Finding the intersection between two series in Pandas

by

Place both series in Python’s set container then use the set intersection method:

s1.intersection(s2)

and then transform back to list if needed.

Just noticed pandas in the tag. Can translate back to that:

pd.Series(list(set(s1).intersection(set(s2))))

From comments I have changed this to a more Pythonic expression, which is shorter and easier to read:

Series(list(set(s1) & set(s2)))

should do the trick, except if the index data is also important to you.

Have added the list(...) to translate the set before going to pd.Series as pandas does not accept a set as direct input for a Series.

More Related Contents:

  1. error when applying function to a series object
  2. Conditional Replace Pandas
  3. How to convert index of a pandas dataframe into a column
  4. Pandas filtering for multiple substrings in series
  5. Keep only date part when using pandas.to_datetime
  6. Strings in a DataFrame, but dtype is object
  7. Pandas: convert categories to numbers
  8. df.append() is not appending to the DataFrame
  9. Python: Pandas Series – Why use loc?
  10. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  11. Combining two Series into a DataFrame in pandas
  12. Convert pandas Series to DataFrame
  13. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  14. Pandas: change data type of Series to String
  15. Pandas pd.Series.isin performance with set versus array
  16. how do I calculate a rolling idxmax
  17. Remove name, dtype from pandas output of dataframe or series
  18. Convert pandas data frame to series
  19. What is the fastest and most efficient way to append rows to a DataFrame?
  20. Compute the running (cumulative) maximum for a series in pandas
  21. Getting a list of indices where pandas boolean series is True
  22. Using replace efficiently in pandas
  23. Convert Pandas series containing string to boolean
  24. How to specify the type of pandas series elements in type hints?
  25. Python Pandas iterate over rows and access column names
  26. Intersection of two pandas dataframes based on column entries
  27. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  28. Sorting a pandas series
  29. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x
  30. Find difference between two data frames

Leave a Comment