r - 根据 15 分钟数据计算土壤水势的日平均值

Question

我是 R 的新手。我有一个土壤水势值数据框，它以 15 分钟的间隔记录在两个区域和 5 个深度。我想计算每个区域和深度的两年土壤水势的日平均值。你能帮帮我吗？

这是数据框的一部分：

TimeStamp_Field       Area     Parameter           Value     Sensor_UID    Depth Unit
07/01/2017  00:00:00    S   soil_water_potential    1.2     N_B3_TM_10/1_WP 10  pF
07/01/2017  00:15:00    S   soil_water_potential    1.193   N_B3_TM_10/1_WP 10  pF
07/01/2017  00:29:52    S   soil_water_potential    1.204   N_B3_TM_10/1_WP 10  pF
07/01/2017  00:45:00    S   soil_water_potential    1.203   N_B3_TM_10/1_WP 10  pF
07/01/2017  01:00:00    S   soil_water_potential    1.205   N_B3_TM_10/1_WP 10  pF
07/01/2017  01:15:00    S   soil_water_potential    1.214   N_B3_TM_10/1_WP 10  pF
07/01/2017  01:30:00    S   soil_water_potential    1.22    N_B3_TM_10/1_WP 10  pF
07/01/2017  01:45:00    S   soil_water_potential    1.219   N_B3_TM_10/1_WP 10  pF
07/01/2017  02:00:00    S   soil_water_potential    1.222   N_B3_TM_10/1_WP 10  pF
07/01/2017  02:15:00    S   soil_water_potential    1.229   N_B3_TM_10/1_WP 10  pF
07/01/2017  02:30:00    S   soil_water_potential    1.233   N_B3_TM_10/1_WP 10  pF
07/01/2017  02:45:00    S   soil_water_potential    1.231   N_B3_TM_10/1_WP 10  pF
07/01/2017  03:00:00    S   soil_water_potential    1.23    N_B3_TM_10/1_WP 10  pF
07/01/2017  03:15:00    S   soil_water_potential    1.239   N_B3_TM_10/1_WP 10  pF
07/01/2017  03:30:00    S   soil_water_potential    1.238   N_B3_TM_10/1_WP 10  pF
07/01/2017  03:45:00    S   soil_water_potential    1.236   N_B3_TM_10/1_WP 10  pF
07/01/2017  04:00:00    S   soil_water_potential    1.24    N_B3_TM_10/1_WP 10  pF

标签： rdatetime

Answer 1

您可以从时间戳中为日/月/年创建新字段，然后group_by在summarise这些列 + 参数/sensor_UID（如果需要）上计算平均值。