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)