DATA ANALYSIS

Code and resources can be found in their respective tabs if you have any doubts on this information. Pandas was used to filter the data frames to gather the columns of information needed while also creating our own columns using information provided.
The time series plots above are broken into two kinds of groups. The first 6 solely plots the counts from the first day the first open street was opened to the public all the way until the end of September of this year. The next 5 use the shows the percentage of covid case counts per day from each borough. From the information based on the first 6 graphs we can see that there is no unusual spikes within the case counts that cannot be explained by outside factors. By looking solely from the dates starting when the open streets were implemented, one would believe the correlation is obvious between the two datas being compared. However, in this case we see spikes mainly in the winter and in the summer. This being the months where most people are prone to get sick, winter, or the months where people disobey CDC guidelines, summer.
From the first 6 graph we can see an average number of case counts between the months of 'normalcy' for this pandemic, we can see no huge uptick in counts like those of the summer months or the winter months. However, a huge flaw with this analysis is the inability to pinpoint what caused these upticks specifically, one way to do so would have been to finding the zip codes of the increases and comparing it to the locations of the open streets, but that data was also not taken down by OPEN DATA NYC.
One interesting piece of analysis that surprised me was the higher percentage of case counts coming from Brooklyn making an average of over 25% of the daily counts. Some potential reasoning for this may be the popularity of the borough bringing more people allowing for a higher spread onto its already dense population. Following Brooklyn, is Queens borough which can also suffers from a large population. But this is proven to not be the problem with open streets, because the most popular and congested borough, Manhattan, maintained a low daily case percentage.