Pandas dataframe on python

Question

I feel like this may be a really easy question but I can't figure it out I have a data frame that looks like this

one two three

1   2  3

2   3  3

3   4  4

The third column has duplicates if I want to keep the first row but drop the second row because there is a duplicate on row two how would I do this.

Does this answer your question? python pandas: Remove duplicates by columns A, keeping the row with the highest value in column B — Peacepieceonepiece
– Peacepieceonepiece, Commented Sep 30, 2021 at 1:41

Elijah Cox · Accepted Answer · 2021-09-29 23:34:05Z

1

Pandas DataFrame objects have a method for this; assuming df is your dataframe, df.drop_duplicates(subset='name_of_third_column') returns the dataframe with any rows containing duplicate values in the third column removed.

answered Sep 29, 2021 at 23:34

Elijah Cox

1067 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe on python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related