LoslegenKostenlos loslegen

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?

Diese Übung ist Teil des Kurses

Cleaning Data with Generative AI

Kurs anzeigen

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten