In [7]:
import os
os.chdir('../raw_data')
os.listdir('.')
import pandas as pd
import sqlalchemy
data = pd.read_excel('Hack4Cause_Housing_BP_Issued_Phased_and_NonPhased_1.1.015_12.31.15(FINAL).xlsx','BP_Issued_NonPh_clean')
In [12]:
engine = sqlalchemy.create_engine('postgresql://cityview:testthis@localhost/cityview')
data.to_sql(con=engine,name='bp_neighbors')