Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows43
Duplicate rows (%)0.4%
Total size in memory2.0 MiB
Average record size in memory212.0 B

Variable types

Categorical8
Text1
Numeric13
DateTime1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15963/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
Dataset has 43 (0.4%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (67.6%)Imbalance
알림단계등급 is highly imbalanced (93.0%)Imbalance
활동수치 (%) has 527 (5.3%) zerosZeros
전력량1 (Wh) has 4349 (43.5%) zerosZeros
조도1 (%) has 1047 (10.5%) zerosZeros
전력량2 (Wh) has 4449 (44.5%) zerosZeros
조도2 (%) has 1030 (10.3%) zerosZeros
전력량3 (Wh) has 4433 (44.3%) zerosZeros
조도3 (%) has 1046 (10.5%) zerosZeros
전력량4 (Wh) has 4434 (44.3%) zerosZeros
조도4 (%) has 1017 (10.2%) zerosZeros
전력량5 (Wh) has 4446 (44.5%) zerosZeros
조도5 (%) has 1015 (10.2%) zerosZeros
전력량6 (Wh) has 4448 (44.5%) zerosZeros
조도6 (%) has 1009 (10.1%) zerosZeros

Reproduction

Analysis started2024-05-11 16:20:59.729524
Analysis finished2024-05-11 16:21:00.310188
Duration0.58 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:21:00.493608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:21:00.781762image/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
3
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 10000
100.0%

Length

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

Common Values (Plot)

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

패킷길이
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
29
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
29 10000
100.0%

Length

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

Common Values (Plot)

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

시리얼
Text

Distinct348
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:21:03.006227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters80000
Distinct characters14
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowKCN-1054
2nd rowKCN-1409
3rd rowKCN-1428
4th rowKCN-1347
5th rowKCN-1073
ValueCountFrequency (%)
kcn-1218 45
 
0.4%
kcn-1116 45
 
0.4%
kcn-1430 45
 
0.4%
kcn-1235 41
 
0.4%
kcn-1054 41
 
0.4%
kcn-1243 40
 
0.4%
kcn-1412 40
 
0.4%
kcn-1420 40
 
0.4%
kcn-1213 39
 
0.4%
kcn-1385 39
 
0.4%
Other values (338) 9585
95.9%
2024-05-12T01:21:04.511545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14186
17.7%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4537
 
5.7%
3 4441
 
5.6%
0 4281
 
5.4%
4 2839
 
3.5%
5 2029
 
2.5%
Other values (4) 7687
9.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40000
50.0%
Uppercase Letter 30000
37.5%
Dash Punctuation 10000
 
12.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 14186
35.5%
2 4537
 
11.3%
3 4441
 
11.1%
0 4281
 
10.7%
4 2839
 
7.1%
5 2029
 
5.1%
9 2000
 
5.0%
7 1983
 
5.0%
6 1888
 
4.7%
8 1816
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
K 10000
33.3%
C 10000
33.3%
N 10000
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 50000
62.5%
Latin 30000
37.5%

Most frequent character per script

Common
ValueCountFrequency (%)
1 14186
28.4%
- 10000
20.0%
2 4537
 
9.1%
3 4441
 
8.9%
0 4281
 
8.6%
4 2839
 
5.7%
5 2029
 
4.1%
9 2000
 
4.0%
7 1983
 
4.0%
6 1888
 
3.8%
Latin
ValueCountFrequency (%)
K 10000
33.3%
C 10000
33.3%
N 10000
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 80000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 14186
17.7%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4537
 
5.7%
3 4441
 
5.6%
0 4281
 
5.4%
4 2839
 
3.5%
5 2029
 
2.5%
Other values (4) 7687
9.6%

명령어
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
83
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
83 10000
100.0%

Length

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

Common Values (Plot)

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

사용자관리그룹
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
8908 
2
 
642
0
 
265
3
 
185

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 8908
89.1%
2 642
 
6.4%
0 265
 
2.6%
3 185
 
1.8%

Length

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

Common Values (Plot)

2024-05-12T01:21:05.820121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8908
89.1%
2 642
 
6.4%
0 265
 
2.6%
3 185
 
1.8%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9843 
1
 
80
3
 
52
2
 
25

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 9843
98.4%
1 80
 
0.8%
3 52
 
0.5%
2 25
 
0.2%

Length

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

Common Values (Plot)

2024-05-12T01:21:06.466357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9843
98.4%
1 80
 
0.8%
3 52
 
0.5%
2 25
 
0.2%

기기상태정보
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:21:06.803224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

활동수치 (%)
Real number (ℝ)

ZEROS 

Distinct138
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.2479
Minimum0
Maximum152
Zeros527
Zeros (%)5.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:07.414261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median12
Q322
95-th percentile72
Maximum152
Range152
Interquartile range (IQR)16

Descriptive statistics

Standard deviation22.220707
Coefficient of variation (CV)1.1544484
Kurtosis6.9486306
Mean19.2479
Median Absolute Deviation (MAD)7
Skewness2.4496686
Sum192479
Variance493.75982
MonotonicityNot monotonic
2024-05-12T01:21:07.874761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 527
 
5.3%
8 426
 
4.3%
10 426
 
4.3%
12 401
 
4.0%
11 396
 
4.0%
9 394
 
3.9%
6 390
 
3.9%
5 381
 
3.8%
7 371
 
3.7%
4 367
 
3.7%
Other values (128) 5921
59.2%
ValueCountFrequency (%)
0 527
5.3%
1 335
3.4%
2 280
2.8%
3 343
3.4%
4 367
3.7%
5 381
3.8%
6 390
3.9%
7 371
3.7%
8 426
4.3%
9 394
3.9%
ValueCountFrequency (%)
152 1
 
< 0.1%
150 2
 
< 0.1%
149 1
 
< 0.1%
148 2
 
< 0.1%
146 3
 
< 0.1%
145 4
< 0.1%
144 2
 
< 0.1%
143 8
0.1%
142 4
< 0.1%
141 2
 
< 0.1%

최근활동
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 7057
70.6%
1 2943
29.4%

Length

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

Common Values (Plot)

2024-05-12T01:21:08.603036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 7057
70.6%
1 2943
29.4%

전력량1 (Wh)
Real number (ℝ)

ZEROS 

Distinct308
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.41902
Minimum0
Maximum177.8
Zeros4349
Zeros (%)43.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:08.933931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile14.9
Maximum177.8
Range177.8
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation7.2021671
Coefficient of variation (CV)2.1065004
Kurtosis100.99323
Mean3.41902
Median Absolute Deviation (MAD)0.1
Skewness7.2755748
Sum34190.2
Variance51.871211
MonotonicityNot monotonic
2024-05-12T01:21:09.386910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4349
43.5%
0.1 676
 
6.8%
0.3 209
 
2.1%
0.2 197
 
2.0%
1.5 112
 
1.1%
0.4 97
 
1.0%
4.0 94
 
0.9%
1.4 93
 
0.9%
5.2 78
 
0.8%
4.1 78
 
0.8%
Other values (298) 4017
40.2%
ValueCountFrequency (%)
0.0 4349
43.5%
0.1 676
 
6.8%
0.2 197
 
2.0%
0.3 209
 
2.1%
0.4 97
 
1.0%
0.5 51
 
0.5%
0.6 43
 
0.4%
0.7 71
 
0.7%
0.8 64
 
0.6%
0.9 24
 
0.2%
ValueCountFrequency (%)
177.8 1
< 0.1%
143.5 1
< 0.1%
140.3 1
< 0.1%
129.9 1
< 0.1%
96.4 1
< 0.1%
95.9 1
< 0.1%
91.0 1
< 0.1%
80.4 1
< 0.1%
76.0 1
< 0.1%
75.0 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75.8555
Minimum0
Maximum100
Zeros1047
Zeros (%)10.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:09.831722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q161.75
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)38.25

Descriptive statistics

Standard deviation35.224822
Coefficient of variation (CV)0.46436741
Kurtosis0.036686506
Mean75.8555
Median Absolute Deviation (MAD)4
Skewness-1.2690269
Sum758555
Variance1240.7881
MonotonicityNot monotonic
2024-05-12T01:21:10.270242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4309
43.1%
0 1047
 
10.5%
96 542
 
5.4%
97 304
 
3.0%
95 224
 
2.2%
98 143
 
1.4%
93 142
 
1.4%
91 119
 
1.2%
89 104
 
1.0%
99 92
 
0.9%
Other values (91) 2974
29.7%
ValueCountFrequency (%)
0 1047
10.5%
1 17
 
0.2%
2 24
 
0.2%
3 17
 
0.2%
4 27
 
0.3%
5 29
 
0.3%
6 25
 
0.2%
7 26
 
0.3%
8 17
 
0.2%
9 17
 
0.2%
ValueCountFrequency (%)
100 4309
43.1%
99 92
 
0.9%
98 143
 
1.4%
97 304
 
3.0%
96 542
 
5.4%
95 224
 
2.2%
94 84
 
0.8%
93 142
 
1.4%
92 89
 
0.9%
91 119
 
1.2%

전력량2 (Wh)
Real number (ℝ)

ZEROS 

Distinct302
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.22873
Minimum0
Maximum153.6
Zeros4449
Zeros (%)44.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:10.677062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile14.5
Maximum153.6
Range153.6
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation6.2387712
Coefficient of variation (CV)1.9322679
Kurtosis120.192
Mean3.22873
Median Absolute Deviation (MAD)0.1
Skewness7.1408626
Sum32287.3
Variance38.922266
MonotonicityNot monotonic
2024-05-12T01:21:11.132434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4449
44.5%
0.1 657
 
6.6%
0.3 199
 
2.0%
0.2 150
 
1.5%
1.6 120
 
1.2%
4.1 104
 
1.0%
0.4 95
 
0.9%
0.9 82
 
0.8%
1.4 81
 
0.8%
5.9 79
 
0.8%
Other values (292) 3984
39.8%
ValueCountFrequency (%)
0.0 4449
44.5%
0.1 657
 
6.6%
0.2 150
 
1.5%
0.3 199
 
2.0%
0.4 95
 
0.9%
0.5 77
 
0.8%
0.6 33
 
0.3%
0.7 52
 
0.5%
0.8 21
 
0.2%
0.9 82
 
0.8%
ValueCountFrequency (%)
153.6 1
< 0.1%
151.4 1
< 0.1%
146.5 1
< 0.1%
110.8 1
< 0.1%
104.9 1
< 0.1%
72.2 1
< 0.1%
66.4 1
< 0.1%
66.2 1
< 0.1%
64.6 1
< 0.1%
64.0 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75.8501
Minimum0
Maximum100
Zeros1030
Zeros (%)10.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:11.755886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q161
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)39

Descriptive statistics

Standard deviation35.181626
Coefficient of variation (CV)0.46383098
Kurtosis0.039688947
Mean75.8501
Median Absolute Deviation (MAD)4
Skewness-1.26987
Sum758501
Variance1237.7468
MonotonicityNot monotonic
2024-05-12T01:21:12.190155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4293
42.9%
0 1030
 
10.3%
96 532
 
5.3%
97 320
 
3.2%
95 221
 
2.2%
93 141
 
1.4%
98 132
 
1.3%
89 112
 
1.1%
91 109
 
1.1%
90 93
 
0.9%
Other values (91) 3017
30.2%
ValueCountFrequency (%)
0 1030
10.3%
1 21
 
0.2%
2 34
 
0.3%
3 18
 
0.2%
4 18
 
0.2%
5 28
 
0.3%
6 21
 
0.2%
7 28
 
0.3%
8 18
 
0.2%
9 17
 
0.2%
ValueCountFrequency (%)
100 4293
42.9%
99 85
 
0.9%
98 132
 
1.3%
97 320
 
3.2%
96 532
 
5.3%
95 221
 
2.2%
94 88
 
0.9%
93 141
 
1.4%
92 81
 
0.8%
91 109
 
1.1%

전력량3 (Wh)
Real number (ℝ)

ZEROS 

Distinct302
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.25871
Minimum0
Maximum158.5
Zeros4433
Zeros (%)44.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:12.591503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile14.7
Maximum158.5
Range158.5
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation6.0655317
Coefficient of variation (CV)1.8613291
Kurtosis74.788061
Mean3.25871
Median Absolute Deviation (MAD)0.1
Skewness5.5094057
Sum32587.1
Variance36.790675
MonotonicityNot monotonic
2024-05-12T01:21:13.046626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4433
44.3%
0.1 644
 
6.4%
0.3 179
 
1.8%
0.2 154
 
1.5%
0.4 112
 
1.1%
1.4 105
 
1.1%
1.8 97
 
1.0%
4.1 90
 
0.9%
1.5 86
 
0.9%
1.6 86
 
0.9%
Other values (292) 4014
40.1%
ValueCountFrequency (%)
0.0 4433
44.3%
0.1 644
 
6.4%
0.2 154
 
1.5%
0.3 179
 
1.8%
0.4 112
 
1.1%
0.5 72
 
0.7%
0.6 46
 
0.5%
0.7 31
 
0.3%
0.8 58
 
0.6%
0.9 47
 
0.5%
ValueCountFrequency (%)
158.5 1
< 0.1%
98.1 1
< 0.1%
94.5 1
< 0.1%
89.7 1
< 0.1%
82.4 1
< 0.1%
73.8 1
< 0.1%
72.0 1
< 0.1%
66.6 2
< 0.1%
66.4 1
< 0.1%
65.7 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean75.926
Minimum0
Maximum100
Zeros1046
Zeros (%)10.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:13.491806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q162
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)38

Descriptive statistics

Standard deviation35.176246
Coefficient of variation (CV)0.46329644
Kurtosis0.059234715
Mean75.926
Median Absolute Deviation (MAD)4
Skewness-1.2766396
Sum759260
Variance1237.3683
MonotonicityNot monotonic
2024-05-12T01:21:13.925921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4332
43.3%
0 1046
 
10.5%
96 534
 
5.3%
97 305
 
3.0%
95 219
 
2.2%
93 146
 
1.5%
98 143
 
1.4%
91 119
 
1.2%
89 106
 
1.1%
92 103
 
1.0%
Other values (91) 2947
29.5%
ValueCountFrequency (%)
0 1046
10.5%
1 18
 
0.2%
2 28
 
0.3%
3 16
 
0.2%
4 17
 
0.2%
5 24
 
0.2%
6 22
 
0.2%
7 44
 
0.4%
8 9
 
0.1%
9 20
 
0.2%
ValueCountFrequency (%)
100 4332
43.3%
99 74
 
0.7%
98 143
 
1.4%
97 305
 
3.0%
96 534
 
5.3%
95 219
 
2.2%
94 59
 
0.6%
93 146
 
1.5%
92 103
 
1.0%
91 119
 
1.2%

전력량4 (Wh)
Real number (ℝ)

ZEROS 

Distinct301
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.18344
Minimum0
Maximum151
Zeros4434
Zeros (%)44.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:14.327643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35
95-th percentile14.505
Maximum151
Range151
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5.6527946
Coefficient of variation (CV)1.7756875
Kurtosis61.95012
Mean3.18344
Median Absolute Deviation (MAD)0.1
Skewness4.6111298
Sum31834.4
Variance31.954087
MonotonicityNot monotonic
2024-05-12T01:21:14.774156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4434
44.3%
0.1 654
 
6.5%
0.3 192
 
1.9%
0.2 151
 
1.5%
0.4 115
 
1.1%
4.1 104
 
1.0%
1.6 103
 
1.0%
1.5 95
 
0.9%
6.1 77
 
0.8%
4.2 76
 
0.8%
Other values (291) 3999
40.0%
ValueCountFrequency (%)
0.0 4434
44.3%
0.1 654
 
6.5%
0.2 151
 
1.5%
0.3 192
 
1.9%
0.4 115
 
1.1%
0.5 67
 
0.7%
0.6 16
 
0.2%
0.7 65
 
0.7%
0.8 26
 
0.3%
0.9 73
 
0.7%
ValueCountFrequency (%)
151.0 1
< 0.1%
72.5 1
< 0.1%
66.6 1
< 0.1%
66.4 1
< 0.1%
65.4 2
< 0.1%
62.9 1
< 0.1%
59.5 1
< 0.1%
52.3 1
< 0.1%
44.0 1
< 0.1%
42.7 1
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76.1323
Minimum0
Maximum100
Zeros1017
Zeros (%)10.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:15.211434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q162
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)38

Descriptive statistics

Standard deviation34.910888
Coefficient of variation (CV)0.45855554
Kurtosis0.097289804
Mean76.1323
Median Absolute Deviation (MAD)4
Skewness-1.286018
Sum761323
Variance1218.7701
MonotonicityNot monotonic
2024-05-12T01:21:15.643886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4318
43.2%
0 1017
 
10.2%
96 549
 
5.5%
97 306
 
3.1%
95 212
 
2.1%
98 139
 
1.4%
93 137
 
1.4%
89 115
 
1.1%
92 112
 
1.1%
91 110
 
1.1%
Other values (91) 2985
29.8%
ValueCountFrequency (%)
0 1017
10.2%
1 21
 
0.2%
2 21
 
0.2%
3 15
 
0.1%
4 19
 
0.2%
5 21
 
0.2%
6 12
 
0.1%
7 33
 
0.3%
8 17
 
0.2%
9 25
 
0.2%
ValueCountFrequency (%)
100 4318
43.2%
99 79
 
0.8%
98 139
 
1.4%
97 306
 
3.1%
96 549
 
5.5%
95 212
 
2.1%
94 79
 
0.8%
93 137
 
1.4%
92 112
 
1.1%
91 110
 
1.1%

전력량5 (Wh)
Real number (ℝ)

ZEROS 

Distinct293
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.20052
Minimum0
Maximum173.2
Zeros4446
Zeros (%)44.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:16.047846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile14.6
Maximum173.2
Range173.2
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation5.9795973
Coefficient of variation (CV)1.8683205
Kurtosis119.76666
Mean3.20052
Median Absolute Deviation (MAD)0.1
Skewness6.6972539
Sum32005.2
Variance35.755583
MonotonicityNot monotonic
2024-05-12T01:21:16.495507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4446
44.5%
0.1 640
 
6.4%
0.3 192
 
1.9%
0.2 153
 
1.5%
0.4 116
 
1.2%
1.6 110
 
1.1%
1.8 96
 
1.0%
4.1 95
 
0.9%
6.1 87
 
0.9%
1.5 86
 
0.9%
Other values (283) 3979
39.8%
ValueCountFrequency (%)
0.0 4446
44.5%
0.1 640
 
6.4%
0.2 153
 
1.5%
0.3 192
 
1.9%
0.4 116
 
1.2%
0.5 54
 
0.5%
0.6 41
 
0.4%
0.7 58
 
0.6%
0.8 44
 
0.4%
0.9 61
 
0.6%
ValueCountFrequency (%)
173.2 1
< 0.1%
128.5 1
< 0.1%
121.6 1
< 0.1%
110.5 1
< 0.1%
79.4 1
< 0.1%
66.4 1
< 0.1%
66.3 1
< 0.1%
64.9 1
< 0.1%
49.4 1
< 0.1%
44.5 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76.0866
Minimum0
Maximum100
Zeros1015
Zeros (%)10.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:16.933103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q162
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)38

Descriptive statistics

Standard deviation34.872572
Coefficient of variation (CV)0.45832739
Kurtosis0.094824258
Mean76.0866
Median Absolute Deviation (MAD)4
Skewness-1.2834279
Sum760866
Variance1216.0963
MonotonicityNot monotonic
2024-05-12T01:21:17.367084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4303
43.0%
0 1015
 
10.2%
96 517
 
5.2%
97 308
 
3.1%
95 214
 
2.1%
93 142
 
1.4%
98 136
 
1.4%
89 119
 
1.2%
91 117
 
1.2%
92 105
 
1.1%
Other values (91) 3024
30.2%
ValueCountFrequency (%)
0 1015
10.2%
1 10
 
0.1%
2 22
 
0.2%
3 18
 
0.2%
4 25
 
0.2%
5 24
 
0.2%
6 19
 
0.2%
7 26
 
0.3%
8 11
 
0.1%
9 20
 
0.2%
ValueCountFrequency (%)
100 4303
43.0%
99 91
 
0.9%
98 136
 
1.4%
97 308
 
3.1%
96 517
 
5.2%
95 214
 
2.1%
94 83
 
0.8%
93 142
 
1.4%
92 105
 
1.1%
91 117
 
1.2%

전력량6 (Wh)
Real number (ℝ)

ZEROS 

Distinct308
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.23484
Minimum0
Maximum190.8
Zeros4448
Zeros (%)44.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:17.780281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.9
95-th percentile14.7
Maximum190.8
Range190.8
Interquartile range (IQR)4.9

Descriptive statistics

Standard deviation6.4895249
Coefficient of variation (CV)2.0061347
Kurtosis166.12939
Mean3.23484
Median Absolute Deviation (MAD)0.1
Skewness8.3172408
Sum32348.4
Variance42.113934
MonotonicityNot monotonic
2024-05-12T01:21:18.242628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4448
44.5%
0.1 651
 
6.5%
0.3 171
 
1.7%
0.2 159
 
1.6%
0.4 124
 
1.2%
4.1 97
 
1.0%
1.6 93
 
0.9%
4.2 87
 
0.9%
1.4 87
 
0.9%
1.5 86
 
0.9%
Other values (298) 3997
40.0%
ValueCountFrequency (%)
0.0 4448
44.5%
0.1 651
 
6.5%
0.2 159
 
1.6%
0.3 171
 
1.7%
0.4 124
 
1.2%
0.5 74
 
0.7%
0.6 42
 
0.4%
0.7 61
 
0.6%
0.8 42
 
0.4%
0.9 67
 
0.7%
ValueCountFrequency (%)
190.8 1
< 0.1%
186.6 1
< 0.1%
103.4 1
< 0.1%
97.3 1
< 0.1%
95.0 1
< 0.1%
92.3 1
< 0.1%
91.5 1
< 0.1%
86.4 1
< 0.1%
75.3 1
< 0.1%
71.7 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76.2734
Minimum0
Maximum100
Zeros1009
Zeros (%)10.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:18.685244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q162
median96
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)38

Descriptive statistics

Standard deviation34.779471
Coefficient of variation (CV)0.45598428
Kurtosis0.13220611
Mean76.2734
Median Absolute Deviation (MAD)4
Skewness-1.2969988
Sum762734
Variance1209.6116
MonotonicityNot monotonic
2024-05-12T01:21:19.118901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4311
43.1%
0 1009
 
10.1%
96 523
 
5.2%
97 300
 
3.0%
95 231
 
2.3%
93 146
 
1.5%
98 133
 
1.3%
92 111
 
1.1%
89 111
 
1.1%
99 105
 
1.1%
Other values (91) 3020
30.2%
ValueCountFrequency (%)
0 1009
10.1%
1 17
 
0.2%
2 21
 
0.2%
3 10
 
0.1%
4 28
 
0.3%
5 18
 
0.2%
6 16
 
0.2%
7 35
 
0.4%
8 17
 
0.2%
9 18
 
0.2%
ValueCountFrequency (%)
100 4311
43.1%
99 105
 
1.1%
98 133
 
1.3%
97 300
 
3.0%
96 523
 
5.2%
95 231
 
2.3%
94 79
 
0.8%
93 146
 
1.5%
92 111
 
1.1%
91 103
 
1.0%

등록 일시
Date

Distinct8854
Distinct (%)88.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-10-09 00:01:55
Maximum2023-10-15 23:52:21
2024-05-12T01:21:19.515139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:21:20.014990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Sample

기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
48804금천구329KCN-1054832015316.1875.7874.2546.1556.2553.7542023-10-14 16:22:44
47180금천구329KCN-140983101217.107.307.407.407.4517.5572023-10-14 11:22:06
54725금천구329KCN-142883101000.0970.0970.0620.0650.0630.0642023-10-15 06:42:04
13789금천구329KCN-1347831012015.3774.3764.3754.6551.5490.0442023-10-10 13:52:11
16982금천구329KCN-1073831011000.5720.5730.5730.6690.5700.5692023-10-10 23:31:58
45107금천구329KCN-104283101500.01000.01000.01000.01000.01000.01002023-10-14 05:05:59
26968금천구329KCN-1250831010016.39016.29116.39016.19116.29116.3902023-10-12 01:41:45
2863금천구329KCN-118483001000.0910.0910.0930.0910.0890.0952023-10-09 08:31:49
44941금천구329KCN-1173831014310.21000.21000.21004.71007.81007.91002023-10-14 04:58:17
32699금천구329KCN-1410831011100.0950.0950.0950.0950.0950.0952023-10-12 19:02:51
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
27310금천구329KCN-111483201200.01000.01000.01000.01000.01000.01002023-10-12 02:42:54
42578금천구329KCN-127083001000.0940.0930.0930.0930.0930.0932023-10-13 21:52:29
29871금천구329KCN-1357831011408.81008.91008.81008.81008.71008.81002023-10-12 10:53:00
58400금천구329KCN-1189831011200.0900.0920.0970.01000.01000.01002023-10-15 17:51:52
38083금천구329KCN-1334831011205.8985.9965.8955.9935.8915.9892023-10-13 08:22:02
23341금천구329KCN-141783101500.000.000.000.000.000.002023-10-11 14:43:15
23860금천구329KCN-1005831012500.0290.0300.0320.0330.0390.0422023-10-11 16:12:21
39854금천구329KCN-1110832011100.0890.0900.0920.0900.0890.0902023-10-13 13:42:00
41909금천구329KCN-1081831011500.01000.01000.01000.01000.01000.01002023-10-13 19:52:57
7589금천구329KCN-120483131006.7746.7736.7746.7736.8736.7732023-10-09 22:42:54

Duplicate rows

Most frequently occurring

기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시# duplicates
9금천구329KCN-1073831011100.41000.31000.31000.11000.01000.01002023-10-11 05:02:483
23금천구329KCN-122183101300.01000.01000.01000.01000.01000.11002023-10-11 04:44:313
0금천구329KCN-10108310124111.010011.010011.010010.99611.010011.01002023-10-11 05:02:572
1금천구329KCN-101483101915.11004.51005.11006.31005.21005.01002023-10-13 05:03:422
2금천구329KCN-101683101101.31001.31001.41001.31001.31001.31002023-10-15 05:55:242
3금천구329KCN-1027831011600.41000.51000.41000.51000.41000.51002023-10-10 04:14:192
4금천구329KCN-103683101910.01000.01000.01000.81003.21003.11002023-10-15 05:56:552
5금천구329KCN-104083301908.0928.0929.1919.2919.1918.1912023-10-11 04:30:222
6금천구329KCN-1045831012300.01000.01000.01000.01000.01000.01002023-10-11 05:02:202
7금천구329KCN-1046831012400.01000.01000.01000.01000.01000.01002023-10-13 05:02:462