Aan de slagGa gratis aan de slag

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?

Deze oefening maakt deel uit van de cursus

Cleaning Data with Generative AI

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen