How to use str.contains() with multiple expressions in pandas dataframes

by

They should be one regular expression, and should be in one string:

"nt|nv"  # rather than "nt" | " nv"
f_recs[f_recs['Behavior'].str.contains("nt|nv", na=False)]

Python doesn’t let you use the or (|) operator on strings:

In [1]: "nt" | "nv"
TypeError: unsupported operand type(s) for |: 'str' and 'str'

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. Fast punctuation removal with pandas
  5. Remove unwanted parts from strings in a column
  6. String concatenation of two pandas columns
  7. Find column whose name contains a specific string
  8. add a string prefix to each value in a string column using Pandas
  9. pandas dataframe str.contains() AND operation
  10. Pandas DataFrame stored list as string: How to convert back to list
  11. Pandas column access w/column names containing spaces
  12. How to remove square bracket from pandas dataframe
  13. Strip / trim all strings of a dataframe
  14. NLTK-based text processing with pandas
  15. Left justify string values in a pandas DataFrame
  16. Count number of words per row
  17. Converting a column within pandas dataframe from int to string
  18. Capitalize first letter of each word in a dataframe column
  19. FutureWarning: The default value of regex will change from True to False in a future version
  20. Copy text between parentheses in pandas DataFrame column into another column
  21. SQL / Pandas equivalent
  22. Selecting multiple columns in a Pandas dataframe
  23. How to groupby consecutive values in pandas DataFrame
  24. How to reset index in a pandas dataframe? [duplicate]
  25. selecting from multi-index pandas
  26. Dataframe set_index not setting
  27. Python Pandas update a dataframe value from another dataframe
  28. python dataframe pandas drop column using int
  29. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  30. append dictionary to data frame

Leave a Comment