Airbnb_Project

Analysed Airbnb dataset on the San Francisco listings.

The Issue

● San Francisco has seen enormous spikes in rent prices in the last 5 years.
● Neighborhoods such as the Financial District, Bayview, and Russian Hill are seeing rent prices hitting nearly $5,000/month

Tableau link for additional findings

https://public.tableau.com/profile/ramneek2937#!/vizhome/Book1_15858892931090/Sheet1?publish=yes

Findings

• Conducted a comprehensive analysis of Airbnb's San Francisco listings dataset to understand trends and impacts on the local housing market.
• Investigated rent price spikes in neighborhoods like the Financial District, Bayview, and Russian Hill, identifying rent prices nearing $5,000/month.
• Discovered a high ratio of listings with extensive availability, indicating potential illegal listings and displacement of local residents.
• Identified multiple hosts managing numerous properties, with some like Zeus holding 248 listings, highlighting a potential breach of the "One Host, One Home" rule.
• Analyzed pricing trends, noting an average price increase over the years and a significant drop post-2016 due to stricter Airbnb regulations by the city.
• Found a preference for "Entire Homes" or "Private Rooms" over "Shared Rooms" in the listings, comprising 98% of total listings.
• Concluded that over 50% of listings were highly available, suggesting a negative impact on local affordable housing availability.

Screenshots