Call Baidu Map API, get latitude and longitude data, and then call Baidu Map API, generate heat force diagram
ImportPandas as PDImportNumPy as Npdata= Pd.read_excel (r'd:\\ New Tenant data (recovered). xlsx')ImportRequestsImportJSONImport TimedefGet_long (weizhi): URL="Http://restapi.amap.com/v3/geocode/geo?address={}&output=json&key=***********4b0e539e&city=%e5 %b9%bf%e5%b7%9e". Format (Weizhi)Try: Res=requests.get (URL) data=json.loads (res.text) Loca=data["geocodes"][0][" Location"].split (",") [0]returnLocaexcept: Pass returnNonedefGet_lat (weizhi): URL="http://restapi.amap.com/v3/geocode/geo?address={}&output=json&key=*****994b0e539e&city=%e5%b9% bf%e5%b7%9e". Format (Weizhi)Try: Res=requests.get (URL) data=json.loads (res.text) Loca=data["geocodes"][0][" Location"].split (",") [1] returnLocaexcept: Pass returnnonedata["lat"]=data["Property name"].apply (Get_lat) data["LNG"]=data["Property name"].apply (Get_long)
New_data.to_csv (r "D:\\new_datass.csv")
b=[]with open (R"d:\\new_datass.csv") as F: a=f.readlines () Print (a) for inch A: a=item.strip ("\ n"). Split ("," data=[a[2],a[1]] dic={a[0]:d ata} b.append (DIC)
Python_ Guangzhou house price Heat Force diagram