/sqlalchemy-challenge

Designed a Flask API based on queries developed with Sqlalchemy. Use queries, Python and Matplotlib to analyze weather station and precipitation data.

Primary LanguageJupyter Notebook

sqlalchemy-challenge

alt text

Wish you were here! 🌺


Table of Contents


General info

I've decided to treat myself to a long holiday vacation in Honolulu, Hawaii! To help with trip planning, I did some climate analysis on the area. 🏝️

Objectives

  1. Use queries to analyze weather station and precipitation data for the last year.
  2. Design a Flask API based on the queries that you have just developed.

Bonus: Calculate and visualize average temperature for dates of my trip!

Step 1

Climate Analysis and Exploration

Precipitation Analysis

alt text

alt text

Station Analysis

alt text

Step 2

Climate App

Routes

The routes I used for my Flask API are here: routes

Bonus Analysis

Based on my analysis, my vacation this coming May will be warm and beautiful! 🌤️

alt text

Technologies

sqlalchemy

jupyternotebook

Python

Matplotlib