Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)< 0.1%
Total size in memory752.0 KiB
Average record size in memory77.0 B

Variable types

Categorical4
Text1
Numeric2
DateTime1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15962/S/1/datasetView.do

Alerts

기관 명 has constant value ""Constant
모델명 has constant value ""Constant
전원상태(꺼짐:0, 켜짐 :1) has constant value ""Constant
Dataset has 2 (< 0.1%) duplicate rowsDuplicates
사용전력(W) has 4686 (46.9%) zerosZeros

Reproduction

Analysis started2024-05-11 05:39:45.540487
Analysis finished2024-05-11 05:39:48.078896
Duration2.54 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-11T05:39:48.233733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T05:39:48.533381image/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
340
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row340
2nd row340
3rd row340
4th row340
5th row340

Common Values

ValueCountFrequency (%)
340 10000
100.0%

Length

2024-05-11T05:39:48.714521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T05:39:48.955636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
340 10000
100.0%

시리얼
Text

Distinct72
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-11T05:39:49.346257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters100000
Distinct characters16
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row2de72cfce9
2nd row6eb31aa286
3rd rowe1ba1dbe08
4th rowea961e3698
5th rowa309c919fd
ValueCountFrequency (%)
e1ba1dbe08 2029
 
20.3%
de28c29733 525
 
5.2%
08ccb88d44 319
 
3.2%
ba77c59645 301
 
3.0%
a8080bd747 231
 
2.3%
7abcf2427a 178
 
1.8%
6a309a539d 170
 
1.7%
c11fce50b9 169
 
1.7%
7540803cd5 166
 
1.7%
1ee5a7ada7 151
 
1.5%
Other values (62) 5761
57.6%
2024-05-11T05:39:50.140950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
b 8508
 
8.5%
e 8399
 
8.4%
8 8104
 
8.1%
d 7716
 
7.7%
a 7689
 
7.7%
1 7672
 
7.7%
7 6607
 
6.6%
0 6397
 
6.4%
5 5603
 
5.6%
2 5544
 
5.5%
Other values (6) 27761
27.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 59186
59.2%
Lowercase Letter 40814
40.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 8104
13.7%
1 7672
13.0%
7 6607
11.2%
0 6397
10.8%
5 5603
9.5%
2 5544
9.4%
3 5430
9.2%
9 5288
8.9%
4 4332
7.3%
6 4209
7.1%
Lowercase Letter
ValueCountFrequency (%)
b 8508
20.8%
e 8399
20.6%
d 7716
18.9%
a 7689
18.8%
c 4908
12.0%
f 3594
8.8%

Most occurring scripts

ValueCountFrequency (%)
Common 59186
59.2%
Latin 40814
40.8%

Most frequent character per script

Common
ValueCountFrequency (%)
8 8104
13.7%
1 7672
13.0%
7 6607
11.2%
0 6397
10.8%
5 5603
9.5%
2 5544
9.4%
3 5430
9.2%
9 5288
8.9%
4 4332
7.3%
6 4209
7.1%
Latin
ValueCountFrequency (%)
b 8508
20.8%
e 8399
20.6%
d 7716
18.9%
a 7689
18.8%
c 4908
12.0%
f 3594
8.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 100000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
b 8508
 
8.5%
e 8399
 
8.4%
8 8104
 
8.1%
d 7716
 
7.7%
a 7689
 
7.7%
1 7672
 
7.7%
7 6607
 
6.6%
0 6397
 
6.4%
5 5603
 
5.6%
2 5544
 
5.5%
Other values (6) 27761
27.8%

가동유무
Categorical

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 5327
53.3%
1 4673
46.7%

Length

2024-05-11T05:39:50.395004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T05:39:50.567770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 5327
53.3%
1 4673
46.7%

사용전력(W)
Real number (ℝ)

ZEROS 

Distinct236
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.4487
Minimum0
Maximum1433
Zeros4686
Zeros (%)46.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T05:39:50.848975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2.5
Q332
95-th percentile91
Maximum1433
Range1433
Interquartile range (IQR)32

Descriptive statistics

Standard deviation84.867677
Coefficient of variation (CV)2.983183
Kurtosis113.4669
Mean28.4487
Median Absolute Deviation (MAD)2.5
Skewness9.6720809
Sum284487
Variance7202.5226
MonotonicityNot monotonic
2024-05-11T05:39:51.306811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4686
46.9%
1 299
 
3.0%
6 262
 
2.6%
15 202
 
2.0%
30 191
 
1.9%
29 183
 
1.8%
13 182
 
1.8%
64 181
 
1.8%
33 176
 
1.8%
63 171
 
1.7%
Other values (226) 3467
34.7%
ValueCountFrequency (%)
0 4686
46.9%
1 299
 
3.0%
2 15
 
0.1%
3 66
 
0.7%
4 20
 
0.2%
5 29
 
0.3%
6 262
 
2.6%
7 20
 
0.2%
8 140
 
1.4%
9 48
 
0.5%
ValueCountFrequency (%)
1433 1
< 0.1%
1285 1
< 0.1%
1244 1
< 0.1%
1234 1
< 0.1%
1233 1
< 0.1%
1230 1
< 0.1%
1228 1
< 0.1%
1227 1
< 0.1%
1223 1
< 0.1%
1214 1
< 0.1%

빛의밝기(%)
Real number (ℝ)

Distinct67
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.23
Minimum20
Maximum93
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-11T05:39:51.676495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile20
Q120
median20
Q324
95-th percentile42
Maximum93
Range73
Interquartile range (IQR)4

Descriptive statistics

Standard deviation8.2929354
Coefficient of variation (CV)0.34225899
Kurtosis13.252935
Mean24.23
Median Absolute Deviation (MAD)0
Skewness3.2408007
Sum242300
Variance68.772777
MonotonicityNot monotonic
2024-05-11T05:39:52.300868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20 5149
51.5%
21 763
 
7.6%
22 711
 
7.1%
23 529
 
5.3%
24 415
 
4.2%
29 239
 
2.4%
28 239
 
2.4%
25 207
 
2.1%
30 172
 
1.7%
27 166
 
1.7%
Other values (57) 1410
 
14.1%
ValueCountFrequency (%)
20 5149
51.5%
21 763
 
7.6%
22 711
 
7.1%
23 529
 
5.3%
24 415
 
4.2%
25 207
 
2.1%
26 144
 
1.4%
27 166
 
1.7%
28 239
 
2.4%
29 239
 
2.4%
ValueCountFrequency (%)
93 2
< 0.1%
92 1
 
< 0.1%
91 1
 
< 0.1%
87 1
 
< 0.1%
85 3
< 0.1%
84 1
 
< 0.1%
83 4
< 0.1%
82 2
< 0.1%
81 4
< 0.1%
79 1
 
< 0.1%

전원상태(꺼짐:0, 켜짐 :1)
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-11T05:39:52.667937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

등록일자
Date

Distinct9870
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-22 00:00:30
Maximum2024-01-28 23:59:33
2024-05-11T05:39:53.282434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:39:53.728073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-11T05:39:46.686127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:39:46.113373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:39:46.968112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:39:46.390023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T05:39:54.012614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼가동유무사용전력(W)빛의밝기(%)
시리얼1.0000.7000.6300.645
가동유무0.7001.0000.2190.140
사용전력(W)0.6300.2191.0000.000
빛의밝기(%)0.6450.1400.0001.000
2024-05-11T05:39:54.342507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용전력(W)빛의밝기(%)가동유무
사용전력(W)1.0000.0980.168
빛의밝기(%)0.0981.0000.107
가동유무0.1680.1071.000

Missing values

2024-05-11T05:39:47.347302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T05:39:47.799197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

기관 명모델명시리얼가동유무사용전력(W)빛의밝기(%)전원상태(꺼짐:0, 켜짐 :1)등록일자
276양천구3402de72cfce9002812024-01-22 02:29:16
13814양천구3406eb31aa286003612024-01-26 11:24:57
21552양천구340e1ba1dbe08012012024-01-28 19:05:19
8009양천구340ea961e36981334012024-01-24 11:20:11
4353양천구340a309c919fd0132012024-01-23 07:22:06
16828양천구340e08664952a012012024-01-27 08:48:08
15357양천구340e1ba1dbe081642012024-01-26 21:52:09
10790양천구340262ba2fb6e002112024-01-25 10:54:28
17196양천구340c11fce50b91294312024-01-27 12:01:25
6521양천구3407456e58b131102012024-01-24 00:28:19
기관 명모델명시리얼가동유무사용전력(W)빛의밝기(%)전원상태(꺼짐:0, 켜짐 :1)등록일자
18737양천구3404324a749c6004312024-01-27 22:32:54
15171양천구340e1ba1dbe08012012024-01-26 20:34:00
15827양천구340e1ba1dbe08002012024-01-27 01:20:21
4612양천구340f530a70d3a1672012024-01-23 09:29:28
13589양천구340f530a70d3a1712012024-01-26 09:47:32
12644양천구3406a309a539d002012024-01-26 01:44:58
7529양천구340e1ba1dbe081622012024-01-24 07:44:58
9189양천구3405d2ce46157002012024-01-24 19:55:25
17634양천구340e1ba1dbe080152312024-01-27 15:04:19
9135양천구340d796bdf0f6032312024-01-24 19:24:52

Duplicate rows

Most frequently occurring

기관 명모델명시리얼가동유무사용전력(W)빛의밝기(%)전원상태(꺼짐:0, 켜짐 :1)등록일자# duplicates
0양천구340e1ba1dbe08012012024-01-28 00:52:142
1양천구340e1ba1dbe081652812024-01-24 14:58:182