test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b930fcc2-816b-4fde-9095-1c2ed2d6db23",
   "metadata": {},
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "from tkinter import filedialog, messagebox, ttk, scrolledtext, Label, PhotoImage\n",
    "import pandas as pd\n",
    "import threading\n",
    "import requests\n",
    "import json\n",
    "import logging\n",
    "import os\n",
    "\n",
    "# Setup logging\n",
    "LOG_FILE = \"geocoding.log\"\n",
    "CACHE_FILE = \"geocoding_cache.json\"\n",
    "logging.basicConfig(filename=LOG_FILE, level=logging.INFO, format='%(asctime)s:%(levelname)s:%(message)s')\n",
    "\n",
    "# Global flag to stop geocoding\n",
    "stop_geocoding = False\n",
    "nominatim_ip = 'http://10.102.65.194/nominatim/'\n",
    "\n",
    "def log_message(message):\n",
    "    logging.info(message)\n",
    "\n",
    "# Função para geocodificar endereços usando a API Nominatim local\n",
    "def geocode_address(query):\n",
    "    try:\n",
    "        request_url = f\"{nominatim_ip}search?q={query}&format=json&addressdetails=1&countrycodes=br\"\n",
    "        response = requests.get(request_url, timeout=30)\n",
    "        results = response.json()\n",
    "        if results:\n",
    "            result = results[0]\n",
    "            lat = float(result['lat'])\n",
    "            lon = float(result['lon'])\n",
    "            return {'lat': lat, 'lon': lon}\n",
    "    except requests.exceptions.Timeout:\n",
    "        log_message(f\"Timeout na geocodificação para a query: {query}\")\n",
    "    except Exception as e:\n",
    "        log_message(f\"Erro na geocodificação: {e}\")\n",
    "    return None\n",
    "\n",
    "# Função para carregar ou criar o cache\n",
    "def load_or_create_cache():\n",
    "    if not os.path.isfile(CACHE_FILE):\n",
    "        with open(CACHE_FILE, 'w') as file:\n",
    "            json.dump({}, file)\n",
    "        log_message(\"New cache file created.\")\n",
    "    try:\n",
    "        with open(CACHE_FILE, 'r') as file:\n",
    "            cache = json.load(file)\n",
    "    except json.JSONDecodeError:\n",
    "        log_message(\"Cache file is corrupted. Creating a new one.\")\n",
    "        cache = {}\n",
    "    return cache\n",
    "\n",
    "# Função para atualizar o cache\n",
    "def update_cache(cache):\n",
    "    with open(CACHE_FILE, 'w') as file:\n",
    "        json.dump(cache, file, indent=4)\n",
    "\n",
    "def geocode_addresses(input_file, selected_columns, progress_callback, finished_callback, status_callback):\n",
    "    global stop_geocoding\n",
    "    status_callback(\"Preparing data... This may take some time...\")\n",
    "    df_input = pd.read_excel(input_file)\n",
    "    \n",
    "    cache = load_or_create_cache()\n",
    "    \n",
    "    status_callback(\"Geocoding data...\")\n",
    "    for index, row in df_input.iterrows():\n",
    "        if stop_geocoding:\n",
    "            break\n",
    "        address_parts = [str(row[col]).strip() for col in selected_columns if col in df_input.columns]\n",
    "        address = ' '.join(address_parts)\n",
    "        cache_key = address\n",
    "        \n",
    "        if cache_key in cache:\n",
    "            result = cache[cache_key]\n",
    "        else:\n",
    "            result = geocode_address(address)\n",
    "            if result:\n",
    "                cache[cache_key] = result\n",
    "                update_cache(cache)\n",
    "        \n",
    "        if result:\n",
    "            df_input.at[index, 'Latitude'] = result['lat']\n",
    "            df_input.at[index, 'Longitude'] = result['lon']\n",
    "            progress_callback(index + 1, df_input.shape[0])\n",
    "    \n",
    "    update_cache(cache)\n",
    "    \n",
    "    output_file = os.path.splitext(input_file)[0] + \"_geocoded.xlsx\"\n",
    "    df_input.to_excel(output_file, index=False)\n",
    "    finished_callback(output_file, not stop_geocoding)\n",
    "\n",
    "class GeocodeApp(tk.Tk):\n",
    "    def __init__(self):\n",
    "        super().__init__()\n",
    "        self.title(\"Geocoding App with Local Nominatim API\")\n",
    "        self.geometry(\"700x550\")\n",
    "        \n",
    "        self.nominatim_ip = tk.StringVar(value=nominatim_ip)\n",
    "        \n",
    "        self.create_widgets()\n",
    "        self.file_path = \"\"\n",
    "        self.column_checkboxes = []\n",
    "        self.selected_columns = []\n",
    "        \n",
    "    def create_widgets(self):\n",
    "        self.file_label = tk.Label(self, text=\"No file selected\")\n",
    "        self.file_label.pack(pady=10)\n",
    "        \n",
    "        self.browse_button = tk.Button(self, text=\"Browse\", command=self.browse_file)\n",
    "        self.browse_button.pack()\n",
    "\n",
    "        self.api_frame = tk.LabelFrame(self, text=\"Nominatim API Settings\")\n",
    "        self.api_frame.pack(pady=10, fill=\"x\", expand=\"no\")\n",
    "        \n",
    "        self.api_label = tk.Label(self.api_frame, text=\"API IP:\")\n",
    "        self.api_label.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.api_entry = tk.Entry(self.api_frame, textvariable=self.nominatim_ip, width=50)\n",
    "        self.api_entry.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.test_api_button = tk.Button(self.api_frame, text=\"Test\", command=self.test_nominatim_api)\n",
    "        self.test_api_button.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.api_status = Label(self.api_frame, text=\"●\", fg=\"red\", font=(\"TkDefaultFont\", 16))\n",
    "        self.api_status.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.columns_frame = tk.LabelFrame(self, text=\"Columns\")\n",
    "        self.columns_scroll = scrolledtext.ScrolledText(self.columns_frame, width=50, height=10, wrap=tk.WORD)\n",
    "        self.columns_scroll.pack()\n",
    "        self.columns_frame.pack(pady=10, fill=\"both\", expand=\"yes\")\n",
    "        \n",
    "        self.status_label = tk.Label(self, text=\"\")\n",
    "        self.status_label.pack(pady=10)\n",
    "\n",
    "        self.start_button = tk.Button(self, text=\"Start Geocoding\", command=self.start_geocoding)\n",
    "        self.start_button.pack(pady=5)\n",
    "        \n",
    "        self.stop_button = tk.Button(self, text=\"Stop Geocoding\", command=self.stop_geocoding, state=tk.DISABLED)\n",
    "        self.stop_button.pack(pady=5)\n",
    "\n",
    "        self.progress_label = tk.Label(self, text=\"Progress: 0/0\")\n",
    "        self.progress_label.pack(pady=5)\n",
    "        \n",
    "        self.progress = ttk.Progressbar(self, orient=tk.HORIZONTAL, length=300, mode='determinate')\n",
    "        self.progress.pack(pady=20)\n",
    "\n",
    "    def test_nominatim_api(self):\n",
    "        try:\n",
    "            response = requests.get(self.nominatim_ip.get(), timeout=5)\n",
    "            if response.status_code == 200:\n",
    "                self.api_status.config(fg=\"green\")\n",
    "                messagebox.showinfo(\"API Test\", \"Nominatim API is online.\")\n",
    "            else:\n",
    "                self.api_status.config(fg=\"red\")\n",
    "                messagebox.showerror(\"API Test\", \"Nominatim API is offline.\")\n",
    "        except:\n",
    "            self.api_status.config(fg=\"red\")\n",
    "            messagebox.showerror(\"API Test\", \"Nominatim API is offline.\")\n",
    "\n",
    "    def browse_file(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = False\n",
    "        file_path = filedialog.askopenfilename(filetypes=[(\"Excel files\", \"*.xlsx *.xls\")])\n",
    "        if file_path:\n",
    "            self.file_path = file_path\n",
    "            self.file_label.config(text=f\"File: {os.path.basename(file_path)}\")\n",
    "            self.display_column_checkboxes(file_path)\n",
    "\n",
    "    def display_column_checkboxes(self, file_path):\n",
    "        for widget in self.columns_frame.winfo_children():\n",
    "            widget.destroy()\n",
    "        \n",
    "        df = pd.read_excel(file_path)\n",
    "        self.selected_columns = []\n",
    "        for col in df.columns:\n",
    "            var = tk.BooleanVar()\n",
    "            chk = tk.Checkbutton(self.columns_frame, text=col, variable=var)\n",
    "            chk.pack(anchor='w')\n",
    "            self.column_checkboxes.append((var, col))\n",
    "    \n",
    "    def update_progress(self, current, total):\n",
    "        self.progress['value'] = (current / total) * 100\n",
    "        self.progress_label.config(text=f\"Progress: {current}/{total}\")\n",
    "        self.update_idletasks()\n",
    "\n",
    "    def finished_geocoding(self, output_file, success):\n",
    "        if success:\n",
    "            messagebox.showinfo(\"Complete\", f\"Geocoding complete. Output saved to {output_file}\")\n",
    "        else:\n",
    "            messagebox.showinfo(\"Stopped\", \"Geocoding stopped by user.\")\n",
    "        self.start_button['state'] = tk.NORMAL\n",
    "        self.stop_button['state'] = tk.DISABLED\n",
    "    \n",
    "    def update_status(self, message):\n",
    "        self.status_label.config(text=message)\n",
    "        self.update_idletasks()\n",
    "\n",
    "    def start_geocoding(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = False\n",
    "        selected_columns = [col for var, col in self.column_checkboxes if var.get()]\n",
    "        if not self.file_path or not selected_columns:\n",
    "            messagebox.showerror(\"Error\", \"Please select a file and at least one column.\")\n",
    "            return\n",
    "        self.start_button['state'] = tk.DISABLED\n",
    "        self.stop_button['state'] = tk.NORMAL\n",
    "        threading.Thread(target=geocode_addresses, args=(self.file_path, selected_columns, self.update_progress, self.finished_geocoding, self.update_status)).start()\n",
    "\n",
    "    def stop_geocoding(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = True\n",
    "        self.stop_button['state'] = tk.DISABLED\n",
    "\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app = GeocodeApp()\n",
    "    app.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f4318bb1-b5a3-4576-b39a-f83558880f5f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "4541967c-949a-4a8e-be54-3b7c747f8b9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import tkinter as tk\n",
    "from tkinter import filedialog, messagebox, ttk, scrolledtext, Label\n",
    "import pandas as pd\n",
    "import threading\n",
    "import requests\n",
    "import json\n",
    "import logging\n",
    "import os\n",
    "\n",
    "# Configuração do logging\n",
    "LOG_FILE = \"geocoding.log\"\n",
    "CACHE_FILE = \"geocoding_cache.json\"\n",
    "logging.basicConfig(filename=LOG_FILE, level=logging.INFO, format='%(asctime)s:%(levelname)s:%(message)s')\n",
    "\n",
    "# Sinalizador global para interromper a geocodificação\n",
    "stop_geocoding = False\n",
    "nominatim_ip = 'http://10.102.65.194/nominatim/'\n",
    "\n",
    "def log_message(message):\n",
    "    logging.info(message)\n",
    "\n",
    "def load_or_create_cache():\n",
    "    if not os.path.isfile(CACHE_FILE):\n",
    "        with open(CACHE_FILE, 'w') as file:\n",
    "            json.dump({}, file)\n",
    "        log_message(\"New cache file created.\")\n",
    "    try:\n",
    "        with open(CACHE_FILE, 'r') as file:\n",
    "            cache = json.load(file)\n",
    "    except json.JSONDecodeError:\n",
    "        log_message(\"Cache file is corrupted. Creating a new one.\")\n",
    "        cache = {}\n",
    "    return cache\n",
    "\n",
    "def update_cache(cache):\n",
    "    with open(CACHE_FILE, 'w') as file:\n",
    "        json.dump(cache, file, indent=4)\n",
    "\n",
    "def geocode_address(query, precision_level):\n",
    "    try:\n",
    "        request_url = f\"{nominatim_ip}search?q={query}&format=json&addressdetails=1&countrycodes=br\"\n",
    "        response = requests.get(request_url, timeout=30)\n",
    "        results = response.json()\n",
    "        if results:\n",
    "            result = results[0]\n",
    "            lat = float(result['lat'])\n",
    "            lon = float(result['lon'])\n",
    "            return {'lat': lat, 'lon': lon, 'precision': precision_level}\n",
    "    except requests.exceptions.Timeout:\n",
    "        log_message(f\"Timeout na geocodificação para a query: {query}\")\n",
    "    except Exception as e:\n",
    "        log_message(f\"Erro na geocodificação: {e}\")\n",
    "    return None\n",
    "\n",
    "def geocode_addresses(input_file, selected_columns, progress_callback, finished_callback, status_callback):\n",
    "    global stop_geocoding\n",
    "    status_callback(\"Preparing data... This may take some time...\")\n",
    "    df_input = pd.read_excel(input_file)\n",
    "    \n",
    "    cache = load_or_create_cache()\n",
    "    \n",
    "    # Define o caminho do arquivo de saída com antecedência\n",
    "    output_file = os.path.splitext(input_file)[0] + \"_geocoded.xlsx\"\n",
    "    \n",
    "    status_callback(\"Geocoding data...\")\n",
    "    for index, row in df_input.iterrows():\n",
    "        if stop_geocoding:\n",
    "            break\n",
    "        \n",
    "        # Verifica se o endereço já foi geocodificado para evitar processamento duplicado\n",
    "        if pd.notna(row.get('Latitude')) and pd.notna(row.get('Longitude')):\n",
    "            progress_callback(index + 1, df_input.shape[0])\n",
    "            continue  # Se já geocodificado, passa para o próximo endereço\n",
    "        \n",
    "        success = False\n",
    "        for precision_level in range(len(selected_columns), 0, -1):\n",
    "            address_parts = [str(row[col]).strip() for col in selected_columns[:precision_level]]\n",
    "            address = ', '.join(address_parts) + ', br'\n",
    "            cache_key = '-'.join(address_parts)\n",
    "            \n",
    "            if cache_key in cache:\n",
    "                result = cache[cache_key]\n",
    "            else:\n",
    "                result = geocode_address(address, precision_level)\n",
    "                if result:\n",
    "                    cache[cache_key] = result\n",
    "                    update_cache(cache)\n",
    "                else:\n",
    "                    continue  # Próximo nível de precisão\n",
    "\n",
    "            if result:\n",
    "                df_input.at[index, 'Latitude'] = result['lat']\n",
    "                df_input.at[index, 'Longitude'] = result['lon']\n",
    "                df_input.at[index, 'Precision'] = result['precision']\n",
    "                progress_callback(index + 1, df_input.shape[0])\n",
    "                success = True\n",
    "                # Salva o DataFrame após cada geocodificação com sucesso\n",
    "                df_input.to_excel(output_file, index=False)\n",
    "                break\n",
    "\n",
    "        if not success:\n",
    "            log_message(f\"Endereço '{cache_key}' não foi geocodificado com sucesso.\")\n",
    "    \n",
    "    update_cache(cache)\n",
    "    finished_callback(output_file, not stop_geocoding)\n",
    "\n",
    "\n",
    "class GeocodeApp(tk.Tk):\n",
    "    def __init__(self):\n",
    "        super().__init__()\n",
    "        self.title(\"Transporte e Meio Ambiente(Trama) - Geocoding App with Local Nominatim API - APP\")\n",
    "        self.geometry(\"700x550\")\n",
    "        \n",
    "        self.nominatim_ip = tk.StringVar(value=nominatim_ip)\n",
    "        \n",
    "        self.create_widgets()\n",
    "        self.file_path = \"\"\n",
    "        self.column_checkboxes = []\n",
    "        self.selected_columns = []\n",
    "        \n",
    "    def create_widgets(self):\n",
    "        self.file_label = tk.Label(self, text=\"No file selected\")\n",
    "        self.file_label.pack(pady=10)\n",
    "        \n",
    "        self.browse_button = tk.Button(self, text=\"Browse\", command=self.browse_file)\n",
    "        self.browse_button.pack()\n",
    "\n",
    "        self.api_frame = tk.LabelFrame(self, text=\"Nominatim API Settings\")\n",
    "        self.api_frame.pack(pady=10, fill=\"x\", expand=\"no\")\n",
    "        \n",
    "        self.api_label = tk.Label(self.api_frame, text=\"API IP:\")\n",
    "        self.api_label.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.api_entry = tk.Entry(self.api_frame, textvariable=self.nominatim_ip, width=50)\n",
    "        self.api_entry.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.test_api_button = tk.Button(self.api_frame, text=\"Test\", command=self.test_nominatim_api)\n",
    "        self.test_api_button.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.api_status = Label(self.api_frame, text=\"●\", fg=\"red\", font=(\"TkDefaultFont\", 16))\n",
    "        self.api_status.pack(side=tk.LEFT, padx=5)\n",
    "        \n",
    "        self.columns_frame = tk.LabelFrame(self, text=\"Columns\")\n",
    "        self.columns_scroll = scrolledtext.ScrolledText(self.columns_frame, width=50, height=10, wrap=tk.WORD)\n",
    "        self.columns_scroll.pack()\n",
    "        self.columns_frame.pack(pady=10, fill=\"both\", expand=\"yes\")\n",
    "        \n",
    "        self.status_label = tk.Label(self, text=\"\")\n",
    "        self.status_label.pack(pady=10)\n",
    "\n",
    "        self.start_button = tk.Button(self, text=\"Start Geocoding\", command=self.start_geocoding)\n",
    "        self.start_button.pack(pady=5)\n",
    "        \n",
    "        self.stop_button = tk.Button(self, text=\"Stop Geocoding\", command=self.stop_geocoding, state=tk.DISABLED)\n",
    "        self.stop_button.pack(pady=5)\n",
    "\n",
    "        self.progress_label = tk.Label(self, text=\"Progress: 0/0\")\n",
    "        self.progress_label.pack(pady=5)\n",
    "        \n",
    "        self.progress = ttk.Progressbar(self, orient=tk.HORIZONTAL, length=300, mode='determinate')\n",
    "        self.progress.pack(pady=20)\n",
    "\n",
    "    def test_nominatim_api(self):\n",
    "        try:\n",
    "            response = requests.get(self.nominatim_ip.get(), timeout=5)\n",
    "            if response.status_code == 200:\n",
    "                self.api_status.config(fg=\"green\")\n",
    "                messagebox.showinfo(\"API Test\", \"Nominatim API is online.\")\n",
    "            else:\n",
    "                self.api_status.config(fg=\"red\")\n",
    "                messagebox.showerror(\"API Test\", \"Nominatim API is offline.\")\n",
    "        except:\n",
    "            self.api_status.config(fg=\"red\")\n",
    "            messagebox.showerror(\"API Test\", \"Nominatim API is offline.\")\n",
    "\n",
    "    def browse_file(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = False\n",
    "        file_path = filedialog.askopenfilename(filetypes=[(\"Excel files\", \"*.xlsx *.xls\")])\n",
    "        if file_path:\n",
    "            self.file_path = file_path\n",
    "            self.file_label.config(text=f\"File: {os.path.basename(file_path)}\")\n",
    "            self.display_column_checkboxes(file_path)\n",
    "\n",
    "    def display_column_checkboxes(self, file_path):\n",
    "        for widget in self.columns_frame.winfo_children():\n",
    "            widget.destroy()\n",
    "        \n",
    "        df = pd.read_excel(file_path)\n",
    "        self.selected_columns = []\n",
    "        for col in df.columns:\n",
    "            var = tk.BooleanVar()\n",
    "            chk = tk.Checkbutton(self.columns_frame, text=col, variable=var)\n",
    "            chk.pack(anchor='w')\n",
    "            self.column_checkboxes.append((var, col))\n",
    "    \n",
    "    def update_progress(self, current, total):\n",
    "        self.progress['value'] = (current / total) * 100\n",
    "        self.progress_label.config(text=f\"Progress: {current}/{total}\")\n",
    "        self.update_idletasks()\n",
    "\n",
    "    def finished_geocoding(self, output_file, success):\n",
    "        if success:\n",
    "            messagebox.showinfo(\"Complete\", f\"Geocoding complete. Output saved to {output_file}\")\n",
    "        else:\n",
    "            messagebox.showinfo(\"Stopped\", \"Geocoding stopped by user.\")\n",
    "        self.start_button['state'] = tk.NORMAL\n",
    "        self.stop_button['state'] = tk.DISABLED\n",
    "    \n",
    "    def update_status(self, message):\n",
    "        self.status_label.config(text=message)\n",
    "        self.update_idletasks()\n",
    "\n",
    "    def start_geocoding(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = False\n",
    "        selected_columns = [col for var, col in self.column_checkboxes if var.get()]\n",
    "        if not self.file_path or not selected_columns:\n",
    "            messagebox.showerror(\"Error\", \"Please select a file and at least one column.\")\n",
    "            return\n",
    "        self.start_button['state'] = tk.DISABLED\n",
    "        self.stop_button['state'] = tk.NORMAL\n",
    "        threading.Thread(target=geocode_addresses, args=(self.file_path, selected_columns, self.update_progress, self.finished_geocoding, self.update_status)).start()\n",
    "\n",
    "    def stop_geocoding(self):\n",
    "        global stop_geocoding\n",
    "        stop_geocoding = True\n",
    "        self.stop_button['state'] = tk.DISABLED\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app = GeocodeApp()\n",
    "    app.mainloop()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "0b01e3e4-69a8-42bc-a373-a16c3195c8fb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Current working directory: C:\\Users\\jairo\\OneDrive\\Desktop\\geocode-with-nominatim\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "print(\"Current working directory:\", os.getcwd())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0ca0d701-d265-40ad-a0ce-4ef7a910c567",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Current working directory: C:\\Users\\jairo\\OneDrive\\Desktop\\geocode-with-nominatim\n",
      "['logo_trama.png']\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "\n",
    "# Imprime o diretório de trabalho atual\n",
    "print(\"Current working directory:\", os.getcwd())\n",
    "\n",
    "# Lista todos os arquivos com extensão .png no diretório atual\n",
    "arquivos_png = [arquivo for arquivo in os.listdir(os.getcwd()) if arquivo.endswith('.png')]\n",
    "print(arquivos_png)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "304200ab-8f80-4ddd-a897-9587611929e8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}