The question behind this project
How do places to stay differ across Mexico City?
Looking for a place to stay means comparing neighborhoods, rooms, and prices. We explore Airbnb listings to see where the supply is concentrated and who offers it, without assuming every listing gets booked.
Read the analysis
Market research An analytical case study
Airbnb listings, prices, and hosts in Mexico City
How do location, room type, and host scale shape the visible listing market?
The finding
Listing prices and host concentration describe the supply on display. They do not directly measure bookings, occupancy, or realized revenue.
Analytical work
Connect price distributions, borough comparisons, and host portfolios while separating observed supply from unobserved demand.
Listings are concentrated in a few boroughs
Listings · five largest borough counts in the retained artifact
01
Show the distribution before the average
A few expensive listings can move the mean away from the typical listing. Compare distributions within room type and location, and inspect missing-price coverage before ranking boroughs on price.
02
Count listings and hosts separately
A host can operate multiple listings. Comparing each host segment’s share of hosts with its share of listings reveals the structure of supply. The map shows locations from a sample; borough totals come from the broader processed listing data.
03
Treat availability as an ambiguous signal
An unavailable calendar day may be booked or blocked by the host. A high advertised price may reflect room mix rather than stronger demand. These distinctions determine which questions the snapshot can answer and which require booking or longitudinal data.
Decision supported
What to do with this evidence
Use the snapshot to describe market composition and select comparable listing groups. Validate any pricing or expansion hypothesis with occupancy, realized prices, and repeated snapshots.
What this analysis cannot establish
- Price and review fields contain missing values. The geographic scatter is sampled, and location summaries are at borough level.
- A single listing snapshot cannot establish demand strength, an underserved market, or a causal effect on housing.
Continue the investigation