Overview

Dataset statistics

Number of variables3
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory25.3 B

Variable types

Text2
Categorical1

Dataset

Description중앙보훈병원 요양병원 약품정보입니다. 중앙보훈병원 요양병원의 약품정보를 약품코드, 약품명, 규격으로 구분하여 제공합니다.
Author한국보훈복지의료공단
URLhttps://www.data.go.kr/data/15089750/fileData.do

Alerts

약품코드 has unique valuesUnique
약품명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:29:23.740818
Analysis finished2023-12-12 08:29:24.151860
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약품코드
Text

UNIQUE 

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

Length

Max length10
Median length9
Mean length7.97
Min length4

Characters and Unicode

Total characters797
Distinct characters27
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 row1070100126
2nd row1070100127
3rd row1070100128
4th row1070100129
5th row112003
ValueCountFrequency (%)
1070100126 1
 
1.0%
c48014 1
 
1.0%
d19055 1
 
1.0%
d19050 1
 
1.0%
d09195 1
 
1.0%
d09170 1
 
1.0%
d09140 1
 
1.0%
d09100 1
 
1.0%
d01220 1
 
1.0%
d01190 1
 
1.0%
Other values (90) 90
90.0%
2023-12-12T17:29:24.960318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 298
37.4%
1 125
15.7%
2 51
 
6.4%
3 49
 
6.1%
6 40
 
5.0%
8 40
 
5.0%
7 28
 
3.5%
9 28
 
3.5%
4 27
 
3.4%
5 23
 
2.9%
Other values (17) 88
 
11.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 709
89.0%
Uppercase Letter 88
 
11.0%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
D 16
18.2%
M 13
14.8%
F 12
13.6%
C 9
10.2%
S 5
 
5.7%
O 5
 
5.7%
H 5
 
5.7%
N 5
 
5.7%
B 4
 
4.5%
P 3
 
3.4%
Other values (7) 11
12.5%
Decimal Number
ValueCountFrequency (%)
0 298
42.0%
1 125
17.6%
2 51
 
7.2%
3 49
 
6.9%
6 40
 
5.6%
8 40
 
5.6%
7 28
 
3.9%
9 28
 
3.9%
4 27
 
3.8%
5 23
 
3.2%

Most occurring scripts

ValueCountFrequency (%)
Common 709
89.0%
Latin 88
 
11.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
D 16
18.2%
M 13
14.8%
F 12
13.6%
C 9
10.2%
S 5
 
5.7%
O 5
 
5.7%
H 5
 
5.7%
N 5
 
5.7%
B 4
 
4.5%
P 3
 
3.4%
Other values (7) 11
12.5%
Common
ValueCountFrequency (%)
0 298
42.0%
1 125
17.6%
2 51
 
7.2%
3 49
 
6.9%
6 40
 
5.6%
8 40
 
5.6%
7 28
 
3.9%
9 28
 
3.9%
4 27
 
3.8%
5 23
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 797
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 298
37.4%
1 125
15.7%
2 51
 
6.4%
3 49
 
6.1%
6 40
 
5.0%
8 40
 
5.0%
7 28
 
3.5%
9 28
 
3.5%
4 27
 
3.4%
5 23
 
2.9%
Other values (17) 88
 
11.0%

약품명
Text

UNIQUE 

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

Length

Max length52
Median length25
Mean length12.53
Min length1

Characters and Unicode

Total characters1253
Distinct characters283
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
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 (%)
기타 10
 
5.0%
7
 
3.5%
catheter 5
 
2.5%
silicone 5
 
2.5%
foley 5
 
2.5%
국산 4
 
2.0%
for 4
 
2.0%
및 4
 
2.0%
etc.(기타 3
 
1.5%
산제분포용 3
 
1.5%
Other values (141) 149
74.9%
2023-12-12T17:29:25.679426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
99
 
7.9%
e 48
 
3.8%
( 40
 
3.2%
) 40
 
3.2%
o 36
 
2.9%
l 32
 
2.6%
기 29
 
2.3%
t 28
 
2.2%
r 25
 
2.0%
a 25
 
2.0%
Other values (273) 851
67.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 597
47.6%
Lowercase Letter 340
27.1%
Space Separator 99
 
7.9%
Decimal Number 72
 
5.7%
Uppercase Letter 42
 
3.4%
Open Punctuation 40
 
3.2%
Close Punctuation 40
 
3.2%
Other Punctuation 21
 
1.7%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 29
 
4.9%
제 17
 
2.8%
타 14
 
2.3%
리 14
 
2.3%
이 14
 
2.3%
용 14
 
2.3%
포 12
 
2.0%
산 11
 
1.8%
주 10
 
1.7%
가 8
 
1.3%
Other values (222) 454
76.0%
Lowercase Letter
ValueCountFrequency (%)
e 48
14.1%
o 36
10.6%
l 32
9.4%
t 28
8.2%
r 25
 
7.4%
a 25
 
7.4%
i 23
 
6.8%
m 22
 
6.5%
c 18
 
5.3%
n 17
 
5.0%
Other values (9) 66
19.4%
Uppercase Letter
ValueCountFrequency (%)
C 10
23.8%
S 7
16.7%
F 6
14.3%
H 5
11.9%
R 3
 
7.1%
P 2
 
4.8%
L 2
 
4.8%
A 2
 
4.8%
O 1
 
2.4%
N 1
 
2.4%
Other values (3) 3
 
7.1%
Decimal Number
ValueCountFrequency (%)
0 22
30.6%
5 16
22.2%
2 9
12.5%
1 8
 
11.1%
4 6
 
8.3%
3 5
 
6.9%
9 2
 
2.8%
8 2
 
2.8%
6 1
 
1.4%
7 1
 
1.4%
Other Punctuation
ValueCountFrequency (%)
# 6
28.6%
% 6
28.6%
. 5
23.8%
/ 3
14.3%
* 1
 
4.8%
Space Separator
ValueCountFrequency (%)
99
100.0%
Open Punctuation
ValueCountFrequency (%)
( 40
100.0%
Close Punctuation
ValueCountFrequency (%)
) 40
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 597
47.6%
Latin 382
30.5%
Common 274
21.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 29
 
4.9%
제 17
 
2.8%
타 14
 
2.3%
리 14
 
2.3%
이 14
 
2.3%
용 14
 
2.3%
포 12
 
2.0%
산 11
 
1.8%
주 10
 
1.7%
가 8
 
1.3%
Other values (222) 454
76.0%
Latin
ValueCountFrequency (%)
e 48
12.6%
o 36
 
9.4%
l 32
 
8.4%
t 28
 
7.3%
r 25
 
6.5%
a 25
 
6.5%
i 23
 
6.0%
m 22
 
5.8%
c 18
 
4.7%
n 17
 
4.5%
Other values (22) 108
28.3%
Common
ValueCountFrequency (%)
99
36.1%
( 40
14.6%
) 40
14.6%
0 22
 
8.0%
5 16
 
5.8%
2 9
 
3.3%
1 8
 
2.9%
4 6
 
2.2%
# 6
 
2.2%
% 6
 
2.2%
Other values (9) 22
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 656
52.4%
Hangul 597
47.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
99
 
15.1%
e 48
 
7.3%
( 40
 
6.1%
) 40
 
6.1%
o 36
 
5.5%
l 32
 
4.9%
t 28
 
4.3%
r 25
 
3.8%
a 25
 
3.8%
i 23
 
3.5%
Other values (41) 260
39.6%
Hangul
ValueCountFrequency (%)
기 29
 
4.9%
제 17
 
2.8%
타 14
 
2.3%
리 14
 
2.3%
이 14
 
2.3%
용 14
 
2.3%
포 12
 
2.0%
산 11
 
1.8%
주 10
 
1.7%
가 8
 
1.3%
Other values (222) 454
76.0%

규격
Categorical

Distinct14
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
41 
EA
28 
KG
12 
BAG
7 
BTL
 
2
Other values (9)
10 

Length

Max length4
Median length3
Mean length3.01
Min length2

Unique

Unique8 ?
Unique (%)8.0%

Sample

1st rowEA
2nd rowEA
3rd rowSET
4th rowEA
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 41
41.0%
EA 28
28.0%
KG 12
 
12.0%
BAG 7
 
7.0%
BTL 2
 
2.0%
AMP 2
 
2.0%
SET 1
 
1.0%
kg 1
 
1.0%
CAN 1
 
1.0%
ea 1
 
1.0%
Other values (4) 4
 
4.0%

Length

2023-12-12T17:29:25.879237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 41
41.0%
ea 29
29.0%
kg 13
 
13.0%
bag 7
 
7.0%
btl 2
 
2.0%
amp 2
 
2.0%
set 1
 
1.0%
can 1
 
1.0%
bong 1
 
1.0%
bott 1
 
1.0%
Other values (2) 2
 
2.0%

Correlations

2023-12-12T17:29:25.996376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약품코드약품명규격
약품코드1.0001.0001.000
약품명1.0001.0001.000
규격1.0001.0001.000

Missing values

2023-12-12T17:29:24.027694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:29:24.112085image/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

약품코드약품명규격
01070100126산제분포기용 포장지(이지텍)EA
11070100127산제분포용 리본(이지텍)EA
21070100128산제분포용 먼지주머니(이지텍)SET
31070100129산제분포용 필터(이지텍)EA
4112003복사용품<NA>
5121032위생재료청구서(을)<NA>
612503의료분쟁배상책임보험<NA>
7131040수술(회복실모자)<NA>
8141009린넨류 (자체 제작 용품등)<NA>
9141056시트<NA>
약품코드약품명규격
90M45NS1씨제이0.45%생리식염주사액1lBAG
91M5DS500B대한5%포도당가생리식염액 500밀리리터BAG
92M5DSB씨제이5%포도당생리식염주사액1lBAG
93M5DW500B씨제이5%포도당주사액500ml(씨제이제일제당)BAG
94MHMORPHO11ml당 Hydromorphone HCl 1mgAMP
95MHMORPHO21ml당 Hydromorphone HCl 2mgAMP
96MHSOL헤파솔주500ml(제일약품)BTL
97MNAA중외네프라민주 250밀리리터(제이더블유중외제약)BAG
98MNS100B씨제이0.9%생리식염주사액 100mlBAG
99MNUT48뉴트리플렉스48주사1L(비브라운코리아)BAG