Cleanup-2-Analytics-API-and-Custom-Search-Crawl.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "len(rows): 100000\n",
      "len(rows): 200000\n",
      "len(rows): 223174\n"
     ]
    }
   ],
   "source": [
    "from apiclient.discovery import build\n",
    "from oauth2client.service_account import ServiceAccountCredentials\n",
    "\n",
    "SCOPES = ['https://www.googleapis.com/auth/analytics.readonly']\n",
    "KEY_FILE_LOCATION = './testapp-60fcd-f547300981c5.json'\n",
    "VIEW_ID = '170130817'\n",
    "\n",
    "def initialize_analyticsreporting():\n",
    "  credentials = ServiceAccountCredentials.from_json_keyfile_name(\n",
    "      KEY_FILE_LOCATION, SCOPES)\n",
    "  analytics = build('analyticsreporting', 'v4', credentials=credentials)\n",
    "  return analytics\n",
    "\n",
    "def get_report(analytics, pageTokenVar):\n",
    "  return analytics.reports().batchGet(\n",
    "      body={\n",
    "        'reportRequests': [\n",
    "        {\n",
    "          'viewId': VIEW_ID,\n",
    "          'dateRanges': [{'startDate': '700daysAgo', 'endDate': 'yesterday'}],\n",
    "          'metrics': [{'expression': 'ga:pageviews'},{'expression': 'ga:entrances'}],\n",
    "          'dimensions': [{'name': 'ga:pagePath'}],\n",
    "          'dimensionFilterClauses': [{\n",
    "                    'operator': \"AND\",\n",
    "                    'filters': [\n",
    "                          {\n",
    "                          'dimensionName': 'ga:pagePath',\n",
    "                          'operator': 'REGEXP',\n",
    "                          'expressions': [\n",
    "                            '.*id[0-9]{7}.htm'\n",
    "                          ]},\n",
    "                          {\n",
    "                          'dimensionName': 'ga:pagePath',\n",
    "                          'operator': 'REGEXP',\n",
    "                          'expressions': [\n",
    "                            '^[^?&]*$'\n",
    "                          ]}\n",
    "                    ]    \n",
    "          }],\n",
    "          'metricFilterClauses': [{ \n",
    "              \"filters\": [\n",
    "                        {\n",
    "                          'metricName': 'ga:pageviews',\n",
    "                          'not': 'false',\n",
    "                          'operator': 'LESS_THAN',\n",
    "                          'comparisonValue': '6'\n",
    "                        }\n",
    "                    ]   \n",
    "          }],\n",
    "          'pageSize': 100000,\n",
    "          'pageToken': pageTokenVar,\n",
    "          'samplingLevel': 'LARGE'\n",
    "          \n",
    "        }],\n",
    "        'useResourceQuotas': 'true'\n",
    "      }\n",
    "  ).execute()\n",
    "    \n",
    "def handle_report(analytics,pagetoken,rows):  \n",
    "\n",
    "    response = get_report(analytics, pagetoken)\n",
    "\n",
    "    #Header, Dimentions Headers, Metric Headers \n",
    "    columnHeader = response.get(\"reports\")[0].get('columnHeader', {})\n",
    "    dimensionHeaders = columnHeader.get('dimensions', [])\n",
    "    metricHeaders = columnHeader.get('metricHeader', {}).get('metricHeaderEntries', [])\n",
    "\n",
    "    #Pagination\n",
    "    pagetoken = response.get(\"reports\")[0].get('nextPageToken', None)\n",
    "    \n",
    "    #Rows\n",
    "    rowsNew = response.get(\"reports\")[0].get('data', {}).get('rows', [])\n",
    "    rows = rows + rowsNew\n",
    "    print(\"len(rows): \" + str(len(rows)))\n",
    "\n",
    "    #Recursivly query next page\n",
    "    if pagetoken != None:\n",
    "        return handle_report(analytics,pagetoken,rows)\n",
    "    else:\n",
    "        return rows\n",
    "\n",
    "def main():    \n",
    "    analytics = initialize_analyticsreporting()\n",
    "    \n",
    "    global dfanalytics\n",
    "    dfanalytics = []\n",
    "\n",
    "    rows = []\n",
    "    rows = handle_report(analytics,'0',rows)\n",
    "\n",
    "    dfanalytics = pd.DataFrame(list(rows))\n",
    "\n",
    "if __name__ == '__main__':\n",
    "  main()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [],
   "source": [
    "tags = dfanalytics['dimensions'].apply(pd.Series)\n",
    "tags = tags.rename(columns = lambda x : 'pagePath')\n",
    "dfanalytics = pd.concat([dfanalytics[:], tags[:]], axis=1)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Drop columns about performance. Don't care if there were 3 or 4 pageviews \n",
    "dfanalytics = dfanalytics.drop(\"dimensions\",1)\n",
    "dfanalytics = dfanalytics.drop(\"metrics\",1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Generate a short URL for the crawl with just the ID\n",
    "dfanalytics['ID_GA'] = dfanalytics['pagePath'].str.extract('(?:.*id)([0-9]+)(?:.html)', expand=False)\n",
    "dfanalytics['ShortURL'] = \"https://www.blick.ch/\"+dfanalytics['ID_GA']+'/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "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>ID_GA</th>\n",
       "      <th>ShortURL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5378225</td>\n",
       "      <td>https://www.blick.ch/5378225/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7091834</td>\n",
       "      <td>https://www.blick.ch/7091834/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7252099</td>\n",
       "      <td>https://www.blick.ch/7252099/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7277672</td>\n",
       "      <td>https://www.blick.ch/7277672/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7393854</td>\n",
       "      <td>https://www.blick.ch/7393854/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7987322</td>\n",
       "      <td>https://www.blick.ch/7987322/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>8943756</td>\n",
       "      <td>https://www.blick.ch/8943756/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8943976</td>\n",
       "      <td>https://www.blick.ch/8943976/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2153815</td>\n",
       "      <td>https://www.blick.ch/2153815/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8441776</td>\n",
       "      <td>https://www.blick.ch/8441776/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>9005034</td>\n",
       "      <td>https://www.blick.ch/9005034/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8946692</td>\n",
       "      <td>https://www.blick.ch/8946692/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7068779</td>\n",
       "      <td>https://www.blick.ch/7068779/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8958308</td>\n",
       "      <td>https://www.blick.ch/8958308/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8945118</td>\n",
       "      <td>https://www.blick.ch/8945118/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>9061778</td>\n",
       "      <td>https://www.blick.ch/9061778/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7074460</td>\n",
       "      <td>https://www.blick.ch/7074460/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1772349</td>\n",
       "      <td>https://www.blick.ch/1772349/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8885549</td>\n",
       "      <td>https://www.blick.ch/8885549/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>7651914</td>\n",
       "      <td>https://www.blick.ch/7651914/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6430402</td>\n",
       "      <td>https://www.blick.ch/6430402/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>9002212</td>\n",
       "      <td>https://www.blick.ch/9002212/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8962614</td>\n",
       "      <td>https://www.blick.ch/8962614/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5489638</td>\n",
       "      <td>https://www.blick.ch/5489638/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8908548</td>\n",
       "      <td>https://www.blick.ch/8908548/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>9013074</td>\n",
       "      <td>https://www.blick.ch/9013074/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7027513</td>\n",
       "      <td>https://www.blick.ch/7027513/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>7538597</td>\n",
       "      <td>https://www.blick.ch/7538597/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>8134329</td>\n",
       "      <td>https://www.blick.ch/8134329/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5527389</td>\n",
       "      <td>https://www.blick.ch/5527389/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223130</th>\n",
       "      <td>8455505</td>\n",
       "      <td>https://www.blick.ch/8455505/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223131</th>\n",
       "      <td>9015022</td>\n",
       "      <td>https://www.blick.ch/9015022/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223132</th>\n",
       "      <td>6792263</td>\n",
       "      <td>https://www.blick.ch/6792263/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223133</th>\n",
       "      <td>8578972</td>\n",
       "      <td>https://www.blick.ch/8578972/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223134</th>\n",
       "      <td>5794406</td>\n",
       "      <td>https://www.blick.ch/5794406/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223135</th>\n",
       "      <td>9034616</td>\n",
       "      <td>https://www.blick.ch/9034616/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223137</th>\n",
       "      <td>8211556</td>\n",
       "      <td>https://www.blick.ch/8211556/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223140</th>\n",
       "      <td>8533838</td>\n",
       "      <td>https://www.blick.ch/8533838/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223141</th>\n",
       "      <td>8912369</td>\n",
       "      <td>https://www.blick.ch/8912369/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223142</th>\n",
       "      <td>7107576</td>\n",
       "      <td>https://www.blick.ch/7107576/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223144</th>\n",
       "      <td>8854431</td>\n",
       "      <td>https://www.blick.ch/8854431/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223145</th>\n",
       "      <td>8948051</td>\n",
       "      <td>https://www.blick.ch/8948051/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223146</th>\n",
       "      <td>8921450</td>\n",
       "      <td>https://www.blick.ch/8921450/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223147</th>\n",
       "      <td>8891656</td>\n",
       "      <td>https://www.blick.ch/8891656/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223150</th>\n",
       "      <td>4337749</td>\n",
       "      <td>https://www.blick.ch/4337749/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223151</th>\n",
       "      <td>9069060</td>\n",
       "      <td>https://www.blick.ch/9069060/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223154</th>\n",
       "      <td>8947262</td>\n",
       "      <td>https://www.blick.ch/8947262/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223155</th>\n",
       "      <td>8621731</td>\n",
       "      <td>https://www.blick.ch/8621731/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223156</th>\n",
       "      <td>8407448</td>\n",
       "      <td>https://www.blick.ch/8407448/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223157</th>\n",
       "      <td>8982370</td>\n",
       "      <td>https://www.blick.ch/8982370/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223158</th>\n",
       "      <td>8969518</td>\n",
       "      <td>https://www.blick.ch/8969518/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223160</th>\n",
       "      <td>8998611</td>\n",
       "      <td>https://www.blick.ch/8998611/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223161</th>\n",
       "      <td>8157378</td>\n",
       "      <td>https://www.blick.ch/8157378/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223162</th>\n",
       "      <td>8901094</td>\n",
       "      <td>https://www.blick.ch/8901094/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223164</th>\n",
       "      <td>9061916</td>\n",
       "      <td>https://www.blick.ch/9061916/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223165</th>\n",
       "      <td>8955119</td>\n",
       "      <td>https://www.blick.ch/8955119/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223166</th>\n",
       "      <td>9065932</td>\n",
       "      <td>https://www.blick.ch/9065932/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223167</th>\n",
       "      <td>8870859</td>\n",
       "      <td>https://www.blick.ch/8870859/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223168</th>\n",
       "      <td>9030778</td>\n",
       "      <td>https://www.blick.ch/9030778/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223169</th>\n",
       "      <td>8865362</td>\n",
       "      <td>https://www.blick.ch/8865362/</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>194686 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                       ShortURL\n",
       "0       5378225  https://www.blick.ch/5378225/\n",
       "1       7091834  https://www.blick.ch/7091834/\n",
       "2       7252099  https://www.blick.ch/7252099/\n",
       "3       7277672  https://www.blick.ch/7277672/\n",
       "4       7393854  https://www.blick.ch/7393854/\n",
       "5       7987322  https://www.blick.ch/7987322/\n",
       "6       8943756  https://www.blick.ch/8943756/\n",
       "7       8943976  https://www.blick.ch/8943976/\n",
       "8       2153815  https://www.blick.ch/2153815/\n",
       "9       8441776  https://www.blick.ch/8441776/\n",
       "10      9005034  https://www.blick.ch/9005034/\n",
       "11      8946692  https://www.blick.ch/8946692/\n",
       "12      7068779  https://www.blick.ch/7068779/\n",
       "13      8958308  https://www.blick.ch/8958308/\n",
       "14      8945118  https://www.blick.ch/8945118/\n",
       "15      9061778  https://www.blick.ch/9061778/\n",
       "16      7074460  https://www.blick.ch/7074460/\n",
       "17      1772349  https://www.blick.ch/1772349/\n",
       "18      8885549  https://www.blick.ch/8885549/\n",
       "19      7651914  https://www.blick.ch/7651914/\n",
       "20      6430402  https://www.blick.ch/6430402/\n",
       "21      9002212  https://www.blick.ch/9002212/\n",
       "22      8962614  https://www.blick.ch/8962614/\n",
       "23      5489638  https://www.blick.ch/5489638/\n",
       "24      8908548  https://www.blick.ch/8908548/\n",
       "25      9013074  https://www.blick.ch/9013074/\n",
       "26      7027513  https://www.blick.ch/7027513/\n",
       "27      7538597  https://www.blick.ch/7538597/\n",
       "28      8134329  https://www.blick.ch/8134329/\n",
       "29      5527389  https://www.blick.ch/5527389/\n",
       "...         ...                            ...\n",
       "223130  8455505  https://www.blick.ch/8455505/\n",
       "223131  9015022  https://www.blick.ch/9015022/\n",
       "223132  6792263  https://www.blick.ch/6792263/\n",
       "223133  8578972  https://www.blick.ch/8578972/\n",
       "223134  5794406  https://www.blick.ch/5794406/\n",
       "223135  9034616  https://www.blick.ch/9034616/\n",
       "223137  8211556  https://www.blick.ch/8211556/\n",
       "223140  8533838  https://www.blick.ch/8533838/\n",
       "223141  8912369  https://www.blick.ch/8912369/\n",
       "223142  7107576  https://www.blick.ch/7107576/\n",
       "223144  8854431  https://www.blick.ch/8854431/\n",
       "223145  8948051  https://www.blick.ch/8948051/\n",
       "223146  8921450  https://www.blick.ch/8921450/\n",
       "223147  8891656  https://www.blick.ch/8891656/\n",
       "223150  4337749  https://www.blick.ch/4337749/\n",
       "223151  9069060  https://www.blick.ch/9069060/\n",
       "223154  8947262  https://www.blick.ch/8947262/\n",
       "223155  8621731  https://www.blick.ch/8621731/\n",
       "223156  8407448  https://www.blick.ch/8407448/\n",
       "223157  8982370  https://www.blick.ch/8982370/\n",
       "223158  8969518  https://www.blick.ch/8969518/\n",
       "223160  8998611  https://www.blick.ch/8998611/\n",
       "223161  8157378  https://www.blick.ch/8157378/\n",
       "223162  8901094  https://www.blick.ch/8901094/\n",
       "223164  9061916  https://www.blick.ch/9061916/\n",
       "223165  8955119  https://www.blick.ch/8955119/\n",
       "223166  9065932  https://www.blick.ch/9065932/\n",
       "223167  8870859  https://www.blick.ch/8870859/\n",
       "223168  9030778  https://www.blick.ch/9030778/\n",
       "223169  8865362  https://www.blick.ch/8865362/\n",
       "\n",
       "[194686 rows x 2 columns]"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Drop duplicates, after droping pagePath \n",
    "dfanalytics = dfanalytics.drop(\"pagePath\",1)\n",
    "dfanalytics = dfanalytics.drop_duplicates()\n",
    "dfanalytics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Export crawl\n",
    "#dfanalyticsExport = dfanalytics.drop(\"ID_GA\",1)\n",
    "dfanalyticsExport.to_csv('dfanalyticsExport.txt', header=None, index=None, sep=' ', mode='a')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "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>Address</th>\n",
       "      <th>Content</th>\n",
       "      <th>Status Code</th>\n",
       "      <th>Status</th>\n",
       "      <th>Contains: '\"article-text-box\"'</th>\n",
       "      <th>Contains: '\"video-player\"'</th>\n",
       "      <th>Contains: '&lt;picture'</th>\n",
       "      <th>Contains: '\"article-body'</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/parteien-sp-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://www.blick.ch/people-tv/musik/menschenr...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://www.blick.ch/people-tv/international/a...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/schneebrett-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://www.blick.ch/people-tv/schweiz/mode-bl...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/ein-w...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://www.blick.ch/news/ausland/ex-polizist-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/bern/sie-kli...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://www.blick.ch/news/ausland/kurios/hirnv...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/belgier-b...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/rauchverbote...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://www.blick.ch/news/schweiz-italien-neue...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/syrien-syrer...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/waffen-pu...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://www.blick.ch/people-tv/schweiz/energy-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://www.blick.ch/sport/auftakt-in-lausanne...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://www.blick.ch/news/ausland/protest-gege...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://www.blick.ch/news/politik/belaestigung...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://www.blick.ch/news/ausland/termin-fuer-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/graubuenden/...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://www.blick.ch/news/ausland/mutter-des-e...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://www.blick.ch/news/ausland/miss-tuerkei...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://www.blick.ch/news/politik/lex-fifa-ste...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/zwei-buben-f...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://www.blick.ch/life/jetzt-beginnt-der-so...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://www.blick.ch/news/politik/ein-sehr-kna...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/mittelland/p...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/kantonsfinan...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://www.blick.ch/sport/fussball/europaleag...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://www.blick.ch/news/das-schwere-leben-in...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189035</th>\n",
       "      <td>https://www.blick.ch/news/ausland/sie-traf-den...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189036</th>\n",
       "      <td>https://www.blick.ch/people-tv/tv/gntm/wueste-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189037</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/hermann-lei-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189038</th>\n",
       "      <td>https://www.blick.ch/life/reisen/ch/staedte/vi...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189039</th>\n",
       "      <td>https://www.blick.ch/life/da-tschudderets-eine...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189040</th>\n",
       "      <td>https://www.blick.ch/people-tv/international/p...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189041</th>\n",
       "      <td>https://www.blick.ch/sport/fussball/europaleag...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189042</th>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/mclare...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189043</th>\n",
       "      <td>https://www.blick.ch/news/ausland/weil-er-eine...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189044</th>\n",
       "      <td>https://www.blick.ch/people-tv/SonntagsFahrt/s...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189045</th>\n",
       "      <td>https://www.blick.ch/news/schweiz/hier-entsteh...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189046</th>\n",
       "      <td>https://www.blick.ch/news/ausland/herzzerreiss...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189047</th>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/hubers-la...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189048</th>\n",
       "      <td>https://www.blick.ch/auto/tests/alfa-romeo-giu...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189049</th>\n",
       "      <td>https://www.blick.ch/sport/fussball/em/das-adr...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189050</th>\n",
       "      <td>https://www.blick.ch/interaktiv/infografiken/</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189051</th>\n",
       "      <td>https://www.blick.ch/incoming/nach-vereiteltem...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189052</th>\n",
       "      <td>https://www.blick.ch/sport/olympia/rio2016/tim...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189053</th>\n",
       "      <td>https://www.blick.ch/news/politik/abstimmung-v...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189054</th>\n",
       "      <td>https://www.blick.ch/sport/tennis/schaut-mal-f...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189055</th>\n",
       "      <td>https://www.blick.ch/news/ausland/50-menschen-...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189056</th>\n",
       "      <td>https://www.blick.ch/sport/fussball/nati/</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189057</th>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/gebru...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189058</th>\n",
       "      <td>https://www.blick.ch/life/reisen/active/unterw...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189059</th>\n",
       "      <td>https://www.blick.ch/incoming/schweizer-starph...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189060</th>\n",
       "      <td>https://www.blick.ch/life/essen/weintipp/weiss...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189061</th>\n",
       "      <td>https://www.blick.ch/sport/eishockey/eishockey...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189062</th>\n",
       "      <td>https://www.blick.ch/life/ho-ho-ho-ho-ho-ho-bl...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189063</th>\n",
       "      <td>https://www.blick.ch/incoming/crash-auf-dem-ma...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189064</th>\n",
       "      <td>https://www.blick.ch/incoming/us-comedy-legend...</td>\n",
       "      <td>text/html; charset=utf-8</td>\n",
       "      <td>200</td>\n",
       "      <td>OK</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>189065 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  Address  \\\n",
       "0       https://www.blick.ch/news/schweiz/parteien-sp-...   \n",
       "1       https://www.blick.ch/people-tv/musik/menschenr...   \n",
       "2       https://www.blick.ch/people-tv/international/a...   \n",
       "3       https://www.blick.ch/news/schweiz/schneebrett-...   \n",
       "4       https://www.blick.ch/people-tv/schweiz/mode-bl...   \n",
       "5       https://www.blick.ch/sport/eishockey/nla/ein-w...   \n",
       "6       https://www.blick.ch/news/ausland/ex-polizist-...   \n",
       "7       https://www.blick.ch/news/schweiz/bern/sie-kli...   \n",
       "8       https://www.blick.ch/news/ausland/kurios/hirnv...   \n",
       "9       https://www.blick.ch/news/wirtschaft/belgier-b...   \n",
       "10      https://www.blick.ch/news/schweiz/rauchverbote...   \n",
       "11      https://www.blick.ch/news/schweiz-italien-neue...   \n",
       "12      https://www.blick.ch/news/schweiz/syrien-syrer...   \n",
       "13      https://www.blick.ch/news/wirtschaft/waffen-pu...   \n",
       "14      https://www.blick.ch/people-tv/schweiz/energy-...   \n",
       "15      https://www.blick.ch/sport/auftakt-in-lausanne...   \n",
       "16      https://www.blick.ch/news/ausland/protest-gege...   \n",
       "17      https://www.blick.ch/news/politik/belaestigung...   \n",
       "18      https://www.blick.ch/news/ausland/termin-fuer-...   \n",
       "19      https://www.blick.ch/news/schweiz/graubuenden/...   \n",
       "20      https://www.blick.ch/news/ausland/mutter-des-e...   \n",
       "21      https://www.blick.ch/news/ausland/miss-tuerkei...   \n",
       "22      https://www.blick.ch/news/politik/lex-fifa-ste...   \n",
       "23      https://www.blick.ch/news/schweiz/zwei-buben-f...   \n",
       "24      https://www.blick.ch/life/jetzt-beginnt-der-so...   \n",
       "25      https://www.blick.ch/news/politik/ein-sehr-kna...   \n",
       "26      https://www.blick.ch/news/schweiz/mittelland/p...   \n",
       "27      https://www.blick.ch/news/schweiz/kantonsfinan...   \n",
       "28      https://www.blick.ch/sport/fussball/europaleag...   \n",
       "29      https://www.blick.ch/news/das-schwere-leben-in...   \n",
       "...                                                   ...   \n",
       "189035  https://www.blick.ch/news/ausland/sie-traf-den...   \n",
       "189036  https://www.blick.ch/people-tv/tv/gntm/wueste-...   \n",
       "189037  https://www.blick.ch/news/schweiz/hermann-lei-...   \n",
       "189038  https://www.blick.ch/life/reisen/ch/staedte/vi...   \n",
       "189039  https://www.blick.ch/life/da-tschudderets-eine...   \n",
       "189040  https://www.blick.ch/people-tv/international/p...   \n",
       "189041  https://www.blick.ch/sport/fussball/europaleag...   \n",
       "189042  https://www.blick.ch/auto/news_n_trends/mclare...   \n",
       "189043  https://www.blick.ch/news/ausland/weil-er-eine...   \n",
       "189044  https://www.blick.ch/people-tv/SonntagsFahrt/s...   \n",
       "189045  https://www.blick.ch/news/schweiz/hier-entsteh...   \n",
       "189046  https://www.blick.ch/news/ausland/herzzerreiss...   \n",
       "189047  https://www.blick.ch/news/wirtschaft/hubers-la...   \n",
       "189048  https://www.blick.ch/auto/tests/alfa-romeo-giu...   \n",
       "189049  https://www.blick.ch/sport/fussball/em/das-adr...   \n",
       "189050      https://www.blick.ch/interaktiv/infografiken/   \n",
       "189051  https://www.blick.ch/incoming/nach-vereiteltem...   \n",
       "189052  https://www.blick.ch/sport/olympia/rio2016/tim...   \n",
       "189053  https://www.blick.ch/news/politik/abstimmung-v...   \n",
       "189054  https://www.blick.ch/sport/tennis/schaut-mal-f...   \n",
       "189055  https://www.blick.ch/news/ausland/50-menschen-...   \n",
       "189056          https://www.blick.ch/sport/fussball/nati/   \n",
       "189057  https://www.blick.ch/sport/eishockey/nla/gebru...   \n",
       "189058  https://www.blick.ch/life/reisen/active/unterw...   \n",
       "189059  https://www.blick.ch/incoming/schweizer-starph...   \n",
       "189060  https://www.blick.ch/life/essen/weintipp/weiss...   \n",
       "189061  https://www.blick.ch/sport/eishockey/eishockey...   \n",
       "189062  https://www.blick.ch/life/ho-ho-ho-ho-ho-ho-bl...   \n",
       "189063  https://www.blick.ch/incoming/crash-auf-dem-ma...   \n",
       "189064  https://www.blick.ch/incoming/us-comedy-legend...   \n",
       "\n",
       "                         Content  Status Code Status  \\\n",
       "0       text/html; charset=utf-8          200     OK   \n",
       "1       text/html; charset=utf-8          200     OK   \n",
       "2       text/html; charset=utf-8          200     OK   \n",
       "3       text/html; charset=utf-8          200     OK   \n",
       "4       text/html; charset=utf-8          200     OK   \n",
       "5       text/html; charset=utf-8          200     OK   \n",
       "6       text/html; charset=utf-8          200     OK   \n",
       "7       text/html; charset=utf-8          200     OK   \n",
       "8       text/html; charset=utf-8          200     OK   \n",
       "9       text/html; charset=utf-8          200     OK   \n",
       "10      text/html; charset=utf-8          200     OK   \n",
       "11      text/html; charset=utf-8          200     OK   \n",
       "12      text/html; charset=utf-8          200     OK   \n",
       "13      text/html; charset=utf-8          200     OK   \n",
       "14      text/html; charset=utf-8          200     OK   \n",
       "15      text/html; charset=utf-8          200     OK   \n",
       "16      text/html; charset=utf-8          200     OK   \n",
       "17      text/html; charset=utf-8          200     OK   \n",
       "18      text/html; charset=utf-8          200     OK   \n",
       "19      text/html; charset=utf-8          200     OK   \n",
       "20      text/html; charset=utf-8          200     OK   \n",
       "21      text/html; charset=utf-8          200     OK   \n",
       "22      text/html; charset=utf-8          200     OK   \n",
       "23      text/html; charset=utf-8          200     OK   \n",
       "24      text/html; charset=utf-8          200     OK   \n",
       "25      text/html; charset=utf-8          200     OK   \n",
       "26      text/html; charset=utf-8          200     OK   \n",
       "27      text/html; charset=utf-8          200     OK   \n",
       "28      text/html; charset=utf-8          200     OK   \n",
       "29      text/html; charset=utf-8          200     OK   \n",
       "...                          ...          ...    ...   \n",
       "189035  text/html; charset=utf-8          200     OK   \n",
       "189036  text/html; charset=utf-8          200     OK   \n",
       "189037  text/html; charset=utf-8          200     OK   \n",
       "189038  text/html; charset=utf-8          200     OK   \n",
       "189039  text/html; charset=utf-8          200     OK   \n",
       "189040  text/html; charset=utf-8          200     OK   \n",
       "189041  text/html; charset=utf-8          200     OK   \n",
       "189042  text/html; charset=utf-8          200     OK   \n",
       "189043  text/html; charset=utf-8          200     OK   \n",
       "189044  text/html; charset=utf-8          200     OK   \n",
       "189045  text/html; charset=utf-8          200     OK   \n",
       "189046  text/html; charset=utf-8          200     OK   \n",
       "189047  text/html; charset=utf-8          200     OK   \n",
       "189048  text/html; charset=utf-8          200     OK   \n",
       "189049  text/html; charset=utf-8          200     OK   \n",
       "189050  text/html; charset=utf-8          200     OK   \n",
       "189051  text/html; charset=utf-8          200     OK   \n",
       "189052  text/html; charset=utf-8          200     OK   \n",
       "189053  text/html; charset=utf-8          200     OK   \n",
       "189054  text/html; charset=utf-8          200     OK   \n",
       "189055  text/html; charset=utf-8          200     OK   \n",
       "189056  text/html; charset=utf-8          200     OK   \n",
       "189057  text/html; charset=utf-8          200     OK   \n",
       "189058  text/html; charset=utf-8          200     OK   \n",
       "189059  text/html; charset=utf-8          200     OK   \n",
       "189060  text/html; charset=utf-8          200     OK   \n",
       "189061  text/html; charset=utf-8          200     OK   \n",
       "189062  text/html; charset=utf-8          200     OK   \n",
       "189063  text/html; charset=utf-8          200     OK   \n",
       "189064  text/html; charset=utf-8          200     OK   \n",
       "\n",
       "        Contains: '\"article-text-box\"'  Contains: '\"video-player\"'  \\\n",
       "0                                    0                           0   \n",
       "1                                    0                           0   \n",
       "2                                    0                           0   \n",
       "3                                    0                           0   \n",
       "4                                    0                           1   \n",
       "5                                    0                           0   \n",
       "6                                    0                           0   \n",
       "7                                    0                           0   \n",
       "8                                    0                           0   \n",
       "9                                    0                           0   \n",
       "10                                   0                           0   \n",
       "11                                   0                           0   \n",
       "12                                   0                           0   \n",
       "13                                   0                           0   \n",
       "14                                   0                           1   \n",
       "15                                   0                           1   \n",
       "16                                   0                           1   \n",
       "17                                   0                           0   \n",
       "18                                   0                           1   \n",
       "19                                   0                           0   \n",
       "20                                   0                           0   \n",
       "21                                   0                           0   \n",
       "22                                   0                           0   \n",
       "23                                   0                           0   \n",
       "24                                   0                           0   \n",
       "25                                   0                           1   \n",
       "26                                   0                           0   \n",
       "27                                   0                           0   \n",
       "28                                   0                           1   \n",
       "29                                   0                           1   \n",
       "...                                ...                         ...   \n",
       "189035                               0                           1   \n",
       "189036                               0                           0   \n",
       "189037                               0                           1   \n",
       "189038                               0                           1   \n",
       "189039                               0                           1   \n",
       "189040                               0                           1   \n",
       "189041                               0                           1   \n",
       "189042                               0                           1   \n",
       "189043                               0                           1   \n",
       "189044                               1                           1   \n",
       "189045                               0                           1   \n",
       "189046                               0                           1   \n",
       "189047                               0                           1   \n",
       "189048                               1                           1   \n",
       "189049                               0                           1   \n",
       "189050                               0                           0   \n",
       "189051                               0                           1   \n",
       "189052                               0                           1   \n",
       "189053                               0                           1   \n",
       "189054                               0                           1   \n",
       "189055                               0                           1   \n",
       "189056                               0                           0   \n",
       "189057                               0                           0   \n",
       "189058                               3                           1   \n",
       "189059                               1                           1   \n",
       "189060                               0                           1   \n",
       "189061                               0                           0   \n",
       "189062                               0                           1   \n",
       "189063                               0                           1   \n",
       "189064                               0                           1   \n",
       "\n",
       "        Contains: '<picture'  Contains: '\"article-body'  \n",
       "0                          8                          8  \n",
       "1                          9                          2  \n",
       "2                         13                          5  \n",
       "3                          8                          2  \n",
       "4                         10                          6  \n",
       "5                         10                          3  \n",
       "6                          9                          1  \n",
       "7                          8                          6  \n",
       "8                         11                          9  \n",
       "9                          8                          7  \n",
       "10                         8                          1  \n",
       "11                         8                         21  \n",
       "12                         8                         18  \n",
       "13                         8                          7  \n",
       "14                         8                          0  \n",
       "15                         8                          0  \n",
       "16                         8                          6  \n",
       "17                         9                          7  \n",
       "18                         8                         16  \n",
       "19                         9                          4  \n",
       "20                        11                          8  \n",
       "21                        10                          6  \n",
       "22                         8                         13  \n",
       "23                         8                          7  \n",
       "24                        12                          4  \n",
       "25                        10                         13  \n",
       "26                        10                          1  \n",
       "27                         8                          7  \n",
       "28                         8                          9  \n",
       "29                         8                          0  \n",
       "...                      ...                        ...  \n",
       "189035                     8                          2  \n",
       "189036                    13                          3  \n",
       "189037                     8                         12  \n",
       "189038                     8                          4  \n",
       "189039                     8                          0  \n",
       "189040                    12                          4  \n",
       "189041                     8                          6  \n",
       "189042                    14                          6  \n",
       "189043                    11                         14  \n",
       "189044                     8                         11  \n",
       "189045                    14                          6  \n",
       "189046                     8                          0  \n",
       "189047                     8                         11  \n",
       "189048                    14                         11  \n",
       "189049                     8                          6  \n",
       "189050                    20                          0  \n",
       "189051                    10                          8  \n",
       "189052                     8                          6  \n",
       "189053                     4                         17  \n",
       "189054                     8                          4  \n",
       "189055                    13                          9  \n",
       "189056                    20                          0  \n",
       "189057                    12                          7  \n",
       "189058                    16                         13  \n",
       "189059                    14                         43  \n",
       "189060                     9                          3  \n",
       "189061                    10                          4  \n",
       "189062                     8                          8  \n",
       "189063                    10                          8  \n",
       "189064                    10                         13  \n",
       "\n",
       "[189065 rows x 8 columns]"
      ]
     },
     "execution_count": 109,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Crawl here\n",
    "#Import crawl \n",
    "dfCrawled = pd.DataFrame(pd.read_excel('./custom_search_all.xlsx', header=0, sheet_name='1 - All'))\n",
    "dfCrawled"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Rename columns\n",
    "dfCrawled = dfCrawled.rename(columns={\"Contains: \\'\\\"article-text-box\\\"\\'\": \"article-text-box\", \n",
    "                                         \"Contains: \\'\\\"video-player\\\"\\'\":\"video-player\", \n",
    "                                         \"Contains: \\'<picture\\'\":\"picture\", \n",
    "                                         \"Contains: \\'\\\"article-body\\'\":\"article-body\" })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Getting the Id for later merge\n",
    "dfCrawled['ID_Crawl'] = dfCrawled['Address'].str.extract('(?:.*id)([0-9]+)(?:.html)', expand=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfCrawled = dfCrawled.drop(\"Status Code\",1)\n",
    "dfCrawled = dfCrawled.drop(\"Status\",1)\n",
    "dfCrawled = dfCrawled.drop(\"Content\",1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "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>ID_GA</th>\n",
       "      <th>Address</th>\n",
       "      <th>article-text-box</th>\n",
       "      <th>video-player</th>\n",
       "      <th>picture</th>\n",
       "      <th>article-body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5378225</td>\n",
       "      <td>https://www.blick.ch/people-tv/seth-rogen-wirb...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7091834</td>\n",
       "      <td>https://www.blick.ch/news/ausland/new-yorker-r...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7252099</td>\n",
       "      <td>https://www.blick.ch/news/ausland/die-behoerde...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7277672</td>\n",
       "      <td>https://www.blick.ch/news/ausland/enzym-zerset...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7393854</td>\n",
       "      <td>https://www.blick.ch/news/ausland/kenia-hat-da...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>8441776</td>\n",
       "      <td>https://www.blick.ch/people-tv/tv/bachelorette...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>9005034</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/internatio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8946692</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/internatio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7068779</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/best-o...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8958308</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/1-1-sieg-g...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8945118</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nhl/1-sch...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7074460</td>\n",
       "      <td>https://www.blick.ch/news/ausland/10-verletzte...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8885549</td>\n",
       "      <td>https://www.blick.ch/auto/classic/100-jahre-tr...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>7651914</td>\n",
       "      <td>https://www.blick.ch/news/ausland/100000-mensc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6430402</td>\n",
       "      <td>https://www.blick.ch/sport/kampfsport/111-beto...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>9002212</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/118-s...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>8962614</td>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/11880-fra...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5489638</td>\n",
       "      <td>https://www.blick.ch/life/gesundheit/medizin/1...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8908548</td>\n",
       "      <td>https://www.blick.ch/news/politik/12-jahre-im-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>9013074</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/12-kranke-2-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7027513</td>\n",
       "      <td>https://www.blick.ch/news/ausland/13-milliarde...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>7538597</td>\n",
       "      <td>https://www.blick.ch/life/gesundheit/ernaehrun...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>8134329</td>\n",
       "      <td>https://www.blick.ch/news/ausland/136-kilo-dyn...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5527389</td>\n",
       "      <td>https://www.blick.ch/people-tv/14-baeder-dacht...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>9027399</td>\n",
       "      <td>https://www.blick.ch/news/ausland/14-verletzte...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>8912285</td>\n",
       "      <td>https://www.blick.ch/people-tv/14-zurich-film-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>8839371</td>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/15-m-verp...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5690702</td>\n",
       "      <td>https://www.blick.ch/news/150-meter-unter-der-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5747679</td>\n",
       "      <td>https://www.blick.ch/news/1500-meter-hohe-rauc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>8945359</td>\n",
       "      <td>https://www.blick.ch/news/ausland/16-fache-gef...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194656</th>\n",
       "      <td>8455505</td>\n",
       "      <td>https://www.blick.ch/life/essen/rezept/saucen/...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194657</th>\n",
       "      <td>9015022</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zur-fahndung...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194658</th>\n",
       "      <td>6792263</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zur-rush-hou...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194659</th>\n",
       "      <td>8578972</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zur-tat-reko...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194660</th>\n",
       "      <td>5794406</td>\n",
       "      <td>https://www.blick.ch/people-tv/zurueck-nach-ei...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194661</th>\n",
       "      <td>9034616</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zusammen-mit...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194662</th>\n",
       "      <td>8211556</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-boeing-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194663</th>\n",
       "      <td>8533838</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-haben-s...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194664</th>\n",
       "      <td>8912369</td>\n",
       "      <td>https://www.blick.ch/news/wirtschaft/zwei-leis...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194665</th>\n",
       "      <td>7107576</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-mensche...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194666</th>\n",
       "      <td>8854431</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194667</th>\n",
       "      <td>8948051</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194668</th>\n",
       "      <td>8921450</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194669</th>\n",
       "      <td>8891656</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194670</th>\n",
       "      <td>4337749</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194671</th>\n",
       "      <td>9069060</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194672</th>\n",
       "      <td>8947262</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/ostschweiz/z...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194673</th>\n",
       "      <td>8621731</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/bern/zwei-sc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194674</th>\n",
       "      <td>8407448</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-schwerv...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194675</th>\n",
       "      <td>8982370</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/nati/zwei-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194676</th>\n",
       "      <td>8969518</td>\n",
       "      <td>https://www.blick.ch/digital/zwei-start-up-gru...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194677</th>\n",
       "      <td>8998611</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-tote-na...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194678</th>\n",
       "      <td>8157378</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-tote-sc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194679</th>\n",
       "      <td>8901094</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zwei-tote-un...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194680</th>\n",
       "      <td>9061916</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-verletz...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194681</th>\n",
       "      <td>8955119</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/basel/zwei-v...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194682</th>\n",
       "      <td>9065932</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/mittelland/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194683</th>\n",
       "      <td>8870859</td>\n",
       "      <td>https://www.blick.ch/life/beauty/koerperpflege...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194684</th>\n",
       "      <td>9030778</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/zweim...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194685</th>\n",
       "      <td>8865362</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zweisamkeit-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>188477 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                                            Address  \\\n",
       "0       5378225  https://www.blick.ch/people-tv/seth-rogen-wirb...   \n",
       "1       7091834  https://www.blick.ch/news/ausland/new-yorker-r...   \n",
       "2       7252099  https://www.blick.ch/news/ausland/die-behoerde...   \n",
       "3       7277672  https://www.blick.ch/news/ausland/enzym-zerset...   \n",
       "4       7393854  https://www.blick.ch/news/ausland/kenia-hat-da...   \n",
       "9       8441776  https://www.blick.ch/people-tv/tv/bachelorette...   \n",
       "10      9005034  https://www.blick.ch/sport/fussball/internatio...   \n",
       "11      8946692  https://www.blick.ch/sport/fussball/internatio...   \n",
       "12      7068779  https://www.blick.ch/sport/videoformate/best-o...   \n",
       "13      8958308  https://www.blick.ch/sport/fussball/1-1-sieg-g...   \n",
       "14      8945118  https://www.blick.ch/sport/eishockey/nhl/1-sch...   \n",
       "16      7074460  https://www.blick.ch/news/ausland/10-verletzte...   \n",
       "18      8885549  https://www.blick.ch/auto/classic/100-jahre-tr...   \n",
       "19      7651914  https://www.blick.ch/news/ausland/100000-mensc...   \n",
       "20      6430402  https://www.blick.ch/sport/kampfsport/111-beto...   \n",
       "21      9002212  https://www.blick.ch/sport/eishockey/nla/118-s...   \n",
       "22      8962614  https://www.blick.ch/news/wirtschaft/11880-fra...   \n",
       "23      5489638  https://www.blick.ch/life/gesundheit/medizin/1...   \n",
       "24      8908548  https://www.blick.ch/news/politik/12-jahre-im-...   \n",
       "25      9013074  https://www.blick.ch/news/schweiz/12-kranke-2-...   \n",
       "26      7027513  https://www.blick.ch/news/ausland/13-milliarde...   \n",
       "27      7538597  https://www.blick.ch/life/gesundheit/ernaehrun...   \n",
       "28      8134329  https://www.blick.ch/news/ausland/136-kilo-dyn...   \n",
       "29      5527389  https://www.blick.ch/people-tv/14-baeder-dacht...   \n",
       "30      9027399  https://www.blick.ch/news/ausland/14-verletzte...   \n",
       "31      8912285  https://www.blick.ch/people-tv/14-zurich-film-...   \n",
       "32      8839371  https://www.blick.ch/news/wirtschaft/15-m-verp...   \n",
       "33      5690702  https://www.blick.ch/news/150-meter-unter-der-...   \n",
       "34      5747679  https://www.blick.ch/news/1500-meter-hohe-rauc...   \n",
       "35      8945359  https://www.blick.ch/news/ausland/16-fache-gef...   \n",
       "...         ...                                                ...   \n",
       "194656  8455505  https://www.blick.ch/life/essen/rezept/saucen/...   \n",
       "194657  9015022  https://www.blick.ch/news/ausland/zur-fahndung...   \n",
       "194658  6792263  https://www.blick.ch/news/ausland/zur-rush-hou...   \n",
       "194659  8578972  https://www.blick.ch/news/schweiz/zur-tat-reko...   \n",
       "194660  5794406  https://www.blick.ch/people-tv/zurueck-nach-ei...   \n",
       "194661  9034616  https://www.blick.ch/news/ausland/zusammen-mit...   \n",
       "194662  8211556  https://www.blick.ch/news/ausland/zwei-boeing-...   \n",
       "194663  8533838  https://www.blick.ch/news/ausland/zwei-haben-s...   \n",
       "194664  8912369  https://www.blick.ch/news/wirtschaft/zwei-leis...   \n",
       "194665  7107576  https://www.blick.ch/news/ausland/zwei-mensche...   \n",
       "194666  8854431  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194667  8948051  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194668  8921450  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194669  8891656  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194670  4337749  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194671  9069060  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194672  8947262  https://www.blick.ch/news/schweiz/ostschweiz/z...   \n",
       "194673  8621731  https://www.blick.ch/news/schweiz/bern/zwei-sc...   \n",
       "194674  8407448  https://www.blick.ch/news/ausland/zwei-schwerv...   \n",
       "194675  8982370  https://www.blick.ch/sport/fussball/nati/zwei-...   \n",
       "194676  8969518  https://www.blick.ch/digital/zwei-start-up-gru...   \n",
       "194677  8998611  https://www.blick.ch/news/ausland/zwei-tote-na...   \n",
       "194678  8157378  https://www.blick.ch/news/ausland/zwei-tote-sc...   \n",
       "194679  8901094  https://www.blick.ch/news/schweiz/zwei-tote-un...   \n",
       "194680  9061916  https://www.blick.ch/news/ausland/zwei-verletz...   \n",
       "194681  8955119  https://www.blick.ch/news/schweiz/basel/zwei-v...   \n",
       "194682  9065932  https://www.blick.ch/news/schweiz/mittelland/z...   \n",
       "194683  8870859  https://www.blick.ch/life/beauty/koerperpflege...   \n",
       "194684  9030778  https://www.blick.ch/sport/eishockey/nla/zweim...   \n",
       "194685  8865362  https://www.blick.ch/news/ausland/zweisamkeit-...   \n",
       "\n",
       "        article-text-box  video-player  picture  article-body  \n",
       "0                    0.0           1.0      8.0           0.0  \n",
       "1                    0.0           1.0      8.0           8.0  \n",
       "2                    0.0           1.0      8.0           0.0  \n",
       "3                    0.0           1.0      8.0           0.0  \n",
       "4                    0.0           1.0      8.0           0.0  \n",
       "9                    0.0           0.0     13.0           8.0  \n",
       "10                   0.0           1.0      8.0           0.0  \n",
       "11                   0.0           1.0      8.0           0.0  \n",
       "12                   0.0           1.0      8.0           0.0  \n",
       "13                   0.0           1.0      8.0           0.0  \n",
       "14                   0.0           1.0      8.0           0.0  \n",
       "16                   0.0           1.0      8.0           0.0  \n",
       "18                   0.0           0.0     13.0           7.0  \n",
       "19                   0.0           1.0      8.0           4.0  \n",
       "20                   0.0           1.0      8.0           0.0  \n",
       "21                   1.0           2.0      8.0          14.0  \n",
       "22                   0.0           0.0     12.0           8.0  \n",
       "23                   1.0           0.0      9.0          26.0  \n",
       "24                   0.0           1.0      8.0           0.0  \n",
       "25                   0.0           0.0     10.0          10.0  \n",
       "26                   0.0           1.0      4.0           0.0  \n",
       "27                   4.0           0.0     16.0          42.0  \n",
       "28                   0.0           1.0      8.0           0.0  \n",
       "29                   0.0           1.0      8.0           0.0  \n",
       "30                   0.0           0.0      8.0           6.0  \n",
       "31                   0.0           1.0      8.0           0.0  \n",
       "32                   0.0           1.0     13.0           8.0  \n",
       "33                   0.0           1.0      8.0           0.0  \n",
       "34                   0.0           1.0      8.0           0.0  \n",
       "35                   0.0           1.0      8.0           2.0  \n",
       "...                  ...           ...      ...           ...  \n",
       "194656               1.0           0.0     11.0           6.0  \n",
       "194657               0.0           1.0      8.0           0.0  \n",
       "194658               0.0           1.0      8.0           0.0  \n",
       "194659               0.0           1.0      8.0           0.0  \n",
       "194660               0.0           1.0      8.0           0.0  \n",
       "194661               0.0           1.0      8.0           4.0  \n",
       "194662               0.0           1.0      8.0           0.0  \n",
       "194663               0.0           1.0      8.0           0.0  \n",
       "194664               0.0           0.0      9.0           5.0  \n",
       "194665               0.0           1.0      8.0           3.0  \n",
       "194666               0.0           1.0      4.0           0.0  \n",
       "194667               0.0           1.0      8.0           0.0  \n",
       "194668               0.0           1.0      8.0           0.0  \n",
       "194669               0.0           1.0      8.0           0.0  \n",
       "194670               0.0           1.0      4.0           4.0  \n",
       "194671               0.0           1.0      8.0           0.0  \n",
       "194672               1.0           2.0     12.0           9.0  \n",
       "194673               0.0           1.0      8.0           0.0  \n",
       "194674               0.0           1.0      8.0           1.0  \n",
       "194675               0.0           0.0     17.0           3.0  \n",
       "194676               0.0           0.0     11.0          13.0  \n",
       "194677               0.0           1.0      8.0           3.0  \n",
       "194678               0.0           1.0      8.0           0.0  \n",
       "194679               0.0           0.0     13.0          13.0  \n",
       "194680               0.0           0.0     13.0          11.0  \n",
       "194681               0.0           0.0     10.0           2.0  \n",
       "194682               0.0           0.0     10.0           6.0  \n",
       "194683               2.0           1.0     11.0          19.0  \n",
       "194684               0.0           0.0     13.0           8.0  \n",
       "194685               0.0           1.0      8.0           0.0  \n",
       "\n",
       "[188477 rows x 6 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Merge is important because of possible redirects to useful articels \n",
    "dfMerged = pd.merge(dfanalytics, dfCrawled, left_on='ID_GA', right_on='ID_Crawl', how='outer')\n",
    "dfMerged = dfMerged[dfMerged['ID_Crawl'].notnull()]\n",
    "dfMerged = dfMerged[dfMerged['ID_GA'].notnull()]\n",
    "dfMerged = dfMerged.drop(\"ShortURL\",1)\n",
    "dfMerged = dfMerged.drop(\"ID_Crawl\",1)\n",
    "dfMerged\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [],
   "source": [
    "#dfMerged.to_csv('mergedNew.csv', sep='\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "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>ID_GA</th>\n",
       "      <th>Address</th>\n",
       "      <th>article-text-box</th>\n",
       "      <th>video-player</th>\n",
       "      <th>picture</th>\n",
       "      <th>article-body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>1443922</td>\n",
       "      <td>https://www.blick.ch/aktuell/15-12-swiss-flieg...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>904</th>\n",
       "      <td>7410126</td>\n",
       "      <td>https://www.blick.ch/auto/abgefahren/facebook-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>1796059</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/direkt-vom...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1105</th>\n",
       "      <td>6305932</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/blick-auto...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1123</th>\n",
       "      <td>2714035</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/interaktiv...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1127</th>\n",
       "      <td>2717233</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/interaktiv...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1134</th>\n",
       "      <td>2716437</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/interaktiv...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>4770422</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/multimedia...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1259</th>\n",
       "      <td>8070433</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/news/blick...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1282</th>\n",
       "      <td>2227668</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/news/mehr-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1444</th>\n",
       "      <td>2092364</td>\n",
       "      <td>https://www.blick.ch/auto/e-paper-nutzfahrzeug...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1483</th>\n",
       "      <td>1843493</td>\n",
       "      <td>https://www.blick.ch/auto/gratis-epaper-holen-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>2712337</td>\n",
       "      <td>https://www.blick.ch/auto/historie-meilenstein...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1566</th>\n",
       "      <td>2206181</td>\n",
       "      <td>https://www.blick.ch/auto/e-paper-blick-extra-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1764</th>\n",
       "      <td>7312658</td>\n",
       "      <td>https://www.blick.ch/auto/vw-beetle-polo-r-lin...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2100</th>\n",
       "      <td>1662404</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/die-gi...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5026</th>\n",
       "      <td>9033984</td>\n",
       "      <td>https://www.blick.ch/sport/formel1/das-qualify...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5240</th>\n",
       "      <td>1953909</td>\n",
       "      <td>https://www.blick.ch/digital/3-kameras-mit-cha...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5278</th>\n",
       "      <td>1913923</td>\n",
       "      <td>https://www.blick.ch/digital/appsolut-fussball...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5354</th>\n",
       "      <td>3363834</td>\n",
       "      <td>https://www.blick.ch/digital/das-war-2014-dies...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5449</th>\n",
       "      <td>2573184</td>\n",
       "      <td>https://www.blick.ch/digital/finger-drummer-di...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5485</th>\n",
       "      <td>7800647</td>\n",
       "      <td>https://www.blick.ch/digital/gadgets-technik/l...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5500</th>\n",
       "      <td>8780961</td>\n",
       "      <td>https://www.blick.ch/digital/gadgets-technik/t...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5511</th>\n",
       "      <td>5465135</td>\n",
       "      <td>https://www.blick.ch/digital/games/ab-21-uhr-l...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5908</th>\n",
       "      <td>4678749</td>\n",
       "      <td>https://www.blick.ch/digital/games/legends-of-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5913</th>\n",
       "      <td>2901142</td>\n",
       "      <td>https://www.blick.ch/digital/games/livestream-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6291</th>\n",
       "      <td>1800752</td>\n",
       "      <td>https://www.blick.ch/digital/hatsune-miku-umju...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6724</th>\n",
       "      <td>1658954</td>\n",
       "      <td>https://www.blick.ch/digital/iphone-am-strand-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7017</th>\n",
       "      <td>8558310</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/internatio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8295</th>\n",
       "      <td>2335310</td>\n",
       "      <td>https://www.blick.ch/incoming/360-panoramafoto...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183777</th>\n",
       "      <td>5284265</td>\n",
       "      <td>https://www.blick.ch/sport/rad/tour-de-france-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183844</th>\n",
       "      <td>5210943</td>\n",
       "      <td>https://www.blick.ch/sport/rad/tour-de-suisse/...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184366</th>\n",
       "      <td>2419207</td>\n",
       "      <td>https://www.blick.ch/sport/schwingen/drehtelle...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184854</th>\n",
       "      <td>7078932</td>\n",
       "      <td>https://www.blick.ch/sport/sempach-janka-benci...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186184</th>\n",
       "      <td>7523513</td>\n",
       "      <td>https://www.blick.ch/sport/ski/zweiter-riesen-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186386</th>\n",
       "      <td>2205257</td>\n",
       "      <td>https://www.blick.ch/sport/ski/kommentar-zu-li...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186446</th>\n",
       "      <td>7790439</td>\n",
       "      <td>https://www.blick.ch/sport/ski/live-ab-16-05-u...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186795</th>\n",
       "      <td>1808540</td>\n",
       "      <td>https://www.blick.ch/sport/ski/tschuess-didi-i...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186995</th>\n",
       "      <td>2192690</td>\n",
       "      <td>https://www.blick.ch/sport/ski/wm/infografik-a...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187019</th>\n",
       "      <td>6174618</td>\n",
       "      <td>https://www.blick.ch/sport/ski/wm/stmoritz2017...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187027</th>\n",
       "      <td>6147597</td>\n",
       "      <td>https://www.blick.ch/sport/ski/wm/stmoritz2017...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187182</th>\n",
       "      <td>3415260</td>\n",
       "      <td>https://www.blick.ch/sport/sport-samstag-im-ti...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187183</th>\n",
       "      <td>3482964</td>\n",
       "      <td>https://www.blick.ch/sport/sport-samstag-im-ti...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187281</th>\n",
       "      <td>4345014</td>\n",
       "      <td>https://www.blick.ch/sport/tattoo-freak-beckha...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187893</th>\n",
       "      <td>3298935</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/durchblaette...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188302</th>\n",
       "      <td>7001020</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/grand-slam/w...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188588</th>\n",
       "      <td>2354053</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/jahrgang-198...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191493</th>\n",
       "      <td>8489292</td>\n",
       "      <td>https://www.blick.ch/sport/wer-fuehrt-die-wm-t...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191762</th>\n",
       "      <td>1661314</td>\n",
       "      <td>https://www.blick.ch/sport/wintersport/so-verb...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191916</th>\n",
       "      <td>3518844</td>\n",
       "      <td>https://www.blick.ch/sport/wintersport/langlau...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191978</th>\n",
       "      <td>7810592</td>\n",
       "      <td>https://www.blick.ch/sport/wintersport/langlau...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192053</th>\n",
       "      <td>4541891</td>\n",
       "      <td>https://www.blick.ch/sport/wintersport/langlau...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194308</th>\n",
       "      <td>5490562</td>\n",
       "      <td>https://www.blick.ch/vr/eiger-id5490562.html</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194321</th>\n",
       "      <td>5743588</td>\n",
       "      <td>https://www.blick.ch/vr/neues-virtual-reality-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194349</th>\n",
       "      <td>7278807</td>\n",
       "      <td>https://www.blick.ch/vr/neues-virtual-reality-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194375</th>\n",
       "      <td>5936544</td>\n",
       "      <td>https://www.blick.ch/vr/neues-virtual-reality-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194384</th>\n",
       "      <td>5744691</td>\n",
       "      <td>https://www.blick.ch/vr/neues-virtual-reality-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194388</th>\n",
       "      <td>6945062</td>\n",
       "      <td>https://www.blick.ch/vr/virtual-reality-video-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194389</th>\n",
       "      <td>6528233</td>\n",
       "      <td>https://www.blick.ch/vr/virtual-reality-video-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194555</th>\n",
       "      <td>6836299</td>\n",
       "      <td>https://www.blick.ch/interaktiv/interaktiv/wie...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1013 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                                            Address  \\\n",
       "165     1443922  https://www.blick.ch/aktuell/15-12-swiss-flieg...   \n",
       "904     7410126  https://www.blick.ch/auto/abgefahren/facebook-...   \n",
       "1073    1796059  https://www.blick.ch/auto/autosalon/direkt-vom...   \n",
       "1105    6305932  https://www.blick.ch/auto/autosalon/blick-auto...   \n",
       "1123    2714035  https://www.blick.ch/auto/autosalon/interaktiv...   \n",
       "1127    2717233  https://www.blick.ch/auto/autosalon/interaktiv...   \n",
       "1134    2716437  https://www.blick.ch/auto/autosalon/interaktiv...   \n",
       "1169    4770422  https://www.blick.ch/auto/autosalon/multimedia...   \n",
       "1259    8070433  https://www.blick.ch/auto/autosalon/news/blick...   \n",
       "1282    2227668  https://www.blick.ch/auto/autosalon/news/mehr-...   \n",
       "1444    2092364  https://www.blick.ch/auto/e-paper-nutzfahrzeug...   \n",
       "1483    1843493  https://www.blick.ch/auto/gratis-epaper-holen-...   \n",
       "1487    2712337  https://www.blick.ch/auto/historie-meilenstein...   \n",
       "1566    2206181  https://www.blick.ch/auto/e-paper-blick-extra-...   \n",
       "1764    7312658  https://www.blick.ch/auto/vw-beetle-polo-r-lin...   \n",
       "2100    1662404  https://www.blick.ch/auto/news_n_trends/die-gi...   \n",
       "5026    9033984  https://www.blick.ch/sport/formel1/das-qualify...   \n",
       "5240    1953909  https://www.blick.ch/digital/3-kameras-mit-cha...   \n",
       "5278    1913923  https://www.blick.ch/digital/appsolut-fussball...   \n",
       "5354    3363834  https://www.blick.ch/digital/das-war-2014-dies...   \n",
       "5449    2573184  https://www.blick.ch/digital/finger-drummer-di...   \n",
       "5485    7800647  https://www.blick.ch/digital/gadgets-technik/l...   \n",
       "5500    8780961  https://www.blick.ch/digital/gadgets-technik/t...   \n",
       "5511    5465135  https://www.blick.ch/digital/games/ab-21-uhr-l...   \n",
       "5908    4678749  https://www.blick.ch/digital/games/legends-of-...   \n",
       "5913    2901142  https://www.blick.ch/digital/games/livestream-...   \n",
       "6291    1800752  https://www.blick.ch/digital/hatsune-miku-umju...   \n",
       "6724    1658954  https://www.blick.ch/digital/iphone-am-strand-...   \n",
       "7017    8558310  https://www.blick.ch/sport/fussball/internatio...   \n",
       "8295    2335310  https://www.blick.ch/incoming/360-panoramafoto...   \n",
       "...         ...                                                ...   \n",
       "183777  5284265  https://www.blick.ch/sport/rad/tour-de-france-...   \n",
       "183844  5210943  https://www.blick.ch/sport/rad/tour-de-suisse/...   \n",
       "184366  2419207  https://www.blick.ch/sport/schwingen/drehtelle...   \n",
       "184854  7078932  https://www.blick.ch/sport/sempach-janka-benci...   \n",
       "186184  7523513  https://www.blick.ch/sport/ski/zweiter-riesen-...   \n",
       "186386  2205257  https://www.blick.ch/sport/ski/kommentar-zu-li...   \n",
       "186446  7790439  https://www.blick.ch/sport/ski/live-ab-16-05-u...   \n",
       "186795  1808540  https://www.blick.ch/sport/ski/tschuess-didi-i...   \n",
       "186995  2192690  https://www.blick.ch/sport/ski/wm/infografik-a...   \n",
       "187019  6174618  https://www.blick.ch/sport/ski/wm/stmoritz2017...   \n",
       "187027  6147597  https://www.blick.ch/sport/ski/wm/stmoritz2017...   \n",
       "187182  3415260  https://www.blick.ch/sport/sport-samstag-im-ti...   \n",
       "187183  3482964  https://www.blick.ch/sport/sport-samstag-im-ti...   \n",
       "187281  4345014  https://www.blick.ch/sport/tattoo-freak-beckha...   \n",
       "187893  3298935  https://www.blick.ch/sport/tennis/durchblaette...   \n",
       "188302  7001020  https://www.blick.ch/sport/tennis/grand-slam/w...   \n",
       "188588  2354053  https://www.blick.ch/sport/tennis/jahrgang-198...   \n",
       "191493  8489292  https://www.blick.ch/sport/wer-fuehrt-die-wm-t...   \n",
       "191762  1661314  https://www.blick.ch/sport/wintersport/so-verb...   \n",
       "191916  3518844  https://www.blick.ch/sport/wintersport/langlau...   \n",
       "191978  7810592  https://www.blick.ch/sport/wintersport/langlau...   \n",
       "192053  4541891  https://www.blick.ch/sport/wintersport/langlau...   \n",
       "194308  5490562       https://www.blick.ch/vr/eiger-id5490562.html   \n",
       "194321  5743588  https://www.blick.ch/vr/neues-virtual-reality-...   \n",
       "194349  7278807  https://www.blick.ch/vr/neues-virtual-reality-...   \n",
       "194375  5936544  https://www.blick.ch/vr/neues-virtual-reality-...   \n",
       "194384  5744691  https://www.blick.ch/vr/neues-virtual-reality-...   \n",
       "194388  6945062  https://www.blick.ch/vr/virtual-reality-video-...   \n",
       "194389  6528233  https://www.blick.ch/vr/virtual-reality-video-...   \n",
       "194555  6836299  https://www.blick.ch/interaktiv/interaktiv/wie...   \n",
       "\n",
       "        article-text-box  video-player  picture  article-body  \n",
       "165                  0.0           0.0      8.0           0.0  \n",
       "904                  0.0           0.0      8.0           0.0  \n",
       "1073                 0.0           0.0      8.0           0.0  \n",
       "1105                 0.0           0.0      8.0           0.0  \n",
       "1123                 0.0           0.0      8.0           0.0  \n",
       "1127                 0.0           0.0      8.0           0.0  \n",
       "1134                 0.0           0.0      8.0           0.0  \n",
       "1169                 0.0           0.0      8.0           0.0  \n",
       "1259                 0.0           0.0      8.0           0.0  \n",
       "1282                 0.0           0.0      8.0           0.0  \n",
       "1444                 0.0           0.0      8.0           0.0  \n",
       "1483                 0.0           0.0      8.0           0.0  \n",
       "1487                 0.0           0.0      8.0           0.0  \n",
       "1566                 0.0           0.0      8.0           0.0  \n",
       "1764                 0.0           0.0      8.0           0.0  \n",
       "2100                 0.0           0.0      8.0           0.0  \n",
       "5026                 0.0           0.0      8.0           0.0  \n",
       "5240                 0.0           0.0      8.0           0.0  \n",
       "5278                 0.0           0.0      8.0           0.0  \n",
       "5354                 0.0           0.0      8.0           0.0  \n",
       "5449                 0.0           0.0      8.0           0.0  \n",
       "5485                 0.0           0.0      8.0           0.0  \n",
       "5500                 0.0           0.0      8.0           0.0  \n",
       "5511                 0.0           0.0      8.0           0.0  \n",
       "5908                 0.0           0.0      0.0           0.0  \n",
       "5913                 0.0           0.0      8.0           0.0  \n",
       "6291                 0.0           0.0      7.0           0.0  \n",
       "6724                 0.0           0.0      8.0           0.0  \n",
       "7017                 0.0           0.0      0.0           0.0  \n",
       "8295                 0.0           0.0      8.0           0.0  \n",
       "...                  ...           ...      ...           ...  \n",
       "183777               0.0           0.0      8.0           0.0  \n",
       "183844               0.0           0.0      4.0           0.0  \n",
       "184366               0.0           0.0      8.0           0.0  \n",
       "184854               0.0           0.0      8.0           0.0  \n",
       "186184               0.0           0.0      8.0           0.0  \n",
       "186386               0.0           0.0      8.0           0.0  \n",
       "186446               0.0           0.0      8.0           0.0  \n",
       "186795               0.0           0.0      8.0           0.0  \n",
       "186995               0.0           0.0      8.0           0.0  \n",
       "187019               0.0           0.0      8.0           0.0  \n",
       "187027               0.0           0.0      8.0           0.0  \n",
       "187182               0.0           0.0      8.0           0.0  \n",
       "187183               0.0           0.0      8.0           0.0  \n",
       "187281               0.0           0.0      8.0           0.0  \n",
       "187893               0.0           0.0      8.0           0.0  \n",
       "188302               0.0           0.0      8.0           0.0  \n",
       "188588               0.0           0.0      8.0           0.0  \n",
       "191493               0.0           0.0      0.0           0.0  \n",
       "191762               0.0           0.0      8.0           0.0  \n",
       "191916               0.0           0.0      8.0           0.0  \n",
       "191978               0.0           0.0      8.0           0.0  \n",
       "192053               0.0           0.0      8.0           0.0  \n",
       "194308               0.0           0.0      0.0           0.0  \n",
       "194321               0.0           0.0      8.0           0.0  \n",
       "194349               0.0           0.0      8.0           0.0  \n",
       "194375               0.0           0.0      8.0           0.0  \n",
       "194384               0.0           0.0      8.0           0.0  \n",
       "194388               0.0           0.0      8.0           0.0  \n",
       "194389               0.0           0.0      8.0           0.0  \n",
       "194555               0.0           0.0      8.0           0.0  \n",
       "\n",
       "[1013 rows x 6 columns]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Usecases Pure Bullshit: No video, No images, No article text, no textbox\n",
    "dfPureBullshit = dfMerged\n",
    "dfPureBullshit = dfPureBullshit[dfPureBullshit['article-text-box'] == 0]\n",
    "dfPureBullshit = dfPureBullshit[dfPureBullshit['article-body'] == 0]\n",
    "dfPureBullshit = dfPureBullshit[dfPureBullshit['picture'] < 9]\n",
    "dfPureBullshit = dfPureBullshit[dfPureBullshit['video-player'] == 0]\n",
    "dfPureBullshit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {
    "scrolled": false
   },
   "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>ID_GA</th>\n",
       "      <th>Address</th>\n",
       "      <th>article-text-box</th>\n",
       "      <th>video-player</th>\n",
       "      <th>picture</th>\n",
       "      <th>article-body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>8961535</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/32-ja...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>8755696</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/ab-fr...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1179</th>\n",
       "      <td>4751915</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/news/augen...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1199</th>\n",
       "      <td>2226057</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/news/die-m...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1325</th>\n",
       "      <td>1797530</td>\n",
       "      <td>https://www.blick.ch/auto/autosalon/promis/die...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2095</th>\n",
       "      <td>1721007</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/detroi...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2104</th>\n",
       "      <td>2049991</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/die-sc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2183</th>\n",
       "      <td>4379858</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/fantas...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2259</th>\n",
       "      <td>1677955</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/gesche...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2288</th>\n",
       "      <td>1867903</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/miss-t...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2440</th>\n",
       "      <td>2438472</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/sexy-m...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3160</th>\n",
       "      <td>4177080</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/messe-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3175</th>\n",
       "      <td>2016651</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/moskau...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3271</th>\n",
       "      <td>2077675</td>\n",
       "      <td>https://www.blick.ch/auto/news_n_trends/sao-pa...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4868</th>\n",
       "      <td>8950744</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/cathy...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5060</th>\n",
       "      <td>8777374</td>\n",
       "      <td>https://www.blick.ch/news/ausland/demonstratio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5200</th>\n",
       "      <td>9034342</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/die-s...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5296</th>\n",
       "      <td>3578075</td>\n",
       "      <td>https://www.blick.ch/digital/bestseller-wieder...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5342</th>\n",
       "      <td>2536215</td>\n",
       "      <td>https://www.blick.ch/digital/damit-kein-boreou...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5446</th>\n",
       "      <td>3732780</td>\n",
       "      <td>https://www.blick.ch/digital/fernseher-fuer-je...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6294</th>\n",
       "      <td>3879273</td>\n",
       "      <td>https://www.blick.ch/digital/helfer-aus-der-di...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6331</th>\n",
       "      <td>1720914</td>\n",
       "      <td>https://www.blick.ch/digital/ipad-gitarre-und-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6476</th>\n",
       "      <td>3781635</td>\n",
       "      <td>https://www.blick.ch/digital/mp3-player-statt-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6485</th>\n",
       "      <td>3954288</td>\n",
       "      <td>https://www.blick.ch/digital/jetzt-zugreifen-d...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6718</th>\n",
       "      <td>6365740</td>\n",
       "      <td>https://www.blick.ch/digital/innovativer-als-d...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6732</th>\n",
       "      <td>3521527</td>\n",
       "      <td>https://www.blick.ch/digital/kickstarter-diese...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6786</th>\n",
       "      <td>2020519</td>\n",
       "      <td>https://www.blick.ch/digital/neues-von-der-ifa...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6813</th>\n",
       "      <td>4321749</td>\n",
       "      <td>https://www.blick.ch/digital/schlaue-und-trend...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6913</th>\n",
       "      <td>1958736</td>\n",
       "      <td>https://www.blick.ch/digital/technik-fuer-die-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6931</th>\n",
       "      <td>3852907</td>\n",
       "      <td>https://www.blick.ch/digital/veredlete-technik...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179789</th>\n",
       "      <td>6420692</td>\n",
       "      <td>https://www.blick.ch/sport/manche-moegens-bunt...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179801</th>\n",
       "      <td>6850961</td>\n",
       "      <td>https://www.blick.ch/sport/wir-trainieren-wied...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179810</th>\n",
       "      <td>7089850</td>\n",
       "      <td>https://www.blick.ch/sport/mit-kind-und-kuebel...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179889</th>\n",
       "      <td>8315563</td>\n",
       "      <td>https://www.blick.ch/sport/zuerich-steht-kopf-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180117</th>\n",
       "      <td>2616730</td>\n",
       "      <td>https://www.blick.ch/sport/legende-viktor-gert...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180239</th>\n",
       "      <td>3057694</td>\n",
       "      <td>https://www.blick.ch/sport/leichtathletik/geil...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180396</th>\n",
       "      <td>5446169</td>\n",
       "      <td>https://www.blick.ch/sport/leichtathletik/welt...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180783</th>\n",
       "      <td>3581640</td>\n",
       "      <td>https://www.blick.ch/sport/mehr_sport/die-best...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182190</th>\n",
       "      <td>7859233</td>\n",
       "      <td>https://www.blick.ch/sport/olympia/pyeongchang...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182202</th>\n",
       "      <td>7690775</td>\n",
       "      <td>https://www.blick.ch/sport/olympia/pyeongchang...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183384</th>\n",
       "      <td>5971902</td>\n",
       "      <td>https://www.blick.ch/sport/rad/seine-groessten...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183472</th>\n",
       "      <td>8126018</td>\n",
       "      <td>https://www.blick.ch/sport/rad/schurter-beim-c...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185134</th>\n",
       "      <td>4797380</td>\n",
       "      <td>https://www.blick.ch/sport/ski/damen/gut-gewin...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185237</th>\n",
       "      <td>3594971</td>\n",
       "      <td>https://www.blick.ch/sport/ski/das-waren-die-h...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185605</th>\n",
       "      <td>1742271</td>\n",
       "      <td>https://www.blick.ch/sport/ski/ski-weltcup-die...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186133</th>\n",
       "      <td>6203400</td>\n",
       "      <td>https://www.blick.ch/sport/ski/live-ab-18-30-u...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186135</th>\n",
       "      <td>6216172</td>\n",
       "      <td>https://www.blick.ch/sport/ski/gold-und-bronze...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186984</th>\n",
       "      <td>6242052</td>\n",
       "      <td>https://www.blick.ch/sport/ski/wm/schangnau-be...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187068</th>\n",
       "      <td>6253465</td>\n",
       "      <td>https://www.blick.ch/sport/ski/wm/stmoritz2017...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187593</th>\n",
       "      <td>6744963</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/atp/stan-waw...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188004</th>\n",
       "      <td>4161231</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/federer-gege...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189091</th>\n",
       "      <td>6395176</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/immer-wieder...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189543</th>\n",
       "      <td>6510752</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/match-for-af...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189561</th>\n",
       "      <td>6046558</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/mit-ihnen-re...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189693</th>\n",
       "      <td>4164589</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/promi-auflau...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189884</th>\n",
       "      <td>5233955</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/sieg-nach-0-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189949</th>\n",
       "      <td>5242614</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/stars-in-wim...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191494</th>\n",
       "      <td>6734943</td>\n",
       "      <td>https://www.blick.ch/sport/wer-holt-sich-den-c...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193053</th>\n",
       "      <td>9068417</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/victo...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194423</th>\n",
       "      <td>5005200</td>\n",
       "      <td>https://www.blick.ch/people-tv/fotostory/playb...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1742 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                                            Address  \\\n",
       "83      8961535  https://www.blick.ch/people-tv/fotostory/32-ja...   \n",
       "117     8755696  https://www.blick.ch/people-tv/fotostory/ab-fr...   \n",
       "1179    4751915  https://www.blick.ch/auto/autosalon/news/augen...   \n",
       "1199    2226057  https://www.blick.ch/auto/autosalon/news/die-m...   \n",
       "1325    1797530  https://www.blick.ch/auto/autosalon/promis/die...   \n",
       "2095    1721007  https://www.blick.ch/auto/news_n_trends/detroi...   \n",
       "2104    2049991  https://www.blick.ch/auto/news_n_trends/die-sc...   \n",
       "2183    4379858  https://www.blick.ch/auto/news_n_trends/fantas...   \n",
       "2259    1677955  https://www.blick.ch/auto/news_n_trends/gesche...   \n",
       "2288    1867903  https://www.blick.ch/auto/news_n_trends/miss-t...   \n",
       "2440    2438472  https://www.blick.ch/auto/news_n_trends/sexy-m...   \n",
       "3160    4177080  https://www.blick.ch/auto/news_n_trends/messe-...   \n",
       "3175    2016651  https://www.blick.ch/auto/news_n_trends/moskau...   \n",
       "3271    2077675  https://www.blick.ch/auto/news_n_trends/sao-pa...   \n",
       "4868    8950744  https://www.blick.ch/people-tv/fotostory/cathy...   \n",
       "5060    8777374  https://www.blick.ch/news/ausland/demonstratio...   \n",
       "5200    9034342  https://www.blick.ch/people-tv/fotostory/die-s...   \n",
       "5296    3578075  https://www.blick.ch/digital/bestseller-wieder...   \n",
       "5342    2536215  https://www.blick.ch/digital/damit-kein-boreou...   \n",
       "5446    3732780  https://www.blick.ch/digital/fernseher-fuer-je...   \n",
       "6294    3879273  https://www.blick.ch/digital/helfer-aus-der-di...   \n",
       "6331    1720914  https://www.blick.ch/digital/ipad-gitarre-und-...   \n",
       "6476    3781635  https://www.blick.ch/digital/mp3-player-statt-...   \n",
       "6485    3954288  https://www.blick.ch/digital/jetzt-zugreifen-d...   \n",
       "6718    6365740  https://www.blick.ch/digital/innovativer-als-d...   \n",
       "6732    3521527  https://www.blick.ch/digital/kickstarter-diese...   \n",
       "6786    2020519  https://www.blick.ch/digital/neues-von-der-ifa...   \n",
       "6813    4321749  https://www.blick.ch/digital/schlaue-und-trend...   \n",
       "6913    1958736  https://www.blick.ch/digital/technik-fuer-die-...   \n",
       "6931    3852907  https://www.blick.ch/digital/veredlete-technik...   \n",
       "...         ...                                                ...   \n",
       "179789  6420692  https://www.blick.ch/sport/manche-moegens-bunt...   \n",
       "179801  6850961  https://www.blick.ch/sport/wir-trainieren-wied...   \n",
       "179810  7089850  https://www.blick.ch/sport/mit-kind-und-kuebel...   \n",
       "179889  8315563  https://www.blick.ch/sport/zuerich-steht-kopf-...   \n",
       "180117  2616730  https://www.blick.ch/sport/legende-viktor-gert...   \n",
       "180239  3057694  https://www.blick.ch/sport/leichtathletik/geil...   \n",
       "180396  5446169  https://www.blick.ch/sport/leichtathletik/welt...   \n",
       "180783  3581640  https://www.blick.ch/sport/mehr_sport/die-best...   \n",
       "182190  7859233  https://www.blick.ch/sport/olympia/pyeongchang...   \n",
       "182202  7690775  https://www.blick.ch/sport/olympia/pyeongchang...   \n",
       "183384  5971902  https://www.blick.ch/sport/rad/seine-groessten...   \n",
       "183472  8126018  https://www.blick.ch/sport/rad/schurter-beim-c...   \n",
       "185134  4797380  https://www.blick.ch/sport/ski/damen/gut-gewin...   \n",
       "185237  3594971  https://www.blick.ch/sport/ski/das-waren-die-h...   \n",
       "185605  1742271  https://www.blick.ch/sport/ski/ski-weltcup-die...   \n",
       "186133  6203400  https://www.blick.ch/sport/ski/live-ab-18-30-u...   \n",
       "186135  6216172  https://www.blick.ch/sport/ski/gold-und-bronze...   \n",
       "186984  6242052  https://www.blick.ch/sport/ski/wm/schangnau-be...   \n",
       "187068  6253465  https://www.blick.ch/sport/ski/wm/stmoritz2017...   \n",
       "187593  6744963  https://www.blick.ch/sport/tennis/atp/stan-waw...   \n",
       "188004  4161231  https://www.blick.ch/sport/tennis/federer-gege...   \n",
       "189091  6395176  https://www.blick.ch/sport/tennis/immer-wieder...   \n",
       "189543  6510752  https://www.blick.ch/sport/tennis/match-for-af...   \n",
       "189561  6046558  https://www.blick.ch/sport/tennis/mit-ihnen-re...   \n",
       "189693  4164589  https://www.blick.ch/sport/tennis/promi-auflau...   \n",
       "189884  5233955  https://www.blick.ch/sport/tennis/sieg-nach-0-...   \n",
       "189949  5242614  https://www.blick.ch/sport/tennis/stars-in-wim...   \n",
       "191494  6734943  https://www.blick.ch/sport/wer-holt-sich-den-c...   \n",
       "193053  9068417  https://www.blick.ch/people-tv/fotostory/victo...   \n",
       "194423  5005200  https://www.blick.ch/people-tv/fotostory/playb...   \n",
       "\n",
       "        article-text-box  video-player  picture  article-body  \n",
       "83                   0.0           0.0     13.0           0.0  \n",
       "117                  0.0           0.0     12.0           0.0  \n",
       "1179                 0.0           0.0     13.0           0.0  \n",
       "1199                 0.0           0.0     13.0           0.0  \n",
       "1325                 0.0           0.0     13.0           0.0  \n",
       "2095                 0.0           0.0     13.0           0.0  \n",
       "2104                 0.0           0.0     13.0           0.0  \n",
       "2183                 0.0           0.0     13.0           0.0  \n",
       "2259                 0.0           0.0     13.0           0.0  \n",
       "2288                 0.0           0.0     13.0           0.0  \n",
       "2440                 0.0           0.0     12.0           0.0  \n",
       "3160                 0.0           0.0     13.0           0.0  \n",
       "3175                 0.0           0.0     13.0           0.0  \n",
       "3271                 0.0           0.0     13.0           0.0  \n",
       "4868                 0.0           0.0     13.0           0.0  \n",
       "5060                 0.0           1.0     13.0           0.0  \n",
       "5200                 0.0           0.0     13.0           0.0  \n",
       "5296                 0.0           0.0     11.0           0.0  \n",
       "5342                 0.0           0.0     13.0           0.0  \n",
       "5446                 0.0           0.0     13.0           0.0  \n",
       "6294                 0.0           0.0     13.0           0.0  \n",
       "6331                 0.0           0.0     13.0           0.0  \n",
       "6476                 0.0           0.0     13.0           0.0  \n",
       "6485                 0.0           0.0     13.0           0.0  \n",
       "6718                 0.0           0.0     12.0           0.0  \n",
       "6732                 0.0           0.0     13.0           0.0  \n",
       "6786                 0.0           0.0     13.0           0.0  \n",
       "6813                 0.0           0.0     13.0           0.0  \n",
       "6913                 0.0           0.0     12.0           0.0  \n",
       "6931                 0.0           0.0     13.0           0.0  \n",
       "...                  ...           ...      ...           ...  \n",
       "179789               0.0           0.0     13.0           0.0  \n",
       "179801               0.0           0.0     13.0           0.0  \n",
       "179810               0.0           0.0     13.0           0.0  \n",
       "179889               0.0           0.0     13.0           0.0  \n",
       "180117               0.0           0.0     13.0           0.0  \n",
       "180239               0.0           0.0     12.0           0.0  \n",
       "180396               0.0           0.0     12.0           0.0  \n",
       "180783               0.0           0.0     13.0           0.0  \n",
       "182190               0.0           0.0     13.0           0.0  \n",
       "182202               0.0           0.0     11.0           0.0  \n",
       "183384               0.0           0.0     13.0           0.0  \n",
       "183472               0.0           0.0     13.0           0.0  \n",
       "185134               0.0           0.0     13.0           0.0  \n",
       "185237               0.0           0.0     13.0           0.0  \n",
       "185605               0.0           0.0     11.0           0.0  \n",
       "186133               0.0           1.0     13.0           0.0  \n",
       "186135               0.0           1.0     12.0           0.0  \n",
       "186984               0.0           1.0     13.0           0.0  \n",
       "187068               0.0           0.0     13.0           0.0  \n",
       "187593               0.0           0.0     12.0           0.0  \n",
       "188004               0.0           0.0     13.0           0.0  \n",
       "189091               0.0           0.0     13.0           0.0  \n",
       "189543               0.0           0.0     13.0           0.0  \n",
       "189561               0.0           0.0     13.0           0.0  \n",
       "189693               0.0           0.0     13.0           0.0  \n",
       "189884               0.0           0.0     13.0           0.0  \n",
       "189949               0.0           0.0     13.0           0.0  \n",
       "191494               0.0           0.0     13.0           0.0  \n",
       "193053               0.0           0.0     13.0           0.0  \n",
       "194423               0.0           0.0     13.0           0.0  \n",
       "\n",
       "[1742 rows x 6 columns]"
      ]
     },
     "execution_count": 116,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfNoTextButSomeImages = dfMerged\n",
    "dfNoTextButSomeImages = dfNoTextButSomeImages[dfNoTextButSomeImages['article-text-box'] == 0]\n",
    "dfNoTextButSomeImages = dfNoTextButSomeImages[dfNoTextButSomeImages['article-body'] == 0]\n",
    "dfNoTextButSomeImages = dfNoTextButSomeImages[dfNoTextButSomeImages['picture'] > 10]\n",
    "dfNoTextButSomeImages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "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>ID_GA</th>\n",
       "      <th>Address</th>\n",
       "      <th>article-text-box</th>\n",
       "      <th>video-player</th>\n",
       "      <th>picture</th>\n",
       "      <th>article-body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5378225</td>\n",
       "      <td>https://www.blick.ch/people-tv/seth-rogen-wirb...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7252099</td>\n",
       "      <td>https://www.blick.ch/news/ausland/die-behoerde...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7277672</td>\n",
       "      <td>https://www.blick.ch/news/ausland/enzym-zerset...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7393854</td>\n",
       "      <td>https://www.blick.ch/news/ausland/kenia-hat-da...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>9005034</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/internatio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>8946692</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/internatio...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>7068779</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/best-o...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8958308</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/1-1-sieg-g...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>8945118</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nhl/1-sch...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>7074460</td>\n",
       "      <td>https://www.blick.ch/news/ausland/10-verletzte...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>6430402</td>\n",
       "      <td>https://www.blick.ch/sport/kampfsport/111-beto...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>8908548</td>\n",
       "      <td>https://www.blick.ch/news/politik/12-jahre-im-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>7027513</td>\n",
       "      <td>https://www.blick.ch/news/ausland/13-milliarde...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>8134329</td>\n",
       "      <td>https://www.blick.ch/news/ausland/136-kilo-dyn...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5527389</td>\n",
       "      <td>https://www.blick.ch/people-tv/14-baeder-dacht...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>8912285</td>\n",
       "      <td>https://www.blick.ch/people-tv/14-zurich-film-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5690702</td>\n",
       "      <td>https://www.blick.ch/news/150-meter-unter-der-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5747679</td>\n",
       "      <td>https://www.blick.ch/news/1500-meter-hohe-rauc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>7200267</td>\n",
       "      <td>https://www.blick.ch/news/ausland/16-menschen-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>8109963</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/16-prozent-w...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>8919216</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zuerich/17-j...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>8946765</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/highl...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>7294692</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/graubuenden/...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>9024168</td>\n",
       "      <td>https://www.blick.ch/incoming/2-digitaltag-bli...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>9023462</td>\n",
       "      <td>https://www.blick.ch/incoming/2-digitaltalk-bl...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>8101929</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/2-mio-kubikm...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>9007362</td>\n",
       "      <td>https://www.blick.ch/sport/us-highlights/2-poi...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>4882108</td>\n",
       "      <td>https://www.blick.ch/news/20-jaehrige-schwerve...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>8694378</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/20-todesopfe...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>7191285</td>\n",
       "      <td>https://www.blick.ch/news/ausland/kurios/200-b...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194619</th>\n",
       "      <td>4194249</td>\n",
       "      <td>https://www.blick.ch/life/ch_youtube_stars/you...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194620</th>\n",
       "      <td>4330461</td>\n",
       "      <td>https://www.blick.ch/news/yves-rossys-neuster-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194622</th>\n",
       "      <td>8209094</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zahlreiche-l...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194626</th>\n",
       "      <td>8903776</td>\n",
       "      <td>https://www.blick.ch/news/politik/zeichen-der-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194628</th>\n",
       "      <td>8764126</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/graubuenden/...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194631</th>\n",
       "      <td>5923363</td>\n",
       "      <td>https://www.blick.ch/video/viral/zoff-um-huege...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194632</th>\n",
       "      <td>8813470</td>\n",
       "      <td>https://www.blick.ch/news/zoo-zuerich-trauert-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194638</th>\n",
       "      <td>4619582</td>\n",
       "      <td>https://www.blick.ch/news/zu-enges-halsband-ti...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194639</th>\n",
       "      <td>6834789</td>\n",
       "      <td>https://www.blick.ch/sport/baseball/zu-frueh-g...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194641</th>\n",
       "      <td>8863221</td>\n",
       "      <td>https://www.blick.ch/news/zu-viel-drama-in-hur...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194642</th>\n",
       "      <td>8965761</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zuege-lahm-g...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194645</th>\n",
       "      <td>9069376</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194648</th>\n",
       "      <td>6713190</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zuerst-rammt...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194653</th>\n",
       "      <td>5379090</td>\n",
       "      <td>https://www.blick.ch/sport/zum-dritten-mal-100...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194654</th>\n",
       "      <td>8039185</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zum-glueck-i...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194655</th>\n",
       "      <td>5242714</td>\n",
       "      <td>https://www.blick.ch/news/zum-glueck-sitzen-ke...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194657</th>\n",
       "      <td>9015022</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zur-fahndung...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194658</th>\n",
       "      <td>6792263</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zur-rush-hou...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194659</th>\n",
       "      <td>8578972</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/zur-tat-reko...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194660</th>\n",
       "      <td>5794406</td>\n",
       "      <td>https://www.blick.ch/people-tv/zurueck-nach-ei...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194662</th>\n",
       "      <td>8211556</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-boeing-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194663</th>\n",
       "      <td>8533838</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-haben-s...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194666</th>\n",
       "      <td>8854431</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194667</th>\n",
       "      <td>8948051</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194668</th>\n",
       "      <td>8921450</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194669</th>\n",
       "      <td>8891656</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194671</th>\n",
       "      <td>9069060</td>\n",
       "      <td>https://www.blick.ch/sport/videoformate/dino/z...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194673</th>\n",
       "      <td>8621731</td>\n",
       "      <td>https://www.blick.ch/news/schweiz/bern/zwei-sc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194678</th>\n",
       "      <td>8157378</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zwei-tote-sc...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194685</th>\n",
       "      <td>8865362</td>\n",
       "      <td>https://www.blick.ch/news/ausland/zweisamkeit-...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29469 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                                            Address  \\\n",
       "0       5378225  https://www.blick.ch/people-tv/seth-rogen-wirb...   \n",
       "2       7252099  https://www.blick.ch/news/ausland/die-behoerde...   \n",
       "3       7277672  https://www.blick.ch/news/ausland/enzym-zerset...   \n",
       "4       7393854  https://www.blick.ch/news/ausland/kenia-hat-da...   \n",
       "10      9005034  https://www.blick.ch/sport/fussball/internatio...   \n",
       "11      8946692  https://www.blick.ch/sport/fussball/internatio...   \n",
       "12      7068779  https://www.blick.ch/sport/videoformate/best-o...   \n",
       "13      8958308  https://www.blick.ch/sport/fussball/1-1-sieg-g...   \n",
       "14      8945118  https://www.blick.ch/sport/eishockey/nhl/1-sch...   \n",
       "16      7074460  https://www.blick.ch/news/ausland/10-verletzte...   \n",
       "20      6430402  https://www.blick.ch/sport/kampfsport/111-beto...   \n",
       "24      8908548  https://www.blick.ch/news/politik/12-jahre-im-...   \n",
       "26      7027513  https://www.blick.ch/news/ausland/13-milliarde...   \n",
       "28      8134329  https://www.blick.ch/news/ausland/136-kilo-dyn...   \n",
       "29      5527389  https://www.blick.ch/people-tv/14-baeder-dacht...   \n",
       "31      8912285  https://www.blick.ch/people-tv/14-zurich-film-...   \n",
       "33      5690702  https://www.blick.ch/news/150-meter-unter-der-...   \n",
       "34      5747679  https://www.blick.ch/news/1500-meter-hohe-rauc...   \n",
       "36      7200267  https://www.blick.ch/news/ausland/16-menschen-...   \n",
       "37      8109963  https://www.blick.ch/news/schweiz/16-prozent-w...   \n",
       "39      8919216  https://www.blick.ch/news/schweiz/zuerich/17-j...   \n",
       "46      8946765  https://www.blick.ch/sport/eishockey/nla/highl...   \n",
       "47      7294692  https://www.blick.ch/news/schweiz/graubuenden/...   \n",
       "48      9024168  https://www.blick.ch/incoming/2-digitaltag-bli...   \n",
       "49      9023462  https://www.blick.ch/incoming/2-digitaltalk-bl...   \n",
       "50      8101929  https://www.blick.ch/news/schweiz/2-mio-kubikm...   \n",
       "51      9007362  https://www.blick.ch/sport/us-highlights/2-poi...   \n",
       "53      4882108  https://www.blick.ch/news/20-jaehrige-schwerve...   \n",
       "55      8694378  https://www.blick.ch/news/schweiz/20-todesopfe...   \n",
       "56      7191285  https://www.blick.ch/news/ausland/kurios/200-b...   \n",
       "...         ...                                                ...   \n",
       "194619  4194249  https://www.blick.ch/life/ch_youtube_stars/you...   \n",
       "194620  4330461  https://www.blick.ch/news/yves-rossys-neuster-...   \n",
       "194622  8209094  https://www.blick.ch/news/schweiz/zahlreiche-l...   \n",
       "194626  8903776  https://www.blick.ch/news/politik/zeichen-der-...   \n",
       "194628  8764126  https://www.blick.ch/news/schweiz/graubuenden/...   \n",
       "194631  5923363  https://www.blick.ch/video/viral/zoff-um-huege...   \n",
       "194632  8813470  https://www.blick.ch/news/zoo-zuerich-trauert-...   \n",
       "194638  4619582  https://www.blick.ch/news/zu-enges-halsband-ti...   \n",
       "194639  6834789  https://www.blick.ch/sport/baseball/zu-frueh-g...   \n",
       "194641  8863221  https://www.blick.ch/news/zu-viel-drama-in-hur...   \n",
       "194642  8965761  https://www.blick.ch/news/schweiz/zuege-lahm-g...   \n",
       "194645  9069376  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "194648  6713190  https://www.blick.ch/news/ausland/zuerst-rammt...   \n",
       "194653  5379090  https://www.blick.ch/sport/zum-dritten-mal-100...   \n",
       "194654  8039185  https://www.blick.ch/news/ausland/zum-glueck-i...   \n",
       "194655  5242714  https://www.blick.ch/news/zum-glueck-sitzen-ke...   \n",
       "194657  9015022  https://www.blick.ch/news/ausland/zur-fahndung...   \n",
       "194658  6792263  https://www.blick.ch/news/ausland/zur-rush-hou...   \n",
       "194659  8578972  https://www.blick.ch/news/schweiz/zur-tat-reko...   \n",
       "194660  5794406  https://www.blick.ch/people-tv/zurueck-nach-ei...   \n",
       "194662  8211556  https://www.blick.ch/news/ausland/zwei-boeing-...   \n",
       "194663  8533838  https://www.blick.ch/news/ausland/zwei-haben-s...   \n",
       "194666  8854431  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194667  8948051  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194668  8921450  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194669  8891656  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194671  9069060  https://www.blick.ch/sport/videoformate/dino/z...   \n",
       "194673  8621731  https://www.blick.ch/news/schweiz/bern/zwei-sc...   \n",
       "194678  8157378  https://www.blick.ch/news/ausland/zwei-tote-sc...   \n",
       "194685  8865362  https://www.blick.ch/news/ausland/zweisamkeit-...   \n",
       "\n",
       "        article-text-box  video-player  picture  article-body  \n",
       "0                    0.0           1.0      8.0           0.0  \n",
       "2                    0.0           1.0      8.0           0.0  \n",
       "3                    0.0           1.0      8.0           0.0  \n",
       "4                    0.0           1.0      8.0           0.0  \n",
       "10                   0.0           1.0      8.0           0.0  \n",
       "11                   0.0           1.0      8.0           0.0  \n",
       "12                   0.0           1.0      8.0           0.0  \n",
       "13                   0.0           1.0      8.0           0.0  \n",
       "14                   0.0           1.0      8.0           0.0  \n",
       "16                   0.0           1.0      8.0           0.0  \n",
       "20                   0.0           1.0      8.0           0.0  \n",
       "24                   0.0           1.0      8.0           0.0  \n",
       "26                   0.0           1.0      4.0           0.0  \n",
       "28                   0.0           1.0      8.0           0.0  \n",
       "29                   0.0           1.0      8.0           0.0  \n",
       "31                   0.0           1.0      8.0           0.0  \n",
       "33                   0.0           1.0      8.0           0.0  \n",
       "34                   0.0           1.0      8.0           0.0  \n",
       "36                   0.0           1.0      8.0           0.0  \n",
       "37                   0.0           1.0      8.0           0.0  \n",
       "39                   0.0           1.0      8.0           0.0  \n",
       "46                   0.0           1.0      8.0           0.0  \n",
       "47                   0.0           1.0      8.0           0.0  \n",
       "48                   0.0           1.0      8.0           0.0  \n",
       "49                   0.0           1.0      8.0           0.0  \n",
       "50                   0.0           1.0      8.0           0.0  \n",
       "51                   0.0           1.0      8.0           0.0  \n",
       "53                   0.0           1.0      8.0           0.0  \n",
       "55                   0.0           1.0      8.0           0.0  \n",
       "56                   0.0           1.0      8.0           0.0  \n",
       "...                  ...           ...      ...           ...  \n",
       "194619               0.0           1.0      8.0           0.0  \n",
       "194620               0.0           1.0      8.0           0.0  \n",
       "194622               0.0           1.0      8.0           0.0  \n",
       "194626               0.0           1.0      8.0           0.0  \n",
       "194628               0.0           1.0      8.0           0.0  \n",
       "194631               0.0           1.0      8.0           0.0  \n",
       "194632               0.0           1.0      8.0           0.0  \n",
       "194638               0.0           1.0      8.0           0.0  \n",
       "194639               0.0           1.0      8.0           0.0  \n",
       "194641               0.0           1.0      8.0           0.0  \n",
       "194642               0.0           1.0      8.0           0.0  \n",
       "194645               0.0           1.0      8.0           0.0  \n",
       "194648               0.0           1.0      8.0           0.0  \n",
       "194653               0.0           1.0      8.0           0.0  \n",
       "194654               0.0           1.0      8.0           0.0  \n",
       "194655               0.0           1.0      8.0           0.0  \n",
       "194657               0.0           1.0      8.0           0.0  \n",
       "194658               0.0           1.0      8.0           0.0  \n",
       "194659               0.0           1.0      8.0           0.0  \n",
       "194660               0.0           1.0      8.0           0.0  \n",
       "194662               0.0           1.0      8.0           0.0  \n",
       "194663               0.0           1.0      8.0           0.0  \n",
       "194666               0.0           1.0      4.0           0.0  \n",
       "194667               0.0           1.0      8.0           0.0  \n",
       "194668               0.0           1.0      8.0           0.0  \n",
       "194669               0.0           1.0      8.0           0.0  \n",
       "194671               0.0           1.0      8.0           0.0  \n",
       "194673               0.0           1.0      8.0           0.0  \n",
       "194678               0.0           1.0      8.0           0.0  \n",
       "194685               0.0           1.0      8.0           0.0  \n",
       "\n",
       "[29469 rows x 6 columns]"
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfNoText = dfMerged\n",
    "dfNoText = dfNoText[dfNoText['article-text-box'] == 0]\n",
    "dfNoText = dfNoText[dfNoText['article-body'] == 0]\n",
    "dfNoText"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "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>ID_GA</th>\n",
       "      <th>Address</th>\n",
       "      <th>article-text-box</th>\n",
       "      <th>video-player</th>\n",
       "      <th>picture</th>\n",
       "      <th>article-body</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>1660333</td>\n",
       "      <td>https://www.blick.ch/aktuell/das-war-der-chat-...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>1660346</td>\n",
       "      <td>https://www.blick.ch/aktuell/das-chat-protokol...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3648</th>\n",
       "      <td>2926517</td>\n",
       "      <td>https://www.blick.ch/auto/tests/chevrolet-corv...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5369</th>\n",
       "      <td>2143894</td>\n",
       "      <td>https://www.blick.ch/digital/die-welt-der-tech...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5463</th>\n",
       "      <td>3386849</td>\n",
       "      <td>https://www.blick.ch/digital/gadget-news-von-d...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5634</th>\n",
       "      <td>2643496</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5635</th>\n",
       "      <td>3710102</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5636</th>\n",
       "      <td>3368173</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5638</th>\n",
       "      <td>2691578</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5639</th>\n",
       "      <td>2615893</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5640</th>\n",
       "      <td>3450786</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5641</th>\n",
       "      <td>3286821</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5642</th>\n",
       "      <td>2657027</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5643</th>\n",
       "      <td>3460624</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5645</th>\n",
       "      <td>2772936</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5646</th>\n",
       "      <td>2668621</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5647</th>\n",
       "      <td>2634375</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5648</th>\n",
       "      <td>3030377</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5651</th>\n",
       "      <td>2664499</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5652</th>\n",
       "      <td>3650262</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5654</th>\n",
       "      <td>3303718</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5660</th>\n",
       "      <td>3332843</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5661</th>\n",
       "      <td>2676828</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5662</th>\n",
       "      <td>3469284</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5664</th>\n",
       "      <td>3210814</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5665</th>\n",
       "      <td>3445677</td>\n",
       "      <td>https://www.blick.ch/digital/games/game-gegen-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5744</th>\n",
       "      <td>2238286</td>\n",
       "      <td>https://www.blick.ch/digital/games/god-of-war-...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5858</th>\n",
       "      <td>6809441</td>\n",
       "      <td>https://www.blick.ch/digital/games/e3-steht-ku...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6440</th>\n",
       "      <td>3212647</td>\n",
       "      <td>https://www.blick.ch/digital/alternativen-zum-...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6830</th>\n",
       "      <td>4255292</td>\n",
       "      <td>https://www.blick.ch/digital/smartphone-kaputt...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155861</th>\n",
       "      <td>3569865</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/blick...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155862</th>\n",
       "      <td>3644152</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/blick...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155863</th>\n",
       "      <td>3601402</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/blick...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155917</th>\n",
       "      <td>1786311</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/blick...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157556</th>\n",
       "      <td>2058426</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/nla/letzt...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158368</th>\n",
       "      <td>1682132</td>\n",
       "      <td>https://www.blick.ch/sport/eishockey/spenglerc...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161611</th>\n",
       "      <td>1778873</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/championsl...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162663</th>\n",
       "      <td>2807809</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/cup/8-tite...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164234</th>\n",
       "      <td>2159246</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/fifa-ballo...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170409</th>\n",
       "      <td>1788630</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/nati/messi...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170530</th>\n",
       "      <td>3352116</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/nati/nach-...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171080</th>\n",
       "      <td>2900766</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/nati/rodri...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171873</th>\n",
       "      <td>1721620</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172430</th>\n",
       "      <td>1737072</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172487</th>\n",
       "      <td>1722049</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172898</th>\n",
       "      <td>1782551</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173216</th>\n",
       "      <td>1716028</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173220</th>\n",
       "      <td>1721387</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175208</th>\n",
       "      <td>1721700</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175634</th>\n",
       "      <td>1682159</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/superleagu...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176819</th>\n",
       "      <td>2564643</td>\n",
       "      <td>https://www.blick.ch/sport/fussball/wm/alle-st...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180252</th>\n",
       "      <td>2016889</td>\n",
       "      <td>https://www.blick.ch/sport/leichtathletik/gros...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180436</th>\n",
       "      <td>7126681</td>\n",
       "      <td>https://www.blick.ch/sport/leichtathletik/spru...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184763</th>\n",
       "      <td>4009885</td>\n",
       "      <td>https://www.blick.ch/sport/schwingen/schwinger...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184990</th>\n",
       "      <td>1772484</td>\n",
       "      <td>https://www.blick.ch/sport/ski/ab-10-00-uhr-li...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185589</th>\n",
       "      <td>1716022</td>\n",
       "      <td>https://www.blick.ch/sport/ski/benno-heer-und-...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186356</th>\n",
       "      <td>1743274</td>\n",
       "      <td>https://www.blick.ch/sport/ski/jetzt-im-ticker...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186566</th>\n",
       "      <td>2134239</td>\n",
       "      <td>https://www.blick.ch/sport/ski/riesenslalom-de...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189456</th>\n",
       "      <td>1763477</td>\n",
       "      <td>https://www.blick.ch/sport/tennis/jetzt-live-d...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192236</th>\n",
       "      <td>1678446</td>\n",
       "      <td>https://www.blick.ch/sport/wintersport/skispri...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>124 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID_GA                                            Address  \\\n",
       "227     1660333  https://www.blick.ch/aktuell/das-war-der-chat-...   \n",
       "352     1660346  https://www.blick.ch/aktuell/das-chat-protokol...   \n",
       "3648    2926517  https://www.blick.ch/auto/tests/chevrolet-corv...   \n",
       "5369    2143894  https://www.blick.ch/digital/die-welt-der-tech...   \n",
       "5463    3386849  https://www.blick.ch/digital/gadget-news-von-d...   \n",
       "5634    2643496  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5635    3710102  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5636    3368173  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5638    2691578  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5639    2615893  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5640    3450786  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5641    3286821  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5642    2657027  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5643    3460624  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5645    2772936  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5646    2668621  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5647    2634375  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5648    3030377  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5651    2664499  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5652    3650262  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5654    3303718  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5660    3332843  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5661    2676828  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5662    3469284  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5664    3210814  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5665    3445677  https://www.blick.ch/digital/games/game-gegen-...   \n",
       "5744    2238286  https://www.blick.ch/digital/games/god-of-war-...   \n",
       "5858    6809441  https://www.blick.ch/digital/games/e3-steht-ku...   \n",
       "6440    3212647  https://www.blick.ch/digital/alternativen-zum-...   \n",
       "6830    4255292  https://www.blick.ch/digital/smartphone-kaputt...   \n",
       "...         ...                                                ...   \n",
       "155861  3569865  https://www.blick.ch/sport/eishockey/nla/blick...   \n",
       "155862  3644152  https://www.blick.ch/sport/eishockey/nla/blick...   \n",
       "155863  3601402  https://www.blick.ch/sport/eishockey/nla/blick...   \n",
       "155917  1786311  https://www.blick.ch/sport/eishockey/nla/blick...   \n",
       "157556  2058426  https://www.blick.ch/sport/eishockey/nla/letzt...   \n",
       "158368  1682132  https://www.blick.ch/sport/eishockey/spenglerc...   \n",
       "161611  1778873  https://www.blick.ch/sport/fussball/championsl...   \n",
       "162663  2807809  https://www.blick.ch/sport/fussball/cup/8-tite...   \n",
       "164234  2159246  https://www.blick.ch/sport/fussball/fifa-ballo...   \n",
       "170409  1788630  https://www.blick.ch/sport/fussball/nati/messi...   \n",
       "170530  3352116  https://www.blick.ch/sport/fussball/nati/nach-...   \n",
       "171080  2900766  https://www.blick.ch/sport/fussball/nati/rodri...   \n",
       "171873  1721620  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "172430  1737072  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "172487  1722049  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "172898  1782551  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "173216  1716028  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "173220  1721387  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "175208  1721700  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "175634  1682159  https://www.blick.ch/sport/fussball/superleagu...   \n",
       "176819  2564643  https://www.blick.ch/sport/fussball/wm/alle-st...   \n",
       "180252  2016889  https://www.blick.ch/sport/leichtathletik/gros...   \n",
       "180436  7126681  https://www.blick.ch/sport/leichtathletik/spru...   \n",
       "184763  4009885  https://www.blick.ch/sport/schwingen/schwinger...   \n",
       "184990  1772484  https://www.blick.ch/sport/ski/ab-10-00-uhr-li...   \n",
       "185589  1716022  https://www.blick.ch/sport/ski/benno-heer-und-...   \n",
       "186356  1743274  https://www.blick.ch/sport/ski/jetzt-im-ticker...   \n",
       "186566  2134239  https://www.blick.ch/sport/ski/riesenslalom-de...   \n",
       "189456  1763477  https://www.blick.ch/sport/tennis/jetzt-live-d...   \n",
       "192236  1678446  https://www.blick.ch/sport/wintersport/skispri...   \n",
       "\n",
       "        article-text-box  video-player  picture  article-body  \n",
       "227                  1.0           0.0      9.0           0.0  \n",
       "352                  1.0           0.0      8.0           0.0  \n",
       "3648                 2.0           1.0     10.0           0.0  \n",
       "5369                 7.0           0.0     16.0           0.0  \n",
       "5463                 4.0           0.0     16.0           0.0  \n",
       "5634                 2.0           0.0     15.0           0.0  \n",
       "5635                 3.0           0.0     16.0           0.0  \n",
       "5636                 3.0           0.0     16.0           0.0  \n",
       "5638                 3.0           0.0     16.0           0.0  \n",
       "5639                 2.0           0.0     15.0           0.0  \n",
       "5640                 3.0           0.0     16.0           0.0  \n",
       "5641                 3.0           0.0     16.0           0.0  \n",
       "5642                 2.0           0.0     15.0           0.0  \n",
       "5643                 3.0           0.0     16.0           0.0  \n",
       "5645                 3.0           0.0     16.0           0.0  \n",
       "5646                 2.0           0.0     15.0           0.0  \n",
       "5647                 2.0           0.0     15.0           0.0  \n",
       "5648                 3.0           0.0     16.0           0.0  \n",
       "5651                 2.0           0.0     15.0           0.0  \n",
       "5652                 3.0           0.0     16.0           0.0  \n",
       "5654                 3.0           0.0     16.0           0.0  \n",
       "5660                 3.0           0.0     16.0           0.0  \n",
       "5661                 2.0           0.0     15.0           0.0  \n",
       "5662                 3.0           0.0     16.0           0.0  \n",
       "5664                 3.0           0.0     16.0           0.0  \n",
       "5665                 3.0           0.0     16.0           0.0  \n",
       "5744                 5.0           1.0     13.0           0.0  \n",
       "5858                 1.0           0.0      8.0           0.0  \n",
       "6440                 3.0           0.0      7.0           0.0  \n",
       "6830                 3.0           0.0     12.0           0.0  \n",
       "...                  ...           ...      ...           ...  \n",
       "155861               1.0           0.0      9.0           0.0  \n",
       "155862               1.0           0.0     10.0           0.0  \n",
       "155863               1.0           1.0      8.0           0.0  \n",
       "155917               4.0           0.0     12.0           0.0  \n",
       "157556               5.0           0.0     10.0           0.0  \n",
       "158368               1.0           0.0     13.0           0.0  \n",
       "161611               1.0           0.0     13.0           0.0  \n",
       "162663               1.0           0.0     13.0           0.0  \n",
       "164234               1.0           0.0      8.0           0.0  \n",
       "170409               1.0           0.0     13.0           0.0  \n",
       "170530               2.0           0.0     10.0           0.0  \n",
       "171080               9.0           0.0     21.0           0.0  \n",
       "171873               6.0           1.0     14.0           0.0  \n",
       "172430               1.0           0.0     14.0           0.0  \n",
       "172487               6.0           1.0     13.0           0.0  \n",
       "172898               1.0           0.0     10.0           0.0  \n",
       "173216               8.0           0.0     16.0           0.0  \n",
       "173220               6.0           1.0     14.0           0.0  \n",
       "175208               1.0           1.0      9.0           0.0  \n",
       "175634               1.0           1.0      8.0           0.0  \n",
       "176819               1.0           0.0     13.0           0.0  \n",
       "180252               1.0           0.0     13.0           0.0  \n",
       "180436               1.0           0.0      8.0           0.0  \n",
       "184763               6.0           0.0     16.0           0.0  \n",
       "184990               1.0           0.0      8.0           0.0  \n",
       "185589               1.0           1.0      9.0           0.0  \n",
       "186356               1.0           0.0     11.0           0.0  \n",
       "186566               1.0           0.0      9.0           0.0  \n",
       "189456               5.0           0.0     10.0           0.0  \n",
       "192236               5.0           0.0     10.0           0.0  \n",
       "\n",
       "[124 rows x 6 columns]"
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfNoTextButTextbox = dfMerged\n",
    "dfNoTextButTextbox = dfNoTextButTextbox[dfNoTextButTextbox['article-text-box'] != 0]\n",
    "dfNoTextButTextbox = dfNoTextButTextbox[dfNoTextButTextbox['article-body'] == 0]\n",
    "dfNoTextButTextbox"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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
}