Math_proj2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Math_proj2.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyO/izvIbDpZ5COp7yA2zAMA",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/Harikrishna-AL/MathProject/blob/main/Math_proj2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "id": "hKVZ9JMXGB4g"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import math\n",
        "from scipy import stats\n",
        "import requests"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "stocks = pd.read_csv(\"sp_500_stocks.csv\")\n",
        "IEX_CLOUD_API_TOKEN = 'Tpk_059b97af715d417d9f49f50b51b1c448'"
      ],
      "metadata": {
        "id": "9RLpYtcWGVlP"
      },
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def chunks(lst, n):\n",
        "  for i in range(0, len(lst),n):\n",
        "    yield lst[i:i+n]\n",
        "\n",
        "symbol_groups = list(chunks(stocks['Ticker'], 100))\n",
        "symbol_strings = []\n",
        "for i in range(0,len(symbol_groups)):\n",
        "  symbol_strings.append(','.join(symbol_groups[i]))\n",
        "\n",
        "my_columns = ['Tinker', 'Price', 'Price-to-Earnings Ratio', 'Number of Shares to Buy']\n",
        "print(symbol_strings)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pNFYE0jgGxjD",
        "outputId": "3b863956-4f4d-44e4-bbbf-cd0c49d98e32"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "['A,AAL,AAP,AAPL,ABBV,ABC,ABMD,ABT,ACN,ADBE,ADI,ADM,ADP,ADSK,AEE,AEP,AES,AFL,AIG,AIV,AIZ,AJG,AKAM,ALB,ALGN,ALK,ALL,ALLE,ALXN,AMAT,AMCR,AMD,AME,AMGN,AMP,AMT,AMZN,ANET,ANSS,ANTM,AON,AOS,APA,APD,APH,APTV,ARE,ATO,ATVI,AVB,AVGO,AVY,AWK,AXP,AZO,BA,BAC,BAX,BBY,BDX,BEN,BF.B,BIIB,BIO,BK,BKNG,BKR,BLK,BLL,BMY,BR,BRK.B,BSX,BWA,BXP,C,CAG,CAH,CARR,CAT,CB,CBOE,CBRE,CCI,CCL,CDNS,CDW,CE,CERN,CF,CFG,CHD,CHRW,CHTR,CI,CINF,CL,CLX,CMA,CMCSA', 'CME,CMG,CMI,CMS,CNC,CNP,COF,COG,COO,COP,COST,COTY,CPB,CPRT,CRM,CSCO,CSX,CTAS,CTL,CTSH,CTVA,CTXS,CVS,CVX,CXO,D,DAL,DD,DE,DFS,DG,DGX,DHI,DHR,DIS,DISCA,DISCK,DISH,DLR,DLTR,DOV,DOW,DPZ,DRE,DRI,DTE,DUK,DVA,DVN,DXC,DXCM,EA,EBAY,ECL,ED,EFX,EIX,EL,EMN,EMR,EOG,EQIX,EQR,ES,ESS,ETFC,ETN,ETR,EVRG,EW,EXC,EXPD,EXPE,EXR,F,FANG,FAST,FB,FBHS,FCX,FDX,FE,FFIV,FIS,FISV,FITB,FLIR,FLS,FLT,FMC,FOX,FOXA,FRC,FRT,FTI,FTNT,FTV,GD,GE,GILD', 'GIS,GL,GLW,GM,GOOG,GOOGL,GPC,GPN,GPS,GRMN,GS,GWW,HAL,HAS,HBAN,HBI,HCA,HD,HES,HFC,HIG,HII,HLT,HOLX,HON,HPE,HPQ,HRB,HRL,HSIC,HST,HSY,HUM,HWM,IBM,ICE,IDXX,IEX,IFF,ILMN,INCY,INFO,INTC,INTU,IP,IPG,IPGP,IQV,IR,IRM,ISRG,IT,ITW,IVZ,J,JBHT,JCI,JKHY,JNJ,JNPR,JPM,K,KEY,KEYS,KHC,KIM,KLAC,KMB,KMI,KMX,KO,KR,KSS,KSU,L,LB,LDOS,LEG,LEN,LH,LHX,LIN,LKQ,LLY,LMT,LNC,LNT,LOW,LRCX,LUV,LVS,LW,LYB,LYV,MA,MAA,MAR,MAS,MCD,MCHP', 'MCK,MCO,MDLZ,MDT,MET,MGM,MHK,MKC,MKTX,MLM,MMC,MMM,MNST,MO,MOS,MPC,MRK,MRO,MS,MSCI,MSFT,MSI,MTB,MTD,MU,MXIM,MYL,NBL,NCLH,NDAQ,NEE,NEM,NFLX,NI,NKE,NLOK,NLSN,NOC,NOV,NOW,NRG,NSC,NTAP,NTRS,NUE,NVDA,NVR,NWL,NWS,NWSA,O,ODFL,OKE,OMC,ORCL,ORLY,OTIS,OXY,PAYC,PAYX,PBCT,PCAR,PEAK,PEG,PEP,PFE,PFG,PG,PGR,PH,PHM,PKG,PKI,PLD,PM,PNC,PNR,PNW,PPG,PPL,PRGO,PRU,PSA,PSX,PVH,PWR,PXD,PYPL,QCOM,QRVO,RCL,RE,REG,REGN,RF,RHI,RJF,RL,RMD,ROK', 'ROL,ROP,ROST,RSG,RTX,SBAC,SBUX,SCHW,SEE,SHW,SIVB,SJM,SLB,SLG,SNA,SNPS,SO,SPG,SPGI,SRE,STE,STT,STX,STZ,SWK,SWKS,SYF,SYK,SYY,T,TAP,TDG,TDY,TEL,TFC,TFX,TGT,TIF,TJX,TMO,TMUS,TPR,TROW,TRV,TSCO,TSN,TT,TTWO,TWTR,TXN,TXT,TYL,UA,UAA,UAL,UDR,UHS,ULTA,UNH,UNM,UNP,UPS,URI,USB,V,VAR,VFC,VIAC,VLO,VMC,VNO,VRSK,VRSN,VRTX,VTR,VZ,WAB,WAT,WBA,WDC,WEC,WELL,WFC,WHR,WM,WMB,WMT,WRB,WRK,WST,WU,WY,WYNN,XEL,XLNX,XOM,XRAY,XRX,XYL,YUM', 'ZBH,ZBRA,ZION,ZTS']\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "final_dataframe = pd.DataFrame(columns = my_columns)\n",
        "\n",
        "for symbol_string in symbol_strings:\n",
        "  batch_api = f'https://sandbox.iexapis.com/stable/stock/market/batch/?types=quote&symbols={symbol_string}&token={IEX_CLOUD_API_TOKEN}'\n",
        "  response = requests.get(batch_api)\n",
        "  response.raise_for_status()\n",
        "  if response.status_code != 204:\n",
        "    data = response.json()\n",
        "  for symbol in symbol_string.split(','):\n",
        "    final_dataframe = final_dataframe.append(\n",
        "        pd.Series([symbol,data[symbol]['quote']['latestPrice'],data[symbol]['quote']['peRatio'],'N/A'],index = my_columns),ignore_index = True)\n",
        "    \n",
        "final_dataframe\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 424
        },
        "id": "nePK47dlHyxd",
        "outputId": "8b0e4486-6399-4a15-97e2-2c3c241aba92"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-13d377c8-4d1c-489f-8a15-193c6e098ad7\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Tinker</th>\n",
              "      <th>Price</th>\n",
              "      <th>Price-to-Earnings Ratio</th>\n",
              "      <th>Number of Shares to Buy</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>A</td>\n",
              "      <td>142.77</td>\n",
              "      <td>17.97</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>AAL</td>\n",
              "      <td>16.90</td>\n",
              "      <td>-3.38</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>AAP</td>\n",
              "      <td>227.24</td>\n",
              "      <td>23.66</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>AAPL</td>\n",
              "      <td>167.75</td>\n",
              "      <td>15.06</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ABBV</td>\n",
              "      <td>132.48</td>\n",
              "      <td>31.6</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>499</th>\n",
              "      <td>YUM</td>\n",
              "      <td>126.58</td>\n",
              "      <td>24.72</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>500</th>\n",
              "      <td>ZBH</td>\n",
              "      <td>125.19</td>\n",
              "      <td>32.08</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>501</th>\n",
              "      <td>ZBRA</td>\n",
              "      <td>501.54</td>\n",
              "      <td>32.32</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>502</th>\n",
              "      <td>ZION</td>\n",
              "      <td>63.40</td>\n",
              "      <td>6.11</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>503</th>\n",
              "      <td>ZTS</td>\n",
              "      <td>209.24</td>\n",
              "      <td>49.37</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>504 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-13d377c8-4d1c-489f-8a15-193c6e098ad7')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-13d377c8-4d1c-489f-8a15-193c6e098ad7 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-13d377c8-4d1c-489f-8a15-193c6e098ad7');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "    Tinker   Price Price-to-Earnings Ratio Number of Shares to Buy\n",
              "0        A  142.77                   17.97                     N/A\n",
              "1      AAL   16.90                   -3.38                     N/A\n",
              "2      AAP  227.24                   23.66                     N/A\n",
              "3     AAPL  167.75                   15.06                     N/A\n",
              "4     ABBV  132.48                    31.6                     N/A\n",
              "..     ...     ...                     ...                     ...\n",
              "499    YUM  126.58                   24.72                     N/A\n",
              "500    ZBH  125.19                   32.08                     N/A\n",
              "501   ZBRA  501.54                   32.32                     N/A\n",
              "502   ZION   63.40                    6.11                     N/A\n",
              "503    ZTS  209.24                   49.37                     N/A\n",
              "\n",
              "[504 rows x 4 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "final_dataframe.sort_values('Price-to-Earnings Ratio', inplace = True)\n",
        "final_dataframe = final_dataframe[final_dataframe['Price-to-Earnings Ratio'] > 0]\n",
        "final_dataframe = final_dataframe[:50]\n",
        "final_dataframe.reset_index(inplace = True)\n",
        "final_dataframe.drop('index', axis=1, inplace = True)\n",
        "final_dataframe"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "EX6jjgmIXuc_",
        "outputId": "1958cccf-9fa7-4c15-edf2-44d0b3a300d5"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-05b994b7-9038-4660-9639-6ec848c62785\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Tinker</th>\n",
              "      <th>Price</th>\n",
              "      <th>Price-to-Earnings Ratio</th>\n",
              "      <th>Number of Shares to Buy</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>BIO</td>\n",
              "      <td>598.80</td>\n",
              "      <td>2.69</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>HPE</td>\n",
              "      <td>16.28</td>\n",
              "      <td>3.14</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>EBAY</td>\n",
              "      <td>60.93</td>\n",
              "      <td>3.38</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>HPQ</td>\n",
              "      <td>36.34</td>\n",
              "      <td>3.41</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>COO</td>\n",
              "      <td>401.40</td>\n",
              "      <td>3.42</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>NRG</td>\n",
              "      <td>40.12</td>\n",
              "      <td>4.01</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>DHI</td>\n",
              "      <td>90.88</td>\n",
              "      <td>4.03</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>BEN</td>\n",
              "      <td>32.59</td>\n",
              "      <td>4.47</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>HOLX</td>\n",
              "      <td>70.88</td>\n",
              "      <td>5</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>MPC</td>\n",
              "      <td>73.20</td>\n",
              "      <td>5.05</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>TSN</td>\n",
              "      <td>91.63</td>\n",
              "      <td>5.42</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>USB</td>\n",
              "      <td>57.50</td>\n",
              "      <td>5.5</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>COF</td>\n",
              "      <td>149.58</td>\n",
              "      <td>5.55</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>LYB</td>\n",
              "      <td>95.82</td>\n",
              "      <td>5.67</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>GS</td>\n",
              "      <td>359.57</td>\n",
              "      <td>5.77</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>NUE</td>\n",
              "      <td>95.78</td>\n",
              "      <td>5.86</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>ZION</td>\n",
              "      <td>63.40</td>\n",
              "      <td>6.11</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>PRU</td>\n",
              "      <td>110.66</td>\n",
              "      <td>6.13</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>VIAC</td>\n",
              "      <td>32.77</td>\n",
              "      <td>6.16</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>SYF</td>\n",
              "      <td>46.58</td>\n",
              "      <td>6.32</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>C</td>\n",
              "      <td>65.67</td>\n",
              "      <td>6.4</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>BAC</td>\n",
              "      <td>45.01</td>\n",
              "      <td>6.46</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>WHR</td>\n",
              "      <td>203.81</td>\n",
              "      <td>6.52</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>CE</td>\n",
              "      <td>168.28</td>\n",
              "      <td>6.67</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>AIZ</td>\n",
              "      <td>153.40</td>\n",
              "      <td>6.87</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>UNM</td>\n",
              "      <td>26.60</td>\n",
              "      <td>6.88</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>WRK</td>\n",
              "      <td>45.10</td>\n",
              "      <td>7</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>DFS</td>\n",
              "      <td>116.29</td>\n",
              "      <td>7.01</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>DD</td>\n",
              "      <td>81.05</td>\n",
              "      <td>7.18</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>GM</td>\n",
              "      <td>55.33</td>\n",
              "      <td>7.2</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>WBA</td>\n",
              "      <td>54.90</td>\n",
              "      <td>7.26</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>CINF</td>\n",
              "      <td>115.29</td>\n",
              "      <td>7.44</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>LEN</td>\n",
              "      <td>96.38</td>\n",
              "      <td>7.45</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>KSS</td>\n",
              "      <td>47.92</td>\n",
              "      <td>7.59</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>DOW</td>\n",
              "      <td>58.83</td>\n",
              "      <td>7.61</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>DISH</td>\n",
              "      <td>32.69</td>\n",
              "      <td>7.65</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>RJF</td>\n",
              "      <td>102.08</td>\n",
              "      <td>7.8</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>SWKS</td>\n",
              "      <td>145.60</td>\n",
              "      <td>7.8</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>PHM</td>\n",
              "      <td>53.45</td>\n",
              "      <td>8.34</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>RF</td>\n",
              "      <td>22.20</td>\n",
              "      <td>8.36</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>SLG</td>\n",
              "      <td>74.26</td>\n",
              "      <td>8.63</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>DGX</td>\n",
              "      <td>140.10</td>\n",
              "      <td>8.63</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>MOS</td>\n",
              "      <td>39.69</td>\n",
              "      <td>8.63</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>IVZ</td>\n",
              "      <td>22.27</td>\n",
              "      <td>8.76</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>NLSN</td>\n",
              "      <td>19.74</td>\n",
              "      <td>8.94</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>AIG</td>\n",
              "      <td>57.74</td>\n",
              "      <td>9.09</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>ABC</td>\n",
              "      <td>136.97</td>\n",
              "      <td>9.3</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>WU</td>\n",
              "      <td>18.94</td>\n",
              "      <td>9.3</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>JPM</td>\n",
              "      <td>146.37</td>\n",
              "      <td>9.45</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>L</td>\n",
              "      <td>58.57</td>\n",
              "      <td>9.54</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-05b994b7-9038-4660-9639-6ec848c62785')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-05b994b7-9038-4660-9639-6ec848c62785 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-05b994b7-9038-4660-9639-6ec848c62785');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "   Tinker   Price Price-to-Earnings Ratio Number of Shares to Buy\n",
              "0     BIO  598.80                    2.69                     N/A\n",
              "1     HPE   16.28                    3.14                     N/A\n",
              "2    EBAY   60.93                    3.38                     N/A\n",
              "3     HPQ   36.34                    3.41                     N/A\n",
              "4     COO  401.40                    3.42                     N/A\n",
              "5     NRG   40.12                    4.01                     N/A\n",
              "6     DHI   90.88                    4.03                     N/A\n",
              "7     BEN   32.59                    4.47                     N/A\n",
              "8    HOLX   70.88                       5                     N/A\n",
              "9     MPC   73.20                    5.05                     N/A\n",
              "10    TSN   91.63                    5.42                     N/A\n",
              "11    USB   57.50                     5.5                     N/A\n",
              "12    COF  149.58                    5.55                     N/A\n",
              "13    LYB   95.82                    5.67                     N/A\n",
              "14     GS  359.57                    5.77                     N/A\n",
              "15    NUE   95.78                    5.86                     N/A\n",
              "16   ZION   63.40                    6.11                     N/A\n",
              "17    PRU  110.66                    6.13                     N/A\n",
              "18   VIAC   32.77                    6.16                     N/A\n",
              "19    SYF   46.58                    6.32                     N/A\n",
              "20      C   65.67                     6.4                     N/A\n",
              "21    BAC   45.01                    6.46                     N/A\n",
              "22    WHR  203.81                    6.52                     N/A\n",
              "23     CE  168.28                    6.67                     N/A\n",
              "24    AIZ  153.40                    6.87                     N/A\n",
              "25    UNM   26.60                    6.88                     N/A\n",
              "26    WRK   45.10                       7                     N/A\n",
              "27    DFS  116.29                    7.01                     N/A\n",
              "28     DD   81.05                    7.18                     N/A\n",
              "29     GM   55.33                     7.2                     N/A\n",
              "30    WBA   54.90                    7.26                     N/A\n",
              "31   CINF  115.29                    7.44                     N/A\n",
              "32    LEN   96.38                    7.45                     N/A\n",
              "33    KSS   47.92                    7.59                     N/A\n",
              "34    DOW   58.83                    7.61                     N/A\n",
              "35   DISH   32.69                    7.65                     N/A\n",
              "36    RJF  102.08                     7.8                     N/A\n",
              "37   SWKS  145.60                     7.8                     N/A\n",
              "38    PHM   53.45                    8.34                     N/A\n",
              "39     RF   22.20                    8.36                     N/A\n",
              "40    SLG   74.26                    8.63                     N/A\n",
              "41    DGX  140.10                    8.63                     N/A\n",
              "42    MOS   39.69                    8.63                     N/A\n",
              "43    IVZ   22.27                    8.76                     N/A\n",
              "44   NLSN   19.74                    8.94                     N/A\n",
              "45    AIG   57.74                    9.09                     N/A\n",
              "46    ABC  136.97                     9.3                     N/A\n",
              "47     WU   18.94                     9.3                     N/A\n",
              "48    JPM  146.37                    9.45                     N/A\n",
              "49      L   58.57                    9.54                     N/A"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def portfolio_input():\n",
        "  global portfolio_size\n",
        "  portfolio_size = input(\"Enter the value of your portfolio:\")\n",
        "\n",
        "  try:\n",
        "    val = float(portfolio_size)\n",
        "  except ValueError:\n",
        "    print(\"That's not a number! \\n Try again:\")\n",
        "    portfolio_size = input(\"Enter the value of your portfolio:\")"
      ],
      "metadata": {
        "id": "xywvlbnbU5ek"
      },
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "portfolio_input()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "D-cYrfy8YO6H",
        "outputId": "65b83f0e-67b8-44e8-87cb-ad496a3b825f"
      },
      "execution_count": 9,
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Enter the value of your portfolio:500000\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "position_size = float(portfolio_size)/len(final_dataframe.index)\n",
        "print(position_size)\n",
        "for i in range(0, len(final_dataframe['Tinker'])-1):\n",
        "  final_dataframe.loc[i, 'Number of Shares to Buy'] = math.floor(position_size/final_dataframe['Price'][i])\n",
        "\n",
        "final_dataframe"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "-2IkReC6VX95",
        "outputId": "8a72bab5-376c-4b56-f807-ff10b722ccf9"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "10000.0\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "  <div id=\"df-c4da2916-6646-471d-a2e7-3598692824bd\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <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>Tinker</th>\n",
              "      <th>Price</th>\n",
              "      <th>Price-to-Earnings Ratio</th>\n",
              "      <th>Number of Shares to Buy</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>BIO</td>\n",
              "      <td>598.80</td>\n",
              "      <td>2.69</td>\n",
              "      <td>16</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>HPE</td>\n",
              "      <td>16.28</td>\n",
              "      <td>3.14</td>\n",
              "      <td>614</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>EBAY</td>\n",
              "      <td>60.93</td>\n",
              "      <td>3.38</td>\n",
              "      <td>164</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>HPQ</td>\n",
              "      <td>36.34</td>\n",
              "      <td>3.41</td>\n",
              "      <td>275</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>COO</td>\n",
              "      <td>401.40</td>\n",
              "      <td>3.42</td>\n",
              "      <td>24</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>NRG</td>\n",
              "      <td>40.12</td>\n",
              "      <td>4.01</td>\n",
              "      <td>249</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>DHI</td>\n",
              "      <td>90.88</td>\n",
              "      <td>4.03</td>\n",
              "      <td>110</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>BEN</td>\n",
              "      <td>32.59</td>\n",
              "      <td>4.47</td>\n",
              "      <td>306</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>HOLX</td>\n",
              "      <td>70.88</td>\n",
              "      <td>5</td>\n",
              "      <td>141</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>MPC</td>\n",
              "      <td>73.20</td>\n",
              "      <td>5.05</td>\n",
              "      <td>136</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>TSN</td>\n",
              "      <td>91.63</td>\n",
              "      <td>5.42</td>\n",
              "      <td>109</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>USB</td>\n",
              "      <td>57.50</td>\n",
              "      <td>5.5</td>\n",
              "      <td>173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>COF</td>\n",
              "      <td>149.58</td>\n",
              "      <td>5.55</td>\n",
              "      <td>66</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>LYB</td>\n",
              "      <td>95.82</td>\n",
              "      <td>5.67</td>\n",
              "      <td>104</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>GS</td>\n",
              "      <td>359.57</td>\n",
              "      <td>5.77</td>\n",
              "      <td>27</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>NUE</td>\n",
              "      <td>95.78</td>\n",
              "      <td>5.86</td>\n",
              "      <td>104</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>ZION</td>\n",
              "      <td>63.40</td>\n",
              "      <td>6.11</td>\n",
              "      <td>157</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>PRU</td>\n",
              "      <td>110.66</td>\n",
              "      <td>6.13</td>\n",
              "      <td>90</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>VIAC</td>\n",
              "      <td>32.77</td>\n",
              "      <td>6.16</td>\n",
              "      <td>305</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>SYF</td>\n",
              "      <td>46.58</td>\n",
              "      <td>6.32</td>\n",
              "      <td>214</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>C</td>\n",
              "      <td>65.67</td>\n",
              "      <td>6.4</td>\n",
              "      <td>152</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>BAC</td>\n",
              "      <td>45.01</td>\n",
              "      <td>6.46</td>\n",
              "      <td>222</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>WHR</td>\n",
              "      <td>203.81</td>\n",
              "      <td>6.52</td>\n",
              "      <td>49</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>CE</td>\n",
              "      <td>168.28</td>\n",
              "      <td>6.67</td>\n",
              "      <td>59</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>AIZ</td>\n",
              "      <td>153.40</td>\n",
              "      <td>6.87</td>\n",
              "      <td>65</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>UNM</td>\n",
              "      <td>26.60</td>\n",
              "      <td>6.88</td>\n",
              "      <td>375</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>WRK</td>\n",
              "      <td>45.10</td>\n",
              "      <td>7</td>\n",
              "      <td>221</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>DFS</td>\n",
              "      <td>116.29</td>\n",
              "      <td>7.01</td>\n",
              "      <td>85</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>DD</td>\n",
              "      <td>81.05</td>\n",
              "      <td>7.18</td>\n",
              "      <td>123</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>GM</td>\n",
              "      <td>55.33</td>\n",
              "      <td>7.2</td>\n",
              "      <td>180</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>WBA</td>\n",
              "      <td>54.90</td>\n",
              "      <td>7.26</td>\n",
              "      <td>182</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>CINF</td>\n",
              "      <td>115.29</td>\n",
              "      <td>7.44</td>\n",
              "      <td>86</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>LEN</td>\n",
              "      <td>96.38</td>\n",
              "      <td>7.45</td>\n",
              "      <td>103</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>KSS</td>\n",
              "      <td>47.92</td>\n",
              "      <td>7.59</td>\n",
              "      <td>208</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>DOW</td>\n",
              "      <td>58.83</td>\n",
              "      <td>7.61</td>\n",
              "      <td>169</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>DISH</td>\n",
              "      <td>32.69</td>\n",
              "      <td>7.65</td>\n",
              "      <td>305</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>RJF</td>\n",
              "      <td>102.08</td>\n",
              "      <td>7.8</td>\n",
              "      <td>97</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>SWKS</td>\n",
              "      <td>145.60</td>\n",
              "      <td>7.8</td>\n",
              "      <td>68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>PHM</td>\n",
              "      <td>53.45</td>\n",
              "      <td>8.34</td>\n",
              "      <td>187</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>RF</td>\n",
              "      <td>22.20</td>\n",
              "      <td>8.36</td>\n",
              "      <td>450</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>SLG</td>\n",
              "      <td>74.26</td>\n",
              "      <td>8.63</td>\n",
              "      <td>134</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>DGX</td>\n",
              "      <td>140.10</td>\n",
              "      <td>8.63</td>\n",
              "      <td>71</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>MOS</td>\n",
              "      <td>39.69</td>\n",
              "      <td>8.63</td>\n",
              "      <td>251</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>IVZ</td>\n",
              "      <td>22.27</td>\n",
              "      <td>8.76</td>\n",
              "      <td>449</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>NLSN</td>\n",
              "      <td>19.74</td>\n",
              "      <td>8.94</td>\n",
              "      <td>506</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>AIG</td>\n",
              "      <td>57.74</td>\n",
              "      <td>9.09</td>\n",
              "      <td>173</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>ABC</td>\n",
              "      <td>136.97</td>\n",
              "      <td>9.3</td>\n",
              "      <td>73</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>WU</td>\n",
              "      <td>18.94</td>\n",
              "      <td>9.3</td>\n",
              "      <td>527</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>JPM</td>\n",
              "      <td>146.37</td>\n",
              "      <td>9.45</td>\n",
              "      <td>68</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>L</td>\n",
              "      <td>58.57</td>\n",
              "      <td>9.54</td>\n",
              "      <td>N/A</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c4da2916-6646-471d-a2e7-3598692824bd')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c4da2916-6646-471d-a2e7-3598692824bd button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c4da2916-6646-471d-a2e7-3598692824bd');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ],
            "text/plain": [
              "   Tinker   Price Price-to-Earnings Ratio Number of Shares to Buy\n",
              "0     BIO  598.80                    2.69                      16\n",
              "1     HPE   16.28                    3.14                     614\n",
              "2    EBAY   60.93                    3.38                     164\n",
              "3     HPQ   36.34                    3.41                     275\n",
              "4     COO  401.40                    3.42                      24\n",
              "5     NRG   40.12                    4.01                     249\n",
              "6     DHI   90.88                    4.03                     110\n",
              "7     BEN   32.59                    4.47                     306\n",
              "8    HOLX   70.88                       5                     141\n",
              "9     MPC   73.20                    5.05                     136\n",
              "10    TSN   91.63                    5.42                     109\n",
              "11    USB   57.50                     5.5                     173\n",
              "12    COF  149.58                    5.55                      66\n",
              "13    LYB   95.82                    5.67                     104\n",
              "14     GS  359.57                    5.77                      27\n",
              "15    NUE   95.78                    5.86                     104\n",
              "16   ZION   63.40                    6.11                     157\n",
              "17    PRU  110.66                    6.13                      90\n",
              "18   VIAC   32.77                    6.16                     305\n",
              "19    SYF   46.58                    6.32                     214\n",
              "20      C   65.67                     6.4                     152\n",
              "21    BAC   45.01                    6.46                     222\n",
              "22    WHR  203.81                    6.52                      49\n",
              "23     CE  168.28                    6.67                      59\n",
              "24    AIZ  153.40                    6.87                      65\n",
              "25    UNM   26.60                    6.88                     375\n",
              "26    WRK   45.10                       7                     221\n",
              "27    DFS  116.29                    7.01                      85\n",
              "28     DD   81.05                    7.18                     123\n",
              "29     GM   55.33                     7.2                     180\n",
              "30    WBA   54.90                    7.26                     182\n",
              "31   CINF  115.29                    7.44                      86\n",
              "32    LEN   96.38                    7.45                     103\n",
              "33    KSS   47.92                    7.59                     208\n",
              "34    DOW   58.83                    7.61                     169\n",
              "35   DISH   32.69                    7.65                     305\n",
              "36    RJF  102.08                     7.8                      97\n",
              "37   SWKS  145.60                     7.8                      68\n",
              "38    PHM   53.45                    8.34                     187\n",
              "39     RF   22.20                    8.36                     450\n",
              "40    SLG   74.26                    8.63                     134\n",
              "41    DGX  140.10                    8.63                      71\n",
              "42    MOS   39.69                    8.63                     251\n",
              "43    IVZ   22.27                    8.76                     449\n",
              "44   NLSN   19.74                    8.94                     506\n",
              "45    AIG   57.74                    9.09                     173\n",
              "46    ABC  136.97                     9.3                      73\n",
              "47     WU   18.94                     9.3                     527\n",
              "48    JPM  146.37                    9.45                      68\n",
              "49      L   58.57                    9.54                     N/A"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    }
  ]
}