Message-ID: <CAOEXkoB1BW8QH=L0n3gazGD0a=jDbAX_h8R-_M4g7K7OT38_Ng@mail.gmail.com>
Date: 2012-09-05T23:57:24Z
From: HJ YAN
Subject: Summarizing data containing data/time information (as factor)
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