{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "eae0b105-af7c-4aa3-8905-3a23234ac057", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:50:05.243843Z", "iopub.status.busy": "2026-06-17T12:50:05.243542Z", "iopub.status.idle": "2026-06-17T12:50:05.501857Z", "shell.execute_reply": "2026-06-17T12:50:05.501026Z", "shell.execute_reply.started": "2026-06-17T12:50:05.243808Z" } }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 4, "id": "ff0f5d93-729e-4538-8c8c-90a28268e66d", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:50:54.208328Z", "iopub.status.busy": "2026-06-17T12:50:54.208073Z", "iopub.status.idle": "2026-06-17T12:50:55.257136Z", "shell.execute_reply": "2026-06-17T12:50:55.256280Z", "shell.execute_reply.started": "2026-06-17T12:50:54.208303Z" } }, "outputs": [], "source": [ "preise =pd.read_csv('https://data.hsbo.de/tankpreise_Bochum_2020.csv')" ] }, { "cell_type": "code", "execution_count": 5, "id": "e534dde2-56ce-4003-a557-a21c632705e1", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:50:56.963020Z", "iopub.status.busy": "2026-06-17T12:50:56.962718Z", "iopub.status.idle": "2026-06-17T12:50:56.974609Z", "shell.execute_reply": "2026-06-17T12:50:56.973886Z", "shell.execute_reply.started": "2026-06-17T12:50:56.962983Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datestation_uuiddiesele5e10dieselchangee5changee10change
02020-01-01 02:03:03+01b7dc5a11-661a-419f-8d30-d9763b2897c71.2891.4091.369001
12020-01-01 04:36:04+0151d4b638-a095-1aa0-e100-80009459e03a1.3091.4291.409111
22020-01-01 04:36:04+0151d4b671-a095-1aa0-e100-80009459e03a1.3191.4391.399111
32020-01-01 04:36:04+0151d4b500-a095-1aa0-e100-80009459e03a1.3191.4391.419111
42020-01-01 04:36:04+01cd8b8686-d085-1ed7-a59b-163f66bf05c41.3191.4391.419111
\n", "
" ], "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": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "preise.head()" ] }, { "cell_type": "code", "execution_count": 6, "id": "4a1e5e67-a484-4ddb-8f51-57f209099da5", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:51:45.123519Z", "iopub.status.busy": "2026-06-17T12:51:45.123212Z", "iopub.status.idle": "2026-06-17T12:51:45.297191Z", "shell.execute_reply": "2026-06-17T12:51:45.296207Z", "shell.execute_reply.started": "2026-06-17T12:51:45.123487Z" } }, "outputs": [], "source": [ "tankstellen =pd.read_csv('https://data.hsbo.de/tankstellen.csv')" ] }, { "cell_type": "code", "execution_count": 7, "id": "2733c980-6cb2-4a93-a806-9936c39c5e9e", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:51:45.526461Z", "iopub.status.busy": "2026-06-17T12:51:45.526180Z", "iopub.status.idle": "2026-06-17T12:51:45.539802Z", "shell.execute_reply": "2026-06-17T12:51:45.538818Z", "shell.execute_reply.started": "2026-06-17T12:51:45.526428Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
uuidnamebrandstreethouse_numberpost_codecitylatitudelongitude
000060723-0001-4444-8888-acdc00000001BAGeno Raiffeisen eGNaNKünzelsauer Strasse774653Ingelfingen49.2968229.661385
1005056ba-7cb6-1ed2-bceb-5332ab168d12famila TankstelleFAMILAPascalstrasse925442Quickborn53.7421509.941240
2005056ba-7cb6-1ed2-bceb-573c18314d16star TankstelleSTARRiehler Strasse24050735Köln50.9618006.980070
3005056ba-7cb6-1ed2-bceb-662ba1a94d1fstar TankstelleSTARBAB 10 / Seeberg OstNaN15345Altlandsberg52.55016013.682120
4005056ba-7cb6-1ed2-bceb-6f7b23564d23star TankstelleSTARDuisburger Straße13047166Duisburg51.4897906.783730
\n", "
" ], "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": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen.head()" ] }, { "cell_type": "code", "execution_count": 8, "id": "4330d762-8a46-4e63-a08f-f52e4da9cd25", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:52:41.455290Z", "iopub.status.busy": "2026-06-17T12:52:41.454985Z", "iopub.status.idle": "2026-06-17T12:52:41.462083Z", "shell.execute_reply": "2026-06-17T12:52:41.461124Z", "shell.execute_reply.started": "2026-06-17T12:52:41.455258Z" } }, "outputs": [ { "data": { "text/plain": [ "899" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen['brand'].nunique()" ] }, { "cell_type": "code", "execution_count": 9, "id": "1219b239-d8f4-4766-8fda-b50499e6d498", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:53:10.791376Z", "iopub.status.busy": "2026-06-17T12:53:10.791078Z", "iopub.status.idle": "2026-06-17T12:53:10.797738Z", "shell.execute_reply": "2026-06-17T12:53:10.796740Z", "shell.execute_reply.started": "2026-06-17T12:53:10.791344Z" } }, "outputs": [ { "data": { "text/plain": [ "\n", "[ nan, 'FAMILA',\n", " 'STAR', 'ARAL',\n", " 'Freie', 'AVIA',\n", " 'Shell', 'M1',\n", " 'Westfalen', 'ESSO',\n", " ...\n", " 'BauXpert Gebhard', 'Avia Schmidt',\n", " 'Tankstelle Hörlin', 'Schlicker Transport GmbH ',\n", " 'BAG Creglingen', 'L.Baierer ',\n", " 'Wurzer R. - Freie Tankstelle', 'Tankstelle Kolb',\n", " 'Wörner', 'gelöscht']\n", "Length: 900, dtype: str" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen['brand'].unique()" ] }, { "cell_type": "code", "execution_count": 10, "id": "f26826f4-1a77-4885-b717-cdcd5a5d2ea8", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:58:33.434381Z", "iopub.status.busy": "2026-06-17T12:58:33.434077Z", "iopub.status.idle": "2026-06-17T12:58:33.440917Z", "shell.execute_reply": "2026-06-17T12:58:33.439942Z", "shell.execute_reply.started": "2026-06-17T12:58:33.434349Z" } }, "outputs": [], "source": [ "tankstellen_bo = tankstellen[ tankstellen['city'] == 'Bochum' ]" ] }, { "cell_type": "code", "execution_count": 15, "id": "538dd247-4776-4f68-97b0-cd4b0ae94354", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:59:50.836254Z", "iopub.status.busy": "2026-06-17T12:59:50.835965Z", "iopub.status.idle": "2026-06-17T12:59:50.840231Z", "shell.execute_reply": "2026-06-17T12:59:50.839476Z", "shell.execute_reply.started": "2026-06-17T12:59:50.836238Z" } }, "outputs": [ { "data": { "text/plain": [ "34" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen_bo.shape[0]" ] }, { "cell_type": "code", "execution_count": 16, "id": "0ed8455d-0071-46f5-b8ae-2b0d7c177477", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T12:59:56.990779Z", "iopub.status.busy": "2026-06-17T12:59:56.990503Z", "iopub.status.idle": "2026-06-17T12:59:57.006175Z", "shell.execute_reply": "2026-06-17T12:59:57.005450Z", "shell.execute_reply.started": "2026-06-17T12:59:56.990749Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
uuidnamebrandstreethouse_numberpost_codecitylatitudelongitude
2510fc7548-e99d-4fda-b80d-48f5ea40e84dHeike ReineckeWestfalenAlte Wittener Str.4044803Bochum51.4686707.271020
593bfab341-1f1e-49e0-8c32-bc77ca730e57Aral TankstelleARALA40RaststätteBeverbac44892Bochum51.4940227.339435
624005056ba-7cb6-1ed2-bceb-6ef642fc2d23star TankstelleSTARWestenfelder Straße13444867Bochum51.4721407.144930
659005056ba-7cb6-1ed2-bceb-77ca3e088d25star TankstelleSTARDorstener Straße34344809Bochum51.5009007.188580
768005056ba-7cb6-1ed2-bceb-966c48c48d38star TankstelleSTARHattinger Straße702-70444879Bochum51.4327207.171890
\n", "
" ], "text/plain": [ " uuid name brand \\\n", "25 10fc7548-e99d-4fda-b80d-48f5ea40e84d Heike Reinecke Westfalen \n", "59 3bfab341-1f1e-49e0-8c32-bc77ca730e57 Aral Tankstelle ARAL \n", "624 005056ba-7cb6-1ed2-bceb-6ef642fc2d23 star Tankstelle STAR \n", "659 005056ba-7cb6-1ed2-bceb-77ca3e088d25 star Tankstelle STAR \n", "768 005056ba-7cb6-1ed2-bceb-966c48c48d38 star Tankstelle STAR \n", "\n", " street house_number post_code city latitude \\\n", "25 Alte Wittener Str. 40 44803 Bochum 51.468670 \n", "59 A 40RaststätteBeverbac 44892 Bochum 51.494022 \n", "624 Westenfelder Straße 134 44867 Bochum 51.472140 \n", "659 Dorstener Straße 343 44809 Bochum 51.500900 \n", "768 Hattinger Straße 702-704 44879 Bochum 51.432720 \n", "\n", " longitude \n", "25 7.271020 \n", "59 7.339435 \n", "624 7.144930 \n", "659 7.188580 \n", "768 7.171890 " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen_bo.head()" ] }, { "cell_type": "code", "execution_count": 18, "id": "10a98569-64d0-488e-b777-181fbcf68e3f", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:01:04.431153Z", "iopub.status.busy": "2026-06-17T13:01:04.430850Z", "iopub.status.idle": "2026-06-17T13:01:04.437406Z", "shell.execute_reply": "2026-06-17T13:01:04.436462Z", "shell.execute_reply.started": "2026-06-17T13:01:04.431121Z" } }, "outputs": [ { "data": { "text/plain": [ "\n", "[ 'Westfalen', 'ARAL', 'STAR',\n", " 'Markant', 'BFT Tankhof Stein', 'OIL!',\n", " 'SB', 'TinQ', 'Classic Tankstelle',\n", " 'Freie Tankstelle', 'HEM', 'GO']\n", "Length: 12, dtype: str" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen_bo['brand'].unique()" ] }, { "cell_type": "code", "execution_count": 19, "id": "b2bf43c4-d210-4df1-9444-636f2f12b704", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:01:15.186723Z", "iopub.status.busy": "2026-06-17T13:01:15.186414Z", "iopub.status.idle": "2026-06-17T13:01:15.192822Z", "shell.execute_reply": "2026-06-17T13:01:15.191844Z", "shell.execute_reply.started": "2026-06-17T13:01:15.186690Z" } }, "outputs": [ { "data": { "text/plain": [ "12" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellen_bo['brand'].nunique()" ] }, { "cell_type": "code", "execution_count": 22, "id": "d440e75e-09ab-42b5-ab48-21d6662a7527", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:03:57.771761Z", "iopub.status.busy": "2026-06-17T13:03:57.771595Z", "iopub.status.idle": "2026-06-17T13:03:57.779663Z", "shell.execute_reply": "2026-06-17T13:03:57.778901Z", "shell.execute_reply.started": "2026-06-17T13:03:57.771746Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
datestation_uuiddiesele5e10dieselchangee5changee10change
02020-01-01 02:03:03+01b7dc5a11-661a-419f-8d30-d9763b2897c71.2891.4091.369001
12020-01-01 04:36:04+0151d4b638-a095-1aa0-e100-80009459e03a1.3091.4291.409111
22020-01-01 04:36:04+0151d4b671-a095-1aa0-e100-80009459e03a1.3191.4391.399111
32020-01-01 04:36:04+0151d4b500-a095-1aa0-e100-80009459e03a1.3191.4391.419111
42020-01-01 04:36:04+01cd8b8686-d085-1ed7-a59b-163f66bf05c41.3191.4391.419111
\n", "
" ], "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": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "preise.head()" ] }, { "cell_type": "code", "execution_count": 23, "id": "687a2f43-5fe8-411c-a2de-483ee5417561", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:04:47.146911Z", "iopub.status.busy": "2026-06-17T13:04:47.146608Z", "iopub.status.idle": "2026-06-17T13:04:47.151600Z", "shell.execute_reply": "2026-06-17T13:04:47.150689Z", "shell.execute_reply.started": "2026-06-17T13:04:47.146879Z" } }, "outputs": [], "source": [ "preise.columns = [ 'date', 'uuid', 'diesel', 'e5', 'e10', 'dieselchange', 'e5change', 'e10change' ]" ] }, { "cell_type": "code", "execution_count": 25, "id": "a8d36e54-9881-4e00-a02d-66a88145a3b6", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:06:26.551016Z", "iopub.status.busy": "2026-06-17T13:06:26.550753Z", "iopub.status.idle": "2026-06-17T13:06:26.642526Z", "shell.execute_reply": "2026-06-17T13:06:26.641694Z", "shell.execute_reply.started": "2026-06-17T13:06:26.550988Z" } }, "outputs": [], "source": [ "tankstellenPreise = preise.merge(tankstellen)" ] }, { "cell_type": "code", "execution_count": 27, "id": "f8affea5-3be9-48b6-89e7-35294bc53522", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:07:09.990592Z", "iopub.status.busy": "2026-06-17T13:07:09.990288Z", "iopub.status.idle": "2026-06-17T13:07:10.010278Z", "shell.execute_reply": "2026-06-17T13:07:10.009205Z", "shell.execute_reply.started": "2026-06-17T13:07:09.990559Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dateuuiddiesele5e10dieselchangee5changee10changenamebrandstreethouse_numberpost_codecitylatitudelongitude
02020-01-01 02:03:03+01b7dc5a11-661a-419f-8d30-d9763b2897c71.2891.4091.369001Bochum, Wittenerstr. 361SBWittenerstr. 361NaN44803Bochum51.4724077.259509
12020-01-01 04:36:04+0151d4b638-a095-1aa0-e100-80009459e03a1.3091.4291.409111Supermarkt-Tankstelle am real,- Markt BOCHUM O...Supermarkt-Tankstelle am real,- MarktOTTOSTR. 40 - 43NaN44867BOCHUM51.4722007.121800
\n", "
" ], "text/plain": [ " date 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", "\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", "\n", " name \\\n", "0 Bochum, Wittenerstr. 361 \n", "1 Supermarkt-Tankstelle am real,- Markt BOCHUM O... \n", "\n", " brand street house_number \\\n", "0 SB Wittenerstr. 361 NaN \n", "1 Supermarkt-Tankstelle am real,- Markt OTTOSTR. 40 - 43 NaN \n", "\n", " post_code city latitude longitude \n", "0 44803 Bochum 51.472407 7.259509 \n", "1 44867 BOCHUM 51.472200 7.121800 " ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise.head(2)" ] }, { "cell_type": "code", "execution_count": 28, "id": "e9ed413a-58a7-4fb2-8b25-ac7f3f5583c3", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:07:23.841882Z", "iopub.status.busy": "2026-06-17T13:07:23.841587Z", "iopub.status.idle": "2026-06-17T13:07:23.848162Z", "shell.execute_reply": "2026-06-17T13:07:23.847396Z", "shell.execute_reply.started": "2026-06-17T13:07:23.841850Z" } }, "outputs": [ { "data": { "text/plain": [ "np.float64(1.0953806420845342)" ] }, "execution_count": 28, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise['diesel'].mean()" ] }, { "cell_type": "code", "execution_count": 29, "id": "ccecd209-6b01-47ed-b3be-bebdd5181b7b", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:08:13.960529Z", "iopub.status.busy": "2026-06-17T13:08:13.960226Z", "iopub.status.idle": "2026-06-17T13:08:14.026114Z", "shell.execute_reply": "2026-06-17T13:08:14.025131Z", "shell.execute_reply.started": "2026-06-17T13:08:13.960496Z" } }, "outputs": [], "source": [ "tankstellenPreise_bo = tankstellenPreise[ tankstellenPreise['city'] == 'Bochum' ]" ] }, { "cell_type": "code", "execution_count": 30, "id": "d257d758-0f47-42f1-b4b3-770329f25eec", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:08:40.359536Z", "iopub.status.busy": "2026-06-17T13:08:40.359220Z", "iopub.status.idle": "2026-06-17T13:08:40.364330Z", "shell.execute_reply": "2026-06-17T13:08:40.363685Z", "shell.execute_reply.started": "2026-06-17T13:08:40.359504Z" } }, "outputs": [ { "data": { "text/plain": [ "np.float64(1.09217639967943)" ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise_bo['diesel'].mean()" ] }, { "cell_type": "code", "execution_count": 34, "id": "6b4d656b-4dec-4a0a-9074-3991dd892f0f", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:13:29.364131Z", "iopub.status.busy": "2026-06-17T13:13:29.363826Z", "iopub.status.idle": "2026-06-17T13:13:29.368458Z", "shell.execute_reply": "2026-06-17T13:13:29.367616Z", "shell.execute_reply.started": "2026-06-17T13:13:29.364098Z" } }, "outputs": [ { "data": { "text/plain": [ "0.08765150850004158" ] }, "execution_count": 34, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise_bo['diesel'].std()" ] }, { "cell_type": "code", "execution_count": 36, "id": "aec4d71f-9d33-49ad-b9ac-dda1df2094b3", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:13:51.610531Z", "iopub.status.busy": "2026-06-17T13:13:51.610223Z", "iopub.status.idle": "2026-06-17T13:13:51.630988Z", "shell.execute_reply": "2026-06-17T13:13:51.630066Z", "shell.execute_reply.started": "2026-06-17T13:13:51.610498Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dateuuiddiesele5e10dieselchangee5changee10changenamebrandstreethouse_numberpost_codecitylatitudelongitude
02020-01-01 02:03:03+01b7dc5a11-661a-419f-8d30-d9763b2897c71.2891.4091.369001Bochum, Wittenerstr. 361SBWittenerstr. 361NaN44803Bochum51.4724077.259509
52020-01-01 04:52:03+01836a1517-3843-467b-377a-c08344a300c61.3081.4281.408111TinQ BochumTinQGünningfelder Str.3944866Bochum51.4936007.143640
\n", "
" ], "text/plain": [ " date uuid diesel \\\n", "0 2020-01-01 02:03:03+01 b7dc5a11-661a-419f-8d30-d9763b2897c7 1.289 \n", "5 2020-01-01 04:52:03+01 836a1517-3843-467b-377a-c08344a300c6 1.308 \n", "\n", " e5 e10 dieselchange e5change e10change name \\\n", "0 1.409 1.369 0 0 1 Bochum, Wittenerstr. 361 \n", "5 1.428 1.408 1 1 1 TinQ Bochum \n", "\n", " brand street house_number post_code city latitude \\\n", "0 SB Wittenerstr. 361 NaN 44803 Bochum 51.472407 \n", "5 TinQ Günningfelder Str. 39 44866 Bochum 51.493600 \n", "\n", " longitude \n", "0 7.259509 \n", "5 7.143640 " ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise_bo.head(2)" ] }, { "cell_type": "code", "execution_count": 39, "id": "b0268ce9-89ac-440a-a31e-f4fd2579d1a3", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:17:56.583366Z", "iopub.status.busy": "2026-06-17T13:17:56.583063Z", "iopub.status.idle": "2026-06-17T13:17:56.622487Z", "shell.execute_reply": "2026-06-17T13:17:56.621326Z", "shell.execute_reply.started": "2026-06-17T13:17:56.583334Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
diesele5e10
brand
ARAL1.4691.6091.589
BFT Tankhof Stein1.3791.4991.490
Classic Tankstelle1.4091.5391.529
Freie Tankstelle1.3991.5191.499
GO1.3891.5091.489
HEM1.3891.5091.489
Markant1.3991.5091.489
OIL!1.4391.5391.519
SB1.3891.5091.469
STAR1.4091.5291.509
TinQ1.3881.5081.488
Westfalen1.4191.5491.539
\n", "
" ], "text/plain": [ " diesel e5 e10\n", "brand \n", "ARAL 1.469 1.609 1.589\n", "BFT Tankhof Stein 1.379 1.499 1.490\n", "Classic Tankstelle 1.409 1.539 1.529\n", "Freie Tankstelle 1.399 1.519 1.499\n", "GO 1.389 1.509 1.489\n", "HEM 1.389 1.509 1.489\n", "Markant 1.399 1.509 1.489\n", "OIL! 1.439 1.539 1.519\n", "SB 1.389 1.509 1.469\n", "STAR 1.409 1.529 1.509\n", "TinQ 1.388 1.508 1.488\n", "Westfalen 1.419 1.549 1.539" ] }, "execution_count": 39, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tankstellenPreise_bo.loc[:,['diesel','e5','e10', 'brand']].groupby('brand').max()" ] }, { "cell_type": "code", "execution_count": 40, "id": "b1025cef-917d-412a-9114-b4a09c6f1ad3", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:28:28.937903Z", "iopub.status.busy": "2026-06-17T13:28:28.937601Z", "iopub.status.idle": "2026-06-17T13:28:28.942196Z", "shell.execute_reply": "2026-06-17T13:28:28.941097Z", "shell.execute_reply.started": "2026-06-17T13:28:28.937872Z" } }, "outputs": [], "source": [ "a = 3\n", "b = 3\n", "c = (3**2 + 3**2)**0.5" ] }, { "cell_type": "code", "execution_count": 41, "id": "147711c0-8176-49ea-baaa-28bc4fbd650d", "metadata": { "execution": { "iopub.execute_input": "2026-06-17T13:28:30.022195Z", "iopub.status.busy": "2026-06-17T13:28:30.021934Z", "iopub.status.idle": "2026-06-17T13:28:30.027020Z", "shell.execute_reply": "2026-06-17T13:28:30.026005Z", "shell.execute_reply.started": "2026-06-17T13:28:30.022166Z" } }, "outputs": [ { "data": { "text/plain": [ "4.242640687119285" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "c" ] }, { "cell_type": "code", "execution_count": null, "id": "1294fde6-22e9-4fa7-a44d-19f47a390bf6", "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.13.13" } }, "nbformat": 4, "nbformat_minor": 5 }