Weather_Database.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import the dependencies.\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np \n",
    "import requests\n",
    "from citipy import citipy \n",
    "import time \n",
    "from datetime import datetime \n",
    "from config import api_key "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<zip at 0x7f8ed162a8c0>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a set of random latitude and longitude combinations.\n",
    "lats = np.random.uniform(low=-90.000, high=90.000, size=2000)\n",
    "lngs = np.random.uniform(low=-180.000, high=180.000, size=2000)\n",
    "lat_lngs = zip(lats, lngs)\n",
    "lat_lngs "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(-40.81892950900716, -10.579846577007942),\n",
       " (-43.19799184169529, 140.42866321567067),\n",
       " (28.362722489290633, 148.9604560318233),\n",
       " (-46.696659783633365, -91.50293523953998),\n",
       " (-16.48833259403186, -65.48999498754957),\n",
       " (34.37771554698689, 71.82398148011472),\n",
       " (83.41858035567705, 133.42242757931444),\n",
       " (-70.0594202046361, 141.3912780305489),\n",
       " (-52.21652734509562, -70.13069222386855),\n",
       " (71.78149083147099, -65.41363024685114),\n",
       " (-51.337035988417796, 175.63354102811303),\n",
       " (-7.523774710596172, 134.77728418956224),\n",
       " (-34.7016459030929, -131.96384424814806),\n",
       " (-33.26459033575427, -140.11136115291464),\n",
       " (16.67657949706617, -154.31722464464718),\n",
       " (53.07484849973932, -89.88667580081464),\n",
       " (62.005245366770225, 4.991468214289711),\n",
       " (-32.342389334463554, 133.64021701918875),\n",
       " (-11.632069061214978, -118.2704418589364),\n",
       " (-39.6132324218828, 35.83171097006195),\n",
       " (-12.87770535639055, 105.25924092370349),\n",
       " (-26.064053838988393, 80.53584602097379),\n",
       " (-77.23940479294706, 27.30964839680695),\n",
       " (12.148181055606216, -96.22888716154462),\n",
       " (55.16969591807475, -109.65840536071184),\n",
       " (60.353016988689944, 39.98367931547105),\n",
       " (-3.520347397784036, 14.896261619209355),\n",
       " (42.53485360188171, -102.63783238758919),\n",
       " (-55.741946539637475, -133.25160952885753),\n",
       " (65.78102922926041, 56.603190361420786),\n",
       " (-14.405750439736238, -18.433396283812982),\n",
       " (-52.690782635510736, 63.83899403914154),\n",
       " (-78.72422455673521, -146.6431381245787),\n",
       " (22.458562235425376, -108.69622823834204),\n",
       " (-76.22559964138847, -80.62959433965025),\n",
       " (24.497806858598054, -107.53581821758081),\n",
       " (-80.83904761873275, 166.9876636711038),\n",
       " (85.01241927245846, -171.81799217056437),\n",
       " (19.322999069141503, 74.42011276988544),\n",
       " (-3.937313473324295, -82.82873578809271),\n",
       " (59.42644189372976, 161.47042606426453),\n",
       " (34.22507393975961, -0.6184636163702635),\n",
       " (-17.22731881252848, 55.295163360150866),\n",
       " (-84.81541026987314, 29.420394440123687),\n",
       " (13.330837176740104, 123.52363373714087),\n",
       " (-27.52961646359912, 133.98864636461298),\n",
       " (71.28134291987223, -14.498681577444302),\n",
       " (12.632356922511804, -40.5569525733965),\n",
       " (-70.88431628221, 58.544164713730254),\n",
       " (-40.61514462936869, 162.37869019201463),\n",
       " (-38.78905847295196, -86.98159608028578),\n",
       " (-28.620999554975654, 126.28444884411545),\n",
       " (-80.98905653699134, 16.66050932766487),\n",
       " (-69.54560366710227, 121.13552910146444),\n",
       " (-51.057636727389344, -37.055218232783005),\n",
       " (-75.43962200176429, -94.13139333852024),\n",
       " (87.31798957009846, -4.78932299931293),\n",
       " (-78.38150359691703, -169.17477889184184),\n",
       " (36.47945680116237, 47.2190397579389),\n",
       " (-42.29668404258377, 142.13793976264247),\n",
       " (89.9521019094741, -141.05917000575457),\n",
       " (32.443204559363096, -101.1654814064452),\n",
       " (-61.726506204316586, -46.02052727202917),\n",
       " (8.390741161825161, 49.84652829152026),\n",
       " (-69.37879923994893, 167.053720739683),\n",
       " (12.054937921601919, 50.09096650304153),\n",
       " (62.32292241611671, 9.589639014278362),\n",
       " (-63.67871011525538, -133.77032652545213),\n",
       " (43.63029717506427, 160.84153782650708),\n",
       " (-44.936564167494225, 106.25900685658803),\n",
       " (-24.593062559451724, -43.5157530990671),\n",
       " (25.961014437368718, 51.54906868725422),\n",
       " (8.184468241018735, 168.8083103716964),\n",
       " (74.62765441615812, -165.85157385415064),\n",
       " (17.917252635965426, 32.62962431350826),\n",
       " (-69.68364364395615, -132.8733064822638),\n",
       " (-34.97393255496425, -19.05189500439846),\n",
       " (-82.90941069733483, -126.83644950005126),\n",
       " (-33.76902822478727, -21.443602405483176),\n",
       " (-40.96886836452149, -112.2717629962717),\n",
       " (-22.103364075166354, 131.02411512967325),\n",
       " (-3.227578559774045, 97.67027896993721),\n",
       " (-41.48694449908588, 168.23377201412626),\n",
       " (45.8397738277169, -48.541552462224985),\n",
       " (-23.420767988480407, 62.566378781005454),\n",
       " (-18.15517482692144, -150.853640624598),\n",
       " (-28.01859206851649, 40.35411037783544),\n",
       " (9.91608913112239, 142.28867883646677),\n",
       " (-55.88645354527679, 120.09914787645096),\n",
       " (83.03241429724369, -172.8100919823585),\n",
       " (87.96996161127603, 101.3270207887229),\n",
       " (30.46883190003811, -5.171925091600059),\n",
       " (-31.014219990112068, 91.4781063579332),\n",
       " (72.00066948977079, -95.44061240804007),\n",
       " (-72.35693900820397, 134.88071536713085),\n",
       " (-28.93809392002799, -25.93119113339526),\n",
       " (-82.02424445334995, 40.118602791700596),\n",
       " (-89.3464128372512, 91.64767216854727),\n",
       " (47.27301206701921, 176.58891708249718),\n",
       " (-76.9345119840067, -83.80487476370057),\n",
       " (75.09587285986743, -92.5970662118153),\n",
       " (-53.14579473708322, 162.70433361810956),\n",
       " (-31.87840209083609, 16.31563514241543),\n",
       " (-71.41130491699874, 132.88447995325498),\n",
       " (88.01168500033103, -26.368144290813973),\n",
       " (-8.915987960388037, -122.49355273353507),\n",
       " (-56.10766600912024, -139.719452719501),\n",
       " (-17.33587655252022, 81.21712115376829),\n",
       " (-54.572852443441356, 61.14887690119721),\n",
       " (-7.638601299284602, 72.0378645638738),\n",
       " (80.46358818361423, -132.6207203099573),\n",
       " (-79.92993770439915, -166.70499217275378),\n",
       " (86.0288030630694, -71.61250102563442),\n",
       " (71.36991415387217, 170.9624553221699),\n",
       " (80.88039411484684, 134.81240535230722),\n",
       " (-46.274504162496605, -17.048702180231658),\n",
       " (-53.944548645359184, 169.09551657537412),\n",
       " (52.86524371613663, -146.26991013937214),\n",
       " (33.94148176313895, 159.76313755573858),\n",
       " (-74.95493776754464, -31.210502829291755),\n",
       " (-27.71633017493697, -90.30535426509557),\n",
       " (50.63463893266996, 0.5350398238299476),\n",
       " (-89.96269300453659, -102.67724135653938),\n",
       " (-79.78231496708136, 165.48805943979136),\n",
       " (7.73111475712075, 133.94327522324733),\n",
       " (-3.836920366021303, -86.06263870177021),\n",
       " (-72.47580399698205, -131.90884907805304),\n",
       " (71.69120483334012, 96.07621175587565),\n",
       " (16.00526752332547, 157.16776336921544),\n",
       " (-63.627333305504884, 102.54045389412238),\n",
       " (-0.05854125324117376, 84.5503177214764),\n",
       " (89.71477921187227, -122.89844489731811),\n",
       " (70.53323442702603, -119.91162559352985),\n",
       " (-43.08220940809673, -94.97918995723826),\n",
       " (46.108121047895025, 164.1385095326907),\n",
       " (5.7346965545236515, -151.78042282815323),\n",
       " (72.21585110037512, 116.38046706220746),\n",
       " (2.281342610103877, 105.15200941613864),\n",
       " (51.84359854205252, -169.52293649465182),\n",
       " (-51.07355929305547, 44.72899868215876),\n",
       " (32.77512125160092, 131.63916867522062),\n",
       " (-76.98068602220238, -131.08981892753525),\n",
       " (50.044403133203105, 163.05082959231947),\n",
       " (16.994130443908972, 11.366937368820203),\n",
       " (-9.176153045528949, -125.30687425022055),\n",
       " (-3.561795516607461, -143.542340628826),\n",
       " (54.38274638911594, -34.84898054810512),\n",
       " (3.25662257269029, -121.72284498526646),\n",
       " (23.734279955377787, 151.50177570643137),\n",
       " (84.17554497576825, -28.016352128202726),\n",
       " (3.7411925327852202, -11.216968961869156),\n",
       " (70.5584292499174, 111.42146199718235),\n",
       " (15.597416773690085, 34.550967354598185),\n",
       " (23.51584518420934, 5.204650459548532),\n",
       " (-40.61310966068459, -9.4530972311764),\n",
       " (34.26955719336377, -175.49651373372583),\n",
       " (50.62403752008291, -171.88178292433201),\n",
       " (-86.68136089785747, -109.09932044975555),\n",
       " (-15.363562358655855, -15.321124472561024),\n",
       " (-16.879251424202607, 0.6655887924978003),\n",
       " (37.774939702260525, 121.6342695759796),\n",
       " (-47.34809177516552, -133.83250420767519),\n",
       " (53.30657781347526, -164.89829854809946),\n",
       " (58.95545481211499, -54.2000517627783),\n",
       " (59.28555823605103, 52.66096594150338),\n",
       " (-82.74939674856492, -86.2591053201996),\n",
       " (31.744520489271068, 115.38157687722742),\n",
       " (-73.6572623782704, 142.61599076737076),\n",
       " (-2.845812071806833, -105.42112669325851),\n",
       " (-67.95957968246927, 139.35356793829493),\n",
       " (37.767348301619776, 74.73323489897223),\n",
       " (-64.39888314089168, -20.11421255803654),\n",
       " (-41.259183133867026, -61.79997919268884),\n",
       " (-2.9579670189671106, -147.46757224817605),\n",
       " (10.790743174194489, -137.74986439363494),\n",
       " (-25.563370523599744, -157.1105010309455),\n",
       " (-55.56830635180977, -6.574650538285226),\n",
       " (-72.40198622515405, -28.00151984811987),\n",
       " (-46.05273651689361, -37.59399801583157),\n",
       " (15.210505012932757, 85.99182830799617),\n",
       " (18.17870715088067, -129.8690618016115),\n",
       " (33.99492341765854, 22.43529500669544),\n",
       " (-38.046377773546794, -116.94205308474301),\n",
       " (-79.01444003293145, -47.45600655264357),\n",
       " (-59.4368157029464, -5.664750144127822),\n",
       " (48.893675251909514, -117.89601532491272),\n",
       " (-55.85588012682087, -36.14363894008096),\n",
       " (-70.46398307717573, -78.2442989444277),\n",
       " (71.5574368618675, -97.0101625886228),\n",
       " (63.52067257677095, -28.679840783702303),\n",
       " (-53.99312290343559, -5.019506521935028),\n",
       " (60.36779445300235, 166.7288166108857),\n",
       " (51.8678452213166, 3.9367636734703524),\n",
       " (-6.478943077290467, -148.06476437592508),\n",
       " (6.221557126591151, 138.96853962404924),\n",
       " (-44.78412358230927, -121.95672194656484),\n",
       " (89.88504075866086, -22.166607182179263),\n",
       " (68.14019624376397, -73.39527707250151),\n",
       " (73.01117285520817, 96.51701524505108),\n",
       " (-68.86470722281533, -28.58450908644417),\n",
       " (-51.164434181658876, 70.5395369331946),\n",
       " (25.861478518688713, 126.0730400050287),\n",
       " (6.8355998094242665, 32.70066238381304),\n",
       " (-82.66348902104905, 48.43423529004957),\n",
       " (-15.785979095000329, 121.22509862383271),\n",
       " (9.880573876663348, 94.88761271133677),\n",
       " (-3.898385328749228, 170.7922493859345),\n",
       " (35.05135892819, -59.69787848609003),\n",
       " (-20.26772212745101, 165.33322615967228),\n",
       " (20.37181689534347, 61.159820269996885),\n",
       " (-69.1509611134897, 34.63210613335002),\n",
       " (4.192615010520981, -39.71736177120968),\n",
       " (-12.903959063493176, 96.17683783933319),\n",
       " (-51.049242991505956, -94.17060905744754),\n",
       " (-27.910415128610516, 46.397267489784554),\n",
       " (-22.848714848571234, -108.27431672345759),\n",
       " (77.34490227948933, 38.558427086999615),\n",
       " (-89.33500339210504, -173.3248304528087),\n",
       " (7.9500853881233695, -75.48496950500703),\n",
       " (33.618500410147234, 134.43949896469013),\n",
       " (-31.435602602498925, -72.6987288667751),\n",
       " (68.6321988428291, -140.06648547166057),\n",
       " (-78.90928852367207, 80.88356712231968),\n",
       " (2.3264541418402445, -178.0188675486058),\n",
       " (54.25282040169512, 12.372554188691936),\n",
       " (55.9722450610177, -89.31770909061152),\n",
       " (-75.59728531642995, -60.253708435824166),\n",
       " (-47.37857506996142, 135.4556491236832),\n",
       " (-76.4149723323593, -44.15804253681108),\n",
       " (5.706453491474917, -2.9991349945624677),\n",
       " (-43.71296222759384, 81.59543140235445),\n",
       " (-3.2755014495374013, -137.08451288736097),\n",
       " (-72.9515903725365, -37.51450930903863),\n",
       " (-28.93930742748754, 54.948372960213305),\n",
       " (42.95432305253132, 11.812468204766134),\n",
       " (-39.40668804788319, 167.1415071420447),\n",
       " (-22.244651304954573, -37.04589005243028),\n",
       " (32.97295641880274, -164.62773972756352),\n",
       " (66.65055226286611, -166.72914935185784),\n",
       " (78.37511783896622, -102.21698071381745),\n",
       " (60.010823757303, 94.5976639202845),\n",
       " (51.388910124442816, -83.75706896953179),\n",
       " (63.814124012414055, -121.56242344495467),\n",
       " (11.491760541662401, -110.00706418458773),\n",
       " (74.03442560301269, 22.32270448465448),\n",
       " (33.085109600687844, 166.44546143757657),\n",
       " (-19.478200549030475, -108.23511392072444),\n",
       " (-17.327345266810283, -126.31145539893527),\n",
       " (-15.760315453208548, -166.7688524379659),\n",
       " (-9.653277442234057, -89.54309219524076),\n",
       " (-42.00725676559724, -93.28075896019699),\n",
       " (-6.589157043217867, 133.82312800634742),\n",
       " (58.97999774572821, 138.61064863218917),\n",
       " (-16.27220211747101, -100.8080617490933),\n",
       " (24.28979966934675, 123.24988226488523),\n",
       " (-32.048347253852135, 21.03854788756729),\n",
       " (-28.948002014629957, -59.67355296029196),\n",
       " (47.37972071003372, -8.09609473232291),\n",
       " (16.87584149213619, 40.63709708944364),\n",
       " (63.77984089099556, -163.53217241332038),\n",
       " (63.86239055554043, 115.281839016812),\n",
       " (42.613168934967376, 104.48765827339975),\n",
       " (-64.9244865860216, -15.850655090152031),\n",
       " (35.996580472935364, -87.22537792818979),\n",
       " (-5.203480881087785, 35.382819093935666),\n",
       " (68.04275953628962, -107.53006970483804),\n",
       " (-70.58477790446524, -121.68110304022107),\n",
       " (-1.5111485147733248, 84.79380563443726),\n",
       " (-61.46567557676564, -132.67436116056098),\n",
       " (72.01834804398632, -35.10934713729574),\n",
       " (79.63343392885093, 3.2726845335427868),\n",
       " (-69.32465372594501, 2.008083622033581),\n",
       " (-56.28810160413731, -172.43716365614233),\n",
       " (33.10992508936127, -67.12634294874839),\n",
       " (-16.043827806289244, -35.46951690853703),\n",
       " (-48.769547314376034, 166.5499369565365),\n",
       " (-27.01106704895716, -96.19512754810046),\n",
       " (70.11332690583836, -95.84777067430535),\n",
       " (-3.4488041425454554, -134.51390475305388),\n",
       " (68.33107917798864, -116.49010389969769),\n",
       " (29.56615569995236, -63.9525363624041),\n",
       " (-62.129630108203784, -22.87142507276883),\n",
       " (88.99176103987344, -112.38315748212749),\n",
       " (-42.813741430679556, -60.7642147277397),\n",
       " (18.569724250595243, 9.71016384247713),\n",
       " (63.42037499077213, -149.75978692178137),\n",
       " (28.02738184971355, -3.5618073730400965),\n",
       " (-44.26111314994758, -116.64684972885215),\n",
       " (-62.327152297249214, -91.06904483984748),\n",
       " (-38.586100353412505, 8.889015322014927),\n",
       " (85.9408549768527, 15.249547767658385),\n",
       " (-31.37790084978805, -45.66886794139265),\n",
       " (3.9369792412901745, 141.22375632481896),\n",
       " (-88.94078125335791, -161.57167843321122),\n",
       " (89.9084990365593, 143.10165657296915),\n",
       " (-65.49071058304672, -69.25681165941967),\n",
       " (-21.69847230777613, -145.85677823200814),\n",
       " (56.22674069030734, -109.72026447721758),\n",
       " (60.393414916043184, -26.244914741420587),\n",
       " (-43.870358639300406, -14.867924325415316),\n",
       " (-64.88232365913905, -147.24098863065046),\n",
       " (26.72243691692846, -34.15319188257746),\n",
       " (59.88209302111795, -11.031928017473547),\n",
       " (7.158676735007319, 154.29496631403907),\n",
       " (-30.507007369793612, -104.05045286788383),\n",
       " (15.294471235564089, 138.90360169195725),\n",
       " (-68.15632137098765, 37.48658816736594),\n",
       " (15.3198580795179, -131.80311184487869),\n",
       " (80.99037302422914, -60.47974245327303),\n",
       " (-57.73689920802477, 177.19307998847114),\n",
       " (4.469522472108224, 61.441339762626626),\n",
       " (36.454930785364056, 127.96694394575854),\n",
       " (56.234874019653034, -111.75518960593807),\n",
       " (-10.297996089588437, -102.82199174868691),\n",
       " (79.09047626180111, 151.13002584340023),\n",
       " (-18.553498008814273, -3.2730181778625536),\n",
       " (-47.029965686618056, 134.16372777474754),\n",
       " (-18.181340258494302, -4.647177213427483),\n",
       " (47.52593255241098, -146.26863023740844),\n",
       " (30.000767125168508, 164.0212687672149),\n",
       " (24.620345124601343, -136.14969548825474),\n",
       " (-7.875619278016217, 14.495162410654643),\n",
       " (69.97485377172313, -4.744530251580699),\n",
       " (52.880707323548165, 126.66000621771832),\n",
       " (12.792022496041326, -149.0206258864895),\n",
       " (-83.79685488745929, 104.53663793739008),\n",
       " (-48.7384873616327, -88.66626212832858),\n",
       " (-79.72725727428606, 115.71516645964175),\n",
       " (-55.66764531382705, 11.679773654371047),\n",
       " (-74.56287359764482, -54.10832453203513),\n",
       " (-74.06030515794703, 147.8578390829764),\n",
       " (-8.687976570234994, -104.14484099120182),\n",
       " (68.46427080960589, -161.34399075702044),\n",
       " (53.10713111568569, 2.1218258934727032),\n",
       " (-38.630718068944724, 1.2146745382072481),\n",
       " (-74.85443972522611, 112.79799375518155),\n",
       " (1.3037663793681702, -60.02323225068926),\n",
       " (-32.54234894854126, 123.55037519821337),\n",
       " (69.6223967900435, 29.247424045843587),\n",
       " (48.50523436776459, 154.60932367631096),\n",
       " (-30.76045749033034, -98.1952905058236),\n",
       " (42.0408027007158, 7.306575775024612),\n",
       " (52.86637026903301, -158.10065926466177),\n",
       " (20.950529630806287, 87.18787243622631),\n",
       " (-16.754910154790963, -130.1229758268736),\n",
       " (-39.74626756061056, 53.410200374461),\n",
       " (-17.73658157248491, -8.352268429935208),\n",
       " (21.532162230812418, 136.45837564232096),\n",
       " (-49.64961052232724, 126.18008191680633),\n",
       " (-14.956807843202924, -35.6297597404029),\n",
       " (-61.50751597382721, 136.88503160537596),\n",
       " (-8.159104600643147, 83.18072094469841),\n",
       " (27.75772599504465, 94.85384047049189),\n",
       " (35.637993234765844, -169.01178920941825),\n",
       " (-67.61818579578785, 138.87685321796278),\n",
       " (0.0862717622531477, 98.5662966759109),\n",
       " (-65.61649050120946, 126.06473680393384),\n",
       " (-36.10803828274649, 133.25101716347052),\n",
       " (-42.17806196440205, 73.54755566689272),\n",
       " (80.155628087649, -21.09248512350422),\n",
       " (-24.90689455636982, -66.03597593327535),\n",
       " (-11.972887852051628, -173.36418299408317),\n",
       " (72.08302754514887, 115.61267970319307),\n",
       " (-31.44000483132543, -86.27804572534339),\n",
       " (-8.838485372811974, -66.27025233565962),\n",
       " (-44.016218489743466, 132.48838714734222),\n",
       " (-17.14294748002301, 51.32577883975125),\n",
       " (-75.00407937727552, 53.08271835892077),\n",
       " (-5.1996021598728674, 171.5204227975089),\n",
       " (-72.88181199882216, 107.08932643874215),\n",
       " (-79.08142408752204, -174.10610369899587),\n",
       " (0.09866981276175579, -57.19127115478463),\n",
       " (75.97201800515396, -79.81719306521238),\n",
       " (44.29400115691129, 104.75824927621892),\n",
       " (-80.11198501818853, -12.874874502561084),\n",
       " (-46.728218569893414, -67.65870729362591),\n",
       " (-50.10290290994038, 90.63556772675992),\n",
       " (48.40034292315883, 2.359192743039557),\n",
       " (22.265112060962267, -158.28872307874337),\n",
       " (53.79807322873273, 0.9953089248626839),\n",
       " (-23.86103708869169, -16.16634684796469),\n",
       " (57.29136766509865, -24.949713910910873),\n",
       " (66.27617735626617, -84.36334717476734),\n",
       " (-46.60892473171738, 100.7868096363851),\n",
       " (-21.349159023983034, -106.68501424616812),\n",
       " (-2.8143018436134923, -55.01859294638628),\n",
       " (-80.0744332115414, 133.90021881291437),\n",
       " (10.784124309091538, 106.70981689907268),\n",
       " (52.17744003480692, 142.45301654771123),\n",
       " (33.38509868248373, -83.27075184297091),\n",
       " (-6.375215612990303, -55.13741985244208),\n",
       " (7.784897501854886, -172.5088991543744),\n",
       " (57.839102527185986, 52.29087093000592),\n",
       " (-58.094321208330584, 105.69979790880626),\n",
       " (57.26554401180525, 110.76133545910267),\n",
       " (47.72520859255613, 55.5648903518499),\n",
       " (75.5649233840793, 66.41039082302365),\n",
       " (44.962416175699104, -18.10691336518707),\n",
       " (45.17466742349643, -23.978838495346963),\n",
       " (-59.44964775633572, -34.688913288795334),\n",
       " (-69.53677707065795, 178.67558727573243),\n",
       " (-25.21341912907515, 173.60565063315056),\n",
       " (-5.584571841723104, -141.35936949683082),\n",
       " (-27.664560623516564, -96.86772035029668),\n",
       " (39.46967814893435, 113.748588432681),\n",
       " (-72.92923130304274, -71.5929654082933),\n",
       " (-52.59830897461325, 160.02377855771817),\n",
       " (-64.91012854897141, 50.132240978130085),\n",
       " (-66.45802480141376, 153.78019097105636),\n",
       " (-57.334521290731885, 87.24893202964756),\n",
       " (24.243545824082247, 93.82363906919045),\n",
       " (-38.80432250257472, 55.067617320574016),\n",
       " (89.90923638470551, 88.91072663199401),\n",
       " (22.986543705496018, -50.8820253678621),\n",
       " (-34.651303639430324, 119.48504144685904),\n",
       " (-44.75587703344648, -139.56913743970972),\n",
       " (16.50289895954721, -20.583443782331273),\n",
       " (-72.950571158896, 77.1197439140559),\n",
       " (-23.511065224684188, 74.76901683992267),\n",
       " (28.631237630269183, -119.2732043278703),\n",
       " (22.56296345279955, -165.40052999546182),\n",
       " (80.27024944095666, 176.5399799845825),\n",
       " (53.00803184081499, -74.1328796740857),\n",
       " (7.9418505073394385, -157.31251296107638),\n",
       " (16.417880870275297, -75.18992822744272),\n",
       " (79.91090808438005, 2.418495609621033),\n",
       " (-17.30660604153404, -21.438385079172434),\n",
       " (-21.53226798728626, -99.07781169588087),\n",
       " (-17.381667473588877, 167.62051310312808),\n",
       " (-12.634701274879319, -27.483003827277287),\n",
       " (86.94516168578551, -113.38448763000426),\n",
       " (-26.290444964119118, -47.70821821544379),\n",
       " (73.86259535940428, -14.036247552491744),\n",
       " (-55.3389713285168, -26.026337491123257),\n",
       " (54.60032463645689, -15.952996770475579),\n",
       " (-64.45507453344247, 17.052326328062207),\n",
       " (84.99087881137797, 147.93680071754522),\n",
       " (-19.0954513817326, 74.04766885866366),\n",
       " (10.274190249955993, -177.25685616717703),\n",
       " (-77.97775703717122, -15.717082932221928),\n",
       " (81.31499210795997, 9.753831545322697),\n",
       " (48.74664584085298, -4.484380768271819),\n",
       " (66.27551792624647, -43.579754633391104),\n",
       " (-8.001329818114598, 130.6241533399538),\n",
       " (-43.20088102261566, 136.19064124954838),\n",
       " (10.331331437072578, 87.10028396424468),\n",
       " (-27.809006184024604, -30.982386572396194),\n",
       " (-65.6995168939232, 0.07839860820618583),\n",
       " (53.26967508507781, -89.30631250331372),\n",
       " (-81.87355294613994, 4.056845857426566),\n",
       " (-1.7936368141107266, -116.47057793835992),\n",
       " (60.038326014460154, 161.92255740268348),\n",
       " (2.5686300797996466, 116.11678812168662),\n",
       " (9.515264494476568, 114.44628474762294),\n",
       " (-17.58776007512327, 110.36268466807917),\n",
       " (16.307095395594814, -69.14362935965676),\n",
       " (73.19908798634324, -138.94545758332106),\n",
       " (-75.39723148569595, 122.22005068335443),\n",
       " (-68.52512385952062, -96.60464295787848),\n",
       " (75.85075049227933, -68.12125106271996),\n",
       " (-21.49822764646865, -34.97284674622955),\n",
       " (-80.04335486084167, -78.74670615932891),\n",
       " (80.50116321421953, -12.15367965184089),\n",
       " (25.44800099515743, -61.307915385650915),\n",
       " (74.51883181554078, 177.74968967479805),\n",
       " (19.175374802334233, 112.59347180041203),\n",
       " (32.63632915841872, -44.57036034968942),\n",
       " (76.79952262028948, 95.43567035710038),\n",
       " (-9.021803837681688, 107.20834289887028),\n",
       " (-76.50344723105759, 165.41558062445614),\n",
       " (77.90542907059643, 119.86540597262865),\n",
       " (35.34319182430487, 99.32020049215157),\n",
       " (85.85425462076901, -38.658345074733006),\n",
       " (-33.690700431348546, 102.25105006104042),\n",
       " (68.80481297801751, 123.39012911842048),\n",
       " (-36.9717139969036, 71.83551765681023),\n",
       " (-50.45465306793515, 53.08017551912664),\n",
       " (-44.528439277307136, -103.03527559759237),\n",
       " (-64.4553635756468, -26.889419310745666),\n",
       " (-58.67613031561379, 178.91216162897655),\n",
       " (-75.05176146061001, -38.08320221529456),\n",
       " (12.072780086693086, 154.4395148597822),\n",
       " (15.454361472561303, -162.04771807055937),\n",
       " (2.03695517626052, -65.43223010037255),\n",
       " (-14.7878200701969, -20.423598255488372),\n",
       " (46.811595299921606, 14.192195563522858),\n",
       " (-61.383442784468244, 58.097148079353246),\n",
       " (12.362271808032588, -108.6055481329642),\n",
       " (-41.82257042224812, -156.1809676225663),\n",
       " (-33.6219683081968, 73.54464213420272),\n",
       " (-22.843575499599908, 53.77135557348217),\n",
       " (14.728527722936846, -148.51566433845207),\n",
       " (57.36571992896046, -138.57870786843137),\n",
       " (1.6509951823005906, 118.23176155406651),\n",
       " (61.77089955944294, -149.33405224959048),\n",
       " (52.53888445486709, 54.24627965481565),\n",
       " (30.50731783875277, 37.312307279641885),\n",
       " (81.8304911762084, 150.81613086521338),\n",
       " (-77.56610284760363, -21.707342134843685),\n",
       " (0.6644219971600052, -174.14241061751207),\n",
       " (57.73486068581656, -164.80414313826057),\n",
       " (-52.23773714765854, -59.890677236259464),\n",
       " (-16.37824843729696, 123.66449259765676),\n",
       " (-71.62202288279175, -20.173797730775902),\n",
       " (-44.44196070721483, 137.92316337751294),\n",
       " (16.908028890496396, 173.60268624740002),\n",
       " (-76.85476954407565, -19.77830887897619),\n",
       " (-70.19129453186133, 43.663666214024346),\n",
       " (-31.607430327073224, -178.017643328766),\n",
       " (-36.03119773287771, 12.216005270514387),\n",
       " (-56.07147711808525, 25.8457167108279),\n",
       " (4.185575449495147, -91.39827896304911),\n",
       " (59.44752513997366, -145.00142607910652),\n",
       " (-24.180087049290393, 126.62565701128864),\n",
       " (-42.91069177304274, -106.96172978520156),\n",
       " (7.109438386028103, 21.721963666141306),\n",
       " (-66.82046402484545, -98.3978378121755),\n",
       " (38.02111404801565, -121.85402116147407),\n",
       " (75.16238709563916, 88.22224997258337),\n",
       " (-21.922737999137965, 127.41372430309173),\n",
       " (-2.233369138505168, 4.088746423543228),\n",
       " (-46.02219381799247, -67.30340270836336),\n",
       " (45.91514891105416, 144.65684739322836),\n",
       " (14.380981356994852, 38.80321080382396),\n",
       " (-68.4548684744962, -0.1824554145773618),\n",
       " (-20.646353598066256, 108.94736107094315),\n",
       " (86.61103977633431, 62.382574106130164),\n",
       " (-34.85111627711683, -100.6783939748936),\n",
       " (-24.829447134536082, 85.06242108054147),\n",
       " (88.97740395081479, -40.477132130061506),\n",
       " (-20.995873520404658, -22.289142380010446),\n",
       " (6.199500840156375, -57.498143656009674),\n",
       " (-72.89639365661431, -161.31526116884876),\n",
       " (-55.554947553035035, -119.32200715881407),\n",
       " (51.772192305731636, 109.46827706477296),\n",
       " (-15.36537069275471, -175.63874383860542),\n",
       " (-83.86452381362528, 30.20348322895586),\n",
       " (-33.60850647651654, 145.41705488112729),\n",
       " (61.44545726255856, -36.17566155275472),\n",
       " (33.556914273721745, 104.34885216851097),\n",
       " (3.221084736975797, -8.327704477183971),\n",
       " (-31.276227382636478, -79.61431770967164),\n",
       " (74.39071142849977, 12.411710333189205),\n",
       " (-30.50450583021211, 42.78020904582698),\n",
       " (48.05255831149469, 20.374271604356494),\n",
       " (26.151177156814043, -55.98128198514067),\n",
       " (-5.415605087298474, -56.80078004071635),\n",
       " (-41.36336553258356, 98.73150330485885),\n",
       " (-45.14324828477032, -84.07725739981328),\n",
       " (-37.52607053025383, -47.84016331963895),\n",
       " (-38.3898993959373, -167.90375376403543),\n",
       " (32.92486871132482, -153.2260764953773),\n",
       " (4.198401825820923, -28.357768650733902),\n",
       " (60.35286147536897, -8.040814426411345),\n",
       " (2.1372288960388914, 127.7968155599998),\n",
       " (54.04521422359008, -86.52924333141713),\n",
       " (26.614078154840797, 31.245048749708474),\n",
       " (67.3979564157419, 77.47668090981648),\n",
       " (-59.36854080169143, 8.729207267822488),\n",
       " (51.132876899349725, -23.596430088882926),\n",
       " (71.11485987505088, 133.81420698138038),\n",
       " (-7.547887519458101, 107.99901097980984),\n",
       " (-57.98351018499747, -119.05159334580489),\n",
       " (46.636257877026765, -159.96905557124325),\n",
       " (58.702300160399176, -86.4124325044867),\n",
       " (-87.07590815844387, 31.34347705817578),\n",
       " (85.34146583493057, -160.15640564445977),\n",
       " (-58.09811285004734, -45.63313677236411),\n",
       " (-64.3637018353636, 69.87194041262049),\n",
       " (48.98110757181834, -3.191314416359461),\n",
       " (40.54360641754178, -105.07741207514773),\n",
       " (-32.026958016665056, 147.99716883066867),\n",
       " (44.92979197861379, 102.18059916159064),\n",
       " (-71.95350662629355, 76.50393389491342),\n",
       " (89.25124885629253, 67.58350833380268),\n",
       " (-66.59111791434628, 130.67154740986092),\n",
       " (72.60612742728983, 49.03964055352566),\n",
       " (2.065377809153688, -80.52549176361826),\n",
       " (10.316495871132375, -33.20853647813843),\n",
       " (53.46384898714396, 92.48507937595872),\n",
       " (5.648486923239318, -73.89564439974853),\n",
       " (27.080563661398685, 93.490519336278),\n",
       " (34.304056985524596, -144.05829005007212),\n",
       " (63.73266738122828, -171.45229488106932),\n",
       " (-43.06879758113157, -57.66241522256087),\n",
       " (-43.91752971267812, 88.32377020906779),\n",
       " (-63.48023679433796, -86.2655853426669),\n",
       " (-85.11814955956784, -17.16946324884998),\n",
       " (-33.87829711551359, -157.02143898634108),\n",
       " (-5.99304808437455, -95.45204663169054),\n",
       " (40.24106122453753, 114.98817393016338),\n",
       " (-71.8662513045853, 14.739389716727771),\n",
       " (-1.818674901289441, 55.520235033408255),\n",
       " (-8.174775799570412, -5.1094686888466185),\n",
       " (-18.684080654811225, -47.09750341825679),\n",
       " (19.40367013697177, -114.0959166668988),\n",
       " (80.57847035758982, -48.95631272971244),\n",
       " (-32.06966993130173, 41.77585527985656),\n",
       " (-74.40189887328447, 138.34341529336916),\n",
       " (-86.37243839003295, 13.569857481567084),\n",
       " (-80.56821540468326, 4.062935594203708),\n",
       " (-79.46002690008984, 58.39431056536242),\n",
       " (40.763075969711736, 134.6596460842738),\n",
       " (63.76471212716507, -32.51268137525267),\n",
       " (27.885973811272052, 95.5727336195747),\n",
       " (-83.37800623096778, -117.43759848558179),\n",
       " (2.094494736478353, -120.94447364684926),\n",
       " (46.14741115420097, -98.10494201056069),\n",
       " (-32.37026940767998, 58.043297514401644),\n",
       " (-43.57161438820266, 156.35662715004554),\n",
       " (31.579666690711903, 159.6251011552116),\n",
       " (81.3372239262111, 176.26243091416518),\n",
       " (22.272415958380208, 121.0030939905572),\n",
       " (36.87316325492051, 146.95172050233003),\n",
       " (-45.49637236727631, 36.41887623796052),\n",
       " (44.886573782038, 83.14461937582018),\n",
       " (-46.17710869172086, -0.2989606379093743),\n",
       " (-79.54330083591182, 120.91706349353524),\n",
       " (75.31706886787953, 151.08769439079236),\n",
       " (-71.03258556835416, 56.68846412883744),\n",
       " (-58.570219937671325, 89.73166414793707),\n",
       " (-14.205852185350977, -7.392022522319991),\n",
       " (39.46615855812348, -143.47027756095747),\n",
       " (36.93672339060616, 126.62623901423586),\n",
       " (-25.68882094635684, 170.24603943034998),\n",
       " (-41.449844205023666, 77.08915736633378),\n",
       " (-0.7887225911586597, 161.26354276433432),\n",
       " (-1.8372242902790958, 4.18508480506577),\n",
       " (-54.71820940405759, 86.33318273204634),\n",
       " (28.35075164500016, 135.89999549369668),\n",
       " (-81.0993343176229, 27.557780032283205),\n",
       " (12.431098372468213, -62.6966056726577),\n",
       " (-80.16185419093344, 51.20261786690671),\n",
       " (44.18524885719481, 174.59160092247998),\n",
       " (65.68233464178374, -0.5881287439736695),\n",
       " (-30.69662815703716, 32.274808385577074),\n",
       " (74.50784273025727, -81.46133554618137),\n",
       " (-66.30841416265946, -2.9201282416259744),\n",
       " (-29.21843835713993, -150.6206161321594),\n",
       " (-12.520190753953543, -100.38361057368836),\n",
       " (-32.37807297773378, -162.48828560130244),\n",
       " (-68.37151759833081, -124.73165115595523),\n",
       " (50.9953311968562, -62.137139446819006),\n",
       " (-68.38377670057653, 47.74494212554953),\n",
       " (22.295828398393837, -74.96729394018494),\n",
       " (-26.064995291299745, -10.76633755315163),\n",
       " (83.26198831438126, -62.03032085105414),\n",
       " (30.330814719692754, 152.1935510927177),\n",
       " (79.74326275043327, -45.69165622695314),\n",
       " (-68.82287107519336, -33.77924389733613),\n",
       " (70.17728641984345, -52.37780389097024),\n",
       " (-65.38637183818597, 166.68174011321776),\n",
       " (-49.248137057378656, 46.2969386691629),\n",
       " (74.38128477398294, 57.32326337543773),\n",
       " (17.2598304555502, -72.11375501493445),\n",
       " (-47.72521023442368, -41.846732774634944),\n",
       " (42.83098353994791, 76.9506126781377),\n",
       " (52.84357461916193, -16.6468369112024),\n",
       " (-55.1974330545268, -175.97430622474644),\n",
       " (74.21954455814489, 155.26247748586337),\n",
       " (75.60600988509603, -32.071739958342675),\n",
       " (73.49731545223764, 115.82810120290662),\n",
       " (-50.44965311274789, -133.06683006700717),\n",
       " (70.75148119382337, -11.17022840431062),\n",
       " (-76.19927859820184, 83.74435659246404),\n",
       " (-81.5264002169564, -60.438444525725444),\n",
       " (41.23976406958664, 69.53037443873609),\n",
       " (-11.689730160108596, 70.90314044646226),\n",
       " (18.762430178538438, -78.01902117794512),\n",
       " (-50.11513447109392, -28.645711298376995),\n",
       " (-18.292168074095173, -102.30209019982466),\n",
       " (-75.2131962191252, -57.770575611414344),\n",
       " (86.09313330600156, -162.68892604825146),\n",
       " (-38.08657070664625, -25.51799864860996),\n",
       " (-53.84242398852094, 168.26966277666406),\n",
       " (21.647208151448808, -127.86352550975184),\n",
       " (69.77497437059, 144.7107788488284),\n",
       " (-29.809420437426255, 56.41809880299317),\n",
       " (77.84318199528394, -33.204132949509074),\n",
       " (-10.989772279829978, -39.021933019193455),\n",
       " (84.81567645575194, 71.1976930947001),\n",
       " (-83.88935733904545, 58.39708459099185),\n",
       " (45.49068601239841, -141.12889521190192),\n",
       " (47.858679535638345, 110.69564989338585),\n",
       " (70.46219641018396, 112.16869357974173),\n",
       " (-18.421865429972044, 45.87220216718188),\n",
       " (-33.22967990760472, -168.48517998133173),\n",
       " (-5.114559832403245, -131.0303288044625),\n",
       " (-13.580880725660691, -60.5720276699555),\n",
       " (-68.36188479401282, -50.21263331204659),\n",
       " (-53.151474789704956, 7.374115796674516),\n",
       " (26.36418066698748, -67.25165759829606),\n",
       " (-0.8617429134248056, 138.6897554429977),\n",
       " (-2.59533965882936, -60.84550398593052),\n",
       " (-7.1323341555397946, -170.27769402952921),\n",
       " (41.354187899594166, 103.07684557696797),\n",
       " (39.6003186617549, 104.86779576879587),\n",
       " (60.091936718524096, -124.16627256404331),\n",
       " (-37.905266676821626, 73.76450369906584),\n",
       " (-29.085825706830242, -173.75407096455552),\n",
       " (70.65888203216099, 99.66049296833256),\n",
       " (-10.056716883421117, 111.56459259756446),\n",
       " (89.68363128596872, 132.1006222355017),\n",
       " (27.505357425221973, -39.774082722045506),\n",
       " (-73.41521422593249, 68.6767983316658),\n",
       " (60.99192461808255, -176.43790097834037),\n",
       " (40.645236048901324, 60.74027278271234),\n",
       " (-17.636222427990518, 17.45278838688344),\n",
       " (-56.00205266582382, -25.536037515419594),\n",
       " (-82.14109123795319, 30.35328806872556),\n",
       " (22.52165403617252, 53.862625209471986),\n",
       " (40.99490806738015, -97.03024768370996),\n",
       " (-50.10403464013754, -66.37077024562659),\n",
       " (-72.99494602728925, -157.72934210357516),\n",
       " (37.10830919025261, -133.09302211614298),\n",
       " (54.920423096947786, 33.36530764723281),\n",
       " (45.501313651363546, -119.6828343882682),\n",
       " (-7.841430162469393, -170.19385618501306),\n",
       " (36.02303881465885, -90.61930938417454),\n",
       " (49.10439439077112, -82.20186947409978),\n",
       " (50.42636554575549, 88.07897029588645),\n",
       " (-47.69704884951164, 162.74156722996076),\n",
       " (17.90903412197251, 3.266333805039494),\n",
       " (-24.463907521848938, -69.48968053981719),\n",
       " (8.45948172258116, 165.6926997434519),\n",
       " (3.8147636186053404, -157.8143463557409),\n",
       " (34.414797076956205, -153.89697929838616),\n",
       " (-3.8721480386002582, 79.07743507512237),\n",
       " (-27.24978407121717, 53.18467382128054),\n",
       " (13.421417844234583, -79.99600819936492),\n",
       " (21.78188092585627, 41.00829501504643),\n",
       " (16.492258463846497, 134.0774551070554),\n",
       " (16.033809890591712, 91.0120360000235),\n",
       " (-43.494420310409986, 154.87069953008893),\n",
       " (-56.16372650793672, 11.985964092179216),\n",
       " (54.14810502780935, -80.59885882425743),\n",
       " (89.82319321365313, 16.969704206131155),\n",
       " (-88.70267923176094, 10.431141309404097),\n",
       " (-0.27422585864405846, -47.648070717382666),\n",
       " (21.105979232357697, -23.085371649145003),\n",
       " (-33.79268988024621, -80.06106054060409),\n",
       " (-28.048468188426163, -21.719529079998495),\n",
       " (13.62338897664793, -144.4264979038317),\n",
       " (-42.66384074446804, -1.4630970355688078),\n",
       " (54.85936193183133, 18.45442352615089),\n",
       " (-33.15111104510035, 12.351902829147491),\n",
       " (-3.7528535503108174, 16.04410731584136),\n",
       " (-72.96776414809558, -28.674066031505788),\n",
       " (-57.69103732793659, -51.17201823460306),\n",
       " (15.156720105166968, -149.8661735076841),\n",
       " (-48.9813696241589, -102.99779173766991),\n",
       " (-30.32956722103679, -131.53029282272297),\n",
       " (-13.51305174382982, -119.03504018541356),\n",
       " (51.906243442603284, 52.149819216581136),\n",
       " (-75.90489092233578, -16.320019990469433),\n",
       " (17.816338685259822, -18.341992500907622),\n",
       " (63.40244816052922, 150.2421915196121),\n",
       " (-21.871868873167912, -18.675073935517105),\n",
       " (64.15887079685922, -124.52559581309421),\n",
       " (37.34645000632442, 135.15256216060556),\n",
       " (64.90471671723819, -46.70688531155744),\n",
       " (43.79977860382263, 57.23225480945612),\n",
       " (-8.046547113692299, 156.99408494704204),\n",
       " (67.54577684787088, 35.22302393160595),\n",
       " (61.13038659474114, 167.1469691608379),\n",
       " (-10.442249468917623, -170.54663692146966),\n",
       " (75.02677713474213, 115.74452565547449),\n",
       " (-49.85809300561086, 5.611184723044971),\n",
       " (-33.80582901567587, 160.90022994004397),\n",
       " (-78.05659076717403, 130.61105712728903),\n",
       " (-11.477943270228991, 7.0928348246064274),\n",
       " (3.7051212679063497, -112.79176878572723),\n",
       " (-50.04847923380328, -163.95160849994036),\n",
       " (24.50450179940067, -125.63298103980401),\n",
       " (-60.542409899512194, 143.19799012530444),\n",
       " (71.538922871513, -85.83608468098704),\n",
       " (-19.047247464742412, 124.92999251041533),\n",
       " (-23.695714836830703, 84.7414414599624),\n",
       " (74.97835483156976, -60.59809256950872),\n",
       " (-25.011648128298788, -72.78981017849013),\n",
       " (-7.857347436380238, 124.57015062980366),\n",
       " (-12.196140780999542, 85.51761047191104),\n",
       " (30.769534932286106, -178.2841288972625),\n",
       " (51.67049098729103, 100.50167356378569),\n",
       " (13.433126161762729, -129.29145058865276),\n",
       " (-1.2681726298289675, 44.13527544125901),\n",
       " (71.81812709010563, -134.61038978016524),\n",
       " (-5.452452123235759, -114.47663909402954),\n",
       " (31.713940035324725, -45.82291591009104),\n",
       " (23.857694214427156, -109.1533521516903),\n",
       " (-48.23684074498952, 84.78933990323355),\n",
       " (-44.36689220437926, -137.44777484723886),\n",
       " (63.628551254628746, 174.3890967950851),\n",
       " (1.839164642609319, 12.68039360206663),\n",
       " (53.44567465929535, 166.6616270569752),\n",
       " (-35.04400023500516, 136.83570127713898),\n",
       " (-48.73918228495666, 120.3218817825209),\n",
       " (-4.728386295431008, 140.87778492440543),\n",
       " (-85.26495984568412, 17.00229443677125),\n",
       " (-74.26041827458072, -132.3505749392798),\n",
       " (-49.38821799729455, 77.66708280591843),\n",
       " (-33.66007547790354, -169.6804919227406),\n",
       " (12.836561805694686, 51.74715638246744),\n",
       " (-56.427780503511244, 47.98958496579712),\n",
       " (-6.625932460687025, -120.52658050858128),\n",
       " (-20.584647066698963, -175.7286794246749),\n",
       " (-37.79204534103495, -113.90910981925721),\n",
       " (-86.64778289729551, 150.12923932430573),\n",
       " (-37.63119913630445, 144.7476913936427),\n",
       " (-22.082334322154637, -110.86914264584388),\n",
       " (10.937390568574173, 157.3349019173021),\n",
       " (-48.556184233103906, 122.0410223087622),\n",
       " (74.49185444128653, -84.65501028359485),\n",
       " (-58.4741498263696, -172.8503511688158),\n",
       " (-40.633781237393585, 51.0760443615259),\n",
       " (-53.92313759677596, -73.60023093533238),\n",
       " (-62.04825353676002, -51.871647933268406),\n",
       " (-37.38032633830076, 119.12836797632337),\n",
       " (-89.04565540404164, -140.90900839057014),\n",
       " (-36.7785837307592, 5.099214655959685),\n",
       " (-65.3612738413631, 158.63984614419928),\n",
       " (-42.3785243487365, -34.1212589984454),\n",
       " (-44.79376978142658, 10.154410158342074),\n",
       " (22.309313771971546, -119.22892703956826),\n",
       " (-55.8298621608125, 166.3081825608208),\n",
       " (-9.124889332338213, 27.683080689388788),\n",
       " (72.88855734888406, 60.11174891484214),\n",
       " (80.61494558967948, -176.097972805406),\n",
       " (-74.93387472661816, 83.00523423055841),\n",
       " (-56.009789961086646, 42.10735632474055),\n",
       " (28.844292089655, -161.17118058636055),\n",
       " (-81.55790409340794, 172.71792915785142),\n",
       " (32.188790949213384, 29.337363251905515),\n",
       " (18.392203628249646, -47.13252328973121),\n",
       " (59.457643027434216, -112.79264350339704),\n",
       " (-50.04964545800103, -94.73044801802853),\n",
       " (13.960916596635087, -129.89243816696754),\n",
       " (-23.52062630612437, 152.06194973836637),\n",
       " (85.21062287663563, 162.72960781351998),\n",
       " (35.79939699611987, 125.32770489342658),\n",
       " (7.404300462114591, -8.288950128686906),\n",
       " (-55.46388495752814, 100.19317561931717),\n",
       " (62.44057708350772, 136.85509138139503),\n",
       " (11.050010112076023, -138.27711359542124),\n",
       " (77.1914011052628, 31.24367156015586),\n",
       " (-72.96322159209839, -178.26132568177886),\n",
       " (78.38511276760639, -133.62475294425116),\n",
       " (-78.96824917199508, 168.55034141072656),\n",
       " (-28.30702928312042, -111.54931784337678),\n",
       " (61.17083362790419, -52.067787698798156),\n",
       " (-22.450357282247396, -73.52595587180937),\n",
       " (71.90232591705345, 148.4067246108532),\n",
       " (-75.72807635042498, 124.9470924869791),\n",
       " (31.830142646725008, 72.76131445809662),\n",
       " (-56.214260766665525, -60.847567659731084),\n",
       " (-3.5452499341443655, -52.25812583983354),\n",
       " (48.19454099032953, -115.28263111147643),\n",
       " (-19.408320864435154, -75.32868196239879),\n",
       " (-68.92088415479887, -128.33853773309397),\n",
       " (10.289204133082293, -86.91938097950275),\n",
       " (78.33754907099441, 132.75322212345003),\n",
       " (-62.96143665800725, -46.2602576731299),\n",
       " (61.38242999699369, -151.82016742703962),\n",
       " (5.403891952317494, 74.66968476802458),\n",
       " (5.817200822096794, 21.688655143913877),\n",
       " (43.972423342352755, -15.35562154851209),\n",
       " (70.22714322804862, 71.86644331199918),\n",
       " (11.209908243659726, -160.90665962658815),\n",
       " (89.89207245534459, 91.58189228896754),\n",
       " (53.57993864199517, -117.29644690838511),\n",
       " (-59.37786086130434, 93.38946116346494),\n",
       " (69.2455080847493, -60.56788497931693),\n",
       " (15.599599990754456, -109.3300672552222),\n",
       " (-83.78164550290032, -165.68994646219952),\n",
       " (-15.134789393666821, -60.7696639276777),\n",
       " (-63.71960386709076, 92.88241654249236),\n",
       " (-6.893233818709064, -142.96135393051446),\n",
       " (39.34464138803628, -177.55958822895946),\n",
       " (68.3324521388331, -121.99934788723974),\n",
       " (62.55325799780812, -67.51871863479866),\n",
       " (50.497106731844696, -158.04894913478938),\n",
       " (66.09948283872762, -23.08502551989227),\n",
       " (46.168809171338324, 110.95700738088783),\n",
       " (76.75245440163178, -108.46893579879438),\n",
       " (-39.9852563249514, 127.88342111133295),\n",
       " (67.04195862867041, -142.06241411700742),\n",
       " (-47.904246377992365, 152.0818945136815),\n",
       " (-40.221653965825936, 94.23059790550263),\n",
       " (57.519384372482875, 60.97646665565574),\n",
       " (9.48823054252584, -31.498917252070584),\n",
       " (50.95639574456976, 117.98464929490075),\n",
       " (12.792309379892188, 70.03069068998644),\n",
       " (-39.05394875814488, 9.291705796017794),\n",
       " (88.64874770914557, -123.79610150214384),\n",
       " (-17.104759470770276, -134.63867412249337),\n",
       " (-86.97168034758981, 54.11088538816759),\n",
       " (-29.92169670779991, 20.932129735705814),\n",
       " (-87.41959930106165, -116.0097537460461),\n",
       " (-88.80971970472537, -35.00835612544975),\n",
       " (-75.29546128967976, 9.864369702224991),\n",
       " (-39.00759858160409, -67.02609871193307),\n",
       " (-39.47040013101638, 70.9705668184582),\n",
       " (58.63987051104968, -13.834059956724928),\n",
       " (44.727899903415334, -48.913245189681106),\n",
       " (-72.87056759227579, 145.0168066513791),\n",
       " (-44.832375098144325, -122.40537302927561),\n",
       " (-41.3522028575771, 94.40643427467705),\n",
       " (-69.92918031743675, -131.42737850717802),\n",
       " (-75.20502016052518, 103.23584506649684),\n",
       " (-49.15749946379132, 12.283048579235128),\n",
       " (-71.10301821194204, 170.94358048105278),\n",
       " (46.26100398974748, -122.89289572597137),\n",
       " (-72.53101913330762, 33.50466137957966),\n",
       " (-63.610170735312266, -41.28704634757216),\n",
       " (40.49502895723231, -10.69966312087891),\n",
       " (42.029272187954206, 105.90184667008151),\n",
       " (89.06747976084145, 5.265246239101856),\n",
       " (35.91074283728497, 166.54645408776491),\n",
       " (48.18200533405019, 106.10520733145029),\n",
       " (-59.355418135035514, 103.19062780257963),\n",
       " (1.6536045319808323, 71.92101835093243),\n",
       " (-5.334548578870397, -126.25005729109873),\n",
       " (-43.30057783738358, -42.869182254570575),\n",
       " (-66.29768969658774, -79.60821159743871),\n",
       " (65.45672348464313, 3.5946820412798672),\n",
       " (-38.86336680449092, -27.151454368828126),\n",
       " (-9.53757065927826, 37.38948018122764),\n",
       " (11.509957789879948, 34.94846294492578),\n",
       " (31.93288321451503, 9.93171721401501),\n",
       " (-47.17478341946086, 128.48065833253872),\n",
       " (-68.0021611159622, 4.994783382157323),\n",
       " (-34.57019671306733, -100.16810211399756),\n",
       " (-83.26607663089234, 37.45693456379797),\n",
       " (83.48153862294967, -138.65421625960755),\n",
       " (77.45104724260722, -134.3491796901072),\n",
       " (-1.0496989977350921, 63.85391595947101),\n",
       " (27.248274024428397, -106.49884286005548),\n",
       " (-77.44277554672297, -54.12682798614712),\n",
       " (-64.83367902954723, -132.29462496828023),\n",
       " (-64.18742897658342, 16.618781594998666),\n",
       " (25.15728730340045, -23.356173086719366),\n",
       " (31.806270838798042, -61.20328799004109),\n",
       " (-54.07696519451556, 127.89833242604146),\n",
       " (-33.114031774873766, -141.81266956382314),\n",
       " (48.51788359503229, 147.1947444292304),\n",
       " (85.76824475256566, 63.25745058145014),\n",
       " (31.300319968697238, 117.33173738481838),\n",
       " (-46.37235244441227, 125.57447289100111),\n",
       " (-7.6873606495585705, -41.00877413347368),\n",
       " (-24.924016597388842, 65.64861759002042),\n",
       " (-89.03260455652827, -144.55780262904025),\n",
       " (-14.428137604672159, -57.2153954497733),\n",
       " (-12.332012167770472, -121.91299063235209),\n",
       " (38.3947278339036, -163.24990474702267),\n",
       " (73.3947243005617, 13.38961886612114),\n",
       " (-85.01095599993025, 158.164288538238),\n",
       " (-2.1600324372634105, 167.64928245480962),\n",
       " (39.794900389867564, -173.86184458370633),\n",
       " (70.45593648063729, -114.69231480172407),\n",
       " (-0.46771747079060333, -130.32875862448697),\n",
       " (-0.983007428222777, -178.48654405713233),\n",
       " (73.99220465884639, 117.38746580320634),\n",
       " (-79.50246165899637, -150.53037236846828),\n",
       " (37.53682541426943, -153.67065771255506),\n",
       " (-2.2990489009035855, 44.241632349973514),\n",
       " (-78.7654105614164, -72.9667725558813),\n",
       " (-84.24407501408346, -167.1219123802099),\n",
       " (-75.26174406703629, 7.111308287503476),\n",
       " (47.90249835517352, 64.70216999815193),\n",
       " (-47.7948474006631, -92.32496127068721),\n",
       " (54.23825097485181, -32.67471481469411),\n",
       " (-71.46507497265131, -147.45914732843266),\n",
       " (-7.55514573621393, -133.93643078771356),\n",
       " (84.22365815837145, -59.57424819568507),\n",
       " (5.437177195720309, -151.2150983447858),\n",
       " (55.99582852950306, -152.91032911351252),\n",
       " (19.904302602385627, 113.98319657822816),\n",
       " (30.29814685814341, 24.600017544370075),\n",
       " (-17.580696904553648, -76.43089332232378),\n",
       " (8.044235672358766, 132.68830283146605),\n",
       " (-39.29731079159565, -12.897728753751636),\n",
       " (61.29380049689422, 138.48604682566327),\n",
       " (-81.87595218721246, 140.10106618193697),\n",
       " (37.434554302230964, -19.858887074913326),\n",
       " (-12.190590238651822, -42.76955680488808),\n",
       " (7.938920547935069, -56.18154780212369),\n",
       " (-10.022939231323264, -45.85224378418107),\n",
       " (56.60443444117604, -142.7277941793433),\n",
       " (31.918351972238867, 111.96374487249722),\n",
       " (-8.532725298978434, 0.3957504621116925),\n",
       " (64.01470179599684, -163.88698988511197),\n",
       " (-51.32134041133628, 126.50455079287798),\n",
       " (46.004828496151475, 97.90900585512514),\n",
       " (-14.076801810132821, -172.95680789020247),\n",
       " (23.313480119310995, 19.345750788976943),\n",
       " (86.3728621060028, 3.550610376157522),\n",
       " (-58.737571185915456, -79.50903822366438),\n",
       " (-7.682739925753836, 74.64109281168376),\n",
       " (-43.96193449254609, 172.98531529933825),\n",
       " (80.75807871322183, -144.2841074774957),\n",
       " ...]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Add the latitudes and longitudes to a list.\n",
    "coordinates = list(lat_lngs) \n",
    "coordinates "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a list for holding the cities.\n",
    "cities = []\n",
    "# Identify the nearest city for each latitude and longitude combination.\n",
    "for coordinate in coordinates:\n",
    "    city = citipy.nearest_city(coordinate[0], coordinate[1]).city_name \n",
    "    \n",
    "    # If the city is unique, then we will add it to the cities list.\n",
    "    if city not in cities:\n",
    "        cities.append(city) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Starting URL for Weather Map API Call.\n",
    "url = \"http://api.openweathermap.org/data/2.5/weather?units=Imperial&APPID=\" + api_key "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Beginning Data Retrieval     \n",
      "-----------------------------\n"
     ]
    }
   ],
   "source": [
    "#6.2.6\n",
    "# Create an empty list to hold the weather data.\n",
    "city_data = []\n",
    "# Print the beginning of the logging.\n",
    "print(\"Beginning Data Retrieval     \")\n",
    "print(\"-----------------------------\")\n",
    "\n",
    "# Create counters.\n",
    "record_count = 1\n",
    "set_count = 1 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Loop through all the cities in our list.\n",
    "for i in range(len(cities)):\n",
    "\n",
    "    # Group cities in sets of 50 for logging purposes.\n",
    "    if (i % 50 == 0 and i >= 50):\n",
    "        set_count += 1\n",
    "        record_count = 1\n",
    "    # Create endpoint URL with each city.\n",
    "    city_url = url + \"&q=\" + cities[i] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 1 of Set 15 | jamestown\n",
      "Processing Record 2 of Set 15 | portland\n",
      "Processing Record 3 of Set 15 | hasaki\n",
      "Processing Record 4 of Set 15 | castro\n",
      "Processing Record 5 of Set 15 | chimore\n",
      "Processing Record 6 of Set 15 | tangi\n",
      "Processing Record 7 of Set 15 | nizhneyansk\n",
      "City not found. Skipping...\n",
      "Processing Record 8 of Set 15 | hobart\n",
      "Processing Record 9 of Set 15 | rio gallegos\n",
      "Processing Record 10 of Set 15 | clyde river\n",
      "Processing Record 11 of Set 15 | dunedin\n",
      "Processing Record 12 of Set 15 | tual\n",
      "Processing Record 13 of Set 15 | rikitea\n",
      "Processing Record 14 of Set 15 | hilo\n",
      "Processing Record 15 of Set 15 | sioux lookout\n",
      "Processing Record 16 of Set 15 | maloy\n",
      "Processing Record 17 of Set 15 | flinders\n",
      "Processing Record 18 of Set 15 | umzimvubu\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 15 | palabuhanratu\n",
      "City not found. Skipping...\n",
      "Processing Record 20 of Set 15 | grand river south east\n",
      "City not found. Skipping...\n",
      "Processing Record 21 of Set 15 | kruisfontein\n",
      "Processing Record 22 of Set 15 | pochutla\n",
      "Processing Record 23 of Set 15 | grand centre\n",
      "City not found. Skipping...\n",
      "Processing Record 24 of Set 15 | vozhega\n",
      "Processing Record 25 of Set 15 | brazzaville\n",
      "Processing Record 26 of Set 15 | scottsbluff\n",
      "Processing Record 27 of Set 15 | puteyets\n",
      "Processing Record 28 of Set 15 | georgetown\n",
      "Processing Record 29 of Set 15 | saint-philippe\n",
      "Processing Record 30 of Set 15 | mataura\n",
      "Processing Record 31 of Set 15 | cabo san lucas\n",
      "Processing Record 32 of Set 15 | ushuaia\n",
      "Processing Record 33 of Set 15 | campo gobierno\n",
      "Processing Record 34 of Set 15 | bluff\n",
      "Processing Record 35 of Set 15 | mys shmidta\n",
      "City not found. Skipping...\n",
      "Processing Record 36 of Set 15 | rahuri\n",
      "Processing Record 37 of Set 15 | el alto\n",
      "Processing Record 38 of Set 15 | palana\n",
      "Processing Record 39 of Set 15 | wahran\n",
      "City not found. Skipping...\n",
      "Processing Record 40 of Set 15 | grand baie\n",
      "Processing Record 41 of Set 15 | lanigay\n",
      "Processing Record 42 of Set 15 | yulara\n",
      "Processing Record 43 of Set 15 | husavik\n",
      "Processing Record 44 of Set 15 | cayenne\n",
      "Processing Record 45 of Set 15 | taolanaro\n",
      "City not found. Skipping...\n",
      "Processing Record 46 of Set 15 | te anau\n",
      "Processing Record 47 of Set 15 | lebu\n",
      "Processing Record 48 of Set 15 | bredasdorp\n",
      "Processing Record 49 of Set 15 | albany\n",
      "Processing Record 50 of Set 15 | chuy\n",
      "Processing Record 1 of Set 16 | punta arenas\n",
      "Processing Record 2 of Set 16 | barentsburg\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 16 | vaini\n",
      "Processing Record 4 of Set 16 | takab\n",
      "Processing Record 5 of Set 16 | warrnambool\n",
      "Processing Record 6 of Set 16 | tuktoyaktuk\n",
      "Processing Record 7 of Set 16 | big spring\n",
      "Processing Record 8 of Set 16 | eyl\n",
      "Processing Record 9 of Set 16 | qandala\n",
      "Processing Record 10 of Set 16 | oppdal\n",
      "Processing Record 11 of Set 16 | severo-kurilsk\n",
      "Processing Record 12 of Set 16 | busselton\n",
      "Processing Record 13 of Set 16 | mangaratiba\n",
      "Processing Record 14 of Set 16 | khor\n",
      "Processing Record 15 of Set 16 | butaritari\n",
      "Processing Record 16 of Set 16 | barrow\n",
      "Processing Record 17 of Set 16 | marawi\n",
      "Processing Record 18 of Set 16 | sao joao da barra\n",
      "Processing Record 19 of Set 16 | padang\n",
      "Processing Record 20 of Set 16 | hokitika\n",
      "Processing Record 21 of Set 16 | torbay\n",
      "Processing Record 22 of Set 16 | bambous virieux\n",
      "Processing Record 23 of Set 16 | haapiti\n",
      "Processing Record 24 of Set 16 | beloha\n",
      "Processing Record 25 of Set 16 | airai\n",
      "Processing Record 26 of Set 16 | khatanga\n",
      "Processing Record 27 of Set 16 | mrirt\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 16 | carnarvon\n",
      "Processing Record 29 of Set 16 | thompson\n",
      "Processing Record 30 of Set 16 | new norfolk\n",
      "Processing Record 31 of Set 16 | vila velha\n",
      "Processing Record 32 of Set 16 | port alfred\n",
      "Processing Record 33 of Set 16 | nikolskoye\n",
      "Processing Record 34 of Set 16 | tuatapere\n",
      "Processing Record 35 of Set 16 | saldanha\n",
      "Processing Record 36 of Set 16 | illoqqortoormiut\n",
      "City not found. Skipping...\n",
      "Processing Record 37 of Set 16 | atuona\n",
      "Processing Record 38 of Set 16 | hithadhoo\n",
      "Processing Record 39 of Set 16 | avarua\n",
      "Processing Record 40 of Set 16 | qaanaaq\n",
      "Processing Record 41 of Set 16 | pevek\n",
      "Processing Record 42 of Set 16 | kodiak\n",
      "Processing Record 43 of Set 16 | sentyabrskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 44 of Set 16 | coquimbo\n",
      "Processing Record 45 of Set 16 | bexhill\n",
      "Processing Record 46 of Set 16 | meyungs\n",
      "City not found. Skipping...\n",
      "Processing Record 47 of Set 16 | san cristobal\n",
      "Processing Record 48 of Set 16 | kavieng\n",
      "Processing Record 49 of Set 16 | hambantota\n",
      "Processing Record 50 of Set 16 | norman wells\n",
      "Processing Record 1 of Set 17 | petropavlovsk-kamchatskiy\n",
      "Processing Record 2 of Set 17 | saskylakh\n",
      "Processing Record 3 of Set 17 | mersing\n",
      "Processing Record 4 of Set 17 | bethel\n",
      "Processing Record 5 of Set 17 | nobeoka\n",
      "Processing Record 6 of Set 17 | bilma\n",
      "Processing Record 7 of Set 17 | tasiilaq\n",
      "Processing Record 8 of Set 17 | katsuura\n",
      "Processing Record 9 of Set 17 | buchanan\n",
      "Processing Record 10 of Set 17 | tambul\n",
      "City not found. Skipping...\n",
      "Processing Record 11 of Set 17 | gat\n",
      "Processing Record 12 of Set 17 | kapaa\n",
      "Processing Record 13 of Set 17 | provideniya\n",
      "Processing Record 14 of Set 17 | yantai\n",
      "Processing Record 15 of Set 17 | paamiut\n",
      "Processing Record 16 of Set 17 | svetlopolyansk\n",
      "Processing Record 17 of Set 17 | huangchuan\n",
      "Processing Record 18 of Set 17 | puerto ayora\n",
      "Processing Record 19 of Set 17 | hunza\n",
      "City not found. Skipping...\n",
      "Processing Record 20 of Set 17 | viedma\n",
      "Processing Record 21 of Set 17 | cape town\n",
      "Processing Record 22 of Set 17 | yarada\n",
      "Processing Record 23 of Set 17 | san quintin\n",
      "Processing Record 24 of Set 17 | darnah\n",
      "Processing Record 25 of Set 17 | rossland\n",
      "Processing Record 26 of Set 17 | mar del plata\n",
      "Processing Record 27 of Set 17 | olafsvik\n",
      "Processing Record 28 of Set 17 | tilichiki\n",
      "Processing Record 29 of Set 17 | goedereede\n",
      "Processing Record 30 of Set 17 | hirara\n",
      "Processing Record 31 of Set 17 | yirol\n",
      "City not found. Skipping...\n",
      "Processing Record 32 of Set 17 | broome\n",
      "Processing Record 33 of Set 17 | port blair\n",
      "Processing Record 34 of Set 17 | utiroa\n",
      "City not found. Skipping...\n",
      "Processing Record 35 of Set 17 | saint george\n",
      "Processing Record 36 of Set 17 | touho\n",
      "Processing Record 37 of Set 17 | sur\n",
      "Processing Record 38 of Set 17 | port elizabeth\n",
      "Processing Record 39 of Set 17 | acarau\n",
      "Processing Record 40 of Set 17 | bengkulu\n",
      "Processing Record 41 of Set 17 | ambovombe\n",
      "Processing Record 42 of Set 17 | tumannyy\n",
      "City not found. Skipping...\n",
      "Processing Record 43 of Set 17 | caucasia\n",
      "Processing Record 44 of Set 17 | anan\n",
      "Processing Record 45 of Set 17 | illapel\n",
      "Processing Record 46 of Set 17 | aklavik\n",
      "Processing Record 47 of Set 17 | vaitupu\n",
      "City not found. Skipping...\n",
      "Processing Record 48 of Set 17 | ribnitz-damgarten\n",
      "Processing Record 49 of Set 17 | ayame\n",
      "Processing Record 50 of Set 17 | mahebourg\n",
      "Processing Record 1 of Set 18 | saint-joseph\n",
      "Processing Record 2 of Set 18 | montepulciano\n",
      "Processing Record 3 of Set 18 | westport\n",
      "Processing Record 4 of Set 18 | nome\n",
      "Processing Record 5 of Set 18 | yellowknife\n",
      "Processing Record 6 of Set 18 | yuzhno-yeniseyskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 7 of Set 18 | hearst\n",
      "Processing Record 8 of Set 18 | fort nelson\n",
      "Processing Record 9 of Set 18 | san patricio\n",
      "Processing Record 10 of Set 18 | hammerfest\n",
      "Processing Record 11 of Set 18 | alofi\n",
      "Processing Record 12 of Set 18 | ancud\n",
      "Processing Record 13 of Set 18 | solnechnyy\n",
      "Processing Record 14 of Set 18 | ishigaki\n",
      "Processing Record 15 of Set 18 | calvinia\n",
      "Processing Record 16 of Set 18 | reconquista\n",
      "Processing Record 17 of Set 18 | plouzane\n",
      "Processing Record 18 of Set 18 | jizan\n",
      "Processing Record 19 of Set 18 | almaznyy\n",
      "Processing Record 20 of Set 18 | hovd\n",
      "Processing Record 21 of Set 18 | dickson\n",
      "Processing Record 22 of Set 18 | kondoa\n",
      "Processing Record 23 of Set 18 | hermanus\n",
      "Processing Record 24 of Set 18 | hamilton\n",
      "Processing Record 25 of Set 18 | belmonte\n",
      "Processing Record 26 of Set 18 | pisco\n",
      "Processing Record 27 of Set 18 | agadez\n",
      "Processing Record 28 of Set 18 | wasilla\n",
      "Processing Record 29 of Set 18 | adrar\n",
      "Processing Record 30 of Set 18 | longyearbyen\n",
      "Processing Record 31 of Set 18 | laguna\n",
      "Processing Record 32 of Set 18 | vanimo\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 33 of Set 18 | grindavik\n",
      "Processing Record 34 of Set 18 | ribeira grande\n",
      "Processing Record 35 of Set 18 | sorvag\n",
      "City not found. Skipping...\n",
      "Processing Record 36 of Set 18 | guerrero negro\n",
      "Processing Record 37 of Set 18 | narsaq\n",
      "Processing Record 38 of Set 18 | kaitangata\n",
      "Processing Record 39 of Set 18 | victoria\n",
      "Processing Record 40 of Set 18 | seoul\n",
      "Processing Record 41 of Set 18 | athabasca\n",
      "Processing Record 42 of Set 18 | chokurdakh\n",
      "Processing Record 43 of Set 18 | mount gambier\n",
      "Processing Record 44 of Set 18 | pacific grove\n",
      "Processing Record 45 of Set 18 | uige\n",
      "Processing Record 46 of Set 18 | klaksvik\n",
      "Processing Record 47 of Set 18 | ushumun\n",
      "Processing Record 48 of Set 18 | great yarmouth\n",
      "Processing Record 49 of Set 18 | boa vista\n",
      "Processing Record 50 of Set 18 | esperance\n",
      "Processing Record 1 of Set 19 | vadso\n",
      "Processing Record 2 of Set 19 | ajaccio\n",
      "Processing Record 3 of Set 19 | chandbali\n",
      "Processing Record 4 of Set 19 | naze\n",
      "Processing Record 5 of Set 19 | dibrugarh\n",
      "Processing Record 6 of Set 19 | sibolga\n",
      "Processing Record 7 of Set 19 | port lincoln\n",
      "Processing Record 8 of Set 19 | salta\n",
      "Processing Record 9 of Set 19 | falealupo\n",
      "City not found. Skipping...\n",
      "Processing Record 10 of Set 19 | boca do acre\n",
      "Processing Record 11 of Set 19 | ambodifototra\n",
      "City not found. Skipping...\n",
      "Processing Record 12 of Set 19 | east london\n",
      "Processing Record 13 of Set 19 | lolua\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 19 | oriximina\n",
      "Processing Record 15 of Set 19 | mandalgovi\n",
      "Processing Record 16 of Set 19 | comodoro rivadavia\n",
      "Processing Record 17 of Set 19 | etampes\n",
      "Processing Record 18 of Set 19 | makaha\n",
      "Processing Record 19 of Set 19 | skegness\n",
      "Processing Record 20 of Set 19 | attawapiskat\n",
      "City not found. Skipping...\n",
      "Processing Record 21 of Set 19 | santarem\n",
      "Processing Record 22 of Set 19 | ho chi minh city\n",
      "Processing Record 23 of Set 19 | nogliki\n",
      "Processing Record 24 of Set 19 | eatonton\n",
      "Processing Record 25 of Set 19 | itaituba\n",
      "Processing Record 26 of Set 19 | yukamenskoye\n",
      "Processing Record 27 of Set 19 | gorno-chuyskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 19 | shubarkuduk\n",
      "Processing Record 29 of Set 19 | amderma\n",
      "City not found. Skipping...\n",
      "Processing Record 30 of Set 19 | muros\n",
      "Processing Record 31 of Set 19 | praia da vitoria\n",
      "Processing Record 32 of Set 19 | vao\n",
      "Processing Record 33 of Set 19 | datong\n",
      "Processing Record 34 of Set 19 | churachandpur\n",
      "Processing Record 35 of Set 19 | dikson\n",
      "Processing Record 36 of Set 19 | codrington\n",
      "Processing Record 37 of Set 19 | santa maria\n",
      "Processing Record 38 of Set 19 | leningradskiy\n",
      "Processing Record 39 of Set 19 | chapais\n",
      "Processing Record 40 of Set 19 | morant bay\n",
      "Processing Record 41 of Set 19 | vila\n",
      "Processing Record 42 of Set 19 | sao jose da coroa grande\n",
      "Processing Record 43 of Set 19 | sao francisco do sul\n",
      "Processing Record 44 of Set 19 | cidreira\n",
      "Processing Record 45 of Set 19 | dingle\n",
      "Processing Record 46 of Set 19 | guipavas\n",
      "Processing Record 47 of Set 19 | ossora\n",
      "Processing Record 48 of Set 19 | tarakan\n",
      "Processing Record 49 of Set 19 | taburi\n",
      "City not found. Skipping...\n",
      "Processing Record 50 of Set 19 | karratha\n",
      "Processing Record 1 of Set 20 | la romana\n",
      "Processing Record 2 of Set 20 | the valley\n",
      "Processing Record 3 of Set 20 | wanning\n",
      "Processing Record 4 of Set 20 | banjar\n",
      "Processing Record 5 of Set 20 | xining\n",
      "Processing Record 6 of Set 20 | zhigansk\n",
      "Processing Record 7 of Set 20 | nanakuli\n",
      "Processing Record 8 of Set 20 | santa isabel do rio negro\n",
      "Processing Record 9 of Set 20 | feldkirchen\n",
      "Processing Record 10 of Set 20 | saint-leu\n",
      "Processing Record 11 of Set 20 | sitka\n",
      "Processing Record 12 of Set 20 | bontang\n",
      "Processing Record 13 of Set 20 | aleksandrovka\n",
      "Processing Record 14 of Set 20 | bayir\n",
      "Processing Record 15 of Set 20 | palmer\n",
      "Processing Record 16 of Set 20 | bria\n",
      "Processing Record 17 of Set 20 | pittsburg\n",
      "Processing Record 18 of Set 20 | talnakh\n",
      "Processing Record 19 of Set 20 | port-gentil\n",
      "Processing Record 20 of Set 20 | novikovo\n",
      "Processing Record 21 of Set 20 | adwa\n",
      "Processing Record 22 of Set 20 | ilulissat\n",
      "Processing Record 23 of Set 20 | new amsterdam\n",
      "Processing Record 24 of Set 20 | novokizhinginsk\n",
      "Processing Record 25 of Set 20 | hihifo\n",
      "City not found. Skipping...\n",
      "Processing Record 26 of Set 20 | griffith\n",
      "Processing Record 27 of Set 20 | jiangyou\n",
      "Processing Record 28 of Set 20 | harper\n",
      "Processing Record 29 of Set 20 | valparaiso\n",
      "Processing Record 30 of Set 20 | belapatfalva\n",
      "Processing Record 31 of Set 20 | jacareacanga\n",
      "Processing Record 32 of Set 20 | ahuimanu\n",
      "Processing Record 33 of Set 20 | sao filipe\n",
      "Processing Record 34 of Set 20 | vagur\n",
      "Processing Record 35 of Set 20 | ternate\n",
      "Processing Record 36 of Set 20 | tahta\n",
      "Processing Record 37 of Set 20 | tazovskiy\n",
      "Processing Record 38 of Set 20 | vestmannaeyjar\n",
      "Processing Record 39 of Set 20 | ust-kuyga\n",
      "Processing Record 40 of Set 20 | singaparna\n",
      "Processing Record 41 of Set 20 | lannion\n",
      "Processing Record 42 of Set 20 | fort collins\n",
      "Processing Record 43 of Set 20 | dubbo\n",
      "Processing Record 44 of Set 20 | belushya guba\n",
      "City not found. Skipping...\n",
      "Processing Record 45 of Set 20 | esmeraldas\n",
      "Processing Record 46 of Set 20 | yermakovskoye\n",
      "Processing Record 47 of Set 20 | briceno\n",
      "Processing Record 48 of Set 20 | itanagar\n",
      "Processing Record 49 of Set 20 | kahului\n",
      "Processing Record 50 of Set 20 | lavrentiya\n",
      "Processing Record 1 of Set 21 | necochea\n",
      "Processing Record 2 of Set 21 | avera\n",
      "Processing Record 3 of Set 21 | xuanhua\n",
      "Processing Record 4 of Set 21 | coromandel\n",
      "Processing Record 5 of Set 21 | upernavik\n",
      "Processing Record 6 of Set 21 | preobrazheniye\n",
      "Processing Record 7 of Set 21 | pasighat\n",
      "Processing Record 8 of Set 21 | aberdeen\n",
      "Processing Record 9 of Set 21 | taitung\n",
      "Processing Record 10 of Set 21 | kamaishi\n",
      "Processing Record 11 of Set 21 | karamay\n",
      "City not found. Skipping...\n",
      "Processing Record 12 of Set 21 | fortuna\n",
      "Processing Record 13 of Set 21 | buala\n",
      "Processing Record 14 of Set 21 | muroto\n",
      "Processing Record 15 of Set 21 | gouyave\n",
      "Processing Record 16 of Set 21 | brae\n",
      "Processing Record 17 of Set 21 | durban\n",
      "Processing Record 18 of Set 21 | havre-saint-pierre\n",
      "Processing Record 19 of Set 21 | clarence town\n",
      "Processing Record 20 of Set 21 | aasiaat\n",
      "Processing Record 21 of Set 21 | tsihombe\n",
      "City not found. Skipping...\n",
      "Processing Record 22 of Set 21 | pedernales\n",
      "Processing Record 23 of Set 21 | rocha\n",
      "Processing Record 24 of Set 21 | almaty\n",
      "Processing Record 25 of Set 21 | srednekolymsk\n",
      "Processing Record 26 of Set 21 | hofn\n",
      "Processing Record 27 of Set 21 | parkent\n",
      "Processing Record 28 of Set 21 | montego bay\n",
      "Processing Record 29 of Set 21 | arraial do cabo\n",
      "Processing Record 30 of Set 21 | belaya gora\n",
      "Processing Record 31 of Set 21 | tucano\n",
      "Processing Record 32 of Set 21 | ondorhaan\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 21 | tsiroanomandidy\n",
      "Processing Record 34 of Set 21 | vilhena\n",
      "Processing Record 35 of Set 21 | cockburn town\n",
      "Processing Record 36 of Set 21 | biak\n",
      "Processing Record 37 of Set 21 | manacapuru\n",
      "Processing Record 38 of Set 21 | saleaula\n",
      "City not found. Skipping...\n",
      "Processing Record 39 of Set 21 | jinchang\n",
      "Processing Record 40 of Set 21 | shitanjing\n",
      "Processing Record 41 of Set 21 | boyolangu\n",
      "Processing Record 42 of Set 21 | tiksi\n",
      "Processing Record 43 of Set 21 | hazorasp\n",
      "Processing Record 44 of Set 21 | eenhana\n",
      "Processing Record 45 of Set 21 | abu dhabi\n",
      "Processing Record 46 of Set 21 | lincoln\n",
      "Processing Record 47 of Set 21 | verkhnedneprovskiy\n",
      "Processing Record 48 of Set 21 | hermiston\n",
      "Processing Record 49 of Set 21 | paragould\n",
      "Processing Record 50 of Set 21 | kapuskasing\n",
      "Processing Record 1 of Set 22 | ulagan\n",
      "Processing Record 2 of Set 22 | kidal\n",
      "Processing Record 3 of Set 22 | antofagasta\n",
      "Processing Record 4 of Set 22 | saint-pierre\n",
      "Processing Record 5 of Set 22 | san andres\n",
      "Processing Record 6 of Set 22 | mecca\n",
      "Processing Record 7 of Set 22 | labutta\n",
      "City not found. Skipping...\n",
      "Processing Record 8 of Set 22 | marapanim\n",
      "Processing Record 9 of Set 22 | ponta do sol\n",
      "Processing Record 10 of Set 22 | wladyslawowo\n",
      "Processing Record 11 of Set 22 | tashla\n",
      "Processing Record 12 of Set 22 | nouakchott\n",
      "Processing Record 13 of Set 22 | yagodnoye\n",
      "Processing Record 14 of Set 22 | mikuni\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 15 of Set 22 | beyneu\n",
      "Processing Record 16 of Set 22 | gizo\n",
      "Processing Record 17 of Set 22 | lovozero\n",
      "Processing Record 18 of Set 22 | samalaeulu\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 22 | port macquarie\n",
      "Processing Record 20 of Set 22 | namibe\n",
      "Processing Record 21 of Set 22 | lompoc\n",
      "Processing Record 22 of Set 22 | taltal\n",
      "Processing Record 23 of Set 22 | atambua\n",
      "Processing Record 24 of Set 22 | orlik\n",
      "Processing Record 25 of Set 22 | kismayo\n",
      "Processing Record 26 of Set 22 | todos santos\n",
      "Processing Record 27 of Set 22 | anadyr\n",
      "Processing Record 28 of Set 22 | oyem\n",
      "Processing Record 29 of Set 22 | kiunga\n",
      "Processing Record 30 of Set 22 | bereda\n",
      "Processing Record 31 of Set 22 | sunbury\n",
      "Processing Record 32 of Set 22 | nchelenge\n",
      "Processing Record 33 of Set 22 | alexandria\n",
      "Processing Record 34 of Set 22 | bathsheba\n",
      "Processing Record 35 of Set 22 | hay river\n",
      "Processing Record 36 of Set 22 | gladstone\n",
      "Processing Record 37 of Set 22 | cherskiy\n",
      "Processing Record 38 of Set 22 | danane\n",
      "Processing Record 39 of Set 22 | dzhebariki-khaya\n",
      "Processing Record 40 of Set 22 | berlevag\n",
      "Processing Record 41 of Set 22 | tocopilla\n",
      "Processing Record 42 of Set 22 | lalian\n",
      "Processing Record 43 of Set 22 | altamira\n",
      "Processing Record 44 of Set 22 | whitefish\n",
      "Processing Record 45 of Set 22 | camana\n",
      "Processing Record 46 of Set 22 | santa cruz\n",
      "Processing Record 47 of Set 22 | kenai\n",
      "Processing Record 48 of Set 22 | manadhoo\n",
      "Processing Record 49 of Set 22 | ippy\n",
      "Processing Record 50 of Set 22 | yar-sale\n",
      "Processing Record 1 of Set 23 | hinton\n",
      "Processing Record 2 of Set 23 | san ignacio\n",
      "Processing Record 3 of Set 23 | iqaluit\n",
      "Processing Record 4 of Set 23 | bolungarvik\n",
      "City not found. Skipping...\n",
      "Processing Record 5 of Set 23 | fairbanks\n",
      "Processing Record 6 of Set 23 | neyvo-shaytanskiy\n",
      "Processing Record 7 of Set 23 | aleksandrovskiy zavod\n",
      "Processing Record 8 of Set 23 | kavaratti\n",
      "Processing Record 9 of Set 23 | upington\n",
      "Processing Record 10 of Set 23 | general roca\n",
      "Processing Record 11 of Set 23 | kelso\n",
      "Processing Record 12 of Set 23 | peniche\n",
      "Processing Record 13 of Set 23 | haibowan\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 23 | ulaanbaatar\n",
      "Processing Record 15 of Set 23 | kudahuvadhoo\n",
      "Processing Record 16 of Set 23 | raudeberg\n",
      "Processing Record 17 of Set 23 | liwale\n",
      "Processing Record 18 of Set 23 | galgani\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 23 | nalut\n",
      "Processing Record 20 of Set 23 | santa barbara\n",
      "Processing Record 21 of Set 23 | los llanos de aridane\n",
      "Processing Record 22 of Set 23 | vostok\n",
      "Processing Record 23 of Set 23 | lujiang\n",
      "Processing Record 24 of Set 23 | simoes\n",
      "Processing Record 25 of Set 23 | arenapolis\n",
      "Processing Record 26 of Set 23 | tabiauea\n",
      "City not found. Skipping...\n",
      "Processing Record 27 of Set 23 | dzhusaly\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 23 | zhuhai\n",
      "Processing Record 29 of Set 23 | bardiyah\n",
      "Processing Record 30 of Set 23 | marcona\n",
      "City not found. Skipping...\n",
      "Processing Record 31 of Set 23 | kloulklubed\n",
      "Processing Record 32 of Set 23 | oliveira dos brejinhos\n",
      "Processing Record 33 of Set 23 | totness\n",
      "Processing Record 34 of Set 23 | gilbues\n",
      "Processing Record 35 of Set 23 | haines junction\n",
      "Processing Record 36 of Set 23 | nanzhang\n",
      "Processing Record 37 of Set 23 | moron\n",
      "Processing Record 38 of Set 23 | siutu\n",
      "City not found. Skipping...\n",
      "Processing Record 39 of Set 23 | faya\n",
      "Processing Record 40 of Set 23 | christchurch\n",
      "Processing Record 41 of Set 23 | bandarbeyla\n",
      "Processing Record 42 of Set 23 | isla mujeres\n",
      "Processing Record 43 of Set 23 | bilibino\n",
      "Processing Record 44 of Set 23 | rodrigues alves\n",
      "Processing Record 45 of Set 23 | juneau\n",
      "Processing Record 46 of Set 23 | ugoofaaru\n",
      "Processing Record 47 of Set 23 | tessalit\n",
      "Processing Record 48 of Set 23 | sorong\n",
      "Processing Record 49 of Set 23 | kitimat\n",
      "Processing Record 50 of Set 23 | natal\n",
      "Processing Record 1 of Set 24 | hobyo\n",
      "Processing Record 2 of Set 24 | rockhampton\n",
      "Processing Record 3 of Set 24 | souillac\n",
      "Processing Record 4 of Set 24 | riverside\n",
      "Processing Record 5 of Set 24 | pouembout\n",
      "Processing Record 6 of Set 24 | sainte-maxime\n",
      "Processing Record 7 of Set 24 | metro\n",
      "Processing Record 8 of Set 24 | benguela\n",
      "Processing Record 9 of Set 24 | taos\n",
      "Processing Record 10 of Set 24 | mount isa\n",
      "Processing Record 11 of Set 24 | pangnirtung\n",
      "Processing Record 12 of Set 24 | torit\n",
      "Processing Record 13 of Set 24 | daru\n",
      "Processing Record 14 of Set 24 | khani\n",
      "Processing Record 15 of Set 24 | sergiyevsk\n",
      "Processing Record 16 of Set 24 | suntar\n",
      "Processing Record 17 of Set 24 | seymchan\n",
      "Processing Record 18 of Set 24 | thinadhoo\n",
      "Processing Record 19 of Set 24 | salalah\n",
      "Processing Record 20 of Set 24 | tafresh\n",
      "Processing Record 21 of Set 24 | coihaique\n",
      "Processing Record 22 of Set 24 | axim\n",
      "Processing Record 23 of Set 24 | naica\n",
      "Processing Record 24 of Set 24 | sept-iles\n",
      "Processing Record 25 of Set 24 | manicore\n",
      "Processing Record 26 of Set 24 | tidore\n",
      "City not found. Skipping...\n",
      "Processing Record 27 of Set 24 | salina cruz\n",
      "Processing Record 28 of Set 24 | lamar\n",
      "Processing Record 29 of Set 24 | qaqortoq\n",
      "Processing Record 30 of Set 24 | samarinda\n",
      "Processing Record 31 of Set 24 | mankovo-kalitvenskoye\n",
      "City not found. Skipping...\n",
      "Processing Record 32 of Set 24 | dombas\n",
      "Processing Record 33 of Set 24 | alta floresta\n",
      "Processing Record 34 of Set 24 | richards bay\n",
      "Processing Record 35 of Set 24 | batemans bay\n",
      "Processing Record 36 of Set 24 | ust-maya\n",
      "Processing Record 37 of Set 24 | amudat\n",
      "Processing Record 38 of Set 24 | tevaitoa\n",
      "Processing Record 39 of Set 24 | siuna\n",
      "Processing Record 40 of Set 24 | wuwei\n",
      "Processing Record 41 of Set 24 | barcelos\n",
      "Processing Record 42 of Set 24 | acapulco\n",
      "Processing Record 43 of Set 24 | dolzhanskaya\n",
      "Processing Record 44 of Set 24 | keetmanshoop\n",
      "Processing Record 45 of Set 24 | impfondo\n",
      "Processing Record 46 of Set 24 | katobu\n",
      "Processing Record 47 of Set 24 | nouadhibou\n",
      "Processing Record 48 of Set 24 | azimur\n",
      "City not found. Skipping...\n",
      "Processing Record 49 of Set 24 | presidencia roque saenz pena\n",
      "Processing Record 50 of Set 24 | watertown\n",
      "Processing Record 1 of Set 25 | togur\n",
      "Processing Record 2 of Set 25 | luderitz\n",
      "Processing Record 3 of Set 25 | port hedland\n",
      "Processing Record 4 of Set 25 | juquitiba\n",
      "Processing Record 5 of Set 25 | riyadh\n",
      "Processing Record 6 of Set 25 | stokmarknes\n",
      "Processing Record 7 of Set 25 | mozarlandia\n",
      "Processing Record 8 of Set 25 | kanniyakumari\n",
      "Processing Record 9 of Set 25 | gisborne\n",
      "Processing Record 10 of Set 25 | santa rosa\n",
      "Processing Record 11 of Set 25 | kankaanpaa\n",
      "Processing Record 12 of Set 25 | bastia\n",
      "Processing Record 13 of Set 25 | lorengau\n",
      "Processing Record 14 of Set 25 | balad\n",
      "Processing Record 15 of Set 25 | abancay\n",
      "Processing Record 16 of Set 25 | mildura\n",
      "Processing Record 17 of Set 25 | lata\n",
      "Processing Record 18 of Set 25 | vredendal\n",
      "Processing Record 19 of Set 25 | tupelo\n",
      "Processing Record 20 of Set 25 | jujuy\n",
      "City not found. Skipping...\n",
      "Processing Record 21 of Set 25 | ambilobe\n",
      "Processing Record 22 of Set 25 | touros\n",
      "Processing Record 23 of Set 25 | wanaka\n",
      "Processing Record 24 of Set 25 | krasnoselkup\n",
      "Processing Record 25 of Set 25 | adiake\n",
      "Processing Record 26 of Set 25 | salinopolis\n",
      "Processing Record 27 of Set 25 | celestun\n",
      "Processing Record 28 of Set 25 | rancho palos verdes\n",
      "Processing Record 29 of Set 25 | svobodnyy\n",
      "Processing Record 30 of Set 25 | havoysund\n",
      "Processing Record 31 of Set 25 | lethem\n",
      "Processing Record 32 of Set 25 | kandrian\n",
      "Processing Record 33 of Set 25 | hun\n",
      "Processing Record 34 of Set 25 | belance\n",
      "Processing Record 35 of Set 25 | fare\n",
      "Processing Record 36 of Set 25 | serik\n",
      "Processing Record 37 of Set 25 | skibbereen\n",
      "Processing Record 38 of Set 25 | strezhevoy\n",
      "Processing Record 39 of Set 25 | faanui\n",
      "Processing Record 40 of Set 25 | tromso\n",
      "Processing Record 41 of Set 25 | kundiawa\n",
      "Processing Record 42 of Set 25 | gimbi\n",
      "Processing Record 43 of Set 25 | marienburg\n",
      "Processing Record 44 of Set 25 | pitimbu\n",
      "Processing Record 45 of Set 25 | quatre cocos\n",
      "Processing Record 46 of Set 25 | lichuan\n",
      "Processing Record 47 of Set 25 | sabha\n",
      "Processing Record 48 of Set 25 | mehndawal\n",
      "Processing Record 49 of Set 25 | corinto\n",
      "Processing Record 50 of Set 25 | parbhani\n",
      "Processing Record 1 of Set 26 | nelson bay\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 2 of Set 26 | kyra\n",
      "Processing Record 3 of Set 26 | mamallapuram\n",
      "Processing Record 4 of Set 26 | mabaruma\n",
      "Processing Record 5 of Set 26 | nathdwara\n",
      "Processing Record 6 of Set 26 | vardo\n",
      "Processing Record 7 of Set 26 | deputatskiy\n",
      "Processing Record 8 of Set 26 | iralaya\n",
      "Processing Record 9 of Set 26 | sibiti\n",
      "Processing Record 10 of Set 26 | nisia floresta\n",
      "Processing Record 11 of Set 26 | gorontalo\n",
      "Processing Record 12 of Set 26 | jiddah\n",
      "City not found. Skipping...\n",
      "Processing Record 13 of Set 26 | prince rupert\n",
      "Processing Record 14 of Set 26 | teguise\n",
      "Processing Record 15 of Set 26 | voyvozh\n",
      "Processing Record 16 of Set 26 | leshukonskoye\n",
      "Processing Record 17 of Set 26 | initao\n",
      "Processing Record 18 of Set 26 | veinticinco de mayo\n",
      "Processing Record 19 of Set 26 | imelda\n",
      "Processing Record 20 of Set 26 | saint-augustin\n",
      "Processing Record 21 of Set 26 | balaipungut\n",
      "Processing Record 22 of Set 26 | cascais\n",
      "Processing Record 23 of Set 26 | tulagi\n",
      "Processing Record 24 of Set 26 | tabou\n",
      "Processing Record 25 of Set 26 | bireun\n",
      "Processing Record 26 of Set 26 | filingue\n",
      "Processing Record 27 of Set 26 | kirakira\n",
      "Processing Record 28 of Set 26 | rockwall\n",
      "Processing Record 29 of Set 26 | gangotri\n",
      "City not found. Skipping...\n",
      "Processing Record 30 of Set 26 | rio grande\n",
      "Processing Record 31 of Set 26 | inirida\n",
      "Processing Record 32 of Set 26 | pundaguitan\n",
      "Processing Record 33 of Set 26 | pachino\n",
      "Processing Record 34 of Set 26 | balabac\n",
      "Processing Record 35 of Set 26 | egvekinot\n",
      "Processing Record 36 of Set 26 | sorland\n",
      "Processing Record 37 of Set 26 | mogadishu\n",
      "Processing Record 38 of Set 26 | nara\n",
      "Processing Record 39 of Set 26 | midleton\n",
      "Processing Record 40 of Set 26 | itacoatiara\n",
      "Processing Record 41 of Set 26 | broken hill\n",
      "Processing Record 42 of Set 26 | kpalime\n",
      "Processing Record 43 of Set 26 | rock sound\n",
      "Processing Record 44 of Set 26 | aleksandrovsk-sakhalinskiy\n",
      "Processing Record 45 of Set 26 | honningsvag\n",
      "Processing Record 46 of Set 26 | ca mau\n",
      "Processing Record 47 of Set 26 | jining\n",
      "Processing Record 48 of Set 26 | jishu\n",
      "Processing Record 49 of Set 26 | zhangye\n",
      "Processing Record 50 of Set 26 | chicama\n",
      "Processing Record 1 of Set 27 | storforshei\n",
      "Processing Record 2 of Set 27 | satitoa\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 27 | mergui\n",
      "City not found. Skipping...\n",
      "Processing Record 4 of Set 27 | catuday\n",
      "Processing Record 5 of Set 27 | yumen\n",
      "Processing Record 6 of Set 27 | challans\n",
      "Processing Record 7 of Set 27 | warqla\n",
      "City not found. Skipping...\n",
      "Processing Record 8 of Set 27 | san jose de guanipa\n",
      "Processing Record 9 of Set 27 | constitucion\n",
      "Processing Record 10 of Set 27 | sao felix do xingu\n",
      "Processing Record 11 of Set 27 | juegang\n",
      "Processing Record 12 of Set 27 | sinnamary\n",
      "Processing Record 13 of Set 27 | sulangan\n",
      "Processing Record 14 of Set 27 | tabuk\n",
      "Processing Record 15 of Set 27 | betare oya\n",
      "Processing Record 16 of Set 27 | atbasar\n",
      "Processing Record 17 of Set 27 | talesh\n",
      "City not found. Skipping...\n",
      "Processing Record 18 of Set 27 | kontagora\n",
      "Processing Record 19 of Set 27 | maniitsoq\n",
      "Processing Record 20 of Set 27 | panguipulli\n",
      "Processing Record 21 of Set 27 | namtsy\n",
      "Processing Record 22 of Set 27 | aksu\n",
      "Processing Record 23 of Set 27 | prainha\n",
      "Processing Record 24 of Set 27 | wakkanai\n",
      "Processing Record 25 of Set 27 | meadow lake\n",
      "Processing Record 26 of Set 27 | senanga\n",
      "Processing Record 27 of Set 27 | greenville\n",
      "Processing Record 28 of Set 27 | bhanpura\n",
      "Processing Record 29 of Set 27 | tautira\n",
      "Processing Record 30 of Set 27 | hami\n",
      "Processing Record 31 of Set 27 | tigil\n",
      "Processing Record 32 of Set 27 | urdzhar\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 27 | teeli\n",
      "Processing Record 34 of Set 27 | samarai\n",
      "Processing Record 35 of Set 27 | caraballeda\n",
      "Processing Record 36 of Set 27 | olinda\n",
      "Processing Record 37 of Set 27 | lewistown\n",
      "Processing Record 38 of Set 27 | miracatu\n",
      "Processing Record 39 of Set 27 | gravdal\n",
      "Processing Record 40 of Set 27 | matagami\n",
      "Processing Record 41 of Set 27 | pietarsaari\n",
      "Processing Record 42 of Set 27 | putyatino\n",
      "Processing Record 43 of Set 27 | ciudad bolivar\n",
      "Processing Record 44 of Set 27 | ewa beach\n",
      "Processing Record 45 of Set 27 | baruun-urt\n",
      "Processing Record 46 of Set 27 | tarata\n",
      "Processing Record 47 of Set 27 | kayiry\n",
      "Processing Record 48 of Set 27 | moore\n",
      "Processing Record 49 of Set 27 | najran\n",
      "Processing Record 50 of Set 27 | gwadar\n",
      "Processing Record 1 of Set 28 | kamenskoye\n",
      "City not found. Skipping...\n",
      "Processing Record 2 of Set 28 | manyana\n",
      "Processing Record 3 of Set 28 | moshkovo\n",
      "Processing Record 4 of Set 28 | samusu\n",
      "City not found. Skipping...\n",
      "Processing Record 5 of Set 28 | nagar karnul\n",
      "Processing Record 6 of Set 28 | pishva\n",
      "Processing Record 7 of Set 28 | minab\n",
      "Processing Record 8 of Set 28 | iaciara\n",
      "Processing Record 9 of Set 28 | beringovskiy\n",
      "Processing Record 10 of Set 28 | mehamn\n",
      "Processing Record 11 of Set 28 | riyaq\n",
      "City not found. Skipping...\n",
      "Processing Record 12 of Set 28 | wad madani\n",
      "Processing Record 13 of Set 28 | anderson\n",
      "Processing Record 14 of Set 28 | tura\n",
      "Processing Record 15 of Set 28 | diego de almagro\n",
      "Processing Record 16 of Set 28 | belvidere\n",
      "Processing Record 17 of Set 28 | ocampo\n",
      "Processing Record 18 of Set 28 | ariogala\n",
      "Processing Record 19 of Set 28 | ust-tsilma\n",
      "Processing Record 20 of Set 28 | camacha\n",
      "Processing Record 21 of Set 28 | puerto suarez\n",
      "Processing Record 22 of Set 28 | bingol\n",
      "Processing Record 23 of Set 28 | pokrov\n",
      "Processing Record 24 of Set 28 | pabrade\n",
      "Processing Record 25 of Set 28 | willowmore\n",
      "Processing Record 26 of Set 28 | shiloh\n",
      "Processing Record 27 of Set 28 | laem sing\n",
      "Processing Record 28 of Set 28 | empangeni\n",
      "Processing Record 29 of Set 28 | sataua\n",
      "City not found. Skipping...\n",
      "Processing Record 30 of Set 28 | contai\n",
      "Processing Record 31 of Set 28 | pontes e lacerda\n",
      "Processing Record 32 of Set 28 | urusha\n",
      "Processing Record 33 of Set 28 | tshikapa\n",
      "Processing Record 34 of Set 28 | college\n",
      "Processing Record 35 of Set 28 | poum\n",
      "Processing Record 36 of Set 28 | shahe\n",
      "Processing Record 37 of Set 28 | kharp\n",
      "Processing Record 38 of Set 28 | champerico\n",
      "Processing Record 39 of Set 28 | fukue\n",
      "Processing Record 40 of Set 28 | batticaloa\n",
      "Processing Record 41 of Set 28 | kazalinsk\n",
      "City not found. Skipping...\n",
      "Processing Record 42 of Set 28 | tombouctou\n",
      "Processing Record 43 of Set 28 | sistranda\n",
      "Processing Record 44 of Set 28 | mirabad\n",
      "Processing Record 45 of Set 28 | saint anthony\n",
      "Processing Record 46 of Set 28 | kathmandu\n",
      "Processing Record 47 of Set 28 | bud\n",
      "Processing Record 48 of Set 28 | soissons\n",
      "Processing Record 49 of Set 28 | coahuayana\n",
      "Processing Record 50 of Set 28 | nanortalik\n",
      "Processing Record 1 of Set 29 | fairlie\n",
      "Processing Record 2 of Set 29 | kindersley\n",
      "Processing Record 3 of Set 29 | alice springs\n",
      "Processing Record 4 of Set 29 | namatanai\n",
      "Processing Record 5 of Set 29 | bonavista\n",
      "Processing Record 6 of Set 29 | alotau\n",
      "City not found. Skipping...\n",
      "Processing Record 7 of Set 29 | seredka\n",
      "Processing Record 8 of Set 29 | whitehaven\n",
      "Processing Record 9 of Set 29 | aripuana\n",
      "Processing Record 10 of Set 29 | okhotsk\n",
      "Processing Record 11 of Set 29 | jumla\n",
      "Processing Record 12 of Set 29 | we\n",
      "City not found. Skipping...\n",
      "Processing Record 13 of Set 29 | mocambique\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 29 | waingapu\n",
      "Processing Record 15 of Set 29 | cilegon\n",
      "Processing Record 16 of Set 29 | kerrville\n",
      "Processing Record 17 of Set 29 | keuruu\n",
      "Processing Record 18 of Set 29 | bollnas\n",
      "Processing Record 19 of Set 29 | muzhi\n",
      "Processing Record 20 of Set 29 | waycross\n",
      "Processing Record 21 of Set 29 | kurchum\n",
      "Processing Record 22 of Set 29 | mulchen\n",
      "Processing Record 23 of Set 29 | mahadday weyne\n",
      "City not found. Skipping...\n",
      "-----------------------------\n",
      "Data Retrieval Complete      \n",
      "-----------------------------\n"
     ]
    }
   ],
   "source": [
    "# Loop through all the cities in the list.\n",
    "for i, city in enumerate(cities): \n",
    "\n",
    "    # Group cities in sets of 50 for logging purposes.\n",
    "    if (i % 50 == 0 and i >= 50):\n",
    "        set_count += 1\n",
    "        record_count = 1\n",
    "    # Create endpoint URL with each city.\n",
    "    city_url = url + \"&q=\" + city.replace(\" \",\"+\")\n",
    "\n",
    "    # Log the URL, record, and set numbers and the city.\n",
    "    print(f\"Processing Record {record_count} of Set {set_count} | {city}\")\n",
    "    # Add 1 to the record count.\n",
    "    record_count += 1 \n",
    "    # Run an API request for each of the cities.\n",
    "    try:\n",
    "        # Parse the JSON and retrieve data.\n",
    "        city_weather = requests.get(city_url).json()\n",
    "        # Parse out the needed data.\n",
    "        city_lat = city_weather[\"coord\"][\"lat\"]\n",
    "        city_lng = city_weather[\"coord\"][\"lon\"]\n",
    "        city_description = str(city_weather[\"weather\"][0][\"description\"]) \n",
    "        city_max_temp = city_weather[\"main\"][\"temp_max\"] \n",
    "        city_humidity = city_weather[\"main\"][\"humidity\"]\n",
    "        city_clouds = city_weather[\"clouds\"][\"all\"]\n",
    "        city_wind = city_weather[\"wind\"][\"speed\"]\n",
    "        city_country = city_weather[\"sys\"][\"country\"] \n",
    "    \n",
    "        # Convert the date to ISO standard.\n",
    "        city_date = datetime.utcfromtimestamp(city_weather[\"dt\"]).strftime('%Y-%m-%d %H:%M:%S')\n",
    "        # Append the city information into city_data list.\n",
    "        city_data.append({\"City\": city.title(),\n",
    "                          \"Lat\": city_lat,\n",
    "                          \"Lng\": city_lng,\n",
    "                          \"Current Description\": city_description,\n",
    "                          \"Max Temp\": city_max_temp,\n",
    "                          \"Humidity\": city_humidity,\n",
    "                          \"Cloudiness\": city_clouds,\n",
    "                          \"Wind Speed\": city_wind,\n",
    "                          \"Country\": city_country,\n",
    "                          \"Date\": city_date})\n",
    "\n",
    "# If an error is experienced, skip the city.\n",
    "    except:\n",
    "        print(\"City not found. Skipping...\")\n",
    "        pass\n",
    "\n",
    "# Indicate that Data Loading is complete.\n",
    "print(\"-----------------------------\")\n",
    "print(\"Data Retrieval Complete      \")\n",
    "print(\"-----------------------------\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "660"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(city_data) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "      <th>Current Description</th>\n",
       "      <th>Max Temp</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Cloudiness</th>\n",
       "      <th>Wind Speed</th>\n",
       "      <th>Country</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jamestown</td>\n",
       "      <td>42.10</td>\n",
       "      <td>-79.24</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>35.01</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>8.05</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-01-03 15:22:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Portland</td>\n",
       "      <td>45.52</td>\n",
       "      <td>-122.68</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>44.01</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "      <td>9.17</td>\n",
       "      <td>US</td>\n",
       "      <td>2021-01-03 15:26:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hasaki</td>\n",
       "      <td>35.73</td>\n",
       "      <td>140.83</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>32.00</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>1.12</td>\n",
       "      <td>JP</td>\n",
       "      <td>2021-01-03 15:27:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Castro</td>\n",
       "      <td>-24.79</td>\n",
       "      <td>-50.01</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>71.10</td>\n",
       "      <td>76</td>\n",
       "      <td>54</td>\n",
       "      <td>6.33</td>\n",
       "      <td>BR</td>\n",
       "      <td>2021-01-03 15:27:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chimore</td>\n",
       "      <td>-16.98</td>\n",
       "      <td>-65.13</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>90.18</td>\n",
       "      <td>48</td>\n",
       "      <td>66</td>\n",
       "      <td>4.07</td>\n",
       "      <td>BO</td>\n",
       "      <td>2021-01-03 15:27:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tangi</td>\n",
       "      <td>34.30</td>\n",
       "      <td>71.65</td>\n",
       "      <td>haze</td>\n",
       "      <td>55.40</td>\n",
       "      <td>43</td>\n",
       "      <td>75</td>\n",
       "      <td>4.70</td>\n",
       "      <td>PK</td>\n",
       "      <td>2021-01-03 15:27:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Hobart</td>\n",
       "      <td>-42.88</td>\n",
       "      <td>147.33</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>60.80</td>\n",
       "      <td>77</td>\n",
       "      <td>90</td>\n",
       "      <td>6.93</td>\n",
       "      <td>AU</td>\n",
       "      <td>2021-01-03 15:27:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rio Gallegos</td>\n",
       "      <td>-51.62</td>\n",
       "      <td>-69.22</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>59.00</td>\n",
       "      <td>30</td>\n",
       "      <td>75</td>\n",
       "      <td>23.04</td>\n",
       "      <td>AR</td>\n",
       "      <td>2021-01-03 15:27:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Clyde River</td>\n",
       "      <td>70.47</td>\n",
       "      <td>-68.59</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>-27.40</td>\n",
       "      <td>74</td>\n",
       "      <td>1</td>\n",
       "      <td>3.36</td>\n",
       "      <td>CA</td>\n",
       "      <td>2021-01-03 15:27:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Dunedin</td>\n",
       "      <td>-45.87</td>\n",
       "      <td>170.50</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>54.00</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>4.00</td>\n",
       "      <td>NZ</td>\n",
       "      <td>2021-01-03 15:24:37</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           City    Lat     Lng Current Description  Max Temp  Humidity  \\\n",
       "0     Jamestown  42.10  -79.24     overcast clouds     35.01        86   \n",
       "1      Portland  45.52 -122.68       broken clouds     44.01       100   \n",
       "2        Hasaki  35.73  140.83       broken clouds     32.00        55   \n",
       "3        Castro -24.79  -50.01       broken clouds     71.10        76   \n",
       "4       Chimore -16.98  -65.13       broken clouds     90.18        48   \n",
       "5         Tangi  34.30   71.65                haze     55.40        43   \n",
       "6        Hobart -42.88  147.33     overcast clouds     60.80        77   \n",
       "7  Rio Gallegos -51.62  -69.22       broken clouds     59.00        30   \n",
       "8   Clyde River  70.47  -68.59           clear sky    -27.40        74   \n",
       "9       Dunedin -45.87  170.50     overcast clouds     54.00        82   \n",
       "\n",
       "   Cloudiness  Wind Speed Country                 Date  \n",
       "0          90        8.05      US  2021-01-03 15:22:44  \n",
       "1          75        9.17      US  2021-01-03 15:26:41  \n",
       "2          75        1.12      JP  2021-01-03 15:27:01  \n",
       "3          54        6.33      BR  2021-01-03 15:27:01  \n",
       "4          66        4.07      BO  2021-01-03 15:27:01  \n",
       "5          75        4.70      PK  2021-01-03 15:27:01  \n",
       "6          90        6.93      AU  2021-01-03 15:27:02  \n",
       "7          75       23.04      AR  2021-01-03 15:27:02  \n",
       "8           1        3.36      CA  2021-01-03 15:27:02  \n",
       "9          87        4.00      NZ  2021-01-03 15:24:37  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert the array of dictionaries to a Pandas DataFrame.\n",
    "city_data_df = pd.DataFrame(city_data)\n",
    "city_data_df.head(10) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>City</th>\n",
       "      <th>Country</th>\n",
       "      <th>Lat</th>\n",
       "      <th>Lng</th>\n",
       "      <th>Max Temp</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Cloudiness</th>\n",
       "      <th>Wind Speed</th>\n",
       "      <th>Current Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jamestown</td>\n",
       "      <td>US</td>\n",
       "      <td>42.10</td>\n",
       "      <td>-79.24</td>\n",
       "      <td>35.01</td>\n",
       "      <td>86</td>\n",
       "      <td>90</td>\n",
       "      <td>8.05</td>\n",
       "      <td>overcast clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Portland</td>\n",
       "      <td>US</td>\n",
       "      <td>45.52</td>\n",
       "      <td>-122.68</td>\n",
       "      <td>44.01</td>\n",
       "      <td>100</td>\n",
       "      <td>75</td>\n",
       "      <td>9.17</td>\n",
       "      <td>broken clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Hasaki</td>\n",
       "      <td>JP</td>\n",
       "      <td>35.73</td>\n",
       "      <td>140.83</td>\n",
       "      <td>32.00</td>\n",
       "      <td>55</td>\n",
       "      <td>75</td>\n",
       "      <td>1.12</td>\n",
       "      <td>broken clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Castro</td>\n",
       "      <td>BR</td>\n",
       "      <td>-24.79</td>\n",
       "      <td>-50.01</td>\n",
       "      <td>71.10</td>\n",
       "      <td>76</td>\n",
       "      <td>54</td>\n",
       "      <td>6.33</td>\n",
       "      <td>broken clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Chimore</td>\n",
       "      <td>BO</td>\n",
       "      <td>-16.98</td>\n",
       "      <td>-65.13</td>\n",
       "      <td>90.18</td>\n",
       "      <td>48</td>\n",
       "      <td>66</td>\n",
       "      <td>4.07</td>\n",
       "      <td>broken clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tangi</td>\n",
       "      <td>PK</td>\n",
       "      <td>34.30</td>\n",
       "      <td>71.65</td>\n",
       "      <td>55.40</td>\n",
       "      <td>43</td>\n",
       "      <td>75</td>\n",
       "      <td>4.70</td>\n",
       "      <td>haze</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Hobart</td>\n",
       "      <td>AU</td>\n",
       "      <td>-42.88</td>\n",
       "      <td>147.33</td>\n",
       "      <td>60.80</td>\n",
       "      <td>77</td>\n",
       "      <td>90</td>\n",
       "      <td>6.93</td>\n",
       "      <td>overcast clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Rio Gallegos</td>\n",
       "      <td>AR</td>\n",
       "      <td>-51.62</td>\n",
       "      <td>-69.22</td>\n",
       "      <td>59.00</td>\n",
       "      <td>30</td>\n",
       "      <td>75</td>\n",
       "      <td>23.04</td>\n",
       "      <td>broken clouds</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Clyde River</td>\n",
       "      <td>CA</td>\n",
       "      <td>70.47</td>\n",
       "      <td>-68.59</td>\n",
       "      <td>-27.40</td>\n",
       "      <td>74</td>\n",
       "      <td>1</td>\n",
       "      <td>3.36</td>\n",
       "      <td>clear sky</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Dunedin</td>\n",
       "      <td>NZ</td>\n",
       "      <td>-45.87</td>\n",
       "      <td>170.50</td>\n",
       "      <td>54.00</td>\n",
       "      <td>82</td>\n",
       "      <td>87</td>\n",
       "      <td>4.00</td>\n",
       "      <td>overcast clouds</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           City Country    Lat     Lng  Max Temp  Humidity  Cloudiness  \\\n",
       "0     Jamestown      US  42.10  -79.24     35.01        86          90   \n",
       "1      Portland      US  45.52 -122.68     44.01       100          75   \n",
       "2        Hasaki      JP  35.73  140.83     32.00        55          75   \n",
       "3        Castro      BR -24.79  -50.01     71.10        76          54   \n",
       "4       Chimore      BO -16.98  -65.13     90.18        48          66   \n",
       "5         Tangi      PK  34.30   71.65     55.40        43          75   \n",
       "6        Hobart      AU -42.88  147.33     60.80        77          90   \n",
       "7  Rio Gallegos      AR -51.62  -69.22     59.00        30          75   \n",
       "8   Clyde River      CA  70.47  -68.59    -27.40        74           1   \n",
       "9       Dunedin      NZ -45.87  170.50     54.00        82          87   \n",
       "\n",
       "   Wind Speed Current Description  \n",
       "0        8.05     overcast clouds  \n",
       "1        9.17       broken clouds  \n",
       "2        1.12       broken clouds  \n",
       "3        6.33       broken clouds  \n",
       "4        4.07       broken clouds  \n",
       "5        4.70                haze  \n",
       "6        6.93     overcast clouds  \n",
       "7       23.04       broken clouds  \n",
       "8        3.36           clear sky  \n",
       "9        4.00     overcast clouds  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_data_reordered = ['City', 'Country', 'Lat', 'Lng', 'Max Temp', 'Humidity', 'Cloudiness', 'Wind Speed', 'Current Description']\n",
    "city_data_df = city_data_df[city_data_reordered] \n",
    "city_data_df.head(10)   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "city_data_df.to_csv('WeatherPy_database.csv') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}