Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

When trying to replace values, "missing values are not allowed in subscripted assignments of data frames"

Tags:

r

I have a table that has two columns: whether you were sick (H01) and the number of days sick (H03). However, the number of days sick is NA if H01 == false, and I would like to set it to 0. When I do this:

test <- pe94.person[pe94.person$H01 == 12,]
test$H03 <- 0

It works fine. However, I'd like to replace the values in the original dataframe. This, however, fails:

pe94.person[pe94.person$H01 == 12,]$H03 <- 0

It returns:

> pe94.person[pe94.person$H01 == 12,]$H03 <- 0
Error in `[<-.data.frame`(`*tmp*`, pe94.person$H01 == 12, , value = list( : 
  missing values are not allowed in subscripted assignments of data frames

Any idea why this is? For what it's worth, here's a frequency table:

> table(pe94.person[pe94.person$H01 == 12,]$H03)

 2  3  5 28 
 3  1  1  1 
like image 566
Andrew Min Avatar asked Apr 30 '14 19:04

Andrew Min


4 Answers

It is due to missingness in H01 variable.

> x <- data.frame(a=c(NA,2:5), b=c(1:5))
> x
   a b
1 NA 1
2  2 2
3  3 3
4  4 4
5  5 5
> x[x$a==2,]$b <- 99
Error in `[<-.data.frame`(`*tmp*`, x$a == 1, , value = list(a = NA_integer_,  : 
  missing values are not allowed in subscripted assignments of data frames

The assignment won't work because x$a has a missing value.

Subsetting first works:

> z <- x[x$a==2,]
> z$b <- 99
> z <- x[x$a==2,]
> z
    a  b
NA NA NA
2   2  2

But that's because the [<- function apparently can't handle missing values in its extraction indices, even though [ can:

> `[<-`(x,x$a==2,,99)
Error in `[<-.data.frame`(x, x$a == 2, , 99) : 
  missing values are not allowed in subscripted assignments of data frames

So instead, trying specifying your !is.na(x$a) part when you're doing the assignment:

> `[<-`(x,!is.na(x$a) & x$a==2,'b',99)
   a  b
1 NA  1
2  2 99
3  3  3
4  4  4
5  5  5

Or, more commonly:

> x[!is.na(x$a) & x$a==2,]$b <- 99
> x
   a  b
1 NA  1
2  2 99
3  3  3
4  4  4
5  5  5

Note that this behavior is described in the documentation:

The replacement methods can be used to add whole column(s) by specifying non-existent column(s), in which case the column(s) are added at the right-hand edge of the data frame and numerical indices must be contiguous to existing indices. On the other hand, rows can be added at any row after the current last row, and the columns will be in-filled with missing values. Missing values in the indices are not allowed for replacement.

like image 52
Thomas Avatar answered Oct 22 '22 04:10

Thomas


You can use ifelse, like so

pe94.person$foo <- ifelse(!is.na(pe94.person$H01) & pe94.person$H01 == 12, 0, pe94.person$H03)

check if foo meets your criteria and then go ahead and assign it to pe94.person$H03 directly. I find it safer to assign it a new variable and usually use that in subsequent analysis.

like image 31
infominer Avatar answered Oct 22 '22 04:10

infominer


There might be an NA somewhere in the column that is causing the error. Run the index on a specific column instead of the entire data frame.

movies[movies$Actors == "N/A",] = NA #ERROR
movies$Actors[movies$Actors == "N/A"] = NA #Works
like image 31
James L. Avatar answered Oct 22 '22 04:10

James L.


I realise the question is very old, but I think the most elegant solution is by using the which() function:

 pe94.person[which(pe94.person$H01 == 12),]$H03 <- 0

should do what the original poster asked for. Because which() drops the NAs and keeps the (positions of the) TRUE results only.

like image 34
Christian Steglich Avatar answered Oct 22 '22 05:10

Christian Steglich