Overview

Dataset statistics

Number of variables18
Number of observations30
Missing cells112
Missing cells (%)20.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.6 KiB
Average record size in memory156.4 B

Variable types

Categorical8
Text5
Numeric4
Boolean1

Dataset

Description샘플 데이터
Author코나아이㈜
URLhttps://bigdata-region.kr/#/dataset/e93c3ee3-0292-42fa-acff-9a31670d315a

Alerts

일반주간결제시작일자 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 회원코드 and 3 other fieldsHigh correlation
성별코드 is highly overall correlated with 가맹점우편번호High correlation
결제상품ID is highly overall correlated with 회원코드 and 3 other fieldsHigh correlation
가맹점우편번호 is highly overall correlated with 회원코드 and 6 other fieldsHigh correlation
사용여부 is highly overall correlated with 가맹점번호 and 1 other fieldsHigh correlation
회원코드 is highly overall correlated with 결제상품ID and 2 other fieldsHigh correlation
가맹점번호 is highly overall correlated with 결제금액 and 2 other fieldsHigh correlation
연령대코드 is highly overall correlated with 결제상품ID and 2 other fieldsHigh correlation
결제금액 is highly overall correlated with 가맹점번호High correlation
위도 is highly imbalanced (78.9%)Imbalance
경도 is highly imbalanced (78.9%)Imbalance
가맹점업종명 has 25 (83.3%) missing valuesMissing
시도명 has 29 (96.7%) missing valuesMissing
시군구명 has 29 (96.7%) missing valuesMissing
읍면동명 has 29 (96.7%) missing valuesMissing
카드번호 has unique valuesUnique
결제금액 has 25 (83.3%) zerosZeros

Reproduction

Analysis started2023-12-10 13:55:24.461332
Analysis finished2023-12-10 13:55:30.096286
Duration5.63 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
2020-07-06
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-07-06
2nd row2020-07-06
3rd row2020-07-06
4th row2020-07-06
5th row2020-07-06

Common Values

ValueCountFrequency (%)
2020-07-06 30
100.0%

Length

2023-12-10T22:55:30.334682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:30.550576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-07-06 30
100.0%

일반주간결제종료일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2020-07-12
30 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-07-12
2nd row2020-07-12
3rd row2020-07-12
4th row2020-07-12
5th row2020-07-12

Common Values

ValueCountFrequency (%)
2020-07-12 30
100.0%

Length

2023-12-10T22:55:30.756433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:30.948784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-07-12 30
100.0%

카드번호
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:55:31.289705image/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 rowrZQW9QnLHdBuirupGwHJ95NcsW9u5VMasn/HH7/Qa6A=
2nd row2BiBIc7MndH0e9FjNEowiXw2nG+OVoVPWVoweXPeJRE=
3rd row1K56osTohSaArYgtvLvUGKa/VmB+Rn3UclJY7X8dizU=
4th rowS5EUUzBPWhOzc4L49VNdMMICcgQg8ipsE6ziocm/K7I=
5th rowrpH9AXa51162VRFabuVaXTniVwdzkL8sd07HeYFapFw=
ValueCountFrequency (%)
rzqw9qnlhdbuirupgwhj95ncsw9u5vmasn/hh7/qa6a 1
 
3.3%
2bibic7mndh0e9fjneowixw2ng+ovovpwvowexpejre 1
 
3.3%
m8huq0vslbg7j5ckktelhmytxazlenusymdkoimpvew 1
 
3.3%
lluz2wptlydkoiwlky5sdo5xbin+rxxcik8ijf8atpc 1
 
3.3%
kltfprg1d9b85zqnpnzfh5g3dwlwx441l4glmat6ep0 1
 
3.3%
jjkdqu2edkblksjq0zbeswglgagd4hemzmqrxcy0+be 1
 
3.3%
h+sgx9slwlrfxpdood+qv6csbfknwqkgefh0ivguwu0 1
 
3.3%
gp4fvj5luroeyn1crklsi4pj8mppn+becylezeoinws 1
 
3.3%
frobav25pnhdm0y8f/u3ojmeboxpttel/upb0kc/fok 1
 
3.3%
c+atetv+edy54/xcxhs1u9esyzmrgo2ntz6uomkap6c 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T22:55:31.882241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
l 35
 
2.7%
+ 31
 
2.3%
= 30
 
2.3%
s 29
 
2.2%
w 29
 
2.2%
B 27
 
2.0%
K 27
 
2.0%
P 26
 
2.0%
0 26
 
2.0%
i 25
 
1.9%
Other values (55) 1035
78.4%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 538
40.8%
Lowercase Letter 508
38.5%
Decimal Number 197
 
14.9%
Math Symbol 61
 
4.6%
Other Punctuation 16
 
1.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
l 35
 
6.9%
s 29
 
5.7%
w 29
 
5.7%
i 25
 
4.9%
o 25
 
4.9%
u 23
 
4.5%
g 23
 
4.5%
r 23
 
4.5%
e 22
 
4.3%
x 20
 
3.9%
Other values (16) 254
50.0%
Uppercase Letter
ValueCountFrequency (%)
B 27
 
5.0%
K 27
 
5.0%
P 26
 
4.8%
E 25
 
4.6%
L 25
 
4.6%
C 25
 
4.6%
W 24
 
4.5%
R 23
 
4.3%
S 22
 
4.1%
U 22
 
4.1%
Other values (16) 292
54.3%
Decimal Number
ValueCountFrequency (%)
0 26
13.2%
5 24
12.2%
4 24
12.2%
2 22
11.2%
7 21
10.7%
9 20
10.2%
6 19
9.6%
1 14
7.1%
3 14
7.1%
8 13
6.6%
Math Symbol
ValueCountFrequency (%)
+ 31
50.8%
= 30
49.2%
Other Punctuation
ValueCountFrequency (%)
/ 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1046
79.2%
Common 274
 
20.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
l 35
 
3.3%
s 29
 
2.8%
w 29
 
2.8%
B 27
 
2.6%
K 27
 
2.6%
P 26
 
2.5%
i 25
 
2.4%
o 25
 
2.4%
E 25
 
2.4%
L 25
 
2.4%
Other values (42) 773
73.9%
Common
ValueCountFrequency (%)
+ 31
11.3%
= 30
10.9%
0 26
9.5%
5 24
8.8%
4 24
8.8%
2 22
8.0%
7 21
7.7%
9 20
7.3%
6 19
6.9%
/ 16
 
5.8%
Other values (3) 41
15.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1320
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
l 35
 
2.7%
+ 31
 
2.3%
= 30
 
2.3%
s 29
 
2.2%
w 29
 
2.2%
B 27
 
2.0%
K 27
 
2.0%
P 26
 
2.0%
0 26
 
2.0%
i 25
 
1.9%
Other values (55) 1035
78.4%

회원코드
Real number (ℝ)

HIGH CORRELATION 

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.0086196 × 109
Minimum3.0020403 × 109
Maximum3.0267692 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:32.237663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.0020403 × 109
5-th percentile3.0020881 × 109
Q13.0021113 × 109
median3.0096656 × 109
Q33.0126641 × 109
95-th percentile3.0143299 × 109
Maximum3.0267692 × 109
Range24728903
Interquartile range (IQR)10552805

Descriptive statistics

Standard deviation5984171.7
Coefficient of variation (CV)0.0019890091
Kurtosis1.0758878
Mean3.0086196 × 109
Median Absolute Deviation (MAD)3580002.5
Skewness0.69185109
Sum9.0258588 × 1010
Variance3.5810311 × 1013
MonotonicityNot monotonic
2023-12-10T22:55:32.462711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
3007890125 2
 
6.7%
3012638118 1
 
3.3%
3012607104 1
 
3.3%
3011193111 1
 
3.3%
3013268130 1
 
3.3%
3012658124 1
 
3.3%
3012631141 1
 
3.3%
3002109590 1
 
3.3%
3012666136 1
 
3.3%
3026769206 1
 
3.3%
Other values (19) 19
63.3%
ValueCountFrequency (%)
3002040303 1
3.3%
3002086694 1
3.3%
3002089905 1
3.3%
3002090055 1
3.3%
3002109590 1
3.3%
3002110323 1
3.3%
3002110711 1
3.3%
3002111088 1
3.3%
3002112047 1
3.3%
3002114442 1
3.3%
ValueCountFrequency (%)
3026769206 1
3.3%
3014859103 1
3.3%
3013683145 1
3.3%
3013268130 1
3.3%
3013223142 1
3.3%
3012833140 1
3.3%
3012671106 1
3.3%
3012666136 1
3.3%
3012658124 1
3.3%
3012638118 1
3.3%

가맹점번호
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.3333346 × 1014
Minimum7.0615336 × 108
Maximum1 × 1015
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:32.633533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7.0615336 × 108
5-th percentile7.1037575 × 108
Q11 × 1015
median1 × 1015
Q31 × 1015
95-th percentile1 × 1015
Maximum1 × 1015
Range9.9999929 × 1014
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3.7904874 × 1014
Coefficient of variation (CV)0.45485842
Kurtosis1.6571429
Mean8.3333346 × 1014
Median Absolute Deviation (MAD)0
Skewness-1.8844151
Sum2.5000004 × 1016
Variance1.4367795 × 1029
MonotonicityNot monotonic
2023-12-10T22:55:32.784854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
999999999999999 25
83.3%
769843770 1
 
3.3%
710562692 1
 
3.3%
706153363 1
 
3.3%
793054034 1
 
3.3%
710222799 1
 
3.3%
ValueCountFrequency (%)
706153363 1
 
3.3%
710222799 1
 
3.3%
710562692 1
 
3.3%
769843770 1
 
3.3%
793054034 1
 
3.3%
999999999999999 25
83.3%
ValueCountFrequency (%)
999999999999999 25
83.3%
793054034 1
 
3.3%
769843770 1
 
3.3%
710562692 1
 
3.3%
710222799 1
 
3.3%
706153363 1
 
3.3%

성별코드
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

2023-12-10T22:55:32.947413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:33.089853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 22
73.3%
f 8
 
26.7%

연령대코드
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.666667
Minimum20
Maximum80
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:33.208079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile20
Q120
median30
Q347.5
95-th percentile70
Maximum80
Range60
Interquartile range (IQR)27.5

Descriptive statistics

Standard deviation17.564332
Coefficient of variation (CV)0.50666341
Kurtosis0.34875687
Mean34.666667
Median Absolute Deviation (MAD)10
Skewness1.0615801
Sum1040
Variance308.50575
MonotonicityNot monotonic
2023-12-10T22:55:33.356730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
20 14
46.7%
40 5
 
16.7%
50 5
 
16.7%
30 3
 
10.0%
70 2
 
6.7%
80 1
 
3.3%
ValueCountFrequency (%)
20 14
46.7%
30 3
 
10.0%
40 5
 
16.7%
50 5
 
16.7%
70 2
 
6.7%
80 1
 
3.3%
ValueCountFrequency (%)
80 1
 
3.3%
70 2
 
6.7%
50 5
 
16.7%
40 5
 
16.7%
30 3
 
10.0%
20 14
46.7%

결제상품ID
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
140000146000
18 
140000134000
12 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row140000134000
2nd row140000146000
3rd row140000146000
4th row140000146000
5th row140000146000

Common Values

ValueCountFrequency (%)
140000146000 18
60.0%
140000134000 12
40.0%

Length

2023-12-10T22:55:33.591199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:33.756821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
140000146000 18
60.0%
140000134000 12
40.0%

결제상품명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
양평농협 창립50주년 기프트카드
18 
가평사랑상품권(장병용)
12 

Length

Max length17
Median length17
Mean length15
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평사랑상품권(장병용)
2nd row양평농협 창립50주년 기프트카드
3rd row양평농협 창립50주년 기프트카드
4th row양평농협 창립50주년 기프트카드
5th row양평농협 창립50주년 기프트카드

Common Values

ValueCountFrequency (%)
양평농협 창립50주년 기프트카드 18
60.0%
가평사랑상품권(장병용) 12
40.0%

Length

2023-12-10T22:55:33.939764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:34.099014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양평농협 18
27.3%
창립50주년 18
27.3%
기프트카드 18
27.3%
가평사랑상품권(장병용 12
18.2%

가맹점업종명
Text

MISSING 

Distinct3
Distinct (%)60.0%
Missing25
Missing (%)83.3%
Memory size372.0 B
2023-12-10T22:55:34.303543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.6
Min length4

Characters and Unicode

Total characters28
Distinct characters14
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)20.0%

Sample

1st row음료식품
2nd row유통업 영리
3rd row일반휴게음식
4th row일반휴게음식
5th row유통업 영리
ValueCountFrequency (%)
유통업 2
28.6%
영리 2
28.6%
일반휴게음식 2
28.6%
음료식품 1
14.3%
2023-12-10T22:55:34.961185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
음 3
10.7%
식 3
10.7%
유 2
 
7.1%
통 2
 
7.1%
업 2
 
7.1%
2
 
7.1%
영 2
 
7.1%
리 2
 
7.1%
일 2
 
7.1%
반 2
 
7.1%
Other values (4) 6
21.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 26
92.9%
Space Separator 2
 
7.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
음 3
11.5%
식 3
11.5%
유 2
7.7%
통 2
7.7%
업 2
7.7%
영 2
7.7%
리 2
7.7%
일 2
7.7%
반 2
7.7%
휴 2
7.7%
Other values (3) 4
15.4%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 26
92.9%
Common 2
 
7.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
음 3
11.5%
식 3
11.5%
유 2
7.7%
통 2
7.7%
업 2
7.7%
영 2
7.7%
리 2
7.7%
일 2
7.7%
반 2
7.7%
휴 2
7.7%
Other values (3) 4
15.4%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 26
92.9%
ASCII 2
 
7.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
음 3
11.5%
식 3
11.5%
유 2
7.7%
통 2
7.7%
업 2
7.7%
영 2
7.7%
리 2
7.7%
일 2
7.7%
반 2
7.7%
휴 2
7.7%
Other values (3) 4
15.4%
ASCII
ValueCountFrequency (%)
2
100.0%

가맹점우편번호
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
<NA>
25 
12438
3 
12419
 
2

Length

Max length5
Median length4
Mean length4.1666667
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 25
83.3%
12438 3
 
10.0%
12419 2
 
6.7%

Length

2023-12-10T22:55:35.202223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:35.370185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 25
83.3%
12438 3
 
10.0%
12419 2
 
6.7%

시도명
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing29
Missing (%)96.7%
Memory size372.0 B
2023-12-10T22:55:35.519040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters3
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row경기도
ValueCountFrequency (%)
경기도 1
100.0%
2023-12-10T22:55:36.013001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
경 1
33.3%
기 1
33.3%
도 1
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 1
33.3%
기 1
33.3%
도 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 1
33.3%
기 1
33.3%
도 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
경 1
33.3%
기 1
33.3%
도 1
33.3%

시군구명
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing29
Missing (%)96.7%
Memory size372.0 B
2023-12-10T22:55:36.289625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters3
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row가평군
ValueCountFrequency (%)
가평군 1
100.0%
2023-12-10T22:55:37.065735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
가 1
33.3%
평 1
33.3%
군 1
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
가 1
33.3%
평 1
33.3%
군 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
가 1
33.3%
평 1
33.3%
군 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
가 1
33.3%
평 1
33.3%
군 1
33.3%

읍면동명
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing29
Missing (%)96.7%
Memory size372.0 B
2023-12-10T22:55:37.244885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters3
Distinct characters3
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row조종면
ValueCountFrequency (%)
조종면 1
100.0%
2023-12-10T22:55:37.647649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
조 1
33.3%
종 1
33.3%
면 1
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
조 1
33.3%
종 1
33.3%
면 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
조 1
33.3%
종 1
33.3%
면 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
조 1
33.3%
종 1
33.3%
면 1
33.3%

위도
Categorical

IMBALANCE 

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

Length

Max length6
Median length3
Mean length3.1
Min length3

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row37.818
2nd row0.0
3rd row0.0
4th row0.0
5th row0.0

Common Values

ValueCountFrequency (%)
0.0 29
96.7%
37.818 1
 
3.3%

Length

2023-12-10T22:55:37.886007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:38.060472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.0 29
96.7%
37.818 1
 
3.3%

경도
Categorical

IMBALANCE 

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

Length

Max length7
Median length3
Mean length3.1333333
Min length3

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row127.349
2nd row0.0
3rd row0.0
4th row0.0
5th row0.0

Common Values

ValueCountFrequency (%)
0.0 29
96.7%
127.349 1
 
3.3%

Length

2023-12-10T22:55:38.252445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:55:38.454380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.0 29
96.7%
127.349 1
 
3.3%

사용여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size162.0 B
False
25 
True
5 
ValueCountFrequency (%)
False 25
83.3%
True 5
 
16.7%
2023-12-10T22:55:38.602308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

결제금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6835
Minimum0
Maximum181500
Zeros25
Zeros (%)83.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:38.745015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile7352.5
Maximum181500
Range181500
Interquartile range (IQR)0

Descriptive statistics

Standard deviation33059.719
Coefficient of variation (CV)4.836828
Kurtosis29.716065
Mean6835
Median Absolute Deviation (MAD)0
Skewness5.4403607
Sum205050
Variance1.092945 × 109
MonotonicityNot monotonic
2023-12-10T22:55:38.926764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 25
83.3%
7600 1
 
3.3%
7050 1
 
3.3%
2500 1
 
3.3%
6400 1
 
3.3%
181500 1
 
3.3%
ValueCountFrequency (%)
0 25
83.3%
2500 1
 
3.3%
6400 1
 
3.3%
7050 1
 
3.3%
7600 1
 
3.3%
181500 1
 
3.3%
ValueCountFrequency (%)
181500 1
 
3.3%
7600 1
 
3.3%
7050 1
 
3.3%
6400 1
 
3.3%
2500 1
 
3.3%
0 25
83.3%

Interactions

2023-12-10T22:55:27.969927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:25.786423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.534868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:27.144665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:28.203299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:25.959485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.657830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:27.307817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:28.383421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.149137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.780041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:27.562029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:28.570250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.386214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:26.946204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:27.804303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:55:39.108416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호위도경도사용여부결제금액
카드번호1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
회원코드1.0001.0000.6300.5890.8740.9960.996NaNNaN0.0000.0000.7050.000
가맹점번호1.0000.6301.0000.0000.2390.5500.550NaNNaN0.1120.1120.9720.112
성별코드1.0000.5890.0001.0000.3290.5610.561NaNNaN0.0000.0000.0000.000
연령대코드1.0000.8740.2390.3291.0000.9700.970NaNNaN0.0000.0000.3790.000
결제상품ID1.0000.9960.5500.5610.9701.0000.994NaNNaN0.0000.0000.6200.000
결제상품명1.0000.9960.5500.5610.9700.9941.000NaNNaN0.0000.0000.6200.000
가맹점업종명1.000NaNNaNNaNNaNNaNNaN1.0000.0001.0001.000NaN0.000
가맹점우편번호1.000NaNNaNNaNNaNNaNNaN0.0001.0000.0000.000NaN0.000
위도1.0000.0000.1120.0000.0000.0000.0001.0000.0001.0000.6550.0000.000
경도1.0000.0000.1120.0000.0000.0000.0001.0000.0000.6551.0000.0000.000
사용여부1.0000.7050.9720.0000.3790.6200.620NaNNaN0.0000.0001.0000.000
결제금액1.0000.0000.1120.0000.0000.0000.0000.0000.0000.0000.0000.0001.000
2023-12-10T22:55:39.402254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경도결제상품명위도성별코드결제상품ID가맹점우편번호사용여부
경도1.0000.0000.4540.0000.0000.0000.000
결제상품명0.0001.0000.0000.3780.9281.0000.424
위도0.4540.0001.0000.0000.0000.0000.000
성별코드0.0000.3780.0001.0000.3781.0000.000
결제상품ID0.0000.9280.0000.3781.0001.0000.424
가맹점우편번호0.0001.0000.0001.0001.0001.0001.000
사용여부0.0000.4240.0000.0000.4241.0001.000
2023-12-10T22:55:39.637687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회원코드가맹점번호연령대코드결제금액성별코드결제상품ID결제상품명가맹점우편번호위도경도사용여부
회원코드1.000-0.366-0.4740.3740.3540.8720.8721.0000.0000.0000.486
가맹점번호-0.3661.0000.436-0.9880.0000.4240.4241.0000.0000.0000.875
연령대코드-0.4740.4361.000-0.4360.2060.7810.7811.0000.0000.0000.241
결제금액0.374-0.988-0.4361.0000.0000.0000.0000.0000.0000.0000.000
성별코드0.3540.0000.2060.0001.0000.3780.3781.0000.0000.0000.000
결제상품ID0.8720.4240.7810.0000.3781.0000.9281.0000.0000.0000.424
결제상품명0.8720.4240.7810.0000.3780.9281.0001.0000.0000.0000.424
가맹점우편번호1.0001.0001.0000.0001.0001.0001.0001.0000.0000.0001.000
위도0.0000.0000.0000.0000.0000.0000.0000.0001.0000.4540.000
경도0.0000.0000.0000.0000.0000.0000.0000.0000.4541.0000.000
사용여부0.4860.8750.2410.0000.0000.4240.4241.0000.0000.0001.000

Missing values

2023-12-10T22:55:28.875434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:55:29.651808image/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.
2023-12-10T22:55:29.979993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

일반주간결제시작일자일반주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
02020-07-062020-07-12rZQW9QnLHdBuirupGwHJ95NcsW9u5VMasn/HH7/Qa6A=3012638118769843770M20140000134000가평사랑상품권(장병용)음료식품12438경기도가평군조종면37.818127.349Y7600
12020-07-062020-07-122BiBIc7MndH0e9FjNEowiXw2nG+OVoVPWVoweXPeJRE=3011376245999999999999999F70140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
22020-07-062020-07-121K56osTohSaArYgtvLvUGKa/VmB+Rn3UclJY7X8dizU=3002110323999999999999999M40140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
32020-07-062020-07-12S5EUUzBPWhOzc4L49VNdMMICcgQg8ipsE6ziocm/K7I=3002090055999999999999999F40140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
42020-07-062020-07-12rpH9AXa51162VRFabuVaXTniVwdzkL8sd07HeYFapFw=3002111088999999999999999F50140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
52020-07-062020-07-122sX20c4YX4GTARe2wP5FkM6D+VAbD+n+Au5Yr/lWSrw=3013223142999999999999999M20140000134000가평사랑상품권(장병용)<NA><NA><NA><NA><NA>0.00.0N0
62020-07-062020-07-124+KfDtCVLKlySytN+UxCnLWIUdqouuaGgl+gis3RLww=3014859103999999999999999M20140000134000가평사랑상품권(장병용)<NA><NA><NA><NA><NA>0.00.0N0
72020-07-062020-07-12BJ+07wo+pLog/Wo0YdECLL2esrb3uQO6p2sw1WZ2lrI=3002110711999999999999999F50140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
82020-07-062020-07-12JPv7W7mZkKNlKZ+OuY5vrHtxlPBS1R2GXYN+yHmLO/E=3002040303999999999999999M50140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
92020-07-062020-07-12SD7KDo6xT+hNPLESOPKRIfJ3pvDs41FmsGblzCj+In0=3002089905999999999999999F40140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
일반주간결제시작일자일반주간결제종료일자카드번호회원코드가맹점번호성별코드연령대코드결제상품ID결제상품명가맹점업종명가맹점우편번호시도명시군구명읍면동명위도경도사용여부결제금액
202020-07-062020-07-129SIVrjsIg96x+7B2OPGBFP7E7CzCj2PqDaTsiwFlMWQ=3012833140999999999999999M20140000134000가평사랑상품권(장병용)<NA><NA><NA><NA><NA>0.00.0N0
212020-07-062020-07-12C+ATeTV+EdY54/xCXhs1U9ESyZMRGO2NTZ6uoMkAp6c=3007243149999999999999999F20140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
222020-07-062020-07-12FRobAv25PNHDm0y8f/U3oJMEbOXPTtEl/upB0KC/FOk=3026769206999999999999999M70140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
232020-07-062020-07-12Gp4FvJ5lUrOEyn1CrklsI4Pj8MPpN+beCYlEzeoinws=3012666136710562692M20140000134000가평사랑상품권(장병용)유통업 영리12438<NA><NA><NA>0.00.0Y7050
242020-07-062020-07-12H+SgX9SlwLrfxpDood+qV6CSBfknWqKgEFh0ivguwU0=3002109590999999999999999F20140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
252020-07-062020-07-12JjKdqU2edKBLKsjq0zBeSWGlGAgd4HemZMqRxCY0+BE=3007890125999999999999999M30140000146000양평농협 창립50주년 기프트카드<NA><NA><NA><NA><NA>0.00.0N0
262020-07-062020-07-12KLtfprg1D9B85zQNPnzFH5G3DWlWX441l4GlmAt6EP0=3012631141706153363M20140000134000가평사랑상품권(장병용)일반휴게음식12438<NA><NA><NA>0.00.0Y2500
272020-07-062020-07-12LlUz2WpTlyDkOiwlKY5SDO5xBin+RxxCiK8ijf8AtPc=3012658124793054034M20140000134000가평사랑상품권(장병용)일반휴게음식12419<NA><NA><NA>0.00.0Y6400
282020-07-062020-07-12M8huq0vsLbg7j5cKKTelHmYTXAzLeNUSYMdKOiMpVEw=3013268130710222799M20140000134000가평사랑상품권(장병용)유통업 영리12419<NA><NA><NA>0.00.0Y181500
292020-07-062020-07-12Spmg5gy0e8luxSLiG0sor9C6f1v96rZz5jM/4SueD0Q=3011193111999999999999999M20140000134000가평사랑상품권(장병용)<NA><NA><NA><NA><NA>0.00.0N0