Overview

Dataset info

Number of variables 24
Number of observations 406252
Total Missing (%) 48.3%
Total size in memory 74.4 MiB
Average record size in memory 192.0 B

Variables types

Numeric 2
Categorical 21
Boolean 0
Date 0
Text (Unique) 1
Rejected 0
Unsupported 0

Warnings

Variables

adresse
Categorical

Distinct count 261389
Unique (%) 64.3%
Missing (%) 0.0%
Missing (n) 3
26 BOULEVARD DE LOUVAIN 13008 Marseille
 
218
87 BOULEVARD DE PORT ROYAL 75013 Paris
 
169
63 BOULEVARD VICTOR HUGO 92200 Neuilly-sur-Seine
 
138
Other values (261385)
405724
Value Count Frequency (%)  
26 BOULEVARD DE LOUVAIN 13008 Marseille 218 0.1%
 
87 BOULEVARD DE PORT ROYAL 75013 Paris 169 0.0%
 
63 BOULEVARD VICTOR HUGO 92200 Neuilly-sur-Seine 138 0.0%
 
6 RUE DESIREE CLARY 13331 Marseille 132 0.0%
 
1 RUE VELPEAU 92160 Antony 123 0.0%
 
505 RUE IRENE JOLIOT CURIE 76620 Le Havre 116 0.0%
 
39 CHEMIN DE LA VERNIQUE 69130 Écully 101 0.0%
 
50 RUE EMILE COMBES 34170 Castelnau-le-Lez 93 0.0%
 
6 AVENUE DU NOYER LAMBERT 91300 Massy 85 0.0%
 
128 BOULEVARD MACDONALD 75019 Paris 79 0.0%
 
Other values (261378) 404995 99.7%
 

cedex
Categorical

Distinct count 24942
Unique (%) 6.1%
Missing (%) 0.0%
Missing (n) 3
06000 NICE
 
1877
75015 PARIS
 
1698
67000 STRASBOURG
 
1491
Other values (24938)
401183
Value Count Frequency (%)  
06000 NICE 1877 0.5%
 
75015 PARIS 1698 0.4%
 
67000 STRASBOURG 1491 0.4%
 
13008 MARSEILLE 1463 0.4%
 
75017 PARIS 1408 0.3%
 
33000 BORDEAUX 1388 0.3%
 
75013 PARIS 1325 0.3%
 
59000 LILLE 1295 0.3%
 
34000 MONTPELLIER 1287 0.3%
 
21000 DIJON 1075 0.3%
 
Other values (24931) 391942 96.5%
 

code_commune
Categorical

Distinct count 12416
Unique (%) 3.1%
Missing (%) 32.9%
Missing (n) 133706
75056
 
8569
13055
 
3129
31555
 
2768
Other values (12412)
258080
(Missing)
133706
Value Count Frequency (%)  
75056 8569 2.1%
 
13055 3129 0.8%
 
31555 2768 0.7%
 
06088 2548 0.6%
 
34172 2247 0.6%
 
33063 2115 0.5%
 
67482 1989 0.5%
 
69123 1901 0.5%
 
44109 1814 0.4%
 
59350 1538 0.4%
 
Other values (12405) 243928 60.0%
 
(Missing) 133706 32.9%
 

code_postal
Categorical

Distinct count 9276
Unique (%) 2.3%
Missing (%) 0.0%
Missing (n) 3
06000
 
1877
75015
 
1795
13008
 
1535
Other values (9272)
401042
Value Count Frequency (%)  
06000 1877 0.5%
 
75015 1795 0.4%
 
13008 1535 0.4%
 
75017 1517 0.4%
 
67000 1493 0.4%
 
33000 1388 0.3%
 
75013 1371 0.3%
 
59000 1295 0.3%
 
34000 1290 0.3%
 
75008 1148 0.3%
 
Other values (9265) 391540 96.4%
 

commune
Categorical

Distinct count 12113
Unique (%) 3.0%
Missing (%) 32.9%
Missing (n) 133706
Paris
 
8569
Marseille
 
3129
Toulouse
 
2768
Other values (12109)
258080
(Missing)
133706
Value Count Frequency (%)  
Paris 8569 2.1%
 
Marseille 3129 0.8%
 
Toulouse 2768 0.7%
 
Nice 2548 0.6%
 
Montpellier 2247 0.6%
 
Bordeaux 2115 0.5%
 
Strasbourg 1989 0.5%
 
Lyon 1901 0.5%
 
Nantes 1814 0.4%
 
Lille 1538 0.4%
 
Other values (12102) 243928 60.0%
 
(Missing) 133706 32.9%
 

complement_destinataire
Categorical

Distinct count 114231
Unique (%) 28.1%
Missing (%) 56.7%
Missing (n) 230234
CABINET DE KINESITHERAPIE
 
1308
CABINET MEDICAL
 
709
MAISON MEDICALE
 
557
Other values (114227)
173444
(Missing)
230234
Value Count Frequency (%)  
CABINET DE KINESITHERAPIE 1308 0.3%
 
CABINET MEDICAL 709 0.2%
 
MAISON MEDICALE 557 0.1%
 
MAISON DE SANTE 393 0.1%
 
AUDIKA FRANCE 382 0.1%
 
CENTRE HOSPITALIER 304 0.1%
 
SOS MEDECINS 298 0.1%
 
GRANDVISION FRANCE - GDO 298 0.1%
 
LES OPTICIENS MUTUALISTES 275 0.1%
 
MAISON DE SANTE PLURIDISCIPLINAIRE 239 0.1%
 
Other values (114220) 171255 42.2%
 
(Missing) 230234 56.7%
 

complement_point_geographique
Categorical

Distinct count 37726
Unique (%) 9.3%
Missing (%) 83.6%
Missing (n) 339678
MAISON MEDICALE
 
961
MAISON DE SANTE
 
667
CABINET INFIRMIER
 
661
Other values (37722)
 
64285
(Missing)
339678
Value Count Frequency (%)  
MAISON MEDICALE 961 0.2%
 
MAISON DE SANTE 667 0.2%
 
CABINET INFIRMIER 661 0.2%
 
CABINET MEDICAL 602 0.1%
 
CABINET DE SOINS INFIRMIERS 403 0.1%
 
CENTRE MEDICAL 358 0.1%
 
CABINET ORTHOPHONISTE 273 0.1%
 
CENTRE HOSPITALIER 200 0.0%
 
SOS MEDECINS 193 0.0%
 
CABINET D ORTHOPHONIE 184 0.0%
 
Other values (37715) 62072 15.3%
 
(Missing) 339678 83.6%
 

email
Categorical

Distinct count 41960
Unique (%) 10.3%
Missing (%) 88.4%
Missing (n) 359227
[email protected]
 
209
[email protected]
 
65
[email protected]
 
45
Other values (41956)
 
46706
(Missing)
359227
Value Count Frequency (%)  
[email protected] 209 0.1%
 
[email protected] 65 0.0%
 
[email protected] 45 0.0%
 
[email protected] 33 0.0%
 
[email protected] 23 0.0%
 
[email protected] 20 0.0%
 
[email protected] 20 0.0%
 
[email protected] 18 0.0%
 
[email protected] 18 0.0%
 
[email protected] 18 0.0%
 
Other values (41949) 46556 11.5%
 
(Missing) 359227 88.4%
 

enseigne_commerciale_site
Categorical

Distinct count 106675
Unique (%) 26.3%
Missing (%) 56.7%
Missing (n) 230216
CABINET INDIVIDUEL
 
17947
CABINET DE GROUPE
 
14437
Cabinet individuel
 
11181
Other values (106671)
132471
(Missing)
230216
Value Count Frequency (%)  
CABINET INDIVIDUEL 17947 4.4%
 
CABINET DE GROUPE 14437 3.6%
 
Cabinet individuel 11181 2.8%
 
CABINET DE SAGE-FEMME 6358 1.6%
 
Cabinet de groupe 5571 1.4%
 
CABINET DE SAGE FEMME 259 0.1%
 
SITE PRINCIPAL 83 0.0%
 
PHARMACIE CENTRALE 75 0.0%
 
PHARMACIE DU CENTRE 73 0.0%
 
CABINET DE SAGES-FEMMES 70 0.0%
 
Other values (106664) 119982 29.5%
 
(Missing) 230216 56.7%
 

finess_etablissement_juridique
Categorical

Distinct count 33061
Unique (%) 8.1%
Missing (%) 86.9%
Missing (n) 353066
750719239
 
321
750721334
 
303
930019229
 
204
Other values (33057)
 
52358
(Missing)
353066
Value Count Frequency (%)  
750719239 321 0.1%
 
750721334 303 0.1%
 
930019229 204 0.1%
 
920030152 177 0.0%
 
750056335 133 0.0%
 
620020859 103 0.0%
 
920028560 102 0.0%
 
750712184 102 0.0%
 
590805131 87 0.0%
 
920030269 86 0.0%
 
Other values (33050) 51568 12.7%
 
(Missing) 353066 86.9%
 

finess_site
Numeric

Distinct count 181
Unique (%) 0.0%
Missing (%) 100.0%
Missing (n) 406072
Infinite (%) 0.0%
Infinite (n) 0
Mean 281800000
Minimum 180040000
Maximum 784620000
Zeros (%) 0.0%

Quantile statistics

Minimum 180040000
5-th percentile 260210000
Q1 262410000
Median 265300000
Q3 267600000
95-th percentile 348960000
Maximum 784620000
Range 604580000
Interquartile range 5195800

Descriptive statistics

Standard deviation 85931000
Coef of variation 0.30494
Kurtosis 25.179
Mean 281800000
MAD 35573000
Skewness 4.9412
Sum 50724000000
Variance 7384100000000000
Memory size 3.1 MiB
Value Count Frequency (%)  
268400223.0 1 0.0%
 
267601706.0 1 0.0%
 
261927602.0 1 0.0%
 
229740014.0 1 0.0%
 
229720016.0 1 0.0%
 
266800192.0 1 0.0%
 
266900273.0 1 0.0%
 
266900133.0 1 0.0%
 
267100444.0 1 0.0%
 
265200105.0 1 0.0%
 
Other values (170) 170 0.0%
 
(Missing) 406072 100.0%
 

Minimum 5 values

Value Count Frequency (%)  
180036014.0 1 0.0%
 
200034650.0 1 0.0%
 
200044972.0 1 0.0%
 
200047835.0 1 0.0%
 
200055358.0 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
636713422.0 1 0.0%
 
775672272.0 1 0.0%
 
775694748.0 1 0.0%
 
782921233.0 1 0.0%
 
784615387.0 1 0.0%
 

identifiant_organisation
Categorical, Unique

First 3 values
C82442027700017
C45212535400020
R10100000191924
Last 3 values
R10100000203160
R10100000197090
R10100000236991

First 10 values

Value Count Frequency (%)  
C00708070800022 1 0.0%
 
C01602961300 1 0.0%
 
C01603642800 1 0.0%
 
C01603742600 1 0.0%
 
C01603756600 1 0.0%
 

Last 10 values

Value Count Frequency (%)  
R10100000258499 1 0.0%
 
R10100000258500 1 0.0%
 
R10100000258503 1 0.0%
 
R10100000258505 1 0.0%
 
R10100000258506 1 0.0%
 

indice_repetition_voie
Categorical

Distinct count 50
Unique (%) 0.0%
Missing (%) 93.3%
Missing (n) 379184
B
 
11350
BIS
 
8004
A
 
3205
Other values (46)
 
4509
(Missing)
379184
Value Count Frequency (%)  
B 11350 2.8%
 
BIS 8004 2.0%
 
A 3205 0.8%
 
T 1382 0.3%
 
TER 1244 0.3%
 
C 821 0.2%
 
D 439 0.1%
 
E 173 0.0%
 
F 84 0.0%
 
Q 61 0.0%
 
Other values (39) 305 0.1%
 
(Missing) 379184 93.3%
 

mention_distribution
Categorical

Distinct count 15106
Unique (%) 3.7%
Missing (%) 92.9%
Missing (n) 377323
MAISON DE SANTE
 
217
LE BOURG
 
165
BP
 
149
Other values (15102)
 
28398
(Missing)
377323
Value Count Frequency (%)  
MAISON DE SANTE 217 0.1%
 
LE BOURG 165 0.0%
 
BP 149 0.0%
 
MAISON MEDICALE 127 0.0%
 
CABINET INFIRMIER 117 0.0%
 
BP 8 83 0.0%
 
BAT B 79 0.0%
 
CS 56816 72 0.0%
 
BAT A 69 0.0%
 
POLE SANTE 69 0.0%
 
Other values (15095) 27782 6.8%
 
(Missing) 377323 92.9%
 

numero_voie
Categorical

Distinct count 2178
Unique (%) 0.5%
Missing (%) 11.0%
Missing (n) 44591
1
 
22146
2
 
20575
3
 
14407
Other values (2174)
304533
(Missing)
 
44591
Value Count Frequency (%)  
1 22146 5.5%
 
2 20575 5.1%
 
3 14407 3.5%
 
4 13649 3.4%
 
5 11387 2.8%
 
6 11172 2.8%
 
7 9674 2.4%
 
8 9387 2.3%
 
9 8530 2.1%
 
10 8411 2.1%
 
Other values (2167) 232323 57.2%
 
(Missing) 44591 11.0%
 

pays
Categorical

Distinct count 7
Unique (%) 0.0%
Missing (%) 0.0%
Missing (n) 0
France
406246
Canada
 
1
Italie
 
1
Other values (4)
 
4
Value Count Frequency (%)  
France 406246 100.0%
 
Canada 1 0.0%
 
Italie 1 0.0%
 
Israel 1 0.0%
 
Suisse 1 0.0%
 
Belgique 1 0.0%
 
Monaco 1 0.0%
 

raison_sociale_site
Categorical

Distinct count 336085
Unique (%) 82.7%
Missing (%) 0.0%
Missing (n) 35
AUDIKA FRANCE
 
382
GRANDVISION FRANCE - GDO
 
298
LES OPTICIENS MUTUALISTES
 
273
Other values (336081)
405264
Value Count Frequency (%)  
AUDIKA FRANCE 382 0.1%
 
GRANDVISION FRANCE - GDO 298 0.1%
 
LES OPTICIENS MUTUALISTES 273 0.1%
 
CABINET INFIRMIER MME MARTIN 153 0.0%
 
CABINET INFIRMIER MME BERNARD 94 0.0%
 
SCE DEP DE L EDUCATION NATIONALE 85 0.0%
 
GRANDVISION FRANCE 84 0.0%
 
CABINET INFIRMIER MME THOMAS 83 0.0%
 
Cabinet du Dr MARTIN 77 0.0%
 
CABINET INFIRMIER MME ROBERT 75 0.0%
 
Other values (336074) 404613 99.6%
 

siren_site
Categorical

Distinct count 53103
Unique (%) 13.1%
Missing (%) 86.9%
Missing (n) 353147
820002137
 
2
670012434
 
2
780014775
 
2
Other values (53099)
 
53099
(Missing)
353147
Value Count Frequency (%)  
820002137 2 0.0%
 
670012434 2 0.0%
 
780014775 2 0.0%
 
380017806 1 0.0%
 
450016365 1 0.0%
 
660788555 1 0.0%
 
560016826 1 0.0%
 
330789926 1 0.0%
 
810004218 1 0.0%
 
130785728 1 0.0%
 
Other values (53092) 53092 13.1%
 
(Missing) 353147 86.9%
 

siret_site
Numeric

Distinct count 63129
Unique (%) 15.5%
Missing (%) 84.0%
Missing (n) 341096
Infinite (%) 0.0%
Infinite (n) 0
Mean 51444000000000
Minimum 0
Maximum 99804000000000
Zeros (%) 0.0%

Quantile statistics

Minimum 0
5-th percentile 26070000000000
Q1 34117000000000
Median 48008000000000
Q3 77565000000000
95-th percentile 82889000000000
Maximum 99804000000000
Range 99804000000000
Interquartile range 43447000000000

Descriptive statistics

Standard deviation 20640000000000
Coef of variation 0.4012
Kurtosis -1.2179
Mean 51444000000000
MAD 17471000000000
Skewness 0.34425
Sum 3.3519e+18
Variance 4.2599e+26
Memory size 3.1 MiB
Value Count Frequency (%)  
18003502402369.0 142 0.0%
 
22920050600157.0 25 0.0%
 
22770001000019.0 12 0.0%
 
49331533700011.0 12 0.0%
 
32101874900127.0 11 0.0%
 
78457968201771.0 9 0.0%
 
39742046400042.0 8 0.0%
 
42358185900018.0 8 0.0%
 
31929497100043.0 8 0.0%
 
77567227221138.0 7 0.0%
 
Other values (63118) 64914 16.0%
 
(Missing) 341096 84.0%
 

Minimum 5 values

Value Count Frequency (%)  
0.0 1 0.0%
 
572016400028.0 1 0.0%
 
578096000059.0 1 0.0%
 
578096000117.0 1 0.0%
 
705004000018.0 3 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
98692020500010.0 1 0.0%
 
98722029000017.0 1 0.0%
 
99565009000013.0 2 0.0%
 
99792772800011.0 1 0.0%
 
99803631300018.0 1 0.0%
 

telecopie
Categorical

Distinct count 52172
Unique (%) 12.8%
Missing (%) 85.4%
Missing (n) 347065
0411932045
 
17
04 38 70 17 02
 
16
04 91 61 70 03
 
15
Other values (52168)
 
59139
(Missing)
347065
Value Count Frequency (%)  
0411932045 17 0.0%
 
04 38 70 17 02 16 0.0%
 
04 91 61 70 03 15 0.0%
 
13 0.0%
 
/ 13 0.0%
 
04.77.41.61.90 12 0.0%
 
03.88.06.30.30 12 0.0%
 
0546455000 10 0.0%
 
0388802265 10 0.0%
 
04 91 07 11 02 10 0.0%
 
Other values (52161) 59059 14.5%
 
(Missing) 347065 85.4%
 

telephone
Categorical

Distinct count 210956
Unique (%) 51.9%
Missing (%) 37.1%
Missing (n) 150748
01.30.40.12.12
 
68
0000000000
 
44
04 91 52 91 52
 
36
Other values (210952)
255356
(Missing)
150748
Value Count Frequency (%)  
01.30.40.12.12 68 0.0%
 
0000000000 44 0.0%
 
04 91 52 91 52 36 0.0%
 
02.40.50.30.30 33 0.0%
 
05.56.44.74.74 31 0.0%
 
0142731665 30 0.0%
 
03.88.75.75.75 28 0.0%
 
01 47 07 77 77 28 0.0%
 
0491605265 26 0.0%
 
02.48.48.48.48 25 0.0%
 
Other values (210945) 255155 62.8%
 
(Missing) 150748 37.1%
 

telephone_2
Categorical

Distinct count 16651
Unique (%) 4.1%
Missing (%) 95.7%
Missing (n) 388899
0692285510
 
4
0664184444
 
4
0637886735
 
4
Other values (16647)
 
17341
(Missing)
388899
Value Count Frequency (%)  
0692285510 4 0.0%
 
0664184444 4 0.0%
 
0637886735 4 0.0%
 
0660614210 3 0.0%
 
0662327248 3 0.0%
 
0663898369 3 0.0%
 
0617487632 3 0.0%
 
06.95.57.08.71 3 0.0%
 
0607046250 3 0.0%
 
0609886193 3 0.0%
 
Other values (16640) 17320 4.3%
 
(Missing) 388899 95.7%
 

type_voie
Categorical

Distinct count 139
Unique (%) 0.0%
Missing (%) 32.5%
Missing (n) 132010
Rue
144253
Avenue
47214
Place
 
20052
Other values (135)
62723
(Missing)
132010
Value Count Frequency (%)  
Rue 144253 35.5%
 
Avenue 47214 11.6%
 
Place 20052 4.9%
 
Boulevard 16661 4.1%
 
Route 13991 3.4%
 
Chemin 8247 2.0%
 
Allee 5540 1.4%
 
Impasse 2896 0.7%
 
Cours 2356 0.6%
 
Quai 1376 0.3%
 
Other values (128) 11656 2.9%
 
(Missing) 132010 32.5%
 

voie
Categorical

Distinct count 91761
Unique (%) 22.6%
Missing (%) 1.2%
Missing (n) 4781
DE LA REPUBLIQUE
 
4494
JEAN JAURES
 
3331
DU GENERAL DE GAULLE
 
3035
Other values (91757)
390611
(Missing)
 
4781
Value Count Frequency (%)  
DE LA REPUBLIQUE 4494 1.1%
 
JEAN JAURES 3331 0.8%
 
DU GENERAL DE GAULLE 3035 0.7%
 
GRANDE RUE 1884 0.5%
 
VICTOR HUGO 1876 0.5%
 
DE LA GARE 1854 0.5%
 
GAMBETTA 1814 0.4%
 
PASTEUR 1546 0.4%
 
DU GENERAL LECLERC 1465 0.4%
 
DE LA LIBERATION 1456 0.4%
 
Other values (91750) 378716 93.2%
 
(Missing) 4781 1.2%
 

Correlations

Sample

adresse cedex code_commune code_postal commune complement_destinataire complement_point_geographique email enseigne_commerciale_site finess_etablissement_juridique finess_site identifiant_organisation indice_repetition_voie mention_distribution numero_voie pays raison_sociale_site siren_site siret_site telecopie telephone telephone_2 type_voie voie
0 900 Route DE PARIS 01012 Bourg-en-Bresse 01012 BOURG EN BRESSE CEDEX 01053 01012 Bourg-en-Bresse NaN NaN NaN NaN 010780054 NaN F010000024 NaN CS 90401 900 France CENTRE HOSPITALIER DE FLEYRIAT 010000024 2.601000e+13 0474454114 0474454647 NaN Route DE PARIS
1 1 Route DE VEYZIAT 01108 Oyonnax 01108 OYONNAX CEDEX 01283 01108 Oyonnax NaN NaN NaN NaN 010008407 NaN F010005239 NaN BP 818 1 France CH DU HAUT BUGEY - GEOVREISSET 010005239 2.601102e+13 0474731002 0474731001 NaN Route DE VEYZIAT
2 62 Avenue DE JASSERON 01000 Bourg-en-Bresse 01000 BOURG EN BRESSE 01053 01000 Bourg-en-Bresse NaN NaN NaN NaN 010000156 NaN F010780195 NaN BP 132 62 France CLINIQUE CONVERT 010780195 7.722015e+13 0474452656 0474456445 NaN Avenue DE JASSERON
3 55 Rue BERTHELOT 01500 01500 AMBERIEU EN BUGEY NaN 01500 NaN CABINET INFIRMIER MME MORENO MME DI BENEDETTO CAROLE NaN NaN NaN NaN C01667509200 NaN NaN 55 France CABINET INFIRMIER MME MORENO NaN NaN NaN 0680113119 NaN Rue BERTHELOT
4 Avenue DE MARBOZ 01012 Bourg-en-Bresse 01012 BOURG EN BRESSE CEDEX 01053 01012 Bourg-en-Bresse NaN NaN NaN NaN 010783009 NaN F010000495 NaN NaN NaN France CENTRE PSYCHOTHERAPIQUE DE L'AIN 010000495 7.755446e+13 0474522899 0474522911 NaN Avenue DE MARBOZ