Overview

Dataset statistics

Number of variables18
Number of observations30
Missing cells150
Missing cells (%)27.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory160.4 B

Variable types

DateTime2
Text2
Numeric3
Categorical5
Unsupported5
Boolean1

Dataset

Description샘플 데이터
Author코나아이㈜
URLhttps://bigdata-region.kr/#/dataset/8b1c69b8-02b1-415c-b762-08cc9ed85acc

Alerts

정책주간결제시작일자 has constant value ""Constant
정책주간결제종료일자 has constant value ""Constant
가맹점번호 has constant value ""Constant
위도 has constant value ""Constant
경도 has constant value ""Constant
사용여부 has constant value ""Constant
결제금액 has constant value ""Constant
연령대코드 is highly overall correlated with 성별코드High correlation
성별코드 is highly overall correlated with 연령대코드High correlation
가맹점업종명 has 30 (100.0%) missing valuesMissing
가맹점우편번호 has 30 (100.0%) missing valuesMissing
시도명 has 30 (100.0%) missing valuesMissing
시군구명 has 30 (100.0%) missing valuesMissing
읍면동명 has 30 (100.0%) missing valuesMissing
카드번호 has unique valuesUnique
회원코드 has unique valuesUnique
가맹점업종명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
가맹점우편번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
시도명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
시군구명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
읍면동명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
연령대코드 has 10 (33.3%) zerosZeros

Reproduction

Analysis started2024-03-13 11:45:40.442001
Analysis finished2024-03-13 11:45:42.219589
Duration1.78 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

정책주간결제시작일자
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-11-06 00:00:00
Maximum2023-11-06 00:00:00
2024-03-13T20:45:42.305196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:42.450671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

정책주간결제종료일자
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-11-12 00:00:00
Maximum2023-11-12 00:00:00
2024-03-13T20:45:42.597266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:42.702438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

카드번호
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T20:45:42.995007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length44
Mean length44
Min length44

Characters and Unicode

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

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row9H23NCRrswE6A4Tp95MaTHHvvawxRBG+YWbPp5ICLQ8=
2nd row9HBKuv6TxqdCfCyLdAsEv4K2/I1y4lMvu8HXJkG2dQM=
3rd row9HZNbHBS9A0HC32CISAYYCT1JmXRjAY0j3UgidqEeFw=
4th row9HCgKSLd3cPFlRLaKL1RjTNBRzwIsgB2oXF9KR6XE9Y=
5th row9HHsyNnWh5Y0D+F7htaMr4O2HLkUswHxqN1zZdAuKtM=
ValueCountFrequency (%)
9h23ncrrswe6a4tp95mathhvvawxrbg+ywbpp5iclq8 1
 
3.3%
9hbkuv6txqdcfcyldasev4k2/i1y4lmvu8hxjkg2dqm 1
 
3.3%
9krwxnu5xb7hceps9tgbn9p1jxjfnofywj5hp+tir84 1
 
3.3%
9iegbbpb6hwliseb3qrjqyxrulsuulkihzzx3i45uvg 1
 
3.3%
9kohklpsnvtfw/hobdis+lo97gxedqk+hq4sfjpxw/8 1
 
3.3%
9ie0i7vmb9bptx11jgtz01xhnmkvvg16vl9tqdguuew 1
 
3.3%
9hv25gviwzd9u+nrhnpqh6hgoryy8uyhyjyt99bg32s 1
 
3.3%
9izj3mzojy7pzwj10kaidqnwmmv1jhd/gyyj5tns2y8 1
 
3.3%
9k4ru4rqkshwvb/xe276l6mvjyixhamezdixgcs3v4m 1
 
3.3%
9iwzqmwwdraeqneqxwfpg4llsx0psgjcqr6w/hphum4 1
 
3.3%
Other values (20) 20
66.7%
2024-03-13T20:45:43.406918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9 49
 
3.7%
H 40
 
3.0%
I 33
 
2.5%
P 30
 
2.3%
Q 30
 
2.3%
= 30
 
2.3%
4 29
 
2.2%
x 28
 
2.1%
j 26
 
2.0%
L 25
 
1.9%
Other values (55) 1000
75.8%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 567
43.0%
Lowercase Letter 470
35.6%
Decimal Number 216
 
16.4%
Math Symbol 46
 
3.5%
Other Punctuation 21
 
1.6%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
H 40
 
7.1%
I 33
 
5.8%
P 30
 
5.3%
Q 30
 
5.3%
L 25
 
4.4%
U 24
 
4.2%
R 23
 
4.1%
T 23
 
4.1%
N 23
 
4.1%
W 23
 
4.1%
Other values (16) 293
51.7%
Lowercase Letter
ValueCountFrequency (%)
x 28
 
6.0%
j 26
 
5.5%
b 24
 
5.1%
w 23
 
4.9%
g 22
 
4.7%
d 22
 
4.7%
s 21
 
4.5%
e 21
 
4.5%
h 20
 
4.3%
u 20
 
4.3%
Other values (16) 243
51.7%
Decimal Number
ValueCountFrequency (%)
9 49
22.7%
4 29
13.4%
2 20
9.3%
1 20
9.3%
8 18
 
8.3%
7 18
 
8.3%
5 17
 
7.9%
3 17
 
7.9%
0 15
 
6.9%
6 13
 
6.0%
Math Symbol
ValueCountFrequency (%)
= 30
65.2%
+ 16
34.8%
Other Punctuation
ValueCountFrequency (%)
/ 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1037
78.6%
Common 283
 
21.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
H 40
 
3.9%
I 33
 
3.2%
P 30
 
2.9%
Q 30
 
2.9%
x 28
 
2.7%
j 26
 
2.5%
L 25
 
2.4%
b 24
 
2.3%
U 24
 
2.3%
R 23
 
2.2%
Other values (42) 754
72.7%
Common
ValueCountFrequency (%)
9 49
17.3%
= 30
10.6%
4 29
10.2%
/ 21
7.4%
2 20
7.1%
1 20
7.1%
8 18
 
6.4%
7 18
 
6.4%
5 17
 
6.0%
3 17
 
6.0%
Other values (3) 44
15.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1320
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9 49
 
3.7%
H 40
 
3.0%
I 33
 
2.5%
P 30
 
2.3%
Q 30
 
2.3%
= 30
 
2.3%
4 29
 
2.2%
x 28
 
2.1%
j 26
 
2.0%
L 25
 
1.9%
Other values (55) 1000
75.8%

회원코드
Real number (ℝ)

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.0180585 × 109
Minimum3.0028102 × 109
Maximum3.0342882 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:45:43.551744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.0028102 × 109
5-th percentile3.0048948 × 109
Q13.0166824 × 109
median3.0179256 × 109
Q33.0198372 × 109
95-th percentile3.0321308 × 109
Maximum3.0342882 × 109
Range31477973
Interquartile range (IQR)3154762.2

Descriptive statistics

Standard deviation6882978.1
Coefficient of variation (CV)0.0022805979
Kurtosis1.8176083
Mean3.0180585 × 109
Median Absolute Deviation (MAD)1546954
Skewness0.18819983
Sum9.0541756 × 1010
Variance4.7375388 × 1013
MonotonicityNot monotonic
2024-03-13T20:45:43.733921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
3019475088 1
 
3.3%
3019231294 1
 
3.3%
3019252119 1
 
3.3%
3019957898 1
 
3.3%
3017925863 1
 
3.3%
3017310297 1
 
3.3%
3029601325 1
 
3.3%
3018531358 1
 
3.3%
3017820944 1
 
3.3%
3016381180 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
3002810207 1
3.3%
3004081151 1
3.3%
3005889180 1
3.3%
3011380141 1
3.3%
3012917111 1
3.3%
3015191117 1
3.3%
3016381180 1
3.3%
3016643695 1
3.3%
3016798648 1
3.3%
3017310297 1
3.3%
ValueCountFrequency (%)
3034288180 1
3.3%
3034200282 1
3.3%
3029601325 1
3.3%
3023132223 1
3.3%
3020926906 1
3.3%
3020256985 1
3.3%
3020116104 1
3.3%
3019957898 1
3.3%
3019475088 1
3.3%
3019337136 1
3.3%

가맹점번호
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
999999999999999
30 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
999999999999999 30
100.0%

Length

2024-03-13T20:45:43.937059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:45:44.042718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
999999999999999 30
100.0%

성별코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
F
22 
M
8 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowM
2nd rowM
3rd rowF
4th rowM
5th rowF

Common Values

ValueCountFrequency (%)
F 22
73.3%
M 8
 
26.7%

Length

2024-03-13T20:45:44.166523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:45:44.291845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 22
73.3%
m 8
 
26.7%

연령대코드
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.333333
Minimum0
Maximum70
Zeros10
Zeros (%)33.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:45:44.392350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median25
Q347.5
95-th percentile55.5
Maximum70
Range70
Interquartile range (IQR)47.5

Descriptive statistics

Standard deviation22.358109
Coefficient of variation (CV)0.84904213
Kurtosis-1.3351535
Mean26.333333
Median Absolute Deviation (MAD)25
Skewness0.098979219
Sum790
Variance499.88506
MonotonicityNot monotonic
2024-03-13T20:45:44.552531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 10
33.3%
50 6
20.0%
20 5
16.7%
40 5
16.7%
30 2
 
6.7%
70 1
 
3.3%
60 1
 
3.3%
ValueCountFrequency (%)
0 10
33.3%
20 5
16.7%
30 2
 
6.7%
40 5
16.7%
50 6
20.0%
60 1
 
3.3%
70 1
 
3.3%
ValueCountFrequency (%)
70 1
 
3.3%
60 1
 
3.3%
50 6
20.0%
40 5
16.7%
30 2
 
6.7%
20 5
16.7%
0 10
33.3%

결제상품ID
Real number (ℝ)

Distinct19
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4000008 × 1011
Minimum1.4000002 × 1011
Maximum1.4000013 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:45:44.718182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.4000002 × 1011
5-th percentile1.4000003 × 1011
Q11.4000005 × 1011
median1.4000009 × 1011
Q31.4000012 × 1011
95-th percentile1.4000013 × 1011
Maximum1.4000013 × 1011
Range110000
Interquartile range (IQR)70000

Descriptive statistics

Standard deviation36542.779
Coefficient of variation (CV)2.610197 × 10-7
Kurtosis-1.2921382
Mean1.4000008 × 1011
Median Absolute Deviation (MAD)32000
Skewness-0.37523316
Sum4.2000025 × 1012
Variance1.3353747 × 109
MonotonicityNot monotonic
2024-03-13T20:45:44.881148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
140000116000 4
13.3%
140000126000 4
13.3%
140000038000 2
 
6.7%
140000044000 2
 
6.7%
140000046000 2
 
6.7%
140000092000 2
 
6.7%
140000124000 2
 
6.7%
140000120000 1
 
3.3%
140000086000 1
 
3.3%
140000088000 1
 
3.3%
Other values (9) 9
30.0%
ValueCountFrequency (%)
140000016000 1
3.3%
140000018000 1
3.3%
140000038000 2
6.7%
140000040000 1
3.3%
140000044000 2
6.7%
140000046000 2
6.7%
140000060000 1
3.3%
140000064000 1
3.3%
140000076000 1
3.3%
140000084000 1
3.3%
ValueCountFrequency (%)
140000126000 4
13.3%
140000124000 2
6.7%
140000120000 1
 
3.3%
140000116000 4
13.3%
140000104000 1
 
3.3%
140000100000 1
 
3.3%
140000092000 2
6.7%
140000088000 1
 
3.3%
140000086000 1
 
3.3%
140000084000 1
 
3.3%

결제상품명
Text

Distinct19
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T20:45:45.094968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length13
Mean length8.5666667
Min length4

Characters and Unicode

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

Unique

Unique12 ?
Unique (%)40.0%

Sample

1st row양평통보
2nd row양평통보
3rd row여주사랑카드
4th row행복화성지역화폐
5th row용인와이페이(통합)
ValueCountFrequency (%)
행복화성지역화폐 4
 
10.3%
수원페이 4
 
10.3%
안산사랑상품권 3
 
7.7%
양평통보 2
 
5.1%
다온 2
 
5.1%
오산화폐 2
 
5.1%
오색전 2
 
5.1%
용인와이페이 2
 
5.1%
행복화성지역화폐(통합 2
 
5.1%
다온(통합 1
 
2.6%
Other values (15) 15
38.5%
2024-03-13T20:45:45.488603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
화 17
 
6.6%
이 14
 
5.4%
통 12
 
4.7%
( 11
 
4.3%
폐 11
 
4.3%
) 11
 
4.3%
합 10
 
3.9%
페 10
 
3.9%
9
 
3.5%
랑 8
 
3.1%
Other values (50) 144
56.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 208
80.9%
Open Punctuation 11
 
4.3%
Close Punctuation 11
 
4.3%
Lowercase Letter 10
 
3.9%
Space Separator 9
 
3.5%
Uppercase Letter 7
 
2.7%
Dash Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
화 17
 
8.2%
이 14
 
6.7%
통 12
 
5.8%
폐 11
 
5.3%
합 10
 
4.8%
페 10
 
4.8%
랑 8
 
3.8%
사 8
 
3.8%
지 7
 
3.4%
역 7
 
3.4%
Other values (34) 104
50.0%
Lowercase Letter
ValueCountFrequency (%)
a 3
30.0%
y 2
20.0%
u 1
 
10.0%
o 1
 
10.0%
k 1
 
10.0%
n 1
 
10.0%
h 1
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
P 3
42.9%
N 1
 
14.3%
G 1
 
14.3%
Y 1
 
14.3%
T 1
 
14.3%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 208
80.9%
Common 32
 
12.5%
Latin 17
 
6.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
화 17
 
8.2%
이 14
 
6.7%
통 12
 
5.8%
폐 11
 
5.3%
합 10
 
4.8%
페 10
 
4.8%
랑 8
 
3.8%
사 8
 
3.8%
지 7
 
3.4%
역 7
 
3.4%
Other values (34) 104
50.0%
Latin
ValueCountFrequency (%)
a 3
17.6%
P 3
17.6%
y 2
11.8%
N 1
 
5.9%
G 1
 
5.9%
u 1
 
5.9%
o 1
 
5.9%
Y 1
 
5.9%
k 1
 
5.9%
n 1
 
5.9%
Other values (2) 2
11.8%
Common
ValueCountFrequency (%)
( 11
34.4%
) 11
34.4%
9
28.1%
- 1
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 208
80.9%
ASCII 49
 
19.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
화 17
 
8.2%
이 14
 
6.7%
통 12
 
5.8%
폐 11
 
5.3%
합 10
 
4.8%
페 10
 
4.8%
랑 8
 
3.8%
사 8
 
3.8%
지 7
 
3.4%
역 7
 
3.4%
Other values (34) 104
50.0%
ASCII
ValueCountFrequency (%)
( 11
22.4%
) 11
22.4%
9
18.4%
a 3
 
6.1%
P 3
 
6.1%
y 2
 
4.1%
N 1
 
2.0%
G 1
 
2.0%
u 1
 
2.0%
- 1
 
2.0%
Other values (6) 6
12.2%

가맹점업종명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

가맹점우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

시도명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

시군구명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

읍면동명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

위도
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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 30
100.0%

Length

2024-03-13T20:45:45.667341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:45:45.806342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

경도
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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 30
100.0%

Length

2024-03-13T20:45:45.957703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:45:46.106261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

사용여부
Boolean

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size162.0 B
False
30 
ValueCountFrequency (%)
False 30
100.0%
2024-03-13T20:45:46.224268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

결제금액
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

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 30
100.0%

Length

2024-03-13T20:45:46.332723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:45:46.430946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

Interactions

2024-03-13T20:45:41.428006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:40.821548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.133111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.553741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:40.920079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.228717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.684458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.044842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:45:41.322527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:45:46.510258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카드번호회원코드성별코드연령대코드결제상품ID결제상품명
카드번호1.0001.0001.0001.0001.0001.000
회원코드1.0001.0000.0000.1420.0000.309
성별코드1.0000.0001.0000.5250.1180.819
연령대코드1.0000.1420.5251.0000.0000.822
결제상품ID1.0000.0000.1180.0001.0001.000
결제상품명1.0000.3090.8190.8221.0001.000
2024-03-13T20:45:46.633630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회원코드연령대코드결제상품ID성별코드
회원코드1.0000.1190.1090.000
연령대코드0.1191.000-0.1440.506
결제상품ID0.109-0.1441.0000.141
성별코드0.0000.5060.1411.000

Missing values

2024-03-13T20:45:41.866213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:45:42.127237image/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

정책주간결제시작일자정책주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
02023-11-062023-11-129H23NCRrswE6A4Tp95MaTHHvvawxRBG+YWbPp5ICLQ8=3019475088999999999999999M50140000038000양평통보<NA><NA><NA><NA><NA>00N0
12023-11-062023-11-129HBKuv6TxqdCfCyLdAsEv4K2/I1y4lMvu8HXJkG2dQM=3020116104999999999999999M50140000038000양평통보<NA><NA><NA><NA><NA>00N0
22023-11-062023-11-129HZNbHBS9A0HC32CISAYYCT1JmXRjAY0j3UgidqEeFw=3004081151999999999999999F20140000040000여주사랑카드<NA><NA><NA><NA><NA>00N0
32023-11-062023-11-129HCgKSLd3cPFlRLaKL1RjTNBRzwIsgB2oXF9KR6XE9Y=3023132223999999999999999M40140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
42023-11-062023-11-129HHsyNnWh5Y0D+F7htaMr4O2HLkUswHxqN1zZdAuKtM=3002810207999999999999999F0140000064000용인와이페이(통합)<NA><NA><NA><NA><NA>00N0
52023-11-062023-11-129HeM7suVFWhjBk/qUDiGyzj0PXkL7vsfwzyL0YxulB4=3034288180999999999999999M40140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
62023-11-062023-11-129I5HaDt1myWlxpm+Rynz8EL7nvPtkJgZL9+NDXN8rxY=3016798648999999999999999F0140000044000오산화폐 오색전<NA><NA><NA><NA><NA>00N0
72023-11-062023-11-129HfXmqrieUKRPPqg4e4T8Utu+P31vSfS40DXJwv2VwU=3018011544999999999999999F40140000044000오산화폐 오색전<NA><NA><NA><NA><NA>00N0
82023-11-062023-11-129HUhGC/EWQjpVp4QNsPPTUuV48UNbjPMf/uSjSwfQrE=3019337136999999999999999F0140000060000이천사랑지역화폐(통합)<NA><NA><NA><NA><NA>00N0
92023-11-062023-11-129HhW/neDlWaizY3uVvGlIdZlgQR67ZQ9ykL4l55dC4A=3020256985999999999999999M30140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
정책주간결제시작일자정책주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
202023-11-062023-11-129HtQ1MBoOQB8jwPiK3AKBObd+DhDauHUrneFeXfFI1Y=3017452607999999999999999F20140000124000안산사랑상품권 다온<NA><NA><NA><NA><NA>00N0
212023-11-062023-11-129IWZQMwWdRAEQnEqxwfPg4LLsx0psgjcQr6W/HPhUm4=3020926906999999999999999F0140000126000수원페이<NA><NA><NA><NA><NA>00N0
222023-11-062023-11-129K4Ru4RqkShWvb/Xe276l6MvjyIxhAMeZdIXgcS3V4M=3016381180999999999999999F40140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
232023-11-062023-11-129IZj3MzOjy7PzWJ10kAidQnwMMV1jHd/GYyj5Tns2Y8=3017820944999999999999999M60140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
242023-11-062023-11-129Hv25gviwzD9U+NRHNPQH6HgOrYY8uyHyjYt99bg32s=3018531358999999999999999M50140000084000광주사랑카드(통합)<NA><NA><NA><NA><NA>00N0
252023-11-062023-11-129Ie0i7VMb9bptx11jgTZ01xhnMKVvG16VL9TQdGUuew=3029601325999999999999999F0140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
262023-11-062023-11-129KohkLPSnvTfW/hObdis+lO97GxEdQK+HQ4sfJpXW/8=3017310297999999999999999F0140000018000고양페이카드<NA><NA><NA><NA><NA>00N0
272023-11-062023-11-129IegbBpb6hwLIsEb3QRJqYxruLSuUlkIhzZX3I45uVg=3017925863999999999999999F0140000126000수원페이<NA><NA><NA><NA><NA>00N0
282023-11-062023-11-129KrWxNu5xb7HCEpS9TGbn9P1JxJfnOFyWj5hp+TIr84=3019957898999999999999999F50140000088000광명사랑화폐(통합)<NA><NA><NA><NA><NA>00N0
292023-11-062023-11-129IkaxnZt/+QcQi86QUqDbXgAofg7Bm3x49BKcGXb2OA=3019252119999999999999999F50140000086000과천화폐 과천토리(통합)<NA><NA><NA><NA><NA>00N0