year_end.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d2ec6104",
   "metadata": {},
   "outputs": [],
   "source": [
    "path = r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\cgt_data\\final_data'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5fef1ad4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import fitz\n",
    "import pandas as pd\n",
    "import datefinder"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "cf21dbf5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " 25 January 2020.\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020  gi\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 the\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020.\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      "   25 January 2020.”\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 and\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 wit\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020;\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020, wh\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 of \n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 is \n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 and\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 and\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 was\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 the\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020, R.\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      "  25 January 2020. S\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      "  25 January 2020\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 att\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020 of \n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020, if\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n",
      " 25 January 2020, th\n",
      "[datetime.datetime(2020, 1, 25, 0, 0)]\n"
     ]
    }
   ],
   "source": [
    "\n",
    "file= 'AG Barr AR 2021.pdf'\n",
    "with fitz.open(os.path.join(path, file)) as f:\n",
    "    for j in range(f.pageCount):\n",
    "        r_text=''\n",
    "        page = f.loadPage(j)\n",
    "        blocks = page.getText(\"blocks\")\n",
    "        blocks.sort(key=lambda block: block[1])  # sort vertically ascending\n",
    "        for b in blocks:\n",
    "            text = ' '.join(b[4].strip().splitlines())\n",
    "            if ('year ended' in text):\n",
    "        \n",
    "                val = text.split('year ended')[1][0:20]\n",
    "                if '2020' in val:\n",
    "                   print(val)\n",
    "                   matches = datefinder.find_dates(val)\n",
    "                   res=[]\n",
    "                   for match in matches:\n",
    "                      res.append(match)\n",
    "                   if res:\n",
    "                    print(res)\n",
    "                    break\n",
    "           \n",
    "                   else:\n",
    "                    continue\n",
    "                    \n",
    "        \n",
    "#             if 'year ended' in text:\n",
    "#                 r_text += ' '.join(text)\n",
    "#                 matches = datefinder.find_dates(string1)\n",
    "#                 print(string1)\n",
    "#                 break\n",
    "#             else:\n",
    "#                 continue "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b5d56fe6",
   "metadata": {},
   "outputs": [],
   "source": [
    "def year_end_finder(file, path):\n",
    "       with fitz.open(os.path.join(path, file)) as f:\n",
    "            for j in range(f.pageCount):\n",
    "            \n",
    "                page = f.loadPage(j)\n",
    "                blocks = page.getText(\"blocks\")\n",
    "                blocks.sort(key=lambda block: block[1])  # sort vertically ascending\n",
    "                for b in blocks:\n",
    "                    text = ' '.join(b[4].strip().splitlines())\n",
    "                    if 'year ended' in text:\n",
    "                        val = text.split('year ended')[1][0:20]\n",
    "                        if ('2020' in val) or ('2021' in val):\n",
    "                          try:\n",
    "                            matches = datefinder.find_dates(val)\n",
    "                            res=[]\n",
    "                            for match in matches:\n",
    "                                res.append(match)\n",
    "                            if res:\n",
    "                                return(str(res[0]).split(' ')[0])\n",
    "                          except:\n",
    "                            continue"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "f7be3f54",
   "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",
      "Barclays PLC AR 2020.pdf\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "mupdf: invalid page object\n",
      "mupdf: invalid page object\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "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"
     ]
    },
    {
     "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": [
    "date_val=[]\n",
    "file_name=[]\n",
    "for i in os.listdir(path):\n",
    "    print(i)\n",
    "    path = path\n",
    "    file= i\n",
    "    date_val.append(year_end_finder(file, path))\n",
    "    file_name.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "id": "c67db2bb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2020-01-25'"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year_end_finder('AG Barr AR 2021.pdf', path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "a9c8e9be",
   "metadata": {},
   "outputs": [],
   "source": [
    "df= pd.DataFrame()\n",
    "df['file_name']= file_name\n",
    "df['year_end']= date_val"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d9c72edf",
   "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>file_name</th>\n",
       "      <th>year_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3i infrastructure ar 2021.pdf</td>\n",
       "      <td>2021-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4imprint Group AR 2020.pdf</td>\n",
       "      <td>2021-01-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>888 Holdings Annual Report.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>91-ninety-one-integrated-annual-report-2021.pdf</td>\n",
       "      <td>2021-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Admiral Group Plc Annual Report 2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Aggreko PLC annual report 2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Airtel Africa Annual Report 2021.pdf</td>\n",
       "      <td>2021-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AJ_Bell PLC Annual Report 2020.pdf</td>\n",
       "      <td>2020-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Anglo American PLC AR 2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>antofagasta_2020_annual_report.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ascential PLC Annual Report 2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ashmore Group PLC Annual Report 2020.pdf</td>\n",
       "      <td>2021-06-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Associated British Foods PLC AR 2020.pdf</td>\n",
       "      <td>2020-07-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Assura AnnualReport2021final.pdf</td>\n",
       "      <td>2021-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AstraZeneca_AR_2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Auto Trader  plc ar2021-web.pdf</td>\n",
       "      <td>2020-03-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Avast PLC Annual report 2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Aveva AR 2021.pdf</td>\n",
       "      <td>2021-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>aviva-plc-annual-report-and-accounts-2020.pdf</td>\n",
       "      <td>2020-12-31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          file_name    year_end\n",
       "0                     3i infrastructure ar 2021.pdf  2021-03-31\n",
       "1                        4imprint Group AR 2020.pdf  2021-01-02\n",
       "2                    888 Holdings Annual Report.pdf  2020-12-31\n",
       "3   91-ninety-one-integrated-annual-report-2021.pdf  2021-03-31\n",
       "4          Admiral Group Plc Annual Report 2020.pdf  2020-12-31\n",
       "5                Aggreko PLC annual report 2020.pdf  2020-12-31\n",
       "6              Airtel Africa Annual Report 2021.pdf  2021-03-31\n",
       "7                AJ_Bell PLC Annual Report 2020.pdf  2020-09-30\n",
       "8                    Anglo American PLC AR 2020.pdf  2020-12-31\n",
       "9                antofagasta_2020_annual_report.pdf  2020-12-31\n",
       "10             Ascential PLC Annual Report 2020.pdf  2020-12-31\n",
       "11         Ashmore Group PLC Annual Report 2020.pdf  2021-06-30\n",
       "12         Associated British Foods PLC AR 2020.pdf  2020-07-31\n",
       "13                 Assura AnnualReport2021final.pdf  2021-03-31\n",
       "14   Aston-Martin-Lagonda-2020-Annual-Report-v2.pdf  2020-12-31\n",
       "15                          AstraZeneca_AR_2020.pdf  2020-12-31\n",
       "16                  Auto Trader  plc ar2021-web.pdf  2020-03-06\n",
       "17                 Avast PLC Annual report 2020.pdf  2020-12-31\n",
       "18                                Aveva AR 2021.pdf  2021-03-31\n",
       "19    aviva-plc-annual-report-and-accounts-2020.pdf  2020-12-31"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "c8840cb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(r'D:\\C Drive Backup 2021\\Desktop\\company_contracts\\answers\\year_end\\results_2021.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "67939e54",
   "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
}