/Python/Remove rows if not matching with value in df

Remove rows if not matching with value in df

# Quick Examples

#Using drop() to delete rows based on column value
df.drop(df[df['Fee'] >= 24000].index, inplace = True)

# Remove rows
df2 = df[df.Fee >= 24000]

# If you have space in column name
# Specify column name with in single quotes
df2 = df[df['column name']]

# Using loc
df2 = df.loc[df["Fee"] >= 24000 ]

# Delect rows based on multiple column value
df2 = df[ (df['Fee'] >= 22000) & (df['Discount'] == 2300)]

# Drop rows with None/NaN
df2 = df[df.Discount.notnull()]

Remove row if all are the same value pandas

print (df['S'] != df['T'])
0    False
1     True
2     True
3     True
4    False
5     True
6     True
7     True
8    False
dtype: bool

df = df[df['S'] != df['T']]
print (df)
   S  T  W           U
1  A  B  0  Undirected
2  A  C  1  Undirected
3  B  A  0  Undirected
5  B  C  1  Undirected
6  C  A  1  Undirected
7  C  B  1  Undirected

Source: stackoverflow.com

Similar codes

1 vote130 views1 answer
Django manger
Python
0 vote113 views1 answer
Pandas show head and tail
Python
10 votes116 views3 answers
Isletter python
Python
10 votes125 views4 answers
Set method in python
Python
42 votes115 views6 answers
Train test split pandas
Python
0 vote194 views1 answer
Pandas index from 1
Python
40 votes114 views3 answers
Train dev test split sklearn
Python
0 vote119 views1 answer
Pandas crosstab function(counting) frequencies
Python
0 vote114 views1 answer
Unable to import flask pylint
Python
0 vote133 views1 answer
Re python split()
Python