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_01_Identite


In [2]:
extrait_df_d_01_identite = pd.read_pickle('boamp_2021_T1_data_mensuel/df_boamp_2021_02_D_01_identite.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_01_identite.html");
In [4]:
extrait_df_d_01_identite.info()
<class 'pandas.core.frame.DataFrame'>
Index: 11513 entries, 18-111639 to 21-9966
Data columns (total 24 columns):
 #   Column                                        Non-Null Count  Dtype 
---  ------                                        --------------  ----- 
 0   D_01_01_Identite_Denomination                 11513 non-null  object
 1   D_01_02_Identite_Codeidentnational            11513 non-null  object
 2   D_01_03_Identite_Correspondant                5695 non-null   object
 3   D_01_04_Identite_Contact                      1559 non-null   object
 4   D_01_05_Identite_Adjudicateurnuts             5808 non-null   object
 5   D_01_06_Identite_Adresse                      11356 non-null  object
 6   D_01_07_Identite_Cp                           11513 non-null  object
 7   D_01_08_Identite_Ville                        11513 non-null  object
 8   D_01_09_Identite_Pays                         49 non-null     object
 9   D_01_10_Identite_Tel                          7594 non-null   object
 10  D_01_11_Identite_Poste                        50 non-null     object
 11  D_01_12_Identite_Fax                          2724 non-null   object
 12  D_01_13_Identite_Mel                          10279 non-null  object
 13  D_01_14_Identite_Url                          9948 non-null   object
 14  D_01_15_Identite_Urlprofilacheteur            9390 non-null   object
 15  D_01_16_Identite_Urlinformation               218 non-null    object
 16  D_01_17_Identite_Urlparticipation             3063 non-null   object
 17  D_01_18_Identite_Urldocument                  3127 non-null   object
 18  D_01_19_Identite_Outillogiciel                435 non-null    object
 19  D_01_20_Identite_Agitpourautrecompteoui       11513 non-null  bool  
 20  D_01_21_Identite_Agitpourautrecomptenon       11513 non-null  bool  
 21  D_01_22_Identite_Loicompteautrepays           10 non-null     object
 22  D_01_23_Identite_Organismeacheteurcentraloui  11513 non-null  bool  
 23  D_01_24_Identite_Organismeacheteurcentralnon  11513 non-null  bool  
dtypes: bool(4), object(20)
memory usage: 1.9+ MB
In [5]:
extrait_df_d_01_identite.head(3).T
Out[5]:
BOAMP_AVIS_NUM 18-111639 19-138840 20-105937
D_01_01_Identite_Denomination Ville de Draguignan (83) Centre des monuments nationaux Ville de Lescar
D_01_02_Identite_Codeidentnational None None None
D_01_03_Identite_Correspondant None None None
D_01_04_Identite_Contact commande publique None None
D_01_05_Identite_Adjudicateurnuts FR FR FRI15
D_01_06_Identite_Adresse rue Cisson 62 Rue Saint Antoine Allée du bois d'Ariste CS 70488
D_01_07_Identite_Cp 83300 75004 64238
D_01_08_Identite_Ville Draguignan Paris Lescar cedex
D_01_09_Identite_Pays None None None
D_01_10_Identite_Tel (+33) -04-94-60-20-94 (+33) 1-44-61-22-21 (+33) 5-59-81-57-13
D_01_11_Identite_Poste None None None
D_01_12_Identite_Fax None None None
D_01_13_Identite_Mel [email protected] [email protected] [email protected]
D_01_14_Identite_Url http://www.ville-draguignan.fr http://www.monuments-nationaux.fr http://www.lescar.fr
D_01_15_Identite_Urlprofilacheteur http://www.marches-securises.fr https://www.marches-publics.gouv.fr/?page=entreprise.EntrepriseAdvancedSearch&amp;AllCons&amp;refConsultation=460679&amp;orgAcronyme=f5j https://www.demat-ampa.fr
D_01_16_Identite_Urlinformation None None None
D_01_17_Identite_Urlparticipation None None None
D_01_18_Identite_Urldocument None None None
D_01_19_Identite_Outillogiciel None None None
D_01_20_Identite_Agitpourautrecompteoui False False False
D_01_21_Identite_Agitpourautrecomptenon False True True
D_01_22_Identite_Loicompteautrepays None None None
D_01_23_Identite_Organismeacheteurcentraloui False False False
D_01_24_Identite_Organismeacheteurcentralnon False True True
In [6]:
extrait_df_d_01_identite.head(3)
Out[6]:
D_01_01_Identite_Denomination D_01_02_Identite_Codeidentnational D_01_03_Identite_Correspondant D_01_04_Identite_Contact D_01_05_Identite_Adjudicateurnuts D_01_06_Identite_Adresse D_01_07_Identite_Cp D_01_08_Identite_Ville D_01_09_Identite_Pays D_01_10_Identite_Tel D_01_11_Identite_Poste D_01_12_Identite_Fax D_01_13_Identite_Mel D_01_14_Identite_Url D_01_15_Identite_Urlprofilacheteur D_01_16_Identite_Urlinformation D_01_17_Identite_Urlparticipation D_01_18_Identite_Urldocument D_01_19_Identite_Outillogiciel D_01_20_Identite_Agitpourautrecompteoui D_01_21_Identite_Agitpourautrecomptenon D_01_22_Identite_Loicompteautrepays D_01_23_Identite_Organismeacheteurcentraloui D_01_24_Identite_Organismeacheteurcentralnon
BOAMP_AVIS_NUM
18-111639 Ville de Draguignan (83) None None commande publique FR rue Cisson 83300 Draguignan None (+33) -04-94-60-20-94 None None [email protected] http://www.ville-draguignan.fr http://www.marches-securises.fr None None None None False False None False False
19-138840 Centre des monuments nationaux None None None FR 62 Rue Saint Antoine 75004 Paris None (+33) 1-44-61-22-21 None None [email protected] http://www.monuments-nationaux.fr https://www.marches-publics.gouv.fr/?page=entreprise.EntrepriseAdvancedSearch&amp;AllCons&amp;refConsultation=460679&amp;orgAcronyme=f5j None None None None False True None False True
20-105937 Ville de Lescar None None None FRI15 Allée du bois d'Ariste CS 70488 64238 Lescar cedex None (+33) 5-59-81-57-13 None None [email protected] http://www.lescar.fr https://www.demat-ampa.fr None None None None False True None False True
In [ ]:
 
In [ ]: