- I have a CSV file containing column called datetime with values like 2022-10-11 15:15:00+05:30 in 5 minutes interval.
- File has 20k rows and I want to remove +05:30 from all datetime column values.
- I have to change all values date format from 2022-10-11 15:15:00+05:30 to 2022-10-11 15:15(DD-MM-YYYY HH:MI).
Can anyone help me in changing all 20k rows date format using Pandas
1.Original CSV file
| datetime |
|---|
09-01-2015 14:30:00+05:30 |
09-01-2015 14:35:00+05:30 |
09-01-2015 14:40:00+05:30 |
09-01-2015 14:45:00+05:30 |
- Final output to generate
| datetime |
|---|
09-01-2015 14:30 |
09-01-2015 14:35 |
09-01-2015 14:40 |
09-01-2015 14:45 |