How to filter a DataFrame column of lists for those that contain a certain item

by

You can use apply, like this.

In [13]: df[df['col'].apply(lambda x: 'b' in x)]
Out[13]: 
         col
0     [a, b]
2  [a, b, c]

Although generally, storing lists in a DataFrame is a bit awkward – you might find some different representation (columns for each element in the list, MultiIndex, etc) that is easier to work with.

More Related Contents:

  1. Python returns "SyntaxError: invalid syntax sys module" [closed]
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. How to sort a dataFrame in python pandas by two or more columns?
  4. How to display pandas DataFrame of floats using a format string for columns?
  5. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  6. Reading an Excel file in python using pandas
  7. How do I create test and train samples from one dataframe with pandas?
  8. How to map numeric data into categories / bins in Pandas dataframe
  9. Check if a string in a Pandas DataFrame column is in a list of strings
  10. Naturally sorting Pandas DataFrame
  11. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  12. converting currency with $ to numbers in Python pandas
  13. How to normalize json correctly by Python Pandas
  14. Insert a Pandas Dataframe into mongodb using PyMongo
  15. Improve Row Append Performance On Pandas DataFrames
  16. Comparing two pandas dataframes for differences
  17. Use Multiple Character Delimiter in Python Pandas read_csv
  18. Merging dataframes based on date range
  19. pandas: replace string with another string
  20. how to merge two data frames based on particular column in pandas python?
  21. How to solve import error for pandas?
  22. I want to multiply two columns in a pandas DataFrame and add the result into a new column
  23. pandas, melt, unmelt preserve index
  24. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  25. Python Pandas – Read csv file containing multiple tables
  26. Group DataFrame in 5-minute intervals
  27. Python Pandas add column for row-wise max value of selected columns [duplicate]
  28. Python Pandas: remove entries based on the number of occurrences
  29. df.append() is not appending to the DataFrame
  30. Replace value for a selected cell in pandas DataFrame without using index

Leave a Comment