/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

0 vote247 views1 answer
Comment interpreter tuple python avec valeur unique
Python
16 votes253 views5 answers
Primes in python
Python
0 vote263 views3 answers
Move window with overrideredirect
Python
0 vote251 views1 answer
How to code discord bot 8ball python
Python
0 vote276 views1 answer
PIL Make Circle
Python
1 vote266 views1 answer
Passing Functions Around python
Python
6 votes258 views1 answer
Change maximum recursion depth python
Python
1 vote257 views1 answer
FutureWarning: Input image dtype is bool. Interpolation is not defined with bool data type. Please set order to 0 or explicitly cast input image to another data type. Starting from version 0.19 a ValueError will be raised instead of this warning.
Python
0 vote240 views1 answer
Convert_hex_to_ASCII_3.py
Python
-4 votes263 views4 answers
Latest django version
Python