Overview

Dataset statistics

Number of variables6
Number of observations631
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory30.3 KiB
Average record size in memory49.2 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description진안군 관내 진안고원행복상품권 가맹점 현황에 대한 데이터로 가맹점명, 대표자, 주소, 업종에 대한 정보를 제공합니다.
Author전라북도 진안군
URLhttps://www.data.go.kr/data/15065459/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:09:27.087655
Analysis finished2023-12-12 10:09:28.162137
Duration1.07 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct631
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean316
Minimum1
Maximum631
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.7 KiB
2023-12-12T19:09:28.261149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile32.5
Q1158.5
median316
Q3473.5
95-th percentile599.5
Maximum631
Range630
Interquartile range (IQR)315

Descriptive statistics

Standard deviation182.29829
Coefficient of variation (CV)0.57689332
Kurtosis-1.2
Mean316
Median Absolute Deviation (MAD)158
Skewness0
Sum199396
Variance33232.667
MonotonicityStrictly increasing
2023-12-12T19:09:28.487375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
425 1
 
0.2%
418 1
 
0.2%
419 1
 
0.2%
420 1
 
0.2%
421 1
 
0.2%
422 1
 
0.2%
423 1
 
0.2%
424 1
 
0.2%
426 1
 
0.2%
Other values (621) 621
98.4%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
631 1
0.2%
630 1
0.2%
629 1
0.2%
628 1
0.2%
627 1
0.2%
626 1
0.2%
625 1
0.2%
624 1
0.2%
623 1
0.2%
622 1
0.2%
Distinct627
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2023-12-12T19:09:28.754536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length6.0744849
Min length2

Characters and Unicode

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

Unique

Unique623 ?
Unique (%)98.7%

Sample

1st row구구식당
2nd row농산표고
3rd row대광천막
4th row뚝배기
5th row목화이불집
ValueCountFrequency (%)
진안점 8
 
1.1%
진안 6
 
0.8%
홍삼 5
 
0.7%
마이산 3
 
0.4%
농업회사법인 3
 
0.4%
흑돼지 3
 
0.4%
왕다리분식 2
 
0.3%
2
 
0.3%
진안농협 2
 
0.3%
주식회사 2
 
0.3%
Other values (675) 683
95.0%
2023-12-12T19:09:29.274878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
126
 
3.3%
121
 
3.2%
91
 
2.4%
89
 
2.3%
79
 
2.1%
78
 
2.0%
69
 
1.8%
62
 
1.6%
52
 
1.4%
52
 
1.4%
Other values (463) 3014
78.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3610
94.2%
Space Separator 89
 
2.3%
Close Punctuation 35
 
0.9%
Open Punctuation 35
 
0.9%
Uppercase Letter 24
 
0.6%
Decimal Number 21
 
0.5%
Lowercase Letter 11
 
0.3%
Other Symbol 3
 
0.1%
Other Punctuation 3
 
0.1%
Dash Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
126
 
3.5%
121
 
3.4%
91
 
2.5%
79
 
2.2%
78
 
2.2%
69
 
1.9%
62
 
1.7%
52
 
1.4%
52
 
1.4%
50
 
1.4%
Other values (429) 2830
78.4%
Uppercase Letter
ValueCountFrequency (%)
C 4
16.7%
A 2
 
8.3%
G 2
 
8.3%
H 2
 
8.3%
M 2
 
8.3%
B 2
 
8.3%
Y 2
 
8.3%
S 1
 
4.2%
D 1
 
4.2%
T 1
 
4.2%
Other values (5) 5
20.8%
Decimal Number
ValueCountFrequency (%)
7 5
23.8%
1 4
19.0%
3 4
19.0%
2 3
14.3%
5 3
14.3%
8 2
 
9.5%
Lowercase Letter
ValueCountFrequency (%)
e 3
27.3%
a 2
18.2%
c 2
18.2%
f 2
18.2%
o 1
 
9.1%
m 1
 
9.1%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
, 1
33.3%
Space Separator
ValueCountFrequency (%)
89
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Other Symbol
ValueCountFrequency (%)
3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3612
94.2%
Common 185
 
4.8%
Latin 35
 
0.9%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
126
 
3.5%
121
 
3.3%
91
 
2.5%
79
 
2.2%
78
 
2.2%
69
 
1.9%
62
 
1.7%
52
 
1.4%
52
 
1.4%
50
 
1.4%
Other values (429) 2832
78.4%
Latin
ValueCountFrequency (%)
C 4
 
11.4%
e 3
 
8.6%
a 2
 
5.7%
c 2
 
5.7%
f 2
 
5.7%
A 2
 
5.7%
G 2
 
5.7%
H 2
 
5.7%
M 2
 
5.7%
B 2
 
5.7%
Other values (11) 12
34.3%
Common
ValueCountFrequency (%)
89
48.1%
) 35
 
18.9%
( 35
 
18.9%
7 5
 
2.7%
1 4
 
2.2%
3 4
 
2.2%
2 3
 
1.6%
5 3
 
1.6%
8 2
 
1.1%
- 2
 
1.1%
Other values (2) 3
 
1.6%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3609
94.2%
ASCII 220
 
5.7%
None 3
 
0.1%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
126
 
3.5%
121
 
3.4%
91
 
2.5%
79
 
2.2%
78
 
2.2%
69
 
1.9%
62
 
1.7%
52
 
1.4%
52
 
1.4%
50
 
1.4%
Other values (428) 2829
78.4%
ASCII
ValueCountFrequency (%)
89
40.5%
) 35
 
15.9%
( 35
 
15.9%
7 5
 
2.3%
1 4
 
1.8%
C 4
 
1.8%
3 4
 
1.8%
2 3
 
1.4%
e 3
 
1.4%
5 3
 
1.4%
Other values (23) 35
 
15.9%
None
ValueCountFrequency (%)
3
100.0%
CJK
ValueCountFrequency (%)
1
100.0%
Distinct578
Distinct (%)91.6%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2023-12-12T19:09:29.712821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length3
Mean length3.0142631
Min length2

Characters and Unicode

Total characters1902
Distinct characters192
Distinct categories4 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique551 ?
Unique (%)87.3%

Sample

1st row강남순
2nd row양점자
3rd row장혁
4th row김용란
5th row박순덕
ValueCountFrequency (%)
허남규 16
 
2.5%
김영배 6
 
0.9%
신용빈 6
 
0.9%
손종엽 4
 
0.6%
박도영 3
 
0.5%
강산도 3
 
0.5%
이영숙 2
 
0.3%
강종민 2
 
0.3%
강순복 2
 
0.3%
서병호 2
 
0.3%
Other values (570) 587
92.7%
2023-12-12T19:09:30.277392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
115
 
6.0%
85
 
4.5%
71
 
3.7%
71
 
3.7%
59
 
3.1%
54
 
2.8%
35
 
1.8%
35
 
1.8%
34
 
1.8%
33
 
1.7%
Other values (182) 1310
68.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1881
98.9%
Uppercase Letter 17
 
0.9%
Space Separator 2
 
0.1%
Decimal Number 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
115
 
6.1%
85
 
4.5%
71
 
3.8%
71
 
3.8%
59
 
3.1%
54
 
2.9%
35
 
1.9%
35
 
1.9%
34
 
1.8%
33
 
1.8%
Other values (172) 1289
68.5%
Uppercase Letter
ValueCountFrequency (%)
I 5
29.4%
N 4
23.5%
J 3
17.6%
F 1
 
5.9%
Z 1
 
5.9%
E 1
 
5.9%
G 1
 
5.9%
L 1
 
5.9%
Space Separator
ValueCountFrequency (%)
2
100.0%
Decimal Number
ValueCountFrequency (%)
1 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1881
98.9%
Latin 17
 
0.9%
Common 4
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
115
 
6.1%
85
 
4.5%
71
 
3.8%
71
 
3.8%
59
 
3.1%
54
 
2.9%
35
 
1.9%
35
 
1.9%
34
 
1.8%
33
 
1.8%
Other values (172) 1289
68.5%
Latin
ValueCountFrequency (%)
I 5
29.4%
N 4
23.5%
J 3
17.6%
F 1
 
5.9%
Z 1
 
5.9%
E 1
 
5.9%
G 1
 
5.9%
L 1
 
5.9%
Common
ValueCountFrequency (%)
2
50.0%
1 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1881
98.9%
ASCII 21
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
115
 
6.1%
85
 
4.5%
71
 
3.8%
71
 
3.8%
59
 
3.1%
54
 
2.9%
35
 
1.9%
35
 
1.9%
34
 
1.8%
33
 
1.8%
Other values (172) 1289
68.5%
ASCII
ValueCountFrequency (%)
I 5
23.8%
N 4
19.0%
J 3
14.3%
2
 
9.5%
1 2
 
9.5%
F 1
 
4.8%
Z 1
 
4.8%
E 1
 
4.8%
G 1
 
4.8%
L 1
 
4.8%
Distinct492
Distinct (%)78.0%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2023-12-12T19:09:30.555854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length24
Mean length15.930269
Min length9

Characters and Unicode

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

Unique

Unique422 ?
Unique (%)66.9%

Sample

1st row진안군 진안읍 시장1길 16
2nd row진안군 진안읍 시장1길 16
3rd row진안군 진안읍 시장1길 16
4th row진안군 진안읍 시장1길 16
5th row진안군 진안읍 시장1길 16
ValueCountFrequency (%)
진안군 586
23.1%
진안읍 427
 
16.9%
진무로 145
 
5.7%
시장1길 59
 
2.3%
16 54
 
2.1%
중앙로 50
 
2.0%
마령면 43
 
1.7%
부귀면 36
 
1.4%
임진로 31
 
1.2%
진용로 30
 
1.2%
Other values (520) 1072
42.3%
2023-12-12T19:09:31.080666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1905
19.0%
1281
12.7%
1042
 
10.4%
1 719
 
7.2%
602
 
6.0%
428
 
4.3%
423
 
4.2%
2 277
 
2.8%
202
 
2.0%
0 201
 
2.0%
Other values (129) 2972
29.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5824
57.9%
Decimal Number 2113
 
21.0%
Space Separator 1905
 
19.0%
Dash Punctuation 184
 
1.8%
Other Punctuation 25
 
0.2%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1281
22.0%
1042
17.9%
602
10.3%
428
 
7.3%
423
 
7.3%
202
 
3.5%
182
 
3.1%
145
 
2.5%
112
 
1.9%
79
 
1.4%
Other values (115) 1328
22.8%
Decimal Number
ValueCountFrequency (%)
1 719
34.0%
2 277
 
13.1%
0 201
 
9.5%
6 188
 
8.9%
3 159
 
7.5%
9 127
 
6.0%
7 127
 
6.0%
4 113
 
5.3%
8 105
 
5.0%
5 97
 
4.6%
Space Separator
ValueCountFrequency (%)
1905
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 184
100.0%
Other Punctuation
ValueCountFrequency (%)
, 25
100.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5824
57.9%
Common 4227
42.1%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1281
22.0%
1042
17.9%
602
10.3%
428
 
7.3%
423
 
7.3%
202
 
3.5%
182
 
3.1%
145
 
2.5%
112
 
1.9%
79
 
1.4%
Other values (115) 1328
22.8%
Common
ValueCountFrequency (%)
1905
45.1%
1 719
 
17.0%
2 277
 
6.6%
0 201
 
4.8%
6 188
 
4.4%
- 184
 
4.4%
3 159
 
3.8%
9 127
 
3.0%
7 127
 
3.0%
4 113
 
2.7%
Other values (3) 227
 
5.4%
Latin
ValueCountFrequency (%)
D 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5824
57.9%
ASCII 4228
42.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1905
45.1%
1 719
 
17.0%
2 277
 
6.6%
0 201
 
4.8%
6 188
 
4.4%
- 184
 
4.4%
3 159
 
3.8%
9 127
 
3.0%
7 127
 
3.0%
4 113
 
2.7%
Other values (4) 228
 
5.4%
Hangul
ValueCountFrequency (%)
1281
22.0%
1042
17.9%
602
10.3%
428
 
7.3%
423
 
7.3%
202
 
3.5%
182
 
3.1%
145
 
2.5%
112
 
1.9%
79
 
1.4%
Other values (115) 1328
22.8%

업종
Text

Distinct380
Distinct (%)60.2%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2023-12-12T19:09:31.399993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length8.0824089
Min length2

Characters and Unicode

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

Unique

Unique316 ?
Unique (%)50.1%

Sample

1st row음식(한식)
2nd row소매(농산물)
3rd row도·소매임대(천막제작,잡화,천막대여)
4th row음식(한식)
5th row소매(침구)
ValueCountFrequency (%)
일반음식점 58
 
8.2%
음식(한식 35
 
5.0%
음식점(한식 14
 
2.0%
도소매 12
 
1.7%
소매(식잡 12
 
1.7%
10
 
1.4%
음식점업(한식 9
 
1.3%
9
 
1.3%
서비스(미용실 8
 
1.1%
음식(일반음식 8
 
1.1%
Other values (389) 532
75.2%
2023-12-12T19:09:32.216061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 486
 
9.5%
) 486
 
9.5%
393
 
7.7%
293
 
5.7%
292
 
5.7%
255
 
5.0%
236
 
4.6%
, 185
 
3.6%
158
 
3.1%
101
 
2.0%
Other values (242) 2215
43.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3854
75.6%
Open Punctuation 486
 
9.5%
Close Punctuation 486
 
9.5%
Other Punctuation 188
 
3.7%
Space Separator 77
 
1.5%
Uppercase Letter 9
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
393
 
10.2%
293
 
7.6%
292
 
7.6%
255
 
6.6%
236
 
6.1%
158
 
4.1%
101
 
2.6%
96
 
2.5%
89
 
2.3%
78
 
2.0%
Other values (232) 1863
48.3%
Other Punctuation
ValueCountFrequency (%)
, 185
98.4%
/ 1
 
0.5%
& 1
 
0.5%
· 1
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
L 3
33.3%
P 3
33.3%
G 3
33.3%
Open Punctuation
ValueCountFrequency (%)
( 486
100.0%
Close Punctuation
ValueCountFrequency (%)
) 486
100.0%
Space Separator
ValueCountFrequency (%)
77
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3854
75.6%
Common 1237
 
24.3%
Latin 9
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
393
 
10.2%
293
 
7.6%
292
 
7.6%
255
 
6.6%
236
 
6.1%
158
 
4.1%
101
 
2.6%
96
 
2.5%
89
 
2.3%
78
 
2.0%
Other values (232) 1863
48.3%
Common
ValueCountFrequency (%)
( 486
39.3%
) 486
39.3%
, 185
 
15.0%
77
 
6.2%
/ 1
 
0.1%
& 1
 
0.1%
· 1
 
0.1%
Latin
ValueCountFrequency (%)
L 3
33.3%
P 3
33.3%
G 3
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3854
75.6%
ASCII 1245
 
24.4%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 486
39.0%
) 486
39.0%
, 185
 
14.9%
77
 
6.2%
L 3
 
0.2%
P 3
 
0.2%
G 3
 
0.2%
/ 1
 
0.1%
& 1
 
0.1%
Hangul
ValueCountFrequency (%)
393
 
10.2%
293
 
7.6%
292
 
7.6%
255
 
6.6%
236
 
6.1%
158
 
4.1%
101
 
2.6%
96
 
2.5%
89
 
2.3%
78
 
2.0%
Other values (232) 1863
48.3%
None
ValueCountFrequency (%)
· 1
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2021-09-16
631 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021-09-16 631
100.0%

Length

2023-12-12T19:09:32.412397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:09:32.538641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-16 631
100.0%

Interactions

2023-12-12T19:09:27.805810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T19:09:27.961987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:09:28.103886image/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구구식당강남순진안군 진안읍 시장1길 16음식(한식)2021-09-16
12농산표고양점자진안군 진안읍 시장1길 16소매(농산물)2021-09-16
23대광천막장혁진안군 진안읍 시장1길 16도·소매임대(천막제작,잡화,천막대여)2021-09-16
34뚝배기김용란진안군 진안읍 시장1길 16음식(한식)2021-09-16
45목화이불집박순덕진안군 진안읍 시장1길 16소매(침구)2021-09-16
56무궁화 대진 옷집정용순진안군 진안읍 시장1길 16소매업(의류,이불)2021-09-16
67무진장 옷수선정순자진안군 진안읍 시장1길 16서비스업(의류수선)2021-09-16
78미래유통유종철진안군 진안읍 시장1길 16소매(외의,문구,운동용품)2021-09-16
89미래축산강원주진안군 진안읍 시장1길 16소매(식육)2021-09-16
910미영유통곽상조진안군 진안읍 시장1길 16소매(건어물,식품잡화)2021-09-16
순번가맹점명대표자가맹점 주소업종데이터기준일자
621622만나식당임태형진안군 주천면 동상주천로 2212-3음식(한식)2021-09-16
622623낙원식당전선임진안군 주천면 동상주천로 2222-1음식(중국음식)2021-09-16
623624운장산송어신남정진안군 주천면 내처사길 64-14음식및숙박업(기타음식점업)2021-09-16
624625머루랑다래랑김정순진안군 주천면 삼거길 10음식(한식)2021-09-16
625626영희머리방오순자진안군 주천면 동상주천로 2233서비스업(미용업)2021-09-16
626627미가 정육 식당안점순진안군 주천면 동상주천로 2214음식(한식), 소매(정육)2021-09-16
627628하늘가든이경순진안군 주천면 봉소길 32-4음식점업(한식)2021-09-16
628629달밤백철현진안군 주천면 동상주천로 2233음식점업(커피,과일청)2021-09-16
629630어우렁돌집안종순진안군 주천면 강촌길 22-5음식점업(일반음식점)2021-09-16
630631진안로컬푸드손종엽전주시 덕진구 동부대로 930도소매(로컬푸드)2021-09-16