Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 352283 |
| Missing cells | 53813 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.6 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-04-15" | Constant |
PEILDATUM has constant value "2024-04-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 53813 (15.3%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.06362552) | Skewed |
Reproduction
| Analysis started | 2024-05-06 23:57:50.839297 |
|---|---|
| Analysis finished | 2024-05-06 23:58:09.725254 |
| Duration | 18.89 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.7 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1056849 |
|---|---|
| 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 | 352283 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 352283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 352283 | |
| . | 352283 | |
| 0 | 352283 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1056849 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 352283 | |
| . | 352283 | |
| 0 | 352283 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1056849 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 352283 | |
| . | 352283 | |
| 0 | 352283 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1056849 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 352283 | |
| . | 352283 | |
| 0 | 352283 |
DATUM_BESTAND
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| 2024-04-15 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3522830 |
|---|---|
| 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-04-15 |
|---|---|
| 2nd row | 2024-04-15 |
| 3rd row | 2024-04-15 |
| 4th row | 2024-04-15 |
| 5th row | 2024-04-15 |
Common Values
| Value | Count | Frequency (%) |
| 2024-04-15 | 352283 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-04-15 | 352283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 704566 | |
| 0 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | |
| 5 | 352283 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 704566 | |
| 0 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | |
| 5 | 352283 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 704566 | |
| 0 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | |
| 5 | 352283 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 704566 | |
| 0 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | |
| 5 | 352283 |
PEILDATUM
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| 2024-04-01 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3522830 |
|---|---|
| Distinct characters | 5 |
| 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-04-01 |
|---|---|
| 2nd row | 2024-04-01 |
| 3rd row | 2024-04-01 |
| 4th row | 2024-04-01 |
| 5th row | 2024-04-01 |
Common Values
| Value | Count | Frequency (%) |
| 2024-04-01 | 352283 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-04-01 | 352283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1056849 | |
| 2 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1056849 | |
| 2 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1056849 | |
| 2 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3522830 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1056849 | |
| 2 | 704566 | |
| 4 | 704566 | |
| - | 704566 | |
| 1 | 352283 | 10.0% |
JAAR
Date
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 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 | 454.54837 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 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 | 1052.1806 |
|---|---|
| Coefficient of variation (CV) | 2.3147825 |
| Kurtosis | 53.20448 |
| Mean | 454.54837 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.4253593 |
| Sum | 1.6012966 × 108 |
| Variance | 1107084.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 49543 | |
| 313 | 45692 | |
| 303 | 40550 | |
| 330 | 27660 | 7.9% |
| 316 | 23910 | 6.8% |
| 308 | 19242 | 5.5% |
| 306 | 14785 | 4.2% |
| 324 | 14454 | 4.1% |
| 301 | 13995 | 4.0% |
| 304 | 11400 | 3.2% |
| Other values (18) | 91052 |
| Value | Count | Frequency (%) |
| 301 | 13995 | 4.0% |
| 302 | 7732 | 2.2% |
| 303 | 40550 | |
| 304 | 11400 | 3.2% |
| 305 | 49543 | |
| 306 | 14785 | 4.2% |
| 307 | 6185 | 1.8% |
| 308 | 19242 | 5.5% |
| 310 | 3868 | 1.1% |
| 313 | 45692 |
| Value | Count | Frequency (%) |
| 8418 | 4819 | 1.4% |
| 8416 | 1216 | 0.3% |
| 1900 | 232 | 0.1% |
| 390 | 960 | 0.3% |
| 389 | 3701 | 1.1% |
| 362 | 4513 | 1.3% |
| 361 | 2567 | 0.7% |
| 335 | 3535 | 1.0% |
| 330 | 27660 | |
| 329 | 912 | 0.3% |
| Distinct | 1904 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3534176 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1181352 |
|---|---|
| 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 | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 203 |
|---|---|
| 2nd row | B13 |
| 3rd row | 104 |
| 4th row | G14 |
| 5th row | 605 |
| Value | Count | Frequency (%) |
| 101 | 1511 | 0.4% |
| 402 | 1442 | 0.4% |
| 301 | 1414 | 0.4% |
| 403 | 1411 | 0.4% |
| 201 | 1347 | 0.4% |
| 203 | 1313 | 0.4% |
| 401 | 1176 | 0.3% |
| 404 | 1168 | 0.3% |
| 802 | 1140 | 0.3% |
| 409 | 1139 | 0.3% |
| Other values (1894) | 339222 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 225950 | |
| 0 | 217116 | |
| 2 | 156615 | |
| 3 | 127667 | |
| 5 | 91217 | |
| 9 | 84947 | 7.2% |
| 4 | 83557 | 7.1% |
| 7 | 69676 | 5.9% |
| 6 | 61725 | 5.2% |
| 8 | 50933 | 4.3% |
| Other values (15) | 11949 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1181352 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225950 | |
| 0 | 217116 | |
| 2 | 156615 | |
| 3 | 127667 | |
| 5 | 91217 | |
| 9 | 84947 | 7.2% |
| 4 | 83557 | 7.1% |
| 7 | 69676 | 5.9% |
| 6 | 61725 | 5.2% |
| 8 | 50933 | 4.3% |
| Other values (15) | 11949 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1181352 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225950 | |
| 0 | 217116 | |
| 2 | 156615 | |
| 3 | 127667 | |
| 5 | 91217 | |
| 9 | 84947 | 7.2% |
| 4 | 83557 | 7.1% |
| 7 | 69676 | 5.9% |
| 6 | 61725 | 5.2% |
| 8 | 50933 | 4.3% |
| Other values (15) | 11949 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1181352 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225950 | |
| 0 | 217116 | |
| 2 | 156615 | |
| 3 | 127667 | |
| 5 | 91217 | |
| 9 | 84947 | 7.2% |
| 4 | 83557 | 7.1% |
| 7 | 69676 | 5.9% |
| 6 | 61725 | 5.2% |
| 8 | 50933 | 4.3% |
| Other values (15) | 11949 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6259 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.419992 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99899016 |
| median | 1.49899 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9010401 × 108 |
Descriptive statistics
| Standard deviation | 4.2919922 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97104072 |
| Kurtosis | -1.742799 |
| Mean | 4.419992 × 108 |
| Median Absolute Deviation (MAD) | 1.199 × 108 |
| Skewness | 0.46192766 |
| Sum | 1.557088 × 1014 |
| Variance | 1.8421197 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2539 | 0.7% |
| 990004007 | 2503 | 0.7% |
| 990003004 | 2442 | 0.7% |
| 990004006 | 2054 | 0.6% |
| 990356076 | 1858 | 0.5% |
| 990356073 | 1733 | 0.5% |
| 131999228 | 1714 | 0.5% |
| 131999164 | 1691 | 0.5% |
| 990003007 | 1579 | 0.4% |
| 131999194 | 1542 | 0.4% |
| Other values (6249) | 332628 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 13 | |
| 10501011 | 4 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 179 | |
| 998418080 | 164 | |
| 998418079 | 40 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 241 | |
| 998418073 | 241 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10725 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 526.4239 |
| Minimum | 1 |
|---|---|
| Maximum | 168842 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 106 |
| 95-th percentile | 1793.9 |
| Maximum | 168842 |
| Range | 168841 |
| Interquartile range (IQR) | 103 |
Descriptive statistics
| Standard deviation | 3234.5378 |
|---|---|
| Coefficient of variation (CV) | 6.1443598 |
| Kurtosis | 403.58583 |
| Mean | 526.4239 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 16.593281 |
| Sum | 1.8545019 × 108 |
| Variance | 10462235 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57984 | 16.5% |
| 2 | 28312 | 8.0% |
| 3 | 18527 | 5.3% |
| 4 | 13563 | 3.9% |
| 5 | 10624 | 3.0% |
| 6 | 8942 | 2.5% |
| 7 | 7465 | 2.1% |
| 8 | 6272 | 1.8% |
| 9 | 5728 | 1.6% |
| 10 | 5170 | 1.5% |
| Other values (10715) | 189696 |
| Value | Count | Frequency (%) |
| 1 | 57984 | |
| 2 | 28312 | |
| 3 | 18527 | 5.3% |
| 4 | 13563 | 3.9% |
| 5 | 10624 | 3.0% |
| 6 | 8942 | 2.5% |
| 7 | 7465 | 2.1% |
| 8 | 6272 | 1.8% |
| 9 | 5728 | 1.6% |
| 10 | 5170 | 1.5% |
| Value | Count | Frequency (%) |
| 168842 | 1 | |
| 165184 | 1 | |
| 163743 | 1 | |
| 155869 | 1 | |
| 154640 | 1 | |
| 154258 | 1 | |
| 144714 | 1 | |
| 121067 | 1 | |
| 118396 | 1 | |
| 115934 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11514 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 625.08623 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 15 |
| Q3 | 116 |
| 95-th percentile | 2052.9 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 113 |
Descriptive statistics
| Standard deviation | 4181.9167 |
|---|---|
| Coefficient of variation (CV) | 6.6901436 |
| Kurtosis | 702.3786 |
| Mean | 625.08623 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 21.063626 |
| Sum | 2.2020725 × 108 |
| Variance | 17488427 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55772 | 15.8% |
| 2 | 27789 | 7.9% |
| 3 | 18378 | 5.2% |
| 4 | 13352 | 3.8% |
| 5 | 10514 | 3.0% |
| 6 | 8919 | 2.5% |
| 7 | 7411 | 2.1% |
| 8 | 6182 | 1.8% |
| 9 | 5690 | 1.6% |
| 10 | 5141 | 1.5% |
| Other values (11504) | 193135 |
| Value | Count | Frequency (%) |
| 1 | 55772 | |
| 2 | 27789 | |
| 3 | 18378 | 5.2% |
| 4 | 13352 | 3.8% |
| 5 | 10514 | 3.0% |
| 6 | 8919 | 2.5% |
| 7 | 7411 | 2.1% |
| 8 | 6182 | 1.8% |
| 9 | 5690 | 1.6% |
| 10 | 5141 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231945 | 1 | |
| 230943 | 1 | |
| 227921 | 1 | |
| 227409 | 1 | |
| 226679 | 1 | |
| 223889 | 1 | |
| 218673 | 1 | |
| 215400 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9627 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7906.2921 |
| Minimum | 1 |
|---|---|
| Maximum | 240850 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 42 |
| Q1 | 417 |
| median | 1787 |
| Q3 | 6613 |
| 95-th percentile | 37539 |
| Maximum | 240850 |
| Range | 240849 |
| Interquartile range (IQR) | 6196 |
Descriptive statistics
| Standard deviation | 18197.228 |
|---|---|
| Coefficient of variation (CV) | 2.3016134 |
| Kurtosis | 33.882692 |
| Mean | 7906.2921 |
| Median Absolute Deviation (MAD) | 1627 |
| Skewness | 5.0292428 |
| Sum | 2.7852523 × 109 |
| Variance | 3.3113911 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 580 | 0.2% |
| 26 | 517 | 0.1% |
| 8 | 507 | 0.1% |
| 25 | 494 | 0.1% |
| 2 | 492 | 0.1% |
| 19 | 486 | 0.1% |
| 9 | 478 | 0.1% |
| 14 | 478 | 0.1% |
| 4 | 475 | 0.1% |
| 17 | 474 | 0.1% |
| Other values (9617) | 347302 |
| Value | Count | Frequency (%) |
| 1 | 471 | |
| 2 | 492 | |
| 3 | 422 | |
| 4 | 475 | |
| 5 | 472 | |
| 6 | 470 | |
| 7 | 438 | |
| 8 | 507 | |
| 9 | 478 | |
| 10 | 410 |
| Value | Count | Frequency (%) |
| 240850 | 22 | |
| 232879 | 23 | |
| 227997 | 23 | |
| 218546 | 24 | |
| 214503 | 17 | |
| 213515 | 25 | |
| 211576 | 17 | |
| 210414 | 19 | |
| 205336 | 17 | |
| 200599 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10785 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11506.598 |
| Minimum | 1 |
|---|---|
| Maximum | 377812 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 54 |
| Q1 | 558 |
| median | 2491 |
| Q3 | 9452 |
| 95-th percentile | 54027 |
| Maximum | 377812 |
| Range | 377811 |
| Interquartile range (IQR) | 8894 |
Descriptive statistics
| Standard deviation | 27358.537 |
|---|---|
| Coefficient of variation (CV) | 2.3776391 |
| Kurtosis | 37.024565 |
| Mean | 11506.598 |
| Median Absolute Deviation (MAD) | 2286 |
| Skewness | 5.2521101 |
| Sum | 4.0535788 × 109 |
| Variance | 7.4848954 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 442 | 0.1% |
| 21 | 399 | 0.1% |
| 6 | 398 | 0.1% |
| 34 | 388 | 0.1% |
| 77 | 383 | 0.1% |
| 4 | 382 | 0.1% |
| 39 | 379 | 0.1% |
| 23 | 379 | 0.1% |
| 1 | 378 | 0.1% |
| 20 | 378 | 0.1% |
| Other values (10775) | 348377 |
| Value | Count | Frequency (%) |
| 1 | 378 | |
| 2 | 364 | |
| 3 | 352 | |
| 4 | 382 | |
| 5 | 364 | |
| 6 | 398 | |
| 7 | 366 | |
| 8 | 336 | |
| 9 | 275 | |
| 10 | 357 |
| Value | Count | Frequency (%) |
| 377812 | 22 | |
| 370304 | 23 | |
| 370137 | 23 | |
| 348482 | 25 | |
| 344907 | 24 | |
| 341651 | 19 | |
| 323753 | 20 | |
| 315768 | 17 | |
| 310748 | 17 | |
| 298625 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 344 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 686051.01 |
| Minimum | 1 |
|---|---|
| Maximum | 1487625 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 43323 |
| Q1 | 299319 |
| median | 768371 |
| Q3 | 1027867 |
| 95-th percentile | 1332254 |
| Maximum | 1487625 |
| Range | 1487624 |
| Interquartile range (IQR) | 728548 |
Descriptive statistics
| Standard deviation | 409425.82 |
|---|---|
| Coefficient of variation (CV) | 0.59678626 |
| Kurtosis | -1.0754111 |
| Mean | 686051.01 |
| Median Absolute Deviation (MAD) | 312115 |
| Skewness | -0.07081738 |
| Sum | 2.4168411 × 1011 |
| Variance | 1.676295 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880922 | 5102 | 1.4% |
| 874080 | 4354 | 1.2% |
| 843975 | 4347 | 1.2% |
| 894296 | 4333 | 1.2% |
| 880447 | 4273 | 1.2% |
| 897684 | 4212 | 1.2% |
| 764999 | 4089 | 1.2% |
| 809510 | 4042 | 1.1% |
| 804294 | 4031 | 1.1% |
| 1067371 | 3925 | 1.1% |
| Other values (334) | 309575 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 3 | 5 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 7 | < 0.1% |
| 26 | 15 | |
| 34 | 13 | < 0.1% |
| 36 | 8 | < 0.1% |
| 43 | 12 | < 0.1% |
| 179 | 17 | |
| 252 | 37 |
| Value | Count | Frequency (%) |
| 1487625 | 2975 | |
| 1450388 | 3048 | |
| 1421694 | 3564 | |
| 1344168 | 3543 | |
| 1340471 | 3441 | |
| 1332254 | 3545 | |
| 1327142 | 3412 | |
| 1316252 | 3463 | |
| 1282927 | 3576 | |
| 1269137 | 3352 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 345 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1117599.6 |
| Minimum | 2 |
|---|---|
| Maximum | 2668791 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 46387 |
| Q1 | 517727 |
| median | 1142111 |
| Q3 | 1812960 |
| 95-th percentile | 2592884 |
| Maximum | 2668791 |
| Range | 2668789 |
| Interquartile range (IQR) | 1295233 |
Descriptive statistics
| Standard deviation | 741121.4 |
|---|---|
| Coefficient of variation (CV) | 0.66313677 |
| Kurtosis | -0.7690712 |
| Mean | 1117599.6 |
| Median Absolute Deviation (MAD) | 645559 |
| Skewness | 0.32289587 |
| Sum | 3.9371135 × 1011 |
| Variance | 5.4926094 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211797 | 5102 | 1.4% |
| 1281474 | 4354 | 1.2% |
| 1216248 | 4347 | 1.2% |
| 1315550 | 4333 | 1.2% |
| 1300408 | 4273 | 1.2% |
| 1341792 | 4212 | 1.2% |
| 1155925 | 4089 | 1.2% |
| 1221152 | 4042 | 1.1% |
| 1207076 | 4031 | 1.1% |
| 2645380 | 3925 | 1.1% |
| Other values (335) | 309575 |
| Value | Count | Frequency (%) |
| 2 | 2 | < 0.1% |
| 3 | 5 | < 0.1% |
| 7 | 5 | < 0.1% |
| 9 | 7 | |
| 26 | 10 | |
| 27 | 5 | < 0.1% |
| 36 | 8 | |
| 41 | 13 | |
| 43 | 12 | |
| 184 | 17 |
| Value | Count | Frequency (%) |
| 2668791 | 3796 | |
| 2663609 | 3866 | |
| 2645380 | 3925 | |
| 2618102 | 3788 | |
| 2592884 | 3843 | |
| 2547611 | 3890 | |
| 2479456 | 3851 | |
| 2178171 | 3757 | |
| 2061888 | 3811 | |
| 2051811 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3732 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 53813 |
| Missing (%) | 15.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3651.713 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 485 |
| median | 1275 |
| Q3 | 4245 |
| 95-th percentile | 13915 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3760 |
Descriptive statistics
| Standard deviation | 6608.5177 |
|---|---|
| Coefficient of variation (CV) | 1.8097035 |
| Kurtosis | 130.78242 |
| Mean | 3651.713 |
| Median Absolute Deviation (MAD) | 1045 |
| Skewness | 6.8474728 |
| Sum | 1.0899268 × 109 |
| Variance | 43672506 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2043 | 0.6% |
| 105 | 1983 | 0.6% |
| 110 | 1791 | 0.5% |
| 180 | 1646 | 0.5% |
| 185 | 1567 | 0.4% |
| 140 | 1550 | 0.4% |
| 125 | 1527 | 0.4% |
| 175 | 1469 | 0.4% |
| 165 | 1435 | 0.4% |
| 300 | 1427 | 0.4% |
| Other values (3722) | 282032 | |
| (Missing) | 53813 | 15.3% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 670 | 0.2% |
| 95 | 716 | 0.2% |
| 100 | 1026 | |
| 105 | 1983 | |
| 110 | 1791 | |
| 115 | 1177 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 107390 | 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.313 | 0.322 | 0.987 | 0.297 | 0.318 | -0.062 | 0.028 | -0.179 |
| AANTAL_PAT_PER_SPC | 0.313 | 1.000 | 0.069 | 0.326 | 0.961 | 0.071 | -0.560 | -0.010 | -0.383 |
| AANTAL_PAT_PER_ZPD | 0.322 | 0.069 | 1.000 | 0.320 | 0.078 | 0.996 | 0.008 | -0.304 | -0.141 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.987 | 0.326 | 0.320 | 1.000 | 0.327 | 0.320 | -0.056 | 0.037 | -0.212 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.297 | 0.961 | 0.078 | 0.327 | 1.000 | 0.084 | -0.481 | -0.012 | -0.414 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.318 | 0.071 | 0.996 | 0.320 | 0.084 | 1.000 | 0.013 | -0.307 | -0.149 |
| BEHANDELEND_SPECIALISME_CD | -0.062 | -0.560 | 0.008 | -0.056 | -0.481 | 0.013 | 1.000 | 0.045 | 0.215 |
| GEMIDDELDE_VERKOOPPRIJS | 0.028 | -0.010 | -0.304 | 0.037 | -0.012 | -0.307 | 0.045 | 1.000 | 0.029 |
| ZORGPRODUCT_CD | -0.179 | -0.383 | -0.141 | -0.212 | -0.414 | -0.149 | 0.215 | 0.029 | 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-04-15 | 2024-04-01 | 2021-01-01 | 318 | 203 | 119499078 | 14213 | 16904 | 44133 | 58881 | 560226 | 832680 | 280.0 |
| 1 | 1.0 | 2024-04-15 | 2024-04-01 | 2020-01-01 | 307 | B13 | 159899007 | 102 | 102 | 118 | 118 | 677776 | 1128999 | 4455.0 |
| 2 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 361 | 104 | 990061029 | 1574 | 2000 | 3439 | 5157 | 95133 | 142589 | 195.0 |
| 3 | 1.0 | 2024-04-15 | 2024-04-01 | 2020-01-01 | 307 | G14 | 990003024 | 67 | 67 | 19592 | 20820 | 677776 | 1128999 | 150.0 |
| 4 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 318 | 605 | 119499075 | 529 | 574 | 5831 | 7354 | 560226 | 832680 | 705.0 |
| 5 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 361 | 108 | 990061018 | 197 | 197 | 2214 | 2710 | 95133 | 142589 | 310.0 |
| 6 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 318 | 407 | 29199206 | 412 | 479 | 1946 | 2618 | 560226 | 832680 | 195.0 |
| 7 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 318 | 605 | 119499076 | 82 | 90 | 5831 | 7354 | 560226 | 832680 | 720.0 |
| 8 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 318 | 713 | 990003008 | 9 | 9 | 2015 | 3600 | 560226 | 832680 | 160.0 |
| 9 | 1.0 | 2024-04-15 | 2024-04-01 | 2021-01-01 | 361 | 201 | 990061072 | 81 | 87 | 1365 | 1758 | 95133 | 142589 | 7390.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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 352273 | 1.0 | 2024-04-15 | 2024-04-01 | 2014-01-01 | 313 | 762 | 28999024 | 1 | 1 | 299 | 2397 | 1037157 | 2061888 | 25040.0 |
| 352274 | 1.0 | 2024-04-15 | 2024-04-01 | 2015-01-01 | 322 | 1307 | 29099051 | 1 | 1 | 3154 | 4681 | 442134 | 759714 | NaN |
| 352275 | 1.0 | 2024-04-15 | 2024-04-01 | 2014-01-01 | 313 | 832 | 20109081 | 3 | 3 | 4720 | 18327 | 1037157 | 2061888 | NaN |
| 352276 | 1.0 | 2024-04-15 | 2024-04-01 | 2012-01-01 | 303 | 434 | 99699088 | 2 | 2 | 902 | 1012 | 1487625 | 1939511 | 1505.0 |
| 352277 | 1.0 | 2024-04-15 | 2024-04-01 | 2016-01-01 | 303 | 269 | 199299087 | 1 | 1 | 4540 | 5248 | 1332254 | 1831326 | 2575.0 |
| 352278 | 1.0 | 2024-04-15 | 2024-04-01 | 2016-01-01 | 303 | 212 | 199299062 | 1 | 1 | 39064 | 44560 | 1332254 | 1831326 | 5450.0 |
| 352279 | 1.0 | 2024-04-15 | 2024-04-01 | 2014-01-01 | 313 | 263 | 29699006 | 1 | 1 | 1743 | 2262 | 1037157 | 2061888 | 4865.0 |
| 352280 | 1.0 | 2024-04-15 | 2024-04-01 | 2016-01-01 | 303 | 237 | 199299063 | 1 | 1 | 1500 | 1744 | 1332254 | 1831326 | 3380.0 |
| 352281 | 1.0 | 2024-04-15 | 2024-04-01 | 2014-01-01 | 313 | 779 | 979003008 | 1 | 1 | 777 | 1239 | 1037157 | 2061888 | 7560.0 |
| 352282 | 1.0 | 2024-04-15 | 2024-04-01 | 2015-01-01 | 322 | 1103 | 990011003 | 1 | 1 | 23601 | 27215 | 442134 | 759714 | 3405.0 |