Hi, I am a student in trouble with R. please help me! I have a 16 huge data(.csv).
data1<-read.csv(D://data1.csv, header=FALSE) . . . data16<-read.csv(D://data16.csv, header=FALSE) and then, I tried to seperated data w/ column. a1<-cbind(data1[1:36568,1]) b1<-cbind(data1[1:36568,2]) . . . ac16<-cbind(data16[1:85207,31]) a column is a Date(yyyy-mm-dd) b column is a Time(hh:mm:ss) c to ac is a numeric data. finished this work, use "rbind" function. date<-rbind(a1,a2,a3,a4,.....,a16) time<-rbind(b1,b2,b3,..........,b16) . . . . ac<-rbind(ac1,ac2,ac3,...,ac16) I want to see yyyy-mm-dd format, but It does not work. >b [,1] [1,] 17753 [2,] 17754 [3,] 17755 [4,] 17756 [5,] 17757 [6,] 17758 >a [,1] [1,] 1 [2,] 1 [3,] 1 [4,] 1 [5,] 1 [6,] 1 I don't know why... Question 1. I want to paste a and b >> yyyy-mm-dd hh:mm:ss Question 2. I want to averaging mean, median for every each minute groups. for example) Time c d e f . . . 2014-01-20 00:00:00 3.1428 1.99 0.123455 7.5526 2014-01-20 00:00:01 3.1887 1.03 0.176545 7.5234 2014-01-20 00:00:02 2.1876 1.27 0.987455 7.5996 ... 2014-01-20 00:01:00 5.4428 1.96 0.164455 7.8666 2014-01-20 00:01:01 1.5658 1.39 0.176545 7.7786 2014-01-20 00:01:02 3.1776 1.67 0.254655 7.4567 then, Time average_C c d e f . . . 2014-01-20 00:00:00 here 3.1428 1.99 0.123455 7.5526 2014-01-20 00:00:01 3.1887 1.03 0.176545 7.5234 2014-01-20 00:00:02 2.1876 1.27 0.987455 7.5996 ... 2014-01-20 00:01:00 here 5.4428 1.96 0.164455 7.8666 2014-01-20 00:01:01 1.5658 1.39 0.176545 7.7786 2014-01-20 00:01:02 3.1776 1.67 0.254655 7.4567 PLEASE HELP ME, R-help!!! [[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.