[R] help with splitting parts of data frame
Charles Berry
ccberry at ucsd.edu
Sun Sep 28 18:33:57 CEST 2014
Andras Farkas <motyocska <at> yahoo.com> writes:
>
> Dear All,
>
> please help with the following if you can:
>
[snip details]
>
> ####
> first24 <-sum(unlist(c(subset(df, df[, 'simt'] > 0 & df[, 'simt'] <=
> z[1], 3))))
> second24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[1] & df[, 'simt'] <=
> z[2], 3))))
> third24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[2] & df[, 'simt'] <=
> z[3], 3))))
> fourth24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[3] & df[, 'simt'] <=
> z[4], 3))))
> fifth24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[4] & df[, 'simt'] <=
z[5], 3))))
> sixth24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[5] & df[, 'simt'] <=
> z[6], 3))))
>
> last24 <-sum(unlist(c(subset(df, df[, 'simt'] > z[6] , 3))))
>
> my end result is to get this vector:
>
> c(first24,second24,third24,fourth24,fifth24,sixth24,last24)
>
> ####
>
Some hints:
see
?xtabs
for weighted tabulations and
?cut
for forming categories to tabulate.
Try to solve this using just those functions, 'c', and the '~' operator.
It can be done in one line.
HTH,
Chuck
More information about the R-help
mailing list