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_11_Conditiondelai


In [2]:
extrait_df_d_11_conditiondelai = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_11_conditiondelai.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_11_conditiondelai.html");
In [4]:
extrait_df_d_11_conditiondelai.info()
<class 'pandas.core.frame.DataFrame'>
Index: 7445 entries, 20-107212 to 21-9966
Data columns (total 8 columns):
 #   Column                                             Non-Null Count  Dtype         
---  ------                                             --------------  -----         
 0   D_11_01_Conditiondelai_Receptcandidat              108 non-null    datetime64[ns]
 1   D_11_02_Conditiondelai_Receptoffres                7358 non-null   datetime64[ns]
 2   D_11_03_Conditiondelai_Limiteenvoiinvit            97 non-null     datetime64[ns]
 3   D_11_04_Conditiondelai_Validiteoffre               7445 non-null   object        
 4   D_11_04_01_Conditiondelai_Validiteoffre_Jusquau    0 non-null      float64       
 5   D_11_04_02_Conditiondelai_Validiteoffre_Dureemois  3335 non-null   float64       
 6   D_11_04_03_Conditiondelai_Validiteoffre_Dureejour  2362 non-null   Int16         
 7   D_11_05_Conditiondelai_Dureesystemequalification   0 non-null      object        
dtypes: Int16(1), datetime64[ns](3), float64(2), object(2)
memory usage: 487.1+ KB
In [5]:
extrait_df_d_11_conditiondelai.head(3).T
Out[5]:
BOAMP_AVIS_NUM 20-107212 20-114622 20-117134
D_11_01_Conditiondelai_Receptcandidat NaT NaT NaT
D_11_02_Conditiondelai_Receptoffres 2021-03-08 16:00:00 2021-03-04 11:00:00 2021-03-11 11:00:00
D_11_03_Conditiondelai_Limiteenvoiinvit NaT NaT NaT
D_11_04_Conditiondelai_Validiteoffre CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_11_04_01_Conditiondelai_Validiteoffre_Jusquau NaN NaN NaN
D_11_04_02_Conditiondelai_Validiteoffre_Dureemois NaN 4.0 6.0
D_11_04_03_Conditiondelai_Validiteoffre_Dureejour 240 <NA> <NA>
D_11_05_Conditiondelai_Dureesystemequalification None None None
In [6]:
extrait_df_d_11_conditiondelai.head(3)
Out[6]:
D_11_01_Conditiondelai_Receptcandidat D_11_02_Conditiondelai_Receptoffres D_11_03_Conditiondelai_Limiteenvoiinvit D_11_04_Conditiondelai_Validiteoffre D_11_04_01_Conditiondelai_Validiteoffre_Jusquau D_11_04_02_Conditiondelai_Validiteoffre_Dureemois D_11_04_03_Conditiondelai_Validiteoffre_Dureejour D_11_05_Conditiondelai_Dureesystemequalification
BOAMP_AVIS_NUM
20-107212 NaT 2021-03-08 16:00:00 NaT CF_NIV_SUIV NaN NaN 240 None
20-114622 NaT 2021-03-04 11:00:00 NaT CF_NIV_SUIV NaN 4.0 <NA> None
20-117134 NaT 2021-03-11 11:00:00 NaT CF_NIV_SUIV NaN 6.0 <NA> None