Hi, I am not sure how your dataset looks like. If it is like the one below: (otherwise, please provide a reproducible example using ?dput())
dat1<- read.table(text=" datetime 10/02/2010 02:30 11/02/2010 04:00 14/02/2010 06:30 ",sep="",header=TRUE,stringsAsFactors=FALSE) lst1<-split(dat1,(seq_along(dat1$datetime)-1)%%2+1) dat2<- data.frame(datetime=as.POSIXct(paste(lst1[[1]][,1],lst1[[2]][,1]),format="%d/%m/%Y %H:%M")) str(dat2) #'data.frame': 3 obs. of 1 variable: # $ datetime: POSIXct, format: "2010-02-10 02:30:00" "2010-02-11 04:00:00" ... dat2 # datetime #1 2010-02-10 02:30:00 #2 2010-02-11 04:00:00 #3 2010-02-14 06:30:00 #or data.frame(datetime=as.POSIXct(paste(dat1[seq(1,nrow(dat1),by=2),1], dat1[seq(2,nrow(dat1),by=2),1]),format="%d/%m/%Y %H:%M")) # datetime #1 2010-02-10 02:30:00 #2 2010-02-11 04:00:00 #3 2010-02-14 06:30:00 A.K. Hey everybody, I am a new user of R software. I don't know how I can merge two rows in one. In fact, I have one row with the date(dd/mm/yyyy) and another with the time (hh:mm) and I would like to get one row with date time in order to convert to POSIXct. How can I do it?? ______________________________________________ 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.
