I have the following data set, abbreviated for simplicity:
SM = soil moisture, T = Temperature

DateTime              SMCount      T1        T2      T3  
2023-04-24 11:45:00   3960        12.875   15.625   17.5  
2023-04-24 12:00:00   3951        13.00    15.375   17.125         
2023-04-24 12:15:00   3955        13.25    15.6875  17.5  
2023-04-24 12:30:00   3961        13.1875  14.75    15.875 

等.

我想创建以下内容:

DateTime              SMCount      T1        T2      T3  
2023-04-24 11:45:00   3960        12.875   15.625   17.5  
2023-04-24 11:45:10   3960        12.875   15.625   17.5  
2023-04-24 11:45:20   3960        12.875   15.625   17.5  
2023-04-24 11:45:30   3960        12.875   15.625   17.5 

...诸若此类

2023-04-24 12:00:00   3951        13.00    15.375   17.125   
2023-04-24 12:00:10   3951        13.00    15.375   17.125   
2023-04-24 12:00:20   3951        13.00    15.375   17.125   
2023-04-24 12:00:30   3951        13.00    15.375   17.125   

...诸若此类

2023-04-24 12:15:00   3955        13.25    15.6875  17.5   
2023-04-24 12:15:10   3955        13.25    15.6875  17.5   
2023-04-24 12:15:20   3955        13.25    15.6875  17.5   
2023-04-24 12:15:30   3955        13.25    15.6875  17.5  

...诸若此类

2023-04-24 12:30:00   3961        13.1875  14.75    15.875   
2023-04-24 12:30:10   3961        13.1875  14.75    15.875   
2023-04-24 12:30:20   3961        13.1875  14.75    15.875   
2023-04-24 12:30:30   3961        13.1875  14.75    15.875   

...诸若此类

我搜索了这个问题,发现了我正在try 适应的两个可能的解决方案:

解决方案1:

library(tidyr)
df <- complete(soilmoisture$DateTime = seq(from = min(soilmoisture$DateTime), to = max(soilmoisture$DateTime), by = 1)) %>%
  fill(SMCount)

解决方案2:

library(tidyverse)
data <- mutate(soilmoisture$DateTime = lubridate::ymd_hms(soilmoisture$DateTime))%>%
  complete(soilmoisture$DateTime = seq.POSIXt(min(soilmoisture$Datetime), max(soilmoisture$DateTime), by="sec"))%>%
  fill(SMCount)

我分别收到以下错误消息:

Error: unexpected '=' in "df %>% complete(soilmoisture$DateTime="  
and  
Error: unexpected '=' in "data <- mutate(soilmoisture$DateTime ="

你知道怎么修吗? 我如何调整我的代码,使SMCount、t1、t2和t3同时填充?

非常感谢

推荐答案

我想你可以试试这个,如果这是你所期待的,请让我知道

data <- structure(list(DateTime = structure(c(1682336700, 1682337600, 
                                             1682338500, 1682339400), class = c("POSIXct", "POSIXt"), tzone = "UTC"), 
                      SMCount = c(3960L, 3951L, 3955L, 3961L), T1 = c(12.875, 13, 
                                                                      13.25, 13.1875), T2 = c(15.625, 15.375, 15.6875, 14.75), 
                      T3 = c(17.5, 17.125, 17.5, 15.875)), row.names = c(NA, -4L
                      ), class = "data.frame")

Code

  dfs <- data %>% 
  complete(DateTime = seq(from = min(DateTime), to = max(DateTime), by = 1)) %>%
  fill(SMCount,T1, T2, T3,.direction='down') 
 

R相关问答推荐

在交互式情节中从barplot中获取值时遇到问题,在shinly中的ggplotly

插入指示行之间时间间隔的新行

如何创建具有总计列和ggplot 2所有条线的百分比标签的堆叠条形图?

如何对数据集进行逆向工程?

根据模式将一列拆分为多列,并在R中进行拆分

derrr mutate case_when grepl不能在R中正确返回值

根据多个条件增加y轴高度以适应geom_text标签

如何将旋转后的NetCDF转换回正常的纬度/经度网格,并使用R?

标识R中多个列中缺少的唯一值

如何删除仅在数据集顶部和底部包含零的行

比较理论阿尔法和经验阿尔法

以字符格式导入的ExcelElectron 表格日期列标题

如何在R中平滑地绘制线图(不拟合)?

从非重叠(非滚动)周期中的最新数据向后开窗并在周期内计数

如何在PDF格式的kableExtra表格中显示管道字符?

Geom_arcbar()中出错:找不到函数";geom_arcbar";

以不同于绘图中元素的方式对GG图图例进行排序

快速合并R内的值

为什么将负值向量提升到分数次方会得到NaN

Ggplot2如何找到存储在对象中的残差和拟合值?