How do I replace empty cell in specific column dataframe with some value

Question

I have this dataframe(df)

   A Column1      Column2
0  0  Value1              
1  1                    
2  2  Value2   some value
3  3  Value3

And I want the to replace all empty value from just column2 with specific string "Its Empty"

   A Column1      Column2
0  0  Value1     Its Empty         
1  1             Its Empty       
2  2  Value2    some value
3  3  Value3     Its Empty

BENY · Accepted Answer · 2021-02-04 04:21:20Z

2

Try with assign loc

df.loc[df['Column2']=='','Column2'] = 'Its Empty'

Or replace

df['Column2'].replace({'':'Its Empty'},inplace=True)

answered Feb 4, 2021 at 4:21

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Answer 1