Overview

Dataset statistics

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

Variable types

Categorical4
Numeric3
Unsupported13
DateTime1

Dataset

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

Alerts

소상공인결제분류코드 has constant value ""Constant
소상공인시스템로그IDONURI00000 has constant value ""Constant
결제건수 has constant value ""Constant
소상공인시스템로그일시 has constant value ""Constant
200900 has 203 (100.0%) missing valuesMissing
11 has 203 (100.0%) missing valuesMissing
서울특별시 has 203 (100.0%) missing valuesMissing
0 has 203 (100.0%) missing valuesMissing
25300000 has 203 (100.0%) missing valuesMissing
Unnamed: 8 has 203 (100.0%) missing valuesMissing
Unnamed: 9 has 203 (100.0%) missing valuesMissing
Unnamed: 10 has 203 (100.0%) missing valuesMissing
2020-12-14 18:27:16.0 has 203 (100.0%) missing valuesMissing
help@sobig.or.kr has 203 (100.0%) missing valuesMissing
표준산업업종대분류코드 has 203 (100.0%) missing valuesMissing
표준산업업종상세분류코드 has 203 (100.0%) missing valuesMissing
표준산업업종상세분류명 has 203 (100.0%) missing valuesMissing
200900 is an unsupported type, check if it needs cleaning or further analysisUnsupported
11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
서울특별시 is an unsupported type, check if it needs cleaning or further analysisUnsupported
0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
25300000 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:16.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 3 (1.5%) zerosZeros

Reproduction

Analysis started2023-12-10 06:15:01.193949
Analysis finished2023-12-10 06:15:01.411665
Duration0.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

소상공인결제분류코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
ONURI00000
203 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
ONURI00000 203
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:15:01.679529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
onuri00000 203
100.0%

년월
Real number (ℝ)

Distinct12
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201453.55
Minimum200900
Maximum202010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:15:01.814606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum200900
5-th percentile200900
Q1201200
median201500
Q3201750
95-th percentile202010
Maximum202010
Range1110
Interquartile range (IQR)550

Descriptive statistics

Standard deviation346.07879
Coefficient of variation (CV)0.0017179086
Kurtosis-1.2007497
Mean201453.55
Median Absolute Deviation (MAD)300
Skewness0.0079649816
Sum40895070
Variance119770.53
MonotonicityIncreasing
2023-12-10T15:15:01.966704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
201000 17
8.4%
201100 17
8.4%
201200 17
8.4%
201300 17
8.4%
201400 17
8.4%
201500 17
8.4%
201600 17
8.4%
201700 17
8.4%
201800 17
8.4%
201900 17
8.4%
Other values (2) 33
16.3%
ValueCountFrequency (%)
200900 16
7.9%
201000 17
8.4%
201100 17
8.4%
201200 17
8.4%
201300 17
8.4%
201400 17
8.4%
201500 17
8.4%
201600 17
8.4%
201700 17
8.4%
201800 17
8.4%
ValueCountFrequency (%)
202010 17
8.4%
201900 17
8.4%
201800 17
8.4%
201700 17
8.4%
201600 17
8.4%
201500 17
8.4%
201400 17
8.4%
201300 17
8.4%
201200 17
8.4%
201100 17
8.4%

소상공인시스템로그IDONURI00000
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
help@sobig.or.kr
203 

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

Length

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

Common Values (Plot)

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

200900
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

서울특별시
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

25300000
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

2020-12-14 18:27:16.0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

광역시도코드
Real number (ℝ)

Distinct17
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.832512
Minimum11
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:15:02.774458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation10.144087
Coefficient of variation (CV)0.27541122
Kurtosis-0.054710102
Mean36.832512
Median Absolute Deviation (MAD)7
Skewness-0.73891273
Sum7477
Variance102.9025
MonotonicityNot monotonic
2023-12-10T15:15:02.968232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
26 12
 
5.9%
27 12
 
5.9%
50 12
 
5.9%
48 12
 
5.9%
47 12
 
5.9%
46 12
 
5.9%
45 12
 
5.9%
44 12
 
5.9%
43 12
 
5.9%
42 12
 
5.9%
Other values (7) 83
40.9%
ValueCountFrequency (%)
11 11
5.4%
26 12
5.9%
27 12
5.9%
28 12
5.9%
29 12
5.9%
30 12
5.9%
31 12
5.9%
36 12
5.9%
41 12
5.9%
42 12
5.9%
ValueCountFrequency (%)
50 12
5.9%
48 12
5.9%
47 12
5.9%
46 12
5.9%
45 12
5.9%
44 12
5.9%
43 12
5.9%
42 12
5.9%
41 12
5.9%
36 12
5.9%

help@sobig.or.kr
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

광역시도명
Categorical

Distinct17
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
부산광역시
 
12
대구광역시
 
12
인천광역시
 
12
광주광역시
 
12
대전광역시
 
12
Other values (12)
143 

Length

Max length7
Median length5
Mean length4.6453202
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시
2nd row대구광역시
3rd row인천광역시
4th row광주광역시
5th row대전광역시

Common Values

ValueCountFrequency (%)
부산광역시 12
 
5.9%
대구광역시 12
 
5.9%
인천광역시 12
 
5.9%
광주광역시 12
 
5.9%
대전광역시 12
 
5.9%
울산광역시 12
 
5.9%
세종특별자치시 12
 
5.9%
경기도 12
 
5.9%
강원도 12
 
5.9%
충청북도 12
 
5.9%
Other values (7) 83
40.9%

Length

2023-12-10T15:15:03.218408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부산광역시 12
 
5.9%
충청북도 12
 
5.9%
제주특별자치도 12
 
5.9%
경상남도 12
 
5.9%
경상북도 12
 
5.9%
전라남도 12
 
5.9%
전라북도 12
 
5.9%
충청남도 12
 
5.9%
강원도 12
 
5.9%
대구광역시 12
 
5.9%
Other values (7) 83
40.9%

결제건수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
0
203 

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

Length

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

Common Values (Plot)

2023-12-10T15:15:03.606039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 203
100.0%

합계금액
Real number (ℝ)

ZEROS 

Distinct197
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.3545369 × 108
Minimum0
Maximum6.1937 × 109
Zeros3
Zeros (%)1.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:15:03.772666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3310000
Q161650000
median1.928 × 108
Q36.373 × 108
95-th percentile2.11221 × 109
Maximum6.1937 × 109
Range6.1937 × 109
Interquartile range (IQR)5.7565 × 108

Descriptive statistics

Standard deviation8.6370434 × 108
Coefficient of variation (CV)1.6130327
Kurtosis15.087525
Mean5.3545369 × 108
Median Absolute Deviation (MAD)1.771 × 108
Skewness3.4166722
Sum1.086971 × 1011
Variance7.4598518 × 1017
MonotonicityNot monotonic
2023-12-10T15:15:04.016477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3
 
1.5%
3700000 2
 
1.0%
13100000 2
 
1.0%
130100000 2
 
1.0%
30900000 2
 
1.0%
10500000 1
 
0.5%
33700000 1
 
0.5%
83200000 1
 
0.5%
2064600000 1
 
0.5%
1658800000 1
 
0.5%
Other values (187) 187
92.1%
ValueCountFrequency (%)
0 3
1.5%
1400000 1
 
0.5%
1500000 1
 
0.5%
1700000 1
 
0.5%
1900000 1
 
0.5%
2200000 1
 
0.5%
2700000 1
 
0.5%
3000000 1
 
0.5%
3300000 1
 
0.5%
3400000 1
 
0.5%
ValueCountFrequency (%)
6193700000 1
0.5%
4960000000 1
0.5%
4870900000 1
0.5%
3327900000 1
0.5%
2884200000 1
0.5%
2875900000 1
0.5%
2592800000 1
0.5%
2585500000 1
0.5%
2500600000 1
0.5%
2392700000 1
0.5%

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

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

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

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

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

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)100.0%
Memory size1.9 KiB

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

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2020-12-14 18:27:16
Maximum2020-12-14 18:27:16
2023-12-10T15:15:04.226568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:15:04.365521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Sample

소상공인결제분류코드년월소상공인시스템로그IDONURI0000020090011서울특별시025300000Unnamed: 8Unnamed: 9Unnamed: 102020-12-14 18:27:16.0광역시도코드help@sobig.or.kr광역시도명결제건수합계금액표준산업업종대분류코드표준산업업종상세분류코드표준산업업종상세분류명소상공인시스템로그일시
0ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>26<NA>부산광역시010500000<NA><NA><NA>2020-12-14 18:27:16.0
1ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>27<NA>대구광역시03400000<NA><NA><NA>2020-12-14 18:27:16.0
2ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>28<NA>인천광역시03600000<NA><NA><NA>2020-12-14 18:27:16.0
3ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>29<NA>광주광역시03700000<NA><NA><NA>2020-12-14 18:27:16.0
4ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>30<NA>대전광역시09100000<NA><NA><NA>2020-12-14 18:27:16.0
5ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>31<NA>울산광역시03000000<NA><NA><NA>2020-12-14 18:27:16.0
6ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>36<NA>세종특별자치시00<NA><NA><NA>2020-12-14 18:27:16.0
7ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>41<NA>경기도021200000<NA><NA><NA>2020-12-14 18:27:16.0
8ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>42<NA>강원도02700000<NA><NA><NA>2020-12-14 18:27:16.0
9ONURI00000200900help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>43<NA>충청북도03300000<NA><NA><NA>2020-12-14 18:27:16.0
소상공인결제분류코드년월소상공인시스템로그IDONURI0000020090011서울특별시025300000Unnamed: 8Unnamed: 9Unnamed: 102020-12-14 18:27:16.0광역시도코드help@sobig.or.kr광역시도명결제건수합계금액표준산업업종대분류코드표준산업업종상세분류코드표준산업업종상세분류명소상공인시스템로그일시
193ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>36<NA>세종특별자치시0137400000<NA><NA><NA>2020-12-14 18:27:16.0
194ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>41<NA>경기도02875900000<NA><NA><NA>2020-12-14 18:27:16.0
195ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>42<NA>강원도0405700000<NA><NA><NA>2020-12-14 18:27:16.0
196ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>43<NA>충청북도0397800000<NA><NA><NA>2020-12-14 18:27:16.0
197ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>44<NA>충청남도0514700000<NA><NA><NA>2020-12-14 18:27:16.0
198ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>45<NA>전라북도01370700000<NA><NA><NA>2020-12-14 18:27:16.0
199ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>46<NA>전라남도01070300000<NA><NA><NA>2020-12-14 18:27:16.0
200ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>47<NA>경상북도02585500000<NA><NA><NA>2020-12-14 18:27:16.0
201ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>48<NA>경상남도02392700000<NA><NA><NA>2020-12-14 18:27:16.0
202ONURI00000202010help@sobig.or.kr<NA><NA><NA><NA><NA><NA><NA><NA><NA>50<NA>제주특별자치도0352700000<NA><NA><NA>2020-12-14 18:27:16.0