Overview

Dataset statistics

Number of variables9
Number of observations35
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory80.8 B

Variable types

DateTime1
Categorical4
Numeric4

Alerts

전원여부 has constant value ""Constant
아이디 is highly overall correlated with 전류 and 4 other fieldsHigh correlation
디바이스아이디 is highly overall correlated with 전류 and 4 other fieldsHigh correlation
디바이스 is highly overall correlated with 전류 and 4 other fieldsHigh correlation
전류 is highly overall correlated with 전력 and 4 other fieldsHigh correlation
전력 is highly overall correlated with 전류 and 4 other fieldsHigh correlation
파워팩터 is highly overall correlated with 전류 and 4 other fieldsHigh correlation
전압 has unique valuesUnique
전력 has unique valuesUnique
파워팩터 has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:42:18.427835
Analysis finished2023-12-10 13:42:22.675323
Duration4.25 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시간
Date

Distinct18
Distinct (%)51.4%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2020-10-01 00:00:00
Maximum2020-10-01 11:30:00
2023-12-10T22:42:22.738302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:22.877795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

아이디
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
5f04533bef45e344565af9ec
18 
5f0451bbef45e344565af9e3
17 

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5f0451bbef45e344565af9e3
2nd row5f04533bef45e344565af9ec
3rd row5f0451bbef45e344565af9e3
4th row5f04533bef45e344565af9ec
5th row5f04533bef45e344565af9ec

Common Values

ValueCountFrequency (%)
5f04533bef45e344565af9ec 18
51.4%
5f0451bbef45e344565af9e3 17
48.6%

Length

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

Common Values (Plot)

2023-12-10T22:42:23.175940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5f04533bef45e344565af9ec 18
51.4%
5f0451bbef45e344565af9e3 17
48.6%

디바이스
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
5f04533bef45e344565af9ec
18 
5f0451bbef45e344565af9e3
17 

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5f0451bbef45e344565af9e3
2nd row5f04533bef45e344565af9ec
3rd row5f0451bbef45e344565af9e3
4th row5f04533bef45e344565af9ec
5th row5f04533bef45e344565af9ec

Common Values

ValueCountFrequency (%)
5f04533bef45e344565af9ec 18
51.4%
5f0451bbef45e344565af9e3 17
48.6%

Length

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

Common Values (Plot)

2023-12-10T22:42:23.491576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5f04533bef45e344565af9ec 18
51.4%
5f0451bbef45e344565af9e3 17
48.6%

디바이스아이디
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
Dawon-B540-6ac63ad1fc79
18 
Dawon-B540-2ef432510305
17 

Length

Max length23
Median length23
Mean length23
Min length23

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDawon-B540-2ef432510305
2nd rowDawon-B540-6ac63ad1fc79
3rd rowDawon-B540-2ef432510305
4th rowDawon-B540-6ac63ad1fc79
5th rowDawon-B540-6ac63ad1fc79

Common Values

ValueCountFrequency (%)
Dawon-B540-6ac63ad1fc79 18
51.4%
Dawon-B540-2ef432510305 17
48.6%

Length

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

Common Values (Plot)

2023-12-10T22:42:23.798110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
dawon-b540-6ac63ad1fc79 18
51.4%
dawon-b540-2ef432510305 17
48.6%

전류
Real number (ℝ)

HIGH CORRELATION 

Distinct30
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.10242952
Minimum0.065266667
Maximum0.13805
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-10T22:42:23.959796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.065266667
5-th percentile0.06533
Q10.065641667
median0.13583333
Q30.13729167
95-th percentile0.13798167
Maximum0.13805
Range0.072783333
Interquartile range (IQR)0.071650001

Descriptive statistics

Standard deviation0.036283604
Coefficient of variation (CV)0.35422994
Kurtosis-2.1203721
Mean0.10242952
Median Absolute Deviation (MAD)0.002216667
Skewness-0.059348599
Sum3.5850333
Variance0.0013164999
MonotonicityNot monotonic
2023-12-10T22:42:24.169541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
0.065866667 3
 
8.6%
0.065416667 2
 
5.7%
0.066083333 2
 
5.7%
0.137366667 2
 
5.7%
0.065783333 1
 
2.9%
0.13765 1
 
2.9%
0.136829167 1
 
2.9%
0.137966667 1
 
2.9%
0.135983333 1
 
2.9%
0.0654 1
 
2.9%
Other values (20) 20
57.1%
ValueCountFrequency (%)
0.065266667 1
 
2.9%
0.065283333 1
 
2.9%
0.06535 1
 
2.9%
0.065366667 1
 
2.9%
0.065383333 1
 
2.9%
0.0654 1
 
2.9%
0.065416667 2
5.7%
0.0655 1
 
2.9%
0.065783333 1
 
2.9%
0.065866667 3
8.6%
ValueCountFrequency (%)
0.13805 1
2.9%
0.138016667 1
2.9%
0.137966667 1
2.9%
0.137783333 1
2.9%
0.13765 1
2.9%
0.137483333 1
2.9%
0.137433333 1
2.9%
0.137366667 2
5.7%
0.137216667 1
2.9%
0.137183333 1
2.9%

전압
Real number (ℝ)

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean232.17882
Minimum230.42883
Maximum233.8405
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-10T22:42:24.418953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum230.42883
5-th percentile230.47855
Q1231.28718
median232.02183
Q3233.25508
95-th percentile233.79562
Maximum233.8405
Range3.4116667
Interquartile range (IQR)1.9679028

Descriptive statistics

Standard deviation1.1584893
Coefficient of variation (CV)0.0049896427
Kurtosis-1.4429438
Mean232.17882
Median Absolute Deviation (MAD)0.9453334
Skewness0.086474171
Sum8126.2586
Variance1.3420975
MonotonicityNot monotonic
2023-12-10T22:42:24.627075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
232.4063333 1
 
2.9%
232.4505 1
 
2.9%
231.3184167 1
 
2.9%
231.2960278 1
 
2.9%
231.3338056 1
 
2.9%
231.3854167 1
 
2.9%
231.2783333 1
 
2.9%
231.2481667 1
 
2.9%
233.754 1
 
2.9%
233.8405 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
230.4288333 1
2.9%
230.4413333 1
2.9%
230.4945 1
2.9%
230.6926667 1
2.9%
230.7855 1
2.9%
230.8926667 1
2.9%
230.986 1
2.9%
231.2481667 1
2.9%
231.2783333 1
2.9%
231.2960278 1
2.9%
ValueCountFrequency (%)
233.8405 1
2.9%
233.8106667 1
2.9%
233.7891667 1
2.9%
233.754 1
2.9%
233.6885 1
2.9%
233.678 1
2.9%
233.654 1
2.9%
233.6173333 1
2.9%
233.258 1
2.9%
233.2521667 1
2.9%

전력
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.8227643
Minimum0.010333333
Maximum11.466333
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-10T22:42:24.827692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.010333333
5-th percentile0.010733333
Q10.02325
median10.970833
Q311.334604
95-th percentile11.440767
Maximum11.466333
Range11.456
Interquartile range (IQR)11.311354

Descriptive statistics

Standard deviation5.715515
Coefficient of variation (CV)0.98158104
Kurtosis-2.1199286
Mean5.8227643
Median Absolute Deviation (MAD)0.4955
Skewness-0.058811349
Sum203.79675
Variance32.667112
MonotonicityNot monotonic
2023-12-10T22:42:25.035584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0.027666667 1
 
2.9%
11.344 1
 
2.9%
11.336375 1
 
2.9%
0.043166667 1
 
2.9%
0.034 1
 
2.9%
11.289375 1
 
2.9%
11.33283333 1
 
2.9%
0.030833333 1
 
2.9%
0.023333333 1
 
2.9%
11.11216667 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
0.010333333 1
2.9%
0.0105 1
2.9%
0.010833333 1
2.9%
0.021 1
2.9%
0.021166667 1
2.9%
0.021333333 1
2.9%
0.022666667 1
2.9%
0.022833333 1
2.9%
0.023166667 1
2.9%
0.023333333 1
2.9%
ValueCountFrequency (%)
11.46633333 1
2.9%
11.44683333 1
2.9%
11.43816667 1
2.9%
11.43566667 1
2.9%
11.4185 1
2.9%
11.35683333 1
2.9%
11.35016667 1
2.9%
11.344 1
2.9%
11.336375 1
2.9%
11.33283333 1
2.9%

파워팩터
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.21198262
Minimum0.046341667
Maximum0.35608333
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2023-12-10T22:42:25.239175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.046341667
5-th percentile0.05171
Q10.06185
median0.34803333
Q30.35395
95-th percentile0.3554525
Maximum0.35608333
Range0.30974167
Interquartile range (IQR)0.2921

Descriptive statistics

Standard deviation0.14738276
Coefficient of variation (CV)0.69525868
Kurtosis-2.1087808
Mean0.21198262
Median Absolute Deviation (MAD)0.00805
Skewness-0.06664897
Sum7.4193917
Variance0.021721677
MonotonicityNot monotonic
2023-12-10T22:42:25.478593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
0.059666667 1
 
2.9%
0.35345 1
 
2.9%
0.354333333 1
 
2.9%
0.069790278 1
 
2.9%
0.077651389 1
 
2.9%
0.354833333 1
 
2.9%
0.354716667 1
 
2.9%
0.064033333 1
 
2.9%
0.0589 1
 
2.9%
0.348166667 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
0.046341667 1
2.9%
0.050683333 1
2.9%
0.05215 1
2.9%
0.054283333 1
2.9%
0.055166667 1
2.9%
0.055933333 1
2.9%
0.057883333 1
2.9%
0.0589 1
2.9%
0.059666667 1
2.9%
0.064033333 1
2.9%
ValueCountFrequency (%)
0.356083333 1
2.9%
0.355516667 1
2.9%
0.355425 1
2.9%
0.3553 1
2.9%
0.355266667 1
2.9%
0.354833333 1
2.9%
0.354716667 1
2.9%
0.354683333 1
2.9%
0.354333333 1
2.9%
0.353566667 1
2.9%

전원여부
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
1
35 

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

Length

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

Common Values (Plot)

2023-12-10T22:42:25.873445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 35
100.0%

Interactions

2023-12-10T22:42:21.571237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.111661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.735932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:20.482028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:21.785947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.269350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.926375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:20.641398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:22.002911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.444996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:20.136043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:20.800822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:22.208650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:19.589616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:20.330754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:42:21.380756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:42:25.996317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간아이디디바이스디바이스아이디전류전압전력파워팩터
시간1.0000.0000.0000.0000.0000.9990.0000.000
아이디0.0001.0000.9960.9960.9960.0000.9961.000
디바이스0.0000.9961.0000.9960.9960.0000.9961.000
디바이스아이디0.0000.9960.9961.0000.9960.0000.9961.000
전류0.0000.9960.9960.9961.0000.0000.9961.000
전압0.9990.0000.0000.0000.0001.0000.0000.000
전력0.0000.9960.9960.9960.9960.0001.0001.000
파워팩터0.0001.0001.0001.0001.0000.0001.0001.000
2023-12-10T22:42:26.229620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
아이디디바이스아이디디바이스
아이디1.0000.9410.941
디바이스아이디0.9411.0000.941
디바이스0.9410.9411.000
2023-12-10T22:42:26.395689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전류전압전력파워팩터아이디디바이스디바이스아이디
전류1.0000.2730.8450.7760.9410.9410.941
전압0.2731.0000.1580.0470.0000.0000.000
전력0.8450.1581.0000.8470.9410.9410.941
파워팩터0.7760.0470.8471.0000.9850.9850.985
아이디0.9410.0000.9410.9851.0000.9410.941
디바이스0.9410.0000.9410.9850.9411.0000.941
디바이스아이디0.9410.0000.9410.9850.9410.9411.000

Missing values

2023-12-10T22:42:22.430773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:42:22.615024image/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

시간아이디디바이스디바이스아이디전류전압전력파워팩터전원여부
02020-10-01 0:005f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065783232.4063330.0276670.0596671
12020-10-01 0:005f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.137433232.450511.3440.353451
22020-10-01 0:105f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065867232.86750.01050.072351
32020-10-01 0:105f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.137483232.89083311.3501670.3489671
42020-10-01 0:205f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.138017232.96716711.4356670.3554251
52020-10-01 0:205f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065975232.904250.0231670.0463421
62020-10-01 0:305f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.066083233.2521670.0351670.0647171
72020-10-01 0:305f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.137367233.25811.4468330.35531
82020-10-01 0:405f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065867233.6173330.0453330.0672171
92020-10-01 0:405f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.137367233.688511.41850.3560831
시간아이디디바이스디바이스아이디전류전압전력파워팩터전원여부
252020-10-01 10:505f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065417231.2481670.0308330.0640331
262020-10-01 1:105f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.066083233.7540.0233330.05891
272020-10-01 1:105f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.135983233.840511.1121670.3481671
282020-10-01 11:005f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.0654230.8926670.0568330.052151
292020-10-01 11:005f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.13765230.98611.1688330.351251
302020-10-01 11:105f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.135833230.494510.9708330.3480331
312020-10-01 11:105f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.065267230.4288330.0226670.0853671
322020-10-01 11:205f0451bbef45e344565af9e35f0451bbef45e344565af9e3Dawon-B540-2ef4325103050.06535230.6926670.0108330.0542831
332020-10-01 11:205f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.13635230.785511.1090.3535671
342020-10-01 11:305f04533bef45e344565af9ec5f04533bef45e344565af9ecDawon-B540-6ac63ad1fc790.137183230.44133311.1231670.348751