Merge multiple rows with same value into one row in pandas

Question

I have seen that there are similar questions, but the answers did not quite fit my exact needs. I have a dataframe that contains rows with different values. Some of the rows however have exactly the same value.

     Column1 Column2 Column3
0       a       x       x
1       a       x       x
2       a       x       x
3       d       y       y
4       d       y       y

What I would like to have is:

     Column1 Column2 Column3
0       a       x       x
1       d       y       y

So basically I want to merge all rows with the same values in all columns into one row. What is the most decent way to do that in python?

Thank you in advance!

EdChum · Accepted Answer · 2015-10-09 14:01:04Z

2

Call drop_duplicates:

In [214]:
df.drop_duplicates()

Out[214]:
  Column1 Column2 Column3
0       a       x       x
3       d       y       y

answered Oct 9, 2015 at 14:01

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

Collectives™ on Stack Overflow

Merge multiple rows with same value into one row 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