Final Project
Amit Singh
2023-08-14
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.2 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.2 ✔ tibble 3.2.1
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errorssetwd("C:/Users/StarKid/Desktop/Data_Science/Data_101/final_project/zillow_data")
cities_crosswalk <- read.csv("cities_crosswalk.csv")
city_time_series <- read.csv("City_time_series.csv")
county_time_series <- read.csv("County_time_series.csv")
countycrosswalk_zillow <- read.csv("CountyCrossWalk_Zillow.csv")
datadictionary <- read.csv("DataDictionary.csv")
metro_time_series <-read.csv("Metro_time_series.csv")
neighborhood_time_series <- read.csv("Neighborhood_time_series.csv")
state_time_series <- read.csv("State_time_series.csv")
zip_time_series <- read.csv("Zip_time_series.csv")dim(cities_crosswalk)## [1] 25341 4str(cities_crosswalk)## 'data.frame': 25341 obs. of 4 variables:
## $ Unique_City_ID: chr "oak_grovechristianky" "jarvisburgcurritucknc" "mcminnvilleyamhillor" "union_townshiperiepa" ...
## $ City : chr "Oak Grove" "Jarvisburg" "McMinnville" "Union Township" ...
## $ County : chr "Christian" "Currituck" "Yamhill" "Erie" ...
## $ State : chr "KY" "NC" "OR" "PA" ...dim(city_time_series)## [1] 3762566 81str(city_time_series)## 'data.frame': 3762566 obs. of 81 variables:
## $ Date : chr "1996-04-30" "1996-04-30" "1996-04-30" "1996-04-30" ...
## $ RegionName : chr "abbottstownadamspa" "aberdeenbinghamid" "aberdeenharfordmd" "aberdeenmonroems" ...
## $ InventorySeasonallyAdjusted_AllHomes : int NA NA NA NA NA NA NA NA NA NA ...
## $ InventoryRaw_AllHomes : int NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_1Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_2Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_3Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_4Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_5BedroomOrMore : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_DuplexTriplex : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPricePerSqft_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_1Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_2Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_3Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_4Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_5BedroomOrMore : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_DuplexTriplex : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianListingPrice_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPctOfPriceReduction_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPctOfPriceReduction_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPctOfPriceReduction_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPriceCutDollar_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPriceCutDollar_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianPriceCutDollar_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_1Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_2Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_3Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_4Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_5BedroomOrMore : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_DuplexTriplex : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPricePerSqft_Studio : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_1Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_2Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_3Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_4Bedroom : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_5BedroomOrMore : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_DuplexTriplex : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_MultiFamilyResidence5PlusUnits : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ MedianRentalPrice_Studio : num NA NA NA NA NA NA NA NA NA NA ...
## $ ZHVIPerSqft_AllHomes : int NA 96 76 NA NA 48 NA 77 NA 57 ...
## $ PctOfHomesDecreasingInValues_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfHomesIncreasingInValues_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfHomesSellingForGain_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfHomesSellingForLoss_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductionsSeasAdj_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductionsSeasAdj_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence: num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductions_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductions_CondoCoop : num NA NA NA NA NA NA NA NA NA NA ...
## $ PctOfListingsWithPriceReductions_SingleFamilyResidence : num NA NA NA NA NA NA NA NA NA NA ...
## $ PriceToRentRatio_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ Sale_Counts : num NA NA NA NA NA NA NA NA NA NA ...
## $ Sale_Counts_Seas_Adj : num NA NA NA NA NA NA NA NA NA NA ...
## $ Sale_Prices : num NA NA NA NA NA NA NA NA NA NA ...
## $ ZHVI_1bedroom : int NA NA NA NA NA NA NA NA NA NA ...
## $ ZHVI_2bedroom : int NA NA 76000 NA NA NA NA 93200 NA 57800 ...
## $ ZHVI_3bedroom : int NA NA 111700 NA NA NA 66800 118400 NA 88800 ...
## $ ZHVI_4bedroom : int NA NA 141700 NA 117400 NA 111700 162400 NA 147700 ...
## $ ZHVI_5BedroomOrMore : int NA NA NA NA NA NA NA NA NA 170100 ...
## $ ZHVI_AllHomes : int NA NA 109600 NA NA NA NA 123900 NA 89400 ...
## $ ZHVI_BottomTier : int NA NA 81300 NA NA NA NA 91000 NA NA ...
## $ ZHVI_CondoCoop : int NA NA 137900 NA NA NA NA 87600 NA NA ...
## $ ZHVI_MiddleTier : int NA NA 109600 NA NA NA NA 123900 NA 89400 ...
## $ ZHVI_SingleFamilyResidence : int NA NA 108600 NA NA NA NA 125600 NA 89400 ...
## $ ZHVI_TopTier : int 108700 168400 147900 74500 131100 NA NA 169700 59000 155000 ...
## $ ZRI_AllHomes : int NA NA NA NA NA NA NA NA NA NA ...
## $ ZRI_AllHomesPlusMultifamily : int NA NA NA NA NA NA NA NA NA NA ...
## $ ZriPerSqft_AllHomes : num NA NA NA NA NA NA NA NA NA NA ...
## $ Zri_MultiFamilyResidenceRental : int NA NA NA NA NA NA NA NA NA NA ...
## $ Zri_SingleFamilyResidenceRental : int NA NA NA NA NA NA NA NA NA NA ...glimpse(city_time_series)## Rows: 3,762,566
## Columns: 81
## $ Date <chr> "1996-04…
## $ RegionName <chr> "abbotts…
## $ InventorySeasonallyAdjusted_AllHomes <int> NA, NA, …
## $ InventoryRaw_AllHomes <int> NA, NA, …
## $ MedianListingPricePerSqft_1Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_2Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_3Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_4Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_5BedroomOrMore <dbl> NA, NA, …
## $ MedianListingPricePerSqft_AllHomes <dbl> NA, NA, …
## $ MedianListingPricePerSqft_CondoCoop <dbl> NA, NA, …
## $ MedianListingPricePerSqft_DuplexTriplex <dbl> NA, NA, …
## $ MedianListingPricePerSqft_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianListingPrice_1Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_2Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_3Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_4Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_5BedroomOrMore <dbl> NA, NA, …
## $ MedianListingPrice_AllHomes <dbl> NA, NA, …
## $ MedianListingPrice_CondoCoop <dbl> NA, NA, …
## $ MedianListingPrice_DuplexTriplex <dbl> NA, NA, …
## $ MedianListingPrice_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_AllHomes <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_CondoCoop <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianPriceCutDollar_AllHomes <dbl> NA, NA, …
## $ MedianPriceCutDollar_CondoCoop <dbl> NA, NA, …
## $ MedianPriceCutDollar_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_1Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_2Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_3Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_4Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_5BedroomOrMore <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_AllHomes <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_CondoCoop <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_DuplexTriplex <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_Studio <dbl> NA, NA, …
## $ MedianRentalPrice_1Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_2Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_3Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_4Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_5BedroomOrMore <dbl> NA, NA, …
## $ MedianRentalPrice_AllHomes <dbl> NA, NA, …
## $ MedianRentalPrice_CondoCoop <dbl> NA, NA, …
## $ MedianRentalPrice_DuplexTriplex <dbl> NA, NA, …
## $ MedianRentalPrice_MultiFamilyResidence5PlusUnits <dbl> NA, NA, …
## $ MedianRentalPrice_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPrice_Studio <dbl> NA, NA, …
## $ ZHVIPerSqft_AllHomes <int> NA, 96, …
## $ PctOfHomesDecreasingInValues_AllHomes <dbl> NA, NA, …
## $ PctOfHomesIncreasingInValues_AllHomes <dbl> NA, NA, …
## $ PctOfHomesSellingForGain_AllHomes <dbl> NA, NA, …
## $ PctOfHomesSellingForLoss_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_CondoCoop <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_CondoCoop <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_SingleFamilyResidence <dbl> NA, NA, …
## $ PriceToRentRatio_AllHomes <dbl> NA, NA, …
## $ Sale_Counts <dbl> NA, NA, …
## $ Sale_Counts_Seas_Adj <dbl> NA, NA, …
## $ Sale_Prices <dbl> NA, NA, …
## $ ZHVI_1bedroom <int> NA, NA, …
## $ ZHVI_2bedroom <int> NA, NA, …
## $ ZHVI_3bedroom <int> NA, NA, …
## $ ZHVI_4bedroom <int> NA, NA, …
## $ ZHVI_5BedroomOrMore <int> NA, NA, …
## $ ZHVI_AllHomes <int> NA, NA, …
## $ ZHVI_BottomTier <int> NA, NA, …
## $ ZHVI_CondoCoop <int> NA, NA, …
## $ ZHVI_MiddleTier <int> NA, NA, …
## $ ZHVI_SingleFamilyResidence <int> NA, NA, …
## $ ZHVI_TopTier <int> 108700, …
## $ ZRI_AllHomes <int> NA, NA, …
## $ ZRI_AllHomesPlusMultifamily <int> NA, NA, …
## $ ZriPerSqft_AllHomes <dbl> NA, NA, …
## $ Zri_MultiFamilyResidenceRental <int> NA, NA, …
## $ Zri_SingleFamilyResidenceRental <int> NA, NA, …head(city_time_series)## Date RegionName InventorySeasonallyAdjusted_AllHomes
## 1 1996-04-30 abbottstownadamspa NA
## 2 1996-04-30 aberdeenbinghamid NA
## 3 1996-04-30 aberdeenharfordmd NA
## 4 1996-04-30 aberdeenmonroems NA
## 5 1996-04-30 aberdeenmoorenc NA
## 6 1996-04-30 abernathyhaletx NA
## InventoryRaw_AllHomes MedianListingPricePerSqft_1Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPricePerSqft_2Bedroom MedianListingPricePerSqft_3Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPricePerSqft_4Bedroom MedianListingPricePerSqft_5BedroomOrMore
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPricePerSqft_AllHomes MedianListingPricePerSqft_CondoCoop
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPricePerSqft_DuplexTriplex
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## MedianListingPricePerSqft_SingleFamilyResidence MedianListingPrice_1Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPrice_2Bedroom MedianListingPrice_3Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPrice_4Bedroom MedianListingPrice_5BedroomOrMore
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPrice_AllHomes MedianListingPrice_CondoCoop
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianListingPrice_DuplexTriplex MedianListingPrice_SingleFamilyResidence
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianPctOfPriceReduction_AllHomes MedianPctOfPriceReduction_CondoCoop
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianPctOfPriceReduction_SingleFamilyResidence MedianPriceCutDollar_AllHomes
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianPriceCutDollar_CondoCoop MedianPriceCutDollar_SingleFamilyResidence
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPricePerSqft_1Bedroom MedianRentalPricePerSqft_2Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPricePerSqft_3Bedroom MedianRentalPricePerSqft_4Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPricePerSqft_5BedroomOrMore MedianRentalPricePerSqft_AllHomes
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPricePerSqft_CondoCoop MedianRentalPricePerSqft_DuplexTriplex
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## MedianRentalPricePerSqft_SingleFamilyResidence
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## MedianRentalPricePerSqft_Studio MedianRentalPrice_1Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPrice_2Bedroom MedianRentalPrice_3Bedroom
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPrice_4Bedroom MedianRentalPrice_5BedroomOrMore
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPrice_AllHomes MedianRentalPrice_CondoCoop
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## MedianRentalPrice_DuplexTriplex
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## MedianRentalPrice_MultiFamilyResidence5PlusUnits
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## MedianRentalPrice_SingleFamilyResidence MedianRentalPrice_Studio
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## ZHVIPerSqft_AllHomes PctOfHomesDecreasingInValues_AllHomes
## 1 NA NA
## 2 96 NA
## 3 76 NA
## 4 NA NA
## 5 NA NA
## 6 48 NA
## PctOfHomesIncreasingInValues_AllHomes PctOfHomesSellingForGain_AllHomes
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## PctOfHomesSellingForLoss_AllHomes
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductionsSeasAdj_AllHomes
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductionsSeasAdj_CondoCoop
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductions_AllHomes
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductions_CondoCoop
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PctOfListingsWithPriceReductions_SingleFamilyResidence
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## PriceToRentRatio_AllHomes Sale_Counts Sale_Counts_Seas_Adj Sale_Prices
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## ZHVI_1bedroom ZHVI_2bedroom ZHVI_3bedroom ZHVI_4bedroom ZHVI_5BedroomOrMore
## 1 NA NA NA NA NA
## 2 NA NA NA NA NA
## 3 NA 76000 111700 141700 NA
## 4 NA NA NA NA NA
## 5 NA NA NA 117400 NA
## 6 NA NA NA NA NA
## ZHVI_AllHomes ZHVI_BottomTier ZHVI_CondoCoop ZHVI_MiddleTier
## 1 NA NA NA NA
## 2 NA NA NA NA
## 3 109600 81300 137900 109600
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## ZHVI_SingleFamilyResidence ZHVI_TopTier ZRI_AllHomes
## 1 NA 108700 NA
## 2 NA 168400 NA
## 3 108600 147900 NA
## 4 NA 74500 NA
## 5 NA 131100 NA
## 6 NA NA NA
## ZRI_AllHomesPlusMultifamily ZriPerSqft_AllHomes
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
## Zri_MultiFamilyResidenceRental Zri_SingleFamilyResidenceRental
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NAtail(city_time_series)## Date RegionName InventorySeasonallyAdjusted_AllHomes
## 3762561 2017-12-31 zionvillewatauganc NA
## 3762562 2017-12-31 zirconiahendersonnc 26
## 3762563 2017-12-31 zolfo_springshardeefl NA
## 3762564 2017-12-31 zumbro_fallswabashamn NA
## 3762565 2017-12-31 zumbrotagoodhuemn 15
## 3762566 2017-12-31 zuniisle_of_wightva NA
## InventoryRaw_AllHomes MedianListingPricePerSqft_1Bedroom
## 3762561 NA NA
## 3762562 25 NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 11 NA
## 3762566 NA NA
## MedianListingPricePerSqft_2Bedroom MedianListingPricePerSqft_3Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPricePerSqft_4Bedroom
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianListingPricePerSqft_5BedroomOrMore
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianListingPricePerSqft_AllHomes MedianListingPricePerSqft_CondoCoop
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPricePerSqft_DuplexTriplex
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianListingPricePerSqft_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianListingPrice_1Bedroom MedianListingPrice_2Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPrice_3Bedroom MedianListingPrice_4Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPrice_5BedroomOrMore MedianListingPrice_AllHomes
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPrice_CondoCoop MedianListingPrice_DuplexTriplex
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianListingPrice_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianPctOfPriceReduction_AllHomes MedianPctOfPriceReduction_CondoCoop
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianPctOfPriceReduction_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianPriceCutDollar_AllHomes MedianPriceCutDollar_CondoCoop
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianPriceCutDollar_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPricePerSqft_1Bedroom MedianRentalPricePerSqft_2Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPricePerSqft_3Bedroom MedianRentalPricePerSqft_4Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPricePerSqft_5BedroomOrMore
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPricePerSqft_AllHomes MedianRentalPricePerSqft_CondoCoop
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPricePerSqft_DuplexTriplex
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPricePerSqft_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPricePerSqft_Studio MedianRentalPrice_1Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPrice_2Bedroom MedianRentalPrice_3Bedroom
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPrice_4Bedroom MedianRentalPrice_5BedroomOrMore
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPrice_AllHomes MedianRentalPrice_CondoCoop
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## MedianRentalPrice_DuplexTriplex
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPrice_MultiFamilyResidence5PlusUnits
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## MedianRentalPrice_SingleFamilyResidence MedianRentalPrice_Studio
## 3762561 NA NA
## 3762562 NA NA
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA NA
## 3762566 NA NA
## ZHVIPerSqft_AllHomes PctOfHomesDecreasingInValues_AllHomes
## 3762561 129 13.36
## 3762562 150 21.93
## 3762563 61 47.97
## 3762564 133 NA
## 3762565 142 31.03
## 3762566 121 29.12
## PctOfHomesIncreasingInValues_AllHomes PctOfHomesSellingForGain_AllHomes
## 3762561 81.56 NA
## 3762562 73.13 NA
## 3762563 45.99 NA
## 3762564 NA NA
## 3762565 54.91 NA
## 3762566 61.14 NA
## PctOfHomesSellingForLoss_AllHomes
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductionsSeasAdj_AllHomes
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductionsSeasAdj_CondoCoop
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductions_AllHomes
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductions_CondoCoop
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PctOfListingsWithPriceReductions_SingleFamilyResidence
## 3762561 NA
## 3762562 NA
## 3762563 NA
## 3762564 NA
## 3762565 NA
## 3762566 NA
## PriceToRentRatio_AllHomes Sale_Counts Sale_Counts_Seas_Adj Sale_Prices
## 3762561 12.54 NA NA NA
## 3762562 14.70 NA NA NA
## 3762563 4.92 NA NA NA
## 3762564 14.85 NA NA NA
## 3762565 11.33 NA NA NA
## 3762566 13.42 NA NA NA
## ZHVI_1bedroom ZHVI_2bedroom ZHVI_3bedroom ZHVI_4bedroom
## 3762561 NA 158100 196900 NA
## 3762562 NA 189600 229100 NA
## 3762563 NA NA NA NA
## 3762564 NA NA 294400 NA
## 3762565 NA NA 161400 NA
## 3762566 NA 129700 222300 286700
## ZHVI_5BedroomOrMore ZHVI_AllHomes ZHVI_BottomTier ZHVI_CondoCoop
## 3762561 NA 189200 NA NA
## 3762562 NA 237500 149200 NA
## 3762563 NA 67600 NA NA
## 3762564 NA 277000 157500 NA
## 3762565 NA 183700 136700 NA
## 3762566 NA 216400 123700 NA
## ZHVI_MiddleTier ZHVI_SingleFamilyResidence ZHVI_TopTier ZRI_AllHomes
## 3762561 189200 189800 281100 1242
## 3762562 237500 237600 433800 1340
## 3762563 67600 79000 118600 NA
## 3762564 277000 277000 NA NA
## 3762565 183700 183700 261300 1340
## 3762566 216400 216400 301500 1305
## ZRI_AllHomesPlusMultifamily ZriPerSqft_AllHomes
## 3762561 1236 0.846
## 3762562 1335 0.866
## 3762563 NA NA
## 3762564 NA NA
## 3762565 1337 1.084
## 3762566 1303 0.800
## Zri_MultiFamilyResidenceRental Zri_SingleFamilyResidenceRental
## 3762561 NA 1237
## 3762562 NA 1336
## 3762563 NA NA
## 3762564 NA NA
## 3762565 NA 1338
## 3762566 NA 1303#city_time_series$RegionNamedim(state_time_series)## [1] 13212 82#str(state_time_series)
glimpse(state_time_series)## Rows: 13,212
## Columns: 82
## $ Date <chr> "1996-04…
## $ RegionName <chr> "Alabama…
## $ DaysOnZillow_AllHomes <dbl> NA, NA, …
## $ InventorySeasonallyAdjusted_AllHomes <int> NA, NA, …
## $ InventoryRaw_AllHomes <int> NA, NA, …
## $ MedianListingPricePerSqft_1Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_2Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_3Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_4Bedroom <dbl> NA, NA, …
## $ MedianListingPricePerSqft_5BedroomOrMore <dbl> NA, NA, …
## $ MedianListingPricePerSqft_AllHomes <dbl> NA, NA, …
## $ MedianListingPricePerSqft_CondoCoop <dbl> NA, NA, …
## $ MedianListingPricePerSqft_DuplexTriplex <dbl> NA, NA, …
## $ MedianListingPricePerSqft_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianListingPrice_1Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_2Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_3Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_4Bedroom <dbl> NA, NA, …
## $ MedianListingPrice_5BedroomOrMore <dbl> NA, NA, …
## $ MedianListingPrice_AllHomes <dbl> NA, NA, …
## $ MedianListingPrice_CondoCoop <dbl> NA, NA, …
## $ MedianListingPrice_DuplexTriplex <dbl> NA, NA, …
## $ MedianListingPrice_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_AllHomes <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_CondoCoop <dbl> NA, NA, …
## $ MedianPctOfPriceReduction_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianPriceCutDollar_AllHomes <dbl> NA, NA, …
## $ MedianPriceCutDollar_CondoCoop <dbl> NA, NA, …
## $ MedianPriceCutDollar_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_1Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_2Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_3Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_4Bedroom <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_5BedroomOrMore <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_AllHomes <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_CondoCoop <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_DuplexTriplex <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPricePerSqft_Studio <dbl> NA, NA, …
## $ MedianRentalPrice_1Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_2Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_3Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_4Bedroom <dbl> NA, NA, …
## $ MedianRentalPrice_5BedroomOrMore <dbl> NA, NA, …
## $ MedianRentalPrice_AllHomes <dbl> NA, NA, …
## $ MedianRentalPrice_CondoCoop <dbl> NA, NA, …
## $ MedianRentalPrice_DuplexTriplex <dbl> NA, NA, …
## $ MedianRentalPrice_MultiFamilyResidence5PlusUnits <dbl> NA, NA, …
## $ MedianRentalPrice_SingleFamilyResidence <dbl> NA, NA, …
## $ MedianRentalPrice_Studio <dbl> NA, NA, …
## $ ZHVIPerSqft_AllHomes <int> 50, 62, …
## $ PctOfHomesDecreasingInValues_AllHomes <dbl> NA, NA, …
## $ PctOfHomesIncreasingInValues_AllHomes <dbl> NA, NA, …
## $ PctOfHomesSellingForGain_AllHomes <dbl> NA, NA, …
## $ PctOfHomesSellingForLoss_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_CondoCoop <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_AllHomes <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_CondoCoop <dbl> NA, NA, …
## $ PctOfListingsWithPriceReductions_SingleFamilyResidence <dbl> NA, NA, …
## $ PriceToRentRatio_AllHomes <dbl> NA, NA, …
## $ Sale_Counts <dbl> NA, NA, …
## $ Sale_Counts_Seas_Adj <dbl> NA, NA, …
## $ Sale_Prices <dbl> NA, NA, …
## $ ZHVI_1bedroom <int> 61500, 5…
## $ ZHVI_2bedroom <int> 48900, 8…
## $ ZHVI_3bedroom <int> 78200, 9…
## $ ZHVI_4bedroom <int> 146500, …
## $ ZHVI_5BedroomOrMore <int> 206300, …
## $ ZHVI_AllHomes <int> 79500, 1…
## $ ZHVI_BottomTier <int> 45600, 6…
## $ ZHVI_CondoCoop <int> 99500, 7…
## $ ZHVI_MiddleTier <int> 79500, 1…
## $ ZHVI_SingleFamilyResidence <int> 79000, 1…
## $ ZHVI_TopTier <int> 140200, …
## $ ZRI_AllHomes <int> NA, NA, …
## $ ZRI_AllHomesPlusMultifamily <int> NA, NA, …
## $ ZriPerSqft_AllHomes <dbl> NA, NA, …
## $ Zri_MultiFamilyResidenceRental <int> NA, NA, …
## $ Zri_SingleFamilyResidenceRental <int> NA, NA, …summary(state_time_series)## Date RegionName DaysOnZillow_AllHomes
## Length:13212 Length:13212 Min. : 49.25
## Class :character Class :character 1st Qu.: 90.25
## Mode :character Mode :character Median :108.50
## Mean :110.12
## 3rd Qu.:126.75
## Max. :251.62
## NA's :8367
## InventorySeasonallyAdjusted_AllHomes InventoryRaw_AllHomes
## Min. : 972 Min. : 911
## 1st Qu.: 9828 1st Qu.: 9756
## Median : 21713 Median : 21289
## Mean : 33293 Mean : 33299
## 3rd Qu.: 47453 3rd Qu.: 46891
## Max. :260687 Max. :268055
## NA's :8316 NA's :8316
## MedianListingPricePerSqft_1Bedroom MedianListingPricePerSqft_2Bedroom
## Min. : 57.14 Min. : 60.00
## 1st Qu.:125.69 1st Qu.: 92.16
## Median :162.75 Median :121.30
## Mean :182.47 Mean :135.49
## 3rd Qu.:202.63 3rd Qu.:152.24
## Max. :627.55 Max. :550.64
## NA's :9626 NA's :8678
## MedianListingPricePerSqft_3Bedroom MedianListingPricePerSqft_4Bedroom
## Min. : 56.48 Min. : 61.8
## 1st Qu.: 93.28 1st Qu.: 99.6
## Median :116.63 Median :119.8
## Mean :129.45 Mean :133.5
## 3rd Qu.:143.19 3rd Qu.:144.8
## Max. :460.46 Max. :480.8
## NA's :8605 NA's :8535
## MedianListingPricePerSqft_5BedroomOrMore MedianListingPricePerSqft_AllHomes
## Min. : 63.78 Min. : 62.14
## 1st Qu.: 99.08 1st Qu.: 96.01
## Median :119.75 Median :120.58
## Mean :135.67 Mean :136.66
## 3rd Qu.:149.35 3rd Qu.:153.44
## Max. :617.96 Max. :520.72
## NA's :8643 NA's :8538
## MedianListingPricePerSqft_CondoCoop MedianListingPricePerSqft_DuplexTriplex
## Min. : 61.92 Min. : 32.14
## 1st Qu.: 113.08 1st Qu.: 60.89
## Median : 141.00 Median : 81.21
## Mean : 163.55 Mean : 97.09
## 3rd Qu.: 177.07 3rd Qu.:113.52
## Max. :1000.00 Max. :446.43
## NA's :9063 NA's :9248
## MedianListingPricePerSqft_SingleFamilyResidence MedianListingPrice_1Bedroom
## Min. : 63.27 Min. : 49900
## 1st Qu.: 95.55 1st Qu.: 99000
## Median :120.09 Median :130000
## Mean :133.37 Mean :147083
## 3rd Qu.:149.84 3rd Qu.:169900
## Max. :475.36 Max. :399000
## NA's :8573 NA's :10205
## MedianListingPrice_2Bedroom MedianListingPrice_3Bedroom
## Min. : 57000 Min. :109900
## 1st Qu.:109500 1st Qu.:149000
## Median :147000 Median :189900
## Mean :158873 Mean :209226
## 3rd Qu.:179900 3rd Qu.:240000
## Max. :599000 Max. :687000
## NA's :8839 NA's :8842
## MedianListingPrice_4Bedroom MedianListingPrice_5BedroomOrMore
## Min. :169000 Min. : 159900
## 1st Qu.:238745 1st Qu.: 310000
## Median :283020 Median : 369700
## Mean :310850 Mean : 416375
## 3rd Qu.:339900 3rd Qu.: 452173
## Max. :950000 Max. :1847500
## NA's :8876 NA's :8989
## MedianListingPrice_AllHomes MedianListingPrice_CondoCoop
## Min. :112944 Min. : 82500
## 1st Qu.:159900 1st Qu.:152363
## Median :209000 Median :184900
## Mean :223379 Mean :202333
## 3rd Qu.:259900 3rd Qu.:228000
## Max. :610000 Max. :754500
## NA's :8966 NA's :9402
## MedianListingPrice_DuplexTriplex MedianListingPrice_SingleFamilyResidence
## Min. : 64900 Min. :112900
## 1st Qu.:129900 1st Qu.:159900
## Median :178900 Median :209900
## Mean :207475 Mean :228170
## 3rd Qu.:245000 3rd Qu.:265000
## Max. :939000 Max. :725000
## NA's :9323 NA's :9082
## MedianPctOfPriceReduction_AllHomes MedianPctOfPriceReduction_CondoCoop
## Min. :1.744 Min. : 1.676
## 1st Qu.:3.239 1st Qu.: 3.261
## Median :3.718 Median : 3.807
## Mean :3.848 Mean : 4.015
## 3rd Qu.:4.350 3rd Qu.: 4.561
## Max. :8.340 Max. :10.000
## NA's :8724 NA's :9340
## MedianPctOfPriceReduction_SingleFamilyResidence MedianPriceCutDollar_AllHomes
## Min. :1.716 Min. : 5000
## 1st Qu.:3.233 1st Qu.: 5100
## Median :3.737 Median : 7500
## Mean :3.847 Mean : 8034
## 3rd Qu.:4.349 3rd Qu.:10000
## Max. :8.347 Max. :24000
## NA's :8724 NA's :8724
## MedianPriceCutDollar_CondoCoop MedianPriceCutDollar_SingleFamilyResidence
## Min. : 2050 Min. : 5000
## 1st Qu.: 5000 1st Qu.: 5300
## Median : 6800 Median : 7900
## Mean : 7453 Mean : 8245
## 3rd Qu.:10000 3rd Qu.:10000
## Max. :27754 Max. :26000
## NA's :9340 NA's :8724
## MedianRentalPricePerSqft_1Bedroom MedianRentalPricePerSqft_2Bedroom
## Min. :0.716 Min. :0.521
## 1st Qu.:0.992 1st Qu.:0.806
## Median :1.211 Median :0.952
## Mean :1.397 Mean :1.106
## 3rd Qu.:1.606 3rd Qu.:1.262
## Max. :3.369 Max. :3.113
## NA's :9588 NA's :9065
## MedianRentalPricePerSqft_3Bedroom MedianRentalPricePerSqft_4Bedroom
## Min. :0.533 Min. :0.489
## 1st Qu.:0.751 1st Qu.:0.678
## Median :0.863 Median :0.781
## Mean :0.968 Mean :0.847
## 3rd Qu.:1.073 3rd Qu.:0.938
## Max. :2.453 Max. :2.134
## NA's :8985 NA's :9808
## MedianRentalPricePerSqft_5BedroomOrMore MedianRentalPricePerSqft_AllHomes
## Min. :0.363 Min. :0.580
## 1st Qu.:0.629 1st Qu.:0.760
## Median :0.745 Median :0.880
## Mean :0.763 Mean :1.015
## 3rd Qu.:0.891 3rd Qu.:1.125
## Max. :1.267 Max. :3.147
## NA's :11752 NA's :8864
## MedianRentalPricePerSqft_CondoCoop MedianRentalPricePerSqft_DuplexTriplex
## Min. :0.637 Min. :0.499
## 1st Qu.:0.896 1st Qu.:0.740
## Median :1.075 Median :0.871
## Mean :1.297 Mean :1.066
## 3rd Qu.:1.414 3rd Qu.:1.119
## Max. :4.824 Max. :3.862
## NA's :10004 NA's :10293
## MedianRentalPricePerSqft_MultiFamilyResidence5PlusUnits
## Min. :0.585
## 1st Qu.:0.837
## Median :1.000
## Mean :1.170
## 3rd Qu.:1.300
## Max. :3.380
## NA's :9189
## MedianRentalPricePerSqft_SingleFamilyResidence MedianRentalPricePerSqft_Studio
## Min. :0.581 Min. :0.565
## 1st Qu.:0.749 1st Qu.:0.739
## Median :0.861 Median :0.853
## Mean :0.939 Mean :1.176
## 3rd Qu.:1.031 3rd Qu.:1.260
## Max. :2.440 Max. :3.982
## NA's :8923 NA's :10875
## MedianRentalPrice_1Bedroom MedianRentalPrice_2Bedroom
## Min. : 495.0 Min. : 575
## 1st Qu.: 650.0 1st Qu.: 775
## Median : 860.0 Median : 925
## Mean : 978.6 Mean :1098
## 3rd Qu.:1195.0 3rd Qu.:1279
## Max. :2690.0 Max. :3215
## NA's :9686 NA's :9168
## MedianRentalPrice_3Bedroom MedianRentalPrice_4Bedroom
## Min. : 750 Min. : 950
## 1st Qu.:1050 1st Qu.:1395
## Median :1200 Median :1595
## Mean :1357 Mean :1722
## 3rd Qu.:1515 3rd Qu.:1950
## Max. :3550 Max. :3850
## NA's :9075 NA's :9856
## MedianRentalPrice_5BedroomOrMore MedianRentalPrice_AllHomes
## Min. : 795 Min. : 750
## 1st Qu.:1750 1st Qu.:1050
## Median :1995 Median :1200
## Mean :2139 Mean :1362
## 3rd Qu.:2495 3rd Qu.:1590
## Max. :4500 Max. :3600
## NA's :11994 NA's :9060
## MedianRentalPrice_CondoCoop MedianRentalPrice_DuplexTriplex
## Min. : 697.5 Min. : 500.0
## 1st Qu.:1050.0 1st Qu.: 685.0
## Median :1295.0 Median : 800.0
## Mean :1410.2 Mean : 963.6
## 3rd Qu.:1595.0 3rd Qu.:1100.0
## Max. :3200.0 Max. :2895.0
## NA's :10437 NA's :10068
## MedianRentalPrice_MultiFamilyResidence5PlusUnits
## Min. : 550
## 1st Qu.: 750
## Median : 950
## Mean :1091
## 3rd Qu.:1296
## Max. :2895
## NA's :9029
## MedianRentalPrice_SingleFamilyResidence MedianRentalPrice_Studio
## Min. : 750 Min. : 490
## 1st Qu.:1050 1st Qu.: 975
## Median :1205 Median :1150
## Mean :1363 Mean :1221
## 3rd Qu.:1582 3rd Qu.:1400
## Max. :3400 Max. :2500
## NA's :9120 NA's :10211
## ZHVIPerSqft_AllHomes PctOfHomesDecreasingInValues_AllHomes
## Min. : 35.0 Min. : 0.18
## 1st Qu.: 77.0 1st Qu.:16.98
## Median : 98.0 Median :27.45
## Mean :116.4 Mean :33.29
## 3rd Qu.:141.0 3rd Qu.:45.08
## Max. :499.0 Max. :99.38
## NA's :620 NA's :4292
## PctOfHomesIncreasingInValues_AllHomes PctOfHomesSellingForGain_AllHomes
## Min. : 0.47 Min. : 50.99
## 1st Qu.:44.22 1st Qu.: 79.08
## Median :63.54 Median : 89.97
## Mean :59.03 Mean : 85.88
## 3rd Qu.:76.30 3rd Qu.: 95.64
## Max. :99.76 Max. :100.00
## NA's :4292 NA's :12609
## PctOfHomesSellingForLoss_AllHomes
## Min. : 0.000
## 1st Qu.: 4.365
## Median :10.030
## Mean :14.121
## 3rd Qu.:20.915
## Max. :49.010
## NA's :12609
## PctOfListingsWithPriceReductionsSeasAdj_AllHomes
## Min. : 4.509
## 1st Qu.:10.908
## Median :12.309
## Mean :12.382
## 3rd Qu.:13.917
## Max. :20.636
## NA's :8724
## PctOfListingsWithPriceReductionsSeasAdj_CondoCoop
## Min. : 2.233
## 1st Qu.: 8.528
## Median :10.381
## Mean :10.394
## 3rd Qu.:12.189
## Max. :19.608
## NA's :9164
## PctOfListingsWithPriceReductionsSeasAdj_SingleFamilyResidence
## Min. : 4.438
## 1st Qu.:11.094
## Median :12.536
## Mean :12.602
## 3rd Qu.:14.114
## Max. :20.762
## NA's :8724
## PctOfListingsWithPriceReductions_AllHomes
## Min. : 3.564
## 1st Qu.:10.225
## Median :12.302
## Mean :12.364
## 3rd Qu.:14.366
## Max. :20.918
## NA's :8724
## PctOfListingsWithPriceReductions_CondoCoop
## Min. : 1.788
## 1st Qu.: 8.246
## Median :10.249
## Mean :10.379
## 3rd Qu.:12.381
## Max. :22.904
## NA's :9164
## PctOfListingsWithPriceReductions_SingleFamilyResidence
## Min. : 3.745
## 1st Qu.:10.423
## Median :12.498
## Mean :12.584
## 3rd Qu.:14.624
## Max. :21.689
## NA's :8724
## PriceToRentRatio_AllHomes Sale_Counts Sale_Counts_Seas_Adj
## Min. : 7.05 Min. : 130 Min. : 242
## 1st Qu.: 9.73 1st Qu.: 1672 1st Qu.: 1713
## Median :11.14 Median : 4546 Median : 4764
## Mean :11.44 Mean : 7066 Mean : 7049
## 3rd Qu.:12.74 3rd Qu.: 9247 3rd Qu.: 9393
## Max. :21.55 Max. :50275 Max. :41779
## NA's :8912 NA's :7837 NA's :7837
## Sale_Prices ZHVI_1bedroom ZHVI_2bedroom ZHVI_3bedroom
## Min. : 83800 Min. : 30900 Min. : 32800 Min. : 49600
## 1st Qu.:137000 1st Qu.: 74600 1st Qu.: 86700 1st Qu.:116400
## Median :180900 Median :100400 Median :115400 Median :141200
## Mean :194552 Mean :117060 Mean :135169 Mean :167063
## 3rd Qu.:235775 3rd Qu.:142300 3rd Qu.:166800 3rd Qu.:204400
## Max. :543100 Max. :390200 Max. :542400 Max. :639700
## NA's :9218 NA's :2607 NA's :1467 NA's :425
## ZHVI_4bedroom ZHVI_5BedroomOrMore ZHVI_AllHomes ZHVI_BottomTier
## Min. : 64700 Min. : 68600 Min. : 38200 Min. : 32600
## 1st Qu.:174900 1st Qu.: 217900 1st Qu.:114500 1st Qu.: 66600
## Median :218000 Median : 288000 Median :144750 Median : 87400
## Mean :243830 Mean : 323734 Mean :169753 Mean :102670
## 3rd Qu.:281000 3rd Qu.: 365300 3rd Qu.:207600 3rd Qu.:128200
## Max. :850400 Max. :1497000 Max. :620400 Max. :335600
## NA's :853 NA's :1398 NA's :774 NA's :896
## ZHVI_CondoCoop ZHVI_MiddleTier ZHVI_SingleFamilyResidence ZHVI_TopTier
## Min. : 42200 Min. : 38200 Min. : 37900 Min. : 70900
## 1st Qu.:111300 1st Qu.:114500 1st Qu.:115000 1st Qu.:194700
## Median :134700 Median :144750 Median :147300 Median :251100
## Mean :156770 Mean :169753 Mean :174154 Mean :293974
## 3rd Qu.:175800 3rd Qu.:207600 3rd Qu.:211775 3rd Qu.:349400
## Max. :782900 Max. :620400 Max. :737500 Max. :988100
## NA's :1530 NA's :774 NA's :774 NA's :688
## ZRI_AllHomes ZRI_AllHomesPlusMultifamily ZriPerSqft_AllHomes
## Min. : 799 Min. : 799 Min. :0.560
## 1st Qu.:1047 1st Qu.:1036 1st Qu.:0.728
## Median :1210 Median :1210 Median :0.862
## Mean :1321 Mean :1318 Mean :0.930
## 3rd Qu.:1474 3rd Qu.:1477 3rd Qu.:1.074
## Max. :2690 Max. :2653 Max. :2.294
## NA's :8958 NA's :8876 NA's :8876
## Zri_MultiFamilyResidenceRental Zri_SingleFamilyResidenceRental
## Min. : 713.0 Min. : 799
## 1st Qu.: 959.8 1st Qu.:1039
## Median :1126.0 Median :1220
## Mean :1233.0 Mean :1328
## 3rd Qu.:1399.5 3rd Qu.:1468
## Max. :2606.0 Max. :2754
## NA's :8876 NA's :8958boxplot(state_time_series$MedianListingPricePerSqft_1Bedroom, outline = FALSE)
hist(state_time_series$Sale_Prices, col = "green", breaks= 100)
plot(state_time_series$PctOfHomesSellingForLoss_AllHomes)
plot(state_time_series$PctOfHomesIncreasingInValues_AllHomes)