Skip to content
AKON Data Overview.ipynb 60.2 KiB
Newer Older
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "How many different publisher places are in the data set?"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df['publisher_place'].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Show me some!"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'numpy.ndarray' object has no attribute 'sample'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-16-3d3e9c7ad7b5>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'publisher_place'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0munique\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msample\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m10\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m: 'numpy.ndarray' object has no attribute 'sample'"
     ]
    }
   ],
   "source": [
    "df['publisher_place'].unique().sample(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Oh, that doesn't work. Let's wrap it in a pandas DataFrame, step by step:"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "outputs": [],
   "source": [
    "publisher_places = df['publisher_place'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'Wien', 'Kierling', ..., 'Königstein i. T.', 'Detmold',\n",
       "       'Furth i. W.'], dtype=object)"
      ]
     },
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "publisher_places"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "outputs": [],
   "source": [
    "pp = pd.DataFrame(publisher_places)"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Kirchhain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>München</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Kitzbühel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Innsbruck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Klagenfurt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Grein a/D.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Heidelberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Gr. Siegharts</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Bodenbach a. d. Elbe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Korneuburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Mürzzuschlag</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Frankfurt a. M.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Kilchberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Friedau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1516</th>\n",
       "      <td>Wildalpe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Gießhübl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Schlossberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Frakfurt a. Oder</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Casale Monferrato</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1521</th>\n",
       "      <td>gr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1522</th>\n",
       "      <td>Steinhaus a. Semmering</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1523</th>\n",
       "      <td>Sternberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1524</th>\n",
       "      <td>Stronsdorf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Thörl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>Coburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1527</th>\n",
       "      <td>Traismauer</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Trebnitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1529</th>\n",
       "      <td>Unterlamm</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Daun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Kilchberg-Züich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Mühlhausen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Eschwege</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Tabarz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1535</th>\n",
       "      <td>Suhl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1536</th>\n",
       "      <td>Weimar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Friedrichsroda i. Th.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Leipa i. B.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Schumburg a. D.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Pisa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Straßburg i./E.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1542</th>\n",
       "      <td>Königstein i. T.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1543</th>\n",
       "      <td>Detmold</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Furth i. W.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1545 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           0\n",
       "0                        NaN\n",
       "1                       Wien\n",
       "2                   Kierling\n",
       "3                   Kindberg\n",
       "4                    Kirchau\n",
       "5                  Kirchhain\n",
       "6                    München\n",
       "7                  Kitzbühel\n",
       "8                  Innsbruck\n",
       "9                 Klagenfurt\n",
       "10                Grein a/D.\n",
       "11                     Bozen\n",
       "12                     Znaim\n",
       "13                      Graz\n",
       "14                Heidelberg\n",
       "15                   Komotau\n",
       "16             Gr. Siegharts\n",
       "17                      Köln\n",
       "18      Bodenbach a. d. Elbe\n",
       "19                   Meissen\n",
       "20                   Leipzig\n",
       "21                  Konstanz\n",
       "22                Korneuburg\n",
       "23                    Brașov\n",
       "24              Mürzzuschlag\n",
       "25                  Salzburg\n",
       "26           Frankfurt a. M.\n",
       "27                     Arosa\n",
       "28                 Kilchberg\n",
       "29                      Arys\n",
       "1515                 Friedau\n",
       "1516                Wildalpe\n",
       "1517                Gießhübl\n",
       "1518             Schlossberg\n",
       "1519        Frakfurt a. Oder\n",
       "1520       Casale Monferrato\n",
       "1521                      gr\n",
       "1522  Steinhaus a. Semmering\n",
       "1523               Sternberg\n",
       "1524              Stronsdorf\n",
       "1525                   Thörl\n",
       "1526                  Coburg\n",
       "1527              Traismauer\n",
       "1528                Trebnitz\n",
       "1529               Unterlamm\n",
       "1530                    Daun\n",
       "1531         Kilchberg-Züich\n",
       "1532              Mühlhausen\n",
       "1533                Eschwege\n",
       "1534                  Tabarz\n",
       "1535                    Suhl\n",
       "1536                  Weimar\n",
       "1537   Friedrichsroda i. Th.\n",
       "1538             Leipa i. B.\n",
       "1539         Schumburg a. D.\n",
       "1540                    Pisa\n",
       "1541         Straßburg i./E.\n",
       "1542        Königstein i. T.\n",
       "1543                 Detmold\n",
       "1544             Furth i. W.\n",
       "[1545 rows x 1 columns]"
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pp"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Better. Now show me some randomly:"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1007</th>\n",
       "      <td>Wörschach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1494</th>\n",
       "      <td>Raibl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>Imst</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>Zbiroh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>Bad Sachsa</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               0\n",
       "1007   Wörschach\n",
       "1494       Raibl\n",
       "339         Imst\n",
       "879       Zbiroh\n",
       "457   Bad Sachsa"
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pp.sample(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Sort Things"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Just sort the sample, please:"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>599</th>\n",
       "      <td>Aue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>938</th>\n",
       "      <td>Chocěn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Ernstbrunn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>Hall Tirol</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>788</th>\n",
       "      <td>Hardegg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kindberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Meissen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>Neuchatel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1211</th>\n",
       "      <td>Sommerein</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>Vorkloster bei Bregenz</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           0\n",
       "599                      Aue\n",
       "938                   Chocěn\n",
       "314               Ernstbrunn\n",
       "739               Hall Tirol\n",
       "788                  Hardegg\n",
       "3                   Kindberg\n",
       "19                   Meissen\n",
       "725                Neuchatel\n",
       "1211               Sommerein\n",
       "1302  Vorkloster bei Bregenz"
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pp.sample(10).sort_values(0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Why the '0' in `sort_values(0)`? That's the name of the column to sort by."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Sort the whole thing:"
   ]
  },
  {
   "cell_type": "code",
   "metadata": {},
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>Békéscsaba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Łuck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>#</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>A B.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>A.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Aachen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Abbazia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Abbazia-Lovrana</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Absam b. Innsbruck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Abtenau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Achensee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Adelsberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Admont</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Aeuckens</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Aflenz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934</th>\n",
       "      <td>Afritz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>Aggsbach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Aigen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Albendorf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Alexandria</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1111</th>\n",
       "      <td>Alland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786</th>\n",
       "      <td>Alland II</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>Allensteig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933</th>\n",
       "      <td>Allentsteig</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>Allerheiligen</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>Alsfeld</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>Alt Aussee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>Alt Lengbach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1348</th>\n",
       "      <td>Altaussee</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>Altenberg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1177</th>\n",
       "      <td>Würflach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>Würnitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>Würzburg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ybbs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ypres</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ypser</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Ysper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zakopane</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zantan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zara</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zbiroh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zell a. See</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zell am See</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zistersdorf</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zittau</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1368</th>\n",
       "      <td>Zlabing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Znaim</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zuckmantel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zurigo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>Zurzach</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>Zwettl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zwiesel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Zürich</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1521</th>\n",
       "      <td>gr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>spitz</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>861</th>\n",
       "      <td>w</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>Č. Krumlov</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1304</th>\n",
       "      <td>Łuck</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Šibenik</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1545 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       0\n",
       "1248         Békéscsaba \n",
       "1303                Łuck\n",
       "389                    #\n",
       "1489                A B.\n",
       "1239                  A.\n",
       "1397              Aachen\n",
       "487              Abbazia\n",
       "1280     Abbazia-Lovrana\n",
       "313   Absam b. Innsbruck\n",
       "1181             Abtenau\n",
       "722             Achensee\n",
       "1479           Adelsberg\n",
       "340               Admont\n",
       "354             Aeuckens\n",
       "308               Aflenz\n",
       "934               Afritz\n",
       "982             Aggsbach\n",
       "819                Aigen\n",
       "462            Albendorf\n",
       "57            Alexandria\n",
       "1111              Alland\n",
       "786            Alland II\n",
       "947           Allensteig\n",
       "933          Allentsteig\n",
       "765        Allerheiligen\n",
       "396              Alsfeld\n",
       "730           Alt Aussee\n",
       "736         Alt Lengbach\n",
       "1348           Altaussee\n",
       "955            Altenberg\n",
       "...                  ...\n",
       "1177            Würflach\n",
       "829              Würnitz\n",
       "650             Würzburg\n",
       "674                 Ybbs\n",
       "651                Ypres\n",
       "802                Ypser\n",
       "1487               Ysper\n",
       "1144            Zakopane\n",
       "1249              Zantan\n",
       "652                 Zara\n",
       "879               Zbiroh\n",
       "1028         Zell a. See\n",
       "45           Zell am See\n",
       "1074         Zistersdorf\n",
       "37                Zittau\n",
       "1368             Zlabing\n",
       "12                 Znaim\n",
       "1369          Zuckmantel\n",
       "560               Zurigo\n",
       "654              Zurzach\n",
       "431               Zwettl\n",
       "401              Zwiesel\n",
       "33                Zürich\n",
       "1521                  gr\n",
       "769                spitz\n",
       "861                    w\n",
       "417           Č. Krumlov\n",