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

Exercise

Who is securing federally guaranteed loans?

Borrower's income is not in the data set. However, annual income divided by the median income of people in the local area is. This is called the Borrower Income Ratio. Let's look at the proportion of federally guaranteed loans for each borrower income category.

Instructions

100 XP
  • Use the bigtable() function to make a table of the borrower_income_ratio by federal_guarantee.
  • For each row in ir_by_fg, divide by the sum of the row.