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 ejercicio forma parte del curso
Scalable Data Processing in R
Instrucciones del ejercicio
- 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.
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
# 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