import housecanary, pandas, csv, json, time
from requests import get

client = housecanary.ApiClient("T5UV26YA2LNB6T602X7L", "PwTHSj2wMI8IR9jFPIB7llDlJ3BeX8Rt")
user = 'jack@patchhomes.com'
password = 'kj6qje1qaz'
addresses = pandas.read_csv('inputaddresses2.csv')

with open('hcdata8.csv','a') as csvfile:
 for address in addresses.iterrows():
  try:
   zipcode = address[1].zipcode
   housevals = [zipcode]
   zipcode = str(int(zipcode))
   if len(zipcode) == 4: zipcode = '0' + zipcode
   result = client.zip.details(zipcode)
   print(result.text)
   for val in json.loads(result.text)[0]['zip/details']['result']['single_family'].values(): housevals.append(val)
   # for val in json.loads(result.text)[0]['zip/details']['result']['multi_family'].values(): housevals.append(val)
   # for val in json.loads(result.text)[0]['zip/details']['result']['historical'].values(): housevals.append(val)
   #result2 = get('https://api.housecanary.com/v2/zip/market_grade?zipcode='+zipcode, auth=(user, password))
   #housevals.append(json.loads(result2.text)[0]['zip/market_grade']['result']['market_grade'])
   housevals.append('')
   result3 = client.zip.hpi_forecast(zipcode)
   for val in json.loads(result3.text)[0]['zip/hpi_forecast']['result'].values(): housevals.append(val)
   print(json.loads(result.text)[0]['zip/details']['result'])
   #print(json.loads(result2.text)[0]['zip/market_grade']['result']['market_grade'])
   print(json.loads(result3.text)[0]['zip/hpi_forecast']['result'])
   print(housevals)
   csvfile.write(','.join([str(i) for i in housevals])+'\n')
   time.sleep(1)
  except:
   csvfile.write(zipcode+'\n')
   time.sleep(1)