python_god_web_api

http://lbs.amap.com/api/webservice/guide/api/search

#!/usr/bin/env python3
#-*- coding:utf-8 -*-
'''
利用高德地图api实现地址和经纬度的转换
'''
import requests
def geocode(address):
        parameters = {'address': address, 'key': 'e798a5bfb344a09977b79552ae415974'}
        base = 'http://restapi.amap.com/v3/geocode/geo'
        response = requests.get(base, parameters)
        answer = response.json()
        print(address + "的经纬度：", answer['geocodes'][0]['location'])
if __name__=='__main__':
        #address = input("请输入地址:")
        address = '北京市海淀区'
        geocode(address)

import xlrd
def readXlsx(self, filename='CenterBottom2013.xlsx', sheetname='Sheet1'):
        rawData = []
        if (os.path.isfile(self.fn_rawDat)):
            with open(self.fn_rawDat, 'rb') as f:
                self.rawDat = np.load(f)
        else:
            workBook = xlrd.open_workbook(filename)
            bookSheet = workBook.sheet_by_name(sheetname)
            # 从第二行开始读取，因为第一行有标签
            for row in range(1, bookSheet.nrows):
                rowData = []
                for col in range(bookSheet.ncols):
                    cel = bookSheet.cell(row, col)
                    try:
                        val = cel.value
                    except:
                        pass
                    if type(val) == float:
                        val = float(val)
                    else:
                        val = str(val)
                    rowData.append(val)
                rawData.append(rowData)
            self.rawDat = np.array(rawData)
            with open(self.fn_rawDat, 'wb') as f:
                np.save(f, self.rawDat)
        return self.rawDat

Read Excel files
Transfer the address to locaion info
Put back