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/d4539bcc-f48d-4b4f-908a-d4d4f99dcbfe

Alerts

정책주간결제시작일자 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
성별코드 is highly overall correlated with 회원코드 and 1 other fieldsHigh correlation
가맹점번호 is highly imbalanced (78.9%)Imbalance
사용여부 is highly imbalanced (78.9%)Imbalance
결제금액 is highly imbalanced (78.9%)Imbalance
가맹점업종명 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 15 (50.0%) zerosZeros

Reproduction

Analysis started2024-03-13 11:54:26.806594
Analysis finished2024-03-13 11:54:28.598935
Duration1.79 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-12-04 00:00:00
Maximum2023-12-04 00:00:00
2024-03-13T20:54:28.662722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:28.768478image/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-12-10 00:00:00
Maximum2023-12-10 00:00:00
2024-03-13T20:54:28.862338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:28.955304image/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:54:29.183666image/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 rowyt2js73X8FT5G6BGS/KbnMTLi2JsC4MDkGi7lj+D4+0=
2nd rowUVMIruoDkOsNxAd0XjnHidqKWwekWz+sOa61F4TsQ6g=
3rd rowyt8Tf1BVL3QEfGOAXRiSXeu8u5N1Yu3y1VipOienyBs=
4th row+Itev0tQPR4o1DiYN8hgc0SY3DuHGYbd++b4xLBYB0s=
5th rowytAGmQMvSeZ4JIpsXIHKfxyPJoOgsozCAO2Y636I7Rk=
ValueCountFrequency (%)
yt2js73x8ft5g6bgs/kbnmtli2jsc4mdkgi7lj+d4+0 1
 
3.3%
uvmiruodkosnxad0xjnhidqkwwekwz+soa61f4tsq6g 1
 
3.3%
yu0mfhbpvqffavihrmveadbg8a6ajod5gdq7mbtygno 1
 
3.3%
jhttuv0ywiz3ky4j3mbi4sswijjcdnbpguy4ia/+bu 1
 
3.3%
yu+gr/bofje2tzlkut9njvncydrom34xseuyyg5vkgk 1
 
3.3%
jbzsgaaivo9fzbqjrwqiu3zczuqfi2aqmrax8+vyca 1
 
3.3%
ytkkzgp0+owxcckpx5tjoicco8e1oidiqrrtqaxnuay 1
 
3.3%
ja5trvgrqnycnp82m8bwnawoulqlpxfbi0b3ngwkau 1
 
3.3%
ytiv0f/3km+ffoio1zl8kco5rzbmxsrhkdsy1j3jjri 1
 
3.3%
j8e3ch6y1xb0kyjfhqrlvfeqevgbzq/s2edbybzdks 1
 
3.3%
Other values (20) 20
66.7%
2024-03-13T20:54:29.537063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
+ 33
 
2.5%
J 32
 
2.4%
t 32
 
2.4%
y 32
 
2.4%
s 31
 
2.3%
Y 31
 
2.3%
= 30
 
2.3%
I 28
 
2.1%
k 28
 
2.1%
i 26
 
2.0%
Other values (55) 1017
77.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 531
40.2%
Uppercase Letter 524
39.7%
Decimal Number 188
 
14.2%
Math Symbol 63
 
4.8%
Other Punctuation 14
 
1.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
J 32
 
6.1%
Y 31
 
5.9%
I 28
 
5.3%
E 23
 
4.4%
K 22
 
4.2%
M 22
 
4.2%
Q 21
 
4.0%
V 21
 
4.0%
L 21
 
4.0%
W 21
 
4.0%
Other values (16) 282
53.8%
Lowercase Letter
ValueCountFrequency (%)
t 32
 
6.0%
y 32
 
6.0%
s 31
 
5.8%
k 28
 
5.3%
i 26
 
4.9%
b 24
 
4.5%
u 23
 
4.3%
g 22
 
4.1%
o 22
 
4.1%
f 22
 
4.1%
Other values (16) 269
50.7%
Decimal Number
ValueCountFrequency (%)
3 25
13.3%
4 24
12.8%
1 23
12.2%
8 21
11.2%
6 20
10.6%
0 18
9.6%
5 17
9.0%
2 15
8.0%
7 13
6.9%
9 12
6.4%
Math Symbol
ValueCountFrequency (%)
+ 33
52.4%
= 30
47.6%
Other Punctuation
ValueCountFrequency (%)
/ 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1055
79.9%
Common 265
 
20.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
J 32
 
3.0%
t 32
 
3.0%
y 32
 
3.0%
s 31
 
2.9%
Y 31
 
2.9%
I 28
 
2.7%
k 28
 
2.7%
i 26
 
2.5%
b 24
 
2.3%
E 23
 
2.2%
Other values (42) 768
72.8%
Common
ValueCountFrequency (%)
+ 33
12.5%
= 30
11.3%
3 25
9.4%
4 24
9.1%
1 23
8.7%
8 21
7.9%
6 20
7.5%
0 18
6.8%
5 17
6.4%
2 15
 
5.7%
Other values (3) 39
14.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1320
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
+ 33
 
2.5%
J 32
 
2.4%
t 32
 
2.4%
y 32
 
2.4%
s 31
 
2.3%
Y 31
 
2.3%
= 30
 
2.3%
I 28
 
2.1%
k 28
 
2.1%
i 26
 
2.0%
Other values (55) 1017
77.0%

회원코드
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

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

Quantile statistics

Minimum3.0053691 × 109
5-th percentile3.0128189 × 109
Q13.0174501 × 109
median3.0193623 × 109
Q33.0339458 × 109
95-th percentile3.0523258 × 109
Maximum3.0645825 × 109
Range59213425
Interquartile range (IQR)16495640

Descriptive statistics

Standard deviation13791348
Coefficient of variation (CV)0.0045574712
Kurtosis1.2059733
Mean3.0260965 × 109
Median Absolute Deviation (MAD)4354025.5
Skewness1.2416208
Sum9.0782896 × 1010
Variance1.9020128 × 1014
MonotonicityNot monotonic
2024-03-13T20:54:30.172798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
3045066431 1
 
3.3%
3015664167 1
 
3.3%
3024372218 1
 
3.3%
3018123994 1
 
3.3%
3045540358 1
 
3.3%
3033098159 1
 
3.3%
3017396372 1
 
3.3%
3013306195 1
 
3.3%
3064582540 1
 
3.3%
3016607205 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
3005369115 1
3.3%
3012420220 1
3.3%
3013306195 1
3.3%
3015664167 1
3.3%
3016607205 1
3.3%
3016741766 1
3.3%
3017396372 1
3.3%
3017416361 1
3.3%
3017551408 1
3.3%
3018003173 1
3.3%
ValueCountFrequency (%)
3064582540 1
3.3%
3057877505 1
3.3%
3045540358 1
3.3%
3045066431 1
3.3%
3039793630 1
3.3%
3038537166 1
3.3%
3035661268 1
3.3%
3034228298 1
3.3%
3033098159 1
3.3%
3029450247 1
3.3%

가맹점번호
Categorical

IMBALANCE 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
999999999999999
29 
410851050229801
 
1

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
999999999999999 29
96.7%
410851050229801 1
 
3.3%

Length

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

Common Values (Plot)

2024-03-13T20:54:30.425802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
999999999999999 29
96.7%
410851050229801 1
 
3.3%

성별코드
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
F 26
86.7%
M 4
 
13.3%

Length

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

Common Values (Plot)

2024-03-13T20:54:30.680431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 26
86.7%
m 4
 
13.3%

연령대코드
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.666667
Minimum0
Maximum70
Zeros15
Zeros (%)50.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:54:30.770616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median10
Q350
95-th percentile65.5
Maximum70
Range70
Interquartile range (IQR)50

Descriptive statistics

Standard deviation26.252531
Coefficient of variation (CV)1.1581999
Kurtosis-1.3511479
Mean22.666667
Median Absolute Deviation (MAD)10
Skewness0.58306268
Sum680
Variance689.1954
MonotonicityNot monotonic
2024-03-13T20:54:30.876060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 15
50.0%
50 4
 
13.3%
20 4
 
13.3%
60 3
 
10.0%
70 2
 
6.7%
40 2
 
6.7%
ValueCountFrequency (%)
0 15
50.0%
20 4
 
13.3%
40 2
 
6.7%
50 4
 
13.3%
60 3
 
10.0%
70 2
 
6.7%
ValueCountFrequency (%)
70 2
 
6.7%
60 3
 
10.0%
50 4
 
13.3%
40 2
 
6.7%
20 4
 
13.3%
0 15
50.0%

결제상품ID
Real number (ℝ)

Distinct23
Distinct (%)76.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4000007 × 1011
Minimum1.4000002 × 1011
Maximum1.4000014 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:54:31.005924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.4000002 × 1011
5-th percentile1.4000002 × 1011
Q11.4000004 × 1011
median1.4000007 × 1011
Q31.4000012 × 1011
95-th percentile1.4000013 × 1011
Maximum1.4000014 × 1011
Range122000
Interquartile range (IQR)78500

Descriptive statistics

Standard deviation39318.096
Coefficient of variation (CV)2.808434 × 10-7
Kurtosis-1.4089786
Mean1.4000007 × 1011
Median Absolute Deviation (MAD)36000
Skewness0.21489056
Sum4.2000022 × 1012
Variance1.5459126 × 109
MonotonicityNot monotonic
2024-03-13T20:54:31.133846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
140000046000 3
 
10.0%
140000072000 2
 
6.7%
140000058000 2
 
6.7%
140000028000 2
 
6.7%
140000018000 2
 
6.7%
140000120000 2
 
6.7%
140000032000 1
 
3.3%
140000090000 1
 
3.3%
140000052000 1
 
3.3%
140000116000 1
 
3.3%
Other values (13) 13
43.3%
ValueCountFrequency (%)
140000018000 2
6.7%
140000022000 1
 
3.3%
140000024000 1
 
3.3%
140000028000 2
6.7%
140000032000 1
 
3.3%
140000034000 1
 
3.3%
140000046000 3
10.0%
140000052000 1
 
3.3%
140000058000 2
6.7%
140000060000 1
 
3.3%
ValueCountFrequency (%)
140000140000 1
3.3%
140000126000 1
3.3%
140000124000 1
3.3%
140000122000 1
3.3%
140000120000 2
6.7%
140000118000 1
3.3%
140000116000 1
3.3%
140000114000 1
3.3%
140000100000 1
3.3%
140000090000 1
3.3%

결제상품명
Text

Distinct23
Distinct (%)76.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T20:54:31.329708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length8.4333333
Min length4

Characters and Unicode

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

Unique

Unique17 ?
Unique (%)56.7%

Sample

1st row양평통보(통합)
2nd row용인와이페이
3rd row평택사랑카드(통합)
4th row하남하머니
5th row이천사랑지역화폐(통합)
ValueCountFrequency (%)
용인와이페이 3
 
8.1%
파주 2
 
5.4%
pay(파주페이 2
 
5.4%
고양페이카드 2
 
5.4%
평택사랑카드(통합 2
 
5.4%
양평통보(통합 2
 
5.4%
구리사랑카드 2
 
5.4%
안산사랑상품권 2
 
5.4%
수원페이 1
 
2.7%
과천토리 1
 
2.7%
Other values (18) 18
48.6%
2024-03-13T20:54:31.693705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 15
 
5.9%
사 14
 
5.5%
랑 14
 
5.5%
카 12
 
4.7%
드 12
 
4.7%
) 11
 
4.3%
( 11
 
4.3%
통 11
 
4.3%
페 10
 
4.0%
합 9
 
3.6%
Other values (55) 134
53.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 204
80.6%
Lowercase Letter 12
 
4.7%
Close Punctuation 11
 
4.3%
Open Punctuation 11
 
4.3%
Space Separator 7
 
2.8%
Uppercase Letter 6
 
2.4%
Dash Punctuation 1
 
0.4%
Connector Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 15
 
7.4%
사 14
 
6.9%
랑 14
 
6.9%
카 12
 
5.9%
드 12
 
5.9%
통 11
 
5.4%
페 10
 
4.9%
합 9
 
4.4%
양 7
 
3.4%
화 7
 
3.4%
Other values (39) 93
45.6%
Lowercase Letter
ValueCountFrequency (%)
a 4
33.3%
y 3
25.0%
u 1
 
8.3%
k 1
 
8.3%
o 1
 
8.3%
n 1
 
8.3%
h 1
 
8.3%
Uppercase Letter
ValueCountFrequency (%)
P 3
50.0%
N 1
 
16.7%
Y 1
 
16.7%
T 1
 
16.7%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 204
80.6%
Common 31
 
12.3%
Latin 18
 
7.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 15
 
7.4%
사 14
 
6.9%
랑 14
 
6.9%
카 12
 
5.9%
드 12
 
5.9%
통 11
 
5.4%
페 10
 
4.9%
합 9
 
4.4%
양 7
 
3.4%
화 7
 
3.4%
Other values (39) 93
45.6%
Latin
ValueCountFrequency (%)
a 4
22.2%
y 3
16.7%
P 3
16.7%
u 1
 
5.6%
N 1
 
5.6%
k 1
 
5.6%
o 1
 
5.6%
Y 1
 
5.6%
n 1
 
5.6%
h 1
 
5.6%
Common
ValueCountFrequency (%)
) 11
35.5%
( 11
35.5%
7
22.6%
- 1
 
3.2%
_ 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 204
80.6%
ASCII 49
 
19.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 15
 
7.4%
사 14
 
6.9%
랑 14
 
6.9%
카 12
 
5.9%
드 12
 
5.9%
통 11
 
5.4%
페 10
 
4.9%
합 9
 
4.4%
양 7
 
3.4%
화 7
 
3.4%
Other values (39) 93
45.6%
ASCII
ValueCountFrequency (%)
) 11
22.4%
( 11
22.4%
7
14.3%
a 4
 
8.2%
y 3
 
6.1%
P 3
 
6.1%
u 1
 
2.0%
N 1
 
2.0%
- 1
 
2.0%
k 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:54:31.868257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:54:31.977995image/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:54:32.130313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

사용여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size162.0 B
False
29 
True
 
1
ValueCountFrequency (%)
False 29
96.7%
True 1
 
3.3%
2024-03-13T20:54:32.358717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

결제금액
Categorical

IMBALANCE 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
29 
50000
 
1

Length

Max length5
Median length1
Mean length1.1333333
Min length1

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
0 29
96.7%
50000 1
 
3.3%

Length

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

Common Values (Plot)

2024-03-13T20:54:32.579021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 29
96.7%
50000 1
 
3.3%

Interactions

2024-03-13T20:54:27.885116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.246057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.523332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.968162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.333075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.666571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:28.078690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.429096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:54:27.793893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:54:32.645028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명사용여부결제금액
카드번호1.0001.0001.0001.0001.0001.0001.0001.0001.000
회원코드1.0001.0000.0000.8430.4670.3330.0000.0000.000
가맹점번호1.0000.0001.0000.1310.3650.0001.0000.6550.655
성별코드1.0000.8430.1311.0000.8440.3420.7560.1310.131
연령대코드1.0000.4670.3650.8441.0000.0000.7940.3650.365
결제상품ID1.0000.3330.0000.3420.0001.0001.0000.0000.000
결제상품명1.0000.0001.0000.7560.7941.0001.0001.0001.000
사용여부1.0000.0000.6550.1310.3650.0001.0001.0000.655
결제금액1.0000.0000.6550.1310.3650.0001.0000.6551.000
2024-03-13T20:54:32.781476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가맹점번호성별코드결제금액사용여부
가맹점번호1.0000.0760.4540.454
성별코드0.0761.0000.0760.076
결제금액0.4540.0761.0000.454
사용여부0.4540.0760.4541.000
2024-03-13T20:54:32.880532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회원코드연령대코드결제상품ID가맹점번호성별코드사용여부결제금액
회원코드1.0000.1950.0220.0000.5580.0000.000
연령대코드0.1951.0000.1350.2310.5990.2310.231
결제상품ID0.0220.1351.0000.0000.2590.0000.000
가맹점번호0.0000.2310.0001.0000.0760.4540.454
성별코드0.5580.5990.2590.0761.0000.0760.076
사용여부0.0000.2310.0000.4540.0761.0000.454
결제금액0.0000.2310.0000.4540.0760.4541.000

Missing values

2024-03-13T20:54:28.228373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:54:28.499094image/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-12-042023-12-10yt2js73X8FT5G6BGS/KbnMTLi2JsC4MDkGi7lj+D4+0=3045066431999999999999999F0140000072000양평통보(통합)<NA><NA><NA><NA><NA>00N0
12023-12-042023-12-10UVMIruoDkOsNxAd0XjnHidqKWwekWz+sOa61F4TsQ6g=3022937792999999999999999F50140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
22023-12-042023-12-10yt8Tf1BVL3QEfGOAXRiSXeu8u5N1Yu3y1VipOienyBs=3057877505999999999999999F70140000058000평택사랑카드(통합)<NA><NA><NA><NA><NA>00N0
32023-12-042023-12-10+Itev0tQPR4o1DiYN8hgc0SY3DuHGYbd++b4xLBYB0s=3034228298999999999999999F0140000118000하남하머니<NA><NA><NA><NA><NA>00N0
42023-12-042023-12-10ytAGmQMvSeZ4JIpsXIHKfxyPJoOgsozCAO2Y636I7Rk=3012420220410851050229801M20140000060000이천사랑지역화폐(통합)<NA><NA><NA><NA><NA>00Y50000
52023-12-042023-12-10+Iuh2t5FwQR6DHGOioX7CUsFJb0pCSdosV4vnEww2OY=3017416361999999999999999F0140000100000안산사랑상품권 다온(통합)<NA><NA><NA><NA><NA>00N0
62023-12-042023-12-10ytAnFAS5TM+82/SBLgjF1M9NHdeMGEEeE6pYwqyVj3k=3028040152999999999999999F0140000028000구리사랑카드<NA><NA><NA><NA><NA>00N0
72023-12-042023-12-10rLLeSnW8kskkE3I/PNJ2TZseeaKemSgATysIm+guj/Y=3039793630999999999999999M60140000074000양주사랑카드(통합)<NA><NA><NA><NA><NA>00N0
82023-12-042023-12-10ytHqfdqKz34/hiHOQKWfFnbMbFFobscyXUemJd49Ls8=3035661268999999999999999M20140000034000안양사랑페이<NA><NA><NA><NA><NA>00N0
92023-12-042023-12-10+J/EPZ76dYP34VqjeGVqFPZHSaetpW1EvrQNKL5P9NY=3019351231999999999999999F0140000028000구리사랑카드<NA><NA><NA><NA><NA>00N0
정책주간결제시작일자정책주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
202023-12-042023-12-10ytgH/MN3tiEpOgai0yztv6J4BxUP4wm0uGkWTMwBD6g=3018144690999999999999999F0140000114000Thank You Pay-N<NA><NA><NA><NA><NA>00N0
212023-12-042023-12-10+J8e3ch6Y1xB0KYJFhQrlvFeqEVgbZq/S2eDbybzdKs=3018455239999999999999999F50140000126000수원페이<NA><NA><NA><NA><NA>00N0
222023-12-042023-12-10ytiV0F/3km+ffOio1ZL8KCo5RzBMxsRhkdSY1J3jJrI=3016607205999999999999999F0140000120000파주 Pay(파주페이)<NA><NA><NA><NA><NA>00N0
232023-12-042023-12-10+JA5tRvGrqNYCnp82M8bwnAWOULQLPxfbI0B3nGWKAU=3064582540999999999999999M60140000072000양평통보(통합)<NA><NA><NA><NA><NA>00N0
242023-12-042023-12-10ytkkZGp0+oWxCckPx5TJoICcO8E1oidiqrrTqaxnUaY=3013306195999999999999999F70140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
252023-12-042023-12-10+JBZsgAaIVo9FZbqJRwqiu3zCZUQFi2aqMRAx8+VyCA=3017396372999999999999999F0140000052000포천사랑상품권<NA><NA><NA><NA><NA>00N0
262023-12-042023-12-10yu+gr/bOfJE2tzlkut9nJVNcYDrom34XseuyYg5VkGk=3033098159999999999999999F40140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
272023-12-042023-12-10+JHTtuv0yWiz3kY4J3MBI4sswIjjcdNBPGuY4Ia/+BU=3045540358999999999999999F0140000090000고양페이카드(통합)<NA><NA><NA><NA><NA>00N0
282023-12-042023-12-10yu0mfhBpvQffaVihrMVEadbg8A6AjoD5gdq7MbtYgNo=3018123994999999999999999F50140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
292023-12-042023-12-10+JJIBhMo3CKY9vhIP+wYSQSkaHR+8u7s9dEuLsLz8Ys=3024372218999999999999999F0140000058000평택사랑카드(통합)<NA><NA><NA><NA><NA>00N0