Overview

Dataset statistics

Number of variables6
Number of observations96
Missing cells14
Missing cells (%)2.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory50.4 B

Variable types

Numeric1
DateTime1
Categorical1
Text3

Dataset

Description김해시 의약품도매상 현황에 대한 자료로 허가일자, 영업종별, 영업소명, 도로명주소, 전화번호에 대한 데이터를 제공하고 있습니다.
Author경상남도 김해시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15033426

Alerts

영업소전화번호 has 14 (14.6%) missing valuesMissing
순번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:17:44.448213
Analysis finished2023-12-10 23:17:45.314009
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct96
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48.5
Minimum1
Maximum96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size996.0 B
2023-12-11T08:17:45.387553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.75
Q124.75
median48.5
Q372.25
95-th percentile91.25
Maximum96
Range95
Interquartile range (IQR)47.5

Descriptive statistics

Standard deviation27.856777
Coefficient of variation (CV)0.57436653
Kurtosis-1.2
Mean48.5
Median Absolute Deviation (MAD)24
Skewness0
Sum4656
Variance776
MonotonicityStrictly increasing
2023-12-11T08:17:45.530362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
50 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
67 1
 
1.0%
66 1
 
1.0%
65 1
 
1.0%
Other values (86) 86
89.6%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%
90 1
1.0%
89 1
1.0%
88 1
1.0%
87 1
1.0%

허가일자
Date

Distinct89
Distinct (%)92.7%
Missing0
Missing (%)0.0%
Memory size900.0 B
Minimum1996-02-07 00:00:00
Maximum2022-08-17 00:00:00
2023-12-11T08:17:45.721020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:17:45.861721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

영업종별
Categorical

Distinct4
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size900.0 B
의료용 고압가스
52 
일반종합도매
39 
기타
 
3
한약도매
 
2

Length

Max length8
Median length8
Mean length6.9166667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의료용 고압가스
2nd row의료용 고압가스
3rd row일반종합도매
4th row일반종합도매
5th row일반종합도매

Common Values

ValueCountFrequency (%)
의료용 고압가스 52
54.2%
일반종합도매 39
40.6%
기타 3
 
3.1%
한약도매 2
 
2.1%

Length

2023-12-11T08:17:45.994733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:17:46.145415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의료용 52
35.1%
고압가스 52
35.1%
일반종합도매 39
26.4%
기타 3
 
2.0%
한약도매 2
 
1.4%

영업소명
Text

UNIQUE 

Distinct96
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size900.0 B
2023-12-11T08:17:46.354851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length6.4791667
Min length3

Characters and Unicode

Total characters622
Distinct characters146
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

Unique96 ?
Unique (%)100.0%

Sample

1st row벽천가스테크
2nd row신항만가스
3rd row제이케이바이오(JKBIO)
4th row위드약품
5th row수진약품
ValueCountFrequency (%)
주식회사 5
 
4.8%
벽천가스테크 1
 
1.0%
동원종합가스 1
 
1.0%
삼흥씨앤씨 1
 
1.0%
피에스켐(주 1
 
1.0%
우리동성e&g 1
 
1.0%
주)용진테크 1
 
1.0%
장유에너지 1
 
1.0%
동일에너지 1
 
1.0%
주)엠에스동남산업가스 1
 
1.0%
Other values (91) 91
86.7%
2023-12-11T08:17:46.753783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 47
 
7.6%
가 36
 
5.8%
주 29
 
4.7%
( 26
 
4.2%
) 26
 
4.2%
합 19
 
3.1%
약 18
 
2.9%
품 18
 
2.9%
종 18
 
2.9%
에 17
 
2.7%
Other values (136) 368
59.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 533
85.7%
Open Punctuation 26
 
4.2%
Close Punctuation 26
 
4.2%
Uppercase Letter 19
 
3.1%
Space Separator 9
 
1.4%
Lowercase Letter 5
 
0.8%
Other Symbol 2
 
0.3%
Other Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 47
 
8.8%
가 36
 
6.8%
주 29
 
5.4%
합 19
 
3.6%
약 18
 
3.4%
품 18
 
3.4%
종 18
 
3.4%
에 17
 
3.2%
지 14
 
2.6%
팜 13
 
2.4%
Other values (113) 304
57.0%
Uppercase Letter
ValueCountFrequency (%)
S 4
21.1%
M 2
10.5%
J 2
10.5%
K 2
10.5%
B 2
10.5%
Y 1
 
5.3%
R 1
 
5.3%
T 1
 
5.3%
G 1
 
5.3%
E 1
 
5.3%
Other values (2) 2
10.5%
Lowercase Letter
ValueCountFrequency (%)
p 1
20.0%
h 1
20.0%
a 1
20.0%
r 1
20.0%
m 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 1
50.0%
& 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 535
86.0%
Common 63
 
10.1%
Latin 24
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 47
 
8.8%
가 36
 
6.7%
주 29
 
5.4%
합 19
 
3.6%
약 18
 
3.4%
품 18
 
3.4%
종 18
 
3.4%
에 17
 
3.2%
지 14
 
2.6%
팜 13
 
2.4%
Other values (114) 306
57.2%
Latin
ValueCountFrequency (%)
S 4
16.7%
M 2
 
8.3%
J 2
 
8.3%
K 2
 
8.3%
B 2
 
8.3%
Y 1
 
4.2%
R 1
 
4.2%
T 1
 
4.2%
G 1
 
4.2%
E 1
 
4.2%
Other values (7) 7
29.2%
Common
ValueCountFrequency (%)
( 26
41.3%
) 26
41.3%
9
 
14.3%
, 1
 
1.6%
& 1
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 533
85.7%
ASCII 87
 
14.0%
None 2
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 47
 
8.8%
가 36
 
6.8%
주 29
 
5.4%
합 19
 
3.6%
약 18
 
3.4%
품 18
 
3.4%
종 18
 
3.4%
에 17
 
3.2%
지 14
 
2.6%
팜 13
 
2.4%
Other values (113) 304
57.0%
ASCII
ValueCountFrequency (%)
( 26
29.9%
) 26
29.9%
9
 
10.3%
S 4
 
4.6%
M 2
 
2.3%
J 2
 
2.3%
K 2
 
2.3%
B 2
 
2.3%
Y 1
 
1.1%
, 1
 
1.1%
Other values (12) 12
13.8%
None
ValueCountFrequency (%)
㈜ 2
100.0%

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

Distinct87
Distinct (%)90.6%
Missing0
Missing (%)0.0%
Memory size900.0 B
2023-12-11T08:17:47.089769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length39
Mean length27.447917
Min length19

Characters and Unicode

Total characters2635
Distinct characters122
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

Unique80 ?
Unique (%)83.3%

Sample

1st row경상남도 김해시 생림면 나전로 396-31
2nd row경상남도 김해시 진영읍 본산로86번길 34-11
3rd row경상남도 김해시 번화1로44번길 20, 위드투빌딩 402-2호 (대청동)
4th row경상남도 김해시 진례면 테크노밸리로 25-7, 4층 401(B)호
5th row경상남도 김해시 대청로210번길 20, 비전타워빌딩 608호 (대청동)
ValueCountFrequency (%)
경상남도 96
 
17.8%
김해시 96
 
17.8%
대청동 19
 
3.5%
생림면 13
 
2.4%
진례면 13
 
2.4%
진영읍 7
 
1.3%
20 7
 
1.3%
한림면 7
 
1.3%
마사로 7
 
1.3%
부곡동 6
 
1.1%
Other values (174) 269
49.8%
2023-12-11T08:17:47.563699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
445
 
16.9%
상 109
 
4.1%
1 103
 
3.9%
김 101
 
3.8%
해 101
 
3.8%
경 97
 
3.7%
시 97
 
3.7%
남 96
 
3.6%
도 96
 
3.6%
로 95
 
3.6%
Other values (112) 1295
49.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1506
57.2%
Decimal Number 502
 
19.1%
Space Separator 445
 
16.9%
Open Punctuation 51
 
1.9%
Close Punctuation 51
 
1.9%
Dash Punctuation 37
 
1.4%
Other Punctuation 37
 
1.4%
Uppercase Letter 6
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 109
 
7.2%
김 101
 
6.7%
해 101
 
6.7%
경 97
 
6.4%
시 97
 
6.4%
남 96
 
6.4%
도 96
 
6.4%
로 95
 
6.3%
동 67
 
4.4%
번 58
 
3.9%
Other values (91) 589
39.1%
Decimal Number
ValueCountFrequency (%)
1 103
20.5%
2 80
15.9%
4 65
12.9%
0 52
10.4%
6 43
8.6%
3 42
8.4%
7 35
 
7.0%
9 31
 
6.2%
5 30
 
6.0%
8 21
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
A 3
50.0%
C 2
33.3%
B 1
 
16.7%
Open Punctuation
ValueCountFrequency (%)
( 50
98.0%
[ 1
 
2.0%
Close Punctuation
ValueCountFrequency (%)
) 50
98.0%
] 1
 
2.0%
Other Punctuation
ValueCountFrequency (%)
, 36
97.3%
* 1
 
2.7%
Space Separator
ValueCountFrequency (%)
445
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1506
57.2%
Common 1123
42.6%
Latin 6
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 109
 
7.2%
김 101
 
6.7%
해 101
 
6.7%
경 97
 
6.4%
시 97
 
6.4%
남 96
 
6.4%
도 96
 
6.4%
로 95
 
6.3%
동 67
 
4.4%
번 58
 
3.9%
Other values (91) 589
39.1%
Common
ValueCountFrequency (%)
445
39.6%
1 103
 
9.2%
2 80
 
7.1%
4 65
 
5.8%
0 52
 
4.6%
( 50
 
4.5%
) 50
 
4.5%
6 43
 
3.8%
3 42
 
3.7%
- 37
 
3.3%
Other values (8) 156
 
13.9%
Latin
ValueCountFrequency (%)
A 3
50.0%
C 2
33.3%
B 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1506
57.2%
ASCII 1129
42.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
445
39.4%
1 103
 
9.1%
2 80
 
7.1%
4 65
 
5.8%
0 52
 
4.6%
( 50
 
4.4%
) 50
 
4.4%
6 43
 
3.8%
3 42
 
3.7%
- 37
 
3.3%
Other values (11) 162
 
14.3%
Hangul
ValueCountFrequency (%)
상 109
 
7.2%
김 101
 
6.7%
해 101
 
6.7%
경 97
 
6.4%
시 97
 
6.4%
남 96
 
6.4%
도 96
 
6.4%
로 95
 
6.3%
동 67
 
4.4%
번 58
 
3.9%
Other values (91) 589
39.1%

영업소전화번호
Text

MISSING 

Distinct80
Distinct (%)97.6%
Missing14
Missing (%)14.6%
Memory size900.0 B
2023-12-11T08:17:47.833180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.012195
Min length12

Characters and Unicode

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

Unique78 ?
Unique (%)95.1%

Sample

1st row055-724-2448
2nd row055-326-0358
3rd row055-724-3133
4th row055-342-8494
5th row055-723-2761
ValueCountFrequency (%)
055-724-2448 2
 
2.4%
055-336-1261 2
 
2.4%
055-314-9005 1
 
1.2%
055-329-6505 1
 
1.2%
051-341-1888 1
 
1.2%
055-331-1737 1
 
1.2%
055-338-8101 1
 
1.2%
055-327-5057 1
 
1.2%
055-313-5711 1
 
1.2%
055-313-3636 1
 
1.2%
Other values (70) 70
85.4%
2023-12-11T08:17:48.271996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 190
19.3%
- 164
16.6%
3 139
14.1%
0 129
13.1%
2 79
8.0%
1 78
7.9%
4 57
 
5.8%
7 46
 
4.7%
6 41
 
4.2%
8 31
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 821
83.4%
Dash Punctuation 164
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 190
23.1%
3 139
16.9%
0 129
15.7%
2 79
9.6%
1 78
9.5%
4 57
 
6.9%
7 46
 
5.6%
6 41
 
5.0%
8 31
 
3.8%
9 31
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 164
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 985
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 190
19.3%
- 164
16.6%
3 139
14.1%
0 129
13.1%
2 79
8.0%
1 78
7.9%
4 57
 
5.8%
7 46
 
4.7%
6 41
 
4.2%
8 31
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 985
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 190
19.3%
- 164
16.6%
3 139
14.1%
0 129
13.1%
2 79
8.0%
1 78
7.9%
4 57
 
5.8%
7 46
 
4.7%
6 41
 
4.2%
8 31
 
3.1%

Interactions

2023-12-11T08:17:45.043907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:17:48.374985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번허가일자영업종별영업소명영업소소재지(도로명)영업소전화번호
순번1.0001.0000.4141.0000.9410.831
허가일자1.0001.0000.0001.0000.9360.985
영업종별0.4140.0001.0001.0000.0001.000
영업소명1.0001.0001.0001.0001.0001.000
영업소소재지(도로명)0.9410.9360.0001.0001.0000.993
영업소전화번호0.8310.9851.0001.0000.9931.000
2023-12-11T08:17:48.510207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업종별
순번1.0000.253
영업종별0.2531.000

Missing values

2023-12-11T08:17:45.144363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:17:45.265959image/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

순번허가일자영업종별영업소명영업소소재지(도로명)영업소전화번호
012022-08-17의료용 고압가스벽천가스테크경상남도 김해시 생림면 나전로 396-31<NA>
122021-11-17의료용 고압가스신항만가스경상남도 김해시 진영읍 본산로86번길 34-11<NA>
232021-10-26일반종합도매제이케이바이오(JKBIO)경상남도 김해시 번화1로44번길 20, 위드투빌딩 402-2호 (대청동)<NA>
342021-10-19일반종합도매위드약품경상남도 김해시 진례면 테크노밸리로 25-7, 4층 401(B)호055-724-2448
452021-09-28일반종합도매수진약품경상남도 김해시 대청로210번길 20, 비전타워빌딩 608호 (대청동)055-326-0358
562021-08-24일반종합도매(주)파인메디칼경상남도 김해시 번화1로79번길 2, 센터빌딩 702호 (대청동)<NA>
672021-05-28일반종합도매(주)원메디팜경상남도 김해시 계동로 241, 리더스빌딩 202호 일부호 (대청동)055-724-3133
782021-05-27일반종합도매굿메딕스경상남도 김해시 진례면 테크노밸리로 25-7, 4층 401(A)호055-342-8494
892021-03-12일반종합도매주식회사 세종메디팜경상남도 김해시 번화1로79번길 4, 다인메디컬센타 10층 1001호 (대청동)055-723-2761
9102021-02-17일반종합도매태은약품경상남도 김해시 대청로210번길 20, 비전타워빌딩 606호 (대청동)055-339-7693
순번허가일자영업종별영업소명영업소소재지(도로명)영업소전화번호
86872009-05-26의료용 고압가스(주)삼흥에너지경상남도 김해시 장유로55번길 40 (부곡동)055-338-7618
87882008-06-26일반종합도매우림약품경상남도 김해시 칠산로210번길 138-28, 2층 (이동)055-322-0693
88892006-04-27일반종합도매㈜홍익약품경상남도 김해시 계동로 149 (대청동)055-313-8937
89902003-07-05의료용 고압가스상명종합가스경상남도 김해시 칠산로279번길 16-22 (화목동)055-327-7040
90912002-03-15의료용 고압가스도원TR경상남도 김해시 칠산로223번길 12-5 (이동)055-323-0253
91922001-06-27의료용 고압가스(주)하나경상남도 김해시 삼안로16번길 21 (지내동)055-325-2002
92932001-05-10의료용 고압가스경남종합가스경상남도 김해시 주촌면 서부로1563번길 23055-322-0202
93941999-04-13일반종합도매한솔약품(주)경상남도 김해시 계동로 241 (대청동)055-314-9005
94951998-04-06의료용 고압가스(주)SY가스경상남도 김해시 대청계곡길 65-23 (대청동)055-313-5711
95961996-02-07일반종합도매㈜삼원약품경남지사경상남도 김해시 진례면 진례로371번길 71-1055-345-4488