Importing DateTime data
You'll now work with the entire divorce dataset! The data describes Mexican marriages dissolved between 2000 and 2015. It contains marriage and divorce dates, education level, birthday, income for each partner, and marriage duration, as well as the number of children the couple had at the time of divorce.
The column names and data types are as follows:
divorce_date object
dob_man object
education_man object
income_man float64
dob_woman object
education_woman object
income_woman float64
marriage_date object
marriage_duration float64
num_kids float64
It looks like there is a lot of date information in this data that is not yet a DateTime data type! Your task is to fix that so that you can explore patterns over time.
pandas
has been imported as pd
.
This exercise is part of the course
Exploratory Data Analysis in Python
Exercise instructions
- Import
divorce.csv
, saving as a DataFrame,divorce
; indicate in the import function that thedivorce_date
,dob_man
,dob_woman
, andmarriage_date
columns should be imported as DateTime values.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import divorce.csv, parsing the appropriate columns as dates in the import
divorce = ____
print(divorce.dtypes)