Standardizing data formats
Great work! You've now removed any row that contained duplicate values and values where the transaction date did not exist. The next step will be to standardize the date format for transactions. Currently, there are dates in several different formats that will not be easy to work with for analysis.
You'll be using Python to carry out these data transformation tasks. Use CleanerBot3000 to understand how to standardize these date formats and apply a Pandas function to format the data in a ‘YYYY-MM-DD’ format.
What is the correct Pandas function to standardize the date format?
This exercise is part of the course
Cleaning Data with Generative AI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
