Given the following data frame and necessary wrangling:
import pandas as pd
df=pd.DataFrame({'A':['a','b','c'],
'dates':['2015-08-31 00:00:00','2015-08-24 00:00:00','2015-08-25 00:00:00']})
df.dates=df.dates.astype(str)
df['dates'] = pd.to_datetime(df.dates.str.split(',s*').str[0])
set(df['dates'])
I end up with:
{Timestamp('2015-08-24 00:00:00'),
Timestamp('2015-08-25 00:00:00'),
Timestamp('2015-08-31 00:00:00')}
I need to convert the time stamps back to datetime (really, just date) format.
I've tried this based on the answer to this post:
df['dates'].to_pydatetime()
But that returns:
AttributeError: 'Series' object has no attribute 'to_pydatetime'
In my real data, the data type is: <M8[ns]
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…