sqlalchemy-weather-analysis

SQLAlchemy for Weather Analysis

Step 1 - Use SQLite database for Climate Analysis and Exploration

SQLite database is used to analyse Precipitation and other weather realted information for various weather stations over a period of 15 days.

Precipitation Analysis

precipitation

Station Analysis

station-histogram

Step 2 - Climate App

A Flask API is created with different routes for weather realted data

Routes

/
/api/v1.0/precipitation
/api/v1.0/stations
/api/v1.0/tobs
/api/v1.0/<start> and /api/v1.0/<start>/<end>

Libraries and Tools used

Python and SQLAlchemy
SQLAlchemy ORM queries, Pandas, and Matplotlib.