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?
Questo esercizio fa parte del corso
Cleaning Data with Generative AI
Esercizio pratico interattivo
Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi
Inizia esercizio