/Surfs_Up

Analyzes climate and precipitation in Honolulu, Hawaii using database stored in SQLite. Extracts and transforms the data using SQLite and visualizes the analysis by using Matplotlib.

Primary LanguageJupyter NotebookMIT LicenseMIT

Surfs Up!

main

About:

The purpose of this project is to do a climate analysis on Honolulu, Hawaii. Variables that are observed include but are not limited to "date", "precipitation", "station", and "temperatures." The first part of the project analyzes the precipitation amount by date as well as the lowest, highest, and average temperatures in Hawaii measured for 12 months by the most active climate station. The second part of the project designs a Flask API based on the observations from the first part of the project.

Precipitation Analysis:

The previous 12 months of precipitation data from the most recent date in the dataset:

precip


Station Analysis:


- The most active station based on the number of observations: USC00519281
- Lowest, highest, and average temperatures that filters on the most active station: 54.0, 85.0, 71.7
- Histogram showing the most active station's number of observations for a range of temperatures for a 12-month period.

obs


How to Use the Climate App:


1) Run app.py and enter the command "python -m flask run" inside the correct directory.

2) Choose from the different routes:

- "/api/v1.0/precipitation": Returns jsonified precipitation data for the final year in the database
- "/api/v1.0/stations": Returns jsonified data of all the stations in the database
- "/api/v1.0/tobs": Returns the jsonified data of the past year from the most active station
- "/api/v1.0/start/": Enter a start date YYYY-MM-DD. Returns the date, min, avg, and max temperatures calculated from the given date to the end of the dataset
- "/api/v1.0/start_end//": Enter a start and an end date YYYY-MM-DD. Returns the date, min, avg, and max temperatures calculated from the given start date to the given end date

3) Enjoy!

Languages and Libraries:

Python Pandas NumPy SQLAlchemy datetime Matplotlib SQLite