gimi9 Pandas Profiling

Dataset statistics

Number of variables	11
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.0 MiB
Average record size in memory	106.0 B

Variable types

Numeric	8
Categorical	3

Dataset

Description	o 모집단: 해당년도 만 20세 이상 국민 건강보험 가입자 또는 의료급여수급권자(외국인 포함) o 내용: 해당년도 주·부상병 조건(I20-I25)의 만 20세 이상 환자의 진료에피소드 및 사망건수 o 진료에피소드 구축기준 - 진료개시일 간 간격이 28일 이내인 경우 동일한 진료에피소드로 간주함 - 선별조건 ① 1일 이상 입원 또는 1일 내 사망 또는 응급실 방문 또는 (최초발생 7일 내) 기관 간 전원 ② (최초발생 7일 내) 주 이용기관이 급성기병의원(요양병원 제외)인 경우 ③ (최초발생 7일 내) 주 이용기관에서 주·부상병 조건인 경우
URL	https://www.data.go.kr/data/15119957/fileData.do

Alerts

`광역시도` is highly overall correlated with `광역시도명`	High correlation
`인년` is highly overall correlated with `실 인원수`	High correlation
`실 인원수` is highly overall correlated with `인년`	High correlation
`입원에피소드 발생건수` is highly overall correlated with `발생 28일내 사망건수`	High correlation
`발생 28일내 사망건수` is highly overall correlated with `입원에피소드 발생건수`	High correlation
`광역시도명` is highly overall correlated with `광역시도`	High correlation
`소득수준` has 800 (8.0%) zeros	Zeros
`입원에피소드 발생건수` has 2105 (21.1%) zeros	Zeros
`발생 28일내 사망건수` has 7384 (73.8%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 02:05:15.003024
Analysis finished	2023-12-12 02:05:25.818558
Duration	10.82 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

발생년도
Real number (ℝ)

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2009.8102

Minimum	2006
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2006
5-th percentile	2006
Q1	2008
median	2010
Q3	2012
95-th percentile	2014
Maximum	2014
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.4550313
Coefficient of variation (CV)	0.001221524
Kurtosis	-1.162395
Mean	2009.8102
Median Absolute Deviation (MAD)	2
Skewness	0.004108151
Sum	20098102
Variance	6.0271787
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2011	1262	12.6%
2010	1233	12.3%
2013	1198	12.0%
2006	1174	11.7%
2009	1159	11.6%
2008	1140	11.4%
2012	1131	11.3%
2007	1099	11.0%
2014	604	6.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2006	1174	11.7%
2007	1099	11.0%
2008	1140	11.4%
2009	1159	11.6%
2010	1233	12.3%
2011	1262	12.6%
2012	1131	11.3%
2013	1198	12.0%
2014	604	6.0%

Value	Count	Frequency (%)
2014	604	6.0%
2013	1198	12.0%
2012	1131	11.3%
2011	1262	12.6%
2010	1233	12.3%
2009	1159	11.6%
2008	1140	11.4%
2007	1099	11.0%
2006	1174	11.7%

성별
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	5264
2	4736

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
1	5264	52.6%
2	4736	47.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5264	52.6%
2	4736	47.4%

5세 연령군
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.531

Minimum	20
Maximum	85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20
5-th percentile	20
Q1	35
median	55
Q3	70
95-th percentile	85
Maximum	85
Range	65
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	20.244135
Coefficient of variation (CV)	0.38537503
Kurtosis	-1.2314919
Mean	52.531
Median Absolute Deviation (MAD)	20
Skewness	-0.0078856025
Sum	525310
Variance	409.82502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
80	760	7.6%
30	746	7.5%
70	726	7.3%
75	722	7.2%
20	721	7.2%
35	719	7.2%
65	717	7.2%
50	717	7.2%
25	716	7.2%
55	707	7.1%
Other values (4)	2749	27.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	721	7.2%
25	716	7.2%
30	746	7.5%
35	719	7.2%
40	678	6.8%
45	688	6.9%
50	717	7.2%
55	707	7.1%
60	692	6.9%
65	717	7.2%

Value	Count	Frequency (%)
85	691	6.9%
80	760	7.6%
75	722	7.2%
70	726	7.3%
65	717	7.2%
60	692	6.9%
55	707	7.1%
50	717	7.2%
45	688	6.9%
40	678	6.8%

소득수준
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.6205

Minimum	0
Maximum	99
Zeros	800
Zeros (%)	8.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	14
95-th percentile	99
Maximum	99
Range	99
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	25.479886
Coefficient of variation (CV)	1.7427507
Kurtosis	6.6924762
Mean	14.6205
Median Absolute Deviation (MAD)	5
Skewness	2.8593656
Sum	146205
Variance	649.2246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	876	8.8%
1	871	8.7%
14	865	8.6%
5	858	8.6%
15	852	8.5%
3	840	8.4%
11	825	8.2%
13	806	8.1%
99	803	8.0%
4	802	8.0%
Other values (2)	1602	16.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	800	8.0%
1	871	8.7%
2	876	8.8%
3	840	8.4%
4	802	8.0%
5	858	8.6%
11	825	8.2%
12	802	8.0%
13	806	8.1%
14	865	8.6%

Value	Count	Frequency (%)
99	803	8.0%
15	852	8.5%
14	865	8.6%
13	806	8.1%
12	802	8.0%
11	825	8.2%
5	858	8.6%
4	802	8.0%
3	840	8.4%
2	876	8.8%

광역시도
Real number (ℝ)

HIGH CORRELATION

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.6583

Minimum	11
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	11
5-th percentile	26
Q1	30
median	42
Q3	46
95-th percentile	48
Maximum	50
Range	39
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.0675886
Coefficient of variation (CV)	0.23455736
Kurtosis	0.44127509
Mean	38.6583
Median Absolute Deviation (MAD)	5
Skewness	-1.0116249
Sum	386583
Variance	82.221163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
47	902	9.0%
41	882	8.8%
43	876	8.8%
45	781	7.8%
44	770	7.7%
48	738	7.4%
28	580	5.8%
42	574	5.7%
27	561	5.6%
46	551	5.5%
Other values (7)	2785	27.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	300	3.0%
26	543	5.4%
27	561	5.6%
28	580	5.8%
29	300	3.0%
30	296	3.0%
31	545	5.5%
36	491	4.9%
41	882	8.8%
42	574	5.7%

Value	Count	Frequency (%)
50	310	3.1%
48	738	7.4%
47	902	9.0%
46	551	5.5%
45	781	7.8%
44	770	7.7%
43	876	8.8%
42	574	5.7%
41	882	8.8%
36	491	4.9%

광역시도명
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

경상북도	902
경기도	882
충청북도	876
전라북도	781
충청남도	770
Other values (12)	5789

Length

Max length	7
Median length	5
Mean length	4.4072
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	경상남도
2nd row	울산광역시
3rd row	인천광역시
4th row	경기도
5th row	충청남도

Common Values

Value	Count	Frequency (%)
경상북도	902	9.0%
경기도	882	8.8%
충청북도	876	8.8%
전라북도	781	7.8%
충청남도	770	7.7%
경상남도	738	7.4%
인천광역시	580	5.8%
강원도	574	5.7%
대구광역시	561	5.6%
전라남도	551	5.5%
Other values (7)	2785	27.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
경상북도	902	9.0%
경기도	882	8.8%
충청북도	876	8.8%
전라북도	781	7.8%
충청남도	770	7.7%
경상남도	738	7.4%
인천광역시	580	5.8%
강원도	574	5.7%
대구광역시	561	5.6%
전라남도	551	5.5%
Other values (7)	2785	27.9%

구시군
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	3638
3	3572
2	2790

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	1
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
1	3638	36.4%
3	3572	35.7%
2	2790	27.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	3638	36.4%
3	3572	35.7%
2	2790	27.9%

인년
Real number (ℝ)

HIGH CORRELATION

Distinct	9529
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3380.922

Minimum	0.093
Maximum	98104.218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.093
5-th percentile	62.9915
Q1	434.7975
median	1243.876
Q3	3055.594
95-th percentile	13633.772
Maximum	98104.218
Range	98104.125
Interquartile range (IQR)	2620.7965

Descriptive statistics

Standard deviation	7193.3518
Coefficient of variation (CV)	2.1276302
Kurtosis	45.386144
Mean	3380.922
Median Absolute Deviation (MAD)	975.9235
Skewness	5.7593113
Sum	33809220
Variance	51744310
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.0	14	0.1%
1.0	13	0.1%
15.0	12	0.1%
8.0	11	0.1%
11.0	11	0.1%
9.0	10	0.1%
18.0	10	0.1%
13.0	7	0.1%
3.0	7	0.1%
6.0	7	0.1%
Other values (9519)	9898	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.093	1	< 0.1%
0.104	2	< 0.1%
0.118	1	< 0.1%
0.123	1	< 0.1%
0.137	1	< 0.1%
0.156	1	< 0.1%
0.304	1	< 0.1%
0.373	1	< 0.1%
0.414	1	< 0.1%
0.43	1	< 0.1%

Value	Count	Frequency (%)
98104.218	1	< 0.1%
92683.054	1	< 0.1%
90546.683	1	< 0.1%
88076.526	1	< 0.1%
87535.447	1	< 0.1%
87326.663	1	< 0.1%
86960.677	1	< 0.1%
86073.404	1	< 0.1%
85211.755	1	< 0.1%
83644.995	1	< 0.1%

실 인원수
Real number (ℝ)

HIGH CORRELATION

Distinct	4728
Distinct (%)	47.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3391.749

Minimum	1
Maximum	98126
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	66
Q1	441.75
median	1257
Q3	3077.25
95-th percentile	13647.15
Maximum	98126
Range	98125
Interquartile range (IQR)	2635.5

Descriptive statistics

Standard deviation	7196.6452
Coefficient of variation (CV)	2.1218095
Kurtosis	45.32274
Mean	3391.749
Median Absolute Deviation (MAD)	980.5
Skewness	5.7548555
Sum	33917490
Variance	51791702
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	25	0.2%
1	20	0.2%
4	17	0.2%
3	16	0.2%
15	16	0.2%
106	15	0.1%
45	14	0.1%
11	13	0.1%
9	13	0.1%
8	12	0.1%
Other values (4718)	9839	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	20	0.2%
2	25	0.2%
3	16	0.2%
4	17	0.2%
5	11	0.1%
6	11	0.1%
7	7	0.1%
8	12	0.1%
9	13	0.1%
10	7	0.1%

Value	Count	Frequency (%)
98126	1	< 0.1%
92700	1	< 0.1%
90562	1	< 0.1%
88084	1	< 0.1%
87545	1	< 0.1%
87360	1	< 0.1%
86969	1	< 0.1%
86090	1	< 0.1%
85230	1	< 0.1%
83658	1	< 0.1%

입원에피소드 발생건수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	242
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.8093

Minimum	0
Maximum	494
Zeros	2105
Zeros (%)	21.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	19
95-th percentile	73
Maximum	494
Range	494
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	35.676595
Coefficient of variation (CV)	2.0032564
Kurtosis	42.458365
Mean	17.8093
Median Absolute Deviation (MAD)	6
Skewness	5.3157835
Sum	178093
Variance	1272.8194
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2105	21.1%
1	840	8.4%
2	666	6.7%
3	474	4.7%
4	464	4.6%
5	349	3.5%
6	306	3.1%
7	288	2.9%
8	251	2.5%
9	250	2.5%
Other values (232)	4007	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2105	21.1%
1	840	8.4%
2	666	6.7%
3	474	4.7%
4	464	4.6%
5	349	3.5%
6	306	3.1%
7	288	2.9%
8	251	2.5%
9	250	2.5%

Value	Count	Frequency (%)
494	1	< 0.1%
492	1	< 0.1%
490	1	< 0.1%
463	1	< 0.1%
456	1	< 0.1%
452	1	< 0.1%
450	1	< 0.1%
442	1	< 0.1%
440	1	< 0.1%
415	1	< 0.1%

발생 28일내 사망건수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6032

Minimum	0
Maximum	25
Zeros	7384
Zeros (%)	73.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	25
Range	25
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.4993247
Coefficient of variation (CV)	2.4856179
Kurtosis	31.81693
Mean	0.6032
Median Absolute Deviation (MAD)	0
Skewness	4.5636755
Sum	6032
Variance	2.2479746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0	7384	73.8%
1	1343	13.4%
2	514	5.1%
3	306	3.1%
4	172	1.7%
5	82	0.8%
6	54	0.5%
7	50	0.5%
8	30	0.3%
9	25	0.2%
Other values (9)	40	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7384	73.8%
1	1343	13.4%
2	514	5.1%
3	306	3.1%
4	172	1.7%
5	82	0.8%
6	54	0.5%
7	50	0.5%
8	30	0.3%
9	25	0.2%

Value	Count	Frequency (%)
25	1	< 0.1%
18	3	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
14	4	< 0.1%
13	3	< 0.1%
12	4	< 0.1%
11	8	0.1%
10	13	0.1%
9	25	0.2%

Heatmap
Table

	발생년도	성별	5세 연령군	소득수준	광역시도	광역시도명	구시군	인년	실 인원수	입원에피소드 발생건수	발생 28일내 사망건수
발생년도	1.000	0.339	0.044	0.023	0.058	0.049	0.049	0.018	0.017	0.017	0.031
성별	0.339	1.000	0.032	0.000	0.005	0.000	0.000	0.000	0.000	0.070	0.041
5세 연령군	0.044	0.032	1.000	0.000	0.000	0.000	0.021	0.229	0.229	0.251	0.235
소득수준	0.023	0.000	0.000	1.000	0.021	0.032	0.019	0.158	0.158	0.167	0.162
광역시도	0.058	0.005	0.000	0.021	1.000	1.000	0.497	0.445	0.445	0.349	0.258
광역시도명	0.049	0.000	0.000	0.032	1.000	1.000	0.645	0.497	0.498	0.397	0.303
구시군	0.049	0.000	0.021	0.019	0.497	0.645	1.000	0.286	0.287	0.222	0.195
인년	0.018	0.000	0.229	0.158	0.445	0.497	0.286	1.000	1.000	0.462	0.062
실 인원수	0.017	0.000	0.229	0.158	0.445	0.498	0.287	1.000	1.000	0.464	0.069
입원에피소드 발생건수	0.017	0.070	0.251	0.167	0.349	0.397	0.222	0.462	0.464	1.000	0.530
발생 28일내 사망건수	0.031	0.041	0.235	0.162	0.258	0.303	0.195	0.062	0.069	0.530	1.000

Heatmap
Table

	구시군	성별	광역시도명
구시군	1.000	0.000	0.446
성별	0.000	1.000	0.000
광역시도명	0.446	0.000	1.000

Heatmap
Table

	발생년도	5세 연령군	소득수준	광역시도	인년	실 인원수	입원에피소드 발생건수	발생 28일내 사망건수	성별	광역시도명	구시군
발생년도	1.000	-0.015	0.002	0.016	0.058	0.058	0.021	-0.035	0.239	0.027	0.034
5세 연령군	-0.015	1.000	-0.002	0.021	-0.386	-0.379	0.407	0.449	0.025	0.000	0.012
소득수준	0.002	-0.002	1.000	-0.006	0.096	0.096	-0.120	-0.080	0.000	0.017	0.006
광역시도	0.016	0.021	-0.006	1.000	0.009	0.009	0.011	-0.005	0.004	1.000	0.364
인년	0.058	-0.386	0.096	0.009	1.000	1.000	0.467	0.136	0.000	0.218	0.178
실 인원수	0.058	-0.379	0.096	0.009	1.000	1.000	0.472	0.142	0.000	0.219	0.179
입원에피소드 발생건수	0.021	0.407	-0.120	0.011	0.467	0.472	1.000	0.570	0.054	0.166	0.135
발생 28일내 사망건수	-0.035	0.449	-0.080	-0.005	0.136	0.142	0.570	1.000	0.039	0.126	0.087
성별	0.239	0.025	0.000	0.004	0.000	0.000	0.054	0.039	1.000	0.000	0.000
광역시도명	0.027	0.000	0.017	1.000	0.218	0.219	0.166	0.126	0.000	1.000	0.446
구시군	0.034	0.012	0.006	0.364	0.178	0.179	0.135	0.087	0.000	0.446	1.000

Count
Matrix

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.

First rows
Last rows

	발생년도	성별	5세 연령군	소득수준	광역시도	광역시도명	구시군	인년	실 인원수	입원에피소드 발생건수	발생 28일내 사망건수
6696	2006	2	30	0	48	경상남도	3	385.726	387	0	0
34314	2008	2	80	14	31	울산광역시	3	182.989	189	5	0
92158	2013	2	60	4	28	인천광역시	1	3527.345	3531	19	0
22442	2007	2	80	5	41	경기도	1	2393.344	2456	54	6
9759	2006	2	65	5	44	충청남도	2	2258.287	2262	30	1
92251	2013	2	60	11	47	경상북도	1	1646.963	1650	8	0
84102	2013	1	35	1	50	제주특별자치도	2	1766.028	1769	6	1
47948	2010	1	35	1	48	경상남도	3	1427.708	1430	2	0
68308	2011	2	60	3	48	경상남도	1	1057.694	1060	2	0
8788	2006	2	55	1	43	충청북도	1	637.956	640	9	0

	발생년도	성별	5세 연령군	소득수준	광역시도	광역시도명	구시군	인년	실 인원수	입원에피소드 발생건수	발생 28일내 사망건수
27453	2008	1	70	5	27	대구광역시	1	1894.393	1919	46	3
97170	2014	1	50	3	41	경기도	1	15520.319	15564	63	0
59424	2011	1	25	13	48	경상남도	3	2777.685	2778	2	0
7661	2006	2	40	4	48	경상남도	2	10401.297	10405	10	0
99509	2014	1	75	15	28	인천광역시	3	270.652	275	5	0
86681	2013	1	65	3	45	전라북도	1	476.239	479	14	0
53456	2010	2	25	99	26	부산광역시	3	105.0	105	0	0
42084	2009	2	35	3	42	강원도	2	3688.543	3690	1	0
94365	2013	2	85	12	29	광주광역시	1	716.62	765	5	1
45157	2009	2	70	12	31	울산광역시	1	556.039	561	7	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample