Filter by single column

22 Apr 2019

import numpy as np
import pandas as pd

df = pd.read_csv('abc.csv')

df.shape

(7, 5)

df

	student	language	science	maths	history
0	kumar	90	56	34	34
1	kevin	10	34	32	67
2	sammy	90	23	12	32
3	janice	20	67	90	45
4	peter	30	56	45	65
5	prem	90	45	45	34
6	carrol	50	90	45	23

# We will get the students whoever passed science (considering 50 is the pass mark)

df_passed_science = df[df.science > 50]

df_passed_science

	student	language	science	maths	history
0	kumar	90	56	34	34
3	janice	20	67	90	45
4	peter	30	56	45	65
6	carrol	50	90	45	23