knitr::opts_chunk$set(echo = TRUE)
source("code/0-packages.R")
grav_data_0to5 = read.csv("raw/FTC_t0_1_2_5_grav.csv")
print(grav_data_0to5)
## Tin_num ti_.wt_g sample tinwt_plus_wetsoil_g
## 1 1 0.9812 Rooney_H1_depth1_T0 5.7856
## 2 2 0.9726 Rooney_H1_depth2_T0 3.9859
## 3 3 1.0007 Rooney_H1_depth3_T0 4.1146
## 4 4 0.9835 Rooney_H2_depth1_T0 2.1679
## 5 5 0.9832 Rooney_H2_depth2_T0 5.3560
## 6 6 0.9681 Rooney_H2_depth3_T0 5.3268
## 7 7 0.9670 Rooney_H3_depth1_T0 4.8815
## 8 8 0.9840 Rooney_H3_depth2_T0 4.0049
## 9 9 0.9700 Rooney_H3_depth3_T0 5.9855
## 10 10 0.9983 Rooney_D1_depth1_T0 7.5944
## 11 11 1.0021 Rooney_D1_depth2_T0 4.0346
## 12 12 1.0060 Rooney_D2_depth1_T0 6.2270
## 13 13 1.0066 Rooney_D2_depth2_T0 4.1898
## 14 14 1.0195 Rooney_D3_depth1_T0 5.0673
## 15 15 1.0071 Rooney_D3_depth2_T0 3.9418
## 16 16 1.0139 Rooney_M1_depth1_T0 3.9741
## 17 17 1.0048 Rooney_M1_depth2_T0 6.0458
## 18 18 1.0070 Rooney_M2_depth1_T0 5.0849
## 19 19 1.0075 Rooney_M2_depth2_T0 5.5268
## 20 20 1.0057 Rooney_M3_depth1_T0 6.5045
## 21 21 1.0023 Rooney_M3_depth2_T0 6.4989
## 22 22 1.0167 Rooney_H1_depth1_FTC1 4.0533
## 23 23 0.9808 Rooney_H1_depth2_FTC1 9.3624
## 24 24 0.9645 Rooney_H1_depth3_FTC1 5.6022
## 25 25 1.0122 Rooney_H2_depth1_FTC1 3.8142
## 26 26 0.9948 Rooney_H2_depth2_FTC1 14.0655
## 27 27 1.0074 Rooney_H2_depth3_FTC1 2.4163
## 28 28 0.9972 Rooney_H3_depth1_FTC1 4.8863
## 29 29 1.0049 Rooney_H3_depth2_FTC1 6.4857
## 30 30 1.0000 Rooney_H3_depth3_FTC1 6.2079
## 31 31 0.9795 Rooney_H1_depth1_FTC2 2.6946
## 32 32 0.9921 Rooney_H1_depth2_FTC2 3.2790
## 33 33 0.9937 Rooney_H1_depth3_FTC2 12.9156
## 34 34 1.0261 Rooney_H2_depth1_FTC2 4.8375
## 35 35 1.0164 Rooney_H2_depth2_FTC2 9.3176
## 36 36 1.0240 Rooney_H2_depth3_FTC2 7.1249
## 37 37 0.9928 Rooney_H3_depth1_FTC2 2.6723
## 38 38 0.9892 Rooney_H3_depth2_FTC2 3.3290
## 39 39 0.9965 Rooney_H3_depth3_FTC2 21.2361
## 40 40 0.9852 Rooney_H1_depth1_FTC5 4.8240
## 41 41 1.0288 Rooney_H1_depth2_FTC5 8.4491
## 42 42 0.9699 Rooney_H1_depth3_FTC5 4.9985
## 43 43 0.9993 Rooney_H2_depth1_FTC5 6.8166
## 44 44 0.9718 Rooney_H2_depth2_FTC5 8.2318
## 45 45 0.9655 Rooney_H2_depth3_FTC5 6.5514
## 46 46 0.9663 Rooney_H3_depth1_FTC5 7.8548
## 47 47 0.9610 Rooney_H3_depth2_FTC5 6.9048
## 48 48 1.0009 Rooney_H3_depth3_FTC5 3.8806
## 49 49 0.9875 NA
## 50 50 0.9637 NA
## tinwt_plus_ovendrysoil
## 1 2.0078
## 2 1.8269
## 3 1.8969
## 4 1.1336
## 5 2.8540
## 6 2.5462
## 7 1.8709
## 8 2.4597
## 9 2.0559
## 10 2.4350
## 11 2.1449
## 12 1.6893
## 13 1.8418
## 14 1.6720
## 15 1.9575
## 16 1.5752
## 17 2.1991
## 18 4.0908
## 19 4.1097
## 20 5.2274
## 21 5.4470
## 22 1.3633
## 23 3.7291
## 24 1.8652
## 25 1.7278
## 26 6.7709
## 27 1.4874
## 28 1.8036
## 29 3.0578
## 30 2.6295
## 31 1.2529
## 32 1.6495
## 33 2.5962
## 34 1.7414
## 35 4.2643
## 36 3.2301
## 37 1.2902
## 38 1.7241
## 39 4.3539
## 40 1.7472
## 41 3.3212
## 42 1.4802
## 43 2.3691
## 44 3.8028
## 45 2.5937
## 46 2.1912
## 47 4.1737
## 48 2.0758
## 49 NA
## 50 NA
grav_data_0to5_calcs =
grav_data_0to5 %>%
janitor::clean_names() %>%
mutate(wet_weight = tinwt_plus_wetsoil_g - ti_wt_g,
dry_weight = tinwt_plus_ovendrysoil - ti_wt_g) %>%
mutate(wet_dry_diff = wet_weight - dry_weight) %>%
mutate(grav_moisture_percent = (wet_dry_diff/dry_weight)*100)
print(grav_data_0to5_calcs)
## tin_num ti_wt_g sample tinwt_plus_wetsoil_g
## 1 1 0.9812 Rooney_H1_depth1_T0 5.7856
## 2 2 0.9726 Rooney_H1_depth2_T0 3.9859
## 3 3 1.0007 Rooney_H1_depth3_T0 4.1146
## 4 4 0.9835 Rooney_H2_depth1_T0 2.1679
## 5 5 0.9832 Rooney_H2_depth2_T0 5.3560
## 6 6 0.9681 Rooney_H2_depth3_T0 5.3268
## 7 7 0.9670 Rooney_H3_depth1_T0 4.8815
## 8 8 0.9840 Rooney_H3_depth2_T0 4.0049
## 9 9 0.9700 Rooney_H3_depth3_T0 5.9855
## 10 10 0.9983 Rooney_D1_depth1_T0 7.5944
## 11 11 1.0021 Rooney_D1_depth2_T0 4.0346
## 12 12 1.0060 Rooney_D2_depth1_T0 6.2270
## 13 13 1.0066 Rooney_D2_depth2_T0 4.1898
## 14 14 1.0195 Rooney_D3_depth1_T0 5.0673
## 15 15 1.0071 Rooney_D3_depth2_T0 3.9418
## 16 16 1.0139 Rooney_M1_depth1_T0 3.9741
## 17 17 1.0048 Rooney_M1_depth2_T0 6.0458
## 18 18 1.0070 Rooney_M2_depth1_T0 5.0849
## 19 19 1.0075 Rooney_M2_depth2_T0 5.5268
## 20 20 1.0057 Rooney_M3_depth1_T0 6.5045
## 21 21 1.0023 Rooney_M3_depth2_T0 6.4989
## 22 22 1.0167 Rooney_H1_depth1_FTC1 4.0533
## 23 23 0.9808 Rooney_H1_depth2_FTC1 9.3624
## 24 24 0.9645 Rooney_H1_depth3_FTC1 5.6022
## 25 25 1.0122 Rooney_H2_depth1_FTC1 3.8142
## 26 26 0.9948 Rooney_H2_depth2_FTC1 14.0655
## 27 27 1.0074 Rooney_H2_depth3_FTC1 2.4163
## 28 28 0.9972 Rooney_H3_depth1_FTC1 4.8863
## 29 29 1.0049 Rooney_H3_depth2_FTC1 6.4857
## 30 30 1.0000 Rooney_H3_depth3_FTC1 6.2079
## 31 31 0.9795 Rooney_H1_depth1_FTC2 2.6946
## 32 32 0.9921 Rooney_H1_depth2_FTC2 3.2790
## 33 33 0.9937 Rooney_H1_depth3_FTC2 12.9156
## 34 34 1.0261 Rooney_H2_depth1_FTC2 4.8375
## 35 35 1.0164 Rooney_H2_depth2_FTC2 9.3176
## 36 36 1.0240 Rooney_H2_depth3_FTC2 7.1249
## 37 37 0.9928 Rooney_H3_depth1_FTC2 2.6723
## 38 38 0.9892 Rooney_H3_depth2_FTC2 3.3290
## 39 39 0.9965 Rooney_H3_depth3_FTC2 21.2361
## 40 40 0.9852 Rooney_H1_depth1_FTC5 4.8240
## 41 41 1.0288 Rooney_H1_depth2_FTC5 8.4491
## 42 42 0.9699 Rooney_H1_depth3_FTC5 4.9985
## 43 43 0.9993 Rooney_H2_depth1_FTC5 6.8166
## 44 44 0.9718 Rooney_H2_depth2_FTC5 8.2318
## 45 45 0.9655 Rooney_H2_depth3_FTC5 6.5514
## 46 46 0.9663 Rooney_H3_depth1_FTC5 7.8548
## 47 47 0.9610 Rooney_H3_depth2_FTC5 6.9048
## 48 48 1.0009 Rooney_H3_depth3_FTC5 3.8806
## 49 49 0.9875 NA
## 50 50 0.9637 NA
## tinwt_plus_ovendrysoil wet_weight dry_weight wet_dry_diff
## 1 2.0078 4.8044 1.0266 3.7778
## 2 1.8269 3.0133 0.8543 2.1590
## 3 1.8969 3.1139 0.8962 2.2177
## 4 1.1336 1.1844 0.1501 1.0343
## 5 2.8540 4.3728 1.8708 2.5020
## 6 2.5462 4.3587 1.5781 2.7806
## 7 1.8709 3.9145 0.9039 3.0106
## 8 2.4597 3.0209 1.4757 1.5452
## 9 2.0559 5.0155 1.0859 3.9296
## 10 2.4350 6.5961 1.4367 5.1594
## 11 2.1449 3.0325 1.1428 1.8897
## 12 1.6893 5.2210 0.6833 4.5377
## 13 1.8418 3.1832 0.8352 2.3480
## 14 1.6720 4.0478 0.6525 3.3953
## 15 1.9575 2.9347 0.9504 1.9843
## 16 1.5752 2.9602 0.5613 2.3989
## 17 2.1991 5.0410 1.1943 3.8467
## 18 4.0908 4.0779 3.0838 0.9941
## 19 4.1097 4.5193 3.1022 1.4171
## 20 5.2274 5.4988 4.2217 1.2771
## 21 5.4470 5.4966 4.4447 1.0519
## 22 1.3633 3.0366 0.3466 2.6900
## 23 3.7291 8.3816 2.7483 5.6333
## 24 1.8652 4.6377 0.9007 3.7370
## 25 1.7278 2.8020 0.7156 2.0864
## 26 6.7709 13.0707 5.7761 7.2946
## 27 1.4874 1.4089 0.4800 0.9289
## 28 1.8036 3.8891 0.8064 3.0827
## 29 3.0578 5.4808 2.0529 3.4279
## 30 2.6295 5.2079 1.6295 3.5784
## 31 1.2529 1.7151 0.2734 1.4417
## 32 1.6495 2.2869 0.6574 1.6295
## 33 2.5962 11.9219 1.6025 10.3194
## 34 1.7414 3.8114 0.7153 3.0961
## 35 4.2643 8.3012 3.2479 5.0533
## 36 3.2301 6.1009 2.2061 3.8948
## 37 1.2902 1.6795 0.2974 1.3821
## 38 1.7241 2.3398 0.7349 1.6049
## 39 4.3539 20.2396 3.3574 16.8822
## 40 1.7472 3.8388 0.7620 3.0768
## 41 3.3212 7.4203 2.2924 5.1279
## 42 1.4802 4.0286 0.5103 3.5183
## 43 2.3691 5.8173 1.3698 4.4475
## 44 3.8028 7.2600 2.8310 4.4290
## 45 2.5937 5.5859 1.6282 3.9577
## 46 2.1912 6.8885 1.2249 5.6636
## 47 4.1737 5.9438 3.2127 2.7311
## 48 2.0758 2.8797 1.0749 1.8048
## 49 NA NA NA NA
## 50 NA NA NA NA
## grav_moisture_percent
## 1 367.99143
## 2 252.72153
## 3 247.45593
## 4 689.07395
## 5 133.73958
## 6 176.19923
## 7 333.06782
## 8 104.70963
## 9 361.87494
## 10 359.11464
## 11 165.35702
## 12 664.08605
## 13 281.13027
## 14 520.35249
## 15 208.78577
## 16 427.38286
## 17 322.08825
## 18 32.23620
## 19 45.68048
## 20 30.25085
## 21 23.66639
## 22 776.11079
## 23 204.97398
## 24 414.89952
## 25 291.55953
## 26 126.28936
## 27 193.52083
## 28 382.27927
## 29 166.97842
## 30 219.60110
## 31 527.32260
## 32 247.87040
## 33 643.95632
## 34 432.83937
## 35 155.58669
## 36 176.54685
## 37 464.72764
## 38 218.38345
## 39 502.83553
## 40 403.77953
## 41 223.69133
## 42 689.45718
## 43 324.68244
## 44 156.44649
## 45 243.07210
## 46 462.37244
## 47 85.00949
## 48 167.90399
## 49 NA
## 50 NA
gravimetric_moisture =
grav_data_0to5_calcs %>%
dplyr::select(sample, grav_moisture_percent)
print(gravimetric_moisture)
## sample grav_moisture_percent
## 1 Rooney_H1_depth1_T0 367.99143
## 2 Rooney_H1_depth2_T0 252.72153
## 3 Rooney_H1_depth3_T0 247.45593
## 4 Rooney_H2_depth1_T0 689.07395
## 5 Rooney_H2_depth2_T0 133.73958
## 6 Rooney_H2_depth3_T0 176.19923
## 7 Rooney_H3_depth1_T0 333.06782
## 8 Rooney_H3_depth2_T0 104.70963
## 9 Rooney_H3_depth3_T0 361.87494
## 10 Rooney_D1_depth1_T0 359.11464
## 11 Rooney_D1_depth2_T0 165.35702
## 12 Rooney_D2_depth1_T0 664.08605
## 13 Rooney_D2_depth2_T0 281.13027
## 14 Rooney_D3_depth1_T0 520.35249
## 15 Rooney_D3_depth2_T0 208.78577
## 16 Rooney_M1_depth1_T0 427.38286
## 17 Rooney_M1_depth2_T0 322.08825
## 18 Rooney_M2_depth1_T0 32.23620
## 19 Rooney_M2_depth2_T0 45.68048
## 20 Rooney_M3_depth1_T0 30.25085
## 21 Rooney_M3_depth2_T0 23.66639
## 22 Rooney_H1_depth1_FTC1 776.11079
## 23 Rooney_H1_depth2_FTC1 204.97398
## 24 Rooney_H1_depth3_FTC1 414.89952
## 25 Rooney_H2_depth1_FTC1 291.55953
## 26 Rooney_H2_depth2_FTC1 126.28936
## 27 Rooney_H2_depth3_FTC1 193.52083
## 28 Rooney_H3_depth1_FTC1 382.27927
## 29 Rooney_H3_depth2_FTC1 166.97842
## 30 Rooney_H3_depth3_FTC1 219.60110
## 31 Rooney_H1_depth1_FTC2 527.32260
## 32 Rooney_H1_depth2_FTC2 247.87040
## 33 Rooney_H1_depth3_FTC2 643.95632
## 34 Rooney_H2_depth1_FTC2 432.83937
## 35 Rooney_H2_depth2_FTC2 155.58669
## 36 Rooney_H2_depth3_FTC2 176.54685
## 37 Rooney_H3_depth1_FTC2 464.72764
## 38 Rooney_H3_depth2_FTC2 218.38345
## 39 Rooney_H3_depth3_FTC2 502.83553
## 40 Rooney_H1_depth1_FTC5 403.77953
## 41 Rooney_H1_depth2_FTC5 223.69133
## 42 Rooney_H1_depth3_FTC5 689.45718
## 43 Rooney_H2_depth1_FTC5 324.68244
## 44 Rooney_H2_depth2_FTC5 156.44649
## 45 Rooney_H2_depth3_FTC5 243.07210
## 46 Rooney_H3_depth1_FTC5 462.37244
## 47 Rooney_H3_depth2_FTC5 85.00949
## 48 Rooney_H3_depth3_FTC5 167.90399
## 49 NA
## 50 NA
write.csv(gravimetric_moisture, "processed/grav_moisture_FTC_t0_1_2_5.csv")