0

I'm having some issue with converting a list (string) to DateTime format, the data come like this above:

df[arrive time] = 
28/11/2022 08:01
28/11/2022 08:01
28/11/2022 08:03
28/11/2022 08:15
28/11/2022 08:16
28/11/2022 08:17
28/11/2022 08:20
28/11/2022 08:20
28/11/2022 08:21
28/11/2022 08:22
28/11/2022 08:23
28/11/2022 08:30
28/11/2022 08:30

I try this way:

for i in range(len(df['Arrive time'])):
     datas = df['Arrive time'][i]
     datas = pd.to_datetime(datas, format ='%d/%m/%y %H:%M:%S')

at the csv file come with seconds, but here, the DF didn't bring the complete data, I remove seconds but still bringing me errors.

the error:

ValueError: time data '28/11/2022 08:01' does not match format '%d/%m/%y %H:%M:%S' (match)

I tryed other methods but I didn't found one that works. If someone know where are the answer for this problem, I'll be glad if notice me here.

0 Answers0