CommencerCommencer gratuitement

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?

Cet exercice fait partie du cours

Cleaning Data with Generative AI

Afficher le cours

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice