Overview

Dataset statistics

Number of variables32
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 MiB
Average record size in memory288.0 B

Variable types

Categorical27
Text1
Numeric3
DateTime1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15961/S/1/datasetView.do

Alerts

기관 명 has constant value ""Constant
모델명 has constant value ""Constant
접속간격 has constant value ""Constant
지역ID has constant value ""Constant
디밍시2 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
수동/강제상태(정상:0, 고장:1) has constant value ""Constant
수동유지 is highly imbalanced (98.9%)Imbalance
심야소등시작시간 is highly imbalanced (99.5%)Imbalance
심야소등시작분 is highly imbalanced (99.7%)Imbalance
심야소등해제시간 is highly imbalanced (99.5%)Imbalance
심야소등해제분 is highly imbalanced (99.7%)Imbalance
심야소등적용기간 is highly imbalanced (99.2%)Imbalance
디밍시1 is highly imbalanced (74.5%)Imbalance
디밍분1 is highly imbalanced (99.7%)Imbalance
디밍값1(%) is highly imbalanced (79.4%)Imbalance
현재디밍값(%) is highly imbalanced (74.5%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.3%)Imbalance
이상점등(정상:0, 고장:1) is highly imbalanced (99.7%)Imbalance
누전발생(정상:0, 고장:1) is highly imbalanced (99.9%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (96.4%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (99.3%)Imbalance
현재전력값(W) has 4972 (49.7%) zerosZeros

Reproduction

Analysis started2024-05-11 16:03:41.648300
Analysis finished2024-05-11 16:03:42.859235
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
광진구
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광진구
2nd row광진구
3rd row광진구
4th row광진구
5th row광진구

Common Values

ValueCountFrequency (%)
광진구 10000
100.0%

Length

2024-05-12T01:03:42.967035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:43.125036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광진구 10000
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
BMC-300S
10000 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowBMC-300S
2nd rowBMC-300S
3rd rowBMC-300S
4th rowBMC-300S
5th rowBMC-300S

Common Values

ValueCountFrequency (%)
BMC-300S 10000
100.0%

Length

2024-05-12T01:03:43.287361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:43.443146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
bmc-300s 10000
100.0%

시리얼
Text

Distinct3121
Distinct (%)31.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:03:44.061879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

Total characters150000
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique293 ?
Unique (%)2.9%

Sample

1st row019010d00005b58
2nd row019010d00000cdf
3rd row019010d00000c48
4th row019010d00000be5
5th row019010d0000987f
ValueCountFrequency (%)
019010d00006116 8
 
0.1%
019010d000012b4 8
 
0.1%
019010d00001350 8
 
0.1%
019010d0000f293 7
 
0.1%
019010d00008213 7
 
0.1%
019010d00000ae7 7
 
0.1%
019010d000060d5 7
 
0.1%
019010d000012aa 7
 
0.1%
019010d00000b99 7
 
0.1%
019010d00000c73 7
 
0.1%
Other values (3111) 9927
99.3%
2024-05-12T01:03:44.933769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 73894
49.3%
1 25705
 
17.1%
9 12375
 
8.2%
d 12320
 
8.2%
a 2948
 
2.0%
b 2826
 
1.9%
5 2688
 
1.8%
6 2251
 
1.5%
2 2236
 
1.5%
4 2093
 
1.4%
Other values (6) 10664
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 126257
84.2%
Lowercase Letter 23743
 
15.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 73894
58.5%
1 25705
 
20.4%
9 12375
 
9.8%
5 2688
 
2.1%
6 2251
 
1.8%
2 2236
 
1.8%
4 2093
 
1.7%
3 1877
 
1.5%
7 1632
 
1.3%
8 1506
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
d 12320
51.9%
a 2948
 
12.4%
b 2826
 
11.9%
c 2070
 
8.7%
f 1958
 
8.2%
e 1621
 
6.8%

Most occurring scripts

ValueCountFrequency (%)
Common 126257
84.2%
Latin 23743
 
15.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 73894
58.5%
1 25705
 
20.4%
9 12375
 
9.8%
5 2688
 
2.1%
6 2251
 
1.8%
2 2236
 
1.8%
4 2093
 
1.7%
3 1877
 
1.5%
7 1632
 
1.3%
8 1506
 
1.2%
Latin
ValueCountFrequency (%)
d 12320
51.9%
a 2948
 
12.4%
b 2826
 
11.9%
c 2070
 
8.7%
f 1958
 
8.2%
e 1621
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 150000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 73894
49.3%
1 25705
 
17.1%
9 12375
 
8.2%
d 12320
 
8.2%
a 2948
 
2.0%
b 2826
 
1.9%
5 2688
 
1.8%
6 2251
 
1.5%
2 2236
 
1.5%
4 2093
 
1.4%
Other values (6) 10664
 
7.1%

접속간격
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
120
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
120 10000
100.0%

Length

2024-05-12T01:03:45.157303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:45.315232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
120 10000
100.0%

수동유지
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
10
9985 
1
 
13
14
 
2

Length

Max length2
Median length2
Mean length1.9987
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 9985
99.9%
1 13
 
0.1%
14 2
 
< 0.1%

Length

2024-05-12T01:03:45.482951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:45.655566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 9985
99.9%
1 13
 
0.1%
14 2
 
< 0.1%

지역ID
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
10000 

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

Length

2024-05-12T01:03:45.834290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:45.989600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

점등편차
Real number (ℝ)

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-19.9383
Minimum-79
Maximum9
Zeros0
Zeros (%)0.0%
Negative9996
Negative (%)> 99.9%
Memory size166.0 KiB
2024-05-12T01:03:46.135480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-79
5-th percentile-20
Q1-20
median-20
Q3-20
95-th percentile-20
Maximum9
Range88
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.8099781
Coefficient of variation (CV)-0.090778958
Kurtosis467.06629
Mean-19.9383
Median Absolute Deviation (MAD)0
Skewness-15.159869
Sum-199383
Variance3.2760207
MonotonicityNot monotonic
2024-05-12T01:03:46.315423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
-20 9743
97.4%
-15 229
 
2.3%
-60 6
 
0.1%
-40 5
 
0.1%
9 4
 
< 0.1%
-30 4
 
< 0.1%
-35 3
 
< 0.1%
-70 3
 
< 0.1%
-25 2
 
< 0.1%
-79 1
 
< 0.1%
ValueCountFrequency (%)
-79 1
 
< 0.1%
-70 3
 
< 0.1%
-60 6
 
0.1%
-40 5
 
0.1%
-35 3
 
< 0.1%
-30 4
 
< 0.1%
-25 2
 
< 0.1%
-20 9743
97.4%
-15 229
 
2.3%
9 4
 
< 0.1%
ValueCountFrequency (%)
9 4
 
< 0.1%
-15 229
 
2.3%
-20 9743
97.4%
-25 2
 
< 0.1%
-30 4
 
< 0.1%
-35 3
 
< 0.1%
-40 5
 
0.1%
-60 6
 
0.1%
-70 3
 
< 0.1%
-79 1
 
< 0.1%

소등편차
Real number (ℝ)

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.1099
Minimum-15
Maximum60
Zeros0
Zeros (%)0.0%
Negative1
Negative (%)< 0.1%
Memory size166.0 KiB
2024-05-12T01:03:46.492918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-15
5-th percentile13
Q113
median13
Q313
95-th percentile13
Maximum60
Range75
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.065151
Coefficient of variation (CV)0.15752606
Kurtosis452.24093
Mean13.1099
Median Absolute Deviation (MAD)0
Skewness19.83724
Sum131099
Variance4.2648485
MonotonicityNot monotonic
2024-05-12T01:03:46.683619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
13 9734
97.3%
15 209
 
2.1%
5 24
 
0.2%
60 16
 
0.2%
11 6
 
0.1%
34 5
 
0.1%
20 2
 
< 0.1%
12 2
 
< 0.1%
-15 1
 
< 0.1%
57 1
 
< 0.1%
ValueCountFrequency (%)
-15 1
 
< 0.1%
5 24
 
0.2%
11 6
 
0.1%
12 2
 
< 0.1%
13 9734
97.3%
15 209
 
2.1%
20 2
 
< 0.1%
34 5
 
0.1%
57 1
 
< 0.1%
60 16
 
0.2%
ValueCountFrequency (%)
60 16
 
0.2%
57 1
 
< 0.1%
34 5
 
0.1%
20 2
 
< 0.1%
15 209
 
2.1%
13 9734
97.3%
12 2
 
< 0.1%
11 6
 
0.1%
5 24
 
0.2%
-15 1
 
< 0.1%

심야소등시작시간
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9994 
01
 
4
19
 
2

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
XX 9994
99.9%
01 4
 
< 0.1%
19 2
 
< 0.1%

Length

2024-05-12T01:03:46.902490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:47.068312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9994
99.9%
01 4
 
< 0.1%
19 2
 
< 0.1%

심야소등시작분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
39
 
2

Length

Max length2
Median length1
Mean length1.0002
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9998
> 99.9%
39 2
 
< 0.1%

Length

2024-05-12T01:03:47.414054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:47.581887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
39 2
 
< 0.1%

심야소등해제시간
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9994 
3
 
4
22
 
2

Length

Max length2
Median length1
Mean length1.0002
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9994
99.9%
3 4
 
< 0.1%
22 2
 
< 0.1%

Length

2024-05-12T01:03:47.761554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:47.931725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9994
99.9%
3 4
 
< 0.1%
22 2
 
< 0.1%

심야소등해제분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
32
 
2

Length

Max length2
Median length1
Mean length1.0002
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9998
> 99.9%
32 2
 
< 0.1%

Length

2024-05-12T01:03:48.113512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:48.280460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
32 2
 
< 0.1%

심야소등적용기간
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1011231
9985 
0
 
9
5121231
 
3
5010931
 
2
6011231
 
1

Length

Max length7
Median length7
Mean length6.9946
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
1011231 9985
99.9%
0 9
 
0.1%
5121231 3
 
< 0.1%
5010931 2
 
< 0.1%
6011231 1
 
< 0.1%

Length

2024-05-12T01:03:48.462238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:48.647945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1011231 9985
99.9%
0 9
 
0.1%
5121231 3
 
< 0.1%
5010931 2
 
< 0.1%
6011231 1
 
< 0.1%

디밍시1
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9198 
00
 
800
20
 
2

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
XX 9198
92.0%
00 800
 
8.0%
20 2
 
< 0.1%

Length

2024-05-12T01:03:48.838756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:49.004773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9198
92.0%
00 800
 
8.0%
20 2
 
< 0.1%

디밍분1
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
1
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9998
> 99.9%
1 2
 
< 0.1%

Length

2024-05-12T01:03:49.178998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:49.341792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
1 2
 
< 0.1%

디밍값1(%)
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
9193 
60
 
800
90
 
5
10
 
2

Length

Max length3
Median length3
Mean length2.9193
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9193
91.9%
60 800
 
8.0%
90 5
 
0.1%
10 2
 
< 0.1%

Length

2024-05-12T01:03:49.513498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:49.688357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9193
91.9%
60 800
 
8.0%
90 5
 
< 0.1%
10 2
 
< 0.1%

디밍시2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
XX 10000
100.0%

Length

2024-05-12T01:03:49.868214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:50.025541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 10000
100.0%

디밍분2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-05-12T01:03:50.187011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:50.341610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

디밍값2(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 10000
100.0%

Length

2024-05-12T01:03:50.505744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:50.661829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 10000
100.0%

디밍시3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
XX 10000
100.0%

Length

2024-05-12T01:03:50.825724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:50.984622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 10000
100.0%

디밍분3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2024-05-12T01:03:51.147250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:51.303363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

디밍값3(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 10000
100.0%

Length

2024-05-12T01:03:51.464764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:51.623404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 10000
100.0%

현재디밍값(%)
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
9198 
60
 
800
10
 
2

Length

Max length3
Median length3
Mean length2.9198
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9198
92.0%
60 800
 
8.0%
10 2
 
< 0.1%

Length

2024-05-12T01:03:51.788729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:51.960809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9198
92.0%
60 800
 
8.0%
10 2
 
< 0.1%

현재전력값(W)
Real number (ℝ)

ZEROS 

Distinct127
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.8572
Minimum0
Maximum339
Zeros4972
Zeros (%)49.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:03:52.154405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median28
Q350
95-th percentile75
Maximum339
Range339
Interquartile range (IQR)50

Descriptive statistics

Standard deviation31.465464
Coefficient of variation (CV)1.1295272
Kurtosis3.7731988
Mean27.8572
Median Absolute Deviation (MAD)28
Skewness1.1181317
Sum278572
Variance990.07542
MonotonicityNot monotonic
2024-05-12T01:03:52.412268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4972
49.7%
47 526
 
5.3%
46 433
 
4.3%
49 417
 
4.2%
48 392
 
3.9%
50 361
 
3.6%
52 314
 
3.1%
51 292
 
2.9%
45 193
 
1.9%
53 179
 
1.8%
Other values (117) 1921
 
19.2%
ValueCountFrequency (%)
0 4972
49.7%
1 1
 
< 0.1%
2 2
 
< 0.1%
5 2
 
< 0.1%
6 2
 
< 0.1%
7 4
 
< 0.1%
21 1
 
< 0.1%
22 4
 
< 0.1%
23 2
 
< 0.1%
24 1
 
< 0.1%
ValueCountFrequency (%)
339 2
< 0.1%
338 1
< 0.1%
300 2
< 0.1%
188 1
< 0.1%
169 1
< 0.1%
167 1
< 0.1%
158 2
< 0.1%
156 1
< 0.1%
154 2
< 0.1%
147 1
< 0.1%

램프고장(정상:0, 고장:1)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9994 
1
 
6

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9994
99.9%
1 6
 
0.1%

Length

2024-05-12T01:03:52.649940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:52.809656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9994
99.9%
1 6
 
0.1%

이상점등(정상:0, 고장:1)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
1
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9998
> 99.9%
1 2
 
< 0.1%

Length

2024-05-12T01:03:52.978616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:53.139679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
1 2
 
< 0.1%

누전발생(정상:0, 고장:1)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9999 
1
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
0 9999
> 99.9%
1 1
 
< 0.1%

Length

2024-05-12T01:03:53.307917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:53.470834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9999
> 99.9%
1 1
 
< 0.1%

안정기고장(정상:0, 고장:1)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9962 
1
 
38

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9962
99.6%
1 38
 
0.4%

Length

2024-05-12T01:03:53.638412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:53.801195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9962
99.6%
1 38
 
0.4%

깜빡거림(정상:0, 고장:1)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9994 
1
 
6

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9994
99.9%
1 6
 
0.1%

Length

2024-05-12T01:03:53.968091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:54.127851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9994
99.9%
1 6
 
0.1%

점소등상태(정상:0, 고장:1)
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
5039 
0
4961 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 5039
50.4%
0 4961
49.6%

Length

2024-05-12T01:03:54.297059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:54.458307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 5039
50.4%
0 4961
49.6%

수동/강제상태(정상:0, 고장:1)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 10000
100.0%

Length

2024-05-12T01:03:54.631334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:03:54.787147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 10000
100.0%

등록일자
Date

Distinct8875
Distinct (%)88.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-02-05 00:00:03
Maximum2024-02-05 14:35:46
2024-05-12T01:03:54.972475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:03:55.301578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Sample

기관 명모델명시리얼접속간격수동유지지역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)등록일자
11058광진구BMC-300S019010d00005b58120101-2013XX0001011231XX0100XX0100XX01001009700000122024-02-05 07:01:49
18293광진구BMC-300S019010d00000cdf120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 11:42:11
1515광진구BMC-300S019010d00000c48120101-2013XX0001011231XX0100XX0100XX01001004800000122024-02-05 00:56:26
16985광진구BMC-300S019010d00000be5120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 10:51:06
19048광진구BMC-300S019010d0000987f120101-1515XX0001011231XX0100XX0100XX0100100000000022024-02-05 12:11:05
12885광진구BMC-300S019010d00000fbd120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 08:14:43
6536광진구BMC-300S019010d0000f310120101-2013XX0001011231XX0100XX0100XX01001004700000122024-02-05 04:09:45
19287광진구BMC-300S019010d00011de3120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 12:20:35
16844광진구BMC-300S019010d00000c8c120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 10:45:03
13585광진구BMC-300S019010d00011d24120101-2013XX0001011231XX0100XX0100XX0100100000000022024-02-05 08:39:49
기관 명모델명시리얼접속간격수동유지지역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)등록일자
2267광진구BMC-300S019010d0000245d120101-2013XX0001011231XX0100XX0100XX01001005000000122024-02-05 01:25:11
4709광진구BMC-300S019010d00005beb120101-2013XX0001011231XX0100XX0100XX01001009600000122024-02-05 02:58:45
7159광진구BMC-300S019010d0000138f120101-2013XX0001011231XX0100XX0100XX01001004900000122024-02-05 04:33:15
5768광진구BMC-300S019010d0000b688120101-2013XX0001011231XX0100XX0100XX01001004600000122024-02-05 03:39:59
5148광진구BMC-300S019010d00009b30120101-2013XX0001011231XX0100XX0100XX01001004900000122024-02-05 03:14:58
3653광진구BMC-300S019010d00011de3120101-2013XX0001011231XX0100XX0100XX01001004700000122024-02-05 02:19:54
2927광진구BMC-300S019010d00006e80120101-2013XX0001011231XX0100XX0100XX01001004500000122024-02-05 01:51:01
7660광진구BMC-300S019010d0000a42b120101-2013XX0001011231XX0100XX0100XX01001004600000122024-02-05 04:52:12
11506광진구BMC-300S019010d00000ae9120101-2013XX0001011231XX0100XX0100XX01001004600000122024-02-05 07:18:45
1278광진구BMC-300S019010d0000aca6120101-2013XX0001011231XX0100XX0100XX01001005000000122024-02-05 00:47:50