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

Exercise

Validating totals

In this lesson, you'll continue to work with the accounts data frame, but this time, you have a bit more information about each account. There are three different funds that account holders can store their money in. In this exercise, you'll validate whether the total amount in each account is equal to the sum of the amount in fund_A, fund_B, and fund_C. If there are any accounts that don't match up, you can look into them further to see what went wrong in the bookkeeping that led to inconsistencies.

dplyr is loaded and accounts is available.

Instructions

100 XP
  • Create a new column called theoretical_total that contains the sum of the amounts in each fund.
  • Find the accounts where the total doesn't match the theoretical_total.