I am trying to change the format of a UTC timestamp in a csv file but nothing seems to be working. It keeps saying that there is a ValueError does not match format '%m/%d/%Y %I:%M:%S %p' Below there is an example of the CSV column
does not match format '%m/%d/%Y %I:%M:%S %p'
Example of CSV column
df[' UTC Event Timestamp'] = df[' UTC Event Timestamp'].astype(str) string_col = str(df) string_col.strip() datetime.strptime(string_col, '%m/%d/%Y %I:%M:%S %p') datetime.strptime(string_col, '%m/%d/%Y %I:%M:%S %p').strftime('%d/%m/%Y %I:%M:%S %p') print(string_col)
You can use
df['string_col'].apply(lambda row: datetime.strptime(row, '%m/%d/%Y %I:%M:%S %p').strftime('%d/%m/%Y %I:%M:%S %p'))
to convert the column in to datetime format.
1.4m articles
1.4m replys
5 comments
56.9k users