Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows8
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 8 (0.1%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (68.6%)Imbalance
알림단계등급 is highly imbalanced (93.2%)Imbalance
활동수치 (%) has 530 (5.3%) zerosZeros
전력량1 (Wh) has 4367 (43.7%) zerosZeros
조도1 (%) has 1114 (11.1%) zerosZeros
전력량2 (Wh) has 4457 (44.6%) zerosZeros
조도2 (%) has 1127 (11.3%) zerosZeros
전력량3 (Wh) has 4414 (44.1%) zerosZeros
조도3 (%) has 1142 (11.4%) zerosZeros
전력량4 (Wh) has 4432 (44.3%) zerosZeros
조도4 (%) has 1133 (11.3%) zerosZeros
전력량5 (Wh) has 4438 (44.4%) zerosZeros
조도5 (%) has 1159 (11.6%) zerosZeros
전력량6 (Wh) has 4450 (44.5%) zerosZeros
조도6 (%) has 1166 (11.7%) zerosZeros

Reproduction

Analysis started2024-05-11 16:20:09.666893
Analysis finished2024-05-11 16:20:10.966573
Duration1.3 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관명
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row금천구
2nd row금천구
3rd row금천구
4th row금천구
5th row금천구

Common Values

ValueCountFrequency (%)
금천구 10000
100.0%

Length

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

시리얼
Text

Distinct349
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-12T01:20:12.971272image/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-1408
2nd rowKCN-1412
3rd rowKCN-1346
4th rowKCN-1079
5th rowKCN-1275
ValueCountFrequency (%)
kcn-1373 47
 
0.5%
kcn-1033 43
 
0.4%
kcn-1055 42
 
0.4%
kcn-1168 41
 
0.4%
kcn-1079 41
 
0.4%
kcn-1371 41
 
0.4%
kcn-1198 41
 
0.4%
kcn-1007 41
 
0.4%
kcn-1348 41
 
0.4%
kcn-1330 40
 
0.4%
Other values (339) 9582
95.8%
2024-05-12T01:20:14.256629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14110
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
3 4545
 
5.7%
2 4463
 
5.6%
0 4338
 
5.4%
4 2763
 
3.5%
7 2110
 
2.6%
Other values (4) 7671
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 14110
35.3%
3 4545
 
11.4%
2 4463
 
11.2%
0 4338
 
10.8%
4 2763
 
6.9%
7 2110
 
5.3%
9 2090
 
5.2%
5 1930
 
4.8%
6 1891
 
4.7%
8 1760
 
4.4%
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 14110
28.2%
- 10000
20.0%
3 4545
 
9.1%
2 4463
 
8.9%
0 4338
 
8.7%
4 2763
 
5.5%
7 2110
 
4.2%
9 2090
 
4.2%
5 1930
 
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 14110
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
3 4545
 
5.7%
2 4463
 
5.6%
0 4338
 
5.4%
4 2763
 
3.5%
7 2110
 
2.6%
Other values (4) 7671
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:14.484389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:20:14.639139image/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
8949 
2
 
619
0
 
273
3
 
159

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 8949
89.5%
2 619
 
6.2%
0 273
 
2.7%
3 159
 
1.6%

Length

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

Common Values (Plot)

2024-05-12T01:20:14.969484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8949
89.5%
2 619
 
6.2%
0 273
 
2.7%
3 159
 
1.6%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9848 
1
 
68
3
 
52
2
 
32

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 9848
98.5%
1 68
 
0.7%
3 52
 
0.5%
2 32
 
0.3%

Length

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

Common Values (Plot)

2024-05-12T01:20:15.318030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9848
98.5%
1 68
 
0.7%
3 52
 
0.5%
2 32
 
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:20:15.497498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

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

ZEROS 

Distinct118
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.0145
Minimum0
Maximum123
Zeros530
Zeros (%)5.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:15.842172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16
median13
Q322
95-th percentile68
Maximum123
Range123
Interquartile range (IQR)16

Descriptive statistics

Standard deviation21.101901
Coefficient of variation (CV)1.1097794
Kurtosis5.072576
Mean19.0145
Median Absolute Deviation (MAD)7
Skewness2.2207593
Sum190145
Variance445.29022
MonotonicityNot monotonic
2024-05-12T01:20:16.104722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 530
 
5.3%
9 451
 
4.5%
12 433
 
4.3%
10 416
 
4.2%
14 398
 
4.0%
4 394
 
3.9%
11 393
 
3.9%
13 387
 
3.9%
8 385
 
3.9%
7 357
 
3.6%
Other values (108) 5856
58.6%
ValueCountFrequency (%)
0 530
5.3%
1 289
2.9%
2 286
2.9%
3 356
3.6%
4 394
3.9%
5 348
3.5%
6 327
3.3%
7 357
3.6%
8 385
3.9%
9 451
4.5%
ValueCountFrequency (%)
123 2
 
< 0.1%
122 1
 
< 0.1%
120 1
 
< 0.1%
117 5
 
0.1%
115 3
 
< 0.1%
114 6
0.1%
113 10
0.1%
112 14
0.1%
111 6
0.1%
110 10
0.1%

최근활동
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 7017
70.2%
1 2983
29.8%

Length

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

Common Values (Plot)

2024-05-12T01:20:16.499336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 7017
70.2%
1 2983
29.8%

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

ZEROS 

Distinct318
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.47964
Minimum0
Maximum148.8
Zeros4367
Zeros (%)43.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:16.817470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.925
95-th percentile15.4
Maximum148.8
Range148.8
Interquartile range (IQR)4.925

Descriptive statistics

Standard deviation7.6328133
Coefficient of variation (CV)2.1935641
Kurtosis71.540183
Mean3.47964
Median Absolute Deviation (MAD)0.1
Skewness6.5294498
Sum34796.4
Variance58.259839
MonotonicityNot monotonic
2024-05-12T01:20:17.075976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4367
43.7%
0.1 687
 
6.9%
0.2 243
 
2.4%
0.3 224
 
2.2%
1.4 97
 
1.0%
4.1 90
 
0.9%
0.8 88
 
0.9%
5.2 88
 
0.9%
1.5 87
 
0.9%
4.0 85
 
0.9%
Other values (308) 3944
39.4%
ValueCountFrequency (%)
0.0 4367
43.7%
0.1 687
 
6.9%
0.2 243
 
2.4%
0.3 224
 
2.2%
0.4 83
 
0.8%
0.5 42
 
0.4%
0.6 38
 
0.4%
0.7 77
 
0.8%
0.8 88
 
0.9%
0.9 20
 
0.2%
ValueCountFrequency (%)
148.8 1
< 0.1%
138.7 1
< 0.1%
131.8 1
< 0.1%
127.8 1
< 0.1%
106.1 1
< 0.1%
100.6 1
< 0.1%
93.9 1
< 0.1%
92.5 1
< 0.1%
91.3 1
< 0.1%
70.0 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.9226
Minimum0
Maximum100
Zeros1114
Zeros (%)11.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:17.343658image/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.818606
Coefficient of variation (CV)0.47807478
Kurtosis-0.15964993
Mean74.9226
Median Absolute Deviation (MAD)4
Skewness-1.1953158
Sum749226
Variance1282.9725
MonotonicityNot monotonic
2024-05-12T01:20:17.597122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4353
43.5%
0 1114
 
11.1%
96 461
 
4.6%
97 327
 
3.3%
95 236
 
2.4%
93 121
 
1.2%
98 113
 
1.1%
89 100
 
1.0%
90 91
 
0.9%
94 90
 
0.9%
Other values (91) 2994
29.9%
ValueCountFrequency (%)
0 1114
11.1%
1 18
 
0.2%
2 15
 
0.1%
3 14
 
0.1%
4 19
 
0.2%
5 25
 
0.2%
6 20
 
0.2%
7 25
 
0.2%
8 23
 
0.2%
9 27
 
0.3%
ValueCountFrequency (%)
100 4353
43.5%
99 87
 
0.9%
98 113
 
1.1%
97 327
 
3.3%
96 461
 
4.6%
95 236
 
2.4%
94 90
 
0.9%
93 121
 
1.2%
92 80
 
0.8%
91 89
 
0.9%

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

ZEROS 

Distinct312
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.20185
Minimum0
Maximum166.6
Zeros4457
Zeros (%)44.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:17.838019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.9
95-th percentile15
Maximum166.6
Range166.6
Interquartile range (IQR)4.9

Descriptive statistics

Standard deviation6.2252626
Coefficient of variation (CV)1.9442705
Kurtosis94.533669
Mean3.20185
Median Absolute Deviation (MAD)0.1
Skewness6.2774418
Sum32018.5
Variance38.753895
MonotonicityNot monotonic
2024-05-12T01:20:18.089232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4457
44.6%
0.1 659
 
6.6%
0.3 187
 
1.9%
0.2 174
 
1.7%
0.4 148
 
1.5%
4.1 113
 
1.1%
1.6 112
 
1.1%
0.9 99
 
1.0%
1.4 87
 
0.9%
5.9 73
 
0.7%
Other values (302) 3891
38.9%
ValueCountFrequency (%)
0.0 4457
44.6%
0.1 659
 
6.6%
0.2 174
 
1.7%
0.3 187
 
1.9%
0.4 148
 
1.5%
0.5 51
 
0.5%
0.6 44
 
0.4%
0.7 43
 
0.4%
0.8 33
 
0.3%
0.9 99
 
1.0%
ValueCountFrequency (%)
166.6 1
< 0.1%
114.3 1
< 0.1%
110.9 1
< 0.1%
103.3 1
< 0.1%
101.8 1
< 0.1%
91.1 1
< 0.1%
87.7 1
< 0.1%
67.1 1
< 0.1%
65.1 1
< 0.1%
63.0 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.8362
Minimum0
Maximum100
Zeros1127
Zeros (%)11.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:18.352063image/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.954427
Coefficient of variation (CV)0.48044165
Kurtosis-0.17675475
Mean74.8362
Median Absolute Deviation (MAD)4
Skewness-1.1910121
Sum748362
Variance1292.7208
MonotonicityNot monotonic
2024-05-12T01:20:18.603037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4355
43.5%
0 1127
 
11.3%
96 466
 
4.7%
97 314
 
3.1%
95 236
 
2.4%
93 130
 
1.3%
98 128
 
1.3%
89 102
 
1.0%
94 89
 
0.9%
99 86
 
0.9%
Other values (91) 2967
29.7%
ValueCountFrequency (%)
0 1127
11.3%
1 18
 
0.2%
2 23
 
0.2%
3 16
 
0.2%
4 28
 
0.3%
5 22
 
0.2%
6 16
 
0.2%
7 27
 
0.3%
8 29
 
0.3%
9 23
 
0.2%
ValueCountFrequency (%)
100 4355
43.5%
99 86
 
0.9%
98 128
 
1.3%
97 314
 
3.1%
96 466
 
4.7%
95 236
 
2.4%
94 89
 
0.9%
93 130
 
1.3%
92 82
 
0.8%
91 86
 
0.9%

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

ZEROS 

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

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.9
95-th percentile15
Maximum184.6
Range184.6
Interquartile range (IQR)4.9

Descriptive statistics

Standard deviation6.6878512
Coefficient of variation (CV)2.0382954
Kurtosis138.82534
Mean3.2811
Median Absolute Deviation (MAD)0.1
Skewness7.7112097
Sum32811
Variance44.727354
MonotonicityNot monotonic
2024-05-12T01:20:19.246029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4414
44.1%
0.1 676
 
6.8%
0.2 196
 
2.0%
0.3 181
 
1.8%
0.4 145
 
1.5%
1.4 104
 
1.0%
4.1 104
 
1.0%
1.8 98
 
1.0%
1.5 88
 
0.9%
0.9 88
 
0.9%
Other values (304) 3906
39.1%
ValueCountFrequency (%)
0.0 4414
44.1%
0.1 676
 
6.8%
0.2 196
 
2.0%
0.3 181
 
1.8%
0.4 145
 
1.5%
0.5 45
 
0.4%
0.6 43
 
0.4%
0.7 43
 
0.4%
0.8 47
 
0.5%
0.9 88
 
0.9%
ValueCountFrequency (%)
184.6 1
< 0.1%
178.3 1
< 0.1%
135.5 1
< 0.1%
99.4 1
< 0.1%
96.1 1
< 0.1%
83.3 1
< 0.1%
81.1 1
< 0.1%
74.0 1
< 0.1%
67.6 1
< 0.1%
67.4 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.5236
Minimum0
Maximum100
Zeros1142
Zeros (%)11.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:19.683198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation36.078456
Coefficient of variation (CV)0.48412122
Kurtosis-0.2315415
Mean74.5236
Median Absolute Deviation (MAD)4
Skewness-1.1690024
Sum745236
Variance1301.655
MonotonicityNot monotonic
2024-05-12T01:20:20.116327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4317
43.2%
0 1142
 
11.4%
96 458
 
4.6%
97 313
 
3.1%
95 236
 
2.4%
93 127
 
1.3%
89 124
 
1.2%
98 118
 
1.2%
91 103
 
1.0%
99 99
 
1.0%
Other values (91) 2963
29.6%
ValueCountFrequency (%)
0 1142
11.4%
1 15
 
0.1%
2 20
 
0.2%
3 15
 
0.1%
4 22
 
0.2%
5 28
 
0.3%
6 16
 
0.2%
7 25
 
0.2%
8 12
 
0.1%
9 35
 
0.4%
ValueCountFrequency (%)
100 4317
43.2%
99 99
 
1.0%
98 118
 
1.2%
97 313
 
3.1%
96 458
 
4.6%
95 236
 
2.4%
94 71
 
0.7%
93 127
 
1.3%
92 76
 
0.8%
91 103
 
1.0%

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

ZEROS 

Distinct315
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.24495
Minimum0
Maximum161.3
Zeros4432
Zeros (%)44.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:20.546337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation6.3908204
Coefficient of variation (CV)1.9694665
Kurtosis89.465696
Mean3.24495
Median Absolute Deviation (MAD)0.1
Skewness6.1820757
Sum32449.5
Variance40.842585
MonotonicityNot monotonic
2024-05-12T01:20:21.000529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4432
44.3%
0.1 682
 
6.8%
0.3 191
 
1.9%
0.2 181
 
1.8%
0.4 140
 
1.4%
1.5 94
 
0.9%
4.1 93
 
0.9%
1.6 90
 
0.9%
1.4 77
 
0.8%
5.9 75
 
0.8%
Other values (305) 3945
39.5%
ValueCountFrequency (%)
0.0 4432
44.3%
0.1 682
 
6.8%
0.2 181
 
1.8%
0.3 191
 
1.9%
0.4 140
 
1.4%
0.5 65
 
0.7%
0.6 28
 
0.3%
0.7 59
 
0.6%
0.8 48
 
0.5%
0.9 71
 
0.7%
ValueCountFrequency (%)
161.3 1
< 0.1%
144.1 1
< 0.1%
110.8 1
< 0.1%
95.1 1
< 0.1%
87.4 1
< 0.1%
69.3 1
< 0.1%
69.0 1
< 0.1%
68.9 1
< 0.1%
66.0 1
< 0.1%
65.4 2
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.5693
Minimum0
Maximum100
Zeros1133
Zeros (%)11.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:21.444231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation35.968363
Coefficient of variation (CV)0.48234814
Kurtosis-0.21318778
Mean74.5693
Median Absolute Deviation (MAD)4
Skewness-1.1729344
Sum745693
Variance1293.7232
MonotonicityNot monotonic
2024-05-12T01:20:21.876350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4327
43.3%
0 1133
 
11.3%
96 457
 
4.6%
97 301
 
3.0%
95 226
 
2.3%
98 120
 
1.2%
89 116
 
1.2%
93 114
 
1.1%
90 96
 
1.0%
92 90
 
0.9%
Other values (91) 3020
30.2%
ValueCountFrequency (%)
0 1133
11.3%
1 12
 
0.1%
2 24
 
0.2%
3 14
 
0.1%
4 22
 
0.2%
5 28
 
0.3%
6 21
 
0.2%
7 30
 
0.3%
8 12
 
0.1%
9 23
 
0.2%
ValueCountFrequency (%)
100 4327
43.3%
99 87
 
0.9%
98 120
 
1.2%
97 301
 
3.0%
96 457
 
4.6%
95 226
 
2.3%
94 88
 
0.9%
93 114
 
1.1%
92 90
 
0.9%
91 80
 
0.8%

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

ZEROS 

Distinct305
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.25365
Minimum0
Maximum144.4
Zeros4438
Zeros (%)44.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:22.279524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.8
95-th percentile14.905
Maximum144.4
Range144.4
Interquartile range (IQR)4.8

Descriptive statistics

Standard deviation6.5993631
Coefficient of variation (CV)2.0282953
Kurtosis79.268808
Mean3.25365
Median Absolute Deviation (MAD)0.1
Skewness6.3569764
Sum32536.5
Variance43.551594
MonotonicityNot monotonic
2024-05-12T01:20:22.725841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4438
44.4%
0.1 684
 
6.8%
0.3 191
 
1.9%
0.2 174
 
1.7%
0.4 153
 
1.5%
4.1 99
 
1.0%
1.5 96
 
1.0%
1.8 87
 
0.9%
1.6 86
 
0.9%
0.9 85
 
0.9%
Other values (295) 3907
39.1%
ValueCountFrequency (%)
0.0 4438
44.4%
0.1 684
 
6.8%
0.2 174
 
1.7%
0.3 191
 
1.9%
0.4 153
 
1.5%
0.5 49
 
0.5%
0.6 33
 
0.3%
0.7 59
 
0.6%
0.8 43
 
0.4%
0.9 85
 
0.9%
ValueCountFrequency (%)
144.4 1
< 0.1%
111.9 1
< 0.1%
106.9 1
< 0.1%
106.1 1
< 0.1%
104.7 1
< 0.1%
104.6 1
< 0.1%
103.5 1
< 0.1%
93.8 1
< 0.1%
90.8 1
< 0.1%
89.9 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.5479
Minimum0
Maximum100
Zeros1159
Zeros (%)11.6%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:23.333301image/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 deviation36.077617
Coefficient of variation (CV)0.48395216
Kurtosis-0.21278396
Mean74.5479
Median Absolute Deviation (MAD)4
Skewness-1.1767958
Sum745479
Variance1301.5945
MonotonicityNot monotonic
2024-05-12T01:20:23.694737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4309
43.1%
0 1159
 
11.6%
96 461
 
4.6%
97 310
 
3.1%
95 234
 
2.3%
93 124
 
1.2%
98 117
 
1.2%
89 108
 
1.1%
91 94
 
0.9%
90 91
 
0.9%
Other values (91) 2993
29.9%
ValueCountFrequency (%)
0 1159
11.6%
1 19
 
0.2%
2 22
 
0.2%
3 14
 
0.1%
4 17
 
0.2%
5 31
 
0.3%
6 13
 
0.1%
7 24
 
0.2%
8 15
 
0.1%
9 18
 
0.2%
ValueCountFrequency (%)
100 4309
43.1%
99 90
 
0.9%
98 117
 
1.2%
97 310
 
3.1%
96 461
 
4.6%
95 234
 
2.3%
94 84
 
0.8%
93 124
 
1.2%
92 77
 
0.8%
91 94
 
0.9%

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

ZEROS 

Distinct306
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.20876
Minimum0
Maximum123.1
Zeros4450
Zeros (%)44.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:23.978660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q34.8
95-th percentile15.305
Maximum123.1
Range123.1
Interquartile range (IQR)4.8

Descriptive statistics

Standard deviation6.0061091
Coefficient of variation (CV)1.8717851
Kurtosis45.069313
Mean3.20876
Median Absolute Deviation (MAD)0.1
Skewness4.5325725
Sum32087.6
Variance36.073347
MonotonicityNot monotonic
2024-05-12T01:20:24.257698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4450
44.5%
0.1 677
 
6.8%
0.3 191
 
1.9%
0.2 174
 
1.7%
0.4 152
 
1.5%
4.1 103
 
1.0%
1.5 87
 
0.9%
1.6 85
 
0.9%
0.9 83
 
0.8%
1.4 83
 
0.8%
Other values (296) 3915
39.1%
ValueCountFrequency (%)
0.0 4450
44.5%
0.1 677
 
6.8%
0.2 174
 
1.7%
0.3 191
 
1.9%
0.4 152
 
1.5%
0.5 51
 
0.5%
0.6 45
 
0.4%
0.7 46
 
0.5%
0.8 49
 
0.5%
0.9 83
 
0.8%
ValueCountFrequency (%)
123.1 1
< 0.1%
101.1 1
< 0.1%
93.9 1
< 0.1%
80.9 1
< 0.1%
71.2 1
< 0.1%
70.9 1
< 0.1%
69.6 1
< 0.1%
67.4 1
< 0.1%
66.2 1
< 0.1%
62.2 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.3665
Minimum0
Maximum100
Zeros1166
Zeros (%)11.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:20:24.544253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation36.200213
Coefficient of variation (CV)0.48678119
Kurtosis-0.25652516
Mean74.3665
Median Absolute Deviation (MAD)4
Skewness-1.160104
Sum743665
Variance1310.4554
MonotonicityNot monotonic
2024-05-12T01:20:24.793523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4328
43.3%
0 1166
 
11.7%
96 443
 
4.4%
97 320
 
3.2%
95 230
 
2.3%
93 121
 
1.2%
89 118
 
1.2%
98 109
 
1.1%
91 99
 
1.0%
99 94
 
0.9%
Other values (91) 2972
29.7%
ValueCountFrequency (%)
0 1166
11.7%
1 11
 
0.1%
2 17
 
0.2%
3 14
 
0.1%
4 23
 
0.2%
5 25
 
0.2%
6 14
 
0.1%
7 32
 
0.3%
8 19
 
0.2%
9 23
 
0.2%
ValueCountFrequency (%)
100 4328
43.3%
99 94
 
0.9%
98 109
 
1.1%
97 320
 
3.2%
96 443
 
4.4%
95 230
 
2.3%
94 81
 
0.8%
93 121
 
1.2%
92 81
 
0.8%
91 99
 
1.0%

등록 일시
Date

Distinct8933
Distinct (%)89.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-10-16 00:01:53
Maximum2023-10-22 23:56:27
2024-05-12T01:20:25.033029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:20:25.280434image/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 (%)등록 일시
22272금천구329KCN-1408831012310.0950.0950.0960.0970.0972.8962023-10-18 18:12:08
22535금천구329KCN-141283101706.1936.1936.0936.1926.1926.1932023-10-18 19:02:40
21436금천구329KCN-1346831011503.0402.9413.0413.0423.0443.0422023-10-18 15:48:28
11331금천구329KCN-107983101600.1430.1450.1550.1470.1490.1472023-10-17 10:12:59
12515금천구329KCN-1275831011812.910018.910018.410018.110018.010018.01002023-10-17 14:03:10
22672금천구329KCN-137783101600.5960.6960.6960.5960.6960.6962023-10-18 19:23:02
28944금천구329KCN-1276831011810.0210.0590.0510.0360.0480.0502023-10-19 13:42:15
25금천구329KCN-1216831011305.11005.11005.11005.11005.21005.11002023-10-16 00:02:03
46297금천구329KCN-1406831011500.0970.0970.0970.0970.0970.0972023-10-21 15:25:43
23488금천구329KCN-128583101310.0990.0990.0990.0990.0380.01002023-10-18 21:52:52
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
28477금천구329KCN-1381831011300.1850.1890.1910.1870.1890.1902023-10-19 12:02:10
10472금천구329KCN-1078831012010.0945.6576.5557.9567.4904.2872023-10-17 07:32:39
29328금천구329KCN-142283101100.0280.0410.0510.0350.0220.0382023-10-19 14:32:23
18854금천구329KCN-107383101700.01000.01000.01000.01000.01000.01002023-10-18 07:54:17
34701금천구329KCN-112183101900.31000.41000.41000.31000.41000.41002023-10-20 06:05:25
5714금천구329KCN-1388831011200.0270.0350.0410.0520.0570.0652023-10-16 17:24:22
42775금천구329KCN-1361831012300.01000.01000.01000.01000.01000.01002023-10-21 05:07:57
48698금천구329KCN-1065831011700.21000.21000.21000.21000.21000.21002023-10-21 22:36:51
15904금천구329KCN-1083833011910.01000.01000.01000.01000.01000.0432023-10-18 00:01:59
57820금천구329KCN-1399831011400.0960.0970.0970.0970.0970.0972023-10-22 23:18:10

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-1005831012306.61006.61006.61006.51006.5686.5682023-10-22 06:00:292
1금천구329KCN-1056832012200.01000.01000.01000.01000.01000.01002023-10-18 03:43:502
2금천구329KCN-1071831012110.01000.01000.01000.01000.5713.9712023-10-21 05:08:132
3금천구329KCN-1156832011315.205.21005.31005.21005.31005.21002023-10-21 05:07:582
4금천구329KCN-125983101201.21001.21001.31001.21001.31001.21002023-10-21 05:07:392
5금천구329KCN-130583101300.01000.01000.01000.01000.01000.01002023-10-20 04:56:502
6금천구329KCN-1386831011217.1967.0966.9966.9965.9967.1962023-10-22 06:19:032
7금천구329KCN-139583101300.0970.0970.0970.0970.0970.0972023-10-19 05:07:052