Question

How to select pandas DataFrame rows that not with in multiple values on single column in Python

Answer 1

import pandas as pd

df = pd.DataFrame(
	[['Tom', 91, 80, 94],
	 ['Emmy', 98, 95, 96],
	 ['Rubeus', 87, 81, 87],
	 ['Dumbledore', 99, 100, 98],
	 ['Axel', 75, 85, 90]],
	columns=['name', 'algebra', 'python', 'java'])

q = df.loc[(~df['python'].isin(['80','85']))]

print(q)

 
 
 
'''
run:
 
          name  algebra  python  java
1        Emmy       98      95    96
2      Rubeus       87      81    87
3  Dumbledore       99     100    98

'''

 

70+ SQL courses for beginners and professionals