Pandas: Updating dataframe values for rows where one colum has missing data

Question

I have a dataframe called firstpart.

I'm trying to update the values in one column (Key), but only for rows in which another column (Zone) has no data.

I'm using this code, which doesn't work:

firstpart.ix[firstpart.Zone ==np.nan,"Key"] = "newvalue"

Neither does this:

firstpart.ix[firstpart.Zone =="","Key"] = "newvalue"

Using this syntax I'm able to update values in rows for which Zone has another value, but for some reason not if I try to select the rows in which it is blank.

What am I doing wrong?

dmvianna · Accepted Answer · 2014-05-01 02:31:23Z

1

firstpart.ix[firstpart.Zone.isnull()] = "newvalue"

You can't equate NaN to anything.

In [1]: NaN == NaN
Out[1]: False

You need special methods for that, and this is what .isnull() is about.

answered May 1, 2014 at 2:31

dmvianna

15.8k18 gold badges81 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

Pandas: Updating dataframe values for rows where one colum has missing data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related