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

Categorical7
Text2
Numeric3
Unsupported5
Boolean1

Dataset

Description샘플 데이터
Author코나아이㈜
URLhttps://bigdata-region.kr/#/dataset/654d6523-8d55-4954-8c0e-bc63b4f831e0

Alerts

정책주간결제시작일자 has constant value ""Constant
정책주간결제종료일자 has constant value ""Constant
위도 has constant value ""Constant
경도 has constant value ""Constant
연령대코드 is highly overall correlated with 결제상품IDHigh correlation
결제상품ID is highly overall correlated with 연령대코드 and 3 other fieldsHigh correlation
가맹점번호 is highly overall correlated with 결제상품IDHigh correlation
사용여부 is highly overall correlated with 결제상품IDHigh correlation
결제금액 is highly overall correlated with 결제상품IDHigh 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 11 (36.7%) zerosZeros

Reproduction

Analysis started2024-03-13 11:47:43.381535
Analysis finished2024-03-13 11:47:45.418611
Duration2.04 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

정책주간결제시작일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-09-04
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-04
2nd row2023-09-04
3rd row2023-09-04
4th row2023-09-04
5th row2023-09-04

Common Values

ValueCountFrequency (%)
2023-09-04 30
100.0%

Length

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

Common Values (Plot)

2024-03-13T20:47:45.594612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-04 30
100.0%

정책주간결제종료일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-09-10
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-10
2nd row2023-09-10
3rd row2023-09-10
4th row2023-09-10
5th row2023-09-10

Common Values

ValueCountFrequency (%)
2023-09-10 30
100.0%

Length

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

Common Values (Plot)

2024-03-13T20:47:45.846510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-10 30
100.0%

카드번호
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-03-13T20:47:46.066931image/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 row0hE9vrmEaalq/iLmqFIPoKo5KGy09iiBiKakeA9dsfY=
2nd rowDoVHPpVu364xEncNJOyETouIvctv6eVXPM6itlQFo88=
3rd row0hFzE667QlJXje8IYKjA/FLMxQxAOGEhq5VgBQPWe78=
4th rowmhiEkxx187DCPdZKK4K1BPk95IlSNW0Mu6vI4OpggnM=
5th row0hGK0V62d2l/kJz0VHugo+OgHCB3ZsgQXZftichd008=
ValueCountFrequency (%)
0he9vrmeaalq/ilmqfipoko5kgy09iibikakea9dsfy 1
 
3.3%
dovhppvu364xencnjoyetouivctv6evxpm6itlqfo88 1
 
3.3%
0heuytffvxferdsuhxu0ltbmszy3pbd3pb5efgvphwm 1
 
3.3%
mi5duo6d4pc0l4f9ft/idmsnwzvxxj4uooj5kcnuj7c 1
 
3.3%
0hejgd7xuqrv99fnzy7sxo/zp70figmwqpxgu1yahcu 1
 
3.3%
mi2kdeikf8bwgcboz0r0b4awwz6vccg8gyjmzep8awu 1
 
3.3%
0hb0ogrldbb5whgqrybz2/ihwxwgdlrsq2x49hcnsn8 1
 
3.3%
mi/y3dhs+b7nulkv5guopfoljbs693cicdppuzzrxdu 1
 
3.3%
0hztweeciusoln8munauajyuahk1h8si1hncm96ffao 1
 
3.3%
mhyst6yf9ka6puladkump6qeakqqydo2pwovs2cer6u 1
 
3.3%
Other values (20) 20
66.7%
2024-03-13T20:47:46.437829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 42
 
3.2%
h 39
 
3.0%
m 33
 
2.5%
= 30
 
2.3%
I 27
 
2.0%
2 26
 
2.0%
9 25
 
1.9%
a 25
 
1.9%
s 25
 
1.9%
K 24
 
1.8%
Other values (55) 1024
77.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 531
40.2%
Uppercase Letter 513
38.9%
Decimal Number 216
16.4%
Math Symbol 41
 
3.1%
Other Punctuation 19
 
1.4%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
h 39
 
7.3%
m 33
 
6.2%
a 25
 
4.7%
s 25
 
4.7%
g 24
 
4.5%
k 23
 
4.3%
q 22
 
4.1%
y 22
 
4.1%
i 22
 
4.1%
l 22
 
4.1%
Other values (16) 274
51.6%
Uppercase Letter
ValueCountFrequency (%)
I 27
 
5.3%
K 24
 
4.7%
E 24
 
4.7%
N 24
 
4.7%
T 23
 
4.5%
W 23
 
4.5%
Z 22
 
4.3%
F 22
 
4.3%
P 21
 
4.1%
O 20
 
3.9%
Other values (16) 283
55.2%
Decimal Number
ValueCountFrequency (%)
0 42
19.4%
2 26
12.0%
9 25
11.6%
6 24
11.1%
8 20
9.3%
4 19
8.8%
5 16
 
7.4%
1 16
 
7.4%
7 15
 
6.9%
3 13
 
6.0%
Math Symbol
ValueCountFrequency (%)
= 30
73.2%
+ 11
 
26.8%
Other Punctuation
ValueCountFrequency (%)
/ 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1044
79.1%
Common 276
 
20.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
h 39
 
3.7%
m 33
 
3.2%
I 27
 
2.6%
a 25
 
2.4%
s 25
 
2.4%
K 24
 
2.3%
E 24
 
2.3%
g 24
 
2.3%
N 24
 
2.3%
T 23
 
2.2%
Other values (42) 776
74.3%
Common
ValueCountFrequency (%)
0 42
15.2%
= 30
10.9%
2 26
9.4%
9 25
9.1%
6 24
8.7%
8 20
7.2%
/ 19
6.9%
4 19
6.9%
5 16
 
5.8%
1 16
 
5.8%
Other values (3) 39
14.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1320
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 42
 
3.2%
h 39
 
3.0%
m 33
 
2.5%
= 30
 
2.3%
I 27
 
2.0%
2 26
 
2.0%
9 25
 
1.9%
a 25
 
1.9%
s 25
 
1.9%
K 24
 
1.8%
Other values (55) 1024
77.6%

회원코드
Real number (ℝ)

UNIQUE 

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

Quantile statistics

Minimum3.003374 × 109
5-th percentile3.0092203 × 109
Q13.0166958 × 109
median3.0208738 × 109
Q33.0347605 × 109
95-th percentile3.0719759 × 109
Maximum3.1008152 × 109
Range97441200
Interquartile range (IQR)18064682

Descriptive statistics

Standard deviation21709032
Coefficient of variation (CV)0.0071659717
Kurtosis3.6289915
Mean3.0294611 × 109
Median Absolute Deviation (MAD)8751515
Skewness1.7975313
Sum9.0883832 × 1010
Variance4.7128208 × 1014
MonotonicityNot monotonic
2024-03-13T20:47:46.808393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
3012471137 1
 
3.3%
3029320346 1
 
3.3%
3029641328 1
 
3.3%
3010304119 1
 
3.3%
3016999326 1
 
3.3%
3100815163 1
 
3.3%
3021541295 1
 
3.3%
3016792258 1
 
3.3%
3018304350 1
 
3.3%
3016663624 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
3003373963 1
3.3%
3008333610 1
3.3%
3010304119 1
3.3%
3010725141 1
3.3%
3012471137 1
3.3%
3013286104 1
3.3%
3016589793 1
3.3%
3016663624 1
3.3%
3016792258 1
3.3%
3016999326 1
3.3%
ValueCountFrequency (%)
3100815163 1
3.3%
3082990597 1
3.3%
3058513500 1
3.3%
3049064351 1
3.3%
3048256366 1
3.3%
3047419398 1
3.3%
3039146795 1
3.3%
3035462192 1
3.3%
3032655282 1
3.3%
3031212170 1
3.3%

가맹점번호
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
999999999999999
29 
410686230165101
 
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 row999999999999999

Common Values

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

Length

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

Common Values (Plot)

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

성별코드
Categorical

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 rowF
2nd rowF
3rd rowM
4th rowF
5th rowF

Common Values

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

Length

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

Common Values (Plot)

2024-03-13T20:47:47.433916image/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%
Mean23.666667
Minimum0
Maximum70
Zeros11
Zeros (%)36.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:47:47.554124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median20
Q340
95-th percentile60
Maximum70
Range70
Interquartile range (IQR)40

Descriptive statistics

Standard deviation22.358109
Coefficient of variation (CV)0.94470885
Kurtosis-0.93860555
Mean23.666667
Median Absolute Deviation (MAD)20
Skewness0.45637398
Sum710
Variance499.88506
MonotonicityNot monotonic
2024-03-13T20:47:47.666637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 11
36.7%
20 6
20.0%
40 5
16.7%
30 3
 
10.0%
60 3
 
10.0%
70 1
 
3.3%
50 1
 
3.3%
ValueCountFrequency (%)
0 11
36.7%
20 6
20.0%
30 3
 
10.0%
40 5
16.7%
50 1
 
3.3%
60 3
 
10.0%
70 1
 
3.3%
ValueCountFrequency (%)
70 1
 
3.3%
60 3
 
10.0%
50 1
 
3.3%
40 5
16.7%
30 3
 
10.0%
20 6
20.0%
0 11
36.7%

결제상품ID
Real number (ℝ)

HIGH CORRELATION 

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

Quantile statistics

Minimum1.4000002 × 1011
5-th percentile1.4000002 × 1011
Q11.4000003 × 1011
median1.4000006 × 1011
Q31.400001 × 1011
95-th percentile1.4000012 × 1011
Maximum1.4000013 × 1011
Range110000
Interquartile range (IQR)71000

Descriptive statistics

Standard deviation37186.39
Coefficient of variation (CV)2.6561694 × 10-7
Kurtosis-1.602029
Mean1.4000007 × 1011
Median Absolute Deviation (MAD)36000
Skewness0.018398772
Sum4.2000021 × 1012
Variance1.3828276 × 109
MonotonicityNot monotonic
2024-03-13T20:47:47.951954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
140000102000 4
13.3%
140000028000 3
 
10.0%
140000030000 2
 
6.7%
140000016000 2
 
6.7%
140000046000 2
 
6.7%
140000084000 2
 
6.7%
140000058000 2
 
6.7%
140000114000 2
 
6.7%
140000034000 1
 
3.3%
140000120000 1
 
3.3%
Other values (9) 9
30.0%
ValueCountFrequency (%)
140000016000 2
6.7%
140000018000 1
 
3.3%
140000028000 3
10.0%
140000030000 2
6.7%
140000034000 1
 
3.3%
140000042000 1
 
3.3%
140000046000 2
6.7%
140000052000 1
 
3.3%
140000058000 2
6.7%
140000070000 1
 
3.3%
ValueCountFrequency (%)
140000126000 1
 
3.3%
140000120000 1
 
3.3%
140000116000 1
 
3.3%
140000114000 2
6.7%
140000112000 1
 
3.3%
140000102000 4
13.3%
140000100000 1
 
3.3%
140000092000 1
 
3.3%
140000084000 2
6.7%
140000070000 1
 
3.3%

결제상품명
Text

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

Length

Max length15
Median length12
Mean length8.1
Min length4

Characters and Unicode

Total characters243
Distinct characters62
Distinct categories7 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11 ?
Unique (%)36.7%

Sample

1st row부천페이
2nd row평택사랑카드(통합)
3rd row행복화성지역화폐(통합)
4th row수원페이(통합)
5th row수원페이(통합)
ValueCountFrequency (%)
수원페이(통합 4
 
11.1%
구리사랑카드 3
 
8.3%
부천페이 2
 
5.6%
용인와이페이 2
 
5.6%
thank 2
 
5.6%
you 2
 
5.6%
pay-n 2
 
5.6%
평택사랑카드(통합 2
 
5.6%
광주사랑카드(통합 2
 
5.6%
가평gp페이 2
 
5.6%
Other values (13) 13
36.1%
2024-03-13T20:47:48.548949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 16
 
6.6%
페 14
 
5.8%
( 12
 
4.9%
) 12
 
4.9%
사 12
 
4.9%
랑 12
 
4.9%
통 11
 
4.5%
합 11
 
4.5%
카 9
 
3.7%
드 9
 
3.7%
Other values (52) 125
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 180
74.1%
Lowercase Letter 18
 
7.4%
Uppercase Letter 13
 
5.3%
Open Punctuation 12
 
4.9%
Close Punctuation 12
 
4.9%
Space Separator 6
 
2.5%
Dash Punctuation 2
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 16
 
8.9%
페 14
 
7.8%
사 12
 
6.7%
랑 12
 
6.7%
통 11
 
6.1%
합 11
 
6.1%
카 9
 
5.0%
드 9
 
5.0%
수 5
 
2.8%
원 5
 
2.8%
Other values (36) 76
42.2%
Lowercase Letter
ValueCountFrequency (%)
a 5
27.8%
y 3
16.7%
h 2
 
11.1%
n 2
 
11.1%
k 2
 
11.1%
o 2
 
11.1%
u 2
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
P 5
38.5%
G 2
 
15.4%
N 2
 
15.4%
T 2
 
15.4%
Y 2
 
15.4%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 179
73.7%
Common 32
 
13.2%
Latin 31
 
12.8%
Han 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 16
 
8.9%
페 14
 
7.8%
사 12
 
6.7%
랑 12
 
6.7%
통 11
 
6.1%
합 11
 
6.1%
카 9
 
5.0%
드 9
 
5.0%
수 5
 
2.8%
원 5
 
2.8%
Other values (35) 75
41.9%
Latin
ValueCountFrequency (%)
a 5
16.1%
P 5
16.1%
y 3
9.7%
G 2
 
6.5%
N 2
 
6.5%
T 2
 
6.5%
h 2
 
6.5%
n 2
 
6.5%
k 2
 
6.5%
Y 2
 
6.5%
Other values (2) 4
12.9%
Common
ValueCountFrequency (%)
( 12
37.5%
) 12
37.5%
6
18.8%
- 2
 
6.2%
Han
ValueCountFrequency (%)
愛 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 179
73.7%
ASCII 63
 
25.9%
CJK 1
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 16
 
8.9%
페 14
 
7.8%
사 12
 
6.7%
랑 12
 
6.7%
통 11
 
6.1%
합 11
 
6.1%
카 9
 
5.0%
드 9
 
5.0%
수 5
 
2.8%
원 5
 
2.8%
Other values (35) 75
41.9%
ASCII
ValueCountFrequency (%)
( 12
19.0%
) 12
19.0%
6
9.5%
a 5
7.9%
P 5
7.9%
y 3
 
4.8%
G 2
 
3.2%
N 2
 
3.2%
T 2
 
3.2%
h 2
 
3.2%
Other values (6) 12
19.0%
CJK
ValueCountFrequency (%)
愛 1
100.0%

가맹점업종명
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:47:48.712968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

사용여부
Boolean

HIGH CORRELATION  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:47:49.123078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

결제금액
Categorical

HIGH CORRELATION  IMBALANCE 

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

Length

Max length4
Median length1
Mean length1.1
Min length1

Unique

Unique1 ?
Unique (%)3.3%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

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

Interactions

2024-03-13T20:47:44.527101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:43.886242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.212560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.653167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:43.987398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.318438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.776242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.107746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:47:44.432061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:47:49.605727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명사용여부결제금액
카드번호1.0001.0001.0001.0001.0001.0001.0001.0001.000
회원코드1.0001.0000.3990.4980.2500.0000.0000.3990.399
가맹점번호1.0000.3991.0000.0000.3471.0001.0000.6550.655
성별코드1.0000.4980.0001.0000.3920.2580.9220.0000.000
연령대코드1.0000.2500.3470.3921.0000.7520.5990.3470.347
결제상품ID1.0000.0001.0000.2580.7521.0001.0001.0001.000
결제상품명1.0000.0001.0000.9220.5991.0001.0001.0001.000
사용여부1.0000.3990.6550.0000.3471.0001.0001.0000.655
결제금액1.0000.3990.6550.0000.3471.0001.0000.6551.000
2024-03-13T20:47:49.743103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가맹점번호성별코드결제금액사용여부
가맹점번호1.0000.0000.4540.454
성별코드0.0001.0000.0000.000
결제금액0.4540.0001.0000.454
사용여부0.4540.0000.4541.000
2024-03-13T20:47:50.169235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회원코드연령대코드결제상품ID가맹점번호성별코드사용여부결제금액
회원코드1.0000.1660.1070.2670.2900.2670.267
연령대코드0.1661.000-0.5520.3270.3730.3270.327
결제상품ID0.107-0.5521.0000.8660.1200.8660.866
가맹점번호0.2670.3270.8661.0000.0000.4540.454
성별코드0.2900.3730.1200.0001.0000.0000.000
사용여부0.2670.3270.8660.4540.0001.0000.454
결제금액0.2670.3270.8660.4540.0000.4541.000

Missing values

2024-03-13T20:47:44.987136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:47:45.314692image/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-09-042023-09-100hE9vrmEaalq/iLmqFIPoKo5KGy09iiBiKakeA9dsfY=3012471137999999999999999F20140000030000부천페이<NA><NA><NA><NA><NA>00N0
12023-09-042023-09-10DoVHPpVu364xEncNJOyETouIvctv6eVXPM6itlQFo88=3039146795999999999999999F0140000058000평택사랑카드(통합)<NA><NA><NA><NA><NA>00N0
22023-09-042023-09-100hFzE667QlJXje8IYKjA/FLMxQxAOGEhq5VgBQPWe78=3010725141999999999999999M20140000092000행복화성지역화폐(통합)<NA><NA><NA><NA><NA>00N0
32023-09-042023-09-10mhiEkxx187DCPdZKK4K1BPk95IlSNW0Mu6vI4OpggnM=3035462192999999999999999F0140000102000수원페이(통합)<NA><NA><NA><NA><NA>00N0
42023-09-042023-09-100hGK0V62d2l/kJz0VHugo+OgHCB3ZsgQXZftichd008=3058513500999999999999999F30140000102000수원페이(통합)<NA><NA><NA><NA><NA>00N0
52023-09-042023-09-10mhjDg+s+cCSBjTmsYtqKmEEzQmjp3WDNqHu64RtIkg0=3018506100999999999999999F70140000018000고양페이카드<NA><NA><NA><NA><NA>00N0
62023-09-042023-09-100hICEgwZ7yxrdU2AbAq4uCF+HGTl4n9CQRtRtEdTh2I=3048256366999999999999999F20140000102000수원페이(통합)<NA><NA><NA><NA><NA>00N0
72023-09-042023-09-10DoYlWNiOuic9tvhMLUM8bRA6X9xT6A2SWIlP6oeiIOw=3013286104999999999999999F0140000126000수원페이<NA><NA><NA><NA><NA>00N0
82023-09-042023-09-100hIjdwj2rgZKBkVO38M9wmOZ5zlES3yNmguyahQW1eA=3018680009999999999999999F50140000016000가평GP페이<NA><NA><NA><NA><NA>00N0
92023-09-042023-09-10mhlxLjxtLtzKyKLaApFna9Rjls0YpJNBpzGsyk6qkVQ=3003373963999999999999999F0140000030000부천페이<NA><NA><NA><NA><NA>00N0
정책주간결제시작일자정책주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
202023-09-042023-09-100hYgVcWfM1t0/rqUqw+Rrv/VZGFiGL7epWj2laTXoXc=3020206235999999999999999M30140000028000구리사랑카드<NA><NA><NA><NA><NA>00N0
212023-09-042023-09-10mhyST6yF9KA6PuLaDkUmP6QEakqqYdO2PwOVS2cer6U=3028049178999999999999999M40140000052000포천사랑상품권<NA><NA><NA><NA><NA>00N0
222023-09-042023-09-100hZTWeEciUSoln8mUNAuaJyUaHk1h8si1HNCm96FfAo=3016663624999999999999999F40140000034000안양사랑페이<NA><NA><NA><NA><NA>00N0
232023-09-042023-09-10mi/Y3Dhs+B7nuLKV5GUOpFOLjBS693cICdPPUZzRXDU=3018304350999999999999999F0140000116000행복화성지역화폐<NA><NA><NA><NA><NA>00N0
242023-09-042023-09-100hb0OGRLdbb5WhgqRYbz2/iHWXWgdLRSq2X49HcNSN8=3016792258999999999999999F0140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
252023-09-042023-09-10mi2KdEIkf8bWGCboZ0r0b4awWZ6VccG8gyJmZEP8awU=3021541295999999999999999F20140000112000군포愛머니<NA><NA><NA><NA><NA>00N0
262023-09-042023-09-100hejgD7xUQrV99FNZy7sXO/ZP70fIgmwQpXgu1yaHCU=3100815163999999999999999M60140000042000연천사랑상품권<NA><NA><NA><NA><NA>00N0
272023-09-042023-09-10mi5DUO6D4pc0l4f9ft/IdmSnwZVXxJ4uooJ5KCNuj7c=3016999326999999999999999F0140000120000파주 Pay(파주페이)<NA><NA><NA><NA><NA>00N0
282023-09-042023-09-100heuyTffvxFErdsUhxu0ltbmSzy3PBD3pb5EFGVPHwM=3010304119999999999999999F40140000046000용인와이페이<NA><NA><NA><NA><NA>00N0
292023-09-042023-09-10miDz6cdzThKJOMtp34N1TPDk5Q2lZQvAZUpxHCpgJFk=3029641328999999999999999F20140000114000Thank You Pay-N<NA><NA><NA><NA><NA>00N0