Overview

Dataset statistics

Number of variables6
Number of observations3036
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory145.4 KiB
Average record size in memory49.0 B

Variable types

Numeric1
Text2
Categorical3

Dataset

Description경상북도 문경시 관내의 문경사랑상품권 가맹점에 대한 현황 정보이며 번호, 가맹점명, 주소, 업종, 읍면동 순으로 정보가 있습니다.
URLhttps://www.data.go.kr/data/15121166/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 14:04:47.186949
Analysis finished2023-12-12 14:04:48.205581
Duration1.02 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct3036
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1518.5
Minimum1
Maximum3036
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.8 KiB
2023-12-12T23:04:48.289757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile152.75
Q1759.75
median1518.5
Q32277.25
95-th percentile2884.25
Maximum3036
Range3035
Interquartile range (IQR)1517.5

Descriptive statistics

Standard deviation876.56203
Coefficient of variation (CV)0.57725521
Kurtosis-1.2
Mean1518.5
Median Absolute Deviation (MAD)759
Skewness0
Sum4610166
Variance768361
MonotonicityStrictly increasing
2023-12-12T23:04:48.428425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
2030 1
 
< 0.1%
2021 1
 
< 0.1%
2022 1
 
< 0.1%
2023 1
 
< 0.1%
2024 1
 
< 0.1%
2025 1
 
< 0.1%
2026 1
 
< 0.1%
2027 1
 
< 0.1%
2028 1
 
< 0.1%
Other values (3026) 3026
99.7%
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 (%)
3036 1
< 0.1%
3035 1
< 0.1%
3034 1
< 0.1%
3033 1
< 0.1%
3032 1
< 0.1%
3031 1
< 0.1%
3030 1
< 0.1%
3029 1
< 0.1%
3028 1
< 0.1%
3027 1
< 0.1%

가맹점명
Text

Distinct2952
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size23.8 KiB
2023-12-12T23:04:48.723289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length25
Mean length6.3507905
Min length1

Characters and Unicode

Total characters19281
Distinct characters810
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

Unique2892 ?
Unique (%)95.3%

Sample

1st row신성자 바이올린 교습소
2nd row서문경농업협동조합 농암지점
3rd row문경축산업협동조합
4th row코오롱스포츠문경
5th row수치과의원
ValueCountFrequency (%)
문경점 85
 
2.1%
주식회사 25
 
0.6%
아모레 21
 
0.5%
점촌점 20
 
0.5%
문경시청점 18
 
0.5%
문경(특 17
 
0.4%
문경 17
 
0.4%
문경점촌점 17
 
0.4%
세븐일레븐 16
 
0.4%
문경모전점 14
 
0.4%
Other values (3331) 3720
93.7%
2023-12-12T23:04:49.182101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
934
 
4.8%
경 544
 
2.8%
점 525
 
2.7%
문 521
 
2.7%
이 309
 
1.6%
리 261
 
1.4%
식 251
 
1.3%
스 249
 
1.3%
가 186
 
1.0%
대 186
 
1.0%
Other values (800) 15315
79.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 17408
90.3%
Space Separator 934
 
4.8%
Uppercase Letter 248
 
1.3%
Lowercase Letter 193
 
1.0%
Decimal Number 150
 
0.8%
Close Punctuation 126
 
0.7%
Open Punctuation 124
 
0.6%
Other Punctuation 77
 
0.4%
Other Symbol 16
 
0.1%
Dash Punctuation 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 544
 
3.1%
점 525
 
3.0%
문 521
 
3.0%
이 309
 
1.8%
리 261
 
1.5%
식 251
 
1.4%
스 249
 
1.4%
가 186
 
1.1%
대 186
 
1.1%
사 185
 
1.1%
Other values (727) 14191
81.5%
Uppercase Letter
ValueCountFrequency (%)
C 29
 
11.7%
G 22
 
8.9%
S 22
 
8.9%
P 19
 
7.7%
A 18
 
7.3%
O 15
 
6.0%
T 14
 
5.6%
B 11
 
4.4%
E 11
 
4.4%
F 10
 
4.0%
Other values (15) 77
31.0%
Lowercase Letter
ValueCountFrequency (%)
a 24
12.4%
m 18
 
9.3%
e 18
 
9.3%
o 18
 
9.3%
p 16
 
8.3%
i 13
 
6.7%
r 12
 
6.2%
l 11
 
5.7%
n 9
 
4.7%
y 8
 
4.1%
Other values (15) 46
23.8%
Decimal Number
ValueCountFrequency (%)
2 40
26.7%
1 21
14.0%
5 21
14.0%
0 17
11.3%
3 17
11.3%
4 13
 
8.7%
9 7
 
4.7%
6 6
 
4.0%
7 5
 
3.3%
8 3
 
2.0%
Other Punctuation
ValueCountFrequency (%)
, 33
42.9%
& 15
19.5%
. 15
19.5%
; 8
 
10.4%
/ 2
 
2.6%
？ 2
 
2.6%
: 1
 
1.3%
# 1
 
1.3%
Space Separator
ValueCountFrequency (%)
934
100.0%
Close Punctuation
ValueCountFrequency (%)
) 126
100.0%
Open Punctuation
ValueCountFrequency (%)
( 124
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 16
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 17423
90.4%
Common 1416
 
7.3%
Latin 441
 
2.3%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 544
 
3.1%
점 525
 
3.0%
문 521
 
3.0%
이 309
 
1.8%
리 261
 
1.5%
식 251
 
1.4%
스 249
 
1.4%
가 186
 
1.1%
대 186
 
1.1%
사 185
 
1.1%
Other values (727) 14206
81.5%
Latin
ValueCountFrequency (%)
C 29
 
6.6%
a 24
 
5.4%
G 22
 
5.0%
S 22
 
5.0%
P 19
 
4.3%
m 18
 
4.1%
A 18
 
4.1%
e 18
 
4.1%
o 18
 
4.1%
p 16
 
3.6%
Other values (40) 237
53.7%
Common
ValueCountFrequency (%)
934
66.0%
) 126
 
8.9%
( 124
 
8.8%
2 40
 
2.8%
, 33
 
2.3%
1 21
 
1.5%
5 21
 
1.5%
0 17
 
1.2%
3 17
 
1.2%
& 15
 
1.1%
Other values (12) 68
 
4.8%
Han
ValueCountFrequency (%)
正 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 17407
90.3%
ASCII 1851
 
9.6%
None 22
 
0.1%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
934
50.5%
) 126
 
6.8%
( 124
 
6.7%
2 40
 
2.2%
, 33
 
1.8%
C 29
 
1.6%
a 24
 
1.3%
G 22
 
1.2%
S 22
 
1.2%
1 21
 
1.1%
Other values (59) 476
25.7%
Hangul
ValueCountFrequency (%)
경 544
 
3.1%
점 525
 
3.0%
문 521
 
3.0%
이 309
 
1.8%
리 261
 
1.5%
식 251
 
1.4%
스 249
 
1.4%
가 186
 
1.1%
대 186
 
1.1%
사 185
 
1.1%
Other values (726) 14190
81.5%
None
ValueCountFrequency (%)
㈜ 16
72.7%
É 2
 
9.1%
é 2
 
9.1%
？ 2
 
9.1%
CJK
ValueCountFrequency (%)
正 1
100.0%

주소
Text

Distinct2324
Distinct (%)76.5%
Missing0
Missing (%)0.0%
Memory size23.8 KiB
2023-12-12T23:04:49.522758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length35
Mean length21.818182
Min length18

Characters and Unicode

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

Unique

Unique1876 ?
Unique (%)61.8%

Sample

1st row경상북도 문경시 당교6길 10(모전동)
2nd row경상북도 문경시 농암면 농암길 62
3rd row경상북도 문경시 호계면 문경대로 1024
4th row경상북도 문경시 당교로 242 (모전동)
5th row경상북도 문경시 중앙9길 1 (점촌동)
ValueCountFrequency (%)
경상북도 3036
20.8%
문경시 3036
20.8%
모전동 612
 
4.2%
점촌동 608
 
4.2%
중앙로 340
 
2.3%
문경읍 338
 
2.3%
흥덕동 274
 
1.9%
가은읍 129
 
0.9%
당교로 116
 
0.8%
신흥로 109
 
0.7%
Other values (1482) 5986
41.0%
2023-12-12T23:04:50.012882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11548
17.4%
경 6473
 
9.8%
문 3488
 
5.3%
시 3297
 
5.0%
상 3175
 
4.8%
북 3072
 
4.6%
도 3047
 
4.6%
동 2395
 
3.6%
( 2272
 
3.4%
) 2272
 
3.4%
Other values (212) 25201
38.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 40774
61.6%
Space Separator 11548
 
17.4%
Decimal Number 8555
 
12.9%
Open Punctuation 2273
 
3.4%
Close Punctuation 2273
 
3.4%
Dash Punctuation 702
 
1.1%
Other Punctuation 114
 
0.2%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 6473
15.9%
문 3488
 
8.6%
시 3297
 
8.1%
상 3175
 
7.8%
북 3072
 
7.5%
도 3047
 
7.5%
동 2395
 
5.9%
로 1576
 
3.9%
길 1488
 
3.6%
전 1075
 
2.6%
Other values (193) 11688
28.7%
Decimal Number
ValueCountFrequency (%)
1 2242
26.2%
2 1381
16.1%
3 930
10.9%
6 712
 
8.3%
4 699
 
8.2%
5 616
 
7.2%
8 532
 
6.2%
7 514
 
6.0%
9 482
 
5.6%
0 447
 
5.2%
Open Punctuation
ValueCountFrequency (%)
( 2272
> 99.9%
[ 1
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 2272
> 99.9%
] 1
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
, 113
99.1%
* 1
 
0.9%
Space Separator
ValueCountFrequency (%)
11548
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 702
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 40774
61.6%
Common 25465
38.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 6473
15.9%
문 3488
 
8.6%
시 3297
 
8.1%
상 3175
 
7.8%
북 3072
 
7.5%
도 3047
 
7.5%
동 2395
 
5.9%
로 1576
 
3.9%
길 1488
 
3.6%
전 1075
 
2.6%
Other values (193) 11688
28.7%
Common
ValueCountFrequency (%)
11548
45.3%
( 2272
 
8.9%
) 2272
 
8.9%
1 2242
 
8.8%
2 1381
 
5.4%
3 930
 
3.7%
6 712
 
2.8%
- 702
 
2.8%
4 699
 
2.7%
5 616
 
2.4%
Other values (8) 2091
 
8.2%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 40774
61.6%
ASCII 25466
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11548
45.3%
( 2272
 
8.9%
) 2272
 
8.9%
1 2242
 
8.8%
2 1381
 
5.4%
3 930
 
3.7%
6 712
 
2.8%
- 702
 
2.8%
4 699
 
2.7%
5 616
 
2.4%
Other values (9) 2092
 
8.2%
Hangul
ValueCountFrequency (%)
경 6473
15.9%
문 3488
 
8.6%
시 3297
 
8.1%
상 3175
 
7.8%
북 3072
 
7.5%
도 3047
 
7.5%
동 2395
 
5.9%
로 1576
 
3.9%
길 1488
 
3.6%
전 1075
 
2.6%
Other values (193) 11688
28.7%

업종
Categorical

Distinct9
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size23.8 KiB
음식점업
1190 
소매업
1101 
개인서비스업
281 
기타
171 
보건업
 
99
Other values (4)
194 

Length

Max length11
Median length6
Mean length3.7378129
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교육서비스업
2nd row소매업
3rd row기타
4th row소매업
5th row보건업

Common Values

ValueCountFrequency (%)
음식점업 1190
39.2%
소매업 1101
36.3%
개인서비스업 281
 
9.3%
기타 171
 
5.6%
보건업 99
 
3.3%
제조업 92
 
3.0%
교육서비스업 54
 
1.8%
스포츠여가관련서비스업 27
 
0.9%
숙박업 21
 
0.7%

Length

2023-12-12T23:04:50.312805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:04:50.462064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
음식점업 1190
39.2%
소매업 1101
36.3%
개인서비스업 281
 
9.3%
기타 171
 
5.6%
보건업 99
 
3.3%
제조업 92
 
3.0%
교육서비스업 54
 
1.8%
스포츠여가관련서비스업 27
 
0.9%
숙박업 21
 
0.7%

읍면동
Categorical

Distinct19
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size23.8 KiB
모전동
975 
점촌동
815 
흥덕동
382 
문경읍
338 
가은읍
129 
Other values (14)
397 

Length

Max length3
Median length3
Mean length2.9990119
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row모전동
2nd row농암면
3rd row호계면
4th row모전동
5th row점촌동

Common Values

ValueCountFrequency (%)
모전동 975
32.1%
점촌동 815
26.8%
흥덕동 382
 
12.6%
문경읍 338
 
11.1%
가은읍 129
 
4.2%
마성면 77
 
2.5%
산양면 59
 
1.9%
신기동 42
 
1.4%
농암면 39
 
1.3%
호계면 38
 
1.3%
Other values (9) 142
 
4.7%

Length

2023-12-12T23:04:50.612517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
모전동 975
32.1%
점촌동 815
26.8%
흥덕동 382
 
12.6%
문경읍 338
 
11.1%
가은읍 129
 
4.2%
마성면 77
 
2.5%
산양면 59
 
1.9%
신기동 42
 
1.4%
농암면 39
 
1.3%
호계면 38
 
1.3%
Other values (9) 142
 
4.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.8 KiB
2023-08-29
3036 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-29
2nd row2023-08-29
3rd row2023-08-29
4th row2023-08-29
5th row2023-08-29

Common Values

ValueCountFrequency (%)
2023-08-29 3036
100.0%

Length

2023-12-12T23:04:50.723548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:04:50.814293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-29 3036
100.0%

Interactions

2023-12-12T23:04:47.909916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:04:50.871038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종읍면동
번호1.0000.1980.279
업종0.1981.0000.257
읍면동0.2790.2571.000
2023-12-12T23:04:50.970120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동업종
읍면동1.0000.103
업종0.1031.000
2023-12-12T23:04:51.056558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업종읍면동
번호1.0000.0910.108
업종0.0911.0000.103
읍면동0.1080.1031.000

Missing values

2023-12-12T23:04:48.038528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:04:48.151211image/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신성자 바이올린 교습소경상북도 문경시 당교6길 10(모전동)교육서비스업모전동2023-08-29
12서문경농업협동조합 농암지점경상북도 문경시 농암면 농암길 62소매업농암면2023-08-29
23문경축산업협동조합경상북도 문경시 호계면 문경대로 1024기타호계면2023-08-29
34코오롱스포츠문경경상북도 문경시 당교로 242 (모전동)소매업모전동2023-08-29
45수치과의원경상북도 문경시 중앙9길 1 (점촌동)보건업점촌동2023-08-29
56리트학원경상북도 문경시 당교12길 5-2 (모전동)교육서비스업모전동2023-08-29
67일광카센타경상북도 문경시 운동장로 81 (모전동)개인서비스업모전동2023-08-29
78중앙약국경상북도 문경시 중앙로 148 (점촌동)소매업점촌동2023-08-29
89김수미의 엄마손맛 문경시청점경상북도 문경시 당교11길 5-4 (모전동)제조업모전동2023-08-29
910가은식당경상북도 문경시 가은읍 대야로 2502음식점업가은읍2023-08-29
번호가맹점명주소업종읍면동데이터기준일자
30263027태평양 약국경상북도 문경시 중앙로 137 (점촌동)보건업점촌동2023-08-29
30273028은하우리옷꾸밈샵경상북도 문경시 모전천3길 1 (모전동)소매업모전동2023-08-29
30283029농가축산물도소매센타경상북도 문경시 상신로 12 (점촌동)소매업점촌동2023-08-29
30293030중앙플라워경상북도 문경시 중앙로 51 (모전동)소매업모전동2023-08-29
30303031대성상회경상북도 문경시 중앙시장1길 6-8 (점촌동)소매업점촌동2023-08-29
30313032미리내경상북도 문경시 중앙시장1길 2 (점촌동)소매업점촌동2023-08-29
30323033동신상회경상북도 문경시 중앙시장1길 4-11 (점촌동)소매업점촌동2023-08-29
30333034곰소맛 젓갈마트경상북도 문경시 중앙시장1길 8-13 (점촌동)소매업점촌동2023-08-29
30343035세종떡집. 폐백경상북도 문경시 중앙시장1길 6-2 (점촌동)제조업점촌동2023-08-29
30353036무지개종합화장품경상북도 문경시 중앙시장길 14 (점촌동)소매업점촌동2023-08-29