1. Learn
    2. /
  2. Courses
    3. /
  3. Scalable Data Processing in R

Exercise

Borrower Race and Ethnicity by Year (I)

As a second exercise in creating big tables, suppose you want to see the total count by year, rather than for all years at once. Then you would create a table for each ethnicity for each year.

Instructions

100 XP

The character vector race_cat is available in your workspace.

  • Use the bigtable() function to create a table of the borrower race ("borrower_race") by year ("year").
  • Use the as.data.frame() function to convert the table into a data.frame and assign it to rfdf.
  • Create a new column (Race) holding the race/ethnicity information using the race_cat variable.