Diff of two Dataframes

by

merge the 2 dfs using method ‘outer’ and pass param indicator=True this will tell you whether the rows are present in both/left only/right only, you can then filter the merged df after:

In [22]:
merged = df1.merge(df2, indicator=True, how='outer')
merged[merged['_merge'] == 'right_only']

Out[22]:
  Buyer  Quantity      _merge
3  Carl         2  right_only
4  Mark         1  right_only

More Related Contents:

  1. How to split a dataframe string column into two columns?
  2. Annotate bars with values on Pandas bar plots
  3. Comparing two dataframes and getting the differences [duplicate]
  4. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  5. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  6. Get the name of a pandas DataFrame
  7. pandas concat generates nan values
  8. Pandas Groupby and Sum Only One Column
  9. What is the difference between join and merge in Pandas?
  10. Pandas Dataframe: Replacing NaN with row average
  11. How to read a .xlsx file using the pandas Library in iPython?
  12. Pandas – Number of Months Between Two Dates
  13. “unstack” a pandas column containing lists into multiple rows [duplicate]
  14. Pandas Replace NaN with blank/empty string
  15. Python pandas Filtering out nan from a data selection of a column of strings
  16. How to append rows in a pandas dataframe in a for loop?
  17. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  18. How to drop unique rows in a pandas dataframe?
  19. How to reorder indexed rows based on a list in Pandas data frame
  20. vectorize conditional assignment in pandas dataframe
  21. Pandas DataFrame merge summing column
  22. Mapping ranges of values in pandas dataframe [duplicate]
  23. Binning a column with pandas
  24. Convert month int to month name in Pandas
  25. How to get/set a pandas index column title or name?
  26. Python pandas integer YYYYMMDD to datetime
  27. Pandas: drop columns with all NaN’s
  28. Replace NaN with empty list in a pandas dataframe
  29. Get max value from row of a dataframe in python [duplicate]
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment