The Borrower Income Ratio

The borrower income ratio is the ratio of the borrower’s (or borrowers’) annual income to the median family income of the area for the reporting year. This is the ratio used to determine whether borrower’s income qualifies for an income-based housing goal.

In the data set mort, missing values are recoded as 9. In this exercise, we replaced the 9's in the "borrower_income_ratio" column with NA, so you can create a table of the borrower income ratios.

Deze oefening maakt deel uit van de cursus

Scalable Data Processing in R

Cursus bekijken

Oefeninstructies

Load the biganalytics and dplyr packages.
Call summary() on mort to check that "borrower_income_ratio" now has NAs.
Using bigtable(), create a table of borrower income ratios for each year.
Use dplyr's mutate() to add a new column BIR.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# Load biganalytics and dplyr packages
___
___

# Call summary on mort
___

bir_df_wide <- ___(mort, c(___, "year")) %>% 
    # Turn it into a data.frame
    as.data.frame() %>% 
    # Create a new column called BIR with the corresponding table categories
    ___(BIR = c(">=0,<=50%", ">50, <=80%", ">80%"))

bir_df_wide

Code bewerken en uitvoeren