Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 480 |
Missing cells | 84 |
Missing cells (%) | 2.2% |
Duplicate rows | 1 |
Duplicate rows (%) | 0.2% |
Total size in memory | 32.9 KiB |
Average record size in memory | 70.3 B |
Variable types
DateTime | 1 |
---|---|
Categorical | 1 |
Numeric | 6 |
Dataset
Description | 진료비 청구 현황 데이터로 진료년월, 보험유형, 내원구분, 청구건수, 요양급여총액, 본인부담, 지원금, 장애인, 청구금액 등의 정보를 제공합니다. |
---|---|
Author | 질병관리청 국립마산병원 |
URL | https://www.data.go.kr/data/3048703/fileData.do |
Dataset has 1 (0.2%) duplicate rows | Duplicates |
인원(청구건수) is highly overall correlated with 본인부담(B) and 1 other fields | High correlation |
요양급여총액 is highly overall correlated with 본인부담(B) and 2 other fields | High correlation |
본인부담(B) is highly overall correlated with 인원(청구건수) and 2 other fields | High correlation |
지원금 is highly overall correlated with 인원(청구건수) | High correlation |
청구금액(D) is highly overall correlated with 요양급여총액 and 2 other fields | High correlation |
서식 is highly overall correlated with 요양급여총액 and 1 other fields | High correlation |
진료년월 has 12 (2.5%) missing values | Missing |
인원(청구건수) has 12 (2.5%) missing values | Missing |
요양급여총액 has 12 (2.5%) missing values | Missing |
본인부담(B) has 12 (2.5%) missing values | Missing |
지원금 has 12 (2.5%) missing values | Missing |
장애인(C) has 12 (2.5%) missing values | Missing |
청구금액(D) has 12 (2.5%) missing values | Missing |
인원(청구건수) has 6 (1.2%) zeros | Zeros |
요양급여총액 has 6 (1.2%) zeros | Zeros |
본인부담(B) has 38 (7.9%) zeros | Zeros |
지원금 has 365 (76.0%) zeros | Zeros |
장애인(C) has 430 (89.6%) zeros | Zeros |
청구금액(D) has 7 (1.5%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 21:18:00.742182 |
---|---|
Analysis finished | 2023-12-12 21:18:05.405906 |
Duration | 4.66 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
진료년월
Date
MISSING
 
Distinct | 117 |
---|---|
Distinct (%) | 25.0% |
Missing | 12 |
Missing (%) | 2.5% |
Memory size | 3.9 KiB |
Minimum | 2014-01-01 00:00:00 |
---|---|
Maximum | 2023-09-01 00:00:00 |
서식
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 3.9 KiB |
건강보험 외래 | |
---|---|
건강보험 입원 | |
의료급여 외래 | |
의료급여 입원 | |
<NA> |
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 6.925 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 건강보험 외래 |
---|---|
2nd row | 건강보험 입원 |
3rd row | 의료급여 외래 |
4th row | 의료급여 입원 |
5th row | 건강보험 외래 |
Common Values
Value | Count | Frequency (%) |
건강보험 외래 | 117 | |
건강보험 입원 | 117 | |
의료급여 외래 | 117 | |
의료급여 입원 | 117 | |
<NA> | 12 | 2.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
건강보험 | 234 | |
외래 | 234 | |
입원 | 234 | |
의료급여 | 234 | |
na | 12 | 1.3% |
인원(청구건수)
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 193 |
---|---|
Distinct (%) | 41.2% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 88.087607 |
Minimum | 0 |
---|---|
Maximum | 419 |
Zeros | 6 |
Zeros (%) | 1.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 7 |
Q1 | 32 |
median | 58 |
Q3 | 121.25 |
95-th percentile | 255.65 |
Maximum | 419 |
Range | 419 |
Interquartile range (IQR) | 89.25 |
Descriptive statistics
Standard deviation | 79.446525 |
---|---|
Coefficient of variation (CV) | 0.90190355 |
Kurtosis | 1.4108488 |
Mean | 88.087607 |
Median Absolute Deviation (MAD) | 37 |
Skewness | 1.3597069 |
Sum | 41225 |
Variance | 6311.7503 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
19 | 11 | 2.3% |
52 | 7 | 1.5% |
58 | 7 | 1.5% |
43 | 7 | 1.5% |
42 | 7 | 1.5% |
35 | 7 | 1.5% |
30 | 6 | 1.2% |
37 | 6 | 1.2% |
0 | 6 | 1.2% |
36 | 6 | 1.2% |
Other values (183) | 398 | |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 6 | |
1 | 3 | |
2 | 3 | |
3 | 1 | 0.2% |
4 | 4 | |
5 | 2 | 0.4% |
6 | 3 | |
7 | 4 | |
8 | 4 | |
9 | 2 | 0.4% |
Value | Count | Frequency (%) |
419 | 1 | |
400 | 1 | |
365 | 1 | |
353 | 1 | |
342 | 1 | |
311 | 1 | |
307 | 1 | |
304 | 1 | |
293 | 1 | |
289 | 1 |
요양급여총액
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 463 |
---|---|
Distinct (%) | 98.9% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 86983967 |
Minimum | 0 |
---|---|
Maximum | 9.1239458 × 108 |
Zeros | 6 |
Zeros (%) | 1.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 726424 |
Q1 | 5576860 |
median | 19548670 |
Q3 | 1.2452174 × 108 |
95-th percentile | 2.7949522 × 108 |
Maximum | 9.1239458 × 108 |
Range | 9.1239458 × 108 |
Interquartile range (IQR) | 1.1894488 × 108 |
Descriptive statistics
Standard deviation | 1.2020361 × 108 |
---|---|
Coefficient of variation (CV) | 1.3819054 |
Kurtosis | 12.187663 |
Mean | 86983967 |
Median Absolute Deviation (MAD) | 19324955 |
Skewness | 2.7806897 |
Sum | 4.0708496 × 1010 |
Variance | 1.4448909 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 6 | 1.2% |
27734320 | 1 | 0.2% |
12511930 | 1 | 0.2% |
70825570 | 1 | 0.2% |
2270040 | 1 | 0.2% |
172750450 | 1 | 0.2% |
10046310 | 1 | 0.2% |
54562520 | 1 | 0.2% |
2429930 | 1 | 0.2% |
126289090 | 1 | 0.2% |
Other values (453) | 453 | |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 6 | |
11530 | 1 | 0.2% |
16370 | 1 | 0.2% |
49980 | 1 | 0.2% |
58640 | 1 | 0.2% |
74290 | 1 | 0.2% |
104580 | 1 | 0.2% |
125140 | 1 | 0.2% |
147290 | 1 | 0.2% |
201230 | 1 | 0.2% |
Value | Count | Frequency (%) |
912394580 | 1 | |
849943320 | 1 | |
810540360 | 1 | |
670620200 | 1 | |
619323030 | 1 | |
519330840 | 1 | |
512327660 | 1 | |
506149100 | 1 | |
414181840 | 1 | |
369786900 | 1 |
본인부담(B)
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 422 |
---|---|
Distinct (%) | 90.2% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7607222.4 |
Minimum | 0 |
---|---|
Maximum | 1.9823357 × 108 |
Zeros | 38 |
Zeros (%) | 7.9% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 41475 |
median | 1612090 |
Q3 | 3874400 |
95-th percentile | 33346858 |
Maximum | 1.9823357 × 108 |
Range | 1.9823357 × 108 |
Interquartile range (IQR) | 3832925 |
Descriptive statistics
Standard deviation | 20293549 |
---|---|
Coefficient of variation (CV) | 2.6676686 |
Kurtosis | 45.005884 |
Mean | 7607222.4 |
Median Absolute Deviation (MAD) | 1574770 |
Skewness | 6.0612147 |
Sum | 3.5601801 × 109 |
Variance | 4.1182812 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 38 | 7.9% |
1500 | 3 | 0.6% |
4500 | 3 | 0.6% |
6000 | 2 | 0.4% |
7500 | 2 | 0.4% |
39699720 | 2 | 0.4% |
21900 | 2 | 0.4% |
2306500 | 2 | 0.4% |
1827700 | 1 | 0.2% |
25940 | 1 | 0.2% |
Other values (412) | 412 | |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 38 | |
1500 | 3 | 0.6% |
1750 | 1 | 0.2% |
3000 | 1 | 0.2% |
3500 | 1 | 0.2% |
4500 | 3 | 0.6% |
6000 | 2 | 0.4% |
6990 | 1 | 0.2% |
7500 | 2 | 0.4% |
7850 | 1 | 0.2% |
Value | Count | Frequency (%) |
198233570 | 1 | |
182665700 | 1 | |
170840320 | 1 | |
144343100 | 1 | |
135908270 | 1 | |
110404250 | 1 | |
74510780 | 1 | |
60116020 | 1 | |
52710730 | 1 | |
46895640 | 1 |
지원금
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 102 |
---|---|
Distinct (%) | 21.8% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 82683.632 |
Minimum | 0 |
---|---|
Maximum | 843550 |
Zeros | 365 |
Zeros (%) | 76.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 641120 |
Maximum | 843550 |
Range | 843550 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 194540.85 |
---|---|
Coefficient of variation (CV) | 2.3528339 |
Kurtosis | 4.0133562 |
Mean | 82683.632 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 2.3160623 |
Sum | 38695940 |
Variance | 3.7846142 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 365 | |
452070 | 2 | 0.4% |
49270 | 2 | 0.4% |
117800 | 1 | 0.2% |
159780 | 1 | 0.2% |
243140 | 1 | 0.2% |
127320 | 1 | 0.2% |
220380 | 1 | 0.2% |
220880 | 1 | 0.2% |
282800 | 1 | 0.2% |
Other values (92) | 92 | 19.2% |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 365 | |
4300 | 1 | 0.2% |
4480 | 1 | 0.2% |
4700 | 1 | 0.2% |
9900 | 1 | 0.2% |
16600 | 1 | 0.2% |
17100 | 1 | 0.2% |
17900 | 1 | 0.2% |
31700 | 1 | 0.2% |
36500 | 1 | 0.2% |
Value | Count | Frequency (%) |
843550 | 1 | |
778840 | 1 | |
772250 | 1 | |
764500 | 1 | |
733750 | 1 | |
713900 | 1 | |
711900 | 1 | |
710950 | 1 | |
706750 | 1 | |
684000 | 1 |
장애인(C)
Real number (ℝ)
MISSING
  ZEROS
 
Distinct | 27 |
---|---|
Distinct (%) | 5.8% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7271.1538 |
Minimum | 0 |
---|---|
Maximum | 1660800 |
Zeros | 430 |
Zeros (%) | 89.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 5178 |
Maximum | 1660800 |
Range | 1660800 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 81788.724 |
---|---|
Coefficient of variation (CV) | 11.248383 |
Kurtosis | 360.78871 |
Mean | 7271.1538 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 18.16732 |
Sum | 3402900 |
Variance | 6.6893954 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 430 | |
1000 | 5 | 1.0% |
5220 | 3 | 0.6% |
2000 | 3 | 0.6% |
5310 | 3 | 0.6% |
23800 | 2 | 0.4% |
3000 | 2 | 0.4% |
250080 | 1 | 0.2% |
790 | 1 | 0.2% |
239540 | 1 | 0.2% |
Other values (17) | 17 | 3.5% |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 430 | |
790 | 1 | 0.2% |
1000 | 5 | 1.0% |
2000 | 3 | 0.6% |
2150 | 1 | 0.2% |
2860 | 1 | 0.2% |
3000 | 2 | 0.4% |
5100 | 1 | 0.2% |
5220 | 3 | 0.6% |
5310 | 3 | 0.6% |
Value | Count | Frequency (%) |
1660800 | 1 | |
366820 | 1 | |
283690 | 1 | |
250080 | 1 | |
239540 | 1 | |
172700 | 1 | |
132720 | 1 | |
52400 | 1 | |
51060 | 1 | |
24720 | 1 |
청구금액(D)
Real number (ℝ)
HIGH CORRELATION
  MISSING
  ZEROS
 
Distinct | 462 |
---|---|
Distinct (%) | 98.7% |
Missing | 12 |
Missing (%) | 2.5% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 79186751 |
Minimum | 0 |
---|---|
Maximum | 7.1416101 × 108 |
Zeros | 7 |
Zeros (%) | 1.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.3 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 368804.5 |
Q1 | 4577370 |
median | 16486260 |
Q3 | 1.1967872 × 108 |
95-th percentile | 2.653258 × 108 |
Maximum | 7.1416101 × 108 |
Range | 7.1416101 × 108 |
Interquartile range (IQR) | 1.1510134 × 108 |
Descriptive statistics
Standard deviation | 1.0389655 × 108 |
---|---|
Coefficient of variation (CV) | 1.3120446 |
Kurtosis | 7.6740321 |
Mean | 79186751 |
Median Absolute Deviation (MAD) | 16359210 |
Skewness | 2.2429573 |
Sum | 3.70594 × 1010 |
Variance | 1.0794493 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 7 | 1.5% |
26564080 | 1 | 0.2% |
10390530 | 1 | 0.2% |
69470800 | 1 | 0.2% |
2244100 | 1 | 0.2% |
163954630 | 1 | 0.2% |
8216110 | 1 | 0.2% |
53567520 | 1 | 0.2% |
2394670 | 1 | 0.2% |
119570980 | 1 | 0.2% |
Other values (452) | 452 | |
(Missing) | 12 | 2.5% |
Value | Count | Frequency (%) |
0 | 7 | |
11530 | 1 | 0.2% |
16370 | 1 | 0.2% |
49980 | 1 | 0.2% |
56890 | 1 | 0.2% |
62980 | 1 | 0.2% |
74290 | 1 | 0.2% |
75440 | 1 | 0.2% |
99890 | 1 | 0.2% |
154210 | 1 | 0.2% |
Value | Count | Frequency (%) |
714161010 | 1 | |
667277620 | 1 | |
639700040 | 1 | |
526277100 | 1 | |
499924640 | 1 | |
483414760 | 1 | |
444820060 | 1 | |
401923410 | 1 | |
365568390 | 1 | |
354065820 | 1 |
서식 | 인원(청구건수) | 요양급여총액 | 본인부담(B) | 지원금 | 장애인(C) | 청구금액(D) | |
---|---|---|---|---|---|---|---|
서식 | 1.000 | 0.683 | 0.777 | 0.452 | 0.532 | 0.203 | 0.845 |
인원(청구건수) | 0.683 | 1.000 | 0.873 | 0.751 | 0.743 | 0.000 | 0.852 |
요양급여총액 | 0.777 | 0.873 | 1.000 | 0.940 | 0.216 | 0.173 | 0.988 |
본인부담(B) | 0.452 | 0.751 | 0.940 | 1.000 | 0.461 | 0.072 | 0.910 |
지원금 | 0.532 | 0.743 | 0.216 | 0.461 | 1.000 | 0.205 | 0.311 |
장애인(C) | 0.203 | 0.000 | 0.173 | 0.072 | 0.205 | 1.000 | 0.164 |
청구금액(D) | 0.845 | 0.852 | 0.988 | 0.910 | 0.311 | 0.164 | 1.000 |
인원(청구건수) | 요양급여총액 | 본인부담(B) | 지원금 | 장애인(C) | 청구금액(D) | 서식 | |
---|---|---|---|---|---|---|---|
인원(청구건수) | 1.000 | 0.402 | 0.579 | 0.639 | 0.215 | 0.383 | 0.481 |
요양급여총액 | 0.402 | 1.000 | 0.734 | 0.082 | -0.058 | 0.991 | 0.589 |
본인부담(B) | 0.579 | 0.734 | 1.000 | 0.415 | 0.073 | 0.708 | 0.304 |
지원금 | 0.639 | 0.082 | 0.415 | 1.000 | 0.241 | 0.048 | 0.345 |
장애인(C) | 0.215 | -0.058 | 0.073 | 0.241 | 1.000 | -0.062 | 0.081 |
청구금액(D) | 0.383 | 0.991 | 0.708 | 0.048 | -0.062 | 1.000 | 0.686 |
서식 | 0.481 | 0.589 | 0.304 | 0.345 | 0.081 | 0.686 | 1.000 |
진료년월 | 서식 | 인원(청구건수) | 요양급여총액 | 본인부담(B) | 지원금 | 장애인(C) | 청구금액(D) | |
---|---|---|---|---|---|---|---|---|
0 | 2014-01 | 건강보험 외래 | 260 | 16766020 | 2627900 | 664250 | 0 | 14138120 |
1 | 2014-01 | 건강보험 입원 | 177 | 229439520 | 39539180 | 251520 | 172700 | 189727640 |
2 | 2014-01 | 의료급여 외래 | 37 | 1929460 | 73780 | 0 | 0 | 1855680 |
3 | 2014-01 | 의료급여 입원 | 81 | 118172210 | 206430 | 0 | 0 | 117965780 |
4 | 2014-02 | 건강보험 외래 | 248 | 14845890 | 2307600 | 584500 | 0 | 12538290 |
5 | 2014-02 | 건강보험 입원 | 162 | 204558620 | 35082300 | 214720 | 250080 | 169226240 |
6 | 2014-02 | 의료급여 외래 | 54 | 2878380 | 102010 | 0 | 10440 | 2765930 |
7 | 2014-02 | 의료급여 입원 | 75 | 97133660 | 0 | 0 | 0 | 97133660 |
8 | 2014-03 | 건강보험 외래 | 293 | 19557310 | 3849100 | 650300 | 0 | 15708210 |
9 | 2014-03 | 건강보험 입원 | 177 | 237044780 | 39899850 | 490440 | 283690 | 196861240 |
진료년월 | 서식 | 인원(청구건수) | 요양급여총액 | 본인부담(B) | 지원금 | 장애인(C) | 청구금액(D) | |
---|---|---|---|---|---|---|---|---|
470 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
471 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
472 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
473 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
474 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
475 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
476 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
477 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
478 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
479 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
Most frequently occurring
진료년월 | 서식 | 인원(청구건수) | 요양급여총액 | 본인부담(B) | 지원금 | 장애인(C) | 청구금액(D) | # duplicates | |
---|---|---|---|---|---|---|---|---|---|
0 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 12 |