GR5206-Homework 2 Solved

Goals: data cleaning, EDA, R graphics, more practice with filtering and vectorized commands.

The data set NYChousing.csv contains property-level data on privately-owned, subsidized rental properties in New York City collected by the Furman Center. The data can be downloaded from Canvas. The dataset contains financial and physical information on the properties including geographic, subsidy, ownership, physical, and financial information.

Perform the following tasks:

Part 1: Loading and Cleaning the Data in R

i.             Load the data into a dataframe called housing.

ii.           How many rows and columns does the dataframe have?

iii.         Run this command, and explain, in words, what this does: apply(is.na(housing), 2, sum).

iv.         Remove the rows of the dataset for which the variable Value is NA.

v.            How many rows did you remove with the previous call? Does this agree with your result from (iii)?

vi.         Create a new variable in the dataset called logValue that is equal to the logarithm of the property’s Value. What are the minimum, median, mean, and maximum values of logValue?

vii.       Create a new variable in the dataset called logUnits that is equal to the logarithm of the number of units in the property. The number of units in each piece of property is stored in the variable UnitCount.

viii.     Finally create a new variable in the dataset called after1950 which equals TRUE if the property was built in or after 1950 and FALSE otherwise. You’ll want to use the YearBuilt variable here. This can be done in a single line of code.

Part 2: EDA

The column Borough contains the Borough of each property and is one of either Bronx, Manhattan, Staten Island, Brooklyn, or Queens.

i.           Plot property logValue against property logUnits. Name the x and y labels of the plot appropriately. logValue should be on the y-axis.

ii.         Make the same plot as above, but now include the argument col = factor(housing$after1950). Describe this plot and the covariation between the two variables. What does the coloring in the plot tell us?

Hint: legend("bottomright", legend = levels(factor(housing$after1950)), fill = unique(factor(housing$after1950))).

iii.      The cor() function calculates the correlation coefficient between two variables. What is the correlation between property logValue and property logUnits in (i) the whole data, (ii) just Manhattan (iii) just Brooklyn (iv) for properties built after 1950 (v) for properties built before 1950?

iv.       Make a single plot showing property logValue against property logUnits for Manhattan and Brooklyn. When creating this plot, clearly distinguish the two boroughs.

v.         Consider the following block of code. Give a single line of R code which gives the same final answer as the block of code. There are a few ways to do this. manhat.props <- c()

for (props in 1:nrow(housing)) {

if (housing$Borough[props] == "Manhattan") {

manhat.props <- c(manhat.props, props) } }

med.value <- c() for (props in manhat.props) {

med.value <- c(med.value, housing$Value[props])

}

med.value <- median(med.value, na.rm = TRUE)

vi.       Make side-by-side box plots comparing property logValue across the five boroughs.

vii.     For five boroughs, what are the median property values? (Use Value here, not logValue.)