Data Dive 1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('avocado.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 18249 entries, 0 to 18248\n",
      "Data columns (total 14 columns):\n",
      "Unnamed: 0      18249 non-null int64\n",
      "Date            18249 non-null object\n",
      "AveragePrice    18249 non-null float64\n",
      "Total Volume    18249 non-null float64\n",
      "4046            18249 non-null float64\n",
      "4225            18249 non-null float64\n",
      "4770            18249 non-null float64\n",
      "Total Bags      18249 non-null float64\n",
      "Small Bags      18249 non-null float64\n",
      "Large Bags      18249 non-null float64\n",
      "XLarge Bags     18249 non-null float64\n",
      "type            18249 non-null object\n",
      "year            18249 non-null int64\n",
      "region          18249 non-null object\n",
      "dtypes: float64(9), int64(2), object(3)\n",
      "memory usage: 1.9+ MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Date</th>\n",
       "      <th>AveragePrice</th>\n",
       "      <th>Total Volume</th>\n",
       "      <th>4046</th>\n",
       "      <th>4225</th>\n",
       "      <th>4770</th>\n",
       "      <th>Total Bags</th>\n",
       "      <th>Small Bags</th>\n",
       "      <th>Large Bags</th>\n",
       "      <th>XLarge Bags</th>\n",
       "      <th>type</th>\n",
       "      <th>year</th>\n",
       "      <th>region</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2015-12-27</td>\n",
       "      <td>1.33</td>\n",
       "      <td>64236.62</td>\n",
       "      <td>1036.74</td>\n",
       "      <td>54454.85</td>\n",
       "      <td>48.16</td>\n",
       "      <td>8696.87</td>\n",
       "      <td>8603.62</td>\n",
       "      <td>93.25</td>\n",
       "      <td>0.0</td>\n",
       "      <td>conventional</td>\n",
       "      <td>2015</td>\n",
       "      <td>Albany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2015-12-20</td>\n",
       "      <td>1.35</td>\n",
       "      <td>54876.98</td>\n",
       "      <td>674.28</td>\n",
       "      <td>44638.81</td>\n",
       "      <td>58.33</td>\n",
       "      <td>9505.56</td>\n",
       "      <td>9408.07</td>\n",
       "      <td>97.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>conventional</td>\n",
       "      <td>2015</td>\n",
       "      <td>Albany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2015-12-13</td>\n",
       "      <td>0.93</td>\n",
       "      <td>118220.22</td>\n",
       "      <td>794.70</td>\n",
       "      <td>109149.67</td>\n",
       "      <td>130.50</td>\n",
       "      <td>8145.35</td>\n",
       "      <td>8042.21</td>\n",
       "      <td>103.14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>conventional</td>\n",
       "      <td>2015</td>\n",
       "      <td>Albany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2015-12-06</td>\n",
       "      <td>1.08</td>\n",
       "      <td>78992.15</td>\n",
       "      <td>1132.00</td>\n",
       "      <td>71976.41</td>\n",
       "      <td>72.58</td>\n",
       "      <td>5811.16</td>\n",
       "      <td>5677.40</td>\n",
       "      <td>133.76</td>\n",
       "      <td>0.0</td>\n",
       "      <td>conventional</td>\n",
       "      <td>2015</td>\n",
       "      <td>Albany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2015-11-29</td>\n",
       "      <td>1.28</td>\n",
       "      <td>51039.60</td>\n",
       "      <td>941.48</td>\n",
       "      <td>43838.39</td>\n",
       "      <td>75.78</td>\n",
       "      <td>6183.95</td>\n",
       "      <td>5986.26</td>\n",
       "      <td>197.69</td>\n",
       "      <td>0.0</td>\n",
       "      <td>conventional</td>\n",
       "      <td>2015</td>\n",
       "      <td>Albany</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0        Date  AveragePrice  Total Volume     4046       4225  \\\n",
       "0           0  2015-12-27          1.33      64236.62  1036.74   54454.85   \n",
       "1           1  2015-12-20          1.35      54876.98   674.28   44638.81   \n",
       "2           2  2015-12-13          0.93     118220.22   794.70  109149.67   \n",
       "3           3  2015-12-06          1.08      78992.15  1132.00   71976.41   \n",
       "4           4  2015-11-29          1.28      51039.60   941.48   43838.39   \n",
       "\n",
       "     4770  Total Bags  Small Bags  Large Bags  XLarge Bags          type  \\\n",
       "0   48.16     8696.87     8603.62       93.25          0.0  conventional   \n",
       "1   58.33     9505.56     9408.07       97.49          0.0  conventional   \n",
       "2  130.50     8145.35     8042.21      103.14          0.0  conventional   \n",
       "3   72.58     5811.16     5677.40      133.76          0.0  conventional   \n",
       "4   75.78     6183.95     5986.26      197.69          0.0  conventional   \n",
       "\n",
       "   year  region  \n",
       "0  2015  Albany  \n",
       "1  2015  Albany  \n",
       "2  2015  Albany  \n",
       "3  2015  Albany  \n",
       "4  2015  Albany  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "#4046: small hass, 4225: large hass, 4770: extra-large hass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Date</th>\n",
       "      <th>Total Volume</th>\n",
       "      <th>4046</th>\n",
       "      <th>4225</th>\n",
       "      <th>4770</th>\n",
       "      <th>Total Bags</th>\n",
       "      <th>Small Bags</th>\n",
       "      <th>Large Bags</th>\n",
       "      <th>XLarge Bags</th>\n",
       "      <th>type</th>\n",
       "      <th>year</th>\n",
       "      <th>region</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AveragePrice</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0.44</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.46</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.48</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.49</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.51</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.52</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.53</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.54</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.55</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.56</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.57</th>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.58</th>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.59</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.60</th>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.61</th>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.62</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.63</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.64</th>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.65</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.66</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.67</th>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.68</th>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.69</th>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.70</th>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "      <td>44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.71</th>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.72</th>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.73</th>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.74</th>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.75</th>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0.76</th>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.76</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.77</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.78</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.79</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.80</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.81</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.82</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.83</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.84</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.85</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.86</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.87</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.88</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.89</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.90</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.91</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.92</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.93</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.94</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.95</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.96</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.97</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.99</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.00</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.03</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.04</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.05</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.12</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.17</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3.25</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>259 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Unnamed: 0  Date  Total Volume  4046  4225  4770  Total Bags  \\\n",
       "AveragePrice                                                                 \n",
       "0.44                   1     1             1     1     1     1           1   \n",
       "0.46                   1     1             1     1     1     1           1   \n",
       "0.48                   1     1             1     1     1     1           1   \n",
       "0.49                   2     2             2     2     2     2           2   \n",
       "0.51                   5     5             5     5     5     5           5   \n",
       "0.52                   3     3             3     3     3     3           3   \n",
       "0.53                   6     6             6     6     6     6           6   \n",
       "0.54                   7     7             7     7     7     7           7   \n",
       "0.55                   3     3             3     3     3     3           3   \n",
       "0.56                  12    12            12    12    12    12          12   \n",
       "0.57                   9     9             9     9     9     9           9   \n",
       "0.58                  14    14            14    14    14    14          14   \n",
       "0.59                   5     5             5     5     5     5           5   \n",
       "0.60                  12    12            12    12    12    12          12   \n",
       "0.61                  11    11            11    11    11    11          11   \n",
       "0.62                  10    10            10    10    10    10          10   \n",
       "0.63                  10    10            10    10    10    10          10   \n",
       "0.64                  17    17            17    17    17    17          17   \n",
       "0.65                  23    23            23    23    23    23          23   \n",
       "0.66                  10    10            10    10    10    10          10   \n",
       "0.67                  23    23            23    23    23    23          23   \n",
       "0.68                  26    26            26    26    26    26          26   \n",
       "0.69                  18    18            18    18    18    18          18   \n",
       "0.70                  44    44            44    44    44    44          44   \n",
       "0.71                  28    28            28    28    28    28          28   \n",
       "0.72                  30    30            30    30    30    30          30   \n",
       "0.73                  38    38            38    38    38    38          38   \n",
       "0.74                  50    50            50    50    50    50          50   \n",
       "0.75                  43    43            43    43    43    43          43   \n",
       "0.76                  61    61            61    61    61    61          61   \n",
       "...                  ...   ...           ...   ...   ...   ...         ...   \n",
       "2.76                   5     5             5     5     5     5           5   \n",
       "2.77                   3     3             3     3     3     3           3   \n",
       "2.78                   1     1             1     1     1     1           1   \n",
       "2.79                   4     4             4     4     4     4           4   \n",
       "2.80                   2     2             2     2     2     2           2   \n",
       "2.81                   3     3             3     3     3     3           3   \n",
       "2.82                   3     3             3     3     3     3           3   \n",
       "2.83                   6     6             6     6     6     6           6   \n",
       "2.84                   4     4             4     4     4     4           4   \n",
       "2.85                   4     4             4     4     4     4           4   \n",
       "2.86                   4     4             4     4     4     4           4   \n",
       "2.87                   3     3             3     3     3     3           3   \n",
       "2.88                   3     3             3     3     3     3           3   \n",
       "2.89                   3     3             3     3     3     3           3   \n",
       "2.90                   1     1             1     1     1     1           1   \n",
       "2.91                   1     1             1     1     1     1           1   \n",
       "2.92                   2     2             2     2     2     2           2   \n",
       "2.93                   4     4             4     4     4     4           4   \n",
       "2.94                   2     2             2     2     2     2           2   \n",
       "2.95                   1     1             1     1     1     1           1   \n",
       "2.96                   1     1             1     1     1     1           1   \n",
       "2.97                   1     1             1     1     1     1           1   \n",
       "2.99                   2     2             2     2     2     2           2   \n",
       "3.00                   2     2             2     2     2     2           2   \n",
       "3.03                   1     1             1     1     1     1           1   \n",
       "3.04                   1     1             1     1     1     1           1   \n",
       "3.05                   1     1             1     1     1     1           1   \n",
       "3.12                   1     1             1     1     1     1           1   \n",
       "3.17                   1     1             1     1     1     1           1   \n",
       "3.25                   1     1             1     1     1     1           1   \n",
       "\n",
       "              Small Bags  Large Bags  XLarge Bags  type  year  region  \n",
       "AveragePrice                                                           \n",
       "0.44                   1           1            1     1     1       1  \n",
       "0.46                   1           1            1     1     1       1  \n",
       "0.48                   1           1            1     1     1       1  \n",
       "0.49                   2           2            2     2     2       2  \n",
       "0.51                   5           5            5     5     5       5  \n",
       "0.52                   3           3            3     3     3       3  \n",
       "0.53                   6           6            6     6     6       6  \n",
       "0.54                   7           7            7     7     7       7  \n",
       "0.55                   3           3            3     3     3       3  \n",
       "0.56                  12          12           12    12    12      12  \n",
       "0.57                   9           9            9     9     9       9  \n",
       "0.58                  14          14           14    14    14      14  \n",
       "0.59                   5           5            5     5     5       5  \n",
       "0.60                  12          12           12    12    12      12  \n",
       "0.61                  11          11           11    11    11      11  \n",
       "0.62                  10          10           10    10    10      10  \n",
       "0.63                  10          10           10    10    10      10  \n",
       "0.64                  17          17           17    17    17      17  \n",
       "0.65                  23          23           23    23    23      23  \n",
       "0.66                  10          10           10    10    10      10  \n",
       "0.67                  23          23           23    23    23      23  \n",
       "0.68                  26          26           26    26    26      26  \n",
       "0.69                  18          18           18    18    18      18  \n",
       "0.70                  44          44           44    44    44      44  \n",
       "0.71                  28          28           28    28    28      28  \n",
       "0.72                  30          30           30    30    30      30  \n",
       "0.73                  38          38           38    38    38      38  \n",
       "0.74                  50          50           50    50    50      50  \n",
       "0.75                  43          43           43    43    43      43  \n",
       "0.76                  61          61           61    61    61      61  \n",
       "...                  ...         ...          ...   ...   ...     ...  \n",
       "2.76                   5           5            5     5     5       5  \n",
       "2.77                   3           3            3     3     3       3  \n",
       "2.78                   1           1            1     1     1       1  \n",
       "2.79                   4           4            4     4     4       4  \n",
       "2.80                   2           2            2     2     2       2  \n",
       "2.81                   3           3            3     3     3       3  \n",
       "2.82                   3           3            3     3     3       3  \n",
       "2.83                   6           6            6     6     6       6  \n",
       "2.84                   4           4            4     4     4       4  \n",
       "2.85                   4           4            4     4     4       4  \n",
       "2.86                   4           4            4     4     4       4  \n",
       "2.87                   3           3            3     3     3       3  \n",
       "2.88                   3           3            3     3     3       3  \n",
       "2.89                   3           3            3     3     3       3  \n",
       "2.90                   1           1            1     1     1       1  \n",
       "2.91                   1           1            1     1     1       1  \n",
       "2.92                   2           2            2     2     2       2  \n",
       "2.93                   4           4            4     4     4       4  \n",
       "2.94                   2           2            2     2     2       2  \n",
       "2.95                   1           1            1     1     1       1  \n",
       "2.96                   1           1            1     1     1       1  \n",
       "2.97                   1           1            1     1     1       1  \n",
       "2.99                   2           2            2     2     2       2  \n",
       "3.00                   2           2            2     2     2       2  \n",
       "3.03                   1           1            1     1     1       1  \n",
       "3.04                   1           1            1     1     1       1  \n",
       "3.05                   1           1            1     1     1       1  \n",
       "3.12                   1           1            1     1     1       1  \n",
       "3.17                   1           1            1     1     1       1  \n",
       "3.25                   1           1            1     1     1       1  \n",
       "\n",
       "[259 rows x 13 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('AveragePrice').count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1b7ef3ac550>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAElZJREFUeJzt3X+s3XV9x/Hn2xaUoBOwcNe03cpis4jrVLgpXUiWGzFQYbEkg6SESCGYJhtzmjSZ1T9GREnqEmTi5o9OmlWDAkEdHeBYBz0x+0N+KVKwsl6xkbs2dlqoXpks1733x/lcdrze23vu7fnRcz7PR3Jyv9/P93O+388733Pv63y/53u+NzITSVJ9XtPvAUiS+sMAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUm0FQEQcjIh9EfFURDxR2s6KiD0RcaD8PLO0R0TcHhHjEfF0RJzfsp7Npf+BiNjcnZIkSe2Idr4JHBEHgdHM/ElL298ARzNze0RsA87MzA9FxGXA+4HLgAuBT2XmhRFxFvAEMAok8CRwQWa+ONd2ly1blqtXr150cXP5xS9+wemnn97x9fabdQ2eYa3NuvrrySef/Elmnj1vx8yc9wEcBJbNaHsOWF6mlwPPlenPA1fP7AdcDXy+pf3X+s32uOCCC7Ib9u7d25X19pt1DZ5hrc26+gt4Itv4297uZwAJ/GtEPBkRW0rbSGYeLiFyGDintK8AXmh57kRpm6tdktQHS9vsd1FmHoqIc4A9EfH94/SNWdryOO2//uRmwGwBGBkZodFotDnE9k1OTnZlvf1mXYNnWGuzrsHQVgBk5qHy80hEfB1YB/w4IpZn5uGIWA4cKd0ngFUtT18JHCrtYzPaG7NsawewA2B0dDTHxsZmdjlhjUaDbqy336xr8AxrbdY1GOY9BRQRp0fEG6angUuAZ4DdwPSVPJuB+8r0buDacjXQeuBYOUX0EHBJRJxZrhi6pLRJkvqgnSOAEeDrETHd/8uZ+S8R8ThwT0TcAPwIuKr0f5DmFUDjwMvA9QCZeTQiPgY8XvrdnJlHO1aJJGlB5g2AzHweeNss7T8FLp6lPYEb51jXTmDnwocpSeo0vwksSZUyACSpUgaAJFWq3e8BaADs+89jXLftgb5s++D2y/uyXUmL5xGAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkirlzeDUEau7eBO6rWun5rzJnTehkxbPIwBJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqVNsBEBFLIuI7EXF/mT83Ih6NiAMRcXdEnFraX1vmx8vy1S3r+HBpfy4iLu10MZKk9i3kCOADwP6W+U8At2XmGuBF4IbSfgPwYma+Gbit9CMizgM2AW8FNgCfiYglJzZ8SdJitRUAEbESuBz4QpkP4J3AvaXLLuCKMr2xzFOWX1z6bwTuysxXMvOHwDiwrhNFSJIWrt0jgL8F/gr43zL/JuClzJwq8xPAijK9AngBoCw/Vvq/2j7LcyRJPbZ0vg4R8SfAkcx8MiLGpptn6ZrzLDvec1q3twXYAjAyMkKj0ZhviAs2OTnZlfX228hpsHXt1PwdB8zx6hr0/Tisr0XrGgzzBgBwEfCeiLgMeB3wWzSPCM6IiKXlXf5K4FDpPwGsAiYiYinwRuBoS/u01ue8KjN3ADsARkdHc2xsbBFlHV+j0aAb6+23T995H7fua2eXDpata6fmrOvgNWO9HUyHDetr0boGw7yngDLzw5m5MjNX0/wQ95HMvAbYC1xZum0G7ivTu8s8ZfkjmZmlfVO5SuhcYA3wWMcqkSQtyIm8XfwQcFdEfBz4DnBHab8D+FJEjNN8578JIDOfjYh7gO8BU8CNmfmrE9i+JOkELCgAMrMBNMr088xyFU9m/hK4ao7n3wLcstBBSpI6z28CS1KlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgv6p/DSyWb1tgf6tu2D2y/v27alTvAIQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVLzBkBEvC4iHouI70bEsxHx0dJ+bkQ8GhEHIuLuiDi1tL+2zI+X5atb1vXh0v5cRFzaraIkSfNr5wjgFeCdmfk24O3AhohYD3wCuC0z1wAvAjeU/jcAL2bmm4HbSj8i4jxgE/BWYAPwmYhY0sliJEntmzcAsmmyzJ5SHgm8E7i3tO8CrijTG8s8ZfnFERGl/a7MfCUzfwiMA+s6UoUkacHa+gwgIpZExFPAEWAP8APgpcycKl0mgBVlegXwAkBZfgx4U2v7LM+RJPVYW/8RLDN/Bbw9Is4Avg68ZbZu5WfMsWyu9l8TEVuALQAjIyM0Go12hrggk5OTXVlvv42cBlvXTs3fccCcrHV14jU0rK9F6xoMC/qXkJn5UkQ0gPXAGRGxtLzLXwkcKt0mgFXAREQsBd4IHG1pn9b6nNZt7AB2AIyOjubY2NhChtiWRqNBN9bbb5++8z5u3Td8/+Vz69qpk7Kug9eMnfA6hvW1aF2DoZ2rgM4u7/yJiNOAdwH7gb3AlaXbZuC+Mr27zFOWP5KZWdo3lauEzgXWAI91qhBJ0sK087ZqObCrXLHzGuCezLw/Ir4H3BURHwe+A9xR+t8BfCkixmm+898EkJnPRsQ9wPeAKeDGcmpJktQH8wZAZj4NvGOW9ueZ5SqezPwlcNUc67oFuGXhw5QkdZrfBJakShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkip18t1jdwis3vZAX7a7dW1fNitpQHkEIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKjVvAETEqojYGxH7I+LZiPhAaT8rIvZExIHy88zSHhFxe0SMR8TTEXF+y7o2l/4HImJz98qSJM2nnSOAKWBrZr4FWA/cGBHnAduAhzNzDfBwmQd4N7CmPLYAn4VmYAA3ARcC64CbpkNDktR78wZAZh7OzG+X6Z8D+4EVwEZgV+m2C7iiTG8EvphN3wLOiIjlwKXAnsw8mpkvAnuADR2tRpLUtgV9BhARq4F3AI8CI5l5GJohAZxTuq0AXmh52kRpm6tdktQHS9vtGBGvB74KfDAzfxYRc3adpS2P0z5zO1tonjpiZGSERqPR7hDbNjk52ZX1Ttu6dqpr6z6ekdP6t+1uOlnr6sRrqNuvxX6xrsHQVgBExCk0//jfmZlfK80/jojlmXm4nOI5UtongFUtT18JHCrtYzPaGzO3lZk7gB0Ao6OjOTY2NrPLCWs0GnRjvdOu2/ZA19Z9PFvXTnHrvrYzfWCcrHUdvGbshNfR7ddiv1jXYGjnKqAA7gD2Z+YnWxbtBqav5NkM3NfSfm25Gmg9cKycInoIuCQiziwf/l5S2iRJfdDO26qLgPcC+yLiqdL2EWA7cE9E3AD8CLiqLHsQuAwYB14GrgfIzKMR8THg8dLv5sw82pEqJEkLNm8AZOa/M/v5e4CLZ+mfwI1zrGsnsHMhA5QkdYffBJakShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEqdfHfYkgbE6g7c9G/r2qkF3zzw4PbLT3i7EngEIEnVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqtS8ARAROyPiSEQ809J2VkTsiYgD5eeZpT0i4vaIGI+IpyPi/JbnbC79D0TE5u6UI0lqVztHAP8IbJjRtg14ODPXAA+XeYB3A2vKYwvwWWgGBnATcCGwDrhpOjQkSf0xbwBk5jeBozOaNwK7yvQu4IqW9i9m07eAMyJiOXApsCczj2bmi8AefjNUJEk9tNjPAEYy8zBA+XlOaV8BvNDSb6K0zdUuSeqTpR1eX8zSlsdp/80VRGyhefqIkZERGo1GxwY3bXJysivrnbZ17VTX1n08I6f1b9vdNKx1weJq6+Zrt1O6/TvWL8NW12ID4McRsTwzD5dTPEdK+wSwqqXfSuBQaR+b0d6YbcWZuQPYATA6OppjY2OzdTshjUaDbqx32nXbHujauo9n69opbt3X6Uzvv2GtCxZX28FrxrozmA7q9u9YvwxbXYs9BbQbmL6SZzNwX0v7teVqoPXAsXKK6CHgkog4s3z4e0lpkyT1ybxvPSLiKzTfvS+LiAmaV/NsB+6JiBuAHwFXle4PApcB48DLwPUAmXk0Ij4GPF763ZyZMz9YliT10LwBkJlXz7Ho4ln6JnDjHOvZCexc0OgkSV3jN4ElqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVKnhvMm6NMRW9+n/TQAc3H5537atzvMIQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqtRQ3wtornumbF07xXV9vJ+KJJ0MPAKQpEoZAJJUKQNAkiplAEhSpQwASarUUF8FJKmz2v1vZJ2+0s7/RNYdHgFIUqUMAEmqlAEgSZXq+WcAEbEB+BSwBPhCZm7v9RgkDZZ2P3votGH/7KGnRwARsQT4e+DdwHnA1RFxXi/HIElq6vUpoHXAeGY+n5n/A9wFbOzxGCRJ9P4U0ArghZb5CeDCHo9Bktoy89RTL28k2YvTT5GZXd/IqxuLuAq4NDPfV+bfC6zLzPe39NkCbCmzvw8814WhLAN+0oX19pt1DZ5hrc26+ut3M/Ps+Tr1+ghgAljVMr8SONTaITN3ADu6OYiIeCIzR7u5jX6wrsEzrLVZ12Do9WcAjwNrIuLciDgV2ATs7vEYJEn0+AggM6ci4i+Ah2heBrozM5/t5RgkSU09/x5AZj4IPNjr7c7Q1VNMfWRdg2dYa7OuAdDTD4ElSScPbwUhSZUa6gCIiA0R8VxEjEfEtlmWXxcR/xURT5XH+/oxzoWIiJ0RcSQinpljeUTE7aXmpyPi/F6PcTHaqGssIo617Ku/7vUYFyMiVkXE3ojYHxHPRsQHZukzcPuszboGdZ+9LiIei4jvlto+Okuf10bE3WWfPRoRq3s/0g7IzKF80PyQ+QfA7wGnAt8FzpvR5zrg7/o91gXW9cfA+cAzcyy/DPgGEMB64NF+j7lDdY0B9/d7nIuoazlwfpl+A/Afs7wOB26ftVnXoO6zAF5fpk8BHgXWz+jz58DnyvQm4O5+j3sxj2E+AhjK205k5jeBo8fpshH4YjZ9CzgjIpb3ZnSL10ZdAykzD2fmt8v0z4H9NL8R32rg9lmbdQ2ksh8my+wp5THzw9KNwK4yfS9wcUREj4bYMcMcALPddmK2F+iflsPueyNi1SzLB027dQ+iPyqH5d+IiLf2ezALVU4TvIPmO8pWA73PjlMXDOg+i4glEfEUcATYk5lz7rPMnAKOAW/q7ShP3DAHwGxpPDPF/xlYnZl/CPwb/5/og6ydugfRt2l+vf1twKeBf+rzeBYkIl4PfBX4YGb+bObiWZ4yEPtsnroGdp9l5q8y8+0071awLiL+YEaXgd1nrYY5ANq57cRPM/OVMvsPwAU9Gls3zVv3IMrMn00flmfzuySnRMSyPg+rLRFxCs0/kndm5tdm6TKQ+2y+ugZ5n03LzJeABrBhxqJX91lELAXeyACewhzmAJj3thMzzrO+h+Z5zEG3G7i2XFmyHjiWmYf7PagTFRG/PX2ONSLW0Xzt/rS/o5pfGfMdwP7M/OQc3QZun7VT1wDvs7Mj4owyfRrwLuD7M7rtBjaX6SuBR7J8IjxIev5N4F7JOW47ERE3A09k5m7gLyPiPcAUzfS+rm8DblNEfIXm1RXLImICuInmh1Rk5udofsv6MmAceBm4vj8jXZg26roS+LOImAL+G9g0IL9wFwHvBfaVc8oAHwF+BwZ6n7VT16Dus+XArmj+A6vXAPdk5v0z/nbcAXwpIsZp/u3Y1L/hLp7fBJakSg3zKSBJ0nEYAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVer/AMU+R5LfpN4fAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df['AveragePrice'].hist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAElZJREFUeJzt3X+s3XV9x/Hn2xaUoBOwcNe03cpis4jrVLgpXUiWGzFQYbEkg6SESCGYJhtzmjSZ1T9GREnqEmTi5o9OmlWDAkEdHeBYBz0x+0N+KVKwsl6xkbs2dlqoXpks1733x/lcdrze23vu7fnRcz7PR3Jyv9/P93O+388733Pv63y/53u+NzITSVJ9XtPvAUiS+sMAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUm0FQEQcjIh9EfFURDxR2s6KiD0RcaD8PLO0R0TcHhHjEfF0RJzfsp7Npf+BiNjcnZIkSe2Idr4JHBEHgdHM/ElL298ARzNze0RsA87MzA9FxGXA+4HLgAuBT2XmhRFxFvAEMAok8CRwQWa+ONd2ly1blqtXr150cXP5xS9+wemnn97x9fabdQ2eYa3NuvrrySef/Elmnj1vx8yc9wEcBJbNaHsOWF6mlwPPlenPA1fP7AdcDXy+pf3X+s32uOCCC7Ib9u7d25X19pt1DZ5hrc26+gt4Itv4297uZwAJ/GtEPBkRW0rbSGYeLiFyGDintK8AXmh57kRpm6tdktQHS9vsd1FmHoqIc4A9EfH94/SNWdryOO2//uRmwGwBGBkZodFotDnE9k1OTnZlvf1mXYNnWGuzrsHQVgBk5qHy80hEfB1YB/w4IpZn5uGIWA4cKd0ngFUtT18JHCrtYzPaG7NsawewA2B0dDTHxsZmdjlhjUaDbqy336xr8AxrbdY1GOY9BRQRp0fEG6angUuAZ4DdwPSVPJuB+8r0buDacjXQeuBYOUX0EHBJRJxZrhi6pLRJkvqgnSOAEeDrETHd/8uZ+S8R8ThwT0TcAPwIuKr0f5DmFUDjwMvA9QCZeTQiPgY8XvrdnJlHO1aJJGlB5g2AzHweeNss7T8FLp6lPYEb51jXTmDnwocpSeo0vwksSZUyACSpUgaAJFWq3e8BaADs+89jXLftgb5s++D2y/uyXUmL5xGAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkirlzeDUEau7eBO6rWun5rzJnTehkxbPIwBJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqVNsBEBFLIuI7EXF/mT83Ih6NiAMRcXdEnFraX1vmx8vy1S3r+HBpfy4iLu10MZKk9i3kCOADwP6W+U8At2XmGuBF4IbSfgPwYma+Gbit9CMizgM2AW8FNgCfiYglJzZ8SdJitRUAEbESuBz4QpkP4J3AvaXLLuCKMr2xzFOWX1z6bwTuysxXMvOHwDiwrhNFSJIWrt0jgL8F/gr43zL/JuClzJwq8xPAijK9AngBoCw/Vvq/2j7LcyRJPbZ0vg4R8SfAkcx8MiLGpptn6ZrzLDvec1q3twXYAjAyMkKj0ZhviAs2OTnZlfX228hpsHXt1PwdB8zx6hr0/Tisr0XrGgzzBgBwEfCeiLgMeB3wWzSPCM6IiKXlXf5K4FDpPwGsAiYiYinwRuBoS/u01ue8KjN3ADsARkdHc2xsbBFlHV+j0aAb6+23T995H7fua2eXDpata6fmrOvgNWO9HUyHDetr0boGw7yngDLzw5m5MjNX0/wQ95HMvAbYC1xZum0G7ivTu8s8ZfkjmZmlfVO5SuhcYA3wWMcqkSQtyIm8XfwQcFdEfBz4DnBHab8D+FJEjNN8578JIDOfjYh7gO8BU8CNmfmrE9i+JOkELCgAMrMBNMr088xyFU9m/hK4ao7n3wLcstBBSpI6z28CS1KlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgv6p/DSyWb1tgf6tu2D2y/v27alTvAIQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVLzBkBEvC4iHouI70bEsxHx0dJ+bkQ8GhEHIuLuiDi1tL+2zI+X5atb1vXh0v5cRFzaraIkSfNr5wjgFeCdmfk24O3AhohYD3wCuC0z1wAvAjeU/jcAL2bmm4HbSj8i4jxgE/BWYAPwmYhY0sliJEntmzcAsmmyzJ5SHgm8E7i3tO8CrijTG8s8ZfnFERGl/a7MfCUzfwiMA+s6UoUkacHa+gwgIpZExFPAEWAP8APgpcycKl0mgBVlegXwAkBZfgx4U2v7LM+RJPVYW/8RLDN/Bbw9Is4Avg68ZbZu5WfMsWyu9l8TEVuALQAjIyM0Go12hrggk5OTXVlvv42cBlvXTs3fccCcrHV14jU0rK9F6xoMC/qXkJn5UkQ0gPXAGRGxtLzLXwkcKt0mgFXAREQsBd4IHG1pn9b6nNZt7AB2AIyOjubY2NhChtiWRqNBN9bbb5++8z5u3Td8/+Vz69qpk7Kug9eMnfA6hvW1aF2DoZ2rgM4u7/yJiNOAdwH7gb3AlaXbZuC+Mr27zFOWP5KZWdo3lauEzgXWAI91qhBJ0sK087ZqObCrXLHzGuCezLw/Ir4H3BURHwe+A9xR+t8BfCkixmm+898EkJnPRsQ9wPeAKeDGcmpJktQH8wZAZj4NvGOW9ueZ5SqezPwlcNUc67oFuGXhw5QkdZrfBJakShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkip18t1jdwis3vZAX7a7dW1fNitpQHkEIEmVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKjVvAETEqojYGxH7I+LZiPhAaT8rIvZExIHy88zSHhFxe0SMR8TTEXF+y7o2l/4HImJz98qSJM2nnSOAKWBrZr4FWA/cGBHnAduAhzNzDfBwmQd4N7CmPLYAn4VmYAA3ARcC64CbpkNDktR78wZAZh7OzG+X6Z8D+4EVwEZgV+m2C7iiTG8EvphN3wLOiIjlwKXAnsw8mpkvAnuADR2tRpLUtgV9BhARq4F3AI8CI5l5GJohAZxTuq0AXmh52kRpm6tdktQHS9vtGBGvB74KfDAzfxYRc3adpS2P0z5zO1tonjpiZGSERqPR7hDbNjk52ZX1Ttu6dqpr6z6ekdP6t+1uOlnr6sRrqNuvxX6xrsHQVgBExCk0//jfmZlfK80/jojlmXm4nOI5UtongFUtT18JHCrtYzPaGzO3lZk7gB0Ao6OjOTY2NrPLCWs0GnRjvdOu2/ZA19Z9PFvXTnHrvrYzfWCcrHUdvGbshNfR7ddiv1jXYGjnKqAA7gD2Z+YnWxbtBqav5NkM3NfSfm25Gmg9cKycInoIuCQiziwf/l5S2iRJfdDO26qLgPcC+yLiqdL2EWA7cE9E3AD8CLiqLHsQuAwYB14GrgfIzKMR8THg8dLv5sw82pEqJEkLNm8AZOa/M/v5e4CLZ+mfwI1zrGsnsHMhA5QkdYffBJakShkAklQpA0CSKmUASFKlDABJqpQBIEmVMgAkqVIGgCRVygCQpEqdfHfYkgbE6g7c9G/r2qkF3zzw4PbLT3i7EngEIEnVMgAkqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVCkDQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqtS8ARAROyPiSEQ809J2VkTsiYgD5eeZpT0i4vaIGI+IpyPi/JbnbC79D0TE5u6UI0lqVztHAP8IbJjRtg14ODPXAA+XeYB3A2vKYwvwWWgGBnATcCGwDrhpOjQkSf0xbwBk5jeBozOaNwK7yvQu4IqW9i9m07eAMyJiOXApsCczj2bmi8AefjNUJEk9tNjPAEYy8zBA+XlOaV8BvNDSb6K0zdUuSeqTpR1eX8zSlsdp/80VRGyhefqIkZERGo1GxwY3bXJysivrnbZ17VTX1n08I6f1b9vdNKx1weJq6+Zrt1O6/TvWL8NW12ID4McRsTwzD5dTPEdK+wSwqqXfSuBQaR+b0d6YbcWZuQPYATA6OppjY2OzdTshjUaDbqx32nXbHujauo9n69opbt3X6Uzvv2GtCxZX28FrxrozmA7q9u9YvwxbXYs9BbQbmL6SZzNwX0v7teVqoPXAsXKK6CHgkog4s3z4e0lpkyT1ybxvPSLiKzTfvS+LiAmaV/NsB+6JiBuAHwFXle4PApcB48DLwPUAmXk0Ij4GPF763ZyZMz9YliT10LwBkJlXz7Ho4ln6JnDjHOvZCexc0OgkSV3jN4ElqVIGgCRVygCQpEoZAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVcoAkKRKGQCSVKnhvMm6NMRW9+n/TQAc3H5537atzvMIQJIqZQBIUqUMAEmqlAEgSZUyACSpUgaAJFXKAJCkShkAklQpA0CSKmUASFKlDABJqtRQ3wtornumbF07xXV9vJ+KJJ0MPAKQpEoZAJJUKQNAkiplAEhSpQwASarUUF8FJKmz2v1vZJ2+0s7/RNYdHgFIUqUMAEmqlAEgSZXq+WcAEbEB+BSwBPhCZm7v9RgkDZZ2P3votGH/7KGnRwARsQT4e+DdwHnA1RFxXi/HIElq6vUpoHXAeGY+n5n/A9wFbOzxGCRJ9P4U0ArghZb5CeDCHo9Bktoy89RTL28k2YvTT5GZXd/IqxuLuAq4NDPfV+bfC6zLzPe39NkCbCmzvw8814WhLAN+0oX19pt1DZ5hrc26+ut3M/Ps+Tr1+ghgAljVMr8SONTaITN3ADu6OYiIeCIzR7u5jX6wrsEzrLVZ12Do9WcAjwNrIuLciDgV2ATs7vEYJEn0+AggM6ci4i+Ah2heBrozM5/t5RgkSU09/x5AZj4IPNjr7c7Q1VNMfWRdg2dYa7OuAdDTD4ElSScPbwUhSZUa6gCIiA0R8VxEjEfEtlmWXxcR/xURT5XH+/oxzoWIiJ0RcSQinpljeUTE7aXmpyPi/F6PcTHaqGssIo617Ku/7vUYFyMiVkXE3ojYHxHPRsQHZukzcPuszboGdZ+9LiIei4jvlto+Okuf10bE3WWfPRoRq3s/0g7IzKF80PyQ+QfA7wGnAt8FzpvR5zrg7/o91gXW9cfA+cAzcyy/DPgGEMB64NF+j7lDdY0B9/d7nIuoazlwfpl+A/Afs7wOB26ftVnXoO6zAF5fpk8BHgXWz+jz58DnyvQm4O5+j3sxj2E+AhjK205k5jeBo8fpshH4YjZ9CzgjIpb3ZnSL10ZdAykzD2fmt8v0z4H9NL8R32rg9lmbdQ2ksh8my+wp5THzw9KNwK4yfS9wcUREj4bYMcMcALPddmK2F+iflsPueyNi1SzLB027dQ+iPyqH5d+IiLf2ezALVU4TvIPmO8pWA73PjlMXDOg+i4glEfEUcATYk5lz7rPMnAKOAW/q7ShP3DAHwGxpPDPF/xlYnZl/CPwb/5/og6ydugfRt2l+vf1twKeBf+rzeBYkIl4PfBX4YGb+bObiWZ4yEPtsnroGdp9l5q8y8+0071awLiL+YEaXgd1nrYY5ANq57cRPM/OVMvsPwAU9Gls3zVv3IMrMn00flmfzuySnRMSyPg+rLRFxCs0/kndm5tdm6TKQ+2y+ugZ5n03LzJeABrBhxqJX91lELAXeyACewhzmAJj3thMzzrO+h+Z5zEG3G7i2XFmyHjiWmYf7PagTFRG/PX2ONSLW0Xzt/rS/o5pfGfMdwP7M/OQc3QZun7VT1wDvs7Mj4owyfRrwLuD7M7rtBjaX6SuBR7J8IjxIev5N4F7JOW47ERE3A09k5m7gLyPiPcAUzfS+rm8DblNEfIXm1RXLImICuInmh1Rk5udofsv6MmAceBm4vj8jXZg26roS+LOImAL+G9g0IL9wFwHvBfaVc8oAHwF+BwZ6n7VT16Dus+XArmj+A6vXAPdk5v0z/nbcAXwpIsZp/u3Y1L/hLp7fBJakSg3zKSBJ0nEYAJJUKQNAkiplAEhSpQwASaqUASBJlTIAJKlSBoAkVer/AMU+R5LfpN4fAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "avocado_hist = df['AveragePrice'].hist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1b7f1547358>"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "avocado_hist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x1b7f1556240>"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAWQAAAEKCAYAAAAl5S8KAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAD65JREFUeJzt3X1sXfV9x/HPJ3aeIC1NnSxB4cGL3IhkoetohqhgXbaGLkRTWQVRAWmEDpaOiZCxP7ZpCUvSRftnEhtxhdp07ZpUG6SUtWLImJJ1rNpUHsJTE2IW3dEUyBpInS48BQeH7/44x65j7PjGse/9XvN+SRH3nnPuPb/Dsd8+PvfeY0eEAAD1N6neAwAAFAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkmk9l4VmzZkVra+s4DQUAJqYnn3zyZxExe6TlTinIra2t2rVr1+hHBQDvQ7Z/Us1ynLIAgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASCJU/qbehh77e3tqlQqNV/vgQMHJEnz5s2r+bolqa2tTWvWrKnLuoGsCHKdVSoVPbOnS8fP+HBN19v01hFJ0sGe2n8JNL11uObrBBoBQU7g+Bkf1tELVtR0ndOf75Ckmq934LoBnIhzyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASRBkAEiCIANAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkERNgtze3q729vZarApAie+7xtNci5VUKpVarAbAAHzfNR5OWQBAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASRBkAEiCIANAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgieZ6DwDA+Dl48KCWLl065LzFixdrz549wz7WtiLihGkrV67U008/rZdeeknHjh17z/yBZs+erUOHDmn16tXatm3biMtL0nnnnaczzzxTN954o9atW6eenh5NmTJF55xzjpqbm9XU1KSbbrpJ69atk221t7dr5syZ2rRpk2699Vbdcccdight3rxZLS0tJzx3d3e3Nm3apA0bNpwwb7jp1c4fSxwhAxPYK6+8Muy8k8VY0pDxvPfee1WpVNTT0zNiXA8dOiRJ2rp1a1XLS9KLL76orq4ubdy4UT09PZKkY8eO6YUXXtC+ffvU1dWlDRs26O2339bRo0e1efNmbdu2Tbt379bmzZu1d+9edXV1afv27e957r7lBs8bbnq188cSQQYmqIMHD9Z7CKP2xhtvVDVv//796ujoUERo//79/dMffPBBdXd399/v7u5WZ2enIkKdnZ3984abPtLjxktNTlkcOHBAR48e1dq1a2uxuoZSqVQ06djIRw4TyaS3X1Ol8jpfD+PsZEfHE0lvb+97pr3zzjvavn27brvtNknFUe67774rSTp+/Hj/vOGm9xlp/lgb8QjZ9mrbu2zv6vsVBAAyiwg9/PDD/fd37tzZH+7e3t7+ecNNH+lx42XEI+SI2CppqyQtWbJkVIdy8+bNkyTdeeedo3n4hLZ27Vo9+cL740imz7vTPqi2+XP4ehhnw72Y935gW5dffnn//WXLlqmjo0O9vb1qbm7unzfc9JEeN144hwxMUHPmzKn3EGqiufm9x5WTJ0/W9ddf339/1apVmjSpyF1TU1P/vOGmj/S48UKQgQlq7ty59R7CqM2YMaOqea2trVqxYoVsq7W1tX/6FVdcccJb1FpaWrR8+XLZ1vLly/vnDTd9pMeNF4IMTGAnO0pevHjxSR9r+z3TVq5cqba2Nk2dOnXI+QPNnj1bkrR69eqqlpeK9yEvXLhQGzdu1NSpUyVJU6ZM0fz587VgwQItXLhQmzZt0rRp0zR9+nStX79eq1at0oUXXqj169dr0aJFWrhw4ZBHsn3LDXUUPNT0auePJT4YAkxgc+fO1Y4dO+o9DF133XWn/JiHHnpo2HmdnZ0n3N+yZYsk6a677hr2MS0tLf3LVTO92vljiSNkAEiCIANAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASRBkAEiCIANAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACTRXIuVtLW11WI1AAbg+67x1CTIa9asqcVqAAzA913j4ZQFACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASRBkAEiCIANAEgQZAJIgyACQBEEGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASRBkAEiCIANAEgQZAJIgyACQBEEGgCSa6z0ASE1vHdb05ztqvM5uSar5eot1H5Y0p+brBbIjyHXW1tZWl/UeONArSZo3rx5hnFO37QYyI8h1tmbNmnoPAUASnEMGgCQIMgAkQZABIAmCDABJEGQASIIgA0ASBBkAkiDIAJAEQQaAJAgyACRBkAEgCYIMAEkQZABIgiADQBIEGQCSIMgAkARBBoAkCDIAJEGQASAJggwASTgiql/YPiTpJ2M8hlmSfjbGz5nFRN02tquxsF31d35EzB5poVMK8niwvSsiltR1EONkom4b29VY2K7GwSkLAEiCIANAEhmCvLXeAxhHE3Xb2K7GwnY1iLqfQwYAFDIcIQMAVMMg215u+79tV2z/xRDzb7B9yPYz5b+bajW202H767Zftb1nmPm2vaXc7h/ZvqjWYxyNKrZrqe0jA/bXX9V6jKNh+1zb/267y/ZzttcOsUzD7bMqt6vh9pntabYft/1suV2bhlhmqu0d5f56zHZr7Uc6RiJi3P9JapL0P5LmS5oi6VlJiwYtc4OkL9ViPGO8bZ+UdJGkPcPMXyHpQUmWdImkx+o95jHarqWSHqj3OEexXWdLuqi8/QFJ+4b4Wmy4fVbldjXcPiv3wYzy9mRJj0m6ZNAyfyzpy+XtayTtqPe4R/uvVkfIF0uqRMQLEXFM0j2SrqzRusdVRPxA0uGTLHKlpO1ReFTSh2yfXZvRjV4V29WQIuKnEfFUeft1SV2S5g1arOH2WZXb1XDKffBGeXdy+W/wC19XStpW3v62pE/Zdo2GOKZqFeR5kl4acP9lDf3FclX5K+K3bZ9bm6GNu2q3vRF9ovxV8kHbv1LvwZyq8lfbX1Nx1DVQQ++zk2yX1ID7zHaT7WckvSrp4YgYdn9FRK+kI5JaajvKsVGrIA/102rwT7l/ldQaER+VtFO/+InX6KrZ9kb0lIqPg/6qpHZJ363zeE6J7RmS7pP0JxHx2uDZQzykIfbZCNvVkPssIo5HxMcknSPpYtuLBy3SsPtrsFoF+WVJA494z5H0vwMXiIjuiOgp735V0sdrNLbxNuK2N6KIeK3vV8mI6JA02fasOg+rKrYnq4jWP0XEvwyxSEPus5G2q5H3mSRFxP9JekTS8kGz+veX7WZJZ6lBT7fVKshPSPqI7V+2PUXFiff7By4w6BzdZ1ScA5sI7pd0ffnK/SWSjkTET+s9qNNle27feTrbF6v4Wuqu76hGVo75a5K6IuKOYRZruH1WzXY14j6zPdv2h8rb0yUtk/T8oMXul7SqvH21pO9H+Qpfo2muxUoiotf2LZIeUvGOi69HxHO2vyhpV0TcL+lW25+R1Kvip9sNtRjb6bJ9t4pXr2fZflnSBhUvPCgiviypQ8Wr9hVJb0n6fH1Gemqq2K6rJd1su1fSUUnXNMg3waWSfl/S7vK8pCT9paTzpIbeZ9VsVyPus7MlbbPdpOIHyLci4oFB7fiapG/arqhoxzX1G+7p4ZN6AJAEn9QDgCQIMgAkQZABIAmCDABJEGQASIIgY8zY/qztsH1BvccymE+8muBe2384zHJLbG+p9fgAibe9YQzZ/paK943+W0RsPM3naoqI42MysOL5bpC0JCJusf1Lkp6TtDgiXhmwTHN5LQSgLjhCxpgor6FwqaQbVb4xv7xG7YoBy3zD9lXlxWL+1vYT5cWkvlDOX1pe0/efJe0up33X9pPltXBXD3iuG23vs/2I7a/a/lI5fbbt+8rnfsL2pYPHGhGvqrgc7Pm2N9reavt7kraXY3igb5ts/6Pt3eU4ryqnf9r2D20/ZfvectuB01aTT+rhfeH3JHVGxD7bh11c1P0eSZ+T1FF+ZP5Tkm5WEe0jEfHrtqdK+q8yiFJxqdbFEfHj8v4fRMTh8mOzT9i+T9JUSberuF7z65K+r+Ia25J0p6S/i4j/tH2eik+HLhw4UNvzVVybu1JO+rikyyLiqO2lAxa9vRznheXjZpbXflgvaVlEvGn7zyX9qaQvns7/PEAiyBg710r6+/L2PeX92yVtKaO7XNIPyuh9WtJHbV9dLn+WpI9IOibp8QExloqP1H+2vH1uudxcSf8REYclyfa9khaUyyyTtMi/uBzuB21/oLz9OduXSeqR9IUy9JJ0f0QcHWKblmnAx3Aj4ue2f1fSIhU/RKTiDy78sNr/ScDJEGScNtstkn5b0mLboeJ6JSHpz1Rcnet3VBwp3933EElrIuKhQc+zVNKbg+4vk/SJiHjL9iOSpmnoyy32mVQuf0Jgy3juiIhbhnjMm0NM6xvn4BdZrOKavNeeZAzAqHAOGWPhahV/YeP8iGiNiHMl/VjSZSqOlj8v6TdUnD5Q+d+bXVwuUrYX2D5ziOc9S9LPyxhfoOLPKUnS45J+szyF0CzpqgGP+Z6k/uja/thpbNfg55op6VFJl9puK6edYXvBMI8HTglBxli4VtJ3Bk27T9J1KqL2SUk7yz/fJUn/IGmvpKdc/BHVr2jo39Y6JTXb/pGkv1YRQ0XEAUl/o+IvYuwsn+tI+ZhbJS0pX4TbK+mPTmO7NkuaaXuP7Wcl/VZEHFJxJcK7y3E9Kind2/zQmHjbGxqS7RkR8UZ5hPwdFZd0HfxDAWgoHCGjUW0sr/u7R8XpkYb4c0TAyXCEDABJcIQMAEkQZABIgiADQBIEGQCSIMgAkARBBoAk/h8bqCXrdYdNFwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.boxplot(x=df['AveragePrice'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    18249.000000\n",
       "mean         1.405978\n",
       "std          0.402677\n",
       "min          0.440000\n",
       "25%          1.100000\n",
       "50%          1.370000\n",
       "75%          1.660000\n",
       "max          3.250000\n",
       "Name: AveragePrice, dtype: float64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['AveragePrice'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}