Wed 2020-Nov-04

Transcript for "Wastewater coronavirus RNA vs medical loads"

Tagged: COVID MathInTheNews R

Here’s the transcript of running the analysis:

* MWRA COVID Analysis on Wed Nov 04 14:21:50 2020
  - input data directory: ./data
  - results directory:    ./results
  - transcript to:        ./results/mwra-covid-transcript.txt

Archival:
---------

* Archived analysis script(s) to ./results:
  - ./mwra-covid.r

Loading datasets and constructing joint dataset:
------------------------------------------------

* Reading MWRA wastewater RNA data from ./data/MWRAData20201027-NSdata.tsv
  - Structure:
    o 162 rows
    o 3 columns: Date, South.7, North.7
* Reading Mass COVID data from ./data/massachusetts-history.csv
  - Structure:
    o 286 rows
    o 3 columns: Date, deadIncr.7, hospIncr.7
* Constructing inner join on dates
  - Complete cases only, to drop the initial 6 rows w/o 7 day trailing means
  - Saved to ./results/mwra-covid-joint-data.tsv
  - Structure:
    o 156 rows
    o 6 columns: Date, North.7, South.7, RNA.7, hospIncr.7, deadIncr.7

Exploratory plots:
------------------

* Plot of north vs south RNA to ./results/plot-north-south.png
* Plot of medical loads vs RNA to ./results/plot-med-loads-vs-RNA.png
* Correlations, using all data:
           North.7 South.7 RNA.7 hospIncr.7 deadIncr.7
North.7       1.00    0.91  0.98       0.66       0.62
South.7       0.91    1.00  0.97       0.60       0.54
RNA.7         0.98    0.97  1.00       0.65       0.59
hospIncr.7    0.66    0.60  0.65       1.00       0.87
deadIncr.7    0.62    0.54  0.59       0.87       1.00

* Correlations, first wave data:
           North.7 South.7 RNA.7 hospIncr.7 deadIncr.7
North.7       1.00    0.95  0.99       0.74       0.67
South.7       0.95    1.00  0.98       0.78       0.68
RNA.7         0.99    0.98  1.00       0.77       0.68
hospIncr.7    0.74    0.78  0.77       1.00       0.81
deadIncr.7    0.67    0.68  0.68       0.81       1.00

* Correlations, second wave data:
           North.7 South.7 RNA.7 hospIncr.7 deadIncr.7
North.7       1.00    0.92  0.97      -0.04       0.06
South.7       0.92    1.00  0.99       0.19       0.18
RNA.7         0.97    0.99  1.00       0.10       0.14
hospIncr.7   -0.04    0.19  0.10       1.00       0.71
deadIncr.7    0.06    0.18  0.14       0.71       1.00


* MWRA COVID Analysis completed Wed Nov 04 14:21:50 2020 (0.4 sec elapsed).
Published Wed 2020-Nov-04