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

View Course

Exercise instructions

Load the tidyr and ggplot2 packages.
Use the pivot_longer() function to gather the counts by year.
Create a line plot with Year on the x-axis and Count on the y-axis. Color and group by BIR.

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)) + 
    ___

Edit and Run Code