Overview

Dataset statistics

Number of variables3
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory27.8 B

Variable types

Numeric1
Text2

Dataset

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

Alerts

순번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:35:27.591583
Analysis finished2023-12-10 16:35:28.208579
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.5
Minimum1
Maximum48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2023-12-11T01:35:28.313076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.35
Q112.75
median24.5
Q336.25
95-th percentile45.65
Maximum48
Range47
Interquartile range (IQR)23.5

Descriptive statistics

Standard deviation14
Coefficient of variation (CV)0.57142857
Kurtosis-1.2
Mean24.5
Median Absolute Deviation (MAD)12
Skewness0
Sum1176
Variance196
MonotonicityStrictly increasing
2023-12-11T01:35:28.522221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
1 1
 
2.1%
26 1
 
2.1%
28 1
 
2.1%
29 1
 
2.1%
30 1
 
2.1%
31 1
 
2.1%
32 1
 
2.1%
33 1
 
2.1%
34 1
 
2.1%
35 1
 
2.1%
Other values (38) 38
79.2%
ValueCountFrequency (%)
1 1
2.1%
2 1
2.1%
3 1
2.1%
4 1
2.1%
5 1
2.1%
6 1
2.1%
7 1
2.1%
8 1
2.1%
9 1
2.1%
10 1
2.1%
ValueCountFrequency (%)
48 1
2.1%
47 1
2.1%
46 1
2.1%
45 1
2.1%
44 1
2.1%
43 1
2.1%
42 1
2.1%
41 1
2.1%
40 1
2.1%
39 1
2.1%

영업소명
Text

UNIQUE 

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

Length

Max length13
Median length11
Mean length5.8541667
Min length3

Characters and Unicode

Total characters281
Distinct characters104
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

Unique48 ?
Unique (%)100.0%

Sample

1st row아이에스메디팜 주식회사
2nd row에스비 메디텍
3rd row메넥스(주)
4th row에스와이팜 주식회사
5th row휴네프로
ValueCountFrequency (%)
주식회사 3
 
5.7%
레볼루션 1
 
1.9%
홍인메디칼 1
 
1.9%
신화약품 1
 
1.9%
스마일덕성팜 1
 
1.9%
바이오메딕스코리아 1
 
1.9%
주)세일글로발 1
 
1.9%
비엔팜 1
 
1.9%
청진약품 1
 
1.9%
신세계약품 1
 
1.9%
Other values (41) 41
77.4%
2023-12-11T01:35:29.336688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
17
 
6.0%
16
 
5.7%
( 13
 
4.6%
) 13
 
4.6%
13
 
4.6%
13
 
4.6%
12
 
4.3%
11
 
3.9%
8
 
2.8%
8
 
2.8%
Other values (94) 157
55.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 240
85.4%
Open Punctuation 13
 
4.6%
Close Punctuation 13
 
4.6%
Space Separator 5
 
1.8%
Other Symbol 5
 
1.8%
Uppercase Letter 5
 
1.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
17
 
7.1%
16
 
6.7%
13
 
5.4%
13
 
5.4%
12
 
5.0%
11
 
4.6%
8
 
3.3%
8
 
3.3%
7
 
2.9%
4
 
1.7%
Other values (85) 131
54.6%
Uppercase Letter
ValueCountFrequency (%)
L 1
20.0%
N 1
20.0%
K 1
20.0%
S 1
20.0%
M 1
20.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Other Symbol
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 245
87.2%
Common 31
 
11.0%
Latin 5
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
17
 
6.9%
16
 
6.5%
13
 
5.3%
13
 
5.3%
12
 
4.9%
11
 
4.5%
8
 
3.3%
8
 
3.3%
7
 
2.9%
5
 
2.0%
Other values (86) 135
55.1%
Latin
ValueCountFrequency (%)
L 1
20.0%
N 1
20.0%
K 1
20.0%
S 1
20.0%
M 1
20.0%
Common
ValueCountFrequency (%)
( 13
41.9%
) 13
41.9%
5
 
16.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 240
85.4%
ASCII 36
 
12.8%
None 5
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
17
 
7.1%
16
 
6.7%
13
 
5.4%
13
 
5.4%
12
 
5.0%
11
 
4.6%
8
 
3.3%
8
 
3.3%
7
 
2.9%
4
 
1.7%
Other values (85) 131
54.6%
ASCII
ValueCountFrequency (%)
( 13
36.1%
) 13
36.1%
5
 
13.9%
L 1
 
2.8%
N 1
 
2.8%
K 1
 
2.8%
S 1
 
2.8%
M 1
 
2.8%
None
ValueCountFrequency (%)
5
100.0%
Distinct45
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-11T01:35:29.740326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length37
Mean length33.1875
Min length25

Characters and Unicode

Total characters1593
Distinct characters105
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

Unique42 ?
Unique (%)87.5%

Sample

1st row부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)
2nd row부산광역시 금정구 금샘로 585, 다솔빌딩 603호 (남산동)
3rd row부산광역시 금정구 중앙대로1719번길 30, 4층 (부곡동)
4th row부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)
5th row부산광역시 금정구 금단로 190, 대화빌딩 3층 302호 (남산동)
ValueCountFrequency (%)
부산광역시 48
 
15.0%
금정구 48
 
15.0%
2층 12
 
3.7%
구서동 11
 
3.4%
3층 9
 
2.8%
장전동 9
 
2.8%
남산동 8
 
2.5%
4층 8
 
2.5%
부곡동 7
 
2.2%
금사동 5
 
1.6%
Other values (110) 156
48.6%
2023-12-11T01:35:30.289118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
274
 
17.2%
67
 
4.2%
1 61
 
3.8%
60
 
3.8%
60
 
3.8%
59
 
3.7%
57
 
3.6%
53
 
3.3%
, 53
 
3.3%
( 48
 
3.0%
Other values (95) 801
50.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 894
56.1%
Space Separator 274
 
17.2%
Decimal Number 261
 
16.4%
Other Punctuation 53
 
3.3%
Open Punctuation 48
 
3.0%
Close Punctuation 48
 
3.0%
Dash Punctuation 9
 
0.6%
Uppercase Letter 6
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
67
 
7.5%
60
 
6.7%
60
 
6.7%
59
 
6.6%
57
 
6.4%
53
 
5.9%
48
 
5.4%
48
 
5.4%
48
 
5.4%
47
 
5.3%
Other values (77) 347
38.8%
Decimal Number
ValueCountFrequency (%)
1 61
23.4%
2 40
15.3%
3 33
12.6%
9 23
 
8.8%
4 22
 
8.4%
0 22
 
8.4%
5 21
 
8.0%
7 15
 
5.7%
6 14
 
5.4%
8 10
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
B 3
50.0%
K 2
33.3%
A 1
 
16.7%
Space Separator
ValueCountFrequency (%)
274
100.0%
Other Punctuation
ValueCountFrequency (%)
, 53
100.0%
Open Punctuation
ValueCountFrequency (%)
( 48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 48
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 894
56.1%
Common 693
43.5%
Latin 6
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
67
 
7.5%
60
 
6.7%
60
 
6.7%
59
 
6.6%
57
 
6.4%
53
 
5.9%
48
 
5.4%
48
 
5.4%
48
 
5.4%
47
 
5.3%
Other values (77) 347
38.8%
Common
ValueCountFrequency (%)
274
39.5%
1 61
 
8.8%
, 53
 
7.6%
( 48
 
6.9%
) 48
 
6.9%
2 40
 
5.8%
3 33
 
4.8%
9 23
 
3.3%
4 22
 
3.2%
0 22
 
3.2%
Other values (5) 69
 
10.0%
Latin
ValueCountFrequency (%)
B 3
50.0%
K 2
33.3%
A 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 894
56.1%
ASCII 699
43.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
274
39.2%
1 61
 
8.7%
, 53
 
7.6%
( 48
 
6.9%
) 48
 
6.9%
2 40
 
5.7%
3 33
 
4.7%
9 23
 
3.3%
4 22
 
3.1%
0 22
 
3.1%
Other values (8) 75
 
10.7%
Hangul
ValueCountFrequency (%)
67
 
7.5%
60
 
6.7%
60
 
6.7%
59
 
6.6%
57
 
6.4%
53
 
5.9%
48
 
5.4%
48
 
5.4%
48
 
5.4%
47
 
5.3%
Other values (77) 347
38.8%

Interactions

2023-12-11T01:35:27.793930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:35:30.431690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소명영업소소재지(도로명)
순번1.0001.0000.933
영업소명1.0001.0001.000
영업소소재지(도로명)0.9331.0001.000

Missing values

2023-12-11T01:35:27.973554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:35:28.172583image/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

순번영업소명영업소소재지(도로명)
01아이에스메디팜 주식회사부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)
12에스비 메디텍부산광역시 금정구 금샘로 585, 다솔빌딩 603호 (남산동)
23메넥스(주)부산광역시 금정구 중앙대로1719번길 30, 4층 (부곡동)
34에스와이팜 주식회사부산광역시 금정구 공단서로 15, 삼원약품 3층 일부호 (금사동)
45휴네프로부산광역시 금정구 금단로 190, 대화빌딩 3층 302호 (남산동)
56(주)와이즈팜부산광역시 금정구 중앙대로1929번길 9, 3층 302호 (구서동)
67라온메디부산광역시 금정구 중앙대로 1617-12, 101동 2층 상가230호 (부곡동, 푸르지오아파트)
78오션파마(주)부산광역시 금정구 금정로 138, K빌딩 4층 401호 (장전동)
89(주)홍인약품부산광역시 금정구 온천장로125번길 48, B동 501호 (장전동, 금정산 태진팰리스)
910하이팜부산광역시 금정구 중앙대로1929번길 9, 3층 301호 (구서동)
순번영업소명영업소소재지(도로명)
3839한주메디칼㈜부산광역시 금정구 청룡로 17, 범어주차장 2층 (청룡동)
3940㈜대림디에스부산광역시 금정구 금강로 592, 2층 (구서동)
4041팜울림부산광역시 금정구 청룡예전로 93, 지하1,1층 (청룡동)
4142원약품(주)부산광역시 금정구 체육공원로 39, 1층 (구서동)
4243에스에이치팜(주)부산광역시 금정구 식물원로 27, 3층 (장전동)
4344신우팜(주)부산광역시 금정구 무학송로 147, 3층 (부곡동)
4445㈜효원메디콤부산광역시 금정구 금단로 141, 2층 (남산동)
4546동서약품부산광역시 금정구 중앙대로1959번길 11, 2층 (구서동)
4647부경약품㈜부산광역시 금정구 금강로693번길 17, 3, 4층 (남산동)
4748(주)영남지오영 부산지점부산광역시 금정구 중앙대로1929번길 9, 4층 (구서동)