Overview

Dataset statistics

Number of variables4
Number of observations69
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory34.9 B

Variable types

Numeric1
Text3

Dataset

Description대전광역시 서구 양약 및 한약도매 등 의약품도매업소 현황입니다. (순번, 영업소명, 영업소소재지도로명, 전화번호)
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15104528/fileData.do

Alerts

순번 has unique valuesUnique
영업소명 has unique valuesUnique
영업소소재지도로명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:43:53.138215
Analysis finished2023-12-12 07:43:53.598161
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35
Minimum1
Maximum69
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2023-12-12T16:43:53.662434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.4
Q118
median35
Q352
95-th percentile65.6
Maximum69
Range68
Interquartile range (IQR)34

Descriptive statistics

Standard deviation20.062403
Coefficient of variation (CV)0.5732115
Kurtosis-1.2
Mean35
Median Absolute Deviation (MAD)17
Skewness0
Sum2415
Variance402.5
MonotonicityStrictly increasing
2023-12-12T16:43:53.802026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
45 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
46 1
 
1.4%
44 1
 
1.4%
53 1
 
1.4%
Other values (59) 59
85.5%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%
64 1
1.4%
63 1
1.4%
62 1
1.4%
61 1
1.4%
60 1
1.4%

영업소명
Text

UNIQUE 

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

Length

Max length13
Median length11
Mean length6.6086957
Min length3

Characters and Unicode

Total characters456
Distinct characters105
Distinct categories3 ?
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 (%)
주식회사 18
 
20.2%
제이에스팜 2
 
2.2%
㈜한일덴탈 1
 
1.1%
㈜도강메디칼 1
 
1.1%
라온약품 1
 
1.1%
지산약품 1
 
1.1%
엠에이치메디칼 1
 
1.1%
메디인팜 1
 
1.1%
디앤드피 1
 
1.1%
씨메디 1
 
1.1%
Other values (61) 61
68.5%
2023-12-12T16:43:54.440162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
팜 22
 
4.8%
사 22
 
4.8%
약 21
 
4.6%
주 20
 
4.4%
20
 
4.4%
회 20
 
4.4%
식 19
 
4.2%
디 19
 
4.2%
㈜ 18
 
3.9%
이 17
 
3.7%
Other values (95) 258
56.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 418
91.7%
Space Separator 20
 
4.4%
Other Symbol 18
 
3.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팜 22
 
5.3%
사 22
 
5.3%
약 21
 
5.0%
주 20
 
4.8%
회 20
 
4.8%
식 19
 
4.5%
디 19
 
4.5%
이 17
 
4.1%
메 17
 
4.1%
스 14
 
3.3%
Other values (93) 227
54.3%
Space Separator
ValueCountFrequency (%)
20
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 436
95.6%
Common 20
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팜 22
 
5.0%
사 22
 
5.0%
약 21
 
4.8%
주 20
 
4.6%
회 20
 
4.6%
식 19
 
4.4%
디 19
 
4.4%
㈜ 18
 
4.1%
이 17
 
3.9%
메 17
 
3.9%
Other values (94) 241
55.3%
Common
ValueCountFrequency (%)
20
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 418
91.7%
ASCII 20
 
4.4%
None 18
 
3.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
팜 22
 
5.3%
사 22
 
5.3%
약 21
 
5.0%
주 20
 
4.8%
회 20
 
4.8%
식 19
 
4.5%
디 19
 
4.5%
이 17
 
4.1%
메 17
 
4.1%
스 14
 
3.3%
Other values (93) 227
54.3%
ASCII
ValueCountFrequency (%)
20
100.0%
None
ValueCountFrequency (%)
㈜ 18
100.0%

영업소소재지도로명
Text

UNIQUE 

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

Length

Max length44
Median length39
Mean length32.217391
Min length21

Characters and Unicode

Total characters2223
Distinct characters103
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

Unique69 ?
Unique (%)100.0%

Sample

1st row대전광역시 서구 둔산대로117번길 44, 311, 312호 (만년동)
2nd row대전광역시 서구 장안로 76 (매노동)
3rd row대전광역시 서구 괴정로 125, 1층 (괴정동)
4th row대전광역시 서구 혜천로 15, 지하1층 (정림동)
5th row대전광역시 서구 청사로 148, 매그놀리아 4층 405호 (둔산동)
ValueCountFrequency (%)
대전광역시 69
 
15.3%
서구 68
 
15.1%
월평동 24
 
5.3%
2층 15
 
3.3%
150 14
 
3.1%
계룡로232번길 14
 
3.1%
관저동 12
 
2.7%
4층 10
 
2.2%
1층 9
 
2.0%
정림동 6
 
1.3%
Other values (144) 209
46.4%
2023-12-12T16:43:55.458846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
381
 
17.1%
2 91
 
4.1%
1 85
 
3.8%
대 78
 
3.5%
동 74
 
3.3%
구 72
 
3.2%
시 71
 
3.2%
서 71
 
3.2%
광 71
 
3.2%
( 70
 
3.1%
Other values (93) 1159
52.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1181
53.1%
Decimal Number 446
 
20.1%
Space Separator 381
 
17.1%
Open Punctuation 70
 
3.1%
Close Punctuation 70
 
3.1%
Other Punctuation 68
 
3.1%
Dash Punctuation 6
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 78
 
6.6%
동 74
 
6.3%
구 72
 
6.1%
시 71
 
6.0%
서 71
 
6.0%
광 71
 
6.0%
역 69
 
5.8%
전 69
 
5.8%
로 67
 
5.7%
층 52
 
4.4%
Other values (77) 487
41.2%
Decimal Number
ValueCountFrequency (%)
2 91
20.4%
1 85
19.1%
0 59
13.2%
5 45
10.1%
3 45
10.1%
4 44
9.9%
7 22
 
4.9%
6 20
 
4.5%
8 18
 
4.0%
9 17
 
3.8%
Space Separator
ValueCountFrequency (%)
381
100.0%
Open Punctuation
ValueCountFrequency (%)
( 70
100.0%
Close Punctuation
ValueCountFrequency (%)
) 70
100.0%
Other Punctuation
ValueCountFrequency (%)
, 68
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1181
53.1%
Common 1041
46.8%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 78
 
6.6%
동 74
 
6.3%
구 72
 
6.1%
시 71
 
6.0%
서 71
 
6.0%
광 71
 
6.0%
역 69
 
5.8%
전 69
 
5.8%
로 67
 
5.7%
층 52
 
4.4%
Other values (77) 487
41.2%
Common
ValueCountFrequency (%)
381
36.6%
2 91
 
8.7%
1 85
 
8.2%
( 70
 
6.7%
) 70
 
6.7%
, 68
 
6.5%
0 59
 
5.7%
5 45
 
4.3%
3 45
 
4.3%
4 44
 
4.2%
Other values (5) 83
 
8.0%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1181
53.1%
ASCII 1042
46.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
381
36.6%
2 91
 
8.7%
1 85
 
8.2%
( 70
 
6.7%
) 70
 
6.7%
, 68
 
6.5%
0 59
 
5.7%
5 45
 
4.3%
3 45
 
4.3%
4 44
 
4.2%
Other values (6) 84
 
8.1%
Hangul
ValueCountFrequency (%)
대 78
 
6.6%
동 74
 
6.3%
구 72
 
6.1%
시 71
 
6.0%
서 71
 
6.0%
광 71
 
6.0%
역 69
 
5.8%
전 69
 
5.8%
로 67
 
5.7%
층 52
 
4.4%
Other values (77) 487
41.2%

전화번호
Text

Distinct51
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
2023-12-12T16:43:55.690962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.73913
Min length11

Characters and Unicode

Total characters810
Distinct characters22
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique50 ?
Unique (%)72.5%

Sample

1st row042-482-5910
2nd row비공개(휴대전화번호)
3rd row042-523-8488
4th row042-478-4567
5th row042-252-8455
ValueCountFrequency (%)
비공개(휴대전화번호 19
27.5%
042-482-5910 1
 
1.4%
042-633-2234 1
 
1.4%
042-483-5233 1
 
1.4%
042-226-8828 1
 
1.4%
042-625-1013 1
 
1.4%
042-542-6730 1
 
1.4%
042-721-4721 1
 
1.4%
042-721-6022 1
 
1.4%
042-824-4205 1
 
1.4%
Other values (41) 41
59.4%
2023-12-12T16:43:56.124134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 106
13.1%
- 100
12.3%
4 99
12.2%
0 78
 
9.6%
8 45
 
5.6%
5 40
 
4.9%
7 37
 
4.6%
3 35
 
4.3%
1 31
 
3.8%
6 20
 
2.5%
Other values (12) 219
27.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 501
61.9%
Other Letter 171
 
21.1%
Dash Punctuation 100
 
12.3%
Close Punctuation 19
 
2.3%
Open Punctuation 19
 
2.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 106
21.2%
4 99
19.8%
0 78
15.6%
8 45
9.0%
5 40
 
8.0%
7 37
 
7.4%
3 35
 
7.0%
1 31
 
6.2%
6 20
 
4.0%
9 10
 
2.0%
Other Letter
ValueCountFrequency (%)
공 19
11.1%
비 19
11.1%
호 19
11.1%
번 19
11.1%
화 19
11.1%
전 19
11.1%
대 19
11.1%
휴 19
11.1%
개 19
11.1%
Dash Punctuation
ValueCountFrequency (%)
- 100
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 639
78.9%
Hangul 171
 
21.1%

Most frequent character per script

Common
ValueCountFrequency (%)
2 106
16.6%
- 100
15.6%
4 99
15.5%
0 78
12.2%
8 45
7.0%
5 40
 
6.3%
7 37
 
5.8%
3 35
 
5.5%
1 31
 
4.9%
6 20
 
3.1%
Other values (3) 48
7.5%
Hangul
ValueCountFrequency (%)
공 19
11.1%
비 19
11.1%
호 19
11.1%
번 19
11.1%
화 19
11.1%
전 19
11.1%
대 19
11.1%
휴 19
11.1%
개 19
11.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 639
78.9%
Hangul 171
 
21.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 106
16.6%
- 100
15.6%
4 99
15.5%
0 78
12.2%
8 45
7.0%
5 40
 
6.3%
7 37
 
5.8%
3 35
 
5.5%
1 31
 
4.9%
6 20
 
3.1%
Other values (3) 48
7.5%
Hangul
ValueCountFrequency (%)
공 19
11.1%
비 19
11.1%
호 19
11.1%
번 19
11.1%
화 19
11.1%
전 19
11.1%
대 19
11.1%
휴 19
11.1%
개 19
11.1%

Interactions

2023-12-12T16:43:53.375802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:43:56.244407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소명영업소소재지도로명전화번호
순번1.0001.0001.0000.741
영업소명1.0001.0001.0001.000
영업소소재지도로명1.0001.0001.0001.000
전화번호0.7411.0001.0001.000

Missing values

2023-12-12T16:43:53.494448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:43:53.568552image/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㈜한일덴탈대전광역시 서구 둔산대로117번길 44, 311, 312호 (만년동)042-482-5910
12한진산소대전광역시 서구 장안로 76 (매노동)비공개(휴대전화번호)
23㈜대림메디컬대전광역시 서구 괴정로 125, 1층 (괴정동)042-523-8488
34㈜서울유니온약품 대전지점대전광역시 서구 혜천로 15, 지하1층 (정림동)042-478-4567
45㈜아큐텍파마대전광역시 서구 청사로 148, 매그놀리아 4층 405호 (둔산동)042-252-8455
56㈜대전지오영대전광역시 서구 변정7길 5, 3동 1,2층 (변동)042-536-7012
67주식회사 제이에스팜대전광역시 서구 도솔로483번길 113, 1층 (탄방동)070-8270-8462
78그린약품대전광역시 정림로66번길 39, 2층 (정림동)042-482-2778
89대명사대전광역시 서구 도산로 159, 신성빌딩 5층 (변동)042-585-9992
910㈜오성팜대전광역시 서구 혜천로 15, 2층 (정림동)042-273-3451
순번영업소명영업소소재지도로명전화번호
5960㈜삼성팜대전광역시 서구 대덕대로242번길 48, 4층 401호 (둔산동)042-477-1124
6061㈜우신팜대전광역시 서구 복수동로87번길 5-10, 2층 (복수동)042-253-7289
6162주식회사 베스트오베이대전광역시 서구 계룡로232번길 150, 2층 205호 (월평동)비공개(휴대전화번호)
6263성보건재도매한약대전광역시 서구 도산로403번길 29, 2층 (탄방동)042-583-8833
6364평화당한약건재도매대전광역시 서구 월평로 28-1, 1층 (월평동)042-486-0343
6465경희건재도매한약대전광역시 서구 도산로 266, 1층 (가장동)042-527-5203
6566건재도매대동한약대전광역시 서구 도솔로 217, 1층 (변동)042-524-7700
6667제일약업사대전광역시 서구 갈마로147번길 73 (갈마동)042-524-3278
6768대화당건재도매한약대전광역시 서구 정림로70번길 23 (정림동)042-581-6705
6869제원당건재도매한약대전광역시 서구 도마5길 26 (도마동)042-524-2079