Intersection of two pandas dataframes based on column entries

by

You can merge them so:

s1 = pd.merge(dfA, dfB, how='inner', on=['S', 'T'])

To drop NA rows:

s1.dropna(inplace=True)

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Convert DataFrame column type from string to datetime
  4. How to convert an XML file to nice pandas dataframe?
  5. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  6. Can pandas automatically read dates from a CSV file?
  7. Selecting a row of pandas series/dataframe by integer index
  8. df.append() is not appending to the DataFrame
  9. pandas dataframe str.contains() AND operation
  10. Pandas groupby mean – into a dataframe?
  11. How do I find the closest values in a Pandas series to an input number?
  12. pandas groupby without turning grouped by column into index
  13. How do I count the NaN values in a column in pandas DataFrame?
  14. getting the index of a row in a pandas apply function
  15. Tilde sign in pandas DataFrame
  16. Drop columns whose name contains a specific string from pandas DataFrame
  17. Find the unique values in a column and then sort them
  18. how do I calculate a rolling idxmax
  19. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  20. python Pandas DataFrame copy(deep=False) vs copy(deep=True) vs ‘=’
  21. From password-protected Excel file to pandas DataFrame
  22. How to filter a pandas dataframe based on the length of a entry
  23. How can repetitive rows of data be collected in a single row in pandas?
  24. How is pandas groupby method actually working?
  25. Replace value for a selected cell in pandas DataFrame without using index
  26. Python pandas: how to remove nan and -inf values
  27. How to summarize on different groupby combinations?
  28. How to upload a CSV file in FastAPI and convert it into a Pandas Dataframe?
  29. DataFrame object has no attribute append
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment