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 ______________________________________________ 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.
