2014-2015/1er_STMG/DM/DM_0403/Bilan/Bilan DM_0403.ipynb
2017-06-16 09:48:07 +03:00

2375 lines
93 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

{
"cells": [
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"import pandas as pd\n",
"from texenv import texenv\n",
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"ds_name = \"DM_0403\"\n",
"classe = \"1stmg\""
]
},
{
"cell_type": "code",
"execution_count": 23,
"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": 24,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"Index(['DM_0403', 'av_arrondi', 'Exercice 1', 1, 2, 3, '1 Malus', 'Exercice 2', '1.a (tableau valeurs)', '1.b (lecture tableau)', '2.a (dériver)', '2.b (étude de signe)', '2.c (tableau de variations)', '2.d (Maximum)', '2.e (minimum)', '2.f (allure de la courbe)', '3.a (simplification)', '3.b (dériver)', '3.c (étude de signe)', '3.d (tableau de variations)', '3.e (Maximum)', '3.f (minimum)', '2 Malus'], dtype='object')"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes.index"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"notes = notes.T"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes.drop(\"av_arrondi\", axis=1)\n",
"notes = notes.drop(\"1.b (lecture tableau)\", axis=1)"
]
},
{
"cell_type": "code",
"execution_count": 27,
"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_0403</th>\n",
" <th>Exercice 1</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>1 Malus</th>\n",
" <th>Exercice 2</th>\n",
" <th>1.a (tableau valeurs)</th>\n",
" <th>2.a (dériver)</th>\n",
" <th>2.b (étude de signe)</th>\n",
" <th>...</th>\n",
" <th>2.d (Maximum)</th>\n",
" <th>2.e (minimum)</th>\n",
" <th>2.f (allure de la courbe)</th>\n",
" <th>3.a (simplification)</th>\n",
" <th>3.b (dériver)</th>\n",
" <th>3.c (étude de signe)</th>\n",
" <th>3.d (tableau de variations)</th>\n",
" <th>3.e (Maximum)</th>\n",
" <th>3.f (minimum)</th>\n",
" <th>2 Malus</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>AHRAM Anyssa</th>\n",
" <td>10.0</td>\n",
" <td>2.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>5.333333</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AISSA Reda</th>\n",
" <td>12.0</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>7.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BENALIA Nassim</th>\n",
" <td>10.0</td>\n",
" <td>2.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>5.333333</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BOUCETTA M'hamed</th>\n",
" <td>16.5</td>\n",
" <td>2.333333</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>10.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DA COSTA SANTOS Pauline</th>\n",
" <td>14.0</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>9.000000</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DE SOUZA Laurencia</th>\n",
" <td>15.5</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>10.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DIA Anais</th>\n",
" <td>12.5</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>8.000000</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>-1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEINDREAU Anne Lyse</th>\n",
" <td>13.5</td>\n",
" <td>1.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>9.000000</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GIAHI KHOSHNAM Kimiya</th>\n",
" <td>12.5</td>\n",
" <td>3.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>7.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GOMES DOS SANTOS Mélina</th>\n",
" <td>17.0</td>\n",
" <td>3.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>10.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GOMES TAVARES Janice</th>\n",
" <td>7.0</td>\n",
" <td>1.666667</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>4.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>JOSEPH Lucie</th>\n",
" <td>17.0</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>11.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</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",
" </tr>\n",
" <tr>\n",
" <th>KENEMO Jordan</th>\n",
" <td>7.5</td>\n",
" <td>1.333333</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>4.666667</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAHBATI Baddredine</th>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>LELO Yokoche</th>\n",
" <td>19.0</td>\n",
" <td>2.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>12.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MBARKI Nesrin</th>\n",
" <td>14.0</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>9.000000</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEDJADIR Ikrame</th>\n",
" <td>19.5</td>\n",
" <td>2.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>13.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>MOUGAMADOUSOULEMANE Nasrin</th>\n",
" <td>19.0</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>-1</td>\n",
" <td>13.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>MOUMNI Mohamed</th>\n",
" <td>15.5</td>\n",
" <td>2.666667</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>9.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NKOUNKOU MOUANGASSA Primaëlle Allegresse</th>\n",
" <td>19.5</td>\n",
" <td>3.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>12.500000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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>-0.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PATRICK Alvin</th>\n",
" <td>17.5</td>\n",
" <td>3.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>11.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</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>-1.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVART Morgane</th>\n",
" <td>18.5</td>\n",
" <td>3.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>11.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Safarnyan Vakil</th>\n",
" <td>15.0</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>10.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SENKAL Kursad</th>\n",
" <td>15.5</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>10.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHABBIR Rukhssar</th>\n",
" <td>14.5</td>\n",
" <td>1.333333</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>10.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILMI Walid</th>\n",
" <td>0.0</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0.000000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>SOUPRAMANIANE Pavitra</th>\n",
" <td>19.0</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>13.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>TERBECHE Fatima</th>\n",
" <td>13.5</td>\n",
" <td>2.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>8.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UGURLU Rojin</th>\n",
" <td>19.0</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>13.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>VALERE Laureen</th>\n",
" <td>19.0</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>13.000000</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</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",
" </tr>\n",
" <tr>\n",
" <th>VAZ DE ALMEIDA Gabrielle</th>\n",
" <td>16.5</td>\n",
" <td>2.333333</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" <td>10.666667</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>31 rows × 21 columns</p>\n",
"</div>"
],
"text/plain": [
" DM_0403 Exercice 1 1 2 3 \\\n",
"AHRAM Anyssa 10.0 2.666667 3 2 3 \n",
"AISSA Reda 12.0 2.333333 3 3 1 \n",
"BENALIA Nassim 10.0 2.666667 3 2 3 \n",
"BOUCETTA M'hamed 16.5 2.333333 2 2 3 \n",
"DA COSTA SANTOS Pauline 14.0 2.000000 3 3 0 \n",
"DE SOUZA Laurencia 15.5 2.333333 3 3 1 \n",
"DIA Anais 12.5 2.000000 3 2 1 \n",
"GEINDREAU Anne Lyse 13.5 1.666667 3 2 NaN \n",
"GIAHI KHOSHNAM Kimiya 12.5 3.000000 3 3 3 \n",
"GOMES DOS SANTOS Mélina 17.0 3.000000 3 3 3 \n",
"GOMES TAVARES Janice 7.0 1.666667 2 2 1 \n",
"JOSEPH Lucie 17.0 2.000000 3 3 0 \n",
"KENEMO Jordan 7.5 1.333333 2 1 1 \n",
"LAHBATI Baddredine 0.0 0.000000 NaN NaN NaN \n",
"LELO Yokoche 19.0 2.666667 3 3 2 \n",
"MBARKI Nesrin 14.0 2.333333 3 2 2 \n",
"MEDJADIR Ikrame 19.5 2.666667 3 2 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 19.0 2.000000 3 3 3 \n",
"MOUMNI Mohamed 15.5 2.666667 3 2 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 19.5 3.000000 3 3 3 \n",
"PATRICK Alvin 17.5 3.000000 3 3 3 \n",
"RIVART Morgane 18.5 3.000000 3 3 3 \n",
"Safarnyan Vakil 15.0 2.000000 3 3 NaN \n",
"SENKAL Kursad 15.5 2.000000 3 2 1 \n",
"SHABBIR Rukhssar 14.5 1.333333 3 1 0 \n",
"SILMI Walid 0.0 0.000000 NaN NaN NaN \n",
"SOUPRAMANIANE Pavitra 19.0 2.333333 3 2 2 \n",
"TERBECHE Fatima 13.5 2.000000 3 3 0 \n",
"UGURLU Rojin 19.0 2.333333 3 3 1 \n",
"VALERE Laureen 19.0 2.333333 3 3 1 \n",
"VAZ DE ALMEIDA Gabrielle 16.5 2.333333 3 2 2 \n",
"\n",
" 1 Malus Exercice 2 \\\n",
"AHRAM Anyssa NaN 5.333333 \n",
"AISSA Reda NaN 7.333333 \n",
"BENALIA Nassim NaN 5.333333 \n",
"BOUCETTA M'hamed NaN 10.666667 \n",
"DA COSTA SANTOS Pauline NaN 9.000000 \n",
"DE SOUZA Laurencia NaN 10.000000 \n",
"DIA Anais NaN 8.000000 \n",
"GEINDREAU Anne Lyse NaN 9.000000 \n",
"GIAHI KHOSHNAM Kimiya NaN 7.000000 \n",
"GOMES DOS SANTOS Mélina NaN 10.666667 \n",
"GOMES TAVARES Janice NaN 4.000000 \n",
"JOSEPH Lucie NaN 11.666667 \n",
"KENEMO Jordan NaN 4.666667 \n",
"LAHBATI Baddredine NaN 0.000000 \n",
"LELO Yokoche NaN 12.666667 \n",
"MBARKI Nesrin NaN 9.000000 \n",
"MEDJADIR Ikrame NaN 13.000000 \n",
"MOUGAMADOUSOULEMANE Nasrin -1 13.000000 \n",
"MOUMNI Mohamed NaN 9.666667 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse NaN 12.500000 \n",
"PATRICK Alvin NaN 11.000000 \n",
"RIVART Morgane NaN 11.666667 \n",
"Safarnyan Vakil NaN 10.000000 \n",
"SENKAL Kursad NaN 10.333333 \n",
"SHABBIR Rukhssar NaN 10.333333 \n",
"SILMI Walid NaN 0.000000 \n",
"SOUPRAMANIANE Pavitra NaN 13.000000 \n",
"TERBECHE Fatima NaN 8.666667 \n",
"UGURLU Rojin NaN 13.000000 \n",
"VALERE Laureen NaN 13.000000 \n",
"VAZ DE ALMEIDA Gabrielle NaN 10.666667 \n",
"\n",
" 1.a (tableau valeurs) \\\n",
"AHRAM Anyssa 3 \n",
"AISSA Reda 3 \n",
"BENALIA Nassim 3 \n",
"BOUCETTA M'hamed 3 \n",
"DA COSTA SANTOS Pauline 3 \n",
"DE SOUZA Laurencia 3 \n",
"DIA Anais NaN \n",
"GEINDREAU Anne Lyse NaN \n",
"GIAHI KHOSHNAM Kimiya 3 \n",
"GOMES DOS SANTOS Mélina 3 \n",
"GOMES TAVARES Janice 3 \n",
"JOSEPH Lucie 3 \n",
"KENEMO Jordan 3 \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche 3 \n",
"MBARKI Nesrin 3 \n",
"MEDJADIR Ikrame 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
"MOUMNI Mohamed 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
"PATRICK Alvin 3 \n",
"RIVART Morgane 3 \n",
"Safarnyan Vakil 3 \n",
"SENKAL Kursad 3 \n",
"SHABBIR Rukhssar 3 \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra 3 \n",
"TERBECHE Fatima 3 \n",
"UGURLU Rojin 3 \n",
"VALERE Laureen 3 \n",
"VAZ DE ALMEIDA Gabrielle 3 \n",
"\n",
" 2.a (dériver) 2.b (étude de signe) \\\n",
"AHRAM Anyssa 0 1 \n",
"AISSA Reda 3 3 \n",
"BENALIA Nassim 2 1 \n",
"BOUCETTA M'hamed 3 3 \n",
"DA COSTA SANTOS Pauline 2 3 \n",
"DE SOUZA Laurencia 3 3 \n",
"DIA Anais 3 3 \n",
"GEINDREAU Anne Lyse 3 3 \n",
"GIAHI KHOSHNAM Kimiya 3 3 \n",
"GOMES DOS SANTOS Mélina 3 3 \n",
"GOMES TAVARES Janice 3 3 \n",
"JOSEPH Lucie 3 3 \n",
"KENEMO Jordan 0 2 \n",
"LAHBATI Baddredine NaN NaN \n",
"LELO Yokoche 3 3 \n",
"MBARKI Nesrin 1 2 \n",
"MEDJADIR Ikrame 3 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 3 \n",
"MOUMNI Mohamed 3 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 3 \n",
"PATRICK Alvin 3 3 \n",
"RIVART Morgane 3 3 \n",
"Safarnyan Vakil 3 3 \n",
"SENKAL Kursad 3 3 \n",
"SHABBIR Rukhssar 3 3 \n",
"SILMI Walid NaN NaN \n",
"SOUPRAMANIANE Pavitra 3 3 \n",
"TERBECHE Fatima 3 3 \n",
"UGURLU Rojin 3 3 \n",
"VALERE Laureen 3 3 \n",
"VAZ DE ALMEIDA Gabrielle 3 3 \n",
"\n",
" ... 2.d (Maximum) \\\n",
"AHRAM Anyssa ... 0 \n",
"AISSA Reda ... 0 \n",
"BENALIA Nassim ... 2 \n",
"BOUCETTA M'hamed ... 3 \n",
"DA COSTA SANTOS Pauline ... 3 \n",
"DE SOUZA Laurencia ... 3 \n",
"DIA Anais ... 2 \n",
"GEINDREAU Anne Lyse ... 2 \n",
"GIAHI KHOSHNAM Kimiya ... 0 \n",
"GOMES DOS SANTOS Mélina ... 3 \n",
"GOMES TAVARES Janice ... NaN \n",
"JOSEPH Lucie ... 3 \n",
"KENEMO Jordan ... 0 \n",
"LAHBATI Baddredine ... NaN \n",
"LELO Yokoche ... 3 \n",
"MBARKI Nesrin ... 2 \n",
"MEDJADIR Ikrame ... 3 \n",
"MOUGAMADOUSOULEMANE Nasrin ... 3 \n",
"MOUMNI Mohamed ... 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse ... 3 \n",
"PATRICK Alvin ... 3 \n",
"RIVART Morgane ... 3 \n",
"Safarnyan Vakil ... 3 \n",
"SENKAL Kursad ... 2 \n",
"SHABBIR Rukhssar ... 3 \n",
"SILMI Walid ... NaN \n",
"SOUPRAMANIANE Pavitra ... 3 \n",
"TERBECHE Fatima ... 0 \n",
"UGURLU Rojin ... 3 \n",
"VALERE Laureen ... 3 \n",
"VAZ DE ALMEIDA Gabrielle ... 2 \n",
"\n",
" 2.e (minimum) \\\n",
"AHRAM Anyssa 0 \n",
"AISSA Reda 0 \n",
"BENALIA Nassim 0 \n",
"BOUCETTA M'hamed 3 \n",
"DA COSTA SANTOS Pauline 3 \n",
"DE SOUZA Laurencia 3 \n",
"DIA Anais 1 \n",
"GEINDREAU Anne Lyse 2 \n",
"GIAHI KHOSHNAM Kimiya 0 \n",
"GOMES DOS SANTOS Mélina 3 \n",
"GOMES TAVARES Janice NaN \n",
"JOSEPH Lucie 3 \n",
"KENEMO Jordan 0 \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche 3 \n",
"MBARKI Nesrin 2 \n",
"MEDJADIR Ikrame 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
"MOUMNI Mohamed 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
"PATRICK Alvin 3 \n",
"RIVART Morgane 3 \n",
"Safarnyan Vakil 3 \n",
"SENKAL Kursad 2 \n",
"SHABBIR Rukhssar 2 \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra 3 \n",
"TERBECHE Fatima 3 \n",
"UGURLU Rojin 3 \n",
"VALERE Laureen 3 \n",
"VAZ DE ALMEIDA Gabrielle 2 \n",
"\n",
" 2.f (allure de la courbe) \\\n",
"AHRAM Anyssa 2 \n",
"AISSA Reda 3 \n",
"BENALIA Nassim NaN \n",
"BOUCETTA M'hamed 3 \n",
"DA COSTA SANTOS Pauline 2 \n",
"DE SOUZA Laurencia 3 \n",
"DIA Anais 3 \n",
"GEINDREAU Anne Lyse 3 \n",
"GIAHI KHOSHNAM Kimiya 2 \n",
"GOMES DOS SANTOS Mélina 3 \n",
"GOMES TAVARES Janice NaN \n",
"JOSEPH Lucie 2 \n",
"KENEMO Jordan 2 \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche 2 \n",
"MBARKI Nesrin 2 \n",
"MEDJADIR Ikrame 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
"MOUMNI Mohamed 2 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
"PATRICK Alvin 2 \n",
"RIVART Morgane 3 \n",
"Safarnyan Vakil 3 \n",
"SENKAL Kursad 2 \n",
"SHABBIR Rukhssar 3 \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra 3 \n",
"TERBECHE Fatima 2 \n",
"UGURLU Rojin 3 \n",
"VALERE Laureen 3 \n",
"VAZ DE ALMEIDA Gabrielle 3 \n",
"\n",
" 3.a (simplification) 3.b (dériver) \\\n",
"AHRAM Anyssa NaN 3 \n",
"AISSA Reda NaN 3 \n",
"BENALIA Nassim NaN 2 \n",
"BOUCETTA M'hamed 1 1 \n",
"DA COSTA SANTOS Pauline NaN 2 \n",
"DE SOUZA Laurencia NaN 3 \n",
"DIA Anais NaN 3 \n",
"GEINDREAU Anne Lyse 3 3 \n",
"GIAHI KHOSHNAM Kimiya 0 3 \n",
"GOMES DOS SANTOS Mélina 2 1 \n",
"GOMES TAVARES Janice NaN NaN \n",
"JOSEPH Lucie 1 2 \n",
"KENEMO Jordan NaN 2 \n",
"LAHBATI Baddredine NaN NaN \n",
"LELO Yokoche 3 3 \n",
"MBARKI Nesrin 3 3 \n",
"MEDJADIR Ikrame 3 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 3 \n",
"MOUMNI Mohamed NaN 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 3 \n",
"PATRICK Alvin 1 3 \n",
"RIVART Morgane 3 3 \n",
"Safarnyan Vakil NaN 1 \n",
"SENKAL Kursad NaN 3 \n",
"SHABBIR Rukhssar 1 3 \n",
"SILMI Walid NaN NaN \n",
"SOUPRAMANIANE Pavitra 3 3 \n",
"TERBECHE Fatima 0 3 \n",
"UGURLU Rojin 3 3 \n",
"VALERE Laureen 3 3 \n",
"VAZ DE ALMEIDA Gabrielle 3 2 \n",
"\n",
" 3.c (étude de signe) \\\n",
"AHRAM Anyssa 2 \n",
"AISSA Reda 3 \n",
"BENALIA Nassim 2 \n",
"BOUCETTA M'hamed 2 \n",
"DA COSTA SANTOS Pauline 3 \n",
"DE SOUZA Laurencia 3 \n",
"DIA Anais 3 \n",
"GEINDREAU Anne Lyse 3 \n",
"GIAHI KHOSHNAM Kimiya 2 \n",
"GOMES DOS SANTOS Mélina 2 \n",
"GOMES TAVARES Janice NaN \n",
"JOSEPH Lucie 3 \n",
"KENEMO Jordan 2 \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche 3 \n",
"MBARKI Nesrin 2 \n",
"MEDJADIR Ikrame 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
"MOUMNI Mohamed 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
"PATRICK Alvin 3 \n",
"RIVART Morgane 2 \n",
"Safarnyan Vakil 2 \n",
"SENKAL Kursad 3 \n",
"SHABBIR Rukhssar 2 \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra 3 \n",
"TERBECHE Fatima 3 \n",
"UGURLU Rojin 3 \n",
"VALERE Laureen 3 \n",
"VAZ DE ALMEIDA Gabrielle 2 \n",
"\n",
" 3.d (tableau de variations) \\\n",
"AHRAM Anyssa 3 \n",
"AISSA Reda 2 \n",
"BENALIA Nassim 2 \n",
"BOUCETTA M'hamed 2 \n",
"DA COSTA SANTOS Pauline 3 \n",
"DE SOUZA Laurencia 3 \n",
"DIA Anais 3 \n",
"GEINDREAU Anne Lyse 2 \n",
"GIAHI KHOSHNAM Kimiya 2 \n",
"GOMES DOS SANTOS Mélina 2 \n",
"GOMES TAVARES Janice NaN \n",
"JOSEPH Lucie 3 \n",
"KENEMO Jordan 1 \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche 3 \n",
"MBARKI Nesrin 2 \n",
"MEDJADIR Ikrame 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
"MOUMNI Mohamed 3 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
"PATRICK Alvin 3 \n",
"RIVART Morgane 2 \n",
"Safarnyan Vakil 2 \n",
"SENKAL Kursad 3 \n",
"SHABBIR Rukhssar 1 \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra 3 \n",
"TERBECHE Fatima 3 \n",
"UGURLU Rojin 3 \n",
"VALERE Laureen 3 \n",
"VAZ DE ALMEIDA Gabrielle 2 \n",
"\n",
" 3.e (Maximum) 3.f (minimum) \\\n",
"AHRAM Anyssa 0 0 \n",
"AISSA Reda 0 0 \n",
"BENALIA Nassim NaN NaN \n",
"BOUCETTA M'hamed 3 2 \n",
"DA COSTA SANTOS Pauline NaN NaN \n",
"DE SOUZA Laurencia NaN NaN \n",
"DIA Anais 2 1 \n",
"GEINDREAU Anne Lyse NaN NaN \n",
"GIAHI KHOSHNAM Kimiya 0 0 \n",
"GOMES DOS SANTOS Mélina 2 2 \n",
"GOMES TAVARES Janice NaN NaN \n",
"JOSEPH Lucie 3 3 \n",
"KENEMO Jordan NaN NaN \n",
"LAHBATI Baddredine NaN NaN \n",
"LELO Yokoche 3 3 \n",
"MBARKI Nesrin 2 2 \n",
"MEDJADIR Ikrame 3 3 \n",
"MOUGAMADOUSOULEMANE Nasrin 3 3 \n",
"MOUMNI Mohamed 0 0 \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 3 \n",
"PATRICK Alvin 3 3 \n",
"RIVART Morgane 2 2 \n",
"Safarnyan Vakil 2 2 \n",
"SENKAL Kursad 2 2 \n",
"SHABBIR Rukhssar 2 2 \n",
"SILMI Walid NaN NaN \n",
"SOUPRAMANIANE Pavitra 3 3 \n",
"TERBECHE Fatima NaN NaN \n",
"UGURLU Rojin 3 3 \n",
"VALERE Laureen 3 3 \n",
"VAZ DE ALMEIDA Gabrielle 2 2 \n",
"\n",
" 2 Malus \n",
"AHRAM Anyssa NaN \n",
"AISSA Reda NaN \n",
"BENALIA Nassim NaN \n",
"BOUCETTA M'hamed NaN \n",
"DA COSTA SANTOS Pauline NaN \n",
"DE SOUZA Laurencia NaN \n",
"DIA Anais -1.0 \n",
"GEINDREAU Anne Lyse NaN \n",
"GIAHI KHOSHNAM Kimiya NaN \n",
"GOMES DOS SANTOS Mélina NaN \n",
"GOMES TAVARES Janice NaN \n",
"JOSEPH Lucie NaN \n",
"KENEMO Jordan NaN \n",
"LAHBATI Baddredine NaN \n",
"LELO Yokoche NaN \n",
"MBARKI Nesrin NaN \n",
"MEDJADIR Ikrame NaN \n",
"MOUGAMADOUSOULEMANE Nasrin NaN \n",
"MOUMNI Mohamed NaN \n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse -0.5 \n",
"PATRICK Alvin -1.0 \n",
"RIVART Morgane NaN \n",
"Safarnyan Vakil NaN \n",
"SENKAL Kursad NaN \n",
"SHABBIR Rukhssar NaN \n",
"SILMI Walid NaN \n",
"SOUPRAMANIANE Pavitra NaN \n",
"TERBECHE Fatima NaN \n",
"UGURLU Rojin NaN \n",
"VALERE Laureen NaN \n",
"VAZ DE ALMEIDA Gabrielle NaN \n",
"\n",
"[31 rows x 21 columns]"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"barem = notes[:1]\n",
"notes = notes[1:]\n",
"notes"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes[notes[ds_name].notnull()]\n",
"#notes"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes = notes.astype(float)"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"count 31.000000\n",
"mean 14.177419\n",
"std 5.098281\n",
"min 0.000000\n",
"25% 12.500000\n",
"50% 15.500000\n",
"75% 18.000000\n",
"max 19.500000\n",
"Name: DM_0403, dtype: float64"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"notes[ds_name].describe()"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"list_exo = [\"Exercice 1\", \"Exercice 2\"]"
]
},
{
"cell_type": "code",
"execution_count": 32,
"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>AHRAM Anyssa</th>\n",
" <td>2.67</td>\n",
" <td>5.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>AISSA Reda</th>\n",
" <td>2.33</td>\n",
" <td>7.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BENALIA Nassim</th>\n",
" <td>2.67</td>\n",
" <td>5.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>BOUCETTA M'hamed</th>\n",
" <td>2.33</td>\n",
" <td>10.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DA COSTA SANTOS Pauline</th>\n",
" <td>2.00</td>\n",
" <td>9.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DE SOUZA Laurencia</th>\n",
" <td>2.33</td>\n",
" <td>10.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DIA Anais</th>\n",
" <td>2.00</td>\n",
" <td>8.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GEINDREAU Anne Lyse</th>\n",
" <td>1.67</td>\n",
" <td>9.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GIAHI KHOSHNAM Kimiya</th>\n",
" <td>3.00</td>\n",
" <td>7.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GOMES DOS SANTOS Mélina</th>\n",
" <td>3.00</td>\n",
" <td>10.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GOMES TAVARES Janice</th>\n",
" <td>1.67</td>\n",
" <td>4.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>JOSEPH Lucie</th>\n",
" <td>2.00</td>\n",
" <td>11.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>KENEMO Jordan</th>\n",
" <td>1.33</td>\n",
" <td>4.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LAHBATI Baddredine</th>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>LELO Yokoche</th>\n",
" <td>2.67</td>\n",
" <td>12.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MBARKI Nesrin</th>\n",
" <td>2.33</td>\n",
" <td>9.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MEDJADIR Ikrame</th>\n",
" <td>2.67</td>\n",
" <td>13.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOUGAMADOUSOULEMANE Nasrin</th>\n",
" <td>2.00</td>\n",
" <td>13.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MOUMNI Mohamed</th>\n",
" <td>2.67</td>\n",
" <td>9.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NKOUNKOU MOUANGASSA Primaëlle Allegresse</th>\n",
" <td>3.00</td>\n",
" <td>12.50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>PATRICK Alvin</th>\n",
" <td>3.00</td>\n",
" <td>11.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>RIVART Morgane</th>\n",
" <td>3.00</td>\n",
" <td>11.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Safarnyan Vakil</th>\n",
" <td>2.00</td>\n",
" <td>10.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SENKAL Kursad</th>\n",
" <td>2.00</td>\n",
" <td>10.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SHABBIR Rukhssar</th>\n",
" <td>1.33</td>\n",
" <td>10.33</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SILMI Walid</th>\n",
" <td>0.00</td>\n",
" <td>0.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>SOUPRAMANIANE Pavitra</th>\n",
" <td>2.33</td>\n",
" <td>13.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>TERBECHE Fatima</th>\n",
" <td>2.00</td>\n",
" <td>8.67</td>\n",
" </tr>\n",
" <tr>\n",
" <th>UGURLU Rojin</th>\n",
" <td>2.33</td>\n",
" <td>13.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VALERE Laureen</th>\n",
" <td>2.33</td>\n",
" <td>13.00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>VAZ DE ALMEIDA Gabrielle</th>\n",
" <td>2.33</td>\n",
" <td>10.67</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Exercice 1 Exercice 2\n",
"AHRAM Anyssa 2.67 5.33\n",
"AISSA Reda 2.33 7.33\n",
"BENALIA Nassim 2.67 5.33\n",
"BOUCETTA M'hamed 2.33 10.67\n",
"DA COSTA SANTOS Pauline 2.00 9.00\n",
"DE SOUZA Laurencia 2.33 10.00\n",
"DIA Anais 2.00 8.00\n",
"GEINDREAU Anne Lyse 1.67 9.00\n",
"GIAHI KHOSHNAM Kimiya 3.00 7.00\n",
"GOMES DOS SANTOS Mélina 3.00 10.67\n",
"GOMES TAVARES Janice 1.67 4.00\n",
"JOSEPH Lucie 2.00 11.67\n",
"KENEMO Jordan 1.33 4.67\n",
"LAHBATI Baddredine 0.00 0.00\n",
"LELO Yokoche 2.67 12.67\n",
"MBARKI Nesrin 2.33 9.00\n",
"MEDJADIR Ikrame 2.67 13.00\n",
"MOUGAMADOUSOULEMANE Nasrin 2.00 13.00\n",
"MOUMNI Mohamed 2.67 9.67\n",
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3.00 12.50\n",
"PATRICK Alvin 3.00 11.00\n",
"RIVART Morgane 3.00 11.67\n",
"Safarnyan Vakil 2.00 10.00\n",
"SENKAL Kursad 2.00 10.33\n",
"SHABBIR Rukhssar 1.33 10.33\n",
"SILMI Walid 0.00 0.00\n",
"SOUPRAMANIANE Pavitra 2.33 13.00\n",
"TERBECHE Fatima 2.00 8.67\n",
"UGURLU Rojin 2.33 13.00\n",
"VALERE Laureen 2.33 13.00\n",
"VAZ DE ALMEIDA Gabrielle 2.33 10.67"
]
},
"execution_count": 32,
"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": 33,
"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": 34,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[1,\n",
" 2,\n",
" 3,\n",
" '1.a (tableau valeurs)',\n",
" '2.a (dériver)',\n",
" '2.b (étude de signe)',\n",
" '2.c (tableau de variations)',\n",
" '2.d (Maximum)',\n",
" '2.e (minimum)',\n",
" '2.f (allure de la courbe)',\n",
" '3.a (simplification)',\n",
" '3.b (dériver)',\n",
" '3.c (étude de signe)',\n",
" '3.d (tableau de variations)',\n",
" '3.e (Maximum)',\n",
" '3.f (minimum)']"
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sous_exo = [i for i in notes.T.index if i not in list_exo + [ds_name, \"Bonus\", \"1 Malus\",\"2 Malus\",]]\n",
"sous_exo"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"notes[sous_exo] = notes[sous_exo].applymap(toRepVal)"
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"21"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(notes.T.index)"
]
},
{
"cell_type": "code",
"execution_count": 39,
"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
}