BeautifulSoup4.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Web Scraping With BeautifulSoup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Source:  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "https://www.lseg.com/resources/1000-companies-inspire/2018-report-1000-companies-uk/search-1000-companies-uk-2018?results_per_page=1000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#import dependencies\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import csv\n",
    "from urllib.request import urlopen "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "url='https://www.lseg.com/resources/1000-companies-inspire/2018-report-1000-companies-uk/search-1000-companies-uk-2018?results_per_page=1000'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "souce = urlopen(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(souce,'html.parser')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Title"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Search 1000 companies UK - 2018 | London Stock Exchange Group\n"
     ]
    }
   ],
   "source": [
    "print(soup.title.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Company Details in the class named panel-row-text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "container = soup.findAll('span', {'class': 'panel-row-text'})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Details of first Company :"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<span class=\"panel-row-text\">1PM PLC</span>\n",
      "<span class=\"panel-row-text\">http://www.1pm.co.uk/Contact-1pm</span>\n",
      "<span class=\"panel-row-text\">Financial services</span>\n",
      "<span class=\"panel-row-text\">South West England</span>\n",
      "<span class=\"panel-row-text\">£10M - £20M</span>\n"
     ]
    }
   ],
   "source": [
    "for i in range(0,5):\n",
    "    print(container[i])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#lists\n",
    "A=[]\n",
    "B=[]\n",
    "C=[]\n",
    "D=[]\n",
    "E=[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#storing Data in desired list\n",
    "for i in range(0,len(container),5):\n",
    "    A.append(container[i].text)\n",
    "    B.append(container[i+1].text)\n",
    "    C.append(container[i+2].text)\n",
    "    D.append(container[i+3].text)\n",
    "    E.append(container[i+4].text)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Inserting list in the *Comp* Data frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "Comp = pd.DataFrame(data = A, columns = ['Company name'])\n",
    "Comp['Website']=B\n",
    "Comp['Sector']=C\n",
    "Comp['Region']=D\n",
    "Comp['Revenue Band']=E"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Company name</th>\n",
       "      <th>Website</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Region</th>\n",
       "      <th>Revenue Band</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1PM PLC</td>\n",
       "      <td>http://www.1pm.co.uk/Contact-1pm</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>South West England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>24 X 7 LTD.</td>\n",
       "      <td>http://www.24x7ltd.co.uk/index.php</td>\n",
       "      <td>Transportation services</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3T LOGISTICS HOLDINGS LIMITED</td>\n",
       "      <td>http://www.3t-europe.com</td>\n",
       "      <td>Transportation services</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3T'S LEISURE LTD.</td>\n",
       "      <td>http://www.surfbayleisure.co.uk/</td>\n",
       "      <td>Leisure</td>\n",
       "      <td>South West England</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A P P WHOLESALE PLC</td>\n",
       "      <td>https://www.appwholesaleplc.co.uk</td>\n",
       "      <td>Wholesale</td>\n",
       "      <td>London</td>\n",
       "      <td>£100M - £150M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A R DEMOLITION LIMITED</td>\n",
       "      <td>http://www.ardemolition.co.uk</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A. &amp; J. STEPHEN (HOLDINGS) LIMITED</td>\n",
       "      <td>https://www.stephen.co.uk/</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>A. MIR &amp; CO. LIMITED</td>\n",
       "      <td>http://www.a-mir.co.uk</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>A.&amp; E.ELKINS LIMITED</td>\n",
       "      <td>http://aeelkins.co.uk</td>\n",
       "      <td>Building &amp; Landscape services</td>\n",
       "      <td>London</td>\n",
       "      <td>£40M - £50M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>A.EDMONDS &amp; CO.LIMITED</td>\n",
       "      <td>http://www.edmonds.uk.com</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>A.J.N. STEELSTOCK LTD.</td>\n",
       "      <td>https://www.ajnsteelstock.co.uk/</td>\n",
       "      <td>Transportation services</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£75M - £100M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AA WOODS HOLDINGS LIMITED</td>\n",
       "      <td>http://aawoods.co.uk/</td>\n",
       "      <td>Waste Management</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ABSOLUTE APPAREL LIMITED</td>\n",
       "      <td>http://www.absoluteapparel.co.uk</td>\n",
       "      <td>Wholesale</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ABZENA PLC</td>\n",
       "      <td>http://www.abzena.com</td>\n",
       "      <td>Pharmaceuticals &amp; Biotechnology</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ACCORA LIMITED</td>\n",
       "      <td>http://www.accora.uk.com</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>MAST GROUP LIMITED</td>\n",
       "      <td>http://www.mastgrp.com/</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>North West England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ACM GROUP LIMITED</td>\n",
       "      <td>https://www.alphacapitalmarkets.co.uk</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>South East England</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>ACORNE LIMITED</td>\n",
       "      <td>https://www.acorne.co.uk</td>\n",
       "      <td>Professional services</td>\n",
       "      <td>South East England</td>\n",
       "      <td>£40M - £50M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ACTIVE FLOORING SOLUTIONS LIMITED</td>\n",
       "      <td>http://www.active-flooring.com</td>\n",
       "      <td>Building &amp; Landscape services</td>\n",
       "      <td>North West England</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ACTURIS GROUP LIMITED</td>\n",
       "      <td>http://www.acturis.com</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>London</td>\n",
       "      <td>£50M - £75M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>ADAMS AVIATION SUPPLY COMPANY LIMITED</td>\n",
       "      <td>http://www.adamsaviation.com</td>\n",
       "      <td>Wholesale</td>\n",
       "      <td>South East England</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>ADEPT CARE HOMES LIMITED</td>\n",
       "      <td>http://adeptcarehomes.co.uk</td>\n",
       "      <td>Healthcare</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>ADEY HOLDINGS LIMITED</td>\n",
       "      <td>http://www.adeysteelgroup.co.uk</td>\n",
       "      <td>Metal Manufacturing &amp; Engineering</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>ADT WORKPLACE LIMITED</td>\n",
       "      <td>http://www.adtworkplace.com/</td>\n",
       "      <td>Architecture &amp; Engineering</td>\n",
       "      <td>North West England</td>\n",
       "      <td>£30M - £40M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>ADVANCE CONSTRUCTION GROUP LIMITED</td>\n",
       "      <td>http://advance-groupltd.com/</td>\n",
       "      <td>Engineering &amp; Construction</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>£150M - £200M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>ADVANCED INSULATION HOLDINGS LIMITED</td>\n",
       "      <td>http://www.advancedinsulation.com</td>\n",
       "      <td>Metal Manufacturing &amp; Engineering</td>\n",
       "      <td>South West England</td>\n",
       "      <td>£50M - £75M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>ADVENTURE FOREST GROUP LIMITED</td>\n",
       "      <td>https://goape.co.uk</td>\n",
       "      <td>Leisure</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£30M - £40M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AFI TOPCO LIMITED</td>\n",
       "      <td>http://www.afi-group.co.uk</td>\n",
       "      <td>Rental &amp; Leasing</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£50M - £75M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>AGC EQUITY PARTNERS LIMITED</td>\n",
       "      <td>http://agcequitypartners.com</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>London</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AGE PARTNERSHIP GROUP LIMITED</td>\n",
       "      <td>https://www.agepartnership.co.uk/</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>WEBB PLANT GROUP LTD</td>\n",
       "      <td>http://www.apwebbplanthire.co.uk/</td>\n",
       "      <td>Rental &amp; Leasing</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>WELLHOPPED LTD</td>\n",
       "      <td>http://www.charlesfaram.co.uk</td>\n",
       "      <td>Farming &amp; Fishery</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£30M - £40M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>WENZELS THE BAKERS LIMITED</td>\n",
       "      <td>https://www.wenzels.co.uk/</td>\n",
       "      <td>Food &amp; Beverage</td>\n",
       "      <td>London</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>WESTCOTT INVESTMENTS LIMITED</td>\n",
       "      <td>http://www.westcott.com</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>WESTGREEN CONSTRUCTION LTD</td>\n",
       "      <td>http://www.westgreen.com/</td>\n",
       "      <td>Architecture &amp; Engineering</td>\n",
       "      <td>London</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>WESTMORLAND LIMITED</td>\n",
       "      <td>http://www.westmorlandfamily.com</td>\n",
       "      <td>Retail</td>\n",
       "      <td>North West England</td>\n",
       "      <td>£75M - £100M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>WEX EUROPE LIMITED</td>\n",
       "      <td>http://www.wexeurope.com/</td>\n",
       "      <td>Financial services</td>\n",
       "      <td>London</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>WHITBY SEAFOODS LIMITED</td>\n",
       "      <td>https://www.whitby-seafoods.com</td>\n",
       "      <td>Food &amp; Beverage</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£50M - £75M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>WHITEMEADOW GROUP HOLDINGS LIMITED</td>\n",
       "      <td>https://www.whitemeadow.com/</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£40M - £50M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>WHYTE CRANES HOLDING LIMITED</td>\n",
       "      <td>http://www.whytecranes.com</td>\n",
       "      <td>Rental &amp; Leasing</td>\n",
       "      <td>Scotland</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>WIFINITY LIMITED</td>\n",
       "      <td>https://wifinity.co.uk</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>London</td>\n",
       "      <td>£6M - £10M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>WILD LIFE GROUP LIMITED</td>\n",
       "      <td>https://www.yorkshirewildlifepark.com/</td>\n",
       "      <td>Leisure</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>WILLIAM CROXSON &amp; SON,LIMITED</td>\n",
       "      <td>https://www.croxsons.com</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>London</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>WILLSHEE'S SKIP HIRE LIMITED</td>\n",
       "      <td>http://www.willshees.co.uk/</td>\n",
       "      <td>Waste Management</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>WILSON POWER SOLUTIONS GROUP LIMITED</td>\n",
       "      <td>http://www.wilsonpowersolutions.co.uk</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>WILSON'S AUCTIONS LIMITED</td>\n",
       "      <td>https://www.wilsonsauctions.com</td>\n",
       "      <td>Leisure</td>\n",
       "      <td>Northern Ireland</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>WILSONS FURNISHERS (HOLDINGS) LIMITED</td>\n",
       "      <td>http://www.wilsonscarpets.com/</td>\n",
       "      <td>Retail</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>WINDMILL ORGANICS LIMITED</td>\n",
       "      <td>http://www.windmillorganics.com/</td>\n",
       "      <td>Food &amp; Beverage</td>\n",
       "      <td>London</td>\n",
       "      <td>£40M - £50M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>WINNER RECRUITMENT (BIRMINGHAM) LTD</td>\n",
       "      <td>http://www.winnerrecruitment.co.uk/</td>\n",
       "      <td>Employment services</td>\n",
       "      <td>West Midlands</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>WINNING MOVES INTERNATIONAL LIMITED</td>\n",
       "      <td>https://www.winningmoves.co.uk/</td>\n",
       "      <td>Leisure</td>\n",
       "      <td>London</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>WOODFORD HEATING HOLDINGS LIMITED</td>\n",
       "      <td>http://www.woodfordheating.com</td>\n",
       "      <td>Energy &amp; Utility</td>\n",
       "      <td>East of England</td>\n",
       "      <td>£20M - £30M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>WOODLAND KITCHENS (N.I.) LIMITED</td>\n",
       "      <td>http://www.woodlandni.com</td>\n",
       "      <td>Manufacturing</td>\n",
       "      <td>Northern Ireland</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>WOODLANDS SITE SERVICES LIMITED</td>\n",
       "      <td>http://www.woodlands-ss.co.uk</td>\n",
       "      <td>Professional services</td>\n",
       "      <td>London</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>WORDSWORTH EXCAVATIONS LIMITED</td>\n",
       "      <td>http://www.wordsworthexcavations.co.uk</td>\n",
       "      <td>Building &amp; Landscape services</td>\n",
       "      <td>Yorkshire and the Humber</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>WORLDREMIT LTD.</td>\n",
       "      <td>https://www.worldremit.com</td>\n",
       "      <td>Information Technology</td>\n",
       "      <td>London</td>\n",
       "      <td>£40M - £50M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>WSR RECYCLING LIMITED</td>\n",
       "      <td>http://wsrrecycling.co.uk</td>\n",
       "      <td>Waste Management</td>\n",
       "      <td>North West England</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>XBITE LIMITED</td>\n",
       "      <td>http://www.xbite.co.uk/</td>\n",
       "      <td>Wholesale</td>\n",
       "      <td>East Midlands</td>\n",
       "      <td>£30M - £40M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>YOUR WORLD RECRUITMENT GROUP LIMITED</td>\n",
       "      <td>https://www.yourworldrecruitmentgroup.com</td>\n",
       "      <td>Employment services</td>\n",
       "      <td>London</td>\n",
       "      <td>£100M - £150M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>ZETA ALARMS LIMITED</td>\n",
       "      <td>http://www.zetaalarmsystems.com/</td>\n",
       "      <td>Security</td>\n",
       "      <td>Wales</td>\n",
       "      <td>£10M - £20M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>ZPG PLC</td>\n",
       "      <td>http://www.zoopla.co.uk</td>\n",
       "      <td>Real Estate</td>\n",
       "      <td>London</td>\n",
       "      <td>£150M - £200M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Company name  \\\n",
       "0                                  1PM PLC   \n",
       "1                              24 X 7 LTD.   \n",
       "2            3T LOGISTICS HOLDINGS LIMITED   \n",
       "3                        3T'S LEISURE LTD.   \n",
       "4                      A P P WHOLESALE PLC   \n",
       "5                   A R DEMOLITION LIMITED   \n",
       "6       A. & J. STEPHEN (HOLDINGS) LIMITED   \n",
       "7                     A. MIR & CO. LIMITED   \n",
       "8                     A.& E.ELKINS LIMITED   \n",
       "9                   A.EDMONDS & CO.LIMITED   \n",
       "10                  A.J.N. STEELSTOCK LTD.   \n",
       "11               AA WOODS HOLDINGS LIMITED   \n",
       "12                ABSOLUTE APPAREL LIMITED   \n",
       "13                              ABZENA PLC   \n",
       "14                          ACCORA LIMITED   \n",
       "15                      MAST GROUP LIMITED   \n",
       "16                       ACM GROUP LIMITED   \n",
       "17                          ACORNE LIMITED   \n",
       "18       ACTIVE FLOORING SOLUTIONS LIMITED   \n",
       "19                   ACTURIS GROUP LIMITED   \n",
       "20   ADAMS AVIATION SUPPLY COMPANY LIMITED   \n",
       "21                ADEPT CARE HOMES LIMITED   \n",
       "22                   ADEY HOLDINGS LIMITED   \n",
       "23                   ADT WORKPLACE LIMITED   \n",
       "24      ADVANCE CONSTRUCTION GROUP LIMITED   \n",
       "25    ADVANCED INSULATION HOLDINGS LIMITED   \n",
       "26          ADVENTURE FOREST GROUP LIMITED   \n",
       "27                       AFI TOPCO LIMITED   \n",
       "28             AGC EQUITY PARTNERS LIMITED   \n",
       "29           AGE PARTNERSHIP GROUP LIMITED   \n",
       "..                                     ...   \n",
       "970                   WEBB PLANT GROUP LTD   \n",
       "971                         WELLHOPPED LTD   \n",
       "972             WENZELS THE BAKERS LIMITED   \n",
       "973           WESTCOTT INVESTMENTS LIMITED   \n",
       "974             WESTGREEN CONSTRUCTION LTD   \n",
       "975                    WESTMORLAND LIMITED   \n",
       "976                     WEX EUROPE LIMITED   \n",
       "977                WHITBY SEAFOODS LIMITED   \n",
       "978     WHITEMEADOW GROUP HOLDINGS LIMITED   \n",
       "979           WHYTE CRANES HOLDING LIMITED   \n",
       "980                       WIFINITY LIMITED   \n",
       "981                WILD LIFE GROUP LIMITED   \n",
       "982          WILLIAM CROXSON & SON,LIMITED   \n",
       "983           WILLSHEE'S SKIP HIRE LIMITED   \n",
       "984   WILSON POWER SOLUTIONS GROUP LIMITED   \n",
       "985              WILSON'S AUCTIONS LIMITED   \n",
       "986  WILSONS FURNISHERS (HOLDINGS) LIMITED   \n",
       "987              WINDMILL ORGANICS LIMITED   \n",
       "988    WINNER RECRUITMENT (BIRMINGHAM) LTD   \n",
       "989    WINNING MOVES INTERNATIONAL LIMITED   \n",
       "990      WOODFORD HEATING HOLDINGS LIMITED   \n",
       "991       WOODLAND KITCHENS (N.I.) LIMITED   \n",
       "992        WOODLANDS SITE SERVICES LIMITED   \n",
       "993         WORDSWORTH EXCAVATIONS LIMITED   \n",
       "994                        WORLDREMIT LTD.   \n",
       "995                  WSR RECYCLING LIMITED   \n",
       "996                          XBITE LIMITED   \n",
       "997   YOUR WORLD RECRUITMENT GROUP LIMITED   \n",
       "998                    ZETA ALARMS LIMITED   \n",
       "999                                ZPG PLC   \n",
       "\n",
       "                                       Website  \\\n",
       "0             http://www.1pm.co.uk/Contact-1pm   \n",
       "1           http://www.24x7ltd.co.uk/index.php   \n",
       "2                     http://www.3t-europe.com   \n",
       "3             http://www.surfbayleisure.co.uk/   \n",
       "4           https://www.appwholesaleplc.co.uk    \n",
       "5                http://www.ardemolition.co.uk   \n",
       "6                   https://www.stephen.co.uk/   \n",
       "7                      http://www.a-mir.co.uk    \n",
       "8                        http://aeelkins.co.uk   \n",
       "9                    http://www.edmonds.uk.com   \n",
       "10            https://www.ajnsteelstock.co.uk/   \n",
       "11                       http://aawoods.co.uk/   \n",
       "12           http://www.absoluteapparel.co.uk    \n",
       "13                       http://www.abzena.com   \n",
       "14                   http://www.accora.uk.com    \n",
       "15                     http://www.mastgrp.com/   \n",
       "16       https://www.alphacapitalmarkets.co.uk   \n",
       "17                    https://www.acorne.co.uk   \n",
       "18              http://www.active-flooring.com   \n",
       "19                     http://www.acturis.com    \n",
       "20               http://www.adamsaviation.com    \n",
       "21                 http://adeptcarehomes.co.uk   \n",
       "22             http://www.adeysteelgroup.co.uk   \n",
       "23                http://www.adtworkplace.com/   \n",
       "24                http://advance-groupltd.com/   \n",
       "25           http://www.advancedinsulation.com   \n",
       "26                         https://goape.co.uk   \n",
       "27                  http://www.afi-group.co.uk   \n",
       "28               http://agcequitypartners.com    \n",
       "29           https://www.agepartnership.co.uk/   \n",
       "..                                         ...   \n",
       "970          http://www.apwebbplanthire.co.uk/   \n",
       "971              http://www.charlesfaram.co.uk   \n",
       "972                https://www.wenzels.co.uk/    \n",
       "973                    http://www.westcott.com   \n",
       "974                  http://www.westgreen.com/   \n",
       "975           http://www.westmorlandfamily.com   \n",
       "976                  http://www.wexeurope.com/   \n",
       "977           https://www.whitby-seafoods.com    \n",
       "978              https://www.whitemeadow.com/    \n",
       "979                 http://www.whytecranes.com   \n",
       "980                     https://wifinity.co.uk   \n",
       "981    https://www.yorkshirewildlifepark.com/    \n",
       "982                   https://www.croxsons.com   \n",
       "983                http://www.willshees.co.uk/   \n",
       "984      http://www.wilsonpowersolutions.co.uk   \n",
       "985            https://www.wilsonsauctions.com   \n",
       "986             http://www.wilsonscarpets.com/   \n",
       "987          http://www.windmillorganics.com/    \n",
       "988        http://www.winnerrecruitment.co.uk/   \n",
       "989            https://www.winningmoves.co.uk/   \n",
       "990             http://www.woodfordheating.com   \n",
       "991                  http://www.woodlandni.com   \n",
       "992              http://www.woodlands-ss.co.uk   \n",
       "993    http://www.wordsworthexcavations.co.uk    \n",
       "994                 https://www.worldremit.com   \n",
       "995                  http://wsrrecycling.co.uk   \n",
       "996                    http://www.xbite.co.uk/   \n",
       "997  https://www.yourworldrecruitmentgroup.com   \n",
       "998          http://www.zetaalarmsystems.com/    \n",
       "999                    http://www.zoopla.co.uk   \n",
       "\n",
       "                                Sector                    Region  \\\n",
       "0                   Financial services        South West England   \n",
       "1              Transportation services           East of England   \n",
       "2              Transportation services             East Midlands   \n",
       "3                              Leisure        South West England   \n",
       "4                            Wholesale                    London   \n",
       "5           Engineering & Construction             East Midlands   \n",
       "6           Engineering & Construction                  Scotland   \n",
       "7                        Manufacturing             West Midlands   \n",
       "8        Building & Landscape services                    London   \n",
       "9           Engineering & Construction             West Midlands   \n",
       "10             Transportation services           East of England   \n",
       "11                    Waste Management           East of England   \n",
       "12                           Wholesale             West Midlands   \n",
       "13     Pharmaceuticals & Biotechnology           East of England   \n",
       "14                          Healthcare           East of England   \n",
       "15                       Manufacturing        North West England   \n",
       "16                  Financial services        South East England   \n",
       "17               Professional services        South East England   \n",
       "18       Building & Landscape services        North West England   \n",
       "19              Information Technology                    London   \n",
       "20                           Wholesale        South East England   \n",
       "21                          Healthcare             East Midlands   \n",
       "22   Metal Manufacturing & Engineering             East Midlands   \n",
       "23          Architecture & Engineering        North West England   \n",
       "24          Engineering & Construction                  Scotland   \n",
       "25   Metal Manufacturing & Engineering        South West England   \n",
       "26                             Leisure           East of England   \n",
       "27                    Rental & Leasing  Yorkshire and the Humber   \n",
       "28                  Financial services                    London   \n",
       "29                  Financial services  Yorkshire and the Humber   \n",
       "..                                 ...                       ...   \n",
       "970                   Rental & Leasing             West Midlands   \n",
       "971                  Farming & Fishery             West Midlands   \n",
       "972                    Food & Beverage                    London   \n",
       "973                 Financial services           East of England   \n",
       "974         Architecture & Engineering                    London   \n",
       "975                             Retail        North West England   \n",
       "976                 Financial services                    London   \n",
       "977                    Food & Beverage  Yorkshire and the Humber   \n",
       "978                      Manufacturing             East Midlands   \n",
       "979                   Rental & Leasing                  Scotland   \n",
       "980             Information Technology                    London   \n",
       "981                            Leisure  Yorkshire and the Humber   \n",
       "982                      Manufacturing                    London   \n",
       "983                   Waste Management             West Midlands   \n",
       "984                      Manufacturing  Yorkshire and the Humber   \n",
       "985                            Leisure          Northern Ireland   \n",
       "986                             Retail  Yorkshire and the Humber   \n",
       "987                    Food & Beverage                    London   \n",
       "988                Employment services             West Midlands   \n",
       "989                            Leisure                    London   \n",
       "990                   Energy & Utility           East of England   \n",
       "991                      Manufacturing          Northern Ireland   \n",
       "992              Professional services                    London   \n",
       "993      Building & Landscape services  Yorkshire and the Humber   \n",
       "994             Information Technology                    London   \n",
       "995                   Waste Management        North West England   \n",
       "996                          Wholesale             East Midlands   \n",
       "997                Employment services                    London   \n",
       "998                           Security                     Wales   \n",
       "999                        Real Estate                    London   \n",
       "\n",
       "      Revenue Band  \n",
       "0      £10M - £20M  \n",
       "1       £6M - £10M  \n",
       "2      £10M - £20M  \n",
       "3      £20M - £30M  \n",
       "4    £100M - £150M  \n",
       "5      £10M - £20M  \n",
       "6      £20M - £30M  \n",
       "7      £10M - £20M  \n",
       "8      £40M - £50M  \n",
       "9       £6M - £10M  \n",
       "10    £75M - £100M  \n",
       "11     £10M - £20M  \n",
       "12     £10M - £20M  \n",
       "13     £10M - £20M  \n",
       "14     £10M - £20M  \n",
       "15     £10M - £20M  \n",
       "16      £6M - £10M  \n",
       "17     £40M - £50M  \n",
       "18      £6M - £10M  \n",
       "19     £50M - £75M  \n",
       "20     £20M - £30M  \n",
       "21     £10M - £20M  \n",
       "22     £20M - £30M  \n",
       "23     £30M - £40M  \n",
       "24   £150M - £200M  \n",
       "25     £50M - £75M  \n",
       "26     £30M - £40M  \n",
       "27     £50M - £75M  \n",
       "28     £10M - £20M  \n",
       "29     £20M - £30M  \n",
       "..             ...  \n",
       "970    £10M - £20M  \n",
       "971    £30M - £40M  \n",
       "972    £10M - £20M  \n",
       "973     £6M - £10M  \n",
       "974    £20M - £30M  \n",
       "975   £75M - £100M  \n",
       "976    £10M - £20M  \n",
       "977    £50M - £75M  \n",
       "978    £40M - £50M  \n",
       "979    £10M - £20M  \n",
       "980     £6M - £10M  \n",
       "981    £10M - £20M  \n",
       "982    £10M - £20M  \n",
       "983    £10M - £20M  \n",
       "984    £10M - £20M  \n",
       "985    £10M - £20M  \n",
       "986    £10M - £20M  \n",
       "987    £40M - £50M  \n",
       "988    £10M - £20M  \n",
       "989    £20M - £30M  \n",
       "990    £20M - £30M  \n",
       "991    £10M - £20M  \n",
       "992    £10M - £20M  \n",
       "993    £10M - £20M  \n",
       "994    £40M - £50M  \n",
       "995    £10M - £20M  \n",
       "996    £30M - £40M  \n",
       "997  £100M - £150M  \n",
       "998    £10M - £20M  \n",
       "999  £150M - £200M  \n",
       "\n",
       "[1000 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Comp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1000"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(Comp)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "Saving data into a "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "Comp.to_csv('C://Users//DELL//Desktop//Data Science//filename4.csv', header=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}