lafrite/2014-2015
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
master
2014-2015/2nd/DM/DM_0327/Bilan/Bilan DM_0327.ipynb

1885 lines
62 KiB
Plaintext
Raw Permalink Normal View History

Import work from year 2014-2015
2017-06-16 06:48:07 +00:00
{
"cells": [
{
"cell_type": "code",
"execution_count": 104,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import pandas as pd\n",
"from texenv import texenv\n",
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 105,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"ds_name = \"DM_0327\"\n",
"classe = \"2nd6\""
]
},
{
"cell_type": "code",
"execution_count": 106,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [],
"source": [
"notes = pd.ExcelFile(\"./../../../notes_\"+classe+\".xls\")\n",
"notes.sheet_names\n",
"notes = notes.parse(ds_name)"
]
},
{
"cell_type": "code",
"execution_count": 107,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"Index(['DM_0327', 'av_arrondi', 'Exercice 1', '1.a', '1.b', '1.c', '1.d', '2.a', '2.b', '2.c', '2.d', '3.a', '3.b', '3.c', 'Malus', 'Exercice 2', 'Num_sujet', 'Raisonner', 'Communiquer'], dtype='object')"
]
},
"execution_count": 107,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes.index"
]
},
{
"cell_type": "code",
"execution_count": 108,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"notes = notes.T"
]
},
{
"cell_type": "code",
"execution_count": 109,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes.drop(\"av_arrondi\", axis=1)\n",
"notes = notes.drop(\"Num_sujet\", axis=1)"
]
},
{
"cell_type": "code",
"execution_count": 110,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DM_0327</th>\n",
" <th>Exercice 1</th>\n",
" <th>1.a</th>\n",
" <th>1.b</th>\n",
" <th>1.c</th>\n",
" <th>1.d</th>\n",
" <th>2.a</th>\n",
" <th>2.b</th>\n",
" <th>2.c</th>\n",
" <th>2.d</th>\n",
" <th>3.a</th>\n",
" <th>3.b</th>\n",
" <th>3.c</th>\n",
" <th>Malus</th>\n",
" <th>Exercice 2</th>\n",
" <th>Raisonner</th>\n",
" <th>Communiquer</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>ANANTHARASA Kisojana</th>\n",
" <td>11</td>\n",
" <td>10.33333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>0.6666667</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BAKAYOKO Aïcha</th>\n",
" <td>15</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BLAISE Emilie</th>\n",
" <td>13</td>\n",
" <td>9.333333</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>CHOISI Geordy</th>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DRIDI Karim</th>\n",
" <td>11</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FADIGA Mohamed</th>\n",
" <td>12</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>1.333333</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FESSARD Katelyne</th>\n",
" <td>9</td>\n",
" <td>7</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FUSCO Manon</th>\n",
" <td>12</td>\n",
" <td>10.66667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>1.333333</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GILBERT Melissa</th>\n",
" <td>11</td>\n",
" <td>10</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.5</td>\n",
" <td>1.333333</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUNARASA Rithurshan</th>\n",
" <td>12</td>\n",
" <td>10.33333</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>HAMLAOUI Fattouma</th>\n",
" <td>14</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3.333333</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INACIO Bastien</th>\n",
" <td>13</td>\n",
" <td>10.66667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JAMAL EL AMRANI Hafar</th>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JOHNSON Yannick</th>\n",
" <td>8</td>\n",
" <td>7.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KEITA Yakaré</th>\n",
" <td>15</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KONE Yacouba</th>\n",
" <td>15</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LE Quentin</th>\n",
" <td>9</td>\n",
" <td>7.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>1.333333</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LOUKA Marina</th>\n",
" <td>13</td>\n",
" <td>10.66667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2.666667</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MARIGA Alexis</th>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MATOS GOMES Jean Daniel</th>\n",
" <td>5</td>\n",
" <td>3.333333</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>1.333333</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MELAYAH Marwa</th>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOALI Lauryn</th>\n",
" <td>13</td>\n",
" <td>10.33333</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2.666667</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MONTAGNINI Cindy</th>\n",
" <td>15</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NGO Viviane</th>\n",
" <td>13</td>\n",
" <td>10.33333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2.666667</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEREIRA VAZ Luis Carlos</th>\n",
" <td>13</td>\n",
" <td>10.66667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QADIR Maryam</th>\n",
" <td>11</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAIDANE Maissa</th>\n",
" <td>11</td>\n",
" <td>6.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SANTOS DO CARMO Kevin</th>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVA Andre Luis</th>\n",
" <td>14</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3.333333</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAUFF Léna</th>\n",
" <td>14</td>\n",
" <td>10.33333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3.333333</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DM_0327 Exercice 1 1.a 1.b 1.c 1.d 2.a 2.b 2.c \\\n",
"ANANTHARASA Kisojana 11 10.33333 3 3 3 2 3 3 3 \n",
"BAKAYOKO Aïcha 15 11 3 3 3 3 3 3 3 \n",
"BLAISE Emilie 13 9.333333 3 2 3 3 3 0 3 \n",
"CHOISI Geordy NaN 0 NaN NaN NaN NaN NaN NaN NaN \n",
"DRIDI Karim 11 11 3 3 3 3 3 3 3 \n",
"FADIGA Mohamed 12 11 3 3 3 3 3 3 3 \n",
"FESSARD Katelyne 9 7 3 3 3 NaN 3 NaN NaN \n",
"FUSCO Manon 12 10.66667 3 3 3 3 3 3 2 \n",
"GILBERT Melissa 11 10 3 2 3 2 3 3 3 \n",
"GUNARASA Rithurshan 12 10.33333 1 3 3 3 3 3 3 \n",
"HAMLAOUI Fattouma 14 11 3 3 3 3 3 3 3 \n",
"INACIO Bastien 13 10.66667 3 3 2 3 3 3 3 \n",
"JAMAL EL AMRANI Hafar NaN 0 NaN NaN NaN NaN NaN NaN NaN \n",
"JOHNSON Yannick 8 7.666667 3 2 2 0 3 3 NaN \n",
"KEITA Yakaré 15 11 3 3 3 3 3 3 3 \n",
"KONE Yacouba 15 11 3 3 3 3 3 3 3 \n",
"LE Quentin 9 7.666667 3 3 3 0 3 1 3 \n",
"LOUKA Marina 13 10.66667 3 3 3 2 3 3 3 \n",
"MARIGA Alexis NaN 0 NaN NaN NaN NaN NaN NaN NaN \n",
"MATOS GOMES Jean Daniel 5 3.333333 2 2 0 0 2 0 0 \n",
"MELAYAH Marwa NaN 0 NaN NaN NaN NaN NaN NaN NaN \n",
"MOALI Lauryn 13 10.33333 3 1 3 3 3 3 3 \n",
"MONTAGNINI Cindy 15 11 3 3 3 3 3 3 3 \n",
"NGO Viviane 13 10.33333 3 3 3 3 3 3 3 \n",
"PEREIRA VAZ Luis Carlos 13 10.66667 3 3 3 3 3 3 3 \n",
"QADIR Maryam 11 7 2 3 3 1 3 0 0 \n",
"SAIDANE Maissa 11 6.666667 3 2 3 0 3 0 0 \n",
"SANTOS DO CARMO Kevin NaN 0 NaN NaN NaN NaN NaN NaN NaN \n",
"SILVA Andre Luis 14 11 3 3 3 3 3 3 3 \n",
"STAUFF Léna 14 10.33333 3 3 3 1 3 3 3 \n",
"\n",
" 2.d 3.a 3.b 3.c Malus Exercice 2 Raisonner \\\n",
"ANANTHARASA Kisojana 3 3 2 3 NaN 0.6666667 1 \n",
"BAKAYOKO Aïcha 3 3 3 3 NaN 4 3 \n",
"BLAISE Emilie 2 3 3 3 NaN 4 3 \n",
"CHOISI Geordy NaN NaN NaN NaN NaN 0 NaN \n",
"DRIDI Karim 3 3 3 3 NaN 0 0 \n",
"FADIGA Mohamed 3 3 3 3 NaN 1.333333 0 \n",
"FESSARD Katelyne NaN 3 3 3 NaN 2 1 \n",
"FUSCO Manon 3 3 3 3 NaN 1.333333 1 \n",
"GILBERT Melissa 3 3 2 3 0.5 1.333333 1 \n",
"GUNARASA Rithurshan 3 3 3 3 NaN 2 2 \n",
"HAMLAOUI Fattouma 3 3 3 3 NaN 3.333333 2 \n",
"INACIO Bastien 3 3 3 3 NaN 2 1 \n",
"JAMAL EL AMRANI Hafar NaN NaN NaN NaN NaN 0 NaN \n",
"JOHNSON Yannick 3 3 2 2 NaN 0 0 \n",
"KEITA Yakaré 3 3 3 3 NaN 4 3 \n",
"KONE Yacouba 3 3 3 3 NaN 4 3 \n",
"LE Quentin 3 0 2 2 NaN 1.333333 1 \n",
"LOUKA Marina 3 3 3 3 NaN 2.666667 2 \n",
"MARIGA Alexis NaN NaN NaN NaN NaN 0 NaN \n",
"MATOS GOMES Jean Daniel 0 2 1 1 NaN 1.333333 1 \n",
"MELAYAH Marwa NaN NaN NaN NaN NaN 0 NaN \n",
"MOALI Lauryn 3 3 3 3 NaN 2.666667 1 \n",
"MONTAGNINI Cindy 3 3 3 3 NaN 4 3 \n",
"NGO Viviane 1 3 3 3 NaN 2.666667 2 \n",
"PEREIRA VAZ Luis Carlos 3 2 3 3 NaN 2 1 \n",
"QADIR Maryam 3 3 2 1 NaN 4 3 \n",
"SAIDANE Maissa 0 3 3 3 NaN 4 3 \n",
"SANTOS DO CARMO Kevin NaN NaN NaN NaN NaN 0 NaN \n",
"SILVA Andre Luis 3 3 3 3 NaN 3.333333 2 \n",
"STAUFF Léna 3 3 3 3 NaN 3.333333 2 \n",
"\n",
" Communiquer \n",
"ANANTHARASA Kisojana 0 \n",
"BAKAYOKO Aïcha 3 \n",
"BLAISE Emilie 3 \n",
"CHOISI Geordy NaN \n",
"DRIDI Karim 0 \n",
"FADIGA Mohamed 2 \n",
"FESSARD Katelyne 2 \n",
"FUSCO Manon 1 \n",
"GILBERT Melissa 1 \n",
"GUNARASA Rithurshan 1 \n",
"HAMLAOUI Fattouma 3 \n",
"INACIO Bastien 2 \n",
"JAMAL EL AMRANI Hafar NaN \n",
"JOHNSON Yannick 0 \n",
"KEITA Yakaré 3 \n",
"KONE Yacouba 3 \n",
"LE Quentin 1 \n",
"LOUKA Marina 2 \n",
"MARIGA Alexis NaN \n",
"MATOS GOMES Jean Daniel 1 \n",
"MELAYAH Marwa NaN \n",
"MOALI Lauryn 3 \n",
"MONTAGNINI Cindy 3 \n",
"NGO Viviane 2 \n",
"PEREIRA VAZ Luis Carlos 2 \n",
"QADIR Maryam 3 \n",
"SAIDANE Maissa 3 \n",
"SANTOS DO CARMO Kevin NaN \n",
"SILVA Andre Luis 3 \n",
"STAUFF Léna 3 "
]
},
"execution_count": 110,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"barem = notes[:1]\n",
"notes = notes[1:]\n",
"notes"
]
},
{
"cell_type": "code",
"execution_count": 111,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes[notes[ds_name].notnull()]\n",
"#notes"
]
},
{
"cell_type": "code",
"execution_count": 112,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes.astype(float)"
]
},
{
"cell_type": "code",
"execution_count": 113,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"count 25.000000\n",
"mean 12.080000\n",
"std 2.431049\n",
"min 5.000000\n",
"25% 11.000000\n",
"50% 13.000000\n",
"75% 14.000000\n",
"max 15.000000\n",
"Name: DM_0327, dtype: float64"
]
},
"execution_count": 113,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes[ds_name].describe()"
]
},
{
"cell_type": "code",
"execution_count": 114,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"list_exo = [\"Exercice 1\", \"Exercice 2\"]"
]
},
{
"cell_type": "code",
"execution_count": 121,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Exercice 1</th>\n",
" <th>Exercice 2</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>ANANTHARASA Kisojana</th>\n",
" <td>10.33</td>\n",
" <td>0.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BAKAYOKO Aïcha</th>\n",
" <td>11.00</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BLAISE Emilie</th>\n",
" <td>9.33</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DRIDI Karim</th>\n",
" <td>11.00</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FADIGA Mohamed</th>\n",
" <td>11.00</td>\n",
" <td>1.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FESSARD Katelyne</th>\n",
" <td>7.00</td>\n",
" <td>2.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FUSCO Manon</th>\n",
" <td>10.67</td>\n",
" <td>1.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GILBERT Melissa</th>\n",
" <td>10.00</td>\n",
" <td>1.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUNARASA Rithurshan</th>\n",
" <td>10.33</td>\n",
" <td>2.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>HAMLAOUI Fattouma</th>\n",
" <td>11.00</td>\n",
" <td>3.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INACIO Bastien</th>\n",
" <td>10.67</td>\n",
" <td>2.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JOHNSON Yannick</th>\n",
" <td>7.67</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KEITA Yakaré</th>\n",
" <td>11.00</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KONE Yacouba</th>\n",
" <td>11.00</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LE Quentin</th>\n",
" <td>7.67</td>\n",
" <td>1.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LOUKA Marina</th>\n",
" <td>10.67</td>\n",
" <td>2.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MATOS GOMES Jean Daniel</th>\n",
" <td>3.33</td>\n",
" <td>1.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOALI Lauryn</th>\n",
" <td>10.33</td>\n",
" <td>2.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MONTAGNINI Cindy</th>\n",
" <td>11.00</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NGO Viviane</th>\n",
" <td>10.33</td>\n",
" <td>2.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEREIRA VAZ Luis Carlos</th>\n",
" <td>10.67</td>\n",
" <td>2.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QADIR Maryam</th>\n",
" <td>7.00</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAIDANE Maissa</th>\n",
" <td>6.67</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVA Andre Luis</th>\n",
" <td>11.00</td>\n",
" <td>3.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAUFF Léna</th>\n",
" <td>10.33</td>\n",
" <td>3.33</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Exercice 1 Exercice 2\n",
"ANANTHARASA Kisojana 10.33 0.67\n",
"BAKAYOKO Aïcha 11.00 4.00\n",
"BLAISE Emilie 9.33 4.00\n",
"DRIDI Karim 11.00 0.00\n",
"FADIGA Mohamed 11.00 1.33\n",
"FESSARD Katelyne 7.00 2.00\n",
"FUSCO Manon 10.67 1.33\n",
"GILBERT Melissa 10.00 1.33\n",
"GUNARASA Rithurshan 10.33 2.00\n",
"HAMLAOUI Fattouma 11.00 3.33\n",
"INACIO Bastien 10.67 2.00\n",
"JOHNSON Yannick 7.67 0.00\n",
"KEITA Yakaré 11.00 4.00\n",
"KONE Yacouba 11.00 4.00\n",
"LE Quentin 7.67 1.33\n",
"LOUKA Marina 10.67 2.67\n",
"MATOS GOMES Jean Daniel 3.33 1.33\n",
"MOALI Lauryn 10.33 2.67\n",
"MONTAGNINI Cindy 11.00 4.00\n",
"NGO Viviane 10.33 2.67\n",
"PEREIRA VAZ Luis Carlos 10.67 2.00\n",
"QADIR Maryam 7.00 4.00\n",
"SAIDANE Maissa 6.67 4.00\n",
"SILVA Andre Luis 11.00 3.33\n",
"STAUFF Léna 10.33 3.33"
]
},
"execution_count": 121,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes[list_exo] = notes[list_exo].applymap(lambda x:round(x,2))\n",
"notes[list_exo]"
]
},
{
"cell_type": "code",
"execution_count": 122,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"def toRepVal(val):\n",
" if pd.isnull(val):\n",
" return \"\\\\NoRep\"\n",
" elif val == 0:\n",
" return \"\\\\RepZ\"\n",
" elif val == 1:\n",
" return \"\\\\RepU\"\n",
" elif val == 2:\n",
" return \"\\\\RepD\"\n",
" elif val == 3:\n",
" return \"\\\\RepT\"\n",
" else:\n",
" return val"
]
},
{
"cell_type": "code",
"execution_count": 123,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"['1.a',\n",
" '1.b',\n",
" '1.c',\n",
" '1.d',\n",
" '2.a',\n",
" '2.b',\n",
" '2.c',\n",
" '2.d',\n",
" '3.a',\n",
" '3.b',\n",
" '3.c',\n",
" 'Raisonner',\n",
" 'Communiquer']"
]
},
"execution_count": 123,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sous_exo = [i for i in notes.T.index if i not in list_exo + [ds_name, \"bonus\", \"Malus\", \"Num_sujet\"]]\n",
"sous_exo"
]
},
{
"cell_type": "code",
"execution_count": 124,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes[sous_exo] = notes[sous_exo].applymap(toRepVal)"
]
},
{
"cell_type": "code",
"execution_count": 125,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"17"
]
},
"execution_count": 125,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(notes.T.index)"
]
},
{
"cell_type": "code",
"execution_count": 127,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"bilan = texenv.get_template(\"tpl_bilan.tex\")\n",
"with open(\"./bilan.tex\",\"w\") as f:\n",
" f.write(bilan.render(eleves = notes, barem = barem, ds_name = ds_name))"
]
},
{
"cell_type": "code",
"execution_count": 102,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>DM_0327</th>\n",
" <th>Exercice 1</th>\n",
" <th>1.a</th>\n",
" <th>1.b</th>\n",
" <th>1.c</th>\n",
" <th>1.d</th>\n",
" <th>2.a</th>\n",
" <th>2.b</th>\n",
" <th>2.c</th>\n",
" <th>2.d</th>\n",
" <th>3.a</th>\n",
" <th>3.b</th>\n",
" <th>3.c</th>\n",
" <th>Malus</th>\n",
" <th>Exercice 2</th>\n",
" <th>Num_sujet</th>\n",
" <th>Raisonner</th>\n",
" <th>Communiquer</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>ANANTHARASA Kisojana</th>\n",
" <td>11</td>\n",
" <td>10.33</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>0.67</td>\n",
" <td>4</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepZ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BAKAYOKO Aïcha</th>\n",
" <td>15</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>1</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BLAISE Emilie</th>\n",
" <td>13</td>\n",
" <td>9.33</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>1</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DRIDI Karim</th>\n",
" <td>11</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>0.00</td>\n",
" <td>1</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FADIGA Mohamed</th>\n",
" <td>12</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>1.33</td>\n",
" <td>4</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FESSARD Katelyne</th>\n",
" <td>9</td>\n",
" <td>7.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\NoRep</td>\n",
" <td>\\RepT</td>\n",
" <td>\\NoRep</td>\n",
" <td>\\NoRep</td>\n",
" <td>\\NoRep</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>3</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>FUSCO Manon</th>\n",
" <td>12</td>\n",
" <td>10.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>1.33</td>\n",
" <td>2</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GILBERT Melissa</th>\n",
" <td>11</td>\n",
" <td>10.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>0.5</td>\n",
" <td>1.33</td>\n",
" <td>1</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GUNARASA Rithurshan</th>\n",
" <td>12</td>\n",
" <td>10.33</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>2</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>HAMLAOUI Fattouma</th>\n",
" <td>14</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>3.33</td>\n",
" <td>3</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>INACIO Bastien</th>\n",
" <td>13</td>\n",
" <td>10.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>1</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JOHNSON Yannick</th>\n",
" <td>8</td>\n",
" <td>7.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\NoRep</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" <td>NaN</td>\n",
" <td>0.00</td>\n",
" <td>NaN</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KEITA Yakaré</th>\n",
" <td>15</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>3</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KONE Yacouba</th>\n",
" <td>15</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>3</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LE Quentin</th>\n",
" <td>9</td>\n",
" <td>7.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" <td>NaN</td>\n",
" <td>1.33</td>\n",
" <td>2</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LOUKA Marina</th>\n",
" <td>13</td>\n",
" <td>10.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.67</td>\n",
" <td>2</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MATOS GOMES Jean Daniel</th>\n",
" <td>5</td>\n",
" <td>3.33</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepU</td>\n",
" <td>NaN</td>\n",
" <td>1.33</td>\n",
" <td>1b</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepU</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOALI Lauryn</th>\n",
" <td>13</td>\n",
" <td>10.33</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.67</td>\n",
" <td>2</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MONTAGNINI Cindy</th>\n",
" <td>15</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>1b</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NGO Viviane</th>\n",
" <td>13</td>\n",
" <td>10.33</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.67</td>\n",
" <td>1b</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PEREIRA VAZ Luis Carlos</th>\n",
" <td>13</td>\n",
" <td>10.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>2.00</td>\n",
" <td>4</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>QADIR Maryam</th>\n",
" <td>11</td>\n",
" <td>7.00</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepU</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>3</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SAIDANE Maissa</th>\n",
" <td>11</td>\n",
" <td>6.67</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepZ</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>4.00</td>\n",
" <td>1</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILVA Andre Luis</th>\n",
" <td>14</td>\n",
" <td>11.00</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>3.33</td>\n",
" <td>1</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>STAUFF Léna</th>\n",
" <td>14</td>\n",
" <td>10.33</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepU</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>\\RepT</td>\n",
" <td>NaN</td>\n",
" <td>3.33</td>\n",
" <td>2</td>\n",
" <td>\\RepD</td>\n",
" <td>\\RepT</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" DM_0327 Exercice 1 1.a 1.b 1.c 1.d \\\n",
"ANANTHARASA Kisojana 11 10.33 \\RepT \\RepT \\RepT \\RepD \n",
"BAKAYOKO Aïcha 15 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"BLAISE Emilie 13 9.33 \\RepT \\RepD \\RepT \\RepT \n",
"DRIDI Karim 11 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"FADIGA Mohamed 12 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"FESSARD Katelyne 9 7.00 \\RepT \\RepT \\RepT \\NoRep \n",
"FUSCO Manon 12 10.67 \\RepT \\RepT \\RepT \\RepT \n",
"GILBERT Melissa 11 10.00 \\RepT \\RepD \\RepT \\RepD \n",
"GUNARASA Rithurshan 12 10.33 \\RepU \\RepT \\RepT \\RepT \n",
"HAMLAOUI Fattouma 14 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"INACIO Bastien 13 10.67 \\RepT \\RepT \\RepD \\RepT \n",
"JOHNSON Yannick 8 7.67 \\RepT \\RepD \\RepD \\RepZ \n",
"KEITA Yakaré 15 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"KONE Yacouba 15 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"LE Quentin 9 7.67 \\RepT \\RepT \\RepT \\RepZ \n",
"LOUKA Marina 13 10.67 \\RepT \\RepT \\RepT \\RepD \n",
"MATOS GOMES Jean Daniel 5 3.33 \\RepD \\RepD \\RepZ \\RepZ \n",
"MOALI Lauryn 13 10.33 \\RepT \\RepU \\RepT \\RepT \n",
"MONTAGNINI Cindy 15 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"NGO Viviane 13 10.33 \\RepT \\RepT \\RepT \\RepT \n",
"PEREIRA VAZ Luis Carlos 13 10.67 \\RepT \\RepT \\RepT \\RepT \n",
"QADIR Maryam 11 7.00 \\RepD \\RepT \\RepT \\RepU \n",
"SAIDANE Maissa 11 6.67 \\RepT \\RepD \\RepT \\RepZ \n",
"SILVA Andre Luis 14 11.00 \\RepT \\RepT \\RepT \\RepT \n",
"STAUFF Léna 14 10.33 \\RepT \\RepT \\RepT \\RepU \n",
"\n",
" 2.a 2.b 2.c 2.d 3.a 3.b 3.c \\\n",
"ANANTHARASA Kisojana \\RepT \\RepT \\RepT \\RepT \\RepT \\RepD \\RepT \n",
"BAKAYOKO Aïcha \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"BLAISE Emilie \\RepT \\RepZ \\RepT \\RepD \\RepT \\RepT \\RepT \n",
"DRIDI Karim \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"FADIGA Mohamed \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"FESSARD Katelyne \\RepT \\NoRep \\NoRep \\NoRep \\RepT \\RepT \\RepT \n",
"FUSCO Manon \\RepT \\RepT \\RepD \\RepT \\RepT \\RepT \\RepT \n",
"GILBERT Melissa \\RepT \\RepT \\RepT \\RepT \\RepT \\RepD \\RepT \n",
"GUNARASA Rithurshan \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"HAMLAOUI Fattouma \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"INACIO Bastien \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"JOHNSON Yannick \\RepT \\RepT \\NoRep \\RepT \\RepT \\RepD \\RepD \n",
"KEITA Yakaré \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"KONE Yacouba \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"LE Quentin \\RepT \\RepU \\RepT \\RepT \\RepZ \\RepD \\RepD \n",
"LOUKA Marina \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"MATOS GOMES Jean Daniel \\RepD \\RepZ \\RepZ \\RepZ \\RepD \\RepU \\RepU \n",
"MOALI Lauryn \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"MONTAGNINI Cindy \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"NGO Viviane \\RepT \\RepT \\RepT \\RepU \\RepT \\RepT \\RepT \n",
"PEREIRA VAZ Luis Carlos \\RepT \\RepT \\RepT \\RepT \\RepD \\RepT \\RepT \n",
"QADIR Maryam \\RepT \\RepZ \\RepZ \\RepT \\RepT \\RepD \\RepU \n",
"SAIDANE Maissa \\RepT \\RepZ \\RepZ \\RepZ \\RepT \\RepT \\RepT \n",
"SILVA Andre Luis \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"STAUFF Léna \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \\RepT \n",
"\n",
" Malus Exercice 2 Num_sujet Raisonner Communiquer \n",
"ANANTHARASA Kisojana NaN 0.67 4 \\RepU \\RepZ \n",
"BAKAYOKO Aïcha NaN 4.00 1 \\RepT \\RepT \n",
"BLAISE Emilie NaN 4.00 1 \\RepT \\RepT \n",
"DRIDI Karim NaN 0.00 1 \\RepZ \\RepZ \n",
"FADIGA Mohamed NaN 1.33 4 \\RepZ \\RepD \n",
"FESSARD Katelyne NaN 2.00 3 \\RepU \\RepD \n",
"FUSCO Manon NaN 1.33 2 \\RepU \\RepU \n",
"GILBERT Melissa 0.5 1.33 1 \\RepU \\RepU \n",
"GUNARASA Rithurshan NaN 2.00 2 \\RepD \\RepU \n",
"HAMLAOUI Fattouma NaN 3.33 3 \\RepD \\RepT \n",
"INACIO Bastien NaN 2.00 1 \\RepU \\RepD \n",
"JOHNSON Yannick NaN 0.00 NaN \\RepZ \\RepZ \n",
"KEITA Yakaré NaN 4.00 3 \\RepT \\RepT \n",
"KONE Yacouba NaN 4.00 3 \\RepT \\RepT \n",
"LE Quentin NaN 1.33 2 \\RepU \\RepU \n",
"LOUKA Marina NaN 2.67 2 \\RepD \\RepD \n",
"MATOS GOMES Jean Daniel NaN 1.33 1b \\RepU \\RepU \n",
"MOALI Lauryn NaN 2.67 2 \\RepU \\RepT \n",
"MONTAGNINI Cindy NaN 4.00 1b \\RepT \\RepT \n",
"NGO Viviane NaN 2.67 1b \\RepD \\RepD \n",
"PEREIRA VAZ Luis Carlos NaN 2.00 4 \\RepU \\RepD \n",
"QADIR Maryam NaN 4.00 3 \\RepT \\RepT \n",
"SAIDANE Maissa NaN 4.00 1 \\RepT \\RepT \n",
"SILVA Andre Luis NaN 3.33 1 \\RepD \\RepT \n",
"STAUFF Léna NaN 3.33 2 \\RepD \\RepT "
]
},
"execution_count": 102,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"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.4.3"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Reference in New Issue Copy Permalink