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'))]

Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. Find column whose name contains a specific string
  3. How to test if a string contains one of the substrings in a list, in pandas?
  4. add a string prefix to each value in a string column using Pandas
  5. Remove unwanted parts from strings in a column
  6. Converting a column within pandas dataframe from int to string
  7. String concatenation of two pandas columns
  8. Pandas DataFrame stored list as string: How to convert back to list
  9. Pandas column access w/column names containing spaces
  10. Remove first x number of characters from each row in a column of a Python dataframe
  11. Python – Turn all items in a Dataframe to strings
  12. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  13. How to flatten a hierarchical index in columns
  14. Pandas read_csv: low_memory and dtype options
  15. Get the row(s) which have the max value in groups using groupby
  16. Normalize columns of a dataframe
  17. How do I Pandas group-by to get sum?
  18. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  19. How to loop over grouped Pandas dataframe?
  20. How to replace NaNs by preceding or next values in pandas DataFrame?
  21. Compare two DataFrames and output their differences side-by-side
  22. Insert a row to pandas dataframe
  23. Convert pandas data frame to series
  24. How to add a suffix (or prefix) to each column name?
  25. How to lowercase a pandas dataframe string column if it has missing values?
  26. Pandas split DataFrame by column value
  27. ‘DataFrame’ object has no attribute ‘sort’
  28. Filtering Pandas Dataframe using OR statement
  29. substring of an entire column in pandas dataframe
  30. Pandas version of rbind
  31. pandas get the row-wise minimum value of two or more columns
  32. Fast punctuation removal with pandas
  33. SQL-like window functions in PANDAS: Row Numbering in Python Pandas Dataframe
  34. Diff of two Dataframes
  35. Python / Pandas – GUI for viewing a DataFrame or Matrix [closed]
  36. How to delete multiple pandas (python) dataframes from memory to save RAM?
  37. Numpy “where” with multiple conditions
  38. return max value from pandas dataframe as a whole, not based on column or rows
  39. Set MultiIndex of an existing DataFrame in pandas
  40. How can I use cumsum within a group in Pandas?
  41. Pandas DataFrame: apply function to all columns
  42. Returning multiple values from pandas apply on a DataFrame
  43. How to select a range of values in a pandas dataframe column?
  44. How to pivot a dataframe in Pandas? [duplicate]
  45. How to do/workaround a conditional join in python Pandas?
  46. Create single row python pandas dataframe
  47. Group by and find top n value_counts pandas
  48. Create multiple dataframes in loop
  49. Reading a pickle file (PANDAS Python Data Frame) in R
  50. Nested Json to pandas DataFrame with specific format

Leave a Comment