Who doesn't want to know the weather? Weather Underground provides weather data for areas across the world.
In this project we'll be using sample weather data for the month of May from Weather Underground. We are interested in querying the data to answer various questions. We'll specifically look at:
- Max temperature on foggy and non-foggy days
- Number of rainy days
- Average temperature on the weekends
- Average temperatures on rainy days where the minimum temperature is greater then 55
You'll need to install:
weather.csv- Weather Underground sample data for the month of May.
weather.py- Takes in the Weather Underground data, and uses SQL queries to answer various questions about the weather.
-
max_temp_aggregate_by_fog(weather_data)- Returns Max Temperature when Foggy or Non-Foggy -
num_rainy_days(weather_data)- Count the number rainy days. -
avg_weekend_temperature(weather_data)- Returns the average temperature on the weekends -
avg_min_temperature(weather_data)- Returns the average temperatures on rainy days where the minimum temperature is greater then 55
