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

Un tour d'horizon des Tables du BOAMP

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


Table D_07_Publicationanterieure


In [2]:
extrait_df_d_07_publicationanterieure = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_07_publicationanterieure.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_d_07_publicationanterieure.html");
In [4]:
extrait_df_d_07_publicationanterieure.info()
<class 'pandas.core.frame.DataFrame'>
Index: 2194 entries, 19-138840 to 21-9868
Data columns (total 21 columns):
 #   Column                                                                                                           Non-Null Count  Dtype         
---  ------                                                                                                           --------------  -----         
 0   D_07_01_Publicationanterieure_Oui                                                                                2194 non-null   bool          
 1   D_07_02_Publicationanterieure_Referencepublication                                                               2194 non-null   object        
 2   D_07_02_01_Publicationanterieure_Referencepublication_Publicationpapier                                          2167 non-null   object        
 3   D_07_02_02_Publicationanterieure_Referencepublication_Publicationelectronique                                    0 non-null      object        
 4   D_07_02_03_Publicationanterieure_Referencepublication_Publicationjoue                                            2194 non-null   object        
 5   D_07_02_03_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature                                  2194 non-null   object        
 6   D_07_02_03_01_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avispreinformation            2194 non-null   bool          
 7   D_07_02_03_01_02_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisperiodique                2194 non-null   bool          
 8   D_07_02_03_01_03_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissystemqualif              0 non-null      object        
 9   D_07_02_03_01_04_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisprofilacheteur            2194 non-null   bool          
 10  D_07_02_03_01_05_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisexantevolontaire          2194 non-null   bool          
 11  D_07_02_03_01_06_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avismarche                    2194 non-null   bool          
 12  D_07_02_03_01_07_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissad                       0 non-null      object        
 13  D_07_02_03_01_08_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisconcours                  0 non-null      object        
 14  D_07_02_03_01_09_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisattribution               2194 non-null   bool          
 15  D_07_02_03_01_10_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Autrespublcationsanterieures  2194 non-null   bool          
 16  D_07_02_03_02_Publicationanterieure_Referencepublication_Publicationjoue_Annee                                   2194 non-null   object        
 17  D_07_02_03_03_Publicationanterieure_Referencepublication_Publicationjoue_Numparution                             2194 non-null   object        
 18  D_07_02_03_04_Publicationanterieure_Referencepublication_Publicationjoue_Numannonce                              2194 non-null   object        
 19  D_07_02_03_05_Publicationanterieure_Referencepublication_Publicationjoue_Datepublication                         2100 non-null   datetime64[ns]
 20  D_07_03_Publicationanterieure_Non                                                                                2194 non-null   bool          
dtypes: bool(9), datetime64[ns](1), object(11)
memory usage: 242.1+ KB
In [5]:
extrait_df_d_07_publicationanterieure.head(3).T
Out[5]:
BOAMP_AVIS_NUM 19-138840 20-105937 20-117935
D_07_01_Publicationanterieure_Oui True True True
D_07_02_Publicationanterieure_Referencepublication CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_07_02_01_Publicationanterieure_Referencepublication_Publicationpapier [] [] []
D_07_02_02_Publicationanterieure_Referencepublication_Publicationelectronique None None None
D_07_02_03_Publicationanterieure_Referencepublication_Publicationjoue CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_07_02_03_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_07_02_03_01_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avispreinformation False False False
D_07_02_03_01_02_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisperiodique False False False
D_07_02_03_01_03_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissystemqualif None None None
D_07_02_03_01_04_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisprofilacheteur False False True
D_07_02_03_01_05_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisexantevolontaire False False False
D_07_02_03_01_06_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avismarche True True False
D_07_02_03_01_07_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissad None None None
D_07_02_03_01_08_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisconcours None None None
D_07_02_03_01_09_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisattribution False False False
D_07_02_03_01_10_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Autrespublcationsanterieures False False False
D_07_02_03_02_Publicationanterieure_Referencepublication_Publicationjoue_Annee 2019 2020 2019
D_07_02_03_03_Publicationanterieure_Referencepublication_Publicationjoue_Numparution 173 89 145
D_07_02_03_04_Publicationanterieure_Referencepublication_Publicationjoue_Numannonce 422306 212697 358573
D_07_02_03_05_Publicationanterieure_Referencepublication_Publicationjoue_Datepublication 2019-09-08 22:00:00 2020-05-06 22:00:00 2019-07-29 22:00:00
D_07_03_Publicationanterieure_Non False False False
In [6]:
extrait_df_d_07_publicationanterieure.head(3)
Out[6]:
D_07_01_Publicationanterieure_Oui D_07_02_Publicationanterieure_Referencepublication D_07_02_01_Publicationanterieure_Referencepublication_Publicationpapier D_07_02_02_Publicationanterieure_Referencepublication_Publicationelectronique D_07_02_03_Publicationanterieure_Referencepublication_Publicationjoue D_07_02_03_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature D_07_02_03_01_01_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avispreinformation D_07_02_03_01_02_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisperiodique D_07_02_03_01_03_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissystemqualif D_07_02_03_01_04_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisprofilacheteur D_07_02_03_01_05_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisexantevolontaire D_07_02_03_01_06_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avismarche D_07_02_03_01_07_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avissad D_07_02_03_01_08_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisconcours D_07_02_03_01_09_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Avisattribution D_07_02_03_01_10_Publicationanterieure_Referencepublication_Publicationjoue_Nature_Autrespublcationsanterieures D_07_02_03_02_Publicationanterieure_Referencepublication_Publicationjoue_Annee D_07_02_03_03_Publicationanterieure_Referencepublication_Publicationjoue_Numparution D_07_02_03_04_Publicationanterieure_Referencepublication_Publicationjoue_Numannonce D_07_02_03_05_Publicationanterieure_Referencepublication_Publicationjoue_Datepublication D_07_03_Publicationanterieure_Non
BOAMP_AVIS_NUM
19-138840 True CF_NIV_SUIV [] None CF_NIV_SUIV CF_NIV_SUIV False False None False False True None None False False 2019 173 422306 2019-09-08 22:00:00 False
20-105937 True CF_NIV_SUIV [] None CF_NIV_SUIV CF_NIV_SUIV False False None False False True None None False False 2020 89 212697 2020-05-06 22:00:00 False
20-117935 True CF_NIV_SUIV [] None CF_NIV_SUIV CF_NIV_SUIV False False None True False False None None False False 2019 145 358573 2019-07-29 22:00:00 False