Open-Meteo Bulk Weather Extractor

Pull current weather + 7-day forecast for any list of cities via Open-Meteo (free, no API key, no quota — uses DWD ICON, NOAA GFS, ECMWF IFS aggregated). Maps to "weather data for these N cities" briefs — agriculture, logistics, retail demand forecasting, energy markets, travel-tech recommenders.

Built 2026-05-03 as Demo #38.

Run

. ~/freelance/.venv/bin/activate
cd ~/freelance/portfolio_demos/openmeteo_weather_extractor
python extract.py --cities "London,Tokyo,Sao Paulo,Lagos,Sydney"
python extract.py --file cities.txt

Result

• 5 cities → 35 (city × day) rows ✅
• Auto-geocoding via Open-Meteo's /v1/geocoding (handles "Sao Paulo" → "São Paulo, Brazil") ✅
• Per-row: city, resolved_name, country, lat, lon, day, t_max_c, t_min_c, precip_mm, wind_max_kmh, elevation_m, timezone ✅
• Free, no auth ✅
• Easy to swap to historical data via /v1/archive (back to 1940) ✅