Overview

Dataset statistics

Number of variables21
Number of observations169
Missing cells2197
Missing cells (%)61.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory30.7 KiB
Average record size in memory185.8 B

Variable types

Categorical3
Numeric4
Unsupported13
DateTime1

Dataset

DescriptionSample
Author소상공인연합회
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KFMZEROSTT014

Alerts

소상공인결제분류코드 has constant value ""Constant
소상공인시스템로그IDCMBAK00000 has constant value ""Constant
소상공인시스템로그일시 has constant value ""Constant
202001 has 169 (100.0%) missing valuesMissing
42 has 169 (100.0%) missing valuesMissing
강원도 has 169 (100.0%) missing valuesMissing
133 has 169 (100.0%) missing valuesMissing
5409000000 has 169 (100.0%) missing valuesMissing
Unnamed: 8 has 169 (100.0%) missing valuesMissing
Unnamed: 9 has 169 (100.0%) missing valuesMissing
Unnamed: 10 has 169 (100.0%) missing valuesMissing
2020-12-14 18:27:45.0 has 169 (100.0%) missing valuesMissing
help@sobig.or.kr has 169 (100.0%) missing valuesMissing
표준산업업종대분류코드 has 169 (100.0%) missing valuesMissing
표준산업업종상세분류코드 has 169 (100.0%) missing valuesMissing
표준산업업종상세분류명 has 169 (100.0%) missing valuesMissing
202001 is an unsupported type, check if it needs cleaning or further analysisUnsupported
42 is an unsupported type, check if it needs cleaning or further analysisUnsupported
강원도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
133 is an unsupported type, check if it needs cleaning or further analysisUnsupported
5409000000 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
2020-12-14 18:27:45.0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
help@sobig.or.kr 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 (5.9%) zerosZeros
합계금액 has 10 (5.9%) zerosZeros

Reproduction

Analysis started2023-12-10 06:39:25.108008
Analysis finished2023-12-10 06:39:25.394168
Duration0.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

소상공인결제분류코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
CMBAK00000
169 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
CMBAK00000 169
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:39:25.706365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cmbak00000 169
100.0%

년월
Real number (ℝ)

Distinct10
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202005.53
Minimum202001
Maximum202010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-10T15:39:25.880744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum202001
5-th percentile202001
Q1202003
median202006
Q3202008
95-th percentile202010
Maximum202010
Range9
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.8682687
Coefficient of variation (CV)1.4198962 × 10-5
Kurtosis-1.2193707
Mean202005.53
Median Absolute Deviation (MAD)2
Skewness-0.0049229109
Sum34138934
Variance8.2269653
MonotonicityIncreasing
2023-12-10T15:39:26.089527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
202002 17
10.1%
202003 17
10.1%
202004 17
10.1%
202005 17
10.1%
202006 17
10.1%
202007 17
10.1%
202008 17
10.1%
202009 17
10.1%
202010 17
10.1%
202001 16
9.5%
ValueCountFrequency (%)
202001 16
9.5%
202002 17
10.1%
202003 17
10.1%
202004 17
10.1%
202005 17
10.1%
202006 17
10.1%
202007 17
10.1%
202008 17
10.1%
202009 17
10.1%
202010 17
10.1%
ValueCountFrequency (%)
202010 17
10.1%
202009 17
10.1%
202008 17
10.1%
202007 17
10.1%
202006 17
10.1%
202005 17
10.1%
202004 17
10.1%
202003 17
10.1%
202002 17
10.1%
202001 16
9.5%

소상공인시스템로그IDCMBAK00000
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
help@sobig.or.kr
169 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhelp@sobig.or.kr
2nd rowhelp@sobig.or.kr
3rd rowhelp@sobig.or.kr
4th rowhelp@sobig.or.kr
5th rowhelp@sobig.or.kr

Common Values

ValueCountFrequency (%)
help@sobig.or.kr 169
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:39:26.469158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
help@sobig.or.kr 169
100.0%

202001
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

42
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

강원도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

133
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

5409000000
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

2020-12-14 18:27:45.0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

광역시도코드
Real number (ℝ)

Distinct17
Distinct (%)10.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.674556
Minimum11
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-10T15:39:26.630834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile11
Q129
median41
Q345
95-th percentile50
Maximum50
Range39
Interquartile range (IQR)16

Descriptive statistics

Standard deviation10.306927
Coefficient of variation (CV)0.28103754
Kurtosis-0.071479667
Mean36.674556
Median Absolute Deviation (MAD)7
Skewness-0.74051339
Sum6198
Variance106.23274
MonotonicityNot monotonic
2023-12-10T15:39:26.819951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
41 10
 
5.9%
48 10
 
5.9%
43 10
 
5.9%
44 10
 
5.9%
50 10
 
5.9%
45 10
 
5.9%
46 10
 
5.9%
28 10
 
5.9%
31 10
 
5.9%
36 10
 
5.9%
Other values (7) 69
40.8%
ValueCountFrequency (%)
11 10
5.9%
26 10
5.9%
27 10
5.9%
28 10
5.9%
29 10
5.9%
30 10
5.9%
31 10
5.9%
36 10
5.9%
41 10
5.9%
42 9
5.3%
ValueCountFrequency (%)
50 10
5.9%
48 10
5.9%
47 10
5.9%
46 10
5.9%
45 10
5.9%
44 10
5.9%
43 10
5.9%
42 9
5.3%
41 10
5.9%
36 10
5.9%

help@sobig.or.kr
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

광역시도명
Categorical

Distinct17
Distinct (%)10.1%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
경기도
 
10
경상남도
 
10
경상북도
 
10
광주광역시
 
10
대구광역시
 
10
Other values (12)
119 

Length

Max length7
Median length5
Mean length4.6568047
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경상남도
3rd row경상북도
4th row광주광역시
5th row대구광역시

Common Values

ValueCountFrequency (%)
경기도 10
 
5.9%
경상남도 10
 
5.9%
경상북도 10
 
5.9%
광주광역시 10
 
5.9%
대구광역시 10
 
5.9%
대전광역시 10
 
5.9%
부산광역시 10
 
5.9%
서울특별시 10
 
5.9%
세종특별자치시 10
 
5.9%
울산광역시 10
 
5.9%
Other values (7) 69
40.8%

Length

2023-12-10T15:39:27.005479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 10
 
5.9%
울산광역시 10
 
5.9%
충청북도 10
 
5.9%
충청남도 10
 
5.9%
제주특별자치도 10
 
5.9%
전라북도 10
 
5.9%
전라남도 10
 
5.9%
인천광역시 10
 
5.9%
세종특별자치시 10
 
5.9%
경상남도 10
 
5.9%
Other values (7) 69
40.8%

결제건수
Real number (ℝ)

ZEROS 

Distinct140
Distinct (%)82.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean949.11834
Minimum0
Maximum19748
Zeros10
Zeros (%)5.9%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-10T15:39:27.209443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q140
median172
Q3791
95-th percentile5296.8
Maximum19748
Range19748
Interquartile range (IQR)751

Descriptive statistics

Standard deviation2194.3607
Coefficient of variation (CV)2.311999
Kurtosis33.445337
Mean949.11834
Median Absolute Deviation (MAD)165
Skewness4.9146957
Sum160401
Variance4815218.7
MonotonicityNot monotonic
2023-12-10T15:39:27.457533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 10
 
5.9%
1 5
 
3.0%
47 3
 
1.8%
7 2
 
1.2%
8 2
 
1.2%
61 2
 
1.2%
44 2
 
1.2%
37 2
 
1.2%
17 2
 
1.2%
2 2
 
1.2%
Other values (130) 137
81.1%
ValueCountFrequency (%)
0 10
5.9%
1 5
3.0%
2 2
 
1.2%
4 1
 
0.6%
5 1
 
0.6%
6 2
 
1.2%
7 2
 
1.2%
8 2
 
1.2%
10 2
 
1.2%
14 1
 
0.6%
ValueCountFrequency (%)
19748 1
0.6%
8206 1
0.6%
8154 1
0.6%
7441 1
0.6%
7024 1
0.6%
6480 1
0.6%
6461 1
0.6%
5350 1
0.6%
5312 1
0.6%
5274 1
0.6%

합계금액
Real number (ℝ)

ZEROS 

Distinct157
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3550107 × 1010
Minimum0
Maximum3.83789 × 1011
Zeros10
Zeros (%)5.9%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-10T15:39:27.703743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q17.25 × 108
median4.707 × 109
Q32.0185 × 1010
95-th percentile1.014024 × 1011
Maximum3.83789 × 1011
Range3.83789 × 1011
Interquartile range (IQR)1.946 × 1010

Descriptive statistics

Standard deviation4.6830768 × 1010
Coefficient of variation (CV)1.9885586
Kurtosis23.208083
Mean2.3550107 × 1010
Median Absolute Deviation (MAD)4.607 × 109
Skewness4.0866941
Sum3.979968 × 1012
Variance2.1931208 × 1021
MonotonicityNot monotonic
2023-12-10T15:39:27.902115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 10
 
5.9%
100000000 2
 
1.2%
20000000 2
 
1.2%
295000000 2
 
1.2%
725000000 1
 
0.6%
659000000 1
 
0.6%
150000000 1
 
0.6%
230000000 1
 
0.6%
170000000 1
 
0.6%
2948000000 1
 
0.6%
Other values (147) 147
87.0%
ValueCountFrequency (%)
0 10
5.9%
20000000 2
 
1.2%
40000000 1
 
0.6%
85000000 1
 
0.6%
100000000 2
 
1.2%
115000000 1
 
0.6%
150000000 1
 
0.6%
170000000 1
 
0.6%
187000000 1
 
0.6%
195000000 1
 
0.6%
ValueCountFrequency (%)
383789000000 1
0.6%
231942000000 1
0.6%
177990000000 1
0.6%
164113000000 1
0.6%
146370000000 1
0.6%
134033000000 1
0.6%
121116000000 1
0.6%
108104000000 1
0.6%
101782000000 1
0.6%
100833000000 1
0.6%

표준산업업종대분류코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

표준산업업종상세분류코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

표준산업업종상세분류명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing169
Missing (%)100.0%
Memory size1.6 KiB

소상공인시스템로그일시
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2020-12-14 18:27:45
Maximum2020-12-14 18:27:45
2023-12-10T15:39:28.082289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:39:28.257595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Sample

소상공인결제분류코드년월소상공인시스템로그IDCMBAK0000020200142강원도1335409000000Unnamed: 8Unnamed: 9Unnamed: 102020-12-14 18:27:45.0광역시도코드help@sobig.or.kr광역시도명결제건수합계금액표준산업업종대분류코드표준산업업종상세분류코드표준산업업종상세분류명소상공인시스템로그일시
0CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>41<NA>경기도109934762000000<NA><NA><NA>2020-12-14 18:27:45.0
1CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>48<NA>경상남도2368723000000<NA><NA><NA>2020-12-14 18:27:45.0
2CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>47<NA>경상북도2609479000000<NA><NA><NA>2020-12-14 18:27:45.0
3CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>29<NA>광주광역시1004000000000<NA><NA><NA>2020-12-14 18:27:45.0
4CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>27<NA>대구광역시1545223000000<NA><NA><NA>2020-12-14 18:27:45.0
5CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>30<NA>대전광역시1274707000000<NA><NA><NA>2020-12-14 18:27:45.0
6CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>26<NA>부산광역시1064222000000<NA><NA><NA>2020-12-14 18:27:45.0
7CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>11<NA>서울특별시27812324000000<NA><NA><NA>2020-12-14 18:27:45.0
8CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>36<NA>세종특별자치시391306000000<NA><NA><NA>2020-12-14 18:27:45.0
9CMBAK00000202001help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>31<NA>울산광역시14645000000<NA><NA><NA>2020-12-14 18:27:45.0
소상공인결제분류코드년월소상공인시스템로그IDCMBAK0000020200142강원도1335409000000Unnamed: 8Unnamed: 9Unnamed: 102020-12-14 18:27:45.0광역시도코드help@sobig.or.kr광역시도명결제건수합계금액표준산업업종대분류코드표준산업업종상세분류코드표준산업업종상세분류명소상공인시스템로그일시
159CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>26<NA>부산광역시983077000000<NA><NA><NA>2020-12-14 18:27:45.0
160CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>11<NA>서울특별시1994885000000<NA><NA><NA>2020-12-14 18:27:45.0
161CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>36<NA>세종특별자치시6115000000<NA><NA><NA>2020-12-14 18:27:45.0
162CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>31<NA>울산광역시471493000000<NA><NA><NA>2020-12-14 18:27:45.0
163CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>28<NA>인천광역시872860000000<NA><NA><NA>2020-12-14 18:27:45.0
164CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>46<NA>전라남도1094010000000<NA><NA><NA>2020-12-14 18:27:45.0
165CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>45<NA>전라북도1133824000000<NA><NA><NA>2020-12-14 18:27:45.0
166CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>50<NA>제주특별자치도25624000000<NA><NA><NA>2020-12-14 18:27:45.0
167CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>44<NA>충청남도972802000000<NA><NA><NA>2020-12-14 18:27:45.0
168CMBAK00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>43<NA>충청북도621704000000<NA><NA><NA>2020-12-14 18:27:45.0