Overview

Dataset statistics

Number of variables5
Number of observations915
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory36.8 KiB
Average record size in memory41.1 B

Variable types

Numeric1
Categorical1
Text2
DateTime1

Dataset

Description경상남도 산청군 산청사랑상품권 가맹점 현황으로 소재지(시도/시군구/읍면), 상호명, 주소, 데이서소관부서 등의 정보를 제공하고 있습니다.
Author경상남도 산청군
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15089936

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 읍면High correlation
읍면 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-11 00:35:35.041070
Analysis finished2023-12-11 00:35:35.681199
Duration0.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct915
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean458
Minimum1
Maximum915
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.2 KiB
2023-12-11T09:35:36.036080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile46.7
Q1229.5
median458
Q3686.5
95-th percentile869.3
Maximum915
Range914
Interquartile range (IQR)457

Descriptive statistics

Standard deviation264.28205
Coefficient of variation (CV)0.57703504
Kurtosis-1.2
Mean458
Median Absolute Deviation (MAD)229
Skewness0
Sum419070
Variance69845
MonotonicityStrictly increasing
2023-12-11T09:35:36.183381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
603 1
 
0.1%
605 1
 
0.1%
606 1
 
0.1%
607 1
 
0.1%
608 1
 
0.1%
609 1
 
0.1%
610 1
 
0.1%
611 1
 
0.1%
612 1
 
0.1%
Other values (905) 905
98.9%
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 (%)
915 1
0.1%
914 1
0.1%
913 1
0.1%
912 1
0.1%
911 1
0.1%
910 1
0.1%
909 1
0.1%
908 1
0.1%
907 1
0.1%
906 1
0.1%

읍면
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size7.3 KiB
산청읍
290 
신안면
168 
시천면
133 
단성면
86 
금서면
66 
Other values (7)
172 

Length

Max length4
Median length3
Mean length3.0185792
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row금서면
2nd row금서면
3rd row금서면
4th row금서면
5th row금서면

Common Values

ValueCountFrequency (%)
산청읍 290
31.7%
신안면 168
18.4%
시천면 133
14.5%
단성면 86
 
9.4%
금서면 66
 
7.2%
생초면 57
 
6.2%
신등면 49
 
5.4%
차황면 26
 
2.8%
삼장면 16
 
1.7%
생비량면 15
 
1.6%
Other values (2) 9
 
1.0%

Length

2023-12-11T09:35:36.343828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
산청읍 290
31.7%
신안면 170
18.6%
시천면 133
14.5%
단성면 86
 
9.4%
금서면 66
 
7.2%
생초면 57
 
6.2%
신등면 49
 
5.4%
차황면 26
 
2.8%
삼장면 16
 
1.7%
생비량면 15
 
1.6%

가맹점명
Text

Distinct887
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size7.3 KiB
2023-12-11T09:35:36.603514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length6.3540984
Min length2

Characters and Unicode

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

Unique

Unique859 ?
Unique (%)93.9%

Sample

1st rowcafe이팝
2nd row가현농원
3rd row경호식당
4th row고속주유소
5th row금서정미소
ValueCountFrequency (%)
산청군농협 35
 
3.2%
산청점 12
 
1.1%
하나로마트 11
 
1.0%
신등노점상 6
 
0.5%
주유소 4
 
0.4%
산청대리점 4
 
0.4%
씨유 4
 
0.4%
단성지점 4
 
0.4%
산청덕산점 3
 
0.3%
도야족발 3
 
0.3%
Other values (953) 1024
92.3%
2023-12-11T09:35:36.978365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
산 286
 
4.9%
195
 
3.4%
청 175
 
3.0%
식 154
 
2.6%
지 139
 
2.4%
점 117
 
2.0%
리 115
 
2.0%
원 112
 
1.9%
당 110
 
1.9%
농 96
 
1.7%
Other values (511) 4315
74.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5463
94.0%
Space Separator 195
 
3.4%
Uppercase Letter 46
 
0.8%
Decimal Number 29
 
0.5%
Open Punctuation 28
 
0.5%
Close Punctuation 27
 
0.5%
Other Symbol 11
 
0.2%
Other Punctuation 9
 
0.2%
Lowercase Letter 6
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 286
 
5.2%
청 175
 
3.2%
식 154
 
2.8%
지 139
 
2.5%
점 117
 
2.1%
리 115
 
2.1%
원 112
 
2.1%
당 110
 
2.0%
농 96
 
1.8%
장 71
 
1.3%
Other values (468) 4088
74.8%
Uppercase Letter
ValueCountFrequency (%)
C 8
17.4%
G 5
10.9%
S 5
10.9%
B 4
 
8.7%
K 3
 
6.5%
O 2
 
4.3%
P 2
 
4.3%
J 2
 
4.3%
L 2
 
4.3%
H 2
 
4.3%
Other values (11) 11
23.9%
Decimal Number
ValueCountFrequency (%)
5 6
20.7%
2 6
20.7%
1 6
20.7%
9 3
10.3%
6 2
 
6.9%
7 2
 
6.9%
0 2
 
6.9%
3 1
 
3.4%
4 1
 
3.4%
Lowercase Letter
ValueCountFrequency (%)
c 1
16.7%
a 1
16.7%
f 1
16.7%
e 1
16.7%
s 1
16.7%
k 1
16.7%
Other Punctuation
ValueCountFrequency (%)
. 4
44.4%
, 3
33.3%
& 2
22.2%
Space Separator
ValueCountFrequency (%)
195
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5474
94.2%
Common 288
 
5.0%
Latin 52
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 286
 
5.2%
청 175
 
3.2%
식 154
 
2.8%
지 139
 
2.5%
점 117
 
2.1%
리 115
 
2.1%
원 112
 
2.0%
당 110
 
2.0%
농 96
 
1.8%
장 71
 
1.3%
Other values (469) 4099
74.9%
Latin
ValueCountFrequency (%)
C 8
15.4%
G 5
 
9.6%
S 5
 
9.6%
B 4
 
7.7%
K 3
 
5.8%
O 2
 
3.8%
P 2
 
3.8%
J 2
 
3.8%
L 2
 
3.8%
H 2
 
3.8%
Other values (17) 17
32.7%
Common
ValueCountFrequency (%)
195
67.7%
( 28
 
9.7%
) 27
 
9.4%
5 6
 
2.1%
2 6
 
2.1%
1 6
 
2.1%
. 4
 
1.4%
, 3
 
1.0%
9 3
 
1.0%
6 2
 
0.7%
Other values (5) 8
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5463
94.0%
ASCII 340
 
5.8%
None 11
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
산 286
 
5.2%
청 175
 
3.2%
식 154
 
2.8%
지 139
 
2.5%
점 117
 
2.1%
리 115
 
2.1%
원 112
 
2.1%
당 110
 
2.0%
농 96
 
1.8%
장 71
 
1.3%
Other values (468) 4088
74.8%
ASCII
ValueCountFrequency (%)
195
57.4%
( 28
 
8.2%
) 27
 
7.9%
C 8
 
2.4%
5 6
 
1.8%
2 6
 
1.8%
1 6
 
1.8%
G 5
 
1.5%
S 5
 
1.5%
. 4
 
1.2%
Other values (32) 50
 
14.7%
None
ValueCountFrequency (%)
㈜ 11
100.0%

가맹점주소
Text

Distinct780
Distinct (%)85.2%
Missing0
Missing (%)0.0%
Memory size7.3 KiB
2023-12-11T09:35:37.272449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length29
Mean length17.569399
Min length12

Characters and Unicode

Total characters16076
Distinct characters150
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

Unique685 ?
Unique (%)74.9%

Sample

1st row산청군 금서면 동의보감로 150번길 115
2nd row산청군 금서면 동의보감로 1067, 1층
3rd row산청군 금서면 주상리 235
4th row산청군 금서면 친환경로 2582
5th row산창군 금서면 동의보감로1029번길 82
ValueCountFrequency (%)
산청군 910
24.2%
산청읍 289
 
7.7%
신안면 169
 
4.5%
시천면 133
 
3.5%
단성면 86
 
2.3%
남명로 71
 
1.9%
금서면 67
 
1.8%
웅석봉로 66
 
1.8%
지리산대로 65
 
1.7%
생초면 57
 
1.5%
Other values (746) 1841
49.0%
2023-12-11T09:35:37.728077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2846
17.7%
산 1414
 
8.8%
청 1232
 
7.7%
군 915
 
5.7%
로 818
 
5.1%
1 641
 
4.0%
면 626
 
3.9%
2 466
 
2.9%
3 397
 
2.5%
5 345
 
2.1%
Other values (140) 6376
39.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9507
59.1%
Decimal Number 3366
 
20.9%
Space Separator 2846
 
17.7%
Dash Punctuation 278
 
1.7%
Other Punctuation 43
 
0.3%
Open Punctuation 17
 
0.1%
Close Punctuation 17
 
0.1%
Uppercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 1414
14.9%
청 1232
 
13.0%
군 915
 
9.6%
로 818
 
8.6%
면 626
 
6.6%
신 292
 
3.1%
읍 289
 
3.0%
길 248
 
2.6%
번 234
 
2.5%
지 202
 
2.1%
Other values (122) 3237
34.0%
Decimal Number
ValueCountFrequency (%)
1 641
19.0%
2 466
13.8%
3 397
11.8%
5 345
10.2%
4 286
8.5%
6 283
8.4%
0 272
8.1%
9 247
 
7.3%
7 223
 
6.6%
8 206
 
6.1%
Other Punctuation
ValueCountFrequency (%)
, 42
97.7%
. 1
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
B 1
50.0%
Space Separator
ValueCountFrequency (%)
2846
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 278
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9507
59.1%
Common 6567
40.8%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 1414
14.9%
청 1232
 
13.0%
군 915
 
9.6%
로 818
 
8.6%
면 626
 
6.6%
신 292
 
3.1%
읍 289
 
3.0%
길 248
 
2.6%
번 234
 
2.5%
지 202
 
2.1%
Other values (122) 3237
34.0%
Common
ValueCountFrequency (%)
2846
43.3%
1 641
 
9.8%
2 466
 
7.1%
3 397
 
6.0%
5 345
 
5.3%
4 286
 
4.4%
6 283
 
4.3%
- 278
 
4.2%
0 272
 
4.1%
9 247
 
3.8%
Other values (6) 506
 
7.7%
Latin
ValueCountFrequency (%)
A 1
50.0%
B 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9507
59.1%
ASCII 6569
40.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2846
43.3%
1 641
 
9.8%
2 466
 
7.1%
3 397
 
6.0%
5 345
 
5.3%
4 286
 
4.4%
6 283
 
4.3%
- 278
 
4.2%
0 272
 
4.1%
9 247
 
3.8%
Other values (8) 508
 
7.7%
Hangul
ValueCountFrequency (%)
산 1414
14.9%
청 1232
 
13.0%
군 915
 
9.6%
로 818
 
8.6%
면 626
 
6.6%
신 292
 
3.1%
읍 289
 
3.0%
길 248
 
2.6%
번 234
 
2.5%
지 202
 
2.1%
Other values (122) 3237
34.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.3 KiB
Minimum2021-09-24 00:00:00
Maximum2021-09-24 00:00:00
2023-12-11T09:35:37.824324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:35:37.909825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T09:35:35.399299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:35:37.982912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번읍면
연번1.0000.914
읍면0.9141.000
2023-12-11T09:35:38.052347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번읍면
연번1.0000.707
읍면0.7071.000

Missing values

2023-12-11T09:35:35.523687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:35:35.632264image/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금서면cafe이팝산청군 금서면 동의보감로 150번길 1152021-09-24
12금서면가현농원산청군 금서면 동의보감로 1067, 1층2021-09-24
23금서면경호식당산청군 금서면 주상리 2352021-09-24
34금서면고속주유소산청군 금서면 친환경로 25822021-09-24
45금서면금서정미소산창군 금서면 동의보감로1029번길 822021-09-24
56금서면다담산청군 금서면 동의보감로555번길 45-52021-09-24
67금서면대장금약선관(춘산식당)산청군 금서면 친환경로2605번길 6-62021-09-24
78금서면덕진동의보감약초탕산청군 금서면 동의보감로555번길 582021-09-24
89금서면동의보감촌 푸드트럭산청군 금서면 특리 1300번지 30호2021-09-24
910금서면동의보감한의원산청군 금서면 동의보감로555번길 45-272021-09-24
연번읍면가맹점명가맹점주소데이터기준일자
905906차황면지리산곤충연구소산청군 차황면 신차로1567번길 1102021-09-24
906907차황면차황만리장성산청군 차황면 친환경로 35872021-09-24
907908차황면차황주유소산청군 차황면 신차로 17872021-09-24
908909차황면차황참기름산청군 차황면 친환경로3584번길 272021-09-24
909910차황면청산임산물영농조합법인산청군 차황면 친환경로3449번길 13-82021-09-24
910911차황면초록연구소산청군 차황면 신차로1989번길 2712021-09-24
911912차황면한방수피아산청군 차황면 신차로2006번길 192021-09-24
912913차황면황매산가든산창군 차황면 신차로 18062021-09-24
913914차황면황매산식당산청군 차황면 황매산로1202번길 2102021-09-24
914915차황면황매산영화산장산청군 차황면 황매산로1202번길 109-232021-09-24