{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "6dd2d38b-08ff-4a7a-b89d-e23c69d5e9d3",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T10:00:45.359449Z",
     "iopub.status.busy": "2024-12-04T10:00:45.359032Z",
     "iopub.status.idle": "2024-12-04T10:00:45.362241Z",
     "shell.execute_reply": "2024-12-04T10:00:45.361738Z",
     "shell.execute_reply.started": "2024-12-04T10:00:45.359433Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "c38c6486-2a11-4935-9b61-276fa1d02f9c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:40:56.118956Z",
     "iopub.status.busy": "2024-12-04T09:40:56.118587Z",
     "iopub.status.idle": "2024-12-04T09:40:59.017814Z",
     "shell.execute_reply": "2024-12-04T09:40:59.017070Z",
     "shell.execute_reply.started": "2024-12-04T09:40:56.118926Z"
    }
   },
   "outputs": [],
   "source": [
    "tankpreise = pd.read_csv('https://data.hsbo.de/tankpreise_Bochum_2020.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "2be98bc9-1d16-44dd-9953-1038e68612a1",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:40:59.018748Z",
     "iopub.status.busy": "2024-12-04T09:40:59.018607Z",
     "iopub.status.idle": "2024-12-04T09:40:59.025486Z",
     "shell.execute_reply": "2024-12-04T09:40:59.025023Z",
     "shell.execute_reply.started": "2024-12-04T09:40:59.018735Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>dieselchange</th>\n",
       "      <th>e5change</th>\n",
       "      <th>e10change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 02:03:03+01</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>1.289</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1.369</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.399</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     date                          station_uuid  diesel  \\\n",
       "0  2020-01-01 02:03:03+01  b7dc5a11-661a-419f-8d30-d9763b2897c7   1.289   \n",
       "1  2020-01-01 04:36:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.309   \n",
       "2  2020-01-01 04:36:04+01  51d4b671-a095-1aa0-e100-80009459e03a   1.319   \n",
       "3  2020-01-01 04:36:04+01  51d4b500-a095-1aa0-e100-80009459e03a   1.319   \n",
       "4  2020-01-01 04:36:04+01  cd8b8686-d085-1ed7-a59b-163f66bf05c4   1.319   \n",
       "\n",
       "      e5    e10  dieselchange  e5change  e10change  \n",
       "0  1.409  1.369             0         0          1  \n",
       "1  1.429  1.409             1         1          1  \n",
       "2  1.439  1.399             1         1          1  \n",
       "3  1.439  1.419             1         1          1  \n",
       "4  1.439  1.419             1         1          1  "
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "bf7a4f7e-87ab-479d-82a4-3b249d1d15ba",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:15:39.494368Z",
     "iopub.status.busy": "2024-12-04T08:15:39.493977Z",
     "iopub.status.idle": "2024-12-04T08:15:39.561806Z",
     "shell.execute_reply": "2024-12-04T08:15:39.561157Z",
     "shell.execute_reply.started": "2024-12-04T08:15:39.494339Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>487736.000000</td>\n",
       "      <td>487736.000000</td>\n",
       "      <td>487736.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1.095399</td>\n",
       "      <td>1.275508</td>\n",
       "      <td>1.239714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.088784</td>\n",
       "      <td>0.077771</td>\n",
       "      <td>0.083094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.029000</td>\n",
       "      <td>1.228000</td>\n",
       "      <td>1.188000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1.069000</td>\n",
       "      <td>1.259000</td>\n",
       "      <td>1.219000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1.129000</td>\n",
       "      <td>1.319000</td>\n",
       "      <td>1.279000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1.489000</td>\n",
       "      <td>1.629000</td>\n",
       "      <td>1.609000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              diesel             e5            e10\n",
       "count  487736.000000  487736.000000  487736.000000\n",
       "mean        1.095399       1.275508       1.239714\n",
       "std         0.088784       0.077771       0.083094\n",
       "min         0.000000       0.000000       0.000000\n",
       "25%         1.029000       1.228000       1.188000\n",
       "50%         1.069000       1.259000       1.219000\n",
       "75%         1.129000       1.319000       1.279000\n",
       "max         1.489000       1.629000       1.609000"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7a5c4d04-b105-4a36-b48d-e15e0ddce1ea",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:17:27.546418Z",
     "iopub.status.busy": "2024-12-04T08:17:27.546034Z",
     "iopub.status.idle": "2024-12-04T08:17:27.552129Z",
     "shell.execute_reply": "2024-12-04T08:17:27.551504Z",
     "shell.execute_reply.started": "2024-12-04T08:17:27.546383Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date             object\n",
       "station_uuid     object\n",
       "diesel          float64\n",
       "e5              float64\n",
       "e10             float64\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "id": "f36a7738-9ac8-4477-967c-ea9497571283",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:43:01.394017Z",
     "iopub.status.busy": "2024-12-04T09:43:01.393648Z",
     "iopub.status.idle": "2024-12-04T09:43:04.692311Z",
     "shell.execute_reply": "2024-12-04T09:43:04.691888Z",
     "shell.execute_reply.started": "2024-12-04T09:43:01.393987Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_1111/3130635898.py:1: FutureWarning: In a future version of pandas, parsing datetimes with mixed time zones will raise an error unless `utc=True`. Please specify `utc=True` to opt in to the new behaviour and silence this warning. To create a `Series` with mixed offsets and `object` dtype, please use `apply` and `datetime.datetime.strptime`\n",
      "  tankpreise['Datum'] = pd.to_datetime(tankpreise['date'] + \":00\")\n"
     ]
    }
   ],
   "source": [
    "tankpreise['Datum'] = pd.to_datetime(tankpreise['date'] + \":00\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "18417ba4-1bb8-4ec8-b234-9d936ad5d334",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:18:30.487955Z",
     "iopub.status.busy": "2024-12-04T08:18:30.487589Z",
     "iopub.status.idle": "2024-12-04T08:18:30.491904Z",
     "shell.execute_reply": "2024-12-04T08:18:30.491419Z",
     "shell.execute_reply.started": "2024-12-04T08:18:30.487936Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date                         object\n",
       "station_uuid                 object\n",
       "diesel                      float64\n",
       "e5                          float64\n",
       "e10                         float64\n",
       "Datum           datetime64[ns, UTC]\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "f3154327-4061-4777-a85c-578a9fc79f60",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:19:07.112297Z",
     "iopub.status.busy": "2024-12-04T08:19:07.112082Z",
     "iopub.status.idle": "2024-12-04T08:19:07.119482Z",
     "shell.execute_reply": "2024-12-04T08:19:07.118882Z",
     "shell.execute_reply.started": "2024-12-04T08:19:07.112282Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>Datum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 02:03:03+01</td>\n",
       "      <td>b7d..7c7</td>\n",
       "      <td>1.289</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1.369</td>\n",
       "      <td>2020-01-01 01:03:03+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d..03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d..03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.399</td>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d..03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>cd8..5c4</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     date station_uuid  diesel     e5    e10  \\\n",
       "0  2020-01-01 02:03:03+01     b7d..7c7   1.289  1.409  1.369   \n",
       "1  2020-01-01 04:36:04+01     51d..03a   1.309  1.429  1.409   \n",
       "2  2020-01-01 04:36:04+01     51d..03a   1.319  1.439  1.399   \n",
       "3  2020-01-01 04:36:04+01     51d..03a   1.319  1.439  1.419   \n",
       "4  2020-01-01 04:36:04+01     cd8..5c4   1.319  1.439  1.419   \n",
       "\n",
       "                      Datum  \n",
       "0 2020-01-01 01:03:03+00:00  \n",
       "1 2020-01-01 03:36:04+00:00  \n",
       "2 2020-01-01 03:36:04+00:00  \n",
       "3 2020-01-01 03:36:04+00:00  \n",
       "4 2020-01-01 03:36:04+00:00  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b060f776-b408-4c8e-8211-a4dd6f97261c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:19:30.957486Z",
     "iopub.status.busy": "2024-12-04T08:19:30.957111Z",
     "iopub.status.idle": "2024-12-04T08:19:30.963249Z",
     "shell.execute_reply": "2024-12-04T08:19:30.962493Z",
     "shell.execute_reply.started": "2024-12-04T08:19:30.957456Z"
    }
   },
   "outputs": [],
   "source": [
    "preiseE5 = tankpreise[['Datum','e5']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "dc3aed80-9ee6-403d-91d9-88f450e3dba0",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:32:29.131458Z",
     "iopub.status.busy": "2024-12-04T08:32:29.131086Z",
     "iopub.status.idle": "2024-12-04T08:32:29.141748Z",
     "shell.execute_reply": "2024-12-04T08:32:29.141131Z",
     "shell.execute_reply.started": "2024-12-04T08:32:29.131429Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Datum</th>\n",
       "      <th>e5</th>\n",
       "      <th>Wochentag</th>\n",
       "      <th>Monat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 01:03:03+00:00</td>\n",
       "      <td>1.409</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.429</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Datum     e5  Wochentag  Monat\n",
       "0 2020-01-01 01:03:03+00:00  1.409  Wednesday      1\n",
       "1 2020-01-01 03:36:04+00:00  1.429  Wednesday      1\n",
       "2 2020-01-01 03:36:04+00:00  1.439  Wednesday      1\n",
       "3 2020-01-01 03:36:04+00:00  1.439  Wednesday      1\n",
       "4 2020-01-01 03:36:04+00:00  1.439  Wednesday      1"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseE5.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4346afde-3904-4d9f-a8d3-6a8dd92ecc54",
   "metadata": {},
   "source": [
    "## Aufgabe 2\n",
    "\n",
    "Um den Verlauf zu charakterisieren würde man als erstes die Preise z.B. pro Wochentag\n",
    "berechnen.\n",
    "\n",
    "  1. Wochentag Spalte hinzufügen\n",
    "  2. mit Group By Durchschnittspreise nach Wochentag berechnen"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "293585ec-4a2d-481c-8eb8-60e505d1180c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:21:28.641692Z",
     "iopub.status.busy": "2024-12-04T08:21:28.641157Z",
     "iopub.status.idle": "2024-12-04T08:21:28.705253Z",
     "shell.execute_reply": "2024-12-04T08:21:28.704756Z",
     "shell.execute_reply.started": "2024-12-04T08:21:28.641678Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_1111/3209317105.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  preiseE5['Wochentag'] = preiseE5['Datum'].dt.day_name()\n"
     ]
    }
   ],
   "source": [
    "preiseE5['Wochentag'] = preiseE5['Datum'].dt.day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e34a7918-cbc4-4dae-a1a4-2133c26055a1",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:21:34.323776Z",
     "iopub.status.busy": "2024-12-04T08:21:34.323384Z",
     "iopub.status.idle": "2024-12-04T08:21:34.330845Z",
     "shell.execute_reply": "2024-12-04T08:21:34.330003Z",
     "shell.execute_reply.started": "2024-12-04T08:21:34.323741Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Datum</th>\n",
       "      <th>e5</th>\n",
       "      <th>Wochentag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 01:03:03+00:00</td>\n",
       "      <td>1.409</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.429</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Datum     e5  Wochentag\n",
       "0 2020-01-01 01:03:03+00:00  1.409  Wednesday\n",
       "1 2020-01-01 03:36:04+00:00  1.429  Wednesday\n",
       "2 2020-01-01 03:36:04+00:00  1.439  Wednesday\n",
       "3 2020-01-01 03:36:04+00:00  1.439  Wednesday\n",
       "4 2020-01-01 03:36:04+00:00  1.439  Wednesday"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseE5.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "9edc983a-7769-40ea-9e34-e0d6c69e846a",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:22:13.354436Z",
     "iopub.status.busy": "2024-12-04T08:22:13.354066Z",
     "iopub.status.idle": "2024-12-04T08:22:13.370940Z",
     "shell.execute_reply": "2024-12-04T08:22:13.370327Z",
     "shell.execute_reply.started": "2024-12-04T08:22:13.354406Z"
    }
   },
   "outputs": [],
   "source": [
    "preiseWochentag = preiseE5[['Wochentag','e5']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "78c1d492-48df-4ac8-8bf5-ec9d86f31a5b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:22:32.464343Z",
     "iopub.status.busy": "2024-12-04T08:22:32.463970Z",
     "iopub.status.idle": "2024-12-04T08:22:32.518978Z",
     "shell.execute_reply": "2024-12-04T08:22:32.518193Z",
     "shell.execute_reply.started": "2024-12-04T08:22:32.464313Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>e5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wochentag</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Friday</th>\n",
       "      <td>1.069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monday</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saturday</th>\n",
       "      <td>1.069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sunday</th>\n",
       "      <td>1.069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thursday</th>\n",
       "      <td>1.059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tuesday</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wednesday</th>\n",
       "      <td>0.000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              e5\n",
       "Wochentag       \n",
       "Friday     1.069\n",
       "Monday     0.000\n",
       "Saturday   1.069\n",
       "Sunday     1.069\n",
       "Thursday   1.059\n",
       "Tuesday    0.000\n",
       "Wednesday  0.000"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseWochentag.groupby('Wochentag').min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "8d7727b2-7824-409e-8e72-b3702cc47805",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:23:28.897125Z",
     "iopub.status.busy": "2024-12-04T08:23:28.896751Z",
     "iopub.status.idle": "2024-12-04T08:23:28.920001Z",
     "shell.execute_reply": "2024-12-04T08:23:28.919066Z",
     "shell.execute_reply.started": "2024-12-04T08:23:28.897095Z"
    }
   },
   "outputs": [],
   "source": [
    "preiseWochentag = preiseWochentag[ preiseWochentag['e5'] > 0 ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "c272b38f-7267-4fda-908e-133ecad59804",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:24:21.978400Z",
     "iopub.status.busy": "2024-12-04T08:24:21.977747Z",
     "iopub.status.idle": "2024-12-04T08:24:22.030568Z",
     "shell.execute_reply": "2024-12-04T08:24:22.029831Z",
     "shell.execute_reply.started": "2024-12-04T08:24:21.978369Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>e5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wochentag</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Friday</th>\n",
       "      <td>1.277120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monday</th>\n",
       "      <td>1.277774</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saturday</th>\n",
       "      <td>1.269661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sunday</th>\n",
       "      <td>1.260579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Thursday</th>\n",
       "      <td>1.280508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tuesday</th>\n",
       "      <td>1.280024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wednesday</th>\n",
       "      <td>1.279878</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 e5\n",
       "Wochentag          \n",
       "Friday     1.277120\n",
       "Monday     1.277774\n",
       "Saturday   1.269661\n",
       "Sunday     1.260579\n",
       "Thursday   1.280508\n",
       "Tuesday    1.280024\n",
       "Wednesday  1.279878"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseWochentag.groupby('Wochentag').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "836e75df-984f-41f0-9059-9a5d2601422d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:27:02.475278Z",
     "iopub.status.busy": "2024-12-04T08:27:02.474913Z",
     "iopub.status.idle": "2024-12-04T08:27:02.485543Z",
     "shell.execute_reply": "2024-12-04T08:27:02.484806Z",
     "shell.execute_reply.started": "2024-12-04T08:27:02.475248Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Datum</th>\n",
       "      <th>e5</th>\n",
       "      <th>Wochentag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 01:03:03+00:00</td>\n",
       "      <td>1.409</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.429</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Datum     e5  Wochentag\n",
       "0 2020-01-01 01:03:03+00:00  1.409  Wednesday\n",
       "1 2020-01-01 03:36:04+00:00  1.429  Wednesday\n",
       "2 2020-01-01 03:36:04+00:00  1.439  Wednesday\n",
       "3 2020-01-01 03:36:04+00:00  1.439  Wednesday\n",
       "4 2020-01-01 03:36:04+00:00  1.439  Wednesday"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseE5.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "5437f73d-646f-48e6-9f3f-68de0587d88b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:34.700220Z",
     "iopub.status.busy": "2024-12-04T08:30:34.700003Z",
     "iopub.status.idle": "2024-12-04T08:30:34.709316Z",
     "shell.execute_reply": "2024-12-04T08:30:34.708890Z",
     "shell.execute_reply.started": "2024-12-04T08:30:34.700206Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_1111/1321889525.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  preiseE5['Monat'] = preiseE5['Datum'].dt.month\n"
     ]
    }
   ],
   "source": [
    "preiseE5['Monat'] = preiseE5['Datum'].dt.month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "1f7d77e7-e4b7-4afb-8aec-8a317f8789db",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:35.061039Z",
     "iopub.status.busy": "2024-12-04T08:30:35.060724Z",
     "iopub.status.idle": "2024-12-04T08:30:35.068706Z",
     "shell.execute_reply": "2024-12-04T08:30:35.068208Z",
     "shell.execute_reply.started": "2024-12-04T08:30:35.061011Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Datum</th>\n",
       "      <th>e5</th>\n",
       "      <th>Wochentag</th>\n",
       "      <th>Monat</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 01:03:03+00:00</td>\n",
       "      <td>1.409</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.429</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 03:36:04+00:00</td>\n",
       "      <td>1.439</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Datum     e5  Wochentag  Monat\n",
       "0 2020-01-01 01:03:03+00:00  1.409  Wednesday      1\n",
       "1 2020-01-01 03:36:04+00:00  1.429  Wednesday      1\n",
       "2 2020-01-01 03:36:04+00:00  1.439  Wednesday      1\n",
       "3 2020-01-01 03:36:04+00:00  1.439  Wednesday      1\n",
       "4 2020-01-01 03:36:04+00:00  1.439  Wednesday      1"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseE5.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "ece5408d-d2cc-42e8-b518-3cea64f2a0c3",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:35.493836Z",
     "iopub.status.busy": "2024-12-04T08:30:35.493523Z",
     "iopub.status.idle": "2024-12-04T08:30:35.502466Z",
     "shell.execute_reply": "2024-12-04T08:30:35.501806Z",
     "shell.execute_reply.started": "2024-12-04T08:30:35.493809Z"
    }
   },
   "outputs": [],
   "source": [
    "nachMonat = preiseE5[['Monat','e5']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "10284514-9a69-4ee1-a78a-50058c1111c8",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:36.115933Z",
     "iopub.status.busy": "2024-12-04T08:30:36.115189Z",
     "iopub.status.idle": "2024-12-04T08:30:36.134504Z",
     "shell.execute_reply": "2024-12-04T08:30:36.133736Z",
     "shell.execute_reply.started": "2024-12-04T08:30:36.115897Z"
    }
   },
   "outputs": [],
   "source": [
    "jeMonat = nachMonat.groupby('Monat').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "99e0cdbc-e2d3-4d5d-b692-1b1010fd4415",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:40.414344Z",
     "iopub.status.busy": "2024-12-04T08:30:40.413980Z",
     "iopub.status.idle": "2024-12-04T08:30:40.422729Z",
     "shell.execute_reply": "2024-12-04T08:30:40.422117Z",
     "shell.execute_reply.started": "2024-12-04T08:30:40.414313Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>e5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Monat</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.400187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.400610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.315823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.205535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.186785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.261453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.280435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.276992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.273902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1.256308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.232512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.263433</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             e5\n",
       "Monat          \n",
       "1      1.400187\n",
       "2      1.400610\n",
       "3      1.315823\n",
       "4      1.205535\n",
       "5      1.186785\n",
       "6      1.261453\n",
       "7      1.280435\n",
       "8      1.276992\n",
       "9      1.273902\n",
       "10     1.256308\n",
       "11     1.232512\n",
       "12     1.263433"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jeMonat.head(14)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "961edfa8-26ac-4b75-9ac1-a3f7afb1035a",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:30:08.897150Z",
     "iopub.status.busy": "2024-12-04T08:30:08.896830Z",
     "iopub.status.idle": "2024-12-04T08:30:09.038641Z",
     "shell.execute_reply": "2024-12-04T08:30:09.038273Z",
     "shell.execute_reply.started": "2024-12-04T08:30:08.897122Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: xlabel='Monat'>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjQAAAGwCAYAAAC+Qv9QAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8hTgPZAAAACXBIWXMAAA9hAAAPYQGoP6dpAACBAUlEQVR4nO3de3xbdf0/8NfJPWmb9H7b2t0v7MLWwUa3IWPAGBMmKgiCDFARUK7Oy48pCAMV+AKC3ARUmKgMVAYMRbkJbGMDHLRjMHbvrm3X9ZomaZM0Ob8/knNyTi5t0qZN0r6ej0cfW5LT5JPTNnnn/Xl/3h9BFEURRERERBlMk+oBEBEREQ0UAxoiIiLKeAxoiIiIKOMxoCEiIqKMx4CGiIiIMh4DGiIiIsp4DGiIiIgo4+lSPYBk8fv9qK+vR05ODgRBSPVwiIiIKA6iKKKzsxPl5eXQaPqfZxk2AU19fT0qKipSPQwiIiLqh8OHD2P06NH9/v5hE9Dk5OQACJwQq9Wa4tEQERFRPOx2OyoqKuT38f4aNgGNNM1ktVoZ0BAREWWYgZaLsCiYiIiIMh4DGiIiIsp4DGiIiIgo4w2bGhoiIqJ05PP54PV6Uz2MlNHr9dBqtYP+OAxoiIiIBoEoimhsbER7e3uqh5Jyubm5KC0tHdQ+cQxoiIiIBoEUzBQXF8NisYzIpq+iKMLlcqGpqQkAUFZWNmiPxYCGiIgoyXw+nxzMFBQUpHo4KWU2mwEATU1NKC4uHrTpJxYFExERJZlUM2OxWFI8kvQgnYfBrCViQENERDRIRuI0UzRDcR4Y0BAREVHGY0BDREREGY8BDREREWU8BjR9sHd7UdfshNPdk+qhEBERpQVBECK+nnjiiZSOicu2+3DRE1uws7ETf/rOPCyaXJTq4RAREaWFZ555Buecc4582WazpXA0DGj6VJBtAAC0Ot0pHgkREWUyURTR5fWl5LHNem1CK41EUcR9992HJ554Ag0NDZg8eTJuu+02XHjhhfIxUvffdJFwQLNhwwbcd999+Pjjj9HQ0ICXXnoJX/3qV+P63vfffx+LFi3CjBkzUFtbK1+/Zs0afPvb3444vqurCyaTKdEhJlWeRQpoRu4+HERENHBdXh+m/eL1lDz2jjuXwmKI/y3/1ltvxbp16/C73/0OkyZNwoYNG3DZZZehqKgIixYtAgBcf/31uOqqqzBu3Dh897vfxdVXXw2NJnWVLAkHNE6nE7NmzcK3v/1tXHDBBXF/X0dHBy6//HKceeaZOHbsWMTtVqsVu3btUl2X6mAGAAqymKEhIqKRw+l04je/+Q3++9//Yv78+QCA8ePHY9OmTXjyySexaNEi3HXXXTjzzDNhNpvx9ttv40c/+hGam5tx6623pmzcCQc0y5Ytw7JlyxJ+oGuuuQaXXnoptFotXn755YjbBUFIKHXldrvhdoeCDLvdnvCY4pGXxQwNERENnFmvxY47l6bsseO1Y8cOdHd3Y8mSJarrPR4PqqqqAEAVuMyePRsAcOedd2ZWQNMfzzzzDPbt24e//OUv+OUvfxn1GIfDgTFjxsDn82H27Nm466675BMXzd13343Vq1cP1pBlzNAQEVEyCIKQ0LRPqvj9fgDAv/71L4waNUp1m9FojPo91dXVsNvtOHbsGEpKSgZ9jNEM+pnds2cPbrnlFmzcuBE6XfSHmzp1KtasWYOZM2fCbrfjt7/9LRYuXIht27Zh0qRJUb9n1apVWLlypXzZbrejoqIi6eOXMjRtzNAQEdEIMG3aNBiNRhw6dEiul+lLTU0NTCYTcnNzB3dwvRjUgMbn8+HSSy/F6tWrMXny5JjHVVdXo7q6Wr68cOFCzJkzB4888ggefvjhqN9jNBpjRorJlB8MaFqYoSEiohEgJycHP/7xj/HDH/4Qfr8fp556Kux2OzZv3ozs7Gzk5+ejsbER8+fPh9lsxjvvvIOf//znuPrqq4fkfTmWQQ1oOjs7sXXrVtTU1OD6668HEEhliaIInU6HN954A2eccUbE92k0GsydOxd79uwZzOHFpSAr8MNpczFDQ0REI8Ndd92F4uJi3H333di/fz9yc3MxZ84c/OxnP4PL5cLjjz+OlStXwu/3Y/z48bjzzjtx3XXXpXTMgxrQWK1WbN++XXXd448/jv/+97/4xz/+gXHjxkX9PlEUUVtbi5kzZw7m8OKSl6UHALS5PPD5RWg13DmViIiGN0EQcOONN+LGG2+MeruyoV66SDigcTgc2Lt3r3y5rq4OtbW1yM/PR2VlJVatWoWjR4/i2WefhUajwYwZM1TfX1xcDJPJpLp+9erVqK6uxqRJk2C32/Hwww+jtrYWjz322ACeWnJIfWhEEejo8spTUERERJQ+Eg5otm7disWLF8uXpcLcK664AmvWrEFDQwMOHTqU0H22t7fj6quvRmNjI2w2G6qqqrBhwwbMmzcv0eElnV6rgdWkg727B61ONwMaIiKiNCSIoiimehDJYLfbYbPZ0NHRAavVmtT7Xnz/u6hrduJv18zHvHH5Sb1vIiIafrq7u1FXV4dx48alRZPYVOvtfCTr/Zu7bcchzxKoo2EvGiIiSsQwyRkM2FCcBwY0ccgPrnRit2AiIoqHXh/4IOxyuVI8kvQgnQfpvAyG9G9ZmAbys5ihISKi+Gm1WuTm5qKpqQkAYLFYEtrtergQRREulwtNTU3Izc2FVhv/FgyJYkATB7lbMHvREBFRnKT9CaWgZiTLzc1NaL/G/mBAEwerKZChcXT3pHgkRESUKQRBQFlZGYqLi+H1jtwPxHq9flAzMxIGNHHIMgR+EA4PAxoiIkqMVqsdkjf0kY5FwXHIZoaGiIgorTGgiUO2MZDIcrgHN6D59/YGVP/6bXxU1zqoj0NERDTcMKCJQ44pGNAMcobm+3/9BI32bty4tmZQH4eIiGi4YUATh6HK0Ei8Pv+QPA4REdFwwYAmDtnBDE1n99BUqZv0LB4jIiJKBAOaOOQoMjRD0b7ZYkjPgEYURRxpc6G+vSvVQyEiIlLhsu04SBkavwh0eX2wGJJ/2pTTTBZj+v1Y/H4RX//dZtQebodOI+D1H56GCUXZqR4WERERAGZo4mLWa6EJdqwerDqaFodH/r9Bm37tsZudbtQebgcA9PhFbNh9PLUDIiIiUmBAEwdBEJBlHNyVTsc7Q/tEOd2+QXmMgegMe941h9pTMxAiIqIoGNDEKWeQVzodd3TL/3emYUfiiIDmcFuKRkJERBSJAU2csge5F01zZ2jKKR0zNNLzHpVrhiAAh1u7VFklIiKiVGJAEyepF03noGVolFNO6ZihCSxZL7OZMLk4BwBQc4hZGiIiSg8MaOI02Ps5KbMdXV4ffP7BXx6eCCmQyzHpMGOUDQCwq7EzlUMiIiKSMaCJ06DX0IRN36S6juadnU34z2cN8mWphibHpIfNHAjuXN70mxojIqKRiQFNnAZ7+wPllBMAuFJYR+P1+fHtNf/DtX/5BA0dgSZ60pRTtkkHkz7wa9PNgIaIiNIEA5o4ZQ1yQNPq9KguD9W+UdEos0V7jjkAhKbackw6eWuGbi/3nCIiovTAgCZOg73KKbwQOJWFwcfsoSXke5oCAY085WQMZWjczNAQEVGaSL8e+2lqsGtopABGqxHg84spDWiaFBmaXY12AKHnnWPSQwg2Mu7uYUBDRETpgRmaOIV23B6cQKMrmO0ozjECSO2UU5MiQ7MrOOVkD9bQ5Jh0MOk45UREROmFAU2c5D40wTf2ZPL0+OH1BZZpFwUDGpcnddmPY3ZlDU0n/H5RDuSyjToYWRRMRERphlNOcZIyJ4dbXUm/b5diiXZRdhpkaDpDGRqXx4cjbV2qKSepQw4DGiIiShfM0MRpxigbNAJQ39GNxo7AG74oJqf5nTOYjTHoNHKPl9QWBauXkNccbpMzU1zlRERE6YgBTZyyjDpMKbUCAGoPt+Ght3bjxNVv4P29zQO+b1cweMkyaOXl4elQFDwz2BH4pZqj6mXbOk45ERFRemFAk4DZFbkAgGv/8gkeemsPOrt78M9P6wd8v1KGxmLQwWLUqq4bSlLGSSoKvm7xBADAu7uOy+PJMekVGRoGNERElB4Y0CSgqjI34roDzQOvqZEzNEYtsg2pydD8cVMd5v7qLeyot6Ml2ORv7th8zB2bpzou26iYcurhlBMREaUHBjQJmKMIaOaNywcA7D3uGPD9KjM0g92ROJa7/rkDzQ4PvvfsVgCAXisgz2LA16pGy8cYdRoYdBpufUBERGmHAU0CJhRl45J5lbhkXgV+f/nJAALbBHS4BraUW1rllGXUIkuachrkgKbd5cGv/rUDO4ON8yRH2wN7NxVlG6HRCDh7eol8mzuYkTErppySVRhNREQ0EFy2nQBBEHD312fKl8ttJtR3dGPv8U6cNCa/3/frdIcyNDmmwCqnwWrgJ/nnpw34/cY6NNrdeOSSqojbKwssAIDCbCN0GgE9/lDgYgwGNH4R8PpEGHTCoI6ViIioL8zQDMCE4mwAoQ0c+0vO0Bi08rJt+yA08FNmU9pdgTqZlrBdviWTinPk/180t0J1mzTlBHD7AyIiSg/M0AzApOIcbNzTjL1NAw1oghkaow7WYIamoyu5AY2nx4/zHtmIsQVZeOryk+EIZoViPc6kkmz5/7edOw0GrQaLpxYDAAxaDQQBEMXAtJM0ZiIiolRhhmYAJgff9F/f0TigOhpntAxNV3KnnA62OLH7mANvfnEMfsXmlx1d3qh1MBOLQwGN2aDFHV+ZjkWTiwAEpt6k/ZzcbK5HRERpgAHNACybUYZRuWYcbu3CLes+7ff9uILZErNBB6s5kDTr8vrgSeKyaCkTI4pAp7tHDmjsXV54fJGPo5xyioYrnYiIKJ0woBkAm0WPRy4NFNS+ueNYv1f8KDM0OYrpm0TqaP75aT2+9+zWmN+jnFqyd3nlx+x098hdgCW5Fj0Ksw29Ph63PyAionTCgGaAppUFtkPo8Yuw93NlkpShsRh10GoE5AR70dgTqKO5/rkavLnjGB79796ot7crpsQ6urzyyipRBBrt3apjJxVnQxB6X7kUaq7HDA0REaUeA5oBMum1yDIE3tzbgh12E6XM0ACA1dz/wuD9MRr9Ke+ro8uratzX0K4OaGYE93DqjZH7ORERURphQJMEeVmB6ZlWV/8CGpeiUzAQCmj6k/GJ1WFYGdC0u7yqxn0NHcFmejlGPP6tObj5rMl9Pg6nnIiIKJ0kHNBs2LABy5cvR3l5OQRBwMsvvxz3977//vvQ6XSYPXt2xG0vvvgipk2bBqPRiGnTpuGll15KdGgpkx8MaPqdoVHs5QQAtmBhcLwZGmWWxBVjU8vwDI0yoKnvCGRoCrIM+PLMMnmlVW9YFExEROkk4YDG6XRi1qxZePTRRxP6vo6ODlx++eU488wzI27bsmULLr74YqxYsQLbtm3DihUrcNFFF+HDDz9MdHgpkWcJZmj6GdBEZGhM0tLt+AIaZX1Me4zl471POXUFH18b95i54zYREaWThBvrLVu2DMuWLUv4ga655hpceuml0Gq1EVmdhx56CEuWLMGqVasAAKtWrcJ7772Hhx56CGvXrk34sYaanKHp95RTeIYmsRoaZSDV0NEFn1+EVqMu6o3I0CgyOVKGRtoYMx5SHxruuE1EROlgSGponnnmGezbtw+333571Nu3bNmCs88+W3Xd0qVLsXnz5pj36Xa7YbfbVV+pEsrQxA5A2l0enPvwRtyx/vOI5d1ShiYrooYmvoBGGUh5fSKOha1akh5f0mTvhk+xN5NUQyM9fjzkKacYU1xKbq6EIiKiQTboAc2ePXtwyy234K9//St0uuhvmI2NjSgpKVFdV1JSgsbGxpj3e/fdd8Nms8lfFRUVMY8dbPlZgQCktxqaN3ccw+f1dqzZfAB//uCgfL3fLyqmnNQZmninnMIzQ4daXRHHKDM00o7aEmmVk8UY/5ST2RDflNO7u5ow4/bX8dcPD/Z6HBER0UAMakDj8/lw6aWXYvXq1Zg8ufeVM+F9T0RR7LUXyqpVq9DR0SF/HT58OClj7o94VjltPdAm//9X//pCLsp9qeaofH2ohkbqQxPfKqfwQOqbT32AO1/dobquo0u5qkmdwZF20k4kQ2PUxdeHZsv+Fnh9Ij6qa437vomIiBI1qJtTdnZ2YuvWraipqcH1118PAPD7/RBFETqdDm+88QbOOOMMlJaWRmRjmpqaIrI2SkajEUajcTCHH7d8S9+rnP53IPSG7u7xY1+wX8yP/r4NAHDymDx5GsdmSbSGJvK4p9+vw81LJsFq0kMURXR0hcZWH5ahkSRUQxPnsu3mzsDjJtIkkIiIKFGDmqGxWq3Yvn07amtr5a9rr70WU6ZMQW1tLU455RQAwPz58/Hmm2+qvveNN97AggULBnN4SZPXR1Hw8U439jc7IQjA1NLAHkl1zU5sP9oBAJg7Ng9rr66WM1LyKqcEa2gmFWcjWxGU/Gd7IEjs8vrg9YVqZnr80bdoyEpolVN8y7abHW4Ayd89nIiISCnhDI3D4cDevaH2+nV1daitrUV+fj4qKyuxatUqHD16FM8++yw0Gg1mzJih+v7i4mKYTCbV9TfddBNOO+003HvvvTj//PPxyiuv4K233sKmTZsG8NSGTmiVk/pNWxRF9PhFbA1mZ6aU5GB2RS52NnZi33En/MHAYkppDvTaUGyZ6ConKaC5eG4FvrNwHH733j7c9/ouvFx7FBfNrYi5lDucZTAyNMGApr/bQhAREcUj4QzN1q1bUVVVhaqqwKaMK1euRFVVFX7xi18AABoaGnDo0KGE7nPBggV4/vnn8cwzz+DEE0/EmjVr8MILL8gZnHQnrXJqd3nk1UMf1bXijAfew+n3vYuPDwbqZ6oq8zC+KAtAIENTH1xdVGYzq+5PufXBfz5rwLLfbsSBZmfMx5eWbedZDNBoBHxlVjmAQP2K090jB0bhS7nDLyeUoZG2PuijhqbF4ZGfCxER0WBJOENz+umn97qr9Jo1a3r9/jvuuAN33HFHxPUXXnghLrzwwkSHkxZygzUvfjFQK+Jw9+CyP34IT7BHy3u7jwMARueZMa4wG0BgzyVpaqk816S6v1KbCRoh0CTv2r98AgD4zZu78fAlVVEfX8rQ5AVXW1XkW1CcY0RTpxu7jnXK4xiVa1atgKrMt6BOESj1p4bG3cuUkyiKaHEGMzQMaIiIaBBxL6ck0Gs18sqkFqcHb+w4JgcRALCnKVAAXJ5rii9DY9LjpDF5quukmpVo2oJFwVKmCACmBncB/6LBLk85FWQbVN2Ap5VbUWINFVZn9WPZtrRrdzQdXV65dsfd42dXYSIiGjQMaJKkPDcQlBxqdeLdXU1RjymzmVGRZ4FWI8Dl8eFgSyBbUh4W0ADA6VOKVZc1vSxhlzI0Ui0PAJxQFig+3tnQKWdHcs16FGaHApgcow6nTSqSL1sSWLadK02zKTIvXR4f1rxfhyNtgecl1c9I4i1yJiIiShQDmiSZVBIIIGoPtePD/YEi4LOnqZedl9lMMOg0qMhTBzAltsjl54vDAppYK6jcPT65MV+uWRHQlAYyNDsb7XL9is2sxxlTQ/ebZdRh0ZRQQJOdwJRTXnCaTdmB+KG3d+OOV3fgq4+9DwA43qkec7x9dYiIiBLFgCZJJhcHamOe++gQPD4/xhRYcOqkQtUxpbZArczsilz5usJso9ykTumEshyMKbDIl8NXUEk6gtdrBCDHFApIpioyNFIwlGsx4Cuzy+VjtBoBp04MjbG3aa1w0Tbk3LC7GQDQHCwEDs/QdHR5IYoit0IgIqKkY0CTJJOD/WWkN/PFU4oxKjeUiSnMNsiBy5dnlsnXl9nUBcESQRDw5++cgh+eFeiw3B4jQ9OuyL5oFKuWxhdmQ68V0OnuwRcNgX2urGY9qhTBVKvTg1yLAT/78lR865RKTCjKjvv5Sr133D1+dAUzROEBUbQpp7v++QVmrX4D+4ONBYmIiJKBAU2STA5OOUkWTy3GKMXUUqkicDltcmiaJ3wbAqXKAgvOPCEwRRQzQ6MIaJQMOg3GFQYKkGsOt8vHCIKA335zNsYUWHDtogkAgKtPm4BffW1mr1tNhMsyaKHXCsGxBYItU1imKSKg6fLiowMt6Pb68SG3QiAioiRiQJMklfkWGIO9Wcx6LU4Zly8XCgPqlUwmvVaeTjo5bDVTOCkT0u7yRF0uL61gsilWOEmKc0yqY3KDQc/5s0fhvZ8sxsTi+DMy4QRBkAuDpYDGqMjQ9Pj88rYHEnuXF45ggz2pcJiIiCgZGNAkiVYjyAHCwokFMOm1sJr0cl1LedjU0j+uXYBrF03A6vOn93q/UvGt1yfC6YmsPZGmonLDMjRAYJm2UngWZ6BChcGBgEmnCf06tbo8cg8aqYFfR7BHDwAcbo2+nxQREVF/MKBJourxBQCA5bNChbdSHU1ZrnplU1GOEbcsm4oSa/QaGolZr4UhmPlR1tGIooi6Zmco+2KJDFaUS7RjHTMQ4RkaZZ+ZFodHng6T6oTs3T2hgIYZGiIiSqJB3W17pPnx2VPw1dmjMHO0Tb5uerkNOxs7MS3Y6C5RgiAgz6LHMbsb7S4vRgdnqF6qOYqVf9smHxct+zJUGRqpvkcKVoBAQCMt067Is+BIWxdaHB557ydmaIiIKJkY0CSR2aBVBTMAcOf503H5/DE4Mez6RORZDDhmd6t60by767jqmGhTToVZ6gxN8gOaYH1PcOm2KqBxuuUMzehgcXR9eyiIaXa40eXxyR2HiYiIBoJTToMsy6jDrIrchFYQhZMCEeVKp9rgyiX5mChFwYU56uusSQ5opCmn1mCg5VQENM0Oj9wZuCI/UAAtbfUgOdrOaSciIkoOBjQZQLmbNxDoH6PcZBKIURSsyNCY9Bp5Q8nkjUtdFKzM0DTZu+UOxtEyNACnnYiIKHkY0GQAaRdtaRPKbWHZGaDvGhrltgjJG1eoKFgURVWGRrmLt5ShkTaqlLAwmIiIkoUBTQYIbQQZyNDURAlo+lrllOz6GSCUOWpzedHl9cGviFekgCbLoEVxTuReVQBwuJUBDRERJQcDmgwgryYKFt9Gy9BEC2hMeq284eTgBDShDSqV001AKKCxmvWqXcCVOOVERETJwoAmAxQFMxzHHW6IoohtR9oBqPeBssWYUpKmnWxJ7kEDKPrQOD1wutVN/3qC6RqrSY9so07upQNA3jLhCIuCiYgoSRjQZIBSa6CotqGjGwdbXGh3eWHQaXDy2Hz5mFgZGGnaaTAyNIXBYMne3YNWpzvqMVazDoIgoECRpZlYHNj3ihkaIiJKFgY0GUDKxDR2dMvLtaeXW1Urm5QZECUpkIi2CmqgbGa9/Lh1zYFsy5gCC5Qr1K2mwOMqC5RPCO5M3tHllZd2ExERDQQDmgwg7dTt8viwYXegod7silxkm/rui1gZXGEUvvVCMgiCgKJgBqiu2QEgMA2lLAKWMkP5iiXkRVajHGixMJiIiJKBAU0GMOm1cgHum18cAxAIaK6YPxZZBi2+otg7Ktz3T5+Ae74+ExfPrRiUsRVbA4HK/uOBIuBso1a1y7jUzK9QMeWUY9TJvWk47URERMnArQ8yRKnNjDaXF53dgdVEsytyUWozYeutS2DSx45LC7KN+Oa8ykEbl5SNCS3T1iHPYkDNoXYAgDWYRVKudMo26jA634JtRzpwhL1oiIgoCZihyRDKFU35WQZ5Ksls0A5oW4WBKs4JjGt/MKDJNunkHcaBUIYmX1FDk23SoyIvMP4jbczQEBHRwDGgyRClioBm1mhbSoMYJSlD4+kJ7KKdbdRhVJ4ioDFJU06hGppsoxYV+dKUEzM0REQ0cJxyyhBlVkVAU5GbuoGEkWpoJFlGHcptygxNtCknPYy6wL5SjfbuIRglERENdwxoMoQyQzM7nQKaHJPqcqwMTYFqykkHvxhovNfRxWXbREQ0cAxoMkSZIusxa3Ru6gYSpihsn6bCbINqlZM+2KemQDXlpJN71TCgISKiZGBAkyGmlObAoNPghDKrvMt1OlBOOWkEYMm0UlVXYqmYWVkUrNcKyAruMdXZ3QOfX4RWkx41QURElJkY0GSIohwjNvxkcVzN9IaSMvNy0pg8uVbmPzd/Ca0OD0YHVzNlGbQ464QS2Lu8qMizwCeGtubu7PbK+0IRERH1R3q9O1KvlHU06UKZWVkxf6z8/6mlVtVxgiDgD1ecLF/WQIDFoIXL40NHFwMaIiIaGAY0NGAvfn8BDrY4sfzEsoS+z2bWywENERHRQDCgoQE7aUweThqTl/D32cx6NHR0M6AhIqIBY2M9Shmpi3C7iwENERENDAMaShlpNRQzNERENFAMaChlGNAQEVGyMKChlJECGjsDGiIiGiAGNJQyzNAQEVGyMKChlGFAQ0REycKAhlKGAQ0RESULAxpKGQY0RESULAxoKGWsDGiIiChJGNBQykgZmiNtXdh9rDPFoyEiokyWcECzYcMGLF++HOXl5RAEAS+//HKvx2/atAkLFy5EQUEBzGYzpk6digcffFB1zJo1ayAIQsRXd3d3osOjDJJr0cv/P/vBDahrdqZwNERElMkS3svJ6XRi1qxZ+Pa3v40LLrigz+OzsrJw/fXX48QTT0RWVhY2bdqEa665BllZWbj66qvl46xWK3bt2qX6XpMp/XaXpuQpyDLg0lMq8dyHhwAAR9pcGFeYleJRERFRJko4oFm2bBmWLVsW9/FVVVWoqqqSL48dOxbr1q3Dxo0bVQGNIAgoLS1NdDiUwQRBwK+/NhPbj3Rg+9EO9PjEVA+JiIgy1JDX0NTU1GDz5s1YtGiR6nqHw4ExY8Zg9OjROO+881BTU9Pr/bjdbtjtdtUXZSa9VgAAeHz+FI+EiIgy1ZAFNKNHj4bRaMTJJ5+M6667DldddZV829SpU7FmzRqsX78ea9euhclkwsKFC7Fnz56Y93f33XfDZrPJXxUVFUPxNGgQ6LSBX0NmaIiIqL8SnnLqr40bN8LhcOCDDz7ALbfcgokTJ+KSSy4BAFRXV6O6ulo+duHChZgzZw4eeeQRPPzww1Hvb9WqVVi5cqV82W63M6jJUFKGpsfPDA0REfXPkAU048aNAwDMnDkTx44dwx133CEHNOE0Gg3mzp3ba4bGaDTCaDQOylhpaOmDGRpPDwMaIiLqn5T0oRFFEW63u9fba2trUVZWNoSjolTRaYJTTn5OORERUf8knKFxOBzYu3evfLmurg61tbXIz89HZWUlVq1ahaNHj+LZZ58FADz22GOorKzE1KlTAQT60tx///244YYb5PtYvXo1qqurMWnSJNjtdjz88MOora3FY489NtDnRxlAnnJiUTAREfVTwgHN1q1bsXjxYvmyVMdyxRVXYM2aNWhoaMChQ4fk2/1+P1atWoW6ujrodDpMmDAB99xzD6655hr5mPb2dlx99dVobGyEzWZDVVUVNmzYgHnz5g3kuVGGkIqCvSwKJiKifhJEURwW7yJ2ux02mw0dHR2wWq2pHg4lYOXfarHuk6NYtWwqrlk0IdXDISKiIZSs92/u5UQpp2cNDRERDRADGko5XbCGxssaGiIi6icGNJRyermGhgENERH1DwMaSrnQKidOORERUf8woKGU4yonIiIaKAY0lHJ6DWtoiIhoYBjQUMpJNTTcy4mIiPqLAQ2lHKeciIhooBjQUMrpuWybiIgGiAENpZw85cQMDRER9RMDGko5NtYjIqKBYkBDKSdtfcCAhoiI+osBDaWcXhdsrMe9nIiIqJ8Y0FDK6ZihISKiAWJAQynHrQ+IiGigGNBQyoVnaP6wcT9e3VafyiEREZHCa9sb8FLNETQ73KkeSky6VA+ASK8LNdbb29SJX/7rCwDAeSeWQRCEVA6NiIgA3PufnTjY4sKL35+PwmxjqocTFTM0lHLSXk49fj86u3vk650eX6qGRERECq7g67FZn755EAY0lHLKrQ+UC53anJ4UjYiIiJS6pIDGoE3xSGJjQEMpp9z6oEuRlWllQENElHKiKKLLG3httjCgIYpNufWB0xOacmp1MaAhIko1j88PXzB9btIzoCGKSbn1gUsZ0DgY0BARpVq3J9QjjBkaol4ol227FFNObczQEBGlnMsb+KCp1wpyRj0dpe/IaMQwSFNOfhEuN2toiIjSiVTbmM7TTQADGkoD6iknZmiIiNKJ9LqcztNNAAMaSgOhgEZdFNzCGhoiopSTVjiZmaEh6p1BMSerbKzHDA0RUeqFetCkb1M9gAENpQGdIqCxd3nl/7OGhogo9TjlRBQnnSa0X1N7VyiIaXN5ox1ORERDqJtTTkTx0asyNKEpp3aXR27mREREqeHKgG0PAAY0lAa0GgFSkqZDMeXkF9WXiYho6LEomCgBUh1NeADT6nSnYjhERBTUFVx9yhoaojjogyma8IDmeCcLg4mIUolTTkQJ0OvUv4r5WQYAQKO9KxXDISKiIE45ESVA2s9JMr4wCwDQ0NGdiuEQEVFQF5dtE8VPrxVUl8cXBQKaRgY0REQpJWVouJcTURzCd3AdX5QNgBkaIqJUCzXWY6dgoj7pwjI04wqZoSEiSgdSYz1OORHFQa+ooTHrtRiVawbADA0RUapJGRpOORHFQZmhsRi0KLOZAADNDjc8Pf5UDYuIaMTjXk5ECVDW0FiMWuRnGeRduJs6maUhIkoVTjkRJUC5yinLoIMgCCixGQGwjoaIKJVcwU7BnHIiioOyD43UjbLMyjoaIqJUG7Z9aDZs2IDly5ejvLwcgiDg5Zdf7vX4TZs2YeHChSgoKIDZbMbUqVPx4IMPRhz34osvYtq0aTAajZg2bRpeeumlRIdGGUzZKTjbGFgaWJ4bqKM50OxMyZiIiEjRKXi4BTROpxOzZs3Co48+GtfxWVlZuP7667FhwwZ88cUXuPXWW3Hrrbfiqaeeko/ZsmULLr74YqxYsQLbtm3DihUrcNFFF+HDDz9MdHiUoaS9nABgckkOAGDm6FwAQO3h9hSMiCiz/WnzAazfVp/qYVCG8/r88PpEAIBFn959aBIe3bJly7Bs2bK4j6+qqkJVVZV8eezYsVi3bh02btyIq6++GgDw0EMPYcmSJVi1ahUAYNWqVXjvvffw0EMPYe3atVHv1+12w+0O7cRst9sTfSqURpSrnGZV5AIAqioD/9YcbocoihAEIcp3EqWHA81OtLk8qKrMS/VQsKuxE7ev/xwAsPzEMv7tUMLe230cq9d/ji9NKpSvG3YZmoGqqanB5s2bsWjRIvm6LVu24Oyzz1Ydt3TpUmzevDnm/dx9992w2WzyV0VFxaCNmQafKIb+PzuYmZleboVBq0Gr04NDra7UDIxS6kibCx0ub98HpoErnvkIFz6xBcc73X0fPMj2Njnk/3e6e1I4EspUb+5oxP5mJ/605SCAQH+w8C1q0s2QBTSjR4+G0WjEySefjOuuuw5XXXWVfFtjYyNKSkpUx5eUlKCxsTHm/a1atQodHR3y1+HDhwdt7DT4lC/AFfmBYmCjTovpo6wAgJpD7akYFqVQi8ONMx94D6f+33/losR05enx42CLCz6/iIaO1O8Qf7gt9AGgzelJ4UgoU3V5Qv2/Fk8pwn3fODHtM31DNiG2ceNGOBwOfPDBB7jlllswceJEXHLJJfLt4SeqrykGo9EIo9E4aOOlobVfUfir/LlXVeSh5lA7th5sxVerRqViaJQih1pdcPf44e7x4w8b9+OGMyelekgxtTgV099dqcuItLs8eHPHMXxeH5qCb3N5MaYgZUOiDNXdE/gQccfyabhy4bgUjyY+Q5ahGTduHGbOnInvfe97+OEPf4g77rhDvq20tDQiG9PU1BSRtaHh68szSwEA584sU12/cGLglfi17Y1ycycaGZzu0M/7d+/tQ0dX+k49NXeGsiD27tSN8/43duEn//gUryqKgdtczNBQ4rozZLsDpZT0oRFFUVXQO3/+fLz55puqY9544w0sWLBgqIdGKfKrr87E/114Iu77xomq6xdNLkK5zYRWpwf//qwhRaOjVHAoaj9cHh+2HmhN4Wh61+wIvZ6lMvD656eRfyOccqL+kDI0wzqgcTgcqK2tRW1tLQCgrq4OtbW1OHToEIBAbcvll18uH//YY4/h1VdfxZ49e7Bnzx4888wzuP/++3HZZZfJx9x000144403cO+992Lnzp2499578dZbb+Hmm28e2LOjjJGXZcBFJ1dEbE+v02pw6SmVAIDnPjyUiqFRijjDilk/PtiWopH07bhDOeWUuoCmelzk3FJbhhRVU3rp9gZqaEz6zOm/m3ANzdatW7F48WL58sqVKwEAV1xxBdasWYOGhgY5uAEAv9+PVatWoa6uDjqdDhMmTMA999yDa665Rj5mwYIFeP7553Hrrbfitttuw4QJE/DCCy/glFNOGchzo2HirGkluP+N3arCYRr+nJ4MCmgUK5tSOeXkUy4XDGrnlBP1gzTFn0kZmoQDmtNPPx1ilD8ayZo1a1SXb7jhBtxwww193u+FF16ICy+8MNHh0AiQFczadLGGZljp9vrQ0NGN0Xlm1eakEqmGZlZFLrYdbse2I+3w+vxRj021Zkd6FAVHqzNjDQ31RyYGNOn3ykAURmrm1O319xpMU+bw+UWs+OOHWHz/u5i1+g1s3tsccYw05TRrtA02sx7dXj921CfeQPOV2qO4Y/3n8Pn7/7vz8cFW/Pq1L9BkD+wr9uctB3DD2hp4fYG0fLNj6IqCmzq7caQtel8md3Ca4OFLqnD78mkAgDZn6qecnO4e3PR8DTsXZ5DQlBMDGqKkMSv+oNw9/l6OpHTm8vTgte0NcLp78NxHh/C/A23B6314LUrBt1QUnG3UYe7YfADA7es/l3f+jddNz9dizeYD2LD7eL/G/cjbe3DB77bgqQ378ecPDkIURdz2yud4dVs93tsVuM/mzqGpoRFFEV9/fDNOvfcdHI7SbNIdLOTMMmiRZzEASI8Mzfpt9Xilth73/ntnqodCcQplaDInTMickdKIpfyEkO4N1ii2h97agx/89RNc/9wnuO8/gTe22cFtLnY3RtZHSRmaLKMOq748FbkWPWoPt+OJd/fF/ZjKwmKPr3/B8CuKrMK+4w5VvYw22DlVVRTcPXhTTvbuHhxpCzTue3LDPvj9ItZ+dAi7j3UCUH+qzsuSAproAdbhVheu/fPHQ1KbtGlPIAN3tL0LTZ3dg/54NHBSQGNmhoYoebQaAYZg3QTraDLX2o8CiwXe2XUc9u4eFGYbcef50wEAu5s6I6YTpaLgbKMOE4qy8f1FEwAAdS29b4Ph84vY2WiHKIrymz8A6DT963KqDKL3H3eqitOlMTcP0SqnVsUS7HWfHMWazQewat12nP3gBgDKpbYa5Fn0AGIv2/7Hx0fwn88b8YeN+wdtvEDg5/H+vtCU4qeHOwAEzt1r2xsY4KQhURTR3cMpJ6JBIaU9GdBkrknF2arLc8fmYXJJDjQC0O7yqrIcAOAIFgVnGQNF4TZz4A3a1cfeRA++uRvnPLQRf//4iGpaxtXP7J5yiutgi0vOhgCB9vBenx/tiizIYNbQtCo6Ers8Pvz6tS9Ut0ufqo26vqecDrQEunMrn09v+lu/9nl9h+r81B5uBwC8u+s4fvDXTzDvV2/3635p8Hh9olxzZtIxoCFKKqkwmFNOmSs3+AYrOXlsPkx6LSrzLQAip53kKafgz14KbBx9BDSPvrMXALB6/eeqPY36GwwrA6Eurw+b9raoLrc41AFDshvrdbi82LjnOPx+MeKxesIKnZW9Q6QpJ3ePP+rfzYHgdiMHWlzw9FGbdrDFiVN+/TZ+l8B0n2TLvsD5kjJk2460AwC+aAwVeNcptj6h1JMyfQBgZA0NUXJJ87jc/iBzdYZlLk4ekwcAmFySAyCQKfjPZ4347Vt7IIqiqoYm8G/gd6C3TMsBxRtjXpYBh1tDU079CYZ9flEuRJcyRG99cSx0n16fnAEx6AIvp91ev1ycmwyr//k5VvzxI7z1xbFeC3y7vT5VhibLENodOdr3HQhO3fn8opytieU3b+5GU6cb9/4n8aLepmDN0fwJgaZ/tYfbIYqifD4B4KWaownfLw0e6fdIEACjLnPChMwZKY1o0jwup5wyV6eiWNas12JaeWAndSmgWb+tHtf+5WM8+NZubDvSIdfQSAGN1EU6vOGe0ju7muT/N9ndqjfq/kw5KX/fppVZI27v9vjkgKco2whpX9XOJBYGf340kMnY0+RAS7AexmKInAZocXrksZj0WgiCIGfFWsPqaNpdHlUmqa9pp2hL3kVRxGdHO/r8kBFafp8LIHBuOt098hJzAFhfy4AmnUg/G5NOm/Y7bCsxoKGMwCmnzKd8k18yrURukFdVmQsgVFsBBFbgSI31soMBjfRv+JYIQOD3wu8XVdkTj8+PTYr+Nl1xLve2d3ux9qNDaHd55PoZQQCmluVEPq4iK2LSa+QxJqsw2O8XcbA1EJQ1dnSjNTjlNKcyL+LYxo5QNkqqOcsNZkHC63oOhBVW7znWexduQ5Rmhi/XHsV5j2zCz17a3uv3SlOE+VkGedrJ6e5RtWA40OKSe/rQ0HO6e/BSzRE5yO3KwCXbAAMayhDylBP70GSEzm4vnt5Uh8aO0AoW6U31b9fMx/9dGNqE9IypxfjRksny9AgA1Ld3yW+E0lSTlJVwudVB7bbD7Zhz15v4xpNb8P7eFggC5BU+ytqQvrJ7bU4P6pqdOPfhjVi1bjue3LBfDqDNei3GF2VHfE+X16fKilhNUgDR/wyNcmquqdMt18U02rvlTMucYBCoVN8eOtdSRtMqBTRh3YsPhNWs9LWtiEEx7SAFcPf9ZxeAwGqr3jgV/YSkn6HT7YuYlmvnnlMpc8f6z/HDF7bhtpc/A5CZXYIBBjSUIaQ/rG5maDLC37YewZ3/3IHH3w0U6Pr9ohygjC20qF4oBUHADWdOwv9+fhZWVI8BABxqDRWqZss1NKEpJ2nFjc8v4taXP0OX1yf3Uzl3ZhmWTCuJGFNvU049Pj+WP7oJi+9/V667eX9vs/w9FoMWS04oQVVlLm48YyKuDS4h7/L44JbrVjRyANHfwuAn3tuHE1e/gfeCTQAPKqbMjtm75Smn0fkWFGYbVd9b3x4Yt1YjyNkvqyl6xkiaiiuzmQAA7+5qwn8+a4w5LuW0gxRUxbvppVOxWk2ZZQtvkpkODQBHqr9/fASA1ADxKP629TCAzOpBAzCgoQxhZg1NRmkIvrkeC24VEAhCArdJWYxwuRYDJpcEsiB7FBmDrLCAxi8GCm+d7h7c+vJ2bD/aoZoS+cHpE+W6HCUp23KkzRWxYeO2I+2qnjVA4FNql+KTaqnNhJd+sBArz56CnGCg0O31yVlDo04rBxBXPP0RXgy+SQCBGpUVf/wQP/n7Nnxe3xH1+QOBDThFMZB1AgLLxCWNHaEMTUGWAWMLLKrvbQhmw0yKbIo1xpSTdL/fnFuJk8bkwenx4Ycv1EYUbkuUK8ukMSj/Fv29bCuhzLRZFEFp+MqqWP1yaGjd9Hwt/vJBoGeUkQENUfKxKDiztAYDBilTIU3BGLSaXldNlNnMAEJTIAadRs42KD8tOj09uOufO7D2o8AnydXnT8evvzYT939jFqaVW3HmCSUozjHi4pMrcNt5gT2NXB4fmjq7cdZv3sOXf7tRNeWxMdjJdtHkIvzlu6cACGSJpOmt8CJc5e+jW1FvoAyk/rU9tJ3Duk+OYuOeZvz94yNyWj+ajmDWQ8pWSPUzQKB5n9SlOD/LgLGFWarvlTI0yuyXPAUWlqGRzu+U0mw8f3U1LAZt1CXoEoci0GlxelTdkoHQzzsaZYNEOcsWZcop3owPJVdv2UTW0BANArMh2FiPU04ZQfq03RGs3ZA++eeYdL2umijPDQQ0UhYgSxFIaDWCHNS43D5sDU4x3XvBTFwyrxKXnlKJC08aDQAYV5iFj35+Fu698MRQQz6vDzvq7ej2+lHf0Y3nPjwk37fUmv+cGaWYNy4fghDIAh0KNuYzB1dYSeSMoWKVk1Gnxc++fAJ+fPZkAIFtEiTK5nyHWtWZIKX2ruB5C765K4t3/WKgjgYACrKMmD8+sAxamnqSMzSKgMZmjqzp8flF7GkKrGqaUmqFXquRA59YPX7UGRo3dip6yABQ1UqFUy6/l36eLo96lROAiKwZDY1djbFXuGVSUz2AAQ1lCPahySzSp20pMyCtcJKmamIpzzWpLkuf6MMvO9w98s7X0Vb8KEnZlW6PD0fbQ8HEY+/sRbfXB3u3FzXBKZ5TJxbCoNOgPJgp2hV847aEpd7lAFvZ+0WvgdmgxUVzKwAEVmpJtynrd1qc7pgretrDMzQx+sPkZxtwwUmj8cltS3DDGRMBhDI0ykZoVnNkDU1gXH4YdRq5qWF28OcSa7m58voWhwc7G9Rvgr0FNMpNRpU/v/Aamt6yPDR4vmiIvYM9MzREg4A1NJlFekMOBTRShiZ6/YzEZtarpneyIwKawG2tTo+cdSjOUQdB4aQl/y5vj6pOptnhweFWF3Y1dsLnF1FuM6Ei+AZfkR8IaHYGP72GTzkpA2x5lVPw02xRthE5Jh38YqhWRZlZFEXg0yPteOPzRlV/GFEU0R48X+1dXvzvQKscOORaQufNoNPImY78LIPcEVgqGFZ+qg6tugoFNLuCPWcmlWRDG1xGLZ3nWDU0yoCm1emJ6Fvz788aoxYV9/j88iotZVGwSzHlJJ1brnJKjfBsm5I5Sr+jdMaAhjKCiX1oMor0Rt3p7oHPL8adoREEQV55A0RmaKTmetIqHYNOI2chYpGyKy6PL6Lw1+XxwREcW352aGsGKXMhvfmHv7CramikKafgp1lBEDAhuMRbmnZyhfXA+eZTH+DqP3+MOXe9if/uDPTO6fb65ULZ+vYuXPvnj9HjF7FsRimqxxXI31uQZVBN2xVkqbeUUGdoIpdtS1MMynof6ecS35STRz6POcGfz4ufHMG1f/lY1UsIAJyKv9cso1YOXpQZmlJr4OfNouChJ4oiPtzfGvN2TjkRDQL2ockcXp9f9Ym+s9srZ1P6CmiAUB0NEBnQZAczNFIfleIcY5+dTJVNGZWbVQKBgEbuSKyok5ECGilrECtDE75sWzK+KFCwu18OaNSBuNcXWhX06rZA8bBUPwMAx+xutDg9KMw24oGLZqnOW/iS9LywPbKiZWiUhZ9SkDYlzoBGFEXV9S1OD+qDTfzmjFFP9/3j48Oqy1L9jF4rwKjThjI0ihqaEimg4ZTTkNt+tAP7m50w6TVy/ZkSVzkRDQKTnhmaTBH+xtTR5ZWnnvqacgKAeWPz5f+HL00Oz9AU56h7sUQjBSNd3lCGRoqBurw98komZfAkTT2FP65ECpIC+zaFioIloQyNU35sQF3kLJH650SbchlflAWLQYeZo23y9//syyeojskPy9CYotXQKKaSdksZmtJQQBOacorShdnrU2190OJwo6E9ev3Sq9saVHVuUmZKOn/Svw7FlFOpTQpovOj2+nCkzdXvnb0pMS/X1AMAlkwrVQW4kkyroen74xJRGmBRcOZoc6rfmDu6vPIbZaweNErXnzERZ00rQUNHF+YqghsgVEOzX87Q9F4/A4RWKCkDhiklOdjZ2BmYcnJLb7qhYGOUIksUuI8YGRpv6I1Z+eIfOeUUOGZcURY+C+7NVJFvxpG2LhxqdaGpsztqQFMefLP/xkkVMOu1OPOEkojurZEBTe/LtqUdyMcrln1nG2OvcnKEBTm7jzng8fkhCJD34wIC038dXV5s2H0cZ08vDd6fevsK6eenbKwnZWg+PtiGGbe/jh6/iO+fPgH/75ypEWOh5PH7Rbz6aSCg+ers8ogibYCN9YgGBfvQZI7wjRDtXT2qZdt9EQQBJ5RZccbUkoiMjjQtJE85WePI0IS9KGcbdXKdjsvjk7MIyikn6U021n0oM4ZS0asyQzMuGCyEFwWPKwxtnzCnMk/+VPzJwXZ0dEVOuZQGV1uZDVp84+SKiOAFCAQSyjqaaMu2nR4fenx+1XiV95Vjil0U3BkW5EhBT0mOCTNGhQIaaSpMWuru84vyVJcUyGQpp5yCb6DKmqmeYCboo7rYdR2UHLuOdeJ4pxtmvRZfmlSEhRMLMW9sPr40qVA+JtO2PmCGhjICN6fMHOH9RJQZmngCmt4ouwUD8U05hWdXRueZ5amPLo9PLly1GEPHFYXdb0SGRjGNpVy2rXwMIPDcO7q8ctA0TpEVmVScjSyjDjsbO/HJoTbVbZLwZeyxFFtNoVVOinEoz3dnd4/8gUCvFVQryOQamihTTtLPLs+ih727R55+Ks81ocxmxj9vOBW5Fj1+v2E/gNCU4wW/2ywXCYd3e3a4Q52Cw4NHADganBoURRHtLq+8kouS54P9LQCAk8fmwaDTwKDT4G/XzkfNoTa50WSmTTll1mhpxOKUU+YI7ycSCGgCn9TjmXLqTXhxbjxTTkadBsq64dF5ZjkgcXp64FL0SZGY9Fo5uxF43OiN9YBQfYqyGDfLqJOzJodbXfKUk3KaZ2JxDqoqcgEA2490RJ1ykjon96VUkalSZop02tASb3u3V86e5VrUK6WyjbGLgh2K5fHTFVNMUvH2jFE2jM6zIDdYnNzm8sLd41OteArtmB5acRZeQwOE3kCPdXbD0+PHPf/eiaq73sSHwTdfSp4t+wLndP6EAtX1BVmh36VMy9AwoKGMwD40mSN8+a2924tGe6BVvs0ysIAmfNVTURxTToIgqKaMxhZkhQqFPT65ziM8aClR3LfUSE+ifKGXaoaMYZ9mpcLiQ60ueXplrCqgycaoYCanqbNbtcpJopyO6Y06KFC/CSmXbktBU37YyqjeGus53KHpwpPHhGqawuuMpB3O212eiExPVkRRcGjKSRlInjm1BEadBqIYaNb3ZDDrs2rd9hjPnPrD7xfxYXBaT+o4LVG2L+htj650xICGMoKyMyult9awouCDLS65eZeUkeiv8FVC8Uw5Aeopo/FF2aFme8oaGqP6vpVTIWa9OtjRagQYgsu0pTqR8D2qpIBG2YRuYnE2ym0mlNtMGFtgkcd/vNMtb3egVJ4bX4ZGmakKnyZQNteTsme5YYFlbxkaKcjJNukwd2xoVVP42KRpoTanN+J+suQMjaKxnlx7pEGwvx8uPGm0HCgdaQ8tseeS7uTa0+RAR5cXWQYtZo6yqW5T/o25Muz1ljU0lBGkNDqnnNKf9OaTZdDC6fHhzR2NEEVgQlEWiqPUSyTCEpahiXdKRh3QZMmbK7qUNTRhGRplkBA+1QUEsoaeHr9cMxTes6MimH2RAhpBCJyTN1cugiAEpoOKsgOPYe/ukfdpUsqLM6PVe4Ym8Lzqmp3ylgvhxcVS8XW0DI0c0Bh1OFmx6iw8W5YnTzl5Iu5HmmqSzmNglVOof8+/bzoNh1tdWDy1GE+/X4f9zU4caFYGNF6IoghBEPCPj4/gb1sP4/FvzZH3saLESL//FfkW6LTqAFg5FSm1NMgUDGgoIyj7fvj9IjSa3pupUepIb/CVBVn4osGO5uAOzgsmFPb2bXFRTk/MH18QddVPNDqNouldYRa2H+kAAHSpamjCMzShN8tYAU1Hl1cOiGJlaKTOvBa9FoIgqAIBq1kHg04DT49f3gFbqa+mgZJSRaBo0kXP0Nyq2OU71xIe0KgzNPZuL658+iNkGXU4Kdg8L8ekQ1GOEUU5RhzvdKv6BQHqgKavDI1y5ZRRp8WUUhOmBPviSBmarQfUK52O2d0otZmwZnMdPjtqx8Y9x/G1qshmcNQ3qe7Lao4eMBt1Grh7/BH1NemOAQ1lBGURprvHn3F7jIwk0pvZqFyzauO7BUl4cdQrPk2umD8m7u+TPpECgRVMFkVxauwMjbKGJkpAE3adUReeoQkENFJzvfAdu4FAwFKUbcTR9q6IbRkSoVy+Hp6hkep0lPKzYkw5dffA7xex8oVafHKoPXhsIFCRsjj/uelLaHN5URnW9DAveJ9tLm9EhkYKaMIzbEBk7ZEU0HwUFtB8drQDpTYT6oNN/VocnIbqL6kvkTXGqsONP12MfcedGRfQsIaGMoLyRTqeOhqp4ygNPanIdrTijdSo06B6/MBfHJX3Gb4FQO9jCr3BCoKg6h4stefvrYYmPNgBIgOH8NoVaYNLSXhhsSR8ifg9X5+JbKMOt557QtTjo1FmaMKzlz86ewpuDO7ILQnfLkEqCvb4/Phgfwve+qJJvu2TQ22q7ynINmJicTbCSbd7evyqABIAeoJbPYT38wEAQ9iUx+jgeQsP8D6vt6Pb65NXarGupv/sfaw6LLaaMi6YARjQUIZQFmGGb/QXzQ/++glOvfcdfF7fMdhDozDSqpgJRaEVPQ9fUpWUXiInlFnx1IqT8NbKRapsTaKkIl9lUXBEhqbPKSf144dnaMpzzVDGFhZ99E/DyoBGEIDzZ4/Cp7efjau+ND6OZxKgDFDCsyM2sx7fP72PgEbx3PceV099HW4NBBbjCtUZmXAWg1YOTg6F7Zl13BHIqmg0gupcGrSaiABsVG70x9m09zjq20NBTngDx3Ty2Dt7cevL2+VeO+lG2qw01pRTpmJAQxnDYlAXBnt9fnzrDx/gG09sRo9P/cLx352BT5hPvrcf/zvQGtHsjQaPM5ihmTeuAA98YxbWX78QS4Ot8JPh7OmlUTME8TgxuCeSsjjVGdaeX6KsM4nWjyNyykn9cqrXalTBSqxpUuXU1tiCLJgN2oRrxJTHd0UJ+M0GrSqLkxc25aTRhBrtNXREFicD6iXn0QiCIK+eCt8E9EuTiuT/K2uIws8ZAEwuyYZeG3o+3zqlEoIA/O9AG7YG970C0jeg6fH5cd/ru/CXDw6l7XLzUIZmeFWdMKChjCH1spDegP629TDe39uC/x1ow87GToiiiFe31eNQS+jFdP22enzjiS2qgkgaXA7FFM4FJ43GiaNzUzsgAGu/V43FU4rw2KVzACgCGk+oe254FqYy34LCbAMq8y3IiVL7Eb7PTbSgp9Ta+0opQJ2hmVzSv0ANAL576jgUZhtw0dyKqLePVWRYwjM0QCiga4wV0BT0HtAAoXobab+o5bPK8ex35uFsxfSgMnAMr58BAoHkWSeEjj9pTJ68p5fUjRhI34DGrsiQvfjJEXnz0VRqc3rQ7fXhs6MduPvfX8idmIdbhmZ4hWc0rKnehDw+PPTWHvm2z+s7YO/24oa1NTh5TF7E9/7z0wY8eumQDXVY63B5YTXroq7A8fr8cpo9POORSvMnFKhqAqRsibKwNHwZsl6rwab/dwaAyLoUIDKAifbmHKjDCUx7xhPQTCm1Rj0mHredNw0///IJMbM74wqz8MH+QKFt1IDGpAPsoYBGWnYPBAp14+kaG56hGVdgwWmTi1THKLdjCJ+mk1w0twL//qwRQGBJ+vJZ5fiorhV7FCvB0jWgCc8G7zvukFeKpUKHy4vqu9/GqFyzvKmrZKCdu9MNMzSUMaQVEk63DzWH21SFh9uPdsjLXj89Gr1uhj1sBu6zox2Y88s3cdc/v4h6u1NRfBseIKQTqV5G2pJAI0Sf/jDptTHfyMODgmjfr+wPE22VE6DudyNtVtlfvU1VlSt69kSrZwpNOQU+vU8tCwVXY/uon5HvV7H9ARAqNlZSTrFFO2cAcNqkIowtCGTGTii1YtmMUoTHz2kb0HSpGyTauyIbJvZmb1MnmjqjZ8n649Oj7XD3+COCGSDUo2i4YEBDGSO0D0xPxJLN7Uftcho1ViHegZbIP2hKzI56O3x+EduOtEe9XSpINeo0AyraHWzh2ZIsY/SMU2+UwYogRK7WAcJWSsUIjAoUreanlPZ/yqkvyu7A0WonpOkHqYbmhLJQcBVt48zojxG9YZ9SkSKAM8QIaLQaAa9cfyre/vEi5GUZUJhtjMi8tnd55Y0y00l4x+e+Apo/f3AQN6ytgafHj2P2bpz1mw2Y96u3kzYeTS+/18zQEKWIRVFDIy3ZnBpsxvVFgx0HW3pfpr3/OAOagXIGC05jvUhLt6fTdFM04QW6WTGyJ71R1scENsCMfONQHhOrKFh5TDx1Kv2l7PIbbay5wYBG3neqIEvOoMQ7rlj9bZTiydAAgdVZyuzV2dPUheWiGDm9kw46wjM0UbovS0RRxANv7MKr2+rxYV0L9hwLTakl+tx2H+vEgrvfxu/e3ae6Plr3Z8lwq6FhQEMZQ9pjRJmhqarMQ45RB0+PH+/tPq46fu7YPHy2eikumBPoJrovSidWSow0RdPZ3YM/bNyPi5/cgj9uqpNb6od6uqR3QBOeLbEY+64PCafcODJWLYgyixOrhqY814xHL63CX686JaINfTKdUGbFmm/PxX9u/lLU221hb245Jp0cyMS7qix8K4JoU04l1r7PWzRnT4/sOxTei6apsxsXPbEFL9Ucift+ky08EAkPcJSaHR55w9C9TQ74xFDGSeowHa8Vf/wQ9R3duPc/O1XXSzvdRzPcMjTp/apDpKCsoZFeyAqzDZg+yooP9rdGNNzLsxiQbdRhfLAfyiPv7IUI4IYzJiY8vUABUsDS2e3FE+/tR7PDjQ/rWpFt1OLiuZVyU710D2h0Wo285QDQzwyNav+k6IFISRyrnADgvBPLE378/jh9SnHM28IDmmyjHrd/ZRo+2NeCUyfGt23F+CJ14BNtdZgqQxPjvEUzpiAL1y+eiM5uLzbsaUZdsxMtDg8mKp7SPa/txEcHWvHRgdaUbYsg1dDoNAJ6/GLUbGa314df/esL1XTj3iaHKiDcfawTp8TZjPJAsxPH7Opmhj6/iKNtXb1maHKG2bLt4fVsaFhTZWiCBYF5FgOqKvPk1RtKUoHihOCLrKfHj9+8uRsLJxamdNVBJpMCGqdiywAAcjt6Z4x9kdKRxaCVA5rego1YlAGN1xe9lkN5TBqWe6iE78CdZdRiwYTChPbgUjZTBKLX0CgbFvY25RTNj5dOAQBc8LvNqGt2RmRodiaY1RgMUsalMt+C/c1OueeL0l8+OIg/f3BQdd2eJgemlYcKsXcdi/+5/G3rYdXlji4vHnxzN9ZsPtBroflwC2g45UQZQ66h8fSgLRjQFGQbMKcyenCSG5zPD0+X72y0Rzuc4qAMYpSktLqjOzNqaAD1tFN/xqvsLBxrxY3yfntL/aeD8HqK/rzZldvMqmxVX1NOyk1DEyF9WGkJO+/KAEcUUxNBSn8L0uak0aacnFF2sd7X5JA7+ALA7sb4p8jDt4k42taFNZsPAOg9MBrMKc5UGF7Phoa1bMWUU6sqQ5Mb9fhQhiYLN5wxUW5DvzsNPsVlqljbTkhpdUeG1NAA6iLdaJsmJltvtRTpINccnqFJ/JxoNAJG54WWeEcLFAsUS8adcWxjEo10H21OdQCjDHDaXak539LPuTIY0CiDFImIyGCrxenBodbQwoWdjfa4g7IWp3q66XCMfewKswe+/Ug6Y0BDGUMq3HS6e+SAJj+4pDOavGAKXRAE/OjsKbjvwlkAEkvlklq0T5ZA6EU8NOWU/gGNMsNSrpgaSrZlMwKrcy6fP3bQHiMZImto+vczLFFMKUW7D2VWoL9BnlR7IvWi6vL48L8DbaqWDU1hG2QOFakoeExB7AxNeLAlfdj65GC7fJ29uwfH7G74/SJ++9YevLXjmOp7HO4eOeCRFklI5/vTKG0VfnHeNLlR5HCVcECzYcMGLF++HOXl5RAEAS+//HKvx69btw5LlixBUVERrFYr5s+fj9dff111zJo1ayAIQsRXd3fymgtR5stSTjm5QgENEH0uPrwnxpTgEu9dwW0SKHGxMjTtXV7sauxEXbDXTyZkaLYrGjBevmBsv+4jfPuDaB67dA4+vvUszBhl69djDBWbJTkBjXKptbaPPan6G9BI2Y8DwVYN33t2Ky56covqmGQ2p0tEe9iUU5fXF9EbK/x5nzwmsKQ+/MPW/mYHPjrQigff2o2rnt0qNw/95FAb5v3qLfzkH58CCE29zaoI/I69s1O94hMITCnG0+05kyUc0DidTsyaNQuPPvpoXMdv2LABS5YswWuvvYaPP/4YixcvxvLly1FTU6M6zmq1oqGhQfVlMg3epybKPFLh5jG7Wy7ClAKadT9YgHnj8nHd4gny8eGdXCcWZ0MQAl1Mmx3p178iEzhiZGh2Ntix9KENWPfJUQCZEdBIG1XOHZuHUbnmPo6OLj+OHcQ1GgEFMbKI6STXrH4u/f0ZKot++9LfaSGp0d/+Zge2H+nApr3NEcc02VOToZEa61Uopt7C66fa5VWaRtx67gnyh61wB5pdquXbP3tpO3p8fnz98c1weXz4x8dH4PeLcsZa2jdtR0NknaBUE5VoIXYmSfiZLVu2DL/85S/x9a9/Pa7jH3roIfz0pz/F3LlzMWnSJPz617/GpEmT8Oqrr6qOEwQBpaWlqi8iJekFVtonxmIItaWfXm7D366Zr1qWmhf2idOk18p9NXZz2qlfwjM0FfmBQCC8WDjact108+uvzcQPTp+Ap6+c2+/7+P7pgQD6rBNiL4fOFMopp4F0ev7m3EoAQPX4/JjHSF0TpN+fREnLw4+0deGpjfujHpOKKSdRFOUMTX6WQf47CM/ISMf8+mszcNWXxqtWwwGQA+yDLU45KwMAH9W1RjTOa3N55I7JJ/aSBZQCGmnn8/DXx+FgyF91/H4/Ojs7kZ+v/mV3OBwYM2YMfD4fZs+ejbvuugtVVVUx78ftdsPtDv3C2u1cuTLcSQGN1Mk02gZ7ynqaaPvVTCrORl1z4EViYZy9NSgkvIZmTH4WDrd2RRyXCRmaGaNsA54GunReJaaVW3HCADaVTBcmfag3z0CW844rzMJHPz8zoiZH6dXrT8Wj/92Ln5wzpV+PUZgdCBY63T14dVs9gECWtsRqwrNbDuDJ9/anZMrJ4e6Rg4tcix5Wsx6d7p6IbsFSZkqaFi8LC2hmVdhwtL0LdVGWfb/1hbqWRpqmyjHpIvoAKeUYAz+Pey+Yid+9a8E350XflT2TDXnu6YEHHoDT6cRFF10kXzd16lSsWbMG69evx9q1a2EymbBw4ULs2bMn5v3cfffdsNls8ldFxfD74ZBaVlivkIIoFfulVhOyDFrYzPqIVRtA6IUjVfPrmS48QyMVPobLyoA+NMmg0QiYU5kXc1uDTCIIghyEDDQgLc4x9doFeMYoG55YcZLcIypRgiBgnKLnzfjCLFRV5GJUrlmu4RmKDM22w+1yxhgIZWKMOg1Meq28FD4iQxOccpJ6/4RnaKSpowOKDI2U1foibJXm50cDH+YLs40YV5glNxINJwWpBdlG3HreNEwsHthGqOloSD9GrV27FnfccQdeeeUVFBeHUrTV1dWorq6WLy9cuBBz5szBI488gocffjjqfa1atQorV66UL9vtdgY1w1z40tpoGRqzQYt/fH8BtBohao8FKYPT3MkamkT5/aK89YFkdJ4FWo0QsUlgJqxyokg2sx7HO90Z8fMbX5iFT48ECrvPmlYid/+WOhEfH+Qamvr2Lpz/2PsAgLq7vwxBEORaFilQkTYBVXYL9vtFOcCRPnQp9/MCQvVduxV7O80fX4DN+1oiCoyl4vb8LAMMOg1ev/k01B5uh1Yj4PI/fiS3UhhuTfSiGbJn+MILL+C73/0u/v73v+Oss87q9ViNRoO5c+f2mqExGo0wGtO/0I6SJzxDE6sg84Sy2On/wuCLXbMjNQWDmczljSwIzrPoYTXp0BZW3JkJU04UKTdJGZqhIK10AoAzp4Y+IEsBzWBnYZWb4TZ0dKM814yNewLFyZOC2Q8p46WcNup098hdo6UMTniGZlqZVd46AQjU1IwpyMLmfS3yMeU2E+o7uvFZfSCgkXrz6LUazA1uRJqfZZADmmhNDoebIZlyWrt2La688ko899xzOPfcc/s8XhRF1NbWoqysbAhGR5nCErbfjvIFLV5yhoYBTcJc7sgl27kWfdRaieG8kmI4k36WmVDUrfxAo9zKpNiqnnI63unGzc/X4IP9LUgmaUNWIDD1BECu51k+K/DeFW3KSVoFZdaHFjWEv7ZZTXqMygsVTE8qyUZRjvoD/KyKXADA/uOBVgnRVtJJdYQGnSahjUAzVcK/tQ6HA3v37pUv19XVoba2Fvn5+aisrMSqVatw9OhRPPvsswACwczll1+O3/72t6iurkZjYyMAwGw2w2YLpNVWr16N6upqTJo0CXa7HQ8//DBqa2vx2GOPJeM50jBh0Gmg1wryku1YSx17I3XK5LLtxEXb9iDXYoga0IS/+FJmkHrRZEKG5hsnV2DT3mYsmVaiml6WMjQujw8Odw8ef3cvXq6tx8u19ThwT98fqOOl3PRx25EOTCjOxs7GTui1As6ZHghobFECmvYu9bSURJmR0WgETCrOkbNA584sQ3fYVNOJo3Px788a5csFUTLW0nXWEZCdAfoR0GzduhWLFy+WL0t1LFdccQXWrFmDhoYGHDp0SL79ySefRE9PD6677jpcd9118vXS8QDQ3t6Oq6++Go2NjbDZbKiqqsKGDRswb968/j4vGqbMei28vsALyeSSxAsKpQzNcYcboihy1+0EOGNkaJR7AD1x2RxYDDpV+3vKHNIbcCZMT2QZdfjDFZFL7rOMOmQZtHB6fGiyd6t63fT4/Enbv0jZW2bb4Xb5w9KpEwvlwFDKIh1XFChL4wn/IGA2aFVB0k/PmYJp5VacP7scE4qy8frnoeAlz6KPKMiPtkhCqjOMtknocJTwb+3pp5/ea5dVKUiRvPvuu33e54MPPogHH3ww0aHQCKRc/jimIHo1f2+kzIGnx49Odw+sI+QPPRmiBjRmg6ob7KLJxcNixc9IdfKYfPxp84GYG75mimKrCXXNTjR1ulWN/nYd68T08uR0bFYGH58d7cDs4J5yytel0cFpo6OKzSPbXNEzNFkGneo+J5fkYOWSUBZamfUszjFF1N1Em3LKD27QmwlF3skwMp4lDUv9afxl0muRbdTB4e5Bc6ebAU0CpBVOUq8SIPCi3K0oFmYwk9nOPbEMZ0w9J+N/jkU5RjmgcSl6J31yqD2JAY260Pfz+sDyaWXGUgpopN2w/+8/O/F4sDFeeGdmSx+tDooUAUux1Yhym7op4dgoLRTyswLfMxJWOAHcnJIyVPiKp0SwjiY+Pr+IP2zcj8+Cy0KlnZHHFWRBpxFQmG2ESa+VGx3S8JDpwQygWOlk71YFHjWH2pL2GOHN8g40B4pzlfUq0tRro70bPT6/HMwAkQHMt04ZAwCYE8z0hAvP0BTnGDFrtA1jCix4csVJcu8aJaknTax+UcPNyAjbaNip7Md0k6Qw24gDLS40O9xod3ng7vGjxMp9w8K9uq0ev/zXFwCAA/ecK3/SHZVnxurzp8vZrfC+GESpJjXXO97plpctA0DtofakPUZnWEBztD2QhVFmfYuyjTBoNfD4/Gi0d6t6NhnCMsxXLhiL8UWBBoHRmPRa5JgC01IlViM0GgEvX7ew1zrAJSeU4LmrTsGM0em9MWqyMENDGeUnS6fAYtDigW/M6vd9SIXBR9u6cMYD7+HMB97r966/w9n+4CdOINBKQcrQWAxaVI8vwLTyQL+f25dPh0YAbj5rUkrGSRROqptp6nSrMimHWl0RTSD7K3zDSel+reZQnkCjEVCeGwiujrZ1wRJcpl2YbcTl88eqvl+rEbB4SrG8HUI0UuZJ+revRQ0ajYAFEwtHzNQ6MzSUUa5bPBHXnDZ+QCsVCnMCLxiP/HeP/GJ3sMUZNWU7kimXgR53uOWi4KywnhnzxuVj+x1LM2KpL40MyuZ6DkVA0+MX0exwJyUjG56hkYQHD6PyzDjQ4sLhti75Q8G/bjy1X2MYV5iNfcedve7ZNJIxQ0MZZ6DLLqUMjfKTm9SynEKUjcM+PtCGV7c1AIhevMhghtKJvJ+TXT3lBAS2LEiGTncgQyPtjC2xhi3HHp0bqF/Zd9whdwju79/Lr742A0+tOAmncmPdqPgqRCPOxOLITzcMaCIp3wi+/9dP5P+PlCWglLlKFFNOUlcBaXfuxo7kbIkgZWhG55nl+hkgeoYGAHYpNpWUpp4SVWI14ezppf363pGAGRoacZbNKMMzV87FE5fNwfzxBQAY0EQTre/MqFwzzpnBF1RKb1KGpqPLK+8zNinYiLM+yQFNRdgWLMoaGiC0dFsKaLIMWmg0bOg5GBjQ0Iij1QhYPLUY58wok7dPGCkBzb7jDiz77UasD+450xuHW73VwYmjbXj/ljOS1seDaLBYzToYwvYTm1wS+Ftv7Bj4lJMoinJR8Og89ZRTeAZT2klbyuJwenbwMKChEU1qTT5SApq7X/sCXzTYcePamj6PDc/QLJpcNFjDIkoqQRDkaafA5dBU80AzNH/732FMufU/8p5yFYptPrIM2ogav/BVSwxoBg8DGhrRpN1odzZ24hevfIY9xzr7+I7M1pPAklWXhwENZS5lsW62QYfy4OWGARYF//TFT+EJFswLAuT7BSILgoEoWxz00RGY+o8BDY1o0tLk2sPteHbLQVz5zP9SPKLBVahon97j670hnrIoeFqZFbNjNPwiSkfKDVKzTTqUBfc+SlZRMBCYXsrLCgUs0fq9RNuziQYHzyyNaPlZ6nTw0SQt6UxXyhfcho7uiIJGJWewhubpK0/GosnFqk0oidKdsrYl2xjK0BzrdMPnF/v9+1yYbZC3TTHqNKo9mcILggHArNfK3YKlsdDgYIaGRrTwgCZcl8eHm5+vwatxFNFmAndPqND3sj9+iAt/tzlml2RlIz0GM5RplBmaHJMOhdlG6IJbDzTa+5+lUX4oaHZ4VBmYaBkaQRBgUxzDGprBw4CGRrS+Apo3vziGl2vrccPaGhxscfZ6bCboUuyMfbDFha0H2/Crf+2Ieqw05cQXYMpEqgyNSQ+tRpBXOm3Z19Lv+w3flNKk18orqqLV0ABArpkBzVBgQEMjWl6UfVMOtjix/7gDQGC3XsnqV6O/8WeSLo8v4rq/bT0i76it5AoeyxQ5ZSL1lFOgEHfJtBIAwH8+a+z3/Ybv4QSEAhblTtuq25UZmmGwm3m6YkBDI1q0qZRF972LMx54Dw53DxoUBYT/3dmEbm9kQJBJumKMf+uBVtVl5WaU/ERJmahUsVeSFJxLTSHf+uIYLv39BxG/933x9PjhDu4uP7siF2u+PRdAKGCJlaGxKeps+Pc0eBjQEMVwpM0VsSIifF+YTBOeoZlWFtgx+7jDrbre5fFBlPed4SdKyjzKfjBSndjU0hxUBgvhN+9rwXMfHkroPpXZmX9cOx+nTykGANiCgUxOHBkaZjwHDwMaohia7G7Uh3UVdcTYYTdThGeYzp4eSMEf71QHNFJBsEYIrNIgymQdwe0PBEHAj86eHLo+RkF8LNJ2B+EN9KQVVKU2c9TvYw3N0GBAQyPeNYvGQxBCn7IkjfbuYZehkVLvF540Gi9cXY3y4AtwU1hA41CscBIErnCizHTWCYEMymXVY+Trzp89Co9eWgUA6Ezw71kKaHLCVjPdsmwq7rvwRJwTY+NIVQ0NM56DhqEijXi3nDMV1y2eiF/98wu8sPWwfH19exeOBYuCswxaOD2+qBs2ZhKphuZbp1SiqjJPDnDCMzTS9fw0SZns4UuqsP1IB04em6+6Xpr26Uww4ypNOYVPLZXZzPjGyRUxv8+mWHzAKafBwwwNjXiCIMBq0qMox6i6fvuRDvhFQKcRMKYgCwDkQtlMJU05mYMrLaTnHB7QhJZs89MkZS6LQYdTxhdEFP9LGRaHO7EpJ7ucoUksKFFOOVnYKXjQMKAhCirMVi/hrjncDgAosZrkDqDhO1BnGinzItXFSAFNi9MDn2KfJyd70NAwJi2vTjRDY5czNNFXM8XCouChwYCGKCh840ZpB+4ym0l+EcrkKSdRFOUpJylDU5BlgCAAPr+o2nFcWUNDNNxkBwMaR3cPRDH+DVulACjW8uxYclXLtpn1HCwMaIiCqscXRL2+LNcsZypaHG5s3tcMbx8bO6aTPcc6cbS9C+4ev7wUW8rQ6LQaeYNO5bSTtI8TMzQ0HEkZlh6/iG5v/H/LsWpo+sIMzdBgQEMUNGOUDS9ftxD/uflLquvH5FvkN/b739iNS3//IR5+e08qhpiwdpcH5z2yCRc9sUW1ZFu5FFvagVvZi8YVrBXK5qdJGoYsei2kxXudCdTRdPazhiYvmAnVCIlPV1H8GNAQKcyuyMXk4hzVdV+ZXR7xqer3G/cP5bD6bd9xB9w9fhxt70JzMGAxaDWqHhrRCoOlKScLP03SMKTRCP1a6SRlaKJtQtmbbKMOq78yHau/Ml2e7qXk46sVURiNYkWERgAml+RE1JKYMqTZ3JG2UGPAQ60uAIBJr/4cIwU0TZ2hnjvtwUZk4b15iIYLq0mPzu6eBAOa/mVoAODy+WMT/h5KDDM0RFHMGxfoW3HrudMAhIoIJSZdZgQ0R9sVAU1LIKAJ/4QoBzT2UIZG6r9TEraUnWi4kDI0iXT/HkhAQ4OPPxWiKB68eDa+qLfjzGCn0fBakkxJGx9VZGgOBjM04VsZSJv4KTM0jcGAptRmAtFwlCMv3Y5eQ+P1+eFy+2BTFPT2d8qJhgYzNERRjMo146xpJXLb//DVPkZdZvzpRM/QqJ+LtA/N0bYuiKIIURRxLLjlQ4mVAQ0NT1LWNdr2B6Io4rt/2op5v34LHx8M7chtj7H1AaUHZmiI4hAe0BgyJaCJmqFRj32UFNC0d+GbT32AdpcX9R3M0NDwJgUl0WpoXqmtx4bdxwEAP/3Hp/jXjV+CRhBwpC3wN1TGv4u0lBmvykQpFr7KSbkE+sWPj6D612/js6MdQz2sXomiqM7QtEavoZEyNM0ODz6sa8WuY50AAEEILekmGm5yTNFraHp8ftz97y8ABBYF7DvuxN+3HsbuY53w+kTYzHqMzou+qzalFgMaojiEr3JyKrZA+NHft6HR3o1bX/5sqIfVq3aXV97qAAA8PYEGYma9+rnkWfQRdTVAIJjRa/kSQcNTjjF6Dc2Rti4cs7th1GnwnYXjAAB7mxzYUW8HAEwvt3IH+jTFVyuiOISvaoi2SWX8DdSHhjI7oxSeoREEAeW5kSn0UtbP0DCWE2M/pwMtTgDA2IIsORNz3OHG5/WBDOz0cusQjpISwYCGKA7hNTTR9nSyptlSzk8OtQGIXNUUXkMDhKadlFgQTMOZvGw77G/5QHMwoCm0oCgn8DdwvNONz+UMjW0IR0mJYEBDFIfwDeW8PhHuHp+qliadlnLuauzEr18L1AFcMq9SdVu06aVoNQElVtbP0PAlFQXbw6acDgRXA44tyEJhdmCfs6ZON3Y0hKacKD0xoCGKgzFKIz2X2yc3oAMArSZ95tX/8sFBdHv9OHViIVZ9eSqUQwtftg0A5bbIgCZTuiET9YdcFByWoamTMzRZctPJgy0uuDw+GHQajC/KHtqBUtwY0BD1k8Pdg4aOUECjLMBNNWlfpqXTS6DXalTTR+FbHwDRp5x8/nSrCiJKnuwYNTQHFTU0RWGdsscWWNLqgwupMaAh6ieXx4dGVUATfwv1wdbq8gAAci2BlPkPFk+Ub4uWbRpbaAn8W2DB9YsnIs+ix7cXjh38gRKlSHGwPqahPdBQEgh0Bz4c7N00rjAL2UadqonmmIKsoR8oxS29qhiJ0liOSaf6NBeeoXGmUYamzRkIaPKzAgHNiuoxAIC//e8wlkwrjjh+TmUebj33BJw4OhfzxuVj5ZLJqk06iYabinwzNELg7/a4w43iHBOOtHXB5xdh0mtQnGOEIAgoyjHKm7yOLbCkeNTUGwY0RHH6749Ox8EWJ259+TPsbOyE092jqqFxRVn5lCptwQxNXjBDAwSCGimwCScIAq760nj5MoMZGu6MOi3Kc8040taFA80uFOeY8PethwEA4wuz5b8BZUDDDE16S3jKacOGDVi+fDnKy8shCAJefvnlXo9ft24dlixZgqKiIlitVsyfPx+vv/56xHEvvvgipk2bBqPRiGnTpuGll15KdGhEg6oox4iTx+bLyz1dnh40dIR6vaRLDY0oimhzBVZuSBkaIoo0rjAQoBxodmLTnmY8/u4+AMAPFk+Qj1F2yx7LgCatJRzQOJ1OzJo1C48++mhcx2/YsAFLlizBa6+9ho8//hiLFy/G8uXLUVNTIx+zZcsWXHzxxVixYgW2bduGFStW4KKLLsKHH36Y6PCIBp1F7l+hrqGJ1mxvqB1qcWFHg10u6M21pM9ScqJ0IwUodS1OPPrOHgDApadU4rwTy+VjChQfCsZwyimtJTzltGzZMixbtizu4x966CHV5V//+td45ZVX8Oqrr6Kqqko+ZsmSJVi1ahUAYNWqVXjvvffw0EMPYe3atYkOkWhQZQd70rg8PWgKriYCAsu4U6nb68O5j2yU63wsBi2XXhP1YmwwQ/PmjmPY2+SARgCuVxTQA+rVftFWA1L6GPJVTn6/H52dncjPz5ev27JlC84++2zVcUuXLsXmzZtj3o/b7Ybdbld9EQ0FaV8nh7sH9q5QUy6Pzy/vl5QKB1tcqqJlZf0MEUUaF1zdt7fJAQA464SSiKBFmXnlku30NuQBzQMPPACn04mLLrpIvq6xsRElJSWq40pKStDY2Bjzfu6++27YbDb5q6KiYtDGTKSUZQz1rwhf2dSVwjoaaTdtCetniHoXXhPz7eBmlErfCxbLf2VWecRtlF6GNKBZu3Yt7rjjDrzwwgsoLlYvHQ3fvVQUxV53NF21ahU6Ojrkr8OHDw/KmInCSdsgKFc4SVJZR3M4LKBh/QxR7yryLXKfmR+eNRnzJxREHFNVmYcPf3YmHrx49hCPjhI1ZMu2X3jhBXz3u9/F3//+d5x11lmq20pLSyOyMU1NTRFZGyWj0QijkXvN0NCTMjRSQGPQaWAxaNHu8qa0uR4zNESJ0Ws1eGLFSWhzevC1qlExj+NGrZlhSDI0a9euxZVXXonnnnsO5557bsTt8+fPx5tvvqm67o033sCCBQuGYnhECZFqaKQVTlaTTr7OmcLC4CNt6oCGNTREfVs8pRhfnzO61xkBygwJZ2gcDgf27t0rX66rq0NtbS3y8/NRWVmJVatW4ejRo3j22WcBBIKZyy+/HL/97W9RXV0tZ2LMZjNstsA27DfddBNOO+003HvvvTj//PPxyiuv4K233sKmTZuS8RyJkkrK0EgBTY5JD12wWDCVU07M0BDRSJZwhmbr1q2oqqqSl1yvXLkSVVVV+MUvfgEAaGhowKFDh+Tjn3zySfT09OC6665DWVmZ/HXTTTfJxyxYsADPP/88nnnmGZx44olYs2YNXnjhBZxyyikDfX5ESZdrDtSmSAXB2Uad3JsmVUu3RVHE4dYu1XXSbsJERCNBwq94p59+uryRVzRr1qxRXX733Xfjut8LL7wQF154YaLDIRpyeWGZD2XgkKoMTbPDgy6vD4IASH+e6dK5mIhoKHC3baIEFYQFNNlGHSwGaTuE1AQR0nRTmaJ4cXq5NSVjISJKBeakiRKUnx2eodGjxx9oqOdM0QaVzY5Ax+JiqwnPfncePq+3Y9HkopSMhYgoFRjQECUox6iDXivA6wvM7eSYdHAHOwQPVYZGFEXsbXLAatajxGqSG/plGbWYWJyDicU5QzIOIqJ0wYCGKEGCICDPYpD3ccox6aALBhRDUUPT5vTg67/bjLpmJ/Iserx/yxlyIGXW80+aiEYm1tAQ9YNySXSOaWhXOb2xoxF1zU4AQJvLi8OtXXJDP4uBm1ES0cjEj3NE/aAOaPTyyqKhyNBs2N2sulzf0SVPOTGgIaKRihkaon5QBjTZRh2yg0u37V2DG9D0+PzYuOc4gNBeTY0d3XB5g1NODGiIaIRiQEPUD+FTTgVZgX3FWpzuQX3cbUc6YO/ugdWkwznTSwEADR3dzNAQ0YjHKSeifggPaLKD+6S2ODyD9pj7jzuw8m+1AIAvTSrC6DwzAKChvQvSNjRSPxwiopGGGRqifigIq6EpDEY0Uj+YwXDHqztwsMWFUblm/OjsySi1BQKaRnu3YpUTMzRENDLx4xxRP+SFZWhyTIF6FpfHB5enJ+mZki6PDx/sbwEAPH3lXIwvypY3x6xv74JBG/hswiknIhqpmKEh6ofwouAsgxYmfeDPqbkz+dNOHx1ohafHj3KbCZNLsgEApbbANgcNHYoMDQMaIhqhGNAQ9YNUBCwIQJZBB0EQ5Gmn44Mw7bRxd2Bl05cmFUEIFsyUBaecXB4fjnUGsjWsoSGikYoBDVE/jCmwoNxmwtwx+dBoAgFGQTCgaRmEgGbT3kDvmVMnFcrXmQ1aeen2/uOBRnucciKikYof54j6waTX4t2fLIY2GMwAQFFw08rmJK90EkUR+447AABVlbmq20qtJrS7vPJlTjkR0UjFDA1RPxl0GlVAM1grnRzuHnkjTGmqS1JsNakuM0NDRCMVAxqiJBmsgEbKwJj0mogMjHL5OABYuDklEY1QDGiIkqRQnnJKbkDT6gxMYeVZDBG35YcFNJxyIqKRigENUZIUyBma5NbQtLniD2g45UREIxUDGqIkiTbl5POLuO3lz/BK7dF+36805ZSXpY+4LXzKiZ2CiWikYkBDlCRStkS56uh/B1rx5w8O4qbna7G3ydGv+413ysmk18hLyImIRhoGNERJkmUMZEec7h75us7u0P/v+ueOft1vey9TTgXZoevYVI+IRjIGNERJkhUMKNw9fvT4/ACAzu5Qtua93cfl4CQRrXJAEznllK9Yxs3pJiIayRjQECWJxRgKKFzewN5KDkW2JtrleLTJNTS9TzlpOd1ERCMYAxqiJDFoNdAFgwqXOxDQKKecAKDb60/4fnubcrKaQtNM3cEgiohoJGJAQ5QkgiDIy6adnkAgE56R6U/Q0eqMnaGRNqoEgC4GNEQ0gjGgIUqiLGMgYyJlaBxhGRp3T+JBR3svNTRKzNAQ0UjGgIYoifrK0Lj7MeXUW2M9JWm/JyKikYjrPImSSM7QBAMa5SonAOhOIEPj84t4dVu9XHcTbcqJiIgCGNAQJZGUofnXp414/qPDONDiUt2eSFHwA2/swuPv7pMvZ/WxrYHARU5ENIIxoCFKIqkXzYufHIl6e7x1LnubHPj9xv3y5fGFWaoCYKUXrq7Gz1/+DHd+ZXqCoyUiGj4Y0BAlkcUY/U8qP8uAVqcn7gzNHzfth9cnYvGUIlw+fyxG55ljHnvK+AK8tXJRv8ZLRDRcMKAhSqJY00KF2VJAE1+G5khbFwDg3BPLsXhqcdLGR0Q0XHGVE1ESxdpPSdqJO96i4BZHYGVT+G7aREQUHQMaoiTKMkbP0BTlBAOaOKecpB22lZtPEhFRbAxoiJIoVoamILiJpDuOKSdRFOWAJp8ZGiKiuDCgIUoiS5QaGqNOI18fTw2Nw90DT3C37gLFbtpERBQbAxqiJIoW0Lh7/DDpNfL/ozna3oVzHtqA5z86JNfPmPVamPvoPUNERAEMaIiSKCvGsm2TvvcMzft7mrGzsRPrPjmKFk43EREljAENURJFy9AAgFEOaAIZmv/uPIb69i759o6uwBYJ9m4vC4KJiPqBAQ1REsXM0OgCf2rdPT5s3teM76zZiuue+0S+XQpoOrq8aHW6AXDJNhFRIhjQECVR3xkaHz6qawUA1BxqR5O9G4A6oAlNObEgmIgoXgxoiJIoK8qy7TKbKZSh8frx2dEO+bZ3dx8HEJhqAgCXx4cmezBDwyknIqK4JRzQbNiwAcuXL0d5eTkEQcDLL7/c6/ENDQ249NJLMWXKFGg0Gtx8880Rx6xZswaCIER8dXd3Jzo8opSyKBrr/fScKfjel8bhL1edoioK3q4IaN7bFQhopAwNANQ1OwGwKJiIKBEJBzROpxOzZs3Co48+GtfxbrcbRUVF+PnPf45Zs2bFPM5qtaKhoUH1ZTKZEh0eUUopMzSj8yz4+bnTMKEoWw5ojrR14VgwAwMAG/Ych98vMqAhIhqghDenXLZsGZYtWxb38WPHjsVvf/tbAMDTTz8d8zhBEFBaWhr3/brdbrjdoTcGu90e9/cSDRazPpShMWhDnxekPjQOdw8AYFxhFg62ONHZ3YNmp1sV0BxqdQEIbGhJRETxSZsaGofDgTFjxmD06NE477zzUFNT0+vxd999N2w2m/xVUVExRCMlik2jEeT/l1hDRb0mvbpYeHZFrrxh5bEON+xdPRH3xaJgIqL4pUVAM3XqVKxZswbr16/H2rVrYTKZsHDhQuzZsyfm96xatQodHR3y1+HDh4dwxESx/eaiWbj5rEmoqsyTrzPp1AHN+MIslFgDU6qN9m7YFRkaSZmNU65ERPFKeMppMFRXV6O6ulq+vHDhQsyZMwePPPIIHn744ajfYzQaYTTyEyyln6/PGR1xnTTlJCnLNaPEasL2ox042OKU926S6LUCirL5+01EFK+0yNCE02g0mDt3bq8ZGqJMYgybciqzmVBqCwQsu491RhxfZjOrpq+IiKh3aRnQiKKI2tpalJWVpXooREkRkaGxmVAanHLafcwRcXx5LqebiIgSkfCUk8PhwN69e+XLdXV1qK2tRX5+PiorK7Fq1SocPXoUzz77rHxMbW2t/L3Hjx9HbW0tDAYDpk2bBgBYvXo1qqurMWnSJNjtdjz88MOora3FY489NsCnR5QelCuegEAGpkQOaCIzNOW55iEZFxHRcJFwQLN161YsXrxYvrxy5UoAwBVXXIE1a9agoaEBhw4dUn1PVVWV/P+PP/4Yzz33HMaMGYMDBw4AANrb23H11VejsbERNpsNVVVV2LBhA+bNm9ef50SUdgRBPX1kNmjlgMblidyBexQDGiKihCQc0Jx++ukQRTHm7WvWrIm4rrfjAeDBBx/Egw8+mOhQiDKSXhsIbkp7WcXEgIaIKDFpWUNDNJzlWgIN86QMjSRLsbElp5yIiBLDgIZoiOVZ9AAAq0mn6ixckW+R/8+AhogoMQxoiIZYXjBDIwiCqnmedD3AVU5ERIliQEM0xJTZl+vPmIhxhVnIMmhx9WnjUWo1oaoyFxZDWvS8JCLKGILYV8VuhrDb7bDZbOjo6IDVak31cIgi/GHjfvz1w0NY+73qiIJgURQhCAK6vT7otRpo2VSPiEaIZL1/M6AhIiKilEnW+zennIiIiCjjMaAhIiKijMeAhoiIiDIeAxoiIiLKeAxoiIiIKOMxoCEiIqKMx4CGiIiIMh4DGiIiIsp4DGiIiIgo4zGgISIioozHgIaIiIgyHgMaIiIiyngMaIiIiCjjMaAhIiKijKdL9QCSRRRFAIFtyImIiCgzSO/b0vt4fw2bgKazsxMAUFFRkeKREBERUaI6Ozths9n6/f2CONCQKE34/X7U19cjJycHgiAk7X7tdjsqKipw+PBhWK3WpN3vcMPzlBier/jxXCWO5yx+PFfxG6xzJYoiOjs7UV5eDo2m/5UwwyZDo9FoMHr06EG7f6vVyl/2OPA8JYbnK348V4njOYsfz1X8BuNcDSQzI2FRMBEREWU8BjRERESU8RjQ9MFoNOL222+H0WhM9VDSGs9TYni+4sdzlTies/jxXMUv3c/VsCkKJiIiopGLGRoiIiLKeAxoiIiIKOMxoCEiIqKMx4CGiIiIMl5GBjR333035s6di5ycHBQXF+OrX/0qdu3apTpGFEXccccdKC8vh9lsxumnn47PP/9cvr21tRU33HADpkyZAovFgsrKStx4443o6OhQ3U9bWxtWrFgBm80Gm82GFStWoL29vc8xbt++HYsWLYLZbMaoUaNw5513qvapaGhowKWXXoopU6ZAo9Hg5ptvHtA5iWY4nKdNmzZh4cKFKCgogNlsxtSpU/Hggw8O7MTEMBzO17vvvgtBECK+du7cObCTE2Y4nKsrr7wy6rmaPn36wE5ODMPhnAHAY489hhNOOAFmsxlTpkzBs88+2/+TEkO6n6vu7m5ceeWVmDlzJnQ6Hb761a9GHDMUr/HA0J6rX/3qV1iwYAEsFgtyc3PjHuOQvR+KGWjp0qXiM888I3722WdibW2teO6554qVlZWiw+GQj7nnnnvEnJwc8cUXXxS3b98uXnzxxWJZWZlot9tFURTF7du3i1//+tfF9evXi3v37hXffvttcdKkSeIFF1ygeqxzzjlHnDFjhrh582Zx8+bN4owZM8Tzzjuv1/F1dHSIJSUl4je/+U1x+/bt4osvvijm5OSI999/v3xMXV2deOONN4p/+tOfxNmzZ4s33XRT8k5Q0HA4T5988on43HPPiZ999plYV1cn/vnPfxYtFov45JNPJvFMBQyH8/XOO++IAMRdu3aJDQ0N8ldPT08Sz9TwOFft7e2qc3T48GExPz9fvP3225N3ohSGwzl7/PHHxZycHPH5558X9+3bJ65du1bMzs4W169fn8Qzlf7nyuFwiNdee6341FNPiUuXLhXPP//8iGOG4jVeFIf2XP3iF78Qf/Ob34grV64UbTZbXOMbyvfDjAxowjU1NYkAxPfee08URVH0+/1iaWmpeM8998jHdHd3izabTXziiSdi3s/f/vY30WAwiF6vVxRFUdyxY4cIQPzggw/kY7Zs2SICEHfu3Bnzfh5//HHRZrOJ3d3d8nV33323WF5eLvr9/ojjFy1aNGi/7EqZfp4kX/va18TLLrus7yc8QJl4vqSApq2trV/Pub8y8VyFe+mll0RBEMQDBw7E96QHKBPP2fz588Uf//jHqu+76aabxIULFybwzBOXbudK6Yorroga0CgN1Wu8KA7euVJ65pln4g5ohvL9MCOnnMJJabH8/HwAQF1dHRobG3H22WfLxxiNRixatAibN2/u9X6sVit0usAWV1u2bIHNZsMpp5wiH1NdXQ2bzdbr/WzZsgWLFi1SNR9aunQp6uvrceDAgX49x2QYDueppqYGmzdvxqJFi/p+wgOUyeerqqoKZWVlOPPMM/HOO+/E/6T7KZPPleSPf/wjzjrrLIwZM6bvJ5wEmXjO3G43TCaT6vvMZjM++ugjeL3eOJ954tLtXKWzwTpX/TWU74cZH9CIooiVK1fi1FNPxYwZMwAAjY2NAICSkhLVsSUlJfJt4VpaWnDXXXfhmmuuka9rbGxEcXFxxLHFxcUx70f6vmiPrRzbUMv08zR69GgYjUacfPLJuO6663DVVVfFvN9kyNTzVVZWhqeeegovvvgi1q1bhylTpuDMM8/Ehg0b+nrK/Zap50qpoaEB//73vwf990qSqeds6dKl+MMf/oCPP/4Yoihi69atePrpp+H1etHc3NzX0+6XdDxX6Wowz1V/DeX7YcYHNNdffz0+/fRTrF27NuI2QRBUl0VRjLgOCGyJfu6552LatGm4/fbbe72P8PuZPn06srOzkZ2djWXLlvX62LHubyhk+nnauHEjtm7diieeeAIPPfRQ1OeRTJl6vqZMmYLvfe97mDNnDubPn4/HH38c5557Lu6///54nna/ZOq5UlqzZg1yc3OjFncOhkw9Z7fddhuWLVuG6upq6PV6nH/++bjyyisBAFqttq+n3S/peq7S0WCfq76k+v1wYLmkFLvhhhuwfv16bNiwAaNHj5avLy0tBRCI/srKyuTrm5qaIiLFzs5OnHPOOcjOzsZLL70EvV6vup9jx45FPO7x48fl+3nttdfkVKvZbJa/LzzybGpqAhAZJQ+F4XCexo0bBwCYOXMmjh07hjvuuAOXXHJJAmchfsPhfClVV1fjL3/5S99PvB+Gw7kSRRFPP/00VqxYAYPBkNgJ6IdMPmdmsxlPP/00nnzySRw7dkzOCObk5KCwsLB/J6QX6Xqu0tFgn6t4pPz9sF+VNynm9/vF6667TiwvLxd3794d9fbS0lLx3nvvla9zu90RRVAdHR1idXW1uGjRItHpdEbcj1Qw9uGHH8rXffDBB3EV1+Xm5oput1u+7p577hnyouDhdp4kd955pzhmzJiYt/fXcD1fF1xwgbh48eLYT7wfhtO5kgqpt2/fHt+T76fhdM6UTjvtNPGSSy6J/cT7Id3PlVKqi4KH6lwpJVoUPFTvhxkZ0Hz/+98XbTab+O6776qWXbpcLvmYe+65R7TZbOK6devE7du3i5dccolqmZrdbhdPOeUUcebMmeLevXtjLnE955xzxBNPPFHcsmWLuGXLFnHmzJl9Lulrb28XS0pKxEsuuUTcvn27uG7dOtFqtaqWqYmiKNbU1Ig1NTXiSSedJF566aViTU2N+Pnnn/M8Kc7To48+Kq5fv17cvXu3uHv3bvHpp58WrVar+POf/zxp50kyHM7Xgw8+KL700kvi7t27xc8++0y85ZZbRADiiy++yHMV5W9QFEXxsssuE0855ZQknZnYhsM527Vrl/jnP/9Z3L17t/jhhx+KF198sZifny/W1dWNqHMliqL4+eefizU1NeLy5cvF008/XX49Vxrs13hRHNpzdfDgQbGmpkZcvXq1mJ2dLT+/zs7OmOMbyvfDjAxoAET9euaZZ+Rj/H6/ePvtt4ulpaWi0WgUTzvtNNUnMOlTWbQv5R9nS0uL+K1vfUvMyckRc3JyxG9961txLYn99NNPxS996Uui0WgUS0tLxTvuuCMiGo322MnMPAyH8/Twww+L06dPFy0Wi2i1WsWqqirx8ccfF30+XzJOkcpwOF/33nuvOGHCBNFkMol5eXniqaeeKv7rX/9KxulRGQ7nShQDL7Zms1l86qmnBnpK+jQcztmOHTvE2bNni2azWbRareL5558fdyYjEZlwrsaMGRP1vvt6HsnOLg/lubriiiuiHvPOO+/0Osahej8UgndERERElLEyfpUTEREREQMaIiIiyngMaIiIiCjjMaAhIiKijMeAhoiIiDIeAxoiIiLKeAxoiIiIKOMxoCEiIqKMx4CGiIiIMh4DGiJKuiuvvBKCIODaa6+NuO0HP/gBBEHAlVdeOaRjGjt2LB566KEhfUwiGjoMaIhoUFRUVOD5559HV1eXfF13dzfWrl2LysrKFI6MiIYjBjRENCjmzJmDyspKrFu3Tr5u3bp1qKioQFVVlXyd2+3GjTfeiOLiYphMJpx66qn43//+J9/+7rvvQhAEvP322zj55JNhsViwYMEC7Nq1Sz5m3759OP/881FSUoLs7GzMnTsXb731lnz76aefjoMHD+KHP/whBEGAIAiD/OyJaKgxoCGiQfPtb38bzzzzjHz56aefxne+8x3VMT/96U/x4osv4k9/+hM++eQTTJw4EUuXLkVra6vquJ///Od44IEHsHXrVuh0OtX9OBwOfPnLX8Zbb72FmpoaLF26FMuXL8ehQ4cABAKp0aNH484770RDQwMaGhoG8VkTUSowoCGiQbNixQps2rQJBw4cwMGDB/H+++/jsssuk293Op343e9+h/vuuw/Lli3DtGnT8Pvf/x5msxl//OMfVff1q1/9CosWLcK0adNwyy23YPPmzeju7gYAzJo1C9dccw1mzpyJSZMm4Ze//CXGjx+P9evXAwDy8/Oh1WqRk5OD0tJSlJaWDt1JIKIhoUv1AIho+CosLMS5556LP/3pTxBFEeeeey4KCwvl2/ft2wev14uFCxfK1+n1esybNw9ffPGF6r5OPPFE+f9lZWUAgKamJlRWVsLpdGL16tX45z//ifr6evT09KCrq0vO0BDR8MeAhogG1Xe+8x1cf/31AIDHHntMdZsoigAQUdMiimLEdXq9Xv6/dJvf7wcA/OQnP8Hrr7+O+++/HxMnToTZbMaFF14Ij8eT3CdDRGmLU05ENKjOOecceDweeDweLF26VHXbxIkTYTAYsGnTJvk6r9eLrVu34oQTToj7MTZu3Igrr7wSX/va1zBz5kyUlpbiwIEDqmMMBgN8Pt+AngsRpS9maIhoUGm1Wnn6SKvVqm7LysrC97//ffzkJz9Bfn4+Kisr8X//939wuVz47ne/G/djTJw4EevWrcPy5cshCAJuu+02OXsjGTt2LDZs2IBvfvObMBqNqqkvIsp8DGiIaNBZrdaYt91zzz3w+/1YsWIFOjs7cfLJJ+P1119HXl5e3Pf/4IMP4jvf+Q4WLFiAwsJC/L//9/9gt9tVx9x555245pprMGHCBLjdbnm6i4iGB0HkXzURERFlONbQEBERUcZjQENEREQZjwENERERZTwGNERERJTxGNAQERFRxmNAQ0RERBmPAQ0RERFlPAY0RERElPEY0BAREVHGY0BDREREGY8BDREREWW8/w8PhzvS1LBO8QAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "jeMonat.plot()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b80044b0-c0dd-4ba1-8fd1-3cbf57fdf209",
   "metadata": {},
   "source": [
    "## Aufgabe 3 - In welchen PLZ Bereich kann man in Bochum am günstigsten tanken?\n",
    "\n",
    "Idee:\n",
    "\n",
    "  1. Tankpreise mit Tankstellendaten verbinden\n",
    "  2. Relevante Spalten herausfiltern\n",
    "  3. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "639b8ea4-62db-4966-a049-46294dfaa126",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:42:42.619130Z",
     "iopub.status.busy": "2024-12-04T08:42:42.618788Z",
     "iopub.status.idle": "2024-12-04T08:42:43.576660Z",
     "shell.execute_reply": "2024-12-04T08:42:43.576259Z",
     "shell.execute_reply.started": "2024-12-04T08:42:42.619108Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>dieselchange</th>\n",
       "      <th>e5change</th>\n",
       "      <th>e10change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 02:03:03+01</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>1.289</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1.369</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.399</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     date                          station_uuid  diesel  \\\n",
       "0  2020-01-01 02:03:03+01  b7dc5a11-661a-419f-8d30-d9763b2897c7   1.289   \n",
       "1  2020-01-01 04:36:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.309   \n",
       "2  2020-01-01 04:36:04+01  51d4b671-a095-1aa0-e100-80009459e03a   1.319   \n",
       "3  2020-01-01 04:36:04+01  51d4b500-a095-1aa0-e100-80009459e03a   1.319   \n",
       "4  2020-01-01 04:36:04+01  cd8b8686-d085-1ed7-a59b-163f66bf05c4   1.319   \n",
       "\n",
       "      e5    e10  dieselchange  e5change  e10change  \n",
       "0  1.409  1.369             0         0          1  \n",
       "1  1.429  1.409             1         1          1  \n",
       "2  1.439  1.399             1         1          1  \n",
       "3  1.439  1.419             1         1          1  \n",
       "4  1.439  1.419             1         1          1  "
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankpreise = pd.read_csv('https://datascience.hs-bochum.de/data/tankpreise/tankpreise-Bochum_2020-01-01_to_2020-12-31.csv')\n",
    "tankpreise.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "2ff01a01-496b-42cc-b6ae-d17b12789aa4",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:41:30.159223Z",
     "iopub.status.busy": "2024-12-04T09:41:30.158840Z",
     "iopub.status.idle": "2024-12-04T09:41:30.800472Z",
     "shell.execute_reply": "2024-12-04T09:41:30.799677Z",
     "shell.execute_reply.started": "2024-12-04T09:41:30.159209Z"
    }
   },
   "outputs": [],
   "source": [
    "tankstellen = pd.read_csv('https://data.hsbo.de/tankstellen.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "e2eebf77-89c1-4558-9289-40e2e746c3b6",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:41:30.801629Z",
     "iopub.status.busy": "2024-12-04T09:41:30.801419Z",
     "iopub.status.idle": "2024-12-04T09:41:30.811800Z",
     "shell.execute_reply": "2024-12-04T09:41:30.811218Z",
     "shell.execute_reply.started": "2024-12-04T09:41:30.801608Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uuid</th>\n",
       "      <th>name</th>\n",
       "      <th>brand</th>\n",
       "      <th>street</th>\n",
       "      <th>house_number</th>\n",
       "      <th>post_code</th>\n",
       "      <th>city</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>00060723-0001-4444-8888-acdc00000001</td>\n",
       "      <td>BAGeno Raiffeisen eG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Künzelsauer Strasse</td>\n",
       "      <td>7</td>\n",
       "      <td>74653</td>\n",
       "      <td>Ingelfingen</td>\n",
       "      <td>49.296822</td>\n",
       "      <td>9.661385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>005056ba-7cb6-1ed2-bceb-5332ab168d12</td>\n",
       "      <td>famila Tankstelle</td>\n",
       "      <td>FAMILA</td>\n",
       "      <td>Pascalstrasse</td>\n",
       "      <td>9</td>\n",
       "      <td>25442</td>\n",
       "      <td>Quickborn</td>\n",
       "      <td>53.742150</td>\n",
       "      <td>9.941240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>005056ba-7cb6-1ed2-bceb-573c18314d16</td>\n",
       "      <td>star Tankstelle</td>\n",
       "      <td>STAR</td>\n",
       "      <td>Riehler Strasse</td>\n",
       "      <td>240</td>\n",
       "      <td>50735</td>\n",
       "      <td>Köln</td>\n",
       "      <td>50.961800</td>\n",
       "      <td>6.980070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>005056ba-7cb6-1ed2-bceb-662ba1a94d1f</td>\n",
       "      <td>star Tankstelle</td>\n",
       "      <td>STAR</td>\n",
       "      <td>BAB 10 / Seeberg Ost</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15345</td>\n",
       "      <td>Altlandsberg</td>\n",
       "      <td>52.550160</td>\n",
       "      <td>13.682120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>005056ba-7cb6-1ed2-bceb-6f7b23564d23</td>\n",
       "      <td>star Tankstelle</td>\n",
       "      <td>STAR</td>\n",
       "      <td>Duisburger Straße</td>\n",
       "      <td>130</td>\n",
       "      <td>47166</td>\n",
       "      <td>Duisburg</td>\n",
       "      <td>51.489790</td>\n",
       "      <td>6.783730</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   uuid                  name   brand  \\\n",
       "0  00060723-0001-4444-8888-acdc00000001  BAGeno Raiffeisen eG     NaN   \n",
       "1  005056ba-7cb6-1ed2-bceb-5332ab168d12     famila Tankstelle  FAMILA   \n",
       "2  005056ba-7cb6-1ed2-bceb-573c18314d16       star Tankstelle    STAR   \n",
       "3  005056ba-7cb6-1ed2-bceb-662ba1a94d1f       star Tankstelle    STAR   \n",
       "4  005056ba-7cb6-1ed2-bceb-6f7b23564d23       star Tankstelle    STAR   \n",
       "\n",
       "                 street house_number post_code          city   latitude  \\\n",
       "0   Künzelsauer Strasse            7     74653  Ingelfingen   49.296822   \n",
       "1         Pascalstrasse            9     25442     Quickborn  53.742150   \n",
       "2       Riehler Strasse          240     50735          Köln  50.961800   \n",
       "3  BAB 10 / Seeberg Ost          NaN     15345  Altlandsberg  52.550160   \n",
       "4     Duisburger Straße          130     47166      Duisburg  51.489790   \n",
       "\n",
       "   longitude  \n",
       "0   9.661385  \n",
       "1   9.941240  \n",
       "2   6.980070  \n",
       "3  13.682120  \n",
       "4   6.783730  "
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankstellen.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "f93acbe0-78ae-4a62-a157-9c0be5c9de63",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:44:28.258702Z",
     "iopub.status.busy": "2024-12-04T08:44:28.258294Z",
     "iopub.status.idle": "2024-12-04T08:44:28.366236Z",
     "shell.execute_reply": "2024-12-04T08:44:28.365805Z",
     "shell.execute_reply.started": "2024-12-04T08:44:28.258665Z"
    }
   },
   "outputs": [],
   "source": [
    "df = tankpreise.merge(tankstellen, left_on=\"station_uuid\", right_on=\"uuid\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "d6c4d692-aafa-497d-ae5d-e74d4904a60d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:44:30.943091Z",
     "iopub.status.busy": "2024-12-04T08:44:30.942639Z",
     "iopub.status.idle": "2024-12-04T08:44:30.952778Z",
     "shell.execute_reply": "2024-12-04T08:44:30.952186Z",
     "shell.execute_reply.started": "2024-12-04T08:44:30.943057Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>dieselchange</th>\n",
       "      <th>e5change</th>\n",
       "      <th>e10change</th>\n",
       "      <th>uuid</th>\n",
       "      <th>name</th>\n",
       "      <th>brand</th>\n",
       "      <th>street</th>\n",
       "      <th>house_number</th>\n",
       "      <th>post_code</th>\n",
       "      <th>city</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 02:03:03+01</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>1.289</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1.369</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>Bochum, Wittenerstr. 361</td>\n",
       "      <td>SB</td>\n",
       "      <td>Wittenerstr. 361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44803</td>\n",
       "      <td>Bochum</td>\n",
       "      <td>51.472407</td>\n",
       "      <td>7.259509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.472200</td>\n",
       "      <td>7.121800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.399</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>JET BOCHUM WITTENER STR. 110</td>\n",
       "      <td>JET</td>\n",
       "      <td>WITTENER STR. 110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44789</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.475900</td>\n",
       "      <td>7.233920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>JET BOCHUM RIEMKER STR. 11</td>\n",
       "      <td>JET</td>\n",
       "      <td>RIEMKER STR. 11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44809</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.507660</td>\n",
       "      <td>7.191170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>JET BOCHUM HATTINGER STRASSE 629</td>\n",
       "      <td>JET</td>\n",
       "      <td>HATTINGER STRASSE 629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44879</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.435008</td>\n",
       "      <td>7.179170</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     date                          station_uuid  diesel  \\\n",
       "0  2020-01-01 02:03:03+01  b7dc5a11-661a-419f-8d30-d9763b2897c7   1.289   \n",
       "1  2020-01-01 04:36:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.309   \n",
       "2  2020-01-01 04:36:04+01  51d4b671-a095-1aa0-e100-80009459e03a   1.319   \n",
       "3  2020-01-01 04:36:04+01  51d4b500-a095-1aa0-e100-80009459e03a   1.319   \n",
       "4  2020-01-01 04:36:04+01  cd8b8686-d085-1ed7-a59b-163f66bf05c4   1.319   \n",
       "\n",
       "      e5    e10  dieselchange  e5change  e10change  \\\n",
       "0  1.409  1.369             0         0          1   \n",
       "1  1.429  1.409             1         1          1   \n",
       "2  1.439  1.399             1         1          1   \n",
       "3  1.439  1.419             1         1          1   \n",
       "4  1.439  1.419             1         1          1   \n",
       "\n",
       "                                   uuid  \\\n",
       "0  b7dc5a11-661a-419f-8d30-d9763b2897c7   \n",
       "1  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "2  51d4b671-a095-1aa0-e100-80009459e03a   \n",
       "3  51d4b500-a095-1aa0-e100-80009459e03a   \n",
       "4  cd8b8686-d085-1ed7-a59b-163f66bf05c4   \n",
       "\n",
       "                                                name  \\\n",
       "0                           Bochum, Wittenerstr. 361   \n",
       "1  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "2                       JET BOCHUM WITTENER STR. 110   \n",
       "3                         JET BOCHUM RIEMKER STR. 11   \n",
       "4                   JET BOCHUM HATTINGER STRASSE 629   \n",
       "\n",
       "                                   brand                 street house_number  \\\n",
       "0                                     SB       Wittenerstr. 361          NaN   \n",
       "1  Supermarkt-Tankstelle am real,- Markt       OTTOSTR. 40 - 43          NaN   \n",
       "2                                    JET      WITTENER STR. 110          NaN   \n",
       "3                                    JET        RIEMKER STR. 11          NaN   \n",
       "4                                    JET  HATTINGER STRASSE 629          NaN   \n",
       "\n",
       "  post_code    city   latitude  longitude  \n",
       "0     44803  Bochum  51.472407   7.259509  \n",
       "1     44867  BOCHUM  51.472200   7.121800  \n",
       "2     44789  BOCHUM  51.475900   7.233920  \n",
       "3     44809  BOCHUM  51.507660   7.191170  \n",
       "4     44879  BOCHUM  51.435008   7.179170  "
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "59d2c1d1-2eb7-4270-b01d-d4938443503d",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:48:29.537328Z",
     "iopub.status.busy": "2024-12-04T08:48:29.536952Z",
     "iopub.status.idle": "2024-12-04T08:48:29.550704Z",
     "shell.execute_reply": "2024-12-04T08:48:29.549993Z",
     "shell.execute_reply.started": "2024-12-04T08:48:29.537299Z"
    }
   },
   "outputs": [],
   "source": [
    "bochum = df[['post_code','e5']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "a13521cb-a651-489b-b894-e897835a28c9",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:48:33.383922Z",
     "iopub.status.busy": "2024-12-04T08:48:33.383546Z",
     "iopub.status.idle": "2024-12-04T08:48:33.393139Z",
     "shell.execute_reply": "2024-12-04T08:48:33.392456Z",
     "shell.execute_reply.started": "2024-12-04T08:48:33.383891Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>post_code</th>\n",
       "      <th>e5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>44803</td>\n",
       "      <td>1.409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>44867</td>\n",
       "      <td>1.429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>44789</td>\n",
       "      <td>1.439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>44809</td>\n",
       "      <td>1.439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>44879</td>\n",
       "      <td>1.439</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  post_code     e5\n",
       "0     44803  1.409\n",
       "1     44867  1.429\n",
       "2     44789  1.439\n",
       "3     44809  1.439\n",
       "4     44879  1.439"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bochum.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "12d3404f-1ce2-4e07-981c-63908e2548ba",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:51:24.755697Z",
     "iopub.status.busy": "2024-12-04T08:51:24.755320Z",
     "iopub.status.idle": "2024-12-04T08:51:24.800255Z",
     "shell.execute_reply": "2024-12-04T08:51:24.799451Z",
     "shell.execute_reply.started": "2024-12-04T08:51:24.755668Z"
    }
   },
   "outputs": [],
   "source": [
    "preiseBO_nachPLZ = bochum.groupby('post_code').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "74d76fdd-d2b9-4d0a-9de8-a174a068a136",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "17be42b5-6678-4ae2-a037-1dc2225a5e1e",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:52:14.078462Z",
     "iopub.status.busy": "2024-12-04T08:52:14.078090Z",
     "iopub.status.idle": "2024-12-04T08:52:14.088158Z",
     "shell.execute_reply": "2024-12-04T08:52:14.087542Z",
     "shell.execute_reply.started": "2024-12-04T08:52:14.078433Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>e5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>post_code</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>44787</th>\n",
       "      <td>1.257457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44869</th>\n",
       "      <td>1.258886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44879</th>\n",
       "      <td>1.260674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44867</th>\n",
       "      <td>1.266948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44809</th>\n",
       "      <td>1.269947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44892</th>\n",
       "      <td>1.271463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44793</th>\n",
       "      <td>1.271586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44803</th>\n",
       "      <td>1.272313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44791</th>\n",
       "      <td>1.276414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44797</th>\n",
       "      <td>1.276847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44795</th>\n",
       "      <td>1.280254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44894</th>\n",
       "      <td>1.281944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44789</th>\n",
       "      <td>1.285073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44807</th>\n",
       "      <td>1.286237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44799</th>\n",
       "      <td>1.288476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44805</th>\n",
       "      <td>1.294359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44866</th>\n",
       "      <td>1.296658</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 e5\n",
       "post_code          \n",
       "44787      1.257457\n",
       "44869      1.258886\n",
       "44879      1.260674\n",
       "44867      1.266948\n",
       "44809      1.269947\n",
       "44892      1.271463\n",
       "44793      1.271586\n",
       "44803      1.272313\n",
       "44791      1.276414\n",
       "44797      1.276847\n",
       "44795      1.280254\n",
       "44894      1.281944\n",
       "44789      1.285073\n",
       "44807      1.286237\n",
       "44799      1.288476\n",
       "44805      1.294359\n",
       "44866      1.296658"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseBO_nachPLZ.sort_values(by = 'e5')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "30cc3eb6-0082-46ac-885a-0524504bbf5c",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:51:00.629298Z",
     "iopub.status.busy": "2024-12-04T08:51:00.628773Z",
     "iopub.status.idle": "2024-12-04T08:51:00.636060Z",
     "shell.execute_reply": "2024-12-04T08:51:00.635421Z",
     "shell.execute_reply.started": "2024-12-04T08:51:00.629267Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "e5    44866\n",
       "dtype: object"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "preiseBO_nachPLZ.idxmax()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "516b32b9-e2c7-4cd2-bbc2-0f96cdbbf0f2",
   "metadata": {},
   "source": [
    "## Aufgabe 5: Wie häufig haben Shell/ESSO jeweils die Preise geändert?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "462885ac-2b6c-464b-b7e3-73a759882d4b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:56:09.896005Z",
     "iopub.status.busy": "2024-12-04T08:56:09.895631Z",
     "iopub.status.idle": "2024-12-04T08:56:09.914712Z",
     "shell.execute_reply": "2024-12-04T08:56:09.914057Z",
     "shell.execute_reply.started": "2024-12-04T08:56:09.895976Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>dieselchange</th>\n",
       "      <th>e5change</th>\n",
       "      <th>e10change</th>\n",
       "      <th>uuid</th>\n",
       "      <th>name</th>\n",
       "      <th>brand</th>\n",
       "      <th>street</th>\n",
       "      <th>house_number</th>\n",
       "      <th>post_code</th>\n",
       "      <th>city</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-01-01 02:03:03+01</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>1.289</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1.369</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>b7dc5a11-661a-419f-8d30-d9763b2897c7</td>\n",
       "      <td>Bochum, Wittenerstr. 361</td>\n",
       "      <td>SB</td>\n",
       "      <td>Wittenerstr. 361</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44803</td>\n",
       "      <td>Bochum</td>\n",
       "      <td>51.472407</td>\n",
       "      <td>7.259509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.472200</td>\n",
       "      <td>7.121800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.399</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b671-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>JET BOCHUM WITTENER STR. 110</td>\n",
       "      <td>JET</td>\n",
       "      <td>WITTENER STR. 110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44789</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.475900</td>\n",
       "      <td>7.233920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b500-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>JET BOCHUM RIEMKER STR. 11</td>\n",
       "      <td>JET</td>\n",
       "      <td>RIEMKER STR. 11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44809</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.507660</td>\n",
       "      <td>7.191170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>1.319</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1.419</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>cd8b8686-d085-1ed7-a59b-163f66bf05c4</td>\n",
       "      <td>JET BOCHUM HATTINGER STRASSE 629</td>\n",
       "      <td>JET</td>\n",
       "      <td>HATTINGER STRASSE 629</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44879</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.435008</td>\n",
       "      <td>7.179170</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     date                          station_uuid  diesel  \\\n",
       "0  2020-01-01 02:03:03+01  b7dc5a11-661a-419f-8d30-d9763b2897c7   1.289   \n",
       "1  2020-01-01 04:36:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.309   \n",
       "2  2020-01-01 04:36:04+01  51d4b671-a095-1aa0-e100-80009459e03a   1.319   \n",
       "3  2020-01-01 04:36:04+01  51d4b500-a095-1aa0-e100-80009459e03a   1.319   \n",
       "4  2020-01-01 04:36:04+01  cd8b8686-d085-1ed7-a59b-163f66bf05c4   1.319   \n",
       "\n",
       "      e5    e10  dieselchange  e5change  e10change  \\\n",
       "0  1.409  1.369             0         0          1   \n",
       "1  1.429  1.409             1         1          1   \n",
       "2  1.439  1.399             1         1          1   \n",
       "3  1.439  1.419             1         1          1   \n",
       "4  1.439  1.419             1         1          1   \n",
       "\n",
       "                                   uuid  \\\n",
       "0  b7dc5a11-661a-419f-8d30-d9763b2897c7   \n",
       "1  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "2  51d4b671-a095-1aa0-e100-80009459e03a   \n",
       "3  51d4b500-a095-1aa0-e100-80009459e03a   \n",
       "4  cd8b8686-d085-1ed7-a59b-163f66bf05c4   \n",
       "\n",
       "                                                name  \\\n",
       "0                           Bochum, Wittenerstr. 361   \n",
       "1  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "2                       JET BOCHUM WITTENER STR. 110   \n",
       "3                         JET BOCHUM RIEMKER STR. 11   \n",
       "4                   JET BOCHUM HATTINGER STRASSE 629   \n",
       "\n",
       "                                   brand                 street house_number  \\\n",
       "0                                     SB       Wittenerstr. 361          NaN   \n",
       "1  Supermarkt-Tankstelle am real,- Markt       OTTOSTR. 40 - 43          NaN   \n",
       "2                                    JET      WITTENER STR. 110          NaN   \n",
       "3                                    JET        RIEMKER STR. 11          NaN   \n",
       "4                                    JET  HATTINGER STRASSE 629          NaN   \n",
       "\n",
       "  post_code    city   latitude  longitude  \n",
       "0     44803  Bochum  51.472407   7.259509  \n",
       "1     44867  BOCHUM  51.472200   7.121800  \n",
       "2     44789  BOCHUM  51.475900   7.233920  \n",
       "3     44809  BOCHUM  51.507660   7.191170  \n",
       "4     44879  BOCHUM  51.435008   7.179170  "
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "701141e5-9bf1-4d8f-9227-007ded8b92f2",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:56:54.154836Z",
     "iopub.status.busy": "2024-12-04T08:56:54.154557Z",
     "iopub.status.idle": "2024-12-04T08:56:54.202849Z",
     "shell.execute_reply": "2024-12-04T08:56:54.202143Z",
     "shell.execute_reply.started": "2024-12-04T08:56:54.154814Z"
    }
   },
   "outputs": [],
   "source": [
    "shell = df[ df['brand'] == 'Shell' ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "f8d4b60b-5dab-4e7a-98cc-19d3f2cf29a1",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:01:32.262252Z",
     "iopub.status.busy": "2024-12-04T09:01:32.261886Z",
     "iopub.status.idle": "2024-12-04T09:01:32.267867Z",
     "shell.execute_reply": "2024-12-04T09:01:32.267122Z",
     "shell.execute_reply.started": "2024-12-04T09:01:32.262223Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(35748, 17)"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shell.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "a023d69e-4b53-4e75-987e-4a4a0720dd96",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:01:53.562003Z",
     "iopub.status.busy": "2024-12-04T09:01:53.561635Z",
     "iopub.status.idle": "2024-12-04T09:01:53.619286Z",
     "shell.execute_reply": "2024-12-04T09:01:53.618653Z",
     "shell.execute_reply.started": "2024-12-04T09:01:53.561973Z"
    }
   },
   "outputs": [],
   "source": [
    "tankstelleRealmarktBO = df[ df['uuid'] == '51d4b638-a095-1aa0-e100-80009459e03a' ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "8b33667f-2fe3-406c-aefd-54cff5f1a633",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T09:02:09.160567Z",
     "iopub.status.busy": "2024-12-04T09:02:09.160203Z",
     "iopub.status.idle": "2024-12-04T09:02:09.179483Z",
     "shell.execute_reply": "2024-12-04T09:02:09.178741Z",
     "shell.execute_reply.started": "2024-12-04T09:02:09.160537Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>station_uuid</th>\n",
       "      <th>diesel</th>\n",
       "      <th>e5</th>\n",
       "      <th>e10</th>\n",
       "      <th>dieselchange</th>\n",
       "      <th>e5change</th>\n",
       "      <th>e10change</th>\n",
       "      <th>uuid</th>\n",
       "      <th>name</th>\n",
       "      <th>brand</th>\n",
       "      <th>street</th>\n",
       "      <th>house_number</th>\n",
       "      <th>post_code</th>\n",
       "      <th>city</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-01-01 04:36:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.309</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1.409</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.4722</td>\n",
       "      <td>7.1218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2020-01-01 06:33:03+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.389</td>\n",
       "      <td>1.509</td>\n",
       "      <td>1.489</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.4722</td>\n",
       "      <td>7.1218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2020-01-01 07:23:03+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.379</td>\n",
       "      <td>1.499</td>\n",
       "      <td>1.479</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.4722</td>\n",
       "      <td>7.1218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2020-01-01 07:37:03+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.339</td>\n",
       "      <td>1.459</td>\n",
       "      <td>1.439</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.4722</td>\n",
       "      <td>7.1218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2020-01-01 08:08:04+01</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>1.329</td>\n",
       "      <td>1.449</td>\n",
       "      <td>1.429</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>51d4b638-a095-1aa0-e100-80009459e03a</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt BOCHUM O...</td>\n",
       "      <td>Supermarkt-Tankstelle am real,- Markt</td>\n",
       "      <td>OTTOSTR. 40 - 43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44867</td>\n",
       "      <td>BOCHUM</td>\n",
       "      <td>51.4722</td>\n",
       "      <td>7.1218</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      date                          station_uuid  diesel  \\\n",
       "1   2020-01-01 04:36:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.309   \n",
       "53  2020-01-01 06:33:03+01  51d4b638-a095-1aa0-e100-80009459e03a   1.389   \n",
       "76  2020-01-01 07:23:03+01  51d4b638-a095-1aa0-e100-80009459e03a   1.379   \n",
       "80  2020-01-01 07:37:03+01  51d4b638-a095-1aa0-e100-80009459e03a   1.339   \n",
       "84  2020-01-01 08:08:04+01  51d4b638-a095-1aa0-e100-80009459e03a   1.329   \n",
       "\n",
       "       e5    e10  dieselchange  e5change  e10change  \\\n",
       "1   1.429  1.409             1         1          1   \n",
       "53  1.509  1.489             1         1          1   \n",
       "76  1.499  1.479             1         1          1   \n",
       "80  1.459  1.439             1         1          1   \n",
       "84  1.449  1.429             1         1          1   \n",
       "\n",
       "                                    uuid  \\\n",
       "1   51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "53  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "76  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "80  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "84  51d4b638-a095-1aa0-e100-80009459e03a   \n",
       "\n",
       "                                                 name  \\\n",
       "1   Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "53  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "76  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "80  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "84  Supermarkt-Tankstelle am real,- Markt BOCHUM O...   \n",
       "\n",
       "                                    brand            street house_number  \\\n",
       "1   Supermarkt-Tankstelle am real,- Markt  OTTOSTR. 40 - 43          NaN   \n",
       "53  Supermarkt-Tankstelle am real,- Markt  OTTOSTR. 40 - 43          NaN   \n",
       "76  Supermarkt-Tankstelle am real,- Markt  OTTOSTR. 40 - 43          NaN   \n",
       "80  Supermarkt-Tankstelle am real,- Markt  OTTOSTR. 40 - 43          NaN   \n",
       "84  Supermarkt-Tankstelle am real,- Markt  OTTOSTR. 40 - 43          NaN   \n",
       "\n",
       "   post_code    city  latitude  longitude  \n",
       "1      44867  BOCHUM   51.4722     7.1218  \n",
       "53     44867  BOCHUM   51.4722     7.1218  \n",
       "76     44867  BOCHUM   51.4722     7.1218  \n",
       "80     44867  BOCHUM   51.4722     7.1218  \n",
       "84     44867  BOCHUM   51.4722     7.1218  "
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankstelleRealmarktBO.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "446115b4-6d0f-4c45-b941-19c1eb59666b",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:58:14.437165Z",
     "iopub.status.busy": "2024-12-04T08:58:14.436796Z",
     "iopub.status.idle": "2024-12-04T08:58:14.480719Z",
     "shell.execute_reply": "2024-12-04T08:58:14.479994Z",
     "shell.execute_reply.started": "2024-12-04T08:58:14.437136Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['SB', 'Supermarkt-Tankstelle am real,- Markt', 'JET', 'TinQ',\n",
       "       'Shell', 'ESSO', 'ARAL', 'Westfalen', 'TOTAL', 'Access', 'Markant',\n",
       "       'Classic Tankstelle', 'STAR', 'Freie Tankstelle', 'OIL!', 'HEM',\n",
       "       'GO', 'BFT Tankhof Stein'], dtype=object)"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['brand'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "10b5588a-4c32-4fe2-bfba-ffe02a85ae72",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-12-04T08:58:45.078398Z",
     "iopub.status.busy": "2024-12-04T08:58:45.078030Z",
     "iopub.status.idle": "2024-12-04T08:58:45.087941Z",
     "shell.execute_reply": "2024-12-04T08:58:45.087311Z",
     "shell.execute_reply.started": "2024-12-04T08:58:45.078368Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'FAMILA', 'STAR', 'ARAL', 'Freie', 'AVIA', 'Shell', 'M1',\n",
       "       'Westfalen', 'ESSO', 'TOTAL', 'Markant', 'AVIA Xpress',\n",
       "       'TANKHOF STEINHEIM', 'Raiffeisen', 'OMV', 'Zahradnik', 'TEC',\n",
       "       'Schillhorn Mineralöle GmbH Hemme', 'SB', 'BayWa',\n",
       "       'Schillhorn Mineralöle GmbH Hanerau', 'ELAN', 'V-Markt Schongau',\n",
       "       'bft', 'Tankstelle Teuchern', 'Heinrich Albers OHG', 'Tankpoint',\n",
       "       'Tankstelle', 'JET', 'Raiffeisen Tankstelle', 'BFT', 'OIL!',\n",
       "       'Frei', 'SHELL', 'Sauerwald', 'CLASSIC', 'Mandler Tank & Wasch',\n",
       "       'Q1', 'Freie Tankstelle', 'PM', 'Mengin',\n",
       "       'Tankstelle Kassner GmbH', 'Sunoil', 'EC - Tankstelle Rolfes',\n",
       "       'Nuttelmann Tankservice', 'Agip', 'Roth- Station', 'Hoyer',\n",
       "       'Eberhardt Unteröwisheim', 'BUNTE MINERALÖLHANDEL GMBH',\n",
       "       'Freie Tankstelle AH Holste', 'ED', 'Calpam', 'team', 'Greenline',\n",
       "       'Tankpool24', 'TAMOIL', 'HEM', 'bft - Walther', 'freie Tankstelle',\n",
       "       'RAN', 'Kaiser/Freie-24h-Tankstelle', 'Sigmund Hoffmann',\n",
       "       '1A Tank', 'Auto-Kohler KG ', 'Autohaus Wankmüller GmbH',\n",
       "       'Tank- und Waschpark Lahr', 'Bft', 'Zehner Energie GmbH',\n",
       "       'Freie Tankstelle ASL', 'Auto-Kohler', 'Ultsch-Tankstelle Bamberg',\n",
       "       'Bergler', 'Tankstelle Schreyer', 'S-Tank Hohenwart',\n",
       "       'Tankhof Norsingen', 'Tankstelle I.Zens', 'Zillinger', 'BAUM',\n",
       "       'Schiffer & Nicklaus GmbH', 'TANKHOF SAUERLACH', 'Orosol', 'EDEKA',\n",
       "       'Tankhof Iffezheim', 'Seitz Tankstellen', 'Auto-Service-Bund',\n",
       "       'S-TANK Biberbach', 'Freie Tankstelle Hans Ritz',\n",
       "       'Freie Tankstelle Hartmann', 'Marktkauf', 'frei ',\n",
       "       'Raiffeisen-Tankstelle', 'RWZ-Kassel', 'Reibert', 'SVG',\n",
       "       'Tankstelle Paul Ziefle', 'TANK 24', 'Willi Walter GmbH',\n",
       "       'Freie Tankstelle Union Tankhof', 'GILLET tanken & waschen',\n",
       "       'S-TANK Kühbach', 'Tank & Waschcenter Auerbach', 'Mc Sprit',\n",
       "       'BFT Tankstelle Michael Richter', 'C+C Oberallgäu Lang-Steudler  ',\n",
       "       'Gohde', 'BFT-Tankstelle', 'STB Tankstelle', 'Behrenswerth',\n",
       "       'CardTank 24', 'Wittmann Oil', 'Tankstelle Werner Cunow',\n",
       "       'BFT Tankstelle Cunow', 'BFT Tankstelle Blattmann',\n",
       "       'Mineralölvertrieb Noeke Gmbh', 'H. Sattler KG', 'Pfeffer',\n",
       "       'Raiffeisen Vogelsberg GmbH', 'BFT-Tankstelle Kloiber GmbH',\n",
       "       'Richter Mineralöl GmbH & Co KG', 'Eurotank', 'ST 2 Tankstelle',\n",
       "       'Bft - Tankstelle Herrmann', 'Kröber Mineralöl GmbH',\n",
       "       'Paul Fischer GmbH', 'Auto Riedel', 'Freie Tankstelle Ehmann',\n",
       "       'ch-tank', 'Auto Huber', 'FELTA', 'A Energie', 'Sonstige', 'ORLEN',\n",
       "       'City Tank', 'Mundorf Tank', 'Pinoil', 'Mr. Wash Autoservice AG',\n",
       "       'Supermarkt C&C', 'Tankcenter', 'Wiro', 'LEO', 'SB-Tank Scherer',\n",
       "       'Winkler 24h', 'GO', 'Freie Tankstelle Dittmann', 'Zaubzer',\n",
       "       'EP Tankstelle', 'ADAP Tankstelle', 'TAS', 'SB Tankstelle', 'C&S',\n",
       "       'ALLGUTH', 'Tankstelle  Ruehl', 'Westfalen Tankstelle', 'SCORE',\n",
       "       'Markant (Tankautomat)', 'Turbo', 'AMB', 'Gulf', 'tankpool24',\n",
       "       'Jantzon Tankstelle', 'Kuster oil', 'NORDOEL', 'GS agri eG',\n",
       "       'Globus SB Warenhaus', 'TAP PflipsenGroup', 'Raiffeisen Hunsrück',\n",
       "       'Kaufland', 'T', 'HERM', 'MTB Tankstelle',\n",
       "       'Kohlenhof - Freie Tankstelle', 'V-Markt Bobingen', 'frei',\n",
       "       'Sprint', 'Freie Tankstelle Huber', 'MTB-Tankstelle AH Schlecht',\n",
       "       'Markenfreie TS', 'Tank Plus', 'V-Markt Kaufbeuren', 'Access',\n",
       "       'ELO', 'BELL Oil', 'CITTI', 'Rakelbusch', 'RUMAG GmbH',\n",
       "       'Raiffeisen Mitte', 'Joiss', 'SB-Tanken',\n",
       "       'Hans Heinrich Mundt e.K.', 'Hörndl Freie Tankstelle',\n",
       "       'SVG Düsseldorf', 'Bavaria Petrol', 'Tankstelle Feldmeier',\n",
       "       'Schillhorn Mineral\"le GmbH Remmels', 'Tank am Ring',\n",
       "       'Freie Tankstelle Henke', 'SPREVES', 'Deppe Freie Tankstellen',\n",
       "       'Hessol', 'Tankstelle Gröditsch', 'AS Mineralöle',\n",
       "       'Raiffeisenmarkt Oberstadion', 'E-Center',\n",
       "       'LD Tankstelle Nürtingen', 'Supermarkt', 'Pludra',\n",
       "       'HTN-Tankstelle J.Nienhaus', 'EDi', 'Supol', 'TS ARNT',\n",
       "       'EDi Hohenlohe', 'V-Markt Mindelheim', 'AVEX',\n",
       "       'Tank & Waschcenter Kirchberg', 'Edeka C + C',\n",
       "       'ZG Raiffeisen Energie', 'Reifen Labetzke Tankstelle',\n",
       "       'BFT Tankhof Stein', 'V-Baumarkt Kaufbeuren',\n",
       "       'Depenbrock Freie Tankstelle', 'HemSaer Agrar GmbH', 'T & W',\n",
       "       'LTG', 'Tankport Süd', 'Tankstelle Grüne',\n",
       "       'Freie Tankstelle Vorrink', 'SUN', 'GT Brennstoffvertrieb GmbH',\n",
       "       'bft Tankstelle Emir', 'PT Tankstelle Becker', 'LOOS',\n",
       "       'Argos Tankstelle', 'Tankstelle & Espressobar Nardi',\n",
       "       'Tankstelle Fischer', 'Engelke Energie',\n",
       "       'Autohaus Lang GmbH - BFT', 'Dieselmann', 'Stoffmehl',\n",
       "       'Tank und Wasch', 'Honsel', 'Neumann Tankstelle GmbH', 'GULF',\n",
       "       'BURKHARD', 'BFT Tankstelle Mucke', 'Classic', 'bft (Heimburger)',\n",
       "       'Auto SPREVES', 'Tankstelle Schuster',\n",
       "       'Bremer Mineralölhandel GmbH', 'WEVAG Autohof',\n",
       "       'bft-Station-Uesbeck', 'REWE', 'BFT Krüger Hodenhagen', 'arwe',\n",
       "       'Pickelmann', 'Autohaus Huber - freie Tankstelle', 'Lenz',\n",
       "       'Mineralöle Andrys', 'famila', 'Trigema', 'Schrewe Vertriebs GmbH',\n",
       "       'SB Tankstelle Wallner', 'ssd GmbH',\n",
       "       'Kaiser Mineralöl und Tankstellen GmbH', 'EC Tankstelle Rolfes',\n",
       "       'Pink-Tank', 'Tankstop 24h', 'Freie Tankstelle Limmer', 'WIKING',\n",
       "       'bft Wilstacke + Growe', 'Union Zapfstelle', 'Adams', 'W. Dorst',\n",
       "       'J. Dorst GmbH', 'Freie Tankstelle Grawinkel', 'ch-tank Ost',\n",
       "       'Freie Tankstelle Wiehe', 'Tank & Shop', 'LOTHEROL',\n",
       "       'SP Tank & Shop', 'Tanken mit Bedienung Schulte', 'J. Hannöver',\n",
       "       'Nibelungentankstelle', 'DOC  - Freie Tankstelle', 'PM24',\n",
       "       'Freie Tankstelle Neusaess', 'Tankstelle Rhein', 'BFT Wolfhagen',\n",
       "       'Elf', 'SB-Markttankstelle', 'PT 1', 'WITTIG Tankautomatenstation',\n",
       "       'MTB', 'Eberhardt Ubstadt', 'SB-Tank am HIT (Mundorf Tank)',\n",
       "       'Südtank', 'Stoffregen', 'Walther Automatenstaion', 'budget öl',\n",
       "       'Freie Tankstelle Rolfes', 'Autowelt Bad Saulgau GmbH',\n",
       "       'V-Markt Peiting', 'HAUER', 'famila Nordost', 'V-Markt Neugablonz',\n",
       "       'Weidemann-Tank', 'AVIA Xpress Automatentankstelle ', 'MINOL',\n",
       "       'DEXX', 'Supermarkt Uetze', 'HIT (Supermarkt TS)', 'Kling Energie',\n",
       "       'Freie Tankstelle Seltenberg', 'Tankzentrum Lacher',\n",
       "       'V-Markt Günzburg', 'Freie Tankstelle Pöpken', 'E Center',\n",
       "       'Avanti', 'Freie Automatentankstelle',\n",
       "       'Gerhard Leger GmbH - freie Tankstelle', 'Haisch-tank', 'AHR',\n",
       "       'Edewechter Tankpark', 'Hauer', 'Brzezina GmbH - Drebber',\n",
       "       'Tankstelle Logabirum', 'Frühmesser GmbH',\n",
       "       'Grüning Automobile Krempel', 'Knauber (PM)', 'Autohaus Röse GbR',\n",
       "       'BUROL', 'VARO Energy Direct GmbH', 'Freie Tankstelle Behrends',\n",
       "       'Lölfin', 'Eberhardt (Diedelsheim)', 'Harting Freie Tankstelle',\n",
       "       'Rottaler Autohöfe', 'BFT Auto-Team GmbH',\n",
       "       'Freie Tankstelle Berta Schneider', 'CleanCar AG',\n",
       "       'BFT Willig´s GTR-Tankhof', 'T (Supermarkt TS)', 'MHT', 'Oel-Huff',\n",
       "       'Tankstelle Hauser KG', 'Freie Tankstelle Körschen',\n",
       "       'Tankstelle am Osterkanal', 'FREIE WELLE', 'Schonhoff Mineralöle',\n",
       "       'Freie Tankstelle Kaufmarkt', 'Tinex Tankstelle',\n",
       "       'Alb-Donau-Center', 'Raiffeisen EG', 'JOISS', 'MR Tankstelle',\n",
       "       'Stolch / Tank-Netz', 'Freie Tankstelle Krenn',\n",
       "       'V-Markt Weißenhorn', 'V-Markt Fischen-Langen', 'Autol',\n",
       "       'West-Tank', 'Fulmin', 'LKT', 'Freie ', 'Reitmayr TS',\n",
       "       'Kessel Mineralöl', 'BFT Pieper',\n",
       "       'WDG Tankstelle Bad Liebenwerda-Dobra', 'Tankstelle-Reilmann',\n",
       "       'Hoyer Tank-Treff Lindau', 'Tankstelle Zieglmeier', 'ALLGUTH ',\n",
       "       'Vorteil-Center', 'Raiffeisen Tungeln',\n",
       "       'Autohaus Luckey Freie Tankst.',\n",
       "       'Bauer Oelzapf Mineralölvertrieb GmbH', 'Fritz Walter GmbH',\n",
       "       'Freie Tankstelle Cinar', 'Ludger Brämswig GmbH',\n",
       "       'RWG Bissel-Halenhorst eG', 'Brachthäuser', 'Stiegler',\n",
       "       'Börde Agrarhandel', 'Tank-Eck',\n",
       "       'Freie Tankstelle Autohaus Knieper GmbH', 'Schuster & Sohn KG',\n",
       "       'BFT ', 'Tankstelle Still', 'bft Winkler 24h',\n",
       "       'Autoservice Spitz Tankstelle', 'Ruhe Agrar GmbH', 'nordenergie',\n",
       "       'SB Markt', 'Morgenstern GmbH - Freie Tankstelle Liblar', 'Unitol',\n",
       "       'Egenolf Freie TS', 'TANKHOF GRÜN',\n",
       "       'Supermarkt-Tankstelle am real,- Markt', 'Supermarkt-Tankstelle',\n",
       "       'BSB Benzinkontor GmbH & Co. KG',\n",
       "       'AVIA Xpress Automatentankstelle', 'HIT', 'BTW',\n",
       "       'Georg Heinlein GmbH (FT)', 'DEA', 'BFT / Tankstelle  Lang', 'TOP',\n",
       "       'Freie Tankstelle Feldstetten', 'TTM Meiwes', 'UNITOL', 'agron',\n",
       "       '24-Stunden Tankstelle Sellner', 'Günstig-Tanken-TST',\n",
       "       'Dörge Brennstoffe & Dienstleistungen', 'Deglmann Tankcenter',\n",
       "       'Broering Tankstelle', 'bft-Tankstation',\n",
       "       'Freie Tankstelle Wessel', 'Freie Tankstelle Tank & Shop',\n",
       "       'Felsch Mineralöl', 'Gasolin', 'MSS', 'Freie Tankstelle Lögering',\n",
       "       'Gerlinger Weikersheim', 'Ektra', 'SB-Tankstelle',\n",
       "       'Hubert Thiele GmbH', 'Raiffeisen Aßling', 'Eberhardt Forst',\n",
       "       'OKTAN', 'Rossnagel Tankstelle',\n",
       "       'Schaffers Brennstoffhandels GmbH', 'Freie Tankstelle Rabeneck',\n",
       "       'BeckmannLindemann GmbH', 'SEEL Tankstelle', 'Hümmer KG',\n",
       "       'Leu Energie', 'SB Station', 'bft Bräuning', 'FIT',\n",
       "       'Tanklager Baack', 'Freie Tankstelle Schwägerl-Bäde',\n",
       "       'Raiffeisen Hatten eG', 'Raiffeisen Mansfeld', 'Freie Tankstelle ',\n",
       "       'BFT LUTZ GMBH VW-AUDI-SERVICE', 'GVS', 'FT Mangold',\n",
       "       'Tankbistro Selgros', 'Tank Stop Best', ' AVIA Xpress ',\n",
       "       'Gerlinger MGH-Markelsheim', 'Shell Basedow', 'Weinmayr',\n",
       "       'DCS-Tankstelle', 'Steffens Kfz Rep. GmbH', 'GREBE',\n",
       "       'Andreas Sauter GmbH & Co. KG', 'Seiffert',\n",
       "       'Walther Automatenstation', 'LD Tankstelle Heidenheim',\n",
       "       'Kfz-Werkstatt Neff', 'BFT Tankstelle', 'Tankstelle Haar',\n",
       "       'Agroservice Tankstelle Nobitz', 'HMH', 'V-Markt Bad Wörishofen',\n",
       "       'Eichhorn AG', 'Calpam Tankstelle', 'azur', 'K+K',\n",
       "       'Tecklenburg Tankstelle', 'Tank u. Waschcenter Harting GmbH',\n",
       "       'LD Tankstelle Westheim', 'KÖHN PLAMBECK', 'Raiffeisen eG',\n",
       "       'Zieglmeier Tankstelle', 'Tankstelle am Kiebitzmarkt',\n",
       "       'K&S Freie Tankstelle', 'Ahlert Junior',\n",
       "       'Raiffeisenbank Kastellaun eG', 'Wolber', 'E+C',\n",
       "       'bft H. Gr. Höötmann Tankstellen GmbH', 'V-Markt F\\x81üssen',\n",
       "       'Marktkauf LD Tankstelle Pfullingen', 'QPT', 'V-Markt Kissing',\n",
       "       'Freie Tankstelle Wessels', 'Edeka', 'Schwarzkopf',\n",
       "       'Westfalen-Tankstelle', 'Haisch TankCenter', 'Roth- Energie',\n",
       "       'Metank', 'Freie Tankstelle Prehn', 'Josef Höckelmann',\n",
       "       'Freie Tankstelle Meurer', 'Fleming + Wendeln GmbH & Co. KG',\n",
       "       'Bendix', 'Freie Tankstelle Laufer', 'Freie Tankstelle Wagner',\n",
       "       'Freie Tankstelle Herold', 'Tankstelle Wenker', 'TankDiscount24',\n",
       "       'LS&WD Handels-GmbH Tankstelle', 'SB-Service-Station Dettmer',\n",
       "       'bft Tankstelle Richters GmbH', 'Eller', 'Kfz-Werkstatt Schneider',\n",
       "       'carTank24', 'PS-Laden', 'LD Tankstelle Fellbach',\n",
       "       'bft Tankstelle', 'Freie Tankstelle Esch',\n",
       "       'V-Markt München Balanstrasse', 'LBAG Pretzier eG',\n",
       "       'Tankstelle Klüver', 'TinQ', 'Raiffeisen Muecke',\n",
       "       'Harting - Freie Tankstelle', 'Sefrin Heizöl und Kraftstoffe',\n",
       "       'Freie Tankstelle Schröder', 'Nordoel', 'Tankcenter Hafen',\n",
       "       'freie tankstelle', 'Express Tank', 'super wash',\n",
       "       'Tankstelle Gebauer', 'BFT Tankstelle Ewald Leiber ', 'ECO',\n",
       "       'Hoffmann Tankstellen', 'Autohaus König', 'Schnorberger',\n",
       "       'VW Thierolf', 'Freie Tankstelle E. Wippenhohn e.K.',\n",
       "       'TSR - Rossi', 'SBT', 'V-Markt Thannhausen', 'bft-Tankstelle',\n",
       "       'KURZ-EBERT TELGTE TANKSTELLE', 'Speed Point Eble',\n",
       "       'MTB Automaten-Tankstelle', 'Freie Tankstelle Kühling Transporte',\n",
       "       'bft SENG Hattenhof', 'FGL Tankstelle', 'Tankstelle Aitrachtal',\n",
       "       'Classic Tankstelle', 'Süd-Treibstoff Tankstelle',\n",
       "       'Agten Freie Tankstelle', 'Flaeming Tank',\n",
       "       'Rastpark24 GmbH & Co. KG', 'WELTER', 'Tank & Waschcenter',\n",
       "       'Schillhorn Mineralöle GmbH Gudendorf',\n",
       "       'BFT Tankstelle Vornmoor GmbH',\n",
       "       'Autohaus Otto Menger GmbH & Co. KG', 'agritura Raiffeisen eG',\n",
       "       'LD Tankstelle Fornsbach', 'Hoyer bei Dodenhof',\n",
       "       'Supermarkt Tankstelle', 'bft-Tankstelle ',\n",
       "       'Freie Tankstelle AH Meyer', 'Kirschbaum', 'Tankstelle Späth',\n",
       "       'Freie Tankstelle Schürkötter & Bleckmann GmbH',\n",
       "       'Schillhorn Mineralöle GmbH Tönning',\n",
       "       'Freie Tankstelle Lente Center', 'Brandol Beeskow',\n",
       "       'bft - Tankstelle Laubach', 'Tobias Lehre GmbH',\n",
       "       'A. Kuenstler GmbH', 'Raiffeisen - LBAG Schmalenbrücke eG',\n",
       "       'Tankstelle Schlotter', 'MTB Tankstelle Auto-Heidt',\n",
       "       'Autohaus Anton Segbert GmbH & Co.  KG', 'Freie Tankst. ',\n",
       "       'famila Nordwest', 'TS - GREIL IFFELDORF', 'TankPoint Berneck',\n",
       "       'Nordgarage Rottweil', 'Tankstelle Denner', 'Oel Schneider GmbH',\n",
       "       'Zander', 'Gruber Freie Tankstelle',\n",
       "       'AUTO ZOTZ Landau in der Pfalz   Tanken und waschen',\n",
       "       'R. Tesche GmbH', 'Havelland Agrar eG Weseram', 'TINOL Tankstelle',\n",
       "       'Itzehoer Tankhof', 'Autohaus Nachtmann',\n",
       "       'Raiffeisen Tankverbund GmbH', 'Autohaus Hackmann',\n",
       "       'Freie Tankstelle Loder', 'bft-Tankstelle Hölker GmbH',\n",
       "       'V-Markt Immenstadt', 'Freie Tankstelle Hündl', 'mtb',\n",
       "       'Tankstelle Donautal', 'Freie Tankstelle Kuhl', 'bft Pyrbaum',\n",
       "       'Beernink´s Freie Tankstelle', 'Raiffeisen Lagerhaus Eschlkam',\n",
       "       'Hink & Hölkemann GmbH & Co. KG', 'Autohaus Modler',\n",
       "       'Lange Mineralöl GmbH', 'bft-Station',\n",
       "       'Möbel Inhofer GmbH & Co. KG                ',\n",
       "       'Freie Tankstelle Piper', 'WEKO PETROL', 'Lanwehr',\n",
       "       'Freie Tankstelle Schöllmann', 'Freie Tankstelle Putbus',\n",
       "       'Freie Tankstelle Heinzelmann', 'Freie TS', 'Tankpunkt Weinmann',\n",
       "       'Autofit Freie Tankstelle', 'CT Mineralöle',\n",
       "       'Mtb - Filderstadt  Ford-Stauch', 'centertank',\n",
       "       'Freie Tankstelle Rinck', 'LD Tankstelle Backnang', 'SB-Tankpunkt',\n",
       "       'Avia', 'BfT Tankstelle', 'V-Markt Türkheim',\n",
       "       'Pfeiffer  Metalltechnologie', 'blakert.de VW in Osterwick',\n",
       "       'Agroservice Tankstelle Waldenburg', 'MTB Automatentankstelle',\n",
       "       'Freie Tankstelle Schütte', 'Tankstelle Müller',\n",
       "       'V-Markt Marktoberdorf', 'Schneider Winkler24h',\n",
       "       'Tankstelle Marco Gaubig', 'bft - Freie Tankstelle',\n",
       "       'WK Tank Berkatal', 'Piening Tankstelle',\n",
       "       'OHO - Tankstelle & Shop', 'BFT Huddelbusch', 'Tankstelle Reier',\n",
       "       'M1 ', 'AMIDI Freie Tankstelle', 'Wilhelm Claas GmbH',\n",
       "       'Tankstelle Barver', 'Classic Tankstelle Wirth', 'Greiner',\n",
       "       'Zahradnik GmbH', 'Bft Tankstelle Alte Huette',\n",
       "       'Tankstelle Lukosek', 'BFT Bahrendorf', ' F T B', 'Brandol Goyatz',\n",
       "       'Raimund Tankstelle', 'Tankstelle Lösenbach', 'Profi-T',\n",
       "       'Freie Tankstelle Ostermünchen', 'BAG Hohenlohe',\n",
       "       'Tankstelle Scharlibbe', 'bft Tankstelle Neussel', 'Fina',\n",
       "       'TANKHOF RIEGEL Freie Tankst.', 'bft-Walther',\n",
       "       'TAS (Umbau provisorisch)', 'Freie Tankstelle Autofit Lambert',\n",
       "       'Autohaus Weinmann', 'V-Markt Leipheim',\n",
       "       'Georg Wagner KG freie Tankstelle',\n",
       "       'Raiffeisen Adelebsen Uslar GmbH', 'Selgros', 'OPEL - MOROF ',\n",
       "       '24h Tankstelle am Wyker Hafen', 'bft-Walther Wagner',\n",
       "       'Frei Tankstelle Lange', 'K1 Tanstelle', 'HMH Mineralöl Service',\n",
       "       'Beyer Tankstelle', 'Halfmann Mineralöl GmbH & Co. KG',\n",
       "       'Tankhof Lengenfeld', 'V-Markt Memmingen', 'ED-Freie-Tankstelle',\n",
       "       'Freie Tankstelle Lampa', 'Tank & Waschcenter Rohsiepe',\n",
       "       'Rapp - Freie Tankstelle', 'Markant Tankstelle', 'Schorfheide',\n",
       "       'Tank- und Baumarkt Zahna', 'Tankstelle Greil',\n",
       "       'BFT-freie Tankstelle', 'Autohaus Rickmeier GmbH',\n",
       "       'Freie Tankstelle Bartels', 'SB-Tanken Herget',\n",
       "       'Tankstelle Heinrich', 'Freie/ESSOTankstelle',\n",
       "       'Freie KANNE Tankstelle', 'Rewe Tankstelle Olching', 'WOTAN',\n",
       "       'Tankstelle Lietsch', 'Tankstelle Bily GmbH & CO KG',\n",
       "       'BHG Brennstoffhandel Großer Gmbh - Tankstelle an der B101', 'MLZ',\n",
       "       'Sprit Point', \"Kattner\\\\'s Freie Tankstelle GmbH\", 'Döringer',\n",
       "       'Tankstelle Senftl', 'Thelen', 'BFT Idar-Oberstein',\n",
       "       'BFT Filderstadt', 'SIT', 'Krämer', 'Tankstelle Barthmann',\n",
       "       'Tankstelle Meier', 'Hempelmann', 'Tebben Automobile', 'Profitank',\n",
       "       'Freie Faldera Tankstelle Günzel', 'V-Markt Lauingen',\n",
       "       'Lanzinger Tanke & Caravan e. K', 'BFT - Freie Tankstelle',\n",
       "       'bft Tankstelle Hartenstein', 'Lölfin Tankstelle',\n",
       "       'Freie Tankstelle Fuhr', 'Freie Tankstelle Meyer ',\n",
       "       'HAWA Flüssiggas GmbH', 'V-Markt Saulgrub',\n",
       "       'Tankstelle Schutzbach', ' Freie Tankstelle Hirschmann',\n",
       "       'AUTO ZOTZ Herxheim b.LD.       Tanken an L.493',\n",
       "       'Rubart Mineralöl', 'MTB Tankstelle Saarbrücken',\n",
       "       'TS Karmann tanken & sparen',\n",
       "       'Schillhorn Mineralöle GmbH Süderhastedt', 'Kaiser-Tankstelle',\n",
       "       'Schäfer', 'Freie Tankstelle Baumann', 'V-Markt Schwabmünchen',\n",
       "       'OTTO HATTENDORF GmbH', 'B-Station', 'FT Freie Tankstelle',\n",
       "       'SB Tankstelle Raker', 'freie Tankstelle Schmelzer',\n",
       "       'Kfz-Werkstatt u. Tankstelle Winkler', 'V-Markt Burgau',\n",
       "       'Schütz - Freie Tankstelle', 'Tank und Waschservice Schuch',\n",
       "       'Freie Tankstelle Hans Hummel', 'Meiers39',\n",
       "       'Freie Tankstellen Spathelf', 'Autohaus Knoepfle', 'classic',\n",
       "       'Preis', 'Tankstelle Kuhn', 'BFT Eilsleben',\n",
       "       'Freie Tankstelle GS Tank Schmidt', 'TINQ',\n",
       "       'Freie Tankstelle Salewski', 'Classic Knoll',\n",
       "       'FTF Tankstelle Mulda', 'Autohaus Fritz Pieper',\n",
       "       'Die Tankstelle Uwe Giersch', 'Freie Tankstelle Feher',\n",
       "       'Tankhof Anders', 'KTS GmbH', 'Tankstelle Dreyer',\n",
       "       'DOC - Freie Tankstelle',\n",
       "       'Tank- und Waschcenter BSB in Bersenbrück', 'CARL MENNER',\n",
       "       'Hüter Einkaufszentrum', 'Freie Tankstelle Struthütten',\n",
       "       'FREIE Tankstelle', 'Freie Tankstelle Witzel', 'Ultsch',\n",
       "       'SB-Tankstelle Illerpark Rieden', 'Graf', 'BFT                  ',\n",
       "       'Auto Seidl', 'Freie Tankstelle Krause', 'V-Markt Kirchheim',\n",
       "       'Robert Raimund e.K.', 'V-Markt Illertissen', 'SKY',\n",
       "       'Freie Tankstelle Blatt', 'Freie Tankstelle Niederl', 'Die Grüne',\n",
       "       'Tankstelle Wiegand', 'Tankstelle Brey',\n",
       "       'Freie Tankstelle Schramm', 'Autohaus Eyßelein',\n",
       "       'LD Tankstelle Herlikofen', 'SWE Südwestenergie GmbH',\n",
       "       'nicht mehr aktiv', 'LOMO', 'Egon von Haw', 'FT',\n",
       "       'Tankstelle Heinz', 'Greenol', 'bft Tankstelle Reinersmann',\n",
       "       'Globus Baumarkt', 'Freie Tankstelle Thode', 'Autohaus Maier',\n",
       "       'SUED TREIBSTOFF', 'Iboil', 'Kuster Oil GmbH',\n",
       "       'Freie Tankstelle Ihringen', 'Raiffeisenbank Oberstadion',\n",
       "       'Beducker', 'BFT Pickelmann', 'freie', 'Tank und Waschcenter',\n",
       "       'Flora Park', 'Easy Sprit', 'Eberhardt Jöhlingen', 'EXTROL',\n",
       "       'WATA waschen & tanken eK.', 'EDEKA Walke',\n",
       "       'Mineralölvertrieb Noeke GmbH', 'SB Tankstelle E&S',\n",
       "       'Schumacher Roisdorf', 'TankCenter Europoint',\n",
       "       'Wengel & Dettelbacher GmbH', 'Freie Tankstelle Mangold',\n",
       "       'Freie Tankstelle Herbert Klink', 'TWS Niederfüllbach',\n",
       "       'Wippenhohn', 'V-Markt Ichenhausen',\n",
       "       'Brzezina / Wiechers Diepholz', 'freie Tankstelle Endrass',\n",
       "       'V-Markt Landsberg', 'EC-Tankstelle Meemken', 'V-Markt Erkheim',\n",
       "       'Tank Schäfer', 'Tankstelle West - Welldorf',\n",
       "       'LD Tankstelle Öhringen', 'PINK', 'Kühling Tankstelle',\n",
       "       'Rundel Mineralölvertrieb', 'Freie Tankstelle Lachmund GmbH',\n",
       "       'Freie Tankstelle Bayer', 'bft-Tankstelle Vogl', 'Hirschmann',\n",
       "       'Freie Tankstelle Leyh GmbH', 'Classic Rademacher',\n",
       "       'Tankstelle Schäfer', 'Nicht mehr aktiv', 'H & F Logistik GmbH',\n",
       "       'Saggel GbR Lauenförde', 'Autohaus Jagow', 'Doukkali Autoservice',\n",
       "       'Kaiser Freie Tankstelle/Shop', 'Wingenfeld Energie Gmbh',\n",
       "       'Oel - Heim', 'roth', 'S-TANK Langenpettenbach', 'K&S',\n",
       "       'Autohaus Braun', 'Kfz-Kleppel', 'TS Narr', 'Tankstelle Ehret',\n",
       "       'Walther Tankstelle', '24h Tankstelle Schmidtler // Joe´s Carwash',\n",
       "       'LIQUI-MOLY', 'Tankstelle Buckreus', 'Raiffeisen Agil',\n",
       "       'Autohaus Bauer', 'Wingenfeld', 'Rottal Tankstelle  ', 'C+C Markt',\n",
       "       'Bau-Markt Buchloe', 'Autohaus Kupferschmid', 'Ludwig Mineralöle',\n",
       "       'V-Markt Nesselwang', 'NEO', 'Dieseltankstelle Mauch',\n",
       "       'Tramin City Tank', 'DEMO Tank', ' Autohof Frechen (Mundorf Tank)',\n",
       "       'Citi Oil SB Tankstelle', 'Autohaus Kaiser GmbH',\n",
       "       'V-Markt Mainburg', 'Freie SB-Tankstelle Feil',\n",
       "       'Freie Tankstelle Teichmann', 'Ott Transporte-Tankstelle e.K.',\n",
       "       'Bft zum Boxenstop', 'MHB Markt-Tankstelle am ACC ',\n",
       "       'DONIG ARAL-Vertrieb',\n",
       "       'Raiffeisen-Warengenossenschaft Budjadingen-Seefeld eG',\n",
       "       'Eberhardt Hambrücken', 'Unger + Guthier GmbH', 'BauXpert Gebhard',\n",
       "       'Avia Schmidt', 'Tankstelle Hörlin', 'Schlicker Transport GmbH ',\n",
       "       'BAG Creglingen', 'L.Baierer ', 'Wurzer R. - Freie Tankstelle',\n",
       "       'Tankstelle Kolb', 'Wörner', 'gelöscht'], dtype=object)"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tankstellen['brand'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "75202ab4-5d05-4c35-b695-93c93e17193f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c722dce4-4bc0-4d31-90ba-bd1856f4810f",
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}