/Python/Delete rows based on condition python

Delete rows based on condition python

Pandas drop rows with value in list

import pandas as pd

a = ['2015-01-01' , '2015-02-01']

df = pd.DataFrame(data={'date':['2015-01-01' , '2015-02-01', '2015-03-01' , '2015-04-01', '2015-05-01' , '2015-06-01']})

print(df)
#         date
#0  2015-01-01
#1  2015-02-01
#2  2015-03-01
#3  2015-04-01
#4  2015-05-01
#5  2015-06-01

df = df[~df['date'].isin(a)]

print(df)
#         date
#2  2015-03-01
#3  2015-04-01
#4  2015-05-01
#5  2015-06-01

Source: stackoverflow.com

Delete rows based on condition python

df = df.drop(df[df.score < 50].index)

Source: stackoverflow.com

Delete rows based on condition python

df.drop(df[df.score < 50].index, inplace=True)

Source: stackoverflow.com

Similar codes

0 vote141 views1 answer
How to check if all values in list are equal python
Python
0 vote130 views1 answer
How to get the duration of audio python
Python
0 vote163 views1 answer
Django month name from month number
Python Django
13 votes148 views6 answers
Python length
Python
0 vote129 views1 answer
Python loop array 0,101/100
Python
0 vote151 views2 answers
Aes in python
Python
75 votes125 views2 answers
Python write to file while reading
Python
-1 vote146 views1 answer
How to store categorical variables in separate dataframe
Python
-1 vote132 views1 answer
Img_sm = pygame.transform.scale(img, (32, 32))
Python
2 votes132 views1 answer
Matplotlib plot remove margins
Python