Skip to content

Latest commit

 

History

History
24 lines (18 loc) · 1.58 KB

README.md

File metadata and controls

24 lines (18 loc) · 1.58 KB
Raw

NC_COVID_data

nc_counties_covid image

This repository contains the data for and documents the process used to generate the Tableau visualisation for the prevalence of COVID across North Carolina Counties from May - Oct 2020.

Data Source:

  • Data was taken from the NCDHHS.gov website, under the "County-Daily Cases and Deaths Metrics" as an excel file.
  • Excel file for demographics for NC County Populations taken from here
  • Excel file for fibs codes taken from simple Google search

Process:

Using R,

  • The original daily cases were summed into groups by month and county
  • The population data was added to the counties using an outer join, and the rate (cases/population) for each month calculated
  • Saving the dataframe as an Excel file, Tableau was used to visualise the data

Problems faced:

  • County column insufficient on its own in Tableau, extra research from here helped in adding fibs and State columns. fibs data added to excel using outer join in R.

This project was inspired by https://github.com/huishun98/SG-COVID-data