[R] (no subject)

[Benjamin Stewart]

I've got a problem with the sparseby command (reshape
library), and I have reached the peak of my R knowledge (it isn't really that
high).

 

I have a small data frame of 23 rows and 15 columns, here
is a subset, the first four columns are factors and the rest are numeric (only
one, line54 is provided).

 

   bearID YEAR
Season SEX      line54

5    1900    8     
3   0  16.3923519

11   2270    5     
1   0 233.7414014

12   2271    5     
1   0 290.8207652

13   2271    5     
2   0 244.7820844

15   2291    5     
1   0   0.0000000

16   2291    5     
2   0  14.5037795

17   2291    6     
1   0   0.0000000

18   2293    5     
2   0 144.7440752

19   2293    5     
3   0   0.0000000

20   2293    6     
1   0  16.0592270

21   2293    6     
2   0  30.1383426

28   2298    5     
1   0   0.9741067

29   2298    5     
2   0   9.6641018

30   2298    6     
2   0   8.6533828

31   2309    5     
2   0  85.9781303

32   2325    6     
1   0 110.8892153

35   2331    6     
1   0  26.7335562

44   2390    7     
2   0   7.1690620

45   2390    8     
2   0  44.1109897

46   2390    8     
3   0 503.9074898

47   2390    9     
2   0   8.4393660

54   2416    7     
3   0  48.6910907

58   2418    8      2  
0   5.7951139

 

Sparseby works fine when I try to calculate mean

 

>sparseby(mF[1:5], mF$Season, mean)

 

  mF$Season bearID
YEAR Season SEX    line54

1         1     NA  
NA     NA   0 
84.90228

2         2     NA  
NA     NA   0 
54.90713

3         3     NA  
NA     NA   0 142.24773

 

But it goes nuts when looking for max or min

 

> sparseby(mF[5:6], mF$Season, max)

  mF$Season
structure(c(2169.49621795108, 1885.22677689026, 2492.17544685464

1         1                                                        
2169.496

2         2                                                        
1885.227

3         3                                                        
2492.175

 

Any ideas? All I want is to calculate create three
data.frames, mean, min and max.

 

Thanks,

 

Ben Stewart