Date columns

Currently, the date columns in the marketing DataFrame are being incorrectly read as objects. We need to convert these columns to date columns to be able to use Python and pandas' robust date manipulation and formatting capabilities.

In this exercise, you will practice reading the CSV with proper date columns and create a day of the week column.

Diese Übung ist Teil des Kurses

Analyzing Marketing Campaigns with pandas

Kurs anzeigen

Anleitung zur Übung

Import pandas into the environment with the alias pd.
Read 'marketing.csv' into your environment correctly identifying date columns,'date_served' 'date_subscribed' and 'date_canceled' within your call to read_csv().
Create a day of week column from 'date_subscribed' using dt.dayofweek.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

# Import pandas into the environment
____

# Import marketing.csv with date columns
marketing = ____

# Add a DoW column
marketing['DoW'] = ____

Code bearbeiten und ausführen