Project DD360 is a Jupyter notebook exploratory data analysis of apartment sale listings in Roma Norte and Roma Sur (Cuauhtémoc, CDMX). It loads a scraped Metroscubicos dataset, profiles price drivers like surface area and bedroom count, and plots every listing on an interactive Folium map by latitude and longitude.
What it does
The main notebook (PruebaDD360.ipynb) walks through a two-part analysis:
Part 1 — Exploratory statistics
- Load data — Reads
reto_precios.csvinto a Pandas DataFrame with 30+ columns: price,m2, bedrooms, bathrooms, location, vendor, lat/lon, amenities, and derived fields likeprice_square_meterandfinal_price. - Profile the dataset —
head(),describe(), andinfo()to inspect dtypes, missing values, and numeric ranges across hundreds of Roma listings (March 2022 snapshot). - Correlation heatmap — Seaborn heatmap over all numeric columns to spot relationships between price, surface, bedrooms, parking, and fees.
- Distribution charts — Matplotlib/Seaborn visuals:
- Scatter: surface (
m2) vs. price per m² - Box plot: price per m² by number of bedrooms
- Box plot: price per m² by neighborhood (
location)
- Scatter: surface (
Part 2 — Geospatial visualization
Uses Folium to build an interactive map centered on CDMX (19.4, -99.15):
- One marker per listing at
lat/lon - Popup shows price per m² for each property
- Lets you compare spatial price clusters across Roma Norte vs. Roma Sur streets
Dataset
reto_precios.csv contains Metroscubicos apartment listings scraped from Roma neighborhoods — fields include listing title, address, vendor, days on site, orientation, parking, monthly fees, and geocoordinates. The price_square_meter column is precomputed for direct comparison across unit sizes.
Tech stack
| Layer | Choice |
|---|---|
| Environment | Jupyter Notebook |
| Language | Python 3 |
| Data | Pandas, NumPy |
| Charts | Matplotlib, Seaborn |
| Maps | Folium |
| Source data | Metroscubicos CSV export (reto_precios.csv) |
Development process
Initial scaffold
Repository created on GitLab with the default README scaffold.
Notebook + dataset upload
Added PruebaDD360.ipynb with the full EDA workflow, reto_precios.csv listing data, and a blank Untitled.ipynb scratch pad. This commit captures the completed price-analysis challenge for the DD360 project.
Use cases
- Real-estate benchmarking — Compare price-per-m² distributions across Roma sub-neighborhoods and bedroom counts
- Spatial pricing — Spot geographic clusters of high- or low-priced units on the Folium map
- EDA template — Reusable notebook pattern for CSV profiling, correlation analysis, and map overlays on lat/lon data


Building Smartclic Demo