Check if string is in a pandas dataframe

by

a['Names'].str.contains('Mel') will return an indicator vector of boolean values of size len(BabyDataSet)

Therefore, you can use

mel_count=a['Names'].str.contains('Mel').sum()
if mel_count>0:
    print ("There are {m} Mels".format(m=mel_count))

Or any(), if you don’t care how many records match your query

if a['Names'].str.contains('Mel').any():
    print ("Mel is there")

More Related Contents:

  1. How do I find the closest values in a Pandas series to an input number?
  2. How to display custom values on a bar plot
  3. How do I count the NaN values in a column in pandas DataFrame?
  4. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  5. How to read file with space separated values in pandas
  6. How to filter a dataframe of dates by a particular month/day?
  7. Ignoring NaNs with str.contains
  8. Python remove stop words from pandas dataframe
  9. Count number of words per row
  10. How to select all columns except one in pandas?
  11. What techniques can be used to measure performance of pandas/numpy solutions
  12. Pandas groupby nlargest sum
  13. Pandas get frequency of item occurrences in a column as percentage [duplicate]
  14. Appending a list or series to a pandas DataFrame as a row?
  15. Move non-empty cells to the left in pandas DataFrame
  16. Python Numpy TypeError: ufunc ‘isfinite’ not supported for the input types
  17. Convert Pandas Series to DateTime in a DataFrame
  18. Expanding pandas data frame with date range in columns
  19. Why is np.where faster than pd.apply
  20. Improve subplot size/spacing with many subplots
  21. Extract column value based on another column in Pandas
  22. Python Pandas: Get index of rows where column matches certain value
  23. Change the color of text within a pandas dataframe html table python using styles and css
  24. Pandas and Matplotlib – fill_between() vs datetime64
  25. pandas – scatter plot with different color legend for each point
  26. Pandas: parse merged header columns from Excel
  27. Remove substring from column based on another column
  28. plotting value_counts() in seaborn barplot
  29. Convert a column of timestamps into periods in pandas
  30. how to specify the datetime format in read_csv

Leave a Comment