Time Data Does Not Match Format
I Get the Following Error: Time Data '07/28/2014 18:54:55.099000' Does Not Match Format '%D/%M/%Y %H: %M: %S. %F' but I Cannot See What Parameter Is Wrong in...
I get the following error:
time data '07/28/2014 18:54:55.099000' does not match format '%d/%m/%Y %H:%M:%S.%f'
But I cannot see what parameter is wrong in %d/%m/%Y %H:%M:%S.%f ?
This is the code I use.
from datetime import datetime
time_value = datetime.strptime(csv_line[0] + '000', '%d/%m/%Y %H:%M:%S.%f')
I have added and removed the 000 but I get the same error.
11 Answers
You have the month and day swapped:
'%m/%d/%Y %H:%M:%S.%f'
28 will never fit in the range for the %m month parameter otherwise.
With %m and %d in the correct order parsing works:
>>> from datetime import datetime
>>> datetime.strptime('07/28/2014 18:54:55.099000', '%m/%d/%Y %H:%M:%S.%f')
datetime.datetime(2014, 7, 28, 18, 54, 55, 99000)
You don't need to add '000'; %f can parse shorter numbers correctly:
>>> datetime.strptime('07/28/2014 18:54:55.099', '%m/%d/%Y %H:%M:%S.%f')
datetime.datetime(2014, 7, 28, 18, 54, 55, 99000)
While the above answer is 100% helpful and correct, I'd like to add the following since only a combination of the above answer and reading through the pandas doc helped me:
Must Read
2-digit / 4-digit year
It is noteworthy, that in order to parse through a 2-digit year, e.g. '90' rather than '1990', a %y is required instead of a %Y.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
