notebooks/Demo-sorting.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Sorting text regions as columns or as rows\n",
    "\n",
    "**Note**: This tutorial follows and depends on the tutorial on [Reading PageXML files from archives](./Demo-reading-pagexml-files-from-archive.ipynb). It assumes you have downloaded the PageXML archives and derived line format files from them. \n",
    "\n",
    "Text in documents can have different reading orders and a single document can have multiple valid reading orders. Depending on the reading order you want, you can sort the `TextRegion`s and `TextLine`s of a document as columns (columns from left to right, lines within columns from top to bottom) or as rows (horizontally overlapping lines from left to right, and sets of horizontally overlapping lines from top to bottom).\n",
    "\n",
    "The `pagexml_helper` module supports both types of sorting."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We start with accessing the PageXML files from the zip downloaded in the tutorial on [Reading PageXML files from archives](./Demo-reading-pagexml-files-from-archive.ipynb)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pagexml.analysis.stats import get_doc_stats\n",
    "from pagexml.parser import parse_pagexml_files_from_archive\n",
    "\n",
    "na_archive_file = '../data/HTR results 1.05.06 PAGE.zip'\n",
    "\n",
    "scans = parse_pagexml_files_from_archive(na_archive_file)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Below, two scans from this archive are identified, one representing a scan with two columns of text, the other representing a table with many columns and rows. The two functions below turn the scan IDs into URLs so we can view the scan images."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/1005/file/NL-HaNA_1.05.06_1005_0013?eadId=1.05.06&unitID=1005\n",
      "https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/103/file/NL-HaNA_1.05.06_103_0001?eadId=1.05.06&unitID=103\n"
     ]
    }
   ],
   "source": [
    "# https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/1/file/NL-HaNA_1.05.06_1_0001?eadID=1.05.06&unitID=1&query=1.05.06\n",
    "def parse_doc_id(doc_id):\n",
    "    return {\n",
    "        'archive_id': doc_id.split('_')[1],\n",
    "        'inv_num': doc_id.split('_')[2],\n",
    "        'scan_num': int(doc_id.split('_')[3].replace('.jpg', ''))        \n",
    "    }\n",
    "\n",
    "\n",
    "def make_iiif_url_from_doc_id(doc_id):\n",
    "    base_url = 'https://www.nationaalarchief.nl/onderzoeken/archief'\n",
    "    doc_info = parse_doc_id(doc_id)\n",
    "    return f\"{base_url}/{doc_info['archive_id']}/invnr/{doc_info['inv_num']}/file/{doc_id[:-4]}?eadId={doc_info['archive_id']}&unitID={doc_info['inv_num']}\"\n",
    "\n",
    "\n",
    "two_column_scan_id = 'NL-HaNA_1.05.06_1005_0013.jpg'\n",
    "table_scan_id = 'NL-HaNA_1.05.06_103_0001.jpg'\n",
    "\n",
    "print(make_iiif_url_from_doc_id(two_column_scan_id))\n",
    "print(make_iiif_url_from_doc_id(table_scan_id))\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Next, we extract the scans from the archive."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "NL-HaNA_1.05.06_103_0001.jpg {'lines': 410, 'words': 329, 'text_regions': 161, 'columns': 0, 'extra': 0, 'pages': 0}\n",
      "https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/103/file/NL-HaNA_1.05.06_103_0001?eadId=1.05.06&unitID=103\n",
      "NL-HaNA_1.05.06_114_0002.jpg {'lines': 517, 'words': 753, 'text_regions': 15, 'columns': 0, 'extra': 0, 'pages': 0}\n",
      "https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/114/file/NL-HaNA_1.05.06_114_0002?eadId=1.05.06&unitID=114\n",
      "NL-HaNA_1.05.06_114_0003.jpg {'lines': 560, 'words': 750, 'text_regions': 29, 'columns': 0, 'extra': 0, 'pages': 0}\n",
      "https://www.nationaalarchief.nl/onderzoeken/archief/1.05.06/invnr/114/file/NL-HaNA_1.05.06_114_0003?eadId=1.05.06&unitID=114\n"
     ]
    }
   ],
   "source": [
    "scans = parse_pagexml_files_from_archive(na_archive_file)\n",
    "\n",
    "two_column_scan_id = 'NL-HaNA_1.05.06_1005_0013.jpg'\n",
    "table_scan_id = 'NL-HaNA_1.05.06_103_0001.jpg'\n",
    "table_scan_id = 'NL-HaNA_1.05.06_114_0003.jpg'\n",
    "\n",
    "two_column_scan = None\n",
    "table_scan = None\n",
    "\n",
    "for scan in scans:\n",
    "    if scan.id == two_column_scan_id:\n",
    "        two_column_scan = scan\n",
    "    if scan.id == table_scan_id:\n",
    "        table_scan = scan\n",
    "    if table_scan is not None and two_column_scan is not None:\n",
    "        break"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pretty printing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                          22                                                                       23\n",
      "kunnen brengen. Dit is best te zien, wanneer men de on-                   geld en victualie, des maands 2165 guldens, dus in 27 maan-\n",
      "kosten, die de Oostindische Compagnie moet doen, om de                   den 25564 guldens; by gevolg kosten de dertig schepen\n",
      "Waaren uit Europa na Batavia, en weer anderen van daar                   aan maandgeld en victualie in 21 maanden „E1366950\n",
      "na Europa te zenden, vergelykt met de onkosten, die de                     zoo menrekend dat ieder tregat-schip gl. boooc\n",
      "Westindische Compagnie volgens dit Project zou behoeven                   kost, en de Intrest van dit Capitaal rekend tegen\n",
      "te doen, om, als gezegd is, haare Waaren uit Europa over                   3:½ per cent in ’t jaar, zou ieder schip jaarlyks aan\n",
      "de Kust van Magellaan na ’t Land van 5. Esprit, en van daar                   Interest kosten gl. 2100, en dus in 21 maanden\n",
      "weer anderen na Europate zenden: want, wanneer men, by                   81. 3675, dat is voor 30 schepen                  110250\n",
      "voorheeld, verondersteld, dat die beide Compagnien jaar-                     Voor ’t verouderen van ’t schip, en voor ’t on-\n",
      "lyks dertig scheepslaadingen na de voorschreeve Plaatsen                   derhoud van ’t schip, aan Zeilen en Louwerk, enz.\n",
      "uitzenden, en weer t'huisbekomen, zoo blykt, dat de onkos-                   kan men rekenen gl.booo in ’t jaar, dat is in 24\n",
      "ten, die de Westindische Compagnie ten dien einde zou be-                   maanden gl. Iooo, en dus voor de dertig thuns\n",
      "hoeven aan te wenden, verscheide Ponnen Gonds minder                  komende schepen                                420000\n",
      "zouden bedraagen, als de onkosten van de Oostindische Com-                     Aan Proemien voor ieder t' huiskomend schip\n",
      "pagnie.                                                                    moet men rekenen gl. 16774, dus voor dertig\n",
      "   Tot bewys hier van diend de volgende Balance:                           schepen                                         503220\n",
      "  De Oostindische Compagnie wordt verondersteld uit Ku                     zoo dat de dertig scheepslaadingen, die uit\n",
      "ropa na Batavia te zullen zenden,                                           Europa na Batavia, en die van Batavia na Europg\n",
      "10. Schepen in Mai 1773. welke t'huis zullen komen Nov:o 1774.                   werden gezonden, aan de Oostindische Compag-\n",
      "10. dito vaaren uit in Sept: 1773. en komen t'huis in July 1775.                  nie komen te staan op eene somma van        vƒ 2400420\n",
      "10. dito         in Dec:o 1771              in Octob: 175.                     En zoo de Westindische Compagnie jaarlyks Hekboots\n",
      "10. dito         in Mai 1774              in Nov: 2 25                   van 136 voet lang, die met 45 zeevarende Persoonen be-\n",
      "10. dito         in Sept: 1774              in July 1776.                  mant worden, van de slaven 5. Juliaan na ’t Land van 5. Aspril\n",
      "20 dito—       in Dec: 1774. —          in Octob: 1776.                  een reis heen en weerom liet doen, zoo zou ieder schip aan\n",
      "20. dito         in Mai 1775. zynde de bovengemelde so                   maandgeld en viclualie, ieder maand kosten gl. 1247, dat\n",
      "schepen, die in November 1774 waren t'huis gekomen; bly.                   is voor twaalf maanden gl. 14964, en dus voor dertig sche\n",
      "vende dus bo schepen, die de Oostindische Compagnie noo-                   pen                                         8.448920\n",
      "sig heeft, om de Vaart aan de gang te houden, indien de                      En als tien Hekboots van 136 voet, in de maand\n",
      "zelve dertig scheepslaadingen alle jaaren uit en t' huis begeerd                   van Maart, uit Europana de Slaven 5. Juliaan vol-\n",
      "te hebben,                                                                  ren, en van daar weerterug na Europa wierden ge-\n",
      "   De eerste schepen doen, gelyk uit de voorgaande Latel                   zonden met de Waaren door de eerstgemelde Sche-\n",
      " te zien is, haar reis in agttien maanden, die van de tweede                    sen in de slaven 5. Juliaan gebragt, en de zelve haar\n",
      "verzending in twee en twintig maanden, en van de derde                   reis in agt maanden kwamen te doen: (te weeten\n",
      "verzending mede in twee en twintig maanden: zynde dus                   heen en weerom,) en als daaren boven nog tien Sche-\n",
      "twee en zestig maanden, dat de dertig jaarlyks t' huiskomen                    pen in de maand September en December nog z0\n",
      "de Fregat-schepen (want zoodanige schepen gebruikt de                  schepen uit Europa na de slaven 5. Juliaan, en\n",
      " Oost-indische Compagnie) in Zee of bemant zyn geweest.                   van daar weer na Europa wierden gezonden: dan\n",
      "te weeten met go zeevaarende Persoonen, zynde het ordi-                   hadt ieder schip aan onkosten, zoo aan victualie\n",
      "naris getal daar een Fregat mee bemant wordt: want die op                   als maandgeld, ieder maand gl. 1247, dat is in agt\n",
      "de uitgaande Oostindische schepen meer worden meege-                   maanden gl.9976, en dus de dertig uit en t' huis\n",
      "geeven, worden eigentlyk gestuurd om de ontbreekende                                                                    299280\n",
      "                                                                             vaarende schepen\n",
      "manschap in Oostindie te vervullen.141\n",
      "   Ieder Fregatschip, bemant als vooren, kost aan maand                                                                8.. 748200\n",
      "                                                    ged                                           F 2           Frans\n",
      "\n"
     ]
    }
   ],
   "source": [
    "pretty_print_textregion(two_column_scan)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This shows fairly clearly the two columns next to each other.\n",
    "\n",
    "Now for the scan with the table:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                                 Gedestineert\n",
      "                                                 bale\n",
      "                                                                                                                                                             Gedestineerd naar\n",
      "                                        Vate             Bale                                                                                   ate balen\n",
      " datum\n",
      "                                            Ort     Vate                                                                         vate Ortbale\n",
      "         Naander schoepNaam der schip                                           waar datum Naamder scheepsNaamder schip per\n",
      "                                        ZuykZuikCoffenCosfiCatoe                                                                   ZuykeJunykeCoffy Coffy Oatoe\n",
      "                                                                                             Aan\n",
      "\n",
      " 1787\n",
      "                         W: g den Boet\n",
      "\n",
      "         decourier\n",
      "                                                                                 Amstf                          nrestaande Maertans 2294\n",
      "                                                                                                     : Werdenbende\n",
      "                                                                                                    Transport van Om                         3030  45 467\n",
      " Maart                M. Vzeydag     :— 34      15\n",
      "                                                                                            1792\n",
      "                                                                                                                    E. Koerssen\n",
      "                                                                                                                       Tal\n",
      "      21 de zee Compas                                           Geen Lading  idem OctoberC                                                      Geen LadingAmsterdam\n",
      "                                                                                 Midalber                                          2294     303   45465\n",
      "      31Esseg: Societeit B. Govert   112 80 398     103\n",
      "                                                                                            1789\n",
      "Apri    de Vreede    J. H. Tienken 257              60 3 balen Cacao   iden\n",
      "                                                                                                     Akkerydam\n",
      "      10                                         845                                      Januari 21                 .Wolgehagen          195          Vat Cacao.  idem\n",
      "                                                                                                                                   108                38\n",
      "      2 Amerika     Ad. Adriaans Na                                          Amst                                                                   Geen Ladin\n",
      "                                                  35\n",
      "                                        162 ——           40                                                     C. C. Heyde                                         iden\n",
      "                                                                                          Febrwana  Cathar, Theodor\n",
      "         Akker &amp; dam\n",
      "                            „ning zoon\n",
      "                         R. Broers                - - -  21                   idem                                                                                  Moddelb.\n",
      "                                         - -                                                                        A. Ritchie                      36„\n",
      "                                                                                                                                            444\n",
      "                                                                                                    de Vriendschap\n",
      "                                                                236xh. Limpensag                                                                                         Amsteelan\n",
      "         1 Eensgezenhen\n",
      "\n",
      "      24 Iuffrouw Snoek I: Andriessen  89     498      84  3022. Rum    „ Middelh:Maart 13 de Liefde    I. Hturck                       8\n",
      "                                                                                                                                                                          Vlissinge\n",
      "Mai                     H:s Koevbedt                                           Amst.\n",
      "                                         —      57½       39  „ -                                              C. Pieterse       - 263\n",
      "                                                                                                    de Zeenimph                171\n",
      "                                                                                 middelb:\n",
      "         Vrees &amp; Hoog  Jacob Bievert.  352         - - - - 13                                                                                                           middelb.\n",
      "                                                 944                                                                                                 14\n",
      "                                                                                                    de Vreede\n",
      "                                                                                                                    I. A. Sienke 155     580\n",
      "                                                                                                                                                   — —\n",
      "                                                                                 Amstsr        20\n",
      "          de vziend George Eld:t Evertsen   —      15  2  7                                                                                                           Amst\n",
      "                                                                                                                                                       13\n",
      "                                                                                                    Schoonhoven\n",
      "                                                                                                                                             71\n",
      "Juni\n",
      "          de verwagting A: Bappelhof 230 166                                middels        20                P. C. Spiegilber\n",
      "                                                                                                  93\n",
      "                                                  191 – — 17\n",
      "                                                                                                                                                                          idem\n",
      "                                                                                                                                             90  10  6\n",
      "          de Regina  A. Rittschie            3       -                    idem April   de Boode    R. Broers\n",
      "                                        148                                                                                                51   1  2                idem\n",
      "          de Vrouw Mari A. Reyding        84 32                            Rotterdam          de Een dragt  H:k Steur\n",
      "      10\n",
      "                                                                                                                                                                          idem\n",
      "                                                           23                   Amst.                           A: Adriaan              24      34\n",
      "         de nieuwe Expediti I. A. Redge                -.\n",
      "                                                                                                                                                  20\n",
      "      28                                                                                           Amerika                   241\n",
      "                                                  37\n",
      "                                         -                                                    28\n",
      "                                                                                                                    Nanning Jonn                                       idem\n",
      "                         P. Sturck                      7                   iden                                                      13       7\n",
      "July      de Kerterl. Vriendsch                                                                 Junij 2 Marimiliaan\n",
      "                                                  „ -                                                              I. Borselman\n",
      "                                                                                 idem                                                                                   idem\n",
      "         Handel Lust                           19                                                               S. Rickels\n",
      "                                                                                                                                                       3\n",
      "                         I. Wolgehagen       17                                                   Carl &amp; Magdalen\n",
      "                                                                                                                                                   5\n",
      "                                         89                                                                                       06\n",
      "          t zeepaard                                                             iden                                                                    1Vat Limoensap Middel\n",
      "                         And:s Muller            30  2                                          vrees &amp; Hoop I. Rieverts  157  6 1421      33\n",
      "      11\n",
      "          de vriendsschap Corn.s Gerrits                    10                   middelb        9                                                                      iden\n",
      "                                                                                                                    W:r Oostdyk\n",
      "      23                                45  81                                                                                   65  71  51      36\n",
      "          sabelle Johann G: de Groot                   1  1                   idem            de Algem: Welbeer                                                      Amstr\n",
      "                                                                                                                   M. Hanssen\n",
      "                                          12 71\n",
      "                                                                                                                                              18\n",
      "      27de vigilantieC. Andriessen      25 20   —      -             Vlissinge        1 devrijheid\n",
      "  1788                      Total         523      24450                                                      Total                                 Zynde totheden\n",
      "                                                                                                                                   937           36 230\n",
      "                                        1496„\n",
      "                                                                                                                                        7\n",
      "                                                  240\n",
      "                                                                                                                                             233\n",
      "Maart 26 de Goede verwagt Jan Koert                                            Amstvr:\n",
      "                                         o\n",
      "                                                                 Geen Lading                                                 Vaten O5  baleVate Balen\n",
      "                                        --               - - -\n",
      "                                                                                                                                                Coffij\n",
      "                         Jacob Iacobs                                                                                                     Coffy\n",
      "          de Johanne Adrian                                      idem.     idem\n",
      "                                                                                                                                  zuyke zuijt           Catoe\n",
      "                                                                                                    Carga over Anno 1784\n",
      "                                                                                                                                                 2\n",
      "                                                                                                                                  1525„ --4629     365\n",
      "April   de Goede Hoop  C. van Muye   2  „405-   5                   Lissingen\n",
      "                                                   17.                        Amm            idem.                   1514½     512-  138\n",
      "                                                                                                                                         -\n",
      "                         M. Hanssen                     11                                                           1785\n",
      "          de vrijheid\n",
      "                                                                                 middelb:                                          2826               368\n",
      "                                         644\n",
      "      10 Brandenbur C. Bredaun       - -  96   24                                      idem.-—       1786         33 4793½243\n",
      "          de Boode   R. Broeri            186.„-  17                   Amsts                                 1787   149652.      24\n",
      "                                                                                                     idem.\n",
      "                                         -                                                                                                 240      450\n",
      "       17 de Johanne                           182  20                       idem             idem.                                      463\n",
      "                                                            28                                                                    2294     3030 45\n",
      "                          JI. Homberg                                                                                  1788\n",
      "            Margaretha\n",
      "                                                                                                                                            3233  36 230\n",
      "                          C. P. Kraay\n",
      "                                                                 Geen Lading                                                   93½  77\n",
      "                                                                                 idem           idem           1780\n",
      "                                                                                                     Generaad\n",
      "\n",
      "          de dolphyn                                   „-\n",
      "\n",
      "       21de vreede     J. H. Thienke342 - 478     21                  middelb\n",
      "May  5t Fortuynter zeeM. Pieterse            1                           Amstr                          2 Montant  10593 6358648352014\n",
      "                                         187. -           70\n",
      "       13deCouvier    M: Vreijdan             11      -                   idem\n",
      "       14de Verwagtin  R. Boom   141      664     46                middelb.              M   Ssequebo den 11 Iuni 17 89.\n",
      "                                               -\n",
      "                                                                                                                1\n",
      "       11                B. Land                                               idem\n",
      "          Ceres                          78     131-   2\n",
      "                                                                                                                  Was get.\n",
      "          Jans souci    Wagenaar    213   — 43 - -              —       Amst.                                          7      Luij„Een.\n",
      "      21 vreese Hoop   SRieverts     168 -- 34      44  -- -   middelo\n",
      "Iuny                                —                         Geen Ladin\n",
      "                                                                                                                                   In\n",
      "       28 de Uytvlugt   J. A. Ruge    - - . -—                               Amst.\n",
      "Rui   15 ’t zee compas  W: G. de Boer   —  - - - 12 - -  8   - —         iden                            secret: ad     beren\n",
      "                                                                                middelb\n",
      "       28.Mahle       D. Factor      365 -„ 19 -- 54\n",
      "       30 de Nieuwe Hoor  A. Helmers                      14                  Amst\n",
      "sept\n",
      "                                          -      248\n",
      "                                                                                 Roerda\n",
      "                                              - - -\n",
      "          Prins Willem\n",
      "                          M. Winter\n",
      "                                                                   —\n",
      "                                                        8  4\n",
      "                                              - - -\n",
      "             Fredrik                                                           Amsterdam\n",
      "                                          7               35\n",
      "      19devzouw gesini Elsaba G: Siemering           „\n",
      "                                              —        —\n",
      "                          Transporteeren2294     3030  47 463\n",
      "\n",
      "\n"
     ]
    }
   ],
   "source": [
    "pretty_print_textregion(table_scan)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Hmm. This needs a different approach to make pretty printing work."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Sorting by column or by row\n",
    "\n",
    "It is possible to sort the `TextLine`s as columns or as rows.\n",
    "\n",
    "### Sorting by column\n",
    "\n",
    "We start with sorting by column:\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1440-1583\t 369-462\t22\n",
      " 688-2321\t 418-544\tkunnen brengen. Dit is best te zien, wanneer men de on-\n",
      " 685-2329\t 509-615\tkosten, die de Oostindische Compagnie moet doen, om de\n",
      " 688-2313\t 577-682\tWaaren uit Europa na Batavia, en weer anderen van daar\n",
      " 683-2320\t 650-755\tna Europa te zenden, vergelykt met de onkosten, die de\n",
      " 691-2332\t 720-821\tWestindische Compagnie volgens dit Project zou behoeven\n",
      " 694-2328\t 791-893\tte doen, om, als gezegd is, haare Waaren uit Europa over\n",
      " 695-2331\t 862-955\tde Kust van Magellaan na ’t Land van 5. Esprit, en van daar\n",
      " 700-2317\t 932-1034\tweer anderen na Europate zenden: want, wanneer men, by\n",
      " 704-2329\t 994-1095\tvoorheeld, verondersteld, dat die beide Compagnien jaar-\n",
      " 686-2332\t1057-1163\tlyks dertig scheepslaadingen na de voorschreeve Plaatsen\n",
      " 689-2330\t1134-1228\tuitzenden, en weer t'huisbekomen, zoo blykt, dat de onkos-\n",
      " 695-2327\t1206-1302\tten, die de Westindische Compagnie ten dien einde zou be-\n",
      " 694-2334\t1278-1367\thoeven aan te wenden, verscheide Ponnen Gonds minder\n",
      " 703-2330\t1341-1444\tzouden bedraagen, als de onkosten van de Oostindische Com-\n",
      " 701-911\t1415-1505\tpagnie.\n",
      " 769-2107\t1480-1576\tTot bewys hier van diend de volgende Balance:\n",
      " 762-2320\t1548-1650\tDe Oostindische Compagnie wordt verondersteld uit Ku\n",
      " 702-1634\t1620-1709\tropa na Batavia te zullen zenden,\n",
      " 688-2334\t1687-1782\t10. Schepen in Mai 1773. welke t'huis zullen komen Nov:o 1774.\n",
      " 707-2334\t1757-1854\t10. dito vaaren uit in Sept: 1773. en komen t'huis in July 1775.\n",
      " 697-891\t1821-1904\t10. dito\n",
      "1172-1514\t1831-1912\tin Dec:o 177\n",
      "1464-1515\t1876-1912\t1\n",
      "1934-2258\t1831-1915\tin Octob: 17\n",
      "2277-2334\t1841-1913\t5.\n",
      " 705-896\t1896-1971\t10. dito\n",
      "1177-1532\t1896-1986\tin Mai 1774\n",
      "1950-2221\t1895-1990\tin Nov: 2\n",
      "2251-2334\t1910-1982\t25\n",
      " 701-893\t1951-2031\t10. dito\n",
      "1171-1525\t1954-2051\tin Sept: 1774\n",
      "1944-2340\t1966-2054\tin July 1776.\n",
      " 701-919\t2025-2130\t20 dito\n",
      " 919-964\t2033-2108\t—\n",
      "1168-1523\t2029-2121\tin Dec: 1774.\n",
      "1562-1607\t2037-2106\t—\n",
      "1911-2342\t2031-2120\tin Octob: 1776.\n",
      " 699-903\t2100-2182\t20. dito\n",
      "1177-2333\t2096-2191\tin Mai 1775. zynde de bovengemelde so\n",
      " 694-2325\t2157-2272\tschepen, die in November 1774 waren t'huis gekomen; bly.\n",
      " 695-2333\t2234-2329\tvende dus bo schepen, die de Oostindische Compagnie noo-\n",
      " 697-2330\t2303-2397\tsig heeft, om de Vaart aan de gang te houden, indien de\n",
      " 687-2335\t2368-2470\tzelve dertig scheepslaadingen alle jaaren uit en t' huis begeerd\n",
      " 709-984\t2430-2526\tte hebben,\n",
      " 769-2333\t2495-2603\tDe eerste schepen doen, gelyk uit de voorgaande Latel\n",
      " 712-2331\t2577-2671\tte zien is, haar reis in agttien maanden, die van de tweede\n",
      " 708-2329\t2647-2740\tverzending in twee en twintig maanden, en van de derde\n",
      " 691-2331\t2714-2807\tverzending mede in twee en twintig maanden: zynde dus\n",
      " 698-2326\t2783-2876\ttwee en zestig maanden, dat de dertig jaarlyks t' huiskomen\n",
      " 696-2342\t2851-2948\tde Fregat-schepen (want zoodanige schepen gebruikt de\n",
      " 712-2329\t2919-3028\tOost-indische Compagnie) in Zee of bemant zyn geweest.\n",
      " 703-2333\t2983-3082\tte weeten met go zeevaarende Persoonen, zynde het ordi-\n",
      " 696-2325\t3049-3158\tnaris getal daar een Fregat mee bemant wordt: want die op\n",
      " 707-2333\t3123-3223\tde uitgaande Oostindische schepen meer worden meege-\n",
      " 697-2335\t3183-3296\tgeeven, worden eigentlyk gestuurd om de ontbreekende\n",
      " 706-1693\t3260-3356\tmanschap in Oostindie te vervullen.\n",
      "1696-1843\t3271-3352\t141\n",
      " 773-2343\t3326-3438\tIeder Fregatschip, bemant als vooren, kost aan maand\n",
      "2195-2342\t3411-3511\tged\n",
      "3628-3723\t 366-465\t23\n",
      "2882-4503\t 427-542\tgeld en victualie, des maands 2165 guldens, dus in 27 maan-\n",
      "2892-4508\t 507-612\tden 25564 guldens; by gevolg kosten de dertig schepen\n",
      "2881-4037\t 584-676\taan maandgeld en victualie in 21 maanden\n",
      "4068-4158\t 582-661\t„\n",
      "4167-4255\t 588-663\tE\n",
      "4253-4504\t 589-671\t1366950\n",
      "2942-4221\t 651-753\tzoo menrekend dat ieder tregat-schip gl. boooc\n",
      "2880-4224\t 719-820\tkost, en de Intrest van dit Capitaal rekend tegen\n",
      "2890-4247\t 784-888\t3:½ per cent in ’t jaar, zou ieder schip jaarlyks aan\n",
      "2876-4236\t 853-954\tInterest kosten gl. 2100, en dus in 21 maanden\n",
      "2870-3780\t 929-1026\t81. 3675, dat is voor 30 schepen\n",
      "4303-4499\t 933-1003\t110250\n",
      "2945-4237\t 991-1096\tVoor ’t verouderen van ’t schip, en voor ’t on-\n",
      "2880-4231\t1065-1160\tderhoud van ’t schip, aan Zeilen en Louwerk, enz.\n",
      "2888-4238\t1130-1229\tkan men rekenen gl.booo in ’t jaar, dat is in 24\n",
      "2877-4222\t1194-1308\tmaanden gl. Iooo, en dus voor de dertig thuns\n",
      "2876-3377\t1279-1367\tkomende schepen\n",
      "4293-4518\t1261-1351\t420000\n",
      "2952-4235\t1334-1433\tAan Proemien voor ieder t' huiskomend schip\n",
      "2871-4225\t1408-1504\tmoet men rekenen gl. 16774, dus voor dertig\n",
      "2882-3107\t1492-1562\tschepen\n",
      "4296-4515\t1467-1558\t503220\n",
      "2939-4226\t1545-1643\tzoo dat de dertig scheepslaadingen, die uit\n",
      "2878-4228\t1619-1710\tEuropa na Batavia, en die van Batavia na Europg\n",
      "2889-4239\t1683-1785\twerden gezonden, aan de Oostindische Compag-\n",
      "2871-3942\t1758-1850\tnie komen te staan op eene somma van\n",
      "4189-4522\t1748-1833\tvƒ 2400420\n",
      "2953-4514\t1814-1916\tEn zoo de Westindische Compagnie jaarlyks Hekboots\n",
      "2881-4524\t1884-1986\tvan 136 voet lang, die met 45 zeevarende Persoonen be-\n",
      "2876-4526\t1954-2055\tmant worden, van de slaven 5. Juliaan na ’t Land van 5. Aspril\n",
      "2880-4512\t2017-2121\teen reis heen en weerom liet doen, zoo zou ieder schip aan\n",
      "2884-4523\t2089-2191\tmaandgeld en viclualie, ieder maand kosten gl. 1247, dat\n",
      "2892-4511\t2157-2262\tis voor twaalf maanden gl. 14964, en dus voor dertig sche\n",
      "2885-3006\t2245-2332\tpen\n",
      "4194-4277\t2230-2316\t8.\n",
      "4292-4523\t2224-2309\t448920\n",
      "2966-4255\t2295-2391\tEn als tien Hekboots van 136 voet, in de maand\n",
      "2886-4251\t2361-2472\tvan Maart, uit Europana de Slaven 5. Juliaan vol-\n",
      "2894-4234\t2435-2529\tren, en van daar weerterug na Europa wierden ge-\n",
      "2889-4247\t2498-2602\tzonden met de Waaren door de eerstgemelde Sche-\n",
      "2905-4249\t2571-2667\tsen in de slaven 5. Juliaan gebragt, en de zelve haar\n",
      "2879-4253\t2643-2738\treis in agt maanden kwamen te doen: (te weeten\n",
      "2891-4242\t2707-2805\theen en weerom,) en als daaren boven nog tien Sche-\n",
      "2901-4243\t2775-2873\tpen in de maand September en December nog z0\n",
      "2884-4261\t2840-2948\tschepen uit Europa na de slaven 5. Juliaan, en\n",
      "2897-4264\t2912-3013\tvan daar weer na Europa wierden gezonden: dan\n",
      "2877-4249\t2982-3078\thadt ieder schip aan onkosten, zoo aan victualie\n",
      "2882-4241\t3044-3153\tals maandgeld, ieder maand gl. 1247, dat is in agt\n",
      "2892-4246\t3119-3216\tmaanden gl.9976, en dus de dertig uit en t' huis\n",
      "4305-4517\t3190-3272\t299280\n",
      "2888-3405\t3193-3294\tvaarende schepen\n",
      "4185-4524\t3325-3421\t8.. 748200\n",
      "3589-3734\t3404-3497\tF 2\n",
      "4058-4256\t3367-3473\tFrans\n"
     ]
    }
   ],
   "source": [
    "from pagexml.helper.pagexml_helper import sort_lines_in_column_reading_order\n",
    "\n",
    "for line in sort_lines_in_column_reading_order(two_column_scan):\n",
    "    print(f'{line.coords.left: >4}-{line.coords.right}\\t{line.coords.top: >4}-{line.coords.bottom}\\t{line.text}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  94-277\t 132-247\tdatum\n",
      " 100-229\t 356-418\t1787\n",
      "  95-282\t 411-505\tMaart\n",
      " 236-283\t 510-576\t21\n",
      " 228-298\t 588-665\t31\n",
      "  78-206\t 645-728\tApri\n",
      " 241-283\t 665-735\t10\n",
      " 243-293\t 737-822\t2\n",
      " 240-310\t 919-977\t24\n",
      "  75-193\t 966-1057\tMai\n",
      "  73-211\t1184-1290\tJuni\n",
      " 240-296\t1399-1470\t10\n",
      " 231-306\t1460-1546\t28\n",
      "  63-169\t1535-1620\tJuly\n",
      " 246-293\t1720-1793\t11\n",
      " 236-321\t1795-1868\t23\n",
      " 248-311\t1952-2017\t27\n",
      " 125-234\t2016-2090\t1788\n",
      "  64-322\t2071-2168\tMaart 26\n",
      "  63-236\t2230-2310\tApril\n",
      " 248-311\t2408-2481\t10\n",
      " 253-316\t2551-2621\t17\n",
      " 257-311\t2731-2809\t21\n",
      "  63-193\t2779-2857\tMay\n",
      " 272-325\t2805-2867\t5\n",
      " 254-324\t2854-2947\t13\n",
      " 264-328\t2930-2998\t14\n",
      " 264-307\t2996-3059\t11\n",
      " 248-311\t3115-3167\t21\n",
      "  62-176\t3144-3224\tIuny\n",
      " 257-323\t3164-3211\t28\n",
      "  70-169\t3204-3288\tRui\n",
      " 271-316\t3211-3274\t15\n",
      " 264-328\t3272-3323\t28\n",
      " 262-318\t3318-3378\t30\n",
      "  68-168\t3333-3409\tsept\n",
      " 248-318\t3440-3496\t19\n",
      " 327-712\t 159-256\tNaander schoep\n",
      " 320-615\t 377-503\tdecourier\n",
      " 316-648\t 496-591\tde zee Compas\n",
      " 322-694\t 576-666\tEsseg: Societeit\n",
      " 320-600\t 646-743\tde Vreede\n",
      " 339-589\t 728-820\tAmerika\n",
      " 324-699\t 799-907\tAkker &amp; dam\n",
      " 326-716\t 884-1068\t1 Eensgezenhen\n",
      " 338-710\t 891-980\tIuffrouw Snoek\n",
      " 328-664\t1056-1144\tVrees &amp; Hoog\n",
      " 339-716\t1128-1229\tde vziend George\n",
      " 338-709\t1207-1298\tde verwagting\n",
      " 333-673\t1281-1369\tde Regina\n",
      " 336-706\t1363-1459\tde Vrouw Mari\n",
      " 327-719\t1452-1547\tde nieuwe Expediti\n",
      " 335-712\t1529-1623\tde Kerterl. Vriendsch\n",
      " 330-674\t1609-1708\tHandel Lust\n",
      " 333-626\t1690-1781\tt zeepaard\n",
      " 338-701\t1772-1864\tde vriendsschap\n",
      " 340-722\t1852-1943\tsabelle Johann\n",
      " 327-733\t1935-2036\tde vigilantie\n",
      " 349-732\t2067-2168\tde Goede verwagt\n",
      " 331-727\t2156-2251\tde Johanne Adrian\n",
      " 336-671\t2232-2321\tde Goede Hoop\n",
      " 335-608\t2311-2405\tde vrijheid\n",
      " 342-712\t2386-2483\tBrandenbur\n",
      " 335-652\t2458-2557\tde Boode\n",
      " 345-684\t2530-2629\tde Johanne\n",
      " 402-719\t2599-2672\tMargaretha\n",
      " 345-689\t2643-2741\tde dolphyn\n",
      " 337-613\t2720-2797\tde vreede\n",
      " 339-738\t2794-2877\tt Fortuynter zee\n",
      " 345-628\t2854-2938\tdeCouvier\n",
      " 350-680\t2923-3025\tde Verwagtin\n",
      " 354-496\t2999-3068\tCeres\n",
      " 347-633\t3052-3127\tJans souci\n",
      " 351-667\t3111-3187\tvreese Hoop\n",
      " 355-671\t3164-3242\tde Uytvlugt\n",
      " 349-694\t3210-3298\t’t zee compas\n",
      " 343-578\t3268-3350\t.Mahle\n",
      " 355-700\t3319-3383\tde Nieuwe Hoor\n",
      " 349-729\t3363-3430\tPrins Willem\n",
      " 433-637\t3410-3464\tFredrik\n",
      " 343-744\t3420-3519\tdevzouw gesini Elsaba\n",
      " 721-1110\t 168-257\tNaam der schip\n",
      " 744-1112\t 367-587\tW: g den Boet\n",
      " 731-1095\t 413-505\tM. Vzeydag\n",
      " 745-1053\t 573-665\tB. Govert\n",
      " 732-1107\t 645-736\tJ. H. Tienken\n",
      " 734-1132\t 728-815\tAd. Adriaans Na\n",
      " 827-1071\t 800-849\t„ning zoon\n",
      " 750-1058\t 817-898\tR. Broers\n",
      " 743-1113\t 895-977\tI: Andriessen\n",
      " 760-1096\t 968-1065\tH:s Koevbedt\n",
      " 738-1099\t1050-1141\tJacob Bievert.\n",
      " 750-1085\t1127-1224\tEld:t Evertsen\n",
      " 749-1117\t1200-1292\tA: Bappelhof\n",
      " 744-1092\t1279-1374\tA. Rittschie\n",
      " 741-1085\t1363-1464\tA. Reyding\n",
      " 763-1085\t1449-1554\tI. A. Redge\n",
      " 754-1080\t1524-1623\tP. Sturck\n",
      " 743-1120\t1617-1713\tI. Wolgehagen\n",
      " 745-1097\t1693-1787\tAnd:s Muller\n",
      " 752-1115\t1772-1872\tCorn.s Gerrits\n",
      " 771-1071\t1857-1953\tG: de Groot\n",
      " 756-1133\t1938-2034\tC. Andriessen\n",
      " 827-1025\t2016-2099\tTotal\n",
      " 761-1063\t2085-2179\tJan Koert\n",
      " 758-1108\t2155-2251\tJacob Iacobs\n",
      " 749-1122\t2230-2326\tC. van Muye\n",
      " 742-1089\t2303-2404\tM. Hanssen\n",
      " 765-1103\t2388-2479\tC. Bredaun\n",
      " 759-1087\t2459-2545\tR. Broeri\n",
      " 759-1098\t2565-2649\tJI. Homberg\n",
      " 765-1096\t2628-2742\tC. P. Kraay\n",
      " 757-1138\t2724-2814\tJ. H. Thienke\n",
      " 759-1106\t2788-2882\tM. Pieterse\n",
      " 758-1086\t2857-2955\tM: Vreijdan\n",
      " 757-1078\t2927-3014\tR. Boom\n",
      " 758-989\t2993-3073\tB. Land\n",
      " 765-1072\t3054-3134\tWagenaar\n",
      " 761-1049\t3115-3194\tSRieverts\n",
      " 769-1057\t3166-3234\tJ. A. Ruge\n",
      "1052-1113\t3151-3242\t—\n",
      " 767-1094\t3214-3292\tW: G. de Boer\n",
      " 770-1007\t3269-3344\tD. Factor\n",
      " 759-1092\t3324-3397\tA. Helmers\n",
      " 773-1083\t3371-3459\tM. Winter\n",
      " 791-1151\t3430-3519\tG: Siemering\n",
      " 768-1159\t3520-3610\tTransporteeren\n",
      "1144-1254\t 128-217\tVate\n",
      "1139-1247\t 209-277\tZuyk\n",
      "1160-1252\t 576-667\t112\n",
      "1156-1246\t 656-735\t257\n",
      "1149-1236\t 751-838\t162\n",
      "1163-1229\t 833-899\t- -\n",
      "1189-1252\t 920-978\t89\n",
      "1167-1235\t1003-1054\t—\n",
      "1161-1247\t1056-1142\t352\n",
      "1168-1244\t1136-1218\t—\n",
      "1161-1243\t1210-1290\t230\n",
      "1152-1262\t1298-1375\t148\n",
      "1170-1230\t1487-1547\t-\n",
      "1184-1247\t1629-1692\t89\n",
      "1184-1247\t1793-1863\t45\n",
      "1201-1271\t1889-1950\t12\n",
      "1150-1272\t2021-2094\t1496„\n",
      "1177-1244\t2087-2130\to\n",
      "1145-1247\t2121-2163\t--\n",
      "1224-1287\t2249-2312\t2\n",
      "1177-1264\t2373-2469\t644\n",
      "1168-1212\t2469-2530\t-\n",
      "1158-1276\t2729-2820\t342\n",
      "1181-1269\t2805-2871\t187\n",
      "1184-1269\t2944-3015\t141\n",
      "1217-1283\t3005-3066\t78\n",
      "1181-1270\t3061-3126\t213\n",
      "1191-1276\t3122-3188\t168\n",
      "1184-1280\t3181-3242\t- - .\n",
      "1184-1247\t3223-3281\t—\n",
      "1189-1280\t3267-3354\t365\n",
      "1207-1255\t3347-3389\t-\n",
      "1195-1275\t3416-3495\t7\n",
      "1166-1285\t3518-3610\t2294\n",
      "1262-1348\t 136-225\tOrt\n",
      "1254-1364\t 224-289\tZuik\n",
      "1255-1320\t 428-476\t:\n",
      "1297-1360\t 585-653\t80\n",
      "1278-1345\t 764-843\t——\n",
      "1292-1376\t1201-1280\t166\n",
      "1301-1383\t1376-1456\t84\n",
      "1314-1365\t1620-1706\t17\n",
      "1307-1363\t1786-1861\t81\n",
      "1315-1384\t1884-1947\t71\n",
      "1299-1386\t1944-2017\t25\n",
      "1276-1382\t2011-2091\t523\n",
      "1297-1369\t2405-2468\t- -\n",
      "1315-1379\t2720-2809\t-\n",
      "1285-1372\t2811-2879\t. -\n",
      "1343-1388\t2954-3001\t-\n",
      "1353-1395\t3057-3143\t—\n",
      "1315-1383\t3136-3195\t--\n",
      "1330-1397\t3182-3244\t-—\n",
      "1307-1413\t3217-3284\t- - -\n",
      "1325-1393\t3285-3343\t-„\n",
      "1313-1376\t3352-3396\t- - -\n",
      "1304-1388\t3384-3464\t- - -\n",
      "1316-1365\t3459-3480\t—\n",
      "1330-1378\t 440-501\t—\n",
      "1349-1403\t2250-2320\t„\n",
      "1383-1472\t 115-224\tbale\n",
      "1375-1484\t 217-299\tCoffen\n",
      "1410-1498\t 415-481\t34\n",
      "1397-1485\t 586-664\t398\n",
      "1403-1477\t 669-738\t845\n",
      "1411-1479\t 737-894\t35\n",
      "1409-1491\t 920-992\t498\n",
      "1397-1491\t1000-1072\t57½\n",
      "1399-1491\t1073-1145\t944\n",
      "1407-1477\t1127-1203\t15\n",
      "1409-1491\t1217-1299\t191\n",
      "1437-1479\t1287-1367\t3\n",
      "1418-1486\t1372-1450\t32\n",
      "1413-1502\t1460-1524\t37\n",
      "1411-1477\t1549-1594\t„ -\n",
      "1423-1486\t1610-1702\t19\n",
      "1426-1497\t1713-1782\t30\n",
      "1428-1491\t1940-2010\t20\n",
      "1404-1489\t2022-2090\t240\n",
      "1411-1520\t2233-2310\t405\n",
      "1533-1580\t2242-2291\t-\n",
      "1449-1512\t2301-2371\t17\n",
      "1506-1593\t2292-2377\t.\n",
      "1430-1583\t2380-2474\t96\n",
      "1427-1534\t2451-2533\t186.\n",
      "1535-1606\t2454-2538\t„-\n",
      "1425-1507\t2551-2638\t182\n",
      "1568-1631\t2549-2635\t20\n",
      "1412-1516\t2742-2812\t478\n",
      "1446-1503\t2801-2869\t1\n",
      "1449-1512\t2876-2930\t11\n",
      "1433-1526\t2935-2996\t664\n",
      "1429-1520\t2997-3077\t131\n",
      "1446-1512\t3071-3129\t43\n",
      "1432-1503\t3131-3189\t34\n",
      "1456-1500\t3221-3281\t12\n",
      "1423-1505\t3284-3345\t19\n",
      "1419-1513\t3336-3405\t248\n",
      "1449-1503\t3438-3480\t„\n",
      "1423-1514\t3516-3586\t3030\n",
      "1507-1592\t 133-227\tVate\n",
      "1501-1609\t 221-300\tCosfi\n",
      "1510-1616\t 814-903\t- - -\n",
      "1515-1631\t1060-1140\t- - - -\n",
      "1545-1592\t1135-1219\t2\n",
      "1531-1624\t1212-1287\t– —\n",
      "1517-1590\t1450-1531\t-.\n",
      "1549-1625\t2011-2085\t24\n",
      "1573-1615\t1711-1783\t2\n",
      "1545-1608\t3022-3061\t-\n",
      "1549-1613\t3054-3134\t- -\n",
      "1542-1646\t3214-3278\t- -\n",
      "1548-1620\t3281-3355\t-\n",
      "1613-1655\t3274-3326\t-\n",
      "1580-1624\t3382-3441\t8\n",
      "1592-1636\t3441-3478\t—\n",
      "1569-1641\t3508-3594\t47\n",
      "1587-1638\t1864-1935\t1\n",
      "1596-1641\t1978-2017\t—\n",
      "1624-1732\t 119-215\tBale\n",
      "1623-1735\t 210-289\tCatoe\n",
      "1669-1732\t 405-487\t15\n",
      "1641-1723\t 585-653\t103\n",
      "1646-1735\t 649-732\t60\n",
      "1660-1733\t 755-828\t40\n",
      "1674-1736\t 822-911\t21\n",
      "1671-1744\t 915-990\t84\n",
      "1680-1744\t 988-1067\t39\n",
      "1680-1727\t1049-1140\t13\n",
      "1669-1727\t1127-1199\t7\n",
      "1673-1739\t1215-1290\t17\n",
      "1669-1711\t1287-1369\t-\n",
      "1652-1739\t1442-1528\t23\n",
      "1687-1732\t1521-1603\t7\n",
      "1665-1735\t1768-1849\t10\n",
      "1692-1737\t1870-1943\t1\n",
      "1648-1744\t2013-2085\t450\n",
      "1660-1746\t2116-2153\t- - -\n",
      "1664-1727\t2233-2310\t5\n",
      "1663-1738\t2309-2382\t11\n",
      "1664-1751\t2373-2448\t24\n",
      "1673-1737\t2448-2542\t17\n",
      "1683-1746\t2556-2617\t28\n",
      "1643-1760\t2643-2743\t„-\n",
      "1661-1737\t2734-2811\t21\n",
      "1678-1741\t2806-2872\t70\n",
      "1685-1727\t2900-2933\t-\n",
      "1680-1765\t2933-3015\t46\n",
      "1692-1739\t3001-3064\t2\n",
      "1682-1771\t3123-3189\t44\n",
      "1717-1773\t3213-3274\t8\n",
      "1697-1760\t3270-3331\t54\n",
      "1695-1763\t3330-3383\t14\n",
      "1699-1765\t3382-3431\t4\n",
      "1692-1755\t3417-3478\t35\n",
      "1673-1760\t3508-3583\t463\n",
      "1827-2259\t  85-262\tGedestineert\n",
      "1801-2213\t 482-584\tGeen Lading\n",
      "1784-2176\t 648-722\t3 balen Cacao\n",
      "1778-2230\t 873-972\t236xh. Limpensag\n",
      "1810-2134\t 940-1016\t3022. Rum\n",
      "1816-1929\t1001-1041\t„ -\n",
      "1805-1879\t1940-2017\t-\n",
      "1808-2222\t2087-2183\tGeen Lading\n",
      "1765-2096\t2156-2243\tidem.\n",
      "1805-2219\t2636-2737\tGeen Lading\n",
      "1992-2039\t3061-3127\t—\n",
      "1847-2147\t3116-3187\t-- -\n",
      "1787-2190\t3144-3242\tGeen Ladin\n",
      "1879-1994\t3232-3284\t- —\n",
      "1867-1918\t3376-3424\t—\n",
      "2263-2448\t 173-250\twaar\n",
      "2248-2454\t 383-482\tAmstf\n",
      "2277-2460\t 476-570\tidem\n",
      "2254-2441\t 548-637\tMidalber\n",
      "2257-2413\t 640-724\tiden\n",
      "2258-2429\t 736-820\tAmst\n",
      "2257-2416\t 810-907\tidem\n",
      "2264-2462\t 900-988\t„ Middelh:\n",
      "2255-2417\t 972-1054\tAmst.\n",
      "2241-2457\t1034-1103\tmiddelb:\n",
      "2253-2433\t1104-1191\tAmstsr\n",
      "2252-2438\t1196-1278\tmiddels\n",
      "2262-2436\t1263-1346\tidem\n",
      "2256-2467\t1346-1445\tRotterdam\n",
      "2256-2416\t1428-1518\tAmst.\n",
      "2259-2394\t1510-1593\tiden\n",
      "2258-2393\t1594-1680\tidem\n",
      "2272-2399\t1679-1752\tiden\n",
      "2258-2452\t1759-1857\tmiddelb\n",
      "2263-2420\t1844-1938\tidem\n",
      "2238-2442\t1936-2029\tVlissinge\n",
      "2258-2427\t2078-2174\tAmstvr:\n",
      "2256-2425\t2158-2242\tidem\n",
      "2251-2477\t2225-2307\tLissingen\n",
      "2254-2427\t2290-2374\tAmm\n",
      "2251-2436\t2357-2455\tmiddelb:\n",
      "2256-2425\t2442-2529\tAmsts\n",
      "2260-2421\t2523-2615\tidem\n",
      "2247-2458\t2642-2716\tidem\n",
      "2221-2427\t2709-2807\tmiddelb\n",
      "2243-2431\t2776-2863\tAmstr\n",
      "2247-2392\t2848-2937\tidem\n",
      "2213-2457\t2914-3010\tmiddelb.\n",
      "2256-2425\t2989-3064\tidem\n",
      "2241-2418\t3055-3122\tAmst.\n",
      "2233-2413\t3118-3189\tmiddelo\n",
      "2238-2416\t3163-3237\tAmst.\n",
      "2239-2384\t3219-3284\tiden\n",
      "2229-2439\t3250-3336\tmiddelb\n",
      "2253-2413\t3314-3368\tAmst\n",
      "2245-2438\t3350-3428\tRoerda\n",
      "2243-2459\t3403-3480\tAmsterdam\n",
      "2501-2733\t 163-259\tdatum\n",
      "2556-2752\t 323-469\tAan\n",
      "2542-2647\t 446-520\t1792\n",
      "2505-2677\t 493-566\tOctober\n",
      "2672-2731\t 501-566\tC\n",
      "2533-2666\t 612-707\t1789\n",
      "2501-2723\t 688-786\tJanuari 21\n",
      "2485-2731\t 790-860\tFebrwana\n",
      "2481-2730\t 920-1015\tMaart 13\n",
      "2670-2740\t1119-1188\t20\n",
      "2661-2743\t1203-1269\t20\n",
      "2481-2652\t1273-1353\tApril\n",
      "2689-2731\t1210-1360\t93\n",
      "2649-2731\t1472-1549\t28\n",
      "2481-2628\t1538-1629\tJunij\n",
      "2680-2724\t1542-1622\t2\n",
      "2673-2715\t1926-2017\t1\n",
      "2671-2729\t1751-1834\t9\n",
      "3575-3678\t 141-220\tvate\n",
      "2771-3165\t 167-265\tNaamder scheeps\n",
      "3171-3561\t 172-272\tNaamder schip per\n",
      "3547-3702\t 206-294\tZuyke\n",
      "3167-3696\t 383-482\tnrestaande Maertans 2294\n",
      "2775-3160\t 387-572\t: Werdenbende\n",
      "2759-3157\t 389-485\tTransport van Om\n",
      "3198-3534\t 454-549\tE. Koerssen\n",
      "3256-3499\t 454-644\tTal\n",
      "3569-3679\t 564-641\t2294\n",
      "2773-3134\t 657-789\tAkkerydam\n",
      "3194-3556\t 678-777\t.Wolgehagen\n",
      "3583-3668\t 700-772\t108\n",
      "2785-3132\t 770-857\tCathar, Theodor\n",
      "3180-3534\t 758-851\tC. C. Heyde\n",
      "2752-3130\t 852-942\tde Vriendschap\n",
      "3162-3520\t 826-925\tA. Ritchie\n",
      "3162-3526\t 907-1004\tI. Hturck\n",
      "2761-3034\t 921-1024\tde Liefde\n",
      "2757-3138\t1009-1105\tde Zeenimph\n",
      "3175-3514\t 974-1085\tC. Pieterse\n",
      "3591-3678\t1011-1081\t171\n",
      "2757-3031\t1081-1189\tde Vreede\n",
      "3174-3549\t1085-1177\tI. A. Sienke\n",
      "3595-3684\t1083-1161\t155\n",
      "2750-3135\t1164-1284\tSchoonhoven\n",
      "3172-3547\t1190-1275\tP. C. Spiegilber\n",
      "2757-3060\t1264-1355\tde Boode\n",
      "3175-3487\t1260-1350\tR. Broers\n",
      "2761-3103\t1350-1443\tde Een dragt\n",
      "3165-3463\t1337-1426\tH:k Steur\n",
      "2759-3075\t1458-1547\tAmerika\n",
      "3157-3469\t1418-1527\tA: Adriaan\n",
      "3586-3702\t1457-1550\t241\n",
      "3198-3547\t1503-1575\tNanning Jonn\n",
      "2759-3132\t1536-1629\tMarimiliaan\n",
      "3164-3562\t1551-1622\tI. Borselman\n",
      "2748-3149\t1616-1723\tCarl &amp; Magdalen\n",
      "3185-3509\t1600-1721\tS. Rickels\n",
      "3604-3687\t1631-1703\t06\n",
      "2758-3121\t1719-1819\tvrees &amp; Hoop\n",
      "3163-3506\t1692-1803\tI. Rieverts\n",
      "3583-3688\t1713-1791\t157\n",
      "3172-3544\t1784-1907\tW:r Oostdyk\n",
      "3599-3686\t1797-1880\t65\n",
      "2751-3147\t1823-1924\tde Algem: Welbeer\n",
      "2768-3090\t1918-2018\tdevrijheid\n",
      "3154-3533\t1883-2010\tM. Hanssen\n",
      "3210-3456\t1981-2094\tTotal\n",
      "3583-3668\t2020-2076\t937\n",
      "3560-3668\t2113-2170\tVaten\n",
      "3572-3679\t2163-2212\tzuyke\n",
      "2758-3480\t2190-2295\tCarga over Anno 1784\n",
      "3572-3685\t2211-2290\t1525„\n",
      "2766-3054\t2295-2386\tidem.\n",
      "3326-3476\t2304-2382\t1785\n",
      "3567-3698\t2283-2371\t1514½\n",
      "2775-3074\t2382-2481\tidem.\n",
      "3073-3120\t2399-2469\t-—\n",
      "3326-3477\t2381-2455\t1786\n",
      "3563-3677\t2372-2454\t2826\n",
      "2784-3033\t2466-2561\tidem.\n",
      "3323-3475\t2459-2545\t1787\n",
      "3565-3709\t2452-2544\t1496\n",
      "2783-3074\t2551-2640\tidem.\n",
      "3320-3469\t2558-2640\t1788\n",
      "3579-3675\t2553-2631\t2294\n",
      "2779-3025\t2640-2726\tidem\n",
      "3328-3469\t2640-2706\t1780\n",
      "3590-3668\t2638-2724\t93½\n",
      "2782-3142\t2642-2864\tGeneraad\n",
      "3143-3185\t2802-2851\t2\n",
      "3214-3491\t2768-2851\tMontant\n",
      "3570-3676\t2767-2842\t10593\n",
      "2852-3058\t2937-3017\tM\n",
      "3073-3115\t2956-3008\t1\n",
      "3140-3535\t2929-3023\tSsequebo\n",
      "3569-3679\t2902-3017\tden\n",
      "3144-3432\t3034-3150\tWas get.\n",
      "3551-3642\t3035-3138\t7\n",
      "3148-3527\t3191-3287\tsecret: ad\n",
      "3587-3678\t3152-3275\tIn\n",
      "3726-3797\t 991-1072\t-\n",
      "3717-3796\t 141-224\tOrt\n",
      "3721-3808\t 211-302\tJunyke\n",
      "3745-3810\t1710-1775\t6\n",
      "3752-3808\t1814-1877\t71\n",
      "3822-3932\t 141-213\tbale\n",
      "3826-3920\t 212-301\tCoffy\n",
      "3831-3927\t 400-468\t3030\n",
      "3818-3924\t 540-613\t303\n",
      "3845-3951\t 681-775\t195\n",
      "3829-3937\t 840-917\t444\n",
      "3830-3945\t 981-1072\t263\n",
      "3844-3934\t1082-1155\t580\n",
      "3866-3936\t1179-1244\t71\n",
      "3848-3937\t1259-1334\t90\n",
      "3855-3927\t1329-1403\t51\n",
      "3849-3945\t1441-1527\t24\n",
      "3865-3935\t1521-1600\t13\n",
      "3841-3937\t1706-1788\t1421\n",
      "3875-3947\t1796-1869\t51\n",
      "3869-3937\t1891-1973\t18\n",
      "3725-3794\t2021-2076\t7\n",
      "3845-3932\t2022-2076\t233\n",
      "3981-4047\t2017-2076\t36\n",
      "3712-3775\t2104-2177\tO5\n",
      "3829-3939\t2104-2165\tbale\n",
      "3955-4044\t2109-2167\tVate\n",
      "3707-3803\t2167-2219\tzuijt\n",
      "3838-3937\t2155-2230\tCoffy\n",
      "3940-4060\t2153-2223\tCoffij\n",
      "3957-4025\t2198-2267\t2\n",
      "3724-3808\t2219-2287\t--\n",
      "3823-3935\t2202-2297\t4629\n",
      "3745-3787\t2301-2359\t-\n",
      "3839-3946\t2297-2362\t512\n",
      "3959-4035\t2282-2361\t-\n",
      "3725-3794\t2380-2454\t33\n",
      "3831-3943\t2373-2466\t4793½\n",
      "3966-4072\t2378-2459\t243\n",
      "3708-3796\t2460-2543\t52.\n",
      "3820-3927\t2467-2546\t240\n",
      "3978-4063\t2458-2541\t24\n",
      "3818-3937\t2552-2623\t3030\n",
      "3984-4068\t2553-2626\t45\n",
      "3740-3803\t2638-2701\t77\n",
      "3827-3935\t2621-2700\t3233\n",
      "4000-4063\t2621-2701\t36\n",
      "3705-3813\t2772-2845\t635\n",
      "3838-3930\t2753-2846\t8648\n",
      "3953-4059\t2756-2845\t35\n",
      "3708-3804\t2909-3016\t11\n",
      "3831-4057\t2945-3021\tIuni\n",
      "3808-4018\t3074-3167\tLuij\n",
      "4014-4058\t3089-3146\t„\n",
      "3687-3935\t3198-3290\tberen\n",
      "3967-4049\t 126-211\tate\n",
      "3949-4063\t 203-296\tCoffy\n",
      "4005-4068\t 396-477\t45\n",
      "4005-4065\t 559-637\t45\n",
      "4005-4075\t1088-1140\t— —\n",
      "4009-4072\t1252-1329\t10\n",
      "4017-4068\t1330-1400\t1\n",
      "4000-4063\t1453-1512\t20\n",
      "4005-4072\t1620-1680\t5\n",
      "4095-4202\t 123-210\tbalen\n",
      "4091-4190\t 204-289\tOatoe\n",
      "4099-4188\t 398-484\t467\n",
      "4082-4190\t 511-637\t465\n",
      "4113-4181\t 692-750\t38\n",
      "4124-4210\t 826-918\t36\n",
      "4161-4204\t 910-971\t8\n",
      "4106-4180\t1069-1141\t14\n",
      "4117-4187\t1163-1245\t13\n",
      "4138-4204\t1245-1329\t6\n",
      "4144-4193\t1332-1402\t2\n",
      "4122-4195\t1433-1524\t34\n",
      "4147-4192\t1528-1599\t7\n",
      "4120-4188\t1612-1686\t3\n",
      "4122-4187\t1704-1781\t33\n",
      "4112-4210\t1787-1865\t36\n",
      "4091-4195\t2017-2075\t230\n",
      "4090-4215\t2102-2166\tBalen\n",
      "4099-4216\t2160-2209\tCatoe\n",
      "4085-4195\t2198-2282\t365\n",
      "4104-4190\t2282-2359\t138\n",
      "4100-4205\t2366-2453\t368\n",
      "4096-4199\t2469-2535\t450\n",
      "4095-4200\t2530-2619\t463\n",
      "4093-4188\t2619-2685\t230\n",
      "4077-4203\t2764-2840\t2014\n",
      "4092-4178\t2928-3021\t17\n",
      "4213-4358\t2937-3032\t89.\n",
      "4056-4255\t3073-3158\tEen.\n",
      "4283-4834\t 117-267\tGedestineerd naar\n",
      "4203-4613\t 458-553\tGeen Lading\n",
      "4616-4865\t 458-552\tAmsterdam\n",
      "4222-4571\t 671-758\tVat Cacao.\n",
      "4651-4837\t 662-752\tidem\n",
      "4241-4607\t 736-841\tGeen Ladin\n",
      "4638-4836\t 745-826\tiden\n",
      "4213-4282\t 826-908\t„\n",
      "4618-4869\t 813-893\tModdelb.\n",
      "4632-4863\t 883-973\tAmsteelan\n",
      "4642-4838\t 962-1054\tVlissinge\n",
      "4617-4840\t1045-1139\tmiddelb.\n",
      "4614-4783\t1133-1227\tAmst\n",
      "4631-4816\t1220-1310\tidem\n",
      "4626-4793\t1305-1392\tidem\n",
      "4622-4829\t1405-1486\tidem\n",
      "4619-4825\t1500-1583\tidem\n",
      "4623-4833\t1583-1661\tidem\n",
      "4246-4829\t1674-1777\t1Vat Limoensap Middel\n",
      "4620-4799\t1758-1843\tiden\n",
      "4601-4826\t1837-1943\tAmstr\n",
      "4359-4837\t1992-2096\tZynde totheden\n"
     ]
    }
   ],
   "source": [
    "for line in sort_lines_in_column_reading_order(table_scan):\n",
    "    print(f'{line.coords.left: >4}-{line.coords.right}\\t{line.coords.top: >4}-{line.coords.bottom}\\t{line.text}')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sorting by row"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1440-1583\t 369-462\t22\n",
      "3628-3723\t 366-465\t23\n",
      " 688-2321\t 418-544\tkunnen brengen. Dit is best te zien, wanneer men de on-\n",
      "2882-4503\t 427-542\tgeld en victualie, des maands 2165 guldens, dus in 27 maan-\n",
      " 685-2329\t 509-615\tkosten, die de Oostindische Compagnie moet doen, om de\n",
      "2892-4508\t 507-612\tden 25564 guldens; by gevolg kosten de dertig schepen\n",
      " 688-2313\t 577-682\tWaaren uit Europa na Batavia, en weer anderen van daar\n",
      "2881-4037\t 584-676\taan maandgeld en victualie in 21 maanden\n",
      "4068-4158\t 582-661\t„\n",
      "4167-4255\t 588-663\tE\n",
      "4253-4504\t 589-671\t1366950\n",
      " 683-2320\t 650-755\tna Europa te zenden, vergelykt met de onkosten, die de\n",
      "2942-4221\t 651-753\tzoo menrekend dat ieder tregat-schip gl. boooc\n",
      " 691-2332\t 720-821\tWestindische Compagnie volgens dit Project zou behoeven\n",
      "2880-4224\t 719-820\tkost, en de Intrest van dit Capitaal rekend tegen\n",
      " 694-2328\t 791-893\tte doen, om, als gezegd is, haare Waaren uit Europa over\n",
      "2890-4247\t 784-888\t3:½ per cent in ’t jaar, zou ieder schip jaarlyks aan\n",
      " 695-2331\t 862-955\tde Kust van Magellaan na ’t Land van 5. Esprit, en van daar\n",
      "2876-4236\t 853-954\tInterest kosten gl. 2100, en dus in 21 maanden\n",
      " 700-2317\t 932-1034\tweer anderen na Europate zenden: want, wanneer men, by\n",
      "2870-3780\t 929-1026\t81. 3675, dat is voor 30 schepen\n",
      "4303-4499\t 933-1003\t110250\n",
      " 704-2329\t 994-1095\tvoorheeld, verondersteld, dat die beide Compagnien jaar-\n",
      "2945-4237\t 991-1096\tVoor ’t verouderen van ’t schip, en voor ’t on-\n",
      " 686-2332\t1057-1163\tlyks dertig scheepslaadingen na de voorschreeve Plaatsen\n",
      "2880-4231\t1065-1160\tderhoud van ’t schip, aan Zeilen en Louwerk, enz.\n",
      " 689-2330\t1134-1228\tuitzenden, en weer t'huisbekomen, zoo blykt, dat de onkos-\n",
      "2888-4238\t1130-1229\tkan men rekenen gl.booo in ’t jaar, dat is in 24\n",
      " 695-2327\t1206-1302\tten, die de Westindische Compagnie ten dien einde zou be-\n",
      "2877-4222\t1194-1308\tmaanden gl. Iooo, en dus voor de dertig thuns\n",
      " 694-2334\t1278-1367\thoeven aan te wenden, verscheide Ponnen Gonds minder\n",
      "2876-3377\t1279-1367\tkomende schepen\n",
      "4293-4518\t1261-1351\t420000\n",
      " 703-2330\t1341-1444\tzouden bedraagen, als de onkosten van de Oostindische Com-\n",
      "2952-4235\t1334-1433\tAan Proemien voor ieder t' huiskomend schip\n",
      " 701-911\t1415-1505\tpagnie.\n",
      "2871-4225\t1408-1504\tmoet men rekenen gl. 16774, dus voor dertig\n",
      " 769-2107\t1480-1576\tTot bewys hier van diend de volgende Balance:\n",
      "2882-3107\t1492-1562\tschepen\n",
      "4296-4515\t1467-1558\t503220\n",
      " 762-2320\t1548-1650\tDe Oostindische Compagnie wordt verondersteld uit Ku\n",
      "2939-4226\t1545-1643\tzoo dat de dertig scheepslaadingen, die uit\n",
      " 702-1634\t1620-1709\tropa na Batavia te zullen zenden,\n",
      "2878-4228\t1619-1710\tEuropa na Batavia, en die van Batavia na Europg\n",
      " 688-2334\t1687-1782\t10. Schepen in Mai 1773. welke t'huis zullen komen Nov:o 1774.\n",
      "2889-4239\t1683-1785\twerden gezonden, aan de Oostindische Compag-\n",
      " 707-2334\t1757-1854\t10. dito vaaren uit in Sept: 1773. en komen t'huis in July 1775.\n",
      "2871-3942\t1758-1850\tnie komen te staan op eene somma van\n",
      "4189-4522\t1748-1833\tvƒ 2400420\n",
      " 697-891\t1821-1904\t10. dito\n",
      "1172-1514\t1831-1912\tin Dec:o 177\n",
      "1464-1515\t1876-1912\t1\n",
      "1934-2258\t1831-1915\tin Octob: 17\n",
      "2277-2334\t1841-1913\t5.\n",
      "2953-4514\t1814-1916\tEn zoo de Westindische Compagnie jaarlyks Hekboots\n",
      " 705-896\t1896-1971\t10. dito\n",
      "1177-1532\t1896-1986\tin Mai 1774\n",
      "1950-2221\t1895-1990\tin Nov: 2\n",
      "2251-2334\t1910-1982\t25\n",
      "2881-4524\t1884-1986\tvan 136 voet lang, die met 45 zeevarende Persoonen be-\n",
      " 701-893\t1951-2031\t10. dito\n",
      "1171-1525\t1954-2051\tin Sept: 1774\n",
      "1944-2340\t1966-2054\tin July 1776.\n",
      "2876-4526\t1954-2055\tmant worden, van de slaven 5. Juliaan na ’t Land van 5. Aspril\n",
      " 701-919\t2025-2130\t20 dito\n",
      " 919-964\t2033-2108\t—\n",
      "1168-1523\t2029-2121\tin Dec: 1774.\n",
      "1562-1607\t2037-2106\t—\n",
      "1911-2342\t2031-2120\tin Octob: 1776.\n",
      "2880-4512\t2017-2121\teen reis heen en weerom liet doen, zoo zou ieder schip aan\n",
      " 699-903\t2100-2182\t20. dito\n",
      "1177-2333\t2096-2191\tin Mai 1775. zynde de bovengemelde so\n",
      "2884-4523\t2089-2191\tmaandgeld en viclualie, ieder maand kosten gl. 1247, dat\n",
      " 694-2325\t2157-2272\tschepen, die in November 1774 waren t'huis gekomen; bly.\n",
      "2892-4511\t2157-2262\tis voor twaalf maanden gl. 14964, en dus voor dertig sche\n",
      " 695-2333\t2234-2329\tvende dus bo schepen, die de Oostindische Compagnie noo-\n",
      "2885-3006\t2245-2332\tpen\n",
      "4194-4277\t2230-2316\t8.\n",
      "4292-4523\t2224-2309\t448920\n",
      " 697-2330\t2303-2397\tsig heeft, om de Vaart aan de gang te houden, indien de\n",
      "2966-4255\t2295-2391\tEn als tien Hekboots van 136 voet, in de maand\n",
      " 687-2335\t2368-2470\tzelve dertig scheepslaadingen alle jaaren uit en t' huis begeerd\n",
      "2886-4251\t2361-2472\tvan Maart, uit Europana de Slaven 5. Juliaan vol-\n",
      " 709-984\t2430-2526\tte hebben,\n",
      "2894-4234\t2435-2529\tren, en van daar weerterug na Europa wierden ge-\n",
      " 769-2333\t2495-2603\tDe eerste schepen doen, gelyk uit de voorgaande Latel\n",
      "2889-4247\t2498-2602\tzonden met de Waaren door de eerstgemelde Sche-\n",
      " 712-2331\t2577-2671\tte zien is, haar reis in agttien maanden, die van de tweede\n",
      "2905-4249\t2571-2667\tsen in de slaven 5. Juliaan gebragt, en de zelve haar\n",
      " 708-2329\t2647-2740\tverzending in twee en twintig maanden, en van de derde\n",
      "2879-4253\t2643-2738\treis in agt maanden kwamen te doen: (te weeten\n",
      " 691-2331\t2714-2807\tverzending mede in twee en twintig maanden: zynde dus\n",
      "2891-4242\t2707-2805\theen en weerom,) en als daaren boven nog tien Sche-\n",
      " 698-2326\t2783-2876\ttwee en zestig maanden, dat de dertig jaarlyks t' huiskomen\n",
      "2901-4243\t2775-2873\tpen in de maand September en December nog z0\n",
      " 696-2342\t2851-2948\tde Fregat-schepen (want zoodanige schepen gebruikt de\n",
      "2884-4261\t2840-2948\tschepen uit Europa na de slaven 5. Juliaan, en\n",
      " 712-2329\t2919-3028\tOost-indische Compagnie) in Zee of bemant zyn geweest.\n",
      "2897-4264\t2912-3013\tvan daar weer na Europa wierden gezonden: dan\n",
      " 703-2333\t2983-3082\tte weeten met go zeevaarende Persoonen, zynde het ordi-\n",
      "2877-4249\t2982-3078\thadt ieder schip aan onkosten, zoo aan victualie\n",
      " 696-2325\t3049-3158\tnaris getal daar een Fregat mee bemant wordt: want die op\n",
      "2882-4241\t3044-3153\tals maandgeld, ieder maand gl. 1247, dat is in agt\n",
      " 707-2333\t3123-3223\tde uitgaande Oostindische schepen meer worden meege-\n",
      "2892-4246\t3119-3216\tmaanden gl.9976, en dus de dertig uit en t' huis\n",
      " 697-2335\t3183-3296\tgeeven, worden eigentlyk gestuurd om de ontbreekende\n",
      "4305-4517\t3190-3272\t299280\n",
      "2888-3405\t3193-3294\tvaarende schepen\n",
      " 706-1693\t3260-3356\tmanschap in Oostindie te vervullen.\n",
      "1696-1843\t3271-3352\t141\n",
      " 773-2343\t3326-3438\tIeder Fregatschip, bemant als vooren, kost aan maand\n",
      "4185-4524\t3325-3421\t8.. 748200\n",
      "2195-2342\t3411-3511\tged\n",
      "3589-3734\t3404-3497\tF 2\n",
      "4058-4256\t3367-3473\tFrans\n"
     ]
    }
   ],
   "source": [
    "from pagexml.helper.pagexml_helper import sort_lines_in_row_reading_order\n",
    "\n",
    "for line in sort_lines_in_row_reading_order(two_column_scan):\n",
    "    print(f'{line.coords.left: >4}-{line.coords.right}\\t{line.coords.top: >4}-{line.coords.bottom}\\t{line.text}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1827-2259\t  85-262\tGedestineert\n",
      "\n",
      "1383-1472\t 115-224\tbale\n",
      "4283-4834\t 117-267\tGedestineerd naar\n",
      "\n",
      "1144-1254\t 128-217\tVate\n",
      "1624-1732\t 119-215\tBale\n",
      "3967-4049\t 126-211\tate\n",
      "4095-4202\t 123-210\tbalen\n",
      "\n",
      "  94-277\t 132-247\tdatum\n",
      "1262-1348\t 136-225\tOrt\n",
      "1507-1592\t 133-227\tVate\n",
      "3575-3678\t 141-220\tvate\n",
      "3717-3796\t 141-224\tOrt\n",
      "3822-3932\t 141-213\tbale\n",
      "\n",
      " 327-712\t 159-256\tNaander schoep\n",
      " 721-1110\t 168-257\tNaam der schip\n",
      "2263-2448\t 173-250\twaar\n",
      "2501-2733\t 163-259\tdatum\n",
      "2771-3165\t 167-265\tNaamder scheeps\n",
      "3171-3561\t 172-272\tNaamder schip per\n",
      "\n",
      "1139-1247\t 209-277\tZuyk\n",
      "1254-1364\t 224-289\tZuik\n",
      "1375-1484\t 217-299\tCoffen\n",
      "1501-1609\t 221-300\tCosfi\n",
      "1623-1735\t 210-289\tCatoe\n",
      "3547-3702\t 206-294\tZuyke\n",
      "3721-3808\t 211-302\tJunyke\n",
      "3826-3920\t 212-301\tCoffy\n",
      "3949-4063\t 203-296\tCoffy\n",
      "4091-4190\t 204-289\tOatoe\n",
      "\n",
      "2556-2752\t 323-469\tAan\n",
      "\n",
      " 100-229\t 356-418\t1787\n",
      " 744-1112\t 367-587\tW: g den Boet\n",
      "\n",
      " 320-615\t 377-503\tdecourier\n",
      "2248-2454\t 383-482\tAmstf\n",
      "3167-3696\t 383-482\tnrestaande Maertans 2294\n",
      "\n",
      "2775-3160\t 387-572\t: Werdenbende\n",
      "\n",
      "2759-3157\t 389-485\tTransport van Om\n",
      "3831-3927\t 400-468\t3030\n",
      "4005-4068\t 396-477\t45\n",
      "4099-4188\t 398-484\t467\n",
      "\n",
      "  95-282\t 411-505\tMaart\n",
      " 731-1095\t 413-505\tM. Vzeydag\n",
      "1255-1320\t 428-476\t:\n",
      "1330-1378\t 440-501\t—\n",
      "1410-1498\t 415-481\t34\n",
      "1669-1732\t 405-487\t15\n",
      "2542-2647\t 446-520\t1792\n",
      "3198-3534\t 454-549\tE. Koerssen\n",
      "3256-3499\t 454-644\tTal\n",
      "4203-4613\t 458-553\tGeen Lading\n",
      "4616-4865\t 458-552\tAmsterdam\n",
      "\n",
      " 236-283\t 510-576\t21\n",
      " 316-648\t 496-591\tde zee Compas\n",
      "1801-2213\t 482-584\tGeen Lading\n",
      "2277-2460\t 476-570\tidem\n",
      "2505-2677\t 493-566\tOctober\n",
      "2672-2731\t 501-566\tC\n",
      "\n",
      "2254-2441\t 548-637\tMidalber\n",
      "3569-3679\t 564-641\t2294\n",
      "3818-3924\t 540-613\t303\n",
      "4005-4065\t 559-637\t45\n",
      "4082-4190\t 511-637\t465\n",
      "\n",
      " 228-298\t 588-665\t31\n",
      " 322-694\t 576-666\tEsseg: Societeit\n",
      " 745-1053\t 573-665\tB. Govert\n",
      "1160-1252\t 576-667\t112\n",
      "1297-1360\t 585-653\t80\n",
      "1397-1485\t 586-664\t398\n",
      "1641-1723\t 585-653\t103\n",
      "2533-2666\t 612-707\t1789\n",
      "\n",
      "  78-206\t 645-728\tApri\n",
      " 320-600\t 646-743\tde Vreede\n",
      " 732-1107\t 645-736\tJ. H. Tienken\n",
      "1156-1246\t 656-735\t257\n",
      "1646-1735\t 649-732\t60\n",
      "1784-2176\t 648-722\t3 balen Cacao\n",
      "2257-2413\t 640-724\tiden\n",
      "2773-3134\t 657-789\tAkkerydam\n",
      "\n",
      " 241-283\t 665-735\t10\n",
      "1403-1477\t 669-738\t845\n",
      "2501-2723\t 688-786\tJanuari 21\n",
      "3194-3556\t 678-777\t.Wolgehagen\n",
      "3845-3951\t 681-775\t195\n",
      "4222-4571\t 671-758\tVat Cacao.\n",
      "4651-4837\t 662-752\tidem\n",
      "\n",
      "3583-3668\t 700-772\t108\n",
      "4113-4181\t 692-750\t38\n",
      "\n",
      " 243-293\t 737-822\t2\n",
      " 339-589\t 728-820\tAmerika\n",
      " 734-1132\t 728-815\tAd. Adriaans Na\n",
      "2258-2429\t 736-820\tAmst\n",
      "4241-4607\t 736-841\tGeen Ladin\n",
      "\n",
      "1411-1479\t 737-894\t35\n",
      "\n",
      "1149-1236\t 751-838\t162\n",
      "1278-1345\t 764-843\t——\n",
      "1660-1733\t 755-828\t40\n",
      "3180-3534\t 758-851\tC. C. Heyde\n",
      "4638-4836\t 745-826\tiden\n",
      "\n",
      "2485-2731\t 790-860\tFebrwana\n",
      "2785-3132\t 770-857\tCathar, Theodor\n",
      "\n",
      " 324-699\t 799-907\tAkker &amp; dam\n",
      " 827-1071\t 800-849\t„ning zoon\n",
      "\n",
      " 750-1058\t 817-898\tR. Broers\n",
      "1510-1616\t 814-903\t- - -\n",
      "1674-1736\t 822-911\t21\n",
      "2257-2416\t 810-907\tidem\n",
      "4618-4869\t 813-893\tModdelb.\n",
      "\n",
      "1163-1229\t 833-899\t- -\n",
      "3162-3520\t 826-925\tA. Ritchie\n",
      "4124-4210\t 826-918\t36\n",
      "4213-4282\t 826-908\t„\n",
      "\n",
      "3829-3937\t 840-917\t444\n",
      "\n",
      "2752-3130\t 852-942\tde Vriendschap\n",
      "\n",
      "1778-2230\t 873-972\t236xh. Limpensag\n",
      "4632-4863\t 883-973\tAmsteelan\n",
      "\n",
      " 326-716\t 884-1068\t1 Eensgezenhen\n",
      "\n",
      " 240-310\t 919-977\t24\n",
      " 338-710\t 891-980\tIuffrouw Snoek\n",
      " 743-1113\t 895-977\tI: Andriessen\n",
      "1189-1252\t 920-978\t89\n",
      "1409-1491\t 920-992\t498\n",
      "1671-1744\t 915-990\t84\n",
      "1810-2134\t 940-1016\t3022. Rum\n",
      "2264-2462\t 900-988\t„ Middelh:\n",
      "2481-2730\t 920-1015\tMaart 13\n",
      "2761-3034\t 921-1024\tde Liefde\n",
      "3162-3526\t 907-1004\tI. Hturck\n",
      "4161-4204\t 910-971\t8\n",
      "4642-4838\t 962-1054\tVlissinge\n",
      "\n",
      "  75-193\t 966-1057\tMai\n",
      " 760-1096\t 968-1065\tH:s Koevbedt\n",
      "2255-2417\t 972-1054\tAmst.\n",
      "\n",
      "1167-1235\t1003-1054\t—\n",
      "1397-1491\t1000-1072\t57½\n",
      "1680-1744\t 988-1067\t39\n",
      "1816-1929\t1001-1041\t„ -\n",
      "3175-3514\t 974-1085\tC. Pieterse\n",
      "3726-3797\t 991-1072\t-\n",
      "3830-3945\t 981-1072\t263\n",
      "\n",
      "2757-3138\t1009-1105\tde Zeenimph\n",
      "3591-3678\t1011-1081\t171\n",
      "\n",
      "2241-2457\t1034-1103\tmiddelb:\n",
      "\n",
      " 328-664\t1056-1144\tVrees &amp; Hoog\n",
      " 738-1099\t1050-1141\tJacob Bievert.\n",
      "1161-1247\t1056-1142\t352\n",
      "1515-1631\t1060-1140\t- - - -\n",
      "1680-1727\t1049-1140\t13\n",
      "4617-4840\t1045-1139\tmiddelb.\n",
      "\n",
      "1399-1491\t1073-1145\t944\n",
      "4106-4180\t1069-1141\t14\n",
      "\n",
      "2757-3031\t1081-1189\tde Vreede\n",
      "3174-3549\t1085-1177\tI. A. Sienke\n",
      "3595-3684\t1083-1161\t155\n",
      "3844-3934\t1082-1155\t580\n",
      "4005-4075\t1088-1140\t— —\n",
      "\n",
      "2253-2433\t1104-1191\tAmstsr\n",
      "2670-2740\t1119-1188\t20\n",
      "\n",
      " 339-716\t1128-1229\tde vziend George\n",
      " 750-1085\t1127-1224\tEld:t Evertsen\n",
      "1168-1244\t1136-1218\t—\n",
      "1407-1477\t1127-1203\t15\n",
      "1545-1592\t1135-1219\t2\n",
      "1669-1727\t1127-1199\t7\n",
      "4614-4783\t1133-1227\tAmst\n",
      "\n",
      "4117-4187\t1163-1245\t13\n",
      "\n",
      "2750-3135\t1164-1284\tSchoonhoven\n",
      "3866-3936\t1179-1244\t71\n",
      "\n",
      "  73-211\t1184-1290\tJuni\n",
      " 338-709\t1207-1298\tde verwagting\n",
      " 749-1117\t1200-1292\tA: Bappelhof\n",
      "1161-1243\t1210-1290\t230\n",
      "1292-1376\t1201-1280\t166\n",
      "2252-2438\t1196-1278\tmiddels\n",
      "2661-2743\t1203-1269\t20\n",
      "3172-3547\t1190-1275\tP. C. Spiegilber\n",
      "\n",
      "2689-2731\t1210-1360\t93\n",
      "\n",
      "1409-1491\t1217-1299\t191\n",
      "1531-1624\t1212-1287\t– —\n",
      "1673-1739\t1215-1290\t17\n",
      "4631-4816\t1220-1310\tidem\n",
      "\n",
      "3848-3937\t1259-1334\t90\n",
      "4009-4072\t1252-1329\t10\n",
      "4138-4204\t1245-1329\t6\n",
      "\n",
      " 333-673\t1281-1369\tde Regina\n",
      " 744-1092\t1279-1374\tA. Rittschie\n",
      "1437-1479\t1287-1367\t3\n",
      "1669-1711\t1287-1369\t-\n",
      "2262-2436\t1263-1346\tidem\n",
      "2481-2652\t1273-1353\tApril\n",
      "2757-3060\t1264-1355\tde Boode\n",
      "3175-3487\t1260-1350\tR. Broers\n",
      "\n",
      "1152-1262\t1298-1375\t148\n",
      "3855-3927\t1329-1403\t51\n",
      "4017-4068\t1330-1400\t1\n",
      "4144-4193\t1332-1402\t2\n",
      "4626-4793\t1305-1392\tidem\n",
      "\n",
      " 336-706\t1363-1459\tde Vrouw Mari\n",
      " 741-1085\t1363-1464\tA. Reyding\n",
      "1301-1383\t1376-1456\t84\n",
      "1418-1486\t1372-1450\t32\n",
      "2256-2467\t1346-1445\tRotterdam\n",
      "2761-3103\t1350-1443\tde Een dragt\n",
      "3165-3463\t1337-1426\tH:k Steur\n",
      "\n",
      " 240-296\t1399-1470\t10\n",
      "4622-4829\t1405-1486\tidem\n",
      "\n",
      "1652-1739\t1442-1528\t23\n",
      "2256-2416\t1428-1518\tAmst.\n",
      "3157-3469\t1418-1527\tA: Adriaan\n",
      "3849-3945\t1441-1527\t24\n",
      "4122-4195\t1433-1524\t34\n",
      "\n",
      " 327-719\t1452-1547\tde nieuwe Expediti\n",
      " 763-1085\t1449-1554\tI. A. Redge\n",
      "1517-1590\t1450-1531\t-.\n",
      "4000-4063\t1453-1512\t20\n",
      "\n",
      " 231-306\t1460-1546\t28\n",
      "2759-3075\t1458-1547\tAmerika\n",
      "3586-3702\t1457-1550\t241\n",
      "\n",
      "1413-1502\t1460-1524\t37\n",
      "\n",
      "1170-1230\t1487-1547\t-\n",
      "2649-2731\t1472-1549\t28\n",
      "3198-3547\t1503-1575\tNanning Jonn\n",
      "4619-4825\t1500-1583\tidem\n",
      "\n",
      " 754-1080\t1524-1623\tP. Sturck\n",
      "1687-1732\t1521-1603\t7\n",
      "2259-2394\t1510-1593\tiden\n",
      "3865-3935\t1521-1600\t13\n",
      "4147-4192\t1528-1599\t7\n",
      "\n",
      "  63-169\t1535-1620\tJuly\n",
      " 335-712\t1529-1623\tde Kerterl. Vriendsch\n",
      "2481-2628\t1538-1629\tJunij\n",
      "2680-2724\t1542-1622\t2\n",
      "2759-3132\t1536-1629\tMarimiliaan\n",
      "\n",
      "1411-1477\t1549-1594\t„ -\n",
      "3164-3562\t1551-1622\tI. Borselman\n",
      "\n",
      "2258-2393\t1594-1680\tidem\n",
      "4623-4833\t1583-1661\tidem\n",
      "\n",
      " 330-674\t1609-1708\tHandel Lust\n",
      "1423-1486\t1610-1702\t19\n",
      "3185-3509\t1600-1721\tS. Rickels\n",
      "4120-4188\t1612-1686\t3\n",
      "\n",
      " 743-1120\t1617-1713\tI. Wolgehagen\n",
      "1314-1365\t1620-1706\t17\n",
      "2748-3149\t1616-1723\tCarl &amp; Magdalen\n",
      "4005-4072\t1620-1680\t5\n",
      "\n",
      "1184-1247\t1629-1692\t89\n",
      "3604-3687\t1631-1703\t06\n",
      "\n",
      " 333-626\t1690-1781\tt zeepaard\n",
      "2272-2399\t1679-1752\tiden\n",
      "4246-4829\t1674-1777\t1Vat Limoensap Middel\n",
      "\n",
      " 745-1097\t1693-1787\tAnd:s Muller\n",
      "1426-1497\t1713-1782\t30\n",
      "1573-1615\t1711-1783\t2\n",
      "2758-3121\t1719-1819\tvrees &amp; Hoop\n",
      "3163-3506\t1692-1803\tI. Rieverts\n",
      "3583-3688\t1713-1791\t157\n",
      "3745-3810\t1710-1775\t6\n",
      "3841-3937\t1706-1788\t1421\n",
      "4122-4187\t1704-1781\t33\n",
      "\n",
      " 246-293\t1720-1793\t11\n",
      " 338-701\t1772-1864\tde vriendsschap\n",
      " 752-1115\t1772-1872\tCorn.s Gerrits\n",
      "1665-1735\t1768-1849\t10\n",
      "2258-2452\t1759-1857\tmiddelb\n",
      "2671-2729\t1751-1834\t9\n",
      "4620-4799\t1758-1843\tiden\n",
      "\n",
      "3172-3544\t1784-1907\tW:r Oostdyk\n",
      "\n",
      " 236-321\t1795-1868\t23\n",
      "1184-1247\t1793-1863\t45\n",
      "1307-1363\t1786-1861\t81\n",
      "3599-3686\t1797-1880\t65\n",
      "3752-3808\t1814-1877\t71\n",
      "3875-3947\t1796-1869\t51\n",
      "4112-4210\t1787-1865\t36\n",
      "\n",
      " 340-722\t1852-1943\tsabelle Johann\n",
      " 771-1071\t1857-1953\tG: de Groot\n",
      "1587-1638\t1864-1935\t1\n",
      "1692-1737\t1870-1943\t1\n",
      "2263-2420\t1844-1938\tidem\n",
      "2751-3147\t1823-1924\tde Algem: Welbeer\n",
      "4601-4826\t1837-1943\tAmstr\n",
      "\n",
      "3154-3533\t1883-2010\tM. Hanssen\n",
      "\n",
      "1201-1271\t1889-1950\t12\n",
      "1315-1384\t1884-1947\t71\n",
      "3869-3937\t1891-1973\t18\n",
      "\n",
      " 248-311\t1952-2017\t27\n",
      " 327-733\t1935-2036\tde vigilantie\n",
      " 756-1133\t1938-2034\tC. Andriessen\n",
      "1299-1386\t1944-2017\t25\n",
      "1428-1491\t1940-2010\t20\n",
      "1596-1641\t1978-2017\t—\n",
      "1805-1879\t1940-2017\t-\n",
      "2238-2442\t1936-2029\tVlissinge\n",
      "2673-2715\t1926-2017\t1\n",
      "2768-3090\t1918-2018\tdevrijheid\n",
      "\n",
      " 125-234\t2016-2090\t1788\n",
      " 827-1025\t2016-2099\tTotal\n",
      "1276-1382\t2011-2091\t523\n",
      "1549-1625\t2011-2085\t24\n",
      "1648-1744\t2013-2085\t450\n",
      "3210-3456\t1981-2094\tTotal\n",
      "4359-4837\t1992-2096\tZynde totheden\n",
      "\n",
      "3583-3668\t2020-2076\t937\n",
      "3981-4047\t2017-2076\t36\n",
      "4091-4195\t2017-2075\t230\n",
      "\n",
      "1150-1272\t2021-2094\t1496„\n",
      "3725-3794\t2021-2076\t7\n",
      "\n",
      "1404-1489\t2022-2090\t240\n",
      "3845-3932\t2022-2076\t233\n",
      "\n",
      "  64-322\t2071-2168\tMaart 26\n",
      " 349-732\t2067-2168\tde Goede verwagt\n",
      " 761-1063\t2085-2179\tJan Koert\n",
      "2258-2427\t2078-2174\tAmstvr:\n",
      "\n",
      "1177-1244\t2087-2130\to\n",
      "1808-2222\t2087-2183\tGeen Lading\n",
      "3560-3668\t2113-2170\tVaten\n",
      "3712-3775\t2104-2177\tO5\n",
      "3829-3939\t2104-2165\tbale\n",
      "3955-4044\t2109-2167\tVate\n",
      "4090-4215\t2102-2166\tBalen\n",
      "\n",
      "1145-1247\t2121-2163\t--\n",
      "1660-1746\t2116-2153\t- - -\n",
      "3940-4060\t2153-2223\tCoffij\n",
      "\n",
      " 758-1108\t2155-2251\tJacob Iacobs\n",
      "3838-3937\t2155-2230\tCoffy\n",
      "\n",
      " 331-727\t2156-2251\tde Johanne Adrian\n",
      "1765-2096\t2156-2243\tidem.\n",
      "2256-2425\t2158-2242\tidem\n",
      "3572-3679\t2163-2212\tzuyke\n",
      "3707-3803\t2167-2219\tzuijt\n",
      "4099-4216\t2160-2209\tCatoe\n",
      "\n",
      "2758-3480\t2190-2295\tCarga over Anno 1784\n",
      "3957-4025\t2198-2267\t2\n",
      "\n",
      "3572-3685\t2211-2290\t1525„\n",
      "3724-3808\t2219-2287\t--\n",
      "3823-3935\t2202-2297\t4629\n",
      "4085-4195\t2198-2282\t365\n",
      "\n",
      "  63-236\t2230-2310\tApril\n",
      " 336-671\t2232-2321\tde Goede Hoop\n",
      " 749-1122\t2230-2326\tC. van Muye\n",
      "1224-1287\t2249-2312\t2\n",
      "1349-1403\t2250-2320\t„\n",
      "1411-1520\t2233-2310\t405\n",
      "1533-1580\t2242-2291\t-\n",
      "1664-1727\t2233-2310\t5\n",
      "2251-2477\t2225-2307\tLissingen\n",
      "\n",
      "1449-1512\t2301-2371\t17\n",
      "1506-1593\t2292-2377\t.\n",
      "2254-2427\t2290-2374\tAmm\n",
      "2766-3054\t2295-2386\tidem.\n",
      "3567-3698\t2283-2371\t1514½\n",
      "3839-3946\t2297-2362\t512\n",
      "3959-4035\t2282-2361\t-\n",
      "4104-4190\t2282-2359\t138\n",
      "\n",
      "3745-3787\t2301-2359\t-\n",
      "\n",
      " 742-1089\t2303-2404\tM. Hanssen\n",
      "1663-1738\t2309-2382\t11\n",
      "3326-3476\t2304-2382\t1785\n",
      "\n",
      " 335-608\t2311-2405\tde vrijheid\n",
      "2251-2436\t2357-2455\tmiddelb:\n",
      "3563-3677\t2372-2454\t2826\n",
      "4100-4205\t2366-2453\t368\n",
      "\n",
      "1177-1264\t2373-2469\t644\n",
      "\n",
      " 248-311\t2408-2481\t10\n",
      " 342-712\t2386-2483\tBrandenbur\n",
      " 765-1103\t2388-2479\tC. Bredaun\n",
      "1297-1369\t2405-2468\t- -\n",
      "1430-1583\t2380-2474\t96\n",
      "1664-1751\t2373-2448\t24\n",
      "2775-3074\t2382-2481\tidem.\n",
      "3073-3120\t2399-2469\t-—\n",
      "3326-3477\t2381-2455\t1786\n",
      "3725-3794\t2380-2454\t33\n",
      "3831-3943\t2373-2466\t4793½\n",
      "3966-4072\t2378-2459\t243\n",
      "\n",
      " 335-652\t2458-2557\tde Boode\n",
      " 759-1087\t2459-2545\tR. Broeri\n",
      "1427-1534\t2451-2533\t186.\n",
      "1535-1606\t2454-2538\t„-\n",
      "1673-1737\t2448-2542\t17\n",
      "2256-2425\t2442-2529\tAmsts\n",
      "3323-3475\t2459-2545\t1787\n",
      "3565-3709\t2452-2544\t1496\n",
      "3708-3796\t2460-2543\t52.\n",
      "3978-4063\t2458-2541\t24\n",
      "\n",
      "2784-3033\t2466-2561\tidem.\n",
      "\n",
      "1168-1212\t2469-2530\t-\n",
      "3820-3927\t2467-2546\t240\n",
      "4096-4199\t2469-2535\t450\n",
      "\n",
      " 253-316\t2551-2621\t17\n",
      " 345-684\t2530-2629\tde Johanne\n",
      "1425-1507\t2551-2638\t182\n",
      "1568-1631\t2549-2635\t20\n",
      "2260-2421\t2523-2615\tidem\n",
      "2783-3074\t2551-2640\tidem.\n",
      "4095-4200\t2530-2619\t463\n",
      "\n",
      "1683-1746\t2556-2617\t28\n",
      "3579-3675\t2553-2631\t2294\n",
      "3818-3937\t2552-2623\t3030\n",
      "3984-4068\t2553-2626\t45\n",
      "\n",
      " 759-1098\t2565-2649\tJI. Homberg\n",
      "3320-3469\t2558-2640\t1788\n",
      "\n",
      " 402-719\t2599-2672\tMargaretha\n",
      "3827-3935\t2621-2700\t3233\n",
      "4000-4063\t2621-2701\t36\n",
      "4093-4188\t2619-2685\t230\n",
      "\n",
      " 765-1096\t2628-2742\tC. P. Kraay\n",
      "1805-2219\t2636-2737\tGeen Lading\n",
      "2247-2458\t2642-2716\tidem\n",
      "2779-3025\t2640-2726\tidem\n",
      "3328-3469\t2640-2706\t1780\n",
      "3590-3668\t2638-2724\t93½\n",
      "3740-3803\t2638-2701\t77\n",
      "\n",
      "2782-3142\t2642-2864\tGeneraad\n",
      "\n",
      " 345-689\t2643-2741\tde dolphyn\n",
      "1643-1760\t2643-2743\t„-\n",
      "\n",
      " 257-311\t2731-2809\t21\n",
      " 337-613\t2720-2797\tde vreede\n",
      " 757-1138\t2724-2814\tJ. H. Thienke\n",
      "1158-1276\t2729-2820\t342\n",
      "1315-1379\t2720-2809\t-\n",
      "1412-1516\t2742-2812\t478\n",
      "1661-1737\t2734-2811\t21\n",
      "2221-2427\t2709-2807\tmiddelb\n",
      "\n",
      "  63-193\t2779-2857\tMay\n",
      " 272-325\t2805-2867\t5\n",
      " 339-738\t2794-2877\tt Fortuynter zee\n",
      " 759-1106\t2788-2882\tM. Pieterse\n",
      "1446-1503\t2801-2869\t1\n",
      "2243-2431\t2776-2863\tAmstr\n",
      "3143-3185\t2802-2851\t2\n",
      "3214-3491\t2768-2851\tMontant\n",
      "3570-3676\t2767-2842\t10593\n",
      "3705-3813\t2772-2845\t635\n",
      "3838-3930\t2753-2846\t8648\n",
      "3953-4059\t2756-2845\t35\n",
      "4077-4203\t2764-2840\t2014\n",
      "\n",
      "1181-1269\t2805-2871\t187\n",
      "1285-1372\t2811-2879\t. -\n",
      "1678-1741\t2806-2872\t70\n",
      "\n",
      " 254-324\t2854-2947\t13\n",
      " 345-628\t2854-2938\tdeCouvier\n",
      " 758-1086\t2857-2955\tM: Vreijdan\n",
      "1449-1512\t2876-2930\t11\n",
      "1685-1727\t2900-2933\t-\n",
      "2247-2392\t2848-2937\tidem\n",
      "\n",
      " 264-328\t2930-2998\t14\n",
      " 350-680\t2923-3025\tde Verwagtin\n",
      " 757-1078\t2927-3014\tR. Boom\n",
      "1184-1269\t2944-3015\t141\n",
      "1433-1526\t2935-2996\t664\n",
      "1680-1765\t2933-3015\t46\n",
      "2213-2457\t2914-3010\tmiddelb.\n",
      "2852-3058\t2937-3017\tM\n",
      "3140-3535\t2929-3023\tSsequebo\n",
      "3569-3679\t2902-3017\tden\n",
      "3708-3804\t2909-3016\t11\n",
      "3831-4057\t2945-3021\tIuni\n",
      "4092-4178\t2928-3021\t17\n",
      "4213-4358\t2937-3032\t89.\n",
      "\n",
      "1343-1388\t2954-3001\t-\n",
      "3073-3115\t2956-3008\t1\n",
      "\n",
      " 264-307\t2996-3059\t11\n",
      " 758-989\t2993-3073\tB. Land\n",
      "2256-2425\t2989-3064\tidem\n",
      "\n",
      " 354-496\t2999-3068\tCeres\n",
      "1217-1283\t3005-3066\t78\n",
      "1429-1520\t2997-3077\t131\n",
      "1545-1608\t3022-3061\t-\n",
      "1692-1739\t3001-3064\t2\n",
      "3144-3432\t3034-3150\tWas get.\n",
      "\n",
      " 347-633\t3052-3127\tJans souci\n",
      " 765-1072\t3054-3134\tWagenaar\n",
      "1181-1270\t3061-3126\t213\n",
      "1353-1395\t3057-3143\t—\n",
      "1446-1512\t3071-3129\t43\n",
      "1549-1613\t3054-3134\t- -\n",
      "1992-2039\t3061-3127\t—\n",
      "2241-2418\t3055-3122\tAmst.\n",
      "3551-3642\t3035-3138\t7\n",
      "3808-4018\t3074-3167\tLuij\n",
      "4014-4058\t3089-3146\t„\n",
      "4056-4255\t3073-3158\tEen.\n",
      "\n",
      " 248-311\t3115-3167\t21\n",
      " 351-667\t3111-3187\tvreese Hoop\n",
      " 761-1049\t3115-3194\tSRieverts\n",
      "1191-1276\t3122-3188\t168\n",
      "1315-1383\t3136-3195\t--\n",
      "1432-1503\t3131-3189\t34\n",
      "1682-1771\t3123-3189\t44\n",
      "1847-2147\t3116-3187\t-- -\n",
      "2233-2413\t3118-3189\tmiddelo\n",
      "\n",
      "  62-176\t3144-3224\tIuny\n",
      "1052-1113\t3151-3242\t—\n",
      "1787-2190\t3144-3242\tGeen Ladin\n",
      "3587-3678\t3152-3275\tIn\n",
      "\n",
      " 257-323\t3164-3211\t28\n",
      " 355-671\t3164-3242\tde Uytvlugt\n",
      " 769-1057\t3166-3234\tJ. A. Ruge\n",
      "1184-1280\t3181-3242\t- - .\n",
      "1330-1397\t3182-3244\t-—\n",
      "2238-2416\t3163-3237\tAmst.\n",
      "\n",
      "  70-169\t3204-3288\tRui\n",
      " 271-316\t3211-3274\t15\n",
      " 349-694\t3210-3298\t’t zee compas\n",
      " 767-1094\t3214-3292\tW: G. de Boer\n",
      "1184-1247\t3223-3281\t—\n",
      "1307-1413\t3217-3284\t- - -\n",
      "1456-1500\t3221-3281\t12\n",
      "1542-1646\t3214-3278\t- -\n",
      "1717-1773\t3213-3274\t8\n",
      "1879-1994\t3232-3284\t- —\n",
      "2239-2384\t3219-3284\tiden\n",
      "3148-3527\t3191-3287\tsecret: ad\n",
      "3687-3935\t3198-3290\tberen\n",
      "\n",
      "2229-2439\t3250-3336\tmiddelb\n",
      "\n",
      " 264-328\t3272-3323\t28\n",
      " 343-578\t3268-3350\t.Mahle\n",
      " 770-1007\t3269-3344\tD. Factor\n",
      "1189-1280\t3267-3354\t365\n",
      "1325-1393\t3285-3343\t-„\n",
      "1423-1505\t3284-3345\t19\n",
      "1548-1620\t3281-3355\t-\n",
      "1613-1655\t3274-3326\t-\n",
      "1697-1760\t3270-3331\t54\n",
      "\n",
      " 262-318\t3318-3378\t30\n",
      " 355-700\t3319-3383\tde Nieuwe Hoor\n",
      " 759-1092\t3324-3397\tA. Helmers\n",
      "1695-1763\t3330-3383\t14\n",
      "2253-2413\t3314-3368\tAmst\n",
      "\n",
      "  68-168\t3333-3409\tsept\n",
      "1207-1255\t3347-3389\t-\n",
      "1419-1513\t3336-3405\t248\n",
      "2245-2438\t3350-3428\tRoerda\n",
      "\n",
      "1313-1376\t3352-3396\t- - -\n",
      "\n",
      " 349-729\t3363-3430\tPrins Willem\n",
      " 773-1083\t3371-3459\tM. Winter\n",
      "1867-1918\t3376-3424\t—\n",
      "\n",
      "1580-1624\t3382-3441\t8\n",
      "1699-1765\t3382-3431\t4\n",
      "\n",
      "1304-1388\t3384-3464\t- - -\n",
      "\n",
      " 433-637\t3410-3464\tFredrik\n",
      "2243-2459\t3403-3480\tAmsterdam\n",
      "\n",
      "1195-1275\t3416-3495\t7\n",
      "1692-1755\t3417-3478\t35\n",
      "\n",
      " 248-318\t3440-3496\t19\n",
      " 343-744\t3420-3519\tdevzouw gesini Elsaba\n",
      " 791-1151\t3430-3519\tG: Siemering\n",
      "1449-1503\t3438-3480\t„\n",
      "\n",
      "1316-1365\t3459-3480\t—\n",
      "1592-1636\t3441-3478\t—\n",
      "\n",
      " 768-1159\t3520-3610\tTransporteeren\n",
      "1166-1285\t3518-3610\t2294\n",
      "1423-1514\t3516-3586\t3030\n",
      "1569-1641\t3508-3594\t47\n",
      "1673-1760\t3508-3583\t463\n"
     ]
    }
   ],
   "source": [
    "prev_line = None\n",
    "for line in sort_lines_in_row_reading_order(table_scan):\n",
    "    if prev_line and prev_line.coords.left > line.coords.left:\n",
    "        print()\n",
    "    print(f'{line.coords.left: >4}-{line.coords.right}\\t{line.coords.top: >4}-{line.coords.bottom}\\t{line.text}')\n",
    "    prev_line = line"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###  Spliting documents by columns\n",
    "\n",
    "When there is a gap between adjacent lines and that gap is repeated for each row of lines, those gaps represent a gap between two columns. This can be used to identify columns of text lines."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "COLUMN RANGES: [{'start': 62, 'end': 2477}, {'start': 2481, 'end': 4869}]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[PageXMLColumn(\n",
       " \tid=NL-HaNA_1.05.06_114_0003.jpg-column-62-85-2415-3525, \n",
       " \ttype=['pagexml_doc', 'text_region', 'column', 'scan'], \n",
       " \tstats={\"lines\": 344, \"words\": 479, \"text_regions\": 0}\n",
       " ),\n",
       " PageXMLColumn(\n",
       " \tid=NL-HaNA_1.05.06_114_0003.jpg-column-2481-117-2388-3173, \n",
       " \ttype=['pagexml_doc', 'text_region', 'column', 'scan'], \n",
       " \tstats={\"lines\": 216, \"words\": 271, \"text_regions\": 0}\n",
       " )]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pagexml.column_parser import split_lines_on_column_gaps\n",
    "\n",
    "\n",
    "split_lines_on_column_gaps(table_scan, gap_threshold=2, debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "COLUMN RANGES: [{'start': 45, 'end': 3176}, {'start': 3192, 'end': 3386}, {'start': 3390, 'end': 3502}, {'start': 3556, 'end': 3880}, {'start': 3884, 'end': 4212}, {'start': 4239, 'end': 4741}, {'start': 4746, 'end': 4928}, {'start': 4942, 'end': 5422}, {'start': 5467, 'end': 6050}, {'start': 6053, 'end': 6381}, {'start': 6398, 'end': 7188}, {'start': 7281, 'end': 7638}, {'start': 7866, 'end': 8228}, {'start': 8270, 'end': 8531}]\n",
      "14\n",
      "COLUMN RANGES: [{'start': 43, 'end': 2447}, {'start': 2459, 'end': 4859}]\n",
      "2\n",
      "COLUMN RANGES: [{'start': 62, 'end': 2477}, {'start': 2481, 'end': 4869}]\n",
      "2\n"
     ]
    }
   ],
   "source": [
    "for scan in table_scans:\n",
    "    columns = split_lines_on_column_gaps(scan, gap_threshold=2, debug=True)\n",
    "    print(len(columns))"
   ]
  },
  {
   "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": []
  },
  {
   "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": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.9"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}