Skip to content

Instantly share code, notes, and snippets.

@P3nny

P3nny/sirenenliste.ipynb

Last active January 4, 2016 21:56
Show Gist options
  • Save P3nny/dc7d0306cf6743a5f43d to your computer and use it in GitHub Desktop.
Save P3nny/dc7d0306cf6743a5f43d to your computer and use it in GitHub Desktop.
Download ZIP
Data Cleansing an offenen Daten aus Köln
Display the source blob
Display the rendered blob
Raw
sirenenliste.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"# Sirenenstandorte Köln #\n",
"\n",
"Data Cleansing am Beispiel von offenen Daten aus Köln\n",
"\n",
"Liste der Sirenstandorte in Köln \n",
"\n",
"[http://www.offenedaten-koeln.de/dataset/8ea02fcd-7b32-4557-8b92-764df6f9edb8/resource/8ea02fcd-7b32-4557-8b92-764df6f9edb8]\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## 1. Frage: Welche Sirene hat den höchsten Mast? ##\n"
]
},
{
"cell_type": "code",
"execution_count": 162,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Stadtteil</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>Emdener Str.</td>\n",
" <td>Niehl</td>\n",
" <td>50735</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>Fühlinger See, Am Strandbad</td>\n",
" <td>Fühlingen</td>\n",
" <td>50769</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>Stresemannstr. 15</td>\n",
" <td>Porz</td>\n",
" <td>51149</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Vingster Ring/Ecke Frankfurter Str.</td>\n",
" <td>Ostheim</td>\n",
" <td>51107</td>\n",
" <td>EPS 2400S</td>\n",
" <td>1000</td>\n",
" <td>Mast 24,5m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Sürther Str.</td>\n",
" <td>Rodenkirchen</td>\n",
" <td>50996</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>Rondorfer Hauptstr.</td>\n",
" <td>Rondorf</td>\n",
" <td>50997</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>7</td>\n",
" <td>Theodor-Zingsheim-Weg</td>\n",
" <td>Müngersdorf</td>\n",
" <td>50933</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>8</td>\n",
" <td>Nüssenberger Busch</td>\n",
" <td>Mengenich</td>\n",
" <td>50829</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>9</td>\n",
" <td>Friedrich-Karl-Str. 261</td>\n",
" <td>Riehl</td>\n",
" <td>50735</td>\n",
" <td>ECN 2400</td>\n",
" <td>1200</td>\n",
" <td>Mast 23m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>10</td>\n",
" <td>Bayer AG, Werksgelände Flittard Tor 11</td>\n",
" <td>Flittard</td>\n",
" <td>51061</td>\n",
" <td>ECN 1800</td>\n",
" <td>800</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>11</td>\n",
" <td>Klärwerk Stammheim</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 1800</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>12</td>\n",
" <td>An der Joch 3</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>13</td>\n",
" <td>Ecke Dünnwalder Kommunalweg/Am weißen Mönch</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 2400</td>\n",
" <td>gerichtet 1200</td>\n",
" <td>Mast</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>14</td>\n",
" <td>Erdölchemie Further Weg</td>\n",
" <td>Roggendorf/Thenhoven</td>\n",
" <td>51069</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>15</td>\n",
" <td>Krötschweg 1</td>\n",
" <td>Worringen</td>\n",
" <td>50769</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>16</td>\n",
" <td>AKZO Niehl, Geestemünder Str. 26</td>\n",
" <td>Niehl</td>\n",
" <td>50827</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>17</td>\n",
" <td>Scheibenstr.13</td>\n",
" <td>Weidenpesch</td>\n",
" <td>50737</td>\n",
" <td>ECN 3600</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>18</td>\n",
" <td>Ossietzkystr. Longerich-Süd</td>\n",
" <td>Longerich</td>\n",
" <td>50737</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast 23m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>19</td>\n",
" <td>Longericher Hauptstr. 83 - 85, Longerich-West</td>\n",
" <td>Longerich</td>\n",
" <td>50739</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>20</td>\n",
" <td>Neusser Landstr.16, Longerich-Nord</td>\n",
" <td>Longerich</td>\n",
" <td>50735</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse \\\n",
"0 1 Emdener Str. \n",
"1 2 Fühlinger See, Am Strandbad \n",
"2 3 Stresemannstr. 15 \n",
"3 4 Vingster Ring/Ecke Frankfurter Str. \n",
"4 5 Sürther Str. \n",
"5 6 Rondorfer Hauptstr. \n",
"6 7 Theodor-Zingsheim-Weg \n",
"7 8 Nüssenberger Busch \n",
"8 9 Friedrich-Karl-Str. 261 \n",
"9 10 Bayer AG, Werksgelände Flittard Tor 11 \n",
"10 11 Klärwerk Stammheim \n",
"11 12 An der Joch 3 \n",
"12 13 Ecke Dünnwalder Kommunalweg/Am weißen Mönch \n",
"13 14 Erdölchemie Further Weg \n",
"14 15 Krötschweg 1 \n",
"15 16 AKZO Niehl, Geestemünder Str. 26 \n",
"16 17 Scheibenstr.13 \n",
"17 18 Ossietzkystr. Longerich-Süd \n",
"18 19 Longericher Hauptstr. 83 - 85, Longerich-West \n",
"19 20 Neusser Landstr.16, Longerich-Nord \n",
"\n",
" Stadtteil Plz Art der Sirene / Leistung in Watt \\\n",
"0 Niehl 50735 HLS \n",
"1 Fühlingen 50769 HLS \n",
"2 Porz 51149 HLS \n",
"3 Ostheim 51107 EPS 2400S \n",
"4 Rodenkirchen 50996 HLS \n",
"5 Rondorf 50997 HLS \n",
"6 Müngersdorf 50933 EPS 2400S \n",
"7 Mengenich 50829 EPS 2400S \n",
"8 Riehl 50735 ECN 2400 \n",
"9 Flittard 51061 ECN 1800 \n",
"10 Stammheim 51061 ECN 1800 \n",
"11 Stammheim 51061 ECN 2400 \n",
"12 Stammheim 51061 ECN 2400 \n",
"13 Roggendorf/Thenhoven 51069 ECN 2400 \n",
"14 Worringen 50769 ECN 2400 \n",
"15 Niehl 50827 ECN 2400 \n",
"16 Weidenpesch 50737 ECN 3600 \n",
"17 Longerich 50737 ECN 2400 \n",
"18 Longerich 50739 ECN 2400 \n",
"19 Longerich 50735 ECN 2400 \n",
"\n",
" Radius in m Aufbau /Befestigung \n",
"0 1000 Mast 25m \n",
"1 1000 Mast 20m \n",
"2 1000 Mast 20m \n",
"3 1000 Mast 24,5m \n",
"4 1000 Mast 25m \n",
"5 1000 Mast 25m \n",
"6 800 Mast 24,5m \n",
"7 800 Mast 24,5m \n",
"8 1200 Mast 23m \n",
"9 800 Gebäude \n",
"10 1000 Gebäude \n",
"11 1000 Gebäude \n",
"12 gerichtet 1200 Mast \n",
"13 1000 Mast \n",
"14 1000 Gebäude \n",
"15 1000 Gebäude \n",
"16 1000 Gebäude \n",
"17 1000 Mast 23m \n",
"18 1000 Gebäude \n",
"19 1000 Gebäude "
]
},
"execution_count": 162,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"import re\n",
"f = '2015-08-11Sirenenliste.csv'\n",
"df = pd.read_csv(f, sep=';')\n",
"df1 = df\n",
"df1.head(20)"
]
},
{
"cell_type": "code",
"execution_count": 163,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Stadtteil</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>Emdener Str.</td>\n",
" <td>Niehl</td>\n",
" <td>50735</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>Fühlinger See, Am Strandbad</td>\n",
" <td>Fühlingen</td>\n",
" <td>50769</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>Stresemannstr. 15</td>\n",
" <td>Porz</td>\n",
" <td>51149</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Vingster Ring/Ecke Frankfurter Str.</td>\n",
" <td>Ostheim</td>\n",
" <td>51107</td>\n",
" <td>EPS 2400S</td>\n",
" <td>1000</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Sürther Str.</td>\n",
" <td>Rodenkirchen</td>\n",
" <td>50996</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse Stadtteil Plz \\\n",
"0 1 Emdener Str. Niehl 50735 \n",
"1 2 Fühlinger See, Am Strandbad Fühlingen 50769 \n",
"2 3 Stresemannstr. 15 Porz 51149 \n",
"3 4 Vingster Ring/Ecke Frankfurter Str. Ostheim 51107 \n",
"4 5 Sürther Str. Rodenkirchen 50996 \n",
"\n",
" Art der Sirene / Leistung in Watt Radius in m Aufbau /Befestigung \\\n",
"0 HLS 1000 Mast 25m \n",
"1 HLS 1000 Mast 20m \n",
"2 HLS 1000 Mast 20m \n",
"3 EPS 2400S 1000 Mast 24,5m \n",
"4 HLS 1000 Mast 25m \n",
"\n",
" Mast \n",
"0 Mast 25m \n",
"1 Mast 20m \n",
"2 Mast 20m \n",
"3 Mast 24.5m \n",
"4 Mast 25m "
]
},
"execution_count": 163,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Die gesuchte Information steckt in der Spalte 'Aufbau /Befestigung'. \n",
"# Klar ist, dass nur Sirenen mitgewertet werden, die an Masten befestigt sind, deren Höhe auch angegeben ist \n",
"\n",
"# Zuerst werden ',' durch '.' ersetzt \n",
"df1['Mast'] = df1['Aufbau /Befestigung'].str.replace(',', '.')\n",
"df1.head()"
]
},
{
"cell_type": "code",
"execution_count": 164,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Stadtteil</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" <th>mast2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>Emdener Str.</td>\n",
" <td>Niehl</td>\n",
" <td>50735</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>Fühlinger See, Am Strandbad</td>\n",
" <td>Fühlingen</td>\n",
" <td>50769</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>Stresemannstr. 15</td>\n",
" <td>Porz</td>\n",
" <td>51149</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Vingster Ring/Ecke Frankfurter Str.</td>\n",
" <td>Ostheim</td>\n",
" <td>51107</td>\n",
" <td>EPS 2400S</td>\n",
" <td>1000</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Sürther Str.</td>\n",
" <td>Rodenkirchen</td>\n",
" <td>50996</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>Rondorfer Hauptstr.</td>\n",
" <td>Rondorf</td>\n",
" <td>50997</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>7</td>\n",
" <td>Theodor-Zingsheim-Weg</td>\n",
" <td>Müngersdorf</td>\n",
" <td>50933</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>8</td>\n",
" <td>Nüssenberger Busch</td>\n",
" <td>Mengenich</td>\n",
" <td>50829</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>9</td>\n",
" <td>Friedrich-Karl-Str. 261</td>\n",
" <td>Riehl</td>\n",
" <td>50735</td>\n",
" <td>ECN 2400</td>\n",
" <td>1200</td>\n",
" <td>Mast 23m</td>\n",
" <td>Mast 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>10</td>\n",
" <td>Bayer AG, Werksgelände Flittard Tor 11</td>\n",
" <td>Flittard</td>\n",
" <td>51061</td>\n",
" <td>ECN 1800</td>\n",
" <td>800</td>\n",
" <td>Gebäude</td>\n",
" <td>Gebäude</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>11</td>\n",
" <td>Klärwerk Stammheim</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 1800</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" <td>Gebäude</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>12</td>\n",
" <td>An der Joch 3</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" <td>Gebäude</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>13</td>\n",
" <td>Ecke Dünnwalder Kommunalweg/Am weißen Mönch</td>\n",
" <td>Stammheim</td>\n",
" <td>51061</td>\n",
" <td>ECN 2400</td>\n",
" <td>gerichtet 1200</td>\n",
" <td>Mast</td>\n",
" <td>Mast</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>14</td>\n",
" <td>Erdölchemie Further Weg</td>\n",
" <td>Roggendorf/Thenhoven</td>\n",
" <td>51069</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast</td>\n",
" <td>Mast</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>15</td>\n",
" <td>Krötschweg 1</td>\n",
" <td>Worringen</td>\n",
" <td>50769</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Gebäude</td>\n",
" <td>Gebäude</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse \\\n",
"0 1 Emdener Str. \n",
"1 2 Fühlinger See, Am Strandbad \n",
"2 3 Stresemannstr. 15 \n",
"3 4 Vingster Ring/Ecke Frankfurter Str. \n",
"4 5 Sürther Str. \n",
"5 6 Rondorfer Hauptstr. \n",
"6 7 Theodor-Zingsheim-Weg \n",
"7 8 Nüssenberger Busch \n",
"8 9 Friedrich-Karl-Str. 261 \n",
"9 10 Bayer AG, Werksgelände Flittard Tor 11 \n",
"10 11 Klärwerk Stammheim \n",
"11 12 An der Joch 3 \n",
"12 13 Ecke Dünnwalder Kommunalweg/Am weißen Mönch \n",
"13 14 Erdölchemie Further Weg \n",
"14 15 Krötschweg 1 \n",
"\n",
" Stadtteil Plz Art der Sirene / Leistung in Watt \\\n",
"0 Niehl 50735 HLS \n",
"1 Fühlingen 50769 HLS \n",
"2 Porz 51149 HLS \n",
"3 Ostheim 51107 EPS 2400S \n",
"4 Rodenkirchen 50996 HLS \n",
"5 Rondorf 50997 HLS \n",
"6 Müngersdorf 50933 EPS 2400S \n",
"7 Mengenich 50829 EPS 2400S \n",
"8 Riehl 50735 ECN 2400 \n",
"9 Flittard 51061 ECN 1800 \n",
"10 Stammheim 51061 ECN 1800 \n",
"11 Stammheim 51061 ECN 2400 \n",
"12 Stammheim 51061 ECN 2400 \n",
"13 Roggendorf/Thenhoven 51069 ECN 2400 \n",
"14 Worringen 50769 ECN 2400 \n",
"\n",
" Radius in m Aufbau /Befestigung Mast mast2 \n",
"0 1000 Mast 25m Mast 25m 25.0 \n",
"1 1000 Mast 20m Mast 20m 20.0 \n",
"2 1000 Mast 20m Mast 20m 20.0 \n",
"3 1000 Mast 24,5m Mast 24.5m 24.5 \n",
"4 1000 Mast 25m Mast 25m 25.0 \n",
"5 1000 Mast 25m Mast 25m 25.0 \n",
"6 800 Mast 24,5m Mast 24.5m 24.5 \n",
"7 800 Mast 24,5m Mast 24.5m 24.5 \n",
"8 1200 Mast 23m Mast 23m 23.0 \n",
"9 800 Gebäude Gebäude NaN \n",
"10 1000 Gebäude Gebäude NaN \n",
"11 1000 Gebäude Gebäude NaN \n",
"12 gerichtet 1200 Mast Mast NaN \n",
"13 1000 Mast Mast NaN \n",
"14 1000 Gebäude Gebäude NaN "
]
},
"execution_count": 164,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Per Regex werden dann aus der Spalte nur Zahlen gefiltert, eventuell (?) mit '.' und weiterer Zahl\n",
"# Die Zeile bekommt dann den Datentyp 'float'\n",
"df1['mast2'] = df1['Mast'].str.extract('(\\d+\\.?\\d)').astype(float)\n",
"df1.head(15)"
]
},
{
"cell_type": "code",
"execution_count": 165,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"lfd. Nummer object\n",
"Standort/Adresse object\n",
"Stadtteil object\n",
"Plz float64\n",
"Art der Sirene / Leistung in Watt object\n",
"Radius in m object\n",
"Aufbau /Befestigung object\n",
"Mast object\n",
"mast2 float64\n",
"dtype: object"
]
},
"execution_count": 165,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df1.dtypes"
]
},
{
"cell_type": "code",
"execution_count": 166,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Stadtteil</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" <th>mast2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>Emdener Str.</td>\n",
" <td>Niehl</td>\n",
" <td>50735</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>Fühlinger See, Am Strandbad</td>\n",
" <td>Fühlingen</td>\n",
" <td>50769</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>Stresemannstr. 15</td>\n",
" <td>Porz</td>\n",
" <td>51149</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Vingster Ring/Ecke Frankfurter Str.</td>\n",
" <td>Ostheim</td>\n",
" <td>51107</td>\n",
" <td>EPS 2400S</td>\n",
" <td>1000</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Sürther Str.</td>\n",
" <td>Rodenkirchen</td>\n",
" <td>50996</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse Stadtteil Plz \\\n",
"0 1 Emdener Str. Niehl 50735 \n",
"1 2 Fühlinger See, Am Strandbad Fühlingen 50769 \n",
"2 3 Stresemannstr. 15 Porz 51149 \n",
"3 4 Vingster Ring/Ecke Frankfurter Str. Ostheim 51107 \n",
"4 5 Sürther Str. Rodenkirchen 50996 \n",
"\n",
" Art der Sirene / Leistung in Watt Radius in m Aufbau /Befestigung \\\n",
"0 HLS 1000 Mast 25m \n",
"1 HLS 1000 Mast 20m \n",
"2 HLS 1000 Mast 20m \n",
"3 EPS 2400S 1000 Mast 24,5m \n",
"4 HLS 1000 Mast 25m \n",
"\n",
" Mast mast2 \n",
"0 Mast 25m 25.0 \n",
"1 Mast 20m 20.0 \n",
"2 Mast 20m 20.0 \n",
"3 Mast 24.5m 24.5 \n",
"4 Mast 25m 25.0 "
]
},
"execution_count": 166,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Übrig bleiben recht viele 'NaN' Zeilen, dort wo vorher 'Gebäude' etc stand\n",
"# Diese Zeilen werden aussortiert\n",
"df_no_missing = df1.dropna()\n",
"df_no_missing.head()"
]
},
{
"cell_type": "code",
"execution_count": 167,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Stadtteil</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" <th>mast2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>Emdener Str.</td>\n",
" <td>Niehl</td>\n",
" <td>50735</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Sürther Str.</td>\n",
" <td>Rodenkirchen</td>\n",
" <td>50996</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>Rondorfer Hauptstr.</td>\n",
" <td>Rondorf</td>\n",
" <td>50997</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 25m</td>\n",
" <td>Mast 25m</td>\n",
" <td>25.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Vingster Ring/Ecke Frankfurter Str.</td>\n",
" <td>Ostheim</td>\n",
" <td>51107</td>\n",
" <td>EPS 2400S</td>\n",
" <td>1000</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>7</td>\n",
" <td>Theodor-Zingsheim-Weg</td>\n",
" <td>Müngersdorf</td>\n",
" <td>50933</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>8</td>\n",
" <td>Nüssenberger Busch</td>\n",
" <td>Mengenich</td>\n",
" <td>50829</td>\n",
" <td>EPS 2400S</td>\n",
" <td>800</td>\n",
" <td>Mast 24,5m</td>\n",
" <td>Mast 24.5m</td>\n",
" <td>24.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>47</td>\n",
" <td>Langemaß 21</td>\n",
" <td>Mülheim</td>\n",
" <td>51063</td>\n",
" <td>2400</td>\n",
" <td>1000</td>\n",
" <td>Mast mit Fundament 23m</td>\n",
" <td>Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>65</th>\n",
" <td>66</td>\n",
" <td>Am Damm 7</td>\n",
" <td>K.-Weiss</td>\n",
" <td>51149</td>\n",
" <td>2400</td>\n",
" <td>1200</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>58</td>\n",
" <td>Oberstr / Andre-Citroen-Str. (Engelshof)</td>\n",
" <td>Westhoven</td>\n",
" <td>51149</td>\n",
" <td>2400</td>\n",
" <td>1100</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>57</td>\n",
" <td>Poller Hauptstr.65/ Poller Damm</td>\n",
" <td>Poll</td>\n",
" <td>51105</td>\n",
" <td>2400</td>\n",
" <td>1000</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>49</td>\n",
" <td>Wuppertaler Str. / Ecke Herler Ring</td>\n",
" <td>Buchheim</td>\n",
" <td>51067</td>\n",
" <td>2400</td>\n",
" <td>1000</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>68</td>\n",
" <td>Schillingsrotter Weg 8-12</td>\n",
" <td>Marienburg</td>\n",
" <td>50968</td>\n",
" <td>2400</td>\n",
" <td>1000</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>neuer Mast mit Fundament 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>21</td>\n",
" <td>Volkhovener Weg 140</td>\n",
" <td>Heimersdorf</td>\n",
" <td>50767</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast 23m</td>\n",
" <td>Mast 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>18</td>\n",
" <td>Ossietzkystr. Longerich-Süd</td>\n",
" <td>Longerich</td>\n",
" <td>50737</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast 23m</td>\n",
" <td>Mast 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>9</td>\n",
" <td>Friedrich-Karl-Str. 261</td>\n",
" <td>Riehl</td>\n",
" <td>50735</td>\n",
" <td>ECN 2400</td>\n",
" <td>1200</td>\n",
" <td>Mast 23m</td>\n",
" <td>Mast 23m</td>\n",
" <td>23.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>35</td>\n",
" <td>Kerkrader Str. (L150) / Im Hellenberg</td>\n",
" <td>Immendorf</td>\n",
" <td>50997</td>\n",
" <td>ECN 2400</td>\n",
" <td>1000</td>\n",
" <td>Mast mit Fundament 22m</td>\n",
" <td>Mast mit Fundament 22m</td>\n",
" <td>22.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>38</td>\n",
" <td>Am Neuen Forst</td>\n",
" <td>Hahnwald</td>\n",
" <td>50996</td>\n",
" <td>ECN 1800</td>\n",
" <td>800</td>\n",
" <td>Mast mit Fundament 22m</td>\n",
" <td>Mast mit Fundament 22m</td>\n",
" <td>22.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>Fühlinger See, Am Strandbad</td>\n",
" <td>Fühlingen</td>\n",
" <td>50769</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>Stresemannstr. 15</td>\n",
" <td>Porz</td>\n",
" <td>51149</td>\n",
" <td>HLS</td>\n",
" <td>1000</td>\n",
" <td>Mast 20m</td>\n",
" <td>Mast 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>42</td>\n",
" <td>Neusser Landstr./Ecke Alte Neusserstr.</td>\n",
" <td>Worringen</td>\n",
" <td>50679</td>\n",
" <td>2400</td>\n",
" <td>1200</td>\n",
" <td>neuer Mast mit Fundament 20m</td>\n",
" <td>neuer Mast mit Fundament 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>44</td>\n",
" <td>Martinusstr. 28</td>\n",
" <td>Esch/Auweiler</td>\n",
" <td>50765</td>\n",
" <td>1800</td>\n",
" <td>900</td>\n",
" <td>neuer Mast mit Fundament 20m</td>\n",
" <td>neuer Mast mit Fundament 20m</td>\n",
" <td>20.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>59</td>\n",
" <td>Gremberghovenerstr/ Schützenhaus</td>\n",
" <td>Ensen</td>\n",
" <td>51149</td>\n",
" <td>1200</td>\n",
" <td>800</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>16.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>65</td>\n",
" <td>Schmittgasse / Ecke Ranzeler Str.</td>\n",
" <td>Zündorf</td>\n",
" <td>51143</td>\n",
" <td>1200</td>\n",
" <td>800</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>16.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>61</td>\n",
" <td>Schulstr. 23</td>\n",
" <td>Eil</td>\n",
" <td>51145</td>\n",
" <td>600</td>\n",
" <td>600</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>neuer Mast ohne Fundament 16m</td>\n",
" <td>16.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>34</td>\n",
" <td>Industriestr. / Auf dem Breiten Feld</td>\n",
" <td>Sürth</td>\n",
" <td>50997</td>\n",
" <td>ECN 600</td>\n",
" <td>700</td>\n",
" <td>Mast mit Fundament 16m</td>\n",
" <td>Mast mit Fundament 16m</td>\n",
" <td>16.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>36</td>\n",
" <td>Unter den Birken, Ecke Im Hasengarten</td>\n",
" <td>Hahnwald</td>\n",
" <td>50996</td>\n",
" <td>ECN 600</td>\n",
" <td>600</td>\n",
" <td>Mast mit Fundament 13,5m</td>\n",
" <td>Mast mit Fundament 13.5m</td>\n",
" <td>13.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>40</td>\n",
" <td>Rheinbergstr. ggü. 92</td>\n",
" <td>Porz-Langel</td>\n",
" <td>51143</td>\n",
" <td>ECN 600</td>\n",
" <td>600</td>\n",
" <td>Mast mit Fundament 13,5m</td>\n",
" <td>Mast mit Fundament 13.5m</td>\n",
" <td>13.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>39</td>\n",
" <td>Rodenkirchener Str. / Weißdornweg</td>\n",
" <td>Hochkirchen</td>\n",
" <td>50997</td>\n",
" <td>ECN 600</td>\n",
" <td>600</td>\n",
" <td>Mast mit Fundament 13,5m</td>\n",
" <td>Mast mit Fundament 13.5m</td>\n",
" <td>13.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>37</td>\n",
" <td>Wattigniestr./Kiesgrubenweg / Ecke Emil-Hofman...</td>\n",
" <td>Hahnwald</td>\n",
" <td>50996</td>\n",
" <td>ECN 600</td>\n",
" <td>600</td>\n",
" <td>Mast mit Fundament 13,5m</td>\n",
" <td>Mast mit Fundament 13.5m</td>\n",
" <td>13.5</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse \\\n",
"0 1 Emdener Str. \n",
"4 5 Sürther Str. \n",
"5 6 Rondorfer Hauptstr. \n",
"3 4 Vingster Ring/Ecke Frankfurter Str. \n",
"6 7 Theodor-Zingsheim-Weg \n",
"7 8 Nüssenberger Busch \n",
"46 47 Langemaß 21 \n",
"65 66 Am Damm 7 \n",
"57 58 Oberstr / Andre-Citroen-Str. (Engelshof) \n",
"56 57 Poller Hauptstr.65/ Poller Damm \n",
"48 49 Wuppertaler Str. / Ecke Herler Ring \n",
"67 68 Schillingsrotter Weg 8-12 \n",
"20 21 Volkhovener Weg 140 \n",
"17 18 Ossietzkystr. Longerich-Süd \n",
"8 9 Friedrich-Karl-Str. 261 \n",
"34 35 Kerkrader Str. (L150) / Im Hellenberg \n",
"37 38 Am Neuen Forst \n",
"1 2 Fühlinger See, Am Strandbad \n",
"2 3 Stresemannstr. 15 \n",
"41 42 Neusser Landstr./Ecke Alte Neusserstr. \n",
"43 44 Martinusstr. 28 \n",
"58 59 Gremberghovenerstr/ Schützenhaus \n",
"64 65 Schmittgasse / Ecke Ranzeler Str. \n",
"60 61 Schulstr. 23 \n",
"33 34 Industriestr. / Auf dem Breiten Feld \n",
"35 36 Unter den Birken, Ecke Im Hasengarten \n",
"39 40 Rheinbergstr. ggü. 92 \n",
"38 39 Rodenkirchener Str. / Weißdornweg \n",
"36 37 Wattigniestr./Kiesgrubenweg / Ecke Emil-Hofman... \n",
"\n",
" Stadtteil Plz Art der Sirene / Leistung in Watt Radius in m \\\n",
"0 Niehl 50735 HLS 1000 \n",
"4 Rodenkirchen 50996 HLS 1000 \n",
"5 Rondorf 50997 HLS 1000 \n",
"3 Ostheim 51107 EPS 2400S 1000 \n",
"6 Müngersdorf 50933 EPS 2400S 800 \n",
"7 Mengenich 50829 EPS 2400S 800 \n",
"46 Mülheim 51063 2400 1000 \n",
"65 K.-Weiss 51149 2400 1200 \n",
"57 Westhoven 51149 2400 1100 \n",
"56 Poll 51105 2400 1000 \n",
"48 Buchheim 51067 2400 1000 \n",
"67 Marienburg 50968 2400 1000 \n",
"20 Heimersdorf 50767 ECN 2400 1000 \n",
"17 Longerich 50737 ECN 2400 1000 \n",
"8 Riehl 50735 ECN 2400 1200 \n",
"34 Immendorf 50997 ECN 2400 1000 \n",
"37 Hahnwald 50996 ECN 1800 800 \n",
"1 Fühlingen 50769 HLS 1000 \n",
"2 Porz 51149 HLS 1000 \n",
"41 Worringen 50679 2400 1200 \n",
"43 Esch/Auweiler 50765 1800 900 \n",
"58 Ensen 51149 1200 800 \n",
"64 Zündorf 51143 1200 800 \n",
"60 Eil 51145 600 600 \n",
"33 Sürth 50997 ECN 600 700 \n",
"35 Hahnwald 50996 ECN 600 600 \n",
"39 Porz-Langel 51143 ECN 600 600 \n",
"38 Hochkirchen 50997 ECN 600 600 \n",
"36 Hahnwald 50996 ECN 600 600 \n",
"\n",
" Aufbau /Befestigung Mast mast2 \n",
"0 Mast 25m Mast 25m 25.0 \n",
"4 Mast 25m Mast 25m 25.0 \n",
"5 Mast 25m Mast 25m 25.0 \n",
"3 Mast 24,5m Mast 24.5m 24.5 \n",
"6 Mast 24,5m Mast 24.5m 24.5 \n",
"7 Mast 24,5m Mast 24.5m 24.5 \n",
"46 Mast mit Fundament 23m Mast mit Fundament 23m 23.0 \n",
"65 neuer Mast mit Fundament 23m neuer Mast mit Fundament 23m 23.0 \n",
"57 neuer Mast mit Fundament 23m neuer Mast mit Fundament 23m 23.0 \n",
"56 neuer Mast mit Fundament 23m neuer Mast mit Fundament 23m 23.0 \n",
"48 neuer Mast mit Fundament 23m neuer Mast mit Fundament 23m 23.0 \n",
"67 neuer Mast mit Fundament 23m neuer Mast mit Fundament 23m 23.0 \n",
"20 Mast 23m Mast 23m 23.0 \n",
"17 Mast 23m Mast 23m 23.0 \n",
"8 Mast 23m Mast 23m 23.0 \n",
"34 Mast mit Fundament 22m Mast mit Fundament 22m 22.0 \n",
"37 Mast mit Fundament 22m Mast mit Fundament 22m 22.0 \n",
"1 Mast 20m Mast 20m 20.0 \n",
"2 Mast 20m Mast 20m 20.0 \n",
"41 neuer Mast mit Fundament 20m neuer Mast mit Fundament 20m 20.0 \n",
"43 neuer Mast mit Fundament 20m neuer Mast mit Fundament 20m 20.0 \n",
"58 neuer Mast ohne Fundament 16m neuer Mast ohne Fundament 16m 16.0 \n",
"64 neuer Mast ohne Fundament 16m neuer Mast ohne Fundament 16m 16.0 \n",
"60 neuer Mast ohne Fundament 16m neuer Mast ohne Fundament 16m 16.0 \n",
"33 Mast mit Fundament 16m Mast mit Fundament 16m 16.0 \n",
"35 Mast mit Fundament 13,5m Mast mit Fundament 13.5m 13.5 \n",
"39 Mast mit Fundament 13,5m Mast mit Fundament 13.5m 13.5 \n",
"38 Mast mit Fundament 13,5m Mast mit Fundament 13.5m 13.5 \n",
"36 Mast mit Fundament 13,5m Mast mit Fundament 13.5m 13.5 "
]
},
"execution_count": 167,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Dann können die Werte der Spalte \"Mast 2\" absteigend sortiert werden \n",
"df_no_missing.sort_values(by='mast2', ascending=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## 1. Ergebnis: ## \n",
"Die höchsten angegebenen Sirenennmasten stehen in Niehl, Rodenkirchen, Rondorf"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## 2. Frage: Wo stehen die meisten Sirenen? ##"
]
},
{
"cell_type": "code",
"execution_count": 169,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" <th>mast2</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Stadtteil</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Altstadt-Nord</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Altstadt-Süd</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Bayenthal</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Bocklemünd</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Buchheim</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse Plz \\\n",
"Stadtteil \n",
"Altstadt-Nord 2 2 2 \n",
"Altstadt-Süd 2 2 2 \n",
"Bayenthal 1 1 1 \n",
"Bocklemünd 1 1 1 \n",
"Buchheim 1 1 1 \n",
"\n",
" Art der Sirene / Leistung in Watt Radius in m \\\n",
"Stadtteil \n",
"Altstadt-Nord 2 2 \n",
"Altstadt-Süd 2 2 \n",
"Bayenthal 1 1 \n",
"Bocklemünd 1 1 \n",
"Buchheim 1 1 \n",
"\n",
" Aufbau /Befestigung Mast mast2 \n",
"Stadtteil \n",
"Altstadt-Nord 2 2 0 \n",
"Altstadt-Süd 2 2 0 \n",
"Bayenthal 1 1 0 \n",
"Bocklemünd 1 1 0 \n",
"Buchheim 1 1 1 "
]
},
"execution_count": 169,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"stadtteil_count = df.groupby('Stadtteil').count()\n",
"stadtteil_count.head()"
]
},
{
"cell_type": "code",
"execution_count": 170,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>lfd. Nummer</th>\n",
" <th>Standort/Adresse</th>\n",
" <th>Plz</th>\n",
" <th>Art der Sirene / Leistung in Watt</th>\n",
" <th>Radius in m</th>\n",
" <th>Aufbau /Befestigung</th>\n",
" <th>Mast</th>\n",
" <th>mast2</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Stadtteil</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Mülheim</th>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Zündorf</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Neustadt-Nord</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Hahnwald</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Longerich</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Stammheim</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sürth</th>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Roggendorf/Thenhoven</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rodenkirchen</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Riehl</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Immendorf</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Porz</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Niehl</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Neustadt-Süd</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Worringen</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Altstadt-Süd</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Porz-Langel</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Altstadt-Nord</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Fühlingen</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Deutz</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Höhenhaus</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Esch/Auweiler</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Raderthal</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rheinkassel</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Eil</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Chorweiler</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Rondorf</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Buchheim</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Bocklemünd</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Weidenpesch</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Weiler</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Westhoven</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Widdersdorf</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Bayenthal</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Zollstock</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ensen</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Poll</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Humboldt/Gremberg</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Ostheim</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Nippes</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Flittard</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Godorf</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Neuehrenfeld</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Müngersdorf</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Gremberghoven</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Heimersdorf</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Mengenich</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Marienburg</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Hochkirchen</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Langel</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Kalk</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>K.-Weiss</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Meschenich</th>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" lfd. Nummer Standort/Adresse Plz \\\n",
"Stadtteil \n",
"Mülheim 4 4 4 \n",
"Zündorf 3 3 3 \n",
"Neustadt-Nord 3 3 3 \n",
"Hahnwald 3 3 3 \n",
"Longerich 3 3 3 \n",
"Stammheim 3 3 3 \n",
"Sürth 3 3 3 \n",
"Roggendorf/Thenhoven 2 2 2 \n",
"Rodenkirchen 2 2 2 \n",
"Riehl 2 2 2 \n",
"Immendorf 2 2 2 \n",
"Porz 2 2 2 \n",
"Niehl 2 2 2 \n",
"Neustadt-Süd 2 2 2 \n",
"Worringen 2 2 2 \n",
"Altstadt-Süd 2 2 2 \n",
"Porz-Langel 2 2 2 \n",
"Altstadt-Nord 2 2 2 \n",
"Fühlingen 2 2 2 \n",
"Deutz 2 2 2 \n",
"Höhenhaus 1 1 1 \n",
"Esch/Auweiler 1 1 1 \n",
"Raderthal 1 1 1 \n",
"Rheinkassel 1 1 1 \n",
"Eil 1 1 1 \n",
"Chorweiler 1 1 1 \n",
"Rondorf 1 1 1 \n",
"Buchheim 1 1 1 \n",
"Bocklemünd 1 1 1 \n",
"Weidenpesch 1 1 1 \n",
"Weiler 1 1 1 \n",
"Westhoven 1 1 1 \n",
"Widdersdorf 1 1 1 \n",
"Bayenthal 1 1 1 \n",
"Zollstock 1 1 1 \n",
"Ensen 1 1 1 \n",
"Poll 1 1 1 \n",
"Humboldt/Gremberg 1 1 1 \n",
"Ostheim 1 1 1 \n",
"Nippes 1 1 1 \n",
"Flittard 1 1 1 \n",
"Godorf 1 1 1 \n",
"Neuehrenfeld 1 1 1 \n",
"Müngersdorf 1 1 1 \n",
"Gremberghoven 1 1 1 \n",
"Heimersdorf 1 1 1 \n",
"Mengenich 1 1 1 \n",
"Marienburg 1 1 1 \n",
"Hochkirchen 1 1 1 \n",
"Langel 1 1 1 \n",
"Kalk 1 1 1 \n",
"K.-Weiss 1 1 1 \n",
"Meschenich 1 1 1 \n",
"\n",
" Art der Sirene / Leistung in Watt Radius in m \\\n",
"Stadtteil \n",
"Mülheim 4 4 \n",
"Zündorf 3 3 \n",
"Neustadt-Nord 3 3 \n",
"Hahnwald 3 3 \n",
"Longerich 3 3 \n",
"Stammheim 3 3 \n",
"Sürth 3 3 \n",
"Roggendorf/Thenhoven 2 2 \n",
"Rodenkirchen 2 2 \n",
"Riehl 2 2 \n",
"Immendorf 2 2 \n",
"Porz 2 2 \n",
"Niehl 2 2 \n",
"Neustadt-Süd 2 2 \n",
"Worringen 2 2 \n",
"Altstadt-Süd 2 2 \n",
"Porz-Langel 2 2 \n",
"Altstadt-Nord 2 2 \n",
"Fühlingen 2 2 \n",
"Deutz 2 2 \n",
"Höhenhaus 1 1 \n",
"Esch/Auweiler 1 1 \n",
"Raderthal 1 1 \n",
"Rheinkassel 1 1 \n",
"Eil 1 1 \n",
"Chorweiler 1 1 \n",
"Rondorf 1 1 \n",
"Buchheim 1 1 \n",
"Bocklemünd 1 1 \n",
"Weidenpesch 1 1 \n",
"Weiler 1 1 \n",
"Westhoven 1 1 \n",
"Widdersdorf 1 1 \n",
"Bayenthal 1 1 \n",
"Zollstock 1 1 \n",
"Ensen 1 1 \n",
"Poll 1 1 \n",
"Humboldt/Gremberg 1 1 \n",
"Ostheim 1 1 \n",
"Nippes 1 1 \n",
"Flittard 1 1 \n",
"Godorf 1 1 \n",
"Neuehrenfeld 1 1 \n",
"Müngersdorf 1 1 \n",
"Gremberghoven 1 1 \n",
"Heimersdorf 1 1 \n",
"Mengenich 1 1 \n",
"Marienburg 1 1 \n",
"Hochkirchen 1 1 \n",
"Langel 1 1 \n",
"Kalk 1 1 \n",
"K.-Weiss 1 1 \n",
"Meschenich 1 1 \n",
"\n",
" Aufbau /Befestigung Mast mast2 \n",
"Stadtteil \n",
"Mülheim 4 4 1 \n",
"Zündorf 3 3 1 \n",
"Neustadt-Nord 3 3 0 \n",
"Hahnwald 3 3 3 \n",
"Longerich 3 3 1 \n",
"Stammheim 3 3 0 \n",
"Sürth 3 3 1 \n",
"Roggendorf/Thenhoven 2 2 0 \n",
"Rodenkirchen 2 2 1 \n",
"Riehl 2 2 1 \n",
"Immendorf 2 2 1 \n",
"Porz 2 2 1 \n",
"Niehl 2 2 1 \n",
"Neustadt-Süd 2 2 0 \n",
"Worringen 2 2 1 \n",
"Altstadt-Süd 2 2 0 \n",
"Porz-Langel 2 2 1 \n",
"Altstadt-Nord 2 2 0 \n",
"Fühlingen 2 2 1 \n",
"Deutz 2 2 0 \n",
"Höhenhaus 1 1 0 \n",
"Esch/Auweiler 1 1 1 \n",
"Raderthal 1 1 0 \n",
"Rheinkassel 1 1 0 \n",
"Eil 1 1 1 \n",
"Chorweiler 1 1 0 \n",
"Rondorf 1 1 1 \n",
"Buchheim 1 1 1 \n",
"Bocklemünd 1 1 0 \n",
"Weidenpesch 1 1 0 \n",
"Weiler 1 1 0 \n",
"Westhoven 1 1 1 \n",
"Widdersdorf 1 1 0 \n",
"Bayenthal 1 1 0 \n",
"Zollstock 1 1 0 \n",
"Ensen 1 1 1 \n",
"Poll 1 1 1 \n",
"Humboldt/Gremberg 1 1 0 \n",
"Ostheim 1 1 1 \n",
"Nippes 1 1 0 \n",
"Flittard 1 1 0 \n",
"Godorf 1 1 0 \n",
"Neuehrenfeld 1 1 0 \n",
"Müngersdorf 1 1 1 \n",
"Gremberghoven 1 1 0 \n",
"Heimersdorf 1 1 1 \n",
"Mengenich 1 1 1 \n",
"Marienburg 1 1 1 \n",
"Hochkirchen 1 1 1 \n",
"Langel 1 1 0 \n",
"Kalk 1 1 0 \n",
"K.-Weiss 1 1 1 \n",
"Meschenich 1 1 0 "
]
},
"execution_count": 170,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"stadtteil_count.sort_values(by='Plz', ascending=False)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## 2. Ergebnis: ##\n",
"In Mühlheim stehen die meisten Sirenen (4). "
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"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.5.1"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment