ML_Training_Pandas_Class2.ipynb

{
 "cells": [
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "Libs used are xlrd, openpyxl (for excel), sqlalchemy (for sql), BeautifulSoup4, lxml and request for (html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"C://Users//ms47807//Documents//Purchase_Agreements__Copy_F.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"C://Users//ms47807//Documents//my_output\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": false
   },
   "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>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "2007/10/07 00:00:00.000000000\u001d",
       "12603042\u001d",
       "56374\u001d",
       "SCOPE TECHNOLOGY CO.</th>\n",
       "      <th>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "USD\u001d",
       "Tang</th>\n",
       "      <th>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-000085\u001d",
       "0402 SMT CAP</th>\n",
       "      <th>1</th>\n",
       "      <th>UF</th>\n",
       "      <th>6.3V</th>\n",
       "      <th>10%</th>\n",
       "      <th>X5R</th>\n",
       "      <th>0402</th>\n",
       "      <th>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Capacitors\u001d",
       "Each\u001d",
       "\u001d",
       "0.00057\u001d",
       "N\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "0\u001d",
       "\u001d",
       "NON CUMULATIVE\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "2007/10/08 00:00:00.000000000\u001d",
       "2025/12/30 00:00:00.000000000\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "2017/11/14 00:00:00.000000000\u001d",
       "2017/10/19 21:33:41.000000000\u001d",
       "2016/05/19 00:53:05.000000000\u001d",
       "N\u001d",
       "\u001d",
       "CL05A105KQ5NNNC/\u001d",
       "5235926\u001d",
       "102\u001d",
       "23\u001d",
       "\u001d",
       "2015/07/01 00:00:00.000000000\u001d",
       "2015/09/30 00:00:00.000000000\u001d",
       "0.00061\u001d",
       "OPEN\u001d",
       "OPEN\u001d",
       "OPEN\u001d",
       "N\u001d",
       "N\u001d",
       "N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>5000117\u001d",
       "5013548\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "151\u001d",
       "20026127\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>LF\u001d",
       "151\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Ca...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5000117\u001d",
       "5013564\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "167\u001d",
       "20029487\u001d",
       "301-0005...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>16V</td>\n",
       "      <td>20%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402\u001d",
       "167\u001d",
       "2015/03/23 03:01:36.000000000\u001d",
       "EE.301\u001d",
       "...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "2007/10/07 00:00:00.000000000\n",
       "12603042\n",
       "56374\n",
       "SCOPE TECHNOLOGY CO.  \\\n",
       "0   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "1   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "2   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "3   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "4   5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "5   5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "6   5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "7   5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "8   5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "9   5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "10  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "11  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "12  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "13  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "14  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "15  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "16  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "17  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "18  5000117\n",
       "5013548\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "19  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "20  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "21  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "22  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "23  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "24  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "25  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "26  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "27  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "28  5000117\n",
       "5013564\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "\n",
       "    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "USD\n",
       "Tang  \\\n",
       "0    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "1    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "2    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "3    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "4    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "5    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "6    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "7    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "8    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "9    LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "10   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "11   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "12   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "13   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "14   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "15   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "16   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "17   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "18   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "19   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "20   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "21   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "22   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "23   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "24   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "25   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "26   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "27   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "28   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "\n",
       "    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-000085\n",
       "0402 SMT CAP    1  UF  \\\n",
       "0    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "1    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "2    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "3    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "4    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "5    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "6    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "7    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "8    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "9    Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "10   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "11   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "12   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "13   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "14   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "15   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "16   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "17   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "18   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "151\n",
       "20026127\n",
       "301-0005...             1.0  UF   \n",
       "19   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "20   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "21   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "22   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "23   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "24   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "25   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "26   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "27   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "28   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "167\n",
       "20029487\n",
       "301-0005...             1.0  UF   \n",
       "\n",
       "    6.3V  10%  X5R                                               0402  \\\n",
       "0   6.3V  10%  X5R                                               0402   \n",
       "1   6.3V  10%  X5R                                               0402   \n",
       "2   6.3V  10%  X5R                                               0402   \n",
       "3   6.3V  10%  X5R                                               0402   \n",
       "4   6.3V  10%  X5R                                               0402   \n",
       "5   6.3V  10%  X5R                                               0402   \n",
       "6   6.3V  10%  X5R                                               0402   \n",
       "7   6.3V  10%  X5R                                               0402   \n",
       "8   6.3V  10%  X5R                                               0402   \n",
       "9   6.3V  10%  X5R                                               0402   \n",
       "10  6.3V  10%  X5R                                               0402   \n",
       "11  6.3V  10%  X5R                                               0402   \n",
       "12  6.3V  10%  X5R                                               0402   \n",
       "13  6.3V  10%  X5R                                               0402   \n",
       "14  6.3V  10%  X5R                                               0402   \n",
       "15  6.3V  10%  X5R                                               0402   \n",
       "16  6.3V  10%  X5R                                               0402   \n",
       "17  6.3V  10%  X5R                                               0402   \n",
       "18  6.3V  10%  X5R                                               0402   \n",
       "19   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "20   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "21   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "22   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "23   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "24   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "25   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "26   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "27   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "28   16V  20%  X5R  0402\n",
       "167\n",
       "2015/03/23 03:01:36.000000000\n",
       "EE.301\n",
       "...   \n",
       "\n",
       "   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Capacitors\n",
       "Each\n",
       "\n",
       "0.00057\n",
       "N\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "0\n",
       "0\n",
       "\n",
       "NON CUMULATIVE\n",
       "\n",
       "\n",
       "\n",
       "2007/10/08 00:00:00.000000000\n",
       "2025/12/30 00:00:00.000000000\n",
       "\n",
       "\n",
       "\n",
       "2017/11/14 00:00:00.000000000\n",
       "2017/10/19 21:33:41.000000000\n",
       "2016/05/19 00:53:05.000000000\n",
       "N\n",
       "\n",
       "CL05A105KQ5NNNC/\n",
       "5235926\n",
       "102\n",
       "23\n",
       "\n",
       "2015/07/01 00:00:00.000000000\n",
       "2015/09/30 00:00:00.000000000\n",
       "0.00061\n",
       "OPEN\n",
       "OPEN\n",
       "OPEN\n",
       "N\n",
       "N\n",
       "N  \n",
       "0   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "1   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "2   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "3   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "4   T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "5   LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "6   LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "7   LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "8   LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "9   LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "10  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "11  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "12  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "13  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "14  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "15  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "16  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "17  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "18  LF\n",
       "151\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Ca...                                                                                                                                                                                                                                                                                                                                             \n",
       "19                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "20                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "21                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "22                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "23                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "24                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "25                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "26                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "27                                                NaN                                                                                                                                                                                                                                                                                                                                             \n",
       "28                                                NaN                                                                                                                                                                                                                                                                                                                                             "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(\"C://Users//ms47807//Documents//my_output\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 =  pd.read_excel(\"sample-file.xlsx\", sheetname=\"Sheet1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_excel(\"excel_output.xlsx\", sheet_name=\"SheetOne\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                                             Bank Name                City  \\\n",
       " 0      The Farmers and Merchants State Bank of Argonia             Argonia   \n",
       " 1                                  Fayette County Bank          Saint Elmo   \n",
       " 2    Guaranty Bank, (d/b/a BestBank in Georgia & Mi...           Milwaukee   \n",
       " 3                                       First NBC Bank         New Orleans   \n",
       " 4                                        Proficio Bank  Cottonwood Heights   \n",
       " 5                        Seaway Bank and Trust Company             Chicago   \n",
       " 6                               Harvest Community Bank          Pennsville   \n",
       " 7                                          Allied Bank            Mulberry   \n",
       " 8                         The Woodbury Banking Company            Woodbury   \n",
       " 9                               First CornerStone Bank     King of Prussia   \n",
       " 10                                  Trust Company Bank             Memphis   \n",
       " 11                          North Milwaukee State Bank           Milwaukee   \n",
       " 12                              Hometown National Bank            Longview   \n",
       " 13                                 The Bank of Georgia      Peachtree City   \n",
       " 14                                        Premier Bank              Denver   \n",
       " 15                                      Edgebrook Bank             Chicago   \n",
       " 16                              Doral Bank  En Espanol            San Juan   \n",
       " 17                   Capitol City Bank & Trust Company             Atlanta   \n",
       " 18                             Highland Community Bank             Chicago   \n",
       " 19                    First National Bank of Crestview           Crestview   \n",
       " 20                                  Northern Star Bank             Mankato   \n",
       " 21              Frontier Bank, FSB D/B/A El Paseo Bank         Palm Desert   \n",
       " 22               The National Republic Bank of Chicago             Chicago   \n",
       " 23                                      NBRS Financial          Rising Sun   \n",
       " 24                               GreenChoice Bank, fsb             Chicago   \n",
       " 25                            Eastside Commercial Bank             Conyers   \n",
       " 26                              The Freedom State Bank             Freedom   \n",
       " 27                                         Valley Bank     Fort Lauderdale   \n",
       " 28                                         Valley Bank              Moline   \n",
       " 29                         Slavie Federal Savings Bank             Bel Air   \n",
       " ..                                                 ...                 ...   \n",
       " 524                                  ANB Financial, NA         Bentonville   \n",
       " 525                                          Hume Bank                Hume   \n",
       " 526                             Douglass National Bank         Kansas City   \n",
       " 527                                  Miami Valley Bank            Lakeview   \n",
       " 528                                            NetBank          Alpharetta   \n",
       " 529                          Metropolitan Savings Bank          Pittsburgh   \n",
       " 530                                    Bank of Ephraim             Ephraim   \n",
       " 531                                      Reliance Bank        White Plains   \n",
       " 532              Guaranty National Bank of Tallahassee         Tallahassee   \n",
       " 533                                Dollar Savings Bank              Newark   \n",
       " 534                               Pulaski Savings Bank        Philadelphia   \n",
       " 535              First National Bank of Blanchardville      Blanchardville   \n",
       " 536                              Southern Pacific Bank            Torrance   \n",
       " 537                        Farmers Bank of Cheneyville         Cheneyville   \n",
       " 538                                      Bank of Alamo               Alamo   \n",
       " 539             AmTrade International Bank  En Espanol             Atlanta   \n",
       " 540                     Universal Federal Savings Bank             Chicago   \n",
       " 541                       Connecticut Bank of Commerce            Stamford   \n",
       " 542                                   New Century Bank     Shelby Township   \n",
       " 543                              Net 1st National Bank          Boca Raton   \n",
       " 544                                       NextBank, NA             Phoenix   \n",
       " 545                           Oakwood Deposit Bank Co.             Oakwood   \n",
       " 546                              Bank of Sierra Blanca       Sierra Blanca   \n",
       " 547                      Hamilton Bank, NA  En Espanol               Miami   \n",
       " 548                             Sinclair National Bank            Gravette   \n",
       " 549                                 Superior Bank, FSB            Hinsdale   \n",
       " 550                                Malta National Bank               Malta   \n",
       " 551                    First Alliance Bank & Trust Co.          Manchester   \n",
       " 552                  National State Bank of Metropolis          Metropolis   \n",
       " 553                                   Bank of Honolulu            Honolulu   \n",
       " \n",
       "      ST   CERT                Acquiring Institution        Closing Date  \\\n",
       " 0    KS  17719                          Conway Bank    October 13, 2017   \n",
       " 1    IL   1802            United Fidelity Bank, fsb        May 26, 2017   \n",
       " 2    WI  30003  First-Citizens Bank & Trust Company         May 5, 2017   \n",
       " 3    LA  58302                         Whitney Bank      April 28, 2017   \n",
       " 4    UT  35495                    Cache Valley Bank       March 3, 2017   \n",
       " 5    IL  19328                  State Bank of Texas    January 27, 2017   \n",
       " 6    NJ  34951  First-Citizens Bank & Trust Company    January 13, 2017   \n",
       " 7    AR     91                         Today's Bank  September 23, 2016   \n",
       " 8    GA  11297                          United Bank     August 19, 2016   \n",
       " 9    PA  35312  First-Citizens Bank & Trust Company         May 6, 2016   \n",
       " 10   TN   9956           The Bank of Fayette County      April 29, 2016   \n",
       " 11   WI  20364  First-Citizens Bank & Trust Company      March 11, 2016   \n",
       " 12   WA  35156                       Twin City Bank     October 2, 2015   \n",
       " 13   GA  35259                        Fidelity Bank     October 2, 2015   \n",
       " 14   CO  34112            United Fidelity Bank, fsb       July 10, 2015   \n",
       " 15   IL  57772             Republic Bank of Chicago         May 8, 2015   \n",
       " 16   PR  32102         Banco Popular de Puerto Rico   February 27, 2015   \n",
       " 17   GA  33938  First-Citizens Bank & Trust Company   February 13, 2015   \n",
       " 18   IL  20290            United Fidelity Bank, fsb    January 23, 2015   \n",
       " 19   FL  17557                       First NBC Bank    January 16, 2015   \n",
       " 20   MN  34983                            BankVista   December 19, 2014   \n",
       " 21   CA  34738    Bank of Southern California, N.A.    November 7, 2014   \n",
       " 22   IL    916                  State Bank of Texas    October 24, 2014   \n",
       " 23   MD   4862                          Howard Bank    October 17, 2014   \n",
       " 24   IL  28462                 Providence Bank, LLC       July 25, 2014   \n",
       " 25   GA  58125            Community & Southern Bank       July 18, 2014   \n",
       " 26   OK  12483      Alva State Bank & Trust Company       June 27, 2014   \n",
       " 27   FL  21793  Landmark Bank, National Association       June 20, 2014   \n",
       " 28   IL  10450                  Great Southern Bank       June 20, 2014   \n",
       " 29   MD  32368                        Bay Bank, FSB        May 30, 2014   \n",
       " ..   ..    ...                                  ...                 ...   \n",
       " 524  AR  33901       Pulaski Bank and Trust Company         May 9, 2008   \n",
       " 525  MO   1971                        Security Bank       March 7, 2008   \n",
       " 526  MO  24660       Liberty Bank and Trust Company    January 25, 2008   \n",
       " 527  OH  16848         The Citizens Banking Company     October 4, 2007   \n",
       " 528  GA  32575                           ING DIRECT  September 28, 2007   \n",
       " 529  PA  35353  Allegheny Valley Bank of Pittsburgh    February 2, 2007   \n",
       " 530  UT   1249                        Far West Bank       June 25, 2004   \n",
       " 531  NY  26778                     Union State Bank      March 19, 2004   \n",
       " 532  FL  26838              Hancock Bank of Florida      March 12, 2004   \n",
       " 533  NJ  31330                          No Acquirer   February 14, 2004   \n",
       " 534  PA  27203                       Earthstar Bank   November 14, 2003   \n",
       " 535  WI  11639                        The Park Bank         May 9, 2003   \n",
       " 536  CA  27094                            Beal Bank    February 7, 2003   \n",
       " 537  LA  16445            Sabine State Bank & Trust   December 17, 2002   \n",
       " 538  TN   9961                          No Acquirer    November 8, 2002   \n",
       " 539  GA  33784                          No Acquirer  September 30, 2002   \n",
       " 540  IL  29355               Chicago Community Bank       June 27, 2002   \n",
       " 541  CT  19183                   Hudson United Bank       June 26, 2002   \n",
       " 542  MI  34979                          No Acquirer      March 28, 2002   \n",
       " 543  FL  26652                       Bank Leumi USA       March 1, 2002   \n",
       " 544  AZ  22314                          No Acquirer    February 7, 2002   \n",
       " 545  OH   8966       The State Bank & Trust Company    February 1, 2002   \n",
       " 546  TX  22002     The Security State Bank of Pecos    January 18, 2002   \n",
       " 547  FL  24382     Israel Discount Bank of New York    January 11, 2002   \n",
       " 548  AR  34248                   Delta Trust & Bank   September 7, 2001   \n",
       " 549  IL  32646                Superior Federal, FSB       July 27, 2001   \n",
       " 550  OH   6629                    North Valley Bank         May 3, 2001   \n",
       " 551  NH  34264  Southern New Hampshire Bank & Trust    February 2, 2001   \n",
       " 552  IL   3815              Banterra Bank of Marion   December 14, 2000   \n",
       " 553  HI  21029                   Bank of the Orient    October 13, 2000   \n",
       " \n",
       "            Updated Date  \n",
       " 0      October 20, 2017  \n",
       " 1         July 26, 2017  \n",
       " 2         July 26, 2017  \n",
       " 3         July 26, 2017  \n",
       " 4          May 18, 2017  \n",
       " 5          May 18, 2017  \n",
       " 6          May 18, 2017  \n",
       " 7    September 25, 2017  \n",
       " 8          June 1, 2017  \n",
       " 9     September 6, 2016  \n",
       " 10    September 6, 2016  \n",
       " 11       March 13, 2017  \n",
       " 12       April 13, 2016  \n",
       " 13     October 24, 2016  \n",
       " 14      August 17, 2016  \n",
       " 15        July 12, 2016  \n",
       " 16         May 13, 2015  \n",
       " 17       April 21, 2015  \n",
       " 18    November 15, 2017  \n",
       " 19    November 15, 2017  \n",
       " 20      January 6, 2016  \n",
       " 21    November 10, 2016  \n",
       " 22      January 6, 2016  \n",
       " 23       March 26, 2015  \n",
       " 24    December 12, 2016  \n",
       " 25      October 6, 2017  \n",
       " 26       March 25, 2016  \n",
       " 27      October 6, 2017  \n",
       " 28        June 26, 2015  \n",
       " 29    December 12, 2016  \n",
       " ..                  ...  \n",
       " 524     August 28, 2012  \n",
       " 525     August 28, 2012  \n",
       " 526    October 26, 2012  \n",
       " 527  September 12, 2016  \n",
       " 528     August 28, 2012  \n",
       " 529    October 27, 2010  \n",
       " 530       April 9, 2008  \n",
       " 531       April 9, 2008  \n",
       " 532        June 5, 2012  \n",
       " 533       April 9, 2008  \n",
       " 534     October 6, 2017  \n",
       " 535        June 5, 2012  \n",
       " 536    October 20, 2008  \n",
       " 537    October 20, 2004  \n",
       " 538      March 18, 2005  \n",
       " 539  September 11, 2006  \n",
       " 540     October 6, 2017  \n",
       " 541   February 14, 2012  \n",
       " 542      March 18, 2005  \n",
       " 543       April 9, 2008  \n",
       " 544    February 5, 2015  \n",
       " 545    October 25, 2012  \n",
       " 546    November 6, 2003  \n",
       " 547  September 21, 2015  \n",
       " 548     October 6, 2017  \n",
       " 549     August 19, 2014  \n",
       " 550   November 18, 2002  \n",
       " 551   February 18, 2003  \n",
       " 552      March 17, 2005  \n",
       " 553      March 17, 2005  \n",
       " \n",
       " [554 rows x 7 columns]]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.read_html(\"https://www.fdic.gov/bank/individual/failed/banklist.html\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sqlalchemy import create_engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(\"sqlite:///:memory:\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "Table 'my_table' already exists.",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-27-437f6f6402d2>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_sql\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"my_table\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m;\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32md:\\python\\python36\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36mto_sql\u001b[1;34m(self, name, con, flavor, schema, if_exists, index, index_label, chunksize, dtype)\u001b[0m\n\u001b[0;32m   1360\u001b[0m         sql.to_sql(self, name, con, flavor=flavor, schema=schema,\n\u001b[0;32m   1361\u001b[0m                    \u001b[0mif_exists\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mif_exists\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mindex_label\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex_label\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1362\u001b[1;33m                    chunksize=chunksize, dtype=dtype)\n\u001b[0m\u001b[0;32m   1363\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1364\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mto_pickle\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mpath\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcompression\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'infer'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32md:\\python\\python36\\lib\\site-packages\\pandas\\io\\sql.py\u001b[0m in \u001b[0;36mto_sql\u001b[1;34m(frame, name, con, flavor, schema, if_exists, index, index_label, chunksize, dtype)\u001b[0m\n\u001b[0;32m    469\u001b[0m     pandas_sql.to_sql(frame, name, if_exists=if_exists, index=index,\n\u001b[0;32m    470\u001b[0m                       \u001b[0mindex_label\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex_label\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mschema\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mschema\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 471\u001b[1;33m                       chunksize=chunksize, dtype=dtype)\n\u001b[0m\u001b[0;32m    472\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    473\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32md:\\python\\python36\\lib\\site-packages\\pandas\\io\\sql.py\u001b[0m in \u001b[0;36mto_sql\u001b[1;34m(self, frame, name, if_exists, index, index_label, schema, chunksize, dtype)\u001b[0m\n\u001b[0;32m   1148\u001b[0m                          \u001b[0mif_exists\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mif_exists\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mindex_label\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex_label\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1149\u001b[0m                          schema=schema, dtype=dtype)\n\u001b[1;32m-> 1150\u001b[1;33m         \u001b[0mtable\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcreate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1151\u001b[0m         \u001b[0mtable\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0minsert\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mchunksize\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1152\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;32mnot\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0misdigit\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mand\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mislower\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32md:\\python\\python36\\lib\\site-packages\\pandas\\io\\sql.py\u001b[0m in \u001b[0;36mcreate\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    586\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexists\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    587\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mif_exists\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'fail'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 588\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Table '%s' already exists.\"\u001b[0m \u001b[1;33m%\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    589\u001b[0m             \u001b[1;32melif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mif_exists\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'replace'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    590\u001b[0m                 \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mpd_sql\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdrop_table\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mschema\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mValueError\u001b[0m: Table 'my_table' already exists."
     ]
    }
   ],
   "source": [
    "df.to_sql(\"my_table\", engine);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "sqldf = pd.read_sql('my_table', con=engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>index</th>\n",
       "      <th>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "2007/10/07 00:00:00.000000000\u001d",
       "12603042\u001d",
       "56374\u001d",
       "SCOPE TECHNOLOGY CO.</th>\n",
       "      <th>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "USD\u001d",
       "Tang</th>\n",
       "      <th>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-000085\u001d",
       "0402 SMT CAP</th>\n",
       "      <th>1</th>\n",
       "      <th>UF</th>\n",
       "      <th>6.3V</th>\n",
       "      <th>10%</th>\n",
       "      <th>X5R</th>\n",
       "      <th>0402</th>\n",
       "      <th>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.301\u001d",
       "Capacitors\u001d",
       "Each\u001d",
       "\u001d",
       "0.00057\u001d",
       "N\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "0\u001d",
       "\u001d",
       "NON CUMULATIVE\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "2007/10/08 00:00:00.000000000\u001d",
       "2025/12/30 00:00:00.000000000\u001d",
       "\u001d",
       "\u001d",
       "\u001d",
       "2017/11/14 00:00:00.000000000\u001d",
       "2017/10/19 21:33:41.000000000\u001d",
       "2016/05/19 00:53:05.000000000\u001d",
       "N\u001d",
       "\u001d",
       "CL05A105KQ5NNNC/\u001d",
       "5235926\u001d",
       "102\u001d",
       "23\u001d",
       "\u001d",
       "2015/07/01 00:00:00.000000000\u001d",
       "2015/09/30 00:00:00.000000000\u001d",
       "0.00061\u001d",
       "OPEN\u001d",
       "OPEN\u001d",
       "OPEN\u001d",
       "N\u001d",
       "N\u001d",
       "N</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>5000117\u001d",
       "5013518\u001d",
       "82\u001d",
       "SZLT OU\u001d",
       "675018927\u001d",
       "43\u001d",
       "GPA\u001d",
       "20...</td>\n",
       "      <td>LTD.\u001d",
       "408755\u001d",
       "TAIWAN\u001d",
       "SZLT-SUZHOU\u001d",
       "SZLT-SUZHOU\u001d",
       "US...</td>\n",
       "      <td>Nancy\u001d",
       "APPROVED\u001d",
       "\u001d",
       "\u001d",
       "0\u001d",
       "Y\u001d",
       "Y\u001d",
       "\u001d",
       "121\u001d",
       "20029154\u001d",
       "301-0000...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>UF</td>\n",
       "      <td>6.3V</td>\n",
       "      <td>10%</td>\n",
       "      <td>X5R</td>\n",
       "      <td>0402</td>\n",
       "      <td>T=0.5MM\u001d",
       "121\u001d",
       "2015/03/23 03:01:35.000000000\u001d",
       "EE.3...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   index  \\\n",
       "0      0   \n",
       "1      1   \n",
       "2      2   \n",
       "\n",
       "  5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "2007/10/07 00:00:00.000000000\n",
       "12603042\n",
       "56374\n",
       "SCOPE TECHNOLOGY CO.  \\\n",
       "0  5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "1  5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "2  5000117\n",
       "5013518\n",
       "82\n",
       "SZLT OU\n",
       "675018927\n",
       "43\n",
       "GPA\n",
       "20...                                                              \n",
       "\n",
       "   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "USD\n",
       "Tang  \\\n",
       "0   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "1   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "2   LTD.\n",
       "408755\n",
       "TAIWAN\n",
       "SZLT-SUZHOU\n",
       "SZLT-SUZHOU\n",
       "US...     \n",
       "\n",
       "   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-000085\n",
       "0402 SMT CAP    1  UF  \\\n",
       "0   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "1   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "2   Nancy\n",
       "APPROVED\n",
       "\n",
       "\n",
       "0\n",
       "Y\n",
       "Y\n",
       "\n",
       "121\n",
       "20029154\n",
       "301-0000...             1.0  UF   \n",
       "\n",
       "   6.3V  10%  X5R  0402  \\\n",
       "0  6.3V  10%  X5R  0402   \n",
       "1  6.3V  10%  X5R  0402   \n",
       "2  6.3V  10%  X5R  0402   \n",
       "\n",
       "  T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.301\n",
       "Capacitors\n",
       "Each\n",
       "\n",
       "0.00057\n",
       "N\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "0\n",
       "0\n",
       "\n",
       "NON CUMULATIVE\n",
       "\n",
       "\n",
       "\n",
       "2007/10/08 00:00:00.000000000\n",
       "2025/12/30 00:00:00.000000000\n",
       "\n",
       "\n",
       "\n",
       "2017/11/14 00:00:00.000000000\n",
       "2017/10/19 21:33:41.000000000\n",
       "2016/05/19 00:53:05.000000000\n",
       "N\n",
       "\n",
       "CL05A105KQ5NNNC/\n",
       "5235926\n",
       "102\n",
       "23\n",
       "\n",
       "2015/07/01 00:00:00.000000000\n",
       "2015/09/30 00:00:00.000000000\n",
       "0.00061\n",
       "OPEN\n",
       "OPEN\n",
       "OPEN\n",
       "N\n",
       "N\n",
       "N  \n",
       "0  T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "1  T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             \n",
       "2  T=0.5MM\n",
       "121\n",
       "2015/03/23 03:01:35.000000000\n",
       "EE.3...                                                                                                                                                                                                                                                                                                                                             "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sqldf.head(3)"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}