CODEWITHSUNDEEP
pythonpandasdataframe
John
John

Reputation: 1465

Create column from non null values in other column in Pandas

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?

Upvotes: 1

Views: 1126

Answers (1)

AZhao
AZhao

Reputation: 14405

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.

Upvotes: 3

Related Questions