1. Learn
  2. /
  3. Courses
  4. /
  5. Winning a Kaggle Competition in Python

Exercise

Impute missing data

You've found that "price" and "building_id" columns have missing values in the Rental Listing Inquiries dataset. So, before passing the data to the models you need to impute these values.

Numerical feature "price" will be encoded with a mean value of non-missing prices.

Imputing categorical feature "building_id" with the most frequent category is a bad idea, because it would mean that all the apartments with a missing "building_id" are located in the most popular building. The better idea is to impute it with a new category.

The DataFrame rental_listings with competition data is read for you.

Instructions 1/2

undefined XP
  • 1
    • Create a SimpleImputer object with "mean" strategy.
    • Impute missing prices with the mean value.
  • 2
    • Create an imputer with "constant" strategy. Use "MISSING" as fill_value.
    • Impute missing buildings with a constant value.