Raketa_PROD_v5_0.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/loktissimo/Raketa/blob/main/Raketa_PROD_v5_0.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "cellView": "form",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 69
        },
        "id": "4TSzHIhoqQzD",
        "outputId": "babc1a1d-a4f0-4bae-f1b5-e9c868aeeb10"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "⏳ Получено 1268 записей Ракеты с 01 Oct 2024"
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\n",
            "✔️ Готово. Клиент - Woerwag\n"
          ]
        }
      ],
      "source": [
        "# @title Заполни дату\n",
        "# @markdown Дата начала выписки\n",
        "\n",
        "from datetime import datetime, timezone\n",
        "import IPython\n",
        "import requests\n",
        "\n",
        "DATEFROM = '2024-10-01'  #@param {type: \"date\"}\n",
        "CLIENT = 'Woerwag' #@param [\"Petrovax\", \"Woerwag\"]\n",
        "\n",
        "def string_to_isotime(date_string):\n",
        "    datetime_object = datetime.fromisoformat(date_string)\n",
        "    return datetime_object.strftime(\"%Y-%m-%dT%H:%M:%S.000Z\")\n",
        "\n",
        "def string_to_humanreadable(date_string):\n",
        "    datetime_object = datetime.fromisoformat(date_string)\n",
        "    return datetime_object.strftime(\"%d %h %Y\")\n",
        "\n",
        "DATE_FROM = string_to_isotime(DATEFROM)\n",
        "DATE_NOW = datetime.now().strftime(\"%Y-%m-%dT%H:%M:%S.000Z\")\n",
        "DATE_FILE = datetime.now().strftime(\"%H:%M-%d.%m.%Y\")\n",
        "DATE_FROM_HUMAN = string_to_humanreadable(DATEFROM)\n",
        "# print(f\"{DATE_FROM = }\\n{DATE_NOW = }\\n{DATE_FILE = }\\n{DATE_FROM_HUMAN}\")\n",
        "\n",
        "\n",
        "\n",
        "''' GLOBAL Variables '''\n",
        "token = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'\n",
        "headers = {'Authorization': f'Bearer {token}', 'accept': 'application/json'}\n",
        "\n",
        "\n",
        "\n",
        "def get_json(headers):\n",
        "    '''\n",
        "    Сбор данных из ракеты по 100 \"строк\" за проход\n",
        "    '''\n",
        "\n",
        "    date_from = DATE_FROM\n",
        "\n",
        "    ''' Отображение числа записей '''\n",
        "    rocket_item_counter = 0\n",
        "    print_rocket_counter = display(IPython.display.Pretty(f'⏳ Получено {rocket_item_counter} записей Ракеты с {DATE_FROM_HUMAN}'), display_id=True)\n",
        "\n",
        "\n",
        "    services_endpoint = 'https://agency.raketa.travel/v2/services?fromLastUpdate=' + date_from\n",
        "    json_data_services = requests.get(services_endpoint, headers=headers).json()\n",
        "    json_last_date = json_data_services[len(json_data_services)-1]['lastUpdate']\n",
        "\n",
        "\n",
        "    while json_last_date[:10] != DATE_NOW[:10]:\n",
        "        date_from = string_to_isotime(json_last_date)\n",
        "        url = \"https://agency.raketa.travel/v2/services?fromLastUpdate=\" + date_from\n",
        "        new_request = requests.get(url, headers=headers).json()\n",
        "\n",
        "        if not new_request: break\n",
        "\n",
        "        rocket_item_counter += len(new_request)\n",
        "        print_rocket_counter.update(IPython.display.Pretty(f'⏳ Получено {rocket_item_counter} записей Ракеты с {DATE_FROM_HUMAN}'))\n",
        "\n",
        "        # print(f'LastUpdate field: {json_data_services[len(json_data_services)-1][\"lastUpdate\"]}')\n",
        "        # print(f'{date_from = }')\n",
        "        # print(f'{new_request = }')\n",
        "\n",
        "        json_data_services.extend(new_request)\n",
        "        json_last_date = new_request[len(new_request)-1]['lastUpdate']\n",
        "\n",
        "    return json_data_services\n",
        "\n",
        "\n",
        "''' Запрос по API массива данных из Ракеты '''\n",
        "json_data_services = get_json(headers)\n",
        "\n",
        "\n",
        "print(f\"\\n✔️ Готово. Клиент - {CLIENT}\")\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "cellView": "form",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 107
        },
        "id": "tLwPCsAR3Nn2",
        "outputId": "d3d66d42-eb46-4a9d-f34b-b8131ef1984f"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-e7129c29-7d0c-49c0-bc34-2c46abb4ae31\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-e7129c29-7d0c-49c0-bc34-2c46abb4ae31\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script>// Copyright 2017 Google LLC\n",
              "//\n",
              "// Licensed under the Apache License, Version 2.0 (the \"License\");\n",
              "// you may not use this file except in compliance with the License.\n",
              "// You may obtain a copy of the License at\n",
              "//\n",
              "//      http://www.apache.org/licenses/LICENSE-2.0\n",
              "//\n",
              "// Unless required by applicable law or agreed to in writing, software\n",
              "// distributed under the License is distributed on an \"AS IS\" BASIS,\n",
              "// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n",
              "// See the License for the specific language governing permissions and\n",
              "// limitations under the License.\n",
              "\n",
              "/**\n",
              " * @fileoverview Helpers for google.colab Python module.\n",
              " */\n",
              "(function(scope) {\n",
              "function span(text, styleAttributes = {}) {\n",
              "  const element = document.createElement('span');\n",
              "  element.textContent = text;\n",
              "  for (const key of Object.keys(styleAttributes)) {\n",
              "    element.style[key] = styleAttributes[key];\n",
              "  }\n",
              "  return element;\n",
              "}\n",
              "\n",
              "// Max number of bytes which will be uploaded at a time.\n",
              "const MAX_PAYLOAD_SIZE = 100 * 1024;\n",
              "\n",
              "function _uploadFiles(inputId, outputId) {\n",
              "  const steps = uploadFilesStep(inputId, outputId);\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  // Cache steps on the outputElement to make it available for the next call\n",
              "  // to uploadFilesContinue from Python.\n",
              "  outputElement.steps = steps;\n",
              "\n",
              "  return _uploadFilesContinue(outputId);\n",
              "}\n",
              "\n",
              "// This is roughly an async generator (not supported in the browser yet),\n",
              "// where there are multiple asynchronous steps and the Python side is going\n",
              "// to poll for completion of each step.\n",
              "// This uses a Promise to block the python side on completion of each step,\n",
              "// then passes the result of the previous step as the input to the next step.\n",
              "function _uploadFilesContinue(outputId) {\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  const steps = outputElement.steps;\n",
              "\n",
              "  const next = steps.next(outputElement.lastPromiseValue);\n",
              "  return Promise.resolve(next.value.promise).then((value) => {\n",
              "    // Cache the last promise value to make it available to the next\n",
              "    // step of the generator.\n",
              "    outputElement.lastPromiseValue = value;\n",
              "    return next.value.response;\n",
              "  });\n",
              "}\n",
              "\n",
              "/**\n",
              " * Generator function which is called between each async step of the upload\n",
              " * process.\n",
              " * @param {string} inputId Element ID of the input file picker element.\n",
              " * @param {string} outputId Element ID of the output display.\n",
              " * @return {!Iterable<!Object>} Iterable of next steps.\n",
              " */\n",
              "function* uploadFilesStep(inputId, outputId) {\n",
              "  const inputElement = document.getElementById(inputId);\n",
              "  inputElement.disabled = false;\n",
              "\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  outputElement.innerHTML = '';\n",
              "\n",
              "  const pickedPromise = new Promise((resolve) => {\n",
              "    inputElement.addEventListener('change', (e) => {\n",
              "      resolve(e.target.files);\n",
              "    });\n",
              "  });\n",
              "\n",
              "  const cancel = document.createElement('button');\n",
              "  inputElement.parentElement.appendChild(cancel);\n",
              "  cancel.textContent = 'Cancel upload';\n",
              "  const cancelPromise = new Promise((resolve) => {\n",
              "    cancel.onclick = () => {\n",
              "      resolve(null);\n",
              "    };\n",
              "  });\n",
              "\n",
              "  // Wait for the user to pick the files.\n",
              "  const files = yield {\n",
              "    promise: Promise.race([pickedPromise, cancelPromise]),\n",
              "    response: {\n",
              "      action: 'starting',\n",
              "    }\n",
              "  };\n",
              "\n",
              "  cancel.remove();\n",
              "\n",
              "  // Disable the input element since further picks are not allowed.\n",
              "  inputElement.disabled = true;\n",
              "\n",
              "  if (!files) {\n",
              "    return {\n",
              "      response: {\n",
              "        action: 'complete',\n",
              "      }\n",
              "    };\n",
              "  }\n",
              "\n",
              "  for (const file of files) {\n",
              "    const li = document.createElement('li');\n",
              "    li.append(span(file.name, {fontWeight: 'bold'}));\n",
              "    li.append(span(\n",
              "        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n",
              "        `last modified: ${\n",
              "            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n",
              "                                    'n/a'} - `));\n",
              "    const percent = span('0% done');\n",
              "    li.appendChild(percent);\n",
              "\n",
              "    outputElement.appendChild(li);\n",
              "\n",
              "    const fileDataPromise = new Promise((resolve) => {\n",
              "      const reader = new FileReader();\n",
              "      reader.onload = (e) => {\n",
              "        resolve(e.target.result);\n",
              "      };\n",
              "      reader.readAsArrayBuffer(file);\n",
              "    });\n",
              "    // Wait for the data to be ready.\n",
              "    let fileData = yield {\n",
              "      promise: fileDataPromise,\n",
              "      response: {\n",
              "        action: 'continue',\n",
              "      }\n",
              "    };\n",
              "\n",
              "    // Use a chunked sending to avoid message size limits. See b/62115660.\n",
              "    let position = 0;\n",
              "    do {\n",
              "      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n",
              "      const chunk = new Uint8Array(fileData, position, length);\n",
              "      position += length;\n",
              "\n",
              "      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n",
              "      yield {\n",
              "        response: {\n",
              "          action: 'append',\n",
              "          file: file.name,\n",
              "          data: base64,\n",
              "        },\n",
              "      };\n",
              "\n",
              "      let percentDone = fileData.byteLength === 0 ?\n",
              "          100 :\n",
              "          Math.round((position / fileData.byteLength) * 100);\n",
              "      percent.textContent = `${percentDone}% done`;\n",
              "\n",
              "    } while (position < fileData.byteLength);\n",
              "  }\n",
              "\n",
              "  // All done.\n",
              "  yield {\n",
              "    response: {\n",
              "      action: 'complete',\n",
              "    }\n",
              "  };\n",
              "}\n",
              "\n",
              "scope.google = scope.google || {};\n",
              "scope.google.colab = scope.google.colab || {};\n",
              "scope.google.colab._files = {\n",
              "  _uploadFiles,\n",
              "  _uploadFilesContinue,\n",
              "};\n",
              "})(self);\n",
              "</script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving Верваг НДС в таксах_01-15.11.2024_доп.xlsx to Верваг НДС в таксах_01-15.11.2024_доп.xlsx\n",
            "\n",
            "✔️ Готово. Файл - Верваг НДС в таксах_01-15.11.2024_доп.xlsx\n"
          ]
        }
      ],
      "source": [
        "#  @title Загрузи .xlsx файл\n",
        "\n",
        "import pandas as pd\n",
        "import io\n",
        "\n",
        "from google.colab import files\n",
        "uploaded = files.upload()\n",
        "\n",
        "filename = list(uploaded.keys())\n",
        "\n",
        "# df = pd.read_excel(io.BytesIO(uploaded[filename[0]]), header=[1])\n",
        "\n",
        "# Проверяем файл, что он подходит для работы далее\n",
        "# headers = ['Имя позиции в счете',\n",
        "#         'Путешественник',\n",
        "#         'Расчетный код перевозчика',\n",
        "#         '№ продукта',\n",
        "#         'Дата выписки',\n",
        "#         'Табельный номер',\n",
        "#         'ЦФО',\n",
        "#         'код ЦФО',\n",
        "#         'Дата начала оказания услуги',\n",
        "#         'Дата окончания оказания услуги',\n",
        "#         'Грейд',\n",
        "#         'Город прибытия',\n",
        "#         'Тип продукта',\n",
        "#         'Сумма такс',\n",
        "#         'Сумма НДС в счете',\n",
        "#         'Ставка НДС в счете',\n",
        "#         'Сумма счета',\n",
        "#         'ИНН поставщика',\n",
        "#         'Клиент (полное название)',\n",
        "#         'Статус продукта',\n",
        "#         '№ заказа',\n",
        "#         'Наименование ИНН поставщика',\n",
        "#         'Комментарии',\n",
        "#         '№ реализации',\n",
        "#         'Тариф',\n",
        "#         'Выписывающий агент']\n",
        "\n",
        "# if list(df.columns) != headers:\n",
        "#     print(\"\\n\\n😔 Неверный исходный файл! Загрузи другой.\")\n",
        "\n",
        "\n",
        "print(f\"\\n✔️ Готово. Файл - {filename[0]}\")\n"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "0gtmZANLXHIm"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "cellView": "form",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 208,
          "referenced_widgets": [
            "91271cb506e948e1b70b83d0da9b5afa",
            "d80768cc1c794b8c970eb0829dca5ffb",
            "a188521522274df697ac8b684a468e93"
          ]
        },
        "id": "lhn2a4HtrzCX",
        "outputId": "fef56716-6067-4239-f27e-476254aa4cd5"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Анализируем файл: Верваг НДС в таксах_01-15.11.2024_доп.xlsx\n",
            "\n"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "IntProgress(value=0, max=6)"
            ],
            "application/vnd.jupyter.widget-view+json": {
              "version_major": 2,
              "version_minor": 0,
              "model_id": "91271cb506e948e1b70b83d0da9b5afa"
            }
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-10-ac9b2cab89fe>:182: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  ticket_number = validate_ticket(row[2], row[3], row[12])\n",
            "<ipython-input-10-ac9b2cab89fe>:182: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  ticket_number = validate_ticket(row[2], row[3], row[12])\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\n",
            "✔️ Готово\n"
          ]
        }
      ],
      "source": [
        "# @title Запускай анализ файла\n",
        "\n",
        "import requests\n",
        "import pandas as pd\n",
        "import re\n",
        "import io\n",
        "from time import sleep\n",
        "from ipywidgets import IntProgress\n",
        "from IPython.display import display\n",
        "# import IPython\n",
        "# from tables import file\n",
        "\n",
        "\n",
        "def ticket_to_str(code):\n",
        "    '''\n",
        "    Получение номеров из pandas в виде str\n",
        "    '''\n",
        "    try:\n",
        "        return str(int(code))    #str(int) потому что pandas может поменять тип на float.\n",
        "        # return str(code)\n",
        "    except:\n",
        "        print(f'⚠️ С номером билета / кодом АК ({code}) проблема. Передай разработчикам!')\n",
        "        return None\n",
        "\n",
        "\n",
        "def validate_ticket(code_ak, ticket_number, service_type):\n",
        "    '''\n",
        "    Получение номера билета на основании типа услуги\n",
        "    '''\n",
        "    if service_type == \"Железнодорожные билеты\" or service_type == \"Гостиницы\" or service_type == \"Транспортные услуги\":\n",
        "        return ticket_to_str(ticket_number)\n",
        "    elif service_type == \"Авиабилеты\":\n",
        "        return \"\".join( (ticket_to_str(code_ak), ticket_to_str(ticket_number)) )\n",
        "    else:\n",
        "        return None\n",
        "\n",
        "\n",
        "def find_order_clientid(ticket_number, json):\n",
        "    '''\n",
        "    Get order id, client id by ticket number\n",
        "    '''\n",
        "    result = [None, None]\n",
        "\n",
        "    for element in json:\n",
        "        if element['type'] == 'avia' \\\n",
        "            and element['avia']['tickets'] \\\n",
        "            and element['avia']['tickets'][0]['number'] == ticket_number:\n",
        "            result = [element['orderId'], element['avia']['tickets'][0].get('passengerId')]\n",
        "            return result\n",
        "\n",
        "        elif element['type'] == 'rail' \\\n",
        "            and element['rail']['forward'][0]['tickets'] \\\n",
        "            and element['rail']['forward'][0]['tickets'][0]['number'] == ticket_number:\n",
        "            result = [element['orderId'], element['rail']['forward'][0]['tickets'][0].get('passengerId')]\n",
        "            return result\n",
        "\n",
        "        elif element['type'] == 'hotel' \\\n",
        "            and element['hotel']['bookingReference'] \\\n",
        "            and element['hotel']['bookingReference'] == ticket_number:\n",
        "            result = [element['orderId'], element['travellers'][0]]\n",
        "            return result\n",
        "\n",
        "        elif element['type'] == 'transfer' \\\n",
        "            and element['transfer']['bookingReference'] \\\n",
        "            and element['transfer']['bookingReference'] == ticket_number:\n",
        "                result = [element['orderId'], element['travellers'][0]]\n",
        "                return result\n",
        "\n",
        "        elif element['type'] == 'misc' and element['files']:    # Поиск имён файлов для offline-билетов\n",
        "            filenames_list = [item.get('fileName') for item in element['files']]\n",
        "            filenames_strings = [s for s in filenames_list if ticket_number in s]\n",
        "            if filenames_strings:\n",
        "                result = [element.get('orderId'), element.get('customer')]\n",
        "                return result\n",
        "\n",
        "    print(f\"⚠️ Информация о билете ({ticket_number}) не найдена\")\n",
        "    return result\n",
        "\n",
        "\n",
        "def find_tabnum_cfo_code_fio(client_id, headers):\n",
        "    '''\n",
        "    Найти ЦФО, Код ЦФО, табельный номер + ФИО\n",
        "    '''\n",
        "    client_id = str(client_id)\n",
        "    profiles_endpoint = f'https://agency.raketa.travel/v2/profiles/{client_id}'\n",
        "\n",
        "    json_data_profiles = requests.get(profiles_endpoint, headers=headers).json()\n",
        "\n",
        "    fio = \" \".join([json_data_profiles['lastName'], json_data_profiles['firstName'], json_data_profiles['middleName']])\n",
        "\n",
        "    if json_data_profiles.get('extrafields'):\n",
        "        return [json_data_profiles['code'], json_data_profiles['costCenter'], json_data_profiles['extrafields'][0]['value'], fio]\n",
        "    else:\n",
        "        return [json_data_profiles['code'], json_data_profiles['costCenter'], None, fio]\n",
        "\n",
        "\n",
        "def find_brand(order_id, headers):\n",
        "    '''\n",
        "    Поиска Бренда\n",
        "    '''\n",
        "    brand_endpoint = f'https://agency.raketa.travel/v2/orders/{order_id}'\n",
        "    json_data_brand = requests.get(brand_endpoint, headers=headers).json()\n",
        "\n",
        "    if json_data_brand.get('extrafields'):\n",
        "        ''' С номером элеманта массива [1] могут быть *фокусы* '''\n",
        "        return str(json_data_brand['extrafields'][1]['label'])\n",
        "\n",
        "\n",
        "def find_businesstrip(order_id, client, headers):\n",
        "    '''\n",
        "    Поиск Цель командировки\n",
        "    '''\n",
        "    if client != 'Woerwag':\n",
        "        businesstrip_endpoint = f'https://agency.raketa.travel/v2/orders/{order_id}/businessTrip'\n",
        "        json_data_businesstrip = requests.get(businesstrip_endpoint, headers=headers).json()\n",
        "        if json_data_businesstrip.get('purpose'):\n",
        "            return str(json_data_businesstrip['purpose'])\n",
        "        else:\n",
        "            print(f'{order_id = }') #debug\n",
        "            return None\n",
        "\n",
        "    elif client == 'Woerwag':\n",
        "        brand_endpoint = f'https://agency.raketa.travel/v2/orders/{order_id}'\n",
        "        json_data_brand = requests.get(brand_endpoint, headers=headers).json()\n",
        "\n",
        "        if json_data_brand.get('extrafields'):\n",
        "            return str(json_data_brand['extrafields'][2]['label'])\n",
        "        else:\n",
        "            print(f'{order_id = }') #debug\n",
        "            return None\n",
        "\n",
        "\n",
        "\n",
        "def collect_data_and_generate_df(**kwargs):\n",
        "    '''\n",
        "    Собираем данные и формуруем нормализованный DataFrame\n",
        "    '''\n",
        "    # filename = list(uploaded.keys())      #  !!!!!!!!!!!!!!! удалить, если всё работает.\n",
        "    print(f'Анализируем файл: {filename[0]}\\n')\n",
        "\n",
        "    ''' Загружаем данные из .xls в Pandas DataFrame '''\n",
        "    df = pd.read_excel(io.BytesIO(uploaded[filename[0]]), header=[1])\n",
        "\n",
        "    ''' Статусбар по красоте '''\n",
        "    bar_max_count = len(df.index) - 2\n",
        "    bar = IntProgress(min=0, max=bar_max_count) # instantiate the bar\n",
        "    display(bar) # display the bar\n",
        "\n",
        "\n",
        "    ''' Добавляем в DataFrame все необходимые колонки в конец таблицы\n",
        "        Мы приняли подход, когда мы сначала заполняем исходную таблицу всеми полями,\n",
        "        а затем из нее вырезаем нужную клиентскую форму '''\n",
        "    df['№ п/п'] = \"\"\n",
        "    df['Номер заказа в СОБ'] = \"\"\n",
        "    df['№ акта'] = \"\"\n",
        "    df['дата акта'] = \"\"\n",
        "    df['Цель командировки'] = \"\"\n",
        "    df['номер строки билета'] = \"\"\n",
        "    df['Бренд'] = \"\"\n",
        "    df['Номер билета к обмену'] = \"\"\n",
        "    df['Номер клиента'] = \"\"\n",
        "    df['Стоимость услуги без НДС'] = \"\"\n",
        "    df['Номер СЧФ'] = \"\"\n",
        "    df['Номенклатура'] = \"\"\n",
        "    # df['Содержание'] = \"\"     # Удаляем ?\n",
        "    df['NON/ded'] = \"\"\n",
        "    df['Tax code'] = \"\"\n",
        "    #print(df.columns)\n",
        "    #print(df.head())\n",
        "\n",
        "\n",
        "    ''' Проход по строкам файла .xls '''\n",
        "    for index, row in df.iterrows():\n",
        "\n",
        "        ''' Статусбар по красоте '''\n",
        "        bar.value = index   # signal to increment the progress bar\n",
        "\n",
        "        # print(f'{row.iloc[2] = } {type(row.iloc[2]) = } \\n'\n",
        "        #     f'{row.iloc[3] = } {type(row.iloc[3]) = } \\n'\n",
        "        #     f'{row.iloc[12] = } {type(row.iloc[12]) = }')\n",
        "\n",
        "        ticket_number = validate_ticket(row[2], row[3], row[12])\n",
        "        # ticket_number = validate_ticket(row.iloc[2], row.iloc[3], row.iloc[12]) # ПРОВЕРИТЬ В СЛЕДУЮЩЕМ СПРИНТЕ\n",
        "        if ticket_number:\n",
        "            order_id, client_id = find_order_clientid(ticket_number, json_data_services)\n",
        "            if order_id and client_id:\n",
        "                tabnum, cfo, cfo_code, fio = find_tabnum_cfo_code_fio(client_id, headers)\n",
        "                businesstrip = find_businesstrip(order_id, CLIENT, headers)\n",
        "                brand = find_brand(order_id, headers)\n",
        "\n",
        "                '''  _debug_ - проверочная информация по найденным данным '''\n",
        "                if kwargs.get('_debug_', False):\n",
        "                    print(f\"{'№ билета' : <17} {ticket_number}\\n\"   # не добавляем в DataFrame\n",
        "                            f\"{'№ СОБ (order_id)' : <17} {order_id}\\n\"\n",
        "                            f\"{'№ Клиента (client_id)' : <17} {client_id}\\n\"\n",
        "                            f\"{'ФИО' : <17} {fio}\\n\"\n",
        "                            f\"{'Цель ком.' : <17} {businesstrip}\\n\"\n",
        "                            f\"{'Бренд' : <17} {brand}\\n\"\n",
        "                            f\"{'Таб.номер' : <17} {tabnum}\\n\"\n",
        "                            f\"{'ЦФО' : <17} {cfo}\\n\"\n",
        "                            f\"{'Код ЦФО' : <17} {cfo_code}\\n\")\n",
        "\n",
        "\n",
        "                ''' Add collected data to DataFrame '''\n",
        "                # df.at[index, 'Номер билета'] = ticket_number  # оставляем существующий из исходного файла\n",
        "                df.at[index, 'Номер заказа в СОБ'] = order_id\n",
        "                df.at[index, 'Путешественник'] = fio\n",
        "                df.at[index, 'Номер клиента'] = client_id\n",
        "                df.at[index, 'Цель командировки'] = businesstrip\n",
        "                df.at[index, 'Бренд'] = brand\n",
        "                df.at[index, 'Табельный номер'] = tabnum\n",
        "                df.at[index, 'ЦФО'] = cfo\n",
        "                df.at[index, 'код ЦФО'] = cfo_code\n",
        "\n",
        "    print(f\"\\n✔️ Готово\")\n",
        "    return df\n",
        "\n",
        "\n",
        "''' Записываем DataFrame в переменную '''\n",
        "df_normalized = collect_data_and_generate_df(_debug_ = False)\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "cellView": "form",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "74--lNgG2nfZ",
        "outputId": "90bd9081-dfd8-4dd1-b1eb-9f94cd457342"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "⌛ Запускаем форматирование Woerwag\n",
            "\n",
            "✔️ Файл Woerwag_report_10:37-02.12.2024.xlsx записан\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "<ipython-input-11-2402d479ef17>:176: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if str(row[13]) == 'Авиабилеты':\n",
            "<ipython-input-11-2402d479ef17>:177: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if row[2].startswith('Сервисный сбор'):\n",
            "<ipython-input-11-2402d479ef17>:179: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[2].startswith('Такса ZZ'):\n",
            "<ipython-input-11-2402d479ef17>:181: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[2].startswith('Таксы без НДС'):\n",
            "<ipython-input-11-2402d479ef17>:183: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[2].startswith('Таксы и сборы НДС0'):\n",
            "<ipython-input-11-2402d479ef17>:185: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[2].startswith('Таксы и сборы НДС10'):\n",
            "<ipython-input-11-2402d479ef17>:190: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if str(row[13]) == 'Гостиницы':\n",
            "<ipython-input-11-2402d479ef17>:193: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if str(row[13]) == 'Железнодорожные билеты':\n",
            "<ipython-input-11-2402d479ef17>:203: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if str(row[13]) == 'Железнодорожные билеты':\n",
            "<ipython-input-11-2402d479ef17>:205: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif str(row[13]) == 'Авиабилеты':\n",
            "<ipython-input-11-2402d479ef17>:212: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  if row[1].startswith('ЖД билет'):\n",
            "<ipython-input-11-2402d479ef17>:214: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[1].startswith('Сервисный сбор ИМ'):\n",
            "<ipython-input-11-2402d479ef17>:216: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`\n",
            "  elif row[1].startswith('Сервисный сбор'):\n"
          ]
        }
      ],
      "source": [
        "# @title Нажимай для формирования итогового файла\n",
        "\n",
        "result_filename = f\"{CLIENT}_report_{DATE_FILE}.xlsx\"\n",
        "\n",
        "petrovax_rename = {'Имя позиции в счете':'Наименование услуги',\n",
        "                    '№ продукта':'номер билета',\n",
        "                    'Дата выписки':'Дата оформления билета',\n",
        "                    'Дата начала оказания услуги':'Дата начала командировки (вылета)',\n",
        "                    'Дата окончания оказания услуги':'Дата окончания командировки (прилета)',\n",
        "                    'Город прибытия':'Место командировки',\n",
        "                    'Тип продукта':'Тип услуги',\n",
        "                    'Сумма НДС в счете':'Сумма НДС',\n",
        "                    'Ставка НДС в счете':'Ставка НДС',\n",
        "                    'Сумма счета':'Стоимость услуги с НДС',\n",
        "                    'ИНН поставщика':'ИНН поставщика (авиакомпании, ржд)',\n",
        "                    'Клиент (полное название)':'ЮЛ',\n",
        "                    'Статус продукта':'Вид операции',\n",
        "                    '№ заказа':'Номер заказа в МОМ',\n",
        "                    'Путешественник':'ФИО пассажира'}\n",
        "\n",
        "petrovax_reindex = ['№ п/п',\n",
        "                    'Наименование услуги',\n",
        "                    'Номер заказа в СОБ',\n",
        "                    'ФИО пассажира',\n",
        "                    '№ акта',\n",
        "                    'дата акта',\n",
        "                    'номер билета',\n",
        "                    'Дата оформления билета',\n",
        "                    'Табельный номер',\n",
        "                    'ЦФО',\n",
        "                    'код ЦФО',\n",
        "                    'Дата начала командировки (вылета)',\n",
        "                    'Дата окончания командировки (прилета)',\n",
        "                    'Цель командировки',\n",
        "                    'Место командировки',\n",
        "                    'Тип услуги',\n",
        "                    'Стоимость услуги без НДС',\n",
        "                    'Сумма НДС',\n",
        "                    'Ставка НДС',\n",
        "                    'Стоимость услуги с НДС',\n",
        "                    'номер строки билета',\n",
        "                    'ИНН поставщика (авиакомпании, ржд)',\n",
        "                    'ЮЛ',\n",
        "                    'Бренд',\n",
        "                    'Номер билета к обмену',\n",
        "                    'Вид операции',\n",
        "                    'Номер заказа в МОМ']\n",
        "\n",
        "woerwag_rename = {'Имя позиции в счете':'Содержание',\n",
        "                    'Дата начала оказания услуги':'Даты отправления',\n",
        "                    'Наименование ИНН поставщика':'Перевозчик',\n",
        "                    'ЦФО':'Кост-центр путешественника',\n",
        "                    'Сумма счета':'Сумма',\n",
        "                    'Ставка НДС в счете':'Ставка НДС',\n",
        "                    'Сумма НДС в счете':'Сумма НДС',\n",
        "                    'Стоимость услуги без НДС':'Сумма без НДС',\n",
        "                    'Цель командировки':'Цель поездки',\n",
        "                    'Тип продукта':'Вид услуги',\n",
        "                    'Бренд':'Препарат',\n",
        "                    '№ продукта':'номер билета',\n",
        "                    'Номер заказа в СОБ':'номер заказа в СОБ'}\n",
        "\n",
        "woerwag_reindex = ['Номер СЧФ',\n",
        "                    'Номенклатура',\n",
        "                    'Содержание',\n",
        "                    'Путешественник',\n",
        "                    'Маршрут',\n",
        "                    'Даты отправления',\n",
        "                    'Перевозчик',\n",
        "                    'Кост-центр путешественника',\n",
        "                    'Сумма',\n",
        "                    'Ставка НДС',\n",
        "                    'Сумма НДС',\n",
        "                    'Сумма без НДС',\n",
        "                    'Цель поездки',\n",
        "                    'Вид услуги',\n",
        "                    'Препарат',\n",
        "                    'NON/ded',\n",
        "                    'Tax code',\n",
        "                    'Комментарии',\n",
        "                    'номер билета',\n",
        "                    'номер заказа в СОБ']\n",
        "\n",
        "\n",
        "''' Удаляем ненужные колонки. Ненужные колонки можно и не удалять. На этапе выстраивания последовательности колонок\n",
        "мы перекладываем один df в клиентский с реиндексом, поэтому в исходной форме можно не делать df.drop. '''\n",
        "# client_df.drop(['Расчетный код перевозчика',\n",
        "\n",
        "\n",
        "def map_and_save_client_form(client_df, client_name):\n",
        "    '''\n",
        "    Сборка клиентских форм и запись DataFrame в клиентские файлы\n",
        "    '''\n",
        "\n",
        "    if client_name == 'Petrovax':\n",
        "        print(f'⌛ Запускаем форматирование {client_name}')\n",
        "\n",
        "        ''' Переименовываем колонки'''\n",
        "        client_df.rename(columns = petrovax_rename, inplace = True )\n",
        "\n",
        "        ''' Выстраиваем колонки в нужной последовательности'''\n",
        "        petrovax_df = client_df.reindex(columns=petrovax_reindex)\n",
        "\n",
        "        ''' Модифицируем колонки'''\n",
        "        # Вычисляем колонку \"Стоимость услуги без НДС\"\n",
        "        petrovax_df['Стоимость услуги без НДС'] = petrovax_df['Стоимость услуги с НДС'] - petrovax_df['Сумма НДС']\n",
        "\n",
        "        ''' Модифицируем колонку \"Тип Услуги\" '''\n",
        "        for index1, row in petrovax_df.iterrows():\n",
        "          if str(row[15]).startswith('Железнодорожные билеты'):\n",
        "            if row[1].startswith('ЖД билет'):\n",
        "              petrovax_df.at[index1, 'Тип услуги'] = 'ЖД билет'\n",
        "            else:\n",
        "              petrovax_df.at[index1, 'Тип услуги'] = 'Сборы'\n",
        "\n",
        "          elif str(row[15]).startswith('Авиабилеты'):\n",
        "            if row[1].startswith('Сервисный сбор'):\n",
        "              petrovax_df.at[index1, 'Тип услуги'] = 'Сборы'\n",
        "\n",
        "            elif row[1].startswith('EMD'):\n",
        "              if row[1].startswith('EMD на Штраф '):\n",
        "                petrovax_df.at[index1, 'Тип услуги'] = 'Штраф'\n",
        "              else:\n",
        "                petrovax_df.at[index1, 'Тип услуги'] = 'Допуслуга авиа'\n",
        "\n",
        "            else:\n",
        "              petrovax_df.at[index1, 'Тип услуги'] = 'Авиабилет'\n",
        "\n",
        "          elif str(row[1]).startswith('Проживание'):\n",
        "            petrovax_df.at[index1, 'Тип услуги'] = 'Проживание'\n",
        "\n",
        "          elif str(row[1]).startswith(', '):\n",
        "            petrovax_df.at[index1, 'Тип услуги'] = 'Трансфер'\n",
        "\n",
        "          else:\n",
        "            petrovax_df.at[index1, 'Тип услуги'] = 'Сборы'\n",
        "\n",
        "        ''' Модифицируем колонку \"номер строки билета\" '''\n",
        "        for index_nomer_bileta, row in petrovax_df.iterrows():\n",
        "          if str(row[1]).startswith('Тариф'):\n",
        "            petrovax_df.at[index_nomer_bileta, 'номер строки билета'] = '1'\n",
        "          elif str(row[1]).startswith('Такса ZZ'):\n",
        "            petrovax_df.at[index_nomer_bileta, 'номер строки билета'] = '3'\n",
        "          elif str(row[1]).startswith('Таксы и сборы'):\n",
        "            petrovax_df.at[index_nomer_bileta, 'номер строки билета'] = '2'\n",
        "          else:\n",
        "            print(f'Не могу установить номер строки билета для строки {index_nomer_bileta}.')\n",
        "\n",
        "        ''' Модифицируем колонку \"Вид операции\" '''\n",
        "        for index_vid_opercii, row in petrovax_df.iterrows():\n",
        "          if str(row[15]) in [\"Допуслуга авиа\", \"Штраф\", \"Проживание\", \"Трансфер\", \"Сборы\"]:\n",
        "           petrovax_df.at[index_vid_opercii, 'Вид операции']= 'Сборы'\n",
        "\n",
        "        #print(petrovax_df.columns)\n",
        "        petrovax_df.to_excel(result_filename, index=False)\n",
        "        print(f'\\n✔️ Файл {result_filename} записан')\n",
        "\n",
        "\n",
        "\n",
        "    elif client_name == 'Woerwag':\n",
        "        print(f'⌛ Запускаем форматирование {client_name}')\n",
        "\n",
        "        ''' Переименовываем колонки '''\n",
        "        client_df.rename(columns = woerwag_rename, inplace = True )\n",
        "\n",
        "        ''' Выстраиваем колонки в нужной последовательности '''\n",
        "        woerwag_df = client_df.reindex(columns=woerwag_reindex)\n",
        "\n",
        "        ''' Модифицируем колонки '''\n",
        "\n",
        "        ''' Модифицируем колонку \"Сумма без НДС\"'''\n",
        "        woerwag_df['Сумма без НДС'] = woerwag_df['Сумма'] - woerwag_df['Сумма НДС']\n",
        "\n",
        "        ''' Модифицирем колонку \"Номенклатура\" '''\n",
        "        for index1, row in woerwag_df.iterrows():\n",
        "          if str(row[13]) == 'Авиабилеты':\n",
        "            if row[2].startswith('Сервисный сбор'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Сервисный сбор'\n",
        "            elif row[2].startswith('Такса ZZ'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Такса ZZ'\n",
        "            elif row[2].startswith('Таксы без НДС'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Таксы без НДС'\n",
        "            elif row[2].startswith('Таксы и сборы НДС0'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Таксы и сборы НДС0'\n",
        "            elif row[2].startswith('Таксы и сборы НДС10'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Таксы и сборы НДС10'\n",
        "            else:\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Тариф'\n",
        "\n",
        "          if str(row[13]) == 'Гостиницы':\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Проживание'\n",
        "\n",
        "          if str(row[13]) == 'Железнодорожные билеты':\n",
        "            if row[2].startswith('ЖД билет'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'ЖД билет'\n",
        "            elif row[2].startswith('Сервисный сбор ИМ'):\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Сервисный сбор ИМ'\n",
        "            else:\n",
        "              woerwag_df.at[index1, 'Номенклатура'] = 'Сервисный сбор'\n",
        "\n",
        "        ''' Модифицирем колонку \"Вид услуги\" '''\n",
        "        for index_vid_uslugi, row in woerwag_df.iterrows():\n",
        "          if str(row[13]) == 'Железнодорожные билеты':\n",
        "            woerwag_df.at[index_vid_uslugi, 'Вид услуги'] = 'ЖД билет'\n",
        "          elif str(row[13]) == 'Авиабилеты':\n",
        "            woerwag_df.at[index_vid_uslugi, 'Вид услуги'] = 'Авиабилет'\n",
        "          elif str(row[13]) == 'Гостиницы':\n",
        "            woerwag_df.at[index_vid_uslugi, 'Вид услуги'] = 'Отель'\n",
        "\n",
        "        ''' Модифицирем колонку \"Перевозчик\" '''\n",
        "        for index_perevozchik, row in woerwag_df.iterrows():\n",
        "          if row[1].startswith('ЖД билет'):\n",
        "            woerwag_df.at[index_perevozchik, 'Перевозчик'] = 'РЖД'\n",
        "          elif row[1].startswith('Сервисный сбор ИМ'):\n",
        "            woerwag_df.at[index_perevozchik, 'Перевозчик'] = 'Инновационная мобильность'\n",
        "          elif row[1].startswith('Сервисный сбор'):\n",
        "            woerwag_df.at[index_perevozchik, 'Перевозчик'] = 'ООО \"КОРПОРЭЙТ ТРЭВЕЛ\"'\n",
        "\n",
        "\n",
        "        ''' Записываем файл '''\n",
        "        woerwag_df.to_excel(result_filename, index=False)\n",
        "        print(f'\\n✔️ Файл {result_filename} записан')\n",
        "\n",
        "    else:\n",
        "        print(f'❌Ошибка! Клиента {client_name} не существует')\n",
        "\n",
        "    return None\n",
        "\n",
        "\n",
        "''' Создаем целевой файл для клиента '''\n",
        "map_and_save_client_form(df_normalized, CLIENT)\n"
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    },
    "widgets": {
      "application/vnd.jupyter.widget-state+json": {
        "91271cb506e948e1b70b83d0da9b5afa": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "IntProgressModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "IntProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_d80768cc1c794b8c970eb0829dca5ffb",
            "max": 6,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_a188521522274df697ac8b684a468e93",
            "value": 6
          }
        },
        "d80768cc1c794b8c970eb0829dca5ffb": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "a188521522274df697ac8b684a468e93": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": ""
          }
        }
      }
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}