Overview

Dataset statistics

Number of variables4
Number of observations1321
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory42.7 KiB
Average record size in memory33.1 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Descriptionㅇ 경남 도 내 18개 시군의 약국에 대한 데이터로, 약국명 및 주소 현황 등을 제시하여 위치 파악에 유용한 정보를 제공합니다.
Author경상남도
URLhttps://www.data.go.kr/data/15069258/fileData.do

Alerts

연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:42:12.409429
Analysis finished2023-12-12 12:42:13.273853
Duration0.86 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1321
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean661
Minimum1
Maximum1321
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.7 KiB
2023-12-12T21:42:13.370435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile67
Q1331
median661
Q3991
95-th percentile1255
Maximum1321
Range1320
Interquartile range (IQR)660

Descriptive statistics

Standard deviation381.48416
Coefficient of variation (CV)0.57713187
Kurtosis-1.2
Mean661
Median Absolute Deviation (MAD)330
Skewness0
Sum873181
Variance145530.17
MonotonicityStrictly increasing
2023-12-12T21:42:13.563668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
888 1
 
0.1%
886 1
 
0.1%
885 1
 
0.1%
884 1
 
0.1%
883 1
 
0.1%
882 1
 
0.1%
881 1
 
0.1%
880 1
 
0.1%
879 1
 
0.1%
Other values (1311) 1311
99.2%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1321 1
0.1%
1320 1
0.1%
1319 1
0.1%
1318 1
0.1%
1317 1
0.1%
1316 1
0.1%
1315 1
0.1%
1314 1
0.1%
1313 1
0.1%
1312 1
0.1%

업종
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
김해시
184 
진주시
152 
양산시
134 
창원시 의창구
106 
창원시 성산구
81 
Other values (17)
664 

Length

Max length9
Median length3
Mean length4.5034065
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row창원시 의창구
2nd row창원시 의창구
3rd row창원시 의창구
4th row창원시 성산구
5th row창원시 성산구

Common Values

ValueCountFrequency (%)
김해시 184
13.9%
진주시 152
11.5%
양산시 134
10.1%
창원시 의창구 106
 
8.0%
창원시 성산구 81
 
6.1%
창원시 마산회원구 79
 
6.0%
창원시 마산합포구 78
 
5.9%
거제시 77
 
5.8%
창원시 진해구 74
 
5.6%
통영시 58
 
4.4%
Other values (12) 298
22.6%

Length

2023-12-12T21:42:13.719659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
창원시 418
24.0%
김해시 184
10.6%
진주시 152
 
8.7%
양산시 134
 
7.7%
의창구 106
 
6.1%
성산구 81
 
4.7%
마산회원구 79
 
4.5%
마산합포구 78
 
4.5%
거제시 77
 
4.4%
진해구 74
 
4.3%
Other values (13) 356
20.5%

업체명
Text

Distinct930
Distinct (%)70.4%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
2023-12-12T21:42:14.097154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length4
Mean length4.8327025
Min length3

Characters and Unicode

Total characters6384
Distinct characters341
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

Unique762 ?
Unique (%)57.7%

Sample

1st row2층하늘약국
2nd row4층약국
3rd row8시약국
4th rowe조은약국
5th row가음정한약국
ValueCountFrequency (%)
약국 16
 
1.2%
우리약국 13
 
1.0%
조은약국 10
 
0.7%
제일약국 10
 
0.7%
한솔약국 9
 
0.7%
삼성약국 9
 
0.7%
중앙약국 9
 
0.7%
행복한약국 8
 
0.6%
미래약국 8
 
0.6%
새봄약국 7
 
0.5%
Other values (924) 1260
92.7%
2023-12-12T21:42:14.679698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 1325
20.8%
국 1324
20.7%
리 131
 
2.1%
한 115
 
1.8%
온 77
 
1.2%
성 77
 
1.2%
누 72
 
1.1%
대 71
 
1.1%
동 66
 
1.0%
새 60
 
0.9%
Other values (331) 3066
48.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6322
99.0%
Space Separator 40
 
0.6%
Decimal Number 15
 
0.2%
Lowercase Letter 6
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 1325
21.0%
국 1324
20.9%
리 131
 
2.1%
한 115
 
1.8%
온 77
 
1.2%
성 77
 
1.2%
누 72
 
1.1%
대 71
 
1.1%
동 66
 
1.0%
새 60
 
0.9%
Other values (317) 3004
47.5%
Decimal Number
ValueCountFrequency (%)
2 4
26.7%
1 3
20.0%
4 2
13.3%
3 2
13.3%
7 1
 
6.7%
5 1
 
6.7%
6 1
 
6.7%
8 1
 
6.7%
Lowercase Letter
ValueCountFrequency (%)
e 3
50.0%
i 1
 
16.7%
h 1
 
16.7%
t 1
 
16.7%
Space Separator
ValueCountFrequency (%)
40
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6322
99.0%
Common 56
 
0.9%
Latin 6
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 1325
21.0%
국 1324
20.9%
리 131
 
2.1%
한 115
 
1.8%
온 77
 
1.2%
성 77
 
1.2%
누 72
 
1.1%
대 71
 
1.1%
동 66
 
1.0%
새 60
 
0.9%
Other values (317) 3004
47.5%
Common
ValueCountFrequency (%)
40
71.4%
2 4
 
7.1%
1 3
 
5.4%
4 2
 
3.6%
3 2
 
3.6%
7 1
 
1.8%
5 1
 
1.8%
6 1
 
1.8%
8 1
 
1.8%
- 1
 
1.8%
Latin
ValueCountFrequency (%)
e 3
50.0%
i 1
 
16.7%
h 1
 
16.7%
t 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6322
99.0%
ASCII 62
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 1325
21.0%
국 1324
20.9%
리 131
 
2.1%
한 115
 
1.8%
온 77
 
1.2%
성 77
 
1.2%
누 72
 
1.1%
대 71
 
1.1%
동 66
 
1.0%
새 60
 
0.9%
Other values (317) 3004
47.5%
ASCII
ValueCountFrequency (%)
40
64.5%
2 4
 
6.5%
1 3
 
4.8%
e 3
 
4.8%
4 2
 
3.2%
3 2
 
3.2%
i 1
 
1.6%
7 1
 
1.6%
5 1
 
1.6%
6 1
 
1.6%
Other values (4) 4
 
6.5%

소재지
Text

Distinct1314
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size10.4 KiB
2023-12-12T21:42:15.071869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length40
Mean length22.741862
Min length13

Characters and Unicode

Total characters30042
Distinct characters395
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1307 ?
Unique (%)98.9%

Sample

1st row창원시 의창구 북면 동곡로 9, 2층 202호
2nd row창원시 의창구 원이대로 587 (용호동)
3rd row창원시 의창구 용동로 45, 현대썬앤빌스퀘어 A동 1층 105,106호 (사림동)
4th row창원시 성산구 대암로 40-14, 동양람세스빌딩 (남양동)
5th row창원시 성산구 가음정로43번길 1, 가음정빌딩 1층 107호 (가음동)
ValueCountFrequency (%)
창원시 418
 
6.4%
김해시 184
 
2.8%
1층 175
 
2.7%
진주시 152
 
2.3%
양산시 134
 
2.0%
의창구 106
 
1.6%
성산구 81
 
1.2%
마산회원구 79
 
1.2%
마산합포구 78
 
1.2%
거제시 77
 
1.2%
Other values (1914) 5062
77.3%
2023-12-12T21:42:15.555269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5277
 
17.6%
1 1463
 
4.9%
동 1200
 
4.0%
시 1157
 
3.9%
로 1145
 
3.8%
( 947
 
3.2%
) 947
 
3.2%
창 691
 
2.3%
원 656
 
2.2%
, 646
 
2.2%
Other values (385) 15913
53.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16843
56.1%
Space Separator 5277
 
17.6%
Decimal Number 5093
 
17.0%
Open Punctuation 947
 
3.2%
Close Punctuation 947
 
3.2%
Other Punctuation 683
 
2.3%
Dash Punctuation 211
 
0.7%
Uppercase Letter 31
 
0.1%
Lowercase Letter 8
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 1200
 
7.1%
시 1157
 
6.9%
로 1145
 
6.8%
창 691
 
4.1%
원 656
 
3.9%
산 541
 
3.2%
구 453
 
2.7%
길 387
 
2.3%
진 367
 
2.2%
해 335
 
2.0%
Other values (347) 9911
58.8%
Uppercase Letter
ValueCountFrequency (%)
A 7
22.6%
B 5
16.1%
H 3
9.7%
M 3
9.7%
C 2
 
6.5%
Y 2
 
6.5%
K 2
 
6.5%
N 2
 
6.5%
O 1
 
3.2%
S 1
 
3.2%
Other values (3) 3
9.7%
Decimal Number
ValueCountFrequency (%)
1 1463
28.7%
2 642
12.6%
3 534
 
10.5%
0 464
 
9.1%
4 423
 
8.3%
5 398
 
7.8%
6 327
 
6.4%
8 305
 
6.0%
7 301
 
5.9%
9 236
 
4.6%
Lowercase Letter
ValueCountFrequency (%)
n 2
25.0%
c 1
12.5%
p 1
12.5%
e 1
12.5%
o 1
12.5%
d 1
12.5%
a 1
12.5%
Other Punctuation
ValueCountFrequency (%)
, 646
94.6%
· 35
 
5.1%
. 2
 
0.3%
Space Separator
ValueCountFrequency (%)
5277
100.0%
Open Punctuation
ValueCountFrequency (%)
( 947
100.0%
Close Punctuation
ValueCountFrequency (%)
) 947
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 211
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16843
56.1%
Common 13160
43.8%
Latin 39
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 1200
 
7.1%
시 1157
 
6.9%
로 1145
 
6.8%
창 691
 
4.1%
원 656
 
3.9%
산 541
 
3.2%
구 453
 
2.7%
길 387
 
2.3%
진 367
 
2.2%
해 335
 
2.0%
Other values (347) 9911
58.8%
Latin
ValueCountFrequency (%)
A 7
17.9%
B 5
12.8%
H 3
 
7.7%
M 3
 
7.7%
C 2
 
5.1%
Y 2
 
5.1%
K 2
 
5.1%
n 2
 
5.1%
N 2
 
5.1%
c 1
 
2.6%
Other values (10) 10
25.6%
Common
ValueCountFrequency (%)
5277
40.1%
1 1463
 
11.1%
( 947
 
7.2%
) 947
 
7.2%
, 646
 
4.9%
2 642
 
4.9%
3 534
 
4.1%
0 464
 
3.5%
4 423
 
3.2%
5 398
 
3.0%
Other values (8) 1419
 
10.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16843
56.1%
ASCII 13164
43.8%
None 35
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5277
40.1%
1 1463
 
11.1%
( 947
 
7.2%
) 947
 
7.2%
, 646
 
4.9%
2 642
 
4.9%
3 534
 
4.1%
0 464
 
3.5%
4 423
 
3.2%
5 398
 
3.0%
Other values (27) 1423
 
10.8%
Hangul
ValueCountFrequency (%)
동 1200
 
7.1%
시 1157
 
6.9%
로 1145
 
6.8%
창 691
 
4.1%
원 656
 
3.9%
산 541
 
3.2%
구 453
 
2.7%
길 387
 
2.3%
진 367
 
2.2%
해 335
 
2.0%
Other values (347) 9911
58.8%
None
ValueCountFrequency (%)
· 35
100.0%

Interactions

2023-12-12T21:42:12.888359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:42:15.651918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.960
업종0.9601.000
2023-12-12T21:42:15.756516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.794
업종0.7941.000

Missing values

2023-12-12T21:42:13.113419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:42:13.232932image/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창원시 의창구2층하늘약국창원시 의창구 북면 동곡로 9, 2층 202호
12창원시 의창구4층약국창원시 의창구 원이대로 587 (용호동)
23창원시 의창구8시약국창원시 의창구 용동로 45, 현대썬앤빌스퀘어 A동 1층 105,106호 (사림동)
34창원시 성산구e조은약국창원시 성산구 대암로 40-14, 동양람세스빌딩 (남양동)
45창원시 성산구가음정한약국창원시 성산구 가음정로43번길 1, 가음정빌딩 1층 107호 (가음동)
56창원시 의창구감계 현대약국창원시 의창구 북면 동전로 63
67창원시 의창구감계미소약국창원시 의창구 북면 감계로110번길 54-39, 102호
78창원시 의창구건강약국창원시 의창구 창원천로 34, 121동 226호 (대원동, 대원 꿈에그린)
89창원시 성산구건강일등약국창원시 성산구 삼정자로43번길 8, 성주빌딩 1층 103호 (성주동)
910창원시 의창구경남약국창원시 의창구 창이대로309번길 7 (봉곡동, 중앙빌딩)
연번업종업체명소재지
13111312합천군삼성온누리약국합천군 합천읍 대야로 880-8
13121313합천군소정약국합천군 합천읍 충효로 78-3
13131314합천군중앙프라자약국합천군 합천읍 충효로 75
13141315합천군세종약국합천군 합천읍 95 1층
13151316합천군합천약국합천군 합천읍 충효로4길 4-1
13161317합천군강약국합천군 합천읍 대야로 889, 1층 102호
13171318합천군백중약국합천군 삼가면 일부4길 23
13181319합천군동일약국합천군 야로면 가야산로 351-1
13191320합천군수강약국합천군 초계면 초계중앙로 86
13201321합천군큰별약국합천군 옥산로 68, 1층