Replace values of rows to one value in pandas dataframe

Question

I want to replace the values of the rows of a specific column with one name, but I want to skip the rows that have no value.

So only the row with text in it should get a different name.

I tried this: df.loc[:, 'Groenlinks'] = 'gl' But with this all the rows change to 'gl'. I'm not sure how I can only replace the names of different rows with one word without typing all the words it should replace.

I want it to look like this:

VVD          PVV          Groenlinks
vvd                       gl
             pvv          
vvd                    
                    
vvd                       gl
vvd          pvv

SeaBean · Accepted Answer · 2021-05-08 17:44:45Z

2

You can use:

df.loc[df['Groenlinks'] != '', 'Groenlinks'] = 'gl'

Empty string is not equivalent to NaN / null in Pandas. So, if you have empty string in other blank rows in the column, you can use the code above to filter the rows to set up with the new value.

answered May 8, 2021 at 17:44

SeaBean

23.4k3 gold badges16 silver badges28 bronze badges

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

Comments

Shivam Roy · Accepted Answer · 2021-05-08 17:52:37Z

2

If the values in the column are an empty string or they are null values, then this should work perfectly:

df['Groenlinks'].loc[df['Groenlinks'].notnull() | (df['Groenlinks'] != '')] = 'gl'

edited May 8, 2021 at 17:52

answered May 8, 2021 at 17:38

Shivam Roy

2,0713 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

Replace values of rows to one value in pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related