For this lab, we will be using the marketing_customer_analysis.csv
file that you can find in the files_for_lab
folder.
Note - For the next labs we will be using the same data file. Please save the code, so that you can re-use it later in the labs following this lab.
- Show the dataframe shape.
- Standardize header names.
- Which columns are numerical?
- Which columns are categorical?
- Check and deal with
NaN
values. - Datetime format- Extract the months from the dataset and store in a separate column. Then filter the data to show only the information for the first quarter , ie Jan Feb and March
- BONUS: Put all the previously mentioned data transformations into a function.