Jean-Marie FALVET | Data Broker B2B | AuFilDuBoamp AuFilDuBoamp
AuFilDuBoamp
/ comment-telecharger-la-table-boamp-siren-acheteurs-80-d-aufilduboamp-avec-python-en-4-etapes.ipynb
Last active
July 20, 2024 11:17
comment-telecharger-la-table-boamp-siren-acheteurs-80-d-aufilduboamp-avec-python-en-4-etapes.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
AuFilDuBoamp
/ dico_py_replace_calendar_en_to_fr.txt
Last active
July 4, 2024 14:40
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dico_py_replace_calendar_en_to_fr = { | |
| "Monday": "Lundi", | |
| "Tuesday": "Mardi", | |
| "Wednesday": "Mercredi", | |
| "Thursday": "Jeudi", | |
| "Friday": "Vendredi", | |
| "Saturday": "Samedi", | |
| "Sunday": "Dimanche", | |
| "January": "Janvier", | |
| "February": "Février", |
AuFilDuBoamp
/ 211_telecharger_boamp_2024_csv_pour_pandas.py
Last active
July 27, 2024 11:20
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Adresse du tableau BOAMP officiel (2024 - CSV) | |
| URL = "https://boamp-datadila.opendatasoft.com/api/explore/v2.1/catalog/datasets/boamp/\ | |
| exports/csv?lang=fr&qv1=(dateparution%3A2024)&timezone=Europe%2FBerlin&use_labels=true&delimiter=%3B" | |
| # Création de la Dataframe | |
| df = pd.read_csv(URL, sep=';', low_memory=False, dtype='string', encoding='utf-8') |
AuFilDuBoamp
/ 003_liste_des_regions_francaises_pour_python.py
Last active
July 27, 2024 11:21
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Liste des Régions françaises et assimilées (au format SIRENE) | |
| LISTE_REGIONS = [ | |
| "COLLECTIVITE DE CORSE", | |
| "COLLECTIVITE TERRITORIALE DE GUYANE", | |
| "COLLECTIVITE TERRITORIALE DE MARTINIQUE", | |
| "CONSEIL REGIONAL DE LA GUADELOUPE", | |
| "REGION AUVERGNE-RHONE-ALPES", | |
| "REGION BOURGOGNE-FRANCHE-COMTE", | |
| "REGION BRETAGNE", | |
| "REGION CENTRE-VAL DE LOIRE", |
AuFilDuBoamp
/ LISTE_CONSEILS_REGIONAUX_SIRENE.csv
Last active
August 3, 2024 15:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| REGION_NOM_SIREN | REGION_NUM_SIREN | REGION_NUM_SIRET | REGION_CP | |
|---|---|---|---|---|
| COLLECTIVITE DE CORSE | 200076958 | 20007695800012 | 20000 | |
| COLLECTIVITE TERRITORIALE DE GUYANE | 200052678 | 20005267800014 | 97300 | |
| COLLECTIVITE TERRITORIALE DE MARTINIQUE | 200055507 | 20005550700012 | 97200 | |
| CONSEIL REGIONAL DE LA GUADELOUPE | 239710015 | 23971001500029 | 97100 | |
| REGION AUVERGNE-RHONE-ALPES | 200053767 | 20005376700014 | 69002 | |
| REGION BOURGOGNE-FRANCHE-COMTE | 200053726 | 20005372600028 | 25000 | |
| REGION BRETAGNE | 233500016 | 23350001600040 | 35700 | |
| REGION CENTRE-VAL DE LOIRE | 234500023 | 23450002300028 | 45000 | |
| REGION GRAND EST | 200052264 | 20005226400013 | 67000 |
AuFilDuBoamp
/ 003_selectionner_conseils_regionaux_boamp_t1_2024.py
Last active
August 1, 2024 15:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Fichier lié à l'article ► https://www.aufilduboamp.com/article3.html | |
| # Importer pandas: | |
| import pandas as pd | |
| # Charger une copie du premier trimestre 2024 du tableau Boamp | |
| # officiel versée sur notre dépôt Datagouv par confort: | |
| df_boamp_t1_2024 = pd.read_parquet('https://www.data.gouv.fr/fr/datasets/r/f7a4a76e-ff50-4dc6-bae8-97368081add2') | |
| # Maintenant charger le CSV des régions sur github: |
AuFilDuBoamp
/ 211_selectionner_conseils_regionaux_panorama_t1_2024.py
Last active
August 1, 2024 15:11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Fichier lié à l'article ► https://www.aufilduboamp.com/article211.html | |
| # Importer pandas: | |
| import pandas as pd | |
| # Charger une copie du premier trimestre 2024 du tableau Boamp | |
| # Panorama versée sur notre dépôt Datagouv: | |
| df_boamp_t1_2024 = pd.read_parquet('https://www.data.gouv.fr/fr/datasets/r/e9942655-a7b9-4680-a174-02dab1039b49') | |
| ## Sélectionner les annonces du premier trimestre: |
AuFilDuBoamp
/ 216_selectionner_conseils_regionaux_bsa_t1_2024.py
Created
August 1, 2024 15:21
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Fichier lié à l'article ► https://www.aufilduboamp.com/article216.html | |
| # Importer pandas: | |
| import pandas as pd | |
| # Charger une copie du premier trimestre 2024 du tableau | |
| # BOAMP-SIREN-ACHETEURS (BSA) d'AuFilDuBoamp | |
| df_boamp_t1_2024_bsa = pd.read_parquet('https://www.data.gouv.fr/fr/datasets/r/4b77da19-3834-4a12-9626-9aedd75d168a') | |
AuFilDuBoamp
/ LISTE_DEPARTEMENTS_FRANCAIS_SIRENE.csv
Created
August 3, 2024 10:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DEPARTEMENT_NOM_SIREN | DEPARTEMENT_NUM_SIREN | DEPARTEMENT_NUM_SIRET | DEPARTEMENT_CP_SIEGE | ||
|---|---|---|---|---|---|
| 0 | DEPARTEMENT DE L AIN | 220100010 | 22010001000010 | 01000 | |
| 1 | DEPARTEMENT DE L AISNE | 220200026 | 22020002600015 | 02000 | |
| 2 | DEPARTEMENT DE L ALLIER | 220300016 | 22030001600080 | 03000 | |
| 3 | DEPARTEMENT DES ALPES DE HAUTE PROVENCE | 220400014 | 22040001400019 | 04000 | |
| 4 | DEPARTEMENT DES HAUTES ALPES | 220500011 | 22050001100089 | 05000 | |
| 5 | DEPARTEMENT DES ALPES MARITIMES | 220600019 | 22060001900016 | 06200 | |
| 6 | DEPARTEMENT DE L ARDECHE | 220700017 | 22070001700019 | 07000 | |
| 7 | DEPARTEMENT DES ARDENNES | 220800049 | 22080004900011 | 08000 | |
| 8 | DEPARTEMENT DE L ARIEGE | 220900013 | 22090001300016 | 09000 |
AuFilDuBoamp
/ LISTE_COM_AGGLO_FRANCAISES_SIRENE.csv
Last active
August 3, 2024 14:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| COM_AGGLO_NOM_SIREN | COM_AGGLO_NUM_SIREN | COM_AGGLO_NUM_SIRET | COM_AGGLO_DEP | ||
|---|---|---|---|---|---|
| 0 | HAUT - BUGEY AGGLOMERATION | 200042935 | 20004293500011 | 01 | |
| 1 | CA DU BASSIN DE BOURG-EN-BRESSE | 200071751 | 20007175100016 | 01 | |
| 2 | COMMUNAUTE D'AGGLOMERATION DU PAYS DE GEX | 240100750 | 24010075000126 | 01 | |
| 3 | COMMUNAUTE D'AGGLOMERATION DU PAYS DE LAON | 200043495 | 20004349500015 | 02 | |
| 4 | CA CHAUNY TERGNIER LA FERE | 200071785 | 20007178500014 | 02 | |
| 5 | CA DU SAINT-QUENTINOIS | 200071892 | 20007189200067 | 02 | |
| 6 | CA DE LA REGION DE CHATEAU-THIERRY | 200072031 | 20007203100129 | 02 | |
| 7 | GRANDSOISSONS AGGLOMERATION | 240200477 | 24020047700026 | 02 | |
| 8 | CA MONTLUCON COMMUNAUTE | 200071082 | 20007108200016 | 03 |
OlderNewer