Filter pandas DataFrame by substring criteria

by

Based on github issue #620, it looks like you’ll soon be able to do the following:

df[df['A'].str.contains("hello")]

Update: vectorized string methods (i.e., Series.str) are available in pandas 0.8.1 and up.

More Related Contents:

  1. How to test if a string contains one of the substrings in a list, in pandas?
  2. Pandas filtering for multiple substrings in series
  3. Remove unwanted parts from strings in a column
  4. String concatenation of two pandas columns
  5. Find column whose name contains a specific string
  6. add a string prefix to each value in a string column using Pandas
  7. pandas dataframe str.contains() AND operation
  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. Select rows in pandas MultiIndex DataFrame
  19. Python: get a frequency count based on two columns (variables) in pandas dataframe some row appers
  20. Find the max of two or more columns with pandas
  21. What is the difference between using squared brackets or dot to access a column?
  22. Creating an empty Pandas DataFrame, then filling it?
  23. How to map numeric data into categories / bins in Pandas dataframe
  24. replace column values in one dataframe by values of another dataframe
  25. How can I use cumsum within a group in Pandas?
  26. Why does df.apply(tuple) work but not df.apply(list)?
  27. Merge a list of pandas dataframes
  28. How to repeat a Pandas DataFrame?
  29. Get column name where value is something in pandas dataframe
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment