Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 351331 |
| Missing cells | 53545 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 37.5 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | 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 53545 (15.2%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.12240234) | Skewed |
Reproduction
| Analysis started | 2024-03-18 18:22:44.872240 |
|---|---|
| Analysis finished | 2024-03-18 18:23:03.362406 |
| Duration | 18.49 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 | 1053993 |
|---|---|
| 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 | 351331 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 351331 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 351331 | |
| . | 351331 | |
| 0 | 351331 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1053993 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 351331 | |
| . | 351331 | |
| 0 | 351331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1053993 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 351331 | |
| . | 351331 | |
| 0 | 351331 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1053993 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 351331 | |
| . | 351331 | |
| 0 | 351331 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2024-03-08 00:00:00 |
|---|---|
| Maximum | 2024-03-08 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.7 MiB |
| Minimum | 2024-03-01 00:00:00 |
|---|---|
| Maximum | 2024-03-01 00:00:00 |
Histogram with fixed size bins (bins=1)
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 | 452.22386 |
| 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 | 1043.5078 |
|---|---|
| Coefficient of variation (CV) | 2.3075028 |
| Kurtosis | 54.191221 |
| Mean | 452.22386 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.4913619 |
| Sum | 1.5888026 × 108 |
| Variance | 1088908.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 49411 | |
| 313 | 45595 | |
| 303 | 40435 | |
| 330 | 27616 | 7.9% |
| 316 | 23857 | 6.8% |
| 308 | 19194 | 5.5% |
| 306 | 14757 | 4.2% |
| 324 | 14443 | 4.1% |
| 301 | 13973 | 4.0% |
| 304 | 11384 | 3.2% |
| Other values (18) | 90666 |
| Value | Count | Frequency (%) |
| 301 | 13973 | 4.0% |
| 302 | 7710 | 2.2% |
| 303 | 40435 | |
| 304 | 11384 | 3.2% |
| 305 | 49411 | |
| 306 | 14757 | 4.2% |
| 307 | 6162 | 1.8% |
| 308 | 19194 | 5.5% |
| 310 | 3821 | 1.1% |
| 313 | 45595 |
| Value | Count | Frequency (%) |
| 8418 | 4723 | 1.3% |
| 8416 | 1195 | 0.3% |
| 1900 | 231 | 0.1% |
| 390 | 960 | 0.3% |
| 389 | 3680 | 1.0% |
| 362 | 4499 | 1.3% |
| 361 | 2554 | 0.7% |
| 335 | 3532 | 1.0% |
| 330 | 27616 | |
| 329 | 910 | 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.3536209 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1178231 |
|---|---|
| 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 | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 203 |
|---|---|
| 2nd row | 501 |
| 3rd row | 309 |
| 4th row | 101 |
| 5th row | 303 |
| Value | Count | Frequency (%) |
| 101 | 1504 | 0.4% |
| 402 | 1437 | 0.4% |
| 301 | 1409 | 0.4% |
| 403 | 1408 | 0.4% |
| 201 | 1337 | 0.4% |
| 203 | 1308 | 0.4% |
| 401 | 1172 | 0.3% |
| 404 | 1167 | 0.3% |
| 802 | 1139 | 0.3% |
| 409 | 1133 | 0.3% |
| Other values (1894) | 338317 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 225353 | |
| 0 | 216500 | |
| 2 | 156197 | |
| 3 | 127334 | |
| 5 | 90956 | |
| 9 | 84751 | 7.2% |
| 4 | 83341 | 7.1% |
| 7 | 69492 | 5.9% |
| 6 | 61579 | 5.2% |
| 8 | 50811 | 4.3% |
| Other values (15) | 11917 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1178231 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225353 | |
| 0 | 216500 | |
| 2 | 156197 | |
| 3 | 127334 | |
| 5 | 90956 | |
| 9 | 84751 | 7.2% |
| 4 | 83341 | 7.1% |
| 7 | 69492 | 5.9% |
| 6 | 61579 | 5.2% |
| 8 | 50811 | 4.3% |
| Other values (15) | 11917 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1178231 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225353 | |
| 0 | 216500 | |
| 2 | 156197 | |
| 3 | 127334 | |
| 5 | 90956 | |
| 9 | 84751 | 7.2% |
| 4 | 83341 | 7.1% |
| 7 | 69492 | 5.9% |
| 6 | 61579 | 5.2% |
| 8 | 50811 | 4.3% |
| Other values (15) | 11917 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1178231 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 225353 | |
| 0 | 216500 | |
| 2 | 156197 | |
| 3 | 127334 | |
| 5 | 90956 | |
| 9 | 84751 | 7.2% |
| 4 | 83341 | 7.1% |
| 7 | 69492 | 5.9% |
| 6 | 61579 | 5.2% |
| 8 | 50811 | 4.3% |
| Other values (15) | 11917 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6247 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4185276 × 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 | 99899013 |
| 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.2916647 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97128842 |
| Kurtosis | -1.7421448 |
| Mean | 4.4185276 × 108 |
| Median Absolute Deviation (MAD) | 1.199 × 108 |
| Skewness | 0.46260833 |
| Sum | 1.5523657 × 1014 |
| Variance | 1.8418386 × 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 | 2052 | 0.6% |
| 990356076 | 1858 | 0.5% |
| 990356073 | 1730 | 0.5% |
| 131999228 | 1711 | 0.5% |
| 131999164 | 1689 | 0.5% |
| 990003007 | 1574 | 0.4% |
| 131999194 | 1541 | 0.4% |
| Other values (6237) | 331692 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 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 | 10695 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 524.33049 |
| Minimum | 1 |
|---|---|
| Maximum | 168486 |
| 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 | 105 |
| 95-th percentile | 1785 |
| Maximum | 168486 |
| Range | 168485 |
| Interquartile range (IQR) | 102 |
Descriptive statistics
| Standard deviation | 3223.164 |
|---|---|
| Coefficient of variation (CV) | 6.1471993 |
| Kurtosis | 405.62933 |
| Mean | 524.33049 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 16.628355 |
| Sum | 1.8421356 × 108 |
| Variance | 10388786 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57769 | 16.4% |
| 2 | 28234 | 8.0% |
| 3 | 18514 | 5.3% |
| 4 | 13545 | 3.9% |
| 5 | 10586 | 3.0% |
| 6 | 8914 | 2.5% |
| 7 | 7466 | 2.1% |
| 8 | 6272 | 1.8% |
| 9 | 5710 | 1.6% |
| 10 | 5149 | 1.5% |
| Other values (10685) | 189172 |
| Value | Count | Frequency (%) |
| 1 | 57769 | |
| 2 | 28234 | |
| 3 | 18514 | 5.3% |
| 4 | 13545 | 3.9% |
| 5 | 10586 | 3.0% |
| 6 | 8914 | 2.5% |
| 7 | 7466 | 2.1% |
| 8 | 6272 | 1.8% |
| 9 | 5710 | 1.6% |
| 10 | 5149 | 1.5% |
| Value | Count | Frequency (%) |
| 168486 | 1 | |
| 165184 | 1 | |
| 163742 | 1 | |
| 155869 | 1 | |
| 154640 | 1 | |
| 154258 | 1 | |
| 144714 | 1 | |
| 118396 | 1 | |
| 115934 | 1 | |
| 113287 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11516 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 622.27717 |
| 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 | 115 |
| 95-th percentile | 2041 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 112 |
Descriptive statistics
| Standard deviation | 4166.0374 |
|---|---|
| Coefficient of variation (CV) | 6.6948259 |
| Kurtosis | 706.94937 |
| Mean | 622.27717 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 21.122402 |
| Sum | 2.1862526 × 108 |
| Variance | 17355867 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55586 | 15.8% |
| 2 | 27712 | 7.9% |
| 3 | 18353 | 5.2% |
| 4 | 13324 | 3.8% |
| 5 | 10485 | 3.0% |
| 6 | 8898 | 2.5% |
| 7 | 7413 | 2.1% |
| 8 | 6183 | 1.8% |
| 9 | 5663 | 1.6% |
| 10 | 5139 | 1.5% |
| Other values (11506) | 192575 |
| Value | Count | Frequency (%) |
| 1 | 55586 | |
| 2 | 27712 | |
| 3 | 18353 | 5.2% |
| 4 | 13324 | 3.8% |
| 5 | 10485 | 3.0% |
| 6 | 8898 | 2.5% |
| 7 | 7413 | 2.1% |
| 8 | 6183 | 1.8% |
| 9 | 5663 | 1.6% |
| 10 | 5139 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231945 | 1 | |
| 230943 | 1 | |
| 227921 | 1 | |
| 227409 | 1 | |
| 226679 | 1 | |
| 223889 | 1 | |
| 218673 | 1 | |
| 215390 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9629 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7873.4298 |
| Minimum | 1 |
|---|---|
| Maximum | 240482 |
| 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 | 1779 |
| Q3 | 6583 |
| 95-th percentile | 37461 |
| Maximum | 240482 |
| Range | 240481 |
| Interquartile range (IQR) | 6166 |
Descriptive statistics
| Standard deviation | 18134.788 |
|---|---|
| Coefficient of variation (CV) | 2.3032895 |
| Kurtosis | 34.057348 |
| Mean | 7873.4298 |
| Median Absolute Deviation (MAD) | 1619 |
| Skewness | 5.0404818 |
| Sum | 2.76618 × 109 |
| Variance | 3.2887053 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 580 | 0.2% |
| 8 | 513 | 0.1% |
| 19 | 499 | 0.1% |
| 26 | 497 | 0.1% |
| 25 | 483 | 0.1% |
| 17 | 478 | 0.1% |
| 28 | 474 | 0.1% |
| 9 | 467 | 0.1% |
| 12 | 466 | 0.1% |
| 4 | 459 | 0.1% |
| Other values (9619) | 346415 |
| Value | Count | Frequency (%) |
| 1 | 403 | |
| 2 | 446 | |
| 3 | 425 | |
| 4 | 459 | |
| 5 | 447 | |
| 6 | 433 | |
| 7 | 435 | |
| 8 | 513 | |
| 9 | 467 | |
| 10 | 411 |
| Value | Count | Frequency (%) |
| 240482 | 22 | |
| 232879 | 23 | |
| 227997 | 23 | |
| 218546 | 24 | |
| 214503 | 17 | |
| 213515 | 25 | |
| 211576 | 17 | |
| 210414 | 19 | |
| 205337 | 17 | |
| 200599 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10722 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11446.614 |
| Minimum | 1 |
|---|---|
| Maximum | 376865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 55 |
| Q1 | 557 |
| median | 2482 |
| Q3 | 9410 |
| 95-th percentile | 53436.5 |
| Maximum | 376865 |
| Range | 376864 |
| Interquartile range (IQR) | 8853 |
Descriptive statistics
| Standard deviation | 27248.092 |
|---|---|
| Coefficient of variation (CV) | 2.3804499 |
| Kurtosis | 37.319715 |
| Mean | 11446.614 |
| Median Absolute Deviation (MAD) | 2278 |
| Skewness | 5.2695784 |
| Sum | 4.0215505 × 109 |
| Variance | 7.4245852 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 427 | 0.1% |
| 77 | 394 | 0.1% |
| 23 | 390 | 0.1% |
| 39 | 388 | 0.1% |
| 6 | 382 | 0.1% |
| 20 | 379 | 0.1% |
| 45 | 379 | 0.1% |
| 18 | 376 | 0.1% |
| 31 | 370 | 0.1% |
| 34 | 369 | 0.1% |
| Other values (10712) | 347477 |
| Value | Count | Frequency (%) |
| 1 | 314 | |
| 2 | 322 | |
| 3 | 352 | |
| 4 | 357 | |
| 5 | 357 | |
| 6 | 382 | |
| 7 | 349 | |
| 8 | 324 | |
| 9 | 289 | |
| 10 | 353 |
| Value | Count | Frequency (%) |
| 376865 | 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 | 338 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 683322.47 |
| 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 | 43684 |
| Q1 | 329924 |
| median | 764879 |
| Q3 | 1026428 |
| 95-th percentile | 1332258 |
| Maximum | 1487625 |
| Range | 1487624 |
| Interquartile range (IQR) | 696504 |
Descriptive statistics
| Standard deviation | 409165.71 |
|---|---|
| Coefficient of variation (CV) | 0.59878861 |
| Kurtosis | -1.0740483 |
| Mean | 683322.47 |
| Median Absolute Deviation (MAD) | 315054 |
| Skewness | -0.052451911 |
| Sum | 2.4007237 × 1011 |
| Variance | 1.6741658 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880923 | 5102 | 1.5% |
| 874080 | 4354 | 1.2% |
| 843975 | 4347 | 1.2% |
| 894295 | 4333 | 1.2% |
| 880448 | 4273 | 1.2% |
| 897684 | 4212 | 1.2% |
| 764999 | 4089 | 1.2% |
| 808505 | 4041 | 1.2% |
| 804285 | 4031 | 1.1% |
| 1066233 | 3925 | 1.1% |
| Other values (328) | 308624 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 16 | 4 | < 0.1% |
| 19 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 22 | 6 | < 0.1% |
| 34 | 26 | |
| 41 | 5 | < 0.1% |
| 54 | 2 | < 0.1% |
| 66 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1487625 | 2975 | |
| 1450388 | 3048 | |
| 1421696 | 3564 | |
| 1344174 | 3543 | |
| 1340477 | 3441 | |
| 1332258 | 3545 | |
| 1325444 | 3413 | |
| 1316254 | 3463 | |
| 1282927 | 3576 | |
| 1269140 | 3352 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1111888.5 |
| Minimum | 1 |
|---|---|
| Maximum | 2668851 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 46632 |
| Q1 | 512469 |
| median | 1139150 |
| Q3 | 1810408 |
| 95-th percentile | 2592938 |
| Maximum | 2668851 |
| Range | 2668850 |
| Interquartile range (IQR) | 1297939 |
Descriptive statistics
| Standard deviation | 740552.97 |
|---|---|
| Coefficient of variation (CV) | 0.66603168 |
| Kurtosis | -0.75610165 |
| Mean | 1111888.5 |
| Median Absolute Deviation (MAD) | 629029 |
| Skewness | 0.33962784 |
| Sum | 3.906409 × 1011 |
| Variance | 5.484187 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211797 | 5102 | 1.5% |
| 1281474 | 4354 | 1.2% |
| 1216248 | 4347 | 1.2% |
| 1315550 | 4333 | 1.2% |
| 1300409 | 4273 | 1.2% |
| 1341793 | 4212 | 1.2% |
| 1155926 | 4089 | 1.2% |
| 1218770 | 4041 | 1.2% |
| 1207051 | 4031 | 1.1% |
| 2640049 | 3925 | 1.1% |
| Other values (329) | 308624 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 16 | 3 | < 0.1% |
| 18 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 22 | 6 | < 0.1% |
| 34 | 26 | |
| 47 | 5 | < 0.1% |
| 54 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 2668851 | 3796 | |
| 2663706 | 3866 | |
| 2640049 | 3925 | |
| 2618208 | 3788 | |
| 2592938 | 3843 | |
| 2547668 | 3890 | |
| 2479530 | 3851 | |
| 2178204 | 3757 | |
| 2061927 | 3811 | |
| 2051811 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3707 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 53545 |
| Missing (%) | 15.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3643.9968 |
| 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 | 1270 |
| Q3 | 4230 |
| 95-th percentile | 13905 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3745 |
Descriptive statistics
| Standard deviation | 6589.8557 |
|---|---|
| Coefficient of variation (CV) | 1.8084142 |
| Kurtosis | 131.64692 |
| Mean | 3643.9968 |
| Median Absolute Deviation (MAD) | 1040 |
| Skewness | 6.8483004 |
| Sum | 1.0851312 × 109 |
| Variance | 43426198 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2044 | 0.6% |
| 105 | 1984 | 0.6% |
| 110 | 1791 | 0.5% |
| 180 | 1645 | 0.5% |
| 185 | 1567 | 0.4% |
| 140 | 1547 | 0.4% |
| 125 | 1520 | 0.4% |
| 175 | 1482 | 0.4% |
| 165 | 1441 | 0.4% |
| 300 | 1428 | 0.4% |
| Other values (3697) | 281337 | |
| (Missing) | 53545 | 15.2% |
| 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 | 1025 | |
| 105 | 1984 | |
| 110 | 1791 | |
| 115 | 1176 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99540 | 5 |
| 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.312 | 0.321 | 0.987 | 0.295 | 0.317 | -0.061 | 0.028 | -0.179 |
| AANTAL_PAT_PER_SPC | 0.312 | 1.000 | 0.068 | 0.325 | 0.959 | 0.070 | -0.559 | -0.011 | -0.381 |
| AANTAL_PAT_PER_ZPD | 0.321 | 0.068 | 1.000 | 0.319 | 0.077 | 0.996 | 0.008 | -0.303 | -0.141 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.987 | 0.325 | 0.319 | 1.000 | 0.325 | 0.320 | -0.055 | 0.037 | -0.212 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.295 | 0.959 | 0.077 | 0.325 | 1.000 | 0.084 | -0.478 | -0.014 | -0.411 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.317 | 0.070 | 0.996 | 0.320 | 0.084 | 1.000 | 0.014 | -0.306 | -0.149 |
| BEHANDELEND_SPECIALISME_CD | -0.061 | -0.559 | 0.008 | -0.055 | -0.478 | 0.014 | 1.000 | 0.046 | 0.214 |
| GEMIDDELDE_VERKOOPPRIJS | 0.028 | -0.011 | -0.303 | 0.037 | -0.014 | -0.306 | 0.046 | 1.000 | 0.029 |
| ZORGPRODUCT_CD | -0.179 | -0.381 | -0.141 | -0.212 | -0.411 | -0.149 | 0.214 | 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-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 203 | 998418070 | 1 | 1 | 1 | 1 | 34 | 34 | NaN |
| 1 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 501 | 998418069 | 2 | 2 | 3 | 3 | 34 | 34 | NaN |
| 2 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 309 | 998418032 | 1 | 1 | 1 | 1 | 34 | 34 | NaN |
| 3 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 101 | 998418052 | 1 | 1 | 8 | 8 | 34 | 34 | NaN |
| 4 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 303 | 998418070 | 1 | 1 | 4 | 4 | 34 | 34 | NaN |
| 5 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 302 | 998418067 | 1 | 1 | 2 | 2 | 34 | 34 | NaN |
| 6 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 503 | 998418069 | 2 | 2 | 7 | 7 | 34 | 34 | NaN |
| 7 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 303 | 998418069 | 1 | 1 | 4 | 4 | 34 | 34 | NaN |
| 8 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 303 | 998418036 | 1 | 1 | 4 | 4 | 34 | 34 | NaN |
| 9 | 1.0 | 2024-03-08 | 2024-03-01 | 2024-01-01 | 8418 | 504 | 998418069 | 1 | 1 | 4 | 4 | 34 | 34 | NaN |
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351321 | 1.0 | 2024-03-08 | 2024-03-01 | 2014-01-01 | 313 | 762 | 979003003 | 1 | 1 | 299 | 2397 | 1037165 | 2061927 | 12575.0 |
| 351322 | 1.0 | 2024-03-08 | 2024-03-01 | 2012-01-01 | 303 | 327 | 119499062 | 1 | 1 | 8179 | 10669 | 1487625 | 1939514 | NaN |
| 351323 | 1.0 | 2024-03-08 | 2024-03-01 | 2012-01-01 | 303 | 339 | 119499054 | 1 | 1 | 3069 | 4254 | 1487625 | 1939514 | NaN |
| 351324 | 1.0 | 2024-03-08 | 2024-03-01 | 2015-01-01 | 301 | 755 | 79799024 | 1 | 1 | 3689 | 9281 | 1084413 | 1653257 | NaN |
| 351325 | 1.0 | 2024-03-08 | 2024-03-01 | 2016-01-01 | 303 | 249 | 199299062 | 1 | 1 | 628 | 794 | 1332258 | 1831332 | 5450.0 |
| 351326 | 1.0 | 2024-03-08 | 2024-03-01 | 2015-01-01 | 322 | 1303 | 29099025 | 1 | 1 | 25737 | 72856 | 442135 | 759728 | NaN |
| 351327 | 1.0 | 2024-03-08 | 2024-03-01 | 2014-01-01 | 313 | 833 | 20110030 | 2 | 3 | 1686 | 7675 | 1037165 | 2061927 | NaN |
| 351328 | 1.0 | 2024-03-08 | 2024-03-01 | 2014-01-01 | 313 | 761 | 28999065 | 1 | 1 | 2557 | 5459 | 1037165 | 2061927 | NaN |
| 351329 | 1.0 | 2024-03-08 | 2024-03-01 | 2014-01-01 | 313 | 904 | 29199114 | 1 | 1 | 3280 | 13272 | 1037165 | 2061927 | 16420.0 |
| 351330 | 1.0 | 2024-03-08 | 2024-03-01 | 2015-01-01 | 322 | 1402 | 990022035 | 1 | 1 | 1619 | 2356 | 442135 | 759728 | 2915.0 |