The problem
Málaga is one of the fastest-growing tourist destinations in Spain. Airbnb concentrates thousands of listings, but 65.8% of properties are in the City Centre. Saturation has turned that area into a highly competitive market with tight margins.
Is it still profitable to invest in the City Centre? Are there better opportunities in peripheral neighbourhoods? How does demand behave throughout the year?
This project analyses 9,420 properties from Inside Airbnb (2024 dump) using exploratory, geospatial and temporal analysis techniques, aimed at investors, hosts and tourism consultants.
The approach
I designed a three-phase analysis.
Phase 1 · Cleaning and preprocessing — Python
I loaded the data with pandas. I normalised prices (range €15 to €410), handled missing values and removed outliers by neighbourhood using the interquartile range (IQR). I imputed missing values with the neighbourhood mean.
- Total records: 9,420
- Unique hosts: 3,504
- Neighbourhoods: 11
- Most common property type: entire home (86.8%)
- Marginal types: hotel room (4 records) and shared room (2 records)
Phase 2 · Exploratory and geospatial analysis — Python
I calculated key statistics and created heatmaps with Plotly and Folium.
| Property type offered | Percentage |
|---|---|
| Entire home/apt | 86.8% |
| Private room | 13.1% |
| Hotel room | <0.1% |
| Shared room | <0.1% |
Phase 3 · Temporal analysis — Python
I used review frequency as a proxy for occupancy to detect seasonality. I analysed monthly distribution and calculated the correlation between reviews and availability (coefficient = 0.10, very weak).
The findings
Finding 1 · The City Centre concentrates supply, but not the best price opportunities
Campanillas, Puerto de la Torre and Churriana have higher average prices than the City Centre. Tourist saturation in the City Centre and competition from hotels and other channels push prices down.
| Neighbourhood | Average price (€/night) |
|---|---|
| Campanillas | €186/night |
| Puerto de la Torre | €144/night |
| Churriana | €132/night |
| City Centre | €112/night |
The City Centre has the most supply, but it is not the most expensive for guests. Saturation has flattened its prices.
Finding 2 · Western peripheral neighbourhoods show better profitability potential
Those same neighbourhoods offer the best estimated profitability (average price × estimated occupancy —estimated from calendar availability). Lower supply and the presence of spacious accommodation —near the Technology Park— drive prices up.
Finding 3 · Demand shows strong seasonal concentration
December accounts for 66.4% of the year's reviews. Demand spikes at Christmas; the first half of the year represents barely 3% of the total.
| Month | Reviews | Annual percentage |
|---|---|---|
| January | 1,541 | 0.37% |
| February | 1,029 | 0.25% |
| March | 2,005 | 0.48% |
| April | 2,225 | 0.53% |
| May | 2,588 | 0.62% |
| June | 3,262 | 0.78% |
| July | 5,562 | 1.33% |
| August | 11,799 | 2.82% |
| September | 16,978 | 4.06% |
| October | 34,823 | 8.34% |
| November | 58,683 | 14.05% |
| December | 277,294 | 66.37% |
The correlation between reviews and actual occupancy is weak (0.10), so reviews should not be used as the sole metric for estimating occupancy.
Finding 4 · The market is already dominated by professional operators
Companies such as I Loft Málaga, Remy and Living4Malaga manage hundreds of properties each. The peer-to-peer collaborative economy model is now a minority.
| Host | Properties | Percentage |
|---|---|---|
| I Loft Málaga | 218 | 2.31% |
| Remy | 137 | 1.45% |
| Living4Malaga | 109 | 1.16% |
The three largest hosts account for 4.9% of properties. Competition is no longer between individuals, but with specialised companies.
The conclusion
The analysis yields four strategic implications:
- Invest in the West (Campanillas, Puerto de la Torre, Churriana) offers better profitability than the saturated City Centre.
- Adjust prices dynamically: raise them in December, apply discounts from January to June.
- Do not blindly trust reviews as an occupancy indicator; the correlation is very low (0.10).
- The market is professionalised. Competition is no longer between individuals, but with specialised companies.
Stack and methodology
| Tool | Use in the project |
|---|---|
| Python · pandas, numpy | Cleaning, preprocessing, imputation |
| Python · folium, plotly | Interactive heatmaps and geospatial visualisation |
| Python · matplotlib, seaborn | Seasonality charts and temporal analysis |
| Inside Airbnb | Base data source (2024 dump) |
Dataset: 9,420 properties · 11 neighbourhoods · 3,504 hosts
Geospatial analysis: heatmaps with folium · official shapefiles
Seasonality: occupancy proxy = reviews · correlation with availability = 0.10
Professionalisation: the three largest hosts account for 4.9% of properties