Overview

Dataset statistics

Number of variables6
Number of observations939
Missing cells939
Missing cells (%)16.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory46.0 KiB
Average record size in memory50.1 B

Variable types

Numeric1
Unsupported1
Text3
DateTime1

Dataset

Description전라남도 함평군에 소재한 함평사랑상품권 가맹점 현황으로 가맹점명, 주소, 대표자, 등록일 데이터를 제공하고 있습니다.
Author전라남도 함평군
URLhttps://www.data.go.kr/data/15060044/fileData.do

Alerts

등록번호 has 939 (100.0%) missing valuesMissing
일련번호 has unique valuesUnique
등록번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 05:28:53.872960
Analysis finished2023-12-12 05:28:54.855564
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct939
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean470
Minimum1
Maximum939
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.4 KiB
2023-12-12T14:28:54.970126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile47.9
Q1235.5
median470
Q3704.5
95-th percentile892.1
Maximum939
Range938
Interquartile range (IQR)469

Descriptive statistics

Standard deviation271.21025
Coefficient of variation (CV)0.57704309
Kurtosis-1.2
Mean470
Median Absolute Deviation (MAD)235
Skewness0
Sum441330
Variance73555
MonotonicityStrictly increasing
2023-12-12T14:28:55.155443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
632 1
 
0.1%
620 1
 
0.1%
621 1
 
0.1%
622 1
 
0.1%
623 1
 
0.1%
624 1
 
0.1%
625 1
 
0.1%
626 1
 
0.1%
627 1
 
0.1%
Other values (929) 929
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 (%)
939 1
0.1%
938 1
0.1%
937 1
0.1%
936 1
0.1%
935 1
0.1%
934 1
0.1%
933 1
0.1%
932 1
0.1%
931 1
0.1%
930 1
0.1%

등록번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing939
Missing (%)100.0%
Memory size8.4 KiB

가맹점명
Text

Distinct917
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2023-12-12T14:28:55.460109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length6.3322684
Min length2

Characters and Unicode

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

Unique

Unique902 ?
Unique (%)96.1%

Sample

1st row함평농협 신광지점
2nd row통달배 함평점
3rd row강운양만셀프직판장
4th row함평농산물가공영농조합법인
5th row동수네건강원
ValueCountFrequency (%)
함평점 10
 
0.9%
개인택시 8
 
0.8%
함평대리점 5
 
0.5%
하나로마트 4
 
0.4%
주식회사 4
 
0.4%
월야농협 3
 
0.3%
함평농협 3
 
0.3%
유한회사 3
 
0.3%
의원 3
 
0.3%
농업회사법인 3
 
0.3%
Other values (988) 1019
95.7%
2023-12-12T14:28:55.921713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
평 219
 
3.7%
함 217
 
3.6%
장 151
 
2.5%
128
 
2.2%
시 115
 
1.9%
( 109
 
1.8%
) 109
 
1.8%
식 103
 
1.7%
원 88
 
1.5%
사 87
 
1.5%
Other values (531) 4620
77.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5491
92.3%
Space Separator 128
 
2.2%
Open Punctuation 109
 
1.8%
Close Punctuation 109
 
1.8%
Uppercase Letter 44
 
0.7%
Decimal Number 28
 
0.5%
Lowercase Letter 20
 
0.3%
Other Punctuation 9
 
0.2%
Other Symbol 8
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
평 219
 
4.0%
함 217
 
4.0%
장 151
 
2.7%
시 115
 
2.1%
식 103
 
1.9%
원 88
 
1.6%
사 87
 
1.6%
농 80
 
1.5%
나 78
 
1.4%
점 73
 
1.3%
Other values (481) 4280
77.9%
Uppercase Letter
ValueCountFrequency (%)
C 6
13.6%
E 5
 
11.4%
T 4
 
9.1%
H 3
 
6.8%
S 3
 
6.8%
G 2
 
4.5%
K 2
 
4.5%
B 2
 
4.5%
F 2
 
4.5%
P 2
 
4.5%
Other values (11) 13
29.5%
Lowercase Letter
ValueCountFrequency (%)
e 4
20.0%
a 3
15.0%
n 2
10.0%
s 2
10.0%
f 2
10.0%
k 1
 
5.0%
o 1
 
5.0%
p 1
 
5.0%
m 1
 
5.0%
h 1
 
5.0%
Other values (2) 2
10.0%
Decimal Number
ValueCountFrequency (%)
1 5
17.9%
3 5
17.9%
5 5
17.9%
8 4
14.3%
0 4
14.3%
2 3
10.7%
9 1
 
3.6%
6 1
 
3.6%
Other Punctuation
ValueCountFrequency (%)
& 4
44.4%
, 2
22.2%
＆ 1
 
11.1%
' 1
 
11.1%
; 1
 
11.1%
Space Separator
ValueCountFrequency (%)
128
100.0%
Open Punctuation
ValueCountFrequency (%)
( 109
100.0%
Close Punctuation
ValueCountFrequency (%)
) 109
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5498
92.5%
Common 383
 
6.4%
Latin 64
 
1.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
평 219
 
4.0%
함 217
 
3.9%
장 151
 
2.7%
시 115
 
2.1%
식 103
 
1.9%
원 88
 
1.6%
사 87
 
1.6%
농 80
 
1.5%
나 78
 
1.4%
점 73
 
1.3%
Other values (481) 4287
78.0%
Latin
ValueCountFrequency (%)
C 6
 
9.4%
E 5
 
7.8%
e 4
 
6.2%
T 4
 
6.2%
H 3
 
4.7%
a 3
 
4.7%
S 3
 
4.7%
n 2
 
3.1%
G 2
 
3.1%
K 2
 
3.1%
Other values (23) 30
46.9%
Common
ValueCountFrequency (%)
128
33.4%
( 109
28.5%
) 109
28.5%
1 5
 
1.3%
3 5
 
1.3%
5 5
 
1.3%
8 4
 
1.0%
& 4
 
1.0%
0 4
 
1.0%
2 3
 
0.8%
Other values (6) 7
 
1.8%
Han
ValueCountFrequency (%)
宮 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5490
92.3%
ASCII 446
 
7.5%
None 9
 
0.2%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
평 219
 
4.0%
함 217
 
4.0%
장 151
 
2.8%
시 115
 
2.1%
식 103
 
1.9%
원 88
 
1.6%
사 87
 
1.6%
농 80
 
1.5%
나 78
 
1.4%
점 73
 
1.3%
Other values (480) 4279
77.9%
ASCII
ValueCountFrequency (%)
128
28.7%
( 109
24.4%
) 109
24.4%
C 6
 
1.3%
1 5
 
1.1%
3 5
 
1.1%
5 5
 
1.1%
E 5
 
1.1%
8 4
 
0.9%
& 4
 
0.9%
Other values (38) 66
14.8%
None
ValueCountFrequency (%)
㈜ 8
88.9%
＆ 1
 
11.1%
CJK
ValueCountFrequency (%)
宮 1
100.0%

주소
Text

Distinct658
Distinct (%)70.1%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2023-12-12T14:28:56.235520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length33
Mean length20.643237
Min length18

Characters and Unicode

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

Unique

Unique527 ?
Unique (%)56.1%

Sample

1st row전라남도 함평군 신광면 신광중앙길 104-1
2nd row전라남도 함평군 함평읍 영수길 88
3rd row전라남도 함평군 대동면 함장로 1681
4th row전라남도 함평군 대동면 동함평산단길 74-59
5th row전라남도 함평군 함평읍 석두길 1-48
ValueCountFrequency (%)
전라남도 938
19.9%
함평군 937
19.9%
함평읍 553
 
11.8%
영수길 129
 
2.7%
중앙길 124
 
2.6%
밀재로 108
 
2.3%
시장길 103
 
2.2%
105 88
 
1.9%
해보면 81
 
1.7%
학교면 74
 
1.6%
Other values (630) 1568
33.3%
2023-12-12T14:28:56.671149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3764
19.4%
함 1578
 
8.1%
평 1505
 
7.8%
남 988
 
5.1%
군 945
 
4.9%
전 941
 
4.9%
라 938
 
4.8%
도 938
 
4.8%
1 718
 
3.7%
길 668
 
3.4%
Other values (130) 6401
33.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12426
64.1%
Space Separator 3764
 
19.4%
Decimal Number 2942
 
15.2%
Dash Punctuation 240
 
1.2%
Close Punctuation 5
 
< 0.1%
Open Punctuation 5
 
< 0.1%
Uppercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
함 1578
12.7%
평 1505
12.1%
남 988
 
8.0%
군 945
 
7.6%
전 941
 
7.6%
라 938
 
7.5%
도 938
 
7.5%
길 668
 
5.4%
읍 553
 
4.5%
면 385
 
3.1%
Other values (114) 2987
24.0%
Decimal Number
ValueCountFrequency (%)
1 718
24.4%
2 329
11.2%
5 312
10.6%
0 304
10.3%
3 253
 
8.6%
6 236
 
8.0%
4 212
 
7.2%
9 203
 
6.9%
7 188
 
6.4%
8 187
 
6.4%
Uppercase Letter
ValueCountFrequency (%)
L 1
50.0%
H 1
50.0%
Space Separator
ValueCountFrequency (%)
3764
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 240
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12426
64.1%
Common 6956
35.9%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
함 1578
12.7%
평 1505
12.1%
남 988
 
8.0%
군 945
 
7.6%
전 941
 
7.6%
라 938
 
7.5%
도 938
 
7.5%
길 668
 
5.4%
읍 553
 
4.5%
면 385
 
3.1%
Other values (114) 2987
24.0%
Common
ValueCountFrequency (%)
3764
54.1%
1 718
 
10.3%
2 329
 
4.7%
5 312
 
4.5%
0 304
 
4.4%
3 253
 
3.6%
- 240
 
3.5%
6 236
 
3.4%
4 212
 
3.0%
9 203
 
2.9%
Other values (4) 385
 
5.5%
Latin
ValueCountFrequency (%)
L 1
50.0%
H 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12426
64.1%
ASCII 6958
35.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3764
54.1%
1 718
 
10.3%
2 329
 
4.7%
5 312
 
4.5%
0 304
 
4.4%
3 253
 
3.6%
- 240
 
3.4%
6 236
 
3.4%
4 212
 
3.0%
9 203
 
2.9%
Other values (6) 387
 
5.6%
Hangul
ValueCountFrequency (%)
함 1578
12.7%
평 1505
12.1%
남 988
 
8.0%
군 945
 
7.6%
전 941
 
7.6%
라 938
 
7.5%
도 938
 
7.5%
길 668
 
5.4%
읍 553
 
4.5%
면 385
 
3.1%
Other values (114) 2987
24.0%

대표자
Text

Distinct865
Distinct (%)92.1%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
2023-12-12T14:28:56.984930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length3
Mean length3.0095847
Min length2

Characters and Unicode

Total characters2826
Distinct characters214
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

Unique808 ?
Unique (%)86.0%

Sample

1st row김형모
2nd row장승효
3rd row성영제
4th row서종규
5th row박희경
ValueCountFrequency (%)
김영철 5
 
0.5%
김영순 4
 
0.4%
정태연 4
 
0.4%
천성섭 4
 
0.4%
정상진 4
 
0.4%
이정숙 3
 
0.3%
김인숙 3
 
0.3%
이경숙 3
 
0.3%
이 3
 
0.3%
김남현 3
 
0.3%
Other values (861) 912
96.2%
2023-12-12T14:28:57.487405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 234
 
8.3%
이 131
 
4.6%
정 120
 
4.2%
박 89
 
3.1%
영 79
 
2.8%
순 73
 
2.6%
숙 62
 
2.2%
현 50
 
1.8%
미 47
 
1.7%
희 46
 
1.6%
Other values (204) 1895
67.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2800
99.1%
Space Separator 16
 
0.6%
Uppercase Letter 7
 
0.2%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 234
 
8.4%
이 131
 
4.7%
정 120
 
4.3%
박 89
 
3.2%
영 79
 
2.8%
순 73
 
2.6%
숙 62
 
2.2%
현 50
 
1.8%
미 47
 
1.7%
희 46
 
1.6%
Other values (193) 1869
66.8%
Uppercase Letter
ValueCountFrequency (%)
U 1
14.3%
E 1
14.3%
I 1
14.3%
S 1
14.3%
J 1
14.3%
O 1
14.3%
M 1
14.3%
Space Separator
ValueCountFrequency (%)
16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2800
99.1%
Common 19
 
0.7%
Latin 7
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 234
 
8.4%
이 131
 
4.7%
정 120
 
4.3%
박 89
 
3.2%
영 79
 
2.8%
순 73
 
2.6%
숙 62
 
2.2%
현 50
 
1.8%
미 47
 
1.7%
희 46
 
1.6%
Other values (193) 1869
66.8%
Latin
ValueCountFrequency (%)
U 1
14.3%
E 1
14.3%
I 1
14.3%
S 1
14.3%
J 1
14.3%
O 1
14.3%
M 1
14.3%
Common
ValueCountFrequency (%)
16
84.2%
) 1
 
5.3%
( 1
 
5.3%
, 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2800
99.1%
ASCII 26
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 234
 
8.4%
이 131
 
4.7%
정 120
 
4.3%
박 89
 
3.2%
영 79
 
2.8%
순 73
 
2.6%
숙 62
 
2.2%
현 50
 
1.8%
미 47
 
1.7%
희 46
 
1.6%
Other values (193) 1869
66.8%
ASCII
ValueCountFrequency (%)
16
61.5%
U 1
 
3.8%
E 1
 
3.8%
I 1
 
3.8%
S 1
 
3.8%
J 1
 
3.8%
O 1
 
3.8%
M 1
 
3.8%
) 1
 
3.8%
( 1
 
3.8%

등록일
Date

Distinct85
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size7.5 KiB
Minimum2020-07-29 00:00:00
Maximum2021-07-20 00:00:00
2023-12-12T14:28:57.667947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:57.818225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T14:28:54.530668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:28:57.924449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호등록일
일련번호1.0000.816
등록일0.8161.000

Missing values

2023-12-12T14:28:54.680027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:28:54.802357image/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<NA>함평농협 신광지점전라남도 함평군 신광면 신광중앙길 104-1김형모2020-08-18
12<NA>통달배 함평점전라남도 함평군 함평읍 영수길 88장승효2021-07-20
23<NA>강운양만셀프직판장전라남도 함평군 대동면 함장로 1681성영제2021-07-09
34<NA>함평농산물가공영농조합법인전라남도 함평군 대동면 동함평산단길 74-59서종규2021-07-09
45<NA>동수네건강원전라남도 함평군 함평읍 석두길 1-48박희경2021-07-06
56<NA>다솔농원전라남도 함평군 월야면 월야장교길 6-6김새하2021-07-06
67<NA>문장건강원전라남도 함평군 해보면 해삼로 363이현옥2021-07-06
78<NA>불갑산 관광농원전라남도 함평군 월야면 연화길 18신행순2021-06-30
89<NA>중앙약국전라남도 함평군 함평읍 중앙길 115최여규2021-06-30
910<NA>월야농협 마트전라남도 함평군 월야면 밀재로 1516정상진2020-08-18
일련번호등록번호가맹점명주소대표자등록일
929930<NA>월크크리닝(함평점)전라남도 함평군 함평읍 영수길 183송경희2020-07-29
930931<NA>함평택시 합자회사전라남도 함평군 함평읍 중앙길 57임채병2020-07-29
931932<NA>학교식품전라남도 함평군 학교면 백학길 111김희정2020-07-29
932933<NA>천지단향양봉영농조합법인전라남도 함평군 대동면 대동길 81정나진2020-07-29
933934<NA>보현영농조합법인전라남도 함평군 월야면 신덕길 7-10이주완2020-07-29
934935<NA>함평연합의원전라남도 함평군 함평읍 중앙길 80김동명2020-07-29
935936<NA>함평하나내과의원전라남도 함평군 함평읍 중앙길 134윤상준2020-07-29
936937<NA>영진식당전라남도 함평군 학교면 사거리길 38김정례2020-07-29
937938<NA>현대식품전라남도 함평군 나산면 나산길 80-11고화자2020-07-29
938939<NA>정성가득한식당전라남도 함평군 함평읍 광남길 69-17추승호2020-07-29