How do I change a single value in a data.frame?

Question

How can one change a single cell in a data.frame to something else?

Basically I just want to rename that one cell, not all cells which matches it.

I can´t use the edit() command because it will screw up my script since I'm using the data.frame on several occasions.

Higgle

Answer 1

data.frame[row_number, column_number] = new_value

For example, if x is your data.frame:

x[1, 4] = 5

Contrived

Is it possibe to edit cell value by column name and row name? – Pruritus

@Pruritus data_frame["row_name", "col_name"]=2 – Urethrectomy

Answer 2

Suppose your dataframe is df and you want to change gender from 2 to 1 in participant id 5 then you should determine the row by writing "==" as you can see

 df["rowName", "columnName"] <- value
 df[df$serial.id==5, "gender"] <- 1

Casimiracasimire

Most useful answer of the lot. – Prehension

@LuísdeSousa Thanks a lot – Casimiracasimire

Answer 3

To change a cell value using a column name, one can use

iris$Sepal.Length[3]=999

Silvern

Answer 4

In RStudio you can write directly in a cell. Suppose your data.frame is called myDataFrame and the row and column are called columnName and rowName. Then the code would look like:

myDataFrame["rowName", "columnName"] <- value

Hope that helps!

Areopagite