Overview

Dataset statistics

Number of variables3
Number of observations52
Missing cells10
Missing cells (%)6.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory26.5 B

Variable types

Text3

Dataset

Description부산광역시_금정구_의약품도매상현황_20220518
Author부산광역시 금정구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15025847

Alerts

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

Reproduction

Analysis started2023-12-10 16:35:31.664447
Analysis finished2023-12-10 16:35:32.035359
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업소명
Text

UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-11T01:35:32.218824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length5.4807692
Min length3

Characters and Unicode

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

Unique

Unique52 ?
Unique (%)100.0%

Sample

1st row에스와이팜 주식회사
2nd row세계로약품
3rd row이지팜
4th row미강팜
5th row(주)다인파마
ValueCountFrequency (%)
주식회사 2
 
3.6%
에스와이팜 1
 
1.8%
정산약품(주 1
 
1.8%
내츄럴원더스 1
 
1.8%
송인약품 1
 
1.8%
홍인메디칼 1
 
1.8%
스마일덕성팜 1
 
1.8%
주)청운메디 1
 
1.8%
주)씨앤디팜 1
 
1.8%
바이오메딕스코리아 1
 
1.8%
Other values (44) 44
80.0%
2023-12-11T01:35:32.667968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
팜 19
 
6.7%
품 16
 
5.6%
약 16
 
5.6%
주 16
 
5.6%
) 14
 
4.9%
( 14
 
4.9%
스 9
 
3.2%
이 8
 
2.8%
메 7
 
2.5%
디 5
 
1.8%
Other values (97) 161
56.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 245
86.0%
Close Punctuation 14
 
4.9%
Open Punctuation 14
 
4.9%
Uppercase Letter 5
 
1.8%
Other Symbol 4
 
1.4%
Space Separator 3
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팜 19
 
7.8%
품 16
 
6.5%
약 16
 
6.5%
주 16
 
6.5%
스 9
 
3.7%
이 8
 
3.3%
메 7
 
2.9%
디 5
 
2.0%
에 5
 
2.0%
인 4
 
1.6%
Other values (88) 140
57.1%
Uppercase Letter
ValueCountFrequency (%)
L 1
20.0%
N 1
20.0%
K 1
20.0%
S 1
20.0%
M 1
20.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 249
87.4%
Common 31
 
10.9%
Latin 5
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팜 19
 
7.6%
품 16
 
6.4%
약 16
 
6.4%
주 16
 
6.4%
스 9
 
3.6%
이 8
 
3.2%
메 7
 
2.8%
디 5
 
2.0%
에 5
 
2.0%
㈜ 4
 
1.6%
Other values (89) 144
57.8%
Latin
ValueCountFrequency (%)
L 1
20.0%
N 1
20.0%
K 1
20.0%
S 1
20.0%
M 1
20.0%
Common
ValueCountFrequency (%)
) 14
45.2%
( 14
45.2%
3
 
9.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 245
86.0%
ASCII 36
 
12.6%
None 4
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
팜 19
 
7.8%
품 16
 
6.5%
약 16
 
6.5%
주 16
 
6.5%
스 9
 
3.7%
이 8
 
3.3%
메 7
 
2.9%
디 5
 
2.0%
에 5
 
2.0%
인 4
 
1.6%
Other values (88) 140
57.1%
ASCII
ValueCountFrequency (%)
) 14
38.9%
( 14
38.9%
3
 
8.3%
L 1
 
2.8%
N 1
 
2.8%
K 1
 
2.8%
S 1
 
2.8%
M 1
 
2.8%
None
ValueCountFrequency (%)
㈜ 4
100.0%

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

Distinct51
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-11T01:35:33.006574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length44
Mean length35.826923
Min length25

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)96.2%

Sample

1st row부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)
2nd row부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 312호 (금사동)
3rd row부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 303호 (금사동)
4th row부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 3층 302호 (금사동)
5th row부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 307호 (금사동)
ValueCountFrequency (%)
부산광역시 52
 
14.4%
금정구 52
 
14.4%
3층 16
 
4.4%
금사동 15
 
4.2%
구서동 11
 
3.1%
금사자동차운전전문학원 11
 
3.1%
49 11
 
3.1%
공단서로8번길 11
 
3.1%
2층 11
 
3.1%
a동 9
 
2.5%
Other values (108) 161
44.7%
2023-12-11T01:35:33.550871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
309
 
16.6%
금 89
 
4.8%
동 79
 
4.2%
구 64
 
3.4%
부 62
 
3.3%
산 59
 
3.2%
, 57
 
3.1%
정 55
 
3.0%
시 52
 
2.8%
( 52
 
2.8%
Other values (88) 985
52.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1081
58.0%
Space Separator 309
 
16.6%
Decimal Number 293
 
15.7%
Other Punctuation 57
 
3.1%
Open Punctuation 52
 
2.8%
Close Punctuation 52
 
2.8%
Uppercase Letter 11
 
0.6%
Dash Punctuation 8
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
금 89
 
8.2%
동 79
 
7.3%
구 64
 
5.9%
부 62
 
5.7%
산 59
 
5.5%
정 55
 
5.1%
시 52
 
4.8%
역 52
 
4.8%
광 52
 
4.8%
로 51
 
4.7%
Other values (71) 466
43.1%
Decimal Number
ValueCountFrequency (%)
1 52
17.7%
3 49
16.7%
2 41
14.0%
9 33
11.3%
4 31
10.6%
0 24
8.2%
8 19
 
6.5%
5 15
 
5.1%
7 15
 
5.1%
6 14
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
A 9
81.8%
K 2
 
18.2%
Space Separator
ValueCountFrequency (%)
309
100.0%
Other Punctuation
ValueCountFrequency (%)
, 57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 52
100.0%
Close Punctuation
ValueCountFrequency (%)
) 52
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1081
58.0%
Common 771
41.4%
Latin 11
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
금 89
 
8.2%
동 79
 
7.3%
구 64
 
5.9%
부 62
 
5.7%
산 59
 
5.5%
정 55
 
5.1%
시 52
 
4.8%
역 52
 
4.8%
광 52
 
4.8%
로 51
 
4.7%
Other values (71) 466
43.1%
Common
ValueCountFrequency (%)
309
40.1%
, 57
 
7.4%
( 52
 
6.7%
1 52
 
6.7%
) 52
 
6.7%
3 49
 
6.4%
2 41
 
5.3%
9 33
 
4.3%
4 31
 
4.0%
0 24
 
3.1%
Other values (5) 71
 
9.2%
Latin
ValueCountFrequency (%)
A 9
81.8%
K 2
 
18.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1081
58.0%
ASCII 782
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
309
39.5%
, 57
 
7.3%
( 52
 
6.6%
1 52
 
6.6%
) 52
 
6.6%
3 49
 
6.3%
2 41
 
5.2%
9 33
 
4.2%
4 31
 
4.0%
0 24
 
3.1%
Other values (7) 82
 
10.5%
Hangul
ValueCountFrequency (%)
금 89
 
8.2%
동 79
 
7.3%
구 64
 
5.9%
부 62
 
5.7%
산 59
 
5.5%
정 55
 
5.1%
시 52
 
4.8%
역 52
 
4.8%
광 52
 
4.8%
로 51
 
4.7%
Other values (71) 466
43.1%

영업소전화번호
Text

MISSING 

Distinct42
Distinct (%)100.0%
Missing10
Missing (%)19.2%
Memory size548.0 B
2023-12-11T01:35:33.873283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.952381
Min length9

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row051-520-2626
2nd row051-518-0875
3rd row051-714-6056
4th row051-583-0928
5th row070-4409-0728
ValueCountFrequency (%)
051-581-5156 1
 
2.4%
051-520-2626 1
 
2.4%
055-222-9794 1
 
2.4%
051-517-1540 1
 
2.4%
1599-2875 1
 
2.4%
051-524-7400 1
 
2.4%
051-507-6657 1
 
2.4%
051-312-2138 1
 
2.4%
051-512-3311 1
 
2.4%
051-905-6971 1
 
2.4%
Other values (32) 32
76.2%
2023-12-11T01:35:34.322426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 100
19.9%
1 88
17.5%
- 83
16.5%
0 71
14.1%
2 29
 
5.8%
7 28
 
5.6%
8 24
 
4.8%
4 23
 
4.6%
9 23
 
4.6%
6 17
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 419
83.5%
Dash Punctuation 83
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 100
23.9%
1 88
21.0%
0 71
16.9%
2 29
 
6.9%
7 28
 
6.7%
8 24
 
5.7%
4 23
 
5.5%
9 23
 
5.5%
6 17
 
4.1%
3 16
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 83
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 502
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 100
19.9%
1 88
17.5%
- 83
16.5%
0 71
14.1%
2 29
 
5.8%
7 28
 
5.6%
8 24
 
4.8%
4 23
 
4.6%
9 23
 
4.6%
6 17
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 502
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 100
19.9%
1 88
17.5%
- 83
16.5%
0 71
14.1%
2 29
 
5.8%
7 28
 
5.6%
8 24
 
4.8%
4 23
 
4.6%
9 23
 
4.6%
6 17
 
3.4%

Correlations

2023-12-11T01:35:34.436743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업소명영업소소재지(도로명)영업소전화번호
영업소명1.0001.0001.000
영업소소재지(도로명)1.0001.0001.000
영업소전화번호1.0001.0001.000

Missing values

2023-12-11T01:35:31.921304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:35:32.000399image/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에스와이팜 주식회사부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)051-520-2626
1세계로약품부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 312호 (금사동)<NA>
2이지팜부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 303호 (금사동)<NA>
3미강팜부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 3층 302호 (금사동)<NA>
4(주)다인파마부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 307호 (금사동)<NA>
5휴네프로부산광역시 금정구 금단로 190, 대화빌딩 3층 302호 (남산동)051-518-0875
6와이즈팜부산광역시 금정구 중앙대로1929번길 9, 3층 302호 (구서동)051-714-6056
7신화약품부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 310호 (금사동)<NA>
8오션파마(주)부산광역시 금정구 금정로 138, K빌딩 4층 401호 (장전동)051-583-0928
9(주)홍인약품부산광역시 금정구 동부곡로15번길 76, 롯데캐슬상가동 2층 202호 (부곡동, 롯데캐슬디아망)070-4409-0728
영업소명영업소소재지(도로명)영업소전화번호
42㈜대림약품부산광역시 금정구 금강로 592, 2층 (구서동)051-517-6221
43우성약품부산광역시 금정구 공단서로8번길 49, 금사자동차운전전문학원 A동 3층 304호 (금사동)051-507-7663
44팜울림부산광역시 금정구 청룡예전로 93, 지하1,1층 (청룡동)051-507-9058
45원약품(주)부산광역시 금정구 체육공원로 39, 1층 (구서동)051-516-9132
46에스에이치팜(주)부산광역시 금정구 식물원로 27, 3층 (장전동)051-502-0007
47신우팜(주)부산광역시 금정구 무학송로 147, 3층 (부곡동)051-555-1114
48㈜효원메디콤부산광역시 금정구 금단로 141, 2층 (남산동)051-582-6692
49동서약품부산광역시 금정구 중앙대로1959번길 11, 2층 (구서동)051-517-9998
50부경약품㈜부산광역시 금정구 금강로693번길 17, 3, 4층 (남산동)051-518-4521
51(주)영남지오영 부산지점부산광역시 금정구 중앙대로1929번길 9, 4층 (구서동)051-509-3311