and_tp1_presentation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "e5886235-f44e-48f7-a642-76884eb84826",
   "metadata": {},
   "source": [
    "Importation des modules utiles pour l'étude"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cfc65631-5e3f-4496-9004-601eb7ab068d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7ed281af",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q1_Masculin</th>\n",
       "      <th>Q1_Feminin</th>\n",
       "      <th>Q2_Science de Données</th>\n",
       "      <th>Q2_Sécurité Informatique</th>\n",
       "      <th>Q2_Intelligence Artificielle</th>\n",
       "      <th>Q3_1</th>\n",
       "      <th>Q3_2</th>\n",
       "      <th>Q3_3</th>\n",
       "      <th>Q3_4</th>\n",
       "      <th>Q3_5</th>\n",
       "      <th>...</th>\n",
       "      <th>Q5_Non, pas du tout</th>\n",
       "      <th>Q5_Non, pas suffisamment</th>\n",
       "      <th>Q5_Oui, mais il manque certains aspects pratiques</th>\n",
       "      <th>Q5_Oui, complètement</th>\n",
       "      <th>Q6_Devenir employé en grandes entreprises</th>\n",
       "      <th>Q6_Recherche scientifique</th>\n",
       "      <th>Q6_Je ne sais pas encore</th>\n",
       "      <th>Q6_Créer une start-up</th>\n",
       "      <th>Q6_Domaine commerciale (par exemple, vente de produits, de formations etc..)</th>\n",
       "      <th>Q6_Travailler en freelance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Q1_Masculin  Q1_Feminin  Q2_Science de Données  Q2_Sécurité Informatique  \\\n",
       "0             1           0                      1                         0   \n",
       "1             0           1                      1                         0   \n",
       "2             1           0                      0                         1   \n",
       "3             1           0                      0                         1   \n",
       "4             0           1                      0                         1   \n",
       "5             1           0                      1                         0   \n",
       "6             1           0                      1                         0   \n",
       "7             1           0                      0                         0   \n",
       "8             1           0                      1                         0   \n",
       "9             1           0                      0                         0   \n",
       "10            1           0                      1                         0   \n",
       "11            1           0                      0                         1   \n",
       "12            0           1                      1                         0   \n",
       "13            1           0                      1                         0   \n",
       "14            1           0                      1                         0   \n",
       "15            1           0                      0                         1   \n",
       "16            1           0                      0                         1   \n",
       "17            0           1                      1                         0   \n",
       "18            0           1                      0                         0   \n",
       "19            0           1                      0                         0   \n",
       "20            1           0                      1                         0   \n",
       "\n",
       "    Q2_Intelligence Artificielle  Q3_1  Q3_2  Q3_3  Q3_4  Q3_5  ...  \\\n",
       "0                              0     1     1     1     1     0  ...   \n",
       "1                              0     1     1     1     1     0  ...   \n",
       "2                              0     1     1     1     0     0  ...   \n",
       "3                              0     1     0     0     0     0  ...   \n",
       "4                              0     1     1     1     0     0  ...   \n",
       "5                              0     1     1     1     1     1  ...   \n",
       "6                              0     1     1     1     1     1  ...   \n",
       "7                              1     1     1     1     1     0  ...   \n",
       "8                              0     1     1     1     1     0  ...   \n",
       "9                              1     1     1     1     0     0  ...   \n",
       "10                             0     1     1     1     1     1  ...   \n",
       "11                             0     1     1     0     0     0  ...   \n",
       "12                             0     1     1     1     1     0  ...   \n",
       "13                             0     1     1     1     1     1  ...   \n",
       "14                             0     1     1     1     1     0  ...   \n",
       "15                             0     1     1     1     1     0  ...   \n",
       "16                             0     1     1     1     1     0  ...   \n",
       "17                             0     1     1     1     1     1  ...   \n",
       "18                             1     1     1     1     1     1  ...   \n",
       "19                             1     1     1     1     1     1  ...   \n",
       "20                             0     1     1     1     1     0  ...   \n",
       "\n",
       "    Q5_Non, pas du tout  Q5_Non, pas suffisamment  \\\n",
       "0                     1                         1   \n",
       "1                     1                         1   \n",
       "2                     1                         1   \n",
       "3                     1                         0   \n",
       "4                     1                         1   \n",
       "5                     1                         1   \n",
       "6                     1                         1   \n",
       "7                     1                         1   \n",
       "8                     1                         1   \n",
       "9                     1                         1   \n",
       "10                    1                         1   \n",
       "11                    1                         1   \n",
       "12                    1                         1   \n",
       "13                    1                         1   \n",
       "14                    1                         1   \n",
       "15                    1                         1   \n",
       "16                    1                         1   \n",
       "17                    1                         1   \n",
       "18                    1                         1   \n",
       "19                    1                         1   \n",
       "20                    1                         1   \n",
       "\n",
       "    Q5_Oui, mais il manque certains aspects pratiques  Q5_Oui, complètement  \\\n",
       "0                                                   1                     0   \n",
       "1                                                   0                     0   \n",
       "2                                                   0                     0   \n",
       "3                                                   0                     0   \n",
       "4                                                   0                     0   \n",
       "5                                                   1                     0   \n",
       "6                                                   1                     0   \n",
       "7                                                   1                     0   \n",
       "8                                                   1                     0   \n",
       "9                                                   1                     0   \n",
       "10                                                  1                     0   \n",
       "11                                                  0                     0   \n",
       "12                                                  1                     1   \n",
       "13                                                  1                     0   \n",
       "14                                                  0                     0   \n",
       "15                                                  0                     0   \n",
       "16                                                  0                     0   \n",
       "17                                                  1                     0   \n",
       "18                                                  0                     0   \n",
       "19                                                  0                     0   \n",
       "20                                                  1                     0   \n",
       "\n",
       "    Q6_Devenir employé en grandes entreprises  Q6_Recherche scientifique  \\\n",
       "0                                           1                          0   \n",
       "1                                           0                          1   \n",
       "2                                           1                          0   \n",
       "3                                           0                          0   \n",
       "4                                           0                          0   \n",
       "5                                           1                          0   \n",
       "6                                           0                          1   \n",
       "7                                           0                          0   \n",
       "8                                           0                          0   \n",
       "9                                           0                          0   \n",
       "10                                          0                          0   \n",
       "11                                          0                          1   \n",
       "12                                          0                          0   \n",
       "13                                          0                          0   \n",
       "14                                          0                          0   \n",
       "15                                          0                          0   \n",
       "16                                          0                          0   \n",
       "17                                          0                          0   \n",
       "18                                          0                          0   \n",
       "19                                          0                          0   \n",
       "20                                          1                          0   \n",
       "\n",
       "    Q6_Je ne sais pas encore  Q6_Créer une start-up  \\\n",
       "0                          0                      0   \n",
       "1                          0                      0   \n",
       "2                          0                      0   \n",
       "3                          1                      0   \n",
       "4                          0                      1   \n",
       "5                          0                      0   \n",
       "6                          0                      0   \n",
       "7                          0                      0   \n",
       "8                          0                      0   \n",
       "9                          0                      0   \n",
       "10                         0                      1   \n",
       "11                         0                      0   \n",
       "12                         1                      0   \n",
       "13                         1                      0   \n",
       "14                         0                      0   \n",
       "15                         0                      1   \n",
       "16                         0                      0   \n",
       "17                         0                      0   \n",
       "18                         1                      0   \n",
       "19                         1                      0   \n",
       "20                         0                      0   \n",
       "\n",
       "    Q6_Domaine commerciale (par exemple, vente de produits, de formations etc..)  \\\n",
       "0                                                   0                              \n",
       "1                                                   0                              \n",
       "2                                                   0                              \n",
       "3                                                   0                              \n",
       "4                                                   0                              \n",
       "5                                                   0                              \n",
       "6                                                   0                              \n",
       "7                                                   1                              \n",
       "8                                                   0                              \n",
       "9                                                   0                              \n",
       "10                                                  0                              \n",
       "11                                                  0                              \n",
       "12                                                  0                              \n",
       "13                                                  0                              \n",
       "14                                                  0                              \n",
       "15                                                  0                              \n",
       "16                                                  0                              \n",
       "17                                                  1                              \n",
       "18                                                  0                              \n",
       "19                                                  0                              \n",
       "20                                                  0                              \n",
       "\n",
       "    Q6_Travailler en freelance  \n",
       "0                            0  \n",
       "1                            0  \n",
       "2                            0  \n",
       "3                            0  \n",
       "4                            0  \n",
       "5                            0  \n",
       "6                            0  \n",
       "7                            0  \n",
       "8                            1  \n",
       "9                            1  \n",
       "10                           0  \n",
       "11                           0  \n",
       "12                           0  \n",
       "13                           0  \n",
       "14                           1  \n",
       "15                           0  \n",
       "16                           1  \n",
       "17                           0  \n",
       "18                           0  \n",
       "19                           0  \n",
       "20                           0  \n",
       "\n",
       "[21 rows x 25 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "def create_coding_table(data, ordinale_order={}):\n",
    "    tab_de_codage = pd.DataFrame()\n",
    "\n",
    "    for col in data.columns:\n",
    "        unique_values = data[col].dropna().unique()\n",
    "        if col in ordinale_order:\n",
    "            for val in ordinale_order[col]:\n",
    "               if val in unique_values:\n",
    "                    tab_de_codage[f\"{col}_{val}\"] = 0\n",
    "        else:\n",
    "            for val in unique_values:\n",
    "                tab_de_codage[f\"{col}_{val}\"] = 0\n",
    "\n",
    "    for i in range(data.shape[0]):\n",
    "        for col in data.columns:\n",
    "            value = data.loc[i, col]\n",
    "            if pd.notna(value):\n",
    "\n",
    "                if col in ordinale_order:\n",
    "                    for val in ordinale_order[col]:\n",
    "                        tab_de_codage.loc[i, f\"{col}_{val}\"] = 1\n",
    "                        if val == value:\n",
    "                            break\n",
    "                else:\n",
    "                    tab_de_codage.loc[i, f\"{col}_{value}\"] = 1\n",
    "\n",
    "    tab_de_codage.reset_index(drop=True, inplace=True)\n",
    "    tab_de_codage = tab_de_codage.fillna(0)\n",
    "    tab_de_codage = tab_de_codage.astype(int)\n",
    "\n",
    "    return tab_de_codage\n",
    "\n",
    "data = './backend/coding_table/dataset_forms.csv'\n",
    "\n",
    "df = pd.read_csv(data)\n",
    "ord = {'Q3': [1, 2, 3, 4, 5], 'Q5': ['Non, pas du tout', 'Non, pas suffisamment', 'Oui, mais il manque certains aspects pratiques', 'Oui, complètement']}\n",
    "create_coding_table(df, ordinale_order=ord)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9fe3bd56-7593-468a-a599-df3ceda07942",
   "metadata": {},
   "source": [
    "Affichage des informations du tableau de données"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "332f815f-cb59-4d46-9daf-4406a7b42662",
   "metadata": {},
   "source": [
    "On organise les données en ajoutant un identifiant"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "da560fe5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q1_1</th>\n",
       "      <th>Q1_2</th>\n",
       "      <th>Q2_1</th>\n",
       "      <th>Q2_2</th>\n",
       "      <th>Q2_3</th>\n",
       "      <th>Q3_1</th>\n",
       "      <th>Q3_2</th>\n",
       "      <th>Q3_3</th>\n",
       "      <th>Q3_4</th>\n",
       "      <th>Q3_5</th>\n",
       "      <th>...</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q5_3</th>\n",
       "      <th>Q5_4</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q6_2</th>\n",
       "      <th>Q6_3</th>\n",
       "      <th>Q6_4</th>\n",
       "      <th>Q6_5</th>\n",
       "      <th>Q6_6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.476190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.476190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>...</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.619048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.190476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>...</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.238095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>...</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.285714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>...</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.476190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>...</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>...</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.619048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>0.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.952381</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>...</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.047619</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.761905</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>...</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.619048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>...</td>\n",
       "      <td>0.380952</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.809524</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>...</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.714286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.238095</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>...</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.761905</td>\n",
       "      <td>0.619048</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Q1_1      Q1_2      Q2_1      Q2_2      Q2_3      Q3_1      Q3_2  \\\n",
       "0   1.000000  0.000000  0.523810  0.476190  0.285714  0.714286  0.666667   \n",
       "1   0.000000  1.000000  0.476190  0.523810  0.714286  0.285714  0.333333   \n",
       "2   0.523810  0.476190  1.000000  0.190476  0.285714  0.523810  0.571429   \n",
       "3   0.476190  0.523810  0.190476  1.000000  0.523810  0.285714  0.238095   \n",
       "4   0.285714  0.714286  0.285714  0.523810  1.000000  0.190476  0.238095   \n",
       "5   0.714286  0.285714  0.523810  0.285714  0.190476  1.000000  0.952381   \n",
       "6   0.666667  0.333333  0.571429  0.238095  0.238095  0.952381  1.000000   \n",
       "7   0.619048  0.380952  0.619048  0.190476  0.285714  0.904762  0.952381   \n",
       "8   0.571429  0.428571  0.761905  0.142857  0.333333  0.761905  0.809524   \n",
       "9   0.333333  0.666667  0.619048  0.380952  0.666667  0.333333  0.380952   \n",
       "10  0.333333  0.666667  0.523810  0.666667  0.571429  0.238095  0.285714   \n",
       "11  0.380952  0.619048  0.571429  0.619048  0.619048  0.190476  0.142857   \n",
       "12  0.571429  0.428571  0.571429  0.619048  0.428571  0.380952  0.428571   \n",
       "13  0.333333  0.666667  0.428571  0.666667  0.857143  0.047619  0.095238   \n",
       "14  0.238095  0.761905  0.333333  0.571429  0.952381  0.142857  0.190476   \n",
       "15  0.666667  0.333333  0.761905  0.238095  0.523810  0.476190  0.523810   \n",
       "16  0.333333  0.666667  0.238095  0.761905  0.571429  0.428571  0.476190   \n",
       "17  0.333333  0.666667  0.428571  0.761905  0.761905  0.047619  0.000000   \n",
       "18  0.238095  0.761905  0.523810  0.666667  0.761905  0.047619  0.095238   \n",
       "19  0.476190  0.523810  0.571429  0.619048  0.619048  0.190476  0.238095   \n",
       "20  0.333333  0.666667  0.523810  0.666667  0.666667  0.142857  0.190476   \n",
       "21  0.238095  0.761905  0.428571  0.571429  0.761905  0.238095  0.190476   \n",
       "22  0.333333  0.666667  0.428571  0.761905  0.666667  0.142857  0.190476   \n",
       "23  0.285714  0.714286  0.476190  0.619048  0.809524  0.095238  0.142857   \n",
       "24  0.476190  0.523810  0.476190  0.619048  0.714286  0.190476  0.238095   \n",
       "\n",
       "        Q3_3      Q3_4      Q3_5  ...      Q5_1      Q5_2      Q5_3      Q5_4  \\\n",
       "0   0.619048  0.571429  0.333333  ...  0.666667  0.333333  0.333333  0.238095   \n",
       "1   0.380952  0.428571  0.666667  ...  0.333333  0.666667  0.666667  0.761905   \n",
       "2   0.619048  0.761905  0.619048  ...  0.761905  0.238095  0.428571  0.523810   \n",
       "3   0.190476  0.142857  0.380952  ...  0.238095  0.761905  0.761905  0.666667   \n",
       "4   0.285714  0.333333  0.666667  ...  0.523810  0.571429  0.761905  0.761905   \n",
       "5   0.904762  0.761905  0.333333  ...  0.476190  0.428571  0.047619  0.047619   \n",
       "6   0.952381  0.809524  0.380952  ...  0.523810  0.476190  0.000000  0.095238   \n",
       "7   1.000000  0.857143  0.428571  ...  0.571429  0.428571  0.047619  0.142857   \n",
       "8   0.857143  1.000000  0.571429  ...  0.619048  0.380952  0.190476  0.285714   \n",
       "9   0.428571  0.571429  1.000000  ...  0.666667  0.428571  0.619048  0.619048   \n",
       "10  0.238095  0.285714  0.523810  ...  0.476190  0.523810  0.714286  0.809524   \n",
       "11  0.190476  0.333333  0.571429  ...  0.523810  0.476190  0.857143  0.761905   \n",
       "12  0.476190  0.523810  0.571429  ...  0.523810  0.571429  0.571429  0.571429   \n",
       "13  0.142857  0.285714  0.619048  ...  0.571429  0.523810  0.904762  0.904762   \n",
       "14  0.238095  0.285714  0.714286  ...  0.476190  0.619048  0.809524  0.809524   \n",
       "15  0.571429  0.619048  0.666667  ...  1.000000  0.095238  0.476190  0.476190   \n",
       "16  0.428571  0.380952  0.428571  ...  0.095238  1.000000  0.523810  0.523810   \n",
       "17  0.047619  0.190476  0.619048  ...  0.476190  0.523810  1.000000  0.904762   \n",
       "18  0.142857  0.285714  0.619048  ...  0.476190  0.523810  0.904762  1.000000   \n",
       "19  0.285714  0.333333  0.571429  ...  0.619048  0.476190  0.761905  0.761905   \n",
       "20  0.142857  0.285714  0.619048  ...  0.476190  0.619048  0.809524  0.809524   \n",
       "21  0.238095  0.380952  0.714286  ...  0.380952  0.523810  0.809524  0.809524   \n",
       "22  0.238095  0.285714  0.619048  ...  0.476190  0.619048  0.809524  0.809524   \n",
       "23  0.190476  0.333333  0.666667  ...  0.619048  0.476190  0.857143  0.857143   \n",
       "24  0.285714  0.333333  0.476190  ...  0.523810  0.571429  0.761905  0.761905   \n",
       "\n",
       "        Q6_1      Q6_2      Q6_3      Q6_4      Q6_5      Q6_6  \n",
       "0   0.476190  0.333333  0.238095  0.333333  0.285714  0.476190  \n",
       "1   0.523810  0.666667  0.761905  0.666667  0.714286  0.523810  \n",
       "2   0.571429  0.523810  0.428571  0.428571  0.476190  0.476190  \n",
       "3   0.619048  0.666667  0.571429  0.761905  0.619048  0.619048  \n",
       "4   0.619048  0.666667  0.761905  0.666667  0.809524  0.714286  \n",
       "5   0.190476  0.142857  0.238095  0.142857  0.095238  0.190476  \n",
       "6   0.238095  0.190476  0.190476  0.190476  0.142857  0.238095  \n",
       "7   0.285714  0.142857  0.238095  0.238095  0.190476  0.285714  \n",
       "8   0.333333  0.285714  0.380952  0.285714  0.333333  0.333333  \n",
       "9   0.571429  0.619048  0.714286  0.619048  0.666667  0.476190  \n",
       "10  0.666667  0.714286  0.714286  0.714286  0.666667  0.571429  \n",
       "11  0.619048  0.761905  0.666667  0.761905  0.714286  0.714286  \n",
       "12  0.714286  0.571429  0.380952  0.571429  0.619048  0.619048  \n",
       "13  0.761905  0.809524  0.714286  0.809524  0.952381  0.761905  \n",
       "14  0.666667  0.714286  0.809524  0.714286  0.761905  0.761905  \n",
       "15  0.619048  0.476190  0.380952  0.476190  0.619048  0.523810  \n",
       "16  0.476190  0.619048  0.523810  0.619048  0.476190  0.571429  \n",
       "17  0.761905  0.809524  0.809524  0.809524  0.857143  0.761905  \n",
       "18  0.761905  0.809524  0.809524  0.809524  0.857143  0.761905  \n",
       "19  1.000000  0.666667  0.571429  0.666667  0.714286  0.619048  \n",
       "20  0.666667  1.000000  0.619048  0.714286  0.761905  0.666667  \n",
       "21  0.571429  0.619048  1.000000  0.619048  0.666667  0.571429  \n",
       "22  0.666667  0.714286  0.619048  1.000000  0.761905  0.666667  \n",
       "23  0.714286  0.761905  0.666667  0.761905  1.000000  0.714286  \n",
       "24  0.619048  0.666667  0.571429  0.666667  0.714286  1.000000  \n",
       "\n",
       "[25 rows x 25 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def tab_de_distance(file):\n",
    "\n",
    "  tab_codage = pd.read_csv(file)\n",
    "\n",
    "  # Mesure de ressemblance\n",
    "  rows, columns = tab_codage.shape\n",
    "  tab_de_distance = pd.DataFrame(np.zeros((columns, columns)), columns=tab_codage.columns)\n",
    "\n",
    "  def calcRessemblance(a, b):\n",
    "    resultat = 0\n",
    "    for i in range(0, len(a)):\n",
    "      if(a[i] == b[i]):\n",
    "        resultat += 1\n",
    "    return resultat/len(a)\n",
    "      \n",
    "\n",
    "  for i in range(0, len(tab_codage.columns)):\n",
    "    for j in range(0, len(tab_codage.columns)):\n",
    "      tab_de_distance.iloc[i, j] =(calcRessemblance(tab_codage.iloc[:, i], tab_codage.iloc[:, j]))\n",
    "\n",
    "  return tab_de_distance\n",
    "\n",
    "tab_codage = './backend/coding_table/tableau_de_codage.csv'\n",
    "\n",
    "tab_de_distance(tab_codage)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7ce93484",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Q1_1</th>\n",
       "      <th>Q1_2</th>\n",
       "      <th>Q2_1</th>\n",
       "      <th>Q2_2</th>\n",
       "      <th>Q2_3</th>\n",
       "      <th>Q3_1</th>\n",
       "      <th>Q3_2</th>\n",
       "      <th>Q3_3</th>\n",
       "      <th>Q3_4</th>\n",
       "      <th>Q3_5</th>\n",
       "      <th>...</th>\n",
       "      <th>Q5_1</th>\n",
       "      <th>Q5_2</th>\n",
       "      <th>Q5_3</th>\n",
       "      <th>Q5_4</th>\n",
       "      <th>Q6_1</th>\n",
       "      <th>Q6_2</th>\n",
       "      <th>Q6_3</th>\n",
       "      <th>Q6_4</th>\n",
       "      <th>Q6_5</th>\n",
       "      <th>Q6_6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Q1_1</th>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q1_2</th>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q2_1</th>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q2_2</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q2_3</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q3_1</th>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q3_2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q3_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q3_4</th>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q3_5</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_1</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_2</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_3</th>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_4</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q4_5</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_1</th>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_2</th>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_3</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q5_4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_1</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_2</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_3</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_4</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_5</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Q6_6</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Q1_1  Q1_2  Q2_1  Q2_2  Q2_3  Q3_1  Q3_2  Q3_3  Q3_4  Q3_5  ...  Q5_1  \\\n",
       "Q1_1    15     0     8     5     2     7     2     1     4     1  ...     9   \n",
       "Q1_2     0     6     3     1     2     2     1     0     3     0  ...     1   \n",
       "Q2_1     8     3    11     0     0     6     0     0     5     0  ...     8   \n",
       "Q2_2     5     1     0     6     0     2     2     1     0     1  ...     0   \n",
       "Q2_3     2     2     0     0     4     1     1     0     2     0  ...     2   \n",
       "Q3_1     7     2     6     2     1     9     0     0     0     0  ...     4   \n",
       "Q3_2     2     1     0     2     1     0     3     0     0     0  ...     1   \n",
       "Q3_3     1     0     0     1     0     0     0     1     0     0  ...     0   \n",
       "Q3_4     4     3     5     0     2     0     0     0     7     0  ...     5   \n",
       "Q3_5     1     0     0     1     0     0     0     0     0     1  ...     0   \n",
       "Q4_1     3     2     3     2     0     2     1     0     1     1  ...     2   \n",
       "Q4_2     3     1     3     1     0     2     0     1     1     0  ...     2   \n",
       "Q4_3     7     1     5     3     0     4     1     0     3     0  ...     4   \n",
       "Q4_4     1     0     0     0     1     1     0     0     0     0  ...     1   \n",
       "Q4_5     1     2     0     0     3     0     1     0     2     0  ...     1   \n",
       "Q5_1     9     1     8     0     2     4     1     0     5     0  ...    10   \n",
       "Q5_2     5     4     2     5     2     4     2     0     2     1  ...     0   \n",
       "Q5_3     1     0     0     1     0     0     0     1     0     0  ...     0   \n",
       "Q5_4     0     1     1     0     0     1     0     0     0     0  ...     0   \n",
       "Q6_1     4     0     3     1     0     2     1     0     1     0  ...     3   \n",
       "Q6_2     2     1     2     1     0     1     0     0     1     1  ...     1   \n",
       "Q6_3     2     3     2     1     2     1     0     1     3     0  ...     1   \n",
       "Q6_4     2     1     1     2     0     1     1     0     1     0  ...     1   \n",
       "Q6_5     1     1     1     0     1     1     0     0     1     0  ...     2   \n",
       "Q6_6     4     0     2     1     1     3     1     0     0     0  ...     2   \n",
       "\n",
       "      Q5_2  Q5_3  Q5_4  Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6  \n",
       "Q1_1     5     1     0     4     2     2     2     1     4  \n",
       "Q1_2     4     0     1     0     1     3     1     1     0  \n",
       "Q2_1     2     0     1     3     2     2     1     1     2  \n",
       "Q2_2     5     1     0     1     1     1     2     0     1  \n",
       "Q2_3     2     0     0     0     0     2     0     1     1  \n",
       "Q3_1     4     0     1     2     1     1     1     1     3  \n",
       "Q3_2     2     0     0     1     0     0     1     0     1  \n",
       "Q3_3     0     1     0     0     0     1     0     0     0  \n",
       "Q3_4     2     0     0     1     1     3     1     1     0  \n",
       "Q3_5     1     0     0     0     1     0     0     0     0  \n",
       "Q4_1     2     0     1     1     1     2     1     0     0  \n",
       "Q4_2     1     1     0     0     1     1     1     0     1  \n",
       "Q4_3     4     0     0     3     1     0     1     1     2  \n",
       "Q4_4     0     0     0     0     0     0     0     1     0  \n",
       "Q4_5     2     0     0     0     0     2     0     0     1  \n",
       "Q5_1     0     0     0     3     1     1     1     2     2  \n",
       "Q5_2     9     0     0     1     2     2     2     0     2  \n",
       "Q5_3     0     1     0     0     0     1     0     0     0  \n",
       "Q5_4     0     0     1     0     0     1     0     0     0  \n",
       "Q6_1     1     0     0     4     0     0     0     0     0  \n",
       "Q6_2     2     0     0     0     3     0     0     0     0  \n",
       "Q6_3     2     1     1     0     0     5     0     0     0  \n",
       "Q6_4     2     0     0     0     0     0     3     0     0  \n",
       "Q6_5     0     0     0     0     0     0     0     2     0  \n",
       "Q6_6     2     0     0     0     0     0     0     0     4  \n",
       "\n",
       "[25 rows x 25 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def Tab_burt(file):\n",
    "  tab_de_codage_disjonctif_complet = pd.read_csv(file)\n",
    "  Burt = tab_de_codage_disjonctif_complet.T.dot(tab_de_codage_disjonctif_complet)\n",
    "  return Burt\n",
    "  \n",
    "Tab_burt(\"./backend/coding_table/tableau_de_codage_disjonctif_complet.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "77d49bae",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "      Q2_1  Q2_2  Q2_3\n",
      "Q1_1     8     5     2\n",
      "Q1_2     3     1     2\n",
      "      Q3_1  Q3_2  Q3_3  Q3_4  Q3_5\n",
      "Q1_1     7     2     1     4     1\n",
      "Q1_2     2     1     0     3     0\n",
      "      Q4_1  Q4_2  Q4_3  Q4_4  Q4_5\n",
      "Q1_1     3     3     7     1     1\n",
      "Q1_2     2     1     1     0     2\n",
      "      Q5_1  Q5_2  Q5_3  Q5_4\n",
      "Q1_1     9     5     1     0\n",
      "Q1_2     1     4     0     1\n",
      "      Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6\n",
      "Q1_1     4     2     2     2     1     4\n",
      "Q1_2     0     1     3     1     1     0\n",
      "      Q3_1  Q3_2  Q3_3  Q3_4  Q3_5\n",
      "Q2_1     6     0     0     5     0\n",
      "Q2_2     2     2     1     0     1\n",
      "Q2_3     1     1     0     2     0\n",
      "      Q4_1  Q4_2  Q4_3  Q4_4  Q4_5\n",
      "Q2_1     3     3     5     0     0\n",
      "Q2_2     2     1     3     0     0\n",
      "Q2_3     0     0     0     1     3\n",
      "      Q5_1  Q5_2  Q5_3  Q5_4\n",
      "Q2_1     8     2     0     1\n",
      "Q2_2     0     5     1     0\n",
      "Q2_3     2     2     0     0\n",
      "      Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6\n",
      "Q2_1     3     2     2     1     1     2\n",
      "Q2_2     1     1     1     2     0     1\n",
      "Q2_3     0     0     2     0     1     1\n",
      "      Q4_1  Q4_2  Q4_3  Q4_4  Q4_5\n",
      "Q3_1     2     2     4     1     0\n",
      "Q3_2     1     0     1     0     1\n",
      "Q3_3     0     1     0     0     0\n",
      "Q3_4     1     1     3     0     2\n",
      "Q3_5     1     0     0     0     0\n",
      "      Q5_1  Q5_2  Q5_3  Q5_4\n",
      "Q3_1     4     4     0     1\n",
      "Q3_2     1     2     0     0\n",
      "Q3_3     0     0     1     0\n",
      "Q3_4     5     2     0     0\n",
      "Q3_5     0     1     0     0\n",
      "      Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6\n",
      "Q3_1     2     1     1     1     1     3\n",
      "Q3_2     1     0     0     1     0     1\n",
      "Q3_3     0     0     1     0     0     0\n",
      "Q3_4     1     1     3     1     1     0\n",
      "Q3_5     0     1     0     0     0     0\n",
      "      Q5_1  Q5_2  Q5_3  Q5_4\n",
      "Q4_1     2     2     0     1\n",
      "Q4_2     2     1     1     0\n",
      "Q4_3     4     4     0     0\n",
      "Q4_4     1     0     0     0\n",
      "Q4_5     1     2     0     0\n",
      "      Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6\n",
      "Q4_1     1     1     2     1     0     0\n",
      "Q4_2     0     1     1     1     0     1\n",
      "Q4_3     3     1     0     1     1     2\n",
      "Q4_4     0     0     0     0     1     0\n",
      "Q4_5     0     0     2     0     0     1\n",
      "      Q6_1  Q6_2  Q6_3  Q6_4  Q6_5  Q6_6\n",
      "Q5_1     3     1     1     1     2     2\n",
      "Q5_2     1     2     2     2     0     2\n",
      "Q5_3     0     0     1     0     0     0\n",
      "Q5_4     0     0     1     0     0     0\n"
     ]
    }
   ],
   "source": [
    "def TabContingence(file):\n",
    "  tab_de_codage_disjonctif_complet = pd.read_csv(file)\n",
    "  Burt = tab_de_codage_disjonctif_complet.T.dot(tab_de_codage_disjonctif_complet)\n",
    "\n",
    "  lest = [0]\n",
    "  index = 0 \n",
    "  to_start = 'Q1_1'\n",
    "  for i in Burt.columns:\n",
    "    if(to_start[0:2] == i[0:2]):\n",
    "      index = index + 1\n",
    "    else:\n",
    "      lest.append(index)\n",
    "      index = index + 1\n",
    "      to_start = i\n",
    "\n",
    "  lest.append(index)\n",
    "\n",
    "  for i in range(1, len(lest)):\n",
    "    for j in range(i + 1, len(lest)):\n",
    "      tab_contingence = Burt.iloc[lest[i-1]:lest[i],lest[j-1]:lest[j]]\n",
    "      df = pd.DataFrame(tab_contingence)\n",
    "      print(df)\n",
    "\n",
    "\n",
    "TabContingence(\"./backend/coding_table/tableau_de_codage_disjonctif_complet.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "4e523efe",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Original Data:\n",
      "            ph    Hardness        Solids  Chloramines     Sulfate  \\\n",
      "0          NaN  204.890455  20791.318981     7.300212  368.516441   \n",
      "1     3.716080  129.422921  18630.057858     6.635246         NaN   \n",
      "2     8.099124  224.236259  19909.541732     9.275884         NaN   \n",
      "3     8.316766  214.373394  22018.417441     8.059332  356.886136   \n",
      "4     9.092223  181.101509  17978.986339     6.546600  310.135738   \n",
      "...        ...         ...           ...          ...         ...   \n",
      "3271  4.668102  193.681735  47580.991603     7.166639  359.948574   \n",
      "3272  7.808856  193.553212  17329.802160     8.061362         NaN   \n",
      "3273  9.419510  175.762646  33155.578218     7.350233         NaN   \n",
      "3274  5.126763  230.603758  11983.869376     6.303357         NaN   \n",
      "3275  7.874671  195.102299  17404.177061     7.509306         NaN   \n",
      "\n",
      "      Conductivity  Organic_carbon  Trihalomethanes  Turbidity  Potability  \n",
      "0       564.308654       10.379783        86.990970   2.963135           0  \n",
      "1       592.885359       15.180013        56.329076   4.500656           0  \n",
      "2       418.606213       16.868637        66.420093   3.055934           0  \n",
      "3       363.266516       18.436524       100.341674   4.628771           0  \n",
      "4       398.410813       11.558279        31.997993   4.075075           0  \n",
      "...            ...             ...              ...        ...         ...  \n",
      "3271    526.424171       13.894419        66.687695   4.435821           1  \n",
      "3272    392.449580       19.903225              NaN   2.798243           1  \n",
      "3273    432.044783       11.039070        69.845400   3.298875           1  \n",
      "3274    402.883113       11.168946        77.488213   4.708658           1  \n",
      "3275    327.459760       16.140368        78.698446   2.309149           1  \n",
      "\n",
      "[3276 rows x 10 columns]\n",
      "\n",
      "Imputed Data:\n",
      "             0           1             2         3           4           5  \\\n",
      "0     6.007427  204.890455  20791.318981  7.300212  368.516441  564.308654   \n",
      "1     3.716080  129.422921  18630.057858  6.635246  326.479827  592.885359   \n",
      "2     8.099124  224.236259  19909.541732  9.275884  357.947334  418.606213   \n",
      "3     8.316766  214.373394  22018.417441  8.059332  356.886136  363.266516   \n",
      "4     9.092223  181.101509  17978.986339  6.546600  310.135738  398.410813   \n",
      "...        ...         ...           ...       ...         ...         ...   \n",
      "3271  4.668102  193.681735  47580.991603  7.166639  359.948574  526.424171   \n",
      "3272  7.808856  193.553212  17329.802160  8.061362  355.544770  392.449580   \n",
      "3273  9.419510  175.762646  33155.578218  7.350233  321.930158  432.044783   \n",
      "3274  5.126763  230.603758  11983.869376  6.303357  338.733772  402.883113   \n",
      "3275  7.874671  195.102299  17404.177061  7.509306  335.431261  327.459760   \n",
      "\n",
      "              6           7         8    9  \n",
      "0     10.379783   86.990970  2.963135  0.0  \n",
      "1     15.180013   56.329076  4.500656  0.0  \n",
      "2     16.868637   66.420093  3.055934  0.0  \n",
      "3     18.436524  100.341674  4.628771  0.0  \n",
      "4     11.558279   31.997993  4.075075  0.0  \n",
      "...         ...         ...       ...  ...  \n",
      "3271  13.894419   66.687695  4.435821  1.0  \n",
      "3272  19.903225   46.827049  2.798243  1.0  \n",
      "3273  11.039070   69.845400  3.298875  1.0  \n",
      "3274  11.168946   77.488213  4.708658  1.0  \n",
      "3275  16.140368   78.698446  2.309149  1.0  \n",
      "\n",
      "[3276 rows x 10 columns]\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from sklearn.impute import KNNImputer\n",
    "\n",
    "# Sample data with missing values (NaN)\n",
    "data = pd.read_csv(\"../../water_potability.csv\") \n",
    "\n",
    "# Create the imputer with 2 neighbors\n",
    "imputer = KNNImputer(n_neighbors=2, weights=\"uniform\")\n",
    "\n",
    "# Impute missing values\n",
    "imputed_data = imputer.fit_transform(data)\n",
    "imputed_data = pd.DataFrame(imputed_data)\n",
    "\n",
    "print(\"Original Data:\")\n",
    "print(data)\n",
    "print(\"\\nImputed Data:\")\n",
    "print(imputed_data)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1ba52ff2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'ph': 491, 'Hardness': 0, 'Solids': 0, 'Chloramines': 0, 'Sulfate': 781, 'Conductivity': 0, 'Organic_carbon': 0, 'Trihalomethanes': 162, 'Turbidity': 0, 'Potability': 0}\n"
     ]
    }
   ],
   "source": [
    "import math\n",
    "\n",
    "def nbValManquantes(pd):\n",
    "  valManqua = {}\n",
    "  for col in pd:\n",
    "    sum = 0\n",
    "    for row in pd[col]:\n",
    "      if math.isnan(row):\n",
    "        sum += 1\n",
    "\n",
    "    valManqua[col] = sum \n",
    "\n",
    "  return valManqua\n",
    "\n",
    "data = pd.read_csv(\"../../water_potability.csv\" ) \n",
    "print(nbValManquantes(data))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "83eb62f3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Pairwise distances between all rows, ignoring NaNs:\n",
      "[[    0.          2162.99043406   894.20565616 ... 12365.01290638\n",
      "   8808.97178331  3395.4420938 ]\n",
      " [ 2162.99043406     0.          1294.82613735 ... 14526.49283629\n",
      "   6649.70876729  1256.21392643]\n",
      " [  894.20565616  1294.82613735     0.         ... 13246.13396816\n",
      "   7925.70163752  2507.22249045]\n",
      " ...\n",
      " [12365.01290638 14526.49283629 13246.13396816 ...     0.\n",
      "  21171.80184067 15751.76365545]\n",
      " [ 8808.97178331  6649.70876729  7925.70163752 ... 21171.80184067\n",
      "      0.          5420.95244172]\n",
      " [ 3395.4420938   1256.21392643  2507.22249045 ... 15751.76365545\n",
      "   5420.95244172     0.        ]]\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "\n",
    "# Load the data\n",
    "file_path = \"../../water_potability.csv\"\n",
    "data = np.genfromtxt(file_path, delimiter=',', skip_header=1)\n",
    "\n",
    "def calculate_all_row_distances_with_nan(data):\n",
    "    # Expand dimensions to compute pairwise differences\n",
    "    data_expanded = np.expand_dims(data, axis=1)  # Shape (n_rows, 1, n_columns)\n",
    "    diff = data_expanded - data  # Pairwise differences: Shape (n_rows, n_rows, n_columns)\n",
    "\n",
    "    # Square the differences\n",
    "    squared_diff = diff ** 2\n",
    "\n",
    "    # Ignore NaNs in the summation\n",
    "    squared_diff_sum = np.nansum(squared_diff, axis=2)  # Sum along columns (axis=2)\n",
    "\n",
    "    # Take the square root to get the Euclidean distance\n",
    "    distances = np.sqrt(squared_diff_sum)\n",
    "\n",
    "    return distances\n",
    "\n",
    "# Example usage: Calculate distances for all rows\n",
    "distances = calculate_all_row_distances_with_nan(data)\n",
    "\n",
    "print(\"Pairwise distances between all rows, ignoring NaNs:\")\n",
    "print(distances)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.12.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}