Replace the values of multiple rows with the values of another row based on a condition in Pandas

Question

I want to replace the values of the columns A, B, C, D with the values where region = '' for the a unique value for the year 2011. For example, the unique column with the value 1 for 2011 will replace its 3, 4, 9, 8 values with 6, 6, 6, 6; this approach would then be applied to the unique values 2 and 3. Afterwards the rows where region = '' would be dropped.

Other questions related to this don't have the answers I am looking for. I have tried using loc but to no avail.

Suhas Mucherla · Accepted Answer · 2020-12-30 09:48:51Z

1

I think you need this:

df=df.groupby(['unique','year']).agg('last').reset_index()

answered Dec 30, 2020 at 9:48

Suhas Mucherla

1,4131 gold badge7 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Replace the values of multiple rows with the values of another row based on a condition 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