1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Efficient Code with pandas

Exercise

Missing value imputation

As the majority of the real world data contain missing entries, replacing these entries with sensible values can increase the insight you can get from our data.

In the restaurant dataset, the "total_bill" column has some missing entries, meaning that you have not recorded how much some tables have paid. Your task in this exercise is to replace the missing entries with the median value of the amount paid, according to whether the entry was recorded on lunch or dinner (time variable).

Instructions 1/2

undefined XP
    1
    2
  • Define the lambda function that fills missing values with the median.