Overview

Dataset statistics

Number of variables5
Number of observations8087
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory331.8 KiB
Average record size in memory42.0 B

Variable types

Numeric2
Text2
Categorical1

Dataset

Description서울시내 위치한 식당에 대한 이미지정보를 적어놓은 데이터입니다.
Author서울관광재단
URLhttps://www.data.go.kr/data/15097007/fileData.do

Alerts

식당이미지(ID) is highly overall correlated with 식당(ID)High correlation
식당(ID) is highly overall correlated with 식당이미지(ID)High correlation
식당이미지(ID) has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:49:46.770731
Analysis finished2023-12-12 17:49:48.127875
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

식당이미지(ID)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct8087
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4044
Minimum1
Maximum8087
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size71.2 KiB
2023-12-13T02:49:48.231959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile405.3
Q12022.5
median4044
Q36065.5
95-th percentile7682.7
Maximum8087
Range8086
Interquartile range (IQR)4043

Descriptive statistics

Standard deviation2334.6601
Coefficient of variation (CV)0.57731458
Kurtosis-1.2
Mean4044
Median Absolute Deviation (MAD)2022
Skewness0
Sum32703828
Variance5450638
MonotonicityNot monotonic
2023-12-13T02:49:48.462325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 1
 
< 0.1%
5388 1
 
< 0.1%
5401 1
 
< 0.1%
5400 1
 
< 0.1%
5399 1
 
< 0.1%
5398 1
 
< 0.1%
5397 1
 
< 0.1%
5396 1
 
< 0.1%
5395 1
 
< 0.1%
5394 1
 
< 0.1%
Other values (8077) 8077
99.9%
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 (%)
8087 1
< 0.1%
8086 1
< 0.1%
8085 1
< 0.1%
8084 1
< 0.1%
8083 1
< 0.1%
8082 1
< 0.1%
8081 1
< 0.1%
8080 1
< 0.1%
8079 1
< 0.1%
8078 1
< 0.1%

식당(ID)
Real number (ℝ)

HIGH CORRELATION 

Distinct1370
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean368542.73
Minimum1439
Maximum968193
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size71.2 KiB
2023-12-13T02:49:48.651306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1439
5-th percentile11036.5
Q1108976
median333540
Q3593393
95-th percentile838914
Maximum968193
Range966754
Interquartile range (IQR)484417

Descriptive statistics

Standard deviation275845.4
Coefficient of variation (CV)0.74847602
Kurtosis-1.0841483
Mean368542.73
Median Absolute Deviation (MAD)233216
Skewness0.32790514
Sum2.9804051 × 109
Variance7.6090683 × 1010
MonotonicityNot monotonic
2023-12-13T02:49:48.846198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
22180 42
 
0.5%
33269 31
 
0.4%
164761 30
 
0.4%
245568 29
 
0.4%
392003 28
 
0.3%
11059 28
 
0.3%
771133 26
 
0.3%
308715 25
 
0.3%
85080 24
 
0.3%
361459 24
 
0.3%
Other values (1360) 7800
96.5%
ValueCountFrequency (%)
1439 10
0.1%
1440 7
0.1%
1576 2
 
< 0.1%
1578 12
0.1%
1580 11
0.1%
1581 5
0.1%
1583 5
0.1%
1725 5
0.1%
1912 4
 
< 0.1%
1916 8
0.1%
ValueCountFrequency (%)
968193 11
0.1%
966274 6
0.1%
951170 5
0.1%
951155 7
0.1%
950183 4
 
< 0.1%
947492 3
 
< 0.1%
942167 7
0.1%
941135 6
0.1%
938078 7
0.1%
936135 5
0.1%
Distinct1256
Distinct (%)15.5%
Missing0
Missing (%)0.0%
Memory size63.3 KiB
2023-12-13T02:49:49.159980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length18
Mean length7.7619636
Min length1

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)0.3%

Sample

1st row만족오향족발(관철점)
2nd row만족오향족발(관철점)
3rd row만족오향족발(관철점)
4th row만족오향족발(관철점)
5th row만족오향족발(관철점)
ValueCountFrequency (%)
카페 88
 
0.9%
명동파티파티 65
 
0.7%
52
 
0.5%
본점 47
 
0.5%
라온(명동1호점 42
 
0.4%
약천 38
 
0.4%
화떡 34
 
0.4%
곰국시집 34
 
0.4%
원조 34
 
0.4%
둘둘치킨(명동2호점 34
 
0.4%
Other values (1393) 9026
95.1%
2023-12-13T02:49:49.672313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3562
 
5.7%
( 3409
 
5.4%
) 3409
 
5.4%
2122
 
3.4%
1574
 
2.5%
1435
 
2.3%
1305
 
2.1%
1160
 
1.8%
954
 
1.5%
812
 
1.3%
Other values (647) 43029
68.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 53117
84.6%
Open Punctuation 3409
 
5.4%
Close Punctuation 3409
 
5.4%
Space Separator 1435
 
2.3%
Decimal Number 1020
 
1.6%
Other Punctuation 146
 
0.2%
Uppercase Letter 132
 
0.2%
Lowercase Letter 99
 
0.2%
Dash Punctuation 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3562
 
6.7%
2122
 
4.0%
1574
 
3.0%
1305
 
2.5%
1160
 
2.2%
954
 
1.8%
812
 
1.5%
739
 
1.4%
638
 
1.2%
595
 
1.1%
Other values (605) 39656
74.7%
Uppercase Letter
ValueCountFrequency (%)
D 21
15.9%
X 20
15.2%
L 15
11.4%
Y 15
11.4%
S 12
9.1%
W 10
7.6%
Z 10
7.6%
P 9
6.8%
H 6
 
4.5%
R 6
 
4.5%
Other values (2) 8
 
6.1%
Decimal Number
ValueCountFrequency (%)
1 273
26.8%
2 252
24.7%
3 105
 
10.3%
4 81
 
7.9%
0 79
 
7.7%
6 58
 
5.7%
7 51
 
5.0%
8 45
 
4.4%
9 42
 
4.1%
5 34
 
3.3%
Lowercase Letter
ValueCountFrequency (%)
o 18
18.2%
l 18
18.2%
e 12
12.1%
a 12
12.1%
d 10
10.1%
u 6
 
6.1%
t 6
 
6.1%
i 6
 
6.1%
r 6
 
6.1%
p 5
 
5.1%
Other Punctuation
ValueCountFrequency (%)
& 78
53.4%
. 22
 
15.1%
, 19
 
13.0%
% 16
 
11.0%
· 6
 
4.1%
: 5
 
3.4%
Open Punctuation
ValueCountFrequency (%)
( 3409
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3409
100.0%
Space Separator
ValueCountFrequency (%)
1435
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 53117
84.6%
Common 9423
 
15.0%
Latin 231
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3562
 
6.7%
2122
 
4.0%
1574
 
3.0%
1305
 
2.5%
1160
 
2.2%
954
 
1.8%
812
 
1.5%
739
 
1.4%
638
 
1.2%
595
 
1.1%
Other values (605) 39656
74.7%
Latin
ValueCountFrequency (%)
D 21
 
9.1%
X 20
 
8.7%
o 18
 
7.8%
l 18
 
7.8%
L 15
 
6.5%
Y 15
 
6.5%
S 12
 
5.2%
e 12
 
5.2%
a 12
 
5.2%
W 10
 
4.3%
Other values (12) 78
33.8%
Common
ValueCountFrequency (%)
( 3409
36.2%
) 3409
36.2%
1435
15.2%
1 273
 
2.9%
2 252
 
2.7%
3 105
 
1.1%
4 81
 
0.9%
0 79
 
0.8%
& 78
 
0.8%
6 58
 
0.6%
Other values (10) 244
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 53117
84.6%
ASCII 9648
 
15.4%
None 6
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
3562
 
6.7%
2122
 
4.0%
1574
 
3.0%
1305
 
2.5%
1160
 
2.2%
954
 
1.8%
812
 
1.5%
739
 
1.4%
638
 
1.2%
595
 
1.1%
Other values (605) 39656
74.7%
ASCII
ValueCountFrequency (%)
( 3409
35.3%
) 3409
35.3%
1435
14.9%
1 273
 
2.8%
2 252
 
2.6%
3 105
 
1.1%
4 81
 
0.8%
0 79
 
0.8%
& 78
 
0.8%
6 58
 
0.6%
Other values (31) 469
 
4.9%
None
ValueCountFrequency (%)
· 6
100.0%

지역명
Categorical

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size63.3 KiB
서울특별시 중구
4501 
서울특별시 종로구
1642 
서울특별시 용산구
1496 
서울특별시 강남구
 
308
서울특별시 서초구
 
50
Other values (5)
 
90

Length

Max length10
Median length8
Mean length8.4488686
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 종로구
2nd row서울특별시 종로구
3rd row서울특별시 종로구
4th row서울특별시 종로구
5th row서울특별시 종로구

Common Values

ValueCountFrequency (%)
서울특별시 중구 4501
55.7%
서울특별시 종로구 1642
 
20.3%
서울특별시 용산구 1496
 
18.5%
서울특별시 강남구 308
 
3.8%
서울특별시 서초구 50
 
0.6%
서울특별시 서대문구 42
 
0.5%
서울특별시 마포구 22
 
0.3%
서울특별시 송파구 22
 
0.3%
서울특별시 강서구 2
 
< 0.1%
서울특별시 동대문구 2
 
< 0.1%

Length

2023-12-13T02:49:49.882834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:49:50.066501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 8087
50.0%
중구 4501
27.8%
종로구 1642
 
10.2%
용산구 1496
 
9.2%
강남구 308
 
1.9%
서초구 50
 
0.3%
서대문구 42
 
0.3%
마포구 22
 
0.1%
송파구 22
 
0.1%
강서구 2
 
< 0.1%
Distinct7189
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size63.3 KiB
2023-12-13T02:49:50.506717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length96
Median length95
Mean length94.041177
Min length89

Characters and Unicode

Total characters760511
Distinct characters36
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6385 ?
Unique (%)79.0%

Sample

1st rowhttps://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_798545529.jpg
2nd rowhttps://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_242811985.jpg
3rd rowhttps://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1612196586.jpg
4th rowhttps://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_166987050.jpg
5th rowhttps://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1015053566.jpg
ValueCountFrequency (%)
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-09/restaurant/367159_1167572322.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-09/restaurant/367159_679668982.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-08/restaurant/367159_675087300.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-08/restaurant/367159_796535500.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-08/restaurant/367159_1820830716.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-08/restaurant/367159_1671621902.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-08/restaurant/367159_1009259783.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-09/restaurant/367159_128239274.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-09/restaurant/367159_2119015743.jpg 5
 
0.1%
https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-09/restaurant/367159_525147373.jpg 5
 
0.1%
Other values (7179) 8037
99.4%
2023-12-13T02:49:51.129742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
t 48522
 
6.4%
/ 48522
 
6.4%
2 44166
 
5.8%
o 40435
 
5.3%
c 40435
 
5.3%
0 33495
 
4.4%
a 32348
 
4.3%
. 32348
 
4.3%
u 32348
 
4.3%
s 32348
 
4.3%
Other values (26) 375544
49.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 420524
55.3%
Decimal Number 226769
29.8%
Other Punctuation 88957
 
11.7%
Connector Punctuation 16174
 
2.1%
Dash Punctuation 8087
 
1.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
t 48522
11.5%
o 40435
9.6%
c 40435
9.6%
a 32348
 
7.7%
u 32348
 
7.7%
s 32348
 
7.7%
n 24261
 
5.8%
d 24261
 
5.8%
r 24261
 
5.8%
p 24261
 
5.8%
Other values (11) 97044
23.1%
Decimal Number
ValueCountFrequency (%)
2 44166
19.5%
0 33495
14.8%
1 31142
13.7%
9 29405
13.0%
8 20695
9.1%
7 20416
9.0%
4 12311
 
5.4%
6 11913
 
5.3%
5 11892
 
5.2%
3 11334
 
5.0%
Other Punctuation
ValueCountFrequency (%)
/ 48522
54.5%
. 32348
36.4%
: 8087
 
9.1%
Connector Punctuation
ValueCountFrequency (%)
_ 16174
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8087
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 420524
55.3%
Common 339987
44.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 48522
11.5%
o 40435
9.6%
c 40435
9.6%
a 32348
 
7.7%
u 32348
 
7.7%
s 32348
 
7.7%
n 24261
 
5.8%
d 24261
 
5.8%
r 24261
 
5.8%
p 24261
 
5.8%
Other values (11) 97044
23.1%
Common
ValueCountFrequency (%)
/ 48522
14.3%
2 44166
13.0%
0 33495
9.9%
. 32348
9.5%
1 31142
9.2%
9 29405
8.6%
8 20695
6.1%
7 20416
 
6.0%
_ 16174
 
4.8%
4 12311
 
3.6%
Other values (5) 51313
15.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 760511
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 48522
 
6.4%
/ 48522
 
6.4%
2 44166
 
5.8%
o 40435
 
5.3%
c 40435
 
5.3%
0 33495
 
4.4%
a 32348
 
4.3%
. 32348
 
4.3%
u 32348
 
4.3%
s 32348
 
4.3%
Other values (26) 375544
49.4%

Interactions

2023-12-13T02:49:47.697815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:49:47.448464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:49:47.816934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:49:47.582179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:49:51.285118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
식당이미지(ID)식당(ID)지역명
식당이미지(ID)1.0000.9760.397
식당(ID)0.9761.0000.406
지역명0.3970.4061.000
2023-12-13T02:49:51.407765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
식당이미지(ID)식당(ID)지역명
식당이미지(ID)1.0001.0000.132
식당(ID)1.0001.0000.135
지역명0.1320.1351.000

Missing values

2023-12-13T02:49:47.943928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:49:48.071021image/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

식당이미지(ID)식당(ID)식당명지역명식당이미지(URL)
021439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_798545529.jpg
131439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_242811985.jpg
241439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1612196586.jpg
351439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_166987050.jpg
461439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1015053566.jpg
571439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_894465002.jpg
681439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_762738390.jpg
791439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_458844803.jpg
8101439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1487183779.jpg
911439만족오향족발(관철점)서울특별시 종로구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-10/restaurant/692182_1493790217.jpg
식당이미지(ID)식당(ID)식당명지역명식당이미지(URL)
80778078968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_795844693.jpg
80788079968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_676395352.jpg
80798080968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1765119384.jpg
80808081968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_769468873.jpg
80818082968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1923523887.jpg
80828083968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1720033453.jpg
80838084968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1182132106.jpg
80848085968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1223904019.jpg
80858086968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_184396058.jpg
80868087968193매일더맥주(명동점)서울특별시 중구https://ukcooyocdlvo8099722.cdn.ntruss.com/public_data/2021-07/restaurant/718468_1413429321.jpg