Home » How to Fix: number of items to replace is not a multiple of replacement length

How to Fix: number of items to replace is not a multiple of replacement length

by Erma Khan

One error you may encounter in R is:

Warning message:
  number of items to replace is not a multiple of replacement length

This error occurs when you attempt to replace a certain number of items in a vector or data frame column (suppose 3 items) with a different number of items (suppose 6 items).

This tutorial shares exactly how to fix this error.

How to Reproduce the Error

Suppose we have the following data frame in R with some missing values in the first column:

#create data frame
df frame(a=c(3, NA, 7, NA, NA, 14),
                 b=c(4, 4, 5, 12, 13, 18))

#view data frame
df

   a  b
1  3  4
2 NA  4
3  7  5
4 NA 12
5 NA 13
6 14 18

Now suppose we try to replace the missing values in the first column with values in the second column:

#attempt to replace missing values in first column with values in second column
df$a[is.na(df$a)] 

We receive an error because we attempted to replace 3 missing values in the first column with all 6 values from the second column.

How to Fix the Error

The easiest way to fix this error is to simply use an ifelse() statement:

#replace missing values in column 'a' with corresponding values in column 'b'
df$a na(df$a), df$b, df$a)

#view updated data frame
df

   a  b
1  3  4
2  4  4
3  7  5
4 12 12
5 13 13
6 14 18 

This ifelse() statement checks if the value in column ‘a’ is empty. If it is, then it gets replaced by the corresponding value in column ‘b’, otherwise it is left alone.

Another way to fix this error is to simply replace all missing values with a specific number:

#replace all missing values in column 'a' with zero
df$a[is.na(df$a)] 
#view updated data frame
df

   a  b
1  3  4
2  0  4
3  7  5
4  0 12
5  0 13
6 14 18

Using this method, each missing value in column ‘a’ gets replaced with a zero.

Additional Resources

How to Fix in R: NAs Introduced by Coercion
How to Fix in R: Subscript out of bounds
How to Fix in R: longer object length is not a multiple of shorter object length

Related Posts