I'm trying to datetime a column of a dataframe. But I skip this mistake, I read the documentation of datetime and I don't understand what the problem is.
datetime.strptime('Oct 22 2019 12:58:45:196AM', '%b %d %Y %H:%M:%S:%f%p')
Asked
Active
Viewed 288 times
0
jezrael
- 822,522
- 95
- 1,334
- 1,252
Iago Sanchez Prieto
- 21
- 2
-
Possible duplicate of [time data does not match format](https://stackoverflow.com/questions/25015711/time-data-does-not-match-format) – Almuntasir Abir Oct 24 '19 at 08:41
-
1It works under python 3.7. What is the python version that you are using? – balderman Oct 24 '19 at 08:41
-
Im using python 3.6.5 – Iago Sanchez Prieto Oct 25 '19 at 08:38
-
If i use: locale.setlocale(locale.LC_ALL, 'en_us') before, works. But if i try to use pd.to_datetime(df1[f], '%b %d %Y %H:%M:%S:%f%p').dt.strftime('%Y-%m-%d') dont work – Iago Sanchez Prieto Oct 25 '19 at 09:01
1 Answers
0
USE this one there is no need to any format
>>> from dateutil import parser
>>> s= '25 April, 2020, 2:50, pm, IST'
>>> parser.parse(s)
>>> datetime.datetime(2020, 4, 25, 14, 50)
Amit Kumar
- 619
- 7
- 10
-
This isn't really solving the problem. We don't know where the input will be coming from and should not change it (in not trivial ways) just like that. – Faboor Apr 28 '20 at 14:55