notebooks/overview_project.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Projektstruktur\n",
    "\n",
    "Ausgehend von einem beliebigen Wurzelordner liegt dem Projekt folgende Ordnerstruktur zugrunde:\n",
    "\n",
    "- **master_cloud** [Sciebo-Ordner]\n",
    "  - ... externer Code, Tutorials etc.\n",
    "  - *corpora*\n",
    "    - ... diverse rohe Corpora\n",
    "    - hpc [backup der ETL und NLP Pipeline Resultate auf dem HPC]\n",
    "    - *preprocessed* [corpora nach ETL Pipeline]\n",
    "      - *nlp* [corpora nach NLP Pipeline]\n",
    "        - spacy_model\n",
    "          - vocab\n",
    "    - scrapy\n",
    "      - faz\n",
    "      - focus\n",
    "    + German_datasets.ods [s.u.]\n",
    "    \n",
    "- **topiclabeling**\n",
    "  - data\n",
    "    - feeds [Rohoutput der scrapy feeds]\n",
    "    + IWNLP.Lemmatizer_20170501.json\n",
    "  - logs\n",
    "  - *src* [Git Projektordner, Python code und Notebooks]\n",
    "    - scrapy [code]\n",
    "  + ToDo.txt\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from os import listdir\n",
    "from os.path import isfile, join\n",
    "\n",
    "from constants import DATA_BASE, ETL_PATH, NLP_PATH, HASH\n",
    "import pandas as pd\n",
    "import ezodf\n",
    "\n",
    "pd.set_option('display.precision',10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## German Corpora Overview\n",
    "\n",
    "Übersicht über deutschsprachige Corpora, die zur Verfügung stehen. Die ersten 6 fallen hierbei in die engere Wahl. Die gecrawlten News-Corpora von FAZ und Focus können auch als ein gemeinsamer Corpus betrachten werden, ebenso könnten auch weitere Newsseiten hinzugenommen werden. Das Parsing des Wikipedia-Corpus ist noch nicht abgeschlossen. Der dewac-Corpus ist aufgrund seiner Größe noch nicht vollständig durch die NLP-Pipeline gegangen."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style  type=\"text/css\" >\n",
       "    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col0 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col1 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col2 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col3 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col4 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col5 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col6 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col7 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col8 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col9 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col10 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col0 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col1 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col2 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col3 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col4 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col5 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col6 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col7 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col8 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col9 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col10 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col0 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col1 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col2 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col3 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col4 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col5 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col6 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col7 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col8 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col9 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col10 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col0 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col1 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col2 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col3 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col4 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col5 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col6 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col7 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col8 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col9 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col10 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col0 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col1 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col2 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col3 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col4 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col5 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col6 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col7 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col8 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col9 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col10 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col0 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col1 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col2 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col3 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col4 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col5 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col6 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col7 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col8 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col9 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col10 {\n",
       "            color:  #dd3355;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col0 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col1 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col2 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col3 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col4 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col5 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col6 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col7 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col8 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col9 {\n",
       "            color:  #cc2244;\n",
       "        }    #T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col10 {\n",
       "            color:  #cc2244;\n",
       "        }</style>  \n",
       "<table id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cf\" > \n",
       "<thead>    <tr> \n",
       "        <th class=\"blank level0\" ></th> \n",
       "        <th class=\"col_heading level0 col0\" >Category</th> \n",
       "        <th class=\"col_heading level0 col1\" >Name</th> \n",
       "        <th class=\"col_heading level0 col2\" >Date</th> \n",
       "        <th class=\"col_heading level0 col3\" >Content</th> \n",
       "        <th class=\"col_heading level0 col4\" >#documents</th> \n",
       "        <th class=\"col_heading level0 col5\" >#sentences</th> \n",
       "        <th class=\"col_heading level0 col6\" >#tokens</th> \n",
       "        <th class=\"col_heading level0 col7\" >Size\n",
       "(unzipped +\n",
       "unprocessed)</th> \n",
       "        <th class=\"col_heading level0 col8\" >Remarks</th> \n",
       "        <th class=\"col_heading level0 col9\" >Link</th> \n",
       "        <th class=\"col_heading level0 col10\" >Selected</th> \n",
       "    </tr></thead> \n",
       "<tbody>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row0\" class=\"row_heading level0 row0\" >0</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col0\" class=\"data row0 col0\" >Online-Partizipation</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col1\" class=\"data row0 col1\" >Online-Partizipation</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col2\" class=\"data row0 col2\" >2011-2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col3\" class=\"data row0 col3\" >Online-Partizipation</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col4\" class=\"data row0 col4\" >25981</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col5\" class=\"data row0 col5\" >143384</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col6\" class=\"data row0 col6\" >1751790</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col7\" class=\"data row0 col7\" >16M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col8\" class=\"data row0 col8\" >interessant</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col9\" class=\"data row0 col9\" >https://github.com/Liebeck/OnlineParticipationDatasets</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow0_col10\" class=\"data row0 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row1\" class=\"row_heading level0 row1\" >1</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col0\" class=\"data row1 col0\" >Politics</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col1\" class=\"data row1 col1\" >German political speeches</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col2\" class=\"data row1 col2\" >1984-2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col3\" class=\"data row1 col3\" >includes the four highest ranked functions on federal state level</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col4\" class=\"data row1 col4\" >6037</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col5\" class=\"data row1 col5\" >221397</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col6\" class=\"data row1 col6\" >4136463</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col7\" class=\"data row1 col7\" >73M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col8\" class=\"data row1 col8\" >interessant</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col9\" class=\"data row1 col9\" >https://hal.archives-ouvertes.fr/hal-01798703</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow1_col10\" class=\"data row1 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row2\" class=\"row_heading level0 row2\" >2</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col0\" class=\"data row2 col0\" >Politics</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col1\" class=\"data row2 col1\" >Europarl</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col2\" class=\"data row2 col2\" >1996-2011</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col3\" class=\"data row2 col3\" >parallel corpus extracted from the European Parliament web site</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col4\" class=\"data row2 col4\" >12788</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col5\" class=\"data row2 col5\" >2692391</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col6\" class=\"data row2 col6\" >56609511</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col7\" class=\"data row2 col7\" >~3.5G</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col8\" class=\"data row2 col8\" >interessant</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col9\" class=\"data row2 col9\" >http://opus.nlpl.eu/Europarl.php, http://www.statmt.org/europarl/</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow2_col10\" class=\"data row2 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row3\" class=\"row_heading level0 row3\" >3</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col0\" class=\"data row3 col0\" >News</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col1\" class=\"data row3 col1\" >faz.de</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col2\" class=\"data row3 col2\" >2006-2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col3\" class=\"data row3 col3\" >finanzen, feuilleton, gesellschaft, technik, politik, wirtschaft, wissen, reise, beruf</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col4\" class=\"data row3 col4\" >51385</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col5\" class=\"data row3 col5\" >1837668</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col6\" class=\"data row3 col6\" >29527792</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col7\" class=\"data row3 col7\" >201M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col8\" class=\"data row3 col8\" >crawled</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col9\" class=\"data row3 col9\" >http://www.faz.de</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow3_col10\" class=\"data row3 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row4\" class=\"row_heading level0 row4\" >4</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col0\" class=\"data row4 col0\" >News</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col1\" class=\"data row4 col1\" >focus.de</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col2\" class=\"data row4 col2\" >bis 2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col3\" class=\"data row4 col3\" >politik, finanzen, wissen, gesundheit, kultur, panorama, digital, reisen, auto, immobilien, regional</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col4\" class=\"data row4 col4\" >144127</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col5\" class=\"data row4 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col6\" class=\"data row4 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col7\" class=\"data row4 col7\" >190M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col8\" class=\"data row4 col8\" >crawled</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col9\" class=\"data row4 col9\" >http://www.focus.de</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow4_col10\" class=\"data row4 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row5\" class=\"row_heading level0 row5\" >5</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col0\" class=\"data row5 col0\" >Wikipedia</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col1\" class=\"data row5 col1\" >dewiki</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col2\" class=\"data row5 col2\" >bis 2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col3\" class=\"data row5 col3\" >German Wikipedia</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col4\" class=\"data row5 col4\" >3681494</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col5\" class=\"data row5 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col6\" class=\"data row5 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col7\" class=\"data row5 col7\" >19.7G</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col8\" class=\"data row5 col8\" >interessant</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col9\" class=\"data row5 col9\" >https://dumps.wikimedia.org/backup-index.html</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow5_col10\" class=\"data row5 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row6\" class=\"row_heading level0 row6\" >6</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col0\" class=\"data row6 col0\" >www</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col1\" class=\"data row6 col1\" >dewac_preproc</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col2\" class=\"data row6 col2\" >bis 2018</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col3\" class=\"data row6 col3\" >constructed from the Web limiting the crawl to the .de domain and using medium-frequency words from the SudDeutsche Zeitung corpus and basic German vocabulary lists as seeds</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col4\" class=\"data row6 col4\" >1751871</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col5\" class=\"data row6 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col6\" class=\"data row6 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col7\" class=\"data row6 col7\" >10.2G</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col8\" class=\"data row6 col8\" >interessant, aber wenige Metadaten</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col9\" class=\"data row6 col9\" >http://wacky.sslmit.unibo.it/doku.php?id=corpora#german</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow6_col10\" class=\"data row6 col10\" >True</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row7\" class=\"row_heading level0 row7\" >7</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col0\" class=\"data row7 col0\" >Div.</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col1\" class=\"data row7 col1\" >Wikisource</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col2\" class=\"data row7 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col3\" class=\"data row7 col3\" >Sammlung von Texten und Quellen, die entweder urheberrechtsfrei sind oder unter einer freien Lizenz stehen.</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col4\" class=\"data row7 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col5\" class=\"data row7 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col6\" class=\"data row7 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col7\" class=\"data row7 col7\" >1.9G</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col8\" class=\"data row7 col8\" >interessant, teilw. sprachlich veraltet, schwierig zu parsen (MediaWiki Markdown; enthält auch Meta Content)</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col9\" class=\"data row7 col9\" >https://de.wikisource.org/wiki/Hauptseite</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow7_col10\" class=\"data row7 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row8\" class=\"row_heading level0 row8\" >8</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col0\" class=\"data row8 col0\" >Div.</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col1\" class=\"data row8 col1\" >DEREKO / IDS Mannheim</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col2\" class=\"data row8 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col3\" class=\"data row8 col3\" >belletristische, wissenschaftliche und populärwissenschaftliche Texte, eine große Zahl von Zeitungstexten sowie eine breite Palette weiterer Textarten</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col4\" class=\"data row8 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col5\" class=\"data row8 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col6\" class=\"data row8 col6\" >42B</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col7\" class=\"data row8 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col8\" class=\"data row8 col8\" >nicht als Download verfügbar</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col9\" class=\"data row8 col9\" >http://www1.ids-mannheim.de/direktion/kl/projekte/korpora.html</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow8_col10\" class=\"data row8 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row9\" class=\"row_heading level0 row9\" >9</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col0\" class=\"data row9 col0\" >Div.</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col1\" class=\"data row9 col1\" >DWDS-Kernkorpus</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col2\" class=\"data row9 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col3\" class=\"data row9 col3\" >ein nach Textsorten und zeitlich über das gesamte Jahrhundert ausgewogenes Korpus</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col4\" class=\"data row9 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col5\" class=\"data row9 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col6\" class=\"data row9 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col7\" class=\"data row9 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col8\" class=\"data row9 col8\" >nicht als Download verfügbar</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col9\" class=\"data row9 col9\" >https://www.dwds.de/d/k-referenz/</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow9_col10\" class=\"data row9 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row10\" class=\"row_heading level0 row10\" >10</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col0\" class=\"data row10 col0\" >Literature</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col1\" class=\"data row10 col1\" >Wikibooks</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col2\" class=\"data row10 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col3\" class=\"data row10 col3\" >freie Bücher</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col4\" class=\"data row10 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col5\" class=\"data row10 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col6\" class=\"data row10 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col7\" class=\"data row10 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col8\" class=\"data row10 col8\" >interessant, teilw. sprachlich veraltet, schwierig zu parsen (MediaWiki Markdown; enthält auch Meta Content)</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col9\" class=\"data row10 col9\" >https://de.wikibooks.org/wiki/Hauptseite</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow10_col10\" class=\"data row10 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row11\" class=\"row_heading level0 row11\" >11</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col0\" class=\"data row11 col0\" >Literature</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col1\" class=\"data row11 col1\" >Project Gutenberg</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col2\" class=\"data row11 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col3\" class=\"data row11 col3\" >eBooks</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col4\" class=\"data row11 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col5\" class=\"data row11 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col6\" class=\"data row11 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col7\" class=\"data row11 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col8\" class=\"data row11 col8\" >German access blocked / copyright issures</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col9\" class=\"data row11 col9\" >http://www.gutenberg.org/wiki/Main_Page</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow11_col10\" class=\"data row11 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row12\" class=\"row_heading level0 row12\" >12</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col0\" class=\"data row12 col0\" >Literature</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col1\" class=\"data row12 col1\" >Projekt Gutenberg</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col2\" class=\"data row12 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col3\" class=\"data row12 col3\" >deutsches Sammlung urheberrechtsfreier Literatur</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col4\" class=\"data row12 col4\" >8000</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col5\" class=\"data row12 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col6\" class=\"data row12 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col7\" class=\"data row12 col7\" >8G</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col8\" class=\"data row12 col8\" >kein Download, USB-Stick Bestellung (39,90)</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col9\" class=\"data row12 col9\" >https://gutenberg.abc.de/edition/9-gutenberg-de-edition-14-usb-stick.html</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow12_col10\" class=\"data row12 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row13\" class=\"row_heading level0 row13\" >13</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col0\" class=\"data row13 col0\" >News</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col1\" class=\"data row13 col1\" >TIGER</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col2\" class=\"data row13 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col3\" class=\"data row13 col3\" >German newspaper text, taken from the Frankfurter Rundschau</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col4\" class=\"data row13 col4\" >2264</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col5\" class=\"data row13 col5\" >50K</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col6\" class=\"data row13 col6\" >0.9M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col7\" class=\"data row13 col7\" >60M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col8\" class=\"data row13 col8\" >interessant, etwas alt</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col9\" class=\"data row13 col9\" >http://www.ims.uni-stuttgart.de/forschung/ressourcen/korpora/tiger.html</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow13_col10\" class=\"data row13 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row14\" class=\"row_heading level0 row14\" >14</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col0\" class=\"data row14 col0\" >News</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col1\" class=\"data row14 col1\" >NEGRA</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col2\" class=\"data row14 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col3\" class=\"data row14 col3\" >Zeitungstexte aus der Frankfurter Rundschau</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col4\" class=\"data row14 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col5\" class=\"data row14 col5\" >20K</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col6\" class=\"data row14 col6\" >0.35M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col7\" class=\"data row14 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col8\" class=\"data row14 col8\" >postalische Registrierung, keine Vorteile gegenüber TIGER</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col9\" class=\"data row14 col9\" >http://www.coli.uni-saarland.de/projects/sfb378/negra-corpus/negra-corpus.html</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow14_col10\" class=\"data row14 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row15\" class=\"row_heading level0 row15\" >15</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col0\" class=\"data row15 col0\" >News / IT</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col1\" class=\"data row15 col1\" >Hamburg Dependency Treebank</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col2\" class=\"data row15 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col3\" class=\"data row15 col3\" >IT articles from heise.de (1996 and 2001)</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col4\" class=\"data row15 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col5\" class=\"data row15 col5\" >261K</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col6\" class=\"data row15 col6\" >4.8M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col7\" class=\"data row15 col7\" >290M</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col8\" class=\"data row15 col8\" >zu spezialisiert, Dokumente sind nicht getrennt</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col9\" class=\"data row15 col9\" >https://corpora.uni-hamburg.de/hzsk/de/islandora/object/treebank:hdt</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow15_col10\" class=\"data row15 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row16\" class=\"row_heading level0 row16\" >16</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col0\" class=\"data row16 col0\" >www</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col1\" class=\"data row16 col1\" >sdewac</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col2\" class=\"data row16 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col3\" class=\"data row16 col3\" >optimized/cleaned up deWaC</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col4\" class=\"data row16 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col5\" class=\"data row16 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col6\" class=\"data row16 col6\" >0.9B</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col7\" class=\"data row16 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col8\" class=\"data row16 col8\" >huge, Original-Dokumente nicht wiederherstellbar</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col9\" class=\"data row16 col9\" >http://wacky.sslmit.unibo.it/doku.php?id=corpora#german</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow16_col10\" class=\"data row16 col10\" >False</td> \n",
       "    </tr>    <tr> \n",
       "        <th id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cflevel0_row17\" class=\"row_heading level0 row17\" >17</th> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col0\" class=\"data row17 col0\" >www, News</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col1\" class=\"data row17 col1\" >Leipzig Corpora Collection</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col2\" class=\"data row17 col2\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col3\" class=\"data row17 col3\" >Die Korpora enthalten zufällig ausgewählte Sätze der jeweiligen Korpussprache</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col4\" class=\"data row17 col4\" >nan</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col5\" class=\"data row17 col5\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col6\" class=\"data row17 col6\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col7\" class=\"data row17 col7\" >None</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col8\" class=\"data row17 col8\" >Original-Dokumente nicht wiederherstellbar</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col9\" class=\"data row17 col9\" >http://wortschatz.uni-leipzig.de/de/download</td> \n",
       "        <td id=\"T_ee292fa2_b9fe_11e8_89b5_c86000dd86cfrow17_col10\" class=\"data row17 col10\" >False</td> \n",
       "    </tr></tbody> \n",
       "</table> "
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fd3e009deb8>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def read_ods(filename, sheet_no=0, header=0):\n",
    "    tab = ezodf.opendoc(filename=filename).sheets[sheet_no]\n",
    "    return pd.DataFrame({col[header].value:[x.value for x in col[header+1:]]\n",
    "                         for col in tab.columns()}).iloc[:,:-1].dropna(how='all')\n",
    "\n",
    "def highlight(s):\n",
    "    if s.Selected:\n",
    "        col = '#dd3355' if s.name%2 else '#cc2244'\n",
    "        return ['color: %s' % col]*len(s)\n",
    "    return ['']*len(s)\n",
    "\n",
    "df = read_ods(join(DATA_BASE, 'German_datasets.ods'))\n",
    "df.style.apply(highlight, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def read(f):\n",
    "     return pd.read_pickle(f)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Scrapy spiders\n",
    "\n",
    "Unter ```../../topiclabeling/src/scrapy``` sind derzeit zwei Spiders für die FAZ und den Focus lauffähig. Der Crawler lässt sich von dort aufrufen durch\n",
    "\n",
    "```scrapy crawl [-a categories=\"politik|kultur|panorama|digital\"] focus```\n",
    "\n",
    "Die Categories beziehen sich auf die möglichen Rubriken der jeweiligen News-Seite. Ohne ihre Angabe werden als Default-Kategorien Politik und Wirtschaft gecrawlt."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ETL Pipeline\n",
    "\n",
    "Die rohen Corpora wurden durch [ETL_pipeline.ipynb](ETL_pipeline.ipynb) geladen, wenn nötig geparst und in ein einheitliches Datenschema gebracht, wobei unter 'Load' hier das Speichern als pandas DataFrame im pickle-Format zu verstehen ist. Der Output der Pipeline befindet sich im Ordner ```../../master_cloud/corpora/preprocessed```."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "read(join(ETL_PATH, 'dewiki.pickle'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## NLP Pipeline\n",
    "\n",
    "Nachdem die Corpora in ein einheitliches Format gebracht wurden durchlaufen sie die Spacy Pipeline für das 'de' language model. s. [NLP_pipeline.ipynb](NLP_pipeline.ipynb)\n",
    "\n",
    "Die Tokenisierung ist nicht optimal und könnte durch Definition einiger Sonderfälle noch verbessert werden. Dies betrifft insbesondere den Forums-Corpus der Online-Partizipation. Hier macht es sich nachteilig bemerkbar, dass das Sprachmodell auf einem orthographisch korrekten Corpus trainiert wurde.\n",
    "\n",
    "Die Lemmatisierung wird durch IWNLP durchgeführt. Um einige merkwürdige Ergebnisse abzufangen, habe ich hier einen Wrapper herum gebaut, der bestimmte Sonderfälle abfängt, bzw. bestimmte Wortarten nicht durch IWNLP parsen lässt. Zusätzlich überprüfe ich Suffixe von zusammengesetzten Nomen auf Lemmata. Wo IWNLP keine Ergebnisse findet, wird die Lemmatisierung des Spacy Modells verwendet, ansonsten das ursprüngliche Token. Für IWNLP verwende ich die XML-Datenbank von 2017. Der Versuch, das aktuelle Wiktionary neu zu parsen, schlug nach wenigen Wörtern mit einer OutOfMemory Exception fehl (Build sowohl unter Mono als auch Visual Studio). Die Lemmatisierung ist noch anfällig für Fehler, insbesondere wenn das POS-Tagging nicht korrekt war. Named Entities sind ein Problem, wenn sie von Spacy nicht als solche erkannt wurden.\n",
    "\n",
    "Der Output der Pipeline befindet sich im Ordner ```../../master_cloud/corpora/preprocessed/nlp```. Das spacy vocabulary wird mit gespeichert."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "read(join(NLP_PATH, 'FAZ_nlp.pickle'))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Phrase detection\n",
    "\n",
    "Zu den Token des Corpus versuche ich Phrasen-Token zu generieren. Die Phrase-Detection von Gensim erwies sich dabei als eher problematisch. Die Ergebnisse sind zu willkürlich. Die Named Entities von Spacy liefern zu wenige Ergebnisse. Einigermaßen brauchbar (nach etwas Überarbeitung) sind Spacy's noun chunks. Interessant wäre hier ein Dictionary basierter Ansatz, z.B. auf Basis von Wikipedia-Titeln. Dies könnte aber rechenintensiv werden."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Topic Modeling\n",
    "\n",
    "Für das topic modeling werden nur die Tags NOUN, PROPN (Entities) und Phrasen verwendet. Zur Erstellung der Models wird Gensims LDAModel verwendet. Hier muss noch mit den Parametern experimentiert werden. Für das Topic Labeling wäre es wünschenswert möglichst exklusive Topics zu haben, d.h. mit hoher Wahrscheinlichkeitsmasse an den Rändern der Dirichlet-Verteilung, z.B. durch niedrige $\\alpha$-Werte. Hier besteht auf jeden Fall noch Experimentierbedarf.\n",
    "\n",
    "[Gensim_topic_modeling.ipynb](Gensim_topic_modeling.ipynb)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "-----\n",
    "\n",
    "### Appendix: Corpus metrics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = NLP_PATH\n",
    "\n",
    "files = sorted([f for f in listdir(path) if isfile(join(path, f))\n",
    "                # and f[:4] == 'dewa'\n",
    "                # and f[:4] == 'dewi'\n",
    "                # and f[:3] == 'Onl'\n",
    "                # and f[:3] == 'Eur'\n",
    "                # and f[:3] == 'FAZ'\n",
    "                # and f[:3] == 'FOC'\n",
    "                # and f[:3] == 'Pol'\n",
    "               ])\n",
    "\n",
    "dfs = [(name, read(join(path, name))) for name in files]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "overview_list = [(name, df.groupby(HASH).ngroups, df.groupby([HASH, 'sent_idx']).ngroups, df.shape[0]) \n",
    "                 for name, df in dfs]\n",
    "overview = pd.DataFrame(overview_list, columns=['dataset', '#documents', '#sentences', '#tokens'])\n",
    "overview"
   ]
  }
 ],
 "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}