Dataset statistics
Number of variables | 32 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 1 |
Duplicate rows (%) | < 0.1% |
Total size in memory | 2.7 MiB |
Average record size in memory | 288.0 B |
Variable types
Categorical | 26 |
---|---|
Text | 1 |
Numeric | 4 |
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 |
디밍시2 has constant value "" | Constant |
디밍분2 has constant value "" | Constant |
디밍시3 has constant value "" | Constant |
디밍분3 has constant value "" | Constant |
이상점등(정상:0, 고장:1) has constant value "" | Constant |
누전발생(정상:0, 고장:1) has constant value "" | Constant |
Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
지역ID is highly imbalanced (99.3%) | Imbalance |
소등편차 is highly imbalanced (78.3%) | Imbalance |
심야소등해제시간 is highly imbalanced (99.3%) | Imbalance |
디밍값1(%) is highly imbalanced (99.4%) | Imbalance |
디밍값2(%) is highly imbalanced (98.9%) | Imbalance |
디밍값3(%) is highly imbalanced (99.5%) | Imbalance |
현재디밍값(%) is highly imbalanced (99.3%) | Imbalance |
램프고장(정상:0, 고장:1) is highly imbalanced (99.5%) | Imbalance |
안정기고장(정상:0, 고장:1) is highly imbalanced (99.3%) | Imbalance |
깜빡거림(정상:0, 고장:1) is highly imbalanced (97.6%) | Imbalance |
수동/강제상태(정상:0, 고장:1) is highly imbalanced (99.3%) | Imbalance |
점등편차 is highly skewed (γ1 = -21.63395204) | Skewed |
심야소등적용기간 is highly skewed (γ1 = 37.3376869) | Skewed |
현재전력값(W) has 3910 (39.1%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-03 21:21:40.551630 |
---|---|
Analysis finished | 2024-05-03 21:21:41.828116 |
Duration | 1.28 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 | 1939 |
---|---|
Distinct (%) | 19.4% |
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 | 62 ? |
---|---|
Unique (%) | 0.6% |
Sample
1st row | 359369084330600 |
---|---|
2nd row | 359369084345400 |
3rd row | 019010d00010f0e |
4th row | 359369083432878 |
5th row | 019010d00014696 |
Value | Count | Frequency (%) |
359369083367751 | 15 | 0.1% |
019010d00013a48 | 14 | 0.1% |
019010d00013a3e | 14 | 0.1% |
019010d00010f0f | 13 | 0.1% |
019010d00005c53 | 13 | 0.1% |
019010d000149e6 | 13 | 0.1% |
019010d000146a4 | 12 | 0.1% |
019010d00013a4f | 12 | 0.1% |
019010d00003e7c | 12 | 0.1% |
019010d0001226f | 12 | 0.1% |
Other values (1929) | 9870 |
Most occurring characters
Value | Count | Frequency (%) |
0 | 42732 | |
3 | 22417 | |
9 | 19113 | |
1 | 14742 | 9.8% |
5 | 9235 | 6.2% |
8 | 8627 | 5.8% |
6 | 8142 | 5.4% |
4 | 6618 | 4.4% |
d | 5986 | 4.0% |
2 | 4307 | 2.9% |
Other values (6) | 8081 | 5.4% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 139009 | |
Lowercase Letter | 10991 | 7.3% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 42732 | |
3 | 22417 | |
9 | 19113 | |
1 | 14742 | 10.6% |
5 | 9235 | 6.6% |
8 | 8627 | 6.2% |
6 | 8142 | 5.9% |
4 | 6618 | 4.8% |
2 | 4307 | 3.1% |
7 | 3076 | 2.2% |
Lowercase Letter
Value | Count | Frequency (%) |
d | 5986 | |
e | 1308 | 11.9% |
f | 1059 | 9.6% |
c | 967 | 8.8% |
a | 948 | 8.6% |
b | 723 | 6.6% |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 139009 | |
Latin | 10991 | 7.3% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 42732 | |
3 | 22417 | |
9 | 19113 | |
1 | 14742 | 10.6% |
5 | 9235 | 6.6% |
8 | 8627 | 6.2% |
6 | 8142 | 5.9% |
4 | 6618 | 4.8% |
2 | 4307 | 3.1% |
7 | 3076 | 2.2% |
Latin
Value | Count | Frequency (%) |
d | 5986 | |
e | 1308 | 11.9% |
f | 1059 | 9.6% |
c | 967 | 8.8% |
a | 948 | 8.6% |
b | 723 | 6.6% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 150000 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 42732 | |
3 | 22417 | |
9 | 19113 | |
1 | 14742 | 9.8% |
5 | 9235 | 6.2% |
8 | 8627 | 5.8% |
6 | 8142 | 5.4% |
4 | 6618 | 4.4% |
d | 5986 | 4.0% |
2 | 4307 | 2.9% |
Other values (6) | 8081 | 5.4% |
접속간격
Categorical
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
240 | |
---|---|
120 | |
100 | 6 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 240 |
---|---|
2nd row | 240 |
3rd row | 120 |
4th row | 240 |
5th row | 120 |
Common Values
Value | Count | Frequency (%) |
240 | 5170 | |
120 | 4824 | |
100 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
240 | 5170 | |
120 | 4824 | |
100 | 6 | 0.1% |
수동유지
Real number (ℝ)
Distinct | 13 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 9.9541 |
Minimum | 0 |
---|---|
Maximum | 30 |
Zeros | 15 |
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.7763189 |
---|---|
Coefficient of variation (CV) | 0.17845098 |
Kurtosis | 83.015994 |
Mean | 9.9541 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 5.4783153 |
Sum | 99541 |
Variance | 3.1553087 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
10 | 9723 | |
2 | 75 | 0.8% |
30 | 48 | 0.5% |
3 | 47 | 0.5% |
4 | 26 | 0.3% |
1 | 18 | 0.2% |
0 | 15 | 0.1% |
5 | 13 | 0.1% |
9 | 10 | 0.1% |
20 | 9 | 0.1% |
Other values (3) | 16 | 0.2% |
Value | Count | Frequency (%) |
0 | 15 | 0.1% |
1 | 18 | 0.2% |
2 | 75 | 0.8% |
3 | 47 | 0.5% |
4 | 26 | 0.3% |
5 | 13 | 0.1% |
6 | 7 | 0.1% |
8 | 6 | 0.1% |
9 | 10 | 0.1% |
10 | 9723 |
Value | Count | Frequency (%) |
30 | 48 | 0.5% |
20 | 9 | 0.1% |
11 | 3 | < 0.1% |
10 | 9723 | |
9 | 10 | 0.1% |
8 | 6 | 0.1% |
6 | 7 | 0.1% |
5 | 13 | 0.1% |
4 | 26 | 0.3% |
3 | 47 | 0.5% |
지역ID
Categorical
IMBALANCE
 
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
1 | |
---|---|
0 | 5 |
2 | 4 |
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 | 9991 | |
0 | 5 | 0.1% |
2 | 4 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 9991 | |
0 | 5 | < 0.1% |
2 | 4 | < 0.1% |
점등편차
Real number (ℝ)
SKEWED
 
Distinct | 7 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -15.0461 |
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.1647791 |
---|---|
Coefficient of variation (CV) | -0.077414024 |
Kurtosis | 544.94209 |
Mean | -15.0461 |
Median Absolute Deviation (MAD) | 0 |
Skewness | -21.633952 |
Sum | -150461 |
Variance | 1.3567105 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-15 | 9945 | |
-20 | 18 | 0.2% |
-45 | 12 | 0.1% |
-10 | 10 | 0.1% |
-30 | 7 | 0.1% |
-5 | 5 | 0.1% |
-17 | 3 | < 0.1% |
Value | Count | Frequency (%) |
-45 | 12 | 0.1% |
-30 | 7 | 0.1% |
-20 | 18 | 0.2% |
-17 | 3 | < 0.1% |
-15 | 9945 | |
-10 | 10 | 0.1% |
-5 | 5 | 0.1% |
Value | Count | Frequency (%) |
-5 | 5 | 0.1% |
-10 | 10 | 0.1% |
-15 | 9945 | |
-17 | 3 | < 0.1% |
-20 | 18 | 0.2% |
-30 | 7 | 0.1% |
-45 | 12 | 0.1% |
소등편차
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
15 | |
---|---|
5 | 827 |
13 | 15 |
10 | 6 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 1.9173 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5 |
---|---|
2nd row | 15 |
3rd row | 15 |
4th row | 15 |
5th row | 15 |
Common Values
Value | Count | Frequency (%) |
15 | 9152 | |
5 | 827 | 8.3% |
13 | 15 | 0.1% |
10 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
15 | 9152 | |
5 | 827 | 8.3% |
13 | 15 | 0.1% |
10 | 6 | 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 | 6 |
Length
Max length | 2 |
---|---|
Median length | 1 |
Mean length | 1.0006 |
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 | 9994 | |
19 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9994 | |
19 | 6 | 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 |
심야소등적용기간
Real number (ℝ)
SKEWED
 
Distinct | 9 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1017923.9 |
Minimum | 1030 |
---|---|
Maximum | 12011231 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1030 |
---|---|
5-th percentile | 1011231 |
Q1 | 1011231 |
median | 1011231 |
Q3 | 1011231 |
95-th percentile | 1011231 |
Maximum | 12011231 |
Range | 12010201 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 253128.2 |
---|---|
Coefficient of variation (CV) | 0.24867106 |
Kurtosis | 1512.1153 |
Mean | 1017923.9 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 37.337687 |
Sum | 1.0179239 × 1010 |
Variance | 6.4073886 × 1010 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1011231 | 9981 | |
6011231 | 6 | 0.1% |
1030 | 4 | < 0.1% |
12011231 | 4 | < 0.1% |
1231 | 1 | < 0.1% |
1011031 | 1 | < 0.1% |
1001030 | 1 | < 0.1% |
11031 | 1 | < 0.1% |
1230 | 1 | < 0.1% |
Value | Count | Frequency (%) |
1030 | 4 | < 0.1% |
1230 | 1 | < 0.1% |
1231 | 1 | < 0.1% |
11031 | 1 | < 0.1% |
1001030 | 1 | < 0.1% |
1011031 | 1 | < 0.1% |
1011231 | 9981 | |
6011231 | 6 | 0.1% |
12011231 | 4 | < 0.1% |
Value | Count | Frequency (%) |
12011231 | 4 | < 0.1% |
6011231 | 6 | 0.1% |
1011231 | 9981 | |
1011031 | 1 | < 0.1% |
1001030 | 1 | < 0.1% |
11031 | 1 | < 0.1% |
1231 | 1 | < 0.1% |
1230 | 1 | < 0.1% |
1030 | 4 | < 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
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 | |
---|---|
96 | 5 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.9995 |
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 | 9995 | |
96 | 5 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 9995 | |
96 | 5 | < 0.1% |
디밍시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 | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 | |
---|---|
96 | 8 |
30 | 6 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.9986 |
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 | 9986 | |
96 | 8 | 0.1% |
30 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 9986 | |
96 | 8 | 0.1% |
30 | 6 | 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
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 | |
---|---|
96 | 4 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.9996 |
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 | 9996 | |
96 | 4 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 9996 | |
96 | 4 | < 0.1% |
현재디밍값(%)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
100 | |
---|---|
96 | 6 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 2.9994 |
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 | 9994 | |
96 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
100 | 9994 | |
96 | 6 | 0.1% |
현재전력값(W)
Real number (ℝ)
ZEROS
 
Distinct | 130 |
---|---|
Distinct (%) | 1.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 32.6506 |
Minimum | 0 |
---|---|
Maximum | 390 |
Zeros | 3910 |
Zeros (%) | 39.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 30 |
Q3 | 52 |
95-th percentile | 101 |
Maximum | 390 |
Range | 390 |
Interquartile range (IQR) | 52 |
Descriptive statistics
Standard deviation | 32.659629 |
---|---|
Coefficient of variation (CV) | 1.0002765 |
Kurtosis | 3.0152721 |
Mean | 32.6506 |
Median Absolute Deviation (MAD) | 26 |
Skewness | 1.1018012 |
Sum | 326506 |
Variance | 1066.6514 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 3910 | |
52 | 593 | 5.9% |
53 | 577 | 5.8% |
51 | 568 | 5.7% |
48 | 426 | 4.3% |
27 | 353 | 3.5% |
50 | 326 | 3.3% |
26 | 296 | 3.0% |
54 | 244 | 2.4% |
47 | 206 | 2.1% |
Other values (120) | 2501 |
Value | Count | Frequency (%) |
0 | 3910 | |
22 | 1 | < 0.1% |
23 | 11 | 0.1% |
24 | 13 | 0.1% |
25 | 111 | 1.1% |
26 | 296 | 3.0% |
27 | 353 | 3.5% |
28 | 155 | 1.6% |
29 | 131 | 1.3% |
30 | 105 | 1.1% |
Value | Count | Frequency (%) |
390 | 1 | < 0.1% |
229 | 1 | < 0.1% |
220 | 2 | < 0.1% |
216 | 3 | |
212 | 2 | < 0.1% |
205 | 2 | < 0.1% |
201 | 2 | < 0.1% |
200 | 6 | |
198 | 2 | < 0.1% |
180 | 1 | < 0.1% |
램프고장(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 4 |
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 | 9996 | |
1 | 4 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9996 | |
1 | 4 | < 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
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 | 6 |
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 | 9994 | |
1 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9994 | |
1 | 6 | 0.1% |
깜빡거림(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
0 | |
---|---|
1 | 24 |
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 | 9976 | |
1 | 24 | 0.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 9976 | |
1 | 24 | 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 | 0 |
---|---|
2nd row | 0 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 6099 | |
0 | 3901 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 6099 | |
0 | 3901 |
수동/강제상태(정상:0, 고장:1)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
2 | |
---|---|
0 | 6 |
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 | 9994 | |
0 | 6 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 9994 | |
0 | 6 | 0.1% |
등록일자
Date
Distinct | 8640 |
---|---|
Distinct (%) | 86.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2023-12-25 00:00:25 |
---|---|
Maximum | 2023-12-27 08:57:30 |
기관 명 | 모델명 | 시리얼 | 접속간격 | 수동유지 | 지역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) | 등록일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8006 | 강북구 | BMC-300S | 359369084330600 | 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 | 2023-12-25 11:26:32 |
6370 | 강북구 | BMC-300S | 359369084345400 | 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 | 2023-12-25 07:36:21 |
21988 | 강북구 | BMC-300S | 019010d00010f0e | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 48 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-26 06:05:37 |
29879 | 강북구 | BMC-300S | 359369083432878 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 95 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-26 17:36:34 |
34758 | 강북구 | BMC-300S | 019010d00014696 | 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 | 2023-12-27 00:23:37 |
14660 | 강북구 | BMC-300S | 359369084333539 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 198 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-25 19:38:23 |
34706 | 강북구 | BMC-300S | 019010d000149f8 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 29 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-27 00:14:48 |
23370 | 강북구 | BMC-300S | 359369083303731 | 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 | 2023-12-26 07:36:21 |
9491 | 강북구 | BMC-300S | 019010d00006a89 | 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 | 1 | 0 | 2 | 2023-12-25 12:26:35 |
36763 | 강북구 | BMC-300S | 019010d0000ba82 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 94 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-27 02:26:55 |
기관 명 | 모델명 | 시리얼 | 접속간격 | 수동유지 | 지역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) | 등록일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1232 | 강북구 | BMC-300S | 359369083304085 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 131 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-25 01:42:19 |
20205 | 강북구 | BMC-300S | 019010d00013707 | 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 | 2023-12-26 04:20:37 |
6074 | 강북구 | BMC-300S | 359369083304325 | 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 | 2023-12-25 07:34:56 |
14433 | 강북구 | BMC-300S | 019010d00004be6 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 101 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-25 19:02:21 |
19753 | 강북구 | BMC-300S | 019010d00003e97 | 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 | 2023-12-26 03:05:29 |
29593 | 강북구 | BMC-300S | 019010d00010f03 | 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 | 2023-12-26 17:08:26 |
19262 | 강북구 | BMC-300S | 019010d00012289 | 120 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 49 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-26 02:00:15 |
20552 | 강북구 | BMC-300S | 019010d00003e97 | 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 | 2023-12-26 05:06:14 |
22463 | 강북구 | BMC-300S | 359369083481131 | 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 | 2023-12-26 07:23:22 |
752 | 강북구 | BMC-300S | 359369083407052 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 57 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-25 01:37:46 |
Most frequently occurring
기관 명 | 모델명 | 시리얼 | 접속간격 | 수동유지 | 지역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) | 등록일자 | # duplicates | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 강북구 | BMC-300S | 359369083301123 | 240 | 10 | 1 | -15 | 15 | XX | 0 | 0 | 0 | 1011231 | XX | 0 | 100 | XX | 0 | 100 | XX | 0 | 100 | 100 | 46 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2023-12-26 01:44:58 | 2 |