SwinePriceWorld_Halfway.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1.Scrapping data from wbesite"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. Importing libraries essetial to scrapping"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2. Pointing url to fetch data from"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://www.pig333.com/markets_and_prices/'\n",
    "response = requests.get(url)\n",
    "\n",
    "soup = BeautifulSoup(response.text, \"html.parser\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "3. Locating tags where the data in relevant fetching into a dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "markets = []\n",
    "listings = soup.find('div', {'class': 'contingut'}).find_all('div', {'class': 'preu_mercat'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[]\n"
     ]
    }
   ],
   "source": [
    "print(markets)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "4. Fetching data from located tags in the HTML into a proper dataframe."
   ]
  },
  {
   "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>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Belgium - Danis</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>0.960</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>10.50</td>\n",
       "      <td>DKK</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 60%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>France - MPB</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>1.293</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 56 TMV</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Germany</td>\n",
       "      <td>5 Aug</td>\n",
       "      <td>1.470</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Italy</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.325</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>160/176 kg Live</td>\n",
       "      <td>3.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Netherlands - Beursprijs</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>1.050</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Poland</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>6.441</td>\n",
       "      <td>PLN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>2.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Romania</td>\n",
       "      <td>24 Jul</td>\n",
       "      <td>536.79</td>\n",
       "      <td>RON</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Russia</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>112.20</td>\n",
       "      <td>RUB</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>6.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Spain - Lleida</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.300</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1 Aug</td>\n",
       "      <td>164.68</td>\n",
       "      <td>GBX</td>\n",
       "      <td>kg</td>\n",
       "      <td>SPP Euro Spec</td>\n",
       "      <td>0.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>46.30</td>\n",
       "      <td>UAH</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.6%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>65.81</td>\n",
       "      <td>ARS</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>8.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Brazil - Paraná</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>6.140</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>1.5%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Brazil - Santa Catarina</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>6.610</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Canada - Ontario</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>127.01</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>6.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Canada - Quebec</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>148.18</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>4.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chile</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>1320</td>\n",
       "      <td>CLP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>3.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>5444</td>\n",
       "      <td>COP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mexico - Sonora</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>25.40</td>\n",
       "      <td>MXN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.2%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USA - Iowa/Minnesota</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>38.81</td>\n",
       "      <td>USD</td>\n",
       "      <td>cwt</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>China</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>36.94</td>\n",
       "      <td>CNY</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>4279</td>\n",
       "      <td>KRW</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.7%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     country    date   price  CUR   unit        reference  \\\n",
       "0            Belgium - Danis   6 Aug   0.960  EUR     kg             Live   \n",
       "1                    Denmark   6 Aug   10.50  DKK     kg      Carcass 60%   \n",
       "2               France - MPB   3 Aug   1.293  EUR     kg   Carcass 56 TMV   \n",
       "3                    Germany   5 Aug   1.470  EUR     kg      Carcass 57%   \n",
       "4                      Italy   6 Aug   1.325  EUR     kg  160/176 kg Live   \n",
       "5   Netherlands - Beursprijs  31 Jul   1.050  EUR     kg             Live   \n",
       "6                     Poland  31 Jul   6.441  PLN     kg      Carcass 57%   \n",
       "7                    Romania  24 Jul  536.79  RON  100kg             Live   \n",
       "8                     Russia  29 Jul  112.20  RUB     kg             Live   \n",
       "9             Spain - Lleida   6 Aug   1.300  EUR     kg             Live   \n",
       "10            United Kingdom   1 Aug  164.68  GBX     kg    SPP Euro Spec   \n",
       "11                   Ukraine  31 Jul   46.30  UAH     kg             Live   \n",
       "12                 Argentine  31 Jul   65.81  ARS     kg             Live   \n",
       "13           Brazil - Paraná   3 Aug   6.140  BRL     kg             Live   \n",
       "14   Brazil - Santa Catarina   6 Aug   6.610  BRL     kg             Live   \n",
       "15          Canada - Ontario  31 Jul  127.01  CAD  100kg          Carcass   \n",
       "16           Canada - Quebec   7 Aug  148.18  CAD  100kg          Carcass   \n",
       "17                     Chile   7 Aug    1320  CLP     kg             Live   \n",
       "18                  Colombia   7 Aug    5444  COP     kg             Live   \n",
       "19           Mexico - Sonora  31 Jul   25.40  MXN     kg             Live   \n",
       "20      USA - Iowa/Minnesota   6 Aug   38.81  USD    cwt          Carcass   \n",
       "21                     China  29 Jul   36.94  CNY     kg             Live   \n",
       "22               South Korea   6 Aug    4279  KRW     kg          Carcass   \n",
       "\n",
       "   variation  \n",
       "0         0%  \n",
       "1         0%  \n",
       "2         0%  \n",
       "3         0%  \n",
       "4       3.9%  \n",
       "5         0%  \n",
       "6       2.9%  \n",
       "7       2.0%  \n",
       "8       6.8%  \n",
       "9         0%  \n",
       "10      0.3%  \n",
       "11      4.6%  \n",
       "12      8.8%  \n",
       "13      1.5%  \n",
       "14      4.3%  \n",
       "15      6.1%  \n",
       "16      4.9%  \n",
       "17      3.1%  \n",
       "18      0.4%  \n",
       "19      4.2%  \n",
       "20      2.0%  \n",
       "21      0.4%  \n",
       "22      2.7%  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for item in listings:\n",
    "    market = {}\n",
    "\n",
    "    market['country'] = item.find('a', {'class': 'titol'}).getText()\n",
    "    market['date'] = item.select('.col-titol > span.data')[0].getText()\n",
    "    market['price'] = item.find('span', {'class': 'preu'}).getText()\n",
    "    market['CUR'] = item.find('span', {'class': 'moneda'}).getText()\n",
    "    market['unit'] = item.find('span', {'class': 'unitats'}).getText()\n",
    "    market['reference'] = item.find('span', {'class': 'data fs9'}).getText()\n",
    "    market['variation'] = item.find('span', {'class': 'perc'}).getText()\n",
    "\n",
    "    markets.append(market)\n",
    "  \n",
    "\n",
    "pricing = pd.DataFrame(markets)\n",
    "pricing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'country': 'South Korea', 'date': '6 Aug', 'price': '4279', 'CUR': 'KRW', 'unit': 'kg', 'reference': 'Carcass', 'variation': ' 2.7%'}\n"
     ]
    }
   ],
   "source": [
    "print(market)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "pricing['price'] = pricing['price'].astype(float)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "5. Create Unit equalizing column"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Find the price units that  distorts (dressing percentage) the value of the dafult price of a pig at the gate and equalize it for a price per kilo to into all currencies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Romania</td>\n",
       "      <td>24 Jul</td>\n",
       "      <td>536.79</td>\n",
       "      <td>RON</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Canada - Ontario</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>127.01</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>6.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Canada - Quebec</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>148.18</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>4.9%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             country    date   price  CUR   unit reference variation\n",
       "7            Romania  24 Jul  536.79  RON  100kg      Live      2.0%\n",
       "15  Canada - Ontario  31 Jul  127.01  CAD  100kg   Carcass      6.1%\n",
       "16   Canada - Quebec   7 Aug  148.18  CAD  100kg   Carcass      4.9%"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "treat_price=pricing.loc[(pricing['unit']=='100kg')]\n",
    "treat_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7     536.79\n",
       "15    127.01\n",
       "16    148.18\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "treat_price.price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7     5.3679\n",
       "15    1.2701\n",
       "16    1.4818\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correct_price = treat_price.price.div(100)\n",
    "correct_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USA - Iowa/Minnesota</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>38.81</td>\n",
       "      <td>USD</td>\n",
       "      <td>cwt</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 country   date  price  CUR unit reference variation\n",
       "20  USA - Iowa/Minnesota  6 Aug  38.81  USD  cwt   Carcass      2.0%"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "treat_price2=pricing.loc[(pricing['unit']=='cwt')]\n",
    "treat_price2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20    0.763946\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correct_price2 = treat_price2.price.div(50.802)\n",
    "correct_price2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1 Aug</td>\n",
       "      <td>164.68</td>\n",
       "      <td>GBX</td>\n",
       "      <td>kg</td>\n",
       "      <td>SPP Euro Spec</td>\n",
       "      <td>0.3%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           country   date   price  CUR unit      reference variation\n",
       "10  United Kingdom  1 Aug  164.68  GBX   kg  SPP Euro Spec      0.3%"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "treat_price3=pricing.loc[(pricing['CUR']=='GBX')]\n",
    "treat_price3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10    1.6468\n",
       "Name: price, dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "correct_price3 = treat_price3.price.div(100)\n",
    "correct_price3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "pricing.update(correct_price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "pricing.update(correct_price2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "pricing.update(correct_price3)"
   ]
  },
  {
   "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>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Belgium - Danis</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>0.960000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>DKK</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 60%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>France - MPB</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>1.293000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 56 TMV</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Germany</td>\n",
       "      <td>5 Aug</td>\n",
       "      <td>1.470000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Italy</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.325000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>160/176 kg Live</td>\n",
       "      <td>3.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Netherlands - Beursprijs</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>1.050000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Poland</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>6.441000</td>\n",
       "      <td>PLN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>2.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Romania</td>\n",
       "      <td>24 Jul</td>\n",
       "      <td>5.367900</td>\n",
       "      <td>RON</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Russia</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>112.200000</td>\n",
       "      <td>RUB</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>6.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Spain - Lleida</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.300000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1 Aug</td>\n",
       "      <td>1.646800</td>\n",
       "      <td>GBX</td>\n",
       "      <td>kg</td>\n",
       "      <td>SPP Euro Spec</td>\n",
       "      <td>0.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>46.300000</td>\n",
       "      <td>UAH</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.6%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>65.810000</td>\n",
       "      <td>ARS</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>8.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Brazil - Paraná</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>6.140000</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>1.5%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Brazil - Santa Catarina</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>6.610000</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Canada - Ontario</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>1.270100</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>6.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Canada - Quebec</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>1.481800</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>4.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chile</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>1320.000000</td>\n",
       "      <td>CLP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>3.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>5444.000000</td>\n",
       "      <td>COP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mexico - Sonora</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>25.400000</td>\n",
       "      <td>MXN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.2%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USA - Iowa/Minnesota</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>0.763946</td>\n",
       "      <td>USD</td>\n",
       "      <td>cwt</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>China</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>36.940000</td>\n",
       "      <td>CNY</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>4279.000000</td>\n",
       "      <td>KRW</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.7%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     country    date        price  CUR   unit  \\\n",
       "0            Belgium - Danis   6 Aug     0.960000  EUR     kg   \n",
       "1                    Denmark   6 Aug    10.500000  DKK     kg   \n",
       "2               France - MPB   3 Aug     1.293000  EUR     kg   \n",
       "3                    Germany   5 Aug     1.470000  EUR     kg   \n",
       "4                      Italy   6 Aug     1.325000  EUR     kg   \n",
       "5   Netherlands - Beursprijs  31 Jul     1.050000  EUR     kg   \n",
       "6                     Poland  31 Jul     6.441000  PLN     kg   \n",
       "7                    Romania  24 Jul     5.367900  RON  100kg   \n",
       "8                     Russia  29 Jul   112.200000  RUB     kg   \n",
       "9             Spain - Lleida   6 Aug     1.300000  EUR     kg   \n",
       "10            United Kingdom   1 Aug     1.646800  GBX     kg   \n",
       "11                   Ukraine  31 Jul    46.300000  UAH     kg   \n",
       "12                 Argentine  31 Jul    65.810000  ARS     kg   \n",
       "13           Brazil - Paraná   3 Aug     6.140000  BRL     kg   \n",
       "14   Brazil - Santa Catarina   6 Aug     6.610000  BRL     kg   \n",
       "15          Canada - Ontario  31 Jul     1.270100  CAD  100kg   \n",
       "16           Canada - Quebec   7 Aug     1.481800  CAD  100kg   \n",
       "17                     Chile   7 Aug  1320.000000  CLP     kg   \n",
       "18                  Colombia   7 Aug  5444.000000  COP     kg   \n",
       "19           Mexico - Sonora  31 Jul    25.400000  MXN     kg   \n",
       "20      USA - Iowa/Minnesota   6 Aug     0.763946  USD    cwt   \n",
       "21                     China  29 Jul    36.940000  CNY     kg   \n",
       "22               South Korea   6 Aug  4279.000000  KRW     kg   \n",
       "\n",
       "          reference variation  \n",
       "0              Live        0%  \n",
       "1       Carcass 60%        0%  \n",
       "2    Carcass 56 TMV        0%  \n",
       "3       Carcass 57%        0%  \n",
       "4   160/176 kg Live      3.9%  \n",
       "5              Live        0%  \n",
       "6       Carcass 57%      2.9%  \n",
       "7              Live      2.0%  \n",
       "8              Live      6.8%  \n",
       "9              Live        0%  \n",
       "10    SPP Euro Spec      0.3%  \n",
       "11             Live      4.6%  \n",
       "12             Live      8.8%  \n",
       "13             Live      1.5%  \n",
       "14             Live      4.3%  \n",
       "15          Carcass      6.1%  \n",
       "16          Carcass      4.9%  \n",
       "17             Live      3.1%  \n",
       "18             Live      0.4%  \n",
       "19             Live      4.2%  \n",
       "20          Carcass      2.0%  \n",
       "21             Live      0.4%  \n",
       "22          Carcass      2.7%  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pricing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "##4.1 exporting prices for swine into a CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import datetime\n",
    "\n",
    "#current_date = datetime.datetime.now()\n",
    "#filename = str(current_date.day)+str(current_date.month)+str(current_date.year)\n",
    "#pricing.to_csv(str('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetoday'+filename+ '.csv'))\n",
    "#pricing.to_csv('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetoday.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "6. Creat Currency equalizing column"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "6.1 Finding the currency conversions on a website online to keep the values always updated with FX figures"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'AED': 3.6732, 'AFN': 76.960585, 'ALL': 104.84989, 'AMD': 481.616228, 'ANG': 1.799535, 'AOA': 582.5, 'ARS': 72.890768, 'AUD': 1.396229, 'AWG': 1.8002, 'AZN': 1.7025, 'BAM': 1.658404, 'BBD': 2, 'BDT': 85.002098, 'BGN': 1.6595, 'BHD': 0.377934, 'BIF': 1933.083753, 'BMD': 1, 'BND': 1.374369, 'BOB': 6.922089, 'BRL': 5.4376, 'BSD': 1, 'BTC': 8.3408984e-05, 'BTN': 75.078502, 'BWP': 11.766676, 'BYN': 2.457009, 'BZD': 2.020749, 'CAD': 1.33781, 'CDF': 1976.961192, 'CHF': 0.913307, 'CLF': 0.028224, 'CLP': 788.79937, 'CNH': 6.966504, 'CNY': 6.9673, 'COP': 3752.895973, 'CRC': 591.136287, 'CUC': 1, 'CUP': 25.75, 'CVE': 94.37, 'CZK': 22.307001, 'DJF': 178.432371, 'DKK': 6.31735, 'DOP': 58.537022, 'DZD': 128.513438, 'EGP': 15.9553, 'ERN': 15.003119, 'ETB': 35.674655, 'EUR': 0.848088, 'FJD': 2.1178, 'FKP': 0.765239, 'GBP': 0.765239, 'GEL': 3.085, 'GGP': 0.765239, 'GHS': 5.784361, 'GIP': 0.765239, 'GMD': 51.87, 'GNF': 9671.301265, 'GTQ': 7.719181, 'GYD': 209.456937, 'HKD': 7.75055, 'HNL': 24.756107, 'HRK': 6.330268, 'HTG': 112.610241, 'HUF': 293.538, 'IDR': 14662.513787, 'ILS': 3.41096, 'IMP': 0.765239, 'INR': 74.932498, 'IQD': 1196.814173, 'IRR': 42105, 'ISK': 136.21, 'JEP': 0.765239, 'JMD': 148.758793, 'JOD': 0.709, 'JPY': 105.776, 'KES': 108, 'KGS': 76.980313, 'KHR': 4111.409803, 'KMF': 419.969922, 'KPW': 900, 'KRW': 1186.37, 'KWD': 0.3057, 'KYD': 0.835492, 'KZT': 420.841144, 'LAK': 9093.750416, 'LBP': 1515.79225, 'LKR': 185.714964, 'LRD': 199.325061, 'LSL': 17.583947, 'LYD': 1.368827, 'MAD': 9.284906, 'MDL': 16.59151, 'MGA': 3853.199464, 'MKD': 52.245105, 'MMK': 1358.904021, 'MNT': 2847.826129, 'MOP': 8.002849, 'MRO': 357, 'MRU': 38.546432, 'MUR': 39.680003, 'MVR': 15.4, 'MWK': 744.240152, 'MXN': 22.379955, 'MYR': 4.1925, 'MZN': 70.956005, 'NAD': 17.39, 'NGN': 386.72, 'NIO': 34.902759, 'NOK': 9.036245, 'NPR': 120.12839, 'NZD': 1.513569, 'OMR': 0.38498, 'PAB': 1, 'PEN': 3.551439, 'PGK': 3.527501, 'PHP': 49.168984, 'PKR': 168.824133, 'PLN': 3.743633, 'PYG': 6951.524076, 'QAR': 3.650108, 'RON': 4.1055, 'RSD': 99.775, 'RUB': 73.3099, 'RWF': 961.83687, 'SAR': 3.74995, 'SBD': 8.225909, 'SCR': 17.824908, 'SDG': 55.3, 'SEK': 8.746382, 'SGD': 1.372741, 'SHP': 0.765239, 'SLL': 9826.321355, 'SOS': 579.91808, 'SRD': 7.458, 'SSP': 130.26, 'STD': 21292.767074, 'STN': 20.9, 'SVC': 8.772116, 'SYP': 511.919948, 'SZL': 17.582644, 'THB': 31.183502, 'TJS': 10.340743, 'TMT': 3.5, 'TND': 2.724, 'TOP': 2.279305, 'TRY': 7.2798, 'TTD': 6.779982, 'TWD': 29.398998, 'TZS': 2330.850884, 'UAH': 27.714628, 'UGX': 3694.18973, 'USD': 1, 'UYU': 42.640694, 'UZS': 10263.779697, 'VEF': 248487.642241, 'VES': 270695.245074, 'VND': 23237.938539, 'VUV': 112.895876, 'WST': 2.628702, 'XAF': 556.309383, 'XAG': 0.03562142, 'XAU': 0.00049278, 'XCD': 2.70255, 'XDR': 0.709289, 'XOF': 556.309383, 'XPD': 0.00045945, 'XPF': 101.203841, 'XPT': 0.0010225, 'YER': 250.350066, 'ZAR': 17.615851, 'ZMW': 18.471232, 'ZWL': 322}\n"
     ]
    }
   ],
   "source": [
    "api_url = \"https://openexchangerates.org/api/latest.json?app_id=84f0e7f007024e6aa0c5fc52f419b104\"\n",
    "r = requests.get(api_url)\n",
    "\n",
    "r.raise_for_status()\n",
    "result = r.json()\n",
    "rates = result['rates']\n",
    "print(rates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>index</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AED</td>\n",
       "      <td>3.673200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AFN</td>\n",
       "      <td>76.960585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ALL</td>\n",
       "      <td>104.849890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AMD</td>\n",
       "      <td>481.616228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ANG</td>\n",
       "      <td>1.799535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>XPT</td>\n",
       "      <td>0.001022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>YER</td>\n",
       "      <td>250.350066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>ZAR</td>\n",
       "      <td>17.615851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>ZMW</td>\n",
       "      <td>18.471232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>ZWL</td>\n",
       "      <td>322.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>171 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    index           0\n",
       "0     AED    3.673200\n",
       "1     AFN   76.960585\n",
       "2     ALL  104.849890\n",
       "3     AMD  481.616228\n",
       "4     ANG    1.799535\n",
       "..    ...         ...\n",
       "166   XPT    0.001022\n",
       "167   YER  250.350066\n",
       "168   ZAR   17.615851\n",
       "169   ZMW   18.471232\n",
       "170   ZWL  322.000000\n",
       "\n",
       "[171 rows x 2 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usdrates = pd.DataFrame([rates])\n",
    "usdrates.T.reset_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "6.2 Selecting only the currencys I actually need conversion for the quotations I have in each country"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Filtering the ACTUAL CURRENCIES I need (16 only of actual_currencies) from the total FX rates I've have caputred"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/lstorino/opt/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0     EUR\n",
       "1     DKK\n",
       "2     EUR\n",
       "3     EUR\n",
       "4     EUR\n",
       "5     EUR\n",
       "6     PLN\n",
       "7     RON\n",
       "8     RUB\n",
       "9     EUR\n",
       "10    GBP\n",
       "11    UAH\n",
       "12    ARS\n",
       "13    BRL\n",
       "14    BRL\n",
       "15    CAD\n",
       "16    CAD\n",
       "17    CLP\n",
       "18    COP\n",
       "19    MXN\n",
       "20    USD\n",
       "21    CNY\n",
       "22    KRW\n",
       "Name: CUR, dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "actual_currency = pricing['CUR']\n",
    "actual_currency[10]='GBP'\n",
    "actual_currency"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "actual_currency_list = list(actual_currency)\n",
    "usd_daily_rate=usdrates[actual_currency_list]\n",
    "usd_d_rates = usd_daily_rate.T.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>index</th>\n",
       "      <th>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DKK</td>\n",
       "      <td>6.317350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PLN</td>\n",
       "      <td>3.743633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RON</td>\n",
       "      <td>4.105500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>RUB</td>\n",
       "      <td>73.309900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GBP</td>\n",
       "      <td>0.765239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>UAH</td>\n",
       "      <td>27.714628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ARS</td>\n",
       "      <td>72.890768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRL</td>\n",
       "      <td>5.437600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BRL</td>\n",
       "      <td>5.437600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CAD</td>\n",
       "      <td>1.337810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CAD</td>\n",
       "      <td>1.337810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CLP</td>\n",
       "      <td>788.799370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>COP</td>\n",
       "      <td>3752.895973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>MXN</td>\n",
       "      <td>22.379955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USD</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CNY</td>\n",
       "      <td>6.967300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>KRW</td>\n",
       "      <td>1186.370000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index            0\n",
       "0    EUR     0.848088\n",
       "1    DKK     6.317350\n",
       "2    EUR     0.848088\n",
       "3    EUR     0.848088\n",
       "4    EUR     0.848088\n",
       "5    EUR     0.848088\n",
       "6    PLN     3.743633\n",
       "7    RON     4.105500\n",
       "8    RUB    73.309900\n",
       "9    EUR     0.848088\n",
       "10   GBP     0.765239\n",
       "11   UAH    27.714628\n",
       "12   ARS    72.890768\n",
       "13   BRL     5.437600\n",
       "14   BRL     5.437600\n",
       "15   CAD     1.337810\n",
       "16   CAD     1.337810\n",
       "17   CLP   788.799370\n",
       "18   COP  3752.895973\n",
       "19   MXN    22.379955\n",
       "20   USD     1.000000\n",
       "21   CNY     6.967300\n",
       "22   KRW  1186.370000"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usd_d_rates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>CUR</th>\n",
       "      <th>Rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DKK</td>\n",
       "      <td>6.317350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PLN</td>\n",
       "      <td>3.743633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RON</td>\n",
       "      <td>4.105500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>RUB</td>\n",
       "      <td>73.309900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>EUR</td>\n",
       "      <td>0.848088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GBP</td>\n",
       "      <td>0.765239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>UAH</td>\n",
       "      <td>27.714628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ARS</td>\n",
       "      <td>72.890768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BRL</td>\n",
       "      <td>5.437600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BRL</td>\n",
       "      <td>5.437600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CAD</td>\n",
       "      <td>1.337810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CAD</td>\n",
       "      <td>1.337810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CLP</td>\n",
       "      <td>788.799370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>COP</td>\n",
       "      <td>3752.895973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>MXN</td>\n",
       "      <td>22.379955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USD</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CNY</td>\n",
       "      <td>6.967300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>KRW</td>\n",
       "      <td>1186.370000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    CUR         Rate\n",
       "0   EUR     0.848088\n",
       "1   DKK     6.317350\n",
       "2   EUR     0.848088\n",
       "3   EUR     0.848088\n",
       "4   EUR     0.848088\n",
       "5   EUR     0.848088\n",
       "6   PLN     3.743633\n",
       "7   RON     4.105500\n",
       "8   RUB    73.309900\n",
       "9   EUR     0.848088\n",
       "10  GBP     0.765239\n",
       "11  UAH    27.714628\n",
       "12  ARS    72.890768\n",
       "13  BRL     5.437600\n",
       "14  BRL     5.437600\n",
       "15  CAD     1.337810\n",
       "16  CAD     1.337810\n",
       "17  CLP   788.799370\n",
       "18  COP  3752.895973\n",
       "19  MXN    22.379955\n",
       "20  USD     1.000000\n",
       "21  CNY     6.967300\n",
       "22  KRW  1186.370000"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usd_d_rates.rename(columns={'index': 'CUR', 0: 'Rate'},inplace = True)\n",
    "usd_d_rates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>country</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>CUR</th>\n",
       "      <th>unit</th>\n",
       "      <th>reference</th>\n",
       "      <th>variation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Belgium - Danis</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>0.960000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Denmark</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>DKK</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 60%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>France - MPB</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>1.293000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 56 TMV</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Germany</td>\n",
       "      <td>5 Aug</td>\n",
       "      <td>1.470000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Italy</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.325000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>160/176 kg Live</td>\n",
       "      <td>3.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Netherlands - Beursprijs</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>1.050000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Poland</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>6.441000</td>\n",
       "      <td>PLN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass 57%</td>\n",
       "      <td>2.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Romania</td>\n",
       "      <td>24 Jul</td>\n",
       "      <td>5.367900</td>\n",
       "      <td>RON</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Russia</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>112.200000</td>\n",
       "      <td>RUB</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>6.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Spain - Lleida</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>1.300000</td>\n",
       "      <td>EUR</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1 Aug</td>\n",
       "      <td>1.646800</td>\n",
       "      <td>GBP</td>\n",
       "      <td>kg</td>\n",
       "      <td>SPP Euro Spec</td>\n",
       "      <td>0.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>46.300000</td>\n",
       "      <td>UAH</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.6%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Argentine</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>65.810000</td>\n",
       "      <td>ARS</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>8.8%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Brazil - Paraná</td>\n",
       "      <td>3 Aug</td>\n",
       "      <td>6.140000</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>1.5%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Brazil - Santa Catarina</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>6.610000</td>\n",
       "      <td>BRL</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.3%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Canada - Ontario</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>1.270100</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>6.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Canada - Quebec</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>1.481800</td>\n",
       "      <td>CAD</td>\n",
       "      <td>100kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>4.9%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Chile</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>1320.000000</td>\n",
       "      <td>CLP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>3.1%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>7 Aug</td>\n",
       "      <td>5444.000000</td>\n",
       "      <td>COP</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mexico - Sonora</td>\n",
       "      <td>31 Jul</td>\n",
       "      <td>25.400000</td>\n",
       "      <td>MXN</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>4.2%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>USA - Iowa/Minnesota</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>0.763946</td>\n",
       "      <td>USD</td>\n",
       "      <td>cwt</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>China</td>\n",
       "      <td>29 Jul</td>\n",
       "      <td>36.940000</td>\n",
       "      <td>CNY</td>\n",
       "      <td>kg</td>\n",
       "      <td>Live</td>\n",
       "      <td>0.4%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>South Korea</td>\n",
       "      <td>6 Aug</td>\n",
       "      <td>4279.000000</td>\n",
       "      <td>KRW</td>\n",
       "      <td>kg</td>\n",
       "      <td>Carcass</td>\n",
       "      <td>2.7%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     country    date        price  CUR   unit  \\\n",
       "0            Belgium - Danis   6 Aug     0.960000  EUR     kg   \n",
       "1                    Denmark   6 Aug    10.500000  DKK     kg   \n",
       "2               France - MPB   3 Aug     1.293000  EUR     kg   \n",
       "3                    Germany   5 Aug     1.470000  EUR     kg   \n",
       "4                      Italy   6 Aug     1.325000  EUR     kg   \n",
       "5   Netherlands - Beursprijs  31 Jul     1.050000  EUR     kg   \n",
       "6                     Poland  31 Jul     6.441000  PLN     kg   \n",
       "7                    Romania  24 Jul     5.367900  RON  100kg   \n",
       "8                     Russia  29 Jul   112.200000  RUB     kg   \n",
       "9             Spain - Lleida   6 Aug     1.300000  EUR     kg   \n",
       "10            United Kingdom   1 Aug     1.646800  GBP     kg   \n",
       "11                   Ukraine  31 Jul    46.300000  UAH     kg   \n",
       "12                 Argentine  31 Jul    65.810000  ARS     kg   \n",
       "13           Brazil - Paraná   3 Aug     6.140000  BRL     kg   \n",
       "14   Brazil - Santa Catarina   6 Aug     6.610000  BRL     kg   \n",
       "15          Canada - Ontario  31 Jul     1.270100  CAD  100kg   \n",
       "16           Canada - Quebec   7 Aug     1.481800  CAD  100kg   \n",
       "17                     Chile   7 Aug  1320.000000  CLP     kg   \n",
       "18                  Colombia   7 Aug  5444.000000  COP     kg   \n",
       "19           Mexico - Sonora  31 Jul    25.400000  MXN     kg   \n",
       "20      USA - Iowa/Minnesota   6 Aug     0.763946  USD    cwt   \n",
       "21                     China  29 Jul    36.940000  CNY     kg   \n",
       "22               South Korea   6 Aug  4279.000000  KRW     kg   \n",
       "\n",
       "          reference variation  \n",
       "0              Live        0%  \n",
       "1       Carcass 60%        0%  \n",
       "2    Carcass 56 TMV        0%  \n",
       "3       Carcass 57%        0%  \n",
       "4   160/176 kg Live      3.9%  \n",
       "5              Live        0%  \n",
       "6       Carcass 57%      2.9%  \n",
       "7              Live      2.0%  \n",
       "8              Live      6.8%  \n",
       "9              Live        0%  \n",
       "10    SPP Euro Spec      0.3%  \n",
       "11             Live      4.6%  \n",
       "12             Live      8.8%  \n",
       "13             Live      1.5%  \n",
       "14             Live      4.3%  \n",
       "15          Carcass      6.1%  \n",
       "16          Carcass      4.9%  \n",
       "17             Live      3.1%  \n",
       "18             Live      0.4%  \n",
       "19             Live      4.2%  \n",
       "20          Carcass      2.0%  \n",
       "21             Live      0.4%  \n",
       "22          Carcass      2.7%  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pricing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_9490f0d4_dacb_11ea_b4a1_985aebd60274row20_col2 {\n",
       "            : ;\n",
       "            background-color:  lightblue;\n",
       "        }    #T_9490f0d4_dacb_11ea_b4a1_985aebd60274row21_col2 {\n",
       "            background-color:  yellow;\n",
       "            : ;\n",
       "        }</style><table id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274\" ><thead>    <tr>        <th class=\"col_heading level0 col0\" >country</th>        <th class=\"col_heading level0 col1\" >date</th>        <th class=\"col_heading level0 col2\" >usd_base_kg</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row0_col0\" class=\"data row0 col0\" >Belgium - Danis</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row0_col1\" class=\"data row0 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row0_col2\" class=\"data row0 col2\" >1.131958</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row1_col0\" class=\"data row1 col0\" >Denmark</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row1_col1\" class=\"data row1 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row1_col2\" class=\"data row1 col2\" >1.662089</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row2_col0\" class=\"data row2 col0\" >France - MPB</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row2_col1\" class=\"data row2 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row2_col2\" class=\"data row2 col2\" >1.524606</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row3_col0\" class=\"data row3 col0\" >Germany</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row3_col1\" class=\"data row3 col1\" >5 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row3_col2\" class=\"data row3 col2\" >1.733311</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row4_col0\" class=\"data row4 col0\" >Italy</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row4_col1\" class=\"data row4 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row4_col2\" class=\"data row4 col2\" >1.562338</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row5_col0\" class=\"data row5 col0\" >Netherlands - Beursprijs</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row5_col1\" class=\"data row5 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row5_col2\" class=\"data row5 col2\" >1.238079</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row6_col0\" class=\"data row6 col0\" >Poland</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row6_col1\" class=\"data row6 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row6_col2\" class=\"data row6 col2\" >1.720521</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row7_col0\" class=\"data row7 col0\" >Romania</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row7_col1\" class=\"data row7 col1\" >24 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row7_col2\" class=\"data row7 col2\" >1.307490</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row8_col0\" class=\"data row8 col0\" >Russia</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row8_col1\" class=\"data row8 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row8_col2\" class=\"data row8 col2\" >1.530489</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row9_col0\" class=\"data row9 col0\" >Spain - Lleida</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row9_col1\" class=\"data row9 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row9_col2\" class=\"data row9 col2\" >1.532860</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row10_col0\" class=\"data row10 col0\" >United Kingdom</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row10_col1\" class=\"data row10 col1\" >1 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row10_col2\" class=\"data row10 col2\" >2.152007</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row11_col0\" class=\"data row11 col0\" >Ukraine</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row11_col1\" class=\"data row11 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row11_col2\" class=\"data row11 col2\" >1.670598</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row12_col0\" class=\"data row12 col0\" >Argentine</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row12_col1\" class=\"data row12 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row12_col2\" class=\"data row12 col2\" >0.902858</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row13_col0\" class=\"data row13 col0\" >Brazil - Paraná</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row13_col1\" class=\"data row13 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row13_col2\" class=\"data row13 col2\" >1.129175</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row14_col0\" class=\"data row14 col0\" >Brazil - Santa Catarina</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row14_col1\" class=\"data row14 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row14_col2\" class=\"data row14 col2\" >1.215610</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row15_col0\" class=\"data row15 col0\" >Canada - Ontario</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row15_col1\" class=\"data row15 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row15_col2\" class=\"data row15 col2\" >0.949387</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row16_col0\" class=\"data row16 col0\" >Canada - Quebec</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row16_col1\" class=\"data row16 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row16_col2\" class=\"data row16 col2\" >1.107631</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row17_col0\" class=\"data row17 col0\" >Chile</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row17_col1\" class=\"data row17 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row17_col2\" class=\"data row17 col2\" >1.673429</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row18_col0\" class=\"data row18 col0\" >Colombia</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row18_col1\" class=\"data row18 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row18_col2\" class=\"data row18 col2\" >1.450613</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row19_col0\" class=\"data row19 col0\" >Mexico - Sonora</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row19_col1\" class=\"data row19 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row19_col2\" class=\"data row19 col2\" >1.134944</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row20_col0\" class=\"data row20 col0\" >USA - Iowa/Minnesota</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row20_col1\" class=\"data row20 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row20_col2\" class=\"data row20 col2\" >0.763946</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row21_col0\" class=\"data row21 col0\" >China</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row21_col1\" class=\"data row21 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row21_col2\" class=\"data row21 col2\" >5.301910</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                                <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row22_col0\" class=\"data row22 col0\" >South Korea</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row22_col1\" class=\"data row22 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9490f0d4_dacb_11ea_b4a1_985aebd60274row22_col2\" class=\"data row22 col2\" >3.606801</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd8f6ac9550>"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pricing['usd_base_kg'] = pricing.price.div(usd_d_rates.Rate)\n",
    "pig_price_kg_usd = pricing[['country','date','usd_base_kg']]\n",
    "pig_price_kg_usd.style.hide_index().highlight_max(color = 'yellow').highlight_min(color = 'lightblue')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row0_col2 {\n",
       "            background-color:  #ecf8e8;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row1_col2 {\n",
       "            background-color:  #d4eece;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row2_col2 {\n",
       "            background-color:  #dbf1d6;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row3_col2 {\n",
       "            background-color:  #d0edca;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row4_col2 {\n",
       "            background-color:  #d9f0d3;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row5_col2 {\n",
       "            background-color:  #e8f6e4;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row6_col2 {\n",
       "            background-color:  #d1edcb;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row7_col2 {\n",
       "            background-color:  #e6f5e1;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row8_col2 {\n",
       "            background-color:  #dbf1d5;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row9_col2 {\n",
       "            background-color:  #dbf1d5;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row10_col2 {\n",
       "            background-color:  #b6e2af;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row11_col2 {\n",
       "            background-color:  #d3eecd;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row12_col2 {\n",
       "            background-color:  #f3faf0;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row13_col2 {\n",
       "            background-color:  #ecf8e8;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row14_col2 {\n",
       "            background-color:  #e9f7e5;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row15_col2 {\n",
       "            background-color:  #f1faee;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row16_col2 {\n",
       "            background-color:  #ecf8e8;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row17_col2 {\n",
       "            background-color:  #d3eecd;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row18_col2 {\n",
       "            background-color:  #dff3da;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row19_col2 {\n",
       "            background-color:  #ecf8e8;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row20_col2 {\n",
       "            background-color:  #f7fcf5;\n",
       "            color:  #000000;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row21_col2 {\n",
       "            background-color:  #00441b;\n",
       "            color:  #f1f1f1;\n",
       "        }    #T_9497b6ee_dacb_11ea_b4a1_985aebd60274row22_col2 {\n",
       "            background-color:  #40aa5d;\n",
       "            color:  #000000;\n",
       "        }</style><table id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >country</th>        <th class=\"col_heading level0 col1\" >date</th>        <th class=\"col_heading level0 col2\" >usd_base_kg</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row0_col0\" class=\"data row0 col0\" >Belgium - Danis</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row0_col1\" class=\"data row0 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row0_col2\" class=\"data row0 col2\" >1.131958</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row1_col0\" class=\"data row1 col0\" >Denmark</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row1_col1\" class=\"data row1 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row1_col2\" class=\"data row1 col2\" >1.662089</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row2_col0\" class=\"data row2 col0\" >France - MPB</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row2_col1\" class=\"data row2 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row2_col2\" class=\"data row2 col2\" >1.524606</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row3_col0\" class=\"data row3 col0\" >Germany</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row3_col1\" class=\"data row3 col1\" >5 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row3_col2\" class=\"data row3 col2\" >1.733311</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row4_col0\" class=\"data row4 col0\" >Italy</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row4_col1\" class=\"data row4 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row4_col2\" class=\"data row4 col2\" >1.562338</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row5_col0\" class=\"data row5 col0\" >Netherlands - Beursprijs</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row5_col1\" class=\"data row5 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row5_col2\" class=\"data row5 col2\" >1.238079</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row6_col0\" class=\"data row6 col0\" >Poland</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row6_col1\" class=\"data row6 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row6_col2\" class=\"data row6 col2\" >1.720521</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row7_col0\" class=\"data row7 col0\" >Romania</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row7_col1\" class=\"data row7 col1\" >24 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row7_col2\" class=\"data row7 col2\" >1.307490</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row8_col0\" class=\"data row8 col0\" >Russia</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row8_col1\" class=\"data row8 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row8_col2\" class=\"data row8 col2\" >1.530489</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row9_col0\" class=\"data row9 col0\" >Spain - Lleida</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row9_col1\" class=\"data row9 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row9_col2\" class=\"data row9 col2\" >1.532860</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row10\" class=\"row_heading level0 row10\" >10</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row10_col0\" class=\"data row10 col0\" >United Kingdom</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row10_col1\" class=\"data row10 col1\" >1 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row10_col2\" class=\"data row10 col2\" >2.152007</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row11\" class=\"row_heading level0 row11\" >11</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row11_col0\" class=\"data row11 col0\" >Ukraine</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row11_col1\" class=\"data row11 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row11_col2\" class=\"data row11 col2\" >1.670598</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row12\" class=\"row_heading level0 row12\" >12</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row12_col0\" class=\"data row12 col0\" >Argentine</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row12_col1\" class=\"data row12 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row12_col2\" class=\"data row12 col2\" >0.902858</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row13\" class=\"row_heading level0 row13\" >13</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row13_col0\" class=\"data row13 col0\" >Brazil - Paraná</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row13_col1\" class=\"data row13 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row13_col2\" class=\"data row13 col2\" >1.129175</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row14\" class=\"row_heading level0 row14\" >14</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row14_col0\" class=\"data row14 col0\" >Brazil - Santa Catarina</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row14_col1\" class=\"data row14 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row14_col2\" class=\"data row14 col2\" >1.215610</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row15\" class=\"row_heading level0 row15\" >15</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row15_col0\" class=\"data row15 col0\" >Canada - Ontario</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row15_col1\" class=\"data row15 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row15_col2\" class=\"data row15 col2\" >0.949387</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row16\" class=\"row_heading level0 row16\" >16</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row16_col0\" class=\"data row16 col0\" >Canada - Quebec</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row16_col1\" class=\"data row16 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row16_col2\" class=\"data row16 col2\" >1.107631</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row17\" class=\"row_heading level0 row17\" >17</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row17_col0\" class=\"data row17 col0\" >Chile</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row17_col1\" class=\"data row17 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row17_col2\" class=\"data row17 col2\" >1.673429</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row18\" class=\"row_heading level0 row18\" >18</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row18_col0\" class=\"data row18 col0\" >Colombia</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row18_col1\" class=\"data row18 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row18_col2\" class=\"data row18 col2\" >1.450613</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row19\" class=\"row_heading level0 row19\" >19</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row19_col0\" class=\"data row19 col0\" >Mexico - Sonora</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row19_col1\" class=\"data row19 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row19_col2\" class=\"data row19 col2\" >1.134944</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row20\" class=\"row_heading level0 row20\" >20</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row20_col0\" class=\"data row20 col0\" >USA - Iowa/Minnesota</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row20_col1\" class=\"data row20 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row20_col2\" class=\"data row20 col2\" >0.763946</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row21\" class=\"row_heading level0 row21\" >21</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row21_col0\" class=\"data row21 col0\" >China</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row21_col1\" class=\"data row21 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row21_col2\" class=\"data row21 col2\" >5.301910</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274level0_row22\" class=\"row_heading level0 row22\" >22</th>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row22_col0\" class=\"data row22 col0\" >South Korea</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row22_col1\" class=\"data row22 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_9497b6ee_dacb_11ea_b4a1_985aebd60274row22_col2\" class=\"data row22 col2\" >3.606801</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd8f52cae90>"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pig_price_kg_usd.style.background_gradient(cmap = 'Greens')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "usd_pig_price_blue = pig_price_kg_usd.sort_values(by = 'usd_base_kg').style.bar(color= 'lightblue')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row0_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row1_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 3.1%, transparent 3.1%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row2_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 4.1%, transparent 4.1%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row3_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 7.6%, transparent 7.6%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row4_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 8.0%, transparent 8.0%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row5_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 8.1%, transparent 8.1%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row6_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 8.2%, transparent 8.2%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row7_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 10.0%, transparent 10.0%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row8_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 10.4%, transparent 10.4%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row9_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 12.0%, transparent 12.0%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row10_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 15.1%, transparent 15.1%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row11_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 16.8%, transparent 16.8%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row12_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 16.9%, transparent 16.9%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row13_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 16.9%, transparent 16.9%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row14_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 17.6%, transparent 17.6%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row15_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 19.8%, transparent 19.8%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row16_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 20.0%, transparent 20.0%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row17_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 20.0%, transparent 20.0%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row18_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 21.1%, transparent 21.1%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row19_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 21.4%, transparent 21.4%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row20_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 30.6%, transparent 30.6%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row21_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 62.6%, transparent 62.6%);\n",
       "        }    #T_94b0b70c_dacb_11ea_b4a1_985aebd60274row22_col2 {\n",
       "            width:  10em;\n",
       "             height:  80%;\n",
       "            background:  linear-gradient(90deg,lightblue 100.0%, transparent 100.0%);\n",
       "        }</style><table id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274\" ><thead>    <tr>        <th class=\"blank level0\" ></th>        <th class=\"col_heading level0 col0\" >country</th>        <th class=\"col_heading level0 col1\" >date</th>        <th class=\"col_heading level0 col2\" >usd_base_kg</th>    </tr></thead><tbody>\n",
       "                <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row0\" class=\"row_heading level0 row0\" >20</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row0_col0\" class=\"data row0 col0\" >USA - Iowa/Minnesota</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row0_col1\" class=\"data row0 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row0_col2\" class=\"data row0 col2\" >0.763946</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row1\" class=\"row_heading level0 row1\" >12</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row1_col0\" class=\"data row1 col0\" >Argentine</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row1_col1\" class=\"data row1 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row1_col2\" class=\"data row1 col2\" >0.902858</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row2\" class=\"row_heading level0 row2\" >15</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row2_col0\" class=\"data row2 col0\" >Canada - Ontario</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row2_col1\" class=\"data row2 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row2_col2\" class=\"data row2 col2\" >0.949387</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row3\" class=\"row_heading level0 row3\" >16</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row3_col0\" class=\"data row3 col0\" >Canada - Quebec</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row3_col1\" class=\"data row3 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row3_col2\" class=\"data row3 col2\" >1.107631</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row4\" class=\"row_heading level0 row4\" >13</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row4_col0\" class=\"data row4 col0\" >Brazil - Paraná</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row4_col1\" class=\"data row4 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row4_col2\" class=\"data row4 col2\" >1.129175</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row5\" class=\"row_heading level0 row5\" >0</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row5_col0\" class=\"data row5 col0\" >Belgium - Danis</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row5_col1\" class=\"data row5 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row5_col2\" class=\"data row5 col2\" >1.131958</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row6\" class=\"row_heading level0 row6\" >19</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row6_col0\" class=\"data row6 col0\" >Mexico - Sonora</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row6_col1\" class=\"data row6 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row6_col2\" class=\"data row6 col2\" >1.134944</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row7\" class=\"row_heading level0 row7\" >14</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row7_col0\" class=\"data row7 col0\" >Brazil - Santa Catarina</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row7_col1\" class=\"data row7 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row7_col2\" class=\"data row7 col2\" >1.215610</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row8\" class=\"row_heading level0 row8\" >5</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row8_col0\" class=\"data row8 col0\" >Netherlands - Beursprijs</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row8_col1\" class=\"data row8 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row8_col2\" class=\"data row8 col2\" >1.238079</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row9\" class=\"row_heading level0 row9\" >7</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row9_col0\" class=\"data row9 col0\" >Romania</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row9_col1\" class=\"data row9 col1\" >24 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row9_col2\" class=\"data row9 col2\" >1.307490</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row10\" class=\"row_heading level0 row10\" >18</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row10_col0\" class=\"data row10 col0\" >Colombia</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row10_col1\" class=\"data row10 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row10_col2\" class=\"data row10 col2\" >1.450613</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row11\" class=\"row_heading level0 row11\" >2</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row11_col0\" class=\"data row11 col0\" >France - MPB</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row11_col1\" class=\"data row11 col1\" >3 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row11_col2\" class=\"data row11 col2\" >1.524606</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row12\" class=\"row_heading level0 row12\" >8</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row12_col0\" class=\"data row12 col0\" >Russia</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row12_col1\" class=\"data row12 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row12_col2\" class=\"data row12 col2\" >1.530489</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row13\" class=\"row_heading level0 row13\" >9</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row13_col0\" class=\"data row13 col0\" >Spain - Lleida</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row13_col1\" class=\"data row13 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row13_col2\" class=\"data row13 col2\" >1.532860</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row14\" class=\"row_heading level0 row14\" >4</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row14_col0\" class=\"data row14 col0\" >Italy</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row14_col1\" class=\"data row14 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row14_col2\" class=\"data row14 col2\" >1.562338</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row15\" class=\"row_heading level0 row15\" >1</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row15_col0\" class=\"data row15 col0\" >Denmark</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row15_col1\" class=\"data row15 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row15_col2\" class=\"data row15 col2\" >1.662089</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row16\" class=\"row_heading level0 row16\" >11</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row16_col0\" class=\"data row16 col0\" >Ukraine</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row16_col1\" class=\"data row16 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row16_col2\" class=\"data row16 col2\" >1.670598</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row17\" class=\"row_heading level0 row17\" >17</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row17_col0\" class=\"data row17 col0\" >Chile</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row17_col1\" class=\"data row17 col1\" >7 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row17_col2\" class=\"data row17 col2\" >1.673429</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row18\" class=\"row_heading level0 row18\" >6</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row18_col0\" class=\"data row18 col0\" >Poland</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row18_col1\" class=\"data row18 col1\" >31 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row18_col2\" class=\"data row18 col2\" >1.720521</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row19\" class=\"row_heading level0 row19\" >3</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row19_col0\" class=\"data row19 col0\" >Germany</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row19_col1\" class=\"data row19 col1\" >5 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row19_col2\" class=\"data row19 col2\" >1.733311</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row20\" class=\"row_heading level0 row20\" >10</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row20_col0\" class=\"data row20 col0\" >United Kingdom</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row20_col1\" class=\"data row20 col1\" >1 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row20_col2\" class=\"data row20 col2\" >2.152007</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row21\" class=\"row_heading level0 row21\" >22</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row21_col0\" class=\"data row21 col0\" >South Korea</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row21_col1\" class=\"data row21 col1\" >6 Aug</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row21_col2\" class=\"data row21 col2\" >3.606801</td>\n",
       "            </tr>\n",
       "            <tr>\n",
       "                        <th id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274level0_row22\" class=\"row_heading level0 row22\" >21</th>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row22_col0\" class=\"data row22 col0\" >China</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row22_col1\" class=\"data row22 col1\" >29 Jul</td>\n",
       "                        <td id=\"T_94b0b70c_dacb_11ea_b4a1_985aebd60274row22_col2\" class=\"data row22 col2\" >5.301910</td>\n",
       "            </tr>\n",
       "    </tbody></table>"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd8f807bf50>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "usd_pig_price_blue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "[Errno 2] No such file or directory: '/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetodayUSDBlueGrade1082020.xls'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-34-18c662451331>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mcurrent_date\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnow\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mfilename\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcurrent_date\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mday\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcurrent_date\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmonth\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcurrent_date\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0myear\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m \u001b[0musd_pig_price_blue\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_excel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetodayUSDBlueGrade'\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mfilename\u001b[0m\u001b[0;34m+\u001b[0m \u001b[0;34m'.xls'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m \u001b[0;31m#pricing.to_csv('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetoday.csv')\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.7/site-packages/pandas/io/formats/style.py\u001b[0m in \u001b[0;36mto_excel\u001b[0;34m(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes)\u001b[0m\n\u001b[1;32m    233\u001b[0m             \u001b[0mstartcol\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mstartcol\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    234\u001b[0m             \u001b[0mfreeze_panes\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mfreeze_panes\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 235\u001b[0;31m             \u001b[0mengine\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    236\u001b[0m         )\n\u001b[1;32m    237\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.7/site-packages/pandas/io/formats/excel.py\u001b[0m in \u001b[0;36mwrite\u001b[0;34m(self, writer, sheet_name, startrow, startcol, freeze_panes, engine)\u001b[0m\n\u001b[1;32m    736\u001b[0m         )\n\u001b[1;32m    737\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mneed_save\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 738\u001b[0;31m             \u001b[0mwriter\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msave\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.7/site-packages/pandas/io/excel/_xlwt.py\u001b[0m in \u001b[0;36msave\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m     30\u001b[0m         \u001b[0mSave\u001b[0m \u001b[0mworkbook\u001b[0m \u001b[0mto\u001b[0m \u001b[0mdisk\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     31\u001b[0m         \"\"\"\n\u001b[0;32m---> 32\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mbook\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msave\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     33\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     34\u001b[0m     def write_cells(\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.7/site-packages/xlwt/Workbook.py\u001b[0m in \u001b[0;36msave\u001b[0;34m(self, filename_or_stream)\u001b[0m\n\u001b[1;32m    708\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    709\u001b[0m         \u001b[0mdoc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mCompoundDoc\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mXlsDoc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 710\u001b[0;31m         \u001b[0mdoc\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msave\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilename_or_stream\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_biff_data\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    711\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    712\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/opt/anaconda3/lib/python3.7/site-packages/xlwt/CompoundDoc.py\u001b[0m in \u001b[0;36msave\u001b[0;34m(self, file_name_or_filelike_obj, stream)\u001b[0m\n\u001b[1;32m    260\u001b[0m         \u001b[0mwe_own_it\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mhasattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'write'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    261\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mwe_own_it\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 262\u001b[0;31m             \u001b[0mf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfile_name_or_filelike_obj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'w+b'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    263\u001b[0m         \u001b[0mf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwrite\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mheader\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    264\u001b[0m         \u001b[0mf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwrite\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpacked_MSAT_1st\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mFileNotFoundError\u001b[0m: [Errno 2] No such file or directory: '/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetodayUSDBlueGrade1082020.xls'"
     ]
    }
   ],
   "source": [
    "import datetime\n",
    "\n",
    "current_date = datetime.datetime.now()\n",
    "filename = str(current_date.day)+str(current_date.month)+str(current_date.year)\n",
    "usd_pig_price_blue.to_excel(str('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetodayUSDBlueGrade'+filename+ '.xls'))\n",
    "#pricing.to_csv('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetoday.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "pig_price_kg_usd.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "8. Export to CSV file for further temporal analisys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "\n",
    "current_date = datetime.datetime.now()\n",
    "filename = str(current_date.day)+str(current_date.month)+str(current_date.year)\n",
    "pig_price_kg_usd.to_csv(str('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetodayUSD'+filename+ '.csv'))\n",
    "#pricing.to_csv('/Users/lstorino/PythonTests/scrapping/Pig333/data/pricetoday.csv')"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "name": "Untitled12.ipynb",
   "provenance": [],
   "version": "0.3.2"
  },
  "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": 1
}