drop_duplicates not working in pandas?

by

You’ve got inplace=False so you’re not modifying df. You want either

 df.drop_duplicates(subset=None, keep="first", inplace=True)

or

 df = df.drop_duplicates(subset=None, keep="first", inplace=False)

More Related Contents:

  1. Drop all duplicate rows across multiple columns in Python Pandas
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. Append existing excel sheet with new dataframe using python pandas
  4. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  5. Remove pandas rows with duplicate indices
  6. Remove duplicates by columns A, keeping the row with the highest value in column B
  7. Convert Excel style date with pandas
  8. Import multiple excel files into python pandas and concatenate them into one dataframe
  9. Pandas: Looking up the list of sheets in an excel file
  10. Group duplicate column IDs in pandas dataframe
  11. How to concatenate two dataframes without duplicates?
  12. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  13. append dataframe to excel with pandas
  14. pandas xlsxwriter, format table header – not sheet header
  15. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  16. Refresh Excel External Data with Python
  17. How can I see the formulas of an excel spreadsheet in pandas / python?
  18. How to obtain sheet names from XLS files without loading the whole file?
  19. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  20. Merge rows based on value (pandas to excel – xlsxwriter)
  21. From password-protected Excel file to pandas DataFrame
  22. Write to StringIO object using Pandas Excelwriter?
  23. Leave dates as strings using read_excel function from pandas in python
  24. Putting many python pandas dataframes to one excel worksheet
  25. Pandas: Reading Excel with merged cells
  26. How to repeat a Pandas DataFrame?
  27. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  28. Pandas: parse merged header columns from Excel
  29. Python Pandas – Read csv file containing multiple tables
  30. How to “select distinct” across multiple data frame columns in pandas?

Leave a Comment