Dataset statistics
Number of variables | 32 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 2.7 MiB |
Average record size in memory | 288.0 B |
Variable types
Categorical | 27 |
---|---|
Text | 1 |
Numeric | 3 |
DateTime | 1 |
Dataset
Description | 파일 다운로드 |
---|---|
Author | 서울특별시 |
URL | https://data.seoul.go.kr/dataList/OA-15965/S/1/datasetView.do |
기관 명 has constant value "" | Constant |
모델명 has constant value "" | Constant |
심야소등시작시간 has constant value "" | Constant |
심야소등시작분 has constant value "" | Constant |
심야소등해제분 has constant value "" | Constant |
디밍시1 has constant value "" | Constant |
디밍분1 has constant value "" | Constant |
디밍값1(%) has constant value "" | Constant |
디밍시2 has constant value "" | Constant |
디밍분2 has constant value "" | Constant |
디밍시3 has constant value "" | Constant |
디밍분3 has constant value "" | Constant |
디밍값3(%) has constant value "" | Constant |
현재디밍값(%) has constant value "" | Constant |
이상점등(정상:0, 고장:1) has constant value "" | Constant |
수동/강제상태(정상:0, 고장:1) has constant value "" | Constant |
지역ID is highly imbalanced (99.9%) | Imbalance |
소등편차 is highly imbalanced (79.7%) | Imbalance |
심야소등해제시간 is highly imbalanced (99.6%) | Imbalance |
심야소등적용기간 is highly imbalanced (99.6%) | Imbalance |
디밍값2(%) is highly imbalanced (98.9%) | Imbalance |
램프고장(정상:0, 고장:1) is highly imbalanced (99.4%) | Imbalance |
누전발생(정상:0, 고장:1) is highly imbalanced (99.9%) | Imbalance |
안정기고장(정상:0, 고장:1) is highly imbalanced (98.8%) | Imbalance |
깜빡거림(정상:0, 고장:1) is highly imbalanced (98.2%) | Imbalance |
현재전력값(W) has 4779 (47.8%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-17 23:29:32.447599 |
---|---|
Analysis finished | 2024-05-17 23:29:34.419168 |
Duration | 1.97 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
기관 명
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
강북구 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 강북구 |
---|---|
2nd row | 강북구 |
3rd row | 강북구 |
4th row | 강북구 |
5th row | 강북구 |
Common Values
Value | Count | Frequency (%) |
강북구 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
강북구 | 10000 |
모델명
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
BMC-300S |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | BMC-300S |
---|---|
2nd row | BMC-300S |
3rd row | BMC-300S |
4th row | BMC-300S |
5th row | BMC-300S |
Common Values
Value | Count | Frequency (%) |
BMC-300S | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
bmc-300s | 10000 |
시리얼
Text
Distinct | 1946 |
---|---|
Distinct (%) | 19.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Length
Max length | 15 |
---|---|
Median length | 15 |
Mean length | 15 |
Min length | 15 |
Characters and Unicode
Total characters | 150000 |
---|---|
Distinct characters | 16 |
Distinct categories | 2 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 42 ? |
---|---|
Unique (%) | 0.4% |
Sample
1st row | 019010d00003a2a |
---|---|
2nd row | 019010d00003f34 |
3rd row | 359369083367751 |
4th row | 359369084334008 |
5th row | 359369081409951 |
Value | Count | Frequency (%) |
019010d00013a46 | 13 | 0.1% |
019010d000050ec | 13 | 0.1% |
019010d00010ed3 | 12 | 0.1% |
019010d00004bb5 | 12 | 0.1% |
019010d0000706e | 11 | 0.1% |
019010d00012267 | 11 | 0.1% |
019010d000050f3 | 11 | 0.1% |
019010d00004be1 | 11 | 0.1% |
019010d00010eff | 11 | 0.1% |
019010d00005037 | 11 | 0.1% |
Other values (1936) | 9884 |
Most occurring characters
Value | Count | Frequency (%) |
0 | 44188 | |
3 | 21428 | |
9 | 18699 | |
1 | 15221 | 10.1% |
5 | 8983 | 6.0% |
8 | 8264 | 5.5% |
6 | 7888 | 5.3% |
4 | 6454 | 4.3% |
d | 6358 | 4.2% |
2 | 4155 | 2.8% |
Other values (6) | 8362 | 5.6% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 138426 | |
Lowercase Letter | 11574 | 7.7% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 44188 | |
3 | 21428 | |
9 | 18699 | |
1 | 15221 | 11.0% |
5 | 8983 | 6.5% |
8 | 8264 | 6.0% |
6 | 7888 | 5.7% |
4 | 6454 | 4.7% |
2 | 4155 | 3.0% |
7 | 3146 | 2.3% |
Lowercase Letter
Value | Count | Frequency (%) |
d | 6358 | |
e | 1364 | 11.8% |
f | 1115 | 9.6% |
a | 992 | 8.6% |
c | 983 | 8.5% |
b | 762 | 6.6% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 138426 | |
Latin | 11574 | 7.7% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 44188 | |
3 | 21428 | |
9 | 18699 | |
1 | 15221 | 11.0% |
5 | 8983 | 6.5% |
8 | 8264 | 6.0% |
6 | 7888 | 5.7% |
4 | 6454 | 4.7% |
2 | 4155 | 3.0% |
7 | 3146 | 2.3% |
Latin
Value | Count | Frequency (%) |
d | 6358 | |
e | 1364 | 11.8% |
f | 1115 | 9.6% |
a | 992 | 8.6% |
c | 983 | 8.5% |
b | 762 | 6.6% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 150000 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 44188 | |
3 | 21428 | |
9 | 18699 | |
1 | 15221 | 10.1% |
5 | 8983 | 6.0% |
8 | 8264 | 5.5% |
6 | 7888 | 5.3% |
4 | 6454 | 4.3% |
d | 6358 | 4.2% |
2 | 4155 | 2.8% |
Other values (6) | 8362 | 5.6% |
접속간격
Categorical
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
120 | |
---|---|
240 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 120 |
---|---|
2nd row | 120 |
3rd row | 240 |
4th row | 240 |
5th row | 240 |
Common Values
Value | Count | Frequency (%) |
120 | 5086 | |
240 | 4914 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
120 | 5086 | |
240 | 4914 |
수동유지
Real number (ℝ)
Distinct | 14 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 9.9892 |
Minimum | 0 |
---|---|
Maximum | 30 |
Zeros | 9 |
Zeros (%) | 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 10 |
Q1 | 10 |
median | 10 |
Q3 | 10 |
95-th percentile | 10 |
Maximum | 30 |
Range | 30 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 1.8527889 |
---|---|
Coefficient of variation (CV) | 0.18547921 |
Kurtosis | 84.047344 |
Mean | 9.9892 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 6.4162754 |
Sum | 99892 |
Variance | 3.4328266 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
10 | 9732 | |
2 | 69 | 0.7% |
30 | 60 | 0.6% |
3 | 40 | 0.4% |
4 | 34 | 0.3% |
5 | 13 | 0.1% |
1 | 12 | 0.1% |
0 | 9 | 0.1% |
6 | 9 | 0.1% |
8 | 6 | 0.1% |
Other values (4) | 16 | 0.2% |
Value | Count | Frequency (%) |
0 | 9 | 0.1% |
1 | 12 | 0.1% |
2 | 69 | 0.7% |
3 | 40 | 0.4% |
4 | 34 | 0.3% |
5 | 13 | 0.1% |
6 | 9 | 0.1% |
8 | 6 | 0.1% |
9 | 6 | 0.1% |
10 | 9732 |
Value | Count | Frequency (%) |
30 | 60 | 0.6% |
20 | 3 | < 0.1% |
15 | 2 | < 0.1% |
11 | 5 | 0.1% |
10 | 9732 | |
9 | 6 | 0.1% |
8 | 6 | 0.1% |
6 | 9 | 0.1% |
5 | 13 | 0.1% |
4 | 34 | 0.3% |
지역ID
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
1 | |
---|---|
2 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | < 0.1% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 9999 | |
2 | 1 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 9999 | |
2 | 1 | < 0.1% |
점등편차
Real number (ℝ)
Distinct | 7 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -15.0769 |
Minimum | -45 |
---|---|
Maximum | -5 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 10000 |
Negative (%) | 100.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | -45 |
---|---|
5-th percentile | -15 |
Q1 | -15 |
median | -15 |
Q3 | -15 |
95-th percentile | -15 |
Maximum | -5 |
Range | 40 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 1.342597 |
---|---|
Coefficient of variation (CV) | -0.089049936 |
Kurtosis | 374.68485 |
Mean | -15.0769 |
Median Absolute Deviation (MAD) | 0 |
Skewness | -18.195806 |
Sum | -150769 |
Variance | 1.8025666 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-15 | 9934 | |
-20 | 21 | 0.2% |
-30 | 20 | 0.2% |
-45 | 14 | 0.1% |
-10 | 6 | 0.1% |
-5 | 3 | < 0.1% |
-17 | 2 | < 0.1% |
Value | Count | Frequency (%) |
-45 | 14 | 0.1% |
-30 | 20 | 0.2% |
-20 | 21 | 0.2% |
-17 | 2 | < 0.1% |
-15 | 9934 | |
-10 | 6 | 0.1% |
-5 | 3 | < 0.1% |
Value | Count | Frequency (%) |
-5 | 3 | < 0.1% |
-10 | 6 | 0.1% |
-15 | 9934 | |
-17 | 2 | < 0.1% |
-20 | 21 | 0.2% |
-30 | 20 | 0.2% |
-45 | 14 | 0.1% |
소등편차
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
15 | |
---|---|
5 | 747 |
13 | 17 |
30 | 3 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 1.9253 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 15 |
---|---|
2nd row | 15 |
3rd row | 15 |
4th row | 15 |
5th row | 15 |
Common Values
Value | Count | Frequency (%) |
15 | 9233 | |
5 | 747 | 7.5% |
13 | 17 | 0.2% |
30 | 3 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
15 | 9233 | |
5 | 747 | 7.5% |
13 | 17 | 0.2% |
30 | 3 | < 0.1% |
심야소등시작시간
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
XX |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | XX |
---|---|
2nd row | XX |
3rd row | XX |
4th row | XX |
5th row | XX |
Common Values
Value | Count | Frequency (%) |
XX | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
xx | 10000 |
심야소등시작분
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
심야소등해제시간
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
19 | 3 |
Length
Max length | 2 |
---|---|
Median length | 1 |
Mean length | 1.0003 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 9997 | |
19 | 3 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9997 | |
19 | 3 | < 0.1% |
심야소등해제분
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
심야소등적용기간
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
1011231 | |
---|---|
6011231 | 3 |
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1011231 |
---|---|
2nd row | 1011231 |
3rd row | 1011231 |
4th row | 1011231 |
5th row | 1011231 |
Common Values
Value | Count | Frequency (%) |
1011231 | 9997 | |
6011231 | 3 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1011231 | 9997 | |
6011231 | 3 | < 0.1% |
디밍시1
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
XX |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | XX |
---|---|
2nd row | XX |
3rd row | XX |
4th row | XX |
5th row | XX |
Common Values
Value | Count | Frequency (%) |
XX | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
xx | 10000 |
디밍분1
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
디밍값1(%)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 100 |
---|---|
2nd row | 100 |
3rd row | 100 |
4th row | 100 |
5th row | 100 |
Common Values
Value | Count | Frequency (%) |
100 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 10000 |
디밍시2
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
XX |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | XX |
---|---|
2nd row | XX |
3rd row | XX |
4th row | XX |
5th row | XX |
Common Values
Value | Count | Frequency (%) |
XX | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
xx | 10000 |
디밍분2
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
디밍값2(%)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 | |
---|---|
30 | 10 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.999 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 100 |
---|---|
2nd row | 100 |
3rd row | 100 |
4th row | 100 |
5th row | 100 |
Common Values
Value | Count | Frequency (%) |
100 | 9990 | |
30 | 10 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 9990 | |
30 | 10 | 0.1% |
디밍시3
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
XX |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | XX |
---|---|
2nd row | XX |
3rd row | XX |
4th row | XX |
5th row | XX |
Common Values
Value | Count | Frequency (%) |
XX | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
xx | 10000 |
디밍분3
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
디밍값3(%)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 100 |
---|---|
2nd row | 100 |
3rd row | 100 |
4th row | 100 |
5th row | 100 |
Common Values
Value | Count | Frequency (%) |
100 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 10000 |
현재디밍값(%)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 100 |
---|---|
2nd row | 100 |
3rd row | 100 |
4th row | 100 |
5th row | 100 |
Common Values
Value | Count | Frequency (%) |
100 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 10000 |
현재전력값(W)
Real number (ℝ)
ZEROS
 
Distinct | 126 |
---|---|
Distinct (%) | 1.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 27.581 |
Minimum | 0 |
---|---|
Maximum | 225 |
Zeros | 4779 |
Zeros (%) | 47.8% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 26 |
Q3 | 51 |
95-th percentile | 96 |
Maximum | 225 |
Range | 225 |
Interquartile range (IQR) | 51 |
Descriptive statistics
Standard deviation | 31.393987 |
---|---|
Coefficient of variation (CV) | 1.1382469 |
Kurtosis | 1.3962053 |
Mean | 27.581 |
Median Absolute Deviation (MAD) | 26 |
Skewness | 1.077036 |
Sum | 275810 |
Variance | 985.5824 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 4779 | |
52 | 655 | 6.6% |
51 | 471 | 4.7% |
47 | 394 | 3.9% |
50 | 364 | 3.6% |
53 | 353 | 3.5% |
26 | 350 | 3.5% |
27 | 196 | 2.0% |
54 | 195 | 1.9% |
48 | 185 | 1.8% |
Other values (116) | 2058 |
Value | Count | Frequency (%) |
0 | 4779 | |
20 | 1 | < 0.1% |
23 | 8 | 0.1% |
24 | 23 | 0.2% |
25 | 99 | 1.0% |
26 | 350 | 3.5% |
27 | 196 | 2.0% |
28 | 135 | 1.4% |
29 | 86 | 0.9% |
30 | 115 | 1.1% |
Value | Count | Frequency (%) |
225 | 1 | |
216 | 2 | |
208 | 2 | |
201 | 1 | |
199 | 2 | |
198 | 2 | |
177 | 1 | |
169 | 1 | |
159 | 1 | |
158 | 2 |
램프고장(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 5 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 9995 | |
1 | 5 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9995 | |
1 | 5 | < 0.1% |
이상점등(정상:0, 고장:1)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 10000 |
누전발생(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | < 0.1% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 9999 | |
1 | 1 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9999 | |
1 | 1 | < 0.1% |
안정기고장(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 11 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 9989 | |
1 | 11 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9989 | |
1 | 11 | 0.1% |
깜빡거림(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 17 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 9983 | |
1 | 17 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9983 | |
1 | 17 | 0.2% |
점소등상태(정상:0, 고장:1)
Categorical
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
1 | |
---|---|
0 |
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 | 0 |
3rd row | 1 |
4th row | 1 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
1 | 5231 | |
0 | 4769 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 5231 | |
0 | 4769 |
수동/강제상태(정상:0, 고장:1)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
2 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 2 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
2 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 10000 |
등록일자
Date
Distinct | 7998 |
---|---|
Distinct (%) | 80.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2024-04-01 00:00:05 |
---|---|
Maximum | 2024-04-02 04:19:23 |
기관 명 | 모델명 | 시리얼 | 접속간격 | 수동유지 | 지역ID | 점등편차 | 소등편차 | 심야소등시작시간 | 심야소등시작분 | 심야소등해제시간 | 심야소등해제분 | 심야소등적용기간 | 디밍시1 | 디밍분1 | 디밍값1(%) | 디밍시2 | 디밍분2 | 디밍값2(%) | 디밍시3 | 디밍분3 | 디밍값3(%) | 현재디밍값(%) | 현재전력값(W) | 램프고장(정상:0, 고장:1) | 이상점등(정상:0, 고장:1) | 누전발생(정상:0, 고장:1) | 안정기고장(정상:0, 고장:1) | 깜빡거림(정상:0, 고장:1) | 점소등상태(정상:0, 고장:1) | 수동/강제상태(정상:0, 고장:1) | 등록일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3152 | 강북구 | BMC-300S | 019010d00003a2a | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 26 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 05:08:22 |
13009 | 강북구 | BMC-300S | 019010d00003f34 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 18:37:40 |
17771 | 강북구 | BMC-300S | 359369083367751 | 240 | 0 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 52 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-02 00:47:37 |
16754 | 강북구 | BMC-300S | 359369084334008 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 55 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 23:16:15 |
5872 | 강북구 | BMC-300S | 359369081409951 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 09:05:27 |
6532 | 강북구 | BMC-300S | 359369083293585 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 10:05:49 |
17787 | 강북구 | BMC-300S | 019010d00003a33 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 27 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-02 00:49:21 |
2127 | 강북구 | BMC-300S | 359369083303558 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 26 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 03:14:26 |
8864 | 강북구 | BMC-300S | 019010d00003f54 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 13:58:06 |
9477 | 강북구 | BMC-300S | 359369083483400 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 14:11:13 |
기관 명 | 모델명 | 시리얼 | 접속간격 | 수동유지 | 지역ID | 점등편차 | 소등편차 | 심야소등시작시간 | 심야소등시작분 | 심야소등해제시간 | 심야소등해제분 | 심야소등적용기간 | 디밍시1 | 디밍분1 | 디밍값1(%) | 디밍시2 | 디밍분2 | 디밍값2(%) | 디밍시3 | 디밍분3 | 디밍값3(%) | 현재디밍값(%) | 현재전력값(W) | 램프고장(정상:0, 고장:1) | 이상점등(정상:0, 고장:1) | 누전발생(정상:0, 고장:1) | 안정기고장(정상:0, 고장:1) | 깜빡거림(정상:0, 고장:1) | 점소등상태(정상:0, 고장:1) | 수동/강제상태(정상:0, 고장:1) | 등록일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8754 | 강북구 | BMC-300S | 019010d00003f3e | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 13:39:50 |
18961 | 강북구 | BMC-300S | 359369083220232 | 240 | 10 | 1 | -15 | 5 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 28 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-02 03:15:43 |
2216 | 강북구 | BMC-300S | 019010d0000d4a6 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 52 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 03:15:09 |
19859 | 강북구 | BMC-300S | 019010d00003f4a | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 25 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-02 03:27:14 |
14059 | 강북구 | BMC-300S | 359369083324992 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 30 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 19:12:47 |
8993 | 강북구 | BMC-300S | 359369083484127 | 240 | 10 | 1 | -15 | 5 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 14:02:26 |
13171 | 강북구 | BMC-300S | 019010d00006938 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 19:00:12 |
16814 | 강북구 | BMC-300S | 359369083302063 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 27 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 23:16:36 |
6395 | 강북구 | BMC-300S | 019010d0000d787 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2024-04-01 10:03:36 |
1387 | 강북구 | BMC-300S | 019010d0000c7d3 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 51 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2024-04-01 03:08:56 |