How to convert timestamp in datetime.date to pandas dataframe?

Question

I need to combine 2 pandas dataframes together by dates, but they currently have different types of dates. 1 - timestamp (imported from excel), and the other - datetime.date.

Any tips?

I tried pd.to_datetime().date, but it only works on one element (e.g. df.ix[0,0]), it will not allow me to apply to the entire series (e.g., df['mydates']) or to the data frame.

Answer 1

I got some help from a colleague.

This seems to solve the problem above

pd.to_datetime(df['mydates']).apply(lambda x: x.date())

Answer 2

datetime.date... .date Timestamp

pd.to_datetime(df['mydates']).date

Answer 3

, , , (, , / ):

pandas pandas.Timestamp.to_pydatetime " Timestamp datetime Python".

Answer 4

, . , df ts.

df.ts.apply(lambda x: pd.datetime.fromtimestamp(x).date())

, .date() .date() datetime. . ...

df.loc[:, 'ts'] = df.ts.apply(lambda x: pd.datetime.fromtimestamp(x).date())