Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 31 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 2.3 KiB |
Average record size in memory | 75.3 B |
Variable types
DateTime | 1 |
---|---|
Numeric | 7 |
Dataset
Description | HEPI, EIA 등의 자료를 가공하여 주요국(미국, 영국, 독일, 프랑스 등)의 소매 전기요금 가격지수를 생성한 것으로, 각국의 소매 전기요금의 등락 정도를 교차 비교할 수 있다. 2020년 6월 가격을 100으로 설정하여 비교한 것이다. |
---|---|
URL | https://www.data.go.kr/data/15117850/fileData.do |
미국 is highly overall correlated with 유럽연합27개국 및 영국 and 4 other fields | High correlation |
유럽연합27개국 및 영국 is highly overall correlated with 미국 and 5 other fields | High correlation |
유럽연합27개국 is highly overall correlated with 미국 and 5 other fields | High correlation |
독일 is highly overall correlated with 유럽연합27개국 및 영국 and 4 other fields | High correlation |
스페인 is highly overall correlated with 미국 and 5 other fields | High correlation |
프랑스 is highly overall correlated with 미국 and 5 other fields | High correlation |
영국 is highly overall correlated with 미국 and 5 other fields | High correlation |
연월 has unique values | Unique |
미국 has 2 (6.5%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 17:37:49.816053 |
---|---|
Analysis finished | 2023-12-12 17:37:56.398595 |
Duration | 6.58 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
연월
Date
UNIQUE
 
Distinct | 31 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 380.0 B |
Minimum | 2020-06-01 00:00:00 |
---|---|
Maximum | 2022-12-01 00:00:00 |
미국
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 19 |
---|---|
Distinct (%) | 61.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 99.451613 |
Minimum | 0 |
---|---|
Maximum | 123 |
Zeros | 2 |
Zeros (%) | 6.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 47.5 |
Q1 | 100 |
median | 105 |
Q3 | 108 |
95-th percentile | 121.5 |
Maximum | 123 |
Range | 123 |
Interquartile range (IQR) | 8 |
Descriptive statistics
Standard deviation | 27.491621 |
---|---|
Coefficient of variation (CV) | 0.27643213 |
Kurtosis | 10.694469 |
Mean | 99.451613 |
Median Absolute Deviation (MAD) | 5 |
Skewness | -3.2869684 |
Sum | 3083 |
Variance | 755.78925 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
105 | 5 | |
100 | 4 | |
104 | 3 | 9.7% |
0 | 2 | 6.5% |
116 | 2 | 6.5% |
106 | 2 | 6.5% |
98 | 1 | 3.2% |
95 | 1 | 3.2% |
97 | 1 | 3.2% |
107 | 1 | 3.2% |
Other values (9) | 9 |
Value | Count | Frequency (%) |
0 | 2 | 6.5% |
95 | 1 | 3.2% |
97 | 1 | 3.2% |
98 | 1 | 3.2% |
100 | 4 | |
101 | 1 | 3.2% |
102 | 1 | 3.2% |
103 | 1 | 3.2% |
104 | 3 | |
105 | 5 |
Value | Count | Frequency (%) |
123 | 1 | 3.2% |
122 | 1 | 3.2% |
121 | 1 | 3.2% |
116 | 2 | 6.5% |
113 | 1 | 3.2% |
111 | 1 | 3.2% |
109 | 1 | 3.2% |
107 | 1 | 3.2% |
106 | 2 | 6.5% |
105 | 5 |
유럽연합27개국 및 영국
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 22 |
---|---|
Distinct (%) | 71.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 126.96774 |
Minimum | 99 |
---|---|
Maximum | 188 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 99 |
---|---|
5-th percentile | 100 |
Q1 | 104 |
median | 112 |
Q3 | 149 |
95-th percentile | 180.5 |
Maximum | 188 |
Range | 89 |
Interquartile range (IQR) | 45 |
Descriptive statistics
Standard deviation | 28.914222 |
---|---|
Coefficient of variation (CV) | 0.22772889 |
Kurtosis | -0.70222097 |
Mean | 126.96774 |
Median Absolute Deviation (MAD) | 12 |
Skewness | 0.81640359 |
Sum | 3936 |
Variance | 836.03226 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
104 | 4 | 12.9% |
100 | 3 | 9.7% |
101 | 3 | 9.7% |
149 | 2 | 6.5% |
140 | 2 | 6.5% |
132 | 1 | 3.2% |
171 | 1 | 3.2% |
177 | 1 | 3.2% |
188 | 1 | 3.2% |
184 | 1 | 3.2% |
Other values (12) | 12 |
Value | Count | Frequency (%) |
99 | 1 | 3.2% |
100 | 3 | |
101 | 3 | |
104 | 4 | |
105 | 1 | 3.2% |
106 | 1 | 3.2% |
108 | 1 | 3.2% |
110 | 1 | 3.2% |
112 | 1 | 3.2% |
118 | 1 | 3.2% |
Value | Count | Frequency (%) |
188 | 1 | |
184 | 1 | |
177 | 1 | |
171 | 1 | |
170 | 1 | |
158 | 1 | |
150 | 1 | |
149 | 2 | |
140 | 2 | |
132 | 1 |
유럽연합27개국
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 22 |
---|---|
Distinct (%) | 71.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 128.41935 |
Minimum | 99 |
---|---|
Maximum | 197 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 99 |
---|---|
5-th percentile | 99.5 |
Q1 | 104 |
median | 113 |
Q3 | 151 |
95-th percentile | 188 |
Maximum | 197 |
Range | 98 |
Interquartile range (IQR) | 47 |
Descriptive statistics
Standard deviation | 31.011583 |
---|---|
Coefficient of variation (CV) | 0.24148683 |
Kurtosis | -0.42233959 |
Mean | 128.41935 |
Median Absolute Deviation (MAD) | 13 |
Skewness | 0.91260303 |
Sum | 3981 |
Variance | 961.71828 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
101 | 3 | 9.7% |
105 | 3 | 9.7% |
151 | 3 | 9.7% |
100 | 2 | 6.5% |
104 | 2 | 6.5% |
99 | 2 | 6.5% |
140 | 1 | 3.2% |
177 | 1 | 3.2% |
183 | 1 | 3.2% |
197 | 1 | 3.2% |
Other values (12) | 12 |
Value | Count | Frequency (%) |
99 | 2 | |
100 | 2 | |
101 | 3 | |
104 | 2 | |
105 | 3 | |
106 | 1 | 3.2% |
109 | 1 | 3.2% |
111 | 1 | 3.2% |
113 | 1 | 3.2% |
119 | 1 | 3.2% |
Value | Count | Frequency (%) |
197 | 1 | 3.2% |
193 | 1 | 3.2% |
183 | 1 | 3.2% |
177 | 1 | 3.2% |
172 | 1 | 3.2% |
159 | 1 | 3.2% |
151 | 3 | |
141 | 1 | 3.2% |
140 | 1 | 3.2% |
132 | 1 | 3.2% |
독일
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 17 |
---|---|
Distinct (%) | 54.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 119.83871 |
Minimum | 99 |
---|---|
Maximum | 198 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 99 |
---|---|
5-th percentile | 99 |
Q1 | 102 |
median | 103 |
Q3 | 129 |
95-th percentile | 181.5 |
Maximum | 198 |
Range | 99 |
Interquartile range (IQR) | 27 |
Descriptive statistics
Standard deviation | 27.905909 |
---|---|
Coefficient of variation (CV) | 0.23286223 |
Kurtosis | 2.0050033 |
Mean | 119.83871 |
Median Absolute Deviation (MAD) | 4 |
Skewness | 1.6391249 |
Sum | 3715 |
Variance | 778.73978 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
102 | 5 | |
103 | 5 | |
99 | 4 | |
100 | 3 | |
123 | 2 | 6.5% |
122 | 1 | 3.2% |
159 | 1 | 3.2% |
198 | 1 | 3.2% |
194 | 1 | 3.2% |
169 | 1 | 3.2% |
Other values (7) | 7 |
Value | Count | Frequency (%) |
99 | 4 | |
100 | 3 | |
102 | 5 | |
103 | 5 | |
112 | 1 | 3.2% |
114 | 1 | 3.2% |
122 | 1 | 3.2% |
123 | 2 | 6.5% |
128 | 1 | 3.2% |
130 | 1 | 3.2% |
Value | Count | Frequency (%) |
198 | 1 | |
194 | 1 | |
169 | 1 | |
159 | 1 | |
154 | 1 | |
137 | 1 | |
131 | 1 | |
130 | 1 | |
128 | 1 | |
123 | 2 |
스페인
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 26 |
---|---|
Distinct (%) | 83.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 134.3871 |
Minimum | 100 |
---|---|
Maximum | 197 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 100 |
---|---|
5-th percentile | 102.5 |
Q1 | 109 |
median | 125 |
Q3 | 158 |
95-th percentile | 173 |
Maximum | 197 |
Range | 97 |
Interquartile range (IQR) | 49 |
Descriptive statistics
Standard deviation | 27.813279 |
---|---|
Coefficient of variation (CV) | 0.20696391 |
Kurtosis | -1.0321981 |
Mean | 134.3871 |
Median Absolute Deviation (MAD) | 22 |
Skewness | 0.41326208 |
Sum | 4166 |
Variance | 773.57849 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
103 | 3 | 9.7% |
104 | 2 | 6.5% |
115 | 2 | 6.5% |
167 | 2 | 6.5% |
100 | 1 | 3.2% |
164 | 1 | 3.2% |
149 | 1 | 3.2% |
125 | 1 | 3.2% |
152 | 1 | 3.2% |
168 | 1 | 3.2% |
Other values (16) | 16 |
Value | Count | Frequency (%) |
100 | 1 | 3.2% |
102 | 1 | 3.2% |
103 | 3 | |
104 | 2 | |
106 | 1 | 3.2% |
112 | 1 | 3.2% |
115 | 2 | |
116 | 1 | 3.2% |
118 | 1 | 3.2% |
121 | 1 | 3.2% |
Value | Count | Frequency (%) |
197 | 1 | |
176 | 1 | |
170 | 1 | |
168 | 1 | |
167 | 2 | |
164 | 1 | |
160 | 1 | |
156 | 1 | |
152 | 1 | |
150 | 1 |
프랑스
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 18 |
---|---|
Distinct (%) | 58.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 110.67742 |
Minimum | 100 |
---|---|
Maximum | 146 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 100 |
---|---|
5-th percentile | 100.5 |
Q1 | 102.5 |
median | 104 |
Q3 | 117.5 |
95-th percentile | 132.5 |
Maximum | 146 |
Range | 46 |
Interquartile range (IQR) | 15 |
Descriptive statistics
Standard deviation | 11.931435 |
---|---|
Coefficient of variation (CV) | 0.1078037 |
Kurtosis | 1.2530116 |
Mean | 110.67742 |
Median Absolute Deviation (MAD) | 4 |
Skewness | 1.3503559 |
Sum | 3431 |
Variance | 142.35914 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
103 | 6 | |
101 | 5 | |
108 | 3 | 9.7% |
100 | 2 | 6.5% |
104 | 2 | 6.5% |
122 | 1 | 3.2% |
129 | 1 | 3.2% |
146 | 1 | 3.2% |
131 | 1 | 3.2% |
134 | 1 | 3.2% |
Other values (8) | 8 |
Value | Count | Frequency (%) |
100 | 2 | 6.5% |
101 | 5 | |
102 | 1 | 3.2% |
103 | 6 | |
104 | 2 | 6.5% |
105 | 1 | 3.2% |
108 | 3 | |
115 | 1 | 3.2% |
116 | 1 | 3.2% |
117 | 1 | 3.2% |
Value | Count | Frequency (%) |
146 | 1 | |
134 | 1 | |
131 | 1 | |
129 | 1 | |
122 | 1 | |
121 | 1 | |
120 | 1 | |
118 | 1 | |
117 | 1 | |
116 | 1 |
영국
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 26 |
---|---|
Distinct (%) | 83.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 159.25806 |
Minimum | 99 |
---|---|
Maximum | 289 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 411.0 B |
Quantile statistics
Minimum | 99 |
---|---|
5-th percentile | 99.5 |
Q1 | 106 |
median | 125 |
Q3 | 211.5 |
95-th percentile | 263 |
Maximum | 289 |
Range | 190 |
Interquartile range (IQR) | 105.5 |
Descriptive statistics
Standard deviation | 59.660689 |
---|---|
Coefficient of variation (CV) | 0.37461644 |
Kurtosis | -0.81815099 |
Mean | 159.25806 |
Median Absolute Deviation (MAD) | 26 |
Skewness | 0.6374887 |
Sum | 4937 |
Variance | 3559.3978 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
100 | 4 | 12.9% |
178 | 2 | 6.5% |
99 | 2 | 6.5% |
216 | 1 | 3.2% |
211 | 1 | 3.2% |
191 | 1 | 3.2% |
289 | 1 | 3.2% |
284 | 1 | 3.2% |
228 | 1 | 3.2% |
224 | 1 | 3.2% |
Other values (16) | 16 |
Value | Count | Frequency (%) |
99 | 2 | |
100 | 4 | |
101 | 1 | 3.2% |
104 | 1 | 3.2% |
108 | 1 | 3.2% |
110 | 1 | 3.2% |
112 | 1 | 3.2% |
117 | 1 | 3.2% |
118 | 1 | 3.2% |
120 | 1 | 3.2% |
Value | Count | Frequency (%) |
289 | 1 | |
284 | 1 | |
242 | 1 | |
228 | 1 | |
224 | 1 | |
219 | 1 | |
216 | 1 | |
212 | 1 | |
211 | 1 | |
199 | 1 |
연월 | 미국 | 유럽연합27개국 및 영국 | 유럽연합27개국 | 독일 | 스페인 | 프랑스 | 영국 | |
---|---|---|---|---|---|---|---|---|
연월 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
미국 | 1.000 | 1.000 | 0.889 | 0.823 | 0.904 | 0.461 | 0.751 | 0.752 |
유럽연합27개국 및 영국 | 1.000 | 0.889 | 1.000 | 0.996 | 0.834 | 0.797 | 0.855 | 0.911 |
유럽연합27개국 | 1.000 | 0.823 | 0.996 | 1.000 | 0.868 | 0.769 | 0.904 | 0.911 |
독일 | 1.000 | 0.904 | 0.834 | 0.868 | 1.000 | 0.564 | 0.897 | 0.849 |
스페인 | 1.000 | 0.461 | 0.797 | 0.769 | 0.564 | 1.000 | 0.719 | 0.829 |
프랑스 | 1.000 | 0.751 | 0.855 | 0.904 | 0.897 | 0.719 | 1.000 | 0.766 |
영국 | 1.000 | 0.752 | 0.911 | 0.911 | 0.849 | 0.829 | 0.766 | 1.000 |
미국 | 유럽연합27개국 및 영국 | 유럽연합27개국 | 독일 | 스페인 | 프랑스 | 영국 | |
---|---|---|---|---|---|---|---|
미국 | 1.000 | 0.588 | 0.588 | 0.461 | 0.713 | 0.557 | 0.617 |
유럽연합27개국 및 영국 | 0.588 | 1.000 | 0.997 | 0.943 | 0.879 | 0.986 | 0.911 |
유럽연합27개국 | 0.588 | 0.997 | 1.000 | 0.945 | 0.877 | 0.984 | 0.911 |
독일 | 0.461 | 0.943 | 0.945 | 1.000 | 0.814 | 0.943 | 0.861 |
스페인 | 0.713 | 0.879 | 0.877 | 0.814 | 1.000 | 0.864 | 0.921 |
프랑스 | 0.557 | 0.986 | 0.984 | 0.943 | 0.864 | 1.000 | 0.903 |
영국 | 0.617 | 0.911 | 0.911 | 0.861 | 0.921 | 0.903 | 1.000 |
연월 | 미국 | 유럽연합27개국 및 영국 | 유럽연합27개국 | 독일 | 스페인 | 프랑스 | 영국 | |
---|---|---|---|---|---|---|---|---|
0 | 2020-06-01 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
1 | 2020-07-01 | 100 | 99 | 99 | 99 | 102 | 100 | 100 |
2 | 2020-08-01 | 100 | 100 | 99 | 100 | 103 | 101 | 99 |
3 | 2020-09-01 | 102 | 100 | 100 | 100 | 104 | 101 | 99 |
4 | 2020-10-01 | 103 | 101 | 101 | 99 | 103 | 101 | 100 |
5 | 2020-11-01 | 101 | 101 | 101 | 99 | 104 | 101 | 100 |
6 | 2020-12-01 | 97 | 101 | 101 | 99 | 106 | 101 | 101 |
7 | 2021-01-01 | 95 | 104 | 104 | 102 | 118 | 102 | 104 |
8 | 2021-02-01 | 98 | 104 | 104 | 103 | 103 | 103 | 108 |
9 | 2021-03-01 | 100 | 104 | 105 | 103 | 112 | 103 | 110 |
연월 | 미국 | 유럽연합27개국 및 영국 | 유럽연합27개국 | 독일 | 스페인 | 프랑스 | 영국 | |
---|---|---|---|---|---|---|---|---|
21 | 2022-03-01 | 109 | 140 | 140 | 128 | 197 | 117 | 242 |
22 | 2022-04-01 | 111 | 149 | 151 | 130 | 176 | 118 | 219 |
23 | 2022-05-01 | 113 | 149 | 151 | 131 | 167 | 115 | 224 |
24 | 2022-06-01 | 116 | 150 | 151 | 122 | 170 | 120 | 228 |
25 | 2022-07-01 | 116 | 158 | 159 | 123 | 156 | 122 | 284 |
26 | 2022-08-01 | 121 | 170 | 172 | 137 | 167 | 121 | 289 |
27 | 2022-09-01 | 123 | 184 | 193 | 169 | 168 | 134 | 178 |
28 | 2022-10-01 | 122 | 188 | 197 | 194 | 152 | 131 | 191 |
29 | 2022-11-01 | 0 | 177 | 183 | 198 | 125 | 146 | 211 |
30 | 2022-12-01 | 0 | 171 | 177 | 159 | 149 | 129 | 216 |