Weather_Database.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import the dependencies\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "# Use the citipy module to determine city based on latitude and longitude\n",
    "from citipy import citipy\n",
    "\n",
    "# Import the requests library\n",
    "import requests\n",
    "\n",
    "# Import the API key\n",
    "from config import weather_api_key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<zip at 0x20ca965d508>"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Creating a set of random latitude and longitude combinations\n",
    "lats = np.random.uniform(low=-90.000, high=90.000, size=1500)\n",
    "lngs = np.random.uniform(low=-180.000, high=180.000, size=1500)\n",
    "lat_lngs = zip(lats, lngs)\n",
    "lat_lngs "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creating a list with the random latitudes and longitudes\n",
    "coordinates = list(lat_lngs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "598"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Creating a list to hold the nearest cities\n",
    "cities = []\n",
    "\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)\n",
    "\n",
    "# Print the city count to confirm sufficient count\n",
    "len(cities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Perform API call with Open Weather Map\n",
    "url = \"http://api.openweathermap.org/data/2.5/weather?units=Imperial&APPID=\" + weather_api_key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://api.openweathermap.org/data/2.5/weather?units=Imperial&APPID=341aca6b382978ac3c45b49bd2416709&q=Toronto\n"
     ]
    }
   ],
   "source": [
    "# Create an endpoint URL for a city that might have rain to figure out how to parse the JSON for\n",
    "# rain in the last hour\n",
    "city_url = url + \"&q=\" + \"Toronto\"\n",
    "print(city_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "http://api.openweathermap.org/data/2.5/weather?units=Imperial&APPID=341aca6b382978ac3c45b49bd2416709&q=Alert\n"
     ]
    }
   ],
   "source": [
    "# Create an endpoint URL for a city that might have snow to figure out how to parse the JSON for\n",
    "# rain in the last hour\n",
    "city_url = url + \"&q=\" + \"Alert\"\n",
    "print(city_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Beginning Data Retrieval     \n",
      "-----------------------------\n",
      "Processing Record 1 of Set 1 | busselton\n",
      "Processing Record 2 of Set 1 | punta arenas\n",
      "Processing Record 3 of Set 1 | esperance\n",
      "Processing Record 4 of Set 1 | bluff\n",
      "Processing Record 5 of Set 1 | mar del plata\n",
      "Processing Record 6 of Set 1 | tiarei\n",
      "Processing Record 7 of Set 1 | sept-iles\n",
      "Processing Record 8 of Set 1 | ulladulla\n",
      "Processing Record 9 of Set 1 | mys shmidta\n",
      "City not found. Skipping...\n",
      "Processing Record 10 of Set 1 | ponta do sol\n",
      "Processing Record 11 of Set 1 | wlodawa\n",
      "Processing Record 12 of Set 1 | nanortalik\n",
      "Processing Record 13 of Set 1 | mataura\n",
      "Processing Record 14 of Set 1 | hermanus\n",
      "Processing Record 15 of Set 1 | qaanaaq\n",
      "Processing Record 16 of Set 1 | ampanihy\n",
      "Processing Record 17 of Set 1 | vestmannaeyjar\n",
      "Processing Record 18 of Set 1 | cape town\n",
      "Processing Record 19 of Set 1 | saint george\n",
      "Processing Record 20 of Set 1 | chapais\n",
      "Processing Record 21 of Set 1 | saint-pierre\n",
      "Processing Record 22 of Set 1 | tuktoyaktuk\n",
      "Processing Record 23 of Set 1 | georgetown\n",
      "Processing Record 24 of Set 1 | nizhneyansk\n",
      "City not found. Skipping...\n",
      "Processing Record 25 of Set 1 | chachapoyas\n",
      "Processing Record 26 of Set 1 | hobart\n",
      "Processing Record 27 of Set 1 | olavarria\n",
      "Processing Record 28 of Set 1 | thompson\n",
      "Processing Record 29 of Set 1 | suntar\n",
      "Processing Record 30 of Set 1 | geraldton\n",
      "Processing Record 31 of Set 1 | hihifo\n",
      "City not found. Skipping...\n",
      "Processing Record 32 of Set 1 | boa vista\n",
      "Processing Record 33 of Set 1 | albany\n",
      "Processing Record 34 of Set 1 | amderma\n",
      "City not found. Skipping...\n",
      "Processing Record 35 of Set 1 | klyuchi\n",
      "Processing Record 36 of Set 1 | kruisfontein\n",
      "Processing Record 37 of Set 1 | rikitea\n",
      "Processing Record 38 of Set 1 | dikson\n",
      "Processing Record 39 of Set 1 | kaitangata\n",
      "Processing Record 40 of Set 1 | choma\n",
      "Processing Record 41 of Set 1 | jiuquan\n",
      "Processing Record 42 of Set 1 | karakendzha\n",
      "City not found. Skipping...\n",
      "Processing Record 43 of Set 1 | tumannyy\n",
      "City not found. Skipping...\n",
      "Processing Record 44 of Set 1 | vaini\n",
      "Processing Record 45 of Set 1 | saint anthony\n",
      "Processing Record 46 of Set 1 | taolanaro\n",
      "City not found. Skipping...\n",
      "Processing Record 47 of Set 1 | canutama\n",
      "Processing Record 48 of Set 1 | hambantota\n",
      "Processing Record 49 of Set 1 | lagoa\n",
      "Processing Record 50 of Set 1 | puerto escondido\n",
      "Processing Record 1 of Set 2 | ushuaia\n",
      "Processing Record 2 of Set 2 | belushya guba\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 2 | faanui\n",
      "Processing Record 4 of Set 2 | lasa\n",
      "Processing Record 5 of Set 2 | jamestown\n",
      "Processing Record 6 of Set 2 | pangnirtung\n",
      "Processing Record 7 of Set 2 | puerto ayora\n",
      "Processing Record 8 of Set 2 | pevek\n",
      "Processing Record 9 of Set 2 | samusu\n",
      "City not found. Skipping...\n",
      "Processing Record 10 of Set 2 | longyearbyen\n",
      "Processing Record 11 of Set 2 | black diamond\n",
      "Processing Record 12 of Set 2 | airai\n",
      "Processing Record 13 of Set 2 | sola\n",
      "Processing Record 14 of Set 2 | novikovo\n",
      "Processing Record 15 of Set 2 | tuatapere\n",
      "Processing Record 16 of Set 2 | haapiti\n",
      "Processing Record 17 of Set 2 | guerrero negro\n",
      "Processing Record 18 of Set 2 | langham\n",
      "Processing Record 19 of Set 2 | nikolskoye\n",
      "Processing Record 20 of Set 2 | guantanamo\n",
      "Processing Record 21 of Set 2 | pundaguitan\n",
      "Processing Record 22 of Set 2 | ilulissat\n",
      "Processing Record 23 of Set 2 | malwan\n",
      "City not found. Skipping...\n",
      "Processing Record 24 of Set 2 | kerteh\n",
      "City not found. Skipping...\n",
      "Processing Record 25 of Set 2 | gorontalo\n",
      "Processing Record 26 of Set 2 | charters towers\n",
      "Processing Record 27 of Set 2 | ixtapa\n",
      "Processing Record 28 of Set 2 | coahuayana\n",
      "Processing Record 29 of Set 2 | butaritari\n",
      "Processing Record 30 of Set 2 | kutum\n",
      "Processing Record 31 of Set 2 | port alfred\n",
      "Processing Record 32 of Set 2 | port hardy\n",
      "Processing Record 33 of Set 2 | bengkulu\n",
      "Processing Record 34 of Set 2 | new norfolk\n",
      "Processing Record 35 of Set 2 | illoqqortoormiut\n",
      "City not found. Skipping...\n",
      "Processing Record 36 of Set 2 | asosa\n",
      "Processing Record 37 of Set 2 | kazbegi\n",
      "City not found. Skipping...\n",
      "Processing Record 38 of Set 2 | lavrentiya\n",
      "Processing Record 39 of Set 2 | rabo de peixe\n",
      "Processing Record 40 of Set 2 | hilo\n",
      "Processing Record 41 of Set 2 | grand river south east\n",
      "City not found. Skipping...\n",
      "Processing Record 42 of Set 2 | provideniya\n",
      "Processing Record 43 of Set 2 | asau\n",
      "Processing Record 44 of Set 2 | avarua\n",
      "Processing Record 45 of Set 2 | atuona\n",
      "Processing Record 46 of Set 2 | muros\n",
      "Processing Record 47 of Set 2 | karratha\n",
      "Processing Record 48 of Set 2 | souillac\n",
      "Processing Record 49 of Set 2 | bathsheba\n",
      "Processing Record 50 of Set 2 | kikwit\n",
      "Processing Record 1 of Set 3 | vermilion\n",
      "Processing Record 2 of Set 3 | bull savanna\n",
      "Processing Record 3 of Set 3 | eyrarbakki\n",
      "Processing Record 4 of Set 3 | desnogorsk\n",
      "Processing Record 5 of Set 3 | ust-nera\n",
      "Processing Record 6 of Set 3 | itoman\n",
      "Processing Record 7 of Set 3 | kemise\n",
      "Processing Record 8 of Set 3 | tasiilaq\n",
      "Processing Record 9 of Set 3 | sturgeon falls\n",
      "Processing Record 10 of Set 3 | kargasok\n",
      "Processing Record 11 of Set 3 | marawi\n",
      "Processing Record 12 of Set 3 | castro\n",
      "Processing Record 13 of Set 3 | meyungs\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 3 | port elizabeth\n",
      "Processing Record 15 of Set 3 | arlit\n",
      "Processing Record 16 of Set 3 | chokurdakh\n",
      "Processing Record 17 of Set 3 | taoudenni\n",
      "Processing Record 18 of Set 3 | the valley\n",
      "Processing Record 19 of Set 3 | vardo\n",
      "Processing Record 20 of Set 3 | kapaa\n",
      "Processing Record 21 of Set 3 | saint-ambroise\n",
      "Processing Record 22 of Set 3 | chirongui\n",
      "Processing Record 23 of Set 3 | vanimo\n",
      "Processing Record 24 of Set 3 | ruwi\n",
      "Processing Record 25 of Set 3 | nueve de julio\n",
      "Processing Record 26 of Set 3 | barrow\n",
      "Processing Record 27 of Set 3 | pochutla\n",
      "Processing Record 28 of Set 3 | haibowan\n",
      "City not found. Skipping...\n",
      "Processing Record 29 of Set 3 | borujan\n",
      "City not found. Skipping...\n",
      "Processing Record 30 of Set 3 | carnarvon\n",
      "Processing Record 31 of Set 3 | igarka\n",
      "Processing Record 32 of Set 3 | eureka\n",
      "Processing Record 33 of Set 3 | saldanha\n",
      "Processing Record 34 of Set 3 | khatanga\n",
      "Processing Record 35 of Set 3 | wasilla\n",
      "Processing Record 36 of Set 3 | methoni\n",
      "Processing Record 37 of Set 3 | yellowknife\n",
      "Processing Record 38 of Set 3 | bac lieu\n",
      "Processing Record 39 of Set 3 | attawapiskat\n",
      "City not found. Skipping...\n",
      "Processing Record 40 of Set 3 | kalmunai\n",
      "Processing Record 41 of Set 3 | pacific grove\n",
      "Processing Record 42 of Set 3 | kavaratti\n",
      "Processing Record 43 of Set 3 | lebu\n",
      "Processing Record 44 of Set 3 | nakamura\n",
      "Processing Record 45 of Set 3 | micheweni\n",
      "Processing Record 46 of Set 3 | panaba\n",
      "Processing Record 47 of Set 3 | cherskiy\n",
      "Processing Record 48 of Set 3 | vao\n",
      "Processing Record 49 of Set 3 | egvekinot\n",
      "Processing Record 50 of Set 3 | ribeira grande\n",
      "Processing Record 1 of Set 4 | torbay\n",
      "Processing Record 2 of Set 4 | rio gallegos\n",
      "Processing Record 3 of Set 4 | san carlos de bariloche\n",
      "Processing Record 4 of Set 4 | tiksi\n",
      "Processing Record 5 of Set 4 | bredasdorp\n",
      "Processing Record 6 of Set 4 | odweyne\n",
      "Processing Record 7 of Set 4 | reshetylivka\n",
      "Processing Record 8 of Set 4 | grindavik\n",
      "Processing Record 9 of Set 4 | nome\n",
      "Processing Record 10 of Set 4 | kolvereid\n",
      "Processing Record 11 of Set 4 | udayagiri\n",
      "Processing Record 12 of Set 4 | malakal\n",
      "Processing Record 13 of Set 4 | bahia blanca\n",
      "Processing Record 14 of Set 4 | xining\n",
      "Processing Record 15 of Set 4 | namibe\n",
      "Processing Record 16 of Set 4 | iskateley\n",
      "Processing Record 17 of Set 4 | bilibino\n",
      "Processing Record 18 of Set 4 | vitim\n",
      "Processing Record 19 of Set 4 | metro\n",
      "Processing Record 20 of Set 4 | vernon\n",
      "Processing Record 21 of Set 4 | severo-kurilsk\n",
      "Processing Record 22 of Set 4 | sentyabrskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 23 of Set 4 | olafsvik\n",
      "Processing Record 24 of Set 4 | saint-philippe\n",
      "Processing Record 25 of Set 4 | gat\n",
      "Processing Record 26 of Set 4 | la serena\n",
      "Processing Record 27 of Set 4 | tsihombe\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 4 | jalu\n",
      "Processing Record 29 of Set 4 | east london\n",
      "Processing Record 30 of Set 4 | vaitupu\n",
      "City not found. Skipping...\n",
      "Processing Record 31 of Set 4 | eagle pass\n",
      "Processing Record 32 of Set 4 | iqaluit\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 33 of Set 4 | port lincoln\n",
      "Processing Record 34 of Set 4 | mahebourg\n",
      "Processing Record 35 of Set 4 | arraial do cabo\n",
      "Processing Record 36 of Set 4 | port moresby\n",
      "Processing Record 37 of Set 4 | terra nova\n",
      "Processing Record 38 of Set 4 | littleton\n",
      "Processing Record 39 of Set 4 | fort-de-france\n",
      "Processing Record 40 of Set 4 | upernavik\n",
      "Processing Record 41 of Set 4 | hithadhoo\n",
      "Processing Record 42 of Set 4 | saskylakh\n",
      "Processing Record 43 of Set 4 | coquimbo\n",
      "Processing Record 44 of Set 4 | necochea\n",
      "Processing Record 45 of Set 4 | samarai\n",
      "Processing Record 46 of Set 4 | qostanay\n",
      "Processing Record 47 of Set 4 | leningradskiy\n",
      "Processing Record 48 of Set 4 | okha\n",
      "Processing Record 49 of Set 4 | fort nelson\n",
      "Processing Record 50 of Set 4 | champerico\n",
      "Processing Record 1 of Set 5 | ekibastuz\n",
      "Processing Record 2 of Set 5 | constitucion\n",
      "Processing Record 3 of Set 5 | manacapuru\n",
      "Processing Record 4 of Set 5 | salinopolis\n",
      "Processing Record 5 of Set 5 | lages\n",
      "Processing Record 6 of Set 5 | husavik\n",
      "Processing Record 7 of Set 5 | nepomuceno\n",
      "Processing Record 8 of Set 5 | road town\n",
      "Processing Record 9 of Set 5 | phan thiet\n",
      "Processing Record 10 of Set 5 | itupiranga\n",
      "Processing Record 11 of Set 5 | harnai\n",
      "Processing Record 12 of Set 5 | rawson\n",
      "Processing Record 13 of Set 5 | ancud\n",
      "Processing Record 14 of Set 5 | binga\n",
      "Processing Record 15 of Set 5 | norman wells\n",
      "Processing Record 16 of Set 5 | qaqortoq\n",
      "Processing Record 17 of Set 5 | quatre cocos\n",
      "Processing Record 18 of Set 5 | brigantine\n",
      "Processing Record 19 of Set 5 | cotia\n",
      "Processing Record 20 of Set 5 | tsiroanomandidy\n",
      "Processing Record 21 of Set 5 | half moon bay\n",
      "Processing Record 22 of Set 5 | erzin\n",
      "Processing Record 23 of Set 5 | mosquera\n",
      "Processing Record 24 of Set 5 | springfield\n",
      "Processing Record 25 of Set 5 | tyup\n",
      "Processing Record 26 of Set 5 | flinders\n",
      "Processing Record 27 of Set 5 | alyangula\n",
      "Processing Record 28 of Set 5 | wamba\n",
      "Processing Record 29 of Set 5 | christchurch\n",
      "Processing Record 30 of Set 5 | tabialan\n",
      "City not found. Skipping...\n",
      "Processing Record 31 of Set 5 | san patricio\n",
      "Processing Record 32 of Set 5 | freetown\n",
      "Processing Record 33 of Set 5 | sur\n",
      "Processing Record 34 of Set 5 | margate\n",
      "Processing Record 35 of Set 5 | katsuura\n",
      "Processing Record 36 of Set 5 | wynyard\n",
      "Processing Record 37 of Set 5 | manggar\n",
      "Processing Record 38 of Set 5 | mnogovershinnyy\n",
      "Processing Record 39 of Set 5 | korla\n",
      "Processing Record 40 of Set 5 | ketchikan\n",
      "Processing Record 41 of Set 5 | miyazu\n",
      "Processing Record 42 of Set 5 | na wa\n",
      "Processing Record 43 of Set 5 | oyama\n",
      "Processing Record 44 of Set 5 | aranos\n",
      "Processing Record 45 of Set 5 | san cristobal\n",
      "Processing Record 46 of Set 5 | cape coast\n",
      "Processing Record 47 of Set 5 | isangel\n",
      "Processing Record 48 of Set 5 | tevaitoa\n",
      "Processing Record 49 of Set 5 | lake cowichan\n",
      "Processing Record 50 of Set 5 | belousovka\n",
      "Processing Record 1 of Set 6 | kapit\n",
      "Processing Record 2 of Set 6 | satitoa\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 6 | srednekolymsk\n",
      "Processing Record 4 of Set 6 | cidreira\n",
      "Processing Record 5 of Set 6 | cruden bay\n",
      "City not found. Skipping...\n",
      "Processing Record 6 of Set 6 | port macquarie\n",
      "Processing Record 7 of Set 6 | bethel\n",
      "Processing Record 8 of Set 6 | madison\n",
      "Processing Record 9 of Set 6 | agara\n",
      "Processing Record 10 of Set 6 | kedrovyy\n",
      "Processing Record 11 of Set 6 | aden\n",
      "Processing Record 12 of Set 6 | college\n",
      "Processing Record 13 of Set 6 | clemson\n",
      "Processing Record 14 of Set 6 | mendahara\n",
      "City not found. Skipping...\n",
      "Processing Record 15 of Set 6 | kulhudhuffushi\n",
      "Processing Record 16 of Set 6 | kamaishi\n",
      "Processing Record 17 of Set 6 | padang\n",
      "Processing Record 18 of Set 6 | altoona\n",
      "Processing Record 19 of Set 6 | tacuarembo\n",
      "Processing Record 20 of Set 6 | singleton\n",
      "Processing Record 21 of Set 6 | laibin\n",
      "Processing Record 22 of Set 6 | camopi\n",
      "Processing Record 23 of Set 6 | codrington\n",
      "Processing Record 24 of Set 6 | lazaro cardenas\n",
      "Processing Record 25 of Set 6 | hamilton\n",
      "Processing Record 26 of Set 6 | zhigansk\n",
      "Processing Record 27 of Set 6 | luang prabang\n",
      "Processing Record 28 of Set 6 | bay roberts\n",
      "Processing Record 29 of Set 6 | ostrovnoy\n",
      "Processing Record 30 of Set 6 | mount isa\n",
      "Processing Record 31 of Set 6 | kichmengskiy gorodok\n",
      "Processing Record 32 of Set 6 | nueva loja\n",
      "Processing Record 33 of Set 6 | atasu\n",
      "Processing Record 34 of Set 6 | magelang\n",
      "Processing Record 35 of Set 6 | komsomolskiy\n",
      "Processing Record 36 of Set 6 | azimur\n",
      "City not found. Skipping...\n",
      "Processing Record 37 of Set 6 | sankheda\n",
      "Processing Record 38 of Set 6 | bend\n",
      "Processing Record 39 of Set 6 | victoria\n",
      "Processing Record 40 of Set 6 | nova olinda do norte\n",
      "Processing Record 41 of Set 6 | batagay-alyta\n",
      "Processing Record 42 of Set 6 | waddan\n",
      "Processing Record 43 of Set 6 | skalistyy\n",
      "City not found. Skipping...\n",
      "Processing Record 44 of Set 6 | baykit\n",
      "Processing Record 45 of Set 6 | ahuimanu\n",
      "Processing Record 46 of Set 6 | mingguang\n",
      "Processing Record 47 of Set 6 | russell\n",
      "Processing Record 48 of Set 6 | barentsburg\n",
      "City not found. Skipping...\n",
      "Processing Record 49 of Set 6 | krasnoarmeysk\n",
      "Processing Record 50 of Set 6 | tessalit\n",
      "Processing Record 1 of Set 7 | tazovskiy\n",
      "Processing Record 2 of Set 7 | daru\n",
      "Processing Record 3 of Set 7 | lososina\n",
      "Processing Record 4 of Set 7 | beroroha\n",
      "Processing Record 5 of Set 7 | pangody\n",
      "Processing Record 6 of Set 7 | cockburn town\n",
      "Processing Record 7 of Set 7 | tomatlan\n",
      "Processing Record 8 of Set 7 | pauini\n",
      "Processing Record 9 of Set 7 | cayenne\n",
      "Processing Record 10 of Set 7 | prado\n",
      "Processing Record 11 of Set 7 | ossora\n",
      "Processing Record 12 of Set 7 | alofi\n",
      "Processing Record 13 of Set 7 | mopti\n",
      "Processing Record 14 of Set 7 | traverse city\n",
      "Processing Record 15 of Set 7 | lolua\n",
      "City not found. Skipping...\n",
      "Processing Record 16 of Set 7 | cockburn harbour\n",
      "City not found. Skipping...\n",
      "Processing Record 17 of Set 7 | yazd\n",
      "Processing Record 18 of Set 7 | ucluelet\n",
      "Processing Record 19 of Set 7 | leua\n",
      "Processing Record 20 of Set 7 | moindou\n",
      "Processing Record 21 of Set 7 | vanino\n",
      "Processing Record 22 of Set 7 | cap-aux-meules\n",
      "Processing Record 23 of Set 7 | touros\n",
      "Processing Record 24 of Set 7 | westport\n",
      "Processing Record 25 of Set 7 | roald\n",
      "Processing Record 26 of Set 7 | luderitz\n",
      "Processing Record 27 of Set 7 | terralba\n",
      "Processing Record 28 of Set 7 | asilah\n",
      "Processing Record 29 of Set 7 | ormara\n",
      "Processing Record 30 of Set 7 | ryotsu\n",
      "Processing Record 31 of Set 7 | satka\n",
      "Processing Record 32 of Set 7 | san rafael del sur\n",
      "Processing Record 33 of Set 7 | santa rosa\n",
      "Processing Record 34 of Set 7 | salalah\n",
      "Processing Record 35 of Set 7 | hualmay\n",
      "Processing Record 36 of Set 7 | port hedland\n",
      "Processing Record 37 of Set 7 | shelburne\n",
      "Processing Record 38 of Set 7 | kefamenanu\n",
      "Processing Record 39 of Set 7 | bambous virieux\n",
      "Processing Record 40 of Set 7 | kahului\n",
      "Processing Record 41 of Set 7 | abnub\n",
      "Processing Record 42 of Set 7 | awjilah\n",
      "Processing Record 43 of Set 7 | tommot\n",
      "Processing Record 44 of Set 7 | zadar\n",
      "Processing Record 45 of Set 7 | waingapu\n",
      "Processing Record 46 of Set 7 | roebourne\n",
      "Processing Record 47 of Set 7 | waw\n",
      "Processing Record 48 of Set 7 | jos\n",
      "Processing Record 49 of Set 7 | aguimes\n",
      "Processing Record 50 of Set 7 | codajas\n",
      "Processing Record 1 of Set 8 | valparaiso\n",
      "Processing Record 2 of Set 8 | la peca\n",
      "Processing Record 3 of Set 8 | alice springs\n",
      "Processing Record 4 of Set 8 | kamenskoye\n",
      "City not found. Skipping...\n",
      "Processing Record 5 of Set 8 | halalo\n",
      "City not found. Skipping...\n",
      "Processing Record 6 of Set 8 | chuy\n",
      "Processing Record 7 of Set 8 | tupaciguara\n",
      "Processing Record 8 of Set 8 | adzope\n",
      "Processing Record 9 of Set 8 | sao filipe\n",
      "Processing Record 10 of Set 8 | lillooet\n",
      "Processing Record 11 of Set 8 | indi\n",
      "Processing Record 12 of Set 8 | rura\n",
      "Processing Record 13 of Set 8 | kuruman\n",
      "Processing Record 14 of Set 8 | fortuna\n",
      "Processing Record 15 of Set 8 | sitka\n",
      "Processing Record 16 of Set 8 | balkanabat\n",
      "Processing Record 17 of Set 8 | flin flon\n",
      "Processing Record 18 of Set 8 | ban nahin\n",
      "Processing Record 19 of Set 8 | pisco\n",
      "Processing Record 20 of Set 8 | kampot\n",
      "Processing Record 21 of Set 8 | lodja\n",
      "Processing Record 22 of Set 8 | bontang\n",
      "Processing Record 23 of Set 8 | hasaki\n",
      "Processing Record 24 of Set 8 | lima\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 25 of Set 8 | tezu\n",
      "Processing Record 26 of Set 8 | andapa\n",
      "Processing Record 27 of Set 8 | umm lajj\n",
      "Processing Record 28 of Set 8 | deputatskiy\n",
      "Processing Record 29 of Set 8 | askarovo\n",
      "Processing Record 30 of Set 8 | kidal\n",
      "Processing Record 31 of Set 8 | severomuysk\n",
      "Processing Record 32 of Set 8 | ballina\n",
      "Processing Record 33 of Set 8 | susehri\n",
      "Processing Record 34 of Set 8 | berlevag\n",
      "Processing Record 35 of Set 8 | angoche\n",
      "Processing Record 36 of Set 8 | tahta\n",
      "Processing Record 37 of Set 8 | senanga\n",
      "Processing Record 38 of Set 8 | broome\n",
      "Processing Record 39 of Set 8 | oktyabrskoye\n",
      "Processing Record 40 of Set 8 | seoul\n",
      "Processing Record 41 of Set 8 | talara\n",
      "Processing Record 42 of Set 8 | gimli\n",
      "Processing Record 43 of Set 8 | niamey\n",
      "Processing Record 44 of Set 8 | huitzo\n",
      "Processing Record 45 of Set 8 | dunedin\n",
      "Processing Record 46 of Set 8 | varzea da palma\n",
      "Processing Record 47 of Set 8 | mrirt\n",
      "City not found. Skipping...\n",
      "Processing Record 48 of Set 8 | shimoda\n",
      "Processing Record 49 of Set 8 | aflu\n",
      "City not found. Skipping...\n",
      "Processing Record 50 of Set 8 | moose factory\n",
      "Processing Record 1 of Set 9 | sambava\n",
      "Processing Record 2 of Set 9 | temaraia\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 9 | aketi\n",
      "Processing Record 4 of Set 9 | kamina\n",
      "Processing Record 5 of Set 9 | changji\n",
      "Processing Record 6 of Set 9 | hay river\n",
      "Processing Record 7 of Set 9 | kontagora\n",
      "Processing Record 8 of Set 9 | florida\n",
      "Processing Record 9 of Set 9 | kaminskiy\n",
      "Processing Record 10 of Set 9 | zemio\n",
      "Processing Record 11 of Set 9 | jieshi\n",
      "Processing Record 12 of Set 9 | wewak\n",
      "Processing Record 13 of Set 9 | walvis bay\n",
      "Processing Record 14 of Set 9 | kununurra\n",
      "Processing Record 15 of Set 9 | clyde river\n",
      "Processing Record 16 of Set 9 | zolotyy potik\n",
      "Processing Record 17 of Set 9 | manta\n",
      "Processing Record 18 of Set 9 | bambanglipuro\n",
      "Processing Record 19 of Set 9 | aksu\n",
      "Processing Record 20 of Set 9 | ksenyevka\n",
      "City not found. Skipping...\n",
      "Processing Record 21 of Set 9 | yerbogachen\n",
      "Processing Record 22 of Set 9 | kodiak\n",
      "Processing Record 23 of Set 9 | salamanca\n",
      "Processing Record 24 of Set 9 | cervo\n",
      "Processing Record 25 of Set 9 | kingman\n",
      "Processing Record 26 of Set 9 | louisbourg\n",
      "City not found. Skipping...\n",
      "Processing Record 27 of Set 9 | portland\n",
      "Processing Record 28 of Set 9 | tocopilla\n",
      "Processing Record 29 of Set 9 | zavoi\n",
      "Processing Record 30 of Set 9 | puerto quijarro\n",
      "Processing Record 31 of Set 9 | washington\n",
      "Processing Record 32 of Set 9 | ilam\n",
      "Processing Record 33 of Set 9 | palabuhanratu\n",
      "City not found. Skipping...\n",
      "Processing Record 34 of Set 9 | pangkalanbuun\n",
      "Processing Record 35 of Set 9 | fort wellington\n",
      "Processing Record 36 of Set 9 | alta floresta\n",
      "Processing Record 37 of Set 9 | pemangkat\n",
      "Processing Record 38 of Set 9 | baoning\n",
      "Processing Record 39 of Set 9 | platteville\n",
      "Processing Record 40 of Set 9 | knysna\n",
      "Processing Record 41 of Set 9 | naze\n",
      "Processing Record 42 of Set 9 | umm durman\n",
      "City not found. Skipping...\n",
      "Processing Record 43 of Set 9 | sande\n",
      "Processing Record 44 of Set 9 | acapulco\n",
      "Processing Record 45 of Set 9 | howard springs\n",
      "Processing Record 46 of Set 9 | comodoro rivadavia\n",
      "Processing Record 47 of Set 9 | santa vitoria do palmar\n",
      "Processing Record 48 of Set 9 | omboue\n",
      "Processing Record 49 of Set 9 | chicama\n",
      "Processing Record 50 of Set 9 | meulaboh\n",
      "Processing Record 1 of Set 10 | mandera\n",
      "Processing Record 2 of Set 10 | schoneiche\n",
      "Processing Record 3 of Set 10 | henties bay\n",
      "Processing Record 4 of Set 10 | pawayan\n",
      "Processing Record 5 of Set 10 | fuerte olimpo\n",
      "Processing Record 6 of Set 10 | ambur\n",
      "Processing Record 7 of Set 10 | menongue\n",
      "Processing Record 8 of Set 10 | awbari\n",
      "Processing Record 9 of Set 10 | mala tokmachka\n",
      "Processing Record 10 of Set 10 | kamenka\n",
      "Processing Record 11 of Set 10 | bisceglie\n",
      "Processing Record 12 of Set 10 | phatthalung\n",
      "Processing Record 13 of Set 10 | tangier\n",
      "Processing Record 14 of Set 10 | zhitikara\n",
      "City not found. Skipping...\n",
      "Processing Record 15 of Set 10 | tateyama\n",
      "Processing Record 16 of Set 10 | morondava\n",
      "Processing Record 17 of Set 10 | anandnagar\n",
      "Processing Record 18 of Set 10 | karkaralinsk\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 10 | iquitos\n",
      "Processing Record 20 of Set 10 | eravur\n",
      "Processing Record 21 of Set 10 | chumphon\n",
      "Processing Record 22 of Set 10 | malinyi\n",
      "Processing Record 23 of Set 10 | sungaipenuh\n",
      "Processing Record 24 of Set 10 | san policarpo\n",
      "Processing Record 25 of Set 10 | beringovskiy\n",
      "Processing Record 26 of Set 10 | mayya\n",
      "Processing Record 27 of Set 10 | canto do buriti\n",
      "Processing Record 28 of Set 10 | kundiawa\n",
      "Processing Record 29 of Set 10 | wichita falls\n",
      "Processing Record 30 of Set 10 | ardistan\n",
      "City not found. Skipping...\n",
      "Processing Record 31 of Set 10 | campo bom\n",
      "Processing Record 32 of Set 10 | mandalgovi\n",
      "Processing Record 33 of Set 10 | carballo\n",
      "Processing Record 34 of Set 10 | key west\n",
      "Processing Record 35 of Set 10 | varkkallai\n",
      "Processing Record 36 of Set 10 | tondano\n",
      "Processing Record 37 of Set 10 | alnavar\n",
      "Processing Record 38 of Set 10 | griffith\n",
      "Processing Record 39 of Set 10 | grand-lahou\n",
      "Processing Record 40 of Set 10 | brive-la-gaillarde\n",
      "Processing Record 41 of Set 10 | hunza\n",
      "City not found. Skipping...\n",
      "Processing Record 42 of Set 10 | aklavik\n",
      "Processing Record 43 of Set 10 | filingue\n",
      "Processing Record 44 of Set 10 | sioux lookout\n",
      "Processing Record 45 of Set 10 | anadyr\n",
      "Processing Record 46 of Set 10 | nola\n",
      "Processing Record 47 of Set 10 | orasac\n",
      "Processing Record 48 of Set 10 | miri\n",
      "Processing Record 49 of Set 10 | ugoofaaru\n",
      "Processing Record 50 of Set 10 | dinguiraye\n",
      "Processing Record 1 of Set 11 | usakos\n",
      "Processing Record 2 of Set 11 | brebu\n",
      "Processing Record 3 of Set 11 | lydenburg\n",
      "Processing Record 4 of Set 11 | kalininsk\n",
      "Processing Record 5 of Set 11 | jumla\n",
      "Processing Record 6 of Set 11 | den helder\n",
      "Processing Record 7 of Set 11 | tautira\n",
      "Processing Record 8 of Set 11 | verkhoyansk\n",
      "Processing Record 9 of Set 11 | marathon\n",
      "Processing Record 10 of Set 11 | sibu\n",
      "Processing Record 11 of Set 11 | bonavista\n",
      "Processing Record 12 of Set 11 | gorno-chuyskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 13 of Set 11 | roura\n",
      "Processing Record 14 of Set 11 | borgarnes\n",
      "Processing Record 15 of Set 11 | dongsheng\n",
      "Processing Record 16 of Set 11 | shillong\n",
      "Processing Record 17 of Set 11 | muzhi\n",
      "Processing Record 18 of Set 11 | kloulklubed\n",
      "Processing Record 19 of Set 11 | lisakovsk\n",
      "Processing Record 20 of Set 11 | bubaque\n",
      "Processing Record 21 of Set 11 | bousso\n",
      "Processing Record 22 of Set 11 | alimpesti\n",
      "Processing Record 23 of Set 11 | eyl\n",
      "Processing Record 24 of Set 11 | szprotawa\n",
      "Processing Record 25 of Set 11 | chumikan\n",
      "Processing Record 26 of Set 11 | marion\n",
      "Processing Record 27 of Set 11 | laguna\n",
      "Processing Record 28 of Set 11 | narsaq\n",
      "Processing Record 29 of Set 11 | shellbrook\n",
      "Processing Record 30 of Set 11 | zlobin\n",
      "Processing Record 31 of Set 11 | karumbakkam\n",
      "Processing Record 32 of Set 11 | kalamakion\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 11 | bilma\n",
      "Processing Record 34 of Set 11 | hermiston\n",
      "Processing Record 35 of Set 11 | whitianga\n",
      "Processing Record 36 of Set 11 | yar-sale\n",
      "Processing Record 37 of Set 11 | margaride\n",
      "Processing Record 38 of Set 11 | maceio\n",
      "Processing Record 39 of Set 11 | kovur\n",
      "Processing Record 40 of Set 11 | palana\n",
      "Processing Record 41 of Set 11 | cap malheureux\n",
      "Processing Record 42 of Set 11 | lake havasu city\n",
      "Processing Record 43 of Set 11 | warqla\n",
      "City not found. Skipping...\n",
      "Processing Record 44 of Set 11 | talnakh\n",
      "Processing Record 45 of Set 11 | xunchang\n",
      "Processing Record 46 of Set 11 | dzhusaly\n",
      "City not found. Skipping...\n",
      "Processing Record 47 of Set 11 | mama\n",
      "Processing Record 48 of Set 11 | hala\n",
      "Processing Record 49 of Set 11 | nouadhibou\n",
      "Processing Record 50 of Set 11 | harper\n",
      "Processing Record 1 of Set 12 | yuancheng\n",
      "Processing Record 2 of Set 12 | dinghai\n",
      "Processing Record 3 of Set 12 | sorland\n",
      "Processing Record 4 of Set 12 | ranong\n",
      "Processing Record 5 of Set 12 | bardiyah\n",
      "Processing Record 6 of Set 12 | emba\n",
      "Processing Record 7 of Set 12 | kodinsk\n",
      "Processing Record 8 of Set 12 | ternate\n",
      "Processing Record 9 of Set 12 | quibdo\n",
      "Processing Record 10 of Set 12 | hovd\n",
      "Processing Record 11 of Set 12 | tres arroyos\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 12 of Set 12 | calvinia\n",
      "Processing Record 13 of Set 12 | karsun\n",
      "Processing Record 14 of Set 12 | ratlam\n",
      "Processing Record 15 of Set 12 | fairmont\n",
      "Processing Record 16 of Set 12 | kabare\n",
      "Processing Record 17 of Set 12 | newport\n",
      "Processing Record 18 of Set 12 | shache\n",
      "Processing Record 19 of Set 12 | madimba\n",
      "Processing Record 20 of Set 12 | khartoum\n",
      "Processing Record 21 of Set 12 | narasapur\n",
      "Processing Record 22 of Set 12 | maniitsoq\n",
      "Processing Record 23 of Set 12 | fomboni\n",
      "Processing Record 24 of Set 12 | yumen\n",
      "Processing Record 25 of Set 12 | mayna\n",
      "Processing Record 26 of Set 12 | ayan\n",
      "Processing Record 27 of Set 12 | lata\n",
      "Processing Record 28 of Set 12 | tornio\n",
      "Processing Record 29 of Set 12 | muli\n",
      "Processing Record 30 of Set 12 | shenkursk\n",
      "Processing Record 31 of Set 12 | pudozh\n",
      "Processing Record 32 of Set 12 | kurilsk\n",
      "Processing Record 33 of Set 12 | guane\n",
      "Processing Record 34 of Set 12 | viligili\n",
      "City not found. Skipping...\n",
      "Processing Record 35 of Set 12 | mouila\n",
      "Processing Record 36 of Set 12 | slave lake\n",
      "Processing Record 37 of Set 12 | tarragona\n",
      "Processing Record 38 of Set 12 | atar\n",
      "Processing Record 39 of Set 12 | agdas\n",
      "Processing Record 40 of Set 12 | pemberton\n",
      "Processing Record 41 of Set 12 | baruun-urt\n",
      "Processing Record 42 of Set 12 | gezing\n",
      "Processing Record 43 of Set 12 | nagua\n",
      "Processing Record 44 of Set 12 | seica mica\n",
      "Processing Record 45 of Set 12 | higuey\n",
      "City not found. Skipping...\n",
      "Processing Record 46 of Set 12 | artyk\n",
      "City not found. Skipping...\n",
      "Processing Record 47 of Set 12 | lorengau\n",
      "Processing Record 48 of Set 12 | vila velha\n",
      "-----------------------------\n",
      "Data Retrieval Complete      \n",
      "-----------------------------\n"
     ]
    }
   ],
   "source": [
    "# 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\n",
    "\n",
    "# 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",
    "    \n",
    "\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",
    "        \n",
    "        # Parse out the needed data.\n",
    "        city_country = city_weather[\"sys\"][\"country\"]\n",
    "        city_lat = city_weather[\"coord\"][\"lat\"]\n",
    "        city_lng = city_weather[\"coord\"][\"lon\"]\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_description = city_weather[\"weather\"][0][\"description\"]\n",
    "        \n",
    "    \n",
    "\n",
    "    # If an error is experienced, skip the city.\n",
    "    except:\n",
    "        print(\"City not found. Skipping...\")\n",
    "        pass\n",
    "\n",
    "\n",
    "    \n",
    "    # Running a next try-except block to get cities that had rainfall in the last hour\n",
    "    # If not, setting rainfall= 0\n",
    "    try:\n",
    "        # Parse the JSON and retrieve data.\n",
    "        city_weather = requests.get(city_url).json()\n",
    "        \n",
    "        # Parse out the needed data.\n",
    "        city_rain_1h = city_weather[\"rain\"][\"1h\"]\n",
    "        \n",
    "\n",
    "    # If an error is experienced, rainfall = 0.\n",
    "    except:\n",
    "        city_rain_1h = 0\n",
    "        pass    \n",
    "\n",
    "\n",
    "    \n",
    "\n",
    "    # Running a next try-except block to get cities that had snowl in the last hour\n",
    "    # Not many cities around the world will have snow especially given this time of year\n",
    "    # If not, setting snow = 0\n",
    "    try:\n",
    "        # Parse the JSON and retrieve data.\n",
    "        city_weather = requests.get(city_url).json()\n",
    "        \n",
    "        # Parse out the needed data.\n",
    "        city_snow_1h = city_weather[\"snow\"][\"1h\"]\n",
    "        \n",
    "\n",
    "    # If an error is experienced, snow = 0.\n",
    "    except:\n",
    "        city_snow_1h = 0\n",
    "        pass   \n",
    "\n",
    "\n",
    "        # Append the city information into city_data list.\n",
    "        city_data.append({\"City\": city.title(),\n",
    "                          \"Country\": city_country,\n",
    "                          \"Lat\": city_lat,\n",
    "                          \"Lng\": city_lng,\n",
    "                          \"Max Temp\": city_max_temp,\n",
    "                          \"Humidity\": city_humidity,\n",
    "                          \"Cloudiness\": city_clouds,\n",
    "                          \"Wind Speed\": city_wind,\n",
    "                          \"Current Description\": city_description,\n",
    "                          \"Rain(inches)\": city_rain_1h,\n",
    "                          \"Snow(inches)\": city_snow_1h})\n",
    "        \n",
    "        \n",
    "# Indicate that Data Loading is complete.\n",
    "print(\"-----------------------------\")\n",
    "print(\"Data Retrieval Complete      \")\n",
    "print(\"-----------------------------\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "598"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(city_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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",
       "      <th>Rain(inches)</th>\n",
       "      <th>Snow(inches)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Busselton</td>\n",
       "      <td>AU</td>\n",
       "      <td>-33.65</td>\n",
       "      <td>115.33</td>\n",
       "      <td>55.99</td>\n",
       "      <td>81</td>\n",
       "      <td>44</td>\n",
       "      <td>13.24</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Punta Arenas</td>\n",
       "      <td>CL</td>\n",
       "      <td>-53.15</td>\n",
       "      <td>-70.92</td>\n",
       "      <td>37.40</td>\n",
       "      <td>78</td>\n",
       "      <td>20</td>\n",
       "      <td>21.92</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Esperance</td>\n",
       "      <td>AU</td>\n",
       "      <td>-33.87</td>\n",
       "      <td>121.90</td>\n",
       "      <td>48.20</td>\n",
       "      <td>66</td>\n",
       "      <td>48</td>\n",
       "      <td>18.34</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bluff</td>\n",
       "      <td>NZ</td>\n",
       "      <td>-46.60</td>\n",
       "      <td>168.33</td>\n",
       "      <td>39.00</td>\n",
       "      <td>83</td>\n",
       "      <td>56</td>\n",
       "      <td>3.00</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mar Del Plata</td>\n",
       "      <td>AR</td>\n",
       "      <td>-38.00</td>\n",
       "      <td>-57.56</td>\n",
       "      <td>50.00</td>\n",
       "      <td>37</td>\n",
       "      <td>20</td>\n",
       "      <td>17.22</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tiarei</td>\n",
       "      <td>PF</td>\n",
       "      <td>-17.53</td>\n",
       "      <td>-149.33</td>\n",
       "      <td>77.00</td>\n",
       "      <td>69</td>\n",
       "      <td>75</td>\n",
       "      <td>1.12</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Sept-Iles</td>\n",
       "      <td>CA</td>\n",
       "      <td>50.20</td>\n",
       "      <td>-66.38</td>\n",
       "      <td>69.80</td>\n",
       "      <td>88</td>\n",
       "      <td>90</td>\n",
       "      <td>9.17</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ulladulla</td>\n",
       "      <td>AU</td>\n",
       "      <td>-35.35</td>\n",
       "      <td>150.47</td>\n",
       "      <td>48.99</td>\n",
       "      <td>100</td>\n",
       "      <td>90</td>\n",
       "      <td>5.82</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mys Shmidta</td>\n",
       "      <td>AU</td>\n",
       "      <td>-35.35</td>\n",
       "      <td>150.47</td>\n",
       "      <td>48.99</td>\n",
       "      <td>100</td>\n",
       "      <td>90</td>\n",
       "      <td>5.82</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ponta Do Sol</td>\n",
       "      <td>PT</td>\n",
       "      <td>32.67</td>\n",
       "      <td>-17.10</td>\n",
       "      <td>73.99</td>\n",
       "      <td>70</td>\n",
       "      <td>0</td>\n",
       "      <td>3.74</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            City Country    Lat     Lng  Max Temp  Humidity  Cloudiness  \\\n",
       "0      Busselton      AU -33.65  115.33     55.99        81          44   \n",
       "1   Punta Arenas      CL -53.15  -70.92     37.40        78          20   \n",
       "2      Esperance      AU -33.87  121.90     48.20        66          48   \n",
       "3          Bluff      NZ -46.60  168.33     39.00        83          56   \n",
       "4  Mar Del Plata      AR -38.00  -57.56     50.00        37          20   \n",
       "5         Tiarei      PF -17.53 -149.33     77.00        69          75   \n",
       "6      Sept-Iles      CA  50.20  -66.38     69.80        88          90   \n",
       "7      Ulladulla      AU -35.35  150.47     48.99       100          90   \n",
       "8    Mys Shmidta      AU -35.35  150.47     48.99       100          90   \n",
       "9   Ponta Do Sol      PT  32.67  -17.10     73.99        70           0   \n",
       "\n",
       "   Wind Speed Current Description  Rain(inches)  Snow(inches)  \n",
       "0       13.24    scattered clouds           0.0             0  \n",
       "1       21.92          few clouds           0.0             0  \n",
       "2       18.34    scattered clouds           0.0             0  \n",
       "3        3.00       broken clouds           0.0             0  \n",
       "4       17.22          few clouds           0.0             0  \n",
       "5        1.12       broken clouds           0.0             0  \n",
       "6        9.17     overcast clouds           0.0             0  \n",
       "7        5.82     overcast clouds           0.0             0  \n",
       "8        5.82     overcast clouds           0.0             0  \n",
       "9        3.74           clear sky           0.0             0  "
      ]
     },
     "execution_count": 21,
     "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": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create the output file (CSV)\n",
    "output_data_file = \"weather_data/WeatherPy_database.csv\"\n",
    "\n",
    "# Export the City_Data into a CSV\n",
    "city_data_df.to_csv(output_data_file, index_label=\"City_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonData",
   "language": "python",
   "name": "pythondata"
  },
  "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
}