Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
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 2 (< 0.1%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (69.6%)Imbalance
알림단계등급 is highly imbalanced (92.6%)Imbalance
활동수치 (%) has 501 (5.0%) zerosZeros
전력량1 (Wh) has 4352 (43.5%) zerosZeros
조도1 (%) has 1033 (10.3%) zerosZeros
전력량2 (Wh) has 4384 (43.8%) zerosZeros
조도2 (%) has 1014 (10.1%) zerosZeros
전력량3 (Wh) has 4384 (43.8%) zerosZeros
조도3 (%) has 1008 (10.1%) zerosZeros
전력량4 (Wh) has 4391 (43.9%) zerosZeros
조도4 (%) has 1003 (10.0%) zerosZeros
전력량5 (Wh) has 4397 (44.0%) zerosZeros
조도5 (%) has 1009 (10.1%) zerosZeros
전력량6 (Wh) has 4380 (43.8%) zerosZeros
조도6 (%) has 1003 (10.0%) zerosZeros

Reproduction

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

2024-05-12T01:21:24.592515image/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:25.689298image/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-1096
2nd rowKCN-1392
3rd rowKCN-1036
4th rowKCN-1211
5th rowKCN-1343
ValueCountFrequency (%)
kcn-1267 42
 
0.4%
kcn-1170 42
 
0.4%
kcn-1390 42
 
0.4%
kcn-1222 41
 
0.4%
kcn-1230 40
 
0.4%
kcn-1124 39
 
0.4%
kcn-1237 39
 
0.4%
kcn-1134 38
 
0.4%
kcn-1419 38
 
0.4%
kcn-1049 38
 
0.4%
Other values (335) 9601
96.0%
2024-05-12T01:21:27.246232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14028
17.5%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4617
 
5.8%
3 4519
 
5.6%
0 4244
 
5.3%
4 2779
 
3.5%
9 2135
 
2.7%
Other values (4) 7678
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 14028
35.1%
2 4617
 
11.5%
3 4519
 
11.3%
0 4244
 
10.6%
4 2779
 
6.9%
9 2135
 
5.3%
7 2074
 
5.2%
5 2009
 
5.0%
6 1884
 
4.7%
8 1711
 
4.3%
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 14028
28.1%
- 10000
20.0%
2 4617
 
9.2%
3 4519
 
9.0%
0 4244
 
8.5%
4 2779
 
5.6%
9 2135
 
4.3%
7 2074
 
4.1%
5 2009
 
4.0%
6 1884
 
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 14028
17.5%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4617
 
5.8%
3 4519
 
5.6%
0 4244
 
5.3%
4 2779
 
3.5%
9 2135
 
2.7%
Other values (4) 7678
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:27.653927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:21:27.940530image/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
8989 
2
 
610
0
 
257
3
 
144

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 8989
89.9%
2 610
 
6.1%
0 257
 
2.6%
3 144
 
1.4%

Length

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

Common Values (Plot)

2024-05-12T01:21:28.553405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8989
89.9%
2 610
 
6.1%
0 257
 
2.6%
3 144
 
1.4%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9830 
3
 
95
1
 
49
2
 
26

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 9830
98.3%
3 95
 
0.9%
1 49
 
0.5%
2 26
 
0.3%

Length

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

Common Values (Plot)

2024-05-12T01:21:29.195473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9830
98.3%
3 95
 
0.9%
1 49
 
0.5%
2 26
 
0.3%

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

Common Values (Plot)

2024-05-12T01:21:29.816324image/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%
Mean18.5566
Minimum0
Maximum118
Zeros501
Zeros (%)5.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:30.132710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median13
Q321
95-th percentile67
Maximum118
Range118
Interquartile range (IQR)15

Descriptive statistics

Standard deviation19.851433
Coefficient of variation (CV)1.0697775
Kurtosis3.9364565
Mean18.5566
Median Absolute Deviation (MAD)8
Skewness1.9920055
Sum185566
Variance394.0794
MonotonicityNot monotonic
2024-05-12T01:21:30.430773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 501
 
5.0%
5 434
 
4.3%
4 421
 
4.2%
3 416
 
4.2%
6 399
 
4.0%
8 390
 
3.9%
9 385
 
3.9%
7 376
 
3.8%
13 376
 
3.8%
10 371
 
3.7%
Other values (102) 5931
59.3%
ValueCountFrequency (%)
0 501
5.0%
1 265
2.6%
2 322
3.2%
3 416
4.2%
4 421
4.2%
5 434
4.3%
6 399
4.0%
7 376
3.8%
8 390
3.9%
9 385
3.9%
ValueCountFrequency (%)
118 5
0.1%
116 3
 
< 0.1%
114 1
 
< 0.1%
113 3
 
< 0.1%
112 1
 
< 0.1%
110 6
0.1%
109 11
0.1%
108 3
 
< 0.1%
107 2
 
< 0.1%
106 1
 
< 0.1%

최근활동
Categorical

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

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 (%)
0 6951
69.5%
1 3049
30.5%

Length

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

Common Values (Plot)

2024-05-12T01:21:30.822155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 6951
69.5%
1 3049
30.5%

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

ZEROS 

Distinct320
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.59512
Minimum0
Maximum210.8
Zeros4352
Zeros (%)43.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:31.018263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation6.7981803
Coefficient of variation (CV)1.8909467
Kurtosis135.82271
Mean3.59512
Median Absolute Deviation (MAD)0.2
Skewness7.1912214
Sum35951.2
Variance46.215256
MonotonicityNot monotonic
2024-05-12T01:21:31.265401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4352
43.5%
0.1 538
 
5.4%
0.3 167
 
1.7%
0.2 159
 
1.6%
5.2 111
 
1.1%
0.7 106
 
1.1%
1.5 88
 
0.9%
6.7 83
 
0.8%
1.4 80
 
0.8%
0.8 78
 
0.8%
Other values (310) 4238
42.4%
ValueCountFrequency (%)
0.0 4352
43.5%
0.1 538
 
5.4%
0.2 159
 
1.6%
0.3 167
 
1.7%
0.4 74
 
0.7%
0.5 65
 
0.7%
0.6 25
 
0.2%
0.7 106
 
1.1%
0.8 78
 
0.8%
0.9 22
 
0.2%
ValueCountFrequency (%)
210.8 1
< 0.1%
146.1 1
< 0.1%
125.0 1
< 0.1%
98.8 1
< 0.1%
95.5 1
< 0.1%
94.3 1
< 0.1%
89.7 1
< 0.1%
77.9 1
< 0.1%
72.8 1
< 0.1%
67.8 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.907453
Coefficient of variation (CV)0.46063352
Kurtosis0.064334296
Mean75.7814
Median Absolute Deviation (MAD)4
Skewness-1.2658958
Sum757814
Variance1218.5303
MonotonicityNot monotonic
2024-05-12T01:21:31.766635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4216
42.2%
0 1033
 
10.3%
96 516
 
5.2%
97 286
 
2.9%
95 236
 
2.4%
93 154
 
1.5%
98 146
 
1.5%
89 119
 
1.2%
99 113
 
1.1%
94 107
 
1.1%
Other values (91) 3074
30.7%
ValueCountFrequency (%)
0 1033
10.3%
1 10
 
0.1%
2 20
 
0.2%
3 18
 
0.2%
4 26
 
0.3%
5 24
 
0.2%
6 21
 
0.2%
7 32
 
0.3%
8 12
 
0.1%
9 17
 
0.2%
ValueCountFrequency (%)
100 4216
42.2%
99 113
 
1.1%
98 146
 
1.5%
97 286
 
2.9%
96 516
 
5.2%
95 236
 
2.4%
94 107
 
1.1%
93 154
 
1.5%
92 90
 
0.9%
91 103
 
1.0%

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

ZEROS 

Distinct322
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.59188
Minimum0
Maximum153.4
Zeros4384
Zeros (%)43.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:32.008572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation6.7425504
Coefficient of variation (CV)1.8771647
Kurtosis96.524981
Mean3.59188
Median Absolute Deviation (MAD)0.2
Skewness6.4670709
Sum35918.8
Variance45.461986
MonotonicityNot monotonic
2024-05-12T01:21:32.437742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4384
43.8%
0.1 522
 
5.2%
0.2 142
 
1.4%
0.3 116
 
1.2%
0.4 105
 
1.1%
1.6 104
 
1.0%
5.3 99
 
1.0%
1.4 93
 
0.9%
1.8 90
 
0.9%
4.1 88
 
0.9%
Other values (312) 4257
42.6%
ValueCountFrequency (%)
0.0 4384
43.8%
0.1 522
 
5.2%
0.2 142
 
1.4%
0.3 116
 
1.2%
0.4 105
 
1.1%
0.5 61
 
0.6%
0.6 64
 
0.6%
0.7 55
 
0.5%
0.8 23
 
0.2%
0.9 87
 
0.9%
ValueCountFrequency (%)
153.4 1
< 0.1%
145.5 1
< 0.1%
141.6 1
< 0.1%
129.4 1
< 0.1%
127.1 1
< 0.1%
89.8 1
< 0.1%
80.5 1
< 0.1%
66.8 1
< 0.1%
65.6 1
< 0.1%
64.1 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.789276
Coefficient of variation (CV)0.45842317
Kurtosis0.076605405
Mean75.889
Median Absolute Deviation (MAD)4
Skewness-1.2684544
Sum758890
Variance1210.2937
MonotonicityNot monotonic
2024-05-12T01:21:32.960164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4243
42.4%
0 1014
 
10.1%
96 531
 
5.3%
97 282
 
2.8%
95 232
 
2.3%
93 163
 
1.6%
98 129
 
1.3%
89 120
 
1.2%
99 114
 
1.1%
94 102
 
1.0%
Other values (91) 3070
30.7%
ValueCountFrequency (%)
0 1014
10.1%
1 14
 
0.1%
2 23
 
0.2%
3 17
 
0.2%
4 21
 
0.2%
5 23
 
0.2%
6 17
 
0.2%
7 28
 
0.3%
8 14
 
0.1%
9 12
 
0.1%
ValueCountFrequency (%)
100 4243
42.4%
99 114
 
1.1%
98 129
 
1.3%
97 282
 
2.8%
96 531
 
5.3%
95 232
 
2.3%
94 102
 
1.0%
93 163
 
1.6%
92 70
 
0.7%
91 99
 
1.0%

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

ZEROS 

Distinct310
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.5561
Minimum0
Maximum264.2
Zeros4384
Zeros (%)43.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:33.206082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile15.8
Maximum264.2
Range264.2
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation6.9808071
Coefficient of variation (CV)1.9630514
Kurtosis240.69543
Mean3.5561
Median Absolute Deviation (MAD)0.2
Skewness9.5003182
Sum35561
Variance48.731668
MonotonicityNot monotonic
2024-05-12T01:21:33.465331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4384
43.8%
0.1 534
 
5.3%
0.2 147
 
1.5%
0.3 126
 
1.3%
0.4 118
 
1.2%
1.8 98
 
1.0%
1.6 96
 
1.0%
5.2 91
 
0.9%
5.3 86
 
0.9%
1.4 78
 
0.8%
Other values (300) 4242
42.4%
ValueCountFrequency (%)
0.0 4384
43.8%
0.1 534
 
5.3%
0.2 147
 
1.5%
0.3 126
 
1.3%
0.4 118
 
1.2%
0.5 34
 
0.3%
0.6 50
 
0.5%
0.7 56
 
0.6%
0.8 71
 
0.7%
0.9 58
 
0.6%
ValueCountFrequency (%)
264.2 1
< 0.1%
128.6 1
< 0.1%
116.6 1
< 0.1%
116.1 1
< 0.1%
115.2 1
< 0.1%
95.5 1
< 0.1%
93.9 1
< 0.1%
85.3 2
< 0.1%
80.9 1
< 0.1%
68.6 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.809567
Coefficient of variation (CV)0.45869297
Kurtosis0.070070633
Mean75.8886
Median Absolute Deviation (MAD)4
Skewness-1.2664712
Sum758886
Variance1211.706
MonotonicityNot monotonic
2024-05-12T01:21:33.974844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4257
42.6%
0 1008
 
10.1%
96 551
 
5.5%
97 281
 
2.8%
95 227
 
2.3%
93 140
 
1.4%
98 137
 
1.4%
89 125
 
1.2%
94 113
 
1.1%
99 106
 
1.1%
Other values (91) 3055
30.6%
ValueCountFrequency (%)
0 1008
10.1%
1 16
 
0.2%
2 25
 
0.2%
3 17
 
0.2%
4 16
 
0.2%
5 18
 
0.2%
6 20
 
0.2%
7 25
 
0.2%
8 22
 
0.2%
9 21
 
0.2%
ValueCountFrequency (%)
100 4257
42.6%
99 106
 
1.1%
98 137
 
1.4%
97 281
 
2.8%
96 551
 
5.5%
95 227
 
2.3%
94 113
 
1.1%
93 140
 
1.4%
92 67
 
0.7%
91 94
 
0.9%

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

ZEROS 

Distinct312
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.56177
Minimum0
Maximum253.1
Zeros4391
Zeros (%)43.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:34.221890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile15.8
Maximum253.1
Range253.1
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation7.2375237
Coefficient of variation (CV)2.032002
Kurtosis249.82035
Mean3.56177
Median Absolute Deviation (MAD)0.2
Skewness10.412218
Sum35617.7
Variance52.38175
MonotonicityNot monotonic
2024-05-12T01:21:34.481406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4391
43.9%
0.1 532
 
5.3%
0.2 142
 
1.4%
0.3 115
 
1.1%
0.4 104
 
1.0%
1.4 98
 
1.0%
5.3 95
 
0.9%
0.5 90
 
0.9%
1.6 88
 
0.9%
1.8 86
 
0.9%
Other values (302) 4259
42.6%
ValueCountFrequency (%)
0.0 4391
43.9%
0.1 532
 
5.3%
0.2 142
 
1.4%
0.3 115
 
1.1%
0.4 104
 
1.0%
0.5 90
 
0.9%
0.6 32
 
0.3%
0.7 70
 
0.7%
0.8 30
 
0.3%
0.9 72
 
0.7%
ValueCountFrequency (%)
253.1 1
< 0.1%
195.3 1
< 0.1%
175.3 1
< 0.1%
123.5 1
< 0.1%
107.7 1
< 0.1%
107.5 1
< 0.1%
91.0 1
< 0.1%
90.1 1
< 0.1%
83.1 2
< 0.1%
67.7 2
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.868604
Coefficient of variation (CV)0.46006927
Kurtosis0.04792575
Mean75.7899
Median Absolute Deviation (MAD)4
Skewness-1.2598421
Sum757899
Variance1215.8195
MonotonicityNot monotonic
2024-05-12T01:21:34.990919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4221
42.2%
0 1003
 
10.0%
96 541
 
5.4%
97 284
 
2.8%
95 228
 
2.3%
93 159
 
1.6%
98 144
 
1.4%
99 116
 
1.2%
89 115
 
1.1%
94 105
 
1.1%
Other values (91) 3084
30.8%
ValueCountFrequency (%)
0 1003
10.0%
1 23
 
0.2%
2 12
 
0.1%
3 17
 
0.2%
4 21
 
0.2%
5 22
 
0.2%
6 23
 
0.2%
7 25
 
0.2%
8 18
 
0.2%
9 28
 
0.3%
ValueCountFrequency (%)
100 4221
42.2%
99 116
 
1.2%
98 144
 
1.4%
97 284
 
2.8%
96 541
 
5.4%
95 228
 
2.3%
94 105
 
1.1%
93 159
 
1.6%
92 70
 
0.7%
91 98
 
1.0%

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

ZEROS 

Distinct309
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.5198
Minimum0
Maximum323.3
Zeros4397
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:35.231529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile15.7
Maximum323.3
Range323.3
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation7.1967335
Coefficient of variation (CV)2.0446427
Kurtosis460.69885
Mean3.5198
Median Absolute Deviation (MAD)0.2
Skewness13.612856
Sum35198
Variance51.792973
MonotonicityNot monotonic
2024-05-12T01:21:35.477969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4397
44.0%
0.1 526
 
5.3%
0.2 137
 
1.4%
0.4 128
 
1.3%
5.3 106
 
1.1%
0.3 106
 
1.1%
1.8 104
 
1.0%
1.6 89
 
0.9%
1.5 81
 
0.8%
1.4 80
 
0.8%
Other values (299) 4246
42.5%
ValueCountFrequency (%)
0.0 4397
44.0%
0.1 526
 
5.3%
0.2 137
 
1.4%
0.3 106
 
1.1%
0.4 128
 
1.3%
0.5 50
 
0.5%
0.6 51
 
0.5%
0.7 57
 
0.6%
0.8 63
 
0.6%
0.9 67
 
0.7%
ValueCountFrequency (%)
323.3 1
< 0.1%
160.1 1
< 0.1%
144.1 1
< 0.1%
138.1 1
< 0.1%
136.0 1
< 0.1%
110.7 1
< 0.1%
92.8 1
< 0.1%
77.0 1
< 0.1%
66.3 1
< 0.1%
61.3 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.863064
Coefficient of variation (CV)0.45968079
Kurtosis0.058399249
Mean75.8419
Median Absolute Deviation (MAD)4
Skewness-1.263898
Sum758419
Variance1215.4332
MonotonicityNot monotonic
2024-05-12T01:21:35.995685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4237
42.4%
0 1009
 
10.1%
96 523
 
5.2%
97 296
 
3.0%
95 235
 
2.4%
93 156
 
1.6%
98 137
 
1.4%
89 129
 
1.3%
99 121
 
1.2%
91 111
 
1.1%
Other values (91) 3046
30.5%
ValueCountFrequency (%)
0 1009
10.1%
1 17
 
0.2%
2 15
 
0.1%
3 12
 
0.1%
4 28
 
0.3%
5 25
 
0.2%
6 21
 
0.2%
7 27
 
0.3%
8 17
 
0.2%
9 14
 
0.1%
ValueCountFrequency (%)
100 4237
42.4%
99 121
 
1.2%
98 137
 
1.4%
97 296
 
3.0%
96 523
 
5.2%
95 235
 
2.4%
94 95
 
0.9%
93 156
 
1.6%
92 65
 
0.7%
91 111
 
1.1%

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

ZEROS 

Distinct309
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.54765
Minimum0
Maximum160.4
Zeros4380
Zeros (%)43.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:21:36.238079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q35.3
95-th percentile15.8
Maximum160.4
Range160.4
Interquartile range (IQR)5.3

Descriptive statistics

Standard deviation6.5630337
Coefficient of variation (CV)1.8499665
Kurtosis85.152634
Mean3.54765
Median Absolute Deviation (MAD)0.2
Skewness6.0050313
Sum35476.5
Variance43.073412
MonotonicityNot monotonic
2024-05-12T01:21:36.499315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4380
43.8%
0.1 514
 
5.1%
0.2 143
 
1.4%
0.3 131
 
1.3%
1.6 104
 
1.0%
5.3 92
 
0.9%
0.4 91
 
0.9%
1.4 81
 
0.8%
5.2 78
 
0.8%
6.7 75
 
0.8%
Other values (299) 4311
43.1%
ValueCountFrequency (%)
0.0 4380
43.8%
0.1 514
 
5.1%
0.2 143
 
1.4%
0.3 131
 
1.3%
0.4 91
 
0.9%
0.5 68
 
0.7%
0.6 53
 
0.5%
0.7 58
 
0.6%
0.8 51
 
0.5%
0.9 68
 
0.7%
ValueCountFrequency (%)
160.4 1
< 0.1%
137.6 1
< 0.1%
126.1 1
< 0.1%
103.3 1
< 0.1%
93.8 1
< 0.1%
86.9 1
< 0.1%
82.6 1
< 0.1%
76.4 1
< 0.1%
72.1 1
< 0.1%
67.0 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

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

Quantile statistics

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

Descriptive statistics

Standard deviation34.819365
Coefficient of variation (CV)0.45845538
Kurtosis0.067638256
Mean75.9493
Median Absolute Deviation (MAD)4
Skewness-1.2678423
Sum759493
Variance1212.3882
MonotonicityNot monotonic
2024-05-12T01:21:37.250948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4271
42.7%
0 1003
 
10.0%
96 521
 
5.2%
97 281
 
2.8%
95 229
 
2.3%
93 155
 
1.6%
98 138
 
1.4%
99 118
 
1.2%
91 109
 
1.1%
89 109
 
1.1%
Other values (91) 3066
30.7%
ValueCountFrequency (%)
0 1003
10.0%
1 12
 
0.1%
2 18
 
0.2%
3 13
 
0.1%
4 25
 
0.2%
5 21
 
0.2%
6 22
 
0.2%
7 23
 
0.2%
8 19
 
0.2%
9 21
 
0.2%
ValueCountFrequency (%)
100 4271
42.7%
99 118
 
1.2%
98 138
 
1.4%
97 281
 
2.8%
96 521
 
5.2%
95 229
 
2.3%
94 107
 
1.1%
93 155
 
1.6%
92 76
 
0.8%
91 109
 
1.1%

등록 일시
Date

Distinct8808
Distinct (%)88.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-10-30 00:04:32
Maximum2023-11-05 23:55:14
2024-05-12T01:21:37.488644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:21:37.733356image/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 (%)등록 일시
38814금천구329KCN-1096831011514.9816.1806.2816.0816.4817.1812023-11-03 21:06:04
49246금천구329KCN-13928310164125.69125.28918.79022.88913.79112.1902023-11-05 04:35:46
41486금천구329KCN-1036831011803.11003.21003.2973.11003.21003.21002023-11-04 05:06:02
43417금천구329KCN-121183101903.3883.4883.3883.4883.3873.4852023-11-04 10:55:32
39037금천구329KCN-134383101410.0990.0990.0170.0180.0180.0232023-11-03 21:45:47
34416금천구329KCN-142783101100.0970.0970.0970.0970.0960.0962023-11-03 07:55:33
39121금천구329KCN-127783101200.01000.01000.01000.01000.01000.01002023-11-03 22:05:39
35497금천구329KCN-1272831011910.0360.0310.0510.0510.0360.002023-11-03 11:15:47
35324금천구329KCN-12758310119017.910017.910018.010017.910017.910017.91002023-11-03 10:36:02
22282금천구329KCN-120383101311.41001.41001.41001.41001.4361.4372023-11-01 19:15:46
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
19265금천구329KCN-1072831011200.0910.0950.0960.0970.0950.0822023-11-01 10:05:32
26515금천구329KCN-136383101800.1950.1950.1950.1960.11000.1972023-11-02 08:05:47
2518금천구329KCN-1145831017610.203.5013.100.305.8010.102023-10-30 07:35:39
45706금천구329KCN-1175831012500.01000.01000.01000.01000.01000.01002023-11-04 17:55:44
25567금천구329KCN-1065831011200.21000.21000.21000.21000.21000.21002023-11-02 05:15:02
47415금천구329KCN-1391831016500.0870.0850.0850.0850.0850.0852023-11-04 22:56:04
43532금천구329KCN-111883101700.0850.0860.0850.0850.0850.0842023-11-04 11:15:36
52026금천구329KCN-11648310120013.38813.38813.27613.27213.26713.1722023-11-05 11:16:09
38176금천구329KCN-1218831017313.906.605.81004.11006.71005.61002023-11-03 19:15:34
13162금천구329KCN-1237831013618.310010.110013.61009.81009.91008.41002023-10-31 15:54:22

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-100183101400.11000.11000.11000.11000.11000.11002023-11-05 07:58:312
1금천구329KCN-107783201404.71004.71004.81004.71004.81004.71002023-11-01 02:37:072