I am attempting to reformat a datetime pattern within CSV files:
Original date format:
DAY/MONTH/YEAR
Desired Outcome:
YEAR/MONTH/DAY
rows = df['clock_now'] contains the following data:
22/05/2022 12:16
22/05/2022 12:20
22/05/2022 12:21
22/05/2022 12:44
22/05/2022 12:47
22/05/2022 12:47
22/05/2022 12:51
This is my full script:
import pandas as pd
import datetime
filials= [
'base.csv',
'max.csv'
]
for filial in filials:
df = pd.read_csv(filial)
rows = df['clock_now']
for row in rows:
change_format = datetime.datetime.strptime(row, '%d/%m/%Y %H:%M')
final_format = change_format.strftime('%Y/%m/%d %H:%M')
df.loc[df['clock_now'] == row, 'clock_now'] = final_format
df.to_csv(filial, index=False)
An error is being returned stating a format issue with one of the values, although there isn't a '2022/05/22 12:47' value present in rows = df['clock_now'].
change_format = datetime.datetime.strptime(row, '%d/%m/%Y %H:%M')
File "C:\Users\Computador\AppData\Local\Programs\Python\Python310\lib\_strptime.py", line 568, in _strptime_datetime
tt, fraction, gmtoff_fraction = _strptime(data_string, format)
File "C:\Users\Computador\AppData\Local\Programs\Python\Python310\lib\_strptime.py", line 349, in _strptime
raise ValueError("time data %r does not match format %r" %
ValueError: time data '2022/05/22 12:47' does not match format '%d/%m/%Y %H:%M'
What could be causing this issue?