日常数据通报及数据分析

日常通报报表


文字描述，

商户维度交易额下降分析，

附近商户引流，python爬虫获取经纬度，建立商户地址数据，

# -*- coding: utf-8 -*-
"""
Created on Tue Dec 29 13:59:36 2020
@author: jixiaokang
"""
import pandas as pd
import requests
import numpy as np
from math import *
from requests.exceptions import RequestException
def getcode(site):
    try:
        parameters = { 'address' : site, 'key': '1dddfee42171d1cf5f8dd5adfe18fc9d'}
        base = 'http://restapi.amap.com/v3/geocode/geo'
        response = requests.get(base, parameters)
        info_site = response.json()
        lng = info_site['geocodes'][0]['location'].split(',')[0]
        lat = info_site['geocodes'][0]['location'].split(',')[1]
        return (lng,lat)
    except:
        (0,0)

"print(getcode('塘沽路463号'))"

data=pd.read_csv(r'D:\1jxk\映射下载数据\附近商户地址.csv')

for i in data['biz_dtl_addr']:
    print(getcode(i))

最终效果，