Overview

Dataset statistics

Number of variables32
Number of observations9757
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.4%)Imbalance
심야소등시작분 is highly imbalanced (99.6%)Imbalance
심야소등해제시간 is highly imbalanced (99.5%)Imbalance
심야소등해제분 is highly imbalanced (99.6%)Imbalance
심야소등적용기간 is highly imbalanced (99.0%)Imbalance
디밍시1 is highly imbalanced (74.3%)Imbalance
디밍분1 is highly imbalanced (99.6%)Imbalance
디밍값1(%) is highly imbalanced (79.4%)Imbalance
현재디밍값(%) is highly imbalanced (74.3%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.4%)Imbalance
누전발생(정상:0, 고장:1) is highly imbalanced (99.6%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (96.0%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (99.1%)Imbalance
점소등상태(정상:0, 고장:1) is highly imbalanced (99.8%)Imbalance

Reproduction

Analysis started2024-05-11 16:03:04.544685
Analysis finished2024-05-11 16:03:05.616484
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.4 KiB
광진구
9757 

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

Length

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

Common Values (Plot)

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

모델명
Categorical

CONSTANT 

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

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

Length

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

Common Values (Plot)

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

시리얼
Text

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

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

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

Unique18 ?
Unique (%)0.2%

Sample

1st row019010d00006123
2nd row019010d0000a50b
3rd row019010d00010444
4th row019010d0000103b
5th row019010d00000489
ValueCountFrequency (%)
019010d00001378 5
 
0.1%
019010d0000a527 4
 
< 0.1%
019010d00000b38 4
 
< 0.1%
019010d00012dd5 4
 
< 0.1%
019010d0000559f 4
 
< 0.1%
019010d00000612 4
 
< 0.1%
019010d00009cb1 4
 
< 0.1%
019010d0000146a 4
 
< 0.1%
019010d00011d44 4
 
< 0.1%
019010d0000108c 4
 
< 0.1%
Other values (3182) 9716
99.6%
2024-05-12T01:03:07.691248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 72045
49.2%
1 25097
 
17.1%
9 12111
 
8.3%
d 11993
 
8.2%
a 2873
 
2.0%
b 2812
 
1.9%
5 2616
 
1.8%
6 2207
 
1.5%
2 2195
 
1.5%
4 2084
 
1.4%
Other values (6) 10322
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 123219
84.2%
Lowercase Letter 23136
 
15.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 72045
58.5%
1 25097
 
20.4%
9 12111
 
9.8%
5 2616
 
2.1%
6 2207
 
1.8%
2 2195
 
1.8%
4 2084
 
1.7%
3 1838
 
1.5%
7 1585
 
1.3%
8 1441
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
d 11993
51.8%
a 2873
 
12.4%
b 2812
 
12.2%
c 2028
 
8.8%
f 1863
 
8.1%
e 1567
 
6.8%

Most occurring scripts

ValueCountFrequency (%)
Common 123219
84.2%
Latin 23136
 
15.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 72045
58.5%
1 25097
 
20.4%
9 12111
 
9.8%
5 2616
 
2.1%
6 2207
 
1.8%
2 2195
 
1.8%
4 2084
 
1.7%
3 1838
 
1.5%
7 1585
 
1.3%
8 1441
 
1.2%
Latin
ValueCountFrequency (%)
d 11993
51.8%
a 2873
 
12.4%
b 2812
 
12.2%
c 2028
 
8.8%
f 1863
 
8.1%
e 1567
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 146355
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 72045
49.2%
1 25097
 
17.1%
9 12111
 
8.3%
d 11993
 
8.2%
a 2873
 
2.0%
b 2812
 
1.9%
5 2616
 
1.8%
6 2207
 
1.5%
2 2195
 
1.5%
4 2084
 
1.4%
Other values (6) 10322
 
7.1%

접속간격
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
120
9757 

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

Length

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

Common Values (Plot)

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

수동유지
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
10
9736 
1
 
18
14
 
3

Length

Max length2
Median length2
Mean length1.9981552
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 9736
99.8%
1 18
 
0.2%
14 3
 
< 0.1%

Length

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

Common Values (Plot)

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

지역ID
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
1
9757 

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

Length

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

Common Values (Plot)

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

점등편차
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-19.975402
Minimum-79
Maximum9
Zeros0
Zeros (%)0.0%
Negative9754
Negative (%)> 99.9%
Memory size85.9 KiB
2024-05-12T01:03:08.875748image/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.1986264
Coefficient of variation (CV)-0.11006669
Kurtosis407.29314
Mean-19.975402
Median Absolute Deviation (MAD)0
Skewness-16.760049
Sum-194900
Variance4.8339582
MonotonicityNot monotonic
2024-05-12T01:03:09.053890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
-20 9505
97.4%
-15 219
 
2.2%
-70 6
 
0.1%
-60 6
 
0.1%
-45 3
 
< 0.1%
-79 3
 
< 0.1%
-30 3
 
< 0.1%
-40 3
 
< 0.1%
-25 3
 
< 0.1%
-35 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 3
 
< 0.1%
-25 3
 
< 0.1%
-20 9505
97.4%
-15 219
 
2.2%
ValueCountFrequency (%)
9 3
 
< 0.1%
-15 219
 
2.2%
-20 9505
97.4%
-25 3
 
< 0.1%
-30 3
 
< 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.113559
Minimum-15
Maximum60
Zeros0
Zeros (%)0.0%
Negative3
Negative (%)< 0.1%
Memory size85.9 KiB
2024-05-12T01:03:09.229750image/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.19298
Coefficient of variation (CV)0.16722996
Kurtosis400.49974
Mean13.113559
Median Absolute Deviation (MAD)0
Skewness18.036611
Sum127949
Variance4.8091611
MonotonicityNot monotonic
2024-05-12T01:03:09.420420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
13 9498
97.3%
15 200
 
2.0%
5 19
 
0.2%
60 16
 
0.2%
11 6
 
0.1%
10 3
 
< 0.1%
57 3
 
< 0.1%
12 3
 
< 0.1%
34 3
 
< 0.1%
-15 3
 
< 0.1%
ValueCountFrequency (%)
-15 3
 
< 0.1%
5 19
 
0.2%
10 3
 
< 0.1%
11 6
 
0.1%
12 3
 
< 0.1%
13 9498
97.3%
15 200
 
2.0%
20 3
 
< 0.1%
34 3
 
< 0.1%
57 3
 
< 0.1%
ValueCountFrequency (%)
60 16
 
0.2%
57 3
 
< 0.1%
34 3
 
< 0.1%
20 3
 
< 0.1%
15 200
 
2.0%
13 9498
97.3%
12 3
 
< 0.1%
11 6
 
0.1%
10 3
 
< 0.1%
5 19
 
0.2%

심야소등시작시간
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
XX
9748 
22
 
3
01
 
3
19
 
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 9748
99.9%
22 3
 
< 0.1%
01 3
 
< 0.1%
19 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등시작분
Categorical

IMBALANCE 

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

Length

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

Common Values (Plot)

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

심야소등해제시간
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9751 
3
 
3
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 9751
99.9%
3 3
 
< 0.1%
22 3
 
< 0.1%

Length

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

Common Values (Plot)

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

심야소등해제분
Categorical

IMBALANCE 

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

Length

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

Common Values (Plot)

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

심야소등적용기간
Categorical

IMBALANCE 

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

Length

Max length7
Median length7
Mean length6.9938506
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 10
 
0.1%
5121231 3
 
< 0.1%
5010931 3
 
< 0.1%
6011231 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:11.208176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1011231 9738
99.8%
0 10
 
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.4 KiB
XX
8971 
00
 
783
20
 
3

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
XX 8971
91.9%
00 783
 
8.0%
20 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:11.558840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 8971
91.9%
00 783
 
8.0%
20 3
 
< 0.1%

디밍분1
Categorical

IMBALANCE 

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

Length

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

Common Values (Plot)

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

디밍값1(%)
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
100
8968 
60
 
783
90
 
3
10
 
3

Length

Max length3
Median length3
Mean length2.919135
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 8968
91.9%
60 783
 
8.0%
90 3
 
< 0.1%
10 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:12.239197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 8968
91.9%
60 783
 
8.0%
90 3
 
< 0.1%
10 3
 
< 0.1%

디밍시2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
XX
9757 

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

Length

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

Common Values (Plot)

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

디밍분2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9757 

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

Length

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

Common Values (Plot)

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

디밍값2(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
100
9757 

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

Length

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

Common Values (Plot)

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

디밍시3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
XX
9757 

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

Length

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

Common Values (Plot)

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

디밍분3
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9757 

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

Length

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

Common Values (Plot)

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

디밍값3(%)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
100
9757 

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

Length

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

Common Values (Plot)

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

현재디밍값(%)
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
100
8971 
60
 
783
10
 
3

Length

Max length3
Median length3
Mean length2.9194425
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 8971
91.9%
60 783
 
8.0%
10 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:03:14.649331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 8971
91.9%
60 783
 
8.0%
10 3
 
< 0.1%

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

Distinct134
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.428
Minimum0
Maximum338
Zeros41
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size85.9 KiB
2024-05-12T01:03:14.844005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile30
Q147
median50
Q355
95-th percentile100
Maximum338
Range338
Interquartile range (IQR)8

Descriptive statistics

Standard deviation20.945792
Coefficient of variation (CV)0.37789189
Kurtosis19.508752
Mean55.428
Median Absolute Deviation (MAD)4
Skewness2.8203269
Sum540811
Variance438.72619
MonotonicityNot monotonic
2024-05-12T01:03:15.098088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
47 999
 
10.2%
46 874
 
9.0%
50 770
 
7.9%
49 749
 
7.7%
48 729
 
7.5%
52 586
 
6.0%
51 555
 
5.7%
45 360
 
3.7%
53 338
 
3.5%
30 223
 
2.3%
Other values (124) 3574
36.6%
ValueCountFrequency (%)
0 41
 
0.4%
1 2
 
< 0.1%
2 5
 
0.1%
5 4
 
< 0.1%
22 4
 
< 0.1%
23 5
 
0.1%
24 3
 
< 0.1%
25 3
 
< 0.1%
27 3
 
< 0.1%
28 138
1.4%
ValueCountFrequency (%)
338 3
< 0.1%
303 1
 
< 0.1%
302 1
 
< 0.1%
298 1
 
< 0.1%
195 1
 
< 0.1%
188 2
< 0.1%
167 2
< 0.1%
164 1
 
< 0.1%
162 1
 
< 0.1%
161 1
 
< 0.1%

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

IMBALANCE 

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

Length

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

Common Values (Plot)

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

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

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9757 

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

Length

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

Common Values (Plot)

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

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

IMBALANCE 

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

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9715 
1
 
42

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 9715
99.6%
1 42
 
0.4%

Length

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

Common Values (Plot)

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

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

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
0
9750 
1
 
7

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 7
 
0.1%

Length

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

Common Values (Plot)

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

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

IMBALANCE 

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

Length

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

Common Values (Plot)

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

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

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
2
9757 

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

Length

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

Common Values (Plot)

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

등록일자
Date

Distinct7348
Distinct (%)75.3%
Missing0
Missing (%)0.0%
Memory size76.4 KiB
Minimum2024-01-29 00:00:00
Maximum2024-01-29 06:11:47
2024-05-12T01:03:17.614149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:03:17.841357image/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-300S019010d00006123120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-29 00:00:00
1광진구BMC-300S019010d0000a50b120101-2013XX000101123100060XX0100XX0100603000000122024-01-29 00:00:04
2광진구BMC-300S019010d00010444120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-29 00:00:09
3광진구BMC-300S019010d0000103b120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-29 00:00:10
4광진구BMC-300S019010d00000489120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-29 00:00:11
5광진구BMC-300S019010d000010cd120101-2013XX0001011231XX0100XX0100XX01001005200000122024-01-29 00:00:12
6광진구BMC-300S019010d000083c8120101-2013XX000101123100060XX0100XX0100603000000122024-01-29 00:00:13
7광진구BMC-300S019010d00011d53120101-2013XX0001011231XX0100XX0100XX01001007600000122024-01-29 00:00:14
8광진구BMC-300S019010d000055a3120101-1515XX0001011231XX0100XX0100XX01001005200000122024-01-29 00:00:19
9광진구BMC-300S019010d0000f409120101-2013XX0001011231XX0100XX0100XX01001004900000122024-01-29 00:00:21
기관 명모델명시리얼접속간격수동유지지역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)등록일자
9747광진구BMC-300S019010d00005b1f120101-2013XX0001011231XX0100XX0100XX01001005100000122024-01-29 06:11:23
9748광진구BMC-300S019010d000003fc120101-2013XX0001011231XX0100XX0100XX01001004600000122024-01-29 06:11:27
9749광진구BMC-300S019010d00007502120101-2013XX000101123100060XX0100XX0100602900000122024-01-29 06:11:27
9750광진구BMC-300S019010d000012d8120101-2013XX0001011231XX0100XX0100XX01001005000000122024-01-29 06:11:29
9751광진구BMC-300S019010d000017c3120101-2013XX0001011231XX0100XX0100XX01001005100000122024-01-29 06:11:30
9752광진구BMC-300S019010d00005b68120101-2013XX0001011231XX0100XX0100XX01001005100000122024-01-29 06:11:31
9753광진구BMC-300S019010d00009aef120101-2013XX0001011231XX0100XX0100XX01001005600000122024-01-29 06:11:38
9754광진구BMC-300S019010d00011dde120101-2013XX0001011231XX0100XX0100XX01001007300000122024-01-29 06:11:38
9755광진구BMC-300S019010d00005b41120101-2013XX0001011231XX0100XX0100XX01001004900000122024-01-29 06:11:41
9756광진구BMC-300S019010d0000613e120101-2013XX0001011231XX0100XX0100XX01001004900000122024-01-29 06:11:47