Skip to main content
100%

Gist 7e406d1d7597759ba28a1b687103ea3a

✓ Published0🌍 Public
Aantichaos
Last edited Apr 8, 2025
Created on Apr 8, 2025

This example retrieves a seven-day weather forecast for San Diego from the OpenWeatherMap One Call API and converts it into a pandas DataFrame structured for Tableau analytics. The code transforms raw JSON fields into normalized columns, including temperature conversions from Kelvin to Celsius and Fahrenheit, humidity as a decimal, and wind direction mapped to sixteen-point wind rose labels. It also generates icon URLs for weather conditions and converts Unix timestamps for sunrise, sunset, and moon phases into UTC datetime strings. The final output is a dictionary of lists ready for Tableau ingestion.

AI-generated description

Similar vizzes