Overview

Dataset statistics

Number of variables6
Number of observations23
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory55.7 B

Variable types

Text4
Numeric2

Dataset

Description경기도 연천군에 있는 약국현황을 공개하여 약품이 필요한 일반인 및 환자들에게 편의 제공하기 위한 항목(약국명, 도로명주소, 지번주소, 위도, 경도, 전화번호)을 제공합니다.
Author경기도 연천군
URLhttps://www.data.go.kr/data/15017184/fileData.do

Alerts

약국명 has unique valuesUnique
도로명주소 has unique valuesUnique
지번주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:51:45.295669
Analysis finished2023-12-12 22:51:46.052010
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-13T07:51:46.182045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length4
Mean length4.5217391
Min length3

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row우리약국
2nd row참사랑약국
3rd row연천약국
4th row코리아약국
5th row백학종점약국
ValueCountFrequency (%)
우리약국 1
 
4.2%
참사랑약국 1
 
4.2%
여름약국 1
 
4.2%
행운약국 1
 
4.2%
광신약국 1
 
4.2%
럭키약국 1
 
4.2%
보경약국 1
 
4.2%
중앙약국 1
 
4.2%
유약국 1
 
4.2%
태양약국 1
 
4.2%
Other values (14) 14
58.3%
2023-12-13T07:51:46.485347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
23
22.1%
23
22.1%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
1
 
1.0%
1
 
1.0%
Other values (44) 44
42.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 103
99.0%
Space Separator 1
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
23
22.3%
23
22.3%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
1
 
1.0%
1
 
1.0%
Other values (43) 43
41.7%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 103
99.0%
Common 1
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
23
22.3%
23
22.3%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
1
 
1.0%
1
 
1.0%
Other values (43) 43
41.7%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 103
99.0%
ASCII 1
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
23
22.3%
23
22.3%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
2
 
1.9%
1
 
1.0%
1
 
1.0%
Other values (43) 43
41.7%
ASCII
ValueCountFrequency (%)
1
100.0%

도로명주소
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-13T07:51:46.662157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length19.304348
Min length17

Characters and Unicode

Total characters444
Distinct characters40
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

Unique23 ?
Unique (%)100.0%

Sample

1st row경기도 연천군 전곡읍 온골로 36
2nd row경기도 연천군 연천읍 연천로 264-1
3rd row경기도 연천군 연천읍 연천로 277
4th row경기도 연천군 전곡읍 전곡로167번길 4
5th row경기도 연천군 백학면 두백로 33
ValueCountFrequency (%)
경기도 23
20.4%
연천군 23
20.4%
전곡읍 15
13.3%
전곡로 7
 
6.2%
온골로 4
 
3.5%
연천읍 4
 
3.5%
연천로 2
 
1.8%
청산면 2
 
1.8%
음터길 1
 
0.9%
69 1
 
0.9%
Other values (31) 31
27.4%
2023-12-13T07:51:46.972138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
90
20.3%
30
 
6.8%
30
 
6.8%
25
 
5.6%
25
 
5.6%
25
 
5.6%
23
 
5.2%
23
 
5.2%
23
 
5.2%
22
 
5.0%
Other values (30) 128
28.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 284
64.0%
Space Separator 90
 
20.3%
Decimal Number 67
 
15.1%
Dash Punctuation 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
30
10.6%
30
10.6%
25
8.8%
25
8.8%
25
8.8%
23
8.1%
23
8.1%
23
8.1%
22
7.7%
19
6.7%
Other values (18) 39
13.7%
Decimal Number
ValueCountFrequency (%)
1 16
23.9%
6 10
14.9%
2 8
11.9%
3 7
10.4%
4 6
 
9.0%
7 6
 
9.0%
5 5
 
7.5%
8 4
 
6.0%
9 3
 
4.5%
0 2
 
3.0%
Space Separator
ValueCountFrequency (%)
90
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 284
64.0%
Common 160
36.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
30
10.6%
30
10.6%
25
8.8%
25
8.8%
25
8.8%
23
8.1%
23
8.1%
23
8.1%
22
7.7%
19
6.7%
Other values (18) 39
13.7%
Common
ValueCountFrequency (%)
90
56.2%
1 16
 
10.0%
6 10
 
6.2%
2 8
 
5.0%
3 7
 
4.4%
4 6
 
3.8%
7 6
 
3.8%
5 5
 
3.1%
8 4
 
2.5%
- 3
 
1.9%
Other values (2) 5
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 284
64.0%
ASCII 160
36.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
90
56.2%
1 16
 
10.0%
6 10
 
6.2%
2 8
 
5.0%
3 7
 
4.4%
4 6
 
3.8%
7 6
 
3.8%
5 5
 
3.1%
8 4
 
2.5%
- 3
 
1.9%
Other values (2) 5
 
3.1%
Hangul
ValueCountFrequency (%)
30
10.6%
30
10.6%
25
8.8%
25
8.8%
25
8.8%
23
8.1%
23
8.1%
23
8.1%
22
7.7%
19
6.7%
Other values (18) 39
13.7%

지번주소
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-13T07:51:47.180106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length21.478261
Min length20

Characters and Unicode

Total characters494
Distinct characters40
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

Unique23 ?
Unique (%)100.0%

Sample

1st row경기도 연천군 전곡읍 전곡리 304-6
2nd row경기도 연천군 연천읍 차탄리 34-16
3rd row경기도 연천군 연천읍 차탄리 34-144
4th row경기도 연천군 전곡읍 전곡리 480-20
5th row경기도 연천군 백학면 두일리 529-5
ValueCountFrequency (%)
경기도 23
20.0%
연천군 23
20.0%
전곡읍 15
13.0%
전곡리 12
10.4%
연천읍 4
 
3.5%
은대리 3
 
2.6%
차탄리 3
 
2.6%
청산면 2
 
1.7%
상리 1
 
0.9%
577-67 1
 
0.9%
Other values (28) 28
24.3%
2023-12-13T07:51:47.530776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
93
18.8%
27
 
5.5%
27
 
5.5%
27
 
5.5%
27
 
5.5%
24
 
4.9%
23
 
4.7%
- 23
 
4.7%
23
 
4.7%
23
 
4.7%
Other values (30) 177
35.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 275
55.7%
Decimal Number 103
 
20.9%
Space Separator 93
 
18.8%
Dash Punctuation 23
 
4.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
27
9.8%
27
9.8%
27
9.8%
27
9.8%
24
8.7%
23
8.4%
23
8.4%
23
8.4%
23
8.4%
19
6.9%
Other values (18) 32
11.6%
Decimal Number
ValueCountFrequency (%)
4 22
21.4%
1 13
12.6%
2 12
11.7%
5 11
10.7%
6 10
9.7%
7 10
9.7%
3 8
 
7.8%
8 7
 
6.8%
0 6
 
5.8%
9 4
 
3.9%
Space Separator
ValueCountFrequency (%)
93
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 275
55.7%
Common 219
44.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
27
9.8%
27
9.8%
27
9.8%
27
9.8%
24
8.7%
23
8.4%
23
8.4%
23
8.4%
23
8.4%
19
6.9%
Other values (18) 32
11.6%
Common
ValueCountFrequency (%)
93
42.5%
- 23
 
10.5%
4 22
 
10.0%
1 13
 
5.9%
2 12
 
5.5%
5 11
 
5.0%
6 10
 
4.6%
7 10
 
4.6%
3 8
 
3.7%
8 7
 
3.2%
Other values (2) 10
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 275
55.7%
ASCII 219
44.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
93
42.5%
- 23
 
10.5%
4 22
 
10.0%
1 13
 
5.9%
2 12
 
5.5%
5 11
 
5.0%
6 10
 
4.6%
7 10
 
4.6%
3 8
 
3.7%
8 7
 
3.2%
Other values (2) 10
 
4.6%
Hangul
ValueCountFrequency (%)
27
9.8%
27
9.8%
27
9.8%
27
9.8%
24
8.7%
23
8.4%
23
8.4%
23
8.4%
23
8.4%
19
6.9%
Other values (18) 32
11.6%

위도
Real number (ℝ)

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.040976
Minimum37.997183
Maximum38.133589
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size339.0 B
2023-12-13T07:51:47.727493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.997183
5-th percentile38.024261
Q138.025083
median38.026828
Q338.03114
95-th percentile38.101608
Maximum38.133589
Range0.13640533
Interquartile range (IQR)0.0060575182

Descriptive statistics

Standard deviation0.033721692
Coefficient of variation (CV)0.00088645708
Kurtosis1.8982311
Mean38.040976
Median Absolute Deviation (MAD)0.0023382863
Skewness1.6820792
Sum874.94244
Variance0.0011371525
MonotonicityNot monotonic
2023-12-13T07:51:47.866369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
38.0242740631 1
 
4.3%
38.1004751518 1
 
4.3%
38.0284068688 1
 
4.3%
38.0261800921 1
 
4.3%
38.0301802032 1
 
4.3%
38.0270810057 1
 
4.3%
38.0265436434 1
 
4.3%
38.0268242874 1
 
4.3%
38.0993595938 1
 
4.3%
38.1335886505 1
 
4.3%
Other values (13) 13
56.5%
ValueCountFrequency (%)
37.9971833205 1
4.3%
38.0242593187 1
4.3%
38.0242740631 1
4.3%
38.024344456 1
4.3%
38.024489614 1
4.3%
38.0247936017 1
4.3%
38.0253720458 1
4.3%
38.0256978353 1
4.3%
38.0261800921 1
4.3%
38.0265436434 1
4.3%
ValueCountFrequency (%)
38.1335886505 1
4.3%
38.1017336994 1
4.3%
38.1004751518 1
4.3%
38.0993595938 1
4.3%
38.0580323626 1
4.3%
38.0321004806 1
4.3%
38.0301802032 1
4.3%
38.0284068688 1
4.3%
38.0276108287 1
4.3%
38.0270835974 1
4.3%

경도
Real number (ℝ)

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.06199
Minimum126.91364
Maximum127.10825
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size339.0 B
2023-12-13T07:51:48.010122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.91364
5-th percentile127.02323
Q1127.0672
median127.06799
Q3127.07037
95-th percentile127.07864
Maximum127.10825
Range0.19460311
Interquartile range (IQR)0.0031629548

Descriptive statistics

Standard deviation0.035257373
Coefficient of variation (CV)0.00027748166
Kurtosis15.583399
Mean127.06199
Median Absolute Deviation (MAD)0.0012613492
Skewness-3.6691892
Sum2922.4258
Variance0.0012430823
MonotonicityNot monotonic
2023-12-13T07:51:48.156963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
127.0685652569 1
 
4.3%
127.074998322 1
 
4.3%
127.0667013108 1
 
4.3%
127.0672636347 1
 
4.3%
127.0656627857 1
 
4.3%
127.0679108125 1
 
4.3%
127.0676860589 1
 
4.3%
127.0679882517 1
 
4.3%
127.0747883209 1
 
4.3%
127.0790408455 1
 
4.3%
Other values (13) 13
56.5%
ValueCountFrequency (%)
126.9136448347 1
4.3%
127.018994977 1
4.3%
127.0613334867 1
4.3%
127.0656627857 1
4.3%
127.0667013108 1
4.3%
127.0671458078 1
4.3%
127.0672636347 1
4.3%
127.0674779 1
4.3%
127.0676860589 1
4.3%
127.0677196764 1
4.3%
ValueCountFrequency (%)
127.108247944 1
4.3%
127.0790408455 1
4.3%
127.074998322 1
4.3%
127.0747883209 1
4.3%
127.0747610979 1
4.3%
127.0714857512 1
4.3%
127.0692496009 1
4.3%
127.0688313076 1
4.3%
127.0685652569 1
4.3%
127.0682025015 1
4.3%

전화번호
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-13T07:51:48.376516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique23 ?
Unique (%)100.0%

Sample

1st row031-832-1972
2nd row031-834-7082
3rd row031-834-2921
4th row031-833-5540
5th row031-835-8935
ValueCountFrequency (%)
031-832-1972 1
 
4.3%
031-835-0355 1
 
4.3%
031-832-2200 1
 
4.3%
031-832-8881 1
 
4.3%
031-832-2178 1
 
4.3%
031-832-2340 1
 
4.3%
031-832-2042 1
 
4.3%
031-834-0124 1
 
4.3%
031-834-2576 1
 
4.3%
031-832-3435 1
 
4.3%
Other values (13) 13
56.5%
2023-12-13T07:51:48.772269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 58
21.0%
- 46
16.7%
0 36
13.0%
8 36
13.0%
1 31
11.2%
2 25
9.1%
5 14
 
5.1%
4 11
 
4.0%
7 9
 
3.3%
9 8
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 230
83.3%
Dash Punctuation 46
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 58
25.2%
0 36
15.7%
8 36
15.7%
1 31
13.5%
2 25
10.9%
5 14
 
6.1%
4 11
 
4.8%
7 9
 
3.9%
9 8
 
3.5%
6 2
 
0.9%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 58
21.0%
- 46
16.7%
0 36
13.0%
8 36
13.0%
1 31
11.2%
2 25
9.1%
5 14
 
5.1%
4 11
 
4.0%
7 9
 
3.3%
9 8
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 58
21.0%
- 46
16.7%
0 36
13.0%
8 36
13.0%
1 31
11.2%
2 25
9.1%
5 14
 
5.1%
4 11
 
4.0%
7 9
 
3.3%
9 8
 
2.9%

Interactions

2023-12-13T07:51:45.696296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:51:45.515463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:51:45.784948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:51:45.595136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:51:48.871441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명도로명주소지번주소위도경도전화번호
약국명1.0001.0001.0001.0001.0001.000
도로명주소1.0001.0001.0001.0001.0001.000
지번주소1.0001.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.7381.000
경도1.0001.0001.0000.7381.0001.000
전화번호1.0001.0001.0001.0001.0001.000
2023-12-13T07:51:48.976945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.021
경도0.0211.000

Missing values

2023-12-13T07:51:45.895257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:51:46.011047image/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

약국명도로명주소지번주소위도경도전화번호
0우리약국경기도 연천군 전곡읍 온골로 36경기도 연천군 전곡읍 전곡리 304-638.024274127.068565031-832-1972
1참사랑약국경기도 연천군 연천읍 연천로 264-1경기도 연천군 연천읍 차탄리 34-1638.100475127.074998031-834-7082
2연천약국경기도 연천군 연천읍 연천로 277경기도 연천군 연천읍 차탄리 34-14438.101734127.074761031-834-2921
3코리아약국경기도 연천군 전곡읍 전곡로167번길 4경기도 연천군 전곡읍 전곡리 480-2038.027084127.067478031-833-5540
4백학종점약국경기도 연천군 백학면 두백로 33경기도 연천군 백학면 두일리 529-538.0321126.913645031-835-8935
5성심미소약국경기도 연천군 전곡읍 전곡로 175경기도 연천군 전곡읍 전곡리 483-6838.027611127.067146031-832-8271
6메디팜 원무약국경기도 연천군 청산면 궁평로 42경기도 연천군 청산면 궁평리 474-238.026828127.108248031-833-3578
7임진강약국경기도 연천군 군남면 군남로 117-2경기도 연천군 군남면 진상리 624-938.058032127.018995031-833-5579
8학담약국경기도 연천군 청산면 학담로89번길 10경기도 연천군 청산면 초성리 214-1537.997183127.071486031-835-0090
9전곡약국경기도 연천군 전곡읍 전곡로 138경기도 연천군 전곡읍 전곡리 335-1138.02449127.06925031-835-7890
약국명도로명주소지번주소위도경도전화번호
13희망약국경기도 연천군 전곡읍 전곡로 146경기도 연천군 전곡읍 전곡리 468-1738.025372127.068831031-832-0399
14태양약국경기도 연천군 전곡읍 온골로 53경기도 연천군 전곡읍 전곡리 477-538.025698127.06772031-832-3435
15유약국경기도 연천군 연천읍 신망로 2경기도 연천군 연천읍 상리 142-638.133589127.079041031-834-2576
16중앙약국경기도 연천군 연천읍 연천로252번길 3경기도 연천군 연천읍 차탄리 62-838.09936127.074788031-834-0124
17보경약국경기도 연천군 전곡읍 전곡로 166경기도 연천군 전곡읍 전곡리 479-1238.026824127.067988031-832-2042
18럭키약국경기도 연천군 전곡읍 전곡로 161경기도 연천군 전곡읍 전곡리 480-1438.026544127.067686031-832-2340
19광신약국경기도 연천군 전곡읍 전곡로 168-1경기도 연천군 전곡읍 전곡리 479-4538.027081127.067911031-832-2178
20행운약국경기도 연천군 전곡읍 전곡로 205경기도 연천군 전곡읍 은대리 556-138.03018127.065663031-832-8881
21여름약국경기도 연천군 전곡읍 전곡로161번길9경기도 연천군 전곡읍 전곡리 480-3538.02618127.067264031-832-2200
22호야약국경기도 연천군 전곡읍 전곡로185경기도 연천군 전곡읍 은대리 564-238.028407127.066701031-833-6123