This script that allows beginners to query a sqlite database using SQLAlchemy and complete the following:
-
Create an engine, connection, and session to query precipitation data from Hawaii weather stations.
-
Query specific dates and station locations.
-
- Load query results into dataframes using pandas to run statistical analysis and create visualizations.
After exploring the database using SQLAlchemy, the app.py script uses Flask to create a Flask API based on queries developed in jupyter notebook.