How to remove rows in a Pandas dataframe if the same row exists in another dataframe?

by

You an use merge with parameter indicator and outer join, query for filtering and then remove helper column with drop:

DataFrames are joined on all columns, so on parameter can be omit.

print (pd.merge(a,b, indicator=True, how='outer')
         .query('_merge=="left_only"')
         .drop('_merge', axis=1))
   0   1
0  1  10
2  3  30

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Get the row(s) which have the max value in groups using groupby
  5. Error: pandas hashtable keyerror
  6. Remove unwanted parts from strings in a column
  7. Combine Date and Time columns using python pandas
  8. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  9. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  10. Pandas Timedelta in Days
  11. How to add value labels on a bar chart
  12. How to remove blanks/NA’s from dataframe and shift the values up
  13. Why does my Pandas DataFrame not display new order using `sort_values`?
  14. python/pandas: convert month int to month name
  15. How to check if a column exists in Pandas
  16. Difference(s) between merge() and concat() in pandas
  17. Seaborn showing scientific notation in heatmap for 3-digit numbers
  18. Format certain floating dataframe columns into percentage in pandas
  19. How can I see the formulas of an excel spreadsheet in pandas / python?
  20. How to annotate each segment of a stacked bar chart
  21. How to swap two DataFrame columns?
  22. Convert a column of datetimes to epoch in Python
  23. How to implode(reverse of pandas explode) based on a column
  24. Pandas concat yields ValueError: Plan shapes are not aligned
  25. how to replace an entire column on Pandas.DataFrame
  26. Creating dummy variables in pandas for python
  27. Load CSV to Pandas MultiIndex DataFrame
  28. Python pandas – new column’s value if the item is in the list
  29. bash: Python import – Command not found for pandas
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment