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

Exercise

Validating age

Now that you found some inconsistencies in the total amounts, you're suspicious that there may also be inconsistencies in the acct_agecolumn, and you want to see if these inconsistencies are related. Using the skills you learned from the video exercise, you'll need to validate the age of each account and see if rows with inconsistent acct_ages are the same ones that had inconsistent totals

dplyr and lubridate are loaded, and accounts is available.

Instructions

100 XP
  • Create a new column called theoretical_age that contains the age of each account based on the date_opened.
  • Find the accounts where the acct_age doesn't match the theoretical_age.