analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h1>Clean CSV Data and Add to SQL Database</h1>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Import Dependencies</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import csv\n",
    "import pandas as pd\n",
    "\n",
    "import sqlite3\n",
    "import csv\n",
    "from sqlalchemy import create_engine\n",
    "\n",
    "from config import pgPassword"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Create paths to CSV files</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "pathBeers = os.path.join(\"data\", \"beers.csv\")\n",
    "pathBreweries = os.path.join(\"data\", \"breweries.csv\")\n",
    "pathOpenBeer = os.path.join(\"data\", \"open-beer-database.csv\")\n",
    "pathRecipe = os.path.join(\"data\", \"recipeData.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Load Beer file into DataFrame and clean</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>Unnamed: 0</th>\n",
       "      <th>abv</th>\n",
       "      <th>ibu</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>style</th>\n",
       "      <th>brewery_id</th>\n",
       "      <th>ounces</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1583</th>\n",
       "      <td>1583</td>\n",
       "      <td>0.065</td>\n",
       "      <td>65.0</td>\n",
       "      <td>1</td>\n",
       "      <td>Dale's Pale Ale</td>\n",
       "      <td>American Pale Ale (APA)</td>\n",
       "      <td>166</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1582</th>\n",
       "      <td>1582</td>\n",
       "      <td>0.087</td>\n",
       "      <td>85.0</td>\n",
       "      <td>4</td>\n",
       "      <td>Gordon Ale (2009)</td>\n",
       "      <td>American Double / Imperial IPA</td>\n",
       "      <td>166</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1581</th>\n",
       "      <td>1581</td>\n",
       "      <td>0.080</td>\n",
       "      <td>35.0</td>\n",
       "      <td>5</td>\n",
       "      <td>Old Chub</td>\n",
       "      <td>Scottish Ale</td>\n",
       "      <td>166</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1580</th>\n",
       "      <td>1580</td>\n",
       "      <td>0.099</td>\n",
       "      <td>100.0</td>\n",
       "      <td>6</td>\n",
       "      <td>GUBNA Imperial IPA</td>\n",
       "      <td>American Double / Imperial IPA</td>\n",
       "      <td>166</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1579</th>\n",
       "      <td>1579</td>\n",
       "      <td>0.053</td>\n",
       "      <td>35.0</td>\n",
       "      <td>7</td>\n",
       "      <td>Mama's Little Yella Pils</td>\n",
       "      <td>Czech Pilsener</td>\n",
       "      <td>166</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0    abv    ibu  id                      name  \\\n",
       "1583        1583  0.065   65.0   1           Dale's Pale Ale   \n",
       "1582        1582  0.087   85.0   4         Gordon Ale (2009)   \n",
       "1581        1581  0.080   35.0   5                  Old Chub   \n",
       "1580        1580  0.099  100.0   6        GUBNA Imperial IPA   \n",
       "1579        1579  0.053   35.0   7  Mama's Little Yella Pils   \n",
       "\n",
       "                               style  brewery_id  ounces  \n",
       "1583         American Pale Ale (APA)         166    12.0  \n",
       "1582  American Double / Imperial IPA         166    12.0  \n",
       "1581                    Scottish Ale         166    12.0  \n",
       "1580  American Double / Imperial IPA         166    12.0  \n",
       "1579                  Czech Pilsener         166    12.0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "beersDF = pd.read_csv(pathBeers)\n",
    "beersDF = beersDF.drop_duplicates(subset=['id'])\n",
    "beersDF.sort_values(by=[\"id\"]).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Load Breweries file into DataFrame and clean</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>id</th>\n",
       "      <th>name</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>NorthGate Brewing</td>\n",
       "      <td>Minneapolis</td>\n",
       "      <td>MN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Against the Grain Brewery</td>\n",
       "      <td>Louisville</td>\n",
       "      <td>KY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Jack's Abby Craft Lagers</td>\n",
       "      <td>Framingham</td>\n",
       "      <td>MA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Mike Hess Brewing Company</td>\n",
       "      <td>San Diego</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Fort Point Beer Company</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>162</td>\n",
       "      <td>Right Brain Brewery</td>\n",
       "      <td>Traverse City</td>\n",
       "      <td>MI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>163</td>\n",
       "      <td>Sly Fox Brewing Company</td>\n",
       "      <td>Phoenixville</td>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>164</td>\n",
       "      <td>Round Guys Brewing</td>\n",
       "      <td>Lansdale</td>\n",
       "      <td>PA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>165</td>\n",
       "      <td>Great Crescent Brewery</td>\n",
       "      <td>Aurora</td>\n",
       "      <td>IN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>166</td>\n",
       "      <td>Oskar Blues Brewery</td>\n",
       "      <td>Longmont</td>\n",
       "      <td>CO</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>167 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      id                       name           city state\n",
       "0      0         NorthGate Brewing     Minneapolis    MN\n",
       "1      1  Against the Grain Brewery     Louisville    KY\n",
       "2      2   Jack's Abby Craft Lagers     Framingham    MA\n",
       "3      3  Mike Hess Brewing Company      San Diego    CA\n",
       "4      4    Fort Point Beer Company  San Francisco    CA\n",
       "..   ...                        ...            ...   ...\n",
       "162  162        Right Brain Brewery  Traverse City    MI\n",
       "163  163    Sly Fox Brewing Company   Phoenixville    PA\n",
       "164  164         Round Guys Brewing       Lansdale    PA\n",
       "165  165     Great Crescent Brewery         Aurora    IN\n",
       "166  166        Oskar Blues Brewery       Longmont    CO\n",
       "\n",
       "[167 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "breweriesDF = pd.read_csv(pathBreweries)\n",
    "breweriesDF = breweriesDF.rename(columns={\"Unnamed: 0\": \"id\"})\n",
    "breweriesDF = breweriesDF.drop_duplicates(subset=['id'])\n",
    "breweriesDF.head(167)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Load OpenBeer file into DataFrame and clean</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Name</th>\n",
       "      <th>id</th>\n",
       "      <th>Alcohol_By_Vol</th>\n",
       "      <th>IBU</th>\n",
       "      <th>Style</th>\n",
       "      <th>style_id</th>\n",
       "      <th>Category</th>\n",
       "      <th>Brewer</th>\n",
       "      <th>brewery_id</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Coordinates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>Hocus Pocus</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>Light American Wheat Ale or Lager</td>\n",
       "      <td>116</td>\n",
       "      <td>Other Style</td>\n",
       "      <td>Magic Hat</td>\n",
       "      <td>812</td>\n",
       "      <td>5 Bartlett Bay Road</td>\n",
       "      <td>South Burlington</td>\n",
       "      <td>Vermont</td>\n",
       "      <td>United States</td>\n",
       "      <td>44.4284, -73.2131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>Grimbergen Blonde</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>na</td>\n",
       "      <td>-1</td>\n",
       "      <td>na</td>\n",
       "      <td>Brouwerij Alken-Maes</td>\n",
       "      <td>264</td>\n",
       "      <td>Rue Derbque 7</td>\n",
       "      <td>Jumet</td>\n",
       "      <td>Hainaut</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>50.4431, 4.4147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2937</th>\n",
       "      <td>Widdershins Barleywine</td>\n",
       "      <td>3</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>na</td>\n",
       "      <td>-1</td>\n",
       "      <td>na</td>\n",
       "      <td>Left Hand Brewing Company</td>\n",
       "      <td>779</td>\n",
       "      <td>1265 Boston Avenue</td>\n",
       "      <td>Longmont</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>United States</td>\n",
       "      <td>40.1587, -105.113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2938</th>\n",
       "      <td>Lucifer</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>na</td>\n",
       "      <td>-1</td>\n",
       "      <td>na</td>\n",
       "      <td>Brouwerij Liefmans</td>\n",
       "      <td>287</td>\n",
       "      <td>200 Aalststraat</td>\n",
       "      <td>Oudenaarde</td>\n",
       "      <td>Oost-Vlaanderen</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>50.8439, 3.617</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2082</th>\n",
       "      <td>Bitter</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>na</td>\n",
       "      <td>-1</td>\n",
       "      <td>na</td>\n",
       "      <td>Ridgeway Brewing</td>\n",
       "      <td>1056</td>\n",
       "      <td>6 Chapel Close</td>\n",
       "      <td>South Stoke</td>\n",
       "      <td>Oxford</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>51.5462, -1.1355</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Name  id  Alcohol_By_Vol  IBU  \\\n",
       "391              Hocus Pocus   1               5    0   \n",
       "473        Grimbergen Blonde   2               7    0   \n",
       "2937  Widdershins Barleywine   3               9    0   \n",
       "2938                 Lucifer   4               9    0   \n",
       "2082                  Bitter   5               4    0   \n",
       "\n",
       "                                  Style  style_id     Category  \\\n",
       "391   Light American Wheat Ale or Lager       116  Other Style   \n",
       "473                                  na        -1           na   \n",
       "2937                                 na        -1           na   \n",
       "2938                                 na        -1           na   \n",
       "2082                                 na        -1           na   \n",
       "\n",
       "                         Brewer  brewery_id              Address  \\\n",
       "391                   Magic Hat         812  5 Bartlett Bay Road   \n",
       "473        Brouwerij Alken-Maes         264        Rue Derbque 7   \n",
       "2937  Left Hand Brewing Company         779   1265 Boston Avenue   \n",
       "2938         Brouwerij Liefmans         287      200 Aalststraat   \n",
       "2082           Ridgeway Brewing        1056       6 Chapel Close   \n",
       "\n",
       "                  City            State         Country        Coordinates  \n",
       "391   South Burlington          Vermont   United States  44.4284, -73.2131  \n",
       "473              Jumet          Hainaut         Belgium    50.4431, 4.4147  \n",
       "2937          Longmont         Colorado   United States  40.1587, -105.113  \n",
       "2938        Oudenaarde  Oost-Vlaanderen         Belgium     50.8439, 3.617  \n",
       "2082       South Stoke           Oxford  United Kingdom   51.5462, -1.1355  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "openBeerDF = pd.read_csv(pathOpenBeer)\n",
    "targetColumns = [\"Name\", \"id\", \"Alcohol_By_Vol\", \"IBU\", \"Style\", \"style_id\", \"Category\",\"Brewer\",\"brewery_id\", \"Address\", \"City\", \"State\", \"Country\", \"Coordinates\"]\n",
    "openBeerDF = openBeerDF[targetColumns]\n",
    "openBeerDF = openBeerDF.drop_duplicates(subset=['id'])\n",
    "openBeerDF.sort_values(by=[\"id\"]).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Load Recipe file into DataFrame and clean</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>BeerID</th>\n",
       "      <th>Name</th>\n",
       "      <th>Style</th>\n",
       "      <th>StyleID</th>\n",
       "      <th>OG</th>\n",
       "      <th>FG</th>\n",
       "      <th>ABV</th>\n",
       "      <th>IBU</th>\n",
       "      <th>Color</th>\n",
       "      <th>Efficiency</th>\n",
       "      <th>BrewMethod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Vanilla Cream Ale</td>\n",
       "      <td>Cream Ale</td>\n",
       "      <td>45</td>\n",
       "      <td>1.055</td>\n",
       "      <td>1.013</td>\n",
       "      <td>5.48</td>\n",
       "      <td>17.65</td>\n",
       "      <td>4.83</td>\n",
       "      <td>70.0</td>\n",
       "      <td>All Grain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Southern Tier Pumking clone</td>\n",
       "      <td>Holiday/Winter Special Spiced Beer</td>\n",
       "      <td>85</td>\n",
       "      <td>1.083</td>\n",
       "      <td>1.021</td>\n",
       "      <td>8.16</td>\n",
       "      <td>60.65</td>\n",
       "      <td>15.64</td>\n",
       "      <td>70.0</td>\n",
       "      <td>All Grain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Zombie Dust Clone - EXTRACT</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>7</td>\n",
       "      <td>1.063</td>\n",
       "      <td>1.018</td>\n",
       "      <td>5.91</td>\n",
       "      <td>59.25</td>\n",
       "      <td>8.98</td>\n",
       "      <td>70.0</td>\n",
       "      <td>extract</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Zombie Dust Clone - ALL GRAIN</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>7</td>\n",
       "      <td>1.061</td>\n",
       "      <td>1.017</td>\n",
       "      <td>5.80</td>\n",
       "      <td>54.48</td>\n",
       "      <td>8.50</td>\n",
       "      <td>70.0</td>\n",
       "      <td>All Grain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Bakke Brygg Belgisk Blonde 50 l</td>\n",
       "      <td>Belgian Blond Ale</td>\n",
       "      <td>20</td>\n",
       "      <td>1.060</td>\n",
       "      <td>1.010</td>\n",
       "      <td>6.48</td>\n",
       "      <td>17.84</td>\n",
       "      <td>4.57</td>\n",
       "      <td>72.0</td>\n",
       "      <td>All Grain</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   BeerID                             Name  \\\n",
       "0       1                Vanilla Cream Ale   \n",
       "1       2      Southern Tier Pumking clone   \n",
       "2       3      Zombie Dust Clone - EXTRACT   \n",
       "3       4    Zombie Dust Clone - ALL GRAIN   \n",
       "4       5  Bakke Brygg Belgisk Blonde 50 l   \n",
       "\n",
       "                                Style  StyleID     OG     FG   ABV    IBU  \\\n",
       "0                           Cream Ale       45  1.055  1.013  5.48  17.65   \n",
       "1  Holiday/Winter Special Spiced Beer       85  1.083  1.021  8.16  60.65   \n",
       "2                        American IPA        7  1.063  1.018  5.91  59.25   \n",
       "3                        American IPA        7  1.061  1.017  5.80  54.48   \n",
       "4                   Belgian Blond Ale       20  1.060  1.010  6.48  17.84   \n",
       "\n",
       "   Color  Efficiency BrewMethod  \n",
       "0   4.83        70.0  All Grain  \n",
       "1  15.64        70.0  All Grain  \n",
       "2   8.98        70.0    extract  \n",
       "3   8.50        70.0  All Grain  \n",
       "4   4.57        72.0  All Grain  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "recipesDF = pd.read_csv(pathRecipe, encoding = \"ISO-8859-1\")\n",
    "recipesDF = recipesDF[[\"BeerID\", \"Name\", \"Style\", \"StyleID\",\"OG\", \"FG\", \"ABV\",\"IBU\", \"Color\", \"Efficiency\", \"BrewMethod\" ]]\n",
    "recipesDF = recipesDF.drop_duplicates(subset=['BeerID'])\n",
    "recipesDF.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Create a connection to SQL database</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "pg_user = 'postgres'\n",
    "pg_password = pgPassword\n",
    "db_name = 'beersDB'\n",
    "\n",
    "connection_string = f\"{pg_user}:{pg_password}@localhost:5432/{db_name}\"\n",
    "engine = create_engine(f'postgresql://{connection_string}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "engine.table_names()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Add dataframes to SQL database</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "beersDF.to_sql(name = \"beers\", con=engine, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "breweriesDF.to_sql(name = \"breweries\", con=engine, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "openBeerDF.to_sql(name = \"openBeer\", con=engine, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "recipesDF.to_sql(name = \"recipes\", con=engine, if_exists='append', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['beers', 'breweries', 'openBeer', 'recipes']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "engine.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>Unnamed: 0</th>\n",
       "      <th>abv</th>\n",
       "      <th>ibu</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>style</th>\n",
       "      <th>brewery_id</th>\n",
       "      <th>ounces</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0.050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1436</td>\n",
       "      <td>Pub Beer</td>\n",
       "      <td>American Pale Lager</td>\n",
       "      <td>408</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0.066</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2265</td>\n",
       "      <td>Devil's Cup</td>\n",
       "      <td>American Pale Ale (APA)</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0.071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2264</td>\n",
       "      <td>Rise of the Phoenix</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0.090</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2263</td>\n",
       "      <td>Sinister</td>\n",
       "      <td>American Double / Imperial IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2262</td>\n",
       "      <td>Sex and Candy</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0    abv  ibu    id                 name  \\\n",
       "0           0  0.050  NaN  1436             Pub Beer   \n",
       "1           1  0.066  NaN  2265          Devil's Cup   \n",
       "2           2  0.071  NaN  2264  Rise of the Phoenix   \n",
       "3           3  0.090  NaN  2263             Sinister   \n",
       "4           4  0.075  NaN  2262        Sex and Candy   \n",
       "\n",
       "                            style  brewery_id  ounces  \n",
       "0             American Pale Lager         408    12.0  \n",
       "1         American Pale Ale (APA)         177    12.0  \n",
       "2                    American IPA         177    12.0  \n",
       "3  American Double / Imperial IPA         177    12.0  \n",
       "4                    American IPA         177    12.0  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql_query('select * from beers', con=engine).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Pull SQL table back into DataFrame</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>Unnamed: 0</th>\n",
       "      <th>abv</th>\n",
       "      <th>ibu</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>style</th>\n",
       "      <th>brewery_id</th>\n",
       "      <th>ounces</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0.050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1436</td>\n",
       "      <td>Pub Beer</td>\n",
       "      <td>American Pale Lager</td>\n",
       "      <td>408</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>0.066</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2265</td>\n",
       "      <td>Devil's Cup</td>\n",
       "      <td>American Pale Ale (APA)</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0.071</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2264</td>\n",
       "      <td>Rise of the Phoenix</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0.090</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2263</td>\n",
       "      <td>Sinister</td>\n",
       "      <td>American Double / Imperial IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>0.075</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2262</td>\n",
       "      <td>Sex and Candy</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>177</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0    abv  ibu    id                 name  \\\n",
       "0           0  0.050  NaN  1436             Pub Beer   \n",
       "1           1  0.066  NaN  2265          Devil's Cup   \n",
       "2           2  0.071  NaN  2264  Rise of the Phoenix   \n",
       "3           3  0.090  NaN  2263             Sinister   \n",
       "4           4  0.075  NaN  2262        Sex and Candy   \n",
       "\n",
       "                            style  brewery_id  ounces  \n",
       "0             American Pale Lager         408    12.0  \n",
       "1         American Pale Ale (APA)         177    12.0  \n",
       "2                    American IPA         177    12.0  \n",
       "3  American Double / Imperial IPA         177    12.0  \n",
       "4                    American IPA         177    12.0  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newBeerDF = pd.read_sql_table('beers', con=engine)\n",
    "newBeerDF.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<h4>Convert Dataframe to Dictionary</h4>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Unnamed: 0': 0, 'abv': 0.05, 'ibu': nan, 'id': 1436, 'name': 'Pub Beer', 'style': 'American Pale Lager', 'brewery_id': 408, 'ounces': 12.0}\n"
     ]
    }
   ],
   "source": [
    "newBeerDict = newBeerDF.to_dict('records')\n",
    "print(newBeerDict[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Brewer</th>\n",
       "      <th>Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State</th>\n",
       "      <th>Country</th>\n",
       "      <th>Coordinates</th>\n",
       "      <th>beer</th>\n",
       "      <th>style</th>\n",
       "      <th>brewery</th>\n",
       "      <th>abv</th>\n",
       "      <th>ibu</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Carolina Brewery</td>\n",
       "      <td>460 West Franklin Street</td>\n",
       "      <td>Chapel Hill</td>\n",
       "      <td>North Carolina</td>\n",
       "      <td>United States</td>\n",
       "      <td>35.9103, -79.0632</td>\n",
       "      <td>Santa's Secret</td>\n",
       "      <td>Winter Warmer</td>\n",
       "      <td>Carolina Brewery</td>\n",
       "      <td>0.059</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>471 Kalamath Street</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>United States</td>\n",
       "      <td>39.7236, -105.001</td>\n",
       "      <td>Agave Wheat</td>\n",
       "      <td>American Pale Wheat Ale</td>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>0.042</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>471 Kalamath Street</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>United States</td>\n",
       "      <td>39.7236, -105.001</td>\n",
       "      <td>SummerBright Ale</td>\n",
       "      <td>American Pale Wheat Ale</td>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>0.045</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>471 Kalamath Street</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>United States</td>\n",
       "      <td>39.7236, -105.001</td>\n",
       "      <td>Lucky U IPA</td>\n",
       "      <td>American IPA</td>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>0.062</td>\n",
       "      <td>68.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>471 Kalamath Street</td>\n",
       "      <td>Denver</td>\n",
       "      <td>Colorado</td>\n",
       "      <td>United States</td>\n",
       "      <td>39.7236, -105.001</td>\n",
       "      <td>Avalanche Ale</td>\n",
       "      <td>American Amber / Red Ale</td>\n",
       "      <td>Breckenridge Brewery</td>\n",
       "      <td>0.054</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Brewer                   Address         City  \\\n",
       "15      Carolina Brewery  460 West Franklin Street  Chapel Hill   \n",
       "27  Breckenridge Brewery       471 Kalamath Street       Denver   \n",
       "28  Breckenridge Brewery       471 Kalamath Street       Denver   \n",
       "29  Breckenridge Brewery       471 Kalamath Street       Denver   \n",
       "30  Breckenridge Brewery       471 Kalamath Street       Denver   \n",
       "\n",
       "             State        Country        Coordinates              beer  \\\n",
       "15  North Carolina  United States  35.9103, -79.0632    Santa's Secret   \n",
       "27        Colorado  United States  39.7236, -105.001       Agave Wheat   \n",
       "28        Colorado  United States  39.7236, -105.001  SummerBright Ale   \n",
       "29        Colorado  United States  39.7236, -105.001       Lucky U IPA   \n",
       "30        Colorado  United States  39.7236, -105.001     Avalanche Ale   \n",
       "\n",
       "                       style               brewery    abv   ibu  \n",
       "15             Winter Warmer      Carolina Brewery  0.059  22.0  \n",
       "27   American Pale Wheat Ale  Breckenridge Brewery  0.042   9.0  \n",
       "28   American Pale Wheat Ale  Breckenridge Brewery  0.045  15.0  \n",
       "29              American IPA  Breckenridge Brewery  0.062  68.0  \n",
       "30  American Amber / Red Ale  Breckenridge Brewery  0.054  19.0  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "beersAndBreweries = pd.merge(left = beersDF, right = breweriesDF, how=\"inner\", left_on=\"brewery_id\", right_on = \"id\")\n",
    "beersAndBreweries = beersAndBreweries[[\"name_x\", \"style\", \"name_y\", \"abv\", \"ibu\"]]\n",
    "beersAndBreweries = beersAndBreweries.rename(columns = {\"name_x\": \"beer\",\n",
    "                                                       \"name_y\": \"brewery\"})\n",
    "beersAndBreweries.head()\n",
    "\n",
    "breweryLocations = openBeerDF[[\"Brewer\", \"Address\", \"City\", \"State\", \"Country\", \"Coordinates\"]]\n",
    "\n",
    "joinedDF = pd.merge(left = breweryLocations, right = beersAndBreweries, how=\"inner\", left_on=\"Brewer\", right_on = \"brewery\")\n",
    "\n",
    "noNulls = joinedDF.dropna().drop_duplicates()\n",
    "\n",
    "noNulls.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Carolina Brewery\n",
      "Breckenridge Brewery\n",
      "Breckenridge Brewery\n",
      "Breckenridge Brewery\n",
      "Breckenridge Brewery\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Nebraska Brewing Company\n",
      "Deschutes Brewery\n",
      "Flying Dog Brewery\n",
      "Flying Dog Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "Stevens Point Brewery\n",
      "O'Fallon Brewery\n",
      "O'Fallon Brewery\n",
      "Capital Brewery\n",
      "Capital Brewery\n",
      "Capital Brewery\n",
      "Capital Brewery\n",
      "Capital Brewery\n",
      "Boulder Beer Company\n",
      "Boulder Beer Company\n",
      "Boulder Beer Company\n",
      "Boulevard Brewing Company\n",
      "Boston Beer Company\n",
      "Boston Beer Company\n",
      "Boston Beer Company\n",
      "Boston Beer Company\n",
      "Boston Beer Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Real Ale Brewing Company\n",
      "Avery Brewing Company\n",
      "Avery Brewing Company\n",
      "Avery Brewing Company\n",
      "Avery Brewing Company\n",
      "Firestone Walker Brewing Company\n",
      "Firestone Walker Brewing Company\n",
      "Firestone Walker Brewing Company\n",
      "Brooklyn Brewery\n",
      "Rahr & Sons Brewing Company\n",
      "Abita Brewing Company\n",
      "Abita Brewing Company\n",
      "Abita Brewing Company\n",
      "Seabright Brewery\n",
      "The Alchemist\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Hopworks Urban Brewery\n",
      "Santa Fe Brewing Company\n",
      "Santa Fe Brewing Company\n",
      "Twisted Pine Brewing Company\n",
      "Utah Brewers Cooperative\n",
      "Utah Brewers Cooperative\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Southern Star Brewing Company\n",
      "Straub Brewery\n",
      "Straub Brewery\n",
      "Straub Brewery\n",
      "Ska Brewing Company\n",
      "Ska Brewing Company\n",
      "Ska Brewing Company\n",
      "Ska Brewing Company\n",
      "Aviator Brewing Company\n",
      "Aviator Brewing Company\n",
      "Aviator Brewing Company\n",
      "Aviator Brewing Company\n",
      "Aviator Brewing Company\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Sixpoint Craft Ales\n",
      "Gore Range Brewery\n",
      "Aspen Brewing Company\n",
      "Aspen Brewing Company\n"
     ]
    }
   ],
   "source": [
    "for i, r in noNulls.iterrows():\n",
    "    print(r[\"Brewer\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}