Overview

Dataset statistics

Number of variables8
Number of observations8238
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)< 0.1%
Total size in memory555.2 KiB
Average record size in memory69.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 1 (< 0.1%) duplicate rowsDuplicates
사용전력(W) has 3886 (47.2%) zerosZeros

Reproduction

Analysis started2024-05-11 05:38:57.985724
Analysis finished2024-05-11 05:39:00.612079
Duration2.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
양천구
8238 

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 (%)
양천구 8238
100.0%

Length

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

Common Values (Plot)

2024-05-11T05:39:01.118296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양천구 8238
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
340
8238 

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 8238
100.0%

Length

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

Common Values (Plot)

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

시리얼
Text

Distinct76
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
2024-05-11T05:39:02.411505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters82380
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

Unique0 ?
Unique (%)0.0%

Sample

1st rowa8080bd747
2nd rowc31620c8e1
3rd rowd71f39e8b1
4th rowa8080bd747
5th rowba77c59645
ValueCountFrequency (%)
e1ba1dbe08 1694
 
20.6%
de28c29733 387
 
4.7%
08ccb88d44 295
 
3.6%
ba77c59645 274
 
3.3%
a8080bd747 222
 
2.7%
c11fce50b9 129
 
1.6%
6a309a539d 127
 
1.5%
7abcf2427a 119
 
1.4%
1ee5a7ada7 117
 
1.4%
7540803cd5 108
 
1.3%
Other values (66) 4766
57.9%
2024-05-11T05:39:03.222379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
b 7026
 
8.5%
e 6967
 
8.5%
8 6664
 
8.1%
d 6464
 
7.8%
1 6266
 
7.6%
a 6235
 
7.6%
7 5304
 
6.4%
0 5297
 
6.4%
9 4530
 
5.5%
5 4517
 
5.5%
Other values (6) 23110
28.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 48613
59.0%
Lowercase Letter 33767
41.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 6664
13.7%
1 6266
12.9%
7 5304
10.9%
0 5297
10.9%
9 4530
9.3%
5 4517
9.3%
2 4392
9.0%
3 4187
8.6%
4 3873
8.0%
6 3583
7.4%
Lowercase Letter
ValueCountFrequency (%)
b 7026
20.8%
e 6967
20.6%
d 6464
19.1%
a 6235
18.5%
c 3973
11.8%
f 3102
9.2%

Most occurring scripts

ValueCountFrequency (%)
Common 48613
59.0%
Latin 33767
41.0%

Most frequent character per script

Common
ValueCountFrequency (%)
8 6664
13.7%
1 6266
12.9%
7 5304
10.9%
0 5297
10.9%
9 4530
9.3%
5 4517
9.3%
2 4392
9.0%
3 4187
8.6%
4 3873
8.0%
6 3583
7.4%
Latin
ValueCountFrequency (%)
b 7026
20.8%
e 6967
20.6%
d 6464
19.1%
a 6235
18.5%
c 3973
11.8%
f 3102
9.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 82380
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
b 7026
 
8.5%
e 6967
 
8.5%
8 6664
 
8.1%
d 6464
 
7.8%
1 6266
 
7.6%
a 6235
 
7.6%
7 5304
 
6.4%
0 5297
 
6.4%
9 4530
 
5.5%
5 4517
 
5.5%
Other values (6) 23110
28.1%

가동유무
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
0
4451 
1
3787 

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 4451
54.0%
1 3787
46.0%

Length

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

Common Values (Plot)

2024-05-11T05:39:03.978587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 4451
54.0%
1 3787
46.0%

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

ZEROS 

Distinct217
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.966618
Minimum0
Maximum1663
Zeros3886
Zeros (%)47.2%
Negative0
Negative (%)0.0%
Memory size72.5 KiB
2024-05-11T05:39:04.305663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q330
95-th percentile87.15
Maximum1663
Range1663
Interquartile range (IQR)30

Descriptive statistics

Standard deviation91.525757
Coefficient of variation (CV)3.2726788
Kurtosis181.6545
Mean27.966618
Median Absolute Deviation (MAD)1
Skewness12.112538
Sum230389
Variance8376.9642
MonotonicityNot monotonic
2024-05-11T05:39:04.853070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3886
47.2%
13 415
 
5.0%
1 324
 
3.9%
29 191
 
2.3%
6 149
 
1.8%
22 148
 
1.8%
64 143
 
1.7%
32 143
 
1.7%
30 137
 
1.7%
33 136
 
1.7%
Other values (207) 2566
31.1%
ValueCountFrequency (%)
0 3886
47.2%
1 324
 
3.9%
2 22
 
0.3%
3 21
 
0.3%
4 5
 
0.1%
5 38
 
0.5%
6 149
 
1.8%
7 2
 
< 0.1%
8 2
 
< 0.1%
9 18
 
0.2%
ValueCountFrequency (%)
1663 1
< 0.1%
1656 1
< 0.1%
1652 1
< 0.1%
1651 2
< 0.1%
1650 2
< 0.1%
1648 1
< 0.1%
1592 1
< 0.1%
1549 1
< 0.1%
1422 1
< 0.1%
1420 2
< 0.1%

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

Distinct50
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.068342
Minimum20
Maximum79
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size72.5 KiB
2024-05-11T05:39:05.259190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20
5-th percentile20
Q120
median20
Q323
95-th percentile35
Maximum79
Range59
Interquartile range (IQR)3

Descriptive statistics

Standard deviation5.9938308
Coefficient of variation (CV)0.25982929
Kurtosis14.063992
Mean23.068342
Median Absolute Deviation (MAD)0
Skewness3.2374855
Sum190037
Variance35.926007
MonotonicityNot monotonic
2024-05-11T05:39:05.722727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20 4469
54.2%
21 795
 
9.7%
22 542
 
6.6%
23 389
 
4.7%
24 363
 
4.4%
25 258
 
3.1%
28 186
 
2.3%
29 148
 
1.8%
30 112
 
1.4%
26 104
 
1.3%
Other values (40) 872
 
10.6%
ValueCountFrequency (%)
20 4469
54.2%
21 795
 
9.7%
22 542
 
6.6%
23 389
 
4.7%
24 363
 
4.4%
25 258
 
3.1%
26 104
 
1.3%
27 102
 
1.2%
28 186
 
2.3%
29 148
 
1.8%
ValueCountFrequency (%)
79 3
< 0.1%
78 1
 
< 0.1%
73 3
< 0.1%
70 1
 
< 0.1%
68 2
< 0.1%
67 1
 
< 0.1%
64 1
 
< 0.1%
63 1
 
< 0.1%
61 1
 
< 0.1%
60 1
 
< 0.1%

전원상태(꺼짐:0, 켜짐 :1)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
1
8238 

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 8238
100.0%

Length

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

Common Values (Plot)

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

등록일자
Date

Distinct8025
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size64.5 KiB
Minimum2023-12-25 00:00:27
Maximum2023-12-27 08:58:01
2024-05-11T05:39:07.015715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:39:07.586762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-11T05:38:59.226164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:38:58.611871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:38:59.528263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T05:38:58.935667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T05:39:07.822888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼가동유무사용전력(W)빛의밝기(%)
시리얼1.0000.7090.6340.664
가동유무0.7091.0000.1590.122
사용전력(W)0.6340.1591.0000.000
빛의밝기(%)0.6640.1220.0001.000
2024-05-11T05:39:08.314013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용전력(W)빛의밝기(%)가동유무
사용전력(W)1.0000.1080.158
빛의밝기(%)0.1081.0000.093
가동유무0.1580.0931.000

Missing values

2024-05-11T05:38:59.916331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T05:39:00.376424image/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)등록일자
0양천구340a8080bd747102212023-12-25 00:00:27
1양천구340c31620c8e11652012023-12-25 00:00:32
2양천구340d71f39e8b1002012023-12-25 00:00:47
3양천구340a8080bd747002212023-12-25 00:00:57
4양천구340ba77c596451232012023-12-25 00:01:01
5양천구340ba77c596450232012023-12-25 00:01:31
6양천구3405d2ce46157002012023-12-25 00:01:53
7양천구340ba77c596450232012023-12-25 00:01:55
8양천구340ec036093df102112023-12-25 00:03:31
9양천구340ec036093df002112023-12-25 00:04:01
기관 명모델명시리얼가동유무사용전력(W)빛의밝기(%)전원상태(꺼짐:0, 켜짐 :1)등록일자
8228양천구340283c0deb9b11112012023-12-27 08:50:54
8229양천구34005d372d93711252212023-12-27 08:51:04
8230양천구340e1ba1dbe081632812023-12-27 08:51:11
8231양천구340bdaa0641451872212023-12-27 08:51:29
8232양천구34071d6d75839003312023-12-27 08:51:45
8233양천구340a888aab6a9102012023-12-27 08:55:52
8234양천구340a888aab6a9002012023-12-27 08:56:17
8235양천구340a201a00e4d003912023-12-27 08:57:37
8236양천구3402de72cfce91542612023-12-27 08:57:52
8237양천구340276f3a51ab1282012023-12-27 08:58:01

Duplicate rows

Most frequently occurring

기관 명모델명시리얼가동유무사용전력(W)빛의밝기(%)전원상태(꺼짐:0, 켜짐 :1)등록일자# duplicates
0양천구340ba77c596450232012023-12-25 02:09:472