Overview

Dataset statistics

Number of variables23
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows3
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 3 (< 0.1%) duplicate rowsDuplicates
사용자관리그룹 is highly imbalanced (69.0%)Imbalance
알림단계등급 is highly imbalanced (93.7%)Imbalance
활동수치 (%) has 494 (4.9%) zerosZeros
전력량1 (Wh) has 4397 (44.0%) zerosZeros
조도1 (%) has 1123 (11.2%) zerosZeros
전력량2 (Wh) has 4437 (44.4%) zerosZeros
조도2 (%) has 1148 (11.5%) zerosZeros
전력량3 (Wh) has 4436 (44.4%) zerosZeros
조도3 (%) has 1150 (11.5%) zerosZeros
전력량4 (Wh) has 4429 (44.3%) zerosZeros
조도4 (%) has 1153 (11.5%) zerosZeros
전력량5 (Wh) has 4437 (44.4%) zerosZeros
조도5 (%) has 1141 (11.4%) zerosZeros
전력량6 (Wh) has 4437 (44.4%) zerosZeros
조도6 (%) has 1146 (11.5%) zerosZeros

Reproduction

Analysis started2024-05-11 03:02:29.010858
Analysis finished2024-05-11 03:02:30.325881
Duration1.32 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-11T03:02:30.668054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:31.043477image/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-11T03:02:31.543353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:31.890836image/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-11T03:02:32.273754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:32.615038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
29 10000
100.0%

시리얼
Text

Distinct348
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-11T03:02:33.405915image/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

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowKCN-1339
2nd rowKCN-1086
3rd rowKCN-1168
4th rowKCN-1389
5th rowKCN-1373
ValueCountFrequency (%)
kcn-1076 45
 
0.4%
kcn-1222 45
 
0.4%
kcn-1336 44
 
0.4%
kcn-1380 43
 
0.4%
kcn-1187 43
 
0.4%
kcn-1081 43
 
0.4%
kcn-1020 42
 
0.4%
kcn-1400 41
 
0.4%
kcn-1341 41
 
0.4%
kcn-1204 41
 
0.4%
Other values (338) 9572
95.7%
2024-05-11T03:02:34.905927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 14054
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4517
 
5.6%
3 4476
 
5.6%
0 4350
 
5.4%
4 2784
 
3.5%
7 2073
 
2.6%
Other values (4) 7746
9.7%

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 14054
35.1%
2 4517
 
11.3%
3 4476
 
11.2%
0 4350
 
10.9%
4 2784
 
7.0%
7 2073
 
5.2%
9 2052
 
5.1%
5 2011
 
5.0%
6 1910
 
4.8%
8 1773
 
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 14054
28.1%
- 10000
20.0%
2 4517
 
9.0%
3 4476
 
9.0%
0 4350
 
8.7%
4 2784
 
5.6%
7 2073
 
4.1%
9 2052
 
4.1%
5 2011
 
4.0%
6 1910
 
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 14054
17.6%
K 10000
12.5%
C 10000
12.5%
N 10000
12.5%
- 10000
12.5%
2 4517
 
5.6%
3 4476
 
5.6%
0 4350
 
5.4%
4 2784
 
3.5%
7 2073
 
2.6%
Other values (4) 7746
9.7%

명령어
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-11T03:02:35.498406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:35.845522image/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
8962 
2
 
631
0
 
252
3
 
155

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 8962
89.6%
2 631
 
6.3%
0 252
 
2.5%
3 155
 
1.6%

Length

2024-05-11T03:02:36.259552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:36.675779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 8962
89.6%
2 631
 
6.3%
0 252
 
2.5%
3 155
 
1.6%

알림단계등급
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
9859 
1
 
76
3
 
47
2
 
18

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 9859
98.6%
1 76
 
0.8%
3 47
 
0.5%
2 18
 
0.2%

Length

2024-05-11T03:02:37.125336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:37.519736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 9859
98.6%
1 76
 
0.8%
3 47
 
0.5%
2 18
 
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-11T03:02:37.982075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:38.468510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

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

ZEROS 

Distinct106
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.6091
Minimum0
Maximum107
Zeros494
Zeros (%)4.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:38.922630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q17
median13
Q321
95-th percentile69
Maximum107
Range107
Interquartile range (IQR)14

Descriptive statistics

Standard deviation19.733855
Coefficient of variation (CV)1.0604411
Kurtosis3.6223201
Mean18.6091
Median Absolute Deviation (MAD)7
Skewness1.9880121
Sum186091
Variance389.42504
MonotonicityNot monotonic
2024-05-11T03:02:39.544829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 494
 
4.9%
10 446
 
4.5%
8 434
 
4.3%
7 428
 
4.3%
9 422
 
4.2%
11 403
 
4.0%
3 392
 
3.9%
5 373
 
3.7%
13 368
 
3.7%
12 368
 
3.7%
Other values (96) 5872
58.7%
ValueCountFrequency (%)
0 494
4.9%
1 314
3.1%
2 248
2.5%
3 392
3.9%
4 305
3.0%
5 373
3.7%
6 359
3.6%
7 428
4.3%
8 434
4.3%
9 422
4.2%
ValueCountFrequency (%)
107 1
 
< 0.1%
105 1
 
< 0.1%
104 2
 
< 0.1%
103 4
< 0.1%
101 2
 
< 0.1%
100 7
0.1%
99 4
< 0.1%
98 6
0.1%
97 2
 
< 0.1%
96 5
0.1%

최근활동
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 6778
67.8%
1 3222
32.2%

Length

2024-05-11T03:02:40.044748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T03:02:40.399981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 6778
67.8%
1 3222
32.2%

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

ZEROS 

Distinct324
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.37853
Minimum0
Maximum303.1
Zeros4397
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:41.066988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile15.6
Maximum303.1
Range303.1
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation7.2069415
Coefficient of variation (CV)2.133159
Kurtosis348.48488
Mean3.37853
Median Absolute Deviation (MAD)0.1
Skewness11.602852
Sum33785.3
Variance51.940006
MonotonicityNot monotonic
2024-05-11T03:02:41.761094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4397
44.0%
0.1 615
 
6.2%
0.2 216
 
2.2%
0.3 216
 
2.2%
5.2 103
 
1.0%
1.5 93
 
0.9%
1.4 89
 
0.9%
4.0 86
 
0.9%
4.1 84
 
0.8%
6.7 84
 
0.8%
Other values (314) 4017
40.2%
ValueCountFrequency (%)
0.0 4397
44.0%
0.1 615
 
6.2%
0.2 216
 
2.2%
0.3 216
 
2.2%
0.4 62
 
0.6%
0.5 47
 
0.5%
0.6 45
 
0.4%
0.7 68
 
0.7%
0.8 77
 
0.8%
0.9 34
 
0.3%
ValueCountFrequency (%)
303.1 1
< 0.1%
141.3 1
< 0.1%
138.6 1
< 0.1%
113.4 1
< 0.1%
101.8 1
< 0.1%
93.6 1
< 0.1%
85.6 1
< 0.1%
84.8 1
< 0.1%
76.2 1
< 0.1%
75.4 1
< 0.1%

조도1 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.3738
Minimum0
Maximum100
Zeros1123
Zeros (%)11.2%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:42.387198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation35.716787
Coefficient of variation (CV)0.48023345
Kurtosis-0.20090888
Mean74.3738
Median Absolute Deviation (MAD)4
Skewness-1.1714296
Sum743738
Variance1275.6888
MonotonicityNot monotonic
2024-05-11T03:02:42.991659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4048
40.5%
0 1123
 
11.2%
96 547
 
5.5%
97 327
 
3.3%
95 225
 
2.2%
93 157
 
1.6%
98 127
 
1.3%
89 115
 
1.1%
91 102
 
1.0%
94 102
 
1.0%
Other values (91) 3127
31.3%
ValueCountFrequency (%)
0 1123
11.2%
1 13
 
0.1%
2 21
 
0.2%
3 10
 
0.1%
4 19
 
0.2%
5 12
 
0.1%
6 19
 
0.2%
7 21
 
0.2%
8 14
 
0.1%
9 24
 
0.2%
ValueCountFrequency (%)
100 4048
40.5%
99 89
 
0.9%
98 127
 
1.3%
97 327
 
3.3%
96 547
 
5.5%
95 225
 
2.2%
94 102
 
1.0%
93 157
 
1.6%
92 81
 
0.8%
91 102
 
1.0%

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

ZEROS 

Distinct329
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.40784
Minimum0
Maximum205.1
Zeros4437
Zeros (%)44.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:43.465691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.1
95-th percentile16
Maximum205.1
Range205.1
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation6.8113589
Coefficient of variation (CV)1.998732
Kurtosis139.14849
Mean3.40784
Median Absolute Deviation (MAD)0.1
Skewness7.5134273
Sum34078.4
Variance46.39461
MonotonicityNot monotonic
2024-05-11T03:02:44.053945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 593
 
5.9%
0.3 198
 
2.0%
0.2 154
 
1.5%
0.4 111
 
1.1%
4.1 108
 
1.1%
0.9 106
 
1.1%
1.6 103
 
1.0%
6.7 92
 
0.9%
5.3 87
 
0.9%
Other values (319) 4011
40.1%
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 593
 
5.9%
0.2 154
 
1.5%
0.3 198
 
2.0%
0.4 111
 
1.1%
0.5 47
 
0.5%
0.6 56
 
0.6%
0.7 47
 
0.5%
0.8 16
 
0.2%
0.9 106
 
1.1%
ValueCountFrequency (%)
205.1 1
< 0.1%
167.3 1
< 0.1%
107.8 1
< 0.1%
105.0 1
< 0.1%
103.4 1
< 0.1%
93.0 1
< 0.1%
81.8 1
< 0.1%
74.1 1
< 0.1%
67.3 1
< 0.1%
66.7 1
< 0.1%

조도2 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.1431
Minimum0
Maximum100
Zeros1148
Zeros (%)11.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:44.516466image/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.887382
Coefficient of variation (CV)0.48402862
Kurtosis-0.2277894
Mean74.1431
Median Absolute Deviation (MAD)4
Skewness-1.1621278
Sum741431
Variance1287.9042
MonotonicityNot monotonic
2024-05-11T03:02:45.024161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4019
40.2%
0 1148
 
11.5%
96 553
 
5.5%
97 333
 
3.3%
95 225
 
2.2%
93 178
 
1.8%
98 125
 
1.2%
89 111
 
1.1%
91 97
 
1.0%
94 95
 
0.9%
Other values (91) 3116
31.2%
ValueCountFrequency (%)
0 1148
11.5%
1 14
 
0.1%
2 27
 
0.3%
3 8
 
0.1%
4 24
 
0.2%
5 26
 
0.3%
6 14
 
0.1%
7 22
 
0.2%
8 19
 
0.2%
9 26
 
0.3%
ValueCountFrequency (%)
100 4019
40.2%
99 88
 
0.9%
98 125
 
1.2%
97 333
 
3.3%
96 553
 
5.5%
95 225
 
2.2%
94 95
 
0.9%
93 178
 
1.8%
92 70
 
0.7%
91 97
 
1.0%

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

ZEROS 

Distinct336
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.45504
Minimum0
Maximum206.7
Zeros4436
Zeros (%)44.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:45.454619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.2
95-th percentile15.9
Maximum206.7
Range206.7
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation7.2233819
Coefficient of variation (CV)2.0906797
Kurtosis177.01247
Mean3.45504
Median Absolute Deviation (MAD)0.1
Skewness8.9344083
Sum34550.4
Variance52.177246
MonotonicityNot monotonic
2024-05-11T03:02:45.980632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4436
44.4%
0.1 581
 
5.8%
0.3 176
 
1.8%
0.2 161
 
1.6%
0.4 154
 
1.5%
4.1 113
 
1.1%
1.8 107
 
1.1%
1.4 100
 
1.0%
5.9 86
 
0.9%
5.3 81
 
0.8%
Other values (326) 4005
40.1%
ValueCountFrequency (%)
0.0 4436
44.4%
0.1 581
 
5.8%
0.2 161
 
1.6%
0.3 176
 
1.8%
0.4 154
 
1.5%
0.5 24
 
0.2%
0.6 41
 
0.4%
0.7 53
 
0.5%
0.8 57
 
0.6%
0.9 78
 
0.8%
ValueCountFrequency (%)
206.7 1
< 0.1%
205.6 1
< 0.1%
160.9 1
< 0.1%
120.1 1
< 0.1%
107.4 1
< 0.1%
106.7 1
< 0.1%
102.3 1
< 0.1%
95.3 1
< 0.1%
81.8 1
< 0.1%
81.0 1
< 0.1%

조도3 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.1135
Minimum0
Maximum100
Zeros1150
Zeros (%)11.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:46.405768image/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.963278
Coefficient of variation (CV)0.48524598
Kurtosis-0.24481518
Mean74.1135
Median Absolute Deviation (MAD)4
Skewness-1.1579522
Sum741135
Variance1293.3574
MonotonicityNot monotonic
2024-05-11T03:02:47.024557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4026
40.3%
0 1150
 
11.5%
96 568
 
5.7%
97 338
 
3.4%
95 211
 
2.1%
93 164
 
1.6%
98 126
 
1.3%
89 111
 
1.1%
91 97
 
1.0%
94 97
 
1.0%
Other values (91) 3112
31.1%
ValueCountFrequency (%)
0 1150
11.5%
1 10
 
0.1%
2 28
 
0.3%
3 15
 
0.1%
4 12
 
0.1%
5 25
 
0.2%
6 19
 
0.2%
7 22
 
0.2%
8 13
 
0.1%
9 27
 
0.3%
ValueCountFrequency (%)
100 4026
40.3%
99 91
 
0.9%
98 126
 
1.3%
97 338
 
3.4%
96 568
 
5.7%
95 211
 
2.1%
94 97
 
1.0%
93 164
 
1.6%
92 79
 
0.8%
91 97
 
1.0%

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

ZEROS 

Distinct326
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.44302
Minimum0
Maximum327.1
Zeros4429
Zeros (%)44.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:47.530742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.2
95-th percentile15.7
Maximum327.1
Range327.1
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation7.590902
Coefficient of variation (CV)2.204722
Kurtosis425.98558
Mean3.44302
Median Absolute Deviation (MAD)0.1
Skewness13.510384
Sum34430.2
Variance57.621793
MonotonicityNot monotonic
2024-05-11T03:02:48.052361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4429
44.3%
0.1 578
 
5.8%
0.3 211
 
2.1%
0.2 165
 
1.7%
4.1 102
 
1.0%
1.6 96
 
1.0%
1.4 92
 
0.9%
0.4 91
 
0.9%
1.5 91
 
0.9%
0.9 81
 
0.8%
Other values (316) 4064
40.6%
ValueCountFrequency (%)
0.0 4429
44.3%
0.1 578
 
5.8%
0.2 165
 
1.7%
0.3 211
 
2.1%
0.4 91
 
0.9%
0.5 72
 
0.7%
0.6 36
 
0.4%
0.7 53
 
0.5%
0.8 40
 
0.4%
0.9 81
 
0.8%
ValueCountFrequency (%)
327.1 1
< 0.1%
205.9 1
< 0.1%
171.9 1
< 0.1%
109.5 1
< 0.1%
96.6 1
< 0.1%
93.0 1
< 0.1%
92.9 1
< 0.1%
92.8 1
< 0.1%
91.2 1
< 0.1%
88.4 1
< 0.1%

조도4 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.2142
Minimum0
Maximum100
Zeros1153
Zeros (%)11.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:48.563587image/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.950468
Coefficient of variation (CV)0.48441495
Kurtosis-0.22921594
Mean74.2142
Median Absolute Deviation (MAD)4
Skewness-1.1644033
Sum742142
Variance1292.4362
MonotonicityNot monotonic
2024-05-11T03:02:49.338662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4052
40.5%
0 1153
 
11.5%
96 548
 
5.5%
97 340
 
3.4%
95 231
 
2.3%
93 164
 
1.6%
98 130
 
1.3%
89 112
 
1.1%
91 97
 
1.0%
94 92
 
0.9%
Other values (91) 3081
30.8%
ValueCountFrequency (%)
0 1153
11.5%
1 15
 
0.1%
2 16
 
0.2%
3 15
 
0.1%
4 23
 
0.2%
5 24
 
0.2%
6 10
 
0.1%
7 14
 
0.1%
8 19
 
0.2%
9 37
 
0.4%
ValueCountFrequency (%)
100 4052
40.5%
99 89
 
0.9%
98 130
 
1.3%
97 340
 
3.4%
96 548
 
5.5%
95 231
 
2.3%
94 92
 
0.9%
93 164
 
1.6%
92 67
 
0.7%
91 97
 
1.0%

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

ZEROS 

Distinct331
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.43478
Minimum0
Maximum242.5
Zeros4437
Zeros (%)44.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:49.914699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.2
95-th percentile15.7
Maximum242.5
Range242.5
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation7.1154853
Coefficient of variation (CV)2.0715986
Kurtosis195.72268
Mean3.43478
Median Absolute Deviation (MAD)0.1
Skewness9.0465649
Sum34347.8
Variance50.630131
MonotonicityNot monotonic
2024-05-11T03:02:50.515798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 567
 
5.7%
0.3 176
 
1.8%
0.2 162
 
1.6%
0.4 143
 
1.4%
4.1 101
 
1.0%
1.8 100
 
1.0%
1.5 99
 
1.0%
0.9 92
 
0.9%
1.4 86
 
0.9%
Other values (321) 4037
40.4%
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 567
 
5.7%
0.2 162
 
1.6%
0.3 176
 
1.8%
0.4 143
 
1.4%
0.5 36
 
0.4%
0.6 36
 
0.4%
0.7 70
 
0.7%
0.8 27
 
0.3%
0.9 92
 
0.9%
ValueCountFrequency (%)
242.5 1
< 0.1%
158.5 1
< 0.1%
150.7 1
< 0.1%
113.0 1
< 0.1%
111.0 1
< 0.1%
102.4 1
< 0.1%
92.6 1
< 0.1%
90.8 1
< 0.1%
76.4 1
< 0.1%
74.9 1
< 0.1%

조도5 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.2286
Minimum0
Maximum100
Zeros1141
Zeros (%)11.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:51.419237image/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.95804
Coefficient of variation (CV)0.48442299
Kurtosis-0.23003931
Mean74.2286
Median Absolute Deviation (MAD)4
Skewness-1.1645832
Sum742286
Variance1292.9806
MonotonicityNot monotonic
2024-05-11T03:02:51.976145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4067
40.7%
0 1141
 
11.4%
96 553
 
5.5%
97 320
 
3.2%
95 227
 
2.3%
93 168
 
1.7%
98 134
 
1.3%
91 115
 
1.1%
94 101
 
1.0%
89 96
 
1.0%
Other values (91) 3078
30.8%
ValueCountFrequency (%)
0 1141
11.4%
1 18
 
0.2%
2 27
 
0.3%
3 14
 
0.1%
4 22
 
0.2%
5 20
 
0.2%
6 11
 
0.1%
7 27
 
0.3%
8 17
 
0.2%
9 32
 
0.3%
ValueCountFrequency (%)
100 4067
40.7%
99 88
 
0.9%
98 134
 
1.3%
97 320
 
3.2%
96 553
 
5.5%
95 227
 
2.3%
94 101
 
1.0%
93 168
 
1.7%
92 64
 
0.6%
91 115
 
1.1%

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

ZEROS 

Distinct321
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.41681
Minimum0
Maximum238.5
Zeros4437
Zeros (%)44.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:52.464934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.1
Q35.2
95-th percentile15.6
Maximum238.5
Range238.5
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation7.310206
Coefficient of variation (CV)2.1394827
Kurtosis251.54557
Mean3.41681
Median Absolute Deviation (MAD)0.1
Skewness10.883106
Sum34168.1
Variance53.439112
MonotonicityNot monotonic
2024-05-11T03:02:53.092448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 569
 
5.7%
0.3 181
 
1.8%
0.2 162
 
1.6%
0.4 130
 
1.3%
1.4 99
 
1.0%
4.1 91
 
0.9%
1.6 86
 
0.9%
5.8 77
 
0.8%
5.9 76
 
0.8%
Other values (311) 4092
40.9%
ValueCountFrequency (%)
0.0 4437
44.4%
0.1 569
 
5.7%
0.2 162
 
1.6%
0.3 181
 
1.8%
0.4 130
 
1.3%
0.5 49
 
0.5%
0.6 48
 
0.5%
0.7 46
 
0.5%
0.8 57
 
0.6%
0.9 68
 
0.7%
ValueCountFrequency (%)
238.5 1
< 0.1%
198.5 1
< 0.1%
184.6 1
< 0.1%
179.4 1
< 0.1%
115.3 1
< 0.1%
110.7 1
< 0.1%
107.3 1
< 0.1%
101.3 1
< 0.1%
87.1 1
< 0.1%
68.5 1
< 0.1%

조도6 (%)
Real number (ℝ)

ZEROS 

Distinct101
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74.2513
Minimum0
Maximum100
Zeros1146
Zeros (%)11.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T03:02:53.789468image/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.957962
Coefficient of variation (CV)0.48427384
Kurtosis-0.2319023
Mean74.2513
Median Absolute Deviation (MAD)4
Skewness-1.1636525
Sum742513
Variance1292.975
MonotonicityNot monotonic
2024-05-11T03:02:54.266058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100 4075
40.8%
0 1146
 
11.5%
96 546
 
5.5%
97 338
 
3.4%
95 237
 
2.4%
93 168
 
1.7%
98 136
 
1.4%
89 95
 
0.9%
94 89
 
0.9%
99 89
 
0.9%
Other values (91) 3081
30.8%
ValueCountFrequency (%)
0 1146
11.5%
1 22
 
0.2%
2 18
 
0.2%
3 14
 
0.1%
4 21
 
0.2%
5 15
 
0.1%
6 17
 
0.2%
7 21
 
0.2%
8 21
 
0.2%
9 25
 
0.2%
ValueCountFrequency (%)
100 4075
40.8%
99 89
 
0.9%
98 136
 
1.4%
97 338
 
3.4%
96 546
 
5.5%
95 237
 
2.4%
94 89
 
0.9%
93 168
 
1.7%
92 73
 
0.7%
91 89
 
0.9%

등록 일시
Date

Distinct8680
Distinct (%)86.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-10-24 10:45:18
Maximum2023-10-29 23:54:37
2024-05-11T03:02:54.849604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T03:02:55.316188image/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 (%)등록 일시
51509금천구329KCN-133983101100.01000.01000.01000.01000.01000.01002023-10-29 21:24:31
45044금천구329KCN-1086831011810.11000.11000.11000.11000.11000.11002023-10-29 02:50:02
36826금천구329KCN-1168831016014.31004.21000.11005.61004.11000.11002023-10-28 01:55:17
51043금천구329KCN-1389831011107.4567.4567.3567.3567.2557.5562023-10-29 19:54:32
47918금천구329KCN-1373831013023.29524.19524.39524.19424.19224.2912023-10-29 10:35:26
19627금천구329KCN-10098310122010.94611.04710.94710.94710.94711.0472023-10-25 21:54:20
33162금천구329KCN-1231831011510.000.000.000.000.006.702023-10-27 14:44:47
48714금천구329KCN-111883101900.0910.0910.0850.0860.0860.0892023-10-29 12:54:36
16130금천구329KCN-140283101612.3582.3472.302.3372.452.302023-10-25 11:14:29
22661금천구329KCN-1062831011900.01000.01000.01000.01000.01000.01002023-10-26 06:55:32
기관명모델명패킷길이시리얼명령어사용자관리그룹알림단계등급기기상태정보활동수치 (%)최근활동전력량1 (Wh)조도1 (%)전력량2 (Wh)조도2 (%)전력량3 (Wh)조도3 (%)전력량4 (Wh)조도4 (%)전력량5 (Wh)조도5 (%)전력량6 (Wh)조도6 (%)등록 일시
27995금천구329KCN-1138831011300.01000.01000.01000.01000.01000.01002023-10-26 23:04:41
10023금천구329KCN-1116831011104.0934.1884.1954.2894.0944.2942023-10-24 16:34:21
47297금천구329KCN-1218831017016.51004.31004.71006.41005.11004.01002023-10-29 08:35:01
18991금천구329KCN-1028831011200.0820.0820.0820.0830.0820.0812023-10-25 19:54:34
18564금천구329KCN-1123831011704.51004.51004.51004.51004.51004.61002023-10-25 18:35:40
15734금천구329KCN-1403831011308.7598.7498.7448.7218.698.7142023-10-25 09:55:37
13475금천구329KCN-11288310113128.51728.42014.31002.51002.51002.51002023-10-25 03:05:29
44849금천구329KCN-1173831014517.01007.01002.21000.21000.21000.21002023-10-29 02:15:56
29717금천구329KCN-136383101700.11000.11000.11000.11000.11000.11002023-10-27 04:15:33
16664금천구329KCN-1388831011100.030.0150.000.000.000.002023-10-25 12:45:42

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-1056832011100.01000.01000.01000.01000.01000.01002023-10-29 06:23:332
1금천구329KCN-1209831012400.11000.11000.11000.11000.11000.11002023-10-29 06:23:162
2금천구329KCN-137683101700.7960.6960.7960.7960.7960.7962023-10-29 06:10:242