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_02_Typeorganisme


In [2]:
extrait_df_d_02_typeorganisme = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_02_typeorganisme.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_02_typeorganisme.html");
In [4]:
extrait_df_d_02_typeorganisme.info()
<class 'pandas.core.frame.DataFrame'>
Index: 5005 entries, 20-107212 to 21-9915
Data columns (total 8 columns):
 #   Column                                       Non-Null Count  Dtype 
---  ------                                       --------------  ----- 
 0   D_02_01_Typeorganisme_Institutioneuropeenne  5005 non-null   bool  
 1   D_02_02_Typeorganisme_Etat                   5005 non-null   bool  
 2   D_02_03_Typeorganisme_Region                 5005 non-null   bool  
 3   D_02_04_Typeorganisme_Departement            5005 non-null   bool  
 4   D_02_05_Typeorganisme_Commune                5005 non-null   bool  
 5   D_02_06_Typeorganisme_Epn                    5005 non-null   bool  
 6   D_02_07_Typeorganisme_Ept                    5005 non-null   bool  
 7   D_02_08_Typeorganisme_Autre                  0 non-null      object
dtypes: bool(7), object(1)
memory usage: 112.4+ KB
In [5]:
extrait_df_d_02_typeorganisme.head(3).T
Out[5]:
BOAMP_AVIS_NUM 20-107212 20-124969 20-137224
D_02_01_Typeorganisme_Institutioneuropeenne False False False
D_02_02_Typeorganisme_Etat True False False
D_02_03_Typeorganisme_Region False False False
D_02_04_Typeorganisme_Departement False False True
D_02_05_Typeorganisme_Commune False False False
D_02_06_Typeorganisme_Epn False False False
D_02_07_Typeorganisme_Ept False False False
D_02_08_Typeorganisme_Autre None None None
In [6]:
extrait_df_d_02_typeorganisme.head(3)
Out[6]:
D_02_01_Typeorganisme_Institutioneuropeenne D_02_02_Typeorganisme_Etat D_02_03_Typeorganisme_Region D_02_04_Typeorganisme_Departement D_02_05_Typeorganisme_Commune D_02_06_Typeorganisme_Epn D_02_07_Typeorganisme_Ept D_02_08_Typeorganisme_Autre
BOAMP_AVIS_NUM
20-107212 False True False False False False False None
20-124969 False False False False False False False None
20-137224 False False False True False False False None