我们在爬数据的很多时候,获得的地址数据只有经纬度,没有对应的省份、城市信息,这时我们可以根据如下脚本进行获取:
import requests
import csv,time
timenow =time.strftime("%Y-%m-%d-%H%M%S", time.localtime())
file = '省城信息-%s.csv'% (timenow)
#写入表头
with open(file,'a+',encoding='gb18030', newline='') as f:
writer_f = csv.writer(f)
writer_f.writerow(['lt','province','city'])
lt=['39.98412,116.31333,', '39.837001800537,116.422996521,', '39.960687,116.484864,', '39.947200775146,116.53099822998,', '39.9748799999999,116.223839999999,', '39.7489619999999,116.33046,', '40.0246849999999,116.568079999999,', '40.206014,116.22445,', '39.8635329999999,116.31556,', '40.056499481201,116.261001586909,', '39.72679901123,116.108001708979,', '39.818000793457,116.51499938965,', '39.8723983764648,116.669998168945,', '39.869901023193,116.55278242529,', '40.3624769999999,116.803312,', '40.0279,116.45564,', '40.0810012817379,116.31199645996,', '40.08917,116.421459999999,', '39.932637,116.24684,', '39.9696006774902,116.31900024414,', '40.019598,116.374067999999,', '39.9155998229979,116.181999206539,', '40.1202011108398,116.56900024414,', '39.9906459999999,116.319969999999,', '39.97576,116.224496,', '39.866239,116.556241999999,', '39.930194,116.565982,', '39.836982009,116.422817061399,', '39.164853,117.386990999999,', '39,117.661003112789,', '39.050498962402,117.20300292969,', '38.9953994750976,117.275001525878,', '39.1423988342289,117.24900054932,', '39.1367988586425,117.152999877929,', '39.087768907471,117.35576844141,', '39.1551359999999,117.077029999999,', '39.3275229999999,117.096675,', '39.21515,117.2235,', '38.007496,114.528104999999,', '38.010817,114.445121,', '38.118065,114.531829999999,', '38.091248,114.46831,', '38.077465057373,114.551940917968,', '39.642101287842,118.268997192379,', '39.60179901123,118.20400238037,', '40.00019,118.73218,', '39.734724,118.175393999999,', '39.657299041748,118.126998901367,', '39.9742012023929,119.64199829102,', '39.941501617432,119.53500366211,', '39.8735008239746,119.276000976562,', '36.568758592285,114.4369737124,', '36.6152000427246,114.458999633789,', '36.7123985290527,114.255996704101,', '36.6068989999999,114.548191,', '37.0681991577148,114.509002685546,', '37.105856,114.454869,', '37.1041269999999,114.639718,', '38.959802,115.366291,', '38.92783,115.539648,', '38.8236007690429,115.5,', '38.546699523926,114.93099975586,', '38.9256859999999,115.466544999999,', '39.494228,115.971025999999,', '39.3442001342773,115.914001464843,', '38.959296,115.36453,', '40.6986999511718,114.930999755859,', '40.782909393311,114.91516876221,', '40.892265,118.00215,', '41.0260729999999,117.84389,', '37.7405014038089,115.6429977417,', '37.7014009999999,115.685406999999,', '37.7855589999999,115.863325,', '39.5894664492,116.7720020122,', '39.5792999267579,116.75299835205,', '38.7367739999999,116.087326,', '38.2913017272949,116.916458129882,', '38.3221015930179,116.821998596189,', '38.3539009094239,116.855003356929,', '38.449798,116.160679,', '37.87012,112.48081,', '37.7899017333979,112.55799865723,', '37.7778619999999,112.634887,', '37.828800201416,112.536003112792,', '37.807439,112.559959,', '40.0542984008789,113.29499816895,', '40.0464111628419,113.26146158691,', '37.8503990173339,113.623001098629,', '36.2392997741699,113.119277954101,', '36.217300415039,113.080001831054,', '35.5059738159179,112.886993408199,', '35.5098229999999,112.810599999999,', '39.361902,112.427402,', '37.735599517822,112.69300079346,', '37.0461999999999,111.880219999999,', '35.5802079999999,110.701272,', '35.1228964211429,110.95672053516,', '35.334583,111.19683,', '35.071300506592,111.03299713135,', '38.470731,112.739305,', '36.111499786377,111.513999938959,', '36.027115,111.482889999999,', '37.1609992980957,111.766998291015,', '37.5042055727999,111.097826545,', '40.86669921875,111.697998046875,', '40.8266983032229,111.615997314449,', '40.7774009704589,111.606002807617,', '40.6629981994629,109.875,', '40.68907,109.857659999999,', '40.596867,109.991242999999,', '42.2353441719999,118.885341132799,', '42.3235549999999,118.942019999999,', '43.649956,122.22301,', '43.6450004577636,122.321998596191,', '39.8601989746093,109.968002319335,', '39.8587989999999,109.971508,', '49.125439,119.764283,', '49.2476997375489,119.78099822998,', '40.7795982360839,107.46600341797,', '40.93798,113.12456,', '46.0747985839843,121.988998413085,', '46.7298011779785,122.871002197265,', '43.9359279999999,116.026815999999,', '41.8074989318847,123.396003723144,', '41.6964988708496,123.379997253417,', '41.832455,123.537283,', '41.7356406510999,123.4892829022,', '41.803037,123.302048999999,', '41.8266369999999,123.48241,', '41.8545939999999,123.485432,', '41.836157,123.329069,', '39.016201019287,121.60399627686,', '39.0471992492675,121.84700012207,', '38.968327,121.527539,', '41.131599,122.972479,', '40.8431259999999,122.726938,', '41.1324699999999,123.082465999999,', '41.8521599999999,123.762075999999,', '41.3296012878417,123.862998962402,', '40.1250419616699,124.368331909179,', '41.087100982666,121.141998291015,', '40.6739006042479,122.29299926758,', '41.9985008239746,121.612998962402,', '41.2977981567379,123.140998840329,', '41.1566009521479,122.056999206539,', '42.2226638793945,123.775428771972,', '41.5652999877929,120.408996582029,', '40.738098144531,120.88500213623,', '43.8577995300292,125.406997680664,', '43.889499664307,125.24900054932,', '43.8213157653808,125.25454711914,', '43.8134002685546,125.196998596191,', '43.984181,125.295548999999,', '43.821252,125.260125,', '43.873401641846,126.5240020752,', '43.8158988952639,126.58399963379,', '43.1430744576,124.4606827102,', '42.866346,125.208318,', '41.777000427246,125.928001403808,', '41.9755326538999,126.479369298199,', '45.1074981689453,124.888999938964,', '42.9018374974,129.5437315165,', '45.7679499999999,126.71441,', '45.78150177002,126.7620010376,', '45.7205459999999,126.572874999999,', '45.704697,126.54496,', '47.3502006530761,124.070999145507,', '47.326301574707,123.942001342769,', '45.265317,130.941769999999,', '47.334414,130.371278999999,', '46.8184013366699,131.151000976562,', '46.68166,124.866236,', '46.5681209999999,125.156214,', '47.310920715332,130.27868652344,', '45.7700919999999,130.99251,', '45.763824,130.992917,', '44.603199005127,129.64700317383,', '50.223343,127.517994999999,', '46.618999481201,126.983001708979,', '50.4233759999999,124.19325,', '31.23126,121.4687,', '31.0904099999999,121.584784999999,', '31.399200439453,121.480003356929,', '30.962999343872,121.449996948242,', '31.162000656128,121.56500244141,', '31.3004929999999,121.470419,', '31.2041,121.629,', '31.02799987793,121.24900054932,', '31.1732006073,121.33599853516,', '31.1933994293212,121.420997619628,', '31.28707,121.173903999999,', '31.21010017395,121.375,', '31.128288,121.502694,', '31.045214,121.406082999999,', '31.9640007019039,118.824996948239,', '32.121319,118.812667,', '31.9979000091552,118.809997558593,', '32.13570022583,118.875,', '31.6212997436519,120.23100280762,', '31.9067001342769,120.205001831049,', '31.6147994995117,120.320999145507,', '31.569174,120.41507,', '31.529800415039,120.305000305175,', '31.8894996643066,120.319999694824,', '31.4162006378169,119.81600189209,', '34.214908,117.245474999999,', '34.1689069999999,117.189549999999,', '34.3179206848144,117.220390319824,', '34.351475,117.1162,', '31.8143005371093,119.970001220703,', '31.7728004455569,119.946998596189,', '31.799600601196,119.88500213623,', '31.4691009521484,119.499000549316,', '31.740100860596,119.65799713135,', '31.263500213623,120.547996521,', '31.275915,120.660774,', '31.0027251210939,120.648538779299,', '31.184799194336,120.68099975586,', '31.481639,121.10136,', '31.4162006378169,120.646003723139,', '31.302360534668,120.660697937009,', '31.410799,121.023926,', '31.8426990509033,120.581001281738,', '31.366398,120.981347999999,', '31.326299667358,120.56300354004,', '31.3388269999999,120.71074,', '31.642623,120.799715,', '31.3673159999999,120.896349999999,', '30.893086,120.656820999999,', '32.3541719999999,120.568550999999,', '32.2893981933593,121.217002868652,', '32.5449981689453,120.512001037597,', '31.838600158691,121.58699798584,', '31.922700881958,120.997001647949,', '31.8880996704101,121.12799835205,', '32.040199279785,120.81300354004,', '32.0088996887207,120.930999755859,', '34.822161,119.127514,', '34.5792427062989,119.220321655269,', '34.6393789999999,119.198819999999,', '33.6481712200999,119.033369017699,', '33.615755,119.113564999999,', '33.4639,119.032523999999,', '33.4215011596679,119.776000976562,', '32.86360168457,120.42099761963,', '33.3787994384765,120.22200012207,', '33.3333129999999,120.140563999999,', '32.456199645996,119.399002075195,', '32.359798431396,119.426002502439,', '31.955355,119.595614999999,', '32.1861000061035,119.518997192382,', '31.984800338745,119.174003601069,', '32.4245986938476,119.912002563476,', '32.037799835205,120.24299621582,', '33.936171,118.235438,', '34.0925259999999,118.806254999999,', '30.2952739999999,120.247518999999,', '30.3355922167999,120.1588623864,', '30.2285739999999,120.298660999999,', '30.140199661255,120.293998718259,', '30.188597,120.236335999999,', '30.328598,120.127988999999,', '30.450979,120.329542,', '30.2131996154785,119.69400024414,', '30.0948009490969,119.93800354004,', '30.2702007293701,120.1070022583,', '29.8214499999999,121.50552,', '30.213,121.219999999999,', '30.1016998291019,121.151000976559,', '29.915583,121.821432999999,', '30.1636009216308,121.320999145507,', '29.4200209999999,121.897283999999,', '29.8491569307859,121.581285281739,', '29.919357,121.609504999999,', '29.3661379999999,121.476219,', '27.976900100708,120.75299835205,', '27.7989997863769,120.68800354004,', '28.0006008148193,120.671997070312,', '27.968700408936,120.799003601069,', '28.1340919999999,121.005129999999,', '28.0384998321533,120.59700012207,', '28.0596008300781,120.638000488281,', '30.7383995056152,120.813003540039,', '30.6819992065429,121.053001403808,', '30.5387001037597,120.672996520996,', '30.6114989999999,120.55858,', '30.729600906372,120.726997375488,', '30.829374,120.90151,', '30.868523,120.075591,', '30.8907279999999,120.1602,', '31.0156139999999,119.944621999999,', '30.0252990722656,120.830001831054,', '30.096926830078,120.52384573242,', '29.6396007537841,120.837997436523,', '30.0300998687744,120.573997497558,', '29.7134299999999,120.288849999999,', '30.0269219999999,122.034549999999,', '28.9414005279539,118.911003112789,', '29.36820602417,120.054321289059,', '29.4440002441406,119.958999633789,', '29.126499176025,119.658996582029,', '29.1476609999999,119.698363999999,', '28.9183006286619,120.051002502439,', '28.509682,121.391200999999,', '28.8209991455078,121.156997680664,', '28.6410999298095,121.430999755859,', '28.5611000061035,121.394996643066,', '28.66370010376,121.255996704099,', '28.4232997894287,119.864997863769,', '31.901371,117.352170999999,', '31.8017997741699,117.350997924804,', '31.7320789999999,117.267196999999,', '31.8906993865969,117.34700012207,', '31.8584999999999,117.183,', '31.9251995086669,117.271003723144,', '31.37687,118.41132,', '31.388466,118.378529999999,', '32.9248008728029,117.36499786377,', '32.6664009094238,117.073997497558,', '31.641000747681,118.503997802729,', '33.9325981140136,116.806999206542,', '30.9492816925048,117.861328125,', '30.5742259999999,117.064949999999,', '29.7539005279541,118.275001525878,', '32.2728004455566,118.356002807617,', '32.8873299999999,115.798469999999,', '32.85092,115.869129999999,', '31.7196998596191,116.4820022583,', '31.76609992981,116.62799835205,', '33.243572,116.603909,', '33.834814,115.764398,', '30.623006,117.534319999999,', '30.937400817871,118.745002746579,', '26.1455993652343,119.30899810791,', '26.0266990661619,119.35600280762,', '26.0603008270263,119.257003784179,', '25.7341003417969,119.31800079346,', '26.006399154663,119.362998962399,', '25.9229939999999,119.390117,', '24.4905259999999,118.10317,', '24.4946994781489,118.01999664307,', '24.7083529999999,118.14793,', '24.523281,118.15505,', '24.555971,118.13415,', '25.4727001190189,119.049003601069,', '25.331745,119.08025,', '26.3013000488281,117.65599822998,', '24.913757,118.526269999999,', '24.928376,118.645464,', '24.8799819999999,118.558481,', '24.788200378418,118.571998596189,', '25.053388582886,118.240774314449,', '24.774573621582,118.605609807619,', '24.5868499999999,117.617239999999,', '24.5135299999999,117.731673999999,', '27.0312004089355,118.319999694824,', '25.1070003509521,116.961997985839,', '25.130196,117.05744,', '26.6471996307373,119.56900024414,', '28.665599822998,115.967002868649,', '28.6562995910644,115.930000305175,', '28.71369934082,115.962997436519,', '28.6797259999999,115.843185,', '28.59684,115.95327,', '29.3145999908447,117.154998779296,', '27.629400253296,113.883003234859,', '29.709593,115.952545,', '29.6822332885,115.981395292399,', '27.7991008758544,114.873001098632,', '28.233695,117.009694999999,', '25.8509998321533,114.940002441406,', '25.85051,114.892714999999,', '25.7461279999999,114.83261,', '25.883219,115.04116,', '27.15419960022,115.008003234859,', '27.136133,115.050179999999,', '28.4596079999999,115.3987,', '27.868999481201,114.416999816889,', '27.8213996887207,114.382003784179,', '28.032,116.292,', '28.676500320435,115.89199829102,', '29.259815,117.820914999999,', '36.675584,117.179821,', '36.6544359999999,116.888081999999,', '36.6179959999999,116.965805,', '36.724155,117.118033999999,', '36.7196998596191,117.518997192382,', '36.6993039999999,116.940019,', '36.6531639999999,117.018113999999,', '36.65816,116.914238999999,', '36.125759,120.445845,', '36.7669982910156,120.018997192382,', '36.2547988891601,120.43399810791,', '35.9978981018066,120.177001953125,', '36.398998260498,120.419998168945,', '36.8653984069824,120.521003723144,', '36.12763,120.393895999999,', '36.283599853516,120.06099700928,', '36.365712,120.448729999999,', '36.7182099999999,118.007869999999,', '36.791999816895,117.927001953119,', '36.837100982666,118.074996948239,', '36.8252983093261,118.22200012207,', '36.7813379999999,118.047169999999,', '34.883026,117.536578,', '34.82818,117.444299999999,', '37.415246,118.490814,', '37.4850396103519,118.44080489209,', '37.0391998291015,118.43699645996,', '37.5670013427734,121.336997985839,', '37.4805649999999,121.368364,', '37.5537029999999,121.21929,', '36.9538993835449,120.646003723144,', '37.639218,120.548124,', '37.129803,119.940438999999,', '37.3925729999999,120.449171,', '36.6324996948239,119.13999938965,', '36.8946990966796,118.703002929687,', '35.9957008361816,119.380996704101,', '36.764499664307,119.18599700928,', '36.4418473567,119.7886956497,', '36.8404006958007,119.376998901367,', '36.7597999572753,118.488998413085,', '36.7308006286621,118.995002746582,', '35.4453049999999,116.980609999999,', '35.446098327637,116.679000854489,', '35.4476,116.583374,', '35.54109954834,116.94599914551,', '35.7630996704101,116.113998413085,', '36.162601470947,117.03500366211,', '35.8802986145019,117.721000671386,', '36.0695991516113,117.091003417968,', '37.249436,122.051490999999,', '37.1189994812011,122.410003662109,', '37.410999298096,122.1490020752,', '35.4018599999999,119.442141,', '35.4552993774414,119.47200012207,', '36.195701599121,117.7320022583,', '35.0240399999999,118.308859999999,', '35.754252,118.646169999999,', '35.10452,118.317406,', '35.163833618164,118.809692382812,', '35.0797004699707,118.440002441406,', '35.1351013183593,118.265998840332,', '37.415298461914,116.38500213623,', '37.458599090576,116.375999450679,', '37.218654,116.808134999999,', '36.4641990661621,116.078002929687,', '36.4850006103515,116.032997131347,', '37.3566017150879,117.93000030518,', '36.918007,117.736014999999,', '37.428621,118.024887,', '35.268001556396,115.55799865723,', '35.2852749999999,115.428335,', '34.7462099999999,113.79652,', '34.7951649999999,113.538712,', '34.409801,113.726658,', '34.796055255371,113.05649520654,', '34.5396831994629,113.422524427249,', '34.7132056154789,113.65003552588,', '34.7530969999999,113.738855,', '34.715913,113.770730999999,', '34.767156,113.556220999999,', '34.409801,113.726658,', '34.7138139999999,114.02115,', '34.815795,113.664609999999,', '34.729964,113.77406,', '34.783699035645,114.302001953119,', '34.6833992004394,112.513000488281,', '34.6974639999999,112.42619,', '34.6034319999999,112.346441999999,', '34.7436239999999,112.761114,', '34.68565,112.51134,', '33.7400969999999,113.36812,', '33.780891418457,113.185844421386,', '36.057737,114.42037,', '36.0953689999999,114.439147,', '35.7768179999999,114.300000999999,', '35.224068,113.90524,', '35.3712039999999,113.936708999999,', '35.4469789999999,113.82939,', '35.1972999572753,114.713996887207,', '35.1771011352539,113.26499938965,', '35.7873992919921,115.001998901367,', '35.7821006774902,115.125999450683,', '34.075763,113.847907,', '34.1446499999999,113.465248,', '34.063079,113.802539999999,', '33.6013984680175,113.994003295898,', '34.8035011291503,111.177001953125,', '33.037357,112.518364,', '33.0150379999999,112.523269999999,', '33.0590286254882,112.210212707519,', '34.4564018249511,115.600997924804,', '33.894927,116.428477,', '32.13330078125,114.148002624509,', '32.1507110595703,115.054046630859,', '33.6044619999999,114.700194999999,', '33.6570014953613,114.696998596191,', '33.0182991027832,114.068000793457,', '33.0421219999999,114.032353999999,', '35.108135859131,112.603520982909,', '30.552200317383,114.20800018311,', '30.6236991882319,114.166999816889,', '30.4052149999999,114.378209999999,', '30.520099639893,114.34300231934,', '30.667334,114.30794,', '30.6338005065919,114.28500366211,', '30.5729617829589,114.18153272607,', '30.4246869999999,114.264758999999,', '30.4361991882324,114.419998168945,', '30.477781,114.344425999999,', '30.21430015564,115.015998840329,', '30.1410999298095,115.027999877929,', '32.623932,110.780702,', '32.6637992858886,110.717002868652,', '30.6734259999999,111.36318,', '30.684359,111.32079,', '30.729201,111.341718,', '32.097009145,112.197822181099,', '32.095199584961,112.06500244141,', '32.1030998229979,112.19400024414,', '30.388500213623,114.87999725342,', '31.0494995117187,112.249000549316,', '30.942295,113.968748,', '30.909400939941,113.97899627686,', '30.3619995117187,112.225997924804,', '30.344296,112.34605,', '30.4603996276855,114.927001953125,', '30.7614629999999,115.366874999999,', '29.892499923706,114.320999145507,', '31.7099990844726,113.425003051757,', '30.3264999389648,109.50299835205,', '30.281707,108.964364,', '30.3795649999999,113.42246,', '30.4200992584228,112.871002197265,', '30.6114565164,113.1884896242,', '28.2313537597656,112.935714721679,', '28.236982345581,112.865272521969,', '28.2406005859375,112.554000854492,', '28.086241,113.021994,', '28.240600585938,113.07299804688,', '28.159956,113.598146999999,', '28.1839008331298,113.035003662109,', '28.148300170898,112.924003601069,', '28.209257,112.86797,', '28.2422299999999,113.075029999999,', '27.839500427246,113.111999511718,', '26.9820003509521,113.347999572753,', '27.870399475098,113.161003112789,', '27.9361000061035,112.935997009277,', '27.838338,112.982581999999,', '26.8798007965089,112.58100128174,', '26.9393997192382,112.609001159667,', '27.2602949999999,111.557603,', '26.75371,110.632829999999,', '28.697762238037,113.58332006006,', '29.375837,113.186327,', '29.4285029999999,113.179567,', '29.0753993988039,111.68299865723,', '29.4690499999999,111.64099,', '29.0748996734619,111.708999633789,', '29.1479713519,110.574488009899,', '28.5786991119384,112.398002624511,', '28.513725,112.40129,', '25.793199539185,113.06199645996,', '25.752251,112.959079,', '26.4050006866455,111.634002685546,', '27.5291,109.974999999999,', '27.6875991821289,112.017997741699,', '27.742999,112.051154999999,', '28.3067929999999,109.760895,', '23.39032,113.309402,', '23.433300018311,113.21600341797,', '23.1622239999999,113.278048999999,', '23.1075000762939,113.439002990722,', '23.075300216675,113.23899841309,', '23.0712359999999,113.28857,', '22.9491004943847,113.410003662109,', '23.192699432373,113.24700164795,', '23.386018497437,113.174775051759,', '22.958400726318,113.383003234859,', '23.072599411011,113.314002990719,', '23.0429000854492,113.334999084472,', '23.131757,113.393260999999,', '22.973564,113.325329999999,', '23.286600112915,113.796997070312,', '23.1907005310058,113.380996704101,', '23.125900268555,113.59400177002,', '23.238958,113.311600999999,', '23.5538005828857,113.614997863769,', '22.8271007537841,113.529998779296,', '23.13043,113.354217,', '24.7396011352539,113.586418151855,', '24.7667999267578,113.593002319335,', '22.678463,114.073757999999,', '22.7087993621826,114.2320022583,', '22.6732006072998,114.227996826171,', '22.655199050903,114.0179977417,', '22.680700302124,113.819999694824,', '22.7152004241943,114.085998535156,', '22.553072,113.911327999999,', '22.7388000488281,113.806999206542,', '22.5646991729736,114.037002563476,', '22.58690071106,113.90000152588,', '22.532699584961,113.942001342769,', '22.5489997863769,114.146003723144,', '22.5451249999999,114.088616999999,', '22.213300704956,113.462997436523,', '22.2220993041992,113.333000183105,', '22.295799255371,113.50199890137,', '22.12153,113.335434,', '23.25478,116.469703999999,', '23.4015307308999,116.751024129399,', '23.427195,116.698459999999,', '23.2266998291015,112.932998657226,', '22.864189,113.236588999999,', '22.8844819999999,112.909103999999,', '22.9514159999999,113.259319,', '23.041716,113.185433,', '23.075299,113.129395,', '22.95895,113.039433,', '23.132895,113.02028,', '22.7516002655029,113.282997131347,', '23.0133991241455,113.106002807617,', '23.1748008728027,113.177001953125,', '22.8659000396728,113.100997924804,', '23.0100559999999,113.104911,', '22.2317074535999,112.3561991243,', '22.306999206543,112.80899810791,', '22.5417003631591,113.068000793457,', '22.5904006958007,113.095001220703,', '22.3703498840332,112.657478332519,', '21.3028173159,110.384632373499,', '21.255199432373,110.37799835205,', '21.5582889999999,110.27392,', '21.267809,110.385949999999,', '21.6737995147705,110.954002380371,', '21.8924007415771,110.842002868652,', '21.6349769999999,110.913874,', '22.320906,110.938923,', '23.1116008758544,112.507003784179,', '23.3201007843019,112.740997314449,', '23.91525,112.15769,', '22.9750995635986,114.754997253417,', '23.035551,114.33759,', '22.982717,114.463491,', '23.1867729999999,114.275115999999,', '23.0882879999999,114.459022,', '23.0793991088869,114.41300201416,', '23.166500091553,114.43399810791,', '22.761299133301,114.49299621582,', '23.06567,114.424779999999,', '24.266300201416,116.11799621582,', '24.132341,115.706959999999,', '24.3311004638669,116.102996826169,', '23.796457,116.15286,', '22.8042602539062,115.39557647705,', '23.7096492344,114.6991869718,', '21.8645992279052,111.927001953125,', '22.1818689999999,111.78851,', '21.8780002593989,112.00700378418,', '23.640871,113.067406,', '24.2287998199462,113.422996520996,', '23.6678009033203,113.060997009277,', '23.103179,113.884703999999,', '23.0179004669189,113.873001098632,', '22.9116306304931,113.832344055175,', '23.0985599999999,113.83328,', '22.918398,113.970084999999,', '22.8671913146972,113.673622131347,', '22.787799835205,113.80000305176,', '22.910400390625,114.085998535156,', '22.85120010376,114.11100006104,', '22.953800201416,113.685997009277,', '22.9596996307373,113.967002868652,', '22.7178993225097,114.156997680664,', '22.9882473034,113.7158179988,', '22.576581954956,113.347335815429,', '22.5372009277339,113.459999084469,', '22.467199325562,113.35304260254,', '22.646608352661,113.22102355957,', '22.558781,113.416528,', '22.708888,113.360946999999,', '22.6275234222412,113.500099182128,', '23.588486,116.608829999999,', '23.6856499999999,116.61226,', '23.571674,116.378178,', '23.5283769999999,116.449686999999,', '23.3264007568359,116.158996582031,', '23.5305199999999,116.512829999999,', '22.726548,111.617664,', '22.9538993835449,112.039001464843,', '22.8139991760253,108.466003417968,', '22.7831993103027,108.267997741699,', '22.7846112418999,108.323295014699,', '22.8687000274658,108.371002197265,', '22.8600789999999,108.276677,', '22.8420279999999,108.220119999999,', '22.766665,108.37094,', '22.78358,108.332849999999,', '24.3167991638183,109.46499633789,', '24.3082099999999,109.364729999999,', '24.3792991638183,109.443000793457,', '25.270681,110.179924,', '25.3584989999999,110.315002,', '23.520458,111.257862,', '21.4955997467041,109.169998168945,', '21.7793006896972,108.376998901367,', '21.9456996917719,108.64199829102,', '23.1047992706298,109.62799835205,', '22.622551,110.133827999999,', '22.6618370720999,110.1829955916,', '23.8600006103519,106.677001953119,', '24.4097003936769,111.59600067139,', '24.694200515747,108.096000671386,', '23.7003659999999,109.246774,', '22.3713950852,107.379578665699,', '19.99760055542,110.233001708979,', '20.00119972229,110.324996948239,', '19.9976997375488,110.426002502441,', '20.006824,110.30777,', '20.00167,110.27132,', '18.34532,109.175579999999,', '18.2882003784179,109.584999084472,', '19.2943000793457,110.471000671386,', '19.5305609999999,109.559399999999,', '18.794758,110.363045,', '19.09966,108.672195,', '29.7555289629,106.4867398919,', '29.5925429999999,106.53282,', '29.525100708008,106.46600341797,', '29.6456,106.576999999999,', '29.709699,107.382003999999,', '29.4092006683349,106.543998718261,', '30.7773990631103,108.406997680664,', '29.524,106.572997999999,', '30.6811809999999,103.997354999999,', '30.98281,103.970731999999,', '30.6147003173828,104.063003540039,', '30.690747,104.173326,', '30.7635993957519,104.09300231934,', '31.0321998596191,103.678001403808,', '30.667100906372,103.836997985839,', '30.7122993469239,104.00700378418,', '30.6032905578613,103.955123901367,', '30.55122,104.246885,', '30.5966209999999,104.117148,', '30.6340999603271,103.986000061035,', '30.532600402832,104.056999206542,', '29.3351993560791,104.712997436523,', '26.5340995788574,101.718002319335,', '28.839500427246,105.418998718261,', '31.070632,104.392115,', '31.47080039978,104.692001342769,', '0,0,', '32.4331280481,105.8887403585,', '30.4619059999999,105.576661999999,', '29.5856258534,105.039961175399,', '29.623226165771,103.7067565918,', '30.776703,106.17507,', '30.88512,106.059224999999,', '30.0748996734619,103.823997497558,', '28.7509994506839,104.651000976559,', '30.5108999999999,106.707999999999,', '31.1765102865999,107.5099255388,', '29.9804059999999,102.9728,', '31.85602,106.803414,', '30.1122591279,104.626413460699,', '27.879935,102.226806999999,', '26.56609916687,106.69300079346,', '26.630827,106.759829999999,', '26.5156002044677,106.684997558593,', '26.5983839999999,106.636938999999,', '26.6102649999999,106.72825,', '26.5494995117187,104.901000976562,', '27.6185321807861,106.882118225097,', '27.7868968354,106.9315518515,', '27.64103,106.89162,', '26.281600952148,106.01000213623,', '27.299146,107.942542,', '25.130213,104.864857999999,', '27.2679996490478,105.394996643066,', '26.5252409392,107.866102968899,', '26.302299,107.521163,', '24.9521007537841,102.764999389648,', '25.073600769043,102.67500305176,', '24.964701,102.811518,', '25.0678997039794,102.754997253417,', '25.053944,102.801377,', '24.99445,102.81516,', '25.4719009399414,103.80899810791,', '25.5789259999999,103.809241,', '24.363500595093,102.559997558589,', '25.14794921875,99.1908798217773,', '25.12482,99.1870899999999,', '27.3308737262,103.712781597599,', '26.8727054595947,100.261672973632,', '25.060009,101.577358,', '23.380696,103.373074,', '23.3619995117187,104.289001464843,', '21.9776000976562,100.794998168945,', '25.602976,100.264940999999,', '24.4546585083007,98.5795364379882,', '22.8246402740478,100.973327636718,', '29.666799545288,91.0659027099609,', '29.626245,91.005159,', '29.6505599999999,91.02849,', '34.239200592041,109.023002624511,', '34.3352059878999,108.939323255,', '34.333469,108.853451,', '34.176994,108.853437,', '34.2914009094238,108.828002929687,', '34.3064994812011,109.057998657226,', '34.2235984802246,108.893997192382,', '34.3468999999999,107.2917,', '34.3759994506839,108.796997070309,', '34.374833,108.670361,', '34.5208015441894,109.448997497558,', '36.6665000915527,109.593002319335,', '33.1320991516113,107.009002685546,', '38.228500366211,109.73600006104,', '32.729400634766,108.995002746579,', '36.1215362548829,103.83088684082,', '36.0734369999999,103.8687,', '36.1343002319335,103.646003723144,', '38.5410699999999,102.23147,', '36.5018005371093,104.206001281738,', '34.56777,105.849699999999,', '37.91178,102.67144,', '38.9424599999999,100.407769,', '35.5152015686035,106.765998840332,', '39.7678985595703,98.426902770996,', '35.7719001770019,107.629997253417,', '35.5499289999999,104.644512,', '35.5826148986816,103.237586975097,', '36.606647491455,101.777359008789,', '36.691898345947,101.74700164795,', '36.408278,94.925545,', '38.5402984619139,106.324996948239,', '38.4552993774414,106.161003112792,', '38.011837,106.227919999999,', '43.7928009033203,87.6176986694335,', '43.887988,87.5196219999999,', '43.9521217346189,87.63404083252,', '43.8474006652832,87.6064987182617,', '43.8775367736816,87.5381240844726,', '43.88889,87.51156,', '43.8847499999999,87.5327099999999,', '45.5626983642578,84.9048995971679,', '42.9537252489,89.1887867747,', '42.8879013061523,93.5914001464843,', '44.0354549999999,87.2529559999999,', '-1,-1,', '44.8548419999999,82.0795619999999,', '41.7210998535156,86.2208023071289,', '41.723739,86.2214989999999,', '41.214500427246,80.2991027832031,', '39.418877,76.03454,', '37.15335,79.9158139999999,', '44.4056879999999,84.920298,', '43.895198822021,81.3712005615229,', '46.510803,83.6327739999999,', '44.288198,86.060145,']
for i in lt:
key = 'GjG3XAdmywz7CyETWqHwIuEC6ZExY6QT'
r = requests.get(url='http://api.map.baidu.com/geocoder/v2/', params={'location':i,'ak':key,'output':'json'})
result = r.json()
#print(result)
lt=i
province = result['result']['addressComponent']['province']
city = result['result']['addressComponent']['city']
print(lt,province,city)
with open(file,'a+',encoding='gb18030',newline='') as f:
writer = csv.writer(f)
writer.writerow([lt,province,city])
获取结果如下: