Replace all particular values in a data frame

r dataframe replace
zxzak picture zxzak · Oct 21, 2013 · Viewed 319.2k times · Source

Having a data frame, how do I go about replacing all particular values along all rows and columns. Say for example I want to replace all empty records with NA's (without typing the positions):

df <- data.frame(list(A=c("", "xyz", "jkl"), B=c(12, "", 100)))

    A   B
1      12
2  xyz    
3  jkl 100

Expected result: 

    A   B
1  NA   12
2  xyz  NA  
3  jkl  100

Answer

mrip picture mrip · Oct 21, 2013

Like this:

> df[df==""]<-NA
> df
     A    B
1 <NA>   12
2  xyz <NA>
3  jkl  100

Related questions

How to replace NA values in a table for selected columns

There are a lot of posts about replacing NA values. I am aware that one could replace NAs in the following table/frame with the following: x[is.na(x)]<-0 But, what if I want to restrict it …

Read More
Replace <NA> in a factor column

I want to replace <NA> values in a factors column with a valid value. But I can not find a way. This example is only for demonstration. The original data comes from a foreign csv file I have …

Read More
Add characters to a numeric column in dataframe

I have a dataframe like this: V1 V2 V3 1 1 3423086 3423685 2 1 3467184 3467723 3 1 4115236 4115672 4 1 5202437 5203057 5 2 7132558 7133089 6 2 7448688 7449283 I want to change the V1 column and add chr before the number. Just like this: V1 V2 V3 1 chr1 3423086 3423685 2 chr1 3467184 3467723 3 chr1 4115236 4115672 4 chr1 5202437 5203057 5 chr2 7132558 7133089 6 chr2 7448688 7449283 Is there a way to do …

Read More