[R] Summarizing data containing data/time information (as factor)
HJ YAN
yhj204 at googlemail.com
Thu Sep 6 01:57:24 CEST 2012
Dear R user
I want to create a table (as below) to summarize the attached data
(Test.csv, which can be read into R by using 'read.csv(Test.csv, header=F)'
), to indicate the day that there are any data available, e.g.value=1 if
there are any data available for that day, otherwise value=0.
28/04 29/04 30/04 01/05 02/05
532703 0 1 1 1 0
532704 1 1 1 1 1
532705 0 0 1 1 0
Only Column A (Names: automatically stored as integer if being read into R)
and Column B (date/time: automatically stored as factor if being read into
R) are useful for this task.
Could anyone kindly provide me some hints/ideas about how to write some
code to to this job please?
Many thanks in advance!
Best wishes
HJ
More information about the R-help
mailing list