Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.0 KiB
Average record size in memory51.3 B

Variable types

DateTime1
Numeric2
Categorical3

Dataset

DescriptionSample
Author경기대학교 빅데이터센터
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KGUDSTNORDER

Alerts

DLVR_DSTN_BRTC_NM is highly overall correlated with HRLY_TIME and 1 other fieldsHigh correlation
DLVR_DSTN_SIGNGU_NM is highly overall correlated with HRLY_TIME and 1 other fieldsHigh correlation
HRLY_TIME is highly overall correlated with DLVR_DSTN_BRTC_NM and 1 other fieldsHigh correlation
DLVR_DSTN_BRTC_NM is highly imbalanced (89.8%)Imbalance
DLVR_DSTN_SIGNGU_NM is highly imbalanced (89.8%)Imbalance
HRLY_TIME has 4 (4.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:44:44.461929
Analysis finished2023-12-10 06:44:45.470650
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

DE
Date

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-05-01 00:00:00
Maximum2019-05-02 00:00:00
2023-12-10T15:44:45.524031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:45.671315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=2)

HRLY_TIME
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.6
Minimum0
Maximum23
Zeros4
Zeros (%)4.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:44:45.821168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q112
median15
Q318
95-th percentile21.05
Maximum23
Range23
Interquartile range (IQR)6

Descriptive statistics

Standard deviation5.0171423
Coefficient of variation (CV)0.34363989
Kurtosis2.0653957
Mean14.6
Median Absolute Deviation (MAD)3
Skewness-1.2071823
Sum1460
Variance25.171717
MonotonicityNot monotonic
2023-12-10T15:44:45.972641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
14 11
11.0%
15 11
11.0%
12 10
10.0%
18 10
10.0%
17 9
9.0%
13 7
 
7.0%
19 6
 
6.0%
11 6
 
6.0%
16 6
 
6.0%
21 4
 
4.0%
Other values (7) 20
20.0%
ValueCountFrequency (%)
0 4
 
4.0%
1 2
 
2.0%
3 1
 
1.0%
10 4
 
4.0%
11 6
6.0%
12 10
10.0%
13 7
7.0%
14 11
11.0%
15 11
11.0%
16 6
6.0%
ValueCountFrequency (%)
23 2
 
2.0%
22 3
 
3.0%
21 4
 
4.0%
20 4
 
4.0%
19 6
6.0%
18 10
10.0%
17 9
9.0%
16 6
6.0%
15 11
11.0%
14 11
11.0%

DLVR_STORE_INDUTY_NM
Categorical

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
패스트푸드
21 
족발/보쌈
18 
한식
18 
치킨
15 
돈까스/일식
10 
Other values (4)
18 

Length

Max length6
Median length5
Mean length3.93
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row족발/보쌈
2nd row치킨
3rd row치킨
4th row패스트푸드
5th row한식

Common Values

ValueCountFrequency (%)
패스트푸드 21
21.0%
족발/보쌈 18
18.0%
한식 18
18.0%
치킨 15
15.0%
돈까스/일식 10
10.0%
카페/디저트 9
9.0%
분식 6
 
6.0%
찜탕 2
 
2.0%
피자 1
 
1.0%

Length

2023-12-10T15:44:46.159661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:46.349670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
패스트푸드 21
21.0%
족발/보쌈 18
18.0%
한식 18
18.0%
치킨 15
15.0%
돈까스/일식 10
10.0%
카페/디저트 9
9.0%
분식 6
 
6.0%
찜탕 2
 
2.0%
피자 1
 
1.0%

DLVR_DSTN_BRTC_NM
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
충청북도
98 
경상남도
 
1
경상북도
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row충청북도
2nd row충청북도
3rd row충청북도
4th row충청북도
5th row충청북도

Common Values

ValueCountFrequency (%)
충청북도 98
98.0%
경상남도 1
 
1.0%
경상북도 1
 
1.0%

Length

2023-12-10T15:44:46.537730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:46.676850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 98
98.0%
경상남도 1
 
1.0%
경상북도 1
 
1.0%

DLVR_DSTN_SIGNGU_NM
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제천시
98 
김해시
 
1
문경시
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row제천시
2nd row제천시
3rd row제천시
4th row제천시
5th row제천시

Common Values

ValueCountFrequency (%)
제천시 98
98.0%
김해시 1
 
1.0%
문경시 1
 
1.0%

Length

2023-12-10T15:44:46.817892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:44:46.972549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제천시 98
98.0%
김해시 1
 
1.0%
문경시 1
 
1.0%

OREDER_CASCNT
Real number (ℝ)

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.8
Minimum1
Maximum14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:44:47.066376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q34
95-th percentile7
Maximum14
Range13
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.4037009
Coefficient of variation (CV)0.85846459
Kurtosis3.9125928
Mean2.8
Median Absolute Deviation (MAD)1
Skewness1.7411071
Sum280
Variance5.7777778
MonotonicityNot monotonic
2023-12-10T15:44:47.205485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
1 44
44.0%
2 19
19.0%
6 9
 
9.0%
3 8
 
8.0%
4 7
 
7.0%
5 5
 
5.0%
7 5
 
5.0%
9 2
 
2.0%
14 1
 
1.0%
ValueCountFrequency (%)
1 44
44.0%
2 19
19.0%
3 8
 
8.0%
4 7
 
7.0%
5 5
 
5.0%
6 9
 
9.0%
7 5
 
5.0%
9 2
 
2.0%
14 1
 
1.0%
ValueCountFrequency (%)
14 1
 
1.0%
9 2
 
2.0%
7 5
 
5.0%
6 9
 
9.0%
5 5
 
5.0%
4 7
 
7.0%
3 8
 
8.0%
2 19
19.0%
1 44
44.0%

Interactions

2023-12-10T15:44:44.987254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:44.784251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:45.086318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:44:44.877239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:44:47.339715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DEHRLY_TIMEDLVR_STORE_INDUTY_NMDLVR_DSTN_BRTC_NMDLVR_DSTN_SIGNGU_NMOREDER_CASCNT
DE1.0000.3770.0000.0410.0410.000
HRLY_TIME0.3771.0000.1780.7770.7770.311
DLVR_STORE_INDUTY_NM0.0000.1781.0000.0000.0000.000
DLVR_DSTN_BRTC_NM0.0410.7770.0001.0001.0000.000
DLVR_DSTN_SIGNGU_NM0.0410.7770.0001.0001.0000.000
OREDER_CASCNT0.0000.3110.0000.0000.0001.000
2023-12-10T15:44:47.534895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DLVR_STORE_INDUTY_NMDLVR_DSTN_BRTC_NMDLVR_DSTN_SIGNGU_NM
DLVR_STORE_INDUTY_NM1.0000.0000.000
DLVR_DSTN_BRTC_NM0.0001.0001.000
DLVR_DSTN_SIGNGU_NM0.0001.0001.000
2023-12-10T15:44:47.668112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
HRLY_TIMEOREDER_CASCNTDLVR_STORE_INDUTY_NMDLVR_DSTN_BRTC_NMDLVR_DSTN_SIGNGU_NM
HRLY_TIME1.0000.1770.0820.6720.672
OREDER_CASCNT0.1771.0000.0000.0000.000
DLVR_STORE_INDUTY_NM0.0820.0001.0000.0000.000
DLVR_DSTN_BRTC_NM0.6720.0000.0001.0001.000
DLVR_DSTN_SIGNGU_NM0.6720.0000.0001.0001.000

Missing values

2023-12-10T15:44:45.245991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:44:45.405798image/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

DEHRLY_TIMEDLVR_STORE_INDUTY_NMDLVR_DSTN_BRTC_NMDLVR_DSTN_SIGNGU_NMOREDER_CASCNT
02019-05-010족발/보쌈충청북도제천시2
12019-05-010치킨충청북도제천시5
22019-05-011치킨충청북도제천시6
32019-05-0110패스트푸드충청북도제천시1
42019-05-0110한식충청북도제천시4
52019-05-0111돈까스/일식충청북도제천시4
62019-05-0111카페/디저트충청북도제천시1
72019-05-0111패스트푸드충청북도제천시7
82019-05-0112돈까스/일식충청북도제천시1
92019-05-0112분식충청북도제천시1
DEHRLY_TIMEDLVR_STORE_INDUTY_NMDLVR_DSTN_BRTC_NMDLVR_DSTN_SIGNGU_NMOREDER_CASCNT
902019-05-0216족발/보쌈충청북도제천시2
912019-05-0216패스트푸드충청북도제천시2
922019-05-0217족발/보쌈충청북도제천시1
932019-05-0217카페/디저트충청북도제천시1
942019-05-0217패스트푸드충청북도제천시2
952019-05-0217한식충청북도제천시1
962019-05-0218족발/보쌈충청북도제천시5
972019-05-0218치킨충청북도제천시4
982019-05-0218패스트푸드충청북도제천시3
992019-05-0218한식충청북도제천시7