Skip to content

Instantly share code, notes, and snippets.

@adipasquale

adipasquale/explore-siret-idcc-mapping.ipynb

Created February 8, 2019 16:50
Show Gist options
  • Save adipasquale/c4f43ba865822069dbfd678ba711887d to your computer and use it in GitHub Desktop.
Save adipasquale/c4f43ba865822069dbfd678ba711887d to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
explore-siret-idcc-mapping.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 116,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"b'Skipping line 56017: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 69008: expected 29 fields, saw 31\\nSkipping line 73814: expected 29 fields, saw 30\\nSkipping line 77190: expected 29 fields, saw 30\\nSkipping line 80624: expected 29 fields, saw 31\\nSkipping line 82496: expected 29 fields, saw 31\\nSkipping line 84218: expected 29 fields, saw 31\\nSkipping line 88928: expected 29 fields, saw 30\\nSkipping line 93813: expected 29 fields, saw 30\\nSkipping line 93814: expected 29 fields, saw 30\\nSkipping line 94642: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 107473: expected 29 fields, saw 36\\nSkipping line 117374: expected 29 fields, saw 30\\nSkipping line 120314: expected 29 fields, saw 33\\nSkipping line 120381: expected 29 fields, saw 31\\nSkipping line 125141: expected 29 fields, saw 33\\n'\n",
"b'Skipping line 139655: expected 29 fields, saw 31\\nSkipping line 139870: expected 29 fields, saw 31\\nSkipping line 144367: expected 29 fields, saw 34\\nSkipping line 154235: expected 29 fields, saw 30\\nSkipping line 154236: expected 29 fields, saw 30\\nSkipping line 155491: expected 29 fields, saw 34\\n'\n",
"b'Skipping line 182499: expected 29 fields, saw 35\\nSkipping line 195412: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 198489: expected 29 fields, saw 30\\nSkipping line 216117: expected 29 fields, saw 31\\nSkipping line 216118: expected 29 fields, saw 31\\nSkipping line 217261: expected 29 fields, saw 30\\nSkipping line 217262: expected 29 fields, saw 30\\nSkipping line 221259: expected 29 fields, saw 30\\nSkipping line 221260: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 233482: expected 29 fields, saw 31\\nSkipping line 233483: expected 29 fields, saw 31\\nSkipping line 238726: expected 29 fields, saw 31\\nSkipping line 238727: expected 29 fields, saw 31\\nSkipping line 238728: expected 29 fields, saw 31\\nSkipping line 238729: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 264255: expected 29 fields, saw 30\\nSkipping line 264256: expected 29 fields, saw 30\\nSkipping line 264257: expected 29 fields, saw 30\\nSkipping line 273617: expected 29 fields, saw 30\\nSkipping line 273618: expected 29 fields, saw 30\\nSkipping line 273619: expected 29 fields, saw 30\\nSkipping line 285718: expected 29 fields, saw 30\\nSkipping line 290436: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 299633: expected 29 fields, saw 30\\nSkipping line 306727: expected 29 fields, saw 31\\nSkipping line 321331: expected 29 fields, saw 30\\nSkipping line 323892: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 338268: expected 29 fields, saw 31\\nSkipping line 345191: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 366474: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 403280: expected 29 fields, saw 30\\nSkipping line 404135: expected 29 fields, saw 30\\nSkipping line 404136: expected 29 fields, saw 30\\nSkipping line 406288: expected 29 fields, saw 30\\nSkipping line 407751: expected 29 fields, saw 30\\nSkipping line 411854: expected 29 fields, saw 30\\nSkipping line 413544: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 441468: expected 29 fields, saw 30\\nSkipping line 442483: expected 29 fields, saw 30\\nSkipping line 443905: expected 29 fields, saw 30\\nSkipping line 443906: expected 29 fields, saw 30\\nSkipping line 449763: expected 29 fields, saw 30\\nSkipping line 451699: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 458887: expected 29 fields, saw 33\\nSkipping line 458888: expected 29 fields, saw 33\\nSkipping line 462137: expected 29 fields, saw 31\\nSkipping line 464022: expected 29 fields, saw 30\\nSkipping line 464023: expected 29 fields, saw 30\\nSkipping line 464311: expected 29 fields, saw 33\\nSkipping line 464312: expected 29 fields, saw 33\\nSkipping line 464313: expected 29 fields, saw 33\\nSkipping line 467645: expected 29 fields, saw 30\\nSkipping line 469947: expected 29 fields, saw 30\\nSkipping line 479434: expected 29 fields, saw 31\\nSkipping line 483414: expected 29 fields, saw 30\\nSkipping line 483990: expected 29 fields, saw 30\\nSkipping line 488706: expected 29 fields, saw 32\\nSkipping line 490098: expected 29 fields, saw 30\\nSkipping line 491438: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 492058: expected 29 fields, saw 30\\nSkipping line 492277: expected 29 fields, saw 30\\nSkipping line 494873: expected 29 fields, saw 30\\nSkipping line 506601: expected 29 fields, saw 30\\nSkipping line 508060: expected 29 fields, saw 30\\nSkipping line 516520: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 533091: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 565526: expected 29 fields, saw 30\\nSkipping line 574319: expected 29 fields, saw 35\\n'\n",
"b'Skipping line 591334: expected 29 fields, saw 30\\nSkipping line 601654: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 637712: expected 29 fields, saw 30\\nSkipping line 655241: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 664111: expected 29 fields, saw 32\\n'\n",
"b'Skipping line 701492: expected 29 fields, saw 31\\nSkipping line 703605: expected 29 fields, saw 30\\nSkipping line 708641: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 759589: expected 29 fields, saw 32\\nSkipping line 786482: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 791984: expected 29 fields, saw 30\\nSkipping line 807167: expected 29 fields, saw 32\\nSkipping line 807168: expected 29 fields, saw 32\\nSkipping line 809876: expected 29 fields, saw 30\\nSkipping line 809877: expected 29 fields, saw 30\\nSkipping line 811324: expected 29 fields, saw 30\\nSkipping line 817171: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 821480: expected 29 fields, saw 30\\nSkipping line 821481: expected 29 fields, saw 30\\nSkipping line 824141: expected 29 fields, saw 32\\nSkipping line 825248: expected 29 fields, saw 30\\nSkipping line 840566: expected 29 fields, saw 30\\nSkipping line 842843: expected 29 fields, saw 32\\n'\n",
"b'Skipping line 861340: expected 29 fields, saw 30\\nSkipping line 865622: expected 29 fields, saw 30\\nSkipping line 865623: expected 29 fields, saw 30\\nSkipping line 870612: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 896942: expected 29 fields, saw 35\\nSkipping line 898694: expected 29 fields, saw 30\\nSkipping line 910889: expected 29 fields, saw 30\\nSkipping line 911644: expected 29 fields, saw 30\\nSkipping line 911645: expected 29 fields, saw 30\\nSkipping line 911646: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 945695: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 967391: expected 29 fields, saw 33\\nSkipping line 967392: expected 29 fields, saw 33\\n'\n",
"b'Skipping line 1029571: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1056252: expected 29 fields, saw 31\\nSkipping line 1079216: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1081885: expected 29 fields, saw 31\\nSkipping line 1094125: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1196847: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1218067: expected 29 fields, saw 30\\nSkipping line 1225036: expected 29 fields, saw 30\\nSkipping line 1229988: expected 29 fields, saw 30\\nSkipping line 1235326: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1252210: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1327929: expected 29 fields, saw 30\\nSkipping line 1327930: expected 29 fields, saw 30\\nSkipping line 1327931: expected 29 fields, saw 30\\nSkipping line 1327932: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1344647: expected 29 fields, saw 30\\nSkipping line 1345559: expected 29 fields, saw 30\\nSkipping line 1346670: expected 29 fields, saw 30\\nSkipping line 1348017: expected 29 fields, saw 30\\nSkipping line 1348018: expected 29 fields, saw 30\\nSkipping line 1348334: expected 29 fields, saw 30\\nSkipping line 1351129: expected 29 fields, saw 30\\nSkipping line 1351686: expected 29 fields, saw 30\\nSkipping line 1356341: expected 29 fields, saw 31\\nSkipping line 1366919: expected 29 fields, saw 30\\nSkipping line 1366920: expected 29 fields, saw 30\\nSkipping line 1366921: expected 29 fields, saw 30\\nSkipping line 1366985: expected 29 fields, saw 30\\nSkipping line 1367526: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1382613: expected 29 fields, saw 30\\nSkipping line 1396317: expected 29 fields, saw 31\\nSkipping line 1396318: expected 29 fields, saw 31\\nSkipping line 1408563: expected 29 fields, saw 30\\nSkipping line 1408564: expected 29 fields, saw 30\\nSkipping line 1408565: expected 29 fields, saw 30\\n'\n"
]
},
{
"name": "stderr",
"output_type": "stream",
"text": [
"b'Skipping line 1420076: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 1442945: expected 29 fields, saw 30\\nSkipping line 1443694: expected 29 fields, saw 30\\nSkipping line 1443695: expected 29 fields, saw 30\\nSkipping line 1444814: expected 29 fields, saw 32\\nSkipping line 1445905: expected 29 fields, saw 31\\nSkipping line 1450087: expected 29 fields, saw 30\\nSkipping line 1450341: expected 29 fields, saw 30\\nSkipping line 1451720: expected 29 fields, saw 30\\nSkipping line 1451721: expected 29 fields, saw 30\\nSkipping line 1451722: expected 29 fields, saw 30\\nSkipping line 1455479: expected 29 fields, saw 30\\nSkipping line 1455896: expected 29 fields, saw 31\\nSkipping line 1456224: expected 29 fields, saw 30\\nSkipping line 1458372: expected 29 fields, saw 35\\n'\n",
"b'Skipping line 1484068: expected 29 fields, saw 30\\nSkipping line 1486417: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1513195: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1569190: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 1590761: expected 29 fields, saw 30\\nSkipping line 1590762: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1625788: expected 29 fields, saw 30\\n'\n",
"b'Skipping line 1647128: expected 29 fields, saw 30\\nSkipping line 1661795: expected 29 fields, saw 32\\n'\n",
"b'Skipping line 1706514: expected 29 fields, saw 30\\nSkipping line 1711483: expected 29 fields, saw 32\\nSkipping line 1715309: expected 29 fields, saw 30\\nSkipping line 1734085: expected 29 fields, saw 31\\n'\n",
"b'Skipping line 1780248: expected 29 fields, saw 31\\n'\n"
]
}
],
"source": [
"df_original = pd.read_csv('extraction_etablissements_idcc.csv', sep=\";\", quotechar='\"', error_bad_lines=False)"
]
},
{
"cell_type": "code",
"execution_count": 117,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Nom de l'établissement</th>\n",
" <th>SIRET</th>\n",
" <th>Raison Sociale</th>\n",
" <th>Enseigne</th>\n",
" <th>Siège</th>\n",
" <th>Dernier effectif connu</th>\n",
" <th>Code postal</th>\n",
" <th>Commune</th>\n",
" <th>Pays</th>\n",
" <th>Numéro dans la voie</th>\n",
" <th>...</th>\n",
" <th>Equipe</th>\n",
" <th>Email UC</th>\n",
" <th>URL SP de l'équipe</th>\n",
" <th>Standard UC</th>\n",
" <th>IDCC</th>\n",
" <th>Convention</th>\n",
" <th>Intitulé abrégé Convention</th>\n",
" <th>Lien vers convention</th>\n",
" <th>Niveau d'application</th>\n",
" <th>Numéro de brochure</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0255</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0203</td>\n",
" <td>Bâtiment Ingénieurs cadres</td>\n",
" <td>Bâtiment Ingénieurs cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0072</td>\n",
" <td>Bâtiment ouvriers Eure et Loir</td>\n",
" <td>Bâtiment ouvriers Eure et Loir</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Johann Acatrini Transporte-87452-ALTUSRIED-KRU...</td>\n",
" <td>ETR00000021727</td>\n",
" <td>Johann Acatrini Transporte</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>87452</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle Pays d'Aix</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.42.39.56.12</td>\n",
" <td>0016</td>\n",
" <td>CC nationale des transports routiers et activi...</td>\n",
" <td>Transports routiers</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>SERGE VANTHOURNOUT-38960-SAINT ETIENNE DE CROSSEY</td>\n",
" <td>39125196400014</td>\n",
" <td>SERGE VANTHOURNOUT</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>38960</td>\n",
" <td>SAINT ETIENNE DE CROSSEY</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle Isère Grenoble Nord et Ouest</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>00.00.00.00.00</td>\n",
" <td>1596</td>\n",
" <td>CC nationale concernant les ouvriers employés ...</td>\n",
" <td>Bâtiment ouvriers jusqu'à 10 Salariés</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 29 columns</p>\n",
"</div>"
],
"text/plain": [
" Nom de l'établissement SIRET \\\n",
"0 HPK WESER-BREMEN ETR00000010002 \n",
"1 HPK WESER-BREMEN ETR00000010002 \n",
"2 HPK WESER-BREMEN ETR00000010002 \n",
"3 Johann Acatrini Transporte-87452-ALTUSRIED-KRU... ETR00000021727 \n",
"4 SERGE VANTHOURNOUT-38960-SAINT ETIENNE DE CROSSEY 39125196400014 \n",
"\n",
" Raison Sociale Enseigne Siège Dernier effectif connu \\\n",
"0 HPK WESER NaN 0 0 \n",
"1 HPK WESER NaN 0 0 \n",
"2 HPK WESER NaN 0 0 \n",
"3 Johann Acatrini Transporte NaN 0 0 \n",
"4 SERGE VANTHOURNOUT NaN 1 1 \n",
"\n",
" Code postal Commune Pays Numéro dans la voie ... \\\n",
"0 NaN NaN Allemagne 8 ... \n",
"1 NaN NaN Allemagne 8 ... \n",
"2 NaN NaN Allemagne 8 ... \n",
"3 87452 NaN Allemagne NaN ... \n",
"4 38960 SAINT ETIENNE DE CROSSEY France NaN ... \n",
"\n",
" Equipe \\\n",
"0 2ème unité de contrôle d'Eure et Loir \n",
"1 2ème unité de contrôle d'Eure et Loir \n",
"2 2ème unité de contrôle d'Eure et Loir \n",
"3 Unité de contrôle Pays d'Aix \n",
"4 Unité de contrôle Isère Grenoble Nord et Ouest \n",
"\n",
" Email UC \\\n",
"0 [email protected] \n",
"1 [email protected] \n",
"2 [email protected] \n",
"3 [email protected] \n",
"4 [email protected] \n",
"\n",
" URL SP de l'équipe Standard UC \\\n",
"0 https://wikit.ged.travail.gouv.fr/sites/wikitc... 02 37 91 23 20/23 33 \n",
"1 https://wikit.ged.travail.gouv.fr/sites/wikitc... 02 37 91 23 20/23 33 \n",
"2 https://wikit.ged.travail.gouv.fr/sites/wikitc... 02 37 91 23 20/23 33 \n",
"3 https://wikit.ged.travail.gouv.fr/sites/wikitc... 04.42.39.56.12 \n",
"4 https://wikit.ged.travail.gouv.fr/sites/wikitc... 00.00.00.00.00 \n",
"\n",
" IDCC Convention \\\n",
"0 0255 Bâtiment ETAM \n",
"1 0203 Bâtiment Ingénieurs cadres \n",
"2 0072 Bâtiment ouvriers Eure et Loir \n",
"3 0016 CC nationale des transports routiers et activi... \n",
"4 1596 CC nationale concernant les ouvriers employés ... \n",
"\n",
" Intitulé abrégé Convention Lien vers convention \\\n",
"0 Bâtiment ETAM NaN \n",
"1 Bâtiment Ingénieurs cadres NaN \n",
"2 Bâtiment ouvriers Eure et Loir NaN \n",
"3 Transports routiers NaN \n",
"4 Bâtiment ouvriers jusqu'à 10 Salariés NaN \n",
"\n",
" Niveau d'application Numéro de brochure \n",
"0 NaN NaN \n",
"1 NaN NaN \n",
"2 NaN NaN \n",
"3 NaN NaN \n",
"4 NaN NaN \n",
"\n",
"[5 rows x 29 columns]"
]
},
"execution_count": 117,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_original.head()"
]
},
{
"cell_type": "code",
"execution_count": 186,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"got 1780113 rows\n",
"cleaned rows with SIRET 0 and 1, got 1775472 rows\n"
]
}
],
"source": [
"print(\"got %s rows\" % df_original.shape[0])\n",
"df = df[df[\"SIRET\"] != 0]\n",
"df = df[df[\"SIRET\"] != 1]\n",
"df = df[df[\"SIRET\"] != '0']\n",
"df = df[df[\"SIRET\"] != '1']\n",
"print(\"cleaned rows with SIRET 0 and 1, got %s rows\" % df.shape[0])\n"
]
},
{
"cell_type": "code",
"execution_count": 187,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" count freq in %\n",
"IDCC \n",
"9999 338411 19.0\n",
"1979 86021 5.0\n",
"1043 84133 5.0\n",
"1596 78982 4.0\n",
"1090 55748 3.0\n",
"1486 42328 2.0\n",
"2596 31346 2.0\n",
"0016 30082 2.0\n",
"2609 29688 2.0\n",
"1527 29429 2.0\n"
]
}
],
"source": [
"def get_idcc_freq(df1):\n",
" df2 = df1[[\"IDCC\"]]\n",
" counts = df2.groupby(['IDCC']).size()\n",
" counts = counts.sort_values(ascending=False)\n",
" df3 = pd.DataFrame({\"count\": counts, \"freq in %\": round(counts / counts.sum() * 100)})\n",
" print(df3[0:10])\n",
"get_idcc_freq(df)"
]
},
{
"cell_type": "code",
"execution_count": 188,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
" count freq in %\n",
"IDCC \n",
"1979 86021 6.0\n",
"1043 84133 6.0\n",
"1596 78982 6.0\n",
"1090 55748 4.0\n",
"1486 42328 3.0\n",
"2596 31346 2.0\n",
"0016 30082 2.0\n",
"2609 29688 2.0\n",
"1527 29429 2.0\n",
"1147 28561 2.0\n"
]
}
],
"source": [
"df4 = df[df[\"IDCC\"] != '9999']\n",
"get_idcc_freq(df4)"
]
},
{
"cell_type": "code",
"execution_count": 181,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/adipasquale/.virtualenvs/siret-idcc-mapping/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame.\n",
"Try using .loc[row_indexer,col_indexer] = value instead\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
" \n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"got 1597371 rows after removing rows with effectif == 0 (cleaned 11%)\n"
]
}
],
"source": [
"df_eff = df.dropna(subset=[\"Dernier effectif connu\"])\n",
"df_eff[\"effectif\"] = df_eff[\"Dernier effectif connu\"].astype(int)\n",
"df_eff = df_eff[df_eff.effectif > 0]\n",
"print(\n",
" \"got %s rows after removing rows with effectif == 0 (cleaned %s%%)\" % \n",
" (df_eff.shape[0], round((df.shape[0] - df_eff.shape[0]) / df_eff.shape[0] * 100))\n",
")"
]
},
{
"cell_type": "code",
"execution_count": 189,
"metadata": {},
"outputs": [],
"source": [
"df_by_siret = df4[[\"SIRET\", \"IDCC\"]].groupby([\"SIRET\"]).filter(lambda r: len(set(r[\"IDCC\"])) > 1)"
]
},
{
"cell_type": "code",
"execution_count": 195,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"got 320928 rows\n",
"for 141424 different SIRETs\n"
]
}
],
"source": [
"print(\"got %s rows\" % df_by_siret.shape[0])\n",
"g = df_by_siret.groupby([\"SIRET\"]).size()\n",
"print(\"for %s different SIRETs\" % g.shape[0])"
]
},
{
"cell_type": "code",
"execution_count": 203,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Nom de l'établissement</th>\n",
" <th>SIRET</th>\n",
" <th>Raison Sociale</th>\n",
" <th>Enseigne</th>\n",
" <th>Siège</th>\n",
" <th>Dernier effectif connu</th>\n",
" <th>Code postal</th>\n",
" <th>Commune</th>\n",
" <th>Pays</th>\n",
" <th>Numéro dans la voie</th>\n",
" <th>...</th>\n",
" <th>Equipe</th>\n",
" <th>Email UC</th>\n",
" <th>URL SP de l'équipe</th>\n",
" <th>Standard UC</th>\n",
" <th>IDCC</th>\n",
" <th>Convention</th>\n",
" <th>Intitulé abrégé Convention</th>\n",
" <th>Lien vers convention</th>\n",
" <th>Niveau d'application</th>\n",
" <th>Numéro de brochure</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0255</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0203</td>\n",
" <td>Bâtiment Ingénieurs cadres</td>\n",
" <td>Bâtiment Ingénieurs cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>HPK WESER-BREMEN</td>\n",
" <td>ETR00000010002</td>\n",
" <td>HPK WESER</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Allemagne</td>\n",
" <td>8</td>\n",
" <td>...</td>\n",
" <td>2ème unité de contrôle d'Eure et Loir</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02 37 91 23 20/23 33</td>\n",
" <td>0072</td>\n",
" <td>Bâtiment ouvriers Eure et Loir</td>\n",
" <td>Bâtiment ouvriers Eure et Loir</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES</td>\n",
" <td>31445177400017</td>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES</td>\n",
" <td>31445177400017</td>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2281</td>\n",
" <td>CC des chefs d'établissement directeurs d'écol...</td>\n",
" <td>Enseignement primaire catholique directeurs</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES</td>\n",
" <td>31445177400017</td>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>0713</td>\n",
" <td>CC des surveillants personnels administratifs ...</td>\n",
" <td>Enseignement Loire St Etienne</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES</td>\n",
" <td>31445177400017</td>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2409</td>\n",
" <td>CC nationale des cadres des travaux publics du...</td>\n",
" <td>Travaux publics cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES</td>\n",
" <td>31445177400017</td>\n",
" <td>AEP ECOLE NOTRE DAME DE GRACE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2408</td>\n",
" <td>CC de travail des personnels des services admi...</td>\n",
" <td>Ets enseignement privé</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>BRED BANQUE POPULAIRE-97139-LES ABYMES</td>\n",
" <td>55209179502191</td>\n",
" <td>BRED BANQUE POPULAIRE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>5560</td>\n",
" <td>Banque Populaire</td>\n",
" <td>Banque Populaire</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>BRED BANQUE POPULAIRE-97139-LES ABYMES</td>\n",
" <td>55209179502191</td>\n",
" <td>BRED BANQUE POPULAIRE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>BRED BANQUE POPULAIRE-97139-LES ABYMES</td>\n",
" <td>55209179502191</td>\n",
" <td>BRED BANQUE POPULAIRE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2120</td>\n",
" <td>CC de la banque</td>\n",
" <td>Banques</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>SYND COPROP LES GOYAVIERS-97139-LES ABYMES</td>\n",
" <td>41245129600013</td>\n",
" <td>SYND COPROP LES GOYAVIERS</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1527</td>\n",
" <td>CC nationale de l'immobilier</td>\n",
" <td>Immobilier</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>SYND COPROP LES GOYAVIERS-97139-LES ABYMES</td>\n",
" <td>41245129600013</td>\n",
" <td>SYND COPROP LES GOYAVIERS</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97139</td>\n",
" <td>LES ABYMES</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1043</td>\n",
" <td>CC nationale des gardiens, concierges et emplo...</td>\n",
" <td>Gardiens concierges employés d'immeubles</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>SUD METAL-97118-SAINT FRANCOIS</td>\n",
" <td>38979596400029</td>\n",
" <td>SUD METAL</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97118</td>\n",
" <td>SAINT FRANCOIS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>5100</td>\n",
" <td>Statut divers</td>\n",
" <td>Statut divers</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>SUD METAL-97118-SAINT FRANCOIS</td>\n",
" <td>38979596400029</td>\n",
" <td>SUD METAL</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97118</td>\n",
" <td>SAINT FRANCOIS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>SUD METAL-97118-SAINT FRANCOIS</td>\n",
" <td>38979596400029</td>\n",
" <td>SUD METAL</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97118</td>\n",
" <td>SAINT FRANCOIS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2098</td>\n",
" <td>CC nationale du personnel des prestataires de ...</td>\n",
" <td>Prestataires de services secteur tertiaire</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>ASSOC MEDICALE COTE SS VENT DOU MANMAN-97115-S...</td>\n",
" <td>33363506800013</td>\n",
" <td>ASSOC MEDICALE COTE SS VENT DOU MANMAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>14</td>\n",
" <td>97115</td>\n",
" <td>SAINTE ROSE</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1258</td>\n",
" <td>CC des organismes d'aide ou de maintien à domi...</td>\n",
" <td>Organismes d'aide ou de maintien à domicile</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>ASSOC MEDICALE COTE SS VENT DOU MANMAN-97115-S...</td>\n",
" <td>33363506800013</td>\n",
" <td>ASSOC MEDICALE COTE SS VENT DOU MANMAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>14</td>\n",
" <td>97115</td>\n",
" <td>SAINTE ROSE</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1565</td>\n",
" <td>CC des services de soins infirmiers à domicile...</td>\n",
" <td>Soins infirmiers à domicile Guadeloupe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>DIFFUSION GENERALE QUINCAILLERIE-97122-BAIE MA...</td>\n",
" <td>31239811800017</td>\n",
" <td>DIFFUSION GENERALE QUINCAILLERIE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>39</td>\n",
" <td>97122</td>\n",
" <td>BAIE MAHAULT</td>\n",
" <td>France</td>\n",
" <td>7</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1203</td>\n",
" <td>CC départementale du commerce et des services ...</td>\n",
" <td>Commerces services Guadeloupe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>DIFFUSION GENERALE QUINCAILLERIE-97122-BAIE MA...</td>\n",
" <td>31239811800017</td>\n",
" <td>DIFFUSION GENERALE QUINCAILLERIE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>39</td>\n",
" <td>97122</td>\n",
" <td>BAIE MAHAULT</td>\n",
" <td>France</td>\n",
" <td>7</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1383</td>\n",
" <td>CC nationale des commerces de quincaillerie, f...</td>\n",
" <td>Commerce de quincaillerie interrégionale employés</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>BATIMENTS OUVRAGE METALLIQUE 2002-97118-SAINT ...</td>\n",
" <td>42483638500023</td>\n",
" <td>BATIMENTS OUVRAGE METALLIQUE 2002</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>97118</td>\n",
" <td>SAINT FRANCOIS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>0016</td>\n",
" <td>CC nationale des transports routiers et activi...</td>\n",
" <td>Transports routiers</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>BATIMENTS OUVRAGE METALLIQUE 2002-97118-SAINT ...</td>\n",
" <td>42483638500023</td>\n",
" <td>BATIMENTS OUVRAGE METALLIQUE 2002</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>97118</td>\n",
" <td>SAINT FRANCOIS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>0083</td>\n",
" <td>CC nationale des menuiseries charpentes et con...</td>\n",
" <td>Menuiseries charpentes portes planes</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>125</th>\n",
" <td>CHEZ JOAN-97110-POINTE A PITRE</td>\n",
" <td>39995434600017</td>\n",
" <td>CHEZ JOAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97110</td>\n",
" <td>POINTE A PITRE</td>\n",
" <td>France</td>\n",
" <td>62</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1284</td>\n",
" <td>CC départementale des hôtels cafés restaurants...</td>\n",
" <td>Hôtellerie Gironde</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>126</th>\n",
" <td>CHEZ JOAN-97110-POINTE A PITRE</td>\n",
" <td>39995434600017</td>\n",
" <td>CHEZ JOAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97110</td>\n",
" <td>POINTE A PITRE</td>\n",
" <td>France</td>\n",
" <td>62</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>CHEZ JOAN-97110-POINTE A PITRE</td>\n",
" <td>39995434600017</td>\n",
" <td>CHEZ JOAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97110</td>\n",
" <td>POINTE A PITRE</td>\n",
" <td>France</td>\n",
" <td>62</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1311</td>\n",
" <td>CC nationale de la restauration ferroviaire</td>\n",
" <td>Restauration ferroviaire</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td>CHEZ JOAN-97110-POINTE A PITRE</td>\n",
" <td>39995434600017</td>\n",
" <td>CHEZ JOAN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>97110</td>\n",
" <td>POINTE A PITRE</td>\n",
" <td>France</td>\n",
" <td>62</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1501</td>\n",
" <td>CC nationale de la restauration rapide</td>\n",
" <td>Restauration rapide</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>134</th>\n",
" <td>BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF</td>\n",
" <td>34379816100018</td>\n",
" <td>BERNARD MARIE JOSEPH PAGESY</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>97123</td>\n",
" <td>BAILLIF</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>135</th>\n",
" <td>BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF</td>\n",
" <td>34379816100018</td>\n",
" <td>BERNARD MARIE JOSEPH PAGESY</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>97123</td>\n",
" <td>BAILLIF</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>1203</td>\n",
" <td>CC départementale du commerce et des services ...</td>\n",
" <td>Commerces services Guadeloupe</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>136</th>\n",
" <td>BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF</td>\n",
" <td>34379816100018</td>\n",
" <td>BERNARD MARIE JOSEPH PAGESY</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>97123</td>\n",
" <td>BAILLIF</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>9862</td>\n",
" <td>Champignonnières Vienne</td>\n",
" <td>Champignonnières Vienne</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>141</th>\n",
" <td>SOC GUADELOUPEENNE ENROBES CHAUD-97122-BAIE MA...</td>\n",
" <td>40180275600015</td>\n",
" <td>SOC GUADELOUPEENNE ENROBES CHAUD</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>61</td>\n",
" <td>97122</td>\n",
" <td>BAIE MAHAULT</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle de Guadeloupe</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>05 90 83 10 34</td>\n",
" <td>2420</td>\n",
" <td>CC nationale des cadres du bâtiment du 1er jui...</td>\n",
" <td>Bâtiment cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779970</th>\n",
" <td>POLE EMPLOI-34120-PEZENAS</td>\n",
" <td>13000548115117</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>ALE PEZENAS</td>\n",
" <td>0</td>\n",
" <td>23</td>\n",
" <td>34120</td>\n",
" <td>PEZENAS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2847</td>\n",
" <td>CC nationale de Pôle Emploi</td>\n",
" <td>Pôle emploi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779971</th>\n",
" <td>POLE EMPLOI-34120-PEZENAS</td>\n",
" <td>13000548115117</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>ALE PEZENAS</td>\n",
" <td>0</td>\n",
" <td>23</td>\n",
" <td>34120</td>\n",
" <td>PEZENAS</td>\n",
" <td>France</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1420</td>\n",
" <td>CC nationale de travail du personnel des organ...</td>\n",
" <td>Institutions d'assurance chômage Unedic</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779972</th>\n",
" <td>POLE EMPLOI-34170-CASTELNAU LE LEZ</td>\n",
" <td>13000548112775</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>POLE EMPLOI DSI</td>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>34170</td>\n",
" <td>CASTELNAU LE LEZ</td>\n",
" <td>France</td>\n",
" <td>231</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2847</td>\n",
" <td>CC nationale de Pôle Emploi</td>\n",
" <td>Pôle emploi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779973</th>\n",
" <td>POLE EMPLOI-34170-CASTELNAU LE LEZ</td>\n",
" <td>13000548112775</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>POLE EMPLOI DSI</td>\n",
" <td>0</td>\n",
" <td>168</td>\n",
" <td>34170</td>\n",
" <td>CASTELNAU LE LEZ</td>\n",
" <td>France</td>\n",
" <td>231</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1420</td>\n",
" <td>CC nationale de travail du personnel des organ...</td>\n",
" <td>Institutions d'assurance chômage Unedic</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779974</th>\n",
" <td>POLE EMPLOI-34000-MONTPELLIER</td>\n",
" <td>13000548111009</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>DR OCCITANIE - IMP MONTPELLIER</td>\n",
" <td>0</td>\n",
" <td>229</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>600</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779975</th>\n",
" <td>POLE EMPLOI-34000-MONTPELLIER</td>\n",
" <td>13000548111009</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>DR OCCITANIE - IMP MONTPELLIER</td>\n",
" <td>0</td>\n",
" <td>229</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>600</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2847</td>\n",
" <td>CC nationale de Pôle Emploi</td>\n",
" <td>Pôle emploi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779976</th>\n",
" <td>POLE EMPLOI-34000-MONTPELLIER</td>\n",
" <td>13000548111009</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>DR OCCITANIE - IMP MONTPELLIER</td>\n",
" <td>0</td>\n",
" <td>229</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>600</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1420</td>\n",
" <td>CC nationale de travail du personnel des organ...</td>\n",
" <td>Institutions d'assurance chômage Unedic</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779977</th>\n",
" <td>POLE EMPLOI-34430-SAINT JEAN DE VEDAS</td>\n",
" <td>13000548111025</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>24</td>\n",
" <td>34430</td>\n",
" <td>SAINT JEAN DE VEDAS</td>\n",
" <td>France</td>\n",
" <td>4</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779978</th>\n",
" <td>POLE EMPLOI-34430-SAINT JEAN DE VEDAS</td>\n",
" <td>13000548111025</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>24</td>\n",
" <td>34430</td>\n",
" <td>SAINT JEAN DE VEDAS</td>\n",
" <td>France</td>\n",
" <td>4</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2847</td>\n",
" <td>CC nationale de Pôle Emploi</td>\n",
" <td>Pôle emploi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779979</th>\n",
" <td>POLE EMPLOI-34430-SAINT JEAN DE VEDAS</td>\n",
" <td>13000548111025</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>24</td>\n",
" <td>34430</td>\n",
" <td>SAINT JEAN DE VEDAS</td>\n",
" <td>France</td>\n",
" <td>4</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1420</td>\n",
" <td>CC nationale de travail du personnel des organ...</td>\n",
" <td>Institutions d'assurance chômage Unedic</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779980</th>\n",
" <td>POLE EMPLOI-34800-CLERMONT L'HERAULT</td>\n",
" <td>13000548111876</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>43</td>\n",
" <td>34800</td>\n",
" <td>CLERMONT L'HERAULT</td>\n",
" <td>France</td>\n",
" <td>16</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779981</th>\n",
" <td>POLE EMPLOI-34800-CLERMONT L'HERAULT</td>\n",
" <td>13000548111876</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>43</td>\n",
" <td>34800</td>\n",
" <td>CLERMONT L'HERAULT</td>\n",
" <td>France</td>\n",
" <td>16</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2847</td>\n",
" <td>CC nationale de Pôle Emploi</td>\n",
" <td>Pôle emploi</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779982</th>\n",
" <td>POLE EMPLOI-34800-CLERMONT L'HERAULT</td>\n",
" <td>13000548111876</td>\n",
" <td>POLE EMPLOI</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>43</td>\n",
" <td>34800</td>\n",
" <td>CLERMONT L'HERAULT</td>\n",
" <td>France</td>\n",
" <td>16</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1420</td>\n",
" <td>CC nationale de travail du personnel des organ...</td>\n",
" <td>Institutions d'assurance chômage Unedic</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779990</th>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY</td>\n",
" <td>39876221100363</td>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE</td>\n",
" <td>OUEST LANGUEDOC ROUSSILLON</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>34630</td>\n",
" <td>SAINT THIBERY</td>\n",
" <td>France</td>\n",
" <td>28</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°1 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.87.42</td>\n",
" <td>9999</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>Sans Convention Collective</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779991</th>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY</td>\n",
" <td>39876221100363</td>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE</td>\n",
" <td>OUEST LANGUEDOC ROUSSILLON</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>34630</td>\n",
" <td>SAINT THIBERY</td>\n",
" <td>France</td>\n",
" <td>28</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°1 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.87.42</td>\n",
" <td>2614</td>\n",
" <td>CC nationale des employés, techniciens et agen...</td>\n",
" <td>Travaux publics ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779992</th>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY</td>\n",
" <td>39876221100363</td>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE</td>\n",
" <td>OUEST LANGUEDOC ROUSSILLON</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>34630</td>\n",
" <td>SAINT THIBERY</td>\n",
" <td>France</td>\n",
" <td>28</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°1 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.87.42</td>\n",
" <td>2409</td>\n",
" <td>CC nationale des cadres des travaux publics du...</td>\n",
" <td>Travaux publics cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779993</th>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY</td>\n",
" <td>39876221100363</td>\n",
" <td>EIFFAGE ROUTE MEDITERRANEE</td>\n",
" <td>OUEST LANGUEDOC ROUSSILLON</td>\n",
" <td>0</td>\n",
" <td>179</td>\n",
" <td>34630</td>\n",
" <td>SAINT THIBERY</td>\n",
" <td>France</td>\n",
" <td>28</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°1 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.87.42</td>\n",
" <td>1702</td>\n",
" <td>CC nationale des ouvriers de travaux publics</td>\n",
" <td>Travaux publics ouvriers</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779996</th>\n",
" <td>MULTITEC-34470-PEROLS</td>\n",
" <td>44075608800082</td>\n",
" <td>MULTITEC</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>34470</td>\n",
" <td>PEROLS</td>\n",
" <td>France</td>\n",
" <td>195</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2420</td>\n",
" <td>CC nationale des cadres du bâtiment du 1er jui...</td>\n",
" <td>Bâtiment cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779997</th>\n",
" <td>MULTITEC-34470-PEROLS</td>\n",
" <td>44075608800082</td>\n",
" <td>MULTITEC</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>34470</td>\n",
" <td>PEROLS</td>\n",
" <td>France</td>\n",
" <td>195</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>2609</td>\n",
" <td>CC nationale des employés, techniciens et agen...</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779998</th>\n",
" <td>MULTITEC-34470-PEROLS</td>\n",
" <td>44075608800082</td>\n",
" <td>MULTITEC</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>NaN</td>\n",
" <td>34470</td>\n",
" <td>PEROLS</td>\n",
" <td>France</td>\n",
" <td>195</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°2 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.34</td>\n",
" <td>1597</td>\n",
" <td>CC nationale concernant les ouvriers employés ...</td>\n",
" <td>Bâtiment ouvriers plus de 10 Salariés</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1779999</th>\n",
" <td>SA FRANCOIS FONDEVILLE-34000-MONTPELLIER</td>\n",
" <td>38129346300067</td>\n",
" <td>SA FRANCOIS FONDEVILLE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>127</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>91</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°3 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.69</td>\n",
" <td>2420</td>\n",
" <td>CC nationale des cadres du bâtiment du 1er jui...</td>\n",
" <td>Bâtiment cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780000</th>\n",
" <td>SA FRANCOIS FONDEVILLE-34000-MONTPELLIER</td>\n",
" <td>38129346300067</td>\n",
" <td>SA FRANCOIS FONDEVILLE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>127</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>91</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°3 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.69</td>\n",
" <td>2609</td>\n",
" <td>CC nationale des employés, techniciens et agen...</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780001</th>\n",
" <td>SA FRANCOIS FONDEVILLE-34000-MONTPELLIER</td>\n",
" <td>38129346300067</td>\n",
" <td>SA FRANCOIS FONDEVILLE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>127</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>91</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°3 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.69</td>\n",
" <td>2267</td>\n",
" <td>CC des ouvriers du bâtiment de la région Langu...</td>\n",
" <td>Bâtiment ouvriers Languedoc Roussillon</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780002</th>\n",
" <td>SA FRANCOIS FONDEVILLE-34000-MONTPELLIER</td>\n",
" <td>38129346300067</td>\n",
" <td>SA FRANCOIS FONDEVILLE</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>127</td>\n",
" <td>34000</td>\n",
" <td>MONTPELLIER</td>\n",
" <td>France</td>\n",
" <td>91</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n°3 de l'Hérault</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>04.67.22.88.69</td>\n",
" <td>1597</td>\n",
" <td>CC nationale concernant les ouvriers employés ...</td>\n",
" <td>Bâtiment ouvriers plus de 10 Salariés</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780044</th>\n",
" <td>EBN-44100-NANTES</td>\n",
" <td>81786117200010</td>\n",
" <td>EBN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>44100</td>\n",
" <td>NANTES</td>\n",
" <td>France</td>\n",
" <td>6</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n° 2 de Loire-Atlantique</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.40.12.35.05</td>\n",
" <td>1390</td>\n",
" <td>Bâtiment ouvriers Loire Atlantique</td>\n",
" <td>Bâtiment ouvriers Loire Atlantique</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780045</th>\n",
" <td>EBN-44100-NANTES</td>\n",
" <td>81786117200010</td>\n",
" <td>EBN</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>44100</td>\n",
" <td>NANTES</td>\n",
" <td>France</td>\n",
" <td>6</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n° 2 de Loire-Atlantique</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.40.12.35.05</td>\n",
" <td>0255</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>Bâtiment ETAM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780069</th>\n",
" <td>MOVE'N SEE-29200-BREST</td>\n",
" <td>53129924600029</td>\n",
" <td>MOVE'N SEE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>29200</td>\n",
" <td>BREST</td>\n",
" <td>France</td>\n",
" <td>38</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle Nord Finistère</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.98.41.82.55</td>\n",
" <td>0860</td>\n",
" <td>CC départementale de la métallurgie et des ind...</td>\n",
" <td>Métallurgie Finistère</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780070</th>\n",
" <td>MOVE'N SEE-29200-BREST</td>\n",
" <td>53129924600029</td>\n",
" <td>MOVE'N SEE</td>\n",
" <td>NaN</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>29200</td>\n",
" <td>BREST</td>\n",
" <td>France</td>\n",
" <td>38</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle Nord Finistère</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.98.41.82.55</td>\n",
" <td>0650</td>\n",
" <td>CC nationale des ingénieurs et cadres de la mé...</td>\n",
" <td>Métallurgie cadres</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780099</th>\n",
" <td>ATELIER O-44330-LE PALLET</td>\n",
" <td>79105598100025</td>\n",
" <td>ATELIER O</td>\n",
" <td>CUISINE O</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>44330</td>\n",
" <td>LE PALLET</td>\n",
" <td>France</td>\n",
" <td>122</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n° 2 de Loire-Atlantique</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.40.12.35.05</td>\n",
" <td>1411</td>\n",
" <td>CC nationale de la fabrication de l'ameublement</td>\n",
" <td>Fabrication de l'ameublement</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1780100</th>\n",
" <td>ATELIER O-44330-LE PALLET</td>\n",
" <td>79105598100025</td>\n",
" <td>ATELIER O</td>\n",
" <td>CUISINE O</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>44330</td>\n",
" <td>LE PALLET</td>\n",
" <td>France</td>\n",
" <td>122</td>\n",
" <td>...</td>\n",
" <td>Unité de contrôle n° 2 de Loire-Atlantique</td>\n",
" <td>[email protected]</td>\n",
" <td>https://wikit.ged.travail.gouv.fr/sites/wikitc...</td>\n",
" <td>02.40.12.35.05</td>\n",
" <td>0160</td>\n",
" <td>Ameublement</td>\n",
" <td>Ameublement</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>338774 rows × 29 columns</p>\n",
"</div>"
],
"text/plain": [
" Nom de l'établissement SIRET \\\n",
"0 HPK WESER-BREMEN ETR00000010002 \n",
"1 HPK WESER-BREMEN ETR00000010002 \n",
"2 HPK WESER-BREMEN ETR00000010002 \n",
"6 AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES 31445177400017 \n",
"7 AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES 31445177400017 \n",
"8 AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES 31445177400017 \n",
"9 AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES 31445177400017 \n",
"10 AEP ECOLE NOTRE DAME DE GRACE-97139-LES ABYMES 31445177400017 \n",
"33 BRED BANQUE POPULAIRE-97139-LES ABYMES 55209179502191 \n",
"34 BRED BANQUE POPULAIRE-97139-LES ABYMES 55209179502191 \n",
"35 BRED BANQUE POPULAIRE-97139-LES ABYMES 55209179502191 \n",
"39 SYND COPROP LES GOYAVIERS-97139-LES ABYMES 41245129600013 \n",
"40 SYND COPROP LES GOYAVIERS-97139-LES ABYMES 41245129600013 \n",
"48 SUD METAL-97118-SAINT FRANCOIS 38979596400029 \n",
"49 SUD METAL-97118-SAINT FRANCOIS 38979596400029 \n",
"50 SUD METAL-97118-SAINT FRANCOIS 38979596400029 \n",
"72 ASSOC MEDICALE COTE SS VENT DOU MANMAN-97115-S... 33363506800013 \n",
"73 ASSOC MEDICALE COTE SS VENT DOU MANMAN-97115-S... 33363506800013 \n",
"82 DIFFUSION GENERALE QUINCAILLERIE-97122-BAIE MA... 31239811800017 \n",
"83 DIFFUSION GENERALE QUINCAILLERIE-97122-BAIE MA... 31239811800017 \n",
"97 BATIMENTS OUVRAGE METALLIQUE 2002-97118-SAINT ... 42483638500023 \n",
"98 BATIMENTS OUVRAGE METALLIQUE 2002-97118-SAINT ... 42483638500023 \n",
"125 CHEZ JOAN-97110-POINTE A PITRE 39995434600017 \n",
"126 CHEZ JOAN-97110-POINTE A PITRE 39995434600017 \n",
"127 CHEZ JOAN-97110-POINTE A PITRE 39995434600017 \n",
"128 CHEZ JOAN-97110-POINTE A PITRE 39995434600017 \n",
"134 BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF 34379816100018 \n",
"135 BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF 34379816100018 \n",
"136 BERNARD MARIE JOSEPH PAGESY-97123-BAILLIF 34379816100018 \n",
"141 SOC GUADELOUPEENNE ENROBES CHAUD-97122-BAIE MA... 40180275600015 \n",
"... ... ... \n",
"1779970 POLE EMPLOI-34120-PEZENAS 13000548115117 \n",
"1779971 POLE EMPLOI-34120-PEZENAS 13000548115117 \n",
"1779972 POLE EMPLOI-34170-CASTELNAU LE LEZ 13000548112775 \n",
"1779973 POLE EMPLOI-34170-CASTELNAU LE LEZ 13000548112775 \n",
"1779974 POLE EMPLOI-34000-MONTPELLIER 13000548111009 \n",
"1779975 POLE EMPLOI-34000-MONTPELLIER 13000548111009 \n",
"1779976 POLE EMPLOI-34000-MONTPELLIER 13000548111009 \n",
"1779977 POLE EMPLOI-34430-SAINT JEAN DE VEDAS 13000548111025 \n",
"1779978 POLE EMPLOI-34430-SAINT JEAN DE VEDAS 13000548111025 \n",
"1779979 POLE EMPLOI-34430-SAINT JEAN DE VEDAS 13000548111025 \n",
"1779980 POLE EMPLOI-34800-CLERMONT L'HERAULT 13000548111876 \n",
"1779981 POLE EMPLOI-34800-CLERMONT L'HERAULT 13000548111876 \n",
"1779982 POLE EMPLOI-34800-CLERMONT L'HERAULT 13000548111876 \n",
"1779990 EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY 39876221100363 \n",
"1779991 EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY 39876221100363 \n",
"1779992 EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY 39876221100363 \n",
"1779993 EIFFAGE ROUTE MEDITERRANEE-34630-SAINT THIBERY 39876221100363 \n",
"1779996 MULTITEC-34470-PEROLS 44075608800082 \n",
"1779997 MULTITEC-34470-PEROLS 44075608800082 \n",
"1779998 MULTITEC-34470-PEROLS 44075608800082 \n",
"1779999 SA FRANCOIS FONDEVILLE-34000-MONTPELLIER 38129346300067 \n",
"1780000 SA FRANCOIS FONDEVILLE-34000-MONTPELLIER 38129346300067 \n",
"1780001 SA FRANCOIS FONDEVILLE-34000-MONTPELLIER 38129346300067 \n",
"1780002 SA FRANCOIS FONDEVILLE-34000-MONTPELLIER 38129346300067 \n",
"1780044 EBN-44100-NANTES 81786117200010 \n",
"1780045 EBN-44100-NANTES 81786117200010 \n",
"1780069 MOVE'N SEE-29200-BREST 53129924600029 \n",
"1780070 MOVE'N SEE-29200-BREST 53129924600029 \n",
"1780099 ATELIER O-44330-LE PALLET 79105598100025 \n",
"1780100 ATELIER O-44330-LE PALLET 79105598100025 \n",
"\n",
" Raison Sociale \\\n",
"0 HPK WESER \n",
"1 HPK WESER \n",
"2 HPK WESER \n",
"6 AEP ECOLE NOTRE DAME DE GRACE \n",
"7 AEP ECOLE NOTRE DAME DE GRACE \n",
"8 AEP ECOLE NOTRE DAME DE GRACE \n",
"9 AEP ECOLE NOTRE DAME DE GRACE \n",
"10 AEP ECOLE NOTRE DAME DE GRACE \n",
"33 BRED BANQUE POPULAIRE \n",
"34 BRED BANQUE POPULAIRE \n",
"35 BRED BANQUE POPULAIRE \n",
"39 SYND COPROP LES GOYAVIERS \n",
"40 SYND COPROP LES GOYAVIERS \n",
"48 SUD METAL \n",
"49 SUD METAL \n",
"50 SUD METAL \n",
"72 ASSOC MEDICALE COTE SS VENT DOU MANMAN \n",
"73 ASSOC MEDICALE COTE SS VENT DOU MANMAN \n",
"82 DIFFUSION GENERALE QUINCAILLERIE \n",
"83 DIFFUSION GENERALE QUINCAILLERIE \n",
"97 BATIMENTS OUVRAGE METALLIQUE 2002 \n",
"98 BATIMENTS OUVRAGE METALLIQUE 2002 \n",
"125 CHEZ JOAN \n",
"126 CHEZ JOAN \n",
"127 CHEZ JOAN \n",
"128 CHEZ JOAN \n",
"134 BERNARD MARIE JOSEPH PAGESY \n",
"135 BERNARD MARIE JOSEPH PAGESY \n",
"136 BERNARD MARIE JOSEPH PAGESY \n",
"141 SOC GUADELOUPEENNE ENROBES CHAUD \n",
"... ... \n",
"1779970 POLE EMPLOI \n",
"1779971 POLE EMPLOI \n",
"1779972 POLE EMPLOI \n",
"1779973 POLE EMPLOI \n",
"1779974 POLE EMPLOI \n",
"1779975 POLE EMPLOI \n",
"1779976 POLE EMPLOI \n",
"1779977 POLE EMPLOI \n",
"1779978 POLE EMPLOI \n",
"1779979 POLE EMPLOI \n",
"1779980 POLE EMPLOI \n",
"1779981 POLE EMPLOI \n",
"1779982 POLE EMPLOI \n",
"1779990 EIFFAGE ROUTE MEDITERRANEE \n",
"1779991 EIFFAGE ROUTE MEDITERRANEE \n",
"1779992 EIFFAGE ROUTE MEDITERRANEE \n",
"1779993 EIFFAGE ROUTE MEDITERRANEE \n",
"1779996 MULTITEC \n",
"1779997 MULTITEC \n",
"1779998 MULTITEC \n",
"1779999 SA FRANCOIS FONDEVILLE \n",
"1780000 SA FRANCOIS FONDEVILLE \n",
"1780001 SA FRANCOIS FONDEVILLE \n",
"1780002 SA FRANCOIS FONDEVILLE \n",
"1780044 EBN \n",
"1780045 EBN \n",
"1780069 MOVE'N SEE \n",
"1780070 MOVE'N SEE \n",
"1780099 ATELIER O \n",
"1780100 ATELIER O \n",
"\n",
" Enseigne Siège Dernier effectif connu \\\n",
"0 NaN 0 0 \n",
"1 NaN 0 0 \n",
"2 NaN 0 0 \n",
"6 NaN 1 11 \n",
"7 NaN 1 11 \n",
"8 NaN 1 11 \n",
"9 NaN 1 11 \n",
"10 NaN 1 11 \n",
"33 NaN 0 6 \n",
"34 NaN 0 6 \n",
"35 NaN 0 6 \n",
"39 NaN 1 2 \n",
"40 NaN 1 2 \n",
"48 NaN 1 2 \n",
"49 NaN 1 2 \n",
"50 NaN 1 2 \n",
"72 NaN 1 14 \n",
"73 NaN 1 14 \n",
"82 NaN 1 39 \n",
"83 NaN 1 39 \n",
"97 NaN 1 4 \n",
"98 NaN 1 4 \n",
"125 NaN 1 2 \n",
"126 NaN 1 2 \n",
"127 NaN 1 2 \n",
"128 NaN 1 2 \n",
"134 NaN 1 7 \n",
"135 NaN 1 7 \n",
"136 NaN 1 7 \n",
"141 NaN 1 61 \n",
"... ... ... ... \n",
"1779970 ALE PEZENAS 0 23 \n",
"1779971 ALE PEZENAS 0 23 \n",
"1779972 POLE EMPLOI DSI 0 168 \n",
"1779973 POLE EMPLOI DSI 0 168 \n",
"1779974 DR OCCITANIE - IMP MONTPELLIER 0 229 \n",
"1779975 DR OCCITANIE - IMP MONTPELLIER 0 229 \n",
"1779976 DR OCCITANIE - IMP MONTPELLIER 0 229 \n",
"1779977 NaN 0 24 \n",
"1779978 NaN 0 24 \n",
"1779979 NaN 0 24 \n",
"1779980 NaN 0 43 \n",
"1779981 NaN 0 43 \n",
"1779982 NaN 0 43 \n",
"1779990 OUEST LANGUEDOC ROUSSILLON 0 179 \n",
"1779991 OUEST LANGUEDOC ROUSSILLON 0 179 \n",
"1779992 OUEST LANGUEDOC ROUSSILLON 0 179 \n",
"1779993 OUEST LANGUEDOC ROUSSILLON 0 179 \n",
"1779996 NaN 1 NaN \n",
"1779997 NaN 1 NaN \n",
"1779998 NaN 1 NaN \n",
"1779999 NaN 0 127 \n",
"1780000 NaN 0 127 \n",
"1780001 NaN 0 127 \n",
"1780002 NaN 0 127 \n",
"1780044 NaN 1 1 \n",
"1780045 NaN 1 1 \n",
"1780069 NaN 1 5 \n",
"1780070 NaN 1 5 \n",
"1780099 CUISINE O 1 2 \n",
"1780100 CUISINE O 1 2 \n",
"\n",
" Code postal Commune Pays Numéro dans la voie ... \\\n",
"0 NaN NaN Allemagne 8 ... \n",
"1 NaN NaN Allemagne 8 ... \n",
"2 NaN NaN Allemagne 8 ... \n",
"6 97139 LES ABYMES France NaN ... \n",
"7 97139 LES ABYMES France NaN ... \n",
"8 97139 LES ABYMES France NaN ... \n",
"9 97139 LES ABYMES France NaN ... \n",
"10 97139 LES ABYMES France NaN ... \n",
"33 97139 LES ABYMES France NaN ... \n",
"34 97139 LES ABYMES France NaN ... \n",
"35 97139 LES ABYMES France NaN ... \n",
"39 97139 LES ABYMES France NaN ... \n",
"40 97139 LES ABYMES France NaN ... \n",
"48 97118 SAINT FRANCOIS France NaN ... \n",
"49 97118 SAINT FRANCOIS France NaN ... \n",
"50 97118 SAINT FRANCOIS France NaN ... \n",
"72 97115 SAINTE ROSE France NaN ... \n",
"73 97115 SAINTE ROSE France NaN ... \n",
"82 97122 BAIE MAHAULT France 7 ... \n",
"83 97122 BAIE MAHAULT France 7 ... \n",
"97 97118 SAINT FRANCOIS France NaN ... \n",
"98 97118 SAINT FRANCOIS France NaN ... \n",
"125 97110 POINTE A PITRE France 62 ... \n",
"126 97110 POINTE A PITRE France 62 ... \n",
"127 97110 POINTE A PITRE France 62 ... \n",
"128 97110 POINTE A PITRE France 62 ... \n",
"134 97123 BAILLIF France NaN ... \n",
"135 97123 BAILLIF France NaN ... \n",
"136 97123 BAILLIF France NaN ... \n",
"141 97122 BAIE MAHAULT France NaN ... \n",
"... ... ... ... ... ... \n",
"1779970 34120 PEZENAS France NaN ... \n",
"1779971 34120 PEZENAS France NaN ... \n",
"1779972 34170 CASTELNAU LE LEZ France 231 ... \n",
"1779973 34170 CASTELNAU LE LEZ France 231 ... \n",
"1779974 34000 MONTPELLIER France 600 ... \n",
"1779975 34000 MONTPELLIER France 600 ... \n",
"1779976 34000 MONTPELLIER France 600 ... \n",
"1779977 34430 SAINT JEAN DE VEDAS France 4 ... \n",
"1779978 34430 SAINT JEAN DE VEDAS France 4 ... \n",
"1779979 34430 SAINT JEAN DE VEDAS France 4 ... \n",
"1779980 34800 CLERMONT L'HERAULT France 16 ... \n",
"1779981 34800 CLERMONT L'HERAULT France 16 ... \n",
"1779982 34800 CLERMONT L'HERAULT France 16 ... \n",
"1779990 34630 SAINT THIBERY France 28 ... \n",
"1779991 34630 SAINT THIBERY France 28 ... \n",
"1779992 34630 SAINT THIBERY France 28 ... \n",
"1779993 34630 SAINT THIBERY France 28 ... \n",
"1779996 34470 PEROLS France 195 ... \n",
"1779997 34470 PEROLS France 195 ... \n",
"1779998 34470 PEROLS France 195 ... \n",
"1779999 34000 MONTPELLIER France 91 ... \n",
"1780000 34000 MONTPELLIER France 91 ... \n",
"1780001 34000 MONTPELLIER France 91 ... \n",
"1780002 34000 MONTPELLIER France 91 ... \n",
"1780044 44100 NANTES France 6 ... \n",
"1780045 44100 NANTES France 6 ... \n",
"1780069 29200 BREST France 38 ... \n",
"1780070 29200 BREST France 38 ... \n",
"1780099 44330 LE PALLET France 122 ... \n",
"1780100 44330 LE PALLET France 122 ... \n",
"\n",
" Equipe \\\n",
"0 2ème unité de contrôle d'Eure et Loir \n",
"1 2ème unité de contrôle d'Eure et Loir \n",
"2 2ème unité de contrôle d'Eure et Loir \n",
"6 Unité de contrôle de Guadeloupe \n",
"7 Unité de contrôle de Guadeloupe \n",
"8 Unité de contrôle de Guadeloupe \n",
"9 Unité de contrôle de Guadeloupe \n",
"10 Unité de contrôle de Guadeloupe \n",
"33 Unité de contrôle de Guadeloupe \n",
"34 Unité de contrôle de Guadeloupe \n",
"35 Unité de contrôle de Guadeloupe \n",
"39 Unité de contrôle de Guadeloupe \n",
"40 Unité de contrôle de Guadeloupe \n",
"48 Unité de contrôle de Guadeloupe \n",
"49 Unité de contrôle de Guadeloupe \n",
"50 Unité de contrôle de Guadeloupe \n",
"72 Unité de contrôle de Guadeloupe \n",
"73 Unité de contrôle de Guadeloupe \n",
"82 Unité de contrôle de Guadeloupe \n",
"83 Unité de contrôle de Guadeloupe \n",
"97 Unité de contrôle de Guadeloupe \n",
"98 Unité de contrôle de Guadeloupe \n",
"125 Unité de contrôle de Guadeloupe \n",
"126 Unité de contrôle de Guadeloupe \n",
"127 Unité de contrôle de Guadeloupe \n",
"128 Unité de contrôle de Guadeloupe \n",
"134 Unité de contrôle de Guadeloupe \n",
"135 Unité de contrôle de Guadeloupe \n",
"136 Unité de contrôle de Guadeloupe \n",
"141 Unité de contrôle de Guadeloupe \n",
"... ... \n",
"1779970 Unité de contrôle n°2 de l'Hérault \n",
"1779971 Unité de contrôle n°2 de l'Hérault \n",
"1779972 Unité de contrôle n°2 de l'Hérault \n",
"1779973 Unité de contrôle n°2 de l'Hérault \n",
"1779974 Unité de contrôle n°2 de l'Hérault \n",
"1779975 Unité de contrôle n°2 de l'Hérault \n",
"1779976 Unité de contrôle n°2 de l'Hérault \n",
"1779977 Unité de contrôle n°2 de l'Hérault \n",
"1779978 Unité de contrôle n°2 de l'Hérault \n",
"1779979 Unité de contrôle n°2 de l'Hérault \n",
"1779980 Unité de contrôle n°2 de l'Hérault \n",
"1779981 Unité de contrôle n°2 de l'Hérault \n",
"1779982 Unité de contrôle n°2 de l'Hérault \n",
"1779990 Unité de contrôle n°1 de l'Hérault \n",
"1779991 Unité de contrôle n°1 de l'Hérault \n",
"1779992 Unité de contrôle n°1 de l'Hérault \n",
"1779993 Unité de contrôle n°1 de l'Hérault \n",
"1779996 Unité de contrôle n°2 de l'Hérault \n",
"1779997 Unité de contrôle n°2 de l'Hérault \n",
"1779998 Unité de contrôle n°2 de l'Hérault \n",
"1779999 Unité de contrôle n°3 de l'Hérault \n",
"1780000 Unité de contrôle n°3 de l'Hérault \n",
"1780001 Unité de contrôle n°3 de l'Hérault \n",
"1780002 Unité de contrôle n°3 de l'Hérault \n",
"1780044 Unité de contrôle n° 2 de Loire-Atlantique \n",
"1780045 Unité de contrôle n° 2 de Loire-Atlantique \n",
"1780069 Unité de contrôle Nord Finistère \n",
"1780070 Unité de contrôle Nord Finistère \n",
"1780099 Unité de contrôle n° 2 de Loire-Atlantique \n",
"1780100 Unité de contrôle n° 2 de Loire-Atlantique \n",
"\n",
" Email UC \\\n",
"0 [email protected] \n",
"1 [email protected] \n",
"2 [email protected] \n",
"6 [email protected] \n",
"7 [email protected] \n",
"8 [email protected] \n",
"9 [email protected] \n",
"10 [email protected] \n",
"33 [email protected] \n",
"34 [email protected] \n",
"35 [email protected] \n",
"39 [email protected] \n",
"40 [email protected] \n",
"48 [email protected] \n",
"49 [email protected] \n",
"50 [email protected] \n",
"72 [email protected] \n",
"73 [email protected] \n",
"82 [email protected] \n",
"83 [email protected] \n",
"97 [email protected] \n",
"98 [email protected] \n",
"125 [email protected] \n",
"126 [email protected] \n",
"127 [email protected] \n",
"128 [email protected] \n",
"134 [email protected] \n",
"135 [email protected] \n",
"136 [email protected] \n",
"141 [email protected] \n",
"... ... \n",
"1779970 [email protected] \n",
"1779971 [email protected] \n",
"1779972 [email protected] \n",
"1779973 [email protected] \n",
"1779974 [email protected] \n",
"1779975 [email protected] \n",
"1779976 [email protected] \n",
"1779977 [email protected] \n",
"1779978 [email protected] \n",
"1779979 [email protected] \n",
"1779980 [email protected] \n",
"1779981 [email protected] \n",
"1779982 [email protected] \n",
"1779990 [email protected] \n",
"1779991 [email protected] \n",
"1779992 [email protected] \n",
"1779993 [email protected] \n",
"1779996 [email protected] \n",
"1779997 [email protected] \n",
"1779998 [email protected] \n",
"1779999 [email protected] \n",
"1780000 [email protected] \n",
"1780001 [email protected] \n",
"1780002 [email protected] \n",
"1780044 [email protected] \n",
"1780045 [email protected] \n",
"1780069 [email protected] \n",
"1780070 [email protected] \n",
"1780099 [email protected] \n",
"1780100 [email protected] \n",
"\n",
" URL SP de l'équipe \\\n",
"0 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"2 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"6 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"7 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"8 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"9 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"10 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"33 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"34 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"35 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"39 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"40 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"48 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"49 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"50 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"72 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"73 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"82 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"83 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"97 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"98 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"125 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"126 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"127 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"128 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"134 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"135 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"136 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"141 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"... ... \n",
"1779970 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779971 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779972 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779973 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779974 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779975 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779976 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779977 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779978 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779979 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779980 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779981 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779982 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779990 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779991 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779992 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779993 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779996 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779997 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779998 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1779999 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780000 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780001 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780002 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780044 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780045 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780069 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780070 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780099 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"1780100 https://wikit.ged.travail.gouv.fr/sites/wikitc... \n",
"\n",
" Standard UC IDCC \\\n",
"0 02 37 91 23 20/23 33 0255 \n",
"1 02 37 91 23 20/23 33 0203 \n",
"2 02 37 91 23 20/23 33 0072 \n",
"6 05 90 83 10 34 9999 \n",
"7 05 90 83 10 34 2281 \n",
"8 05 90 83 10 34 0713 \n",
"9 05 90 83 10 34 2409 \n",
"10 05 90 83 10 34 2408 \n",
"33 05 90 83 10 34 5560 \n",
"34 05 90 83 10 34 9999 \n",
"35 05 90 83 10 34 2120 \n",
"39 05 90 83 10 34 1527 \n",
"40 05 90 83 10 34 1043 \n",
"48 05 90 83 10 34 5100 \n",
"49 05 90 83 10 34 9999 \n",
"50 05 90 83 10 34 2098 \n",
"72 05 90 83 10 34 1258 \n",
"73 05 90 83 10 34 1565 \n",
"82 05 90 83 10 34 1203 \n",
"83 05 90 83 10 34 1383 \n",
"97 05 90 83 10 34 0016 \n",
"98 05 90 83 10 34 0083 \n",
"125 05 90 83 10 34 1284 \n",
"126 05 90 83 10 34 9999 \n",
"127 05 90 83 10 34 1311 \n",
"128 05 90 83 10 34 1501 \n",
"134 05 90 83 10 34 9999 \n",
"135 05 90 83 10 34 1203 \n",
"136 05 90 83 10 34 9862 \n",
"141 05 90 83 10 34 2420 \n",
"... ... ... \n",
"1779970 04.67.22.88.34 2847 \n",
"1779971 04.67.22.88.34 1420 \n",
"1779972 04.67.22.88.34 2847 \n",
"1779973 04.67.22.88.34 1420 \n",
"1779974 04.67.22.88.34 9999 \n",
"1779975 04.67.22.88.34 2847 \n",
"1779976 04.67.22.88.34 1420 \n",
"1779977 04.67.22.88.34 9999 \n",
"1779978 04.67.22.88.34 2847 \n",
"1779979 04.67.22.88.34 1420 \n",
"1779980 04.67.22.88.34 9999 \n",
"1779981 04.67.22.88.34 2847 \n",
"1779982 04.67.22.88.34 1420 \n",
"1779990 04.67.22.87.42 9999 \n",
"1779991 04.67.22.87.42 2614 \n",
"1779992 04.67.22.87.42 2409 \n",
"1779993 04.67.22.87.42 1702 \n",
"1779996 04.67.22.88.34 2420 \n",
"1779997 04.67.22.88.34 2609 \n",
"1779998 04.67.22.88.34 1597 \n",
"1779999 04.67.22.88.69 2420 \n",
"1780000 04.67.22.88.69 2609 \n",
"1780001 04.67.22.88.69 2267 \n",
"1780002 04.67.22.88.69 1597 \n",
"1780044 02.40.12.35.05 1390 \n",
"1780045 02.40.12.35.05 0255 \n",
"1780069 02.98.41.82.55 0860 \n",
"1780070 02.98.41.82.55 0650 \n",
"1780099 02.40.12.35.05 1411 \n",
"1780100 02.40.12.35.05 0160 \n",
"\n",
" Convention \\\n",
"0 Bâtiment ETAM \n",
"1 Bâtiment Ingénieurs cadres \n",
"2 Bâtiment ouvriers Eure et Loir \n",
"6 Sans Convention Collective \n",
"7 CC des chefs d'établissement directeurs d'écol... \n",
"8 CC des surveillants personnels administratifs ... \n",
"9 CC nationale des cadres des travaux publics du... \n",
"10 CC de travail des personnels des services admi... \n",
"33 Banque Populaire \n",
"34 Sans Convention Collective \n",
"35 CC de la banque \n",
"39 CC nationale de l'immobilier \n",
"40 CC nationale des gardiens, concierges et emplo... \n",
"48 Statut divers \n",
"49 Sans Convention Collective \n",
"50 CC nationale du personnel des prestataires de ... \n",
"72 CC des organismes d'aide ou de maintien à domi... \n",
"73 CC des services de soins infirmiers à domicile... \n",
"82 CC départementale du commerce et des services ... \n",
"83 CC nationale des commerces de quincaillerie, f... \n",
"97 CC nationale des transports routiers et activi... \n",
"98 CC nationale des menuiseries charpentes et con... \n",
"125 CC départementale des hôtels cafés restaurants... \n",
"126 Sans Convention Collective \n",
"127 CC nationale de la restauration ferroviaire \n",
"128 CC nationale de la restauration rapide \n",
"134 Sans Convention Collective \n",
"135 CC départementale du commerce et des services ... \n",
"136 Champignonnières Vienne \n",
"141 CC nationale des cadres du bâtiment du 1er jui... \n",
"... ... \n",
"1779970 CC nationale de Pôle Emploi \n",
"1779971 CC nationale de travail du personnel des organ... \n",
"1779972 CC nationale de Pôle Emploi \n",
"1779973 CC nationale de travail du personnel des organ... \n",
"1779974 Sans Convention Collective \n",
"1779975 CC nationale de Pôle Emploi \n",
"1779976 CC nationale de travail du personnel des organ... \n",
"1779977 Sans Convention Collective \n",
"1779978 CC nationale de Pôle Emploi \n",
"1779979 CC nationale de travail du personnel des organ... \n",
"1779980 Sans Convention Collective \n",
"1779981 CC nationale de Pôle Emploi \n",
"1779982 CC nationale de travail du personnel des organ... \n",
"1779990 Sans Convention Collective \n",
"1779991 CC nationale des employés, techniciens et agen... \n",
"1779992 CC nationale des cadres des travaux publics du... \n",
"1779993 CC nationale des ouvriers de travaux publics \n",
"1779996 CC nationale des cadres du bâtiment du 1er jui... \n",
"1779997 CC nationale des employés, techniciens et agen... \n",
"1779998 CC nationale concernant les ouvriers employés ... \n",
"1779999 CC nationale des cadres du bâtiment du 1er jui... \n",
"1780000 CC nationale des employés, techniciens et agen... \n",
"1780001 CC des ouvriers du bâtiment de la région Langu... \n",
"1780002 CC nationale concernant les ouvriers employés ... \n",
"1780044 Bâtiment ouvriers Loire Atlantique \n",
"1780045 Bâtiment ETAM \n",
"1780069 CC départementale de la métallurgie et des ind... \n",
"1780070 CC nationale des ingénieurs et cadres de la mé... \n",
"1780099 CC nationale de la fabrication de l'ameublement \n",
"1780100 Ameublement \n",
"\n",
" Intitulé abrégé Convention \\\n",
"0 Bâtiment ETAM \n",
"1 Bâtiment Ingénieurs cadres \n",
"2 Bâtiment ouvriers Eure et Loir \n",
"6 Sans Convention Collective \n",
"7 Enseignement primaire catholique directeurs \n",
"8 Enseignement Loire St Etienne \n",
"9 Travaux publics cadres \n",
"10 Ets enseignement privé \n",
"33 Banque Populaire \n",
"34 Sans Convention Collective \n",
"35 Banques \n",
"39 Immobilier \n",
"40 Gardiens concierges employés d'immeubles \n",
"48 Statut divers \n",
"49 Sans Convention Collective \n",
"50 Prestataires de services secteur tertiaire \n",
"72 Organismes d'aide ou de maintien à domicile \n",
"73 Soins infirmiers à domicile Guadeloupe \n",
"82 Commerces services Guadeloupe \n",
"83 Commerce de quincaillerie interrégionale employés \n",
"97 Transports routiers \n",
"98 Menuiseries charpentes portes planes \n",
"125 Hôtellerie Gironde \n",
"126 Sans Convention Collective \n",
"127 Restauration ferroviaire \n",
"128 Restauration rapide \n",
"134 Sans Convention Collective \n",
"135 Commerces services Guadeloupe \n",
"136 Champignonnières Vienne \n",
"141 Bâtiment cadres \n",
"... ... \n",
"1779970 Pôle emploi \n",
"1779971 Institutions d'assurance chômage Unedic \n",
"1779972 Pôle emploi \n",
"1779973 Institutions d'assurance chômage Unedic \n",
"1779974 Sans Convention Collective \n",
"1779975 Pôle emploi \n",
"1779976 Institutions d'assurance chômage Unedic \n",
"1779977 Sans Convention Collective \n",
"1779978 Pôle emploi \n",
"1779979 Institutions d'assurance chômage Unedic \n",
"1779980 Sans Convention Collective \n",
"1779981 Pôle emploi \n",
"1779982 Institutions d'assurance chômage Unedic \n",
"1779990 Sans Convention Collective \n",
"1779991 Travaux publics ETAM \n",
"1779992 Travaux publics cadres \n",
"1779993 Travaux publics ouvriers \n",
"1779996 Bâtiment cadres \n",
"1779997 Bâtiment ETAM \n",
"1779998 Bâtiment ouvriers plus de 10 Salariés \n",
"1779999 Bâtiment cadres \n",
"1780000 Bâtiment ETAM \n",
"1780001 Bâtiment ouvriers Languedoc Roussillon \n",
"1780002 Bâtiment ouvriers plus de 10 Salariés \n",
"1780044 Bâtiment ouvriers Loire Atlantique \n",
"1780045 Bâtiment ETAM \n",
"1780069 Métallurgie Finistère \n",
"1780070 Métallurgie cadres \n",
"1780099 Fabrication de l'ameublement \n",
"1780100 Ameublement \n",
"\n",
" Lien vers convention Niveau d'application Numéro de brochure \n",
"0 NaN NaN NaN \n",
"1 NaN NaN NaN \n",
"2 NaN NaN NaN \n",
"6 NaN NaN NaN \n",
"7 NaN NaN NaN \n",
"8 NaN NaN NaN \n",
"9 NaN NaN NaN \n",
"10 NaN NaN NaN \n",
"33 NaN NaN NaN \n",
"34 NaN NaN NaN \n",
"35 NaN NaN NaN \n",
"39 NaN NaN NaN \n",
"40 NaN NaN NaN \n",
"48 NaN NaN NaN \n",
"49 NaN NaN NaN \n",
"50 NaN NaN NaN \n",
"72 NaN NaN NaN \n",
"73 NaN NaN NaN \n",
"82 NaN NaN NaN \n",
"83 NaN NaN NaN \n",
"97 NaN NaN NaN \n",
"98 NaN NaN NaN \n",
"125 NaN NaN NaN \n",
"126 NaN NaN NaN \n",
"127 NaN NaN NaN \n",
"128 NaN NaN NaN \n",
"134 NaN NaN NaN \n",
"135 NaN NaN NaN \n",
"136 NaN NaN NaN \n",
"141 NaN NaN NaN \n",
"... ... ... ... \n",
"1779970 NaN NaN NaN \n",
"1779971 NaN NaN NaN \n",
"1779972 NaN NaN NaN \n",
"1779973 NaN NaN NaN \n",
"1779974 NaN NaN NaN \n",
"1779975 NaN NaN NaN \n",
"1779976 NaN NaN NaN \n",
"1779977 NaN NaN NaN \n",
"1779978 NaN NaN NaN \n",
"1779979 NaN NaN NaN \n",
"1779980 NaN NaN NaN \n",
"1779981 NaN NaN NaN \n",
"1779982 NaN NaN NaN \n",
"1779990 NaN NaN NaN \n",
"1779991 NaN NaN NaN \n",
"1779992 NaN NaN NaN \n",
"1779993 NaN NaN NaN \n",
"1779996 NaN NaN NaN \n",
"1779997 NaN NaN NaN \n",
"1779998 NaN NaN NaN \n",
"1779999 NaN NaN NaN \n",
"1780000 NaN NaN NaN \n",
"1780001 NaN NaN NaN \n",
"1780002 NaN NaN NaN \n",
"1780044 NaN NaN NaN \n",
"1780045 NaN NaN NaN \n",
"1780069 NaN NaN NaN \n",
"1780070 NaN NaN NaN \n",
"1780099 NaN NaN NaN \n",
"1780100 NaN NaN NaN \n",
"\n",
"[338774 rows x 29 columns]"
]
},
"execution_count": 203,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[df[\"SIRET\"].isin(g.index)]"
]
},
{
"cell_type": "code",
"execution_count": 175,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"41809358"
]
},
"execution_count": 175,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df4.size"
]
},
{
"cell_type": "code",
"execution_count": 206,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"1256255"
]
},
"execution_count": 206,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(set(df4[\"SIRET\"]))"
]
},
{
"cell_type": "code",
"execution_count": 207,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"0.11257587034479465"
]
},
"execution_count": 207,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"g.shape[0] / len(set(df4[\"SIRET\"]))"
]
},
{
"cell_type": "code",
"execution_count": 211,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"338774"
]
},
"execution_count": 211,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[df[\"SIRET\"].isin(g.index)].shape[0]"
]
},
{
"cell_type": "code",
"execution_count": 212,
"metadata": {},
"outputs": [],
"source": [
"df[df[\"SIRET\"].isin(g.index)].to_excel('extract_sirets_with_multiple_idcc.xlsx')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment