Overview

Dataset statistics

Number of variables23
Number of observations100
Missing cells258
Missing cells (%)11.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory18.8 KiB
Average record size in memory192.3 B

Variable types

Numeric3
Categorical18
Unsupported2

Alerts

PROMTN_TY_CD has constant value ""Constant
PROMTN_TY_NM has constant value ""Constant
TRMNL_MODL_OPERSYSM_TY_CD has constant value ""Constant
PROMTN_NM is highly imbalanced (69.6%)Imbalance
PROMTN_BNEF_CN is highly imbalanced (70.4%)Imbalance
BRAND_NM is highly imbalanced (66.2%)Imbalance
CRTFC_STR_NM is highly imbalanced (70.4%)Imbalance
CRTFC_STR_ADDR is highly imbalanced (70.4%)Imbalance
CLUSTR_ID is highly imbalanced (91.9%)Imbalance
ESNTL_ID is highly imbalanced (70.4%)Imbalance
TRMNL_MODL_NM has 100 (100.0%) missing valuesMissing
TRMNL_MODL_OPERSYSM_TY_NM has 100 (100.0%) missing valuesMissing
COUPON_USE_DT has 58 (58.0%) missing valuesMissing
SEQ_NO has unique valuesUnique
TRMNL_MODL_NM is an unsupported type, check if it needs cleaning or further analysisUnsupported
TRMNL_MODL_OPERSYSM_TY_NM is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 09:39:50.548323
Analysis finished2023-12-10 09:39:50.868966
Duration0.32 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%
Mean50.5
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:51.029528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.95
Q125.75
median50.5
Q375.25
95-th percentile95.05
Maximum100
Range99
Interquartile range (IQR)49.5

Descriptive statistics

Standard deviation29.011492
Coefficient of variation (CV)0.57448499
Kurtosis-1.2
Mean50.5
Median Absolute Deviation (MAD)25
Skewness0
Sum5050
Variance841.66667
MonotonicityStrictly increasing
2023-12-10T18:39:51.303217image/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%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
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%
93 1
1.0%
92 1
1.0%
91 1
1.0%

PROMTN_TY_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
15 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:51.806650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
15 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:39:51.947770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

PROMTN_NM
Categorical

IMBALANCE 

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
叶子与茶(泰州香园街店）
86 
.
10 
盖盖章，饮品免费拿Q
 
1
台萃集章卡
 
1
盖盖章，饮品免费拿V
 
1

Length

Max length12
Median length12
Mean length10.79
Min length1

Unique

Unique4 ?
Unique (%)4.0%

Sample

1st row.
2nd row.
3rd row.
4th row.
5th row.

Common Values

ValueCountFrequency (%)
叶子与茶(泰州香园街店） 86
86.0%
. 10
 
10.0%
盖盖章，饮品免费拿Q 1
 
1.0%
台萃集章卡 1
 
1.0%
盖盖章，饮品免费拿V 1
 
1.0%
盖盖章，饮品免费拿!!! 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:52.481297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
叶子与茶(泰州香园街店） 86
86.0%
10
 
10.0%
盖盖章，饮品免费拿q 1
 
1.0%
台萃集章卡 1
 
1.0%
盖盖章，饮品免费拿v 1
 
1.0%
盖盖章，饮品免费拿 1
 
1.0%

PROMTN_BNEF_CN
Categorical

IMBALANCE 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
累计集章满10个送任意饮品一杯
86 
集满10枚印章即可免费兑换1瓶凉茶
9 
折前消费满258元即可集章一次 集章2个，兑换50元无门槛涮菜券 集章5个，兑换58元锅底代金券 集章10个，兑换迪奥口红一只
 
1
每消费一杯盖一个章，集满7个章,兑换10元代金劵一张；集满14个章,兑换10元代金劵一张；
 
1
累计6枚印章可免费获得饮品券
 
1
Other values (2)
 
2

Length

Max length63
Median length15
Mean length16.34
Min length14

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st row折前消费满258元即可集章一次 集章2个，兑换50元无门槛涮菜券 集章5个，兑换58元锅底代金券 集章10个，兑换迪奥口红一只
2nd row集满10枚印章即可免费兑换1瓶凉茶
3rd row集满10枚印章即可免费兑换1瓶凉茶
4th row集满10枚印章即可免费兑换1瓶凉茶
5th row集满10枚印章即可免费兑换1瓶凉茶

Common Values

ValueCountFrequency (%)
累计集章满10个送任意饮品一杯 86
86.0%
集满10枚印章即可免费兑换1瓶凉茶 9
 
9.0%
折前消费满258元即可集章一次 集章2个，兑换50元无门槛涮菜券 集章5个，兑换58元锅底代金券 集章10个，兑换迪奥口红一只 1
 
1.0%
每消费一杯盖一个章，集满7个章,兑换10元代金劵一张；集满14个章,兑换10元代金劵一张； 1
 
1.0%
累计6枚印章可免费获得饮品券 1
 
1.0%
每消费一杯盖一个章，集满8个章，兑换10元代金券1张；集满15个章，兑换10元代金券1张； 1
 
1.0%
满15元盖一个章，集满5个章送10元代金券一张！ 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:53.178049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
累计集章满10个送任意饮品一杯 86
83.5%
集满10枚印章即可免费兑换1瓶凉茶 9
 
8.7%
折前消费满258元即可集章一次 1
 
1.0%
集章2个，兑换50元无门槛涮菜券 1
 
1.0%
集章5个，兑换58元锅底代金券 1
 
1.0%
集章10个，兑换迪奥口红一只 1
 
1.0%
每消费一杯盖一个章，集满7个章,兑换10元代金劵一张；集满14个章,兑换10元代金劵一张； 1
 
1.0%
累计6枚印章可免费获得饮品券 1
 
1.0%
每消费一杯盖一个章，集满8个章，兑换10元代金券1张；集满15个章，兑换10元代金券1张； 1
 
1.0%
满15元盖一个章，集满5个章送10元代金券一张！ 1
 
1.0%

BRAND_NM
Categorical

IMBALANCE 

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
葉子与茶
86 
金葫芦凉茶
9 
茶百道
 
3
蜀大侠火锅
 
1
台萃
 
1

Length

Max length5
Median length4
Mean length4.05
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row蜀大侠火锅
2nd row金葫芦凉茶
3rd row金葫芦凉茶
4th row金葫芦凉茶
5th row金葫芦凉茶

Common Values

ValueCountFrequency (%)
葉子与茶 86
86.0%
金葫芦凉茶 9
 
9.0%
茶百道 3
 
3.0%
蜀大侠火锅 1
 
1.0%
台萃 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:53.624753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
葉子与茶 86
86.0%
金葫芦凉茶 9
 
9.0%
茶百道 3
 
3.0%
蜀大侠火锅 1
 
1.0%
台萃 1
 
1.0%

CSTMR_ID
Categorical

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
oxGQgxB7Bb3eCI6eCw-fuGGQJWvs
64 
oxGQgxCzyOkRGCAkNwzTvGvxX3Kw
14 
oxGQgxIpnaAelhAWwAYa0xC1R2Kc
9 
oxGQgxKS_b2zTLpyCcUgx7YnOzdE
 
5
oxGQgxMdRhOLH_HdgJCRD0zVgFaI
 
3
Other values (5)
 
5

Length

Max length28
Median length28
Mean length28
Min length28

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st rowotw4q0s26fhcsBaS0Hid4aQunXjk
2nd rowoxGQgxIpnaAelhAWwAYa0xC1R2Kc
3rd rowoxGQgxIpnaAelhAWwAYa0xC1R2Kc
4th rowoxGQgxIpnaAelhAWwAYa0xC1R2Kc
5th rowoxGQgxIpnaAelhAWwAYa0xC1R2Kc

Common Values

ValueCountFrequency (%)
oxGQgxB7Bb3eCI6eCw-fuGGQJWvs 64
64.0%
oxGQgxCzyOkRGCAkNwzTvGvxX3Kw 14
 
14.0%
oxGQgxIpnaAelhAWwAYa0xC1R2Kc 9
 
9.0%
oxGQgxKS_b2zTLpyCcUgx7YnOzdE 5
 
5.0%
oxGQgxMdRhOLH_HdgJCRD0zVgFaI 3
 
3.0%
otw4q0s26fhcsBaS0Hid4aQunXjk 1
 
1.0%
oxGQgxEOtPprGQqRKWx0ON5Oly8E 1
 
1.0%
oxGQgxD1sdDhTuua04YCkXdvmuOQ 1
 
1.0%
oxGQgxFrKCUmMgNUuyhubIZ0qX9E 1
 
1.0%
oxGQgxN1CTS7yf6WGybfGt6p-20o 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:54.045084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
oxgqgxb7bb3eci6ecw-fuggqjwvs 64
64.0%
oxgqgxczyokrgcaknwztvgvxx3kw 14
 
14.0%
oxgqgxipnaaelhawwaya0xc1r2kc 9
 
9.0%
oxgqgxks_b2ztlpyccugx7ynozde 5
 
5.0%
oxgqgxmdrholh_hdgjcrd0zvgfai 3
 
3.0%
otw4q0s26fhcsbas0hid4aqunxjk 1
 
1.0%
oxgqgxeotpprgqqrkwx0on5oly8e 1
 
1.0%
oxgqgxd1sddhtuua04yckxdvmuoq 1
 
1.0%
oxgqgxfrkcummgnuuyhubiz0qx9e 1
 
1.0%
oxgqgxn1cts7yf6wgybfgt6p-20o 1
 
1.0%

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
단말모델미분류
100 

Length

Max length7
Median length7
Mean length7
Min length7

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:39:54.264384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:39:54.410255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단말모델미분류 100
100.0%

TRMNL_MODL_OPERSYSM_TY_NM
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

CRTFC_DT
Real number (ℝ)

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.020093 × 1013
Minimum2.020093 × 1013
Maximum2.020093 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:54.577919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.020093 × 1013
5-th percentile2.020093 × 1013
Q12.020093 × 1013
median2.020093 × 1013
Q32.020093 × 1013
95-th percentile2.020093 × 1013
Maximum2.020093 × 1013
Range14921
Interquartile range (IQR)2626

Descriptive statistics

Standard deviation3713.4156
Coefficient of variation (CV)1.8382399 × 10-10
Kurtosis2.8959927
Mean2.020093 × 1013
Median Absolute Deviation (MAD)63.5
Skewness-2.0889454
Sum2.020093 × 1015
Variance13789455
MonotonicityDecreasing
2023-12-10T18:39:54.817639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
20200930230305 7
 
7.0%
20200930230307 7
 
7.0%
20200930232921 4
 
4.0%
20200930232930 4
 
4.0%
20200930232856 4
 
4.0%
20200930232857 4
 
4.0%
20200930232858 4
 
4.0%
20200930232859 4
 
4.0%
20200930232919 4
 
4.0%
20200930232924 4
 
4.0%
Other values (30) 54
54.0%
ValueCountFrequency (%)
20200930220520 1
1.0%
20200930221001 1
1.0%
20200930221205 1
1.0%
20200930221419 1
1.0%
20200930221834 1
1.0%
20200930221835 1
1.0%
20200930221837 1
1.0%
20200930221840 1
1.0%
20200930221841 1
1.0%
20200930222106 1
1.0%
ValueCountFrequency (%)
20200930235441 1
1.0%
20200930233551 1
1.0%
20200930233548 1
1.0%
20200930233546 1
1.0%
20200930233543 1
1.0%
20200930233540 1
1.0%
20200930233530 1
1.0%
20200930233527 1
1.0%
20200930233525 1
1.0%
20200930233522 1
1.0%

CRTFC_FLAG_NM
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
쿠폰발급
45 
사용
42 
적립
13 

Length

Max length4
Median length2
Mean length2.9
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row적립
2nd row쿠폰발급
3rd row쿠폰발급
4th row쿠폰발급
5th row쿠폰발급

Common Values

ValueCountFrequency (%)
쿠폰발급 45
45.0%
사용 42
42.0%
적립 13
 
13.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:55.360088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
쿠폰발급 45
45.0%
사용 42
42.0%
적립 13
 
13.0%

CRTFC_STR_NM
Categorical

IMBALANCE 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
叶子与茶（香园街店）
86 
金葫芦凉茶
9 
蜀大侠
 
1
茶百道（杭州福雷德店）
 
1
台萃鲜茶（香香鸡店）
 
1
Other values (2)
 
2

Length

Max length15
Median length10
Mean length9.55
Min length3

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st row蜀大侠
2nd row金葫芦凉茶
3rd row金葫芦凉茶
4th row金葫芦凉茶
5th row金葫芦凉茶

Common Values

ValueCountFrequency (%)
叶子与茶（香园街店） 86
86.0%
金葫芦凉茶 9
 
9.0%
蜀大侠 1
 
1.0%
茶百道（杭州福雷德店） 1
 
1.0%
台萃鲜茶（香香鸡店） 1
 
1.0%
茶百道（北京石油大学） 1
 
1.0%
茶百道（长沙市火车站地铁2号） 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:55.816455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
叶子与茶（香园街店） 86
86.0%
金葫芦凉茶 9
 
9.0%
蜀大侠 1
 
1.0%
茶百道（杭州福雷德店） 1
 
1.0%
台萃鲜茶（香香鸡店） 1
 
1.0%
茶百道（北京石油大学） 1
 
1.0%
茶百道（长沙市火车站地铁2号） 1
 
1.0%

CRTFC_STR_ADDR
Categorical

IMBALANCE 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
江苏省泰州市迎宾西路
86 
潮州池湖路池湖市场对面
9 
蜀大侠
 
1
杭州市江干区文泽路99号白杨街道贤德巷31号茶百道
 
1
香香鸡店
 
1
Other values (2)
 
2

Length

Max length25
Median length10
Mean length10.34
Min length3

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st row蜀大侠
2nd row潮州池湖路池湖市场对面
3rd row潮州池湖路池湖市场对面
4th row潮州池湖路池湖市场对面
5th row潮州池湖路池湖市场对面

Common Values

ValueCountFrequency (%)
江苏省泰州市迎宾西路 86
86.0%
潮州池湖路池湖市场对面 9
 
9.0%
蜀大侠 1
 
1.0%
杭州市江干区文泽路99号白杨街道贤德巷31号茶百道 1
 
1.0%
香香鸡店 1
 
1.0%
北京市昌平区燕平路东关商贸楼2号（小溪美发南侧） 1
 
1.0%
湖南省长沙市火车站地铁2号出入口茶百道 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:56.439896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
江苏省泰州市迎宾西路 86
86.0%
潮州池湖路池湖市场对面 9
 
9.0%
蜀大侠 1
 
1.0%
杭州市江干区文泽路99号白杨街道贤德巷31号茶百道 1
 
1.0%
香香鸡店 1
 
1.0%
北京市昌平区燕平路东关商贸楼2号（小溪美发南侧） 1
 
1.0%
湖南省长沙市火车站地铁2号出入口茶百道 1
 
1.0%

COUPON_NM
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
任意饮品一杯
78 
<NA>
13 
赠品券
9 

Length

Max length6
Median length6
Mean length5.47
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row赠品券
3rd row赠品券
4th row赠品券
5th row赠品券

Common Values

ValueCountFrequency (%)
任意饮品一杯 78
78.0%
<NA> 13
 
13.0%
赠品券 9
 
9.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:56.982176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
任意饮品一杯 78
78.0%
na 13
 
13.0%
赠品券 9
 
9.0%

COUPON_ID
Categorical

Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
8a58e7c71b8648c8aa1dd65ff5824cfb
16 
499599d4f1304baeae844d9790a59f77
16 
220d9765e3d0436397e38002686dde8e
16 
b4ef871aaafa4f78bc408899e096f186
16 
쿠폰미발급
13 
Other values (8)
23 

Length

Max length32
Median length32
Mean length28.49
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row쿠폰미발급
2nd rowa26f074af25b4a0991b2cee102cda9dd
3rd rowa26f074af25b4a0991b2cee102cda9dd
4th rowa26f074af25b4a0991b2cee102cda9dd
5th rowa26f074af25b4a0991b2cee102cda9dd

Common Values

ValueCountFrequency (%)
8a58e7c71b8648c8aa1dd65ff5824cfb 16
16.0%
499599d4f1304baeae844d9790a59f77 16
16.0%
220d9765e3d0436397e38002686dde8e 16
16.0%
b4ef871aaafa4f78bc408899e096f186 16
16.0%
쿠폰미발급 13
13.0%
a26f074af25b4a0991b2cee102cda9dd 9
9.0%
49df8a5b17cf48e8ae88934a11909c6b 2
 
2.0%
7ffcbebea7034f358b34736f15b9a6d6 2
 
2.0%
3d0f8e79ce9e47978a2b18c12dcb31dd 2
 
2.0%
26559110fcd14bb4a4c925f181742498 2
 
2.0%
Other values (3) 6
 
6.0%

Length

2023-12-10T18:39:57.155151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
8a58e7c71b8648c8aa1dd65ff5824cfb 16
16.0%
499599d4f1304baeae844d9790a59f77 16
16.0%
220d9765e3d0436397e38002686dde8e 16
16.0%
b4ef871aaafa4f78bc408899e096f186 16
16.0%
쿠폰미발급 13
13.0%
a26f074af25b4a0991b2cee102cda9dd 9
9.0%
49df8a5b17cf48e8ae88934a11909c6b 2
 
2.0%
7ffcbebea7034f358b34736f15b9a6d6 2
 
2.0%
3d0f8e79ce9e47978a2b18c12dcb31dd 2
 
2.0%
26559110fcd14bb4a4c925f181742498 2
 
2.0%
Other values (3) 6
 
6.0%

COUPON_USGSTT_NM
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
발급
45 
사용
42 
<NA>
13 

Length

Max length4
Median length2
Mean length2.26
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row발급
3rd row발급
4th row발급
5th row발급

Common Values

ValueCountFrequency (%)
발급 45
45.0%
사용 42
42.0%
<NA> 13
 
13.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:57.592881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발급 45
45.0%
사용 42
42.0%
na 13
 
13.0%

COUPON_USE_DT
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)16.7%
Missing58
Missing (%)58.0%
Infinite0
Infinite (%)0.0%
Mean2.0200675 × 1013
Minimum2.0200417 × 1013
Maximum2.0200919 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:57.781649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0200417 × 1013
5-th percentile2.0200417 × 1013
Q12.0200417 × 1013
median2.0200808 × 1013
Q32.0200808 × 1013
95-th percentile2.0200919 × 1013
Maximum2.0200919 × 1013
Range5.0196766 × 108
Interquartile range (IQR)3.9093978 × 108

Descriptive statistics

Standard deviation2.0974913 × 108
Coefficient of variation (CV)1.0383273 × 10-5
Kurtosis-1.7537332
Mean2.0200675 × 1013
Median Absolute Deviation (MAD)97988977
Skewness-0.35777313
Sum8.4842835 × 1014
Variance4.3994697 × 1016
MonotonicityNot monotonic
2023-12-10T18:39:58.021695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20200808162726 16
 
16.0%
20200417222945 16
 
16.0%
20200919190601 2
 
2.0%
20200906151703 2
 
2.0%
20200723172701 2
 
2.0%
20200919190558 2
 
2.0%
20200906151657 2
 
2.0%
(Missing) 58
58.0%
ValueCountFrequency (%)
20200417222945 16
16.0%
20200723172701 2
 
2.0%
20200808162726 16
16.0%
20200906151657 2
 
2.0%
20200906151703 2
 
2.0%
20200919190558 2
 
2.0%
20200919190601 2
 
2.0%
ValueCountFrequency (%)
20200919190601 2
 
2.0%
20200919190558 2
 
2.0%
20200906151703 2
 
2.0%
20200906151657 2
 
2.0%
20200808162726 16
16.0%
20200723172701 2
 
2.0%
20200417222945 16
16.0%

COUPON_USE_STR_NM
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
58 
叶子与茶（香园街店）
42 

Length

Max length10
Median length4
Mean length6.52
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 58
58.0%
叶子与茶（香园街店） 42
42.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:58.380924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 58
58.0%
叶子与茶（香园街店） 42
42.0%

COUPON_USE_STR_ADDR
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
58 
江苏省泰州市迎宾西路
42 

Length

Max length10
Median length4
Mean length6.52
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 58
58.0%
江苏省泰州市迎宾西路 42
42.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:58.726481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 58
58.0%
江苏省泰州市迎宾西路 42
42.0%

COUPON_BNEF_CN
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
累计集章10个可享
78 
<NA>
13 
集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。
9 

Length

Max length25
Median length9
Mean length9.79
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。
3rd row集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。
4th row集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。
5th row集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。

Common Values

ValueCountFrequency (%)
累计集章10个可享 78
78.0%
<NA> 13
 
13.0%
集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。 9
 
9.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:59.080389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
累计集章10个可享 78
78.0%
na 13
 
13.0%
集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。 9
 
9.0%

CLUSTR_ID
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
99 
1
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 99
99.0%
1 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:59.392991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 99
99.0%
1 1
 
1.0%

ESNTL_ID
Categorical

IMBALANCE 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
V00A020B092S0022FSC003
86 
V00A034B009S0035FSC001
9 
V00A015B270S0016FSC001
 
1
V00A020B007S0022FSC037
 
1
V00A020B105S0022FSC001
 
1
Other values (2)
 
2

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique5 ?
Unique (%)5.0%

Sample

1st rowV00A015B270S0016FSC001
2nd rowV00A034B009S0035FSC001
3rd rowV00A034B009S0035FSC001
4th rowV00A034B009S0035FSC001
5th rowV00A034B009S0035FSC001

Common Values

ValueCountFrequency (%)
V00A020B092S0022FSC003 86
86.0%
V00A034B009S0035FSC001 9
 
9.0%
V00A015B270S0016FSC001 1
 
1.0%
V00A020B007S0022FSC037 1
 
1.0%
V00A020B105S0022FSC001 1
 
1.0%
V00A020B007S0022FSC038 1
 
1.0%
V00A020B007S0022FSC044 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:59.769384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
v00a020b092s0022fsc003 86
86.0%
v00a034b009s0035fsc001 9
 
9.0%
v00a015b270s0016fsc001 1
 
1.0%
v00a020b007s0022fsc037 1
 
1.0%
v00a020b105s0022fsc001 1
 
1.0%
v00a020b007s0022fsc038 1
 
1.0%
v00a020b007s0022fsc044 1
 
1.0%

Sample

SEQ_NOPROMTN_TY_CDPROMTN_TY_NMPROMTN_NMPROMTN_BNEF_CNBRAND_NMCSTMR_IDTRMNL_MODL_NMTRMNL_MODL_OPERSYSM_TY_CDTRMNL_MODL_OPERSYSM_TY_NMCRTFC_DTCRTFC_FLAG_NMCRTFC_STR_NMCRTFC_STR_ADDRCOUPON_NMCOUPON_IDCOUPON_USGSTT_NMCOUPON_USE_DTCOUPON_USE_STR_NMCOUPON_USE_STR_ADDRCOUPON_BNEF_CNCLUSTR_IDESNTL_ID
0115중국보상프로모션참여고객성향.折前消费满258元即可集章一次 集章2个，兑换50元无门槛涮菜券 集章5个，兑换58元锅底代金券 集章10个，兑换迪奥口红一只蜀大侠火锅otw4q0s26fhcsBaS0Hid4aQunXjk<NA>단말모델미분류<NA>20200930235441적립蜀大侠蜀大侠<NA>쿠폰미발급<NA><NA><NA><NA><NA>1V00A015B270S0016FSC001
1215중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233551쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
2315중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233548쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
3415중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233546쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
4515중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233543쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
5615중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233540쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
6715중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233530쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
7815중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233527쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
8915중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233525쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
91015중국보상프로모션참여고객성향.集满10枚印章即可免费兑换1瓶凉茶金葫芦凉茶oxGQgxIpnaAelhAWwAYa0xC1R2Kc<NA>단말모델미분류<NA>20200930233522쿠폰발급金葫芦凉茶潮州池湖路池湖市场对面赠品券a26f074af25b4a0991b2cee102cda9dd발급<NA><NA><NA>集满10枚印章，即可免费兑换店内任一品种凉茶1瓶。0V00A034B009S0035FSC001
SEQ_NOPROMTN_TY_CDPROMTN_TY_NMPROMTN_NMPROMTN_BNEF_CNBRAND_NMCSTMR_IDTRMNL_MODL_NMTRMNL_MODL_OPERSYSM_TY_CDTRMNL_MODL_OPERSYSM_TY_NMCRTFC_DTCRTFC_FLAG_NMCRTFC_STR_NMCRTFC_STR_ADDRCOUPON_NMCOUPON_IDCOUPON_USGSTT_NMCOUPON_USE_DTCOUPON_USE_STR_NMCOUPON_USE_STR_ADDRCOUPON_BNEF_CNCLUSTR_IDESNTL_ID
909115중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxMdRhOLH_HdgJCRD0zVgFaI<NA>단말모델미분류<NA>20200930222106적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
919215중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxKS_b2zTLpyCcUgx7YnOzdE<NA>단말모델미분류<NA>20200930221841적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
929315중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxKS_b2zTLpyCcUgx7YnOzdE<NA>단말모델미분류<NA>20200930221840적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
939415중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxKS_b2zTLpyCcUgx7YnOzdE<NA>단말모델미분류<NA>20200930221837적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
949515중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxKS_b2zTLpyCcUgx7YnOzdE<NA>단말모델미분류<NA>20200930221835적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
959615중국보상프로모션참여고객성향叶子与茶(泰州香园街店）累计集章满10个送任意饮品一杯葉子与茶oxGQgxKS_b2zTLpyCcUgx7YnOzdE<NA>단말모델미분류<NA>20200930221834적립叶子与茶（香园街店）江苏省泰州市迎宾西路<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B092S0022FSC003
969715중국보상프로모션참여고객성향盖盖章，饮品免费拿Q每消费一杯盖一个章，集满7个章,兑换10元代金劵一张；集满14个章,兑换10元代金劵一张；茶百道oxGQgxEOtPprGQqRKWx0ON5Oly8E<NA>단말모델미분류<NA>20200930221419적립茶百道（杭州福雷德店）杭州市江干区文泽路99号白杨街道贤德巷31号茶百道<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B007S0022FSC037
979815중국보상프로모션참여고객성향台萃集章卡累计6枚印章可免费获得饮品券台萃oxGQgxD1sdDhTuua04YCkXdvmuOQ<NA>단말모델미분류<NA>20200930221205적립台萃鲜茶（香香鸡店）香香鸡店<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B105S0022FSC001
989915중국보상프로모션참여고객성향盖盖章，饮品免费拿V每消费一杯盖一个章，集满8个章，兑换10元代金券1张；集满15个章，兑换10元代金券1张；茶百道oxGQgxFrKCUmMgNUuyhubIZ0qX9E<NA>단말모델미분류<NA>20200930221001적립茶百道（北京石油大学）北京市昌平区燕平路东关商贸楼2号（小溪美发南侧）<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B007S0022FSC038
9910015중국보상프로모션참여고객성향盖盖章，饮品免费拿!!!满15元盖一个章，集满5个章送10元代金券一张！茶百道oxGQgxN1CTS7yf6WGybfGt6p-20o<NA>단말모델미분류<NA>20200930220520적립茶百道（长沙市火车站地铁2号）湖南省长沙市火车站地铁2号出入口茶百道<NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A020B007S0022FSC044