I am trying to convert 'Thursday - 6/13/2019' to pd.to_datetime in a pandas dataframe column called 'timestamp".
Here is my attempt to solve the problem:
df['timestamp'] = pd.to_datetime(df['timestamp'], format='%A - %x')
Thanks.
Asked
Active
Viewed 64 times
0
-
Solved it... pd.to_datetime(df['timestamp'].str.split(' - ').str[1]) – Ross Dickinson Jun 24 '22 at 17:59
-
Please provide enough code so others can better understand or reproduce the problem. – Community Jun 24 '22 at 20:57
1 Answers
0
How about %m/%d/%Y instead of %x
pd.to_datetime(df['timestamp'], format='%A - %m/%d/%Y')
Lazyer
- 917
- 1
- 6
- 16
-
Hi, this is the response: ValueError: time data 'Totals' does not match format '%A - %m/%d/%Y' (match) – Ross Dickinson Jun 24 '22 at 05:18
-
How about `pd.to_datetime(df['timestamp'].astype(str), format='%A - %m/%d/%Y')` – Baron Legendre Jun 24 '22 at 05:20
-
-
Same error - ValueError: time data 'Totals' does not match format '%A - %m/%d/%Y' (match) using df['timestamp'] = pd.to_datetime(df['timestamp'].astype(str), format='%A - %m/%d/%Y') – Ross Dickinson Jun 24 '22 at 17:49
-
This works... df['timestamp'] = pd.to_datetime(df['timestamp'].str.split(' - ').str[1]) Thanks for all the help!! – Ross Dickinson Jun 24 '22 at 18:00
-