Advanced Data Storage and Retrieval with Jupyter Notebook, SQLite and SQLAlchemy
The purpose of this analysis is to analyze a dataset pertaining to weather conditions (temperature and precipitation data) for the months of June and December in Oahu, in order to determine ifopening up a Surf n' Shake shop in Oahu, Hawaii, a surf and ice cream shop business is sustainable year-round.
- Data Source: Weather Database: data is stored in the SQLite database, and SQLAlchemy was used to connect and generate queries to pull the necessary information needed for the analysis.
- Software: Python 3.8.8, Pandas Dataframe, Matplotlib, Jupyter Notebook 6.3.0, SQLite, SQLAlchemy, Flask
Initial analysis for one year revealed the that a vast majority of the observations were over 67 degrees. If you count up the bins to the right of 67 degrees, you will get about 325 days where it was over 67 degrees when the temperature was observed. Precipitation data statistics gives us a summary of different statistics for the amount of precipitation in a year. We can see from the chart that some months have higher amounts of precipitation than others but the recorded levels are very low.
The client wants a temperature analysis including statistical inference for the months of June and December to compare in order to determine if the surf and ice cream shop business is sustainable year-round.
- The average recorded temperature in June is about 75°F, 4 degrees higher than the average temp in December(.71°F)
- June's standard deviation of 3.26 and December's standard deviation of 3.75 so temperature records are concentrated around both of their average temperatures. * Temperatures can reach upto 80+ degrees in both June and December which is great ice cream weather.
- Minimum temperatures in December can go to 56 °F, ~10 degrees lower than in summer but the frequency of that is low from the December Temperature chart.
- June and December had a 75th percentile of 77°F and 74°F, respectively, which indicates that these two seasons had relatively warm temperatures.
The results from the above analysis shows that there is no significant difference in the temperatures in June and December, even though some of the temperatures recorded in December is in the 50's, December would still provide appropriate weather conditions for both surfing and demand in ice cream. While results currently seem favorable, additional data retrieval and analysis has to be done on the following before fixing a final pin.
- Precipitation analysis per station to detrmine to narrow down the location in Oahu and compare against the temperature.
- Other variables such as wind speed/conditions, height of the waves per month, and how foot traffic (tourist seasons) relates to weather conditions, how many surf and ice cream shops are already operating in that area.