Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 363659 |
| Missing cells | 59122 |
| Missing cells (%) | 1.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 38.8 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 3 |
|---|---|
| DateTime | 1 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "1.0" | Constant |
DATUM_BESTAND has constant value "2024-06-21" | Constant |
PEILDATUM has constant value "2024-06-01" | Constant |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with AANTAL_SUBTRAJECT_PER_SPC and 1 other fields | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 59122 (16.3%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.23686011) | Skewed |
Reproduction
| Analysis started | 2024-07-15 18:23:53.095900 |
|---|---|
| Analysis finished | 2024-07-15 18:24:11.317119 |
| Duration | 18.22 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.8 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1090977 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| 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 | 363659 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 363659 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 363659 | |
| . | 363659 | |
| 0 | 363659 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1090977 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 363659 | |
| . | 363659 | |
| 0 | 363659 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1090977 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 363659 | |
| . | 363659 | |
| 0 | 363659 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1090977 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 363659 | |
| . | 363659 | |
| 0 | 363659 |
DATUM_BESTAND
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| 2024-06-21 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3636590 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| 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 | 2024-06-21 |
|---|---|
| 2nd row | 2024-06-21 |
| 3rd row | 2024-06-21 |
| 4th row | 2024-06-21 |
| 5th row | 2024-06-21 |
Common Values
| Value | Count | Frequency (%) |
| 2024-06-21 | 363659 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-06-21 | 363659 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1090977 | |
| 0 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1090977 | |
| 0 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1090977 | |
| 0 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1090977 | |
| 0 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
PEILDATUM
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| 2024-06-01 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3636590 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| 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 | 2024-06-01 |
|---|---|
| 2nd row | 2024-06-01 |
| 3rd row | 2024-06-01 |
| 4th row | 2024-06-01 |
| 5th row | 2024-06-01 |
Common Values
| Value | Count | Frequency (%) |
| 2024-06-01 | 363659 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-06-01 | 363659 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1090977 | |
| 2 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1090977 | |
| 2 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1090977 | |
| 2 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3636590 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1090977 | |
| 2 | 727318 | |
| - | 727318 | |
| 4 | 363659 | 10.0% |
| 6 | 363659 | 10.0% |
| 1 | 363659 | 10.0% |
JAAR
Date
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
Histogram with fixed size bins (bins=13)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 459.25334 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 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 | 1069.5272 |
|---|---|
| Coefficient of variation (CV) | 2.3288393 |
| Kurtosis | 51.300322 |
| Mean | 459.25334 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.2962265 |
| Sum | 1.6701161 × 108 |
| Variance | 1143888.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 50894 | |
| 313 | 47340 | |
| 303 | 41946 | |
| 330 | 28525 | 7.8% |
| 316 | 24589 | 6.8% |
| 308 | 19645 | 5.4% |
| 306 | 15255 | 4.2% |
| 324 | 14776 | 4.1% |
| 301 | 14568 | 4.0% |
| 304 | 11842 | 3.3% |
| Other values (18) | 94279 |
| Value | Count | Frequency (%) |
| 301 | 14568 | 4.0% |
| 302 | 8032 | 2.2% |
| 303 | 41946 | |
| 304 | 11842 | 3.3% |
| 305 | 50894 | |
| 306 | 15255 | 4.2% |
| 307 | 6460 | 1.8% |
| 308 | 19645 | 5.4% |
| 310 | 4029 | 1.1% |
| 313 | 47340 |
| Value | Count | Frequency (%) |
| 8418 | 5016 | 1.4% |
| 8416 | 1425 | 0.4% |
| 1900 | 245 | 0.1% |
| 390 | 1014 | 0.3% |
| 389 | 3821 | 1.1% |
| 362 | 4556 | 1.3% |
| 361 | 2660 | 0.7% |
| 335 | 3641 | 1.0% |
| 330 | 28525 | |
| 329 | 961 | 0.3% |
| Distinct | 1904 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3519286 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1218959 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| 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 | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 07 |
|---|---|
| 2nd row | 02 |
| 3rd row | 16 |
| 4th row | 15 |
| 5th row | 12 |
| Value | Count | Frequency (%) |
| 101 | 1565 | 0.4% |
| 402 | 1508 | 0.4% |
| 301 | 1473 | 0.4% |
| 403 | 1466 | 0.4% |
| 201 | 1404 | 0.4% |
| 203 | 1370 | 0.4% |
| 401 | 1229 | 0.3% |
| 404 | 1222 | 0.3% |
| 409 | 1195 | 0.3% |
| 302 | 1177 | 0.3% |
| Other values (1894) | 350050 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 232938 | |
| 0 | 224357 | |
| 2 | 161521 | |
| 3 | 131847 | |
| 5 | 93986 | |
| 9 | 87818 | 7.2% |
| 4 | 86302 | 7.1% |
| 7 | 71819 | 5.9% |
| 6 | 63463 | 5.2% |
| 8 | 52597 | 4.3% |
| Other values (15) | 12311 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1218959 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 232938 | |
| 0 | 224357 | |
| 2 | 161521 | |
| 3 | 131847 | |
| 5 | 93986 | |
| 9 | 87818 | 7.2% |
| 4 | 86302 | 7.1% |
| 7 | 71819 | 5.9% |
| 6 | 63463 | 5.2% |
| 8 | 52597 | 4.3% |
| Other values (15) | 12311 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1218959 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 232938 | |
| 0 | 224357 | |
| 2 | 161521 | |
| 3 | 131847 | |
| 5 | 93986 | |
| 9 | 87818 | 7.2% |
| 4 | 86302 | 7.1% |
| 7 | 71819 | 5.9% |
| 6 | 63463 | 5.2% |
| 8 | 52597 | 4.3% |
| Other values (15) | 12311 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1218959 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 232938 | |
| 0 | 224357 | |
| 2 | 161521 | |
| 3 | 131847 | |
| 5 | 93986 | |
| 9 | 87818 | 7.2% |
| 4 | 86302 | 7.1% |
| 7 | 71819 | 5.9% |
| 6 | 63463 | 5.2% |
| 8 | 52597 | 4.3% |
| Other values (15) | 12311 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6273 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.3965861 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99799061 |
| median | 1.4959902 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.9051606 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020396 × 108 |
Descriptive statistics
| Standard deviation | 4.2863675 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97493088 |
| Kurtosis | -1.7317419 |
| Mean | 4.3965861 × 108 |
| Median Absolute Deviation (MAD) | 1.1960001 × 108 |
| Skewness | 0.47334058 |
| Sum | 1.5988581 × 1014 |
| Variance | 1.8372947 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2655 | 0.7% |
| 990004007 | 2605 | 0.7% |
| 990003004 | 2505 | 0.7% |
| 990004006 | 2093 | 0.6% |
| 990356076 | 1912 | 0.5% |
| 131999228 | 1850 | 0.5% |
| 131999164 | 1816 | 0.5% |
| 990356073 | 1772 | 0.5% |
| 131999194 | 1606 | 0.4% |
| 990003007 | 1603 | 0.4% |
| Other values (6263) | 343242 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 13 | |
| 10501004 | 13 | |
| 10501005 | 13 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 13 | |
| 10501010 | 13 | |
| 10501011 | 4 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 13 |
| Value | Count | Frequency (%) |
| 998418081 | 182 | |
| 998418080 | 169 | |
| 998418079 | 43 | < 0.1% |
| 998418077 | 10 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 256 | |
| 998418073 | 250 | |
| 998418072 | 10 | < 0.1% |
| 998418071 | 10 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10765 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 518.0186 |
| Minimum | 1 |
|---|---|
| Maximum | 170178 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 101 |
| 95-th percentile | 1749 |
| Maximum | 170178 |
| Range | 170177 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 3222.4851 |
|---|---|
| Coefficient of variation (CV) | 6.2207904 |
| Kurtosis | 413.24108 |
| Mean | 518.0186 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.789918 |
| Sum | 1.8838212 × 108 |
| Variance | 10384410 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 61069 | 16.8% |
| 2 | 29622 | 8.1% |
| 3 | 19352 | 5.3% |
| 4 | 14192 | 3.9% |
| 5 | 11113 | 3.1% |
| 6 | 9311 | 2.6% |
| 7 | 7737 | 2.1% |
| 8 | 6569 | 1.8% |
| 9 | 5943 | 1.6% |
| 10 | 5246 | 1.4% |
| Other values (10755) | 193505 |
| Value | Count | Frequency (%) |
| 1 | 61069 | |
| 2 | 29622 | |
| 3 | 19352 | 5.3% |
| 4 | 14192 | 3.9% |
| 5 | 11113 | 3.1% |
| 6 | 9311 | 2.6% |
| 7 | 7737 | 2.1% |
| 8 | 6569 | 1.8% |
| 9 | 5943 | 1.6% |
| 10 | 5246 | 1.4% |
| Value | Count | Frequency (%) |
| 170178 | 1 | |
| 165182 | 1 | |
| 163757 | 1 | |
| 155868 | 1 | |
| 154637 | 1 | |
| 154256 | 1 | |
| 148457 | 1 | |
| 144711 | 1 | |
| 118396 | 1 | |
| 115934 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11625 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 616.17669 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 110 |
| 95-th percentile | 2002.1 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 107 |
Descriptive statistics
| Standard deviation | 4171.7285 |
|---|---|
| Coefficient of variation (CV) | 6.7703446 |
| Kurtosis | 712.16297 |
| Mean | 616.17669 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.23686 |
| Sum | 2.240782 × 108 |
| Variance | 17403319 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 58799 | 16.2% |
| 2 | 29112 | 8.0% |
| 3 | 19168 | 5.3% |
| 4 | 13949 | 3.8% |
| 5 | 11046 | 3.0% |
| 6 | 9269 | 2.5% |
| 7 | 7689 | 2.1% |
| 8 | 6487 | 1.8% |
| 9 | 5876 | 1.6% |
| 10 | 5264 | 1.4% |
| Other values (11615) | 197000 |
| Value | Count | Frequency (%) |
| 1 | 58799 | |
| 2 | 29112 | |
| 3 | 19168 | 5.3% |
| 4 | 13949 | 3.8% |
| 5 | 11046 | 3.0% |
| 6 | 9269 | 2.5% |
| 7 | 7689 | 2.1% |
| 8 | 6487 | 1.8% |
| 9 | 5876 | 1.6% |
| 10 | 5264 | 1.4% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231945 | 1 | |
| 230943 | 1 | |
| 227921 | 1 | |
| 227409 | 1 | |
| 226680 | 1 | |
| 223889 | 1 | |
| 218673 | 1 | |
| 216113 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9727 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7771.8252 |
| Minimum | 1 |
|---|---|
| Maximum | 242182 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 34 |
| Q1 | 376 |
| median | 1688 |
| Q3 | 6337 |
| 95-th percentile | 37206 |
| Maximum | 242182 |
| Range | 242181 |
| Interquartile range (IQR) | 5961 |
Descriptive statistics
| Standard deviation | 18152.681 |
|---|---|
| Coefficient of variation (CV) | 2.3357037 |
| Kurtosis | 34.648646 |
| Mean | 7771.8252 |
| Median Absolute Deviation (MAD) | 1558 |
| Skewness | 5.0849733 |
| Sum | 2.8262942 × 109 |
| Variance | 3.2951983 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 704 | 0.2% |
| 8 | 649 | 0.2% |
| 21 | 645 | 0.2% |
| 7 | 642 | 0.2% |
| 2 | 641 | 0.2% |
| 5 | 635 | 0.2% |
| 6 | 621 | 0.2% |
| 1 | 612 | 0.2% |
| 9 | 606 | 0.2% |
| 17 | 601 | 0.2% |
| Other values (9717) | 357303 |
| Value | Count | Frequency (%) |
| 1 | 612 | |
| 2 | 641 | |
| 3 | 578 | |
| 4 | 704 | |
| 5 | 635 | |
| 6 | 621 | |
| 7 | 642 | |
| 8 | 649 | |
| 9 | 606 | |
| 10 | 534 |
| Value | Count | Frequency (%) |
| 242182 | 23 | |
| 232901 | 23 | |
| 227994 | 23 | |
| 219673 | 23 | |
| 218543 | 24 | |
| 214503 | 17 | |
| 213512 | 25 | |
| 211575 | 17 | |
| 210411 | 19 | |
| 205335 | 17 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10869 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11354.243 |
| Minimum | 1 |
|---|---|
| Maximum | 381466 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 502 |
| median | 2376 |
| Q3 | 9256 |
| 95-th percentile | 53456 |
| Maximum | 381466 |
| Range | 381465 |
| Interquartile range (IQR) | 8754 |
Descriptive statistics
| Standard deviation | 27376.217 |
|---|---|
| Coefficient of variation (CV) | 2.4111002 |
| Kurtosis | 37.647104 |
| Mean | 11354.243 |
| Median Absolute Deviation (MAD) | 2207 |
| Skewness | 5.2984574 |
| Sum | 4.1290727 × 109 |
| Variance | 7.4945727 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 608 | 0.2% |
| 7 | 557 | 0.2% |
| 6 | 551 | 0.2% |
| 5 | 526 | 0.1% |
| 2 | 518 | 0.1% |
| 1 | 514 | 0.1% |
| 25 | 501 | 0.1% |
| 3 | 500 | 0.1% |
| 20 | 494 | 0.1% |
| 10 | 491 | 0.1% |
| Other values (10859) | 358399 |
| Value | Count | Frequency (%) |
| 1 | 514 | |
| 2 | 518 | |
| 3 | 500 | |
| 4 | 608 | |
| 5 | 526 | |
| 6 | 551 | |
| 7 | 557 | |
| 8 | 459 | |
| 9 | 407 | |
| 10 | 491 |
| Value | Count | Frequency (%) |
| 381466 | 23 | |
| 370347 | 23 | |
| 370131 | 23 | |
| 348474 | 25 | |
| 344901 | 24 | |
| 341645 | 19 | |
| 326868 | 23 | |
| 323745 | 20 | |
| 315768 | 17 | |
| 310748 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 352 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 674025.51 |
| Minimum | 285 |
|---|---|
| Maximum | 1487620 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 285 |
|---|---|
| 5-th percentile | 32812 |
| Q1 | 277886 |
| median | 764996 |
| Q3 | 1029694 |
| 95-th percentile | 1337689 |
| Maximum | 1487620 |
| Range | 1487335 |
| Interquartile range (IQR) | 751808 |
Descriptive statistics
| Standard deviation | 420331.07 |
|---|---|
| Coefficient of variation (CV) | 0.623613 |
| Kurtosis | -1.1398073 |
| Mean | 674025.51 |
| Median Absolute Deviation (MAD) | 316347 |
| Skewness | -0.071471056 |
| Sum | 2.4511544 × 1011 |
| Variance | 1.7667821 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880920 | 5102 | 1.4% |
| 874077 | 4354 | 1.2% |
| 843969 | 4347 | 1.2% |
| 894295 | 4333 | 1.2% |
| 880446 | 4273 | 1.2% |
| 897681 | 4212 | 1.2% |
| 764996 | 4089 | 1.1% |
| 813658 | 4045 | 1.1% |
| 804363 | 4031 | 1.1% |
| 1072183 | 3932 | 1.1% |
| Other values (342) | 320941 |
| Value | Count | Frequency (%) |
| 285 | 53 | < 0.1% |
| 299 | 76 | < 0.1% |
| 710 | 49 | < 0.1% |
| 809 | 192 | |
| 853 | 120 | |
| 1015 | 13 | < 0.1% |
| 1317 | 34 | < 0.1% |
| 1418 | 95 | < 0.1% |
| 1610 | 130 | |
| 1683 | 283 |
| Value | Count | Frequency (%) |
| 1487620 | 2975 | |
| 1450382 | 3048 | |
| 1421693 | 3564 | |
| 1344144 | 3543 | |
| 1340452 | 3441 | |
| 1337689 | 3416 | |
| 1332329 | 3545 | |
| 1316224 | 3463 | |
| 1282921 | 3576 | |
| 1269157 | 3352 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1102383.2 |
| Minimum | 285 |
|---|---|
| Maximum | 2668531 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 285 |
|---|---|
| 5-th percentile | 41738 |
| Q1 | 457234 |
| median | 1107036 |
| Q3 | 1810303 |
| 95-th percentile | 2592589 |
| Maximum | 2668531 |
| Range | 2668246 |
| Interquartile range (IQR) | 1353069 |
Descriptive statistics
| Standard deviation | 758055.69 |
|---|---|
| Coefficient of variation (CV) | 0.68765173 |
| Kurtosis | -0.82933535 |
| Mean | 1102383.2 |
| Median Absolute Deviation (MAD) | 697731 |
| Skewness | 0.30855564 |
| Sum | 4.0089156 × 1011 |
| Variance | 5.7464843 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211797 | 5102 | 1.4% |
| 1281473 | 4354 | 1.2% |
| 1216248 | 4347 | 1.2% |
| 1315547 | 4333 | 1.2% |
| 1300405 | 4273 | 1.2% |
| 1341786 | 4212 | 1.2% |
| 1155919 | 4089 | 1.1% |
| 1228790 | 4045 | 1.1% |
| 1207171 | 4031 | 1.1% |
| 2664890 | 3932 | 1.1% |
| Other values (343) | 320941 |
| Value | Count | Frequency (%) |
| 285 | 53 | < 0.1% |
| 299 | 76 | < 0.1% |
| 729 | 49 | < 0.1% |
| 813 | 192 | |
| 1003 | 120 | |
| 1016 | 13 | < 0.1% |
| 1344 | 34 | < 0.1% |
| 1604 | 95 | < 0.1% |
| 1714 | 283 | |
| 1861 | 130 |
| Value | Count | Frequency (%) |
| 2668531 | 3796 | |
| 2664890 | 3932 | |
| 2663293 | 3866 | |
| 2617736 | 3788 | |
| 2592589 | 3843 | |
| 2547364 | 3890 | |
| 2479229 | 3851 | |
| 2248123 | 3852 | |
| 2178002 | 3757 | |
| 2061793 | 3810 |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3754 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 59122 |
| Missing (%) | 16.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3647.0684 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 145 |
| Q1 | 480 |
| median | 1260 |
| Q3 | 4230 |
| 95-th percentile | 13970 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3750 |
Descriptive statistics
| Standard deviation | 6598.1992 |
|---|---|
| Coefficient of variation (CV) | 1.8091789 |
| Kurtosis | 129.45188 |
| Mean | 3647.0684 |
| Median Absolute Deviation (MAD) | 1030 |
| Skewness | 6.8094561 |
| Sum | 1.1106673 × 109 |
| Variance | 43536233 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2105 | 0.6% |
| 105 | 2003 | 0.6% |
| 110 | 1863 | 0.5% |
| 180 | 1668 | 0.5% |
| 185 | 1654 | 0.5% |
| 125 | 1560 | 0.4% |
| 140 | 1560 | 0.4% |
| 145 | 1545 | 0.4% |
| 175 | 1542 | 0.4% |
| 300 | 1442 | 0.4% |
| Other values (3744) | 287595 | |
| (Missing) | 59122 | 16.3% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 920 | |
| 90 | 670 | 0.2% |
| 95 | 723 | 0.2% |
| 100 | 1022 | |
| 105 | 2003 | |
| 110 | 1863 | |
| 115 | 1184 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 107425 | 4 | |
| 101270 | 8 |
| AANTAL_PAT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_SUBTRAJECT_PER_SPC | AANTAL_SUBTRAJECT_PER_ZPD | BEHANDELEND_SPECIALISME_CD | GEMIDDELDE_VERKOOPPRIJS | ZORGPRODUCT_CD | |
|---|---|---|---|---|---|---|---|---|---|
| AANTAL_PAT_PER_DIAG | 1.000 | 0.355 | 0.334 | 0.988 | 0.335 | 0.331 | -0.060 | 0.035 | -0.168 |
| AANTAL_PAT_PER_SPC | 0.355 | 1.000 | 0.093 | 0.367 | 0.960 | 0.095 | -0.534 | -0.001 | -0.359 |
| AANTAL_PAT_PER_ZPD | 0.334 | 0.093 | 1.000 | 0.332 | 0.100 | 0.996 | 0.008 | -0.297 | -0.136 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.988 | 0.367 | 0.332 | 1.000 | 0.365 | 0.333 | -0.053 | 0.043 | -0.200 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.335 | 0.960 | 0.100 | 0.365 | 1.000 | 0.106 | -0.454 | -0.003 | -0.389 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.331 | 0.095 | 0.996 | 0.333 | 0.106 | 1.000 | 0.013 | -0.300 | -0.144 |
| BEHANDELEND_SPECIALISME_CD | -0.060 | -0.534 | 0.008 | -0.053 | -0.454 | 0.013 | 1.000 | 0.049 | 0.213 |
| GEMIDDELDE_VERKOOPPRIJS | 0.035 | -0.001 | -0.297 | 0.043 | -0.003 | -0.300 | 0.049 | 1.000 | 0.030 |
| ZORGPRODUCT_CD | -0.168 | -0.359 | -0.136 | -0.200 | -0.389 | -0.144 | 0.213 | 0.030 | 1.000 |
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.
| 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 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 07 | 990029010 | 227 | 234 | 1439 | 1500 | 21980 | 24166 | 1345.0 |
| 1 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 02 | 990029002 | 246 | 247 | 4872 | 4977 | 21980 | 24166 | 205.0 |
| 2 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 16 | 990029011 | 546 | 577 | 1077 | 1196 | 21980 | 24166 | 545.0 |
| 3 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 15 | 990029012 | 265 | 272 | 1029 | 1075 | 21980 | 24166 | 1040.0 |
| 4 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 12 | 990029011 | 47 | 50 | 114 | 120 | 21980 | 24166 | 545.0 |
| 5 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 03 | 990029002 | 58 | 58 | 847 | 863 | 21980 | 24166 | 205.0 |
| 6 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 07 | 990029011 | 676 | 690 | 1439 | 1500 | 21980 | 24166 | 545.0 |
| 7 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 19 | 59899067 | 11 | 12 | 152 | 284 | 21980 | 24166 | 1440.0 |
| 8 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 08 | 990029010 | 13 | 13 | 162 | 167 | 21980 | 24166 | 1345.0 |
| 9 | 1.0 | 2024-06-21 | 2024-06-01 | 2018-01-01 | 329 | 13 | 990029010 | 30 | 31 | 156 | 157 | 21980 | 24166 | 1345.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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 363649 | 1.0 | 2024-06-21 | 2024-06-01 | 2014-01-01 | 303 | 214 | 990003007 | 2 | 2 | 14959 | 16345 | 1421693 | 1845585 | 105.0 |
| 363650 | 1.0 | 2024-06-21 | 2024-06-01 | 2020-01-01 | 313 | 131 | 99799022 | 1 | 1 | 42 | 60 | 1046663 | 2617736 | NaN |
| 363651 | 1.0 | 2024-06-21 | 2024-06-01 | 2020-01-01 | 320 | 806 | 979001188 | 1 | 1 | 30604 | 41908 | 1030921 | 1831376 | 34420.0 |
| 363652 | 1.0 | 2024-06-21 | 2024-06-01 | 2015-01-01 | 362 | 314 | 990062004 | 1 | 1 | 148 | 154 | 70900 | 81597 | 2900.0 |
| 363653 | 1.0 | 2024-06-21 | 2024-06-01 | 2020-01-01 | 320 | 702 | 979001224 | 1 | 1 | 2227 | 3547 | 1030921 | 1831376 | 3650.0 |
| 363654 | 1.0 | 2024-06-21 | 2024-06-01 | 2020-01-01 | 313 | 831 | 20109107 | 1 | 1 | 4199 | 14244 | 1046663 | 2617736 | NaN |
| 363655 | 1.0 | 2024-06-21 | 2024-06-01 | 2015-01-01 | 362 | 197 | 990062012 | 2 | 2 | 599 | 651 | 70900 | 81597 | 370.0 |
| 363656 | 1.0 | 2024-06-21 | 2024-06-01 | 2014-01-01 | 303 | 213 | 199299059 | 1 | 1 | 7921 | 8583 | 1421693 | 1845585 | 2095.0 |
| 363657 | 1.0 | 2024-06-21 | 2024-06-01 | 2020-01-01 | 313 | 839 | 990003004 | 1 | 1 | 343 | 1203 | 1046663 | 2617736 | 120.0 |
| 363658 | 1.0 | 2024-06-21 | 2024-06-01 | 2016-01-01 | 307 | Z20 | 159999020 | 1 | 1 | 72 | 88 | 701303 | 1185595 | 24045.0 |