Pandas drop row by condition

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

Drop row with condition dataframe

a_dataframe.drop(a_dataframe[a_dataframe.B > 3].index, inplace=True)

Source: kite.com

Pandas drop row by condition

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

Similar codes

6 votes132 views1 answer
Install pip on windows 10 python 3.9
Python
0 vote126 views1 answer
2 variables with statement python
Python
0 vote112 views1 answer
Exclude serializer
Python
12 votes129 views2 answers
New line eval python
Python
0 vote132 views1 answer
Hover show all Y values in Bokeh
Python
1 vote148 views1 answer
Python tts
Python
0 vote161 views1 answer
Decode in django templates
Python Django
8 votes177 views1 answer
Python loop certain number of times
Python
0 vote141 views1 answer
Pythom sum
Python
31 votes207 views1 answer
Flask vs django
Python Django