Data Analysis of Covid-19 on the NYC Apartment Market

Posted on Oct 24, 2021
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.

Data Analysis of Covid-19 on the NYC Apartment Market

Background & Inspiration

As the epicenter of Covid-19 in the United States, New York City's data has shown that there has been over 2.5 million cases since the outbreak of the virus. The virus had a devastating effect on the city, forcing the closure of schools, restaurants and bars - resulting in the loss of jobs for many.

Like many other industries, the real estate industry was greatly affected by the novel virus and real estate prices were drastically changed. The purpose of this analysis is to examine how significantly apartment rents changed in NYC and to identify any trends or patterns in the boroughs where rent declined the most. Further, this analysis seeks to examine the recovery of apartment prices in NYC as Covid cases are declining.

 

Data Collection

Since the goal of this analysis was to examine rent prices in NYC and any other factors that might affect prices, three data sources were used:

  1. Street Easy Median Rent Data
  2. NYT Covid Dataย 
  3. US Census Dataย 

The above datasets allow for a full picture of how Covid cases affected rent prices and which external factors in each borough may have contributed to the changes.

Data Analysis

To begin my analysis, I decided to get a basic understanding of the number of Covid cases in NYC. Using the NYT dataset, the below figure shows the average 7 day case count of Covid cases since the first recorded case on March 1st, 2020:

Data Analysis of Covid-19 on the NYC Apartment Market

As seen in the figure above, Brooklyn and Queens consistently had the largest number of Covid cases while Manhattan and Staten Island had the fewest of all boroughs. Further, the graph allows us to understand the timeline of Covid cases in NYC. For the rest of this analysis, "Peak Covid" will refer to the month of January, 2021, "Pre Covid" will refer to January, 2020, and "Covid Start" will refer to March 1st, 2021.

 

After understanding the amount of Covid cases in NYC, I then decided to shift to look at median rent prices from Street Easy:

Data Analysis of Covid-19 on the NYC Apartment Market

Looking at the above figure, it is clear that from 2010 through January 2020, real estate was a very strong investment. Landlords were able to slowly raise the rent over time in all five boroughs of New York. However, after the first recorded Covid case in New York, rents dropped significantly, as shown by the dip in March 2021. From the above graph, it is clear that there is a sizeable decline in median rents and that decline seems to be more prominent in Brooklyn and Manhattan, the two most expensive boroughs.

To further analyze this decline, I decided to examine the median rents at different times throughout the pandemic. See the chart below:

As is clear by the graph above, Manhattan and Brooklyn witnessed the greatest decrease in rent from Pre-Covid (January 2020) to peak Covid (January 2021). In addition, it looks like most boroughs were able to fully recover from this decline in peak Covid.

Data on Different Timeframes during Pandemic

The next two charts will show how the boroughs have changed (and recovered) throughout different timeframes of the pandemic:

The above chart shows the percent change of median rents by boroughs from the start of the pandemic (March 1st, 2020) through peak pandemic (January 2021). From this chart, it is clear that Manhattan and Brooklyn saw the biggest decline in rent (-16% and -12% respectively). To understand if and how these rates have recovered, the following graph shows current rents vs. pre-pandemic rents:

The chart above shows how current rents have changed since January 2020. While peak pandemic saw a major decrease in rents, it appears that rents have fully recovered in three of the five boroughs and are only down around 2% in Manhattan and Brooklyn. Interestingly, in Queens and Bronx, rates have actually continued their trend of increasing that they have seen since 2010 (shown in the second chart of this document).

 

Ultimately, from the data presented above, it is clear that rates were greatly affected during peak pandemic, however have slowly but steadily recovered and have returned to pre-Covid rates. One question still remained in my analysis -- why did some boroughs (such as Manhattan and Brooklyn) experience such dramatic changes in rent, while the other three boroughs remained largely unchanged? In order to answer this question, I combined census data with the data presented above in order to find correlations.

As shown in the chart above, the largest factors affecting how significantly rent would change was the pre-Covid rent and the number of total housing units in 2020. Interestingly, the number of Covid cases in each borough did not greatly affect median rents in that area.

 

Conclusion

In conclusion, these insights prove to be valuable for different stakeholders in the real estate industry in NYC.

As a renter, you can better understand how rents have changed over the past year and a half and understand if rents are still affected. For example, in Manhattan you can still expect to pay 2% less than you would before the pandemic.

As a landlord, these insights are very promising and show that the NYC apartment market has fully recovered (and will most likely continue to grow). Landlords can use the above insights to understand how much they should currently charge for rent now and gauge what is a reasonable rate the industry should grow at.

 

 

About Author

Jack Copeland

After graduating from the University of Virginia in 2019 with a degree in Computer Science, I went on to join Anheuser-Busch as a Global Management Trainee. I received cross functional training in sales, marketing, supply and more before...
View all posts by Jack Copeland >

Related Articles

Leave a Comment

Analysis of Covid-19 on the NYC Apartment Market - Natluk October 24, 2021
[…] Source link […]

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI