Comparing 2 columns of two Python Pandas dataframes and getting the common rows

by

This would be easier if you renamed the columns of df2 and then you can compare row-wise:

In [35]:

df2.columns = ['A', 'B']
df2
Out[35]:
    A   B
0  AA  BA
1  AD  BF
2  AF  BF
In [38]:

df1['D'] = (df1[['A', 'B']] == df2).all(axis=1).astype(int)
df1
Out[38]:
    A   B   C  D
0  AA  BA  KK  1
1  AD  BD  LL  0
2  AF  BF  MM  1

More Related Contents:

  1. How to provide a reproducible copy of your DataFrame with to_clipboard()
  2. Filter pandas DataFrame by substring criteria
  3. Combine two columns of text in pandas dataframe
  4. Binning a column with Python Pandas
  5. Compare two DataFrames and output their differences side-by-side
  6. Selecting a row of pandas series/dataframe by integer index
  7. How to reversibly store and load a Pandas dataframe to/from disk
  8. How do I find the closest values in a Pandas series to an input number?
  9. How do I transpose dataframe in pandas without index?
  10. How to select all columns whose names start with X in a pandas DataFrame
  11. Remove reverse duplicates from dataframe
  12. How do I count the NaN values in a column in pandas DataFrame?
  13. Pandas finding local max and min
  14. How to split text in a column into multiple rows
  15. getting the index of a row in a pandas apply function
  16. How to flatten a pandas dataframe with some columns as json?
  17. Pandas merge two dataframes with different columns
  18. Pandas filter dataframe rows with a specific year
  19. Bin pandas dataframe by every X rows
  20. Pandas won’t fillna() inplace
  21. Apply function to each cell in DataFrame
  22. pandas apply function that returns multiple values to rows in pandas dataframe
  23. return max value from pandas dataframe as a whole, not based on column or rows
  24. FastAPI is very slow in returning a large amount of JSON data
  25. How to select rows with NaN in particular column?
  26. Store numpy.array in cells of a Pandas.DataFrame
  27. Filtering pandas dataframe with multiple Boolean columns
  28. Pandas: Incrementally count occurrences in a column
  29. Remove substring from column based on another column
  30. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?

Leave a Comment