The purpose of this project is to utilize weather data in a SQLite database to determine if a new surfshop in Oahu would be viable. We will do this using Python and SQLAlchemy.
Using data point from 1700 days in the month of June, we were able to see that the month sees little variance in overall temperature. With the maximum temp being 85 and the lowest being 64. See below for further details on temperature variance in the month of June.
On the opposite end of the temperature spectrum we have December. While it is sliightly cooler compared to a peak summer month like June, it is still a very comfortable temperature overall. This month should see similar traffic as a summer month, possibly even more as people flee the cold in their homes.
Using the information gained from looking at just the temperature data from these two months we can infer that
- The standard deviation of temperatures for Dec is 3.25 while the deviation for June is 3.74.
- The summer months will be a peak time of traffic for the surf shop.
- The winter months will have a very similar weather pattern as the the summer, so business should not slow significantly.
Below I refactored the code to also include precipitation data for the two months. This data can also help us collect more info on weather variance in the two different season.