Tidy Big Tables
As a final exercise of using the "tidyverse" packages in combination with the "bigmemory" suite of packages, you will again use the tidyr
and ggplot2
packages to plot the Borrower Income ratio over time.
This exercise is part of the course
Scalable Data Processing in R
Exercise instructions
- Load the
tidyr
andggplot2
packages. - Use the
pivot_longer()
function to gather the counts by year. - Create a line plot with
Year
on the x-axis andCount
on the y-axis. Color and group byBIR
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the tidyr and ggplot2 packages
library(___)
library(___)
bir_df_wide %>%
# Transform the wide-formatted data.frame into the long format
___(-BIR, names_to = "Year", values_to = "Count") %>%
# Use ggplot to create a line plot
ggplot(aes(x = ___, y = ___, group = BIR, color = BIR)) +
___