Create column from non null values in other column in Pandas

Question

I have a column with some ints and some null values in a pandas dataframe. How do I replace the ints with the float values from another column (by same row), but leave all the nulls?

AZhao · Accepted Answer · 2015-07-16 16:37:26Z

3

Need exact columns and df to be sure, but can you try this:

df.loc[df['ints'].notnull(),'ints'] = df['floats']

where df is your dataframe, ints is the integer column and floats is the float column.

answered Jul 16, 2015 at 16:37

AZhao

14.5k8 gold badges33 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Create column from non null values in other column in Pandas

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