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.
Este exercício faz parte do curso
Scalable Data Processing in R
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# 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