DBC-Zorgproducten per jaar, specialisme, diagnose

Dataset statistics

Number of variables	14
Number of observations	342645
Missing cells	54374
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	36.6 MiB
Average record size in memory	112.0 B

Variable types

Categorical	3
DateTime	1
Numeric	9
Text	1

Alerts

`VERSIE` has constant value ""	Constant
`DATUM_BESTAND` has constant value ""	Constant
`PEILDATUM` has constant value ""	Constant
`BEHANDELEND_SPECIALISME_CD` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`AANTAL_PAT_PER_ZPD` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_ZPD`	High correlation
`AANTAL_SUBTRAJECT_PER_ZPD` is highly overall correlated with `AANTAL_PAT_PER_ZPD`	High correlation
`AANTAL_PAT_PER_DIAG` is highly overall correlated with `AANTAL_SUBTRAJECT_PER_DIAG`	High correlation
`AANTAL_SUBTRAJECT_PER_DIAG` is highly overall correlated with `AANTAL_PAT_PER_DIAG`	High correlation
`AANTAL_PAT_PER_SPC` is highly overall correlated with `BEHANDELEND_SPECIALISME_CD` and 1 other fields	High correlation
`AANTAL_SUBTRAJECT_PER_SPC` is highly overall correlated with `AANTAL_PAT_PER_SPC`	High correlation
`GEMIDDELDE_VERKOOPPRIJS` has 54374 (15.9%) missing values	Missing
`AANTAL_SUBTRAJECT_PER_ZPD` is highly skewed (γ1 = 21.42121827)	Skewed

Reproduction

Analysis started	2023-09-12 08:36:19.031271
Analysis finished	2023-09-12 08:36:39.095454
Duration	20.06 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

VERSIE
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

1.0	342645

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1027935
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	342645	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	342645	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	342645	33.3%
.	342645	33.3%
0	342645	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	685290	66.7%
Other Punctuation	342645	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	342645	50.0%
0	342645	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	342645	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1027935	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	342645	33.3%
.	342645	33.3%
0	342645	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1027935	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	342645	33.3%
.	342645	33.3%
0	342645	33.3%

DATUM_BESTAND
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2023-09-10	342645

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3426450
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-09-10
2nd row	2023-09-10
3rd row	2023-09-10
4th row	2023-09-10
5th row	2023-09-10

Common Values

Value	Count	Frequency (%)
2023-09-10	342645	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-09-10	342645	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2741160	80.0%
Dash Punctuation	685290	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1027935	37.5%
2	685290	25.0%
3	342645	12.5%
9	342645	12.5%
1	342645	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	685290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3426450	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3426450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

PEILDATUM
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2023-09-01	342645

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3426450
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-09-01
2nd row	2023-09-01
3rd row	2023-09-01
4th row	2023-09-01
5th row	2023-09-01

Common Values

Value	Count	Frequency (%)
2023-09-01	342645	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-09-01	342645	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2741160	80.0%
Dash Punctuation	685290	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1027935	37.5%
2	685290	25.0%
3	342645	12.5%
9	342645	12.5%
1	342645	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	685290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3426450	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3426450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1027935	30.0%
2	685290	20.0%
-	685290	20.0%
3	342645	10.0%
9	342645	10.0%
1	342645	10.0%

JAAR
Date

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Minimum	2012-01-01 00:00:00
Maximum	2023-01-01 00:00:00

Histogram

Histogram with fixed size bins (bins=12)

BEHANDELEND_SPECIALISME_CD
Real number (ℝ)

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	449.77818

Minimum	301
Maximum	8418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	301
5-th percentile	302
Q1	305
median	313
Q3	322
95-th percentile	361
Maximum	8418
Range	8117
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	1034.1893
Coefficient of variation (CV)	2.2993319
Kurtosis	55.278205
Mean	449.77818
Median Absolute Deviation (MAD)	8
Skewness	7.5633415
Sum	1.5411424 × 10⁸
Variance	1069547.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
305	48065	14.0%
313	44540	13.0%
303	39400	11.5%
330	27082	7.9%
316	23277	6.8%
308	18412	5.4%
306	14375	4.2%
324	14059	4.1%
301	13757	4.0%
304	11175	3.3%
Other values (18)	88503	25.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
301	13757	4.0%
302	7534	2.2%
303	39400	11.5%
304	11175	3.3%
305	48065	14.0%
306	14375	4.2%
307	6029	1.8%
308	18412	5.4%
310	3760	1.1%
313	44540	13.0%

Value	Count	Frequency (%)
8418	4650	1.4%
8416	1017	0.3%
1900	228	0.1%
390	948	0.3%
389	3599	1.1%
362	4415	1.3%
361	2472	0.7%
335	3472	1.0%
330	27082	7.9%
329	899	0.3%

TYPERENDE_DIAGNOSE_CD
Text

Distinct	1901
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Length

Max length	4
Median length	3
Mean length	3.3522275
Min length	2

Characters and Unicode

Total characters	1148624
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	99
2nd row	14
3rd row	02
4th row	05
5th row	13

Value	Count	Frequency (%)
101	1460	0.4%
402	1412	0.4%
301	1384	0.4%
403	1379	0.4%
201	1304	0.4%
203	1282	0.4%
401	1155	0.3%
404	1141	0.3%
409	1112	0.3%
802	1108	0.3%
Other values (1891)	329908	96.3%

Most occurring characters

Value	Count	Frequency (%)
1	219569	19.1%
0	211086	18.4%
2	152259	13.3%
3	124332	10.8%
5	88527	7.7%
9	82753	7.2%
4	81406	7.1%
7	67627	5.9%
6	59977	5.2%
8	49455	4.3%
Other values (15)	11633	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1136991	99.0%
Uppercase Letter	11633	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	2175	18.7%
M	1950	16.8%
B	1413	12.1%
Z	1003	8.6%
E	980	8.4%
D	765	6.6%
A	754	6.5%
F	725	6.2%
C	380	3.3%
K	377	3.2%
Other values (5)	1111	9.6%

Decimal Number

Value	Count	Frequency (%)
1	219569	19.3%
0	211086	18.6%
2	152259	13.4%
3	124332	10.9%
5	88527	7.8%
9	82753	7.3%
4	81406	7.2%
7	67627	5.9%
6	59977	5.3%
8	49455	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1136991	99.0%
Latin	11633	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	2175	18.7%
M	1950	16.8%
B	1413	12.1%
Z	1003	8.6%
E	980	8.4%
D	765	6.6%
A	754	6.5%
F	725	6.2%
C	380	3.3%
K	377	3.2%
Other values (5)	1111	9.6%

Common

Value	Count	Frequency (%)
1	219569	19.3%
0	211086	18.6%
2	152259	13.4%
3	124332	10.9%
5	88527	7.8%
9	82753	7.3%
4	81406	7.2%
7	67627	5.9%
6	59977	5.3%
8	49455	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1148624	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	219569	19.1%
0	211086	18.4%
2	152259	13.3%
3	124332	10.8%
5	88527	7.7%
9	82753	7.2%
4	81406	7.1%
7	67627	5.9%
6	59977	5.2%
8	49455	4.3%
Other values (15)	11633	1.0%

ZORGPRODUCT_CD
Real number (ℝ)

Distinct	6179
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4033343 × 10⁸

Minimum	10501002
Maximum	9.9841808 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	10501002
5-th percentile	28999040
Q1	99799058
median	1.4959903 × 10⁸
Q3	9.90004 × 10⁸
95-th percentile	9.9051605 × 10⁸
Maximum	9.9841808 × 10⁸
Range	9.8791708 × 10⁸
Interquartile range (IQR)	8.9020494 × 10⁸

Descriptive statistics

Standard deviation	4.2887002 × 10⁸
Coefficient of variation (CV)	0.97396651
Kurtosis	-1.7351762
Mean	4.4033343 × 10⁸
Median Absolute Deviation (MAD)	1.1960002 × 10⁸
Skewness	0.46986069
Sum	1.5087805 × 10¹⁴
Variance	1.8392949 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
990004009	2526	0.7%
990004007	2474	0.7%
990003004	2353	0.7%
990004006	1988	0.6%
990356076	1830	0.5%
990356073	1690	0.5%
131999228	1680	0.5%
131999164	1656	0.5%
990003007	1534	0.4%
131999194	1502	0.4%
Other values (6169)	323412	94.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10501002	9	< 0.1%
10501003	12	< 0.1%
10501004	12	< 0.1%
10501005	12	< 0.1%
10501007	3	< 0.1%
10501008	12	< 0.1%
10501010	12	< 0.1%
10501011	3	< 0.1%
11101002	11	< 0.1%
11101003	12	< 0.1%

Value	Count	Frequency (%)
998418081	170	< 0.1%
998418080	154	< 0.1%
998418079	39	< 0.1%
998418077	9	< 0.1%
998418076	9	< 0.1%
998418075	7	< 0.1%
998418074	238	0.1%
998418073	240	0.1%
998418072	9	< 0.1%
998418071	9	< 0.1%

AANTAL_PAT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION

Distinct	10395
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	510.68185

Minimum	1
Maximum	165184
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	13
Q3	101
95-th percentile	1718
Maximum	165184
Range	165183
Interquartile range (IQR)	98

Descriptive statistics

Standard deviation	3185.634
Coefficient of variation (CV)	6.2380012
Kurtosis	414.71829
Mean	510.68185
Median Absolute Deviation (MAD)	12
Skewness	16.863148
Sum	1.7498258 × 10⁸
Variance	10148264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	57100	16.7%
2	27817	8.1%
3	18204	5.3%
4	13252	3.9%
5	10445	3.0%
6	8789	2.6%
7	7339	2.1%
8	6160	1.8%
9	5639	1.6%
10	5024	1.5%
Other values (10385)	182876	53.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57100	16.7%
2	27817	8.1%
3	18204	5.3%
4	13252	3.9%
5	10445	3.0%
6	8789	2.6%
7	7339	2.1%
8	6160	1.8%
9	5639	1.6%
10	5024	1.5%

Value	Count	Frequency (%)
165184	1	< 0.1%
162459	1	< 0.1%
156552	1	< 0.1%
155870	1	< 0.1%
154483	1	< 0.1%
154259	1	< 0.1%
144715	1	< 0.1%
118396	1	< 0.1%
115935	1	< 0.1%
113246	1	< 0.1%

AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	11168
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	605.42535

Minimum	1
Maximum	240002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	14
Q3	110
95-th percentile	1963
Maximum	240002
Range	240001
Interquartile range (IQR)	107

Descriptive statistics

Standard deviation	4111.3164
Coefficient of variation (CV)	6.79079
Kurtosis	726.93634
Mean	605.42535
Median Absolute Deviation (MAD)	13
Skewness	21.421218
Sum	2.0744597 × 10⁸
Variance	16902923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	55010	16.1%
2	27342	8.0%
3	18023	5.3%
4	13043	3.8%
5	10370	3.0%
6	8761	2.6%
7	7270	2.1%
8	6107	1.8%
9	5567	1.6%
10	5018	1.5%
Other values (11158)	186134	54.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	55010	16.1%
2	27342	8.0%
3	18023	5.3%
4	13043	3.8%
5	10370	3.0%
6	8761	2.6%
7	7270	2.1%
8	6107	1.8%
9	5567	1.6%
10	5018	1.5%

Value	Count	Frequency (%)
240002	1	< 0.1%
232423	1	< 0.1%
231954	1	< 0.1%
230940	1	< 0.1%
227936	1	< 0.1%
227409	1	< 0.1%
226321	1	< 0.1%
223891	1	< 0.1%
218673	1	< 0.1%
215132	1	< 0.1%

AANTAL_PAT_PER_DIAG
Real number (ℝ)

HIGH CORRELATION

Distinct	9294
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7653.6205

Minimum	1
Maximum	230640
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	38
Q1	384
median	1675
Q3	6204
95-th percentile	36749
Maximum	230640
Range	230639
Interquartile range (IQR)	5820

Descriptive statistics

Standard deviation	17939.359
Coefficient of variation (CV)	2.343905
Kurtosis	34.83263
Mean	7653.6205
Median Absolute Deviation (MAD)	1534
Skewness	5.1117917
Sum	2.6224748 × 10⁹
Variance	3.2182061 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	583	0.2%
8	565	0.2%
9	542	0.2%
19	510	0.1%
12	505	0.1%
26	503	0.1%
25	501	0.1%
15	497	0.1%
14	496	0.1%
5	496	0.1%
Other values (9284)	337447	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	442	0.1%
2	487	0.1%
3	474	0.1%
4	490	0.1%
5	496	0.1%
6	457	0.1%
7	493	0.1%
8	565	0.2%
9	542	0.2%
10	436	0.1%

Value	Count	Frequency (%)
230640	23	< 0.1%
227999	23	< 0.1%
227310	19	< 0.1%
218429	24	< 0.1%
214507	17	< 0.1%
213516	25	< 0.1%
211579	17	< 0.1%
210416	19	< 0.1%
205338	17	< 0.1%
200600	16	< 0.1%

AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)

HIGH CORRELATION

Distinct	10393
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11104.744

Minimum	1
Maximum	370140
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1
5-th percentile	48
Q1	507
median	2333
Q3	9025
95-th percentile	52238
Maximum	370140
Range	370139
Interquartile range (IQR)	8518

Descriptive statistics

Standard deviation	26920.999
Coefficient of variation (CV)	2.4242791
Kurtosis	38.107923
Mean	11104.744
Median Absolute Deviation (MAD)	2152
Skewness	5.3410221
Sum	3.804985 × 10⁹
Variance	7.2474018 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	430	0.1%
11	421	0.1%
25	421	0.1%
13	417	0.1%
10	416	0.1%
8	416	0.1%
23	415	0.1%
33	406	0.1%
3	402	0.1%
5	401	0.1%
Other values (10383)	338500	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	361	0.1%
2	377	0.1%
3	402	0.1%
4	430	0.1%
5	401	0.1%
6	396	0.1%
7	389	0.1%
8	416	0.1%
9	342	0.1%
10	416	0.1%

Value	Count	Frequency (%)
370140	23	< 0.1%
365354	23	< 0.1%
348485	25	< 0.1%
346189	19	< 0.1%
344333	24	< 0.1%
341653	19	< 0.1%
323756	20	< 0.1%
315771	17	< 0.1%
310754	17	< 0.1%
298627	17	< 0.1%

AANTAL_PAT_PER_SPC
Real number (ℝ)

HIGH CORRELATION

Distinct	325
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	665442.76

Minimum	1610
Maximum	1487634
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1610
5-th percentile	40186
Q1	248733
median	765014
Q3	1026304
95-th percentile	1332331
Maximum	1487634
Range	1486024
Interquartile range (IQR)	777571

Descriptive statistics

Standard deviation	422451.07
Coefficient of variation (CV)	0.63484209
Kurtosis	-1.1950283
Mean	665442.76
Median Absolute Deviation (MAD)	318423
Skewness	-0.011052742
Sum	2.2801063 × 10¹¹
Variance	1.7846491 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
880929	5102	1.5%
874090	4354	1.3%
843974	4347	1.3%
894306	4333	1.3%
880469	4273	1.2%
897702	4212	1.2%
765014	4089	1.2%
803539	4027	1.2%
775457	3978	1.2%
1080758	3890	1.1%
Other values (315)	300040	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1610	130	< 0.1%
1829	138	< 0.1%
1920	131	< 0.1%
2032	72	< 0.1%
2495	173	0.1%
2520	190	0.1%
2592	62	< 0.1%
3737	279	0.1%
4096	166	< 0.1%
4765	80	< 0.1%

Value	Count	Frequency (%)
1487634	2975	0.9%
1450392	3048	0.9%
1421709	3564	1.0%
1344286	3543	1.0%
1340600	3441	1.0%
1332331	3545	1.0%
1316381	3463	1.0%
1282937	3576	1.0%
1267090	3350	1.0%
1265242	1177	0.3%

AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)

HIGH CORRELATION

Distinct	325
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1081195

Minimum	1861
Maximum	2664439
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	1861
5-th percentile	46325
Q1	356291
median	1106921
Q3	1776680
95-th percentile	2548284
Maximum	2664439
Range	2662578
Interquartile range (IQR)	1420389

Descriptive statistics

Standard deviation	757875.73
Coefficient of variation (CV)	0.70096118
Kurtosis	-0.85544451
Mean	1081195
Median Absolute Deviation (MAD)	703633
Skewness	0.34368238
Sum	3.7046606 × 10¹¹
Variance	5.7437562 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1211794	5102	1.5%
1281484	4354	1.3%
1216251	4347	1.3%
1315569	4333	1.3%
1300433	4273	1.2%
1341828	4212	1.2%
1155933	4089	1.2%
1205468	4027	1.2%
1143059	3978	1.2%
2548284	3890	1.1%
Other values (315)	300040	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1861	130	< 0.1%
2090	72	< 0.1%
2097	138	< 0.1%
2195	131	< 0.1%
2684	62	< 0.1%
2816	173	0.1%
3288	190	0.1%
3742	279	0.1%
4766	80	< 0.1%
4897	166	< 0.1%

Value	Count	Frequency (%)
2664439	3866	1.1%
2663479	3793	1.1%
2618839	3789	1.1%
2593690	3844	1.1%
2548284	3890	1.1%
2480054	3851	1.1%
2469115	3880	1.1%
2178571	3757	1.1%
2062191	3811	1.1%
2052156	1168	0.3%

GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)

MISSING

Distinct	3618
Distinct (%)	1.3%
Missing	54374
Missing (%)	15.9%
Infinite	0
Infinite (%)	0.0%
Mean	3572.0718

Minimum	70
Maximum	287220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	70
5-th percentile	140
Q1	475
median	1235
Q3	4140
95-th percentile	13520
Maximum	287220
Range	287150
Interquartile range (IQR)	3665

Descriptive statistics

Standard deviation	6515.0513
Coefficient of variation (CV)	1.8238859
Kurtosis	140.86348
Mean	3572.0718
Median Absolute Deviation (MAD)	1010
Skewness	7.070028
Sum	1.0297247 × 10⁹
Variance	42445893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
160	2149	0.6%
105	1965	0.6%
185	1800	0.5%
110	1791	0.5%
180	1619	0.5%
175	1501	0.4%
140	1493	0.4%
300	1429	0.4%
145	1371	0.4%
125	1371	0.4%
Other values (3608)	271782	79.3%
(Missing)	54374	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
70	226	0.1%
75	75	< 0.1%
80	362	0.1%
85	919	0.3%
90	664	0.2%
95	734	0.2%
100	1012	0.3%
105	1965	0.6%
110	1791	0.5%
115	1128	0.3%

Value	Count	Frequency (%)
287220	8	< 0.1%
148910	3	< 0.1%
142835	4	< 0.1%
122155	4	< 0.1%
116765	3	< 0.1%
109725	7	< 0.1%
108570	7	< 0.1%
107655	4	< 0.1%
101270	8	< 0.1%
99590	5	< 0.1%

Auto

Heatmap
Table

	BEHANDELEND_SPECIALISME_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
BEHANDELEND_SPECIALISME_CD	1.000	0.215	0.007	0.012	-0.061	-0.055	-0.536	-0.458	0.051
ZORGPRODUCT_CD	0.215	1.000	-0.139	-0.147	-0.175	-0.205	-0.359	-0.387	0.028
AANTAL_PAT_PER_ZPD	0.007	-0.139	1.000	0.996	0.328	0.326	0.087	0.094	-0.297
AANTAL_SUBTRAJECT_PER_ZPD	0.012	-0.147	0.996	1.000	0.325	0.327	0.090	0.102	-0.300
AANTAL_PAT_PER_DIAG	-0.061	-0.175	0.328	0.325	1.000	0.988	0.346	0.328	0.034
AANTAL_SUBTRAJECT_PER_DIAG	-0.055	-0.205	0.326	0.327	0.988	1.000	0.362	0.360	0.043
AANTAL_PAT_PER_SPC	-0.536	-0.359	0.087	0.090	0.346	0.362	1.000	0.963	-0.004
AANTAL_SUBTRAJECT_PER_SPC	-0.458	-0.387	0.094	0.102	0.328	0.360	0.963	1.000	-0.005
GEMIDDELDE_VERKOOPPRIJS	0.051	0.028	-0.297	-0.300	0.034	0.043	-0.004	-0.005	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
0	1.0	2023-09-10	2023-09-01	2018-01-01	329	99	990029011	141	141	3708	3848	21981	24168	545.0
1	1.0	2023-09-10	2023-09-01	2018-01-01	329	14	990029010	4	4	97	97	21981	24168	1345.0
2	1.0	2023-09-10	2023-09-01	2018-01-01	329	02	990029011	1375	1386	4872	4977	21981	24168	545.0
3	1.0	2023-09-10	2023-09-01	2018-01-01	329	05	990029010	256	261	1285	1346	21981	24168	1345.0
4	1.0	2023-09-10	2023-09-01	2018-01-01	329	13	990029002	6	6	156	157	21981	24168	205.0
5	1.0	2023-09-10	2023-09-01	2018-01-01	329	07	990029011	676	690	1439	1500	21981	24168	545.0
6	1.0	2023-09-10	2023-09-01	2018-01-01	329	19	59899067	11	12	152	285	21981	24168	1440.0
7	1.0	2023-09-10	2023-09-01	2018-01-01	329	12	990029012	34	34	114	120	21981	24168	1040.0
8	1.0	2023-09-10	2023-09-01	2018-01-01	329	14	990029011	61	61	97	97	21981	24168	545.0
9	1.0	2023-09-10	2023-09-01	2018-01-01	329	10	990029002	14	14	93	99	21981	24168	205.0

	VERSIE	DATUM_BESTAND	PEILDATUM	JAAR	BEHANDELEND_SPECIALISME_CD	TYPERENDE_DIAGNOSE_CD	ZORGPRODUCT_CD	AANTAL_PAT_PER_ZPD	AANTAL_SUBTRAJECT_PER_ZPD	AANTAL_PAT_PER_DIAG	AANTAL_SUBTRAJECT_PER_DIAG	AANTAL_PAT_PER_SPC	AANTAL_SUBTRAJECT_PER_SPC	GEMIDDELDE_VERKOOPPRIJS
342635	1.0	2023-09-10	2023-09-01	2014-01-01	303	413	99799008	3	3	217	242	1421709	1845606	1975.0
342636	1.0	2023-09-10	2023-09-01	2020-01-01	320	804	979001219	2	2	22933	40323	1030994	1831098	8335.0
342637	1.0	2023-09-10	2023-09-01	2020-01-01	313	842	29499004	2	2	5022	22342	1047048	2618839	9110.0
342638	1.0	2023-09-10	2023-09-01	2014-01-01	303	335	29199031	1	1	12848	17619	1421709	1845606	4125.0
342639	1.0	2023-09-10	2023-09-01	2020-01-01	313	020	131999154	2	2	3001	3805	1047048	2618839	965.0
342640	1.0	2023-09-10	2023-09-01	2020-01-01	313	434	79799011	1	1	342	494	1047048	2618839	2455.0
342641	1.0	2023-09-10	2023-09-01	2014-01-01	303	334	29199075	1	1	7963	9879	1421709	1845606	630.0
342642	1.0	2023-09-10	2023-09-01	2014-01-01	303	131	131999100	2	2	1920	2189	1421709	1845606	3605.0
342643	1.0	2023-09-10	2023-09-01	2014-01-01	303	249	199299067	1	1	884	958	1421709	1845606	2470.0
342644	1.0	2023-09-10	2023-09-01	2016-01-01	307	M13	20108056	1	1	3259	6267	701349	1185655	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample