Overview

Dataset statistics

Number of variables6
Number of observations167
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.4 KiB
Average record size in memory51.8 B

Variable types

Categorical1
DateTime2
Numeric3

Dataset

Description그랜드코리아레저 당사 방문예약 시스템을 통해 카지노 투어를 신청한 고객의 월별 시간대별 평균 고객 수에 대한 데이터로 영업장, 년월, 시간대별 예약건주 등의 항목을 제공합니다.
Author그랜드코리아레저(주)
URLhttps://www.data.go.kr/data/15064874/fileData.do

Alerts

예약업체수 is highly overall correlated with 총예약고객수High correlation
총예약고객수 is highly overall correlated with 예약업체수High correlation

Reproduction

Analysis started2024-03-14 21:02:15.622981
Analysis finished2024-03-14 21:02:18.369064
Duration2.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

영업장
Categorical

Distinct2
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
강남 코엑스점
84 
강북 힐튼점
83 

Length

Max length7
Median length7
Mean length6.502994
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강남 코엑스점
2nd row강남 코엑스점
3rd row강남 코엑스점
4th row강남 코엑스점
5th row강남 코엑스점

Common Values

ValueCountFrequency (%)
강남 코엑스점 84
50.3%
강북 힐튼점 83
49.7%

Length

2024-03-15T06:02:18.605677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T06:02:18.803451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강남 84
25.1%
코엑스점 84
25.1%
강북 83
24.9%
힐튼점 83
24.9%

년월
Date

Distinct11
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2019-05-01 00:00:00
Maximum2020-03-01 00:00:00
2024-03-15T06:02:18.963839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:19.255361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)

시간대
Date

Distinct9
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2024-03-15 09:00:00
Maximum2024-03-15 17:00:00
2024-03-15T06:02:19.422251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:19.770375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

예약업체수
Real number (ℝ)

HIGH CORRELATION 

Distinct60
Distinct (%)35.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.341317
Minimum1
Maximum65
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-03-15T06:02:20.336808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q114
median26
Q344
95-th percentile56.7
Maximum65
Range64
Interquartile range (IQR)30

Descriptive statistics

Standard deviation17.218571
Coefficient of variation (CV)0.60754307
Kurtosis-1.1372267
Mean28.341317
Median Absolute Deviation (MAD)14
Skewness0.23502262
Sum4733
Variance296.47919
MonotonicityNot monotonic
2024-03-15T06:02:20.848610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
51 7
 
4.2%
15 7
 
4.2%
12 6
 
3.6%
36 6
 
3.6%
14 5
 
3.0%
20 5
 
3.0%
1 5
 
3.0%
22 5
 
3.0%
8 5
 
3.0%
17 5
 
3.0%
Other values (50) 111
66.5%
ValueCountFrequency (%)
1 5
3.0%
2 3
1.8%
3 2
 
1.2%
4 1
 
0.6%
5 1
 
0.6%
6 2
 
1.2%
7 3
1.8%
8 5
3.0%
9 2
 
1.2%
10 4
2.4%
ValueCountFrequency (%)
65 1
 
0.6%
61 1
 
0.6%
60 2
 
1.2%
58 2
 
1.2%
57 3
1.8%
56 2
 
1.2%
55 2
 
1.2%
54 4
2.4%
52 1
 
0.6%
51 7
4.2%

총예약고객수
Real number (ℝ)

HIGH CORRELATION 

Distinct161
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1657.3353
Minimum67
Maximum29000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-03-15T06:02:21.533329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum67
5-th percentile229.8
Q1569.5
median1000
Q31804.5
95-th percentile2637.4
Maximum29000
Range28933
Interquartile range (IQR)1235

Descriptive statistics

Standard deviation3360.5499
Coefficient of variation (CV)2.0276825
Kurtosis47.630983
Mean1657.3353
Median Absolute Deviation (MAD)594
Skewness6.6439716
Sum276775
Variance11293295
MonotonicityNot monotonic
2024-03-15T06:02:22.036196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15000 2
 
1.2%
709 2
 
1.2%
352 2
 
1.2%
612 2
 
1.2%
1849 2
 
1.2%
256 2
 
1.2%
618 1
 
0.6%
975 1
 
0.6%
1552 1
 
0.6%
1673 1
 
0.6%
Other values (151) 151
90.4%
ValueCountFrequency (%)
67 1
0.6%
85 1
0.6%
105 1
0.6%
121 1
0.6%
126 1
0.6%
161 1
0.6%
191 1
0.6%
192 1
0.6%
225 1
0.6%
241 1
0.6%
ValueCountFrequency (%)
29000 1
0.6%
27000 1
0.6%
15000 2
1.2%
3427 1
0.6%
3036 1
0.6%
2895 1
0.6%
2689 1
0.6%
2638 1
0.6%
2636 1
0.6%
2519 1
0.6%

예약 평균고객수
Real number (ℝ)

Distinct20
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66.179641
Minimum22
Maximum1000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-03-15T06:02:22.474056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22
5-th percentile26
Q130
median32
Q334
95-th percentile40
Maximum1000
Range978
Interquartile range (IQR)4

Descriptive statistics

Standard deviation174.40102
Coefficient of variation (CV)2.6352669
Kurtosis24.173899
Mean66.179641
Median Absolute Deviation (MAD)2
Skewness5.0573859
Sum11052
Variance30415.715
MonotonicityNot monotonic
2024-03-15T06:02:22.891087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
34 28
16.8%
32 24
14.4%
31 20
12.0%
33 19
11.4%
30 17
10.2%
35 10
 
6.0%
28 8
 
4.8%
29 7
 
4.2%
36 6
 
3.6%
27 5
 
3.0%
Other values (10) 23
13.8%
ValueCountFrequency (%)
22 1
 
0.6%
24 2
 
1.2%
25 2
 
1.2%
26 5
 
3.0%
27 5
 
3.0%
28 8
 
4.8%
29 7
 
4.2%
30 17
10.2%
31 20
12.0%
32 24
14.4%
ValueCountFrequency (%)
1000 5
 
3.0%
759 1
 
0.6%
202 1
 
0.6%
40 4
 
2.4%
39 1
 
0.6%
37 1
 
0.6%
36 6
 
3.6%
35 10
 
6.0%
34 28
16.8%
33 19
11.4%

Interactions

2024-03-15T06:02:17.293590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:15.879276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:16.762823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:17.492222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:16.185273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:16.983627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:17.748306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:16.463043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:02:17.141576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T06:02:23.056197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업장년월시간대예약업체수총예약고객수예약 평균고객수
영업장1.0000.0000.0000.3780.0000.000
년월0.0001.0000.0000.4090.8740.754
시간대0.0000.0001.0000.5620.2900.242
예약업체수0.3780.4090.5621.0000.2970.421
총예약고객수0.0000.8740.2900.2971.0000.971
예약 평균고객수0.0000.7540.2420.4210.9711.000
2024-03-15T06:02:23.342853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예약업체수총예약고객수예약 평균고객수영업장
예약업체수1.0000.7800.0990.282
총예약고객수0.7801.0000.4340.000
예약 평균고객수0.0990.4341.0000.000
영업장0.2820.0000.0001.000

Missing values

2024-03-15T06:02:18.063729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T06:02:18.295352image/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

영업장년월시간대예약업체수총예약고객수예약 평균고객수
0강남 코엑스점2019-0509:0033122233
1강남 코엑스점2019-0510:002062030
2강남 코엑스점2019-0511:001755731
3강남 코엑스점2019-0512:002585532
4강남 코엑스점2019-0513:0030116431
5강남 코엑스점2019-0514:0036164535
6강남 코엑스점2019-0515:0036157134
7강남 코엑스점2019-0516:0036154333
8강남 코엑스점2019-0517:0034140733
9강남 코엑스점2019-0609:0042162730
영업장년월시간대예약업체수총예약고객수예약 평균고객수
157강북 힐튼점2020-0110:00216140
158강북 힐튼점2020-0111:00212140
159강북 힐튼점2020-0112:00627334
160강북 힐튼점2020-0113:00825626
161강북 힐튼점2020-0114:001036731
162강북 힐튼점2020-0115:002792432
163강북 힐튼점2020-0116:002276535
164강북 힐튼점2020-0117:001761232
165강북 힐튼점2020-0209:001290001000
166강북 힐튼점2020-0309:001150001000