Overview

Dataset statistics

Number of variables18
Number of observations100
Missing cells300
Missing cells (%)16.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.1 KiB
Average record size in memory154.3 B

Variable types

Numeric3
Categorical11
Unsupported3
Text1

Alerts

promtn_ty_cd has constant value ""Constant
promtn_ty_nm has constant value ""Constant
coupon_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
esntl_id has constant value ""Constant
brand_nm is highly overall correlated with seq_no and 5 other fieldsHigh correlation
crtfc_str_addr is highly overall correlated with seq_no and 5 other fieldsHigh correlation
coupon_usgstt_nm is highly overall correlated with brand_nm and 2 other fieldsHigh correlation
crtfc_str_nm is highly overall correlated with seq_no and 5 other fieldsHigh correlation
seq_no is highly overall correlated with brand_nm and 2 other fieldsHigh correlation
coupon_issu_dt is highly overall correlated with coupon_id and 3 other fieldsHigh correlation
coupon_id is highly overall correlated with coupon_issu_dt and 3 other fieldsHigh correlation
brand_nm is highly imbalanced (71.4%)Imbalance
coupon_usgstt_nm is highly imbalanced (71.4%)Imbalance
crtfc_str_nm is highly imbalanced (71.4%)Imbalance
crtfc_str_addr is highly imbalanced (71.4%)Imbalance
coupon_bnef_cn has 100 (100.0%) missing valuesMissing
trmnl_modl_nm has 100 (100.0%) missing valuesMissing
coupon_use_dt has 100 (100.0%) missing valuesMissing
seq_no has unique valuesUnique
coupon_bnef_cn is an unsupported type, check if it needs cleaning or further analysisUnsupported
trmnl_modl_nm 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

Reproduction

Analysis started2023-12-10 09:39:12.940396
Analysis finished2023-12-10 09:39:15.785994
Duration2.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

seq_no
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.24
Minimum1
Maximum373
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:15.901742image/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
Maximum373
Range372
Interquartile range (IQR)50.5

Descriptive statistics

Standard deviation61.740598
Coefficient of variation (CV)1.0081744
Kurtosis17.692644
Mean61.24
Median Absolute Deviation (MAD)25.5
Skewness3.8368508
Sum6124
Variance3811.9014
MonotonicityNot monotonic
2023-12-10T18:39:16.140501image/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 (%)
373 1
1.0%
372 1
1.0%
371 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
8
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
8 100
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

2023-12-10T18:39:17.137009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대만임의프로모션참여고객성향 100
100.0%

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

Common Values (Plot)

2023-12-10T18:39:17.430089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
覺旅咖啡通用券 100
100.0%

coupon_bnef_cn
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

brand_nm
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
95 
覺旅咖啡
 
5

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row覺旅咖啡
2nd row覺旅咖啡
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 95
95.0%
覺旅咖啡 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:17.731194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 95
95.0%
覺旅咖啡 5
 
5.0%

cstmr_id
Text

Distinct67
Distinct (%)67.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:39:18.302054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length41
Mean length41
Min length41

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)42.0%

Sample

1st row12cm_cp_U7eaf969d42d44c667c6316076dff239a
2nd row12cm_cp_U3a80c4ac3b2b69a78bc43cd212c717d9
3rd row12cm_cp_U2fb682d9767c0e9aadf21ba99e4868d6
4th row12cm_cp_U2fb682d9767c0e9aadf21ba99e4868d6
5th row12cm_cp_U1f31ca17dde57f52af14130c10d48245
ValueCountFrequency (%)
12cm_cp_ud498b374d8c9d7e44e3d2878f143735e 5
 
5.0%
12cm_cp_ubc88bfddcc7b8b3491f28d6866ceb568 3
 
3.0%
12cm_cp_u66627adb3108c3d630b7d105488fa74a 3
 
3.0%
12cm_cp_ud0619041cf0edfd28bb82cde149a0fc8 3
 
3.0%
12cm_cp_u17aaaa90082aa4828c4cc37b5c47987c 3
 
3.0%
12cm_cp_udb6b452b5c9f50441e123834c39ca2e9 3
 
3.0%
12cm_cp_u67390902584734761686bd63aec99bb5 2
 
2.0%
12cm_cp_ubdd63148a86b5c8ed0f0d9730d1e5413 2
 
2.0%
12cm_cp_udc54c93ead0a7a074f7b4de0029b0e2d 2
 
2.0%
12cm_cp_u3c062d8f58cbdf5524b50f9e9321bcf1 2
 
2.0%
Other values (57) 72
72.0%
2023-12-10T18:39:18.918841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
c 411
 
10.0%
2 303
 
7.4%
1 265
 
6.5%
d 238
 
5.8%
8 234
 
5.7%
4 214
 
5.2%
3 214
 
5.2%
e 213
 
5.2%
7 209
 
5.1%
9 201
 
4.9%
Other values (10) 1598
39.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2182
53.2%
Lowercase Letter 1618
39.5%
Connector Punctuation 200
 
4.9%
Uppercase Letter 100
 
2.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 303
13.9%
1 265
12.1%
8 234
10.7%
4 214
9.8%
3 214
9.8%
7 209
9.6%
9 201
9.2%
0 189
8.7%
6 187
8.6%
5 166
7.6%
Lowercase Letter
ValueCountFrequency (%)
c 411
25.4%
d 238
14.7%
e 213
13.2%
b 193
11.9%
a 190
11.7%
f 173
10.7%
p 100
 
6.2%
m 100
 
6.2%
Connector Punctuation
ValueCountFrequency (%)
_ 200
100.0%
Uppercase Letter
ValueCountFrequency (%)
U 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2382
58.1%
Latin 1718
41.9%

Most frequent character per script

Common
ValueCountFrequency (%)
2 303
12.7%
1 265
11.1%
8 234
9.8%
4 214
9.0%
3 214
9.0%
7 209
8.8%
9 201
8.4%
_ 200
8.4%
0 189
7.9%
6 187
7.9%
Latin
ValueCountFrequency (%)
c 411
23.9%
d 238
13.9%
e 213
12.4%
b 193
11.2%
a 190
11.1%
f 173
10.1%
p 100
 
5.8%
U 100
 
5.8%
m 100
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4100
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
c 411
 
10.0%
2 303
 
7.4%
1 265
 
6.5%
d 238
 
5.8%
8 234
 
5.7%
4 214
 
5.2%
3 214
 
5.2%
e 213
 
5.2%
7 209
 
5.1%
9 201
 
4.9%
Other values (10) 1598
39.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:39:19.143537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

coupon_issu_dt
Real number (ℝ)

HIGH CORRELATION 

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

Quantile statistics

Minimum2.021033 × 1013
5-th percentile2.021033 × 1013
Q12.021033 × 1013
median2.021033 × 1013
Q32.0210331 × 1013
95-th percentile2.0210331 × 1013
Maximum2.0210416 × 1013
Range86101723
Interquartile range (IQR)1048434.8

Descriptive statistics

Standard deviation15433196
Coefficient of variation (CV)7.6362896 × 10-7
Kurtosis22.029449
Mean2.0210334 × 1013
Median Absolute Deviation (MAD)2999
Skewness4.8296764
Sum2.0210334 × 1015
Variance2.3818354 × 1014
MonotonicityNot monotonic
2023-12-10T18:39:20.011321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20210330090417 3
 
3.0%
20210330090459 2
 
2.0%
20210331194939 2
 
2.0%
20210330090931 2
 
2.0%
20210330090302 2
 
2.0%
20210330091449 2
 
2.0%
20210330091342 1
 
1.0%
20210330092525 1
 
1.0%
20210330092524 1
 
1.0%
20210330092101 1
 
1.0%
Other values (83) 83
83.0%
ValueCountFrequency (%)
20210330090207 1
1.0%
20210330090218 1
1.0%
20210330090219 1
1.0%
20210330090229 1
1.0%
20210330090300 1
1.0%
20210330090302 2
2.0%
20210330090303 1
1.0%
20210330090304 1
1.0%
20210330090311 1
1.0%
20210330090312 1
1.0%
ValueCountFrequency (%)
20210416191930 1
1.0%
20210415222147 1
1.0%
20210401073529 1
1.0%
20210401005307 1
1.0%
20210331223934 1
1.0%
20210331214020 1
1.0%
20210331213248 1
1.0%
20210331210817 1
1.0%
20210331210816 1
1.0%
20210331210748 1
1.0%

coupon_usgstt_nm
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
발급
95 
사용
 
5

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
발급 95
95.0%
사용 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:20.380887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발급 95
95.0%
사용 5
 
5.0%

coupon_use_dt
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

crtfc_str_nm
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
95 
西湖店
 
5

Length

Max length4
Median length4
Mean length3.95
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 95
95.0%
西湖店 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:20.710886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 95
95.0%
西湖店 5
 
5.0%

crtfc_str_addr
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
<NA>
95 
台北市內湖區瑞光路583巷24號
 
5

Length

Max length16
Median length4
Mean length4.6
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row台北市內湖區瑞光路583巷24號
2nd row台北市內湖區瑞光路583巷24號
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 95
95.0%
台北市內湖區瑞光路583巷24號 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T18:39:21.068988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 95
95.0%
台北市內湖區瑞光路583巷24號 5
 
5.0%

coupon_id
Real number (ℝ)

HIGH CORRELATION 

Distinct98
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3874553 × 1011
Minimum2.2939573 × 1011
Maximum2.3986003 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:39:21.245025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.2939573 × 1011
5-th percentile2.3882654 × 1011
Q12.3882657 × 1011
median2.3882665 × 1011
Q32.3883386 × 1011
95-th percentile2.3883868 × 1011
Maximum2.3986003 × 1011
Range1.0464298 × 1010
Interquartile range (IQR)7290832.5

Descriptive statistics

Standard deviation9.5004004 × 108
Coefficient of variation (CV)0.0039792999
Kurtosis97.604129
Mean2.3874553 × 1011
Median Absolute Deviation (MAD)102905
Skewness-9.8073617
Sum2.3874553 × 1013
Variance9.0257607 × 1017
MonotonicityNot monotonic
2023-12-10T18:39:21.467566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
238838086130 2
 
2.0%
238826568706 2
 
2.0%
238829610005 1
 
1.0%
238826643228 1
 
1.0%
238826639866 1
 
1.0%
238826638279 1
 
1.0%
238826630588 1
 
1.0%
238826618918 1
 
1.0%
238826610155 1
 
1.0%
238826609423 1
 
1.0%
Other values (88) 88
88.0%
ValueCountFrequency (%)
229395728277 1
1.0%
238826533273 1
1.0%
238826535181 1
1.0%
238826536783 1
1.0%
238826537385 1
1.0%
238826539121 1
1.0%
238826540729 1
1.0%
238826541310 1
1.0%
238826542343 1
1.0%
238826543915 1
1.0%
ValueCountFrequency (%)
239860025834 1
1.0%
238839239024 1
1.0%
238839017694 1
1.0%
238838847014 1
1.0%
238838698559 1
1.0%
238838677602 1
1.0%
238838580755 1
1.0%
238838579560 1
1.0%
238838578648 1
1.0%
238838308475 1
1.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:39:21.778520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

esntl_id
Categorical

CONSTANT 

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

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
V00A004S0024FCS00017 100
100.0%

Length

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

Common Values (Plot)

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

Interactions

2023-12-10T18:39:14.833315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:13.960718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.396687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.966760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.092392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.543434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:15.089487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.234512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:39:14.707283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:39:22.686290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
seq_nocstmr_idcoupon_issu_dtcoupon_usgstt_nmcoupon_id
seq_no1.0000.9920.5650.437NaN
cstmr_id0.9921.0001.0000.505NaN
coupon_issu_dt0.5651.0001.0000.159NaN
coupon_usgstt_nm0.4370.5050.1591.000NaN
coupon_idNaNNaNNaNNaN1.000
2023-12-10T18:39:22.846740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
brand_nmcrtfc_str_addrcoupon_usgstt_nmcrtfc_str_nm
brand_nm1.0001.0001.0001.000
crtfc_str_addr1.0001.0001.0001.000
coupon_usgstt_nm1.0001.0001.0001.000
crtfc_str_nm1.0001.0001.0001.000
2023-12-10T18:39:23.394867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
seq_nocoupon_issu_dtcoupon_idbrand_nmcoupon_usgstt_nmcrtfc_str_nmcrtfc_str_addr
seq_no1.000-0.221-0.1791.0000.2901.0001.000
coupon_issu_dt-0.2211.0000.9281.0000.2611.0001.000
coupon_id-0.1790.9281.0001.0000.1821.0001.000
brand_nm1.0001.0001.0001.0001.0001.0001.000
coupon_usgstt_nm0.2900.2610.1821.0001.0001.0001.000
crtfc_str_nm1.0001.0001.0001.0001.0001.0001.000
crtfc_str_addr1.0001.0001.0001.0001.0001.0001.000

Missing values

2023-12-10T18:39:15.303682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:39:15.646906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

seq_nopromtn_ty_cdpromtn_ty_nmcoupon_nmcoupon_bnef_cnbrand_nmcstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcoupon_issu_dtcoupon_usgstt_nmcoupon_use_dtcrtfc_str_nmcrtfc_str_addrcoupon_idclustr_idesntl_id
018대만임의프로모션참여고객성향覺旅咖啡通用券<NA>覺旅咖啡12cm_cp_U7eaf969d42d44c667c6316076dff239a<NA>0모델정보수집거부20210331081909사용<NA>西湖店台北市內湖區瑞光路583巷24號2388296100050V00A004S0024FCS00017
13718대만임의프로모션참여고객성향覺旅咖啡通用券<NA>覺旅咖啡12cm_cp_U3a80c4ac3b2b69a78bc43cd212c717d9<NA>0모델정보수집거부20210416191930사용<NA>西湖店台北市內湖區瑞光路583巷24號2388303187560V00A004S0024FCS00017
238대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U2fb682d9767c0e9aadf21ba99e4868d6<NA>0모델정보수집거부20210331105802발급<NA><NA><NA>2388338424970V00A004S0024FCS00017
348대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U2fb682d9767c0e9aadf21ba99e4868d6<NA>0모델정보수집거부20210331105803발급<NA><NA><NA>2388338439810V00A004S0024FCS00017
458대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U1f31ca17dde57f52af14130c10d48245<NA>0모델정보수집거부20210331111326발급<NA><NA><NA>2388339085330V00A004S0024FCS00017
568대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_Ucb3c08147d7631a604e71fe877493037<NA>0모델정보수집거부20210330103917발급<NA><NA><NA>2388269139310V00A004S0024FCS00017
678대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U5706bb8a33be8a902358f6c9e684e924<NA>0모델정보수집거부20210331121351발급<NA><NA><NA>2388343502340V00A004S0024FCS00017
73728대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U7c1eee29d3ce6deee087b6be2b6e8f43<NA>0모델정보수집거부20210330202607발급<NA><NA><NA>2388322597280V00A004S0024FCS00017
898대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U7c15eb18f999a64fafcf64762c03aa46<NA>0모델정보수집거부20210331134947발급<NA><NA><NA>2388353659290V00A004S0024FCS00017
9108대만임의프로모션참여고객성향覺旅咖啡通用券<NA>覺旅咖啡12cm_cp_Ua1482a61e2f2e5c6b37a601c875103c0<NA>0모델정보수집거부20210331151453사용<NA>西湖店台北市內湖區瑞光路583巷24號2388287548640V00A004S0024FCS00017
seq_nopromtn_ty_cdpromtn_ty_nmcoupon_nmcoupon_bnef_cnbrand_nmcstmr_idtrmnl_modl_nmtrmnl_modl_opersysm_ty_cdtrmnl_modl_opersysm_ty_nmcoupon_issu_dtcoupon_usgstt_nmcoupon_use_dtcrtfc_str_nmcrtfc_str_addrcoupon_idclustr_idesntl_id
90918대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U5044c1cce0c5a384c245126124a79e58<NA>0모델정보수집거부20210330095145발급<NA><NA><NA>2388266964320V00A004S0024FCS00017
91928대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U5044c1cce0c5a384c245126124a79e58<NA>0모델정보수집거부20210330095146발급<NA><NA><NA>2388266970080V00A004S0024FCS00017
92938대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U64134c8eae1f65657dd0cb423005beac<NA>0모델정보수집거부20210330095335발급<NA><NA><NA>2388267019600V00A004S0024FCS00017
93948대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_Uba1c4732d8d22957a94468e095e970ac<NA>0모델정보수집거부20210330100225발급<NA><NA><NA>2388267560780V00A004S0024FCS00017
94958대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U67390902584734761686bd63aec99bb5<NA>0모델정보수집거부20210330100235발급<NA><NA><NA>2388267584990V00A004S0024FCS00017
95968대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U67390902584734761686bd63aec99bb5<NA>0모델정보수집거부20210330100236발급<NA><NA><NA>2388267590370V00A004S0024FCS00017
96978대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_Uba1c4732d8d22957a94468e095e970ac<NA>0모델정보수집거부20210330100246발급<NA><NA><NA>2388267612590V00A004S0024FCS00017
97988대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U793bce4cce79d494a3d756410e3b6472<NA>0모델정보수집거부20210330100349발급<NA><NA><NA>2388267750050V00A004S0024FCS00017
98998대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U793bce4cce79d494a3d756410e3b6472<NA>0모델정보수집거부20210330100504발급<NA><NA><NA>2388268052150V00A004S0024FCS00017
991008대만임의프로모션참여고객성향覺旅咖啡通用券<NA><NA>12cm_cp_U7fce42e65754cf5f2f6e3097c9186000<NA>0모델정보수집거부20210330100514발급<NA><NA><NA>2388268089190V00A004S0024FCS00017