Breaking News: Grepper is joining You.com. Read the official announcement!

R gap between date add missing value

Tiange Ye answered on April 28, 2022 Popularity 1/10 Helpfulness 1/10

answer R gap between date add missing value

related R gap between date add missing value

R gap between date add missing value

Comment

library(tidyverse)
df <- df %>%
      complete(timestamp = seq.POSIXt(min(timestamp), max(timestamp), by = "minute"), 
               tr, tt, sr,st)

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: add between date r

Link to this answer
Share Copy Link

Contributed on Apr 28 2022

Tiange Ye

0 Answers Avg Quality 2/10

Closely Related Answers

R gap between date add missing value

Comment

library(dplyr)

ts <- seq.POSIXt(as.POSIXct("2001-09-01 0:00",'%m/%d/%y %H:%M'), as.POSIXct("2001-09-01 0:07",'%m/%d/%y %H:%M'), by="min")

ts <- seq.POSIXt(as.POSIXlt("2001-09-01 0:00"), as.POSIXlt("2001-09-01 0:07"), by="min")
ts <- format.POSIXct(ts,'%m/%d/%y %H:%M')

df <- data.frame(timestamp=ts)

data_with_missing_times <- full_join(df,original_data)

   timestamp     tr tt sr st
1 09/01/01 00:00 15 15 78 42
2 09/01/01 00:01 20 64 98 87
3 09/01/01 00:02 31 84 23 35
4 09/01/01 00:03 21 63 54 20
5 09/01/01 00:04 15 23 36 15
6 09/01/01 00:05 NA NA NA NA
7 09/01/01 00:06 NA NA NA NA
8 09/01/01 00:07 NA NA NA NA

data_with_missing_times %>% group_by(timestamp) %>% mutate_each(funs(ifelse(is.na(.),0,.)))

   timestamp     tr tt sr st
1 09/01/01 00:00 15 15 78 42
2 09/01/01 00:01 20 64 98 87
3 09/01/01 00:02 31 84 23 35
4 09/01/01 00:03 21 63 54 20
5 09/01/01 00:04 15 23 36 15
6 09/01/01 00:05  0  0  0  0
7 09/01/01 00:06  0  0  0  0
8 09/01/01 00:07  0  0  0  0

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: add between date r

Link to this answer
Share Copy Link

Contributed on Apr 28 2022

Tiange Ye

0 Answers Avg Quality 2/10

R gap between date add missing value

Comment

df$timestamp<-as.POSIXct(df$timestamp,format="%m/%d/%y %H:%M")

df1.zoo<-zoo(df[,-1],df[,1]) #set date to Index

df2 <- merge(df1.zoo,zoo(,seq(start(df1.zoo),end(df1.zoo),by="min")), all=TRUE)

Popularity 1/10 Helpfulness 1/10 Language r

Source: stackoverflow.com

Tags: r add between date

Link to this answer
Share Copy Link

Contributed on Apr 28 2022

Tiange Ye

0 Answers Avg Quality 2/10

R gap between date add missing value

Contents

More Related Answers

R gap between date add missing value

Closely Related Answers

R gap between date add missing value

R gap between date add missing value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.