Currency uniformity
Now that your dates are in order, you'll need to correct any unit differences. When you first plot the data, you'll notice that there's a group of very high values, and a group of relatively lower values. The bank has two different offices - one in New York, and one in Tokyo, so you suspect that the accounts managed by the Tokyo office are in Japanese yen instead of U.S. dollars. Luckily, you have a data frame called account_offices
that indicates which office manages each customer's account, so you can use this information to figure out which total
s need to be converted from yen to dollars.
The formula to convert yen to dollars is USD = JPY / 104
.
dplyr
and ggplot2
are loaded and the accounts
and account_offices
data frames are 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.
# Scatter plot of opening date and total amount
accounts %>%
ggplot(aes(x = ___, y = ___)) +
___