Python Pandas delete multiple rows based on column value

Question

I am trying to delete some rows based on column values. I am using pandas.

I have four key words for which I want to check a particular column.

df_1[df_1['Item'] != 'YoY Growth'] I know this will delete a column that has 'YoY Growth' however I have not found an efficient way to combine all my key words into one line so I can delete all the rows containing any of the key words ?

I also tried using the method below but I am having some trouble with syntax

indexNames = df_1[ df_1['Customer'] == 'YoY Growth'].index

indexNames = df_1[ df_1['Customer'] == 'WoW Growth'].index

df_1.drop(indexNames)

df_1[~df_1['Customer'].isin(['YoY Growth', 'WoW Growth'])] ? — Henry Ecker
– Henry Ecker ♦, Commented May 10, 2021 at 13:04

AlexTorx · Accepted Answer · 2021-05-10 13:18:21Z

5

Simply do :

indexNames = df_1[df_1['Customer'].isin(['YoY Growth', 'WoW Growth'])].index
df_1.drop(indexNames)

answered May 10, 2021 at 13:18

AlexTorx

8056 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Pandas delete multiple rows based on column value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related