Overview

Dataset statistics

Number of variables21
Number of observations100
Missing cells182
Missing cells (%)8.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.4 KiB
Average record size in memory178.3 B

Variable types

Numeric4
Categorical14
Text2
Unsupported1

Alerts

promtn_ty_cd has constant value ""Constant
promtn_ty_nm has constant value ""Constant
bnef_co has constant value ""Constant
trmnl_modl_opersysm_ty_cd has constant value ""Constant
trmnl_modl_opersysm_ty_nm has constant value ""Constant
clustr_id has constant value ""Constant
coupon_use_str_nm is highly imbalanced (53.3%)Imbalance
coupon_use_str_addr is highly imbalanced (53.3%)Imbalance
trmnl_modl_nm has 100 (100.0%) missing valuesMissing
przwin_rt has 5 (5.0%) missing valuesMissing
coupon_use_dt has 77 (77.0%) missing valuesMissing
seq_no has unique valuesUnique
crtfc_dt has unique valuesUnique
trmnl_modl_nm is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 09:50:39.645928
Analysis finished2023-12-10 09:50:40.202764
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

seq_no
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean69.67
Minimum1
Maximum654
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:50:40.393826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.95
Q127.75
median53.5
Q378.25
95-th percentile98.05
Maximum654
Range653
Interquartile range (IQR)50.5

Descriptive statistics

Standard deviation106.88879
Coefficient of variation (CV)1.5342154
Kurtosis25.489335
Mean69.67
Median Absolute Deviation (MAD)25.5
Skewness4.9844996
Sum6967
Variance11425.213
MonotonicityNot monotonic
2023-12-10T18:50:40.838933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
9 1
1.0%
10 1
1.0%
11 1
1.0%
12 1
1.0%
ValueCountFrequency (%)
654 1
1.0%
653 1
1.0%
652 1
1.0%
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%

promtn_ty_cd
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
13 100
100.0%

Length

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

Common Values (Plot)

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

promtn_ty_nm
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
중국게임프로모션참여고객성향
100 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중국게임프로모션참여고객성향
2nd row중국게임프로모션참여고객성향
3rd row중국게임프로모션참여고객성향
4th row중국게임프로모션참여고객성향
5th row중국게임프로모션참여고객성향

Common Values

ValueCountFrequency (%)
중국게임프로모션참여고객성향 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:41.775396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중국게임프로모션참여고객성향 100
100.0%

promtn_nm
Categorical

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
双店开业迎中秋，优惠赚不停（西兴隆街店）
34 
双店开业迎中秋，优惠赚不停（美后亖食店）
27 
国庆转转乐
21 
华侨城集市抽奖
15 
泽田转转乐
 
3

Length

Max length20
Median length20
Mean length14.45
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row国庆转转乐
2nd row泽田转转乐
3rd row国庆转转乐
4th row国庆转转乐
5th row国庆转转乐

Common Values

ValueCountFrequency (%)
双店开业迎中秋，优惠赚不停（西兴隆街店） 34
34.0%
双店开业迎中秋，优惠赚不停（美后亖食店） 27
27.0%
国庆转转乐 21
21.0%
华侨城集市抽奖 15
15.0%
泽田转转乐 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:42.263085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
双店开业迎中秋，优惠赚不停（西兴隆街店） 34
34.0%
双店开业迎中秋，优惠赚不停（美后亖食店） 27
27.0%
国庆转转乐 21
21.0%
华侨城集市抽奖 15
15.0%
泽田转转乐 3
 
3.0%

promtn_bnef_cn
Categorical

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）
34 
熊煮咖啡美后亖食店新店开业，抽奖赢不停
27 
单笔消费满300元可抽奖一次
21 
凡购买泰有缘奶茶2杯及以上朋友，可参与一次抽奖
15 
转出好运！_x000D_,一次购买5个即可获得1次抽奖机会
 
3

Length

Max length67
Median length29
Mean length35.17
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row单笔消费满300元可抽奖一次
2nd row转出好运！_x000D_,一次购买5个即可获得1次抽奖机会
3rd row单笔消费满300元可抽奖一次
4th row单笔消费满300元可抽奖一次
5th row单笔消费满300元可抽奖一次

Common Values

ValueCountFrequency (%)
熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店） 34
34.0%
熊煮咖啡美后亖食店新店开业，抽奖赢不停 27
27.0%
单笔消费满300元可抽奖一次 21
21.0%
凡购买泰有缘奶茶2杯及以上朋友，可参与一次抽奖 15
15.0%
转出好运！_x000D_,一次购买5个即可获得1次抽奖机会 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:42.722742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店） 34
34.0%
熊煮咖啡美后亖食店新店开业，抽奖赢不停 27
27.0%
单笔消费满300元可抽奖一次 21
21.0%
凡购买泰有缘奶茶2杯及以上朋友，可参与一次抽奖 15
15.0%
转出好运！_x000d_,一次购买5个即可获得1次抽奖机会 3
 
3.0%

bnef_co
Categorical

CONSTANT 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
6 100
100.0%

Length

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

Common Values (Plot)

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

cstmr_id
Text

Distinct69
Distinct (%)69.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:50:43.708133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length28
Mean length28
Min length28

Characters and Unicode

Total characters2800
Distinct characters64
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique62 ?
Unique (%)62.0%

Sample

1st rowoxGQgxNlCZ_5auxXas3kDoQEYwYQ
2nd rowoxGQgxEROxYzsd3mVwZ0PsL1DXjw
3rd rowoxGQgxNlCZ_5auxXas3kDoQEYwYQ
4th rowoxGQgxMwvpQ4amcNcKmNrUHHT_R4
5th rowoxGQgxD7O146NuNEFiWjbF2ZWgMk
ValueCountFrequency (%)
oxgqgxd7o146nunefiwjbf2zwgmk 14
 
14.0%
oxgqgxfeyb50xa1h3zwtkbfdzqfe 9
 
9.0%
oxgqgxlgddp-xx4gvul_qv7hmfmw 4
 
4.0%
oxgqgxepcsgzfvyhgusds0ztevys 4
 
4.0%
oxgqgxeroxyzsd3mvwz0psl1dxjw 3
 
3.0%
oxgqgxnlcz_5auxxas3kdoqeywyq 2
 
2.0%
oxgqgxohufv9bmbix9l2o_5_iexc 2
 
2.0%
oxgqgxaifzw4tyt1ttc91de6y_gy 1
 
1.0%
oxgqgxfgyp6mntai6hxscmr0dong 1
 
1.0%
oxgqgxiedfehcqifashuetlcq6vs 1
 
1.0%
Other values (59) 59
59.0%
2023-12-10T18:50:44.564615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
x 238
 
8.5%
g 141
 
5.0%
Q 137
 
4.9%
G 131
 
4.7%
o 123
 
4.4%
F 92
 
3.3%
E 61
 
2.2%
D 60
 
2.1%
W 54
 
1.9%
s 52
 
1.9%
Other values (54) 1711
61.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1222
43.6%
Uppercase Letter 1194
42.6%
Decimal Number 329
 
11.8%
Connector Punctuation 32
 
1.1%
Dash Punctuation 23
 
0.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
x 238
19.5%
g 141
 
11.5%
o 123
 
10.1%
s 52
 
4.3%
k 47
 
3.8%
z 41
 
3.4%
w 39
 
3.2%
j 38
 
3.1%
t 36
 
2.9%
b 35
 
2.9%
Other values (16) 432
35.4%
Uppercase Letter
ValueCountFrequency (%)
Q 137
 
11.5%
G 131
 
11.0%
F 92
 
7.7%
E 61
 
5.1%
D 60
 
5.0%
W 54
 
4.5%
N 50
 
4.2%
M 50
 
4.2%
Z 47
 
3.9%
B 45
 
3.8%
Other values (16) 467
39.1%
Decimal Number
ValueCountFrequency (%)
1 48
14.6%
4 46
14.0%
0 34
10.3%
3 34
10.3%
6 33
10.0%
7 32
9.7%
2 31
9.4%
8 29
8.8%
5 27
8.2%
9 15
 
4.6%
Connector Punctuation
ValueCountFrequency (%)
_ 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2416
86.3%
Common 384
 
13.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
x 238
 
9.9%
g 141
 
5.8%
Q 137
 
5.7%
G 131
 
5.4%
o 123
 
5.1%
F 92
 
3.8%
E 61
 
2.5%
D 60
 
2.5%
W 54
 
2.2%
s 52
 
2.2%
Other values (42) 1327
54.9%
Common
ValueCountFrequency (%)
1 48
12.5%
4 46
12.0%
0 34
8.9%
3 34
8.9%
6 33
8.6%
_ 32
8.3%
7 32
8.3%
2 31
8.1%
8 29
7.6%
5 27
7.0%
Other values (2) 38
9.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2800
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
x 238
 
8.5%
g 141
 
5.0%
Q 137
 
4.9%
G 131
 
4.7%
o 123
 
4.4%
F 92
 
3.3%
E 61
 
2.2%
D 60
 
2.1%
W 54
 
1.9%
s 52
 
1.9%
Other values (54) 1711
61.1%

trmnl_modl_nm
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

trmnl_modl_opersysm_ty_cd
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-10T18:50:44.866302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

trmnl_modl_opersysm_ty_nm
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
모델정보수집거부
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row모델정보수집거부
2nd row모델정보수집거부
3rd row모델정보수집거부
4th row모델정보수집거부
5th row모델정보수집거부

Common Values

ValueCountFrequency (%)
모델정보수집거부 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:45.384707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
모델정보수집거부 100
100.0%

crtfc_dt
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0210899 × 1013
Minimum2.0210127 × 1013
Maximum2.021093 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:50:45.594686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0210127 × 1013
5-th percentile2.021092 × 1013
Q12.021092 × 1013
median2.021092 × 1013
Q32.0210924 × 1013
95-th percentile2.021093 × 1013
Maximum2.021093 × 1013
Range8.0310167 × 108
Interquartile range (IQR)4039639.2

Descriptive statistics

Standard deviation1.3648718 × 108
Coefficient of variation (CV)6.7531472 × 10-6
Kurtosis29.845331
Mean2.0210899 × 1013
Median Absolute Deviation (MAD)37625
Skewness-5.5875048
Sum2.0210899 × 1015
Variance1.8628749 × 1016
MonotonicityNot monotonic
2023-12-10T18:50:46.001069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20210930213421 1
 
1.0%
20210920162900 1
 
1.0%
20210920150659 1
 
1.0%
20210920150701 1
 
1.0%
20210920150913 1
 
1.0%
20210920151650 1
 
1.0%
20210920154130 1
 
1.0%
20210920154214 1
 
1.0%
20210920155118 1
 
1.0%
20210920155548 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
20210127111750 1
1.0%
20210127112043 1
1.0%
20210127112119 1
1.0%
20210920114658 1
1.0%
20210920122653 1
1.0%
20210920122756 1
1.0%
20210920125015 1
1.0%
20210920125412 1
1.0%
20210920130431 1
1.0%
20210920131643 1
1.0%
ValueCountFrequency (%)
20210930213421 1
1.0%
20210930213326 1
1.0%
20210930161229 1
1.0%
20210930114928 1
1.0%
20210930114912 1
1.0%
20210930114855 1
1.0%
20210930114725 1
1.0%
20210930114638 1
1.0%
20210930114624 1
1.0%
20210930114559 1
1.0%

coupon_nm
Categorical

Distinct20
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
熊煮咖啡挂耳包3包
12 
熊煮咖啡挂耳包5包
10 
熊煮挂耳包3片
10 
精美饰品
9 
动漫挂画
9 
Other values (15)
50 

Length

Max length18
Median length11.5
Mean length6.95
Min length4

Unique

Unique6 ?
Unique (%)6.0%

Sample

1st row动漫便签本
2nd row一张铜锣烧兑换券
3rd row动漫超大鼠标垫
4th row动漫挂画
5th row动漫超大鼠标垫

Common Values

ValueCountFrequency (%)
熊煮咖啡挂耳包3包 12
12.0%
熊煮咖啡挂耳包5包 10
10.0%
熊煮挂耳包3片 10
10.0%
精美饰品 9
9.0%
动漫挂画 9
9.0%
泡泡系列买一赠一 8
8.0%
动漫便签本 8
8.0%
饮品10元代金券 7
7.0%
线下8折券 6
 
6.0%
<NA> 5
 
5.0%
Other values (10) 16
16.0%

Length

2023-12-10T18:50:46.295553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
熊煮咖啡挂耳包3包 12
12.0%
熊煮挂耳包3片 10
10.0%
熊煮咖啡挂耳包5包 10
10.0%
精美饰品 9
9.0%
动漫挂画 9
9.0%
泡泡系列买一赠一 8
8.0%
动漫便签本 8
8.0%
饮品10元代金券 7
7.0%
线下8折券 6
 
6.0%
na 5
 
5.0%
Other values (10) 16
16.0%

coupon_id
Text

Distinct96
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:50:46.704952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length32
Mean length30.65
Min length5

Characters and Unicode

Total characters3065
Distinct characters21
Distinct categories3 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique95 ?
Unique (%)95.0%

Sample

1st rowcb71efd333994a9996f493b54a48b2c6
2nd rowdd00eb0ab66545aabe9efcf6f48d8470
3rd row191bae8ede73403fa06b63b063c1a4b6
4th rowb132ae8c44034ee98a8cf6d1d3064a47
5th rowe84c68df21c048d49f6b1f854d4f0b42
ValueCountFrequency (%)
쿠폰미발급 5
 
5.0%
cb71efd333994a9996f493b54a48b2c6 1
 
1.0%
120e810c748c4bb58caea46a4157d604 1
 
1.0%
9507018b2882442f938d039a3bb8885e 1
 
1.0%
74d51edc207142f18b4ddf19dfdd3a52 1
 
1.0%
19dabd4b526b4bc2894bdffb553361a0 1
 
1.0%
c5dff3ec6d4146cb9916d835c946ed43 1
 
1.0%
8136648b30264a7187f9ed393454c7d1 1
 
1.0%
3294da3f33f94a128a0d86dd449380a1 1
 
1.0%
33d1c6a0a5544e8681060ea0630ba2ef 1
 
1.0%
Other values (86) 86
86.0%
2023-12-10T18:50:47.347575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 272
 
8.9%
3 209
 
6.8%
0 203
 
6.6%
1 201
 
6.6%
8 195
 
6.4%
d 193
 
6.3%
a 191
 
6.2%
9 191
 
6.2%
b 186
 
6.1%
e 182
 
5.9%
Other values (11) 1042
34.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1949
63.6%
Lowercase Letter 1091
35.6%
Other Letter 25
 
0.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 272
14.0%
3 209
10.7%
0 203
10.4%
1 201
10.3%
8 195
10.0%
9 191
9.8%
5 181
9.3%
6 181
9.3%
2 166
8.5%
7 150
7.7%
Lowercase Letter
ValueCountFrequency (%)
d 193
17.7%
a 191
17.5%
b 186
17.0%
e 182
16.7%
c 179
16.4%
f 160
14.7%
Other Letter
ValueCountFrequency (%)
폰 5
20.0%
급 5
20.0%
발 5
20.0%
미 5
20.0%
쿠 5
20.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1949
63.6%
Latin 1091
35.6%
Hangul 25
 
0.8%

Most frequent character per script

Common
ValueCountFrequency (%)
4 272
14.0%
3 209
10.7%
0 203
10.4%
1 201
10.3%
8 195
10.0%
9 191
9.8%
5 181
9.3%
6 181
9.3%
2 166
8.5%
7 150
7.7%
Latin
ValueCountFrequency (%)
d 193
17.7%
a 191
17.5%
b 186
17.0%
e 182
16.7%
c 179
16.4%
f 160
14.7%
Hangul
ValueCountFrequency (%)
폰 5
20.0%
급 5
20.0%
발 5
20.0%
미 5
20.0%
쿠 5
20.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3040
99.2%
Hangul 25
 
0.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 272
 
8.9%
3 209
 
6.9%
0 203
 
6.7%
1 201
 
6.6%
8 195
 
6.4%
d 193
 
6.3%
a 191
 
6.3%
9 191
 
6.3%
b 186
 
6.1%
e 182
 
6.0%
Other values (6) 1017
33.5%
Hangul
ValueCountFrequency (%)
폰 5
20.0%
급 5
20.0%
발 5
20.0%
미 5
20.0%
쿠 5
20.0%

przwin_rt
Real number (ℝ)

MISSING 

Distinct10
Distinct (%)10.5%
Missing5
Missing (%)5.0%
Infinite0
Infinite (%)0.0%
Mean34.642105
Minimum1
Maximum53
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:50:47.609823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q115
median40
Q350
95-th percentile53
Maximum53
Range52
Interquartile range (IQR)35

Descriptive statistics

Standard deviation17.606162
Coefficient of variation (CV)0.50823013
Kurtosis-1.1438753
Mean34.642105
Median Absolute Deviation (MAD)10
Skewness-0.65762516
Sum3291
Variance309.97693
MonotonicityNot monotonic
2023-12-10T18:50:48.213699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
40 28
28.0%
50 24
24.0%
15 17
17.0%
53 12
12.0%
3 3
 
3.0%
10 3
 
3.0%
5 3
 
3.0%
2 2
 
2.0%
1 2
 
2.0%
20 1
 
1.0%
(Missing) 5
 
5.0%
ValueCountFrequency (%)
1 2
 
2.0%
2 2
 
2.0%
3 3
 
3.0%
5 3
 
3.0%
10 3
 
3.0%
15 17
17.0%
20 1
 
1.0%
40 28
28.0%
50 24
24.0%
53 12
12.0%
ValueCountFrequency (%)
53 12
12.0%
50 24
24.0%
40 28
28.0%
20 1
 
1.0%
15 17
17.0%
10 3
 
3.0%
5 3
 
3.0%
3 3
 
3.0%
2 2
 
2.0%
1 2
 
2.0%

coupon_usgstt_nm
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
발급
72 
사용
23 
<NA>
 
5

Length

Max length4
Median length2
Mean length2.1
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사용
2nd row발급
3rd row사용
4th row사용
5th row발급

Common Values

ValueCountFrequency (%)
발급 72
72.0%
사용 23
 
23.0%
<NA> 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:48.679754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발급 72
72.0%
사용 23
 
23.0%
na 5
 
5.0%

coupon_use_dt
Real number (ℝ)

MISSING 

Distinct23
Distinct (%)100.0%
Missing77
Missing (%)77.0%
Infinite0
Infinite (%)0.0%
Mean2.0210929 × 1013
Minimum2.021092 × 1013
Maximum2.021093 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:50:49.017574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.021092 × 1013
5-th percentile2.0210924 × 1013
Q12.0210928 × 1013
median2.021093 × 1013
Q32.021093 × 1013
95-th percentile2.021093 × 1013
Maximum2.021093 × 1013
Range10090522
Interquartile range (IQR)1943800

Descriptive statistics

Standard deviation2589972.5
Coefficient of variation (CV)1.2814713 × 10-7
Kurtosis5.4965279
Mean2.0210929 × 1013
Median Absolute Deviation (MAD)388
Skewness-2.3748336
Sum4.6485136 × 1014
Variance6.7079574 × 1012
MonotonicityNot monotonic
2023-12-10T18:50:49.296736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
20210930213336 1
 
1.0%
20210920122911 1
 
1.0%
20210924194649 1
 
1.0%
20210924194600 1
 
1.0%
20210928170608 1
 
1.0%
20210928170843 1
 
1.0%
20210928170831 1
 
1.0%
20210928170933 1
 
1.0%
20210930114215 1
 
1.0%
20210930114339 1
 
1.0%
Other values (13) 13
 
13.0%
(Missing) 77
77.0%
ValueCountFrequency (%)
20210920122911 1
1.0%
20210924194600 1
1.0%
20210924194649 1
1.0%
20210928170608 1
1.0%
20210928170831 1
1.0%
20210928170843 1
1.0%
20210928170933 1
1.0%
20210930114215 1
1.0%
20210930114339 1
1.0%
20210930114354 1
1.0%
ValueCountFrequency (%)
20210930213433 1
1.0%
20210930213336 1
1.0%
20210930161323 1
1.0%
20210930114921 1
1.0%
20210930114904 1
1.0%
20210930114732 1
1.0%
20210930114644 1
1.0%
20210930114631 1
1.0%
20210930114604 1
1.0%
20210930114541 1
1.0%

coupon_use_str_nm
Categorical

IMBALANCE 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
77 
御宅萌物动漫店
20 
远大店
 
2
熊煮咖啡（前门店）
 
1

Length

Max length9
Median length4
Mean length4.63
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row御宅萌物动漫店
2nd row<NA>
3rd row御宅萌物动漫店
4th row御宅萌物动漫店
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 77
77.0%
御宅萌物动漫店 20
 
20.0%
远大店 2
 
2.0%
熊煮咖啡（前门店） 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:49.739137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 77
77.0%
御宅萌物动漫店 20
 
20.0%
远大店 2
 
2.0%
熊煮咖啡（前门店） 1
 
1.0%

coupon_use_str_addr
Categorical

IMBALANCE 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
77 
杭州市国大城市广场地下一楼
20 
海口市秀英区远大购物中心6号7#1-110
 
2
北京市东城区西打磨厂街214号
 
1

Length

Max length21
Median length4
Mean length6.25
Min length4

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row杭州市国大城市广场地下一楼
2nd row<NA>
3rd row杭州市国大城市广场地下一楼
4th row杭州市国大城市广场地下一楼
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 77
77.0%
杭州市国大城市广场地下一楼 20
 
20.0%
海口市秀英区远大购物中心6号7#1-110 2
 
2.0%
北京市东城区西打磨厂街214号 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:50.172347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 77
77.0%
杭州市国大城市广场地下一楼 20
 
20.0%
海口市秀英区远大购物中心6号7#1-110 2
 
2.0%
北京市东城区西打磨厂街214号 1
 
1.0%

coupon_bnef_cn
Categorical

Distinct15
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
35 
熊煮咖啡挂耳包3包
12 
熊煮咖啡挂耳包三片（种类随机）
10 
熊煮咖啡挂耳包5包
10 
黑泡泡/黑黑泡饮品买一赠一，每单限使用一张，限当日使用
8 
Other values (10)
25 

Length

Max length27
Median length25
Mean length11.58
Min length4

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st row<NA>
2nd row价值16元铜锣烧兑换券一张
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 35
35.0%
熊煮咖啡挂耳包3包 12
 
12.0%
熊煮咖啡挂耳包三片（种类随机） 10
 
10.0%
熊煮咖啡挂耳包5包 10
 
10.0%
黑泡泡/黑黑泡饮品买一赠一，每单限使用一张，限当日使用 8
 
8.0%
全店任意饮品10元优惠券，每单限用一张，限当日使用 7
 
7.0%
恭喜中奖8折券，任意门店都可以用哦 6
 
6.0%
熊煮定制帆布包一个 3
 
3.0%
价值16元铜锣烧兑换券一张 2
 
2.0%
熊煮定制保温杯一只，限当日兑换（颜色随机） 2
 
2.0%
Other values (5) 5
 
5.0%

Length

2023-12-10T18:50:50.462864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 35
35.0%
熊煮咖啡挂耳包3包 12
 
12.0%
熊煮咖啡挂耳包三片（种类随机） 10
 
10.0%
熊煮咖啡挂耳包5包 10
 
10.0%
黑泡泡/黑黑泡饮品买一赠一，每单限使用一张，限当日使用 8
 
8.0%
全店任意饮品10元优惠券，每单限用一张，限当日使用 7
 
7.0%
恭喜中奖8折券，任意门店都可以用哦 6
 
6.0%
熊煮定制帆布包一个 3
 
3.0%
价值16元铜锣烧兑换券一张 2
 
2.0%
熊煮定制保温杯一只，限当日兑换（颜色随机） 2
 
2.0%
Other values (5) 5
 
5.0%

clustr_id
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-10T18:50:50.764294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

esntl_id
Categorical

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
V00A015B301S0016FRT001
34 
V00A015B301S0016FRT003
27 
V00A015B450S0016FRT001
21 
V00A015B391S0016FRT008
15 
V00A015B185S0016FRT001
 
3

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowV00A015B450S0016FRT001
2nd rowV00A015B185S0016FRT001
3rd rowV00A015B450S0016FRT001
4th rowV00A015B450S0016FRT001
5th rowV00A015B450S0016FRT001

Common Values

ValueCountFrequency (%)
V00A015B301S0016FRT001 34
34.0%
V00A015B301S0016FRT003 27
27.0%
V00A015B450S0016FRT001 21
21.0%
V00A015B391S0016FRT008 15
15.0%
V00A015B185S0016FRT001 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:50:51.329677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
v00a015b301s0016frt001 34
34.0%
v00a015b301s0016frt003 27
27.0%
v00a015b450s0016frt001 21
21.0%
v00a015b391s0016frt008 15
15.0%
v00a015b185s0016frt001 3
 
3.0%

Sample

seq_nopromtn_ty_cdpromtn_ty_nmpromtn_nmpromtn_bnef_cnbnef_cocstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcrtfc_dtcoupon_nmcoupon_idprzwin_rtcoupon_usgstt_nmcoupon_use_dtcoupon_use_str_nmcoupon_use_str_addrcoupon_bnef_cnclustr_idesntl_id
0113중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxNlCZ_5auxXas3kDoQEYwYQ<NA>0모델정보수집거부20210930213421动漫便签本cb71efd333994a9996f493b54a48b2c650사용20210930213433御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
165213중국게임프로모션참여고객성향泽田转转乐转出好运！_x000D_,一次购买5个即可获得1次抽奖机会6oxGQgxEROxYzsd3mVwZ0PsL1DXjw<NA>0모델정보수집거부20210127112119一张铜锣烧兑换券dd00eb0ab66545aabe9efcf6f48d847015발급<NA><NA><NA>价值16元铜锣烧兑换券一张0V00A015B185S0016FRT001
2313중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxNlCZ_5auxXas3kDoQEYwYQ<NA>0모델정보수집거부20210930213326动漫超大鼠标垫191bae8ede73403fa06b63b063c1a4b63사용20210930213336御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
3413중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxMwvpQ4amcNcKmNrUHHT_R4<NA>0모델정보수집거부20210930161229动漫挂画b132ae8c44034ee98a8cf6d1d3064a4740사용20210930161323御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
4513중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxD7O146NuNEFiWjbF2ZWgMk<NA>0모델정보수집거부20210930114928动漫超大鼠标垫e84c68df21c048d49f6b1f854d4f0b423발급<NA><NA><NA><NA>0V00A015B450S0016FRT001
5613중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxD7O146NuNEFiWjbF2ZWgMk<NA>0모델정보수집거부20210930114912动漫雨伞330070cdb784442db31c7192400b3ee92사용20210930114921御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
6713중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxD7O146NuNEFiWjbF2ZWgMk<NA>0모델정보수집거부20210930114855动漫便签本d02ac0a333124e2d89453028261ff20e50사용20210930114904御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
765313중국게임프로모션참여고객성향泽田转转乐转出好运！_x000D_,一次购买5个即可获得1次抽奖机会6oxGQgxEROxYzsd3mVwZ0PsL1DXjw<NA>0모델정보수집거부20210127112043两张铜锣烧兑换券971e6e12cedb4b6484f19af630e30e4b20발급<NA><NA><NA>价值16元铜锣烧兑换券两张0V00A015B185S0016FRT001
8913중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxD7O146NuNEFiWjbF2ZWgMk<NA>0모델정보수집거부20210930114725动漫挂画2d817d94078c46728670fcb3f6f8667240사용20210930114732御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
91013중국게임프로모션참여고객성향国庆转转乐单笔消费满300元可抽奖一次6oxGQgxD7O146NuNEFiWjbF2ZWgMk<NA>0모델정보수집거부20210930114638动漫挂画d41361ad3bb1413c853d49f3400d1ca540사용20210930114644御宅萌物动漫店杭州市国大城市广场地下一楼<NA>0V00A015B450S0016FRT001
seq_nopromtn_ty_cdpromtn_ty_nmpromtn_nmpromtn_bnef_cnbnef_cocstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcrtfc_dtcoupon_nmcoupon_idprzwin_rtcoupon_usgstt_nmcoupon_use_dtcoupon_use_str_nmcoupon_use_str_addrcoupon_bnef_cnclustr_idesntl_id
909113중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（美后亖食店）熊煮咖啡美后亖食店新店开业，抽奖赢不停6oxGQgxBVupprcktZREeK8oZyizqQ<NA>0모델정보수집거부20210920134814Cafedekona手冲套装81b3a3878f0a4720ba1474f205613e831발급<NA><NA><NA>Cafedekona手冲套装一套0V00A015B301S0016FRT003
919213중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（西兴隆街店）熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）6oxGQgxP10HOkX8WLvxt2ZlI_vLbg<NA>0모델정보수집거부20210920132838熊煮定制帆布包一个913a179070e047c885289644621b19a110발급<NA><NA><NA>熊煮定制帆布包一个0V00A015B301S0016FRT001
929313중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（西兴隆街店）熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）6oxGQgxPosgThA2XXrss9LiOHnJHs<NA>0모델정보수집거부20210920132545饮品10元代金券51f1a4515f804ee4b5a3b5be58add0af15발급<NA><NA><NA>全店任意饮品10元优惠券，每单限用一张，限当日使用0V00A015B301S0016FRT001
939413중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（西兴隆街店）熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）6oxGQgxPkdtb9H9-tECp_QYiM0Xm8<NA>0모델정보수집거부20210920131643熊煮限量版徽章一枚a435cb125cea47e08e808db3ca3ab2f15발급<NA><NA><NA>熊煮限量版徽章一枚，限当日兑换0V00A015B301S0016FRT001
949513중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（美后亖食店）熊煮咖啡美后亖食店新店开业，抽奖赢不停6oxGQgxCpipgWYEwq-FnvfMXI4FRA<NA>0모델정보수집거부20210920130431熊煮咖啡挂耳包3包75eb9e36ed1148cfb27a9725cdb5691453발급<NA><NA><NA>熊煮咖啡挂耳包3包0V00A015B301S0016FRT003
959613중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（西兴隆街店）熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）6oxGQgxJ2jMPelHTL_NuZhCnAfo7A<NA>0모델정보수집거부20210920125412饮品10元代金券9c3e20f90f014b81854b31d25038fe7015발급<NA><NA><NA>全店任意饮品10元优惠券，每单限用一张，限当日使用0V00A015B301S0016FRT001
969713중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（西兴隆街店）熊煮咖啡西兴隆街店/亖食店双店开业迎中秋，即日起至2021年9月21日，到店即可免费参加转盘抽奖活动，每人每日限一次（熊煮西兴隆街店）6oxGQgxKDKCzkBhH6bAaGqQg3aEDI<NA>0모델정보수집거부20210920125015熊煮定制帆布包一个42878c0220c94d5f9c5d40597fc81d8610발급<NA><NA><NA>熊煮定制帆布包一个0V00A015B301S0016FRT001
979813중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（美后亖食店）熊煮咖啡美后亖食店新店开业，抽奖赢不停6oxGQgxMtrGlqQJBvVo7FkpC81F_4<NA>0모델정보수집거부20210920122756正晃行Ultrakoki智能双称一台1302ec8f3ded4734902b96009f7ed3ab1사용20210920122911熊煮咖啡（前门店）北京市东城区西打磨厂街214号正晃行Ultrakoki智能双称一台（白色）0V00A015B301S0016FRT003
989913중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（美后亖食店）熊煮咖啡美后亖食店新店开业，抽奖赢不停6oxGQgxLYrdpnZF8-9a6yDloUrrYs<NA>0모델정보수집거부20210920122653熊煮咖啡挂耳包5包49e6bcf85f664c02b6f2c82ce3f9441c40발급<NA><NA><NA>熊煮咖啡挂耳包5包0V00A015B301S0016FRT003
9910013중국게임프로모션참여고객성향双店开业迎中秋，优惠赚不停（美后亖食店）熊煮咖啡美后亖食店新店开业，抽奖赢不停6oxGQgxNHJVGaYdOdCyWi0ItH-VxE<NA>0모델정보수집거부20210920114658熊煮咖啡挂耳包3包99966631f15845c3974e55101d5109e953발급<NA><NA><NA>熊煮咖啡挂耳包3包0V00A015B301S0016FRT003