becki_profitable.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Profitable\n",
    "This code is calculating how many movies fall into each of three categories: profitable, not profitable, and break even"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Set up Dependencies\n",
    "from progress.bar import IncrementalBar\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib.cm as cm\n",
    "import statistics as st\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import requests\n",
    "import time\n",
    "import nltk\n",
    "import json\n",
    "import csv\n",
    "import sys\n",
    "import os\n",
    "import re\n",
    "from scipy.stats import linregress\n",
    "from pprint import pprint"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Rated</th>\n",
       "      <th>Released</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Language</th>\n",
       "      <th>Awards</th>\n",
       "      <th>imdbRating</th>\n",
       "      <th>imdbVotes</th>\n",
       "      <th>imdbID</th>\n",
       "      <th>Type</th>\n",
       "      <th>Production</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>ROI%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Vulgar</td>\n",
       "      <td>2000</td>\n",
       "      <td>R</td>\n",
       "      <td>26 Apr 2002</td>\n",
       "      <td>87</td>\n",
       "      <td>Crime, Drama, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3</td>\n",
       "      <td>3876</td>\n",
       "      <td>tt0120467</td>\n",
       "      <td>movie</td>\n",
       "      <td>Lions Gate Films</td>\n",
       "      <td>120000</td>\n",
       "      <td>14904</td>\n",
       "      <td>-87.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Out of the Furnace</td>\n",
       "      <td>2013</td>\n",
       "      <td>R</td>\n",
       "      <td>06 Dec 2013</td>\n",
       "      <td>116</td>\n",
       "      <td>Action, Crime, Drama, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>2 wins &amp; 9 nominations.</td>\n",
       "      <td>6.8</td>\n",
       "      <td>103339</td>\n",
       "      <td>tt1206543</td>\n",
       "      <td>movie</td>\n",
       "      <td>Relativity Media</td>\n",
       "      <td>22000000</td>\n",
       "      <td>15400000</td>\n",
       "      <td>-30.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Coyote Ugly</td>\n",
       "      <td>2000</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>04 Aug 2000</td>\n",
       "      <td>100</td>\n",
       "      <td>Comedy, Drama, Music, Romance</td>\n",
       "      <td>English</td>\n",
       "      <td>4 wins &amp; 8 nominations.</td>\n",
       "      <td>5.7</td>\n",
       "      <td>104644</td>\n",
       "      <td>tt0200550</td>\n",
       "      <td>movie</td>\n",
       "      <td>Buena Vista</td>\n",
       "      <td>45000000</td>\n",
       "      <td>113916474</td>\n",
       "      <td>153.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Parental Guidance</td>\n",
       "      <td>2012</td>\n",
       "      <td>PG</td>\n",
       "      <td>25 Dec 2012</td>\n",
       "      <td>105</td>\n",
       "      <td>Comedy, Family</td>\n",
       "      <td>English</td>\n",
       "      <td>1 win &amp; 4 nominations.</td>\n",
       "      <td>6.0</td>\n",
       "      <td>24453</td>\n",
       "      <td>tt1047540</td>\n",
       "      <td>movie</td>\n",
       "      <td>20th Century Fox</td>\n",
       "      <td>25000000</td>\n",
       "      <td>119772232</td>\n",
       "      <td>379.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Raising Helen</td>\n",
       "      <td>2004</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>28 May 2004</td>\n",
       "      <td>119</td>\n",
       "      <td>Comedy, Drama, Romance</td>\n",
       "      <td>English</td>\n",
       "      <td>1 nomination.</td>\n",
       "      <td>6.0</td>\n",
       "      <td>34868</td>\n",
       "      <td>tt0350028</td>\n",
       "      <td>movie</td>\n",
       "      <td>Buena Vista Pictures</td>\n",
       "      <td>50000000</td>\n",
       "      <td>49718611</td>\n",
       "      <td>-0.56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Title  Year  Rated     Released  Runtime  \\\n",
       "0              Vulgar  2000      R  26 Apr 2002       87   \n",
       "1  Out of the Furnace  2013      R  06 Dec 2013      116   \n",
       "2         Coyote Ugly  2000  PG-13  04 Aug 2000      100   \n",
       "3   Parental Guidance  2012     PG  25 Dec 2012      105   \n",
       "4       Raising Helen  2004  PG-13  28 May 2004      119   \n",
       "\n",
       "                            Genre Language                   Awards  \\\n",
       "0          Crime, Drama, Thriller  English                      NaN   \n",
       "1  Action, Crime, Drama, Thriller  English  2 wins & 9 nominations.   \n",
       "2   Comedy, Drama, Music, Romance  English  4 wins & 8 nominations.   \n",
       "3                  Comedy, Family  English   1 win & 4 nominations.   \n",
       "4          Comedy, Drama, Romance  English            1 nomination.   \n",
       "\n",
       "   imdbRating  imdbVotes     imdbID   Type            Production    Budget  \\\n",
       "0         5.3       3876  tt0120467  movie      Lions Gate Films    120000   \n",
       "1         6.8     103339  tt1206543  movie      Relativity Media  22000000   \n",
       "2         5.7     104644  tt0200550  movie           Buena Vista  45000000   \n",
       "3         6.0      24453  tt1047540  movie      20th Century Fox  25000000   \n",
       "4         6.0      34868  tt0350028  movie  Buena Vista Pictures  50000000   \n",
       "\n",
       "     Revenue    ROI%  \n",
       "0      14904  -87.58  \n",
       "1   15400000  -30.00  \n",
       "2  113916474  153.15  \n",
       "3  119772232  379.09  \n",
       "4   49718611   -0.56  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# read the data back into the dataframe from the csv file\n",
    "input_data_file = os.path.join('data_files','good_merged_data.csv')\n",
    "\n",
    "# write the DataFrame data to the csv file\n",
    "movie_df = pd.read_csv(input_data_file)\n",
    "\n",
    "movie_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Rated</th>\n",
       "      <th>Released</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Language</th>\n",
       "      <th>Awards</th>\n",
       "      <th>imdbRating</th>\n",
       "      <th>imdbVotes</th>\n",
       "      <th>imdbID</th>\n",
       "      <th>Type</th>\n",
       "      <th>Production</th>\n",
       "      <th>Budget</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>ROI%</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Vulgar</td>\n",
       "      <td>2000</td>\n",
       "      <td>R</td>\n",
       "      <td>26 Apr 2002</td>\n",
       "      <td>87</td>\n",
       "      <td>Crime, Drama, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.3</td>\n",
       "      <td>3876</td>\n",
       "      <td>tt0120467</td>\n",
       "      <td>movie</td>\n",
       "      <td>Lions Gate Films</td>\n",
       "      <td>120000</td>\n",
       "      <td>14904</td>\n",
       "      <td>-87.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Out of the Furnace</td>\n",
       "      <td>2013</td>\n",
       "      <td>R</td>\n",
       "      <td>06 Dec 2013</td>\n",
       "      <td>116</td>\n",
       "      <td>Action, Crime, Drama, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>2 wins &amp; 9 nominations.</td>\n",
       "      <td>6.8</td>\n",
       "      <td>103339</td>\n",
       "      <td>tt1206543</td>\n",
       "      <td>movie</td>\n",
       "      <td>Relativity Media</td>\n",
       "      <td>22000000</td>\n",
       "      <td>15400000</td>\n",
       "      <td>-30.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Raising Helen</td>\n",
       "      <td>2004</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>28 May 2004</td>\n",
       "      <td>119</td>\n",
       "      <td>Comedy, Drama, Romance</td>\n",
       "      <td>English</td>\n",
       "      <td>1 nomination.</td>\n",
       "      <td>6.0</td>\n",
       "      <td>34868</td>\n",
       "      <td>tt0350028</td>\n",
       "      <td>movie</td>\n",
       "      <td>Buena Vista Pictures</td>\n",
       "      <td>50000000</td>\n",
       "      <td>49718611</td>\n",
       "      <td>-0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Fair Game</td>\n",
       "      <td>1995</td>\n",
       "      <td>R</td>\n",
       "      <td>03 Nov 1995</td>\n",
       "      <td>91</td>\n",
       "      <td>Action, Romance, Thriller</td>\n",
       "      <td>English, Russian</td>\n",
       "      <td>4 nominations.</td>\n",
       "      <td>4.3</td>\n",
       "      <td>11848</td>\n",
       "      <td>tt0113010</td>\n",
       "      <td>movie</td>\n",
       "      <td>Warner Home Video</td>\n",
       "      <td>50000000</td>\n",
       "      <td>11534477</td>\n",
       "      <td>-76.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>The Girlfriend Experience</td>\n",
       "      <td>2009</td>\n",
       "      <td>R</td>\n",
       "      <td>08 Jul 2009</td>\n",
       "      <td>77</td>\n",
       "      <td>Drama</td>\n",
       "      <td>English, French</td>\n",
       "      <td>1 nomination.</td>\n",
       "      <td>5.5</td>\n",
       "      <td>15619</td>\n",
       "      <td>tt1103982</td>\n",
       "      <td>movie</td>\n",
       "      <td>Magnolia Pictures</td>\n",
       "      <td>1700000</td>\n",
       "      <td>1007962</td>\n",
       "      <td>-40.71</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>Diggstown</td>\n",
       "      <td>1992</td>\n",
       "      <td>R</td>\n",
       "      <td>14 Aug 1992</td>\n",
       "      <td>98</td>\n",
       "      <td>Drama, Sport</td>\n",
       "      <td>English</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7.0</td>\n",
       "      <td>6755</td>\n",
       "      <td>tt0104107</td>\n",
       "      <td>movie</td>\n",
       "      <td>MGM Home Entertainment</td>\n",
       "      <td>17000000</td>\n",
       "      <td>4836637</td>\n",
       "      <td>-71.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td>The Afflicted</td>\n",
       "      <td>2011</td>\n",
       "      <td>Unrated</td>\n",
       "      <td>01 Mar 2012</td>\n",
       "      <td>85</td>\n",
       "      <td>Horror, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.6</td>\n",
       "      <td>1119</td>\n",
       "      <td>tt1566637</td>\n",
       "      <td>movie</td>\n",
       "      <td>Gravitas</td>\n",
       "      <td>180000</td>\n",
       "      <td>175742</td>\n",
       "      <td>-2.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>579</th>\n",
       "      <td>The Tie That Binds</td>\n",
       "      <td>1995</td>\n",
       "      <td>R</td>\n",
       "      <td>08 Sep 1995</td>\n",
       "      <td>99</td>\n",
       "      <td>Crime, Drama, Thriller</td>\n",
       "      <td>English</td>\n",
       "      <td>1 nomination.</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1069</td>\n",
       "      <td>tt0114666</td>\n",
       "      <td>movie</td>\n",
       "      <td>Buena Vista</td>\n",
       "      <td>14000000</td>\n",
       "      <td>5830454</td>\n",
       "      <td>-58.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>580</th>\n",
       "      <td>Proof</td>\n",
       "      <td>2005</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>07 Oct 2005</td>\n",
       "      <td>100</td>\n",
       "      <td>Drama, Mystery</td>\n",
       "      <td>English</td>\n",
       "      <td>Nominated for 1 Golden Globe. Another 4 wins &amp;...</td>\n",
       "      <td>6.7</td>\n",
       "      <td>42455</td>\n",
       "      <td>tt0377107</td>\n",
       "      <td>movie</td>\n",
       "      <td>Miramax Films</td>\n",
       "      <td>20000000</td>\n",
       "      <td>7535331</td>\n",
       "      <td>-62.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>585</th>\n",
       "      <td>Catwoman</td>\n",
       "      <td>2004</td>\n",
       "      <td>PG-13</td>\n",
       "      <td>23 Jul 2004</td>\n",
       "      <td>104</td>\n",
       "      <td>Action, Crime, Fantasy</td>\n",
       "      <td>English, Spanish</td>\n",
       "      <td>13 wins &amp; 8 nominations.</td>\n",
       "      <td>3.4</td>\n",
       "      <td>107522</td>\n",
       "      <td>tt0327554</td>\n",
       "      <td>movie</td>\n",
       "      <td>Warner Bros. Pictures</td>\n",
       "      <td>100000000</td>\n",
       "      <td>82102379</td>\n",
       "      <td>-17.90</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>190 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Title  Year    Rated     Released  Runtime  \\\n",
       "0                       Vulgar  2000        R  26 Apr 2002       87   \n",
       "1           Out of the Furnace  2013        R  06 Dec 2013      116   \n",
       "4                Raising Helen  2004    PG-13  28 May 2004      119   \n",
       "6                    Fair Game  1995        R  03 Nov 1995       91   \n",
       "7    The Girlfriend Experience  2009        R  08 Jul 2009       77   \n",
       "..                         ...   ...      ...          ...      ...   \n",
       "575                  Diggstown  1992        R  14 Aug 1992       98   \n",
       "578              The Afflicted  2011  Unrated  01 Mar 2012       85   \n",
       "579         The Tie That Binds  1995        R  08 Sep 1995       99   \n",
       "580                      Proof  2005    PG-13  07 Oct 2005      100   \n",
       "585                   Catwoman  2004    PG-13  23 Jul 2004      104   \n",
       "\n",
       "                              Genre          Language  \\\n",
       "0            Crime, Drama, Thriller           English   \n",
       "1    Action, Crime, Drama, Thriller           English   \n",
       "4            Comedy, Drama, Romance           English   \n",
       "6         Action, Romance, Thriller  English, Russian   \n",
       "7                             Drama   English, French   \n",
       "..                              ...               ...   \n",
       "575                    Drama, Sport           English   \n",
       "578                Horror, Thriller           English   \n",
       "579          Crime, Drama, Thriller           English   \n",
       "580                  Drama, Mystery           English   \n",
       "585          Action, Crime, Fantasy  English, Spanish   \n",
       "\n",
       "                                                Awards  imdbRating  imdbVotes  \\\n",
       "0                                                  NaN         5.3       3876   \n",
       "1                              2 wins & 9 nominations.         6.8     103339   \n",
       "4                                        1 nomination.         6.0      34868   \n",
       "6                                       4 nominations.         4.3      11848   \n",
       "7                                        1 nomination.         5.5      15619   \n",
       "..                                                 ...         ...        ...   \n",
       "575                                                NaN         7.0       6755   \n",
       "578                                                NaN         4.6       1119   \n",
       "579                                      1 nomination.         5.0       1069   \n",
       "580  Nominated for 1 Golden Globe. Another 4 wins &...         6.7      42455   \n",
       "585                           13 wins & 8 nominations.         3.4     107522   \n",
       "\n",
       "        imdbID   Type              Production     Budget   Revenue   ROI%  \n",
       "0    tt0120467  movie        Lions Gate Films     120000     14904 -87.58  \n",
       "1    tt1206543  movie        Relativity Media   22000000  15400000 -30.00  \n",
       "4    tt0350028  movie    Buena Vista Pictures   50000000  49718611  -0.56  \n",
       "6    tt0113010  movie       Warner Home Video   50000000  11534477 -76.93  \n",
       "7    tt1103982  movie       Magnolia Pictures    1700000   1007962 -40.71  \n",
       "..         ...    ...                     ...        ...       ...    ...  \n",
       "575  tt0104107  movie  MGM Home Entertainment   17000000   4836637 -71.55  \n",
       "578  tt1566637  movie                Gravitas     180000    175742  -2.37  \n",
       "579  tt0114666  movie             Buena Vista   14000000   5830454 -58.35  \n",
       "580  tt0377107  movie           Miramax Films   20000000   7535331 -62.32  \n",
       "585  tt0327554  movie   Warner Bros. Pictures  100000000  82102379 -17.90  \n",
       "\n",
       "[190 rows x 16 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a dataframe containing only profitable movies (ROI over 0)\n",
    "profitable_df = movie_df.loc[movie_df['ROI%'] > 0]\n",
    "\n",
    "# create a dataframe containing only break even movies (ROI = 0)\n",
    "break_even_df = movie_df.loc[movie_df['ROI%'] == 0]\n",
    "\n",
    "# create a dataframe containing only not profitable movies (ROI under 0)\n",
    "non_profitable_df = movie_df.loc[movie_df['ROI%'] < 0]\n",
    "non_profitable_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Profitable: 395 (67.41%)\n",
      "Break Even: 1 (0.17%)\n",
      "Non-Profitable: 190 (32.42%)\n",
      "Total: 586\n"
     ]
    }
   ],
   "source": [
    "# get the number of movie in each of the three categories & the total number of movies\n",
    "profitable = len(profitable_df)\n",
    "break_even = len(break_even_df)\n",
    "non_profitable = len(non_profitable_df)\n",
    "total = len(movie_df)\n",
    "\n",
    "# calculate the percentages for each of the three categories\n",
    "profit_per = round(profitable/total*100,2)\n",
    "break_even_per = round(break_even/total*100,2)\n",
    "not_profit_per = round(non_profitable/total*100,2)\n",
    "\n",
    "# display the vales and percentages of the three categories\n",
    "print(f'Profitable: {profitable} ({profit_per}%)')\n",
    "print(f'Break Even: {break_even} ({break_even_per}%)')\n",
    "print(f'Non-Profitable: {non_profitable} ({not_profit_per}%)')\n",
    "print(f'Total: {total}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAOcAAADnCAYAAADl9EEgAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3deVxUVf8H8M+dBRh2WQUVxgUEZfAxM5dcKqTUkbLHNdQmsx5FM7esyS01l0m0NM0lTaV+WY/aojEuT2aae7mEgwIqOqJsArIvs97fHwOELLIIc+4w5/16+Spnuec7OB/OXc45l2FZFhRFcQ+PdAEURdWOhpOiOIqGk6I4ioaTojiKhpOiOIqGk6I4ioaTojiKhpOiOIqGk6I4ioaTojhK0Ng3XLp0yUsgEOwAEAIabqr5GAHE6/X6t3r16vWAdDFc0OhwCgSCHW3btg329PTM5fF4dGAu1SyMRiOTlZXVLSMjYweAl0nXwwVN6flCPD09C2gwqebE4/FYT0/PfJj2yCg0LZw8GkyqJZR/r+ihUjn6g6Aojmr0MWd1YrmyV3MUUkGtkF6q7zV8Pr9XQEBAqcFgYLp06VK6d+9etZOTk7GhbezcubPNihUrfD09PXXR0dH3d+7c6b579+57sbGxTra2tsbw8PDix71/7ty5vo6Ojobly5dnVn08KSnJZsSIEQE3b9681tBaqjIajZg1a1a7X375pQ2Px2PffPPNrEWLFj1YvHix9759+9wBwGAwMLdv37ZLS0v729vb21DbdmQyWYd9+/Z5lJSUXAGAw4cPO86bN6/DjRs37Ldv33578uTJuQAQFxdnGxkZ2Umv1zNffPHF3SFDhhTrdDoMHjw48OjRo7ca8zOlmp9F9py2trbGxMTE6zdv3rwmFArZdevWeVZ93mg0wmCo9XsLANi1a5fHhg0bUi5cuHBj0KBBJbt3774HAMePH3c6deqUYwuXX6eNGze6379/X5icnBx/+/bta5MnT34IAB9//HFmYmLi9cTExOvLli2737t378K6gvnHH3/Y5+fnP/JLt1OnTtpdu3apIyIicqq157lixYrU/fv3J0dHR7cFgDVr1ni99tprOTSY5FlkOKsaMGBA0a1bt2yTkpJsOnXq1H3ixIl+3bt375acnGyzbds2t8DAwG4BAQHdo6Ki2gHAe++953Pp0iXHmTNn+k+dOrV9bGys0/PPP98lKSnJ5uuvv/bcunWrd1BQULcjR4447tmzxyU0NDQoODi4W//+/QPv3btX+aW/evWqfd++fQP9/f1D1q1b51G9Lr1ej6lTp7YPCQkJDgwM7BYdHV3jNdXt2LHD6+OPP07n8/kAgHbt2umrv+a7775zGzNmzMPa3q/X6zF//vz2GzZsuF/18a5du2r79OlTyuM9+s8tFArZkpISpqioiCcUCtns7Gz+oUOHXGbMmPFIiCkyLDqcOp0OR48edZZIJKUAoFar7SZPnpyTkJBw3cbGhl26dGm7EydO3Lh+/fq1K1euOHzzzTeua9euTQ8JCSn5+uuvb2/btq3yS9y1a1ft66+/njVt2rTMxMTE60OHDi0KDw8v+vvvvxMTEhKujx49+uHy5cvbVrw+ISFBdOzYsZvnz59PjI6O9lWr1cKqta1fv97DxcXFEB8fnxAXF5cQExPjmZiYaAMAQUFB3Wr7PPfu3bP95ptv2oSEhAQPGjQoQKVS2VZ9vrCwkPfHH3+4TJw4Mbe2969evdpr+PDhef7+/rqG/Pzmzp2btWHDhrZRUVH+ixcvTpfL5T4LFixIrx5iiownPuYkQaPR8Cq+4H369CmcNWtW9t27d4U+Pj7asLCwYgA4ffq0Q9++fQt9fX31ADBu3LiHJ0+edJw0aVJeQ9u5c+eOzciRI9tnZWUJtVotr0OHDpqK54YNG5bn6OjIOjo66vv161dw6tQph2eeeaak4vljx445JyYm2h88eLANABQWFvKvX79uFxQUpE1MTLxeW3tarZaxs7Nj4+PjE2JiYlzfeOMN8aVLl5Iqnv/+++9devXqVVTbLq1arRb+/PPPbc6fP59U/bm6BAQEaP/8888kAIiPj7fNyMiwCQ0NLRs5cmRHnU7HrF69OjU0NFRT33aolmGR4aw45qz+uL29feVxUnMsXPbOO+/4zZo1K2PChAn5sbGxTsuXL/eteI5hmEdeW/3vLMsy69atSxk1alRBQ9vz9vbWRkZG5gLApEmT8t555x1x1ef37t3rNnbs2Fp3ac+fP29/9+5dO7FYLAGAsrIynp+fX0hKSkp8Q9r+4IMP2ikUitQ1a9Z4T5w4Madz587aRYsW+R48ePBOQ+unmler3X8ZNGhQ8YULF5zS09MFer0e+/btc3vuueeKHvceJycnQ2FhIb/i74WFhXw/Pz8dAOzevdu96msPHz7sWlJSwmRkZPDPnz/vNGDAgEfO8IaHh+dv2bLFU6PRMABw9epV24KCgsf+vIcNG5Z3+PBhJwA4dOiQk7+/f2WvlZOTw//zzz+dIiMja+35x48fn5+dnR2XmpqqSk1NVdnZ2RkbGkylUuno4+OjlUgkmpKSEh6Px4NAIGBLS0tb7ffDEjxxz9mQSx8k+Pv765YsWZI6ePDgQJZlmbCwsPyJEyc+dpd21KhReaNHj+58+PBh1/Xr16csXLgw7bXXXuvs7e2tffrpp4tTUlIqjwF79uxZHBYWFpCWlmbz3nvvpYvFYl1SUpJNxfNz5szJVqvVthKJJJhlWcbNzU136NChZMB0zFlbz798+fKM0aNHd9y8ebO3vb29cfv27eqK57799lvXgQMHFjg7Oz9yFnXw4MFdYmJi7orF4jqPM0+ePGk/duzYLgUFBfzffvvNdeXKlb63bt26BpjObK9cudLnwIEDtwFgxowZWRMnTuyo1+uZTZs23a33B021GKaxu39xcXHqHj16ZLdQPZSVi4uL8+jRo4eYdB1cQHdbKIqjaDgpiqNoOCmKoyzyUoq1YFkWWr3RpkxvtNMZjEK9gRXqjUaB3sgKDEZWaDCyAiPL8lgWDAswYFF5PYfHwMDjMUYewxh4DIw8hjHweYxeyOdpbQQ8rU35f4V8Rlf9MhDFDTScHKHRG4TFGoNjqc5gr9UbbbV6g53WwNqxLNvU5AhR9/DiSgwY1kbAlNkK+KV2Qn6JyIZfKhLyS2wEvBpDBynzouEkgGVZFGn0DuVhdCjVGhz1RqOw/ne2QC1gGY2eFWn0RlFBmc6t4nEBj6ezt+EXOtgKCp3sBIV2Qj4dKWRmTx7OpS7NOmUMS/MbPGWMZVnw+Xx2w4YNKfVN82qodu3aSS5evJjg4+NTZ8/Rrl07iYODg6FiDGrfvn0LK2a21EVnMAryS3UuhWV6lxKN3tnAsvzHvb4u16/+jcVzp0NTVoYBL4Tjg2WKGqOT7ty6gSXz3kFCfBxmzl8E2bSZAAB18k28P/3NytfdT7mL6fM+xMS3ovDZqo9w5vdj6NpdgpXrt0JvNAq//XaPW0FentuEKdNMYbXlFzrZCvJd7W3y+DyGzlppYRbZc1YdvvfDDz84L1iwoH14ePgjY0r1ej0Egpb7eCdPnrzxuAADgFZvFD4s1roVlOncynQG++Zod8WCeVjyyXqEPtUbM14fgzMnjmHA8+GPvMbZtQ0+WKbA70eVjzwu7hyAvUdPAQAMBgPCe3fDC0OlKCzIR9zFP7H/1zP4cObbuJlwDR3EnXBw33fY/M1+AIDeaBQWlBrdCkp1bmn5ZayDDb/AWSTMdRUJ8wR8XgN2oKnGsviztfn5+XwXFxc9AMTGxjr16dMnMCIiomPXrl27A8DmzZvdJBJJcFBQULfIyEh/vd6UpwkTJviFhIQEd+nSpfucOXN8q2+3qKiIGThwYEBt08Fqc/nyZTuJRBJsMLK87CKN++9/xXcNkUhCHxSWtb986ZL9m6OlGD/8OUybMApZmRkAgCljRuCzVR8hckQYIgY9jcsXzj62jazMDBQXFaJHr2fAMAwiRo3H8WoBBAB3D0+E/OspCIR17ylfOH0SHfzF8G3vBx6PB51OB5ZlUVZWBoFQiN3bNiJy8lQIa9kGy7JMkUbvkpZXKk5IL+yRnFUU8LBY28bY9ONjqhYWGc6KWSkdO3bsPmvWLP+PPvooveK5q1evOkRHR6cmJydfu3z5st3+/fvdLl68mJiYmHidx+OxW7dudQeATz/9NDU+Pj4hMTHx2pkzZ5wuXLggqthGQUEB78UXXwwYN27cw3nz5tU6Gmrw4MGBQUFB3YKCgrotW7bMq2v3UJ7OYLT93/m4Hml5peIDP+13fHHEq9DpdFAseR9rt8Xg+0MnMHLcBGxcs6JyOwa9AXtif8P7S1dh6/o1AIAHGemY8fqYGm0+yEiHt88/v0e8fXzxICO9xusa4sjBHzH0lVEAAAdHJwwZHoFxQwehXQd/ODo541rcZTz/0vB6t8OCZYo1euf7uSWdEtILQlNzS9uV6Qy29b6RqpfF79YeO3bMYfLkyR1v3LhxDQBCQ0OLg4KCtABw5MgRp/j4ePsePXoEA6aZGl5eXnoAiImJcdu9e7eHXq9nsrKyhHFxcXZ9+vQpBYCXX365y+zZszOioqJqnQECmHZr27Ztq88t0bnmFGm8k7OKOrwY8W8c+eUnTJkxB0d/+QlrNu+EOvkmbiUlYlrkqwBMu5MeXpXTQhE2bAQAoJvkX0i7lwIA8Grrgy++3lejzdqGWjblMohOq8XJXw9jlnxJ5WOTo2ZhctQsAMDS+e9i+rwF+PG7r3Huj98RENQd/5n1Xr3bNRhZQU6xpm1OsaatvY2gwNPJNtNFJGzwrBzqURYZzqqGDBlSnJubK0hPTxcANaaNMWPGjMn54osvUqu+JzEx0WbTpk3ely5dSvD09DSMGjVKXFZWVrkX0bt376IjR464TJ069WFtE49ZADnFOo+8jEJPncFYOdj9pYh/472oNxA2LAIMw8C/Y2fcTLiGzoFB+ObA/2qt38bG1Mnw+HwYDI+/euHt44vM9LTKv2emp8HTu+1j3lG7078fQ1BID7h7etV4LiH+KgDAv1NnrPlIjl0/HML709/E3TvJ8O/YucFtlGj1zndz9M52Qn6Jh6Nteht7YR69nto4FrlbW9WVK1fsjEYjvL29a3yzhw4dWhAbG9smNTVVAACZmZn8Gzdu2OTm5vJFIpHRzc3NcO/ePcGJEydcqr4vOjo6zc3NTT9p0iS/qo8bWZZ5UFDmyfD4NjklunZVgwkAHcQdwefx8eWGaLwUYeopxZ0DkJuTjbhLfwIwrd5wKymhSZ/V07stHBwccfXyX2BZFr/88D2ef7H+Xc/qDh/Yj2Hlu7TVfbF2JabP+xB6nR5Go+k8D4/HQ1lpSa2vr0+ZzmB/P7ekc1JmYffsIo17c8yztRbNcCml/ksfza3qSggsy2LLli3q2s7M9urVq2zRokWpYWFhgUajEUKhkP38889TwsLCikNCQkoCAgK6+/n5aXr16lVjnudXX311b+zYseJp06a137Jly/2cYq17VqHGtyKQb42NQMVaPwHB3bFy/VYAwEsRr+LTlUtw6GwcAEBoY4O122LwyZIPUFRYAL3BgIlTpqFL1+A6P9+DjHQse//dWndtF65aV3kp5dnnh1Seqd37zU4AwNhJbyL7QSZek76A4qJC8HgM/u+rrfjp+Dk4OjmjtLQE50+dwGLFZzW2ffyIEiE9noJXWx8AQOhTz2DUkP4IDO6Ort0kdf+DNIBWb7RLyysVZxdp2no726W2sbdp8IoU1opOGatHXonWOSO/rIPWYLQjXUtrIrLhF/m6iFIcbAWlVR+nU8b+YfHHnC2lTGewScsr9SvS6F3qfzXVWKVag2NyVlE3V5Ew28dVdF9Ir5XWQMNZjZFlmcyCMu/sIq0Py7IWf0zOdXmlOo9Cjd7Vx0WU4uZgU+uqgtaKhrOKYo1edD+3tKNGbxDV/2qquRiMrOB+bkmnvBJtnpHFY9d5sia0Z4DppFJGfpn37aziYBpMcoo0eteHpQZfsVw5mXQtXGD14dToDcLkrOLAB4Vl7VnQ4WekGVnwAOwUy5V7xXKlM+l6SLLqcD4s1ra5mVnUvUSrdyJdC1XDGACXxHJlT9KFkPLEx5ySGEmzThlTyVT1XjdlGKbXW2+9lbl9+/b7ALBkyRLvoqIi/qeffppW33sB025sal5p+4fFWu/qz235VIEf9nwNN3d36PV6vPvBYjzXiAv9Wo0G77wxDnkPc/DmjDk4f+oEJr09HZ0Dg7Bj4zq8NXNevdvo27U9zifdr/H44jnTMWjISwiXvtLgeiqorlzCx/LZAEyff9ocOcKGjUBG2n0snB2FnKwHYHg8jI6UYcKUaXVuJ/7vy5j0SjjWbN6JcOkrSLymwsoF81BUVAg+j4e3Zs7D0Jf/DQCmGS6J1zEo7CW8Wz5UcNv6aAQGd2/QuF0AXQCcE8uVc9UK6eZGf2gLZ5EnhGxsbNhDhw61SU9Pz6hv2lZ1eoORfzenpFOxVl/nLtOkt6IgmzYTt28mYfKo4fj976GoOozvcdPREq9dhV6nq5yaVfFFBYAdmz5rUDhbQpegYOxR/g6BQICszAyMeWkgBocPBZ8vwHuLVyBY0gPFRYUYP/x59B34HDoHBtXYhsFgwPrVS9F/8AuVj9mJRFixfgv8O3bGg4x0vCZ9Hv0HhyEjzTS9df+vZ/DGv4ehsCAfZaWliI+7hKmz5zemdFsAX4jlyv4ApqgVUquZ9G2Ru7V8Pp99/fXXs1atWlWj57tx44ZNv379AgMDA7v169cv8ObNmzYAMGrUKLHsjckdn36mb4/BvUOcf1UeqLedTgFdwRcIkPswB4vnTEf0soWYMjYC61ctRX5uLmZPmYDR4c9i4svhuJEQj5zsLCx4dyqSrqsw9qWBuKe+gyljRuBa3BWsX70UmrJSjH1pID6c+TYAYPaUCRg//Dm8GtYP+7/d/Ujba5cvwrhhg/H2+FfwMKfmmI/rV/9GbdPQ6iIS2Vf+QtFoNJUD5j292yJY0gOAaXZKpy6Bdc50+W7XlxgyLAJu7v/ccVHcqUvlmFuvtj5wc/dA7sNsCARClJWVwWg0QqfTgc/nY/O61Zg+b0G9P/c6TADwm1iudK/3la2ERYYTAObPn//gxx9/dMvJyXlkRYFp06b5RUZG5ty4ceP6uHHjcqKiojoAgBE8YXp2rtvun44wG3d9jw2rl9XbxtUrF8FjeHBzN03pvHvnFr787me8t2QFNn+6GkEhodj/6xnM/GAxFs2OgruHJz6K/hw9n+mHvUdPoYO4Y+W2Zn+4FLZ2Iuw9egqrN24HACxbuwnfHzqB72KPY8/ObcjLNU2CKS0pRrAkFP89fBK9+j6LrZ998khdj5uGtvebnZVD+Wr7PK+G9cPo8GexaNWnNXr/1HspSLx2FZKeNY9UMtPTcPxILMZMerPGcxVUVy5Bp9Ohg39HdAroCp927TF+2GC8OGIkUtR3wLIsgkNC6/uxP86zAM6L5cqAJ9mIpbDI3VoAcHNzM44ZMyZHoVB4iUSiypkoV65ccTh8+HAyAERFRT1ctmxZ+4fF2jZGntD5+ZfCwePx0DkwCDnZWXVu+5sdW6D8aS/sHRyxZvNXlb3Mi9KRleNpr/x1Hp9u+xoA0OfZQcjLfYjCgvxGfYY9u7bh+JFYAEBmeipS7iTDtY0beDweXoow7Q6PeHUs5v5n0iPve9w0tLGPCU9oz6fx02/ncPtmEhbNmY4Bzw+BrZ1pVGJJcRHmTX0d85euhqNTzT3+6GULMHvB0srPX11WZgYWzp6GFZ9trjwEeH/p6srnZ04ej8WrP8P2z9fiRsI19B34HEZFyhr0c6qmC0wBHalWSE81ZQOWwmLDCQAffvhh5lNPPdVt/PjxdY/1ZRje/dySTsA/07OAf+ZGbvzkY5w6bprOVXGcWHHMWZ3IvspKI084t/Kvc6dx/vQJfH3gfxCJ7DFlzAhoNHUcTlXfLss+dhpafToFdIXI3h63khLQvUdP6HQ6zP2PDMNHjsGQYRG1vufa1Sv4YMYUAEDuw4c49fuv4PMFeGGoFEWFBXjnjXF4Z/5ChD7Vu8Z7fz96CN1De6K0tAS3khIQvWUXJo8ajuGvjoFI1KTVW9wA/CqWK0epFdKaS0G0Eha7WwsA3t7ehoiIiNw9e/ZULiXSs2fP4h07drQBgM+3fNmx5zP9H/sZZ36wGHuPnqoMZkM91ac/lD+ZZo38de40XN3ca+1xqhIIBdDpTPcbKioogLOLK0Qie9y5dQNXr1ysfJ3RaETFMfGhn/ejZ+++j2ynKdPQ7qfcRcUSLWn3U3A3+RZ8O/iBZVksnT8TnQIC8fp/ZtT5/sNn43D43FUcPncV4cNfxsKVa/HCUCl0Wi3mvD0JEaPG48URI2u8T6fT4dudWyGbNhNlpSWVv8CMrBE6bYPu8VsXWwA/iuXKl59kI1z2xD1nQy59tKSFCxdmxMTEVJ6h2LJlS4pMJhNv2LipQxsPL8HydZtapN2oOXIsmTcDo8OfhZ3IHis+q/9M/6hIGca8OADBIaFYtnYT9v3fTowOfxbizgEI7fl05etE9g5IvpGI8cOfg6OTM9ZsfvQY8nHT0KpOHavqyl/nsHPzBggFAjA8HhasXIs2bu64/Oc5xP7wXwQEdcPYlwYCMP3CGvjCi3Vuq6qjsT/h8oWzyM99iIP79gAAln+6GUHdTVPM/huzAy+Pfg0ikT0Cg0PAsixGDemPAS+Ew9nliecU2ADYL5Yrx6sV0h+fdGNc0yqnjGXkl3k/KCxrT7oOqvEyU27j7YONXhdJDyBSrZDWnABrwSx6t7Y2DwrLPGkwrY4AwHdiuXIE6UKaU6sKZ06Rxi0jv8yv/ldSrRAfwH/FcuUzpAtpLk0Jp9FoNHJugHheidYlLa+0Y/2vpLiKZVmweKI1huwBxLaW66BNCWd8VlaWC5cCWqrV293PLe1Il46yXCzLQl9SgLt5T3QGFwA8ARwRy5U1Ro9ZmkafELp06ZKXQCDYASAEHNgtNrLg5ZYZfAxGy75ma+1YsLibp8PGC7ko0DTLbVguAhioVkjLmmNjJDQ6nFwiliuFAH4FMJh0LRQnfaVWSN8iXURTEe/5ntAm0GBSdZsilistNpwW23OK5cpIAN+SroPiPA2AZ9UKKdHBMk1hkeEUy5UdAfwNwKqXsaAa7C6Ap9QKaZ33vuEii9utFcuVAgDfgQaTajh/ANtIF9FYFhdOAMsB9CFdBGVxRovlyvGki2gMi9qtFcuVAwGcgGX+UqHIewigu1ohffyyERxhMV9ysVxpA+BLWFDNFOe4AdhOuoiGsqQv+ocAaq46RVGNM0IsV75BuoiGsIjdWrFc2RVAHEwTbCnqSWUD6Mr1s7ec7znFciUD05k2GkyquXgAWEW6iPpwPpwwLYlIRwFRze1trq8mz+lwiuVKO1jAbzjKIvEA1Ly9N4dwOpwAZgPoQLoIqtUaLJYr/13/y8jg7AkhsVzZBsBtAK6ka6FatWsAJGqFlHNB4HLP+T5oMKmW1x2mO5pxDid7TrFc6QlADdOyExTV0jjZe3K155wBGkzKfDjZe3Ku5xTLlSIAKTBdi6Ioc+Fc78nFnnMyaDAp8+sO4EXSRVTFqXCK5UoegLmk66CsVt03iyGAU+EEMBJAZ9JFUFZLKpYrxaSLqMC1cL5NugDKqvEATCNdRAXOnBASy5XtYDoRxLVfGJR1yQbQXq2Q1nGzVPPhUhAmgVv1UNbJA6bDK+K4FIbJpAugqHKvkS4A4MhurViu7A/gDOk6KKqcBoC3WiHNJ1kEV3pOi1oVjWr1bAG8SroIroQzgnQBFFUN8Q6D+G6tWK4MhWl9IIriEj1Mu7bE1hniQs9Je02KiwQAhpAsgAvhfJl0ARRVh3CSjRMNp1iu9ALQm2QNFPUY1htOAAMBcOb29RRVjb9Yrgwk1TjpcA4g3D5F1YdY70nDSVGPR2zNZGLhFMuVDgD+Rap9imqgXqQaJtlz9oXpdDVFcVmn8mVazY5kOIn9RqKoRiLyXSUZzu4E26aoxniaRKMkw9mNYNsU1RjW03OW39YvmETbFNUEXUk0Sqrn9AfgQKhtimqsjiQaJRVO2mtSlsSxfKipWZEKpx+hdimqqTqZu0FS4fQl1C5FNZXVhNOHULsU1VRiczdIw0lRDeNm7gZpOCmqYcw+hI9UOM1+5ouinpDVhJNe46QsjdWE045QuxTVVFYTTltC7VJUUzmZu0Gzh1MsVwoB8M3dLkU9IbN/Z0n0nHSXlrJEZg8niZUIaK/ZQoTOl/+09d3bhXQdrRMvD5CatUUS4dQRaNMasHZtf3YAY/6L5dbBmGfuFkns1moJtNnqObicPQe+lq4u0XLM/r01ezjVCqkOgMHc7bZmDIxGfttDrqTraOXMvsdH6lJKMaF2WyVX1z/OsDw9XfalZbX+nrNcEaF2Wx0eDHqj968epOuwAhpzN0gqnDmE2m11PNocO2XkGejKEi0v1dwNkgpnOqF2WxUhtBqt10k6cd087pi7QVLhTCPUbqvi7Xb0tIFnJLIynBWi4aQaxg5lJUWeZ9uTrsOK0HBSDePrpjxt4LG01zQfqwnnfULttgoOKCnI9bwoJl2HFWEB3DV3o6TCeYNQu61CB4+fz+p5LLE7LluhNJVMZTWXUm6CDuNrEhcUPMx0v0oHt5uXmkSjRMKpVkj1AJJItG3p/Dx+uqDngYbTvMx+vAmQvcvYNYJtWyR35D64755Ad2fNj4aTejyx5/6/9Dx0Jl2HFUom0SjJcP5NsG2L0xZZabfdb9FhemScItEoyXCeg+kUNdUAHT33XtEzjNnv10FBrZKpbpNomFg41QppDoAEUu1bEj8m7W6iewrtNck4Tqphkj0nQGh3wdL4e+5V0V6TGBpOqnYBzN1b8W7pIaTrsGI0nFTt/Lz2JuoZRky6Dit1XSVTEZveSDScaoU0BXQwQp0kzM2Ey22yJaTrsGLEek2AfM8JAAdIF8BV7bz3JesZxp90HVbsN5KN03By1DNM/NULrvmhpOuwYgYAJ0gWwIVwngeQSboIrvHy/vGenmH8SNdhxa6oZCqzLyRdFfFwqhVSI4BfSBDHWaMAAAipSURBVNfBJc/xLl4+41pMjzXJUpIugHg4y/1IugAuaeN1MJ32mkQZAHxFugiuhPN/oCvyAQCG88789burpgfpOqzcEZVMdY90EZwIp1ohNQD4mnQd5LGsvbcyy8AwdOEusraRLgDgSDjL7SRdAGlj+MfPH3Mx0DO0ZN0HcIh0EQCHwqlWSG8AOEu6DlIYGI08r1/zaK9J3A6VTMWJG21xJpzliB+EkzJJcPjsUReWHmuSxYkTQRW4Fs7vAGSRLsLc+DDotV4nigwMQ2+tQNYhlUzFmWVbORVOtUJaCmAT6TrM7T+Cn88cdubRXpM8TpwIqsCpcJbbBCu6f6cNdJoCr7NlRobxIV2LlUsBcJh0EVVxLpxqhfQhrOjM7Uzh3nOxzgJ6hpa8L1UylZF0EVVxLpzl1gHQky6ipYmgKcn0vKilvSZx2QA+J11EdZwMp1ohvQsrGJQwT/h/F35xtqG9JnmrVDJVIekiquNkOMstAVBKuoiW4oDSQrWXSm9kmLaka7FyKQA2ky6iNpwNp1ohTQWwnnQdLWWBza6/fnGypb0meUtJ3KSoITgbznKfAMghXURzc0VhbqJnktHIMN6ka7Fy18DhwydOh1OtkOYDWEG6jub2kc32ywed7GivSd67XBmqVxtOh7PcZgCJpItoLl7IzbrsqYaRYbxI12LlflDJVEQX8KoP58OpVki1AKJI19Fcltlsu3rASUR7TbJKAcwjXUR9OB9OAFArpCfA4WODhmqHrPSznqkMyzCepGuxcmtUMpXZbyPfWBYRznJzATwgXcSTWGm7OeGAkz1dG4isBJhONHKexYSz/MZH75Kuo6k6Mmkpxzyyaa9JVimAsSqZyiKun1tMOAFArZD+F6ZpZRZnle0XyQdpr0nabJVMFU+6iIayqHCWmwaAyP0SmyqYuZsc61EAlmE8SNdixf6rkqm+JF1EY1hcONUKaQGA8QB0pGtpqBW2m1N/cbSn8zXJSQbwH9JFNJbFhRMA1ArpXwAWka6jIXoyN5N+8Cg2sgzjRroWK6UFMF4lUxWQLqSxLDKc5aIBHCFdRH0+tt2cFevoQK9rkiNXyVQXSRfRFBYbTrVCygJ4DRy+hWB/Xvy1bz31etprEvOLSqb6jHQRTWWx4QQAtUKaByACwEPStdRmie3WAqUDPdYk5D6AyaSLeBIWHU4AUCukNwGMBsdOEIXzLv69y4PRsAzThnQtVqgAwKsqmcqiZzRZfDgBQK2Q/g7gHdJ1VPWB7Veaww72/yJdhxUqASC11OPMqlpFOAFArZB+CY5ML3uFd+biNg9BKcswrqRrsTIaAK+oZKrTpAtpDq0mnACgVkgXgwOrJ8yxjWGOONj3JF2HldEBGK2SqY6RLqS5tKpwAoBaIZ0DgNhIkEj+sQufe9oVgmFcSNVghQwAJqhkqljShTSnVhfOclEA/s/cjTIwGqfbfGf3q72I9prmwwJ4UyVT7SNdSHNrleEsv5X9GwC+MWe7b/MPnV/n6ZBLe02zmq6SqSx+rm9tWmU4gcob8soAmOUiNA9Gwxs2Pzgfsxc9ZY72KADAPJVMtZV0ES2FYVmWdA0tTixXfghgVUu2MVuw/9Qd3z8Mxx3sn2vJdigAppM/s1Qy1RbShbSkVttzVqVWSFcDeBumEwfNTgi9dpww1vO4vahXS2yfesQDAGGtPZiAlYQTANQK6Q4ALwPIb+5tfyD4/vwqT+cMMIxTc2+besRlAE+rZKpTpAsxB6sJJwCoFdJDAHoDuN5c27SDpnSE8Ne2J2iv2dL2ABigkqnukS7EXKzimLM6sVzpBCAGwKtPuq1Vgh0nz7RTsX/Yi5574sKo2hhgmva1lnQh5mZVPWcFtUJaCGAUgMV4guNQB5QWhtn80f4Pkd3TzVYcVVUugOHWGEzASnvOqsRyZX+Yrod2aux7Nwg3njziewun7UWDm78yq3cNpnGyyaQLIcUqe86q1ArpWQA9AHzVmPe5oCivr/BPv9O012xuRgAbAfSx5mACtOd8hFiuHAlgO4B6V8nbLlx74gffezhDjzWbUwKAKSqZ6hzpQrjA6nvOqtQK6c8AggHshGnMZq3ckZ8dKozreEZk94zZimvddAA+BvAvGsx/0J6zDmK5sh9MdzirMWH6W+HKkzHtHuCciB5rNoPjMN2K7xrpQriGhvMxxHIlH8B0mH6ruwCAL7LTf7Sfow/383UHw9gTLdCy3YVpbOwPpAvhKhrOBhDLlR4AFgKI+tFmyZ+bfQuMF0R2tNdsmlIAawB8Yin3LCGFhrMRxHKl30XR63Of9/eZDIZxJl2PhcmB6TBhk0qmsui7xZkLDWcTSGIkHQDMB/AWABHhcrjuJkzT9nbTnrJxaDifgCRG4gVgNkzHpXSC9aPOAFgH4IBKpjKSLsYS0XA2A0mMxAXAWACRAAYDYMhWRIwRwE8A1qpkqvOki7F0NJzNTBIjaQ/TXdAiAVjLWkLJMIVyi0qmsqjbM3IZDWcLksRIggBMgOmeLp0Jl9OcWAAXABwAcFAlUzXbFDzqHzScZiKJkfSBqTd9FUAHwuU0RSmA32AK5C8qmSqTcD2tHg0nAZIYiS+APlX+PA3AkWhRNRkA3AJwFsBBAP9TyVQlZEuyLjScHCCJkfABdMOjge0O84x9ZgGkAIiv9idBJVNpzNA+VQcaTo6SxEgcAQQC8ALgWf7fqn+qPlbXtVYtTHfcyoNp4nJu+f+nwTRfMh7ANZVMVdhiH4RqMhrOVqA8yPYwhVEHQKuSqTh1S0Sq8Wg4KYqj6HxOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriKBpOiuIoGk6K4igaToriqP8HVzF3OVwiDFMAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# create a pie chart showing the break down of the categories\n",
    "plt.pie([profitable, break_even, non_profitable])\n",
    "\n",
    "# add a legend and include the percentage values in the legend (the break even category was too small to put the percentages on the pie chart itself)\n",
    "plt.legend([f'Profitable: {profit_per}%', f'Break Even: {break_even_per}%', f'Non-Profitable: {not_profit_per}%'], loc='upper left')\n",
    "\n",
    "plt.savefig('figures/Profit_Pie_chart')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:PythonData] *",
   "language": "python",
   "name": "conda-env-PythonData-py"
  },
  "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.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}