Hectorman Hectorman wrote: > Hello! > > I have a question regarding the cumsum function that I do not know how to > solve. Would appreciate help from someone. I have imported data from a > txtfile with 2 columns. I am interested in the seconds column, which > contains numbers from i=0 to 40. I would like to count the number of > instances of the numbers 0 to 40 in the seconds column. My problem is that > if there are no observations of one number i in the second column cumsum > skips this in the output. > > Below is an example of the output of the argument Y=cumsum(table(x[,2])) > 0 1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 > 19 20 21 22 23 24 > 3 5 6 10 13 14 16 18 21 25 27 30 32 35 38 40 42 54 105 > 233 306 341 383 417 > 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 > 441 468 487 502 518 532 542 546 552 564 566 574 578 584 591 594 > > As you can see from the output there are no observations of i=4 in this > column. Are there any way I could return the following result instead > 0 1 2 3 4 5 6 7 8 and so on > 3 5 6 10 10 13 14 16 18 > > When i=4 cumsum is the same as when i=3 (10) >
Y <- cumsum(table(factor(x[,2], levels=0:40))) Uwe Ligges > I would really appreciate if anyone could help me with this one:) > > Jan Moberg > > ______________________________________________ > R-help@stat.math.ethz.ch 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. ______________________________________________ R-help@stat.math.ethz.ch 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.