pandas related problem regarding deleting data from a dataframe

Question

I need to delete rows from a dataframe which have "No" value in column Auto-Investment. How to do that using pandas dataframe?

index = 0
    for x in df3['Auto-Investment']:
        if x == 'No':
            rows = df3.index(index)
            df3.drop(rows, inplace=True)
        index += 1    
    print(df3)

score 2 · Accepted Answer · answered Sep 02 '21 at 10:43

2

try this:

df3 = df3[df3['Auto-Investment'] != 'No']

answered Sep 02 '21 at 10:43

I'mahdi

23,382
5
22
30

@Levsha if this work see this link : https://meta.stackexchange.com/questions/5234/how-does-accepting-an-answer-work – I'mahdi Sep 02 '21 at 10:51

score 1 · Answer 2 · answered Sep 02 '21 at 10:43

1

You can do it by deselecting the ones that are 'no'.

df3 = df3[df3['Auto-Investment']!='No']

answered Sep 02 '21 at 10:43

Babak Fi Foo

926
7
17

It is ok my friend :) we all have been there. – Babak Fi Foo Sep 02 '21 at 12:53

Niv Dudovitch · Answer 3 · 2021-09-02T10:49:15.507

1

Number of solutions:

1. df3 = df3[df3['Auto-Investment']!='No]

2. df3.drop(df3['Auto-Investment']!='No].index, inplace=True)

Discussion on which solution is better: Pandas drop rows vs filter

edited Sep 02 '21 at 10:49

answered Sep 02 '21 at 10:44

Niv Dudovitch

1,614
7
15

lol we just did it exactly the same way and time. – Niv Dudovitch Sep 02 '21 at 10:45
:)))))))))))) Seems that small time difference for such questions is crucial :D – Babak Fi Foo Sep 02 '21 at 10:48
@Levsha What should I do when someone answers my question? https://stackoverflow.com/help/someone-answers Decide if the answer is helpful, and then... - Vote on it - Accept it – Niv Dudovitch Sep 02 '21 at 10:54

pandas related problem regarding deleting data from a dataframe

3 Answers3