ExtractPDFTable_colab.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Oja4VzHmBiLJ"
      },
      "source": [
        "# Install requerements"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "LJqxmgENBeXp",
        "outputId": "4900cb19-e7f5-4167-a0d2-490c2a5ab14f"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Collecting tabula-py[jpype]\n",
            "  Downloading tabula_py-2.9.3-py3-none-any.whl.metadata (7.6 kB)\n",
            "Requirement already satisfied: pandas>=0.25.3 in /usr/local/lib/python3.10/dist-packages (from tabula-py[jpype]) (2.1.4)\n",
            "Requirement already satisfied: numpy in /usr/local/lib/python3.10/dist-packages (from tabula-py[jpype]) (1.26.4)\n",
            "Requirement already satisfied: distro in /usr/lib/python3/dist-packages (from tabula-py[jpype]) (1.7.0)\n",
            "Collecting jpype1 (from tabula-py[jpype])\n",
            "  Downloading JPype1-1.5.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.metadata (4.9 kB)\n",
            "Requirement already satisfied: python-dateutil>=2.8.2 in /usr/local/lib/python3.10/dist-packages (from pandas>=0.25.3->tabula-py[jpype]) (2.8.2)\n",
            "Requirement already satisfied: pytz>=2020.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=0.25.3->tabula-py[jpype]) (2024.1)\n",
            "Requirement already satisfied: tzdata>=2022.1 in /usr/local/lib/python3.10/dist-packages (from pandas>=0.25.3->tabula-py[jpype]) (2024.1)\n",
            "Requirement already satisfied: packaging in /usr/local/lib/python3.10/dist-packages (from jpype1->tabula-py[jpype]) (24.1)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.10/dist-packages (from python-dateutil>=2.8.2->pandas>=0.25.3->tabula-py[jpype]) (1.16.0)\n",
            "Downloading JPype1-1.5.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (488 kB)\n",
            "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m488.6/488.6 kB\u001b[0m \u001b[31m21.0 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hDownloading tabula_py-2.9.3-py3-none-any.whl (12.0 MB)\n",
            "\u001b[2K   \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m12.0/12.0 MB\u001b[0m \u001b[31m54.4 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25hInstalling collected packages: jpype1, tabula-py\n",
            "Successfully installed jpype1-1.5.0 tabula-py-2.9.3\n"
          ]
        }
      ],
      "source": [
        "pip install tabula-py[jpype]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "id": "duzQwEB1BrVZ"
      },
      "outputs": [],
      "source": [
        "import requests\n",
        "from tabula import read_pdf\n",
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "3WIbLQBgBvJc"
      },
      "source": [
        "# Download the PDF"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 85,
      "metadata": {
        "id": "oi0VC5FP5fiW"
      },
      "outputs": [],
      "source": [
        "pdf_path = \"pdf_file\""
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-8N6x5OxVgVK"
      },
      "source": [
        "view images"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 80,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tlllK41iVlTT",
        "outputId": "17e73334-8aae-4e6a-f918-ab724adc608c"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: pdf2image in /usr/local/lib/python3.10/dist-packages (1.17.0)\n",
            "\u001b[31mERROR: Could not find a version that satisfies the requirement poppler (from versions: none)\u001b[0m\u001b[31m\n",
            "\u001b[0m\u001b[31mERROR: No matching distribution found for poppler\u001b[0m\u001b[31m\n",
            "\u001b[0m"
          ]
        }
      ],
      "source": [
        "!pip install pdf2image\n",
        "!apt-get install poppler-utils"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 83,
      "metadata": {
        "id": "SGVChHqAVfzQ"
      },
      "outputs": [],
      "source": [
        "from pdf2image import convert_from_path\n",
        "\n",
        "pages = convert_from_path(pdf_path)\n",
        "for page in pages:\n",
        "    page.save(\"page_image.jpg\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 180,
      "metadata": {
        "id": "RgDabN0yWlj0"
      },
      "outputs": [],
      "source": [
        "from pdf2image import convert_from_path\n",
        "import numpy as np\n",
        "\n",
        "images_of_pdf = convert_from_path(pdf_path, dpi=200)  # Convert PDF to List of PIL Images\n",
        "for i,page in enumerate(pages):\n",
        "    page.save(\"page_image_\"+str(i)+\".jpg\")\n",
        "readable_images_of_pdf = []  # Create a list for thr for loop to put the images into\n",
        "for PIL_Image in images_of_pdf:\n",
        "    readable_images_of_pdf.append(np.array(PIL_Image))  # Add items to list"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 181,
      "metadata": {
        "id": "u_fpJoMaWp8z"
      },
      "outputs": [],
      "source": [
        "import cv2\n",
        "import numpy as np\n",
        "from pdf2image import convert_from_path\n",
        "\n",
        "image_of_pdf = np.concatenate(tuple(convert_from_path(pdf_path)), axis=0)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "let's load the images to have a preview of the modifications we will do for tabula"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 182,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iWoGBeakWwQc",
        "outputId": "334b8ffd-34f9-4a38-be9f-04c499de4dbc"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Width: 595, Height: 841, Channels: 3\n"
          ]
        }
      ],
      "source": [
        "from google.colab.patches import cv2_imshow\n",
        "import cv2\n",
        "\n",
        "#reload the img \n",
        "img = cv2.imread(\"/content/page_image_2.jpg\", cv2.IMREAD_UNCHANGED)\n",
        "\n",
        "#resize the img to the original values of the pdf. To get them open it with any pdf reader and get those info or look in the file properties. Values are in pts.\n",
        "img = cv2.resize(img, (int(595.28), int(841.88)), interpolation=cv2.INTER_LINEAR)\n",
        "\n",
        "#cv2_imshow(img)\n",
        "# Get the dimensions of the image\n",
        "height, width, channels = img.shape\n",
        "\n",
        "print(f\"Width: {width}, Height: {height}, Channels: {channels}\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 858
        },
        "id": "s28L_dl1ZSow",
        "outputId": "41635583-0a33-4395-b9ad-28b945df5be7"
      },
      "outputs": [],
      "source": [
        "# Define the x points for vertical lines\n",
        "x_points = [80, 150, 435, 475, 507, 555]  # Example x points\n",
        "\n",
        "# Define the area to color (top, left, bottom, right)\n",
        "area = [59.9,42.042,790.606,556.959]\n",
        "area_p1 = [262.295,42.042,789.118,552.494]\n",
        "\n",
        "area_preview = area #area_p1\n",
        "\n",
        "#reset the image every time\n",
        "img = cv2.imread(\"/content/page_image_0.jpg\", cv2.IMREAD_UNCHANGED)\n",
        "img = cv2.resize(img, (int(595.28), int(841.88)), interpolation=cv2.INTER_LINEAR)\n",
        "\n",
        "overlay = np.ones((img.shape[0], img.shape[1], 4), dtype='uint8')\n",
        "\n",
        "# Convert the original image to BGRA (with alpha channel)\n",
        "img_bgra = cv2.cvtColor(img, cv2.COLOR_BGR2BGRA)\n",
        "\n",
        "# Color the defined area\n",
        "cv2.rectangle(overlay, (int(area_preview[1]), int(area_preview[0])), (int(area_preview[3]), int(area_preview[2])), (255, 0, 0, 125), -1)  # Blue filled rectangle\n",
        "\n",
        "# Draw vertical lines\n",
        "for x in x_points:\n",
        "    cv2.line(overlay, (x, 0), (x, img.shape[0]), (0, 255, 0,255), 2)  # Green vertical lines\n",
        "\n",
        "# Blend the overlay with the original image\n",
        "combined = cv2.addWeighted(img_bgra, 0.9, overlay, 0.2, 0)\n",
        "\n",
        "# Display the image\n",
        "cv2_imshow(combined)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "O_yUm18CCRv1"
      },
      "source": [
        "# Extract tables"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 231,
      "metadata": {
        "id": "t7qmkwjlrYIw"
      },
      "outputs": [],
      "source": [
        "pandas_options = {\n",
        "    'header': None,\n",
        "    'columns' : [\"DATA\", \"TIPO\", \"DESCRIZIONE\", \"IN ENTRATA\",\"IN USCITA\", \"SALDO\"]\n",
        "}"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 265,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "frgh1ylTCWk-",
        "outputId": "3413f8b1-a8a8-4dd9-bc77-2d14ed0e1c17"
      },
      "outputs": [
        {
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "summary": "{\n  \"name\": \"#dfs_1[0]\",\n  \"rows\": 48,\n  \"fields\": [\n    {\n      \"column\": \"DATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 12,\n        \"samples\": [\n          \"08 giu\",\n          \"06 giu\",\n          \"26 mag\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"TIPO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"Transazione con\",\n          \"carta\",\n          \"Commercio\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"DESCRIZIONE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 17,\n        \"samples\": [\n          \"ASPIT DIREZ. USCITA -\",\n          \"IL PINZIMONIO\",\n          \"AUTOSILO SEMPIONE\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN ENTRATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 2,\n        \"samples\": [\n          \"15,00 \\u20ac\",\n          \"16,51 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN USCITA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 14,\n        \"samples\": [\n          \"116,00 \\u20ac\",\n          \"15,50 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SALDO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 16,\n        \"samples\": [\n          \"4.249,23 \\u20ac\",\n          \"4.239,65 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}",
              "type": "dataframe"
            },
            "text/html": [
              "\n",
              "  <div id=\"df-960ea5ef-cf56-4453-ac22-e530f952be91\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATA</th>\n",
              "      <th>TIPO</th>\n",
              "      <th>DESCRIZIONE</th>\n",
              "      <th>IN ENTRATA</th>\n",
              "      <th>IN USCITA</th>\n",
              "      <th>SALDO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ASPIT DIREZ. USCITA -</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1,80 €</td>\n",
              "      <td>4.249,23 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IL PINZIMONIO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9,58 €</td>\n",
              "      <td>4.239,65 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>28 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>AERLING 22IJ32 VANDON</td>\n",
              "      <td>NaN</td>\n",
              "      <td>421,87 €</td>\n",
              "      <td>3.817,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>30 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SUMUP *A&amp;A S.R.L.S</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30,00 €</td>\n",
              "      <td>3.787,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>30 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>QUERCIA GIOIELLI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>100,00 €</td>\n",
              "      <td>3.687,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>30 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>AUTOSILO SEMPIONE</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1,50 €</td>\n",
              "      <td>3.686,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>31 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SISTEMA CONGRESSI SRL</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300,00 €</td>\n",
              "      <td>3.386,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>01 giu</td>\n",
              "      <td>Pagamento degli</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>16,51 €</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.402,79 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>2024</td>\n",
              "      <td>interessi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>02 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>FARMACIA EUROPA S.R.L.</td>\n",
              "      <td>NaN</td>\n",
              "      <td>16,55 €</td>\n",
              "      <td>3.386,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>03 giu</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>NaN</td>\n",
              "      <td>Premio</td>\n",
              "      <td>Your Saveback payment</td>\n",
              "      <td>15,00 €</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3.401,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2024</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>04 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ESSO ISELLA RUSSO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>20,00 €</td>\n",
              "      <td>3.381,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>04 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TRENORD SRL</td>\n",
              "      <td>NaN</td>\n",
              "      <td>116,00 €</td>\n",
              "      <td>3.265,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>04 giu</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Esecuzione Trade Acquisto diretto Acquisto IE0...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>NaN</td>\n",
              "      <td>Commercio</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15,00 €</td>\n",
              "      <td>3.250,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>2024</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2598471420240604 KW</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>06 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>AU VIEUX STRASBOURG</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15,50 €</td>\n",
              "      <td>3.234,74 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>08 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>SUSHI HIRO SAS DI XIANG</td>\n",
              "      <td>NaN</td>\n",
              "      <td>63,80 €</td>\n",
              "      <td>3.170,94 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>10 giu</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TIGROS 2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>86,56 €</td>\n",
              "      <td>3.084,38 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-960ea5ef-cf56-4453-ac22-e530f952be91')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-960ea5ef-cf56-4453-ac22-e530f952be91 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-960ea5ef-cf56-4453-ac22-e530f952be91');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-b8930aea-ad3a-4f49-b970-2ad65876f34a\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b8930aea-ad3a-4f49-b970-2ad65876f34a')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-b8930aea-ad3a-4f49-b970-2ad65876f34a button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "text/plain": [
              "      DATA             TIPO  \\\n",
              "0   26 mag  Transazione con   \n",
              "1      NaN              NaN   \n",
              "2     2024            carta   \n",
              "3   26 mag  Transazione con   \n",
              "4      NaN              NaN   \n",
              "5     2024            carta   \n",
              "6   28 mag  Transazione con   \n",
              "7      NaN              NaN   \n",
              "8     2024            carta   \n",
              "9   30 mag  Transazione con   \n",
              "10     NaN              NaN   \n",
              "11    2024            carta   \n",
              "12  30 mag  Transazione con   \n",
              "13     NaN              NaN   \n",
              "14    2024            carta   \n",
              "15  30 mag  Transazione con   \n",
              "16     NaN              NaN   \n",
              "17    2024            carta   \n",
              "18  31 mag  Transazione con   \n",
              "19     NaN              NaN   \n",
              "20    2024            carta   \n",
              "21  01 giu  Pagamento degli   \n",
              "22     NaN              NaN   \n",
              "23    2024        interessi   \n",
              "24  02 giu  Transazione con   \n",
              "25     NaN              NaN   \n",
              "26    2024            carta   \n",
              "27  03 giu              NaN   \n",
              "28     NaN           Premio   \n",
              "29    2024              NaN   \n",
              "30  04 giu  Transazione con   \n",
              "31     NaN              NaN   \n",
              "32    2024            carta   \n",
              "33  04 giu  Transazione con   \n",
              "34     NaN              NaN   \n",
              "35    2024            carta   \n",
              "36  04 giu              NaN   \n",
              "37     NaN        Commercio   \n",
              "38    2024              NaN   \n",
              "39  06 giu  Transazione con   \n",
              "40     NaN              NaN   \n",
              "41    2024            carta   \n",
              "42  08 giu  Transazione con   \n",
              "43     NaN              NaN   \n",
              "44    2024            carta   \n",
              "45  10 giu  Transazione con   \n",
              "46     NaN              NaN   \n",
              "47    2024            carta   \n",
              "\n",
              "                                          DESCRIZIONE IN ENTRATA IN USCITA  \\\n",
              "0                                                 NaN        NaN       NaN   \n",
              "1                               ASPIT DIREZ. USCITA -        NaN    1,80 €   \n",
              "2                                                 NaN        NaN       NaN   \n",
              "3                                                 NaN        NaN       NaN   \n",
              "4                                       IL PINZIMONIO        NaN    9,58 €   \n",
              "5                                                 NaN        NaN       NaN   \n",
              "6                                                 NaN        NaN       NaN   \n",
              "7                               AERLING 22IJ32 VANDON        NaN  421,87 €   \n",
              "8                                                 NaN        NaN       NaN   \n",
              "9                                                 NaN        NaN       NaN   \n",
              "10                                 SUMUP *A&A S.R.L.S        NaN   30,00 €   \n",
              "11                                                NaN        NaN       NaN   \n",
              "12                                                NaN        NaN       NaN   \n",
              "13                                   QUERCIA GIOIELLI        NaN  100,00 €   \n",
              "14                                                NaN        NaN       NaN   \n",
              "15                                                NaN        NaN       NaN   \n",
              "16                                  AUTOSILO SEMPIONE        NaN    1,50 €   \n",
              "17                                                NaN        NaN       NaN   \n",
              "18                                                NaN        NaN       NaN   \n",
              "19                              SISTEMA CONGRESSI SRL        NaN  300,00 €   \n",
              "20                                                NaN        NaN       NaN   \n",
              "21                                                NaN        NaN       NaN   \n",
              "22                              Your interest payment    16,51 €       NaN   \n",
              "23                                                NaN        NaN       NaN   \n",
              "24                                                NaN        NaN       NaN   \n",
              "25                             FARMACIA EUROPA S.R.L.        NaN   16,55 €   \n",
              "26                                                NaN        NaN       NaN   \n",
              "27                                                NaN        NaN       NaN   \n",
              "28                              Your Saveback payment    15,00 €       NaN   \n",
              "29                                                NaN        NaN       NaN   \n",
              "30                                                NaN        NaN       NaN   \n",
              "31                                  ESSO ISELLA RUSSO        NaN   20,00 €   \n",
              "32                                                NaN        NaN       NaN   \n",
              "33                                                NaN        NaN       NaN   \n",
              "34                                        TRENORD SRL        NaN  116,00 €   \n",
              "35                                                NaN        NaN       NaN   \n",
              "36  Esecuzione Trade Acquisto diretto Acquisto IE0...        NaN       NaN   \n",
              "37                                                NaN        NaN   15,00 €   \n",
              "38                                2598471420240604 KW        NaN       NaN   \n",
              "39                                                NaN        NaN       NaN   \n",
              "40                                AU VIEUX STRASBOURG        NaN   15,50 €   \n",
              "41                                                NaN        NaN       NaN   \n",
              "42                                                NaN        NaN       NaN   \n",
              "43                            SUSHI HIRO SAS DI XIANG        NaN   63,80 €   \n",
              "44                                                NaN        NaN       NaN   \n",
              "45                                                NaN        NaN       NaN   \n",
              "46                                           TIGROS 2        NaN   86,56 €   \n",
              "47                                                NaN        NaN       NaN   \n",
              "\n",
              "         SALDO  \n",
              "0          NaN  \n",
              "1   4.249,23 €  \n",
              "2          NaN  \n",
              "3          NaN  \n",
              "4   4.239,65 €  \n",
              "5          NaN  \n",
              "6          NaN  \n",
              "7   3.817,78 €  \n",
              "8          NaN  \n",
              "9          NaN  \n",
              "10  3.787,78 €  \n",
              "11         NaN  \n",
              "12         NaN  \n",
              "13  3.687,78 €  \n",
              "14         NaN  \n",
              "15         NaN  \n",
              "16  3.686,28 €  \n",
              "17         NaN  \n",
              "18         NaN  \n",
              "19  3.386,28 €  \n",
              "20         NaN  \n",
              "21         NaN  \n",
              "22  3.402,79 €  \n",
              "23         NaN  \n",
              "24         NaN  \n",
              "25  3.386,24 €  \n",
              "26         NaN  \n",
              "27         NaN  \n",
              "28  3.401,24 €  \n",
              "29         NaN  \n",
              "30         NaN  \n",
              "31  3.381,24 €  \n",
              "32         NaN  \n",
              "33         NaN  \n",
              "34  3.265,24 €  \n",
              "35         NaN  \n",
              "36         NaN  \n",
              "37  3.250,24 €  \n",
              "38         NaN  \n",
              "39         NaN  \n",
              "40  3.234,74 €  \n",
              "41         NaN  \n",
              "42         NaN  \n",
              "43  3.170,94 €  \n",
              "44         NaN  \n",
              "45         NaN  \n",
              "46  3.084,38 €  \n",
              "47         NaN  "
            ]
          },
          "execution_count": 265,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "with open(pdf_path, 'rb') as file:\n",
        "        # extract table from pages\n",
        "        dfs = read_pdf(\n",
        "            file,\n",
        "            pages=\"2-5\", # pages to extract table from\n",
        "            area=area,\n",
        "            columns=x_points,\n",
        "            #lattice=True,\n",
        "            pandas_options=pandas_options,\n",
        "            stream=True,\n",
        "        )\n",
        "\n",
        "        # extract table in page 4\n",
        "        dfs_1 = read_pdf(\n",
        "              file,\n",
        "              pages=1,\n",
        "              area=area_p1,\n",
        "              columns=x_points,\n",
        "              pandas_options=pandas_options,\n",
        "              stream = True,\n",
        "        )\n",
        "\n",
        "dfs[0]\n",
        "#dfs_1[0]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 266,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 622
        },
        "id": "P8NrZDyyt96W",
        "outputId": "a6f3a113-7bc2-4f0e-8689-54ae1a532909"
      },
      "outputs": [
        {
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 172,\n  \"fields\": [\n    {\n      \"column\": \"DATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 38,\n        \"samples\": [\n          \"20 mag\",\n          \"24 mag\",\n          \"31 mag\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"TIPO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"Trasferimento\",\n          \"carta\",\n          \"Commercio\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"DESCRIZIONE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 52,\n        \"samples\": [\n          \"AUTOST TRAFORO FREJUS/TRA\",\n          \"Deposito accettato: IT89Q0302501601TB8880222826 a DE55502109007012708062\",\n          \"PAOLO & VALE S.R.L.S.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN ENTRATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"17,45 \\u20ac\",\n          \"15,00 \\u20ac\",\n          \"5.000,00 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN USCITA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 46,\n        \"samples\": [\n          \"59,01 \\u20ac\",\n          \"38,00 \\u20ac\",\n          \"1,20 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SALDO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 58,\n        \"samples\": [\n          \"4.249,23 \\u20ac\",\n          \"3.686,28 \\u20ac\",\n          \"2.066,01 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}",
              "type": "dataframe",
              "variable_name": "data"
            },
            "text/html": [
              "\n",
              "  <div id=\"df-4e0f932d-4827-4dca-a209-8a6774b95485\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATA</th>\n",
              "      <th>TIPO</th>\n",
              "      <th>DESCRIZIONE</th>\n",
              "      <th>IN ENTRATA</th>\n",
              "      <th>IN USCITA</th>\n",
              "      <th>SALDO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ASPIT DIREZ. USCITA -</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1,80 €</td>\n",
              "      <td>4.249,23 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IL PINZIMONIO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9,58 €</td>\n",
              "      <td>4.239,65 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>167</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TIGROS 17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5,31 €</td>\n",
              "      <td>4.810,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>25 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>170</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>KEYNOTE CONFERENCE SER</td>\n",
              "      <td>NaN</td>\n",
              "      <td>485,00 €</td>\n",
              "      <td>4.325,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>171</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>172 rows × 6 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4e0f932d-4827-4dca-a209-8a6774b95485')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-4e0f932d-4827-4dca-a209-8a6774b95485 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-4e0f932d-4827-4dca-a209-8a6774b95485');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-93890608-e08d-428f-8a4b-f3af375ee12b\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-93890608-e08d-428f-8a4b-f3af375ee12b')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-93890608-e08d-428f-8a4b-f3af375ee12b button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_43a988fe-5417-4c59-9fe2-4ae53696f690\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_43a988fe-5417-4c59-9fe2-4ae53696f690 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "text/plain": [
              "       DATA             TIPO             DESCRIZIONE IN ENTRATA IN USCITA  \\\n",
              "0    26 mag  Transazione con                     NaN        NaN       NaN   \n",
              "1       NaN              NaN   ASPIT DIREZ. USCITA -        NaN    1,80 €   \n",
              "2      2024            carta                     NaN        NaN       NaN   \n",
              "3    26 mag  Transazione con                     NaN        NaN       NaN   \n",
              "4       NaN              NaN           IL PINZIMONIO        NaN    9,58 €   \n",
              "..      ...              ...                     ...        ...       ...   \n",
              "167     NaN              NaN               TIGROS 17        NaN    5,31 €   \n",
              "168    2024            carta                     NaN        NaN       NaN   \n",
              "169  25 mag  Transazione con                     NaN        NaN       NaN   \n",
              "170     NaN              NaN  KEYNOTE CONFERENCE SER        NaN  485,00 €   \n",
              "171    2024            carta                     NaN        NaN       NaN   \n",
              "\n",
              "          SALDO  \n",
              "0           NaN  \n",
              "1    4.249,23 €  \n",
              "2           NaN  \n",
              "3           NaN  \n",
              "4    4.239,65 €  \n",
              "..          ...  \n",
              "167  4.810,01 €  \n",
              "168         NaN  \n",
              "169         NaN  \n",
              "170  4.325,01 €  \n",
              "171         NaN  \n",
              "\n",
              "[172 rows x 6 columns]"
            ]
          },
          "execution_count": 266,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "dfs.extend(dfs_1)\n",
        "\n",
        "# concat all dfs to get one table\n",
        "data = pd.concat(\n",
        "    dfs,\n",
        "    axis=0,\n",
        "    ignore_index=True\n",
        ")\n",
        "data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 267,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 601
        },
        "id": "MLqIxi9PvSEh",
        "outputId": "a6e1115a-be33-4a5f-f14f-80fa4a95bbbf"
      },
      "outputs": [
        {
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 171,\n  \"fields\": [\n    {\n      \"column\": \"DATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 37,\n        \"samples\": [\n          \"17 giu\",\n          \"13 giu\",\n          \"31 mag\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"TIPO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 8,\n        \"samples\": [\n          \"carta\",\n          \"Commercio\",\n          \"Transazione con\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"DESCRIZIONE\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 51,\n        \"samples\": [\n          \"LA CAVEJA\",\n          \"Deposito accettato: IT89Q0302501601TB8880222826 a DE55502109007012708062\",\n          \"PAOLO & VALE S.R.L.S.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN ENTRATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 8,\n        \"samples\": [\n          \"15,00 \\u20ac\",\n          \"15,72 \\u20ac\",\n          \"16,51 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN USCITA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 45,\n        \"samples\": [\n          \"20,50 \\u20ac\",\n          \"38,00 \\u20ac\",\n          \"1,20 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SALDO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 57,\n        \"samples\": [\n          \"4.249,23 \\u20ac\",\n          \"3.686,28 \\u20ac\",\n          \"2.491,73 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}",
              "type": "dataframe",
              "variable_name": "data"
            },
            "text/html": [
              "\n",
              "  <div id=\"df-3acad224-29fc-4853-8604-227104407121\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATA</th>\n",
              "      <th>TIPO</th>\n",
              "      <th>DESCRIZIONE</th>\n",
              "      <th>IN ENTRATA</th>\n",
              "      <th>IN USCITA</th>\n",
              "      <th>SALDO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>ASPIT DIREZ. USCITA -</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1,80 €</td>\n",
              "      <td>4.249,23 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>26 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>IL PINZIMONIO</td>\n",
              "      <td>NaN</td>\n",
              "      <td>9,58 €</td>\n",
              "      <td>4.239,65 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>166</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>TIGROS 17</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5,31 €</td>\n",
              "      <td>4.810,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>167</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>168</th>\n",
              "      <td>25 mag</td>\n",
              "      <td>Transazione con</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>169</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>KEYNOTE CONFERENCE SER</td>\n",
              "      <td>NaN</td>\n",
              "      <td>485,00 €</td>\n",
              "      <td>4.325,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>170</th>\n",
              "      <td>2024</td>\n",
              "      <td>carta</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>171 rows × 6 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3acad224-29fc-4853-8604-227104407121')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-3acad224-29fc-4853-8604-227104407121 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-3acad224-29fc-4853-8604-227104407121');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-9e80fe38-7c93-4d5b-8f72-207afc675199\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9e80fe38-7c93-4d5b-8f72-207afc675199')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-9e80fe38-7c93-4d5b-8f72-207afc675199 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_41e58b89-6de7-4a71-bb56-1540810619d9\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('data')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_41e58b89-6de7-4a71-bb56-1540810619d9 button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('data');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "text/plain": [
              "       DATA             TIPO             DESCRIZIONE IN ENTRATA IN USCITA  \\\n",
              "0    26 mag  Transazione con                     NaN        NaN       NaN   \n",
              "1       NaN              NaN   ASPIT DIREZ. USCITA -        NaN    1,80 €   \n",
              "2      2024            carta                     NaN        NaN       NaN   \n",
              "3    26 mag  Transazione con                     NaN        NaN       NaN   \n",
              "4       NaN              NaN           IL PINZIMONIO        NaN    9,58 €   \n",
              "..      ...              ...                     ...        ...       ...   \n",
              "166     NaN              NaN               TIGROS 17        NaN    5,31 €   \n",
              "167    2024            carta                     NaN        NaN       NaN   \n",
              "168  25 mag  Transazione con                     NaN        NaN       NaN   \n",
              "169     NaN              NaN  KEYNOTE CONFERENCE SER        NaN  485,00 €   \n",
              "170    2024            carta                     NaN        NaN       NaN   \n",
              "\n",
              "          SALDO  \n",
              "0           NaN  \n",
              "1    4.249,23 €  \n",
              "2           NaN  \n",
              "3           NaN  \n",
              "4    4.239,65 €  \n",
              "..          ...  \n",
              "166  4.810,01 €  \n",
              "167         NaN  \n",
              "168         NaN  \n",
              "169  4.325,01 €  \n",
              "170         NaN  \n",
              "\n",
              "[171 rows x 6 columns]"
            ]
          },
          "execution_count": 267,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Drop rows if they contain all column names\n",
        "try:\n",
        "  data = data.drop(data[data.apply(lambda row: all(item in row.values for item in pandas_options['columns']), axis=1)].index)\n",
        "  # Reset the index\n",
        "  data = data.reset_index(drop=True)\n",
        "except KeyError:\n",
        "  print(\"everything ok\")\n",
        "data\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 268,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 299
        },
        "id": "F-xA7FPbsA_L",
        "outputId": "73dbc502-b358-490d-885d-8c8e369fa79a"
      },
      "outputs": [
        {
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "summary": "{\n  \"name\": \"result\",\n  \"rows\": 57,\n  \"fields\": [\n    {\n      \"column\": \"DATA\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 36,\n        \"samples\": [\n          \"25 mag2024\",\n          \"14 giu2024\",\n          \"01 mar2024\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"TIPO\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"Transazione concarta\",\n          \"Pagamento degliinteressi\",\n          \"Commissione\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"DESCRIZIONE\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 49,\n        \"samples\": [\n          \"AU VIEUX STRASBOURG\",\n          \"AUTOGRILL 0736\",\n          \"TIGROS 17\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN ENTRATA\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 9,\n        \"samples\": [\n          \"17,45 \\u20ac\",\n          \"16,51 \\u20ac\",\n          \"5.000,00 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"IN USCITA\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 46,\n        \"samples\": [\n          \"59,01 \\u20ac\",\n          \"4,91 \\u20ac\",\n          \"38,00 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"SALDO\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 57,\n        \"samples\": [\n          \"4.249,23 \\u20ac\",\n          \"3.686,28 \\u20ac\",\n          \"2.491,73 \\u20ac\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}",
              "type": "dataframe",
              "variable_name": "result"
            },
            "text/html": [
              "\n",
              "  <div id=\"df-c56430ed-c1db-4cac-9aad-25f0c0843324\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>DATA</th>\n",
              "      <th>TIPO</th>\n",
              "      <th>DESCRIZIONE</th>\n",
              "      <th>IN ENTRATA</th>\n",
              "      <th>IN USCITA</th>\n",
              "      <th>SALDO</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ASPIT DIREZ. USCITA -</td>\n",
              "      <td></td>\n",
              "      <td>1,80 €</td>\n",
              "      <td>4.249,23 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>26 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>IL PINZIMONIO</td>\n",
              "      <td></td>\n",
              "      <td>9,58 €</td>\n",
              "      <td>4.239,65 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>28 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AERLING 22IJ32 VANDON</td>\n",
              "      <td></td>\n",
              "      <td>421,87 €</td>\n",
              "      <td>3.817,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>30 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SUMUP *A&amp;A S.R.L.S</td>\n",
              "      <td></td>\n",
              "      <td>30,00 €</td>\n",
              "      <td>3.787,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>30 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>QUERCIA GIOIELLI</td>\n",
              "      <td></td>\n",
              "      <td>100,00 €</td>\n",
              "      <td>3.687,78 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>30 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AUTOSILO SEMPIONE</td>\n",
              "      <td></td>\n",
              "      <td>1,50 €</td>\n",
              "      <td>3.686,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>31 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SISTEMA CONGRESSI SRL</td>\n",
              "      <td></td>\n",
              "      <td>300,00 €</td>\n",
              "      <td>3.386,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>01 giu2024</td>\n",
              "      <td>Pagamento degliinteressi</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>16,51 €</td>\n",
              "      <td></td>\n",
              "      <td>3.402,79 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>02 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>FARMACIA EUROPA S.R.L.</td>\n",
              "      <td></td>\n",
              "      <td>16,55 €</td>\n",
              "      <td>3.386,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>03 giu2024</td>\n",
              "      <td>Premio</td>\n",
              "      <td>Your Saveback payment</td>\n",
              "      <td>15,00 €</td>\n",
              "      <td></td>\n",
              "      <td>3.401,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>04 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ESSO ISELLA RUSSO</td>\n",
              "      <td></td>\n",
              "      <td>20,00 €</td>\n",
              "      <td>3.381,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>04 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>TRENORD SRL</td>\n",
              "      <td></td>\n",
              "      <td>116,00 €</td>\n",
              "      <td>3.265,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>04 giu2024</td>\n",
              "      <td>Commercio</td>\n",
              "      <td>Esecuzione Trade Acquisto diretto Acquisto IE0...</td>\n",
              "      <td></td>\n",
              "      <td>15,00 €</td>\n",
              "      <td>3.250,24 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>06 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AU VIEUX STRASBOURG</td>\n",
              "      <td></td>\n",
              "      <td>15,50 €</td>\n",
              "      <td>3.234,74 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>08 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SUSHI HIRO SAS DI XIANG</td>\n",
              "      <td></td>\n",
              "      <td>63,80 €</td>\n",
              "      <td>3.170,94 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>10 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>TIGROS 2</td>\n",
              "      <td></td>\n",
              "      <td>86,56 €</td>\n",
              "      <td>3.084,38 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>12 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>PRAMAGRILL</td>\n",
              "      <td></td>\n",
              "      <td>11,90 €</td>\n",
              "      <td>2.916,75 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>13 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>DALLMAYR DIST</td>\n",
              "      <td></td>\n",
              "      <td>0,50 €</td>\n",
              "      <td>2.916,25 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>14 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AUTOST TRAFORO FREJUS/TRA</td>\n",
              "      <td></td>\n",
              "      <td>68,60 €</td>\n",
              "      <td>2.847,65 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>14 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>BRASSERIENEPTUNE</td>\n",
              "      <td></td>\n",
              "      <td>11,10 €</td>\n",
              "      <td>2.836,55 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>15 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>DELIVEROO</td>\n",
              "      <td></td>\n",
              "      <td>34,98 €</td>\n",
              "      <td>2.801,57 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>15 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>DELIVEROO</td>\n",
              "      <td></td>\n",
              "      <td>17,49 €</td>\n",
              "      <td>2.784,08 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>15 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SEMITAG</td>\n",
              "      <td></td>\n",
              "      <td>2,00 €</td>\n",
              "      <td>2.782,08 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>16 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>Taxis on Booking</td>\n",
              "      <td></td>\n",
              "      <td>29,06 €</td>\n",
              "      <td>2.753,02 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>17 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AUTOGRILL 0683</td>\n",
              "      <td></td>\n",
              "      <td>13,00 €</td>\n",
              "      <td>2.740,02 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>17 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ENI11427</td>\n",
              "      <td></td>\n",
              "      <td>66,18 €</td>\n",
              "      <td>2.673,84 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>17 giu2024</td>\n",
              "      <td>Commercio</td>\n",
              "      <td>Savings plan execution IE00B6R52259 iShares V ...</td>\n",
              "      <td></td>\n",
              "      <td>100,00 €</td>\n",
              "      <td>2.573,84 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>19 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>TIGROS 6</td>\n",
              "      <td></td>\n",
              "      <td>4,91 €</td>\n",
              "      <td>2.568,93 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>20 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>Trainline SAS</td>\n",
              "      <td></td>\n",
              "      <td>38,00 €</td>\n",
              "      <td>2.530,93 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>20 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>Trainline SAS</td>\n",
              "      <td></td>\n",
              "      <td>38,00 €</td>\n",
              "      <td>2.492,93 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>20 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>GRUPPO NEGOZI SRL</td>\n",
              "      <td></td>\n",
              "      <td>1,20 €</td>\n",
              "      <td>2.491,73 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>21 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>GTT</td>\n",
              "      <td></td>\n",
              "      <td>2,00 €</td>\n",
              "      <td>2.489,73 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>28 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>WWW.IKEA.COM</td>\n",
              "      <td></td>\n",
              "      <td>330,90 €</td>\n",
              "      <td>2.071,91 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>MOLINO DORINO PARK</td>\n",
              "      <td></td>\n",
              "      <td>2,50 €</td>\n",
              "      <td>2.069,41 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>MISER DIREZ. USCITA -</td>\n",
              "      <td></td>\n",
              "      <td>3,40 €</td>\n",
              "      <td>2.066,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>GAVIO - SATAP A4</td>\n",
              "      <td></td>\n",
              "      <td>8,20 €</td>\n",
              "      <td>2.057,81 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ASPIT DIREZ.ENTRATA -</td>\n",
              "      <td></td>\n",
              "      <td>1,60 €</td>\n",
              "      <td>2.056,21 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ASPIT DIREZ. USCITA -</td>\n",
              "      <td></td>\n",
              "      <td>1,60 €</td>\n",
              "      <td>2.054,61 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>29 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AU VIEUX STRASBOURG</td>\n",
              "      <td></td>\n",
              "      <td>18,50 €</td>\n",
              "      <td>2.036,11 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>30 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>ALIEXPRESS.COM</td>\n",
              "      <td></td>\n",
              "      <td>45,16 €</td>\n",
              "      <td>1.990,95 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>30 giu2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SUMUP *DAVERIO</td>\n",
              "      <td></td>\n",
              "      <td>37,00 €</td>\n",
              "      <td>1.953,95 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>11 gen2024</td>\n",
              "      <td>Trasferimento</td>\n",
              "      <td>Customer 566b8754-c566-4896-b90c-dff84451358f ...</td>\n",
              "      <td>50,00 €</td>\n",
              "      <td></td>\n",
              "      <td>50,00 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>01 feb2024</td>\n",
              "      <td>Pagamento degliinteressi</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>0,11 €</td>\n",
              "      <td></td>\n",
              "      <td>50,11 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>02 feb2024</td>\n",
              "      <td>Trasferimento</td>\n",
              "      <td>Deposito accettato: IT89Q0302501601TB888022282...</td>\n",
              "      <td>5.000,00 €</td>\n",
              "      <td></td>\n",
              "      <td>5.050,11 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>01 mar2024</td>\n",
              "      <td>Pagamento degliinteressi</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>15,72 €</td>\n",
              "      <td></td>\n",
              "      <td>5.065,83 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>01 apr2024</td>\n",
              "      <td>Pagamento degliinteressi</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>17,45 €</td>\n",
              "      <td></td>\n",
              "      <td>5.083,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>22 apr2024</td>\n",
              "      <td>Commissione</td>\n",
              "      <td>Trade Republic Card</td>\n",
              "      <td></td>\n",
              "      <td>5,00 €</td>\n",
              "      <td>5.078,28 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>01 mag2024</td>\n",
              "      <td>Pagamento degliinteressi</td>\n",
              "      <td>Your interest payment</td>\n",
              "      <td>16,94 €</td>\n",
              "      <td></td>\n",
              "      <td>5.095,22 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>10 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>CIACCARO</td>\n",
              "      <td></td>\n",
              "      <td>7,90 €</td>\n",
              "      <td>5.087,32 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>20 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>LA CAVEJA</td>\n",
              "      <td></td>\n",
              "      <td>12,00 €</td>\n",
              "      <td>5.075,32 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>20 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>NUOVA SIDAP SRL 9157 M</td>\n",
              "      <td></td>\n",
              "      <td>59,01 €</td>\n",
              "      <td>5.016,31 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>21 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>SOCRATE CAFE</td>\n",
              "      <td></td>\n",
              "      <td>20,50 €</td>\n",
              "      <td>4.995,81 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>21 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>PAOLO &amp; VALE S.R.L.S.</td>\n",
              "      <td></td>\n",
              "      <td>104,80 €</td>\n",
              "      <td>4.891,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>21 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>AUTOGRILL 0736</td>\n",
              "      <td></td>\n",
              "      <td>9,40 €</td>\n",
              "      <td>4.881,61 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>22 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>PV ENI - 03970</td>\n",
              "      <td></td>\n",
              "      <td>66,29 €</td>\n",
              "      <td>4.815,32 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>24 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>TIGROS 17</td>\n",
              "      <td></td>\n",
              "      <td>5,31 €</td>\n",
              "      <td>4.810,01 €</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>25 mag2024</td>\n",
              "      <td>Transazione concarta</td>\n",
              "      <td>KEYNOTE CONFERENCE SER</td>\n",
              "      <td></td>\n",
              "      <td>485,00 €</td>\n",
              "      <td>4.325,01 €</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c56430ed-c1db-4cac-9aad-25f0c0843324')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-c56430ed-c1db-4cac-9aad-25f0c0843324 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-c56430ed-c1db-4cac-9aad-25f0c0843324');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-fb59581f-e172-4f93-b026-721499186d1f\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fb59581f-e172-4f93-b026-721499186d1f')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-fb59581f-e172-4f93-b026-721499186d1f button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "  <div id=\"id_dabc329e-59b9-4c48-9b02-68171dfbe8ea\">\n",
              "    <style>\n",
              "      .colab-df-generate {\n",
              "        background-color: #E8F0FE;\n",
              "        border: none;\n",
              "        border-radius: 50%;\n",
              "        cursor: pointer;\n",
              "        display: none;\n",
              "        fill: #1967D2;\n",
              "        height: 32px;\n",
              "        padding: 0 0 0 0;\n",
              "        width: 32px;\n",
              "      }\n",
              "\n",
              "      .colab-df-generate:hover {\n",
              "        background-color: #E2EBFA;\n",
              "        box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "        fill: #174EA6;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate {\n",
              "        background-color: #3B4455;\n",
              "        fill: #D2E3FC;\n",
              "      }\n",
              "\n",
              "      [theme=dark] .colab-df-generate:hover {\n",
              "        background-color: #434B5C;\n",
              "        box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "        filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "        fill: #FFFFFF;\n",
              "      }\n",
              "    </style>\n",
              "    <button class=\"colab-df-generate\" onclick=\"generateWithVariable('result')\"\n",
              "            title=\"Generate code using this dataframe.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M7,19H8.4L18.45,9,17,7.55,7,17.6ZM5,21V16.75L18.45,3.32a2,2,0,0,1,2.83,0l1.4,1.43a1.91,1.91,0,0,1,.58,1.4,1.91,1.91,0,0,1-.58,1.4L9.25,21ZM18.45,9,17,7.55Zm-12,3A5.31,5.31,0,0,0,4.9,8.1,5.31,5.31,0,0,0,1,6.5,5.31,5.31,0,0,0,4.9,4.9,5.31,5.31,0,0,0,6.5,1,5.31,5.31,0,0,0,8.1,4.9,5.31,5.31,0,0,0,12,6.5,5.46,5.46,0,0,0,6.5,12Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "    <script>\n",
              "      (() => {\n",
              "      const buttonEl =\n",
              "        document.querySelector('#id_dabc329e-59b9-4c48-9b02-68171dfbe8ea button.colab-df-generate');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      buttonEl.onclick = () => {\n",
              "        google.colab.notebook.generateWithVariable('result');\n",
              "      }\n",
              "      })();\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "text/plain": [
              "          DATA                      TIPO  \\\n",
              "0   26 mag2024      Transazione concarta   \n",
              "1   26 mag2024      Transazione concarta   \n",
              "2   28 mag2024      Transazione concarta   \n",
              "3   30 mag2024      Transazione concarta   \n",
              "4   30 mag2024      Transazione concarta   \n",
              "5   30 mag2024      Transazione concarta   \n",
              "6   31 mag2024      Transazione concarta   \n",
              "7   01 giu2024  Pagamento degliinteressi   \n",
              "8   02 giu2024      Transazione concarta   \n",
              "9   03 giu2024                    Premio   \n",
              "10  04 giu2024      Transazione concarta   \n",
              "11  04 giu2024      Transazione concarta   \n",
              "12  04 giu2024                 Commercio   \n",
              "13  06 giu2024      Transazione concarta   \n",
              "14  08 giu2024      Transazione concarta   \n",
              "15  10 giu2024      Transazione concarta   \n",
              "16  12 giu2024      Transazione concarta   \n",
              "17  13 giu2024      Transazione concarta   \n",
              "18  14 giu2024      Transazione concarta   \n",
              "19  14 giu2024      Transazione concarta   \n",
              "20  15 giu2024      Transazione concarta   \n",
              "21  15 giu2024      Transazione concarta   \n",
              "22  15 giu2024      Transazione concarta   \n",
              "23  16 giu2024      Transazione concarta   \n",
              "24  17 giu2024      Transazione concarta   \n",
              "25  17 giu2024      Transazione concarta   \n",
              "26  17 giu2024                 Commercio   \n",
              "27  19 giu2024      Transazione concarta   \n",
              "28  20 giu2024      Transazione concarta   \n",
              "29  20 giu2024      Transazione concarta   \n",
              "30  20 giu2024      Transazione concarta   \n",
              "31  21 giu2024      Transazione concarta   \n",
              "32  28 giu2024      Transazione concarta   \n",
              "33  29 giu2024      Transazione concarta   \n",
              "34  29 giu2024      Transazione concarta   \n",
              "35  29 giu2024      Transazione concarta   \n",
              "36  29 giu2024      Transazione concarta   \n",
              "37  29 giu2024      Transazione concarta   \n",
              "38  29 giu2024      Transazione concarta   \n",
              "39  30 giu2024      Transazione concarta   \n",
              "40  30 giu2024      Transazione concarta   \n",
              "41  11 gen2024             Trasferimento   \n",
              "42  01 feb2024  Pagamento degliinteressi   \n",
              "43  02 feb2024             Trasferimento   \n",
              "44  01 mar2024  Pagamento degliinteressi   \n",
              "45  01 apr2024  Pagamento degliinteressi   \n",
              "46  22 apr2024               Commissione   \n",
              "47  01 mag2024  Pagamento degliinteressi   \n",
              "48  10 mag2024      Transazione concarta   \n",
              "49  20 mag2024      Transazione concarta   \n",
              "50  20 mag2024      Transazione concarta   \n",
              "51  21 mag2024      Transazione concarta   \n",
              "52  21 mag2024      Transazione concarta   \n",
              "53  21 mag2024      Transazione concarta   \n",
              "54  22 mag2024      Transazione concarta   \n",
              "55  24 mag2024      Transazione concarta   \n",
              "56  25 mag2024      Transazione concarta   \n",
              "\n",
              "                                          DESCRIZIONE  IN ENTRATA IN USCITA  \\\n",
              "0                               ASPIT DIREZ. USCITA -                1,80 €   \n",
              "1                                       IL PINZIMONIO                9,58 €   \n",
              "2                               AERLING 22IJ32 VANDON              421,87 €   \n",
              "3                                  SUMUP *A&A S.R.L.S               30,00 €   \n",
              "4                                    QUERCIA GIOIELLI              100,00 €   \n",
              "5                                   AUTOSILO SEMPIONE                1,50 €   \n",
              "6                               SISTEMA CONGRESSI SRL              300,00 €   \n",
              "7                               Your interest payment     16,51 €             \n",
              "8                              FARMACIA EUROPA S.R.L.               16,55 €   \n",
              "9                               Your Saveback payment     15,00 €             \n",
              "10                                  ESSO ISELLA RUSSO               20,00 €   \n",
              "11                                        TRENORD SRL              116,00 €   \n",
              "12  Esecuzione Trade Acquisto diretto Acquisto IE0...               15,00 €   \n",
              "13                                AU VIEUX STRASBOURG               15,50 €   \n",
              "14                            SUSHI HIRO SAS DI XIANG               63,80 €   \n",
              "15                                           TIGROS 2               86,56 €   \n",
              "16                                         PRAMAGRILL               11,90 €   \n",
              "17                                      DALLMAYR DIST                0,50 €   \n",
              "18                          AUTOST TRAFORO FREJUS/TRA               68,60 €   \n",
              "19                                   BRASSERIENEPTUNE               11,10 €   \n",
              "20                                          DELIVEROO               34,98 €   \n",
              "21                                          DELIVEROO               17,49 €   \n",
              "22                                            SEMITAG                2,00 €   \n",
              "23                                   Taxis on Booking               29,06 €   \n",
              "24                                     AUTOGRILL 0683               13,00 €   \n",
              "25                                           ENI11427               66,18 €   \n",
              "26  Savings plan execution IE00B6R52259 iShares V ...              100,00 €   \n",
              "27                                           TIGROS 6                4,91 €   \n",
              "28                                      Trainline SAS               38,00 €   \n",
              "29                                      Trainline SAS               38,00 €   \n",
              "30                                  GRUPPO NEGOZI SRL                1,20 €   \n",
              "31                                                GTT                2,00 €   \n",
              "32                                       WWW.IKEA.COM              330,90 €   \n",
              "33                                 MOLINO DORINO PARK                2,50 €   \n",
              "34                              MISER DIREZ. USCITA -                3,40 €   \n",
              "35                                   GAVIO - SATAP A4                8,20 €   \n",
              "36                              ASPIT DIREZ.ENTRATA -                1,60 €   \n",
              "37                              ASPIT DIREZ. USCITA -                1,60 €   \n",
              "38                                AU VIEUX STRASBOURG               18,50 €   \n",
              "39                                     ALIEXPRESS.COM               45,16 €   \n",
              "40                                     SUMUP *DAVERIO               37,00 €   \n",
              "41  Customer 566b8754-c566-4896-b90c-dff84451358f ...     50,00 €             \n",
              "42                              Your interest payment      0,11 €             \n",
              "43  Deposito accettato: IT89Q0302501601TB888022282...  5.000,00 €             \n",
              "44                              Your interest payment     15,72 €             \n",
              "45                              Your interest payment     17,45 €             \n",
              "46                                Trade Republic Card                5,00 €   \n",
              "47                              Your interest payment     16,94 €             \n",
              "48                                           CIACCARO                7,90 €   \n",
              "49                                          LA CAVEJA               12,00 €   \n",
              "50                             NUOVA SIDAP SRL 9157 M               59,01 €   \n",
              "51                                       SOCRATE CAFE               20,50 €   \n",
              "52                              PAOLO & VALE S.R.L.S.              104,80 €   \n",
              "53                                     AUTOGRILL 0736                9,40 €   \n",
              "54                                     PV ENI - 03970               66,29 €   \n",
              "55                                          TIGROS 17                5,31 €   \n",
              "56                             KEYNOTE CONFERENCE SER              485,00 €   \n",
              "\n",
              "         SALDO  \n",
              "0   4.249,23 €  \n",
              "1   4.239,65 €  \n",
              "2   3.817,78 €  \n",
              "3   3.787,78 €  \n",
              "4   3.687,78 €  \n",
              "5   3.686,28 €  \n",
              "6   3.386,28 €  \n",
              "7   3.402,79 €  \n",
              "8   3.386,24 €  \n",
              "9   3.401,24 €  \n",
              "10  3.381,24 €  \n",
              "11  3.265,24 €  \n",
              "12  3.250,24 €  \n",
              "13  3.234,74 €  \n",
              "14  3.170,94 €  \n",
              "15  3.084,38 €  \n",
              "16  2.916,75 €  \n",
              "17  2.916,25 €  \n",
              "18  2.847,65 €  \n",
              "19  2.836,55 €  \n",
              "20  2.801,57 €  \n",
              "21  2.784,08 €  \n",
              "22  2.782,08 €  \n",
              "23  2.753,02 €  \n",
              "24  2.740,02 €  \n",
              "25  2.673,84 €  \n",
              "26  2.573,84 €  \n",
              "27  2.568,93 €  \n",
              "28  2.530,93 €  \n",
              "29  2.492,93 €  \n",
              "30  2.491,73 €  \n",
              "31  2.489,73 €  \n",
              "32  2.071,91 €  \n",
              "33  2.069,41 €  \n",
              "34  2.066,01 €  \n",
              "35  2.057,81 €  \n",
              "36  2.056,21 €  \n",
              "37  2.054,61 €  \n",
              "38  2.036,11 €  \n",
              "39  1.990,95 €  \n",
              "40  1.953,95 €  \n",
              "41     50,00 €  \n",
              "42     50,11 €  \n",
              "43  5.050,11 €  \n",
              "44  5.065,83 €  \n",
              "45  5.083,28 €  \n",
              "46  5.078,28 €  \n",
              "47  5.095,22 €  \n",
              "48  5.087,32 €  \n",
              "49  5.075,32 €  \n",
              "50  5.016,31 €  \n",
              "51  4.995,81 €  \n",
              "52  4.891,01 €  \n",
              "53  4.881,61 €  \n",
              "54  4.815,32 €  \n",
              "55  4.810,01 €  \n",
              "56  4.325,01 €  "
            ]
          },
          "execution_count": 268,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Group the DataFrame by every 3 rows as tabula didn't recognize multiline text in the cells. U should inspect this by urself\n",
        "grouped = data.groupby(data.index // 3)\n",
        "\n",
        "# Aggregate the text within each group\n",
        "result = grouped.agg(lambda x: ''.join(x.fillna('')))\n",
        "\n",
        "# Reset the index\n",
        "result = result.reset_index(drop=True)\n",
        "\n",
        "result\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "s8Qvm-eRC9g4"
      },
      "source": [
        "# Export data to CSV"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 269,
      "metadata": {
        "id": "fiyY17wIyhCk"
      },
      "outputs": [],
      "source": [
        "result.to_csv(\"output.csv\", index=False)"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "collapsed_sections": [
        "Oja4VzHmBiLJ"
      ],
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}