Weather_Database.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Challenge, Part 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import Dependencies\n",
    "from citipy import citipy\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a set of 1500 random lat and long combinations.\n",
    "lats = np.random.uniform(low=-90.000, high=90.00, size=1500)\n",
    "lngs = np.random.uniform(low=-180.000, high=180.000, size=1500)\n",
    "lat_lngs = zip(lats,lngs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Add the lat and long to a list\n",
    "coordinates = list(lat_lngs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "596"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a list for the cities\n",
    "cities = []\n",
    "\n",
    "# Identify nearest city for each lat and long combination\n",
    "for coordinate in coordinates:\n",
    "    city = citipy.nearest_city(coordinate[0], coordinate[1]).city_name\n",
    "    \n",
    "    if city not in cities:\n",
    "        cities.append(city)\n",
    "        \n",
    "len(cities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import request library\n",
    "import requests\n",
    "from datetime import datetime\n",
    "from config import weather_api_key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"http://api.openweathermap.org/data/2.5/weather?units=Imperial&APPID=\" + weather_api_key"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Beginning Data Retrieval\n",
      "------------------------\n",
      "Processing Record 1 of Set 1 | teshie\n",
      "Processing Record 2 of Set 1 | mount gambier\n",
      "Processing Record 3 of Set 1 | clonakilty\n",
      "Processing Record 4 of Set 1 | san rafael\n",
      "Processing Record 5 of Set 1 | hasaki\n",
      "Processing Record 6 of Set 1 | tuktoyaktuk\n",
      "Processing Record 7 of Set 1 | kostomuksha\n",
      "Processing Record 8 of Set 1 | envira\n",
      "Processing Record 9 of Set 1 | east london\n",
      "Processing Record 10 of Set 1 | port-cartier\n",
      "Processing Record 11 of Set 1 | chokurdakh\n",
      "Processing Record 12 of Set 1 | scarborough\n",
      "Processing Record 13 of Set 1 | khatanga\n",
      "Processing Record 14 of Set 1 | mbigou\n",
      "Processing Record 15 of Set 1 | almaznyy\n",
      "Processing Record 16 of Set 1 | georgetown\n",
      "Processing Record 17 of Set 1 | homer\n",
      "Processing Record 18 of Set 1 | aklavik\n",
      "Processing Record 19 of Set 1 | ribeira grande\n",
      "Processing Record 20 of Set 1 | villablino\n",
      "Processing Record 21 of Set 1 | ayan\n",
      "Processing Record 22 of Set 1 | rincon\n",
      "Processing Record 23 of Set 1 | muros\n",
      "Processing Record 24 of Set 1 | yar-sale\n",
      "Processing Record 25 of Set 1 | rikitea\n",
      "Processing Record 26 of Set 1 | barentsburg\n",
      "City not found. Skipping...\n",
      "Processing Record 27 of Set 1 | butaritari\n",
      "Processing Record 28 of Set 1 | yellowknife\n",
      "Processing Record 29 of Set 1 | berlevag\n",
      "Processing Record 30 of Set 1 | hilo\n",
      "Processing Record 31 of Set 1 | bluff\n",
      "Processing Record 32 of Set 1 | atuona\n",
      "Processing Record 33 of Set 1 | vaini\n",
      "Processing Record 34 of Set 1 | bredasdorp\n",
      "Processing Record 35 of Set 1 | ponta do sol\n",
      "Processing Record 36 of Set 1 | mrirt\n",
      "City not found. Skipping...\n",
      "Processing Record 37 of Set 1 | kuminskiy\n",
      "Processing Record 38 of Set 1 | fortuna\n",
      "Processing Record 39 of Set 1 | ostrovnoy\n",
      "Processing Record 40 of Set 1 | namatanai\n",
      "Processing Record 41 of Set 1 | bowen\n",
      "Processing Record 42 of Set 1 | cidreira\n",
      "Processing Record 43 of Set 1 | pangnirtung\n",
      "Processing Record 44 of Set 1 | palmetto\n",
      "Processing Record 45 of Set 1 | pochutla\n",
      "Processing Record 46 of Set 1 | cape town\n",
      "Processing Record 47 of Set 1 | flinders\n",
      "Processing Record 48 of Set 1 | sabha\n",
      "Processing Record 49 of Set 1 | ushuaia\n",
      "Processing Record 50 of Set 1 | ilulissat\n",
      "Processing Record 1 of Set 2 | srednekolymsk\n",
      "Processing Record 2 of Set 2 | camopi\n",
      "Processing Record 3 of Set 2 | castro\n",
      "Processing Record 4 of Set 2 | touros\n",
      "Processing Record 5 of Set 2 | falealupo\n",
      "City not found. Skipping...\n",
      "Processing Record 6 of Set 2 | mayumba\n",
      "Processing Record 7 of Set 2 | sambava\n",
      "Processing Record 8 of Set 2 | krasnoyarsk-45\n",
      "City not found. Skipping...\n",
      "Processing Record 9 of Set 2 | codrington\n",
      "Processing Record 10 of Set 2 | victoria\n",
      "Processing Record 11 of Set 2 | souillac\n",
      "Processing Record 12 of Set 2 | barrow\n",
      "Processing Record 13 of Set 2 | bethel\n",
      "Processing Record 14 of Set 2 | mar del plata\n",
      "Processing Record 15 of Set 2 | pangody\n",
      "Processing Record 16 of Set 2 | ucluelet\n",
      "Processing Record 17 of Set 2 | hualmay\n",
      "Processing Record 18 of Set 2 | taolanaro\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 2 | rosetta\n",
      "Processing Record 20 of Set 2 | illoqqortoormiut\n",
      "City not found. Skipping...\n",
      "Processing Record 21 of Set 2 | chuy\n",
      "Processing Record 22 of Set 2 | punta arenas\n",
      "Processing Record 23 of Set 2 | katsuura\n",
      "Processing Record 24 of Set 2 | geraldton\n",
      "Processing Record 25 of Set 2 | tezu\n",
      "Processing Record 26 of Set 2 | jamestown\n",
      "Processing Record 27 of Set 2 | marigot\n",
      "Processing Record 28 of Set 2 | buncrana\n",
      "Processing Record 29 of Set 2 | tasiilaq\n",
      "Processing Record 30 of Set 2 | sorland\n",
      "Processing Record 31 of Set 2 | beringovskiy\n",
      "Processing Record 32 of Set 2 | grants pass\n",
      "Processing Record 33 of Set 2 | nhulunbuy\n",
      "Processing Record 34 of Set 2 | ahipara\n",
      "Processing Record 35 of Set 2 | puerto ayora\n",
      "Processing Record 36 of Set 2 | port elizabeth\n",
      "Processing Record 37 of Set 2 | kapaa\n",
      "Processing Record 38 of Set 2 | mys shmidta\n",
      "City not found. Skipping...\n",
      "Processing Record 39 of Set 2 | tyshkivka\n",
      "Processing Record 40 of Set 2 | mataura\n",
      "Processing Record 41 of Set 2 | atar\n",
      "Processing Record 42 of Set 2 | northam\n",
      "Processing Record 43 of Set 2 | mabaruma\n",
      "Processing Record 44 of Set 2 | kruisfontein\n",
      "Processing Record 45 of Set 2 | pingliang\n",
      "Processing Record 46 of Set 2 | faanui\n",
      "Processing Record 47 of Set 2 | kalawit\n",
      "Processing Record 48 of Set 2 | malanje\n",
      "Processing Record 49 of Set 2 | belushya guba\n",
      "City not found. Skipping...\n",
      "Processing Record 50 of Set 2 | port hedland\n",
      "Processing Record 1 of Set 3 | saint-philippe\n",
      "Processing Record 2 of Set 3 | amderma\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 3 | soderhamn\n",
      "Processing Record 4 of Set 3 | grindavik\n",
      "Processing Record 5 of Set 3 | majene\n",
      "Processing Record 6 of Set 3 | turbat\n",
      "Processing Record 7 of Set 3 | bandarbeyla\n",
      "Processing Record 8 of Set 3 | inirida\n",
      "Processing Record 9 of Set 3 | hermanus\n",
      "Processing Record 10 of Set 3 | yanchukan\n",
      "City not found. Skipping...\n",
      "Processing Record 11 of Set 3 | longyearbyen\n",
      "Processing Record 12 of Set 3 | nikolskoye\n",
      "Processing Record 13 of Set 3 | port lincoln\n",
      "Processing Record 14 of Set 3 | quatre cocos\n",
      "Processing Record 15 of Set 3 | garhshankar\n",
      "Processing Record 16 of Set 3 | sept-iles\n",
      "Processing Record 17 of Set 3 | churapcha\n",
      "Processing Record 18 of Set 3 | albany\n",
      "Processing Record 19 of Set 3 | port alfred\n",
      "Processing Record 20 of Set 3 | kavieng\n",
      "Processing Record 21 of Set 3 | la ronge\n",
      "Processing Record 22 of Set 3 | krasnoselkup\n",
      "Processing Record 23 of Set 3 | pevek\n",
      "Processing Record 24 of Set 3 | satipo\n",
      "Processing Record 25 of Set 3 | hobart\n",
      "Processing Record 26 of Set 3 | upernavik\n",
      "Processing Record 27 of Set 3 | ust-kuyga\n",
      "Processing Record 28 of Set 3 | mahebourg\n",
      "Processing Record 29 of Set 3 | kez\n",
      "Processing Record 30 of Set 3 | yerofey pavlovich\n",
      "Processing Record 31 of Set 3 | guarapari\n",
      "Processing Record 32 of Set 3 | kathu\n",
      "Processing Record 33 of Set 3 | colares\n",
      "Processing Record 34 of Set 3 | mponela\n",
      "Processing Record 35 of Set 3 | hearst\n",
      "Processing Record 36 of Set 3 | mehamn\n",
      "Processing Record 37 of Set 3 | new norfolk\n",
      "Processing Record 38 of Set 3 | nyurba\n",
      "Processing Record 39 of Set 3 | esperance\n",
      "Processing Record 40 of Set 3 | kaitangata\n",
      "Processing Record 41 of Set 3 | bongaree\n",
      "Processing Record 42 of Set 3 | palabuhanratu\n",
      "City not found. Skipping...\n",
      "Processing Record 43 of Set 3 | silver city\n",
      "Processing Record 44 of Set 3 | busayra\n",
      "Processing Record 45 of Set 3 | saskylakh\n",
      "Processing Record 46 of Set 3 | thompson\n",
      "Processing Record 47 of Set 3 | san andres\n",
      "Processing Record 48 of Set 3 | chirongui\n",
      "Processing Record 49 of Set 3 | nizhniy kuranakh\n",
      "Processing Record 50 of Set 3 | kasongo\n",
      "Processing Record 1 of Set 4 | busselton\n",
      "Processing Record 2 of Set 4 | saleaula\n",
      "City not found. Skipping...\n",
      "Processing Record 3 of Set 4 | makakilo city\n",
      "Processing Record 4 of Set 4 | matay\n",
      "Processing Record 5 of Set 4 | quelimane\n",
      "Processing Record 6 of Set 4 | leh\n",
      "Processing Record 7 of Set 4 | sioux lookout\n",
      "Processing Record 8 of Set 4 | mogwase\n",
      "Processing Record 9 of Set 4 | pisco\n",
      "Processing Record 10 of Set 4 | ternovka\n",
      "Processing Record 11 of Set 4 | santa clara\n",
      "Processing Record 12 of Set 4 | tornio\n",
      "Processing Record 13 of Set 4 | samusu\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 4 | katobu\n",
      "Processing Record 15 of Set 4 | ozu\n",
      "Processing Record 16 of Set 4 | ankpa\n",
      "Processing Record 17 of Set 4 | tuzha\n",
      "Processing Record 18 of Set 4 | naze\n",
      "Processing Record 19 of Set 4 | praya\n",
      "Processing Record 20 of Set 4 | meadow lake\n",
      "Processing Record 21 of Set 4 | kiryas joel\n",
      "Processing Record 22 of Set 4 | neryungri\n",
      "Processing Record 23 of Set 4 | nanortalik\n",
      "Processing Record 24 of Set 4 | matipo\n",
      "Processing Record 25 of Set 4 | sao felix do xingu\n",
      "Processing Record 26 of Set 4 | dingle\n",
      "Processing Record 27 of Set 4 | lavrentiya\n",
      "Processing Record 28 of Set 4 | teruel\n",
      "Processing Record 29 of Set 4 | port keats\n",
      "Processing Record 30 of Set 4 | shizunai\n",
      "Processing Record 31 of Set 4 | beyneu\n",
      "Processing Record 32 of Set 4 | grand centre\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 4 | salalah\n",
      "Processing Record 34 of Set 4 | nara\n",
      "Processing Record 35 of Set 4 | tautira\n",
      "Processing Record 36 of Set 4 | carnarvon\n",
      "Processing Record 37 of Set 4 | lashio\n",
      "Processing Record 38 of Set 4 | zhigansk\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 39 of Set 4 | lompoc\n",
      "Processing Record 40 of Set 4 | sao filipe\n",
      "Processing Record 41 of Set 4 | hurghada\n",
      "Processing Record 42 of Set 4 | mangaratiba\n",
      "Processing Record 43 of Set 4 | saint george\n",
      "Processing Record 44 of Set 4 | isangel\n",
      "Processing Record 45 of Set 4 | la palma\n",
      "Processing Record 46 of Set 4 | christchurch\n",
      "Processing Record 47 of Set 4 | micheweni\n",
      "Processing Record 48 of Set 4 | palmar\n",
      "Processing Record 49 of Set 4 | abonnema\n",
      "Processing Record 50 of Set 4 | vardo\n",
      "Processing Record 1 of Set 5 | lerwick\n",
      "Processing Record 2 of Set 5 | athabasca\n",
      "Processing Record 3 of Set 5 | nacogdoches\n",
      "Processing Record 4 of Set 5 | evensk\n",
      "Processing Record 5 of Set 5 | byron bay\n",
      "Processing Record 6 of Set 5 | podgorica\n",
      "Processing Record 7 of Set 5 | neiafu\n",
      "Processing Record 8 of Set 5 | barybino\n",
      "Processing Record 9 of Set 5 | tres passos\n",
      "Processing Record 10 of Set 5 | rascani\n",
      "City not found. Skipping...\n",
      "Processing Record 11 of Set 5 | dhidhdhoo\n",
      "Processing Record 12 of Set 5 | yeppoon\n",
      "Processing Record 13 of Set 5 | riyadh\n",
      "Processing Record 14 of Set 5 | kholodnyy\n",
      "Processing Record 15 of Set 5 | lagoa\n",
      "Processing Record 16 of Set 5 | grand river south east\n",
      "City not found. Skipping...\n",
      "Processing Record 17 of Set 5 | taltal\n",
      "Processing Record 18 of Set 5 | tunduru\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 5 | provideniya\n",
      "Processing Record 20 of Set 5 | noumea\n",
      "Processing Record 21 of Set 5 | yulara\n",
      "Processing Record 22 of Set 5 | lorengau\n",
      "Processing Record 23 of Set 5 | avarua\n",
      "Processing Record 24 of Set 5 | tsihombe\n",
      "City not found. Skipping...\n",
      "Processing Record 25 of Set 5 | guerrero negro\n",
      "Processing Record 26 of Set 5 | nizhneyansk\n",
      "City not found. Skipping...\n",
      "Processing Record 27 of Set 5 | vaitupu\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 5 | le port\n",
      "Processing Record 29 of Set 5 | dunedin\n",
      "Processing Record 30 of Set 5 | ouadda\n",
      "Processing Record 31 of Set 5 | qasigiannguit\n",
      "Processing Record 32 of Set 5 | kasungu\n",
      "Processing Record 33 of Set 5 | fort nelson\n",
      "Processing Record 34 of Set 5 | bambous virieux\n",
      "Processing Record 35 of Set 5 | hamilton\n",
      "Processing Record 36 of Set 5 | ponta delgada\n",
      "Processing Record 37 of Set 5 | lar gerd\n",
      "City not found. Skipping...\n",
      "Processing Record 38 of Set 5 | deming\n",
      "Processing Record 39 of Set 5 | livingstonia\n",
      "Processing Record 40 of Set 5 | masuguru\n",
      "Processing Record 41 of Set 5 | vaitape\n",
      "Processing Record 42 of Set 5 | sitamau\n",
      "Processing Record 43 of Set 5 | port shepstone\n",
      "Processing Record 44 of Set 5 | havelock\n",
      "Processing Record 45 of Set 5 | torbay\n",
      "Processing Record 46 of Set 5 | kamenskoye\n",
      "City not found. Skipping...\n",
      "Processing Record 47 of Set 5 | hithadhoo\n",
      "Processing Record 48 of Set 5 | suhut\n",
      "Processing Record 49 of Set 5 | cabo san lucas\n",
      "Processing Record 50 of Set 5 | tam ky\n",
      "Processing Record 1 of Set 6 | gitarama\n",
      "Processing Record 2 of Set 6 | flin flon\n",
      "Processing Record 3 of Set 6 | ca mau\n",
      "Processing Record 4 of Set 6 | outjo\n",
      "Processing Record 5 of Set 6 | iqaluit\n",
      "Processing Record 6 of Set 6 | adrar\n",
      "Processing Record 7 of Set 6 | beloha\n",
      "Processing Record 8 of Set 6 | meulaboh\n",
      "Processing Record 9 of Set 6 | aquiles serdan\n",
      "Processing Record 10 of Set 6 | kondinskoye\n",
      "Processing Record 11 of Set 6 | vila franca do campo\n",
      "Processing Record 12 of Set 6 | dekar\n",
      "Processing Record 13 of Set 6 | japura\n",
      "Processing Record 14 of Set 6 | bacungan\n",
      "Processing Record 15 of Set 6 | tokonou\n",
      "Processing Record 16 of Set 6 | mogadishu\n",
      "Processing Record 17 of Set 6 | tessalit\n",
      "Processing Record 18 of Set 6 | sentyabrskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 19 of Set 6 | kuching\n",
      "Processing Record 20 of Set 6 | mamallapuram\n",
      "Processing Record 21 of Set 6 | tlaxiaco\n",
      "City not found. Skipping...\n",
      "Processing Record 22 of Set 6 | kutahya\n",
      "Processing Record 23 of Set 6 | takaka\n",
      "Processing Record 24 of Set 6 | bambanglipuro\n",
      "Processing Record 25 of Set 6 | labuhan\n",
      "Processing Record 26 of Set 6 | broome\n",
      "Processing Record 27 of Set 6 | klaksvik\n",
      "Processing Record 28 of Set 6 | yagodnoye\n",
      "Processing Record 29 of Set 6 | murindo\n",
      "Processing Record 30 of Set 6 | gorom-gorom\n",
      "Processing Record 31 of Set 6 | port-gentil\n",
      "Processing Record 32 of Set 6 | yomitan\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 6 | shu\n",
      "Processing Record 34 of Set 6 | asau\n",
      "Processing Record 35 of Set 6 | calvinia\n",
      "Processing Record 36 of Set 6 | lebu\n",
      "Processing Record 37 of Set 6 | araouane\n",
      "Processing Record 38 of Set 6 | luderitz\n",
      "Processing Record 39 of Set 6 | novovarshavka\n",
      "Processing Record 40 of Set 6 | amuntai\n",
      "Processing Record 41 of Set 6 | qaanaaq\n",
      "Processing Record 42 of Set 6 | salvador\n",
      "Processing Record 43 of Set 6 | san juan\n",
      "Processing Record 44 of Set 6 | sheregesh\n",
      "Processing Record 45 of Set 6 | komsomolskiy\n",
      "Processing Record 46 of Set 6 | ulcinj\n",
      "Processing Record 47 of Set 6 | severo-kurilsk\n",
      "Processing Record 48 of Set 6 | hay river\n",
      "Processing Record 49 of Set 6 | bathsheba\n",
      "Processing Record 50 of Set 6 | phek\n",
      "Processing Record 1 of Set 7 | marzuq\n",
      "Processing Record 2 of Set 7 | hambantota\n",
      "Processing Record 3 of Set 7 | ramhormoz\n",
      "Processing Record 4 of Set 7 | calama\n",
      "Processing Record 5 of Set 7 | kahului\n",
      "Processing Record 6 of Set 7 | antsohihy\n",
      "Processing Record 7 of Set 7 | camoapa\n",
      "Processing Record 8 of Set 7 | verkhnyaya sinyachikha\n",
      "Processing Record 9 of Set 7 | gerash\n",
      "Processing Record 10 of Set 7 | sitio novo do tocantins\n",
      "Processing Record 11 of Set 7 | shimoda\n",
      "Processing Record 12 of Set 7 | muyezerskiy\n",
      "Processing Record 13 of Set 7 | tubruq\n",
      "City not found. Skipping...\n",
      "Processing Record 14 of Set 7 | tanda\n",
      "Processing Record 15 of Set 7 | tulun\n",
      "Processing Record 16 of Set 7 | leshan\n",
      "Processing Record 17 of Set 7 | arraial do cabo\n",
      "Processing Record 18 of Set 7 | mao\n",
      "Processing Record 19 of Set 7 | chilca\n",
      "Processing Record 20 of Set 7 | casablanca\n",
      "Processing Record 21 of Set 7 | ulladulla\n",
      "Processing Record 22 of Set 7 | njombe\n",
      "Processing Record 23 of Set 7 | tanout\n",
      "Processing Record 24 of Set 7 | windhoek\n",
      "Processing Record 25 of Set 7 | zaplyusye\n",
      "City not found. Skipping...\n",
      "Processing Record 26 of Set 7 | rundu\n",
      "Processing Record 27 of Set 7 | lagos\n",
      "Processing Record 28 of Set 7 | hami\n",
      "Processing Record 29 of Set 7 | imbituba\n",
      "Processing Record 30 of Set 7 | nileshwar\n",
      "Processing Record 31 of Set 7 | kodiak\n",
      "Processing Record 32 of Set 7 | bereznehuvate\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 7 | lata\n",
      "Processing Record 34 of Set 7 | vila velha\n",
      "Processing Record 35 of Set 7 | yerbogachen\n",
      "Processing Record 36 of Set 7 | tynne\n",
      "Processing Record 37 of Set 7 | iberia\n",
      "Processing Record 38 of Set 7 | airai\n",
      "Processing Record 39 of Set 7 | mpongwe\n",
      "Processing Record 40 of Set 7 | bonthe\n",
      "Processing Record 41 of Set 7 | tuy hoa\n",
      "Processing Record 42 of Set 7 | antalaha\n",
      "Processing Record 43 of Set 7 | den helder\n",
      "Processing Record 44 of Set 7 | cherskiy\n",
      "Processing Record 45 of Set 7 | fairbanks\n",
      "Processing Record 46 of Set 7 | yantal\n",
      "Processing Record 47 of Set 7 | chodziez\n",
      "Processing Record 48 of Set 7 | te anau\n",
      "Processing Record 49 of Set 7 | axim\n",
      "Processing Record 50 of Set 7 | parkersburg\n",
      "Processing Record 1 of Set 8 | lasa\n",
      "Processing Record 2 of Set 8 | mindelo\n",
      "Processing Record 3 of Set 8 | moindou\n",
      "Processing Record 4 of Set 8 | contai\n",
      "Processing Record 5 of Set 8 | brainerd\n",
      "Processing Record 6 of Set 8 | kibaya\n",
      "Processing Record 7 of Set 8 | sirjan\n",
      "Processing Record 8 of Set 8 | cagayan de tawi-tawi\n",
      "City not found. Skipping...\n",
      "Processing Record 9 of Set 8 | marcona\n",
      "City not found. Skipping...\n",
      "Processing Record 10 of Set 8 | leningradskiy\n",
      "Processing Record 11 of Set 8 | pandan\n",
      "Processing Record 12 of Set 8 | lahij\n",
      "Processing Record 13 of Set 8 | muli\n",
      "Processing Record 14 of Set 8 | sitka\n",
      "Processing Record 15 of Set 8 | raudeberg\n",
      "Processing Record 16 of Set 8 | severo-yeniseyskiy\n",
      "Processing Record 17 of Set 8 | tecoanapa\n",
      "Processing Record 18 of Set 8 | pithora\n",
      "Processing Record 19 of Set 8 | ust-tsilma\n",
      "Processing Record 20 of Set 8 | deputatskiy\n",
      "Processing Record 21 of Set 8 | anadyr\n",
      "Processing Record 22 of Set 8 | saldanha\n",
      "Processing Record 23 of Set 8 | buluang\n",
      "Processing Record 24 of Set 8 | chapais\n",
      "Processing Record 25 of Set 8 | lujan\n",
      "Processing Record 26 of Set 8 | nuuk\n",
      "Processing Record 27 of Set 8 | pangai\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 28 of Set 8 | maloy\n",
      "Processing Record 29 of Set 8 | maraa\n",
      "Processing Record 30 of Set 8 | aguai\n",
      "Processing Record 31 of Set 8 | seoul\n",
      "Processing Record 32 of Set 8 | okandja\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 8 | diffa\n",
      "Processing Record 34 of Set 8 | ancud\n",
      "Processing Record 35 of Set 8 | cap malheureux\n",
      "Processing Record 36 of Set 8 | nizhniy tsasuchey\n",
      "Processing Record 37 of Set 8 | zambezi\n",
      "Processing Record 38 of Set 8 | gasa\n",
      "Processing Record 39 of Set 8 | muroto\n",
      "Processing Record 40 of Set 8 | carauari\n",
      "Processing Record 41 of Set 8 | maltahohe\n",
      "Processing Record 42 of Set 8 | attawapiskat\n",
      "City not found. Skipping...\n",
      "Processing Record 43 of Set 8 | ambon\n",
      "Processing Record 44 of Set 8 | forbes\n",
      "Processing Record 45 of Set 8 | saint-francois\n",
      "Processing Record 46 of Set 8 | taoudenni\n",
      "Processing Record 47 of Set 8 | hovd\n",
      "Processing Record 48 of Set 8 | esmeraldas\n",
      "Processing Record 49 of Set 8 | tura\n",
      "Processing Record 50 of Set 8 | marsh harbour\n",
      "Processing Record 1 of Set 9 | kortkeros\n",
      "Processing Record 2 of Set 9 | fenoarivo\n",
      "Processing Record 3 of Set 9 | pacific grove\n",
      "Processing Record 4 of Set 9 | shache\n",
      "Processing Record 5 of Set 9 | datong\n",
      "Processing Record 6 of Set 9 | sao joao da barra\n",
      "Processing Record 7 of Set 9 | ewa beach\n",
      "Processing Record 8 of Set 9 | verkhoyansk\n",
      "Processing Record 9 of Set 9 | gushikawa\n",
      "Processing Record 10 of Set 9 | egvekinot\n",
      "Processing Record 11 of Set 9 | north bend\n",
      "Processing Record 12 of Set 9 | krasnyy chikoy\n",
      "Processing Record 13 of Set 9 | portland\n",
      "Processing Record 14 of Set 9 | manokwari\n",
      "Processing Record 15 of Set 9 | maragogi\n",
      "Processing Record 16 of Set 9 | da lat\n",
      "Processing Record 17 of Set 9 | karratha\n",
      "Processing Record 18 of Set 9 | tyup\n",
      "Processing Record 19 of Set 9 | yumen\n",
      "Processing Record 20 of Set 9 | kumluca\n",
      "Processing Record 21 of Set 9 | kolyshley\n",
      "Processing Record 22 of Set 9 | tanete\n",
      "Processing Record 23 of Set 9 | arkhangelsk\n",
      "Processing Record 24 of Set 9 | tambopata\n",
      "Processing Record 25 of Set 9 | tasbuget\n",
      "City not found. Skipping...\n",
      "Processing Record 26 of Set 9 | aswan\n",
      "Processing Record 27 of Set 9 | miri\n",
      "Processing Record 28 of Set 9 | soavinandriana\n",
      "Processing Record 29 of Set 9 | rotnes\n",
      "Processing Record 30 of Set 9 | waddan\n",
      "Processing Record 31 of Set 9 | gurskoye\n",
      "City not found. Skipping...\n",
      "Processing Record 32 of Set 9 | dikson\n",
      "Processing Record 33 of Set 9 | richards bay\n",
      "Processing Record 34 of Set 9 | satitoa\n",
      "City not found. Skipping...\n",
      "Processing Record 35 of Set 9 | nouadhibou\n",
      "Processing Record 36 of Set 9 | denizli\n",
      "Processing Record 37 of Set 9 | bengkulu\n",
      "Processing Record 38 of Set 9 | cockburn harbour\n",
      "City not found. Skipping...\n",
      "Processing Record 39 of Set 9 | cockburn town\n",
      "Processing Record 40 of Set 9 | bridlington\n",
      "Processing Record 41 of Set 9 | astana\n",
      "Processing Record 42 of Set 9 | luocheng\n",
      "Processing Record 43 of Set 9 | santa rosa\n",
      "Processing Record 44 of Set 9 | markova\n",
      "Processing Record 45 of Set 9 | tiksi\n",
      "Processing Record 46 of Set 9 | obama\n",
      "Processing Record 47 of Set 9 | san policarpo\n",
      "Processing Record 48 of Set 9 | alofi\n",
      "Processing Record 49 of Set 9 | praia da vitoria\n",
      "Processing Record 50 of Set 9 | cairo\n",
      "Processing Record 1 of Set 10 | portachuelo\n",
      "Processing Record 2 of Set 10 | lowestoft\n",
      "Processing Record 3 of Set 10 | azimur\n",
      "City not found. Skipping...\n",
      "Processing Record 4 of Set 10 | boende\n",
      "Processing Record 5 of Set 10 | waingapu\n",
      "Processing Record 6 of Set 10 | saint-pierre\n",
      "Processing Record 7 of Set 10 | kvarkeno\n",
      "Processing Record 8 of Set 10 | mareeba\n",
      "Processing Record 9 of Set 10 | sayyan\n",
      "Processing Record 10 of Set 10 | charleston\n",
      "Processing Record 11 of Set 10 | vostok\n",
      "Processing Record 12 of Set 10 | valdez\n",
      "Processing Record 13 of Set 10 | natal\n",
      "Processing Record 14 of Set 10 | bahia blanca\n",
      "Processing Record 15 of Set 10 | poya\n",
      "Processing Record 16 of Set 10 | talnakh\n",
      "Processing Record 17 of Set 10 | havre-saint-pierre\n",
      "Processing Record 18 of Set 10 | caravelas\n",
      "Processing Record 19 of Set 10 | valle hermoso\n",
      "Processing Record 20 of Set 10 | villarrubia de los ojos\n",
      "Processing Record 21 of Set 10 | pospelikha\n",
      "Processing Record 22 of Set 10 | sataua\n",
      "City not found. Skipping...\n",
      "Processing Record 23 of Set 10 | avera\n",
      "Processing Record 24 of Set 10 | norman wells\n",
      "Processing Record 25 of Set 10 | hokitika\n",
      "Processing Record 26 of Set 10 | sur\n",
      "Processing Record 27 of Set 10 | warqla\n",
      "City not found. Skipping...\n",
      "Processing Record 28 of Set 10 | mana\n",
      "Processing Record 29 of Set 10 | bilma\n",
      "Processing Record 30 of Set 10 | oga\n",
      "Processing Record 31 of Set 10 | havre\n",
      "Processing Record 32 of Set 10 | pereira barreto\n",
      "Processing Record 33 of Set 10 | searcy\n",
      "Processing Record 34 of Set 10 | chapleau\n",
      "Processing Record 35 of Set 10 | kachug\n",
      "Processing Record 36 of Set 10 | igarka\n",
      "Processing Record 37 of Set 10 | guatire\n",
      "Processing Record 38 of Set 10 | tarboro\n",
      "Processing Record 39 of Set 10 | morehead\n",
      "Processing Record 40 of Set 10 | rawson\n",
      "Processing Record 41 of Set 10 | mackenzie\n",
      "Processing Record 42 of Set 10 | yenagoa\n",
      "Processing Record 43 of Set 10 | tabiauea\n",
      "City not found. Skipping...\n",
      "Processing Record 44 of Set 10 | rio gallegos\n",
      "Processing Record 45 of Set 10 | lokosovo\n",
      "Processing Record 46 of Set 10 | alekseyevka\n",
      "Processing Record 47 of Set 10 | potgietersrus\n",
      "City not found. Skipping...\n",
      "Processing Record 48 of Set 10 | poum\n",
      "Processing Record 49 of Set 10 | severnoye\n",
      "Processing Record 50 of Set 10 | lockhart\n",
      "Processing Record 1 of Set 11 | waterloo\n",
      "Processing Record 2 of Set 11 | vanimo\n",
      "Processing Record 3 of Set 11 | qom\n",
      "Processing Record 4 of Set 11 | shahrud\n",
      "Processing Record 5 of Set 11 | margate\n",
      "Processing Record 6 of Set 11 | porto novo\n",
      "Processing Record 7 of Set 11 | zabol\n",
      "Processing Record 8 of Set 11 | zheleznodorozhnyy\n",
      "Processing Record 9 of Set 11 | taiyuan\n",
      "Processing Record 10 of Set 11 | uyuni\n",
      "Processing Record 11 of Set 11 | gat\n",
      "Processing Record 12 of Set 11 | paamiut\n",
      "Processing Record 13 of Set 11 | berdigestyakh\n",
      "Processing Record 14 of Set 11 | sibolga\n",
      "Processing Record 15 of Set 11 | brandfort\n",
      "Processing Record 16 of Set 11 | vuktyl\n",
      "Processing Record 17 of Set 11 | changtu\n",
      "Processing Record 18 of Set 11 | baykalovo\n",
      "Processing Record 19 of Set 11 | kurumkan\n",
      "Processing Record 20 of Set 11 | gornopravdinsk\n",
      "Processing Record 21 of Set 11 | oskarshamn\n",
      "Processing Record 22 of Set 11 | kuruman\n",
      "Processing Record 23 of Set 11 | saint-augustin\n",
      "Processing Record 24 of Set 11 | umm kaddadah\n",
      "Processing Record 25 of Set 11 | niteroi\n",
      "Processing Record 26 of Set 11 | mujiayingzi\n",
      "Processing Record 27 of Set 11 | isabela\n",
      "Processing Record 28 of Set 11 | broken hill\n",
      "Processing Record 29 of Set 11 | kiruna\n",
      "Processing Record 30 of Set 11 | kerki\n",
      "City not found. Skipping...\n",
      "Processing Record 31 of Set 11 | okhotsk\n",
      "Processing Record 32 of Set 11 | padang\n",
      "Processing Record 33 of Set 11 | guntur\n",
      "Processing Record 34 of Set 11 | manadhoo\n",
      "Processing Record 35 of Set 11 | tabialan\n",
      "City not found. Skipping...\n",
      "Processing Record 36 of Set 11 | benalla\n",
      "Processing Record 37 of Set 11 | qaqortoq\n",
      "Processing Record 38 of Set 11 | narsaq\n",
      "Processing Record 39 of Set 11 | freeport\n",
      "Processing Record 40 of Set 11 | tuatapere\n",
      "Processing Record 41 of Set 11 | belmonte\n",
      "Processing Record 42 of Set 11 | tokmak\n",
      "Processing Record 43 of Set 11 | ahuimanu\n",
      "Processing Record 44 of Set 11 | chauk\n",
      "Processing Record 45 of Set 11 | berezovyy\n",
      "Processing Record 46 of Set 11 | mezen\n",
      "Processing Record 47 of Set 11 | denpasar\n",
      "Processing Record 48 of Set 11 | changqing\n",
      "Processing Record 49 of Set 11 | rangpo\n",
      "Processing Record 50 of Set 11 | nishihara\n",
      "Processing Record 1 of Set 12 | dawei\n",
      "Processing Record 2 of Set 12 | pittsfield\n",
      "Processing Record 3 of Set 12 | vitimskiy\n",
      "City not found. Skipping...\n",
      "Processing Record 4 of Set 12 | arica\n",
      "Processing Record 5 of Set 12 | barawe\n",
      "City not found. Skipping...\n",
      "Processing Record 6 of Set 12 | port blair\n",
      "Processing Record 7 of Set 12 | vao\n",
      "Processing Record 8 of Set 12 | harrison\n",
      "Processing Record 9 of Set 12 | barra dos coqueiros\n",
      "Processing Record 10 of Set 12 | bemidji\n",
      "Processing Record 11 of Set 12 | buala\n",
      "Processing Record 12 of Set 12 | jijiga\n",
      "Processing Record 13 of Set 12 | ulaanbaatar\n",
      "Processing Record 14 of Set 12 | anloga\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Record 15 of Set 12 | ler\n",
      "Processing Record 16 of Set 12 | kanpur\n",
      "Processing Record 17 of Set 12 | santa cruz\n",
      "Processing Record 18 of Set 12 | aras\n",
      "Processing Record 19 of Set 12 | pershotravneve\n",
      "Processing Record 20 of Set 12 | gaoual\n",
      "Processing Record 21 of Set 12 | coahuayana\n",
      "Processing Record 22 of Set 12 | sola\n",
      "Processing Record 23 of Set 12 | taywarah\n",
      "Processing Record 24 of Set 12 | kingman\n",
      "Processing Record 25 of Set 12 | big spring\n",
      "Processing Record 26 of Set 12 | mackay\n",
      "Processing Record 27 of Set 12 | yasnogorsk\n",
      "Processing Record 28 of Set 12 | harper\n",
      "Processing Record 29 of Set 12 | agadez\n",
      "Processing Record 30 of Set 12 | koungou\n",
      "Processing Record 31 of Set 12 | mouzakion\n",
      "City not found. Skipping...\n",
      "Processing Record 32 of Set 12 | babanusah\n",
      "City not found. Skipping...\n",
      "Processing Record 33 of Set 12 | kloulklubed\n",
      "Processing Record 34 of Set 12 | pakokku\n",
      "Processing Record 35 of Set 12 | choix\n",
      "Processing Record 36 of Set 12 | xining\n",
      "Processing Record 37 of Set 12 | los llanos de aridane\n",
      "Processing Record 38 of Set 12 | holden\n",
      "Processing Record 39 of Set 12 | svetlaya\n",
      "Processing Record 40 of Set 12 | san lorenzo\n",
      "Processing Record 41 of Set 12 | calabozo\n",
      "Processing Record 42 of Set 12 | olafsvik\n",
      "Processing Record 43 of Set 12 | tobermory\n",
      "Processing Record 44 of Set 12 | newport\n",
      "Processing Record 45 of Set 12 | novikovo\n",
      "Processing Record 46 of Set 12 | kalabo\n",
      "-----------------------------\n",
      "Data Retrieval Complete      \n",
      "-----------------------------\n"
     ]
    }
   ],
   "source": [
    "# List of city data\n",
    "city_data = []\n",
    "\n",
    "#Print\n",
    "print(\"Beginning Data Retrieval\")\n",
    "print(\"-\" * 24)\n",
    "\n",
    "# Create a counter\n",
    "record_count = 1\n",
    "set_count = 1\n",
    "for i, city in enumerate(cities):\n",
    "    \n",
    "    #Group cities\n",
    "    if(i % 50 == 0 and i >= 50):\n",
    "        set_count += 1\n",
    "        record_count = 1\n",
    "    # Create endpoint url for each city\n",
    "    city_url = url + \"&q=\" + city.replace(\" \",\"+\")    \n",
    "    \n",
    "    print(f\"Processing Record {record_count} of Set {set_count} | {city}\")\n",
    "    \n",
    "    record_count += 1\n",
    "    \n",
    "    # Run an API request for each of the cities.\n",
    "    try:\n",
    "        city_weather = requests.get(city_url).json()\n",
    "        \n",
    "        # Parse out max temp, humidity and cloudiness\n",
    "        city_lat = city_weather[\"coord\"][\"lat\"]\n",
    "        city_lon = 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_country = city_weather[\"sys\"][\"country\"]\n",
    "        city_weather_description = city_weather[\"weather\"][0][\"description\"]\n",
    "        \n",
    "        try:\n",
    "            city_rain_inches = city_weather[\"rain\"][\"1h\"]\n",
    "        except KeyError:\n",
    "            city_rain_inches = 0\n",
    "            \n",
    "        try:\n",
    "            city_snow_inches = city_weather[\"snow\"][\"1h\"]\n",
    "        except KeyError:\n",
    "            city_snow_inches = 0\n",
    "            \n",
    "       \n",
    "        # Append the city information into city_data list.\n",
    "        city_data.append(\n",
    "        {\n",
    "            \"City\": city.title(),\n",
    "            \"Lat\": city_lat,\n",
    "            \"Lon\": city_lon,\n",
    "            \"Max Temp\": city_max_temp,\n",
    "            \"Humidity\": city_humidity,\n",
    "            \"Cloudiness\": city_clouds,\n",
    "            \"Wind Speed\": city_wind,\n",
    "            \"Rain (inches)\": city_rain_inches,\n",
    "            \"Snow (inches)\": city_snow_inches,\n",
    "            \"City Description\": city_weather_description,\n",
    "            \"Country\": city_country,\n",
    "        })\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": 16,
   "metadata": {
    "scrolled": true
   },
   "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>Lon</th>\n",
       "      <th>Max Temp</th>\n",
       "      <th>Humidity</th>\n",
       "      <th>Cloudiness</th>\n",
       "      <th>Wind Speed</th>\n",
       "      <th>Rain (inches)</th>\n",
       "      <th>Snow (inches)</th>\n",
       "      <th>City Description</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Teshie</td>\n",
       "      <td>5.58</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>78.80</td>\n",
       "      <td>78</td>\n",
       "      <td>100</td>\n",
       "      <td>9.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>GH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mount Gambier</td>\n",
       "      <td>-37.83</td>\n",
       "      <td>140.77</td>\n",
       "      <td>46.40</td>\n",
       "      <td>93</td>\n",
       "      <td>75</td>\n",
       "      <td>9.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>light intensity shower rain</td>\n",
       "      <td>AU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Clonakilty</td>\n",
       "      <td>51.62</td>\n",
       "      <td>-8.87</td>\n",
       "      <td>60.01</td>\n",
       "      <td>72</td>\n",
       "      <td>75</td>\n",
       "      <td>17.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>IE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>San Rafael</td>\n",
       "      <td>-34.62</td>\n",
       "      <td>-68.33</td>\n",
       "      <td>50.25</td>\n",
       "      <td>48</td>\n",
       "      <td>99</td>\n",
       "      <td>7.78</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>AR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Hasaki</td>\n",
       "      <td>35.73</td>\n",
       "      <td>140.83</td>\n",
       "      <td>73.40</td>\n",
       "      <td>94</td>\n",
       "      <td>75</td>\n",
       "      <td>9.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>JP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>544</th>\n",
       "      <td>Olafsvik</td>\n",
       "      <td>64.89</td>\n",
       "      <td>-23.71</td>\n",
       "      <td>51.82</td>\n",
       "      <td>79</td>\n",
       "      <td>4</td>\n",
       "      <td>13.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>IS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>545</th>\n",
       "      <td>Tobermory</td>\n",
       "      <td>45.25</td>\n",
       "      <td>-81.67</td>\n",
       "      <td>82.99</td>\n",
       "      <td>57</td>\n",
       "      <td>12</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>546</th>\n",
       "      <td>Newport</td>\n",
       "      <td>51.59</td>\n",
       "      <td>-3.00</td>\n",
       "      <td>63.00</td>\n",
       "      <td>65</td>\n",
       "      <td>11</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>GB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>Novikovo</td>\n",
       "      <td>51.15</td>\n",
       "      <td>37.89</td>\n",
       "      <td>66.34</td>\n",
       "      <td>76</td>\n",
       "      <td>15</td>\n",
       "      <td>4.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>RU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>548</th>\n",
       "      <td>Kalabo</td>\n",
       "      <td>-14.97</td>\n",
       "      <td>22.68</td>\n",
       "      <td>68.31</td>\n",
       "      <td>37</td>\n",
       "      <td>28</td>\n",
       "      <td>4.97</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>ZM</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>549 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              City    Lat     Lon  Max Temp  Humidity  Cloudiness  Wind Speed  \\\n",
       "0           Teshie   5.58   -0.11     78.80        78         100        9.17   \n",
       "1    Mount Gambier -37.83  140.77     46.40        93          75        9.17   \n",
       "2       Clonakilty  51.62   -8.87     60.01        72          75       17.22   \n",
       "3       San Rafael -34.62  -68.33     50.25        48          99        7.78   \n",
       "4           Hasaki  35.73  140.83     73.40        94          75        9.17   \n",
       "..             ...    ...     ...       ...       ...         ...         ...   \n",
       "544       Olafsvik  64.89  -23.71     51.82        79           4       13.22   \n",
       "545      Tobermory  45.25  -81.67     82.99        57          12        1.01   \n",
       "546        Newport  51.59   -3.00     63.00        65          11        3.00   \n",
       "547       Novikovo  51.15   37.89     66.34        76          15        4.12   \n",
       "548         Kalabo -14.97   22.68     68.31        37          28        4.97   \n",
       "\n",
       "     Rain (inches)  Snow (inches)             City Description Country  \n",
       "0              0.0              0              overcast clouds      GH  \n",
       "1              0.0              0  light intensity shower rain      AU  \n",
       "2              0.0              0                broken clouds      IE  \n",
       "3              0.0              0              overcast clouds      AR  \n",
       "4              0.0              0                broken clouds      JP  \n",
       "..             ...            ...                          ...     ...  \n",
       "544            0.0              0                    clear sky      IS  \n",
       "545            0.0              0                   few clouds      CA  \n",
       "546            0.0              0                   few clouds      GB  \n",
       "547            0.0              0                   few clouds      RU  \n",
       "548            0.0              0             scattered clouds      ZM  \n",
       "\n",
       "[549 rows x 11 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert List to DataFrame\n",
    "\n",
    "city_data_df = pd.DataFrame(city_data)\n",
    "\n",
    "city_data_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Export to CSV\n",
    "output_file = \"data/WeatherPy_database.csv\"\n",
    "\n",
    "city_data_df.to_csv(output_file, index_label=\"city_id\")"
   ]
  },
  {
   "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}