How to convert working with date time in Pandas?

Question

I have datetime field like 2017-01-15T02:41:38.466Z and would like to convert it to %Y-%m-%d format. How can this be achieved in pandas or python?

I tried this

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

but getting the error

cannot convert the series to <class 'int'>

Welcome to StackOverflow @NitinVarghese. Please refer How do I ask a good question? — Dhaval Simaria
– Dhaval Simaria, Commented Jan 21, 2021 at 8:54
try pd.to_datetime(frame['datetime_ordered'], format='%Y-%m-%d') — Umar.H
– Umar.H, Commented Jan 21, 2021 at 9:05
The following worked 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) — Nitin Varghese
– Nitin Varghese, Commented Jan 21, 2021 at 9:14

Subbu VidyaSekar · Accepted Answer · 2021-01-21 09:47:36Z

2

The following code worked

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)

edited Jan 21, 2021 at 9:47

Subbu VidyaSekar

2,6413 gold badges26 silver badges45 bronze badges

answered Jan 21, 2021 at 9:44

Nitin Varghese

276 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ListenSoftware Louise Ai Agent · Accepted Answer · 2021-01-22 18:16:10Z

0

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'))

answered Jan 22, 2021 at 18:16

ListenSoftware Louise Ai Agent

4,3432 gold badges31 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to convert working with date time in Pandas?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related