Wikipedia scraping.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Scraping Wikipedia\n",
    "There is different possibilities out there:\n",
    "\n",
    "- Use WikiData: contains a lot of data from Wikipedia (and other) in a relational style. However, data about politician/big swiss companies aren't part of the Wikidata\n",
    "- `Wikipedia` python module (or, more generally, the MediaWiki API) where one can find more structured information. However, in this case, most of the features aren't useful (at least at first)\n",
    "- Scrape page directly. This solution will be tried first\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import requests                       # HTTP requests lib\n",
    "from bs4 import BeautifulSoup         # HTML parsing\n",
    "import pandas as pd                   # Data handling\n",
    "import lxml\n",
    "\n",
    "WIKIPEDIA_URL = \"https://en.wikipedia.org/wiki/List_of_Swiss_companies_by_revenue\"\n",
    "\n",
    "page = BeautifulSoup(requests.get(WIKIPEDIA_URL).content, \"html.parser\")\n",
    "#print(page.prettify())\n",
    "\n",
    "content_div = page.find('div', {'id':'mw-content-text'}) \n",
    "\n",
    "table_class_target = set('wikitable sortable'.split(' '))\n",
    "found_tables = []\n",
    "\n",
    "def parse_table(table):\n",
    "    lines = table.find_all('tr')\n",
    "\n",
    "    # Extract column names\n",
    "    colnames = [str(name.find('b').text) for name in lines[0].find_all('td')]\n",
    "    \n",
    "    # Simple cleanup of the column names\n",
    "    colnames = [elem.split('\\n')[0] for elem in colnames]\n",
    "    \n",
    "    # Parse other lines\n",
    "    content = []\n",
    "    for line in lines[1:]:\n",
    "        content.append([e.text for e in line.find_all('td')])\n",
    "    \n",
    "    return pd.DataFrame(data=content, columns=colnames)\n",
    "\n",
    "for table in content_div.find_all('table') :\n",
    "    classes_found = set(table['class'])\n",
    "    if table_class_target <= classes_found:\n",
    "        # Table to parse\n",
    "        found_tables.append(parse_table(table))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This scrape all the wikitable from the page, then some cleaning need to be done\n",
    "\n",
    "## Largest companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rank</th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Net income</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Director</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.</td>\n",
       "      <td>Glencore</td>\n",
       "      <td>Baar</td>\n",
       "      <td>119 938</td>\n",
       "      <td></td>\n",
       "      <td>181 000[1]</td>\n",
       "      <td>commodity trading</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.</td>\n",
       "      <td>Nestlé</td>\n",
       "      <td>Vevey</td>\n",
       "      <td>91 075</td>\n",
       "      <td>7 995</td>\n",
       "      <td>253 000</td>\n",
       "      <td>agriculture/food</td>\n",
       "      <td>Peter Brabeck-Letmathe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.</td>\n",
       "      <td>Novartis</td>\n",
       "      <td>Basel</td>\n",
       "      <td>42 455</td>\n",
       "      <td>8 093</td>\n",
       "      <td>90 924</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.</td>\n",
       "      <td>Roche</td>\n",
       "      <td>Basel</td>\n",
       "      <td>35 511</td>\n",
       "      <td>2 390</td>\n",
       "      <td>68 218</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.</td>\n",
       "      <td>ABB</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>29 169</td>\n",
       "      <td>955</td>\n",
       "      <td>104 000</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.</td>\n",
       "      <td>Adecco</td>\n",
       "      <td>Chéserex</td>\n",
       "      <td>28 534</td>\n",
       "      <td>706</td>\n",
       "      <td>33 000</td>\n",
       "      <td>temp workers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.</td>\n",
       "      <td>Migros</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>20 385</td>\n",
       "      <td>699</td>\n",
       "      <td>59 934</td>\n",
       "      <td>retail/services</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.</td>\n",
       "      <td>Holcim</td>\n",
       "      <td>Jona</td>\n",
       "      <td>18 468</td>\n",
       "      <td>1 818</td>\n",
       "      <td>59 901</td>\n",
       "      <td>construction materials</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.</td>\n",
       "      <td>Cargill International SA</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>18 275</td>\n",
       "      <td></td>\n",
       "      <td>475</td>\n",
       "      <td>commodity trading</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.</td>\n",
       "      <td>Coop</td>\n",
       "      <td>Basel</td>\n",
       "      <td>14 901</td>\n",
       "      <td>270</td>\n",
       "      <td>37 370</td>\n",
       "      <td>retail/services</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11.</td>\n",
       "      <td>Kühne + Nagel</td>\n",
       "      <td>Schindellegi</td>\n",
       "      <td>14 048</td>\n",
       "      <td>315</td>\n",
       "      <td>25 607</td>\n",
       "      <td>international transport/logistics</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12.</td>\n",
       "      <td>Mercuria Energy Trading</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>11 200</td>\n",
       "      <td>200</td>\n",
       "      <td></td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13.</td>\n",
       "      <td>Syngenta</td>\n",
       "      <td>Basel</td>\n",
       "      <td>10 681</td>\n",
       "      <td>779</td>\n",
       "      <td>19 337</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14.</td>\n",
       "      <td>Xstrata</td>\n",
       "      <td>Zug</td>\n",
       "      <td>10 609</td>\n",
       "      <td>2 249</td>\n",
       "      <td>17 000</td>\n",
       "      <td>mining</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15.</td>\n",
       "      <td>Swisscom</td>\n",
       "      <td>Bern</td>\n",
       "      <td>9 732</td>\n",
       "      <td>2 346</td>\n",
       "      <td>16 088</td>\n",
       "      <td>telecommunications</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16.</td>\n",
       "      <td>Schindler</td>\n",
       "      <td>Ebikon</td>\n",
       "      <td>8 870</td>\n",
       "      <td>401</td>\n",
       "      <td>40 385</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17.</td>\n",
       "      <td>Atel / Motor-Columbus</td>\n",
       "      <td>Olten</td>\n",
       "      <td>8 580</td>\n",
       "      <td>413</td>\n",
       "      <td>8 649</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18.</td>\n",
       "      <td>Alstom Suisse</td>\n",
       "      <td>Baden</td>\n",
       "      <td>8 500</td>\n",
       "      <td></td>\n",
       "      <td>4 500</td>\n",
       "      <td>engineering/manufacturing</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19.</td>\n",
       "      <td>Panalpina</td>\n",
       "      <td>Basel</td>\n",
       "      <td>8 293</td>\n",
       "      <td>120</td>\n",
       "      <td>13 583</td>\n",
       "      <td>international shipping/logistics</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20.</td>\n",
       "      <td>Liebherr</td>\n",
       "      <td>Bulle</td>\n",
       "      <td>8 270</td>\n",
       "      <td></td>\n",
       "      <td>23 762</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21.</td>\n",
       "      <td>Clariant</td>\n",
       "      <td>Muttenz</td>\n",
       "      <td>8 181</td>\n",
       "      <td>192</td>\n",
       "      <td>23 383</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22.</td>\n",
       "      <td>La Poste</td>\n",
       "      <td>Bern</td>\n",
       "      <td>7 499</td>\n",
       "      <td>811</td>\n",
       "      <td>41 073</td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23.</td>\n",
       "      <td>DKSH Management AG</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>7 454</td>\n",
       "      <td></td>\n",
       "      <td>20 500</td>\n",
       "      <td>import/export</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24.</td>\n",
       "      <td>Ciba</td>\n",
       "      <td>Basel</td>\n",
       "      <td>7 419</td>\n",
       "      <td>-256</td>\n",
       "      <td>19 105</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25.</td>\n",
       "      <td>CFF</td>\n",
       "      <td>Bern</td>\n",
       "      <td>7 087</td>\n",
       "      <td>-166</td>\n",
       "      <td>28 383</td>\n",
       "      <td>public transport/railroads</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26.</td>\n",
       "      <td>Axpo</td>\n",
       "      <td>Baden</td>\n",
       "      <td>6 716</td>\n",
       "      <td>571</td>\n",
       "      <td>2 990</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27.</td>\n",
       "      <td>Richemont</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>6 716</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28.</td>\n",
       "      <td>Globus-Cosmos</td>\n",
       "      <td>Montagnola</td>\n",
       "      <td>5 600</td>\n",
       "      <td></td>\n",
       "      <td>5 000</td>\n",
       "      <td>travel agency/tourism</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29.</td>\n",
       "      <td>Swatch</td>\n",
       "      <td>Bienne</td>\n",
       "      <td>4 497</td>\n",
       "      <td>621</td>\n",
       "      <td>20 650</td>\n",
       "      <td>watchmaking</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30.</td>\n",
       "      <td>Fenaco</td>\n",
       "      <td>Bern</td>\n",
       "      <td>4 380</td>\n",
       "      <td>54</td>\n",
       "      <td>7 244</td>\n",
       "      <td>retail</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>71.</td>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 991</td>\n",
       "      <td>208</td>\n",
       "      <td>2 300</td>\n",
       "      <td>telecommunications</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>72.</td>\n",
       "      <td>ALSO Group</td>\n",
       "      <td>Hergiswil</td>\n",
       "      <td>1 980</td>\n",
       "      <td>17</td>\n",
       "      <td>623</td>\n",
       "      <td>computers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>73.</td>\n",
       "      <td>Franke</td>\n",
       "      <td>Aarburg</td>\n",
       "      <td>1 959</td>\n",
       "      <td></td>\n",
       "      <td>7 040</td>\n",
       "      <td>electrical appliances</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>74.</td>\n",
       "      <td>Mettler-Toledo</td>\n",
       "      <td>Greifensee</td>\n",
       "      <td>1 953</td>\n",
       "      <td>143</td>\n",
       "      <td>8 700</td>\n",
       "      <td>tools</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>75.</td>\n",
       "      <td>Emil Frey</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 950</td>\n",
       "      <td></td>\n",
       "      <td>2 144</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>76.</td>\n",
       "      <td>Bucher Industries</td>\n",
       "      <td>Niederweningen</td>\n",
       "      <td>1 948</td>\n",
       "      <td>86</td>\n",
       "      <td>6 874</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>77.</td>\n",
       "      <td>BKW FMB Energie</td>\n",
       "      <td>Bern</td>\n",
       "      <td>1 931</td>\n",
       "      <td>306</td>\n",
       "      <td>2 120</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>78.</td>\n",
       "      <td>Geberit</td>\n",
       "      <td>Rapperswil</td>\n",
       "      <td>1 922</td>\n",
       "      <td></td>\n",
       "      <td>5 162</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>79.</td>\n",
       "      <td>Hotelplan</td>\n",
       "      <td>Glattbrugg</td>\n",
       "      <td>1 728</td>\n",
       "      <td>16</td>\n",
       "      <td>3 109</td>\n",
       "      <td>travel agency/tourism</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>80.</td>\n",
       "      <td>Esso Suisse</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 720</td>\n",
       "      <td></td>\n",
       "      <td>155</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>81.</td>\n",
       "      <td>Forbo</td>\n",
       "      <td>Baar</td>\n",
       "      <td>1 702</td>\n",
       "      <td></td>\n",
       "      <td>5 538</td>\n",
       "      <td>carpets/floor coverings</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>82.</td>\n",
       "      <td>Nuance</td>\n",
       "      <td>Glattbrugg</td>\n",
       "      <td>1 690</td>\n",
       "      <td></td>\n",
       "      <td>4 936</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>83.</td>\n",
       "      <td>Cementia</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 650</td>\n",
       "      <td></td>\n",
       "      <td>6 000</td>\n",
       "      <td>construction materials</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>84.</td>\n",
       "      <td>BP Suisse</td>\n",
       "      <td>Zug</td>\n",
       "      <td>1 634</td>\n",
       "      <td>32</td>\n",
       "      <td>134</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>85.</td>\n",
       "      <td>Unaxis</td>\n",
       "      <td>Pfäffikon</td>\n",
       "      <td>1 605</td>\n",
       "      <td></td>\n",
       "      <td>6 434</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>86.</td>\n",
       "      <td>SRG SSR idée suisse</td>\n",
       "      <td>Bern</td>\n",
       "      <td>1 591</td>\n",
       "      <td>-0.3</td>\n",
       "      <td></td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>87.</td>\n",
       "      <td>Bobst</td>\n",
       "      <td>Prilly</td>\n",
       "      <td>1 591</td>\n",
       "      <td>46</td>\n",
       "      <td>5 587</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>88.</td>\n",
       "      <td>Hewlett-Packard Suisse</td>\n",
       "      <td>Dübendorf</td>\n",
       "      <td>1 550</td>\n",
       "      <td></td>\n",
       "      <td>1 400</td>\n",
       "      <td>computers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>89.</td>\n",
       "      <td>Krupp Presta</td>\n",
       "      <td>Eschen</td>\n",
       "      <td>1 550</td>\n",
       "      <td></td>\n",
       "      <td>4 600</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>90.</td>\n",
       "      <td>Allied Steel</td>\n",
       "      <td>Lugano</td>\n",
       "      <td>1 519</td>\n",
       "      <td>33</td>\n",
       "      <td>70</td>\n",
       "      <td>import/export</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>91.</td>\n",
       "      <td>Bühler</td>\n",
       "      <td>Uzwil</td>\n",
       "      <td>1 502</td>\n",
       "      <td>72</td>\n",
       "      <td>6 266</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>92.</td>\n",
       "      <td>Swissport</td>\n",
       "      <td>Opfikon</td>\n",
       "      <td>1 499</td>\n",
       "      <td></td>\n",
       "      <td>21 000</td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>93.</td>\n",
       "      <td>Migrol</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 496</td>\n",
       "      <td></td>\n",
       "      <td>285</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>94.</td>\n",
       "      <td>Shell Suisse</td>\n",
       "      <td>Baar</td>\n",
       "      <td>1 466</td>\n",
       "      <td></td>\n",
       "      <td>171</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>95.</td>\n",
       "      <td>Bell</td>\n",
       "      <td>Basel</td>\n",
       "      <td>1 443</td>\n",
       "      <td>35</td>\n",
       "      <td>3 326</td>\n",
       "      <td>meat products</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96.</td>\n",
       "      <td>DaimlerChrysler Suisse</td>\n",
       "      <td>Schlieren</td>\n",
       "      <td>1 427</td>\n",
       "      <td></td>\n",
       "      <td>403</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>97.</td>\n",
       "      <td>Sicpa</td>\n",
       "      <td>Prilly</td>\n",
       "      <td>1 400</td>\n",
       "      <td></td>\n",
       "      <td>3 400</td>\n",
       "      <td>chemicals/pharmaceuticals</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>98.</td>\n",
       "      <td>BMW Suisse</td>\n",
       "      <td>Dielsdorf</td>\n",
       "      <td>1 392</td>\n",
       "      <td></td>\n",
       "      <td>299</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>99.</td>\n",
       "      <td>Steiner Group</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 379</td>\n",
       "      <td></td>\n",
       "      <td>500</td>\n",
       "      <td>general contractors</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>100.</td>\n",
       "      <td>EOS Holding</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>1 371</td>\n",
       "      <td>51</td>\n",
       "      <td>333</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Rank                      Name    Headquarters  Revenue Net income  \\\n",
       "0     1.                  Glencore            Baar  119 938              \n",
       "1     2.                    Nestlé           Vevey   91 075      7 995   \n",
       "2     3.                  Novartis           Basel   42 455      8 093   \n",
       "3     4.                     Roche           Basel   35 511      2 390   \n",
       "4     5.                       ABB          Zurich   29 169        955   \n",
       "5     6.                    Adecco        Chéserex   28 534        706   \n",
       "6     7.                    Migros          Zurich   20 385        699   \n",
       "7     8.                    Holcim            Jona   18 468      1 818   \n",
       "8     9.  Cargill International SA          Geneva   18 275              \n",
       "9    10.                      Coop           Basel   14 901        270   \n",
       "10   11.             Kühne + Nagel    Schindellegi   14 048        315   \n",
       "11   12.   Mercuria Energy Trading          Geneva   11 200        200   \n",
       "12   13.                  Syngenta           Basel   10 681        779   \n",
       "13   14.                   Xstrata             Zug   10 609      2 249   \n",
       "14   15.                  Swisscom            Bern    9 732      2 346   \n",
       "15   16.                 Schindler          Ebikon    8 870        401   \n",
       "16   17.     Atel / Motor-Columbus           Olten    8 580        413   \n",
       "17   18.             Alstom Suisse           Baden    8 500              \n",
       "18   19.                 Panalpina           Basel    8 293        120   \n",
       "19   20.                  Liebherr           Bulle    8 270              \n",
       "20   21.                  Clariant         Muttenz    8 181        192   \n",
       "21   22.                  La Poste            Bern    7 499        811   \n",
       "22   23.        DKSH Management AG          Zurich    7 454              \n",
       "23   24.                      Ciba           Basel    7 419       -256   \n",
       "24   25.                       CFF            Bern    7 087       -166   \n",
       "25   26.                      Axpo           Baden    6 716        571   \n",
       "26   27.                 Richemont          Geneva    6 716              \n",
       "27   28.             Globus-Cosmos      Montagnola    5 600              \n",
       "28   29.                    Swatch          Bienne    4 497        621   \n",
       "29   30.                    Fenaco            Bern    4 380         54   \n",
       "..   ...                       ...             ...      ...        ...   \n",
       "70   71.                   Sunrise          Zurich    1 991        208   \n",
       "71   72.                ALSO Group       Hergiswil    1 980         17   \n",
       "72   73.                    Franke         Aarburg    1 959              \n",
       "73   74.            Mettler-Toledo      Greifensee    1 953        143   \n",
       "74   75.                 Emil Frey          Zurich    1 950              \n",
       "75   76.         Bucher Industries  Niederweningen    1 948         86   \n",
       "76   77.           BKW FMB Energie            Bern    1 931        306   \n",
       "77   78.                   Geberit      Rapperswil    1 922              \n",
       "78   79.                 Hotelplan      Glattbrugg    1 728         16   \n",
       "79   80.               Esso Suisse          Zurich    1 720              \n",
       "80   81.                     Forbo            Baar    1 702              \n",
       "81   82.                    Nuance      Glattbrugg    1 690              \n",
       "82   83.                  Cementia          Zurich    1 650              \n",
       "83   84.                 BP Suisse             Zug    1 634         32   \n",
       "84   85.                    Unaxis       Pfäffikon    1 605              \n",
       "85   86.       SRG SSR idée suisse            Bern    1 591       -0.3   \n",
       "86   87.                     Bobst          Prilly    1 591         46   \n",
       "87   88.    Hewlett-Packard Suisse       Dübendorf    1 550              \n",
       "88   89.              Krupp Presta          Eschen    1 550              \n",
       "89   90.              Allied Steel          Lugano    1 519         33   \n",
       "90   91.                    Bühler           Uzwil    1 502         72   \n",
       "91   92.                 Swissport         Opfikon    1 499              \n",
       "92   93.                    Migrol          Zurich    1 496              \n",
       "93   94.              Shell Suisse            Baar    1 466              \n",
       "94   95.                      Bell           Basel    1 443         35   \n",
       "95   96.    DaimlerChrysler Suisse       Schlieren    1 427              \n",
       "96   97.                     Sicpa          Prilly    1 400              \n",
       "97   98.                BMW Suisse       Dielsdorf    1 392              \n",
       "98   99.             Steiner Group          Zurich    1 379              \n",
       "99  100.               EOS Holding        Lausanne    1 371         51   \n",
       "\n",
       "     Employees                           Industry                Director  \n",
       "0   181 000[1]                  commodity trading                          \n",
       "1      253 000                   agriculture/food  Peter Brabeck-Letmathe  \n",
       "2       90 924            chemical/pharmaceutical                          \n",
       "3       68 218            chemical/pharmaceutical                          \n",
       "4      104 000                        engineering                          \n",
       "5       33 000                       temp workers                          \n",
       "6       59 934                    retail/services                          \n",
       "7       59 901             construction materials                          \n",
       "8          475                  commodity trading                          \n",
       "9       37 370                    retail/services                          \n",
       "10      25 607  international transport/logistics                          \n",
       "11                                      petroleum                          \n",
       "12      19 337            chemical/pharmaceutical                          \n",
       "13      17 000                             mining                          \n",
       "14      16 088                 telecommunications                          \n",
       "15      40 385                        engineering                          \n",
       "16       8 649     energy production/distribution                          \n",
       "17       4 500          engineering/manufacturing                          \n",
       "18      13 583   international shipping/logistics                          \n",
       "19      23 762                        engineering                          \n",
       "20      23 383            chemical/pharmaceutical                          \n",
       "21      41 073                            service                          \n",
       "22      20 500                      import/export                          \n",
       "23      19 105            chemical/pharmaceutical                          \n",
       "24      28 383         public transport/railroads                          \n",
       "25       2 990     energy production/distribution                          \n",
       "26                                                                         \n",
       "27       5 000              travel agency/tourism                          \n",
       "28      20 650                        watchmaking                          \n",
       "29       7 244                             retail                          \n",
       "..         ...                                ...                     ...  \n",
       "70       2 300                 telecommunications                          \n",
       "71         623                          computers                          \n",
       "72       7 040              electrical appliances                          \n",
       "73       8 700                              tools                          \n",
       "74       2 144           automobile sales/imports                          \n",
       "75       6 874                        engineering                          \n",
       "76       2 120     energy production/distribution                          \n",
       "77       5 162                                                             \n",
       "78       3 109              travel agency/tourism                          \n",
       "79         155                          petroleum                          \n",
       "80       5 538            carpets/floor coverings                          \n",
       "81       4 936                                                             \n",
       "82       6 000             construction materials                          \n",
       "83         134                          petroleum                          \n",
       "84       6 434                                                             \n",
       "85                                        service                          \n",
       "86       5 587                        engineering                          \n",
       "87       1 400                          computers                          \n",
       "88       4 600                        engineering                          \n",
       "89          70                      import/export                          \n",
       "90       6 266                        engineering                          \n",
       "91      21 000                            service                          \n",
       "92         285                          petroleum                          \n",
       "93         171                          petroleum                          \n",
       "94       3 326                      meat products                          \n",
       "95         403           automobile sales/imports                          \n",
       "96       3 400          chemicals/pharmaceuticals                          \n",
       "97         299           automobile sales/imports                          \n",
       "98         500                general contractors                          \n",
       "99         333     energy production/distribution                          \n",
       "\n",
       "[100 rows x 8 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_companies = found_tables[0]\n",
    "largest_companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Revenue</th>\n",
       "      <th>Net income</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Director</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rank</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Glencore</td>\n",
       "      <td>Baar</td>\n",
       "      <td>119 938</td>\n",
       "      <td></td>\n",
       "      <td>181 000[1]</td>\n",
       "      <td>commodity trading</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Nestlé</td>\n",
       "      <td>Vevey</td>\n",
       "      <td>91 075</td>\n",
       "      <td>7 995</td>\n",
       "      <td>253 000</td>\n",
       "      <td>agriculture/food</td>\n",
       "      <td>Peter Brabeck-Letmathe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Novartis</td>\n",
       "      <td>Basel</td>\n",
       "      <td>42 455</td>\n",
       "      <td>8 093</td>\n",
       "      <td>90 924</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Roche</td>\n",
       "      <td>Basel</td>\n",
       "      <td>35 511</td>\n",
       "      <td>2 390</td>\n",
       "      <td>68 218</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>ABB</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>29 169</td>\n",
       "      <td>955</td>\n",
       "      <td>104 000</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Adecco</td>\n",
       "      <td>Chéserex</td>\n",
       "      <td>28 534</td>\n",
       "      <td>706</td>\n",
       "      <td>33 000</td>\n",
       "      <td>temp workers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Migros</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>20 385</td>\n",
       "      <td>699</td>\n",
       "      <td>59 934</td>\n",
       "      <td>retail/services</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Holcim</td>\n",
       "      <td>Jona</td>\n",
       "      <td>18 468</td>\n",
       "      <td>1 818</td>\n",
       "      <td>59 901</td>\n",
       "      <td>construction materials</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Cargill International SA</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>18 275</td>\n",
       "      <td></td>\n",
       "      <td>475</td>\n",
       "      <td>commodity trading</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Coop</td>\n",
       "      <td>Basel</td>\n",
       "      <td>14 901</td>\n",
       "      <td>270</td>\n",
       "      <td>37 370</td>\n",
       "      <td>retail/services</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Kühne + Nagel</td>\n",
       "      <td>Schindellegi</td>\n",
       "      <td>14 048</td>\n",
       "      <td>315</td>\n",
       "      <td>25 607</td>\n",
       "      <td>international transport/logistics</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Mercuria Energy Trading</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>11 200</td>\n",
       "      <td>200</td>\n",
       "      <td></td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Syngenta</td>\n",
       "      <td>Basel</td>\n",
       "      <td>10 681</td>\n",
       "      <td>779</td>\n",
       "      <td>19 337</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Xstrata</td>\n",
       "      <td>Zug</td>\n",
       "      <td>10 609</td>\n",
       "      <td>2 249</td>\n",
       "      <td>17 000</td>\n",
       "      <td>mining</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Swisscom</td>\n",
       "      <td>Bern</td>\n",
       "      <td>9 732</td>\n",
       "      <td>2 346</td>\n",
       "      <td>16 088</td>\n",
       "      <td>telecommunications</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Schindler</td>\n",
       "      <td>Ebikon</td>\n",
       "      <td>8 870</td>\n",
       "      <td>401</td>\n",
       "      <td>40 385</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Atel / Motor-Columbus</td>\n",
       "      <td>Olten</td>\n",
       "      <td>8 580</td>\n",
       "      <td>413</td>\n",
       "      <td>8 649</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Alstom Suisse</td>\n",
       "      <td>Baden</td>\n",
       "      <td>8 500</td>\n",
       "      <td></td>\n",
       "      <td>4 500</td>\n",
       "      <td>engineering/manufacturing</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Panalpina</td>\n",
       "      <td>Basel</td>\n",
       "      <td>8 293</td>\n",
       "      <td>120</td>\n",
       "      <td>13 583</td>\n",
       "      <td>international shipping/logistics</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Liebherr</td>\n",
       "      <td>Bulle</td>\n",
       "      <td>8 270</td>\n",
       "      <td></td>\n",
       "      <td>23 762</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Clariant</td>\n",
       "      <td>Muttenz</td>\n",
       "      <td>8 181</td>\n",
       "      <td>192</td>\n",
       "      <td>23 383</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>La Poste</td>\n",
       "      <td>Bern</td>\n",
       "      <td>7 499</td>\n",
       "      <td>811</td>\n",
       "      <td>41 073</td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>DKSH Management AG</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>7 454</td>\n",
       "      <td></td>\n",
       "      <td>20 500</td>\n",
       "      <td>import/export</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ciba</td>\n",
       "      <td>Basel</td>\n",
       "      <td>7 419</td>\n",
       "      <td>-256</td>\n",
       "      <td>19 105</td>\n",
       "      <td>chemical/pharmaceutical</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CFF</td>\n",
       "      <td>Bern</td>\n",
       "      <td>7 087</td>\n",
       "      <td>-166</td>\n",
       "      <td>28 383</td>\n",
       "      <td>public transport/railroads</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Axpo</td>\n",
       "      <td>Baden</td>\n",
       "      <td>6 716</td>\n",
       "      <td>571</td>\n",
       "      <td>2 990</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Richemont</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>6 716</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Globus-Cosmos</td>\n",
       "      <td>Montagnola</td>\n",
       "      <td>5 600</td>\n",
       "      <td></td>\n",
       "      <td>5 000</td>\n",
       "      <td>travel agency/tourism</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Swatch</td>\n",
       "      <td>Bienne</td>\n",
       "      <td>4 497</td>\n",
       "      <td>621</td>\n",
       "      <td>20 650</td>\n",
       "      <td>watchmaking</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Fenaco</td>\n",
       "      <td>Bern</td>\n",
       "      <td>4 380</td>\n",
       "      <td>54</td>\n",
       "      <td>7 244</td>\n",
       "      <td>retail</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Sunrise</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 991</td>\n",
       "      <td>208</td>\n",
       "      <td>2 300</td>\n",
       "      <td>telecommunications</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>ALSO Group</td>\n",
       "      <td>Hergiswil</td>\n",
       "      <td>1 980</td>\n",
       "      <td>17</td>\n",
       "      <td>623</td>\n",
       "      <td>computers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>Franke</td>\n",
       "      <td>Aarburg</td>\n",
       "      <td>1 959</td>\n",
       "      <td></td>\n",
       "      <td>7 040</td>\n",
       "      <td>electrical appliances</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>Mettler-Toledo</td>\n",
       "      <td>Greifensee</td>\n",
       "      <td>1 953</td>\n",
       "      <td>143</td>\n",
       "      <td>8 700</td>\n",
       "      <td>tools</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Emil Frey</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 950</td>\n",
       "      <td></td>\n",
       "      <td>2 144</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bucher Industries</td>\n",
       "      <td>Niederweningen</td>\n",
       "      <td>1 948</td>\n",
       "      <td>86</td>\n",
       "      <td>6 874</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>BKW FMB Energie</td>\n",
       "      <td>Bern</td>\n",
       "      <td>1 931</td>\n",
       "      <td>306</td>\n",
       "      <td>2 120</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Geberit</td>\n",
       "      <td>Rapperswil</td>\n",
       "      <td>1 922</td>\n",
       "      <td></td>\n",
       "      <td>5 162</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Hotelplan</td>\n",
       "      <td>Glattbrugg</td>\n",
       "      <td>1 728</td>\n",
       "      <td>16</td>\n",
       "      <td>3 109</td>\n",
       "      <td>travel agency/tourism</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Esso Suisse</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 720</td>\n",
       "      <td></td>\n",
       "      <td>155</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Forbo</td>\n",
       "      <td>Baar</td>\n",
       "      <td>1 702</td>\n",
       "      <td></td>\n",
       "      <td>5 538</td>\n",
       "      <td>carpets/floor coverings</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Nuance</td>\n",
       "      <td>Glattbrugg</td>\n",
       "      <td>1 690</td>\n",
       "      <td></td>\n",
       "      <td>4 936</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Cementia</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 650</td>\n",
       "      <td></td>\n",
       "      <td>6 000</td>\n",
       "      <td>construction materials</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>BP Suisse</td>\n",
       "      <td>Zug</td>\n",
       "      <td>1 634</td>\n",
       "      <td>32</td>\n",
       "      <td>134</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Unaxis</td>\n",
       "      <td>Pfäffikon</td>\n",
       "      <td>1 605</td>\n",
       "      <td></td>\n",
       "      <td>6 434</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>SRG SSR idée suisse</td>\n",
       "      <td>Bern</td>\n",
       "      <td>1 591</td>\n",
       "      <td>-0.3</td>\n",
       "      <td></td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>Bobst</td>\n",
       "      <td>Prilly</td>\n",
       "      <td>1 591</td>\n",
       "      <td>46</td>\n",
       "      <td>5 587</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Hewlett-Packard Suisse</td>\n",
       "      <td>Dübendorf</td>\n",
       "      <td>1 550</td>\n",
       "      <td></td>\n",
       "      <td>1 400</td>\n",
       "      <td>computers</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Krupp Presta</td>\n",
       "      <td>Eschen</td>\n",
       "      <td>1 550</td>\n",
       "      <td></td>\n",
       "      <td>4 600</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Allied Steel</td>\n",
       "      <td>Lugano</td>\n",
       "      <td>1 519</td>\n",
       "      <td>33</td>\n",
       "      <td>70</td>\n",
       "      <td>import/export</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Bühler</td>\n",
       "      <td>Uzwil</td>\n",
       "      <td>1 502</td>\n",
       "      <td>72</td>\n",
       "      <td>6 266</td>\n",
       "      <td>engineering</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Swissport</td>\n",
       "      <td>Opfikon</td>\n",
       "      <td>1 499</td>\n",
       "      <td></td>\n",
       "      <td>21 000</td>\n",
       "      <td>service</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>Migrol</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 496</td>\n",
       "      <td></td>\n",
       "      <td>285</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>Shell Suisse</td>\n",
       "      <td>Baar</td>\n",
       "      <td>1 466</td>\n",
       "      <td></td>\n",
       "      <td>171</td>\n",
       "      <td>petroleum</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Bell</td>\n",
       "      <td>Basel</td>\n",
       "      <td>1 443</td>\n",
       "      <td>35</td>\n",
       "      <td>3 326</td>\n",
       "      <td>meat products</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DaimlerChrysler Suisse</td>\n",
       "      <td>Schlieren</td>\n",
       "      <td>1 427</td>\n",
       "      <td></td>\n",
       "      <td>403</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>Sicpa</td>\n",
       "      <td>Prilly</td>\n",
       "      <td>1 400</td>\n",
       "      <td></td>\n",
       "      <td>3 400</td>\n",
       "      <td>chemicals/pharmaceuticals</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>BMW Suisse</td>\n",
       "      <td>Dielsdorf</td>\n",
       "      <td>1 392</td>\n",
       "      <td></td>\n",
       "      <td>299</td>\n",
       "      <td>automobile sales/imports</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Steiner Group</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 379</td>\n",
       "      <td></td>\n",
       "      <td>500</td>\n",
       "      <td>general contractors</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>EOS Holding</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>1 371</td>\n",
       "      <td>51</td>\n",
       "      <td>333</td>\n",
       "      <td>energy production/distribution</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          Name    Headquarters  Revenue Net income  \\\n",
       "Rank                                                                 \n",
       "1                     Glencore            Baar  119 938              \n",
       "2                       Nestlé           Vevey   91 075      7 995   \n",
       "3                     Novartis           Basel   42 455      8 093   \n",
       "4                        Roche           Basel   35 511      2 390   \n",
       "5                          ABB          Zurich   29 169        955   \n",
       "6                       Adecco        Chéserex   28 534        706   \n",
       "7                       Migros          Zurich   20 385        699   \n",
       "8                       Holcim            Jona   18 468      1 818   \n",
       "9     Cargill International SA          Geneva   18 275              \n",
       "10                        Coop           Basel   14 901        270   \n",
       "11               Kühne + Nagel    Schindellegi   14 048        315   \n",
       "12     Mercuria Energy Trading          Geneva   11 200        200   \n",
       "13                    Syngenta           Basel   10 681        779   \n",
       "14                     Xstrata             Zug   10 609      2 249   \n",
       "15                    Swisscom            Bern    9 732      2 346   \n",
       "16                   Schindler          Ebikon    8 870        401   \n",
       "17       Atel / Motor-Columbus           Olten    8 580        413   \n",
       "18               Alstom Suisse           Baden    8 500              \n",
       "19                   Panalpina           Basel    8 293        120   \n",
       "20                    Liebherr           Bulle    8 270              \n",
       "21                    Clariant         Muttenz    8 181        192   \n",
       "22                    La Poste            Bern    7 499        811   \n",
       "23          DKSH Management AG          Zurich    7 454              \n",
       "24                        Ciba           Basel    7 419       -256   \n",
       "25                         CFF            Bern    7 087       -166   \n",
       "26                        Axpo           Baden    6 716        571   \n",
       "27                   Richemont          Geneva    6 716              \n",
       "28               Globus-Cosmos      Montagnola    5 600              \n",
       "29                      Swatch          Bienne    4 497        621   \n",
       "30                      Fenaco            Bern    4 380         54   \n",
       "...                        ...             ...      ...        ...   \n",
       "71                     Sunrise          Zurich    1 991        208   \n",
       "72                  ALSO Group       Hergiswil    1 980         17   \n",
       "73                      Franke         Aarburg    1 959              \n",
       "74              Mettler-Toledo      Greifensee    1 953        143   \n",
       "75                   Emil Frey          Zurich    1 950              \n",
       "76           Bucher Industries  Niederweningen    1 948         86   \n",
       "77             BKW FMB Energie            Bern    1 931        306   \n",
       "78                     Geberit      Rapperswil    1 922              \n",
       "79                   Hotelplan      Glattbrugg    1 728         16   \n",
       "80                 Esso Suisse          Zurich    1 720              \n",
       "81                       Forbo            Baar    1 702              \n",
       "82                      Nuance      Glattbrugg    1 690              \n",
       "83                    Cementia          Zurich    1 650              \n",
       "84                   BP Suisse             Zug    1 634         32   \n",
       "85                      Unaxis       Pfäffikon    1 605              \n",
       "86         SRG SSR idée suisse            Bern    1 591       -0.3   \n",
       "87                       Bobst          Prilly    1 591         46   \n",
       "88      Hewlett-Packard Suisse       Dübendorf    1 550              \n",
       "89                Krupp Presta          Eschen    1 550              \n",
       "90                Allied Steel          Lugano    1 519         33   \n",
       "91                      Bühler           Uzwil    1 502         72   \n",
       "92                   Swissport         Opfikon    1 499              \n",
       "93                      Migrol          Zurich    1 496              \n",
       "94                Shell Suisse            Baar    1 466              \n",
       "95                        Bell           Basel    1 443         35   \n",
       "96      DaimlerChrysler Suisse       Schlieren    1 427              \n",
       "97                       Sicpa          Prilly    1 400              \n",
       "98                  BMW Suisse       Dielsdorf    1 392              \n",
       "99               Steiner Group          Zurich    1 379              \n",
       "100                EOS Holding        Lausanne    1 371         51   \n",
       "\n",
       "       Employees                           Industry                Director  \n",
       "Rank                                                                         \n",
       "1     181 000[1]                  commodity trading                          \n",
       "2        253 000                   agriculture/food  Peter Brabeck-Letmathe  \n",
       "3         90 924            chemical/pharmaceutical                          \n",
       "4         68 218            chemical/pharmaceutical                          \n",
       "5        104 000                        engineering                          \n",
       "6         33 000                       temp workers                          \n",
       "7         59 934                    retail/services                          \n",
       "8         59 901             construction materials                          \n",
       "9            475                  commodity trading                          \n",
       "10        37 370                    retail/services                          \n",
       "11        25 607  international transport/logistics                          \n",
       "12                                        petroleum                          \n",
       "13        19 337            chemical/pharmaceutical                          \n",
       "14        17 000                             mining                          \n",
       "15        16 088                 telecommunications                          \n",
       "16        40 385                        engineering                          \n",
       "17         8 649     energy production/distribution                          \n",
       "18         4 500          engineering/manufacturing                          \n",
       "19        13 583   international shipping/logistics                          \n",
       "20        23 762                        engineering                          \n",
       "21        23 383            chemical/pharmaceutical                          \n",
       "22        41 073                            service                          \n",
       "23        20 500                      import/export                          \n",
       "24        19 105            chemical/pharmaceutical                          \n",
       "25        28 383         public transport/railroads                          \n",
       "26         2 990     energy production/distribution                          \n",
       "27                                                                           \n",
       "28         5 000              travel agency/tourism                          \n",
       "29        20 650                        watchmaking                          \n",
       "30         7 244                             retail                          \n",
       "...          ...                                ...                     ...  \n",
       "71         2 300                 telecommunications                          \n",
       "72           623                          computers                          \n",
       "73         7 040              electrical appliances                          \n",
       "74         8 700                              tools                          \n",
       "75         2 144           automobile sales/imports                          \n",
       "76         6 874                        engineering                          \n",
       "77         2 120     energy production/distribution                          \n",
       "78         5 162                                                             \n",
       "79         3 109              travel agency/tourism                          \n",
       "80           155                          petroleum                          \n",
       "81         5 538            carpets/floor coverings                          \n",
       "82         4 936                                                             \n",
       "83         6 000             construction materials                          \n",
       "84           134                          petroleum                          \n",
       "85         6 434                                                             \n",
       "86                                          service                          \n",
       "87         5 587                        engineering                          \n",
       "88         1 400                          computers                          \n",
       "89         4 600                        engineering                          \n",
       "90            70                      import/export                          \n",
       "91         6 266                        engineering                          \n",
       "92        21 000                            service                          \n",
       "93           285                          petroleum                          \n",
       "94           171                          petroleum                          \n",
       "95         3 326                      meat products                          \n",
       "96           403           automobile sales/imports                          \n",
       "97         3 400          chemicals/pharmaceuticals                          \n",
       "98           299           automobile sales/imports                          \n",
       "99           500                general contractors                          \n",
       "100          333     energy production/distribution                          \n",
       "\n",
       "[100 rows x 7 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def set_rank_as_index(df, colname='Rank'):\n",
    "    if df[colname].dtype==object:\n",
    "        df[colname] = df[colname].apply(lambda x: int(x.split('.')[0]))\n",
    "        df.set_index(colname, inplace=True)\n",
    "\n",
    "set_rank_as_index(largest_companies)\n",
    "largest_companies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name            object\n",
       "Headquarters    object\n",
       "Revenue         object\n",
       "Net income      object\n",
       "Employees       object\n",
       "Industry        object\n",
       "Director        object\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_companies.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name             object\n",
       "Headquarters     object\n",
       "Revenue           int64\n",
       "Net income      float64\n",
       "Employees       float64\n",
       "Industry         object\n",
       "Director         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def custom_to_numeric(column, silently=True):\n",
    "    if column.dtype != object:\n",
    "        return column\n",
    "    \n",
    "    # Clean cells\n",
    "    def clean(s: str):\n",
    "        # Remove spaces\n",
    "        s = ''.join(s.split())\n",
    "        \n",
    "        # Removes reference (`[d]`)\n",
    "        return s.split('[')[0]\n",
    "    \n",
    "    c = column.apply(clean)\n",
    "    \n",
    "    # Convert to int\n",
    "    conversion_force = 'coerc' if silently else 'raise'\n",
    "    return pd.to_numeric(c, conversion_force)\n",
    "    \n",
    "col_to_convert = ['Revenue', 'Net income', 'Employees']\n",
    "\n",
    "for c in col_to_convert:\n",
    "    largest_companies[c] = custom_to_numeric(largest_companies[c], False)\n",
    "\n",
    "largest_companies.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Where the fields look well parsed.\n",
    "\n",
    "## Largest banks\n",
    "Let do it again for largest banks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Ranked</th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Total assets</th>\n",
       "      <th>Income</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.</td>\n",
       "      <td>UBS</td>\n",
       "      <td>Basel</td>\n",
       "      <td>2 060 250</td>\n",
       "      <td>14 690</td>\n",
       "      <td>69 569</td>\n",
       "      <td>Marcel Ospel, Basler, 2008 abgewählt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.</td>\n",
       "      <td>Credit Suisse</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 339 052</td>\n",
       "      <td>5 850</td>\n",
       "      <td>63 523</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.</td>\n",
       "      <td>Raiffeisen</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>108 187</td>\n",
       "      <td>608</td>\n",
       "      <td>6 549</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.</td>\n",
       "      <td>Zürcher Kantonalbank</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>85 914</td>\n",
       "      <td>810</td>\n",
       "      <td>4 276</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.</td>\n",
       "      <td>HSBC Private Bank (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>54 012</td>\n",
       "      <td>374</td>\n",
       "      <td>1 929</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.</td>\n",
       "      <td>BNP Paribas (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>37 657</td>\n",
       "      <td>309</td>\n",
       "      <td>1 736</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.</td>\n",
       "      <td>Banque cantonale vaudoise</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>34 875</td>\n",
       "      <td>457</td>\n",
       "      <td>2 349</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.</td>\n",
       "      <td>Julius Baer Group</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28 648</td>\n",
       "      <td>144</td>\n",
       "      <td>3 427</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.</td>\n",
       "      <td>Banque Migros</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28 000</td>\n",
       "      <td>87</td>\n",
       "      <td>1 124</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.</td>\n",
       "      <td>Basler Kantonalbank</td>\n",
       "      <td>Basel</td>\n",
       "      <td>24 654</td>\n",
       "      <td>263</td>\n",
       "      <td>1 348</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11.</td>\n",
       "      <td>Crédit Agricole (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>24 512</td>\n",
       "      <td>154</td>\n",
       "      <td>1 119</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12.</td>\n",
       "      <td>Berner Kantonalbank</td>\n",
       "      <td>Bern</td>\n",
       "      <td>20 724</td>\n",
       "      <td>85</td>\n",
       "      <td>1 441</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13.</td>\n",
       "      <td>Saint Galler Kantonalbank</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>19 117</td>\n",
       "      <td>168</td>\n",
       "      <td>957</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14.</td>\n",
       "      <td>Luzerner Kantonalbank</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>18 879</td>\n",
       "      <td>120</td>\n",
       "      <td>951</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15.</td>\n",
       "      <td>Coutts Bank von Ernst</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>18 799</td>\n",
       "      <td>44</td>\n",
       "      <td>975</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16.</td>\n",
       "      <td>Neur Aargauer Bank</td>\n",
       "      <td>Aarau</td>\n",
       "      <td>17 526</td>\n",
       "      <td>138</td>\n",
       "      <td>797</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17.</td>\n",
       "      <td>Valiant Holding AG</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>17 138</td>\n",
       "      <td>122</td>\n",
       "      <td>960</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18.</td>\n",
       "      <td>Union Bancaire Privée</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>15 901</td>\n",
       "      <td>326</td>\n",
       "      <td>1 168</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19.</td>\n",
       "      <td>Aargauische Kantonalbank</td>\n",
       "      <td>Laufenburg</td>\n",
       "      <td>15 546</td>\n",
       "      <td>84</td>\n",
       "      <td>641</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20.</td>\n",
       "      <td></td>\n",
       "      <td>Lugano</td>\n",
       "      <td>15 237</td>\n",
       "      <td>82</td>\n",
       "      <td>1 150</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Ranked                        Name Headquarters Total assets  Income  \\\n",
       "0      1.                         UBS        Basel    2 060 250  14 690   \n",
       "1      2.               Credit Suisse       Zurich    1 339 052   5 850   \n",
       "2      3.                  Raiffeisen   St. Gallen      108 187     608   \n",
       "3      4.        Zürcher Kantonalbank       Zurich       85 914     810   \n",
       "4      5.  HSBC Private Bank (Suisse)       Geneva       54 012     374   \n",
       "5      6.        BNP Paribas (Suisse)       Geneva       37 657     309   \n",
       "6      7.   Banque cantonale vaudoise     Lausanne       34 875     457   \n",
       "7      8.           Julius Baer Group       Zurich       28 648     144   \n",
       "8      9.               Banque Migros       Zurich       28 000      87   \n",
       "9     10.         Basler Kantonalbank        Basel       24 654     263   \n",
       "10    11.    Crédit Agricole (Suisse)       Geneva       24 512     154   \n",
       "11    12.         Berner Kantonalbank         Bern       20 724      85   \n",
       "12    13.   Saint Galler Kantonalbank   St. Gallen       19 117     168   \n",
       "13    14.       Luzerner Kantonalbank      Lucerne       18 879     120   \n",
       "14    15.       Coutts Bank von Ernst       Zurich       18 799      44   \n",
       "15    16.          Neur Aargauer Bank        Aarau       17 526     138   \n",
       "16    17.          Valiant Holding AG      Lucerne       17 138     122   \n",
       "17    18.       Union Bancaire Privée       Geneva       15 901     326   \n",
       "18    19.    Aargauische Kantonalbank   Laufenburg       15 546      84   \n",
       "19    20.                                   Lugano       15 237      82   \n",
       "\n",
       "   Employees                               Manager  \n",
       "0     69 569  Marcel Ospel, Basler, 2008 abgewählt  \n",
       "1     63 523                                        \n",
       "2      6 549                                        \n",
       "3      4 276                                        \n",
       "4      1 929                                        \n",
       "5      1 736                                        \n",
       "6      2 349                                        \n",
       "7      3 427                                        \n",
       "8      1 124                                        \n",
       "9      1 348                                        \n",
       "10     1 119                                        \n",
       "11     1 441                                        \n",
       "12       957                                        \n",
       "13       951                                        \n",
       "14       975                                        \n",
       "15       797                                        \n",
       "16       960                                        \n",
       "17     1 168                                        \n",
       "18       641                                        \n",
       "19     1 150                                        "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_banks = found_tables[1]\n",
    "largest_banks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Total assets</th>\n",
       "      <th>Income</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ranked</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>UBS</td>\n",
       "      <td>Basel</td>\n",
       "      <td>2 060 250</td>\n",
       "      <td>14 690</td>\n",
       "      <td>69 569</td>\n",
       "      <td>Marcel Ospel, Basler, 2008 abgewählt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Credit Suisse</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1 339 052</td>\n",
       "      <td>5 850</td>\n",
       "      <td>63 523</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Raiffeisen</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>108 187</td>\n",
       "      <td>608</td>\n",
       "      <td>6 549</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Zürcher Kantonalbank</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>85 914</td>\n",
       "      <td>810</td>\n",
       "      <td>4 276</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>HSBC Private Bank (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>54 012</td>\n",
       "      <td>374</td>\n",
       "      <td>1 929</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BNP Paribas (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>37 657</td>\n",
       "      <td>309</td>\n",
       "      <td>1 736</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Banque cantonale vaudoise</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>34 875</td>\n",
       "      <td>457</td>\n",
       "      <td>2 349</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Julius Baer Group</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28 648</td>\n",
       "      <td>144</td>\n",
       "      <td>3 427</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Banque Migros</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28 000</td>\n",
       "      <td>87</td>\n",
       "      <td>1 124</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Basler Kantonalbank</td>\n",
       "      <td>Basel</td>\n",
       "      <td>24 654</td>\n",
       "      <td>263</td>\n",
       "      <td>1 348</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Crédit Agricole (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>24 512</td>\n",
       "      <td>154</td>\n",
       "      <td>1 119</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Berner Kantonalbank</td>\n",
       "      <td>Bern</td>\n",
       "      <td>20 724</td>\n",
       "      <td>85</td>\n",
       "      <td>1 441</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Saint Galler Kantonalbank</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>19 117</td>\n",
       "      <td>168</td>\n",
       "      <td>957</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Luzerner Kantonalbank</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>18 879</td>\n",
       "      <td>120</td>\n",
       "      <td>951</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Coutts Bank von Ernst</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>18 799</td>\n",
       "      <td>44</td>\n",
       "      <td>975</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Neur Aargauer Bank</td>\n",
       "      <td>Aarau</td>\n",
       "      <td>17 526</td>\n",
       "      <td>138</td>\n",
       "      <td>797</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Valiant Holding AG</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>17 138</td>\n",
       "      <td>122</td>\n",
       "      <td>960</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Union Bancaire Privée</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>15 901</td>\n",
       "      <td>326</td>\n",
       "      <td>1 168</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Aargauische Kantonalbank</td>\n",
       "      <td>Laufenburg</td>\n",
       "      <td>15 546</td>\n",
       "      <td>84</td>\n",
       "      <td>641</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td></td>\n",
       "      <td>Lugano</td>\n",
       "      <td>15 237</td>\n",
       "      <td>82</td>\n",
       "      <td>1 150</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Name Headquarters Total assets  Income  \\\n",
       "Ranked                                                                 \n",
       "1                              UBS        Basel    2 060 250  14 690   \n",
       "2                    Credit Suisse       Zurich    1 339 052   5 850   \n",
       "3                       Raiffeisen   St. Gallen      108 187     608   \n",
       "4             Zürcher Kantonalbank       Zurich       85 914     810   \n",
       "5       HSBC Private Bank (Suisse)       Geneva       54 012     374   \n",
       "6             BNP Paribas (Suisse)       Geneva       37 657     309   \n",
       "7        Banque cantonale vaudoise     Lausanne       34 875     457   \n",
       "8                Julius Baer Group       Zurich       28 648     144   \n",
       "9                    Banque Migros       Zurich       28 000      87   \n",
       "10             Basler Kantonalbank        Basel       24 654     263   \n",
       "11        Crédit Agricole (Suisse)       Geneva       24 512     154   \n",
       "12             Berner Kantonalbank         Bern       20 724      85   \n",
       "13       Saint Galler Kantonalbank   St. Gallen       19 117     168   \n",
       "14           Luzerner Kantonalbank      Lucerne       18 879     120   \n",
       "15           Coutts Bank von Ernst       Zurich       18 799      44   \n",
       "16              Neur Aargauer Bank        Aarau       17 526     138   \n",
       "17              Valiant Holding AG      Lucerne       17 138     122   \n",
       "18           Union Bancaire Privée       Geneva       15 901     326   \n",
       "19        Aargauische Kantonalbank   Laufenburg       15 546      84   \n",
       "20                                       Lugano       15 237      82   \n",
       "\n",
       "       Employees                               Manager  \n",
       "Ranked                                                  \n",
       "1         69 569  Marcel Ospel, Basler, 2008 abgewählt  \n",
       "2         63 523                                        \n",
       "3          6 549                                        \n",
       "4          4 276                                        \n",
       "5          1 929                                        \n",
       "6          1 736                                        \n",
       "7          2 349                                        \n",
       "8          3 427                                        \n",
       "9          1 124                                        \n",
       "10         1 348                                        \n",
       "11         1 119                                        \n",
       "12         1 441                                        \n",
       "13           957                                        \n",
       "14           951                                        \n",
       "15           975                                        \n",
       "16           797                                        \n",
       "17           960                                        \n",
       "18         1 168                                        \n",
       "19           641                                        \n",
       "20         1 150                                        "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set_rank_as_index(largest_banks, 'Ranked')\n",
    "largest_banks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Total assets</th>\n",
       "      <th>Income</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ranked</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>UBS</td>\n",
       "      <td>Basel</td>\n",
       "      <td>2060250</td>\n",
       "      <td>14690</td>\n",
       "      <td>69569</td>\n",
       "      <td>Marcel Ospel, Basler, 2008 abgewählt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Credit Suisse</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>1339052</td>\n",
       "      <td>5850</td>\n",
       "      <td>63523</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Raiffeisen</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>108187</td>\n",
       "      <td>608</td>\n",
       "      <td>6549</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Zürcher Kantonalbank</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>85914</td>\n",
       "      <td>810</td>\n",
       "      <td>4276</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>HSBC Private Bank (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>54012</td>\n",
       "      <td>374</td>\n",
       "      <td>1929</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BNP Paribas (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>37657</td>\n",
       "      <td>309</td>\n",
       "      <td>1736</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Banque cantonale vaudoise</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>34875</td>\n",
       "      <td>457</td>\n",
       "      <td>2349</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Julius Baer Group</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28648</td>\n",
       "      <td>144</td>\n",
       "      <td>3427</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Banque Migros</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>28000</td>\n",
       "      <td>87</td>\n",
       "      <td>1124</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Basler Kantonalbank</td>\n",
       "      <td>Basel</td>\n",
       "      <td>24654</td>\n",
       "      <td>263</td>\n",
       "      <td>1348</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Crédit Agricole (Suisse)</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>24512</td>\n",
       "      <td>154</td>\n",
       "      <td>1119</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Berner Kantonalbank</td>\n",
       "      <td>Bern</td>\n",
       "      <td>20724</td>\n",
       "      <td>85</td>\n",
       "      <td>1441</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Saint Galler Kantonalbank</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>19117</td>\n",
       "      <td>168</td>\n",
       "      <td>957</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Luzerner Kantonalbank</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>18879</td>\n",
       "      <td>120</td>\n",
       "      <td>951</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Coutts Bank von Ernst</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>18799</td>\n",
       "      <td>44</td>\n",
       "      <td>975</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Neur Aargauer Bank</td>\n",
       "      <td>Aarau</td>\n",
       "      <td>17526</td>\n",
       "      <td>138</td>\n",
       "      <td>797</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Valiant Holding AG</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>17138</td>\n",
       "      <td>122</td>\n",
       "      <td>960</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Union Bancaire Privée</td>\n",
       "      <td>Geneva</td>\n",
       "      <td>15901</td>\n",
       "      <td>326</td>\n",
       "      <td>1168</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Aargauische Kantonalbank</td>\n",
       "      <td>Laufenburg</td>\n",
       "      <td>15546</td>\n",
       "      <td>84</td>\n",
       "      <td>641</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td></td>\n",
       "      <td>Lugano</td>\n",
       "      <td>15237</td>\n",
       "      <td>82</td>\n",
       "      <td>1150</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Name Headquarters  Total assets  Income  \\\n",
       "Ranked                                                                  \n",
       "1                              UBS        Basel       2060250   14690   \n",
       "2                    Credit Suisse       Zurich       1339052    5850   \n",
       "3                       Raiffeisen   St. Gallen        108187     608   \n",
       "4             Zürcher Kantonalbank       Zurich         85914     810   \n",
       "5       HSBC Private Bank (Suisse)       Geneva         54012     374   \n",
       "6             BNP Paribas (Suisse)       Geneva         37657     309   \n",
       "7        Banque cantonale vaudoise     Lausanne         34875     457   \n",
       "8                Julius Baer Group       Zurich         28648     144   \n",
       "9                    Banque Migros       Zurich         28000      87   \n",
       "10             Basler Kantonalbank        Basel         24654     263   \n",
       "11        Crédit Agricole (Suisse)       Geneva         24512     154   \n",
       "12             Berner Kantonalbank         Bern         20724      85   \n",
       "13       Saint Galler Kantonalbank   St. Gallen         19117     168   \n",
       "14           Luzerner Kantonalbank      Lucerne         18879     120   \n",
       "15           Coutts Bank von Ernst       Zurich         18799      44   \n",
       "16              Neur Aargauer Bank        Aarau         17526     138   \n",
       "17              Valiant Holding AG      Lucerne         17138     122   \n",
       "18           Union Bancaire Privée       Geneva         15901     326   \n",
       "19        Aargauische Kantonalbank   Laufenburg         15546      84   \n",
       "20                                       Lugano         15237      82   \n",
       "\n",
       "        Employees                               Manager  \n",
       "Ranked                                                   \n",
       "1           69569  Marcel Ospel, Basler, 2008 abgewählt  \n",
       "2           63523                                        \n",
       "3            6549                                        \n",
       "4            4276                                        \n",
       "5            1929                                        \n",
       "6            1736                                        \n",
       "7            2349                                        \n",
       "8            3427                                        \n",
       "9            1124                                        \n",
       "10           1348                                        \n",
       "11           1119                                        \n",
       "12           1441                                        \n",
       "13            957                                        \n",
       "14            951                                        \n",
       "15            975                                        \n",
       "16            797                                        \n",
       "17            960                                        \n",
       "18           1168                                        \n",
       "19            641                                        \n",
       "20           1150                                        "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_to_convert = ['Total assets', 'Income', 'Employees']\n",
    "for c in col_to_convert:\n",
    "    largest_banks[c] = custom_to_numeric(largest_banks[c])\n",
    "    \n",
    "largest_banks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name            object\n",
       "Headquarters    object\n",
       "Total assets     int64\n",
       "Income           int64\n",
       "Employees        int64\n",
       "Manager         object\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_banks.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## And once again for insurances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Rang</th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Ranked by gross inflow of premimus</th>\n",
       "      <th>Net profit</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.</td>\n",
       "      <td>Zurich Financial Services</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>61 678</td>\n",
       "      <td>4 388</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.</td>\n",
       "      <td>Swiss Re</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>27 779</td>\n",
       "      <td>1 451</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.</td>\n",
       "      <td>Winterthur Group</td>\n",
       "      <td>Winterthur</td>\n",
       "      <td>21 269</td>\n",
       "      <td>1 061</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.</td>\n",
       "      <td>Swiss Life</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>20 211</td>\n",
       "      <td>874</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.</td>\n",
       "      <td>Bâloise</td>\n",
       "      <td>Basel</td>\n",
       "      <td>6 839</td>\n",
       "      <td>403</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.</td>\n",
       "      <td>Helvetia Patria</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>5 176</td>\n",
       "      <td>301</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7.</td>\n",
       "      <td>Suva</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>4 149</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.</td>\n",
       "      <td>Groupe Allianz (Suisse)</td>\n",
       "      <td></td>\n",
       "      <td>3 631</td>\n",
       "      <td>258</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9.</td>\n",
       "      <td>La Mobilière</td>\n",
       "      <td>Bern</td>\n",
       "      <td>2 608</td>\n",
       "      <td>272</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10.</td>\n",
       "      <td>Vaudoise Assurances</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>1 955</td>\n",
       "      <td>44</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Rang                       Name Headquarters  \\\n",
       "0   1.  Zurich Financial Services       Zurich   \n",
       "1   2.                   Swiss Re       Zurich   \n",
       "2   3.           Winterthur Group   Winterthur   \n",
       "3   4.                 Swiss Life       Zurich   \n",
       "4   5.                    Bâloise        Basel   \n",
       "5   6.            Helvetia Patria   St. Gallen   \n",
       "6   7.                       Suva      Lucerne   \n",
       "7   8.    Groupe Allianz (Suisse)                \n",
       "8   9.               La Mobilière         Bern   \n",
       "9  10.        Vaudoise Assurances     Lausanne   \n",
       "\n",
       "  Ranked by gross inflow of premimus Net profit Employees Manager  \n",
       "0                             61 678      4 388                    \n",
       "1                             27 779      1 451                    \n",
       "2                             21 269      1 061                    \n",
       "3                             20 211        874                    \n",
       "4                              6 839        403                    \n",
       "5                              5 176        301                    \n",
       "6                              4 149                               \n",
       "7                              3 631        258                    \n",
       "8                              2 608        272                    \n",
       "9                              1 955         44                    "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_insurances = found_tables[2]\n",
    "largest_insurances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Ranked by gross inflow of premimus</th>\n",
       "      <th>Net profit</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rang</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Zurich Financial Services</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>61 678</td>\n",
       "      <td>4 388</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Swiss Re</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>27 779</td>\n",
       "      <td>1 451</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Winterthur Group</td>\n",
       "      <td>Winterthur</td>\n",
       "      <td>21 269</td>\n",
       "      <td>1 061</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Swiss Life</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>20 211</td>\n",
       "      <td>874</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bâloise</td>\n",
       "      <td>Basel</td>\n",
       "      <td>6 839</td>\n",
       "      <td>403</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Helvetia Patria</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>5 176</td>\n",
       "      <td>301</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Suva</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>4 149</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Groupe Allianz (Suisse)</td>\n",
       "      <td></td>\n",
       "      <td>3 631</td>\n",
       "      <td>258</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>La Mobilière</td>\n",
       "      <td>Bern</td>\n",
       "      <td>2 608</td>\n",
       "      <td>272</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Vaudoise Assurances</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>1 955</td>\n",
       "      <td>44</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Name Headquarters  \\\n",
       "Rang                                           \n",
       "1     Zurich Financial Services       Zurich   \n",
       "2                      Swiss Re       Zurich   \n",
       "3              Winterthur Group   Winterthur   \n",
       "4                    Swiss Life       Zurich   \n",
       "5                       Bâloise        Basel   \n",
       "6               Helvetia Patria   St. Gallen   \n",
       "7                          Suva      Lucerne   \n",
       "8       Groupe Allianz (Suisse)                \n",
       "9                  La Mobilière         Bern   \n",
       "10          Vaudoise Assurances     Lausanne   \n",
       "\n",
       "     Ranked by gross inflow of premimus Net profit Employees Manager  \n",
       "Rang                                                                  \n",
       "1                                61 678      4 388                    \n",
       "2                                27 779      1 451                    \n",
       "3                                21 269      1 061                    \n",
       "4                                20 211        874                    \n",
       "5                                 6 839        403                    \n",
       "6                                 5 176        301                    \n",
       "7                                 4 149                               \n",
       "8                                 3 631        258                    \n",
       "9                                 2 608        272                    \n",
       "10                                1 955         44                    "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set_rank_as_index(largest_insurances, 'Rang')\n",
    "largest_insurances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Headquarters</th>\n",
       "      <th>Ranked by gross inflow of premimus</th>\n",
       "      <th>Net profit</th>\n",
       "      <th>Employees</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Rang</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Zurich Financial Services</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>61678</td>\n",
       "      <td>4388.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Swiss Re</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>27779</td>\n",
       "      <td>1451.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Winterthur Group</td>\n",
       "      <td>Winterthur</td>\n",
       "      <td>21269</td>\n",
       "      <td>1061.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Swiss Life</td>\n",
       "      <td>Zurich</td>\n",
       "      <td>20211</td>\n",
       "      <td>874.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bâloise</td>\n",
       "      <td>Basel</td>\n",
       "      <td>6839</td>\n",
       "      <td>403.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Helvetia Patria</td>\n",
       "      <td>St. Gallen</td>\n",
       "      <td>5176</td>\n",
       "      <td>301.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Suva</td>\n",
       "      <td>Lucerne</td>\n",
       "      <td>4149</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Groupe Allianz (Suisse)</td>\n",
       "      <td></td>\n",
       "      <td>3631</td>\n",
       "      <td>258.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>La Mobilière</td>\n",
       "      <td>Bern</td>\n",
       "      <td>2608</td>\n",
       "      <td>272.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Vaudoise Assurances</td>\n",
       "      <td>Lausanne</td>\n",
       "      <td>1955</td>\n",
       "      <td>44.0</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Name Headquarters  \\\n",
       "Rang                                           \n",
       "1     Zurich Financial Services       Zurich   \n",
       "2                      Swiss Re       Zurich   \n",
       "3              Winterthur Group   Winterthur   \n",
       "4                    Swiss Life       Zurich   \n",
       "5                       Bâloise        Basel   \n",
       "6               Helvetia Patria   St. Gallen   \n",
       "7                          Suva      Lucerne   \n",
       "8       Groupe Allianz (Suisse)                \n",
       "9                  La Mobilière         Bern   \n",
       "10          Vaudoise Assurances     Lausanne   \n",
       "\n",
       "      Ranked by gross inflow of premimus  Net profit Employees Manager  \n",
       "Rang                                                                    \n",
       "1                                  61678      4388.0                    \n",
       "2                                  27779      1451.0                    \n",
       "3                                  21269      1061.0                    \n",
       "4                                  20211       874.0                    \n",
       "5                                   6839       403.0                    \n",
       "6                                   5176       301.0                    \n",
       "7                                   4149         NaN                    \n",
       "8                                   3631       258.0                    \n",
       "9                                   2608       272.0                    \n",
       "10                                  1955        44.0                    "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "col_to_convert = ['Ranked by gross inflow of premimus', 'Net profit']\n",
    "for c in col_to_convert:\n",
    "    largest_insurances[c] = custom_to_numeric(largest_insurances[c])\n",
    "    \n",
    "largest_insurances"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                                   object\n",
       "Headquarters                           object\n",
       "Ranked by gross inflow of premimus      int64\n",
       "Net profit                            float64\n",
       "Employees                              object\n",
       "Manager                                object\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "largest_insurances.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Save scrape data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "DATA_DIR = 'data'\n",
    "\n",
    "if not os.path.exists(DATA_DIR):\n",
    "    print('Create data directory')\n",
    "    os.mkdir(DATA_DIR)\n",
    "    \n",
    "to_save = {\n",
    "    'largest_companies.csv': largest_companies,\n",
    "    'largest_insurances.csv': largest_insurances,\n",
    "    'largest_banks.csv': largest_banks,\n",
    "}\n",
    "\n",
    "for k, v in to_save.items():\n",
    "    path = os.path.join(DATA_DIR, k)\n",
    "    v.to_csv(path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}