Hi,
Just to add:
As you have more columns of data, it would be better to do in this way:
Time1<-as.POSIXct("2013-01-01 00:00:00")
tseq<-seq(Time1,length.out=50,by="secs")
dat2<-data.frame(TIME=tseq,matrix(NA,nrow=50,ncol=3)) #change nrow and ncol
names(dat2)[-1]<-paste("Data",1:3,sep="")
dat3<-read.table(text="
ID Date TIME Data1 Data2 Data3
1 2013-01-01 00:00:00 34 53 66
2 2013-01-01 00:00:01 333 4 5
3 2013-01-01 00:00:05 333 4 5
4 2013-01-01 00:00:20 34 63 66
5 2013-01-01 00:00:25 433 5 8
6 2013-01-01 00:00:26 533 8 5
",sep="",stringsAsFactors=FALSE,header=TRUE)
dat4<-data.frame(TIME=as.POSIXct(paste(dat3$Date,dat3$TIME)),dat3[,4:6])
dat2[,-1][dat2[,1]%in%dat4[,1],]<-dat4[,-1]
head(dat2)
# TIME Data1 Data2 Data3
#1 2013-01-01 00:00:00 34 53 66
#2 2013-01-01 00:00:01 333 4 5
#3 2013-01-01 00:00:02 NA NA NA
#4 2013-01-01 00:00:03 NA NA NA
#5 2013-01-01 00:00:04 NA NA NA
#6 2013-01-01 00:00:05 333 4 5
A.K.
----- Original Message -----
From: Simonas Kecorius <simolas2...@gmail.com>
To: r-help@r-project.org
Cc:
Sent: Saturday, January 5, 2013 8:54 AM
Subject: [R] Need help with time series data
Dear R users,
Could you share your knowledge on following problem:
Suppose we have dataframe:
ID TIME Data1 Data2 Data3
........... Data700
1. 2013-01-01 00:00:00 34 53 66
............ 55
2. 2013-01-01 00:00:01 333 4 5
............ 50
3. 2013-01-01 00:00:02 and so on
4. 2013-01-01 00:00:03 and so on
5. 2013-01-01 03:00:45 44 33 4
............. 66
6. 2013-01-01 03:00:46 46 35 7
............. 6
Notice that between ID 4 and ID 5 there is a gap, that instrument was
turned off. It started automatically in 2013-01-01 03:00:45 and continues
till the next turn off.
What I need R to do, is to find these gaps, and insert missing time values
with empty Data lines to have no gaps in time and empty (or NA) values in
data place:
ID TIME Data1 Data2 Data3
........... Data700
1. 2013-01-01 00:00:00 34 53 66
............ 55
2. 2013-01-01 00:00:01 333 4 5
............ 50
3. 2013-01-01 00:00:02 and so on
4. 2013-01-01 00:00:03 and so on
5. 2013-01-01
00:00:04
<- time with empty (or NA) data values inserted
6. 2013-01-01
00:00:05
<- time with empty (or NA) data values inserted
7. 2013-01-01
00:00:06
<- time with empty (or NA) data values inserted
................
and so on, until the time when instrument works again:
2013-01-01 03:00:45 44 33 4
............. 66
2013-01-01 03:00:46 46 35 7
............. 6
All your suggestions will be appreciated!
Simonas Kecorius
**
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
