Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 35 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 2.8 KiB |
Average record size in memory | 80.8 B |
Variable types
DateTime | 1 |
---|---|
Categorical | 4 |
Numeric | 4 |
Dataset
Description | 샘플 데이터 |
---|---|
Author | 한국과학기술원 |
URL | https://www.bigdata-environment.kr/user/data_market/detail.do?id=5d99a710-50e0-11ec-8ec1-9b2961d225b7 |
전원여부 has constant value "" | Constant |
아이디 is highly overall correlated with 전류 and 4 other fields | High correlation |
디바이스아이디 is highly overall correlated with 전류 and 4 other fields | High correlation |
디바이스 is highly overall correlated with 전류 and 4 other fields | High correlation |
전류 is highly overall correlated with 전력 and 4 other fields | High correlation |
전력 is highly overall correlated with 전류 and 4 other fields | High correlation |
파워팩터 is highly overall correlated with 전류 and 4 other fields | High correlation |
전압 has unique values | Unique |
전력 has unique values | Unique |
파워팩터 has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 13:42:18.427835 |
---|---|
Analysis finished | 2023-12-10 13:42:22.675323 |
Duration | 4.25 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
시간
Date
Distinct | 18 |
---|---|
Distinct (%) | 51.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 412.0 B |
Minimum | 2020-10-01 00:00:00 |
---|---|
Maximum | 2020-10-01 11:30:00 |
아이디
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 5.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 412.0 B |
5f04533bef45e344565af9ec | |
---|---|
5f0451bbef45e344565af9e3 |
Length
Max length | 24 |
---|---|
Median length | 24 |
Mean length | 24 |
Min length | 24 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5f0451bbef45e344565af9e3 |
---|---|
2nd row | 5f04533bef45e344565af9ec |
3rd row | 5f0451bbef45e344565af9e3 |
4th row | 5f04533bef45e344565af9ec |
5th row | 5f04533bef45e344565af9ec |
Common Values
Value | Count | Frequency (%) |
5f04533bef45e344565af9ec | 18 | |
5f0451bbef45e344565af9e3 | 17 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
5f04533bef45e344565af9ec | 18 | |
5f0451bbef45e344565af9e3 | 17 |
디바이스
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 5.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 412.0 B |
5f04533bef45e344565af9ec | |
---|---|
5f0451bbef45e344565af9e3 |
Length
Max length | 24 |
---|---|
Median length | 24 |
Mean length | 24 |
Min length | 24 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5f0451bbef45e344565af9e3 |
---|---|
2nd row | 5f04533bef45e344565af9ec |
3rd row | 5f0451bbef45e344565af9e3 |
4th row | 5f04533bef45e344565af9ec |
5th row | 5f04533bef45e344565af9ec |
Common Values
Value | Count | Frequency (%) |
5f04533bef45e344565af9ec | 18 | |
5f0451bbef45e344565af9e3 | 17 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
5f04533bef45e344565af9ec | 18 | |
5f0451bbef45e344565af9e3 | 17 |
디바이스아이디
Categorical
HIGH CORRELATION
 
Distinct | 2 |
---|---|
Distinct (%) | 5.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 412.0 B |
Dawon-B540-6ac63ad1fc79 | |
---|---|
Dawon-B540-2ef432510305 |
Length
Max length | 23 |
---|---|
Median length | 23 |
Mean length | 23 |
Min length | 23 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Dawon-B540-2ef432510305 |
---|---|
2nd row | Dawon-B540-6ac63ad1fc79 |
3rd row | Dawon-B540-2ef432510305 |
4th row | Dawon-B540-6ac63ad1fc79 |
5th row | Dawon-B540-6ac63ad1fc79 |
Common Values
Value | Count | Frequency (%) |
Dawon-B540-6ac63ad1fc79 | 18 | |
Dawon-B540-2ef432510305 | 17 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
dawon-b540-6ac63ad1fc79 | 18 | |
dawon-b540-2ef432510305 | 17 |
전류
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 30 |
---|---|
Distinct (%) | 85.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.10242952 |
Minimum | 0.065266667 |
---|---|
Maximum | 0.13805 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 447.0 B |
Quantile statistics
Minimum | 0.065266667 |
---|---|
5-th percentile | 0.06533 |
Q1 | 0.065641667 |
median | 0.13583333 |
Q3 | 0.13729167 |
95-th percentile | 0.13798167 |
Maximum | 0.13805 |
Range | 0.072783333 |
Interquartile range (IQR) | 0.071650001 |
Descriptive statistics
Standard deviation | 0.036283604 |
---|---|
Coefficient of variation (CV) | 0.35422994 |
Kurtosis | -2.1203721 |
Mean | 0.10242952 |
Median Absolute Deviation (MAD) | 0.002216667 |
Skewness | -0.059348599 |
Sum | 3.5850333 |
Variance | 0.0013164999 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
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 | |
0.0655 | 1 | 2.9% |
0.065783333 | 1 | 2.9% |
0.065866667 | 3 |
Value | Count | Frequency (%) |
0.13805 | 1 | |
0.138016667 | 1 | |
0.137966667 | 1 | |
0.137783333 | 1 | |
0.13765 | 1 | |
0.137483333 | 1 | |
0.137433333 | 1 | |
0.137366667 | 2 | |
0.137216667 | 1 | |
0.137183333 | 1 |
전압
Real number (ℝ)
UNIQUE
 
Distinct | 35 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 232.17882 |
Minimum | 230.42883 |
---|---|
Maximum | 233.8405 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 447.0 B |
Quantile statistics
Minimum | 230.42883 |
---|---|
5-th percentile | 230.47855 |
Q1 | 231.28718 |
median | 232.02183 |
Q3 | 233.25508 |
95-th percentile | 233.79562 |
Maximum | 233.8405 |
Range | 3.4116667 |
Interquartile range (IQR) | 1.9679028 |
Descriptive statistics
Standard deviation | 1.1584893 |
---|---|
Coefficient of variation (CV) | 0.0049896427 |
Kurtosis | -1.4429438 |
Mean | 232.17882 |
Median Absolute Deviation (MAD) | 0.9453334 |
Skewness | 0.086474171 |
Sum | 8126.2586 |
Variance | 1.3420975 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
230.4288333 | 1 | |
230.4413333 | 1 | |
230.4945 | 1 | |
230.6926667 | 1 | |
230.7855 | 1 | |
230.8926667 | 1 | |
230.986 | 1 | |
231.2481667 | 1 | |
231.2783333 | 1 | |
231.2960278 | 1 |
Value | Count | Frequency (%) |
233.8405 | 1 | |
233.8106667 | 1 | |
233.7891667 | 1 | |
233.754 | 1 | |
233.6885 | 1 | |
233.678 | 1 | |
233.654 | 1 | |
233.6173333 | 1 | |
233.258 | 1 | |
233.2521667 | 1 |
전력
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 35 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.8227643 |
Minimum | 0.010333333 |
---|---|
Maximum | 11.466333 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 447.0 B |
Quantile statistics
Minimum | 0.010333333 |
---|---|
5-th percentile | 0.010733333 |
Q1 | 0.02325 |
median | 10.970833 |
Q3 | 11.334604 |
95-th percentile | 11.440767 |
Maximum | 11.466333 |
Range | 11.456 |
Interquartile range (IQR) | 11.311354 |
Descriptive statistics
Standard deviation | 5.715515 |
---|---|
Coefficient of variation (CV) | 0.98158104 |
Kurtosis | -2.1199286 |
Mean | 5.8227643 |
Median Absolute Deviation (MAD) | 0.4955 |
Skewness | -0.058811349 |
Sum | 203.79675 |
Variance | 32.667112 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
0.010333333 | 1 | |
0.0105 | 1 | |
0.010833333 | 1 | |
0.021 | 1 | |
0.021166667 | 1 | |
0.021333333 | 1 | |
0.022666667 | 1 | |
0.022833333 | 1 | |
0.023166667 | 1 | |
0.023333333 | 1 |
Value | Count | Frequency (%) |
11.46633333 | 1 | |
11.44683333 | 1 | |
11.43816667 | 1 | |
11.43566667 | 1 | |
11.4185 | 1 | |
11.35683333 | 1 | |
11.35016667 | 1 | |
11.344 | 1 | |
11.336375 | 1 | |
11.33283333 | 1 |
파워팩터
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 35 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.21198262 |
Minimum | 0.046341667 |
---|---|
Maximum | 0.35608333 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 447.0 B |
Quantile statistics
Minimum | 0.046341667 |
---|---|
5-th percentile | 0.05171 |
Q1 | 0.06185 |
median | 0.34803333 |
Q3 | 0.35395 |
95-th percentile | 0.3554525 |
Maximum | 0.35608333 |
Range | 0.30974167 |
Interquartile range (IQR) | 0.2921 |
Descriptive statistics
Standard deviation | 0.14738276 |
---|---|
Coefficient of variation (CV) | 0.69525868 |
Kurtosis | -2.1087808 |
Mean | 0.21198262 |
Median Absolute Deviation (MAD) | 0.00805 |
Skewness | -0.06664897 |
Sum | 7.4193917 |
Variance | 0.021721677 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
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 |
Value | Count | Frequency (%) |
0.046341667 | 1 | |
0.050683333 | 1 | |
0.05215 | 1 | |
0.054283333 | 1 | |
0.055166667 | 1 | |
0.055933333 | 1 | |
0.057883333 | 1 | |
0.0589 | 1 | |
0.059666667 | 1 | |
0.064033333 | 1 |
Value | Count | Frequency (%) |
0.356083333 | 1 | |
0.355516667 | 1 | |
0.355425 | 1 | |
0.3553 | 1 | |
0.355266667 | 1 | |
0.354833333 | 1 | |
0.354716667 | 1 | |
0.354683333 | 1 | |
0.354333333 | 1 | |
0.353566667 | 1 |
전원여부
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 2.9% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 412.0 B |
1 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 35 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 35 |
시간 | 아이디 | 디바이스 | 디바이스아이디 | 전류 | 전압 | 전력 | 파워팩터 | |
---|---|---|---|---|---|---|---|---|
시간 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.999 | 0.000 | 0.000 |
아이디 | 0.000 | 1.000 | 0.996 | 0.996 | 0.996 | 0.000 | 0.996 | 1.000 |
디바이스 | 0.000 | 0.996 | 1.000 | 0.996 | 0.996 | 0.000 | 0.996 | 1.000 |
디바이스아이디 | 0.000 | 0.996 | 0.996 | 1.000 | 0.996 | 0.000 | 0.996 | 1.000 |
전류 | 0.000 | 0.996 | 0.996 | 0.996 | 1.000 | 0.000 | 0.996 | 1.000 |
전압 | 0.999 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 |
전력 | 0.000 | 0.996 | 0.996 | 0.996 | 0.996 | 0.000 | 1.000 | 1.000 |
파워팩터 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 |
아이디 | 디바이스아이디 | 디바이스 | |
---|---|---|---|
아이디 | 1.000 | 0.941 | 0.941 |
디바이스아이디 | 0.941 | 1.000 | 0.941 |
디바이스 | 0.941 | 0.941 | 1.000 |
전류 | 전압 | 전력 | 파워팩터 | 아이디 | 디바이스 | 디바이스아이디 | |
---|---|---|---|---|---|---|---|
전류 | 1.000 | 0.273 | 0.845 | 0.776 | 0.941 | 0.941 | 0.941 |
전압 | 0.273 | 1.000 | 0.158 | 0.047 | 0.000 | 0.000 | 0.000 |
전력 | 0.845 | 0.158 | 1.000 | 0.847 | 0.941 | 0.941 | 0.941 |
파워팩터 | 0.776 | 0.047 | 0.847 | 1.000 | 0.985 | 0.985 | 0.985 |
아이디 | 0.941 | 0.000 | 0.941 | 0.985 | 1.000 | 0.941 | 0.941 |
디바이스 | 0.941 | 0.000 | 0.941 | 0.985 | 0.941 | 1.000 | 0.941 |
디바이스아이디 | 0.941 | 0.000 | 0.941 | 0.985 | 0.941 | 0.941 | 1.000 |
시간 | 아이디 | 디바이스 | 디바이스아이디 | 전류 | 전압 | 전력 | 파워팩터 | 전원여부 | |
---|---|---|---|---|---|---|---|---|---|
0 | 2020-10-01 0:00 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065783 | 232.406333 | 0.027667 | 0.059667 | 1 |
1 | 2020-10-01 0:00 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.137433 | 232.4505 | 11.344 | 0.35345 | 1 |
2 | 2020-10-01 0:10 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065867 | 232.8675 | 0.0105 | 0.07235 | 1 |
3 | 2020-10-01 0:10 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.137483 | 232.890833 | 11.350167 | 0.348967 | 1 |
4 | 2020-10-01 0:20 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.138017 | 232.967167 | 11.435667 | 0.355425 | 1 |
5 | 2020-10-01 0:20 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065975 | 232.90425 | 0.023167 | 0.046342 | 1 |
6 | 2020-10-01 0:30 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.066083 | 233.252167 | 0.035167 | 0.064717 | 1 |
7 | 2020-10-01 0:30 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.137367 | 233.258 | 11.446833 | 0.3553 | 1 |
8 | 2020-10-01 0:40 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065867 | 233.617333 | 0.045333 | 0.067217 | 1 |
9 | 2020-10-01 0:40 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.137367 | 233.6885 | 11.4185 | 0.356083 | 1 |
시간 | 아이디 | 디바이스 | 디바이스아이디 | 전류 | 전압 | 전력 | 파워팩터 | 전원여부 | |
---|---|---|---|---|---|---|---|---|---|
25 | 2020-10-01 10:50 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065417 | 231.248167 | 0.030833 | 0.064033 | 1 |
26 | 2020-10-01 1:10 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.066083 | 233.754 | 0.023333 | 0.0589 | 1 |
27 | 2020-10-01 1:10 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.135983 | 233.8405 | 11.112167 | 0.348167 | 1 |
28 | 2020-10-01 11:00 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.0654 | 230.892667 | 0.056833 | 0.05215 | 1 |
29 | 2020-10-01 11:00 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.13765 | 230.986 | 11.168833 | 0.35125 | 1 |
30 | 2020-10-01 11:10 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.135833 | 230.4945 | 10.970833 | 0.348033 | 1 |
31 | 2020-10-01 11:10 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.065267 | 230.428833 | 0.022667 | 0.085367 | 1 |
32 | 2020-10-01 11:20 | 5f0451bbef45e344565af9e3 | 5f0451bbef45e344565af9e3 | Dawon-B540-2ef432510305 | 0.06535 | 230.692667 | 0.010833 | 0.054283 | 1 |
33 | 2020-10-01 11:20 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.13635 | 230.7855 | 11.109 | 0.353567 | 1 |
34 | 2020-10-01 11:30 | 5f04533bef45e344565af9ec | 5f04533bef45e344565af9ec | Dawon-B540-6ac63ad1fc79 | 0.137183 | 230.441333 | 11.123167 | 0.34875 | 1 |