1. Learn
    2. /
  2. Courses
    3. /
  3. Cleaning Data in Python

Exercise

Missing investors

Dealing with missing data is one of the most common tasks in data science. There are a variety of types of missingness, as well as a variety of types of solutions to missing data.

You just received a new version of the banking DataFrame containing data on the amount held and invested for new and existing customers. However, there are rows with missing inv_amount values.

You know for a fact that most customers below 25 do not have investment accounts yet, and suspect it could be driving the missingness. The pandas, missingno and matplotlib.pyplot packages have been imported as pd, msno and plt respectively. The banking DataFrame is in your environment.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Print the number of missing values by column in the banking DataFrame.
  • Plot and show the missingness matrix of banking with the msno.matrix() function.