gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	680
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	93.8 KiB
Average record size in memory	141.2 B

Variable types

DateTime	1
Categorical	2
Numeric	13

Dataset

Description	그랜드코리아레저(주)에서 운영 중인 3개 영업점(강남코엑스점, 서울드래곤시티점(구 강북힐튼점), 부산롯데점)의 2017년~2023년 7월 고객구분에 따른 국적별 입장객 현황
Author	그랜드코리아레저(주)
URL	https://www.data.go.kr/data/15021219/fileData.do

Alerts

`일본` is highly overall correlated with `중국` and 6 other fields	High correlation
`중국` is highly overall correlated with `일본` and 8 other fields	High correlation
`홍콩` is highly overall correlated with `일본` and 3 other fields	High correlation
`대만` is highly overall correlated with `일본` and 6 other fields	High correlation
`동남아` is highly overall correlated with `일본` and 6 other fields	High correlation
`로컬` is highly overall correlated with `일본` and 5 other fields	High correlation
`러시아` is highly overall correlated with `일본` and 10 other fields	High correlation
`미국` is highly overall correlated with `베트남` and 4 other fields	High correlation
`베트남` is highly overall correlated with `러시아` and 5 other fields	High correlation
`태국` is highly overall correlated with `중국` and 6 other fields	High correlation
`몽골` is highly overall correlated with `중국` and 6 other fields	High correlation
`필리핀` is highly overall correlated with `러시아` and 5 other fields	High correlation
`기타` is highly overall correlated with `일본` and 11 other fields	High correlation
`방문고객구분` is highly overall correlated with `러시아` and 1 other fields	High correlation
`일본` has 80 (11.8%) zeros	Zeros
`중국` has 87 (12.8%) zeros	Zeros
`홍콩` has 212 (31.2%) zeros	Zeros
`대만` has 96 (14.1%) zeros	Zeros
`동남아` has 117 (17.2%) zeros	Zeros
`로컬` has 136 (20.0%) zeros	Zeros
`러시아` has 270 (39.7%) zeros	Zeros
`미국` has 315 (46.3%) zeros	Zeros
`베트남` has 333 (49.0%) zeros	Zeros
`태국` has 380 (55.9%) zeros	Zeros
`몽골` has 358 (52.6%) zeros	Zeros
`필리핀` has 410 (60.3%) zeros	Zeros
`기타` has 149 (21.9%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 15:03:36.654771
Analysis finished	2023-12-12 15:03:55.158805
Duration	18.5 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년월
Date

Distinct	77
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

Minimum	2017-01-31 00:00:00
Maximum	2023-07-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

영업장
Categorical

Distinct	4
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

부산롯데점	228
강남코엑스점	227
강북힐튼점	204
서울드래곤시티점	21

Length

Max length	8
Median length	5
Mean length	5.4264706
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
부산롯데점	228	33.5%
강남코엑스점	227	33.4%
강북힐튼점	204	30.0%
서울드래곤시티점	21	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
부산롯데점	228	33.5%
강남코엑스점	227	33.4%
강북힐튼점	204	30.0%
서울드래곤시티점	21	3.1%

방문고객구분
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

단체관광객	227
일반고객	227
VIP	226

Length

Max length	5
Median length	4
Mean length	4.0014706
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	VIP
2nd row	단체관광객
3rd row	일반고객
4th row	VIP
5th row	단체관광객

Common Values

Value	Count	Frequency (%)
단체관광객	227	33.4%
일반고객	227	33.4%
VIP	226	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
단체관광객	227	33.4%
일반고객	227	33.4%
vip	226	33.2%

일본
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	477
Distinct (%)	70.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1585.2809

Minimum	0
Maximum	12028
Zeros	80
Zeros (%)	11.8%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	33.75
median	813.5
Q3	1629.75
95-th percentile	7120.55
Maximum	12028
Range	12028
Interquartile range (IQR)	1596

Descriptive statistics

Standard deviation	2348.7111
Coefficient of variation (CV)	1.4815741
Kurtosis	3.4523567
Mean	1585.2809
Median Absolute Deviation (MAD)	784.5
Skewness	2.0098239
Sum	1077991
Variance	5516444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	11.8%
1	10	1.5%
2	8	1.2%
3	6	0.9%
34	6	0.9%
16	6	0.9%
14	5	0.7%
12	5	0.7%
25	5	0.7%
6	4	0.6%
Other values (467)	545	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	80	11.8%
1	10	1.5%
2	8	1.2%
3	6	0.9%
4	1	0.1%
5	1	0.1%
6	4	0.6%
7	2	0.3%
8	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
12028	1	0.1%
11439	1	0.1%
11208	1	0.1%
11093	1	0.1%
9927	1	0.1%
9872	1	0.1%
9736	1	0.1%
9722	1	0.1%
9678	1	0.1%
9330	1	0.1%

중국
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	538
Distinct (%)	79.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4397.8132

Minimum	0
Maximum	38757
Zeros	87
Zeros (%)	12.8%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	112
median	1434
Q3	4329.75
95-th percentile	22760.8
Maximum	38757
Range	38757
Interquartile range (IQR)	4217.75

Descriptive statistics

Standard deviation	7541.549
Coefficient of variation (CV)	1.7148407
Kurtosis	6.6205518
Mean	4397.8132
Median Absolute Deviation (MAD)	1395.5
Skewness	2.5814069
Sum	2990513
Variance	56874962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	87	12.8%
1	11	1.6%
5	4	0.6%
95	3	0.4%
157	3	0.4%
104	3	0.4%
22	3	0.4%
3	3	0.4%
8	2	0.3%
28	2	0.3%
Other values (528)	559	82.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	87	12.8%
1	11	1.6%
2	1	0.1%
3	3	0.4%
4	1	0.1%
5	4	0.6%
6	1	0.1%
7	1	0.1%
8	2	0.3%
9	2	0.3%

Value	Count	Frequency (%)
38757	1	0.1%
37343	1	0.1%
36824	1	0.1%
36105	1	0.1%
36011	1	0.1%
34942	1	0.1%
34912	1	0.1%
34559	1	0.1%
34504	1	0.1%
34071	1	0.1%

홍콩
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	232
Distinct (%)	34.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	105.97794

Minimum	0
Maximum	1901
Zeros	212
Zeros (%)	31.2%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	12
Q3	133.5
95-th percentile	448.45
Maximum	1901
Range	1901
Interquartile range (IQR)	133.5

Descriptive statistics

Standard deviation	219.51488
Coefficient of variation (CV)	2.0713262
Kurtosis	24.001924
Mean	105.97794
Median Absolute Deviation (MAD)	12
Skewness	4.2321009
Sum	72065
Variance	48186.784
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	212	31.2%
1	30	4.4%
4	20	2.9%
2	19	2.8%
6	12	1.8%
5	10	1.5%
3	8	1.2%
13	8	1.2%
12	7	1.0%
15	7	1.0%
Other values (222)	347	51.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	212	31.2%
1	30	4.4%
2	19	2.8%
3	8	1.2%
4	20	2.9%
5	10	1.5%
6	12	1.8%
7	4	0.6%
8	6	0.9%
9	7	1.0%

Value	Count	Frequency (%)
1901	1	0.1%
1842	1	0.1%
1691	1	0.1%
1612	1	0.1%
1433	1	0.1%
1272	1	0.1%
1209	1	0.1%
1096	1	0.1%
988	1	0.1%
983	1	0.1%

대만
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	385
Distinct (%)	56.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	274.91176

Minimum	0
Maximum	1901
Zeros	96
Zeros (%)	14.1%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.5
median	125
Q3	349.25
95-th percentile	1062.85
Maximum	1901
Range	1901
Interquartile range (IQR)	309.75

Descriptive statistics

Standard deviation	359.18043
Coefficient of variation (CV)	1.3065299
Kurtosis	3.7438713
Mean	274.91176
Median Absolute Deviation (MAD)	113
Skewness	1.9441445
Sum	186940
Variance	129010.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	96	14.1%
3	5	0.7%
104	5	0.7%
32	5	0.7%
94	4	0.6%
82	4	0.6%
27	4	0.6%
13	4	0.6%
69	4	0.6%
123	4	0.6%
Other values (375)	545	80.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	96	14.1%
1	4	0.6%
3	5	0.7%
5	1	0.1%
6	2	0.3%
7	1	0.1%
8	1	0.1%
10	1	0.1%
12	3	0.4%
13	4	0.6%

Value	Count	Frequency (%)
1901	1	0.1%
1864	1	0.1%
1823	1	0.1%
1815	1	0.1%
1802	1	0.1%
1795	1	0.1%
1668	1	0.1%
1482	1	0.1%
1442	1	0.1%
1417	1	0.1%

동남아
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	342
Distinct (%)	50.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	449.72059

Minimum	0
Maximum	5873
Zeros	117
Zeros (%)	17.2%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7.75
median	68
Q3	298.25
95-th percentile	2625.15
Maximum	5873
Range	5873
Interquartile range (IQR)	290.5

Descriptive statistics

Standard deviation	919.28515
Coefficient of variation (CV)	2.0441251
Kurtosis	7.6207011
Mean	449.72059
Median Absolute Deviation (MAD)	68
Skewness	2.7599499
Sum	305810
Variance	845085.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	117	17.2%
2	13	1.9%
11	11	1.6%
1	11	1.6%
3	11	1.6%
9	8	1.2%
8	7	1.0%
23	6	0.9%
35	6	0.9%
13	6	0.9%
Other values (332)	484	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	117	17.2%
1	11	1.6%
2	13	1.9%
3	11	1.6%
4	6	0.9%
5	5	0.7%
6	5	0.7%
7	2	0.3%
8	7	1.0%
9	8	1.2%

Value	Count	Frequency (%)
5873	1	0.1%
4995	1	0.1%
4554	1	0.1%
4429	1	0.1%
4411	1	0.1%
4339	1	0.1%
4301	1	0.1%
4230	1	0.1%
4187	1	0.1%
4162	1	0.1%

로컬
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	370
Distinct (%)	54.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	389.34559

Minimum	0
Maximum	4765
Zeros	136
Zeros (%)	20.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	152.5
Q3	506
95-th percentile	1745.35
Maximum	4765
Range	4765
Interquartile range (IQR)	504

Descriptive statistics

Standard deviation	614.81319
Coefficient of variation (CV)	1.5790938
Kurtosis	9.4823478
Mean	389.34559
Median Absolute Deviation (MAD)	152.5
Skewness	2.7316469
Sum	264755
Variance	377995.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	136	20.0%
2	19	2.8%
1	17	2.5%
4	13	1.9%
3	10	1.5%
13	8	1.2%
10	6	0.9%
5	6	0.9%
17	4	0.6%
9	4	0.6%
Other values (360)	457	67.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	136	20.0%
1	17	2.5%
2	19	2.8%
3	10	1.5%
4	13	1.9%
5	6	0.9%
6	2	0.3%
7	3	0.4%
8	4	0.6%
9	4	0.6%

Value	Count	Frequency (%)
4765	1	0.1%
3809	1	0.1%
3530	1	0.1%
3221	1	0.1%
3209	1	0.1%
3030	1	0.1%
2870	1	0.1%
2836	1	0.1%
2796	1	0.1%
2770	1	0.1%

러시아
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	203
Distinct (%)	29.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.155882

Minimum	0
Maximum	975
Zeros	270
Zeros (%)	39.7%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	99.25
95-th percentile	404.2
Maximum	975
Range	975
Interquartile range (IQR)	99.25

Descriptive statistics

Standard deviation	142.92792
Coefficient of variation (CV)	1.8767811
Kurtosis	7.2270919
Mean	76.155882
Median Absolute Deviation (MAD)	4
Skewness	2.5854139
Sum	51786
Variance	20428.391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	270	39.7%
1	39	5.7%
2	17	2.5%
3	10	1.5%
4	10	1.5%
5	10	1.5%
6	8	1.2%
12	7	1.0%
21	6	0.9%
8	5	0.7%
Other values (193)	298	43.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	270	39.7%
1	39	5.7%
2	17	2.5%
3	10	1.5%
4	10	1.5%
5	10	1.5%
6	8	1.2%
7	3	0.4%
8	5	0.7%
9	4	0.6%

Value	Count	Frequency (%)
975	1	0.1%
788	1	0.1%
723	1	0.1%
709	1	0.1%
687	1	0.1%
669	1	0.1%
659	1	0.1%
627	1	0.1%
626	1	0.1%
612	1	0.1%

미국
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	288
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	207.09265

Minimum	0
Maximum	2053
Zeros	315
Zeros (%)	46.3%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	298.25
95-th percentile	917.85
Maximum	2053
Range	2053
Interquartile range (IQR)	298.25

Descriptive statistics

Standard deviation	329.89175
Coefficient of variation (CV)	1.592967
Kurtosis	5.5779062
Mean	207.09265
Median Absolute Deviation (MAD)	4
Skewness	2.2056604
Sum	140823
Variance	108828.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	315	46.3%
1	12	1.8%
2	8	1.2%
3	5	0.7%
35	4	0.6%
33	3	0.4%
248	3	0.4%
230	3	0.4%
43	3	0.4%
197	3	0.4%
Other values (278)	321	47.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	315	46.3%
1	12	1.8%
2	8	1.2%
3	5	0.7%
5	1	0.1%
6	1	0.1%
7	1	0.1%
19	1	0.1%
22	1	0.1%
24	1	0.1%

Value	Count	Frequency (%)
2053	1	0.1%
1852	1	0.1%
1790	1	0.1%
1703	1	0.1%
1603	1	0.1%
1565	1	0.1%
1519	1	0.1%
1430	1	0.1%
1410	1	0.1%
1375	1	0.1%

베트남
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	222
Distinct (%)	32.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.65147

Minimum	0
Maximum	3187
Zeros	333
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	103
95-th percentile	1277.6
Maximum	3187
Range	3187
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	450.78801
Coefficient of variation (CV)	2.6109712
Kurtosis	14.441698
Mean	172.65147
Median Absolute Deviation (MAD)	2
Skewness	3.7029274
Sum	117403
Variance	203209.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	333	49.0%
12	7	1.0%
1	6	0.9%
70	6	0.9%
54	5	0.7%
111	4	0.6%
56	4	0.6%
23	4	0.6%
55	4	0.6%
205	4	0.6%
Other values (212)	303	44.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	333	49.0%
1	6	0.9%
2	4	0.6%
3	2	0.3%
4	2	0.3%
5	3	0.4%
7	1	0.1%
10	2	0.3%
11	2	0.3%
12	7	1.0%

Value	Count	Frequency (%)
3187	1	0.1%
2973	1	0.1%
2771	1	0.1%
2678	1	0.1%
2590	1	0.1%
2388	1	0.1%
2258	1	0.1%
2180	1	0.1%
2117	1	0.1%
2101	1	0.1%

태국
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	126
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.770588

Minimum	0
Maximum	835
Zeros	380
Zeros (%)	55.9%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	17
95-th percentile	191.15
Maximum	835
Range	835
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	94.149305
Coefficient of variation (CV)	2.7879084
Kurtosis	20.598227
Mean	33.770588
Median Absolute Deviation (MAD)	0
Skewness	4.2629707
Sum	22964
Variance	8864.0916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	380	55.9%
2	19	2.8%
7	13	1.9%
4	12	1.8%
1	11	1.6%
5	9	1.3%
9	9	1.3%
3	8	1.2%
6	8	1.2%
13	7	1.0%
Other values (116)	204	30.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	380	55.9%
1	11	1.6%
2	19	2.8%
3	8	1.2%
4	12	1.8%
5	9	1.3%
6	8	1.2%
7	13	1.9%
8	3	0.4%
9	9	1.3%

Value	Count	Frequency (%)
835	1	0.1%
632	1	0.1%
596	1	0.1%
560	1	0.1%
552	1	0.1%
509	1	0.1%
465	1	0.1%
447	1	0.1%
446	1	0.1%
445	1	0.1%

몽골
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	220
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203.46765

Minimum	0
Maximum	3441
Zeros	358
Zeros (%)	52.6%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	86.25
95-th percentile	1949.7
Maximum	3441
Range	3441
Interquartile range (IQR)	86.25

Descriptive statistics

Standard deviation	570.13242
Coefficient of variation (CV)	2.802079
Kurtosis	12.889142
Mean	203.46765
Median Absolute Deviation (MAD)	0
Skewness	3.669168
Sum	138358
Variance	325050.97
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	358	52.6%
1	11	1.6%
4	7	1.0%
3	7	1.0%
6	6	0.9%
9	5	0.7%
7	5	0.7%
5	4	0.6%
51	4	0.6%
56	4	0.6%
Other values (210)	269	39.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	358	52.6%
1	11	1.6%
2	2	0.3%
3	7	1.0%
4	7	1.0%
5	4	0.6%
6	6	0.9%
7	5	0.7%
8	2	0.3%
9	5	0.7%

Value	Count	Frequency (%)
3441	1	0.1%
3025	1	0.1%
3000	1	0.1%
2990	1	0.1%
2969	1	0.1%
2946	1	0.1%
2923	1	0.1%
2913	1	0.1%
2844	1	0.1%
2788	1	0.1%

필리핀
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	128
Distinct (%)	18.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.845588

Minimum	0
Maximum	2080
Zeros	410
Zeros (%)	60.3%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	8
95-th percentile	352.6
Maximum	2080
Range	2080
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	239.44606
Coefficient of variation (CV)	3.5820773
Kurtosis	28.852754
Mean	66.845588
Median Absolute Deviation (MAD)	0
Skewness	5.1202669
Sum	45455
Variance	57334.416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	410	60.3%
1	30	4.4%
2	27	4.0%
3	13	1.9%
5	11	1.6%
4	8	1.2%
60	6	0.9%
8	6	0.9%
43	4	0.6%
6	4	0.6%
Other values (118)	161	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	410	60.3%
1	30	4.4%
2	27	4.0%
3	13	1.9%
4	8	1.2%
5	11	1.6%
6	4	0.6%
7	3	0.4%
8	6	0.9%
9	2	0.3%

Value	Count	Frequency (%)
2080	1	0.1%
1941	1	0.1%
1840	1	0.1%
1504	1	0.1%
1496	1	0.1%
1421	1	0.1%
1420	1	0.1%
1281	1	0.1%
1271	1	0.1%
1259	1	0.1%

기타
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	356
Distinct (%)	52.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	694.15

Minimum	0
Maximum	6665
Zeros	149
Zeros (%)	21.9%
Negative	0
Negative (%)	0.0%
Memory size	6.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	61
Q3	806
95-th percentile	3796.6
Maximum	6665
Range	6665
Interquartile range (IQR)	804

Descriptive statistics

Standard deviation	1251.0502
Coefficient of variation (CV)	1.8022764
Kurtosis	4.8422012
Mean	694.15
Median Absolute Deviation (MAD)	61
Skewness	2.2909671
Sum	472022
Variance	1565126.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	149	21.9%
1	17	2.5%
2	16	2.4%
3	12	1.8%
8	9	1.3%
4	6	0.9%
29	6	0.9%
25	5	0.7%
12	5	0.7%
16	5	0.7%
Other values (346)	450	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	149	21.9%
1	17	2.5%
2	16	2.4%
3	12	1.8%
4	6	0.9%
5	4	0.6%
6	4	0.6%
7	1	0.1%
8	9	1.3%
9	1	0.1%

Value	Count	Frequency (%)
6665	1	0.1%
6163	1	0.1%
5892	1	0.1%
5673	1	0.1%
5542	1	0.1%
5502	1	0.1%
5464	1	0.1%
5452	1	0.1%
5380	1	0.1%
5226	1	0.1%

Heatmap
Table

	년월	영업장	방문고객구분	일본	중국	홍콩	대만	동남아	로컬	러시아	미국	베트남	태국	몽골	필리핀	기타
년월	1.000	0.139	0.000	0.472	0.000	0.347	0.295	0.000	0.000	0.000	0.000	0.336	0.152	0.255	0.338	0.000
영업장	0.139	1.000	0.000	0.246	0.495	0.221	0.268	0.282	0.424	0.238	0.412	0.213	0.170	0.340	0.230	0.320
방문고객구분	0.000	0.000	1.000	0.612	0.592	0.405	0.564	0.576	0.592	0.717	0.589	0.438	0.554	0.478	0.411	0.766
일본	0.472	0.246	0.612	1.000	0.768	0.713	0.771	0.803	0.434	0.789	0.630	0.789	0.649	0.734	0.830	0.745
중국	0.000	0.495	0.592	0.768	1.000	0.699	0.662	0.859	0.525	0.642	0.725	0.762	0.683	0.798	0.794	0.852
홍콩	0.347	0.221	0.405	0.713	0.699	1.000	0.812	0.714	0.742	0.617	0.700	0.611	0.588	0.575	0.642	0.764
대만	0.295	0.268	0.564	0.771	0.662	0.812	1.000	0.743	0.484	0.760	0.611	0.690	0.542	0.609	0.653	0.713
동남아	0.000	0.282	0.576	0.803	0.859	0.714	0.743	1.000	0.582	0.761	0.518	0.753	0.547	0.630	0.732	0.845
로컬	0.000	0.424	0.592	0.434	0.525	0.742	0.484	0.582	1.000	0.123	0.519	0.269	0.473	0.387	0.305	0.682
러시아	0.000	0.238	0.717	0.789	0.642	0.617	0.760	0.761	0.123	1.000	0.636	0.780	0.685	0.703	0.773	0.759
미국	0.000	0.412	0.589	0.630	0.725	0.700	0.611	0.518	0.519	0.636	1.000	0.803	0.732	0.840	0.824	0.780
베트남	0.336	0.213	0.438	0.789	0.762	0.611	0.690	0.753	0.269	0.780	0.803	1.000	0.819	0.884	0.952	0.731
태국	0.152	0.170	0.554	0.649	0.683	0.588	0.542	0.547	0.473	0.685	0.732	0.819	1.000	0.791	0.841	0.621
몽골	0.255	0.340	0.478	0.734	0.798	0.575	0.609	0.630	0.387	0.703	0.840	0.884	0.791	1.000	0.912	0.764
필리핀	0.338	0.230	0.411	0.830	0.794	0.642	0.653	0.732	0.305	0.773	0.824	0.952	0.841	0.912	1.000	0.755
기타	0.000	0.320	0.766	0.745	0.852	0.764	0.713	0.845	0.682	0.759	0.780	0.731	0.621	0.764	0.755	1.000

Heatmap
Table

	방문고객구분	영업장
방문고객구분	1.000	0.000
영업장	0.000	1.000

Heatmap
Table

	일본	중국	홍콩	대만	동남아	로컬	러시아	미국	베트남	태국	몽골	필리핀	기타	영업장	방문고객구분
일본	1.000	0.618	0.810	0.786	0.788	0.593	0.505	0.131	0.193	0.288	0.214	0.193	0.547	0.148	0.454
중국	0.618	1.000	0.609	0.598	0.804	0.713	0.594	0.471	0.488	0.511	0.515	0.438	0.763	0.317	0.434
홍콩	0.810	0.609	1.000	0.709	0.708	0.422	0.290	0.028	0.067	0.171	0.111	0.099	0.387	0.133	0.265
대만	0.786	0.598	0.709	1.000	0.693	0.662	0.569	0.323	0.344	0.433	0.385	0.322	0.622	0.162	0.406
동남아	0.788	0.804	0.708	0.693	1.000	0.704	0.685	0.289	0.350	0.398	0.380	0.375	0.788	0.171	0.417
로컬	0.593	0.713	0.422	0.662	0.704	1.000	0.561	0.499	0.424	0.474	0.469	0.327	0.836	0.283	0.318
러시아	0.505	0.594	0.290	0.569	0.685	0.561	1.000	0.488	0.566	0.512	0.552	0.661	0.829	0.143	0.575
미국	0.131	0.471	0.028	0.323	0.289	0.499	0.488	1.000	0.899	0.876	0.921	0.759	0.563	0.257	0.430
베트남	0.193	0.488	0.067	0.344	0.350	0.424	0.566	0.899	1.000	0.863	0.903	0.808	0.570	0.128	0.292
태국	0.288	0.511	0.171	0.433	0.398	0.474	0.512	0.876	0.863	1.000	0.903	0.725	0.546	0.109	0.290
몽골	0.214	0.515	0.111	0.385	0.380	0.469	0.552	0.921	0.903	0.903	1.000	0.773	0.585	0.208	0.326
필리핀	0.193	0.438	0.099	0.322	0.375	0.327	0.661	0.759	0.808	0.725	0.773	1.000	0.570	0.139	0.270
기타	0.547	0.763	0.387	0.622	0.788	0.836	0.829	0.563	0.570	0.546	0.585	0.570	1.000	0.196	0.640
영업장	0.148	0.317	0.133	0.162	0.171	0.283	0.143	0.257	0.128	0.109	0.208	0.139	0.196	1.000	0.000
방문고객구분	0.454	0.434	0.265	0.406	0.417	0.318	0.575	0.430	0.292	0.290	0.326	0.270	0.640	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	년월	영업장	방문고객구분	일본	중국	홍콩	대만	동남아	로컬	러시아	기타
0	2017-01-31	강남코엑스점	VIP	1317	2669	34	189	208	1812	0	363
1	2017-01-31	강남코엑스점	단체관광객	247	2671	25	188	0	3	0	0
2	2017-01-31	강남코엑스점	일반고객	2829	11274	342	326	1815	2432	83	4511
3	2017-01-31	강북힐튼점	VIP	1931	1720	18	136	313	635	0	199
4	2017-01-31	강북힐튼점	단체관광객	1273	6272	534	61	190	0	0	0
5	2017-01-31	강북힐튼점	일반고객	8633	23918	365	862	4230	1409	124	4567
6	2017-01-31	부산롯데점	VIP	1628	1220	28	124	58	227	27	26
7	2017-01-31	부산롯데점	단체관광객	1564	22	133	1138	26	0	0	0
8	2017-01-31	부산롯데점	일반고객	5762	1815	146	204	1907	339	320	986
9	2017-02-28	강남코엑스점	VIP	1188	2515	20	194	249	1671	4	317

	년월	영업장	방문고객구분	일본	중국	홍콩	대만	동남아	로컬	러시아	미국	베트남	태국	몽골	필리핀	기타
670	2023-06-30	부산롯데점	일반고객	4022	1266	4	918	241	154	327	197	226	20	126	70	792
671	2023-07-31	강남코엑스점	VIP	1274	1571	22	77	65	849	3	501	18	18	145	1	62
672	2023-07-31	강남코엑스점	단체관광객	0	0	0	0	0	0	0	0	0	0	0	0	0
673	2023-07-31	강남코엑스점	일반고객	2733	6020	55	329	217	644	149	864	67	79	547	52	1540
674	2023-07-31	서울드래곤시티점	VIP	1127	2304	3	165	39	377	10	374	60	49	15	0	76
675	2023-07-31	서울드래곤시티점	단체관광객	0	0	0	0	0	0	0	0	0	0	0	0	0
676	2023-07-31	서울드래곤시티점	일반고객	5698	17142	89	656	506	327	128	632	195	81	459	50	840
677	2023-07-31	부산롯데점	VIP	960	279	0	77	16	116	8	63	13	10	1	0	62
678	2023-07-31	부산롯데점	단체관광객	0	0	0	0	0	0	0	0	0	0	0	0	0
679	2023-07-31	부산롯데점	일반고객	4366	1378	49	666	211	142	295	233	186	19	65	59	905

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample