Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 375707 |
| Missing cells | 58690 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 40.1 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-10-04" | Constant |
PEILDATUM has constant value "2024-10-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 58690 (15.6%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.38814196) | Skewed |
Reproduction
| Analysis started | 2024-10-16 08:55:34.926824 |
|---|---|
| Analysis finished | 2024-10-16 08:55:49.042206 |
| Duration | 14.12 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
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 | 375707 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 375707 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 375707 | |
| . | 375707 | |
| 0 | 375707 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1127121 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 375707 | |
| . | 375707 | |
| 0 | 375707 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1127121 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 375707 | |
| . | 375707 | |
| 0 | 375707 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1127121 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 375707 | |
| . | 375707 | |
| 0 | 375707 |
DATUM_BESTAND
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 2024-10-04 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024-10-04 |
|---|---|
| 2nd row | 2024-10-04 |
| 3rd row | 2024-10-04 |
| 4th row | 2024-10-04 |
| 5th row | 2024-10-04 |
Common Values
| Value | Count | Frequency (%) |
| 2024-10-04 | 375707 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-10-04 | 375707 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| 4 | 751414 | |
| - | 751414 | |
| 1 | 375707 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| 4 | 751414 | |
| - | 751414 | |
| 1 | 375707 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| 4 | 751414 | |
| - | 751414 | |
| 1 | 375707 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| 4 | 751414 | |
| - | 751414 | |
| 1 | 375707 | 10.0% |
PEILDATUM
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 2024-10-01 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024-10-01 |
|---|---|
| 2nd row | 2024-10-01 |
| 3rd row | 2024-10-01 |
| 4th row | 2024-10-01 |
| 5th row | 2024-10-01 |
Common Values
| Value | Count | Frequency (%) |
| 2024-10-01 | 375707 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2024-10-01 | 375707 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| - | 751414 | |
| 1 | 751414 | |
| 4 | 375707 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| - | 751414 | |
| 1 | 751414 | |
| 4 | 375707 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| - | 751414 | |
| 1 | 751414 | |
| 4 | 375707 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3757070 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127121 | |
| 2 | 751414 | |
| - | 751414 | |
| 1 | 751414 | |
| 4 | 375707 | 10.0% |
JAAR
Date
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 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 | 463.10297 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 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 | 1083.5567 |
|---|---|
| Coefficient of variation (CV) | 2.3397749 |
| Kurtosis | 49.829301 |
| Mean | 463.10297 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.1950194 |
| Sum | 1.7399103 × 108 |
| Variance | 1174095.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 52500 | |
| 313 | 48881 | |
| 303 | 43232 | |
| 330 | 29463 | 7.8% |
| 316 | 25386 | 6.8% |
| 308 | 20544 | 5.5% |
| 306 | 15799 | 4.2% |
| 324 | 15391 | 4.1% |
| 301 | 14983 | 4.0% |
| 304 | 12263 | 3.3% |
| Other values (18) | 97265 |
| Value | Count | Frequency (%) |
| 301 | 14983 | 4.0% |
| 302 | 8255 | 2.2% |
| 303 | 43232 | |
| 304 | 12263 | 3.3% |
| 305 | 52500 | |
| 306 | 15799 | 4.2% |
| 307 | 6627 | 1.8% |
| 308 | 20544 | 5.5% |
| 310 | 4085 | 1.1% |
| 313 | 48881 |
| Value | Count | Frequency (%) |
| 8418 | 5110 | 1.4% |
| 8416 | 1724 | 0.5% |
| 1900 | 248 | 0.1% |
| 390 | 1043 | 0.3% |
| 389 | 3927 | 1.0% |
| 362 | 4657 | 1.2% |
| 361 | 2761 | 0.7% |
| 335 | 3755 | 1.0% |
| 330 | 29463 | |
| 329 | 979 | 0.3% |
| Distinct | 1907 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3533472 |
| Min length | 2 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 205 |
|---|---|
| 2nd row | 205 |
| 3rd row | 205 |
| 4th row | 205 |
| 5th row | 205 |
| Value | Count | Frequency (%) |
| 101 | 1610 | 0.4% |
| 402 | 1543 | 0.4% |
| 301 | 1515 | 0.4% |
| 403 | 1513 | 0.4% |
| 201 | 1442 | 0.4% |
| 203 | 1396 | 0.4% |
| 404 | 1256 | 0.3% |
| 401 | 1256 | 0.3% |
| 409 | 1228 | 0.3% |
| 802 | 1211 | 0.3% |
| Other values (1897) | 361737 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 240770 | |
| 0 | 232023 | |
| 2 | 166895 | |
| 3 | 136110 | |
| 5 | 97329 | |
| 9 | 90576 | 7.2% |
| 4 | 89092 | 7.1% |
| 7 | 74261 | 5.9% |
| 6 | 65759 | 5.2% |
| 8 | 54329 | 4.3% |
| Other values (15) | 12732 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1259876 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 240770 | |
| 0 | 232023 | |
| 2 | 166895 | |
| 3 | 136110 | |
| 5 | 97329 | |
| 9 | 90576 | 7.2% |
| 4 | 89092 | 7.1% |
| 7 | 74261 | 5.9% |
| 6 | 65759 | 5.2% |
| 8 | 54329 | 4.3% |
| Other values (15) | 12732 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1259876 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 240770 | |
| 0 | 232023 | |
| 2 | 166895 | |
| 3 | 136110 | |
| 5 | 97329 | |
| 9 | 90576 | 7.2% |
| 4 | 89092 | 7.1% |
| 7 | 74261 | 5.9% |
| 6 | 65759 | 5.2% |
| 8 | 54329 | 4.3% |
| Other values (15) | 12732 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1259876 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 240770 | |
| 0 | 232023 | |
| 2 | 166895 | |
| 3 | 136110 | |
| 5 | 97329 | |
| 9 | 90576 | 7.2% |
| 4 | 89092 | 7.1% |
| 7 | 74261 | 5.9% |
| 6 | 65759 | 5.2% |
| 8 | 54329 | 4.3% |
| Other values (15) | 12732 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6286 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4021143 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99799069 |
| median | 1.4959903 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.90616 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020396 × 108 |
Descriptive statistics
| Standard deviation | 4.2876883 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97400659 |
| Kurtosis | -1.7344348 |
| Mean | 4.4021143 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.47062109 |
| Sum | 1.6539052 × 1014 |
| Variance | 1.8384271 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2748 | 0.7% |
| 990004007 | 2701 | 0.7% |
| 990003004 | 2575 | 0.7% |
| 990004006 | 2193 | 0.6% |
| 990356076 | 2014 | 0.5% |
| 131999228 | 1912 | 0.5% |
| 131999164 | 1887 | 0.5% |
| 990356073 | 1869 | 0.5% |
| 131999194 | 1703 | 0.5% |
| 990003007 | 1642 | 0.4% |
| Other values (6276) | 354463 |
| 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 | 194 | |
| 998418080 | 178 | |
| 998418079 | 44 | < 0.1% |
| 998418077 | 10 | < 0.1% |
| 998418076 | 10 | < 0.1% |
| 998418075 | 8 | < 0.1% |
| 998418074 | 267 | |
| 998418073 | 267 | |
| 998418072 | 10 | < 0.1% |
| 998418071 | 10 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
High correlation
| Distinct | 10937 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 516.40689 |
| Minimum | 1 |
|---|---|
| Maximum | 170376 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 103 |
| 95-th percentile | 1750 |
| Maximum | 170376 |
| Range | 170375 |
| Interquartile range (IQR) | 100 |
Descriptive statistics
| Standard deviation | 3207.2229 |
|---|---|
| Coefficient of variation (CV) | 6.2106508 |
| Kurtosis | 422.70488 |
| Mean | 516.40689 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 16.94388 |
| Sum | 1.9401768 × 108 |
| Variance | 10286278 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 62355 | 16.6% |
| 2 | 30323 | 8.1% |
| 3 | 19839 | 5.3% |
| 4 | 14527 | 3.9% |
| 5 | 11382 | 3.0% |
| 6 | 9592 | 2.6% |
| 7 | 8016 | 2.1% |
| 8 | 6763 | 1.8% |
| 9 | 6145 | 1.6% |
| 10 | 5478 | 1.5% |
| Other values (10927) | 201287 |
| Value | Count | Frequency (%) |
| 1 | 62355 | |
| 2 | 30323 | |
| 3 | 19839 | 5.3% |
| 4 | 14527 | 3.9% |
| 5 | 11382 | 3.0% |
| 6 | 9592 | 2.6% |
| 7 | 8016 | 2.1% |
| 8 | 6763 | 1.8% |
| 9 | 6145 | 1.6% |
| 10 | 5478 | 1.5% |
| Value | Count | Frequency (%) |
| 170376 | 1 | |
| 165181 | 1 | |
| 164558 | 1 | |
| 164145 | 1 | |
| 155866 | 1 | |
| 154635 | 1 | |
| 154254 | 1 | |
| 144709 | 1 | |
| 118398 | 1 | |
| 115934 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
High correlation Skewed
| Distinct | 11809 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 614.3715 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 15 |
| Q3 | 113 |
| 95-th percentile | 2001 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 110 |
Descriptive statistics
| Standard deviation | 4159.6533 |
|---|---|
| Coefficient of variation (CV) | 6.7705831 |
| Kurtosis | 722.46335 |
| Mean | 614.3715 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 21.388142 |
| Sum | 2.3082367 × 108 |
| Variance | 17302716 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 60038 | 16.0% |
| 2 | 29802 | 7.9% |
| 3 | 19626 | 5.2% |
| 4 | 14327 | 3.8% |
| 5 | 11289 | 3.0% |
| 6 | 9555 | 2.5% |
| 7 | 7947 | 2.1% |
| 8 | 6675 | 1.8% |
| 9 | 6082 | 1.6% |
| 10 | 5499 | 1.5% |
| Other values (11799) | 204867 |
| Value | Count | Frequency (%) |
| 1 | 60038 | |
| 2 | 29802 | |
| 3 | 19626 | 5.2% |
| 4 | 14327 | 3.8% |
| 5 | 11289 | 3.0% |
| 6 | 9555 | 2.5% |
| 7 | 7947 | 2.1% |
| 8 | 6675 | 1.8% |
| 9 | 6082 | 1.6% |
| 10 | 5499 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231945 | 1 | |
| 230934 | 1 | |
| 227921 | 1 | |
| 227409 | 1 | |
| 226728 | 1 | |
| 223888 | 1 | |
| 218673 | 1 | |
| 216487 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
High correlation
| Distinct | 9902 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7742.4086 |
| Minimum | 1 |
|---|---|
| Maximum | 242406 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 397 |
| median | 1711 |
| Q3 | 6318 |
| 95-th percentile | 37149 |
| Maximum | 242406 |
| Range | 242405 |
| Interquartile range (IQR) | 5921 |
Descriptive statistics
| Standard deviation | 18052.725 |
|---|---|
| Coefficient of variation (CV) | 2.3316678 |
| Kurtosis | 35.401952 |
| Mean | 7742.4086 |
| Median Absolute Deviation (MAD) | 1567 |
| Skewness | 5.1307025 |
| Sum | 2.9088771 × 109 |
| Variance | 3.2590087 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 601 | 0.2% |
| 14 | 565 | 0.2% |
| 8 | 565 | 0.2% |
| 23 | 562 | 0.1% |
| 9 | 555 | 0.1% |
| 26 | 552 | 0.1% |
| 4 | 550 | 0.1% |
| 19 | 543 | 0.1% |
| 12 | 537 | 0.1% |
| 17 | 536 | 0.1% |
| Other values (9892) | 370141 |
| Value | Count | Frequency (%) |
| 1 | 441 | |
| 2 | 517 | |
| 3 | 527 | |
| 4 | 550 | |
| 5 | 511 | |
| 6 | 525 | |
| 7 | 510 | |
| 8 | 565 | |
| 9 | 555 | |
| 10 | 498 |
| Value | Count | Frequency (%) |
| 242406 | 23 | |
| 233774 | 23 | |
| 233281 | 23 | |
| 227992 | 23 | |
| 218540 | 24 | |
| 214501 | 17 | |
| 213510 | 25 | |
| 211573 | 17 | |
| 210409 | 19 | |
| 205333 | 17 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
High correlation
| Distinct | 11094 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11315.578 |
| Minimum | 1 |
|---|---|
| Maximum | 382138 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 51 |
| Q1 | 527 |
| median | 2396 |
| Q3 | 9236 |
| 95-th percentile | 52933 |
| Maximum | 382138 |
| Range | 382137 |
| Interquartile range (IQR) | 8709 |
Descriptive statistics
| Standard deviation | 27323.145 |
|---|---|
| Coefficient of variation (CV) | 2.4146487 |
| Kurtosis | 38.533963 |
| Mean | 11315.578 |
| Median Absolute Deviation (MAD) | 2207 |
| Skewness | 5.3536484 |
| Sum | 4.2513418 × 109 |
| Variance | 7.4655426 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 481 | 0.1% |
| 20 | 477 | 0.1% |
| 3 | 455 | 0.1% |
| 17 | 452 | 0.1% |
| 11 | 448 | 0.1% |
| 6 | 445 | 0.1% |
| 4 | 444 | 0.1% |
| 23 | 437 | 0.1% |
| 12 | 431 | 0.1% |
| 31 | 431 | 0.1% |
| Other values (11084) | 371206 |
| Value | Count | Frequency (%) |
| 1 | 346 | |
| 2 | 376 | |
| 3 | 455 | |
| 4 | 444 | |
| 5 | 418 | |
| 6 | 445 | |
| 7 | 424 | |
| 8 | 398 | |
| 9 | 353 | |
| 10 | 405 |
| Value | Count | Frequency (%) |
| 382138 | 23 | |
| 371149 | 23 | |
| 370126 | 23 | |
| 366193 | 23 | |
| 348469 | 25 | |
| 344894 | 24 | |
| 341641 | 19 | |
| 323740 | 20 | |
| 315767 | 17 | |
| 310748 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
High correlation
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 670850.95 |
| Minimum | 1610 |
|---|---|
| Maximum | 1487618 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1610 |
|---|---|
| 5-th percentile | 40711 |
| Q1 | 277881 |
| median | 759520 |
| Q3 | 1027654 |
| 95-th percentile | 1339993 |
| Maximum | 1487618 |
| Range | 1486008 |
| Interquartile range (IQR) | 749773 |
Descriptive statistics
| Standard deviation | 416612.38 |
|---|---|
| Coefficient of variation (CV) | 0.62102079 |
| Kurtosis | -1.1630863 |
| Mean | 670850.95 |
| Median Absolute Deviation (MAD) | 319393 |
| Skewness | -0.0071497421 |
| Sum | 2.520434 × 1011 |
| Variance | 1.7356588 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880928 | 5102 | 1.4% |
| 874125 | 4354 | 1.2% |
| 843977 | 4347 | 1.2% |
| 894349 | 4333 | 1.2% |
| 880491 | 4273 | 1.1% |
| 897734 | 4212 | 1.1% |
| 765033 | 4089 | 1.1% |
| 814242 | 4048 | 1.1% |
| 805793 | 4032 | 1.1% |
| 1076639 | 3938 | 1.0% |
| Other values (343) | 332979 |
| Value | Count | Frequency (%) |
| 1610 | 130 | < 0.1% |
| 1831 | 138 | < 0.1% |
| 1922 | 131 | < 0.1% |
| 2495 | 173 | |
| 2633 | 193 | |
| 4309 | 108 | < 0.1% |
| 4657 | 181 | |
| 5528 | 67 | < 0.1% |
| 6810 | 380 | |
| 6977 | 323 |
| Value | Count | Frequency (%) |
| 1487618 | 2975 | |
| 1450393 | 3048 | |
| 1421770 | 3564 | |
| 1344574 | 3543 | |
| 1340864 | 3441 | |
| 1339993 | 3413 | |
| 1332660 | 3545 | |
| 1316655 | 3463 | |
| 1283016 | 3576 | |
| 1271629 | 3355 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
High correlation
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1097877.4 |
| Minimum | 1861 |
|---|---|
| Maximum | 2682876 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 1861 |
|---|---|
| 5-th percentile | 46768 |
| Q1 | 454136 |
| median | 1128103 |
| Q3 | 1813050 |
| 95-th percentile | 2601018 |
| Maximum | 2682876 |
| Range | 2681015 |
| Interquartile range (IQR) | 1358914 |
Descriptive statistics
| Standard deviation | 760119.46 |
|---|---|
| Coefficient of variation (CV) | 0.6923537 |
| Kurtosis | -0.80183896 |
| Mean | 1097877.4 |
| Median Absolute Deviation (MAD) | 684947 |
| Skewness | 0.37331294 |
| Sum | 4.1248021 × 1011 |
| Variance | 5.7778159 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211832 | 5102 | 1.4% |
| 1281603 | 4354 | 1.2% |
| 1216290 | 4347 | 1.2% |
| 1315699 | 4333 | 1.2% |
| 1300575 | 4273 | 1.1% |
| 1342014 | 4212 | 1.1% |
| 1156074 | 4089 | 1.1% |
| 1230538 | 4048 | 1.1% |
| 1209719 | 4032 | 1.1% |
| 2680353 | 3938 | 1.0% |
| Other values (343) | 332979 |
| Value | Count | Frequency (%) |
| 1861 | 130 | < 0.1% |
| 2102 | 138 | < 0.1% |
| 2198 | 131 | < 0.1% |
| 2817 | 173 | |
| 3453 | 193 | |
| 4593 | 108 | < 0.1% |
| 5552 | 181 | |
| 5767 | 67 | < 0.1% |
| 7111 | 323 | |
| 7389 | 380 |
| Value | Count | Frequency (%) |
| 2682876 | 3796 | |
| 2680353 | 3938 | |
| 2671992 | 3866 | |
| 2626220 | 3788 | |
| 2601018 | 3843 | |
| 2555580 | 3890 | |
| 2546348 | 3930 | |
| 2486742 | 3851 | |
| 2183750 | 3757 | |
| 2066313 | 3810 |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
Missing
| Distinct | 3822 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 58690 |
| Missing (%) | 15.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3647.6407 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 145 |
| Q1 | 485 |
| median | 1260 |
| Q3 | 4220 |
| 95-th percentile | 13925 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3735 |
Descriptive statistics
| Standard deviation | 6576.8368 |
|---|---|
| Coefficient of variation (CV) | 1.8030385 |
| Kurtosis | 126.69007 |
| Mean | 3647.6407 |
| Median Absolute Deviation (MAD) | 1030 |
| Skewness | 6.7276893 |
| Sum | 1.1563641 × 109 |
| Variance | 43254782 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2090 | 0.6% |
| 105 | 2064 | 0.5% |
| 110 | 1821 | 0.5% |
| 185 | 1707 | 0.5% |
| 180 | 1702 | 0.5% |
| 140 | 1563 | 0.4% |
| 175 | 1561 | 0.4% |
| 145 | 1504 | 0.4% |
| 125 | 1498 | 0.4% |
| 165 | 1477 | 0.4% |
| Other values (3812) | 300030 | |
| (Missing) | 58690 | 15.6% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 671 | 0.2% |
| 95 | 721 | 0.2% |
| 100 | 1036 | |
| 105 | 2064 | |
| 110 | 1821 | |
| 115 | 1120 |
| 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 |
Interactions
Correlations
| 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.333 | 0.324 | 0.987 | 0.316 | 0.321 | -0.062 | 0.034 | -0.177 |
| AANTAL_PAT_PER_SPC | 0.333 | 1.000 | 0.078 | 0.350 | 0.962 | 0.082 | -0.535 | -0.007 | -0.365 |
| AANTAL_PAT_PER_ZPD | 0.324 | 0.078 | 1.000 | 0.322 | 0.086 | 0.996 | 0.008 | -0.300 | -0.139 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.987 | 0.350 | 0.322 | 1.000 | 0.350 | 0.323 | -0.055 | 0.042 | -0.208 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.316 | 0.962 | 0.086 | 0.350 | 1.000 | 0.093 | -0.456 | -0.008 | -0.391 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.321 | 0.082 | 0.996 | 0.323 | 0.093 | 1.000 | 0.013 | -0.303 | -0.148 |
| BEHANDELEND_SPECIALISME_CD | -0.062 | -0.535 | 0.008 | -0.055 | -0.456 | 0.013 | 1.000 | 0.045 | 0.212 |
| GEMIDDELDE_VERKOOPPRIJS | 0.034 | -0.007 | -0.300 | 0.042 | -0.008 | -0.303 | 0.045 | 1.000 | 0.029 |
| ZORGPRODUCT_CD | -0.177 | -0.365 | -0.139 | -0.208 | -0.391 | -0.148 | 0.212 | 0.029 | 1.000 |
Missing values
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.
Sample
| 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-10-04 | 2024-10-01 | 2012-01-01 | 301 | 205 | 79499003 | 8 | 8 | 7877 | 9853 | 1265234 | 1804771 | 1100.0 |
| 1 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 205 | 79499008 | 1 | 1 | 7877 | 9853 | 1265234 | 1804771 | NaN |
| 2 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 205 | 990003003 | 2 | 2 | 7877 | 9853 | 1265234 | 1804771 | 110.0 |
| 3 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 205 | 79499012 | 7 | 7 | 7877 | 9853 | 1265234 | 1804771 | NaN |
| 4 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 205 | 79499011 | 2 | 2 | 7877 | 9853 | 1265234 | 1804771 | NaN |
| 5 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 655 | 79799017 | 253 | 259 | 8258 | 9764 | 1265234 | 1804771 | 450.0 |
| 6 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 655 | 79799029 | 772 | 801 | 8258 | 9764 | 1265234 | 1804771 | 275.0 |
| 7 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 655 | 79799039 | 133 | 146 | 8258 | 9764 | 1265234 | 1804771 | 410.0 |
| 8 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 655 | 990003003 | 34 | 34 | 8258 | 9764 | 1265234 | 1804771 | 110.0 |
| 9 | 1.0 | 2024-10-04 | 2024-10-01 | 2012-01-01 | 301 | 655 | 79799011 | 19 | 20 | 8258 | 9764 | 1265234 | 1804771 | 2070.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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 375697 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 29799078 | 17 | 19 | 64 | 94 | 82822 | 128091 | 185.0 |
| 375698 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802100 | 3 | 3 | 64 | 94 | 82822 | 128091 | 7145.0 |
| 375699 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802091 | 6 | 6 | 64 | 94 | 82822 | 128091 | 9575.0 |
| 375700 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802093 | 3 | 3 | 64 | 94 | 82822 | 128091 | 14820.0 |
| 375701 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802090 | 1 | 1 | 64 | 94 | 82822 | 128091 | 9730.0 |
| 375702 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802081 | 3 | 3 | 64 | 94 | 82822 | 128091 | 14065.0 |
| 375703 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 29799069 | 1 | 1 | 64 | 94 | 82822 | 128091 | 2915.0 |
| 375704 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 29799072 | 1 | 1 | 64 | 94 | 82822 | 128091 | 1340.0 |
| 375705 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 29799077 | 14 | 14 | 64 | 94 | 82822 | 128091 | 300.0 |
| 375706 | 1.0 | 2024-10-04 | 2024-10-01 | 2019-01-01 | 308 | 2820 | 972802111 | 2 | 2 | 64 | 94 | 82822 | 128091 | 13240.0 |