How to drop duplicates based on two or more subsets criteria in Pandas data-frame

by

Your syntax is wrong. Here’s the correct way:

df.drop_duplicates(subset=['bio', 'center', 'outcome'])

Or in this specific case, just simply:

df.drop_duplicates()

Both return the following:

  bio center outcome
0   1    one       f
2   1    two       f
3   4  three       f

Take a look at the df.drop_duplicates documentation for syntax details. subset should be a sequence of column labels.

More Related Contents:

  1. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  2. Aggregation in Pandas
  3. Groupby value counts on the dataframe pandas
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. Multiple aggregations of the same column using pandas GroupBy.agg()
  6. Pandas groupby mean – into a dataframe?
  7. Python Pandas max value in a group as a new column
  8. How to loop over grouped Pandas dataframe?
  9. How to access pandas groupby dataframe by key
  10. Pandas Groupby and Sum Only One Column
  11. Python Pandas Group by date using datetime data
  12. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  13. Pandas – dataframe groupby – how to get sum of multiple columns
  14. Group dataframe and get sum AND count?
  15. How to summarize on different groupby combinations?
  16. get first and last values in a groupby
  17. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  18. Get the row corresponding to the max in pandas GroupBy [duplicate]
  19. How to get number of groups in a groupby object in pandas?
  20. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?
  21. How to change the order of DataFrame columns?
  22. Split pandas dataframe based on groupby
  23. Add missing dates to pandas dataframe
  24. How to check if any value is NaN in a Pandas DataFrame
  25. pandas dataframe groupby datetime month
  26. Python Pandas update a dataframe value from another dataframe
  27. python dataframe pandas drop column using int
  28. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  29. append dictionary to data frame
  30. Python: Adding hours to pandas timestamp

Leave a Comment