beautiful soup.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "from urllib.request import urlopen as uReq\n",
    "import urllib.request\n",
    "from bs4 import BeautifulSoup as soup\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import pickle\n",
    "from datetime import datetime, timedelta, date\n",
    "import csv\n",
    "import re\n",
    "import os\n",
    "\n",
    "my_url = 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings'\n",
    "# uClient = uReq(my_url)\n",
    "# page_html = uClient.read()\n",
    "# uClient.close()\n",
    "# page_soup = soup(page_html, \"html.parser\")\n",
    "# containers = page_soup.find_all(\"div\",{\"class\":\"genTable\"})\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# container = containers[0].get_text().split(\"\\n\")\n",
    "# container1= list(filter(None, container))\n",
    "\n",
    "# # if container=['\\r', '\\t\\t\\t\\tThere is no data for this month, please select a prior month.\\r', '\\t\\t\\t']:\n",
    "# #     print(\"\")\n",
    "# # else:\n",
    "# container1 = np.array(container1).reshape(-1,7)\n",
    "# container2= pd.DataFrame(container1)\n",
    "# df2 = container2.iloc[1:]\n",
    "# df2 = df2.rename(columns=container2.iloc[0])\n",
    "# df2.to_csv(ipodata.csv)\n",
    "\n",
    "        \n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-07',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-08',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-09',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-10',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-11',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2016-12',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-01',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-02',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-03',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-04',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-05',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-06',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-07',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-08',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-09',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-10',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-11',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2017-12',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2018-01',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings&month=2018-02',\n",
       " 'http://www.nasdaq.com/markets/ipos/activity.aspx?tab=pricings']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#creating backwards time list\n",
    "datelist = pd.date_range(end=pd.datetime.today(), periods=20, freq='M', normalize=bool)\n",
    "datelist = datelist.strftime('%Y-%m').tolist()\n",
    "string1= \"&month=\"\n",
    "myurls=[]\n",
    "for x in datelist:\n",
    "    myurls.append(my_url+string1+str(x))\n",
    "myurls.append(my_url)\n",
    "myurls\n"
   ]
  },


  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def make_soup(url):\n",
    "    thepage=urllib.request.urlopen(url)\n",
    "    soupdata=soup(thepage,\"html.parser\")\n",
    "    return soupdata\n",
    "playerdatasaved=\"\"\n",
    "for eachurl in myurls : \n",
    "    soup1= make_soup(eachurl)\n",
    "    for record in soup1.findAll(\"div\",{\"class\":\"genTable\"})[:1]:\n",
    "        if record==['\\r', '\\t\\t\\t\\tThere is no data for this month, please select a prior month.\\r', '\\t\\t\\t']:\n",
    "            continue\n",
    "        else:\n",
    "            playerdata=\"\"\n",
    "            for data in record.findAll('tr')[1:]:\n",
    "                playerdata=playerdata+data.text\n",
    "            playerdatasaved=playerdatasaved+\"\\n\"+playerdata[1:]\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "playerdatasaved2= playerdatasaved.split(\"\\n\")\n",
    "playerdatasaved3= list(filter(None,playerdatasaved2))\n",
    "playerdatasaved3= np.asarray(playerdatasaved3)\n",
    "playerdatasaved3=playerdatasaved3.reshape(-1,7)[1:]\n",
    "df6= pd.DataFrame(playerdatasaved3, columns=(\"company_name\", \"symbol\",\" market\", \"price\", 'shares', 'offer_amount', 'date_priced'))\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# file= open(os.path.expanduser(\"ipodata3.csv\"),\"wb\")\n",
    "# file.write(bytes(headers,encoding=\"ascii\",errors=\"ignore\"))\n",
    "# file.write(bytes(,encoding=\"ascii\",errors=\"ignore\"))  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df7=df6.drop(df6.columns[[0, 2, 3,4,5]], axis=1) \n",
    "\n",
    "df7['date_priced'] = pd.to_datetime(df7['date_priced'])\n",
    "df7['date_priced']= df7['date_priced'] + pd.DateOffset(days=180)\n",
    "df7['signal']=1\n",
    "df7.to_csv(\"ipodata5.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\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>date_priced</th>\n",
       "      <th>signal</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LTEA</td>\n",
       "      <td>2017-01-25</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>TLND</td>\n",
       "      <td>2017-01-25</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>TCMD</td>\n",
       "      <td>2017-01-24</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>KNSL</td>\n",
       "      <td>2017-01-24</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>KDMN</td>\n",
       "      <td>2017-01-23</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TPIC</td>\n",
       "      <td>2017-01-18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>PI</td>\n",
       "      <td>2017-01-17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>PTHN</td>\n",
       "      <td>2017-01-17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BOLD</td>\n",
       "      <td>2017-01-16</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CPAAU</td>\n",
       "      <td>2017-01-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>APFH</td>\n",
       "      <td>2017-01-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>LN</td>\n",
       "      <td>2017-01-10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MSDI</td>\n",
       "      <td>2017-01-04</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>MIIIU</td>\n",
       "      <td>2017-01-03</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>STLRU</td>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AIRG</td>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>MEDP</td>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PTGX</td>\n",
       "      <td>2017-02-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ATMR</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>GEMP</td>\n",
       "      <td>2017-02-01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HOME</td>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>FHB</td>\n",
       "      <td>2017-01-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NTNX</td>\n",
       "      <td>2017-03-29</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>TRHC</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>MRT</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>FLGT</td>\n",
       "      <td>2017-03-28</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>TYHT</td>\n",
       "      <td>2017-03-27</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>VVV</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>GSUM</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ACIU</td>\n",
       "      <td>2017-03-22</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>ADT</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>COLD</td>\n",
       "      <td>2018-07-18</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>OMADU</td>\n",
       "      <td>2018-07-17</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>EAGLU</td>\n",
       "      <td>2018-07-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>ILPT</td>\n",
       "      <td>2018-07-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>LBRT</td>\n",
       "      <td>2018-07-11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>NEBUU</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>CUE</td>\n",
       "      <td>2018-07-01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>LTN'U</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>DFBHU</td>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>FAMI</td>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>BFRA</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>MOTS</td>\n",
       "      <td>2018-08-13</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>LHC'U</td>\n",
       "      <td>2018-08-12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>QES</td>\n",
       "      <td>2018-08-08</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>CDLX</td>\n",
       "      <td>2018-08-08</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>EOLS</td>\n",
       "      <td>2018-08-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>HMI</td>\n",
       "      <td>2018-08-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>MUDSU</td>\n",
       "      <td>2018-08-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>VCTR</td>\n",
       "      <td>2018-08-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>WHD</td>\n",
       "      <td>2018-08-07</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>SSLJ</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>FTSI</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>CEPU</td>\n",
       "      <td>2018-08-01</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>CAAP</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>OSS</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>HUD</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>IPIC</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>SLGL</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>VICI</td>\n",
       "      <td>2018-07-31</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>328 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    symbol date_priced  signal\n",
       "0     LTEA  2017-01-25       1\n",
       "1     TLND  2017-01-25       1\n",
       "2     TCMD  2017-01-24       1\n",
       "3     KNSL  2017-01-24       1\n",
       "4     KDMN  2017-01-23       1\n",
       "5     TPIC  2017-01-18       1\n",
       "6       PI  2017-01-17       1\n",
       "7     PTHN  2017-01-17       1\n",
       "8     BOLD  2017-01-16       1\n",
       "9    CPAAU  2017-01-11       1\n",
       "10    APFH  2017-01-11       1\n",
       "11      LN  2017-01-10       1\n",
       "12    MSDI  2017-01-04       1\n",
       "13   MIIIU  2017-01-03       1\n",
       "14   STLRU  2017-02-15       1\n",
       "15    AIRG  2017-02-08       1\n",
       "16    MEDP  2017-02-07       1\n",
       "17    PTGX  2017-02-07       1\n",
       "18    ATMR  2017-02-01       1\n",
       "19    GEMP  2017-02-01       1\n",
       "20    HOME  2017-01-31       1\n",
       "21     FHB  2017-01-31       1\n",
       "22    NTNX  2017-03-29       1\n",
       "23    TRHC  2017-03-28       1\n",
       "24     MRT  2017-03-28       1\n",
       "25    FLGT  2017-03-28       1\n",
       "26    TYHT  2017-03-27       1\n",
       "27     VVV  2017-03-22       1\n",
       "28    GSUM  2017-03-22       1\n",
       "29    ACIU  2017-03-22       1\n",
       "..     ...         ...     ...\n",
       "298    ADT  2018-07-18       1\n",
       "299   COLD  2018-07-18       1\n",
       "300  OMADU  2018-07-17       1\n",
       "301  EAGLU  2018-07-11       1\n",
       "302   ILPT  2018-07-11       1\n",
       "303   LBRT  2018-07-11       1\n",
       "304  NEBUU  2018-07-09       1\n",
       "305    CUE  2018-07-01       1\n",
       "306  LTN'U  2018-08-27       1\n",
       "307  DFBHU  2018-08-15       1\n",
       "308   FAMI  2018-08-15       1\n",
       "309   BFRA  2018-08-13       1\n",
       "310   MOTS  2018-08-13       1\n",
       "311  LHC'U  2018-08-12       1\n",
       "312    QES  2018-08-08       1\n",
       "313   CDLX  2018-08-08       1\n",
       "314   EOLS  2018-08-07       1\n",
       "315    HMI  2018-08-07       1\n",
       "316  MUDSU  2018-08-07       1\n",
       "317   VCTR  2018-08-07       1\n",
       "318    WHD  2018-08-07       1\n",
       "319   SSLJ  2018-08-04       1\n",
       "320   FTSI  2018-08-01       1\n",
       "321   CEPU  2018-08-01       1\n",
       "322   CAAP  2018-07-31       1\n",
       "323    OSS  2018-07-31       1\n",
       "324    HUD  2018-07-31       1\n",
       "325   IPIC  2018-07-31       1\n",
       "326   SLGL  2018-07-31       1\n",
       "327   VICI  2018-07-31       1\n",
       "\n",
       "[328 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df7"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "\n",
    "                                   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}