Overview

Dataset statistics

Number of variables32
Number of observations9756
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 MiB
Average record size in memory280.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.5%)Imbalance
심야소등시작시간 is highly imbalanced (99.3%)Imbalance
심야소등시작분 is highly imbalanced (99.6%)Imbalance
심야소등해제시간 is highly imbalanced (99.4%)Imbalance
심야소등해제분 is highly imbalanced (99.6%)Imbalance
심야소등적용기간 is highly imbalanced (99.0%)Imbalance
디밍시1 is highly imbalanced (74.4%)Imbalance
디밍분1 is highly imbalanced (99.6%)Imbalance
디밍값1(%) is highly imbalanced (79.5%)Imbalance
현재디밍값(%) is highly imbalanced (74.4%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.3%)Imbalance
누전발생(정상:0, 고장:1) is highly imbalanced (99.7%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (96.3%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (99.6%)Imbalance
점소등상태(정상:0, 고장:1) is highly imbalanced (99.8%)Imbalance

Reproduction

Analysis started2024-05-11 16:03:20.465989
Analysis finished2024-05-11 16:03:21.537238
Duration1.07 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
광진구
9756 

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 (%)
광진구 9756
100.0%

Length

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

Common Values (Plot)

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

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
BMC-300S
9756 

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

Length

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

Common Values (Plot)

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

시리얼
Text

Distinct3188
Distinct (%)32.7%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
2024-05-12T01:03:23.431036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

Total characters146340
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

Unique27 ?
Unique (%)0.3%

Sample

1st row019010d0000b68c
2nd row019010d0000132d
3rd row019010d0000b69b
4th row019010d0000d7d5
5th row019010d000017c5
ValueCountFrequency (%)
019010d00000c4f 5
 
0.1%
019010d0001063a 4
 
< 0.1%
019010d00005ba7 4
 
< 0.1%
019010d0000acbe 4
 
< 0.1%
019010d00001165 4
 
< 0.1%
019010d00009283 4
 
< 0.1%
019010d00000ed7 4
 
< 0.1%
019010d0000132f 4
 
< 0.1%
019010d00000c6d 4
 
< 0.1%
019010d0000f31f 4
 
< 0.1%
Other values (3178) 9715
99.6%
2024-05-12T01:03:24.565222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 72044
49.2%
1 25083
 
17.1%
9 12123
 
8.3%
d 11962
 
8.2%
a 2881
 
2.0%
b 2809
 
1.9%
5 2606
 
1.8%
2 2209
 
1.5%
6 2204
 
1.5%
4 2098
 
1.4%
Other values (6) 10321
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 123215
84.2%
Lowercase Letter 23125
 
15.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 72044
58.5%
1 25083
 
20.4%
9 12123
 
9.8%
5 2606
 
2.1%
2 2209
 
1.8%
6 2204
 
1.8%
4 2098
 
1.7%
3 1813
 
1.5%
7 1591
 
1.3%
8 1444
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
d 11962
51.7%
a 2881
 
12.5%
b 2809
 
12.1%
c 2037
 
8.8%
f 1869
 
8.1%
e 1567
 
6.8%

Most occurring scripts

ValueCountFrequency (%)
Common 123215
84.2%
Latin 23125
 
15.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 72044
58.5%
1 25083
 
20.4%
9 12123
 
9.8%
5 2606
 
2.1%
2 2209
 
1.8%
6 2204
 
1.8%
4 2098
 
1.7%
3 1813
 
1.5%
7 1591
 
1.3%
8 1444
 
1.2%
Latin
ValueCountFrequency (%)
d 11962
51.7%
a 2881
 
12.5%
b 2809
 
12.1%
c 2037
 
8.8%
f 1869
 
8.1%
e 1567
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 146340
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 72044
49.2%
1 25083
 
17.1%
9 12123
 
8.3%
d 11962
 
8.2%
a 2881
 
2.0%
b 2809
 
1.9%
5 2606
 
1.8%
2 2209
 
1.5%
6 2204
 
1.5%
4 2098
 
1.4%
Other values (6) 10321
 
7.1%

접속간격
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
120
9756 

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

Length

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

Common Values (Plot)

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

수동유지
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
10
9734 
1
 
19
14
 
3

Length

Max length2
Median length2
Mean length1.9980525
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

2024-05-12T01:03:25.332638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 9734
99.8%
1 19
 
0.2%
14 3
 
< 0.1%

지역ID
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
1
9756 

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

Length

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

Common Values (Plot)

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

점등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-19.976937
Minimum-79
Maximum9
Zeros0
Zeros (%)0.0%
Negative9753
Negative (%)> 99.9%
Memory size85.9 KiB
2024-05-12T01:03:25.801636image/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.2005034
Coefficient of variation (CV)-0.11015219
Kurtosis405.93178
Mean-19.976937
Median Absolute Deviation (MAD)0
Skewness-16.727697
Sum-194895
Variance4.8422154
MonotonicityNot monotonic
2024-05-12T01:03:25.979211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
-20 9504
97.4%
-15 218
 
2.2%
-60 6
 
0.1%
-70 6
 
0.1%
-30 4
 
< 0.1%
-25 3
 
< 0.1%
-35 3
 
< 0.1%
9 3
 
< 0.1%
-45 3
 
< 0.1%
-40 3
 
< 0.1%
ValueCountFrequency (%)
-79 3
 
< 0.1%
-70 6
 
0.1%
-60 6
 
0.1%
-45 3
 
< 0.1%
-40 3
 
< 0.1%
-35 3
 
< 0.1%
-30 4
 
< 0.1%
-25 3
 
< 0.1%
-20 9504
97.4%
-15 218
 
2.2%
ValueCountFrequency (%)
9 3
 
< 0.1%
-15 218
 
2.2%
-20 9504
97.4%
-25 3
 
< 0.1%
-30 4
 
< 0.1%
-35 3
 
< 0.1%
-40 3
 
< 0.1%
-45 3
 
< 0.1%
-60 6
 
0.1%
-70 6
 
0.1%

소등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.109779
Minimum-15
Maximum60
Zeros0
Zeros (%)0.0%
Negative3
Negative (%)< 0.1%
Memory size85.9 KiB
2024-05-12T01:03:26.154934image/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.1396031
Coefficient of variation (CV)0.16320665
Kurtosis418.79714
Mean13.109779
Median Absolute Deviation (MAD)0
Skewness18.354449
Sum127899
Variance4.5779013
MonotonicityNot monotonic
2024-05-12T01:03:26.346143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
13 9498
97.4%
15 201
 
2.1%
5 18
 
0.2%
60 15
 
0.2%
11 6
 
0.1%
20 3
 
< 0.1%
34 3
 
< 0.1%
-15 3
 
< 0.1%
57 3
 
< 0.1%
12 3
 
< 0.1%
ValueCountFrequency (%)
-15 3
 
< 0.1%
5 18
 
0.2%
10 3
 
< 0.1%
11 6
 
0.1%
12 3
 
< 0.1%
13 9498
97.4%
15 201
 
2.1%
20 3
 
< 0.1%
34 3
 
< 0.1%
57 3
 
< 0.1%
ValueCountFrequency (%)
60 15
 
0.2%
57 3
 
< 0.1%
34 3
 
< 0.1%
20 3
 
< 0.1%
15 201
 
2.1%
13 9498
97.4%
12 3
 
< 0.1%
11 6
 
0.1%
10 3
 
< 0.1%
5 18
 
0.2%

심야소등시작시간
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
XX
9746 
01
 
4
19
 
3
22
 
3

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 9746
99.9%
01 4
 
< 0.1%
19 3
 
< 0.1%
22 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등시작분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9753 
39
 
3

Length

Max length2
Median length1
Mean length1.0003075
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9753
> 99.9%
39 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등해제시간
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9749 
3
 
4
22
 
3

Length

Max length2
Median length1
Mean length1.0003075
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9749
99.9%
3 4
 
< 0.1%
22 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등해제분
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9753 
32
 
3

Length

Max length2
Median length1
Mean length1.0003075
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 9753
> 99.9%
32 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등적용기간
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
1011231
9738 
0
 
9
5121231
 
3
5010931
 
3
6011231
 
3

Length

Max length7
Median length7
Mean length6.9944649
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1011231 9738
99.8%
0 9
 
0.1%
5121231 3
 
< 0.1%
5010931 3
 
< 0.1%
6011231 3
 
< 0.1%

Length

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

Common Values (Plot)

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

디밍시1
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
XX
8975 
00
 
778
20
 
3

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 8975
92.0%
00 778
 
8.0%
20 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:28.482834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 8975
92.0%
00 778
 
8.0%
20 3
 
< 0.1%

디밍분1
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9753 
1
 
3

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 9753
> 99.9%
1 3
 
< 0.1%

Length

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

Common Values (Plot)

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

디밍값1(%)
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
100
8972 
60
 
778
10
 
3
90
 
3

Length

Max length3
Median length3
Mean length2.9196392
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 8972
92.0%
60 778
 
8.0%
10 3
 
< 0.1%
90 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:29.158512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 8972
92.0%
60 778
 
8.0%
10 3
 
< 0.1%
90 3
 
< 0.1%

디밍시2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
XX
9756 

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

Length

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

Common Values (Plot)

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

디밍분2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9756 

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

Length

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

Common Values (Plot)

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

디밍값2(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
100
9756 

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

Length

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

Common Values (Plot)

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

디밍시3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
XX
9756 

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

Length

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

Common Values (Plot)

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

디밍분3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9756 

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

Length

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

Common Values (Plot)

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

디밍값3(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
100
9756 

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

Length

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

Common Values (Plot)

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

현재디밍값(%)
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
100
8975 
60
 
778
10
 
3

Length

Max length3
Median length3
Mean length2.9199467
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 8975
92.0%
60 778
 
8.0%
10 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:32.639309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 8975
92.0%
60 778
 
8.0%
10 3
 
< 0.1%

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

Distinct136
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.71884
Minimum0
Maximum340
Zeros38
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size85.9 KiB
2024-05-12T01:03:32.971255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile30
Q147
median50
Q356
95-th percentile100
Maximum340
Range340
Interquartile range (IQR)9

Descriptive statistics

Standard deviation20.81422
Coefficient of variation (CV)0.37355803
Kurtosis19.689078
Mean55.71884
Median Absolute Deviation (MAD)4
Skewness2.8131964
Sum543593
Variance433.23176
MonotonicityNot monotonic
2024-05-12T01:03:33.410410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
47 893
 
9.2%
48 831
 
8.5%
50 803
 
8.2%
46 793
 
8.1%
49 682
 
7.0%
51 640
 
6.6%
52 576
 
5.9%
53 404
 
4.1%
45 308
 
3.2%
54 236
 
2.4%
Other values (126) 3590
36.8%
ValueCountFrequency (%)
0 38
0.4%
1 3
 
< 0.1%
2 3
 
< 0.1%
5 3
 
< 0.1%
20 1
 
< 0.1%
21 2
 
< 0.1%
22 9
 
0.1%
23 1
 
< 0.1%
24 3
 
< 0.1%
25 3
 
< 0.1%
ValueCountFrequency (%)
340 3
< 0.1%
301 1
 
< 0.1%
297 1
 
< 0.1%
293 1
 
< 0.1%
188 2
< 0.1%
185 1
 
< 0.1%
169 1
 
< 0.1%
167 2
< 0.1%
161 1
 
< 0.1%
160 3
< 0.1%

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9750 
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 9750
99.9%
1 6
 
0.1%

Length

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

Common Values (Plot)

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

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

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9756 

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

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9754 
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 9754
> 99.9%
1 2
 
< 0.1%

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9718 
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 9718
99.6%
1 38
 
0.4%

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
0
9753 
1
 
3

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 9753
> 99.9%
1 3
 
< 0.1%

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
1
9755 
0
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

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

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

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
2
9756 

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

Length

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

Common Values (Plot)

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

등록일자
Date

Distinct7352
Distinct (%)75.4%
Missing0
Missing (%)0.0%
Memory size76.3 KiB
Minimum2024-01-22 00:00:03
Maximum2024-01-22 06:13:07
2024-05-12T01:03:38.203270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:03:38.617087image/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)등록일자
0광진구BMC-300S019010d0000b68c120101-2013XX0001011231XX0100XX0100XX01001007000000122024-01-22 00:00:03
1광진구BMC-300S019010d0000132d120101-2013XX0001011231XX0100XX0100XX01001004400000122024-01-22 00:00:03
2광진구BMC-300S019010d0000b69b120101-2013XX0001011231XX0100XX0100XX01001005000000122024-01-22 00:00:05
3광진구BMC-300S019010d0000d7d5120101-2013XX0001011231XX0100XX0100XX01001007200000122024-01-22 00:00:05
4광진구BMC-300S019010d000017c5120101-2013XX0001011231XX0100XX0100XX01001009000000122024-01-22 00:00:08
5광진구BMC-300S019010d00005b50120101-2013XX0001011231XX0100XX0100XX01001004700000122024-01-22 00:00:12
6광진구BMC-300S019010d00005bbd120101-2013XX0001011231XX0100XX0100XX01001005000000122024-01-22 00:00:14
7광진구BMC-300S019010d00000bbc120101-2013XX0001011231XX0100XX0100XX010010012100000122024-01-22 00:00:17
8광진구BMC-300S019010d00006137120101-2013XX0001011231XX0100XX0100XX01001004700000122024-01-22 00:00:19
9광진구BMC-300S019010d000060bb120101-2013XX0001011231XX0100XX0100XX01001004700000122024-01-22 00:00:20
기관 명모델명시리얼접속간격수동유지지역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)등록일자
9746광진구BMC-300S019010d00003ecd120101-2013XX000101123100060XX0100XX0100602900000122024-01-22 06:12:48
9747광진구BMC-300S019010d0000b0b1120101-2013XX0001011231XX0100XX0100XX01001005100000122024-01-22 06:12:49
9748광진구BMC-300S019010d00000cf7120101-2013XX0001011231XX0100XX0100XX01001005000000122024-01-22 06:12:49
9749광진구BMC-300S019010d0000a437120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-22 06:12:56
9750광진구BMC-300S019010d0000a3fd120101-2013XX0001011231XX0100XX0100XX010010011300000122024-01-22 06:12:58
9751광진구BMC-300S019010d00005b64120101-2013XX0001011231XX0100XX0100XX01001004800000122024-01-22 06:13:01
9752광진구BMC-300S019010d000098ce120101-2013XX0001011231XX0100XX0100XX01001005000000122024-01-22 06:13:02
9753광진구BMC-300S019010d000010f2120101-2013XX0001011231XX0100XX0100XX01001005800000122024-01-22 06:13:02
9754광진구BMC-300S019010d0000af33120101-2013XX0001011231XX0100XX0100XX01001005200000122024-01-22 06:13:03
9755광진구BMC-300S019010d0000610a120101-2013XX0001011231XX0100XX0100XX01001005300000122024-01-22 06:13:07