Overview

Dataset statistics

Number of variables4
Number of observations159
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.3 KiB
Average record size in memory33.8 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Description강원대학교 후문에 위치한 음식점 및 주점 위치 정보
Author강원도 춘천시
URLhttps://www.data.go.kr/data/15005303/fileData.do

Alerts

업종명 is highly imbalanced (61.4%)Imbalance
연번 has unique valuesUnique
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:07:18.542185
Analysis finished2023-12-12 14:07:19.060961
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct159
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80
Minimum1
Maximum159
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T23:07:19.149338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8.9
Q140.5
median80
Q3119.5
95-th percentile151.1
Maximum159
Range158
Interquartile range (IQR)79

Descriptive statistics

Standard deviation46.043458
Coefficient of variation (CV)0.57554322
Kurtosis-1.2
Mean80
Median Absolute Deviation (MAD)40
Skewness0
Sum12720
Variance2120
MonotonicityStrictly increasing
2023-12-12T23:07:19.316088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
2 1
 
0.6%
103 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
Other values (149) 149
93.7%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
159 1
0.6%
158 1
0.6%
157 1
0.6%
156 1
0.6%
155 1
0.6%
154 1
0.6%
153 1
0.6%
152 1
0.6%
151 1
0.6%
150 1
0.6%

업종명
Categorical

IMBALANCE 

Distinct2
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
일반음식점
147 
휴게음식점
 
12

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row일반음식점
3rd row일반음식점
4th row일반음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 147
92.5%
휴게음식점 12
 
7.5%

Length

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

Common Values (Plot)

2023-12-12T23:07:19.567729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 147
92.5%
휴게음식점 12
 
7.5%

업소명
Text

UNIQUE 

Distinct159
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T23:07:19.853685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length5.3962264
Min length1

Characters and Unicode

Total characters858
Distinct characters289
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

Unique159 ?
Unique (%)100.0%

Sample

1st row뮤엘
2nd row아메리칸박스
3rd row
4th row맑은술이야기(본점)
5th row참맛부흥닭갈비
ValueCountFrequency (%)
뮤엘 1
 
0.6%
서라벌 1
 
0.6%
할머니청국장 1
 
0.6%
지젤 1
 
0.6%
라바 1
 
0.6%
쟈니스바 1
 
0.6%
지오 1
 
0.6%
박가부대춘천강대점 1
 
0.6%
죠스떡볶이강원대점 1
 
0.6%
구이가(강원대점 1
 
0.6%
Other values (150) 150
93.8%
2023-12-12T23:07:20.328970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
42
 
4.9%
36
 
4.2%
35
 
4.1%
35
 
4.1%
20
 
2.3%
19
 
2.2%
( 18
 
2.1%
) 18
 
2.1%
16
 
1.9%
14
 
1.6%
Other values (279) 605
70.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 799
93.1%
Open Punctuation 18
 
2.1%
Close Punctuation 18
 
2.1%
Lowercase Letter 9
 
1.0%
Decimal Number 8
 
0.9%
Uppercase Letter 4
 
0.5%
Space Separator 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
42
 
5.3%
36
 
4.5%
35
 
4.4%
35
 
4.4%
20
 
2.5%
19
 
2.4%
16
 
2.0%
14
 
1.8%
12
 
1.5%
12
 
1.5%
Other values (262) 558
69.8%
Lowercase Letter
ValueCountFrequency (%)
o 2
22.2%
i 2
22.2%
c 1
11.1%
k 1
11.1%
v 1
11.1%
s 1
11.1%
l 1
11.1%
Uppercase Letter
ValueCountFrequency (%)
M 1
25.0%
E 1
25.0%
A 1
25.0%
T 1
25.0%
Decimal Number
ValueCountFrequency (%)
2 6
75.0%
3 1
 
12.5%
1 1
 
12.5%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 799
93.1%
Common 46
 
5.4%
Latin 13
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
42
 
5.3%
36
 
4.5%
35
 
4.4%
35
 
4.4%
20
 
2.5%
19
 
2.4%
16
 
2.0%
14
 
1.8%
12
 
1.5%
12
 
1.5%
Other values (262) 558
69.8%
Latin
ValueCountFrequency (%)
o 2
15.4%
i 2
15.4%
M 1
7.7%
c 1
7.7%
k 1
7.7%
v 1
7.7%
s 1
7.7%
l 1
7.7%
E 1
7.7%
A 1
7.7%
Common
ValueCountFrequency (%)
( 18
39.1%
) 18
39.1%
2 6
 
13.0%
2
 
4.3%
3 1
 
2.2%
1 1
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 799
93.1%
ASCII 59
 
6.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
42
 
5.3%
36
 
4.5%
35
 
4.4%
35
 
4.4%
20
 
2.5%
19
 
2.4%
16
 
2.0%
14
 
1.8%
12
 
1.5%
12
 
1.5%
Other values (262) 558
69.8%
ASCII
ValueCountFrequency (%)
( 18
30.5%
) 18
30.5%
2 6
 
10.2%
2
 
3.4%
o 2
 
3.4%
i 2
 
3.4%
M 1
 
1.7%
c 1
 
1.7%
k 1
 
1.7%
v 1
 
1.7%
Other values (7) 7
 
11.9%
Distinct143
Distinct (%)89.9%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T23:07:20.551198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length33
Mean length27.301887
Min length19

Characters and Unicode

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

Unique

Unique129 ?
Unique (%)81.1%

Sample

1st row강원도 춘천시 서부대성로227번길 7-1 (효자동, 3층.4층)
2nd row강원도 춘천시 서부대성로227번길 7-1, 3동 2층 (효자동)
3rd row강원도 춘천시 백령로138번길 7 (효자동, 1층)
4th row강원도 춘천시 백령로138번길 9 (효자동)
5th row강원도 춘천시 백령로138번길 13 (효자동)
ValueCountFrequency (%)
강원도 159
17.6%
춘천시 159
17.6%
효자동 159
17.6%
백령로138번길 68
 
7.5%
서부대성로 57
 
6.3%
2층 29
 
3.2%
1층 29
 
3.2%
3동 19
 
2.1%
서부대성로227번길 14
 
1.5%
서부대성로239번길 9
 
1.0%
Other values (97) 202
22.3%
2023-12-12T23:07:20.929605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
745
 
17.2%
181
 
4.2%
2 180
 
4.1%
1 172
 
4.0%
3 169
 
3.9%
) 160
 
3.7%
( 160
 
3.7%
159
 
3.7%
159
 
3.7%
159
 
3.7%
Other values (31) 2097
48.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2388
55.0%
Decimal Number 770
 
17.7%
Space Separator 745
 
17.2%
Close Punctuation 160
 
3.7%
Open Punctuation 160
 
3.7%
Other Punctuation 96
 
2.2%
Dash Punctuation 21
 
0.5%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
181
 
7.6%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
Other values (14) 776
32.5%
Decimal Number
ValueCountFrequency (%)
2 180
23.4%
1 172
22.3%
3 169
21.9%
8 87
11.3%
4 42
 
5.5%
9 33
 
4.3%
7 33
 
4.3%
5 32
 
4.2%
6 12
 
1.6%
0 10
 
1.3%
Other Punctuation
ValueCountFrequency (%)
, 95
99.0%
. 1
 
1.0%
Space Separator
ValueCountFrequency (%)
745
100.0%
Close Punctuation
ValueCountFrequency (%)
) 160
100.0%
Open Punctuation
ValueCountFrequency (%)
( 160
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2388
55.0%
Common 1953
45.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
181
 
7.6%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
Other values (14) 776
32.5%
Common
ValueCountFrequency (%)
745
38.1%
2 180
 
9.2%
1 172
 
8.8%
3 169
 
8.7%
) 160
 
8.2%
( 160
 
8.2%
, 95
 
4.9%
8 87
 
4.5%
4 42
 
2.2%
9 33
 
1.7%
Other values (7) 110
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2388
55.0%
ASCII 1953
45.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
745
38.1%
2 180
 
9.2%
1 172
 
8.8%
3 169
 
8.7%
) 160
 
8.2%
( 160
 
8.2%
, 95
 
4.9%
8 87
 
4.5%
4 42
 
2.2%
9 33
 
1.7%
Other values (7) 110
 
5.6%
Hangul
ValueCountFrequency (%)
181
 
7.6%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
159
 
6.7%
Other values (14) 776
32.5%

Interactions

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

Correlations

2023-12-12T23:07:21.039385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.237
업종명0.2371.000
2023-12-12T23:07:21.145542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.179
업종명0.1791.000

Missing values

2023-12-12T23:07:18.905917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:07:19.021066image/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일반음식점뮤엘강원도 춘천시 서부대성로227번길 7-1 (효자동, 3층.4층)
12일반음식점아메리칸박스강원도 춘천시 서부대성로227번길 7-1, 3동 2층 (효자동)
23일반음식점강원도 춘천시 백령로138번길 7 (효자동, 1층)
34일반음식점맑은술이야기(본점)강원도 춘천시 백령로138번길 9 (효자동)
45일반음식점참맛부흥닭갈비강원도 춘천시 백령로138번길 13 (효자동)
56일반음식점캠퍼스닭갈비강원도 춘천시 백령로138번길 15 (효자동)
67일반음식점강원도 춘천시 백령로138번길 15, 2층 (효자동)
78일반음식점앳(AT)강원도 춘천시 백령로138번길 15, 4층 (효자동)
89일반음식점투엔디춘천강원대점강원도 춘천시 백령로138번길 17 (효자동)
910일반음식점피쉬앤그릴강대후문점강원도 춘천시 백령로138번길 17 (효자동)
연번업종명업소명소재지(도로명)
149150일반음식점자전차강원도 춘천시 백령로138번길 52 (효자동)
150151일반음식점행복한끼니강원도 춘천시 백령로138번길 52 (효자동, 1층)
151152일반음식점대학로탕수육강원도 춘천시 후만로 3 (효자동)
152153휴게음식점강대삼단토스트강원도 춘천시 후만로 3, 1층 (효자동)
153154일반음식점한솥도시락강원도 춘천시 서부대성로 251 (효자동)
154155일반음식점원수제돈가스강원도 춘천시 서부대성로 251-1 (효자동)
155156일반음식점곰돌이스넥강원도 춘천시 후만로 5 (효자동)
156157일반음식점종각빈대떡강원도 춘천시 후만로 5 (효자동)
157158일반음식점이모네강원도 춘천시 백령로138번길 69 (효자동, 1층)
158159일반음식점순살파닭(춘천점)강원도 춘천시 후만로 7 (효자동)