Overview

Dataset statistics

Number of variables8
Number of observations199
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.7 KiB
Average record size in memory70.7 B

Variable types

Categorical5
Numeric2
Boolean1

Dataset

DescriptionSample
Author한국스마트그리드
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSGTEAMSRLERN

Alerts

2817010600 has constant value ""Constant
2021 has constant value ""Constant
07 has constant value ""Constant
01 has constant value ""Constant
N has constant value ""Constant
00 has 32 (16.1%) zerosZeros
0.052 has 33 (16.6%) zerosZeros

Reproduction

Analysis started2023-12-10 06:13:13.644929
Analysis finished2023-12-10 06:13:14.628736
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

IC1300102000205
Categorical

Distinct33
Distinct (%)16.6%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
IC1300102000206
 
7
IC1300102000207
 
6
IC1300102000208
 
6
IC1300102000251
 
6
IC1300102000301
 
6
Other values (28)
168 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowIC1300102000206
2nd rowIC1300102000207
3rd rowIC1300102000208
4th rowIC1300102000251
5th rowIC1300102000301

Common Values

ValueCountFrequency (%)
IC1300102000206 7
 
3.5%
IC1300102000207 6
 
3.0%
IC1300102000208 6
 
3.0%
IC1300102000251 6
 
3.0%
IC1300102000301 6
 
3.0%
IC1300102000302 6
 
3.0%
IC1300102000303 6
 
3.0%
IC1300102000304 6
 
3.0%
IC1300102000305 6
 
3.0%
IC1300102000306 6
 
3.0%
Other values (23) 138
69.3%

Length

2023-12-10T15:13:14.721317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
ic1300102000206 7
 
3.5%
ic1300102000401 6
 
3.0%
ic1300102000461 6
 
3.0%
ic1300102000451 6
 
3.0%
ic1300102000441 6
 
3.0%
ic1300102000431 6
 
3.0%
ic1300102000421 6
 
3.0%
ic1300102000410 6
 
3.0%
ic1300102000409 6
 
3.0%
ic1300102000408 6
 
3.0%
Other values (23) 138
69.3%

2817010600
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2817010600
199 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2817010600 199
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:13:15.113028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2817010600 199
100.0%

2021
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2021
199 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021 199
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:13:15.403290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 199
100.0%

07
Categorical

CONSTANT 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7 199
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:13:15.688571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7 199
100.0%

01
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
199 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 199
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:13:16.006457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 199
100.0%

00
Real number (ℝ)

ZEROS 

Distinct7
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.5477387
Minimum0
Maximum6
Zeros32
Zeros (%)16.1%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:13:16.127496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q34
95-th percentile5
Maximum6
Range6
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.73394
Coefficient of variation (CV)0.68058
Kurtosis-1.222517
Mean2.5477387
Median Absolute Deviation (MAD)2
Skewness0.015753355
Sum507
Variance3.0065479
MonotonicityIncreasing
2023-12-10T15:13:16.292812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
1 33
16.6%
2 33
16.6%
3 33
16.6%
4 33
16.6%
5 33
16.6%
0 32
16.1%
6 2
 
1.0%
ValueCountFrequency (%)
0 32
16.1%
1 33
16.6%
2 33
16.6%
3 33
16.6%
4 33
16.6%
5 33
16.6%
6 2
 
1.0%
ValueCountFrequency (%)
6 2
 
1.0%
5 33
16.6%
4 33
16.6%
3 33
16.6%
2 33
16.6%
1 33
16.6%
0 32
16.1%

N
Boolean

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size331.0 B
False
199 
ValueCountFrequency (%)
False 199
100.0%
2023-12-10T15:13:16.440713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

0.052
Real number (ℝ)

ZEROS 

Distinct100
Distinct (%)50.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.087663317
Minimum0
Maximum1.291
Zeros33
Zeros (%)16.6%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:13:16.628509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.0075
median0.043
Q30.089
95-th percentile0.2683
Maximum1.291
Range1.291
Interquartile range (IQR)0.0815

Descriptive statistics

Standard deviation0.18183635
Coefficient of variation (CV)2.0742581
Kurtosis27.2353
Mean0.087663317
Median Absolute Deviation (MAD)0.037
Skewness4.9275803
Sum17.445
Variance0.033064457
MonotonicityNot monotonic
2023-12-10T15:13:16.954284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 33
 
16.6%
0.008 9
 
4.5%
0.004 6
 
3.0%
0.009 5
 
2.5%
0.074 5
 
2.5%
0.061 4
 
2.0%
0.072 4
 
2.0%
0.011 4
 
2.0%
0.08 3
 
1.5%
0.013 3
 
1.5%
Other values (90) 123
61.8%
ValueCountFrequency (%)
0.0 33
16.6%
0.001 3
 
1.5%
0.002 1
 
0.5%
0.004 6
 
3.0%
0.005 2
 
1.0%
0.006 2
 
1.0%
0.007 3
 
1.5%
0.008 9
 
4.5%
0.009 5
 
2.5%
0.011 4
 
2.0%
ValueCountFrequency (%)
1.291 1
0.5%
1.251 1
0.5%
1.17 1
0.5%
1.062 1
0.5%
0.648 1
0.5%
0.484 1
0.5%
0.47 1
0.5%
0.29 1
0.5%
0.284 1
0.5%
0.271 1
0.5%

Interactions

2023-12-10T15:13:14.126310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:13.859940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:14.230592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:13.981400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:13:17.097662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
IC1300102000205000.052
IC13001020002051.0000.0000.830
000.0001.0000.000
0.0520.8300.0001.000
2023-12-10T15:13:17.244534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
000.052IC1300102000205
001.000-0.0940.000
0.052-0.0941.0000.493
IC13001020002050.0000.4931.000

Missing values

2023-12-10T15:13:14.374959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:13:14.552831image/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

IC130010200020528170106002021070100N0.052
0IC130010200020628170106002021710N0.126
1IC130010200020728170106002021710N0.019
2IC130010200020828170106002021710N1.251
3IC130010200025128170106002021710N0.001
4IC130010200030128170106002021710N0.247
5IC130010200030228170106002021710N0.096
6IC130010200030328170106002021710N0.072
7IC130010200030428170106002021710N0.044
8IC130010200030528170106002021710N0.0
9IC130010200030628170106002021710N0.0
IC130010200020528170106002021070100N0.052
189IC130010200040828170106002021715N0.0
190IC130010200040928170106002021715N0.041
191IC130010200041028170106002021715N0.0
192IC130010200042128170106002021715N0.005
193IC130010200043128170106002021715N0.006
194IC130010200044128170106002021715N0.0
195IC130010200045128170106002021715N0.03
196IC130010200046128170106002021715N0.052
197IC130010200020528170106002021716N0.022
198IC130010200020628170106002021716N0.032