Overview

Dataset statistics

Number of variables6
Number of observations945
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory45.3 KiB
Average record size in memory49.1 B

Variable types

Numeric1
Categorical3
Text2

Dataset

Description경상남도 함양군의 지역상품권인 함양사랑상품권을 취급하는 가맹점 현황으로 연번, 소재지, 상호명, 주소(도로명주소), 업종, 데이터기준일자 형식으로 구성되어있음
Author경상남도 함양군
URLhttps://www.data.go.kr/data/15064776/fileData.do

Alerts

데이터기준일 has constant value ""Constant
소재지 is highly imbalanced (50.0%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:58:37.272238
Analysis finished2023-12-12 19:58:38.448823
Duration1.18 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct945
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean473
Minimum1
Maximum945
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.4 KiB
2023-12-13T04:58:38.552316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile48.2
Q1237
median473
Q3709
95-th percentile897.8
Maximum945
Range944
Interquartile range (IQR)472

Descriptive statistics

Standard deviation272.9423
Coefficient of variation (CV)0.57704504
Kurtosis-1.2
Mean473
Median Absolute Deviation (MAD)236
Skewness0
Sum446985
Variance74497.5
MonotonicityStrictly increasing
2023-12-13T04:58:38.773737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
636 1
 
0.1%
624 1
 
0.1%
625 1
 
0.1%
626 1
 
0.1%
627 1
 
0.1%
628 1
 
0.1%
629 1
 
0.1%
630 1
 
0.1%
631 1
 
0.1%
Other values (935) 935
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 (%)
945 1
0.1%
944 1
0.1%
943 1
0.1%
942 1
0.1%
941 1
0.1%
940 1
0.1%
939 1
0.1%
938 1
0.1%
937 1
0.1%
936 1
0.1%

소재지
Categorical

IMBALANCE 

Distinct11
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
함양읍
668 
안의면
90 
마천면
 
43
서상면
 
38
수동면
 
22
Other values (6)
84 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row함양읍
2nd row함양읍
3rd row병곡면
4th row함양읍
5th row함양읍

Common Values

ValueCountFrequency (%)
함양읍 668
70.7%
안의면 90
 
9.5%
마천면 43
 
4.6%
서상면 38
 
4.0%
수동면 22
 
2.3%
서하면 21
 
2.2%
지곡면 15
 
1.6%
백전면 15
 
1.6%
병곡면 12
 
1.3%
유림면 11
 
1.2%

Length

2023-12-13T04:58:38.930784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
함양읍 668
70.7%
안의면 90
 
9.5%
마천면 43
 
4.6%
서상면 38
 
4.0%
수동면 22
 
2.3%
서하면 21
 
2.2%
지곡면 15
 
1.6%
백전면 15
 
1.6%
병곡면 12
 
1.3%
유림면 11
 
1.2%

상호명
Text

Distinct940
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2023-12-13T04:58:39.271479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length19
Mean length6.2137566
Min length1

Characters and Unicode

Total characters5872
Distinct characters587
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

Unique938 ?
Unique (%)99.3%

Sample

1st row역전할머니맥주
2nd row삼성치과의원
3rd row함양군청 대봉산휴양밸리 대봉스카이랜드
4th row불맛짬뽕
5th row쏘맥
ValueCountFrequency (%)
함양점 19
 
1.7%
씨유 6
 
0.5%
주식회사 5
 
0.5%
함양농협 5
 
0.5%
카페 4
 
0.4%
세븐일레븐 4
 
0.4%
외판 4
 
0.4%
아모레 4
 
0.4%
함양 4
 
0.4%
지리산 3
 
0.3%
Other values (1027) 1036
94.7%
2023-12-13T04:58:39.904390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
양 178
 
3.0%
함 155
 
2.6%
149
 
2.5%
점 130
 
2.2%
산 111
 
1.9%
식 103
 
1.8%
지 92
 
1.6%
농 91
 
1.5%
리 88
 
1.5%
마 74
 
1.3%
Other values (577) 4701
80.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5465
93.1%
Space Separator 149
 
2.5%
Uppercase Letter 63
 
1.1%
Open Punctuation 56
 
1.0%
Close Punctuation 56
 
1.0%
Decimal Number 34
 
0.6%
Lowercase Letter 29
 
0.5%
Other Punctuation 12
 
0.2%
Other Symbol 7
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 178
 
3.3%
함 155
 
2.8%
점 130
 
2.4%
산 111
 
2.0%
식 103
 
1.9%
지 92
 
1.7%
농 91
 
1.7%
리 88
 
1.6%
마 74
 
1.4%
원 73
 
1.3%
Other values (527) 4370
80.0%
Uppercase Letter
ValueCountFrequency (%)
C 8
12.7%
S 6
 
9.5%
G 6
 
9.5%
T 4
 
6.3%
A 4
 
6.3%
L 4
 
6.3%
D 4
 
6.3%
E 4
 
6.3%
O 3
 
4.8%
J 3
 
4.8%
Other values (10) 17
27.0%
Lowercase Letter
ValueCountFrequency (%)
e 6
20.7%
t 5
17.2%
a 4
13.8%
i 3
10.3%
c 2
 
6.9%
s 2
 
6.9%
k 2
 
6.9%
r 1
 
3.4%
l 1
 
3.4%
n 1
 
3.4%
Other values (2) 2
 
6.9%
Decimal Number
ValueCountFrequency (%)
0 11
32.4%
1 7
20.6%
2 6
17.6%
5 5
14.7%
4 3
 
8.8%
3 1
 
2.9%
6 1
 
2.9%
Other Punctuation
ValueCountFrequency (%)
, 3
25.0%
. 3
25.0%
& 3
25.0%
# 1
 
8.3%
! 1
 
8.3%
' 1
 
8.3%
Space Separator
ValueCountFrequency (%)
149
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5472
93.2%
Common 308
 
5.2%
Latin 92
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 178
 
3.3%
함 155
 
2.8%
점 130
 
2.4%
산 111
 
2.0%
식 103
 
1.9%
지 92
 
1.7%
농 91
 
1.7%
리 88
 
1.6%
마 74
 
1.4%
원 73
 
1.3%
Other values (528) 4377
80.0%
Latin
ValueCountFrequency (%)
C 8
 
8.7%
e 6
 
6.5%
S 6
 
6.5%
G 6
 
6.5%
t 5
 
5.4%
T 4
 
4.3%
A 4
 
4.3%
L 4
 
4.3%
D 4
 
4.3%
E 4
 
4.3%
Other values (22) 41
44.6%
Common
ValueCountFrequency (%)
149
48.4%
( 56
 
18.2%
) 56
 
18.2%
0 11
 
3.6%
1 7
 
2.3%
2 6
 
1.9%
5 5
 
1.6%
, 3
 
1.0%
4 3
 
1.0%
. 3
 
1.0%
Other values (7) 9
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5465
93.1%
ASCII 400
 
6.8%
None 7
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
양 178
 
3.3%
함 155
 
2.8%
점 130
 
2.4%
산 111
 
2.0%
식 103
 
1.9%
지 92
 
1.7%
농 91
 
1.7%
리 88
 
1.6%
마 74
 
1.4%
원 73
 
1.3%
Other values (527) 4370
80.0%
ASCII
ValueCountFrequency (%)
149
37.2%
( 56
 
14.0%
) 56
 
14.0%
0 11
 
2.8%
C 8
 
2.0%
1 7
 
1.8%
e 6
 
1.5%
S 6
 
1.5%
2 6
 
1.5%
G 6
 
1.5%
Other values (39) 89
22.2%
None
ValueCountFrequency (%)
㈜ 7
100.0%

주소
Text

Distinct719
Distinct (%)76.1%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2023-12-13T04:58:40.336912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length31
Mean length21.055026
Min length18

Characters and Unicode

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

Unique

Unique572 ?
Unique (%)60.5%

Sample

1st row경상남도 함양군 함양읍 고운로 66
2nd row경상남도 함양군 함양읍 고운로 97
3rd row경상남도 함양군 병곡면 병곡지곡로 331
4th row경상남도 함양군 함양읍 필봉산길 106
5th row경상남도 함양군 함양읍 용평1길 3
ValueCountFrequency (%)
경상남도 945
19.9%
함양군 945
19.9%
함양읍 668
14.1%
함양로 154
 
3.2%
안의면 90
 
1.9%
고운로 87
 
1.8%
용평중앙길 67
 
1.4%
중앙시장길 51
 
1.1%
마천면 43
 
0.9%
서상면 38
 
0.8%
Other values (620) 1655
34.9%
2023-12-13T04:58:40.900868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3798
19.1%
함 1811
 
9.1%
양 1809
 
9.1%
상 1033
 
5.2%
남 970
 
4.9%
군 949
 
4.8%
경 946
 
4.8%
도 946
 
4.8%
1 862
 
4.3%
읍 669
 
3.4%
Other values (153) 6104
30.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12986
65.3%
Space Separator 3798
 
19.1%
Decimal Number 2796
 
14.1%
Dash Punctuation 275
 
1.4%
Open Punctuation 21
 
0.1%
Close Punctuation 21
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
함 1811
13.9%
양 1809
13.9%
상 1033
 
8.0%
남 970
 
7.5%
군 949
 
7.3%
경 946
 
7.3%
도 946
 
7.3%
읍 669
 
5.2%
길 497
 
3.8%
로 461
 
3.5%
Other values (139) 2895
22.3%
Decimal Number
ValueCountFrequency (%)
1 862
30.8%
2 370
13.2%
3 314
 
11.2%
5 226
 
8.1%
4 222
 
7.9%
9 173
 
6.2%
7 172
 
6.2%
6 171
 
6.1%
8 146
 
5.2%
0 140
 
5.0%
Space Separator
ValueCountFrequency (%)
3798
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 275
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12986
65.3%
Common 6911
34.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
함 1811
13.9%
양 1809
13.9%
상 1033
 
8.0%
남 970
 
7.5%
군 949
 
7.3%
경 946
 
7.3%
도 946
 
7.3%
읍 669
 
5.2%
길 497
 
3.8%
로 461
 
3.5%
Other values (139) 2895
22.3%
Common
ValueCountFrequency (%)
3798
55.0%
1 862
 
12.5%
2 370
 
5.4%
3 314
 
4.5%
- 275
 
4.0%
5 226
 
3.3%
4 222
 
3.2%
9 173
 
2.5%
7 172
 
2.5%
6 171
 
2.5%
Other values (4) 328
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12986
65.3%
ASCII 6911
34.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3798
55.0%
1 862
 
12.5%
2 370
 
5.4%
3 314
 
4.5%
- 275
 
4.0%
5 226
 
3.3%
4 222
 
3.2%
9 173
 
2.5%
7 172
 
2.5%
6 171
 
2.5%
Other values (4) 328
 
4.7%
Hangul
ValueCountFrequency (%)
함 1811
13.9%
양 1809
13.9%
상 1033
 
8.0%
남 970
 
7.5%
군 949
 
7.3%
경 946
 
7.3%
도 946
 
7.3%
읍 669
 
5.2%
길 497
 
3.8%
로 461
 
3.5%
Other values (139) 2895
22.3%

업종
Categorical

Distinct8
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
소매업
401 
음식점업
318 
제조업
63 
기타
57 
개인서비스업
56 
Other values (3)
50 

Length

Max length6
Median length3
Mean length3.5047619
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row음식점업
2nd row보건업
3rd row기타
4th row음식점업
5th row음식점업

Common Values

ValueCountFrequency (%)
소매업 401
42.4%
음식점업 318
33.7%
제조업 63
 
6.7%
기타 57
 
6.0%
개인서비스업 56
 
5.9%
보건업 27
 
2.9%
교육서비스업 16
 
1.7%
숙박업 7
 
0.7%

Length

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

Common Values (Plot)

2023-12-13T04:58:41.262960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소매업 401
42.4%
음식점업 318
33.7%
제조업 63
 
6.7%
기타 57
 
6.0%
개인서비스업 56
 
5.9%
보건업 27
 
2.9%
교육서비스업 16
 
1.7%
숙박업 7
 
0.7%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2021-09-06
945 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-06
2nd row2021-09-06
3rd row2021-09-06
4th row2021-09-06
5th row2021-09-06

Common Values

ValueCountFrequency (%)
2021-09-06 945
100.0%

Length

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

Common Values (Plot)

2023-12-13T04:58:41.545802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-06 945
100.0%

Interactions

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

Correlations

2023-12-13T04:58:41.607885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소재지업종
연번1.0000.3530.210
소재지0.3531.0000.351
업종0.2100.3511.000
2023-12-13T04:58:41.712005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종소재지
업종1.0000.173
소재지0.1731.000
2023-12-13T04:58:41.820038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소재지업종
연번1.0000.1580.101
소재지0.1581.0000.173
업종0.1010.1731.000

Missing values

2023-12-13T04:58:38.242802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:58:38.391929image/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함양읍역전할머니맥주경상남도 함양군 함양읍 고운로 66음식점업2021-09-06
12함양읍삼성치과의원경상남도 함양군 함양읍 고운로 97보건업2021-09-06
23병곡면함양군청 대봉산휴양밸리 대봉스카이랜드경상남도 함양군 병곡면 병곡지곡로 331기타2021-09-06
34함양읍불맛짬뽕경상남도 함양군 함양읍 필봉산길 106음식점업2021-09-06
45함양읍쏘맥경상남도 함양군 함양읍 용평1길 3음식점업2021-09-06
56함양읍고봉민김밥경상남도 함양군 함양읍 교산3길 3음식점업2021-09-06
67함양읍고운주유소경상남도 함양군 함양읍 고운로 226소매업2021-09-06
78함양읍평화약국경상남도 함양군 함양읍 한들로 143소매업2021-09-06
89안의면천궁 산장식당경상남도 함양군 안의면 용추계곡로 519음식점업2021-09-06
910안의면파란지붕경상남도 함양군 안의면 금성길 11음식점업2021-09-06
연번소재지상호명주소업종데이터기준일
935936함양읍은다래학원경상남도 함양군 함양읍 함양로 1158교육서비스업2021-09-06
936937함양읍킴스경상남도 함양군 함양읍 고운로 58-1음식점업2021-09-06
937938함양읍하얏트사우나호텔경상남도 함양군 함양읍 용평길 31-6기타2021-09-06
938939함양읍한울경상남도 함양군 함양읍 뇌계길 6음식점업2021-09-06
939940함양읍동신가정의학과경상남도 함양군 함양읍 용평중앙길 10-1보건업2021-09-06
940941함양읍이른비학원경상남도 함양군 함양읍 함양로 1194교육서비스업2021-09-06
941942안의면마메들다육이경상남도 함양군 안의면 거안로 395소매업2021-09-06
942943유림면유림식당경상남도 함양군 유림면 천왕봉로 2878음식점업2021-09-06
943944안의면미송갈비탕경상남도 함양군 안의면 광풍로 127-1음식점업2021-09-06
944945백전면누리는농부경상남도 함양군 백전면 오매실길 147-61소매업2021-09-06