amitp06 / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
1 stars 0 forks source link

Join together COVID Time Series data with Mobility data #1

Closed aksomers closed 3 years ago

aksomers commented 3 years ago

Need to join the two datasets. A few things (at least) to resolve before doing so.

aksomers commented 3 years ago

Made progress on 1 and 3 in the data_merge.R code.

amitp06 commented 3 years ago

Regarding #2: I decided to join on FIPS instead of State/County since it was available in both and caused less joining issues.

4 and #5 are complete in the latest commit.

There is some data loss due to time period and some differences in counties included. More sanity checks would help, but my initial impression is that it looks acceptable. (See comments in data_merge.R)

aksomers commented 3 years ago

For now, I think it's acceptable. I think we can push on and circle back later.