Overview

Dataset statistics

Number of variables4
Number of observations599
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.4 KiB
Average record size in memory33.2 B

Variable types

Numeric1
Text1
Categorical2

Dataset

Description영동군 관내의 영동사랑상품권 가맹점에 대한 현황 정보이며 순번, 가맹점명, 행정동, 업종 순으로 정보가 있습니다.
Author충청북도 영동군
URLhttps://www.data.go.kr/data/3070175/fileData.do

Alerts

행정동 is highly imbalanced (54.2%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:40:29.915710
Analysis finished2023-12-12 19:40:30.617239
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct599
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean300
Minimum1
Maximum599
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2023-12-13T04:40:30.704274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile30.9
Q1150.5
median300
Q3449.5
95-th percentile569.1
Maximum599
Range598
Interquartile range (IQR)299

Descriptive statistics

Standard deviation173.06068
Coefficient of variation (CV)0.57686894
Kurtosis-1.2
Mean300
Median Absolute Deviation (MAD)150
Skewness0
Sum179700
Variance29950
MonotonicityStrictly increasing
2023-12-13T04:40:30.922227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
395 1
 
0.2%
397 1
 
0.2%
398 1
 
0.2%
399 1
 
0.2%
400 1
 
0.2%
401 1
 
0.2%
402 1
 
0.2%
403 1
 
0.2%
404 1
 
0.2%
Other values (589) 589
98.3%
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 (%)
599 1
0.2%
598 1
0.2%
597 1
0.2%
596 1
0.2%
595 1
0.2%
594 1
0.2%
593 1
0.2%
592 1
0.2%
591 1
0.2%
590 1
0.2%

가맹점명
Text

Distinct598
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2023-12-13T04:40:31.306922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length22
Mean length5.984975
Min length2

Characters and Unicode

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

Unique

Unique597 ?
Unique (%)99.7%

Sample

1st row달보드레
2nd row홍인블랙벨트
3rd row길손야식
4th row호식이두마리치킨
5th row세븐일레븐 영동산업고점
ValueCountFrequency (%)
영동점 12
 
1.7%
하나로마트 6
 
0.8%
충북영동점 5
 
0.7%
cu 4
 
0.6%
카페 2
 
0.3%
hair 2
 
0.3%
더제이 2
 
0.3%
양꼬치 2
 
0.3%
오리 2
 
0.3%
주식회사 2
 
0.3%
Other values (668) 673
94.5%
2023-12-13T04:40:31.861863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 115
 
3.2%
영 113
 
3.2%
113
 
3.2%
식 63
 
1.8%
점 61
 
1.7%
원 50
 
1.4%
스 47
 
1.3%
이 45
 
1.3%
당 44
 
1.2%
리 43
 
1.2%
Other values (503) 2891
80.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3295
91.9%
Space Separator 113
 
3.2%
Lowercase Letter 57
 
1.6%
Uppercase Letter 54
 
1.5%
Close Punctuation 24
 
0.7%
Open Punctuation 23
 
0.6%
Other Punctuation 11
 
0.3%
Decimal Number 7
 
0.2%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 115
 
3.5%
영 113
 
3.4%
식 63
 
1.9%
점 61
 
1.9%
원 50
 
1.5%
스 47
 
1.4%
이 45
 
1.4%
당 44
 
1.3%
리 43
 
1.3%
마 42
 
1.3%
Other values (449) 2672
81.1%
Uppercase Letter
ValueCountFrequency (%)
C 9
16.7%
U 6
11.1%
H 5
 
9.3%
B 4
 
7.4%
D 4
 
7.4%
A 3
 
5.6%
O 3
 
5.6%
N 2
 
3.7%
J 2
 
3.7%
S 2
 
3.7%
Other values (11) 14
25.9%
Lowercase Letter
ValueCountFrequency (%)
s 7
12.3%
r 6
10.5%
e 6
10.5%
a 6
10.5%
o 5
8.8%
c 4
 
7.0%
f 3
 
5.3%
n 3
 
5.3%
i 3
 
5.3%
t 2
 
3.5%
Other values (10) 12
21.1%
Decimal Number
ValueCountFrequency (%)
0 2
28.6%
1 2
28.6%
2 1
14.3%
5 1
14.3%
6 1
14.3%
Other Punctuation
ValueCountFrequency (%)
. 5
45.5%
& 3
27.3%
, 2
 
18.2%
' 1
 
9.1%
Space Separator
ValueCountFrequency (%)
113
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3295
91.9%
Common 179
 
5.0%
Latin 111
 
3.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 115
 
3.5%
영 113
 
3.4%
식 63
 
1.9%
점 61
 
1.9%
원 50
 
1.5%
스 47
 
1.4%
이 45
 
1.4%
당 44
 
1.3%
리 43
 
1.3%
마 42
 
1.3%
Other values (449) 2672
81.1%
Latin
ValueCountFrequency (%)
C 9
 
8.1%
s 7
 
6.3%
r 6
 
5.4%
e 6
 
5.4%
a 6
 
5.4%
U 6
 
5.4%
o 5
 
4.5%
H 5
 
4.5%
B 4
 
3.6%
c 4
 
3.6%
Other values (31) 53
47.7%
Common
ValueCountFrequency (%)
113
63.1%
) 24
 
13.4%
( 23
 
12.8%
. 5
 
2.8%
& 3
 
1.7%
0 2
 
1.1%
1 2
 
1.1%
, 2
 
1.1%
- 1
 
0.6%
' 1
 
0.6%
Other values (3) 3
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3295
91.9%
ASCII 290
 
8.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 115
 
3.5%
영 113
 
3.4%
식 63
 
1.9%
점 61
 
1.9%
원 50
 
1.5%
스 47
 
1.4%
이 45
 
1.4%
당 44
 
1.3%
리 43
 
1.3%
마 42
 
1.3%
Other values (449) 2672
81.1%
ASCII
ValueCountFrequency (%)
113
39.0%
) 24
 
8.3%
( 23
 
7.9%
C 9
 
3.1%
s 7
 
2.4%
r 6
 
2.1%
e 6
 
2.1%
a 6
 
2.1%
U 6
 
2.1%
o 5
 
1.7%
Other values (44) 85
29.3%

행정동
Categorical

IMBALANCE 

Distinct11
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
영동읍
441 
황간면
52 
용산면
 
26
학산면
 
16
심천면
 
15
Other values (6)
49 

Length

Max length4
Median length3
Mean length3.0217028
Min length3

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row영동읍
2nd row영동읍
3rd row영동읍
4th row영동읍
5th row영동읍

Common Values

ValueCountFrequency (%)
영동읍 441
73.6%
황간면 52
 
8.7%
용산면 26
 
4.3%
학산면 16
 
2.7%
심천면 15
 
2.5%
상촌면 15
 
2.5%
추풍령면 13
 
2.2%
양산면 9
 
1.5%
양강면 6
 
1.0%
매곡면 5
 
0.8%

Length

2023-12-13T04:40:32.065909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
영동읍 441
73.6%
황간면 52
 
8.7%
용산면 26
 
4.3%
학산면 16
 
2.7%
심천면 15
 
2.5%
상촌면 15
 
2.5%
추풍령면 13
 
2.2%
양산면 9
 
1.5%
양강면 6
 
1.0%
매곡면 5
 
0.8%

업종
Categorical

Distinct8
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
음식점업
254 
소매업
230 
개인서비스업
51 
보건업
 
25
교육서비스업
 
15
Other values (3)
 
24

Length

Max length12
Median length6
Mean length3.9565943
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row음식점업
2nd row교육서비스업
3rd row음식점업
4th row음식점업
5th row소매업

Common Values

ValueCountFrequency (%)
음식점업 254
42.4%
소매업 230
38.4%
개인서비스업 51
 
8.5%
보건업 25
 
4.2%
교육서비스업 15
 
2.5%
스포츠및여가관련서비스업 14
 
2.3%
제조업 5
 
0.8%
기타 5
 
0.8%

Length

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

Common Values (Plot)

2023-12-13T04:40:32.410174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
음식점업 254
42.4%
소매업 230
38.4%
개인서비스업 51
 
8.5%
보건업 25
 
4.2%
교육서비스업 15
 
2.5%
스포츠및여가관련서비스업 14
 
2.3%
제조업 5
 
0.8%
기타 5
 
0.8%

Interactions

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

Correlations

2023-12-13T04:40:32.864938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번행정동업종
순번1.0000.1100.291
행정동0.1101.0000.308
업종0.2910.3081.000
2023-12-13T04:40:32.962816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종행정동
업종1.0000.150
행정동0.1501.000
2023-12-13T04:40:33.054424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번행정동업종
순번1.0000.0460.143
행정동0.0461.0000.150
업종0.1430.1501.000

Missing values

2023-12-13T04:40:30.462451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:40:30.571532image/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달보드레영동읍음식점업
12홍인블랙벨트영동읍교육서비스업
23길손야식영동읍음식점업
34호식이두마리치킨영동읍음식점업
45세븐일레븐 영동산업고점영동읍소매업
56에스타테영동읍음식점업
67천사꽃집영동읍소매업
78맘s 공방영동읍소매업
89김순영음악학원영동읍교육서비스업
910그램그램 영동점영동읍음식점업
순번가맹점명행정동업종
589590아이짱 키즈카페영동읍음식점업
590591순이네식당영동읍음식점업
591592자담치킨영동읍음식점업
592593여자만 회타운영동읍음식점업
593594다다할인몰영동읍소매업
594595청운 돈카츠영동읍음식점업
595596흥부네염소탕영동읍음식점업
596597양가네 흑염소용산면음식점업
597598우체국영동어진동기타
598599NH영동영동읍기타