2058 lines
80 KiB
Plaintext
2058 lines
80 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 10,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"import pandas as pd\n",
|
|
"from texenv import texenv\n",
|
|
"%matplotlib inline"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 11,
|
|
"metadata": {
|
|
"collapsed": true
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"ds_name = \"DS_0410\"\n",
|
|
"classe = \"1stmg\""
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 12,
|
|
"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": 13,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"Index(['DS_0410', 'av_arrondi', 'Exercice 1', '1 (tracer fonction)', '2 (inéquation)', 'Exercice 2', '1.a (lecture graphique)', '1.b (proportion)', '1.c (lecture graphique)', '1.d (lecture graphique)', '2.a (dérivation)', '2.b (etude de signe)', '2.c (maximum)', 'Exercice 3 (QCM)'], dtype='object')"
|
|
]
|
|
},
|
|
"execution_count": 13,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"source": [
|
|
"notes.index"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 14,
|
|
"metadata": {
|
|
"collapsed": true
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"notes = notes.T"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 15,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"notes = notes.drop(\"av_arrondi\", axis=1)"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 16,
|
|
"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>DS_0410</th>\n",
|
|
" <th>Exercice 1</th>\n",
|
|
" <th>1 (tracer fonction)</th>\n",
|
|
" <th>2 (inéquation)</th>\n",
|
|
" <th>Exercice 2</th>\n",
|
|
" <th>1.a (lecture graphique)</th>\n",
|
|
" <th>1.b (proportion)</th>\n",
|
|
" <th>1.c (lecture graphique)</th>\n",
|
|
" <th>1.d (lecture graphique)</th>\n",
|
|
" <th>2.a (dérivation)</th>\n",
|
|
" <th>2.b (etude de signe)</th>\n",
|
|
" <th>2.c (maximum)</th>\n",
|
|
" <th>Exercice 3 (QCM)</th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th>AHRAM Anyssa</th>\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>NaN</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>AISSA Reda</th>\n",
|
|
" <td>12.0</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>7.166667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>BENALIA Nassim</th>\n",
|
|
" <td>8.5</td>\n",
|
|
" <td>1.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</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",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>BOUCETTA M'hamed</th>\n",
|
|
" <td>13.0</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>8.666667</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>3</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DA COSTA SANTOS Pauline</th>\n",
|
|
" <td>7.0</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>5.166667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DE SOUZA Laurencia</th>\n",
|
|
" <td>12.5</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>6.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DIA Anais</th>\n",
|
|
" <td>9.5</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GEINDREAU Anne Lyse</th>\n",
|
|
" <td>15.0</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>10.000000</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.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GIAHI KHOSHNAM Kimiya</th>\n",
|
|
" <td>9.5</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>4.500000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GOMES DOS SANTOS Mélina</th>\n",
|
|
" <td>13.5</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>6.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GOMES TAVARES Janice</th>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0.000000</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>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>9.5</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>KENEMO Jordan</th>\n",
|
|
" <td>7.0</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>LAHBATI Baddredine</th>\n",
|
|
" <td>8.0</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>LELO Yokoche</th>\n",
|
|
" <td>14.0</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>9.000000</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>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MBARKI Nesrin</th>\n",
|
|
" <td>14.5</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>8.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MEDJADIR Ikrame</th>\n",
|
|
" <td>10.5</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>5.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MOUGAMADOUSOULEMANE Nasrin</th>\n",
|
|
" <td>8.0</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MOUMNI Mohamed</th>\n",
|
|
" <td>10.0</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>5.000000</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>NKOUNKOU MOUANGASSA Primaëlle Allegresse</th>\n",
|
|
" <td>14.5</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>8.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>PATRICK Alvin</th>\n",
|
|
" <td>11.5</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>7.500000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>RIVART Morgane</th>\n",
|
|
" <td>17.0</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>10.000000</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.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Safarnyan Vakil</th>\n",
|
|
" <td>7.0</td>\n",
|
|
" <td>0.666667</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>3.500000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SENKAL Kursad</th>\n",
|
|
" <td>12.0</td>\n",
|
|
" <td>1.333333</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>9.166667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SHABBIR Rukhssar</th>\n",
|
|
" <td>12.0</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>5.500000</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>1</td>\n",
|
|
" <td>4.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SILMI Walid</th>\n",
|
|
" <td>8.0</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>4.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SOUPRAMANIANE Pavitra</th>\n",
|
|
" <td>11.5</td>\n",
|
|
" <td>3.333333</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>6.500000</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>TERBECHE Fatima</th>\n",
|
|
" <td>12.5</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>7.333333</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>UGURLU Rojin</th>\n",
|
|
" <td>12.5</td>\n",
|
|
" <td>2.666667</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>1</td>\n",
|
|
" <td>6.666667</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>VALERE Laureen</th>\n",
|
|
" <td>11.0</td>\n",
|
|
" <td>2.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>7.500000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>0</td>\n",
|
|
" <td>NaN</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>2</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>VAZ DE ALMEIDA Gabrielle</th>\n",
|
|
" <td>16.5</td>\n",
|
|
" <td>4.000000</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>3</td>\n",
|
|
" <td>9.666667</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.0</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"text/plain": [
|
|
" DS_0410 Exercice 1 \\\n",
|
|
"AHRAM Anyssa NaN NaN \n",
|
|
"AISSA Reda 12.0 3.333333 \n",
|
|
"BENALIA Nassim 8.5 1.333333 \n",
|
|
"BOUCETTA M'hamed 13.0 2.666667 \n",
|
|
"DA COSTA SANTOS Pauline 7.0 2.000000 \n",
|
|
"DE SOUZA Laurencia 12.5 2.666667 \n",
|
|
"DIA Anais 9.5 4.000000 \n",
|
|
"GEINDREAU Anne Lyse 15.0 4.000000 \n",
|
|
"GIAHI KHOSHNAM Kimiya 9.5 3.333333 \n",
|
|
"GOMES DOS SANTOS Mélina 13.5 4.000000 \n",
|
|
"GOMES TAVARES Janice NaN 0.000000 \n",
|
|
"JOSEPH Lucie 9.5 2.666667 \n",
|
|
"KENEMO Jordan 7.0 2.666667 \n",
|
|
"LAHBATI Baddredine 8.0 2.000000 \n",
|
|
"LELO Yokoche 14.0 3.333333 \n",
|
|
"MBARKI Nesrin 14.5 3.333333 \n",
|
|
"MEDJADIR Ikrame 10.5 2.000000 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 8.0 2.666667 \n",
|
|
"MOUMNI Mohamed 10.0 3.333333 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 14.5 3.333333 \n",
|
|
"PATRICK Alvin 11.5 2.666667 \n",
|
|
"RIVART Morgane 17.0 4.000000 \n",
|
|
"Safarnyan Vakil 7.0 0.666667 \n",
|
|
"SENKAL Kursad 12.0 1.333333 \n",
|
|
"SHABBIR Rukhssar 12.0 2.000000 \n",
|
|
"SILMI Walid 8.0 2.000000 \n",
|
|
"SOUPRAMANIANE Pavitra 11.5 3.333333 \n",
|
|
"TERBECHE Fatima 12.5 2.000000 \n",
|
|
"UGURLU Rojin 12.5 2.666667 \n",
|
|
"VALERE Laureen 11.0 2.000000 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 16.5 4.000000 \n",
|
|
"\n",
|
|
" 1 (tracer fonction) 2 (inéquation) \\\n",
|
|
"AHRAM Anyssa NaN NaN \n",
|
|
"AISSA Reda 3 2 \n",
|
|
"BENALIA Nassim 2 NaN \n",
|
|
"BOUCETTA M'hamed 3 1 \n",
|
|
"DA COSTA SANTOS Pauline 3 NaN \n",
|
|
"DE SOUZA Laurencia 2 2 \n",
|
|
"DIA Anais 3 3 \n",
|
|
"GEINDREAU Anne Lyse 3 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 2 3 \n",
|
|
"GOMES DOS SANTOS Mélina 3 3 \n",
|
|
"GOMES TAVARES Janice NaN NaN \n",
|
|
"JOSEPH Lucie 1 3 \n",
|
|
"KENEMO Jordan 2 2 \n",
|
|
"LAHBATI Baddredine 3 0 \n",
|
|
"LELO Yokoche 3 2 \n",
|
|
"MBARKI Nesrin 2 3 \n",
|
|
"MEDJADIR Ikrame 0 3 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 3 1 \n",
|
|
"MOUMNI Mohamed 2 3 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 2 3 \n",
|
|
"PATRICK Alvin 1 3 \n",
|
|
"RIVART Morgane 3 3 \n",
|
|
"Safarnyan Vakil 1 NaN \n",
|
|
"SENKAL Kursad 1 1 \n",
|
|
"SHABBIR Rukhssar 3 0 \n",
|
|
"SILMI Walid 3 0 \n",
|
|
"SOUPRAMANIANE Pavitra 2 3 \n",
|
|
"TERBECHE Fatima 2 1 \n",
|
|
"UGURLU Rojin 3 1 \n",
|
|
"VALERE Laureen 3 0 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3 3 \n",
|
|
"\n",
|
|
" Exercice 2 1.a (lecture graphique) \\\n",
|
|
"AHRAM Anyssa NaN NaN \n",
|
|
"AISSA Reda 7.166667 3 \n",
|
|
"BENALIA Nassim 4.000000 3 \n",
|
|
"BOUCETTA M'hamed 8.666667 2 \n",
|
|
"DA COSTA SANTOS Pauline 5.166667 3 \n",
|
|
"DE SOUZA Laurencia 6.666667 3 \n",
|
|
"DIA Anais 4.000000 3 \n",
|
|
"GEINDREAU Anne Lyse 10.000000 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 4.500000 3 \n",
|
|
"GOMES DOS SANTOS Mélina 6.666667 3 \n",
|
|
"GOMES TAVARES Janice 0.000000 NaN \n",
|
|
"JOSEPH Lucie 4.000000 2 \n",
|
|
"KENEMO Jordan 2.666667 2 \n",
|
|
"LAHBATI Baddredine 3.666667 3 \n",
|
|
"LELO Yokoche 9.000000 3 \n",
|
|
"MBARKI Nesrin 8.000000 3 \n",
|
|
"MEDJADIR Ikrame 5.666667 3 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 4.000000 3 \n",
|
|
"MOUMNI Mohamed 5.000000 1 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 8.000000 3 \n",
|
|
"PATRICK Alvin 7.500000 3 \n",
|
|
"RIVART Morgane 10.000000 3 \n",
|
|
"Safarnyan Vakil 3.500000 3 \n",
|
|
"SENKAL Kursad 9.166667 3 \n",
|
|
"SHABBIR Rukhssar 5.500000 3 \n",
|
|
"SILMI Walid 4.666667 3 \n",
|
|
"SOUPRAMANIANE Pavitra 6.500000 2 \n",
|
|
"TERBECHE Fatima 7.333333 3 \n",
|
|
"UGURLU Rojin 6.666667 2 \n",
|
|
"VALERE Laureen 7.500000 3 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 9.666667 3 \n",
|
|
"\n",
|
|
" 1.b (proportion) \\\n",
|
|
"AHRAM Anyssa NaN \n",
|
|
"AISSA Reda 2 \n",
|
|
"BENALIA Nassim 3 \n",
|
|
"BOUCETTA M'hamed 3 \n",
|
|
"DA COSTA SANTOS Pauline 2 \n",
|
|
"DE SOUZA Laurencia NaN \n",
|
|
"DIA Anais NaN \n",
|
|
"GEINDREAU Anne Lyse 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 0 \n",
|
|
"GOMES DOS SANTOS Mélina 3 \n",
|
|
"GOMES TAVARES Janice NaN \n",
|
|
"JOSEPH Lucie 0 \n",
|
|
"KENEMO Jordan 2 \n",
|
|
"LAHBATI Baddredine 3 \n",
|
|
"LELO Yokoche 3 \n",
|
|
"MBARKI Nesrin 3 \n",
|
|
"MEDJADIR Ikrame NaN \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 3 \n",
|
|
"MOUMNI Mohamed NaN \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3 \n",
|
|
"PATRICK Alvin 3 \n",
|
|
"RIVART Morgane 3 \n",
|
|
"Safarnyan Vakil NaN \n",
|
|
"SENKAL Kursad 2 \n",
|
|
"SHABBIR Rukhssar NaN \n",
|
|
"SILMI Walid 3 \n",
|
|
"SOUPRAMANIANE Pavitra 2 \n",
|
|
"TERBECHE Fatima NaN \n",
|
|
"UGURLU Rojin 0 \n",
|
|
"VALERE Laureen 0 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3 \n",
|
|
"\n",
|
|
" 1.c (lecture graphique) \\\n",
|
|
"AHRAM Anyssa NaN \n",
|
|
"AISSA Reda 3 \n",
|
|
"BENALIA Nassim 3 \n",
|
|
"BOUCETTA M'hamed 3 \n",
|
|
"DA COSTA SANTOS Pauline 0 \n",
|
|
"DE SOUZA Laurencia 0 \n",
|
|
"DIA Anais NaN \n",
|
|
"GEINDREAU Anne Lyse 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 0 \n",
|
|
"GOMES DOS SANTOS Mélina 2 \n",
|
|
"GOMES TAVARES Janice NaN \n",
|
|
"JOSEPH Lucie 2 \n",
|
|
"KENEMO Jordan 1 \n",
|
|
"LAHBATI Baddredine 2 \n",
|
|
"LELO Yokoche 3 \n",
|
|
"MBARKI Nesrin 0 \n",
|
|
"MEDJADIR Ikrame NaN \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 0 \n",
|
|
"MOUMNI Mohamed NaN \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 0 \n",
|
|
"PATRICK Alvin 0 \n",
|
|
"RIVART Morgane 3 \n",
|
|
"Safarnyan Vakil 0 \n",
|
|
"SENKAL Kursad 3 \n",
|
|
"SHABBIR Rukhssar 1 \n",
|
|
"SILMI Walid 2 \n",
|
|
"SOUPRAMANIANE Pavitra 0 \n",
|
|
"TERBECHE Fatima 1 \n",
|
|
"UGURLU Rojin 0 \n",
|
|
"VALERE Laureen NaN \n",
|
|
"VAZ DE ALMEIDA Gabrielle 2 \n",
|
|
"\n",
|
|
" 1.d (lecture graphique) \\\n",
|
|
"AHRAM Anyssa NaN \n",
|
|
"AISSA Reda 3 \n",
|
|
"BENALIA Nassim 3 \n",
|
|
"BOUCETTA M'hamed 3 \n",
|
|
"DA COSTA SANTOS Pauline 3 \n",
|
|
"DE SOUZA Laurencia 2 \n",
|
|
"DIA Anais 3 \n",
|
|
"GEINDREAU Anne Lyse 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 3 \n",
|
|
"GOMES DOS SANTOS Mélina 3 \n",
|
|
"GOMES TAVARES Janice NaN \n",
|
|
"JOSEPH Lucie 2 \n",
|
|
"KENEMO Jordan 0 \n",
|
|
"LAHBATI Baddredine 3 \n",
|
|
"LELO Yokoche 3 \n",
|
|
"MBARKI Nesrin 3 \n",
|
|
"MEDJADIR Ikrame 2 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 2 \n",
|
|
"MOUMNI Mohamed 2 \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 2 \n",
|
|
"SILMI Walid 3 \n",
|
|
"SOUPRAMANIANE Pavitra 2 \n",
|
|
"TERBECHE Fatima 3 \n",
|
|
"UGURLU Rojin 3 \n",
|
|
"VALERE Laureen 3 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3 \n",
|
|
"\n",
|
|
" 2.a (dérivation) \\\n",
|
|
"AHRAM Anyssa NaN \n",
|
|
"AISSA Reda 3 \n",
|
|
"BENALIA Nassim NaN \n",
|
|
"BOUCETTA M'hamed 3 \n",
|
|
"DA COSTA SANTOS Pauline 3 \n",
|
|
"DE SOUZA Laurencia 3 \n",
|
|
"DIA Anais 2 \n",
|
|
"GEINDREAU Anne Lyse 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 3 \n",
|
|
"GOMES DOS SANTOS Mélina 2 \n",
|
|
"GOMES TAVARES Janice NaN \n",
|
|
"JOSEPH Lucie 2 \n",
|
|
"KENEMO Jordan 2 \n",
|
|
"LAHBATI Baddredine NaN \n",
|
|
"LELO Yokoche 3 \n",
|
|
"MBARKI Nesrin 3 \n",
|
|
"MEDJADIR Ikrame 2 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 2 \n",
|
|
"MOUMNI Mohamed 3 \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 2 \n",
|
|
"SILMI Walid 2 \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.b (etude de signe) 2.c (maximum) \\\n",
|
|
"AHRAM Anyssa NaN NaN \n",
|
|
"AISSA Reda 2 0 \n",
|
|
"BENALIA Nassim NaN NaN \n",
|
|
"BOUCETTA M'hamed 2 3 \n",
|
|
"DA COSTA SANTOS Pauline 1 NaN \n",
|
|
"DE SOUZA Laurencia 2 3 \n",
|
|
"DIA Anais 1 NaN \n",
|
|
"GEINDREAU Anne Lyse 3 3 \n",
|
|
"GIAHI KHOSHNAM Kimiya 1 NaN \n",
|
|
"GOMES DOS SANTOS Mélina 2 0 \n",
|
|
"GOMES TAVARES Janice NaN NaN \n",
|
|
"JOSEPH Lucie 1 0 \n",
|
|
"KENEMO Jordan NaN NaN \n",
|
|
"LAHBATI Baddredine NaN 0 \n",
|
|
"LELO Yokoche 2 3 \n",
|
|
"MBARKI Nesrin 3 1 \n",
|
|
"MEDJADIR Ikrame 3 0 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 0 NaN \n",
|
|
"MOUMNI Mohamed 2 1 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 2 3 \n",
|
|
"PATRICK Alvin 2 3 \n",
|
|
"RIVART Morgane 3 3 \n",
|
|
"Safarnyan Vakil NaN 0 \n",
|
|
"SENKAL Kursad 3 3 \n",
|
|
"SHABBIR Rukhssar 2 1 \n",
|
|
"SILMI Walid NaN NaN \n",
|
|
"SOUPRAMANIANE Pavitra 2 2 \n",
|
|
"TERBECHE Fatima 3 1 \n",
|
|
"UGURLU Rojin 2 3 \n",
|
|
"VALERE Laureen 3 2 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3 3 \n",
|
|
"\n",
|
|
" Exercice 3 (QCM) \n",
|
|
"AHRAM Anyssa NaN \n",
|
|
"AISSA Reda 1.5 \n",
|
|
"BENALIA Nassim 3.0 \n",
|
|
"BOUCETTA M'hamed 1.5 \n",
|
|
"DA COSTA SANTOS Pauline 0.0 \n",
|
|
"DE SOUZA Laurencia 3.0 \n",
|
|
"DIA Anais 1.5 \n",
|
|
"GEINDREAU Anne Lyse 1.0 \n",
|
|
"GIAHI KHOSHNAM Kimiya 1.5 \n",
|
|
"GOMES DOS SANTOS Mélina 3.0 \n",
|
|
"GOMES TAVARES Janice NaN \n",
|
|
"JOSEPH Lucie 3.0 \n",
|
|
"KENEMO Jordan 1.5 \n",
|
|
"LAHBATI Baddredine 2.5 \n",
|
|
"LELO Yokoche 1.5 \n",
|
|
"MBARKI Nesrin 3.0 \n",
|
|
"MEDJADIR Ikrame 3.0 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 1.5 \n",
|
|
"MOUMNI Mohamed 1.5 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3.0 \n",
|
|
"PATRICK Alvin 1.5 \n",
|
|
"RIVART Morgane 3.0 \n",
|
|
"Safarnyan Vakil 3.0 \n",
|
|
"SENKAL Kursad 1.5 \n",
|
|
"SHABBIR Rukhssar 4.5 \n",
|
|
"SILMI Walid 1.5 \n",
|
|
"SOUPRAMANIANE Pavitra 1.5 \n",
|
|
"TERBECHE Fatima 3.0 \n",
|
|
"UGURLU Rojin 3.0 \n",
|
|
"VALERE Laureen 1.5 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3.0 "
|
|
]
|
|
},
|
|
"execution_count": 16,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"source": [
|
|
"barem = notes[:1]\n",
|
|
"notes = notes[1:]\n",
|
|
"notes"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 17,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"notes = notes[notes[ds_name].notnull()]\n",
|
|
"#notes"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 18,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"notes = notes.astype(float)"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 19,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"count 29.000000\n",
|
|
"mean 11.310345\n",
|
|
"std 2.820251\n",
|
|
"min 7.000000\n",
|
|
"25% 9.500000\n",
|
|
"50% 11.500000\n",
|
|
"75% 13.000000\n",
|
|
"max 17.000000\n",
|
|
"Name: DS_0410, dtype: float64"
|
|
]
|
|
},
|
|
"execution_count": 19,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"source": [
|
|
"notes[ds_name].describe()"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 20,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"list_exo = [\"Exercice 1\", \"Exercice 2\", \"Exercice 3 (QCM)\"]"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 21,
|
|
"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",
|
|
" <th>Exercice 3 (QCM)</th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th>AISSA Reda</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>7.17</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>BENALIA Nassim</th>\n",
|
|
" <td>1.33</td>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>BOUCETTA M'hamed</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>8.67</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DA COSTA SANTOS Pauline</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>5.17</td>\n",
|
|
" <td>0.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DE SOUZA Laurencia</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>6.67</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>DIA Anais</th>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GEINDREAU Anne Lyse</th>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>10.00</td>\n",
|
|
" <td>1.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GIAHI KHOSHNAM Kimiya</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>4.50</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>GOMES DOS SANTOS Mélina</th>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>6.67</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>JOSEPH Lucie</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>KENEMO Jordan</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>LAHBATI Baddredine</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>3.67</td>\n",
|
|
" <td>2.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>LELO Yokoche</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>9.00</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MBARKI Nesrin</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>8.00</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MEDJADIR Ikrame</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>5.67</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MOUGAMADOUSOULEMANE Nasrin</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>MOUMNI Mohamed</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>5.00</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>NKOUNKOU MOUANGASSA Primaëlle Allegresse</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>8.00</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>PATRICK Alvin</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>7.50</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>RIVART Morgane</th>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>10.00</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Safarnyan Vakil</th>\n",
|
|
" <td>0.67</td>\n",
|
|
" <td>3.50</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SENKAL Kursad</th>\n",
|
|
" <td>1.33</td>\n",
|
|
" <td>9.17</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SHABBIR Rukhssar</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>5.50</td>\n",
|
|
" <td>4.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SILMI Walid</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>4.67</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>SOUPRAMANIANE Pavitra</th>\n",
|
|
" <td>3.33</td>\n",
|
|
" <td>6.50</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>TERBECHE Fatima</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>7.33</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>UGURLU Rojin</th>\n",
|
|
" <td>2.67</td>\n",
|
|
" <td>6.67</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>VALERE Laureen</th>\n",
|
|
" <td>2.00</td>\n",
|
|
" <td>7.50</td>\n",
|
|
" <td>1.5</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>VAZ DE ALMEIDA Gabrielle</th>\n",
|
|
" <td>4.00</td>\n",
|
|
" <td>9.67</td>\n",
|
|
" <td>3.0</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"text/plain": [
|
|
" Exercice 1 Exercice 2 \\\n",
|
|
"AISSA Reda 3.33 7.17 \n",
|
|
"BENALIA Nassim 1.33 4.00 \n",
|
|
"BOUCETTA M'hamed 2.67 8.67 \n",
|
|
"DA COSTA SANTOS Pauline 2.00 5.17 \n",
|
|
"DE SOUZA Laurencia 2.67 6.67 \n",
|
|
"DIA Anais 4.00 4.00 \n",
|
|
"GEINDREAU Anne Lyse 4.00 10.00 \n",
|
|
"GIAHI KHOSHNAM Kimiya 3.33 4.50 \n",
|
|
"GOMES DOS SANTOS Mélina 4.00 6.67 \n",
|
|
"JOSEPH Lucie 2.67 4.00 \n",
|
|
"KENEMO Jordan 2.67 2.67 \n",
|
|
"LAHBATI Baddredine 2.00 3.67 \n",
|
|
"LELO Yokoche 3.33 9.00 \n",
|
|
"MBARKI Nesrin 3.33 8.00 \n",
|
|
"MEDJADIR Ikrame 2.00 5.67 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 2.67 4.00 \n",
|
|
"MOUMNI Mohamed 3.33 5.00 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3.33 8.00 \n",
|
|
"PATRICK Alvin 2.67 7.50 \n",
|
|
"RIVART Morgane 4.00 10.00 \n",
|
|
"Safarnyan Vakil 0.67 3.50 \n",
|
|
"SENKAL Kursad 1.33 9.17 \n",
|
|
"SHABBIR Rukhssar 2.00 5.50 \n",
|
|
"SILMI Walid 2.00 4.67 \n",
|
|
"SOUPRAMANIANE Pavitra 3.33 6.50 \n",
|
|
"TERBECHE Fatima 2.00 7.33 \n",
|
|
"UGURLU Rojin 2.67 6.67 \n",
|
|
"VALERE Laureen 2.00 7.50 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 4.00 9.67 \n",
|
|
"\n",
|
|
" Exercice 3 (QCM) \n",
|
|
"AISSA Reda 1.5 \n",
|
|
"BENALIA Nassim 3.0 \n",
|
|
"BOUCETTA M'hamed 1.5 \n",
|
|
"DA COSTA SANTOS Pauline 0.0 \n",
|
|
"DE SOUZA Laurencia 3.0 \n",
|
|
"DIA Anais 1.5 \n",
|
|
"GEINDREAU Anne Lyse 1.0 \n",
|
|
"GIAHI KHOSHNAM Kimiya 1.5 \n",
|
|
"GOMES DOS SANTOS Mélina 3.0 \n",
|
|
"JOSEPH Lucie 3.0 \n",
|
|
"KENEMO Jordan 1.5 \n",
|
|
"LAHBATI Baddredine 2.5 \n",
|
|
"LELO Yokoche 1.5 \n",
|
|
"MBARKI Nesrin 3.0 \n",
|
|
"MEDJADIR Ikrame 3.0 \n",
|
|
"MOUGAMADOUSOULEMANE Nasrin 1.5 \n",
|
|
"MOUMNI Mohamed 1.5 \n",
|
|
"NKOUNKOU MOUANGASSA Primaëlle Allegresse 3.0 \n",
|
|
"PATRICK Alvin 1.5 \n",
|
|
"RIVART Morgane 3.0 \n",
|
|
"Safarnyan Vakil 3.0 \n",
|
|
"SENKAL Kursad 1.5 \n",
|
|
"SHABBIR Rukhssar 4.5 \n",
|
|
"SILMI Walid 1.5 \n",
|
|
"SOUPRAMANIANE Pavitra 1.5 \n",
|
|
"TERBECHE Fatima 3.0 \n",
|
|
"UGURLU Rojin 3.0 \n",
|
|
"VALERE Laureen 1.5 \n",
|
|
"VAZ DE ALMEIDA Gabrielle 3.0 "
|
|
]
|
|
},
|
|
"execution_count": 21,
|
|
"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": 22,
|
|
"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": 23,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"['1 (tracer fonction)',\n",
|
|
" '2 (inéquation)',\n",
|
|
" '1.a (lecture graphique)',\n",
|
|
" '1.b (proportion)',\n",
|
|
" '1.c (lecture graphique)',\n",
|
|
" '1.d (lecture graphique)',\n",
|
|
" '2.a (dérivation)',\n",
|
|
" '2.b (etude de signe)',\n",
|
|
" '2.c (maximum)']"
|
|
]
|
|
},
|
|
"execution_count": 23,
|
|
"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": 24,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [],
|
|
"source": [
|
|
"notes[sous_exo] = notes[sous_exo].applymap(toRepVal)"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 25,
|
|
"metadata": {
|
|
"collapsed": false
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/plain": [
|
|
"13"
|
|
]
|
|
},
|
|
"execution_count": 25,
|
|
"metadata": {},
|
|
"output_type": "execute_result"
|
|
}
|
|
],
|
|
"source": [
|
|
"len(notes.T.index)"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 26,
|
|
"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
|
|
}
|