Overview

Dataset statistics

Number of variables4
Number of observations62
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory35.1 B

Variable types

Numeric1
Text3

Dataset

Description대전광역시 서구 일반종합도매 등 양약도매상에 대한 현황입니다. (순번, 영업소명, 영업소소재지도로명, 전화번호)
URLhttps://www.data.go.kr/data/15104522/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 16:34:33.738667
Analysis finished2023-12-12 16:34:34.198087
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.5
Minimum1
Maximum62
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-13T01:34:34.282084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.05
Q116.25
median31.5
Q346.75
95-th percentile58.95
Maximum62
Range61
Interquartile range (IQR)30.5

Descriptive statistics

Standard deviation18.041619
Coefficient of variation (CV)0.5727498
Kurtosis-1.2
Mean31.5
Median Absolute Deviation (MAD)15.5
Skewness0
Sum1953
Variance325.5
MonotonicityStrictly increasing
2023-12-13T01:34:34.403991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
48 1
 
1.6%
35 1
 
1.6%
36 1
 
1.6%
37 1
 
1.6%
38 1
 
1.6%
39 1
 
1.6%
40 1
 
1.6%
41 1
 
1.6%
42 1
 
1.6%
Other values (52) 52
83.9%
ValueCountFrequency (%)
1 1
1.6%
2 1
1.6%
3 1
1.6%
4 1
1.6%
5 1
1.6%
6 1
1.6%
7 1
1.6%
8 1
1.6%
9 1
1.6%
10 1
1.6%
ValueCountFrequency (%)
62 1
1.6%
61 1
1.6%
60 1
1.6%
59 1
1.6%
58 1
1.6%
57 1
1.6%
56 1
1.6%
55 1
1.6%
54 1
1.6%
53 1
1.6%

영업소명
Text

UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size628.0 B
2023-12-13T01:34:34.637129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length6.4516129
Min length3

Characters and Unicode

Total characters400
Distinct characters94
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

Unique62 ?
Unique (%)100.0%

Sample

1st row㈜한일덴탈
2nd row한진산소
3rd row㈜대림메디컬
4th row㈜서울유니온약품 대전지점
5th row㈜아큐텍파마
ValueCountFrequency (%)
주식회사 18
 
22.0%
제이에스팜 2
 
2.4%
투플러스팜 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 (54) 54
65.9%
2023-12-13T01:34:35.026822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
팜 22
 
5.5%
사 21
 
5.2%
20
 
5.0%
회 20
 
5.0%
주 20
 
5.0%
디 19
 
4.8%
식 19
 
4.8%
㈜ 18
 
4.5%
이 17
 
4.2%
메 17
 
4.2%
Other values (84) 207
51.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 362
90.5%
Space Separator 20
 
5.0%
Other Symbol 18
 
4.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팜 22
 
6.1%
사 21
 
5.8%
회 20
 
5.5%
주 20
 
5.5%
디 19
 
5.2%
식 19
 
5.2%
이 17
 
4.7%
메 17
 
4.7%
스 14
 
3.9%
약 14
 
3.9%
Other values (82) 179
49.4%
Space Separator
ValueCountFrequency (%)
20
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 380
95.0%
Common 20
 
5.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팜 22
 
5.8%
사 21
 
5.5%
회 20
 
5.3%
주 20
 
5.3%
디 19
 
5.0%
식 19
 
5.0%
㈜ 18
 
4.7%
이 17
 
4.5%
메 17
 
4.5%
스 14
 
3.7%
Other values (83) 193
50.8%
Common
ValueCountFrequency (%)
20
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 362
90.5%
ASCII 20
 
5.0%
None 18
 
4.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
팜 22
 
6.1%
사 21
 
5.8%
회 20
 
5.5%
주 20
 
5.5%
디 19
 
5.2%
식 19
 
5.2%
이 17
 
4.7%
메 17
 
4.7%
스 14
 
3.9%
약 14
 
3.9%
Other values (82) 179
49.4%
ASCII
ValueCountFrequency (%)
20
100.0%
None
ValueCountFrequency (%)
㈜ 18
100.0%

영업소소재지도로명
Text

UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size628.0 B
2023-12-13T01:34:35.360527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length39
Mean length32.935484
Min length21

Characters and Unicode

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

Unique62 ?
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 (%)
대전광역시 62
 
15.1%
서구 61
 
14.8%
월평동 23
 
5.6%
계룡로232번길 14
 
3.4%
150 14
 
3.4%
2층 14
 
3.4%
관저동 12
 
2.9%
4층 10
 
2.4%
3층 6
 
1.5%
1층 6
 
1.5%
Other values (131) 189
46.0%
2023-12-13T01:34:35.836535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
349
 
17.1%
2 84
 
4.1%
1 79
 
3.9%
대 71
 
3.5%
동 67
 
3.3%
구 65
 
3.2%
, 64
 
3.1%
광 64
 
3.1%
시 64
 
3.1%
서 64
 
3.1%
Other values (93) 1071
52.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1081
52.9%
Decimal Number 416
 
20.4%
Space Separator 349
 
17.1%
Other Punctuation 64
 
3.1%
Close Punctuation 63
 
3.1%
Open Punctuation 63
 
3.1%
Dash Punctuation 5
 
0.2%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 71
 
6.6%
동 67
 
6.2%
구 65
 
6.0%
광 64
 
5.9%
시 64
 
5.9%
서 64
 
5.9%
전 62
 
5.7%
역 62
 
5.7%
로 61
 
5.6%
층 48
 
4.4%
Other values (77) 453
41.9%
Decimal Number
ValueCountFrequency (%)
2 84
20.2%
1 79
19.0%
0 57
13.7%
5 44
10.6%
4 42
10.1%
3 42
10.1%
7 18
 
4.3%
6 17
 
4.1%
8 17
 
4.1%
9 16
 
3.8%
Space Separator
ValueCountFrequency (%)
349
100.0%
Other Punctuation
ValueCountFrequency (%)
, 64
100.0%
Close Punctuation
ValueCountFrequency (%)
) 63
100.0%
Open Punctuation
ValueCountFrequency (%)
( 63
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1081
52.9%
Common 960
47.0%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 71
 
6.6%
동 67
 
6.2%
구 65
 
6.0%
광 64
 
5.9%
시 64
 
5.9%
서 64
 
5.9%
전 62
 
5.7%
역 62
 
5.7%
로 61
 
5.6%
층 48
 
4.4%
Other values (77) 453
41.9%
Common
ValueCountFrequency (%)
349
36.4%
2 84
 
8.8%
1 79
 
8.2%
, 64
 
6.7%
) 63
 
6.6%
( 63
 
6.6%
0 57
 
5.9%
5 44
 
4.6%
4 42
 
4.4%
3 42
 
4.4%
Other values (5) 73
 
7.6%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1081
52.9%
ASCII 961
47.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
349
36.3%
2 84
 
8.7%
1 79
 
8.2%
, 64
 
6.7%
) 63
 
6.6%
( 63
 
6.6%
0 57
 
5.9%
5 44
 
4.6%
4 42
 
4.4%
3 42
 
4.4%
Other values (6) 74
 
7.7%
Hangul
ValueCountFrequency (%)
대 71
 
6.6%
동 67
 
6.2%
구 65
 
6.0%
광 64
 
5.9%
시 64
 
5.9%
서 64
 
5.9%
전 62
 
5.7%
역 62
 
5.7%
로 61
 
5.6%
층 48
 
4.4%
Other values (77) 453
41.9%

전화번호
Text

Distinct44
Distinct (%)71.0%
Missing0
Missing (%)0.0%
Memory size628.0 B
2023-12-13T01:34:36.054805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.741935
Min length11

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)69.4%

Sample

1st row042-482-5910
2nd row비공개(휴대전화번호)
3rd row042-523-8488
4th row042-478-4567
5th row042-252-8455
ValueCountFrequency (%)
비공개(휴대전화번호 19
30.6%
042-482-5910 1
 
1.6%
042-721-4721 1
 
1.6%
042-525-3000 1
 
1.6%
042-484-1231 1
 
1.6%
042-471-8882 1
 
1.6%
042-633-2234 1
 
1.6%
042-483-5233 1
 
1.6%
042-226-8828 1
 
1.6%
042-625-1013 1
 
1.6%
Other values (34) 34
54.8%
2023-12-13T01:34:36.393663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 92
12.6%
4 88
12.1%
- 86
 
11.8%
0 65
 
8.9%
8 39
 
5.4%
5 32
 
4.4%
7 31
 
4.3%
1 30
 
4.1%
3 28
 
3.8%
공 19
 
2.6%
Other values (13) 218
29.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 432
59.3%
Other Letter 171
 
23.5%
Dash Punctuation 86
 
11.8%
Close Punctuation 19
 
2.6%
Open Punctuation 19
 
2.6%
Math Symbol 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 92
21.3%
4 88
20.4%
0 65
15.0%
8 39
9.0%
5 32
 
7.4%
7 31
 
7.2%
1 30
 
6.9%
3 28
 
6.5%
6 18
 
4.2%
9 9
 
2.1%
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 (%)
- 86
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 557
76.5%
Hangul 171
 
23.5%

Most frequent character per script

Common
ValueCountFrequency (%)
2 92
16.5%
4 88
15.8%
- 86
15.4%
0 65
11.7%
8 39
7.0%
5 32
 
5.7%
7 31
 
5.6%
1 30
 
5.4%
3 28
 
5.0%
) 19
 
3.4%
Other values (4) 47
8.4%
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 557
76.5%
Hangul 171
 
23.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 92
16.5%
4 88
15.8%
- 86
15.4%
0 65
11.7%
8 39
7.0%
5 32
 
5.7%
7 31
 
5.6%
1 30
 
5.4%
3 28
 
5.0%
) 19
 
3.4%
Other values (4) 47
8.4%
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-13T01:34:33.943031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:34:36.484063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소명영업소소재지도로명전화번호
순번1.0001.0001.0000.667
영업소명1.0001.0001.0001.000
영업소소재지도로명1.0001.0001.0001.000
전화번호0.6671.0001.0001.000

Missing values

2023-12-13T01:34:34.050409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:34:34.160502image/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
순번영업소명영업소소재지도로명전화번호
5253㈜나은약품대전광역시 서구 대덕대로242번길 48 (둔산동)비공개(휴대전화번호)
5354파비스코리아㈜대전광역시 서구 도안대로 59, 관저워시존 2층 (관저동)042-826-4121
5455금강헬스케어대전광역시 서구 문정로90번길 65, 6층 602-19호 (탄방동)비공개(휴대전화번호)
5556주식회사 알파헬스케어대전광역시 서구 월평로 40, 월드프라자 8층 810호 (월평동)042-484-4782
5657제이메디팜대전광역시 서구 월평북로 85, 5층 512호 (월평동)비공개(휴대전화번호)
5758가온팜대전광역시 서구 계룡로232번길 150, 3층 309호 (월평동)042-710-8333
5859㈜에이스약품대전광역시 서구 대덕대로242번길 48, 4층 403호 (둔산동)042-822-7121
5960㈜삼성팜대전광역시 서구 대덕대로242번길 48, 4층 401호 (둔산동)042-477-1124
6061㈜우신팜대전광역시 서구 복수동로87번길 5-10, 2층 (복수동)042-253-7289
6162주식회사 베스트오베이대전광역시 서구 계룡로232번길 150, 2층 205호 (월평동)비공개(휴대전화번호)