Overview

Dataset statistics

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

Variable types

Categorical2
Text2
Numeric2

Dataset

Description경상남도 거제시 거제사랑상품권가맹점현황(가맹번호, 지역, 업종, 상호, 소재지, 위도, 경도, 기준일자)에 대한 정보를 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3080038

Alerts

기준일자 has constant value ""Constant
위도 is highly overall correlated with 지역High correlation
경도 is highly overall correlated with 지역High correlation
지역 is highly overall correlated with 위도 and 1 other fieldsHigh correlation

Reproduction

Analysis started2024-04-17 18:15:13.815551
Analysis finished2024-04-17 18:15:14.747949
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size27.0 KiB
고현동
1575 
옥포동
368 
장평동
266 
상동동
186 
아주동
181 
Other values (18)
861 

Length

Max length4
Median length3
Mean length3.0209485
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고현동
2nd row양정동
3rd row옥포동
4th row고현동
5th row고현동

Common Values

ValueCountFrequency (%)
고현동 1575
45.8%
옥포동 368
 
10.7%
장평동 266
 
7.7%
상동동 186
 
5.4%
아주동 181
 
5.3%
사등면 122
 
3.5%
수월동 108
 
3.1%
연초면 97
 
2.8%
양정동 86
 
2.5%
능포동 84
 
2.4%
Other values (13) 364
 
10.6%

Length

2024-04-18T03:15:14.800470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고현동 1575
45.8%
옥포동 368
 
10.7%
장평동 266
 
7.7%
상동동 186
 
5.4%
아주동 181
 
5.3%
사등면 122
 
3.5%
수월동 108
 
3.1%
연초면 97
 
2.8%
양정동 86
 
2.5%
능포동 84
 
2.4%
Other values (13) 364
 
10.6%
Distinct3387
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size27.0 KiB
2024-04-18T03:15:15.043125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length20
Mean length6.9543206
Min length1

Characters and Unicode

Total characters23902
Distinct characters858
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3340 ?
Unique (%)97.2%

Sample

1st row금진기업
2nd row(주)힐리스쿨
3rd row맑은샘센텀병원
4th row플레이돔
5th row정관장홍삼고현점
ValueCountFrequency (%)
씨유 75
 
1.7%
거제고현점 53
 
1.2%
거제점 50
 
1.1%
세븐일레븐 39
 
0.9%
고현점 38
 
0.9%
gs25 33
 
0.7%
주식회사 24
 
0.5%
장평점 22
 
0.5%
아주점 20
 
0.5%
거제아주점 17
 
0.4%
Other values (3643) 4069
91.6%
2024-04-18T03:15:15.414186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1003
 
4.2%
902
 
3.8%
701
 
2.9%
671
 
2.8%
413
 
1.7%
411
 
1.7%
317
 
1.3%
310
 
1.3%
271
 
1.1%
266
 
1.1%
Other values (848) 18637
78.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21278
89.0%
Space Separator 1003
 
4.2%
Uppercase Letter 511
 
2.1%
Decimal Number 280
 
1.2%
Open Punctuation 241
 
1.0%
Close Punctuation 241
 
1.0%
Lowercase Letter 200
 
0.8%
Other Punctuation 94
 
0.4%
Other Symbol 42
 
0.2%
Dash Punctuation 7
 
< 0.1%
Other values (2) 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
902
 
4.2%
701
 
3.3%
671
 
3.2%
413
 
1.9%
411
 
1.9%
317
 
1.5%
310
 
1.5%
271
 
1.3%
266
 
1.3%
251
 
1.2%
Other values (773) 16765
78.8%
Uppercase Letter
ValueCountFrequency (%)
S 75
14.7%
G 62
 
12.1%
B 36
 
7.0%
C 28
 
5.5%
M 27
 
5.3%
O 27
 
5.3%
A 27
 
5.3%
L 22
 
4.3%
D 21
 
4.1%
E 21
 
4.1%
Other values (15) 165
32.3%
Lowercase Letter
ValueCountFrequency (%)
a 26
13.0%
e 24
12.0%
o 23
11.5%
i 14
 
7.0%
l 14
 
7.0%
r 13
 
6.5%
n 12
 
6.0%
s 12
 
6.0%
t 9
 
4.5%
u 8
 
4.0%
Other values (12) 45
22.5%
Decimal Number
ValueCountFrequency (%)
2 89
31.8%
5 70
25.0%
1 29
 
10.4%
0 21
 
7.5%
4 18
 
6.4%
3 12
 
4.3%
6 12
 
4.3%
9 11
 
3.9%
7 9
 
3.2%
8 9
 
3.2%
Other Punctuation
ValueCountFrequency (%)
& 37
39.4%
. 29
30.9%
, 20
21.3%
/ 2
 
2.1%
# 2
 
2.1%
' 2
 
2.1%
; 1
 
1.1%
: 1
 
1.1%
Open Punctuation
ValueCountFrequency (%)
( 240
99.6%
[ 1
 
0.4%
Close Punctuation
ValueCountFrequency (%)
) 240
99.6%
] 1
 
0.4%
Math Symbol
ValueCountFrequency (%)
+ 3
75.0%
> 1
 
25.0%
Space Separator
ValueCountFrequency (%)
1003
100.0%
Other Symbol
ValueCountFrequency (%)
42
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21313
89.2%
Common 1871
 
7.8%
Latin 711
 
3.0%
Han 7
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
902
 
4.2%
701
 
3.3%
671
 
3.1%
413
 
1.9%
411
 
1.9%
317
 
1.5%
310
 
1.5%
271
 
1.3%
266
 
1.2%
251
 
1.2%
Other values (768) 16800
78.8%
Latin
ValueCountFrequency (%)
S 75
 
10.5%
G 62
 
8.7%
B 36
 
5.1%
C 28
 
3.9%
M 27
 
3.8%
O 27
 
3.8%
A 27
 
3.8%
a 26
 
3.7%
e 24
 
3.4%
o 23
 
3.2%
Other values (37) 356
50.1%
Common
ValueCountFrequency (%)
1003
53.6%
( 240
 
12.8%
) 240
 
12.8%
2 89
 
4.8%
5 70
 
3.7%
& 37
 
2.0%
. 29
 
1.5%
1 29
 
1.5%
0 21
 
1.1%
, 20
 
1.1%
Other values (17) 93
 
5.0%
Han
ValueCountFrequency (%)
2
28.6%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21271
89.0%
ASCII 2582
 
10.8%
None 42
 
0.2%
CJK 7
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1003
38.8%
( 240
 
9.3%
) 240
 
9.3%
2 89
 
3.4%
S 75
 
2.9%
5 70
 
2.7%
G 62
 
2.4%
& 37
 
1.4%
B 36
 
1.4%
. 29
 
1.1%
Other values (64) 701
27.1%
Hangul
ValueCountFrequency (%)
902
 
4.2%
701
 
3.3%
671
 
3.2%
413
 
1.9%
411
 
1.9%
317
 
1.5%
310
 
1.5%
271
 
1.3%
266
 
1.3%
251
 
1.2%
Other values (767) 16758
78.8%
None
ValueCountFrequency (%)
42
100.0%
CJK
ValueCountFrequency (%)
2
28.6%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
Distinct2029
Distinct (%)59.0%
Missing0
Missing (%)0.0%
Memory size27.0 KiB
2024-04-18T03:15:15.665351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length40
Mean length22.537969
Min length18

Characters and Unicode

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

Unique

Unique1587 ?
Unique (%)46.2%

Sample

1st row경상남도 거제시 계룡로 125(고현동)
2nd row경상남도 거제시 제산로 93(양정동)
3rd row경상남도 거제시 거제대로 3762(옥포동)
4th row경상남도 거제시 서문로3길 26(고현동)
5th row경상남도 거제시 계룡로 125(고현동)
ValueCountFrequency (%)
경상남도 3437
23.8%
거제시 3437
23.8%
계룡로 729
 
5.0%
125(고현동 698
 
4.8%
거제중앙로 294
 
2.0%
거제대로 130
 
0.9%
수양로 128
 
0.9%
사등면 122
 
0.8%
옥포로 102
 
0.7%
연초면 97
 
0.7%
Other values (1818) 5277
36.5%
2024-04-18T03:15:16.006676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11014
 
14.2%
4261
 
5.5%
4246
 
5.5%
3736
 
4.8%
3501
 
4.5%
3444
 
4.4%
3442
 
4.4%
3440
 
4.4%
3391
 
4.4%
3164
 
4.1%
Other values (243) 33824
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 48543
62.7%
Decimal Number 11121
 
14.4%
Space Separator 11014
 
14.2%
Open Punctuation 3008
 
3.9%
Close Punctuation 3008
 
3.9%
Dash Punctuation 537
 
0.7%
Other Punctuation 163
 
0.2%
Uppercase Letter 47
 
0.1%
Lowercase Letter 22
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
4261
 
8.8%
4246
 
8.7%
3736
 
7.7%
3501
 
7.2%
3444
 
7.1%
3442
 
7.1%
3440
 
7.1%
3391
 
7.0%
3164
 
6.5%
1814
 
3.7%
Other values (211) 14104
29.1%
Decimal Number
ValueCountFrequency (%)
1 2941
26.4%
2 1895
17.0%
5 1481
13.3%
3 989
 
8.9%
4 899
 
8.1%
8 672
 
6.0%
7 583
 
5.2%
6 579
 
5.2%
9 546
 
4.9%
0 536
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
K 9
19.1%
I 8
17.0%
R 8
17.0%
P 8
17.0%
A 8
17.0%
C 3
 
6.4%
H 1
 
2.1%
S 1
 
2.1%
B 1
 
2.1%
Lowercase Letter
ValueCountFrequency (%)
e 12
54.5%
l 5
22.7%
v 1
 
4.5%
r 1
 
4.5%
y 1
 
4.5%
i 1
 
4.5%
s 1
 
4.5%
Other Punctuation
ValueCountFrequency (%)
, 162
99.4%
. 1
 
0.6%
Space Separator
ValueCountFrequency (%)
11014
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3008
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3008
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 537
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 48542
62.7%
Common 28851
37.2%
Latin 69
 
0.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
4261
 
8.8%
4246
 
8.7%
3736
 
7.7%
3501
 
7.2%
3444
 
7.1%
3442
 
7.1%
3440
 
7.1%
3391
 
7.0%
3164
 
6.5%
1814
 
3.7%
Other values (210) 14103
29.1%
Common
ValueCountFrequency (%)
11014
38.2%
( 3008
 
10.4%
) 3008
 
10.4%
1 2941
 
10.2%
2 1895
 
6.6%
5 1481
 
5.1%
3 989
 
3.4%
4 899
 
3.1%
8 672
 
2.3%
7 583
 
2.0%
Other values (6) 2361
 
8.2%
Latin
ValueCountFrequency (%)
e 12
17.4%
K 9
13.0%
I 8
11.6%
R 8
11.6%
P 8
11.6%
A 8
11.6%
l 5
7.2%
C 3
 
4.3%
H 1
 
1.4%
S 1
 
1.4%
Other values (6) 6
8.7%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 48542
62.7%
ASCII 28920
37.3%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11014
38.1%
( 3008
 
10.4%
) 3008
 
10.4%
1 2941
 
10.2%
2 1895
 
6.6%
5 1481
 
5.1%
3 989
 
3.4%
4 899
 
3.1%
8 672
 
2.3%
7 583
 
2.0%
Other values (22) 2430
 
8.4%
Hangul
ValueCountFrequency (%)
4261
 
8.8%
4246
 
8.7%
3736
 
7.7%
3501
 
7.2%
3444
 
7.1%
3442
 
7.1%
3440
 
7.1%
3391
 
7.0%
3164
 
6.5%
1814
 
3.7%
Other values (210) 14103
29.1%
CJK
ValueCountFrequency (%)
1
100.0%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct2028
Distinct (%)59.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.883998
Minimum34.733405
Maximum35.004879
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.3 KiB
2024-04-18T03:15:16.119375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.733405
5-th percentile34.852491
Q134.880554
median34.885382
Q334.89246
95-th percentile34.908051
Maximum35.004879
Range0.27147456
Interquartile range (IQR)0.01190652

Descriptive statistics

Standard deviation0.020522481
Coefficient of variation (CV)0.00058830646
Kurtosis11.490339
Mean34.883998
Median Absolute Deviation (MAD)0.0066061
Skewness-0.26095623
Sum119896.3
Variance0.00042117223
MonotonicityNot monotonic
2024-04-18T03:15:16.224132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34.88055359 698
 
20.3%
34.88820174 11
 
0.3%
34.89026208 10
 
0.3%
34.89086026 9
 
0.3%
34.88625409 8
 
0.2%
34.8898048 8
 
0.2%
34.88732595 8
 
0.2%
34.89626152 8
 
0.2%
34.8938292 8
 
0.2%
34.86772443 8
 
0.2%
Other values (2018) 2661
77.4%
ValueCountFrequency (%)
34.73340451 1
< 0.1%
34.73762473 1
< 0.1%
34.73824981 2
0.1%
34.74331041 1
< 0.1%
34.77107254 1
< 0.1%
34.77303557 1
< 0.1%
34.77330306 1
< 0.1%
34.77395734 1
< 0.1%
34.77592623 1
< 0.1%
34.7764196 1
< 0.1%
ValueCountFrequency (%)
35.00487907 1
< 0.1%
34.99871986 1
< 0.1%
34.99575924 1
< 0.1%
34.99126474 1
< 0.1%
34.99091284 1
< 0.1%
34.990874 2
0.1%
34.99077954 1
< 0.1%
34.98877008 1
< 0.1%
34.9884155 1
< 0.1%
34.98836679 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct2026
Distinct (%)58.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.63865
Minimum128.47285
Maximum128.73704
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.3 KiB
2024-04-18T03:15:16.333620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.47285
5-th percentile128.58931
Q1128.62077
median128.62483
Q3128.6557
95-th percentile128.71825
Maximum128.73704
Range0.2641934
Interquartile range (IQR)0.0349336

Descriptive statistics

Standard deviation0.041504802
Coefficient of variation (CV)0.00032264643
Kurtosis1.6370394
Mean128.63865
Median Absolute Deviation (MAD)0.0084199
Skewness-0.037708199
Sum442131.05
Variance0.0017226486
MonotonicityNot monotonic
2024-04-18T03:15:16.468669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.6207681 698
 
20.3%
128.6235608 11
 
0.3%
128.6243422 10
 
0.3%
128.6131107 9
 
0.3%
128.6300914 8
 
0.2%
128.6238277 8
 
0.2%
128.6501964 8
 
0.2%
128.6230401 8
 
0.2%
128.6221069 8
 
0.2%
128.6304055 8
 
0.2%
Other values (2016) 2661
77.4%
ValueCountFrequency (%)
128.4728484 1
< 0.1%
128.4768365 1
< 0.1%
128.4768869 1
< 0.1%
128.4769042 1
< 0.1%
128.4769296 1
< 0.1%
128.4770539 1
< 0.1%
128.4771978 1
< 0.1%
128.4772536 1
< 0.1%
128.4772779 1
< 0.1%
128.4773091 1
< 0.1%
ValueCountFrequency (%)
128.7370418 1
< 0.1%
128.7369813 1
< 0.1%
128.7369205 1
< 0.1%
128.7360297 1
< 0.1%
128.7350275 1
< 0.1%
128.7349456 2
0.1%
128.7337525 1
< 0.1%
128.7333228 1
< 0.1%
128.7332324 1
< 0.1%
128.7329694 1
< 0.1%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size27.0 KiB
2022-09-16
3437 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-09-16
2nd row2022-09-16
3rd row2022-09-16
4th row2022-09-16
5th row2022-09-16

Common Values

ValueCountFrequency (%)
2022-09-16 3437
100.0%

Length

2024-04-18T03:15:16.564571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T03:15:16.634094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-09-16 3437
100.0%

Interactions

2024-04-18T03:15:14.477882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T03:15:14.343147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T03:15:14.546650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T03:15:14.408996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-18T03:15:16.675081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역위도경도
지역1.0000.9320.932
위도0.9321.0000.713
경도0.9320.7131.000
2024-04-18T03:15:16.739075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도지역
위도1.000-0.0120.703
경도-0.0121.0000.702
지역0.7030.7021.000

Missing values

2024-04-18T03:15:14.634020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-18T03:15:14.711959image/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고현동금진기업경상남도 거제시 계룡로 125(고현동)34.880554128.6207682022-09-16
1양정동(주)힐리스쿨경상남도 거제시 제산로 93(양정동)34.886489128.6442032022-09-16
2옥포동맑은샘센텀병원경상남도 거제시 거제대로 3762(옥포동)34.892094128.6889182022-09-16
3고현동플레이돔경상남도 거제시 서문로3길 26(고현동)34.890536128.618482022-09-16
4고현동정관장홍삼고현점경상남도 거제시 계룡로 125(고현동)34.880554128.6207682022-09-16
5수월동신쭈꾸(수월점)경상남도 거제시 수양로 454-6(수월동)34.893102128.6415852022-09-16
6고현동보배반점 거제고현점경상남도 거제시 거제중앙로 1930-10(고현동, 고현동주상복합아파트)34.890233128.623042022-09-16
7장평동아이비경상남도 거제시 장평2로 36(장평동, 장평3주공아파트)34.885428128.6088362022-09-16
8사등면안성한의원경상남도 거제시 사등면 거제남서로 534234.88284128.4782532022-09-16
9거제면별이네농산경상남도 거제시 거제면 외간1길 5234.860821128.5729362022-09-16
지역가맹점명소재지위도경도기준일자
3427장평동컨츄리꼬꼬경상남도 거제시 장평3로4길 39(장평동)34.890723128.613462022-09-16
3428사등면고릴라 캠핑 거제점경상남도 거제시 사등면 거제대로 529434.900689128.5623482022-09-16
3429장평동파파존스 거제점경상남도 거제시 장평로8길 23(장평동)34.892472128.6098512022-09-16
3430수월동거제와이즈만영재학원경상남도 거제시 수양로 463(수월동)34.892053128.6404612022-09-16
3431덕포동와이즈만서적경상남도 거제시 옥포대첩로 409-7(덕포동)34.914267128.7128622022-09-16
3432상동동거제상동와이즈만영재학원경상남도 거제시 상동5길 75-40(상동동, 벽산e-솔렌스힐 1차)34.86127128.6331562022-09-16
3433고현동지바(G.bar)경상남도 거제시 중곡로1길 18-3(고현동)34.893404128.628712022-09-16
3434고현동황금조명경상남도 거제시 고현로 90(고현동)34.886295128.6227482022-09-16
3435옥포동못난이꽈배기경상남도 거제시 옥포로21길 3(옥포동)34.894736128.6904172022-09-16
3436아주동㈜대우남문기타경상남도 거제시 아주1로2길 45(아주동)34.866629128.687132022-09-16