# [R] Sparseby Problems

Ben Stewart bpstewar at uvic.ca
Wed Apr 21 19:16:47 CEST 2010

```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

```