{ "cells": [ { "cell_type": "markdown", "id": "c02f3f23", "metadata": {}, "source": [ "# Interaktivní mapa lázeňských míst v ČR\n", "## Instalace balíčků" ] }, { "cell_type": "code", "execution_count": 1, "id": "758d80f6", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Requirement already satisfied: pandas in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (3.0.1)\n", "Requirement already satisfied: requests in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (2.33.0)\n", "Requirement already satisfied: beautifulsoup4 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (4.14.3)\n", "Requirement already satisfied: geopy in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (2.4.1)\n", "Requirement already satisfied: folium in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (0.20.0)\n", "Requirement already satisfied: lxml in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (6.0.2)\n", "Requirement already satisfied: openpyxl in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (3.1.5)\n", "Requirement already satisfied: numpy>=1.26.0 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from pandas) (2.4.2)\n", "Requirement already satisfied: python-dateutil>=2.8.2 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from pandas) (2.9.0.post0)\n", "Requirement already satisfied: charset_normalizer<4,>=2 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from requests) (3.4.6)\n", "Requirement already satisfied: idna<4,>=2.5 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from requests) (3.11)\n", "Requirement already satisfied: urllib3<3,>=1.26 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from requests) (2.6.3)\n", "Requirement already satisfied: certifi>=2023.5.7 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from requests) (2026.2.25)\n", "Requirement already satisfied: soupsieve>=1.6.1 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from beautifulsoup4) (2.8.3)\n", "Requirement already satisfied: typing-extensions>=4.0.0 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from beautifulsoup4) (4.15.0)\n", "Requirement already satisfied: geographiclib<3,>=1.52 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from geopy) (2.1)\n", "Requirement already satisfied: branca>=0.6.0 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from folium) (0.8.2)\n", "Requirement already satisfied: jinja2>=2.9 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from folium) (3.1.6)\n", "Requirement already satisfied: xyzservices in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from folium) (2025.11.0)\n", "Requirement already satisfied: et-xmlfile in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from openpyxl) (2.0.0)\n", "Requirement already satisfied: MarkupSafe>=2.0 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from jinja2>=2.9->folium) (3.0.3)\n", "Requirement already satisfied: six>=1.5 in /opt/homebrew/Caskroom/miniconda/base/envs/jupyter/lib/python3.12/site-packages (from python-dateutil>=2.8.2->pandas) (1.17.0)\n", "Note: you may need to restart the kernel to use updated packages.\n" ] } ], "source": [ "%pip install pandas requests beautifulsoup4 geopy folium lxml openpyxl" ] }, { "cell_type": "markdown", "id": "a0176193", "metadata": {}, "source": [ "## Import potřebných knihoven" ] }, { "cell_type": "code", "execution_count": 2, "id": "32ff69ff", "metadata": {}, "outputs": [], "source": [ "# práce se vstupem a výstupem (soubory v prostém textu apod.)\n", "import io\n", "\n", "# práce s tabulkovými daty\n", "import pandas as pd\n", "\n", "# web scraping\n", "import requests\n", "from bs4 import BeautifulSoup\n", "\n", "# geokódování\n", "from geopy.geocoders import ArcGIS\n", "from geopy.extra.rate_limiter import RateLimiter" ] }, { "cell_type": "markdown", "id": "e888b63d", "metadata": {}, "source": [ "## Získání dat z webu a zobrazení získaných dat" ] }, { "cell_type": "code", "execution_count": 3, "id": "971d6051", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LokalitaStatut lázeňského místaPoskytování LLRPPoznámka
0BechyněANOANONaN
1BělovesANONEnefunkční lázeňské místo
2BílinaANONEnefunkční lázeňské místo
3BludovANOANONaN
4BuchloviceNEANOjsou vyhlášeny pouze přírodní léčebné lázně
5DubíANOANONaN
6Františkovy LázněANOANONaN
7FrymburkNENEjsou vyhlášeny pouze přírodní léčebné lázně
8Hodonín – JosefovANOANONaN
9JáchymovANOANONaN
10Janské LázněANOANONaN
11JeseníkANOANONaN
12Karlova StudánkaANOANONaN
13Karlovy VaryANOANONaN
14Karviná – DarkovANOANONaN
15Klášterec nad OhříNEANONaN
16Konstantinovy LázněANOANONaN
17Kostelec u ZlínaANOANONaN
18Lázně BělohradANOANONaN
19Lázně BohdanečANOANONaN
20Lázně KundraticeANOANONaN
21Lázně KynžvartANOANONaN
22Lázně LibverdaANOANONaN
23LedniceANOANONaN
24Lipová-lázněANOANONaN
25LuhačoviceANOANONaN
26Mariánské LázněANOANONaN
27Mšené LázněANOANONaN
28KlimkoviceANOANONaN
29Ostrožská Nová VesANOANONaN
30PoděbradyANOANONaN
31SlatiniceANOANONaN
32Teplice nad BečvouANOANONaN
33Teplice v ČecháchANOANONaN
34ToušeňANOANONaN
35TřeboňANOANONaN
36VelichovkyANOANONaN
37Velké LosinyANOANONaN
38VrážANOANONaN
39ŽelezniceNENElázeňské místo zrušeno
\n", "
" ], "text/plain": [ "0 Lokalita Statut lázeňského místa Poskytování LLRP \\\n", "0 Bechyně ANO ANO \n", "1 Běloves ANO NE \n", "2 Bílina ANO NE \n", "3 Bludov ANO ANO \n", "4 Buchlovice NE ANO \n", "5 Dubí ANO ANO \n", "6 Františkovy Lázně ANO ANO \n", "7 Frymburk NE NE \n", "8 Hodonín – Josefov ANO ANO \n", "9 Jáchymov ANO ANO \n", "10 Janské Lázně ANO ANO \n", "11 Jeseník ANO ANO \n", "12 Karlova Studánka ANO ANO \n", "13 Karlovy Vary ANO ANO \n", "14 Karviná – Darkov ANO ANO \n", "15 Klášterec nad Ohří NE ANO \n", "16 Konstantinovy Lázně ANO ANO \n", "17 Kostelec u Zlína ANO ANO \n", "18 Lázně Bělohrad ANO ANO \n", "19 Lázně Bohdaneč ANO ANO \n", "20 Lázně Kundratice ANO ANO \n", "21 Lázně Kynžvart ANO ANO \n", "22 Lázně Libverda ANO ANO \n", "23 Lednice ANO ANO \n", "24 Lipová-lázně ANO ANO \n", "25 Luhačovice ANO ANO \n", "26 Mariánské Lázně ANO ANO \n", "27 Mšené Lázně ANO ANO \n", "28 Klimkovice ANO ANO \n", "29 Ostrožská Nová Ves ANO ANO \n", "30 Poděbrady ANO ANO \n", "31 Slatinice ANO ANO \n", "32 Teplice nad Bečvou ANO ANO \n", "33 Teplice v Čechách ANO ANO \n", "34 Toušeň ANO ANO \n", "35 Třeboň ANO ANO \n", "36 Velichovky ANO ANO \n", "37 Velké Losiny ANO ANO \n", "38 Vráž ANO ANO \n", "39 Železnice NE NE \n", "\n", "0 Poznámka \n", "0 NaN \n", "1 nefunkční lázeňské místo \n", "2 nefunkční lázeňské místo \n", "3 NaN \n", "4 jsou vyhlášeny pouze přírodní léčebné lázně \n", "5 NaN \n", "6 NaN \n", "7 jsou vyhlášeny pouze přírodní léčebné lázně \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 lázeňské místo zrušeno " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# web scraping: stažení HTML stránky ministerstva zdravotnictví\n", "\n", "url = \"https://www.mzcr.cz/seznam-lazenskych-mist-v-cr/\"\n", "# HTTP požadavek na server\n", "response = requests.get(url)\n", "\n", "# převod HTML na strukturovaný objekt\n", "\n", "soup = BeautifulSoup(response.content, \"html.parser\")\n", "# najde HTML tabulku na stránce\n", "table = soup.find(\"table\")\n", "table_html = str(table)\n", "# automaticky převede HTML tabulku na DataFrame (vybere první tabulku)\n", "df = pd.read_html(io.StringIO(table_html), flavor=\"lxml\")[0]\n", "\n", "if df.iloc[0].astype(str).str.contains(\"Lokalita\").any():\n", " # nastavení správných názvů sloupců\n", " df.columns = df.iloc[0]\n", " # odstranění původního řádku s hlavičkami a přečíslování řádků od 0\n", " df = df.drop(0).reset_index(drop=True)\n", "\n", "df" ] }, { "cell_type": "markdown", "id": "5bd06d2b", "metadata": {}, "source": [ "Stručný souhrn o DataFrame zahrnující informace o datovém typu indexu a sloupcích, nenulových hodnotách a využití paměti." ] }, { "cell_type": "code", "execution_count": 4, "id": "fac12ba3", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "RangeIndex: 40 entries, 0 to 39\n", "Data columns (total 4 columns):\n", " # Column Non-Null Count Dtype\n", "--- ------ -------------- -----\n", " 0 Lokalita 40 non-null str \n", " 1 Statut lázeňského místa 40 non-null str \n", " 2 Poskytování LLRP 40 non-null str \n", " 3 Poznámka 5 non-null str \n", "dtypes: str(4)\n", "memory usage: 2.3 KB\n" ] } ], "source": [ "df.info()" ] }, { "cell_type": "markdown", "id": "196cc9f0", "metadata": {}, "source": [ "## Geokódování lokalit" ] }, { "cell_type": "code", "execution_count": 5, "id": "2c484eae", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "Geokóduji lokality...\n", "======================================================================\n", "✓ Bechyně\n", "✓ Běloves\n", "✓ Bílina\n", "✓ Bludov\n", "✓ Buchlovice\n", "✓ Dubí\n", "✓ Františkovy Lázně\n", "✓ Frymburk\n", "✓ Hodonín – Josefov\n", "✓ Jáchymov\n", "✓ Janské Lázně\n", "✓ Jeseník\n", "✓ Karlova Studánka\n", "✓ Karlovy Vary\n", "✓ Karviná – Darkov\n", "✓ Klášterec nad Ohří\n", "✓ Konstantinovy Lázně\n", "✓ Kostelec u Zlína\n", "✓ Lázně Bělohrad\n", "✓ Lázně Bohdaneč\n", "✓ Lázně Kundratice\n", "✓ Lázně Kynžvart\n", "✓ Lázně Libverda\n", "✓ Lednice\n", "✓ Lipová-lázně\n", "✓ Luhačovice\n", "✓ Mariánské Lázně\n", "✓ Mšené Lázně\n", "✓ Klimkovice\n", "✓ Ostrožská Nová Ves\n", "✓ Poděbrady\n", "✓ Slatinice\n", "✓ Teplice nad Bečvou\n", "✓ Teplice v Čechách\n", "✓ Toušeň\n", "✓ Třeboň\n", "✓ Velichovky\n", "✓ Velké Losiny\n", "✓ Vráž\n", "✓ Železnice\n", "======================================================================\n", "\n", "Úspěšně geokódováno: 40/40\n", "Lokality se souřadnicemi: 40\n" ] } ], "source": [ "print(\"\\nGeokóduji lokality...\")\n", "print(\"=\" * 70)\n", "\n", "# nástroj pro převod názvu místa na souřadnice\n", "geolocator = ArcGIS(user_agent=\"mzcr_scraper\", timeout=10)\n", "\n", "# trochu zpomalíme\n", "geocode_with_delay = RateLimiter(\n", " geolocator.geocode,\n", " min_delay_seconds=1,\n", " max_retries=2,\n", " error_wait_seconds=3,\n", ")\n", "\n", "# příprava prázdných seznamů pro ukládání souřadnic\n", "latitudes = []\n", "longitudes = []\n", "\n", "# iterace přes každý řádek tabulky\n", "for idx, row in df.iterrows():\n", " location = row[\"Lokalita\"]\n", " if pd.isna(location):\n", " latitudes.append(None)\n", " longitudes.append(None)\n", " print(f\"✗ {idx}: chybějící lokalita\")\n", " continue\n", "\n", " # název Vráž je nutné pro správnou geolokaci upřesnit\n", " search_query = location\n", " if location == \"Vráž\":\n", " search_query = \"Vráž u Písku\"\n", " # přidání země k lokalitám pro přesnější výsledky\n", " search_query += \", Česká republika\"\n", "\n", " try:\n", " result = geocode_with_delay(search_query)\n", " if result and hasattr(result, \"latitude\"):\n", " latitudes.append(result.latitude)\n", " longitudes.append(result.longitude)\n", " print(f\"✓ {location}\")\n", " else:\n", " latitudes.append(None)\n", " longitudes.append(None)\n", " print(f\"✗ {location} - nenalezeno (result: {result})\")\n", " except Exception as e:\n", " latitudes.append(None)\n", " longitudes.append(None)\n", " print(f\"✗ {location} - chyba: {e}\")\n", "\n", "# přidání souřadnic do dataframe\n", "\n", "# vytvoření kopie dat (ochrana originálu)\n", "df_clean = df.copy()\n", "# přidání nových sloupců se souřadnicemi\n", "df_clean[\"latitude\"] = pd.Series(latitudes, dtype=float)\n", "df_clean[\"longitude\"] = pd.Series(longitudes, dtype=float)\n", "\n", "print(\"=\" * 70)\n", "success_count = df_clean[\"latitude\"].notna().sum()\n", "print(f\"\\nÚspěšně geokódováno: {success_count}/{len(df_clean)}\")\n", "\n", "# odstranění řádků bez souřadnic\n", "df_clean = df_clean.dropna(subset=[\"latitude\", \"longitude\"])\n", "print(f\"Lokality se souřadnicemi: {len(df_clean)}\")" ] }, { "cell_type": "markdown", "id": "cefa7961", "metadata": {}, "source": [ "## Zobrazení tabulky rozšířené o geolokační data" ] }, { "cell_type": "code", "execution_count": 6, "id": "b896ff0d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LokalitaStatut lázeňského místaPoskytování LLRPPoznámkalatitudelongitude
0BechyněANOANONaN49.29955014.470589
1BělovesANONEnefunkční lázeňské místo50.42096916.186414
2BílinaANONEnefunkční lázeňské místo50.55088513.778960
3BludovANOANONaN49.94334016.923007
4BuchloviceNEANOjsou vyhlášeny pouze přírodní léčebné lázně49.08769917.334893
5DubíANOANONaN50.67179113.796859
6Františkovy LázněANOANONaN50.12506912.347309
7FrymburkNENEjsou vyhlášeny pouze přírodní léčebné lázně48.67057014.148734
8Hodonín – JosefovANOANONaN48.83944717.009394
9JáchymovANOANONaN50.36698912.920475
10Janské LázněANOANONaN50.63219815.778962
11JeseníkANOANONaN50.27748217.148386
12Karlova StudánkaANOANONaN50.07376217.307615
13Karlovy VaryANOANONaN50.23188512.857833
14Karviná – DarkovANOANONaN49.84457418.543278
15Klášterec nad OhříNEANONaN50.38717213.184552
16Konstantinovy LázněANOANONaN49.88096812.981676
17Kostelec u ZlínaANOANONaN49.26227017.703135
18Lázně BělohradANOANONaN50.43317615.581435
19Lázně BohdanečANOANONaN50.07466515.677325
20Lázně KundraticeANOANONaN50.69755714.911097
21Lázně KynžvartANOANONaN50.00879612.625262
22Lázně LibverdaANOANONaN50.89089215.200040
23LedniceANOANONaN48.79867416.801194
24Lipová-lázněANOANONaN50.22679717.134974
25LuhačoviceANOANONaN49.09869317.753463
26Mariánské LázněANOANONaN49.95810312.700273
27Mšené LázněANOANONaN50.36078014.110850
28KlimkoviceANOANONaN49.78780718.128487
29Ostrožská Nová VesANOANONaN49.00395017.436496
30PoděbradyANOANONaN50.14729215.120567
31SlatiniceANOANONaN49.56174517.100577
32Teplice nad BečvouANOANONaN49.52847417.739646
33Teplice v ČecháchANOANONaN50.64650413.829472
34ToušeňANOANONaN50.16906014.716760
35TřeboňANOANONaN49.00726514.762234
36VelichovkyANOANONaN50.35489815.838102
37Velké LosinyANOANONaN50.04062617.048241
38VrážANOANONaN49.38462614.128398
39ŽelezniceNENElázeňské místo zrušeno50.47322115.383594
\n", "
" ], "text/plain": [ "0 Lokalita Statut lázeňského místa Poskytování LLRP \\\n", "0 Bechyně ANO ANO \n", "1 Běloves ANO NE \n", "2 Bílina ANO NE \n", "3 Bludov ANO ANO \n", "4 Buchlovice NE ANO \n", "5 Dubí ANO ANO \n", "6 Františkovy Lázně ANO ANO \n", "7 Frymburk NE NE \n", "8 Hodonín – Josefov ANO ANO \n", "9 Jáchymov ANO ANO \n", "10 Janské Lázně ANO ANO \n", "11 Jeseník ANO ANO \n", "12 Karlova Studánka ANO ANO \n", "13 Karlovy Vary ANO ANO \n", "14 Karviná – Darkov ANO ANO \n", "15 Klášterec nad Ohří NE ANO \n", "16 Konstantinovy Lázně ANO ANO \n", "17 Kostelec u Zlína ANO ANO \n", "18 Lázně Bělohrad ANO ANO \n", "19 Lázně Bohdaneč ANO ANO \n", "20 Lázně Kundratice ANO ANO \n", "21 Lázně Kynžvart ANO ANO \n", "22 Lázně Libverda ANO ANO \n", "23 Lednice ANO ANO \n", "24 Lipová-lázně ANO ANO \n", "25 Luhačovice ANO ANO \n", "26 Mariánské Lázně ANO ANO \n", "27 Mšené Lázně ANO ANO \n", "28 Klimkovice ANO ANO \n", "29 Ostrožská Nová Ves ANO ANO \n", "30 Poděbrady ANO ANO \n", "31 Slatinice ANO ANO \n", "32 Teplice nad Bečvou ANO ANO \n", "33 Teplice v Čechách ANO ANO \n", "34 Toušeň ANO ANO \n", "35 Třeboň ANO ANO \n", "36 Velichovky ANO ANO \n", "37 Velké Losiny ANO ANO \n", "38 Vráž ANO ANO \n", "39 Železnice NE NE \n", "\n", "0 Poznámka latitude longitude \n", "0 NaN 49.299550 14.470589 \n", "1 nefunkční lázeňské místo 50.420969 16.186414 \n", "2 nefunkční lázeňské místo 50.550885 13.778960 \n", "3 NaN 49.943340 16.923007 \n", "4 jsou vyhlášeny pouze přírodní léčebné lázně 49.087699 17.334893 \n", "5 NaN 50.671791 13.796859 \n", "6 NaN 50.125069 12.347309 \n", "7 jsou vyhlášeny pouze přírodní léčebné lázně 48.670570 14.148734 \n", "8 NaN 48.839447 17.009394 \n", "9 NaN 50.366989 12.920475 \n", "10 NaN 50.632198 15.778962 \n", "11 NaN 50.277482 17.148386 \n", "12 NaN 50.073762 17.307615 \n", "13 NaN 50.231885 12.857833 \n", "14 NaN 49.844574 18.543278 \n", "15 NaN 50.387172 13.184552 \n", "16 NaN 49.880968 12.981676 \n", "17 NaN 49.262270 17.703135 \n", "18 NaN 50.433176 15.581435 \n", "19 NaN 50.074665 15.677325 \n", "20 NaN 50.697557 14.911097 \n", "21 NaN 50.008796 12.625262 \n", "22 NaN 50.890892 15.200040 \n", "23 NaN 48.798674 16.801194 \n", "24 NaN 50.226797 17.134974 \n", "25 NaN 49.098693 17.753463 \n", "26 NaN 49.958103 12.700273 \n", "27 NaN 50.360780 14.110850 \n", "28 NaN 49.787807 18.128487 \n", "29 NaN 49.003950 17.436496 \n", "30 NaN 50.147292 15.120567 \n", "31 NaN 49.561745 17.100577 \n", "32 NaN 49.528474 17.739646 \n", "33 NaN 50.646504 13.829472 \n", "34 NaN 50.169060 14.716760 \n", "35 NaN 49.007265 14.762234 \n", "36 NaN 50.354898 15.838102 \n", "37 NaN 50.040626 17.048241 \n", "38 NaN 49.384626 14.128398 \n", "39 lázeňské místo zrušeno 50.473221 15.383594 " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_clean" ] }, { "cell_type": "markdown", "id": "2765adaf", "metadata": {}, "source": [ "## Jednoduchá mapa pomocí Folium" ] }, { "cell_type": "code", "execution_count": 7, "id": "af47b904", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# pro interaktivní mapy\n", "import folium\n", "\n", "# inicializace mapy\n", "\n", "# výpočet středu: průměr všech souřadnic\n", "center_lat = df_clean[\"latitude\"].mean()\n", "center_lon = df_clean[\"longitude\"].mean()\n", "\n", "# vytvoření interaktivní mapy\n", "m = folium.Map(location=[center_lat, center_lon], zoom_start=7, tiles=\"OpenStreetMap\")\n", "\n", "for idx, row in df_clean.iterrows():\n", " # přidání kruhových značek\n", " folium.CircleMarker(\n", " location=[row[\"latitude\"], row[\"longitude\"]],\n", " tooltip=str(row[\"Lokalita\"]),\n", " ).add_to(m)\n", "m" ] }, { "cell_type": "markdown", "id": "1d39412c", "metadata": {}, "source": [ "## Přidání odkazů na Wikipedii a odkazů na náhledové obrázky z Wikipedie" ] }, { "cell_type": "code", "execution_count": 8, "id": "992f9da7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Získávám odkazy na obrázky z Wikipedie...\n", "============================================================\n", "[1/40] ✓ Bechyně\n", "[2/40] ✓ Běloves\n", "[3/40] ✓ Bílina_(město)\n", "[4/40] ✓ Bludov_(okres_Šumperk)\n", "[5/40] ✓ Buchlovice\n", "[6/40] ✓ Dubí\n", "[7/40] ✓ Františkovy Lázně\n", "[8/40] ✓ Frymburk\n", "[9/40] ✓ Josefov_(okres_Hodonín)\n", "[10/40] ✓ Jáchymov\n", "[11/40] ✓ Janské Lázně\n", "[12/40] ✓ Jeseník\n", "[13/40] ✓ Karlova Studánka\n", "[14/40] ✓ Karlovy Vary\n", "[15/40] ✓ Lázně_Darkov\n", "[16/40] ✓ Klášterec nad Ohří\n", "[17/40] ✓ Konstantinovy Lázně\n", "[18/40] ✓ Kostelec_(Zlín)\n", "[19/40] ✓ Lázně Bělohrad\n", "[20/40] ✓ Lázně Bohdaneč\n", "[21/40] ✓ Lázně Kundratice\n", "[22/40] ✓ Lázně Kynžvart\n", "[23/40] ✓ Lázně Libverda\n", "[24/40] ✓ Lednice_(okres_Břeclav)\n", "[25/40] ✓ Lipová-lázně\n", "[26/40] ✓ Luhačovice\n", "[27/40] ✓ Mariánské Lázně\n", "[28/40] ✓ Mšené-lázně\n", "[29/40] ✓ Klimkovice\n", "[30/40] ✓ Ostrožská Nová Ves\n", "[31/40] ✓ Poděbrady\n", "[32/40] ✓ Slatinice\n", "[33/40] ✓ Teplice nad Bečvou\n", "[34/40] ✓ Teplice\n", "[35/40] ✓ Lázně_Toušeň\n", "[36/40] ✓ Třeboň\n", "[37/40] ✓ Velichovky\n", "[38/40] ✓ Velké Losiny\n", "[39/40] ✓ Vráž (okres Písek)\n", "[40/40] ✓ Železnice (okres Jičín)\n" ] } ], "source": [ "# knihovna pro práci s časem (níže v kódu máme sekundovou pauzu)\n", "import time\n", "\n", "# úprava názvů lokalit kvůli nalezení správného hesla ve Wikipedii\n", "# řeší zejm. nejednoznačnosti (více lokalit se stejným názvem)\n", "name_corrections = {\n", " \"Bílina\": \"Bílina_(město)\",\n", " \"Bludov\": \"Bludov_(okres_Šumperk)\",\n", " \"Hodonín – Josefov\": \"Josefov_(okres_Hodonín)\",\n", " \"Karviná – Darkov\": \"Lázně_Darkov\",\n", " \"Kostelec u Zlína\": \"Kostelec_(Zlín)\",\n", " \"Lednice\": \"Lednice_(okres_Břeclav)\",\n", " \"Mšené Lázně\": \"Mšené-lázně\",\n", " \"Teplice v Čechách\": \"Teplice\",\n", " \"Toušeň\": \"Lázně_Toušeň\",\n", " \"Vráž\": \"Vráž (okres Písek)\",\n", " \"Železnice\": \"Železnice (okres Jičín)\",\n", "}\n", "\n", "# získáme sloupec s názvem lokality pro Wikipedii (většina názvů zůstane stejná)\n", "df_clean[\"Lokalita_Wiki\"] = df_clean[\"Lokalita\"].replace(name_corrections)\n", "\n", "# přidání sloupce s odkazem na Wikipedii\n", "df_clean[\"wiki\"] = df_clean[\"Lokalita_Wiki\"].apply(\n", " lambda x: f\"https://cs.wikipedia.org/wiki/{x}\"\n", ")\n", "\n", "# získání odkazu na náhledový obrázek (z Wikipedia API)\n", "\n", "\n", "def get_thumbnail_link(place_name):\n", " # Wikipedia API: oficiální rozhraní\n", " api_url = \"https://cs.wikipedia.org/w/api.php\"\n", " # vyhledávací parametry: obrázek stránky na základě jejíhio titulu, velikost 300px\n", " params = {\n", " \"action\": \"query\",\n", " \"titles\": place_name,\n", " \"prop\": \"pageimages\",\n", " \"format\": \"json\",\n", " \"pithumbsize\": 300,\n", " }\n", "\n", " # Wikipedie vyžaduje User-Agent\n", " headers = {\n", " \"User-Agent\": \"DigitalHumanitiesProject/1.0 (Educational purposes; Python/requests)\"\n", " }\n", "\n", " # parsování kódu ve formátu JSON získaného na základě požadavku z API\n", " # kontrola existence, ošetření selhání\n", "\n", " try:\n", " response = requests.get(api_url, params=params, headers=headers, timeout=10)\n", " response.raise_for_status()\n", "\n", " data = response.json()\n", "\n", " pages = data.get(\"query\", {}).get(\"pages\", {})\n", " if pages:\n", " page_id = list(pages.keys())[0]\n", " if page_id != \"-1\":\n", " page_data = pages[page_id]\n", " if \"thumbnail\" in page_data:\n", " thumbnail_url = page_data[\"thumbnail\"].get(\"source\")\n", " if thumbnail_url:\n", " print(f\"✓ {place_name}\")\n", " return thumbnail_url\n", "\n", " print(f\"✗ {place_name} (bez obrázku)\")\n", " return None\n", "\n", " except requests.exceptions.HTTPError as e:\n", " print(f\"✗ {place_name}: HTTP {e.response.status_code}\")\n", " return None\n", " except Exception as e:\n", " print(f\"✗ {place_name}: {type(e).__name__}\")\n", " return None\n", "\n", "\n", "# vlastní získání odkazů na obrázky\n", "print(\"Získávám odkazy na obrázky z Wikipedie...\")\n", "print(\"=\" * 60)\n", "\n", "thumbnail_links = []\n", "for idx, place_name in enumerate(df_clean[\"Lokalita_Wiki\"], 1):\n", " print(f\"[{idx}/{len(df_clean)}] \", end=\"\")\n", " thumbnail = get_thumbnail_link(place_name)\n", " thumbnail_links.append(thumbnail)\n", " # pauza (ochrana před zablokováním)\n", " time.sleep(1)\n", "\n", "# přidání obrázků do DataFrame\n", "df_clean[\"thumbnail_link\"] = pd.Series(thumbnail_links, dtype=\"object\")" ] }, { "cell_type": "markdown", "id": "9450a79e", "metadata": {}, "source": [ "## Zobrazení kompletní tabulky (původní data + geolokace + Wikipedie + obrázky)" ] }, { "cell_type": "code", "execution_count": 9, "id": "d49e275d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
LokalitaStatut lázeňského místaPoskytování LLRPPoznámkalatitudelongitudeLokalita_Wikiwikithumbnail_link
0BechyněANOANONaN49.29955014.470589Bechyněhttps://cs.wikipedia.org/wiki/Bechyněhttps://upload.wikimedia.org/wikipedia/commons...
1BělovesANONEnefunkční lázeňské místo50.42096916.186414Běloveshttps://cs.wikipedia.org/wiki/Běloveshttps://upload.wikimedia.org/wikipedia/commons...
2BílinaANONEnefunkční lázeňské místo50.55088513.778960Bílina_(město)https://cs.wikipedia.org/wiki/Bílina_(město)https://upload.wikimedia.org/wikipedia/commons...
3BludovANOANONaN49.94334016.923007Bludov_(okres_Šumperk)https://cs.wikipedia.org/wiki/Bludov_(okres_Šu...https://upload.wikimedia.org/wikipedia/commons...
4BuchloviceNEANOjsou vyhlášeny pouze přírodní léčebné lázně49.08769917.334893Buchlovicehttps://cs.wikipedia.org/wiki/Buchlovicehttps://upload.wikimedia.org/wikipedia/commons...
5DubíANOANONaN50.67179113.796859Dubíhttps://cs.wikipedia.org/wiki/Dubíhttps://upload.wikimedia.org/wikipedia/commons...
6Františkovy LázněANOANONaN50.12506912.347309Františkovy Lázněhttps://cs.wikipedia.org/wiki/Františkovy Lázněhttps://upload.wikimedia.org/wikipedia/commons...
7FrymburkNENEjsou vyhlášeny pouze přírodní léčebné lázně48.67057014.148734Frymburkhttps://cs.wikipedia.org/wiki/Frymburkhttps://upload.wikimedia.org/wikipedia/commons...
8Hodonín – JosefovANOANONaN48.83944717.009394Josefov_(okres_Hodonín)https://cs.wikipedia.org/wiki/Josefov_(okres_H...https://upload.wikimedia.org/wikipedia/commons...
9JáchymovANOANONaN50.36698912.920475Jáchymovhttps://cs.wikipedia.org/wiki/Jáchymovhttps://upload.wikimedia.org/wikipedia/commons...
10Janské LázněANOANONaN50.63219815.778962Janské Lázněhttps://cs.wikipedia.org/wiki/Janské Lázněhttps://upload.wikimedia.org/wikipedia/commons...
11JeseníkANOANONaN50.27748217.148386Jeseníkhttps://cs.wikipedia.org/wiki/Jeseníkhttps://upload.wikimedia.org/wikipedia/commons...
12Karlova StudánkaANOANONaN50.07376217.307615Karlova Studánkahttps://cs.wikipedia.org/wiki/Karlova Studánkahttps://upload.wikimedia.org/wikipedia/commons...
13Karlovy VaryANOANONaN50.23188512.857833Karlovy Varyhttps://cs.wikipedia.org/wiki/Karlovy Varyhttps://upload.wikimedia.org/wikipedia/commons...
14Karviná – DarkovANOANONaN49.84457418.543278Lázně_Darkovhttps://cs.wikipedia.org/wiki/Lázně_Darkovhttps://upload.wikimedia.org/wikipedia/commons...
15Klášterec nad OhříNEANONaN50.38717213.184552Klášterec nad Ohříhttps://cs.wikipedia.org/wiki/Klášterec nad Ohříhttps://upload.wikimedia.org/wikipedia/commons...
16Konstantinovy LázněANOANONaN49.88096812.981676Konstantinovy Lázněhttps://cs.wikipedia.org/wiki/Konstantinovy Lázněhttps://upload.wikimedia.org/wikipedia/commons...
17Kostelec u ZlínaANOANONaN49.26227017.703135Kostelec_(Zlín)https://cs.wikipedia.org/wiki/Kostelec_(Zlín)https://upload.wikimedia.org/wikipedia/commons...
18Lázně BělohradANOANONaN50.43317615.581435Lázně Bělohradhttps://cs.wikipedia.org/wiki/Lázně Bělohradhttps://upload.wikimedia.org/wikipedia/commons...
19Lázně BohdanečANOANONaN50.07466515.677325Lázně Bohdanečhttps://cs.wikipedia.org/wiki/Lázně Bohdanečhttps://upload.wikimedia.org/wikipedia/commons...
20Lázně KundraticeANOANONaN50.69755714.911097Lázně Kundraticehttps://cs.wikipedia.org/wiki/Lázně Kundraticehttps://upload.wikimedia.org/wikipedia/commons...
21Lázně KynžvartANOANONaN50.00879612.625262Lázně Kynžvarthttps://cs.wikipedia.org/wiki/Lázně Kynžvarthttps://upload.wikimedia.org/wikipedia/commons...
22Lázně LibverdaANOANONaN50.89089215.200040Lázně Libverdahttps://cs.wikipedia.org/wiki/Lázně Libverdahttps://upload.wikimedia.org/wikipedia/commons...
23LedniceANOANONaN48.79867416.801194Lednice_(okres_Břeclav)https://cs.wikipedia.org/wiki/Lednice_(okres_B...https://upload.wikimedia.org/wikipedia/commons...
24Lipová-lázněANOANONaN50.22679717.134974Lipová-lázněhttps://cs.wikipedia.org/wiki/Lipová-lázněhttps://upload.wikimedia.org/wikipedia/commons...
25LuhačoviceANOANONaN49.09869317.753463Luhačovicehttps://cs.wikipedia.org/wiki/Luhačovicehttps://upload.wikimedia.org/wikipedia/commons...
26Mariánské LázněANOANONaN49.95810312.700273Mariánské Lázněhttps://cs.wikipedia.org/wiki/Mariánské Lázněhttps://upload.wikimedia.org/wikipedia/commons...
27Mšené LázněANOANONaN50.36078014.110850Mšené-lázněhttps://cs.wikipedia.org/wiki/Mšené-lázněhttps://upload.wikimedia.org/wikipedia/commons...
28KlimkoviceANOANONaN49.78780718.128487Klimkovicehttps://cs.wikipedia.org/wiki/Klimkovicehttps://upload.wikimedia.org/wikipedia/commons...
29Ostrožská Nová VesANOANONaN49.00395017.436496Ostrožská Nová Veshttps://cs.wikipedia.org/wiki/Ostrožská Nová Veshttps://upload.wikimedia.org/wikipedia/commons...
30PoděbradyANOANONaN50.14729215.120567Poděbradyhttps://cs.wikipedia.org/wiki/Poděbradyhttps://upload.wikimedia.org/wikipedia/commons...
31SlatiniceANOANONaN49.56174517.100577Slatinicehttps://cs.wikipedia.org/wiki/Slatinicehttps://upload.wikimedia.org/wikipedia/commons...
32Teplice nad BečvouANOANONaN49.52847417.739646Teplice nad Bečvouhttps://cs.wikipedia.org/wiki/Teplice nad Bečvouhttps://upload.wikimedia.org/wikipedia/commons...
33Teplice v ČecháchANOANONaN50.64650413.829472Teplicehttps://cs.wikipedia.org/wiki/Teplicehttps://upload.wikimedia.org/wikipedia/commons...
34ToušeňANOANONaN50.16906014.716760Lázně_Toušeňhttps://cs.wikipedia.org/wiki/Lázně_Toušeňhttps://upload.wikimedia.org/wikipedia/commons...
35TřeboňANOANONaN49.00726514.762234Třeboňhttps://cs.wikipedia.org/wiki/Třeboňhttps://upload.wikimedia.org/wikipedia/commons...
36VelichovkyANOANONaN50.35489815.838102Velichovkyhttps://cs.wikipedia.org/wiki/Velichovkyhttps://upload.wikimedia.org/wikipedia/commons...
37Velké LosinyANOANONaN50.04062617.048241Velké Losinyhttps://cs.wikipedia.org/wiki/Velké Losinyhttps://upload.wikimedia.org/wikipedia/commons...
38VrážANOANONaN49.38462614.128398Vráž (okres Písek)https://cs.wikipedia.org/wiki/Vráž (okres Písek)https://upload.wikimedia.org/wikipedia/commons...
39ŽelezniceNENElázeňské místo zrušeno50.47322115.383594Železnice (okres Jičín)https://cs.wikipedia.org/wiki/Železnice (okres...https://upload.wikimedia.org/wikipedia/commons...
\n", "
" ], "text/plain": [ "0 Lokalita Statut lázeňského místa Poskytování LLRP \\\n", "0 Bechyně ANO ANO \n", "1 Běloves ANO NE \n", "2 Bílina ANO NE \n", "3 Bludov ANO ANO \n", "4 Buchlovice NE ANO \n", "5 Dubí ANO ANO \n", "6 Františkovy Lázně ANO ANO \n", "7 Frymburk NE NE \n", "8 Hodonín – Josefov ANO ANO \n", "9 Jáchymov ANO ANO \n", "10 Janské Lázně ANO ANO \n", "11 Jeseník ANO ANO \n", "12 Karlova Studánka ANO ANO \n", "13 Karlovy Vary ANO ANO \n", "14 Karviná – Darkov ANO ANO \n", "15 Klášterec nad Ohří NE ANO \n", "16 Konstantinovy Lázně ANO ANO \n", "17 Kostelec u Zlína ANO ANO \n", "18 Lázně Bělohrad ANO ANO \n", "19 Lázně Bohdaneč ANO ANO \n", "20 Lázně Kundratice ANO ANO \n", "21 Lázně Kynžvart ANO ANO \n", "22 Lázně Libverda ANO ANO \n", "23 Lednice ANO ANO \n", "24 Lipová-lázně ANO ANO \n", "25 Luhačovice ANO ANO \n", "26 Mariánské Lázně ANO ANO \n", "27 Mšené Lázně ANO ANO \n", "28 Klimkovice ANO ANO \n", "29 Ostrožská Nová Ves ANO ANO \n", "30 Poděbrady ANO ANO \n", "31 Slatinice ANO ANO \n", "32 Teplice nad Bečvou ANO ANO \n", "33 Teplice v Čechách ANO ANO \n", "34 Toušeň ANO ANO \n", "35 Třeboň ANO ANO \n", "36 Velichovky ANO ANO \n", "37 Velké Losiny ANO ANO \n", "38 Vráž ANO ANO \n", "39 Železnice NE NE \n", "\n", "0 Poznámka latitude longitude \\\n", "0 NaN 49.299550 14.470589 \n", "1 nefunkční lázeňské místo 50.420969 16.186414 \n", "2 nefunkční lázeňské místo 50.550885 13.778960 \n", "3 NaN 49.943340 16.923007 \n", "4 jsou vyhlášeny pouze přírodní léčebné lázně 49.087699 17.334893 \n", "5 NaN 50.671791 13.796859 \n", "6 NaN 50.125069 12.347309 \n", "7 jsou vyhlášeny pouze přírodní léčebné lázně 48.670570 14.148734 \n", "8 NaN 48.839447 17.009394 \n", "9 NaN 50.366989 12.920475 \n", "10 NaN 50.632198 15.778962 \n", "11 NaN 50.277482 17.148386 \n", "12 NaN 50.073762 17.307615 \n", "13 NaN 50.231885 12.857833 \n", "14 NaN 49.844574 18.543278 \n", "15 NaN 50.387172 13.184552 \n", "16 NaN 49.880968 12.981676 \n", "17 NaN 49.262270 17.703135 \n", "18 NaN 50.433176 15.581435 \n", "19 NaN 50.074665 15.677325 \n", "20 NaN 50.697557 14.911097 \n", "21 NaN 50.008796 12.625262 \n", "22 NaN 50.890892 15.200040 \n", "23 NaN 48.798674 16.801194 \n", "24 NaN 50.226797 17.134974 \n", "25 NaN 49.098693 17.753463 \n", "26 NaN 49.958103 12.700273 \n", "27 NaN 50.360780 14.110850 \n", "28 NaN 49.787807 18.128487 \n", "29 NaN 49.003950 17.436496 \n", "30 NaN 50.147292 15.120567 \n", "31 NaN 49.561745 17.100577 \n", "32 NaN 49.528474 17.739646 \n", "33 NaN 50.646504 13.829472 \n", "34 NaN 50.169060 14.716760 \n", "35 NaN 49.007265 14.762234 \n", "36 NaN 50.354898 15.838102 \n", "37 NaN 50.040626 17.048241 \n", "38 NaN 49.384626 14.128398 \n", "39 lázeňské místo zrušeno 50.473221 15.383594 \n", "\n", "0 Lokalita_Wiki \\\n", "0 Bechyně \n", "1 Běloves \n", "2 Bílina_(město) \n", "3 Bludov_(okres_Šumperk) \n", "4 Buchlovice \n", "5 Dubí \n", "6 Františkovy Lázně \n", "7 Frymburk \n", "8 Josefov_(okres_Hodonín) \n", "9 Jáchymov \n", "10 Janské Lázně \n", "11 Jeseník \n", "12 Karlova Studánka \n", "13 Karlovy Vary \n", "14 Lázně_Darkov \n", "15 Klášterec nad Ohří \n", "16 Konstantinovy Lázně \n", "17 Kostelec_(Zlín) \n", "18 Lázně Bělohrad \n", "19 Lázně Bohdaneč \n", "20 Lázně Kundratice \n", "21 Lázně Kynžvart \n", "22 Lázně Libverda \n", "23 Lednice_(okres_Břeclav) \n", "24 Lipová-lázně \n", "25 Luhačovice \n", "26 Mariánské Lázně \n", "27 Mšené-lázně \n", "28 Klimkovice \n", "29 Ostrožská Nová Ves \n", "30 Poděbrady \n", "31 Slatinice \n", "32 Teplice nad Bečvou \n", "33 Teplice \n", "34 Lázně_Toušeň \n", "35 Třeboň \n", "36 Velichovky \n", "37 Velké Losiny \n", "38 Vráž (okres Písek) \n", "39 Železnice (okres Jičín) \n", "\n", "0 wiki \\\n", "0 https://cs.wikipedia.org/wiki/Bechyně \n", "1 https://cs.wikipedia.org/wiki/Běloves \n", "2 https://cs.wikipedia.org/wiki/Bílina_(město) \n", "3 https://cs.wikipedia.org/wiki/Bludov_(okres_Šu... \n", "4 https://cs.wikipedia.org/wiki/Buchlovice \n", "5 https://cs.wikipedia.org/wiki/Dubí \n", "6 https://cs.wikipedia.org/wiki/Františkovy Lázně \n", "7 https://cs.wikipedia.org/wiki/Frymburk \n", "8 https://cs.wikipedia.org/wiki/Josefov_(okres_H... \n", "9 https://cs.wikipedia.org/wiki/Jáchymov \n", "10 https://cs.wikipedia.org/wiki/Janské Lázně \n", "11 https://cs.wikipedia.org/wiki/Jeseník \n", "12 https://cs.wikipedia.org/wiki/Karlova Studánka \n", "13 https://cs.wikipedia.org/wiki/Karlovy Vary \n", "14 https://cs.wikipedia.org/wiki/Lázně_Darkov \n", "15 https://cs.wikipedia.org/wiki/Klášterec nad Ohří \n", "16 https://cs.wikipedia.org/wiki/Konstantinovy Lázně \n", "17 https://cs.wikipedia.org/wiki/Kostelec_(Zlín) \n", "18 https://cs.wikipedia.org/wiki/Lázně Bělohrad \n", "19 https://cs.wikipedia.org/wiki/Lázně Bohdaneč \n", "20 https://cs.wikipedia.org/wiki/Lázně Kundratice \n", "21 https://cs.wikipedia.org/wiki/Lázně Kynžvart \n", "22 https://cs.wikipedia.org/wiki/Lázně Libverda \n", "23 https://cs.wikipedia.org/wiki/Lednice_(okres_B... \n", "24 https://cs.wikipedia.org/wiki/Lipová-lázně \n", "25 https://cs.wikipedia.org/wiki/Luhačovice \n", "26 https://cs.wikipedia.org/wiki/Mariánské Lázně \n", "27 https://cs.wikipedia.org/wiki/Mšené-lázně \n", "28 https://cs.wikipedia.org/wiki/Klimkovice \n", "29 https://cs.wikipedia.org/wiki/Ostrožská Nová Ves \n", "30 https://cs.wikipedia.org/wiki/Poděbrady \n", "31 https://cs.wikipedia.org/wiki/Slatinice \n", "32 https://cs.wikipedia.org/wiki/Teplice nad Bečvou \n", "33 https://cs.wikipedia.org/wiki/Teplice \n", "34 https://cs.wikipedia.org/wiki/Lázně_Toušeň \n", "35 https://cs.wikipedia.org/wiki/Třeboň \n", "36 https://cs.wikipedia.org/wiki/Velichovky \n", "37 https://cs.wikipedia.org/wiki/Velké Losiny \n", "38 https://cs.wikipedia.org/wiki/Vráž (okres Písek) \n", "39 https://cs.wikipedia.org/wiki/Železnice (okres... \n", "\n", "0 thumbnail_link \n", "0 https://upload.wikimedia.org/wikipedia/commons... \n", "1 https://upload.wikimedia.org/wikipedia/commons... \n", "2 https://upload.wikimedia.org/wikipedia/commons... \n", "3 https://upload.wikimedia.org/wikipedia/commons... \n", "4 https://upload.wikimedia.org/wikipedia/commons... \n", "5 https://upload.wikimedia.org/wikipedia/commons... \n", "6 https://upload.wikimedia.org/wikipedia/commons... \n", "7 https://upload.wikimedia.org/wikipedia/commons... \n", "8 https://upload.wikimedia.org/wikipedia/commons... \n", "9 https://upload.wikimedia.org/wikipedia/commons... \n", "10 https://upload.wikimedia.org/wikipedia/commons... \n", "11 https://upload.wikimedia.org/wikipedia/commons... \n", "12 https://upload.wikimedia.org/wikipedia/commons... \n", "13 https://upload.wikimedia.org/wikipedia/commons... \n", "14 https://upload.wikimedia.org/wikipedia/commons... \n", "15 https://upload.wikimedia.org/wikipedia/commons... \n", "16 https://upload.wikimedia.org/wikipedia/commons... \n", "17 https://upload.wikimedia.org/wikipedia/commons... \n", "18 https://upload.wikimedia.org/wikipedia/commons... \n", "19 https://upload.wikimedia.org/wikipedia/commons... \n", "20 https://upload.wikimedia.org/wikipedia/commons... \n", "21 https://upload.wikimedia.org/wikipedia/commons... \n", "22 https://upload.wikimedia.org/wikipedia/commons... \n", "23 https://upload.wikimedia.org/wikipedia/commons... \n", "24 https://upload.wikimedia.org/wikipedia/commons... \n", "25 https://upload.wikimedia.org/wikipedia/commons... \n", "26 https://upload.wikimedia.org/wikipedia/commons... \n", "27 https://upload.wikimedia.org/wikipedia/commons... \n", "28 https://upload.wikimedia.org/wikipedia/commons... \n", "29 https://upload.wikimedia.org/wikipedia/commons... \n", "30 https://upload.wikimedia.org/wikipedia/commons... \n", "31 https://upload.wikimedia.org/wikipedia/commons... \n", "32 https://upload.wikimedia.org/wikipedia/commons... \n", "33 https://upload.wikimedia.org/wikipedia/commons... \n", "34 https://upload.wikimedia.org/wikipedia/commons... \n", "35 https://upload.wikimedia.org/wikipedia/commons... \n", "36 https://upload.wikimedia.org/wikipedia/commons... \n", "37 https://upload.wikimedia.org/wikipedia/commons... \n", "38 https://upload.wikimedia.org/wikipedia/commons... \n", "39 https://upload.wikimedia.org/wikipedia/commons... " ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_clean" ] }, { "cell_type": "markdown", "id": "6a398fd6", "metadata": {}, "source": [ "## Interaktivní mapa pomocí Folium" ] }, { "cell_type": "code", "execution_count": 10, "id": "7f40fcc7", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Interaktivní mapa uložena jako 'mapa_lazne.html'\n", "Data uložena do 'lazenska_mista_cr.xlsx'\n" ] } ], "source": [ "# pro interaktivní mapy\n", "import folium\n", "\n", "# inicializace mapy\n", "\n", "# výpočet středu: průměr všech souřadnic\n", "center_lat = df_clean[\"latitude\"].mean()\n", "center_lon = df_clean[\"longitude\"].mean()\n", "\n", "# vytvoření interaktivní mapy\n", "m = folium.Map(location=[center_lat, center_lon], zoom_start=7, tiles=\"OpenStreetMap\")\n", "\n", "# přidání další mapové vrstvy\n", "folium.TileLayer(\"OpenTopoMap\", name=\"Topo\").add_to(m)\n", "\n", "# přidání značek s vyskakovacími okny\n", "\n", "for idx, row in df_clean.iterrows():\n", " # HTML pro vyskakovací okno\n", " popup_html = f\"\"\"\n", "
\n", "

{row[\"Lokalita\"]}

\n", " \"\"\"\n", " # podmíněné zobrazení obrázku, f-string: dynamické vložení dat\n", " if pd.notna(row[\"thumbnail_link\"]):\n", " popup_html += f'
'\n", "\n", " popup_html += f\"\"\"\n", " Wikipedia\n", "
\n", " \"\"\"\n", "\n", " # přidání značek\n", " # Marker: značka na mapě se souřadnicemi\n", " # popup: okno po kliknutí\n", " # tooltip: text při najetí myší\n", " # icon: ikona lázní (fontawesome)\n", " folium.Marker(\n", " location=[row[\"latitude\"], row[\"longitude\"]],\n", " popup=folium.Popup(popup_html, max_width=300),\n", " tooltip=row[\"Lokalita\"],\n", " icon=folium.Icon(color=\"cadetblue\", icon=\"spa\", prefix=\"fa\"),\n", " ).add_to(m)\n", "\n", "# uživatel může přepínat mezi vrstvami\n", "folium.LayerControl().add_to(m)\n", "\n", "# uložení mapy a dat\n", "m.save(\"mapa_lazne.html\")\n", "print(\"Interaktivní mapa uložena jako 'mapa_lazne.html'\")\n", "\n", "# export do Excelu: všechna data včetně souřadnic\n", "df_clean.to_excel(\"lazenska_mista_cr.xlsx\")\n", "print(\"Data uložena do 'lazenska_mista_cr.xlsx'\")" ] }, { "cell_type": "markdown", "id": "77c073bd", "metadata": {}, "source": [ "## Interaktivní mapa s legislativním rozlišením lázeňských míst podle MZČR" ] }, { "cell_type": "code", "execution_count": 11, "id": "33f727eb", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Kategorizuji lázeňská místa včetně zrušených lokalit...\n", "\n", "============================================================\n", "LEGISLATIVNÍ STAV LÁZEŇSKÝCH MÍST (MZČR):\n", "============================================================\n", " 🟢 Funkční lázně (plný provoz): 34\n", " 🔴 Nefunkční (ochranné pásmo): 2\n", " 🟠 Přírodní léčebné lázně: 2\n", " ⚪ Ostatní zařízení: 1\n", " ⚫ Zrušené lázeňské místo: 1\n", "============================================================\n", "\n", "\n", "✅ Mapa s legislativním rozlišením uložena: 'mapa_lazne_legislativni_stav.html'\n", "✅ Data uložena: 'lazenska_mista_s_legislativou.xlsx'\n" ] }, { "data": { "text/html": [ "
Make this Notebook Trusted to load map: File -> Trust Notebook
" ], "text/plain": [ "" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import folium\n", "\n", "\n", "def categorize_spa_location(row):\n", " \"\"\"\n", " Kategorizace podle skutečné legislativní úpravy MZČR:\n", " - Funkční: ANO/ANO\n", " - Nefunkční: ANO/NE (status zachován, ale bez péče)\n", " - Zrušené: v poznámce \"zrušeno\" (status odebrán)\n", " - Přírodní léčebné lázně: specifický režim\n", " \"\"\"\n", " statut = str(row.get(\"Statut lázeňského místa\", \"\")).strip().upper()\n", " llrp = str(row.get(\"Poskytování LLRP\", \"\")).strip().upper()\n", " poznamka = str(row.get(\"Poznámka\", \"\")).lower()\n", "\n", " # 0. ZRUŠENÁ LÁZEŇSKÁ MÍSTA (priorita - definitivní stav)\n", " if \"zrušeno\" in poznamka or \"zruseno\" in poznamka:\n", " return {\n", " \"kategorie\": \"Zrušené lázeňské místo\",\n", " \"barva\": \"black\",\n", " \"ikonka\": \"trash-alt\",\n", " \"popis\": \"Status lázeňského místa byl zrušen\",\n", " }\n", "\n", " # 1. Plně funkční lázně\n", " elif statut == \"ANO\" and llrp == \"ANO\":\n", " return {\n", " \"kategorie\": \"Funkční lázně (plný provoz)\",\n", " \"barva\": \"darkgreen\",\n", " \"ikonka\": \"plus-circle\",\n", " \"popis\": \"Vyhlášené lázeňské místo s poskytováním LLRP\",\n", " }\n", "\n", " # 2. Nefunkční (status existuje, ale neposkytují péči)\n", " elif statut == \"ANO\" and llrp == \"NE\":\n", " return {\n", " \"kategorie\": \"Nefunkční (ochranné pásmo)\",\n", " \"barva\": \"red\",\n", " \"ikonka\": \"ban\",\n", " \"popis\": \"Lázeňské místo bez poskytování LLRP\",\n", " }\n", "\n", " # 3. Pouze přírodní léčebné lázně (PříLáz)\n", " elif (\n", " \"přírodní léčebné lázně\" in poznamka\n", " or \"prirodni lecne lazne\" in poznamka\n", " or \"přírodní léčebný zdroj\" in poznamka\n", " ):\n", " return {\n", " \"kategorie\": \"Přírodní léčebné lázně\",\n", " \"barva\": \"orange\",\n", " \"ikonka\": \"leaf\",\n", " \"popis\": \"Vyhlášeny pouze přírodní léčebné lázně\",\n", " }\n", "\n", " # 4. Ostatní\n", " else:\n", " return {\n", " \"kategorie\": \"Ostatní zařízení\",\n", " \"barva\": \"gray\",\n", " \"ikonka\": \"question-circle\",\n", " \"popis\": \"Bez statutu lázeňského místa\",\n", " }\n", "\n", "\n", "# Aplikace kategorizace\n", "print(\"Kategorizuji lázeňská místa včetně zrušených lokalit...\")\n", "df_clean[\"Kategorie_Info\"] = df_clean.apply(categorize_spa_location, axis=1)\n", "df_clean[\"Kategorie\"] = df_clean[\"Kategorie_Info\"].apply(lambda x: x[\"kategorie\"])\n", "df_clean[\"Barva\"] = df_clean[\"Kategorie_Info\"].apply(lambda x: x[\"barva\"])\n", "df_clean[\"Ikona\"] = df_clean[\"Kategorie_Info\"].apply(lambda x: x[\"ikonka\"])\n", "\n", "# Výpis statistiky s rozdělením\n", "print(f\"\\n{'=' * 60}\")\n", "print(\"LEGISLATIVNÍ STAV LÁZEŇSKÝCH MÍST (MZČR):\")\n", "print(f\"{'=' * 60}\")\n", "stats = df_clean[\"Kategorie\"].value_counts()\n", "for kategorie, pocet in stats.items():\n", " barva = df_clean[df_clean[\"Kategorie\"] == kategorie][\"Barva\"].iloc[0]\n", " symbol = (\n", " \"⚫\"\n", " if barva == \"black\"\n", " else \"🔴\"\n", " if barva == \"red\"\n", " else \"🟢\"\n", " if barva == \"darkgreen\"\n", " else \"🟠\"\n", " if barva == \"orange\"\n", " else \"⚪\"\n", " )\n", " print(f\" {symbol} {kategorie}: {pocet}\")\n", "print(f\"{'=' * 60}\\n\")\n", "\n", "# Inicializace mapy\n", "center_lat = df_clean[\"latitude\"].mean()\n", "center_lon = df_clean[\"longitude\"].mean()\n", "\n", "m = folium.Map(\n", " location=[center_lat, center_lon], zoom_start=7, tiles=\"CartoDB positron\"\n", ")\n", "\n", "folium.TileLayer(tiles=\"OpenStreetMap\", name=\"OpenStreetMap\", control=True).add_to(m)\n", "\n", "folium.TileLayer(\n", " tiles=\"https://server.arcgisonline.com/ArcGIS/rest/services/World_Imagery/MapServer/tile/{z}/{y}/{x}\",\n", " attr=\"Esri\",\n", " name=\"Satelitní\",\n", " overlay=False,\n", " control=True,\n", ").add_to(m)\n", "\n", "# Vytvoření FeatureGroup pro každou kategorii\n", "feature_groups = {}\n", "category_order = [\n", " \"Zrušené lázeňské místo\",\n", " \"Nefunkční (ochranné pásmo)\",\n", " \"Funkční lázně (plný provoz)\",\n", " \"Přírodní léčebné lázně\",\n", " \"Ostatní zařízení\",\n", "]\n", "\n", "# Ujistíme se, že všechny kategorie existují (i když jsou prázdné)\n", "for kategorie in category_order:\n", " if kategorie in df_clean[\"Kategorie\"].values:\n", " short_name = kategorie.replace(\" (plný provoz)\", \"\").replace(\n", " \" (ochr. pásmo)\", \"\"\n", " )\n", " emoji = (\n", " \"⚫\"\n", " if \"Zrušené\" in kategorie\n", " else \"🔴\"\n", " if \"Nefunkční\" in kategorie\n", " else \"🟢\"\n", " if \"Funkční\" in kategorie\n", " else \"🟠\"\n", " if \"Přírodní\" in kategorie\n", " else \"⚪\"\n", " )\n", " feature_groups[kategorie] = folium.FeatureGroup(name=f\"{emoji} {short_name}\")\n", "\n", "# Vytvoření markerů\n", "for idx, row in df_clean.iterrows():\n", " info = row[\"Kategorie_Info\"]\n", " kategorie = row[\"Kategorie\"]\n", "\n", " # Speciální zvýraznění pro zrušená místa\n", " extra_style = \"\"\n", " if \"Zrušené\" in kategorie:\n", " extra_style = \"text-decoration: line-through; opacity: 0.7;\"\n", "\n", " popup_html = f\"\"\"\n", "
\n", "

\n", " {row[\"Lokalita\"]}\n", " {'ZRUŠENO' if \"Zrušené\" in kategorie else \"\"}\n", "

\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Kategorie:\n", " {kategorie}\n", "
Statut LM:\n", " \n", " {row.get(\"Statut lázeňského místa\", \"N/A\")}\n", " \n", "
Poskytování LLRP:\n", " \n", " {row.get(\"Poskytování LLRP\", \"N/A\")}\n", " \n", "
\n", " \"\"\"\n", "\n", " # Poznámka s vizuálním zvýrazněním podle závažnosti\n", " if pd.notna(row.get(\"Poznámka\")) and str(row.get(\"Poznámka\")) != \"nan\":\n", " note_text = row[\"Poznámka\"]\n", "\n", " # Rozlišení barevného podbarvení poznámky\n", " if \"zrušeno\" in note_text.lower():\n", " note_bg = \"#f8d7da\" # červená\n", " note_border = \"#dc3545\"\n", " note_color = \"#721c24\"\n", " elif \"nefunkční\" in note_text.lower():\n", " note_bg = \"#fff3cd\" # žlutá\n", " note_border = \"#ffc107\"\n", " note_color = \"#856404\"\n", " else:\n", " note_bg = \"#d1ecf1\" # modrá (přírodní lázně)\n", " note_border = \"#17a2b8\"\n", " note_color = \"#0c5460\"\n", "\n", " popup_html += f\"\"\"\n", "
\n", " Poznámka: {note_text}\n", "
\n", " \"\"\"\n", "\n", " # Obrázek (pro zrušená místa menší průhlednost)\n", " opacity = \"0.5\" if \"Zrušené\" in kategorie else \"1.0\"\n", " if pd.notna(row.get(\"thumbnail_link\")):\n", " popup_html += f\"\"\"\n", "
\n", " \n", "
\n", " \"\"\"\n", "\n", " popup_html += f\"\"\"\n", "
\n", "
\n", " Souřadnice: {row[\"latitude\"]:.5f}N, {row[\"longitude\"]:.5f}E\n", "
\n", " \n", " 📖 {\"Historický článek\" if \"Zrušené\" in kategorie else \"Článek na Wikipedii\"}\n", " \n", "
\n", "
\n", " \"\"\"\n", "\n", " # Vytvoření markeru (pro zrušená místa menší průhlednost)\n", " marker = folium.Marker(\n", " location=[row[\"latitude\"], row[\"longitude\"]],\n", " popup=folium.Popup(popup_html, max_width=350),\n", " tooltip=f\"{'[ZRUŠENO] ' if 'Zrušené' in kategorie else ''}{row['Lokalita']} ({kategorie})\",\n", " icon=folium.Icon(color=info[\"barva\"], icon=info[\"ikonka\"], prefix=\"fa\"),\n", " )\n", "\n", " marker.add_to(feature_groups[kategorie])\n", "\n", "# Přidání skupin do mapy (v definovaném pořadí)\n", "for kat in category_order:\n", " if kat in feature_groups:\n", " feature_groups[kat].add_to(m)\n", "\n", "# Legenda se zrušenými místy\n", "legend_html = \"\"\"\n", "
\n", "

\n", " 🏥 Legislativní stav lázeňských míst (MZČR)\n", "

\n", " \n", "
\n", " \n", " Funkční lázně (ANO/ANO)
\n", " Plný provoz\n", "
\n", " \n", "
\n", " \n", " Přírodní léčebné lázně
\n", " Pouze PříLáz, bez statutu LM\n", "
\n", " \n", "
\n", " \n", " Nefunkční (ANO/NE)
\n", " Zachováno ochranné pásmo\n", "
\n", " \n", "
\n", " \n", " Zrušené lázeňské místo
\n", " Status LM byl odebrán (např. Železnice)\n", "
\n", " \n", "
\n", " \n", " Ostatní zařízení
\n", " Bez statutu\n", "
\n", " \n", "
\n", " Legenda: LM = lázeňské místo, LLRP = lázeňská léčebně rehabilitační péče
\n", " Zdroj: Seznam lázeňských míst MZČR (aktualizováno)\n", "
\n", "
\n", "\"\"\"\n", "\n", "m.get_root().add_child(folium.Element(legend_html))\n", "\n", "folium.LayerControl(collapsed=False, position=\"topright\").add_to(m)\n", "\n", "# Uložení\n", "output_html = \"mapa_lazne_legislativni_stav.html\"\n", "output_excel = \"lazenska_mista_s_legislativou.xlsx\"\n", "\n", "m.save(output_html)\n", "print(f\"\\n✅ Mapa s legislativním rozlišením uložena: '{output_html}'\")\n", "\n", "# Export s kompletními informacemi\n", "export_cols = [\n", " \"Lokalita\",\n", " \"Statut lázeňského místa\",\n", " \"Poskytování LLRP\",\n", " \"Poznámka\",\n", " \"Kategorie\",\n", " \"latitude\",\n", " \"longitude\",\n", " \"wiki\",\n", " \"thumbnail_link\",\n", "]\n", "df_clean[export_cols].to_excel(output_excel, index=False, engine=\"openpyxl\")\n", "print(f\"✅ Data uložena: '{output_excel}'\")\n", "\n", "# Zobrazení\n", "m" ] } ], "metadata": { "kernelspec": { "display_name": "jupyter", "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.12" } }, "nbformat": 4, "nbformat_minor": 5 }