How to set values in a data frame based on index

Question

Here's my data

     customer_id       feature_1        feature_2      feature_3
0    1                 78               73             63
1    2                 79               71             66
2    2                 82               76             69
3    3                 43               32             53
4    3                 63               42             54

I want to label the dataframe one by one. For example, for index = 3, target is Bad

     customer_id       feature_1        feature_2      feature_3     target
0    1                 78               73             63
1    2                 79               71             66
2    2                 82               76             69
3    3                 43               32             53            bad
4    3                 63               42             54

Basically, I do the process of pulling out one by one with my anotation specialsit

Best regards

Is there any duplication? if yes why no one label this – Nabih Bawazir Aug 08 '18 at 09:54 — Nabih Bawazir, Aug 08 '18 at 09:54

score 2 · Accepted Answer · edited Aug 08 '18 at 09:47

2

Use the set_value function

syntax format is: `DataFrame.set_value(index, col, value, takeable=False)[source]`

So for your question the answer would be

df.set_value(3, 'target', 'bad')

edited Aug 08 '18 at 09:47

Nabih Bawazir

6,381
7
37
70

answered Aug 08 '18 at 09:27

Mohit Motwani

4,662
3
17
45

score 1 · Answer 2 · edited Aug 08 '18 at 09:51

1

Alternatively, you can add empty column first, then fill a cell with desired value

df['target'] = ''
df['target'].iloc[3] = 'bad'

edited Aug 08 '18 at 09:51

Nabih Bawazir

6,381
7
37
70

answered Aug 08 '18 at 09:31

gyoza

2,112
2
12
18

How to set values in a data frame based on index

2 Answers2