Скачать или смотреть How to Change Date Format in Pandas and Save to CSV

Learn how to easily change the date format in your Pandas DataFrame and save the updated data back to a CSV file with this step-by-step guide.
---
This video is based on the question https://stackoverflow.com/q/75311525/ asked by the user 'huschhusch' ( https://stackoverflow.com/u/17376163/ ) and on the answer https://stackoverflow.com/a/75311553/ provided by the user 'ifkadeveloper' ( https://stackoverflow.com/u/20860418/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: change dataformat and pass it to the csv dataframes pandas

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Change Date Format in Pandas and Save to CSV

Working with date formats can sometimes be tricky in data analysis. If you've ever found yourself loaded with a DataFrame in Python using Pandas, you might have encountered a situation where your time data is not displayed the way you need. In this guide, we will explore how to adjust the date format of a column in a Pandas DataFrame and then save these changes back to a CSV file.

The Problem: Changing Date Format

Let's start with an example. Imagine you have a DataFrame that you read from a CSV file containing time data like this:

[[See Video to Reveal this Text or Code Snippet]]

You want to change the date format from 2020-03-04 15:46:42 to the more readable 04.03.2020 15:46:42. Although you can successfully format an individual entry using strftime, you may find that when you attempt to print the entire DataFrame, no changes are reflected. Why does that happen, and how can you save the new formatting to the CSV?

Solution: Change Date Format for the Entire Column

To update the entire 'Time' column in your DataFrame, using the apply method is the best approach. Here’s a structured way to accomplish this:

Step 1: Load Your DataFrame

First, ensure that you properly read your CSV data into a DataFrame. Here’s a typical way to do it:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Changing the Date Format

You'll want to change the format of the 'Time' column. Use the apply method along with a lambda function, which applies a formatting function to each element. Here’s how you do it:

[[See Video to Reveal this Text or Code Snippet]]

In this line, strftime('%d.%m.%Y %H:%M:%S') formats the date into your desired pattern.

The apply function ensures that this formatting is applied to each entry in the 'Time' column.

Step 3: Saving the Updated DataFrame to a CSV

After changing the date format, you need to save the updated DataFrame back to a CSV file. This can be achieved using the to_csv method:

[[See Video to Reveal this Text or Code Snippet]]

Summary

By following the steps outlined above, you can successfully modify the date format in your Pandas DataFrame and save these changes back to your CSV file. Here’s a quick recap of the important steps:

Load your DataFrame using pd.read_csv().

Change the date format using apply with strftime().

Save the DataFrame with to_csv() without adding an index.

Now you can handle your date formats with confidence and always ensure your data looks exactly how you want it!

Feel free to reach out if you have any further questions or if you’d like to see more examples on working with Pandas!