Extracting features for correlation
In this exercise, you'll work with a version of the salaries dataset containing a new column called "date_of_response".
The dataset has been read in as a pandas DataFrame, with "date_of_response" as a datetime data type.
Your task is to extract datetime attributes from this column and then create a heat map to visualize the correlation coefficients between variables.
Seaborn has been imported for you as sns, pandas as pd, and matplotlib.pyplot as plt.
Deze oefening maakt deel uit van de cursus
Exploratory Data Analysis in Python
Oefeninstructies
- Extract the month from
"date_of_response", storing it as a column called"month". - Create the
"weekday"column, containing the weekday that the participants completed the survey. - Plot a heat map, including the Pearson correlation coefficient scores.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Get the month of the response
salaries["month"] = ____["____"].____.____
# Extract the weekday of the response
salaries["weekday"] = ____
# Create a heatmap
sns.____(____.____(numeric_only=True), annot=____)
plt.show()