Python script to parse a CSV for a ZIP code and then query Mapquest's API for details between source and destination

mapquest_api.py

import requests
import csv

# zip code api variables
API_URL = 'http://www.mapquestapi.com/directions/v2/route'
KEY = 'SECRET'
DEST = 'ZIP_CODE_HERE'

# csv variables
FILE = '/path/to/geo_zip.csv'

with open(FILE, 'rb') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        if row['zip'] == "":
            print("No Zip","Error")
        else:
            ORIG = row['zip']
            payload = {'from': ORIG,'to': DEST,'key': KEY }
            r = requests.get(API_URL, params=payload)
            data = r.json()
            try:
                d = data['route']['distance']
                print(ORIG, d)
            except KeyError:
                d = "Error"
                print(ORIG, d)