_doc/notebooks/simple_processing.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "# Pr\u00e9traitement des logs\n",
        "\n",
        "Traitements de logs g\u00e9n\u00e9r\u00e9s par un QCM."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/html": [
              "<div id=\"my_id_menu_nb\">run previous cell, wait for 2 seconds</div>\n",
              "<script>\n",
              "function repeat_indent_string(n){\n",
              "    var a = \"\" ;\n",
              "    for ( ; n > 0 ; --n)\n",
              "        a += \"    \";\n",
              "    return a;\n",
              "}\n",
              "// look up into all sections and builds an automated menu //\n",
              "var update_menu_string = function(begin, lfirst, llast, sformat, send, keep_item, begin_format, end_format) {\n",
              "    var anchors = document.getElementsByClassName(\"section\");\n",
              "    if (anchors.length == 0) {\n",
              "        anchors = document.getElementsByClassName(\"text_cell_render rendered_html\");\n",
              "    }\n",
              "    var i,t;\n",
              "    var text_menu = begin;\n",
              "    var text_memo = \"<pre>\\nlength:\" + anchors.length + \"\\n\";\n",
              "    var ind = \"\";\n",
              "    var memo_level = 1;\n",
              "    var href;\n",
              "    var tags = [];\n",
              "    var main_item = 0;\n",
              "    var format_open = 0;\n",
              "    for (i = 0; i <= llast; i++)\n",
              "        tags.push(\"h\" + i);\n",
              "\n",
              "    for (i = 0; i < anchors.length; i++) {\n",
              "        text_memo += \"**\" + anchors[i].id + \"--\\n\";\n",
              "\n",
              "        var child = null;\n",
              "        for(t = 0; t < tags.length; t++) {\n",
              "            var r = anchors[i].getElementsByTagName(tags[t]);\n",
              "            if (r.length > 0) {\n",
              "child = r[0];\n",
              "break;\n",
              "            }\n",
              "        }\n",
              "        if (child == null) {\n",
              "            text_memo += \"null\\n\";\n",
              "            continue;\n",
              "        }\n",
              "        if (anchors[i].hasAttribute(\"id\")) {\n",
              "            // when converted in RST\n",
              "            href = anchors[i].id;\n",
              "            text_memo += \"#1-\" + href;\n",
              "            // passer \u00e0 child suivant (le chercher)\n",
              "        }\n",
              "        else if (child.hasAttribute(\"id\")) {\n",
              "            // in a notebook\n",
              "            href = child.id;\n",
              "            text_memo += \"#2-\" + href;\n",
              "        }\n",
              "        else {\n",
              "            text_memo += \"#3-\" + \"*\" + \"\\n\";\n",
              "            continue;\n",
              "        }\n",
              "        var title = child.textContent;\n",
              "        var level = parseInt(child.tagName.substring(1,2));\n",
              "\n",
              "        text_memo += \"--\" + level + \"?\" + lfirst + \"--\" + title + \"\\n\";\n",
              "\n",
              "        if ((level < lfirst) || (level > llast)) {\n",
              "            continue ;\n",
              "        }\n",
              "        if (title.endsWith('\u00b6')) {\n",
              "            title = title.substring(0,title.length-1).replace(\"<\", \"&lt;\")\n",
              "         .replace(\">\", \"&gt;\").replace(\"&\", \"&amp;\");\n",
              "        }\n",
              "        if (title.length == 0) {\n",
              "            continue;\n",
              "        }\n",
              "\n",
              "        while (level < memo_level) {\n",
              "            text_menu += end_format + \"</ul>\\n\";\n",
              "            format_open -= 1;\n",
              "            memo_level -= 1;\n",
              "        }\n",
              "        if (level == lfirst) {\n",
              "            main_item += 1;\n",
              "        }\n",
              "        if (keep_item != -1 && main_item != keep_item + 1) {\n",
              "            // alert(main_item + \" - \" + level + \" - \" + keep_item);\n",
              "            continue;\n",
              "        }\n",
              "        while (level > memo_level) {\n",
              "            text_menu += \"<ul>\\n\";\n",
              "            memo_level += 1;\n",
              "        }\n",
              "        text_menu += repeat_indent_string(level-2);\n",
              "        text_menu += begin_format + sformat.replace(\"__HREF__\", href).replace(\"__TITLE__\", title);\n",
              "        format_open += 1;\n",
              "    }\n",
              "    while (1 < memo_level) {\n",
              "        text_menu += end_format + \"</ul>\\n\";\n",
              "        memo_level -= 1;\n",
              "        format_open -= 1;\n",
              "    }\n",
              "    text_menu += send;\n",
              "    //text_menu += \"\\n\" + text_memo;\n",
              "\n",
              "    while (format_open > 0) {\n",
              "        text_menu += end_format;\n",
              "        format_open -= 1;\n",
              "    }\n",
              "    return text_menu;\n",
              "};\n",
              "var update_menu = function() {\n",
              "    var sbegin = \"\";\n",
              "    var sformat = '<a href=\"#__HREF__\">__TITLE__</a>';\n",
              "    var send = \"\";\n",
              "    var begin_format = '<li>';\n",
              "    var end_format = '</li>';\n",
              "    var keep_item = -1;\n",
              "    var text_menu = update_menu_string(sbegin, 2, 4, sformat, send, keep_item,\n",
              "       begin_format, end_format);\n",
              "    var menu = document.getElementById(\"my_id_menu_nb\");\n",
              "    menu.innerHTML=text_menu;\n",
              "};\n",
              "window.setTimeout(update_menu,2000);\n",
              "            </script>"
            ],
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ]
          },
          "execution_count": 2,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "from jyquickhelper import add_notebook_menu\n",
        "add_notebook_menu()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {},
      "outputs": [],
      "source": [
        "%matplotlib inline"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## Observations brutes"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/plain": [
              "['logs\\\\QCMApp.log']"
            ]
          },
          "execution_count": 4,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "import os\n",
        "names = [os.path.join(\"logs\", _) for _ in os.listdir(\"logs\") if '.log' in _]\n",
        "names = names[-1:]\n",
        "names"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/plain": [
              "['2018-12-12 17:56:29,989,INFO,[DATA],{\"msg\":\"qcm\",\"session\":{\"alias\":\"xavierd\"},\"client\":[\"167.220.197.38\",6274],\"game\":\"simple_french_qcm\",\"qn\":\"0\"}\\n',\n",
              " '2018-12-12 17:56:33,130,INFO,[DATA],{\"msg\":\"event\",\"session\":{\"alias\":\"xavierd\"},\"client\":[\"167.220.197.38\",6274],\"events\":[\"focus:true,game:simple_french_qcm,qn:0\"]}\\n']"
            ]
          },
          "execution_count": 5,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "with open(names[0], 'r', encoding=\"utf-8\") as f:\n",
        "    lines = f.readlines()\n",
        "lines[5:7]"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "Let's retrieve the expected answers from the QCM."
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {},
      "outputs": [
        {
          "data": {
            "text/plain": [
              "[['simple_french_qcm-0-a0'],\n",
              " ['simple_french_qcm-1-a2'],\n",
              " ['simple_french_qcm-2-a2'],\n",
              " ['simple_french_qcm-3-a3'],\n",
              " ['simple_french_qcm-4-a2'],\n",
              " ['simple_french_qcm-5-a0', 'simple_french_qcm-5-a2'],\n",
              " ['simple_french_qcm-6-a5'],\n",
              " ['simple_french_qcm-7-a2'],\n",
              " ['simple_french_qcm-8-Thal\u00e8s']]"
            ]
          },
          "execution_count": 6,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "from mathenjeu.tests import simple_french_qcm\n",
        "qcm = simple_french_qcm()\n",
        "expected = qcm.expected_answers()\n",
        "expected"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "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>person_id</th>\n",
              "      <th>c241c15008614ea67480</th>\n",
              "      <th>32606f02fa0df6aac111</th>\n",
              "      <th>5bd96adafa694996027d</th>\n",
              "      <th>753a507a9205e4c196fa</th>\n",
              "      <th>8a8c40ad28eb1206efd5</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-a0</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-b</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-duration</th>\n",
              "      <td>0 days 00:00:04.266000</td>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:06.904000</td>\n",
              "      <td>0 days 00:00:16.530000</td>\n",
              "      <td>0 days 00:00:02.920000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-good</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-nbvisit</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-a0</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-a1</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-a2</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-b</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-duration</th>\n",
              "      <td>1 days 00:00:00</td>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:10.153000</td>\n",
              "      <td>0 days 00:00:11.740000</td>\n",
              "      <td>0 days 00:00:02.247000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-good</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-5-nbvisit</th>\n",
              "      <td>0.5</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-8-ANS</th>\n",
              "      <td>thal\u00e8s</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Ast\u00e9rix et Cl\u00e9op\u00e2tre</td>\n",
              "      <td>Prout</td>\n",
              "      <td></td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-8-b</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-8-duration</th>\n",
              "      <td>0 days 00:00:04.390000</td>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:03:02.506000</td>\n",
              "      <td>0 days 00:00:14.483000</td>\n",
              "      <td>0 days 00:00:01.422000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-8-good</th>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-8-nbvisit</th>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1001</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:03.343000</td>\n",
              "      <td>0</td>\n",
              "      <td>0 days 00:00:14.010000</td>\n",
              "      <td>NaT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-2-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-2-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-2-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:06.750000</td>\n",
              "      <td>0 days 00:00:31.978000</td>\n",
              "      <td>0 days 00:00:28.765000</td>\n",
              "      <td>NaT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-2-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-2-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-a3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>1 days 00:00:00</td>\n",
              "      <td>0 days 00:00:19.246000</td>\n",
              "      <td>0 days 00:00:19.492000</td>\n",
              "      <td>0 days 00:00:09.323000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:09.688000</td>\n",
              "      <td>0 days 00:00:21.230000</td>\n",
              "      <td>0 days 00:03:19.593000</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-a3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>1 days 00:00:00</td>\n",
              "      <td>0 days 00:00:20.314000</td>\n",
              "      <td>0 days 00:00:21.868000</td>\n",
              "      <td>0 days 00:00:00.750000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>0.5</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-b</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-duration</th>\n",
              "      <td>NaT</td>\n",
              "      <td>0 days 00:00:06.390000</td>\n",
              "      <td>0 days 00:00:17.141000</td>\n",
              "      <td>0 days 00:00:20.923000</td>\n",
              "      <td>0 days 00:00:01.188000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-good</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-nbvisit</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-3-a0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-1-a1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-a0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-6-a5</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-7-a0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>-a1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>on-a2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-0-a1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>simple_french_qcm-4-a3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "person_id                       c241c15008614ea67480    32606f02fa0df6aac111  \\\n",
              "simple_french_qcm-0-a0                             1                     NaN   \n",
              "simple_french_qcm-0-b                              1                     NaN   \n",
              "simple_french_qcm-0-duration  0 days 00:00:04.266000                     NaT   \n",
              "simple_french_qcm-0-good                           1                     NaN   \n",
              "simple_french_qcm-0-nbvisit                        1                     NaN   \n",
              "simple_french_qcm-5-a0                             1                     NaN   \n",
              "simple_french_qcm-5-a1                             1                     NaN   \n",
              "simple_french_qcm-5-a2                             1                     NaN   \n",
              "simple_french_qcm-5-b                              1                     NaN   \n",
              "simple_french_qcm-5-duration         1 days 00:00:00                     NaT   \n",
              "simple_french_qcm-5-good                           1                     NaN   \n",
              "simple_french_qcm-5-nbvisit                      0.5                     NaN   \n",
              "simple_french_qcm-8-ANS                       thal\u00e8s                     NaN   \n",
              "simple_french_qcm-8-b                              1                     NaN   \n",
              "simple_french_qcm-8-duration  0 days 00:00:04.390000                     NaT   \n",
              "simple_french_qcm-8-good                           0                     NaN   \n",
              "simple_french_qcm-8-nbvisit                        1                     NaN   \n",
              "simple_french_qcm-1-a2                           NaN                       1   \n",
              "simple_french_qcm-1-b                            NaN                       1   \n",
              "simple_french_qcm-1-duration                     NaT  0 days 00:00:03.343000   \n",
              "simple_french_qcm-1-good                         NaN                       1   \n",
              "simple_french_qcm-1-nbvisit                      NaN                       1   \n",
              "simple_french_qcm-2-a2                           NaN                       1   \n",
              "simple_french_qcm-2-b                            NaN                       1   \n",
              "simple_french_qcm-2-duration                     NaT  0 days 00:00:06.750000   \n",
              "simple_french_qcm-2-good                         NaN                       1   \n",
              "simple_french_qcm-2-nbvisit                      NaN                       1   \n",
              "simple_french_qcm-3-a2                           NaN                       1   \n",
              "simple_french_qcm-3-a3                           NaN                       1   \n",
              "simple_french_qcm-3-b                            NaN                       1   \n",
              "simple_french_qcm-3-duration                     NaT         1 days 00:00:00   \n",
              "simple_french_qcm-3-good                         NaN                       1   \n",
              "simple_french_qcm-3-nbvisit                      NaN                     0.5   \n",
              "simple_french_qcm-4-a2                           NaN                       1   \n",
              "simple_french_qcm-4-b                            NaN                       1   \n",
              "simple_french_qcm-4-duration                     NaT  0 days 00:00:09.688000   \n",
              "simple_french_qcm-4-good                         NaN                       1   \n",
              "simple_french_qcm-4-nbvisit                      NaN                       1   \n",
              "simple_french_qcm-6-a3                           NaN                       1   \n",
              "simple_french_qcm-6-b                            NaN                       1   \n",
              "simple_french_qcm-6-duration                     NaT         1 days 00:00:00   \n",
              "simple_french_qcm-6-good                         NaN                       0   \n",
              "simple_french_qcm-6-nbvisit                      NaN                     0.5   \n",
              "simple_french_qcm-7-a2                           NaN                       1   \n",
              "simple_french_qcm-7-b                            NaN                       1   \n",
              "simple_french_qcm-7-duration                     NaT  0 days 00:00:06.390000   \n",
              "simple_french_qcm-7-good                         NaN                       1   \n",
              "simple_french_qcm-7-nbvisit                      NaN                       1   \n",
              "simple_french_qcm-3-a0                           NaN                     NaN   \n",
              "simple_french_qcm-6-a2                           NaN                     NaN   \n",
              "simple_french_qcm-1-a1                           NaN                     NaN   \n",
              "simple_french_qcm-4-a0                           NaN                     NaN   \n",
              "simple_french_qcm-6-a5                           NaN                     NaN   \n",
              "simple_french_qcm-7-a0                           NaN                     NaN   \n",
              "-a1                                              NaN                     NaN   \n",
              "on-a2                                            NaN                     NaN   \n",
              "simple_french_qcm-0-a1                           NaN                     NaN   \n",
              "simple_french_qcm-4-a3                           NaN                     NaN   \n",
              "\n",
              "person_id                       5bd96adafa694996027d    753a507a9205e4c196fa  \\\n",
              "simple_french_qcm-0-a0                             1                       1   \n",
              "simple_french_qcm-0-b                              1                       1   \n",
              "simple_french_qcm-0-duration  0 days 00:00:06.904000  0 days 00:00:16.530000   \n",
              "simple_french_qcm-0-good                           1                       1   \n",
              "simple_french_qcm-0-nbvisit                        1                       1   \n",
              "simple_french_qcm-5-a0                           NaN                       1   \n",
              "simple_french_qcm-5-a1                             1                     NaN   \n",
              "simple_french_qcm-5-a2                           NaN                     NaN   \n",
              "simple_french_qcm-5-b                              1                       1   \n",
              "simple_french_qcm-5-duration  0 days 00:00:10.153000  0 days 00:00:11.740000   \n",
              "simple_french_qcm-5-good                           0                       1   \n",
              "simple_french_qcm-5-nbvisit                        1                       1   \n",
              "simple_french_qcm-8-ANS         Ast\u00e9rix et Cl\u00e9op\u00e2tre                   Prout   \n",
              "simple_french_qcm-8-b                              1                       1   \n",
              "simple_french_qcm-8-duration  0 days 00:03:02.506000  0 days 00:00:14.483000   \n",
              "simple_french_qcm-8-good                           0                       0   \n",
              "simple_french_qcm-8-nbvisit                        1                       1   \n",
              "simple_french_qcm-1-a2                             2                     NaN   \n",
              "simple_french_qcm-1-b                           1001                       1   \n",
              "simple_french_qcm-1-duration                       0  0 days 00:00:14.010000   \n",
              "simple_french_qcm-1-good                           2                       0   \n",
              "simple_french_qcm-1-nbvisit                        3                       1   \n",
              "simple_french_qcm-2-a2                             1                       1   \n",
              "simple_french_qcm-2-b                              1                       1   \n",
              "simple_french_qcm-2-duration  0 days 00:00:31.978000  0 days 00:00:28.765000   \n",
              "simple_french_qcm-2-good                           1                       1   \n",
              "simple_french_qcm-2-nbvisit                        2                       1   \n",
              "simple_french_qcm-3-a2                           NaN                     NaN   \n",
              "simple_french_qcm-3-a3                           NaN                     NaN   \n",
              "simple_french_qcm-3-b                              1                       1   \n",
              "simple_french_qcm-3-duration  0 days 00:00:19.246000  0 days 00:00:19.492000   \n",
              "simple_french_qcm-3-good                           0                       0   \n",
              "simple_french_qcm-3-nbvisit                        1                       1   \n",
              "simple_french_qcm-4-a2                             1                     NaN   \n",
              "simple_french_qcm-4-b                              1                       1   \n",
              "simple_french_qcm-4-duration  0 days 00:00:21.230000  0 days 00:03:19.593000   \n",
              "simple_french_qcm-4-good                           1                       0   \n",
              "simple_french_qcm-4-nbvisit                        1                       1   \n",
              "simple_french_qcm-6-a3                           NaN                     NaN   \n",
              "simple_french_qcm-6-b                              1                       1   \n",
              "simple_french_qcm-6-duration  0 days 00:00:20.314000  0 days 00:00:21.868000   \n",
              "simple_french_qcm-6-good                           0                       1   \n",
              "simple_french_qcm-6-nbvisit                        1                       1   \n",
              "simple_french_qcm-7-a2                             1                     NaN   \n",
              "simple_french_qcm-7-b                              1                       1   \n",
              "simple_french_qcm-7-duration  0 days 00:00:17.141000  0 days 00:00:20.923000   \n",
              "simple_french_qcm-7-good                           1                       0   \n",
              "simple_french_qcm-7-nbvisit                        1                       1   \n",
              "simple_french_qcm-3-a0                             1                       1   \n",
              "simple_french_qcm-6-a2                             1                     NaN   \n",
              "simple_french_qcm-1-a1                           NaN                       1   \n",
              "simple_french_qcm-4-a0                           NaN                       1   \n",
              "simple_french_qcm-6-a5                           NaN                       1   \n",
              "simple_french_qcm-7-a0                           NaN                       1   \n",
              "-a1                                              NaN                     NaN   \n",
              "on-a2                                            NaN                     NaN   \n",
              "simple_french_qcm-0-a1                           NaN                     NaN   \n",
              "simple_french_qcm-4-a3                           NaN                     NaN   \n",
              "\n",
              "person_id                       8a8c40ad28eb1206efd5  \n",
              "simple_french_qcm-0-a0                           NaN  \n",
              "simple_french_qcm-0-b                              1  \n",
              "simple_french_qcm-0-duration  0 days 00:00:02.920000  \n",
              "simple_french_qcm-0-good                           0  \n",
              "simple_french_qcm-0-nbvisit                        1  \n",
              "simple_french_qcm-5-a0                           NaN  \n",
              "simple_french_qcm-5-a1                           NaN  \n",
              "simple_french_qcm-5-a2                           NaN  \n",
              "simple_french_qcm-5-b                           1000  \n",
              "simple_french_qcm-5-duration  0 days 00:00:02.247000  \n",
              "simple_french_qcm-5-good                           0  \n",
              "simple_french_qcm-5-nbvisit                        2  \n",
              "simple_french_qcm-8-ANS                               \n",
              "simple_french_qcm-8-b                              1  \n",
              "simple_french_qcm-8-duration  0 days 00:00:01.422000  \n",
              "simple_french_qcm-8-good                           0  \n",
              "simple_french_qcm-8-nbvisit                        1  \n",
              "simple_french_qcm-1-a2                           NaN  \n",
              "simple_french_qcm-1-b                            NaN  \n",
              "simple_french_qcm-1-duration                     NaT  \n",
              "simple_french_qcm-1-good                         NaN  \n",
              "simple_french_qcm-1-nbvisit                      NaN  \n",
              "simple_french_qcm-2-a2                           NaN  \n",
              "simple_french_qcm-2-b                            NaN  \n",
              "simple_french_qcm-2-duration                     NaT  \n",
              "simple_french_qcm-2-good                         NaN  \n",
              "simple_french_qcm-2-nbvisit                      NaN  \n",
              "simple_french_qcm-3-a2                             1  \n",
              "simple_french_qcm-3-a3                             1  \n",
              "simple_french_qcm-3-b                           1000  \n",
              "simple_french_qcm-3-duration  0 days 00:00:09.323000  \n",
              "simple_french_qcm-3-good                           1  \n",
              "simple_french_qcm-3-nbvisit                        3  \n",
              "simple_french_qcm-4-a2                             1  \n",
              "simple_french_qcm-4-b                              2  \n",
              "simple_french_qcm-4-duration                       0  \n",
              "simple_french_qcm-4-good                           1  \n",
              "simple_french_qcm-4-nbvisit                        5  \n",
              "simple_french_qcm-6-a3                           NaN  \n",
              "simple_french_qcm-6-b                              1  \n",
              "simple_french_qcm-6-duration  0 days 00:00:00.750000  \n",
              "simple_french_qcm-6-good                           0  \n",
              "simple_french_qcm-6-nbvisit                        1  \n",
              "simple_french_qcm-7-a2                           NaN  \n",
              "simple_french_qcm-7-b                              1  \n",
              "simple_french_qcm-7-duration  0 days 00:00:01.188000  \n",
              "simple_french_qcm-7-good                           0  \n",
              "simple_french_qcm-7-nbvisit                        1  \n",
              "simple_french_qcm-3-a0                           NaN  \n",
              "simple_french_qcm-6-a2                           NaN  \n",
              "simple_french_qcm-1-a1                           NaN  \n",
              "simple_french_qcm-4-a0                           NaN  \n",
              "simple_french_qcm-6-a5                           NaN  \n",
              "simple_french_qcm-7-a0                           NaN  \n",
              "-a1                                              NaN  \n",
              "on-a2                                            NaN  \n",
              "simple_french_qcm-0-a1                             1  \n",
              "simple_french_qcm-4-a3                             1  "
            ]
          },
          "execution_count": 7,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "import pandas\n",
        "from mathenjeu.datalog import enumerate_qcmlogdf\n",
        "dfs = pandas.concat(list(enumerate_qcmlogdf(names, expected)))\n",
        "dfs.T"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {},
      "outputs": [],
      "source": []
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "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": 1
}