Reading the CA Covid-19 case data files is initially challenging but is easier than one might think. One starts by collecting information on the number of county entries with the same name.
Next a Directory is created by sorting the data by county name.
To create a plot of the county data one can select a county from the Directory and plot the data from a copied section containing just the county data.
Supplemental (Nov 10): To select another county tap the county selected and the formula bar then tap on some other county in the Directory and the check icon to confirm the change.
Supplemental (Nov 10): For those not familiar with Excel spreadsheets the formula for cell S15 is
=MATCH(R15,M15:M74)-1.
No comments:
Post a Comment