[R] Loop With Dates

[Rui Barradas]

Hello,

Maybe I am not understanding but isn't this what you have asked in your 
previous question and my 2nd post (adapted) does?
If not, where does it fail?

Hope this helps,

Rui Barradas

Às 18:46 de 20/09/19, Phillip Heinrich escreveu:
> With the data snippet below I’m trying to increment the “count” vector by one each time the date changes.
> 
>           Date count
> 1   2018-03-29     1
> 2   2018-03-29     1
> 3   2018-03-29     1
> 81  2018-03-30     1
> 82  2018-03-30     1
> 83  2018-03-30     1
> 165 2018-03-31     1
> 166 2018-03-31     1
> 167 2018-03-31     1
>   
>       
>              >
>       
> 
> 
> I can get count to change when the date changes with the following code:
> 
> test2 <- transform(test2,
> +                   count = ifelse(Date == lag(Date,1),count,count+1))
>> test2
>            Date count
> 1   2018-03-29    NA
> 2   2018-03-29     1
> 3   2018-03-29     1
> 81  2018-03-30     2
> 82  2018-03-30     1
> 83  2018-03-30     1
> 165 2018-03-31     2
> 166 2018-03-31     1
> 167 2018-03-31     1
>   
>       
>             
> 
>       
> 
> 
> ...but I want all three March 30 rows to have a count of 2 and the March 31 rows to be equal to 3.  Any suggestions?
> 
> Thanks.
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>