R: How to replace elements of a data.frame?

Posted by John on Stack Overflow See other posts from Stack Overflow or by John
Published on 2010-05-04T16:47:06Z Indexed on 2010/05/04 17:28 UTC
Read the original article Hit count: 126

Filed under:

r

|

dataframe

|

replace

I'm trying to replace elements of a data.frame containing "#N/A" with "NULL", and I'm running into problems:

foo <- data.frame("day"= c(1, 3, 5, 7), "od" = c(0.1, "#N/A", 0.4, 0.8))

indices_of_NAs <- which(foo == "#N/A") 

replace(foo, indices_of_NAs, "NULL")

Error in [<-.data.frame(*tmp*, list, value = "NULL") : new columns would leave holes after existing columns

I think that the problem is that my index is treating the data.frame as a vector, but that the replace function is treating it differently somehow, but I'm not sure what the issue is?

Related posts about dataframe

Pandas Dataframe add rows on top of dataframe

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to add blank rows on top of the pandas Dataframe data. Basically, some blank rows and some calculation for each row which contains calculations for Average etc. for that column. Can someone please help me how I can do this? From: A B D E F G H I J 0 -8 10… >>> More
Converting a dataframe to a vector (by rows)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a dataframe with numeric entries like this one test <- data.frame(x=c(26,21,20),y=c(34,29,28)) How can I get the following vector? > 26,34,21,29,20,28 >>> More
writing to a dataframe from a for-loop in R

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to write from a loop to a data frame in R, for example a loop like this for (i in 1:20) { print(c(i+i,i*i,i/1))} and to write each line of 3 values to a data frame with three columns, so that each iteration takes on a new row. I've tried using matrix, with ncol=3 and filled by rows,… >>> More
R get rid of rows with duplicate attribute

as seen on Stack Overflow - Search for 'Stack Overflow'
hi there I have a big dataframe with columns such as: ID, time, OS, IP Each row of that dataframe corresponds to one entry. Within that dataframe for some IDs serveral entries (rows) exist. I would like to get rid of those multiple rows (obviously the other attributes will differ for the same ID)… >>> More
Replace values in a dataframe based on another factor which contains NA's in R

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a dataframe which contains (among other things) a numeric column with a concentration, and a factor column with a status flag. This status flag contains NA's. Here's an example df<-structure(list(conc = c(101.769, 1.734, 62.944, 92.697, 25.091, 27.377, 24.343, 55.084, 0.335, 23.280),… >>> More

Developer IT

R: How to replace elements of a data.frame? - Developer IT

R: How to replace elements of a data.frame?

r

dataframe

replace

Related posts about r

Related posts about dataframe

Pandas Dataframe add rows on top of dataframe

Converting a dataframe to a vector (by rows)

writing to a dataframe from a for-loop in R

R get rid of rows with duplicate attribute

Replace values in a dataframe based on another factor which contains NA's in R

Categories cloud