How to determine whether a Pandas Column contains a particular value

by

in of a Series checks whether the value is in the index:

In [11]: s = pd.Series(list('abc'))

In [12]: s
Out[12]: 
0    a
1    b
2    c
dtype: object

In [13]: 1 in s
Out[13]: True

In [14]: 'a' in s
Out[14]: False

One option is to see if it’s in unique values:

In [21]: s.unique()
Out[21]: array(['a', 'b', 'c'], dtype=object)

In [22]: 'a' in s.unique()
Out[22]: True

or a python set:

In [23]: set(s)
Out[23]: {'a', 'b', 'c'}

In [24]: 'a' in set(s)
Out[24]: True

As pointed out by @DSM, it may be more efficient (especially if you’re just doing this for one value) to just use in directly on the values:

In [31]: s.values
Out[31]: array(['a', 'b', 'c'], dtype=object)

In [32]: 'a' in s.values
Out[32]: True

More Related Contents:

  1. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  2. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  3. Get the row(s) which have the max value in groups using groupby
  4. Error: pandas hashtable keyerror
  5. Writing a pandas DataFrame to CSV file
  6. Remove unwanted parts from strings in a column
  7. pandas: How do I split text in a column into multiple rows?
  8. Pandas read_csv low_memory and dtype options
  9. Pandas read_csv from url
  10. How to write DataFrame to postgres table
  11. Appending pandas dataframes generated in a for loop
  12. Pandas DataFrame stack multiple column values into single column
  13. unique combinations of values in selected columns in pandas data frame and count
  14. Pandas Merge – How to avoid duplicating columns
  15. pandas read_csv and filter columns with usecols
  16. import text to pandas with multiple delimiters
  17. How to plot stacked event duration (Gantt Charts)
  18. Print very long string completely in pandas dataframe
  19. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  20. How do I filter a pandas DataFrame based on value counts?
  21. Lambda including if…elif…else
  22. Pandas query function not working with spaces in column names
  23. Pandas DataFrame sort by categorical column but by specific class ordering
  24. Python pandas cumsum() reset after hitting max
  25. Remove NaN values from pandas dataframe and reshape table [duplicate]
  26. plotting value_counts() in seaborn barplot
  27. How to resample a dataframe with different functions applied to each column?
  28. Convert a column of timestamps into periods in pandas
  29. how to specify the datetime format in read_csv
  30. Sorting a pandas series

Leave a Comment