1301 lines
52 KiB
Plaintext
1301 lines
52 KiB
Plaintext
{
|
||
"cells": [
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 18,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"import pandas as pd\n",
|
||
"from opytex import texenv\n",
|
||
"%matplotlib inline"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# Informations sur le devoir"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 19,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"{'classe': '309', 'date': '25 septembre 2015', 'titre': 'DS 1'}"
|
||
]
|
||
},
|
||
"execution_count": 19,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"ds_name = \"DS_15_09_25\"\n",
|
||
"classe = \"309\"\n",
|
||
"\n",
|
||
"latex_info = {}\n",
|
||
"latex_info['titre'] = \"DS 1\"\n",
|
||
"latex_info['classe'] = classe\n",
|
||
"latex_info['date'] = \"25 septembre 2015\"\n",
|
||
"latex_info"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# Import et premiers traitements"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 20,
|
||
"metadata": {
|
||
"collapsed": false,
|
||
"scrolled": true
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes = pd.ExcelFile(\"./../../../\"+classe+\".xlsx\")\n",
|
||
"notes.sheet_names\n",
|
||
"notes = notes.parse(ds_name)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 21,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"Index([ 'DS_15_09_25', 'numero sujet', 'Presentation',\n",
|
||
" 'Exercice 1', 1, 2,\n",
|
||
" 'Exercice 2', '1 (Division)', '2.a (Division)',\n",
|
||
" '2.b (PGCD)', 'Exercice 3', '1 (Vrai Faux)',\n",
|
||
" '2 (Proba)', '3 (Proba)', 'Exercice 4',\n",
|
||
" '1 (Modélisation)', '1 (Explication)'],\n",
|
||
" dtype='object')"
|
||
]
|
||
},
|
||
"execution_count": 21,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"notes.index"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 22,
|
||
"metadata": {
|
||
"collapsed": true
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes = notes.T"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 23,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"#notes = notes.drop('av_arrondi', axis=1)\n",
|
||
"notes = notes.drop('numero sujet', axis=1)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 24,
|
||
"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_15_09_25</th>\n",
|
||
" <th>Presentation</th>\n",
|
||
" <th>Exercice 1</th>\n",
|
||
" <th>1</th>\n",
|
||
" <th>2</th>\n",
|
||
" <th>Exercice 2</th>\n",
|
||
" <th>1 (Division)</th>\n",
|
||
" <th>2.a (Division)</th>\n",
|
||
" <th>2.b (PGCD)</th>\n",
|
||
" <th>Exercice 3</th>\n",
|
||
" <th>1 (Vrai Faux)</th>\n",
|
||
" <th>2 (Proba)</th>\n",
|
||
" <th>3 (Proba)</th>\n",
|
||
" <th>Exercice 4</th>\n",
|
||
" <th>1 (Modélisation)</th>\n",
|
||
" <th>1 (Explication)</th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>ABDOU Farida</th>\n",
|
||
" <td>9.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.833333</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ABOU BACAR Djaha</th>\n",
|
||
" <td>16.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.5</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>6.333333</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>5.333333</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>AHAMADA Nabaouya</th>\n",
|
||
" <td>9.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>4.000000</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>AHAMADI Faina</th>\n",
|
||
" <td>4.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>0.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ALI Mardhuia</th>\n",
|
||
" <td>11.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.5</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>4.666667</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ALI SOULAIMANA Chamsia</th>\n",
|
||
" <td>14.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>5.500000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ALSENE ALI MADI Stela</th>\n",
|
||
" <td>8.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.833333</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ANDRIATAHIANA Hoby</th>\n",
|
||
" <td>11.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.5</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.333333</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ANLI Emeline</th>\n",
|
||
" <td>4.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>0.500000</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>ATHOUMANE Naouidat</th>\n",
|
||
" <td>8.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1.166667</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>BOUDRA Nassifanya</th>\n",
|
||
" <td>14.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>5.500000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>3</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>CHANFI Nadhrati</th>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>4</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>COMBO Moinécha</th>\n",
|
||
" <td>12.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.833333</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HALIDI Nisma</th>\n",
|
||
" <td>10.0</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>2.5</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.833333</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HAMZA Samianti</th>\n",
|
||
" <td>4.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.000000</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HOUMADI Mouslimati</th>\n",
|
||
" <td>5.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>0.500000</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HOUMADI Chaharazadi</th>\n",
|
||
" <td>10.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2.666667</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.166667</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HOUMADI Nasmi</th>\n",
|
||
" <td>14.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.333333</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>4.500000</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>HOUMADI Dhoirfia</th>\n",
|
||
" <td>13.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>5.500000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2.0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>LOUTOUFI Nachima</th>\n",
|
||
" <td>4.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0.500000</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>MALIDE El-Anzize</th>\n",
|
||
" <td>9.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>5.500000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>MONNE Kevin</th>\n",
|
||
" <td>14.0</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>4.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3.500000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>MOUSSA Roibouanti</th>\n",
|
||
" <td>13.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.333333</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>5.000000</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>OUSSENI Hilma</th>\n",
|
||
" <td>4.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.166667</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>SAANLI Natali</th>\n",
|
||
" <td>19.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>7.000000</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>5.000000</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>SAID AHAMADA Roukaya</th>\n",
|
||
" <td>14.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>3.0</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>4.666667</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.166667</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>SANDA Issoufi</th>\n",
|
||
" <td>5.0</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>4.166667</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>SOILIHI Soifia</th>\n",
|
||
" <td>9.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>1.5</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>4.166667</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>3</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0.5</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>0</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>SOUFIANI Laila</th>\n",
|
||
" <td>4.0</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>1.000000</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" </tr>\n",
|
||
" <tr>\n",
|
||
" <th>YOUSSOUF Sitirati</th>\n",
|
||
" <td>3.5</td>\n",
|
||
" <td>1.0</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2.000000</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>0</td>\n",
|
||
" <td>2</td>\n",
|
||
" <td>0.500000</td>\n",
|
||
" <td>1</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>0.0</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" </tr>\n",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" DS_15_09_25 Presentation Exercice 1 1 2 \\\n",
|
||
"ABDOU Farida 9.0 1.0 0.0 NaN NaN \n",
|
||
"ABOU BACAR Djaha 16.5 1.0 2.5 3 2 \n",
|
||
"AHAMADA Nabaouya 9.0 1.0 0.0 0 0 \n",
|
||
"AHAMADI Faina 4.5 1.0 1.5 3 NaN \n",
|
||
"ALI Mardhuia 11.5 1.0 2.5 3 2 \n",
|
||
"ALI SOULAIMANA Chamsia 14.0 1.0 3.0 3 3 \n",
|
||
"ALSENE ALI MADI Stela 8.5 1.0 0.0 0 0 \n",
|
||
"ANDRIATAHIANA Hoby 11.0 1.0 2.5 3 2 \n",
|
||
"ANLI Emeline 4.0 0.0 0.0 0 0 \n",
|
||
"ATHOUMANE Naouidat 8.0 1.0 2.0 3 1 \n",
|
||
"BOUDRA Nassifanya 14.5 1.0 3.0 3 3 \n",
|
||
"CHANFI Nadhrati 3.0 1.0 0.0 0 0 \n",
|
||
"COMBO Moinécha 12.5 1.0 3.0 3 3 \n",
|
||
"HALIDI Nisma 10.0 0.5 2.5 3 2 \n",
|
||
"HAMZA Samianti 4.5 1.0 0.0 0 0 \n",
|
||
"HOUMADI Mouslimati 5.5 1.0 0.0 0 0 \n",
|
||
"HOUMADI Chaharazadi 10.5 1.0 2.0 2 2 \n",
|
||
"HOUMADI Nasmi 14.0 1.0 2.0 2 2 \n",
|
||
"HOUMADI Dhoirfia 13.5 1.0 3.0 3 3 \n",
|
||
"LOUTOUFI Nachima 4.0 1.0 0.0 0 0 \n",
|
||
"MALIDE El-Anzize 9.5 1.0 0.0 0 0 \n",
|
||
"MONNE Kevin 14.0 0.5 3.0 3 3 \n",
|
||
"MOUSSA Roibouanti 13.0 1.0 3.0 3 3 \n",
|
||
"OUSSENI Hilma 4.5 1.0 0.0 0 0 \n",
|
||
"SAANLI Natali 19.0 1.0 3.0 3 3 \n",
|
||
"SAID AHAMADA Roukaya 14.5 1.0 3.0 3 3 \n",
|
||
"SANDA Issoufi 5.0 0.5 0.5 1 0 \n",
|
||
"SOILIHI Soifia 9.0 1.0 1.5 2 1 \n",
|
||
"SOUFIANI Laila 4.0 1.0 0.0 0 0 \n",
|
||
"YOUSSOUF Sitirati 3.5 1.0 0.0 0 0 \n",
|
||
"\n",
|
||
" Exercice 2 1 (Division) 2.a (Division) 2.b (PGCD) \\\n",
|
||
"ABDOU Farida 2.000000 0 0 2 \n",
|
||
"ABOU BACAR Djaha 6.333333 2 3 3 \n",
|
||
"AHAMADA Nabaouya 3.000000 0 0 3 \n",
|
||
"AHAMADI Faina 2.000000 0 0 2 \n",
|
||
"ALI Mardhuia 3.000000 0 0 3 \n",
|
||
"ALI SOULAIMANA Chamsia 3.000000 0 0 2 \n",
|
||
"ALSENE ALI MADI Stela 3.000000 0 0 3 \n",
|
||
"ANDRIATAHIANA Hoby 4.333333 0 2 3 \n",
|
||
"ANLI Emeline 3.000000 0 0 3 \n",
|
||
"ATHOUMANE Naouidat 2.000000 0 0 2 \n",
|
||
"BOUDRA Nassifanya 3.000000 0 0 3 \n",
|
||
"CHANFI Nadhrati 0.000000 0 NaN NaN \n",
|
||
"COMBO Moinécha 2.000000 0 0 2 \n",
|
||
"HALIDI Nisma 2.000000 0 0 2 \n",
|
||
"HAMZA Samianti 1.000000 0 0 1 \n",
|
||
"HOUMADI Mouslimati 3.000000 0 0 3 \n",
|
||
"HOUMADI Chaharazadi 2.666667 0 1 2 \n",
|
||
"HOUMADI Nasmi 4.333333 0 2 3 \n",
|
||
"HOUMADI Dhoirfia 2.000000 0 0 2 \n",
|
||
"LOUTOUFI Nachima 1.000000 0 0 1 \n",
|
||
"MALIDE El-Anzize 2.000000 0 0 2 \n",
|
||
"MONNE Kevin 4.000000 0 3 2 \n",
|
||
"MOUSSA Roibouanti 3.333333 2 3 0 \n",
|
||
"OUSSENI Hilma 1.000000 0 0 1 \n",
|
||
"SAANLI Natali 7.000000 3 3 3 \n",
|
||
"SAID AHAMADA Roukaya 4.666667 1 3 2 \n",
|
||
"SANDA Issoufi 0.000000 0 0 0 \n",
|
||
"SOILIHI Soifia 2.000000 0 0 2 \n",
|
||
"SOUFIANI Laila 2.000000 0 0 2 \n",
|
||
"YOUSSOUF Sitirati 2.000000 0 0 2 \n",
|
||
"\n",
|
||
" Exercice 3 1 (Vrai Faux) 2 (Proba) 3 (Proba) \\\n",
|
||
"ABDOU Farida 4.833333 3 3 2 \n",
|
||
"ABOU BACAR Djaha 5.333333 4 3 2 \n",
|
||
"AHAMADA Nabaouya 4.000000 4 2 1 \n",
|
||
"AHAMADI Faina 0.000000 0 NaN NaN \n",
|
||
"ALI Mardhuia 4.666667 4 3 1 \n",
|
||
"ALI SOULAIMANA Chamsia 5.500000 3 3 3 \n",
|
||
"ALSENE ALI MADI Stela 3.833333 1 3 2 \n",
|
||
"ANDRIATAHIANA Hoby 3.000000 2 3 NaN \n",
|
||
"ANLI Emeline 0.500000 1 0 0 \n",
|
||
"ATHOUMANE Naouidat 1.166667 1 1 NaN \n",
|
||
"BOUDRA Nassifanya 5.500000 3 3 3 \n",
|
||
"CHANFI Nadhrati 2.000000 4 0 0 \n",
|
||
"COMBO Moinécha 4.833333 3 3 2 \n",
|
||
"HALIDI Nisma 4.833333 3 3 2 \n",
|
||
"HAMZA Samianti 1.000000 2 NaN NaN \n",
|
||
"HOUMADI Mouslimati 0.500000 1 0 0 \n",
|
||
"HOUMADI Chaharazadi 4.166667 3 3 1 \n",
|
||
"HOUMADI Nasmi 4.500000 1 3 3 \n",
|
||
"HOUMADI Dhoirfia 5.500000 3 3 3 \n",
|
||
"LOUTOUFI Nachima 0.500000 1 0 0 \n",
|
||
"MALIDE El-Anzize 5.500000 3 3 3 \n",
|
||
"MONNE Kevin 3.500000 3 0 3 \n",
|
||
"MOUSSA Roibouanti 5.000000 2 3 3 \n",
|
||
"OUSSENI Hilma 1.166667 1 0 1 \n",
|
||
"SAANLI Natali 5.000000 2 3 3 \n",
|
||
"SAID AHAMADA Roukaya 4.166667 3 3 1 \n",
|
||
"SANDA Issoufi 4.166667 3 3 1 \n",
|
||
"SOILIHI Soifia 4.166667 3 3 1 \n",
|
||
"SOUFIANI Laila 1.000000 2 NaN NaN \n",
|
||
"YOUSSOUF Sitirati 0.500000 1 NaN NaN \n",
|
||
"\n",
|
||
" Exercice 4 1 (Modélisation) 1 (Explication) \n",
|
||
"ABDOU Farida 1.0 2 0 \n",
|
||
"ABOU BACAR Djaha 1.5 1 2 \n",
|
||
"AHAMADA Nabaouya 1.0 1 1 \n",
|
||
"AHAMADI Faina 0.0 0 0 \n",
|
||
"ALI Mardhuia 0.5 0 1 \n",
|
||
"ALI SOULAIMANA Chamsia 1.5 2 1 \n",
|
||
"ALSENE ALI MADI Stela 0.5 1 NaN \n",
|
||
"ANDRIATAHIANA Hoby 0.0 0 0 \n",
|
||
"ANLI Emeline 0.5 0 1 \n",
|
||
"ATHOUMANE Naouidat 2.0 2 2 \n",
|
||
"BOUDRA Nassifanya 2.0 1 3 \n",
|
||
"CHANFI Nadhrati 0.0 0 NaN \n",
|
||
"COMBO Moinécha 1.5 1 2 \n",
|
||
"HALIDI Nisma 0.0 0 0 \n",
|
||
"HAMZA Samianti 1.5 2 1 \n",
|
||
"HOUMADI Mouslimati 1.0 1 1 \n",
|
||
"HOUMADI Chaharazadi 0.5 1 0 \n",
|
||
"HOUMADI Nasmi 2.0 2 2 \n",
|
||
"HOUMADI Dhoirfia 2.0 2 2 \n",
|
||
"LOUTOUFI Nachima 1.5 2 1 \n",
|
||
"MALIDE El-Anzize 1.0 0 2 \n",
|
||
"MONNE Kevin 3.0 3 3 \n",
|
||
"MOUSSA Roibouanti 0.5 0 1 \n",
|
||
"OUSSENI Hilma 1.5 1 2 \n",
|
||
"SAANLI Natali 3.0 3 3 \n",
|
||
"SAID AHAMADA Roukaya 1.5 2 1 \n",
|
||
"SANDA Issoufi 0.0 0 NaN \n",
|
||
"SOILIHI Soifia 0.5 1 0 \n",
|
||
"SOUFIANI Laila 0.0 0 NaN \n",
|
||
"YOUSSOUF Sitirati 0.0 NaN NaN "
|
||
]
|
||
},
|
||
"execution_count": 24,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"barem = notes[:1]\n",
|
||
"notes = notes[1:]\n",
|
||
"notes"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Supression des notes inutiles "
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 25,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"ename": "TypeError",
|
||
"evalue": "invalid type comparison",
|
||
"output_type": "error",
|
||
"traceback": [
|
||
"\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
|
||
"\u001b[1;31mTypeError\u001b[0m Traceback (most recent call last)",
|
||
"\u001b[1;32m<ipython-input-25-5bb918f5a68f>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m 1\u001b[0m \u001b[0mnotes\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mnotes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mnotes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mds_name\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mnotnull\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mnotes\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mnotes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mnotes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mds_name\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m!=\u001b[0m \u001b[1;34m'abs'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
|
||
"\u001b[1;32m/home/lafrite/.virtualenvs/enseignement/lib/python3.4/site-packages/pandas/core/ops.py\u001b[0m in \u001b[0;36mwrapper\u001b[1;34m(self, other, axis)\u001b[0m\n\u001b[0;32m 612\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 613\u001b[0m \u001b[1;31m# scalars\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 614\u001b[1;33m \u001b[0mres\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mna_op\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mother\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 615\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mnp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0misscalar\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mres\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 616\u001b[0m raise TypeError('Could not compare %s type with Series'\n",
|
||
"\u001b[1;32m/home/lafrite/.virtualenvs/enseignement/lib/python3.4/site-packages/pandas/core/ops.py\u001b[0m in \u001b[0;36mna_op\u001b[1;34m(x, y)\u001b[0m\n\u001b[0;32m 566\u001b[0m \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0my\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 567\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[1;32mis\u001b[0m \u001b[0mNotImplemented\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 568\u001b[1;33m \u001b[1;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"invalid type comparison\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 569\u001b[0m \u001b[1;32mexcept\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mAttributeError\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 570\u001b[0m \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mop\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0my\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
|
||
"\u001b[1;31mTypeError\u001b[0m: invalid type comparison"
|
||
]
|
||
}
|
||
],
|
||
"source": [
|
||
"notes = notes[notes[ds_name].notnull()]\n",
|
||
"#notes = notes[notes[ds_name] != 'abs']"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 26,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes = notes.astype(float)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"## Traitement des notes"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 27,
|
||
"metadata": {
|
||
"collapsed": false,
|
||
"scrolled": true
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"Index([ 'DS_15_09_25', 'Presentation', 'Exercice 1',\n",
|
||
" 1, 2, 'Exercice 2',\n",
|
||
" '1 (Division)', '2.a (Division)', '2.b (PGCD)',\n",
|
||
" 'Exercice 3', '1 (Vrai Faux)', '2 (Proba)',\n",
|
||
" '3 (Proba)', 'Exercice 4', '1 (Modélisation)',\n",
|
||
" '1 (Explication)'],\n",
|
||
" dtype='object')"
|
||
]
|
||
},
|
||
"execution_count": 27,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"notes.T.index"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 28,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"list_exo = [\"Exercice 1\", \"Exercice 2\", \"Exercice 3\", \"Exercice 4\"]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 29,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes[list_exo] = notes[list_exo].applymap(lambda x:round(x,2))\n",
|
||
"#notes[list_exo]"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 30,
|
||
"metadata": {
|
||
"collapsed": false,
|
||
"scrolled": true
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"[1,\n",
|
||
" 2,\n",
|
||
" '1 (Division)',\n",
|
||
" '2.a (Division)',\n",
|
||
" '2.b (PGCD)',\n",
|
||
" '1 (Vrai Faux)',\n",
|
||
" '2 (Proba)',\n",
|
||
" '3 (Proba)',\n",
|
||
" '1 (Modélisation)',\n",
|
||
" '1 (Explication)']"
|
||
]
|
||
},
|
||
"execution_count": 30,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"item_avec_note = list_exo + [ds_name, \"Presentation\"]\n",
|
||
"sous_exo = [i for i in notes.T.index if i not in item_avec_note]\n",
|
||
"sous_exo"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 31,
|
||
"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": 32,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes[item_avec_note] = notes[item_avec_note].fillna(\".\")\n",
|
||
"#notes"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 33,
|
||
"metadata": {
|
||
"collapsed": true
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"eleves = notes.copy()\n",
|
||
"eleves[sous_exo] = notes[sous_exo].applymap(toRepVal)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 34,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"16"
|
||
]
|
||
},
|
||
"execution_count": 34,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"len(notes.T.index)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# Preparation du fichier .tex"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 35,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"bilan = texenv.get_template(\"tpl_bilan.tex\")\n",
|
||
"with open(\"./bilan309.tex\",\"w\") as f:\n",
|
||
" f.write(bilan.render(eleves = eleves, barem = barem, ds_name = ds_name, latex_info = latex_info, nbr_questions = len(barem.T)))"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "markdown",
|
||
"metadata": {},
|
||
"source": [
|
||
"# Un peu de statistiques"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 36,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"count 30.000000\n",
|
||
"mean 9.466667\n",
|
||
"std 4.468150\n",
|
||
"min 3.000000\n",
|
||
"25% 4.625000\n",
|
||
"50% 9.250000\n",
|
||
"75% 13.375000\n",
|
||
"max 19.000000\n",
|
||
"Name: DS_15_09_25, dtype: float64"
|
||
]
|
||
},
|
||
"execution_count": 36,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"notes[ds_name].describe()"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 37,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [
|
||
{
|
||
"data": {
|
||
"text/plain": [
|
||
"<matplotlib.axes._subplots.AxesSubplot at 0x7f16822e6c88>"
|
||
]
|
||
},
|
||
"execution_count": 37,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
},
|
||
{
|
||
"data": {
|
||
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXUAAAEACAYAAABMEua6AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAFyVJREFUeJzt3XGMpHV9x/H3xzuwEiorJV717siaAo1YdQ9bPLWWwWpy\nXFvgD5NCanDxD4kt6tGmtVJT/MOksbb1pBa8tuKBRtCgpZicEbQ7xqaWUrhFwKNC9OodhsMcchUI\nCN63f8yzd8Pc7szss7PP851nPq9kcvvM/G7ms799+O7cZ2YXRQRmZtYML6g7gJmZjY6HuplZg3io\nm5k1iIe6mVmDeKibmTWIh7qZWYP0HeqSfkHSHZLmJd0n6cNLrLta0oOS7pG0aVWSmpnZQH2HekQ8\nDZwbETPADLBF0uu710jaCpwWEacD7wauXa2wZmbW38D6JSKeKj48HjgOONyz5Hzg+mLtHcCUpHWj\nDGlmZsMZONQlvUDSPHAAuC0i7uxZsh7Y13W8H9gwuohmZjasYZ6pHy7qlw3A6yW9apFl6v1rowhn\nZmbLs3bYhRFxSNIcsAW4v+umh4GNXccbiuueR5IHvZlZCRHR+8R5SYPe/XKKpKni4xcBbwP29Cy7\nFbikWLMZeDwiDiwRLNWlSDXgMsyaGNnnd9VVV9W+L6uZadg9916N7jLKPW/yPmXMdPTrN7xBz9Rf\nBlwvaQ2dbwBfiIhdki4rToIdxfFWSQ8BTwKXLjuFHbF37966IxwjYybImStjpowy7lPGTGX0HeoR\ncS9w1iLX7+g5vnzEuczMrAT/RGkys7OzdUc4RsZMkDNXxkwZZdynjJnKUJnOptQDSVHVYw1LEoPf\nqDPMms66bJ9fRsPuufdydLzn400SMaoXSq167Xa77gjHyJgJcubKmCmjjPuUMVMZHupmZg3i+sX1\nS6VcBVTPez7eXL+YmU0wD/VkMvZ6GTNBzlwZM2WUcZ8yZirDQ93MrEHcqbtTr5T73ep5z8ebO3Uz\nswnmoZ5Mxl4vYybImStjpowy7lPGTGV4qJuZNYg7dXfqlXK/Wz3v+Xhzp25mNsE81JPJ2OtlzAQ5\nc2XMlFHGfcqYqQwPdTOzBnGn7k69Uu53q+c9H2/u1M3MJpiHejIZe72MmSBnroyZMsq4TxkzleGh\nbmbWIO7U3alXyv1u9bzn482dupnZBPNQTyZjr5cxE+TMlTFTRhn3KWOmMjzUzcwaxJ26O/VKud+t\nnvd8vLlTNzObYB7qyWTs9TJmgpy5MmbKKOM+ZcxUhoe6mVmD9O3UJW0EbgBeSqeU+8eIuLpnTQv4\nV+D7xVVfioiPLHJf7tTN/W4NvOfjbbmd+toBtz8LXBER85JOBO6SdHtE7OlZ982IOH+5Yc3MbLT6\n1i8R8UhEzBcfPwHsAV6+yNKhv4tYfxl7vYyZIGeujJkyyrhPGTOVMXSnLmka2ATc0XNTAG+QNC9p\nl6QzRxfPzMyWY6j3qRfVSxv4SETc0nPbLwI/j4inJJ0HfCIizljkPtypm/vdGnjPx9uoO3UkHQd8\nCfhc70AHiIifdn38VUnXSDo5Ih7rXTs7O8v09DQAU1NTzMzM0Gq1gKP/9Kn6+KiF41bP8aDbW0dX\ntNu1fz7Zj49aOG4tepwlb1OOff6Oz3G73Wbnzp0AR+blskTEkhc6T1NvAD7eZ806jj7jPxvYu8S6\nyAYIiAGXYdZ01o3C3NzcSO5nlEaZadg9rzrXqGTMNMo9H5WM+5QxU8SRr03fWd19GfRM/U3AO4Dv\nSNpdXHclcGoxpXcAbwfeI+k54CngouV/azEzs1Hw735xp14p97vV856PN//uFzOzCeahnsyxLyjW\nL2MmyJkrY6aMMu5TxkxleKibmTWIO3V36pVyv1s97/l4c6duZjbBPNSTydjrZcwEOXNlzJRRxn3K\nmKkMD3UzswZxp+5OvVLud6vnPR9v7tTNzCaYh3oyGXu9jJkgZ66MmTLKuE8ZM5XhoW5m1iDu1N2p\nV8r9bvW85+PNnbqZ2QTzUE8mY6+XMRPkzJUxU0YZ9yljpjI81M3MGsSdujv1SrnfrZ73fLy5Uzcz\nm2Ae6slk7PUyZoKcuTJmyijjPmXMVIaHuplZg7hTd6deKfe71fOejzd36mZmE8xDPZmMvV7GTJAz\nV8ZMGWXcp4yZyvBQNzNrEHfq7tQr5X63et7z8eZO3cxsgnmoJ5Ox18uYCXLmypgpo4z7lDFTGR7q\nZmYN4k7dnXql3O9Wz3s+3typm5lNsL5DXdJGSXOS7pd0n6T3LbHuakkPSrpH0qbViToZMvZ6GTNB\nzlwZM2WUcZ8yZipj7YDbnwWuiIh5SScCd0m6PSL2LCyQtBU4LSJOl/R64Fpg8+pFNjOzpSyrU5d0\nC/D3EfGNrus+BcxFxBeK4weAcyLiQM/fdadu7ndr4D0fb6vWqUuaBjYBd/TctB7Y13W8H9gw7P2a\nmdnoDKpfACiql5uB90fEE4st6Tle9Fv+7Ows09PTAExNTTEzM0Or1QKO9llVHx+1cNzqOR50e+vo\ninZ7JHlarVZt+7HYcW+2lX5+HQvHrUWPh7m/+fl5tm3bNvLPd6WfX7avX8dCvqWOF57RDxYRK86z\nffv2FP/9Zzyf2u02O3fuBDgyL5clIvpegOOArwHblrj9U8BFXccPAOsWWRfZAAEx4DLMms66UZib\nmxvJ/YzSKDMNu+dV5xqVjJl8ng8nY6aII3s+cFYvXPp26up8674eOBgRVyyxZitweURslbQZ2B4R\nx7xQ6k7dwP1uHXyej7flduqD6pc3Ae8AviNpd3HdlcCpABGxIyJ2Sdoq6SHgSeDSErnNzGwE+r5Q\nGhH/HhEviIiZiNhUXL5aDPMdXesuj4jTIuK1EXH36sdurmO75/plzAQ5c2XMlFHGfcqYqQz/RKmZ\nWYP4d7+4a6yUO/Xq+Twfb/7dL2ZmE8xDPZmMvV7GTJAzV8ZMGWXcp4yZyvBQNzNrEHfq7hor5U69\nej7Px5s7dTOzCeahnkzGXi9jJsiZK2OmjDLuU8ZMZXiom5k1iDt1d42VcqdePZ/n482dupnZBPNQ\nTyZjr5cxE+TMlTFTRhn3KWOmMjzUzcwaxJ26u8ZKuVOvns/z8eZO3cxsgnmoJ5Ox18uYCXLmypgp\no4z7lDFTGR7qZmYN4k7dXWOl3KlXz+f5eHOnbmY2wTzUk8nY62XMBDlzZcyUUcZ9ypipDA91M7MG\ncafurrFS7tSr5/N8vLlTNzObYB7qyWTs9TJmgpy5MmbKKOM+ZcxUhoe6mVmDuFN311gpd+rV83k+\n3typm5lNMA/1ZDL2ehkzQc5cGTNllHGfMmYqY+BQl3SdpAOS7l3i9pakQ5J2F5cPjT6mmZkNY2Cn\nLunNwBPADRHx6kVubwF/HBHnD7gfd+rmTr0GPs/H28g79Yj4FvCTQY877AOamdnqGUWnHsAbJM1L\n2iXpzBHc58TK2OtlzAQ5c2XMlFHGfcqYqYy1I7iPu4FTI+IpSecBtwBnLLZwdnaW6elpAKamppiZ\nmaHVagFHN7Tq46MWjls9x4Nubx1d0W6PLE9d+1H/fg9/f/Pz87V/PuPy9Rvm/O1cN2g9I8kzPz+/\nor+/GsdZzqd2u83OnTsBjszL5RjqfeqSpoGvLNapL7L2B8DrIuKxnuvdqZs79Rr4PB9vlb9PXdI6\ndc4aJJ1N5xvFYwP+mpmZrYJh3tJ4I/AfwK9K2ifpXZIuk3RZseTtwL2S5oHtwEWrF7f5jq0p6pcx\nE+TMlTFTRhn3KWOmMgZ26hFx8YDb/wH4h5ElMjOz0vy7X9w1VsqdevV8no83/+4XM7MJ5qGeTMZe\nL2MmyJkrY6aMMu5TxkxleKibmTWIO3V3jZVyp149n+fjzZ26mdkE81BPJmOvlzET5MyVMVNGGfcp\nY6YyPNTNzBrEnbq7xkq5U6+ez/Px5k7dzGyCeagnk7HXy5gJcubKmCmjjPuUMVMZHupmZg3iTt1d\nY6XcqVfP5/l4c6duZjbBPNSTydjrZcwEOXNlzJRRxn3KmKkMD3UzswZxp+6usVLu1Kvn83y8uVM3\nM5tgHurJZOz1MmaCnLkyZsoo4z5lzFSGh7qZWYO4U3fXWCl36tXzeT7e3KmbmU0wD/VkMvZ6GTNB\nzlwZM2WUcZ8yZirDQ93MrEHcqbtrrJQ79er5PB9v7tTNzCaYh3oyGXu9jJkgZ66MmTLKuE8ZM5Xh\noW5m1iADO3VJ1wG/AzwaEa9eYs3VwHnAU8BsROxeZI07dXOnXgOf5+NtNTr1zwBb+jzgVuC0iDgd\neDdw7bAPbmZmozVwqEfEt4Cf9FlyPnB9sfYOYErSutHEmzwZe72MmSBnroyZMsq4TxkzlbF2BPex\nHtjXdbwf2AAcGMF9P8/hw4d55JFHhlp7yimncPzxx486gplZaqMY6tAp5LotWrrNzs4yPT0NwNTU\nFDMzM7RaLeDod8l+x4cOHeLCCy/khBNexs9//gwAa9a8EOB5x08//WMOH35umZ9Cu/iz1XM86PbW\nkRWd7nLlImKo/ajq+Nxzz13ZJ7SodvFna9HjUe1lHQZ9/er53NrFn60ljheuW+r2Nt1Wen4tXDdo\n/bDn3tzc3Iry9D5LH8XXb25urlSedrvNzp07AY7My+UY6oePJE0DX1nshVJJnwLaEXFTcfwAcE5E\nHOhZt+IXSg8ePMj69WfwzDMH+6476aQ3cujQtxnNi0PDv4A0qsfL9kLUcC+0wSj3YJwfb4g3H1Se\naVxfKM34wnrVmer44aNbgUuKB98MPN470M3MumXsrzNmKmNg/SLpRuAc4BRJ+4CrgOMAImJHROyS\ntFXSQ8CTwKWrGdjMzJY2Vr/7xfVLPVy/LO++XL+MjusX/+4XM7OJ5qFuZpXL2F9nzFSGh7qZWYN4\nqJtZ5brfr55FxkxleKibmTWIh7qZVS5jf50xUxke6mZmDeKhbmaVy9hfZ8xUhoe6mVmDeKibWeUy\n9tcZM5XhoW5m1iAe6mZWuYz9dcZMZXiom5k1iIe6mVUuY3+dMVMZHupmZg3ioW5mlcvYX2fMVIaH\nuplZg3iom1nlMvbXGTOV4aFuZtYgHupmVrmM/XXGTGV4qJuZNYiHuplVLmN/nTFTGR7qZmYN4qFu\nZpXL2F9nzFSGh7qZWYN4qJtZ5TL21xkzleGhbmbWIB7qZla5jP11xkxlDBzqkrZIekDSg5I+sMjt\nLUmHJO0uLh9anahmZjZI36EuaQ3wSWALcCZwsaRXLrL0mxGxqbh8ZBVymlmDZOyvM2YqY9Az9bOB\nhyJib0Q8C9wEXLDIOo08mZmZLdugob4e2Nd1vL+4rlsAb5A0L2mXpDNHGdDMmidjf50xUxlrB9we\nQ9zH3cCpEfGUpPOAW4AzVpzMzMyWbdBQfxjY2HW8kc6z9SMi4qddH39V0jWSTo6Ix3rvbHZ2lunp\naQCmpqaYmZk58t1xoc/qd3zo0KGue2sXf7aWOF64bqnb2zxf2dtX5/GG2Y8qjwd//s/Pv/L9HO/H\nW/l+Lly30jyr83grPZ+2b98+1H//z8+2dP5RnO/z8/Ns27ZtqPXD7Ge73S6Vp91us3PnToAj83I5\nFLH0k3FJa4H/AX4b+BHwX8DFEbGna8064NGICElnA1+MiGOSSIp+jzWMgwcPsn79GTzzzMG+6046\n6Y0cOvRtBv9DQyNaM8r7Eivdp1GTqt+DcX68QV+/4fYz7x6M4vzsHnh9H23IvWpqpoXHi4ihX7fs\n+0w9Ip6TdDnwNWAN8OmI2CPpsuL2HcDbgfdIeg54CriodHozmwgZ++uMmcro+0x9pA/kZ+pDr/Ez\n9fF+PD9TH52qnxUPI/szdf9EqZlVLuN7wjNmKsND3cysQTzUzaxyGfvrjJnK8FA3M2sQD3Uzq1zG\n/jpjpjI81M3MGsRD3cwql7G/zpipDA91M7MG8VA3s8pl7K8zZirDQ93MrEE81M2schn764yZyvBQ\nNzNrEA91M6tcxv46Y6YyPNTNzBrEQ93MKpexv86YqQwPdTOzBvFQN7PKZeyvM2Yqw0PdzKxBPNTN\nrHIZ++uMmcrwUDczaxAPdTOrXMb+OmOmMjzUzcwaxEPdzCqXsb/OmKkMD3UzswbxUDezymXsrzNm\nKsND3cysQTzUzaxyGfvrjJnK8FA3M2uQgUNd0hZJD0h6UNIHllhzdXH7PZI2jT6mmTVJxv46Y6Yy\n+g51SWuATwJbgDOBiyW9smfNVuC0iDgdeDdw7SplNbOGmJ+frzvCMTJmKmPQM/WzgYciYm9EPAvc\nBFzQs+Z84HqAiLgDmJK0buRJzawxHn/88bojHCNjpjIGDfX1wL6u4/3FdYPWbFh5NDMzW661A26P\nIe9HJf/esj377P/x4hf/Xt81Tz+9Z7Ue3sxGYO/evXVHOEbGTGUoYun5K2kz8OGI2FIcfxA4HBEf\n7VrzKaAdETcVxw8A50TEgZ77WrVBb2bWZBHR+8R5SYOeqf83cLqkaeBHwO8DF/esuRW4HLip+Cbw\neO9AX24oMzMrp+9Qj4jnJF0OfA1YA3w6IvZIuqy4fUdE7JK0VdJDwJPApaue2szMFtW3fjEzs/Gy\n6j9RKmmjpDlJ90u6T9L7VvsxhyFpjaTdkr5Sd5YFkqYk3Sxpj6TvFnVW3ZmuKL5u90r6vKQX1pDh\nOkkHJN3bdd3Jkm6X9D1Jt0maSpLrY8XX7x5JX5Z0Ut2Zum77E0mHJZ2cIZOk9xZ7dZ+kjy7196vK\nJGlG0n8Wc+FOSb9RcaZFZ+Vyz/Uqfk3As8AVEfEqYDPwR70/wFST9wPfZRXfqVPCJ4BdEfFK4DVA\nrW/jkbQeeC/wuoh4NZ0K7qIaonyGzg/Adftz4PaIOAP4RnFctcVy3Qa8KiJeC3wP+GCCTEjaCLwN\n+N+K88AimSSdS+dnXF4TEb8G/E3dmYC/Bq6KiE3AXxbHVVpqVi7rXF/1oR4Rj0TEfPHxE3QG1ctX\n+3H7kbQB2Ar8M8e+HbMWxTO6N0fEddB5PSMiDtUcCzqvu5wgaS1wAvBw1QEi4lvAT3quPvJDb8Wf\nF1YaisVzRcTtEXG4OLyDin9mY4m9Avg74M+qzLJgiUzvAf6q+KFGIuLHCTIdBhb+ZTVFxef6ErNy\nPcs81yv9hV7Fu2g20TnZ6/Rx4E/pfBGzeAXwY0mfkXS3pH+SdEKdgSLiYeBvgR/SeffT4xHx9Toz\ndVnX9S6rA0DGn2J+F7Cr7hCSLgD2R8R36s7S5XTgt4q6oy3p1+sOBGwDPibph8DHqP5fWUf0zMpl\nneuVDXVJJwI3A+8vvgvVQtLvAo9GxG6SPEsvrAXOAq6JiLPovJOojkrhCEkvofMsYZrOv65OlPQH\ndWZaTHRe7c9UoyHpL4CfRcTna85xAnAlcFX31TXF6bYWeElEbKbzBOuLNecB+ENgW0ScClwBXFdH\niGJWfonOrPxp923DnOuVDHVJx9EJ+bmIuKWKx+zjjcD5kn4A3Ai8RdINNWeCzq9X2B8RdxbHN9MZ\n8nV6K/CDiDgYEc8BX6azfxkckPTLAJJeBjxac54jJM3SqfcyfAP8FTrflO8pzvkNwF2SXlprqs75\n/mWA4pw/LOmX6o3EJRHxL8XHN9P53VeV6pqVn+2alcs616t494uATwPfjYjtq/14g0TElRGxMSJe\nQedFv3+LiEsS5HoE2CfpjOKqtwL31xgJOi+qbZb0ouLr+FY6Ly5ncCvwzuLjdwJ1P1kAOr+qms4z\nzwsi4um680TEvRGxLiJeUZzz+4GzIqLub4K3AG8BKM754yPiYL2R+JGkc4qP30Lnhe7K9JmVyzvX\nI2JVL8Bv0umu54HdxWXLaj/ukNnOAW6tO0dXntcCdwL30HkWc1KCTB+m84LNvXRepDmuhgw30un0\nf0bnl8ddCpwMfJ3Of3i3AVMJcr0LeJDON8OFc/2amjI9s7BXPbd/Hzi57kzAccBni/PqLqCV4Jx6\nE52fop8Hvg1sqjjTorNyuee6f/jIzKxB/L+zMzNrEA91M7MG8VA3M2sQD3UzswbxUDczaxAPdTOz\nBvFQNzNrEA91M7MG+X/PALw5f0MVEwAAAABJRU5ErkJggg==\n",
|
||
"text/plain": [
|
||
"<matplotlib.figure.Figure at 0x7f16822e6198>"
|
||
]
|
||
},
|
||
"metadata": {},
|
||
"output_type": "display_data"
|
||
}
|
||
],
|
||
"source": [
|
||
"notes_seules = notes[ds_name]\n",
|
||
"notes_seules.hist(bins = (notes_seules.max() - notes_seules.min())*2)"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 154,
|
||
"metadata": {
|
||
"collapsed": false
|
||
},
|
||
"outputs": [],
|
||
"source": [
|
||
"notes_questions = notes[sous_exo]\n",
|
||
"notes_analysis = notes_questions.describe()"
|
||
]
|
||
},
|
||
{
|
||
"cell_type": "code",
|
||
"execution_count": 155,
|
||
"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>1.1.a</th>\n",
|
||
" <th>1.1.b</th>\n",
|
||
" <th>1.1.c</th>\n",
|
||
" <th>1.2.a</th>\n",
|
||
" <th>1.2.b</th>\n",
|
||
" <th>1.2.c</th>\n",
|
||
" <th>1.2.d</th>\n",
|
||
" <th>1.3.a</th>\n",
|
||
" <th>1.3.b</th>\n",
|
||
" <th>1.3.c</th>\n",
|
||
" <th>...</th>\n",
|
||
" <th>2.2</th>\n",
|
||
" <th>2.3</th>\n",
|
||
" <th>3.1.a</th>\n",
|
||
" <th>3.1.b</th>\n",
|
||
" <th>3.1.c</th>\n",
|
||
" <th>3.1.d</th>\n",
|
||
" <th>3.2.a</th>\n",
|
||
" <th>3.2.b</th>\n",
|
||
" <th>3.2.c</th>\n",
|
||
" <th>3.2.d</th>\n",
|
||
" </tr>\n",
|
||
" </thead>\n",
|
||
" <tbody>\n",
|
||
" <tr>\n",
|
||
" <th>count</th>\n",
|
||
" <td>25</td>\n",
|
||
" <td>25</td>\n",
|
||
" <td>25</td>\n",
|
||
" <td>25</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>25</td>\n",
|
||
" <td>25</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>...</td>\n",
|
||
" <td>NaN</td>\n",
|
||
" <td>25</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",
|
||
" </tbody>\n",
|
||
"</table>\n",
|
||
"<p>1 rows × 22 columns</p>\n",
|
||
"</div>"
|
||
],
|
||
"text/plain": [
|
||
" 1.1.a 1.1.b 1.1.c 1.2.a 1.2.b 1.2.c 1.2.d 1.3.a 1.3.b 1.3.c \\\n",
|
||
"count 25 25 25 25 NaN NaN NaN 25 25 NaN \n",
|
||
"\n",
|
||
" ... 2.2 2.3 3.1.a 3.1.b 3.1.c 3.1.d 3.2.a 3.2.b 3.2.c 3.2.d \n",
|
||
"count ... NaN 25 NaN NaN NaN NaN NaN NaN NaN NaN \n",
|
||
"\n",
|
||
"[1 rows x 22 columns]"
|
||
]
|
||
},
|
||
"execution_count": 155,
|
||
"metadata": {},
|
||
"output_type": "execute_result"
|
||
}
|
||
],
|
||
"source": [
|
||
"# J'aimerai récupérer le nom des questions qui ont été le moins répondus\n",
|
||
"notes_analysis[:1][notes_analysis[:1] == 25]"
|
||
]
|
||
},
|
||
{
|
||
"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
|
||
}
|