In [ ]:

    

import pandas as pd


    

In [ ]:

    

kampala = pd.read_csv('data/processed/KAMPALA.csv')


    

In [ ]:

    

eng_ones = kampala[kampala['ENG'] == 1]
sci_ones = kampala[kampala['SCI'] == 1]
math_ones = kampala[kampala['MAT'] == 1]
sst_ones = kampala[kampala['SST'] == 1]


    

In [ ]:

    

print('\nENGLISH DISTINCTION 1(top 10)')
print(eng_ones['SCHOOL'].value_counts().head(10))
print('\nMATHEMATICS DISTINCTION 1(top 10)')
print(math_ones['SCHOOL'].value_counts().head(10))
print('\nSCIENCE DISTINCTION 1(top 10)')
print(sci_ones['SCHOOL'].value_counts().head(10))
print('\nSOCIAL STUDIES DISTINCTION 1(top 10)')
print(sst_ones['SCHOOL'].value_counts().head(10))


    

In [ ]:

    

ungraded = kampala[kampala['DIV']==0]


    

In [ ]:

    

ungraded['SCHOOL'].value_counts()


    

In [ ]: