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_12_Conditionrelativemarche


In [2]:
extrait_df_d_12_conditionrelativemarche = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_12_conditionrelativemarche.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_12_conditionrelativemarche.html");
In [4]:
extrait_df_d_12_conditionrelativemarche.info()
<class 'pandas.core.frame.DataFrame'>
Index: 6860 entries, 20-107212 to 21-9966
Data columns (total 12 columns):
 #   Column                                                        Non-Null Count  Dtype 
---  ------                                                        --------------  ----- 
 0   D_12_01_Conditionrelativemarche_Cautionnement                 1513 non-null   object
 1   D_12_02_Conditionrelativemarche_Financement                   2293 non-null   object
 2   D_12_03_Conditionrelativemarche_Formejuridique                2167 non-null   object
 3   D_12_04_Conditionrelativemarche_Participationelectroniqueoui  6860 non-null   bool  
 4   D_12_05_Conditionrelativemarche_Participationelectroniquenon  6860 non-null   bool  
 5   D_12_06_Conditionrelativemarche_Autresconditionspartoui       424 non-null    object
 6   D_12_07_Conditionrelativemarche_Autresconditionspartnon       6860 non-null   bool  
 7   D_12_08_Conditionrelativemarche_Unitemonetaireeur             6860 non-null   bool  
 8   D_12_09_Conditionrelativemarche_Francaisseul                  6860 non-null   bool  
 9   D_12_10_Conditionrelativemarche_Langues                       6860 non-null   object
 10  D_12_10_01_Conditionrelativemarche_Langues_Langue             6261 non-null   object
 11  D_12_10_02_Conditionrelativemarche_Langues_Autres             5 non-null      object
dtypes: bool(5), object(7)
memory usage: 462.2+ KB
In [5]:
extrait_df_d_12_conditionrelativemarche.head(3).T
Out[5]:
BOAMP_AVIS_NUM 20-107212 20-114622 20-117134
D_12_01_Conditionrelativemarche_Cautionnement None None None
D_12_02_Conditionrelativemarche_Financement None None None
D_12_03_Conditionrelativemarche_Formejuridique None None None
D_12_04_Conditionrelativemarche_Participationelectroniqueoui False True False
D_12_05_Conditionrelativemarche_Participationelectroniquenon False False True
D_12_06_Conditionrelativemarche_Autresconditionspartoui None None None
D_12_07_Conditionrelativemarche_Autresconditionspartnon False True False
D_12_08_Conditionrelativemarche_Unitemonetaireeur True False False
D_12_09_Conditionrelativemarche_Francaisseul True False False
D_12_10_Conditionrelativemarche_Langues CF_NIV_SUIV CF_NIV_SUIV CF_NIV_SUIV
D_12_10_01_Conditionrelativemarche_Langues_Langue None [FR] [FR]
D_12_10_02_Conditionrelativemarche_Langues_Autres None None None
In [6]:
extrait_df_d_12_conditionrelativemarche.head(3)
Out[6]:
D_12_01_Conditionrelativemarche_Cautionnement D_12_02_Conditionrelativemarche_Financement D_12_03_Conditionrelativemarche_Formejuridique D_12_04_Conditionrelativemarche_Participationelectroniqueoui D_12_05_Conditionrelativemarche_Participationelectroniquenon D_12_06_Conditionrelativemarche_Autresconditionspartoui D_12_07_Conditionrelativemarche_Autresconditionspartnon D_12_08_Conditionrelativemarche_Unitemonetaireeur D_12_09_Conditionrelativemarche_Francaisseul D_12_10_Conditionrelativemarche_Langues D_12_10_01_Conditionrelativemarche_Langues_Langue D_12_10_02_Conditionrelativemarche_Langues_Autres
BOAMP_AVIS_NUM
20-107212 None None None False False None False True True CF_NIV_SUIV None None
20-114622 None None None True False None True False False CF_NIV_SUIV [FR] None
20-117134 None None None False True None False False False CF_NIV_SUIV [FR] None