Overview

Dataset statistics

Number of variables6
Number of observations92
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory50.4 B

Variable types

Numeric1
Text3
Categorical1
DateTime1

Dataset

Description서울시 종로구에서 영업하고 있는 모범음식점 선정에 대한 데이터로 업소명, 주소, 전화번호, 업태등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/3054122/fileData.do

Alerts

기준일자 has constant value ""Constant
연번 has unique valuesUnique
소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:40:26.954083
Analysis finished2023-12-12 14:40:28.084455
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct92
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46.5
Minimum1
Maximum92
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size960.0 B
2023-12-12T23:40:28.196401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.55
Q123.75
median46.5
Q369.25
95-th percentile87.45
Maximum92
Range91
Interquartile range (IQR)45.5

Descriptive statistics

Standard deviation26.70206
Coefficient of variation (CV)0.57423785
Kurtosis-1.2
Mean46.5
Median Absolute Deviation (MAD)23
Skewness0
Sum4278
Variance713
MonotonicityStrictly increasing
2023-12-12T23:40:28.393986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.1%
60 1
 
1.1%
69 1
 
1.1%
68 1
 
1.1%
67 1
 
1.1%
66 1
 
1.1%
65 1
 
1.1%
64 1
 
1.1%
63 1
 
1.1%
62 1
 
1.1%
Other values (82) 82
89.1%
ValueCountFrequency (%)
1 1
1.1%
2 1
1.1%
3 1
1.1%
4 1
1.1%
5 1
1.1%
6 1
1.1%
7 1
1.1%
8 1
1.1%
9 1
1.1%
10 1
1.1%
ValueCountFrequency (%)
92 1
1.1%
91 1
1.1%
90 1
1.1%
89 1
1.1%
88 1
1.1%
87 1
1.1%
86 1
1.1%
85 1
1.1%
84 1
1.1%
83 1
1.1%

업소명
Text

Distinct91
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T23:40:28.649474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length5.2717391
Min length2

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)97.8%

Sample

1st row(주)베이징코야
2nd row(주)석파랑
3rd row(주)토속촌삼계탕
4th row감촌
5th row고창선운사풍천장어금정
ValueCountFrequency (%)
신안촌 2
 
1.8%
앤 1
 
0.9%
전주골갈비 1
 
0.9%
일품당샤브샤브 1
 
0.9%
오수사 1
 
0.9%
일식 1
 
0.9%
일산칼국수 1
 
0.9%
인사동두부마을 1
 
0.9%
설농탕 1
 
0.9%
이문 1
 
0.9%
Other values (101) 101
90.2%
2023-12-12T23:40:29.099537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20
 
4.1%
대 11
 
2.3%
가 10
 
2.1%
집 10
 
2.1%
동 8
 
1.6%
옥 8
 
1.6%
나 7
 
1.4%
마 7
 
1.4%
어 6
 
1.2%
비 6
 
1.2%
Other values (200) 392
80.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 451
93.0%
Space Separator 20
 
4.1%
Open Punctuation 6
 
1.2%
Close Punctuation 6
 
1.2%
Other Punctuation 1
 
0.2%
Decimal Number 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 11
 
2.4%
가 10
 
2.2%
집 10
 
2.2%
동 8
 
1.8%
옥 8
 
1.8%
나 7
 
1.6%
마 7
 
1.6%
어 6
 
1.3%
비 6
 
1.3%
탕 6
 
1.3%
Other values (195) 372
82.5%
Space Separator
ValueCountFrequency (%)
20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 449
92.6%
Common 34
 
7.0%
Han 2
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 11
 
2.4%
가 10
 
2.2%
집 10
 
2.2%
동 8
 
1.8%
옥 8
 
1.8%
나 7
 
1.6%
마 7
 
1.6%
어 6
 
1.3%
비 6
 
1.3%
탕 6
 
1.3%
Other values (193) 370
82.4%
Common
ValueCountFrequency (%)
20
58.8%
( 6
 
17.6%
) 6
 
17.6%
. 1
 
2.9%
2 1
 
2.9%
Han
ValueCountFrequency (%)
心 1
50.0%
羊 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 449
92.6%
ASCII 34
 
7.0%
CJK 2
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
20
58.8%
( 6
 
17.6%
) 6
 
17.6%
. 1
 
2.9%
2 1
 
2.9%
Hangul
ValueCountFrequency (%)
대 11
 
2.4%
가 10
 
2.2%
집 10
 
2.2%
동 8
 
1.8%
옥 8
 
1.8%
나 7
 
1.6%
마 7
 
1.6%
어 6
 
1.3%
비 6
 
1.3%
탕 6
 
1.3%
Other values (193) 370
82.4%
CJK
ValueCountFrequency (%)
心 1
50.0%
羊 1
50.0%

소재지(도로명)
Text

UNIQUE 

Distinct92
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T23:40:29.384053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length36.5
Mean length29.771739
Min length21

Characters and Unicode

Total characters2739
Distinct characters129
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

Unique92 ?
Unique (%)100.0%

Sample

1st row서울특별시 종로구 율곡로2길 29-1, 지하1층 (수송동)
2nd row서울특별시 종로구 자하문로 309, 1층 (홍지동)
3rd row서울특별시 종로구 자하문로5길 5, 지상1층 (체부동, (체부동 86-1,2,3))
4th row서울특별시 종로구 종로 19, 5층 511호 일부, 512호 (종로1가)
5th row서울특별시 종로구 대학로2길 38 (종로5가)
ValueCountFrequency (%)
서울특별시 92
 
17.6%
종로구 92
 
17.6%
1층 15
 
2.9%
관훈동 10
 
1.9%
지하1층 7
 
1.3%
자하문로 6
 
1.1%
종로 6
 
1.1%
낙원동 5
 
1.0%
통의동 5
 
1.0%
숭인동 5
 
1.0%
Other values (212) 281
53.6%
2023-12-12T23:40:29.837769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
432
 
15.8%
로 172
 
6.3%
1 155
 
5.7%
종 112
 
4.1%
동 99
 
3.6%
) 97
 
3.5%
( 97
 
3.5%
구 94
 
3.4%
서 93
 
3.4%
특 92
 
3.4%
Other values (119) 1296
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1529
55.8%
Decimal Number 454
 
16.6%
Space Separator 432
 
15.8%
Close Punctuation 97
 
3.5%
Open Punctuation 97
 
3.5%
Other Punctuation 86
 
3.1%
Dash Punctuation 36
 
1.3%
Math Symbol 7
 
0.3%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 172
 
11.2%
종 112
 
7.3%
동 99
 
6.5%
구 94
 
6.1%
서 93
 
6.1%
특 92
 
6.0%
별 92
 
6.0%
시 92
 
6.0%
울 92
 
6.0%
층 57
 
3.7%
Other values (101) 534
34.9%
Decimal Number
ValueCountFrequency (%)
1 155
34.1%
2 69
15.2%
3 46
 
10.1%
4 45
 
9.9%
5 34
 
7.5%
0 30
 
6.6%
8 23
 
5.1%
9 20
 
4.4%
6 18
 
4.0%
7 14
 
3.1%
Other Punctuation
ValueCountFrequency (%)
, 84
97.7%
. 2
 
2.3%
Space Separator
ValueCountFrequency (%)
432
100.0%
Close Punctuation
ValueCountFrequency (%)
) 97
100.0%
Open Punctuation
ValueCountFrequency (%)
( 97
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 36
100.0%
Math Symbol
ValueCountFrequency (%)
~ 7
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1529
55.8%
Common 1209
44.1%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 172
 
11.2%
종 112
 
7.3%
동 99
 
6.5%
구 94
 
6.1%
서 93
 
6.1%
특 92
 
6.0%
별 92
 
6.0%
시 92
 
6.0%
울 92
 
6.0%
층 57
 
3.7%
Other values (101) 534
34.9%
Common
ValueCountFrequency (%)
432
35.7%
1 155
 
12.8%
) 97
 
8.0%
( 97
 
8.0%
, 84
 
6.9%
2 69
 
5.7%
3 46
 
3.8%
4 45
 
3.7%
- 36
 
3.0%
5 34
 
2.8%
Other values (7) 114
 
9.4%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1529
55.8%
ASCII 1210
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
432
35.7%
1 155
 
12.8%
) 97
 
8.0%
( 97
 
8.0%
, 84
 
6.9%
2 69
 
5.7%
3 46
 
3.8%
4 45
 
3.7%
- 36
 
3.0%
5 34
 
2.8%
Other values (8) 115
 
9.5%
Hangul
ValueCountFrequency (%)
로 172
 
11.2%
종 112
 
7.3%
동 99
 
6.5%
구 94
 
6.1%
서 93
 
6.1%
특 92
 
6.0%
별 92
 
6.0%
시 92
 
6.0%
울 92
 
6.0%
층 57
 
3.7%
Other values (101) 534
34.9%

업태
Categorical

Distinct10
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size868.0 B
한식
63 
일식
9 
경양식
 
6
기타
 
5
분식
 
4
Other values (5)
 
5

Length

Max length8
Median length2
Mean length2.2173913
Min length2

Unique

Unique5 ?
Unique (%)5.4%

Sample

1st row중식
2nd row한식
3rd row한식
4th row한식
5th row한식

Common Values

ValueCountFrequency (%)
한식 63
68.5%
일식 9
 
9.8%
경양식 6
 
6.5%
기타 5
 
5.4%
분식 4
 
4.3%
중식 1
 
1.1%
식육(숯불구이) 1
 
1.1%
중국식 1
 
1.1%
탕류(보신용) 1
 
1.1%
복어취급 1
 
1.1%

Length

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

Common Values (Plot)

2023-12-12T23:40:30.121555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 63
68.5%
일식 9
 
9.8%
경양식 6
 
6.5%
기타 5
 
5.4%
분식 4
 
4.3%
중식 1
 
1.1%
식육(숯불구이 1
 
1.1%
중국식 1
 
1.1%
탕류(보신용 1
 
1.1%
복어취급 1
 
1.1%

주메뉴
Text

Distinct69
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Memory size868.0 B
2023-12-12T23:40:30.354657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length3.8369565
Min length1

Characters and Unicode

Total characters353
Distinct characters107
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

Unique56 ?
Unique (%)60.9%

Sample

1st row북경오리구이
2nd row한정식
3rd row삼계탕
4th row순두부
5th row장어구이
ValueCountFrequency (%)
한정식 10
 
9.5%
갈비탕 5
 
4.8%
설렁탕 3
 
2.9%
불고기 3
 
2.9%
샤브샤브 3
 
2.9%
전골 3
 
2.9%
낙지 3
 
2.9%
냉면 2
 
1.9%
스테이크 2
 
1.9%
홍어 2
 
1.9%
Other values (61) 69
65.7%
2023-12-12T23:40:30.775015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
탕 18
 
5.1%
, 14
 
4.0%
장 13
 
3.7%
13
 
3.7%
갈 13
 
3.7%
식 12
 
3.4%
비 12
 
3.4%
한 11
 
3.1%
정 11
 
3.1%
어 9
 
2.5%
Other values (97) 227
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 326
92.4%
Other Punctuation 14
 
4.0%
Space Separator 13
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
탕 18
 
5.5%
장 13
 
4.0%
갈 13
 
4.0%
식 12
 
3.7%
비 12
 
3.7%
한 11
 
3.4%
정 11
 
3.4%
어 9
 
2.8%
지 8
 
2.5%
이 7
 
2.1%
Other values (95) 212
65.0%
Other Punctuation
ValueCountFrequency (%)
, 14
100.0%
Space Separator
ValueCountFrequency (%)
13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 326
92.4%
Common 27
 
7.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
탕 18
 
5.5%
장 13
 
4.0%
갈 13
 
4.0%
식 12
 
3.7%
비 12
 
3.7%
한 11
 
3.4%
정 11
 
3.4%
어 9
 
2.8%
지 8
 
2.5%
이 7
 
2.1%
Other values (95) 212
65.0%
Common
ValueCountFrequency (%)
, 14
51.9%
13
48.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 326
92.4%
ASCII 27
 
7.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
탕 18
 
5.5%
장 13
 
4.0%
갈 13
 
4.0%
식 12
 
3.7%
비 12
 
3.7%
한 11
 
3.4%
정 11
 
3.4%
어 9
 
2.8%
지 8
 
2.5%
이 7
 
2.1%
Other values (95) 212
65.0%
ASCII
ValueCountFrequency (%)
, 14
51.9%
13
48.1%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size868.0 B
Minimum2023-03-20 00:00:00
Maximum2023-03-20 00:00:00
2023-12-12T23:40:30.881585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:40:30.968435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

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

Correlations

2023-12-12T23:40:31.053995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업소명소재지(도로명)업태주메뉴
연번1.0001.0001.0000.0000.758
업소명1.0001.0001.0000.9001.000
소재지(도로명)1.0001.0001.0001.0001.000
업태0.0000.9001.0001.0000.932
주메뉴0.7581.0001.0000.9321.000
2023-12-12T23:40:31.216182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업태
연번1.0000.000
업태0.0001.000

Missing values

2023-12-12T23:40:27.889765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:40:28.022032image/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(주)베이징코야서울특별시 종로구 율곡로2길 29-1, 지하1층 (수송동)중식북경오리구이2023-03-20
12(주)석파랑서울특별시 종로구 자하문로 309, 1층 (홍지동)한식한정식2023-03-20
23(주)토속촌삼계탕서울특별시 종로구 자하문로5길 5, 지상1층 (체부동, (체부동 86-1,2,3))한식삼계탕2023-03-20
34감촌서울특별시 종로구 종로 19, 5층 511호 일부, 512호 (종로1가)한식순두부2023-03-20
45고창선운사풍천장어금정서울특별시 종로구 대학로2길 38 (종로5가)한식장어구이2023-03-20
56궁나라냉면.묵밥서울특별시 종로구 지봉로12길 6, 1층 (숭인동)한식냉면,묵밥2023-03-20
67금해 복집서울특별시 종로구 진흥로 461, 1,2층 (구기동)일식활지리2023-03-20
78김가네대청마루서울특별시 종로구 인사동4길 17 (경운동)한식돼지갈비2023-03-20
89끄티집서울특별시 종로구 삼일대로19길 20, 1~4층 (관철동)한식전골, 샤브샤브2023-03-20
910나무향기서울특별시 종로구 세종대로23길 47, 1층 108호 (당주동)한식오리통삼겹 장작구이2023-03-20
연번업소명소재지(도로명)업태주메뉴기준일자
8283하누소서울특별시 종로구 삼일대로 428 (낙원동)한식갈비탕2023-03-20
8384한라의 집서울특별시 종로구 새문안로9길 29-1 (당주동)일식갈치회2023-03-20
8485한옥서울특별시 종로구 통일로14길 24 (무악동,1층)한식갈비탕2023-03-20
8586한일옥서울특별시 종로구 수표로 94 (관수동, 지하1층~지상1층)한식갈비탕2023-03-20
8687할머니두부집서울특별시 종로구 진흥로 439 (구기동)한식두부전골2023-03-20
8788함흥곰보냉면서울특별시 종로구 창경궁로 109, 401,405호 (인의동)한식냉면2023-03-20
8889향가서울특별시 종로구 계동길 19-6 (재동)한식시골밥상2023-03-20
8990향나무세구루서울특별시 종로구 삼청로 100 (삼청동)한식삼겹살2023-03-20
9091허서방네서울특별시 종로구 종로 332 (창신동)한식된장찌개2023-03-20
9192화동옥서울특별시 종로구 창덕궁1길 40 (계동)한식설렁탕2023-03-20