Overview

Dataset statistics

Number of variables4
Number of observations44
Missing cells11
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory36.0 B

Variable types

Numeric1
Text3

Dataset

Description인천광역시 계양구 관내 의약품 도매업소 현황에 대한 데이터로, 순번, 영업소명, 영업소 소재지(도로명주소), 영업소 전화번호 등을 제공합니다.
Author인천광역시 계양구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15039241&srcSe=7661IVAWM27C61E190

Alerts

영업소전화번호 has 11 (25.0%) missing valuesMissing
순번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2024-03-13 06:05:20.345664
Analysis finished2024-03-13 06:05:20.782852
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.5
Minimum1
Maximum44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size528.0 B
2024-03-13T15:05:20.861986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.15
Q111.75
median22.5
Q333.25
95-th percentile41.85
Maximum44
Range43
Interquartile range (IQR)21.5

Descriptive statistics

Standard deviation12.845233
Coefficient of variation (CV)0.57089923
Kurtosis-1.2
Mean22.5
Median Absolute Deviation (MAD)11
Skewness0
Sum990
Variance165
MonotonicityStrictly increasing
2024-03-13T15:05:20.983639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
1 1
 
2.3%
24 1
 
2.3%
26 1
 
2.3%
27 1
 
2.3%
28 1
 
2.3%
29 1
 
2.3%
30 1
 
2.3%
31 1
 
2.3%
32 1
 
2.3%
33 1
 
2.3%
Other values (34) 34
77.3%
ValueCountFrequency (%)
1 1
2.3%
2 1
2.3%
3 1
2.3%
4 1
2.3%
5 1
2.3%
6 1
2.3%
7 1
2.3%
8 1
2.3%
9 1
2.3%
10 1
2.3%
ValueCountFrequency (%)
44 1
2.3%
43 1
2.3%
42 1
2.3%
41 1
2.3%
40 1
2.3%
39 1
2.3%
38 1
2.3%
37 1
2.3%
36 1
2.3%
35 1
2.3%

영업소명
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2024-03-13T15:05:21.180685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length6.4545455
Min length3

Characters and Unicode

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

Unique44 ?
Unique (%)100.0%

Sample

1st row대한바이오
2nd row주식회사드림팜
3rd row제이에스파마
4th row드림팜
5th row주식회사 의지약품
ValueCountFrequency (%)
주식회사 5
 
10.2%
대한바이오 1
 
2.0%
㈜엠에스오팜 1
 
2.0%
티씨피 1
 
2.0%
지엘팜 1
 
2.0%
제이메디팜 1
 
2.0%
알라딘팜 1
 
2.0%
주)돈돌약품 1
 
2.0%
씨엔팜 1
 
2.0%
한진가스상사 1
 
2.0%
Other values (35) 35
71.4%
2024-03-13T15:05:21.546680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
30
 
10.6%
( 24
 
8.5%
) 24
 
8.5%
19
 
6.7%
13
 
4.6%
12
 
4.2%
12
 
4.2%
7
 
2.5%
7
 
2.5%
6
 
2.1%
Other values (79) 130
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 228
80.3%
Open Punctuation 24
 
8.5%
Close Punctuation 24
 
8.5%
Space Separator 5
 
1.8%
Other Symbol 3
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
30
 
13.2%
19
 
8.3%
13
 
5.7%
12
 
5.3%
12
 
5.3%
7
 
3.1%
7
 
3.1%
6
 
2.6%
6
 
2.6%
5
 
2.2%
Other values (75) 111
48.7%
Open Punctuation
ValueCountFrequency (%)
( 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Other Symbol
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 231
81.3%
Common 53
 
18.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
30
 
13.0%
19
 
8.2%
13
 
5.6%
12
 
5.2%
12
 
5.2%
7
 
3.0%
7
 
3.0%
6
 
2.6%
6
 
2.6%
5
 
2.2%
Other values (76) 114
49.4%
Common
ValueCountFrequency (%)
( 24
45.3%
) 24
45.3%
5
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 228
80.3%
ASCII 53
 
18.7%
None 3
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
30
 
13.2%
19
 
8.3%
13
 
5.7%
12
 
5.3%
12
 
5.3%
7
 
3.1%
7
 
3.1%
6
 
2.6%
6
 
2.6%
5
 
2.2%
Other values (75) 111
48.7%
ASCII
ValueCountFrequency (%)
( 24
45.3%
) 24
45.3%
5
 
9.4%
None
ValueCountFrequency (%)
3
100.0%
Distinct43
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size484.0 B
2024-03-13T15:05:21.805902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length37
Mean length33.181818
Min length22

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)95.5%

Sample

1st row인천광역시 계양구 만봉길 86, 성도빌딩 1층 일부호 (귤현동)
2nd row인천광역시 계양구 향교로 22, 1층 일부호 (계산동)
3rd row인천광역시 계양구 경명대로 1037, 2층 일부호 (계산동)
4th row인천광역시 계양구 임학안로28번길 16, 2층 2호 (임학동)
5th row인천광역시 계양구 벌말로573번길 4, 306호 (상야동)
ValueCountFrequency (%)
인천광역시 44
 
15.2%
계양구 44
 
15.2%
3층 14
 
4.8%
상야동 11
 
3.8%
계산동 7
 
2.4%
일부호 6
 
2.1%
효성동 6
 
2.1%
작전동 6
 
2.1%
4 6
 
2.1%
장제로 6
 
2.1%
Other values (93) 139
48.1%
2024-03-13T15:05:22.201231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
245
 
16.8%
52
 
3.6%
45
 
3.1%
45
 
3.1%
45
 
3.1%
44
 
3.0%
) 44
 
3.0%
44
 
3.0%
( 44
 
3.0%
44
 
3.0%
Other values (103) 808
55.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 831
56.9%
Space Separator 245
 
16.8%
Decimal Number 244
 
16.7%
Close Punctuation 44
 
3.0%
Open Punctuation 44
 
3.0%
Other Punctuation 40
 
2.7%
Dash Punctuation 11
 
0.8%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
52
 
6.3%
45
 
5.4%
45
 
5.4%
45
 
5.4%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
42
 
5.1%
Other values (87) 382
46.0%
Decimal Number
ValueCountFrequency (%)
3 41
16.8%
5 35
14.3%
1 30
12.3%
7 27
11.1%
2 25
10.2%
0 22
9.0%
6 19
7.8%
4 18
7.4%
8 14
 
5.7%
9 13
 
5.3%
Space Separator
ValueCountFrequency (%)
245
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%
Other Punctuation
ValueCountFrequency (%)
, 40
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 831
56.9%
Common 629
43.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
52
 
6.3%
45
 
5.4%
45
 
5.4%
45
 
5.4%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
42
 
5.1%
Other values (87) 382
46.0%
Common
ValueCountFrequency (%)
245
39.0%
) 44
 
7.0%
( 44
 
7.0%
3 41
 
6.5%
, 40
 
6.4%
5 35
 
5.6%
1 30
 
4.8%
7 27
 
4.3%
2 25
 
4.0%
0 22
 
3.5%
Other values (6) 76
 
12.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 831
56.9%
ASCII 629
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
245
39.0%
) 44
 
7.0%
( 44
 
7.0%
3 41
 
6.5%
, 40
 
6.4%
5 35
 
5.6%
1 30
 
4.8%
7 27
 
4.3%
2 25
 
4.0%
0 22
 
3.5%
Other values (6) 76
 
12.1%
Hangul
ValueCountFrequency (%)
52
 
6.3%
45
 
5.4%
45
 
5.4%
45
 
5.4%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
44
 
5.3%
42
 
5.1%
Other values (87) 382
46.0%

영업소전화번호
Text

MISSING 

Distinct33
Distinct (%)100.0%
Missing11
Missing (%)25.0%
Memory size484.0 B
2024-03-13T15:05:22.402416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12
Min length11

Characters and Unicode

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

Unique33 ?
Unique (%)100.0%

Sample

1st row032-212-9581
2nd row032-551-2112
3rd row032-543-5590
4th row031-872-8283
5th row032-555-1564
ValueCountFrequency (%)
032-555-1929 1
 
3.0%
02-6404-0020 1
 
3.0%
032-526-7001 1
 
3.0%
032-556-2740 1
 
3.0%
032-548-8388 1
 
3.0%
070-7542-5391 1
 
3.0%
032-556-0000 1
 
3.0%
032-815-9022 1
 
3.0%
032-556-9714 1
 
3.0%
032-212-9581 1
 
3.0%
Other values (23) 23
69.7%
2024-03-13T15:05:22.786573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 66
16.7%
5 65
16.4%
0 55
13.9%
2 52
13.1%
3 48
12.1%
1 26
 
6.6%
4 23
 
5.8%
7 18
 
4.5%
8 18
 
4.5%
6 17
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 330
83.3%
Dash Punctuation 66
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 65
19.7%
0 55
16.7%
2 52
15.8%
3 48
14.5%
1 26
 
7.9%
4 23
 
7.0%
7 18
 
5.5%
8 18
 
5.5%
6 17
 
5.2%
9 8
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 396
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 66
16.7%
5 65
16.4%
0 55
13.9%
2 52
13.1%
3 48
12.1%
1 26
 
6.6%
4 23
 
5.8%
7 18
 
4.5%
8 18
 
4.5%
6 17
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 396
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 66
16.7%
5 65
16.4%
0 55
13.9%
2 52
13.1%
3 48
12.1%
1 26
 
6.6%
4 23
 
5.8%
7 18
 
4.5%
8 18
 
4.5%
6 17
 
4.3%

Interactions

2024-03-13T15:05:20.568668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T15:05:22.875282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소명영업소소재지(도로명)영업소전화번호
순번1.0001.0000.9151.000
영업소명1.0001.0001.0001.000
영업소소재지(도로명)0.9151.0001.0001.000
영업소전화번호1.0001.0001.0001.000

Missing values

2024-03-13T15:05:20.664078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T15:05:20.747406image/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대한바이오인천광역시 계양구 만봉길 86, 성도빌딩 1층 일부호 (귤현동)<NA>
12주식회사드림팜인천광역시 계양구 향교로 22, 1층 일부호 (계산동)<NA>
23제이에스파마인천광역시 계양구 경명대로 1037, 2층 일부호 (계산동)032-212-9581
34드림팜인천광역시 계양구 임학안로28번길 16, 2층 2호 (임학동)<NA>
45주식회사 의지약품인천광역시 계양구 벌말로573번길 4, 306호 (상야동)032-551-2112
56주식회사 비알에스팜인천광역시 계양구 벌말로573번길 4, 3층 308호 (상야동)032-543-5590
67(주)디디팜인천광역시 계양구 장기로 27, 3층 (장기동)<NA>
78비원팜인천광역시 계양구 아나지로374번길 5, 2층 (작전동)<NA>
89주식회사 송석팜인천광역시 계양구 계산새로87번길 6, 레드몰 404호 (용종동)031-872-8283
910(주)인천파마인천광역시 계양구 서운산업로47번길 17-4, 3층 (서운동)<NA>
순번영업소명영업소소재지(도로명)영업소전화번호
3435(주)조은약품인천광역시 계양구 경명대로 1102, 5층 (계산동)032-815-9022
3536(주)나래팜인천광역시 계양구 장제로946번길 32 (병방동)032-555-5454
3637(주)한창약품인천광역시 계양구 벌말로565번길 15-9, 3층 (상야동)032-556-9714
3738(주)케이비팜인천광역시 계양구 벌말로573번길 4, 3층 (상야동)032-324-4664
3839고강제약유통인천광역시 계양구 선주로 48-13 (선주지동)032-548-2411
3940㈜태길약품인천광역시 계양구 오조산로7번길 4, 성우프라자 7층 (작전동)032-547-5050
4041희망약품(주)인천광역시 계양구 양지로 132, 희망빌딩 2층 전체호 (귤현동)032-465-7323
4142㈜한디인천광역시 계양구 주부토로561번길 5-6, 1~2층 (계산동)032-868-8055
4243(주)성도약품인천광역시 계양구 만봉길 86 (귤현동)032-512-8120
4344(주)한국다이이찌산쿄인천광역시 계양구 마장로 537 (효성동)032-556-3308