In [3]:

    

import pandas as pd
import os


    

In [4]:

    

permitFile = '../raw_data/Hack4Cause_Housing_BP_Issued_Phased_and_NonPhased_1.1.015_12.31.15(FINAL).xlsx'


    

In [5]:

    

data = pd.read_excel(permitFile, 'BP_Issued_NonPh_clean')


    

In [6]:

    

data.columns


    

    
Out[6]:





Index(['log_yy', 'log_number', 'log_sequence', 'issued_date',
       'scope_of_work_desc', 'proposed_usc', 'bpr_use_desc', 'proposed_units',
       'neighborhood', 'x_coordinate', 'y_coordinate', 'comments',
       'existing_use_code', 'existing_use', 'current_units',
       'application_received_date', 'multiple_use_code',
       'bpr_multiple_use_desc', 'project_name', 'address', 'maplot',
       'EE_year_issued', 'EE_housingtype', 'EE_housingmixtype'],
      dtype='object')

In [16]:

    

fh = open('C:/Users/Heron/Documents/python/c-dash/cityview/web/html/data/permits.json', 'w')
fh.write(clean.to_json())
fh.close()


    

In [ ]: