[R] & statement within an ifelse Loop

[David Winsemius]

On 9/21/19 12:57 PM, Phillip Heinrich wrote:
> Still putzing around trying to increment a count vector when 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  - lines 81 and 165 - by comparing the date to the date on the previous line (lag(Date,1)) but then the count returns to 1 on line 82 and line 166.
>
> test2 <- transform(test2,
> +                   count = ifelse(Date == lag(Date,1),count,count+1))


The first thing to do is clarify which package you are expecting lag to 
come from. I suspect it from a package other than the "base" stats which 
gives this.


lag(c(1,2)) == c(1,2)
[1] TRUE TRUE
attr(,"tsp")
[1] 0 1 1


The base lag function only changes the tsp attributes, but not the values.


-- 

David.

>> 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
>
> test2 <- transform(test2,
> +           count = ifelse(Date == lag(Date,1),(lag(count,1)),(lag(count,1)+1)))
>
>
>
> With the code above I get the same results.  It seems to me that line 82 should have count = 2 since the dates on line 81 and 82 are the same so the count from line 82 should be the same as 81 -  (lag(count,1)).  Similarly, if line 83 were count = 2 then line 165 should be equal to 3.
>
> What am I missing here?  Is there a way to add an & clause to either the if or the else clause such as:
>
> ((-2:2) >= 0) & ((-2:2) <= 0)I’ve tried this several different ways such as:
>
> (lag(count,1)) &(count = count+1).
>
> with no success.
>
> Thanks,
> Philip
>
> 	[[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.