Skip to content

AliceSartori/SQLAlchemy_Temperature_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

47 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Analyzing Hawaiian Temperatures through SQLAlchemy

Congratulations! You've decided to treat yourself to a long holiday vacation in Honolulu, Hawaii! To help with your trip planning, you need to do some climate analysis on the area.

First, you decided to analyze the last 12 months of data. August, did you say? Not a great period to go to Hawaii. Precipitations are possible and more relevant compared to other months, also the STD in 2016 tells that there is a lot of variability in that period.
Although we have to say that the data is complete for August 2016, not so exhaustive for 2017 to make a truthful comparison.

Summary Statistics

Summary Statistics

Analyzing the temperature of Hawaii, plotting a boxplot allows us to have an understanding of the distribution of the data points of all weather stations and determine if there are any potential outliers visually. There are multiple potential outliers in the temperature data points that could skew data analysis and further investigations should be done. Summary Statistics

Hawaii is reputed to enjoy mild weather all year. Is there a meaningful difference between the temperature in, for example, June and December? I decide to run a statistical un-paired test between June and December data. If the pvalue is smaller than 0.05, like here, we can reject the null hypothesis and say there is a statistically meaningful high difference between these groups.

Summary Statistics

Other specific plots are below:

  • A plot comprising the min, avg, and max temperature from the first days of August across all years as a bar chart

Summary Statistics

  • An area plot (stacked=False) for the daily normals

Summary Statistics

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors