Overview

Dataset statistics

Number of variables6
Number of observations101
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.0 KiB
Average record size in memory50.3 B

Variable types

Numeric1
Text3
Categorical2

Dataset

Description경기도 이천시 약국현황으로 약국 소재 행정동, 약국명칭, 전화번호, 소재지 지번주소, 소재지 도로명주소, 자료기준일 정보를 제공
URLhttps://www.data.go.kr/data/15010781/fileData.do

Alerts

기준연월일 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:47:30.165761
Analysis finished2023-12-12 19:47:30.780768
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51
Minimum1
Maximum101
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-13T04:47:31.190666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6
Q126
median51
Q376
95-th percentile96
Maximum101
Range100
Interquartile range (IQR)50

Descriptive statistics

Standard deviation29.300171
Coefficient of variation (CV)0.57451315
Kurtosis-1.2
Mean51
Median Absolute Deviation (MAD)25
Skewness0
Sum5151
Variance858.5
MonotonicityStrictly increasing
2023-12-13T04:47:31.364285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (91) 91
90.1%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
101 1
1.0%
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%

약국명칭
Text

Distinct99
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-13T04:47:31.697536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length4.9108911
Min length3

Characters and Unicode

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

Unique

Unique97 ?
Unique (%)96.0%

Sample

1st row바른약국
2nd row정성약국
3rd row튼튼약국
4th row조은약국
5th row서울약국
ValueCountFrequency (%)
골드약국 2
 
1.9%
대학약국 2
 
1.9%
최이 2
 
1.9%
새이천약국 1
 
1.0%
세진온누리약국 1
 
1.0%
동의보감한약국 1
 
1.0%
한별약국 1
 
1.0%
설성약국 1
 
1.0%
기린약국 1
 
1.0%
참조은약국 1
 
1.0%
Other values (92) 92
87.6%
2023-12-13T04:47:32.263042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 101
20.4%
국 101
20.4%
리 17
 
3.4%
이 11
 
2.2%
온 11
 
2.2%
누 10
 
2.0%
성 7
 
1.4%
정 6
 
1.2%
하 6
 
1.2%
한 5
 
1.0%
Other values (118) 221
44.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 489
98.6%
Space Separator 4
 
0.8%
Decimal Number 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 101
20.7%
국 101
20.7%
리 17
 
3.5%
이 11
 
2.2%
온 11
 
2.2%
누 10
 
2.0%
성 7
 
1.4%
정 6
 
1.2%
하 6
 
1.2%
한 5
 
1.0%
Other values (114) 214
43.8%
Decimal Number
ValueCountFrequency (%)
5 1
33.3%
6 1
33.3%
3 1
33.3%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 489
98.6%
Common 7
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 101
20.7%
국 101
20.7%
리 17
 
3.5%
이 11
 
2.2%
온 11
 
2.2%
누 10
 
2.0%
성 7
 
1.4%
정 6
 
1.2%
하 6
 
1.2%
한 5
 
1.0%
Other values (114) 214
43.8%
Common
ValueCountFrequency (%)
4
57.1%
5 1
 
14.3%
6 1
 
14.3%
3 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 489
98.6%
ASCII 7
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 101
20.7%
국 101
20.7%
리 17
 
3.5%
이 11
 
2.2%
온 11
 
2.2%
누 10
 
2.0%
성 7
 
1.4%
정 6
 
1.2%
하 6
 
1.2%
한 5
 
1.0%
Other values (114) 214
43.8%
ASCII
ValueCountFrequency (%)
4
57.1%
5 1
 
14.3%
6 1
 
14.3%
3 1
 
14.3%

약국전화번호
Text

Distinct99
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-13T04:47:32.597662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.059406
Min length12

Characters and Unicode

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

Unique97 ?
Unique (%)96.0%

Sample

1st row031-634-1090
2nd row031-636-2030
3rd row031-635-3773
4th row031-635-5008
5th row070-8648-2290
ValueCountFrequency (%)
031-631-3317 2
 
2.0%
031-631-8776 2
 
2.0%
031-631-0688 1
 
1.0%
031-635-2024 1
 
1.0%
031-631-3725 1
 
1.0%
031-635-6680 1
 
1.0%
031-631-1141 1
 
1.0%
031-642-2123 1
 
1.0%
031-631-7221 1
 
1.0%
031-631-5339 1
 
1.0%
Other values (89) 89
88.1%
2023-12-13T04:47:33.058649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 230
18.9%
- 202
16.6%
1 171
14.0%
0 167
13.7%
6 143
11.7%
2 65
 
5.3%
7 61
 
5.0%
8 51
 
4.2%
4 50
 
4.1%
5 47
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1016
83.4%
Dash Punctuation 202
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 230
22.6%
1 171
16.8%
0 167
16.4%
6 143
14.1%
2 65
 
6.4%
7 61
 
6.0%
8 51
 
5.0%
4 50
 
4.9%
5 47
 
4.6%
9 31
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1218
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 230
18.9%
- 202
16.6%
1 171
14.0%
0 167
13.7%
6 143
11.7%
2 65
 
5.3%
7 61
 
5.0%
8 51
 
4.2%
4 50
 
4.1%
5 47
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1218
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 230
18.9%
- 202
16.6%
1 171
14.0%
0 167
13.7%
6 143
11.7%
2 65
 
5.3%
7 61
 
5.0%
8 51
 
4.2%
4 50
 
4.1%
5 47
 
3.9%

약국소재지(도로명)
Text

Distinct98
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-12-13T04:47:33.483902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length35
Mean length25.841584
Min length18

Characters and Unicode

Total characters2610
Distinct characters132
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

Unique95 ?
Unique (%)94.1%

Sample

1st row경기도 이천시 부발읍 경충대로 2088, 103호
2nd row경기도 이천시 향교로 95-4, 106호 (창전동)
3rd row경기도 이천시 영창로 202, 4층 (창전동)
4th row경기도 이천시 장호원읍 장감로77번길 10
5th row경기도 이천시 이섭대천로 1381, 1층 (증포동)
ValueCountFrequency (%)
경기도 101
17.8%
이천시 101
17.8%
창전동 25
 
4.4%
이섭대천로 23
 
4.0%
중리동 19
 
3.3%
경충대로 17
 
3.0%
부발읍 14
 
2.5%
1층 13
 
2.3%
장호원읍 11
 
1.9%
영창로 8
 
1.4%
Other values (180) 237
41.7%
2023-12-13T04:47:34.085966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
468
17.9%
천 140
 
5.4%
이 131
 
5.0%
경 120
 
4.6%
1 120
 
4.6%
시 102
 
3.9%
도 101
 
3.9%
로 101
 
3.9%
기 101
 
3.9%
2 72
 
2.8%
Other values (122) 1154
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1490
57.1%
Space Separator 468
 
17.9%
Decimal Number 456
 
17.5%
Open Punctuation 62
 
2.4%
Close Punctuation 62
 
2.4%
Other Punctuation 53
 
2.0%
Dash Punctuation 17
 
0.7%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 140
 
9.4%
이 131
 
8.8%
경 120
 
8.1%
시 102
 
6.8%
도 101
 
6.8%
로 101
 
6.8%
기 101
 
6.8%
동 65
 
4.4%
대 49
 
3.3%
리 36
 
2.4%
Other values (105) 544
36.5%
Decimal Number
ValueCountFrequency (%)
1 120
26.3%
2 72
15.8%
0 52
11.4%
3 40
 
8.8%
7 37
 
8.1%
4 35
 
7.7%
8 34
 
7.5%
5 28
 
6.1%
9 19
 
4.2%
6 19
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
I 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
468
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 53
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1490
57.1%
Common 1118
42.8%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 140
 
9.4%
이 131
 
8.8%
경 120
 
8.1%
시 102
 
6.8%
도 101
 
6.8%
로 101
 
6.8%
기 101
 
6.8%
동 65
 
4.4%
대 49
 
3.3%
리 36
 
2.4%
Other values (105) 544
36.5%
Common
ValueCountFrequency (%)
468
41.9%
1 120
 
10.7%
2 72
 
6.4%
( 62
 
5.5%
) 62
 
5.5%
, 53
 
4.7%
0 52
 
4.7%
3 40
 
3.6%
7 37
 
3.3%
4 35
 
3.1%
Other values (5) 117
 
10.5%
Latin
ValueCountFrequency (%)
I 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1490
57.1%
ASCII 1120
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
468
41.8%
1 120
 
10.7%
2 72
 
6.4%
( 62
 
5.5%
) 62
 
5.5%
, 53
 
4.7%
0 52
 
4.6%
3 40
 
3.6%
7 37
 
3.3%
4 35
 
3.1%
Other values (7) 119
 
10.6%
Hangul
ValueCountFrequency (%)
천 140
 
9.4%
이 131
 
8.8%
경 120
 
8.1%
시 102
 
6.8%
도 101
 
6.8%
로 101
 
6.8%
기 101
 
6.8%
동 65
 
4.4%
대 49
 
3.3%
리 36
 
2.4%
Other values (105) 544
36.5%

약국행정동
Categorical

Distinct13
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size940.0 B
창전동
25 
중리동
19 
부발읍
14 
장호원읍
11 
증포동
10 
Other values (8)
22 

Length

Max length4
Median length3
Mean length3.1089109
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row부발읍
2nd row창전동
3rd row창전동
4th row장호원읍
5th row증포동

Common Values

ValueCountFrequency (%)
창전동 25
24.8%
중리동 19
18.8%
부발읍 14
13.9%
장호원읍 11
10.9%
증포동 10
 
9.9%
관고동 6
 
5.9%
백사면 4
 
4.0%
신둔면 4
 
4.0%
호법면 2
 
2.0%
마장면 2
 
2.0%
Other values (3) 4
 
4.0%

Length

2023-12-13T04:47:34.334288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
창전동 25
24.8%
중리동 19
18.8%
부발읍 14
13.9%
장호원읍 11
10.9%
증포동 10
 
9.9%
관고동 6
 
5.9%
백사면 4
 
4.0%
신둔면 4
 
4.0%
호법면 2
 
2.0%
마장면 2
 
2.0%
Other values (3) 4
 
4.0%

기준연월일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
2023-08-31
101 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-31
2nd row2023-08-31
3rd row2023-08-31
4th row2023-08-31
5th row2023-08-31

Common Values

ValueCountFrequency (%)
2023-08-31 101
100.0%

Length

2023-12-13T04:47:34.512189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:47:34.614105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-31 101
100.0%

Interactions

2023-12-13T04:47:30.480696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:47:34.699245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국명칭약국전화번호약국소재지(도로명)약국행정동
순번1.0001.0001.0000.9840.372
약국명칭1.0001.0001.0001.0001.000
약국전화번호1.0001.0001.0001.0001.000
약국소재지(도로명)0.9841.0001.0001.0001.000
약국행정동0.3721.0001.0001.0001.000
2023-12-13T04:47:34.809222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약국행정동
순번1.0000.150
약국행정동0.1501.000

Missing values

2023-12-13T04:47:30.587507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:47:30.726883image/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바른약국031-634-1090경기도 이천시 부발읍 경충대로 2088, 103호부발읍2023-08-31
12정성약국031-636-2030경기도 이천시 향교로 95-4, 106호 (창전동)창전동2023-08-31
23튼튼약국031-635-3773경기도 이천시 영창로 202, 4층 (창전동)창전동2023-08-31
34조은약국031-635-5008경기도 이천시 장호원읍 장감로77번길 10장호원읍2023-08-31
45서울약국070-8648-2290경기도 이천시 이섭대천로 1381, 1층 (증포동)증포동2023-08-31
56모전약국031-637-0149경기도 이천시 백사면 청백리로 72백사면2023-08-31
67생명약국031-642-6628경기도 이천시 장호원읍 장터로 45-10장호원읍2023-08-31
78이약국031-632-0901경기도 이천시 호법면 이섭대천로 534호법면2023-08-31
89바다약국031-8011-0012경기도 이천시 장호원읍 이선룡로 16, 202호장호원읍2023-08-31
910사계절약국031-632-0012경기도 이천시 이섭대천로 1213, 시계탑빌딩 (창전동)창전동2023-08-31
순번약국명칭약국전화번호약국소재지(도로명)약국행정동기준연월일
9192한마음약국031-632-6885경기도 이천시 부발읍 무촌로 139부발읍2023-08-31
9293화창약국031-631-6777경기도 이천시 이섭대천로 1233 (창전동)창전동2023-08-31
9394원약국031-635-6161경기도 이천시 부발읍 경충대로 2172부발읍2023-08-31
9495효양약국031-635-4881경기도 이천시 부발읍 대산로 476-13, 1층 (덕원빌딩)부발읍2023-08-31
9596중앙약국031-638-4060경기도 이천시 중리천로 81 (창전동)창전동2023-08-31
9697용수약국031-635-0907경기도 이천시 부발읍 경충대로 2100부발읍2023-08-31
9798감초약국031-633-9927경기도 이천시 신둔면 경충대로 3187신둔면2023-08-31
9899하이중앙약국031-631-2403경기도 이천시 부발읍 경충대로 2091부발읍2023-08-31
99100최약국031-635-2024경기도 이천시 어재연로10번길 60 (중리동)중리동2023-08-31
100101유한약국031-632-2008경기도 이천시 마장면 오천로 33, 아리온프라자 1동 1층 108호마장면2023-08-31