pandas update dataframe row with new value

Question

I have a text file which has been read into pandas by df1 = pandas.read_csv(r'fruits.txt', sep=',')

    item  freshness
0   apple    2.2
1   pear     0.0

and a series of calculations that would yield the result of apple = 2.3

Is it possible to do a pandas.update so that I can update the value of freshness for apple in the dataframe to 2.3?

jezrael · Accepted Answer · 2016-04-10 14:58:10Z

22

IIUC you need loc:

apple = 2.3

print df['item'] == 'apple'
0     True
1    False
Name: item, dtype: bool

df.loc[df['item'] == 'apple', 'freshness'] = apple
print df
    item  freshness
0  apple        2.3
1   pear        0.0

answered Apr 10, 2016 at 14:58

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas update dataframe row with new value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related