I'm dealing with a large amount of data that has both values and times(in strings).
I am converting the string time values into datetime values with the following code:
time = datetime.datetime.strptime(time, " %H:%M:%S.%f")
The only problem is that some of my data has the format: 24:00:00.004.
So some of the data is actually over 24 hours
Python is giving me this error: ValueError: time data ' 24:00:00:004' does not match format ' %H:%M:%S.%f'
Any ideas on how to deal with this problem
解决方案
The %H parameter can only parse values in the range 0-23. You'll have to manually deal with those specific time stamps:
try:
time = datetime.datetime.strptime(time, " %H:%M:%S.%f")
except ValueError:
time = time.replace(' 24', ' 23')
time = datetime.datetime.strptime(time, " %H:%M:%S.%f")
time += datetime.timedelta(hours=1)