Read News XML Sitemap with Python + Pandas.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>loc</th>\n",
       "      <th>news:title</th>\n",
       "      <th>news:publication_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/in-zeiten-des-co...</td>\n",
       "      <td>Das virale Feuilleton-Tagebuch macht keine Ost...</td>\n",
       "      <td>2020-04-11T17:29:16+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.nzz.ch/international/coronavirus-i...</td>\n",
       "      <td>Bundespräsident ruft zu Geduld und Disziplin a...</td>\n",
       "      <td>2020-04-11T17:23:24+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.nzz.ch/zuerich/coronavirus-in-zuer...</td>\n",
       "      <td>Die Schliessung eines Spargelstands im Zürcher...</td>\n",
       "      <td>2020-04-11T16:25:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.nzz.ch/sport/verfahren-gegen-ex-fi...</td>\n",
       "      <td>Verfahren gegen Ex-Fifa-Präsident Sepp Blatter...</td>\n",
       "      <td>2020-04-11T15:25:36+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.nzz.ch/schweiz/coronavirus-in-der-...</td>\n",
       "      <td>Zahl der Neuinfizierten geht weiterhin zurück,...</td>\n",
       "      <td>2020-04-11T15:18:27+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://www.nzz.ch/panorama/die-wichtigsten-gr...</td>\n",
       "      <td>2700 Menschen sind bisher in Deutschland an Co...</td>\n",
       "      <td>2020-04-11T13:12:33+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://www.nzz.ch/international/coronavirus-w...</td>\n",
       "      <td>Die USA verzeichnen mehr als 2000 Todesfälle i...</td>\n",
       "      <td>2020-04-11T13:05:51+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://www.nzz.ch/panorama/radioaktiv-belaste...</td>\n",
       "      <td>Waldbrände bei Tschernobyl weiter nicht unter ...</td>\n",
       "      <td>2020-04-11T12:39:31+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://www.nzz.ch/zuerich/zuerich-philosophis...</td>\n",
       "      <td>Philosophie per Telefon während der Corona-Kri...</td>\n",
       "      <td>2020-04-11T12:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://www.nzz.ch/panorama/die-wichtigsten-gr...</td>\n",
       "      <td>Die Schweiz zählt 1000 Tote, in Genf wächst pr...</td>\n",
       "      <td>2020-04-11T11:31:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://www.nzz.ch/panorama/passant-findet-in-...</td>\n",
       "      <td>Passant findet in Köln Kriegsbombe am Rhein – ...</td>\n",
       "      <td>2020-04-11T11:26:07+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://www.nzz.ch/zuerich/coronavirus-in-zuer...</td>\n",
       "      <td>Die Zürcher Regierung ist in der Krise mächtig...</td>\n",
       "      <td>2020-04-11T10:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://www.nzz.ch/briefing/feiertagsbriefing-...</td>\n",
       "      <td>Feiertagsbriefing</td>\n",
       "      <td>2020-04-11T08:03:19+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://www.nzz.ch/briefing/feiertagsbriefing-...</td>\n",
       "      <td>Feiertagsbriefing</td>\n",
       "      <td>2020-04-11T07:56:12+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://www.nzz.ch/panorama/umweltschuetzer-be...</td>\n",
       "      <td>Umweltschützer befürchten erneut schwere Waldb...</td>\n",
       "      <td>2020-04-11T07:44:32+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://www.nzz.ch/international/pentagon-korr...</td>\n",
       "      <td>Die USA versprechen bis zu zehn Millionen Doll...</td>\n",
       "      <td>2020-04-11T07:13:32+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://www.nzz.ch/wirtschaft/coronavirus-bill...</td>\n",
       "      <td>Bill Gates – der Mann, der die Pandemie kommen...</td>\n",
       "      <td>2020-04-11T07:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://www.nzz.ch/sport/korruption-bei-der-wm...</td>\n",
       "      <td>Korruption bei der WM-Doppelvergabe 2018 und 2...</td>\n",
       "      <td>2020-04-11T06:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://www.nzz.ch/schweiz/coronavirus-gebaut-...</td>\n",
       "      <td>Gebaut wird überall ungefähr gleich. Warum als...</td>\n",
       "      <td>2020-04-11T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://www.nzz.ch/reisen/reisen-im-kopf-zu-be...</td>\n",
       "      <td>Tränen auf Aurora</td>\n",
       "      <td>2020-04-11T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://www.nzz.ch/reisen/lagerkoller-in-den-e...</td>\n",
       "      <td>«Und dann sitzt du fest im Basislager, wartest...</td>\n",
       "      <td>2020-04-11T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://www.nzz.ch/meinung/coronavirus-in-deut...</td>\n",
       "      <td>Die Politik ist nun endgültig durchpädagogisie...</td>\n",
       "      <td>2020-04-11T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://www.nzz.ch/wirtschaft/trump-putin-und-...</td>\n",
       "      <td>Trump, Putin und der saudische Kronprinz bilde...</td>\n",
       "      <td>2020-04-11T05:36:13+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://www.nzz.ch/wirtschaft/coronavirus-schw...</td>\n",
       "      <td>Die Schweizer Banken bleiben krisenresistent</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://www.nzz.ch/sport/das-muessen-sie-frau-...</td>\n",
       "      <td>«Das müssen Sie Frau Wang fragen» – Sky Sun we...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://www.nzz.ch/finanzen/aktienmaerkte-so-e...</td>\n",
       "      <td>So entwickeln sich Aktienmärkte nach wasserfal...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://www.nzz.ch/wissenschaft/coronavirus-fu...</td>\n",
       "      <td>Für die meisten Allergiker bedeutet das neue C...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/bei-t-c-boyle-is...</td>\n",
       "      <td>Die Natur ist am Ende immer die Stärkere –T. C...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/wann-ist-jesus-a...</td>\n",
       "      <td>Ohne Ostern gäbe es vielleicht keinen Computer...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/die-corona-krise...</td>\n",
       "      <td>Die Corona-Krise offenbart auch eine Krise der...</td>\n",
       "      <td>2020-04-11T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>https://www.nzz.ch/panorama/saengerin-rihanna-...</td>\n",
       "      <td>Sängerin Rihanna und Twitter-Chef Dorsey spend...</td>\n",
       "      <td>2020-04-10T07:15:40+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>https://www.nzz.ch/international/uno-sicherhei...</td>\n",
       "      <td>Uno-Sicherheitsrat trifft sich virtuell: Guter...</td>\n",
       "      <td>2020-04-10T06:37:43+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>https://www.nzz.ch/panorama/massensterben-von-...</td>\n",
       "      <td>Massensterben von Zugvögeln in Griechenland du...</td>\n",
       "      <td>2020-04-10T06:00:24+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>https://www.nzz.ch/zuerich/coronavirus-in-zuer...</td>\n",
       "      <td>Ostern in der Isolation: 11 Ideen, damit einem...</td>\n",
       "      <td>2020-04-10T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>https://www.nzz.ch/international/pakistan-in-d...</td>\n",
       "      <td>Ziaullah Khan produziert in Pakistan Waffen fü...</td>\n",
       "      <td>2020-04-10T06:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>https://www.nzz.ch/international/soldaten-toet...</td>\n",
       "      <td>Terroreinsatz im Tschad: Soldaten töten rund 1...</td>\n",
       "      <td>2020-04-10T05:49:27+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>https://www.nzz.ch/fotografie/die-corona-krise...</td>\n",
       "      <td>Die Corona-Krise in Bildern: vier Fotografen, ...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>https://www.nzz.ch/international/coronavirus-u...</td>\n",
       "      <td>Auffällig viele Schwarze unter den Covid-19-Op...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>https://www.nzz.ch/gesellschaft/corona-krise-j...</td>\n",
       "      <td>Er ist der Albtraum jeder Schwiegermutter</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>https://www.nzz.ch/wissenschaft/coronavirus-wa...</td>\n",
       "      <td>Die verseuchte Herzdame: Wie Viren von einem K...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/die-landschaft-v...</td>\n",
       "      <td>Die Landschaft, von der Passstrasse her gesehe...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/trotz-coronaviru...</td>\n",
       "      <td>In Berlin dürfen Bücher noch verkauft werden, ...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/postcorona-studi...</td>\n",
       "      <td>Post-Corona-Studien: Das Virus wäre nichts ohn...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>https://www.nzz.ch/technologie/wie-findet-die-...</td>\n",
       "      <td>Wie findet die Swisscom unsere Standortdaten h...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>https://www.nzz.ch/panorama/coronavirus-norweg...</td>\n",
       "      <td>Wegen der Corona-Krise dürfen die Norweger nic...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>https://www.nzz.ch/international/suedkoreaner-...</td>\n",
       "      <td>Südkoreaner tauschen Daten gegen Bewegungsfrei...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>https://www.nzz.ch/gesellschaft/corona-krise-z...</td>\n",
       "      <td>Einer der reichsten Spanier lässt nun Wegwerfk...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/verschon-uns-got...</td>\n",
       "      <td>«Verschon uns, Gott, mit Strafen»: Vielleicht ...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>https://www.nzz.ch/sport/jakub-blaszczykowski-...</td>\n",
       "      <td>Jakub Blaszczykowski erfreut die Fussball-Roma...</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/corona-und-kunst...</td>\n",
       "      <td>«Den Frühling können sie nicht absagen»</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>https://www.nzz.ch/feuilleton/coronavirus-zuku...</td>\n",
       "      <td>Das Leben im ewigen Idyll ist zu Ende</td>\n",
       "      <td>2020-04-10T05:30:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>https://www.nzz.ch/panorama/us-aktivistin-fuer...</td>\n",
       "      <td>US-Aktivistin für Frauenrechte und Homo-Ehe mi...</td>\n",
       "      <td>2020-04-10T05:01:53+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>https://www.nzz.ch/wissenschaft/coronavirus-di...</td>\n",
       "      <td>Diese neuartigen Impfstoffe sollen das Coronav...</td>\n",
       "      <td>2020-04-10T05:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>https://www.nzz.ch/zuerich/coronavirus-in-zuer...</td>\n",
       "      <td>Den Startups trocknet in der Corona-Krise die ...</td>\n",
       "      <td>2020-04-10T05:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>https://www.nzz.ch/panorama/nach-kanu-unfall-d...</td>\n",
       "      <td>Nach Kanu-Unfall der Kennedy-Enkelin: Taucher ...</td>\n",
       "      <td>2020-04-10T03:54:05+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>https://www.nzz.ch/wirtschaft/eu-finanzministe...</td>\n",
       "      <td>Die EU-Finanzminister einigen sich auf ein 540...</td>\n",
       "      <td>2020-04-10T01:57:21+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>https://www.nzz.ch/fotografie/bilder-des-tages...</td>\n",
       "      <td>Bilder des Tages</td>\n",
       "      <td>2020-04-10T00:11:23+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>https://www.nzz.ch/wirtschaft/noch-einmal-66-m...</td>\n",
       "      <td>Weitere 6,6 Millionen Arbeitslose in den USA -...</td>\n",
       "      <td>2020-04-09T23:43:41+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>https://www.nzz.ch/video/nzz-format/natur-pur-...</td>\n",
       "      <td>Natur pur: Uruguays Rinder ohne Antibiotika un...</td>\n",
       "      <td>2020-04-09T23:00:00+02:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>https://www.nzz.ch/meinung/zentralbanken-finan...</td>\n",
       "      <td>Zentralbanken finanzieren Staatsausgaben: Das ...</td>\n",
       "      <td>2020-04-09T20:24:24+02:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>112 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   loc  \\\n",
       "0    https://www.nzz.ch/feuilleton/in-zeiten-des-co...   \n",
       "1    https://www.nzz.ch/international/coronavirus-i...   \n",
       "2    https://www.nzz.ch/zuerich/coronavirus-in-zuer...   \n",
       "3    https://www.nzz.ch/sport/verfahren-gegen-ex-fi...   \n",
       "4    https://www.nzz.ch/schweiz/coronavirus-in-der-...   \n",
       "5    https://www.nzz.ch/panorama/die-wichtigsten-gr...   \n",
       "6    https://www.nzz.ch/international/coronavirus-w...   \n",
       "7    https://www.nzz.ch/panorama/radioaktiv-belaste...   \n",
       "8    https://www.nzz.ch/zuerich/zuerich-philosophis...   \n",
       "9    https://www.nzz.ch/panorama/die-wichtigsten-gr...   \n",
       "10   https://www.nzz.ch/panorama/passant-findet-in-...   \n",
       "11   https://www.nzz.ch/zuerich/coronavirus-in-zuer...   \n",
       "12   https://www.nzz.ch/briefing/feiertagsbriefing-...   \n",
       "13   https://www.nzz.ch/briefing/feiertagsbriefing-...   \n",
       "14   https://www.nzz.ch/panorama/umweltschuetzer-be...   \n",
       "15   https://www.nzz.ch/international/pentagon-korr...   \n",
       "16   https://www.nzz.ch/wirtschaft/coronavirus-bill...   \n",
       "17   https://www.nzz.ch/sport/korruption-bei-der-wm...   \n",
       "18   https://www.nzz.ch/schweiz/coronavirus-gebaut-...   \n",
       "19   https://www.nzz.ch/reisen/reisen-im-kopf-zu-be...   \n",
       "20   https://www.nzz.ch/reisen/lagerkoller-in-den-e...   \n",
       "21   https://www.nzz.ch/meinung/coronavirus-in-deut...   \n",
       "22   https://www.nzz.ch/wirtschaft/trump-putin-und-...   \n",
       "23   https://www.nzz.ch/wirtschaft/coronavirus-schw...   \n",
       "24   https://www.nzz.ch/sport/das-muessen-sie-frau-...   \n",
       "25   https://www.nzz.ch/finanzen/aktienmaerkte-so-e...   \n",
       "26   https://www.nzz.ch/wissenschaft/coronavirus-fu...   \n",
       "27   https://www.nzz.ch/feuilleton/bei-t-c-boyle-is...   \n",
       "28   https://www.nzz.ch/feuilleton/wann-ist-jesus-a...   \n",
       "29   https://www.nzz.ch/feuilleton/die-corona-krise...   \n",
       "..                                                 ...   \n",
       "82   https://www.nzz.ch/panorama/saengerin-rihanna-...   \n",
       "83   https://www.nzz.ch/international/uno-sicherhei...   \n",
       "84   https://www.nzz.ch/panorama/massensterben-von-...   \n",
       "85   https://www.nzz.ch/zuerich/coronavirus-in-zuer...   \n",
       "86   https://www.nzz.ch/international/pakistan-in-d...   \n",
       "87   https://www.nzz.ch/international/soldaten-toet...   \n",
       "88   https://www.nzz.ch/fotografie/die-corona-krise...   \n",
       "89   https://www.nzz.ch/international/coronavirus-u...   \n",
       "90   https://www.nzz.ch/gesellschaft/corona-krise-j...   \n",
       "91   https://www.nzz.ch/wissenschaft/coronavirus-wa...   \n",
       "92   https://www.nzz.ch/feuilleton/die-landschaft-v...   \n",
       "93   https://www.nzz.ch/feuilleton/trotz-coronaviru...   \n",
       "94   https://www.nzz.ch/feuilleton/postcorona-studi...   \n",
       "95   https://www.nzz.ch/technologie/wie-findet-die-...   \n",
       "96   https://www.nzz.ch/panorama/coronavirus-norweg...   \n",
       "97   https://www.nzz.ch/international/suedkoreaner-...   \n",
       "98   https://www.nzz.ch/gesellschaft/corona-krise-z...   \n",
       "99   https://www.nzz.ch/feuilleton/verschon-uns-got...   \n",
       "100  https://www.nzz.ch/sport/jakub-blaszczykowski-...   \n",
       "101  https://www.nzz.ch/feuilleton/corona-und-kunst...   \n",
       "102  https://www.nzz.ch/feuilleton/coronavirus-zuku...   \n",
       "103  https://www.nzz.ch/panorama/us-aktivistin-fuer...   \n",
       "104  https://www.nzz.ch/wissenschaft/coronavirus-di...   \n",
       "105  https://www.nzz.ch/zuerich/coronavirus-in-zuer...   \n",
       "106  https://www.nzz.ch/panorama/nach-kanu-unfall-d...   \n",
       "107  https://www.nzz.ch/wirtschaft/eu-finanzministe...   \n",
       "108  https://www.nzz.ch/fotografie/bilder-des-tages...   \n",
       "109  https://www.nzz.ch/wirtschaft/noch-einmal-66-m...   \n",
       "110  https://www.nzz.ch/video/nzz-format/natur-pur-...   \n",
       "111  https://www.nzz.ch/meinung/zentralbanken-finan...   \n",
       "\n",
       "                                            news:title  \\\n",
       "0    Das virale Feuilleton-Tagebuch macht keine Ost...   \n",
       "1    Bundespräsident ruft zu Geduld und Disziplin a...   \n",
       "2    Die Schliessung eines Spargelstands im Zürcher...   \n",
       "3    Verfahren gegen Ex-Fifa-Präsident Sepp Blatter...   \n",
       "4    Zahl der Neuinfizierten geht weiterhin zurück,...   \n",
       "5    2700 Menschen sind bisher in Deutschland an Co...   \n",
       "6    Die USA verzeichnen mehr als 2000 Todesfälle i...   \n",
       "7    Waldbrände bei Tschernobyl weiter nicht unter ...   \n",
       "8    Philosophie per Telefon während der Corona-Kri...   \n",
       "9    Die Schweiz zählt 1000 Tote, in Genf wächst pr...   \n",
       "10   Passant findet in Köln Kriegsbombe am Rhein – ...   \n",
       "11   Die Zürcher Regierung ist in der Krise mächtig...   \n",
       "12                                   Feiertagsbriefing   \n",
       "13                                   Feiertagsbriefing   \n",
       "14   Umweltschützer befürchten erneut schwere Waldb...   \n",
       "15   Die USA versprechen bis zu zehn Millionen Doll...   \n",
       "16   Bill Gates – der Mann, der die Pandemie kommen...   \n",
       "17   Korruption bei der WM-Doppelvergabe 2018 und 2...   \n",
       "18   Gebaut wird überall ungefähr gleich. Warum als...   \n",
       "19                                   Tränen auf Aurora   \n",
       "20   «Und dann sitzt du fest im Basislager, wartest...   \n",
       "21   Die Politik ist nun endgültig durchpädagogisie...   \n",
       "22   Trump, Putin und der saudische Kronprinz bilde...   \n",
       "23        Die Schweizer Banken bleiben krisenresistent   \n",
       "24   «Das müssen Sie Frau Wang fragen» – Sky Sun we...   \n",
       "25   So entwickeln sich Aktienmärkte nach wasserfal...   \n",
       "26   Für die meisten Allergiker bedeutet das neue C...   \n",
       "27   Die Natur ist am Ende immer die Stärkere –T. C...   \n",
       "28   Ohne Ostern gäbe es vielleicht keinen Computer...   \n",
       "29   Die Corona-Krise offenbart auch eine Krise der...   \n",
       "..                                                 ...   \n",
       "82   Sängerin Rihanna und Twitter-Chef Dorsey spend...   \n",
       "83   Uno-Sicherheitsrat trifft sich virtuell: Guter...   \n",
       "84   Massensterben von Zugvögeln in Griechenland du...   \n",
       "85   Ostern in der Isolation: 11 Ideen, damit einem...   \n",
       "86   Ziaullah Khan produziert in Pakistan Waffen fü...   \n",
       "87   Terroreinsatz im Tschad: Soldaten töten rund 1...   \n",
       "88   Die Corona-Krise in Bildern: vier Fotografen, ...   \n",
       "89   Auffällig viele Schwarze unter den Covid-19-Op...   \n",
       "90           Er ist der Albtraum jeder Schwiegermutter   \n",
       "91   Die verseuchte Herzdame: Wie Viren von einem K...   \n",
       "92   Die Landschaft, von der Passstrasse her gesehe...   \n",
       "93   In Berlin dürfen Bücher noch verkauft werden, ...   \n",
       "94   Post-Corona-Studien: Das Virus wäre nichts ohn...   \n",
       "95   Wie findet die Swisscom unsere Standortdaten h...   \n",
       "96   Wegen der Corona-Krise dürfen die Norweger nic...   \n",
       "97   Südkoreaner tauschen Daten gegen Bewegungsfrei...   \n",
       "98   Einer der reichsten Spanier lässt nun Wegwerfk...   \n",
       "99   «Verschon uns, Gott, mit Strafen»: Vielleicht ...   \n",
       "100  Jakub Blaszczykowski erfreut die Fussball-Roma...   \n",
       "101            «Den Frühling können sie nicht absagen»   \n",
       "102              Das Leben im ewigen Idyll ist zu Ende   \n",
       "103  US-Aktivistin für Frauenrechte und Homo-Ehe mi...   \n",
       "104  Diese neuartigen Impfstoffe sollen das Coronav...   \n",
       "105  Den Startups trocknet in der Corona-Krise die ...   \n",
       "106  Nach Kanu-Unfall der Kennedy-Enkelin: Taucher ...   \n",
       "107  Die EU-Finanzminister einigen sich auf ein 540...   \n",
       "108                                   Bilder des Tages   \n",
       "109  Weitere 6,6 Millionen Arbeitslose in den USA -...   \n",
       "110  Natur pur: Uruguays Rinder ohne Antibiotika un...   \n",
       "111  Zentralbanken finanzieren Staatsausgaben: Das ...   \n",
       "\n",
       "         news:publication_date  \n",
       "0    2020-04-11T17:29:16+02:00  \n",
       "1    2020-04-11T17:23:24+02:00  \n",
       "2    2020-04-11T16:25:00+02:00  \n",
       "3    2020-04-11T15:25:36+02:00  \n",
       "4    2020-04-11T15:18:27+02:00  \n",
       "5    2020-04-11T13:12:33+02:00  \n",
       "6    2020-04-11T13:05:51+02:00  \n",
       "7    2020-04-11T12:39:31+02:00  \n",
       "8    2020-04-11T12:00:00+02:00  \n",
       "9    2020-04-11T11:31:00+02:00  \n",
       "10   2020-04-11T11:26:07+02:00  \n",
       "11   2020-04-11T10:30:00+02:00  \n",
       "12   2020-04-11T08:03:19+02:00  \n",
       "13   2020-04-11T07:56:12+02:00  \n",
       "14   2020-04-11T07:44:32+02:00  \n",
       "15   2020-04-11T07:13:32+02:00  \n",
       "16   2020-04-11T07:00:00+02:00  \n",
       "17   2020-04-11T06:30:00+02:00  \n",
       "18   2020-04-11T06:00:00+02:00  \n",
       "19   2020-04-11T06:00:00+02:00  \n",
       "20   2020-04-11T06:00:00+02:00  \n",
       "21   2020-04-11T06:00:00+02:00  \n",
       "22   2020-04-11T05:36:13+02:00  \n",
       "23   2020-04-11T05:30:00+02:00  \n",
       "24   2020-04-11T05:30:00+02:00  \n",
       "25   2020-04-11T05:30:00+02:00  \n",
       "26   2020-04-11T05:30:00+02:00  \n",
       "27   2020-04-11T05:30:00+02:00  \n",
       "28   2020-04-11T05:30:00+02:00  \n",
       "29   2020-04-11T05:30:00+02:00  \n",
       "..                         ...  \n",
       "82   2020-04-10T07:15:40+02:00  \n",
       "83   2020-04-10T06:37:43+02:00  \n",
       "84   2020-04-10T06:00:24+02:00  \n",
       "85   2020-04-10T06:00:00+02:00  \n",
       "86   2020-04-10T06:00:00+02:00  \n",
       "87   2020-04-10T05:49:27+02:00  \n",
       "88   2020-04-10T05:30:00+02:00  \n",
       "89   2020-04-10T05:30:00+02:00  \n",
       "90   2020-04-10T05:30:00+02:00  \n",
       "91   2020-04-10T05:30:00+02:00  \n",
       "92   2020-04-10T05:30:00+02:00  \n",
       "93   2020-04-10T05:30:00+02:00  \n",
       "94   2020-04-10T05:30:00+02:00  \n",
       "95   2020-04-10T05:30:00+02:00  \n",
       "96   2020-04-10T05:30:00+02:00  \n",
       "97   2020-04-10T05:30:00+02:00  \n",
       "98   2020-04-10T05:30:00+02:00  \n",
       "99   2020-04-10T05:30:00+02:00  \n",
       "100  2020-04-10T05:30:00+02:00  \n",
       "101  2020-04-10T05:30:00+02:00  \n",
       "102  2020-04-10T05:30:00+02:00  \n",
       "103  2020-04-10T05:01:53+02:00  \n",
       "104  2020-04-10T05:00:00+02:00  \n",
       "105  2020-04-10T05:00:00+02:00  \n",
       "106  2020-04-10T03:54:05+02:00  \n",
       "107  2020-04-10T01:57:21+02:00  \n",
       "108  2020-04-10T00:11:23+02:00  \n",
       "109  2020-04-09T23:43:41+02:00  \n",
       "110  2020-04-09T23:00:00+02:00  \n",
       "111  2020-04-09T20:24:24+02:00  \n",
       "\n",
       "[112 rows x 3 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import xmltodict\n",
    "\n",
    "url = \"https://www.nzz.ch/sitemap/news0.xml\t\"\n",
    "res = requests.get(url)\n",
    "raw = xmltodict.parse(res.text)\n",
    "\n",
    "data = [[r[\"loc\"], r[\"news:news\"][\"news:title\"], r[\"news:news\"][\"news:publication_date\"]] for r in raw[\"urlset\"][\"url\"]]\n",
    "df = pd.DataFrame(data, columns=[\"loc\",\"news:title\", \"news:publication_date\"])\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}