Lab W6_NkechiIregbulem.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<p class=\"pull-left\">\n",
    "COMP 061 - Programming for Data Science\n",
    "</p>\n",
    "<div class=\"pull-right\">\n",
    "<ul class=\"list-inline\">\n",
    "Copyright © Dana Nehoran 2017\n",
    "</ul>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " <div style=\"background-color: #FFF8C6; border:1px solid #000; margin-left: 2px; margin-right: 2px; \n",
    "\n",
    "padding-bottom: 2px; padding-left: 2px; padding-right: 1px; padding-top: 10px;\">\n",
    "<center><b><font size=\"6\">Lab Week 6</font></b></center>\n",
    "</div>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Preparation for pandas and NumPy\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from pandas import DataFrame, Series\n",
    "import random\n",
    "\n",
    "import matplotlib.pyplot as plt\n",
    "from urllib.request import urlopen\n",
    "\n",
    "pd.options.display.float_format = '{:,.2f}'.format\n",
    "\n",
    "# Preparation for matplotlib\n",
    "%matplotlib inline "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# The following commands allows automatic reload of the file on each run\n",
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/javascript": [
       "require(\n",
       "        [\"notebook/js/outputarea\"],\n",
       "        function (oa) {\n",
       "            oa.OutputArea.auto_scroll_threshold = -1;\n",
       "            console.log(\"Setting auto_scroll_threshold to -1\");\n",
       "        });"
      ],
      "text/plain": [
       "<IPython.core.display.Javascript object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%%javascript\n",
    "require(\n",
    "        [\"notebook/js/outputarea\"],\n",
    "        function (oa) {\n",
    "            oa.OutputArea.auto_scroll_threshold = -1;\n",
    "            console.log(\"Setting auto_scroll_threshold to -1\");\n",
    "        });"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<blockquote style=\"border: 2px solid #666; padding: 10px; background-color: #99e6ff\"><b> Question 1:</b> Stock Exchange Data Retrieval\n",
    "<div class=\"pull-right\">\n",
    "Practice for homework question 1\n",
    "</div>\n",
    "</blockquote>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<b><font color=\"blue\", size = 4>a)</font></b> What were the 15 most recent technology IPOs on `NYSE`?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<span style=\"background-color: #FFFF00\">Your answer here</span>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "exchange_columns = ['Symbol', 'Name', 'LastSale', 'MarketCap', 'IPOyear', 'Sector', 'Industry']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>LastSale</th>\n",
       "      <th>MarketCap</th>\n",
       "      <th>IPOyear</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WBAI</td>\n",
       "      <td>500.com Limited</td>\n",
       "      <td>10.93</td>\n",
       "      <td>461,849,696.69</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Consumer Services</td>\n",
       "      <td>Services-Misc. Amusement &amp; Recreation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WUBA</td>\n",
       "      <td>58.com Inc.</td>\n",
       "      <td>70.53</td>\n",
       "      <td>10,402,433,024.40</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Programming, Data Processing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ATEN</td>\n",
       "      <td>A10 Networks, Inc.</td>\n",
       "      <td>6.16</td>\n",
       "      <td>447,876,980.32</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Communications Equipment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AAC</td>\n",
       "      <td>AAC Holdings, Inc.</td>\n",
       "      <td>7.32</td>\n",
       "      <td>180,047,661.00</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Medical Specialities</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ABBV</td>\n",
       "      <td>AbbVie Inc.</td>\n",
       "      <td>96.01</td>\n",
       "      <td>145,385,321,734.98</td>\n",
       "      <td>2,012.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Major Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ACN</td>\n",
       "      <td>Accenture plc</td>\n",
       "      <td>174.14</td>\n",
       "      <td>111,432,186,000.00</td>\n",
       "      <td>2,001.00</td>\n",
       "      <td>Miscellaneous</td>\n",
       "      <td>Business Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ATV</td>\n",
       "      <td>Acorn International, Inc.</td>\n",
       "      <td>20.80</td>\n",
       "      <td>55,746,912.00</td>\n",
       "      <td>2,007.00</td>\n",
       "      <td>Consumer Services</td>\n",
       "      <td>Other Specialty Stores</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>GOLF</td>\n",
       "      <td>Acushnet Holdings Corp.</td>\n",
       "      <td>26.43</td>\n",
       "      <td>1,975,886,316.75</td>\n",
       "      <td>2,016.00</td>\n",
       "      <td>Consumer Non-Durables</td>\n",
       "      <td>Recreational Products/Toys</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AGRO</td>\n",
       "      <td>Adecoagro S.A.</td>\n",
       "      <td>7.38</td>\n",
       "      <td>860,177,612.16</td>\n",
       "      <td>2,011.00</td>\n",
       "      <td>Consumer Non-Durables</td>\n",
       "      <td>Farming/Seeds/Milling</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>ADNT</td>\n",
       "      <td>Adient plc</td>\n",
       "      <td>36.88</td>\n",
       "      <td>3,443,551,910.24</td>\n",
       "      <td>2,016.00</td>\n",
       "      <td>Capital Goods</td>\n",
       "      <td>Auto Parts:O.E.M.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Symbol                       Name  LastSale          MarketCap  IPOyear  \\\n",
       "2    WBAI            500.com Limited     10.93     461,849,696.69 2,013.00   \n",
       "3    WUBA                58.com Inc.     70.53  10,402,433,024.40 2,013.00   \n",
       "6    ATEN         A10 Networks, Inc.      6.16     447,876,980.32 2,014.00   \n",
       "7     AAC         AAC Holdings, Inc.      7.32     180,047,661.00 2,014.00   \n",
       "12   ABBV                AbbVie Inc.     96.01 145,385,321,734.98 2,012.00   \n",
       "21    ACN              Accenture plc    174.14 111,432,186,000.00 2,001.00   \n",
       "23    ATV  Acorn International, Inc.     20.80      55,746,912.00 2,007.00   \n",
       "26   GOLF    Acushnet Holdings Corp.     26.43   1,975,886,316.75 2,016.00   \n",
       "29   AGRO             Adecoagro S.A.      7.38     860,177,612.16 2,011.00   \n",
       "30   ADNT                 Adient plc     36.88   3,443,551,910.24 2,016.00   \n",
       "\n",
       "                   Sector                                         Industry  \n",
       "2       Consumer Services            Services-Misc. Amusement & Recreation  \n",
       "3              Technology  Computer Software: Programming, Data Processing  \n",
       "6              Technology                Computer Communications Equipment  \n",
       "7             Health Care                             Medical Specialities  \n",
       "12            Health Care                            Major Pharmaceuticals  \n",
       "21          Miscellaneous                                Business Services  \n",
       "23      Consumer Services                           Other Specialty Stores  \n",
       "26  Consumer Non-Durables                       Recreational Products/Toys  \n",
       "29  Consumer Non-Durables                            Farming/Seeds/Milling  \n",
       "30          Capital Goods                                Auto Parts:O.E.M.  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "url = \"https://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NYSE&render=download\"\n",
    "try:\n",
    "    NYSE = pd.read_csv(urlopen(url))\n",
    "    NYSE = NYSE[exchange_columns]\n",
    "    NYSE = NYSE.replace('n/a',np.NaN).dropna()\n",
    "    display(NYSE.head(10))\n",
    "except:\n",
    "    print (\"Error with the following url\")\n",
    "    print (url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>LastSale</th>\n",
       "      <th>MarketCap</th>\n",
       "      <th>IPOyear</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3158</th>\n",
       "      <td>ZUO</td>\n",
       "      <td>Zuora, Inc.</td>\n",
       "      <td>21.10</td>\n",
       "      <td>2,272,868,346.90</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>AVLR</td>\n",
       "      <td>Avalara, Inc.</td>\n",
       "      <td>35.75</td>\n",
       "      <td>2,376,382,973.25</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2175</th>\n",
       "      <td>PAGS</td>\n",
       "      <td>PagSeguro Digital Ltd.</td>\n",
       "      <td>29.66</td>\n",
       "      <td>9,346,886,837.88</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>EDP Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2219</th>\n",
       "      <td>PRSP</td>\n",
       "      <td>Perspecta Inc.</td>\n",
       "      <td>26.14</td>\n",
       "      <td>4,332,196,158.76</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>EDP Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2266</th>\n",
       "      <td>PVTL</td>\n",
       "      <td>Pivotal Software, Inc.</td>\n",
       "      <td>19.35</td>\n",
       "      <td>4,980,408,186.60</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>HUYA</td>\n",
       "      <td>HUYA Inc.</td>\n",
       "      <td>21.71</td>\n",
       "      <td>4,424,434,129.18</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Programming, Data Processing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1461</th>\n",
       "      <td>HMI</td>\n",
       "      <td>Huami Corporation</td>\n",
       "      <td>10.68</td>\n",
       "      <td>634,756,358.88</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2572</th>\n",
       "      <td>SMAR</td>\n",
       "      <td>Smartsheet Inc.</td>\n",
       "      <td>28.26</td>\n",
       "      <td>2,903,882,977.44</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1268</th>\n",
       "      <td>GTES</td>\n",
       "      <td>Gates Industrial Corporation plc</td>\n",
       "      <td>19.18</td>\n",
       "      <td>5,557,527,349.22</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Industrial Machinery/Components</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1036</th>\n",
       "      <td>DAVA</td>\n",
       "      <td>Endava plc</td>\n",
       "      <td>28.19</td>\n",
       "      <td>1,494,186,847.55</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>EDP Services</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Symbol                              Name  LastSale        MarketCap  \\\n",
       "3158    ZUO                       Zuora, Inc.     21.10 2,272,868,346.90   \n",
       "278    AVLR                     Avalara, Inc.     35.75 2,376,382,973.25   \n",
       "2175   PAGS            PagSeguro Digital Ltd.     29.66 9,346,886,837.88   \n",
       "2219   PRSP                    Perspecta Inc.     26.14 4,332,196,158.76   \n",
       "2266   PVTL            Pivotal Software, Inc.     19.35 4,980,408,186.60   \n",
       "1473   HUYA                         HUYA Inc.     21.71 4,424,434,129.18   \n",
       "1461    HMI                 Huami Corporation     10.68   634,756,358.88   \n",
       "2572   SMAR                   Smartsheet Inc.     28.26 2,903,882,977.44   \n",
       "1268   GTES  Gates Industrial Corporation plc     19.18 5,557,527,349.22   \n",
       "1036   DAVA                        Endava plc     28.19 1,494,186,847.55   \n",
       "\n",
       "      IPOyear      Sector                                         Industry  \n",
       "3158 2,018.00  Technology          Computer Software: Prepackaged Software  \n",
       "278  2,018.00  Technology          Computer Software: Prepackaged Software  \n",
       "2175 2,018.00  Technology                                     EDP Services  \n",
       "2219 2,018.00  Technology                                     EDP Services  \n",
       "2266 2,018.00  Technology          Computer Software: Prepackaged Software  \n",
       "1473 2,018.00  Technology  Computer Software: Programming, Data Processing  \n",
       "1461 2,018.00  Technology                           Computer Manufacturing  \n",
       "2572 2,018.00  Technology          Computer Software: Prepackaged Software  \n",
       "1268 2,018.00  Technology                  Industrial Machinery/Components  \n",
       "1036 2,018.00  Technology                                     EDP Services  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tech_df = NYSE[NYSE.Sector == \"Technology\"].sort_values(\"IPOyear\", ascending = False)[0:10]\n",
    "tech_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<b><font color=\"blue\", size = 4>b)</font></b> What are the 10 health care companies with the largest market cap on `NYSE`?"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<span style=\"background-color: #FFFF00\">Your answer here</span>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>LastSale</th>\n",
       "      <th>MarketCap</th>\n",
       "      <th>IPOyear</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ABBV</td>\n",
       "      <td>AbbVie Inc.</td>\n",
       "      <td>96.01</td>\n",
       "      <td>145,385,321,734.98</td>\n",
       "      <td>2,012.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Major Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>AGN</td>\n",
       "      <td>Allergan plc.</td>\n",
       "      <td>193.46</td>\n",
       "      <td>65,668,917,880.12</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Major Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1400</th>\n",
       "      <td>HCA</td>\n",
       "      <td>HCA Healthcare, Inc.</td>\n",
       "      <td>138.65</td>\n",
       "      <td>47,979,277,900.00</td>\n",
       "      <td>2,011.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Hospital/Nursing Management</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3156</th>\n",
       "      <td>ZTS</td>\n",
       "      <td>Zoetis Inc.</td>\n",
       "      <td>93.53</td>\n",
       "      <td>45,064,980,294.59</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Major Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1546</th>\n",
       "      <td>IQV</td>\n",
       "      <td>IQVIA Holdings, Inc.</td>\n",
       "      <td>130.35</td>\n",
       "      <td>26,407,201,763.25</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Biotechnology: Commercial Physical &amp; Biologica...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3054</th>\n",
       "      <td>WCG</td>\n",
       "      <td>WellCare Health Plans, Inc.</td>\n",
       "      <td>315.30</td>\n",
       "      <td>15,757,089,438.30</td>\n",
       "      <td>2,004.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Medical Specialities</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1883</th>\n",
       "      <td>MOH</td>\n",
       "      <td>Molina Healthcare Inc</td>\n",
       "      <td>144.66</td>\n",
       "      <td>8,934,490,920.00</td>\n",
       "      <td>2,003.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Medical Specialities</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412</th>\n",
       "      <td>HLF</td>\n",
       "      <td>Herbalife Nutrition Ltd.</td>\n",
       "      <td>54.30</td>\n",
       "      <td>8,534,432,052.30</td>\n",
       "      <td>2,004.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Other Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>592</th>\n",
       "      <td>CTLT</td>\n",
       "      <td>Catalent, Inc.</td>\n",
       "      <td>46.34</td>\n",
       "      <td>6,728,843,027.90</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Major Pharmaceuticals</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>CRL</td>\n",
       "      <td>Charles River Laboratories International, Inc.</td>\n",
       "      <td>134.37</td>\n",
       "      <td>6,454,110,228.75</td>\n",
       "      <td>2,000.00</td>\n",
       "      <td>Health Care</td>\n",
       "      <td>Biotechnology: Commercial Physical &amp; Biologica...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Symbol                                            Name  LastSale  \\\n",
       "12     ABBV                                     AbbVie Inc.     96.01   \n",
       "77      AGN                                   Allergan plc.    193.46   \n",
       "1400    HCA                            HCA Healthcare, Inc.    138.65   \n",
       "3156    ZTS                                     Zoetis Inc.     93.53   \n",
       "1546    IQV                            IQVIA Holdings, Inc.    130.35   \n",
       "3054    WCG                     WellCare Health Plans, Inc.    315.30   \n",
       "1883    MOH                           Molina Healthcare Inc    144.66   \n",
       "1412    HLF                        Herbalife Nutrition Ltd.     54.30   \n",
       "592    CTLT                                  Catalent, Inc.     46.34   \n",
       "630     CRL  Charles River Laboratories International, Inc.    134.37   \n",
       "\n",
       "              MarketCap  IPOyear       Sector  \\\n",
       "12   145,385,321,734.98 2,012.00  Health Care   \n",
       "77    65,668,917,880.12 2,013.00  Health Care   \n",
       "1400  47,979,277,900.00 2,011.00  Health Care   \n",
       "3156  45,064,980,294.59 2,013.00  Health Care   \n",
       "1546  26,407,201,763.25 2,013.00  Health Care   \n",
       "3054  15,757,089,438.30 2,004.00  Health Care   \n",
       "1883   8,934,490,920.00 2,003.00  Health Care   \n",
       "1412   8,534,432,052.30 2,004.00  Health Care   \n",
       "592    6,728,843,027.90 2,014.00  Health Care   \n",
       "630    6,454,110,228.75 2,000.00  Health Care   \n",
       "\n",
       "                                               Industry  \n",
       "12                                Major Pharmaceuticals  \n",
       "77                                Major Pharmaceuticals  \n",
       "1400                        Hospital/Nursing Management  \n",
       "3156                              Major Pharmaceuticals  \n",
       "1546  Biotechnology: Commercial Physical & Biologica...  \n",
       "3054                               Medical Specialities  \n",
       "1883                               Medical Specialities  \n",
       "1412                              Other Pharmaceuticals  \n",
       "592                               Major Pharmaceuticals  \n",
       "630   Biotechnology: Commercial Physical & Biologica...  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tech_df = NYSE[NYSE.Sector == \"Health Care\"].sort_values(\"MarketCap\", ascending = False)[0:10]\n",
    "tech_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<b><font color=\"blue\", size = 4>c)</font></b> Select a segmentation of your own that gives you between 10 to 30 rows"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<span style=\"background-color: #FFFF00\">Your answer here</span>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Name</th>\n",
       "      <th>LastSale</th>\n",
       "      <th>MarketCap</th>\n",
       "      <th>IPOyear</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2157</th>\n",
       "      <td>ORCL</td>\n",
       "      <td>Oracle Corporation</td>\n",
       "      <td>49.75</td>\n",
       "      <td>188,484,748,261.00</td>\n",
       "      <td>1,986.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2478</th>\n",
       "      <td>CRM</td>\n",
       "      <td>Salesforce.com Inc</td>\n",
       "      <td>159.10</td>\n",
       "      <td>120,390,970,000.00</td>\n",
       "      <td>2,004.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2999</th>\n",
       "      <td>VMW</td>\n",
       "      <td>Vmware, Inc.</td>\n",
       "      <td>154.58</td>\n",
       "      <td>63,182,092,445.20</td>\n",
       "      <td>2,007.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2624</th>\n",
       "      <td>SQ</td>\n",
       "      <td>Square, Inc.</td>\n",
       "      <td>96.96</td>\n",
       "      <td>39,795,107,994.24</td>\n",
       "      <td>2,015.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2546</th>\n",
       "      <td>NOW</td>\n",
       "      <td>ServiceNow, Inc.</td>\n",
       "      <td>196.20</td>\n",
       "      <td>34,903,980,000.00</td>\n",
       "      <td>2,012.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2970</th>\n",
       "      <td>VEEV</td>\n",
       "      <td>Veeva Systems Inc.</td>\n",
       "      <td>104.40</td>\n",
       "      <td>15,086,780,002.80</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2553</th>\n",
       "      <td>SHOP</td>\n",
       "      <td>Shopify Inc.</td>\n",
       "      <td>160.20</td>\n",
       "      <td>15,077,942,298.00</td>\n",
       "      <td>2,015.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2703</th>\n",
       "      <td>DATA</td>\n",
       "      <td>Tableau Software, Inc.</td>\n",
       "      <td>107.53</td>\n",
       "      <td>8,918,918,856.20</td>\n",
       "      <td>2,013.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2193</th>\n",
       "      <td>PAYC</td>\n",
       "      <td>Paycom Software, Inc.</td>\n",
       "      <td>147.60</td>\n",
       "      <td>8,653,073,320.80</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1864</th>\n",
       "      <td>MFGP</td>\n",
       "      <td>Micro Focus Intl PLC</td>\n",
       "      <td>18.81</td>\n",
       "      <td>8,094,438,361.35</td>\n",
       "      <td>2,017.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376</th>\n",
       "      <td>GWRE</td>\n",
       "      <td>Guidewire Software, Inc.</td>\n",
       "      <td>99.34</td>\n",
       "      <td>8,007,630,409.46</td>\n",
       "      <td>2,012.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2880</th>\n",
       "      <td>TWLO</td>\n",
       "      <td>Twilio Inc.</td>\n",
       "      <td>80.90</td>\n",
       "      <td>7,883,401,301.40</td>\n",
       "      <td>2,016.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>BKI</td>\n",
       "      <td>Black Knight, Inc.</td>\n",
       "      <td>51.76</td>\n",
       "      <td>7,733,173,245.04</td>\n",
       "      <td>2,017.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624</th>\n",
       "      <td>CDAY</td>\n",
       "      <td>Ceridian HCM Holding Inc.</td>\n",
       "      <td>44.29</td>\n",
       "      <td>5,979,815,014.35</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1464</th>\n",
       "      <td>HUBS</td>\n",
       "      <td>HubSpot, Inc.</td>\n",
       "      <td>150.05</td>\n",
       "      <td>5,820,894,301.55</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981</th>\n",
       "      <td>NEWR</td>\n",
       "      <td>New Relic, Inc.</td>\n",
       "      <td>89.26</td>\n",
       "      <td>5,044,071,174.72</td>\n",
       "      <td>2,014.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2266</th>\n",
       "      <td>PVTL</td>\n",
       "      <td>Pivotal Software, Inc.</td>\n",
       "      <td>19.35</td>\n",
       "      <td>4,980,408,186.60</td>\n",
       "      <td>2,018.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>AYX</td>\n",
       "      <td>Alteryx, Inc.</td>\n",
       "      <td>55.62</td>\n",
       "      <td>3,385,884,909.06</td>\n",
       "      <td>2,017.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>ELLI</td>\n",
       "      <td>Ellie Mae, Inc.</td>\n",
       "      <td>91.81</td>\n",
       "      <td>3,180,294,911.22</td>\n",
       "      <td>2,011.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>BOX</td>\n",
       "      <td>Box, Inc.</td>\n",
       "      <td>22.36</td>\n",
       "      <td>3,166,408,298.04</td>\n",
       "      <td>2,015.00</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Computer Software: Prepackaged Software</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Symbol                       Name  LastSale          MarketCap  IPOyear  \\\n",
       "2157   ORCL         Oracle Corporation     49.75 188,484,748,261.00 1,986.00   \n",
       "2478    CRM         Salesforce.com Inc    159.10 120,390,970,000.00 2,004.00   \n",
       "2999    VMW               Vmware, Inc.    154.58  63,182,092,445.20 2,007.00   \n",
       "2624     SQ               Square, Inc.     96.96  39,795,107,994.24 2,015.00   \n",
       "2546    NOW           ServiceNow, Inc.    196.20  34,903,980,000.00 2,012.00   \n",
       "2970   VEEV         Veeva Systems Inc.    104.40  15,086,780,002.80 2,013.00   \n",
       "2553   SHOP               Shopify Inc.    160.20  15,077,942,298.00 2,015.00   \n",
       "2703   DATA     Tableau Software, Inc.    107.53   8,918,918,856.20 2,013.00   \n",
       "2193   PAYC      Paycom Software, Inc.    147.60   8,653,073,320.80 2,014.00   \n",
       "1864   MFGP       Micro Focus Intl PLC     18.81   8,094,438,361.35 2,017.00   \n",
       "1376   GWRE   Guidewire Software, Inc.     99.34   8,007,630,409.46 2,012.00   \n",
       "2880   TWLO                Twilio Inc.     80.90   7,883,401,301.40 2,016.00   \n",
       "391     BKI         Black Knight, Inc.     51.76   7,733,173,245.04 2,017.00   \n",
       "624    CDAY  Ceridian HCM Holding Inc.     44.29   5,979,815,014.35 2,018.00   \n",
       "1464   HUBS              HubSpot, Inc.    150.05   5,820,894,301.55 2,014.00   \n",
       "1981   NEWR            New Relic, Inc.     89.26   5,044,071,174.72 2,014.00   \n",
       "2266   PVTL     Pivotal Software, Inc.     19.35   4,980,408,186.60 2,018.00   \n",
       "104     AYX              Alteryx, Inc.     55.62   3,385,884,909.06 2,017.00   \n",
       "1015   ELLI            Ellie Mae, Inc.     91.81   3,180,294,911.22 2,011.00   \n",
       "480     BOX                  Box, Inc.     22.36   3,166,408,298.04 2,015.00   \n",
       "\n",
       "          Sector                                 Industry  \n",
       "2157  Technology  Computer Software: Prepackaged Software  \n",
       "2478  Technology  Computer Software: Prepackaged Software  \n",
       "2999  Technology  Computer Software: Prepackaged Software  \n",
       "2624  Technology  Computer Software: Prepackaged Software  \n",
       "2546  Technology  Computer Software: Prepackaged Software  \n",
       "2970  Technology  Computer Software: Prepackaged Software  \n",
       "2553  Technology  Computer Software: Prepackaged Software  \n",
       "2703  Technology  Computer Software: Prepackaged Software  \n",
       "2193  Technology  Computer Software: Prepackaged Software  \n",
       "1864  Technology  Computer Software: Prepackaged Software  \n",
       "1376  Technology  Computer Software: Prepackaged Software  \n",
       "2880  Technology  Computer Software: Prepackaged Software  \n",
       "391   Technology  Computer Software: Prepackaged Software  \n",
       "624   Technology  Computer Software: Prepackaged Software  \n",
       "1464  Technology  Computer Software: Prepackaged Software  \n",
       "1981  Technology  Computer Software: Prepackaged Software  \n",
       "2266  Technology  Computer Software: Prepackaged Software  \n",
       "104   Technology  Computer Software: Prepackaged Software  \n",
       "1015  Technology  Computer Software: Prepackaged Software  \n",
       "480   Technology  Computer Software: Prepackaged Software  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tech_df = NYSE[NYSE.Industry == \"Computer Software: Prepackaged Software\"].sort_values(\"MarketCap\", ascending = False)[0:20]\n",
    "tech_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<b><font color=\"blue\", size = 4>c)</font></b> Create a loop with the following menu items: <br>\n",
    "1 - Search for a symbol <br>\n",
    "2 - Search for part of the name of a company <br>\n",
    "3 - Search for a sector <br>\n",
    "4 - Search for an industry <br>\n",
    "5 - Historical value <br>\n",
    "0 - exit <br>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After the user selects any nubmer between 1 to 5, he/she will be asked to select between 3 options of exchange (NASDAQ, NYSE, AMEX).\n",
    "\n",
    "After the selection of the exchange, the user will be asked the next relevant question. For example if the selection was 1, the program should ask for the symbol to search"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<span style=\"background-color: #FFFF00\">Your answer here</span>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      " Welcome to our Data Store\n",
      "1) Search for a symbol\n",
      "2) Search for part of the name of a company\n",
      "3) Search for a sector\n",
      "4) Search for an industry\n",
      "5) Historical value\n",
      "\n",
      "0) Exit\n"
     ]
    }
   ],
   "source": [
    "print (\"\\n\\n Welcome to our Data Store\")\n",
    "print (\"1) Search for a symbol\")\n",
    "print (\"2) Search for part of the name of a company\")\n",
    "print (\"3) Search for a sector\")\n",
    "print (\"4) Search for an industry\")\n",
    "print (\"5) Historical value\")\n",
    "print (\"\\n0) Exit\")\n",
    "option = input (\"What is your selection? \")\n",
    "\n",
    "your_choice = input(\"Please select a database from AMEX, NASDAQ, AND NYSE: \")\n",
    "if (option == \"1\"):\n",
    "    symbol = input(\"Please enter the symbol: \")\n",
    "    if your_choice == \"AMEX\":\n",
    "        print (AMEX[AMEX.Symbol == symbol])\n",
    "    if your_choice == \"NYSE\":\n",
    "        print (NYSE[NYSE.Symbol == symbol])\n",
    "    if your_choice == \"NASDAQ\":\n",
    "        print (NASDAQ[NASDAQ.Symbol == symbol])\n",
    "if (option == \"2\"):\n",
    "    name = input(\"Please enter part of the name of the company: \")\n",
    "    if your_choice == \"AMEX\":\n",
    "        print (AMEX[AMEX.Name.str.contains(name)])\n",
    "    if your_choice == \"NYSE\":\n",
    "        print (NYSE[NYSE.Name.str.contains(name)])\n",
    "    if your_choice == \"NASDAQ\":\n",
    "        print (NASDAQ[NASDAQ.str.contains(name)])\n",
    "if (option == \"3\"):\n",
    "    sector = input (\"Please enter the sector: \")\n",
    "    if your_choice == \"AMEX\":\n",
    "        print (AMEX[AMEX.Sector == sector])\n",
    "    if your_choice == \"NYSE\":\n",
    "        print (NYSE[NYSE.Sector == sector])\n",
    "    if your_choice == \"NASDAQ\":\n",
    "        print (NASDAQ[NASDAQ.Sector == sector])\n",
    "if (option == \"4\"):\n",
    "    industry = input (\"Please enter the industry: \")\n",
    "    if your_choice == \"AMEX\":\n",
    "        print (AMEX[AMEX.Industry == industry])\n",
    "    if your_choice == \"NYSE\":\n",
    "        print (NYSE[NYSE.Industry == industry])\n",
    "    if your_choice == \"NASDAQ\":\n",
    "        print (NASDAQ[NASDAQ.Industry == industry])\n",
    "if (option == \"5\"):\n",
    "    if your_choice == \"AMEX\":\n",
    "        hist = input(\"Please input the Symbol: \")\n",
    "        url = \"https://www.quandl.com/api/v3/datasets/WIKI/\"+hist+\".csv?start_date=2018-02-01\"\n",
    "        print(url)\n",
    "        try:\n",
    "            hist_df = pd.read_csv(urlopen(url))\n",
    "            print (\"\\n------------- Historical value for \" + hist+ \" -------------------\")\n",
    "            display(hist_df[[\"Date\", \"Open\", \"High\", \"Low\", \"Close\"]])\n",
    "        except:\n",
    "            print (\"Error with the symbol: \" + hist)\n",
    "    if your_choice == \"NYSE\":\n",
    "        hist = input(\"Please input the Symbol: \")\n",
    "        url = \"https://www.quandl.com/api/v3/datasets/WIKI/\"+hist+\".csv?start_date=2018-02-01\"\n",
    "        print(url)\n",
    "        try:\n",
    "            hist_df = pd.read_csv(urlopen(url))\n",
    "            print (\"\\n------------- Historical value for \" + hist+ \" -------------------\")\n",
    "            display(hist_df[[\"Date\", \"Open\", \"High\", \"Low\", \"Close\"]])\n",
    "        except:\n",
    "            print (\"Error with the symbol: \" + hist)\n",
    "    if your_choice == \"NASDAQ\":\n",
    "        hist = input(\"Please input the Symbol: \")\n",
    "        url = \"https://www.quandl.com/api/v3/datasets/WIKI/\"+hist+\".csv?start_date=2018-02-01\"\n",
    "        print(url)\n",
    "        try:\n",
    "            hist_df = pd.read_csv(urlopen(url))\n",
    "            print (\"\\n------------- Historical value for \" + hist+ \" -------------------\")\n",
    "            display(hist_df[[\"Date\", \"Open\", \"High\", \"Low\", \"Close\"]])\n",
    "        except:\n",
    "            print (\"Error with the symbol: \" + hist)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}