datetime conversion error in Pandas dataframe

Asked Jun 20 '23 at 05:32

Active Jun 20 '23 at 05:32

Viewed 22 times

I have a pandas dataframe that has a column (Process Created Date) with date in the form of a string. When converting it to datetime format, am getting the below error.

data['Process Created Date']=pd.to_datetime(data['Process Created Date'], format='%Y%m%d')

How can be converted to datetime (eg. 8/12/2017) ?

asked Jun 20 '23 at 05:32

Venkat

The error am getting is : – Venkat Jun 20 '23 at 05:32
ValueError: time data datetime.datetime(2017, 8, 12, 0, 0) does not match format '%Y%m%d' (match) – Venkat Jun 20 '23 at 05:32
IIUC use `data['Process Created Date']=pd.to_datetime(data['Process Created Date')` – jezrael Jun 20 '23 at 05:33
When I run this, getting the below error. – Venkat Jun 20 '23 at 07:41
TypeError: invalid string coercion to datetime – Venkat Jun 20 '23 at 07:41

datetime conversion error in Pandas dataframe

0 Answers0