Overview

Dataset statistics

Number of variables9
Number of observations50
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.7 KiB
Average record size in memory76.6 B

Variable types

Categorical6
Numeric2
Text1

Alerts

OVSEA_OTA_NM has constant value ""Constant
CRNCY_CD has constant value ""Constant
COUNTRY_NM has constant value ""Constant
RSTRNT_NM is highly overall correlated with OTA_GOODS_ID and 2 other fieldsHigh correlation
RSTRNT_ADDR is highly overall correlated with OTA_GOODS_ID and 2 other fieldsHigh correlation
OTA_GOODS_ID is highly overall correlated with RSTRNT_NM and 2 other fieldsHigh correlation
CTY_NM is highly overall correlated with OTA_GOODS_ID and 2 other fieldsHigh correlation
OTA_GOODS_ID has unique valuesUnique
OTA_GOODS_NM has unique valuesUnique

Reproduction

Analysis started2023-12-10 09:39:21.824016
Analysis finished2023-12-10 09:39:23.622311
Duration1.8 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

OVSEA_OTA_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
KKDAY
50 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKKDAY
2nd rowKKDAY
3rd rowKKDAY
4th rowKKDAY
5th rowKKDAY

Common Values

ValueCountFrequency (%)
KKDAY 50
100.0%

Length

2023-12-10T18:39:23.727198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:23.864377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kkday 50
100.0%

OTA_GOODS_ID
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107229.2
Minimum100464
Maximum111751
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-10T18:39:24.035654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum100464
5-th percentile101745
Q1104541.5
median106195.5
Q3111400.75
95-th percentile111622.55
Maximum111751
Range11287
Interquartile range (IQR)6859.25

Descriptive statistics

Standard deviation3384.4223
Coefficient of variation (CV)0.031562506
Kurtosis-1.1330515
Mean107229.2
Median Absolute Deviation (MAD)1830.5
Skewness0.042923101
Sum5361460
Variance11454314
MonotonicityStrictly increasing
2023-12-10T18:39:24.290822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100464 1
 
2.0%
111402 1
 
2.0%
106931 1
 
2.0%
106932 1
 
2.0%
107457 1
 
2.0%
107459 1
 
2.0%
107460 1
 
2.0%
110025 1
 
2.0%
111395 1
 
2.0%
111399 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
100464 1
2.0%
101345 1
2.0%
101439 1
2.0%
102119 1
2.0%
102547 1
2.0%
103722 1
2.0%
104082 1
2.0%
104195 1
2.0%
104535 1
2.0%
104537 1
2.0%
ValueCountFrequency (%)
111751 1
2.0%
111750 1
2.0%
111623 1
2.0%
111622 1
2.0%
111493 1
2.0%
111492 1
2.0%
111491 1
2.0%
111489 1
2.0%
111487 1
2.0%
111483 1
2.0%

OTA_GOODS_NM
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-10T18:39:24.712441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length17
Mean length12.22
Min length4

Characters and Unicode

Total characters611
Distinct characters149
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

Unique50 ?
Unique (%)100.0%

Sample

1st row닭한마리(기본)
2nd row깨비갈비살(180g/1인)
3rd row[신사점]엘쁠라또세트(2인)
4th row깐쇼새우+쟁반짜장2
5th row스페셜세트(450g)
ValueCountFrequency (%)
3
 
4.3%
1인 2
 
2.9%
양연모듬 2
 
2.9%
bset 2
 
2.9%
a 2
 
2.9%
2인set 2
 
2.9%
프리미엄 2
 
2.9%
aset 2
 
2.9%
3인set 2
 
2.9%
1주문메뉴 2
 
2.9%
Other values (47) 48
69.6%
2023-12-10T18:39:25.531275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 37
 
6.1%
) 37
 
6.1%
인 22
 
3.6%
세 21
 
3.4%
트 21
 
3.4%
19
 
3.1%
+ 18
 
2.9%
1 17
 
2.8%
2 12
 
2.0%
리 10
 
1.6%
Other values (139) 397
65.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 377
61.7%
Decimal Number 56
 
9.2%
Lowercase Letter 40
 
6.5%
Open Punctuation 38
 
6.2%
Close Punctuation 38
 
6.2%
Space Separator 19
 
3.1%
Math Symbol 18
 
2.9%
Uppercase Letter 14
 
2.3%
Other Punctuation 11
 
1.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 22
 
5.8%
세 21
 
5.6%
트 21
 
5.6%
리 10
 
2.7%
스 10
 
2.7%
게 9
 
2.4%
한 9
 
2.4%
우 8
 
2.1%
이 8
 
2.1%
장 8
 
2.1%
Other values (114) 251
66.6%
Decimal Number
ValueCountFrequency (%)
1 17
30.4%
2 12
21.4%
0 9
16.1%
5 8
14.3%
4 5
 
8.9%
3 4
 
7.1%
8 1
 
1.8%
Lowercase Letter
ValueCountFrequency (%)
s 9
22.5%
g 9
22.5%
t 9
22.5%
e 9
22.5%
o 2
 
5.0%
r 2
 
5.0%
Uppercase Letter
ValueCountFrequency (%)
M 5
35.7%
A 4
28.6%
B 4
28.6%
L 1
 
7.1%
Open Punctuation
ValueCountFrequency (%)
( 37
97.4%
[ 1
 
2.6%
Close Punctuation
ValueCountFrequency (%)
) 37
97.4%
] 1
 
2.6%
Other Punctuation
ValueCountFrequency (%)
/ 8
72.7%
: 3
 
27.3%
Space Separator
ValueCountFrequency (%)
19
100.0%
Math Symbol
ValueCountFrequency (%)
+ 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 377
61.7%
Common 180
29.5%
Latin 54
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 22
 
5.8%
세 21
 
5.6%
트 21
 
5.6%
리 10
 
2.7%
스 10
 
2.7%
게 9
 
2.4%
한 9
 
2.4%
우 8
 
2.1%
이 8
 
2.1%
장 8
 
2.1%
Other values (114) 251
66.6%
Common
ValueCountFrequency (%)
( 37
20.6%
) 37
20.6%
19
10.6%
+ 18
10.0%
1 17
9.4%
2 12
 
6.7%
0 9
 
5.0%
5 8
 
4.4%
/ 8
 
4.4%
4 5
 
2.8%
Other values (5) 10
 
5.6%
Latin
ValueCountFrequency (%)
s 9
16.7%
g 9
16.7%
t 9
16.7%
e 9
16.7%
M 5
9.3%
A 4
7.4%
B 4
7.4%
o 2
 
3.7%
r 2
 
3.7%
L 1
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 377
61.7%
ASCII 234
38.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 37
15.8%
) 37
15.8%
19
 
8.1%
+ 18
 
7.7%
1 17
 
7.3%
2 12
 
5.1%
s 9
 
3.8%
g 9
 
3.8%
t 9
 
3.8%
e 9
 
3.8%
Other values (15) 58
24.8%
Hangul
ValueCountFrequency (%)
인 22
 
5.8%
세 21
 
5.6%
트 21
 
5.6%
리 10
 
2.7%
스 10
 
2.7%
게 9
 
2.4%
한 9
 
2.4%
우 8
 
2.1%
이 8
 
2.1%
장 8
 
2.1%
Other values (114) 251
66.6%

OTA_GOODS_PRC
Real number (ℝ)

Distinct31
Distinct (%)62.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean44.98
Minimum9
Maximum130
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-10T18:39:26.185513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile16.35
Q130
median39.5
Q356
95-th percentile86.65
Maximum130
Range121
Interquartile range (IQR)26

Descriptive statistics

Standard deviation24.186765
Coefficient of variation (CV)0.53772265
Kurtosis2.5434427
Mean44.98
Median Absolute Deviation (MAD)11.5
Skewness1.375402
Sum2249
Variance584.99959
MonotonicityNot monotonic
2023-12-10T18:39:26.479956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
37 5
 
10.0%
30 5
 
10.0%
56 5
 
10.0%
20 3
 
6.0%
45 3
 
6.0%
42 2
 
4.0%
49 2
 
4.0%
28 2
 
4.0%
39 1
 
2.0%
40 1
 
2.0%
Other values (21) 21
42.0%
ValueCountFrequency (%)
9 1
 
2.0%
11 1
 
2.0%
15 1
 
2.0%
18 1
 
2.0%
20 3
6.0%
24 1
 
2.0%
26 1
 
2.0%
28 2
 
4.0%
30 5
10.0%
32 1
 
2.0%
ValueCountFrequency (%)
130 1
 
2.0%
109 1
 
2.0%
88 1
 
2.0%
85 1
 
2.0%
80 1
 
2.0%
79 1
 
2.0%
70 1
 
2.0%
68 1
 
2.0%
64 1
 
2.0%
56 5
10.0%

CRNCY_CD
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
KRW
50 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKRW
2nd rowKRW
3rd rowKRW
4th rowKRW
5th rowKRW

Common Values

ValueCountFrequency (%)
KRW 50
100.0%

Length

2023-12-10T18:39:26.813413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:27.016719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
krw 50
100.0%

RSTRNT_NM
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
홍대칼국수와족발(서면점)
6 
순미네행복게장(동대문점)
6 
폴인(홍대점/삼청점/명동점/강남점)
6 
양연화로
5 
파쿠모리(홍대점)
5 
Other values (13)
22 

Length

Max length19
Median length9
Mean length9.48
Min length3

Unique

Unique9 ?
Unique (%)18.0%

Sample

1st row오복닭한마리(을지로본점)
2nd row도깨비불고기
3rd row엘쁠라또(신사점)
4th row명동관
5th row갈비선생

Common Values

ValueCountFrequency (%)
홍대칼국수와족발(서면점) 6
12.0%
순미네행복게장(동대문점) 6
12.0%
폴인(홍대점/삼청점/명동점/강남점) 6
12.0%
양연화로 5
10.0%
파쿠모리(홍대점) 5
10.0%
신화게판(서면점) 4
8.0%
갈비선생 4
8.0%
명동한우촌 3
 
6.0%
크랩회피쉬 2
 
4.0%
황금닭한마리 1
 
2.0%
Other values (8) 8
16.0%

Length

2023-12-10T18:39:27.322418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
홍대칼국수와족발(서면점 6
12.0%
폴인(홍대점/삼청점/명동점/강남점 6
12.0%
순미네행복게장(동대문점 6
12.0%
양연화로 5
10.0%
파쿠모리(홍대점 5
10.0%
신화게판(서면점 4
8.0%
갈비선생 4
8.0%
명동한우촌 3
 
6.0%
크랩회피쉬 2
 
4.0%
삼대나주곰탕 1
 
2.0%
Other values (8) 8
16.0%

RSTRNT_ADDR
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)38.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
부산광역시 부산광역시진구 동천로132번길 12-5
6 
서울특별시 중구 을지로43길 38
6 
서울특별시 마포구 어울마당로 132-1
5 
서울특별시 종로구 삼일대로17길 18
5 
부산광역시 부산광역시진구 가야대로784번길 46-8
4 
Other values (14)
24 

Length

Max length28
Median length23
Mean length21
Min length15

Unique

Unique9 ?
Unique (%)18.0%

Sample

1st row서울특별시 중구 을지로27길 32-3
2nd row서울특별시 중구 을지로 43길 38
3rd row서울특별시 강남구 도산대로17길 11
4th row서울특별시 중구 명동10길 7-9, 2층
5th row서울특별시 중구 명동10길 19-27

Common Values

ValueCountFrequency (%)
부산광역시 부산광역시진구 동천로132번길 12-5 6
12.0%
서울특별시 중구 을지로43길 38 6
12.0%
서울특별시 마포구 어울마당로 132-1 5
10.0%
서울특별시 종로구 삼일대로17길 18 5
10.0%
부산광역시 부산광역시진구 가야대로784번길 46-8 4
8.0%
서울특별시 중구 명동10길 19-27 4
8.0%
서울특별시 강남구 봉은사로6길 29 3
 
6.0%
서울특별시 중구 퇴계로 127, 2층 3
 
6.0%
서울특별시 중구 퇴계로 60 3
 
6.0%
서울특별시 중구 동호로24길 27-4 2
 
4.0%
Other values (9) 9
18.0%

Length

2023-12-10T18:39:27.641817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 40
19.4%
중구 23
 
11.2%
부산광역시 10
 
4.9%
부산광역시진구 10
 
4.9%
12-5 7
 
3.4%
종로구 7
 
3.4%
38 7
 
3.4%
어울마당로 6
 
2.9%
퇴계로 6
 
2.9%
마포구 6
 
2.9%
Other values (32) 84
40.8%

COUNTRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
KOR
50 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKOR
2nd rowKOR
3rd rowKOR
4th rowKOR
5th rowKOR

Common Values

ValueCountFrequency (%)
KOR 50
100.0%

Length

2023-12-10T18:39:27.929895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:28.131757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kor 50
100.0%

CTY_NM
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
seoul
40 
busan
10 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowseoul
2nd rowseoul
3rd rowseoul
4th rowseoul
5th rowseoul

Common Values

ValueCountFrequency (%)
seoul 40
80.0%
busan 10
 
20.0%

Length

2023-12-10T18:39:28.446087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:28.684241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
seoul 40
80.0%
busan 10
 
20.0%

Interactions

2023-12-10T18:39:22.825214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:22.511693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:23.056278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:22.679291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:39:28.846549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
OTA_GOODS_IDOTA_GOODS_NMOTA_GOODS_PRCRSTRNT_NMRSTRNT_ADDRCTY_NM
OTA_GOODS_ID1.0001.0000.7510.9880.9990.653
OTA_GOODS_NM1.0001.0001.0001.0001.0001.000
OTA_GOODS_PRC0.7511.0001.0000.8080.7150.262
RSTRNT_NM0.9881.0000.8081.0001.0001.000
RSTRNT_ADDR0.9991.0000.7151.0001.0001.000
CTY_NM0.6531.0000.2621.0001.0001.000
2023-12-10T18:39:29.133843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
RSTRNT_NMRSTRNT_ADDRCTY_NM
RSTRNT_NM1.0000.9840.816
RSTRNT_ADDR0.9841.0000.804
CTY_NM0.8160.8041.000
2023-12-10T18:39:29.353076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
OTA_GOODS_IDOTA_GOODS_PRCRSTRNT_NMRSTRNT_ADDRCTY_NM
OTA_GOODS_ID1.0000.1540.8290.8140.613
OTA_GOODS_PRC0.1541.0000.3530.3160.235
RSTRNT_NM0.8290.3531.0000.9840.816
RSTRNT_ADDR0.8140.3160.9841.0000.804
CTY_NM0.6130.2350.8160.8041.000

Missing values

2023-12-10T18:39:23.278169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:39:23.520954image/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

OVSEA_OTA_NMOTA_GOODS_IDOTA_GOODS_NMOTA_GOODS_PRCCRNCY_CDRSTRNT_NMRSTRNT_ADDRCOUNTRY_NMCTY_NM
0KKDAY100464닭한마리(기본)20KRW오복닭한마리(을지로본점)서울특별시 중구 을지로27길 32-3KORseoul
1KKDAY101345깨비갈비살(180g/1인)18KRW도깨비불고기서울특별시 중구 을지로 43길 38KORseoul
2KKDAY101439[신사점]엘쁠라또세트(2인)79KRW엘쁠라또(신사점)서울특별시 강남구 도산대로17길 11KORseoul
3KKDAY102119깐쇼새우+쟁반짜장230KRW명동관서울특별시 중구 명동10길 7-9, 2층KORseoul
4KKDAY102547스페셜세트(450g)109KRW갈비선생서울특별시 중구 명동10길 19-27KORseoul
5KKDAY103722닭갈비(1인분/150g)9KRW우리닭갈비서울특별시 마포구 어울마당로 136-5KORseoul
6KKDAY104082황금닭한마리(2인분) : 닭한마리+감자사리+떡사리20KRW황금닭한마리서울특별시 중구 퇴계로58길 33KORseoul
7KKDAY104195일품샤브샤브정식(최상급한우1+)49KRW일품당프리미엄서울특별시 종로구 새문안로5가길 7, 3층KORseoul
8KKDAY1045352인set A20KRW파쿠모리(홍대점)서울특별시 마포구 어울마당로 132-1KORseoul
9KKDAY1045372인set B24KRW파쿠모리(홍대점)서울특별시 마포구 어울마당로 132-1KORseoul
OVSEA_OTA_NMOTA_GOODS_IDOTA_GOODS_NMOTA_GOODS_PRCCRNCY_CDRSTRNT_NMRSTRNT_ADDRCOUNTRY_NMCTY_NM
40KKDAY111483홍칼족발(M)30KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
41KKDAY111487허니마늘족발(M)33KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
42KKDAY111489불족발(M)30KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
43KKDAY111491냉채족발(M)35KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
44KKDAY111492홍칼보쌈(M)30KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
45KKDAY111493족발+보쌈(L)40KRW홍대칼국수와족발(서면점)부산광역시 부산광역시진구 동천로132번길 12-5KORbusan
46KKDAY111622세트1(간장게장+양념게장+새우장+된장찌개+공기밥)39KRW신화게판(서면점)부산광역시 부산광역시진구 가야대로784번길 46-8KORbusan
47KKDAY111623세트2(꽃게(소)+피자+주먹밥+쿨피스)42KRW신화게판(서면점)부산광역시 부산광역시진구 가야대로784번길 46-8KORbusan
48KKDAY111750세트2(새우찜(소)+피자+주먹밥+쿨피스)42KRW신화게판(서면점)부산광역시 부산광역시진구 가야대로784번길 46-8KORbusan
49KKDAY111751세트3(꽃게(소)+꽃게탕+주먹밥+쿨피스)64KRW신화게판(서면점)부산광역시 부산광역시진구 가야대로784번길 46-8KORbusan