How to drop rows from pandas data frame that contains a particular string in a particular column? [duplicate]

by

pandas has vectorized string operations, so you can just filter out the rows that contain the string you don’t want:

In [91]: df = pd.DataFrame(dict(A=[5,3,5,6], C=["foo","bar","fooXYZbar", "bat"]))

In [92]: df
Out[92]:
   A          C
0  5        foo
1  3        bar
2  5  fooXYZbar
3  6        bat

In [93]: df[~df.C.str.contains("XYZ")]
Out[93]:
   A    C
0  5  foo
1  3  bar
3  6  bat

More Related Contents:

  1. Pandas percentage of total with groupby
  2. Scatter plots in Pandas/Pyplot: How to plot by category [duplicate]
  3. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  4. How to add pandas data to an existing csv file?
  5. How to explode a list inside a Dataframe cell into separate rows
  6. How do I operate on a DataFrame with a Series for every column?
  7. Modifying a subset of rows in a pandas dataframe
  8. Naming returned columns in Pandas aggregate function? [duplicate]
  9. replace column values in one dataframe by values of another dataframe
  10. Matplotlib DateFormatter for axis label not working
  11. How to plot multi-color line if x-axis is date time index of pandas
  12. Splitting timestamp column into separate date and time columns
  13. ‘utf-8’ codec can’t decode byte 0x92 in position 18: invalid start byte
  14. Pandas – Compute z-score for all columns
  15. How can I use cumsum within a group in Pandas?
  16. How to group DataFrame by a period of time?
  17. Why does df.apply(tuple) work but not df.apply(list)?
  18. Plot multiple columns of pandas DataFrame on the bar chart
  19. Python: Random selection per group
  20. Keep selected column as DataFrame instead of Series
  21. How to get unique values from multiple columns in a pandas groupby
  22. Merge a list of pandas dataframes
  23. How do I delete a column that contains only zeros in Pandas?
  24. Pandas reindex dates in Groupby
  25. How to repeat a Pandas DataFrame?
  26. Pandas ParserError EOF character when reading multiple csv files to HDF5
  27. Get column name where value is something in pandas dataframe
  28. Split Python sequence (time series/array) into subsequences with overlap
  29. start index at 1 for Pandas DataFrame
  30. Multi Index Sorting in Pandas

Leave a Comment