pandas dataframe str.contains() AND operation

by

You can do that as follows:

df[(df['col_name'].str.contains('apple')) & (df['col_name'].str.contains('banana'))]

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. How to test if a string contains one of the substrings in a list, in pandas?
  3. Pandas filtering for multiple substrings in series
  4. Remove unwanted parts from strings in a column
  5. String concatenation of two pandas columns
  6. Find column whose name contains a specific string
  7. add a string prefix to each value in a string column using Pandas
  8. Pandas DataFrame stored list as string: How to convert back to list
  9. Pandas column access w/column names containing spaces
  10. How to remove square bracket from pandas dataframe
  11. NLTK-based text processing with pandas
  12. Left justify string values in a pandas DataFrame
  13. Count number of words per row
  14. Converting a column within pandas dataframe from int to string
  15. Capitalize first letter of each word in a dataframe column
  16. How to use str.contains() with multiple expressions in pandas dataframes
  17. Copy text between parentheses in pandas DataFrame column into another column
  18. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  19. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  20. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  21. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  22. Add x and y labels to a pandas plot
  23. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  24. How to replace negative numbers in Pandas Data Frame by zero
  25. Removing the timestamp from a datetime in pandas dataframe
  26. vectorize conditional assignment in pandas dataframe
  27. How can I replicate rows of a Pandas DataFrame?
  28. How to get/set a pandas index column title or name?
  29. Pandas: drop columns with all NaN’s
  30. In Python pandas, start row index from 1 instead of zero without creating additional column

Leave a Comment