Question

How to select pandas DataFrame rows whose column value equals to some value in Python

Answer 1

import pandas as pd

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

q = df.loc[df['python'] == 85]

print(q)

 
 
 
'''
run:
 
    name  algebra  python  java
1  Emmy       98      85    96
4  Axel       75      85    90

'''

 

70+ SQL courses for beginners and professionals