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.
This exercise is part of the course
Scalable Data Processing in R
Exercise instructions
- Use the
bigtable()function to make a table of theborrower_income_ratiobyfederal_guarantee. - For each row in
ir_by_fg, divide by the sum of the row.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Tabulate borrower_income_ratio and federal_guarantee
ir_by_fg <- ___(mort, ___)
# Label the columns and rows of the table
dimnames(ir_by_fg) <- list(income_cat, guarantee_cat)
# For each row in ir_by_fg, divide by the sum of the row
for (i in seq_len(nrow(___))) {
ir_by_fg[___, ] = ir_by_fg[___, ] / sum(ir_by_fg[___, ])
}
# Print
ir_by_fg