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
수동/강제상태(정상:0, 고장:1) has constant value ""Constant
수동유지 is highly imbalanced (98.5%)Imbalance
심야소등시작시간 is highly imbalanced (99.6%)Imbalance
심야소등시작분 is highly imbalanced (99.7%)Imbalance
심야소등해제시간 is highly imbalanced (99.6%)Imbalance
심야소등해제분 is highly imbalanced (99.7%)Imbalance
심야소등적용기간 is highly imbalanced (98.9%)Imbalance
디밍시1 is highly imbalanced (75.2%)Imbalance
디밍분1 is highly imbalanced (99.5%)Imbalance
디밍값1(%) is highly imbalanced (80.3%)Imbalance
현재디밍값(%) is highly imbalanced (75.2%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.4%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (96.7%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (99.7%)Imbalance
현재전력값(W) has 4246 (42.5%) zerosZeros

Reproduction

Analysis started2024-05-11 16:02:22.498166
Analysis finished2024-05-11 16:02:23.442460
Duration0.94 seconds
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:02:23.628774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

시리얼
Text

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

Unique349 ?
Unique (%)3.5%

Sample

1st row019010d0000ad91
2nd row019010d000011f5
3rd row019010d00005b55
4th row019010d0000c7eb
5th row019010d0000c7e9
ValueCountFrequency (%)
019010d00008576 9
 
0.1%
019010d000103de 9
 
0.1%
019010d0000751e 8
 
0.1%
019010d000011ea 8
 
0.1%
019010d0000610f 8
 
0.1%
019010d00001172 8
 
0.1%
019010d00006137 8
 
0.1%
019010d0000c7e8 8
 
0.1%
019010d0000a2de 8
 
0.1%
019010d00010a5e 8
 
0.1%
Other values (3097) 9918
99.2%
2024-05-12T01:02:26.311975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 73866
49.2%
1 25697
 
17.1%
9 12404
 
8.3%
d 12291
 
8.2%
a 2966
 
2.0%
b 2866
 
1.9%
5 2760
 
1.8%
2 2331
 
1.6%
6 2253
 
1.5%
c 2093
 
1.4%
Other values (6) 10473
 
7.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 126285
84.2%
Lowercase Letter 23715
 
15.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 73866
58.5%
1 25697
 
20.3%
9 12404
 
9.8%
5 2760
 
2.2%
2 2331
 
1.8%
6 2253
 
1.8%
4 2087
 
1.7%
3 1844
 
1.5%
7 1612
 
1.3%
8 1431
 
1.1%
Lowercase Letter
ValueCountFrequency (%)
d 12291
51.8%
a 2966
 
12.5%
b 2866
 
12.1%
c 2093
 
8.8%
f 1930
 
8.1%
e 1569
 
6.6%

Most occurring scripts

ValueCountFrequency (%)
Common 126285
84.2%
Latin 23715
 
15.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 73866
58.5%
1 25697
 
20.3%
9 12404
 
9.8%
5 2760
 
2.2%
2 2331
 
1.8%
6 2253
 
1.8%
4 2087
 
1.7%
3 1844
 
1.5%
7 1612
 
1.3%
8 1431
 
1.1%
Latin
ValueCountFrequency (%)
d 12291
51.8%
a 2966
 
12.5%
b 2866
 
12.1%
c 2093
 
8.8%
f 1930
 
8.1%
e 1569
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 150000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 73866
49.2%
1 25697
 
17.1%
9 12404
 
8.3%
d 12291
 
8.2%
a 2966
 
2.0%
b 2866
 
1.9%
5 2760
 
1.8%
2 2331
 
1.6%
6 2253
 
1.5%
c 2093
 
1.4%
Other values (6) 10473
 
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:26.719912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:27.006732image/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
9978 
1
 
19
14
 
3

Length

Max length2
Median length2
Mean length1.9981
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 9978
99.8%
1 19
 
0.2%
14 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:27.634021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 9978
99.8%
1 19
 
0.2%
14 3
 
< 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:27.959918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:28.245977image/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.9656
Minimum-79
Maximum9
Zeros0
Zeros (%)0.0%
Negative9996
Negative (%)> 99.9%
Memory size166.0 KiB
2024-05-12T01:02:28.519514image/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.1077146
Coefficient of variation (CV)-0.10556731
Kurtosis447.30858
Mean-19.9656
Median Absolute Deviation (MAD)0
Skewness-16.842247
Sum-199656
Variance4.4424609
MonotonicityNot monotonic
2024-05-12T01:02:28.855377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
-20 9753
97.5%
-15 216
 
2.2%
-70 6
 
0.1%
-35 5
 
0.1%
9 4
 
< 0.1%
-60 4
 
< 0.1%
-79 3
 
< 0.1%
-40 3
 
< 0.1%
-45 2
 
< 0.1%
-30 2
 
< 0.1%
ValueCountFrequency (%)
-79 3
 
< 0.1%
-70 6
 
0.1%
-60 4
 
< 0.1%
-45 2
 
< 0.1%
-40 3
 
< 0.1%
-35 5
 
0.1%
-30 2
 
< 0.1%
-25 2
 
< 0.1%
-20 9753
97.5%
-15 216
 
2.2%
ValueCountFrequency (%)
9 4
 
< 0.1%
-15 216
 
2.2%
-20 9753
97.5%
-25 2
 
< 0.1%
-30 2
 
< 0.1%
-35 5
 
0.1%
-40 3
 
< 0.1%
-45 2
 
< 0.1%
-60 4
 
< 0.1%
-70 6
 
0.1%

소등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.115
Minimum-15
Maximum60
Zeros0
Zeros (%)0.0%
Negative7
Negative (%)0.1%
Memory size166.0 KiB
2024-05-12T01:02:29.177462image/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.3999898
Coefficient of variation (CV)0.18299579
Kurtosis323.84011
Mean13.115
Median Absolute Deviation (MAD)0
Skewness15.14039
Sum131150
Variance5.759951
MonotonicityNot monotonic
2024-05-12T01:02:29.534206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
13 9739
97.4%
15 194
 
1.9%
5 21
 
0.2%
60 19
 
0.2%
-15 7
 
0.1%
11 6
 
0.1%
34 5
 
0.1%
12 3
 
< 0.1%
57 3
 
< 0.1%
20 2
 
< 0.1%
ValueCountFrequency (%)
-15 7
 
0.1%
5 21
 
0.2%
10 1
 
< 0.1%
11 6
 
0.1%
12 3
 
< 0.1%
13 9739
97.4%
15 194
 
1.9%
20 2
 
< 0.1%
34 5
 
0.1%
57 3
 
< 0.1%
ValueCountFrequency (%)
60 19
 
0.2%
57 3
 
< 0.1%
34 5
 
0.1%
20 2
 
< 0.1%
15 194
 
1.9%
13 9739
97.4%
12 3
 
< 0.1%
11 6
 
0.1%
10 1
 
< 0.1%
5 21
 
0.2%

심야소등시작시간
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9994 
01
 
3
19
 
2
22
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
XX 9994
99.9%
01 3
 
< 0.1%
19 2
 
< 0.1%
22 1
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:30.232610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9994
99.9%
01 3
 
< 0.1%
19 2
 
< 0.1%
22 1
 
< 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:02:30.580657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:30.883123image/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
9995 
3
 
3
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 9995
> 99.9%
3 3
 
< 0.1%
22 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:31.521184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
3 3
 
< 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:02:31.857863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:32.163378image/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
9979 
0
 
13
6011231
 
4
5121231
 
2
5010931
 
2

Length

Max length7
Median length7
Mean length6.9922
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1011231 9979
99.8%
0 13
 
0.1%
6011231 4
 
< 0.1%
5121231 2
 
< 0.1%
5010931 2
 
< 0.1%

Length

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

Common Values (Plot)

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

디밍시1
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
XX
9236 
00
 
760
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 9236
92.4%
00 760
 
7.6%
20 4
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:33.477932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 9236
92.4%
00 760
 
7.6%
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:33.800078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:02:34.094800image/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
9235 
60
 
760
10
 
4
90
 
1

Length

Max length3
Median length3
Mean length2.9235
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
100 9235
92.3%
60 760
 
7.6%
10 4
 
< 0.1%
90 1
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:34.727263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9235
92.3%
60 760
 
7.6%
10 4
 
< 0.1%
90 1
 
< 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:35.061867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

2024-05-12T01:02:38.453341image/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
9236 
60
 
760
10
 
4

Length

Max length3
Median length3
Mean length2.9236
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9236
92.4%
60 760
 
7.6%
10 4
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:39.072558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9236
92.4%
60 760
 
7.6%
10 4
 
< 0.1%

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

ZEROS 

Distinct130
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.3219
Minimum0
Maximum339
Zeros4246
Zeros (%)42.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:02:39.408028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median45
Q351
95-th percentile89
Maximum339
Range339
Interquartile range (IQR)51

Descriptive statistics

Standard deviation32.608754
Coefficient of variation (CV)1.0088749
Kurtosis5.4114268
Mean32.3219
Median Absolute Deviation (MAD)28
Skewness1.1676408
Sum323219
Variance1063.3308
MonotonicityNot monotonic
2024-05-12T01:02:39.847310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4246
42.5%
47 611
 
6.1%
46 483
 
4.8%
49 470
 
4.7%
50 431
 
4.3%
48 415
 
4.2%
52 342
 
3.4%
51 324
 
3.2%
45 241
 
2.4%
53 187
 
1.9%
Other values (120) 2250
22.5%
ValueCountFrequency (%)
0 4246
42.5%
1 2
 
< 0.1%
2 2
 
< 0.1%
5 2
 
< 0.1%
21 1
 
< 0.1%
22 8
 
0.1%
24 3
 
< 0.1%
25 3
 
< 0.1%
26 2
 
< 0.1%
27 1
 
< 0.1%
ValueCountFrequency (%)
339 2
< 0.1%
338 3
< 0.1%
303 1
 
< 0.1%
302 1
 
< 0.1%
301 2
< 0.1%
188 1
 
< 0.1%
185 2
< 0.1%
169 1
 
< 0.1%
160 2
< 0.1%
159 1
 
< 0.1%

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

IMBALANCE 

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

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 9995
> 99.9%
1 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:02:40.559375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9995
> 99.9%
1 5
 
< 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:40.871626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

Common Values (Plot)

2024-05-12T01:02:41.758476image/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
9966 
1
 
34

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 9966
99.7%
1 34
 
0.3%

Length

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

Common Values (Plot)

2024-05-12T01:02:42.362682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9966
99.7%
1 34
 
0.3%

깜빡거림(정상: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:42.680465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

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

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 5769
57.7%
0 4231
42.3%

Length

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

Common Values (Plot)

2024-05-12T01:02:43.591644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 5769
57.7%
0 4231
42.3%

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

Common Values (Plot)

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

등록일자
Date

Distinct9404
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-13 00:00:01
Maximum2024-01-13 23:59:58
2024-05-12T01:02:44.529624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:02:44.945802image/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)등록일자
4082광진구BMC-300S019010d0000ad91120101-2013XX0001011231XX0100XX0100XX01001004900000122024-01-13 02:36:01
3238광진구BMC-300S019010d000011f5120101-2013XX0001011231XX0100XX0100XX01001004500000122024-01-13 02:03:49
31775광진구BMC-300S019010d00005b55120101-2013XX0001011231XX0100XX0100XX01001004900000122024-01-13 20:19:53
31713광진구BMC-300S019010d0000c7eb120101-2013XX0001011231XX0100XX0100XX010010011700000122024-01-13 20:17:14
10568광진구BMC-300S019010d0000c7e9120101-2013XX0001011231XX0100XX0100XX01001004700000122024-01-13 06:43:38
5323광진구BMC-300S019010d0000ab13120101-1515XX0001011231XX0100XX0100XX01001004900000122024-01-13 03:23:32
18341광진구BMC-300S019010d000012d5120101-2013XX0001011231XX0100XX0100XX0100100000000022024-01-13 11:44:11
2577광진구BMC-300S019010d00011dd9120101-2013XX0001011231XX0100XX0100XX01001006900000122024-01-13 01:38:20
7008광진구BMC-300S019010d0001065d120101-2013XX0001011231XX0100XX0100XX01001004400000122024-01-13 04:28:17
30237광진구BMC-300S019010d00000fbc120101-2013XX0001011231XX0100XX0100XX01001006100000122024-01-13 19:21:35
기관 명모델명시리얼접속간격수동유지지역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)등록일자
32919광진구BMC-300S019010d0000061b120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-13 21:03:56
26119광진구BMC-300S019010d000011fa120101-2013XX0001011231XX0100XX0100XX0100100000000022024-01-13 16:42:32
24238광진구BMC-300S019010d000060ab120101-2013XX0001011231XX0100XX0100XX0100100000000022024-01-13 15:30:43
30834광진구BMC-300S019010d0000aca3120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-13 19:43:06
10451광진구BMC-300S019010d0000124d120101-2013XX0001011231XX0100XX0100XX01001004300000122024-01-13 06:38:55
29259광진구BMC-300S019010d00000e0b120101-2013XX0001011231XX0100XX0100XX01001005500000122024-01-13 18:42:47
22396광진구BMC-300S019010d0000144f120101-2013XX0001011231XX0100XX0100XX0100100000000022024-01-13 14:20:13
19368광진구BMC-300S019010d00005bc9120101-2013XX0001011231XX0100XX0100XX0100100000000022024-01-13 12:24:20
6238광진구BMC-300S019010d0000f31b120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-13 03:57:49
29651광진구BMC-300S019010d00005b71120101-2013XX0001011231XX0100XX0100XX01001004700000122024-01-13 18:59:07