Drop a column based on row values

Question

How could I drop a column where the row value is equal to 1?

Example: I want to keep the staff names where No. leaves taken is 0 and drop the rest of the columns

                     Jack    Mary    Huin   Lean
No. sales            340     200     100     122
No. leaves taken       1       0       3       0

Is No. leaves taken on the index? – Jason Baker Oct 10 '22 at 04:21 — Jason Baker, Oct 10 '22 at 04:21
`df.loc[:,(df.loc["No. leaves taken"] == 0)]` – Redox Oct 10 '22 at 04:28 — Redox, Oct 10 '22 at 04:28

Jason Baker · Accepted Answer · 2022-10-10T04:45:56.133

1

Using .loc

df = df.loc[:, (df.filter(items=["No.leaves taken"], axis=0).eq(0)).any()]
print(df)

                 Mary  Lean
                           
No. sales         200   122
No.leaves taken     0     0

edited Oct 10 '22 at 04:45

answered Oct 10 '22 at 04:26

Jason Baker

3,170
2
12
15

Will this not remove columns if Sales=0 as well? – Redox Oct 10 '22 at 04:28

Drop a column based on row values

1 Answers1