Overview

Dataset statistics

Number of variables5
Number of observations50
Missing cells13
Missing cells (%)5.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory43.6 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description광주광역시 서구의 관내 의약품도매업소의 연번, 영업소명, 도로명주소, 전화번호, 데이터기준일 등에 대한 현황입니다
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15091992/fileData.do

Alerts

전화번호 has 13 (26.0%) missing valuesMissing
연번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-23 06:54:27.368685
Analysis finished2023-12-23 06:54:29.341684
Duration1.97 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.5
Minimum1
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-23T06:54:29.651182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.45
Q113.25
median25.5
Q337.75
95-th percentile47.55
Maximum50
Range49
Interquartile range (IQR)24.5

Descriptive statistics

Standard deviation14.57738
Coefficient of variation (CV)0.57166195
Kurtosis-1.2
Mean25.5
Median Absolute Deviation (MAD)12.5
Skewness0
Sum1275
Variance212.5
MonotonicityStrictly increasing
2023-12-23T06:54:30.287709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
2.0%
39 1
 
2.0%
29 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
36 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
ValueCountFrequency (%)
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%

영업종별
Categorical

Distinct3
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
일반종합도매
38 
한약도매
11 
의료용 고압가스
 
1

Length

Max length8
Median length6
Mean length5.6
Min length4

Unique

Unique1 ?
Unique (%)2.0%

Sample

1st row일반종합도매
2nd row일반종합도매
3rd row일반종합도매
4th row일반종합도매
5th row일반종합도매

Common Values

ValueCountFrequency (%)
일반종합도매 38
76.0%
한약도매 11
 
22.0%
의료용 고압가스 1
 
2.0%

Length

2023-12-23T06:54:30.884123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T06:54:31.326769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반종합도매 38
74.5%
한약도매 11
 
21.6%
의료용 1
 
2.0%
고압가스 1
 
2.0%

영업소명
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-23T06:54:32.020805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length7.98
Min length5

Characters and Unicode

Total characters399
Distinct characters92
Distinct categories4 ?
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 (%)100.0%

Sample

1st row주식회사 세인트팜
2nd row주식회사 밝은팜
3rd row주식회사솔로몬팜
4th row주식회사 타워메디
5th row주식회사 윈스톤
ValueCountFrequency (%)
주식회사 16
 
23.5%
재인약품 1
 
1.5%
삼대한약도매상 1
 
1.5%
신일특수가스 1
 
1.5%
주)구암약품 1
 
1.5%
주)기독약품 1
 
1.5%
주)에스엠팜 1
 
1.5%
회춘당 1
 
1.5%
한약도매 1
 
1.5%
주)디엔메디 1
 
1.5%
Other values (43) 43
63.2%
2023-12-23T06:54:33.372621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 36
 
9.0%
약 22
 
5.5%
회 19
 
4.8%
디 18
 
4.5%
식 18
 
4.5%
사 18
 
4.5%
18
 
4.5%
메 17
 
4.3%
( 17
 
4.3%
) 17
 
4.3%
Other values (82) 199
49.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 347
87.0%
Space Separator 18
 
4.5%
Open Punctuation 17
 
4.3%
Close Punctuation 17
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 36
 
10.4%
약 22
 
6.3%
회 19
 
5.5%
디 18
 
5.2%
식 18
 
5.2%
사 18
 
5.2%
메 17
 
4.9%
한 13
 
3.7%
품 11
 
3.2%
매 10
 
2.9%
Other values (79) 165
47.6%
Space Separator
ValueCountFrequency (%)
18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 347
87.0%
Common 52
 
13.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 36
 
10.4%
약 22
 
6.3%
회 19
 
5.5%
디 18
 
5.2%
식 18
 
5.2%
사 18
 
5.2%
메 17
 
4.9%
한 13
 
3.7%
품 11
 
3.2%
매 10
 
2.9%
Other values (79) 165
47.6%
Common
ValueCountFrequency (%)
18
34.6%
( 17
32.7%
) 17
32.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 347
87.0%
ASCII 52
 
13.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 36
 
10.4%
약 22
 
6.3%
회 19
 
5.5%
디 18
 
5.2%
식 18
 
5.2%
사 18
 
5.2%
메 17
 
4.9%
한 13
 
3.7%
품 11
 
3.2%
매 10
 
2.9%
Other values (79) 165
47.6%
ASCII
ValueCountFrequency (%)
18
34.6%
( 17
32.7%
) 17
32.7%

도로명주소
Text

Distinct48
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-23T06:54:34.262507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length35
Mean length29.28
Min length21

Characters and Unicode

Total characters1464
Distinct characters89
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

Unique46 ?
Unique (%)92.0%

Sample

1st row광주광역시 서구 금호동 787 중흥아파트 121동 114호 (금호동)
2nd row광주광역시 서구 상무대로 1065-1, 2층 205호 (화정동)
3rd row광주광역시 서구 금호운천길 72, 1층 (쌍촌동)
4th row광주광역시 서구 화정로280번길 4-1, 1층 101호 (농성동)
5th row광주광역시 서구 원마륵1길 19, 304호 (마륵동)
ValueCountFrequency (%)
광주광역시 50
 
16.9%
서구 50
 
16.9%
쌍촌동 11
 
3.7%
1층 9
 
3.1%
농성동 8
 
2.7%
2층 8
 
2.7%
19 6
 
2.0%
마륵동 6
 
2.0%
원마륵1길 6
 
2.0%
풍암동 5
 
1.7%
Other values (108) 136
46.1%
2023-12-23T06:54:35.653770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
245
 
16.7%
광 100
 
6.8%
1 85
 
5.8%
동 54
 
3.7%
서 52
 
3.6%
구 52
 
3.6%
주 52
 
3.6%
) 52
 
3.6%
( 52
 
3.6%
역 50
 
3.4%
Other values (79) 670
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 792
54.1%
Decimal Number 267
 
18.2%
Space Separator 245
 
16.7%
Close Punctuation 52
 
3.6%
Open Punctuation 52
 
3.6%
Other Punctuation 36
 
2.5%
Dash Punctuation 17
 
1.2%
Uppercase Letter 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 100
 
12.6%
동 54
 
6.8%
서 52
 
6.6%
구 52
 
6.6%
주 52
 
6.6%
역 50
 
6.3%
시 50
 
6.3%
로 40
 
5.1%
길 33
 
4.2%
층 27
 
3.4%
Other values (60) 282
35.6%
Decimal Number
ValueCountFrequency (%)
1 85
31.8%
2 40
15.0%
3 25
 
9.4%
0 21
 
7.9%
6 20
 
7.5%
9 18
 
6.7%
5 17
 
6.4%
7 14
 
5.2%
4 14
 
5.2%
8 13
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
B 1
33.3%
G 1
33.3%
K 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 35
97.2%
. 1
 
2.8%
Space Separator
ValueCountFrequency (%)
245
100.0%
Close Punctuation
ValueCountFrequency (%)
) 52
100.0%
Open Punctuation
ValueCountFrequency (%)
( 52
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 792
54.1%
Common 669
45.7%
Latin 3
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 100
 
12.6%
동 54
 
6.8%
서 52
 
6.6%
구 52
 
6.6%
주 52
 
6.6%
역 50
 
6.3%
시 50
 
6.3%
로 40
 
5.1%
길 33
 
4.2%
층 27
 
3.4%
Other values (60) 282
35.6%
Common
ValueCountFrequency (%)
245
36.6%
1 85
 
12.7%
) 52
 
7.8%
( 52
 
7.8%
2 40
 
6.0%
, 35
 
5.2%
3 25
 
3.7%
0 21
 
3.1%
6 20
 
3.0%
9 18
 
2.7%
Other values (6) 76
 
11.4%
Latin
ValueCountFrequency (%)
B 1
33.3%
G 1
33.3%
K 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 792
54.1%
ASCII 672
45.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
245
36.5%
1 85
 
12.6%
) 52
 
7.7%
( 52
 
7.7%
2 40
 
6.0%
, 35
 
5.2%
3 25
 
3.7%
0 21
 
3.1%
6 20
 
3.0%
9 18
 
2.7%
Other values (9) 79
 
11.8%
Hangul
ValueCountFrequency (%)
광 100
 
12.6%
동 54
 
6.8%
서 52
 
6.6%
구 52
 
6.6%
주 52
 
6.6%
역 50
 
6.3%
시 50
 
6.3%
로 40
 
5.1%
길 33
 
4.2%
층 27
 
3.4%
Other values (60) 282
35.6%

전화번호
Text

MISSING 

Distinct37
Distinct (%)100.0%
Missing13
Missing (%)26.0%
Memory size532.0 B
2023-12-23T06:54:36.420499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique37 ?
Unique (%)100.0%

Sample

1st row062-529-9687
2nd row062-262-3611
3rd row062-953-0975
4th row062-529-8813
5th row062-375-6655
ValueCountFrequency (%)
062-372-2381 1
 
2.7%
062-431-4207 1
 
2.7%
062-362-1110 1
 
2.7%
062-362-1515 1
 
2.7%
062-363-8319 1
 
2.7%
062-655-4040 1
 
2.7%
062-352-7887 1
 
2.7%
062-364-7080 1
 
2.7%
062-674-8586 1
 
2.7%
062-365-5445 1
 
2.7%
Other values (27) 27
73.0%
2023-12-23T06:54:37.698631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 74
16.7%
6 69
15.5%
2 65
14.6%
0 59
13.3%
3 41
9.2%
5 41
9.2%
7 26
 
5.9%
8 21
 
4.7%
1 21
 
4.7%
4 16
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 370
83.3%
Dash Punctuation 74
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 69
18.6%
2 65
17.6%
0 59
15.9%
3 41
11.1%
5 41
11.1%
7 26
 
7.0%
8 21
 
5.7%
1 21
 
5.7%
4 16
 
4.3%
9 11
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 74
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 444
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 74
16.7%
6 69
15.5%
2 65
14.6%
0 59
13.3%
3 41
9.2%
5 41
9.2%
7 26
 
5.9%
8 21
 
4.7%
1 21
 
4.7%
4 16
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 444
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 74
16.7%
6 69
15.5%
2 65
14.6%
0 59
13.3%
3 41
9.2%
5 41
9.2%
7 26
 
5.9%
8 21
 
4.7%
1 21
 
4.7%
4 16
 
3.6%

Interactions

2023-12-23T06:54:28.157943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-23T06:54:38.197481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번영업종별영업소명도로명주소전화번호
연번1.0000.6441.0000.8611.000
영업종별0.6441.0001.0001.0001.000
영업소명1.0001.0001.0001.0001.000
도로명주소0.8611.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
2023-12-23T06:54:38.781085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번영업종별
연번1.0000.451
영업종별0.4511.000

Missing values

2023-12-23T06:54:28.546999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T06:54:29.085360image/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일반종합도매주식회사 세인트팜광주광역시 서구 금호동 787 중흥아파트 121동 114호 (금호동)<NA>
12일반종합도매주식회사 밝은팜광주광역시 서구 상무대로 1065-1, 2층 205호 (화정동)<NA>
23일반종합도매주식회사솔로몬팜광주광역시 서구 금호운천길 72, 1층 (쌍촌동)<NA>
34일반종합도매주식회사 타워메디광주광역시 서구 화정로280번길 4-1, 1층 101호 (농성동)<NA>
45일반종합도매주식회사 윈스톤광주광역시 서구 원마륵1길 19, 304호 (마륵동)<NA>
56일반종합도매(주)민주메디칼광주광역시 서구 원마륵1길 19, 3층 302호 (마륵동)<NA>
67일반종합도매주식회사 동원메디스광주광역시 서구 원마륵1길 19, 306호 (마륵동)<NA>
78일반종합도매주식회사 중원약품광주광역시 서구 원마륵1길 19, 305호 (마륵동)<NA>
89일반종합도매주식회사 성운메디칼광주광역시 서구 눌재로 252-16, 1층 (서창동)062-529-9687
910일반종합도매주식회사 한라메디팜광주광역시 서구 상무공원로 15 (치평동)062-262-3611
연번영업종별영업소명도로명주소전화번호
4041일반종합도매(주)중앙약품광주광역시 서구 원마륵1길 19 (마륵동)062-382-3377
4142한약도매보민당한약도매광주광역시 서구 군분2로5번길 6-1 (화정동,(일층))062-365-5445
4243일반종합도매(주)호남지오영광주광역시 서구 덕흥1길 29, B동 2층 (덕흥동)062-383-6070
4344한약도매명신당한약도매광주광역시 서구 화운로 116, 1층 (화정동)062-524-4545
4445한약도매순천당한약도매상광주광역시 서구 화정로253번길 36 (농성동)062-367-2228
4546한약도매운천원한약도매상광주광역시 서구 상무대로868번길 18 (쌍촌동)062-371-5599
4647한약도매영창당한약도매상광주광역시 서구 월산로169번길 3-1 (농성동)062-365-3020
4748한약도매장수당한약도매상광주광역시 서구 천변좌로262번길 17 (양동)062-362-0270
4849한약도매삼대한약도매상광주광역시 서구 월드컵4강로158번길 15-5 (쌍촌동)062-373-5225
4950한약도매삼성당한약도매상광주광역시 서구 구성로 129 (양동)062-365-2611