almador2002/us-airbnb-eda-2023

<video src="https://huggingface.co/datasets/almador2002/us-airbnb-eda-2023/resolve/main/video.mp4" controls="controls" style="max-width: 720px;"></video>

U.S. Airbnb Open Data 2023 — EDA Project

Course: Data Science Dataset Source: Kaggle - US Airbnb Open Data

Dataset Overview

This dataset contains over 230,000 Airbnb listings from 27 major U.S. cities in 2023. Each listing includes information about price, room type, location, number of reviews, availability, and host details.

Main Goal: Explore what factors influence Airbnb listing prices across different U.S. cities.

Data Cleaning Decisions

• —Dropped neighbourhood_group — missing in 58% of rows, not useful
• —Filled reviews_per_month with 0 for listings with no reviews
• —Filled last_review with "No Review" for listings with no reviews
• —Removed listings with price = 0 (invalid)
• —Capped prices at the 99th percentile ($1,803) to reduce outlier impact
• —Removed listings with minimum_nights > 365
• —Final dataset: 229,632 rows

Research Questions & Findings

Q1: Which cities have the highest median listing prices?

San Francisco and Boston are the most expensive markets, with a median price above $200 per night. Columbus and Portland are significantly more affordable.

Q2: How does room type affect price?

Entire homes make up over 72% of all listings and are significantly more expensive than private or shared rooms.

Q3: What does the price distribution look like?

Prices are right-skewed — most listings are under $300, but a long tail of premium listings pulls the mean above the median. No single feature strongly drives price on its own.

Q4: Do hosts with more listings charge more?

Yes. Hosts with 20+ listings consistently charge higher prices, likely due to more professional management and better-located properties.

Q5: Which cities have the most listings?

NYC and LA dominate in total listings. Availability varies across cities, hinting at different market dynamics.

Q6: Is there a relationship between reviews and price?

No strong relationship. Expensive listings tend to have fewer reviews, likely because they are booked less frequently.

Key Takeaways

1. 1.City is the strongest indicator of price level
2. 2.Room type significantly affects price — entire homes cost much more
3. 3.Professional hosts (20+ listings) charge more than individual hosts
4. 4.Price distribution is right-skewed — most listings are affordable
5. 5.Reviews are not a reliable indicator of price

Files in this Repository