Overview

Dataset statistics

Number of variables3
Number of observations101
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

DateTime1
Text2

Dataset

Description질병관리청 국립목포병원 거래처 목록에 대한 데이터로 분기별 의료부분의 거래처리스트(코드 및 회사명)을 제공합니다.
URLhttps://www.data.go.kr/data/15073626/fileData.do

Alerts

거래처코드 has unique valuesUnique

Reproduction

Analysis started2023-12-12 04:38:49.099183
Analysis finished2023-12-12 04:38:49.494468
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록일자
Date

Distinct89
Distinct (%)88.1%
Missing0
Missing (%)0.0%
Memory size940.0 B
Minimum2012-11-06 00:00:00
Maximum2021-12-30 00:00:00
2023-12-12T13:38:49.587562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:38:49.787000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

거래처코드
Text

UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-12T13:38:50.167132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length4
Min length4

Characters and Unicode

Total characters404
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

Unique101 ?
Unique (%)100.0%

Sample

1st rowZ001
2nd rowZ002
3rd rowZ003
4th rowZ004
5th rowZ005
ValueCountFrequency (%)
z001 1
 
1.0%
z054 1
 
1.0%
z080 1
 
1.0%
z079 1
 
1.0%
z078 1
 
1.0%
z076 1
 
1.0%
z074 1
 
1.0%
z073 1
 
1.0%
z072 1
 
1.0%
zzzz 1
 
1.0%
Other values (91) 91
90.1%
2023-12-12T13:38:50.716588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 118
29.2%
Z 104
25.7%
1 29
 
7.2%
4 21
 
5.2%
2 21
 
5.2%
5 20
 
5.0%
8 20
 
5.0%
3 19
 
4.7%
6 18
 
4.5%
9 18
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
74.3%
Uppercase Letter 104
 
25.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 118
39.3%
1 29
 
9.7%
4 21
 
7.0%
2 21
 
7.0%
5 20
 
6.7%
8 20
 
6.7%
3 19
 
6.3%
6 18
 
6.0%
9 18
 
6.0%
7 16
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
Z 104
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 300
74.3%
Latin 104
 
25.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 118
39.3%
1 29
 
9.7%
4 21
 
7.0%
2 21
 
7.0%
5 20
 
6.7%
8 20
 
6.7%
3 19
 
6.3%
6 18
 
6.0%
9 18
 
6.0%
7 16
 
5.3%
Latin
ValueCountFrequency (%)
Z 104
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 404
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 118
29.2%
Z 104
25.7%
1 29
 
7.2%
4 21
 
5.2%
2 21
 
5.2%
5 20
 
5.0%
8 20
 
5.0%
3 19
 
4.7%
6 18
 
4.5%
9 18
 
4.5%

거래처명
Text

Distinct100
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-12T13:38:51.111104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length6.950495
Min length2

Characters and Unicode

Total characters702
Distinct characters191
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique99 ?
Unique (%)98.0%

Sample

1st row유달약품
2nd row안성약품
3rd row보건약품
4th row씨엘피앤디
5th row삼성메디칼
ValueCountFrequency (%)
국립목포병원 3
 
2.5%
질병관리본부 3
 
2.5%
보건소 2
 
1.6%
주 2
 
1.6%
국제약품 1
 
0.8%
재고등록거래처(최초등록 1
 
0.8%
부천시 1
 
0.8%
오성시스템 1
 
0.8%
국립중앙의료원 1
 
0.8%
태종약품 1
 
0.8%
Other values (106) 106
86.9%
2023-12-12T13:38:51.677074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 30
 
4.3%
( 25
 
3.6%
24
 
3.4%
진 20
 
2.8%
약 19
 
2.7%
메 18
 
2.6%
디 18
 
2.6%
원 17
 
2.4%
품 17
 
2.4%
병 15
 
2.1%
Other values (181) 499
71.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 614
87.5%
Close Punctuation 30
 
4.3%
Open Punctuation 25
 
3.6%
Space Separator 24
 
3.4%
Uppercase Letter 6
 
0.9%
Other Symbol 1
 
0.1%
Other Punctuation 1
 
0.1%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
진 20
 
3.3%
약 19
 
3.1%
메 18
 
2.9%
디 18
 
2.9%
원 17
 
2.8%
품 17
 
2.8%
병 15
 
2.4%
검 15
 
2.4%
이 14
 
2.3%
국 14
 
2.3%
Other values (169) 447
72.8%
Uppercase Letter
ValueCountFrequency (%)
J 1
16.7%
H 1
16.7%
L 1
16.7%
G 1
16.7%
K 1
16.7%
S 1
16.7%
Close Punctuation
ValueCountFrequency (%)
) 30
100.0%
Open Punctuation
ValueCountFrequency (%)
( 25
100.0%
Space Separator
ValueCountFrequency (%)
24
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 615
87.6%
Common 81
 
11.5%
Latin 6
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
진 20
 
3.3%
약 19
 
3.1%
메 18
 
2.9%
디 18
 
2.9%
원 17
 
2.8%
품 17
 
2.8%
병 15
 
2.4%
검 15
 
2.4%
이 14
 
2.3%
국 14
 
2.3%
Other values (170) 448
72.8%
Latin
ValueCountFrequency (%)
J 1
16.7%
H 1
16.7%
L 1
16.7%
G 1
16.7%
K 1
16.7%
S 1
16.7%
Common
ValueCountFrequency (%)
) 30
37.0%
( 25
30.9%
24
29.6%
. 1
 
1.2%
2 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 614
87.5%
ASCII 87
 
12.4%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 30
34.5%
( 25
28.7%
24
27.6%
J 1
 
1.1%
H 1
 
1.1%
L 1
 
1.1%
G 1
 
1.1%
K 1
 
1.1%
S 1
 
1.1%
. 1
 
1.1%
Hangul
ValueCountFrequency (%)
진 20
 
3.3%
약 19
 
3.1%
메 18
 
2.9%
디 18
 
2.9%
원 17
 
2.8%
품 17
 
2.8%
병 15
 
2.4%
검 15
 
2.4%
이 14
 
2.3%
국 14
 
2.3%
Other values (169) 447
72.8%
None
ValueCountFrequency (%)
㈜ 1
100.0%

Correlations

2023-12-12T13:38:51.789956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일자거래처명
등록일자1.0001.000
거래처명1.0001.000

Missing values

2023-12-12T13:38:49.352396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:38:49.456233image/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

등록일자거래처코드거래처명
02012-11-06Z001유달약품
12012-11-14Z002안성약품
22012-11-16Z003보건약품
32012-11-16Z004씨엘피앤디
42012-11-20Z005삼성메디칼
52012-11-20Z006푸른약품
62012-11-20Z007에스케이
72013-01-15Z008국립마산병원
82013-02-14Z009태원약품
92013-03-26Z010목포중앙병원
등록일자거래처코드거래처명
912020-10-05Z099나눔테크
922020-11-12Z100유카드 소프트
932020-12-11Z101가상으로 선입고
942020-12-17Z102강남의료기(진검)
952021-03-02Z103새보람메디칼
962021-03-29Z104질병관리청 비축물자관리과
972021-04-22Z105비에이치메디칼
982021-05-28Z106전남장애인생산품판매시설
992021-07-14Z107GL파마
1002021-12-30Z108HK이노엔