[R] unexpected behavior in apply
Derickson, Ryan, VHA NCOD
Ry@n@Der|ck@on @end|ng |rom v@@gov
Fri Oct 8 19:49:20 CEST 2021
Hello,
I'm seeing unexpected behavior when using apply() compared to a for loop when a character vector is part of the data subjected to the apply statement. Below, I check whether all non-missing values are <= 3. If I include a character column, apply incorrectly returns TRUE for d3. If I only pass the numeric columns to apply, it is correct for d3. If I use a for loop, it is correct.
> d<-data.frame(d1 = letters[1:3],
+ d2 = c(1,2,3),
+ d3 = c(NA,NA,6))
>
> d
d1 d2 d3
1 a 1 NA
2 b 2 NA
3 c 3 6
>
> # results are incorrect
> apply(d, 2, FUN=function(x)all(x[!is.na(x)] <= 3))
d1 d2 d3
FALSE TRUE TRUE
>
> # results are correct
> apply(d[,2:3], 2, FUN=function(x)all(x[!is.na(x)] <= 3))
d2 d3
TRUE FALSE
>
> # results are correct
> for(i in names(d)){
+ print(all(d[!is.na(d[,i]),i] <= 3))
+ }
[1] FALSE
[1] TRUE
[1] FALSE
Finally, if I remove the NA values from d3 and include the character column in apply, it is correct.
> d<-data.frame(d1 = letters[1:3],
+ d2 = c(1,2,3),
+ d3 = c(4,5,6))
>
> d
d1 d2 d3
1 a 1 4
2 b 2 5
3 c 3 6
>
> # results are correct
> apply(d, 2, FUN=function(x)all(x[!is.na(x)] <= 3))
d1 d2 d3
FALSE TRUE FALSE
Can someone help me understand what's happening?
More information about the R-help
mailing list