{ "cells": [ { "cell_type": "markdown", "id": "97d1367a-6f39-4fbb-85ac-cb42680838b2", "metadata": {}, "source": [ "# Automotive industry sites" ] }, { "cell_type": "code", "execution_count": 1, "id": "c34a1e8c-c386-41c4-b5bd-16d8d3085c02", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/opt/python/lib/python3.13/site-packages/tqdm/auto.py:21: TqdmWarning: IProgress not found. Please update jupyter and ipywidgets. See https://ipywidgets.readthedocs.io/en/stable/user_install.html\n", " from .autonotebook import tqdm as notebook_tqdm\n" ] } ], "source": [ "import pandas as pd\n", "import numpy as np\n", "from shapely.ops import transform\n", "\n", "#%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import matplotlib.cm as cm\n", "from matplotlib.offsetbox import AnchoredText\n", "\n", "from pynsee import *" ] }, { "cell_type": "code", "execution_count": 2, "id": "afd9bb1b-b5e9-4eb1-8da6-f0dfa716c35b", "metadata": {}, "outputs": [], "source": [ "# get activity list\n", "naf5 = get_activity_list('NAF5')\n", "\n", "# search data in SIRENE database\n", "data = search_sirene(variable=\"activitePrincipaleEtablissement\",\n", " pattern='29.10Z', kind='siret', number=2000)" ] }, { "cell_type": "code", "execution_count": 3, "id": "4b5071e6-9d3f-4f80-b2b5-bd775d8cac5b", "metadata": {}, "outputs": [], "source": [ "data.to_csv('sirene.csv')" ] }, { "cell_type": "code", "execution_count": 4, "id": "fdcb6abc-cead-4fd2-b5ad-662a9f5f33cf", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | siren | \n", "nic | \n", "siret | \n", "dateDebut | \n", "dateCreationEtablissement | \n", "dateCreationUniteLegale | \n", "dateFin | \n", "denominationUniteLegale | \n", "nomUniteLegale | \n", "prenomUsuelUniteLegale | \n", "... | \n", "libelleVoie2Etablissement | \n", "codePostal2Etablissement | \n", "libelleCommune2Etablissement | \n", "libelleCommuneEtranger2Etablissement | \n", "distributionSpeciale2Etablissement | \n", "codeCommune2Etablissement | \n", "codeCedex2Etablissement | \n", "libelleCedex2Etablissement | \n", "codePaysEtranger2Etablissement | \n", "libellePaysEtranger2Etablissement | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "006580195 | \n", "00011 | \n", "00658019500011 | \n", "2008-01-01 | \n", "1965-01-01 | \n", "1965-01-01 | \n", "None | \n", "SOCIETE INDUSTRIELLE POUR LE DEVELOPPEMENT DE ... | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
| 1 | \n", "085520195 | \n", "00109 | \n", "08552019500109 | \n", "2022-09-01 | \n", "2022-06-30 | \n", "1955-01-01 | \n", "None | \n", "SAFRA | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
| 2 | \n", "301692307 | \n", "00020 | \n", "30169230700020 | \n", "2020-12-31 | \n", "2014-08-15 | \n", "1965-01-01 | \n", "None | \n", "GARAGE BEYRIS | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
| 3 | \n", "302279229 | \n", "00025 | \n", "30227922900025 | \n", "2014-07-25 | \n", "1900-01-01 | \n", "1975-01-01 | \n", "None | \n", "RAPIDO | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
| 4 | \n", "302279229 | \n", "00033 | \n", "30227922900033 | \n", "2008-01-01 | \n", "1996-01-01 | \n", "1975-01-01 | \n", "None | \n", "RAPIDO | \n", "None | \n", "None | \n", "... | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
5 rows × 96 columns
\n", "| \n", " | geometry | \n", "cleabs | \n", "nom_officiel | \n", "nom_officiel_en_majuscules | \n", "code_insee | \n", "code_insee_de_la_region | \n", "code_siren | \n", "code_insee_du_departement | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "MULTIPOLYGON (((277926.054 5709617.925, 277848... | \n", "DEPARTEM0000000000000063 | \n", "Puy-de-Dôme | \n", "PUY-DE-DOME | \n", "63 | \n", "84 | \n", "226300010 | \n", "63 | \n", "
| 1 | \n", "MULTIPOLYGON (((336295.261 6472777.256, 336428... | \n", "DEPARTEM0000000000000059 | \n", "Nord | \n", "NORD | \n", "59 | \n", "32 | \n", "225900018 | \n", "59 | \n", "
| 2 | \n", "MULTIPOLYGON (((-91403.654 6186431.719, -91543... | \n", "DEPARTEM0000000000000061 | \n", "Orne | \n", "ORNE | \n", "61 | \n", "28 | \n", "226100014 | \n", "61 | \n", "
| 3 | \n", "MULTIPOLYGON (((582085.39 5342294.655, 582092.... | \n", "DEPARTEM0000000000000013 | \n", "Bouches-du-Rhône | \n", "BOUCHES-DU-RHONE | \n", "13 | \n", "93 | \n", "221300015 | \n", "13 | \n", "
| 4 | \n", "MULTIPOLYGON (((259950.061 6258104.764, 260905... | \n", "DEPARTEM0000000000000075 | \n", "Paris | \n", "PARIS | \n", "75 | \n", "11 | \n", "227500055 | \n", "75 | \n", "