ML Challenge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1479,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "X8XUG1JD\n",
      "X8XX0C57\n",
      "X8XX02AX\n",
      "X8XX0ANN\n",
      "X8XX0BU1\n",
      "X8XX0CEA\n",
      "X8XX00J6\n",
      "X8XX00LL\n",
      "X8XX00MX\n",
      "X8XX000W\n",
      "X8XX00YW\n",
      "X8XX01EH\n",
      "X8XX01EP\n",
      "X8XX01IX\n",
      "X8XX01SZ\n",
      "X8XX01TN\n",
      "X8XX01TV\n",
      "X8XX02N7\n",
      "X8XX02SY\n",
      "X8XX03IJ\n",
      "X8XX03S9\n",
      "X8XX07H7\n",
      "X8XX036G\n",
      "X8XX0137\n",
      "X8XX0196\n",
      "X8XZI9MH\n",
      "X8XZI9Y0\n",
      "X8XZI954\n",
      "X8XZIB3U\n",
      "X8XZIBDK\n",
      "X8XZIBXE\n",
      "X8XZIBZD\n",
      "X8XZICIB\n",
      "X8XZICNE\n",
      "X8XZICQX\n",
      "X8XZIDG2\n",
      "X8XZIDMH\n",
      "X8XZIE17\n",
      "X8XZIEI1\n",
      "X8XZIF16\n",
      "X8XZIFE8\n",
      "X8XZIFNV\n",
      "X8XZIFZL\n",
      "X8XZIG2X\n",
      "X8XZIGW8\n",
      "X8XZIIRN\n",
      "X8XZIIW2\n",
      "X8XZIIYQ\n",
      "X8XZIJC8\n",
      "X8XZIKDF\n",
      "X8XZIKJ6\n",
      "X8XZIKOX\n",
      "X8XZIMDT\n",
      "X8XZIMKG\n",
      "X8XZIML4\n",
      "X8XZIMQ3\n",
      "X8XZIN35\n",
      "X8XZINN6\n",
      "X8XZIO5G\n",
      "X8XZIOFU\n",
      "X8XZIOKY\n",
      "X8XZIOV4\n",
      "X8XZIOXK\n",
      "X8XZIP1V\n",
      "X8XZIPBM\n",
      "X8XZIPGP\n",
      "X8XZIPWZ\n",
      "X8XZIQ16\n",
      "X8XZIQEG\n",
      "X8XZIR1E\n",
      "X8XZIR3U\n",
      "X8XZIR7V\n",
      "X8XZIRI8\n",
      "X8XZIS4B\n",
      "X8XZIS7K\n",
      "X8XZIS17\n",
      "X8XZISVF\n",
      "X8XZIT2O\n",
      "X8XZITQ8\n",
      "X8XZIUTL\n",
      "X8XZIV4B\n",
      "X8XZIVMX\n",
      "X8XZIW68\n",
      "X8XZIWEH\n",
      "X8XZIWI2\n",
      "X8Y2EPBT\n",
      "X8Y2EPNN\n",
      "X8Y2EPVK\n",
      "X8Y2ER1U\n",
      "X8Y2ESHT\n",
      "X8Y2ESJM\n",
      "X8Y2ESK2\n",
      "X8Y2ETEY\n",
      "X8Y2ETP7\n",
      "X8Y2EUWP\n",
      "X8Y2EY7M\n",
      "X8Y2EYGW\n",
      "X8Y2EYNK\n",
      "X8Y2EZ9S\n",
      "X8Y2EZF0\n",
      "X8Y2EZHT\n",
      "X8Y2F0HE\n",
      "X8Y2F0L6\n",
      "X8Y2F3JL\n",
      "X8Y2F3V7\n",
      "X8Y2F4BD\n",
      "X8Y2F4HM\n",
      "X8Y2F4YW\n",
      "X8Y2F14H\n",
      "X8Y2F34B\n",
      "X8Y2F337\n",
      "X8Y4QL1E\n",
      "X8Y4QNO9\n",
      "X8Y4QNPL\n",
      "X8Y4QNRD\n",
      "X8Y4QO1V\n",
      "X8Y4QO6V\n",
      "X8Y4QORK\n",
      "X8Y4QP5M\n",
      "X8Y4QPFS\n",
      "X8Y4QRBV\n",
      "X8Y4QSJK\n",
      "X8Y4QSMO\n",
      "X8Y4QSOG\n",
      "X8Y4QT61\n",
      "X8Y4QUNU\n",
      "X8Y4QUTD\n",
      "X8Y4QVGI\n",
      "X8Y4QVOX\n",
      "X8Y4QVUG\n",
      "X8Y4QW2Z\n",
      "X8Y4QWEH\n",
      "X8Y4QX4H\n",
      "X8Y4QXRM\n",
      "X8Y4QXYP\n",
      "X8Y4QZ0O\n",
      "X8Y4QZEX\n",
      "X8Y4QZFL\n",
      "X8Y4R0K3\n",
      "X8Y4R1VE\n",
      "X8Y4R1X6\n",
      "X8Y4R2E0\n",
      "X8Y4R2LT\n",
      "X8Y4R2OQ\n",
      "X8Y4R2T6\n",
      "X8Y4R2TV\n",
      "X8Y4R4EZ\n",
      "X8Y4R4QG\n",
      "X8Y4R5PL\n",
      "X8Y4R7EY\n",
      "X8Y4R7MZ\n",
      "X8Y4R8QG\n",
      "X8Y4R8UH\n",
      "X8Y4R014\n",
      "X8Y4R66O\n",
      "X8Y4R88A\n",
      "X8Y4R942\n",
      "X8Y4RB69\n",
      "X8Y4RCC3\n",
      "X8Y4RCN0\n",
      "X8Y4RE7S\n",
      "X8Y4REEP\n",
      "X8Y4REMA\n",
      "X8Y4RFD6\n",
      "X8Y4RG7U\n",
      "X8Y4RGAB\n",
      "X8Y4RH9C\n",
      "X8Y4RHX7\n",
      "X8Y4RI3S\n",
      "X8Y4RJKJ\n",
      "X8Y4RKWI\n",
      "X8Y4RL0B\n",
      "X8Y4RLJL\n",
      "X8Y4RLLM\n",
      "X8Y4RM4W\n",
      "X8Y4RM48\n",
      "X8Y4RMKR\n",
      "X8Y4RP2J\n",
      "X8Y4RPRV\n",
      "X8Y4RPXC\n",
      "X8Y4RQMB\n",
      "X8Y4RR01\n",
      "X8Y4RREB\n",
      "X8Y4RSXR\n",
      "X8Y4RTW8\n",
      "X8Y4RU81\n",
      "X8Y4RUDE\n",
      "X8Y4RUPK\n",
      "X8Y4RV3M\n",
      "X8Y4RVQH\n",
      "X8Y4RWLD\n",
      "X8Y4RX03\n",
      "X8Y4RX54\n",
      "X8Y4RXDD\n",
      "X8Y4RYWX\n",
      "X8Y4RZAZ\n",
      "X8Y4RZKO\n",
      "X8Y4RZMH\n",
      "X8Y4S1CP\n",
      "X8Y4S1RV\n",
      "X8Y4S2W9\n",
      "X8Y4S3MP\n",
      "X8Y4S3PL\n",
      "X8Y4S3QX\n",
      "X8Y4S3RE\n",
      "X8Y4S3T6\n",
      "X8Y4S3TU\n",
      "X8Y4S3VE\n",
      "X8Y4S4OI\n",
      "X8Y4S6AA\n",
      "X8Y4S7YB\n",
      "X8Y4S08G\n",
      "X8Y4S8TF\n",
      "X8Y4S9F6\n",
      "X8Y4S037\n",
      "X8Y4S41N\n",
      "X8Y4S57L\n",
      "X8Y4S66I\n",
      "X8Y4S969\n",
      "X8Y4SA4Q\n",
      "X8Y4SBPU\n",
      "X8Y4SDBE\n",
      "X8Y4SE57\n",
      "X8Y4SESG\n",
      "X8Y4SEYR\n",
      "X8Y4SF81\n",
      "X8Y4SFA1\n",
      "X8Y4SFD5\n",
      "X8Y4SFR7\n",
      "X8Y4SHTK\n",
      "X8Y4SINS\n",
      "X8Y4SIQW\n",
      "X8Y4SJNN\n",
      "X8Y4SKV5\n",
      "X8Y4SLB7\n",
      "X8Y4SLGQ\n",
      "X8Y4WJSR\n",
      "X8Y4WKMB\n",
      "X8Y26BQO\n",
      "X8Y26QBM\n",
      "X8Y28A2W\n",
      "X8Y28AFV\n",
      "X8Y28AR5\n",
      "X8Y28AVS\n",
      "X8Y28BDM\n",
      "X8Y28C76\n",
      "X8Y28CDT\n",
      "X8Y28DCG\n",
      "X8Y28DNU\n",
      "X8Y28E4O\n",
      "X8Y28E9V\n",
      "X8Y28E20\n",
      "X8Y28E28\n",
      "X8Y28EQP\n",
      "X8Y28GDT\n",
      "X8Y28GK0\n",
      "X8Y28GVE\n",
      "X8Y28HC0\n",
      "X8Y28HHV\n",
      "X8Y28HNM\n",
      "X8Y28HSH\n",
      "X8Y28IC3\n",
      "X8Y28ICZ\n",
      "X8Y28IWG\n",
      "X8Y28IYR\n",
      "X8Y28J3N\n",
      "X8Y28JG1\n",
      "X8Y28JLK\n",
      "X8Y28KH4\n",
      "X8Y28KR6\n",
      "X8Y28KZ5\n",
      "X8Y28LEJ\n",
      "X8Y28LXS\n",
      "X8Y28M57\n",
      "X8Y28MBM\n",
      "X8Y28MDM\n",
      "X8Y28MNT\n",
      "X8Y28MOH\n",
      "X8Y28NCP\n",
      "X8Y28NOG\n",
      "X8Y28OE8\n",
      "X8Y28OLN\n",
      "X8Y287W0\n",
      "X8Y289DK\n",
      "X8Y2878B\n",
      "X8Y28615\n",
      "X8Y4TUMQ\n",
      "X8Y4TUOQ\n",
      "X8Y4TUUB\n",
      "X8Y4TV08\n",
      "X8Y4TV40\n",
      "X8Y4TVGA\n",
      "X8Y4TVKZ\n",
      "X8Y4TW66\n",
      "X8Y4TXQQ\n",
      "X8Y4TYE1\n",
      "X8Y4TYSR\n",
      "X8Y4TZRK\n",
      "X8Y4TZVK\n",
      "X8Y4U0G3\n",
      "X8Y4U0RL\n",
      "X8Y4U0TL\n",
      "X8Y4U0VT\n",
      "X8Y4U2BD\n",
      "X8Y4U37L\n",
      "X8Y4U3IJ\n",
      "X8Y4U3UP\n",
      "X8Y4U4O1\n",
      "X8Y4U4ZM\n",
      "X8Y4U51F\n",
      "X8Y4U5TV\n",
      "X8Y4U6QJ\n",
      "X8Y4U77U\n",
      "X8Y4U81M\n",
      "X8Y4U856\n",
      "X8Y4U8BF\n",
      "X8Y4U8V6\n",
      "X8Y4U8YA\n",
      "X8Y4U963\n",
      "X8Y4U974\n",
      "X8Y4U9G1\n",
      "X8Y4UBJF\n",
      "X8Y4UBL0\n",
      "X8Y4UBMG\n",
      "X8Y4UC77\n",
      "X8Y4UCJL\n",
      "X8Y4UCQQ\n",
      "X8Y4UDKA\n",
      "X8Y4UDNM\n",
      "X8Y4UDTN\n",
      "X8Y4UECQ\n",
      "X8Y4UESO\n",
      "X8Y4UEZT\n",
      "X8Y4UF29\n",
      "X8Y4UF5E\n",
      "X8Y4UFO8\n",
      "X8Y4UFZM\n",
      "X8Y4UGJT\n",
      "X8Y4UGVM\n",
      "X8Y4UI1O\n",
      "X8Y4UI8P\n",
      "X8Y4UJ1T\n",
      "X8Y4UKE8\n",
      "X8Y4UKFK\n",
      "X8Y4UKFS\n",
      "X8Y4UL4G\n",
      "X8Y4UL6O\n",
      "X8Y4ULBL\n",
      "X8Y4ULYO\n",
      "X8Y4UMQ0\n",
      "X8Y4UN56\n",
      "X8Y4UNU2\n",
      "X8Y4UNWI\n",
      "X8Y4UOIX\n",
      "X8Y4UOLU\n",
      "X8Y4UPU8\n",
      "X8Y4UQ41\n",
      "X8Y4URUI\n",
      "X8Y4URYJ\n",
      "X8Y4USA0\n",
      "X8Y4UT0O\n",
      "X8Y4UT4O\n",
      "X8Y4UT6H\n",
      "X8Y4UU5U\n",
      "X8Y4UUKG\n",
      "X8Y4UVSY\n",
      "X8Y4UWY8\n",
      "X8Y4UX4H\n",
      "X8Y4UX4P\n",
      "X8Y4UZY3\n",
      "X8Y4V0F5\n",
      "X8Y4V15T\n",
      "X8Y4V20P\n",
      "X8Y4V357\n",
      "X8Y4V3VF\n",
      "X8Y4V4OJ\n",
      "X8Y4V4PZ\n",
      "X8Y4V5QG\n",
      "X8Y4V6A3\n",
      "X8Y4V6N5\n",
      "X8Y4V6QP\n",
      "X8Y4V8QX\n",
      "X8Y4V99N\n",
      "X8Y4VBTE\n",
      "X8Y4VCSX\n",
      "X8Y4VEBL\n",
      "X8Y4VEGH\n",
      "X8Y4VEGP\n",
      "X8Y4VFQQ\n",
      "X8Y4VG20\n",
      "X8Y4VGOP\n",
      "X8Y4VH6B\n",
      "X8Y4VHCY\n",
      "X8Y4VHOG\n",
      "X8Y4VIGO\n",
      "X8Y4VIS3\n",
      "X8Y4VJ5T\n",
      "X8Y4VJF3\n",
      "X8Y4VL1F\n",
      "X8Y4VLLC\n",
      "X8Y4VMKJ\n",
      "X8Y4VNMA\n",
      "X8Y4VOB7\n",
      "X8Y4VOCB\n",
      "X8Y4VOS8\n",
      "X8Y4VPEP\n",
      "X8Y4VQ55\n",
      "X8Y4VR7S\n",
      "X8Y4VRIA\n",
      "X8Y4VS77\n",
      "X8Y4VSM1\n",
      "X8Y4VSM9\n",
      "X8Y4VTL4\n",
      "X8Y4VTZ6\n",
      "X8Y4W2I3\n",
      "X8Y4W2YH\n",
      "X8Y4W2YW\n",
      "X8Y4W3ZF\n",
      "X8Y4W423\n",
      "X8Y4W4EP\n",
      "X8Y4W6ER\n",
      "X8Y4W7RS\n",
      "X8Y4W7ZV\n",
      "X8Y4W876\n",
      "X8Y4W8G9\n",
      "X8Y4W91U\n",
      "X8Y4WAVC\n",
      "X8Y4WB00\n",
      "X8Y4WDTE\n",
      "X8Y4WDW9\n",
      "X8Y4WFEP\n",
      "X8Y4WFMO\n",
      "X8Y4WHBC\n",
      "X8Y4WHHN\n",
      "X8Y4WJGP\n",
      "X8Y4WJNS\n",
      "X8Y4SMXM\n",
      "X8Y4SNUY\n",
      "X8Y4SNXT\n",
      "X8Y4SOZS\n",
      "X8Y4SP1S\n",
      "X8Y4SP8R\n",
      "X8Y4SP28\n",
      "X8Y4SPSO\n",
      "X8Y4SR0I\n",
      "X8Y4SRG8\n",
      "X8Y4STP4\n",
      "X8Y4STUZ\n",
      "X8Y4SWO1\n",
      "X8Y4SWQ1\n",
      "X8Y4SWQH\n",
      "X8Y4SXX7\n",
      "X8Y4SXZU\n",
      "X8Y4SYH4\n",
      "X8Y4SZ5L\n",
      "X8Y4SZOY\n",
      "X8Y4T0LT\n",
      "X8Y4T1Q0\n",
      "X8Y4T2MJ\n",
      "X8Y4T2OB\n",
      "X8Y4T3KA\n",
      "X8Y4T6GG\n",
      "X8Y4T6RU\n",
      "X8Y4T6W9\n",
      "X8Y4T8NS\n",
      "X8Y4T8P4\n",
      "X8Y4T8PC\n",
      "X8Y4T9BL\n",
      "X8Y4T68H\n",
      "X8Y4T78O\n",
      "X8Y4T788\n",
      "X8Y4TAXD\n",
      "X8Y4TBSP\n",
      "X8Y4TCB6\n",
      "X8Y4TCWB\n",
      "X8Y4TD22\n",
      "X8Y4TDK0\n",
      "X8Y4TDOJ\n",
      "X8Y4TFAZ\n",
      "X8Y4TG1N\n",
      "X8Y4TGZ6\n",
      "X8Y4THD4\n",
      "X8Y4TJ1O\n",
      "X8Y4TJ1S\n",
      "X8Y4TKGH\n",
      "X8Y4TKLK\n",
      "X8Y4TKPN\n",
      "X8Y4TLIR\n",
      "X8Y4TOYI\n",
      "X8Y4TQB7\n",
      "X8Y4TQBN\n",
      "X8Y4TU43\n",
      "X8XZIBOZ\n",
      "X8XZINW9\n",
      "X8Y4QNJE\n",
      "X8Y4QWQB\n",
      "X8Y4RM8X\n",
      "X8Y4SRGR\n",
      "X8Y4TD2I\n",
      "X8Y4TGYA\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "df = pd.read_csv('Results.csv')\n",
    "dict_result = {}\n",
    "for i in range(len(df)):\n",
    "    name_file = df.iloc[i]['Filename']\n",
    "    print(name_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2307,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1628,
   "metadata": {},
   "outputs": [],
   "source": [
    "name_file = 'X8Y4QW2Z'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1481,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'X8XUG1JD'"
      ]
     },
     "execution_count": 1481,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Filename'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2322,
   "metadata": {},
   "outputs": [],
   "source": [
    "name_file = \"X8XX0C57\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "file_name = \"Challenge Dataset/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2323,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' Balance Sheet as at 31 January 2020', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2020', '', '', '', '', '', '2019', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Â£', '', '', '', '', '', '', ' Â£', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Called up share capital not paid', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' 1', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Net assets', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' 1', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Tssued share capital', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1 Ordinary Share 1 of Â£ each', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ' 1', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Total Shareholder funds', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' STATEMENTS', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', 'a.', ' For the year ending 31 January 2020 the company was entities to exemption under section 480 of', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', ' the Companies Act 2006 relating to dormant companies', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', 'b.', ' The members have not required the company to obtain an audit in accordance with section 476 of', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', ' the Companies Act 2006.', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', 'Â¢.', ' The director acknowledge their responsibilities for complying with the requirements of the Act', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', ' with respect to accounting', '', '', '', '', '', '', '', ' records and the preparation of accounts.', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', 'd.', ' These accounts', '', '', '', '', ' have been prepared in accordance with the provisions applicable to companies', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', '', '', '', '', '', ' subject to the small companies regime.', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' Approved by the Board on 31 January 2020', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' And signed on their behalf by:', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' RASHAD JAVID, Director', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' NOTES', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' During the year the company acted as an Parent for a person', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' This document was delivered using electronic communications and authenticated in accordance with the', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', \" registrar's rules relating to electronic form, authentication and manner of delivery under section 1072 of\", '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['', '', '', '', '', '', '', ' the Companies Act 2006.', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''], ['']]\n"
     ]
    }
   ],
   "source": [
    "with open(file_name + name_file + \".txt\", \"r\") as file:\n",
    "    x = file.read()\n",
    "    y = x.split(\"\\n\")#.replace('  ', ' ')\n",
    "    y = [x.split(\"  \") for x in y]\n",
    "    print(y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2324,
   "metadata": {},
   "outputs": [],
   "source": [
    "for j in range(len(y)):\n",
    "    while(y[j].count(\"\") != 0):\n",
    "        y[j].remove(\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2325,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[' Balance Sheet as at 31 January 2020'],\n",
       " ['2020', '2019'],\n",
       " ['Â£', ' Â£'],\n",
       " ['Called up share capital not paid', ' 1', '1'],\n",
       " ['Net assets', ' 1', '1'],\n",
       " ['Tssued share capital'],\n",
       " ['1 Ordinary Share 1 of Â£ each', ' 1', '1'],\n",
       " ['Total Shareholder funds', '1', '1'],\n",
       " [' STATEMENTS'],\n",
       " ['a.',\n",
       "  ' For the year ending 31 January 2020 the company was entities to exemption under section 480 of'],\n",
       " [' the Companies Act 2006 relating to dormant companies'],\n",
       " ['b.',\n",
       "  ' The members have not required the company to obtain an audit in accordance with section 476 of'],\n",
       " [' the Companies Act 2006.'],\n",
       " ['Â¢.',\n",
       "  ' The director acknowledge their responsibilities for complying with the requirements of the Act'],\n",
       " [' with respect to accounting', ' records and the preparation of accounts.'],\n",
       " ['d.',\n",
       "  ' These accounts',\n",
       "  ' have been prepared in accordance with the provisions applicable to companies'],\n",
       " [' subject to the small companies regime.'],\n",
       " [' Approved by the Board on 31 January 2020'],\n",
       " [' And signed on their behalf by:'],\n",
       " [' RASHAD JAVID, Director'],\n",
       " [' NOTES'],\n",
       " [' During the year the company acted as an Parent for a person'],\n",
       " [' This document was delivered using electronic communications and authenticated in accordance with the'],\n",
       " [\" registrar's rules relating to electronic form, authentication and manner of delivery under section 1072 of\"],\n",
       " [' the Companies Act 2006.'],\n",
       " []]"
      ]
     },
     "execution_count": 2325,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2326,
   "metadata": {},
   "outputs": [],
   "source": [
    "head = [y[j] for j in range(len(y) - 1) if '£' in y[j+1] or ' £' in y[j+1] or '£ ' in y[j+1] or 'Â£' in y[j+1] or ' Â£ ' in y[j+1] or 'Â£ ' in y[j+1] or ' Â£' in y[j+1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2327,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['2020', '2019']]"
      ]
     },
     "execution_count": 2327,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2328,
   "metadata": {},
   "outputs": [],
   "source": [
    "head = head[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2329,
   "metadata": {},
   "outputs": [],
   "source": [
    "p = head.index('2019')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2330,
   "metadata": {},
   "outputs": [],
   "source": [
    "s = 0\n",
    "e = 0\n",
    "for i in range(len(y)):\n",
    "    if '£' in y[i] or ' £' in y[i] or '£ ' in y[i] or 'Â£' in y[i] or ' Â£ ' in y[i] or 'Â£ ' in y[i] or ' Â£' in y[i]:\n",
    "        s = i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2331,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 2331,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2332,
   "metadata": {},
   "outputs": [],
   "source": [
    "del y[s]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2333,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'[[\" Balance Sheet as at 31 January 2020\"], [\"2020\", \"2019\"], [\"Called up share capital not paid\", \" 1\", \"1\"], [\"Net assets\", \" 1\", \"1\"], [\"Tssued share capital\"], [\"1 Ordinary Share 1 of \\\\u00c2\\\\u00a3 each\", \" 1\", \"1\"], [\"Total Shareholder funds\", \"1\", \"1\"], [\" STATEMENTS\"], [\"a.\", \" For the year ending 31 January 2020 the company was entities to exemption under section 480 of\"], [\" the Companies Act 2006 relating to dormant companies\"], [\"b.\", \" The members have not required the company to obtain an audit in accordance with section 476 of\"], [\" the Companies Act 2006.\"], [\"\\\\u00c2\\\\u00a2.\", \" The director acknowledge their responsibilities for complying with the requirements of the Act\"], [\" with respect to accounting\", \" records and the preparation of accounts.\"], [\"d.\", \" These accounts\", \" have been prepared in accordance with the provisions applicable to companies\"], [\" subject to the small companies regime.\"], [\" Approved by the Board on 31 January 2020\"], [\" And signed on their behalf by:\"], [\" RASHAD JAVID, Director\"], [\" NOTES\"], [\" During the year the company acted as an Parent for a person\"], [\" This document was delivered using electronic communications and authenticated in accordance with the\"], [\" registrar\\'s rules relating to electronic form, authentication and manner of delivery under section 1072 of\"], [\" the Companies Act 2006.\"], []]'"
      ]
     },
     "execution_count": 2333,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json.dumps(y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2334,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(y)):\n",
    "    if 'STATEMENTS' in y[i] or ' STATEMENTS' in y[i] or 'STATEMENTS ' in y[i] or ' STATEMENTS ' in y[i]:\n",
    "        e = i"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2335,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(y)):\n",
    "    if 'Capital and reserves' in y[i] or ' Capital and reserves' in y[i] or 'Capital and reserves ' in y[i] or ' Capital and reserves ' in y[i]:\n",
    "        e = i+1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2336,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 2336,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2337,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 2337,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2338,
   "metadata": {},
   "outputs": [],
   "source": [
    "y_new = y[s-1:e]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2339,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['2020', '2019'],\n",
       " ['Called up share capital not paid', ' 1', '1'],\n",
       " ['Net assets', ' 1', '1'],\n",
       " ['Tssued share capital'],\n",
       " ['1 Ordinary Share 1 of Â£ each', ' 1', '1'],\n",
       " ['Total Shareholder funds', '1', '1']]"
      ]
     },
     "execution_count": 2339,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2340,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'for i in range(len(y_new)):\\n    y_new[i] = np.array(y_new[i])'"
      ]
     },
     "execution_count": 2340,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''for i in range(len(y_new)):\n",
    "    y_new[i] = np.array(y_new[i])'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2341,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'y_new = np.array(y_new)'"
      ]
     },
     "execution_count": 2341,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "'''y_new = np.array(y_new)'''"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2342,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2020', '2019']"
      ]
     },
     "execution_count": 2342,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2343,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['2020', '2019'],\n",
       " ['Called up share capital not paid', ' 1', '1'],\n",
       " ['Net assets', ' 1', '1'],\n",
       " ['Tssued share capital'],\n",
       " ['1 Ordinary Share 1 of Â£ each', ' 1', '1'],\n",
       " ['Total Shareholder funds', '1', '1']]"
      ]
     },
     "execution_count": 2343,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2344,
   "metadata": {},
   "outputs": [],
   "source": [
    "mx = 0\n",
    "l= []\n",
    "for i in range(len(y_new)):\n",
    "    l.append(len(y_new[i]))\n",
    "mx= max(l)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2345,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 2345,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mx"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2346,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['2020', '2019'],\n",
       " ['Called up share capital not paid', ' 1', '1'],\n",
       " ['Net assets', ' 1', '1'],\n",
       " ['Tssued share capital'],\n",
       " ['1 Ordinary Share 1 of Â£ each', ' 1', '1'],\n",
       " ['Total Shareholder funds', '1', '1']]"
      ]
     },
     "execution_count": 2346,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2347,
   "metadata": {},
   "outputs": [],
   "source": [
    "if(len(head)<mx):\n",
    "    head.insert(0, 'Notes')\n",
    "    y_new[0] = head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2348,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Notes', '2020', '2019']"
      ]
     },
     "execution_count": 2348,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "head"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2349,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Notes', '2020', '2019'],\n",
       " ['Called up share capital not paid', ' 1', '1'],\n",
       " ['Net assets', ' 1', '1'],\n",
       " ['Tssued share capital'],\n",
       " ['1 Ordinary Share 1 of Â£ each', ' 1', '1'],\n",
       " ['Total Shareholder funds', '1', '1']]"
      ]
     },
     "execution_count": 2349,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "y_new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2350,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfs = pd.DataFrame.from_records(y_new)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2351,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfs.iloc[0][0] = dfs.iloc[0][0].replace(' ', '')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2352,
   "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>Notes</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Notes</td>\n",
       "      <td>2020</td>\n",
       "      <td>2019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Called up share capital not paid</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Net assets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tssued share capital</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1 Ordinary Share 1 of Â£ each</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Total Shareholder funds</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "0                             Notes  2020  2019\n",
       "0                             Notes  2020  2019\n",
       "1  Called up share capital not paid     1     1\n",
       "2                        Net assets     1     1\n",
       "3              Tssued share capital  None  None\n",
       "4     1 Ordinary Share 1 of Â£ each     1     1\n",
       "5           Total Shareholder funds     1     1"
      ]
     },
     "execution_count": 2352,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs.columns = dfs.iloc[0]\n",
    "dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2353,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns = []\n",
    "for i in range(len(dfs.columns)):\n",
    "    if(dfs.columns[i] != None):\n",
    "        columns.append(dfs.columns[i].replace(' ', ''))\n",
    "    else:\n",
    "        columns.append(dfs.columns[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2354,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Notes', '2020', '2019'], dtype='object', name=0)"
      ]
     },
     "execution_count": 2354,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2355,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfs.columns = columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2356,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Notes', '2020', '2019']"
      ]
     },
     "execution_count": 2356,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2357,
   "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>Notes</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Called up share capital not paid</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Net assets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Tssued share capital</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1 Ordinary Share 1 of Â£ each</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Total Shareholder funds</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Notes  2020  2019\n",
       "1  Called up share capital not paid     1     1\n",
       "2                        Net assets     1     1\n",
       "3              Tssued share capital  None  None\n",
       "4     1 Ordinary Share 1 of Â£ each     1     1\n",
       "5           Total Shareholder funds     1     1"
      ]
     },
     "execution_count": 2357,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs = dfs.drop(dfs.index[0])\n",
    "dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2358,
   "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>Notes</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Called up share capital not paid</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Net assets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tssued share capital</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1 Ordinary Share 1 of Â£ each</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Total Shareholder funds</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Notes  2020  2019\n",
       "0  Called up share capital not paid     1     1\n",
       "1                        Net assets     1     1\n",
       "2              Tssued share capital  None  None\n",
       "3     1 Ordinary Share 1 of Â£ each     1     1\n",
       "4           Total Shareholder funds     1     1"
      ]
     },
     "execution_count": 2358,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs.reset_index(drop=True, inplace=True)\n",
    "dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2359,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(dfs['2019'])):\n",
    "    try:        \n",
    "        dfs['2019'][i] = dfs['2019'][i].replace('-', '')\n",
    "        dfs['2019'][i] = dfs['2019'][i].replace(' ', '').replace('(', '-').replace(')', '').replace(',', '')\n",
    "    except:\n",
    "        pass\n",
    "    if(dfs['Notes'][i][0] ==  ' '):\n",
    "        dfs['Notes'][i] = dfs['Notes'][i][1:]\n",
    "    if(dfs['Notes'][i][len(dfs['Notes'][i])-1] == ' '):\n",
    "        dfs['Notes'][i] = dfs['Notes'][i][0:len(dfs['Notes'][i])-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2360,
   "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>Notes</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Called up share capital not paid</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Net assets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tssued share capital</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1 Ordinary Share 1 of Â£ each</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Total Shareholder funds</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Notes  2020  2019\n",
       "0  Called up share capital not paid     1     1\n",
       "1                        Net assets     1     1\n",
       "2              Tssued share capital  None  None\n",
       "3     1 Ordinary Share 1 of Â£ each     1     1\n",
       "4           Total Shareholder funds     1     1"
      ]
     },
     "execution_count": 2360,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2361,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(len(dfs['2019'])): \n",
    "    if(dfs['2019'][i] == None ):\n",
    "        dfs['2019'][i] = ''\n",
    "    if(dfs['2019'][i] == '' ):\n",
    "        dfs['2019'][i] = float(\"nan\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2362,
   "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>Notes</th>\n",
       "      <th>2020</th>\n",
       "      <th>2019</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Called up share capital not paid</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Net assets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tssued share capital</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1 Ordinary Share 1 of Â£ each</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Total Shareholder funds</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Notes  2020 2019\n",
       "0  Called up share capital not paid     1    1\n",
       "1                        Net assets     1    1\n",
       "2              Tssued share capital  None  NaN\n",
       "3     1 Ordinary Share 1 of Â£ each     1    1\n",
       "4           Total Shareholder funds     1    1"
      ]
     },
     "execution_count": 2362,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2363,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Called up share capital not paid': '1',\n",
       " 'Net assets': '1',\n",
       " 'Tssued share capital': nan,\n",
       " '1 Ordinary Share 1 of Â£ each': '1',\n",
       " 'Total Shareholder funds': '1'}"
      ]
     },
     "execution_count": 2363,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs.set_index('Notes').to_dict()['2019']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2364,
   "metadata": {},
   "outputs": [],
   "source": [
    "d = dfs.set_index('Notes').to_dict()['2019']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2365,
   "metadata": {},
   "outputs": [],
   "source": [
    "d = str(d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2366,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"{'Called up share capital not paid': '1', 'Net assets': '1', 'Tssued share capital': nan, '1 Ordinary Share 1 of Â£ each': '1', 'Total Shareholder funds': '1'}\""
      ]
     },
     "execution_count": 2366,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2321,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{\"Called up share capital not paid\": \"1\", \"Net assets\": \"1\", \"Tssued share capital\": NaN, \"1 Ordinary Share 1 of Â£ each\": \"1\", \"Total Shareholder funds\": \"1\"}'"
      ]
     },
     "execution_count": 2321,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.replace(\"\\\\u00c2\", \"Â\").replace(\"\\\\u00a3\", \"£\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 2254,
   "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>Extracted Values</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>X8XUG1JD</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>X8XX0C57</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>X8XX02AX</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>X8XX0ANN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>X8XX0BU1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>X8Y4QWQB</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>X8Y4RM8X</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>X8Y4SRGR</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>X8Y4TD2I</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>X8Y4TGYA</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Filename  Extracted Values\n",
       "0    X8XUG1JD               NaN\n",
       "1    X8XX0C57               NaN\n",
       "2    X8XX02AX               NaN\n",
       "3    X8XX0ANN               NaN\n",
       "4    X8XX0BU1               NaN\n",
       "..        ...               ...\n",
       "495  X8Y4QWQB               NaN\n",
       "496  X8Y4RM8X               NaN\n",
       "497  X8Y4SRGR               NaN\n",
       "498  X8Y4TD2I               NaN\n",
       "499  X8Y4TGYA               NaN\n",
       "\n",
       "[500 rows x 2 columns]"
      ]
     },
     "execution_count": 2254,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2255,
   "metadata": {},
   "outputs": [],
   "source": [
    "dict = {}\n",
    "list = []\n",
    "for x in range(0,500):\n",
    "    dict[1] = x\n",
    "    list.append(dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1112,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "500"
      ]
     },
     "execution_count": 1112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1113,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499},\n",
       " {1: 499}]"
      ]
     },
     "execution_count": 1113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1114,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Extracted Values'] = list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1115,
   "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>Extracted Values</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>X8XUG1JD</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>X8XX0C57</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>X8XX02AX</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>X8XX0ANN</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>X8XX0BU1</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>X8Y4QWQB</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>X8Y4RM8X</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>X8Y4SRGR</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>X8Y4TD2I</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>X8Y4TGYA</td>\n",
       "      <td>{1: 499}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Filename Extracted Values\n",
       "0    X8XUG1JD         {1: 499}\n",
       "1    X8XX0C57         {1: 499}\n",
       "2    X8XX02AX         {1: 499}\n",
       "3    X8XX0ANN         {1: 499}\n",
       "4    X8XX0BU1         {1: 499}\n",
       "..        ...              ...\n",
       "495  X8Y4QWQB         {1: 499}\n",
       "496  X8Y4RM8X         {1: 499}\n",
       "497  X8Y4SRGR         {1: 499}\n",
       "498  X8Y4TD2I         {1: 499}\n",
       "499  X8Y4TGYA         {1: 499}\n",
       "\n",
       "[500 rows x 2 columns]"
      ]
     },
     "execution_count": 1115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1118,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('dummySubmission.csv', index= False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}