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
수동/강제상태(정상:0, 고장:1) has constant value ""Constant
수동유지 is highly imbalanced (98.2%)Imbalance
심야소등시작시간 is highly imbalanced (99.4%)Imbalance
심야소등시작분 is highly imbalanced (99.4%)Imbalance
심야소등해제시간 is highly imbalanced (99.4%)Imbalance
심야소등해제분 is highly imbalanced (99.4%)Imbalance
심야소등적용기간 is highly imbalanced (99.0%)Imbalance
디밍시1 is highly imbalanced (74.4%)Imbalance
디밍분1 is highly imbalanced (99.5%)Imbalance
디밍값1(%) is highly imbalanced (79.6%)Imbalance
현재디밍값(%) is highly imbalanced (74.4%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.7%)Imbalance
이상점등(정상:0, 고장:1) is highly imbalanced (99.5%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (96.2%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (99.5%)Imbalance
현재전력값(W) has 5430 (54.3%) zerosZeros

Reproduction

Analysis started2024-05-11 16:01:56.706066
Analysis finished2024-05-11 16:01:58.488692
Duration1.78 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:01:58.703961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:01:59.010997image/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:01:59.320827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

시리얼
Text

Distinct3126
Distinct (%)31.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:02:00.356003image/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

Unique336 ?
Unique (%)3.4%

Sample

1st row019010d00001172
2nd row019010d0000042e
3rd row019010d00001ac7
4th row019010d000106df
5th row019010d0000c81f
ValueCountFrequency (%)
019010d00000b65 10
 
0.1%
019010d00001017 8
 
0.1%
019010d00001071 7
 
0.1%
019010d00009ad5 7
 
0.1%
019010d00004427 7
 
0.1%
019010d00001061 7
 
0.1%
019010d0000608e 7
 
0.1%
019010d000010b9 7
 
0.1%
019010d000043f5 7
 
0.1%
019010d000043f6 7
 
0.1%
Other values (3116) 9926
99.3%
2024-05-12T01:02:01.564412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 73783
49.2%
1 25821
 
17.2%
9 12461
 
8.3%
d 12231
 
8.2%
a 2913
 
1.9%
b 2778
 
1.9%
5 2642
 
1.8%
6 2330
 
1.6%
2 2282
 
1.5%
4 2199
 
1.5%
Other values (6) 10560
 
7.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 126419
84.3%
Lowercase Letter 23581
 
15.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 73783
58.4%
1 25821
 
20.4%
9 12461
 
9.9%
5 2642
 
2.1%
6 2330
 
1.8%
2 2282
 
1.8%
4 2199
 
1.7%
3 1872
 
1.5%
7 1618
 
1.3%
8 1411
 
1.1%
Lowercase Letter
ValueCountFrequency (%)
d 12231
51.9%
a 2913
 
12.4%
b 2778
 
11.8%
c 2072
 
8.8%
f 1978
 
8.4%
e 1609
 
6.8%

Most occurring scripts

ValueCountFrequency (%)
Common 126419
84.3%
Latin 23581
 
15.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 73783
58.4%
1 25821
 
20.4%
9 12461
 
9.9%
5 2642
 
2.1%
6 2330
 
1.8%
2 2282
 
1.8%
4 2199
 
1.7%
3 1872
 
1.5%
7 1618
 
1.3%
8 1411
 
1.1%
Latin
ValueCountFrequency (%)
d 12231
51.9%
a 2913
 
12.4%
b 2778
 
11.8%
c 2072
 
8.8%
f 1978
 
8.4%
e 1609
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 150000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 73783
49.2%
1 25821
 
17.2%
9 12461
 
8.3%
d 12231
 
8.2%
a 2913
 
1.9%
b 2778
 
1.9%
5 2642
 
1.8%
6 2330
 
1.6%
2 2282
 
1.5%
4 2199
 
1.5%
Other values (6) 10560
 
7.0%

접속간격
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:02:01.975743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:02.263775image/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
9972 
1
 
26
14
 
2

Length

Max length2
Median length2
Mean length1.9974
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 9972
99.7%
1 26
 
0.3%
14 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:02.893679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 9972
99.7%
1 26
 
0.3%
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:02:03.220920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

점등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-19.9678
Minimum-79
Maximum9
Zeros0
Zeros (%)0.0%
Negative9998
Negative (%)> 99.9%
Memory size166.0 KiB
2024-05-12T01:02:03.786758image/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 deviation2.0651851
Coefficient of variation (CV)-0.10342577
Kurtosis480.86535
Mean-19.9678
Median Absolute Deviation (MAD)0
Skewness-18.458752
Sum-199678
Variance4.2649897
MonotonicityNot monotonic
2024-05-12T01:02:04.126533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
-20 9752
97.5%
-15 220
 
2.2%
-60 7
 
0.1%
-79 4
 
< 0.1%
-35 3
 
< 0.1%
-40 3
 
< 0.1%
-70 3
 
< 0.1%
-30 3
 
< 0.1%
-25 2
 
< 0.1%
9 2
 
< 0.1%
ValueCountFrequency (%)
-79 4
 
< 0.1%
-70 3
 
< 0.1%
-60 7
 
0.1%
-45 1
 
< 0.1%
-40 3
 
< 0.1%
-35 3
 
< 0.1%
-30 3
 
< 0.1%
-25 2
 
< 0.1%
-20 9752
97.5%
-15 220
 
2.2%
ValueCountFrequency (%)
9 2
 
< 0.1%
-15 220
 
2.2%
-20 9752
97.5%
-25 2
 
< 0.1%
-30 3
 
< 0.1%
-35 3
 
< 0.1%
-40 3
 
< 0.1%
-45 1
 
< 0.1%
-60 7
 
0.1%
-70 3
 
< 0.1%

소등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.0894
Minimum-15
Maximum60
Zeros0
Zeros (%)0.0%
Negative4
Negative (%)< 0.1%
Memory size166.0 KiB
2024-05-12T01:02:04.446397image/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 deviation1.8993073
Coefficient of variation (CV)0.1451027
Kurtosis523.59846
Mean13.0894
Median Absolute Deviation (MAD)0
Skewness19.46693
Sum130894
Variance3.6073684
MonotonicityNot monotonic
2024-05-12T01:02:04.808287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
13 9744
97.4%
15 209
 
2.1%
5 12
 
0.1%
60 12
 
0.1%
11 7
 
0.1%
12 4
 
< 0.1%
-15 4
 
< 0.1%
20 2
 
< 0.1%
34 2
 
< 0.1%
57 2
 
< 0.1%
ValueCountFrequency (%)
-15 4
 
< 0.1%
5 12
 
0.1%
10 2
 
< 0.1%
11 7
 
0.1%
12 4
 
< 0.1%
13 9744
97.4%
15 209
 
2.1%
20 2
 
< 0.1%
34 2
 
< 0.1%
57 2
 
< 0.1%
ValueCountFrequency (%)
60 12
 
0.1%
57 2
 
< 0.1%
34 2
 
< 0.1%
20 2
 
< 0.1%
15 209
 
2.1%
13 9744
97.4%
12 4
 
< 0.1%
11 7
 
0.1%
10 2
 
< 0.1%
5 12
 
0.1%

심야소등시작시간
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9990 
19
 
5
01
 
3
22
 
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 9990
99.9%
19 5
 
0.1%
01 3
 
< 0.1%
22 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:05.510396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9990
99.9%
19 5
 
< 0.1%
01 3
 
< 0.1%
22 2
 
< 0.1%

심야소등시작분
Categorical

IMBALANCE 

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

Length

Max length2
Median length1
Mean length1.0005
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9995
> 99.9%
39 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:06.160614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
39 5
 
< 0.1%

심야소등해제시간
Categorical

IMBALANCE 

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

Length

Max length2
Median length1
Mean length1.0005
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9992
99.9%
22 5
 
0.1%
3 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:06.797015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9992
99.9%
22 5
 
< 0.1%
3 3
 
< 0.1%

심야소등해제분
Categorical

IMBALANCE 

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

Length

Max length2
Median length1
Mean length1.0005
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9995
> 99.9%
32 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:07.568962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
32 5
 
< 0.1%

심야소등적용기간
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1011231
9981 
0
 
7
6011231
 
5
5010931
 
5
5121231
 
2

Length

Max length7
Median length7
Mean length6.9958
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1011231 9981
99.8%
0 7
 
0.1%
6011231 5
 
0.1%
5010931 5
 
0.1%
5121231 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:08.229572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1011231 9981
99.8%
0 7
 
0.1%
6011231 5
 
< 0.1%
5010931 5
 
< 0.1%
5121231 2
 
< 0.1%

디밍시1
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9199 
00
 
797
20
 
4

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 9199
92.0%
00 797
 
8.0%
20 4
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:08.880762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9199
92.0%
00 797
 
8.0%
20 4
 
< 0.1%

디밍분1
Categorical

IMBALANCE 

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

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 9996
> 99.9%
1 4
 
< 0.1%

Length

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

Common Values (Plot)

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

디밍값1(%)
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
9197 
60
 
797
10
 
4
90
 
2

Length

Max length3
Median length3
Mean length2.9197
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9197
92.0%
60 797
 
8.0%
10 4
 
< 0.1%
90 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:10.134201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9197
92.0%
60 797
 
8.0%
10 4
 
< 0.1%
90 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:02:10.333413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:10.491633image/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:02:10.659433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:10.813886image/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:02:10.999733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:11.287007image/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:02:11.597948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:11.884429image/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:02:12.187924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:12.474616image/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:02:12.776324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:13.062451image/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
9199 
60
 
797
10
 
4

Length

Max length3
Median length3
Mean length2.9199
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9199
92.0%
60 797
 
8.0%
10 4
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:13.678491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9199
92.0%
60 797
 
8.0%
10 4
 
< 0.1%

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

ZEROS 

Distinct120
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.4139
Minimum0
Maximum338
Zeros5430
Zeros (%)54.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:02:14.013936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q349
95-th percentile74
Maximum338
Range338
Interquartile range (IQR)49

Descriptive statistics

Standard deviation30.976613
Coefficient of variation (CV)1.2188847
Kurtosis2.2796823
Mean25.4139
Median Absolute Deviation (MAD)0
Skewness1.0911482
Sum254139
Variance959.55054
MonotonicityNot monotonic
2024-05-12T01:02:14.456110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5430
54.3%
47 494
 
4.9%
46 389
 
3.9%
48 352
 
3.5%
50 342
 
3.4%
49 341
 
3.4%
51 286
 
2.9%
52 261
 
2.6%
45 169
 
1.7%
53 158
 
1.6%
Other values (110) 1778
 
17.8%
ValueCountFrequency (%)
0 5430
54.3%
1 2
 
< 0.1%
2 4
 
< 0.1%
5 3
 
< 0.1%
22 2
 
< 0.1%
24 2
 
< 0.1%
25 1
 
< 0.1%
26 1
 
< 0.1%
27 1
 
< 0.1%
28 65
 
0.7%
ValueCountFrequency (%)
338 1
< 0.1%
301 1
< 0.1%
300 1
< 0.1%
167 1
< 0.1%
164 1
< 0.1%
160 1
< 0.1%
158 1
< 0.1%
154 1
< 0.1%
151 1
< 0.1%
149 1
< 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:02:14.868226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:15.161742image/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
9996 
1
 
4

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 9996
> 99.9%
1 4
 
< 0.1%

Length

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

Common Values (Plot)

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

누전발생(정상:0, 고장:1)
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:02:16.081889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

IMBALANCE 

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

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 9959
99.6%
1 41
 
0.4%

Length

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

Common Values (Plot)

2024-05-12T01:02:16.975786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9959
99.6%
1 41
 
0.4%

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

IMBALANCE 

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

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 9996
> 99.9%
1 4
 
< 0.1%

Length

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

Common Values (Plot)

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

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

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 5411
54.1%
1 4589
45.9%

Length

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

Common Values (Plot)

2024-05-12T01:02:17.941916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 5411
54.1%
1 4589
45.9%

수동/강제상태(정상: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:02:18.261087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

등록일자
Date

Distinct9100
Distinct (%)91.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-25 00:00:03
Maximum2023-12-25 18:25:50
2024-05-12T01:02:18.872204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:02:19.312246image/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)등록일자
1284광진구BMC-300S019010d00001172120101-2013XX0001011231XX0100XX0100XX01001007200000122023-12-25 00:49:15
28288광진구BMC-300S019010d0000042e120101-2013XX0001011231XX0100XX0100XX01001004800000122023-12-25 18:04:48
23333광진구BMC-300S019010d00001ac7120101-2013XX0001011231XX0100XX0100XX0100100000000022023-12-25 14:54:49
350광진구BMC-300S019010d000106df120101-2013XX0001011231XX0100XX0100XX01001004700000122023-12-25 00:14:39
11106광진구BMC-300S019010d0000c81f120101-2013XX0001011231XX0100XX0100XX01001005100000122023-12-25 07:05:08
919광진구BMC-300S019010d0000a40e120101-2013XX0001011231XX0100XX0100XX01001004700000122023-12-25 00:36:32
12606광진구BMC-300S019010d0000044f120101-2013XX0001011231XX0100XX0100XX0100100000000022023-12-25 08:03:10
23273광진구BMC-300S019010d0000507c120101-2013XX000101123100060XX0100XX010060000000022023-12-25 14:52:44
26521광진구BMC-300S019010d00009294120101-2013XX000101123100060XX0100XX010060000000022023-12-25 16:56:47
3812광진구BMC-300S019010d00000b59120101-2013XX0001011231XX0100XX0100XX01001005200000122023-12-25 02:27:38
기관 명모델명시리얼접속간격수동유지지역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)등록일자
9966광진구BMC-300S019010d00011d21120101-2013XX0001011231XX0100XX0100XX01001004600000122023-12-25 06:22:14
24021광진구BMC-300S019010d00007044120101-2013XX000101123100060XX0100XX010060000000022023-12-25 15:22:47
345광진구BMC-300S019010d000109cc120101-2013XX0001011231XX0100XX0100XX01001005100000122023-12-25 00:14:28
21048광진구BMC-300S019010d0000c7fe120101-2013XX0001011231XX0100XX0100XX0100100000000022023-12-25 13:29:23
11101광진구BMC-300S019010d000085bc120101-2013XX000101123100060XX0100XX0100602800000122023-12-25 07:04:54
9341광진구BMC-300S019010d00003eda120101-2013XX000101123100060XX0100XX0100602900000122023-12-25 05:56:52
2205광진구BMC-300S019010d00011de5120101-2013XX0001011231XX0100XX0100XX01001004600000122023-12-25 01:27:12
26373광진구BMC-300S019010d00009b44120101-2013XX0001011231XX0100XX0100XX0100100000000022023-12-25 16:50:52
6528광진구BMC-300S019010d0000abe6120101-2013XX0001011231XX0100XX0100XX01001005000000122023-12-25 04:11:00
20195광진구BMC-300S019010d00005b53120101-2013XX0001011231XX0100XX0100XX0100100000000022023-12-25 12:54:33