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

Exercise

Treating missing data

In this exercise, you're working with another version of the accounts data that contains missing values for both the cust_id and acct_amount columns.

You want to figure out how many unique customers the bank has, as well as the average amount held by customers. You know that rows with missing cust_id don't really help you, and that on average, the acct_amount is usually 5 times the amount of inv_amount.

In this exercise, you will drop rows of accounts with missing cust_ids, and impute missing values of inv_amount with some domain knowledge. dplyr and assertive are loaded and accounts is available.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Filter accounts to remove rows with missing cust_ids and save as accounts_clean.