In [1]:

    

import pandas as pd


    

In [2]:

    

!ls


    

    




 1527858509148_Budget-2018-19.xlsx
'Assam Budget Data Audit on Excel File - processed file.ipynb'
 assam_budget.sqlite
'Assam CSV Audit.ipynb'
 assam_processed_data.csv
 Budget-2018-19.xlsx
'Data Validation for processed data.ipynb'
 plan_sample.csv

In [3]:

    

data = pd.read_csv('assam_processed_data.csv')


    

In [4]:

    

data_2016 = data[data['ACTUALS 2016-17'] > 0]


    

In [5]:

    

data_2016[data_2016['Minor Head'].fillna('').str.endswith('Non')]['HEAD DESCRIPTION'].tolist()


    

    
Out[5]:





[]

In [6]:

    

data[data['Minor Head'].fillna('').str.endswith('Non')]['HEAD DESCRIPTION'].tolist()


    

    
Out[6]:





[]

In [11]:

    

data[data['Major Head'].fillna('').str.endswith('Non')]['HEAD DESCRIPTION'].tolist()


    

    
Out[11]:





[]

In [ ]:

    

data