Question

How to select pandas DataFrame rows that 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
0   Tom       91      80    94
4  Axel       75      85    90

'''

 

70+ SQL courses for beginners and professionals