Overview

Dataset statistics

Number of variables5
Number of observations1405
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory56.4 KiB
Average record size in memory41.1 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description음식류를 조리·판매하는 영업으로서 식사와 함께 부수적으로 음주행위가 허용되는 영업장에 대한 현황(업소명, 도로명주소, 업태명, 전화번호) 데이터
Author경상북도 상주시
URLhttps://www.data.go.kr/data/3049745/fileData.do

Alerts

연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:01:29.877526
Analysis finished2023-12-12 20:01:30.547321
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1405
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean703
Minimum1
Maximum1405
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size12.5 KiB
2023-12-13T05:01:30.857005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile71.2
Q1352
median703
Q31054
95-th percentile1334.8
Maximum1405
Range1404
Interquartile range (IQR)702

Descriptive statistics

Standard deviation405.73288
Coefficient of variation (CV)0.57714492
Kurtosis-1.2
Mean703
Median Absolute Deviation (MAD)351
Skewness0
Sum987715
Variance164619.17
MonotonicityStrictly increasing
2023-12-13T05:01:30.969105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
935 1
 
0.1%
943 1
 
0.1%
942 1
 
0.1%
941 1
 
0.1%
940 1
 
0.1%
939 1
 
0.1%
938 1
 
0.1%
937 1
 
0.1%
936 1
 
0.1%
Other values (1395) 1395
99.3%
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 (%)
1405 1
0.1%
1404 1
0.1%
1403 1
0.1%
1402 1
0.1%
1401 1
0.1%
1400 1
0.1%
1399 1
0.1%
1398 1
0.1%
1397 1
0.1%
1396 1
0.1%
Distinct1395
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size11.1 KiB
2023-12-13T05:01:31.148688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length5.6498221
Min length1

Characters and Unicode

Total characters7938
Distinct characters619
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

Unique1386 ?
Unique (%)98.6%

Sample

1st row골목해장국
2nd row남성통닭
3rd row울산식당
4th row장성각
5th row공주식당
ValueCountFrequency (%)
상주점 23
 
1.5%
경북상주점 4
 
0.3%
대성식당 3
 
0.2%
카페 3
 
0.2%
구내식당 3
 
0.2%
밥상 3
 
0.2%
식당 3
 
0.2%
치킨 3
 
0.2%
돼지국밥 3
 
0.2%
김밥나라 2
 
0.1%
Other values (1499) 1521
96.8%
2023-12-13T05:01:31.552526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
358
 
4.5%
289
 
3.6%
168
 
2.1%
166
 
2.1%
162
 
2.0%
144
 
1.8%
127
 
1.6%
111
 
1.4%
110
 
1.4%
107
 
1.3%
Other values (609) 6196
78.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7414
93.4%
Space Separator 166
 
2.1%
Lowercase Letter 78
 
1.0%
Uppercase Letter 63
 
0.8%
Open Punctuation 59
 
0.7%
Close Punctuation 59
 
0.7%
Decimal Number 58
 
0.7%
Other Punctuation 40
 
0.5%
Modifier Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
358
 
4.8%
289
 
3.9%
168
 
2.3%
162
 
2.2%
144
 
1.9%
127
 
1.7%
111
 
1.5%
110
 
1.5%
107
 
1.4%
96
 
1.3%
Other values (549) 5742
77.4%
Uppercase Letter
ValueCountFrequency (%)
C 7
 
11.1%
T 5
 
7.9%
A 4
 
6.3%
O 4
 
6.3%
L 4
 
6.3%
S 4
 
6.3%
B 4
 
6.3%
Y 3
 
4.8%
H 3
 
4.8%
M 3
 
4.8%
Other values (12) 22
34.9%
Lowercase Letter
ValueCountFrequency (%)
e 11
14.1%
o 10
12.8%
a 9
11.5%
f 6
 
7.7%
n 6
 
7.7%
i 5
 
6.4%
l 5
 
6.4%
r 4
 
5.1%
m 3
 
3.8%
t 3
 
3.8%
Other values (8) 16
20.5%
Decimal Number
ValueCountFrequency (%)
1 15
25.9%
0 8
13.8%
5 6
 
10.3%
2 6
 
10.3%
6 5
 
8.6%
4 5
 
8.6%
3 5
 
8.6%
9 4
 
6.9%
8 3
 
5.2%
7 1
 
1.7%
Other Punctuation
ValueCountFrequency (%)
& 21
52.5%
. 9
22.5%
, 6
 
15.0%
! 2
 
5.0%
· 1
 
2.5%
' 1
 
2.5%
Space Separator
ValueCountFrequency (%)
166
100.0%
Open Punctuation
ValueCountFrequency (%)
( 59
100.0%
Close Punctuation
ValueCountFrequency (%)
) 59
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7411
93.4%
Common 383
 
4.8%
Latin 141
 
1.8%
Han 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
358
 
4.8%
289
 
3.9%
168
 
2.3%
162
 
2.2%
144
 
1.9%
127
 
1.7%
111
 
1.5%
110
 
1.5%
107
 
1.4%
96
 
1.3%
Other values (546) 5739
77.4%
Latin
ValueCountFrequency (%)
e 11
 
7.8%
o 10
 
7.1%
a 9
 
6.4%
C 7
 
5.0%
f 6
 
4.3%
n 6
 
4.3%
T 5
 
3.5%
i 5
 
3.5%
l 5
 
3.5%
A 4
 
2.8%
Other values (30) 73
51.8%
Common
ValueCountFrequency (%)
166
43.3%
( 59
 
15.4%
) 59
 
15.4%
& 21
 
5.5%
1 15
 
3.9%
. 9
 
2.3%
0 8
 
2.1%
5 6
 
1.6%
, 6
 
1.6%
2 6
 
1.6%
Other values (10) 28
 
7.3%
Han
ValueCountFrequency (%)
1
33.3%
1
33.3%
1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7411
93.4%
ASCII 523
 
6.6%
CJK 3
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
358
 
4.8%
289
 
3.9%
168
 
2.3%
162
 
2.2%
144
 
1.9%
127
 
1.7%
111
 
1.5%
110
 
1.5%
107
 
1.4%
96
 
1.3%
Other values (546) 5739
77.4%
ASCII
ValueCountFrequency (%)
166
31.7%
( 59
 
11.3%
) 59
 
11.3%
& 21
 
4.0%
1 15
 
2.9%
e 11
 
2.1%
o 10
 
1.9%
a 9
 
1.7%
. 9
 
1.7%
0 8
 
1.5%
Other values (49) 156
29.8%
CJK
ValueCountFrequency (%)
1
33.3%
1
33.3%
1
33.3%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct1269
Distinct (%)90.3%
Missing0
Missing (%)0.0%
Memory size11.1 KiB
2023-12-13T05:01:31.886001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length51
Mean length23.209253
Min length15

Characters and Unicode

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

Unique

Unique1165 ?
Unique (%)82.9%

Sample

1st row경상북도 상주시 왕산로 192 (성하동)
2nd row경상북도 상주시 중앙시장길 16-13 (남성동)
3rd row경상북도 상주시 함창읍 함창중앙로 147-1
4th row경상북도 상주시 함창읍 함창중앙로 126 (203-5,589-27,141-1)
5th row경상북도 상주시 함창읍 모개낭1길 15
ValueCountFrequency (%)
경상북도 1405
 
19.6%
상주시 1405
 
19.6%
무양동 170
 
2.4%
남성동 170
 
2.4%
경상대로 97
 
1.4%
함창읍 94
 
1.3%
상산로 89
 
1.2%
삼백로 87
 
1.2%
서문동 82
 
1.1%
서성동 72
 
1.0%
Other values (1074) 3514
48.9%
2023-12-13T05:01:32.355295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5780
17.7%
3118
 
9.6%
1512
 
4.6%
1471
 
4.5%
1465
 
4.5%
1448
 
4.4%
1417
 
4.3%
1 1212
 
3.7%
1160
 
3.6%
( 976
 
3.0%
Other values (205) 13050
40.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 19342
59.3%
Space Separator 5780
 
17.7%
Decimal Number 4917
 
15.1%
Open Punctuation 978
 
3.0%
Close Punctuation 978
 
3.0%
Dash Punctuation 401
 
1.2%
Other Punctuation 207
 
0.6%
Uppercase Letter 4
 
< 0.1%
Lowercase Letter 1
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3118
16.1%
1512
 
7.8%
1471
 
7.6%
1465
 
7.6%
1448
 
7.5%
1417
 
7.3%
1160
 
6.0%
791
 
4.1%
609
 
3.1%
484
 
2.5%
Other values (181) 5867
30.3%
Decimal Number
ValueCountFrequency (%)
1 1212
24.6%
2 742
15.1%
3 647
13.2%
4 418
 
8.5%
5 365
 
7.4%
6 360
 
7.3%
0 330
 
6.7%
7 289
 
5.9%
8 285
 
5.8%
9 269
 
5.5%
Other Punctuation
ValueCountFrequency (%)
, 204
98.6%
* 2
 
1.0%
. 1
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
A 2
50.0%
H 1
25.0%
F 1
25.0%
Open Punctuation
ValueCountFrequency (%)
( 976
99.8%
[ 2
 
0.2%
Close Punctuation
ValueCountFrequency (%)
) 976
99.8%
] 2
 
0.2%
Space Separator
ValueCountFrequency (%)
5780
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 401
100.0%
Lowercase Letter
ValueCountFrequency (%)
j 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19342
59.3%
Common 13262
40.7%
Latin 5
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3118
16.1%
1512
 
7.8%
1471
 
7.6%
1465
 
7.6%
1448
 
7.5%
1417
 
7.3%
1160
 
6.0%
791
 
4.1%
609
 
3.1%
484
 
2.5%
Other values (181) 5867
30.3%
Common
ValueCountFrequency (%)
5780
43.6%
1 1212
 
9.1%
( 976
 
7.4%
) 976
 
7.4%
2 742
 
5.6%
3 647
 
4.9%
4 418
 
3.2%
- 401
 
3.0%
5 365
 
2.8%
6 360
 
2.7%
Other values (10) 1385
 
10.4%
Latin
ValueCountFrequency (%)
A 2
40.0%
j 1
20.0%
H 1
20.0%
F 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19342
59.3%
ASCII 13267
40.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5780
43.6%
1 1212
 
9.1%
( 976
 
7.4%
) 976
 
7.4%
2 742
 
5.6%
3 647
 
4.9%
4 418
 
3.2%
- 401
 
3.0%
5 365
 
2.8%
6 360
 
2.7%
Other values (14) 1390
 
10.5%
Hangul
ValueCountFrequency (%)
3118
16.1%
1512
 
7.8%
1471
 
7.6%
1465
 
7.6%
1448
 
7.5%
1417
 
7.3%
1160
 
6.0%
791
 
4.1%
609
 
3.1%
484
 
2.5%
Other values (181) 5867
30.3%
Distinct1074
Distinct (%)76.4%
Missing0
Missing (%)0.0%
Memory size11.1 KiB
2023-12-13T05:01:32.654352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length10.667616
Min length6

Characters and Unicode

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

Unique

Unique1057 ?
Unique (%)75.2%

Sample

1st row054-535-6021
2nd row054-535-5076
3rd row054-541-3737
4th row054-541-8228
5th row054-541-2431
ValueCountFrequency (%)
개인정보포함 313
 
22.3%
054-530-8888 5
 
0.4%
054-531-1982 2
 
0.1%
054-533-0788 2
 
0.1%
054-532-9993 2
 
0.1%
054-541-4849 2
 
0.1%
054-541-9575 2
 
0.1%
054-536-1575 2
 
0.1%
054-534-5595 2
 
0.1%
054-536-5567 2
 
0.1%
Other values (1064) 1071
76.2%
2023-12-13T05:01:33.148340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 2826
18.9%
- 2184
14.6%
4 1702
11.4%
0 1639
10.9%
3 1566
10.4%
2 622
 
4.1%
1 617
 
4.1%
6 538
 
3.6%
9 487
 
3.2%
8 482
 
3.2%
Other values (7) 2325
15.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 10926
72.9%
Dash Punctuation 2184
 
14.6%
Other Letter 1878
 
12.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 2826
25.9%
4 1702
15.6%
0 1639
15.0%
3 1566
14.3%
2 622
 
5.7%
1 617
 
5.6%
6 538
 
4.9%
9 487
 
4.5%
8 482
 
4.4%
7 447
 
4.1%
Other Letter
ValueCountFrequency (%)
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%
Dash Punctuation
ValueCountFrequency (%)
- 2184
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13110
87.5%
Hangul 1878
 
12.5%

Most frequent character per script

Common
ValueCountFrequency (%)
5 2826
21.6%
- 2184
16.7%
4 1702
13.0%
0 1639
12.5%
3 1566
11.9%
2 622
 
4.7%
1 617
 
4.7%
6 538
 
4.1%
9 487
 
3.7%
8 482
 
3.7%
Hangul
ValueCountFrequency (%)
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 13110
87.5%
Hangul 1878
 
12.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 2826
21.6%
- 2184
16.7%
4 1702
13.0%
0 1639
12.5%
3 1566
11.9%
2 622
 
4.7%
1 617
 
4.7%
6 538
 
4.1%
9 487
 
3.7%
8 482
 
3.7%
Hangul
ValueCountFrequency (%)
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%
313
16.7%

업태명
Categorical

Distinct21
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size11.1 KiB
한식
648 
기타
233 
식육(숯불구이)
134 
호프/통닭
72 
중국식
68 
Other values (16)
250 

Length

Max length15
Median length2
Mean length3.1886121
Min length2

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row한식
2nd row통닭(치킨)
3rd row한식
4th row중국식
5th row한식

Common Values

ValueCountFrequency (%)
한식 648
46.1%
기타 233
 
16.6%
식육(숯불구이) 134
 
9.5%
호프/통닭 72
 
5.1%
중국식 68
 
4.8%
분식 64
 
4.6%
통닭(치킨) 44
 
3.1%
횟집 36
 
2.6%
탕류(보신용) 22
 
1.6%
경양식 19
 
1.4%
Other values (11) 65
 
4.6%

Length

2023-12-13T05:01:33.327092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
한식 648
46.1%
기타 233
 
16.6%
식육(숯불구이 134
 
9.5%
호프/통닭 72
 
5.1%
중국식 68
 
4.8%
분식 64
 
4.6%
통닭(치킨 44
 
3.1%
횟집 36
 
2.6%
탕류(보신용 22
 
1.6%
경양식 19
 
1.4%
Other values (11) 65
 
4.6%

Interactions

2023-12-13T05:01:30.317668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:01:33.414309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업태명
연번1.0000.323
업태명0.3231.000
2023-12-13T05:01:33.498921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업태명
연번1.0000.124
업태명0.1241.000

Missing values

2023-12-13T05:01:30.428966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:01:30.509147image/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골목해장국경상북도 상주시 왕산로 192 (성하동)054-535-6021한식
12남성통닭경상북도 상주시 중앙시장길 16-13 (남성동)054-535-5076통닭(치킨)
23울산식당경상북도 상주시 함창읍 함창중앙로 147-1054-541-3737한식
34장성각경상북도 상주시 함창읍 함창중앙로 126 (203-5,589-27,141-1)054-541-8228중국식
45공주식당경상북도 상주시 함창읍 모개낭1길 15054-541-2431한식
56달무리식당경상북도 상주시 함창읍 함창시장1길 38054-533-7305한식
67충무식당경상북도 상주시 함창읍 함창중앙로 125-1054-541-7079한식
78시장닭집경상북도 상주시 함창읍 함창시장1길 63-17054-541-2426통닭(치킨)
89함창반점경상북도 상주시 함창읍 함창중앙로 104054-541-0287중국식
910할매손두부집경상북도 상주시 함창읍 함창중앙로 100-6054-541-0437한식
연번업소명소재지(도로명)소재지전화업태명
13951396삼천리 식당경상북도 상주시 은척면 봉중1길 16-6, 1층개인정보포함한식
13961397청담1985경상북도 상주시 동수1길 89, 1층 (무양동)개인정보포함기타
13971398多맛집(다맛집)경상북도 상주시 동수4길 30, 1층 (무양동)개인정보포함한식
13981399화플경상북도 상주시 동수1길 92, 1층 (서문동)개인정보포함기타
13991400사랑한다면 어탕칼국수경상북도 상주시 화산1길 5 (화산동)개인정보포함한식
14001401이가네 메밀막국수경상북도 상주시 무양2길 65, 1층 (무양동)개인정보포함한식
14011402박대감동죽칼국수경상북도 상주시 동수4길 38-10, 1층 (무양동)054-531-9294한식
14021403임금님밥상경상북도 상주시 이안면 북상주로 1417, 1층개인정보포함한식
14031404카페65경상북도 상주시 은척면 성주봉로 65, 1층개인정보포함기타
14041405윤훈식농가쌈밥 상주점경상북도 상주시 삼백로 274, 로스트 (복룡동)개인정보포함한식