python获取地址经伟度_python2.7根据地址名称获取经纬度

# -*- coding: utf-8 -*-

import codecs

import sys

reload(sys)

sys.setdefaultencoding('utf8') # 设置默认编码格式为'utf-8'

import json

import urllib2;

import xlrd

import re

import numpy as np

import io

import unicodecsv as ucsv

import requests

filename = "D:/a/lonlat02.csv"

def readExcel():

workbook = xlrd.open_workbook("D:/lonlat/industry_site_info.xlsx")

sheet = workbook.sheet_by_name("industry_site_info")

print(sheet.nrows)

Scrap_hotel_lists(sheet)

def Scrap_hotel_lists(sheet):

ids = []

Latitudes = []

longitudes = []

dzmcs = []

jdmcs = []

for i in range(1, sheet.nrows):

try:

print (i)

values = sheet.row_values(i)

dzmc = value