In [1]:
%run afdb_lab_scripts/afdb_lab_prereglages
%run afdb_lab_scripts/afdb_lab_haut

À base des données recueillies en OpenData via l'API consacrée --> https://www.data.gouv.fr/fr/datasets/api-boamp-beta/


Table G_01_Reference

Tour d'horizon


In [2]:
extrait_df_g_01_reference = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_G_01_reference.pkl')

Schéma interactif de la table

In [3]:
from afdb_lab_scripts.afficher_plan_html import afficher_plan_html
afficher_plan_html(source="boamp_plans_html/boamp_plan_g_01_reference.html");
In [4]:
extrait_df_g_01_reference.info()
<class 'pandas.core.frame.DataFrame'>
Index: 11513 entries, 18-111639 to 21-9966
Data columns (total 58 columns):
 #   Column                                                                               Non-Null Count  Dtype 
---  ------                                                                               --------------  ----- 
 0   G_01_01_Reference_Idweb                                                              11513 non-null  object
 1   G_01_02_Reference_Typeavis                                                           11513 non-null  object
 2   G_01_02_01_Reference_Typeavis_Famille                                                11513 non-null  object
 3   G_01_02_01_01_Reference_Typeavis_Famille_Mapa                                        11513 non-null  bool  
 4   G_01_02_01_02_Reference_Typeavis_Famille_Fns                                         11513 non-null  bool  
 5   G_01_02_01_03_Reference_Typeavis_Famille_Joue                                        11513 non-null  bool  
 6   G_01_02_01_04_Reference_Typeavis_Famille_Dsp                                         11513 non-null  bool  
 7   G_01_02_01_05_Reference_Typeavis_Famille_Divers                                      11513 non-null  bool  
 8   G_01_02_02_Reference_Typeavis_Perimetre                                              11513 non-null  object
 9   G_01_02_02_01_Reference_Typeavis_Perimetre_Cmp2006                                   11513 non-null  bool  
 10  G_01_02_02_02_Reference_Typeavis_Perimetre_Cmp2006DEFENSE                            11513 non-null  bool  
 11  G_01_02_02_03_Reference_Typeavis_Perimetre_Directive18                               11513 non-null  bool  
 12  G_01_02_02_04_Reference_Typeavis_Perimetre_Directive17                               11513 non-null  bool  
 13  G_01_02_02_05_Reference_Typeavis_Perimetre_Directive81                               11513 non-null  bool  
 14  G_01_02_02_06_Reference_Typeavis_Perimetre_Directive23                               11513 non-null  bool  
 15  G_01_02_02_07_Reference_Typeavis_Perimetre_Directive24                               11513 non-null  bool  
 16  G_01_02_02_08_Reference_Typeavis_Perimetre_Directive25                               11513 non-null  bool  
 17  G_01_02_02_09_Reference_Typeavis_Perimetre_Dsp                                       11513 non-null  bool  
 18  G_01_02_02_10_Reference_Typeavis_Perimetre_Autre                                     11513 non-null  object
 19  G_01_02_03_Reference_Typeavis_Nature                                                 11513 non-null  object
 20  G_01_02_03_01_Reference_Typeavis_Nature_Preinformation                               11513 non-null  object
 21  G_01_02_03_01_01_Reference_Typeavis_Nature_Preinformation_Standard                   11513 non-null  bool  
 22  G_01_02_03_01_02_Reference_Typeavis_Nature_Preinformation_Periodique                 0 non-null      object
 23  G_01_02_03_01_03_Reference_Typeavis_Nature_Preinformation_Qualification              0 non-null      object
 24  G_01_02_03_01_04_Reference_Typeavis_Nature_Preinformation_Concession                 11513 non-null  bool  
 25  G_01_02_03_01_05_Reference_Typeavis_Nature_Preinformation_Reductiondelai             11513 non-null  bool  
 26  G_01_02_03_01_06_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence          11513 non-null  bool  
 27  G_01_02_03_01_07_Reference_Typeavis_Nature_Preinformation_Profilacheteur             0 non-null      object
 28  G_01_02_03_02_Reference_Typeavis_Nature_Profilacheteur                               0 non-null      object
 29  G_01_02_03_03_Reference_Typeavis_Nature_Appeloffre                                   11513 non-null  object
 30  G_01_02_03_03_01_Reference_Typeavis_Nature_Appeloffre_Standard                       11513 non-null  bool  
 31  G_01_02_03_03_02_Reference_Typeavis_Nature_Appeloffre_Concours                       11513 non-null  bool  
 32  G_01_02_03_03_03_Reference_Typeavis_Nature_Appeloffre_Periodique                     0 non-null      object
 33  G_01_02_03_03_04_Reference_Typeavis_Nature_Appeloffre_Qualification                  0 non-null      object
 34  G_01_02_03_03_05_Reference_Typeavis_Nature_Appeloffre_Sad                            0 non-null      object
 35  G_01_02_03_03_06_Reference_Typeavis_Nature_Appeloffre_Concession                     11513 non-null  bool  
 36  G_01_02_03_03_07_Reference_Typeavis_Nature_Appeloffre_Concessionnaire                0 non-null      object
 37  G_01_02_03_04_Reference_Typeavis_Nature_Intentionconclure                            11513 non-null  bool  
 38  G_01_02_03_05_Reference_Typeavis_Nature_Attribution                                  11513 non-null  object
 39  G_01_02_03_05_01_Reference_Typeavis_Nature_Attribution_Standard                      11513 non-null  bool  
 40  G_01_02_03_05_02_Reference_Typeavis_Nature_Attribution_Concours                      11513 non-null  bool  
 41  G_01_02_03_05_03_Reference_Typeavis_Nature_Attribution_Concession                    11513 non-null  bool  
 42  G_01_02_03_05_04_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite  0 non-null      object
 43  G_01_02_03_06_Reference_Typeavis_Nature_Soustraitance                                0 non-null      object
 44  G_01_02_03_07_Reference_Typeavis_Nature_Modification                                 11513 non-null  bool  
 45  G_01_02_03_08_Reference_Typeavis_Nature_Qualification                                0 non-null      object
 46  G_01_02_03_09_Reference_Typeavis_Nature_Rectificatif                                 11513 non-null  bool  
 47  G_01_02_03_10_Reference_Typeavis_Nature_Periodique                                   11513 non-null  object
 48  G_01_02_03_10_01_Reference_Typeavis_Nature_Periodique_Standard                       11513 non-null  bool  
 49  G_01_02_03_10_02_Reference_Typeavis_Nature_Periodique_Reductiondelai                 0 non-null      object
 50  G_01_02_03_10_03_Reference_Typeavis_Nature_Periodique_Miseenconcurrence              11513 non-null  bool  
 51  G_01_02_03_10_04_Reference_Typeavis_Nature_Periodique_Profilacheteur                 0 non-null      object
 52  G_01_02_03_11_Reference_Typeavis_Nature_Autre                                        0 non-null      object
 53  G_01_02_04_Reference_Typeavis_Statut                                                 11513 non-null  object
 54  G_01_02_04_01_Reference_Typeavis_Statut_Initial                                      11513 non-null  bool  
 55  G_01_02_04_02_Reference_Typeavis_Statut_Rectificatif                                 11513 non-null  bool  
 56  G_01_02_04_03_Reference_Typeavis_Statut_Annulation                                   11513 non-null  bool  
 57  G_01_02_04_04_Reference_Typeavis_Statut_Modification                                 11513 non-null  bool  
dtypes: bool(33), object(25)
memory usage: 2.6+ MB
In [5]:
extrait_df_g_01_reference.head(3).T
Out[5]:
BOAMP_AVIS_NUM 18-111639 19-138840 20-105937
G_01_01_Reference_Idweb 18-111639 19-138840 20-105937
G_01_02_Reference_Typeavis CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_01_Reference_Typeavis_Famille CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_01_01_Reference_Typeavis_Famille_Mapa False False False
G_01_02_01_02_Reference_Typeavis_Famille_Fns False False False
G_01_02_01_03_Reference_Typeavis_Famille_Joue True True True
G_01_02_01_04_Reference_Typeavis_Famille_Dsp False False False
G_01_02_01_05_Reference_Typeavis_Famille_Divers False False False
G_01_02_02_Reference_Typeavis_Perimetre CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_02_01_Reference_Typeavis_Perimetre_Cmp2006 False False False
G_01_02_02_02_Reference_Typeavis_Perimetre_Cmp2006DEFENSE False False False
G_01_02_02_03_Reference_Typeavis_Perimetre_Directive18 False False False
G_01_02_02_04_Reference_Typeavis_Perimetre_Directive17 False False False
G_01_02_02_05_Reference_Typeavis_Perimetre_Directive81 False False False
G_01_02_02_06_Reference_Typeavis_Perimetre_Directive23 True False False
G_01_02_02_07_Reference_Typeavis_Perimetre_Directive24 False True True
G_01_02_02_08_Reference_Typeavis_Perimetre_Directive25 False False False
G_01_02_02_09_Reference_Typeavis_Perimetre_Dsp False False False
G_01_02_02_10_Reference_Typeavis_Perimetre_Autre None None None
G_01_02_03_Reference_Typeavis_Nature CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_03_01_Reference_Typeavis_Nature_Preinformation CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_03_01_01_Reference_Typeavis_Nature_Preinformation_Standard False False False
G_01_02_03_01_02_Reference_Typeavis_Nature_Preinformation_Periodique None None None
G_01_02_03_01_03_Reference_Typeavis_Nature_Preinformation_Qualification None None None
G_01_02_03_01_04_Reference_Typeavis_Nature_Preinformation_Concession False False False
G_01_02_03_01_05_Reference_Typeavis_Nature_Preinformation_Reductiondelai False False False
G_01_02_03_01_06_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence False False False
G_01_02_03_01_07_Reference_Typeavis_Nature_Preinformation_Profilacheteur None None None
G_01_02_03_02_Reference_Typeavis_Nature_Profilacheteur None None None
G_01_02_03_03_Reference_Typeavis_Nature_Appeloffre CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_03_03_01_Reference_Typeavis_Nature_Appeloffre_Standard False False False
G_01_02_03_03_02_Reference_Typeavis_Nature_Appeloffre_Concours False False False
G_01_02_03_03_03_Reference_Typeavis_Nature_Appeloffre_Periodique None None None
G_01_02_03_03_04_Reference_Typeavis_Nature_Appeloffre_Qualification None None None
G_01_02_03_03_05_Reference_Typeavis_Nature_Appeloffre_Sad None None None
G_01_02_03_03_06_Reference_Typeavis_Nature_Appeloffre_Concession False False False
G_01_02_03_03_07_Reference_Typeavis_Nature_Appeloffre_Concessionnaire None None None
G_01_02_03_04_Reference_Typeavis_Nature_Intentionconclure False False False
G_01_02_03_05_Reference_Typeavis_Nature_Attribution CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_03_05_01_Reference_Typeavis_Nature_Attribution_Standard False True True
G_01_02_03_05_02_Reference_Typeavis_Nature_Attribution_Concours False False False
G_01_02_03_05_03_Reference_Typeavis_Nature_Attribution_Concession True False False
G_01_02_03_05_04_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite None None None
G_01_02_03_06_Reference_Typeavis_Nature_Soustraitance None None None
G_01_02_03_07_Reference_Typeavis_Nature_Modification False False False
G_01_02_03_08_Reference_Typeavis_Nature_Qualification None None None
G_01_02_03_09_Reference_Typeavis_Nature_Rectificatif False False False
G_01_02_03_10_Reference_Typeavis_Nature_Periodique CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_03_10_01_Reference_Typeavis_Nature_Periodique_Standard False False False
G_01_02_03_10_02_Reference_Typeavis_Nature_Periodique_Reductiondelai None None None
G_01_02_03_10_03_Reference_Typeavis_Nature_Periodique_Miseenconcurrence False False False
G_01_02_03_10_04_Reference_Typeavis_Nature_Periodique_Profilacheteur None None None
G_01_02_03_11_Reference_Typeavis_Nature_Autre None None None
G_01_02_04_Reference_Typeavis_Statut CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
G_01_02_04_01_Reference_Typeavis_Statut_Initial True True True
G_01_02_04_02_Reference_Typeavis_Statut_Rectificatif False False False
G_01_02_04_03_Reference_Typeavis_Statut_Annulation False False False
G_01_02_04_04_Reference_Typeavis_Statut_Modification False False False
In [6]:
extrait_df_g_01_reference.head(3)
Out[6]:
G_01_01_Reference_Idweb G_01_02_Reference_Typeavis G_01_02_01_Reference_Typeavis_Famille G_01_02_01_01_Reference_Typeavis_Famille_Mapa G_01_02_01_02_Reference_Typeavis_Famille_Fns G_01_02_01_03_Reference_Typeavis_Famille_Joue G_01_02_01_04_Reference_Typeavis_Famille_Dsp G_01_02_01_05_Reference_Typeavis_Famille_Divers G_01_02_02_Reference_Typeavis_Perimetre G_01_02_02_01_Reference_Typeavis_Perimetre_Cmp2006 G_01_02_02_02_Reference_Typeavis_Perimetre_Cmp2006DEFENSE G_01_02_02_03_Reference_Typeavis_Perimetre_Directive18 G_01_02_02_04_Reference_Typeavis_Perimetre_Directive17 G_01_02_02_05_Reference_Typeavis_Perimetre_Directive81 G_01_02_02_06_Reference_Typeavis_Perimetre_Directive23 G_01_02_02_07_Reference_Typeavis_Perimetre_Directive24 G_01_02_02_08_Reference_Typeavis_Perimetre_Directive25 G_01_02_02_09_Reference_Typeavis_Perimetre_Dsp G_01_02_02_10_Reference_Typeavis_Perimetre_Autre G_01_02_03_Reference_Typeavis_Nature G_01_02_03_01_Reference_Typeavis_Nature_Preinformation G_01_02_03_01_01_Reference_Typeavis_Nature_Preinformation_Standard G_01_02_03_01_02_Reference_Typeavis_Nature_Preinformation_Periodique G_01_02_03_01_03_Reference_Typeavis_Nature_Preinformation_Qualification G_01_02_03_01_04_Reference_Typeavis_Nature_Preinformation_Concession G_01_02_03_01_05_Reference_Typeavis_Nature_Preinformation_Reductiondelai G_01_02_03_01_06_Reference_Typeavis_Nature_Preinformation_Miseenconcurrence G_01_02_03_01_07_Reference_Typeavis_Nature_Preinformation_Profilacheteur G_01_02_03_02_Reference_Typeavis_Nature_Profilacheteur G_01_02_03_03_Reference_Typeavis_Nature_Appeloffre G_01_02_03_03_01_Reference_Typeavis_Nature_Appeloffre_Standard G_01_02_03_03_02_Reference_Typeavis_Nature_Appeloffre_Concours G_01_02_03_03_03_Reference_Typeavis_Nature_Appeloffre_Periodique G_01_02_03_03_04_Reference_Typeavis_Nature_Appeloffre_Qualification G_01_02_03_03_05_Reference_Typeavis_Nature_Appeloffre_Sad G_01_02_03_03_06_Reference_Typeavis_Nature_Appeloffre_Concession G_01_02_03_03_07_Reference_Typeavis_Nature_Appeloffre_Concessionnaire G_01_02_03_04_Reference_Typeavis_Nature_Intentionconclure G_01_02_03_05_Reference_Typeavis_Nature_Attribution G_01_02_03_05_01_Reference_Typeavis_Nature_Attribution_Standard G_01_02_03_05_02_Reference_Typeavis_Nature_Attribution_Concours G_01_02_03_05_03_Reference_Typeavis_Nature_Attribution_Concession G_01_02_03_05_04_Reference_Typeavis_Nature_Attribution_Standardinfructueuxsanssuite G_01_02_03_06_Reference_Typeavis_Nature_Soustraitance G_01_02_03_07_Reference_Typeavis_Nature_Modification G_01_02_03_08_Reference_Typeavis_Nature_Qualification G_01_02_03_09_Reference_Typeavis_Nature_Rectificatif G_01_02_03_10_Reference_Typeavis_Nature_Periodique G_01_02_03_10_01_Reference_Typeavis_Nature_Periodique_Standard G_01_02_03_10_02_Reference_Typeavis_Nature_Periodique_Reductiondelai G_01_02_03_10_03_Reference_Typeavis_Nature_Periodique_Miseenconcurrence G_01_02_03_10_04_Reference_Typeavis_Nature_Periodique_Profilacheteur G_01_02_03_11_Reference_Typeavis_Nature_Autre G_01_02_04_Reference_Typeavis_Statut G_01_02_04_01_Reference_Typeavis_Statut_Initial G_01_02_04_02_Reference_Typeavis_Statut_Rectificatif G_01_02_04_03_Reference_Typeavis_Statut_Annulation G_01_02_04_04_Reference_Typeavis_Statut_Modification
BOAMP_AVIS_NUM
18-111639 18-111639 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False True False False False None CF_NIV_SUIV CF_NIV_SUIV False None None False False False None None CF_NIV_SUIV False False None None None False None False CF_NIV_SUIV False False True None None False None False CF_NIV_SUIV False None False None None CF_NIV_SUIV True False False False
19-138840 19-138840 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False False True False False None CF_NIV_SUIV CF_NIV_SUIV False None None False False False None None CF_NIV_SUIV False False None None None False None False CF_NIV_SUIV True False False None None False None False CF_NIV_SUIV False None False None None CF_NIV_SUIV True False False False
20-105937 20-105937 CF_NIV_SUIV CF_NIV_SUIV False False True False False CF_NIV_SUIV False False False False False False True False False None CF_NIV_SUIV CF_NIV_SUIV False None None False False False None None CF_NIV_SUIV False False None None None False None False CF_NIV_SUIV True False False None None False None False CF_NIV_SUIV False None False None None CF_NIV_SUIV True False False False