Dataset statistics
Number of variables | 23 |
---|---|
Number of observations | 100 |
Missing cells | 394 |
Missing cells (%) | 17.1% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 18.8 KiB |
Average record size in memory | 192.3 B |
Variable types
Numeric | 2 |
---|---|
Categorical | 16 |
Unsupported | 2 |
Text | 3 |
Dataset
Description | Sample |
---|---|
Author | 원투씨엠 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=baaeda90-3e96-11eb-af9a-4b03f0a582d6 |
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 (79.3%) | Imbalance |
PROMTN_BNEF_CN is highly imbalanced (79.3%) | Imbalance |
BRAND_NM is highly imbalanced (75.9%) | Imbalance |
CRTFC_FLAG_NM is highly imbalanced (72.1%) | Imbalance |
CRTFC_STR_NM is highly imbalanced (79.3%) | Imbalance |
CRTFC_STR_ADDR is highly imbalanced (79.3%) | Imbalance |
COUPON_USGSTT_NM is highly imbalanced (67.2%) | Imbalance |
COUPON_USE_DT is highly imbalanced (87.9%) | Imbalance |
ESNTL_ID is highly imbalanced (79.3%) | Imbalance |
TRMNL_MODL_NM has 100 (100.0%) missing values | Missing |
TRMNL_MODL_OPERSYSM_TY_NM has 100 (100.0%) missing values | Missing |
COUPON_USE_STR_NM has 97 (97.0%) missing values | Missing |
COUPON_USE_STR_ADDR has 97 (97.0%) missing values | Missing |
SEQ_NO has unique values | Unique |
TRMNL_MODL_NM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TRMNL_MODL_OPERSYSM_TY_NM is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2023-12-10 09:40:32.972181 |
---|---|
Analysis finished | 2023-12-10 09:40:33.471554 |
Duration | 0.5 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 50.5 |
Minimum | 1 |
---|---|
Maximum | 100 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 5.95 |
Q1 | 25.75 |
median | 50.5 |
Q3 | 75.25 |
95-th percentile | 95.05 |
Maximum | 100 |
Range | 99 |
Interquartile range (IQR) | 49.5 |
Descriptive statistics
Standard deviation | 29.011492 |
---|---|
Coefficient of variation (CV) | 0.57448499 |
Kurtosis | -1.2 |
Mean | 50.5 |
Median Absolute Deviation (MAD) | 25 |
Skewness | 0 |
Sum | 5050 |
Variance | 841.66667 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
1 | 1 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 1 | |
6 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
10 | 1 |
Value | Count | Frequency (%) |
100 | 1 | |
99 | 1 | |
98 | 1 | |
97 | 1 | |
96 | 1 | |
95 | 1 | |
94 | 1 | |
93 | 1 | |
92 | 1 | |
91 | 1 |
PROMTN_TY_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
11 |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 11 |
---|---|
2nd row | 11 |
3rd row | 11 |
4th row | 11 |
5th row | 11 |
Common Values
Value | Count | Frequency (%) |
11 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
11 | 100 |
PROMTN_TY_NM
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
중국적립프로모션참여고객성향 |
---|
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 14 |
Min length | 14 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 중국적립프로모션참여고객성향 |
---|---|
2nd row | 중국적립프로모션참여고객성향 |
3rd row | 중국적립프로모션참여고객성향 |
4th row | 중국적립프로모션참여고객성향 |
5th row | 중국적립프로모션참여고객성향 |
Common Values
Value | Count | Frequency (%) |
중국적립프로모션참여고객성향 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
중국적립프로모션참여고객성향 | 100 |
PROMTN_NM
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
江边城.巫山烤鱼 | |
---|---|
盖盖章,饮品免费拿!! | 3 |
虾米铺子 | 2 |
盖盖章,饮品免费拿** | 1 |
Length
Max length | 11 |
---|---|
Median length | 8 |
Mean length | 8.04 |
Min length | 4 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 虾米铺子 |
---|---|
2nd row | 盖盖章,饮品免费拿!! |
3rd row | 盖盖章,饮品免费拿!! |
4th row | 盖盖章,饮品免费拿!! |
5th row | 虾米铺子 |
Common Values
Value | Count | Frequency (%) |
江边城.巫山烤鱼 | 94 | |
盖盖章,饮品免费拿!! | 3 | 3.0% |
虾米铺子 | 2 | 2.0% |
盖盖章,饮品免费拿** | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
江边城.巫山烤鱼 | 94 | |
盖盖章,饮品免费拿!! | 3 | 3.0% |
虾米铺子 | 2 | 2.0% |
盖盖章,饮品免费拿 | 1 | 1.0% |
PROMTN_BNEF_CN
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | |
---|---|
订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! | 3 |
消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 | 2 |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 1 |
Length
Max length | 114 |
---|---|
Median length | 109 |
Mean length | 107.12 |
Min length | 54 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 |
---|---|
2nd row | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! |
3rd row | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! |
4th row | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! |
5th row | 消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 |
Common Values
Value | Count | Frequency (%) |
集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 94 | |
订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! | 3 | 3.0% |
消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 | 2 | 2.0% |
订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; | 94 | |
集齐3枚鱼章,即赠江边城【黄金虾饼】1份; | 94 | |
集齐4枚鱼章,即赠特色【香辣滋味虾】1份; | 94 | |
集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 94 | |
集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; | 94 | |
盖1次 | 4 | 0.8% |
盖3次 | 4 | 0.8% |
订单每消费1杯可盖一个章, | 3 | 0.6% |
集齐7个印章可兑换1张10元饮品优惠券, | 3 | 0.6% |
集齐14个印章可兑换1张20元优惠券! | 3 | 0.6% |
Other values (11) | 18 | 3.6% |
BRAND_NM
Categorical
IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
山西誉顺和餐饮管理合伙企业(有限合伙) | |
---|---|
茶百道 | 4 |
虾米铺子 | 2 |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 18.06 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 虾米铺子 |
---|---|
2nd row | 茶百道 |
3rd row | 茶百道 |
4th row | 茶百道 |
5th row | 虾米铺子 |
Common Values
Value | Count | Frequency (%) |
山西誉顺和餐饮管理合伙企业(有限合伙) | 94 | |
茶百道 | 4 | 4.0% |
虾米铺子 | 2 | 2.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
山西誉顺和餐饮管理合伙企业(有限合伙) | 94 | |
茶百道 | 4 | 4.0% |
虾米铺子 | 2 | 2.0% |
CSTMR_ID
Categorical
Distinct | 11 |
---|---|
Distinct (%) | 11.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
o1yVS1tub92Uw0Qjk80lGPMavJRQ | |
---|---|
o1yVS1nmoMrKCRwXEuMe76up61Jo | |
o1yVS1pnh7EDceP4hMrVru6wEubw | |
o1yVS1gNoWr-Sku8Cccg_i_wQNIk | |
o1yVS1u5_cOa_jaJlXY_6upG8zIM | |
Other values (6) |
Length
Max length | 28 |
---|---|
Median length | 28 |
Mean length | 28 |
Min length | 28 |
Unique
Unique | 4 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | ogUVLwg3dGzmtdAJuq_0q6hSDgNw |
---|---|
2nd row | oxGQgxFio9RJCy0AvV5uyMg30uII |
3rd row | oxGQgxAuRjNyDA8P1MafRgacQJbs |
4th row | oxGQgxAuRjNyDA8P1MafRgacQJbs |
5th row | ogUVLwpQIYC3seAqCHLI8_w3jr2g |
Common Values
Value | Count | Frequency (%) |
o1yVS1tub92Uw0Qjk80lGPMavJRQ | 35 | |
o1yVS1nmoMrKCRwXEuMe76up61Jo | 19 | |
o1yVS1pnh7EDceP4hMrVru6wEubw | 17 | |
o1yVS1gNoWr-Sku8Cccg_i_wQNIk | 12 | 12.0% |
o1yVS1u5_cOa_jaJlXY_6upG8zIM | 7 | 7.0% |
o1yVS1jowqP6jZlMyFReCXBrCp6w | 4 | 4.0% |
oxGQgxAuRjNyDA8P1MafRgacQJbs | 2 | 2.0% |
ogUVLwg3dGzmtdAJuq_0q6hSDgNw | 1 | 1.0% |
oxGQgxFio9RJCy0AvV5uyMg30uII | 1 | 1.0% |
ogUVLwpQIYC3seAqCHLI8_w3jr2g | 1 | 1.0% |
Length
Value | Count | Frequency (%) |
o1yvs1tub92uw0qjk80lgpmavjrq | 35 | |
o1yvs1nmomrkcrwxeume76up61jo | 19 | |
o1yvs1pnh7edcep4hmrvru6weubw | 17 | |
o1yvs1gnowr-sku8cccg_i_wqnik | 12 | 12.0% |
o1yvs1u5_coa_jajlxy_6upg8zim | 7 | 7.0% |
o1yvs1jowqp6jzlmyfrecxbrcp6w | 4 | 4.0% |
oxgqgxaurjnyda8p1mafrgacqjbs | 2 | 2.0% |
oguvlwg3dgzmtdajuq_0q6hsdgnw | 1 | 1.0% |
oxgqgxfio9rjcy0avv5uymg30uii | 1 | 1.0% |
oguvlwpqiyc3seaqchli8_w3jr2g | 1 | 1.0% |
TRMNL_MODL_NM
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 100 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.0 KiB |
TRMNL_MODL_OPERSYSM_TY_CD
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
단말모델미분류 |
---|
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 단말모델미분류 |
---|---|
2nd row | 단말모델미분류 |
3rd row | 단말모델미분류 |
4th row | 단말모델미분류 |
5th row | 단말모델미분류 |
Common Values
Value | Count | Frequency (%) |
단말모델미분류 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
단말모델미분류 | 100 |
TRMNL_MODL_OPERSYSM_TY_NM
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 100 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.0 KiB |
CRTFC_DT
Real number (ℝ)
Distinct | 12 |
---|---|
Distinct (%) | 12.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.020093 × 1013 |
Minimum | 2.020093 × 1013 |
---|---|
Maximum | 2.020093 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2.020093 × 1013 |
---|---|
5-th percentile | 2.020093 × 1013 |
Q1 | 2.020093 × 1013 |
median | 2.020093 × 1013 |
Q3 | 2.020093 × 1013 |
95-th percentile | 2.020093 × 1013 |
Maximum | 2.020093 × 1013 |
Range | 11007 |
Interquartile range (IQR) | 217.25 |
Descriptive statistics
Standard deviation | 1798.0521 |
---|---|
Coefficient of variation (CV) | 8.9008382 × 10-11 |
Kurtosis | 23.061522 |
Mean | 2.020093 × 1013 |
Median Absolute Deviation (MAD) | 104 |
Skewness | 4.8958528 |
Sum | 2.020093 × 1015 |
Variance | 3232991.4 |
Monotonicity | Decreasing |
Value | Count | Frequency (%) |
20200930224325 | 35 | |
20200930224555 | 19 | |
20200930224429 | 17 | |
20200930224446 | 12 | 12.0% |
20200930224538 | 7 | 7.0% |
20200930224305 | 4 | 4.0% |
20200930235312 | 1 | 1.0% |
20200930233848 | 1 | 1.0% |
20200930232330 | 1 | 1.0% |
20200930232327 | 1 | 1.0% |
Other values (2) | 2 | 2.0% |
Value | Count | Frequency (%) |
20200930224305 | 4 | 4.0% |
20200930224325 | 35 | |
20200930224429 | 17 | |
20200930224446 | 12 | 12.0% |
20200930224538 | 7 | 7.0% |
20200930224555 | 19 | |
20200930224716 | 1 | 1.0% |
20200930224718 | 1 | 1.0% |
20200930232327 | 1 | 1.0% |
20200930232330 | 1 | 1.0% |
Value | Count | Frequency (%) |
20200930235312 | 1 | 1.0% |
20200930233848 | 1 | 1.0% |
20200930232330 | 1 | 1.0% |
20200930232327 | 1 | 1.0% |
20200930224718 | 1 | 1.0% |
20200930224716 | 1 | 1.0% |
20200930224555 | 19 | |
20200930224538 | 7 | 7.0% |
20200930224446 | 12 | |
20200930224429 | 17 |
CRTFC_FLAG_NM
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
쿠폰발급 | |
---|---|
적립 | 5 |
사용 | 3 |
<NA> | 1 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 3.84 |
Min length | 2 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 적립 |
---|---|
2nd row | 적립 |
3rd row | 적립 |
4th row | 적립 |
5th row | 적립 |
Common Values
Value | Count | Frequency (%) |
쿠폰발급 | 91 | |
적립 | 5 | 5.0% |
사용 | 3 | 3.0% |
<NA> | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
쿠폰발급 | 91 | |
적립 | 5 | 5.0% |
사용 | 3 | 3.0% |
na | 1 | 1.0% |
CRTFC_STR_NM
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
江边城.巫山烤鱼【长风街店】 | |
---|---|
茶百道(龙泉市尊龙茶) | 3 |
虾米铺子 | 2 |
茶百道(铜仁蓝波湾店) | 1 |
Length
Max length | 14 |
---|---|
Median length | 14 |
Mean length | 13.68 |
Min length | 4 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 虾米铺子 |
---|---|
2nd row | 茶百道(龙泉市尊龙茶) |
3rd row | 茶百道(龙泉市尊龙茶) |
4th row | 茶百道(龙泉市尊龙茶) |
5th row | 虾米铺子 |
Common Values
Value | Count | Frequency (%) |
江边城.巫山烤鱼【长风街店】 | 94 | |
茶百道(龙泉市尊龙茶) | 3 | 3.0% |
虾米铺子 | 2 | 2.0% |
茶百道(铜仁蓝波湾店) | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
江边城.巫山烤鱼【长风街店】 | 94 | |
茶百道(龙泉市尊龙茶) | 3 | 3.0% |
虾米铺子 | 2 | 2.0% |
茶百道(铜仁蓝波湾店 | 1 | 1.0% |
CRTFC_STR_ADDR
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
山西省太原市梅园百盛二部对面过街天桥南 | |
---|---|
浙江省龙泉市尊龙茶百道奶茶店 | 3 |
建邺区莫愁湖水西门 | 2 |
贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号 | 1 |
Length
Max length | 26 |
---|---|
Median length | 19 |
Mean length | 18.72 |
Min length | 9 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | 建邺区莫愁湖水西门 |
---|---|
2nd row | 浙江省龙泉市尊龙茶百道奶茶店 |
3rd row | 浙江省龙泉市尊龙茶百道奶茶店 |
4th row | 浙江省龙泉市尊龙茶百道奶茶店 |
5th row | 建邺区莫愁湖水西门 |
Common Values
Value | Count | Frequency (%) |
山西省太原市梅园百盛二部对面过街天桥南 | 94 | |
浙江省龙泉市尊龙茶百道奶茶店 | 3 | 3.0% |
建邺区莫愁湖水西门 | 2 | 2.0% |
贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
山西省太原市梅园百盛二部对面过街天桥南 | 94 | |
浙江省龙泉市尊龙茶百道奶茶店 | 3 | 3.0% |
建邺区莫愁湖水西门 | 2 | 2.0% |
贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号 | 1 | 1.0% |
COUPON_NM
Categorical
Distinct | 7 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
柴鱼花皮蛋豆腐 | |
---|---|
蜂蜜柚子茶 | |
黄金虾饼 | |
香辣滋味虾 | |
果木炭烤活鱼一份 | |
Other values (2) |
Length
Max length | 13 |
---|---|
Median length | 8 |
Mean length | 5.74 |
Min length | 4 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
柴鱼花皮蛋豆腐 | 21 | |
蜂蜜柚子茶 | 20 | |
黄金虾饼 | 19 | |
香辣滋味虾 | 18 | |
果木炭烤活鱼一份 | 16 | |
<NA> | 5 | 5.0% |
恭喜你获得一张10元代金券 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
柴鱼花皮蛋豆腐 | 21 | |
蜂蜜柚子茶 | 20 | |
黄金虾饼 | 19 | |
香辣滋味虾 | 18 | |
果木炭烤活鱼一份 | 16 | |
na | 5 | 5.0% |
恭喜你获得一张10元代金券 | 1 | 1.0% |
COUPON_ID
Text
Distinct | 96 |
---|---|
Distinct (%) | 96.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
Value | Count | Frequency (%) |
쿠폰미발급 | 5 | 5.0% |
b8fea6b52bfe45e8bf5bae22851c28b0 | 1 | 1.0% |
613f6aa56fc34def8025e8888317d371 | 1 | 1.0% |
23e1745e1bb84f83bb46d557e1c465e9 | 1 | 1.0% |
8bda377692754105b62921ec982abaa1 | 1 | 1.0% |
75da06ccdea747c7a84baf4351949679 | 1 | 1.0% |
c0e9b0b223c44e4ea47ba3d74437ade4 | 1 | 1.0% |
bb088ba58cf04a8185e65ba43a8d4d18 | 1 | 1.0% |
e39f7726b8a84afcba43803bc89acd30 | 1 | 1.0% |
e8e7e7ea626b475dbf5c1a8f9a3b4ac6 | 1 | 1.0% |
Other values (86) | 86 |
Most occurring characters
Value | Count | Frequency (%) |
4 | 285 | 9.3% |
8 | 207 | 6.8% |
b | 203 | 6.6% |
a | 202 | 6.6% |
e | 201 | 6.6% |
2 | 200 | 6.5% |
5 | 194 | 6.3% |
9 | 190 | 6.2% |
f | 180 | 5.9% |
6 | 177 | 5.8% |
Other values (11) | 1026 |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 1918 | |
Lowercase Letter | 1122 | |
Other Letter | 25 | 0.8% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
4 | 285 | |
8 | 207 | |
2 | 200 | |
5 | 194 | |
9 | 190 | |
6 | 177 | |
1 | 175 | |
7 | 172 | |
3 | 168 | |
0 | 150 |
Lowercase Letter
Value | Count | Frequency (%) |
b | 203 | |
a | 202 | |
e | 201 | |
f | 180 | |
d | 171 | |
c | 165 |
Other Letter
Value | Count | Frequency (%) |
폰 | 5 | |
급 | 5 | |
발 | 5 | |
미 | 5 | |
쿠 | 5 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 1918 | |
Latin | 1122 | |
Hangul | 25 | 0.8% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
4 | 285 | |
8 | 207 | |
2 | 200 | |
5 | 194 | |
9 | 190 | |
6 | 177 | |
1 | 175 | |
7 | 172 | |
3 | 168 | |
0 | 150 |
Latin
Value | Count | Frequency (%) |
b | 203 | |
a | 202 | |
e | 201 | |
f | 180 | |
d | 171 | |
c | 165 |
Hangul
Value | Count | Frequency (%) |
폰 | 5 | |
급 | 5 | |
발 | 5 | |
미 | 5 | |
쿠 | 5 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3040 | |
Hangul | 25 | 0.8% |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
4 | 285 | 9.4% |
8 | 207 | 6.8% |
b | 203 | 6.7% |
a | 202 | 6.6% |
e | 201 | 6.6% |
2 | 200 | 6.6% |
5 | 194 | 6.4% |
9 | 190 | 6.2% |
f | 180 | 5.9% |
6 | 177 | 5.8% |
Other values (6) | 1001 |
Hangul
Value | Count | Frequency (%) |
폰 | 5 | |
급 | 5 | |
발 | 5 | |
미 | 5 | |
쿠 | 5 |
COUPON_USGSTT_NM
Categorical
IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
발급 | |
---|---|
<NA> | 6 |
사용 | 3 |
Length
Max length | 4 |
---|---|
Median length | 2 |
Mean length | 2.12 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
발급 | 91 | |
<NA> | 6 | 6.0% |
사용 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
발급 | 91 | |
na | 6 | 6.0% |
사용 | 3 | 3.0% |
COUPON_USE_DT
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
<NA> | |
---|---|
20201001194313 | 1 |
20200430154136 | 1 |
20200715121116 | 1 |
Length
Max length | 14 |
---|---|
Median length | 4 |
Mean length | 4.3 |
Min length | 4 |
Unique
Unique | 3 ? |
---|---|
Unique (%) | 3.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 97 | |
20201001194313 | 1 | 1.0% |
20200430154136 | 1 | 1.0% |
20200715121116 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 97 | |
20201001194313 | 1 | 1.0% |
20200430154136 | 1 | 1.0% |
20200715121116 | 1 | 1.0% |
MISSING
 
Distinct | 2 |
---|---|
Distinct (%) | 66.7% |
Missing | 97 |
Missing (%) | 97.0% |
Memory size | 932.0 B |
Value | Count | Frequency (%) |
江边城.巫山烤鱼【长风街店】 | 2 | |
茶百道(铜仁清水大道店) | 1 |
Most occurring characters
Value | Count | Frequency (%) |
店 | 3 | 7.5% |
【 | 2 | 5.0% |
道 | 2 | 5.0% |
】 | 2 | 5.0% |
边 | 2 | 5.0% |
街 | 2 | 5.0% |
风 | 2 | 5.0% |
长 | 2 | 5.0% |
江 | 2 | 5.0% |
鱼 | 2 | 5.0% |
Other values (14) | 19 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 32 | |
Open Punctuation | 3 | 7.5% |
Close Punctuation | 3 | 7.5% |
Other Punctuation | 2 | 5.0% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
店 | 3 | 9.4% |
道 | 2 | 6.2% |
边 | 2 | 6.2% |
街 | 2 | 6.2% |
风 | 2 | 6.2% |
长 | 2 | 6.2% |
江 | 2 | 6.2% |
鱼 | 2 | 6.2% |
烤 | 2 | 6.2% |
山 | 2 | 6.2% |
Other values (9) | 11 |
Open Punctuation
Value | Count | Frequency (%) |
【 | 2 | |
( | 1 |
Close Punctuation
Value | Count | Frequency (%) |
】 | 2 | |
) | 1 |
Other Punctuation
Value | Count | Frequency (%) |
. | 2 |
Most occurring scripts
Value | Count | Frequency (%) |
Han | 32 | |
Common | 8 | 20.0% |
Most frequent character per script
Han
Value | Count | Frequency (%) |
店 | 3 | 9.4% |
道 | 2 | 6.2% |
边 | 2 | 6.2% |
街 | 2 | 6.2% |
风 | 2 | 6.2% |
长 | 2 | 6.2% |
江 | 2 | 6.2% |
鱼 | 2 | 6.2% |
烤 | 2 | 6.2% |
山 | 2 | 6.2% |
Other values (9) | 11 |
Common
Value | Count | Frequency (%) |
【 | 2 | |
】 | 2 | |
. | 2 | |
( | 1 | |
) | 1 |
Most occurring blocks
Value | Count | Frequency (%) |
CJK | 32 | |
None | 6 | 15.0% |
ASCII | 2 | 5.0% |
Most frequent character per block
CJK
Value | Count | Frequency (%) |
店 | 3 | 9.4% |
道 | 2 | 6.2% |
边 | 2 | 6.2% |
街 | 2 | 6.2% |
风 | 2 | 6.2% |
长 | 2 | 6.2% |
江 | 2 | 6.2% |
鱼 | 2 | 6.2% |
烤 | 2 | 6.2% |
山 | 2 | 6.2% |
Other values (9) | 11 |
None
Value | Count | Frequency (%) |
【 | 2 | |
】 | 2 | |
( | 1 | |
) | 1 |
ASCII
Value | Count | Frequency (%) |
. | 2 |
MISSING
 
Distinct | 2 |
---|---|
Distinct (%) | 66.7% |
Missing | 97 |
Missing (%) | 97.0% |
Memory size | 932.0 B |
Length
Max length | 31 |
---|---|
Median length | 19 |
Mean length | 23 |
Min length | 19 |
Characters and Unicode
Total characters | 69 |
---|---|
Distinct characters | 45 |
Distinct categories | 5 ? |
Distinct scripts | 2 ? |
Distinct blocks | 3 ? |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 33.3% |
Sample
1st row | 贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号门面茶百道 |
---|---|
2nd row | 山西省太原市梅园百盛二部对面过街天桥南 |
3rd row | 山西省太原市梅园百盛二部对面过街天桥南 |
Value | Count | Frequency (%) |
山西省太原市梅园百盛二部对面过街天桥南 | 2 | |
贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号门面茶百道 | 1 |
Most occurring characters
Value | Count | Frequency (%) |
省 | 3 | 4.3% |
市 | 3 | 4.3% |
百 | 3 | 4.3% |
面 | 3 | 4.3% |
山 | 2 | 2.9% |
对 | 2 | 2.9% |
西 | 2 | 2.9% |
南 | 2 | 2.9% |
桥 | 2 | 2.9% |
天 | 2 | 2.9% |
Other values (35) | 45 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 61 | |
Decimal Number | 5 | 7.2% |
Close Punctuation | 1 | 1.4% |
Open Punctuation | 1 | 1.4% |
Dash Punctuation | 1 | 1.4% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
省 | 3 | 4.9% |
市 | 3 | 4.9% |
百 | 3 | 4.9% |
面 | 3 | 4.9% |
山 | 2 | 3.3% |
对 | 2 | 3.3% |
西 | 2 | 3.3% |
南 | 2 | 3.3% |
桥 | 2 | 3.3% |
天 | 2 | 3.3% |
Other values (28) | 37 |
Decimal Number
Value | Count | Frequency (%) |
1 | 2 | |
4 | 1 | |
2 | 1 | |
3 | 1 |
Close Punctuation
Value | Count | Frequency (%) |
) | 1 |
Open Punctuation
Value | Count | Frequency (%) |
( | 1 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 1 |
Most occurring scripts
Value | Count | Frequency (%) |
Han | 61 | |
Common | 8 | 11.6% |
Most frequent character per script
Han
Value | Count | Frequency (%) |
省 | 3 | 4.9% |
市 | 3 | 4.9% |
百 | 3 | 4.9% |
面 | 3 | 4.9% |
山 | 2 | 3.3% |
对 | 2 | 3.3% |
西 | 2 | 3.3% |
南 | 2 | 3.3% |
桥 | 2 | 3.3% |
天 | 2 | 3.3% |
Other values (28) | 37 |
Common
Value | Count | Frequency (%) |
1 | 2 | |
) | 1 | |
4 | 1 | |
( | 1 | |
2 | 1 | |
- | 1 | |
3 | 1 |
Most occurring blocks
Value | Count | Frequency (%) |
CJK | 61 | |
ASCII | 6 | 8.7% |
None | 2 | 2.9% |
Most frequent character per block
CJK
Value | Count | Frequency (%) |
省 | 3 | 4.9% |
市 | 3 | 4.9% |
百 | 3 | 4.9% |
面 | 3 | 4.9% |
山 | 2 | 3.3% |
对 | 2 | 3.3% |
西 | 2 | 3.3% |
南 | 2 | 3.3% |
桥 | 2 | 3.3% |
天 | 2 | 3.3% |
Other values (28) | 37 |
ASCII
Value | Count | Frequency (%) |
1 | 2 | |
4 | 1 | |
2 | 1 | |
- | 1 | |
3 | 1 |
None
Value | Count | Frequency (%) |
) | 1 | |
( | 1 |
COUPON_BNEF_CN
Categorical
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | |
---|---|
此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | |
如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食. | |
限2.5斤以内烤鱼、不含配菜; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | |
<NA> |
Length
Max length | 65 |
---|---|
Median length | 62 |
Mean length | 54.78 |
Min length | 4 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 40 | |
此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | 20 | |
如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食. | 18 | |
限2.5斤以内烤鱼、不含配菜; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | 16 | 16.0% |
<NA> | 5 | 5.0% |
可兑换店内任意一款饮品补差价即可 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
此券不找零、不兑换现金、不开具发票; | 94 | |
不与其他优惠同享; | 94 | |
限堂食 | 94 | |
如菜品估清,可更换为其它等价菜品; | 58 | |
不可与其他优惠券叠加使用; | 54 | |
不可叠加使用; | 40 | |
限2.5斤以内烤鱼、不含配菜; | 16 | 3.5% |
na | 5 | 1.1% |
可兑换店内任意一款饮品补差价即可 | 1 | 0.2% |
CLUSTR_ID
Categorical
Distinct | 5 |
---|---|
Distinct (%) | 5.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
3 | |
---|---|
1 | |
4 | |
2 | |
5 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 2 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
3 | 35 | |
1 | 29 | |
4 | 19 | |
2 | 13 | 13.0% |
5 | 4 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
3 | 35 | |
1 | 29 | |
4 | 19 | |
2 | 13 | 13.0% |
5 | 4 | 4.0% |
ESNTL_ID
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
V00A015B128S0016FSC004 | |
---|---|
V00A020B007S0022FSC056 | 3 |
V00A034B026S0035FSC001 | 2 |
V00A020B007S0022FSC073 | 1 |
Length
Max length | 22 |
---|---|
Median length | 22 |
Mean length | 22 |
Min length | 22 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 1.0% |
Sample
1st row | V00A034B026S0035FSC001 |
---|---|
2nd row | V00A020B007S0022FSC056 |
3rd row | V00A020B007S0022FSC056 |
4th row | V00A020B007S0022FSC056 |
5th row | V00A034B026S0035FSC001 |
Common Values
Value | Count | Frequency (%) |
V00A015B128S0016FSC004 | 94 | |
V00A020B007S0022FSC056 | 3 | 3.0% |
V00A034B026S0035FSC001 | 2 | 2.0% |
V00A020B007S0022FSC073 | 1 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
v00a015b128s0016fsc004 | 94 | |
v00a020b007s0022fsc056 | 3 | 3.0% |
v00a034b026s0035fsc001 | 2 | 2.0% |
v00a020b007s0022fsc073 | 1 | 1.0% |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | PROMTN_NM | PROMTN_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | CRTFC_DT | CRTFC_FLAG_NM | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_NM | COUPON_ID | COUPON_USGSTT_NM | COUPON_USE_DT | COUPON_USE_STR_NM | COUPON_USE_STR_ADDR | COUPON_BNEF_CN | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | 11 | 중국적립프로모션참여고객성향 | 虾米铺子 | 消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 | 虾米铺子 | ogUVLwg3dGzmtdAJuq_0q6hSDgNw | <NA> | 단말모델미분류 | <NA> | 20200930235312 | 적립 | 虾米铺子 | 建邺区莫愁湖水西门 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | V00A034B026S0035FSC001 |
1 | 2 | 11 | 중국적립프로모션참여고객성향 | 盖盖章,饮品免费拿!! | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! | 茶百道 | oxGQgxFio9RJCy0AvV5uyMg30uII | <NA> | 단말모델미분류 | <NA> | 20200930233848 | 적립 | 茶百道(龙泉市尊龙茶) | 浙江省龙泉市尊龙茶百道奶茶店 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | V00A020B007S0022FSC056 |
2 | 3 | 11 | 중국적립프로모션참여고객성향 | 盖盖章,饮品免费拿!! | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! | 茶百道 | oxGQgxAuRjNyDA8P1MafRgacQJbs | <NA> | 단말모델미분류 | <NA> | 20200930232330 | 적립 | 茶百道(龙泉市尊龙茶) | 浙江省龙泉市尊龙茶百道奶茶店 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | V00A020B007S0022FSC056 |
3 | 4 | 11 | 중국적립프로모션참여고객성향 | 盖盖章,饮品免费拿!! | 订单每消费1杯可盖一个章, 集齐7个印章可兑换1张10元饮品优惠券, 集齐14个印章可兑换1张20元优惠券! | 茶百道 | oxGQgxAuRjNyDA8P1MafRgacQJbs | <NA> | 단말모델미분류 | <NA> | 20200930232327 | 적립 | 茶百道(龙泉市尊龙茶) | 浙江省龙泉市尊龙茶百道奶茶店 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | V00A020B007S0022FSC056 |
4 | 5 | 11 | 중국적립프로모션참여고객성향 | 虾米铺子 | 消费一份普通龙虾小份 盖1次 消费一份普通龙虾大份盖2次 消费一份普通龙虾超大份盖4次 消费一份精品龙虾小份 盖1次 消费两份精品龙虾小份 盖3次 消费一份精品龙虾大份 盖3次 集满10章送价值99元的特色炭火牛腩牛肚板筋锅一份 | 虾米铺子 | ogUVLwpQIYC3seAqCHLI8_w3jr2g | <NA> | 단말모델미분류 | <NA> | 20200930224718 | 적립 | 虾米铺子 | 建邺区莫愁湖水西门 | <NA> | 쿠폰미발급 | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | V00A034B026S0035FSC001 |
5 | 6 | 11 | 중국적립프로모션참여고객성향 | 盖盖章,饮品免费拿** | 订单实付每满15元可盖一个章; 集齐5个印章可兑换1张10元优惠券; 所集印章仅限本店累计,不可和其他门店通用; 优惠券有效期:从获得之日90天内有效; | 茶百道 | oxGQgxHnA2LMM7gjP9YeAEH-WpSk | <NA> | 단말모델미분류 | <NA> | 20200930224716 | 사용 | 茶百道(铜仁蓝波湾店) | 贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号 | 恭喜你获得一张10元代金券 | b8fea6b52bfe45e8bf5bae22851c28b0 | 사용 | 20201001194313 | 茶百道(铜仁清水大道店) | 贵州省铜仁市碧江区蓝波湾购物广场13栋1-2(4)号门面茶百道 | 可兑换店内任意一款饮品补差价即可 | 2 | V00A020B007S0022FSC073 |
6 | 7 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1nmoMrKCRwXEuMe76up61Jo | <NA> | 단말모델미분류 | <NA> | 20200930224555 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 柴鱼花皮蛋豆腐 | 3944a5c792074302ba59dd1991358c54 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 4 | V00A015B128S0016FSC004 |
7 | 8 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1nmoMrKCRwXEuMe76up61Jo | <NA> | 단말모델미분류 | <NA> | 20200930224555 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | 770ddeb9e6d944ee81b40732a18159e2 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 4 | V00A015B128S0016FSC004 |
8 | 9 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1nmoMrKCRwXEuMe76up61Jo | <NA> | 단말모델미분류 | <NA> | 20200930224555 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 柴鱼花皮蛋豆腐 | c689ef08406a490695cb2d926628f6f7 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 4 | V00A015B128S0016FSC004 |
9 | 10 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1nmoMrKCRwXEuMe76up61Jo | <NA> | 단말모델미분류 | <NA> | 20200930224555 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 果木炭烤活鱼一份 | c4f40ae349954004b46a71ceaa265f00 | 발급 | <NA> | <NA> | <NA> | 限2.5斤以内烤鱼、不含配菜; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | 4 | V00A015B128S0016FSC004 |
SEQ_NO | PROMTN_TY_CD | PROMTN_TY_NM | PROMTN_NM | PROMTN_BNEF_CN | BRAND_NM | CSTMR_ID | TRMNL_MODL_NM | TRMNL_MODL_OPERSYSM_TY_CD | TRMNL_MODL_OPERSYSM_TY_NM | CRTFC_DT | CRTFC_FLAG_NM | CRTFC_STR_NM | CRTFC_STR_ADDR | COUPON_NM | COUPON_ID | COUPON_USGSTT_NM | COUPON_USE_DT | COUPON_USE_STR_NM | COUPON_USE_STR_ADDR | COUPON_BNEF_CN | CLUSTR_ID | ESNTL_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 91 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 果木炭烤活鱼一份 | aae4bce50db844f5a9bf45c253184eb2 | 발급 | <NA> | <NA> | <NA> | 限2.5斤以内烤鱼、不含配菜; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | 3 | V00A015B128S0016FSC004 |
91 | 92 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | 8891a7aee4e44d1d8c9deeef2b248e13 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 3 | V00A015B128S0016FSC004 |
92 | 93 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | f6649bc32f8342bfb1e94ef412956bc1 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 3 | V00A015B128S0016FSC004 |
93 | 94 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 蜂蜜柚子茶 | 61b900e48d7c4be3bcd4a68b96481d49 | 발급 | <NA> | <NA> | <NA> | 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食 | 3 | V00A015B128S0016FSC004 |
94 | 95 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | 703603f1abda422ea56c249911962ead | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 3 | V00A015B128S0016FSC004 |
95 | 96 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1tub92Uw0Qjk80lGPMavJRQ | <NA> | 단말모델미분류 | <NA> | 20200930224325 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 柴鱼花皮蛋豆腐 | 2a43307acc484b2eb53276bba74d7356 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 3 | V00A015B128S0016FSC004 |
96 | 97 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1jowqP6jZlMyFReCXBrCp6w | <NA> | 단말모델미분류 | <NA> | 20200930224305 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | 214fba2fec4f4eaca4760898bc20ea29 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 5 | V00A015B128S0016FSC004 |
97 | 98 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1jowqP6jZlMyFReCXBrCp6w | <NA> | 단말모델미분류 | <NA> | 20200930224305 | <NA> | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 黄金虾饼 | b40b3f03282945429545d8c165bc2d90 | <NA> | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 5 | V00A015B128S0016FSC004 |
98 | 99 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1jowqP6jZlMyFReCXBrCp6w | <NA> | 단말모델미분류 | <NA> | 20200930224305 | 사용 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 柴鱼花皮蛋豆腐 | 6c28248462434acea392b32a2b5a26d1 | 사용 | 20200715121116 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可叠加使用; 限堂食. | 5 | V00A015B128S0016FSC004 |
99 | 100 | 11 | 중국적립프로모션참여고객성향 | 江边城.巫山烤鱼 | 集齐1枚鱼章,即赠【夏日蜂蜜柚子茶】1杯; 集齐2枚鱼章,即赠【柴鱼花皮蛋豆腐】1份; 集齐3枚鱼章,即赠江边城【黄金虾饼】1份; 集齐4枚鱼章,即赠特色【香辣滋味虾】1份; 集齐5枚鱼章,赠巫山【果木炭烤活鱼】1份; | 山西誉顺和餐饮管理合伙企业(有限合伙) | o1yVS1jowqP6jZlMyFReCXBrCp6w | <NA> | 단말모델미분류 | <NA> | 20200930224305 | 쿠폰발급 | 江边城.巫山烤鱼【长风街店】 | 山西省太原市梅园百盛二部对面过街天桥南 | 香辣滋味虾 | da34920235cf456581b5b20b859c63a3 | 발급 | <NA> | <NA> | <NA> | 如菜品估清,可更换为其它等价菜品; 此券不找零、不兑换现金、不开具发票; 不与其他优惠同享; 不可与其他优惠券叠加使用; 限堂食. | 5 | V00A015B128S0016FSC004 |