批量处理 LI-6800 的数据

祝介东

2018/11/27

对于多数人来讲,一个季节用光合仪测量的数据文件至少是两位数的,如果处理起来非常不方便,于是今天费了半晚上的时间,简单写了一个批量读取 6800 原始数据的包,使用非常简单:

安装

devtools::install_github("zhujiedong/readphoto")

6800 数据整合

library(readphoto)
df <- read_bat_6800("./data/6800", skiplines = 53)
df[1:15,]
##    obs       time elapsed              date plot plant       TIME
## 1    1 1513614617     0.0 20171218 10:30:16    1     1 1513614617
## 2    2 1513614731   114.0 20171218 10:32:10    1     1 1513614731
## 3    3 1513614886   269.0 20171218 10:34:45    1     1 1513614886
## 4    4 1513615008   391.0 20171218 10:36:47    1     1 1513615008
## 5    5 1513615127   510.0 20171218 10:38:46    1     1 1513615127
## 6    6 1513615287   670.5 20171218 10:41:27    1     1 1513615287
## 7    7 1513615410   793.0 20171218 10:43:29    1     1 1513615410
## 8    8 1513615566   949.0 20171218 10:46:05    1     1 1513615566
## 9    9 1513615701  1084.0 20171218 10:48:20    1     1 1513615701
## 10  10 1513615831  1214.0 20171218 10:50:30    1     1 1513615831
## 11  11 1513615940  1323.0 20171218 10:52:19    1     1 1513615940
## 12  12 1513616064  1447.4 20171218 10:54:24    1     1 1513616064
## 13   1 1513612721     0.0 20171218 09:58:40    1     1 1513612721
## 14   2 1513612832   111.0 20171218 10:00:31    1     1 1513612832
## 15   3 1513612941   220.0 20171218 10:02:20    1     1 1513612941
##              E          A        Ca         Ci        Pci        Pca
## 1  0.004572625 24.7381184  377.2420  231.21258  23.480602  38.310497
## 2  0.004716209 18.1379358  283.3320  177.59661  18.036160  28.774317
## 3  0.004972853 10.8055345  189.9250  127.59810  12.957453  19.286683
## 4  0.005263165  3.0239340   96.9793   78.88291   8.010456   9.848120
## 5  0.005361913 -0.9144044   50.5697   53.73937   5.456793   5.134939
## 6  0.005390857 26.9519572  375.1860  239.36541  24.307391  38.099875
## 7  0.005224151 27.5088717  374.7070  239.90519  24.363619  38.053441
## 8  0.005215787 40.9101889  562.4100  363.19442  36.881421  57.111225
## 9  0.005394692 50.1393342  753.5289  506.34634  51.415265  76.514605
## 10 0.005490842 55.3865984  948.0019  665.60434  67.587570  96.263115
## 11 0.005386037 58.0662751 1144.9799  835.18779  84.811968 116.270859
## 12 0.005215889 59.3556428 1442.5899 1106.40723 112.353761 146.492539
## 13 0.006743924 32.4442919  370.0650  260.39836  26.435607  37.568945
## 14 0.006595533 31.7559713  370.6780  263.88851  26.786661  37.626590
## 15 0.006449253 30.8954954  371.4540  266.54153  27.056326  37.705868
##          gsw      gbw       gtw       gtc     Rabs  TleafEB TleafCnd
## 1  0.3043718 2.281382 0.2834781 0.1789313 289.4840 27.59813  26.0080
## 2  0.3095819 2.283519 0.2880127 0.1818205 289.5243 27.79574  26.2524
## 3  0.3172168 2.284847 0.2946244 0.1860358 289.5158 28.10854  26.6891
## 4  0.3293625 2.279137 0.3050218 0.1926754 289.4792 28.33561  27.0532
## 5  0.3432104 2.282424 0.3169024 0.2002594 289.5026 28.21844  26.8767
## 6  0.3623104 2.283108 0.3331341 0.2106341 289.4936 27.84052  26.4112
## 7  0.3721794 2.285401 0.3414922 0.2159785 289.5126 27.20357  25.5778
## 8  0.3749797 2.283367 0.3438244 0.2174733 289.4781 27.02008  25.3616
## 9  0.3733265 2.284633 0.3424488 0.2165915 289.5201 27.40937  25.8553
## 10 0.3644496 2.287160 0.3349905 0.2118170 289.4908 27.73144  26.3405
## 11 0.3512177 2.288006 0.3237819 0.2046498 289.4967 27.92964  26.5675
## 12 0.3359745 2.286158 0.3107583 0.1963316 289.4919 28.12754  26.7022
## 13 0.5630383 2.282713 0.4957738 0.3152299 321.4359 25.43036  23.8649
## 14 0.5664270 2.285210 0.4984674 0.3169660 289.4807 25.04033  23.5525
## 15 0.5607485 2.283992 0.4940280 0.3140981 241.6739 24.75876  23.4143
##     SVPleaf   RHcham   VPcham  SVPcham  VPDleaf  LatHFlux SenHFlux
## 1  3.375856 49.87219 1.779321 3.567761 1.596536 -201.6528 115.3313
## 2  3.424984 49.86424 1.804808 3.619444 1.620176 -207.9848 115.5133
## 3  3.514323 49.81722 1.845551 3.704644 1.668772 -219.3028 110.7271
## 4  3.590358 49.94574 1.885373 3.774843 1.704985 -232.1056 105.2037
## 5  3.553322 50.08245 1.881235 3.756275 1.672087 -236.4603 116.6761
## 6  3.457239 50.51179 1.856941 3.676252 1.600298 -237.7368 128.6627
## 7  3.290874 50.31189 1.776038 3.530056 1.514836 -230.3850 146.2756
## 8  3.248875 50.01534 1.746299 3.491527 1.502576 -230.0162 149.8138
## 9  3.345475 49.83022 1.786281 3.584734 1.559194 -237.9059 144.2557
## 10 3.442846 49.77067 1.821593 3.659973 1.621253 -242.1461 128.2623
## 11 3.489244 49.91136 1.844372 3.695296 1.644872 -237.5242 120.5509
## 12 3.517034 49.85649 1.857714 3.726123 1.659320 -230.0207 121.3656
## 13 2.970755 50.22231 1.621029 3.227706 1.349726 -297.4071 170.6674
## 14 2.915406 50.23651 1.602184 3.189282 1.313221 -290.8630 184.5663
## 15 2.891209 49.94550 1.595354 3.194190 1.295855 -284.4121 204.6620
##    NetTherm    EBSum      blfa_1     blfa_2   blfa_3 Leak LeakPct CorrFact
## 1  10.85304 214.0156 -0.04203399 0.04718684 3.511485  310      44        1
## 2  10.88663 207.9394 -0.04209230 0.04725229 3.515328  308      44        1
## 3  10.47308 191.4132 -0.04212855 0.04729299 3.517717  304      43        1
## 4  10.00979 172.5871 -0.04197279 0.04711814 3.507448  299      43        1
## 5  11.07093 180.7892 -0.04206242 0.04721875 3.513359  298      43        1
## 6  12.15389 192.5734 -0.04208106 0.04723968 3.514588  293      42        1
## 7  13.69880 219.1019 -0.04214368 0.04730997 3.518714  293      42        1
## 8  14.01433 223.2900 -0.04208815 0.04724764 3.515055  295      42        1
## 9  13.55073 209.4206 -0.04212270 0.04728642 3.517332  296      42        1
## 10 12.08573 187.6927 -0.04219173 0.04736392 3.521879  295      42        1
## 11 11.37715 183.9005 -0.04221486 0.04738988 3.523402  294      42        1
## 12 11.47916 192.3159 -0.04216435 0.04733317 3.520075  293      42        1
## 13 15.74451 210.4407 -0.04207029 0.04722758 3.513878  335      48        1
## 14 16.96414 200.1481 -0.04213846 0.04730411 3.518370  337      48        1
## 15 18.81059 180.7344 -0.04210520 0.04726678 3.516179  335      48        1
##    CorrFactPct   Fan               DarkAdaptedID     Fo      Fm      Fv
## 1            0 53613 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 2            0 53641 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 3            0 53614 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 4            0 53367 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 5            0 53491 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 6            0 53579 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 7            0 53780 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 8            0 53745 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 9            0 53707 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 10           0 53728 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 11           0 53727 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 12           0 53640 RECT-1241-20171205-12_54_10 710.75 3267.12 2556.37
## 13           0 53962                           -   0.00    0.00    0.00
## 14           0 54082                           -   0.00    0.00    0.00
## 15           0 54036                           -   0.00    0.00    0.00
##        Fv.Fm     Adark              LightAdaptedID        Fs      Fm.
## 1  0.7824537 -3.251998 RECT-1242-20171205-13_04_35  840.8504 1159.130
## 2  0.7824537 -3.251998 RECT-1244-20171205-13_06_29  798.1235 1070.600
## 3  0.7824537 -3.251998 RECT-1246-20171205-13_09_04  778.1266 1008.670
## 4  0.7824537 -3.251998 RECT-1248-20171205-13_11_06  770.8055  957.616
## 5  0.7824537 -3.251998 RECT-1250-20171205-13_13_05  771.6944  928.064
## 6  0.7824537 -3.251998 RECT-1252-20171205-13_15_46  841.3228 1155.740
## 7  0.7824537 -3.251998 RECT-1254-20171205-13_17_48  829.7272 1147.660
## 8  0.7824537 -3.251998 RECT-1256-20171205-13_20_24  962.8020 1410.620
## 9  0.7824537 -3.251998 RECT-1258-20171205-13_22_39 1035.3277 1578.690
## 10 0.7824537 -3.251998 RECT-1260-20171205-13_24_49 1045.2373 1622.840
## 11 0.7824537 -3.251998 RECT-1262-20171205-13_26_38 1024.9304 1594.490
## 12 0.7824537 -3.251998 RECT-1264-20171205-13_28_43  990.6899 1526.450
## 13 0.0000000  0.000000 RECT-1217-20171205-12_32_59  881.6115 1196.430
## 14 0.0000000  0.000000 RECT-1219-20171205-12_34_50  890.0579 1249.210
## 15 0.0000000  0.000000 RECT-1221-20171205-12_36_39  916.0870 1381.180
##       PhiPS2 PS2.1  Qabs_fs        Afs      ETR   Fv..Fm.      PhiCO2
## 1  0.2745849   0.5 1513.087 24.7381184 207.7355 0.4742609 0.018498680
## 2  0.2545083   0.5 1513.305 18.1379358 192.5743 0.4466654 0.014134582
## 3  0.2285618   0.5 1513.263 10.8055345 172.9370 0.4235974 0.009289552
## 4  0.1950787   0.5 1513.062  3.0239340 147.5831 0.3903611 0.004147835
## 5  0.1684901   0.5 1513.188 -0.9144044 127.4786 0.3815082 0.001544814
## 6  0.2720483   0.5 1513.138 26.9519572 205.8233 0.4843131 0.019961142
## 7  0.2770270   0.5 1513.246 27.5088717 209.6050 0.4855619 0.020327740
## 8  0.3174618   0.5 1513.061 40.9101889 240.1696 0.5455899 0.029187306
## 9  0.3441856   0.5 1513.280 50.1393342 260.4246 0.5692631 0.035281857
## 10 0.3559209   0.5 1513.129 55.3865984 269.2771 0.5817209 0.038753214
## 11 0.3572049   0.5 1513.162 58.0662751 270.2544 0.5693921 0.040523273
## 12 0.3509844   0.5 1513.137 59.3556428 265.5437 0.5591077 0.041376064
## 13 0.2631316   0.5 1681.150 32.4442919 221.1818 0.4954991 0.019298873
## 14 0.2875034   0.5 1513.078 31.7559713 217.5075 0.5016050 0.020987664
## 15 0.3367360   0.5 1261.222 30.8954954 212.3495 0.5453163 0.024496467
##          NPQ                 DarkPulseID   Fo.     Fv.        qP        qN
## 1   1.818597 DARK-1243-20171205-13_04_37 609.4 549.730 0.5789744 0.7931573
## 2   2.051672 DARK-1245-20171205-13_06_31 592.4 478.200 0.5697962 0.8212149
## 3   2.239038 DARK-1247-20171205-13_09_06 581.4 427.270 0.5395731 0.8409104
## 4   2.411722 DARK-1249-20171205-13_11_08 583.8 373.816 0.4997392 0.8606890
## 5   2.520361 DARK-1251-20171205-13_13_07 574.0 354.064 0.4416422 0.8685302
## 6   1.826864 DARK-1253-20171205-13_15_48 596.0 559.740 0.5617200 0.7904475
## 7   1.846766 DARK-1255-20171205-13_17_50 590.4 557.260 0.5705286 0.7918124
## 8   1.316088 DARK-1257-20171205-13_20_26 641.0 769.620 0.5818690 0.7069365
## 9   1.069513 DARK-1259-20171205-13_22_41 680.0 898.690 0.6046159 0.6526292
## 10  1.013211 DARK-1261-20171205-13_24_51 678.8 944.040 0.6118413 0.6352692
## 11  1.049006 DARK-1263-20171205-13_26_40 686.6 907.890 0.6273443 0.6481756
## 12  1.140339 DARK-1265-20171205-13_28_45 673.0 853.450 0.6277581 0.6710060
## 13 -1.000000 DARK-1218-20171205-12_33_01 603.6 592.830 0.5310435 1.9821571
## 14 -1.000000 DARK-1220-20171205-12_34_52 622.6 626.610 0.5731669 2.0064407
## 15 -1.000000 DARK-1222-20171205-12_36_41 628.0 753.180 0.6175058 2.1993312
##        qP_Fo     qN_Fo     Qin     Qabs     alpha   convert S   K
## 1  0.7098435 0.8246029 1799.88 1513.087 0.8406600 0.1913201 6 0.5
## 2  0.7571948 0.8592340 1800.14 1513.305 0.8406596 0.1913192 6 0.5
## 3  0.7738433 0.8834597 1800.09 1513.263 0.8406595 0.1913189 6 0.5
## 4  0.7567283 0.9034310 1799.85 1513.062 0.8406601 0.1913201 6 0.5
## 5  0.7195561 0.9149912 1800.00 1513.188 0.8406598 0.1913197 6 0.5
## 6  0.7065713 0.8259290 1799.94 1513.138 0.8406600 0.1913200 6 0.5
## 7  0.7276848 0.8290897 1800.07 1513.246 0.8406595 0.1913189 6 0.5
## 8  0.6398588 0.7262251 1799.85 1513.061 0.8406597 0.1913194 6 0.5
## 9  0.6260367 0.6604795 1800.11 1513.280 0.8406598 0.1913196 6 0.5
## 10 0.6332738 0.6432089 1799.93 1513.129 0.8406597 0.1913194 6 0.5
## 11 0.6444878 0.6542989 1799.97 1513.162 0.8406595 0.1913190 6 0.5
## 12 0.6568102 0.6809147 1799.94 1513.137 0.8406595 0.1913190 6 0.5
## 13 0.2631316 0.0000000 1999.94 1681.150 0.8406000 0.1912000 6 0.5
## 14 0.2875034 0.0000000 1799.87 1513.078 0.8406595 0.1913191 6 0.5
## 15 0.3367360 0.0000000 1500.01 1261.222 0.8408094 0.1916188 6 0.5
##        Geometry     TIME.1     CO2_s     CO2_r   H2O_s   H2O_r    Flow
## 1  0: Broadleaf 1513614617  377.2420  399.9210 17.5209 13.6708 700.113
## 2  0: Broadleaf 1513614731  283.3320  300.0270 17.7714 13.8001 699.881
## 3  0: Broadleaf 1513614886  189.9250  199.9960 18.1740 13.9892 700.030
## 4  0: Broadleaf 1513615008   96.9793  100.0090 18.5662 14.1383 699.941
## 5  0: Broadleaf 1513615127   50.5697   50.0183 18.5267 14.0156 699.950
## 6  0: Broadleaf 1513615287  375.1860  400.0200 18.2861 13.7501 700.037
## 7  0: Broadleaf 1513615410  374.7070  399.9620 17.4884 13.0892 700.053
## 8  0: Broadleaf 1513615566  562.4100  599.9920 17.1969 12.8029 699.967
## 9  0: Broadleaf 1513615701  753.5290  799.9840 17.5916 13.0495 700.089
## 10 0: Broadleaf 1513615831  948.0020  999.9300 17.9391 13.3178 700.107
## 11 0: Broadleaf 1513615940 1144.9800 1200.0400 18.1625 13.6295 699.962
## 12 0: Broadleaf 1513616064 1442.5900 1499.9200 18.2939 13.9046 699.948
## 13 0: Broadleaf 1513612721  370.0650  400.0130 15.9676 10.2795 700.013
## 14 0: Broadleaf 1513612832  370.6780  399.9920 15.7839 10.2200 700.023
## 15 0: Broadleaf 1513612941  371.4540  399.9900 15.7164 10.2752 699.981
##         Pa   螖Pcham    Tair   Tleaf Tleaf2 Fan_speed Qamb_in Qamb_out
## 1  101.532 0.0221745 26.9457 26.0080  999.9   9983.75       0 299.5580
## 2  101.533 0.0238972 27.1907 26.2524  999.9   9997.50       0 297.3100
## 3  101.525 0.0239472 27.5880 26.6891  999.9  10006.90       0 304.6140
## 4  101.524 0.0246883 27.9094 27.0532  999.9   9970.00       0 258.3330
## 5  101.518 0.0238141 27.8249 26.8767  999.9   9991.88       0 326.0810
## 6  101.525 0.0243074 27.4565 26.4112  999.9   9995.62       0 164.3060
## 7  101.530 0.0251991 26.7650 25.5778  999.9  10010.00       0  35.5527
## 8  101.523 0.0243226 26.5786 25.3616  999.9   9997.50       0 346.5740
## 9  101.518 0.0236938 27.0265 25.8553  999.9  10006.20       0 357.5920
## 10 101.519 0.0241628 27.3807 26.3405  999.9  10022.50       0 362.6650
## 11 101.524 0.0243814 27.5448 26.5675  999.9  10027.50       0 374.1720
## 12 101.523 0.0252887 27.6869 26.7022  999.9  10015.60       0 372.9430
## 13 101.499 0.0208647 25.2517 23.8649  999.9   9995.62       0  83.8536
## 14 101.486 0.0214908 25.0506 23.5525  999.9  10013.10       0 187.7590
## 15 101.488 0.0208579 25.0764 23.4143  999.9  10005.00       0 268.8550
##          Q    f_red    f_blue f_farred        F Q_modavg    F_dc      Pc
## 1  1799.88 0.977989 0.0220110        0  840.133  1.00007 15502.0 14643.1
## 2  1800.14 0.977999 0.0220008        0  797.547  1.00007 14740.7 14645.3
## 3  1800.09 0.978006 0.0219940        0  778.236  1.00007 14414.1 14644.9
## 4  1799.85 0.977989 0.0220115        0  771.281  1.00007 14181.8 14642.9
## 5  1800.00 0.977992 0.0220081        0  771.318  1.00007 14261.6 14644.1
## 6  1799.94 0.977989 0.0220115        0  840.177  1.00007 15398.7 14643.6
## 7  1800.07 0.978006 0.0219940        0  829.838  1.00007 15188.0 14644.7
## 8  1799.85 0.977996 0.0220042        0  964.187  1.00007 17617.9 14642.9
## 9  1800.11 0.977996 0.0220042        0 1036.390  1.00007 19086.0 14645.1
## 10 1799.93 0.977999 0.0220008        0 1045.120  1.00007 19375.2 14643.6
## 11 1799.97 0.978003 0.0219974        0 1024.770  1.00007 19029.4 14643.9
## 12 1799.94 0.978006 0.0219940        0  987.542  1.00007 18329.6 14643.7
## 13 1999.94 0.979992 0.0200084        0  882.191  1.00007 17760.7 16280.2
## 14 1799.87 0.978004 0.0219964        0  890.102  1.00007 16250.6 14643.2
## 15 1500.01 0.973004 0.0269964        0  916.940  1.00007 14141.5 12186.1
##      Tled TDigital TPreamp TPwrSpy TDrive   Q_red Q_blue Q_farred  TSPF
## 1  40.375   41.750  40.875  41.437 42.375 1759.28  39.60        0 624.7
## 2  40.812   42.187  41.250  41.875 42.750 1759.56  39.58        0 113.6
## 3  41.375   42.875  41.875  42.562 43.375 1759.52  39.57        0 154.6
## 4  41.937   43.500  42.437  43.187 43.937 1759.26  39.60        0 121.3
## 5  42.250   43.687  42.750  43.375 44.187 1759.41  39.59        0 118.3
## 6  42.312   43.562  42.875  43.312 44.250 1759.34  39.60        0 159.7
## 7  41.875   42.750  42.437  42.500 43.750 1759.50  39.57        0 122.2
## 8  41.312   42.000  41.875  41.687 43.125 1759.27  39.58        0 155.2
## 9  41.250   42.250  41.750  41.812 43.062 1759.52  39.59        0 134.5
## 10 41.375   42.750  41.937  42.125 43.312 1759.35  39.58        0 129.8
## 11 41.625   43.187  42.187  42.500 43.562 1759.40  39.57        0 108.3
## 12 41.937   43.562  42.500  42.875 43.937 1759.37  39.57        0 123.7
## 13 38.875   39.187  39.250  38.812 40.625 1958.95  40.00        0 729.1
## 14 38.437   38.937  38.937  38.625 40.312 1759.30  39.57        0 110.7
## 15 38.000   38.875  38.687  38.687 40.062 1458.54  40.47        0 108.4
##        F_avg       dF.dt   dF_dc.dt F_dc_avg period MatchValveR
## 1   840.8504  -1.4533333 -195.07692 15550.29     15         100
## 2   798.1235  -4.1021539 -111.98291 14746.63     15         100
## 3   778.1266   0.7671795 -112.14701 14422.39     15         100
## 4   770.8055   0.5991453 -650.15726 14300.30     15         100
## 5   771.6944   1.9799658 -326.52991 14316.74     15         100
## 6   841.3228  -4.0073163  -69.16581 15408.10     15         100
## 7   829.7272   1.5483761  -10.59145 15185.45     15         100
## 8   962.8020   7.8442393  189.88376 17598.86     15         100
## 9  1035.3277   8.8369231  467.24444 19045.08     15         100
## 10 1045.2373  -2.3545299  -25.95556 19364.90     15         100
## 11 1024.9304  -2.9035898 -304.93675 18979.25     15         100
## 12  990.6899 -18.3397949 -498.87863 18377.20     15         100
## 13  881.6115  -1.0895384   73.05641 17765.80     15         100
## 14  890.0579   1.1570940 -381.02564 16211.74     15         100
## 15  916.0870   3.9045128 -906.38633 13953.10     15         100
##    MatchValveS MatchCO2 MatchH2O DIAG  Flow_s  Flow_r   Txchg   Tirga
## 1          100   -3.597    0.008    2 381.395 712.766 25.0011 22.7444
## 2          100   -3.546    0.006    2 384.110 711.558 25.0019 22.9230
## 3          100   -3.094    0.010    2 388.338 710.135 25.0023 23.2402
## 4          100   -2.596    0.012    2 393.039 708.376 25.0018 23.5374
## 5          100   -2.544    0.011    2 394.350 705.551 25.0003 23.8214
## 6          100   -3.575    0.009    2 400.017 705.078 24.9966 23.9913
## 7          100   -3.602    0.002    2 400.127 703.619 24.9969 23.8944
## 8          100   -3.787   -0.005    2 397.743 702.850 25.0008 23.8106
## 9          100   -4.228   -0.013    2 396.519 702.877 25.0018 23.8467
## 10         100   -4.522   -0.001    2 398.302 704.546 25.0013 23.8167
## 11         100   -4.688    0.005    2 399.228 707.119 25.0014 23.8006
## 12         100   -5.577    0.013    2 400.642 709.326 25.0016 23.8959
## 13         100   -3.880   -0.048    2 355.548 708.891 24.9999 20.9200
## 14         100   -3.788   -0.051    2 353.997 709.172 25.0003 20.7393
## 15         100   -3.783   -0.048    2 356.109 707.927 25.0020 20.7422
##    Tchopper      Ts      Tr    CO2_. Desiccant_. Humidifier_. Txchg_sp
## 1   30.0006 22.4512 22.3482 25.41630     38.7892            0       25
## 2   30.0006 22.6221 22.5155 20.19470     39.7737            0       25
## 3   30.0009 22.9194 22.8148 14.69620     41.2827            0       25
## 4   30.0011 23.1960 23.0895  8.97621     42.6671            0       25
## 5   30.0007 23.4750 23.3622  6.08506     44.6806            0       25
## 6   30.0002 23.6895 23.5794 25.34120     47.0662            0       25
## 7   29.9998 23.6858 23.5836 25.30680     50.2942            0       25
## 8   30.0001 23.6565 23.5711 35.09120     52.5490            0       25
## 9   30.0000 23.6853 23.5934 44.30570     50.5955            0       25
## 10  30.0001 23.6705 23.5773 53.07610     48.0355            0       25
## 11  30.0000 23.6431 23.5501 61.49630     45.6737            0       25
## 12  30.0005 23.6954 23.6064 73.46440     43.7812            0       25
## 13  29.9994 20.8979 20.8191 25.43570     48.1688            0       25
## 14  29.9995 20.7025 20.6249 25.42700     47.8532            0       25
## 15  30.0006 20.6419 20.5667 25.42230     48.9497            0       25
##    CO2_r_sp H2O_r_sp    SS_s    SS_r  X  NA
## 1       400  13.6523 103.501 100.780 NA aci
## 2       300  13.7082 103.473 100.757 NA aci
## 3       200  13.9520 103.424 100.721 NA aci
## 4       100  14.0570 103.379 100.679 NA aci
## 5        50  13.9467 103.327 100.633 NA aci
## 6       400  13.5988 103.297 100.603 NA aci
## 7       400  13.0226 103.307 100.614 NA aci
## 8       600  12.7456 103.320 100.626 NA aci
## 9       800  13.0809 103.317 100.620 NA aci
## 10     1000  13.4048 103.318 100.623 NA aci
## 11     1200  13.6662 103.324 100.630 NA aci
## 12     1500  13.9635 103.316 100.624 NA aci
## 13      400  10.2085 103.840 101.042 NA lrc
## 14      400  10.2336 103.857 101.058 NA lrc
## 15      400  10.1878 103.857 101.069 NA lrc

其中就两个参数,第一个为 LI-6800 原始数据所在的文件夹,即文件夹内包含且仅包含 LI-6800 的原始数据,不要放其他文件,不要放 excel 数据。第二个参数即为你原始数据中表头所在的参数行的前一行,我使用的这些示例数据的表头在 54 行。 特别需要注意的是,目前路径写法仅支持 “/” 分隔,不能使用 “\“ 作为分隔。例如在数据放在 D 盘的 6800 文件夹下,那么写法应为”d:/6800“, 不能为 “d:\6800”, 尽管后者对 R 是合法的,主要是因为我要区分你不同数据来源的文件是哪个,也即下文提到的 df$Source

数据输出如上所示,如果想另存为 csv 格式:

write.csv(df, "./combined.csv")

其中,数据的来源在表格中最后一列,叫做 Source,是数据来源的文件名(即你起的名字),例如本例中你看到的 aci 是我之前数据里面 aci 响应曲线的数据。

6400 数据整合

df64  <- read_bat_6400("./data/6400", header_line = 17, data_start = 27)
df64[1:15,]
##    Obs   HHMMSS  FTime EBal.  Photo   Cond     Ci Trmmol  VpdL CTleaf Area
## 1    1 10:55:14  483.0     0  6.990 0.0831  251.0  0.456 0.501  21.35    6
## 4    2 10:57:35  623.5     0  5.160 0.0853  192.0  0.465 0.497  21.36    6
## 7    3 10:59:55  763.5     0  3.140 0.0881  136.0  0.476 0.494  21.36    6
## 10   4 11:02:26  914.5     0  0.910 0.0927   81.9  0.496 0.490  21.36    6
## 13   5 11:04:46 1055.0     0 -0.167 0.0966   52.7  0.514 0.487  21.36    6
## 16   6 11:07:23 1211.5     0  5.240 0.1010  305.0  0.532 0.484  21.35    6
## 19   7 11:09:43 1352.0     0  6.610 0.1040  284.0  0.550 0.484  21.36    6
## 22   8 11:12:04 1492.5     0  9.280 0.1050  438.0  0.551 0.483  21.34    6
## 25   9 11:14:24 1633.0     0 10.200 0.1020  616.0  0.538 0.486  21.33    6
## 28  10 11:16:44 1772.5     0 10.500 0.0943  795.0  0.506 0.491  21.32    6
## 31  11 11:19:49 1958.0     0 10.700 0.0853  970.0  0.465 0.497  21.32    6
## 34  12 11:22:09 2097.5     0 11.100 0.0812 1150.0  0.448 0.502  21.33    6
## 41   2 10:12:52  737.5     0  6.450 0.0700  239.0  0.423 0.548  21.09    6
## 44   3 10:15:12  878.0     0  6.450 0.0684  235.0  0.399 0.530  20.99    6
## 47   4 10:17:32 1017.5     0  5.960 0.0655  241.0  0.371 0.514  20.88    6
##    BLC_1 StmRat BLCond  Tair Tleaf  TBlk    CO2R    CO2S   H2OR   H2OS
## 1   1.42      1   2.84 20.52 21.35 20.08  400.11  391.51 22.012 22.547
## 4   1.42      1   2.84 20.53 21.36 20.08  299.93  293.58 22.066 22.611
## 7   1.42      1   2.84 20.53 21.36 20.08  200.16  196.28 22.095 22.653
## 10  1.42      1   2.84 20.53 21.36 20.08   99.98   98.83 22.108 22.690
## 13  1.42      1   2.84 20.53 21.36 20.08   50.16   50.33 22.109 22.712
## 16  1.42      1   2.84 20.53 21.35 20.08  400.05  393.50 22.117 22.740
## 19  1.42      1   2.84 20.53 21.36 20.08  400.08  391.89 22.108 22.753
## 22  1.42      1   2.84 20.52 21.34 20.08  600.07  588.55 22.088 22.734
## 25  1.42      1   2.84 20.52 21.33 20.08  800.05  787.33 22.057 22.687
## 28  1.42      1   2.84 20.51 21.32 20.08 1000.00  986.77 22.016 22.610
## 31  1.42      1   2.84 20.51 21.32 20.08 1200.04 1186.49 21.993 22.539
## 34  1.42      1   2.84 20.51 21.33 20.08 1400.56 1386.46 21.983 22.508
## 41  1.42      1   2.84 20.42 21.09 20.08  399.90  391.97 21.084 21.580
## 44  1.42      1   2.84 20.41 20.99 20.08  399.89  391.97 21.130 21.598
## 47  1.42      1   2.84 20.39 20.88 20.08  399.82  392.50 21.160 21.595
##     RH_R  RH_S  Flow PARi PARo Press  CsMch  HsMch CsMchSD  HsMchSD
## 1  82.53 84.54 500.2  800    0 90.88  1.820 -0.305 0.03860 0.001870
## 4  82.70 84.74 500.2  800    0 90.88  1.680 -0.307 0.03440 0.001150
## 7  82.81 84.90 500.2  800    0 90.88  1.480 -0.309 0.01280 0.001140
## 10 82.85 85.03 500.2  800    0 90.88  1.050 -0.309 0.03030 0.000609
## 13 82.87 85.13 500.2  800    0 90.87  0.782 -0.312 0.00765 0.001010
## 16 82.91 85.24 500.2  800    0 90.87  1.790 -0.308 0.07960 0.001280
## 19 82.87 85.28 500.2  800    0 90.87  1.810 -0.309 0.02250 0.001210
## 22 82.82 85.24 500.2  800    0 90.87  1.900 -0.306 0.05480 0.001600
## 25 82.70 85.06 500.2  800    0 90.86  1.530 -0.304 0.03450 0.001130
## 28 82.58 84.81 500.2  800    0 90.85  1.050 -0.304 0.06070 0.002480
## 31 82.52 84.56 500.2  800    0 90.85  0.374 -0.301 0.07230 0.001120
## 34 82.44 84.41 500.2  800    0 90.84 -0.415 -0.300 0.03970 0.001290
## 41 79.57 81.44 500.2  801    0 90.91  1.610 -0.300 0.05200 0.001850
## 44 79.81 81.58 500.2  599    0 90.91  1.570 -0.301 0.02680 0.000937
## 47 80.02 81.67 500.2  401    0 90.91  1.580 -0.301 0.02380 0.001000
##    CrMchSD  HrMchSD StableF BLCslope BLCoffst f_parin f_parout alphaK
## 1  0.01340 0.001280       1    -0.22     2.74       1        0   0.16
## 4  0.03040 0.000986       1    -0.22     2.74       1        0   0.16
## 7  0.01150 0.000535       1    -0.22     2.74       1        0   0.16
## 10 0.01740 0.001070       1    -0.22     2.74       1        0   0.16
## 13 0.00661 0.001080       1    -0.22     2.74       1        0   0.16
## 16 0.05430 0.000927       1    -0.22     2.74       1        0   0.16
## 19 0.01410 0.002110       1    -0.22     2.74       1        0   0.16
## 22 0.04680 0.001460       1    -0.22     2.74       1        0   0.16
## 25 0.04620 0.001910       1    -0.22     2.74       1        0   0.16
## 28 0.03000 0.001860       1    -0.22     2.74       1        0   0.16
## 31 0.05750 0.000590       1    -0.22     2.74       1        0   0.16
## 34 0.01780 0.001480       1    -0.22     2.74       1        0   0.16
## 41 0.02210 0.000974       1    -0.22     2.74       1        0   0.16
## 44 0.03440 0.000549       1    -0.22     2.74       1        0   0.16
## 47 0.01540 0.001290       1    -0.22     2.74       1        0   0.16
##    Status  NA
## 1  111115 aci
## 4  111115 aci
## 7  111115 aci
## 10 111115 aci
## 13 111115 aci
## 16 111115 aci
## 19 111115 aci
## 22 111115 aci
## 25 111115 aci
## 28 111115 aci
## 31 111115 aci
## 34 111115 aci
## 41 111115  aq
## 44 111115  aq
## 47 111115  aq

数据输出如上所示,如果想另存为 csv 格式:

write.csv(df64, "./combined.csv")

相比 6800, 6400 参数要多,header_line 表示你数据表头所在行,data_start 表示你数据起始行,Obs = 1 时所在行,不含表头。这个也要确认好了,不同的测量不能放在一起(当然一般不会出现这种情况,同一台仪器,处理数据当然是希望 aci 和 aci 在一起,lrc 和 lrc 在一起,调查测量和调查测量在一起),不同的测量可能起始行不同,这样就会报错,其他注意事项同 read_bat_6800

todo list

增加 LI-6400 数据批量处理

加入到 photoanalysis 里面去