{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", "\n", "\n", "\n", "\n", "AuFilDuBoamp_Lab par Semaine52\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "\n", "
\n", "
\n", " \n", "   AuFilDuBoamp_Lab sur GitHub\n", " \n", "   sur Twitter\n", " \n", "   sur DataGouv.fr\n", " \n", "   sur Binder\n", " \n", "   chez TeamOpenData\n", " \n", " \n", " \n", " \n", "   Le BOAMP sur DataGouv.fr\n", " \n", " BOAMP.fr\n", " \n", "   Code de la commande publique (Légifrance) \n", " \n", "
\n", " \n", "
\n", "\n", "
\n", "
\"AuFilDuBoamp_Lab\"
\n", "\n", "
\n", " \n", " \n", " \n", "   Lien vers le Sommaire général \n", "   Lancer Binder \n", "

N'oubliez pas « Run All Cells » du menu « Run » pour activer les pages une fois sur Binder.

\n", "
\n", " \n", "
\n", "\n", "\n", "\n", " \n", "\n", " " ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "%run afdb_lab_scripts/afdb_lab_prereglages\n", "%run afdb_lab_scripts/afdb_lab_haut" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "#### Un tour d'horizon des Tables du BOAMP\n", "\n", "À base des données recueillies en OpenData via l'API consacrée --> https://www.data.gouv.fr/fr/datasets/api-boamp-beta/\n", "\n", "----\n", "

Table D_18_annexed1

\n", "\n", "----\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "- **Navigateur**\n", " - **Chargement de la table**\n", " - **Schéma interactif de la table** \n", " - **Présentation brute des colonnes**\n", " - **Vue verticale de la table**\n", " - **Vue horizontale de la table**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "## Chargement de la table" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "extrait_df_d_18_annexed1 = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_18_Annexed1.pkl')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "## Schéma interactif de la table" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "application/vnd.jupyter.widget-view+json": { "model_id": "5c79d3680c9a4552bd382b9a7127af8a", "version_major": 2, "version_minor": 0 }, "text/plain": [ "Output(layout=Layout(border='3px solid #cccccc', margin='20px 100px 20px 100px', max_width='80%', padding='10p…" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "from afdb_lab_scripts.afficher_plan_html import afficher_plan_html\n", "afficher_plan_html(source=\"boamp_plans_html/boamp_plan_d_18_annexed1.html\");" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "[Ouvrir ce schéma en plein écran dans un nouvel onglet (cliquez sur « Trust HTML » s'il n'apparaît pas de lui-même à l'ouverture)](boamp_plans_html/boamp_plan_d_18_annexed1.html)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**
Remonter**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "## Présentation brute des colonnes" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "Index: 56 entries, 21-14053 to 21-8554\n", "Data columns (total 15 columns):\n", " # Column Non-Null Count Dtype \n", "--- ------ -------------- ----- \n", " 0 D_18_01_Annexed1_Infructueuxouverte 56 non-null bool \n", " 1 D_18_02_Annexed1_Infructueuxrestreinte 56 non-null bool \n", " 2 D_18_03_Annexed1_Recherche 56 non-null bool \n", " 3 D_18_04_Annexed1_Raisonstechniques 56 non-null bool \n", " 4 D_18_05_Annexed1_Raisonsartistiques 56 non-null bool \n", " 5 D_18_06_Annexed1_Proprieteintellectuelle 56 non-null bool \n", " 6 D_18_07_Annexed1_Urgenceimperieuse 56 non-null bool \n", " 7 D_18_08_Annexed1_Marchecomplementaire 0 non-null object\n", " 8 D_18_09_Annexed1_Prestationsidentiques 56 non-null bool \n", " 9 D_18_10_Annexed1_Laureatsconcours 56 non-null bool \n", " 10 D_18_11_Annexed1_Matierespremieres 0 non-null object\n", " 11 D_18_12_Annexed1_Cessationactivite 0 non-null object\n", " 12 D_18_13_Annexed1_Liquidateurs 0 non-null object\n", " 13 D_18_14_Annexed1_Horsscope 56 non-null bool \n", " 14 D_18_15_Annexed1_Explication 56 non-null object\n", "dtypes: bool(10), object(5)\n", "memory usage: 3.2+ KB\n" ] } ], "source": [ "extrait_df_d_18_annexed1.info()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**
Remonter**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "## Vue verticale de la table " ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
BOAMP_AVIS_NUM21-1405321-1417221-14613
D_18_01_Annexed1_InfructueuxouverteFalseFalseTrue
D_18_02_Annexed1_InfructueuxrestreinteFalseFalseFalse
D_18_03_Annexed1_RechercheFalseFalseFalse
D_18_04_Annexed1_RaisonstechniquesFalseFalseFalse
D_18_05_Annexed1_RaisonsartistiquesFalseFalseFalse
D_18_06_Annexed1_ProprieteintellectuelleFalseFalseFalse
D_18_07_Annexed1_UrgenceimperieuseFalseFalseFalse
D_18_08_Annexed1_MarchecomplementaireNoneNoneNone
D_18_09_Annexed1_PrestationsidentiquesFalseFalseFalse
D_18_10_Annexed1_LaureatsconcoursFalseFalseFalse
D_18_11_Annexed1_MatierespremieresNoneNoneNone
D_18_12_Annexed1_CessationactiviteNoneNoneNone
D_18_13_Annexed1_LiquidateursNoneNoneNone
D_18_14_Annexed1_HorsscopeTrueTrueFalse
D_18_15_Annexed1_ExplicationLa valeur totale du marché (175 136 euro(s) Ht) est inférieure aux seuils européens imposant une publication au JoueLes marchés subséquents découlent de l'accord-cadre dont l'avis de publicité à été transmis le 21 octobre 2021 sur la plateforme AwsAucune offre n'a été déposée lors de l'appel d'offres initial
\n", "
" ], "text/plain": [ "BOAMP_AVIS_NUM 21-14053 \\\n", "D_18_01_Annexed1_Infructueuxouverte False \n", "D_18_02_Annexed1_Infructueuxrestreinte False \n", "D_18_03_Annexed1_Recherche False \n", "D_18_04_Annexed1_Raisonstechniques False \n", "D_18_05_Annexed1_Raisonsartistiques False \n", "D_18_06_Annexed1_Proprieteintellectuelle False \n", "D_18_07_Annexed1_Urgenceimperieuse False \n", "D_18_08_Annexed1_Marchecomplementaire None \n", "D_18_09_Annexed1_Prestationsidentiques False \n", "D_18_10_Annexed1_Laureatsconcours False \n", "D_18_11_Annexed1_Matierespremieres None \n", "D_18_12_Annexed1_Cessationactivite None \n", "D_18_13_Annexed1_Liquidateurs None \n", "D_18_14_Annexed1_Horsscope True \n", "D_18_15_Annexed1_Explication La valeur totale du marché (175 136 euro(s) Ht) est inférieure aux seuils européens imposant une publication au Joue \n", "\n", "BOAMP_AVIS_NUM 21-14172 \\\n", "D_18_01_Annexed1_Infructueuxouverte False \n", "D_18_02_Annexed1_Infructueuxrestreinte False \n", "D_18_03_Annexed1_Recherche False \n", "D_18_04_Annexed1_Raisonstechniques False \n", "D_18_05_Annexed1_Raisonsartistiques False \n", "D_18_06_Annexed1_Proprieteintellectuelle False \n", "D_18_07_Annexed1_Urgenceimperieuse False \n", "D_18_08_Annexed1_Marchecomplementaire None \n", "D_18_09_Annexed1_Prestationsidentiques False \n", "D_18_10_Annexed1_Laureatsconcours False \n", "D_18_11_Annexed1_Matierespremieres None \n", "D_18_12_Annexed1_Cessationactivite None \n", "D_18_13_Annexed1_Liquidateurs None \n", "D_18_14_Annexed1_Horsscope True \n", "D_18_15_Annexed1_Explication Les marchés subséquents découlent de l'accord-cadre dont l'avis de publicité à été transmis le 21 octobre 2021 sur la plateforme Aws \n", "\n", "BOAMP_AVIS_NUM 21-14613 \n", "D_18_01_Annexed1_Infructueuxouverte True \n", "D_18_02_Annexed1_Infructueuxrestreinte False \n", "D_18_03_Annexed1_Recherche False \n", "D_18_04_Annexed1_Raisonstechniques False \n", "D_18_05_Annexed1_Raisonsartistiques False \n", "D_18_06_Annexed1_Proprieteintellectuelle False \n", "D_18_07_Annexed1_Urgenceimperieuse False \n", "D_18_08_Annexed1_Marchecomplementaire None \n", "D_18_09_Annexed1_Prestationsidentiques False \n", "D_18_10_Annexed1_Laureatsconcours False \n", "D_18_11_Annexed1_Matierespremieres None \n", "D_18_12_Annexed1_Cessationactivite None \n", "D_18_13_Annexed1_Liquidateurs None \n", "D_18_14_Annexed1_Horsscope False \n", "D_18_15_Annexed1_Explication Aucune offre n'a été déposée lors de l'appel d'offres initial " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "extrait_df_d_18_annexed1.head(3).T" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**
Remonter**" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
\n", "\n", "## Vue horizontale de la table " ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
D_18_01_Annexed1_InfructueuxouverteD_18_02_Annexed1_InfructueuxrestreinteD_18_03_Annexed1_RechercheD_18_04_Annexed1_RaisonstechniquesD_18_05_Annexed1_RaisonsartistiquesD_18_06_Annexed1_ProprieteintellectuelleD_18_07_Annexed1_UrgenceimperieuseD_18_08_Annexed1_MarchecomplementaireD_18_09_Annexed1_PrestationsidentiquesD_18_10_Annexed1_LaureatsconcoursD_18_11_Annexed1_MatierespremieresD_18_12_Annexed1_CessationactiviteD_18_13_Annexed1_LiquidateursD_18_14_Annexed1_HorsscopeD_18_15_Annexed1_Explication
BOAMP_AVIS_NUM
21-14053FalseFalseFalseFalseFalseFalseFalseNoneFalseFalseNoneNoneNoneTrueLa valeur totale du marché (175 136 euro(s) Ht) est inférieure aux seuils européens imposant une publication au Joue
21-14172FalseFalseFalseFalseFalseFalseFalseNoneFalseFalseNoneNoneNoneTrueLes marchés subséquents découlent de l'accord-cadre dont l'avis de publicité à été transmis le 21 octobre 2021 sur la plateforme Aws
21-14613TrueFalseFalseFalseFalseFalseFalseNoneFalseFalseNoneNoneNoneFalseAucune offre n'a été déposée lors de l'appel d'offres initial
\n", "
" ], "text/plain": [ " D_18_01_Annexed1_Infructueuxouverte \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 True \n", "\n", " D_18_02_Annexed1_Infructueuxrestreinte \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_03_Annexed1_Recherche \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_04_Annexed1_Raisonstechniques \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_05_Annexed1_Raisonsartistiques \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_06_Annexed1_Proprieteintellectuelle \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_07_Annexed1_Urgenceimperieuse \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_08_Annexed1_Marchecomplementaire \\\n", "BOAMP_AVIS_NUM \n", "21-14053 None \n", "21-14172 None \n", "21-14613 None \n", "\n", " D_18_09_Annexed1_Prestationsidentiques \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_10_Annexed1_Laureatsconcours \\\n", "BOAMP_AVIS_NUM \n", "21-14053 False \n", "21-14172 False \n", "21-14613 False \n", "\n", " D_18_11_Annexed1_Matierespremieres \\\n", "BOAMP_AVIS_NUM \n", "21-14053 None \n", "21-14172 None \n", "21-14613 None \n", "\n", " D_18_12_Annexed1_Cessationactivite \\\n", "BOAMP_AVIS_NUM \n", "21-14053 None \n", "21-14172 None \n", "21-14613 None \n", "\n", " D_18_13_Annexed1_Liquidateurs D_18_14_Annexed1_Horsscope \\\n", "BOAMP_AVIS_NUM \n", "21-14053 None True \n", "21-14172 None True \n", "21-14613 None False \n", "\n", " D_18_15_Annexed1_Explication \n", "BOAMP_AVIS_NUM \n", "21-14053 La valeur totale du marché (175 136 euro(s) Ht) est inférieure aux seuils européens imposant une publication au Joue \n", "21-14172 Les marchés subséquents découlent de l'accord-cadre dont l'avis de publicité à été transmis le 21 octobre 2021 sur la plateforme Aws \n", "21-14613 Aucune offre n'a été déposée lors de l'appel d'offres initial " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "extrait_df_d_18_annexed1.head(3)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**
Remonter**" ] } ], "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.8.6" }, "widgets": { "application/vnd.jupyter.widget-state+json": { "state": { "2725701350bb428c9ada6196f8fdec6b": { "model_module": "@jupyter-widgets/base", "model_module_version": "1.2.0", "model_name": "LayoutModel", "state": { "border": "3px solid #cccccc", "margin": "20px 100px 20px 100px", "max_width": "80%", "padding": "10px" } }, "5c79d3680c9a4552bd382b9a7127af8a": { "model_module": "@jupyter-widgets/output", "model_module_version": "1.0.0", "model_name": "OutputModel", "state": { "layout": "IPY_MODEL_2725701350bb428c9ada6196f8fdec6b", "outputs": [ { "data": { "text/html": "\n \n ", "text/plain": "" }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": "

Cliquez sur les cercles contenus dans la figure pour ouvrir et refermer les niveaux.
\n L'image est zommable.

\n
--> Ouvrir ce schéma en plein écran dans un nouvel onglet.
\n Cliquez sur « Trust HTML » si le schéma n'apparaît pas de lui-même à l'ouverture du lien.

\n ", "text/plain": "" }, "metadata": {}, "output_type": "display_data" } ] } } }, "version_major": 2, "version_minor": 0 } } }, "nbformat": 4, "nbformat_minor": 4 }