Filtering pandas dataframe rows by contains str

by

You could either use .str again to get access to the string methods, or (better, IMHO) use case=False to guarantee case insensitivity:

>>> df = pd.DataFrame({"body": ["ball", "red BALL", "round sphere"]})
>>> df[df["body"].str.contains("ball")]
   body
0  ball
>>> df[df["body"].str.lower().str.contains("ball")]
       body
0      ball
1  red BALL
>>> df[df["body"].str.contains("ball", case=False)]
       body
0      ball
1  red BALL
>>> df[df["body"].str.contains("ball", case=True)]
   body
0  ball

(Note that if you’re going to be doing assignments, it’s a better habit to use df.loc, to avoid the dreaded SettingWithCopyWarning, but if we’re just selecting here it doesn’t matter.)

(Note #2: guess I really didn’t need to specify ’round’ there..)

More Related Contents:

  1. How to change the datetime format in Pandas
  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. Create Pandas DataFrame from a string
  6. Remove unwanted parts from strings in a column
  7. String concatenation of two pandas columns
  8. Find column whose name contains a specific string
  9. add a string prefix to each value in a string column using Pandas
  10. Pandas DataFrame stored list as string: How to convert back to list
  11. Convert columns to string in Pandas
  12. Get last “column” after .str.split() operation on column in pandas DataFrame
  13. How to remove square bracket from pandas dataframe
  14. Remove non-ASCII characters from pandas column
  15. NLTK-based text processing with pandas
  16. Left justify string values in a pandas DataFrame
  17. Count number of words per row
  18. removing newlines from messy strings in pandas dataframe cells?
  19. Filter string data based on its string length
  20. Convert a columns of string to list in pandas
  21. Capitalize first letter of each word in a dataframe column
  22. pandas: replace string with another string
  23. Pandas read_csv dtype leading zeros
  24. FutureWarning: The default value of regex will change from True to False in a future version
  25. How to remove numbers from string terms in a pandas dataframe
  26. Column of lists, convert list to string as a new column
  27. How to use str.contains() with multiple expressions in pandas dataframes
  28. Copy text between parentheses in pandas DataFrame column into another column
  29. pandas combine two strings ignore nan values
  30. pandas – convert string into list of strings [duplicate]

Leave a Comment