[R] Help with cumsum function

[Uwe Ligges]

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