Ingestion PBI JIRA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "C:\\Users\\T0230575\\Desktop\\Export JIRA\\AJIR Thales 2021-03-17T13_41_45+0100.csv\n"
     ]
    },
    {
     "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>Résumé</th>\n",
       "      <th>Clé de ticket</th>\n",
       "      <th>ID de ticket</th>\n",
       "      <th>Type de ticket</th>\n",
       "      <th>Etat</th>\n",
       "      <th>Clé de projet</th>\n",
       "      <th>Nom du projet</th>\n",
       "      <th>Type de projet</th>\n",
       "      <th>Chef de projet</th>\n",
       "      <th>Description du projet</th>\n",
       "      <th>...</th>\n",
       "      <th>Gérer les observateurs</th>\n",
       "      <th>Gérer les observateurs.1</th>\n",
       "      <th>Estimation originale</th>\n",
       "      <th>Estimation restante</th>\n",
       "      <th>Temps consacré</th>\n",
       "      <th>Ratio du travail réel comparé à l'estimation</th>\n",
       "      <th>Σ Estimation originale</th>\n",
       "      <th>Σ Estimation restante</th>\n",
       "      <th>Σ Temps consacré</th>\n",
       "      <th>Niveau de sécurité</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DataLunch KAST</td>\n",
       "      <td>DALAB-25</td>\n",
       "      <td>752725</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0249938</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Voir avec Florian Hadjhadj l'existant</td>\n",
       "      <td>DALAB-24</td>\n",
       "      <td>751844</td>\n",
       "      <td>Récit</td>\n",
       "      <td>Fini</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>proposer de nouveaux dashboards</td>\n",
       "      <td>DALAB-23</td>\n",
       "      <td>751843</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Création API Producteur-consommateur</td>\n",
       "      <td>DALAB-22</td>\n",
       "      <td>751842</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Etablir l'analyse multi-vols</td>\n",
       "      <td>DALAB-21</td>\n",
       "      <td>751841</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Retranscrire les graphes en dashboard</td>\n",
       "      <td>DALAB-20</td>\n",
       "      <td>751840</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mettre en DB les données calculées</td>\n",
       "      <td>DALAB-19</td>\n",
       "      <td>751839</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Effectuer le retro-engineering des algorithmes</td>\n",
       "      <td>DALAB-18</td>\n",
       "      <td>751838</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mettre en DB les données brutes</td>\n",
       "      <td>DALAB-17</td>\n",
       "      <td>751836</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Modèle de données</td>\n",
       "      <td>DALAB-16</td>\n",
       "      <td>751835</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Macro Architecture</td>\n",
       "      <td>DALAB-15</td>\n",
       "      <td>751817</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Architecture</td>\n",
       "      <td>DALAB-14</td>\n",
       "      <td>751559</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Data Catalogue</td>\n",
       "      <td>DALAB-13</td>\n",
       "      <td>751558</td>\n",
       "      <td>Récit</td>\n",
       "      <td>Fini</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Data Lineage</td>\n",
       "      <td>DALAB-12</td>\n",
       "      <td>751557</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Reprise du Data Assessment du Step 1 pour coll...</td>\n",
       "      <td>DALAB-11</td>\n",
       "      <td>751555</td>\n",
       "      <td>Récit</td>\n",
       "      <td>En Cours</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[IAS] Outil de restitution pour l'ACCS + outil...</td>\n",
       "      <td>DALAB-10</td>\n",
       "      <td>751552</td>\n",
       "      <td>Épopée</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>T0229555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Indexation fichiers</td>\n",
       "      <td>DALAB-9</td>\n",
       "      <td>751436</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ingestion données</td>\n",
       "      <td>DALAB-8</td>\n",
       "      <td>751244</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ingestion données</td>\n",
       "      <td>DALAB-7</td>\n",
       "      <td>751242</td>\n",
       "      <td>Récit</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Datalake CD</td>\n",
       "      <td>DALAB-6</td>\n",
       "      <td>751241</td>\n",
       "      <td>Épopée</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Spy Ranger</td>\n",
       "      <td>DALAB-5</td>\n",
       "      <td>751240</td>\n",
       "      <td>Épopée</td>\n",
       "      <td>A Faire</td>\n",
       "      <td>DALAB</td>\n",
       "      <td>DataLab</td>\n",
       "      <td>software</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>t0147291</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>External</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>21 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Résumé Clé de ticket  \\\n",
       "0                                      DataLunch KAST      DALAB-25   \n",
       "1               Voir avec Florian Hadjhadj l'existant      DALAB-24   \n",
       "2                     proposer de nouveaux dashboards      DALAB-23   \n",
       "3                Création API Producteur-consommateur      DALAB-22   \n",
       "4                       Etablir l'analyse multi-vols       DALAB-21   \n",
       "5               Retranscrire les graphes en dashboard      DALAB-20   \n",
       "6                  Mettre en DB les données calculées      DALAB-19   \n",
       "7      Effectuer le retro-engineering des algorithmes      DALAB-18   \n",
       "8                     Mettre en DB les données brutes      DALAB-17   \n",
       "9                                   Modèle de données      DALAB-16   \n",
       "10                                 Macro Architecture      DALAB-15   \n",
       "11                                       Architecture      DALAB-14   \n",
       "12                                     Data Catalogue      DALAB-13   \n",
       "13                                       Data Lineage      DALAB-12   \n",
       "14  Reprise du Data Assessment du Step 1 pour coll...      DALAB-11   \n",
       "15  [IAS] Outil de restitution pour l'ACCS + outil...      DALAB-10   \n",
       "16                                Indexation fichiers       DALAB-9   \n",
       "17                                  Ingestion données       DALAB-8   \n",
       "18                                  Ingestion données       DALAB-7   \n",
       "19                                        Datalake CD       DALAB-6   \n",
       "20                                         Spy Ranger       DALAB-5   \n",
       "\n",
       "    ID de ticket Type de ticket      Etat Clé de projet Nom du projet  \\\n",
       "0         752725          Récit  En Cours         DALAB       DataLab   \n",
       "1         751844          Récit      Fini         DALAB       DataLab   \n",
       "2         751843          Récit   A Faire         DALAB       DataLab   \n",
       "3         751842          Récit   A Faire         DALAB       DataLab   \n",
       "4         751841          Récit   A Faire         DALAB       DataLab   \n",
       "5         751840          Récit   A Faire         DALAB       DataLab   \n",
       "6         751839          Récit   A Faire         DALAB       DataLab   \n",
       "7         751838          Récit   A Faire         DALAB       DataLab   \n",
       "8         751836          Récit  En Cours         DALAB       DataLab   \n",
       "9         751835          Récit  En Cours         DALAB       DataLab   \n",
       "10        751817          Récit   A Faire         DALAB       DataLab   \n",
       "11        751559          Récit  En Cours         DALAB       DataLab   \n",
       "12        751558          Récit      Fini         DALAB       DataLab   \n",
       "13        751557          Récit  En Cours         DALAB       DataLab   \n",
       "14        751555          Récit  En Cours         DALAB       DataLab   \n",
       "15        751552         Épopée   A Faire         DALAB       DataLab   \n",
       "16        751436          Récit   A Faire         DALAB       DataLab   \n",
       "17        751244          Récit   A Faire         DALAB       DataLab   \n",
       "18        751242          Récit   A Faire         DALAB       DataLab   \n",
       "19        751241         Épopée   A Faire         DALAB       DataLab   \n",
       "20        751240         Épopée   A Faire         DALAB       DataLab   \n",
       "\n",
       "   Type de projet Chef de projet  Description du projet        ...          \\\n",
       "0        software       t0147291                    NaN        ...           \n",
       "1        software       t0147291                    NaN        ...           \n",
       "2        software       t0147291                    NaN        ...           \n",
       "3        software       t0147291                    NaN        ...           \n",
       "4        software       t0147291                    NaN        ...           \n",
       "5        software       t0147291                    NaN        ...           \n",
       "6        software       t0147291                    NaN        ...           \n",
       "7        software       t0147291                    NaN        ...           \n",
       "8        software       t0147291                    NaN        ...           \n",
       "9        software       t0147291                    NaN        ...           \n",
       "10       software       t0147291                    NaN        ...           \n",
       "11       software       t0147291                    NaN        ...           \n",
       "12       software       t0147291                    NaN        ...           \n",
       "13       software       t0147291                    NaN        ...           \n",
       "14       software       t0147291                    NaN        ...           \n",
       "15       software       t0147291                    NaN        ...           \n",
       "16       software       t0147291                    NaN        ...           \n",
       "17       software       t0147291                    NaN        ...           \n",
       "18       software       t0147291                    NaN        ...           \n",
       "19       software       t0147291                    NaN        ...           \n",
       "20       software       t0147291                    NaN        ...           \n",
       "\n",
       "    Gérer les observateurs Gérer les observateurs.1 Estimation originale  \\\n",
       "0                 t0147291                 T0249938                  NaN   \n",
       "1                 t0147291                 T0229555                  NaN   \n",
       "2                 t0147291                 T0229555                  NaN   \n",
       "3                 t0147291                 T0229555                  NaN   \n",
       "4                 t0147291                 T0229555                  NaN   \n",
       "5                 t0147291                 T0229555                  NaN   \n",
       "6                 t0147291                 T0229555                  NaN   \n",
       "7                 t0147291                 T0229555                  NaN   \n",
       "8                 t0147291                 T0229555                  NaN   \n",
       "9                 t0147291                 T0229555                  NaN   \n",
       "10                t0147291                      NaN                  NaN   \n",
       "11                t0147291                 T0229555                  NaN   \n",
       "12                t0147291                 T0229555                  NaN   \n",
       "13                t0147291                 T0229555                  NaN   \n",
       "14                t0147291                 T0229555                  NaN   \n",
       "15                T0229555                      NaN                  NaN   \n",
       "16                t0147291                      NaN                  NaN   \n",
       "17                t0147291                      NaN                  NaN   \n",
       "18                t0147291                      NaN                  NaN   \n",
       "19                t0147291                      NaN                  NaN   \n",
       "20                t0147291                      NaN                  NaN   \n",
       "\n",
       "   Estimation restante Temps consacré  \\\n",
       "0                  NaN            NaN   \n",
       "1                  NaN            NaN   \n",
       "2                  NaN            NaN   \n",
       "3                  NaN            NaN   \n",
       "4                  NaN            NaN   \n",
       "5                  NaN            NaN   \n",
       "6                  NaN            NaN   \n",
       "7                  NaN            NaN   \n",
       "8                  NaN            NaN   \n",
       "9                  NaN            NaN   \n",
       "10                 NaN            NaN   \n",
       "11                 NaN            NaN   \n",
       "12                 NaN            NaN   \n",
       "13                 NaN            NaN   \n",
       "14                 NaN            NaN   \n",
       "15                 NaN            NaN   \n",
       "16                 NaN            NaN   \n",
       "17                 NaN            NaN   \n",
       "18                 NaN            NaN   \n",
       "19                 NaN            NaN   \n",
       "20                 NaN            NaN   \n",
       "\n",
       "   Ratio du travail réel comparé à l'estimation Σ Estimation originale  \\\n",
       "0                                           NaN                    NaN   \n",
       "1                                           NaN                    NaN   \n",
       "2                                           NaN                    NaN   \n",
       "3                                           NaN                    NaN   \n",
       "4                                           NaN                    NaN   \n",
       "5                                           NaN                    NaN   \n",
       "6                                           NaN                    NaN   \n",
       "7                                           NaN                    NaN   \n",
       "8                                           NaN                    NaN   \n",
       "9                                           NaN                    NaN   \n",
       "10                                          NaN                    NaN   \n",
       "11                                          NaN                    NaN   \n",
       "12                                          NaN                    NaN   \n",
       "13                                          NaN                    NaN   \n",
       "14                                          NaN                    NaN   \n",
       "15                                          NaN                    NaN   \n",
       "16                                          NaN                    NaN   \n",
       "17                                          NaN                    NaN   \n",
       "18                                          NaN                    NaN   \n",
       "19                                          NaN                    NaN   \n",
       "20                                          NaN                    NaN   \n",
       "\n",
       "   Σ Estimation restante Σ Temps consacré Niveau de sécurité  \n",
       "0                    NaN              NaN           External  \n",
       "1                    NaN              NaN           External  \n",
       "2                    NaN              NaN           External  \n",
       "3                    NaN              NaN           External  \n",
       "4                    NaN              NaN           External  \n",
       "5                    NaN              NaN           External  \n",
       "6                    NaN              NaN           External  \n",
       "7                    NaN              NaN           External  \n",
       "8                    NaN              NaN           External  \n",
       "9                    NaN              NaN           External  \n",
       "10                   NaN              NaN           External  \n",
       "11                   NaN              NaN           External  \n",
       "12                   NaN              NaN           External  \n",
       "13                   NaN              NaN           External  \n",
       "14                   NaN              NaN           External  \n",
       "15                   NaN              NaN           External  \n",
       "16                   NaN              NaN           External  \n",
       "17                   NaN              NaN           External  \n",
       "18                   NaN              NaN           External  \n",
       "19                   NaN              NaN           External  \n",
       "20                   NaN              NaN           External  \n",
       "\n",
       "[21 rows x 35 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os, sys\n",
    "import glob\n",
    "import time\n",
    "from pathlib import Path\n",
    "\n",
    "extension = \"/*.csv\"\n",
    "path = 'C:/Users/T0230575/Desktop/Export JIRA/'\n",
    "os.chdir('C:/Users/T0230575/Desktop/Export JIRA/')\n",
    "\n",
    "latest_file = glob.glob(os.getcwd() + '/*.csv')\n",
    "latest_df = max(latest_file, key = os.path.getctime)\n",
    "print(latest_df)\n",
    "\n",
    "jira_df = pd.read_csv(latest_df, sep='|', encoding='utf-8')\n",
    "jira_df = jira_df[jira_df.columns.drop(list(jira_df.filter(regex='Champs personnalisés')))]\n",
    "jira_df\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}