Overview

Dataset statistics

Number of variables5
Number of observations26
Missing cells6
Missing cells (%)4.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory46.1 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description인천광역시 서구 관내에 위치한 의약품도매상 현황(영업소명, 소재지, 전화번호)에 대한 정보를 담은 데이터 파일입니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15068801&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
영업소전화번호 has 6 (23.1%) missing valuesMissing
연번 has unique valuesUnique
영업소명 has unique valuesUnique
영업소소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-01-28 16:08:54.540197
Analysis finished2024-01-28 16:08:54.924531
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.5
Minimum1
Maximum26
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2024-01-29T01:08:54.972705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.25
Q17.25
median13.5
Q319.75
95-th percentile24.75
Maximum26
Range25
Interquartile range (IQR)12.5

Descriptive statistics

Standard deviation7.6485293
Coefficient of variation (CV)0.56655772
Kurtosis-1.2
Mean13.5
Median Absolute Deviation (MAD)6.5
Skewness0
Sum351
Variance58.5
MonotonicityStrictly increasing
2024-01-29T01:08:55.295597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1 1
 
3.8%
15 1
 
3.8%
26 1
 
3.8%
25 1
 
3.8%
24 1
 
3.8%
23 1
 
3.8%
22 1
 
3.8%
21 1
 
3.8%
20 1
 
3.8%
19 1
 
3.8%
Other values (16) 16
61.5%
ValueCountFrequency (%)
1 1
3.8%
2 1
3.8%
3 1
3.8%
4 1
3.8%
5 1
3.8%
6 1
3.8%
7 1
3.8%
8 1
3.8%
9 1
3.8%
10 1
3.8%
ValueCountFrequency (%)
26 1
3.8%
25 1
3.8%
24 1
3.8%
23 1
3.8%
22 1
3.8%
21 1
3.8%
20 1
3.8%
19 1
3.8%
18 1
3.8%
17 1
3.8%

영업소명
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2024-01-29T01:08:55.452106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length9
Mean length7.2692308
Min length2

Characters and Unicode

Total characters189
Distinct characters77
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

Unique26 ?
Unique (%)100.0%

Sample

1st row(주)우성메디코스
2nd row(주)비엔씨글로벌
3rd row우진관리(주)
4th row톡톡팜
5th row주식회사 위즈팜
ValueCountFrequency (%)
주식회사 3
 
9.7%
인천지점 2
 
6.5%
주)우성메디코스 1
 
3.2%
인우특수가스 1
 
3.2%
주)종수약품 1
 
3.2%
주)웰팜 1
 
3.2%
다린 1
 
3.2%
에스더블유헬스케어 1
 
3.2%
영종종합가스 1
 
3.2%
아진산업가스(주 1
 
3.2%
Other values (18) 18
58.1%
2024-01-29T01:08:55.733905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 15
 
7.9%
( 13
 
6.9%
) 13
 
6.9%
스 6
 
3.2%
5
 
2.6%
약 5
 
2.6%
품 5
 
2.6%
회 5
 
2.6%
사 5
 
2.6%
디 5
 
2.6%
Other values (67) 112
59.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 158
83.6%
Open Punctuation 13
 
6.9%
Close Punctuation 13
 
6.9%
Space Separator 5
 
2.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 15
 
9.5%
스 6
 
3.8%
약 5
 
3.2%
품 5
 
3.2%
회 5
 
3.2%
사 5
 
3.2%
디 5
 
3.2%
메 5
 
3.2%
인 4
 
2.5%
팜 4
 
2.5%
Other values (64) 99
62.7%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 158
83.6%
Common 31
 
16.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 15
 
9.5%
스 6
 
3.8%
약 5
 
3.2%
품 5
 
3.2%
회 5
 
3.2%
사 5
 
3.2%
디 5
 
3.2%
메 5
 
3.2%
인 4
 
2.5%
팜 4
 
2.5%
Other values (64) 99
62.7%
Common
ValueCountFrequency (%)
( 13
41.9%
) 13
41.9%
5
 
16.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 158
83.6%
ASCII 31
 
16.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 15
 
9.5%
스 6
 
3.8%
약 5
 
3.2%
품 5
 
3.2%
회 5
 
3.2%
사 5
 
3.2%
디 5
 
3.2%
메 5
 
3.2%
인 4
 
2.5%
팜 4
 
2.5%
Other values (64) 99
62.7%
ASCII
ValueCountFrequency (%)
( 13
41.9%
) 13
41.9%
5
 
16.1%

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

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2024-01-29T01:08:55.948587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length42
Mean length36.038462
Min length23

Characters and Unicode

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

Unique26 ?
Unique (%)100.0%

Sample

1st row인천광역시 서구 청라대로 127, 리베라움 더레이크 208,209호 (청라동)
2nd row인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 201호 (오류동)
3rd row인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 213호 (오류동)
4th row인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 203호 (오류동)
5th row인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 214호 (오류동)
ValueCountFrequency (%)
인천광역시 26
 
13.9%
서구 26
 
13.9%
오류동 9
 
4.8%
2층 8
 
4.3%
정서진4로 8
 
4.3%
10 8
 
4.3%
주)웰팜 8
 
4.3%
인천물류센터 8
 
4.3%
가좌동 6
 
3.2%
석남동 4
 
2.1%
Other values (66) 76
40.6%
2024-01-29T01:08:56.270337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
161
 
17.2%
( 37
 
3.9%
) 37
 
3.9%
서 35
 
3.7%
인 34
 
3.6%
천 34
 
3.6%
1 31
 
3.3%
0 28
 
3.0%
동 28
 
3.0%
, 27
 
2.9%
Other values (84) 485
51.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 509
54.3%
Space Separator 161
 
17.2%
Decimal Number 159
 
17.0%
Open Punctuation 37
 
3.9%
Close Punctuation 37
 
3.9%
Other Punctuation 27
 
2.9%
Dash Punctuation 5
 
0.5%
Uppercase Letter 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 35
 
6.9%
인 34
 
6.7%
천 34
 
6.7%
동 28
 
5.5%
로 26
 
5.1%
구 26
 
5.1%
시 26
 
5.1%
광 26
 
5.1%
역 26
 
5.1%
류 18
 
3.5%
Other values (67) 230
45.2%
Decimal Number
ValueCountFrequency (%)
1 31
19.5%
0 28
17.6%
2 26
16.4%
3 20
12.6%
4 17
10.7%
5 9
 
5.7%
9 8
 
5.0%
6 8
 
5.0%
8 7
 
4.4%
7 5
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
T 1
50.0%
Space Separator
ValueCountFrequency (%)
161
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 37
100.0%
Other Punctuation
ValueCountFrequency (%)
, 27
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 509
54.3%
Common 426
45.5%
Latin 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 35
 
6.9%
인 34
 
6.7%
천 34
 
6.7%
동 28
 
5.5%
로 26
 
5.1%
구 26
 
5.1%
시 26
 
5.1%
광 26
 
5.1%
역 26
 
5.1%
류 18
 
3.5%
Other values (67) 230
45.2%
Common
ValueCountFrequency (%)
161
37.8%
( 37
 
8.7%
) 37
 
8.7%
1 31
 
7.3%
0 28
 
6.6%
, 27
 
6.3%
2 26
 
6.1%
3 20
 
4.7%
4 17
 
4.0%
5 9
 
2.1%
Other values (5) 33
 
7.7%
Latin
ValueCountFrequency (%)
B 1
50.0%
T 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 509
54.3%
ASCII 428
45.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
161
37.6%
( 37
 
8.6%
) 37
 
8.6%
1 31
 
7.2%
0 28
 
6.5%
, 27
 
6.3%
2 26
 
6.1%
3 20
 
4.7%
4 17
 
4.0%
5 9
 
2.1%
Other values (7) 35
 
8.2%
Hangul
ValueCountFrequency (%)
서 35
 
6.9%
인 34
 
6.7%
천 34
 
6.7%
동 28
 
5.5%
로 26
 
5.1%
구 26
 
5.1%
시 26
 
5.1%
광 26
 
5.1%
역 26
 
5.1%
류 18
 
3.5%
Other values (67) 230
45.2%

영업소전화번호
Text

MISSING 

Distinct20
Distinct (%)100.0%
Missing6
Missing (%)23.1%
Memory size340.0 B
2024-01-29T01:08:56.438755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length10.65
Min length8

Characters and Unicode

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

Unique20 ?
Unique (%)100.0%

Sample

1st row032-822-9958
2nd row02-938-3305
3rd row032-565-3735
4th row032-435-8857
5th row032-662-7588
ValueCountFrequency (%)
032-822-9958 1
 
5.0%
02-938-3305 1
 
5.0%
581-8788 1
 
5.0%
032-657-9322 1
 
5.0%
575-6684 1
 
5.0%
032-575-0346 1
 
5.0%
578-5556 1
 
5.0%
578-8884 1
 
5.0%
568-1451 1
 
5.0%
575-4747 1
 
5.0%
Other values (10) 10
50.0%
2024-01-29T01:08:56.697350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 33
15.5%
5 31
14.6%
3 28
13.1%
8 23
10.8%
2 22
10.3%
0 21
9.9%
7 16
7.5%
4 14
6.6%
6 12
 
5.6%
9 6
 
2.8%
Other values (2) 7
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 179
84.0%
Dash Punctuation 33
 
15.5%
Math Symbol 1
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 31
17.3%
3 28
15.6%
8 23
12.8%
2 22
12.3%
0 21
11.7%
7 16
8.9%
4 14
7.8%
6 12
 
6.7%
9 6
 
3.4%
1 6
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 33
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 213
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 33
15.5%
5 31
14.6%
3 28
13.1%
8 23
10.8%
2 22
10.3%
0 21
9.9%
7 16
7.5%
4 14
6.6%
6 12
 
5.6%
9 6
 
2.8%
Other values (2) 7
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 213
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 33
15.5%
5 31
14.6%
3 28
13.1%
8 23
10.8%
2 22
10.3%
0 21
9.9%
7 16
7.5%
4 14
6.6%
6 12
 
5.6%
9 6
 
2.8%
Other values (2) 7
 
3.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-10-19
26 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-19
2nd row2023-10-19
3rd row2023-10-19
4th row2023-10-19
5th row2023-10-19

Common Values

ValueCountFrequency (%)
2023-10-19 26
100.0%

Length

2024-01-29T01:08:56.800980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-29T01:08:56.874018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-19 26
100.0%

Interactions

2024-01-29T01:08:54.734705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-29T01:08:56.923425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번영업소명영업소소재지(도로명)영업소전화번호
연번1.0001.0001.0001.000
영업소명1.0001.0001.0001.000
영업소소재지(도로명)1.0001.0001.0001.000
영업소전화번호1.0001.0001.0001.000

Missing values

2024-01-29T01:08:54.820889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-29T01:08:54.892484image/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(주)우성메디코스인천광역시 서구 청라대로 127, 리베라움 더레이크 208,209호 (청라동)<NA>2023-10-19
12(주)비엔씨글로벌인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 201호 (오류동)032-822-99582023-10-19
23우진관리(주)인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 213호 (오류동)02-938-33052023-10-19
34톡톡팜인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 203호 (오류동)<NA>2023-10-19
45주식회사 위즈팜인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 214호 (오류동)032-565-37352023-10-19
56부천약품인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 206호 (오류동)<NA>2023-10-19
67(사)한국근로장애인진흥회인천광역시 서구 원당대로608번안길 15, 4층 (당하동)032-435-88572023-10-19
78한경팜인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 205호 (오류동)<NA>2023-10-19
89유정약품인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 2층 204호 (오류동)032-662-75882023-10-19
910마켄코리아유한회사 인천지점인천광역시 서구 갑문3로 37, 티제이물류센터 관리동 2(일부)층 (오류동)032-724-92432023-10-19
연번영업소명영업소소재지(도로명)영업소전화번호데이터기준일자
1617맘메디칼인천광역시 서구 백범로934번길 30-12, 3층 (가좌동)032-554-18882023-10-19
1718이화산소(주)인천광역시 서구 가정로58번길 32 (가좌동, 이화산소(주))575-47472023-10-19
1819선도산업(주)인천광역시 서구 사렴로65번길 42 (경서동)568-14512023-10-19
1920아진산업가스(주)인천광역시 서구 봉수대로300번길 42 (석남동)578-88842023-10-19
2021영종종합가스인천광역시 서구 방축로 359 (가좌동, 영종가스)578-55562023-10-19
2122주식회사 에스더블유헬스케어인천광역시 서구 가재울로 109, B106(일부)호 (가좌동)032-575-03462023-10-19
2223다린인천광역시 서구 원적로47번길 6 (가좌동)575-66842023-10-19
2324(주)웰팜인천광역시 서구 정서진4로 10, (주)웰팜 인천물류센터 1, 3, 4층 (오류동)032-657-93222023-10-19
2425(주)종수약품인천광역시 서구 신진말로 37-1, 6층 (가좌동)581-87882023-10-19
2526화덕약품(주)인천광역시 서구 길주로 69-1 (석남동)582-44352023-10-19