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.
Cet exercice fait partie du cours
Scalable Data Processing in R
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.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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