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.
This exercise is part of the course
Cleaning Data in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Check out the accounts data frame
___