Overview

Dataset statistics

Number of variables5
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory46.8 B

Variable types

Categorical2
Numeric3

Dataset

Description경기도수원월드컵경기장 에너지 사용량 현황
Author경기도수원월드컵경기장관리재단
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=4HZXFNGN9KWI8HX2RRT030843668&infSeq=1

Alerts

수도(m³/일) has unique valuesUnique
가스(m³/일) has 4 (8.3%) zerosZeros

Reproduction

Analysis started2024-04-14 03:15:10.974797
Analysis finished2024-04-14 03:15:13.037169
Duration2.06 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
2020
12 
2021
12 
2022
12 
2023
12 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 12
25.0%
2021 12
25.0%
2022 12
25.0%
2023 12
25.0%

Length

2024-04-14T12:15:13.084715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-14T12:15:13.158022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 12
25.0%
2021 12
25.0%
2022 12
25.0%
2023 12
25.0%

구분
Categorical

Distinct12
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
1월
4 
2월
4 
3월
4 
4월
4 
5월
4 
Other values (7)
28 

Length

Max length3
Median length2
Mean length2.25
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1월
2nd row2월
3rd row3월
4th row4월
5th row5월

Common Values

ValueCountFrequency (%)
1월 4
8.3%
2월 4
8.3%
3월 4
8.3%
4월 4
8.3%
5월 4
8.3%
6월 4
8.3%
7월 4
8.3%
8월 4
8.3%
9월 4
8.3%
10월 4
8.3%
Other values (2) 8
16.7%

Length

2024-04-14T12:15:13.257371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1월 4
8.3%
2월 4
8.3%
3월 4
8.3%
4월 4
8.3%
5월 4
8.3%
6월 4
8.3%
7월 4
8.3%
8월 4
8.3%
9월 4
8.3%
10월 4
8.3%
Other values (2) 8
16.7%

전기(원/kWh)
Real number (ℝ)

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean661039.04
Minimum571805
Maximum786721
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2024-04-14T12:15:13.360230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum571805
5-th percentile591552
Q1627742.5
median647880
Q3691035
95-th percentile758470.85
Maximum786721
Range214916
Interquartile range (IQR)63292.5

Descriptive statistics

Standard deviation53274.19
Coefficient of variation (CV)0.080591595
Kurtosis-0.31447157
Mean661039.04
Median Absolute Deviation (MAD)31214
Skewness0.64549395
Sum31729874
Variance2.8381394 × 109
MonotonicityNot monotonic
2024-04-14T12:15:13.460782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
680016 2
 
4.2%
719758 1
 
2.1%
678172 1
 
2.1%
639160 1
 
2.1%
589136 1
 
2.1%
640003 1
 
2.1%
786721 1
 
2.1%
760462 1
 
2.1%
653230 1
 
2.1%
647118 1
 
2.1%
Other values (37) 37
77.1%
ValueCountFrequency (%)
571805 1
2.1%
589136 1
2.1%
591503 1
2.1%
591643 1
2.1%
593873 1
2.1%
600828 1
2.1%
603096 1
2.1%
608856 1
2.1%
609869 1
2.1%
618912 1
2.1%
ValueCountFrequency (%)
786721 1
2.1%
770755 1
2.1%
760462 1
2.1%
754773 1
2.1%
752345 1
2.1%
747978 1
2.1%
727076 1
2.1%
720558 1
2.1%
719758 1
2.1%
713320 1
2.1%

가스(m³/일)
Real number (ℝ)

ZEROS 

Distinct45
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean377.20833
Minimum0
Maximum1401
Zeros4
Zeros (%)8.3%
Negative0
Negative (%)0.0%
Memory size564.0 B
2024-04-14T12:15:13.557644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1118.25
median338
Q3536.25
95-th percentile901.6
Maximum1401
Range1401
Interquartile range (IQR)418

Descriptive statistics

Standard deviation327.90826
Coefficient of variation (CV)0.8693028
Kurtosis0.74473296
Mean377.20833
Median Absolute Deviation (MAD)223.5
Skewness1.0275551
Sum18106
Variance107523.83
MonotonicityNot monotonic
2024-04-14T12:15:13.661000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
0 4
 
8.3%
377 1
 
2.1%
903 1
 
2.1%
302 1
 
2.1%
123 1
 
2.1%
258 1
 
2.1%
626 1
 
2.1%
1093 1
 
2.1%
341 1
 
2.1%
2 1
 
2.1%
Other values (35) 35
72.9%
ValueCountFrequency (%)
0 4
8.3%
2 1
 
2.1%
29 1
 
2.1%
52 1
 
2.1%
69 1
 
2.1%
76 1
 
2.1%
86 1
 
2.1%
93 1
 
2.1%
104 1
 
2.1%
123 1
 
2.1%
ValueCountFrequency (%)
1401 1
2.1%
1093 1
2.1%
903 1
2.1%
899 1
2.1%
865 1
2.1%
824 1
2.1%
791 1
2.1%
789 1
2.1%
762 1
2.1%
695 1
2.1%

수도(m³/일)
Real number (ℝ)

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14822.396
Minimum6774
Maximum25523
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2024-04-14T12:15:13.776480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6774
5-th percentile7097.65
Q111731.25
median15162.5
Q318117.75
95-th percentile21897.25
Maximum25523
Range18749
Interquartile range (IQR)6386.5

Descriptive statistics

Standard deviation4657.6093
Coefficient of variation (CV)0.31422783
Kurtosis-0.58294744
Mean14822.396
Median Absolute Deviation (MAD)3206.5
Skewness0.0034036912
Sum711475
Variance21693324
MonotonicityNot monotonic
2024-04-14T12:15:13.879534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
21153 1
 
2.1%
15728 1
 
2.1%
13152 1
 
2.1%
8062 1
 
2.1%
25523 1
 
2.1%
18110 1
 
2.1%
19274 1
 
2.1%
17916 1
 
2.1%
19164 1
 
2.1%
17101 1
 
2.1%
Other values (38) 38
79.2%
ValueCountFrequency (%)
6774 1
2.1%
6905 1
2.1%
7049 1
2.1%
7188 1
2.1%
7386 1
2.1%
8062 1
2.1%
9484 1
2.1%
9582 1
2.1%
9958 1
2.1%
10389 1
2.1%
ValueCountFrequency (%)
25523 1
2.1%
23857 1
2.1%
22298 1
2.1%
21153 1
2.1%
19445 1
2.1%
19274 1
2.1%
19209 1
2.1%
19164 1
2.1%
18794 1
2.1%
18785 1
2.1%

Interactions

2024-04-14T12:15:12.673307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.107647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.452291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.737195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.194861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.521297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.826531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.382364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-14T12:15:12.593725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-14T12:15:13.955813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도구분전기(원/kWh)가스(m³/일)수도(m³/일)
연도1.0000.0000.3920.0000.522
구분0.0001.0000.5200.6730.182
전기(원/kWh)0.3920.5201.0000.0000.583
가스(m³/일)0.0000.6730.0001.0000.000
수도(m³/일)0.5220.1820.5830.0001.000
2024-04-14T12:15:14.030953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도구분
연도1.0000.000
구분0.0001.000
2024-04-14T12:15:14.094769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전기(원/kWh)가스(m³/일)수도(m³/일)연도구분
전기(원/kWh)1.000-0.1620.4990.2490.261
가스(m³/일)-0.1621.000-0.0070.0000.342
수도(m³/일)0.499-0.0071.0000.2700.000
연도0.2490.0000.2701.0000.000
구분0.2610.3420.0000.0001.000

Missing values

2024-04-14T12:15:12.925528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-14T12:15:13.003931image/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

연도구분전기(원/kWh)가스(m³/일)수도(m³/일)
020201월71975837721153
120202월67817220117852
220203월62828476215875
320204월618912011132
420205월647808011931
520206월64795210412113
620207월68972333522298
720208월72707644123857
820209월60082846413814
9202010월6291671639958
연도구분전기(원/kWh)가스(m³/일)수도(m³/일)
3820233월65187690317573
3920234월60885638818141
4020235월64470712719445
4120236월6800169316563
4220237월74797836913698
4320238월75477379118433
4420239월69497143418785
45202310월65811139914597
46202311월65144413519209
47202312월7523455217806