Overview

Dataset statistics

Number of variables6
Number of observations72
Missing cells4
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.6 KiB
Average record size in memory50.8 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

Description대구광역시 북구_의약품도매상현황_20230418
Author대구광역시 북구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15077921&dataSetDetailId=150779211b0ad19186d95&provdMethod=FILE

Alerts

데이터기준일자 has constant value ""Constant
영업소전화번호 has 4 (5.6%) missing valuesMissing
순번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 18:04:03.690802
Analysis finished2023-12-10 18:04:05.208444
Duration1.52 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct72
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.5
Minimum1
Maximum72
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size780.0 B
2023-12-11T03:04:05.344032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.55
Q118.75
median36.5
Q354.25
95-th percentile68.45
Maximum72
Range71
Interquartile range (IQR)35.5

Descriptive statistics

Standard deviation20.92845
Coefficient of variation (CV)0.57338218
Kurtosis-1.2
Mean36.5
Median Absolute Deviation (MAD)18
Skewness0
Sum2628
Variance438
MonotonicityStrictly increasing
2023-12-11T03:04:05.658953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
38 1
 
1.4%
54 1
 
1.4%
53 1
 
1.4%
52 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
Other values (62) 62
86.1%
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 (%)
72 1
1.4%
71 1
1.4%
70 1
1.4%
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%

영업종별
Categorical

Distinct3
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size708.0 B
일반종합도매
59 
한약도매
7 
의료용 고압가스
6 

Length

Max length8
Median length6
Mean length5.9722222
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
일반종합도매 59
81.9%
한약도매 7
 
9.7%
의료용 고압가스 6
 
8.3%

Length

2023-12-11T03:04:05.960412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:04:06.180585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반종합도매 59
75.6%
한약도매 7
 
9.0%
의료용 6
 
7.7%
고압가스 6
 
7.7%

영업소명
Text

UNIQUE 

Distinct72
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size708.0 B
2023-12-11T03:04:06.616865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9.5
Mean length6.0833333
Min length3

Characters and Unicode

Total characters438
Distinct characters117
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

Unique72 ?
Unique (%)100.0%

Sample

1st row(주)바로메디
2nd row제이케이팜
3rd row와이지엠바이오
4th row(주)미래약품
5th row주식회사 씨드약품
ValueCountFrequency (%)
주식회사 13
 
15.3%
태성약품 2
 
2.4%
청명약품 2
 
2.4%
다온팜 2
 
2.4%
주)바로메디 1
 
1.2%
디케이팜(dk팜 1
 
1.2%
삼원한약품 1
 
1.2%
한국팜 1
 
1.2%
다우약품 1
 
1.2%
에이치케이(hk)약품 1
 
1.2%
Other values (60) 60
70.6%
2023-12-11T03:04:07.310414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 28
 
6.4%
주 25
 
5.7%
품 23
 
5.3%
팜 22
 
5.0%
사 17
 
3.9%
디 15
 
3.4%
( 14
 
3.2%
) 14
 
3.2%
메 14
 
3.2%
식 13
 
3.0%
Other values (107) 253
57.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 388
88.6%
Open Punctuation 14
 
3.2%
Close Punctuation 14
 
3.2%
Space Separator 13
 
3.0%
Uppercase Letter 7
 
1.6%
Other Symbol 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 28
 
7.2%
주 25
 
6.4%
품 23
 
5.9%
팜 22
 
5.7%
사 17
 
4.4%
디 15
 
3.9%
메 14
 
3.6%
식 13
 
3.4%
회 13
 
3.4%
이 11
 
2.8%
Other values (97) 207
53.4%
Uppercase Letter
ValueCountFrequency (%)
K 2
28.6%
D 1
14.3%
H 1
14.3%
A 1
14.3%
U 1
14.3%
M 1
14.3%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Space Separator
ValueCountFrequency (%)
13
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 390
89.0%
Common 41
 
9.4%
Latin 7
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 28
 
7.2%
주 25
 
6.4%
품 23
 
5.9%
팜 22
 
5.6%
사 17
 
4.4%
디 15
 
3.8%
메 14
 
3.6%
식 13
 
3.3%
회 13
 
3.3%
이 11
 
2.8%
Other values (98) 209
53.6%
Latin
ValueCountFrequency (%)
K 2
28.6%
D 1
14.3%
H 1
14.3%
A 1
14.3%
U 1
14.3%
M 1
14.3%
Common
ValueCountFrequency (%)
( 14
34.1%
) 14
34.1%
13
31.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 388
88.6%
ASCII 48
 
11.0%
None 2
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 28
 
7.2%
주 25
 
6.4%
품 23
 
5.9%
팜 22
 
5.7%
사 17
 
4.4%
디 15
 
3.9%
메 14
 
3.6%
식 13
 
3.4%
회 13
 
3.4%
이 11
 
2.8%
Other values (97) 207
53.4%
ASCII
ValueCountFrequency (%)
( 14
29.2%
) 14
29.2%
13
27.1%
K 2
 
4.2%
D 1
 
2.1%
H 1
 
2.1%
A 1
 
2.1%
U 1
 
2.1%
M 1
 
2.1%
None
ValueCountFrequency (%)
㈜ 2
100.0%

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

Distinct65
Distinct (%)90.3%
Missing0
Missing (%)0.0%
Memory size708.0 B
2023-12-11T03:04:07.861980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length43
Mean length31.138889
Min length23

Characters and Unicode

Total characters2242
Distinct characters95
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

Unique60 ?
Unique (%)83.3%

Sample

1st row대구광역시 북구 한강로8길 13-4, 주건축물제1동 5층 506-2호 (금호동)
2nd row대구광역시 북구 환성정길 36, 2층 (서변동)
3rd row대구광역시 북구 호국로 209, 6층 (서변동)
4th row대구광역시 북구 유통단지로8길 108-9, 1층 (산격동)
5th row대구광역시 북구 한강로8길 13-4, 주건축물제1동 5층 506호 (금호동)
ValueCountFrequency (%)
대구광역시 72
 
15.5%
북구 72
 
15.5%
2층 21
 
4.5%
산격동 20
 
4.3%
서변동 14
 
3.0%
3층 12
 
2.6%
1층 10
 
2.2%
4층 9
 
1.9%
33 7
 
1.5%
동암로12길 7
 
1.5%
Other values (127) 221
47.5%
2023-12-11T03:04:08.615341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
393
 
17.5%
구 148
 
6.6%
동 107
 
4.8%
대 80
 
3.6%
1 79
 
3.5%
북 77
 
3.4%
) 75
 
3.3%
( 75
 
3.3%
2 74
 
3.3%
, 73
 
3.3%
Other values (85) 1061
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1197
53.4%
Decimal Number 396
 
17.7%
Space Separator 393
 
17.5%
Close Punctuation 75
 
3.3%
Open Punctuation 75
 
3.3%
Other Punctuation 73
 
3.3%
Dash Punctuation 31
 
1.4%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 148
 
12.4%
동 107
 
8.9%
대 80
 
6.7%
북 77
 
6.4%
광 72
 
6.0%
역 72
 
6.0%
시 72
 
6.0%
로 69
 
5.8%
층 62
 
5.2%
길 40
 
3.3%
Other values (68) 398
33.2%
Decimal Number
ValueCountFrequency (%)
1 79
19.9%
2 74
18.7%
3 68
17.2%
4 44
11.1%
5 34
8.6%
0 30
 
7.6%
8 25
 
6.3%
7 16
 
4.0%
6 15
 
3.8%
9 11
 
2.8%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
A 1
50.0%
Space Separator
ValueCountFrequency (%)
393
100.0%
Close Punctuation
ValueCountFrequency (%)
) 75
100.0%
Open Punctuation
ValueCountFrequency (%)
( 75
100.0%
Other Punctuation
ValueCountFrequency (%)
, 73
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1197
53.4%
Common 1043
46.5%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 148
 
12.4%
동 107
 
8.9%
대 80
 
6.7%
북 77
 
6.4%
광 72
 
6.0%
역 72
 
6.0%
시 72
 
6.0%
로 69
 
5.8%
층 62
 
5.2%
길 40
 
3.3%
Other values (68) 398
33.2%
Common
ValueCountFrequency (%)
393
37.7%
1 79
 
7.6%
) 75
 
7.2%
( 75
 
7.2%
2 74
 
7.1%
, 73
 
7.0%
3 68
 
6.5%
4 44
 
4.2%
5 34
 
3.3%
- 31
 
3.0%
Other values (5) 97
 
9.3%
Latin
ValueCountFrequency (%)
B 1
50.0%
A 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1197
53.4%
ASCII 1045
46.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
393
37.6%
1 79
 
7.6%
) 75
 
7.2%
( 75
 
7.2%
2 74
 
7.1%
, 73
 
7.0%
3 68
 
6.5%
4 44
 
4.2%
5 34
 
3.3%
- 31
 
3.0%
Other values (7) 99
 
9.5%
Hangul
ValueCountFrequency (%)
구 148
 
12.4%
동 107
 
8.9%
대 80
 
6.7%
북 77
 
6.4%
광 72
 
6.0%
역 72
 
6.0%
시 72
 
6.0%
로 69
 
5.8%
층 62
 
5.2%
길 40
 
3.3%
Other values (68) 398
33.2%

영업소전화번호
Text

MISSING 

Distinct66
Distinct (%)97.1%
Missing4
Missing (%)5.6%
Memory size708.0 B
2023-12-11T03:04:08.987625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.073529
Min length12

Characters and Unicode

Total characters821
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique64 ?
Unique (%)94.1%

Sample

1st row053-243-7770
2nd row053-384-1045
3rd row053-325-8890
4th row053-939-8875
5th row053-313-0030
ValueCountFrequency (%)
053-313-0030 2
 
2.9%
053-471-7182 2
 
2.9%
053-280-3100 1
 
1.5%
053-357-1133 1
 
1.5%
053-311-5031 1
 
1.5%
053-356-0308 1
 
1.5%
053-321-3403 1
 
1.5%
053-326-7781 1
 
1.5%
053-719-0233 1
 
1.5%
053-383-2002 1
 
1.5%
Other values (56) 56
82.4%
2023-12-11T03:04:09.686422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 138
16.8%
- 136
16.6%
5 135
16.4%
0 117
14.3%
1 61
7.4%
7 59
7.2%
8 48
 
5.8%
9 38
 
4.6%
2 35
 
4.3%
4 29
 
3.5%
Other values (2) 25
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 684
83.3%
Dash Punctuation 136
 
16.6%
Math Symbol 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 138
20.2%
5 135
19.7%
0 117
17.1%
1 61
8.9%
7 59
8.6%
8 48
 
7.0%
9 38
 
5.6%
2 35
 
5.1%
4 29
 
4.2%
6 24
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 136
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 821
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 138
16.8%
- 136
16.6%
5 135
16.4%
0 117
14.3%
1 61
7.4%
7 59
7.2%
8 48
 
5.8%
9 38
 
4.6%
2 35
 
4.3%
4 29
 
3.5%
Other values (2) 25
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 821
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 138
16.8%
- 136
16.6%
5 135
16.4%
0 117
14.3%
1 61
7.4%
7 59
7.2%
8 48
 
5.8%
9 38
 
4.6%
2 35
 
4.3%
4 29
 
3.5%
Other values (2) 25
 
3.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size708.0 B
Minimum2023-04-18 00:00:00
Maximum2023-04-18 00:00:00
2023-12-11T03:04:09.878016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T03:04:10.055234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T03:04:04.502833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T03:04:10.201350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업종별영업소명영업소소재지(도로명)영업소전화번호
순번1.0000.4921.0000.7820.806
영업종별0.4921.0001.0001.0001.000
영업소명1.0001.0001.0001.0001.000
영업소소재지(도로명)0.7821.0001.0001.0000.998
영업소전화번호0.8061.0001.0000.9981.000
2023-12-11T03:04:10.379709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업종별
순번1.0000.320
영업종별0.3201.000

Missing values

2023-12-11T03:04:04.737934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T03:04:05.037099image/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일반종합도매(주)바로메디대구광역시 북구 한강로8길 13-4, 주건축물제1동 5층 506-2호 (금호동)<NA>2023-04-18
12일반종합도매제이케이팜대구광역시 북구 환성정길 36, 2층 (서변동)053-243-77702023-04-18
23일반종합도매와이지엠바이오대구광역시 북구 호국로 209, 6층 (서변동)<NA>2023-04-18
34일반종합도매(주)미래약품대구광역시 북구 유통단지로8길 108-9, 1층 (산격동)053-384-10452023-04-18
45일반종합도매주식회사 씨드약품대구광역시 북구 한강로8길 13-4, 주건축물제1동 5층 506호 (금호동)053-325-88902023-04-18
56일반종합도매MUA메디(엠유에이메디)대구광역시 북구 호국로 807-25, 1층 (학정동)<NA>2023-04-18
67일반종합도매주식회사 태성약품대구광역시 북구 대현로9길 58, 5층 606호 (산격동)053-939-88752023-04-18
78일반종합도매조은팜대구광역시 북구 학정로 551-50, 2층 (학정동)053-313-00302023-04-18
89일반종합도매책임약품대구광역시 북구 검단공단로 33, (주)동원약품 본동 2층 202호 (산격동)053-710-70112023-04-18
910일반종합도매오션팜대구광역시 북구 원대로 46, 3층 (고성동3가)053-351-48882023-04-18
순번영업종별영업소명영업소소재지(도로명)영업소전화번호데이터기준일자
6263일반종합도매태성약품대구광역시 북구 학남로 43-30, 1층 (학정동)070-8857-67662023-04-18
6364일반종합도매네오팜메디텍대구광역시 북구 학정로13길 25, 2층 (태전동)053-527-28902023-04-18
6465일반종합도매(주)세종약품판매대구광역시 북구 환성정길 12-8, 1,2층 (서변동)053-951-71712023-04-18
6566일반종합도매유안메디칼 주식회사대구광역시 북구 호국로 249, 5층 (서변동)053-956-89952023-04-18
6667일반종합도매㈜동원약품대구광역시 북구 검단공단로 33, 3층 (산격동)053-381-55552023-04-18
6768한약도매만보당약업사대구광역시 북구 팔달로33길 28 (노원동3가)053-357-70142023-04-18
6869한약도매동성약업사대구광역시 북구 태암로18길 28, 1층 (구암동)053-765-71502023-04-18
6970한약도매청운약업사대구광역시 북구 팔거천서로 43-2 (태전동)053-322-74012023-04-18
7071일반종합도매㈜경동사대구광역시 북구 연암로 199, 주건축물제1동 2층 (산격동)053-280-31002023-04-18
7172의료용 고압가스에어젠대구광역시 북구 검단북로2길 18, 제3동 2층 (산격동)053-1899-53132023-04-18