Building Project DD360

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

  1. Load data — Reads reto_precios.csv into a Pandas DataFrame with 30+ columns: price, m2, bedrooms, bathrooms, location, vendor, lat/lon, amenities, and derived fields like price_square_meter and final_price.
  2. Profile the datasethead(), describe(), and info() to inspect dtypes, missing values, and numeric ranges across hundreds of Roma listings (March 2022 snapshot).
  3. Correlation heatmap — Seaborn heatmap over all numeric columns to spot relationships between price, surface, bedrooms, parking, and fees.
  4. 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)

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

LayerChoice
EnvironmentJupyter Notebook
LanguagePython 3
DataPandas, NumPy
ChartsMatplotlib, Seaborn
MapsFolium
Source dataMetroscubicos 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

Blog

recent-work

Building Smartclic Demo

Modern landing page for a Mexican web development agency — React 19, Vite, Tailwind v4, GSAP scroll, 3D viewer, and bilingual ES/EN.

Read more →

Smartclic Demo

Landing page for a Mexican web agency — React 19, Tailwind v4, GSAP scroll, 3D viewer, and bilingual ES/EN.

How it was built →
border-home1