Overview

Dataset statistics

Number of variables4
Number of observations1039
Missing cells0
Missing cells (%)0.0%
Duplicate rows117
Duplicate rows (%)11.3%
Total size in memory33.6 KiB
Average record size in memory33.1 B

Variable types

Categorical3
Numeric1

Dataset

Description광주보훈병원에서 개방하는 월별 진료과별 퇴원환자 퇴원결과 현황 데이터로 월,퇴원과,퇴원결과,건수가 포함된 데이터입니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/15116553/fileData.do

Alerts

Dataset has 117 (11.3%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-21 02:57:08.085688
Analysis finished2024-04-21 02:57:08.934000
Duration0.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables


Categorical

Distinct12
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2022-02
194 
2022-03
179 
2022-04
169 
2022-05
133 
2022-01
100 
Other values (7)
264 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-01
2nd row2022-01
3rd row2022-01
4th row2022-01
5th row2022-01

Common Values

ValueCountFrequency (%)
2022-02 194
18.7%
2022-03 179
17.2%
2022-04 169
16.3%
2022-05 133
12.8%
2022-01 100
9.6%
2022-07 42
 
4.0%
2022-10 40
 
3.8%
2022-12 40
 
3.8%
2022-06 38
 
3.7%
2022-08 38
 
3.7%
Other values (2) 66
 
6.4%

Length

2024-04-21T11:57:09.039582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-02 194
18.7%
2022-03 179
17.2%
2022-04 169
16.3%
2022-05 133
12.8%
2022-01 100
9.6%
2022-07 42
 
4.0%
2022-10 40
 
3.8%
2022-12 40
 
3.8%
2022-06 38
 
3.7%
2022-08 38
 
3.7%
Other values (2) 66
 
6.4%

퇴원과
Categorical

Distinct18
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
비뇨의학과
125 
호흡기내과
95 
외과
86 
응급의학과
82 
신경과
78 
Other values (13)
573 

Length

Max length6
Median length5
Mean length4.5024062
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row순환기내과
2nd row내분비내과
3rd row응급의학과
4th row신장내과
5th row호흡기내과

Common Values

ValueCountFrequency (%)
비뇨의학과 125
12.0%
호흡기내과 95
9.1%
외과 86
 
8.3%
응급의학과 82
 
7.9%
신경과 78
 
7.5%
가정의학과 73
 
7.0%
순환기내과 71
 
6.8%
재활의학과 68
 
6.5%
신장내과 65
 
6.3%
소화기내과 61
 
5.9%
Other values (8) 235
22.6%

Length

2024-04-21T11:57:09.262975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
비뇨의학과 125
12.0%
호흡기내과 95
9.1%
외과 86
 
8.3%
응급의학과 82
 
7.9%
신경과 78
 
7.5%
가정의학과 73
 
7.0%
순환기내과 71
 
6.8%
재활의학과 68
 
6.5%
신장내과 65
 
6.3%
소화기내과 61
 
5.9%
Other values (8) 235
22.6%

퇴원결과
Categorical

Distinct8
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
호전
456 
48시간 후 사망
171 
경쾌
123 
불변(호전안됨)
113 
진단만실시
97 
Other values (3)
79 

Length

Max length9
Median length2
Mean length4.4716073
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row48시간 후 사망
2nd row호전
3rd row호전
4th row경쾌
5th row불변(호전안됨)

Common Values

ValueCountFrequency (%)
호전 456
43.9%
48시간 후 사망 171
 
16.5%
경쾌 123
 
11.8%
불변(호전안됨) 113
 
10.9%
진단만실시 97
 
9.3%
48시간 전 사망 47
 
4.5%
치료안함 29
 
2.8%
가망없는 퇴원 3
 
0.3%

Length

2024-04-21T11:57:09.504512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T11:57:09.741046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
호전 456
30.9%
48시간 218
14.7%
사망 218
14.7%
171
 
11.6%
경쾌 123
 
8.3%
불변(호전안됨 113
 
7.6%
진단만실시 97
 
6.6%
47
 
3.2%
치료안함 29
 
2.0%
가망없는 3
 
0.2%

건수
Real number (ℝ)

Distinct70
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.0240616
Minimum1
Maximum115
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.3 KiB
2024-04-21T11:57:09.989399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median3
Q311
95-th percentile43
Maximum115
Range114
Interquartile range (IQR)10

Descriptive statistics

Standard deviation14.355063
Coefficient of variation (CV)1.5907541
Kurtosis10.597795
Mean9.0240616
Median Absolute Deviation (MAD)2
Skewness2.9462763
Sum9376
Variance206.06782
MonotonicityNot monotonic
2024-04-21T11:57:10.260483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 350
33.7%
2 151
14.5%
3 75
 
7.2%
4 53
 
5.1%
5 36
 
3.5%
7 29
 
2.8%
6 27
 
2.6%
9 22
 
2.1%
8 18
 
1.7%
13 18
 
1.7%
Other values (60) 260
25.0%
ValueCountFrequency (%)
1 350
33.7%
2 151
14.5%
3 75
 
7.2%
4 53
 
5.1%
5 36
 
3.5%
6 27
 
2.6%
7 29
 
2.8%
8 18
 
1.7%
9 22
 
2.1%
10 17
 
1.6%
ValueCountFrequency (%)
115 1
0.1%
104 1
0.1%
90 1
0.1%
88 1
0.1%
83 1
0.1%
81 1
0.1%
74 1
0.1%
73 1
0.1%
70 1
0.1%
69 1
0.1%

Interactions

2024-04-21T11:57:08.358419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T11:57:10.635432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
퇴원과퇴원결과건수
1.0000.0000.0660.184
퇴원과0.0001.0000.5470.406
퇴원결과0.0660.5471.0000.307
건수0.1840.4060.3071.000
2024-04-21T11:57:10.788090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
퇴원과퇴원결과
1.0000.0000.028
퇴원과0.0001.0000.264
퇴원결과0.0280.2641.000
2024-04-21T11:57:10.937945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건수퇴원과퇴원결과
건수1.0000.0790.1450.155
0.0791.0000.0000.028
퇴원과0.1450.0001.0000.264
퇴원결과0.1550.0280.2641.000

Missing values

2024-04-21T11:57:08.698224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T11:57:08.875941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

퇴원과퇴원결과건수
02022-01순환기내과48시간 후 사망2
12022-01내분비내과호전5
22022-01응급의학과호전20
32022-01신장내과경쾌2
42022-01호흡기내과불변(호전안됨)4
52022-02안과호전21
62022-02가정의학과경쾌1
72022-03순환기내과경쾌4
82022-03호흡기내과호전12
92022-03순환기내과호전39
퇴원과퇴원결과건수
10292022-05신장내과호전2
10302022-05외과48시간 후 사망1
10312022-05신경과48시간 전 사망1
10322022-05신장내과호전2
10332022-05소아청소년과진단만실시4
10342022-05호흡기내과48시간 후 사망2
10352022-05가정의학과48시간 후 사망2
10362022-05외과호전6
10372022-05소화기내과진단만실시1
10382022-05재활의학과호전4

Duplicate rows

Most frequently occurring

퇴원과퇴원결과건수# duplicates
552022-03외과48시간 후 사망17
152022-02비뇨의학과불변(호전안됨)14
282022-02신장내과호전34
412022-02호흡기내과불변(호전안됨)14
572022-03응급의학과48시간 후 사망24
732022-04비뇨의학과불변(호전안됨)14
142022-02비뇨의학과경쾌13
162022-02비뇨의학과진단만실시93
182022-02비뇨의학과치료안함13
312022-02외과치료안함13