data-science icon indicating copy to clipboard operation
data-science copied to clipboard
verified publisher icon hackforla

Housing Rental/sales Prices in LA County Post Fires: Zillow

Open salice opened this issue 1 year ago • 12 comments

Overview

We want to analyze how house sales and rental prices and inventory were affected by the fires.

Action Items

  • [ ] Find publicly available data sets
  • [ ] identify what analysis is possible
  • [ ] Bring back to DS CoP for discussion

Resources/Instructions

salice avatar Jan 28 '25 03:01 salice

@FragariaChemist I am going to return this issue to the new issue approval. There have been no updates and we need to better define what tasks need to be done.

akhaleghi avatar May 19 '25 22:05 akhaleghi

@sauravchangde Please provide update

Instructions
  1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
  2. Blockers: "Difficulties or errors encountered."
  3. Availability: "How much time will you have this week to work on this issue?"
  4. ETA: "When do you expect this issue to be completed?"
  5. Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."

You can use this template

1. Progress: 
2. Blockers: 
3. Availability:
4. ETA:
5. Pictures (if necessary):

ExperimentsInHonesty avatar Aug 25 '25 23:08 ExperimentsInHonesty

  1. Progress: Currently looking for a database that will provide Housing Rental/Sales Prices in LA County.
  2. Blockers: No blockers as such, but I want to confirm whether the database that I'm using is the best or not.
  3. Availability:
  4. ETA: If the database is good enough, I can start the data cleaning and preprocessing. I can show my findings in the next meeting.
  5. Pictures (if necessary): Databases: https://public.tableau.com/app/profile/redfin/viz/RedfinDataCentertrend/MedianSalePrice

https://www.kaggle.com/datasets/paultimothymooney/zillow-house-price-data/code

sauravchangde avatar Aug 26 '25 00:08 sauravchangde

  1. Progress: Used the following dataset to compare Housing Rental/Sales Prices in LA County.

data.xlsx

  1. Blockers: None
  2. Availability:
  3. ETA:
  4. Pictures (if necessary): I have provided my findings below.

la_sales_summary_pre_post.csv Image Image

sauravchangde avatar Sep 08 '25 23:09 sauravchangde

HI @sauravchangde this is a good look at what happened in Los Angeles, but I think what we are hoping for is a more granular view of home values, within Los Angeles County. That would include values separately for Los Angeles, Pasadena, Beverly Hills, the valley, and of course Pacific Palisades, etc, etc. Please keep looking and try to see if these statistics are gathered anywhere else on the web, or otherwise how we might put together that kind of dataset on our own. Thanks

chinaexpert1 avatar Sep 09 '25 00:09 chinaexpert1

Hi @chinaexpert1, thank you for your feedback. I will work on it and update here.

sauravchangde avatar Sep 09 '25 01:09 sauravchangde

Progress: I have analyzed the price difference by county in California.

data_based_counties.csv

Blockers: Availability: ETA: Looking for feedback and complete the task. Pictures (if necessary): I have provided my findings below.

Image Image Image Image Image

sauravchangde avatar Sep 09 '25 02:09 sauravchangde

Bonnie will look for the city spreadsheet for this issue.

Try to find some rental data for same locations.

see if you can find zip code data inside Los Angeles counties to map to cities

ExperimentsInHonesty avatar Sep 09 '25 02:09 ExperimentsInHonesty

  1. Progress: I have compared data on Rental prices and Home Values based on zip codes. I have also looked at Sale Listings and Sales data, but that is based on the California Metropolitan Statistical Area. Data Source: https://www.zillow.com/research/data/
  2. Blockers: None
  3. Availability: Available next week.
  4. ETA:
  5. Pictures (if necessary):
Image Image Image Image

Findings: Rentals and Home Values: Rents moved more sharply than home values after the fires — indicating renters may have felt the disruption more than owners. Home values proved resilient, reflecting the slower-moving nature of housing prices and continued demand in California. The strongest shifts (up or down) were localized at the ZIP level, not uniform across the state.

Sales and Sale Listings: The wildfires coincided with a rise in inventory (more homes being listed for sale). Sales activity increased modestly, especially in smaller California metros. In contrast, large metros like Los Angeles only showed mild changes, suggesting a more stable or slower-reacting market.

sauravchangde avatar Sep 23 '25 01:09 sauravchangde

Hi @sauravchangde did a great job of looking there isn't any place to get good sales data by ZIP, I asked Bonnie last week if she wanted to do our own statistical sampling and she wasn't eager for that. I'm keeping Saurav assigned but giving him another issue.

chinaexpert1 avatar Sep 23 '25 02:09 chinaexpert1

Hey @sauravchangde didn't see you this week if you can come next week I can give you an actual data science project not just data gathering, thanks for being patient

chinaexpert1 avatar Oct 14 '25 03:10 chinaexpert1

Please provide update @sauravchangde please provide update, is this done?

Instructions
  1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
  2. Blockers: "Difficulties or errors encountered."
  3. Availability: "How much time will you have this week to work on this issue?"
  4. ETA: "When do you expect this issue to be completed?"
  5. Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."

You can use this template

1. Progress: 
2. Blockers: 
3. Availability:
4. ETA:
5. Pictures (if necessary):

chinaexpert1 avatar Oct 21 '25 03:10 chinaexpert1