Web_Scrapping/Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# import libraries\n",
    "import urllib.request\n",
    "from bs4 import BeautifulSoup\n",
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "urlpage =  'http://www.fasttrack.co.uk/league-tables/tech-track-100/league-table/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "page = urllib.request.urlopen(urlpage)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "soup = BeautifulSoup(page, 'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "bs4.element.Tag"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = soup.find('table', attrs={'class': 'tableSorter2'})\n",
    "type(table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = table.find_all('tr')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# create and write headers to a list \n",
    "rows = []\n",
    "rows.append(['Rank', 'Company Name', 'Webpage', 'Description', 'Location',\n",
    "             'Year end', 'Annual sales rise over 3 years', 'Sales £000s', 'Staff', 'Comments'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/revolut-2/\"><span class=\"company-name\">Revolut</span></a>Digital banking services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/dianomi-5/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/bizuma-3/\"><span class=\"company-name\">Bizuma</span></a>B2B e-commerce platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/revolut-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/global-e-2/\"><span class=\"company-name\">Global-e</span></a>Cross-border ecommerce solutions</td>\n",
      "https://www.fasttrack.co.uk/company_profile/bizuma-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/jungle-creations/\"><span class=\"company-name\">Jungle Creations</span></a>Social media &amp; ecommerce services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/global-e-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/oxford-nanopore-technologies-2/\"><span class=\"company-name\">Oxford Nanopore Technologies</span></a>DNA analysis technology</td>\n",
      "https://www.fasttrack.co.uk/company_profile/jungle-creations/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/lendable/\"><span class=\"company-name\">Lendable</span></a>Consumer lending platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/oxford-nanopore-technologies-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/verve-2/\"><span class=\"company-name\">Verve</span></a>Marketing software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/lendable/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/onfido-2/\"><span class=\"company-name\">Onfido</span></a>Identity verification software</td>\n",
      "https://www.fasttrack.co.uk/company_profile/verve-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/reverse-media-group/\"><span class=\"company-name\">Reverse Media Group</span></a>Digital publishing agency</td>\n",
      "https://www.fasttrack.co.uk/company_profile/onfido-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/rebound-returns/\"><span class=\"company-name\">Rebound Returns</span></a>Ecommerce returns technology</td>\n",
      "https://www.fasttrack.co.uk/company_profile/reverse-media-group/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/clearscore-2/\"><span class=\"company-name\">ClearScore</span></a>Credit-checking technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/rebound-returns/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/spoke/\"><span class=\"company-name\">SPOKE</span></a>Online menswear supplier</td>\n",
      "https://www.fasttrack.co.uk/company_profile/clearscore-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/fsb/\"><span class=\"company-name\">FSB</span></a>Gambling platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/spoke/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/decibel/\"><span class=\"company-name\">Decibel</span></a>Customer experience technology</td>\n",
      "https://www.fasttrack.co.uk/company_profile/fsb/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/miss-group/\"><span class=\"company-name\">Miss Group</span></a>Web hosting provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/decibel/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/complyadvantage-2/\"><span class=\"company-name\">ComplyAdvantage</span></a>Anti-money laundering database</td>\n",
      "https://www.fasttrack.co.uk/company_profile/miss-group/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/ota-insight-2/\"><span class=\"company-name\">OTA Insight</span></a>Hospitality technology provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/complyadvantage-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/light-source/\"><span class=\"company-name\">Light Source</span></a>Telecoms infrastructure builder</td>\n",
      "https://www.fasttrack.co.uk/company_profile/ota-insight-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/digi2al/\"><span class=\"company-name\">Digi2al</span></a>Digital technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/light-source/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/perkbox-3/\"><span class=\"company-name\">Perkbox</span></a>Employee engagement services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/digi2al/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/lending-works/\"><span class=\"company-name\">Lending Works</span></a>Peer-to-peer lender</td>\n",
      "https://www.fasttrack.co.uk/company_profile/perkbox-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/faculty/\"><span class=\"company-name\">Faculty</span></a>AI software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/lending-works/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/internet-mobile-communications/\"><span class=\"company-name\">Internet Mobile Communications</span></a>Telecoms services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/faculty/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/fruugo/\"><span class=\"company-name\">Fruugo</span></a>Online shopping platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/internet-mobile-communications/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/featurespace-2/\"><span class=\"company-name\">Featurespace</span></a>Analytics software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/fruugo/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/monterosa/\"><span class=\"company-name\">Monterosa</span></a>Audience interaction platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/featurespace-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/lockwood-publishing/\"><span class=\"company-name\">Lockwood Publishing</span></a>Mobile games developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/monterosa/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/plan-com-2/\"><span class=\"company-name\">Plan.com</span></a>Communications provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/lockwood-publishing/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/capital-on-tap-3/\"><span class=\"company-name\">Capital on Tap</span></a>Business finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/plan-com-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/in-touch-networks/\"><span class=\"company-name\">In Touch Networks</span></a>Professional networking platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/capital-on-tap-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/dv-signage-2/\"><span class=\"company-name\">DV Signage</span></a>Corporate AV specialist</td>\n",
      "https://www.fasttrack.co.uk/company_profile/in-touch-networks/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/ogury-3/\"><span class=\"company-name\">Ogury</span></a>Mobile data marketing</td>\n",
      "https://www.fasttrack.co.uk/company_profile/dv-signage-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/chameleon-technology/\"><span class=\"company-name\">Chameleon Technology</span></a>Smart energy monitoring</td>\n",
      "https://www.fasttrack.co.uk/company_profile/ogury-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/iwoca-4/\"><span class=\"company-name\">iwoca</span></a>Business finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/chameleon-technology/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/byte/\"><span class=\"company-name\">Byte</span></a>Marketing technology agency</td>\n",
      "https://www.fasttrack.co.uk/company_profile/iwoca-4/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/matillion/\"><span class=\"company-name\">Matillion</span></a>Data transformation software</td>\n",
      "https://www.fasttrack.co.uk/company_profile/byte/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/bought-by-many-3/\"><span class=\"company-name\">Bought By Many</span></a>Specialist insurance platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/matillion/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/checkout-com/\"><span class=\"company-name\">Checkout.com</span></a>Payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/bought-by-many-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/fleximize/\"><span class=\"company-name\">Fleximize</span></a>Business finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/checkout-com/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/hyperdrive-innovation-2/\"><span class=\"company-name\">Hyperdrive Innovation</span></a>Battery technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/fleximize/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/gocardless-3/\"><span class=\"company-name\">GoCardless</span></a>Payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/hyperdrive-innovation-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/azuri-technologies/\"><span class=\"company-name\">Azuri Technologies</span></a>Solar technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/gocardless-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/receipt-bank-3/\"><span class=\"company-name\">Receipt Bank</span></a>Bookkeeping automation services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/azuri-technologies/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/gohenry-2/\"><span class=\"company-name\">gohenry</span></a>Children's pre-paid card service</td>\n",
      "https://www.fasttrack.co.uk/company_profile/receipt-bank-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/gousto-2/\"><span class=\"company-name\">Gousto</span></a>Meal kit delivery services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/gohenry-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/depop-2/\"><span class=\"company-name\">Depop</span></a>Fashion marketplace app</td>\n",
      "https://www.fasttrack.co.uk/company_profile/gousto-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/giacom-3/\"><span class=\"company-name\">Giacom</span></a>Cloud services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/depop-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/account-technologies/\"><span class=\"company-name\">Account Technologies</span></a>Consumer finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/giacom-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/gigaclear-2/\"><span class=\"company-name\">Gigaclear</span></a>Internet services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/account-technologies/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/oakbrook-3/\"><span class=\"company-name\">Oakbrook</span></a>Consumer finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/gigaclear-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/hyperoptic-3/\"><span class=\"company-name\">Hyperoptic</span></a>Internet services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/oakbrook-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/transferwise-7/\"><span class=\"company-name\">TransferWise</span></a>Currency transfer provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/hyperoptic-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/assetz-capital-2/\"><span class=\"company-name\">Assetz Capital</span></a>Business finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/transferwise-7/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/darktrace-4/\"><span class=\"company-name\">Darktrace</span></a>Cyber-security developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/assetz-capital-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/payen-2/\"><span class=\"company-name\">Payen</span></a>Payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/darktrace-4/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/thread-2/\"><span class=\"company-name\">Thread</span></a>Online fashion services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/payen-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/superawesome-3/\"><span class=\"company-name\">SuperAwesome</span></a>Children's privacy protection</td>\n",
      "https://www.fasttrack.co.uk/company_profile/thread-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/vizolution-2/\"><span class=\"company-name\">Vizolution</span></a>Business software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/superawesome-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/bigchange-2/\"><span class=\"company-name\">BigChange</span></a>Workforce management software</td>\n",
      "https://www.fasttrack.co.uk/company_profile/vizolution-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/symetrica-3/\"><span class=\"company-name\">Symetrica</span></a>Detection equipment manufacturer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/bigchange-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/starleaf-3/\"><span class=\"company-name\">StarLeaf</span></a>Video conferencing platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/symetrica-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/azimo-2/\"><span class=\"company-name\">Azimo</span></a>Currency transfer provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/starleaf-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/endomag/\"><span class=\"company-name\">Endomag</span></a>Medical device developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/azimo-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/qhi-group-2/\"><span class=\"company-name\">QHi Group</span></a>Monitoring systems developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/endomag/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/threads-styling-3/\"><span class=\"company-name\">Threads Styling</span></a>Online fashion services</td>\n",
      "https://www.fasttrack.co.uk/company_profile/qhi-group-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/unify-communications/\"><span class=\"company-name\">Unify Communications</span></a>Customer service software</td>\n",
      "https://www.fasttrack.co.uk/company_profile/threads-styling-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/miq-7/\"><span class=\"company-name\">MiQ</span></a>Digital marketing agency</td>\n",
      "https://www.fasttrack.co.uk/company_profile/unify-communications/\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/neyber/\"><span class=\"company-name\">Neyber</span></a>Personal finance technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/miq-7/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/tvsquared-2/\"><span class=\"company-name\">TVSquared</span></a>TV advertising analytics</td>\n",
      "https://www.fasttrack.co.uk/company_profile/neyber/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/the-access-group/\"><span class=\"company-name\">The Access Group</span></a>Business software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/tvsquared-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/contactengine/\"><span class=\"company-name\">ContactEngine</span></a>Conversational AI technology</td>\n",
      "https://www.fasttrack.co.uk/company_profile/the-access-group/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/hutch-3/\"><span class=\"company-name\">Hutch</span></a>Mobile games developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/contactengine/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/sideshow/\"><span class=\"company-name\">Sideshow</span></a>Digital marketing agency</td>\n",
      "https://www.fasttrack.co.uk/company_profile/hutch-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/optal-8/\"><span class=\"company-name\">Optal</span></a>Payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/sideshow/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/leisure-pass-group-11/\"><span class=\"company-name\">Leisure Pass Group</span></a>Tourism smartcard provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/optal-8/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/brompton-technology-3/\"><span class=\"company-name\">Brompton Technology</span></a>Video technology provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/leisure-pass-group-11/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/iplato/\"><span class=\"company-name\">iPlato</span></a>Healthcare app developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/brompton-technology-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/currencycloud-2/\"><span class=\"company-name\">Currencycloud</span></a>Payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/iplato/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/tharsus/\"><span class=\"company-name\">Tharsus</span></a>Robot designer and manufacturer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/currencycloud-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/ensek-2/\"><span class=\"company-name\">ENSEK</span></a>Energy software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/tharsus/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/captify-3/\"><span class=\"company-name\">Captify</span></a>Advertising technology company</td>\n",
      "https://www.fasttrack.co.uk/company_profile/ensek-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/adaptive-3/\"><span class=\"company-name\">Adaptive</span></a>Banking technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/captify-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/student-beans/\"><span class=\"company-name\">Student Beans</span></a>Student loyalty network</td>\n",
      "https://www.fasttrack.co.uk/company_profile/adaptive-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/godel-technologies-3/\"><span class=\"company-name\">Godel Technologies</span></a>Software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/student-beans/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/mpb/\"><span class=\"company-name\">MPB</span></a>Photography equipment trading platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/godel-technologies-3/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/smartsearch/\"><span class=\"company-name\">Smartsearch</span></a>Anti-fraud technology developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/mpb/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/liberis-2/\"><span class=\"company-name\">Liberis</span></a>Business finance provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/smartsearch/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/cloudthing/\"><span class=\"company-name\">cloudThing</span></a>Software developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/liberis-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/zappi/\"><span class=\"company-name\">Zappi</span></a>Consumer insights platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/cloudthing/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/ticketer/\"><span class=\"company-name\">Ticketer</span></a>Electronic ticket machine developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/zappi/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/pharmacy-2u/\"><span class=\"company-name\">Pharmacy 2U</span></a>Online pharmacy</td>\n",
      "https://www.fasttrack.co.uk/company_profile/ticketer/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/adaptavist/\"><span class=\"company-name\">Adaptavist</span></a>IT consultancy</td>\n",
      "https://www.fasttrack.co.uk/company_profile/pharmacy-2u/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/alternative-airlines/\"><span class=\"company-name\">Alternative Airlines</span></a>Flight booking website</td>\n",
      "https://www.fasttrack.co.uk/company_profile/adaptavist/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/biosite-systems-2/\"><span class=\"company-name\">Biosite Systems</span></a>Workforce management software</td>\n",
      "https://www.fasttrack.co.uk/company_profile/alternative-airlines/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/justpark-2/\"><span class=\"company-name\">JustPark</span></a>Smart parking provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/biosite-systems-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/worldremit-4/\"><span class=\"company-name\">WorldRemit</span></a>Currency transfer provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/justpark-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/e3d-online-2/\"><span class=\"company-name\">E3D Online</span></a>3D printer developer</td>\n",
      "https://www.fasttrack.co.uk/company_profile/worldremit-4/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/parentpay-2/\"><span class=\"company-name\">Parentpay</span></a>School payment services provider</td>\n",
      "https://www.fasttrack.co.uk/company_profile/e3d-online-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/victor-6/\"><span class=\"company-name\">Victor</span></a>Online private jet hire</td>\n",
      "https://www.fasttrack.co.uk/company_profile/parentpay-2/\n",
      "<td><a href=\"https://www.fasttrack.co.uk/company_profile/dianomi-5/\"><span class=\"company-name\">Dianomi</span></a>Financial marketing platform</td>\n",
      "https://www.fasttrack.co.uk/company_profile/victor-6/\n"
     ]
    }
   ],
   "source": [
    "for result in results:\n",
    "    # find all columns per result\n",
    "    data = result.find_all('td')\n",
    "    # check that columns have data \n",
    "    if len(data) == 0: \n",
    "        continue\n",
    "    # write columns to variables\n",
    "    rank = data[0].getText()\n",
    "    company = data[1].getText()\n",
    "    location = data[2].getText()\n",
    "    yearend = data[3].getText()\n",
    "    salesrise = data[4].getText()\n",
    "    sales = data[5].getText()\n",
    "    staff = data[6].getText()\n",
    "    comments = data[7].getText()\n",
    "    # extract description from the name\n",
    "    print(data[1])\n",
    "    companyname = data[1].find('span', attrs={'class':'company-name'}).getText()  \n",
    "    #print(companyname)\n",
    "    \n",
    "    print(companyname_url)\n",
    "    #print(data[1].getText())\n",
    "    desc_=data[1].getText()\n",
    "    description = desc_.replace(companyname, '')\n",
    "    #print(description)\n",
    "    # remove unwanted characters\n",
    "    sales = sales.strip('*').strip('†').replace(',','')\n",
    "    try:\n",
    "        #tableRow = soup.find('table').find_all('tr')[-1]\n",
    "        companyname_url = data[1].find('a').get('href')\n",
    "        webpage = companyname_url\n",
    "        #print(f\"webpage----> {webpage}\")\n",
    "    except:\n",
    "        webpage = None\n",
    "    \n",
    "    # write each result to rows\n",
    "    rows.append([rank, companyname, webpage, description, location, yearend, salesrise, sales, staff, comments])\n"
   ]
  },
  {
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}