Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows54
Duplicate rows (%)0.5%
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 54 (0.5%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (68.5%)Imbalance
알림단계등급 is highly imbalanced (92.9%)Imbalance
활동수치 (%) has 513 (5.1%) zerosZeros
전력량1 (Wh) has 4371 (43.7%) zerosZeros
조도1 (%) has 1027 (10.3%) zerosZeros
전력량2 (Wh) has 4423 (44.2%) zerosZeros
조도2 (%) has 1018 (10.2%) zerosZeros
전력량3 (Wh) has 4446 (44.5%) zerosZeros
조도3 (%) has 1044 (10.4%) zerosZeros
전력량4 (Wh) has 4429 (44.3%) zerosZeros
조도4 (%) has 1059 (10.6%) zerosZeros
전력량5 (Wh) has 4413 (44.1%) zerosZeros
조도5 (%) has 1063 (10.6%) zerosZeros
전력량6 (Wh) has 4417 (44.2%) zerosZeros
조도6 (%) has 1064 (10.6%) zerosZeros

Reproduction

Analysis started2024-05-11 16:21:39.679380
Analysis finished2024-05-11 16:21:40.268239
Duration0.59 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:40.451989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

시리얼
Text

Distinct345
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:21:42.986215image/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-1048
2nd rowKCN-1246
3rd rowKCN-1334
4th rowKCN-1167
5th rowKCN-1152
ValueCountFrequency (%)
kcn-1290 43
 
0.4%
kcn-1319 42
 
0.4%
kcn-1031 41
 
0.4%
kcn-1373 41
 
0.4%
kcn-1044 41
 
0.4%
kcn-1132 41
 
0.4%
kcn-1149 41
 
0.4%
kcn-1257 41
 
0.4%
kcn-1045 40
 
0.4%
kcn-1332 40
 
0.4%
Other values (335) 9589
95.9%
2024-05-12T01:21:44.524955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14109
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
3 4569
 
5.7%
2 4469
 
5.6%
0 4282
 
5.4%
4 2834
 
3.5%
9 2069
 
2.6%
Other values (4) 7668
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 14109
35.3%
3 4569
 
11.4%
2 4469
 
11.2%
0 4282
 
10.7%
4 2834
 
7.1%
9 2069
 
5.2%
7 2049
 
5.1%
5 2024
 
5.1%
6 1912
 
4.8%
8 1683
 
4.2%
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 14109
28.2%
- 10000
20.0%
3 4569
 
9.1%
2 4469
 
8.9%
0 4282
 
8.6%
4 2834
 
5.7%
9 2069
 
4.1%
7 2049
 
4.1%
5 2024
 
4.0%
6 1912
 
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 14109
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
3 4569
 
5.7%
2 4469
 
5.6%
0 4282
 
5.4%
4 2834
 
3.5%
9 2069
 
2.6%
Other values (4) 7668
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:44.755018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:21:44.909378image/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
8946 
2
 
628
0
 
266
3
 
160

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 8946
89.5%
2 628
 
6.3%
0 266
 
2.7%
3 160
 
1.6%

Length

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

Common Values (Plot)

2024-05-12T01:21:45.239838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8946
89.5%
2 628
 
6.3%
0 266
 
2.7%
3 160
 
1.6%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9838 
3
 
92
1
 
53
2
 
17

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 9838
98.4%
3 92
 
0.9%
1 53
 
0.5%
2 17
 
0.2%

Length

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

Common Values (Plot)

2024-05-12T01:21:45.588758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9838
98.4%
3 92
 
0.9%
1 53
 
0.5%
2 17
 
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:45.767232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

ZEROS 

Distinct112
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.0928
Minimum0
Maximum117
Zeros513
Zeros (%)5.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:46.106962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median13
Q321
95-th percentile70
Maximum117
Range117
Interquartile range (IQR)15

Descriptive statistics

Standard deviation20.687958
Coefficient of variation (CV)1.0835476
Kurtosis3.5282746
Mean19.0928
Median Absolute Deviation (MAD)7
Skewness1.9866243
Sum190928
Variance427.99159
MonotonicityNot monotonic
2024-05-12T01:21:46.361081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 513
 
5.1%
5 418
 
4.2%
8 418
 
4.2%
10 413
 
4.1%
11 411
 
4.1%
9 409
 
4.1%
6 408
 
4.1%
12 404
 
4.0%
4 402
 
4.0%
14 381
 
3.8%
Other values (102) 5823
58.2%
ValueCountFrequency (%)
0 513
5.1%
1 272
2.7%
2 235
2.4%
3 318
3.2%
4 402
4.0%
5 418
4.2%
6 408
4.1%
7 353
3.5%
8 418
4.2%
9 409
4.1%
ValueCountFrequency (%)
117 1
 
< 0.1%
116 2
< 0.1%
115 4
< 0.1%
113 3
< 0.1%
112 3
< 0.1%
109 2
< 0.1%
108 1
 
< 0.1%
106 3
< 0.1%
105 2
< 0.1%
103 1
 
< 0.1%

최근활동
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 6893
68.9%
1 3107
31.1%

Length

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

Common Values (Plot)

2024-05-12T01:21:46.756342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 6893
68.9%
1 3107
31.1%

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

ZEROS 

Distinct341
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.60917
Minimum0
Maximum195.5
Zeros4371
Zeros (%)43.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:46.952672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.2
95-th percentile16.3
Maximum195.5
Range195.5
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation7.1057399
Coefficient of variation (CV)1.9688017
Kurtosis100.57464
Mean3.60917
Median Absolute Deviation (MAD)0.2
Skewness6.6050265
Sum36091.7
Variance50.49154
MonotonicityNot monotonic
2024-05-12T01:21:47.221358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4371
43.7%
0.1 575
 
5.8%
0.2 176
 
1.8%
0.3 147
 
1.5%
0.7 103
 
1.0%
1.5 101
 
1.0%
5.2 98
 
1.0%
1.4 94
 
0.9%
0.4 86
 
0.9%
4.0 84
 
0.8%
Other values (331) 4165
41.6%
ValueCountFrequency (%)
0.0 4371
43.7%
0.1 575
 
5.8%
0.2 176
 
1.8%
0.3 147
 
1.5%
0.4 86
 
0.9%
0.5 55
 
0.5%
0.6 27
 
0.3%
0.7 103
 
1.0%
0.8 44
 
0.4%
0.9 51
 
0.5%
ValueCountFrequency (%)
195.5 1
< 0.1%
130.1 1
< 0.1%
127.3 1
< 0.1%
124.7 1
< 0.1%
107.1 1
< 0.1%
88.7 1
< 0.1%
84.3 1
< 0.1%
79.7 1
< 0.1%
78.8 1
< 0.1%
68.0 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.351699
Coefficient of variation (CV)0.46793445
Kurtosis-0.063512898
Mean75.5484
Median Absolute Deviation (MAD)4
Skewness-1.2307057
Sum755484
Variance1249.7426
MonotonicityNot monotonic
2024-05-12T01:21:47.909402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4336
43.4%
0 1027
 
10.3%
96 501
 
5.0%
97 350
 
3.5%
95 229
 
2.3%
93 129
 
1.3%
89 117
 
1.2%
98 112
 
1.1%
94 102
 
1.0%
91 93
 
0.9%
Other values (91) 3004
30.0%
ValueCountFrequency (%)
0 1027
10.3%
1 17
 
0.2%
2 20
 
0.2%
3 21
 
0.2%
4 26
 
0.3%
5 15
 
0.1%
6 13
 
0.1%
7 21
 
0.2%
8 14
 
0.1%
9 28
 
0.3%
ValueCountFrequency (%)
100 4336
43.4%
99 89
 
0.9%
98 112
 
1.1%
97 350
 
3.5%
96 501
 
5.0%
95 229
 
2.3%
94 102
 
1.0%
93 129
 
1.3%
92 86
 
0.9%
91 93
 
0.9%

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

ZEROS 

Distinct324
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.54062
Minimum0
Maximum151.9
Zeros4423
Zeros (%)44.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:48.151978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.2
95-th percentile16.2
Maximum151.9
Range151.9
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation6.5429335
Coefficient of variation (CV)1.8479626
Kurtosis65.943814
Mean3.54062
Median Absolute Deviation (MAD)0.2
Skewness5.2519369
Sum35406.2
Variance42.809979
MonotonicityNot monotonic
2024-05-12T01:21:48.408813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4423
44.2%
0.1 547
 
5.5%
0.2 167
 
1.7%
0.4 126
 
1.3%
1.6 101
 
1.0%
1.4 100
 
1.0%
4.1 99
 
1.0%
1.8 91
 
0.9%
5.3 90
 
0.9%
0.3 88
 
0.9%
Other values (314) 4168
41.7%
ValueCountFrequency (%)
0.0 4423
44.2%
0.1 547
 
5.5%
0.2 167
 
1.7%
0.3 88
 
0.9%
0.4 126
 
1.3%
0.5 49
 
0.5%
0.6 51
 
0.5%
0.7 73
 
0.7%
0.8 15
 
0.1%
0.9 80
 
0.8%
ValueCountFrequency (%)
151.9 1
< 0.1%
126.8 1
< 0.1%
114.2 1
< 0.1%
101.5 1
< 0.1%
92.0 1
< 0.1%
87.1 1
< 0.1%
65.9 1
< 0.1%
65.6 1
< 0.1%
65.4 1
< 0.1%
58.7 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.414627
Coefficient of variation (CV)0.46887042
Kurtosis-0.07920599
Mean75.5318
Median Absolute Deviation (MAD)4
Skewness-1.2273055
Sum755318
Variance1254.1958
MonotonicityNot monotonic
2024-05-12T01:21:48.929551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4345
43.5%
0 1018
 
10.2%
96 498
 
5.0%
97 349
 
3.5%
95 223
 
2.2%
93 155
 
1.6%
89 117
 
1.2%
98 116
 
1.2%
94 103
 
1.0%
91 97
 
1.0%
Other values (91) 2979
29.8%
ValueCountFrequency (%)
0 1018
10.2%
1 20
 
0.2%
2 34
 
0.3%
3 14
 
0.1%
4 20
 
0.2%
5 14
 
0.1%
6 17
 
0.2%
7 21
 
0.2%
8 16
 
0.2%
9 30
 
0.3%
ValueCountFrequency (%)
100 4345
43.5%
99 87
 
0.9%
98 116
 
1.2%
97 349
 
3.5%
96 498
 
5.0%
95 223
 
2.2%
94 103
 
1.0%
93 155
 
1.6%
92 81
 
0.8%
91 97
 
1.0%

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

ZEROS 

Distinct328
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.57302
Minimum0
Maximum129.7
Zeros4446
Zeros (%)44.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:49.176400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.2
95-th percentile16.3
Maximum129.7
Range129.7
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation6.7187518
Coefficient of variation (CV)1.8804126
Kurtosis55.459766
Mean3.57302
Median Absolute Deviation (MAD)0.2
Skewness5.1248774
Sum35730.2
Variance45.141626
MonotonicityNot monotonic
2024-05-12T01:21:49.437772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4446
44.5%
0.1 550
 
5.5%
0.2 159
 
1.6%
0.3 118
 
1.2%
1.4 106
 
1.1%
0.4 102
 
1.0%
1.8 88
 
0.9%
1.5 86
 
0.9%
1.6 79
 
0.8%
2.6 75
 
0.8%
Other values (318) 4191
41.9%
ValueCountFrequency (%)
0.0 4446
44.5%
0.1 550
 
5.5%
0.2 159
 
1.6%
0.3 118
 
1.2%
0.4 102
 
1.0%
0.5 38
 
0.4%
0.6 47
 
0.5%
0.7 65
 
0.7%
0.8 43
 
0.4%
0.9 75
 
0.8%
ValueCountFrequency (%)
129.7 1
< 0.1%
126.7 1
< 0.1%
107.9 1
< 0.1%
104.9 1
< 0.1%
104.7 1
< 0.1%
89.7 1
< 0.1%
87.1 1
< 0.1%
72.1 1
< 0.1%
70.9 1
< 0.1%
67.6 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.496262
Coefficient of variation (CV)0.47032732
Kurtosis-0.082222361
Mean75.4714
Median Absolute Deviation (MAD)4
Skewness-1.2277854
Sum754714
Variance1259.9846
MonotonicityNot monotonic
2024-05-12T01:21:49.951671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4338
43.4%
0 1044
 
10.4%
96 518
 
5.2%
97 340
 
3.4%
95 211
 
2.1%
93 139
 
1.4%
89 119
 
1.2%
91 111
 
1.1%
98 104
 
1.0%
94 100
 
1.0%
Other values (91) 2976
29.8%
ValueCountFrequency (%)
0 1044
10.4%
1 20
 
0.2%
2 21
 
0.2%
3 16
 
0.2%
4 13
 
0.1%
5 27
 
0.3%
6 13
 
0.1%
7 24
 
0.2%
8 17
 
0.2%
9 21
 
0.2%
ValueCountFrequency (%)
100 4338
43.4%
99 95
 
0.9%
98 104
 
1.0%
97 340
 
3.4%
96 518
 
5.2%
95 211
 
2.1%
94 100
 
1.0%
93 139
 
1.4%
92 83
 
0.8%
91 111
 
1.1%

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

ZEROS 

Distinct323
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.55295
Minimum0
Maximum130.1
Zeros4429
Zeros (%)44.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:50.196577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.2
95-th percentile16.2
Maximum130.1
Range130.1
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation6.4998548
Coefficient of variation (CV)1.8294248
Kurtosis46.164405
Mean3.55295
Median Absolute Deviation (MAD)0.2
Skewness4.5581067
Sum35529.5
Variance42.248112
MonotonicityNot monotonic
2024-05-12T01:21:50.457780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4429
44.3%
0.1 560
 
5.6%
0.2 159
 
1.6%
0.4 109
 
1.1%
0.3 104
 
1.0%
1.4 91
 
0.9%
6.7 87
 
0.9%
1.6 87
 
0.9%
0.9 86
 
0.9%
1.5 86
 
0.9%
Other values (313) 4202
42.0%
ValueCountFrequency (%)
0.0 4429
44.3%
0.1 560
 
5.6%
0.2 159
 
1.6%
0.3 104
 
1.0%
0.4 109
 
1.1%
0.5 64
 
0.6%
0.6 36
 
0.4%
0.7 58
 
0.6%
0.8 33
 
0.3%
0.9 86
 
0.9%
ValueCountFrequency (%)
130.1 1
 
< 0.1%
126.2 1
 
< 0.1%
87.4 1
 
< 0.1%
86.8 2
< 0.1%
70.6 1
 
< 0.1%
68.5 1
 
< 0.1%
66.3 1
 
< 0.1%
65.8 1
 
< 0.1%
63.0 1
 
< 0.1%
58.1 3
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.694978
Coefficient of variation (CV)0.47488576
Kurtosis-0.14809386
Mean75.1654
Median Absolute Deviation (MAD)4
Skewness-1.2040655
Sum751654
Variance1274.1315
MonotonicityNot monotonic
2024-05-12T01:21:50.969617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4342
43.4%
0 1059
 
10.6%
96 506
 
5.1%
97 341
 
3.4%
95 212
 
2.1%
93 123
 
1.2%
98 110
 
1.1%
89 110
 
1.1%
94 105
 
1.1%
91 91
 
0.9%
Other values (91) 3001
30.0%
ValueCountFrequency (%)
0 1059
10.6%
1 13
 
0.1%
2 30
 
0.3%
3 13
 
0.1%
4 15
 
0.1%
5 23
 
0.2%
6 21
 
0.2%
7 23
 
0.2%
8 11
 
0.1%
9 29
 
0.3%
ValueCountFrequency (%)
100 4342
43.4%
99 84
 
0.8%
98 110
 
1.1%
97 341
 
3.4%
96 506
 
5.1%
95 212
 
2.1%
94 105
 
1.1%
93 123
 
1.2%
92 75
 
0.8%
91 91
 
0.9%

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

ZEROS 

Distinct337
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.64133
Minimum0
Maximum206.1
Zeros4413
Zeros (%)44.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:51.226745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile16.3
Maximum206.1
Range206.1
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation7.0344206
Coefficient of variation (CV)1.9318273
Kurtosis108.18905
Mean3.64133
Median Absolute Deviation (MAD)0.2
Skewness6.629231
Sum36413.3
Variance49.483073
MonotonicityNot monotonic
2024-05-12T01:21:51.474661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4413
44.1%
0.1 537
 
5.4%
0.2 162
 
1.6%
0.4 106
 
1.1%
0.3 102
 
1.0%
1.6 90
 
0.9%
1.8 90
 
0.9%
1.4 89
 
0.9%
1.5 87
 
0.9%
4.1 82
 
0.8%
Other values (327) 4242
42.4%
ValueCountFrequency (%)
0.0 4413
44.1%
0.1 537
 
5.4%
0.2 162
 
1.6%
0.3 102
 
1.0%
0.4 106
 
1.1%
0.5 44
 
0.4%
0.6 40
 
0.4%
0.7 73
 
0.7%
0.8 32
 
0.3%
0.9 74
 
0.7%
ValueCountFrequency (%)
206.1 1
< 0.1%
124.3 1
< 0.1%
109.1 1
< 0.1%
106.9 1
< 0.1%
103.1 1
< 0.1%
98.6 1
< 0.1%
98.3 1
< 0.1%
82.4 1
< 0.1%
70.8 1
< 0.1%
67.2 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.584749
Coefficient of variation (CV)0.47250023
Kurtosis-0.10575609
Mean75.3116
Median Absolute Deviation (MAD)4
Skewness-1.2182529
Sum753116
Variance1266.2743
MonotonicityNot monotonic
2024-05-12T01:21:51.981658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4351
43.5%
0 1063
 
10.6%
96 501
 
5.0%
97 352
 
3.5%
95 200
 
2.0%
89 123
 
1.2%
93 113
 
1.1%
91 105
 
1.1%
98 102
 
1.0%
94 97
 
1.0%
Other values (91) 2993
29.9%
ValueCountFrequency (%)
0 1063
10.6%
1 13
 
0.1%
2 27
 
0.3%
3 14
 
0.1%
4 21
 
0.2%
5 27
 
0.3%
6 17
 
0.2%
7 20
 
0.2%
8 16
 
0.2%
9 23
 
0.2%
ValueCountFrequency (%)
100 4351
43.5%
99 86
 
0.9%
98 102
 
1.0%
97 352
 
3.5%
96 501
 
5.0%
95 200
 
2.0%
94 97
 
1.0%
93 113
 
1.1%
92 82
 
0.8%
91 105
 
1.1%

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

ZEROS 

Distinct346
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.6666
Minimum0
Maximum178.3
Zeros4417
Zeros (%)44.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:52.225551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile16.4
Maximum178.3
Range178.3
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation7.2136614
Coefficient of variation (CV)1.967398
Kurtosis94.925063
Mean3.6666
Median Absolute Deviation (MAD)0.2
Skewness6.6238086
Sum36666
Variance52.03691
MonotonicityNot monotonic
2024-05-12T01:21:52.684348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4417
44.2%
0.1 549
 
5.5%
0.2 165
 
1.7%
0.4 106
 
1.1%
1.4 100
 
1.0%
0.3 95
 
0.9%
1.6 86
 
0.9%
1.5 83
 
0.8%
6.7 81
 
0.8%
0.9 80
 
0.8%
Other values (336) 4238
42.4%
ValueCountFrequency (%)
0.0 4417
44.2%
0.1 549
 
5.5%
0.2 165
 
1.7%
0.3 95
 
0.9%
0.4 106
 
1.1%
0.5 46
 
0.5%
0.6 54
 
0.5%
0.7 61
 
0.6%
0.8 41
 
0.4%
0.9 80
 
0.8%
ValueCountFrequency (%)
178.3 1
< 0.1%
145.8 1
< 0.1%
142.6 1
< 0.1%
112.1 1
< 0.1%
107.4 1
< 0.1%
107.0 1
< 0.1%
103.4 1
< 0.1%
102.6 1
< 0.1%
87.3 1
< 0.1%
80.8 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation35.631111
Coefficient of variation (CV)0.47388917
Kurtosis-0.12642364
Mean75.1887
Median Absolute Deviation (MAD)4
Skewness-1.2099837
Sum751887
Variance1269.576
MonotonicityNot monotonic
2024-05-12T01:21:53.202707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4337
43.4%
0 1064
 
10.6%
96 500
 
5.0%
97 358
 
3.6%
95 202
 
2.0%
89 131
 
1.3%
93 121
 
1.2%
98 111
 
1.1%
91 102
 
1.0%
92 94
 
0.9%
Other values (91) 2980
29.8%
ValueCountFrequency (%)
0 1064
10.6%
1 14
 
0.1%
2 28
 
0.3%
3 12
 
0.1%
4 14
 
0.1%
5 30
 
0.3%
6 19
 
0.2%
7 18
 
0.2%
8 13
 
0.1%
9 31
 
0.3%
ValueCountFrequency (%)
100 4337
43.4%
99 71
 
0.7%
98 111
 
1.1%
97 358
 
3.6%
96 500
 
5.0%
95 202
 
2.0%
94 79
 
0.8%
93 121
 
1.2%
92 94
 
0.9%
91 102
 
1.0%

등록 일시
Date

Distinct8646
Distinct (%)86.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-11-06 00:05:00
Maximum2023-11-12 23:12:36
2024-05-12T01:21:53.440536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:21:53.684123image/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 (%)등록 일시
408금천구329KCN-1048831011605.91005.41005.31005.41004.61005.01002023-11-06 01:15:39
10584금천구329KCN-1246831011210.01002.67515.07714.47814.47714.4772023-11-07 08:05:12
22281금천구329KCN-133483101905.8515.9515.8515.9515.8505.9512023-11-08 19:35:40
43657금천구329KCN-1167831017011.3411.4541.3441.401.4451.5452023-11-11 13:24:12
35091금천구329KCN-115283101814.2984.3984.2994.3994.374.2382023-11-10 10:36:34
38492금천구329KCN-1212831013710.0900.09070.9900.0900.0290.0302023-11-10 20:55:39
41889금천구329KCN-1375831011600.0960.0960.0960.0960.0960.0962023-11-11 08:32:21
7669금천구329KCN-1315831016317.923.624.626.6011.0217.21002023-11-06 23:15:39
6475금천구329KCN-1048831011715.135.416.825.601.200.102023-11-06 19:35:45
31797금천구329KCN-1345831015810.41000.41000.410015.61000.71000.41002023-11-10 01:03:55
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
45859금천구329KCN-141383101600.0970.0960.0960.0960.0960.0962023-11-11 20:42:56
27516금천구329KCN-1004831013418.637.4967.2997.51007.01006.71002023-11-09 11:25:04
51022금천구329KCN-1156832018100.01000.01000.01000.01000.01000.01002023-11-12 06:22:20
27927금천구329KCN-120383101501.31001.4961.4991.4991.4961.4952023-11-09 12:35:50
50773금천구329KCN-1216831011005.11005.11005.11005.11005.21005.11002023-11-12 06:03:49
162금천구329KCN-112283101500.01000.01000.01000.01000.01000.01002023-11-06 00:25:24
43168금천구329KCN-1081831012100.000.000.000.000.000.002023-11-11 11:06:30
5419금천구329KCN-119683101900.01000.01000.01000.01000.01000.01002023-11-06 16:25:46
32047금천구329KCN-1045831012104.41004.41004.41004.41004.41004.51002023-11-10 01:05:38
20571금천구329KCN-1179831012300.4980.4980.5980.4980.4980.4982023-11-08 14:25:41

Duplicate rows

Most frequently occurring

기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시# duplicates
11금천구329KCN-1083833012400.01000.01000.01000.01000.01000.01002023-11-12 06:36:163
15금천구329KCN-11358310158113.49113.69119.09117.29116.39115.6912023-11-12 06:35:453
38금천구329KCN-130483101200.01000.01000.01000.01000.01000.01002023-11-12 06:34:113
48금천구329KCN-1381831015021.59621.39621.59621.49621.29621.4962023-11-12 06:34:463
0금천구329KCN-10098310113011.010011.110011.010011.010011.110011.01002023-11-12 06:35:392
1금천구329KCN-10108310114011.010010.910011.010011.010011.010011.01002023-11-12 04:28:582
2금천구329KCN-102083101100.31000.31000.31000.31000.31000.31002023-11-12 06:37:152
3금천구329KCN-1022831013800.01000.01000.01000.01000.01000.01002023-11-12 04:25:422
4금천구329KCN-1037832011302.91002.91002.71002.81002.71002.71002023-11-12 06:35:442
5금천구329KCN-1052831016600.11000.11000.11000.11000.11000.11002023-11-12 04:32:292