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.

Deze oefening maakt deel uit van de cursus

Scalable Data Processing in R

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

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

Code bewerken en uitvoeren