creation_base.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "connexion = sqlite3.connect(\"toutroule.db\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "curseur = connexion.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "creation_table = \"\"\"\n",
    "CREATE TABLE vehicules(\n",
    "   id_vehicule INTEGER PRIMARY KEY,\n",
    "   type VARCHAR(50) NOT NULL\n",
    ");\n",
    "\"\"\" "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Cursor at 0x1bc4f7ffb40>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "curseur.execute(creation_table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "table_chauffeur = \"\"\"\n",
    "CREATE TABLE chauffeurs(\n",
    "   id_chauffeur INTEGER PRIMARY KEY,\n",
    "   nom VARCHAR(50) NOT NULL,\n",
    "   prenom VARCHAR(50) NOT NULL,\n",
    "   genre VARCHAR(2) NOT NULL\n",
    ");\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Cursor at 0x1bc4f7ffb40>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "curseur.execute(table_chauffeur)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "table_trajets = \"\"\"\n",
    "CREATE TABLE trajets(\n",
    "   id_trajet INTEGER PRIMARY KEY,\n",
    "   km_fin INT NOT NULL,\n",
    "   km_debut INT NOT NULL,\n",
    "   commentaire VARCHAR(250),\n",
    "   id_vehicule CHAR(50) NOT NULL,\n",
    "   id_chauffeur INT NOT NULL,\n",
    "   FOREIGN KEY(id_vehicule) REFERENCES vehicule(id_vehicule),\n",
    "   FOREIGN KEY(id_chauffeur) REFERENCES chauffeurs(id_chauffeur)\n",
    ");\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Cursor at 0x1bc4f7ffb40>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "curseur.execute(table_trajets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "connexion.commit()\n",
    "connexion.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('Antoine', 'Antoine'), ('Antoine', 'Antoine')]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "connexion = sqlite3.connect(\"toutroule.db\")\n",
    "curseur = connexion.cursor()\n",
    "f_prenom = curseur.execute(\"SELECT prenom FROM chauffeurs WHERE nom = ?\", (\"Mouré\",))\n",
    "f_prenom = [(resultat[0], resultat[0]) for resultat in f_prenom]\n",
    "f_prenom    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>id_chauffeur</th>\n",
       "      <th>nom</th>\n",
       "      <th>prenom</th>\n",
       "      <th>genre</th>\n",
       "      <th>id_vehicule</th>\n",
       "      <th>type</th>\n",
       "      <th>id_trajet</th>\n",
       "      <th>km_debut</th>\n",
       "      <th>km_fin</th>\n",
       "      <th>commentaire</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>1</td>\n",
       "      <td>800</td>\n",
       "      <td>600</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>3</td>\n",
       "      <td>camion benne</td>\n",
       "      <td>2</td>\n",
       "      <td>900</td>\n",
       "      <td>1000</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>3</td>\n",
       "      <td>5200</td>\n",
       "      <td>5260</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>4</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>5</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>6</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>7</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>8</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>9</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>10</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>11</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>12</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>13</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>14</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>15</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>16</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>17</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>18</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>19</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>20</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>21</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>22</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>23</td>\n",
       "      <td>5500</td>\n",
       "      <td>5540</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>2</td>\n",
       "      <td>camion frigorifique</td>\n",
       "      <td>24</td>\n",
       "      <td>54200</td>\n",
       "      <td>54300</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "      <td>1</td>\n",
       "      <td>camion citerne</td>\n",
       "      <td>25</td>\n",
       "      <td>45000</td>\n",
       "      <td>45200</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>3</td>\n",
       "      <td>Mouré</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>M</td>\n",
       "      <td>3</td>\n",
       "      <td>camion benne</td>\n",
       "      <td>26</td>\n",
       "      <td>5400</td>\n",
       "      <td>5420</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id_chauffeur    nom   prenom genre  id_vehicule                 type  \\\n",
       "0              1    Mer      Lou     M            1       camion citerne   \n",
       "1              1    Mer      Lou     M            3         camion benne   \n",
       "2              1    Mer      Lou     M            1       camion citerne   \n",
       "3              1    Mer      Lou     M            1       camion citerne   \n",
       "4              1    Mer      Lou     M            1       camion citerne   \n",
       "5              1    Mer      Lou     M            1       camion citerne   \n",
       "6              1    Mer      Lou     M            1       camion citerne   \n",
       "7              1    Mer      Lou     M            1       camion citerne   \n",
       "8              1    Mer      Lou     M            1       camion citerne   \n",
       "9              1    Mer      Lou     M            1       camion citerne   \n",
       "10             1    Mer      Lou     M            1       camion citerne   \n",
       "11             1    Mer      Lou     M            1       camion citerne   \n",
       "12             1    Mer      Lou     M            1       camion citerne   \n",
       "13             1    Mer      Lou     M            1       camion citerne   \n",
       "14             1    Mer      Lou     M            1       camion citerne   \n",
       "15             1    Mer      Lou     M            1       camion citerne   \n",
       "16             1    Mer      Lou     M            1       camion citerne   \n",
       "17             1    Mer      Lou     M            1       camion citerne   \n",
       "18             1    Mer      Lou     M            1       camion citerne   \n",
       "19             1    Mer      Lou     M            1       camion citerne   \n",
       "20             1    Mer      Lou     M            1       camion citerne   \n",
       "21             1    Mer      Lou     M            1       camion citerne   \n",
       "22             1    Mer      Lou     M            1       camion citerne   \n",
       "23             1    Mer      Lou     M            2  camion frigorifique   \n",
       "24             1    Mer      Lou     M            1       camion citerne   \n",
       "25             3  Mouré  Antoine     M            3         camion benne   \n",
       "\n",
       "    id_trajet  km_debut  km_fin commentaire  \n",
       "0           1       800     600              \n",
       "1           2       900    1000              \n",
       "2           3      5200    5260              \n",
       "3           4      5500    5540              \n",
       "4           5      5500    5540              \n",
       "5           6      5500    5540              \n",
       "6           7      5500    5540              \n",
       "7           8      5500    5540              \n",
       "8           9      5500    5540              \n",
       "9          10      5500    5540              \n",
       "10         11      5500    5540              \n",
       "11         12      5500    5540              \n",
       "12         13      5500    5540              \n",
       "13         14      5500    5540              \n",
       "14         15      5500    5540              \n",
       "15         16      5500    5540              \n",
       "16         17      5500    5540              \n",
       "17         18      5500    5540              \n",
       "18         19      5500    5540              \n",
       "19         20      5500    5540              \n",
       "20         21      5500    5540              \n",
       "21         22      5500    5540              \n",
       "22         23      5500    5540              \n",
       "23         24     54200   54300              \n",
       "24         25     45000   45200              \n",
       "25         26      5400    5420              "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import sqlite3\n",
    "import pandas as pd\n",
    "\n",
    "con = sqlite3.connect('toutroule.db')\n",
    "cursor = con.cursor()\n",
    "cursor.execute('''SELECT\n",
    "    c.id_chauffeur,\n",
    "    c.nom,\n",
    "    c.prenom,\n",
    "    c.genre,\n",
    "    v.id_vehicule,\n",
    "    v.type,\n",
    "    t.id_trajet,\n",
    "    t.km_debut,\n",
    "    t.km_fin,\n",
    "    t.commentaire\n",
    "FROM\n",
    "    trajets as t\n",
    "    JOIN chauffeurs as c ON t.id_chauffeur = c.id_chauffeur\n",
    "    JOIN vehicules as v ON t.id_vehicule = v.id_vehicule''')  \n",
    "#===============================================================\n",
    "# Récupérez toutes les lignes dans un DataFrame\n",
    "df = pd.DataFrame(cursor.fetchall(), columns=[  \n",
    "    'id_chauffeur',\n",
    "    'nom',\n",
    "    'prenom',\n",
    "    'genre',\n",
    "    'id_vehicule',\n",
    "    'type',\n",
    "    'id_trajet',\n",
    "    'km_debut',\n",
    "    'km_fin',\n",
    "    'commentaire'\n",
    "])\n",
    "\n",
    "\n",
    "con.close() \n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>nom</th>\n",
       "      <th>prenom</th>\n",
       "      <th>genre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mer</td>\n",
       "      <td>Lou</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Mouré</td>\n",
       "      <td>Antoine</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      nom   prenom genre\n",
       "0     Mer      Lou     M\n",
       "25  Mouré  Antoine     M"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_identite = df[[\"nom\", \"prenom\",'genre']].drop_duplicates()\n",
    "df_identite"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Louve']"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "connexion = sqlite3.connect(\"toutroule.db\")\n",
    "curseur = connexion.cursor()\n",
    "# Récupérez la liste des types de véhicules depuis la base de données\n",
    "f_prenom = curseur.execute(f\"SELECT prenom FROM chauffeurs WHERE nom = '{'Mer'}'\")\n",
    "f_prenom = [resultat[0] for resultat in f_prenom]\n",
    "f_prenom"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "envprojetflask",
   "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.10.11"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}