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.
