Search for “does-not-contain” on a DataFrame in pandas

by

You can use the invert (~) operator (which acts like a not for boolean data):

new_df = df[~df["col"].str.contains(word)]

where new_df is the copy returned by RHS.

contains also accepts a regular expression…

If the above throws a ValueError, the reason is likely because you have mixed datatypes, so use na=False:

new_df = df[~df["col"].str.contains(word, na=False)]

Or,

new_df = df[df["col"].str.contains(word) == False]

More Related Contents:

  1. How to deal with SettingWithCopyWarning in Pandas
  2. Apply multiple functions to multiple groupby columns
  3. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  4. GroupBy results to dictionary of lists
  5. Pandas timeseries plot setting x-axis major and minor ticks and labels
  6. How to remove nan value while combining two column in Panda Data frame?
  7. How do I operate on a DataFrame with a Series for every column?
  8. Improve subplot size/spacing with many subplots in matplotlib
  9. Pandas split column into multiple columns by comma
  10. Repeat rows in a pandas DataFrame based on column value
  11. How to use groupby to concatenate strings in python pandas?
  12. Add months to a date in Pandas
  13. Horizontal stacked bar plot and add labels to each section
  14. How to flatten a nested JSON recursively, with flatten_json
  15. replace column values in one dataframe by values of another dataframe
  16. How to add an empty column to a dataframe?
  17. Matplotlib DateFormatter for axis label not working
  18. python pandas dataframe, is it pass-by-value or pass-by-reference
  19. Pandas expand rows from list data available in column
  20. Splitting timestamp column into separate date and time columns
  21. Create Column with ELIF in Pandas
  22. ‘utf-8’ codec can’t decode byte 0x92 in position 18: invalid start byte
  23. Pandas – Compute z-score for all columns
  24. Find date range overlap in python
  25. How do I delete a column that contains only zeros in Pandas?
  26. Updating a value in a pandas dataframe in an iterrows loop
  27. how to save a pandas DataFrame to an excel file?
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. Add image annotations to bar plots
  30. Add density curve on the histogram

Leave a Comment