Overview

Dataset statistics

Number of variables5
Number of observations2079
Missing cells0
Missing cells (%)0.0%
Duplicate rows22
Duplicate rows (%)1.1%
Total size in memory81.3 KiB
Average record size in memory40.1 B

Variable types

Text3
Categorical2

Dataset

Description서천군의 지역경제 발전을 위해 서천군에서 운영하는 서천사랑 상품권(지역상품권) 가맹점 현황 정보를 제공하고 있습니다
Author충청남도 서천군
URLhttps://www.data.go.kr/data/3066591/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 22 (1.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 12:00:30.534563
Analysis finished2023-12-12 12:00:31.361009
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

Distinct2005
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size16.4 KiB
2023-12-12T21:00:31.732833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length5.7186147
Min length2

Characters and Unicode

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

Unique

Unique1951 ?
Unique (%)93.8%

Sample

1st row(사)한산모시조합
2nd row(유)가본 봄마트
3rd row(유)서림주류상사
4th row(주) 뉴스서천
5th row(주) 대지 골프연습장
ValueCountFrequency (%)
서천점 33
 
1.4%
장항점 17
 
0.7%
서천 12
 
0.5%
주식회사 11
 
0.5%
아모레퍼시픽 10
 
0.4%
세븐일레븐 9
 
0.4%
cu 7
 
0.3%
gs25 6
 
0.2%
아모레 6
 
0.2%
하나로마트 5
 
0.2%
Other values (2171) 2291
95.2%
2023-12-12T21:00:32.411078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
328
 
2.8%
서 302
 
2.5%
천 264
 
2.2%
산 232
 
2.0%
수 211
 
1.8%
장 204
 
1.7%
점 203
 
1.7%
이 165
 
1.4%
리 158
 
1.3%
사 150
 
1.3%
Other values (690) 9672
81.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11168
93.9%
Space Separator 328
 
2.8%
Decimal Number 122
 
1.0%
Uppercase Letter 117
 
1.0%
Lowercase Letter 51
 
0.4%
Open Punctuation 40
 
0.3%
Close Punctuation 39
 
0.3%
Other Punctuation 15
 
0.1%
Dash Punctuation 4
 
< 0.1%
Other Symbol 3
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 302
 
2.7%
천 264
 
2.4%
산 232
 
2.1%
수 211
 
1.9%
장 204
 
1.8%
점 203
 
1.8%
이 165
 
1.5%
리 158
 
1.4%
사 150
 
1.3%
원 149
 
1.3%
Other values (631) 9130
81.8%
Uppercase Letter
ValueCountFrequency (%)
S 15
12.8%
C 15
12.8%
G 14
12.0%
U 10
 
8.5%
B 8
 
6.8%
E 7
 
6.0%
L 6
 
5.1%
D 5
 
4.3%
A 5
 
4.3%
Y 5
 
4.3%
Other values (13) 27
23.1%
Lowercase Letter
ValueCountFrequency (%)
c 10
19.6%
o 7
13.7%
s 6
11.8%
n 5
9.8%
g 5
9.8%
u 4
 
7.8%
e 3
 
5.9%
f 2
 
3.9%
a 2
 
3.9%
i 2
 
3.9%
Other values (5) 5
9.8%
Decimal Number
ValueCountFrequency (%)
2 30
24.6%
0 22
18.0%
5 19
15.6%
1 17
13.9%
4 8
 
6.6%
6 7
 
5.7%
3 6
 
4.9%
8 6
 
4.9%
9 5
 
4.1%
7 2
 
1.6%
Other Punctuation
ValueCountFrequency (%)
, 7
46.7%
. 4
26.7%
& 3
20.0%
# 1
 
6.7%
Space Separator
ValueCountFrequency (%)
328
100.0%
Open Punctuation
ValueCountFrequency (%)
( 40
100.0%
Close Punctuation
ValueCountFrequency (%)
) 39
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11171
94.0%
Common 550
 
4.6%
Latin 168
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 302
 
2.7%
천 264
 
2.4%
산 232
 
2.1%
수 211
 
1.9%
장 204
 
1.8%
점 203
 
1.8%
이 165
 
1.5%
리 158
 
1.4%
사 150
 
1.3%
원 149
 
1.3%
Other values (632) 9133
81.8%
Latin
ValueCountFrequency (%)
S 15
 
8.9%
C 15
 
8.9%
G 14
 
8.3%
c 10
 
6.0%
U 10
 
6.0%
B 8
 
4.8%
o 7
 
4.2%
E 7
 
4.2%
s 6
 
3.6%
L 6
 
3.6%
Other values (28) 70
41.7%
Common
ValueCountFrequency (%)
328
59.6%
( 40
 
7.3%
) 39
 
7.1%
2 30
 
5.5%
0 22
 
4.0%
5 19
 
3.5%
1 17
 
3.1%
4 8
 
1.5%
6 7
 
1.3%
, 7
 
1.3%
Other values (10) 33
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11168
93.9%
ASCII 718
 
6.0%
None 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
328
45.7%
( 40
 
5.6%
) 39
 
5.4%
2 30
 
4.2%
0 22
 
3.1%
5 19
 
2.6%
1 17
 
2.4%
S 15
 
2.1%
C 15
 
2.1%
G 14
 
1.9%
Other values (48) 179
24.9%
Hangul
ValueCountFrequency (%)
서 302
 
2.7%
천 264
 
2.4%
산 232
 
2.1%
수 211
 
1.9%
장 204
 
1.8%
점 203
 
1.8%
이 165
 
1.5%
리 158
 
1.4%
사 150
 
1.3%
원 149
 
1.3%
Other values (631) 9130
81.8%
None
ValueCountFrequency (%)
㈜ 3
100.0%

대표자
Text

Distinct1850
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size16.4 KiB
2023-12-12T21:00:32.901207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length3
Mean length3.023569
Min length2

Characters and Unicode

Total characters6286
Distinct characters242
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

Unique1667 ?
Unique (%)80.2%

Sample

1st row임은순
2nd row유광수
3rd row구재혁
4th row고종만
5th row최철
ValueCountFrequency (%)
이정복 6
 
0.3%
이영숙 6
 
0.3%
김정숙 6
 
0.3%
조성훈 5
 
0.2%
장동필 5
 
0.2%
박언순 5
 
0.2%
김경자 4
 
0.2%
이희자 4
 
0.2%
김진숙 4
 
0.2%
김미영 3
 
0.1%
Other values (1850) 2041
97.7%
2023-12-12T21:00:33.683298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 427
 
6.8%
이 323
 
5.1%
정 216
 
3.4%
박 189
 
3.0%
영 182
 
2.9%
순 169
 
2.7%
희 156
 
2.5%
숙 151
 
2.4%
경 140
 
2.2%
미 111
 
1.8%
Other values (232) 4222
67.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6213
98.8%
Uppercase Letter 62
 
1.0%
Space Separator 10
 
0.2%
Decimal Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 427
 
6.9%
이 323
 
5.2%
정 216
 
3.5%
박 189
 
3.0%
영 182
 
2.9%
순 169
 
2.7%
희 156
 
2.5%
숙 151
 
2.4%
경 140
 
2.3%
미 111
 
1.8%
Other values (211) 4149
66.8%
Uppercase Letter
ValueCountFrequency (%)
A 11
17.7%
N 10
16.1%
H 7
11.3%
G 5
8.1%
I 5
8.1%
K 4
 
6.5%
U 3
 
4.8%
C 3
 
4.8%
J 2
 
3.2%
E 2
 
3.2%
Other values (9) 10
16.1%
Space Separator
ValueCountFrequency (%)
10
100.0%
Decimal Number
ValueCountFrequency (%)
6 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6213
98.8%
Latin 62
 
1.0%
Common 11
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 427
 
6.9%
이 323
 
5.2%
정 216
 
3.5%
박 189
 
3.0%
영 182
 
2.9%
순 169
 
2.7%
희 156
 
2.5%
숙 151
 
2.4%
경 140
 
2.3%
미 111
 
1.8%
Other values (211) 4149
66.8%
Latin
ValueCountFrequency (%)
A 11
17.7%
N 10
16.1%
H 7
11.3%
G 5
8.1%
I 5
8.1%
K 4
 
6.5%
U 3
 
4.8%
C 3
 
4.8%
J 2
 
3.2%
E 2
 
3.2%
Other values (9) 10
16.1%
Common
ValueCountFrequency (%)
10
90.9%
6 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6213
98.8%
ASCII 73
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 427
 
6.9%
이 323
 
5.2%
정 216
 
3.5%
박 189
 
3.0%
영 182
 
2.9%
순 169
 
2.7%
희 156
 
2.5%
숙 151
 
2.4%
경 140
 
2.3%
미 111
 
1.8%
Other values (211) 4149
66.8%
ASCII
ValueCountFrequency (%)
A 11
15.1%
N 10
13.7%
10
13.7%
H 7
9.6%
G 5
 
6.8%
I 5
 
6.8%
K 4
 
5.5%
U 3
 
4.1%
C 3
 
4.1%
J 2
 
2.7%
Other values (11) 13
17.8%

주소
Text

Distinct1389
Distinct (%)66.8%
Missing0
Missing (%)0.0%
Memory size16.4 KiB
2023-12-12T21:00:34.039065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length37
Mean length21.180375
Min length17

Characters and Unicode

Total characters44034
Distinct characters167
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

Unique1073 ?
Unique (%)51.6%

Sample

1st row충청남도 서천군 한산면 한산모시길38번길 4-1
2nd row충청남도 서천군 서천읍 군청로 4
3rd row충청남도 서천군 종천면 충서로 292-23
4th row충청남도 서천군 서천읍 충절로 33
5th row충청남도 서천군 장항읍 장항공단길28번길 40
ValueCountFrequency (%)
충청남도 2079
19.9%
서천군 2079
19.9%
서천읍 1042
 
10.0%
장항읍 492
 
4.7%
서천로 272
 
2.6%
충절로 238
 
2.3%
42 159
 
1.5%
서면 143
 
1.4%
장항로 142
 
1.4%
한산면 107
 
1.0%
Other values (969) 3686
35.3%
2023-12-12T21:00:34.666880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8360
19.0%
서 3935
 
8.9%
천 3494
 
7.9%
충 2523
 
5.7%
군 2183
 
5.0%
청 2151
 
4.9%
남 2103
 
4.8%
도 2086
 
4.7%
로 1793
 
4.1%
1 1560
 
3.5%
Other values (157) 13846
31.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 28608
65.0%
Space Separator 8360
 
19.0%
Decimal Number 6504
 
14.8%
Dash Punctuation 468
 
1.1%
Close Punctuation 47
 
0.1%
Open Punctuation 47
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 3935
13.8%
천 3494
12.2%
충 2523
8.8%
군 2183
 
7.6%
청 2151
 
7.5%
남 2103
 
7.4%
도 2086
 
7.3%
로 1793
 
6.3%
읍 1534
 
5.4%
장 984
 
3.4%
Other values (143) 5822
20.4%
Decimal Number
ValueCountFrequency (%)
1 1560
24.0%
2 925
14.2%
4 782
12.0%
3 592
 
9.1%
5 557
 
8.6%
8 453
 
7.0%
9 444
 
6.8%
7 441
 
6.8%
6 420
 
6.5%
0 330
 
5.1%
Space Separator
ValueCountFrequency (%)
8360
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 468
100.0%
Close Punctuation
ValueCountFrequency (%)
) 47
100.0%
Open Punctuation
ValueCountFrequency (%)
( 47
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 28608
65.0%
Common 15426
35.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 3935
13.8%
천 3494
12.2%
충 2523
8.8%
군 2183
 
7.6%
청 2151
 
7.5%
남 2103
 
7.4%
도 2086
 
7.3%
로 1793
 
6.3%
읍 1534
 
5.4%
장 984
 
3.4%
Other values (143) 5822
20.4%
Common
ValueCountFrequency (%)
8360
54.2%
1 1560
 
10.1%
2 925
 
6.0%
4 782
 
5.1%
3 592
 
3.8%
5 557
 
3.6%
- 468
 
3.0%
8 453
 
2.9%
9 444
 
2.9%
7 441
 
2.9%
Other values (4) 844
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 28608
65.0%
ASCII 15426
35.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8360
54.2%
1 1560
 
10.1%
2 925
 
6.0%
4 782
 
5.1%
3 592
 
3.8%
5 557
 
3.6%
- 468
 
3.0%
8 453
 
2.9%
9 444
 
2.9%
7 441
 
2.9%
Other values (4) 844
 
5.5%
Hangul
ValueCountFrequency (%)
서 3935
13.8%
천 3494
12.2%
충 2523
8.8%
군 2183
 
7.6%
청 2151
 
7.5%
남 2103
 
7.4%
도 2086
 
7.3%
로 1793
 
6.3%
읍 1534
 
5.4%
장 984
 
3.4%
Other values (143) 5822
20.4%

업종
Categorical

Distinct9
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size16.4 KiB
소매업
953 
음식점업
620 
개인서비스업
204 
기타
 
90
제조업
 
89
Other values (4)
123 

Length

Max length11
Median length3
Mean length3.6277056
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row소매업
3rd row소매업
4th row개인서비스업
5th row개인서비스업

Common Values

ValueCountFrequency (%)
소매업 953
45.8%
음식점업 620
29.8%
개인서비스업 204
 
9.8%
기타 90
 
4.3%
제조업 89
 
4.3%
보건업 64
 
3.1%
교육서비스업 41
 
2.0%
숙박업 13
 
0.6%
스포츠여가관련서비스업 5
 
0.2%

Length

2023-12-12T21:00:34.893327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:35.075717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소매업 953
45.8%
음식점업 620
29.8%
개인서비스업 204
 
9.8%
기타 90
 
4.3%
제조업 89
 
4.3%
보건업 64
 
3.1%
교육서비스업 41
 
2.0%
숙박업 13
 
0.6%
스포츠여가관련서비스업 5
 
0.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.4 KiB
2021-07-09
2079 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021-07-09 2079
100.0%

Length

2023-12-12T21:00:35.268740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:35.406213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-07-09 2079
100.0%

Missing values

2023-12-12T21:00:31.191596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:00:31.302737image/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(사)한산모시조합임은순충청남도 서천군 한산면 한산모시길38번길 4-1기타2021-07-09
1(유)가본 봄마트유광수충청남도 서천군 서천읍 군청로 4소매업2021-07-09
2(유)서림주류상사구재혁충청남도 서천군 종천면 충서로 292-23소매업2021-07-09
3(주) 뉴스서천고종만충청남도 서천군 서천읍 충절로 33개인서비스업2021-07-09
4(주) 대지 골프연습장최철충청남도 서천군 장항읍 장항공단길28번길 40개인서비스업2021-07-09
5(주)건호농업회사법인이건호충청남도 서천군 서천읍 서천로 140-1제조업2021-07-09
6(주)계동구남중충청남도 서천군 서면 갯벌체험로 120제조업2021-07-09
7(주)고광이엔지한우석충청남도 서천군 서천읍 화금서길 28기타2021-07-09
8(주)고수룩식품박근준충청남도 서천군 비인면 서인로1117번길 1소매업2021-07-09
9(주)명경전자김상수충청남도 서천군 서천읍 충절로59번길 28소매업2021-07-09
상호명대표자주소업종데이터기준일자
2069흥림식당이정희충청남도 서천군 판교면 대백제로 1566음식점업2021-07-09
2070흥부가 기가막혀(흥부가)권재호충청남도 서천군 장항읍 장마로62번길 17음식점업2021-07-09
2071흥아자전거홍성학충청남도 서천군 장항읍 장항로 138소매업2021-07-09
2072흥아호이영기충청남도 서천군 장항읍 신창서로 81 (신흥아파트)기타2021-07-09
2073희망찬약국한애경충청남도 서천군 서천읍 충절로59번길 18보건업2021-07-09
2074희망치과의원김영호충청남도 서천군 서천읍 충절로59번길 12-3보건업2021-07-09
2075희찬태양광발전소박희찬충청남도 서천군 종천면 충서로460번길 8기타2021-07-09
2076힐링센타김봉순충청남도 서천군 서천읍 충절로49번길 33-14개인서비스업2021-07-09
2077힐링엔젤스서천점전양효충청남도 서천군 서천읍 충절로81번길 47소매업2021-07-09
2078힐링펜션김정자충청남도 서천군 서면 춘장대길 62숙박업2021-07-09

Duplicate rows

Most frequently occurring

상호명대표자주소업종데이터기준일자# duplicates
0기산슈퍼임동희충청남도 서천군 기산면 기산길 60소매업2021-07-092
1다루안해진충청남도 서천군 서천읍 충절로41번길 24-4음식점업2021-07-092
2대전상회나환진충청남도 서천군 서천읍 충절로 42소매업2021-07-092
3바다수산이선옥충청남도 서천군 장항읍 성화로 104소매업2021-07-092
4부엉이카페송관영충청남도 서천군 서천읍 서천로 70음식점업2021-07-092
5새로미농수산서복원충청남도 서천군 마서면 구절길7번길 52-19소매업2021-07-092
6선창수산이처숙충청남도 서천군 서천읍 충절로 42소매업2021-07-092
7솔밭조개포차최한철충청남도 서천군 장항읍 장항산단로34번길 46음식점업2021-07-092
8신용기계김예규충청남도 서천군 마산면 한마로 440개인서비스업2021-07-092
9싱싱마트홍경숙충청남도 서천군 서천읍 충절로 43소매업2021-07-092