Overview

Dataset statistics

Number of variables32
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows2777
Duplicate rows (%)27.8%
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-15965/S/1/datasetView.do

Alerts

기관 명 has constant value ""Constant
모델명 has constant value ""Constant
심야소등시작시간 has constant value ""Constant
심야소등시작분 has constant value ""Constant
심야소등해제분 has constant value ""Constant
디밍시1 has constant value ""Constant
디밍분1 has constant value ""Constant
디밍시2 has constant value ""Constant
디밍분2 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
Dataset has 2777 (27.8%) duplicate rowsDuplicates
지역ID is highly imbalanced (99.1%)Imbalance
소등편차 is highly imbalanced (77.3%)Imbalance
심야소등해제시간 is highly imbalanced (99.7%)Imbalance
심야소등적용기간 is highly imbalanced (99.3%)Imbalance
디밍값1(%) is highly imbalanced (99.4%)Imbalance
디밍값2(%) is highly imbalanced (99.0%)Imbalance
디밍값3(%) is highly imbalanced (99.4%)Imbalance
현재디밍값(%) is highly imbalanced (99.4%)Imbalance
램프고장(정상:0, 고장:1) is highly imbalanced (99.2%)Imbalance
안정기고장(정상:0, 고장:1) is highly imbalanced (99.5%)Imbalance
깜빡거림(정상:0, 고장:1) is highly imbalanced (98.3%)Imbalance
수동/강제상태(정상:0, 고장:1) is highly imbalanced (99.4%)Imbalance
현재전력값(W) has 4014 (40.1%) zerosZeros

Reproduction

Analysis started2024-05-11 16:29:09.684878
Analysis finished2024-05-11 16:29:10.750980
Duration1.07 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:29:10.937231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

시리얼
Text

Distinct1950
Distinct (%)19.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:29:12.660302image/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

Unique29 ?
Unique (%)0.3%

Sample

1st row019010d0000c837
2nd row019010d000149f4
3rd row359369083357588
4th row019010d00004bd8
5th row019010d000083d7
ValueCountFrequency (%)
359369083432910 12
 
0.1%
019010d00010f10 12
 
0.1%
019010d00003a29 11
 
0.1%
019010d00006a89 11
 
0.1%
019010d00007077 11
 
0.1%
019010d000050ff 11
 
0.1%
019010d000149eb 11
 
0.1%
019010d0000c858 11
 
0.1%
019010d00005023 10
 
0.1%
019010d0001225b 10
 
0.1%
Other values (1940) 9890
98.9%
2024-05-12T01:29:13.530138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 42443
28.3%
3 22474
15.0%
9 19124
12.7%
1 14643
 
9.8%
5 9288
 
6.2%
8 8744
 
5.8%
6 8208
 
5.5%
4 6745
 
4.5%
d 5920
 
3.9%
2 4348
 
2.9%
Other values (6) 8063
 
5.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 139221
92.8%
Lowercase Letter 10779
 
7.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 42443
30.5%
3 22474
16.1%
9 19124
13.7%
1 14643
 
10.5%
5 9288
 
6.7%
8 8744
 
6.3%
6 8208
 
5.9%
4 6745
 
4.8%
2 4348
 
3.1%
7 3204
 
2.3%
Lowercase Letter
ValueCountFrequency (%)
d 5920
54.9%
e 1244
 
11.5%
f 1066
 
9.9%
c 968
 
9.0%
a 869
 
8.1%
b 712
 
6.6%

Most occurring scripts

ValueCountFrequency (%)
Common 139221
92.8%
Latin 10779
 
7.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 42443
30.5%
3 22474
16.1%
9 19124
13.7%
1 14643
 
10.5%
5 9288
 
6.7%
8 8744
 
6.3%
6 8208
 
5.9%
4 6745
 
4.8%
2 4348
 
3.1%
7 3204
 
2.3%
Latin
ValueCountFrequency (%)
d 5920
54.9%
e 1244
 
11.5%
f 1066
 
9.9%
c 968
 
9.0%
a 869
 
8.1%
b 712
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 150000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 42443
28.3%
3 22474
15.0%
9 19124
12.7%
1 14643
 
9.8%
5 9288
 
6.2%
8 8744
 
5.8%
6 8208
 
5.5%
4 6745
 
4.5%
d 5920
 
3.9%
2 4348
 
2.9%
Other values (6) 8063
 
5.4%

접속간격
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
240
5214 
120
4781 
100
 
5

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
240 5214
52.1%
120 4781
47.8%
100 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:13.928402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
240 5214
52.1%
120 4781
47.8%
100 5
 
< 0.1%

수동유지
Real number (ℝ)

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.9897
Minimum0
Maximum30
Zeros3
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:29:14.089623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile10
Q110
median10
Q310
95-th percentile10
Maximum30
Range30
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.8007549
Coefficient of variation (CV)0.18026116
Kurtosis88.285609
Mean9.9897
Median Absolute Deviation (MAD)0
Skewness6.5696114
Sum99897
Variance3.2427182
MonotonicityNot monotonic
2024-05-12T01:29:14.284928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
10 9740
97.4%
2 63
 
0.6%
30 56
 
0.6%
3 41
 
0.4%
4 34
 
0.3%
1 18
 
0.2%
8 9
 
0.1%
5 9
 
0.1%
6 8
 
0.1%
9 7
 
0.1%
Other values (3) 15
 
0.1%
ValueCountFrequency (%)
0 3
 
< 0.1%
1 18
 
0.2%
2 63
 
0.6%
3 41
 
0.4%
4 34
 
0.3%
5 9
 
0.1%
6 8
 
0.1%
8 9
 
0.1%
9 7
 
0.1%
10 9740
97.4%
ValueCountFrequency (%)
30 56
 
0.6%
20 6
 
0.1%
11 6
 
0.1%
10 9740
97.4%
9 7
 
0.1%
8 9
 
0.1%
6 8
 
0.1%
5 9
 
0.1%
4 34
 
0.3%
3 41
 
0.4%

지역ID
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
9989 
2
 
6
0
 
5

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 9989
99.9%
2 6
 
0.1%
0 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:14.667437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9989
99.9%
2 6
 
0.1%
0 5
 
< 0.1%

점등편차
Real number (ℝ)

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-15.077
Minimum-45
Maximum-5
Zeros0
Zeros (%)0.0%
Negative10000
Negative (%)100.0%
Memory size166.0 KiB
2024-05-12T01:29:14.818383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-45
5-th percentile-15
Q1-15
median-15
Q3-15
95-th percentile-15
Maximum-5
Range40
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.4339723
Coefficient of variation (CV)-0.095109924
Kurtosis356.62054
Mean-15.077
Median Absolute Deviation (MAD)0
Skewness-17.811357
Sum-150770
Variance2.0562766
MonotonicityNot monotonic
2024-05-12T01:29:15.017205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
-15 9928
99.3%
-20 21
 
0.2%
-45 18
 
0.2%
-30 14
 
0.1%
-10 9
 
0.1%
-5 5
 
0.1%
-17 5
 
0.1%
ValueCountFrequency (%)
-45 18
 
0.2%
-30 14
 
0.1%
-20 21
 
0.2%
-17 5
 
0.1%
-15 9928
99.3%
-10 9
 
0.1%
-5 5
 
0.1%
ValueCountFrequency (%)
-5 5
 
0.1%
-10 9
 
0.1%
-15 9928
99.3%
-17 5
 
0.1%
-20 21
 
0.2%
-30 14
 
0.1%
-45 18
 
0.2%

소등편차
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
15
9091 
5
 
889
13
 
15
10
 
5

Length

Max length2
Median length2
Mean length1.9111
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
15 9091
90.9%
5 889
 
8.9%
13 15
 
0.1%
10 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:15.423785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
15 9091
90.9%
5 889
 
8.9%
13 15
 
0.1%
10 5
 
< 0.1%

심야소등시작시간
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:29:15.611666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

심야소등시작분
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:29:15.936557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

심야소등해제시간
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9998 
19
 
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%
19 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:16.436996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9998
> 99.9%
19 2
 
< 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:29:16.609752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

심야소등적용기간
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1011231
9989 
1030
 
5
12011231
 
4
6011231
 
2

Length

Max length8
Median length7
Mean length6.9989
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1011231 9989
99.9%
1030 5
 
0.1%
12011231 4
 
< 0.1%
6011231 2
 
< 0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:17.175354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1011231 9989
99.9%
1030 5
 
< 0.1%
12011231 4
 
< 0.1%
6011231 2
 
< 0.1%

디밍시1
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:29:17.358814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:29:17.518841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
xx 10000
100.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:29:17.682684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

디밍값1(%)
Categorical

IMBALANCE 

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

Length

Max length3
Median length3
Mean length2.9995
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:18.191867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
< 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:29:18.362362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

디밍값2(%)
Categorical

IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
100
9987 
30
 
8
96
 
5

Length

Max length3
Median length3
Mean length2.9987
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9987
99.9%
30 8
 
0.1%
96 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:19.217801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9987
99.9%
30 8
 
0.1%
96 5
 
< 0.1%

디밍시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:29:19.401615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

디밍값3(%)
Categorical

IMBALANCE 

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

Length

Max length3
Median length3
Mean length2.9995
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:20.357370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
< 0.1%

현재디밍값(%)
Categorical

IMBALANCE 

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

Length

Max length3
Median length3
Mean length2.9995
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
0.1%

Length

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

Common Values (Plot)

2024-05-12T01:29:20.996591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 9995
> 99.9%
96 5
 
< 0.1%

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

ZEROS 

Distinct118
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.3027
Minimum0
Maximum220
Zeros4014
Zeros (%)40.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:29:21.339361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median29.5
Q352
95-th percentile101
Maximum220
Range220
Interquartile range (IQR)52

Descriptive statistics

Standard deviation32.539489
Coefficient of variation (CV)1.0073303
Kurtosis1.4032264
Mean32.3027
Median Absolute Deviation (MAD)29.5
Skewness0.9561844
Sum323027
Variance1058.8184
MonotonicityNot monotonic
2024-05-12T01:29:21.762384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4014
40.1%
53 626
 
6.3%
52 531
 
5.3%
51 527
 
5.3%
48 435
 
4.3%
27 347
 
3.5%
54 311
 
3.1%
49 302
 
3.0%
26 290
 
2.9%
50 248
 
2.5%
Other values (108) 2369
23.7%
ValueCountFrequency (%)
0 4014
40.1%
1 2
 
< 0.1%
23 2
 
< 0.1%
24 15
 
0.1%
25 72
 
0.7%
26 290
 
2.9%
27 347
 
3.5%
28 150
 
1.5%
29 108
 
1.1%
30 112
 
1.1%
ValueCountFrequency (%)
220 3
< 0.1%
216 3
< 0.1%
208 2
 
< 0.1%
205 2
 
< 0.1%
201 6
0.1%
177 1
 
< 0.1%
162 2
 
< 0.1%
160 7
0.1%
142 3
< 0.1%
140 4
< 0.1%

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

IMBALANCE 

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

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

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

IMBALANCE 

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

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 9984
99.8%
1 16
 
0.2%

Length

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

Common Values (Plot)

2024-05-12T01:29:24.881967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9984
99.8%
1 16
 
0.2%

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

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 5984
59.8%
0 4016
40.2%

Length

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

Common Values (Plot)

2024-05-12T01:29:25.688374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 5984
59.8%
0 4016
40.2%

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

IMBALANCE 

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

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

Length

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

Common Values (Plot)

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

등록일자
Date

Distinct5074
Distinct (%)50.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-15 00:00:15
Maximum2024-01-15 11:39:17
2024-05-12T01:29:26.641967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:29:27.064925image/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)등록일자
4216강북구BMC-300S019010d0000c837120101-1515XX0001011231XX0100XX0100XX01001005300000122024-01-15 02:24:02
4928강북구BMC-300S019010d000149f4120101-1515XX0001011231XX0100XX0100XX01001002700000122024-01-15 03:23:40
17346강북구BMC-300S359369083357588240101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 11:38:19
16279강북구BMC-300S019010d00004bd8120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 11:32:42
4696강북구BMC-300S019010d000083d7120101-1515XX0001011231XX0100XX0100XX01001004800000122024-01-15 03:05:07
15630강북구BMC-300S019010d000050df120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 11:09:49
12933강북구BMC-300S359369083482709240101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 07:36:58
12174강북구BMC-300S359369084335591240101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 07:35:14
6131강북구BMC-300S019010d0000706e120101-1515XX0001011231XX0100XX0100XX010010010300000122024-01-15 04:49:38
11245강북구BMC-300S359369083227732240101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 07:33:05
기관 명모델명시리얼접속간격수동유지지역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)등록일자
15313강북구BMC-300S019010d00013708120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 10:41:32
6968강북구BMC-300S019010d00003e96120101-1515XX0001011231XX0100XX0100XX01001004300000122024-01-15 05:41:12
118강북구BMC-300S019010d00005108120101-1515XX0001011231XX0100XX0100XX01001002500000122024-01-15 00:09:00
7125강북구BMC-300S019010d00004bdd120101-1515XX0001011231XX0100XX0100XX01001002700000122024-01-15 05:52:45
7813강북구BMC-300S359369083302998240101-1515XX0001011231XX0100XX0100XX01001005100000122024-01-15 06:03:05
4343강북구BMC-300S019010d0000d7e3120101-1515XX0001011231XX0100XX0100XX01001005300000122024-01-15 02:36:10
8148강북구BMC-300S359369083516746240101-1515XX0001011231XX0100XX0100XX01001005400000122024-01-15 06:04:33
4189강북구BMC-300S019010d00006a83120101-1515XX0001011231XX0100XX0100XX01001005300000122024-01-15 02:22:26
7779강북구BMC-300S359369081393007240101-1515XX0001011231XX0100XX0100XX01001002700000122024-01-15 06:02:59
909강북구BMC-300S019010d00003f48120101-1515XX0001011231XX0100XX0100XX010010010100000122024-01-15 01:12:01

Duplicate rows

Most frequently occurring

기관 명모델명시리얼접속간격수동유지지역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)등록일자# duplicates
0강북구BMC-300S019010d00003a01120101-1515XX0001011231XX0100XX0100XX01001009500000122024-01-15 03:04:312
1강북구BMC-300S019010d00003a02120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 11:05:572
2강북구BMC-300S019010d00003a03120101-1515XX0001011231XX0100XX0100XX01001004900000122024-01-15 05:26:002
3강북구BMC-300S019010d00003a03120101-1515XX0001011231XX0100XX0100XX01001004900000122024-01-15 07:26:452
4강북구BMC-300S019010d00003a08120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 09:14:292
5강북구BMC-300S019010d00003a26120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 10:29:412
6강북구BMC-300S019010d00003a26120101-1515XX0001011231XX0100XX0100XX01001005300000122024-01-15 00:26:012
7강북구BMC-300S019010d00003a27120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 07:33:552
8강북구BMC-300S019010d00003a28120101-1515XX0001011231XX0100XX0100XX0100100000000022024-01-15 07:34:312
9강북구BMC-300S019010d00003a28120101-1515XX0001011231XX0100XX0100XX01001004600000122024-01-15 05:33:532