Overview

Dataset statistics

Number of variables6
Number of observations31
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory53.3 B

Variable types

Numeric1
Categorical1
Text3
DateTime1

Dataset

Description서울특별시 금천구 의약품 도소매업소 현황으로 연번, 영업종별, 영업소명, 영업소소재지(도로명), 영업소전화번호, 데이터기준일자를 제공합니다.
URLhttps://www.data.go.kr/data/3081140/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
영업종별 is highly imbalanced (69.4%)Imbalance
순번 has unique valuesUnique
영업소명 has unique valuesUnique
영업소소재지(도로명) has unique valuesUnique
영업소전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 04:07:28.801007
Analysis finished2023-12-12 04:07:29.559143
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-12T13:07:29.649446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q18.5
median16
Q323.5
95-th percentile29.5
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation9.0921211
Coefficient of variation (CV)0.56825757
Kurtosis-1.2
Mean16
Median Absolute Deviation (MAD)8
Skewness0
Sum496
Variance82.666667
MonotonicityStrictly increasing
2023-12-12T13:07:29.823256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
31 1
 
3.2%
30 1
 
3.2%
29 1
 
3.2%
28 1
 
3.2%
27 1
 
3.2%
26 1
 
3.2%
25 1
 
3.2%
24 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
1 1
3.2%
2 1
3.2%
3 1
3.2%
4 1
3.2%
5 1
3.2%
6 1
3.2%
7 1
3.2%
8 1
3.2%
9 1
3.2%
10 1
3.2%
ValueCountFrequency (%)
31 1
3.2%
30 1
3.2%
29 1
3.2%
28 1
3.2%
27 1
3.2%
26 1
3.2%
25 1
3.2%
24 1
3.2%
23 1
3.2%
22 1
3.2%

영업종별
Categorical

IMBALANCE 

Distinct4
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size380.0 B
일반종합도매
28 
의료용 고압가스
 
1
원료의약품도매
 
1
한약도매
 
1

Length

Max length8
Median length6
Mean length6.0322581
Min length4

Unique

Unique3 ?
Unique (%)9.7%

Sample

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

Common Values

ValueCountFrequency (%)
일반종합도매 28
90.3%
의료용 고압가스 1
 
3.2%
원료의약품도매 1
 
3.2%
한약도매 1
 
3.2%

Length

2023-12-12T13:07:29.997452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:07:30.166781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반종합도매 28
87.5%
의료용 1
 
3.1%
고압가스 1
 
3.1%
원료의약품도매 1
 
3.1%
한약도매 1
 
3.1%

영업소명
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T13:07:30.481853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length7.6774194
Min length5

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row(주)케이비에이치케어
2nd row주식회사 헬피
3rd row디엑스앤브이엑스(주)
4th row(주)이데아약품
5th row클리니젠코리아 유한회사
ValueCountFrequency (%)
주식회사 2
 
5.9%
주)웰스팜텍 1
 
2.9%
제이웨이팜 1
 
2.9%
리퓨어헬스케어(주 1
 
2.9%
㈜광림프로세스 1
 
2.9%
주)엠앤제이에스 1
 
2.9%
㈜티에스약품 1
 
2.9%
한국크라시에약품주식회사 1
 
2.9%
주)케이비에이치케어 1
 
2.9%
주)엘루어코리아 1
 
2.9%
Other values (23) 23
67.6%
2023-12-12T13:07:30.975187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 19
 
8.0%
( 16
 
6.7%
) 16
 
6.7%
이 12
 
5.0%
스 12
 
5.0%
㈜ 7
 
2.9%
리 6
 
2.5%
아 6
 
2.5%
에 6
 
2.5%
코 5
 
2.1%
Other values (69) 133
55.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 196
82.4%
Open Punctuation 16
 
6.7%
Close Punctuation 16
 
6.7%
Other Symbol 7
 
2.9%
Space Separator 3
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 19
 
9.7%
이 12
 
6.1%
스 12
 
6.1%
리 6
 
3.1%
아 6
 
3.1%
에 6
 
3.1%
코 5
 
2.6%
팜 5
 
2.6%
사 4
 
2.0%
회 4
 
2.0%
Other values (65) 117
59.7%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 7
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 203
85.3%
Common 35
 
14.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 19
 
9.4%
이 12
 
5.9%
스 12
 
5.9%
㈜ 7
 
3.4%
리 6
 
3.0%
아 6
 
3.0%
에 6
 
3.0%
코 5
 
2.5%
팜 5
 
2.5%
사 4
 
2.0%
Other values (66) 121
59.6%
Common
ValueCountFrequency (%)
( 16
45.7%
) 16
45.7%
3
 
8.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 196
82.4%
ASCII 35
 
14.7%
None 7
 
2.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 19
 
9.7%
이 12
 
6.1%
스 12
 
6.1%
리 6
 
3.1%
아 6
 
3.1%
에 6
 
3.1%
코 5
 
2.6%
팜 5
 
2.6%
사 4
 
2.0%
회 4
 
2.0%
Other values (65) 117
59.7%
ASCII
ValueCountFrequency (%)
( 16
45.7%
) 16
45.7%
3
 
8.6%
None
ValueCountFrequency (%)
㈜ 7
100.0%

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

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T13:07:31.391707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length42
Mean length39.387097
Min length24

Characters and Unicode

Total characters1221
Distinct characters105
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

Unique31 ?
Unique (%)100.0%

Sample

1st row서울특별시 금천구 디지털로9길 68, 대륭포스트타워 5차 228호 (가산동)
2nd row서울특별시 금천구 서부샛길 606, 대성디폴리스지식산업센터 2층 208-2호 (가산동)
3rd row서울특별시 금천구 벚꽃로 244, 벽산디지털밸리5차 제2층 213호 (가산동)
4th row서울특별시 금천구 가산디지털2로 34, 219호, 220호 (가산동)
5th row서울특별시 금천구 가산디지털2로 70, 대륭테크노타운19차 6층 606호 (가산동)
ValueCountFrequency (%)
서울특별시 31
 
14.0%
금천구 31
 
14.0%
가산동 21
 
9.5%
가산디지털1로 9
 
4.1%
가산디지털2로 6
 
2.7%
독산동 5
 
2.3%
시흥동 5
 
2.3%
시흥대로 3
 
1.4%
2층 3
 
1.4%
67 2
 
0.9%
Other values (96) 106
47.7%
2023-12-12T13:07:31.995584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
191
 
15.6%
1 59
 
4.8%
산 46
 
3.8%
시 44
 
3.6%
2 43
 
3.5%
가 39
 
3.2%
, 35
 
2.9%
동 33
 
2.7%
서 32
 
2.6%
천 31
 
2.5%
Other values (95) 668
54.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 698
57.2%
Decimal Number 224
 
18.3%
Space Separator 191
 
15.6%
Other Punctuation 35
 
2.9%
Close Punctuation 31
 
2.5%
Open Punctuation 31
 
2.5%
Dash Punctuation 7
 
0.6%
Uppercase Letter 4
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 46
 
6.6%
시 44
 
6.3%
가 39
 
5.6%
동 33
 
4.7%
서 32
 
4.6%
천 31
 
4.4%
울 31
 
4.4%
특 31
 
4.4%
구 31
 
4.4%
별 31
 
4.4%
Other values (77) 349
50.0%
Decimal Number
ValueCountFrequency (%)
1 59
26.3%
2 43
19.2%
0 24
10.7%
3 18
 
8.0%
6 15
 
6.7%
7 14
 
6.2%
9 14
 
6.2%
5 13
 
5.8%
4 13
 
5.8%
8 11
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
T 2
50.0%
K 1
25.0%
I 1
25.0%
Space Separator
ValueCountFrequency (%)
191
100.0%
Other Punctuation
ValueCountFrequency (%)
, 35
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 698
57.2%
Common 519
42.5%
Latin 4
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 46
 
6.6%
시 44
 
6.3%
가 39
 
5.6%
동 33
 
4.7%
서 32
 
4.6%
천 31
 
4.4%
울 31
 
4.4%
특 31
 
4.4%
구 31
 
4.4%
별 31
 
4.4%
Other values (77) 349
50.0%
Common
ValueCountFrequency (%)
191
36.8%
1 59
 
11.4%
2 43
 
8.3%
, 35
 
6.7%
) 31
 
6.0%
( 31
 
6.0%
0 24
 
4.6%
3 18
 
3.5%
6 15
 
2.9%
7 14
 
2.7%
Other values (5) 58
 
11.2%
Latin
ValueCountFrequency (%)
T 2
50.0%
K 1
25.0%
I 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 698
57.2%
ASCII 523
42.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
191
36.5%
1 59
 
11.3%
2 43
 
8.2%
, 35
 
6.7%
) 31
 
5.9%
( 31
 
5.9%
0 24
 
4.6%
3 18
 
3.4%
6 15
 
2.9%
7 14
 
2.7%
Other values (8) 62
 
11.9%
Hangul
ValueCountFrequency (%)
산 46
 
6.6%
시 44
 
6.3%
가 39
 
5.6%
동 33
 
4.7%
서 32
 
4.6%
천 31
 
4.4%
울 31
 
4.4%
특 31
 
4.4%
구 31
 
4.4%
별 31
 
4.4%
Other values (77) 349
50.0%

영업소전화번호
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T13:07:32.253976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.419355
Min length7

Characters and Unicode

Total characters354
Distinct characters24
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

Unique31 ?
Unique (%)100.0%

Sample

1st row데이터 미수집
2nd row02-6951-3980
3rd row02-6956-8754
4th row02-511-7013
5th row02-2088-1152
ValueCountFrequency (%)
데이터 1
 
3.0%
02-6111-8490 1
 
3.0%
02-802-8308 1
 
3.0%
02-808-3264 1
 
3.0%
02-2163-0055 1
 
3.0%
02-858-6211 1
 
3.0%
02-2645-4936 1
 
3.0%
02-3663-5558 1
 
3.0%
070-8230-4572 1
 
3.0%
02-2659-2257 1
 
3.0%
Other values (23) 23
69.7%
2023-12-12T13:07:32.639805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 58
16.4%
0 56
15.8%
2 50
14.1%
6 32
9.0%
5 27
7.6%
3 25
7.1%
8 25
7.1%
1 20
 
5.6%
4 16
 
4.5%
9 16
 
4.5%
Other values (14) 29
8.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 282
79.7%
Dash Punctuation 58
 
16.4%
Other Letter 12
 
3.4%
Space Separator 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 1
8.3%
인 1
8.3%
보 1
8.3%
포 1
8.3%
개 1
8.3%
데 1
8.3%
이 1
8.3%
집 1
8.3%
수 1
8.3%
미 1
8.3%
Other values (2) 2
16.7%
Decimal Number
ValueCountFrequency (%)
0 56
19.9%
2 50
17.7%
6 32
11.3%
5 27
9.6%
3 25
8.9%
8 25
8.9%
1 20
 
7.1%
4 16
 
5.7%
9 16
 
5.7%
7 15
 
5.3%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 342
96.6%
Hangul 12
 
3.4%

Most frequent character per script

Common
ValueCountFrequency (%)
- 58
17.0%
0 56
16.4%
2 50
14.6%
6 32
9.4%
5 27
7.9%
3 25
7.3%
8 25
7.3%
1 20
 
5.8%
4 16
 
4.7%
9 16
 
4.7%
Other values (2) 17
 
5.0%
Hangul
ValueCountFrequency (%)
정 1
8.3%
인 1
8.3%
보 1
8.3%
포 1
8.3%
개 1
8.3%
데 1
8.3%
이 1
8.3%
집 1
8.3%
수 1
8.3%
미 1
8.3%
Other values (2) 2
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 342
96.6%
Hangul 12
 
3.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 58
17.0%
0 56
16.4%
2 50
14.6%
6 32
9.4%
5 27
7.9%
3 25
7.3%
8 25
7.3%
1 20
 
5.8%
4 16
 
4.7%
9 16
 
4.7%
Other values (2) 17
 
5.0%
Hangul
ValueCountFrequency (%)
정 1
8.3%
인 1
8.3%
보 1
8.3%
포 1
8.3%
개 1
8.3%
데 1
8.3%
이 1
8.3%
집 1
8.3%
수 1
8.3%
미 1
8.3%
Other values (2) 2
16.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
Minimum2023-08-03 00:00:00
Maximum2023-08-03 00:00:00
2023-12-12T13:07:32.772827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:07:32.866776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T13:07:29.110358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:07:32.938889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업종별영업소명영업소소재지(도로명)영업소전화번호
순번1.0000.0001.0001.0001.000
영업종별0.0001.0001.0001.0001.000
영업소명1.0001.0001.0001.0001.000
영업소소재지(도로명)1.0001.0001.0001.0001.000
영업소전화번호1.0001.0001.0001.0001.000
2023-12-12T13:07:33.031242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업종별
순번1.0000.103
영업종별0.1031.000

Missing values

2023-12-12T13:07:29.290974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:07:29.486710image/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일반종합도매(주)케이비에이치케어서울특별시 금천구 디지털로9길 68, 대륭포스트타워 5차 228호 (가산동)데이터 미수집2023-08-03
12일반종합도매주식회사 헬피서울특별시 금천구 서부샛길 606, 대성디폴리스지식산업센터 2층 208-2호 (가산동)02-6951-39802023-08-03
23일반종합도매디엑스앤브이엑스(주)서울특별시 금천구 벚꽃로 244, 벽산디지털밸리5차 제2층 213호 (가산동)02-6956-87542023-08-03
34일반종합도매(주)이데아약품서울특별시 금천구 가산디지털2로 34, 219호, 220호 (가산동)02-511-70132023-08-03
45일반종합도매클리니젠코리아 유한회사서울특별시 금천구 가산디지털2로 70, 대륭테크노타운19차 6층 606호 (가산동)02-2088-11522023-08-03
56일반종합도매(주)에스티디아이엔씨서울특별시 금천구 디지털로9길 99, 스타밸리 제2층 202-1호 (가산동)02-6267-14172023-08-03
67일반종합도매(주)바이오지서울특별시 금천구 가산디지털1로 205-27, 1511호 (가산동)02-6956-60852023-08-03
78일반종합도매주식회사 테나리코서울특별시 금천구 가산디지털2로 101, 한라원앤원타워 비동 1809호 (가산동)02-857-33032023-08-03
89일반종합도매(주)미앤코팜서울특별시 금천구 가산디지털1로 205-27, 1512호 (가산동)02-6949-33412023-08-03
910일반종합도매(주)엘씨엘글로벌서울특별시 금천구 가산디지털1로 181, 가산 더블유센터 305호 (가산동)02-2679-99092023-08-03
순번영업종별영업소명영업소소재지(도로명)영업소전화번호데이터기준일자
2122일반종합도매한국크라시에약품주식회사서울특별시 금천구 가산디지털2로 101, 에이동 1808호 (가산동)02-3486-04602023-08-03
2223일반종합도매(주)웰스팜텍서울특별시 금천구 가산디지털1로 24, 대륭테크노타운13차 비101-1호 (가산동)02-2659-22572023-08-03
2324일반종합도매(주)에코테라팜서울특별시 금천구 시흥대로 487, 9층 (독산동)070-8230-45722023-08-03
2425일반종합도매㈜송정약품서울특별시 금천구 한내로 56, KT전화국 3층 (독산동)02-3663-55582023-08-03
2526일반종합도매㈜창조테크노서울특별시 금천구 가산디지털1로 2, 1113호 (가산동, 우림라이온스밸리2차)02-2645-49362023-08-03
2627일반종합도매지아이메딕스㈜서울특별시 금천구 벚꽃로 234, 1601호 (가산동, 에이스하이엔드타워6차)02-858-62112023-08-03
2728일반종합도매우리메디칼서울특별시 금천구 가마산로 96, 대륭테크노타운8차 210호 (가산동)02-2163-00552023-08-03
2829일반종합도매㈜메가마트서울특별시 금천구 시흥대로27길 32, 2층 (시흥동)02-808-32642023-08-03
2930한약도매백제한방유통서울특별시 금천구 시흥대로105길 23 (독산동)02-802-83082023-08-03
3031일반종합도매글로벌팜㈜서울특별시 금천구 시흥대로 143, 지층 6호 (시흥동)02-892-04262023-08-03