Overview

Dataset statistics

Number of variables14
Number of observations21
Missing cells42
Missing cells (%)14.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory122.3 B

Variable types

Numeric1
Unsupported2
Categorical11

Alerts

환자수1 has constant value ""Constant
내원일수1 has constant value ""Constant
진료비1 has constant value ""Constant
환자수2 has constant value ""Constant
내원일수2 has constant value ""Constant
진료비2 has constant value ""Constant
환자수3 has constant value ""Constant
내원일수3 has constant value ""Constant
진료비3 has constant value ""Constant
생성날짜 has constant value ""Constant
상병명 has 21 (100.0%) missing valuesMissing
성별 has 21 (100.0%) missing valuesMissing
순번 has unique valuesUnique
상병명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
성별 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 11:25:45.551642
Analysis finished2023-12-10 11:25:46.390678
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-10T20:25:46.444838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median11
Q316
95-th percentile20
Maximum21
Range20
Interquartile range (IQR)10

Descriptive statistics

Standard deviation6.2048368
Coefficient of variation (CV)0.56407607
Kurtosis-1.2
Mean11
Median Absolute Deviation (MAD)5
Skewness0
Sum231
Variance38.5
MonotonicityStrictly increasing
2023-12-10T20:25:46.556269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1 1
 
4.8%
2 1
 
4.8%
21 1
 
4.8%
20 1
 
4.8%
19 1
 
4.8%
18 1
 
4.8%
17 1
 
4.8%
16 1
 
4.8%
15 1
 
4.8%
14 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
1 1
4.8%
2 1
4.8%
3 1
4.8%
4 1
4.8%
5 1
4.8%
6 1
4.8%
7 1
4.8%
8 1
4.8%
9 1
4.8%
10 1
4.8%
ValueCountFrequency (%)
21 1
4.8%
20 1
4.8%
19 1
4.8%
18 1
4.8%
17 1
4.8%
16 1
4.8%
15 1
4.8%
14 1
4.8%
13 1
4.8%
12 1
4.8%

상병명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing21
Missing (%)100.0%
Memory size321.0 B

성별
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing21
Missing (%)100.0%
Memory size321.0 B

연령
Categorical

Distinct10
Distinct (%)47.6%
Missing0
Missing (%)0.0%
Memory size300.0 B
전체
3 
10세미만
2 
10~19세
2 
20~29세
2 
30~39세
2 
Other values (5)
10 

Length

Max length6
Median length6
Mean length5.2380952
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전체
2nd row전체
3rd row10세미만
4th row10~19세
5th row20~29세

Common Values

ValueCountFrequency (%)
전체 3
14.3%
10세미만 2
9.5%
10~19세 2
9.5%
20~29세 2
9.5%
30~39세 2
9.5%
40~49세 2
9.5%
50~59세 2
9.5%
60~69세 2
9.5%
70~79세 2
9.5%
80세이상 2
9.5%

Length

2023-12-10T20:25:46.689639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:46.822757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전체 3
14.3%
10세미만 2
9.5%
10~19세 2
9.5%
20~29세 2
9.5%
30~39세 2
9.5%
40~49세 2
9.5%
50~59세 2
9.5%
60~69세 2
9.5%
70~79세 2
9.5%
80세이상 2
9.5%

환자수1
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2019]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2019]
2nd row0[2019]
3rd row0[2019]
4th row0[2019]
5th row0[2019]

Common Values

ValueCountFrequency (%)
0[2019] 21
100.0%

Length

2023-12-10T20:25:46.956992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:47.041957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2019 21
100.0%

내원일수1
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2019]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2019]
2nd row0[2019]
3rd row0[2019]
4th row0[2019]
5th row0[2019]

Common Values

ValueCountFrequency (%)
0[2019] 21
100.0%

Length

2023-12-10T20:25:47.134141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:47.249483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2019 21
100.0%

진료비1
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2019]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2019]
2nd row0[2019]
3rd row0[2019]
4th row0[2019]
5th row0[2019]

Common Values

ValueCountFrequency (%)
0[2019] 21
100.0%

Length

2023-12-10T20:25:47.362980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:47.465158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2019 21
100.0%

환자수2
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2018]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2018]
2nd row0[2018]
3rd row0[2018]
4th row0[2018]
5th row0[2018]

Common Values

ValueCountFrequency (%)
0[2018] 21
100.0%

Length

2023-12-10T20:25:47.578840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:47.695703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2018 21
100.0%

내원일수2
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2018]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2018]
2nd row0[2018]
3rd row0[2018]
4th row0[2018]
5th row0[2018]

Common Values

ValueCountFrequency (%)
0[2018] 21
100.0%

Length

2023-12-10T20:25:47.798635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:47.897635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2018 21
100.0%

진료비2
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2018]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2018]
2nd row0[2018]
3rd row0[2018]
4th row0[2018]
5th row0[2018]

Common Values

ValueCountFrequency (%)
0[2018] 21
100.0%

Length

2023-12-10T20:25:47.999089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:48.093421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2018 21
100.0%

환자수3
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2017]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2017]
2nd row0[2017]
3rd row0[2017]
4th row0[2017]
5th row0[2017]

Common Values

ValueCountFrequency (%)
0[2017] 21
100.0%

Length

2023-12-10T20:25:48.195615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:48.297386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2017 21
100.0%

내원일수3
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2017]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2017]
2nd row0[2017]
3rd row0[2017]
4th row0[2017]
5th row0[2017]

Common Values

ValueCountFrequency (%)
0[2017] 21
100.0%

Length

2023-12-10T20:25:48.402194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:48.529261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2017 21
100.0%

진료비3
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0[2017]
21 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0[2017]
2nd row0[2017]
3rd row0[2017]
4th row0[2017]
5th row0[2017]

Common Values

ValueCountFrequency (%)
0[2017] 21
100.0%

Length

2023-12-10T20:25:48.646972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:48.753122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0[2017 21
100.0%

생성날짜
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
20191217
21 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20191217 21
100.0%

Length

2023-12-10T20:25:48.857877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:25:48.977579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20191217 21
100.0%

Interactions

2023-12-10T20:25:45.730278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:25:49.049747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번연령
순번1.0000.576
연령0.5761.000
2023-12-10T20:25:49.134097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번연령
순번1.0000.000
연령0.0001.000

Missing values

2023-12-10T20:25:46.159348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:25:46.328083image/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

순번상병명성별연령환자수1내원일수1진료비1환자수2내원일수2진료비2환자수3내원일수3진료비3생성날짜
01<NA><NA>전체0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
12<NA><NA>전체0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
23<NA><NA>10세미만0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
34<NA><NA>10~19세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
45<NA><NA>20~29세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
56<NA><NA>30~39세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
67<NA><NA>40~49세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
78<NA><NA>50~59세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
89<NA><NA>60~69세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
910<NA><NA>70~79세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
순번상병명성별연령환자수1내원일수1진료비1환자수2내원일수2진료비2환자수3내원일수3진료비3생성날짜
1112<NA><NA>전체0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1213<NA><NA>10세미만0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1314<NA><NA>10~19세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1415<NA><NA>20~29세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1516<NA><NA>30~39세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1617<NA><NA>40~49세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1718<NA><NA>50~59세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1819<NA><NA>60~69세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
1920<NA><NA>70~79세0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217
2021<NA><NA>80세이상0[2019]0[2019]0[2019]0[2018]0[2018]0[2018]0[2017]0[2017]0[2017]20191217