Looking at Covid-19 throughout the pandemic, we looked into multiple data sets to see what the progression of the pandemic looked like, how it varied by regions, and looked for different factors that may have influenced how the pandemic impacted different regions.
Line Charts, Bar Graphs, Scatter Plots, linear regression, mapping
Matplotlib, Pandas, geopandas packages
Indranil Roy, Jenna Jorstad, Rhiana Schafer, Ying Sun
- Main COVID-19 Dataset: imported to pandas directly from website https://query.data.world/s/vk5mf4hyssjgd5iqtolztihap6xjpi
- Vaccination Rates Dataset: us_state_vaccinations.csv
- COVID-19 Testing dataset: COVID-19_Diagnostic_Laboratory_Testing__PCR_Testing__Time_Series.csv
- US State Populations dataset: NST-EST2021-POP.csv
- US County Populations dataset: uscensuspop2020.csv
- Shape Data: USA_States_Generalized.shp
- Mask Mandates datset: imported to pandas directly from website 'https://data.cdc.gov/api/views/62d6-pm5i/rows.csv?accessType=DOWNLOAD'
- County Diversity dataset: diversity_index_counties.csv
- 2020 Election results dataset: ElectionResults2020.csv
- US Poverty Rates datset: PovertyEstimates.csv
Analysis 1 - Case Count and New Case Count.ipynb
- Datasets: Main COVID-19 Dataset
- Graphs Produced:
- Total People Positive Case Count Over Time (daily, by week)
- People Positive New Case Counts Over Time (daily, by week)
COVID Vaccinations.ipynb
- Datasets: Vaccination Rates Dataset
- Graphs Produced:
- COVID-19 Total Vaccination Rates in the US over time
- COVID-19 Total People Vaccinated in the US over time
- COVID-19 Daily Vaccination Rates in the US over time
IR_Covid_19_Final.ipynb
- Datasets:
- Main COVID-19 Dataset
- COVID-19 Testing Dataset
- US State Populations Dataset
- Shape Data
- Graphs Produced:
- Total COVID-19 cases and deaths in US over time
- Total COVID-19 cases and deaths in each state
- Total COVID-19 tests in US over time, and %test
- COVID-19 tests vs. COVID-19 cases
- US map with COVID-19 cases, deaths, and tests
jennafile.ipynb
- Datasets:
- Main COVID-19 Dataset
- Graphs Produced:
- Total People Death Count Over Time
- New People Death Counts Over Time
rhiana_file.ipynb
- Datasets:
- Main COVID-19 Dataset
- US County Population Dataset
- Mask Mandates Dataset
- County Diversity Dataset
- 2020 Election Results Dataset
- US Poverty Rates dataset
- Graphs Produced:
- COVID-19 Case/Death rates in each state as percentage of total population
- Political party afflitiation vs. COVID-19 outcomes by county
- Poverty rates vs. COVID-19 outcomes by county, & overall and split by party
- Racial Diversity vs. COVID-19 outcomes, overall and split by ethnicity
- COVID-19 outcomes over time, split by mask mandate status
states.py: Dictionary for translating state abbreviations into full names
Code was tested using Python 3.8. The environment used pandas and matplotlib