Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells475
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory576.2 KiB
Average record size in memory59.0 B

Variable types

Numeric3
Text2
DateTime1

Dataset

Description메뉴정보(식당ID, 메뉴명, 가격 등 6개 항목)
Author전라남도
URLhttps://www.data.go.kr/data/15076624/fileData.do

Alerts

메뉴태그정보 has 475 (4.8%) missing valuesMissing
메뉴ID has unique valuesUnique
메뉴가격 has 336 (3.4%) zerosZeros

Reproduction

Analysis started2023-12-12 17:26:32.261108
Analysis finished2023-12-12 17:26:33.939051
Duration1.68 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

메뉴ID
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean157268.18
Minimum2
Maximum533245
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T02:26:34.000942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3809.95
Q120152
median105713.5
Q3212352.5
95-th percentile362909.2
Maximum533245
Range533243
Interquartile range (IQR)192200.5

Descriptive statistics

Standard deviation130547.67
Coefficient of variation (CV)0.83009585
Kurtosis-1.0800363
Mean157268.18
Median Absolute Deviation (MAD)96569.5
Skewness0.47778276
Sum1.5726818 × 109
Variance1.7042693 × 1010
MonotonicityNot monotonic
2023-12-13T02:26:34.122123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
151915 1
 
< 0.1%
407343 1
 
< 0.1%
209829 1
 
< 0.1%
16585 1
 
< 0.1%
14934 1
 
< 0.1%
92329 1
 
< 0.1%
345902 1
 
< 0.1%
15284 1
 
< 0.1%
5696 1
 
< 0.1%
77034 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
4 1
< 0.1%
13 1
< 0.1%
15 1
< 0.1%
25 1
< 0.1%
29 1
< 0.1%
31 1
< 0.1%
36 1
< 0.1%
38 1
< 0.1%
40 1
< 0.1%
ValueCountFrequency (%)
533245 1
< 0.1%
533224 1
< 0.1%
533222 1
< 0.1%
533213 1
< 0.1%
533212 1
< 0.1%
533211 1
< 0.1%
533205 1
< 0.1%
533204 1
< 0.1%
533201 1
< 0.1%
533196 1
< 0.1%

식당ID
Real number (ℝ)

Distinct2781
Distinct (%)27.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean757881.94
Minimum2858
Maximum865302
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T02:26:34.233596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2858
5-th percentile225755
Q1857752.75
median858754
Q3859704
95-th percentile864430
Maximum865302
Range862444
Interquartile range (IQR)1951.25

Descriptive statistics

Standard deviation214564.13
Coefficient of variation (CV)0.28311023
Kurtosis2.7704708
Mean757881.94
Median Absolute Deviation (MAD)983
Skewness-2.0091265
Sum7.5788194 × 109
Variance4.6037768 × 1010
MonotonicityNot monotonic
2023-12-13T02:26:34.352475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
534154 31
 
0.3%
156723 20
 
0.2%
859582 19
 
0.2%
862343 18
 
0.2%
858234 18
 
0.2%
859848 18
 
0.2%
859854 17
 
0.2%
858893 17
 
0.2%
229979 17
 
0.2%
859473 17
 
0.2%
Other values (2771) 9808
98.1%
ValueCountFrequency (%)
2858 4
 
< 0.1%
3820 14
0.1%
4419 7
0.1%
4751 2
 
< 0.1%
5075 3
 
< 0.1%
6215 4
 
< 0.1%
10302 1
 
< 0.1%
12433 6
0.1%
16676 2
 
< 0.1%
17264 10
0.1%
ValueCountFrequency (%)
865302 2
 
< 0.1%
865300 1
 
< 0.1%
865299 5
0.1%
865297 3
< 0.1%
865295 1
 
< 0.1%
865288 1
 
< 0.1%
865287 1
 
< 0.1%
865282 3
< 0.1%
865268 3
< 0.1%
865266 2
 
< 0.1%

메뉴명
Text

Distinct5598
Distinct (%)56.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T02:26:34.607210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length31
Mean length6.1766
Min length1

Characters and Unicode

Total characters61766
Distinct characters732
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4652 ?
Unique (%)46.5%

Sample

1st row도다리
2nd row새우탕
3rd row유린기(대)
4th row치킨토마토리조또(L)
5th row4인
ValueCountFrequency (%)
소주 350
 
3.5%
맥주 297
 
3.0%
음료수 249
 
2.5%
공기밥 160
 
1.6%
복분자 127
 
1.3%
막걸리 122
 
1.2%
누룽지 80
 
0.8%
김치찌개 54
 
0.5%
공기 53
 
0.5%
냉면 51
 
0.5%
Other values (5586) 8474
84.6%
2023-12-13T02:26:35.008755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 4100
 
6.6%
) 4098
 
6.6%
인 1319
 
2.1%
탕 1240
 
2.0%
리 1064
 
1.7%
1 1049
 
1.7%
0 992
 
1.6%
이 987
 
1.6%
소 976
 
1.6%
주 959
 
1.6%
Other values (722) 44982
72.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 46941
76.0%
Open Punctuation 4100
 
6.6%
Close Punctuation 4098
 
6.6%
Decimal Number 3750
 
6.1%
Lowercase Letter 1060
 
1.7%
Other Punctuation 899
 
1.5%
Uppercase Letter 546
 
0.9%
Math Symbol 279
 
0.5%
Connector Punctuation 71
 
0.1%
Space Separator 17
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 1319
 
2.8%
탕 1240
 
2.6%
리 1064
 
2.3%
이 987
 
2.1%
소 976
 
2.1%
주 959
 
2.0%
밥 929
 
2.0%
대 900
 
1.9%
기 862
 
1.8%
지 754
 
1.6%
Other values (653) 36951
78.7%
Uppercase Letter
ValueCountFrequency (%)
T 69
12.6%
E 68
12.5%
C 63
11.5%
O 61
11.2%
H 61
11.2%
I 53
9.7%
S 35
6.4%
P 26
 
4.8%
A 26
 
4.8%
L 22
 
4.0%
Other values (12) 62
11.4%
Lowercase Letter
ValueCountFrequency (%)
g 630
59.4%
k 58
 
5.5%
p 50
 
4.7%
l 47
 
4.4%
c 44
 
4.2%
e 36
 
3.4%
m 34
 
3.2%
s 32
 
3.0%
t 25
 
2.4%
i 18
 
1.7%
Other values (10) 86
 
8.1%
Decimal Number
ValueCountFrequency (%)
1 1049
28.0%
0 992
26.5%
2 778
20.7%
5 281
 
7.5%
3 266
 
7.1%
4 206
 
5.5%
8 82
 
2.2%
6 53
 
1.4%
7 30
 
0.8%
9 13
 
0.3%
Other Punctuation
ValueCountFrequency (%)
/ 757
84.2%
, 53
 
5.9%
. 43
 
4.8%
: 14
 
1.6%
& 13
 
1.4%
· 10
 
1.1%
% 5
 
0.6%
# 2
 
0.2%
* 1
 
0.1%
! 1
 
0.1%
Math Symbol
ValueCountFrequency (%)
+ 197
70.6%
~ 82
29.4%
Open Punctuation
ValueCountFrequency (%)
( 4100
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4098
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 71
100.0%
Space Separator
ValueCountFrequency (%)
17
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 46940
76.0%
Common 13219
 
21.4%
Latin 1606
 
2.6%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 1319
 
2.8%
탕 1240
 
2.6%
리 1064
 
2.3%
이 987
 
2.1%
소 976
 
2.1%
주 959
 
2.0%
밥 929
 
2.0%
대 900
 
1.9%
기 862
 
1.8%
지 754
 
1.6%
Other values (652) 36950
78.7%
Latin
ValueCountFrequency (%)
g 630
39.2%
T 69
 
4.3%
E 68
 
4.2%
C 63
 
3.9%
O 61
 
3.8%
H 61
 
3.8%
k 58
 
3.6%
I 53
 
3.3%
p 50
 
3.1%
l 47
 
2.9%
Other values (32) 446
27.8%
Common
ValueCountFrequency (%)
( 4100
31.0%
) 4098
31.0%
1 1049
 
7.9%
0 992
 
7.5%
2 778
 
5.9%
/ 757
 
5.7%
5 281
 
2.1%
3 266
 
2.0%
4 206
 
1.6%
+ 197
 
1.5%
Other values (17) 495
 
3.7%
Han
ValueCountFrequency (%)
牛 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 46940
76.0%
ASCII 14815
 
24.0%
None 10
 
< 0.1%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 4100
27.7%
) 4098
27.7%
1 1049
 
7.1%
0 992
 
6.7%
2 778
 
5.3%
/ 757
 
5.1%
g 630
 
4.3%
5 281
 
1.9%
3 266
 
1.8%
4 206
 
1.4%
Other values (58) 1658
11.2%
Hangul
ValueCountFrequency (%)
인 1319
 
2.8%
탕 1240
 
2.6%
리 1064
 
2.3%
이 987
 
2.1%
소 976
 
2.1%
주 959
 
2.0%
밥 929
 
2.0%
대 900
 
1.9%
기 862
 
1.8%
지 754
 
1.6%
Other values (652) 36950
78.7%
None
ValueCountFrequency (%)
· 10
100.0%
CJK
ValueCountFrequency (%)
牛 1
100.0%

메뉴가격
Real number (ℝ)

ZEROS 

Distinct186
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20862.077
Minimum0
Maximum480000
Zeros336
Zeros (%)3.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T02:26:35.152067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1000
Q14000
median10000
Q330000
95-th percentile65025
Maximum480000
Range480000
Interquartile range (IQR)26000

Descriptive statistics

Standard deviation28054.343
Coefficient of variation (CV)1.3447531
Kurtosis22.807942
Mean20862.077
Median Absolute Deviation (MAD)7000
Skewness3.6010387
Sum2.0862077 × 108
Variance7.8704619 × 108
MonotonicityNot monotonic
2023-12-13T02:26:35.288323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4000 912
 
9.1%
8000 659
 
6.6%
10000 537
 
5.4%
7000 467
 
4.7%
2000 441
 
4.4%
12000 400
 
4.0%
1000 397
 
4.0%
30000 396
 
4.0%
5000 345
 
3.5%
0 336
 
3.4%
Other values (176) 5110
51.1%
ValueCountFrequency (%)
0 336
3.4%
40 1
 
< 0.1%
500 10
 
0.1%
600 1
 
< 0.1%
800 1
 
< 0.1%
1000 397
4.0%
1300 1
 
< 0.1%
1500 64
 
0.6%
1700 2
 
< 0.1%
1800 3
 
< 0.1%
ValueCountFrequency (%)
480000 1
 
< 0.1%
350000 1
 
< 0.1%
300000 2
 
< 0.1%
260000 1
 
< 0.1%
250000 5
 
0.1%
240000 1
 
< 0.1%
210000 1
 
< 0.1%
200000 24
0.2%
190000 1
 
< 0.1%
180000 23
0.2%

메뉴태그정보
Text

MISSING 

Distinct3050
Distinct (%)32.0%
Missing475
Missing (%)4.8%
Memory size156.2 KiB
2023-12-13T02:26:35.495632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length72
Median length54
Mean length21.666877
Min length7

Characters and Unicode

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

Unique

Unique1898 ?
Unique (%)19.9%

Sample

1st row주재료 : 도다리
2nd row주재료 : 새우,해산물
3rd row주재료 : 닭고기,야채 / 조리법 : 튀김 / 소스 : 간장,식초
4th row주재료 : 토마토 / 조리법 : 치킨,리소토
5th row주재료 : 소고기 / 조리법 : 전골 / 소스 : 매운
ValueCountFrequency (%)
26437
42.4%
주재료 8988
 
14.4%
조리법 5055
 
8.1%
소스 2801
 
4.5%
옵션 1137
 
1.8%
탕 819
 
1.3%
술 759
 
1.2%
볶음 464
 
0.7%
매운 437
 
0.7%
술,소주 383
 
0.6%
Other values (2238) 15119
24.2%
2023-12-13T02:26:35.938441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
52874
25.6%
: 17981
 
8.7%
, 11243
 
5.4%
주 9901
 
4.8%
료 9326
 
4.5%
재 9020
 
4.4%
/ 8456
 
4.1%
리 5836
 
2.8%
조 5193
 
2.5%
법 5055
 
2.4%
Other values (441) 71492
34.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 115817
56.1%
Space Separator 52874
25.6%
Other Punctuation 37680
 
18.3%
Lowercase Letter 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 9901
 
8.5%
료 9326
 
8.1%
재 9020
 
7.8%
리 5836
 
5.0%
조 5193
 
4.5%
법 5055
 
4.4%
소 4211
 
3.6%
고 3789
 
3.3%
기 3285
 
2.8%
스 3208
 
2.8%
Other values (435) 56993
49.2%
Other Punctuation
ValueCountFrequency (%)
: 17981
47.7%
, 11243
29.8%
/ 8456
22.4%
Lowercase Letter
ValueCountFrequency (%)
a 3
50.0%
l 3
50.0%
Space Separator
ValueCountFrequency (%)
52874
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 115817
56.1%
Common 90554
43.9%
Latin 6
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 9901
 
8.5%
료 9326
 
8.1%
재 9020
 
7.8%
리 5836
 
5.0%
조 5193
 
4.5%
법 5055
 
4.4%
소 4211
 
3.6%
고 3789
 
3.3%
기 3285
 
2.8%
스 3208
 
2.8%
Other values (435) 56993
49.2%
Common
ValueCountFrequency (%)
52874
58.4%
: 17981
 
19.9%
, 11243
 
12.4%
/ 8456
 
9.3%
Latin
ValueCountFrequency (%)
a 3
50.0%
l 3
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 115817
56.1%
ASCII 90560
43.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
52874
58.4%
: 17981
 
19.9%
, 11243
 
12.4%
/ 8456
 
9.3%
a 3
 
< 0.1%
l 3
 
< 0.1%
Hangul
ValueCountFrequency (%)
주 9901
 
8.5%
료 9326
 
8.1%
재 9020
 
7.8%
리 5836
 
5.0%
조 5193
 
4.5%
법 5055
 
4.4%
소 4211
 
3.6%
고 3789
 
3.3%
기 3285
 
2.8%
스 3208
 
2.8%
Other values (435) 56993
49.2%

등록일시
Date

Distinct899
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-10-23 15:59:17
Maximum2021-01-20 17:08:42
2023-12-13T02:26:36.088694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:36.285232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T02:26:33.535279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.063118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.287157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.614325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.133162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.365816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.703512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.212586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:26:33.445380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:26:36.389660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴ID식당ID메뉴가격
메뉴ID1.0000.1830.060
식당ID0.1831.0000.025
메뉴가격0.0600.0251.000
2023-12-13T02:26:36.474431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴ID식당ID메뉴가격
메뉴ID1.0000.245-0.019
식당ID0.2451.000-0.027
메뉴가격-0.019-0.0271.000

Missing values

2023-12-13T02:26:33.802409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:26:33.897171image/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메뉴명메뉴가격메뉴태그정보등록일시
38712151915857659도다리200000주재료 : 도다리2020-11-24 12:05:12
36146105344790799새우탕14000주재료 : 새우,해산물2020-11-11 11:48:33
2589380498534154유린기(대)45000주재료 : 닭고기,야채 / 조리법 : 튀김 / 소스 : 간장,식초2020-11-03 17:29:48
1867820638857987치킨토마토리조또(L)22000주재료 : 토마토 / 조리법 : 치킨,리소토2020-10-29 12:21:58
57625341137839444인41000<NA>2020-12-07 18:52:06
35469104667346651전골(대)29000주재료 : 소고기 / 조리법 : 전골 / 소스 : 매운2020-11-11 11:48:27
39590153374859495보해복분자10000주재료 : 술,복분자2020-11-24 12:05:48
77688457421578라면(1인)3000주재료 : 면 / 조리법 : 라면2020-10-27 15:38:56
39873153657858612(특)회덮밥13000조리법 : 덮밥2020-11-24 12:05:56
1183613213861971활복찜(중)80000주재료 : 복어,생선 / 조리법 : 찜2020-10-27 16:46:14
메뉴ID식당ID메뉴명메뉴가격메뉴태그정보등록일시
961310967653537막걸리3000주재료 : 막걸리 / 소스 : 술2020-10-27 16:35:02
1086112222858687오리전골(소)30000주재료 : 소고기,오리고기 / 조리법 : 전골 / 소스 : 매운2020-10-27 16:42:56
38778151981857768새조개샤브샤브(2인/소)120000주재료 : 해산물,면,조개 / 조리법 : 칼국수,샤브샤브 / 소스 : 육수2020-11-24 12:05:12
1064712008858708맥주4000주재료 : 맥주 / 소스 : 술2020-10-27 16:41:55
12991312857982삼겹살(180g)12000주재료 : 삼겹살,돼지고기 / 조리법 : 구이2020-10-26 13:32:37
1821620175858574새꼬시(대)65000주재료 : 세꼬시2020-10-29 12:21:46
2506279659858854냉면(5월~8월)4000주재료 : 면 / 조리법 : 냉면 / 소스 : 차가운 / 옵션 : 메밀2020-11-03 17:22:02
19491963858642생오리(대)50000주재료 : 오리2020-10-26 13:33:29
247427884395026고창복분자14000주재료 : 술,복분자2020-11-02 11:50:15
41421198846862825도다리(자연산/3인)100000주재료 : 도다리 / 옵션 : 자연산2020-11-26 09:28:07