Cleanup-Analytics.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 155,
   "metadata": {},
   "outputs": [],
   "source": [
    "#'.*id[1−5]?[0-9]{6}.htm'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "len(rows): 100000\n",
      "len(rows): 200000\n",
      "len(rows): 222989\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",
    "    columnHeader = response.get(\"reports\")[0].get('columnHeader', {})\n",
    "    dimensionHeaders = columnHeader.get('dimensions', [])\n",
    "    metricHeaders = columnHeader.get('metricHeader', {}).get('metricHeaderEntries', [])\n",
    "\n",
    "    pagetoken = response.get(\"reports\")[0].get('nextPageToken', None)\n",
    "    rowsNew = response.get(\"reports\")[0].get('data', {}).get('rows', [])\n",
    "    rows = rows + rowsNew\n",
    "    print(\"len(rows): \" + str(len(rows)))\n",
    "\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": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "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>dimensions</th>\n",
       "      <th>metrics</th>\n",
       "      <th>pagePath</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[/-id5378225.html]</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/-id5378225.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[/-id7091834.html]</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/-id7091834.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[/-id7252099.html]</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/-id7252099.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[/-id7277672.html]</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/-id7277672.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[/-id7393854.html]</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/-id7393854.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[/-id7987322.html]</td>\n",
       "      <td>[{'values': ['1', '1']}]</td>\n",
       "      <td>/-id7987322.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[/-id8943756.html]</td>\n",
       "      <td>[{'values': ['2', '2']}]</td>\n",
       "      <td>/-id8943756.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[/-id8943976.html]</td>\n",
       "      <td>[{'values': ['2', '2']}]</td>\n",
       "      <td>/-id8943976.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[/.../ein-callboy-packt-aus-id2153815.html]</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/.../ein-callboy-packt-aus-id2153815.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[/«Bachelorette»-Muskelprotz-mit-Sex-Beichte-S...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/«Bachelorette»-Muskelprotz-mit-Sex-Beichte-Sa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[/0-0-zwischen-augsburg-und-leipzig-video-schi...</td>\n",
       "      <td>[{'values': ['1', '2']}]</td>\n",
       "      <td>/0-0-zwischen-augsburg-und-leipzig-video-schir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[/0-1-niederlage-gegen-alaves-hier-kassiert-re...</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/0-1-niederlage-gegen-alaves-hier-kassiert-rea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[/0-4-pleite-im-video-gc-kriegt-von-yb-aufs-da...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/0-4-pleite-im-video-gc-kriegt-von-yb-aufs-dac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[/1-1-sieg-gegen-belgien-hier-knallt-reuteler-...</td>\n",
       "      <td>[{'values': ['5', '0']}]</td>\n",
       "      <td>/1-1-sieg-gegen-belgien-hier-knallt-reuteler-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[/1-schweizer-nhl-saison-tor-timo-meier-trifft...</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/1-schweizer-nhl-saison-tor-timo-meier-trifft-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[/10-vergleiche-autos-1968-und-2018-frueher-wa...</td>\n",
       "      <td>[{'values': ['1', '1']}]</td>\n",
       "      <td>/10-vergleiche-autos-1968-und-2018-frueher-war...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[/10-verletzte-nach-massenkarambolage-kranwage...</td>\n",
       "      <td>[{'values': ['5', '0']}]</td>\n",
       "      <td>/10-verletzte-nach-massenkarambolage-kranwagen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[/100-jaehriger-stellt-neuen-stundenweltrekord...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/100-jaehriger-stellt-neuen-stundenweltrekord-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[/100-jahre-tribelhorn-wasser-tragen-strom-fah...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/100-jahre-tribelhorn-wasser-tragen-strom-fahr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[/100000-menschen-auf-der-flucht-mount-agung-d...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/100000-menschen-auf-der-flucht-mount-agung-dr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>[/111-betonplatten-in-35-sekunden-bosnier-16-b...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/111-betonplatten-in-35-sekunden-bosnier-16-br...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>[/118-strafminuten-und-dramatische-wende-biel-...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/118-strafminuten-und-dramatische-wende-biel-h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>[/11880-franken-pro-quadratmeter-wohneigentum-...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/11880-franken-pro-quadratmeter-wohneigentum-i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>[/12-fragen-und-antworten-was-angehoerige-bei-...</td>\n",
       "      <td>[{'values': ['0', '1']}]</td>\n",
       "      <td>/12-fragen-und-antworten-was-angehoerige-bei-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>[/12-jahre-im-bundesrat-es-gibt-ein-leben-nach...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/12-jahre-im-bundesrat-es-gibt-ein-leben-nach-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>[/12-kranke-2-todesopfer-in-der-schweiz-ist-de...</td>\n",
       "      <td>[{'values': ['4', '1']}]</td>\n",
       "      <td>/12-kranke-2-todesopfer-in-der-schweiz-ist-der...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>[/13-milliarden-dollar-die-us-navy-besitzt-das...</td>\n",
       "      <td>[{'values': ['0', '1']}]</td>\n",
       "      <td>/13-milliarden-dollar-die-us-navy-besitzt-das-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>[/13-punkte-die-sie-ueber-den-ernaehrungstrend...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/13-punkte-die-sie-ueber-den-ernaehrungstrend-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>[/136-kilo-dynamit-bringen-wohnblock-zum-einst...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/136-kilo-dynamit-bringen-wohnblock-zum-einstu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>[/14-baeder-dachterrassen-pool-und-viel-kitsch...</td>\n",
       "      <td>[{'values': ['5', '0']}]</td>\n",
       "      <td>/14-baeder-dachterrassen-pool-und-viel-kitsch-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222959</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-die-gleichstellungs-d...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-die-gleichstellungs-de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222960</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-die-hcd-unordnung-ist...</td>\n",
       "      <td>[{'values': ['5', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-die-hcd-unordnung-ist-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222961</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-die-new-jersey-devils...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-die-new-jersey-devils-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222962</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-die-schiris-muessen-n...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-die-schiris-muessen-no...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222963</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-ich-lasse-mich-nicht-...</td>\n",
       "      <td>[{'values': ['0', '5']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-ich-lasse-mich-nicht-v...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222964</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-kommt-russland-konkur...</td>\n",
       "      <td>[{'values': ['3', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-kommt-russland-konkurr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222965</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-nehmen-wir-uns-die-de...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-nehmen-wir-uns-die-deu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222966</th>\n",
       "      <td>[/zwei-minuten-fuer-dino-vielleicht-muss-der-h...</td>\n",
       "      <td>[{'values': ['0', '11']}]</td>\n",
       "      <td>/zwei-minuten-fuer-dino-vielleicht-muss-der-hc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222967</th>\n",
       "      <td>[/zwei-opferstock-diebe-in-einer-woche-gestell...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zwei-opferstock-diebe-in-einer-woche-gestellt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222968</th>\n",
       "      <td>[/zwei-personen-ins-spital-gebracht-auto-faehr...</td>\n",
       "      <td>[{'values': ['0', '1']}]</td>\n",
       "      <td>/zwei-personen-ins-spital-gebracht-auto-faehrt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222969</th>\n",
       "      <td>[/zwei-personen-werden-in-truemmern-vermisst-f...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/zwei-personen-werden-in-truemmern-vermisst-fl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222970</th>\n",
       "      <td>[/zwei-schwerverletzte-bei-unfall-militaer-las...</td>\n",
       "      <td>[{'values': ['1', '1']}]</td>\n",
       "      <td>/zwei-schwerverletzte-bei-unfall-militaer-last...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222971</th>\n",
       "      <td>[/zwei-schwerverletzte-in-hessen-zug-knallt-in...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-schwerverletzte-in-hessen-zug-knallt-in-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222972</th>\n",
       "      <td>[/zwei-stars-schwach-nur-drei-gut-das-sind-die...</td>\n",
       "      <td>[{'values': ['1', '1']}]</td>\n",
       "      <td>/zwei-stars-schwach-nur-drei-gut-das-sind-die-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222973</th>\n",
       "      <td>[/zwei-start-up-gruenderinnen-im-interview-fra...</td>\n",
       "      <td>[{'values': ['2', '0']}]</td>\n",
       "      <td>/zwei-start-up-gruenderinnen-im-interview-frau...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222974</th>\n",
       "      <td>[/zwei-stunden-fuer-1500-meter-in-600-metern-h...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-stunden-fuer-1500-meter-in-600-metern-ho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222975</th>\n",
       "      <td>[/zwei-tote-nach-polizeieinsatz-in-deutschland...</td>\n",
       "      <td>[{'values': ['1', '1']}]</td>\n",
       "      <td>/zwei-tote-nach-polizeieinsatz-in-deutschland-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222976</th>\n",
       "      <td>[/zwei-tote-schuesse-und-geiselnahme-in-suedfr...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-tote-schuesse-und-geiselnahme-in-suedfra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222977</th>\n",
       "      <td>[/zwei-tote-und-zwei-schwerverletzte-bei-unfal...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zwei-tote-und-zwei-schwerverletzte-bei-unfall...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222978</th>\n",
       "      <td>[/zwei-verletzte-daecher-abgerissen-baeume-ent...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-verletzte-daecher-abgerissen-baeume-entw...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222979</th>\n",
       "      <td>[/zwei-verletzte-messer-angriff-im-sony-hauptq...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwei-verletzte-messer-angriff-im-sony-hauptqu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222980</th>\n",
       "      <td>[/zwei-verletzte-mussten-ins-spital-crash-im-m...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zwei-verletzte-mussten-ins-spital-crash-im-mo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222981</th>\n",
       "      <td>[/zwei-verletzte-nach-zickzack-fahrt-kroate-50...</td>\n",
       "      <td>[{'values': ['0', '1']}]</td>\n",
       "      <td>/zwei-verletzte-nach-zickzack-fahrt-kroate-50-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222982</th>\n",
       "      <td>[/zweifache-mutter-franziska-ueber-ihre-brust-...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zweifache-mutter-franziska-ueber-ihre-brust-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222983</th>\n",
       "      <td>[/zweimal-lugano-davos-innert-24-stunden-krise...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zweimal-lugano-davos-innert-24-stunden-krisen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222984</th>\n",
       "      <td>[/zweisamkeit-im-freien-in-dieser-stadt-ist-se...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zweisamkeit-im-freien-in-dieser-stadt-ist-sex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222985</th>\n",
       "      <td>[/zweite-cvp-frau-sagt-ja-elisabeth-schneider-...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zweite-cvp-frau-sagt-ja-elisabeth-schneider-s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222986</th>\n",
       "      <td>[/zweiter-halt-der-swiss-drone-league-das-droh...</td>\n",
       "      <td>[{'values': ['4', '0']}]</td>\n",
       "      <td>/zweiter-halt-der-swiss-drone-league-das-drohn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222987</th>\n",
       "      <td>[/zweites-buch-ueber-skilegende-bernhard-russi...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zweites-buch-ueber-skilegende-bernhard-russi-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222988</th>\n",
       "      <td>[/zwischenfall-am-flughafen-hamburg-jan-ullric...</td>\n",
       "      <td>[{'values': ['1', '0']}]</td>\n",
       "      <td>/zwischenfall-am-flughafen-hamburg-jan-ullrich...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>222989 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               dimensions  \\\n",
       "0                                      [/-id5378225.html]   \n",
       "1                                      [/-id7091834.html]   \n",
       "2                                      [/-id7252099.html]   \n",
       "3                                      [/-id7277672.html]   \n",
       "4                                      [/-id7393854.html]   \n",
       "5                                      [/-id7987322.html]   \n",
       "6                                      [/-id8943756.html]   \n",
       "7                                      [/-id8943976.html]   \n",
       "8             [/.../ein-callboy-packt-aus-id2153815.html]   \n",
       "9       [/«Bachelorette»-Muskelprotz-mit-Sex-Beichte-S...   \n",
       "10      [/0-0-zwischen-augsburg-und-leipzig-video-schi...   \n",
       "11      [/0-1-niederlage-gegen-alaves-hier-kassiert-re...   \n",
       "12      [/0-4-pleite-im-video-gc-kriegt-von-yb-aufs-da...   \n",
       "13      [/1-1-sieg-gegen-belgien-hier-knallt-reuteler-...   \n",
       "14      [/1-schweizer-nhl-saison-tor-timo-meier-trifft...   \n",
       "15      [/10-vergleiche-autos-1968-und-2018-frueher-wa...   \n",
       "16      [/10-verletzte-nach-massenkarambolage-kranwage...   \n",
       "17      [/100-jaehriger-stellt-neuen-stundenweltrekord...   \n",
       "18      [/100-jahre-tribelhorn-wasser-tragen-strom-fah...   \n",
       "19      [/100000-menschen-auf-der-flucht-mount-agung-d...   \n",
       "20      [/111-betonplatten-in-35-sekunden-bosnier-16-b...   \n",
       "21      [/118-strafminuten-und-dramatische-wende-biel-...   \n",
       "22      [/11880-franken-pro-quadratmeter-wohneigentum-...   \n",
       "23      [/12-fragen-und-antworten-was-angehoerige-bei-...   \n",
       "24      [/12-jahre-im-bundesrat-es-gibt-ein-leben-nach...   \n",
       "25      [/12-kranke-2-todesopfer-in-der-schweiz-ist-de...   \n",
       "26      [/13-milliarden-dollar-die-us-navy-besitzt-das...   \n",
       "27      [/13-punkte-die-sie-ueber-den-ernaehrungstrend...   \n",
       "28      [/136-kilo-dynamit-bringen-wohnblock-zum-einst...   \n",
       "29      [/14-baeder-dachterrassen-pool-und-viel-kitsch...   \n",
       "...                                                   ...   \n",
       "222959  [/zwei-minuten-fuer-dino-die-gleichstellungs-d...   \n",
       "222960  [/zwei-minuten-fuer-dino-die-hcd-unordnung-ist...   \n",
       "222961  [/zwei-minuten-fuer-dino-die-new-jersey-devils...   \n",
       "222962  [/zwei-minuten-fuer-dino-die-schiris-muessen-n...   \n",
       "222963  [/zwei-minuten-fuer-dino-ich-lasse-mich-nicht-...   \n",
       "222964  [/zwei-minuten-fuer-dino-kommt-russland-konkur...   \n",
       "222965  [/zwei-minuten-fuer-dino-nehmen-wir-uns-die-de...   \n",
       "222966  [/zwei-minuten-fuer-dino-vielleicht-muss-der-h...   \n",
       "222967  [/zwei-opferstock-diebe-in-einer-woche-gestell...   \n",
       "222968  [/zwei-personen-ins-spital-gebracht-auto-faehr...   \n",
       "222969  [/zwei-personen-werden-in-truemmern-vermisst-f...   \n",
       "222970  [/zwei-schwerverletzte-bei-unfall-militaer-las...   \n",
       "222971  [/zwei-schwerverletzte-in-hessen-zug-knallt-in...   \n",
       "222972  [/zwei-stars-schwach-nur-drei-gut-das-sind-die...   \n",
       "222973  [/zwei-start-up-gruenderinnen-im-interview-fra...   \n",
       "222974  [/zwei-stunden-fuer-1500-meter-in-600-metern-h...   \n",
       "222975  [/zwei-tote-nach-polizeieinsatz-in-deutschland...   \n",
       "222976  [/zwei-tote-schuesse-und-geiselnahme-in-suedfr...   \n",
       "222977  [/zwei-tote-und-zwei-schwerverletzte-bei-unfal...   \n",
       "222978  [/zwei-verletzte-daecher-abgerissen-baeume-ent...   \n",
       "222979  [/zwei-verletzte-messer-angriff-im-sony-hauptq...   \n",
       "222980  [/zwei-verletzte-mussten-ins-spital-crash-im-m...   \n",
       "222981  [/zwei-verletzte-nach-zickzack-fahrt-kroate-50...   \n",
       "222982  [/zweifache-mutter-franziska-ueber-ihre-brust-...   \n",
       "222983  [/zweimal-lugano-davos-innert-24-stunden-krise...   \n",
       "222984  [/zweisamkeit-im-freien-in-dieser-stadt-ist-se...   \n",
       "222985  [/zweite-cvp-frau-sagt-ja-elisabeth-schneider-...   \n",
       "222986  [/zweiter-halt-der-swiss-drone-league-das-droh...   \n",
       "222987  [/zweites-buch-ueber-skilegende-bernhard-russi...   \n",
       "222988  [/zwischenfall-am-flughafen-hamburg-jan-ullric...   \n",
       "\n",
       "                          metrics  \\\n",
       "0        [{'values': ['1', '0']}]   \n",
       "1        [{'values': ['3', '0']}]   \n",
       "2        [{'values': ['3', '0']}]   \n",
       "3        [{'values': ['3', '0']}]   \n",
       "4        [{'values': ['3', '0']}]   \n",
       "5        [{'values': ['1', '1']}]   \n",
       "6        [{'values': ['2', '2']}]   \n",
       "7        [{'values': ['2', '2']}]   \n",
       "8        [{'values': ['1', '0']}]   \n",
       "9        [{'values': ['2', '0']}]   \n",
       "10       [{'values': ['1', '2']}]   \n",
       "11       [{'values': ['3', '0']}]   \n",
       "12       [{'values': ['1', '0']}]   \n",
       "13       [{'values': ['5', '0']}]   \n",
       "14       [{'values': ['3', '0']}]   \n",
       "15       [{'values': ['1', '1']}]   \n",
       "16       [{'values': ['5', '0']}]   \n",
       "17       [{'values': ['1', '0']}]   \n",
       "18       [{'values': ['1', '0']}]   \n",
       "19       [{'values': ['1', '0']}]   \n",
       "20       [{'values': ['2', '0']}]   \n",
       "21       [{'values': ['4', '0']}]   \n",
       "22       [{'values': ['1', '0']}]   \n",
       "23       [{'values': ['0', '1']}]   \n",
       "24       [{'values': ['1', '0']}]   \n",
       "25       [{'values': ['4', '1']}]   \n",
       "26       [{'values': ['0', '1']}]   \n",
       "27       [{'values': ['1', '0']}]   \n",
       "28       [{'values': ['1', '0']}]   \n",
       "29       [{'values': ['5', '0']}]   \n",
       "...                           ...   \n",
       "222959   [{'values': ['2', '0']}]   \n",
       "222960   [{'values': ['5', '0']}]   \n",
       "222961   [{'values': ['4', '0']}]   \n",
       "222962   [{'values': ['1', '0']}]   \n",
       "222963   [{'values': ['0', '5']}]   \n",
       "222964   [{'values': ['3', '0']}]   \n",
       "222965   [{'values': ['2', '0']}]   \n",
       "222966  [{'values': ['0', '11']}]   \n",
       "222967   [{'values': ['4', '0']}]   \n",
       "222968   [{'values': ['0', '1']}]   \n",
       "222969   [{'values': ['2', '0']}]   \n",
       "222970   [{'values': ['1', '1']}]   \n",
       "222971   [{'values': ['1', '0']}]   \n",
       "222972   [{'values': ['1', '1']}]   \n",
       "222973   [{'values': ['2', '0']}]   \n",
       "222974   [{'values': ['1', '0']}]   \n",
       "222975   [{'values': ['1', '1']}]   \n",
       "222976   [{'values': ['1', '0']}]   \n",
       "222977   [{'values': ['4', '0']}]   \n",
       "222978   [{'values': ['1', '0']}]   \n",
       "222979   [{'values': ['1', '0']}]   \n",
       "222980   [{'values': ['4', '0']}]   \n",
       "222981   [{'values': ['0', '1']}]   \n",
       "222982   [{'values': ['1', '0']}]   \n",
       "222983   [{'values': ['1', '0']}]   \n",
       "222984   [{'values': ['1', '0']}]   \n",
       "222985   [{'values': ['4', '0']}]   \n",
       "222986   [{'values': ['4', '0']}]   \n",
       "222987   [{'values': ['1', '0']}]   \n",
       "222988   [{'values': ['1', '0']}]   \n",
       "\n",
       "                                                 pagePath  \n",
       "0                                        /-id5378225.html  \n",
       "1                                        /-id7091834.html  \n",
       "2                                        /-id7252099.html  \n",
       "3                                        /-id7277672.html  \n",
       "4                                        /-id7393854.html  \n",
       "5                                        /-id7987322.html  \n",
       "6                                        /-id8943756.html  \n",
       "7                                        /-id8943976.html  \n",
       "8               /.../ein-callboy-packt-aus-id2153815.html  \n",
       "9       /«Bachelorette»-Muskelprotz-mit-Sex-Beichte-Sa...  \n",
       "10      /0-0-zwischen-augsburg-und-leipzig-video-schir...  \n",
       "11      /0-1-niederlage-gegen-alaves-hier-kassiert-rea...  \n",
       "12      /0-4-pleite-im-video-gc-kriegt-von-yb-aufs-dac...  \n",
       "13      /1-1-sieg-gegen-belgien-hier-knallt-reuteler-d...  \n",
       "14      /1-schweizer-nhl-saison-tor-timo-meier-trifft-...  \n",
       "15      /10-vergleiche-autos-1968-und-2018-frueher-war...  \n",
       "16      /10-verletzte-nach-massenkarambolage-kranwagen...  \n",
       "17      /100-jaehriger-stellt-neuen-stundenweltrekord-...  \n",
       "18      /100-jahre-tribelhorn-wasser-tragen-strom-fahr...  \n",
       "19      /100000-menschen-auf-der-flucht-mount-agung-dr...  \n",
       "20      /111-betonplatten-in-35-sekunden-bosnier-16-br...  \n",
       "21      /118-strafminuten-und-dramatische-wende-biel-h...  \n",
       "22      /11880-franken-pro-quadratmeter-wohneigentum-i...  \n",
       "23      /12-fragen-und-antworten-was-angehoerige-bei-d...  \n",
       "24      /12-jahre-im-bundesrat-es-gibt-ein-leben-nach-...  \n",
       "25      /12-kranke-2-todesopfer-in-der-schweiz-ist-der...  \n",
       "26      /13-milliarden-dollar-die-us-navy-besitzt-das-...  \n",
       "27      /13-punkte-die-sie-ueber-den-ernaehrungstrend-...  \n",
       "28      /136-kilo-dynamit-bringen-wohnblock-zum-einstu...  \n",
       "29      /14-baeder-dachterrassen-pool-und-viel-kitsch-...  \n",
       "...                                                   ...  \n",
       "222959  /zwei-minuten-fuer-dino-die-gleichstellungs-de...  \n",
       "222960  /zwei-minuten-fuer-dino-die-hcd-unordnung-ist-...  \n",
       "222961  /zwei-minuten-fuer-dino-die-new-jersey-devils-...  \n",
       "222962  /zwei-minuten-fuer-dino-die-schiris-muessen-no...  \n",
       "222963  /zwei-minuten-fuer-dino-ich-lasse-mich-nicht-v...  \n",
       "222964  /zwei-minuten-fuer-dino-kommt-russland-konkurr...  \n",
       "222965  /zwei-minuten-fuer-dino-nehmen-wir-uns-die-deu...  \n",
       "222966  /zwei-minuten-fuer-dino-vielleicht-muss-der-hc...  \n",
       "222967  /zwei-opferstock-diebe-in-einer-woche-gestellt...  \n",
       "222968  /zwei-personen-ins-spital-gebracht-auto-faehrt...  \n",
       "222969  /zwei-personen-werden-in-truemmern-vermisst-fl...  \n",
       "222970  /zwei-schwerverletzte-bei-unfall-militaer-last...  \n",
       "222971  /zwei-schwerverletzte-in-hessen-zug-knallt-in-...  \n",
       "222972  /zwei-stars-schwach-nur-drei-gut-das-sind-die-...  \n",
       "222973  /zwei-start-up-gruenderinnen-im-interview-frau...  \n",
       "222974  /zwei-stunden-fuer-1500-meter-in-600-metern-ho...  \n",
       "222975  /zwei-tote-nach-polizeieinsatz-in-deutschland-...  \n",
       "222976  /zwei-tote-schuesse-und-geiselnahme-in-suedfra...  \n",
       "222977  /zwei-tote-und-zwei-schwerverletzte-bei-unfall...  \n",
       "222978  /zwei-verletzte-daecher-abgerissen-baeume-entw...  \n",
       "222979  /zwei-verletzte-messer-angriff-im-sony-hauptqu...  \n",
       "222980  /zwei-verletzte-mussten-ins-spital-crash-im-mo...  \n",
       "222981  /zwei-verletzte-nach-zickzack-fahrt-kroate-50-...  \n",
       "222982  /zweifache-mutter-franziska-ueber-ihre-brust-o...  \n",
       "222983  /zweimal-lugano-davos-innert-24-stunden-krisen...  \n",
       "222984  /zweisamkeit-im-freien-in-dieser-stadt-ist-sex...  \n",
       "222985  /zweite-cvp-frau-sagt-ja-elisabeth-schneider-s...  \n",
       "222986  /zweiter-halt-der-swiss-drone-league-das-drohn...  \n",
       "222987  /zweites-buch-ueber-skilegende-bernhard-russi-...  \n",
       "222988  /zwischenfall-am-flughafen-hamburg-jan-ullrich...  \n",
       "\n",
       "[222989 rows x 3 columns]"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tags = dfanalytics['dimensions'].apply(pd.Series)\n",
    "tags = tags.rename(columns = lambda x : 'pagePath')\n",
    "dfanalytics = pd.concat([dfanalytics[:], tags[:]], axis=1)  \n",
    "dfanalytics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfanalytics = dfanalytics.drop(\"dimensions\",1)\n",
    "dfanalytics = dfanalytics.drop(\"metrics\",1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "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>pagePath</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>/-id5378225.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>/-id7091834.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>/-id7252099.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>/-id7277672.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>/-id7393854.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>/-id7987322.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>/-id8943756.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>/-id8943976.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>/.../ein-callboy-packt-aus-id2153815.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>/«Bachelorette»-Muskelprotz-mit-Sex-Beichte-Sa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>/0-0-zwischen-augsburg-und-leipzig-video-schir...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>/0-1-niederlage-gegen-alaves-hier-kassiert-rea...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>/0-4-pleite-im-video-gc-kriegt-von-yb-aufs-dac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>/1-1-sieg-gegen-belgien-hier-knallt-reuteler-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>/1-schweizer-nhl-saison-tor-timo-meier-trifft-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>/10-vergleiche-autos-1968-und-2018-frueher-war...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>/10-verletzte-nach-massenkarambolage-kranwagen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>/100-jaehriger-stellt-neuen-stundenweltrekord-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>/100-jahre-tribelhorn-wasser-tragen-strom-fahr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>/100000-menschen-auf-der-flucht-mount-agung-dr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>/111-betonplatten-in-35-sekunden-bosnier-16-br...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>/118-strafminuten-und-dramatische-wende-biel-h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>/11880-franken-pro-quadratmeter-wohneigentum-i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>/12-fragen-und-antworten-was-angehoerige-bei-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>/12-jahre-im-bundesrat-es-gibt-ein-leben-nach-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>/12-kranke-2-todesopfer-in-der-schweiz-ist-der...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>/13-milliarden-dollar-die-us-navy-besitzt-das-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>/13-punkte-die-sie-ueber-den-ernaehrungstrend-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>/136-kilo-dynamit-bringen-wohnblock-zum-einstu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>/14-baeder-dachterrassen-pool-und-viel-kitsch-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222959</th>\n",
       "      <td>/zwei-minuten-fuer-dino-die-gleichstellungs-de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222960</th>\n",
       "      <td>/zwei-minuten-fuer-dino-die-hcd-unordnung-ist-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222961</th>\n",
       "      <td>/zwei-minuten-fuer-dino-die-new-jersey-devils-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222962</th>\n",
       "      <td>/zwei-minuten-fuer-dino-die-schiris-muessen-no...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222963</th>\n",
       "      <td>/zwei-minuten-fuer-dino-ich-lasse-mich-nicht-v...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222964</th>\n",
       "      <td>/zwei-minuten-fuer-dino-kommt-russland-konkurr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222965</th>\n",
       "      <td>/zwei-minuten-fuer-dino-nehmen-wir-uns-die-deu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222966</th>\n",
       "      <td>/zwei-minuten-fuer-dino-vielleicht-muss-der-hc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222967</th>\n",
       "      <td>/zwei-opferstock-diebe-in-einer-woche-gestellt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222968</th>\n",
       "      <td>/zwei-personen-ins-spital-gebracht-auto-faehrt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222969</th>\n",
       "      <td>/zwei-personen-werden-in-truemmern-vermisst-fl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222970</th>\n",
       "      <td>/zwei-schwerverletzte-bei-unfall-militaer-last...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222971</th>\n",
       "      <td>/zwei-schwerverletzte-in-hessen-zug-knallt-in-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222972</th>\n",
       "      <td>/zwei-stars-schwach-nur-drei-gut-das-sind-die-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222973</th>\n",
       "      <td>/zwei-start-up-gruenderinnen-im-interview-frau...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222974</th>\n",
       "      <td>/zwei-stunden-fuer-1500-meter-in-600-metern-ho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222975</th>\n",
       "      <td>/zwei-tote-nach-polizeieinsatz-in-deutschland-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222976</th>\n",
       "      <td>/zwei-tote-schuesse-und-geiselnahme-in-suedfra...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222977</th>\n",
       "      <td>/zwei-tote-und-zwei-schwerverletzte-bei-unfall...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222978</th>\n",
       "      <td>/zwei-verletzte-daecher-abgerissen-baeume-entw...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222979</th>\n",
       "      <td>/zwei-verletzte-messer-angriff-im-sony-hauptqu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222980</th>\n",
       "      <td>/zwei-verletzte-mussten-ins-spital-crash-im-mo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222981</th>\n",
       "      <td>/zwei-verletzte-nach-zickzack-fahrt-kroate-50-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222982</th>\n",
       "      <td>/zweifache-mutter-franziska-ueber-ihre-brust-o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222983</th>\n",
       "      <td>/zweimal-lugano-davos-innert-24-stunden-krisen...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222984</th>\n",
       "      <td>/zweisamkeit-im-freien-in-dieser-stadt-ist-sex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222985</th>\n",
       "      <td>/zweite-cvp-frau-sagt-ja-elisabeth-schneider-s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222986</th>\n",
       "      <td>/zweiter-halt-der-swiss-drone-league-das-drohn...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222987</th>\n",
       "      <td>/zweites-buch-ueber-skilegende-bernhard-russi-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222988</th>\n",
       "      <td>/zwischenfall-am-flughafen-hamburg-jan-ullrich...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>222989 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 pagePath\n",
       "0                                        /-id5378225.html\n",
       "1                                        /-id7091834.html\n",
       "2                                        /-id7252099.html\n",
       "3                                        /-id7277672.html\n",
       "4                                        /-id7393854.html\n",
       "5                                        /-id7987322.html\n",
       "6                                        /-id8943756.html\n",
       "7                                        /-id8943976.html\n",
       "8               /.../ein-callboy-packt-aus-id2153815.html\n",
       "9       /«Bachelorette»-Muskelprotz-mit-Sex-Beichte-Sa...\n",
       "10      /0-0-zwischen-augsburg-und-leipzig-video-schir...\n",
       "11      /0-1-niederlage-gegen-alaves-hier-kassiert-rea...\n",
       "12      /0-4-pleite-im-video-gc-kriegt-von-yb-aufs-dac...\n",
       "13      /1-1-sieg-gegen-belgien-hier-knallt-reuteler-d...\n",
       "14      /1-schweizer-nhl-saison-tor-timo-meier-trifft-...\n",
       "15      /10-vergleiche-autos-1968-und-2018-frueher-war...\n",
       "16      /10-verletzte-nach-massenkarambolage-kranwagen...\n",
       "17      /100-jaehriger-stellt-neuen-stundenweltrekord-...\n",
       "18      /100-jahre-tribelhorn-wasser-tragen-strom-fahr...\n",
       "19      /100000-menschen-auf-der-flucht-mount-agung-dr...\n",
       "20      /111-betonplatten-in-35-sekunden-bosnier-16-br...\n",
       "21      /118-strafminuten-und-dramatische-wende-biel-h...\n",
       "22      /11880-franken-pro-quadratmeter-wohneigentum-i...\n",
       "23      /12-fragen-und-antworten-was-angehoerige-bei-d...\n",
       "24      /12-jahre-im-bundesrat-es-gibt-ein-leben-nach-...\n",
       "25      /12-kranke-2-todesopfer-in-der-schweiz-ist-der...\n",
       "26      /13-milliarden-dollar-die-us-navy-besitzt-das-...\n",
       "27      /13-punkte-die-sie-ueber-den-ernaehrungstrend-...\n",
       "28      /136-kilo-dynamit-bringen-wohnblock-zum-einstu...\n",
       "29      /14-baeder-dachterrassen-pool-und-viel-kitsch-...\n",
       "...                                                   ...\n",
       "222959  /zwei-minuten-fuer-dino-die-gleichstellungs-de...\n",
       "222960  /zwei-minuten-fuer-dino-die-hcd-unordnung-ist-...\n",
       "222961  /zwei-minuten-fuer-dino-die-new-jersey-devils-...\n",
       "222962  /zwei-minuten-fuer-dino-die-schiris-muessen-no...\n",
       "222963  /zwei-minuten-fuer-dino-ich-lasse-mich-nicht-v...\n",
       "222964  /zwei-minuten-fuer-dino-kommt-russland-konkurr...\n",
       "222965  /zwei-minuten-fuer-dino-nehmen-wir-uns-die-deu...\n",
       "222966  /zwei-minuten-fuer-dino-vielleicht-muss-der-hc...\n",
       "222967  /zwei-opferstock-diebe-in-einer-woche-gestellt...\n",
       "222968  /zwei-personen-ins-spital-gebracht-auto-faehrt...\n",
       "222969  /zwei-personen-werden-in-truemmern-vermisst-fl...\n",
       "222970  /zwei-schwerverletzte-bei-unfall-militaer-last...\n",
       "222971  /zwei-schwerverletzte-in-hessen-zug-knallt-in-...\n",
       "222972  /zwei-stars-schwach-nur-drei-gut-das-sind-die-...\n",
       "222973  /zwei-start-up-gruenderinnen-im-interview-frau...\n",
       "222974  /zwei-stunden-fuer-1500-meter-in-600-metern-ho...\n",
       "222975  /zwei-tote-nach-polizeieinsatz-in-deutschland-...\n",
       "222976  /zwei-tote-schuesse-und-geiselnahme-in-suedfra...\n",
       "222977  /zwei-tote-und-zwei-schwerverletzte-bei-unfall...\n",
       "222978  /zwei-verletzte-daecher-abgerissen-baeume-entw...\n",
       "222979  /zwei-verletzte-messer-angriff-im-sony-hauptqu...\n",
       "222980  /zwei-verletzte-mussten-ins-spital-crash-im-mo...\n",
       "222981  /zwei-verletzte-nach-zickzack-fahrt-kroate-50-...\n",
       "222982  /zweifache-mutter-franziska-ueber-ihre-brust-o...\n",
       "222983  /zweimal-lugano-davos-innert-24-stunden-krisen...\n",
       "222984  /zweisamkeit-im-freien-in-dieser-stadt-ist-sex...\n",
       "222985  /zweite-cvp-frau-sagt-ja-elisabeth-schneider-s...\n",
       "222986  /zweiter-halt-der-swiss-drone-league-das-drohn...\n",
       "222987  /zweites-buch-ueber-skilegende-bernhard-russi-...\n",
       "222988  /zwischenfall-am-flughafen-hamburg-jan-ullrich...\n",
       "\n",
       "[222989 rows x 1 columns]"
      ]
     },
     "execution_count": 160,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfanalytics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 161,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfanalytics.to_csv('gaapi.csv', sep='\\t')\n"
   ]
  },
  {
   "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": {
    "scrolled": false
   },
   "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": []
  },
  {
   "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
}