Overview

Dataset statistics

Number of variables4
Number of observations126
Missing cells14
Missing cells (%)2.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory34.0 B

Variable types

Numeric1
Text3

Dataset

Description인천광역시 연수구 내 등록된 약국 현황에 대한 데이터로 악국명칭, 소재지(도로명), 전화번호 등의 항목을알려 드립니다.
Author인천광역시 연수구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15053181&srcSe=7661IVAWM27C61E190

Alerts

약국전화번호 has 14 (11.1%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 14:11:03.632000
Analysis finished2024-01-28 14:11:04.050580
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct126
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean63.5
Minimum1
Maximum126
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-01-28T23:11:04.108788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.25
Q132.25
median63.5
Q394.75
95-th percentile119.75
Maximum126
Range125
Interquartile range (IQR)62.5

Descriptive statistics

Standard deviation36.517119
Coefficient of variation (CV)0.57507274
Kurtosis-1.2
Mean63.5
Median Absolute Deviation (MAD)31.5
Skewness0
Sum8001
Variance1333.5
MonotonicityStrictly increasing
2024-01-28T23:11:04.233043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
81 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
87 1
 
0.8%
Other values (116) 116
92.1%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%
117 1
0.8%

약국명칭
Text

Distinct124
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-28T23:11:04.443322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length5.5555556
Min length3

Characters and Unicode

Total characters700
Distinct characters161
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique122 ?
Unique (%)96.8%

Sample

1st row든든약국
2nd row송도봄약국
3rd row예쁜나무약국
4th row치유약국
5th row솔로몬약국
ValueCountFrequency (%)
팜프라자 2
 
1.6%
송도온누리약국 2
 
1.6%
연수제일약국 2
 
1.6%
정명약국 1
 
0.8%
중앙약국 1
 
0.8%
미래팜약국 1
 
0.8%
건강나라약국 1
 
0.8%
센타약국 1
 
0.8%
푸른약국 1
 
0.8%
헬스원약국 1
 
0.8%
Other values (115) 115
89.8%
2024-01-28T23:11:04.764522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 126
 
18.0%
국 126
 
18.0%
도 26
 
3.7%
송 25
 
3.6%
리 19
 
2.7%
온 15
 
2.1%
누 15
 
2.1%
수 13
 
1.9%
연 10
 
1.4%
스 10
 
1.4%
Other values (151) 315
45.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 682
97.4%
Decimal Number 8
 
1.1%
Lowercase Letter 6
 
0.9%
Space Separator 2
 
0.3%
Uppercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 126
18.5%
국 126
18.5%
도 26
 
3.8%
송 25
 
3.7%
리 19
 
2.8%
온 15
 
2.2%
누 15
 
2.2%
수 13
 
1.9%
연 10
 
1.5%
스 10
 
1.5%
Other values (138) 297
43.5%
Lowercase Letter
ValueCountFrequency (%)
l 2
33.3%
a 1
16.7%
b 1
16.7%
o 1
16.7%
g 1
16.7%
Decimal Number
ValueCountFrequency (%)
5 2
25.0%
6 2
25.0%
3 2
25.0%
2 1
12.5%
1 1
12.5%
Uppercase Letter
ValueCountFrequency (%)
S 1
50.0%
B 1
50.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 682
97.4%
Common 10
 
1.4%
Latin 8
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 126
18.5%
국 126
18.5%
도 26
 
3.8%
송 25
 
3.7%
리 19
 
2.8%
온 15
 
2.2%
누 15
 
2.2%
수 13
 
1.9%
연 10
 
1.5%
스 10
 
1.5%
Other values (138) 297
43.5%
Latin
ValueCountFrequency (%)
l 2
25.0%
a 1
12.5%
b 1
12.5%
S 1
12.5%
o 1
12.5%
g 1
12.5%
B 1
12.5%
Common
ValueCountFrequency (%)
2
20.0%
5 2
20.0%
6 2
20.0%
3 2
20.0%
2 1
10.0%
1 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 682
97.4%
ASCII 18
 
2.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 126
18.5%
국 126
18.5%
도 26
 
3.8%
송 25
 
3.7%
리 19
 
2.8%
온 15
 
2.2%
누 15
 
2.2%
수 13
 
1.9%
연 10
 
1.5%
스 10
 
1.5%
Other values (138) 297
43.5%
ASCII
ValueCountFrequency (%)
l 2
11.1%
2
11.1%
5 2
11.1%
6 2
11.1%
3 2
11.1%
a 1
 
5.6%
b 1
 
5.6%
S 1
 
5.6%
2 1
 
5.6%
o 1
 
5.6%
Other values (3) 3
16.7%

약국전화번호
Text

MISSING 

Distinct110
Distinct (%)98.2%
Missing14
Missing (%)11.1%
Memory size1.1 KiB
2024-01-28T23:11:04.952275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.017857
Min length8

Characters and Unicode

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

Unique108 ?
Unique (%)96.4%

Sample

1st row032-832-6482
2nd row032-851-8835
3rd row032-822-3360
4th row070-4126-9715
5th row032-833-7599
ValueCountFrequency (%)
032-822-3138 2
 
1.8%
032-833-6606 2
 
1.8%
032-831-8318 1
 
0.9%
032-812-8465 1
 
0.9%
032-832-6482 1
 
0.9%
032-818-7010 1
 
0.9%
032-858-7792 1
 
0.9%
032-833-4557 1
 
0.9%
032-813-1398 1
 
0.9%
032-814-1345 1
 
0.9%
Other values (100) 100
89.3%
2024-01-28T23:11:05.240563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 223
16.6%
3 195
14.5%
2 181
13.4%
0 178
13.2%
8 170
12.6%
1 122
9.1%
5 71
 
5.3%
7 66
 
4.9%
4 53
 
3.9%
9 44
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1123
83.4%
Dash Punctuation 223
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 195
17.4%
2 181
16.1%
0 178
15.9%
8 170
15.1%
1 122
10.9%
5 71
 
6.3%
7 66
 
5.9%
4 53
 
4.7%
9 44
 
3.9%
6 43
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 223
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1346
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 223
16.6%
3 195
14.5%
2 181
13.4%
0 178
13.2%
8 170
12.6%
1 122
9.1%
5 71
 
5.3%
7 66
 
4.9%
4 53
 
3.9%
9 44
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1346
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 223
16.6%
3 195
14.5%
2 181
13.4%
0 178
13.2%
8 170
12.6%
1 122
9.1%
5 71
 
5.3%
7 66
 
4.9%
4 53
 
3.9%
9 44
 
3.3%

약국소재지(도로명)
Text

Distinct124
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-01-28T23:11:05.458133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length45
Mean length38.333333
Min length22

Characters and Unicode

Total characters4830
Distinct characters232
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique122 ?
Unique (%)96.8%

Sample

1st row인천광역시 연수구 독배로40번길 21, 유한빌딩 1층 102호 (옥련동)
2nd row인천광역시 연수구 해돋이로 161, 세종프라자 106호 (송도동)
3rd row인천광역시 연수구 랜드마크로 20, 상가동 215호 (송도동, 호반써밋 송도)
4th row인천광역시 연수구 아트센터대로168번길 100, 한라 웨스턴파크 송도 152호 (송도동)
5th row인천광역시 연수구 용담로 153, 대동월드스포츠센터 2층 201호 일부, 201-1호 (연수동)
ValueCountFrequency (%)
인천광역시 126
 
14.1%
연수구 126
 
14.1%
송도동 58
 
6.5%
연수동 23
 
2.6%
1층 23
 
2.6%
동춘동 19
 
2.1%
옥련동 11
 
1.2%
원인재로 9
 
1.0%
청학동 9
 
1.0%
해돋이로 8
 
0.9%
Other values (318) 481
53.9%
2024-01-28T23:11:05.789292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
767
 
15.9%
1 268
 
5.5%
, 179
 
3.7%
동 165
 
3.4%
연 151
 
3.1%
수 151
 
3.1%
시 145
 
3.0%
인 141
 
2.9%
로 131
 
2.7%
천 129
 
2.7%
Other values (222) 2603
53.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2764
57.2%
Decimal Number 813
 
16.8%
Space Separator 767
 
15.9%
Other Punctuation 181
 
3.7%
Close Punctuation 128
 
2.7%
Open Punctuation 128
 
2.7%
Uppercase Letter 32
 
0.7%
Dash Punctuation 15
 
0.3%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 165
 
6.0%
연 151
 
5.5%
수 151
 
5.5%
시 145
 
5.2%
인 141
 
5.1%
로 131
 
4.7%
천 129
 
4.7%
구 126
 
4.6%
역 126
 
4.6%
광 126
 
4.6%
Other values (190) 1373
49.7%
Uppercase Letter
ValueCountFrequency (%)
A 10
31.2%
B 4
 
12.5%
C 3
 
9.4%
E 3
 
9.4%
Y 2
 
6.2%
R 2
 
6.2%
W 1
 
3.1%
D 1
 
3.1%
H 1
 
3.1%
N 1
 
3.1%
Other values (4) 4
 
12.5%
Decimal Number
ValueCountFrequency (%)
1 268
33.0%
2 111
13.7%
0 108
13.3%
4 62
 
7.6%
3 57
 
7.0%
5 56
 
6.9%
6 53
 
6.5%
8 49
 
6.0%
7 32
 
3.9%
9 17
 
2.1%
Other Punctuation
ValueCountFrequency (%)
, 179
98.9%
@ 1
 
0.6%
? 1
 
0.6%
Space Separator
ValueCountFrequency (%)
767
100.0%
Close Punctuation
ValueCountFrequency (%)
) 128
100.0%
Open Punctuation
ValueCountFrequency (%)
( 128
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2764
57.2%
Common 2034
42.1%
Latin 32
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 165
 
6.0%
연 151
 
5.5%
수 151
 
5.5%
시 145
 
5.2%
인 141
 
5.1%
로 131
 
4.7%
천 129
 
4.7%
구 126
 
4.6%
역 126
 
4.6%
광 126
 
4.6%
Other values (190) 1373
49.7%
Common
ValueCountFrequency (%)
767
37.7%
1 268
 
13.2%
, 179
 
8.8%
) 128
 
6.3%
( 128
 
6.3%
2 111
 
5.5%
0 108
 
5.3%
4 62
 
3.0%
3 57
 
2.8%
5 56
 
2.8%
Other values (8) 170
 
8.4%
Latin
ValueCountFrequency (%)
A 10
31.2%
B 4
 
12.5%
C 3
 
9.4%
E 3
 
9.4%
Y 2
 
6.2%
R 2
 
6.2%
W 1
 
3.1%
D 1
 
3.1%
H 1
 
3.1%
N 1
 
3.1%
Other values (4) 4
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2764
57.2%
ASCII 2066
42.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
767
37.1%
1 268
 
13.0%
, 179
 
8.7%
) 128
 
6.2%
( 128
 
6.2%
2 111
 
5.4%
0 108
 
5.2%
4 62
 
3.0%
3 57
 
2.8%
5 56
 
2.7%
Other values (22) 202
 
9.8%
Hangul
ValueCountFrequency (%)
동 165
 
6.0%
연 151
 
5.5%
수 151
 
5.5%
시 145
 
5.2%
인 141
 
5.1%
로 131
 
4.7%
천 129
 
4.7%
구 126
 
4.6%
역 126
 
4.6%
광 126
 
4.6%
Other values (190) 1373
49.7%

Interactions

2024-01-28T23:11:03.861704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-01-28T23:11:03.960735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T23:11:04.024568image/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든든약국032-832-6482인천광역시 연수구 독배로40번길 21, 유한빌딩 1층 102호 (옥련동)
12송도봄약국032-851-8835인천광역시 연수구 해돋이로 161, 세종프라자 106호 (송도동)
23예쁜나무약국<NA>인천광역시 연수구 랜드마크로 20, 상가동 215호 (송도동, 호반써밋 송도)
34치유약국<NA>인천광역시 연수구 아트센터대로168번길 100, 한라 웨스턴파크 송도 152호 (송도동)
45솔로몬약국032-822-3360인천광역시 연수구 용담로 153, 대동월드스포츠센터 2층 201호 일부, 201-1호 (연수동)
562층약국<NA>인천광역시 연수구 아트센터대로168번길 101, 송도랜드마크푸르지오시티 251호 (송도동)
67한마음약국070-4126-9715인천광역시 연수구 송도문화로28번길 28, 203동 208호 (송도동, 송도글로벌캠퍼스푸르지오)
78수약국<NA>인천광역시 연수구 센트럴로 232, E동 1층 172호 (송도동, 더샵센트럴파크1)
89S메디칼약국032-833-7599인천광역시 연수구 하모니로178번길 6, 121,122,123호 (송도동)
910송도이레약국<NA>인천광역시 연수구 해돋이로172번길 42, 103호 (송도동)
순번약국명칭약국전화번호약국소재지(도로명)
116117누리약국032-818-0591인천광역시 연수구 원인재로 14, 101호 (동춘동, 무지개상가)
117118최현수약국032-814-1333인천광역시 연수구 비류대로 429 (연수동)
118119둥지온누리약국032-818-5549인천광역시 연수구 함박뫼로 26 (청학동)
119120보건약국032-811-8755인천광역시 연수구 원인재로 216, 연수1차,승기마을,원인재마을 115호 (연수동)
120121강봉윤약국032-811-2023인천광역시 연수구 원인재로 315, 110호 (연수동, 주공1단지상가)
121122화랑약국032-813-0282인천광역시 연수구 원인재로 312, 104호 (연수동, 경남아파트상가)
122123효성메디칼약국032-811-7997인천광역시 연수구 청능대로 93, 102호 (청학동, 두손빌딩)
123124자애약국032-812-1019인천광역시 연수구 원인재로 315, 106호 (연수동, 주공임대상가)
124125동인천약국032-814-4101인천광역시 연수구 선학로 101, 104호 (선학동, 뉴서울상가)
125126대산프라자약국032-816-4531인천광역시 연수구 앵고개로246번길 10, 107,108호 (동춘동)