Check if rows in one dataframe exist in another dataframe

by

You can use merge with parameter indicator, then remove column Rating and use numpy.where:

df = pd.merge(df1, df2, on=['User','Movie'], how='left', indicator="Exist")
df.drop('Rating', inplace=True, axis=1)
df['Exist'] = np.where(df.Exist == 'both', True, False)
print (df)
   User  Movie  Exist
0     1    333  False
1     1   1193   True
2     1      3  False
3     2    433  False
4     3     54   True
5     3    343  False
6     3     76   True

More Related Contents:

  1. How to change column names from numbers to names [closed]
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. How to replace NaNs by preceding or next values in pandas DataFrame?
  4. Performant cartesian product (CROSS JOIN) with pandas
  5. Python: pandas merge multiple dataframes
  6. Merge two dataframes by index
  7. Combine two pandas Data Frames (join on a common column)
  8. Find column whose name contains a specific string
  9. Calculate average of every x rows in a table and create new table
  10. Conditionally fill column values based on another columns value in pandas
  11. How to deal with multi-level column names downloaded with yfinance
  12. Rolling Mean on pandas on a specific column
  13. Pandas deleting row with df.drop doesn’t work
  14. Count number of words per row
  15. How to do “(df1 & not df2)” dataframe merge in pandas?
  16. What is the fastest and most efficient way to append rows to a DataFrame?
  17. How to merge multiple dataframes
  18. Updating a value in a pandas dataframe in an iterrows loop
  19. append dictionary to data frame
  20. Anti-Join Pandas
  21. Python pandas: how to remove nan and -inf values
  22. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  23. Python Pandas – Lookup a variable column depending on another column’s value
  24. Confusion about pandas copy of slice of dataframe warning
  25. How are iloc and loc different?
  26. Concatenate strings from several rows using Pandas groupby
  27. Efficient way to unnest (explode) multiple list columns in a pandas DataFrame
  28. Moving Average Pandas
  29. ‘DataFrame’ object has no attribute ‘sort’
  30. Creating an empty Pandas DataFrame, and then filling it

Leave a Comment