data cleaning and consolidation

[kaizadp]

attn: @SarahFansler

1. Locate all files for raw weights/moisture/subsampling. Currently found only CW for 90/150 days.

2020-05-15 KP edit: these are resolved:

2. why are there two files named CPCRW_CW_subsampling_weights_6.26 in Google Drive?

3. CPCRW_CW_subsampling_weights_6.26 >> CW moisture cleaning 3.1 fix formatting, especially for vertically merged cells. fucks up the R coding 3.2 cells are greyed out for Core 27 and Core 55. WHYYYYYY 3.3 remove the calculated columns L-N 3.4 some samples have highly variable moisture across the replicates. currently coded by color (my bad). need to flag them separately and then decide how to proceed. maybe do in R? easier to manually do in Excel. 3.5 remove random rows repeating the header. WTF

4. CPCRW_CW_subsampling_weights_6.26 >> CW subsampling cleaning 4.1 remove color coding for "problem" samples 4.2 remove random rows repeating the header. WTF

[kaizadp]

to-do for SR Picarro:

• [x] corekey looks ok
• [x] INITIAL CORE WEIGHTS ???????
• [x] grav moisture -- fix moisture file
• [x] dry weights - fix raw weights file

[kaizadp]

CHECK

• CPCRW: core 26: check raw weights (deconstruction): 5cm to end. pre-sieved was ~109g, post-sieved was 7 g. But there was enough soil for subsampling???