Overview

Dataset statistics

Number of variables7
Number of observations193
Missing cells6
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.9 KiB
Average record size in memory57.7 B

Variable types

Numeric1
Text3
Categorical3

Dataset

Description원주시에 위치하고 있는 약국들의 대한 데이터로 약국의 명칭, 약국의 전화번호, 약국의 소재지(도로명)의 정보들 제공
URLhttps://www.data.go.kr/data/3044399/fileData.do

Alerts

관리기관 has constant value ""Constant
관리기관 전화번호 has constant value ""Constant
데이터 기준일자 has constant value ""Constant
약국전화번호 has 6 (3.1%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:49:02.607928
Analysis finished2023-12-12 14:49:03.283246
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct193
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean97
Minimum1
Maximum193
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-12T23:49:03.373700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.6
Q149
median97
Q3145
95-th percentile183.4
Maximum193
Range192
Interquartile range (IQR)96

Descriptive statistics

Standard deviation55.858452
Coefficient of variation (CV)0.57586033
Kurtosis-1.2
Mean97
Median Absolute Deviation (MAD)48
Skewness0
Sum18721
Variance3120.1667
MonotonicityStrictly increasing
2023-12-12T23:49:03.566473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
146 1
 
0.5%
124 1
 
0.5%
125 1
 
0.5%
126 1
 
0.5%
127 1
 
0.5%
128 1
 
0.5%
129 1
 
0.5%
130 1
 
0.5%
131 1
 
0.5%
Other values (183) 183
94.8%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
193 1
0.5%
192 1
0.5%
191 1
0.5%
190 1
0.5%
189 1
0.5%
188 1
0.5%
187 1
0.5%
186 1
0.5%
185 1
0.5%
184 1
0.5%

약국명칭
Text

Distinct192
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T23:49:04.008128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length4.7823834
Min length3

Characters and Unicode

Total characters923
Distinct characters190
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

Unique191 ?
Unique (%)99.0%

Sample

1st row다사랑약국
2nd row마음약국
3rd row원주제일큰약국
4th row메가센트럴약국
5th row이화햇살약국
ValueCountFrequency (%)
우리온누리약국 2
 
1.0%
이화약국 2
 
1.0%
개운약국 1
 
0.5%
새서울약국 1
 
0.5%
예담한약국 1
 
0.5%
청솔약국 1
 
0.5%
문약국 1
 
0.5%
문화약국 1
 
0.5%
수약국 1
 
0.5%
북원약국 1
 
0.5%
Other values (184) 184
93.9%
2023-12-12T23:49:04.545856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 193
20.9%
국 193
20.9%
리 24
 
2.6%
한 15
 
1.6%
원 15
 
1.6%
온 12
 
1.3%
누 11
 
1.2%
이 11
 
1.2%
주 11
 
1.2%
문 10
 
1.1%
Other values (180) 428
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 912
98.8%
Decimal Number 5
 
0.5%
Space Separator 3
 
0.3%
Uppercase Letter 2
 
0.2%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 193
21.2%
국 193
21.2%
리 24
 
2.6%
한 15
 
1.6%
원 15
 
1.6%
온 12
 
1.3%
누 11
 
1.2%
이 11
 
1.2%
주 11
 
1.2%
문 10
 
1.1%
Other values (173) 417
45.7%
Decimal Number
ValueCountFrequency (%)
1 2
40.0%
0 2
40.0%
2 1
20.0%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
D 1
50.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 912
98.8%
Common 8
 
0.9%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 193
21.2%
국 193
21.2%
리 24
 
2.6%
한 15
 
1.6%
원 15
 
1.6%
온 12
 
1.3%
누 11
 
1.2%
이 11
 
1.2%
주 11
 
1.2%
문 10
 
1.1%
Other values (173) 417
45.7%
Common
ValueCountFrequency (%)
3
37.5%
1 2
25.0%
0 2
25.0%
2 1
 
12.5%
Latin
ValueCountFrequency (%)
C 1
33.3%
D 1
33.3%
e 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 912
98.8%
ASCII 11
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 193
21.2%
국 193
21.2%
리 24
 
2.6%
한 15
 
1.6%
원 15
 
1.6%
온 12
 
1.3%
누 11
 
1.2%
이 11
 
1.2%
주 11
 
1.2%
문 10
 
1.1%
Other values (173) 417
45.7%
ASCII
ValueCountFrequency (%)
3
27.3%
1 2
18.2%
0 2
18.2%
C 1
 
9.1%
D 1
 
9.1%
e 1
 
9.1%
2 1
 
9.1%

약국전화번호
Text

MISSING 

Distinct186
Distinct (%)99.5%
Missing6
Missing (%)3.1%
Memory size1.6 KiB
2023-12-12T23:49:04.838461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.010695
Min length12

Characters and Unicode

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

Unique185 ?
Unique (%)98.9%

Sample

1st row033-744-6997
2nd row033-765-0687
3rd row033-747-8744
4th row070-4133-1234
5th row033-735-8257
ValueCountFrequency (%)
033-900-2525 2
 
1.1%
033-743-8266 1
 
0.5%
033-748-7727 1
 
0.5%
033-731-5671 1
 
0.5%
033-735-0802 1
 
0.5%
033-744-0405 1
 
0.5%
033-744-7980 1
 
0.5%
033-742-3624 1
 
0.5%
033-747-8366 1
 
0.5%
033-761-2847 1
 
0.5%
Other values (176) 176
94.1%
2023-12-12T23:49:05.289078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 517
23.0%
- 374
16.7%
7 300
13.4%
0 275
12.2%
4 175
 
7.8%
6 149
 
6.6%
5 113
 
5.0%
2 109
 
4.9%
1 89
 
4.0%
8 87
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1872
83.3%
Dash Punctuation 374
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 517
27.6%
7 300
16.0%
0 275
14.7%
4 175
 
9.3%
6 149
 
8.0%
5 113
 
6.0%
2 109
 
5.8%
1 89
 
4.8%
8 87
 
4.6%
9 58
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 374
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2246
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 517
23.0%
- 374
16.7%
7 300
13.4%
0 275
12.2%
4 175
 
7.8%
6 149
 
6.6%
5 113
 
5.0%
2 109
 
4.9%
1 89
 
4.0%
8 87
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2246
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 517
23.0%
- 374
16.7%
7 300
13.4%
0 275
12.2%
4 175
 
7.8%
6 149
 
6.6%
5 113
 
5.0%
2 109
 
4.9%
1 89
 
4.0%
8 87
 
3.9%

약국소재지(도로명)
Text

Distinct189
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T23:49:05.761189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length40
Mean length29.367876
Min length21

Characters and Unicode

Total characters5668
Distinct characters187
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

Unique185 ?
Unique (%)95.9%

Sample

1st row강원특별자치도 원주시 문막읍 구암길 9, 101호
2nd row강원특별자치도 원주시 서원대로 383, 한신프라자 120호 (개운동)
3rd row강원특별자치도 원주시 판부면 서곡널다리길 2
4th row강원특별자치도 원주시 양지로 80, 110, 111호 (반곡동)
5th row강원특별자치도 원주시 현충로58번길 28, 1층 (태장동)
ValueCountFrequency (%)
강원특별자치도 193
 
17.4%
원주시 193
 
17.4%
1층 45
 
4.1%
단계동 24
 
2.2%
단구동 21
 
1.9%
일산동 21
 
1.9%
무실동 19
 
1.7%
서원대로 16
 
1.4%
남원로 13
 
1.2%
개운동 13
 
1.2%
Other values (294) 550
49.6%
2023-12-12T23:49:06.487631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
916
 
16.2%
원 464
 
8.2%
1 259
 
4.6%
시 213
 
3.8%
치 207
 
3.7%
자 206
 
3.6%
별 194
 
3.4%
주 194
 
3.4%
강 193
 
3.4%
특 193
 
3.4%
Other values (177) 2629
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3518
62.1%
Space Separator 916
 
16.2%
Decimal Number 759
 
13.4%
Open Punctuation 165
 
2.9%
Close Punctuation 165
 
2.9%
Other Punctuation 113
 
2.0%
Dash Punctuation 27
 
0.5%
Uppercase Letter 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 464
 
13.2%
시 213
 
6.1%
치 207
 
5.9%
자 206
 
5.9%
별 194
 
5.5%
주 194
 
5.5%
강 193
 
5.5%
특 193
 
5.5%
도 193
 
5.5%
동 181
 
5.1%
Other values (157) 1280
36.4%
Decimal Number
ValueCountFrequency (%)
1 259
34.1%
2 88
 
11.6%
0 69
 
9.1%
3 66
 
8.7%
6 55
 
7.2%
5 54
 
7.1%
4 52
 
6.9%
8 48
 
6.3%
7 37
 
4.9%
9 31
 
4.1%
Uppercase Letter
ValueCountFrequency (%)
B 2
40.0%
D 1
20.0%
S 1
20.0%
G 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 112
99.1%
/ 1
 
0.9%
Space Separator
ValueCountFrequency (%)
916
100.0%
Open Punctuation
ValueCountFrequency (%)
( 165
100.0%
Close Punctuation
ValueCountFrequency (%)
) 165
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3518
62.1%
Common 2145
37.8%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 464
 
13.2%
시 213
 
6.1%
치 207
 
5.9%
자 206
 
5.9%
별 194
 
5.5%
주 194
 
5.5%
강 193
 
5.5%
특 193
 
5.5%
도 193
 
5.5%
동 181
 
5.1%
Other values (157) 1280
36.4%
Common
ValueCountFrequency (%)
916
42.7%
1 259
 
12.1%
( 165
 
7.7%
) 165
 
7.7%
, 112
 
5.2%
2 88
 
4.1%
0 69
 
3.2%
3 66
 
3.1%
6 55
 
2.6%
5 54
 
2.5%
Other values (6) 196
 
9.1%
Latin
ValueCountFrequency (%)
B 2
40.0%
D 1
20.0%
S 1
20.0%
G 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3518
62.1%
ASCII 2150
37.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
916
42.6%
1 259
 
12.0%
( 165
 
7.7%
) 165
 
7.7%
, 112
 
5.2%
2 88
 
4.1%
0 69
 
3.2%
3 66
 
3.1%
6 55
 
2.6%
5 54
 
2.5%
Other values (10) 201
 
9.3%
Hangul
ValueCountFrequency (%)
원 464
 
13.2%
시 213
 
6.1%
치 207
 
5.9%
자 206
 
5.9%
별 194
 
5.5%
주 194
 
5.5%
강 193
 
5.5%
특 193
 
5.5%
도 193
 
5.5%
동 181
 
5.1%
Other values (157) 1280
36.4%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
강원도 원주시청
193 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원도 원주시청
2nd row강원도 원주시청
3rd row강원도 원주시청
4th row강원도 원주시청
5th row강원도 원주시청

Common Values

ValueCountFrequency (%)
강원도 원주시청 193
100.0%

Length

2023-12-12T23:49:06.688966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:49:06.847656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강원도 193
50.0%
원주시청 193
50.0%

관리기관 전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
033-737-4023
193 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row033-737-4023
2nd row033-737-4023
3rd row033-737-4023
4th row033-737-4023
5th row033-737-4023

Common Values

ValueCountFrequency (%)
033-737-4023 193
100.0%

Length

2023-12-12T23:49:07.008299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:49:07.175494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
033-737-4023 193
100.0%

데이터 기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-08-31
193 

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 193
100.0%

Length

2023-12-12T23:49:07.393838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:49:07.575236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-31 193
100.0%

Interactions

2023-12-12T23:49:02.881391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T23:49:03.061905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:49:03.215072image/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다사랑약국033-744-6997강원특별자치도 원주시 문막읍 구암길 9, 101호강원도 원주시청033-737-40232023-08-31
12마음약국033-765-0687강원특별자치도 원주시 서원대로 383, 한신프라자 120호 (개운동)강원도 원주시청033-737-40232023-08-31
23원주제일큰약국<NA>강원특별자치도 원주시 판부면 서곡널다리길 2강원도 원주시청033-737-40232023-08-31
34메가센트럴약국033-747-8744강원특별자치도 원주시 양지로 80, 110, 111호 (반곡동)강원도 원주시청033-737-40232023-08-31
45이화햇살약국<NA>강원특별자치도 원주시 현충로58번길 28, 1층 (태장동)강원도 원주시청033-737-40232023-08-31
56찬슬약국070-4133-1234강원특별자치도 원주시 봉화로 31, 시재메디타워 1층 (단계동)강원도 원주시청033-737-40232023-08-31
67바른약국033-735-8257강원특별자치도 원주시 평원로 98, 나동 (학성동)강원도 원주시청033-737-40232023-08-31
78경희서아당한약국033-904-9731강원특별자치도 원주시 문막읍 문막시장1길 1, 103호강원도 원주시청033-737-40232023-08-31
89주차편한약국033-742-2219강원특별자치도 원주시 일산로 7(일산동)강원도 원주시청033-737-40232023-08-31
910메디팜이화약국<NA>강원특별자치도 원주시 능라동길 59, 정한프라자 104호 (무실동)강원도 원주시청033-737-40232023-08-31
순번약국명칭약국전화번호약국소재지(도로명)관리기관관리기관 전화번호데이터 기준일자
183184신종로약국033-742-5710강원특별자치도 원주시 치악로 1648, 상가동 102,103호 (단구동, 선아아파트)강원도 원주시청033-737-40232023-08-31
184185기독약국033-742-0346강원특별자치도 원주시 무실로 14 (일산동)강원도 원주시청033-737-40232023-08-31
185186100약국033-743-4795강원특별자치도 원주시 평원로 58 (평원동)강원도 원주시청033-737-40232023-08-31
186187전약국033-742-9533강원특별자치도 원주시 치악로 1863 (봉산동)강원도 원주시청033-737-40232023-08-31
187188온누리바다약국033-742-4146강원특별자치도 원주시 북원로 2698 (태장동)강원도 원주시청033-737-40232023-08-31
188189한일약국033-742-7311강원특별자치도 원주시 원일로 161 (일산동)강원도 원주시청033-737-40232023-08-31
189190보당약국033-761-3150강원특별자치도 원주시 서원대로 507 (단구동)강원도 원주시청033-737-40232023-08-31
190191김약국033-763-2315강원특별자치도 원주시 남원로 671 (명륜동)강원도 원주시청033-737-40232023-08-31
191192상도약국033-763-6888강원특별자치도 원주시 서원대로 383, 126,127호 (개운동, 한신프라자)강원도 원주시청033-737-40232023-08-31
192193제일약국033-742-3431강원특별자치도 원주시 중앙로 78 (중앙동)강원도 원주시청033-737-40232023-08-31