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

Exercise

Date uniformity

In this chapter, you work at an asset management company and you'll be working with the accounts dataset, which contains information about each customer, the amount in their account, and the date their account was opened. Your boss has asked you to calculate some summary statistics about the average value of each account and whether the age of the account is associated with a higher or lower account value. Before you can do this, you need to make sure that the accounts dataset you've been given doesn't contain any uniformity problems. In this exercise, you'll investigate the date_opened column and clean it up so that all the dates are in the same format.

dplyr and lubridate are loaded and accounts is available.

Instructions 1/3

undefined XP
    1
    2
    3
  • Take a look at the head of accounts to get a sense of the data you're working with.