Overview

Dataset statistics

Number of variables4
Number of observations232
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.3 KiB
Average record size in memory36.6 B

Variable types

Numeric4

Dataset

Description한국전력공사 월별 SMP(Shared-Memory Multiprocessor) 적용 단가 자료입니다.(번호 연도 월 수기금액 칼럼 보유)
URLhttps://www.data.go.kr/data/15039860/fileData.do

Alerts

순번 is highly overall correlated with 연도High correlation
연도 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:36:17.075929
Analysis finished2023-12-12 18:36:20.466863
Duration3.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct232
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean116.5
Minimum1
Maximum232
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-13T03:36:20.644919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.55
Q158.75
median116.5
Q3174.25
95-th percentile220.45
Maximum232
Range231
Interquartile range (IQR)115.5

Descriptive statistics

Standard deviation67.116814
Coefficient of variation (CV)0.57610999
Kurtosis-1.2
Mean116.5
Median Absolute Deviation (MAD)58
Skewness0
Sum27028
Variance4504.6667
MonotonicityStrictly increasing
2023-12-13T03:36:21.016274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
161 1
 
0.4%
149 1
 
0.4%
150 1
 
0.4%
151 1
 
0.4%
152 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
156 1
 
0.4%
Other values (222) 222
95.7%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
232 1
0.4%
231 1
0.4%
230 1
0.4%
229 1
0.4%
228 1
0.4%
227 1
0.4%
226 1
0.4%
225 1
0.4%
224 1
0.4%
223 1
0.4%

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct20
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2013.25
Minimum2004
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-13T03:36:21.274845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2004
5-th percentile2004.55
Q12008
median2013
Q32018
95-th percentile2022
Maximum2023
Range19
Interquartile range (IQR)10

Descriptive statistics

Standard deviation5.6066982
Coefficient of variation (CV)0.0027848992
Kurtosis-1.1909509
Mean2013.25
Median Absolute Deviation (MAD)5
Skewness0.0015422898
Sum467074
Variance31.435065
MonotonicityIncreasing
2023-12-13T03:36:21.567422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
2004 12
 
5.2%
2015 12
 
5.2%
2022 12
 
5.2%
2021 12
 
5.2%
2020 12
 
5.2%
2019 12
 
5.2%
2018 12
 
5.2%
2017 12
 
5.2%
2016 12
 
5.2%
2014 12
 
5.2%
Other values (10) 112
48.3%
ValueCountFrequency (%)
2004 12
5.2%
2005 11
4.7%
2006 12
5.2%
2007 12
5.2%
2008 12
5.2%
2009 12
5.2%
2010 12
5.2%
2011 12
5.2%
2012 12
5.2%
2013 12
5.2%
ValueCountFrequency (%)
2023 5
2.2%
2022 12
5.2%
2021 12
5.2%
2020 12
5.2%
2019 12
5.2%
2018 12
5.2%
2017 12
5.2%
2016 12
5.2%
2015 12
5.2%
2014 12
5.2%

월
Real number (ℝ)

Distinct12
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.4094828
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-13T03:36:21.809997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median6
Q39
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.465413
Coefficient of variation (CV)0.54066968
Kurtosis-1.2183363
Mean6.4094828
Median Absolute Deviation (MAD)3
Skewness0.041050568
Sum1487
Variance12.009087
MonotonicityNot monotonic
2023-12-13T03:36:22.193628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 20
8.6%
2 20
8.6%
3 20
8.6%
4 20
8.6%
5 20
8.6%
6 19
8.2%
7 19
8.2%
8 19
8.2%
9 19
8.2%
11 19
8.2%
Other values (2) 37
15.9%
ValueCountFrequency (%)
1 20
8.6%
2 20
8.6%
3 20
8.6%
4 20
8.6%
5 20
8.6%
6 19
8.2%
7 19
8.2%
8 19
8.2%
9 19
8.2%
10 18
7.8%
ValueCountFrequency (%)
12 19
8.2%
11 19
8.2%
10 18
7.8%
9 19
8.2%
8 19
8.2%
7 19
8.2%
6 19
8.2%
5 20
8.6%
4 20
8.6%
3 20
8.6%

수기금액
Real number (ℝ)

Distinct227
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean108.14509
Minimum46.68
Maximum267.63
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2023-12-13T03:36:22.660119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum46.68
5-th percentile55.679
Q178.1025
median94.5
Q3133.5775
95-th percentile181.301
Maximum267.63
Range220.95
Interquartile range (IQR)55.475

Descriptive statistics

Standard deviation42.136222
Coefficient of variation (CV)0.38962678
Kurtosis1.6488139
Mean108.14509
Median Absolute Deviation (MAD)23.26
Skewness1.1905774
Sum25089.66
Variance1775.4612
MonotonicityNot monotonic
2023-12-13T03:36:23.181231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
75.38 2
 
0.9%
90.77 2
 
0.9%
84.54 2
 
0.9%
81.48 2
 
0.9%
91.02 2
 
0.9%
91.07 1
 
0.4%
68.78 1
 
0.4%
65.31 1
 
0.4%
67.06 1
 
0.4%
71.73 1
 
0.4%
Other values (217) 217
93.5%
ValueCountFrequency (%)
46.68 1
0.4%
49.72 1
0.4%
49.77 1
0.4%
49.8 1
0.4%
50.39 1
0.4%
52.4 1
0.4%
52.48 1
0.4%
52.85 1
0.4%
54.05 1
0.4%
54.14 1
0.4%
ValueCountFrequency (%)
267.63 1
0.4%
253.56 1
0.4%
251.65 1
0.4%
242.19 1
0.4%
240.81 1
0.4%
233.42 1
0.4%
215.9 1
0.4%
202.11 1
0.4%
197.74 1
0.4%
197.32 1
0.4%

Interactions

2023-12-13T03:36:19.632435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:17.310042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:18.120061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:18.866474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:19.783551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:17.458045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:18.269609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:19.042307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:19.919675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:17.695649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:18.453819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:19.209399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:20.044506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:17.945328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:18.604564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:36:19.436274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:36:23.476741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번연도월수기금액
순번1.0000.9950.0000.895
연도0.9951.0000.0000.886
월0.0000.0001.0000.000
수기금액0.8950.8860.0001.000
2023-12-13T03:36:23.704633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번연도월수기금액
순번1.0000.9990.0200.260
연도0.9991.000-0.0310.262
월0.020-0.0311.000-0.055
수기금액0.2600.262-0.0551.000

Missing values

2023-12-13T03:36:20.210865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:36:20.401233image/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

순번연도월수기금액
012004154.79
122004260.34
232004360.35
342004457.26
452004554.14
562004652.48
672004749.72
782004846.68
892004949.77
91020041058.94
순번연도월수기금액
22222320228197.74
22322420229233.42
224225202210251.65
225226202211242.19
226227202212267.63
22722820231240.81
22822920232253.56
22923020233215.9
23023120234164.86
23123220235143.64