Subhabrata wrote: > Hello R-experts, > > I have a set of data as follows: > > age time > 1 28 1 > 2 53 2 > 3 53 3 > 4 36 4 > 5 54 4 > 6 46 4 > 7 45 5 > 8 31 6 > 9 53 7 > 10 35 7 > 11 62 8 > 12 19 8 > 13 43 2 > 14 51 3 > 15 45 0 > 16 48 2 > 17 49 3 > 18 57 2 > 19 45 3 > 20 27 10 > 21 33 12 > 22 29 14 > 23 46 16 > 24 45 19 > 25 43 2 > 26 28 6 > 27 50 7 > 28 28 4 > 29 33 5 > 30 56 6 > 31 52 6 > 32 50 7 > > > I want to group the data. > > Where the age coloum will be grouped in to 0-15, 15-20 ... > and the sum of time of that group will be added to that group > instead of count of number with in that group. >
Let's call your data frame 'dat'. dat$age.fac <- with(dat, cut(age, breaks = seq(10, 70, by = 10))) sumtime <- with(dat, tapply(time, age.fac, sum)) newdat <- data.frame(agecat = names(sumtime), sumtime) Adjust 'breaks' to suit. Is that what you want? Peter Ehlers > > Thank you for any help > > With Regards > Subhabrata Pal > [[alternative HTML version deleted]] > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
