如何转换工作与日期时间在熊猫?

Question

我有日期时间字段，如2017-01-15T02:41:38.466Z，并希望将其转换为%Y-%m-%d格式。如何在熊猫或蟒蛇身上实现这一点?

I tried this

frame['datetime_ordered'] = pd.datetime(frame['datetime_ordered'], format='%Y-%m-%d')

但是得到错误

cannot convert the series to <class 'int'>

Answer 1

下面的代码可以运行

d_parser= lambda x: pd.datetime.strptime(x,'%Y-%m-%dT%H:%M:%S.%fZ')
for filename in all_files: 
df = pd.read_csv(filename, index_col=None, header=0,parse_dates['datetime_ordered'],date_parser=d_parser) 
li.append(df) 
frame =pd.concat(li, axis=0, ignore_index=True) 

Answer 2

import datetime
from datetime import datetime
date_str="2017-01-15T02:41:38.466Z"
a_date=pd.to_datetime(date_str)
print("date time value", a_date)
#datetime to string with format
print(a_date.strftime('%Y-%m-%d'))