Overview

Dataset statistics

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

Variable types

Categorical6

Dataset

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

Alerts

DE has constant value ""Constant
HRLY_TIME has constant value ""Constant
Dataset has 19 (19.0%) duplicate rowsDuplicates
DLVR_STORE_SIGNGU_NM is highly overall correlated with DLVR_STORE_BRTC_NMHigh correlation
DLVR_STORE_BRTC_NM is highly overall correlated with DLVR_STORE_SIGNGU_NMHigh correlation

Reproduction

Analysis started2023-12-10 06:23:17.601472
Analysis finished2023-12-10 06:23:18.272899
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

DE
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2019-08-01
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-08-01
2nd row2019-08-01
3rd row2019-08-01
4th row2019-08-01
5th row2019-08-01

Common Values

ValueCountFrequency (%)
2019-08-01 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:23:18.576920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-08-01 100
100.0%

HRLY_TIME
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:23:18.904745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

DLVR_STORE_INDUTY_NM
Categorical

Distinct14
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
치킨
46 
야식
10 
족발/보쌈
9 
분식
6 
회
5 
Other values (9)
24 

Length

Max length6
Median length2
Mean length2.71
Min length1

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st row치킨
2nd row치킨
3rd row분식
4th row족발/보쌈
5th row치킨

Common Values

ValueCountFrequency (%)
치킨 46
46.0%
야식 10
 
10.0%
족발/보쌈 9
 
9.0%
분식 6
 
6.0%
회 5
 
5.0%
패스트푸드 5
 
5.0%
한식 4
 
4.0%
돈까스/일식 4
 
4.0%
배달전문업체 3
 
3.0%
피자 3
 
3.0%
Other values (4) 5
 
5.0%

Length

2023-12-10T15:23:19.079163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
치킨 46
46.0%
야식 10
 
10.0%
족발/보쌈 9
 
9.0%
분식 6
 
6.0%
회 5
 
5.0%
패스트푸드 5
 
5.0%
한식 4
 
4.0%
돈까스/일식 4
 
4.0%
배달전문업체 3
 
3.0%
피자 3
 
3.0%
Other values (4) 5
 
5.0%

DLVR_STORE_BRTC_NM
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
경기도
57 
서울특별시
26 
전라남도
6 
전라북도
 
3
제주특별자치도
 
2
Other values (4)
6 

Length

Max length7
Median length3
Mean length3.76
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row전라남도

Common Values

ValueCountFrequency (%)
경기도 57
57.0%
서울특별시 26
26.0%
전라남도 6
 
6.0%
전라북도 3
 
3.0%
제주특별자치도 2
 
2.0%
경상남도 2
 
2.0%
충청북도 2
 
2.0%
대전광역시 1
 
1.0%
충청남도 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T15:23:19.512425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 57
57.0%
서울특별시 26
26.0%
전라남도 6
 
6.0%
전라북도 3
 
3.0%
제주특별자치도 2
 
2.0%
경상남도 2
 
2.0%
충청북도 2
 
2.0%
대전광역시 1
 
1.0%
충청남도 1
 
1.0%

DLVR_STORE_SIGNGU_NM
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
의정부시
32 
고양시 일산동구
13 
영등포구
9 
구로구
9 
광명시
8 
Other values (12)
29 

Length

Max length8
Median length7
Mean length4.24
Min length2

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st row고양시 일산서구
2nd row의정부시
3rd row고양시 일산동구
4th row의정부시
5th row순천시

Common Values

ValueCountFrequency (%)
의정부시 32
32.0%
고양시 일산동구 13
13.0%
영등포구 9
 
9.0%
구로구 9
 
9.0%
광명시 8
 
8.0%
순천시 6
 
6.0%
은평구 6
 
6.0%
시흥시 3
 
3.0%
전주시 완산구 3
 
3.0%
제천시 2
 
2.0%
Other values (7) 9
 
9.0%

Length

2023-12-10T15:23:19.707681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
의정부시 32
27.4%
고양시 14
12.0%
일산동구 13
11.1%
영등포구 9
 
7.7%
구로구 9
 
7.7%
광명시 8
 
6.8%
순천시 6
 
5.1%
은평구 6
 
5.1%
완산구 3
 
2.6%
전주시 3
 
2.6%
Other values (9) 14
12.0%

SETLE_KND_VALUE
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2
56 
1
32 
3
12 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3
2nd row1
3rd row1
4th row2
5th row2

Common Values

ValueCountFrequency (%)
2 56
56.0%
1 32
32.0%
3 12
 
12.0%

Length

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

Common Values (Plot)

2023-12-10T15:23:20.160255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 56
56.0%
1 32
32.0%
3 12
 
12.0%

Correlations

2023-12-10T15:23:20.283268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DLVR_STORE_INDUTY_NMDLVR_STORE_BRTC_NMDLVR_STORE_SIGNGU_NMSETLE_KND_VALUE
DLVR_STORE_INDUTY_NM1.0000.4870.3500.080
DLVR_STORE_BRTC_NM0.4871.0001.0000.408
DLVR_STORE_SIGNGU_NM0.3501.0001.0000.397
SETLE_KND_VALUE0.0800.4080.3971.000
2023-12-10T15:23:20.522444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DLVR_STORE_SIGNGU_NMDLVR_STORE_BRTC_NMSETLE_KND_VALUEDLVR_STORE_INDUTY_NM
DLVR_STORE_SIGNGU_NM1.0000.9550.2130.117
DLVR_STORE_BRTC_NM0.9551.0000.1890.220
SETLE_KND_VALUE0.2130.1891.0000.019
DLVR_STORE_INDUTY_NM0.1170.2200.0191.000
2023-12-10T15:23:20.741001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DLVR_STORE_INDUTY_NMDLVR_STORE_BRTC_NMDLVR_STORE_SIGNGU_NMSETLE_KND_VALUE
DLVR_STORE_INDUTY_NM1.0000.2200.1170.019
DLVR_STORE_BRTC_NM0.2201.0000.9550.189
DLVR_STORE_SIGNGU_NM0.1170.9551.0000.213
SETLE_KND_VALUE0.0190.1890.2131.000

Missing values

2023-12-10T15:23:17.976609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:23:18.195896image/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_STORE_BRTC_NMDLVR_STORE_SIGNGU_NMSETLE_KND_VALUE
02019-08-010치킨경기도고양시 일산서구3
12019-08-010치킨경기도의정부시1
22019-08-010분식경기도고양시 일산동구1
32019-08-010족발/보쌈경기도의정부시2
42019-08-010치킨전라남도순천시2
52019-08-010족발/보쌈서울특별시은평구3
62019-08-010야식경기도의정부시2
72019-08-010야식서울특별시구로구2
82019-08-010족발/보쌈경기도고양시 일산동구1
92019-08-010치킨경기도고양시 일산동구2
DEHRLY_TIMEDLVR_STORE_INDUTY_NMDLVR_STORE_BRTC_NMDLVR_STORE_SIGNGU_NMSETLE_KND_VALUE
902019-08-010분식경기도고양시 일산동구1
912019-08-010심부름경기도의정부시2
922019-08-010야식경기도시흥시1
932019-08-010치킨서울특별시구로구2
942019-08-010심부름경기도의정부시1
952019-08-010한식경기도의정부시2
962019-08-010야식서울특별시구로구2
972019-08-010치킨서울특별시마포구1
982019-08-010피자제주특별자치도서귀포시3
992019-08-010치킨경기도의정부시1

Duplicate rows

Most frequently occurring

DEHRLY_TIMEDLVR_STORE_INDUTY_NMDLVR_STORE_BRTC_NMDLVR_STORE_SIGNGU_NMSETLE_KND_VALUE# duplicates
62019-08-010치킨경기도고양시 일산동구25
102019-08-010치킨경기도의정부시15
112019-08-010치킨경기도의정부시25
122019-08-010치킨서울특별시영등포구15
32019-08-010야식서울특별시구로구24
182019-08-010회경기도의정부시24
132019-08-010치킨서울특별시영등포구23
02019-08-010배달전문업체경기도의정부시22
12019-08-010분식경기도고양시 일산동구12
22019-08-010야식경기도의정부시22