[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