Overview

Dataset statistics

Number of variables24
Number of observations100
Missing cells600
Missing cells (%)25.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.1 KiB
Average record size in memory205.3 B

Variable types

Numeric2
Categorical16
Unsupported6

Alerts

promtn_ty_cd has constant value ""Constant
promtn_ty_nm 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
promtn_nm is highly imbalanced (80.6%)Imbalance
promtn_bnef_cn is highly imbalanced (80.6%)Imbalance
misn_co is highly imbalanced (80.6%)Imbalance
crtfc_flag_nm is highly imbalanced (80.6%)Imbalance
crtfc_str_addr is highly imbalanced (80.6%)Imbalance
coupon_nm is highly imbalanced (80.6%)Imbalance
coupon_id is highly imbalanced (87.9%)Imbalance
coupon_usgstt_nm is highly imbalanced (80.6%)Imbalance
esntl_id is highly imbalanced (80.6%)Imbalance
trmnl_modl_nm has 100 (100.0%) missing valuesMissing
misn_cn has 100 (100.0%) missing valuesMissing
coupon_use_dt has 100 (100.0%) missing valuesMissing
coupon_use_str_nm has 100 (100.0%) missing valuesMissing
coupon_use_str_addr has 100 (100.0%) missing valuesMissing
coupon_bnef_cn has 100 (100.0%) missing valuesMissing
seq_no has unique valuesUnique
trmnl_modl_nm is an unsupported type, check if it needs cleaning or further analysisUnsupported
misn_cn is an unsupported type, check if it needs cleaning or further analysisUnsupported
coupon_use_dt is an unsupported type, check if it needs cleaning or further analysisUnsupported
coupon_use_str_nm is an unsupported type, check if it needs cleaning or further analysisUnsupported
coupon_use_str_addr is an unsupported type, check if it needs cleaning or further analysisUnsupported
coupon_bnef_cn is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 09:54:29.840779
Analysis finished2023-12-10 09:54:30.269031
Duration0.43 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%
Mean1982.77
Minimum1
Maximum64424
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:54:30.482369image/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
Maximum64424
Range64423
Interquartile range (IQR)50.5

Descriptive statistics

Standard deviation11036.289
Coefficient of variation (CV)5.5660965
Kurtosis29.897345
Mean1982.77
Median Absolute Deviation (MAD)25.5
Skewness5.5945912
Sum198277
Variance1.2179968 × 108
MonotonicityNot monotonic
2023-12-10T18:54:30.797278image/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 (%)
64424 1
1.0%
64423 1
1.0%
64422 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
12
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
12 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

promtn_nm
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
宝龙旭辉广场
97 
国美app--天津--到此一游
 
3

Length

Max length15
Median length6
Mean length6.27
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row宝龙旭辉广场
2nd row国美app--天津--到此一游
3rd row宝龙旭辉广场
4th row宝龙旭辉广场
5th row宝龙旭辉广场

Common Values

ValueCountFrequency (%)
宝龙旭辉广场 97
97.0%
国美app--天津--到此一游 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:32.389351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
宝龙旭辉广场 97
97.0%
国美app--天津--到此一游 3
 
3.0%

promtn_bnef_cn
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）
97 
欢迎来到快乐ZAO城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000D_,这里有很多好玩的“ZAO动站”，你只需要在不同的ZAO动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～
 
3

Length

Max length104
Median length87
Mean length87.51
Min length87

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）
2nd row欢迎来到快乐ZAO城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000D_,这里有很多好玩的“ZAO动站”，你只需要在不同的ZAO动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～
3rd row3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）
4th row3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）
5th row3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）

Common Values

ValueCountFrequency (%)
3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止） 97
97.0%
欢迎来到快乐ZAO城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000D_,这里有很多好玩的“ZAO动站”，你只需要在不同的ZAO动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～ 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:33.056641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000d_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止） 97
97.0%
欢迎来到快乐zao城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000d_,这里有很多好玩的“zao动站”，你只需要在不同的zao动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～ 3
 
3.0%

misn_co
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
9
97 
7
 
3

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row9
2nd row7
3rd row9
4th row9
5th row9

Common Values

ValueCountFrequency (%)
9 97
97.0%
7 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:34.102037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
9 97
97.0%
7 3
 
3.0%

cstmr_id
Categorical

Distinct25
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
oxGQgxD5pbQfm8g7U0d4cQLA7XCM
 
6
oxGQgxMedhaK9hkXpTI6cGlERB20
 
6
oxGQgxKgo99Bo4iw8v55JqGPdBIE
 
6
oxGQgxJ0j1Gq_fTRGJ2h38ZxYCIw
 
6
oxGQgxPSzjiXGSWpaF7yVs8X36Mw
 
6
Other values (20)
70 

Length

Max length32
Median length28
Mean length28.12
Min length28

Unique

Unique4 ?
Unique (%)4.0%

Sample

1st rowoxGQgxAquzSaYzrkhp7pinb05Qss
2nd rowbc0ec4feecb842fdafabcd56c7c89748
3rd rowoxGQgxCRnYEHajihorr6o9t2Sp3I
4th rowoxGQgxCRnYEHajihorr6o9t2Sp3I
5th rowoxGQgxCRnYEHajihorr6o9t2Sp3I

Common Values

ValueCountFrequency (%)
oxGQgxD5pbQfm8g7U0d4cQLA7XCM 6
 
6.0%
oxGQgxMedhaK9hkXpTI6cGlERB20 6
 
6.0%
oxGQgxKgo99Bo4iw8v55JqGPdBIE 6
 
6.0%
oxGQgxJ0j1Gq_fTRGJ2h38ZxYCIw 6
 
6.0%
oxGQgxPSzjiXGSWpaF7yVs8X36Mw 6
 
6.0%
oxGQgxBx36p7ja1NLp-KUy03GSgk 6
 
6.0%
oxGQgxJNG5VybNsuk8c5pAhBRa9w 6
 
6.0%
oxGQgxN0pByPzX14-VPWsxSuR7n0 6
 
6.0%
oxGQgxGxV2UGxNk3i09DLMvJ8tR4 5
 
5.0%
oxGQgxJqwpdSNf8jLShLnXQeZ9ZA 5
 
5.0%
Other values (15) 42
42.0%

Length

2023-12-10T18:54:34.366703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
oxgqgxd5pbqfm8g7u0d4cqla7xcm 6
 
6.0%
oxgqgxkgo99bo4iw8v55jqgpdbie 6
 
6.0%
oxgqgxj0j1gq_ftrgj2h38zxyciw 6
 
6.0%
oxgqgxpszjixgswpaf7yvs8x36mw 6
 
6.0%
oxgqgxbx36p7ja1nlp-kuy03gsgk 6
 
6.0%
oxgqgxjng5vybnsuk8c5pahbra9w 6
 
6.0%
oxgqgxn0pbypzx14-vpwsxsur7n0 6
 
6.0%
oxgqgxmedhak9hkxpti6cglerb20 6
 
6.0%
oxgqgxm3bdh6mtsip1ojwjkvlea8 5
 
5.0%
oxgqgxcrnyehajihorr6o9t2sp3i 5
 
5.0%
Other values (15) 42
42.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
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:54:34.972865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:54:35.250041image/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:54:35.529610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

crtfc_dt
Real number (ℝ)

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0210795 × 1013
Minimum2.021061 × 1013
Maximum2.0210801 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:54:36.148818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.021061 × 1013
5-th percentile2.0210801 × 1013
Q12.0210801 × 1013
median2.0210801 × 1013
Q32.0210801 × 1013
95-th percentile2.0210801 × 1013
Maximum2.0210801 × 1013
Range1.910698 × 108
Interquartile range (IQR)13055.5

Descriptive statistics

Standard deviation32755037
Coefficient of variation (CV)1.6206703 × 10-6
Kurtosis29.897771
Mean2.0210795 × 1013
Median Absolute Deviation (MAD)8049
Skewness-5.5946489
Sum2.0210795 × 1015
Variance1.0728924 × 1015
MonotonicityNot monotonic
2023-12-10T18:54:36.750325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20210801185436 2
 
2.0%
20210801214547 1
 
1.0%
20210801192652 1
 
1.0%
20210801190821 1
 
1.0%
20210801190823 1
 
1.0%
20210801191925 1
 
1.0%
20210801191947 1
 
1.0%
20210801192005 1
 
1.0%
20210801192025 1
 
1.0%
20210801192201 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
20210610144750 1
1.0%
20210610145008 1
1.0%
20210610145111 1
1.0%
20210801183802 1
1.0%
20210801183813 1
1.0%
20210801183825 1
1.0%
20210801183829 1
1.0%
20210801183957 1
1.0%
20210801184003 1
1.0%
20210801184213 1
1.0%
ValueCountFrequency (%)
20210801214547 1
1.0%
20210801211844 1
1.0%
20210801211545 1
1.0%
20210801211422 1
1.0%
20210801211259 1
1.0%
20210801210807 1
1.0%
20210801210043 1
1.0%
20210801210021 1
1.0%
20210801205834 1
1.0%
20210801205829 1
1.0%

crtfc_flag_nm
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
적립
97 
쿠폰발급
 
3

Length

Max length4
Median length2
Mean length2.06
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
적립 97
97.0%
쿠폰발급 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:37.398454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
적립 97
97.0%
쿠폰발급 3
 
3.0%

crtfc_str_nm
Categorical

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
B1三只松鼠
16 
B1919
14 
B1总服务台
14 
1F斯凯奇
12 
1F花椒鸡
11 
Other values (6)
33 

Length

Max length12
Median length11
Mean length5.3
Min length4

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st rowB1芳白
2nd row天津--美食ZAO动站1
3rd rowB1夜郎
4th rowB1芳白
5th rowB1919

Common Values

ValueCountFrequency (%)
B1三只松鼠 16
16.0%
B1919 14
14.0%
B1总服务台 14
14.0%
1F斯凯奇 12
12.0%
1F花椒鸡 11
11.0%
B1芳白 10
10.0%
B1夜郎 10
10.0%
2F御鲜匠 10
10.0%
天津--美食ZAO动站1 1
 
1.0%
天津--交换ZAO动站 1
 
1.0%

Length

2023-12-10T18:54:37.775842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
b1三只松鼠 16
16.0%
b1919 14
14.0%
b1总服务台 14
14.0%
1f斯凯奇 12
12.0%
1f花椒鸡 11
11.0%
b1芳白 10
10.0%
b1夜郎 10
10.0%
2f御鲜匠 10
10.0%
天津--美食zao动站1 1
 
1.0%
天津--交换zao动站 1
 
1.0%

crtfc_str_addr
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
97 
活动
 
3

Length

Max length2
Median length1
Mean length1.03
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row活动
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 97
97.0%
活动 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:38.235861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 97
97.0%
活动 3
 
3.0%

misn_cn
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

coupon_nm
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
97 
10枚虎爪
 
3

Length

Max length5
Median length4
Mean length4.03
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row10枚虎爪
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 97
97.0%
10枚虎爪 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:38.618641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 97
97.0%
10枚虎爪 3
 
3.0%

coupon_id
Categorical

IMBALANCE 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
쿠폰미발급
97 
22d8ed83ee074529b92f0f1c1007d08a
 
1
2e1e00c43560484f88dedacf48105a90
 
1
0ace1c147fb54118a58ab567d2ee49ee
 
1

Length

Max length32
Median length5
Mean length5.81
Min length5

Unique

Unique3 ?
Unique (%)3.0%

Sample

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

Common Values

ValueCountFrequency (%)
쿠폰미발급 97
97.0%
22d8ed83ee074529b92f0f1c1007d08a 1
 
1.0%
2e1e00c43560484f88dedacf48105a90 1
 
1.0%
0ace1c147fb54118a58ab567d2ee49ee 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:39.058576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
쿠폰미발급 97
97.0%
22d8ed83ee074529b92f0f1c1007d08a 1
 
1.0%
2e1e00c43560484f88dedacf48105a90 1
 
1.0%
0ace1c147fb54118a58ab567d2ee49ee 1
 
1.0%

coupon_usgstt_nm
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
97 
발급
 
3

Length

Max length4
Median length4
Mean length3.94
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 97
97.0%
발급 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:39.523324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 97
97.0%
발급 3
 
3.0%

coupon_use_dt
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

coupon_use_str_nm
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

coupon_use_str_addr
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

coupon_bnef_cn
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

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

Common Values (Plot)

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

esntl_id
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
V00A005S0006FSR033
97 
V00A005S0006FSR017
 
3

Length

Max length18
Median length18
Mean length18
Min length18

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowV00A005S0006FSR033
2nd rowV00A005S0006FSR017
3rd rowV00A005S0006FSR033
4th rowV00A005S0006FSR033
5th rowV00A005S0006FSR033

Common Values

ValueCountFrequency (%)
V00A005S0006FSR033 97
97.0%
V00A005S0006FSR017 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T18:54:40.291845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
v00a005s0006fsr033 97
97.0%
v00a005s0006fsr017 3
 
3.0%

Sample

seq_nopromtn_ty_cdpromtn_ty_nmpromtn_nmpromtn_bnef_cnmisn_cocstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcrtfc_dtcrtfc_flag_nmcrtfc_str_nmcrtfc_str_addrmisn_cncoupon_nmcoupon_idcoupon_usgstt_nmcoupon_use_dtcoupon_use_str_nmcoupon_use_str_addrcoupon_bnef_cnclustr_idesntl_id
0112중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxAquzSaYzrkhp7pinb05Qss<NA>0모델정보수집거부20210801214547적립B1芳白1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
16442212중국소셜프로모션참여고객성향国美app--天津--到此一游欢迎来到快乐ZAO城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000D_,这里有很多好玩的“ZAO动站”，你只需要在不同的ZAO动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～7bc0ec4feecb842fdafabcd56c7c89748<NA>0모델정보수집거부20210610145111쿠폰발급天津--美食ZAO动站1活动<NA>10枚虎爪22d8ed83ee074529b92f0f1c1007d08a발급<NA><NA><NA><NA>0V00A005S0006FSR017
2312중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxCRnYEHajihorr6o9t2Sp3I<NA>0모델정보수집거부20210801211844적립B1夜郎1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
3412중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxCRnYEHajihorr6o9t2Sp3I<NA>0모델정보수집거부20210801211545적립B1芳白1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
4512중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxCRnYEHajihorr6o9t2Sp3I<NA>0모델정보수집거부20210801211422적립B19191<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
5612중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxCRnYEHajihorr6o9t2Sp3I<NA>0모델정보수집거부20210801211259적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
6712중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxCRnYEHajihorr6o9t2Sp3I<NA>0모델정보수집거부20210801210807적립2F御鲜匠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
76442312중국소셜프로모션참여고객성향国美app--天津--到此一游欢迎来到快乐ZAO城嘉年华！现在，你已经获得了玩家身份，可以开始游玩打卡啦～_x000D_,这里有很多好玩的“ZAO动站”，你只需要在不同的ZAO动站进行玩耍，并点亮logo方块，就可以获得珍贵的“虎爪”哟～7bc0ec4feecb842fdafabcd56c7c89748<NA>0모델정보수집거부20210610145008쿠폰발급天津--交换ZAO动站活动<NA>10枚虎爪2e1e00c43560484f88dedacf48105a90발급<NA><NA><NA><NA>0V00A005S0006FSR017
8912중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxN0pByPzX14-VPWsxSuR7n0<NA>0모델정보수집거부20210801210043적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
91012중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxMedhaK9hkXpTI6cGlERB20<NA>0모델정보수집거부20210801210021적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
seq_nopromtn_ty_cdpromtn_ty_nmpromtn_nmpromtn_bnef_cnmisn_cocstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcrtfc_dtcrtfc_flag_nmcrtfc_str_nmcrtfc_str_addrmisn_cncoupon_nmcoupon_idcoupon_usgstt_nmcoupon_use_dtcoupon_use_str_nmcoupon_use_str_addrcoupon_bnef_cnclustr_idesntl_id
909112중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxNOePVd0mnPkDV49yDEy73w<NA>0모델정보수집거부20210801184635적립B1夜郎1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
919212중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxBhqzANHqZ2LPo3YcuQmi8Q<NA>0모델정보수집거부20210801184302적립1F花椒鸡1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
929312중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxOziTIJIq3SVerFNZxFLpe0<NA>0모델정보수집거부20210801184226적립1F花椒鸡1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
939412중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxHG1TyP8f5a0Q4KjMxxMUX0<NA>0모델정보수집거부20210801184213적립1F花椒鸡1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
949512중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxOziTIJIq3SVerFNZxFLpe0<NA>0모델정보수집거부20210801184003적립B1总服务台1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
959612중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxHG1TyP8f5a0Q4KjMxxMUX0<NA>0모델정보수집거부20210801183957적립B1总服务台1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
969712중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxJ_KZmFg33jJDGvMbXcYbAo<NA>0모델정보수집거부20210801183829적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
979812중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxBhqzANHqZ2LPo3YcuQmi8Q<NA>0모델정보수집거부20210801183825적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
989912중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxOziTIJIq3SVerFNZxFLpe0<NA>0모델정보수집거부20210801183813적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033
9910012중국소셜프로모션참여고객성향宝龙旭辉广场3个章：悟空软抄本1本｜6个章：悟空限量马克杯1只｜9个章：50元全场无限制抵用券1张_x000D_,以上礼品不兼得，可在礼券列表中点击选择使用（礼券礼品数量有限，送完即止）9oxGQgxHG1TyP8f5a0Q4KjMxxMUX0<NA>0모델정보수집거부20210801183802적립B1三只松鼠1<NA><NA>쿠폰미발급<NA><NA><NA><NA><NA>0V00A005S0006FSR033