Question

How to make a column index in pandas DataFrame and get the 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, 95, 96],
	 ['Rubeus', 87, 81, 87],
	 ['Dumbledore', 99, 100, 98],
	 ['Axel', 75, 95, 90]],
	columns=['name', 'algebra', 'python', 'java'])

df = df.set_index(['python'])

print(df.loc[95])

 
 
 
'''
run:
 
         name  algebra  java
python                     
95      Emmy       98    96
95      Axel       75    90

'''

 

70+ SQL courses for beginners and professionals