Drop rows on multiple conditions in pandas dataframe

by

drop is a method, you are calling it using [], that is why it gives you:

'method' object is not subscriptable

change to () (a normal method call) and it should work:

import pandas as pd

df = pd.DataFrame({"col_1": (0.0, 0.0, 1.0, 1.0, 0.0, 1.0, 1.0),
                   "col_2": (0.0, 0.24, 1.0, 0.0, 0.22, 3.11, 0.0),
                   "col_3": ("Mon", "Tue", "Thu", "Fri", "Mon", "Tue", "Thu")})

df_new = df.drop(df[(df['col_1'] == 1.0) & (df['col_2'] == 0.0)].index)
print(df_new)

Output

   col_1  col_2 col_3
0    0.0   0.00   Mon
1    0.0   0.24   Tue
2    1.0   1.00   Thu
4    0.0   0.22   Mon
5    1.0   3.11   Tue

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. Adding value labels on a matplotlib bar chart
  3. Binning a column with Python Pandas
  4. Pandas column of lists, create a row for each list element
  5. Pandas Dataframe line plot display date on xaxis
  6. Best way to join / merge by range in pandas
  7. Compare two DataFrames and output their differences side-by-side
  8. How to plot and annotate a grouped bar chart
  9. pandas: merge (join) two data frames on multiple columns
  10. Pandas Extract Number from String
  11. How do I find numeric columns in Pandas?
  12. How to flatten a pandas dataframe with some columns as json?
  13. pandas groupby to nested json
  14. Element-wise logical OR in Pandas
  15. Pandas won’t fillna() inplace
  16. Pandas: Difference between pivot and pivot_table. Why is only pivot_table working?
  17. Running sum in pandas (without loop)
  18. How to estimate how much memory a Pandas’ DataFrame will need?
  19. FastAPI is very slow in returning a large amount of JSON data
  20. Boxplot of Multiple Columns of a Pandas Dataframe on the Same Figure (seaborn)
  21. Pandas plot doesn’t show
  22. Filtering pandas dataframe with multiple Boolean columns
  23. Pandas bar plot with binned range
  24. Add numpy array as column to Pandas data frame
  25. Python: How to drop a row whose particular column is empty/NaN?
  26. Discrete legend in seaborn heatmap plot
  27. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  28. Why is NaN considered as a float?
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Wide to long data transform in pandas

Leave a Comment