Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.7 KiB
Average record size in memory68.3 B

Variable types

Categorical5
Text2
Numeric1

Alerts

적용시작일자 has constant value ""Constant
투여경로명 has constant value ""Constant
규격명 has constant value ""Constant
급여구분명 has constant value ""Constant
단위 has constant value ""Constant
품목명 has unique valuesUnique
약품코드 has unique valuesUnique

Reproduction

Analysis started2023-12-10 12:00:22.374541
Analysis finished2023-12-10 12:00:22.991152
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

적용시작일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20100101
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20100101 100
100.0%

Length

2023-12-10T21:00:23.074917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:00:23.202840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20100101 100
100.0%

투여경로명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
내복
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
내복 100
100.0%

Length

2023-12-10T21:00:23.328543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:00:23.465636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
내복 100
100.0%

품목명
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T21:00:23.737167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length6.07
Min length4

Characters and Unicode

Total characters607
Distinct characters84
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row갈근엑스산
2nd row경방갈근엑스산
3rd row감국엑스산
4th row경방감국엑스산
5th row감초엑스산
ValueCountFrequency (%)
갈근엑스산 1
 
1.0%
생강엑스산 1
 
1.0%
경방승마엑스산 1
 
1.0%
승마엑스산 1
 
1.0%
숙지황엑스산 1
 
1.0%
경방자소엽엑스산 1
 
1.0%
소엽엑스산 1
 
1.0%
경방세신엑스산 1
 
1.0%
세신엑스산 1
 
1.0%
석고가루 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T21:00:24.284829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
산 100
16.5%
엑 98
16.1%
스 98
16.1%
경 47
 
7.7%
방 46
 
7.6%
지 13
 
2.1%
인 7
 
1.2%
황 7
 
1.2%
강 6
 
1.0%
출 6
 
1.0%
Other values (74) 179
29.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 607
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 100
16.5%
엑 98
16.1%
스 98
16.1%
경 47
 
7.7%
방 46
 
7.6%
지 13
 
2.1%
인 7
 
1.2%
황 7
 
1.2%
강 6
 
1.0%
출 6
 
1.0%
Other values (74) 179
29.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 607
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 100
16.5%
엑 98
16.1%
스 98
16.1%
경 47
 
7.7%
방 46
 
7.6%
지 13
 
2.1%
인 7
 
1.2%
황 7
 
1.2%
강 6
 
1.0%
출 6
 
1.0%
Other values (74) 179
29.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 607
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
산 100
16.5%
엑 98
16.1%
스 98
16.1%
경 47
 
7.7%
방 46
 
7.6%
지 13
 
2.1%
인 7
 
1.2%
황 7
 
1.2%
강 6
 
1.0%
출 6
 
1.0%
Other values (74) 179
29.5%

약품코드
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T21:00:24.652559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters800
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st rowA0001000
2nd rowA0001001
3rd rowA0002000
4th rowA0002001
5th rowA0003000
ValueCountFrequency (%)
a0001000 1
 
1.0%
a0035000 1
 
1.0%
a0041001 1
 
1.0%
a0041000 1
 
1.0%
a0040000 1
 
1.0%
a0039001 1
 
1.0%
a0039000 1
 
1.0%
a0038001 1
 
1.0%
a0038000 1
 
1.0%
a0037000 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T21:00:25.139514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 482
60.2%
A 100
 
12.5%
1 75
 
9.4%
4 29
 
3.6%
2 28
 
3.5%
3 27
 
3.4%
5 24
 
3.0%
8 10
 
1.2%
9 9
 
1.1%
7 8
 
1.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 700
87.5%
Uppercase Letter 100
 
12.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 482
68.9%
1 75
 
10.7%
4 29
 
4.1%
2 28
 
4.0%
3 27
 
3.9%
5 24
 
3.4%
8 10
 
1.4%
9 9
 
1.3%
7 8
 
1.1%
6 8
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
A 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 700
87.5%
Latin 100
 
12.5%

Most frequent character per script

Common
ValueCountFrequency (%)
0 482
68.9%
1 75
 
10.7%
4 29
 
4.1%
2 28
 
4.0%
3 27
 
3.9%
5 24
 
3.4%
8 10
 
1.4%
9 9
 
1.3%
7 8
 
1.1%
6 8
 
1.1%
Latin
ValueCountFrequency (%)
A 100
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 800
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 482
60.2%
A 100
 
12.5%
1 75
 
9.4%
4 29
 
3.6%
2 28
 
3.5%
3 27
 
3.4%
5 24
 
3.0%
8 10
 
1.2%
9 9
 
1.1%
7 8
 
1.0%

규격명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 100
100.0%

Length

2023-12-10T21:00:25.291789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:00:25.394318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 100
100.0%

급여구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
삭제
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
삭제 100
100.0%

Length

2023-12-10T21:00:25.509834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:00:25.632117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
삭제 100
100.0%

개당산출단가
Real number (ℝ)

Distinct70
Distinct (%)70.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean71.5117
Minimum11
Maximum880
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:00:26.092720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile26
Q136.75
median45.855
Q366.23
95-th percentile176.5
Maximum880
Range869
Interquartile range (IQR)29.48

Descriptive statistics

Standard deviation93.757659
Coefficient of variation (CV)1.3110814
Kurtosis56.701064
Mean71.5117
Median Absolute Deviation (MAD)12.855
Skewness6.8204098
Sum7151.17
Variance8790.4987
MonotonicityNot monotonic
2023-12-10T21:00:26.293687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
33.0 5
 
5.0%
43.0 4
 
4.0%
35.0 4
 
4.0%
38.0 4
 
4.0%
39.0 3
 
3.0%
61.11 3
 
3.0%
29.0 3
 
3.0%
36.0 3
 
3.0%
115.0 2
 
2.0%
11.0 2
 
2.0%
Other values (60) 67
67.0%
ValueCountFrequency (%)
11.0 2
 
2.0%
24.0 2
 
2.0%
26.0 2
 
2.0%
27.0 1
 
1.0%
28.89 1
 
1.0%
29.0 3
3.0%
32.0 1
 
1.0%
33.0 5
5.0%
34.0 1
 
1.0%
35.0 4
4.0%
ValueCountFrequency (%)
880.0 1
1.0%
273.53 1
1.0%
239.29 1
1.0%
198.0 1
1.0%
186.0 1
1.0%
176.0 1
1.0%
163.33 1
1.0%
140.0 1
1.0%
134.0 1
1.0%
130.56 1
1.0%

단위
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
g
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
g 100
100.0%

Length

2023-12-10T21:00:26.469157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:00:26.592362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
g 100
100.0%

Interactions

2023-12-10T21:00:22.631245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:00:26.672129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품목명약품코드개당산출단가
품목명1.0001.0001.000
약품코드1.0001.0001.000
개당산출단가1.0001.0001.000

Missing values

2023-12-10T21:00:22.768305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:00:22.923697image/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

적용시작일자투여경로명품목명약품코드규격명급여구분명개당산출단가단위
020100101내복갈근엑스산A00010001삭제26.0g
120100101내복경방갈근엑스산A00010011삭제28.89g
220100101내복감국엑스산A00020001삭제39.0g
320100101내복경방감국엑스산A00020011삭제45.35g
420100101내복감초엑스산A00030001삭제33.0g
520100101내복경방감초엑스산A00030011삭제61.11g
620100101내복강활엑스산A00040001삭제38.0g
720100101내복경방강활엑스산A00040011삭제65.52g
820100101내복건강엑스산A00050001삭제58.0g
920100101내복경방건강엑스산A00050011삭제65.91g
적용시작일자투여경로명품목명약품코드규격명급여구분명개당산출단가단위
9020100101내복지모엑스산A00510001삭제29.0g
9120100101내복경방지모엑스산A00510011삭제39.19g
9220100101내복지실엑스산A00520001삭제37.0g
9320100101내복경방지실엑스산A00520011삭제63.79g
9420100101내복진피엑스산A00530001삭제24.0g
9520100101내복경방진피엑스산A00530011삭제37.5g
9620100101내복창출엑스산A00540001삭제33.0g
9720100101내복경방창출엑스산A00540011삭제43.42g
9820100101내복천궁엑스산A00550001삭제43.0g
9920100101내복경방천궁엑스산A00550011삭제63.24g