extractionDataWithCamelotAndOpenCV.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "'''\n",
    "extraire une page d'un pdf\n",
    "\n",
    "'''\n",
    "import PyPDF2\n",
    "import tabula\n",
    "import pandas as pd\n",
    "from pdf2image import convert_from_path\n",
    "import cv2\n",
    "import numpy as np\n",
    "from PIL import Image, ImageOps\n",
    "from PyPDF2 import PdfFileReader\n",
    "import camelot\n",
    "import matplotlib.pyplot as plt\n",
    "import os\n",
    "from wand.image import Image as wimage\n",
    "import re\n",
    "\n",
    "import tabula\n",
    "\n",
    "\n",
    "num_page=1\n",
    "\n",
    "DATAPATH = 'data/'\n",
    "OUTPUTPATH = 'generated_output/'\n",
    "INPUT_PDF='OneTablePage%d.pdf'%num_page\n",
    "INPUT_JPG='OneTablePage%d.jpg'%num_page\n",
    "OUTPUT_CSV='OneTablePage%d.csv'%num_page\n",
    "OUTPUT_XLSX='OneTablePage%d.xlsx'%num_page\n",
    "PDFfilename = \"doc4.pdf\" #filename of your PDF/directory where your PDF is stored\n",
    "\n",
    "\n",
    "pfr = PyPDF2.PdfFileReader(open(PDFfilename, \"rb\")) #PdfFileReader object\n",
    "pg4 = pfr.getPage(num_page) #extract pg \n",
    "\n",
    "\n",
    "(pdf_width,pdf_height)= (pfr.getPage(num_page).mediaBox[2],pfr.getPage(num_page).mediaBox[3])\n",
    "\n",
    "writer = PyPDF2.PdfFileWriter() #create PdfFileWriter object\n",
    "#add pages\n",
    "writer.addPage(pg4)\n",
    "NewPDFfilename = os.path.join(DATAPATH, INPUT_PDF) #filename of your PDF/directory where you want your new PDF to be\n",
    "with open(NewPDFfilename, \"wb\") as outputStream:\n",
    "    writer.write(outputStream) #write pages to new PDF\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pour convertir la page en jpg\n",
    "\n",
    "import os\n",
    "import tempfile\n",
    "from pdf2image import convert_from_path\n",
    "\n",
    "\n",
    "images_from_path = convert_from_path(PDFfilename, last_page=num_page+1, first_page =num_page+1)\n",
    "\n",
    "for page in images_from_path:\n",
    "    page.save(os.path.join(DATAPATH, INPUT_JPG), 'JPEG')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "# -*- coding: utf-8 -*-\n",
    "\n",
    "from __future__ import division\n",
    "\n",
    "import cv2\n",
    "import numpy as np\n",
    "\n",
    "\n",
    "def adaptive_threshold(imagename, process_background=False, blocksize=15, c=-2):\n",
    "    \"\"\"Thresholds an image using OpenCV's adaptiveThreshold.\n",
    "    Parameters\n",
    "    ----------\n",
    "    imagename : string\n",
    "        Path to image file.\n",
    "    process_background : bool, optional (default: False)\n",
    "        Whether or not to process lines that are in background.\n",
    "    blocksize : int, optional (default: 15)\n",
    "        Size of a pixel neighborhood that is used to calculate a\n",
    "        threshold value for the pixel: 3, 5, 7, and so on.\n",
    "        For more information, refer `OpenCV's adaptiveThreshold <https://docs.opencv.org/2.4/modules/imgproc/doc/miscellaneous_transformations.html#adaptivethreshold>`_.\n",
    "    c : int, optional (default: -2)\n",
    "        Constant subtracted from the mean or weighted mean.\n",
    "        Normally, it is positive but may be zero or negative as well.\n",
    "        For more information, refer `OpenCV's adaptiveThreshold <https://docs.opencv.org/2.4/modules/imgproc/doc/miscellaneous_transformations.html#adaptivethreshold>`_.\n",
    "    Returns\n",
    "    -------\n",
    "    img : object\n",
    "        numpy.ndarray representing the original image.\n",
    "    threshold : object\n",
    "        numpy.ndarray representing the thresholded image.\n",
    "    \"\"\"\n",
    "    img = cv2.imread(imagename)\n",
    "    gray = cv2.cvtColor(img, cv2.COLOR_BGR2GRAY)\n",
    "\n",
    "    if process_background:\n",
    "        threshold = cv2.adaptiveThreshold(\n",
    "            gray, 255, cv2.ADAPTIVE_THRESH_GAUSSIAN_C,\n",
    "            cv2.THRESH_BINARY, blocksize, c)\n",
    "    else:\n",
    "        threshold = cv2.adaptiveThreshold(\n",
    "            np.invert(gray), 255,\n",
    "            cv2.ADAPTIVE_THRESH_GAUSSIAN_C, cv2.THRESH_BINARY, blocksize, c)\n",
    "    return img, threshold\n",
    "\n",
    "\n",
    "def find_lines(threshold, regions=None, direction='horizontal',\n",
    "               line_scale=15, iterations=0):\n",
    "    \"\"\"Finds horizontal and vertical lines by applying morphological\n",
    "    transformations on an image.\n",
    "    Parameters\n",
    "    ----------\n",
    "    threshold : object\n",
    "        numpy.ndarray representing the thresholded image.\n",
    "    regions : list, optional (default: None)\n",
    "        List of page regions that may contain tables of the form x1,y1,x2,y2\n",
    "        where (x1, y1) -> left-top and (x2, y2) -> right-bottom\n",
    "        in image coordinate space.\n",
    "    direction : string, optional (default: 'horizontal')\n",
    "        Specifies whether to find vertical or horizontal lines.\n",
    "    line_scale : int, optional (default: 15)\n",
    "        Factor by which the page dimensions will be divided to get\n",
    "        smallest length of lines that should be detected.\n",
    "        The larger this value, smaller the detected lines. Making it\n",
    "        too large will lead to text being detected as lines.\n",
    "    iterations : int, optional (default: 0)\n",
    "        Number of times for erosion/dilation is applied.\n",
    "        For more information, refer `OpenCV's dilate <https://docs.opencv.org/2.4/modules/imgproc/doc/filtering.html#dilate>`_.\n",
    "    Returns\n",
    "    -------\n",
    "    dmask : object\n",
    "        numpy.ndarray representing pixels where vertical/horizontal\n",
    "        lines lie.\n",
    "    lines : list\n",
    "        List of tuples representing vertical/horizontal lines with\n",
    "        coordinates relative to a left-top origin in\n",
    "        image coordinate space.\n",
    "    \"\"\"\n",
    "    lines = []\n",
    "\n",
    "    if direction == 'vertical':\n",
    "        size = threshold.shape[0] // line_scale\n",
    "        el = cv2.getStructuringElement(cv2.MORPH_RECT, (1, size))\n",
    "    elif direction == 'horizontal':\n",
    "        size = threshold.shape[1] // line_scale\n",
    "        el = cv2.getStructuringElement(cv2.MORPH_RECT, (size, 1))\n",
    "    elif direction is None:\n",
    "        raise ValueError(\"Specify direction as either 'vertical' or\"\n",
    "                         \" 'horizontal'\")\n",
    "\n",
    "    if regions is not None:\n",
    "        region_mask = np.zeros(threshold.shape)\n",
    "        for region in regions:\n",
    "            x, y, w, h = region\n",
    "            region_mask[y : y + h, x : x + w] = 1\n",
    "        threshold = np.multiply(threshold, region_mask)\n",
    "\n",
    "    threshold = cv2.erode(threshold, el)\n",
    "    threshold = cv2.dilate(threshold, el)\n",
    "    dmask = cv2.dilate(threshold, el, iterations=iterations)\n",
    "\n",
    "    try:\n",
    "        _, contours, _ = cv2.findContours(\n",
    "            threshold.astype(np.uint8), cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE)\n",
    "    except ValueError:\n",
    "        # for opencv backward compatibility\n",
    "        contours, _ = cv2.findContours(\n",
    "            threshold.astype(np.uint8), cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE)\n",
    "\n",
    "    for c in contours:\n",
    "        x, y, w, h = cv2.boundingRect(c)\n",
    "        x1, x2 = x, x + w\n",
    "        y1, y2 = y, y + h\n",
    "        if direction == 'vertical':\n",
    "            lines.append(((x1 + x2) // 2, y2, (x1 + x2) // 2, y1))\n",
    "        elif direction == 'horizontal':\n",
    "            lines.append((x1, (y1 + y2) // 2, x2, (y1 + y2) // 2))\n",
    "\n",
    "    return dmask, lines\n",
    "\n",
    "\n",
    "def find_contours(vertical, horizontal):\n",
    "    \"\"\"Finds table boundaries using OpenCV's findContours.\n",
    "    Parameters\n",
    "    ----------\n",
    "    vertical : object\n",
    "        numpy.ndarray representing pixels where vertical lines lie.\n",
    "    horizontal : object\n",
    "        numpy.ndarray representing pixels where horizontal lines lie.\n",
    "    Returns\n",
    "    -------\n",
    "    cont : list\n",
    "        List of tuples representing table boundaries. Each tuple is of\n",
    "        the form (x, y, w, h) where (x, y) -> left-top, w -> width and\n",
    "        h -> height in image coordinate space.\n",
    "    \"\"\"\n",
    "    mask = vertical + horizontal\n",
    "\n",
    "    try:\n",
    "        __, contours, __ = cv2.findContours(\n",
    "            mask.astype(np.uint8), cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE)\n",
    "    except ValueError:\n",
    "        # for opencv backward compatibility\n",
    "        contours, __ = cv2.findContours(\n",
    "            mask.astype(np.uint8), cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE)\n",
    "    # sort in reverse based on contour area and use first 10 contours\n",
    "    contours = sorted(contours, key=cv2.contourArea, reverse=True)[:10]\n",
    "\n",
    "    cont = []\n",
    "    for c in contours:\n",
    "        c_poly = cv2.approxPolyDP(c, 3, True)\n",
    "        x, y, w, h = cv2.boundingRect(c_poly)\n",
    "        cont.append((x, y, w, h))\n",
    "    return cont\n",
    "\n",
    "\n",
    "def find_joints(contours, vertical, horizontal):\n",
    "    \"\"\"Finds joints/intersections present inside each table boundary.\n",
    "    Parameters\n",
    "    ----------\n",
    "    contours : list\n",
    "        List of tuples representing table boundaries. Each tuple is of\n",
    "        the form (x, y, w, h) where (x, y) -> left-top, w -> width and\n",
    "        h -> height in image coordinate space.\n",
    "    vertical : object\n",
    "        numpy.ndarray representing pixels where vertical lines lie.\n",
    "    horizontal : object\n",
    "        numpy.ndarray representing pixels where horizontal lines lie.\n",
    "    Returns\n",
    "    -------\n",
    "    tables : dict\n",
    "        Dict with table boundaries as keys and list of intersections\n",
    "        in that boundary as their value.\n",
    "        Keys are of the form (x1, y1, x2, y2) where (x1, y1) -> lb\n",
    "        and (x2, y2) -> rt in image coordinate space.\n",
    "    \"\"\"\n",
    "    joints = np.multiply(vertical, horizontal)\n",
    "    tables = {}\n",
    "    for c in contours:\n",
    "        x, y, w, h = c\n",
    "        roi = joints[y : y + h, x : x + w]\n",
    "        try:\n",
    "            __, jc, __ = cv2.findContours(\n",
    "                roi.astype(np.uint8), cv2.RETR_CCOMP, cv2.CHAIN_APPROX_SIMPLE)\n",
    "        except ValueError:\n",
    "            # for opencv backward compatibility\n",
    "            jc, __ = cv2.findContours(\n",
    "                roi.astype(np.uint8), cv2.RETR_CCOMP, cv2.CHAIN_APPROX_SIMPLE)\n",
    "        if len(jc) <= 4:  # remove contours with less than 4 joints\n",
    "            continue\n",
    "        joint_coords = []\n",
    "        for j in jc:\n",
    "            jx, jy, jw, jh = cv2.boundingRect(j)\n",
    "            c1, c2 = x + (2 * jx + jw) // 2, y + (2 * jy + jh) // 2\n",
    "            joint_coords.append((c1, c2))\n",
    "        tables[(x, y + h, x + w, y)] = joint_coords\n",
    "\n",
    "    return tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "image ,threshold=adaptive_threshold(os.path.join(DATAPATH, INPUT_JPG), process_background=False, blocksize=15, c=-2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "vertical_mask, vertical_segments=find_lines(threshold, regions=None, direction='vertical',line_scale=15, iterations=0)\n",
    "horizontal_mask, horizontal_segments=find_lines(threshold, regions=None, direction='horizontal',line_scale=15, iterations=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "contours = find_contours(vertical_mask, horizontal_mask)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "table_bbox = find_joints(contours, vertical_mask, horizontal_mask)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{(40, 1446, 1616, 943): [(1613, 1444),\n",
       "  (1505, 1444),\n",
       "  (1401, 1444),\n",
       "  (1321, 1444),\n",
       "  (1250, 1444),\n",
       "  (1179, 1444),\n",
       "  (1107, 1444),\n",
       "  (1036, 1444),\n",
       "  (965, 1444),\n",
       "  (894, 1444),\n",
       "  (822, 1444),\n",
       "  (749, 1444),\n",
       "  (678, 1444),\n",
       "  (607, 1444),\n",
       "  (536, 1444),\n",
       "  (465, 1444),\n",
       "  (391, 1444),\n",
       "  (99, 1444),\n",
       "  (41, 1444),\n",
       "  (1613, 1403),\n",
       "  (1505, 1403),\n",
       "  (1401, 1403),\n",
       "  (1321, 1403),\n",
       "  (1250, 1403),\n",
       "  (1179, 1403),\n",
       "  (1107, 1403),\n",
       "  (1036, 1403),\n",
       "  (965, 1403),\n",
       "  (894, 1403),\n",
       "  (822, 1403),\n",
       "  (749, 1403),\n",
       "  (678, 1403),\n",
       "  (607, 1403),\n",
       "  (536, 1403),\n",
       "  (465, 1403),\n",
       "  (391, 1403),\n",
       "  (99, 1403),\n",
       "  (1613, 1378),\n",
       "  (1505, 1378),\n",
       "  (1401, 1378),\n",
       "  (1321, 1378),\n",
       "  (1250, 1378),\n",
       "  (1179, 1378),\n",
       "  (1107, 1378),\n",
       "  (1036, 1378),\n",
       "  (965, 1378),\n",
       "  (894, 1378),\n",
       "  (822, 1378),\n",
       "  (749, 1378),\n",
       "  (678, 1378),\n",
       "  (607, 1378),\n",
       "  (536, 1378),\n",
       "  (465, 1378),\n",
       "  (391, 1378),\n",
       "  (99, 1378),\n",
       "  (1613, 1352),\n",
       "  (1505, 1352),\n",
       "  (1401, 1352),\n",
       "  (1321, 1352),\n",
       "  (1250, 1352),\n",
       "  (1179, 1352),\n",
       "  (1107, 1352),\n",
       "  (1036, 1352),\n",
       "  (965, 1352),\n",
       "  (894, 1352),\n",
       "  (822, 1352),\n",
       "  (749, 1352),\n",
       "  (678, 1352),\n",
       "  (607, 1352),\n",
       "  (536, 1352),\n",
       "  (465, 1352),\n",
       "  (391, 1352),\n",
       "  (99, 1352),\n",
       "  (1613, 1327),\n",
       "  (1505, 1327),\n",
       "  (1401, 1327),\n",
       "  (1321, 1327),\n",
       "  (1250, 1327),\n",
       "  (1179, 1327),\n",
       "  (1107, 1327),\n",
       "  (1036, 1327),\n",
       "  (965, 1327),\n",
       "  (894, 1327),\n",
       "  (822, 1327),\n",
       "  (749, 1327),\n",
       "  (678, 1327),\n",
       "  (607, 1327),\n",
       "  (536, 1327),\n",
       "  (465, 1327),\n",
       "  (391, 1327),\n",
       "  (99, 1327),\n",
       "  (1613, 1301),\n",
       "  (1505, 1301),\n",
       "  (1401, 1301),\n",
       "  (1321, 1301),\n",
       "  (1250, 1301),\n",
       "  (1179, 1301),\n",
       "  (1107, 1301),\n",
       "  (1036, 1301),\n",
       "  (965, 1301),\n",
       "  (894, 1301),\n",
       "  (822, 1301),\n",
       "  (749, 1301),\n",
       "  (678, 1301),\n",
       "  (607, 1301),\n",
       "  (536, 1301),\n",
       "  (465, 1301),\n",
       "  (391, 1301),\n",
       "  (99, 1301),\n",
       "  (1613, 1276),\n",
       "  (1505, 1276),\n",
       "  (1401, 1276),\n",
       "  (1321, 1276),\n",
       "  (1250, 1276),\n",
       "  (1179, 1276),\n",
       "  (1107, 1276),\n",
       "  (1036, 1276),\n",
       "  (965, 1276),\n",
       "  (894, 1276),\n",
       "  (822, 1276),\n",
       "  (749, 1276),\n",
       "  (678, 1276),\n",
       "  (607, 1276),\n",
       "  (536, 1276),\n",
       "  (465, 1276),\n",
       "  (391, 1276),\n",
       "  (99, 1276),\n",
       "  (1613, 1250),\n",
       "  (1505, 1250),\n",
       "  (1401, 1250),\n",
       "  (1321, 1250),\n",
       "  (1250, 1250),\n",
       "  (1179, 1250),\n",
       "  (1107, 1250),\n",
       "  (1036, 1250),\n",
       "  (965, 1250),\n",
       "  (894, 1250),\n",
       "  (822, 1250),\n",
       "  (749, 1250),\n",
       "  (678, 1250),\n",
       "  (607, 1250),\n",
       "  (536, 1250),\n",
       "  (465, 1250),\n",
       "  (391, 1250),\n",
       "  (99, 1250),\n",
       "  (1613, 1225),\n",
       "  (1505, 1225),\n",
       "  (1401, 1225),\n",
       "  (1321, 1225),\n",
       "  (1250, 1225),\n",
       "  (1179, 1225),\n",
       "  (1107, 1225),\n",
       "  (1036, 1225),\n",
       "  (965, 1225),\n",
       "  (894, 1225),\n",
       "  (822, 1225),\n",
       "  (749, 1225),\n",
       "  (678, 1225),\n",
       "  (607, 1225),\n",
       "  (536, 1225),\n",
       "  (465, 1225),\n",
       "  (391, 1225),\n",
       "  (99, 1225),\n",
       "  (1613, 1199),\n",
       "  (1505, 1199),\n",
       "  (1401, 1199),\n",
       "  (1321, 1199),\n",
       "  (1250, 1199),\n",
       "  (1179, 1199),\n",
       "  (1107, 1199),\n",
       "  (1036, 1199),\n",
       "  (965, 1199),\n",
       "  (894, 1199),\n",
       "  (822, 1199),\n",
       "  (749, 1199),\n",
       "  (678, 1199),\n",
       "  (607, 1199),\n",
       "  (536, 1199),\n",
       "  (465, 1199),\n",
       "  (391, 1199),\n",
       "  (99, 1199),\n",
       "  (1613, 1174),\n",
       "  (1505, 1174),\n",
       "  (1401, 1174),\n",
       "  (1321, 1174),\n",
       "  (1250, 1174),\n",
       "  (1179, 1174),\n",
       "  (1107, 1174),\n",
       "  (1036, 1174),\n",
       "  (965, 1174),\n",
       "  (894, 1174),\n",
       "  (822, 1174),\n",
       "  (749, 1174),\n",
       "  (678, 1174),\n",
       "  (607, 1174),\n",
       "  (536, 1174),\n",
       "  (465, 1174),\n",
       "  (391, 1174),\n",
       "  (99, 1174),\n",
       "  (1613, 1148),\n",
       "  (1505, 1148),\n",
       "  (1401, 1148),\n",
       "  (1321, 1148),\n",
       "  (1250, 1148),\n",
       "  (1179, 1148),\n",
       "  (1107, 1148),\n",
       "  (1036, 1148),\n",
       "  (965, 1148),\n",
       "  (894, 1148),\n",
       "  (822, 1148),\n",
       "  (749, 1148),\n",
       "  (678, 1148),\n",
       "  (607, 1148),\n",
       "  (536, 1148),\n",
       "  (465, 1148),\n",
       "  (391, 1148),\n",
       "  (99, 1148),\n",
       "  (1613, 1123),\n",
       "  (1505, 1123),\n",
       "  (1401, 1123),\n",
       "  (1321, 1123),\n",
       "  (1250, 1123),\n",
       "  (1179, 1123),\n",
       "  (1107, 1123),\n",
       "  (1036, 1123),\n",
       "  (965, 1123),\n",
       "  (894, 1123),\n",
       "  (822, 1123),\n",
       "  (749, 1123),\n",
       "  (678, 1123),\n",
       "  (607, 1123),\n",
       "  (536, 1123),\n",
       "  (465, 1123),\n",
       "  (391, 1123),\n",
       "  (99, 1123),\n",
       "  (1613, 1097),\n",
       "  (1505, 1097),\n",
       "  (1401, 1097),\n",
       "  (1321, 1097),\n",
       "  (1250, 1097),\n",
       "  (1179, 1097),\n",
       "  (1107, 1097),\n",
       "  (1036, 1097),\n",
       "  (965, 1097),\n",
       "  (894, 1097),\n",
       "  (822, 1097),\n",
       "  (749, 1097),\n",
       "  (678, 1097),\n",
       "  (607, 1097),\n",
       "  (536, 1097),\n",
       "  (465, 1097),\n",
       "  (391, 1097),\n",
       "  (99, 1097),\n",
       "  (1613, 1072),\n",
       "  (1505, 1072),\n",
       "  (1401, 1072),\n",
       "  (1321, 1072),\n",
       "  (1250, 1072),\n",
       "  (1179, 1072),\n",
       "  (1107, 1072),\n",
       "  (1036, 1072),\n",
       "  (965, 1072),\n",
       "  (894, 1072),\n",
       "  (822, 1072),\n",
       "  (749, 1072),\n",
       "  (678, 1072),\n",
       "  (607, 1072),\n",
       "  (536, 1072),\n",
       "  (465, 1072),\n",
       "  (391, 1072),\n",
       "  (99, 1072),\n",
       "  (1613, 1046),\n",
       "  (1505, 1046),\n",
       "  (1401, 1046),\n",
       "  (1321, 1046),\n",
       "  (1250, 1046),\n",
       "  (1179, 1046),\n",
       "  (1107, 1046),\n",
       "  (1036, 1046),\n",
       "  (965, 1046),\n",
       "  (894, 1046),\n",
       "  (822, 1046),\n",
       "  (749, 1046),\n",
       "  (678, 1046),\n",
       "  (607, 1046),\n",
       "  (536, 1046),\n",
       "  (465, 1046),\n",
       "  (391, 1046),\n",
       "  (99, 1046),\n",
       "  (1613, 1020),\n",
       "  (1505, 1020),\n",
       "  (1321, 1020),\n",
       "  (1107, 1020),\n",
       "  (391, 1020),\n",
       "  (99, 1020),\n",
       "  (1613, 995),\n",
       "  (1505, 995),\n",
       "  (1321, 995),\n",
       "  (1107, 995),\n",
       "  (391, 995),\n",
       "  (99, 995),\n",
       "  (1613, 944),\n",
       "  (1505, 944),\n",
       "  (1321, 944),\n",
       "  (1107, 944),\n",
       "  (391, 944),\n",
       "  (99, 944),\n",
       "  (41, 944)],\n",
       " (40, 2043, 1611, 1538): [(1608, 2041),\n",
       "  (1515, 2041),\n",
       "  (1456, 2041),\n",
       "  (1390, 2041),\n",
       "  (1324, 2041),\n",
       "  (1235, 2041),\n",
       "  (1150, 2041),\n",
       "  (1085, 2041),\n",
       "  (1027, 2041),\n",
       "  (969, 2041),\n",
       "  (910, 2041),\n",
       "  (852, 2041),\n",
       "  (794, 2041),\n",
       "  (736, 2041),\n",
       "  (678, 2041),\n",
       "  (618, 2041),\n",
       "  (560, 2041),\n",
       "  (502, 2041),\n",
       "  (444, 2041),\n",
       "  (386, 2041),\n",
       "  (326, 2041),\n",
       "  (88, 2041),\n",
       "  (41, 2041),\n",
       "  (1608, 2008),\n",
       "  (1515, 2008),\n",
       "  (1456, 2008),\n",
       "  (1390, 2008),\n",
       "  (1324, 2008),\n",
       "  (1235, 2008),\n",
       "  (1150, 2008),\n",
       "  (1085, 2008),\n",
       "  (1027, 2008),\n",
       "  (969, 2008),\n",
       "  (910, 2008),\n",
       "  (852, 2008),\n",
       "  (794, 2008),\n",
       "  (736, 2008),\n",
       "  (678, 2008),\n",
       "  (618, 2008),\n",
       "  (560, 2008),\n",
       "  (502, 2008),\n",
       "  (444, 2008),\n",
       "  (386, 2008),\n",
       "  (326, 2008),\n",
       "  (89, 2008),\n",
       "  (1608, 1987),\n",
       "  (1515, 1987),\n",
       "  (1456, 1987),\n",
       "  (1390, 1987),\n",
       "  (1324, 1987),\n",
       "  (1235, 1987),\n",
       "  (1150, 1987),\n",
       "  (1085, 1987),\n",
       "  (1027, 1987),\n",
       "  (969, 1987),\n",
       "  (910, 1987),\n",
       "  (852, 1987),\n",
       "  (794, 1987),\n",
       "  (736, 1987),\n",
       "  (678, 1987),\n",
       "  (618, 1987),\n",
       "  (560, 1987),\n",
       "  (502, 1987),\n",
       "  (444, 1987),\n",
       "  (386, 1987),\n",
       "  (326, 1987),\n",
       "  (89, 1987),\n",
       "  (1608, 1967),\n",
       "  (1515, 1967),\n",
       "  (1456, 1967),\n",
       "  (1390, 1967),\n",
       "  (1324, 1967),\n",
       "  (1235, 1967),\n",
       "  (1150, 1967),\n",
       "  (1085, 1967),\n",
       "  (1027, 1967),\n",
       "  (969, 1967),\n",
       "  (910, 1967),\n",
       "  (852, 1967),\n",
       "  (794, 1967),\n",
       "  (736, 1967),\n",
       "  (678, 1967),\n",
       "  (618, 1967),\n",
       "  (560, 1967),\n",
       "  (502, 1967),\n",
       "  (444, 1967),\n",
       "  (386, 1967),\n",
       "  (326, 1967),\n",
       "  (89, 1967),\n",
       "  (1608, 1946),\n",
       "  (1515, 1946),\n",
       "  (1456, 1946),\n",
       "  (1390, 1946),\n",
       "  (1324, 1946),\n",
       "  (1235, 1946),\n",
       "  (1150, 1946),\n",
       "  (1085, 1946),\n",
       "  (1027, 1946),\n",
       "  (969, 1946),\n",
       "  (910, 1946),\n",
       "  (852, 1946),\n",
       "  (794, 1946),\n",
       "  (736, 1946),\n",
       "  (678, 1946),\n",
       "  (618, 1946),\n",
       "  (560, 1946),\n",
       "  (502, 1946),\n",
       "  (444, 1946),\n",
       "  (386, 1946),\n",
       "  (326, 1946),\n",
       "  (89, 1946),\n",
       "  (1608, 1925),\n",
       "  (1515, 1925),\n",
       "  (1456, 1925),\n",
       "  (1390, 1925),\n",
       "  (1324, 1925),\n",
       "  (1235, 1925),\n",
       "  (1150, 1925),\n",
       "  (1085, 1925),\n",
       "  (1027, 1925),\n",
       "  (969, 1925),\n",
       "  (910, 1925),\n",
       "  (852, 1925),\n",
       "  (794, 1925),\n",
       "  (736, 1925),\n",
       "  (678, 1925),\n",
       "  (618, 1925),\n",
       "  (560, 1925),\n",
       "  (502, 1925),\n",
       "  (444, 1925),\n",
       "  (386, 1925),\n",
       "  (326, 1925),\n",
       "  (89, 1925),\n",
       "  (1608, 1904),\n",
       "  (1515, 1904),\n",
       "  (1456, 1904),\n",
       "  (1390, 1904),\n",
       "  (1324, 1904),\n",
       "  (1235, 1904),\n",
       "  (1150, 1904),\n",
       "  (1085, 1904),\n",
       "  (1027, 1904),\n",
       "  (969, 1904),\n",
       "  (910, 1904),\n",
       "  (852, 1904),\n",
       "  (794, 1904),\n",
       "  (736, 1904),\n",
       "  (678, 1904),\n",
       "  (618, 1904),\n",
       "  (560, 1904),\n",
       "  (502, 1904),\n",
       "  (444, 1904),\n",
       "  (386, 1904),\n",
       "  (326, 1904),\n",
       "  (89, 1904),\n",
       "  (1608, 1884),\n",
       "  (1515, 1884),\n",
       "  (1456, 1884),\n",
       "  (1390, 1884),\n",
       "  (1324, 1884),\n",
       "  (1235, 1884),\n",
       "  (1150, 1884),\n",
       "  (1085, 1884),\n",
       "  (1027, 1884),\n",
       "  (969, 1884),\n",
       "  (910, 1884),\n",
       "  (852, 1884),\n",
       "  (794, 1884),\n",
       "  (736, 1884),\n",
       "  (678, 1884),\n",
       "  (618, 1884),\n",
       "  (560, 1884),\n",
       "  (502, 1884),\n",
       "  (444, 1884),\n",
       "  (386, 1884),\n",
       "  (326, 1884),\n",
       "  (89, 1884),\n",
       "  (1608, 1863),\n",
       "  (1515, 1863),\n",
       "  (1456, 1863),\n",
       "  (1390, 1863),\n",
       "  (1324, 1863),\n",
       "  (1235, 1863),\n",
       "  (1150, 1863),\n",
       "  (1085, 1863),\n",
       "  (1027, 1863),\n",
       "  (969, 1863),\n",
       "  (910, 1863),\n",
       "  (852, 1863),\n",
       "  (794, 1863),\n",
       "  (736, 1863),\n",
       "  (678, 1863),\n",
       "  (618, 1863),\n",
       "  (560, 1863),\n",
       "  (502, 1863),\n",
       "  (444, 1863),\n",
       "  (386, 1863),\n",
       "  (326, 1863),\n",
       "  (89, 1863),\n",
       "  (1608, 1842),\n",
       "  (1515, 1842),\n",
       "  (1456, 1842),\n",
       "  (1390, 1842),\n",
       "  (1324, 1842),\n",
       "  (1235, 1842),\n",
       "  (1150, 1842),\n",
       "  (1085, 1842),\n",
       "  (1027, 1842),\n",
       "  (969, 1842),\n",
       "  (910, 1842),\n",
       "  (852, 1842),\n",
       "  (794, 1842),\n",
       "  (736, 1842),\n",
       "  (678, 1842),\n",
       "  (618, 1842),\n",
       "  (560, 1842),\n",
       "  (502, 1842),\n",
       "  (444, 1842),\n",
       "  (386, 1842),\n",
       "  (326, 1842),\n",
       "  (89, 1842),\n",
       "  (1608, 1821),\n",
       "  (1515, 1821),\n",
       "  (1456, 1821),\n",
       "  (1390, 1821),\n",
       "  (1324, 1821),\n",
       "  (1235, 1821),\n",
       "  (1150, 1821),\n",
       "  (1085, 1821),\n",
       "  (1027, 1821),\n",
       "  (969, 1821),\n",
       "  (910, 1821),\n",
       "  (852, 1821),\n",
       "  (794, 1821),\n",
       "  (736, 1821),\n",
       "  (678, 1821),\n",
       "  (618, 1821),\n",
       "  (560, 1821),\n",
       "  (502, 1821),\n",
       "  (444, 1821),\n",
       "  (386, 1821),\n",
       "  (326, 1821),\n",
       "  (89, 1821),\n",
       "  (1608, 1800),\n",
       "  (1515, 1800),\n",
       "  (1456, 1800),\n",
       "  (1390, 1800),\n",
       "  (1324, 1800),\n",
       "  (1235, 1800),\n",
       "  (1150, 1800),\n",
       "  (1085, 1800),\n",
       "  (1027, 1800),\n",
       "  (969, 1800),\n",
       "  (910, 1800),\n",
       "  (852, 1800),\n",
       "  (794, 1800),\n",
       "  (736, 1800),\n",
       "  (678, 1800),\n",
       "  (618, 1800),\n",
       "  (560, 1800),\n",
       "  (502, 1800),\n",
       "  (444, 1800),\n",
       "  (386, 1800),\n",
       "  (326, 1800),\n",
       "  (89, 1800),\n",
       "  (1608, 1780),\n",
       "  (1515, 1780),\n",
       "  (1456, 1780),\n",
       "  (1390, 1780),\n",
       "  (1324, 1780),\n",
       "  (1235, 1780),\n",
       "  (1150, 1780),\n",
       "  (1085, 1780),\n",
       "  (1027, 1780),\n",
       "  (969, 1780),\n",
       "  (910, 1780),\n",
       "  (852, 1780),\n",
       "  (794, 1780),\n",
       "  (736, 1780),\n",
       "  (678, 1780),\n",
       "  (618, 1780),\n",
       "  (560, 1780),\n",
       "  (502, 1780),\n",
       "  (444, 1780),\n",
       "  (386, 1780),\n",
       "  (326, 1780),\n",
       "  (89, 1780),\n",
       "  (1608, 1759),\n",
       "  (1515, 1759),\n",
       "  (1456, 1759),\n",
       "  (1390, 1759),\n",
       "  (1324, 1759),\n",
       "  (1235, 1759),\n",
       "  (1150, 1759),\n",
       "  (1085, 1759),\n",
       "  (1027, 1759),\n",
       "  (969, 1759),\n",
       "  (910, 1759),\n",
       "  (852, 1759),\n",
       "  (794, 1759),\n",
       "  (736, 1759),\n",
       "  (678, 1759),\n",
       "  (618, 1759),\n",
       "  (560, 1759),\n",
       "  (502, 1759),\n",
       "  (444, 1759),\n",
       "  (386, 1759),\n",
       "  (326, 1759),\n",
       "  (89, 1759),\n",
       "  (1608, 1738),\n",
       "  (1515, 1738),\n",
       "  (1456, 1738),\n",
       "  (1390, 1738),\n",
       "  (1324, 1738),\n",
       "  (1235, 1738),\n",
       "  (1150, 1738),\n",
       "  (1085, 1738),\n",
       "  (1027, 1738),\n",
       "  (969, 1738),\n",
       "  (910, 1738),\n",
       "  (852, 1738),\n",
       "  (794, 1738),\n",
       "  (736, 1738),\n",
       "  (678, 1738),\n",
       "  (618, 1738),\n",
       "  (560, 1738),\n",
       "  (502, 1738),\n",
       "  (444, 1738),\n",
       "  (386, 1738),\n",
       "  (326, 1738),\n",
       "  (89, 1738),\n",
       "  (1608, 1717),\n",
       "  (1515, 1717),\n",
       "  (1456, 1717),\n",
       "  (1390, 1717),\n",
       "  (1324, 1717),\n",
       "  (1235, 1717),\n",
       "  (1150, 1717),\n",
       "  (1085, 1717),\n",
       "  (1027, 1717),\n",
       "  (969, 1717),\n",
       "  (910, 1717),\n",
       "  (852, 1717),\n",
       "  (794, 1717),\n",
       "  (736, 1717),\n",
       "  (678, 1717),\n",
       "  (618, 1717),\n",
       "  (560, 1717),\n",
       "  (502, 1717),\n",
       "  (444, 1717),\n",
       "  (386, 1717),\n",
       "  (326, 1717),\n",
       "  (89, 1717),\n",
       "  (1608, 1697),\n",
       "  (1515, 1697),\n",
       "  (1456, 1697),\n",
       "  (1390, 1697),\n",
       "  (1324, 1697),\n",
       "  (1235, 1697),\n",
       "  (1150, 1697),\n",
       "  (1085, 1697),\n",
       "  (1027, 1697),\n",
       "  (969, 1697),\n",
       "  (910, 1697),\n",
       "  (852, 1697),\n",
       "  (794, 1697),\n",
       "  (736, 1697),\n",
       "  (678, 1697),\n",
       "  (618, 1697),\n",
       "  (560, 1697),\n",
       "  (502, 1697),\n",
       "  (444, 1697),\n",
       "  (386, 1697),\n",
       "  (326, 1697),\n",
       "  (89, 1697),\n",
       "  (1608, 1676),\n",
       "  (1515, 1676),\n",
       "  (1456, 1676),\n",
       "  (1390, 1676),\n",
       "  (1324, 1676),\n",
       "  (1235, 1676),\n",
       "  (1150, 1676),\n",
       "  (1085, 1676),\n",
       "  (1027, 1676),\n",
       "  (969, 1676),\n",
       "  (910, 1676),\n",
       "  (852, 1676),\n",
       "  (794, 1676),\n",
       "  (736, 1676),\n",
       "  (678, 1676),\n",
       "  (618, 1676),\n",
       "  (560, 1676),\n",
       "  (502, 1676),\n",
       "  (444, 1676),\n",
       "  (386, 1676),\n",
       "  (326, 1676),\n",
       "  (89, 1676),\n",
       "  (1608, 1655),\n",
       "  (1515, 1655),\n",
       "  (1456, 1655),\n",
       "  (1390, 1655),\n",
       "  (1324, 1655),\n",
       "  (1235, 1655),\n",
       "  (1150, 1655),\n",
       "  (1085, 1655),\n",
       "  (1027, 1655),\n",
       "  (969, 1655),\n",
       "  (910, 1655),\n",
       "  (852, 1655),\n",
       "  (794, 1655),\n",
       "  (736, 1655),\n",
       "  (678, 1655),\n",
       "  (618, 1655),\n",
       "  (560, 1655),\n",
       "  (502, 1655),\n",
       "  (444, 1655),\n",
       "  (386, 1655),\n",
       "  (326, 1655),\n",
       "  (89, 1655),\n",
       "  (1608, 1634),\n",
       "  (1515, 1634),\n",
       "  (1456, 1634),\n",
       "  (1390, 1634),\n",
       "  (1324, 1634),\n",
       "  (1235, 1634),\n",
       "  (1150, 1634),\n",
       "  (1085, 1634),\n",
       "  (1027, 1634),\n",
       "  (969, 1634),\n",
       "  (910, 1634),\n",
       "  (852, 1634),\n",
       "  (794, 1634),\n",
       "  (736, 1634),\n",
       "  (678, 1634),\n",
       "  (618, 1634),\n",
       "  (560, 1634),\n",
       "  (502, 1634),\n",
       "  (444, 1634),\n",
       "  (386, 1634),\n",
       "  (326, 1634),\n",
       "  (88, 1634),\n",
       "  (41, 1634),\n",
       "  (1608, 1613),\n",
       "  (1515, 1613),\n",
       "  (1324, 1613),\n",
       "  (1235, 1613),\n",
       "  (1085, 1613),\n",
       "  (910, 1613),\n",
       "  (326, 1613),\n",
       "  (89, 1613),\n",
       "  (1608, 1593),\n",
       "  (1515, 1593),\n",
       "  (1324, 1593),\n",
       "  (1235, 1593),\n",
       "  (1085, 1593),\n",
       "  (910, 1593),\n",
       "  (326, 1593),\n",
       "  (89, 1593),\n",
       "  (1608, 1539),\n",
       "  (1515, 1539),\n",
       "  (1324, 1539),\n",
       "  (1235, 1539),\n",
       "  (1085, 1539),\n",
       "  (910, 1539),\n",
       "  (326, 1539),\n",
       "  (89, 1539)],\n",
       " (40, 851, 1619, 475): [(1616, 849),\n",
       "  (1508, 849),\n",
       "  (1403, 849),\n",
       "  (1323, 849),\n",
       "  (1252, 849),\n",
       "  (1181, 849),\n",
       "  (1108, 849),\n",
       "  (1037, 849),\n",
       "  (966, 849),\n",
       "  (895, 849),\n",
       "  (824, 849),\n",
       "  (750, 849),\n",
       "  (679, 849),\n",
       "  (608, 849),\n",
       "  (537, 849),\n",
       "  (465, 849),\n",
       "  (392, 849),\n",
       "  (99, 849),\n",
       "  (41, 849),\n",
       "  (1616, 808),\n",
       "  (1508, 808),\n",
       "  (1403, 808),\n",
       "  (1323, 808),\n",
       "  (1252, 808),\n",
       "  (1181, 808),\n",
       "  (1108, 808),\n",
       "  (1037, 808),\n",
       "  (966, 808),\n",
       "  (895, 808),\n",
       "  (824, 808),\n",
       "  (750, 808),\n",
       "  (679, 808),\n",
       "  (608, 808),\n",
       "  (537, 808),\n",
       "  (465, 808),\n",
       "  (392, 808),\n",
       "  (100, 808),\n",
       "  (1616, 783),\n",
       "  (1508, 783),\n",
       "  (1403, 783),\n",
       "  (1323, 783),\n",
       "  (1252, 783),\n",
       "  (1181, 783),\n",
       "  (1108, 783),\n",
       "  (1037, 783),\n",
       "  (966, 783),\n",
       "  (895, 783),\n",
       "  (824, 783),\n",
       "  (750, 783),\n",
       "  (679, 783),\n",
       "  (608, 783),\n",
       "  (537, 783),\n",
       "  (465, 783),\n",
       "  (392, 783),\n",
       "  (100, 783),\n",
       "  (1616, 757),\n",
       "  (1508, 757),\n",
       "  (1403, 757),\n",
       "  (1323, 757),\n",
       "  (1252, 757),\n",
       "  (1181, 757),\n",
       "  (1108, 757),\n",
       "  (1037, 757),\n",
       "  (966, 757),\n",
       "  (895, 757),\n",
       "  (824, 757),\n",
       "  (750, 757),\n",
       "  (679, 757),\n",
       "  (608, 757),\n",
       "  (537, 757),\n",
       "  (465, 757),\n",
       "  (392, 757),\n",
       "  (100, 757),\n",
       "  (1616, 732),\n",
       "  (1508, 732),\n",
       "  (1403, 732),\n",
       "  (1323, 732),\n",
       "  (1252, 732),\n",
       "  (1181, 732),\n",
       "  (1108, 732),\n",
       "  (1037, 732),\n",
       "  (966, 732),\n",
       "  (895, 732),\n",
       "  (824, 732),\n",
       "  (750, 732),\n",
       "  (679, 732),\n",
       "  (608, 732),\n",
       "  (537, 732),\n",
       "  (465, 732),\n",
       "  (392, 732),\n",
       "  (100, 732),\n",
       "  (1616, 706),\n",
       "  (1508, 706),\n",
       "  (1403, 706),\n",
       "  (1323, 706),\n",
       "  (1252, 706),\n",
       "  (1181, 706),\n",
       "  (1108, 706),\n",
       "  (1037, 706),\n",
       "  (966, 706),\n",
       "  (895, 706),\n",
       "  (824, 706),\n",
       "  (750, 706),\n",
       "  (679, 706),\n",
       "  (608, 706),\n",
       "  (537, 706),\n",
       "  (465, 706),\n",
       "  (392, 706),\n",
       "  (100, 706),\n",
       "  (1616, 681),\n",
       "  (1508, 681),\n",
       "  (1403, 681),\n",
       "  (1323, 681),\n",
       "  (1252, 681),\n",
       "  (1181, 681),\n",
       "  (1108, 681),\n",
       "  (1037, 681),\n",
       "  (966, 681),\n",
       "  (895, 681),\n",
       "  (824, 681),\n",
       "  (750, 681),\n",
       "  (679, 681),\n",
       "  (608, 681),\n",
       "  (537, 681),\n",
       "  (465, 681),\n",
       "  (392, 681),\n",
       "  (100, 681),\n",
       "  (1616, 655),\n",
       "  (1508, 655),\n",
       "  (1403, 655),\n",
       "  (1323, 655),\n",
       "  (1252, 655),\n",
       "  (1181, 655),\n",
       "  (1108, 655),\n",
       "  (1037, 655),\n",
       "  (966, 655),\n",
       "  (895, 655),\n",
       "  (824, 655),\n",
       "  (750, 655),\n",
       "  (679, 655),\n",
       "  (608, 655),\n",
       "  (537, 655),\n",
       "  (465, 655),\n",
       "  (392, 655),\n",
       "  (100, 655),\n",
       "  (1616, 630),\n",
       "  (1508, 630),\n",
       "  (1403, 630),\n",
       "  (1323, 630),\n",
       "  (1252, 630),\n",
       "  (1181, 630),\n",
       "  (1108, 630),\n",
       "  (1037, 630),\n",
       "  (966, 630),\n",
       "  (895, 630),\n",
       "  (824, 630),\n",
       "  (750, 630),\n",
       "  (679, 630),\n",
       "  (608, 630),\n",
       "  (537, 630),\n",
       "  (465, 630),\n",
       "  (392, 630),\n",
       "  (100, 630),\n",
       "  (1616, 604),\n",
       "  (1508, 604),\n",
       "  (1403, 604),\n",
       "  (1323, 604),\n",
       "  (1252, 604),\n",
       "  (1181, 604),\n",
       "  (1108, 604),\n",
       "  (1037, 604),\n",
       "  (966, 604),\n",
       "  (895, 604),\n",
       "  (824, 604),\n",
       "  (750, 604),\n",
       "  (679, 604),\n",
       "  (608, 604),\n",
       "  (537, 604),\n",
       "  (465, 604),\n",
       "  (392, 604),\n",
       "  (100, 604),\n",
       "  (1616, 578),\n",
       "  (1508, 578),\n",
       "  (1403, 578),\n",
       "  (1323, 578),\n",
       "  (1252, 578),\n",
       "  (1181, 578),\n",
       "  (1108, 578),\n",
       "  (1037, 578),\n",
       "  (966, 578),\n",
       "  (895, 578),\n",
       "  (824, 578),\n",
       "  (750, 578),\n",
       "  (679, 578),\n",
       "  (608, 578),\n",
       "  (537, 578),\n",
       "  (465, 578),\n",
       "  (392, 578),\n",
       "  (100, 578),\n",
       "  (1616, 553),\n",
       "  (1508, 553),\n",
       "  (1323, 553),\n",
       "  (1108, 553),\n",
       "  (392, 553),\n",
       "  (100, 553),\n",
       "  (1616, 527),\n",
       "  (1508, 527),\n",
       "  (1323, 527),\n",
       "  (1108, 527),\n",
       "  (392, 527),\n",
       "  (100, 527),\n",
       "  (1616, 476),\n",
       "  (1508, 476),\n",
       "  (1323, 476),\n",
       "  (1108, 476),\n",
       "  (392, 476),\n",
       "  (99, 476),\n",
       "  (41, 476)]}"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table_bbox "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "import copy\n",
    "def translate(x1, x2):\n",
    "    \"\"\"Translates x2 by x1.\n",
    "    Parameters\n",
    "    ----------\n",
    "    x1 : float\n",
    "    x2 : float\n",
    "    Returns\n",
    "    -------\n",
    "    x2 : float\n",
    "    \"\"\"\n",
    "    x2 += x1\n",
    "    return x2\n",
    "\n",
    "\n",
    "def scale(x, s):\n",
    "    \"\"\"Scales x by scaling factor s.\n",
    "    Parameters\n",
    "    ----------\n",
    "    x : float\n",
    "    s : float\n",
    "    Returns\n",
    "    -------\n",
    "    x : float\n",
    "    \"\"\"\n",
    "    x *= s\n",
    "    return x\n",
    "\n",
    "def scale_image(tables, v_segments, h_segments, factors):\n",
    "    \"\"\"Translates and scales image coordinate space to pdf\n",
    "    coordinate space.\n",
    "    Parameters\n",
    "    ----------\n",
    "    tables : dict\n",
    "        Dict with table boundaries as keys and list of intersections\n",
    "        in that boundary as value.\n",
    "    v_segments : list\n",
    "        List of vertical line segments.\n",
    "    h_segments : list\n",
    "        List of horizontal line segments.\n",
    "    factors : tuple\n",
    "        Tuple (scaling_factor_x, scaling_factor_y, img_y) where the\n",
    "        first two elements are scaling factors and img_y is height of\n",
    "        image.\n",
    "    Returns\n",
    "    -------\n",
    "    tables_new : dict\n",
    "    v_segments_new : dict\n",
    "    h_segments_new : dict\n",
    "    \"\"\"\n",
    "    scaling_factor_x, scaling_factor_y, img_y = factors\n",
    "    tables_new = {}\n",
    "    for k in tables.keys():\n",
    "        x1, y1, x2, y2 = k\n",
    "        x1 = scale(x1, scaling_factor_x)\n",
    "        y1 = scale(abs(translate(-img_y, y1)), scaling_factor_y)\n",
    "        x2 = scale(x2, scaling_factor_x)\n",
    "        y2 = scale(abs(translate(-img_y, y2)), scaling_factor_y)\n",
    "        j_x, j_y = zip(*tables[k])\n",
    "        j_x = [scale(j, scaling_factor_x) for j in j_x]\n",
    "        j_y = [scale(abs(translate(-img_y, j)), scaling_factor_y) for j in j_y]\n",
    "        joints = zip(j_x, j_y)\n",
    "        tables_new[(x1, y1, x2, y2)] = joints\n",
    "\n",
    "    v_segments_new = []\n",
    "    for v in v_segments:\n",
    "        x1, x2 = scale(v[0], scaling_factor_x), scale(v[2], scaling_factor_x)\n",
    "        y1, y2 = scale(abs(translate(-img_y, v[1])), scaling_factor_y), scale(\n",
    "            abs(translate(-img_y, v[3])), scaling_factor_y)\n",
    "        v_segments_new.append((x1, y1, x2, y2))\n",
    "\n",
    "    h_segments_new = []\n",
    "    for h in h_segments:\n",
    "        x1, x2 = scale(h[0], scaling_factor_x), scale(h[2], scaling_factor_x)\n",
    "        y1, y2 = scale(abs(translate(-img_y, h[1])), scaling_factor_y), scale(\n",
    "            abs(translate(-img_y, h[3])), scaling_factor_y)\n",
    "        h_segments_new.append((x1, y1, x2, y2))\n",
    "\n",
    "    return tables_new, v_segments_new, h_segments_new\n",
    "\n",
    "\n",
    "\n",
    "image_width =  image.shape[1]\n",
    "image_height =  image.shape[0]\n",
    "image_width_scaler = image_width / int(pdf_width)\n",
    "image_height_scaler = image_height / int(pdf_height)\n",
    "pdf_width_scaler =  pdf_width / int(image_width)\n",
    "pdf_height_scaler =  pdf_height / int(image_height)\n",
    "image_scalers = (image_width_scaler, image_height_scaler,  pdf_height)\n",
    "pdf_scalers = (pdf_width_scaler, pdf_height_scaler, image_height)\n",
    "\n",
    "table_bbox_unscaled = copy.deepcopy(table_bbox)\n",
    "table_bbox, vertical_segments, horizontal_segments = scale_image(table_bbox, vertical_segments, horizontal_segments, pdf_scalers)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{(40, 1446, 1616, 943): [(1613, 1444),\n",
       "  (1505, 1444),\n",
       "  (1401, 1444),\n",
       "  (1321, 1444),\n",
       "  (1250, 1444),\n",
       "  (1179, 1444),\n",
       "  (1107, 1444),\n",
       "  (1036, 1444),\n",
       "  (965, 1444),\n",
       "  (894, 1444),\n",
       "  (822, 1444),\n",
       "  (749, 1444),\n",
       "  (678, 1444),\n",
       "  (607, 1444),\n",
       "  (536, 1444),\n",
       "  (465, 1444),\n",
       "  (391, 1444),\n",
       "  (99, 1444),\n",
       "  (41, 1444),\n",
       "  (1613, 1403),\n",
       "  (1505, 1403),\n",
       "  (1401, 1403),\n",
       "  (1321, 1403),\n",
       "  (1250, 1403),\n",
       "  (1179, 1403),\n",
       "  (1107, 1403),\n",
       "  (1036, 1403),\n",
       "  (965, 1403),\n",
       "  (894, 1403),\n",
       "  (822, 1403),\n",
       "  (749, 1403),\n",
       "  (678, 1403),\n",
       "  (607, 1403),\n",
       "  (536, 1403),\n",
       "  (465, 1403),\n",
       "  (391, 1403),\n",
       "  (99, 1403),\n",
       "  (1613, 1378),\n",
       "  (1505, 1378),\n",
       "  (1401, 1378),\n",
       "  (1321, 1378),\n",
       "  (1250, 1378),\n",
       "  (1179, 1378),\n",
       "  (1107, 1378),\n",
       "  (1036, 1378),\n",
       "  (965, 1378),\n",
       "  (894, 1378),\n",
       "  (822, 1378),\n",
       "  (749, 1378),\n",
       "  (678, 1378),\n",
       "  (607, 1378),\n",
       "  (536, 1378),\n",
       "  (465, 1378),\n",
       "  (391, 1378),\n",
       "  (99, 1378),\n",
       "  (1613, 1352),\n",
       "  (1505, 1352),\n",
       "  (1401, 1352),\n",
       "  (1321, 1352),\n",
       "  (1250, 1352),\n",
       "  (1179, 1352),\n",
       "  (1107, 1352),\n",
       "  (1036, 1352),\n",
       "  (965, 1352),\n",
       "  (894, 1352),\n",
       "  (822, 1352),\n",
       "  (749, 1352),\n",
       "  (678, 1352),\n",
       "  (607, 1352),\n",
       "  (536, 1352),\n",
       "  (465, 1352),\n",
       "  (391, 1352),\n",
       "  (99, 1352),\n",
       "  (1613, 1327),\n",
       "  (1505, 1327),\n",
       "  (1401, 1327),\n",
       "  (1321, 1327),\n",
       "  (1250, 1327),\n",
       "  (1179, 1327),\n",
       "  (1107, 1327),\n",
       "  (1036, 1327),\n",
       "  (965, 1327),\n",
       "  (894, 1327),\n",
       "  (822, 1327),\n",
       "  (749, 1327),\n",
       "  (678, 1327),\n",
       "  (607, 1327),\n",
       "  (536, 1327),\n",
       "  (465, 1327),\n",
       "  (391, 1327),\n",
       "  (99, 1327),\n",
       "  (1613, 1301),\n",
       "  (1505, 1301),\n",
       "  (1401, 1301),\n",
       "  (1321, 1301),\n",
       "  (1250, 1301),\n",
       "  (1179, 1301),\n",
       "  (1107, 1301),\n",
       "  (1036, 1301),\n",
       "  (965, 1301),\n",
       "  (894, 1301),\n",
       "  (822, 1301),\n",
       "  (749, 1301),\n",
       "  (678, 1301),\n",
       "  (607, 1301),\n",
       "  (536, 1301),\n",
       "  (465, 1301),\n",
       "  (391, 1301),\n",
       "  (99, 1301),\n",
       "  (1613, 1276),\n",
       "  (1505, 1276),\n",
       "  (1401, 1276),\n",
       "  (1321, 1276),\n",
       "  (1250, 1276),\n",
       "  (1179, 1276),\n",
       "  (1107, 1276),\n",
       "  (1036, 1276),\n",
       "  (965, 1276),\n",
       "  (894, 1276),\n",
       "  (822, 1276),\n",
       "  (749, 1276),\n",
       "  (678, 1276),\n",
       "  (607, 1276),\n",
       "  (536, 1276),\n",
       "  (465, 1276),\n",
       "  (391, 1276),\n",
       "  (99, 1276),\n",
       "  (1613, 1250),\n",
       "  (1505, 1250),\n",
       "  (1401, 1250),\n",
       "  (1321, 1250),\n",
       "  (1250, 1250),\n",
       "  (1179, 1250),\n",
       "  (1107, 1250),\n",
       "  (1036, 1250),\n",
       "  (965, 1250),\n",
       "  (894, 1250),\n",
       "  (822, 1250),\n",
       "  (749, 1250),\n",
       "  (678, 1250),\n",
       "  (607, 1250),\n",
       "  (536, 1250),\n",
       "  (465, 1250),\n",
       "  (391, 1250),\n",
       "  (99, 1250),\n",
       "  (1613, 1225),\n",
       "  (1505, 1225),\n",
       "  (1401, 1225),\n",
       "  (1321, 1225),\n",
       "  (1250, 1225),\n",
       "  (1179, 1225),\n",
       "  (1107, 1225),\n",
       "  (1036, 1225),\n",
       "  (965, 1225),\n",
       "  (894, 1225),\n",
       "  (822, 1225),\n",
       "  (749, 1225),\n",
       "  (678, 1225),\n",
       "  (607, 1225),\n",
       "  (536, 1225),\n",
       "  (465, 1225),\n",
       "  (391, 1225),\n",
       "  (99, 1225),\n",
       "  (1613, 1199),\n",
       "  (1505, 1199),\n",
       "  (1401, 1199),\n",
       "  (1321, 1199),\n",
       "  (1250, 1199),\n",
       "  (1179, 1199),\n",
       "  (1107, 1199),\n",
       "  (1036, 1199),\n",
       "  (965, 1199),\n",
       "  (894, 1199),\n",
       "  (822, 1199),\n",
       "  (749, 1199),\n",
       "  (678, 1199),\n",
       "  (607, 1199),\n",
       "  (536, 1199),\n",
       "  (465, 1199),\n",
       "  (391, 1199),\n",
       "  (99, 1199),\n",
       "  (1613, 1174),\n",
       "  (1505, 1174),\n",
       "  (1401, 1174),\n",
       "  (1321, 1174),\n",
       "  (1250, 1174),\n",
       "  (1179, 1174),\n",
       "  (1107, 1174),\n",
       "  (1036, 1174),\n",
       "  (965, 1174),\n",
       "  (894, 1174),\n",
       "  (822, 1174),\n",
       "  (749, 1174),\n",
       "  (678, 1174),\n",
       "  (607, 1174),\n",
       "  (536, 1174),\n",
       "  (465, 1174),\n",
       "  (391, 1174),\n",
       "  (99, 1174),\n",
       "  (1613, 1148),\n",
       "  (1505, 1148),\n",
       "  (1401, 1148),\n",
       "  (1321, 1148),\n",
       "  (1250, 1148),\n",
       "  (1179, 1148),\n",
       "  (1107, 1148),\n",
       "  (1036, 1148),\n",
       "  (965, 1148),\n",
       "  (894, 1148),\n",
       "  (822, 1148),\n",
       "  (749, 1148),\n",
       "  (678, 1148),\n",
       "  (607, 1148),\n",
       "  (536, 1148),\n",
       "  (465, 1148),\n",
       "  (391, 1148),\n",
       "  (99, 1148),\n",
       "  (1613, 1123),\n",
       "  (1505, 1123),\n",
       "  (1401, 1123),\n",
       "  (1321, 1123),\n",
       "  (1250, 1123),\n",
       "  (1179, 1123),\n",
       "  (1107, 1123),\n",
       "  (1036, 1123),\n",
       "  (965, 1123),\n",
       "  (894, 1123),\n",
       "  (822, 1123),\n",
       "  (749, 1123),\n",
       "  (678, 1123),\n",
       "  (607, 1123),\n",
       "  (536, 1123),\n",
       "  (465, 1123),\n",
       "  (391, 1123),\n",
       "  (99, 1123),\n",
       "  (1613, 1097),\n",
       "  (1505, 1097),\n",
       "  (1401, 1097),\n",
       "  (1321, 1097),\n",
       "  (1250, 1097),\n",
       "  (1179, 1097),\n",
       "  (1107, 1097),\n",
       "  (1036, 1097),\n",
       "  (965, 1097),\n",
       "  (894, 1097),\n",
       "  (822, 1097),\n",
       "  (749, 1097),\n",
       "  (678, 1097),\n",
       "  (607, 1097),\n",
       "  (536, 1097),\n",
       "  (465, 1097),\n",
       "  (391, 1097),\n",
       "  (99, 1097),\n",
       "  (1613, 1072),\n",
       "  (1505, 1072),\n",
       "  (1401, 1072),\n",
       "  (1321, 1072),\n",
       "  (1250, 1072),\n",
       "  (1179, 1072),\n",
       "  (1107, 1072),\n",
       "  (1036, 1072),\n",
       "  (965, 1072),\n",
       "  (894, 1072),\n",
       "  (822, 1072),\n",
       "  (749, 1072),\n",
       "  (678, 1072),\n",
       "  (607, 1072),\n",
       "  (536, 1072),\n",
       "  (465, 1072),\n",
       "  (391, 1072),\n",
       "  (99, 1072),\n",
       "  (1613, 1046),\n",
       "  (1505, 1046),\n",
       "  (1401, 1046),\n",
       "  (1321, 1046),\n",
       "  (1250, 1046),\n",
       "  (1179, 1046),\n",
       "  (1107, 1046),\n",
       "  (1036, 1046),\n",
       "  (965, 1046),\n",
       "  (894, 1046),\n",
       "  (822, 1046),\n",
       "  (749, 1046),\n",
       "  (678, 1046),\n",
       "  (607, 1046),\n",
       "  (536, 1046),\n",
       "  (465, 1046),\n",
       "  (391, 1046),\n",
       "  (99, 1046),\n",
       "  (1613, 1020),\n",
       "  (1505, 1020),\n",
       "  (1321, 1020),\n",
       "  (1107, 1020),\n",
       "  (391, 1020),\n",
       "  (99, 1020),\n",
       "  (1613, 995),\n",
       "  (1505, 995),\n",
       "  (1321, 995),\n",
       "  (1107, 995),\n",
       "  (391, 995),\n",
       "  (99, 995),\n",
       "  (1613, 944),\n",
       "  (1505, 944),\n",
       "  (1321, 944),\n",
       "  (1107, 944),\n",
       "  (391, 944),\n",
       "  (99, 944),\n",
       "  (41, 944)],\n",
       " (40, 2043, 1611, 1538): [(1608, 2041),\n",
       "  (1515, 2041),\n",
       "  (1456, 2041),\n",
       "  (1390, 2041),\n",
       "  (1324, 2041),\n",
       "  (1235, 2041),\n",
       "  (1150, 2041),\n",
       "  (1085, 2041),\n",
       "  (1027, 2041),\n",
       "  (969, 2041),\n",
       "  (910, 2041),\n",
       "  (852, 2041),\n",
       "  (794, 2041),\n",
       "  (736, 2041),\n",
       "  (678, 2041),\n",
       "  (618, 2041),\n",
       "  (560, 2041),\n",
       "  (502, 2041),\n",
       "  (444, 2041),\n",
       "  (386, 2041),\n",
       "  (326, 2041),\n",
       "  (88, 2041),\n",
       "  (41, 2041),\n",
       "  (1608, 2008),\n",
       "  (1515, 2008),\n",
       "  (1456, 2008),\n",
       "  (1390, 2008),\n",
       "  (1324, 2008),\n",
       "  (1235, 2008),\n",
       "  (1150, 2008),\n",
       "  (1085, 2008),\n",
       "  (1027, 2008),\n",
       "  (969, 2008),\n",
       "  (910, 2008),\n",
       "  (852, 2008),\n",
       "  (794, 2008),\n",
       "  (736, 2008),\n",
       "  (678, 2008),\n",
       "  (618, 2008),\n",
       "  (560, 2008),\n",
       "  (502, 2008),\n",
       "  (444, 2008),\n",
       "  (386, 2008),\n",
       "  (326, 2008),\n",
       "  (89, 2008),\n",
       "  (1608, 1987),\n",
       "  (1515, 1987),\n",
       "  (1456, 1987),\n",
       "  (1390, 1987),\n",
       "  (1324, 1987),\n",
       "  (1235, 1987),\n",
       "  (1150, 1987),\n",
       "  (1085, 1987),\n",
       "  (1027, 1987),\n",
       "  (969, 1987),\n",
       "  (910, 1987),\n",
       "  (852, 1987),\n",
       "  (794, 1987),\n",
       "  (736, 1987),\n",
       "  (678, 1987),\n",
       "  (618, 1987),\n",
       "  (560, 1987),\n",
       "  (502, 1987),\n",
       "  (444, 1987),\n",
       "  (386, 1987),\n",
       "  (326, 1987),\n",
       "  (89, 1987),\n",
       "  (1608, 1967),\n",
       "  (1515, 1967),\n",
       "  (1456, 1967),\n",
       "  (1390, 1967),\n",
       "  (1324, 1967),\n",
       "  (1235, 1967),\n",
       "  (1150, 1967),\n",
       "  (1085, 1967),\n",
       "  (1027, 1967),\n",
       "  (969, 1967),\n",
       "  (910, 1967),\n",
       "  (852, 1967),\n",
       "  (794, 1967),\n",
       "  (736, 1967),\n",
       "  (678, 1967),\n",
       "  (618, 1967),\n",
       "  (560, 1967),\n",
       "  (502, 1967),\n",
       "  (444, 1967),\n",
       "  (386, 1967),\n",
       "  (326, 1967),\n",
       "  (89, 1967),\n",
       "  (1608, 1946),\n",
       "  (1515, 1946),\n",
       "  (1456, 1946),\n",
       "  (1390, 1946),\n",
       "  (1324, 1946),\n",
       "  (1235, 1946),\n",
       "  (1150, 1946),\n",
       "  (1085, 1946),\n",
       "  (1027, 1946),\n",
       "  (969, 1946),\n",
       "  (910, 1946),\n",
       "  (852, 1946),\n",
       "  (794, 1946),\n",
       "  (736, 1946),\n",
       "  (678, 1946),\n",
       "  (618, 1946),\n",
       "  (560, 1946),\n",
       "  (502, 1946),\n",
       "  (444, 1946),\n",
       "  (386, 1946),\n",
       "  (326, 1946),\n",
       "  (89, 1946),\n",
       "  (1608, 1925),\n",
       "  (1515, 1925),\n",
       "  (1456, 1925),\n",
       "  (1390, 1925),\n",
       "  (1324, 1925),\n",
       "  (1235, 1925),\n",
       "  (1150, 1925),\n",
       "  (1085, 1925),\n",
       "  (1027, 1925),\n",
       "  (969, 1925),\n",
       "  (910, 1925),\n",
       "  (852, 1925),\n",
       "  (794, 1925),\n",
       "  (736, 1925),\n",
       "  (678, 1925),\n",
       "  (618, 1925),\n",
       "  (560, 1925),\n",
       "  (502, 1925),\n",
       "  (444, 1925),\n",
       "  (386, 1925),\n",
       "  (326, 1925),\n",
       "  (89, 1925),\n",
       "  (1608, 1904),\n",
       "  (1515, 1904),\n",
       "  (1456, 1904),\n",
       "  (1390, 1904),\n",
       "  (1324, 1904),\n",
       "  (1235, 1904),\n",
       "  (1150, 1904),\n",
       "  (1085, 1904),\n",
       "  (1027, 1904),\n",
       "  (969, 1904),\n",
       "  (910, 1904),\n",
       "  (852, 1904),\n",
       "  (794, 1904),\n",
       "  (736, 1904),\n",
       "  (678, 1904),\n",
       "  (618, 1904),\n",
       "  (560, 1904),\n",
       "  (502, 1904),\n",
       "  (444, 1904),\n",
       "  (386, 1904),\n",
       "  (326, 1904),\n",
       "  (89, 1904),\n",
       "  (1608, 1884),\n",
       "  (1515, 1884),\n",
       "  (1456, 1884),\n",
       "  (1390, 1884),\n",
       "  (1324, 1884),\n",
       "  (1235, 1884),\n",
       "  (1150, 1884),\n",
       "  (1085, 1884),\n",
       "  (1027, 1884),\n",
       "  (969, 1884),\n",
       "  (910, 1884),\n",
       "  (852, 1884),\n",
       "  (794, 1884),\n",
       "  (736, 1884),\n",
       "  (678, 1884),\n",
       "  (618, 1884),\n",
       "  (560, 1884),\n",
       "  (502, 1884),\n",
       "  (444, 1884),\n",
       "  (386, 1884),\n",
       "  (326, 1884),\n",
       "  (89, 1884),\n",
       "  (1608, 1863),\n",
       "  (1515, 1863),\n",
       "  (1456, 1863),\n",
       "  (1390, 1863),\n",
       "  (1324, 1863),\n",
       "  (1235, 1863),\n",
       "  (1150, 1863),\n",
       "  (1085, 1863),\n",
       "  (1027, 1863),\n",
       "  (969, 1863),\n",
       "  (910, 1863),\n",
       "  (852, 1863),\n",
       "  (794, 1863),\n",
       "  (736, 1863),\n",
       "  (678, 1863),\n",
       "  (618, 1863),\n",
       "  (560, 1863),\n",
       "  (502, 1863),\n",
       "  (444, 1863),\n",
       "  (386, 1863),\n",
       "  (326, 1863),\n",
       "  (89, 1863),\n",
       "  (1608, 1842),\n",
       "  (1515, 1842),\n",
       "  (1456, 1842),\n",
       "  (1390, 1842),\n",
       "  (1324, 1842),\n",
       "  (1235, 1842),\n",
       "  (1150, 1842),\n",
       "  (1085, 1842),\n",
       "  (1027, 1842),\n",
       "  (969, 1842),\n",
       "  (910, 1842),\n",
       "  (852, 1842),\n",
       "  (794, 1842),\n",
       "  (736, 1842),\n",
       "  (678, 1842),\n",
       "  (618, 1842),\n",
       "  (560, 1842),\n",
       "  (502, 1842),\n",
       "  (444, 1842),\n",
       "  (386, 1842),\n",
       "  (326, 1842),\n",
       "  (89, 1842),\n",
       "  (1608, 1821),\n",
       "  (1515, 1821),\n",
       "  (1456, 1821),\n",
       "  (1390, 1821),\n",
       "  (1324, 1821),\n",
       "  (1235, 1821),\n",
       "  (1150, 1821),\n",
       "  (1085, 1821),\n",
       "  (1027, 1821),\n",
       "  (969, 1821),\n",
       "  (910, 1821),\n",
       "  (852, 1821),\n",
       "  (794, 1821),\n",
       "  (736, 1821),\n",
       "  (678, 1821),\n",
       "  (618, 1821),\n",
       "  (560, 1821),\n",
       "  (502, 1821),\n",
       "  (444, 1821),\n",
       "  (386, 1821),\n",
       "  (326, 1821),\n",
       "  (89, 1821),\n",
       "  (1608, 1800),\n",
       "  (1515, 1800),\n",
       "  (1456, 1800),\n",
       "  (1390, 1800),\n",
       "  (1324, 1800),\n",
       "  (1235, 1800),\n",
       "  (1150, 1800),\n",
       "  (1085, 1800),\n",
       "  (1027, 1800),\n",
       "  (969, 1800),\n",
       "  (910, 1800),\n",
       "  (852, 1800),\n",
       "  (794, 1800),\n",
       "  (736, 1800),\n",
       "  (678, 1800),\n",
       "  (618, 1800),\n",
       "  (560, 1800),\n",
       "  (502, 1800),\n",
       "  (444, 1800),\n",
       "  (386, 1800),\n",
       "  (326, 1800),\n",
       "  (89, 1800),\n",
       "  (1608, 1780),\n",
       "  (1515, 1780),\n",
       "  (1456, 1780),\n",
       "  (1390, 1780),\n",
       "  (1324, 1780),\n",
       "  (1235, 1780),\n",
       "  (1150, 1780),\n",
       "  (1085, 1780),\n",
       "  (1027, 1780),\n",
       "  (969, 1780),\n",
       "  (910, 1780),\n",
       "  (852, 1780),\n",
       "  (794, 1780),\n",
       "  (736, 1780),\n",
       "  (678, 1780),\n",
       "  (618, 1780),\n",
       "  (560, 1780),\n",
       "  (502, 1780),\n",
       "  (444, 1780),\n",
       "  (386, 1780),\n",
       "  (326, 1780),\n",
       "  (89, 1780),\n",
       "  (1608, 1759),\n",
       "  (1515, 1759),\n",
       "  (1456, 1759),\n",
       "  (1390, 1759),\n",
       "  (1324, 1759),\n",
       "  (1235, 1759),\n",
       "  (1150, 1759),\n",
       "  (1085, 1759),\n",
       "  (1027, 1759),\n",
       "  (969, 1759),\n",
       "  (910, 1759),\n",
       "  (852, 1759),\n",
       "  (794, 1759),\n",
       "  (736, 1759),\n",
       "  (678, 1759),\n",
       "  (618, 1759),\n",
       "  (560, 1759),\n",
       "  (502, 1759),\n",
       "  (444, 1759),\n",
       "  (386, 1759),\n",
       "  (326, 1759),\n",
       "  (89, 1759),\n",
       "  (1608, 1738),\n",
       "  (1515, 1738),\n",
       "  (1456, 1738),\n",
       "  (1390, 1738),\n",
       "  (1324, 1738),\n",
       "  (1235, 1738),\n",
       "  (1150, 1738),\n",
       "  (1085, 1738),\n",
       "  (1027, 1738),\n",
       "  (969, 1738),\n",
       "  (910, 1738),\n",
       "  (852, 1738),\n",
       "  (794, 1738),\n",
       "  (736, 1738),\n",
       "  (678, 1738),\n",
       "  (618, 1738),\n",
       "  (560, 1738),\n",
       "  (502, 1738),\n",
       "  (444, 1738),\n",
       "  (386, 1738),\n",
       "  (326, 1738),\n",
       "  (89, 1738),\n",
       "  (1608, 1717),\n",
       "  (1515, 1717),\n",
       "  (1456, 1717),\n",
       "  (1390, 1717),\n",
       "  (1324, 1717),\n",
       "  (1235, 1717),\n",
       "  (1150, 1717),\n",
       "  (1085, 1717),\n",
       "  (1027, 1717),\n",
       "  (969, 1717),\n",
       "  (910, 1717),\n",
       "  (852, 1717),\n",
       "  (794, 1717),\n",
       "  (736, 1717),\n",
       "  (678, 1717),\n",
       "  (618, 1717),\n",
       "  (560, 1717),\n",
       "  (502, 1717),\n",
       "  (444, 1717),\n",
       "  (386, 1717),\n",
       "  (326, 1717),\n",
       "  (89, 1717),\n",
       "  (1608, 1697),\n",
       "  (1515, 1697),\n",
       "  (1456, 1697),\n",
       "  (1390, 1697),\n",
       "  (1324, 1697),\n",
       "  (1235, 1697),\n",
       "  (1150, 1697),\n",
       "  (1085, 1697),\n",
       "  (1027, 1697),\n",
       "  (969, 1697),\n",
       "  (910, 1697),\n",
       "  (852, 1697),\n",
       "  (794, 1697),\n",
       "  (736, 1697),\n",
       "  (678, 1697),\n",
       "  (618, 1697),\n",
       "  (560, 1697),\n",
       "  (502, 1697),\n",
       "  (444, 1697),\n",
       "  (386, 1697),\n",
       "  (326, 1697),\n",
       "  (89, 1697),\n",
       "  (1608, 1676),\n",
       "  (1515, 1676),\n",
       "  (1456, 1676),\n",
       "  (1390, 1676),\n",
       "  (1324, 1676),\n",
       "  (1235, 1676),\n",
       "  (1150, 1676),\n",
       "  (1085, 1676),\n",
       "  (1027, 1676),\n",
       "  (969, 1676),\n",
       "  (910, 1676),\n",
       "  (852, 1676),\n",
       "  (794, 1676),\n",
       "  (736, 1676),\n",
       "  (678, 1676),\n",
       "  (618, 1676),\n",
       "  (560, 1676),\n",
       "  (502, 1676),\n",
       "  (444, 1676),\n",
       "  (386, 1676),\n",
       "  (326, 1676),\n",
       "  (89, 1676),\n",
       "  (1608, 1655),\n",
       "  (1515, 1655),\n",
       "  (1456, 1655),\n",
       "  (1390, 1655),\n",
       "  (1324, 1655),\n",
       "  (1235, 1655),\n",
       "  (1150, 1655),\n",
       "  (1085, 1655),\n",
       "  (1027, 1655),\n",
       "  (969, 1655),\n",
       "  (910, 1655),\n",
       "  (852, 1655),\n",
       "  (794, 1655),\n",
       "  (736, 1655),\n",
       "  (678, 1655),\n",
       "  (618, 1655),\n",
       "  (560, 1655),\n",
       "  (502, 1655),\n",
       "  (444, 1655),\n",
       "  (386, 1655),\n",
       "  (326, 1655),\n",
       "  (89, 1655),\n",
       "  (1608, 1634),\n",
       "  (1515, 1634),\n",
       "  (1456, 1634),\n",
       "  (1390, 1634),\n",
       "  (1324, 1634),\n",
       "  (1235, 1634),\n",
       "  (1150, 1634),\n",
       "  (1085, 1634),\n",
       "  (1027, 1634),\n",
       "  (969, 1634),\n",
       "  (910, 1634),\n",
       "  (852, 1634),\n",
       "  (794, 1634),\n",
       "  (736, 1634),\n",
       "  (678, 1634),\n",
       "  (618, 1634),\n",
       "  (560, 1634),\n",
       "  (502, 1634),\n",
       "  (444, 1634),\n",
       "  (386, 1634),\n",
       "  (326, 1634),\n",
       "  (88, 1634),\n",
       "  (41, 1634),\n",
       "  (1608, 1613),\n",
       "  (1515, 1613),\n",
       "  (1324, 1613),\n",
       "  (1235, 1613),\n",
       "  (1085, 1613),\n",
       "  (910, 1613),\n",
       "  (326, 1613),\n",
       "  (89, 1613),\n",
       "  (1608, 1593),\n",
       "  (1515, 1593),\n",
       "  (1324, 1593),\n",
       "  (1235, 1593),\n",
       "  (1085, 1593),\n",
       "  (910, 1593),\n",
       "  (326, 1593),\n",
       "  (89, 1593),\n",
       "  (1608, 1539),\n",
       "  (1515, 1539),\n",
       "  (1324, 1539),\n",
       "  (1235, 1539),\n",
       "  (1085, 1539),\n",
       "  (910, 1539),\n",
       "  (326, 1539),\n",
       "  (89, 1539)],\n",
       " (40, 851, 1619, 475): [(1616, 849),\n",
       "  (1508, 849),\n",
       "  (1403, 849),\n",
       "  (1323, 849),\n",
       "  (1252, 849),\n",
       "  (1181, 849),\n",
       "  (1108, 849),\n",
       "  (1037, 849),\n",
       "  (966, 849),\n",
       "  (895, 849),\n",
       "  (824, 849),\n",
       "  (750, 849),\n",
       "  (679, 849),\n",
       "  (608, 849),\n",
       "  (537, 849),\n",
       "  (465, 849),\n",
       "  (392, 849),\n",
       "  (99, 849),\n",
       "  (41, 849),\n",
       "  (1616, 808),\n",
       "  (1508, 808),\n",
       "  (1403, 808),\n",
       "  (1323, 808),\n",
       "  (1252, 808),\n",
       "  (1181, 808),\n",
       "  (1108, 808),\n",
       "  (1037, 808),\n",
       "  (966, 808),\n",
       "  (895, 808),\n",
       "  (824, 808),\n",
       "  (750, 808),\n",
       "  (679, 808),\n",
       "  (608, 808),\n",
       "  (537, 808),\n",
       "  (465, 808),\n",
       "  (392, 808),\n",
       "  (100, 808),\n",
       "  (1616, 783),\n",
       "  (1508, 783),\n",
       "  (1403, 783),\n",
       "  (1323, 783),\n",
       "  (1252, 783),\n",
       "  (1181, 783),\n",
       "  (1108, 783),\n",
       "  (1037, 783),\n",
       "  (966, 783),\n",
       "  (895, 783),\n",
       "  (824, 783),\n",
       "  (750, 783),\n",
       "  (679, 783),\n",
       "  (608, 783),\n",
       "  (537, 783),\n",
       "  (465, 783),\n",
       "  (392, 783),\n",
       "  (100, 783),\n",
       "  (1616, 757),\n",
       "  (1508, 757),\n",
       "  (1403, 757),\n",
       "  (1323, 757),\n",
       "  (1252, 757),\n",
       "  (1181, 757),\n",
       "  (1108, 757),\n",
       "  (1037, 757),\n",
       "  (966, 757),\n",
       "  (895, 757),\n",
       "  (824, 757),\n",
       "  (750, 757),\n",
       "  (679, 757),\n",
       "  (608, 757),\n",
       "  (537, 757),\n",
       "  (465, 757),\n",
       "  (392, 757),\n",
       "  (100, 757),\n",
       "  (1616, 732),\n",
       "  (1508, 732),\n",
       "  (1403, 732),\n",
       "  (1323, 732),\n",
       "  (1252, 732),\n",
       "  (1181, 732),\n",
       "  (1108, 732),\n",
       "  (1037, 732),\n",
       "  (966, 732),\n",
       "  (895, 732),\n",
       "  (824, 732),\n",
       "  (750, 732),\n",
       "  (679, 732),\n",
       "  (608, 732),\n",
       "  (537, 732),\n",
       "  (465, 732),\n",
       "  (392, 732),\n",
       "  (100, 732),\n",
       "  (1616, 706),\n",
       "  (1508, 706),\n",
       "  (1403, 706),\n",
       "  (1323, 706),\n",
       "  (1252, 706),\n",
       "  (1181, 706),\n",
       "  (1108, 706),\n",
       "  (1037, 706),\n",
       "  (966, 706),\n",
       "  (895, 706),\n",
       "  (824, 706),\n",
       "  (750, 706),\n",
       "  (679, 706),\n",
       "  (608, 706),\n",
       "  (537, 706),\n",
       "  (465, 706),\n",
       "  (392, 706),\n",
       "  (100, 706),\n",
       "  (1616, 681),\n",
       "  (1508, 681),\n",
       "  (1403, 681),\n",
       "  (1323, 681),\n",
       "  (1252, 681),\n",
       "  (1181, 681),\n",
       "  (1108, 681),\n",
       "  (1037, 681),\n",
       "  (966, 681),\n",
       "  (895, 681),\n",
       "  (824, 681),\n",
       "  (750, 681),\n",
       "  (679, 681),\n",
       "  (608, 681),\n",
       "  (537, 681),\n",
       "  (465, 681),\n",
       "  (392, 681),\n",
       "  (100, 681),\n",
       "  (1616, 655),\n",
       "  (1508, 655),\n",
       "  (1403, 655),\n",
       "  (1323, 655),\n",
       "  (1252, 655),\n",
       "  (1181, 655),\n",
       "  (1108, 655),\n",
       "  (1037, 655),\n",
       "  (966, 655),\n",
       "  (895, 655),\n",
       "  (824, 655),\n",
       "  (750, 655),\n",
       "  (679, 655),\n",
       "  (608, 655),\n",
       "  (537, 655),\n",
       "  (465, 655),\n",
       "  (392, 655),\n",
       "  (100, 655),\n",
       "  (1616, 630),\n",
       "  (1508, 630),\n",
       "  (1403, 630),\n",
       "  (1323, 630),\n",
       "  (1252, 630),\n",
       "  (1181, 630),\n",
       "  (1108, 630),\n",
       "  (1037, 630),\n",
       "  (966, 630),\n",
       "  (895, 630),\n",
       "  (824, 630),\n",
       "  (750, 630),\n",
       "  (679, 630),\n",
       "  (608, 630),\n",
       "  (537, 630),\n",
       "  (465, 630),\n",
       "  (392, 630),\n",
       "  (100, 630),\n",
       "  (1616, 604),\n",
       "  (1508, 604),\n",
       "  (1403, 604),\n",
       "  (1323, 604),\n",
       "  (1252, 604),\n",
       "  (1181, 604),\n",
       "  (1108, 604),\n",
       "  (1037, 604),\n",
       "  (966, 604),\n",
       "  (895, 604),\n",
       "  (824, 604),\n",
       "  (750, 604),\n",
       "  (679, 604),\n",
       "  (608, 604),\n",
       "  (537, 604),\n",
       "  (465, 604),\n",
       "  (392, 604),\n",
       "  (100, 604),\n",
       "  (1616, 578),\n",
       "  (1508, 578),\n",
       "  (1403, 578),\n",
       "  (1323, 578),\n",
       "  (1252, 578),\n",
       "  (1181, 578),\n",
       "  (1108, 578),\n",
       "  (1037, 578),\n",
       "  (966, 578),\n",
       "  (895, 578),\n",
       "  (824, 578),\n",
       "  (750, 578),\n",
       "  (679, 578),\n",
       "  (608, 578),\n",
       "  (537, 578),\n",
       "  (465, 578),\n",
       "  (392, 578),\n",
       "  (100, 578),\n",
       "  (1616, 553),\n",
       "  (1508, 553),\n",
       "  (1323, 553),\n",
       "  (1108, 553),\n",
       "  (392, 553),\n",
       "  (100, 553),\n",
       "  (1616, 527),\n",
       "  (1508, 527),\n",
       "  (1323, 527),\n",
       "  (1108, 527),\n",
       "  (392, 527),\n",
       "  (100, 527),\n",
       "  (1616, 476),\n",
       "  (1508, 476),\n",
       "  (1323, 476),\n",
       "  (1108, 476),\n",
       "  (392, 476),\n",
       "  (99, 476),\n",
       "  (41, 476)]}"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table_bbox_unscaled"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{(Decimal('14.39709794437726723095525998'),\n",
       "  Decimal('321.4341855493800769559640873'),\n",
       "  Decimal('581.6427569528415961305925030'),\n",
       "  Decimal('502.4883796494228302693458744')): <zip at 0x244b8831808>,\n",
       " (Decimal('14.39709794437726723095525998'),\n",
       "  Decimal('106.5448140230867892261650278'),\n",
       "  Decimal('579.8431197097944377267230955'),\n",
       "  Decimal('288.3189055151774262505344164')): <zip at 0x244b88318c8>,\n",
       " (Decimal('14.39709794437726723095525998'),\n",
       "  Decimal('535.6036596836254809747755452'),\n",
       "  Decimal('582.7225392986698911729141475'),\n",
       "  Decimal('670.9443693886276186404446345')): <zip at 0x244b8831e88>}"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table_bbox"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def extractMultipleTable(table_bbox):\n",
    "    allTables=[]\n",
    "    print(\"plusieurs tableau dans la page à detecter\")\n",
    "    i=0\n",
    "    for key1, y in table_bbox.items():\n",
    "        i+=1\n",
    "        print('tableau %d'%i)\n",
    "        x0=key1[0]\n",
    "        y0=key1[3]\n",
    "        x1=key1[2]\n",
    "        y1=key1[1]\n",
    "        tableRowTol2 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=2,flag_size=True,table_areas=['%d,%d,%d,%d'%(x0,y0,x1,y1)]) #methode1\n",
    "        tableRowTol4 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=4,flag_size=True,table_areas=['%d,%d,%d,%d'%(x0,y0,x1,y1)]) #methode1\n",
    "\n",
    "\n",
    "        if verifColumns(tableRowTol2[0].df)<verifColumns(tableRowTol4[0].df):    # dans ce cas df2 a plus de \\n donc les colonnes n'ont pas été bien éclaté avec row_tol=4\n",
    "            print(\"conserver row_tol =2\")\n",
    "            camelot.plot(tableRowTol2[0], kind='contour')\n",
    "            plt.show()\n",
    "            tableRowTol2[0].df.to_csv(os.path.join(OUTPUTPATH, 'tab%d_'%i+PDFfilename+OUTPUT_CSV), index=False)\n",
    "            tableRowTol2[0].df.to_excel(os.path.join(OUTPUTPATH, 'tab%d_'%i+PDFfilename+OUTPUT_XLSX), index=False)\n",
    "            finalDF=tableRowTol2[0].df\n",
    "            allTables.append(finalDF)\n",
    "\n",
    "\n",
    "\n",
    "        else:\n",
    "            print(\"conserver row_tol=4\")\n",
    "            camelot.plot(tableRowTol4[0], kind='contour')\n",
    "            plt.show()\n",
    "            tableRowTol4[0].df.to_csv(os.path.join(OUTPUTPATH, 'tab%d_'%i+PDFfilename+OUTPUT_CSV), index=False)\n",
    "            tableRowTol4[0].df.to_excel(os.path.join(OUTPUTPATH, 'tab%d_'%i+PDFfilename+OUTPUT_XLSX), index=False)\n",
    "            finalDF=tableRowTol4[0].df\n",
    "            allTables.append(finalDF)\n",
    "            \n",
    "    return allTables\n",
    "\n",
    "\n",
    "def extractOneTable(table_bbox,table_bbox_unscaled):\n",
    "    print(\"un seul tableau à detecter\")\n",
    "    for key1, y in table_bbox.items():\n",
    "        x0=key1[0]\n",
    "        y0=key1[3]\n",
    "        x1=key1[2]\n",
    "        y1=key1[1]\n",
    "\n",
    "    for key2, y in table_bbox_unscaled.items():\n",
    "        xx0=key2[0]\n",
    "        yy0=key2[1]\n",
    "        xx1=key2[2]\n",
    "        yy1=key2[3]\n",
    "    \n",
    "    tables1 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=4,flag_size=True,table_areas=['%d,%d,%d,%d'%(x0,y0,x1,y1)]) #methode1\n",
    "    #tables2 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=4,flag_size=True,table_areas=['%d,%d,%d,%d'%(xx0,yy0,xx1,yy1)]) #methode1\n",
    "\n",
    "    \n",
    "    #on verifie si on a besoin de corriger le decalage ou non\n",
    "\n",
    "    '''mask1=tables1[0].df.mask(tables1[0].df.apply(lambda x: x.str.contains('[a-zA-Z]')),'')\n",
    "    mask1.replace('', np.nan, inplace=True)\n",
    "    mask1.dropna(axis=0, how='all',inplace=True,thresh=2)\n",
    "    mask1.dropna(axis=1, how='all',inplace=True)\n",
    "  \n",
    "    mask2=tables2[0].df.mask(tables2[0].df.apply(lambda x: x.str.contains('[a-zA-Z]')),'')\n",
    "    mask2.replace('', np.nan, inplace=True)\n",
    "    mask2.dropna(axis=0, how='all',inplace=True,thresh=2)\n",
    "    mask2.dropna(axis=1, how='all',inplace=True)\n",
    "    \n",
    "    \n",
    " \n",
    "    \n",
    "    if len(mask1)> len(mask2):\n",
    "        print('conserver table1: apres correction de decalage')\n",
    "        choix=2\n",
    "        tableRowTol4=tables1\n",
    "        \n",
    "        \n",
    "    else:\n",
    "        print('conserver table2 :avant correction de decalage')\n",
    "        choix=1\n",
    "        tableRowTol4=tables2'''\n",
    "    \n",
    "    \n",
    "    tableRowTol4=tables1\n",
    "\n",
    "    \n",
    "\n",
    "    '''if choix==1:\n",
    "        tableRowTol2 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=2,flag_size=True,table_areas=['%d, %d, %d, %d'%(xx0,yy0,xx1,yy1)]) #methode1\n",
    "    else:\n",
    "        tableRowTol2 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=2,flag_size=True,table_areas=['%d, %d, %d, %d'%(x0,y0,x1,y1)]) #methode1\n",
    "\n",
    "    '''\n",
    "    tableRowTol2 = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=2,flag_size=True,table_areas=['%d, %d, %d, %d'%(x0,y0,x1,y1)]) #methode1\n",
    "\n",
    "\n",
    "    \n",
    "    if verifColumns(tableRowTol2[0].df)<verifColumns(tableRowTol4[0].df):    # dans ce cas df2 a plus de \\n donc les colonnes n'ont pas été bien éclaté avec row_tol=4\n",
    "        print(\"conserver row_tol =2\")\n",
    "        \n",
    "        camelot.plot(tableRowTol2[0], kind='contour')\n",
    "        plt.show()\n",
    "        tableRowTol2[0].df.to_csv(os.path.join(OUTPUTPATH, OUTPUT_CSV), index=False)\n",
    "        tableRowTol2[0].df.to_excel(os.path.join(OUTPUTPATH, OUTPUT_XLSX), index=False)\n",
    "        finalDF=tableRowTol2[0].df\n",
    "\n",
    "\n",
    "    else:\n",
    "        print(\"conserver row_tol=4\")\n",
    "        camelot.plot(tableRowTol4[0], kind='contour')\n",
    "        plt.show()\n",
    "        tableRowTol4[0].df.to_csv(os.path.join(OUTPUTPATH, PDFfilename+'_'+OUTPUT_CSV), index=False)\n",
    "        tableRowTol4[0].df.to_excel(os.path.join(OUTPUTPATH, PDFfilename+'_'+OUTPUT_XLSX), index=False)\n",
    "        finalDF=tableRowTol4[0].df\n",
    "    return finalDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "plusieurs tableau dans la page à detecter\n",
      "tableau 1\n",
      "conserver row_tol=4\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAMsAAAD8CAYAAADZhFAmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAGxRJREFUeJztnX/MX1V5wD8PraDiJhRq21ngxUgWzRKBNlqmWRzIImjcsmCGcUpIDUvEDaeL4v4pJMsGyyKGLAHRbkPDRIYaDWNjDWLikq1bKwx1SKisZR19X8pPszF12Gd/3HPb+357f5xz7rm/vt/nk9y8956fz7nf97nn93NEVTEMo5kThhbAMKaCKYtheGLKYhiemLIYhiemLIbhiSmLYXhiymIYnpiyGIYnpiyG4cnaoQUAOP3003VpaWloMYwFZO/evU+r6nqfsF7KIiK/D3wIUOC7wJXAJuBOYB3wHeADqvpTETkJ+AKwBXgG+C1V3V+X/tLSEnv27PERxTCSIiIHfMM2NsNE5LXA7wFbVfWXgDXA5cCNwE2qeg7wHLDdRdkOPKeqrwducuEMY/L49lnWAq8QkbXAK4FDwIXA3c7/duA33P2vu2ec/0UiImnEbcfGjdllGDE0Kouq/hfwZ8ATZEryArAXeF5VX3LBDgKvdfevBf7TxX3JhT9tNl0RuUpE9ojInsOHD7cthxcrK9mVmo0bQST+yhW4bTq++QyFT/nqZMzjD1UOn2bYqWS1xdnALwAnA5eUBM3X+pfVIsftA1DV21R1q6puXb/eq3/Vmg0bsis1bRUwj9+FIpflMxQ++deF6es9VeHTDHsH8B+qelhV/w/4KvDLwCmuWQawGXjS3R8EzgBw/q8Gnk0qdSTLy9mVmrYKmMfvQpHL8hkKn/zrwvT1nqrwGQ17AtgmIq8E/he4CNgDPABcRjYidgXwdRf+G+75n5z/N3XOd5ilUsAuFHlMtC3f0O/Hp8+ym6yj/h2yYeMTgNuATwIfE5F9ZH2SnS7KTuA05/4x4NoO5DaM3pExfPS3bt2qNs9iDIGI7FXVrT5hbblLR4SMbPU1GjamUbKqshZl8X0ffclvytIRISM2Q4/yDJFvVZ5Fd1+5+pLflMUwPDFlCcR3FUDI8ObQQ6JD5FuVZ9HdV66+5B/FquMp4VvlxwxzDj002ic+ZR3b+zBlCWToiT1jOCbXDLvuumHz72oVgDF+Jqcs118/tATGojI5ZTGMoZicsuzYMbQExqIyOWW59dZhZrnHeA29P2XRmJyyDL0nY0zYu+iXySmLYQyFKYtheDI5ZbFJwWPYu+iXyc3g24SgMRSTq1kMYyhMWQzDEx9TSL8oIg8Vrh+JyEdFZJ2I7BKRx9zfU114EZGbRWSfiDwsIud3XwzD6B4fgxWPquq5qnoumf3iF4GvkRmiuN+Zb72fY4YpLgHOcddVwC0pBS7bahqzFXURL5vEbEdoM+wi4IeqeoDVZlpvZ7X51i9oxj+T2RfblERayifiYraiLiL2btoRqiyXA19y9xtU9RCA+/sa537UfKujaNr1KEOYbzWMNngri4icCLwH+JumoCVuycy3ls0txGxFXUTs3bQjZJ7lEuA7qppX5isisklVD7lm1lPO/aj5VkfRtGtrmuZZbB7G6IqQZtj7ONYEg2NmWuF4860fdKNi24AX8uaaYUwZ35O/XglcDPxOwfkG4C4R2U5mD/m9zv1e4FJgH9nI2ZXJpDWMAfFSFlV9kZkzVlT1GbLRsdmwClwdK1A+vGnNKWNsjG5tmA1vGmPFlrsYhiejq1lseNMYK6OrWarscnWxjGWsyz+GPjtxHvCx0h/K6JSlii76Mr5p1v3zduFXZ1XfJ80y/7J4Icc+hJRhNt26PH3kbJK3LLyPlf5QJnOY0Zo1cORI2nw3bPAbdZPCmoTZ15XSb+PG43/MWRl905z1L4s3G74sbkz5ytKty7NJzrp0q9Kp+n854QT42c+Kac7hYUahiqLafPkOT9dZuU/p17RI1DfNMv+yeCGW7EPKV/fsG7apfE1+Vf8vbT64k6lZyr66VfjWGGPDp2Yx/Kj6fzm+pp54zdK2g7uykq5jF9v+jvFbXq7/evYpy9j8QsKUvcsNG8JaE2WMsmYJbV/7ElPU2Pa3+aX1y/EJUxW2LNzka5Yi+dej7fxLbPzY9rf5pfULCeOTdgyjVxZIM2ycsmlmLCaTUBbDGAOmLA0sL1cPNxc7kbOjLLHx2shZ1dRokjPGL4WcdfnVxY8Z/l9Zad+SGH0Hv2vaFr9uEi0mXqoJvTq/FBOrfU08tvl9/AYM5qiDn9PFAssUacYey93lhF6dX6qJ1T4mHlMP6rRNbzLK0pZ8nD2mCq+iOPEVUs3HxvNNMzberCxdy1lMM58/mTVrFboGriyfpvR8WRhlMYy2eCmLiJwiIneLyA9E5BERucDMtxoLh6o2XmQWJz/k7k8ETgH+FLjWuV0L3OjuLwX+DhBgG7C7Kf0tW7ZoEb9lkOFXamLzqIvXhd+s/5CyVPmF/G4+79w3PWCPeuiAqnoZBv954FeAnU65fqqqz9Oz+dahZvBD0vTNY4jZ79Qd9dR+PiugfdKLdffBpxn2OuAw8Jci8qCIfF5EToZ25lv7xmbwjbb4KMta4HzgFlU9D/gfjlnML6NsluS40XKzdWxMDR9lOQgcVNXd7vluMuVZyZtXMeZbNdLWcSxdDB0b6fCZvR8arxl8Efk2WQf/URG5DjjZeT2jqjeIyLXAOlX9hIi8C/gIWUf/LcDNqvrmuvT7msH3KGoQIcvFfeN1tbw99Ux8X36z8paFK3vnPlums3DpZ/B/F7hDRB4GzgX+mMx868Ui8hiZadcbXNh7gcfJzLd+DviwZx61WAd/vjv4ZX4+bn128H3Ntz4ElGlfcvOtXZF38FMtCOyK5eVjs88hshbjTZEpyG4z+IbhiSlLA757vlPFg2PL0ENqwNgvcxdbEGII6eAX8w7Jt22rYiGX6IcUeai95illmfWPLb9vvK47+LEylKVlS/QTpjPUXvOUshSfU20l8IlT9pyigx8jQ5u0ciahLClHsspm8sc0q1/VfGuz5LxpGX5VfsUl8/l727ix3uxrF0vjZ8sS+5vN/RJ9mzw0xsLojpwYgrEPJxvjYJQd/LJ5hqE6/WOYxVZtnpHuM79YYuQs+vuGqQt3fHoT7+CXDZ12uW6oLu2hZ7F9l7D3mV+sX6gsTeFD3ercfRilsvRNsdM/2wHswhxQHVX5lc1DNPl3lV+Tn+rqNIsfvrbvs8yGcchpCHM3z1LGkOaR+lyEGJtfmf9Qiyzr0gzNryl+mX9YWhNvhpXR1/Ltuiq9j0WIsfnV5dH3Isu6NEPy83ELaW61/R+aTM1iGF0w6Zoln9gyjLExunmWsS/TNhaX0dUshjFWTFkMwxNTFsPwxNd8634R+a6IPCQie5ybmW81FoqQmuVXVfXcwjDbtcD9qnoOcD/HbIldApzjrquAW1IJaxhD0qYZ1qv5VsMYGt+hYwX+QUQU+Kyq3garzbeKSJP51kM+GT1xwhJnHDlQbtfSMFJx1lmwf39QFF9leauqPukUYpeI/KAmrLf5VrJmGmeeeeZR9zOOHChd7NOFqZyx7mOJMYVkBBKx2NCrGaaqT7q/TwFfA97MxMy3tiHfylp3ClVKvxhZmk7DKotXtz24GCb09C1fvzr/pjyrZK4L03bruM+REyeLyM/l98CvAd8DvgFc4YJdAXzd3X8D+KAbFdsGvJA31/oiXxbedI3tq122792W/owHn2bYBuBrklVba4G/VtW/F5F/Be4Ske3AE8B7Xfh7yewc7wNeBK5MLnXP1ClVF34xsjSlV+bvI0NMfm3K3fadeb/XiD5xo7Ko6uPAm0rcn6FH861jqwW6YBHKOGUmM4Pv0xbtop1a18Y2v/78QsKEhAthMspiGEOzMMpix+QZbRnfTkmR0nmWrvbgNxW/i3325hful+MTxiuc+z+b9E7JKrrYg++T5lhMIS26X0iYkHAhTEZZhqLrIxlSzdI3yeJjfqjvFQOxppB83msXZ1SOUlliZ7cNo0tGqSzFGeyc2S9KiqvtV7TOOn1IWVN8FFLL0sexdU35xZZjdiVEnlbbD/AoO/hSWHeZi9f2x+uiieHb2QyJ11XnuOjvY0ivakBlKFvOITQNBqky3x38MRLbiRyicxxqSC/UuF1bv5S2ievimK1jw+gBUxbD8GRhlMVm8I22jL6DD1k7s6uRmTbFtw5+Oj/r4Cci32KbmrZpWgc/nZ918EdE2e5J2z8yHpoOaxoDC6MshtGWyShL2xn8MX2huqDv4/xSk3IGvzNU1esC1gAPAve457OB3cBjwJeBE537Se55n/Nfakp7y5YtehQo/XffsCHNIpcNGzQZZem3jRfrN+tfl6ePLFXvr6sy1P1moTT9DxwNpKrAHvXUgZCa5RrgkcLzjcBNmplvfQ7Y7ty3A8+p6uuBm1y4uWRMHfzic5uj6ayDX42vYfDNwLuAz7tnAS4E7nZBbme1+dbb3f3dwEUu/CSJ3csdG893CXpZfjELKavyazoVOFbOOjnmpYP/GeATwBH3fBrwvKq+5J5zE61QMN/q/F9w4Q1j0vgY2Xs38JSq7i06lwRVD79iuleJyB4R2XP48OFGQVMt0e9qs1FsvNmvZ5saKaaDX2U9crbDPVtbpbCeEltzNFnfrNr41bqmaurUAH9CVnPsB5bJDOfdATwNrHVhLgDuc/f3ARe4+7UunNTl0baDn7LTHkKqDr5vmn108Ovy6qKD71t23/fnK38nHXxV/ZSqblbVJeBy4Juq+n7gAeAyF+wKVptvvcLdX+bCH1ezzAMpOvi+He6QsLEd/Lq8QmSJzcP3fTbJWeXedsVGm9OKPwncKSJ/RDakvNO57wS+KCL7gGfJFKwVTYXMF0lWxe2qk5jaBGubNFOnu7y8uilW1sEfiqHyDlIWVf0W8C13/ziZNf3ZMD/mmN3j1uR10qgmp4yFZO5n8Lv8CnVhItQYL6Nfol+sWXyX6fc1Ph+7RH9M+c2mWUyvzi8kzWLckPxC8vSRYVV687pEf6zEdvDHlF9sp903zbp0Yjv4MTK0TQ/mTFnyZfh9dQBTz21MibE3QZtWIMQwV8piGF0ySmVpWlxXRd9LupvWY/VtWbOLMyxzuni3Xf5eTSsQYhhlB7+sVxeyFLOvIqXa956i41yXX6wsY7Si78tCd/Bjl793SYp976k6znX5xcrSxVaCNvmH0EUH32tNTNfX7NqwMlJt/mq6ZteZzeZb9O/Tr6r8Vf5d5hfr16Z8Zb9J1ZpAr3WE7v+MjjZ/GcZCY8rCassvY9psZBxPitMCYpnLDn4MVa9hLJ3cJiN0feYXS52cvkb2Yo/SOy68dfDTpz2WTm7TUvQ+84v1i80v5LkurSa/JiajLF1StIM8W60PaWKomF/THvUUcvrmF+vXpnwhdLVT0pphJdRV675NglR+IU2QFHKOuXy+YarCrQprzbBu8vFp6sw+D7GTsK2cYy+fbxjfuKGMr2ZZWoIDBwaVx1gAzjoL9u8PqlnabCvuhI0/3g899w0MwwcfU0gvF5F/EZF/E5Hvi8j1zv1sEdktIo+JyJdF5ETnfpJ73uf8l0IEWlnp/pRcw4jBp8/yE+BCVX0TcC7wThHZhplvNRYMH1NIqqr/7R5f5i5lQcy3GkaOr63jNSLyEPAUsAv4IWa+1VgwvJRFVX+mqucCm8nMH72hLJj724n5VsMYmqB5FlV9nsxu2DbgFBHJR9M2A0+6+4PAGQDO/9VkxvZm07pNVbeq6tb169fHSW8YPeIzGrZeRE5x968A3kF2TssDLLj5VmOx8Jln2QTcLiJryJTrLlW9R0T+nQ7Mt/a509EwQmhUFlV9GDivxL0T8602GTk96gwg9r34tEsmsTZs1kZViqtvKzBjs6s1VlJaxElt22wSytLHYFnVj1T2j14XtupQoHwbQO4XkkaZe9kHZDZfX/mq4lf9k8Uof90HL09P5PhdkFXx6so6m1ZO252Vo1sbVsaRI81hxjqEUPaDGcdT9l5WVuL6sHXvuNX797Vs0eW1yrpLoLWOOisfY6DOssq8USxraDnLfuPYdxVyShyLZt2luNMxpn0a2hSJabrA6s5uWdiqNnYKOfoqYx11fYg628R18crkyY8nmU2vrUGSuVAWw+iDuVWW2drGRqOMtsytshhGakxZWH0E3+who2WjMVXhc1JYJWmyfDJGmt5LUznq3neV5ZqmPFMyvj34JaTaDRNT1CqLKb5hq6yZ+Lg3WW4JSbuNHD7uvjTFDyl/27yyMHNm3eWEBFLGfJnLJuPqKMqZhy26hd4X88vdm+LNylgWr0q+Jrmrzn3xpSl+3fuuei91o3ZtZC1jrmuWtkXztVFVFb6rL3pIDZLKvSpsUZ4mmuLXve+273HW/5hMVrMkqY1m02iqncq+xm1qlpj0ZmVO4V4Vtsqtiqb4VbK0va9zC2ESyuKz3CVFnKY0mjqQxfD5fZlbm/sQ/1TuVWGr3Kpoil8lS9v7OrcQJqEssV+EtvMsTV8qn/BWs9SHtZolMSlqiZgFdE1fKp/wVrPUh7WaJTFDjYZZzVIfFsLe69RrlrlZol9G29Ewq1nqw0LYRKDVLB2Qb+bJr9gvQuudcQPXLMWv9lhrlpB3HFqzlJU/5r7OLYTG6CJyhog8ICKPOFvH1zj3dSKyy9k63iUipzp3EZGbna3jh0Xk/FCh8p2F+RX7RWi70WromqX41R5rzRLyjkNrlrLyx9zXuYXgo2svAR9X1TeQ2Qu7WkTeCFwL3K+ZreP73TPAJcA57roKuKWdiO2+CD5fvqr9ErP5lm1zrZplzu+rziPx+SI2zeCXpR16ZstY+yx1tYzPfRc1S/CuRjL7YBcDjwKbnNsm4FF3/1ngfYXwR8NVXbM7Jet2RcZcTVTFCU0/JN/QNGLLk6rsdWF9Sfn+2uZ1LFxHOyXd8RHnAbuBDap6yCncIeA1LthRW8eOoh3kYlre5lvbrLj1iev71S07YLTqa5a7V61dStFnqdoRWaRpF2abmqWqD1M1r9VUM9XVLKE7NMt+995qFuBVwF7gN93z8zP+z7m/fwu8reB+P7ClLu2mmiXl/uwQ2tRQTWmE1iC+aYTUkiHudWGb5KySt66MIX5VDFKziMjLgK8Ad6jqV53ziohscv6byCzsQ8HWsaNoB3lS1J1/WBc+tE1dVpv49D2a+kg+6aWuWeqO6m6KH3tmZRU+8obQOM/izlbZCTyiqp8ueOU2jW/geFvHHxGRO4G3AC+oa66lJN82PEtKC4ih6VRteCrDZwSsKZ2yNJaXV7+X4gayJjmKzyEjbU1yNuXlEzfmN/WRNwQfXXsr8AHgQhF5yF2XkinJxSLyGFmH/wYX/l7gcWAf8Dngw+1EHI42lkyaCJ3DCUmjbvSqLg0or3Gqaq1QuX1PGk5F6vx8bB3/I5SeuQJwUUl4Ba5uJ1Y4XdjULc4hpDaOFzqHE5JG3bxIXRpw7B361Fop1uxNiVHO4I+FmHZyn2k39Y1CRwLb3C8Ck1eWFMbTqgg1FJHSqHVqumxS+uLzPkNtQPuSouUxeWUxjL6YvLK0tYxeR24Bv8y9q690yi9r1buJfWdV7yNV/Lbp15Hi/2TyymIYfTEXylJmGDzkK1y3OLKYR76Qsunrl+Ir1mWN2ZSn7xe+rYwpylhnCil1LTUXymIYfTCJnZJldHVW4azZ1BBCwofM1Fe5dxW2irbve3l59Re/zBRrqryb8orBahbD8GSUypIvha9aEp96XqXOuHTIKFTISFaKw4JiDzOKPUDJp29X9758+hGho4G+hsFT9I9G2Qwr+4c1jKEZZc1SR9XI17wdXDTbxh7z6oBUxIw09rkyYXLKYhhDMZfKUlf71LWzy9rovjP4xbDFr19ZGrNuZfMbTWlUUZW2T9hQyr7yIenVlTG2/LGy+DCXymIYXWDKMgHaHJPX1XzUImLKYhieLJyy5P2Z1CMnPoeHVrnlX/+6g0bbylGkLD+fPEPDNzG7WkK1+QBa3zw7ObS2yfwL8Bdkllu+V3BbB+wCHnN/T3XuAtxMtv/+YeB8HxMzs6aQfEzapLiaTOa0MWPUZN6oK1NIVe5dlCXUXFEbU0opzCf1YQrpr4B3zrj1ZroVutm+6mN2J9WW25j0UsuUuix1Mpb5NYWvk9fH3Sf91v9HPhoFLLG6ZklmulV1dc2yY8fx2m8YXUFX5lsLtDLdCmHmWw1jDKTu4JeZTNKygKp6m6puVdWt69evP+p+3XWJJTKMRMQqy9ybbjWMWWKVJTfdCsebbv2gO9BoGx2ZbjWMIfCxdfwl4O3A6SJyENhBZqr1LhHZDjwBvNcFvxe4lGzo+EXgyg5kNoxB8DHf+r4Kr9GYbjWMPli4GXzDiMWUxTA8MWUxDE8mpyw2D2PAsc1yfTI5Zbn++qElMMbAykp3dpGrmJyyGMZQjNIUUh07dgwtgTEGhjhIaXLKcuut1hRbZIob1/pmcs2wvtupxrgY8vefnLIs2jmGxmqG/P0n1wzruvqVsk0GRhBauilj+kyuZukaq7naMc/vb3LK0vWkZNEqu13h1zzbKJucsthImDEUk1MWwxiKySmLTUoaQzE5ZbGFlMZQTE5ZDGMoREcwKC4ih4EDQ8uRmNOBp4cWoiPmqWxnqer65mAjUZZ5RET2qOrWoeXognkuWx3WDDMMT0xZDMMTU5buuG1oATpknstWifVZDMMTq1kMwxNTlkhE5AwReUBEHhGR74vINc59nYjsEpHH3N9TnbuIyM0isk9EHhaR84ctQT0iskZEHhSRe9zz2SKy25XryyJyonM/yT3vc/5LQ8rdJaYs8bwEfFxV3wBsA64WkTfS86loHXIN8Ejh+UbgJleu54Dtzn078Jyqvh64yYWbT3xPPbKr8XS0rwMXk/hUtIHKsplM0S8E7iE7d+dpYK3zvwC4z93fB1zg7te6cDJ0Gbq4rGZJgGt6nAfsJsGpaCPgM8AngCPu+TTgeVV9yT0XZT9aLuf/ggs/d5iytEREXgV8Bfioqv6oLmiJ2+iGIkXk3cBTqrq36FwSVD385orJ7cEfEyLyMjJFuUNVv+qcV0Rkk6oemuipaG8F3iMilwIvB36erKY5RUTWutqjKHteroMishZ4NfBs/2J3j9UskYiIADuBR1T10wWvSZ+KpqqfUtXNqroEXA58U1XfDzwAXOaCzZYrL+9lLvxc1iw2KRmJiLwN+DbwXY617f+QrN9yF3Am7lQ0VX3WKdefA+/EnYqmqnt6FzwAEXk78Aeq+m4ReR1wJ7AOeBD4bVX9iYi8HPgiWZ/tWeByVX18KJm7xJTFMDyxZphheGLKYhiemLIYhiemLIbhiSmLYXhiymIYnpiyGIYnpiyG4cn/A0ugWJVAg4rPAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "tableau 2\n",
      "conserver row_tol=4\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAMoAAAD8CAYAAAA2RjsYAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAGw9JREFUeJztnX/MX1V5wD8PraDiBhRq21lKMZJFs0SgjZZpFgeyCBq3LJhhnBJS0yXihtNFcf8AybLBsoghS2Bot6FhIkONhrGxpmLikq1bKwx1lbQyYB28LwUKZmPTYZ/9cc9t7/vt/XHOuef++n6fT3Lz3nt+Pue+3+ee388RVcUwjHpOGloAw5gCpiiG4YEpimF4YIpiGB6YohiGB6YohuGBKYpheGCKYhgemKIYhgerhxYA4KyzztLNmzcPLYaxgOzbt+9ZVV3bFM5LUUTkd4EPAwp8F7ga2ADcDawBvgN8UFV/IiKnAF8AtgDPAb+hqo/Xpb9582b27t3rI4phJEVEnvAJ19j0EpHXAb8DbFXVXwBWAVcCNwO3qOp5wBFgu4uyHTiiqm8AbnHhDGPS+PZRVgOvEpHVwKuBp4GLgXud/53Ar7n7X3XPOP9LRETSiNuO9euzyzBCaVQUVf1P4E+AJ8kU5EVgH/CCqr7sgh0CXufuXwf8h4v7sgt/5my6IrJDRPaKyN7Dhw+3LYcXy8vZlZr160Ek/sqVt206vvkMhU/56mTM4w9RDp+m1xlktcS5wM8BpwKXlQTN1+uX1R4nrOVX1TtUdauqbl27trEvlYR167IrNW2VL4/fhRKX5TMUPvnXhenrPZXh0/R6J/DvqnpYVf8P+Crwi8DprikGsBF4yt0fAs4GcP6nAc8nlTqSpaXsSk1b5cvjd6HEZfkMhU/+dWH6ek9l+Ix6PQlsE5FXA/8DXALsBR4EriAb+boK+LoL/w33/I/O/5s657vDUilfF0o8JtqWb8j349NH2UPWKf8O2dDwScAdwKeAj4vIQbI+yE4XZSdwpnP/OHBdB3IbRq/IGD72W7duVZtHMYZARPap6tamcLaEpSNCRrD6GvUa02hYVVmLsvi+jz7kN0XpiJCRmSFHc4bKtyrPoruvXH3Ib4piGB6YogTiO7sfMoQ55LDnUPlW5Vl095WrD/lHsXp4SvhW8zFDmfM+PFzEp6xjeh+mKIEMPWlnDMPkml433DBs/l3N7hvjZnKKcuONQ0tgLCKTUxTDGILJKcr11w8tgbGITE5Rbr99mNnrMV5D7y9ZJCanKEPvqRgT9i76Y3KKYhhDYIpiGB5MTlFswu849i76Y3Iz8zbZZwzB5GoUwxgCUxTD8MDHXNHPi8jDhetHIvIxEVkjIrtE5ID7e4YLLyJyq4gcFJFHROTC7othGN3iY1ziUVU9X1XPJ7Mn/BLwNTKjEbudSdXdHDcicRlwnrt2ALelFLhse2jM9tFFvGyCMp7QptclwA9V9QlWmk69k5UmVb+gGf9EZv9rQxJpKZ9ki9k+uojYu4knVFGuBL7k7tep6tMA7u9rnfsxk6qOornVYwxhUtUwYvFWFBE5GXgv8NdNQUvckplULZs7iNk+uojYu4knZB7lMuA7qppX4MsiskFVn3ZNq2ec+zGTqo6iudXWNM2j2DyL0QUhTa/3c7zZBcdNp8KJJlU/5Ea/tgEv5k00w5gqviduvRq4FPitgvNNwD0isp3MPvH7nPv9wOXAQbIRsquTSWsYA+GlKKr6EjNnnKjqc2SjYLNhFbgmVqB8CNOaUMaYGN1aLxvCNMaILWExDA9GV6PYEKYxRkZXo1TZzepiacpYl3QMeVbhvOBjLT+E0SlKFV30XXzTrPvhduFXZ93eJ80y/7J4IUcvhJRhNt26PH3kbJK3LLyPtfwQJnOQ0KpVcPRo2nzXrfMbXZPCWoPZ15XSb/36E/+RszL6pjnrXxZvNnxZ3JjylaVbl2eTnHXpVqVT9Xs56ST46U+Lac7ZQUKhSqLafPkOQddZm0/p17Tg0zfNMv+yeCEW5UPKV/fsG7apfE1+Vb+X2I/tZGqUsq9tFb41xdjwqVEMP6p+LyfW0BOuUdp2ZpeX03XiYtvbMX5LS/VfzT5lGZtfSJiyd7luXVgrYpZR1iih7WlfYooa2942v7R+OT5hqsKWhZt0jVIk/2q0nV+JjR/b3ja/tH4hYXzSDmX0igJphoZTNseMxWMSimIYQ2OK0sDSUvWQcrHDODuaEhuvjZxVzYsmOWP8UshZl19d/Jgh/uXldi2I0Xfmu6Zt8esmyGLipZqsq/NLMWna16Rim/+P3+DAnHTmc7pYLJkizdijr7ucrKvzSzVp2sekYuoBnDbpTUZR2pKPo8dU21UUJ7VCqvbYeL5pxsablaVrOYtp5vMjs6anQte0leXTlJ4PC6MohtEGL0URkdNF5F4R+YGI7BeRi8ykqrFQqGrjRWYJ8sPu/mTgdOCPgeuc23XAze7+cuBvAQG2AXua0t+yZYsW8VvSGH6lJjaPunhd+M36DylLlV/I/83nnfumB+xVDx3wMdL9s8AvATudYv1EVV+gZ5OqQ83Mh6Tpm8cQs9qpO+Wp/XxWMvukF+vehE/T6/XAYeAvROQhEfm8iJwK7Uyq9o3NzBtt8FGU1cCFwG2qegHw3xy3XF9G2SzICaPhZnvYmBI+inIIOKSqe9zzvWSKs5w3qWJMqmqk7eFYuhgeNtLhMys/JF4z8yLybbLO/KMicgNwqvN6TlVvEpHrgDWq+kkReTfwUbJO/VuBW1X1LXXp9zUz71HUIEKWfPvG62qJeuoZ9r78ZuUtC1f2zn22OWfh0s7M/zZwl4g8ApwP/CGZSdVLReQAmbnVm1zY+4HHyEyqfg74iGcetVhnfr4782V+Pm59deZ9Tao+DJRpXXKTql2Rd+ZTLe7riqWl47PKIbIW402RsctuM/OG4YEpSgO+e7RTxYPjS8lDar7YL3IX2whiCOnMF/MOybdNa2Ihl9mHFHmoveEpZZn1jy2/b7yuO/OxMpSlZcvsE6Uz1N7wlLIUn1NtB/CJU/acojMfI0ObtGAiipJyxKpshn5Ms/VVTbY2y8abltJX5Vdc9p6/t/Xr602xpl7eXlaW2P/ZXC+zt4lBYwyM7tiHIRj7kLExPKPszJfNIwzVwR/D7LRq80xzn/nFEiNn0d83TF24E9ObcGe+bHi0y3VAdWkPPTvtuwy9z/xi/UJlaQof6lbn3sQoFaVvih382c5eFyZ76qjKr2yeocm/q/ya/FRXpln86LV9n2U2hUNOJZireZQyhjRh1OeCwtj8yvyHWjBZl2Zofk3xy/zD0ppw06uMvpZg11XjfSwojM2vLo++F0zWpRmSn49bSBOrzW9oMjWKYXTBZGuUfNLKMMbE6OZRxrzU2lhcRlejGMYYMUUxDA9MUQzDA1+Tqo+LyHdF5GER2evczKSqsTCE1Ci/rKrnF4bSrgN2q+p5wG6O2/q6DDjPXTuA21IJaxhD0abp1atJVcMYEl9FUeDvRWSfiOxwbp2YVK1bWGcYQ+E7j/I2VX1KRF4L7BKRH9SE9TapStY0Y9OmTcfcqxatdWHOZqz7UGLMFRnd4lWjqOpT7u8zwNeAtzAxk6ptyLef1p3+lNIvRpamU6jK4tVt6S2GCT31ytevzr8pzyqZ68K02e7tc+zDqSLyM/k98CvA94BvAFe5YFcBX3f33wA+5Ea/tgEv5k20vsiXdjddY/tal+1Tt+U848Cn6bUO+Jpk65ZXA3+lqn8nIv8C3CMi24Engfe58PeT2R0+CLwEXJ1c6p6pU6gu/GJkaUqvzN9Hhpj82pS77Tvr6uPXqCiq+hjw5hL35+jRpOrYvv5dsAhlnCqTmZn3aXt2YYaork1tfv35hYQJCefLZBTFMIZkYRTFjqYz2jCZHY5d7ZlvKn4X++LNL9wvxydMWLiJ7nCsoovZep80x2KuaNH9QsKEhPNlMooyFF0fi5Bq9r1JFh8TQX2vBIg1V+TzXlOfCTlKRYmdtTaMrhilohRnpnNmvyQprrZfzzor8SFlTfFBSC1LH0fFNeUXW47ZFQ55Wm0+vqPszJcZSGv7j+uiWeHbYQyJ11VHuOyd1sWrGjwZyrZyCE0DP3Nje3gqxHYYh+gIhxq5CzU819Yvpa3gujix/RZTFMPwwBTFMDxYGEWxmXmjDaPvzEPWruxqBKZN8a0zn87POvMJyLfFpqZtmtaZT+dnnfmRULbr0fZ/jIemg5KGZmEUxTDaMBlFaTszP5YvU1f0fYRearo+n741qup1AauAh4D73PO5wB7gAPBl4GTnfop7Puj8NzelvWXLFi1S9lNfty7NwpV16zQZZem3jRfrN+tfl6ePLFXvr6sy1P3PQmn6DawMy171+P2H1CjXAvsLzzcDt2hmUvUIsN25bweOqOobgFtcuLlkTJ354nOb4+CsM1+Or5HujcC7gc+7ZwEuBu51Qe5kpUnVO939vcAlLvwkid17HRvPdxl5WX4xiyKr8ms6fTdWzjo55qEz/1ngk8BR93wm8IKqvuyei2ZTj5lUdf4vuvCGMVl8DOC9B3hGVfcVnUuCqodfMd0dIrJXRPYePny4UdBUy+y72igUG2/2q9mmJorpzFdZdZztXM/WUimsnMTWGE1WMas2bbWqoZo6McAfkdUYjwNLZEbt7gKeBVa7MBcBD7j7B4CL3P1qF07q8mjbmU/ZQQ8hVWfeN80+OvN1eXXRmfctu+/785X/eLhEnXlV/bSqblTVzcCVwDdV9QPAg8AVLthVrDSpepW7v8KFP6FGmQdSdOZ9O9chYWM783V5hcgSm4fv+2ySs8q9zUqMNqcCfwq4W0T+gGzYeKdz3wl8UUQOAs+TKVcrmgqYL3isittVhzC1WdQ2aaZOd2lpZfOrrDM/FEPkHaQoqvot4Fvu/jEyq/azYf6X43aIW5PXRaOZeDIWkrmfme/y65PabKcxXka/zL5Yo/gute9r/D12mf2Y8ptNs5henV9ImsW4IfmF5OkjQ1l6c7XMfqzEdubHlF9sB903zbp0YjvzMTK0TW+uFCVfSt9XZy/13MWUGHuzs2llQShzpSiG0RWjVJSmhXJV9L0su2l9Vd8WL7s4MzKni3fb5f+raWVBKKPszJcRsqyyryKl2qeeopNcl1+sLGO0Zu/LwnbmY5ewd0mKfeqpOsl1+cXK0sV2gDb5h5C6M9+4xqWPa3atVxmpNm41XbPrxmbzLfr36VdV/ir/LvOL9WtTvrL/SdUav5B1gXSwccswFhZTFFZaaBnLRiGjnBRW+2OYy858DFWvYSwd2iYDcX3mF0udnL4G8GKPr6tOb0E786nTHkuHtmk5eZ/5xfrF5hfyXJdWk18dk1GULinaJZ6tyoc0A1TMr2lPeQo5ffOL9WtTvhC62OFoTa8S6qpy32ZAKr+QZkcKOcdcPt8wVeHK07OmV7J8fJo3s89D7ABsK+fYy+cbxjduCJOpUQyjCyZbo6xfP76VqIbhY67olSLyzyLyryLyfRG50bmfKyJ7ROSAiHxZRE527qe454POf3OIQMvL3Z9Gaxih+NQoPwYuVtU3A+cD7xKRbZhJVWOB8DFXpKr6X+7xFe5SFsSkqmGAv+3hVSLyMPAMsAv4IWZS1VggvBRFVX+qqucDG8lMFL2xLJj724lJVcMYkqBRL1V9gcyu1zbgdBHJ7YJtBJ5y94eAswGc/2lkhvBm07pDVbeq6ta1a9fGSW8YPeEz6rVWRE53968C3kl2TsqDLLhJVWNx8LEUuQG4U0RWkSnWPap6n4j8Gx2YVH3ypM2cffSJ8gacYaTgnHPg8ceDojQqiqo+AlxQ4t6JSdWzjz5RvebdGCV1xgn7XkjqRcQg7Ohm5suYtSGV4urbWoutNvAjpeWalLbHJqEofQyKVf2Dyn7kdWGrDuTJl/LnfiFplLmXfTxm8/WVryp+1Q8sRvHrPnZ5eiIn7l6sildX1tm0ctrsiGxz7ENvHD3aHGasrbWyf5ZxImXvZXk5bsVv3TuOfv8+Fii6vlZYYTm2GMDPqkadNY4xUGcBZd4oljW0nGX/49h31WiFpfAbY5GssBR3KMa0R0ObHzHNFVjZsS0LW9WmTiFHX2Wso67PUGcruC5emTz5ESGz6bUxHjIXimIYXTO3ijJby9iok9GGuVUUw0iJKQorj72bPdCzbNSlKnxOCushTRZKxkjTe2kqR937rrIw05RnKsa3Z17khLHeVLtZYopaZdnEN2yV1REf9yYLKyFpt5HDx92Xpvgh5Y/Oq/Abm+ye+TJOSiBlzBe5bKKtjqKcediiW+h9Mb/cvSnerIxl8arka5K76twVX5ri173vqvdSNzrXRtZZ5rpGaVs0XxtSVeG7+pKH1Byp3KvCFuVpoil+3ftu+x5X+FuN0i5OUxpNtVLZV7hNjRKT3qzMKdyrwla5VdEUv0qWtvd1br5MQlF8lrCkiNOURlNnsRg+vy9za3Mf4p/KvSpslVsVTfGrZGl7X+fmyyQUJfZL0HYepekL5RPeapT6sFajJCRF7RCzGK7pC+UT3mqU+rBWoyRkqFEvq1Hqw0LYe51yjTI3y+zLaDvqZTVKfVgIm+SzGiUx+Uac/Ir9ErRd3zV0jVL8Wo+1Rgl5x6E1Sln5Y+7r3HxpjCoiZ4vIgyKy39kevta5rxGRXc728C4ROcO5i4jc6mwPPyIiF4YKle8IzK/YL0HbTVJD1yjFr/VYa5SQdxxao5SVP+a+zs0XHx17GfiEqr6RzJ7XNSLyJuA6YLdmtod3u2eAy4Dz3LUDuC1ePCdkiy+Bzxevar/DbL5lW1OrZo/z+6rzQHy+hE0z82Vph56ZMtY+Sl3t4nOfukYJ3o1IZr/rUuBRYINz2wA86u7/DHh/IfyxcFXX7A7Hut2MMVcTVXFC0w/JNzSN2PKkKntdWF9Svr9WeRUSp4sdju4IhwuAPcA6VX3aKdvTwGtdsGO2hx1Fu8TFtLxNqrZZOesT1/drW3aYZ9VXLHevWouUoo9StZOxSNPuyTY1SlWfpWreqqlGqqtRQndWlv3fe6lRgNcA+4Bfd88vzPgfcX//Bnh7wX03sKUu7aYaJeV+6hDa1ExNaYTWHL5phNSOIe51YZvkrJK3rowhflX0XqOIyCuArwB3qepXnfOyiGxw/hvILN1Dwfawo2iXeFLUnTdYFz60DV1Wi/j0NZr6RD7ppa5R6o7Dboofe0ZkFT7y+tI4j+LONtkJ7FfVzxS8chvDN3Gi7eGPisjdwFuBF9U10VKSb/WdJaVlwtB0qjYrleEz0tWUTlkaS0sr30tx81eTHMXnkBG1Jjmb8vKJG/M/9ZHXFx8dexvwQeBiEXnYXZeTKcilInKArHN/kwt/P/AYcBD4HPCRePGGpY3FkSZC52hC0qgbpapLA8prmqraKlRu3xN9U5EyPx/bw/8AlSazLykJr8A18SLF0YWN2+IcQWrDdaFzNCFp1M171KUBx9+hT22VYg3eVBjlzPxYiGkX95l2U18odMSvzf28M3lFaWvYrI5Qow4pDUynpstmpC8+7zPUJrMvbVsck1cUw+iDyStKGwvlTeSW6Mvcu/o6p/yiVr2b2HdW9T5SxW+bfh1tfyeTVxTD6IO5UJQyI90hX9+6hY7FPPJFkU1fvRS1XJc1ZVOevl/2tjKmKGOduaKUtdNcKIphdM0kdjiW0dXZgLOmTEMICR8yA1/l3lXYKtq+76WllV/6MvOoqfJuyisUq1EMw4NRKkq+nL1qWXvqeZM6Q88ho00hI1YpDuqJPUgo9vAin75c3fvy6TeEjvr5Gulu2x8aZdOr7MdqGEMyyhqljqoRrnk7NGi2TT3mWf9UxIwo9rXiYHKKYhhDMJeKUlfr1LWry9rkvjPzxbDFr15ZGrNuZfMXTWlUUZW2T9hQyr7uIenVlTG2/LGyNDGXimIYqTFFmQBtjqbrar5p0TBFMQwPFk5R8v5L6hESn4M6q9zyr37doZ5t5ShSlp9PnqHhm5hdBaHafNirb57JD4htMtMC/DmZhZXvFdzWALuAA+7vGc5dgFvJ9ss/AlzoYwpm1lyRj9mZFFeTWZs2poaaTBB1Za6oyr2LsoSaFGpj7iiFiaOuzRX9JfCuGbfezKlCN1tOfUzjpNomG5NeaplSl6VOxjK/pvB18vq4+6Tf6nfko03AZlbWKMnMqaqurFGOnHZO+6rCLrvqrnPOCa5RYpewrDCnKiJN5lRPsOslIjvIah02bdp0zP2zH3ucG26IlMowOiJ1Z77MrJGWBVTVO1R1q6puXbt27TF3UxJjjMQqytybUzWMIrGKkptThRPNqX7IHSa0jY7MqRpG3/jYHv4S8A7gLBE5BFxPZj71HhHZDjwJvM8Fvx+4nGx4+CXg6g5kNoze8TGp+v4Kr9GYUzWMrlm4mXnDiMEUxTA8MEUxDA8mpyg2z2LA8Y1ufTE5RbnxxqElMMbA8nJ3dorLmJyiGMYQjNJcUR3XXz+0BMYY6PsQo8kpyu23W/NrkSluOuuTyTW9+myXGuNjqP//5BRlkc4NNE5kqP//5JpeXVe5ZWfXG2Fo6caKaTO5GqVrrMZqx7y+v8kpStcTjkXr6HaFX/NqQ2xyimIjXsYQTE5RDGMIJqcoNuFoDMHkFMUWRRpDMDlFMYwhEB3BoLeIHAaeGFqOxJwFPDu0EB0xT2U7R1XXNgUahaLMIyKyV1W3Di1HF8xz2aqwppdheGCKYhgemKJ0xx1DC9Ah81y2UqyPYhgeWI1iGB6YokQiImeLyIMisl9Evi8i1zr3NSKyS0QOuL9nOHcRkVtF5KCIPCIiFw5bgnpEZJWIPCQi97nnc0VkjyvXl0XkZOd+ins+6Pw3Dyl3V5iixPMy8AlVfSOwDbhGRN5Ez6eRdci1wP7C883ALa5cR4Dtzn07cERV3wDc4sLNHz6nDdnldSrZ14FLSXwa2UBl2Uim5BcD95Gde/MssNr5XwQ84O4fAC5y96tdOBm6DKkvq1ES4JobFwB7mDmNDGg6jWyMfBb4JHDUPZ8JvKCqL7vnouzHyuX8X3Th5wpTlJaIyGuArwAfU9Uf1QUtcRvdkKOIvAd4RlX3FZ1LgqqH39wwuT3zY0JEXkGmJHep6led87KIbNDsbMspnkb2NuC9InI58ErgZ8lqmNNFZLWrNYqy5+U6JCKrgdOA5/sXu1usRolERATYCexX1c8UvCZ9GpmqflpVN6rqZuBK4Juq+gHgQeAKF2y2XHl5r3Dh565GsQnHSETk7cC3ge9yvC3/+2T9lHuATbjTyFT1eadYfwq8C3camaru7V3wAETkHcDvqep7ROT1wN3AGuAh4DdV9cci8krgi2R9tOeBK1X1saFk7gpTFMPwwJpehuGBKYpheGCKYhgemKIYhgemKIbhgSmKYXhgimIYHpiiGIYH/w9upOglwF1m6QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "tableau 3\n",
      "conserver row_tol=4\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAMsAAAD8CAYAAADZhFAmAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4wLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvqOYd8AAAGw9JREFUeJztnX2sJlV5wH8PrIBiFRbWu1sBL0bSaJoI7EaXahoL0gga2zSYYqwSsoYmYovVRrH/LCRNC00jhjSBorRFQ0WKGg2lpRvExCbttrtCUbuSXSlLKdzLAgumpWqRp3/Mmb1z352Pc86c+Xrf55dM7sz5fM6895nz/RxRVQzDaOaYoQUwjKlgymIYnpiyGIYnpiyG4Ykpi2F4YspiGJ6YshiGJ6YshuGJKYtheLJhaAEATj31VF1eXh5aDGNB2bt379OquqkpnJeyiMjvAR8GFPgucDmwBbgD2Ah8B/igqv5URI4HvgBsBZ4BflNVH61Lf3l5mT179viIYhjJEZGDPuEam2Ei8lrgd4FtqvqLwLHApcD1wA2qehZwGNjhouwADqvqG4AbXDjDmDy+fZYNwMtFZAPwCuBJ4HzgLud/G/Dr7v7X3DPO/wIRkTTitmPz5uwyjBgalUVV/wv4U+AxMiV5HtgLPKeqL7pgjwOvdfevBf7TxX3RhT9lNl0RuUJE9ojInkOHDrUthxerq9mVms2bQST+yhW4bTq++QyFT/nqZMzjD1UOn2bYyWS1xZnAzwMnAheVBM3X+pfVIkftA1DVW1R1m6pu27SpsW+VhKWl7EpNWwXM43ehyGX5DIVP/nVh+npPVfg0w94J/IeqHlLV/wO+CvwScJJrlgGcBjzh7h8HTgdw/q8Gnk0qdSQrK9mVmrYKmMfvQpHL8hkKn/zrwvT1nqrwGQ17DNguIq8A/he4ANgD3A9cQjYidhnwdRf+G+75n5z/N3XOd5ilUsAuFHlMtC3f0O/Hp8+ym6yj/h2yYeNjgFuATwEfF5EDZH2SW12UW4FTnPvHgas7kNswekfG8NHftm2b2jyLMRQisldVtzWFs+UuHREystXXaNiYRsmqylqUxfd99CW/KUtHhIzYDD3KM0S+VXkW3X3l6kt+UxbD8MSUJRDfVQAhw5tDD4kOkW9VnkV3X7n6kn8Uq46nhG+VHzPMOfTQaJ/4lHVs78OUJZChJ/aM4ZhcM+yaa4bNv6tVAMb4mZyyXHvt0BIYi8rklMUwhmJyyrJz59ASGIvK5JTl5puHmeUe4zX0/pRFY3LKMvSejDFh76JfJqcshjEUpiyG4cnklMUmBdewd9Evk5vBtwlBYygmV7MYxlCYshiGJz6mkH5BRB4sXD8SkY+JyEYR2SUi+93fk114EZEbReSAiDwkIud2XwzD6B4fgxUPq+rZqno2mf3iF4CvkRmiuM+Zb72PNcMUFwFnuesK4KaUApdtNY3ZirqIl01itiO0GXYB8ENVPch6M623sd586xc045/J7IttSSIt5RNxMVtRFxF7N+0IVZZLgS+5+yVVfRLA/X2Ncz9ivtVRNO16hCHMtxpGG7yVRUSOA94L/E1T0BK3ZOZby+YWYraiLiL2btoRMs9yEfAdVc0r81UR2aKqT7pm1lPO/Yj5VkfRtGtrmuZZbB7G6IqQZtj7WWuCwZqZVjjafOuH3KjYduD5vLlmGFPG9+SvVwAXAr9dcL4OuFNEdpDZQ36fc78HuBg4QDZydnkyaQ1jQLyURVVfYOaMFVV9hmx0bDasAlfGCpQPb1pzyhgbo1sbZsObxlix5S6G4cnoahYb3jTGyuiUZeWEZTh4sHy2xjBS8brXwaOPBkUZXzPs4EFQPeoSurnK8pq9Ni9lYTcv9eNXJ59PmmX+ZfGK4YtXWZiQMsymW5enj5xN8paFb/zNDx4M/tcc32FGIllhZjj2WHjppbT5Li35jbpJoZabFS2l3+bNRw9wzMrom+asf1m82fBlcWPKV5ZuXZ5NctalW5VO1f/LMcfAz37Guv+zuTvMKFRRPCoM7+HpOiv3Kf2aFon6plnmXxYvxJJ9SPnqnn3DNpWvya/q/6XNB3cyNUvZV7cK3xpjbPjULIYfVf8vR97nvNQs+Z6U2P0Xq6vp9nLM7o+p2zvT1m9lpf7r2acsY/MLCVP2LpeWwloTZYyyZpHCImWf9rUvMUWNbX+bX1q/HJ8wVWHXhZuXmqVI/vVoO/8SGz+2/W1+af1CwvikHcPolQXSLIFJ2TQzFpNJKIthjAFTlgZWVqqHm4udyNlRq9h4beSsamo0yRnjl0LOuvzq4scM/6+utm9JjL6D3zVti183iRYTL9WEXp1fionVviYe2/w+tXLMYwc/p4sFlinSjD2Wu8sJvTq/VBOrfUw8ph7UaZveZJSlLfk4e0wVXkVx4iukmo+N55tmbLxZWbqWs5hmPn8ya9aqaa6lSqay99G2DAujLIbRFi9lEZGTROQuEfmBiOwTkfPMfKuxcKhq40VmcfLD7v444CTgT4CrndvVwPXu/mLg78h2pGwHdjelv3XrVj0CnuvmI67UxOZRF68Lv1n/IWWp8gv53XzeeWN6hYjAHvXQAx/D4K8Cfhm41SnXT1X1OXo23zrUDH5Imr55DDH7nbqjntrPZwW0T3qx7j74NMNeDxwC/lJEHhCRz4vIidDOfGvf2Ay+0RYfZdkAnAvcpKrnAP/DmsX8MrzMt5qtY2Nq+CjL48DjqrrbPd9FpjyrefMqxnyrRto6jqWLoWMjHT6z90PjNYMvIt8m6+A/LCLXACc6r2dU9ToRuRrYqKqfFJF3Ax8l6+i/FbhRVd9Sl35fM/geRQ0iZLm4b7yulrennonvy29W3rJwZe+8cct0hzP4vwPcLiIPAWcDf0RmvvVCEdlPZtr1Ohf2HuARMvOtnwM+4plHLdbBn+8Ofpmfj1ufHXxf860PAmWal9x8a1fkHfxUCwK7YmVlbfY5RNZivCkyBdltBt8wPDFlacB3z3eqeLC2DD2kBoz9MnexBSGGkA5+Me+QfNu2KhZyiX5IkYfaa55Slln/2PL7xuu6gx8rw7q0bIl++nSG2mueUpbic6qtBD5xyp5TdPBjZGiTVs4klCXlSFbZTP6YZvWrmm9tlpw3LcOvyq+4ZD5/b5s3Vx+fnvulXho/W5bY32zul+jb5KExFkZnRX8Ixj6cbIyDUXbwNy/pUfMMKYzs1VH1GsYwi63aPCPdZ36xxMhZ9PcNUxfuSNh56eCXDZ12uW6oLu2hZ7F9l7D3mV+sX6gsTeFD3ercfRilsvRNsdM/2wHswhxQHVX5lc1DNPl3lV+Tn+r6NIsfvrbvs8yGcchpCHM3z1LWJuq6GVakrkrvehFibH5l/kMtsqxLMzS/pvhl/l5pzUszrIy+lm/XVel9LEKMza8uj74XWdalGZKfj1tIc6vt/9D4apbl5agjzAwjiMKZkr41y+iGjjf/+FGwoVxjhIxOWca+TNtYXCbTZzGMoTFlMQxPTFkMwxNf862Pish3ReRBEdnj3Mx8q7FQhNQsv6KqZxeG2K4G7lPVs4D7WLMldhFwlruuAG5KJaxhDEmbZliv5lsNY2h8lUWBfxCRvSJyhXPrxHxr3WI8wxgS33mWt6nqEyLyGmCXiPygJqy3+VayZhpnnHHGEfeqycguTOWMdR9LjCkko3u8ahZVfcL9fQr4GvAWJma+tQ35Vta6U6hS+sXI0nQaVlm8uu3BxTChp2/5+tX5N+VZJXNdmLZbx32OnDhRRH4uvwd+Ffge8A3gMhfsMuDr7v4bwIfcqNh24Pm8udYX+bLwpmtsX+2yfe9D2wQw1vBphi0BX5NszfMG4K9V9e9F5F+BO0VkB/AY8D4X/h4yO8cHgBeAy5NL3TN1StWFX4wsTemV+fvIEJNfm3K3fWddfgAblUVVHwHeXOL+DD2abx1bLdAFi1DGKTOZGXyftmgX7dS6Nrb59ecXEiYkXAiTURbDGJqFURY7Js9oy/h2SlbQ1R78puJ3sc/e/ML9cnzChITLwtoe/CRpjsUU0qL7hYQJCRfCZJRlKLo+kiHVLH2TLD7mh/peMRBrCsnnvXZxRuUolSV2dtswumSUylKcwc6Z/aKkuNp+Reus04eUNcVHIbUsfRxb15RfbDlmV0LkabX9AI+yg1/snOXitf3xumhihHQifeN11Tkue6d18aoGVIay5RxC02DQ0YMGc9bBHyOxncghOsehhvRCjdu19Utpm7guTpt+jCmLYXhiymIYniyMstgMvtGW0XfwIWtndjUy06b41sFP52cd/ETkW2xT0zZN6+Cn87MO/ogo2z1p+0fGQ9NhTWNgYZTFMNoyGWVpO4M/pi9UF/R9nF9qUs7gd4aqel3AscADwN3u+UxgN7Af+DJwnHM/3j0fcP7LTWlv3bpVi5T9uy8tpVnksrSkyShLv228WL9Z/7o8fWSpen9dlaHuNwul6X/g6PDsUQ8dCKlZrgL2FZ6vB27QzHzrYWCHc98BHFbVNwA3uHBzyZg6+MXnNkfTWQe/Gl/D4KcB7wY+754FOB+4ywW5jfXmW29z93cBF7jwkyR2L3dsPN8l6GX5xSykrMqv6VTgWDnr5JiXDv5ngU8CL7nnU4DnVPVF91w00XrEfKvzf96FN4xJ42Nk7z3AU6q6t+hcElQ9/IrpXiEie0Rkz6FDhxoFTbVEv6vNRrHxZr+ebWqkmA5+lfXI2Q73bG2VwnpKbM3RZH2zauNX65qqqVMD/DFZzfEosEJmOO924GlggwtzHnCvu78XOM/db3DhpC6Pth38lJ32EFJ18H3T7KODX5dXFx1837L7vj9f+deHTdTBV9VPq+ppqroMXAp8U1U/ANwPXOKCXcZ6862XuftLXPijapZ5IEUH37fDHRI2toNfl1eILLF5+L7PJjmr3Nuu2GhzWvGngDtE5A/JhpRvde63Al8UkQPAs2QK1oqmQuaLJKvidtVJTG2CtU2aqdNdWVnfFCvr4A/FUHkHKYuqfgv4lrt/hMya/myYH7Nm97g1eZ00qskpYyGZ+xn8Lr9CXZgINcbL6JfoF2sW32X6fY3Pxy7RH1N+s2kW06vzC0mzGDckv5A8fWSoSm+uluiPldgO/pjyi+20+6ZZl05sBz9GhrbpwZwpS74Mv68OYOq5jSkx9iZo0wqEGOZKWQyjS0apLE2L66roe0l303qsvi1rdnGGZU4X77bL36tpBUIMo+zglxGyFLOvIqXa956i41yXX6wsY7Si78tCd/Bjl793SYp976k6znX5xcrSxVaCNvmH0EUHv3E9TB/X7NqwMlJt/mq6ZteZzeZb9O/Tr6r8Vf5d5hfr16Z8Zb9J1ZrA0HWEdLD5yzAWGlMW1lt+GdNmI+NoUpwWEMtcdvBjqHoNY+nkNhmh6zO/WOrk9DWyF3uUXn34Be3gp057LJ3cpqXofeYX6xebX8hzXVpNfk1MRlm6pGgHebZaH9LEUDG/pj3qKeT0zS/Wr035Quhqp6Q1w0qoq9Z9mwSp/EKaICnkHHP5fMNUhasOa82wZPn4NHVmn4fYSdhWzrGXzzeMb9xQJlOzGEZXTLZm2bx5fCtYDQP8TCGdICL/IiL/JiLfF5FrnfuZIrJbRPaLyJdF5Djnfrx7PuD8l0MEWl3t/pRcw4jBp2b5CXC+qr4ZOBt4l4hsx8y3GguGjykkVdX/do8vc5eyIOZbDSPH19bxsSLyIPAUsAv4IWa+1VgwvJRFVX+mqmcDp5GZP3pjWTD3txPzrYYxNEGjYar6HJndsO3ASSKS2x07DXjC3T8OnA7g/F9NZmxvNq1bVHWbqm7btGlTnPSG0SM+o2GbROQkd/9y4J1k57Tcz4KbbzUWCx+LlFuA20TkWDLlulNV7xaRf6cD86197nQ0jBAalUVVHwLOKXHvxHyr7SeZHnUGEPtefNolo5vBL2PWRlWKq28rMLYqwY+UFnFS2zabhLL0MVhW9SOV/aPXha06FCjfBpD7haRR5l72AZnN11e+qvhV/2Qxyl/3wcvTEzl6F2RVvLqyzqaV03ZnZZsjJ3rjpZeaw4x1CKHsBzOOpuy9rK7G9WHr3nGr9+9j1aLrq8m6S5Nll6FO/vKhzrLKvFEsa2g5y37j2Hdl1l1qKO50jGmfhjZFYpousL6zWxa2qo2dQo6+ylhHXR+izjZxXbwyefLjSWbTa2uQZC6UxTD6YG6VZba2sdEooy1zqyyGkRpTFtYfwTd7yGjZaExV+JwUVkmaLJ+Mkab30lSOuvddZbmmKc+UTGIPfqrdMDFFrbKY4hu2ypqJj3uT5ZaQtNvI4ePuS1P8kPK3zWst3ET34JdxTAIpY77MZZNxdRTlzMMW3ULvi/nl7k3xZmUsi1clX5PcVee++NIUv+59V72XulG7NrKWMdc1S9ui+dqoqgrf1Rc9pAZJ5V4VtihPE03x69532/c4679ergWvWVLURrNpNNVOZV/jNjVLTHqzMqdwrwpb5VZFU/wqWdre17mFMAll8VnukiJOUxpNHchi+Py+zK3NfYh/KveqsFVuVTTFr5Kl7X2dWwiTUJbYL0LbeZamL5VPeKtZ6sNazZKYFLVEzAK6pi+VT3irWerDWs2SmKFGw6xmqQ8LYe916jXL3CzRL6PtaJjVLPVhIWwi0GqWDsg38+RX7Beh9c64gWuW4ld7rDVLyDsOrVnKyh9zX+cWQmN0ETldRO4XkX3O1vFVzn2jiOxyto53icjJzl1E5EZn6/ghETk3VKh8Z2F+xX4R2m60GrpmKX61x1qzhLzj0JqlrPwx93VuIfjo2ovAJ1T1jWT2wq4UkTcBVwP3aWbr+D73DHARcJa7rgBuaidiuy+Cz5evar/EbL5l21yrZpnz+6rzSHy+iE0z+GVph57ZMtY+S10t43PfRc0SvKuRzD7YhcDDwBbntgV42N3/OfD+Qvgj4aqu2Z2SdbsiY64mquKEph+Sb2gaseVJVfa6sL6kfH9t81oftoOdku74iHOA3cCSqj7pFO5J4DUu2BFbx46iHeRiWt7mW9usuPWJ6/vVLTtgtOprlrtXrV1K0Wep2hFZpGkXZpuapaoPUzWv1VQz1dUsoTs0y3733moW4JXAXuA33PNzM/6H3d+/Bd5ecL8P2FqXdlPNknJ/dghtaqimNEJrEN80QmrJEPe6sE1yVslbV8YQvyoGqVlE5GXAV4DbVfWrznlVRLY4/y1kFvahYOvYUbSDPCnqzj+sCx/api6rTXz6Hk19JJ/0UtcsdUd1N8WPPbOyCh95Q2icZ3Fnq9wK7FPVzxS8cpvG13G0reOPisgdwFuB59U111KSbxueJaUFxNB0qjY8leEzAtaUTlkaKyvr30txA1mTHMXnkJG2Jjmb8vKJG/Ob+sgbgo+uvQ34IHC+iDzorovJlORCEdlP1uG/zoW/B3gEOAB8DvhIOxGHo40lkyZC53BC0qgbvapLA8prnKpaK1Ru35OGU5E6Px9bx/8IpWeuAFxQEl6BK9uJFU4XNnWLcwipjeOFzuGEpFE3L1KXBqy9Q59aK8WavSkxyhn8sRDTTu4z7aa+UehIYJv7RWDyypLCeFoVoYYiUhq1Tk2XTUpffN5nqA1oX1K0PCavLIbRF5NXlraW0evILeCXuXf1lU75Za16N7HvrOp9pIrfNv06UvyfTF5ZDKMv5kJZygyDh3yF6xZHFvPIF1I2ff1SfMW6rDGb8vT9wreVMUUZ60whpa6l5kJZDKMPJrFTsoyuziqcNZsaQkj4kJn6KveuwlbR9n2vrKz/4peZYk2Vd1NeMVjNYhiejFJZ8qXwVUviU8+r1BmXDhmFChnJSnFYUOxhRrEHKPn07erel08/InQ00NcweIr+0SibYWX/sIYxNKOsWeqoGvmat4OLZtvYY14dkIqYkcY+VyZMTlkMYyjmUlnqap+6dnZZG913Br8Ytvj1K0tj1q1sfqMpjSqq0vYJG0rZVz4kvboyxpY/VhYf5lJZDKMLTFkmQJtj8rqaj1pETFkMw5OFU5a8P5N65MTn8NAqt/zrX3fQaFs5ipTl55NnaPgmZldLqDYfQOubZyeH1jaZfwH+gsxyy/cKbhuBXcB+9/dk5y7AjWT77x8CzvUxMTNrCsnHpE2Kq8lkThszRk3mjboyhVTl3kVZQs0VtTGllMJ8Uh+mkP4KeNeMW2+mW6Gb7as+ZndSbbmNSS+1TKnLUidjmV9T+Dp5fdx90m/9f+SjUcAy62uWZKZbVdfXLDt3lmu/YXQFXZhvLdDKdCuEmW81jDGQuoNfZjJJywKq6i2quk1Vt23atOmI+zXXJJbIMBIRqyxzb7rVMGaJVZbcdCscbbr1Q+5Ao+10ZLrVMIbAx9bxl4B3AKeKyOPATjJTrXeKyA7gMeB9Lvg9wMVkQ8cvAJd3ILNhDIKP+db3V3iNxnSrYfTBws3gG0YspiyG4Ykpi2F4MjllsXkYA9Y2y/XJ5JTl2muHlsAYA6ur3dlFrmJyymIYQzFKU0h17Nw5tATGGBjiIKXJKcvNN1tTbJEpblzrm8k1w/pupxrjYsjff3LKsmjnGBrrGfL3n1wzrOvqV8o2GRhBaOmmjOkzuZqla6zmasc8v7/JKUvXk5JFq+x2hV/zbKNscspiI2HGUExOWQxjKCanLDYpaQzF5JTFFlIaQzE5ZTGMoRAdwaC4iBwCDg4tR2JOBZ4eWoiOmLeyvU5VNzUFGoWyzCMiskdVtw0tRxfMc9nqsGaYYXhiymIYnpiydMctQwvQIfNctkqsz2IYnljNYhiemLJEIiKni8j9IrJPRL4vIlc5940isktE9ru/Jzt3EZEbReSAiDwkIucOW4J6RORYEXlARO52z2eKyG5Xri+LyHHO/Xj3fMD5Lw8pd5eYssTzIvAJVX0jsB24UkTeRM+nonXIVcC+wvP1wA2uXIeBHc59B3BYVd8A3ODCzSc+Jx7Z5XU62teBC0l8KtpAZTmNTNHPB+4mO3fnaWCD8z8PuNfd3wuc5+43uHAydBm6uKxmSYBrepwD7CbBqWgj4LPAJ4GX3PMpwHOq+qJ7Lsp+pFzO/3kXfu4wZWmJiLwS+ArwMVX9UV3QErfRDUWKyHuAp1R1b9G5JKh6+M0Vk9uDPyZE5GVkinK7qn7VOa+KyBZVfXKip6K9DXiviFwMnAC8iqymOUlENrjaoyh7Xq7HRWQD8Grg2f7F7h6rWSIREQFuBfap6mcKXpM+FU1VP62qp6nqMnAp8E1V/QBwP3CJCzZbrry8l7jwc1mz2KRkJCLyduDbwHdZa9v/AVm/5U7gDNypaKr6rFOuPwPehTsVTVX39C54ACLyDuD3VfU9IvJ64A5gI/AA8Fuq+hMROQH4Ilmf7VngUlV9ZCiZu8SUxTA8sWaYYXhiymIYnpiyGIYnpiyG4Ykpi2F4YspiGJ6YshiGJ6YshuHJ/wPTAjFjScEZFQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#pour verifier si on doit utiliser row_tol=2 ou row_tol=4\n",
    "def verifColumns(dataframe):\n",
    "    count=0\n",
    "    for i in range(len(dataframe.columns)):\n",
    "        for j in range(len(dataframe[i])):\n",
    "            count+= dataframe[i][j].count(\"\\n\")\n",
    "  \n",
    "    \n",
    "    return count\n",
    "\n",
    "#pour verifier si on utilise le table_bbox_unscaled  ou table_bbox\n",
    "def verifEmptyRows(dataframe):\n",
    "    df=dataframe.replace('', np.nan)\n",
    "    return df.isna().sum().sum()\n",
    "\n",
    "\n",
    "def extractTables(table_bbox,table_bbox_unscaled):\n",
    "    #pour savoir le nombre de tableau à detecter\n",
    "    t = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='lattice',flag_size=True) #methode1\n",
    "\n",
    "    if len(t)==0:\n",
    "        print(\"pas de tableau dans la page\")\n",
    "        return (0,'')\n",
    "    elif len(t)==1:\n",
    "        finalDF=extractOneTable(table_bbox,table_bbox_unscaled)\n",
    "        return (1,finalDF)\n",
    "\n",
    "\n",
    "    else:\n",
    "        listFinalDF=extractMultipleTable(table_bbox)\n",
    "        return (len(t),listFinalDF)\n",
    "    #return number of dataframes and the list of dataframes extracted\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "#traitement de tous les cas 0 , 1 ou plusieurs tableaux\n",
    "(x , tables) = extractTables(table_bbox,table_bbox_unscaled)    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                           0             1                              2   \\\n",
       " 0                                                               DISCIPLINE   \n",
       " 1                                                                  SUBAREA   \n",
       " 2                                                     Included Contingency   \n",
       " 3                                               Previous Rev.7 Contingency   \n",
       " 4                                             Integrated Below Cellar Deck   \n",
       " 5                                                   Integrated Cellar Deck   \n",
       " 6                                                    Integrated Lower Deck   \n",
       " 7                                             Integrated Intermediate Deck   \n",
       " 8                                                    Integrated Upper Deck   \n",
       " 9   INTEGRATED DECK PHASE 104  DRY IN PLACE        Integrated Weather Deck   \n",
       " 10                                               Integrated Living Quarter   \n",
       " 11                                                                Top Deck   \n",
       " 12                                                       GTG Exhaust stack   \n",
       " 13                                                         GTG Inlet stack   \n",
       " 14                                                              East modue   \n",
       " 15                                                             West module   \n",
       " 16                                           TOTAL INTEGRATED Gross Weight   \n",
       " 17                                             PREVIOUS REV.7 Gross Weight   \n",
       " 18                                           VARIATION FROM PREVIOUS REV.7   \n",
       " \n",
       "         3       4       5       6       7         8       9      10       11  \\\n",
       " 0       AR      EL      HV      IN      IN        ME     PFP     SA  PA (ST)   \n",
       " 1                                   Valves                                     \n",
       " 2     6.8%    5.2%    6.0%    5.2%    5.0%      4.3%    5.0%   5.4%     5.0%   \n",
       " 3     6.9%    5.1%    5.0%    5.2%    5.0%      4.3%    5.0%   5.7%     5.0%   \n",
       " 4             1 te            1 te   13 te     13 te    2 te   0 te     2 te   \n",
       " 5           134 te           35 te   32 te    611 te   48 te   4 te    47 te   \n",
       " 6            89 te           32 te   73 te    288 te   29 te   3 te    19 te   \n",
       " 7            96 te           29 te   15 te    451 te   22 te   4 te    17 te   \n",
       " 8            94 te           32 te   16 te    262 te   31 te   4 te    12 te   \n",
       " 9            55 te           18 te   14 te    987 te    7 te   3 te    18 te   \n",
       " 10  267 te  235 te  101 te   70 te            284 te   22 te   2 te            \n",
       " 11           14 te            6 te   12 te     74 te    3 te   2 te     5 te   \n",
       " 12                                             88 te                    2 te   \n",
       " 13           10 te                             39 te                    1 te   \n",
       " 14            1 te            1 te             11 te                    0 te   \n",
       " 15           20 te    3 te    4 te            107 te    1 te   0 te     5 te   \n",
       " 16  267 te  749 te  104 te  227 te  176 te  3 214 te  165 te  22 te   128 te   \n",
       " 17  258 te  730 te   84 te  179 te  176 te  3 202 te  164 te  25 te   129 te   \n",
       " 18    8 te   20 te   20 te   48 te    0 te     12 te    0 te  -3 te     0 te   \n",
       " \n",
       "           12        13        14      15        16          17         18  \n",
       " 0         PI      ST I     ST II  ST III        ST  T & I Aids  TOTAL DRY  \n",
       " 1                                                                          \n",
       " 2       3.3%      3.1%      3.5%    5.6%      3.4%       20.0%       3.7%  \n",
       " 3       3.3%      3.1%      3.8%    5.8%      3.6%       10.0%       3.7%  \n",
       " 4      12 te     20 te     16 te    7 te     43 te                  86 te  \n",
       " 5     189 te    708 te    583 te   41 te  1 332 te               2 431 te  \n",
       " 6     294 te    645 te    532 te   30 te  1 207 te               2 035 te  \n",
       " 7     240 te    673 te    521 te   21 te  1 215 te               2 090 te  \n",
       " 8     252 te    454 te    329 te   49 te    832 te               1 534 te  \n",
       " 9     260 te    876 te    487 te   61 te  1 424 te               2 786 te  \n",
       " 10      5 te              141 te   40 te    182 te               1 167 te  \n",
       " 11    144 te    168 te    159 te    5 te    332 te        7 te     600 te  \n",
       " 12      9 te              121 te    8 te    130 te                 229 te  \n",
       " 13      5 te               54 te    5 te     59 te                 114 te  \n",
       " 14      9 te     31 te     23 te    3 te     57 te                  80 te  \n",
       " 15     17 te    292 te     81 te   62 te    435 te                 591 te  \n",
       " 16  1 436 te  3 867 te  3 049 te  333 te  7 248 te        7 te  13 743 te  \n",
       " 17  1 362 te  3 841 te  3 115 te  333 te  7 289 te       33 te  13 630 te  \n",
       " 18     74 te     26 te    -66 te    0 te    -41 te      -26 te     112 te  ,\n",
       "                           0                        1   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7                                                       \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " 14  TOPSIDES PHASE 104 - 106  IN PLACE WITHOUT FUTURE   \n",
       " 15                                                      \n",
       " 16                                                      \n",
       " 17                                                      \n",
       " 18                                                      \n",
       " 19                                                      \n",
       " 20                                                      \n",
       " 21                                                      \n",
       " 22                                                      \n",
       " 23                                                      \n",
       " \n",
       "                                2               3               4       5   \\\n",
       " 0                      DISCIPLINE                                      IN   \n",
       " 1                         SUBAREA      AR\\nEL\\nHV              IN  Valves   \n",
       " 2                                                                           \n",
       " 3            Included Contingency      5.3%\\n5.3%      5.6%\\n5.3%    4.9%   \n",
       " 4      Previous Rev.7 Contingency      5.3%\\n5.1%      5.0%\\n5.4%    4.9%   \n",
       " 5    Integrated Below Cellar Deck            1 te            1 te   13 te   \n",
       " 6          Integrated Cellar Deck          134 te           35 te   32 te   \n",
       " 7           Integrated Lower Deck           89 te           32 te   73 te   \n",
       " 8    Integrated Intermediate Deck           96 te           29 te   15 te   \n",
       " 9           Integrated Upper Deck           94 te           32 te   16 te   \n",
       " 10        Integrated Weather Deck           55 te           18 te   14 te   \n",
       " 11      Integrated Living Quarter  267 te\\n235 te   101 te\\n70 te           \n",
       " 12                       Top Deck           14 te            6 te   12 te   \n",
       " 13              GTG Exhaust stack                                           \n",
       " 14                GTG Inlet stack           10 te                           \n",
       " 15                    East module            1 te            1 te           \n",
       " 16                    West Module           20 te      3 te\\n4 te           \n",
       " 17         Modular Living Quarter  550 te\\n191 te   138 te\\n42 te           \n",
       " 18                       Helideck           68 te                           \n",
       " 19                          Flare            2 te            6 te    4 te   \n",
       " 20          Pre Drilling Wellhead            5 te            6 te    5 te   \n",
       " 21    TOTAL TOPSIDES Gross Weight  885 te\\n948 te  242 te\\n281 te  185 te   \n",
       " 22    PREVIOUS REV.7 Gross Weight  908 te\\n908 te  215 te\\n225 te  185 te   \n",
       " 23  VARIATION FROM PREVIOUS REV.7   -23 te\\n40 te    27 te\\n56 te    0 te   \n",
       " \n",
       "           6       7      8        9     ...            11        12      13  \\\n",
       " 0                                       ...                                   \n",
       " 1         ME     PFP     SA  PA (ST)    ...          ST I     ST II  ST III   \n",
       " 2                                       ...                                   \n",
       " 3       4.3%    5.5%   6.4%     6.0%    ...          3.1%      3.5%    5.1%   \n",
       " 4       4.3%    5.5%   6.6%     6.0%    ...          3.1%      3.8%    5.8%   \n",
       " 5      13 te    2 te   0 te     2 te    ...         20 te     16 te    7 te   \n",
       " 6     611 te   48 te   4 te    47 te    ...        708 te    583 te   41 te   \n",
       " 7     288 te   29 te   3 te    19 te    ...        645 te    532 te   30 te   \n",
       " 8     451 te   22 te   4 te    17 te    ...        673 te    521 te   21 te   \n",
       " 9     262 te   31 te   4 te    12 te    ...        454 te    329 te   49 te   \n",
       " 10    987 te    7 te   3 te    18 te    ...        876 te    487 te   61 te   \n",
       " 11    284 te   22 te   2 te             ...                  141 te   40 te   \n",
       " 12     74 te    3 te   2 te     5 te    ...        168 te    159 te    5 te   \n",
       " 13     88 te                    2 te    ...                  121 te    8 te   \n",
       " 14     39 te                    1 te    ...                   54 te    5 te   \n",
       " 15     11 te                    0 te    ...         31 te     23 te    3 te   \n",
       " 16    107 te    1 te   0 te     5 te    ...        292 te     81 te   62 te   \n",
       " 17    138 te   16 te   7 te    21 te    ...        672 te    642 te  100 te   \n",
       " 18                                      ...                                   \n",
       " 19      5 te   25 te           10 te    ...        406 te    121 te   39 te   \n",
       " 20     19 te    8 te   1 te    10 te    ...        354 te    324 te   10 te   \n",
       " 21  3 376 te  213 te  30 te   169 te    ...      5 298 te  4 135 te  482 te   \n",
       " 22  3 360 te  209 te  34 te   169 te    ...      5 265 te  4 195 te  479 te   \n",
       " 23     17 te    4 te  -3 te     0 te    ...         33 te    -60 te    3 te   \n",
       " \n",
       "           14            15         16        17          18      19         20  \n",
       " 0                Permanent                   ME                          TOTAL  \n",
       " 1         ST  Installation  TOTAL DRY   content  PI content      LL  OPERATING  \n",
       " 2                     Aids                                                      \n",
       " 3       3.3%         10.7%       3.9%      3.8%        3.3%    0.0%       3.8%  \n",
       " 4       3.5%          8.9%       3.9%      3.8%        3.3%    0.0%       3.9%  \n",
       " 5      43 te                    86 te      3 te        3 te              92 te  \n",
       " 6   1 332 te                 2 431 te    798 te       34 te    8 te   3 270 te  \n",
       " 7   1 207 te                 2 035 te    123 te       58 te    8 te   2 223 te  \n",
       " 8   1 215 te                 2 090 te    119 te       45 te   15 te   2 269 te  \n",
       " 9     832 te                 1 534 te    110 te       54 te    6 te   1 704 te  \n",
       " 10  1 424 te                 2 786 te     76 te       34 te    8 te   2 903 te  \n",
       " 11    182 te                 1 167 te     36 te                       1 203 te  \n",
       " 12    332 te          7 te     600 te     97 te       12 te             708 te  \n",
       " 13    130 te                   229 te                                   229 te  \n",
       " 14     59 te                   114 te                                   114 te  \n",
       " 15     57 te                    80 te      0 te        1 te              81 te  \n",
       " 16    435 te                   591 te     17 te        5 te             614 te  \n",
       " 17  1 414 te                 2 609 te     12 te        8 te   86 te   2 716 te  \n",
       " 18                              68 te                         16 te      83 te  \n",
       " 19    565 te          4 te     668 te      1 te        2 te             671 te  \n",
       " 20    687 te          7 te     809 te     31 te       12 te   13 te     864 te  \n",
       " 21  9 915 te         18 te  17 897 te  1 423 te      266 te  158 te  19 744 te  \n",
       " 22  9 938 te         44 te  17 741 te  1 422 te      260 te  158 te  19 581 te  \n",
       " 23    -24 te        -26 te     155 te      1 te        6 te    0 te     163 te  \n",
       " \n",
       " [24 rows x 21 columns],\n",
       "                                                    0   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7   I<s>NTEGRATED</s><s>DECK</s><s>PHASE</s><s>103...   \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " \n",
       "                                                    1   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7   <s>L</s>I<s>FT</s>I<s>NG</s> / I<s>NSTALLAT</s...   \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " \n",
       "                                2       3       4      5       6       7   \\\n",
       " 0                      DISCIPLINE      AR      EL     HV      IN      IN   \n",
       " 1                         SUBAREA                                 Valves   \n",
       " 2            Included Contingency    5.0%    5.2%   5.6%    5.2%    5.0%   \n",
       " 3      Previous Rev.7 Contingency    5.0%    5.1%   5.0%    5.2%    5.0%   \n",
       " 4    Integrated Below Cellar Deck            1 te           1 te   13 te   \n",
       " 5          Integrated Cellar Deck          134 te          35 te   32 te   \n",
       " 6           Integrated Lower Deck           89 te          32 te   73 te   \n",
       " 7    Integrated Intermediate Deck           96 te          29 te   15 te   \n",
       " 8           Integrated Upper Deck           94 te          32 te   16 te   \n",
       " 9         Integrated Weather Deck           48 te          18 te    6 te   \n",
       " 10      Integrated Living Quarter  168 te  228 te  88 te   65 te           \n",
       " 11  TOTAL INTEGRATED Gross Weight  168 te  690 te  88 te  211 te  155 te   \n",
       " 12    PREVIOUS REV.7 Gross Weight  159 te  671 te  77 te  168 te  155 te   \n",
       " 13  VARIATION FROM PREVIOUS REV.7    8 te   20 te  10 te   43 te    0 te   \n",
       " \n",
       "           8       9      10       11        12        13        14      15  \\\n",
       " 0         ME     PFP     SA  PA (ST)        PI      ST I     ST II  ST III   \n",
       " 1                                                                            \n",
       " 2       3.6%    5.0%   5.0%     5.0%      3.2%      3.0%      3.0%    5.0%   \n",
       " 3       3.6%    5.0%   5.0%     5.0%      3.2%      3.0%      3.1%    5.0%   \n",
       " 4      13 te    2 te   0 te     1 te      9 te     20 te     15 te    7 te   \n",
       " 5     375 te   48 te   4 te    46 te    165 te    707 te    563 te   34 te   \n",
       " 6     268 te   29 te   3 te    19 te    294 te    636 te    519 te   25 te   \n",
       " 7     451 te   22 te   4 te    17 te    240 te    673 te    513 te   16 te   \n",
       " 8     262 te   31 te   4 te    11 te    252 te    448 te    319 te   47 te   \n",
       " 9     202 te    7 te   3 te    17 te    238 te    809 te    411 te   33 te   \n",
       " 10    233 te   22 te   2 te               5 te              133 te   37 te   \n",
       " 11  1 804 te  162 te  20 te   112 te  1 203 te  3 293 te  2 473 te  199 te   \n",
       " 12  1 791 te  161 te  21 te   112 te  1 127 te  3 331 te  2 465 te  194 te   \n",
       " 13     14 te    0 te  -1 te     0 te     76 te    -38 te      8 te    5 te   \n",
       " \n",
       "           16          17         18  \n",
       " 0         ST  T & I Aids      TOTAL  \n",
       " 1                           LIFTING  \n",
       " 2       3.1%        8.1%       3.6%  \n",
       " 3       3.1%        8.7%       3.6%  \n",
       " 4      42 te                  82 te  \n",
       " 5   1 304 te       22 te   2 166 te  \n",
       " 6   1 181 te       11 te   2 000 te  \n",
       " 7   1 202 te       21 te   2 097 te  \n",
       " 8     814 te       62 te   1 578 te  \n",
       " 9   1 253 te       88 te   1 879 te  \n",
       " 10    170 te                 980 te  \n",
       " 11  5 965 te      204 te  10 782 te  \n",
       " 12  5 990 te      206 te  10 639 te  \n",
       " 13    -25 te       -2 te     142 te  ]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "empty spaces represents 0.279778  of the dataframe\n",
      "empty spaces represents 0.174603  of the dataframe using STREAM parameter \n",
      "empty spaces represents 0.271825  of the dataframe\n",
      "empty spaces represents 0.174603  of the dataframe using STREAM parameter \n",
      "empty spaces represents 0.214286  of the dataframe\n",
      "empty spaces represents 0.174603  of the dataframe using STREAM parameter \n"
     ]
    }
   ],
   "source": [
    "'''\n",
    "Evaluation et extraction de titre de tableau\n",
    "\n",
    "'''\n",
    "\n",
    "def TransformFieldsInString(df):\n",
    "    rows = []\n",
    "    for i in range(len(df)):\n",
    "        row=[]\n",
    "        for col in df.columns:\n",
    "            row.append(df[col][i])\n",
    "        rows.append(row)\n",
    "    A = np.array(rows)        \n",
    "    data = pd.DataFrame(A)        \n",
    "    data.columns = df.columns   \n",
    "    return data \n",
    "\n",
    "def FindFirstNumber(df):\n",
    "    test= False\n",
    "    i = 0\n",
    "    while (i<len(df) and test==False):\n",
    "        h=0\n",
    "        while(h<len(df.columns) and test==False):\n",
    "            col = df.columns[h]\n",
    "            if (VerifyNumber(str(df[col][i]))):\n",
    "                test=True\n",
    "            else :\n",
    "                h = h+1\n",
    "        if (h == len(df.columns) and test ==False):\n",
    "            i=i+1\n",
    "    return i   \n",
    "\n",
    "def Evalute_Columns_Homogenity(df,colum_name,first_value_index):\n",
    "    l = list(df[colum_name][first_value_index:len(df)])\n",
    "    types =[\"string\",\"int\",\"float\",\"None\",\"BLANK\"]\n",
    "    (string,integer,real,NoneType,BLANK) = (0,0,0,0,0)\n",
    "    for i in range(len(l)):\n",
    "\n",
    "        if (str(regDataType(l[i])) == \"STRING\"):\n",
    "            string = string+1\n",
    "        elif (str(regDataType(l[i])) == \"BLANK\"):\n",
    "            BLANK = BLANK+1\n",
    "        elif (str(regDataType(l[i])) == \"INT\"):\n",
    "            integer = integer+1\n",
    "        elif (str(regDataType(l[i])) == \"FLOAT\"):\n",
    "            real = real+1\n",
    "        else:\n",
    "            NoneType = NoneType+1\n",
    "            \n",
    "    string_pourcentage = string /len(l)\n",
    "    integer_pourcentage = integer / len(l)\n",
    "    real_pourcentage = real / len(l)\n",
    "    NoneType_pourcentage = NoneType / len(l)\n",
    "    Homogenity = max(string_pourcentage,integer_pourcentage,real_pourcentage,NoneType_pourcentage)\n",
    "    return Homogenity\n",
    "\n",
    "def regDataType(str):\n",
    "    str=str.strip()\n",
    "    if len(str) == 0: return 'BLANK'\n",
    "\n",
    "\n",
    "    if re.match(r'([-+]\\s*)?\\d+\\s?\\d*$|([-+]\\s*)?\\d+\\s?\\d*\\s?\\D{1,2}$', str): \n",
    "        return 'INT'\n",
    "    if re.match(r'([-+]\\s*)?\\d+\\s?\\d*[.,]?\\d*$|([-+]\\s*)?\\d+\\s?\\d*[.,]?\\d*\\s?\\D{1,2}$', str): \n",
    "        return 'FLOAT'\n",
    "\n",
    "    return 'STRING' \n",
    "def Evaluate_Columns_Concatenation(df,column,first_value):\n",
    "    l = list(df[column][first_value:len(df)])\n",
    "    s = 0\n",
    "    for i in range(len(l)):\n",
    "        if ('\\n' in l[i]  or '\\s' in l[i]):\n",
    "            s = s + 1\n",
    "    NonConcatenation = (1 -s/len(l))\n",
    "    return  NonConcatenation\n",
    "\n",
    "def VerifyNumber(string):\n",
    "    if regDataType(string)=='INT'or regDataType(string)=='FLOAT':\n",
    "        return True\n",
    "    return False\n",
    "        \n",
    "def Evaluation(df,k):\n",
    "\n",
    "    GlobalHomogenity = sum(Evalute_Columns_Homogenity(df,colum_name,k) for colum_name in df.columns)/len(df.columns)\n",
    "    GlobalNonConcatenation = sum(Evaluate_Columns_Concatenation(df,colum_name,k) for colum_name in df.columns)/len(df.columns)    \n",
    "    \n",
    "    return (GlobalHomogenity,GlobalNonConcatenation)\n",
    "\n",
    "def getHeaderTable(df,k):\n",
    "    rows=[]\n",
    "    for i in range(0,k):\n",
    "        row=[]\n",
    "        for j in range(len(df.columns)):\n",
    "            row.append(df[j][i])\n",
    "          \n",
    "        rows.append(row)\n",
    "    tab = np.array(rows)        \n",
    "    df1 = pd.DataFrame(tab)        \n",
    "    \n",
    "    if len(df1)==1:\n",
    "        cols=rows\n",
    "    else:\n",
    "        cols=[]\n",
    "        for i in range(len(df1.columns)):\n",
    "            nameCol=''\n",
    "            for j in range (len(df1)):\n",
    "                \n",
    "                nameCol= nameCol + ' ' + df1[i][j]\n",
    "            cols.append(nameCol)\n",
    "    return cols\n",
    "\n",
    "\n",
    "def emptyCellsPourcentage(df):\n",
    "    dfNan=df.replace('', np.nan)\n",
    "    pourcentage_empty= dfNan.isnull().sum().sum()/(len(dfNan)*len(dfNan.columns))\n",
    "    return pourcentage_empty\n",
    "\n",
    "\n",
    "if x==1:\n",
    "    tablesStream = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=4,flag_size=True) \n",
    "\n",
    "    pourcentage_empty1= emptyCellsPourcentage(tables)\n",
    "    pourcentage_empty2= emptyCellsPourcentage(tablesStream[0].df)\n",
    "\n",
    "    print(\"empty spaces represents %f  of the dataframe\"%pourcentage_empty1)\n",
    "    print(\"empty spaces represents %f  of the dataframe using STREAM parameter \"%pourcentage_empty2)\n",
    "\n",
    "    if pourcentage_empty1>= 0.3 and pourcentage_empty2<pourcentage_empty1:\n",
    "        print(\"we try with stream : detection automatique\")\n",
    "        final0=tablesStream[0].df\n",
    "    else:\n",
    "        final0=tables\n",
    "\n",
    "    \n",
    "\n",
    "elif x>1:\n",
    "    final0=[]\n",
    "    for i in range(x):\n",
    "        tablesStream = camelot.read_pdf(os.path.join(DATAPATH, INPUT_PDF),flavor='stream',row_tol=4,flag_size=True) \n",
    "\n",
    "        pourcentage_empty1= emptyCellsPourcentage(tables[i])\n",
    "        pourcentage_empty2= emptyCellsPourcentage(tablesStream[0].df)\n",
    "\n",
    "        print(\"empty spaces represents %f  of the dataframe\"%pourcentage_empty1)\n",
    "        print(\"empty spaces represents %f  of the dataframe using STREAM parameter \"%pourcentage_empty2)\n",
    "\n",
    "        if pourcentage_empty1>= 0.3 and pourcentage_empty2<pourcentage_empty1:\n",
    "            print(\"we try with stream : detection automatique\")\n",
    "            final0.append(tablesStream[0].df)\n",
    "        else:\n",
    "            final0.append(tables[i])\n",
    "            \n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[                           0             1                              2   \\\n",
       " 0                                                               DISCIPLINE   \n",
       " 1                                                                  SUBAREA   \n",
       " 2                                                     Included Contingency   \n",
       " 3                                               Previous Rev.7 Contingency   \n",
       " 4                                             Integrated Below Cellar Deck   \n",
       " 5                                                   Integrated Cellar Deck   \n",
       " 6                                                    Integrated Lower Deck   \n",
       " 7                                             Integrated Intermediate Deck   \n",
       " 8                                                    Integrated Upper Deck   \n",
       " 9   INTEGRATED DECK PHASE 104  DRY IN PLACE        Integrated Weather Deck   \n",
       " 10                                               Integrated Living Quarter   \n",
       " 11                                                                Top Deck   \n",
       " 12                                                       GTG Exhaust stack   \n",
       " 13                                                         GTG Inlet stack   \n",
       " 14                                                              East modue   \n",
       " 15                                                             West module   \n",
       " 16                                           TOTAL INTEGRATED Gross Weight   \n",
       " 17                                             PREVIOUS REV.7 Gross Weight   \n",
       " 18                                           VARIATION FROM PREVIOUS REV.7   \n",
       " \n",
       "         3       4       5       6       7         8       9      10       11  \\\n",
       " 0       AR      EL      HV      IN      IN        ME     PFP     SA  PA (ST)   \n",
       " 1                                   Valves                                     \n",
       " 2     6.8%    5.2%    6.0%    5.2%    5.0%      4.3%    5.0%   5.4%     5.0%   \n",
       " 3     6.9%    5.1%    5.0%    5.2%    5.0%      4.3%    5.0%   5.7%     5.0%   \n",
       " 4             1 te            1 te   13 te     13 te    2 te   0 te     2 te   \n",
       " 5           134 te           35 te   32 te    611 te   48 te   4 te    47 te   \n",
       " 6            89 te           32 te   73 te    288 te   29 te   3 te    19 te   \n",
       " 7            96 te           29 te   15 te    451 te   22 te   4 te    17 te   \n",
       " 8            94 te           32 te   16 te    262 te   31 te   4 te    12 te   \n",
       " 9            55 te           18 te   14 te    987 te    7 te   3 te    18 te   \n",
       " 10  267 te  235 te  101 te   70 te            284 te   22 te   2 te            \n",
       " 11           14 te            6 te   12 te     74 te    3 te   2 te     5 te   \n",
       " 12                                             88 te                    2 te   \n",
       " 13           10 te                             39 te                    1 te   \n",
       " 14            1 te            1 te             11 te                    0 te   \n",
       " 15           20 te    3 te    4 te            107 te    1 te   0 te     5 te   \n",
       " 16  267 te  749 te  104 te  227 te  176 te  3 214 te  165 te  22 te   128 te   \n",
       " 17  258 te  730 te   84 te  179 te  176 te  3 202 te  164 te  25 te   129 te   \n",
       " 18    8 te   20 te   20 te   48 te    0 te     12 te    0 te  -3 te     0 te   \n",
       " \n",
       "           12        13        14      15        16          17         18  \n",
       " 0         PI      ST I     ST II  ST III        ST  T & I Aids  TOTAL DRY  \n",
       " 1                                                                          \n",
       " 2       3.3%      3.1%      3.5%    5.6%      3.4%       20.0%       3.7%  \n",
       " 3       3.3%      3.1%      3.8%    5.8%      3.6%       10.0%       3.7%  \n",
       " 4      12 te     20 te     16 te    7 te     43 te                  86 te  \n",
       " 5     189 te    708 te    583 te   41 te  1 332 te               2 431 te  \n",
       " 6     294 te    645 te    532 te   30 te  1 207 te               2 035 te  \n",
       " 7     240 te    673 te    521 te   21 te  1 215 te               2 090 te  \n",
       " 8     252 te    454 te    329 te   49 te    832 te               1 534 te  \n",
       " 9     260 te    876 te    487 te   61 te  1 424 te               2 786 te  \n",
       " 10      5 te              141 te   40 te    182 te               1 167 te  \n",
       " 11    144 te    168 te    159 te    5 te    332 te        7 te     600 te  \n",
       " 12      9 te              121 te    8 te    130 te                 229 te  \n",
       " 13      5 te               54 te    5 te     59 te                 114 te  \n",
       " 14      9 te     31 te     23 te    3 te     57 te                  80 te  \n",
       " 15     17 te    292 te     81 te   62 te    435 te                 591 te  \n",
       " 16  1 436 te  3 867 te  3 049 te  333 te  7 248 te        7 te  13 743 te  \n",
       " 17  1 362 te  3 841 te  3 115 te  333 te  7 289 te       33 te  13 630 te  \n",
       " 18     74 te     26 te    -66 te    0 te    -41 te      -26 te     112 te  ,\n",
       "                           0                        1   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7                                                       \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " 14  TOPSIDES PHASE 104 - 106  IN PLACE WITHOUT FUTURE   \n",
       " 15                                                      \n",
       " 16                                                      \n",
       " 17                                                      \n",
       " 18                                                      \n",
       " 19                                                      \n",
       " 20                                                      \n",
       " 21                                                      \n",
       " 22                                                      \n",
       " 23                                                      \n",
       " \n",
       "                                2               3               4       5   \\\n",
       " 0                      DISCIPLINE                                      IN   \n",
       " 1                         SUBAREA      AR\\nEL\\nHV              IN  Valves   \n",
       " 2                                                                           \n",
       " 3            Included Contingency      5.3%\\n5.3%      5.6%\\n5.3%    4.9%   \n",
       " 4      Previous Rev.7 Contingency      5.3%\\n5.1%      5.0%\\n5.4%    4.9%   \n",
       " 5    Integrated Below Cellar Deck            1 te            1 te   13 te   \n",
       " 6          Integrated Cellar Deck          134 te           35 te   32 te   \n",
       " 7           Integrated Lower Deck           89 te           32 te   73 te   \n",
       " 8    Integrated Intermediate Deck           96 te           29 te   15 te   \n",
       " 9           Integrated Upper Deck           94 te           32 te   16 te   \n",
       " 10        Integrated Weather Deck           55 te           18 te   14 te   \n",
       " 11      Integrated Living Quarter  267 te\\n235 te   101 te\\n70 te           \n",
       " 12                       Top Deck           14 te            6 te   12 te   \n",
       " 13              GTG Exhaust stack                                           \n",
       " 14                GTG Inlet stack           10 te                           \n",
       " 15                    East module            1 te            1 te           \n",
       " 16                    West Module           20 te      3 te\\n4 te           \n",
       " 17         Modular Living Quarter  550 te\\n191 te   138 te\\n42 te           \n",
       " 18                       Helideck           68 te                           \n",
       " 19                          Flare            2 te            6 te    4 te   \n",
       " 20          Pre Drilling Wellhead            5 te            6 te    5 te   \n",
       " 21    TOTAL TOPSIDES Gross Weight  885 te\\n948 te  242 te\\n281 te  185 te   \n",
       " 22    PREVIOUS REV.7 Gross Weight  908 te\\n908 te  215 te\\n225 te  185 te   \n",
       " 23  VARIATION FROM PREVIOUS REV.7   -23 te\\n40 te    27 te\\n56 te    0 te   \n",
       " \n",
       "           6       7      8        9     ...            11        12      13  \\\n",
       " 0                                       ...                                   \n",
       " 1         ME     PFP     SA  PA (ST)    ...          ST I     ST II  ST III   \n",
       " 2                                       ...                                   \n",
       " 3       4.3%    5.5%   6.4%     6.0%    ...          3.1%      3.5%    5.1%   \n",
       " 4       4.3%    5.5%   6.6%     6.0%    ...          3.1%      3.8%    5.8%   \n",
       " 5      13 te    2 te   0 te     2 te    ...         20 te     16 te    7 te   \n",
       " 6     611 te   48 te   4 te    47 te    ...        708 te    583 te   41 te   \n",
       " 7     288 te   29 te   3 te    19 te    ...        645 te    532 te   30 te   \n",
       " 8     451 te   22 te   4 te    17 te    ...        673 te    521 te   21 te   \n",
       " 9     262 te   31 te   4 te    12 te    ...        454 te    329 te   49 te   \n",
       " 10    987 te    7 te   3 te    18 te    ...        876 te    487 te   61 te   \n",
       " 11    284 te   22 te   2 te             ...                  141 te   40 te   \n",
       " 12     74 te    3 te   2 te     5 te    ...        168 te    159 te    5 te   \n",
       " 13     88 te                    2 te    ...                  121 te    8 te   \n",
       " 14     39 te                    1 te    ...                   54 te    5 te   \n",
       " 15     11 te                    0 te    ...         31 te     23 te    3 te   \n",
       " 16    107 te    1 te   0 te     5 te    ...        292 te     81 te   62 te   \n",
       " 17    138 te   16 te   7 te    21 te    ...        672 te    642 te  100 te   \n",
       " 18                                      ...                                   \n",
       " 19      5 te   25 te           10 te    ...        406 te    121 te   39 te   \n",
       " 20     19 te    8 te   1 te    10 te    ...        354 te    324 te   10 te   \n",
       " 21  3 376 te  213 te  30 te   169 te    ...      5 298 te  4 135 te  482 te   \n",
       " 22  3 360 te  209 te  34 te   169 te    ...      5 265 te  4 195 te  479 te   \n",
       " 23     17 te    4 te  -3 te     0 te    ...         33 te    -60 te    3 te   \n",
       " \n",
       "           14            15         16        17          18      19         20  \n",
       " 0                Permanent                   ME                          TOTAL  \n",
       " 1         ST  Installation  TOTAL DRY   content  PI content      LL  OPERATING  \n",
       " 2                     Aids                                                      \n",
       " 3       3.3%         10.7%       3.9%      3.8%        3.3%    0.0%       3.8%  \n",
       " 4       3.5%          8.9%       3.9%      3.8%        3.3%    0.0%       3.9%  \n",
       " 5      43 te                    86 te      3 te        3 te              92 te  \n",
       " 6   1 332 te                 2 431 te    798 te       34 te    8 te   3 270 te  \n",
       " 7   1 207 te                 2 035 te    123 te       58 te    8 te   2 223 te  \n",
       " 8   1 215 te                 2 090 te    119 te       45 te   15 te   2 269 te  \n",
       " 9     832 te                 1 534 te    110 te       54 te    6 te   1 704 te  \n",
       " 10  1 424 te                 2 786 te     76 te       34 te    8 te   2 903 te  \n",
       " 11    182 te                 1 167 te     36 te                       1 203 te  \n",
       " 12    332 te          7 te     600 te     97 te       12 te             708 te  \n",
       " 13    130 te                   229 te                                   229 te  \n",
       " 14     59 te                   114 te                                   114 te  \n",
       " 15     57 te                    80 te      0 te        1 te              81 te  \n",
       " 16    435 te                   591 te     17 te        5 te             614 te  \n",
       " 17  1 414 te                 2 609 te     12 te        8 te   86 te   2 716 te  \n",
       " 18                              68 te                         16 te      83 te  \n",
       " 19    565 te          4 te     668 te      1 te        2 te             671 te  \n",
       " 20    687 te          7 te     809 te     31 te       12 te   13 te     864 te  \n",
       " 21  9 915 te         18 te  17 897 te  1 423 te      266 te  158 te  19 744 te  \n",
       " 22  9 938 te         44 te  17 741 te  1 422 te      260 te  158 te  19 581 te  \n",
       " 23    -24 te        -26 te     155 te      1 te        6 te    0 te     163 te  \n",
       " \n",
       " [24 rows x 21 columns],\n",
       "                                                    0   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7   I<s>NTEGRATED</s><s>DECK</s><s>PHASE</s><s>103...   \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " \n",
       "                                                    1   \\\n",
       " 0                                                       \n",
       " 1                                                       \n",
       " 2                                                       \n",
       " 3                                                       \n",
       " 4                                                       \n",
       " 5                                                       \n",
       " 6                                                       \n",
       " 7   <s>L</s>I<s>FT</s>I<s>NG</s> / I<s>NSTALLAT</s...   \n",
       " 8                                                       \n",
       " 9                                                       \n",
       " 10                                                      \n",
       " 11                                                      \n",
       " 12                                                      \n",
       " 13                                                      \n",
       " \n",
       "                                2       3       4      5       6       7   \\\n",
       " 0                      DISCIPLINE      AR      EL     HV      IN      IN   \n",
       " 1                         SUBAREA                                 Valves   \n",
       " 2            Included Contingency    5.0%    5.2%   5.6%    5.2%    5.0%   \n",
       " 3      Previous Rev.7 Contingency    5.0%    5.1%   5.0%    5.2%    5.0%   \n",
       " 4    Integrated Below Cellar Deck            1 te           1 te   13 te   \n",
       " 5          Integrated Cellar Deck          134 te          35 te   32 te   \n",
       " 6           Integrated Lower Deck           89 te          32 te   73 te   \n",
       " 7    Integrated Intermediate Deck           96 te          29 te   15 te   \n",
       " 8           Integrated Upper Deck           94 te          32 te   16 te   \n",
       " 9         Integrated Weather Deck           48 te          18 te    6 te   \n",
       " 10      Integrated Living Quarter  168 te  228 te  88 te   65 te           \n",
       " 11  TOTAL INTEGRATED Gross Weight  168 te  690 te  88 te  211 te  155 te   \n",
       " 12    PREVIOUS REV.7 Gross Weight  159 te  671 te  77 te  168 te  155 te   \n",
       " 13  VARIATION FROM PREVIOUS REV.7    8 te   20 te  10 te   43 te    0 te   \n",
       " \n",
       "           8       9      10       11        12        13        14      15  \\\n",
       " 0         ME     PFP     SA  PA (ST)        PI      ST I     ST II  ST III   \n",
       " 1                                                                            \n",
       " 2       3.6%    5.0%   5.0%     5.0%      3.2%      3.0%      3.0%    5.0%   \n",
       " 3       3.6%    5.0%   5.0%     5.0%      3.2%      3.0%      3.1%    5.0%   \n",
       " 4      13 te    2 te   0 te     1 te      9 te     20 te     15 te    7 te   \n",
       " 5     375 te   48 te   4 te    46 te    165 te    707 te    563 te   34 te   \n",
       " 6     268 te   29 te   3 te    19 te    294 te    636 te    519 te   25 te   \n",
       " 7     451 te   22 te   4 te    17 te    240 te    673 te    513 te   16 te   \n",
       " 8     262 te   31 te   4 te    11 te    252 te    448 te    319 te   47 te   \n",
       " 9     202 te    7 te   3 te    17 te    238 te    809 te    411 te   33 te   \n",
       " 10    233 te   22 te   2 te               5 te              133 te   37 te   \n",
       " 11  1 804 te  162 te  20 te   112 te  1 203 te  3 293 te  2 473 te  199 te   \n",
       " 12  1 791 te  161 te  21 te   112 te  1 127 te  3 331 te  2 465 te  194 te   \n",
       " 13     14 te    0 te  -1 te     0 te     76 te    -38 te      8 te    5 te   \n",
       " \n",
       "           16          17         18  \n",
       " 0         ST  T & I Aids      TOTAL  \n",
       " 1                           LIFTING  \n",
       " 2       3.1%        8.1%       3.6%  \n",
       " 3       3.1%        8.7%       3.6%  \n",
       " 4      42 te                  82 te  \n",
       " 5   1 304 te       22 te   2 166 te  \n",
       " 6   1 181 te       11 te   2 000 te  \n",
       " 7   1 202 te       21 te   2 097 te  \n",
       " 8     814 te       62 te   1 578 te  \n",
       " 9   1 253 te       88 te   1 879 te  \n",
       " 10    170 te                 980 te  \n",
       " 11  5 965 te      204 te  10 782 te  \n",
       " 12  5 990 te      206 te  10 639 te  \n",
       " 13    -25 te       -2 te     142 te  ]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "**\n",
      "evaluation pour table 0 = 0,1\n",
      "**\n",
      "evaluation pour table 1 = 0,0\n",
      "**\n",
      "evaluation pour table 2 = 0,1\n"
     ]
    }
   ],
   "source": [
    "finalDataframes=[]\n",
    "if x ==1:\n",
    "    df0=TransformFieldsInString(final0)\n",
    "    k = FindFirstNumber(df0)\n",
    "    (e1,e2)=Evaluation(df0,k)\n",
    "    print(\"evaluation du table %d,%d\"%(e1,e2))\n",
    "\n",
    "    header =getHeaderTable(final0,k)\n",
    "    df = final0.iloc[k:]\n",
    "    df.columns = header\n",
    "    finalDataframes.append(df)\n",
    "elif x>1:\n",
    "    for i in range(x):\n",
    "        df0=TransformFieldsInString(final0[i])\n",
    "\n",
    "        k = FindFirstNumber(df0)\n",
    "        print('**')\n",
    "        (e1,e2)=Evaluation(df0,k)\n",
    "        print(\"evaluation pour table %d = %d,%d\"%(i,e1,e2))\n",
    "        header =getHeaderTable(final0[i],k)\n",
    "        df = final0[i].iloc[k:]\n",
    "        df.columns = header\n",
    "        finalDataframes.append(df)\n",
    "\n",
    "    \n",
    "for i in range(len(finalDataframes)):\n",
    "    finalDataframes[i]\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "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></th>\n",
       "      <th></th>\n",
       "      <th>DISCIPLINE SUBAREA</th>\n",
       "      <th>AR</th>\n",
       "      <th>EL</th>\n",
       "      <th>HV</th>\n",
       "      <th>IN</th>\n",
       "      <th>IN Valves</th>\n",
       "      <th>ME</th>\n",
       "      <th>PFP</th>\n",
       "      <th>SA</th>\n",
       "      <th>PA (ST)</th>\n",
       "      <th>PI</th>\n",
       "      <th>ST I</th>\n",
       "      <th>ST II</th>\n",
       "      <th>ST III</th>\n",
       "      <th>ST</th>\n",
       "      <th>T &amp; I Aids</th>\n",
       "      <th>TOTAL DRY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Included Contingency</td>\n",
       "      <td>6.8%</td>\n",
       "      <td>5.2%</td>\n",
       "      <td>6.0%</td>\n",
       "      <td>5.2%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>4.3%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>5.4%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>3.3%</td>\n",
       "      <td>3.1%</td>\n",
       "      <td>3.5%</td>\n",
       "      <td>5.6%</td>\n",
       "      <td>3.4%</td>\n",
       "      <td>20.0%</td>\n",
       "      <td>3.7%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Previous Rev.7 Contingency</td>\n",
       "      <td>6.9%</td>\n",
       "      <td>5.1%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>5.2%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>4.3%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>5.7%</td>\n",
       "      <td>5.0%</td>\n",
       "      <td>3.3%</td>\n",
       "      <td>3.1%</td>\n",
       "      <td>3.8%</td>\n",
       "      <td>5.8%</td>\n",
       "      <td>3.6%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>3.7%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Below Cellar Deck</td>\n",
       "      <td></td>\n",
       "      <td>1 te</td>\n",
       "      <td></td>\n",
       "      <td>1 te</td>\n",
       "      <td>13 te</td>\n",
       "      <td>13 te</td>\n",
       "      <td>2 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>2 te</td>\n",
       "      <td>12 te</td>\n",
       "      <td>20 te</td>\n",
       "      <td>16 te</td>\n",
       "      <td>7 te</td>\n",
       "      <td>43 te</td>\n",
       "      <td></td>\n",
       "      <td>86 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Cellar Deck</td>\n",
       "      <td></td>\n",
       "      <td>134 te</td>\n",
       "      <td></td>\n",
       "      <td>35 te</td>\n",
       "      <td>32 te</td>\n",
       "      <td>611 te</td>\n",
       "      <td>48 te</td>\n",
       "      <td>4 te</td>\n",
       "      <td>47 te</td>\n",
       "      <td>189 te</td>\n",
       "      <td>708 te</td>\n",
       "      <td>583 te</td>\n",
       "      <td>41 te</td>\n",
       "      <td>1 332 te</td>\n",
       "      <td></td>\n",
       "      <td>2 431 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Lower Deck</td>\n",
       "      <td></td>\n",
       "      <td>89 te</td>\n",
       "      <td></td>\n",
       "      <td>32 te</td>\n",
       "      <td>73 te</td>\n",
       "      <td>288 te</td>\n",
       "      <td>29 te</td>\n",
       "      <td>3 te</td>\n",
       "      <td>19 te</td>\n",
       "      <td>294 te</td>\n",
       "      <td>645 te</td>\n",
       "      <td>532 te</td>\n",
       "      <td>30 te</td>\n",
       "      <td>1 207 te</td>\n",
       "      <td></td>\n",
       "      <td>2 035 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Intermediate Deck</td>\n",
       "      <td></td>\n",
       "      <td>96 te</td>\n",
       "      <td></td>\n",
       "      <td>29 te</td>\n",
       "      <td>15 te</td>\n",
       "      <td>451 te</td>\n",
       "      <td>22 te</td>\n",
       "      <td>4 te</td>\n",
       "      <td>17 te</td>\n",
       "      <td>240 te</td>\n",
       "      <td>673 te</td>\n",
       "      <td>521 te</td>\n",
       "      <td>21 te</td>\n",
       "      <td>1 215 te</td>\n",
       "      <td></td>\n",
       "      <td>2 090 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Upper Deck</td>\n",
       "      <td></td>\n",
       "      <td>94 te</td>\n",
       "      <td></td>\n",
       "      <td>32 te</td>\n",
       "      <td>16 te</td>\n",
       "      <td>262 te</td>\n",
       "      <td>31 te</td>\n",
       "      <td>4 te</td>\n",
       "      <td>12 te</td>\n",
       "      <td>252 te</td>\n",
       "      <td>454 te</td>\n",
       "      <td>329 te</td>\n",
       "      <td>49 te</td>\n",
       "      <td>832 te</td>\n",
       "      <td></td>\n",
       "      <td>1 534 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>INTEGRATED DECK PHASE 104</td>\n",
       "      <td>DRY IN PLACE</td>\n",
       "      <td>Integrated Weather Deck</td>\n",
       "      <td></td>\n",
       "      <td>55 te</td>\n",
       "      <td></td>\n",
       "      <td>18 te</td>\n",
       "      <td>14 te</td>\n",
       "      <td>987 te</td>\n",
       "      <td>7 te</td>\n",
       "      <td>3 te</td>\n",
       "      <td>18 te</td>\n",
       "      <td>260 te</td>\n",
       "      <td>876 te</td>\n",
       "      <td>487 te</td>\n",
       "      <td>61 te</td>\n",
       "      <td>1 424 te</td>\n",
       "      <td></td>\n",
       "      <td>2 786 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Integrated Living Quarter</td>\n",
       "      <td>267 te</td>\n",
       "      <td>235 te</td>\n",
       "      <td>101 te</td>\n",
       "      <td>70 te</td>\n",
       "      <td></td>\n",
       "      <td>284 te</td>\n",
       "      <td>22 te</td>\n",
       "      <td>2 te</td>\n",
       "      <td></td>\n",
       "      <td>5 te</td>\n",
       "      <td></td>\n",
       "      <td>141 te</td>\n",
       "      <td>40 te</td>\n",
       "      <td>182 te</td>\n",
       "      <td></td>\n",
       "      <td>1 167 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Top Deck</td>\n",
       "      <td></td>\n",
       "      <td>14 te</td>\n",
       "      <td></td>\n",
       "      <td>6 te</td>\n",
       "      <td>12 te</td>\n",
       "      <td>74 te</td>\n",
       "      <td>3 te</td>\n",
       "      <td>2 te</td>\n",
       "      <td>5 te</td>\n",
       "      <td>144 te</td>\n",
       "      <td>168 te</td>\n",
       "      <td>159 te</td>\n",
       "      <td>5 te</td>\n",
       "      <td>332 te</td>\n",
       "      <td>7 te</td>\n",
       "      <td>600 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>GTG Exhaust stack</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>88 te</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2 te</td>\n",
       "      <td>9 te</td>\n",
       "      <td></td>\n",
       "      <td>121 te</td>\n",
       "      <td>8 te</td>\n",
       "      <td>130 te</td>\n",
       "      <td></td>\n",
       "      <td>229 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>GTG Inlet stack</td>\n",
       "      <td></td>\n",
       "      <td>10 te</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>39 te</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>1 te</td>\n",
       "      <td>5 te</td>\n",
       "      <td></td>\n",
       "      <td>54 te</td>\n",
       "      <td>5 te</td>\n",
       "      <td>59 te</td>\n",
       "      <td></td>\n",
       "      <td>114 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>East modue</td>\n",
       "      <td></td>\n",
       "      <td>1 te</td>\n",
       "      <td></td>\n",
       "      <td>1 te</td>\n",
       "      <td></td>\n",
       "      <td>11 te</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>0 te</td>\n",
       "      <td>9 te</td>\n",
       "      <td>31 te</td>\n",
       "      <td>23 te</td>\n",
       "      <td>3 te</td>\n",
       "      <td>57 te</td>\n",
       "      <td></td>\n",
       "      <td>80 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>West module</td>\n",
       "      <td></td>\n",
       "      <td>20 te</td>\n",
       "      <td>3 te</td>\n",
       "      <td>4 te</td>\n",
       "      <td></td>\n",
       "      <td>107 te</td>\n",
       "      <td>1 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>5 te</td>\n",
       "      <td>17 te</td>\n",
       "      <td>292 te</td>\n",
       "      <td>81 te</td>\n",
       "      <td>62 te</td>\n",
       "      <td>435 te</td>\n",
       "      <td></td>\n",
       "      <td>591 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>TOTAL INTEGRATED Gross Weight</td>\n",
       "      <td>267 te</td>\n",
       "      <td>749 te</td>\n",
       "      <td>104 te</td>\n",
       "      <td>227 te</td>\n",
       "      <td>176 te</td>\n",
       "      <td>3 214 te</td>\n",
       "      <td>165 te</td>\n",
       "      <td>22 te</td>\n",
       "      <td>128 te</td>\n",
       "      <td>1 436 te</td>\n",
       "      <td>3 867 te</td>\n",
       "      <td>3 049 te</td>\n",
       "      <td>333 te</td>\n",
       "      <td>7 248 te</td>\n",
       "      <td>7 te</td>\n",
       "      <td>13 743 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>PREVIOUS REV.7 Gross Weight</td>\n",
       "      <td>258 te</td>\n",
       "      <td>730 te</td>\n",
       "      <td>84 te</td>\n",
       "      <td>179 te</td>\n",
       "      <td>176 te</td>\n",
       "      <td>3 202 te</td>\n",
       "      <td>164 te</td>\n",
       "      <td>25 te</td>\n",
       "      <td>129 te</td>\n",
       "      <td>1 362 te</td>\n",
       "      <td>3 841 te</td>\n",
       "      <td>3 115 te</td>\n",
       "      <td>333 te</td>\n",
       "      <td>7 289 te</td>\n",
       "      <td>33 te</td>\n",
       "      <td>13 630 te</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>VARIATION FROM PREVIOUS REV.7</td>\n",
       "      <td>8 te</td>\n",
       "      <td>20 te</td>\n",
       "      <td>20 te</td>\n",
       "      <td>48 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>12 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>-3 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>74 te</td>\n",
       "      <td>26 te</td>\n",
       "      <td>-66 te</td>\n",
       "      <td>0 te</td>\n",
       "      <td>-41 te</td>\n",
       "      <td>-26 te</td>\n",
       "      <td>112 te</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                        DISCIPLINE SUBAREA  \\\n",
       "2                                                     Included Contingency   \n",
       "3                                               Previous Rev.7 Contingency   \n",
       "4                                             Integrated Below Cellar Deck   \n",
       "5                                                   Integrated Cellar Deck   \n",
       "6                                                    Integrated Lower Deck   \n",
       "7                                             Integrated Intermediate Deck   \n",
       "8                                                    Integrated Upper Deck   \n",
       "9   INTEGRATED DECK PHASE 104  DRY IN PLACE        Integrated Weather Deck   \n",
       "10                                               Integrated Living Quarter   \n",
       "11                                                                Top Deck   \n",
       "12                                                       GTG Exhaust stack   \n",
       "13                                                         GTG Inlet stack   \n",
       "14                                                              East modue   \n",
       "15                                                             West module   \n",
       "16                                           TOTAL INTEGRATED Gross Weight   \n",
       "17                                             PREVIOUS REV.7 Gross Weight   \n",
       "18                                           VARIATION FROM PREVIOUS REV.7   \n",
       "\n",
       "       AR      EL      HV      IN   IN Valves       ME     PFP     SA   \\\n",
       "2     6.8%    5.2%    6.0%    5.2%       5.0%      4.3%    5.0%   5.4%   \n",
       "3     6.9%    5.1%    5.0%    5.2%       5.0%      4.3%    5.0%   5.7%   \n",
       "4             1 te            1 te      13 te     13 te    2 te   0 te   \n",
       "5           134 te           35 te      32 te    611 te   48 te   4 te   \n",
       "6            89 te           32 te      73 te    288 te   29 te   3 te   \n",
       "7            96 te           29 te      15 te    451 te   22 te   4 te   \n",
       "8            94 te           32 te      16 te    262 te   31 te   4 te   \n",
       "9            55 te           18 te      14 te    987 te    7 te   3 te   \n",
       "10  267 te  235 te  101 te   70 te               284 te   22 te   2 te   \n",
       "11           14 te            6 te      12 te     74 te    3 te   2 te   \n",
       "12                                                88 te                  \n",
       "13           10 te                                39 te                  \n",
       "14            1 te            1 te                11 te                  \n",
       "15           20 te    3 te    4 te               107 te    1 te   0 te   \n",
       "16  267 te  749 te  104 te  227 te     176 te  3 214 te  165 te  22 te   \n",
       "17  258 te  730 te   84 te  179 te     176 te  3 202 te  164 te  25 te   \n",
       "18    8 te   20 te   20 te   48 te       0 te     12 te    0 te  -3 te   \n",
       "\n",
       "    PA (ST)        PI      ST I     ST II   ST III        ST   T & I Aids   \\\n",
       "2       5.0%      3.3%      3.1%      3.5%     5.6%      3.4%        20.0%   \n",
       "3       5.0%      3.3%      3.1%      3.8%     5.8%      3.6%        10.0%   \n",
       "4       2 te     12 te     20 te     16 te     7 te     43 te                \n",
       "5      47 te    189 te    708 te    583 te    41 te  1 332 te                \n",
       "6      19 te    294 te    645 te    532 te    30 te  1 207 te                \n",
       "7      17 te    240 te    673 te    521 te    21 te  1 215 te                \n",
       "8      12 te    252 te    454 te    329 te    49 te    832 te                \n",
       "9      18 te    260 te    876 te    487 te    61 te  1 424 te                \n",
       "10                5 te              141 te    40 te    182 te                \n",
       "11      5 te    144 te    168 te    159 te     5 te    332 te         7 te   \n",
       "12      2 te      9 te              121 te     8 te    130 te                \n",
       "13      1 te      5 te               54 te     5 te     59 te                \n",
       "14      0 te      9 te     31 te     23 te     3 te     57 te                \n",
       "15      5 te     17 te    292 te     81 te    62 te    435 te                \n",
       "16    128 te  1 436 te  3 867 te  3 049 te   333 te  7 248 te         7 te   \n",
       "17    129 te  1 362 te  3 841 te  3 115 te   333 te  7 289 te        33 te   \n",
       "18      0 te     74 te     26 te    -66 te     0 te    -41 te       -26 te   \n",
       "\n",
       "    TOTAL DRY   \n",
       "2         3.7%  \n",
       "3         3.7%  \n",
       "4        86 te  \n",
       "5     2 431 te  \n",
       "6     2 035 te  \n",
       "7     2 090 te  \n",
       "8     1 534 te  \n",
       "9     2 786 te  \n",
       "10    1 167 te  \n",
       "11      600 te  \n",
       "12      229 te  \n",
       "13      114 te  \n",
       "14       80 te  \n",
       "15      591 te  \n",
       "16   13 743 te  \n",
       "17   13 630 te  \n",
       "18      112 te  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "finalDataframes[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['  ',\n",
       " '  ',\n",
       " ' DISCIPLINE SUBAREA',\n",
       " ' AR ',\n",
       " ' EL ',\n",
       " ' HV ',\n",
       " ' IN ',\n",
       " ' IN Valves',\n",
       " ' ME ',\n",
       " ' PFP ',\n",
       " ' SA ',\n",
       " ' PA (ST) ',\n",
       " ' PI ',\n",
       " ' ST I ',\n",
       " ' ST II ',\n",
       " ' ST III ',\n",
       " ' ST ',\n",
       " ' T & I Aids ',\n",
       " ' TOTAL LIFTING']"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "header"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}