drop row with value pandas code example
Example 1: python - exclude rowin data frame based on value
df = df[df.myvar != 0]
df = df[df.myvar < 2]
Example 2: dataframe drop rows by column value
df = df[df.line_race != 0]
Example 3: 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)
df = df[~df['date'].isin(a)]
print(df)
Example 4: drop row pandas column value not a number
In [215]:
df[df['entrytype'].apply(lambda x: str(x).isdigit())]
Out[215]:
entrytype
0 0
1 1
4 2