Overview

Dataset statistics

Number of variables4
Number of observations69
Missing cells5
Missing cells (%)1.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory33.9 B

Variable types

Categorical1
Text3

Dataset

Description안양시 관내 의약품도매상에 대한 (안양시 관내 영업종별, 영업소소재지명, 영업소전화번호) 현황 데이터 정보입니다.
URLhttps://www.data.go.kr/data/3079494/fileData.do

Alerts

영업소전화번호 has 5 (7.2%) missing valuesMissing
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:49:03.431323
Analysis finished2023-12-12 09:49:03.902547
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업종별
Categorical

Distinct6
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size684.0 B
일반종합도매
48 
원료의약품도매
10 
의료용 고압가스
6 
한약도매
 
3
수입의약품도매
 
1

Length

Max length8
Median length6
Mean length6.2173913
Min length4

Unique

Unique2 ?
Unique (%)2.9%

Sample

1st row일반종합도매
2nd row일반종합도매
3rd row일반종합도매
4th row일반종합도매
5th row한약도매

Common Values

ValueCountFrequency (%)
일반종합도매 48
69.6%
원료의약품도매 10
 
14.5%
의료용 고압가스 6
 
8.7%
한약도매 3
 
4.3%
수입의약품도매 1
 
1.4%
시약도매 1
 
1.4%

Length

2023-12-12T18:49:03.997816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:49:04.120744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반종합도매 48
64.0%
원료의약품도매 10
 
13.3%
의료용 6
 
8.0%
고압가스 6
 
8.0%
한약도매 3
 
4.0%
수입의약품도매 1
 
1.3%
시약도매 1
 
1.3%

영업소명
Text

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T18:49:04.355000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length7.4637681
Min length3

Characters and Unicode

Total characters515
Distinct characters120
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique69 ?
Unique (%)100.0%

Sample

1st row주식회사 지엘바이오사이언스
2nd row주식회사 이노트
3rd row와이케이팜
4th row(주)예일선
5th row자명본초원
ValueCountFrequency (%)
주식회사 14
 
16.5%
지엘바이오사이언스 1
 
1.2%
주)인산엠티에스 1
 
1.2%
지엘루비콘(주 1
 
1.2%
메디웰 1
 
1.2%
영우팜(주 1
 
1.2%
세기약품 1
 
1.2%
안양종합가스 1
 
1.2%
오케이팜 1
 
1.2%
정성프라임 1
 
1.2%
Other values (62) 62
72.9%
2023-12-12T18:49:04.720284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 48
 
9.3%
) 35
 
6.8%
( 34
 
6.6%
이 28
 
5.4%
스 22
 
4.3%
팜 18
 
3.5%
사 16
 
3.1%
16
 
3.1%
회 14
 
2.7%
식 14
 
2.7%
Other values (110) 270
52.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 427
82.9%
Close Punctuation 35
 
6.8%
Open Punctuation 34
 
6.6%
Space Separator 16
 
3.1%
Other Symbol 2
 
0.4%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 48
 
11.2%
이 28
 
6.6%
스 22
 
5.2%
팜 18
 
4.2%
사 16
 
3.7%
회 14
 
3.3%
식 14
 
3.3%
디 12
 
2.8%
약 11
 
2.6%
메 11
 
2.6%
Other values (105) 233
54.6%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Space Separator
ValueCountFrequency (%)
16
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 429
83.3%
Common 86
 
16.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 48
 
11.2%
이 28
 
6.5%
스 22
 
5.1%
팜 18
 
4.2%
사 16
 
3.7%
회 14
 
3.3%
식 14
 
3.3%
디 12
 
2.8%
약 11
 
2.6%
메 11
 
2.6%
Other values (106) 235
54.8%
Common
ValueCountFrequency (%)
) 35
40.7%
( 34
39.5%
16
18.6%
- 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 427
82.9%
ASCII 86
 
16.7%
None 2
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 48
 
11.2%
이 28
 
6.6%
스 22
 
5.2%
팜 18
 
4.2%
사 16
 
3.7%
회 14
 
3.3%
식 14
 
3.3%
디 12
 
2.8%
약 11
 
2.6%
메 11
 
2.6%
Other values (105) 233
54.6%
ASCII
ValueCountFrequency (%)
) 35
40.7%
( 34
39.5%
16
18.6%
- 1
 
1.2%
None
ValueCountFrequency (%)
㈜ 2
100.0%

영업소소재지(도로명)
Text

Distinct68
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T18:49:05.016052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length67
Median length43
Mean length37.942029
Min length25

Characters and Unicode

Total characters2618
Distinct characters169
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

Unique67 ?
Unique (%)97.1%

Sample

1st row경기도 안양시 만안구 안양로329번길 108, 안양월드 지하2층 201호 (안양동)
2nd row경기도 안양시 만안구 안양로 336, 금강빌딩 3층 302호 (안양동)
3rd row경기도 안양시 만안구 안양로 82, 2층 (안양동)
4th row경기도 안양시 만안구 만안로 17, 210-A호 (안양동, 명지캐럿162주상복합아파트)
5th row경기도 안양시 만안구 박달로 488, 도원프라자 1층 102(일부)호 (박달동)
ValueCountFrequency (%)
경기도 69
 
12.5%
안양시 69
 
12.5%
동안구 51
 
9.2%
관양동 26
 
4.7%
만안구 18
 
3.3%
호계동 15
 
2.7%
시민대로 12
 
2.2%
안양동 10
 
1.8%
비산동 9
 
1.6%
3층 9
 
1.6%
Other values (193) 265
47.9%
2023-12-12T18:49:05.456478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
484
 
18.5%
안 175
 
6.7%
동 127
 
4.9%
양 124
 
4.7%
시 84
 
3.2%
1 79
 
3.0%
, 76
 
2.9%
경 75
 
2.9%
로 75
 
2.9%
도 71
 
2.7%
Other values (159) 1248
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1461
55.8%
Space Separator 484
 
18.5%
Decimal Number 419
 
16.0%
Other Punctuation 78
 
3.0%
Close Punctuation 70
 
2.7%
Open Punctuation 70
 
2.7%
Uppercase Letter 18
 
0.7%
Dash Punctuation 12
 
0.5%
Lowercase Letter 6
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 175
 
12.0%
동 127
 
8.7%
양 124
 
8.5%
시 84
 
5.7%
경 75
 
5.1%
로 75
 
5.1%
도 71
 
4.9%
구 69
 
4.7%
기 69
 
4.7%
호 57
 
3.9%
Other values (129) 535
36.6%
Decimal Number
ValueCountFrequency (%)
1 79
18.9%
2 58
13.8%
0 49
11.7%
3 48
11.5%
4 45
10.7%
6 38
9.1%
5 33
7.9%
8 30
 
7.2%
7 23
 
5.5%
9 16
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
B 6
33.3%
A 4
22.2%
O 2
 
11.1%
F 1
 
5.6%
C 1
 
5.6%
S 1
 
5.6%
K 1
 
5.6%
V 1
 
5.6%
W 1
 
5.6%
Lowercase Letter
ValueCountFrequency (%)
e 2
33.3%
n 1
16.7%
c 1
16.7%
t 1
16.7%
r 1
16.7%
Other Punctuation
ValueCountFrequency (%)
, 76
97.4%
. 2
 
2.6%
Space Separator
ValueCountFrequency (%)
484
100.0%
Close Punctuation
ValueCountFrequency (%)
) 70
100.0%
Open Punctuation
ValueCountFrequency (%)
( 70
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1461
55.8%
Common 1133
43.3%
Latin 24
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 175
 
12.0%
동 127
 
8.7%
양 124
 
8.5%
시 84
 
5.7%
경 75
 
5.1%
로 75
 
5.1%
도 71
 
4.9%
구 69
 
4.7%
기 69
 
4.7%
호 57
 
3.9%
Other values (129) 535
36.6%
Common
ValueCountFrequency (%)
484
42.7%
1 79
 
7.0%
, 76
 
6.7%
) 70
 
6.2%
( 70
 
6.2%
2 58
 
5.1%
0 49
 
4.3%
3 48
 
4.2%
4 45
 
4.0%
6 38
 
3.4%
Other values (6) 116
 
10.2%
Latin
ValueCountFrequency (%)
B 6
25.0%
A 4
16.7%
e 2
 
8.3%
O 2
 
8.3%
F 1
 
4.2%
C 1
 
4.2%
n 1
 
4.2%
S 1
 
4.2%
K 1
 
4.2%
V 1
 
4.2%
Other values (4) 4
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1461
55.8%
ASCII 1157
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
484
41.8%
1 79
 
6.8%
, 76
 
6.6%
) 70
 
6.1%
( 70
 
6.1%
2 58
 
5.0%
0 49
 
4.2%
3 48
 
4.1%
4 45
 
3.9%
6 38
 
3.3%
Other values (20) 140
 
12.1%
Hangul
ValueCountFrequency (%)
안 175
 
12.0%
동 127
 
8.7%
양 124
 
8.5%
시 84
 
5.7%
경 75
 
5.1%
로 75
 
5.1%
도 71
 
4.9%
구 69
 
4.7%
기 69
 
4.7%
호 57
 
3.9%
Other values (129) 535
36.6%

영업소전화번호
Text

MISSING 

Distinct64
Distinct (%)100.0%
Missing5
Missing (%)7.2%
Memory size684.0 B
2023-12-12T18:49:05.779379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.109375
Min length7

Characters and Unicode

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

Unique

Unique64 ?
Unique (%)100.0%

Sample

1st row070-4351-6916
2nd row031-446-0099
3rd row031-341-4228
4th row031-443-3331
5th row031-449-0458
ValueCountFrequency (%)
070-8787-9369 1
 
1.6%
031-469-1400 1
 
1.6%
031-455-1500 1
 
1.6%
031)452-4852 1
 
1.6%
031)452-1533 1
 
1.6%
031)421-5757 1
 
1.6%
031-426-0011 1
 
1.6%
031-388-5860 1
 
1.6%
031)348-0904 1
 
1.6%
02-847-7733 1
 
1.6%
Other values (54) 54
84.4%
2023-12-12T18:49:06.280048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 120
15.5%
0 108
13.9%
3 91
11.7%
1 86
11.1%
2 69
8.9%
4 66
8.5%
8 58
7.5%
7 48
 
6.2%
5 47
 
6.1%
6 40
 
5.2%
Other values (4) 42
 
5.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 648
83.6%
Dash Punctuation 120
 
15.5%
Close Punctuation 5
 
0.6%
Other Punctuation 1
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 108
16.7%
3 91
14.0%
1 86
13.3%
2 69
10.6%
4 66
10.2%
8 58
9.0%
7 48
7.4%
5 47
7.3%
6 40
 
6.2%
9 35
 
5.4%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 775
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 120
15.5%
0 108
13.9%
3 91
11.7%
1 86
11.1%
2 69
8.9%
4 66
8.5%
8 58
7.5%
7 48
 
6.2%
5 47
 
6.1%
6 40
 
5.2%
Other values (4) 42
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 775
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 120
15.5%
0 108
13.9%
3 91
11.7%
1 86
11.1%
2 69
8.9%
4 66
8.5%
8 58
7.5%
7 48
 
6.2%
5 47
 
6.1%
6 40
 
5.2%
Other values (4) 42
 
5.4%

Correlations

2023-12-12T18:49:06.404362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업종별영업소명영업소소재지(도로명)영업소전화번호
영업종별1.0001.0001.0001.000
영업소명1.0001.0001.0001.000
영업소소재지(도로명)1.0001.0001.0001.000
영업소전화번호1.0001.0001.0001.000

Missing values

2023-12-12T18:49:03.763969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:49:03.859137image/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

영업종별영업소명영업소소재지(도로명)영업소전화번호
0일반종합도매주식회사 지엘바이오사이언스경기도 안양시 만안구 안양로329번길 108, 안양월드 지하2층 201호 (안양동)070-4351-6916
1일반종합도매주식회사 이노트경기도 안양시 만안구 안양로 336, 금강빌딩 3층 302호 (안양동)031-446-0099
2일반종합도매와이케이팜경기도 안양시 만안구 안양로 82, 2층 (안양동)031-341-4228
3일반종합도매(주)예일선경기도 안양시 만안구 만안로 17, 210-A호 (안양동, 명지캐럿162주상복합아파트)031-443-3331
4한약도매자명본초원경기도 안양시 만안구 박달로 488, 도원프라자 1층 102(일부)호 (박달동)031-449-0458
5일반종합도매(주)메디스토어경기도 안양시 만안구 오리로34번길 7-31, 2층 일부호 (박달동)070-4422-6188
6의료용 고압가스삼성종합가스(고압)경기도 안양시 만안구 만안로340번길 4 (안양동)031-456-5776
7의료용 고압가스미래산업가스경기도 안양시 만안구 전파로44번길 19, 2층 (안양동)031-449-7771,2
8일반종합도매(주)헬스팜경기도 안양시 만안구 예술공원로 72, 2층 (안양동)031-472-3335
9일반종합도매(주)다복메디칼경기도 안양시 만안구 박달로 406, 삼봉프라자 3층 (박달동)02-6959-1599
영업종별영업소명영업소소재지(도로명)영업소전화번호
59일반종합도매(주)비앤씨코리아경기도 안양시 동안구 벌말로 66, 평촌역 하이필드 B-O1214,O1215호 (관양동)1599-0341
60일반종합도매(주)월드팜경기도 안양시 동안구 관악대로 280, 3층 (관양동)031-384-8866
61일반종합도매(주)서울메디원경기도 안양시 동안구 관악대로 354, 정한빌딩 3층 301호 (관양동)031-388-9253
62일반종합도매(주)에이치팜경기도 안양시 동안구 벌말로 146, 3동 4층 (관양동)031-454-2547~8
63일반종합도매㈜지에스팜경기도 안양시 동안구 엘에스로 42, 401호 (호계동, 경륭빌딩)031-424-7001
64원료의약품도매㈜에스지바이오켐경기도 안양시 동안구 동편로183번길 67-6 (관양동)031-383-1268
65원료의약품도매(주)제이에이에이치티경기도 안양시 동안구 시민대로 230, A동 408호 (관양동, 대림아크로타워)031-478-9370
66일반종합도매한국비그팜(주)경기도 안양시 동안구 평촌대로374번길 9-21, 지하1층 (비산동)031-381-4660
67일반종합도매금청약품(주)경기도 안양시 동안구 엘에스로116번길 118, 안양2차 SK V1 center 731,732, B104일부호 (호계동)031-427-8669
68원료의약품도매(주)세일약품경기도 안양시 동안구 관악대로 298, 도명빌딩 402호 (관양동)031-427-0991