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

Question

Could anyone explain how to 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 im using the data.frame on several occasions.

Thanks in advance

score 49 · Answer 1 · answered Feb 08 '13 at 22:21

49

data.frame[row_number, column_number] = new_value

For example, if x is your data.frame:

x[1, 4] = 5

answered Feb 08 '13 at 22:21

Marcel Hebing

2,837
1
17
22

1

Is it possibe to edit cell value by column name and row name? – runjumpfly Oct 19 '16 at 10:23
3

@runjumpfly data_frame["row_name", "col_name"]=2 – Esteemator Dec 11 '16 at 00:47

Mohamed Rahouma · Answer 2 · 2019-08-12T15:26:31.620

25

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

edited Aug 12 '19 at 15:26

answered Aug 12 '19 at 15:20

Mohamed Rahouma

803
7
15

2

Most useful answer of the lot. – Luís de Sousa Apr 01 '20 at 15:22
@LuísdeSousa Thanks a lot – Mohamed Rahouma Apr 01 '20 at 17:43

score 9 · Answer 3 · answered Dec 01 '16 at 20:57

9

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

iris$Sepal.Length[3]=999

answered Dec 01 '16 at 20:57

userJT

10,476
19
70
85

score 6 · Answer 4 · answered Jan 11 '18 at 11:02

6

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!

answered Jan 11 '18 at 11:02

Anne van Vught

61
3
4

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

4 Answers4

Linked