Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows11
Duplicate rows (%)0.1%
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 11 (0.1%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (68.1%)Imbalance
알림단계등급 is highly imbalanced (93.2%)Imbalance
활동수치 (%) has 585 (5.9%) zerosZeros
전력량1 (Wh) has 4323 (43.2%) zerosZeros
조도1 (%) has 1124 (11.2%) zerosZeros
전력량2 (Wh) has 4409 (44.1%) zerosZeros
조도2 (%) has 1135 (11.3%) zerosZeros
전력량3 (Wh) has 4410 (44.1%) zerosZeros
조도3 (%) has 1115 (11.2%) zerosZeros
전력량4 (Wh) has 4404 (44.0%) zerosZeros
조도4 (%) has 1118 (11.2%) zerosZeros
전력량5 (Wh) has 4396 (44.0%) zerosZeros
조도5 (%) has 1126 (11.3%) zerosZeros
전력량6 (Wh) has 4402 (44.0%) zerosZeros
조도6 (%) has 1125 (11.2%) zerosZeros

Reproduction

Analysis started2024-05-11 16:20:27.383588
Analysis finished2024-05-11 16:20:28.031723
Duration0.65 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:20:28.138880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

시리얼
Text

Distinct350
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:20:30.008820image/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-1311
2nd rowKCN-1177
3rd rowKCN-1097
4th rowKCN-1408
5th rowKCN-1295
ValueCountFrequency (%)
kcn-1278 45
 
0.4%
kcn-1297 40
 
0.4%
kcn-1099 40
 
0.4%
kcn-1332 39
 
0.4%
kcn-1401 39
 
0.4%
kcn-1055 39
 
0.4%
kcn-1418 38
 
0.4%
kcn-1127 38
 
0.4%
kcn-1253 38
 
0.4%
kcn-1135 38
 
0.4%
Other values (340) 9606
96.1%
2024-05-12T01:20:31.330860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14248
17.8%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4632
 
5.8%
3 4450
 
5.6%
0 4087
 
5.1%
4 2812
 
3.5%
9 2118
 
2.6%
Other values (4) 7653
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 14248
35.6%
2 4632
 
11.6%
3 4450
 
11.1%
0 4087
 
10.2%
4 2812
 
7.0%
9 2118
 
5.3%
7 2005
 
5.0%
5 1962
 
4.9%
6 1891
 
4.7%
8 1795
 
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 14248
28.5%
- 10000
20.0%
2 4632
 
9.3%
3 4450
 
8.9%
0 4087
 
8.2%
4 2812
 
5.6%
9 2118
 
4.2%
7 2005
 
4.0%
5 1962
 
3.9%
6 1891
 
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 14248
17.8%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4632
 
5.8%
3 4450
 
5.6%
0 4087
 
5.1%
4 2812
 
3.5%
9 2118
 
2.6%
Other values (4) 7653
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:20:31.558249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:20:31.712599image/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
8933 
2
 
620
0
 
277
3
 
170

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 8933
89.3%
2 620
 
6.2%
0 277
 
2.8%
3 170
 
1.7%

Length

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

Common Values (Plot)

2024-05-12T01:20:32.041806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8933
89.3%
2 620
 
6.2%
0 277
 
2.8%
3 170
 
1.7%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9847 
1
 
85
3
 
49
2
 
19

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 9847
98.5%
1 85
 
0.9%
3 49
 
0.5%
2 19
 
0.2%

Length

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

Common Values (Plot)

2024-05-12T01:20:32.553090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9847
98.5%
1 85
 
0.9%
3 49
 
0.5%
2 19
 
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:20:32.733550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

ZEROS 

Distinct124
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.8274
Minimum0
Maximum129
Zeros585
Zeros (%)5.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:33.076539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median12
Q321
95-th percentile75
Maximum129
Range129
Interquartile range (IQR)15

Descriptive statistics

Standard deviation21.962501
Coefficient of variation (CV)1.166518
Kurtosis5.2405885
Mean18.8274
Median Absolute Deviation (MAD)7
Skewness2.3021144
Sum188274
Variance482.35144
MonotonicityNot monotonic
2024-05-12T01:20:33.336999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 585
 
5.9%
7 435
 
4.3%
6 423
 
4.2%
9 408
 
4.1%
8 404
 
4.0%
10 396
 
4.0%
13 391
 
3.9%
3 388
 
3.9%
11 370
 
3.7%
5 363
 
3.6%
Other values (114) 5837
58.4%
ValueCountFrequency (%)
0 585
5.9%
1 281
2.8%
2 313
3.1%
3 388
3.9%
4 360
3.6%
5 363
3.6%
6 423
4.2%
7 435
4.3%
8 404
4.0%
9 408
4.1%
ValueCountFrequency (%)
129 1
 
< 0.1%
128 2
 
< 0.1%
125 4
 
< 0.1%
123 1
 
< 0.1%
122 1
 
< 0.1%
121 1
 
< 0.1%
119 3
 
< 0.1%
118 7
0.1%
117 11
0.1%
116 9
0.1%

최근활동
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 7000
70.0%
1 3000
30.0%

Length

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

Common Values (Plot)

2024-05-12T01:20:33.729537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 7000
70.0%
1 3000
30.0%

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

ZEROS 

Distinct310
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.51587
Minimum0
Maximum211.5
Zeros4323
Zeros (%)43.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:33.925958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile15.4
Maximum211.5
Range211.5
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation7.5632371
Coefficient of variation (CV)2.1511709
Kurtosis115.85616
Mean3.51587
Median Absolute Deviation (MAD)0.1
Skewness7.6311357
Sum35158.7
Variance57.202555
MonotonicityNot monotonic
2024-05-12T01:20:34.172721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4323
43.2%
0.1 680
 
6.8%
0.2 226
 
2.3%
0.3 189
 
1.9%
1.4 93
 
0.9%
6.7 90
 
0.9%
1.5 90
 
0.9%
5.2 84
 
0.8%
4.1 83
 
0.8%
0.8 81
 
0.8%
Other values (300) 4061
40.6%
ValueCountFrequency (%)
0.0 4323
43.2%
0.1 680
 
6.8%
0.2 226
 
2.3%
0.3 189
 
1.9%
0.4 72
 
0.7%
0.5 59
 
0.6%
0.6 36
 
0.4%
0.7 78
 
0.8%
0.8 81
 
0.8%
0.9 26
 
0.3%
ValueCountFrequency (%)
211.5 1
< 0.1%
145.3 1
< 0.1%
141.4 1
< 0.1%
120.5 1
< 0.1%
114.8 1
< 0.1%
93.9 1
< 0.1%
84.7 1
< 0.1%
78.3 1
< 0.1%
76.3 1
< 0.1%
70.1 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.6386
Minimum0
Maximum100
Zeros1124
Zeros (%)11.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:34.425220image/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.503167
Coefficient of variation (CV)0.47566764
Kurtosis-0.13186134
Mean74.6386
Median Absolute Deviation (MAD)4
Skewness-1.1954861
Sum746386
Variance1260.4748
MonotonicityNot monotonic
2024-05-12T01:20:34.675664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4071
40.7%
0 1124
 
11.2%
96 526
 
5.3%
97 294
 
2.9%
95 206
 
2.1%
98 150
 
1.5%
93 138
 
1.4%
89 136
 
1.4%
91 113
 
1.1%
99 99
 
1.0%
Other values (91) 3143
31.4%
ValueCountFrequency (%)
0 1124
11.2%
1 13
 
0.1%
2 24
 
0.2%
3 11
 
0.1%
4 17
 
0.2%
5 20
 
0.2%
6 16
 
0.2%
7 19
 
0.2%
8 4
 
< 0.1%
9 25
 
0.2%
ValueCountFrequency (%)
100 4071
40.7%
99 99
 
1.0%
98 150
 
1.5%
97 294
 
2.9%
96 526
 
5.3%
95 206
 
2.1%
94 68
 
0.7%
93 138
 
1.4%
92 83
 
0.8%
91 113
 
1.1%

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

ZEROS 

Distinct308
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.23025
Minimum0
Maximum132.6
Zeros4409
Zeros (%)44.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:34.921792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35
95-th percentile14.8
Maximum132.6
Range132.6
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5.9032676
Coefficient of variation (CV)1.8274956
Kurtosis61.975599
Mean3.23025
Median Absolute Deviation (MAD)0.1
Skewness4.9950833
Sum32302.5
Variance34.848569
MonotonicityNot monotonic
2024-05-12T01:20:35.182726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4409
44.1%
0.1 665
 
6.7%
0.2 201
 
2.0%
0.3 143
 
1.4%
0.4 120
 
1.2%
4.1 108
 
1.1%
0.9 102
 
1.0%
1.4 101
 
1.0%
1.6 101
 
1.0%
1.8 87
 
0.9%
Other values (298) 3963
39.6%
ValueCountFrequency (%)
0.0 4409
44.1%
0.1 665
 
6.7%
0.2 201
 
2.0%
0.3 143
 
1.4%
0.4 120
 
1.2%
0.5 34
 
0.3%
0.6 58
 
0.6%
0.7 42
 
0.4%
0.8 20
 
0.2%
0.9 102
 
1.0%
ValueCountFrequency (%)
132.6 1
< 0.1%
124.9 1
< 0.1%
95.0 1
< 0.1%
93.8 1
< 0.1%
63.1 1
< 0.1%
60.4 1
< 0.1%
57.8 1
< 0.1%
55.5 1
< 0.1%
54.9 2
< 0.1%
52.9 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.6345
Minimum0
Maximum100
Zeros1135
Zeros (%)11.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:35.443512image/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.536592
Coefficient of variation (CV)0.47614163
Kurtosis-0.12971237
Mean74.6345
Median Absolute Deviation (MAD)4
Skewness-1.1969632
Sum746345
Variance1262.8494
MonotonicityNot monotonic
2024-05-12T01:20:35.695752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4084
40.8%
0 1135
 
11.3%
96 519
 
5.2%
97 296
 
3.0%
95 197
 
2.0%
89 151
 
1.5%
93 139
 
1.4%
98 138
 
1.4%
91 110
 
1.1%
99 96
 
1.0%
Other values (91) 3135
31.4%
ValueCountFrequency (%)
0 1135
11.3%
1 8
 
0.1%
2 20
 
0.2%
3 13
 
0.1%
4 24
 
0.2%
5 20
 
0.2%
6 11
 
0.1%
7 18
 
0.2%
8 9
 
0.1%
9 24
 
0.2%
ValueCountFrequency (%)
100 4084
40.8%
99 96
 
1.0%
98 138
 
1.4%
97 296
 
3.0%
96 519
 
5.2%
95 197
 
2.0%
94 88
 
0.9%
93 139
 
1.4%
92 91
 
0.9%
91 110
 
1.1%

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

ZEROS 

Distinct306
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.27818
Minimum0
Maximum137.9
Zeros4410
Zeros (%)44.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:35.931763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35
95-th percentile14.9
Maximum137.9
Range137.9
Interquartile range (IQR)5

Descriptive statistics

Standard deviation6.2986079
Coefficient of variation (CV)1.9213734
Kurtosis85.275991
Mean3.27818
Median Absolute Deviation (MAD)0.1
Skewness6.2149972
Sum32781.8
Variance39.672461
MonotonicityNot monotonic
2024-05-12T01:20:36.184862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4410
44.1%
0.1 667
 
6.7%
0.2 201
 
2.0%
0.3 149
 
1.5%
0.4 126
 
1.3%
1.4 99
 
1.0%
4.1 92
 
0.9%
1.8 91
 
0.9%
6.7 87
 
0.9%
1.5 84
 
0.8%
Other values (296) 3994
39.9%
ValueCountFrequency (%)
0.0 4410
44.1%
0.1 667
 
6.7%
0.2 201
 
2.0%
0.3 149
 
1.5%
0.4 126
 
1.3%
0.5 37
 
0.4%
0.6 52
 
0.5%
0.7 45
 
0.4%
0.8 56
 
0.6%
0.9 64
 
0.6%
ValueCountFrequency (%)
137.9 1
< 0.1%
136.1 1
< 0.1%
116.2 1
< 0.1%
109.6 1
< 0.1%
101.1 1
< 0.1%
96.9 1
< 0.1%
90.3 1
< 0.1%
84.3 1
< 0.1%
75.4 1
< 0.1%
71.7 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.7041
Minimum0
Maximum100
Zeros1115
Zeros (%)11.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:36.451344image/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.469973
Coefficient of variation (CV)0.47480624
Kurtosis-0.11585295
Mean74.7041
Median Absolute Deviation (MAD)4
Skewness-1.2012858
Sum747041
Variance1258.119
MonotonicityNot monotonic
2024-05-12T01:20:36.702706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4098
41.0%
0 1115
 
11.2%
96 509
 
5.1%
97 284
 
2.8%
95 207
 
2.1%
98 142
 
1.4%
93 136
 
1.4%
89 127
 
1.3%
91 113
 
1.1%
99 99
 
1.0%
Other values (91) 3170
31.7%
ValueCountFrequency (%)
0 1115
11.2%
1 16
 
0.2%
2 19
 
0.2%
3 25
 
0.2%
4 20
 
0.2%
5 19
 
0.2%
6 10
 
0.1%
7 21
 
0.2%
8 10
 
0.1%
9 17
 
0.2%
ValueCountFrequency (%)
100 4098
41.0%
99 99
 
1.0%
98 142
 
1.4%
97 284
 
2.8%
96 509
 
5.1%
95 207
 
2.1%
94 81
 
0.8%
93 136
 
1.4%
92 97
 
1.0%
91 113
 
1.1%

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

ZEROS 

Distinct297
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.22053
Minimum0
Maximum145
Zeros4404
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:36.943512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35
95-th percentile14.6
Maximum145
Range145
Interquartile range (IQR)5

Descriptive statistics

Standard deviation5.9565783
Coefficient of variation (CV)1.8495646
Kurtosis79.517156
Mean3.22053
Median Absolute Deviation (MAD)0.1
Skewness5.6632999
Sum32205.3
Variance35.480826
MonotonicityNot monotonic
2024-05-12T01:20:37.200073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4404
44.0%
0.1 670
 
6.7%
0.2 192
 
1.9%
0.3 143
 
1.4%
0.4 136
 
1.4%
4.1 128
 
1.3%
1.4 89
 
0.9%
1.8 89
 
0.9%
0.9 87
 
0.9%
1.6 82
 
0.8%
Other values (287) 3980
39.8%
ValueCountFrequency (%)
0.0 4404
44.0%
0.1 670
 
6.7%
0.2 192
 
1.9%
0.3 143
 
1.4%
0.4 136
 
1.4%
0.5 59
 
0.6%
0.6 24
 
0.2%
0.7 54
 
0.5%
0.8 29
 
0.3%
0.9 87
 
0.9%
ValueCountFrequency (%)
145.0 1
< 0.1%
126.5 1
< 0.1%
111.0 1
< 0.1%
89.7 1
< 0.1%
83.6 1
< 0.1%
73.2 1
< 0.1%
66.6 1
< 0.1%
65.1 1
< 0.1%
64.2 1
< 0.1%
63.0 1
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.7126
Minimum0
Maximum100
Zeros1118
Zeros (%)11.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:37.651254image/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.438978
Coefficient of variation (CV)0.47433737
Kurtosis-0.11084268
Mean74.7126
Median Absolute Deviation (MAD)4
Skewness-1.2029507
Sum747126
Variance1255.9212
MonotonicityNot monotonic
2024-05-12T01:20:37.902799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4098
41.0%
0 1118
 
11.2%
96 507
 
5.1%
97 287
 
2.9%
95 205
 
2.1%
93 139
 
1.4%
89 134
 
1.3%
98 131
 
1.3%
92 103
 
1.0%
91 101
 
1.0%
Other values (91) 3177
31.8%
ValueCountFrequency (%)
0 1118
11.2%
1 14
 
0.1%
2 18
 
0.2%
3 10
 
0.1%
4 22
 
0.2%
5 13
 
0.1%
6 14
 
0.1%
7 29
 
0.3%
8 11
 
0.1%
9 13
 
0.1%
ValueCountFrequency (%)
100 4098
41.0%
99 95
 
0.9%
98 131
 
1.3%
97 287
 
2.9%
96 507
 
5.1%
95 205
 
2.1%
94 88
 
0.9%
93 139
 
1.4%
92 103
 
1.0%
91 101
 
1.0%

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

ZEROS 

Distinct311
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.25109
Minimum0
Maximum146
Zeros4396
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:38.144459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation6.1723638
Coefficient of variation (CV)1.8985521
Kurtosis82.939332
Mean3.25109
Median Absolute Deviation (MAD)0.1
Skewness5.9526735
Sum32510.9
Variance38.098075
MonotonicityNot monotonic
2024-05-12T01:20:38.402572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4396
44.0%
0.1 664
 
6.6%
0.2 200
 
2.0%
0.3 171
 
1.7%
4.1 103
 
1.0%
0.4 102
 
1.0%
1.4 98
 
1.0%
1.6 89
 
0.9%
1.8 86
 
0.9%
6.7 83
 
0.8%
Other values (301) 4008
40.1%
ValueCountFrequency (%)
0.0 4396
44.0%
0.1 664
 
6.6%
0.2 200
 
2.0%
0.3 171
 
1.7%
0.4 102
 
1.0%
0.5 34
 
0.3%
0.6 53
 
0.5%
0.7 47
 
0.5%
0.8 45
 
0.4%
0.9 80
 
0.8%
ValueCountFrequency (%)
146.0 1
< 0.1%
126.9 1
< 0.1%
122.9 1
< 0.1%
102.6 1
< 0.1%
97.6 1
< 0.1%
73.1 1
< 0.1%
68.3 1
< 0.1%
66.7 1
< 0.1%
65.6 2
< 0.1%
65.2 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.4413
Minimum0
Maximum100
Zeros1126
Zeros (%)11.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:38.670735image/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.610745
Coefficient of variation (CV)0.4783735
Kurtosis-0.15654653
Mean74.4413
Median Absolute Deviation (MAD)4
Skewness-1.1872979
Sum744413
Variance1268.1252
MonotonicityNot monotonic
2024-05-12T01:20:38.921293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4065
40.6%
0 1126
 
11.3%
96 513
 
5.1%
97 283
 
2.8%
95 196
 
2.0%
93 152
 
1.5%
89 134
 
1.3%
98 116
 
1.2%
99 111
 
1.1%
91 109
 
1.1%
Other values (91) 3195
31.9%
ValueCountFrequency (%)
0 1126
11.3%
1 16
 
0.2%
2 18
 
0.2%
3 18
 
0.2%
4 25
 
0.2%
5 12
 
0.1%
6 17
 
0.2%
7 28
 
0.3%
8 8
 
0.1%
9 24
 
0.2%
ValueCountFrequency (%)
100 4065
40.6%
99 111
 
1.1%
98 116
 
1.2%
97 283
 
2.8%
96 513
 
5.1%
95 196
 
2.0%
94 84
 
0.8%
93 152
 
1.5%
92 83
 
0.8%
91 109
 
1.1%

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

ZEROS 

Distinct300
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.26439
Minimum0
Maximum137.2
Zeros4402
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:39.156822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.9
95-th percentile15
Maximum137.2
Range137.2
Interquartile range (IQR)4.9

Descriptive statistics

Standard deviation6.253929
Coefficient of variation (CV)1.9158033
Kurtosis85.121122
Mean3.26439
Median Absolute Deviation (MAD)0.1
Skewness6.0915067
Sum32643.9
Variance39.111628
MonotonicityNot monotonic
2024-05-12T01:20:39.406538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4402
44.0%
0.1 680
 
6.8%
0.2 194
 
1.9%
0.3 149
 
1.5%
0.4 120
 
1.2%
4.1 108
 
1.1%
1.4 94
 
0.9%
1.6 85
 
0.9%
6.7 82
 
0.8%
1.8 79
 
0.8%
Other values (290) 4007
40.1%
ValueCountFrequency (%)
0.0 4402
44.0%
0.1 680
 
6.8%
0.2 194
 
1.9%
0.3 149
 
1.5%
0.4 120
 
1.2%
0.5 39
 
0.4%
0.6 55
 
0.5%
0.7 49
 
0.5%
0.8 45
 
0.4%
0.9 67
 
0.7%
ValueCountFrequency (%)
137.2 1
< 0.1%
136.4 1
< 0.1%
135.7 1
< 0.1%
98.2 1
< 0.1%
93.0 1
< 0.1%
87.0 1
< 0.1%
66.9 1
< 0.1%
66.4 1
< 0.1%
66.3 1
< 0.1%
65.2 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.4785
Minimum0
Maximum100
Zeros1125
Zeros (%)11.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:39.671958image/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.578869
Coefficient of variation (CV)0.47770657
Kurtosis-0.14210784
Mean74.4785
Median Absolute Deviation (MAD)4
Skewness-1.1915902
Sum744785
Variance1265.8559
MonotonicityNot monotonic
2024-05-12T01:20:39.924186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4080
40.8%
0 1125
 
11.2%
96 522
 
5.2%
97 266
 
2.7%
95 193
 
1.9%
98 141
 
1.4%
89 130
 
1.3%
93 129
 
1.3%
91 118
 
1.2%
92 98
 
1.0%
Other values (91) 3198
32.0%
ValueCountFrequency (%)
0 1125
11.2%
1 18
 
0.2%
2 24
 
0.2%
3 14
 
0.1%
4 25
 
0.2%
5 11
 
0.1%
6 16
 
0.2%
7 32
 
0.3%
8 11
 
0.1%
9 22
 
0.2%
ValueCountFrequency (%)
100 4080
40.8%
99 90
 
0.9%
98 141
 
1.4%
97 266
 
2.7%
96 522
 
5.2%
95 193
 
1.9%
94 86
 
0.9%
93 129
 
1.3%
92 98
 
1.0%
91 118
 
1.2%

등록 일시
Date

Distinct8862
Distinct (%)88.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-10-02 00:02:29
Maximum2023-10-08 23:52:17
2024-05-12T01:20:40.161479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:20:40.406412image/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 (%)등록 일시
24381금천구329KCN-1311831011504.71004.81004.71004.71004.81004.71002023-10-04 20:52:31
23349금천구329KCN-11778310113017.210017.110017.010016.910017.010016.91002023-10-04 18:02:43
32184금천구329KCN-1097831012110.01000.01000.01000.01000.0014.81002023-10-05 20:02:08
27215금천구329KCN-1408831012014.1954.7953.6954.3952.9973.1972023-10-05 05:14:32
24446금천구329KCN-129583101305.305.305.305.205.305.302023-10-04 21:02:55
1161금천구329KCN-1416831011814.7964.7964.7964.7964.7961.602023-10-02 03:39:27
50457금천구329KCN-127083001000.0930.0930.0930.0930.0930.0932023-10-08 03:16:49
46819금천구329KCN-1276831013000.050.000.000.0190.0270.032023-10-07 16:22:05
48313금천구329KCN-1250831310016.48816.58916.48916.58916.48916.4892023-10-07 20:52:01
3514금천구329KCN-142183101500.690.440.470.300.200.102023-10-02 10:15:03
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
17686금천구329KCN-1408831011802.8972.8972.9973.0972.9972.8972023-10-04 04:07:35
15846금천구329KCN-107583201700.01000.01000.01000.01000.01000.01002023-10-03 23:22:35
45501금천구329KCN-141883101306.1956.0955.6876.0876.1875.7882023-10-07 12:22:01
42684금천구329KCN-1379831011200.0890.0890.0890.0890.0890.0892023-10-07 03:44:48
22930금천구329KCN-1396831011510.0303.2253.8383.8333.8303.8412023-10-04 16:32:25
20311금천구329KCN-1054832013900.0470.0450.0460.0440.0160.002023-10-04 08:44:12
28015금천구329KCN-1135831016010.9014.69114.58314.1920.2910.0912023-10-05 07:32:44
9343금천구329KCN-1240831011400.21000.21000.21000.21000.21000.21002023-10-03 03:40:39
5662금천구329KCN-1007831011518.5816.8988.1968.6902.5980.01002023-10-02 16:33:00
53086금천구329KCN-1345831016111.01000.410014.81000.41000.41000.41002023-10-08 11:02:07

Duplicate rows

Most frequently occurring

기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시# duplicates
0금천구329KCN-1022831013200.01000.01000.01000.01000.01000.01002023-10-04 04:23:142
1금천구329KCN-1038832011700.11000.11000.11000.11000.11000.11002023-10-04 05:01:592
2금천구329KCN-1129831011600.000.000.000.000.000.002023-10-05 03:54:022
3금천구329KCN-120383101401.41001.41001.41001.41001.41001.41002023-10-06 04:11:512
4금천구329KCN-120383101611.31001.31001.31001.31001.3321.31002023-10-04 05:01:512
5금천구329KCN-1231831011200.01000.01000.01000.01000.01000.01002023-10-04 05:02:012
6금천구329KCN-130583101300.11000.11000.11000.11000.11000.11002023-10-04 04:41:442
7금천구329KCN-1312831011100.01000.01000.01000.01000.01000.01002023-10-04 04:13:202
8금천구329KCN-1316831011900.01000.01000.01000.01000.01000.01002023-10-04 04:50:002
9금천구329KCN-1356831011000.01000.01000.01000.01000.01000.01002023-10-04 04:25:392