Dear Sirs,
At the outset I sincerely apologize for reproducing my query to you. I also
thank all of you for the solution you had provided. It has worked on the actual
data I am working with.
However, there is this peculiar problem which I had realized only after I had
obtained my results.
e.g. in the example I had attached
A <- c(2, 2, 1, 3, 7, 3, 3, 1, 14, 7, 31)
B <- c(0.0728,0.9538,4.0140,0.0020,2.5593,0.1620,2.513,0.3798, .0033,0..2282,
0.1614)
tapply( B, A, sum)
I get R output as –
1 2 3 7 14 31
4.3938 1.0266 2.6770 2.7875 0.0033 0.1614
However, my requirement is I should get the output as
1 2 3 4 5 6 7 8 9 …. 14 ………..31
4.3938 1.0266 2.6770 0 0 0 2.7875 0 0 ..0.0033 .. 0.161
i.e. my output should include the values 4, 5, 6, etc. which are not part of
dataset A and the corresponding totals in B (which are anyways 0’s). I need
this for my further analysis. Its possible for me to add these 0’s manually,
however when the dataset is large, its not practical.
I am attaching herewith an excel file. I will be grateful if you can guide me.
Thanks in advance
Maithili
start: 2009-08-18 end: 0000-00-00
Thinking of ordering food? Find restaurant numbers on Yahoo! India Local
Love Cricket? Check out live scores, photos, video highlights and more.
Click here http://cricket.yahoo.com
______________________________________________
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.