Overview

Dataset info

Number of variables 21
Number of observations 281551
Total Missing (%) 27.3%
Total size in memory 45.1 MiB
Average record size in memory 168.0 B

Variables types

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

Warnings

Variables

annee
Numeric

Distinct count 13
Unique (%) 0.0%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean 2016.4
Minimum 1973
Maximum 2018
Zeros (%) 0.0%

Quantile statistics

Minimum 1973
5-th percentile 2014
Q1 2016
Median 2017
Q3 2017
95-th percentile 2018
Maximum 2018
Range 45
Interquartile range 1

Descriptive statistics

Standard deviation 1.3583
Coef of variation 0.00067361
Kurtosis 5.2411
Mean 2016.4
MAD 1.0768
Skewness -1.2921
Sum 567727054
Variance 1.8449
Memory size 2.1 MiB
Value Count Frequency (%)  
2017 117744 41.8%
 
2018 53487 19.0%
 
2016 49939 17.7%
 
2015 32737 11.6%
 
2014 15969 5.7%
 
2013 7317 2.6%
 
2012 4278 1.5%
 
2007 66 0.0%
 
2011 6 0.0%
 
2005 5 0.0%
 
Other values (3) 3 0.0%
 

Minimum 5 values

Value Count Frequency (%)  
1973 1 0.0%
 
2002 1 0.0%
 
2005 5 0.0%
 
2007 66 0.0%
 
2010 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
2014 15969 5.7%
 
2015 32737 11.6%
 
2016 49939 17.7%
 
2017 117744 41.8%
 
2018 53487 19.0%
 

categorie_generale
Constant

This variable is constant and should be ignored for analysis

Constant value

categorie_precise
Constant

This variable is constant and should be ignored for analysis

Constant value

catégorie_beneficiaire
Categorical

Distinct count 14
Unique (%) 0.0%
Missing (%) 0.0%
Missing (n) 0
Professionnel de santé
189142
Académies, Fondation, sociétés savantes, organismes de conseils
39359
Association professionnel de santé
 
20175
Other values (11)
 
32875
Value Count Frequency (%)  
Professionnel de santé 189142 67.2%
 
Académies, Fondation, sociétés savantes, organismes de conseils 39359 14.0%
 
Association professionnel de santé 20175 7.2%
 
Etablissement de santé 15409 5.5%
 
Presse et média 7917 2.8%
 
Personnes morales assurant la formation initiale ou continue des professionnels de santé 7045 2.5%
 
Association usager de santé 1023 0.4%
 
Vétérinaire 633 0.2%
 
Vétérinaire Personne Morale 347 0.1%
 
Etudiant 180 0.1%
 
Other values (4) 321 0.1%
 

date
Categorical

Distinct count 2231
Unique (%) 0.8%
Missing (%) 0.0%
Missing (n) 0
07/12/2017
 
1781
28/02/2018
 
1479
19/12/2017
 
1257
Other values (2228)
277034
Value Count Frequency (%)  
07/12/2017 1781 0.6%
 
28/02/2018 1479 0.5%
 
19/12/2017 1257 0.4%
 
20/12/2017 1042 0.4%
 
31/07/2017 1011 0.4%
 
30/11/2017 1007 0.4%
 
25/01/2017 983 0.3%
 
31/10/2017 941 0.3%
 
27/06/2018 878 0.3%
 
14/11/2017 869 0.3%
 
Other values (2221) 270303 96.0%
 

declaration_id
Categorical, Unique

First 3 values
Remuneration | IIXRHSGB | CO-2012-02257_ORG-00...
Remuneration | NROJFJET | 290334_R_5213799
Remuneration | IIXRHSGB | CO-2016-02895_PS-020...
Last 3 values
Remuneration | RWVUYGMV | CO-2017-0171_ORG-000...
Remuneration | GXFDURFB | R85
Remuneration | SYCNVYRX | RE_2017_02_P_FIP_FR0...

First 10 values

Value Count Frequency (%)  
Remuneration | AADEBGMH | MANUEL_292651 1 0.0%
 
Remuneration | AADEBGMH | MANUEL_292672 1 0.0%
 
Remuneration | AADEBGMH | MANUEL_292681 1 0.0%
 
Remuneration | AADEBGMH | MANUEL_292692 1 0.0%
 
Remuneration | AADEBGMH | MANUEL_292698 1 0.0%
 

Last 10 values

Value Count Frequency (%)  
Remuneration | ZYNQHBPG | MANUEL_329797 1 0.0%
 
Remuneration | ZYNQHBPG | MANUEL_374773 1 0.0%
 
Remuneration | ZYNQHBPG | MANUEL_374787 1 0.0%
 
Remuneration | ZYNQHBPG | MANUEL_374800 1 0.0%
 
Remuneration | ZYNQHBPG | MANUEL_374810 1 0.0%
 

detail
Constant

This variable is constant and should be ignored for analysis

Constant value

entreprise_émmetrice
Categorical

Distinct count 542
Unique (%) 0.2%
Missing (%) 0.0%
Missing (n) 0
A+A
 
29625
SANOFI SA
 
28978
P\S\L Group Services
 
18261
Other values (539)
204687
Value Count Frequency (%)  
A+A 29625 10.5%
 
SANOFI SA 28978 10.3%
 
P\S\L Group Services 18261 6.5%
 
Novartis 16771 6.0%
 
Bayer 11417 4.1%
 
Johnson & Johnson 8970 3.2%
 
GlaxoSmithKline 8143 2.9%
 
Pfizer 6745 2.4%
 
IMS Medical Radar 6608 2.3%
 
Boehringer Ingelheim 5856 2.1%
 
Other values (532) 140177 49.8%
 

filiale_déclarante
Categorical

Distinct count 643
Unique (%) 0.2%
Missing (%) 0.0%
Missing (n) 0
A+A
 
29625
SANOFI AVENTIS FRANCE
 
19753
P\S\L Group Services
 
18261
Other values (640)
213912
Value Count Frequency (%)  
A+A 29625 10.5%
 
SANOFI AVENTIS FRANCE 19753 7.0%
 
P\S\L Group Services 18261 6.5%
 
NOVARTIS PHARMA SAS 13632 4.8%
 
Bayer HealthCare SAS 11417 4.1%
 
JANSSEN-CILAG 8502 3.0%
 
LABORATOIRE GLAXOSMITHKLINE 7104 2.5%
 
IMS Medical Radar 6608 2.3%
 
AbbVie 5743 2.0%
 
Lilly France SAS 5740 2.0%
 
Other values (633) 155166 55.1%
 

identifiant
Categorical

Distinct count 41980
Unique (%) 14.9%
Missing (%) 20.0%
Missing (n) 56263
[SO]
 
19477
542024054
 
680
SO
 
517
Other values (41976)
204614
(Missing)
56263
Value Count Frequency (%)  
[SO] 19477 6.9%
 
542024054 680 0.2%
 
SO 517 0.2%
 
267500452 466 0.2%
 
302695432 328 0.1%
 
10002393691 307 0.1%
 
10001589422 298 0.1%
 
10100107985 281 0.1%
 
10003113528 233 0.1%
 
10001366961 227 0.1%
 
Other values (41969) 202474 71.9%
 
(Missing) 56263 20.0%
 

identifiant_convention
Categorical

Distinct count 223010
Unique (%) 79.2%
Missing (%) 0.0%
Missing (n) 0
Convention | FXYBJUOV | MANUEL_349949
 
2709
Convention | JUJJFUKK | MANUEL_297341
 
585
Convention | UDUQLMWQ | CN145339
 
263
Other values (223007)
277994
Value Count Frequency (%)  
Convention | FXYBJUOV | MANUEL_349949 2709 1.0%
 
Convention | JUJJFUKK | MANUEL_297341 585 0.2%
 
Convention | UDUQLMWQ | CN145339 263 0.1%
 
Convention | ZKEJWAGJ | 00000000000000249797 236 0.1%
 
Convention | SYCNVYRX | CO_2017_01_M_CTE_2016-06463_CTE_14018_2189 217 0.1%
 
Convention | OHBQOWOS | MANUEL_225608 197 0.1%
 
Convention | OHBQOWOS | HISTO-2013S1-36211 164 0.1%
 
Convention | OPFMIKBW | 303861-CONV 163 0.1%
 
Convention | TJCCUBLU | MANUEL_297351 148 0.1%
 
Convention | OHBQOWOS | MANUEL_242477 136 0.0%
 
Other values (223000) 276733 98.3%
 

identifiant_entreprise
Categorical

Distinct count 646
Unique (%) 0.2%
Missing (%) 0.0%
Missing (n) 0
WSVLSWEO
 
29625
IIXRHSGB
 
19753
IRJQLCSK
 
18261
Other values (643)
213912
Value Count Frequency (%)  
WSVLSWEO 29625 10.5%
 
IIXRHSGB 19753 7.0%
 
IRJQLCSK 18261 6.5%
 
YLWGMHGC 13632 4.8%
 
SOWWIAEU 11417 4.1%
 
XCKYTDRO 8502 3.0%
 
JUJJFUKK 7104 2.5%
 
OJMSGRPF 6608 2.3%
 
LFSWZPFF 5743 2.0%
 
PTBTSRUS 5740 2.0%
 
Other values (636) 155166 55.1%
 

montant_ttc
Numeric

Distinct count 20218
Unique (%) 7.2%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean 5411.4
Minimum 10
Maximum 5177540
Zeros (%) 0.0%

Quantile statistics

Minimum 10
5-th percentile 25
Q1 150
Median 600
Q3 1750
95-th percentile 19440
Maximum 5177540
Range 5177530
Interquartile range 1600

Descriptive statistics

Standard deviation 45005
Coef of variation 8.3167
Kurtosis 4072.8
Mean 5411.4
MAD 7939.2
Skewness 51.501
Sum 1523591601
Variance 2025500000
Memory size 2.1 MiB
Value Count Frequency (%)  
500 12932 4.6%
 
1000 11222 4.0%
 
600 7957 2.8%
 
800 7037 2.5%
 
50 6149 2.2%
 
400 6081 2.2%
 
150 6079 2.2%
 
1500 5982 2.1%
 
300 5669 2.0%
 
40 5438 1.9%
 
Other values (20208) 207005 73.5%
 

Minimum 5 values

Value Count Frequency (%)  
10 766 0.3%
 
11 35 0.0%
 
12 86 0.0%
 
13 83 0.0%
 
14 126 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
4327276 1 0.0%
 
4704916 1 0.0%
 
4843939 1 0.0%
 
5078660 1 0.0%
 
5177540 1 0.0%
 

nom
Categorical

Distinct count 28820
Unique (%) 10.2%
Missing (%) 32.4%
Missing (n) 91092
THOMAS
 
400
ESTIVAL
 
337
ULUSAKARYA
 
335
Other values (28816)
189387
(Missing)
91092
Value Count Frequency (%)  
THOMAS 400 0.1%
 
ESTIVAL 337 0.1%
 
ULUSAKARYA 335 0.1%
 
MARTIN 326 0.1%
 
GIRARD 302 0.1%
 
LEVY 287 0.1%
 
CHIDIAC 285 0.1%
 
COHEN 283 0.1%
 
MOREAU 276 0.1%
 
JDID 265 0.1%
 
Other values (28809) 187363 66.5%
 
(Missing) 91092 32.4%
 

nom_prénom
Categorical

Distinct count 41334
Unique (%) 14.7%
Missing (%) 32.4%
Missing (n) 91091
ULUSAKARYA Ayhan
 
335
ESTIVAL Jean Louis
 
334
CHIDIAC Jean
 
281
Other values (41330)
189510
(Missing)
91091
Value Count Frequency (%)  
ULUSAKARYA Ayhan 335 0.1%
 
ESTIVAL Jean Louis 334 0.1%
 
CHIDIAC Jean 281 0.1%
 
LAMURAGLIA Michele 261 0.1%
 
MOHTY Mohamad 247 0.1%
 
COLMARD Patrick 236 0.1%
 
HACINI Maya 233 0.1%
 
HANON Olivier 227 0.1%
 
ABADIE Aouni 221 0.1%
 
BLIN Nicolas 212 0.1%
 
Other values (41323) 187873 66.7%
 
(Missing) 91091 32.4%
 

profession
Categorical

Distinct count 22
Unique (%) 0.0%
Missing (%) 32.8%
Missing (n) 92366
Médecin
178895
Pharmacien
 
5179
Infirmier
 
3281
Other values (18)
 
1830
(Missing)
92366
Value Count Frequency (%)  
Médecin 178895 63.5%
 
Pharmacien 5179 1.8%
 
Infirmier 3281 1.2%
 
Chirurgien-dentiste 640 0.2%
 
Masseur-kinésithérapeute 280 0.1%
 
Manipulateur d’électroradiologie médicale 198 0.1%
 
Diététicien 176 0.1%
 
Sage-femme 168 0.1%
 
Orthoptiste 125 0.0%
 
Opticien-lunetier 69 0.0%
 
Other values (11) 174 0.1%
 
(Missing) 92366 32.8%
 

prénom
Categorical

Distinct count 4916
Unique (%) 1.7%
Missing (%) 32.6%
Missing (n) 91837
Philippe
 
6061
Pierre
 
3352
Olivier
 
3287
Other values (4912)
177014
(Missing)
91837
Value Count Frequency (%)  
Philippe 6061 2.2%
 
Pierre 3352 1.2%
 
Olivier 3287 1.2%
 
Eric 3029 1.1%
 
Michel 2750 1.0%
 
Francois 2715 1.0%
 
Nicolas 2622 0.9%
 
Patrick 2515 0.9%
 
Laurent 2464 0.9%
 
Alain 2269 0.8%
 
Other values (4905) 158650 56.3%
 
(Missing) 91837 32.6%
 

specialité
Categorical

Distinct count 63
Unique (%) 0.0%
Missing (%) 56.3%
Missing (n) 158387
Autre
 
14222
Cardiologie et maladies vasculaires
 
9591
Endocrinologie et métabolisme
 
7527
Other values (59)
91824
(Missing)
158387
Value Count Frequency (%)  
Autre 14222 5.1%
 
Cardiologie et maladies vasculaires 9591 3.4%
 
Endocrinologie et métabolisme 7527 2.7%
 
Ophtalmologie 7049 2.5%
 
Pneumologie 6896 2.4%
 
Oncologie option médicale 6882 2.4%
 
Médecine Générale 6350 2.3%
 
Gastro-entérologie et hépatologie 6298 2.2%
 
Neurologie 5365 1.9%
 
Rhumatologie 5344 1.9%
 
Other values (52) 47640 16.9%
 
(Missing) 158387 56.3%
 

structure_bénéficiaire
Categorical

Distinct count 19050
Unique (%) 6.8%
Missing (%) 67.5%
Missing (n) 189956
CONSEIL MEDIA SANTE
 
1084
IMS HEALTH
 
958
CMS
 
760
Other values (19046)
88793
(Missing)
189956
Value Count Frequency (%)  
CONSEIL MEDIA SANTE 1084 0.4%
 
IMS HEALTH 958 0.3%
 
CMS 760 0.3%
 
AIXIAL 634 0.2%
 
PUBLICIS LIFE BRANDS 624 0.2%
 
MEDIACOM PARIS 513 0.2%
 
HAYS PHARMA 481 0.2%
 
EXCELYA 464 0.2%
 
GRIS MARINE 423 0.2%
 
GERS 410 0.1%
 
Other values (19039) 85244 30.3%
 
(Missing) 189956 67.5%
 

type_declaration
Constant

This variable is constant and should be ignored for analysis

Constant value Remuneration

type_identifiant
Categorical

Distinct count 5
Unique (%) 0.0%
Missing (%) 0.0%
Missing (n) 0
RPPS
171688
AUTRE
85702
SIREN
 
20365
Other values (2)
 
3796
Value Count Frequency (%)  
RPPS 171688 61.0%
 
AUTRE 85702 30.4%
 
SIREN 20365 7.2%
 
FINESS 1919 0.7%
 
ORDRE 1877 0.7%
 

Correlations

Sample

annee categorie_generale categorie_precise catégorie_beneficiaire date declaration_id detail entreprise_émmetrice filiale_déclarante identifiant identifiant_convention identifiant_entreprise montant_ttc nom nom_prénom profession prénom specialité structure_bénéficiaire type_declaration type_identifiant
0 2017 NaN NaN Etablissement de santé 03/04/2017 Remuneration | KIKIOHQV | XLS-2018-2-27-X-BOR-... NaN Novartis Sociétés étrangères du groupe Novartis NaN Convention | KIKIOHQV | XLS-2018-2-27-X-BOR-R-... KIKIOHQV 2346 NaN NaN NaN NaN NaN Activité de recherche & développement internat... Remuneration AUTRE
1 2017 NaN NaN Etablissement de santé 24/03/2017 Remuneration | KIKIOHQV | XLS-2018-2-27-X-BOR-... NaN Novartis Sociétés étrangères du groupe Novartis NaN Convention | KIKIOHQV | XLS-2018-2-27-X-BOR-R-... KIKIOHQV 1186 NaN NaN NaN NaN NaN Activité de recherche & développement internat... Remuneration AUTRE
2 2016 NaN NaN Etablissement de santé 08/12/2016 Remuneration | YLWGMHGC | XLS-2017-9-28-EC_2_R... NaN Novartis NOVARTIS PHARMA SAS NaN Convention | YLWGMHGC | XLS-2017-9-28-EC_2_CON... YLWGMHGC 684 NaN NaN NaN NaN NaN ASSISTANCE PUBLIQUE Remuneration AUTRE
3 2017 NaN NaN Etablissement de santé 27/06/2017 Remuneration | KIKIOHQV | XLS-2018-2-27-X-BOR-... NaN Novartis Sociétés étrangères du groupe Novartis NaN Convention | KIKIOHQV | XLS-2018-2-27-X-BOR-R-... KIKIOHQV 750 NaN NaN NaN NaN NaN Activité de recherche & développement internat... Remuneration AUTRE
4 2017 NaN NaN Etablissement de santé 06/09/2017 Remuneration | KIKIOHQV | XLS-2018-2-27-X-BOR-... NaN Novartis Sociétés étrangères du groupe Novartis NaN Convention | KIKIOHQV | XLS-2018-2-27-X-BOR-R-... KIKIOHQV 7023 NaN NaN NaN NaN NaN Activité de recherche & développement internat... Remuneration AUTRE