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_15_Conditionadministrative


In [2]:
extrait_df_d_15_conditionadministrative = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_15_conditionadministrative.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_15_conditionadministrative.html");
In [4]:
extrait_df_d_15_conditionadministrative.info()
<class 'pandas.core.frame.DataFrame'>
Index: 9119 entries, 19-138840 to 21-9966
Data columns (total 25 columns):
 #   Column                                                                    Non-Null Count  Dtype         
---  ------                                                                    --------------  -----         
 0   D_15_01_Conditionadministrative_Referencemarche                           3461 non-null   object        
 1   D_15_02_Conditionadministrative_Etudesconcours                            7 non-null      object        
 2   D_15_03_Conditionadministrative_Recompenseslaureatoui                     9119 non-null   bool          
 3   D_15_04_Conditionadministrative_Recompensesaureatnon                      9119 non-null   bool          
 4   D_15_05_Conditionadministrative_Recompenseslaureat                        81 non-null     object        
 5   D_15_06_Conditionadministrative_Indemnisationparticipants                 34 non-null     object        
 6   D_15_07_Conditionadministrative_Conditionsremiseoffres                    800 non-null    object        
 7   D_15_08_Conditionadministrative_Conditionsetmodepaiementobtenirdocuments  412 non-null    object        
 8   D_15_09_Conditionadministrative_Datelimiteobtentiondocuments              241 non-null    datetime64[ns]
 9   D_15_10_Conditionadministrative_Documentpayantoui                         9119 non-null   object        
 10  D_15_10_01_Conditionadministrative_Documentpayantoui_Valeur               9119 non-null   object        
 11  D_15_10_01_01_Conditionadministrative_Documentpayantoui_Valeur_Value      1 non-null      float64       
 12  D_15_10_01_02_Conditionadministrative_Documentpayantoui_Valeur_Devise     1 non-null      object        
 13  D_15_11_Conditionadministrative_Documentpayantnon                         9119 non-null   bool          
 14  D_15_12_Conditionadministrative_Persouvertureoffresoui                    259 non-null    object        
 15  D_15_13_Conditionadministrative_Persouvertureoffresnon                    9119 non-null   bool          
 16  D_15_14_Conditionadministrative_Datedebutattribution                      0 non-null      object        
 17  D_15_15_Conditionadministrative_Dateouvertureoffres                       2816 non-null   datetime64[ns]
 18  D_15_16_Conditionadministrative_Lieuouvertureoffres                       673 non-null    object        
 19  D_15_17_Conditionadministrative_Abandonsadoui                             0 non-null      object        
 20  D_15_18_Conditionadministrative_Abandonsadnon                             9119 non-null   bool          
 21  D_15_19_Conditionadministrative_Finattributionoui                         9119 non-null   bool          
 22  D_15_20_Conditionadministrative_Finattributionnon                         9119 non-null   bool          
 23  D_15_21_Conditionadministrative_Envoielectroniqueavecoutiloui             9119 non-null   bool          
 24  D_15_22_Conditionadministrative_Envoielectroniqueavecoutilnon             9119 non-null   bool          
dtypes: bool(9), datetime64[ns](2), float64(1), object(13)
memory usage: 1.3+ MB
In [5]:
extrait_df_d_15_conditionadministrative.head(3).T
Out[5]:
BOAMP_AVIS_NUM 19-138840 20-105937 20-107212
D_15_01_Conditionadministrative_Referencemarche None None DMORN-2020-21
D_15_02_Conditionadministrative_Etudesconcours None None None
D_15_03_Conditionadministrative_Recompenseslaureatoui False False False
D_15_04_Conditionadministrative_Recompensesaureatnon False False False
D_15_05_Conditionadministrative_Recompenseslaureat None None None
D_15_06_Conditionadministrative_Indemnisationparticipants None None None
D_15_07_Conditionadministrative_Conditionsremiseoffres None None None
D_15_08_Conditionadministrative_Conditionsetmodepaiementobtenirdocuments None None None
D_15_09_Conditionadministrative_Datelimiteobtentiondocuments NaT NaT NaT
D_15_10_Conditionadministrative_Documentpayantoui CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_15_10_01_Conditionadministrative_Documentpayantoui_Valeur CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_15_10_01_01_Conditionadministrative_Documentpayantoui_Valeur_Value NaN NaN NaN
D_15_10_01_02_Conditionadministrative_Documentpayantoui_Valeur_Devise None None None
D_15_11_Conditionadministrative_Documentpayantnon False False False
D_15_12_Conditionadministrative_Persouvertureoffresoui None None None
D_15_13_Conditionadministrative_Persouvertureoffresnon False False False
D_15_14_Conditionadministrative_Datedebutattribution None None None
D_15_15_Conditionadministrative_Dateouvertureoffres NaT NaT NaT
D_15_16_Conditionadministrative_Lieuouvertureoffres None None None
D_15_17_Conditionadministrative_Abandonsadoui None None None
D_15_18_Conditionadministrative_Abandonsadnon True True False
D_15_19_Conditionadministrative_Finattributionoui False False False
D_15_20_Conditionadministrative_Finattributionnon True True False
D_15_21_Conditionadministrative_Envoielectroniqueavecoutiloui False False False
D_15_22_Conditionadministrative_Envoielectroniqueavecoutilnon False False False
In [6]:
extrait_df_d_15_conditionadministrative.head(3)
Out[6]:
D_15_01_Conditionadministrative_Referencemarche D_15_02_Conditionadministrative_Etudesconcours D_15_03_Conditionadministrative_Recompenseslaureatoui D_15_04_Conditionadministrative_Recompensesaureatnon D_15_05_Conditionadministrative_Recompenseslaureat D_15_06_Conditionadministrative_Indemnisationparticipants D_15_07_Conditionadministrative_Conditionsremiseoffres D_15_08_Conditionadministrative_Conditionsetmodepaiementobtenirdocuments D_15_09_Conditionadministrative_Datelimiteobtentiondocuments D_15_10_Conditionadministrative_Documentpayantoui D_15_10_01_Conditionadministrative_Documentpayantoui_Valeur D_15_10_01_01_Conditionadministrative_Documentpayantoui_Valeur_Value D_15_10_01_02_Conditionadministrative_Documentpayantoui_Valeur_Devise D_15_11_Conditionadministrative_Documentpayantnon D_15_12_Conditionadministrative_Persouvertureoffresoui D_15_13_Conditionadministrative_Persouvertureoffresnon D_15_14_Conditionadministrative_Datedebutattribution D_15_15_Conditionadministrative_Dateouvertureoffres D_15_16_Conditionadministrative_Lieuouvertureoffres D_15_17_Conditionadministrative_Abandonsadoui D_15_18_Conditionadministrative_Abandonsadnon D_15_19_Conditionadministrative_Finattributionoui D_15_20_Conditionadministrative_Finattributionnon D_15_21_Conditionadministrative_Envoielectroniqueavecoutiloui D_15_22_Conditionadministrative_Envoielectroniqueavecoutilnon
BOAMP_AVIS_NUM
19-138840 None None False False None None None None NaT CF_NIV_SUIV CF_NIV_SUIV NaN None False None False None NaT None None True False True False False
20-105937 None None False False None None None None NaT CF_NIV_SUIV CF_NIV_SUIV NaN None False None False None NaT None None True False True False False
20-107212 DMORN-2020-21 None False False None None None None NaT CF_NIV_SUIV CF_NIV_SUIV NaN None False None False None NaT None None False False False False False