Python & Pandas: How to query if a list-type column contains something?

by

You can use apply for create mask and then boolean indexing:

mask = df.genre.apply(lambda x: 'comedy' in x)
df1 = df[mask]
print (df1)
                       genre
0           [comedy, sci-fi]
1  [action, romance, comedy]

More Related Contents:

  1. How to provide a reproducible copy of your DataFrame with to_clipboard()
  2. Combine two columns of text in pandas dataframe
  3. How to apply a function to two columns of Pandas dataframe
  4. Dynamically evaluate an expression from a formula in Pandas
  5. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  6. Load data from txt with pandas
  7. Add Leading Zeros to Strings in Pandas Dataframe
  8. Pandas convert dataframe to array of tuples
  9. Coloring Cells in Pandas
  10. How to import data from mongodb to pandas?
  11. How to group a pandas dataframe by a defined time interval?
  12. How to sort a Pandas DataFrame by index?
  13. custom matplotlib plot : chess board like table with colored cells
  14. Adding calculated column(s) to a dataframe in pandas
  15. How do you plot a vertical line on a time series plot in Pandas?
  16. pandas applying regex to replace values
  17. why does pandas rolling use single dimension ndarray
  18. pandas two dataframe cross join [duplicate]
  19. Bin pandas dataframe by every X rows
  20. module ‘pandas’ has no attribute ‘rolling_mean’
  21. Convert dataframe index to datetime
  22. Python: Removing Rows on Count condition
  23. Get first row of dataframe in Python Pandas based on criteria
  24. How to specify the type of pandas series elements in type hints?
  25. how to save a pandas DataFrame to an excel file?
  26. Excel VLOOKUP equivalent in pandas
  27. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  28. Add image annotations to bar plots
  29. Seaborn multiple barplots
  30. Add density curve on the histogram

Leave a Comment