Auditor_name.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "516fbb4b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import fitz\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "08184fad",
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\cgt_data\\final_data'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "c0546f53",
   "metadata": {},
   "outputs": [],
   "source": [
    "file='BHP Group PLC AR 2020.pdf'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "ccd55985",
   "metadata": {},
   "outputs": [],
   "source": [
    "with fitz.open(os.path.join(path, file)) as f:\n",
    "    for j in range(f.pageCount):\n",
    "        page = f.loadPage(j)\n",
    "        blocks = page.getText(\"blocks\")\n",
    "        blocks.sort(key=lambda block: block[1])  # sort vertically ascending\n",
    "        r_text=''\n",
    "        for b in blocks:\n",
    "            text = ' '.join(b[4].strip().splitlines())\n",
    "            r_text=text.lower()\n",
    "            if r_text.count('statutory auditor')>1:\n",
    "                print('yes ' + str(j))\n",
    "                print(text)\n",
    "                break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "bfc818bf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'tel +44 (0)1707 600 300 fax +44 (0)1707 600 333 www.paypoint.com'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "80994593",
   "metadata": {},
   "outputs": [],
   "source": [
    "import spacy\n",
    "nlp = spacy.load('en_core_web_sm')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "3230cae9",
   "metadata": {},
   "outputs": [],
   "source": [
    "text = 'Michael Harper (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square, Canary Wharf, E14 5GL 27 May 2020'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "b4fa7cd6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "KPMG LLP\n"
     ]
    }
   ],
   "source": [
    "doc = nlp(text)\n",
    "for ent in doc.ents:\n",
    "    if ent.label_ == 'ORG':\n",
    "        print(ent.text)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5a2c1df4",
   "metadata": {},
   "source": [
    "# function to extract auditor information and page_num"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "8d499ee9",
   "metadata": {},
   "outputs": [],
   "source": [
    "# def auditor_name(path, file):\n",
    "    \n",
    "    \n",
    "#     with fitz.open(os.path.join(path, file)) as f:\n",
    "#         for j in range(f.pageCount):\n",
    "#             page = f.loadPage(j)\n",
    "#             blocks = page.getText(\"blocks\")\n",
    "#             blocks.sort(key=lambda block: block[1])  # sort vertically ascending\n",
    "#             r_text=''\n",
    "#             for b in blocks:\n",
    "#                 text = ' '.join(b[4].strip().splitlines())\n",
    "#                 r_text=text.lower()\n",
    "#                 if r_text.count('statutory auditor')>1:\n",
    "#                     pg_num = j\n",
    "#                     return([pg_num, text])\n",
    "                   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "d4fdd40f",
   "metadata": {},
   "outputs": [],
   "source": [
    "file='Paypoint AR 2020.pdf'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "67faef72",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[93,\n",
       " 'Michael Harper (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square, Canary Wharf, E14 5GL 27 May 2020']"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_name(path, file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "32bd7e3f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3i infrastructure ar 2021.pdf\n"
     ]
    },
    {
     "ename": "NameError",
     "evalue": "name 'auditor_name' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-d3da10753fc3>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      8\u001b[0m     \u001b[0mprint\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      9\u001b[0m     \u001b[0mfile_name\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 10\u001b[1;33m     \u001b[0ma\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mauditor_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mpath\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfile\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     11\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0ma\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     12\u001b[0m         \u001b[0mpage_num\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0ma\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'auditor_name' is not defined"
     ]
    }
   ],
   "source": [
    "path = r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\cgt_data\\final_data'\n",
    "page_num=[]\n",
    "text=[]\n",
    "file_name=[]\n",
    "for i in os.listdir(path):\n",
    "    path = path\n",
    "    file = i\n",
    "    print(i)\n",
    "    file_name.append(i)\n",
    "    a = auditor_name(path, file)\n",
    "    if a:\n",
    "        page_num.append(a[0])\n",
    "        text.append(a[1])\n",
    "        \n",
    "    else:\n",
    "        page_num.append(np.nan)\n",
    "        text.append(np.nan)\n",
    "       \n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "891ff331",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info = pd.DataFrame()\n",
    "auditor_info['filename'] = file_name\n",
    "auditor_info['page_num']= page_num\n",
    "auditor_info['text'] = text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "26892a90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "79"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.text.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "de40b2f0",
   "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>filename</th>\n",
       "      <th>page_num</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3i_group_ar_2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Julian Young (Senior statutory auditor) for an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4imprint Group AR 2020.pdf</td>\n",
       "      <td>84.0</td>\n",
       "      <td>CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Admiral Group Plc Annual Report 2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Mark McQueen (Senior statutory auditor) For an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AG Barr AR 2021.pdf</td>\n",
       "      <td>110.0</td>\n",
       "      <td>David Sweeney, CA (Senior statutory auditor) F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Aggreko PLC annual report 2020.pdf</td>\n",
       "      <td>106.0</td>\n",
       "      <td>John Luke (Senior Statutory Auditor)   for and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Airtel Africa PLC Annual report 2020.pdf</td>\n",
       "      <td>10.0</td>\n",
       "      <td>MARK GOODEY (FCA) (SENIOR STATUTORY AUDITOR)  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AJ_Bell PLC Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Anglo American PLC AR 2020.pdf</td>\n",
       "      <td>121.0</td>\n",
       "      <td>At the 2020 AGM, shareholders approved the app...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>antofagasta_2020_annual_report.pdf</td>\n",
       "      <td>165.0</td>\n",
       "      <td>Simon Morley (Senior Statutory Auditor)  for a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ascential PLC Annual Report 2020.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Ian Griffiths (Senior Statutory Auditor)  for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ashmore Group PLC Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ashtead_AR2020.pdf</td>\n",
       "      <td>114.0</td>\n",
       "      <td>WILLIAM SMITH   (SENIOR STATUTORY AUDITOR) for...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Associated British Foods PLC AR 2020.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Andrew Walton (Senior Statutory Auditor)  for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Assura PLC Annual Report 2020.pdf</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Scott Bayne, FCA (senior statutory auditor) Fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AstraZeneca_AR_2020.pdf</td>\n",
       "      <td>176.0</td>\n",
       "      <td>Richard Hughes (Senior Statutory Auditor) for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Auto Trader Group PLC Annual report 2020.pdf</td>\n",
       "      <td>100.0</td>\n",
       "      <td>Mick Davies (Senior Statutory Auditor)  for an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Avast PLC Annual report 2020.pdf</td>\n",
       "      <td>140.0</td>\n",
       "      <td>In order to mitigate the risk of working remot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Aveva Group PLC AR 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>aviva-plc-annual-report-and-accounts-2020.pdf</td>\n",
       "      <td>130.0</td>\n",
       "      <td>Alex Bertolotti (Senior Statutory Auditor)  fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B&amp;M Eurpean Value Retail Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           filename  page_num  \\\n",
       "0                              3i_group_ar_2020.pdf     174.0   \n",
       "1                        4imprint Group AR 2020.pdf      84.0   \n",
       "2          Admiral Group Plc Annual Report 2020.pdf     174.0   \n",
       "3                               AG Barr AR 2021.pdf     110.0   \n",
       "4                Aggreko PLC annual report 2020.pdf     106.0   \n",
       "5          Airtel Africa PLC Annual report 2020.pdf      10.0   \n",
       "6                AJ_Bell PLC Annual Report 2020.pdf       NaN   \n",
       "7                    Anglo American PLC AR 2020.pdf     121.0   \n",
       "8                antofagasta_2020_annual_report.pdf     165.0   \n",
       "9              Ascential PLC Annual Report 2020.pdf     120.0   \n",
       "10         Ashmore Group PLC Annual Report 2020.pdf       NaN   \n",
       "11                               Ashtead_AR2020.pdf     114.0   \n",
       "12         Associated British Foods PLC AR 2020.pdf     137.0   \n",
       "13                Assura PLC Annual Report 2020.pdf     114.0   \n",
       "14                          AstraZeneca_AR_2020.pdf     176.0   \n",
       "15     Auto Trader Group PLC Annual report 2020.pdf     100.0   \n",
       "16                 Avast PLC Annual report 2020.pdf     140.0   \n",
       "17                      Aveva Group PLC AR 2020.pdf       NaN   \n",
       "18    aviva-plc-annual-report-and-accounts-2020.pdf     130.0   \n",
       "19  B&M Eurpean Value Retail Annual Report 2020.pdf       NaN   \n",
       "\n",
       "                                                 text  \n",
       "0   Julian Young (Senior statutory auditor) for an...  \n",
       "1   CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...  \n",
       "2   Mark McQueen (Senior statutory auditor) For an...  \n",
       "3   David Sweeney, CA (Senior statutory auditor) F...  \n",
       "4   John Luke (Senior Statutory Auditor)   for and...  \n",
       "5   MARK GOODEY (FCA) (SENIOR STATUTORY AUDITOR)  ...  \n",
       "6                                                 NaN  \n",
       "7   At the 2020 AGM, shareholders approved the app...  \n",
       "8   Simon Morley (Senior Statutory Auditor)  for a...  \n",
       "9   Ian Griffiths (Senior Statutory Auditor)  for ...  \n",
       "10                                                NaN  \n",
       "11  WILLIAM SMITH   (SENIOR STATUTORY AUDITOR) for...  \n",
       "12  Andrew Walton (Senior Statutory Auditor)  for ...  \n",
       "13  Scott Bayne, FCA (senior statutory auditor) Fo...  \n",
       "14  Richard Hughes (Senior Statutory Auditor) for ...  \n",
       "15  Mick Davies (Senior Statutory Auditor)  for an...  \n",
       "16  In order to mitigate the risk of working remot...  \n",
       "17                                                NaN  \n",
       "18  Alex Bertolotti (Senior Statutory Auditor)  fo...  \n",
       "19                                                NaN  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.head(20)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "59cf1384",
   "metadata": {},
   "source": [
    "# try filling more rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "15f0c0ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "def auditor_name_v2(path, file):\n",
    "    \n",
    "    \n",
    "    with fitz.open(os.path.join(path, file)) as f:\n",
    "        for j in range(f.pageCount):\n",
    "            page = f.loadPage(j)\n",
    "            blocks = page.getText(\"blocks\")\n",
    "            blocks.sort(key=lambda block: block[1])  # sort vertically ascending\n",
    "            r_text=''\n",
    "            for b in blocks:\n",
    "                text = ' '.join(b[4].strip().splitlines())\n",
    "                r_text=text.lower()\n",
    "                if ('on behalf' in r_text) and ('statutory auditor' in r_text):\n",
    "                    pg_num = j\n",
    "                    return([pg_num, text])\n",
    "                   "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "8fc949ec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[106,\n",
       " 'External auditor PricewaterhouseCoopers AG, Birchstrasse 160, CH 8050 Zurich,  Switzerland (‘PwC AG’) has been elected by the shareholders as  the\\xa0statutory auditor for the Group’s statutory consolidated and  standalone Financial Statements. Signing partner for the statutory  Financial Statements on behalf of PwC AG is Michael Foley, who  has\\xa0held this role since the year ended 31 December 2016.']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_name_v2(path, 'Coca-Cola HBC AG AR 2020.pdf')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fe1ea360",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3i infrastructure ar 2021.pdf\n",
      "4imprint Group AR 2020.pdf\n",
      "888 Holdings Annual Report.pdf\n",
      "91-ninety-one-integrated-annual-report-2021.pdf\n",
      "Admiral Group Plc Annual Report 2020.pdf\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "mupdf: unknown keyword: '2318.4.0'\n",
      "mupdf: unknown keyword: '2l3632'\n",
      "mupdf: unknown keyword: '5167035182.040.0912'\n",
      "mupdf: unknown keyword: '53.5848.666628.731670351c'\n",
      "mupdf: unknown keyword: '851.211.042'\n",
      "mupdf: unknown keyword: '2.91465614236.96'\n",
      "mupdf: unknown keyword: '265676c'\n",
      "mupdf: unknown keyword: '50.51466.222'\n",
      "mupdf: unknown keyword: 'c.304'\n",
      "mupdf: unknown keyword: '35.37.6964'\n",
      "mupdf: unknown keyword: '35.37.6972'\n",
      "mupdf: unknown keyword: '24.6845.276'\n",
      "mupdf: unknown keyword: '23.5.3015.344'\n",
      "mupdf: unknown keyword: '32.149.2388'\n",
      "mupdf: unknown keyword: '52.93668.7514'\n",
      "mupdf: unknown keyword: '651.0428.75142'\n",
      "mupdf: unknown keyword: '51.16.798'\n",
      "mupdf: unknown keyword: '19423.5.3366'\n",
      "mupdf: unknown keyword: '25.542.7468.9956'\n",
      "mupdf: unknown keyword: '15.24.47'\n",
      "mupdf: unknown keyword: '28.c'\n",
      "mupdf: unknown keyword: '6.7318.4m'\n",
      "mupdf: unknown keyword: '2828.60c'\n",
      "mupdf: unknown keyword: '28.657.28'\n",
      "mupdf: unknown keyword: '5350.5224.51'\n",
      "mupdf: unknown keyword: '6.207.078'\n",
      "mupdf: unknown keyword: '217.4.1'\n",
      "mupdf: unknown keyword: '3684544c'\n",
      "mupdf: unknown keyword: '11.c'\n",
      "mupdf: unknown keyword: '33.36.84'\n",
      "mupdf: unknown keyword: '20.66.852'\n",
      "mupdf: unknown keyword: '36.52.06628.6184'\n",
      "mupdf: unknown keyword: '13.66.956'\n",
      "mupdf: unknown keyword: '366.84.24'\n",
      "mupdf: unknown keyword: '0.1266.84.24'\n",
      "mupdf: unknown keyword: '4662810448.6606628.6182.040'\n",
      "mupdf: unknown keyword: '33.6698.734.272'\n",
      "mupdf: unknown keyword: '31047322.44-16'\n",
      "mupdf: unknown keyword: '30.74.2'\n",
      "mupdf: unknown keyword: '6-16'\n",
      "mupdf: unknown keyword: '30.7574.4144-1647.474.61.226'\n",
      "mupdf: unknown keyword: '250.74.51.108'\n",
      "mupdf: unknown keyword: '24757c'\n",
      "mupdf: unknown keyword: '29.97c'\n",
      "mupdf: unknown keyword: '4780.77898.38.c'\n",
      "mupdf: unknown keyword: '1.371.55275'\n",
      "mupdf: unknown keyword: '52.3.926'\n",
      "mupdf: unknown keyword: '7759.728331.02'\n",
      "mupdf: unknown keyword: 'c2767594'\n",
      "mupdf: unknown keyword: 'c72371.552724.202476'\n",
      "mupdf: unknown keyword: '40.371.55275.868.476'\n",
      "mupdf: unknown keyword: '24665.8930.7578.52.057.90247'\n",
      "mupdf: unknown keyword: '11.287.862'\n",
      "mupdf: unknown keyword: '219258.76-2.1782'\n",
      "mupdf: unknown keyword: '30.374.262'\n",
      "mupdf: unknown keyword: '374.023.53'\n",
      "mupdf: unknown keyword: '74.023.5352'\n",
      "mupdf: unknown keyword: '51.5.67'\n",
      "mupdf: unknown keyword: '23.775240816.798'\n",
      "mupdf: unknown keyword: '74..0428.798'\n",
      "mupdf: unknown keyword: '74..8040.82.286'\n",
      "mupdf: unknown keyword: '6.732.2874.2'\n",
      "mupdf: unknown keyword: '6.732.2874.2'\n",
      "mupdf: unknown keyword: '6.7318.4c'\n",
      "mupdf: unknown keyword: '24.3m'\n",
      "mupdf: unknown keyword: '74..04281545286'\n",
      "mupdf: unknown keyword: '15.2474.896'\n",
      "mupdf: unknown keyword: '48.13.77528'\n",
      "mupdf: unknown keyword: '32.9596667.38628'\n",
      "mupdf: unknown keyword: '2998.76-1.24'\n",
      "mupdf: unknown keyword: '32.36.25876-'\n",
      "mupdf: unknown keyword: '8.7525.6936.9881'\n",
      "mupdf: unknown keyword: '374.26.764'\n",
      "mupdf: unknown keyword: '27574.4.466998'\n",
      "mupdf: unknown keyword: '1.28.6175'\n",
      "mupdf: unknown keyword: '6760c'\n",
      "mupdf: unknown keyword: '-3667.3942.35'\n",
      "mupdf: unknown keyword: '-3.60c'\n",
      "mupdf: unknown keyword: '717511.c'\n",
      "mupdf: unknown keyword: '327.771717.2'\n",
      "mupdf: unknown keyword: '410472c'\n",
      "mupdf: unknown keyword: '30.8331.027572.723.1.386'\n",
      "mupdf: unknown keyword: '272.6.598c'\n",
      "mupdf: unknown keyword: '24.3c'\n",
      "mupdf: unknown keyword: '8451.5.2766.3m'\n",
      "mupdf: unknown keyword: '62128.717.86.10134'\n",
      "mupdf: unknown keyword: '86.05.04'\n",
      "mupdf: unknown keyword: '1916.1.94304'\n",
      "mupdf: unknown keyword: '8c'\n",
      "mupdf: unknown keyword: '104.3c'\n",
      "mupdf: unknown keyword: '51.5816473.83303.581662122'\n",
      "mupdf: unknown keyword: '-3.60c'\n",
      "mupdf: unknown keyword: '-023.8.17478989.8.17478'\n",
      "mupdf: unknown keyword: '29960c'\n",
      "mupdf: unknown keyword: '24.89.393182.94.89.06'\n",
      "mupdf: unknown keyword: '12.7060c'\n",
      "mupdf: unknown keyword: '19.89.38951'\n",
      "mupdf: unknown keyword: '17.89.393117.424'\n",
      "mupdf: unknown keyword: '39.08.2721178'\n",
      "mupdf: unknown keyword: '118.89.06'\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Aggreko PLC annual report 2020.pdf\n",
      "Airtel Africa Annual Report 2021.pdf\n",
      "AJ_Bell PLC Annual Report 2020.pdf\n",
      "Anglo American PLC AR 2020.pdf\n",
      "antofagasta_2020_annual_report.pdf\n",
      "Ascential PLC Annual Report 2020.pdf\n",
      "Ashmore Group PLC Annual Report 2020.pdf\n",
      "Associated British Foods PLC AR 2020.pdf\n",
      "Assura AnnualReport2021final.pdf\n",
      "Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf\n",
      "AstraZeneca_AR_2020.pdf\n",
      "Auto Trader  plc ar2021-web.pdf\n",
      "Avast PLC Annual report 2020.pdf\n",
      "Aveva AR 2021.pdf\n",
      "aviva-plc-annual-report-and-accounts-2020.pdf\n",
      "avon-rubber-annual-report-2020.pdf\n",
      "B&MFull_Annual_Report_and_Accounts_2021.pdf\n",
      "BAE Systems PLC AR 2020.pdf\n",
      "Balfour Beatty PLC Annual Report 2020.pdf\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "mupdf: invalid page object\n",
      "mupdf: invalid page object\n",
      "mupdf: invalid page object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Barclays PLC AR 2020.pdf\n",
      "Barratt Developments P L C AR 2020.pdf\n",
      "Beazley PLC Annual Report-2020.pdf\n",
      "bellway_ar20_web.pdf\n",
      "BHP Group PLC AR 2020.pdf\n",
      "Biffa Annual Report and Accounts FY21 Final.pdf\n",
      "Big Yellow_AR21_Annual_report_and_accounts_2021.pdf\n",
      "Bodycote PLC Annual-report-2020.pdf\n",
      "BP PLC AR 2020.pdf\n",
      "Brewin Dolphin Holdings annual-report-2020.pdf\n",
      "British American Tobacco P.L.C. AR 2020.pdf\n",
      "British Land Company plc AR 2021.pdf\n",
      "Britvic PLC Annual Report 2020.pdf\n",
      "bt-annual-report 2021.pdf\n",
      "Bunzl PLC annual report 2020.pdf\n",
      "Burberry_2020-21_Annual_Report.pdf\n",
      "Bytes Technology Group plc AR 2021.pdf\n",
      "C&C Group plc annual report 2021.pdf\n",
      "cairn-ar2020.pdf\n",
      "CandC Annual Report 2021.pdf\n",
      "Capita PLC annual report 2020.pdf\n",
      "Capital & Counties Properties PLC Annual Report 2020.pdf\n",
      "Carnival PLC Annual Report 2020.pdf\n",
      "Centamin PLC Annual Report 2020.pdf\n",
      "centrica-ar2020.pdf\n",
      "chemring-plc-annual-report-2020.pdf\n",
      "Cineworld Group PLC Annual Report 2020.pdf\n",
      "Clarkson annual_report_2020.pdf\n",
      "Close Brothers Group PLC Annual report 2020.pdf\n",
      "CLS Annual Report - 31 Dec 2020.pdf\n",
      "CMC AR 2021.pdf\n",
      "Coats Group AR 2020.pdf\n",
      "Coca-Cola HBC AG AR 2020.pdf\n",
      "CompassGroupPLC_AnnualReport2020_FINAL.pdf\n",
      "Computacenter PLC annual report 2020.pdf\n",
      "Contourglobal 2020_annual_report.pdf\n",
      "ConvaTec Group PLC Annual Report 2020.pdf\n",
      "Countryside_Properties_PLC_Annual_report_2020.pdf\n",
      "Crainswick 35913 AR2021 Spreads WEB.pdf\n",
      "crest-nicholson-annual-integrated-report-2020.pdf\n",
      "crh-annual-report-2020.pdf\n",
      "Croda International PLC Annual Report  2020.pdf\n",
      "DCC Annual Report 2021.pdf\n",
      "Dechra Pharmaceuticals PLC Annual report 2020.pdf\n",
      "Derwent London PLC Annual report 2020.pdf\n",
      "Diageo PLC AR 2020.pdf\n",
      "Diploma PLC Annual Report 2020.pdf\n",
      "Direct Line PLC Annual report 2020.pdf\n",
      "Diversified Energy plc_2021_Annual_Report.pdf\n",
      "Dominos pizza 2020-annual-report.pdf\n",
      "Dr._Martens_plc_Annual_Report_2021.pdf\n",
      "Dr._Martens_plc_FY21_results_statement.pdf\n",
      "Drax_AR2020.pdf\n",
      "Dunelm Group Plc annual-report-2020.pdf\n",
      "Easyjet PLC Annual Report 2020.pdf\n",
      "electrocomponents aR 2021.pdf\n",
      "Elementis 2020 Annual Report and Accounts.pdf\n",
      "energean-2020-annual-report.pdf\n",
      "Equiniti annual-report-2020.pdf\n",
      "essentra-ar-2020-.pdf\n",
      "Euromoney Institutional Investor annual-report-2020.pdf\n",
      "Evraz PLC Annual report 2020.pdf\n",
      "experian AR 2021.pdf\n",
      "FDM-Annual-Report-2020.pdf\n",
      "Ferguson-plc-Annual-Report-2020.pdf\n",
      "ferrexpo-plc-ara-2020.pdf\n",
      "Flutter Entertainment PLC Annual Report 2020.pdf\n",
      "Fresnillo PLC Annual Report 2020.pdf\n",
      "Future plc ar 2020.pdf\n",
      "G4S PLC Annual report 2020.pdf\n",
      "gamesys-annual-report-and-accounts-2020.pdf\n",
      "Genuit Polypile AR 2020 2021.pdf\n",
      "Genus PLC  Annual report 2020.pdf\n",
      "Glaxosmithkline PLC AR 2020.pdf\n",
      "Glencore_AR20_Interactive.pdf\n",
      "Grafton Group PLC Annual Report 2020.pdf\n",
      "Grainger PLC Annual report 2020.pdf\n",
      "Great Portland Estates-ar2021_bookmarked.pdf\n",
      "Greencore-Group-plc-Annual-Report-and-Financial-Statements-2020.pdf\n",
      "Greggs PLC Annual Report 2020.pdf\n",
      "halma-ara-2021.pdf\n",
      "Hammerson PLC Annual Report 2020.pdf\n",
      "Hargreaves Lansdown PLC AR 2020.pdf\n",
      "Hays PLC Annual Report 2020.pdf\n",
      "helios towers-annual-report-2020.pdf\n",
      "HG Capital annual-report-and-accounts-2020 2021.pdf\n",
      "Hikma Pharmaceuticals PLC Annual report 2020.pdf\n",
      "Hill & Smith annual-report-2020.pdf\n",
      "Hilton Food Group annual-report-2020.pdf\n",
      "Hiscox Ltd Annual Report 2020.pdf\n",
      "Hochschild-AR2020-Single-Pages.pdf\n",
      "homeserve plc AR 2021.pdf\n",
      "Howden Joinery Group PLC Annual Report 2020.pdf\n",
      "HSBC Holdings PLC AR 2020.pdf\n",
      "Ibstock-annual-report-2020.pdf\n",
      "IMI PLC Annual Report 2020.pdf\n",
      "Imperial Brands PLC AR 2020.pdf\n",
      "Inchape PLC Annual Report 2020.pdf\n",
      "INDIVIOR -2020-Annual-Report_Web.pdf\n",
      "informa-annual-report--financial-statements-2020.pdf\n",
      "IntegraFin Holding PLC Annual Report 2020.pdf\n",
      "Intercontinental Hotels Group PLC AR 2020.pdf\n",
      "Intermediate Capital Group plc annual report 2021.pdf\n",
      "International Consolidated Airlines Group AR 2020.pdf\n",
      "Intertek_Group_plc_Annual_Report_2020.pdf\n",
      "Investec-Volume-1-Annual-Report-2021-Online.pdf\n",
      "Investec-Volume-2-Annual-Report-2021-Online.pdf\n",
      "Investec-Volume-3-Annual-Report-2021-Online.pdf\n",
      "IP Group AR 2020.pdf\n",
      "ITV PLC annual-report-2020.pdf\n",
      "IWG PLC Annual Report 2020.pdf\n",
      "JD Sports annual-report-2021.pdf\n",
      "JD Sports Fashion plc annual report 2021.pdf\n",
      "John Laing Group PLC Annual Report 2020.pdf\n",
      "John Wood Group PLC Annual Report 2020.pdf\n",
      "Johnson Matthey plc annual report 2021.pdf\n",
      "JTC Full_Annual_Report_2020-21.pdf\n",
      "Jupiter Fund Management Annual Report 2020.pdf\n",
      "Just Eat PLC Annual Report 2020.pdf\n",
      "Just Group AR 2020.pdf\n",
      "KAZ Minerals PLC annual report 2020.pdf\n",
      "Kingfisher plc 2020-21 AR.pdf\n",
      "Lancashire_2020_Annual_Report_210301.pdf\n",
      "Land Securities Group plc ar 2021.pdf\n",
      "Legal & General Group PLC AR 2020.pdf\n",
      "Lloyds Banking Group PLC AR 2020.pdf\n",
      "Londonmetric Property plc AR 2021.pdf\n",
      "LSEG Annual Report 2020.pdf\n",
      "M&G Plc Annual Report 2020.pdf\n",
      "Man Group PLC Annual Report 2020.pdf\n",
      "Marks and Spencer Group plc ar 2021.pdf\n",
      "Marshalls-plc-Annual-Report-and-Accounts-2020.pdf\n",
      "Mediclinic International plc 2021 Annual Report.pdf\n",
      "Meggitt-AR-2020-Web-PDF.pdf\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "mupdf: invalid page object\n",
      "mupdf: invalid page object\n",
      "mupdf: invalid page object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "melrose-annual-report-and-accounts-2020.pdf\n",
      "Micro Focus International PLC Annual Report 2020.pdf\n",
      "Mitchells & Butlers PLC Annual report 2020.pdf\n",
      "mondi_integrated-report-2020.pdf\n",
      "Moneysupermarket com Group Annual Report-2020.pdf\n",
      "morgan-ar2020.pdf\n",
      "Morgan_Sindall_Interactive-AR2020-21.pdf\n",
      "Morrisons (WM) Supermarkets plc AR 20 to 21.pdf\n",
      "National Express Group PLC Annual Report 2020.pdf\n",
      "NATIONAL GRID Full Report_Interactive_v2 2020-21.pdf\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "mupdf: cannot create appearance stream for  widgets\n",
      "mupdf: cannot create appearance stream for  widgets\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "natwest-group-annual-report-accounts-2020-21.pdf\n",
      "Network International Holding PLC Annual Report 2020.pdf\n",
      "Next AR 2021.pdf\n",
      "Next PLC AR 2020.pdf\n",
      "Ocado Group-Annual Report 2020.pdf\n",
      "Onesavings Bank PLC Annual Report 2020.pdf\n",
      "OXFORD BIOMEDICA AR_2020-21.pdf\n",
      "Page Group PLC Annual Report 2020.pdf\n",
      "ParagonBankingGroup_AR_2020.pdf\n",
      "Pearson PLC Annual Report 2020.pdf\n",
      "Pennon Group plc AR 2021.pdf\n",
      "Pershing-Square-Holdings-Ltd.-2020-Annual-Report-1.pdf\n",
      "persimmon_ar2020_web_bmarks-final.pdf\n",
      "Petropavoslak _Report_and_Accounts_2020-1.pdf\n",
      "Pets at Home Group plc AR 2021.pdf\n",
      "Phoenix Group Holdings Annual report 2020.pdf\n",
      "Playtech annual-report-2020.pdf\n",
      "Plus500_Annual_Report_20.pdf\n",
      "Polymetal_Annual_Report_2020.pdf\n",
      "Polypipe_-AR-2020_-Interactive-19Apr21.pdf\n",
      "Premier_Foods_AR2021.pdf\n",
      "Primary-Health-Properties-PLC-Annual-Report-2020.pdf\n",
      "Provident_Financial_plc_Annual_Report_and_Financial_Statements_2020_002.pdf\n",
      "prudential-plc-ar-2020.pdf\n",
      "PureTech Health AR 2020.pdf\n",
      "Qinetiq Group plc AR 2021.pdf\n",
      "Quilter PLC Annual Report 2020.pdf\n",
      "Rank Group Annual Report and Financial Statements Dec 2020.pdf\n",
      "rathbone_brothers_plc_report_and_accounts_2020.pdf\n",
      "Reckitt Benckiser Group PLC AR 2020.pdf\n",
      "Redrow PLC annual report 2020.pdf\n",
      "Relx PLC AR 2020.pdf\n",
      "Renishaw PLC Annual Report 2020.pdf\n",
      "rentokil-initial-annual-report-2020.pdf\n",
      "RHI Magnesita NV annual-report-2020.pdf\n",
      "Rightmove PLC Annual_Report 2020.pdf\n",
      "Rio Tinto PLC AR 2020.pdf\n",
      "Rolls-Royce Holdings PLC AR 2020.pdf\n",
      "Rotork PLC Annual Report 2020.pdf\n",
      "Royal Dutch Shell PLC AR 2020.pdf\n",
      "Royal Mail Group_ar2020-21.pdf\n",
      "RSA Insurance Group PLC Annual Report 2020.pdf\n",
      "Sabre Insurance 2020-annual-report-and-accounts.pdf\n",
      "Safestore Holdings PLC Annual report 2020.pdf\n",
      "sainsburys ar2021.pdf\n",
      "Saint James Place-annual-report-and-accounts-2020_April2021.pdf\n",
      "sanne-group-plc-annual-report-2020.pdf\n",
      "Savills PLC Annual Report 2020.pdf\n",
      "schroders-annual-report-and-accounts-2020.pdf\n",
      "Segro Public Limited Company AR 2020.pdf\n",
      "Serco Group PLC Annual report 2020.pdf\n",
      "Severn Trent-annual-report-2021.pdf\n",
      "Shaftesbury Annual Report 2020.pdf\n",
      "Signature Aviation PLC Annual Report 2020.pdf\n",
      "smith nephew_annual report 2020_interactive.pdf\n",
      "Smiths Group PLC annual report 2020.pdf\n",
      "Smurfit_Kappa_Annual_Report_2020.pdf\n",
      "Softcat PLC Annual Report 2020.pdf\n",
      "Spectris PLC annual report 2020.pdf\n",
      "Spirax-Sarco S2020-annual-report.pdf\n",
      "Spirent-Communications-plc-Annual-Report-2020.pdf\n",
      "SSE AR 2021.pdf\n",
      "SSP Group PLC annual report 2020.pdf\n",
      "St Modwen Properties annual-report2020.pdf\n",
      "Standard Life Aberdeen PLC AR 2020.pdf\n",
      "standard-chartered-plc-full-year-2020-report.pdf\n",
      "Synthomer_AR2020.pdf\n",
      "Tate & Lyle plc ar 2021.pdf\n",
      "Taylor Wimpey PLC AR 2020.pdf\n",
      "tbc bank AR 2020.pdf\n",
      "Telecoms pluc plc-annual-report-2021-rgb-2-.pdf\n",
      "Tesco AR 2021.pdf\n",
      "The Sage Group Plc. AR 2020.pdf\n",
      "TI Fluid Systems 2020-annual-report.pdf\n",
      "TP ICAP PLC Annual Report 2020.pdf\n",
      "Trainline_AR2021.pdf\n",
      "Travis Perkins PLC annual-report-2020.pdf\n",
      "Tritax Big Box Reit PLC Annual Report 2020.pdf\n",
      "TUI AG Annual Report 2020.pdf\n",
      "Tullow_Oil_plc_2020-21_Annual_Report_and_Accounts.pdf\n",
      "udg-annual-report-2020-web.pdf\n",
      "UK Commercial Property Trust AR 2020.pdf\n",
      "Ultra Electronic Holding PLC Annual Report 2020.pdf\n",
      "Unilever PLC AR 2020.pdf\n",
      "Unite Group PLC Annual Report 2020.pdf\n",
      "United Utilities Group plc ar 2021.pdf\n",
      "Vectura-Group-plc-Annual-Report-and-Accounts-2020-21.pdf\n",
      "Vesuvius_AR20.pdf\n",
      "Victrex PLC Annual-Report 2020.pdf\n",
      "Virgin Money UK plc Full_Annual_Report_2020.pdf\n",
      "Vistry Group PLC Annual report 2020.pdf\n",
      "vivo-energy-annual-report-and-accounts-2020.pdf\n",
      "vodafone AR 2021.pdf\n",
      "Weir Group PLC Annual-report 2020.pdf\n",
      "Whitbread_AR2020-1_web-1.pdf\n",
      "WHSmith PLC Annual Report 2020.pdf\n",
      "William Hill PLC Annual Report 2020.pdf\n",
      "Wizz Air Holdings plc ar 2021.pdf\n",
      "Workspace Group_AR21.pdf\n",
      "wppannualreport2020.pdf\n",
      "XP Power AR 2020-21.pdf\n"
     ]
    }
   ],
   "source": [
    "path = r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\cgt_data\\final_data'\n",
    "page_num=[]\n",
    "text=[]\n",
    "file_name=[]\n",
    "for i in os.listdir(path):\n",
    "    path = path\n",
    "    file = i\n",
    "    print(i)\n",
    "    file_name.append(i)\n",
    "    a = auditor_name_v2(path, file)\n",
    "    if a:\n",
    "        page_num.append(a[0])\n",
    "        text.append(a[1])\n",
    "        \n",
    "    else:\n",
    "        page_num.append(np.nan)\n",
    "        text.append(np.nan)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "91ab7c66",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info = pd.DataFrame()\n",
    "auditor_info['filename'] = file_name\n",
    "auditor_info['page_num']= page_num\n",
    "auditor_info['text'] = text"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "f66e0434",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "54"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.text.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "96d497c2",
   "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>filename</th>\n",
       "      <th>page_num</th>\n",
       "      <th>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3i infrastructure ar 2021.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4imprint Group AR 2020.pdf</td>\n",
       "      <td>84.0</td>\n",
       "      <td>CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>888 Holdings Annual Report.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91-ninety-one-integrated-annual-report-2021.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Jatin Patel (Senior Statutory Auditor)  for an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Admiral Group Plc Annual Report 2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Mark McQueen (Senior statutory auditor) For an...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Aggreko PLC annual report 2020.pdf</td>\n",
       "      <td>106.0</td>\n",
       "      <td>John Luke (Senior Statutory Auditor)   for and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Airtel Africa Annual Report 2021.pdf</td>\n",
       "      <td>150.0</td>\n",
       "      <td>Mark Goodey (FCA) (Senior statutory auditor)  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AJ_Bell PLC Annual Report 2020.pdf</td>\n",
       "      <td>49.0</td>\n",
       "      <td>For and on behalf of BDO LLP, Statutory Audito...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Anglo American PLC AR 2020.pdf</td>\n",
       "      <td>158.0</td>\n",
       "      <td>Mark King (Senior Statutory Auditor) for and o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>antofagasta_2020_annual_report.pdf</td>\n",
       "      <td>165.0</td>\n",
       "      <td>Simon Morley (Senior Statutory Auditor)  for a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ascential PLC Annual Report 2020.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Ian Griffiths (Senior Statutory Auditor)  for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ashmore Group PLC Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Associated British Foods PLC AR 2020.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Andrew Walton (Senior Statutory Auditor)  for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Assura AnnualReport2021final.pdf</td>\n",
       "      <td>118.0</td>\n",
       "      <td>Scott Bayne, FCA (Senior statutory auditor) Fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf</td>\n",
       "      <td>96.0</td>\n",
       "      <td>SIMON O’NEILL (SENIOR STATUTORY AUDITOR) FOR A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AstraZeneca_AR_2020.pdf</td>\n",
       "      <td>176.0</td>\n",
       "      <td>Richard Hughes (Senior Statutory Auditor) for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Auto Trader  plc ar2021-web.pdf</td>\n",
       "      <td>124.0</td>\n",
       "      <td>David Derbyshire (Senior Statutory Auditor)  f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Avast PLC Annual report 2020.pdf</td>\n",
       "      <td>146.0</td>\n",
       "      <td>Marcus Butler (Senior statutory auditor)  for ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Aveva AR 2021.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Christopher Voogd (Senior statutory auditor) f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>aviva-plc-annual-report-and-accounts-2020.pdf</td>\n",
       "      <td>130.0</td>\n",
       "      <td>Alex Bertolotti (Senior Statutory Auditor)  fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>avon-rubber-annual-report-2020.pdf</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Andrew Campbell-Orde (Senior Statutory Auditor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B&amp;MFull_Annual_Report_and_Accounts_2021.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BAE Systems PLC AR 2020.pdf</td>\n",
       "      <td>185.0</td>\n",
       "      <td>John Adam  Senior Statutory Auditor For and on...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Balfour Beatty PLC Annual Report 2020.pdf</td>\n",
       "      <td>164.0</td>\n",
       "      <td>for and on behalf of KPMG LLP, Statutory Audit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Barclays PLC AR 2020.pdf</td>\n",
       "      <td>279.0</td>\n",
       "      <td>Michelle Hinchliffe  (Senior Statutory Auditor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Barratt Developments P L C AR 2020.pdf</td>\n",
       "      <td>166.0</td>\n",
       "      <td>Claire Faulkner (Senior statutory auditor)   F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Beazley PLC Annual Report-2020.pdf</td>\n",
       "      <td>128.0</td>\n",
       "      <td>Stuart Wilson (Senior Statutory Auditor) for a...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>bellway_ar20_web.pdf</td>\n",
       "      <td>104.0</td>\n",
       "      <td>Johnathan Pass (Senior Statutory Auditor)   fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BHP Group PLC AR 2020.pdf</td>\n",
       "      <td>254.0</td>\n",
       "      <td>Gary Donald  Senior Statutory Auditor  for and...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Biffa Annual Report and Accounts FY21 Final.pdf</td>\n",
       "      <td>135.0</td>\n",
       "      <td>Peter Gallimore, FCA  Senior statutory auditor...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           filename  page_num  \\\n",
       "0                     3i infrastructure ar 2021.pdf       NaN   \n",
       "1                        4imprint Group AR 2020.pdf      84.0   \n",
       "2                    888 Holdings Annual Report.pdf       NaN   \n",
       "3   91-ninety-one-integrated-annual-report-2021.pdf     120.0   \n",
       "4          Admiral Group Plc Annual Report 2020.pdf     174.0   \n",
       "5                Aggreko PLC annual report 2020.pdf     106.0   \n",
       "6              Airtel Africa Annual Report 2021.pdf     150.0   \n",
       "7                AJ_Bell PLC Annual Report 2020.pdf      49.0   \n",
       "8                    Anglo American PLC AR 2020.pdf     158.0   \n",
       "9                antofagasta_2020_annual_report.pdf     165.0   \n",
       "10             Ascential PLC Annual Report 2020.pdf     120.0   \n",
       "11         Ashmore Group PLC Annual Report 2020.pdf       NaN   \n",
       "12         Associated British Foods PLC AR 2020.pdf     137.0   \n",
       "13                 Assura AnnualReport2021final.pdf     118.0   \n",
       "14   Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf      96.0   \n",
       "15                          AstraZeneca_AR_2020.pdf     176.0   \n",
       "16                  Auto Trader  plc ar2021-web.pdf     124.0   \n",
       "17                 Avast PLC Annual report 2020.pdf     146.0   \n",
       "18                                Aveva AR 2021.pdf     137.0   \n",
       "19    aviva-plc-annual-report-and-accounts-2020.pdf     130.0   \n",
       "20               avon-rubber-annual-report-2020.pdf     110.0   \n",
       "21      B&MFull_Annual_Report_and_Accounts_2021.pdf       NaN   \n",
       "22                      BAE Systems PLC AR 2020.pdf     185.0   \n",
       "23        Balfour Beatty PLC Annual Report 2020.pdf     164.0   \n",
       "24                         Barclays PLC AR 2020.pdf     279.0   \n",
       "25           Barratt Developments P L C AR 2020.pdf     166.0   \n",
       "26               Beazley PLC Annual Report-2020.pdf     128.0   \n",
       "27                             bellway_ar20_web.pdf     104.0   \n",
       "28                        BHP Group PLC AR 2020.pdf     254.0   \n",
       "29  Biffa Annual Report and Accounts FY21 Final.pdf     135.0   \n",
       "\n",
       "                                                 text  \n",
       "0                                                 NaN  \n",
       "1   CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...  \n",
       "2                                                 NaN  \n",
       "3   Jatin Patel (Senior Statutory Auditor)  for an...  \n",
       "4   Mark McQueen (Senior statutory auditor) For an...  \n",
       "5   John Luke (Senior Statutory Auditor)   for and...  \n",
       "6   Mark Goodey (FCA) (Senior statutory auditor)  ...  \n",
       "7   For and on behalf of BDO LLP, Statutory Audito...  \n",
       "8   Mark King (Senior Statutory Auditor) for and o...  \n",
       "9   Simon Morley (Senior Statutory Auditor)  for a...  \n",
       "10  Ian Griffiths (Senior Statutory Auditor)  for ...  \n",
       "11                                                NaN  \n",
       "12  Andrew Walton (Senior Statutory Auditor)  for ...  \n",
       "13  Scott Bayne, FCA (Senior statutory auditor) Fo...  \n",
       "14  SIMON O’NEILL (SENIOR STATUTORY AUDITOR) FOR A...  \n",
       "15  Richard Hughes (Senior Statutory Auditor) for ...  \n",
       "16  David Derbyshire (Senior Statutory Auditor)  f...  \n",
       "17  Marcus Butler (Senior statutory auditor)  for ...  \n",
       "18  Christopher Voogd (Senior statutory auditor) f...  \n",
       "19  Alex Bertolotti (Senior Statutory Auditor)  fo...  \n",
       "20  Andrew Campbell-Orde (Senior Statutory Auditor...  \n",
       "21                                                NaN  \n",
       "22  John Adam  Senior Statutory Auditor For and on...  \n",
       "23  for and on behalf of KPMG LLP, Statutory Audit...  \n",
       "24  Michelle Hinchliffe  (Senior Statutory Auditor...  \n",
       "25  Claire Faulkner (Senior statutory auditor)   F...  \n",
       "26  Stuart Wilson (Senior Statutory Auditor) for a...  \n",
       "27  Johnathan Pass (Senior Statutory Auditor)   fo...  \n",
       "28  Gary Donald  Senior Statutory Auditor  for and...  \n",
       "29  Peter Gallimore, FCA  Senior statutory auditor...  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "d0505edb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.1839080459770115"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "48/261"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "id": "e5c11e42",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "82"
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "100-18"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "b83498d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info.to_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\auditor_text.csv', index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "973240e8",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "d6404edc",
   "metadata": {},
   "source": [
    "# extract company names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ac733f8d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import spacy\n",
    "nlp = spacy.load('en_core_web_sm')\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "3c0d27db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Julian Young (Senior statutory auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor  London',\n",
       " 'CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) for and on behalf of Ernst & Young LLP,  Statutory Auditor Birmingham  16 March 2021',\n",
       " 'Mark McQueen (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor  London, United Kingdom 3 March 2021',\n",
       " 'David Sweeney, CA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Glasgow, United Kingdom 8 April 2020',\n",
       " 'John Luke (Senior Statutory Auditor)   for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'MARK GOODEY (FCA) (SENIOR STATUTORY AUDITOR)   FOR AND ON BEHALF OF DELOITTE LLP  STATUTORY AUDITOR  LONDON, UNITED KINGDOM',\n",
       " 'For and on behalf of BDO LLP, Statutory Auditor  London, United Kingdom   2 December 2020',\n",
       " 'At the 2020 AGM, shareholders approved the appointment  of PricewaterhouseCoopers LLP (PwC) as the Company’s  new Statutory Auditor. The proposed change in auditor was  communicated to shareholders in May 2019. This extended lead time  provided a smooth handover process from Deloitte LLP (Deloitte),  the previous Statutory Auditor, and allowed PwC to shadow Deloitte  through areas of the 2019 statutory audit process, giving them a  good understanding of the business.',\n",
       " 'Simon Morley (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'Ian Griffiths (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants',\n",
       " 'nan',\n",
       " 'WILLIAM SMITH   (SENIOR STATUTORY AUDITOR) for and on behalf of Deloitte LLP Statutory Auditor London, UK 15 June 2020',\n",
       " 'Andrew Walton (Senior Statutory Auditor)  for and on behalf of Ernst & Young LLP, Statutory Auditor  London  3 November 2020',\n",
       " 'Scott Bayne, FCA (senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Manchester, United Kingdom 20 May 2020',\n",
       " 'Richard Hughes (Senior Statutory Auditor) for and on behalf of   PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 11 February 2021',\n",
       " 'Mick Davies (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  1 St Peter’s Square Manchester M2 3AE 25 June 2020',\n",
       " 'In order to mitigate the risk of working remotely during   the current year audit, the senior statutory auditor held  regular video conference calls with the Czech Republic   and UK based members of the audit team to lead discussion  of the audit approach and issues arising from the audit   work, focussing his time on the significant risks and  judgemental areas of the audit. There have been no new  core members of the integrated audit team and the senior  statutory auditor has held face-to-face meetings with all   core team members previously.',\n",
       " 'nan',\n",
       " 'Alex Bertolotti (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  3 March 2021',\n",
       " 'nan',\n",
       " 'John Waters (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'John Adam  Senior Statutory Auditor For and on behalf of   Deloitte LLP Statutory Auditor London, United Kingdom   24 February 2021',\n",
       " 'Arif Ahmad (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  Birmingham  15 March 2021',\n",
       " 'for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants   15 Canada Square  London  E14 5GL',\n",
       " 'John Headley (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London 30 March 2021',\n",
       " 'Michelle Hinchliffe  (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'Claire Faulkner (Senior statutory auditor)   For and on behalf of Deloitte LLP   Statutory Auditor   London  United Kingdom  1 September 2020',\n",
       " 'Stuart Wilson (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London',\n",
       " 'Michael Harper  (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants',\n",
       " 'Gary Donald  Senior Statutory Auditor  for and on behalf of',\n",
       " 'Simon Morley (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  12 March 2021',\n",
       " \"Due to the COVID-19 pandemic and the travel restrictions in place during the year, the senior statutory auditor and other group audit partners were  unable to conduct visits to meet with the component teams responsible for the full scope locations, and other key locations including the key Global  Business Services (GBS) accounting locations. As a result of this, we performed alternative virtual procedures which included attending planning  meetings, discussing the audit approach and any issues arising from the component team's work, meetings with local management, and reviewing key  audit working papers on higher and significant-risk areas to drive a consistent and high-quality audit. In addition, a global audit planning meeting was  held virtually for two days in July led by the senior statutory auditor and involving the group audit team, partners and staff from all full scope component  teams, audit teams responsible for testing at key GBS locations, senior management from bp, and the audit committee chairman.\",\n",
       " 'Robert Topley FCA (Senior statutory auditor)  for and on behalf of Deloitte LLP Statutory Auditor',\n",
       " 'Jeremy Hall (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'nan',\n",
       " 'CHRISTABEL COWLING (SENIOR STATUTORY AUDITOR) for and on behalf of Ernst & Young LLP, Statutory Auditor   Leeds  26 November 2020',\n",
       " 'Antony Cates (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square London E14 5GL 6 May 2020',\n",
       " 'Neil Grimes (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  1 March 2021',\n",
       " 'PAUL CRAGG (SENIOR STATUTORY AUDITOR)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors',\n",
       " 'Lindsay Gardiner (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors Edinburgh 8 March 2021',\n",
       " 'for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'Robert Brent (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants    15 Canada Square, London, E14 5GL   16 March 2021',\n",
       " 'ANDREW PAYNTER (SENIOR STATUTORY AUDITOR)  FOR AND ON BEHALF OF PRICEWATERHOUSECOOPERS LLP  CHARTERED ACCOUNTANTS AND STATUTORY AUDITORS  LONDON',\n",
       " 'Nick Plumb (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 1 Sovereign Square Sovereign Street Leeds LS1 4DA 2 June 2020',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'Christopher Richmond (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 25 March 2021',\n",
       " 'Christopher Burns (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 5 March 2021',\n",
       " 'Mark Hannam (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London',\n",
       " 'Georgina Robb FCA (Senior statutory auditor)  For and on behalf of Deloitte LLP Statutory Auditor  London, United Kingdom  10 March 2021',\n",
       " 'Edward Hanson (senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor  London, United Kingdom',\n",
       " '204 Report of the statutory auditor  on\\xa0Coca-Cola HBC AG’s  consolidated financial statements 210 Report of the statutory auditor  on\\xa0Coca-Cola HBC AG’s financial  statements 213 Coca-Cola HBC AG’s financial  statements 224 Report of the statutory auditor  on\\xa0the remuneration report 225 Statutory Remuneration Report',\n",
       " 'Paul Korolkiewicz (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants',\n",
       " 'David Neale (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square London E14 5GL 15 March 2021',\n",
       " 'Matthew Hall (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London',\n",
       " 'Mark Mullins FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 4 March 2021',\n",
       " 'John Waters (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 2 December 2020',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'Chris Hearld (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants   1 Sovereign Square  Sovereign Street  Leeds  LS1 4DA  1 March 2021',\n",
       " 'nan',\n",
       " 'Andrew Hammond (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors Birmingham 7 September 2020',\n",
       " 'Sandra Dowling (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors  London 10 March 2021',\n",
       " 'Ian Chambers (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 4 August 2020',\n",
       " 'Christopher Burns (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 16 November 2020',\n",
       " 'nan',\n",
       " 'Stephen Griggs (Senior Statutory Auditor)  for and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom',\n",
       " 'for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  Watford',\n",
       " 'Anthony Matthews FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 24 February 2021',\n",
       " 'Nicola Mitchell  (Senior Statutory Auditor)   for and on behalf of Deloitte LLP   Statutory Auditor   London, United Kingdom  1 July 2020',\n",
       " 'nan',\n",
       " 'for and on behalf of PricewaterhouseCoopers LLP   Chartered Accountants and Statutory Auditors',\n",
       " 'nan',\n",
       " 'CHRISTOPHER POWELL, FCA, (SENIOR STATUTORY AUDITOR) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 23 March 2021',\n",
       " 'Andrew Smyth (Senior Statutory Auditor)  for and on behalf of Ernst & Young LLP, Statutory Auditor  London  18 April 2021      Notes:',\n",
       " 'Darren Meek (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP',\n",
       " 'Nicholas Stevenson (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  Milton Keynes  5 March 2021',\n",
       " 'Jason Burkitt (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'The overall audit strategy is determined  by the senior statutory auditor. The senior  statutory auditor is based in the UK,  but, since Group management and many  operations reside in Russia, the Group  audit team includes members from both  the UK and Russia who work together  as an integrated team throughout the audit  process. The senior statutory auditor  focused his time on the significant risks  and judgemental areas of the audit. He  attended management’s going concern,  impairment and significant estimates  and judgements presentations  to the Audit Committee via video calls.  During the current year’s audit he reviewed  key working papers and held conference  calls with representatives of the component  audit team for all Russian and North  American based full and specific scope  components including internal valuation  specialists used in the audit to discuss  the audit approach and issues arising  from their work.',\n",
       " 'nan',\n",
       " 'Katharine Finn (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 9 March 2021',\n",
       " 'Ian Waller  (Senior statutory auditor)  For and on behalf of Deloitte LLP  Recognised Auditor  London, UK',\n",
       " 'For and on behalf of  MHA MacIntyre Hudson Chartered Accountants and Statutory Auditors  London, United Kingdom 16 March 2021',\n",
       " 'The Group audit team have directed and supervised the work of the component audit teams during the course of the year. We issued detailed  instructions to our component audit teams and included all component teams in our team briefing, discussed their risk assessment and remained  in contact throughout the audit process. The Senior Statutory Auditor met all component teams and held meetings with Management at all  significant components to discuss the work performed. The audits of Avanti, GWR and TPE are led by members of the Group audit team. For all  UK components, the Senior Statutory Auditor has access to the audit files and directly reviews the work performed in key risk areas relevant to  the Group, including significant risk areas.',\n",
       " 'nan',\n",
       " 'For and on behalf of RSM UK Audit LLP,  Statutory Auditor',\n",
       " 'Steven Dobson (Senior statutory auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London',\n",
       " 'Katharine Finn (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  Bristol  10 December 2020',\n",
       " 'nan',\n",
       " 'Thomas Edward Goodworth (Senior Statutory Auditor) For and on behalf of BDO LLP, Statutory Auditor  London, UK  16 September 2020',\n",
       " 'MARK TOLLEY FCA (SENIOR STATUTORY AUDITOR) For and on behalf of Deloitte LLP Statutory Auditor Reading, United Kingdom 7 September 2020',\n",
       " 'nan',\n",
       " 'nan',\n",
       " '•  So far as the Director is aware, there is no relevant audit information (as defined in the Companies Act 2014) of which the statutory Auditor is  unaware; and •  The Director has taken all the steps that he/she ought to have taken as a Director to make himself/herself aware of any relevant audit information  (as defined) and to ensure that the statutory Auditor is aware of such information.',\n",
       " 'Richard Kelly (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants   15 Canada Square Canary Wharf  London   E14 5GL',\n",
       " 'Judith Tacon (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom  9 June 2020',\n",
       " 'nan',\n",
       " 'Timothy Steel (Senior statutory auditor)  For and on behalf of Deloitte LLP  Statutory Auditor  London, UK  29 April 2021',\n",
       " 'Nick Plumb (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  Quayside House  110 Quayside Newcastle Upon Tyne NE1 3DX',\n",
       " 'Owen Mackney (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'Sonia Copeland (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'Alex Bertolotti (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " '(Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 26 August 2020',\n",
       " 'for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors',\n",
       " 'for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'Martin Cowie (Senior Statutory Auditor)  for and on behalf of  PricewaterhouseCoopers LLP Chartered Accountants and  Statutory Auditors  Belfast',\n",
       " 'nan',\n",
       " 'Peter Birch FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Leeds, UK  19 May 2020',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'William Smith (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, UK 4 March 2021',\n",
       " 'Jonathan Dodworth   (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Birmingham, United Kingdom  9 March 2021',\n",
       " 'DARREN MEEK (SENIOR STATUTORY AUDITOR) FOR AND ON BEHALF OF PRICEWATERHOUSECOOPERS LLP Chartered Accountants and Statutory Auditors London 23 July 2020',\n",
       " 'For and on behalf of Ernst & Young LLP, Statutory Auditor   Birmingham  25 February 2021',\n",
       " 'ANDREW WALTON (SENIOR STATUTORY AUDITOR) for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'nan',\n",
       " 'For and on behalf of Deloitte LLP   Statutory Auditor   London    22 April 2021',\n",
       " 'For and on behalf of BDO LLP,  Statutory Auditor',\n",
       " 'The reviews were planned and executed consistent with the  timing and scope of our planned visits. The Senior Statutory Auditor,  and other members of the Primary Team, completed their reviews  remotely for the component teams in the United Kingdom, United  States and India. We used our global audit software to enable the  Senior Statutory Auditor, and other members of the Primary Team,  to complete reviews of key component team working papers,  particularly focussing on the Group’s risk areas. We conducted  meetings using video conferencing to discuss the audit approach  and execution with the component teams and to discuss audit  issues arising from their work. The Senior Statutory Auditor, or  other members of the Primary Team, attended key meetings  with local management via video conference.',\n",
       " 'Allee Bonnard (Senior statutory auditor)  For and on behalf of Deloitte LLP  Statutory Auditor  London',\n",
       " 'nan',\n",
       " 'Ian Chambers (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'nan',\n",
       " 'Jonathan Martin (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square London  E14 5GL',\n",
       " 'Paul Sawdon (Senior Statutory Auditor)   for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants    15 Canada Square  London  E14 5GL',\n",
       " 'nan',\n",
       " 'The Senior Statutory Auditor is also responsible for the audit of Sainsbury’s  Supermarkets Ltd and Argos Limited. For Sainsbury’s Bank plc and Argos  Financial Services, the Senior Statutory Auditor met and held discussions  with management. The team discussed the audit approach with the  component team and significant issues arising from their work, reviewing  key audit working papers on risk areas. The closing meeting was attended  by the primary audit team. This, together with the additional procedures  performed at Group level, gave us appropriate evidence for our opinion on  the Group financial statements. For the insurance company, the team  discussed the audit approach with the component team and interacted  regularly with the component team where appropriate during various stages  of the audit in order to understand the key audit findings.',\n",
       " 'Mike Barradell (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square Canary Wharf London E14 5GL',\n",
       " 'STUART BURDASS  (Senior Statutory Auditor)for and on behalf  of KPMG LLP, Statutory Auditor  Chartered Accountants  1 St. Peter’s Square, Manchester, M2 3AE   7th July 2020',\n",
       " 'Misstatements can arise from fraud or error and are  considered material if, individually or in the aggregate,  they could reasonably be expected to influence the  economic decisions of users taken on the basis of  these financial statements.    A further description of our responsibilities for the audit  of the financial statements is located on the Financial  Reporting Council’s website at:  www.frc.org.uk/auditorsresponsibilities. This description  forms part of our auditor’s report.    Other matters which we are required to address  We were appointed by the Board on 9 November 2017  The period of total uninterrupted engagement including  previous renewals and reappointments of the firm is  between 2 and 3 periods of 52 weeks. The non-audit  services prohibited by the FRC’s Ethical Standard were  not provided to the company and we remain  independent of the company in conducting our audit.  Non-audit services provided to the Company have  been disclosed within Note 2 to the financial  statements on page 21.    Our audit opinion is consistent with the additional report  to the Audit Committee.    Use of our report  This report is made solely to the company’s members,  as a body, in accordance with Chapter 3 of Part 16 of  the Companies Act 2006. Our audit work has been  undertaken so that we might state to the company’s  members those matters we are required to state to  them in an auditor’s report and for no other purpose. To  the fullest extent permitted by law, we do not accept or  assume responsibility to anyone other than the  company and the company’s members as a body, for  our audit work, for this report, or for the opinions we  have formed.                    Marc Summers BSc (Hons) FCA  Senior Statutory Auditor  for and on behalf of Grant Thornton UK LLP  Statutory Auditor, Chartered Accountants  London      16 October 2020',\n",
       " 'Claire Faulkner FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor',\n",
       " 'Catherine Burnet (Senior Statutory Auditor)   for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'Mark Gill (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London',\n",
       " 'Lindsay Gardiner (Senior Statutory Auditor) for and on behalf of   PricewaterhouseCoopers LLP Chartered Accountants and Statutory  Auditors  London 25 February 2021',\n",
       " 'nan',\n",
       " 'Lee Clarke (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP chartered Accountants and statutory Auditors london 16 March 2021',\n",
       " 'Richard Howard  (Senior statutory auditor) For and on behalf of Deloitte (NI) Limited Statutory Auditor Belfast, United Kingdom',\n",
       " 'Juliette Lowes (Senior Statutory Auditor) for  and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square,  London, E14 5GL 1 March 2021',\n",
       " 'For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom',\n",
       " 'Rees Aronson  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'Vanessa-Jayne Bradley (Senior Statutory Auditor) For and on behalf of BDO LLP, Statutory Auditor London United Kingdom 25 February 2021',\n",
       " 'Rees Aronson (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  KPMG LLP 15 Canada Square, London, E14 5GL',\n",
       " 'Mark Hannam (Senior Statutory Auditor)      for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  23 February 2021',\n",
       " 'nan',\n",
       " 'Nicholas Dawes (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London 5 March 2021',\n",
       " 'Stuart Crisp (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'nan',\n",
       " 'For and on behalf of Deloitte LLP  Statutory Auditor  London  26 May 2020',\n",
       " 'David Johnson FCA (Senior Statutory Auditor) for and on behalf of Deloitte LLP Statutory Auditor Leeds, United Kingdom 11 March 2021',\n",
       " 'John Leech (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'Giles Hannam (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 1 June 2020',\n",
       " 'Edward Hanson (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom',\n",
       " 'Tudor\\tAw\\t(Senior\\tStatutory\\tAuditor)\\t for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square, Canary Wharf, London, E14 5GL 8 February 2021',\n",
       " 'For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom',\n",
       " 'for and on behalf of PricewaterhouseCoopers LLP   Chartered Accountants and Statutory Auditors  London',\n",
       " 'Suvro Dutta (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square London  E14 5GL  17 February 2021',\n",
       " 'Jane Makrakis, ACA  (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Reading, United Kingdom',\n",
       " '7.3. Working with other auditors The Group audit team continued to follow a programme of planned oversight designed so that the Senior Statutory Auditor and/or a  senior member of the audit team continually oversees each of the three non-UK divisions where the Group audit scope was focussed.  In previous years, this included at least one physical visit per year, but in light of Covid-19 travel restrictions this has been replaced with  virtual communications and oversight. In relation to the current year audit the Senior Statutory Auditor has maintained appropriate  oversight of non-UK components and both UK divisions for component reporting and reviewing purposes.',\n",
       " 'Douglas King FCA (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom  17 June 2020',\n",
       " 'Michael Harper (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square  London, E14 5GL',\n",
       " 'Christopher Burns (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'Andrew Lyon (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  East Midlands',\n",
       " 'Mark Lee-Amies FCA (Senior Statutory Auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 9 February 2021',\n",
       " 'Robert Topley FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 8 April 2021',\n",
       " 'Bob Forsyth (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor  London  3 March 2021',\n",
       " 'for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'Michael Harper (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square, Canary Wharf, E14 5GL 27 May 2020',\n",
       " 'Giles Hannam (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'nan',\n",
       " 'Peter McIver (Senior statutory auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London',\n",
       " 'nan',\n",
       " 'Stuart Burdass (Senior Statutory Auditor)   for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants  1 St Peter’s Square  Manchester   M2 3AE',\n",
       " 'Stuart Wilson  (Senior statutory auditor)  for and on behalf of Ernst & Young LLP,   Statutory Auditor  London',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'Matthew Perkins (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Birmingham, United Kingdom 10 May 2021',\n",
       " 'Philip Smart (Senior Statutory Auditor)  For and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'Robert Seale (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants 15 Canada Square London E14 5GL  April\\xa014, 2021',\n",
       " 'Jane Boardman BSc FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor Manchester, UK',\n",
       " 'nan',\n",
       " 'Julian Gray  Senior Statutory Auditor  for and on behalf of PricewaterhouseCoopers LLP   Chartered Accountants and Statutory Auditors   Southampton',\n",
       " 'Richard Broadbelt (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square London E14 5GL',\n",
       " 'Nick Plumb (Senior Statutory Auditor)    for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'Hywel Ball (Senior statutory auditor)  for and on behalf of Ernst & Young LLP, Statutory Auditor  London 10 February 2021',\n",
       " 'Paul Mapleston (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor  Bristol',\n",
       " 'Michael Maloney (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants  15 Canada Square  London E14 5GL',\n",
       " 'nan',\n",
       " 'Anna Jones (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'Matthew Price (Senior statutory auditor)  for and on behalf of Ernst & Young LLP, Statutory Auditor London  1 March 2021',\n",
       " 'Ian Chambers (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors London 11 March 2021',\n",
       " 'David Griffin FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 1 March 2021',\n",
       " 'ALLISTER WILSON Senior Statutory Auditor for and on behalf of Ernst & Young LLP  London March 10, 2021',\n",
       " 'Salim Tharani (Senior Statutory Auditor)   for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants',\n",
       " 'STUART WILSON (SENIOR STATUTORY AUDITOR) for and on behalf of Ernst & Young LLP, Statutory Auditor  London',\n",
       " 'Darren Longley FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 13 January 2021',\n",
       " 'nan',\n",
       " 'for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'JOHN WATERS (SENIOR STATUTORY AUDITOR) FOR AND ON BEHALF OF PRICEWATERHOUSECOOPERS LLP CHARTERED ACCOUNTANTS AND STATUTORY AUDITORS LONDON 18 FEBRUARY 2021',\n",
       " 'John Luke (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square, London, E14 5GL 24 February 2021',\n",
       " 'Kari Hale, ACA (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor',\n",
       " 'Daniel Saunders (Senior statutory auditor)  for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'Zulfikar Walji (Senior Statutory Auditor)  for and on behalf of KPMG LLP,  Statutory Auditor',\n",
       " 'Michael Maloney (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants   15 Canada Square  London E14 5GL',\n",
       " 'David Hales (Senior Statutory Auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor London 19 October 2020',\n",
       " 'Andrew Bond, FCA (Senior statutory auditor)  For and on behalf of Deloitte LLP  Statutory Auditor  Reading UK  24 February 2021',\n",
       " 'Joe Yglesia (Senior Statutory Auditor) For and on behalf of Ernst & Young LLP, Statutory Auditor Reading 11 March 2021',\n",
       " 'The Group audit team started a programme of planned visits that has been designed to ensure that the Senior Statutory Auditor visits  approximately 95% of full and specific scope components, with the majority of components based at the same location. The only in audit  scope components that the Senior Statutory Auditor did not visit in the current year consisted of: SSE Airtricity Energy Supply (NI) Ltd, SSE  Airtricity Ltd and SGN. During the current year’s audit cycle, visits were undertaken by the primary audit team to the component teams in Perth  and Reading. These visits involved discussing the audit approach with the component team and issues arising from their work and review  of key audit working papers. The Senior Statutory auditor also attended 5 audit clearance meetings, by video call covering 18 full and 20  specific scope components. The primary team interacted regularly with the component teams where appropriate during various stages of the  audit, reviewed key working papers and were responsible for the scope and direction of the audit process. This, together with the additional  procedures performed at Group level, gave us appropriate evidence for our opinion on the Group financial statements.',\n",
       " 'Nicholas Frost  (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor Chartered Accountants  15 Canada Square  London, E14 5GL',\n",
       " 'William Meredith (Senior Statutory Auditor)  for and on behalf of KPMG LLP,  Statutory Auditor  Chartered Accountants  15 Canada Square  Canary Wharf London E14 5GL',\n",
       " 'Kevin Weston Senior statutory auditor   for and on behalf of Ernst & Young LLP, Statutory Auditor  Glasgow',\n",
       " 'Jonathan Mills (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor   Chartered Accountants  Saltire Court  20 Castle Terrace   Edinburgh  EH1 2EG  9 March 2021',\n",
       " 'The Audit Committee held its annual conference call during  the year, which was hosted by the Audit Committee Chair   and attended by the chairs of subsidiary audit committees.  The Group Head, Finance, Group Head of Internal Audit,  Group Head, Corporate Affairs, Brand & Marketing, Conduct,  Financial Crime and Compliance, lead audit partner of the  Group’s outgoing statutory auditor at the time, KPMG, lead  audit partner of the Group’s incoming statutory auditor at the  time, EY, and the Group Company Secretary also participated  in the call. Items discussed during the call included:',\n",
       " 'John Clacy (FCA) For and on behalf of Deloitte LLP  Statutory Auditor  St Peter Port, Guernsey  11 June 2020',\n",
       " 'Kate J Houldsworth FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, UK 11 June 2020',\n",
       " 'Lloyd Brown  (Senior statutory auditor)  For and on behalf of Ernst & Young LLP, Statutory Auditor  London',\n",
       " 'Dean Cook MA FCA (Senior statutory auditor)  for and on behalf of Deloitte LLP   Statutory Auditor  London, United Kingdom',\n",
       " 'Allan McGrath (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors Edinburgh 26 April 2021',\n",
       " 'Simon Letts (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom',\n",
       " 'Bob Forsyth (Senior statutory auditor) for and on behalf of Ernst & Young LLP, Statutory Auditor',\n",
       " 'Kathryn Barrow (Senior statutory auditor)  for and on behalf of Ernst & Young LLP,   Statutory Auditor  London  20 November 2020',\n",
       " 'JULIE CARLYLE (SENIOR STATUTORY AUDITOR) FOR AND ON BEHALF OF ERNST & YOUNG LLP,   STATUTORY AUDITOR  London',\n",
       " 'Christopher Powell, FCA (Senior statutory auditor) for and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom',\n",
       " 'Andrew Hammond (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors Birmingham 15 March 2021',\n",
       " 'Fiona Walker For and on behalf of Deloitte LLP Statutory Auditor London, United Kingdom 9 March 2021',\n",
       " 'nan',\n",
       " 'Anthony Sykes (Senior Statutory Auditor) for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'nan',\n",
       " 'Deloitte is in its fifth year as auditor to the Company  and in accordance with present professional  guidelines the Senior Statutory Auditor will be  rotated after no more than five years. The current  Senior Statutory Auditor John Clacy has served  for five years and hence will be replaced by David  Becker for the 2021 audit.',\n",
       " 'nan',\n",
       " '(Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor',\n",
       " 'nan',\n",
       " 'present the information. The committee reports its  findings and makes recommendations to the board  accordingly. The committee is supported in this  role by using the expertise of the statutory auditor,  who in the course of the audit, considers whether  accounts have been prepared in accordance with  IFRS and whether adequate accounting records have  been kept. Furthermore, the company’s own internal  audit team also contributes to the assurance process  by reviewing compliance with internal processes.  The statutory auditor presents its findings to the  shareholders as the owners of the business, and its  report can be found on pages 194 to 200.',\n",
       " 'Darryl Phillips (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'Ian Morrison (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors Manchester 9 December 2020',\n",
       " 'Steven Robb (Senior Statutory Auditor)  for and on behalf of Ernst & Young LLP,  Statutory Auditor Leeds 24 November 2020',\n",
       " 'Matthew Mullins (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP',\n",
       " 'Nicholas Stevenson (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  2 March 2021',\n",
       " 'Alison Duncan (Senior statutory auditor) for and on behalf of Ernst & Young LLP,  Statutory Auditor  London',\n",
       " 'LINDSAY GARDINER (SENIOR STATUTORY AUDITOR) for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors',\n",
       " 'Kate J Houldsworth FCA (Senior statutory auditor) For and on behalf of Deloitte LLP Statutory Auditor London, UK 26 April 2021',\n",
       " 'Jonathan Lambert (Senior Statutory Auditor) for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London',\n",
       " 'David Griffin FCA (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, UK',\n",
       " 'nan',\n",
       " 'John Ellis (Senior Statutory Auditor)   for and on behalf of PricewaterhouseCoopers LLP Chartered Accountants and Statutory Auditors   Leeds   10 March 2021',\n",
       " 'Richard Kelly  (Senior Statutory Auditor)  for and on behalf of KPMG LLP, Statutory Auditor  Chartered Accountants  15 Canada Square  London, E14 5GL 4 June 2020',\n",
       " 'nan']"
      ]
     },
     "execution_count": 129,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "b0634d5a",
   "metadata": {},
   "outputs": [],
   "source": [
    "results = []\n",
    "list1 = list(auditor_info.text.values)\n",
    "list1 = [str(i).strip() for i in list1]\n",
    "\n",
    "for doc in nlp.pipe(list1):\n",
    "   results.append([ent.text for ent in doc.ents if ent.label_=='ORG'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "c66392ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Ernst & Young LLP'],\n",
       " ['SENIOR STATUTORY', 'Ernst & Young LLP'],\n",
       " ['Deloitte LLP'],\n",
       " ['Deloitte'],\n",
       " ['KPMG LLP'],\n",
       " ['FCA', 'STATUTORY'],\n",
       " ['BDO LLP'],\n",
       " ['PricewaterhouseCoopers LLP (PwC',\n",
       "  'Company',\n",
       "  'Statutory',\n",
       "  'Deloitte LLP (',\n",
       "  'Deloitte',\n",
       "  'Deloitte'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " ['SENIOR STATUTORY', 'Deloitte LLP Statutory'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['FCA', 'Deloitte LLP Statutory'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['Deloitte LLP   '],\n",
       " ['Ernst & Young LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Global  Business Services', 'GBS'],\n",
       " ['Deloitte LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Antony Cates', 'KPMG LLP', 'Canada Square London E14'],\n",
       " [],\n",
       " ['SENIOR STATUTORY'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP', 'E14 5GL'],\n",
       " ['STATUTORY'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte LLP'],\n",
       " ['Deloitte LLP'],\n",
       " ['Coca-Cola HBC AG', 'Coca-Cola HBC AG'],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP', 'Square London E14'],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Deloitte LLP   '],\n",
       " [],\n",
       " ['PricewaterhouseCoopers LLP   Chartered Accountants and'],\n",
       " [],\n",
       " ['FCA', 'Deloitte LLP Statutory'],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Group', 'Group', 'the Audit Committee'],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " [],\n",
       " ['Group', 'GWR', 'TPE', 'Group', 'Group'],\n",
       " [],\n",
       " ['RSM UK Audit LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Bristol'],\n",
       " [],\n",
       " ['BDO LLP'],\n",
       " ['Deloitte LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['Deloitte', 'LLP'],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['KPMG LLP', 'Quayside House'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Deloitte LLP'],\n",
       " ['SENIOR STATUTORY'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['SENIOR STATUTORY', 'Ernst & Young LLP'],\n",
       " [],\n",
       " ['Deloitte LLP   '],\n",
       " ['BDO LLP'],\n",
       " ['the Primary Team', 'the Primary Team', 'Group', 'the Primary Team'],\n",
       " ['Deloitte', 'LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " ['Sainsbury',\n",
       "  'Supermarkets Ltd',\n",
       "  'Sainsbury’s Bank plc',\n",
       "  'Argos  Financial Services',\n",
       "  'Group',\n",
       "  'Group'],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['the Financial  Reporting Council',\n",
       "  'Board',\n",
       "  'FRC',\n",
       "  'Company',\n",
       "  'the Audit Committee',\n",
       "  'LLP'],\n",
       " ['Deloitte LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['PricewaterhouseCoopers LLP'],\n",
       " ['Deloitte (NI'],\n",
       " ['KPMG LLP'],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['BDO LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Stuart Crisp', 'KPMG LLP'],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['Deloitte LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['PricewaterhouseCoopers LLP   Chartered Accountants and Statutory Auditors'],\n",
       " ['KPMG LLP'],\n",
       " ['ACA', 'Deloitte'],\n",
       " ['The Group', 'Group'],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " ['Stuart Burdass', 'KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP', 'Square London E14'],\n",
       " ['Deloitte LLP Statutory'],\n",
       " [],\n",
       " ['PricewaterhouseCoopers LLP   Chartered Accountants and Statutory Auditors',\n",
       "  'Southampton'],\n",
       " ['KPMG LLP', 'Canada Square London E14'],\n",
       " ['KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['KPMG LLP', 'London E14'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Ernst & Young'],\n",
       " ['KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Deloitte LLP Statutory'],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " ['SENIOR STATUTORY'],\n",
       " ['KPMG LLP'],\n",
       " ['ACA', 'Deloitte', 'LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP', 'London E14'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['FCA', 'Deloitte', 'LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Group',\n",
       "  'SSE Airtricity Energy Supply',\n",
       "  'NI) Ltd',\n",
       "  'SSE',\n",
       "  'Airtricity Ltd',\n",
       "  'SGN',\n",
       "  'Group',\n",
       "  'Group'],\n",
       " ['KPMG LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['KPMG LLP'],\n",
       " ['The Audit Committee',\n",
       "  'the Audit Committee Chair',\n",
       "  'Finance',\n",
       "  'Internal Audit',\n",
       "  'Corporate Affairs',\n",
       "  'Brand & Marketing',\n",
       "  'the  Group’s',\n",
       "  'KPMG',\n",
       "  'Group',\n",
       "  'Group Company'],\n",
       " ['Deloitte LLP'],\n",
       " ['Deloitte LLP Statutory'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Deloitte LLP   '],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['Ernst & Young LLP'],\n",
       " ['JULIE CARLYLE', 'ON BEHALF OF ERNST & YOUNG LLP', 'STATUTORY'],\n",
       " ['FCA', 'Deloitte LLP Statutory'],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " [],\n",
       " [],\n",
       " ['Deloitte', 'Company', 'the Senior Statutory Auditor'],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " [],\n",
       " ['IFRS'],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " [],\n",
       " ['Ernst & Young LLP'],\n",
       " [],\n",
       " ['Deloitte LLP Statutory'],\n",
       " [],\n",
       " ['Deloitte', 'LLP'],\n",
       " [],\n",
       " [],\n",
       " ['KPMG LLP'],\n",
       " []]"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "5d719663",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info['auditor_name'] = results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "39180627",
   "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>filename</th>\n",
       "      <th>page_num</th>\n",
       "      <th>text</th>\n",
       "      <th>auditor_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3i_group_ar_2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Julian Young (Senior statutory auditor) for an...</td>\n",
       "      <td>[Ernst &amp; Young LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4imprint Group AR 2020.pdf</td>\n",
       "      <td>84.0</td>\n",
       "      <td>CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...</td>\n",
       "      <td>[SENIOR STATUTORY, Ernst &amp; Young LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Admiral Group Plc Annual Report 2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Mark McQueen (Senior statutory auditor) For an...</td>\n",
       "      <td>[Deloitte LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AG Barr AR 2021.pdf</td>\n",
       "      <td>110.0</td>\n",
       "      <td>David Sweeney, CA (Senior statutory auditor) F...</td>\n",
       "      <td>[Deloitte]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Aggreko PLC annual report 2020.pdf</td>\n",
       "      <td>106.0</td>\n",
       "      <td>John Luke (Senior Statutory Auditor)   for and...</td>\n",
       "      <td>[KPMG LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Airtel Africa PLC Annual report 2020.pdf</td>\n",
       "      <td>10.0</td>\n",
       "      <td>MARK GOODEY (FCA) (SENIOR STATUTORY AUDITOR)  ...</td>\n",
       "      <td>[FCA, STATUTORY]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AJ_Bell PLC Annual Report 2020.pdf</td>\n",
       "      <td>49.0</td>\n",
       "      <td>For and on behalf of BDO LLP, Statutory Audito...</td>\n",
       "      <td>[BDO LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Anglo American PLC AR 2020.pdf</td>\n",
       "      <td>121.0</td>\n",
       "      <td>At the 2020 AGM, shareholders approved the app...</td>\n",
       "      <td>[PricewaterhouseCoopers LLP (PwC, Company, Sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>antofagasta_2020_annual_report.pdf</td>\n",
       "      <td>165.0</td>\n",
       "      <td>Simon Morley (Senior Statutory Auditor)  for a...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ascential PLC Annual Report 2020.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Ian Griffiths (Senior Statutory Auditor)  for ...</td>\n",
       "      <td>[KPMG LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ashmore Group PLC Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ashtead_AR2020.pdf</td>\n",
       "      <td>114.0</td>\n",
       "      <td>WILLIAM SMITH   (SENIOR STATUTORY AUDITOR) for...</td>\n",
       "      <td>[SENIOR STATUTORY, Deloitte LLP Statutory]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Associated British Foods PLC AR 2020.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Andrew Walton (Senior Statutory Auditor)  for ...</td>\n",
       "      <td>[Ernst &amp; Young LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Assura PLC Annual Report 2020.pdf</td>\n",
       "      <td>114.0</td>\n",
       "      <td>Scott Bayne, FCA (senior statutory auditor) Fo...</td>\n",
       "      <td>[FCA, Deloitte LLP Statutory]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AstraZeneca_AR_2020.pdf</td>\n",
       "      <td>176.0</td>\n",
       "      <td>Richard Hughes (Senior Statutory Auditor) for ...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Auto Trader Group PLC Annual report 2020.pdf</td>\n",
       "      <td>100.0</td>\n",
       "      <td>Mick Davies (Senior Statutory Auditor)  for an...</td>\n",
       "      <td>[KPMG LLP]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Avast PLC Annual report 2020.pdf</td>\n",
       "      <td>140.0</td>\n",
       "      <td>In order to mitigate the risk of working remot...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Aveva Group PLC AR 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>aviva-plc-annual-report-and-accounts-2020.pdf</td>\n",
       "      <td>130.0</td>\n",
       "      <td>Alex Bertolotti (Senior Statutory Auditor)  fo...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B&amp;M Eurpean Value Retail Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           filename  page_num  \\\n",
       "0                              3i_group_ar_2020.pdf     174.0   \n",
       "1                        4imprint Group AR 2020.pdf      84.0   \n",
       "2          Admiral Group Plc Annual Report 2020.pdf     174.0   \n",
       "3                               AG Barr AR 2021.pdf     110.0   \n",
       "4                Aggreko PLC annual report 2020.pdf     106.0   \n",
       "5          Airtel Africa PLC Annual report 2020.pdf      10.0   \n",
       "6                AJ_Bell PLC Annual Report 2020.pdf      49.0   \n",
       "7                    Anglo American PLC AR 2020.pdf     121.0   \n",
       "8                antofagasta_2020_annual_report.pdf     165.0   \n",
       "9              Ascential PLC Annual Report 2020.pdf     120.0   \n",
       "10         Ashmore Group PLC Annual Report 2020.pdf       NaN   \n",
       "11                               Ashtead_AR2020.pdf     114.0   \n",
       "12         Associated British Foods PLC AR 2020.pdf     137.0   \n",
       "13                Assura PLC Annual Report 2020.pdf     114.0   \n",
       "14                          AstraZeneca_AR_2020.pdf     176.0   \n",
       "15     Auto Trader Group PLC Annual report 2020.pdf     100.0   \n",
       "16                 Avast PLC Annual report 2020.pdf     140.0   \n",
       "17                      Aveva Group PLC AR 2020.pdf       NaN   \n",
       "18    aviva-plc-annual-report-and-accounts-2020.pdf     130.0   \n",
       "19  B&M Eurpean Value Retail Annual Report 2020.pdf       NaN   \n",
       "\n",
       "                                                 text  \\\n",
       "0   Julian Young (Senior statutory auditor) for an...   \n",
       "1   CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...   \n",
       "2   Mark McQueen (Senior statutory auditor) For an...   \n",
       "3   David Sweeney, CA (Senior statutory auditor) F...   \n",
       "4   John Luke (Senior Statutory Auditor)   for and...   \n",
       "5   MARK GOODEY (FCA) (SENIOR STATUTORY AUDITOR)  ...   \n",
       "6   For and on behalf of BDO LLP, Statutory Audito...   \n",
       "7   At the 2020 AGM, shareholders approved the app...   \n",
       "8   Simon Morley (Senior Statutory Auditor)  for a...   \n",
       "9   Ian Griffiths (Senior Statutory Auditor)  for ...   \n",
       "10                                                NaN   \n",
       "11  WILLIAM SMITH   (SENIOR STATUTORY AUDITOR) for...   \n",
       "12  Andrew Walton (Senior Statutory Auditor)  for ...   \n",
       "13  Scott Bayne, FCA (senior statutory auditor) Fo...   \n",
       "14  Richard Hughes (Senior Statutory Auditor) for ...   \n",
       "15  Mick Davies (Senior Statutory Auditor)  for an...   \n",
       "16  In order to mitigate the risk of working remot...   \n",
       "17                                                NaN   \n",
       "18  Alex Bertolotti (Senior Statutory Auditor)  fo...   \n",
       "19                                                NaN   \n",
       "\n",
       "                                         auditor_name  \n",
       "0                                 [Ernst & Young LLP]  \n",
       "1               [SENIOR STATUTORY, Ernst & Young LLP]  \n",
       "2                                      [Deloitte LLP]  \n",
       "3                                          [Deloitte]  \n",
       "4                                          [KPMG LLP]  \n",
       "5                                    [FCA, STATUTORY]  \n",
       "6                                           [BDO LLP]  \n",
       "7   [PricewaterhouseCoopers LLP (PwC, Company, Sta...  \n",
       "8                                                  []  \n",
       "9                                          [KPMG LLP]  \n",
       "10                                                 []  \n",
       "11         [SENIOR STATUTORY, Deloitte LLP Statutory]  \n",
       "12                                [Ernst & Young LLP]  \n",
       "13                      [FCA, Deloitte LLP Statutory]  \n",
       "14                                                 []  \n",
       "15                                         [KPMG LLP]  \n",
       "16                                                 []  \n",
       "17                                                 []  \n",
       "18                                                 []  \n",
       "19                                                 []  "
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "e376a135",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Alex Bertolotti (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  3 March 2021'"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.text.loc[18]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "fc7127f7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Alex Bertolotti (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  3 March 2021'"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list1[18]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "2b30d47c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# auditor_info.to_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\auditor_name.csv', index= False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cb2772d3",
   "metadata": {},
   "source": [
    "# spacy training"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "eef01ece",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'auditor_info' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-2bce9bfc01ac>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mresults\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mlist1\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mlist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mauditor_info\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      3\u001b[0m \u001b[0mlist1\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstrip\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'\\s+'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m''\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mlist1\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mNameError\u001b[0m: name 'auditor_info' is not defined"
     ]
    }
   ],
   "source": [
    "results = []\n",
    "list1 = list(auditor_info.text.values)\n",
    "list1 = [str(i).strip().replace('\\s+', '') for i in list1]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "id": "52043d74",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Alex Bertolotti (Senior Statutory Auditor)  for and on behalf of PricewaterhouseCoopers LLP  Chartered Accountants and Statutory Auditors  London  3 March 2021'"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list1[18]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "93cdaa04",
   "metadata": {},
   "outputs": [],
   "source": [
    "train= pd.DataFrame()\n",
    "train['text']=list1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "69bfd1b5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# train.to_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\auditor_name_spacy_raw.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5d806e7b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# read labelled data\n",
    "\n",
    "df = pd.read_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\auditor_name_spacy_label_v1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c94e7c72",
   "metadata": {},
   "outputs": [],
   "source": [
    "def spacy_form(a):\n",
    "    c={}\n",
    "    b=[]\n",
    "    a = eval(str(a))\n",
    "    for i in a:\n",
    "        start= i['start']\n",
    "        end = i['end']\n",
    "        label=''.join(i['labels'])\n",
    "        # if label == 'PER':\n",
    "        #   label = 'PERSON'\n",
    "        # elif label == 'AREA':\n",
    "        #   label= 'WORK_OF_ART'\n",
    "       \n",
    "        # elif label == 'TITLE':\n",
    "        #   label = 'NORP'\n",
    "        b.append((start, end, label))\n",
    "    c['entities']=b\n",
    "    return(c)\n",
    "\n",
    "df= df.dropna()\n",
    "df['spacy_format'] = df.label.apply(lambda x:spacy_form(x) )\n",
    "df['train_v1'] =df[['text', 'spacy_format']].apply(lambda x: (x['text'], x['spacy_format']), axis = 1)\n",
    "spacy_train = [i for i in df.train_v1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "fe300c0b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('Judith Tacon (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom  9 June 2020',\n",
       " {'entities': [(61, 73, 'ORG')]})"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spacy_train[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "8c3f8840",
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'entities1' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-14-483798a26118>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mentities1\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Judith Tacon (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom  9 June 2020'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'entities1' is not defined"
     ]
    }
   ],
   "source": [
    "entities1('Judith Tacon (Senior statutory auditor) For and on behalf of Deloitte LLP  Statutory Auditor  London, United Kingdom  9 June 2020')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "2a60a3ec",
   "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>text</th>\n",
       "      <th>id</th>\n",
       "      <th>label</th>\n",
       "      <th>annotator</th>\n",
       "      <th>annotation_id</th>\n",
       "      <th>spacy_format</th>\n",
       "      <th>train_v1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LINDSAY GARDINER (SENIOR STATUTORY AUDITOR) fo...</td>\n",
       "      <td>8683</td>\n",
       "      <td>[{\"start\": 65, \"end\": 91, \"text\": \"Pricewaterh...</td>\n",
       "      <td>gauravgund2@gmail.com</td>\n",
       "      <td>3691</td>\n",
       "      <td>{'entities': [(65, 91, 'ORG')]}</td>\n",
       "      <td>(LINDSAY GARDINER (SENIOR STATUTORY AUDITOR) f...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JULIE CARLYLE (SENIOR STATUTORY AUDITOR) FOR A...</td>\n",
       "      <td>8663</td>\n",
       "      <td>[{\"start\": 62, \"end\": 79, \"text\": \"ERNST &amp; YOU...</td>\n",
       "      <td>gauravgund2@gmail.com</td>\n",
       "      <td>3690</td>\n",
       "      <td>{'entities': [(62, 79, 'ORG')]}</td>\n",
       "      <td>(JULIE CARLYLE (SENIOR STATUTORY AUDITOR) FOR ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>William Meredith (Senior Statutory Auditor)  f...</td>\n",
       "      <td>8651</td>\n",
       "      <td>[{\"start\": 66, \"end\": 74, \"text\": \"KPMG LLP\", ...</td>\n",
       "      <td>gauravgund2@gmail.com</td>\n",
       "      <td>3689</td>\n",
       "      <td>{'entities': [(66, 74, 'ORG')]}</td>\n",
       "      <td>(William Meredith (Senior Statutory Auditor)  ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                text    id  \\\n",
       "0  LINDSAY GARDINER (SENIOR STATUTORY AUDITOR) fo...  8683   \n",
       "1  JULIE CARLYLE (SENIOR STATUTORY AUDITOR) FOR A...  8663   \n",
       "2  William Meredith (Senior Statutory Auditor)  f...  8651   \n",
       "\n",
       "                                               label              annotator  \\\n",
       "0  [{\"start\": 65, \"end\": 91, \"text\": \"Pricewaterh...  gauravgund2@gmail.com   \n",
       "1  [{\"start\": 62, \"end\": 79, \"text\": \"ERNST & YOU...  gauravgund2@gmail.com   \n",
       "2  [{\"start\": 66, \"end\": 74, \"text\": \"KPMG LLP\", ...  gauravgund2@gmail.com   \n",
       "\n",
       "   annotation_id                     spacy_format  \\\n",
       "0           3691  {'entities': [(65, 91, 'ORG')]}   \n",
       "1           3690  {'entities': [(62, 79, 'ORG')]}   \n",
       "2           3689  {'entities': [(66, 74, 'ORG')]}   \n",
       "\n",
       "                                            train_v1  \n",
       "0  (LINDSAY GARDINER (SENIOR STATUTORY AUDITOR) f...  \n",
       "1  (JULIE CARLYLE (SENIOR STATUTORY AUDITOR) FOR ...  \n",
       "2  (William Meredith (Senior Statutory Auditor)  ...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "753cd058",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0 {'ner': 98.23739722065339}\n",
      "1 {'ner': 8.132303195478851}\n",
      "2 {'ner': 8.093478370590756}\n",
      "3 {'ner': 3.7240377765040793}\n",
      "4 {'ner': 8.320873893052797}\n",
      "5 {'ner': 4.166814530139348}\n",
      "6 {'ner': 5.973978598958802}\n",
      "7 {'ner': 0.16147990104606194}\n",
      "8 {'ner': 0.0067153058100279965}\n",
      "9 {'ner': 1.9997159267437299}\n",
      "10 {'ner': 0.010046324354798623}\n",
      "11 {'ner': 0.004662706965995786}\n",
      "12 {'ner': 1.2576562915842566e-06}\n",
      "13 {'ner': 3.8085384049190404e-05}\n",
      "14 {'ner': 5.497981863987761e-06}\n",
      "15 {'ner': 0.00024733477729473876}\n",
      "16 {'ner': 1.2051493463766283e-07}\n",
      "17 {'ner': 1.8458327057090769}\n",
      "18 {'ner': 0.00014989155820573126}\n",
      "19 {'ner': 5.0067133315202146e-05}\n",
      "20 {'ner': 1.9243066318129163e-07}\n",
      "21 {'ner': 2.9361861301739575e-06}\n",
      "22 {'ner': 7.406823140241109e-06}\n",
      "23 {'ner': 2.6898409160769964e-06}\n",
      "24 {'ner': 3.869522522762174}\n",
      "25 {'ner': 7.116585369341091}\n",
      "26 {'ner': 4.653490215659183}\n",
      "27 {'ner': 0.00032851826861078425}\n",
      "28 {'ner': 4.054016741785117}\n",
      "29 {'ner': 0.05197100917166201}\n",
      "30 {'ner': 3.591991921045484}\n",
      "31 {'ner': 0.15211549512056027}\n",
      "32 {'ner': 1.3759299618130024e-05}\n",
      "33 {'ner': 0.004886950910205557}\n",
      "34 {'ner': 1.2071295295205897e-08}\n"
     ]
    }
   ],
   "source": [
    "\n",
    "import spacy\n",
    "import random\n",
    "nlp = spacy.load('en_core_web_sm')\n",
    "n_iter = 35\n",
    "\n",
    "other_pipes = [pipe for pipe in nlp.pipe_names if pipe != 'ner']\n",
    "with nlp.disable_pipes(*other_pipes):\n",
    "    optimizer = nlp.begin_training()\n",
    "    for i in range(n_iter):\n",
    "        random.shuffle(spacy_train)\n",
    "        losses = {}\n",
    "        \n",
    "        for texts,annotations in spacy_train:\n",
    "            \n",
    "            nlp.update([texts], [annotations],  sgd = optimizer, losses= losses, drop=0.2)\n",
    "        print(i, losses)\n",
    "            \n",
    "        \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "635a6d96",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle as pkl\n",
    "nlp = pkl.load(open(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\nlp_auditor_name.pkl', 'rb'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "034731f7",
   "metadata": {},
   "outputs": [],
   "source": [
    "results = []\n",
    "list1 = list(auditor_info.text.values)\n",
    "list1 = [str(i).strip().replace('\\s+', '') for i in list1]\n",
    "\n",
    "for doc in nlp.pipe(list1):\n",
    "   results.append(' '.join([ent.text for ent in doc.ents if ent.label_=='ORG']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "08fb5620",
   "metadata": {},
   "outputs": [],
   "source": [
    "list1 = list(auditor_info.text.values)\n",
    "list1 = [str(i).strip().replace('\\s+', '') for i in list1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "63f88d28",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'BDO LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " 'ERNST & YOUNG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " '',\n",
       " '',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers AG Switzerland (‘PwC AG PwC AG',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young  LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'MHA MacIntyre Hudson',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'BDO LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " '',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Grant Thornton UK LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'BDO LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " '',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'MHA MacIntyre Hudson',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " '',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PRICEWATERHOUSECOOPERS LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'KPMG LLP',\n",
       " 'Deloitte LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " '',\n",
       " 'Ernst & Young LLP',\n",
       " '',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " 'KPMG LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Ernst & Young LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " 'PricewaterhouseCoopers LLP',\n",
       " 'Deloitte LLP',\n",
       " '',\n",
       " 'KPMG LLP',\n",
       " '',\n",
       " '']"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4baef7c2",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info['auditor_name'] = results\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fbc6d373",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "PricewaterhouseCoopers LLP                               59\n",
       "                                                         57\n",
       "KPMG LLP                                                 53\n",
       "Deloitte LLP                                             46\n",
       "Ernst & Young LLP                                        43\n",
       "BDO LLP                                                   3\n",
       "MHA MacIntyre Hudson                                      2\n",
       "ERNST & YOUNG LLP                                         1\n",
       "Ernst & Young  LLP                                        1\n",
       "PRICEWATERHOUSECOOPERS LLP                                1\n",
       "PricewaterhouseCoopers AG Switzerland (‘PwC AG PwC AG     1\n",
       "Grant Thornton UK LLP                                     1\n",
       "KPMG LLP KPMG LLP                                         1\n",
       "Name: auditor_name, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.auditor_name.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "30af9a7d",
   "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>filename</th>\n",
       "      <th>page_num</th>\n",
       "      <th>text</th>\n",
       "      <th>auditor_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3i infrastructure ar 2021.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4imprint Group AR 2020.pdf</td>\n",
       "      <td>84.0</td>\n",
       "      <td>CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...</td>\n",
       "      <td>Ernst &amp; Young LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>888 Holdings Annual Report.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91-ninety-one-integrated-annual-report-2021.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Jatin Patel (Senior Statutory Auditor)  for an...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Admiral Group Plc Annual Report 2020.pdf</td>\n",
       "      <td>174.0</td>\n",
       "      <td>Mark McQueen (Senior statutory auditor) For an...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Aggreko PLC annual report 2020.pdf</td>\n",
       "      <td>106.0</td>\n",
       "      <td>John Luke (Senior Statutory Auditor)   for and...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Airtel Africa Annual Report 2021.pdf</td>\n",
       "      <td>150.0</td>\n",
       "      <td>Mark Goodey (FCA) (Senior statutory auditor)  ...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AJ_Bell PLC Annual Report 2020.pdf</td>\n",
       "      <td>49.0</td>\n",
       "      <td>For and on behalf of BDO LLP, Statutory Audito...</td>\n",
       "      <td>BDO LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Anglo American PLC AR 2020.pdf</td>\n",
       "      <td>158.0</td>\n",
       "      <td>Mark King (Senior Statutory Auditor) for and o...</td>\n",
       "      <td>PricewaterhouseCoopers LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>antofagasta_2020_annual_report.pdf</td>\n",
       "      <td>165.0</td>\n",
       "      <td>Simon Morley (Senior Statutory Auditor)  for a...</td>\n",
       "      <td>PricewaterhouseCoopers LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ascential PLC Annual Report 2020.pdf</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Ian Griffiths (Senior Statutory Auditor)  for ...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ashmore Group PLC Annual Report 2020.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Associated British Foods PLC AR 2020.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Andrew Walton (Senior Statutory Auditor)  for ...</td>\n",
       "      <td>Ernst &amp; Young LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Assura AnnualReport2021final.pdf</td>\n",
       "      <td>118.0</td>\n",
       "      <td>Scott Bayne, FCA (Senior statutory auditor) Fo...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf</td>\n",
       "      <td>96.0</td>\n",
       "      <td>SIMON O’NEILL (SENIOR STATUTORY AUDITOR) FOR A...</td>\n",
       "      <td>ERNST &amp; YOUNG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AstraZeneca_AR_2020.pdf</td>\n",
       "      <td>176.0</td>\n",
       "      <td>Richard Hughes (Senior Statutory Auditor) for ...</td>\n",
       "      <td>PricewaterhouseCoopers LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Auto Trader  plc ar2021-web.pdf</td>\n",
       "      <td>124.0</td>\n",
       "      <td>David Derbyshire (Senior Statutory Auditor)  f...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Avast PLC Annual report 2020.pdf</td>\n",
       "      <td>146.0</td>\n",
       "      <td>Marcus Butler (Senior statutory auditor)  for ...</td>\n",
       "      <td>Ernst &amp; Young LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Aveva AR 2021.pdf</td>\n",
       "      <td>137.0</td>\n",
       "      <td>Christopher Voogd (Senior statutory auditor) f...</td>\n",
       "      <td>Ernst &amp; Young LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>aviva-plc-annual-report-and-accounts-2020.pdf</td>\n",
       "      <td>130.0</td>\n",
       "      <td>Alex Bertolotti (Senior Statutory Auditor)  fo...</td>\n",
       "      <td>PricewaterhouseCoopers LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>avon-rubber-annual-report-2020.pdf</td>\n",
       "      <td>110.0</td>\n",
       "      <td>Andrew Campbell-Orde (Senior Statutory Auditor...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B&amp;MFull_Annual_Report_and_Accounts_2021.pdf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BAE Systems PLC AR 2020.pdf</td>\n",
       "      <td>185.0</td>\n",
       "      <td>John Adam  Senior Statutory Auditor For and on...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Balfour Beatty PLC Annual Report 2020.pdf</td>\n",
       "      <td>164.0</td>\n",
       "      <td>for and on behalf of KPMG LLP, Statutory Audit...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Barclays PLC AR 2020.pdf</td>\n",
       "      <td>279.0</td>\n",
       "      <td>Michelle Hinchliffe  (Senior Statutory Auditor...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Barratt Developments P L C AR 2020.pdf</td>\n",
       "      <td>166.0</td>\n",
       "      <td>Claire Faulkner (Senior statutory auditor)   F...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Beazley PLC Annual Report-2020.pdf</td>\n",
       "      <td>128.0</td>\n",
       "      <td>Stuart Wilson (Senior Statutory Auditor) for a...</td>\n",
       "      <td>Ernst &amp; Young LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>bellway_ar20_web.pdf</td>\n",
       "      <td>104.0</td>\n",
       "      <td>Johnathan Pass (Senior Statutory Auditor)   fo...</td>\n",
       "      <td>KPMG LLP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BHP Group PLC AR 2020.pdf</td>\n",
       "      <td>254.0</td>\n",
       "      <td>Gary Donald  Senior Statutory Auditor  for and...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Biffa Annual Report and Accounts FY21 Final.pdf</td>\n",
       "      <td>135.0</td>\n",
       "      <td>Peter Gallimore, FCA  Senior statutory auditor...</td>\n",
       "      <td>Deloitte LLP</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           filename  page_num  \\\n",
       "0                     3i infrastructure ar 2021.pdf       NaN   \n",
       "1                        4imprint Group AR 2020.pdf      84.0   \n",
       "2                    888 Holdings Annual Report.pdf       NaN   \n",
       "3   91-ninety-one-integrated-annual-report-2021.pdf     120.0   \n",
       "4          Admiral Group Plc Annual Report 2020.pdf     174.0   \n",
       "5                Aggreko PLC annual report 2020.pdf     106.0   \n",
       "6              Airtel Africa Annual Report 2021.pdf     150.0   \n",
       "7                AJ_Bell PLC Annual Report 2020.pdf      49.0   \n",
       "8                    Anglo American PLC AR 2020.pdf     158.0   \n",
       "9                antofagasta_2020_annual_report.pdf     165.0   \n",
       "10             Ascential PLC Annual Report 2020.pdf     120.0   \n",
       "11         Ashmore Group PLC Annual Report 2020.pdf       NaN   \n",
       "12         Associated British Foods PLC AR 2020.pdf     137.0   \n",
       "13                 Assura AnnualReport2021final.pdf     118.0   \n",
       "14   Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf      96.0   \n",
       "15                          AstraZeneca_AR_2020.pdf     176.0   \n",
       "16                  Auto Trader  plc ar2021-web.pdf     124.0   \n",
       "17                 Avast PLC Annual report 2020.pdf     146.0   \n",
       "18                                Aveva AR 2021.pdf     137.0   \n",
       "19    aviva-plc-annual-report-and-accounts-2020.pdf     130.0   \n",
       "20               avon-rubber-annual-report-2020.pdf     110.0   \n",
       "21      B&MFull_Annual_Report_and_Accounts_2021.pdf       NaN   \n",
       "22                      BAE Systems PLC AR 2020.pdf     185.0   \n",
       "23        Balfour Beatty PLC Annual Report 2020.pdf     164.0   \n",
       "24                         Barclays PLC AR 2020.pdf     279.0   \n",
       "25           Barratt Developments P L C AR 2020.pdf     166.0   \n",
       "26               Beazley PLC Annual Report-2020.pdf     128.0   \n",
       "27                             bellway_ar20_web.pdf     104.0   \n",
       "28                        BHP Group PLC AR 2020.pdf     254.0   \n",
       "29  Biffa Annual Report and Accounts FY21 Final.pdf     135.0   \n",
       "\n",
       "                                                 text  \\\n",
       "0                                                 NaN   \n",
       "1   CHRISTOPHER VOOGD  (SENIOR STATUTORY AUDITOR) ...   \n",
       "2                                                 NaN   \n",
       "3   Jatin Patel (Senior Statutory Auditor)  for an...   \n",
       "4   Mark McQueen (Senior statutory auditor) For an...   \n",
       "5   John Luke (Senior Statutory Auditor)   for and...   \n",
       "6   Mark Goodey (FCA) (Senior statutory auditor)  ...   \n",
       "7   For and on behalf of BDO LLP, Statutory Audito...   \n",
       "8   Mark King (Senior Statutory Auditor) for and o...   \n",
       "9   Simon Morley (Senior Statutory Auditor)  for a...   \n",
       "10  Ian Griffiths (Senior Statutory Auditor)  for ...   \n",
       "11                                                NaN   \n",
       "12  Andrew Walton (Senior Statutory Auditor)  for ...   \n",
       "13  Scott Bayne, FCA (Senior statutory auditor) Fo...   \n",
       "14  SIMON O’NEILL (SENIOR STATUTORY AUDITOR) FOR A...   \n",
       "15  Richard Hughes (Senior Statutory Auditor) for ...   \n",
       "16  David Derbyshire (Senior Statutory Auditor)  f...   \n",
       "17  Marcus Butler (Senior statutory auditor)  for ...   \n",
       "18  Christopher Voogd (Senior statutory auditor) f...   \n",
       "19  Alex Bertolotti (Senior Statutory Auditor)  fo...   \n",
       "20  Andrew Campbell-Orde (Senior Statutory Auditor...   \n",
       "21                                                NaN   \n",
       "22  John Adam  Senior Statutory Auditor For and on...   \n",
       "23  for and on behalf of KPMG LLP, Statutory Audit...   \n",
       "24  Michelle Hinchliffe  (Senior Statutory Auditor...   \n",
       "25  Claire Faulkner (Senior statutory auditor)   F...   \n",
       "26  Stuart Wilson (Senior Statutory Auditor) for a...   \n",
       "27  Johnathan Pass (Senior Statutory Auditor)   fo...   \n",
       "28  Gary Donald  Senior Statutory Auditor  for and...   \n",
       "29  Peter Gallimore, FCA  Senior statutory auditor...   \n",
       "\n",
       "                  auditor_name  \n",
       "0                               \n",
       "1            Ernst & Young LLP  \n",
       "2                               \n",
       "3                     KPMG LLP  \n",
       "4                 Deloitte LLP  \n",
       "5                     KPMG LLP  \n",
       "6                 Deloitte LLP  \n",
       "7                      BDO LLP  \n",
       "8   PricewaterhouseCoopers LLP  \n",
       "9   PricewaterhouseCoopers LLP  \n",
       "10                    KPMG LLP  \n",
       "11                              \n",
       "12           Ernst & Young LLP  \n",
       "13                Deloitte LLP  \n",
       "14           ERNST & YOUNG LLP  \n",
       "15  PricewaterhouseCoopers LLP  \n",
       "16                    KPMG LLP  \n",
       "17           Ernst & Young LLP  \n",
       "18           Ernst & Young LLP  \n",
       "19  PricewaterhouseCoopers LLP  \n",
       "20                    KPMG LLP  \n",
       "21                              \n",
       "22                Deloitte LLP  \n",
       "23                    KPMG LLP  \n",
       "24                    KPMG LLP  \n",
       "25                Deloitte LLP  \n",
       "26           Ernst & Young LLP  \n",
       "27                    KPMG LLP  \n",
       "28                              \n",
       "29                Deloitte LLP  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "dcff5d1b",
   "metadata": {},
   "outputs": [],
   "source": [
    "auditor_info.to_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\auditor_name_v1_2021.csv', index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "09029f22",
   "metadata": {},
   "outputs": [],
   "source": [
    "# import pickle as pkl\n",
    "\n",
    "# pkl.dump(nlp, open(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\auditor_name\\nlp_auditor_name.pkl', 'wb'))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "7cfb6409",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2.2.4'"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "spacy.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "0be49e2f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Gary Donald  Senior Statutory Auditor  for and on behalf of'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "auditor_info.text.iloc[28]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "44b1800a",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}