{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Monte Carlo Simulation with Python\n",
"\n",
"Notebook to accompany article on [Practical Business Python](https://pbpython.com/monte-carlo.html)\n"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import seaborn as sns"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"sns.set_style('whitegrid')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"# Define the variables for the Percent to target based on historical results\n",
"avg = 1\n",
"std_dev = .1\n",
"num_reps = 500\n",
"num_simulations = 1000"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"# Show an example of calculating the percent to target\n",
"pct_to_target = np.random.normal(avg, std_dev, num_reps).round(2)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([1.06, 1.27, 0.85, 0.91, 0.89, 1.18, 1.03, 0.83, 0.99, 0.89])"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pct_to_target[0:10]"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"# Another example for the sales target distribution\n",
"sales_target_values = [75_000, 100_000, 200_000, 300_000, 400_000, 500_000]\n",
"sales_target_prob = [.3, .3, .2, .1, .05, .05]\n",
"sales_target = np.random.choice(sales_target_values, num_reps, p=sales_target_prob)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([400000, 200000, 100000, 200000, 400000, 100000, 300000, 100000,\n",
" 75000, 200000])"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sales_target[0:10]"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Pct_To_Target | \n",
" Sales_Target | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1.06 | \n",
" 400000 | \n",
"
\n",
" \n",
" 1 | \n",
" 1.27 | \n",
" 200000 | \n",
"
\n",
" \n",
" 2 | \n",
" 0.85 | \n",
" 100000 | \n",
"
\n",
" \n",
" 3 | \n",
" 0.91 | \n",
" 200000 | \n",
"
\n",
" \n",
" 4 | \n",
" 0.89 | \n",
" 400000 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Pct_To_Target Sales_Target\n",
"0 1.06 400000\n",
"1 1.27 200000\n",
"2 0.85 100000\n",
"3 0.91 200000\n",
"4 0.89 400000"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Show how to create the dataframe\n",
"df = pd.DataFrame(index=range(num_reps), data={'Pct_To_Target': pct_to_target,\n",
" 'Sales_Target': sales_target})\n",
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEICAYAAABF82P+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3X9cjXf/B/DX6XckU/dOyXrcftzcawxZISyUpCUSNvbANLdoVpIfDyaMKW4zv/YDRzbsNjeSzPIjmqmH3yyM1YaxpXQyqUjnVKfr+4evc2uuOlfpnFOn1/Px8Hg417nO9Xm/O6fr1fXzyARBEEBERPQXZsYugIiIGiYGBBERiWJAEBGRKAYEERGJYkAQEZEoBgQREYliQDQRgYGBOHPmjN7Hyc3Nhbu7OzQazXMtZ/z48di9e3c9VUU1mTt3LjZt2lQvy7p58yY8PDy0j998803s27evXpYNABMmTMCBAwfqbXlUMwaECfDx8cHJkyerTEtMTMTYsWO1j5OTk9GrV68al3P79m3885//REVFRZ1rcXFxQUZGBszNzeu8DF1OnToFHx8f9OvXr8rKori4GCNGjMDDhw+rfe2ZM2fg7e1dp3E3bNgAd3d3uLu749VXX4Wbm5v2cWBgYJ2W+TxWrlyJ+fPn1zhP37590a1bN7i7u8PT0xNvv/02du/ejacvf1q+fDkmT56sc7y+ffvi/PnzNc7Trl07nfNIJdbftm3b8MYbb9TL8kk3C2MXQKajoqICFhb6/0jFxcVhw4YNqKysxIQJE+Dv7w9zc3N88sknmDx5Muzs7PQy7tSpUzF16lQAjwN49+7d2LFjR52XZ6if1+bNm+Hh4YHi4mKcPn0acXFxuHLlChYvXlyv4xiqHzIcbkE0EU9vZVy+fBkhISHo0aMH+vTpg2XLlgEAxo0bBwDw9PSEu7s7MjIyUFlZiS+++AIDBw6El5cX5syZgwcPHgD43xbH7t27MWDAALzzzjvPbIUUFhZi3rx56NevHzw9PfHee+8BAIqKijBlyhT07t0bnp6emDJlCvLy8iT18ujRI3Tq1Akvv/wyLC0tUVhYiMuXL+P27ds1/nX56NEjTJ48Gfn5+dq//JVKJcrKyhAbG4t+/fqhX79+iI2NRVlZWZ1+zosWLYK3tzd69OiBUaNG4eLFi9rnVq5ciZkzZyIqKgru7u5ITk5GSUkJZs6cCQ8PDwwdOhQbN26En5+f9jV37txBeHg4evXqBV9fX20gHT16FFu2bEFSUhLc3d0xatQonbXZ29tj8ODBWLlyJXbu3Ilbt24BAGbMmIEvvvgCAHD37l1MmjQJHh4e6NWrFyZMmAAAiIyMxL179zBp0iS4u7tj27ZtuHHjBl555RXs2rUL/fv3R1hYmHba027evImQkBC89tpriIiI0H5+0tLSqvQK/G8rpbr+nt5lpdFosG7dOgwYMAB9+vTBvHnztFuPT+rYs2cPvL290bt3b8THx0t7E0mLAdEExcbGYsKECfjxxx9x5MgRBAQEAAD+85//AADOnTuHjIwMuLu7IzExEXv37sW2bdtw9OhRPHr0CEuWLKmyvHPnzuHAgQPYvHnzM2PNmTMHpaWlSE5OxsmTJzFx4kQAQGVlJUJCQnDs2DEcO3YM1tbWzyy3Oo6OjsjKykJWVhZkMhns7e0RFxeHmJiYGl/XrFkzbNq0CXK5HBkZGcjIyICTkxPWr1+PS5cuYd++ffj222/x008/aVeYteXu7o79+/fjzJkz8PX1xfTp01FeXq59/vDhwxgxYgQuXLgAf39/rFmzBgUFBTh27Bg2btxYZX+9RqNBWFgY3N3dkZ6ejvj4eGzcuBFnz57FoEGDMHHiRAQHByMjIwMJCQmSa/Tw8ECrVq1w4cKFZ57btGkT2rVrh9OnTyM9PR0REREAgHXr1sHR0RGbN29GRkaGNjg0Gg0uXbqEQ4cOVfsz27dvHz7++GOkpaWhvLwcy5cv11mjlP7++9//4uDBg9i+fTtSUlJQUFBQZdkajQZXrlzBkSNHoFAosGbNGmRnZ0v6GdFjDAgTMW3aNHh4eGj/1bT7wMLCAn/88QcKCgrQvHlzdO/evdp59+/fj4kTJ8LV1RXNmzdHdHQ0Dhw4UOU4RUREBJo1awYbG5sqr83Pz0daWhoWL16Mli1bwtLSEj179gQAtGrVCv7+/rC1tYWdnR3Cw8Nx7tw5Sb0uXrwYsbGxWLBgAT7++GPs2LEDvXv3hlqtxqRJkzB+/HicPXtW0rKe9Dht2jQ4OjrCwcEB06ZNw7fffiv59U8LDg7W9jp16lQUFhZWWSn17NkT/fv3h5mZGWxsbHDw4EGEh4ejRYsWaNOmDd5++23tvBcuXIBarUZYWBisrKzQrl07hISEIDk5uU61PU0ul6OoqOiZ6RYWFsjPz8edO3dgZWUFT09PncuKjIyEra3tM+//EyEhIejQoQOaN2+OiIiIeqkfePy+TZo0CW3atIGdnR1mzJiB/fv3Vzm+EhERAWtra3Tt2hXt2rXDL7/8Ui9jNxXcYWgiPv/8c/Tp00f7+Mk+cjGxsbFYt24dAgIC8NJLL+H999/HwIEDRefNz89HmzZttI/btGmDiooK3Lt3TzvN2dlZ9LV5eXlo2bIlWrZs+cxzpaWlWLZsGdLT07UrqpKSEmg0Gp0HuN3c3PD1119r61u+fDl27tyJcePG4YMPPoBcLse4ceNw7NgxyGSyGpf1ZBkuLi7axy4uLsjPz9f5OjEbN25EYmIi/vzzT8hkMqjVaty/f1/7/NM/K0EQcO/ePbRu3Vr0+dzcXOTk5FQ5K0ij0VR5n+tKqVSKvi/h4eFYu3YtJkyYAAsLC7z99tsIDQ2tdjlmZmZwcnKqcayne3JxcUFpaal2N9Pz+Otn08XFBSqVCoWFhQAAc3NzODg4aJ+3tbVFSUnJc4/blDAgmqC2bdti1apVqKysREpKCiIjI3HmzBnRlalcLkdOTo72cW5uLiwsLODo6Kg9ZlDdStjZ2RlFRUUoLi6Gvb19lee+/PJL3Lx5E7t27cKLL76IzMxMBAcHo7Y3F162bBmioqJgY2ODX3/9FV26dIGVlRUqKipQUFAAR0fHKvNX12Nubi46duwI4PF+f7lcXqs6AODEiRP4+uuvsWXLFnTo0AGCIKBHjx5Venp6fJlMpv05urq6AkCV4zDOzs5o37499u/fLzqelPATc/78eRQWFuK111575rkWLVogJiYGMTExyMrKwoQJE9C1a1e89tprouNJqeHpnu7cuQNbW1u0aNECzZo1Q2lpqfa58vLyKls1upYt9tm0sbHBCy+8gIKCAp11kW7cxdQE7du3DwUFBTAzM9OuuJ/8tWVmZlZll8jQoUOxdetWZGdno6SkBKtXr0ZAQICks1Xkcjm8vb2xePFiFBUVoby8XLsbqaSkBNbW1rC3t0dhYSE+++yzWvdx4sQJqNVq7dbPSy+9hNOnT+PatWsoKyvDCy+88MxrHB0dUVhYWOUv2MDAQKxfvx4FBQUoKCjA559/jqCgoFrXU1JSAktLSzg4OKC8vBxr166FWq2u8TVDhgzBhg0b8ODBA+Tm5lY5K+rJCnzLli1Qq9WoqKhAVlYWrl69qu3l9u3bkkP1wYMHOHr0KObMmYPRo0ejbdu2z8yTmpqK7OxsCIIAOzs7mJmZabfonoxXW3v37sXNmzdRUlKCTz/9VHvMq3379igqKsKpU6dQXl6OTz/9FJWVldrX6epv6NCh+PLLL5Gbm4uHDx9izZo1GDp0aJ2Dk57FgGiC0tPTERgYCHd3d8TGxmL16tWwtraGra0tpk6dirFjx8LDwwMXL17EyJEjMWzYMIwbNw6+vr6wsrLCggULJI+1YsUKWFhYICAgAH369MHWrVsBAO+88w7UajV69+6Nt956C6+//nqteigrK8OKFSuqnCe/YMECfPjhhwgNDcWiRYtEd1V16NABgYGBGDRoEDw8PKBUKvHee++hS5cuGDZsGIYNG4bOnTtrz7aqjYEDB8LDwwODBg2Cr68vWrVqVWUXh5ioqCjY29tj4MCBmDx5MgICAmBlZQUAsLS0hEKhQEZGhvYssg8//BCPHj0C8DjYVCoVevbsiTFjxlQ7xpMzjwYOHIj4+HiEhYVVe4zqxo0bmDBhAnr06IFx48bh3Xff1R6jmjp1KlavXg0PDw/tCQ1SDBs2DDNnzoS3tzfMzMwwd+5cAICDgwPmz5+PWbNmoX///vjb3/6GVq1aaV+nq7+xY8fCz88PY8aMgZ+fH1544QXMmzdPcl2km4xfGETUcGzZsgXp6emiZ4QRGRq3IIiM6M6dO7h48SIqKytx7do1bNu2DYMGDTJ2WUQAeJCayKjKysrwwQcfIDc3F/b29hg2bBhGjx5t7LKIAHAXExERVYO7mIiISFSj3sV08eJFWFtb65xPrVZLmq8xMcWeANPsyxR7Akyzr6bSk1qtrvEOCk806oCwtraGm5ubzvkyMzMlzdeYmGJPgGn2ZYo9AabZV1PpKTMzU9JruYuJiIhEMSCIiEgUA4KIiEQxIIiISBQDgoiIRDEgiIhIFAOCiIhEMSCIiEgUA4KIiEQxIIj0RFWuAQCDX5n7ZFyi59Wob7VB1JDZWJqj7dxkg497a3mgwcck06S3LYh58+bBy8sLQ4cO1U7797//jSFDhiAoKAjTpk1DcXGx9rmNGzfCz88P/v7+SE9P11dZREQkkd4CIiQkBPHx8VWm9e3bF9999x3279+Ptm3bYuPGjQCA69evIzk5GcnJyYiPj8fixYuh0XAzmYjImPQWEJ6enmjZsmWVaf369YOFxeO9Wt27d0deXh4AIDU1FYGBgbCysoKrqyv+/ve/4/Lly/oqjYiIJDDaMYg9e/YgICAAAKBUKtGtWzftc05OTlAqlTqXoVarJd22VqVSSb69bWNhij0BptWXMW8bbYifoSm9V0+wp6qMEhDr16+Hubk5hg0bBgAQ+9ZTmUymczn8PgjT6gkw3b4MzRA/Q1N8r5pKT1IDw+ABsXfvXvzwww/YsmWLNgScnZ21u5uAx1sUcrnc0KUREdFTDHodRFpaGjZt2oT169fD1tZWO93HxwfJyckoKytDdnY2bt26ha5duxqyNCIi+gu9bUFER0fj7NmzuH//Pry9vREREQGFQoGysjKEhoYCALp164YlS5agY8eOCAgIwBtvvAFzc3MsXLgQ5ubm+iqNiIgk0FtArFq16plpo0ePrnb+8PBwhIeH66scIiKqJd5qg4iIRDEgiIhIFAOCiIhEMSCIiEgUA4KIiEQxIIiISBQDgoiIRDEgiIhIFAOCiIhEMSCIiEgUA4KIiEQxIIiISBQDgoiIRDEgiIhIFAOCiIhEMSCIiEgUA4KIiEQxIMikqco1xi6BqNHS21eOEjUENpbmaDs32Shj31oeaJRxieoLtyCIiEgUA4KIiEQxIIiISBQDgoiIRDEgiIhIlN4CYt68efDy8sLQoUO10woLCxEaGorBgwcjNDQURUVFAABBELB06VL4+fkhKCgIV69e1VdZREQkkd4CIiQkBPHx8VWmKRQKeHl5ISUlBV5eXlAoFACAtLQ03Lp1CykpKfjoo4/w4Ycf6qssIiKSSG8B4enpiZYtW1aZlpqaiuDgYABAcHAwjh49WmW6TCZD9+7dUVxcjPz8fH2VRkREEhj0Qrl79+5BLpcDAORyOQoKCgAASqUSzs7O2vmcnZ2hVCq181ZHrVYjMzNT57gqlUrSfI2JKfYE1H9fbm5u9basxsQQnw1T/Ayyp6oaxJXUgiA8M00mk+l8nbW1taQVQGZmpsmtKEyxJ8B0+zI0Q/wMTfG9aio9SQ0Mg57F5OjoqN11lJ+fDwcHBwCPtxjy8vK08+Xl5enceiAiIv0yaED4+PggKSkJAJCUlARfX98q0wVBwMWLF9GiRQsGBBGRkeltF1N0dDTOnj2L+/fvw9vbGxEREQgLC0NUVBQSEhLQunVrrF27FgDQv39/HD9+HH5+frC1tUVcXJy+yiIiIon0FhCrVq0Snb5169ZnpslkMixatEhfpRARUR3wSmoiIhLFgCAiIlEMCCIiEsWAICIiUQwIIiISxYAgIiJRDAgiIhLFgCAiIlEMCCIiEsWAICIiUQwIIiISxYAgIiJRDAgiIhLFgCAiIlEMCCIiEsWAICIiUQwIIiISxYAgIiJRDAgiIhLFgCAiIlEMCCIiEsWAICIiUQwIIiISxYAgIiJRDAgiIhJlYYxBt2zZgt27d0Mmk6FTp05YtmwZ8vPzER0djaKiIrzyyitYsWIFrKysjFEeERHBCFsQSqUS27Ztw549e/Ddd99Bo9EgOTkZK1euxMSJE5GSkgJ7e3skJCQYujQiInqKUXYxaTQaqFQqVFRUQKVS4cUXX8Tp06fh7+8PABgxYgRSU1ONURoREf0/g+9icnJywrvvvouBAwfC2toaffv2RefOnWFvbw8Li8flODs7Q6lU6lyWWq1GZmamzvlUKpWk+RoTU+wJqP++3Nzc6m1ZjYkhPhum+BlkT1UZPCCKioqQmpqK1NRUtGjRAtOnT0daWtoz88lkMp3Lsra2lrQCyMzMNLkVhSn2BJhuX4ZmiJ+hKb5XTaUnqYEhaRfTr7/+WvuqqnHy5Em89NJLcHBwgKWlJQYPHoyMjAwUFxejoqICAJCXlwe5XF5vYxIRUe1JCohFixZh1KhR2L59O4qLi59rQBcXF1y6dAmlpaUQBAGnTp3CP/7xD/Tq1QuHDx8GAOzduxc+Pj7PNQ4RET0fSbuYduzYgVu3bmHPnj0YOXIkunbtipCQEPTt27fWA3br1g3+/v4YMWIELCws4ObmhrfeegsDBgzAjBkzsGbNGri5uWH06NG1XjYREdUfyccg2rZti6ioKHTp0gVLly7Fzz//DEEQEB0djcGDB9dq0MjISERGRlaZ5urqylNbiYgaEEkBkZWVhcTERBw/fhx9+vTBhg0b0LlzZyiVSowZM6bWAUFERA2fpID46KOPMHr0aERHR8PGxkY73cnJCdOnT9dbcUREZDySAkKhUMDGxgbm5uYAgMrKSqjVatja2iI4OFivBRIRkXFIOospNDQUKpVK+7i0tBShoaF6K4qIiIxPUkCo1Wo0b95c+7h58+YoLS3VW1FERGR8kgLC1tYWV69e1T6+cuVKlWMRRERkeiQdg/jggw8wffp07dXNd+/exerVq/VaGBERGZekgOjatSsOHjyImzdvQhAEtG/fHpaWlvqujYiIjEjyhXI//fQTcnJyoNFotDd64hlMRESmS1JAzJ49G9nZ2Xj55Ze1p7rKZDIGBFEDpCrXwMbSXO/j/PUOoYYalwxHUkBcuXIFBw4ckHQLbiIyLhtLc7Sdm2zwcW8tDzT4mKRfks5i6tixI+7evavvWoiIqAGRtAVx//59BAYGomvXrlUOTm/YsEFvhRERkXFJCoiIiAh910FERA2MpIDo2bMncnJy8Pvvv6NPnz4oLS2FRqPRd21ERGREko5B7Nq1C5GRkVi4cCEAQKlUYtq0aXotjIiIjEtSQGzfvh07duyAnZ0dgMdfHlRQUKDXwoiIyLgkBYSVlRWsrKy0jysqKvRWEBERNQySjkF4enpiw4YNUKlUOHHiBL755hv4+PjouzYiIjIiSVsQs2bNgoODAzp16oSdO3eif//+iIqK0ndtZEJU5dJOavjr1blEZDyStiDMzMzw5ptv4s0339R3PWSieHUvUeMjKSB8fHxEb7ORmppa7wUREVHDICkg9uzZo/1/WVkZDh48iKKiIr0VRURExifpGESrVq20/5ycnDBx4kScPn1a37UREZERSdqCePrrRisrK3HlyhWUlJTorSgiIjI+SQGxfPny/73AwgJt2rTBmjVr6jxocXExYmJi8Ouvv0ImkyEuLg7t2rXDjBkzkJOTo11+y5Yt6zwGERE9H0kB8fXXX9froLGxsXj99dexbt06lJWVQaVSYcOGDfDy8kJYWBgUCgUUCgVmz55dr+MSEZF0kgLiq6++qvH50NBQyQM+fPgQ586d026VPLlKOzU1VRtEwcHBGD9+PAOCiMiIJH+j3E8//aS9evrYsWPw8PBA69ataz1gdnY2HBwcMG/ePGRlZaFz586YP38+7t27B7lcDgCQy+WS7vWkVqu1349dE5VKJWm+xqSx9cQL4JqGxvSZFNPYfq+keJ6eJH9hUGJiovZmfe+//z6mT5+O2NjYWg9YUVGBn3/+GQsWLEC3bt2wdOlSKBSKWi8HAKytrSWteDIzM01uBWWKPVHj19g/k6b4eyXWk9TAkHSaa25ubpWb9VlZWSEnJ6cWJf6Ps7MznJ2d0a1bNwDAkCFD8PPPP8PR0RH5+fkAgPz8fDg4ONRp+UREVD8kbUEMHz4co0aNgp+fH2QyGY4cOYLg4OA6Dfjiiy/C2dkZv/32G9q3b49Tp06hQ4cO6NChA5KSkhAWFoakpCT4+vrWaflERFQ/JAVEeHg4vL29cf78eQDAsmXL8Morr9R50AULFmDWrFkoLy+Hq6srli1bhsrKSkRFRSEhIQGtW7fG2rVr67x8IiJ6fpICAgBKS0thZ2eHkSNHoqCgANnZ2XB1da3ToG5ubkhMTHxm+tatW+u0PCIiqn+SjkF89tlniI+P1x5MLi8v5ymoREQmTlJAHDlyBOvXr4etrS0AwMnJibfaICIycZICwtLSEjKZTHvL70ePHum1KCIiMj5JxyACAgKwcOFCFBcXY9euXdizZw+/PIiIyMRJCohJkybhxIkTaN68OW7evInIyEj07dtX37URUSOiKtfAxtK8yY1tynQGhEajwaRJk7BlyxaGAhFVy1hfKwvwq2X1RecxCHNzc9jY2ODBgweGqIeIiBoISbuYrK2tERQUhD59+qBZs2ba6TExMXorjIiIjEtSQAwYMAADBgzQcylERNSQ1BgQubm5cHFxwYgRIwxVDxERNRA1HoOYNm2a9v8RERF6L4aIiBqOGgNCEATt/7Ozs/VeDBERNRw1BsSTK6f/+n8iIjJ9NR6DyMrKQo8ePSAIAtRqNXr06AHg8ZaFTCbDjz/+aJAiiYjI8GoMCFP7blYiIpJO0s36iIio6WFAEBGRKAYEERGJYkAQEZEoBkQToirXGLsEImpEJN2LiUwDb8dMRLXBLQgiIhLFgCAiIlEMCCIiEmW0gNBoNAgODsaUKVMAPL4Z4OjRozF48GBERUWhrKzMWKURERGMGBDbtm1Dhw4dtI9XrlyJiRMnIiUlBfb29khISDBWaUREBCMFRF5eHn744QeMGjUKwOOb/50+fRr+/v4AgBEjRiA1NdUYpRER0f8zymmucXFxmD17NkpKSgAA9+/fh729PSwsHpfj7OwMpVKpczlqtVrSDQVVKpXJ3XiwLj25ubnpqRoi46uP33GuK6oyeEAcO3YMDg4O6NKlC86cOVPtfFK+f8La2lrSSi8zM9PkVo6m2BPR86iP3wdT/L0S60lqYBg8IH788Ud8//33SEtLg1qtxsOHDxEbG4vi4mJUVFTAwsICeXl5kMvlhi6NiIieYvBjEDNnzkRaWhq+//57rFq1Cr1798Ynn3yCXr164fDhwwCAvXv3wsfHx9ClERHRUxrMdRCzZ8/GV199BT8/PxQWFmL06NHGLomIqEkz6r2YevXqhV69egEAXF1deWorEVED0mC2IIiIqGFhQBARkSgGBBERiWJAEBGRKAYEERGJYkAQEZEoBgQREYliQBARkSgGBBERiWJAEBGRKAYEERGJYkAQEZEoBgQREYliQBARkSgGBBERiWJAEBGRKAYEERGJYkAQEZEoBgQREYliQBARkSgGBBERiWJAEBGRKAYEERGJYkAQEZEoBgQREYkyeEDcuXMH48ePR0BAAAIDA7F161YAQGFhIUJDQzF48GCEhoaiqKjI0KUREdFTDB4Q5ubmmDt3Lg4ePIidO3fim2++wfXr16FQKODl5YWUlBR4eXlBoVAYujQiInqKwQNCLpejc+fOAAA7Ozu0b98eSqUSqampCA4OBgAEBwfj6NGjhi6NiIieYmHMwW/fvo3MzEx069YN9+7dg1wuB/A4RAoKCnS+Xq1WIzMzU+d8KpVK0nyNSV16cnNz01M1RMZXH7/jXFdUZbSAKCkpQWRkJD744APY2dnVaRnW1taSVnqZmZkmt3I0xZ6Inkd9/D6Y4u+VWE9SA8MoZzGVl5cjMjISQUFBGDx4MADA0dER+fn5AID8/Hw4ODgYozQiIvp/Bg8IQRAwf/58tG/fHqGhodrpPj4+SEpKAgAkJSXB19fX0KUREdFTDL6L6cKFC9i3bx86deqE4cOHAwCio6MRFhaGqKgoJCQkoHXr1li7dq2hSyMioqcYPCA8PDzwyy+/iD735JoIIiIyPl5JTUREohgQREQkigFBRESiGBBERCSKAUFEjZ6qXFMvy6ntRXL1NW5DZdRbbRAR1QcbS3O0nZts8HFvLQ80+JiGxC0II6iPvzpM7XYARNTwcAvCCPjXDhE1BtyCICIiUQwIIiISxYAgIiJRDAgiIhLFgCAiIlEMCCIiEsWAICIiUQwIIiISxYAgIiJRDAgiIhLFgCAiIlEMCCKiOjLm7b4NMTZv1kdEVEfGuvEmYJibbzbZLQhT/6IPIqLn1WS3IEw9+YmInleT3YIgIqKaMSCIiEhUgwuItLQ0+Pv7w8/PDwqFwtjlEBE1WQ0qIDQaDZYsWYL4+HgkJyfju+++w/Xr141dFhFRk9SgAuLy5cv4+9//DldXV1hZWSEwMBCpqanGLouIqEmSCYIgGLuIJw4dOoT09HTExsYCAJKSknD58mUsXLhQdP6LFy/C2trakCUSETV6arUa3bt31zlfgzrNVSyrZDJZtfNLaZCIiOqmQe1icnZ2Rl5envaxUqmEXC43YkVERE1XgwqIV199Fbdu3UJ2djbKysqQnJwMHx8fY5dFRNQkNahdTBYWFli4cCH+9a9/QaPRYOTIkejYsaOxyyIiapIa1EFqIiJqOBrULiYiImo4GBBERCTKpAJC12064uLiMHz4cAwfPhz+/v7w8PAwQpW1o6un3NxcjB8/HsHBwQgKCsLx48eNUGXt6eqfMrkoAAAEnElEQVQrJycH77zzDoKCgjB+/PgqZ7c1RPPmzYOXlxeGDh0q+rwgCFi6dCn8/PwQFBSEq1evGrjCutHV140bN/DWW2+hS5cu2Lx5s4GrqxtdPX377bcICgpCUFAQxowZg6ysLANXWDe6+jp69CiCgoIwfPhwhISE4Pz587oXKpiIiooKwdfXV/jjjz8EtVotBAUFCdeuXat2/m3btglz5841YIW1J6WnmJgYYfv27YIgCMK1a9eEgQMHGqPUWpHSV0REhJCYmCgIgiCcPHlSmDVrljFKlezs2bPClStXhMDAQNHnf/jhB2HSpElCZWWlkJGRIYwaNcrAFdaNrr7+/PNP4dKlS8KqVauE+Ph4A1dXN7p6unDhglBYWCgIwuP3zVTeq4cPHwqVlZWCIAhCZmam4O/vr3OZJrMFUdvbdCQnJ1ebtA2FlJ5kMhkePnwIAHjw4EGjuG5ESl83btyAl5cXAKB3794N/pYrnp6eaNmyZbXPp6amIjg4GDKZDN27d0dxcTHy8/MNWGHd6OrL0dERXbt2hYVFgzohska6eurRo4f2+e7duzf4rdcndPXVvHlz7YXHpaWlNV6E/ITJBIRSqYSzs7P2sZOTE5RKpei8OTk5uH37Nnr37m2o8upESk/vv/8+9u/fD29vb4SFhSEmJsbQZdaalL5efvllHD58GABw5MgRlJSU4P79+watsz79tWdnZ+dqP5/UcCQkJMDb29vYZdSbI0eOYMiQIZgyZQri4uJ0zm8yASHU4jYdycnJ8Pf3h7m5ub7Lei5SekpOTsaIESOQlpYGhUKBOXPmoLKy0lAl1omUvubMmYNz584hODgYZ8+ehZOTU6P6K/WvavP5pIbh9OnTSEhIwKxZs4xdSr3x8/PDoUOH8Pnnn2Pt2rU652+8v3F/UZvbdBw4cKDaGwA2JFJ6SkhIQHx8PADA3d0darUa9+/fh6Ojo0FrrQ0pfTk5OeGzzz4DAJSUlCAlJQUtWrQwaJ316a895+XlNYrdgU1VVlYWYmJisGnTJrRq1crY5dQ7T09P/PHHHygoKICDg0O185nMFoTU23T89ttvKC4uhru7uxGqrB0pPbVu3RqnTp0C8Hi/vVqtrvENbwik9FVQUKDdElIoFBg5cqQxSq03Pj4+SEpKgiAIuHjxIlq0aMGAaKByc3MRERGBFStWoF27dsYup978/vvv2i3Zq1evory8XGf4mdSV1MePH0dcXJz2Nh3h4eFYu3YtunTpAl9fXwDAp59+CrVa3Wg2G3X1dP36dcTExODRo0eQyWSYPXs2+vXrZ+yyddLV16FDh7Bq1SrIZDJ4eHhg0aJFsLKyMnbZ1YqOjsbZs2e1W28RERGoqKgAAIwdOxaCIGDJkiVIT0+Hra0t4uLi8Oqrrxq5at109XX37l2MHDkSDx8+hJmZGZo1a4YDBw7Azs7OyJVXT1dP8+fPR0pKClxcXAAA5ubmSExMNGbJkujqS6FQYN++fbCwsICNjQ1mz56t81R/kwoIIiKqPyazi4mIiOoXA4KIiEQxIIiISBQDgoiIRDEgiIhIFAOCiIhEMSCIiEjU/wFAxr7T/KCx8gAAAABJRU5ErkJggg==\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# Simple histogram to confirm distribution looks as expected\n",
"df['Pct_To_Target'].plot(kind='hist', title='Historical % to Target Distribution')"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEICAYAAABF82P+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3XtUlHX+B/D3AAIKSqINoD/Xlg6WaSoGKSCagwPhMIKKmac0J9wUDVC6eUlNw7ROecl0la12aTO3UsIKSwRvpFtawiFrKt0kr8wYVwEZbt/fHyzPSjyDIzrMKO/XOZ4z830u38/zFebNcx2FEEKAiIjoDxxsXQAREdknBgQREcliQBARkSwGBBERyWJAEBGRLAYEERHJYkDcxjQaDb755hur93PhwgX4+/ujoaHhhtYzffp0fPzxxzepqv/ZuHEjnn322Zu+3tvNjBkzsHv37puyriNHjmDChAnS+5CQEHz77bc3Zd0AMG7cOOTl5d209ZE8BsQtSqVS4ciRIy3a0tPTMW3aNOl9ZmYmRowY0eZ6zp07h3vuuQf19fXtrqVPnz7Iy8uDo6Nju9dxLRUVFVi0aBFCQkLg7++PiIgIpKamWq2/tixbtgz+/v7w9/fH4MGDMWjQIOn9rFmzOryeBQsWYPPmzWanm0wm3HPPPRg2bBj8/f0xYsQI6HQ6ZGVltZjvvffew/jx49vsq3ldRUVFbc4XHByMTz/91PKNaIPc9mVnZ8Pf3/+mrJ/Mc7J1AXRrq6+vh5OT9X+MVq9ejerqauzevRvdu3fH6dOncfLkSav3K2flypVYuXIlgKa9k99++w2vv/56u9fX0NBg1XBt9uWXX8Lb2xslJSXYt28fXnzxRRQWFuKpp566qf101M8EWR/3IG5jV+9lFBQUYNKkSRg+fDiCg4OxevVqAMDjjz8OAAgMDIS/vz/y8vLQ2NiIzZs3Y+zYsQgKCsLzzz+Py5cvA/jfHsfHH3+Mhx56CE888USrvZCysjIsWrQIo0aNQmBgIObOnQsAKC8vx+zZszFy5EgEBgZi9uzZ1/xLtNn3338PrVYLDw8PODg44O6778bDDz8sTU9JScGYMWMwfPhwTJo0qc3DGfn5+Xj00UcREBCACRMmtDgMl56ejrCwMPj7+0OlUrXrr+D6+nokJCQgODgYAQEBmD59On799Vdp+oIFC5CSkoInn3wSw4YNQ15eHoqLizFr1iwMHz4cjzzyCF5//XXMnDlTWuaXX37BjBkzEBgYiMjISGRnZwNo+qs/KysLmzdvhr+/PxITE69Zn6enJ2JjY7FkyRJs2rQJlZWVAIBHHnkEu3btAgD85z//wbRp0/DAAw9g5MiReP755wEAjz32GADg4Ycfhr+/P7Kzs3Ho0CGo1Wps2rQJwcHBeOmll6S2q+Xl5eHhhx/Ggw8+iKVLl6K2thYAsH379hbbevVeirntu/qQVU1NDVasWIFRo0Zh9OjRePXVV1FXVwcAUh1btmzByJEjERoaetP2bDoDBkQnsWrVKsyYMQPHjx/H3r17ERkZCQB4//33AQDHjh1DXl4e/P39kZ6ejk8++QTvvfcesrOzUV1dLf3F3OzYsWPYvXs33nnnnVZ9Pf/887hy5QoyMzNx5MgR6Ze/sbERkyZNwv79+7F//364uLi0Wq85Q4cOxbp167Bz504UFha2mn7//fcjIyMDR48eRVRUFJKSkmAymVrNZzAYMHv2bMTHx+Po0aN44YUXkJiYiJKSElRXVyMlJQV/+9vfkJeXh3/9618YOHCgRfX9kUqlwt69e3H48GH4+vpi4cKFLaZ/+umnSEpKwvHjxzFkyBAsXboUnp6eOHLkCFauXImMjAxp3srKSjz55JOIjY3F119/jVdffRWLFy/Gb7/9hhkzZiA8PBxz585FXl4e3nzzTYtrVKvVqKmpwYkTJ1pNW7t2LcaNG4dvv/0WBw4cwNSpUwEA27ZtA9C0N5KXl4dx48YBAM6fP4/6+nocOHAAL774omx/mZmZSEtLw5dffokff/wRb7/99jVrtGT73nzzTfz888/49NNPkZ6ejqNHj7ZY94ULFyCEQG5uLpYtW4bly5ejqqrq2gNEDIhb2bx58xAQECD9W7Fihdl5nZyccObMGZSUlMDNzQ3Dhg0zO+9nn32GmTNnol+/fnBzc0NycjJ2797d4jxFQkICunXrBldX1xbLGo1GHDp0CCtWrICHhwe6dOmCBx98EADQs2dPREREoGvXrnB3d0d8fDyOHTtm0bYuXboUWq0W27Ztg0ajgVqtxsGDB6Xp0dHR6NmzJ5ycnPDkk0+itrYWp0+fbrWeXbt2YfTo0RgzZgwcHBwQEhKCwYMHS+tycHDAyZMnUVNTA6VSCT8/P4vqu5qTkxMmTpwINzc3uLi44Omnn0ZBQUGLwIqIiMDQoUPh4OAAIQT27duHpKQkuLq64t5774VWq5Xm3bt3L/z8/DBhwgQ4OjpiyJAhGDt2LPbs2XPdtV2tW7du6N69O8rLy2W34fz587h06RJcXV3xwAMPtLkuZ2dnzJ07F87Ozq1+JprNmDEDXl5e8PT0xOzZs5GZmXlD9Tf77LPPkJCQAE9PT/Tu3Rvx8fHSnhAAuLq6Yvbs2ejSpQvUajUUCgXOnDlzU/q+3fFA4S2seZe+WXp6utmrgFatWoU333wTkZGR+L//+z88/fTTGDt2rOy8RqMRffv2ld737dsX9fX1KC4ultq8vb1lly0qKoKHhwc8PDxaTbty5QpWr16N3Nxc6UOpqqrKomPwrq6umDNnDubMmYPKykqkpqZi/vz52L9/P+644w68++67+Pjjj2E0GqFQKFBZWYnS0tJW67lw4QK+/PJL7N+/X2qrr6/HiBEj0K1bN6xbtw7vvvsulixZguHDh+OFF17A3Xff3WZtf1RfX4833ngDWVlZKC0tlUKgrKwMXl5eAFqO36VLlyCEaNHm7e0NvV4PoOmv82PHjiEgIECa3tDQgNjY2Ouq64+qq6tx+fJl2f+rxYsXY/369Zg4cSI8PT0xa9YsREdHm11X79690aVLlzb78/HxkV736dMHRqOx/cX/lxACv//+e6ufV4PBIL339PSEg8P//hbu2rUr9yAsxIDoJO666y6sXbsWjY2NyMrKQmJiIr755hsoFIpW8yqVSpw/f156f+HCBTg5OaFXr17SOQO55YCmD7by8nJUVFSgR48eLaa9++67OH36ND766CPceeed0Ov1iImJwfU+UNjd3R2zZ8/G1q1bce7cOZw6dQp/+9vf8I9//AN+fn5wcHBAYGCg7Hp9fHwQHR2NlJQU2XWHhoYiNDQUNTU1WL9+PZYuXYoPPvjguupLT0/HV199hffeew99+vTB77//jlGjRrWo5+rxu/POO6FQKGAwGNCnTx8AaHFuxsfHB6NGjcKWLVtk+zP3f3Ete/fuhaurKwYPHtxqmpeXF1avXg0hBI4ePYq4uDgEBgaid+/e7a7h4sWLLV4rlUoATR/YNTU10rRLly5ZvG6FQoHevXvj/Pnz+NOf/gSg6ee1OYjpxvAQUyexa9culJSUwMHBQfrgdnR0lP66Onv2rDRvVFQU0tLScPbsWVRVVWHdunWIjIy06MoUpVKJ0aNHY8WKFSgvL0ddXZ10GKmqqgouLi7o0aMHysrK8NZbb1lc/6ZNm1BQUIDa2lqYTCa899576NGjB/785z+jqqpK2pb6+nq89dZb0onXP5owYQL279+P3NxcNDQ0wGQy4ZtvvkFRURF+//135OTkoLq6Gs7OzujWrVu7ri5q3s477rgD1dXVWL9+fZvzu7i4YOzYsdi4cSNMJhN++eUXfPbZZ9L0cePG4ccff8Tu3btRV1eH2tpa5OfnS4fQevXq1eL/71pKS0vxySef4JVXXkF8fDzc3d1bzbN7924YDAYoFIoWPy/Ozs7o3r37dfXX7J///CeMRiNKSkqQmpoqnQcbOHAgfvzxR5w8eRJXrlzBpk2bWix3re2LiorCpk2bUFpaiuLiYmzZsqXFPRjUfgyITiI3NxcajQb+/v5YtWoV1q1bBxcXF3Tt2hVz5szBtGnTEBAQgPz8fEyePBkTJkzA448/jrCwMDg7O2Pp0qUW9/Xaa6/ByckJkZGRCA4ORlpaGgDgiSeegMlkwsiRIzF16lSEhoZavE6FQoHFixdLV6IcOXIEW7duhZubm3T1SkREBFQqFVxcXFoczriaj48PNm/ejK1btyIoKAhjxozBO++8g8bGRjQ2NuLvf/87QkND8eCDD+LYsWNYvny5xTU2i42NhaenJ0aNGgWtVnvN4/dA06WzRqMRI0eOxIsvvoioqCg4OzsDADw8PPDOO+9g586dGDVqFEJDQ7F+/XrpnNDUqVNx4sQJBAQEYMGCBWb7aL7y6OGHH0ZGRgaWL1+OOXPmyM6bl5eHyZMnw9/fH0lJSVi5cqX0V3liYiKSkpIQEBCAnJwci8dl/PjxmDFjBiIiIjBgwAD85S9/AQDcc889mDVrFh577DFERka2unfnWtuXmJiIu+++G1FRUYiOjsbw4cNtcj/K7UjBLwwisj8pKSmora21+CovImvgHgSRHfjll19w8uRJCCFw/Phx7Nq1S7qElMhWeJKayA5cvnwZzz//PH7//XfpUs3Ro0fbuizq5HiIiYiIZPEQExERybqlDzHl5+fDxcXFpjWYTCab12DPOD5t4/iYx7Fp242Mj8lkavNpCs1u6YBwcXFp97Nybha9Xm/zGuwZx6dtHB/zODZtu5Hxab5L/1p4iImIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEgWA4KIiGQxIIiISBYDgoiIZHXagKipa7gp62nPnYw3q28iImu6pR+1cSNcuzjiroWZNum7cI3GJv0SEV2PTrsHQUREbWNAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERyWJAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERyWJAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERybJaQFy8eBHTp09HZGQkNBoN0tLSAAAbN25EaGgooqOjER0djYMHD0rLbN26FWq1GhEREcjNzbVWaUREZAEna63Y0dERCxcuxKBBg1BZWYnJkycjJCQEADBz5kzExcW1mP/UqVPIzMxEZmYmDAYDdDod9uzZA0dHR2uVSEREbbDaHoRSqcSgQYMAAO7u7vD19YXBYDA7f05ODjQaDZydndGvXz/0798fBQUF1iqPiIiuoUPOQZw7dw56vR5Dhw4FAGzbtg1arRaLFi1CeXk5AMBgMMDb21taxsvLq81AISIi67LaIaZmVVVVSExMxOLFi+Hu7o5p06Zh7ty5UCgU2LBhA9asWYPVq1dDCNFqWYVC0ea6TSYT9Hp9u+oaOHBgu5a7Wdpb962mpqam02xre3B8zOPYtK0jxseqAVFXV4fExERotVqEh4cDAHr37i1NnzJlCubMmQMA8Pb2RlFRkTTNYDBAqVS2uX4XFxebf9C3161a9/XS6/WdZlvbg+NjHsembTcyPpYGi9UOMQkhsGTJEvj6+kKn00ntRqNRep2dnQ0/Pz8AgEqlQmZmJmpra3H27FkUFhZiyJAh1iqPiIiuwWp7EN999x127dqFAQMGIDo6GgCQnJyMzz//HD/99BMAoG/fvli5ciUAwM/PD5GRkRg/fjwcHR2xbNkyXsFERGRDVguIgIAA/Pzzz63ax4wZY3aZ+Ph4xMfHW6skIiK6DryTmoiIZDEgiIhIFgOCiIhkMSCIiEgWA4KIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEgWA4KIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEgWA4KIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEgWA4KIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEiW1QLi4sWLmD59OiIjI6HRaJCWlgYAKCsrg06nQ3h4OHQ6HcrLywEAQgikpKRArVZDq9Xihx9+sFZpRERkAasFhKOjIxYuXIgvvvgCH374IT744AOcOnUKqampCAoKQlZWFoKCgpCamgoAOHToEAoLC5GVlYWXX34ZL730krVKIyIiC1gtIJRKJQYNGgQAcHd3h6+vLwwGA3JychATEwMAiImJQXZ2NgBI7QqFAsOGDUNFRQWMRqO1yiMiomtw6ohOzp07B71ej6FDh6K4uBhKpRJAU4iUlJQAAAwGA7y9vaVlvL29YTAYpHnlmEwm6PX6dtU0cODAdi13s7S37ltNTU1Np9nW9uD4mMexaVtHjI/VA6KqqgqJiYlYvHgx3N3dzc4nhGjVplAo2ly3i4uLzT/o2+tWrft66fX6TrOt7cHxMY9j07YbGR9Lg8WqVzHV1dUhMTERWq0W4eHhAIBevXpJh46MRiM8PT0BNO0xFBUVScsWFRW1ufdARETWZbWAEEJgyZIl8PX1hU6nk9pVKhUyMjIAABkZGQgLC2vRLoRAfn4+unfvzoAgIrIhqx1i+u6777Br1y4MGDAA0dHRAIDk5GQ89dRTmD9/Pnbs2AEfHx9s2LABADBmzBgcPHgQarUaXbt2xSuvvGKt0oiIyAJWC4iAgAD8/PPPstOa74m4mkKhwPLly61VDhERXSfeSU1ERLIYEEREJIsBQUREshgQREQkiwFBRESyGBBERCSLAUFERLIsCohffvnF2nUQEZGdsehGueXLl6Ourg4TJ06EVqtFjx49rF0XERHZmEUBsX37dhQWFmLnzp2YPHkyhgwZgkmTJiEkJMTa9RERkY1Y/KiNu+66C/Pnz8fgwYORkpKCH3/8EUIIJCcnS09qJSKi24dFAfHTTz8hPT0dBw8eRHBwMLZs2YJBgwbBYDDg0UcfZUAQEd2GLAqIl19+GVOmTEFycjJcXV2ldi8vLyQlJVmtOCIish2LAiI1NRWurq5wdHQEADQ2NsJkMqFr167S90sTEdHtxaLLXHU6HWpqaqT3V65cafElQEREdPuxKCBMJhPc3Nyk925ubrhy5YrViiIiItuzKCC6du2KH374QXp/4sSJFuciiIjo9mPROYjFixcjKSlJ+o7oS5cuYd26dVYtjIiIbMuigBgyZAi++OILnD59GkII+Pr6okuXLtaujYiIbMjiG+W+//57nD9/Hg0NDdDr9QDAK5iIiG5jFgXEc889h7Nnz+Lee++VLnVVKBQMCCKi25hFAXHixAns3r0bCoXC2vUQEZGdsOgqJj8/P1y6dMnatRARkR2xaA+itLQUGo0GQ4YMaXFyesuWLVYrjIiIbMuigEhISLB2HUREZGcsCogHH3wQ58+fx2+//Ybg4GBcuXIFDQ0N1q6NiIhsyKJzEB999BESExOxbNkyAIDBYMC8efOsWhgREdmWRQGxbds2bN++He7u7gCavjyopKSkzWUWLVqEoKAgREVFSW0bN25EaGgooqOjER0djYMHD0rTtm7dCrVajYiICOTm5rZnW4iI6Cay6BCTs7MznJ2dpff19fXXXGbSpEl4/PHH8cILL7RonzlzJuLi4lq0nTp1CpmZmcjMzITBYIBOp8OePXukey6IiKjjWbQHERgYiC1btqCmpgaHDx9GUlISVCrVNZfx8PCwqIicnBxoNBo4OzujX79+6N+/PwoKCixaloiIrMOiPYhnn30WO3bswIABA/Dhhx9izJgxmDJlSrs63LZtGzIyMjB48GAsXLgQHh4eMBgMGDp0qDSPl5cXDAbDNddlMpmkx35cr4EDB7ZruZulvXXfampqajrNtrYHx8c8jk3bOmJ8LAoIBwcHPPLII3jkkUduqLNp06Zh7ty5UCgU2LBhA9asWYPVq1dDCNFqXkvu2nZxcbH5B3173ap1Xy+9Xt9ptrU9OD7mcWzadiPjY2mwWBQQKpVK9gM7Jyfnuorq3bu39HrKlCmYM2cOAMDb2xtFRUXSNIPBID1anIiIbMOigNi5c6f0ura2Fl988QXKy8uvuzOj0Sh98GdnZ8PPzw9AUwA988wz0Ol0MBgMKCwsxJAhQ657/UREdPNYFBA9e/Zs8X7mzJmYNm0akpKSzC6TnJyMo0ePorS0FKNHj0ZCQgKOHj2Kn376CQDQt29frFy5EkDTs54iIyMxfvx4ODo6YtmyZbyCiYjIxiwKiKu/brSxsREnTpxAVVVVm8usXbu2VVtbJ7bj4+MRHx9vSTlERNQBLAqINWvW/G8BJyf07dsX69evt1pRRERkexYFxD//+U9r10FERHbGooD4+9//3uZ0nU53U4ohIiL7YfE3yn3//ffS3dP79+9HQEAAfHx8rFocERHZjsVfGJSeni49rO/pp59GUlISVq1aZdXiiIjIdix6FtOFCxdaPKzP2dkZ58+ft1pRRERkexbtQURHRyM2NhZqtRoKhQJ79+5FTEyMtWsjIiIbsigg4uPjMXr0aHz77bcAgNWrV+O+++6zamFERGRbFh1iAoArV67A3d0dTzzxBLy9vXH27Flr1kVERDZmUUC89dZbePvtt5GamgoAqKurw3PPPWfVwoiIyLYsCoi9e/fir3/9K7p27Qqg6fsarvWoDSIiurVZFBBdunSBQqGQHvldXV1t1aKIiMj2LDpJHRkZiWXLlqGiogIfffQRdu7cecNfHkRERPbNooCIi4vD4cOH4ebmhtOnTyMxMREhISHWro2IiGzomgHR0NCAuLg4/OMf/2AoEBF1Itc8B+Ho6AhXV1dcvny5I+ohIiI7YdEhJhcXF2i1WgQHB6Nbt25S+4svvmi1woiIyLYsCoiHHnoIDz30kJVLISIie9JmQFy4cAF9+vTBxIkTO6oeIiKyE22eg5g3b570OiEhwerFEBGR/WgzIIQQ0ms+e4mIqHNpMyCa75z+42siIrr9tXkO4qeffsLw4cMhhIDJZMLw4cMBNO1ZKBQKHD9+vEOKJCKijtdmQOj1+o6qg4iI7IzF3wdBRESdCwOCiIhkMSCIiEgWA4KIiGRZLSAWLVqEoKAgREVFSW1lZWXQ6XQIDw+HTqdDeXk5gKarolJSUqBWq6HVavHDDz9YqywiIrKQ1QJi0qRJePvtt1u0paamIigoCFlZWQgKCpK+4/rQoUMoLCxEVlYWXn75Zbz00kvWKouIiCxktYAIDAyEh4dHi7acnBzExMQAAGJiYpCdnd2iXaFQYNiwYaioqIDRaLRWaUREZAGLnuZ6sxQXF0OpVAIAlEolSkpKAAAGgwHe3t7SfN7e3jAYDNK85phMpnbfqzFw4MB2LXezdJZ7TGpqajrNtrYHx8c8jk3bOmJ8OjQgzLn6mU/NLHm0h4uLi80/6NvLFnXX1DXAtYtjh/dr677tmV6vv2V/hq2NY9O2GxkfS4OlQwOiV69eMBqNUCqVMBqN8PT0BNC0x1BUVCTNV1RUdM29B7p+rl0ccdfCTJv0XbhGY5N+iaj9OvQyV5VKhYyMDABARkYGwsLCWrQLIZCfn4/u3bszIIiIbMxqexDJyck4evQoSktLMXr0aCQkJOCpp57C/PnzsWPHDvj4+GDDhg0AgDFjxuDgwYNQq9Xo2rUrXnnlFWuVRUREFrJaQKxdu1a2PS0trVWbQqHA8uXLrVUKERG1A++kJiIiWQwIIiKSxYAgIiJZDAgiIpLFgCAiIlkMCCIiksWAICIiWQwIIiKSxYAgIiJZDAgiIpLFgCAiIlkMCCIiksWAICIiWQwIIiKSxYAgIiJZDAgiIpLFgCAiIlkMCCIiksWAICIiWQwIIiupqWu45jwDBw60Sb9ElnCydQFEtyvXLo64a2Fmh/dbuEbT4X3S7Yl7EEREJIsBQUREshgQREQkiwFBRESyGBBERCSLAUFERLJscpmrSqWCm5sbHBwc4OjoiPT0dJSVlWHBggU4f/48+vbti/Xr18PDw8MW5REREWy4B5GWloZdu3YhPT0dAJCamoqgoCBkZWUhKCgIqamptiqNiIhgR4eYcnJyEBMTAwCIiYlBdna2jSsiIurcbHYndVxcHBQKBaZOnYqpU6eiuLgYSqUSAKBUKlFSUnLNdZhMJuj1+nb1b41HHFyP9tZ9IzrjNtuSLcf7dhjrmpqa22I7rKUjxscmAbF9+3Z4eXmhuLgYOp0Ovr6+7VqPi4uLzT/02utWrftGdMZttpXbYaz1ev1tsR3WciPjY2mw2OQQk5eXFwCgV69eUKvVKCgoQK9evWA0GgEARqMRnp6etiiNiIj+q8MDorq6GpWVldLrw4cPw8/PDyqVChkZGQCAjIwMhIWFdXRpRER0lQ4/xFRcXIx58+YBABoaGhAVFYXRo0fj/vvvx/z587Fjxw74+Phgw4YNHV0aERFdpcMDol+/fvj0009btffs2RNpaWkdXQ4REZlhN5e5EhGRfWFAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERyWJAEBGRLAYEERHJYkAQEZEsBgQREcliQBDRTVFT13BT13c933Vws/umJjb7Rjkiur24dnHEXQszbdJ34RqNTfqtqWuAaxdHm/T9p7va90Vr14MBQUTUTrd7KPIQExERyWJAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERyWJAEBGRLAYEERHJYkAQEZEsBgQREcliQBARkSwGBBERyWJAEBGRLLsLiEOHDiEiIgJqtRqpqam2LoeIqNOyq4BoaGjAypUr8fbbbyMzMxOff/45Tp06ZeuyiIg6JbsKiIKCAvTv3x/9+vWDs7MzNBoNcnJybF0WEVGnpBBCCFsX0ezLL79Ebm4uVq1aBQDIyMhAQUEBli1bJjt/fn4+XFxcOrJEIqJbnslkwrBhw645n1195ahcVikUCrPzW7KBRETUPnZ1iMnb2xtFRUXSe4PBAKVSacOKiIg6L7sKiPvvvx+FhYU4e/YsamtrkZmZCZVKZeuyiIg6Jbs6xOTk5IRly5Zh1qxZaGhowOTJk+Hn52frsoiIOiW7OklNRET2w64OMRERkf1gQBARkaxOHRCLFi1CUFAQoqKipLaysjLodDqEh4dDp9OhvLwcQNMluCkpKVCr1dBqtfjhhx+kZT49NQtgAAAGNElEQVT55BOEh4cjPDwcn3zyidR+4sQJaLVaqNVqpKSkSJfxmuvDnly8eBHTp09HZGQkNBoN0tLSAHB8mplMJsTGxmLChAnQaDR48803AQBnz57FlClTEB4ejvnz56O2thYAUFtbi/nz50OtVmPKlCk4d+6ctK6tW7dCrVYjIiICubm5Uru5x86Y68PeNDQ0ICYmBrNnzwbAsbmaSqWCVqtFdHQ0Jk2aBMBOf7dEJ3b06FFx4sQJodFopLZXX31VbN26VQghxNatW8Vrr70mhBDiwIEDIi4uTjQ2Noq8vDwRGxsrhBCitLRUqFQqUVpaKsrKyoRKpRJlZWVCCCEmT54sjh8/LhobG0VcXJw4cOBAm33YE4PBIE6cOCGEEOLy5csiPDxcnDx5kuPzX42NjaKyslIIIURtba2IjY0VeXl5IjExUXz++edCCCGWLl0qtm3bJoQQ4v333xdLly4VQgjx+eefi6SkJCGEECdPnhRarVaYTCZx5swZERYWJurr60V9fb0ICwsTZ86cESaTSWi1WnHy5EkhhDDbh7159913RXJysnjqqaeEEObr7oxjM3bsWFFcXNyizR5/tzr1HkRgYCA8PDxatOXk5CAmJgYAEBMTg+zs7BbtCoUCw4YNQ0VFBYxGI7766iuEhITgjjvugIeHB0JCQpCbmwuj0YjKykr4+/tDoVAgJiZGemyIuT7siVKpxKBBgwAA7u7u8PX1hcFg4Pj8l0KhgJubGwCgvr4e9fX1UCgU+PrrrxEREQEAmDhxorRN+/btw8SJEwEAERER+Pe//w0hBHJycqDRaODs7Ix+/fqhf//+KCgoMPvYGSGE2T7sSVFREQ4cOIDY2FgAaLPuzjY25tjj71anDgg5xcXF0s15SqUSJSUlAJpu2vP29pbm8/b2hsFgaNXu5eUl2948f1t92Ktz585Br9dj6NChHJ+rNDQ0IDo6GsHBwQgODka/fv3Qo0cPODk1XT1+9TYZDAb4+PgAaLqcu3v37igtLbV4fJrbS0tLzfZhT1555RU899xzcHBo+ohpq+7ONjbN4uLiMGnSJHz44YcA7POzx67ug7BnwsxjQK63/VZTVVWFxMRELF68GO7u7mbn64zj4+joiF27dqGiogLz5s3Dr7/+2mqe5m263nFobGw0uy5L221l//798PT0xODBg/HNN9+Yna8zjk2z7du3w8vLC8XFxdDpdPD19TU7ry1/t7gH8Qe9evWC0WgEABiNRnh6egJo/RiQoqIiKJVKs48HMTd/W33Ym7q6OiQmJkKr1SI8PBwAx0dOjx49MGLECOTn56OiogL19fUAWm6Tt7c3Ll68CKDpkNTly5dxxx13WDw+ze09e/Y024e9OH78OPbt2weVSoXk5GR8/fXXWLVqFcfmKl5eXgCaftbVajUKCgrs8neLAfEHKpUKGRkZAJqeJhsWFtaiXQiB/Px8dO/eHUqlEqNGjcJXX32F8vJylJeX46uvvsKoUaOgVCrh5uaG/Px8CCFk1/XHPuyJEAJLliyBr68vdDqd1M7xaVJSUoKKigoAQE1NDY4cOYK7774bI0aMwJ49ewA0XWHS/KgYlUolXWWyZ88ejBw5EgqFAiqVCpmZmaitrcXZs2dRWFiIIUOGmH3sjEKhMNuHvXjmmWdw6NAh7Nu3D2vXrsXIkSPxxhtvcGz+q7q6GpWVldLrw4cPw8/Pzz5/t6779PttZMGCBSIkJETcd999IjQ0VHz00UeipKREzJgxQ6jVajFjxgxRWloqhGi6auWll14SYWFhIioqShQUFEjr+fjjj8W4cePEuHHjxI4dO6T2goICodFoRFhYmFixYoVobGwUQgizfdiTY8eOiQEDBoioqCgxYcIEMWHCBHHgwAGOz3/p9XoRHR0toqKihEajERs3bhRCCHHmzBkxefJkMW7cOJGQkCBMJpMQQoiamhqRkJAgxo0bJyZPnizOnDkjrWvz5s0iLCxMhIeHS1ebCNF09Up4eLgICwsTmzdvltrN9WGPvv76a+kqJo5NkzNnzgitViu0Wq0YP368VL89/m7xURtERCSLh5iIiEgWA4KIiGQxIIiISBYDgoiIZDEgiIhIFgOCiIhkMSCIiEjW/wMCRGS48ioFJgAAAABJRU5ErkJggg==\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# Look at the sales target distribution\n",
"df['Sales_Target'].plot(kind='hist', title='Historical Sales Target Distribution')"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [],
"source": [
"# Back into the actual sales amount\n",
"df['Sales'] = df['Pct_To_Target'] * df['Sales_Target']"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [],
"source": [
"def calc_commission_rate(x):\n",
" \"\"\" Return the commission rate based on the table:\n",
" 0-90% = 2%\n",
" 91-99% = 3%\n",
" >= 100 = 4%\n",
" \"\"\"\n",
" if x <= .90:\n",
" return .02\n",
" if x <= .99:\n",
" return .03\n",
" else:\n",
" return .04"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [],
"source": [
"df['Commission_Rate'] = df['Pct_To_Target'].apply(calc_commission_rate)"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Pct_To_Target | \n",
" Sales_Target | \n",
" Sales | \n",
" Commission_Rate | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1.06 | \n",
" 400000 | \n",
" 424000.0 | \n",
" 0.04 | \n",
"
\n",
" \n",
" 1 | \n",
" 1.27 | \n",
" 200000 | \n",
" 254000.0 | \n",
" 0.04 | \n",
"
\n",
" \n",
" 2 | \n",
" 0.85 | \n",
" 100000 | \n",
" 85000.0 | \n",
" 0.02 | \n",
"
\n",
" \n",
" 3 | \n",
" 0.91 | \n",
" 200000 | \n",
" 182000.0 | \n",
" 0.03 | \n",
"
\n",
" \n",
" 4 | \n",
" 0.89 | \n",
" 400000 | \n",
" 356000.0 | \n",
" 0.02 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Pct_To_Target Sales_Target Sales Commission_Rate\n",
"0 1.06 400000 424000.0 0.04\n",
"1 1.27 200000 254000.0 0.04\n",
"2 0.85 100000 85000.0 0.02\n",
"3 0.91 200000 182000.0 0.03\n",
"4 0.89 400000 356000.0 0.02"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [],
"source": [
"# Calculate the commissions\n",
"df['Commission_Amount'] = df['Commission_Rate'] * df['Sales']"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Pct_To_Target | \n",
" Sales_Target | \n",
" Sales | \n",
" Commission_Rate | \n",
" Commission_Amount | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 1.06 | \n",
" 400000 | \n",
" 424000.0 | \n",
" 0.04 | \n",
" 16960.0 | \n",
"
\n",
" \n",
" 1 | \n",
" 1.27 | \n",
" 200000 | \n",
" 254000.0 | \n",
" 0.04 | \n",
" 10160.0 | \n",
"
\n",
" \n",
" 2 | \n",
" 0.85 | \n",
" 100000 | \n",
" 85000.0 | \n",
" 0.02 | \n",
" 1700.0 | \n",
"
\n",
" \n",
" 3 | \n",
" 0.91 | \n",
" 200000 | \n",
" 182000.0 | \n",
" 0.03 | \n",
" 5460.0 | \n",
"
\n",
" \n",
" 4 | \n",
" 0.89 | \n",
" 400000 | \n",
" 356000.0 | \n",
" 0.02 | \n",
" 7120.0 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Pct_To_Target Sales_Target Sales Commission_Rate Commission_Amount\n",
"0 1.06 400000 424000.0 0.04 16960.0\n",
"1 1.27 200000 254000.0 0.04 10160.0\n",
"2 0.85 100000 85000.0 0.02 1700.0\n",
"3 0.91 200000 182000.0 0.03 5460.0\n",
"4 0.89 400000 356000.0 0.02 7120.0"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head()"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"87970500.0 3017002.5 87850000\n"
]
}
],
"source": [
"print(df['Sales'].sum(), df['Commission_Amount'].sum(), df['Sales_Target'].sum())"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"\n",
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Pct_To_Target | \n",
" Sales_Target | \n",
" Sales | \n",
" Commission_Rate | \n",
" Commission_Amount | \n",
"
\n",
" \n",
" \n",
" \n",
" count | \n",
" 500.000000 | \n",
" 500.000000 | \n",
" 500.000000 | \n",
" 500.000000 | \n",
" 500.000000 | \n",
"
\n",
" \n",
" mean | \n",
" 1.000760 | \n",
" 175700.000000 | \n",
" 175941.000000 | \n",
" 0.033600 | \n",
" 6034.005000 | \n",
"
\n",
" \n",
" std | \n",
" 0.098028 | \n",
" 121703.053645 | \n",
" 123823.050417 | \n",
" 0.007613 | \n",
" 4745.301127 | \n",
"
\n",
" \n",
" min | \n",
" 0.710000 | \n",
" 75000.000000 | \n",
" 58500.000000 | \n",
" 0.020000 | \n",
" 1170.000000 | \n",
"
\n",
" \n",
" 25% | \n",
" 0.930000 | \n",
" 75000.000000 | \n",
" 82500.000000 | \n",
" 0.030000 | \n",
" 2932.500000 | \n",
"
\n",
" \n",
" 50% | \n",
" 1.005000 | \n",
" 100000.000000 | \n",
" 108000.000000 | \n",
" 0.040000 | \n",
" 4180.000000 | \n",
"
\n",
" \n",
" 75% | \n",
" 1.070000 | \n",
" 200000.000000 | \n",
" 228000.000000 | \n",
" 0.040000 | \n",
" 8415.000000 | \n",
"
\n",
" \n",
" max | \n",
" 1.280000 | \n",
" 500000.000000 | \n",
" 620000.000000 | \n",
" 0.040000 | \n",
" 24800.000000 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" Pct_To_Target Sales_Target Sales Commission_Rate \\\n",
"count 500.000000 500.000000 500.000000 500.000000 \n",
"mean 1.000760 175700.000000 175941.000000 0.033600 \n",
"std 0.098028 121703.053645 123823.050417 0.007613 \n",
"min 0.710000 75000.000000 58500.000000 0.020000 \n",
"25% 0.930000 75000.000000 82500.000000 0.030000 \n",
"50% 1.005000 100000.000000 108000.000000 0.040000 \n",
"75% 1.070000 200000.000000 228000.000000 0.040000 \n",
"max 1.280000 500000.000000 620000.000000 0.040000 \n",
"\n",
" Commission_Amount \n",
"count 500.000000 \n",
"mean 6034.005000 \n",
"std 4745.301127 \n",
"min 1170.000000 \n",
"25% 2932.500000 \n",
"50% 4180.000000 \n",
"75% 8415.000000 \n",
"max 24800.000000 "
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.describe()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Show Full Example of the simulation"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [],
"source": [
"# Define a list to keep all the results from each simulation that we want to analyze\n",
"all_stats = []\n",
"\n",
"# Loop through many simulations\n",
"for i in range(num_simulations):\n",
" \n",
" # Choose random inputs for the sales targets and percent to target\n",
" sales_target = np.random.choice(sales_target_values, num_reps, p=sales_target_prob)\n",
" pct_to_target = np.random.normal(avg, std_dev, num_reps).round(2)\n",
" \n",
" # Build the dataframe based on the inputs and number of reps\n",
" df = pd.DataFrame(index=range(num_reps), data={'Pct_To_Target': pct_to_target,\n",
" 'Sales_Target': sales_target})\n",
" \n",
" # Back into the sales number using the percent to target rate\n",
" df['Sales'] = df['Pct_To_Target'] * df['Sales_Target']\n",
" \n",
" # Determine the commissions rate and calculate it\n",
" df['Commission_Rate'] = df['Pct_To_Target'].apply(calc_commission_rate)\n",
" df['Commission_Amount'] = df['Commission_Rate'] * df['Sales']\n",
" \n",
" # We want to track sales,commission amounts and sales targets over all the simulations\n",
" all_stats.append([df['Sales'].sum().round(0), \n",
" df['Commission_Amount'].sum().round(0), \n",
" df['Sales_Target'].sum().round(0)])"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [],
"source": [
"results_df = pd.DataFrame.from_records(all_stats, columns=['Sales', 'Commission_Amount', 'Sales_Target'])"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
" \n",
" \n",
" \n",
" | \n",
" Sales | \n",
" Commission_Amount | \n",
" Sales_Target | \n",
"
\n",
" \n",
" count | \n",
" 1,000.0 | \n",
" 1,000.0 | \n",
" 1,000.0 | \n",
"
\n",
" mean | \n",
" 83,709,161.0 | \n",
" 2,858,654.0 | \n",
" 83,702,875.0 | \n",
"
\n",
" std | \n",
" 2,757,247.0 | \n",
" 102,738.0 | \n",
" 2,731,060.0 | \n",
"
\n",
" min | \n",
" 74,279,750.0 | \n",
" 2,509,105.0 | \n",
" 74,725,000.0 | \n",
"
\n",
" 25% | \n",
" 81,792,875.0 | \n",
" 2,790,037.0 | \n",
" 81,800,000.0 | \n",
"
\n",
" 50% | \n",
" 83,796,250.0 | \n",
" 2,858,382.0 | \n",
" 83,625,000.0 | \n",
"
\n",
" 75% | \n",
" 85,533,000.0 | \n",
" 2,925,028.0 | \n",
" 85,600,000.0 | \n",
"
\n",
" max | \n",
" 93,342,750.0 | \n",
" 3,240,805.0 | \n",
" 92,800,000.0 | \n",
"
\n",
"
"
],
"text/plain": [
""
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"results_df.describe().round(0).style.format('{:,}')"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEICAYAAABF82P+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAIABJREFUeJzt3XtYFPXiP/D3sgiYmAq0oB6PPnSwvIRieExQscWFcEHwQubzmEl0PJqJiF1EPeY1sXrKW6bUU3nykncwOaZCiZf04DXUsMQjiQqLcfO6ywKf3x/+nK/ogIuyzK6+X8/j88AwM5/3zl7ezuzMrkoIIUBERHQXB6UDEBGRbWJBEBGRLBYEERHJYkEQEZEsFgQREcliQRARkSwWBNkEk8mEZ555BoWFhUpHqbcpU6bgiy++eODlFy9ejNmzZzdgIqKGoeJ1EFQbPz8/6eebN2/CyckJarUaADBr1iwMGjSo1mX37NmDOXPmYNeuXRaNZTKZ4Ovri8zMTHh5ecnOs3v3bqxYsQKnT5+Gi4sLfHx8EBsbi6CgoHrcqsfPnj178I9//APTpk3DqFGjlI4jKzAwEIsWLYK/v7/SUegOjkoHINt17Ngx6WetVou5c+ciICBAkSxbt27FrFmzMH36dOh0OjRt2hRZWVnYvn07C+I+UlJS0LJlS6SkpNhsQZBt4iEmemBGoxGzZs1Cnz590K9fPyxYsABmsxmlpaV46623kJ+fDz8/P/j5+aG0tBRHjhxBdHQ0nn/+efTp0wcffPABKisr7ztOZWUlFixYgPj4eAwePBiurq5Qq9Xo3bu3dGimqqoKixcvRv/+/REQEIDExERcu3YNAHD27Fl07twZGzZsQN++fdGrVy9s3LgRx44dQ3h4OPz9/TF//nxpvLVr12LUqFGYPXs2nn/+eYSEhODEiRNYt24d+vbti4CAAKSlpUnzT5o0CcuWLQMAXL58GbGxsfD390evXr1qvCB/9tln6NOnD3r06IGwsDAcPnwYAPDxxx9j2rRp0nw7duzAwIED4e/vj9GjRyMvL0/6W2BgIL755huEh4fj+eefx+TJk1FRUVHrtrt69SoyMjIwc+ZMnD59Gr///rv0t/pul7q28Z49e6DT6WqMHRgYWOM2Tp48GQkJCfDz80NERARycnIAAHFxcSguLkZsbCz8/Pzw73//u9bbQ41MEFngxRdfFPv3768xbcGCBWLEiBGiuLhYXL58WQwZMkQsW7ZMCCFEZmamGDBgQI35f/nlF/HLL7+IyspK8ccff4gBAwaINWvWCCGEMBqNomPHjqKgoOCesX/99VfRsWNHYTAYas23atUq8dJLL4kLFy6Iq1evijFjxohp06YJIYTIzc0VHTt2FHPmzBEmk0mkp6eLbt26ibfeekuUlJSIixcvCn9/f3H8+HEhhBBr1qwRnTt3Flu3bhVms1kkJSWJ/v37i3nz5knL+/v7C6PRKIQQIj4+Xnz22WdCCCHmzZsn5syZI8xmszCZTCIrK0sIIUROTo7QarXi8uXLorq6Wpw/f16cP39eCCHERx99JKZOnSqEEOK3334T3bt3FwcPHhQmk0ksXbpUvPTSS8JsNgshhAgICBDDhw8Xly9fFsXFxWLAgAFi06ZNtW6XdevWif79+4vq6moxevRosWDBAulv9d0udW1jufs7ICBAHDp0SLqNvr6+Yt++faKyslLMmzdPjBw5UnZesh3cg6AH9v3332PChAlwc3ODh4cHxo0bh9TU1Frn9/X1ha+vL9RqNf76178iOjoahw4duu84ZWVlUKlU8PDwqDNLbGws2rZtC1dXV0yaNAnff/89xB1vsY0fPx5OTk4IDg4GAERGRqJVq1Zo06YN/Pz88Ouvv0rzent7IyIiAo6OjggLC8OlS5cwYcIEaXmz2YwLFy7ck8PR0RFFRUUoKCiAk5MTevbsCQBQq9UwmUzIzc1FVVUV2rVrh3bt2t2zfFpaGnQ6HXr16gUnJyeMHTsWpaWlOHnypDTP6NGj4eHhATc3NwQFBUn/E5ezZcsW6PV6qFQqhIeHY+vWraiqqqoxj6XbxZJtXJcXXngBgYGBUKvViIyMrDM32QYWBD0QIQT+/PNPtG3bVprWtm1bGAyGWpfJzc3FG2+8gYCAAPTo0QOfffYZSktL7ztWy5YtpfFqU1RUVCNLmzZtYDQaUVZWBuDWC3SrVq2kvzs7O9coHBcXF9y4cUP63d3dvcbfnJyc0Lx58xrL3zn/bePGjYNGo8GoUaOg0+nw9ddfAwB8fHwwefJkLFy4EAEBAZg8ebLs7SkqKkKbNm2k39VqNTw9PWts17py3+n8+fM4evQoIiIiAAChoaG4cuUK9u/fX2P9lm6X+23j+7E0N9kOFgQ9kNv/o7948aI07dKlS/D09JT+frfp06ejS5cu2LVrF44ePYrx48db9L9PHx8feHh4YOfOnbXOo9Fo7sni4uKCli1b1udmPbTmzZtj+vTp+Omnn7BkyRJ8/vnnOHLkCABg8ODB+O6775Ceno6KigosXLjwnuU1Gg0uXbok/V5VVQWDwSBt1/rYsmULAOD1119HYGAgQkNDUVVVVedeXl3q2sZPPPEEbt68Kf3NbDajvLzc4nXLPV5IeSwIemDh4eHSXkBxcTGWL18unfrq4eGB4uJiXL9+XZr/+vXrcHV1RbNmzXDmzBmsX7/eonEcHR3x7rvvYuHChUhJScG1a9dQXV2NrKwszJw5U8ry1Vdf4dKlS7h27RoWLlyI8PDwRn/hycjIQH5+PoQQcHV1hYODA9RqNXJzc5GVlYWKigq4uLjA2dkZDg73Pv3CwsKwa9cuHDp0CGazGcnJyWjZsiW6du1arxxCCKSmpiIhIQEpKSnSv48//hjp6enSm8v1Udc29vb2Rnl5OQ4cOACz2YwlS5agurra4nW7u7vLHrIjZbEg6IHFxcXh6aefRnh4OCIjI9GjRw+88cYbAIBnn30WWq0WWq0W/v7+KCsrw9SpU7Fx40b4+flh9uzZGDhwoMVjRUZG4qOPPsJ3332Hvn37IjAwEEuXLpWOm48YMQI6nQ6vvPIKdDodWrZsicTERKvc7rqcPXsWo0aNQo8ePTBy5Ei8/vrr6N69O4xGI5KSktCrVy/06dMHN27cwMSJE+9Z/tlnn8W8efMwY8YM9O7dGwcOHMCyZcvg6Fi/M9KzsrJQUlKCESNG4KmnnpL+vfTSS/D09MT27dvrfdvq2sZubm6YNm0a3n77bQQFBcHDw6PGoav7GTt2LD799FP4+/tj1apV9c5G1sEL5YiISBb3IIiISBYLgoiIZLEgiIhIFguCiIhk2fWH9R0/fhzOzs4Wz28ymeo1vxLsISNgHzntISPAnA3JHjICyuc0mUzo3r37feez64JwdnZGp06dLJ4/JyenXvMrwR4yAvaR0x4yAszZkOwhI6B8Tks/5oSHmIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCHmlGc9VjOTZRQ7Drj9oguh+XJmp0mJKmyNh5SXpFxiVqKNyDILISS/cgGvozebjnQg2FexBEVqLU3gv3XKihcA+CiIhksSCIiEiW1QqioKAAr776KsLCwqDX67Fy5UoAwJIlS9C3b19ERkYiMjISmZmZ0jIrVqyATqdDaGgo9u7da61oRERkAau9B6FWqzFlyhR06dIF165dw9ChQxEYGAgAGD16NGJjY2vMn5ubi7S0NKSlpcFgMCAmJgY7duyAWq22VkQiIqqD1fYgNBoNunTpAgBwdXWFt7c3DAZDrfNnZGRAr9fDyckJ7dq1Q/v27ZGdnW2teEREdB+NchbThQsXkJOTg27duuHo0aNYvXo1UlJS0LVrV0yZMgUtWrSAwWBAt27dpGU8PT3rLBTg1veqWvrVeQBgNBrrNb8S7CEjYB85jUaj0hEUY437xl7uc1vPCNhPTqsXxPXr1xEXF4epU6fC1dUVI0aMwJtvvgmVSoVFixYhKSkJ8+fPhxDinmVVKlWd6+Z3UivHHnLawxPQWqxx39jLfW7rGQHlc9rEd1KbzWbExcUhIiICISEhAAAPDw+o1Wo4ODggOjoaJ06cAAB4eXmhsLBQWtZgMECj0VgzHhER1cFqBSGEwLRp0+Dt7Y2YmBhpelFRkfRzeno6fHx8AABarRZpaWmoqKhAfn4+8vLy4Ovra614RER0H1Y7xHTkyBGkpqaiY8eOiIyMBAAkJCRg27ZtOH36NACgbdu2mD17NgDAx8cHYWFhGDhwINRqNWbMmMEzmIiIFGS1gvD398dvv/12z/SgoKBalxk3bhzGjRtnrUhERFQPvJKaiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhkWa0gCgoK8OqrryIsLAx6vR4rV64EAJSVlSEmJgYhISGIiYlBeXk5AEAIgblz50Kn0yEiIgKnTp2yVjQiIrKA1QpCrVZjypQp2L59O9atW4c1a9YgNzcXycnJ6N27N3bu3InevXsjOTkZALBnzx7k5eVh586dmDNnDmbOnGmtaEREZAGrFYRGo0GXLl0AAK6urvD29obBYEBGRgaioqIAAFFRUUhPTwcAabpKpUL37t1x5coVFBUVWSseERHdh2NjDHLhwgXk5OSgW7duKC4uhkajAXCrREpKSgAABoMBXl5e0jJeXl4wGAzSvHJMJhNycnIszmE0Gus1vxLsISNgHzmNRqPSERRjjfvGXu5zW88I2E9OqxfE9evXERcXh6lTp8LV1bXW+YQQ90xTqVR1rtvZ2RmdOnWyOEtOTk695leCPWQE7COnPTwBrcUa94293Oe2nhFQPqelzw2rnsVkNpsRFxeHiIgIhISEAADc3d2lQ0dFRUVwc3MDcGuPobCwUFq2sLCwzr0HIiKyLqsVhBAC06ZNg7e3N2JiYqTpWq0WKSkpAICUlBQEBwfXmC6EwPHjx9G8eXMWBBGRgqx2iOnIkSNITU1Fx44dERkZCQBISEjAmDFjEB8fj40bN6J169ZYtGgRACAoKAiZmZnQ6XRo2rQpPvjgA2tFIwUYzVVwaaJu1DHt4VADkS2zWkH4+/vjt99+k/3b7Wsi7qRSqfD+++9bKw4pzKWJGh2mpDX6uHlJ+kYfk+hRwSupiYhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIIiISBYLgoiIZLEgiIhIlkUF8fvvv1s7BxER2RhHS2Z6//33YTabMXjwYERERODJJ5+0di4iIlKYRQWxdu1a5OXlYdOmTRg6dCh8fX0xZMgQBAYGWjsfEREpxKKCAIAOHTogPj4eXbt2xdy5c/Hrr79CCIGEhASEhIRYMyMRESnAooI4ffo0Nm/ejMzMTAQEBGD58uXo0qULDAYDXnnlFRYEEdEjyKKCmDNnDqKjo5GQkAAXFxdpuqenJyZOnGi1cEREpByLCiI5ORkuLi5Qq9UAgOrqaphMJjRt2hRRUVFWDUhERMqw6DTXmJgYGI1G6febN28iJibGaqGIiEh5FhWEyWRCs2bNpN+bNWuGmzdvWi0UEREpz6KCaNq0KU6dOiX9fvLkyRrvRRAR0aPHovcgpk6diokTJ0Kj0QAALl++jE8//dSqwYiISFkWFYSvry+2b9+Oc+fOQQgBb29vNGnSpM5lEhMTsXv3bri7u2Pbtm0AgCVLlmD9+vVwc3MDACQkJCAoKAgAsGLFCmzcuBEODg6YPn06+vbt+zC3i4iIHpLFF8qdOHECFy9eRFVVFXJycgCgzjOYhgwZgpEjR+K9996rMX306NGIjY2tMS03NxdpaWlIS0uDwWBATEwMduzYIZ01RUREjc+ignjnnXeQn5+PZ599VnrRVqlUdRZEz549ceHCBYtCZGRkQK/Xw8nJCe3atUP79u2RnZ0NPz8/i5YnIqKGZ1FBnDx5Ev/5z3+gUqkeesDVq1cjJSUFXbt2xZQpU9CiRQsYDAZ069ZNmsfT0xMGg+G+6zKZTNLejCWMRmO95leCPWQE6p+zU6dOVkxDd7PGY8geHpv2kBGwn5wWFYSPjw8uX74svUn9oEaMGIE333wTKpUKixYtQlJSEubPnw8hxD3zWlJGzs7O9XrhycnJsfkXKnvICNhPzseVNe4be7jP7SEjoHxOS8vJooIoLS2FXq+Hr69vjTenly9fXq9QHh4e0s/R0dEYO3YsAMDLywuFhYXS3wwGw0OXERERPRyLCmLChAkNMlhRUZH0wp+eng4fHx8AgFarxeTJkxETEwODwYC8vDz4+vo2yJhERPRgLCqIv//977h48SL++OMPBAQE4ObNm6iqqqpzmYSEBGRlZaG0tBT9+vXDhAkTkJWVhdOnTwMA2rZti9mzZwO4dQgrLCwMAwcOhFqtxowZM3gGExGRwiwqiPXr12PdunUoLy9Heno6DAYD3n//faxcubLWZT755JN7pkVHR9c6/7hx4zBu3DhL4hARUSOw6KM2Vq9ejbVr18LV1RXArS8PKikpsWowIiJSlkUF4eTkBCcnJ+n3yspKqwUiIiLbYNEhpp49e2L58uUwGo3Yv38/1qxZA61Wa+1sRESkIIv2IN5++224ubmhY8eOWLduHYKCghAfH2/tbEREpCCL9iAcHBzw8ssv4+WXX7Z2HiIishEWFYRWq5W9sjkjI6PBAxHRwzGaq+DSpOFPE7/flb/WGpeUY1FBbNq0Sfq5oqIC27dvR3l5udVCEdGDc2miRocpaY0+bl6SvtHHJOuy6D2IVq1aSf88PT0xevRoHDx40NrZiIhIQRbtQdz5daPV1dU4efIkrl+/brVQRESkPIsKIikp6f8WcHRE27ZtsXDhQquFIiIi5VlUEN9++621cxARkY2xqCC+/vrrOv8eExPTIGGIiMh2WPyNcidOnJCunv7pp5/g7++P1q1bWzUcEREpx+IvDNq8ebP0YX1vvfUWJk6ciHnz5lk1HBERKcei01wvXbpU48P6nJyccPHiRauFIiIi5Vm0BxEZGYlhw4ZBp9NBpVJh165diIqKsnY2IiJSkEUFMW7cOPTr1w+HDx8GAMyfPx+dO3e2ajAiIlKWRYeYAODmzZtwdXXFa6+9Bi8vL+Tn51szFxERKcyigli6dCm+/PJLJCcnAwDMZjPeeecdqwYjIiJlWVQQu3btwueff46mTZsCADw9PflRG0REjziLCqJJkyZQqVTSR37fuHHDqqGIiEh5Fr1JHRYWhhkzZuDKlStYv349Nm3axC8PIiJ6xFlUELGxsdi/fz+aNWuGc+fOIS4uDoGBgdbORkRECrpvQVRVVSE2NhbffPMNS4GI6DFy3/cg1Go1XFxccPXq1cbIQ0RENsKiQ0zOzs6IiIhAQEAAnnjiCWn69OnTrRaMiIiUZVFB9O/fH/3797dyFCIisiV1FsSlS5fQpk0bDB48uLHyEBGRjajzPYjx48dLP0+YMMHqYYiIyHbUWRBCCOlnfvYSEdHjpc6CuH3l9N0/ExHRo6/O9yBOnz6NHj16QAgBk8mEHj16ALi1Z6FSqXD06NFal01MTMTu3bvh7u6Obdu2AQDKysowadIkXLx4EW3btsXChQvRokULCCEwb948ZGZmwsXFBUlJSejSpUsD3kwiIqqvOgsiJyfngVc8ZMgQjBw5Eu+99540LTk5Gb1798aYMWOQnJyM5ORkvPPOO9izZw/y8vKwc+dO/PLLL5g5cyY2bNjwwGMTEdHDs/j7IOqrZ8+eaNGiRY1pGRkZ0jfRRUVFIT09vcZ0lUqF7t2748qVKygqKrJWNCIisoBF10E0lOLiYmg0GgCARqNBSUkJAMBgMMDLy0uaz8vLCwaDQZq3NiaTqV57OUaj8aH2ihqDPWQE6p+zU6dOVkxDtkLpx+6j+vxRSqMWRG3uPFvqNkveFHd2dq7XC09OTo7Nv1DZQ0bAfnJS41L6MWEvj0ulc1paTlY7xCTH3d1dOnRUVFQENzc3ALf2GAoLC6X5CgsL77v3QERE1tWoBaHVapGSkgIASElJQXBwcI3pQggcP34czZs3Z0EQESnMaoeYEhISkJWVhdLSUvTr1w8TJkzAmDFjEB8fj40bN6J169ZYtGgRACAoKAiZmZnQ6XRo2rQpPvjgA2vFIiIiC1mtID755BPZ6StXrrxnmkqlwvvvv2+tKERE9AAa9RATERHZDxYEERHJYkEQEZEsFgQREcliQRARkSwWBBERyWJBEBGRLBYEERHJYkEQEZEsFgQREcliQRARkSwWBBERyWJBEBGRLBYEERHJYkEQEZEsFgQREcliQTxGjOaqBluXPXwxPBE9HKt9oxzZHpcmanSYkqbI2HlJekXGJaIHxz0IIiKSxYIgIiJZLAgiIpLFgiAiIlksCCIiksWCICIiWSwIIiKSxYIgIiJZLAgiIpLFgiAiIlksCCIiksWCICIiWYp8WJ9Wq0WzZs3g4OAAtVqNzZs3o6ysDJMmTcLFixfRtm1bLFy4EC1atFAiHhERQcE9iJUrVyI1NRWbN28GACQnJ6N3797YuXMnevfujeTkZKWiERERbOgQU0ZGBqKiogAAUVFRSE9PVzgREdHjTbHvg4iNjYVKpcLw4cMxfPhwFBcXQ6PRAAA0Gg1KSkruuw6TyYScnByLxzQajfWaXwnWzMgv+SFrU/r5ZQ/PccB+cipSEGvXroWnpyeKi4sRExMDb2/vB1qPs7NzvV70cnJybP5F0h4yEtVG6ceuvTx/lM5paTkpcojJ09MTAODu7g6dTofs7Gy4u7ujqKgIAFBUVAQ3NzclohER0f/X6AVx48YNXLt2Tfp5//798PHxgVarRUpKCgAgJSUFwcHBjR2NiIju0OiHmIqLizF+/HgAQFVVFcLDw9GvXz8899xziI+Px8aNG9G6dWssWrSosaMREdEdGr0g2rVrh61bt94zvVWrVli5cmVjxyEiolrYzGmuRERkW1gQREQkiwVBRESyWBBERCSLBUFERLJYEEREJIsFQUQNwmiueizHfpQp9mF9RPRocWmiRocpaYqMnZekV2TcRx33IIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGSxIBRQ1znb9vB1iUT0eOB1EApQ6nxxnitORPXBPQgiIpLFgiAiIlksCCIiksWCICIiWSwIIiKSxYIgIiJZLAgiIpLFgiAiu3f74tPGvtD0Uf+iIl4oR0R2jxefWgf3IIiISBYLgoiIZLEgiIhIFguCiIhksSCIiEgWC4KIiGTZXEHs2bMHoaGh0Ol0SE5OVjoOEdFjy6YKoqqqCrNnz8aXX36JtLQ0bNu2Dbm5uVYZ61G/wIWI6GHZ1IVy2dnZaN++Pdq1awcA0Ov1yMjIwN/+9rcGH0upC2uAR//iGqLHhdFcBZcm6nov1xBXfD/o2PWhEkIIq45QDz/88AP27t2LefPmAQBSUlKQnZ2NGTNmyM5//PhxODs7N2ZEIiK7ZzKZ0L179/vOZ1N7EHJdpVKpap3fkhtIREQPxqbeg/Dy8kJhYaH0u8FggEajUTAREdHjy6YK4rnnnkNeXh7y8/NRUVGBtLQ0aLVapWMRET2WbOoQk6OjI2bMmIE33ngDVVVVGDp0KHx8fJSORUT0WLKpN6mJiMh22NQhJiIish0sCCIikmWTBVFQUIBXX30VYWFh0Ov1WLlyJQBgyZIl6Nu3LyIjIxEZGYnMzExpmRUrVkCn0yE0NBR79+6Vptf20R35+fmIjo5GSEgI4uPjUVFRAQCoqKhAfHw8dDodoqOjceHChVrHqC0nAHz77bcIDQ2FXq/Hhx9+aJM54+PjpW2p1WoRGRmpWM7U1FTZjDk5OXj55ZcRGRmJIUOGIDs7G8CtU6Lnzp0LnU6HiIgInDp1Slrvli1bEBISgpCQEGzZskWafvLkSURERECn02Hu3LnSadVlZWWIiYlBSEgIYmJiUF5eXusYtW3L06dPY/jw4YiIiMDYsWNx7do1xbbljz/+iGHDhmHQoEHQ6/VYvHhxgz2WGjK7yWSSzblq1SrodDo888wzKCkpkdat1H1eW87JkycjNDQU4eHhSExMhNlsVjSnVQgbZDAYxMmTJ4UQQly9elWEhISIM2fOiMWLF4svv/zynvnPnDkjIiIihMlkEufPnxfBwcGisrJSVFZWiuDgYHH+/HlhMplERESEOHPmjBBCiLi4OLFt2zYhhBD/+te/xOrVq4UQQqxatUr861//EkIIsW3bNjFx4sRaxygoKJDNeeDAAfHaa68Jk8kkhBDizz//tMmcd5o/f75YsmSJYjn79+8vsrOz78kYExMjdu/eLYQQYvfu3WLkyJHSz7GxsaK6ulocO3ZMDBs2TAghRGlpqdBqtaK0tFSUlZUJrVYrysrKhBBCDB06VBw9elRUV1eL2NhYab0LFiwQK1asEEIIsWLFCvHhhx/WOkZtj80hQ4aI//73v0IIITZs2CA+/fRTxbalVqsV5eXlQgghKioqxLBhw8SxY8ca5LHUkNmrq6vFtWvX7sl56tQpkZ+fL1588UVRXFwsPUaVus9ry7l7925RXV0tqqurxaRJk6TbqlROa7DJPQiNRoMuXboAAFxdXeHt7Q2DwVDr/BkZGdDr9XByckK7du3Qvn17ZGdn1/joDicnJ+mjO4QQOHjwIEJDQwEAgwcPRkZGBgDgxx9/xODBgwEAoaGhOHDgAIQQsmMUFBTI5ly7di3GjBkDJycnAIC7u7tN5rxNCIHt27cjPDxcsZze3t6orKy8J6NKpcL169cBAFevXpWui8nIyEBUVBRUKhW6d++OK1euoKioCPv27UNgYCBatmyJFi1aIDAwEHv37kVRURGuXbsGPz9c53jhAAAFxklEQVQ/qFQqREVFSRlvrwsAoqKikJ6eXusYAGS35blz59CzZ08AQGBgIHbu3KnYtuzQoQPOnj0LAKisrERlZSVUKlWDPJYaMjsANGvW7J6cnTt3xl/+8hfcTan7/PLly7I5g4KCoFKpoFKp4OvrKz2nlMpZVFR0zzZ7WDZZEHe6cOECcnJy0K1bNwDA6tWrERERgcTERGl3y2AwwMvLS1rG09MTBoOh1umlpaV48skn4eh46yxfLy8v6c41GAxo3bo1gFun3TZv3hylpaW1rksuZ15eHg4fPozo6GiMHDlSOixiazlvO3z4MNzd3dGhQwebyHlnxqlTp+LDDz9EUFAQFixYgISEBNmMt8e0NPudGYuLi6Xi0Wg00mGNupa5O2fHjh2lJ/UPP/yAgoICRbdlQUEBIiMjERAQgICAALRr167B7qOGzF5VVVUj552Py7speZ/XldNsNiM1NRV9+/ZVPGdDs+mCuH79OuLi4jB16lS4urpixIgR2LVrF1JTU6HRaJCUlASg9o/oqG26nNvTH2Rdd+esqqrClStXsH79erz77ruIj4+HEMLmct62bds2ae/hQdfdUDnvzrh27VokJiYiMzMTiYmJmDZt2gOttz7Zb6vPtpw3bx7WrFmDIUOG4Pr169Leo1LbUq1WIzU1FZmZmcjOzsb//ve/BllvQ2e/O+fvv/8uux5r57zfGHXlnDVrFvz9/eHv7694zoZmswVhNpsRFxeHiIgIhISEAAA8PDygVqvh4OCA6OhonDhxAkDtH9FR2/RWrVrhypUr0iGNwsJCqaW9vLyk//1VVlbi6tWraNmyZa3rksvp6ekJnU4n7Xo6ODigtLTU5nLeXnbXrl0YOHCgNE2pnG5ubvdkvP2mHgCEhYVJe2N3L397TEuz35nR3d1d2j0vKiqCm5tbnWPIbcunn34aX331FTZv3gy9Xi99IrGS9zkAPPnkk+jVqxeOHz/eYOttyOy33c555xvhd1PyPq8t59KlS1FSUoLExESbytlQbLIghBCYNm0avL29ERMTI02/8xhbenq6dJW1VqtFWloaKioqkJ+fj7y8PPj6+tb60R0qlQq9evXCjh07ANx6Ebr9kR5arVY6u2DHjh144YUXoFKpZMd47rnnZHMOGDAABw8eBACcO3cOZrMZrVq1srmcAPDzzz/D29u7xu6qEjnPnTuH9evX35NRo9EgKysLAHDw4EHpMJhWq0VKSgqEEDh+/DiaN28OjUaDPn36YN++fSgvL0d5eTn27duHPn36QKPRoFmzZjh+/DiEEEhJSUFwcHCNdQGQnX7nGE899ZTstiwuLgYAVFdX4/PPP8crr7yi2LY8e/astJ2MRiN+/vlnPP300w3yWGrI7KWlpdL7Ordzent7ozZK3eeOjo6yOTds2IB9+/bhk08+gYODg+I5rfK5dQ35jndDOXTokOjYsaMIDw8XgwYNEoMGDRK7d+8Wb7/9tggPDxfh4eHin//8pzAYDNIyy5YtE8HBwSIkJEQ6A0CIW+/2h4SEiODgYLFs2TJp+vnz58XQoUPFgAEDxIQJE6QzjoxGo5gwYYIYMGCAGDp0qDh//nytY9SW02QyicmTJwu9Xi+ioqLEzz//bJM5hRDivffeE2vWrLnnPmjsnF988YVsxkOHDonBgweLiIgIMWzYMHHixAkhhBDV1dVi5syZIjg4WISHh0tnQAlx6yyiAQMGiAEDBoiNGzdK07Ozs4VerxfBwcFi1qxZorq6WgghRElJiRg1apTQ6XRi1KhRorS0tNYxatuW33zzjQgJCREhISHio48+ktatxLZctWqViIyMFOHh4UKv10tnpzXEY6khs+fk5MjmXLlypejbt6/o1KmTCAwMFFOnTlX0Pq8tZ6dOnURwcLD0OLg9Xamc1sCP2iAiIlk2eYiJiIiUx4IgIiJZLAgiIpLFgiAiIlksCCIiksWCICIiWSwIIiKS9f8A2/1FVGd7XqAAAAAASUVORK5CYII=\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"results_df['Commission_Amount'].plot(kind='hist', title=\"Total Commission Amount\")"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYgAAAEJCAYAAACOr7BbAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4xLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvAOZPmwAAHSBJREFUeJzt3X1QVXXix/HP5SoPgqHQAGauLq1uLKbmZOND6XoZdBRZ0cS2nZwkW2fUQGNzszJ8KB+mPyqn3dVcZ8rMnAoNW8kRxcQ0y57MJ2zTjQ01Lg6ilsJF8Pz+cL0/yaMckXPuVd+vmWa4h3Pv9+PpnvvhPF6XYRiGAAD4hZBABwAABCcKAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAqVaBDnAtdu3apbCwMEfG8vl8jo3VHOS7NuRrvmDOJpHvcmP26tWryfmu64IICwtTUlKSI2OVlpY6NlZzkO/akK/5gjmbRL7LjWkFu5gAAKYoCACAKQoCAGCKggAAmKIgAACmKAgAgCkKAgBgioIAAJiiIAAApigIwCa1Zxta7LWu5krblhwXN7fr+lYbQDALb+1WlxmFjo9btjDN8TFxY2ILAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAKQoCAGDKtoL48ccfNW7cOA0bNkxpaWlavny5JOnVV1/V/fffr5EjR2rkyJEqKSnxP+e1115Tamqqhg4dqo8//tiuaAAAC2y71Ybb7daMGTOUnJysn3/+WQ888IAGDBggSRo/frwmTJjQaP6DBw+qsLBQhYWF8nq9ysrK0oYNG+R2u+2KCAC4Atu2IOLi4pScnCxJioqKUmJiorxe72XnLy4uVlpamkJDQ9WpUyd17txZu3fvtiseAKAJjtys7/DhwyotLVXPnj311VdfaeXKlSooKFD37t01Y8YMRUdHy+v1qmfPnv7nxMfHX7FQJMnn86m0tNTu+JKk2tpax8ZqDvJdGzvyXc0dWFuak8v6Zvx/25KCOZ/tBXH69Gnl5OTomWeeUVRUlB566CFNnjxZLpdLixYt0sKFC7VgwQIZhnHJc10u1xVfOywszLGVsLS0NKArfFPId22CPd/VcvLfEuzLjnzmY1ph61lMZ8+eVU5OjtLT0zVkyBBJ0q233iq3262QkBBlZmZqz549kqSEhARVVFT4n+v1ehUXF2dnPADAFdhWEIZh6Nlnn1ViYqKysrL80ysrK/0/b9q0SV27dpUkeTweFRYWqq6uTuXl5SorK1OPHj3sigcAaIJtu5i+/PJLrV27Vt26ddPIkSMlSbm5uVq3bp0OHDggSerYsaPmzp0rSeratauGDRum4cOHy+12Ky8vjzOYACCAbCuIe+65R99+++0l0wcNGnTZ50yaNEmTJk2yKxIA4CpwJTUAwBQFAQAwRUHghlZ7tsHSfMF8GiQQKI5cKAcESnhrt7rMKAzI2GUL0wIyLtBS2IIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAKQoCAGCKggAAmKIgAACmKAgAgCkKAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAKQoCAGCKggAAmKIgAACmKAgAgCkKAgBgioIAAJiyrSB+/PFHjRs3TsOGDVNaWpqWL18uSTpx4oSysrI0ZMgQZWVl6eTJk5IkwzD0wgsvKDU1Venp6dq3b59d0QAAFthWEG63WzNmzND69ev1zjvv6O2339bBgwe1dOlS9evXT0VFRerXr5+WLl0qSdq6davKyspUVFSk559/XrNnz7YrGgDAAtsKIi4uTsnJyZKkqKgoJSYmyuv1qri4WBkZGZKkjIwMbdq0SZL8010ul3r16qVTp06psrLSrngAgCY4cgzi8OHDKi0tVc+ePVVVVaW4uDhJ50vk+PHjkiSv16uEhAT/cxISEuT1ep2IBwAw0cruAU6fPq2cnBw988wzioqKuux8hmFcMs3lcl3xtX0+n0pLS685oxW1tbWOjdUc5DOXlJTk+JjBwMllzXvv2gRzPlsL4uzZs8rJyVF6erqGDBkiSYqNjVVlZaXi4uJUWVmpmJgYSee3GCoqKvzPraio8G9pXE5YWJhjHwClpaVB/WFDPlzMyWUd7P9vyWc+phW27WIyDEPPPvusEhMTlZWV5Z/u8XhUUFAgSSooKFBKSkqj6YZhaNeuXWrbtm2TBQEAsI9tWxBffvml1q5dq27dumnkyJGSpNzcXE2cOFHTpk1Tfn6+OnTooEWLFkmSBg0apJKSEqWmpioiIkLz58+3KxoAwALbCuKee+7Rt99+a/q7C9dEXMzlcmnWrFl2xQEAXCWupAYAmKIgAACmKAgAgCkKAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAKQoCjvhVl8RARwBwlWz/wiBAkiIjwtRlRqHj45YtTHN8TOBGwRYEAMAUBQEAMEVBAABMWSqIf//733bnAAAEGUsHqWfNmqWzZ89q1KhRSk9P1y233GJ3LgBAgFkqiFWrVqmsrEyrV6/WAw88oB49emj06NEaMGCA3fkAAAFi+TTXLl26aNq0aerevbteeOEF7d+/X4ZhKDc3V0OGDLEzIwAgACwVxIEDB7RmzRqVlJSof//+WrJkiZKTk+X1evXHP/6RggCAG5Clgnj++eeVmZmp3NxchYeH+6fHx8dr6tSptoUDAASOpYJYunSpwsPD5Xa7JUnnzp2Tz+dTRESEMjIybA0IAAgMS6e5ZmVlqba21v+4pqZGWVlZtoUCAASepYLw+XyKjIz0P46MjFRNTY1toQAAgWepICIiIrRv3z7/47179zY6FgEAuPFYOgbxzDPPaOrUqYqLi5MkHTt2TC+//LKtwQAAgWWpIHr06KH169fr+++/l2EYSkxMVOvWre3OBqAZas82KLy127HxkpKSAjIu7Gf5Qrk9e/boyJEjamhoUGlpqSRxBhMQhMJbu/nuDbQISwUxffp0lZeX68477/Sf6upyuSgIALiBWSqIvXv36sMPP5TL5bL8wk8//bS2bNmi2NhYrVu3TpL06quv6t1331VMTIwkKTc3V4MGDZIkvfbaa8rPz1dISIhmzpyp+++//2r/LQCAFmSpILp27apjx475D1JbMXr0aD388MN66qmnGk0fP368JkyY0GjawYMHVVhYqMLCQnm9XmVlZWnDhg3+rRUAgPMsFUR1dbXS0tLUo0ePRgenlyxZctnn9OnTR4cPH7YUori4WGlpaQoNDVWnTp3UuXNn7d69W3fffbel5wMAWp6lgsjOzm6xAVeuXKmCggJ1795dM2bMUHR0tLxer3r27OmfJz4+Xl6vt8nX8vl8/gPmdqutrXVsrOYI9nwXznTBjS0Y34PBvm4Ecz5LBXHvvffqyJEj+u9//6v+/furpqZGDQ0NVz3YQw89pMmTJ8vlcmnRokVauHChFixYIMMwLpnXyvGOsLAwxz54SktLg/pDLtjz4eYQjO/BYF83ApHPaiFZupL63XffVU5OjvLy8iRJXq9XU6ZMuepQt956q9xut0JCQpSZmak9e/ZIkhISElRRUeGfz+v1XtXxDgBAy7NUECtXrtSqVasUFRUl6fyXBx0/fvyqB6usrPT/vGnTJnXt2lWS5PF4VFhYqLq6OpWXl6usrEw9evS46tcHALQcS7uYQkNDFRoa6n9cX1/f5HNyc3O1c+dOVVdXa+DAgcrOztbOnTt14MABSVLHjh01d+5cSefPkho2bJiGDx8ut9utvLw8zmACgACzVBB9+vTRkiVLVFtbq+3bt+vtt9+Wx+O54nNeeumlS6ZlZmZedv5JkyZp0qRJVuIAABxgaRfTk08+qZiYGHXr1k3vvPOOBg0apGnTptmdDQAQQJa2IEJCQjR27FiNHTvW7jwAgCBhqSA8Ho/paafFxcUtHggAEBwsFcTq1av9P9fV1Wn9+vU6efKkbaEAAIFn6RhE+/bt/f/Fx8dr/Pjx+vTTT+3OBgAIIEtbEBd/3ei5c+e0d+9enT592rZQAIDAs1QQCxcu/P8ntGqljh076pVXXrEtFAAg8CwVxIoVK+zOAQAIMpYK4vXXX7/i77OyslokDAAgeFj+Rrk9e/b4r57+6KOPdM8996hDhw62hgMABI7lLwxas2aN/2Z9jz/+uKZOnap58+bZGg4AEDiWTnM9evRoo5v1hYaG6siRI7aFAgAEnqUtiJEjR2rMmDFKTU2Vy+XSxo0blZGRYXc2AEAAWSqISZMmaeDAgfriiy8kSQsWLNDvfvc7W4MBAALL0i4mSaqpqVFUVJQeeeQRJSQkqLy83M5cAIAAs1QQf/vb37Rs2TItXbpUknT27FlNnz7d1mAAgMCyVBAbN27U4sWLFRERIUmKj4/nVhsAcIOzVBCtW7eWy+Xy3/L7zJkztoYCAASepYPUw4YNU15enk6dOqV3331Xq1ev5suDAOAGZ6kgJkyYoO3btysyMlLff/+9cnJyNGDAALuzAQACqMmCaGho0IQJE/TGG29QCgBwE2nyGITb7VZ4eLh++uknJ/IAAIKEpV1MYWFhSk9PV//+/dWmTRv/9JkzZ9oWDAAQWJYK4ve//71+//vf2xwFABBMrlgQR48e1W233aZRo0Y5lQcAECSueAxiypQp/p+zs7NtDwMACB5XLAjDMPw/c+8lALi5XLEgLlw5/cufAQA3visegzhw4IB69+4twzDk8/nUu3dvSee3LFwul7766itHQgIAnHfFgigtLW32Cz/99NPasmWLYmNjtW7dOknSiRMn9MQTT+jIkSPq2LGjXnnlFUVHR8swDM2bN08lJSUKDw/XwoULlZyc3OyxAQDXzvL3QVyt0aNHa9myZY2mLV26VP369VNRUZH69evnv3341q1bVVZWpqKiIj3//POaPXu2XbEAABbZVhB9+vRRdHR0o2nFxcX+ryrNyMjQpk2bGk13uVzq1auXTp06pcrKSruiAQAssK0gzFRVVSkuLk6SFBcXp+PHj0uSvF6vEhIS/PMlJCTI6/U6GQ0A8AuWrqS228Wn015g5awpn893TcdJrkZtba1jYzVHsOdLSkoKdAQ4IBjfg8G+bgRzPkcLIjY2VpWVlYqLi1NlZaViYmIknd9iqKio8M9XUVHh39K4krCwMMc+eEpLS4P6Qy7Y8+HmEIzvwWBfNwKRz2ohObqLyePxqKCgQJJUUFCglJSURtMNw9CuXbvUtm1bSwUBALCPbVsQubm52rlzp6qrqzVw4EBlZ2dr4sSJmjZtmvLz89WhQwctWrRIkjRo0CCVlJQoNTVVERERmj9/vl2xAAAW2VYQL730kun05cuXXzLN5XJp1qxZdkUBADSDo7uYAADXDwoCAGCKggAAmKIgAACmKAgAgCkKAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiAAAKYoCACAKQoCAGCKggAAmKIgAACmKAgAgCkKAgBgioIAAJiiIAAApigIAIApCgIAYIqCAACYoiBuIrVnGwIdAcB1pFWgA8A54a3d6jKjMCBjly1MC8i4AJqPLQgAgCkKAgBgioIAAJiiIAAApigIAICpgJzF5PF4FBkZqZCQELndbq1Zs0YnTpzQE088oSNHjqhjx4565ZVXFB0dHYh4AAAFcAti+fLlWrt2rdasWSNJWrp0qfr166eioiL169dPS5cuDVQ0AM0QyOtsuMbHHkFzHURxcbFWrFghScrIyNC4ceM0ffr0AKcCYBXX2dx4AlYQEyZMkMvl0oMPPqgHH3xQVVVViouLkyTFxcXp+PHjTb6Gz+dTaWmp3VElSbW1tY6N1RxW8iUlJTmUBnDe5d7/N8K6GygBKYhVq1YpPj5eVVVVysrKUmJiYrNeJywszLEPvdLS0qD+gA32fIDdLvf+D/Z1IxD5rBZSQI5BxMfHS5JiY2OVmpqq3bt3KzY2VpWVlZKkyspKxcTEBCIaAOB/HC+IM2fO6Oeff/b/vH37dnXt2lUej0cFBQWSpIKCAqWkpDgdDQBwEcd3MVVVVWnKlCmSpIaGBo0YMUIDBw7UXXfdpWnTpik/P18dOnTQokWLnI4GALiI4wXRqVMnffDBB5dMb9++vZYvX+50HADAZXAlNQDAFAUBADBFQQAATFEQAABTFAQAwBQFAQAwRUEAAExREAAAUxQEAMAUBQEAMEVBAABMURAAAFMUBADAFAUBADBFQQAATFEQAABTFAQAwBQFAQAwRUEAAExREAAAUxREANSebWjx10xKSmrx1wRwc2sV6AA3o/DWbnWZUej4uGUL0xwfE8D1iy0IAIApCgIAYIqCAHDdu9JxPTuPz9lxPDGYcAwCwHWP43r2YAsCAGCKggAAmKIgAKCZWuIYRHOPkThx/CPojkFs3bpV8+bN07lz55SZmamJEycGOhIAmArUsQ/JmeMfQbUF0dDQoLlz52rZsmUqLCzUunXrdPDgQVvGutr25UplADeboNqC2L17tzp37qxOnTpJktLS0lRcXKzf/OY3LT7Wjd78AHCtgmoLwuv1KiEhwf84Pj5eXq83gIkA4OblMgzDCHSIC9avX69t27Zp3rx5kqSCggLt2bNHzz33nOn8u3btUlhYmJMRAeC65/P51KtXrybnC6pdTAkJCaqoqPA/9nq9iouLu+z8Vv6BAIDmCapdTHfddZfKyspUXl6uuro6FRYWyuPxBDoWANyUgmoLolWrVsrLy9Njjz2mhoYGPfDAA+ratWugYwHATSmojkEAAIJHUO1iAgAEDwoCAGAqqI5BBMJ//vMfPfHEE/7H5eXlysnJ0fjx4/3TPvvsM02ePFm33367JCk1NVWPP/64JHtvDWIl27Jly/Svf/1L0vkr0Q8dOqQdO3aoXbt28ng8ioyMVEhIiNxut9asWdNi2S5444039N5778nlcqlbt25asGBBo1OP6+rq9Ne//lX79u1Tu3bt9PLLL/uX42uvvab8/HyFhIRo5syZuv/++x3P9/rrr+u9996T2+1WTEyM5s+fr44dO0o6f/V8t27dJEkdOnTQkiVLHM+3Zs0avfjii4qPj5ckPfzww8rMzJQkvf/++1q8eLEkadKkSRo1apTj+ebPn6/PPvtMklRbW6uqqip98cUXkpxZfsuXL9d7770nwzCUmZnZaN2QJMMwNG/ePJWUlCg8PFwLFy5UcnKyJGeWX1P5PvjgA/3zn/+UJEVGRmr27Nm68847JcmR9bdJBvzq6+uN/v37G4cPH240/dNPPzUmTpxoOn9KSorxww8/GD6fz0hPTze+++47R7NdrLi42Bg3bpz/8eDBg42qqipb8hiGYVRUVBiDBw82ampqDMMwjJycHGP16tWN5nnrrbeM5557zjAMw1i3bp0xdepUwzAM47vvvjPS09MNn89n/PDDD0ZKSopRX1/veL4dO3YYZ86cMQzDMFauXOnPZxiG0atXrxbN05x8q1evNubMmXPJc6urqw2Px2NUV1cbJ06cMDwej3HixAnH813szTffNGbMmOF/bPfy+/bbb420tDTjzJkzxtmzZ41HHnnE+P777xvNs2XLFmPChAnGuXPnjK+//toYM2aMYRjOLD8r+b788kv/uFu2bPHnMwz7118r2MV0kR07dqhTp07+vyCbcvGtQUJDQ/23BglUtsLCQo0YMcKW8S+noaFBtbW1qq+vV21t7SXXrWzevNn/l9nQoUO1Y8cOGYah4uJipaWlKTQ0VJ06dVLnzp21e/dux/P17dtXERERks5fV3PxdThOaCrf5Wzbtk0DBgxQu3btFB0drQEDBujjjz8OaD6n33+HDh1Sz549FRERoVatWqlPnz7auHFjo3mKi4uVkZEhl8ulXr166dSpU6qsrHRk+VnJ17t3b0VHR0sKzPuvKRTERa70Bt+1a5f+8Ic/6LHHHtN3330nydlbgzS18tXU1Ojjjz/WkCFDGk2fMGGCRo8erXfeeafFM8XHx+vRRx/V4MGDdd999ykqKkr33Xdfo3m8Xq86dOgg6fxpzG3btlV1dbUjy85Kvovl5+dr4MCB/sc+n0+jR4/W2LFjtWnTphbNdjX5ioqKlJ6erpycHP3444+SnHnvXc3yO3LkiA4fPqy+ffv6p9m9/Lp166YvvvhC1dXVqqmp0datWy/5gP3lckpISJDX63Vk+VnJd7Ffvv8ke9dfK276YxAX1NXVafPmzfrLX/5yye+Sk5O1efNmRUZGqqSkRFOmTFFRUZEMkzOEXS6Xo9ku+Oijj9S7d2+1a9fOP23VqlWKj49XVVWVsrKylJiYqD59+rRYrpMnT6q4uFjFxcVq27atpk6dqrVr12rkyJH+eS63jJxYdlbyXbB27Vrt3btXb731ln/aRx99pPj4eJWXl+uRRx5Rt27d9Ktf/crRfIMHD9aIESMUGhqqVatW6amnntKbb74ZdMuvsLBQQ4cOldvt9k+ze/ndcccdeuyxx/Too4+qTZs2+u1vf9tofCmw7z8r+S749NNPlZ+fr7fffts/ze711wq2IP5n69atSk5O1q233nrJ76KiohQZGSlJGjRokOrr63X8+PGrvjWIHdkuKCwsVFpa47vEXjiwGRsbq9TU1BbfhfPJJ5/o9ttvV0xMjFq3bq0hQ4bo66+/bjRPQkKC/6/e+vp6/fTTT2rXrp0jy85KvgvzLVmyRIsXL1ZoaKh/+oXl16lTJ917773av3+/4/nat2/vzzR27Fjt27dP0tXflsaufBd8+OGHl33/2bX8JCkzM1Pvv/++Vq5cqXbt2qlz586Nfv/L5VRRUaG4uDjH1t2m8knSgQMHNHPmTP3jH/9Q+/bt/dPtXn+toCD+x+wD9oJjx475/+LYvXu3zp07p/bt2zt2a5ArZZOkn376SZ9//rlSUlL8086cOaOff/7Z//P27dtb/Kr02267Td98841qampkGIZ27NihO+64o9E8Ho9H77//viRpw4YN6tu3r1wulzwejwoLC1VXV6fy8nKVlZWpR48ejufbv3+/8vLytHjxYsXGxvqnnzx5UnV1dZKk48eP66uvvmrx285byVdZWen/efPmzf7f33fffdq2bZtOnjypkydPatu2bVfcfWZXPun82XanTp3S3Xff7Z/mxPKTpKqqKknS0aNHVVRUdMluWI/Ho4KCAhmGoV27dqlt27aKi4tzZPlZyXf06FFlZ2frxRdf1K9//Wv/dCfWXyvYxaTz++8/+eQTzZ071z9t1apVkqSHHnpIGzZs0KpVq+R2uxUeHq6XXnpJLpfLkVuDNJVNkjZu3KgBAwaoTZs2/nmqqqo0ZcoUSecPNI4YMeKS/ZvXqmfPnho6dKhGjRqlVq1aKSkpSQ8++KAWLVqk7t27KyUlRWPGjNH06dOVmpqq6Ohovfzyy5Kkrl27atiwYRo+fLjcbrfy8vIuu/ltZ74XX3xRZ86c0dSpUyX9/+mYhw4d0qxZs/y7I/785z+3+AeclXwrVqzQ5s2b5Xa7FR0drQULFkiS2rVrp8mTJ2vMmDGSpClTpjTavehUPun8HzDDhw9vtIvGieUnSdnZ2Tpx4oRatWqlWbNmKTo6utH6MWjQIJWUlCg1NVURERGaP3++JGeWn5V8f//733XixAnNmTNHkvynszqx/lrBrTYAAKbYxQQAMEVBAABMURAAAFMUBADAFGcxAcB14umnn9aWLVsUGxurdevWXXHeK91I0SrOYgKA68Tnn3+uNm3a6KmnnmqyIC62YsUK7d+/33+atFXsYgKA60SfPn38N/e74IcffvDfs+lPf/qTDh06dMnzmnsjRXYxAcB17LnnntOcOXPUpUsXffPNN5ozZ47efPNN/+/NbqRoFQUBANep06dP6+uvv/bfCUCS/xYnF5jdSNEqCgIArlOGYeiWW27R2rVrLzvPhx9+qLy8vGa9PscgAOA6FRUVpdtvv13r16+XdL4wDhw44P+92Y0UrwZnMQHAdSI3N1c7d+5UdXW1YmNjlZ2drb59+2r27Nk6duyY6uvrNXz4cD3++OOSpFdffVU+n09PPvlks8ajIAAAptjFBAAwRUEAAExREAAAUxQEAMAUBQEAMEVBAABMURAAAFMUBADA1P8B3pZH5SXn6QQAAAAASUVORK5CYII=\n",
"text/plain": [
""
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"results_df['Sales'].plot(kind='hist')"
]
}
],
"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
}