Hi all,
I have the folowing frame(there are more columns than shown),
   1              2           3        4           5     
Year         Total      Tus    Whi      Norw
1994         1.00      1830       0      355 
1995         1.00         0       0        0 
1995         1.00         0       0        0 
1995         1.00      4910    4280      695 
1997         1.00         0       0      110 
1997         0.58         0       0        0 
1997         1.00         0       0        0 
1994         1.00         0       0        0 
1997         1.00         0      40       70 
1998         1.00         0       0     1252 
1999         1.04         0      74        0 
1999         1.00         0       0        0 
1999         1.02         0       0        0 
1999         1.00         0       0        0 
1999         1.00         0       0      171 
1999         1.00      1794       0      229 
1999         1.00         0    3525        0 
1997         1.00      1335    1185      147 
1997         1.00      4925    1057     4801 
1997         1.00         0    6275     1773 

I try to get sum("Total") by "Year" in which Tus>0,  sum("Total") by "Year" in which 
Whi>0,,,and so on.

I have done something like this;

a<-as.list(numeric(3))
for (i in 3:5)
{
a[[i]]<-aggregate(frame[,"Total"],list(Year=frame$"Year",
                                                   Tus=frame$"i">0),sum)
}

But I get

 "Error in FUN(X[[as.integer(1)]], ...) : arguments must have same length"

Also by doing one by one

aggregate(frame[,"Total"],list(Year=frame$"Year",
                                                   Tus=frame$"Tus">0),sum)


The result is something like;

   Year  Tus     x
 1994 FALSE 49.69
 1995 FALSE 49.35
 1996 FALSE 56.95
 1997 FALSE 57.00
 1998 FALSE 57.00
 1999 FALSE 58.09
 2000 FALSE 56.97
 2001 FALSE 57.95
 2002 FALSE 57.10
 2003 FALSE 56.16
 2000  TRUE  1.00
 2002  TRUE  1.00
 2003  TRUE  2.01


Help


Thank you

Luis Ridao Cruz
Fiskirannsóknarstovan
Nóatún 1
P.O. Box 3051
FR-110 Tórshavn
Faroe Islands
Phone:             +298 353900
Phone(direct): +298 353912
Mobile:             +298 580800
Fax:                 +298 353901
E-mail:              [EMAIL PROTECTED]
Web:                www.frs.fo

______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

Reply via email to