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.
Este ejercicio forma parte del curso
Analyzing Marketing Campaigns with pandas
Instrucciones del ejercicio
- Import
pandas
into the environment with the aliaspd
. - Read
'marketing.csv'
into your environment correctly identifying date columns,'date_served'
'date_subscribed'
and'date_canceled'
within your call toread_csv()
. - Create a day of week column from
'date_subscribed'
usingdt.dayofweek
.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
# Import pandas into the environment
____
# Import marketing.csv with date columns
marketing = ____
# Add a DoW column
marketing['DoW'] = ____