gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	62
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.3 KiB
Average record size in memory	55.1 B

Variable types

DateTime	1
Numeric	5

Dataset

Description	한국수력원자력 전원별(원자력,수력,양수,신재생) 전력판매량 현황 관련입니다.- 단위: GWh- 시운전 판매량 포함- PPA(Power Purchase Agreement, 한전직거래) 판매량 제외
Author	한국수력원자력(주)
URL	https://www.data.go.kr/data/15061364/fileData.do

Alerts

`원자력(GWh)` is highly overall correlated with `신재생(GWh)` and 1 other fields	High correlation
`신재생(GWh)` is highly overall correlated with `원자력(GWh)` and 1 other fields	High correlation
`합계(GWh)` is highly overall correlated with `원자력(GWh)` and 1 other fields	High correlation
`연월` has unique values	Unique
`원자력(GWh)` has unique values	Unique
`합계(GWh)` has unique values	Unique

Reproduction

Analysis started	2024-04-06 08:54:12.016552
Analysis finished	2024-04-06 08:54:20.005170
Duration	7.99 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연월
Date

UNIQUE

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	628.0 B

Minimum	2019-01-01 00:00:00
Maximum	2024-02-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

원자력(GWh)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13052.613

Minimum	8835
Maximum	15741
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	8835
5-th percentile	10092.5
Q1	12098.5
median	13325.5
Q3	14174.75
95-th percentile	15318.65
Maximum	15741
Range	6906
Interquartile range (IQR)	2076.25

Descriptive statistics

Standard deviation	1557.1116
Coefficient of variation (CV)	0.11929501
Kurtosis	0.0029623078
Mean	13052.613
Median Absolute Deviation (MAD)	1106.5
Skewness	-0.59235192
Sum	809262
Variance	2424596.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11663	1	1.6%
14498	1	1.6%
12904	1	1.6%
15741	1	1.6%
15331	1	1.6%
13314	1	1.6%
13198	1	1.6%
12748	1	1.6%
13912	1	1.6%
14014	1	1.6%
Other values (52)	52	83.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8835	1	1.6%
9724	1	1.6%
9803	1	1.6%
10071	1	1.6%
10501	1	1.6%
10514	1	1.6%
10793	1	1.6%
11110	1	1.6%
11315	1	1.6%
11560	1	1.6%

Value	Count	Frequency (%)
15741	1	1.6%
15493	1	1.6%
15487	1	1.6%
15331	1	1.6%
15084	1	1.6%
15030	1	1.6%
14958	1	1.6%
14914	1	1.6%
14590	1	1.6%
14555	1	1.6%

수력(GWh)
Real number (ℝ)

Distinct	49
Distinct (%)	79.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88.258065

Minimum	37
Maximum	224
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	37
5-th percentile	43.15
Q1	56.25
median	71.5
Q3	106.5
95-th percentile	201.85
Maximum	224
Range	187
Interquartile range (IQR)	50.25

Descriptive statistics

Standard deviation	47.23639
Coefficient of variation (CV)	0.53520764
Kurtosis	1.8002002
Mean	88.258065
Median Absolute Deviation (MAD)	17
Skewness	1.5529037
Sum	5472
Variance	2231.2766
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
63	4	6.5%
55	3	4.8%
47	2	3.2%
71	2	3.2%
42	2	3.2%
76	2	3.2%
48	2	3.2%
57	2	3.2%
75	2	3.2%
87	2	3.2%
Other values (39)	39	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37	1	1.6%
42	2	3.2%
43	1	1.6%
46	1	1.6%
47	2	3.2%
48	2	3.2%
50	1	1.6%
52	1	1.6%
54	1	1.6%
55	3	4.8%

Value	Count	Frequency (%)
224	1	1.6%
222	1	1.6%
217	1	1.6%
202	1	1.6%
199	1	1.6%
155	1	1.6%
150	1	1.6%
140	1	1.6%
137	1	1.6%
136	1	1.6%

양수(GWh)
Real number (ℝ)

Distinct	48
Distinct (%)	77.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	299.8871

Minimum	222
Maximum	377
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	222
5-th percentile	236.35
Q1	275.25
median	301.5
Q3	323
95-th percentile	357.6
Maximum	377
Range	155
Interquartile range (IQR)	47.75

Descriptive statistics

Standard deviation	36.056924
Coefficient of variation (CV)	0.120235
Kurtosis	-0.17121517
Mean	299.8871
Median Absolute Deviation (MAD)	23.5
Skewness	-0.16060418
Sum	18593
Variance	1300.1018
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
323	3	4.8%
343	3	4.8%
312	3	4.8%
266	2	3.2%
286	2	3.2%
319	2	3.2%
302	2	3.2%
271	2	3.2%
313	2	3.2%
222	2	3.2%
Other values (38)	39	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
222	2	3.2%
224	1	1.6%
236	1	1.6%
243	1	1.6%
250	1	1.6%
255	1	1.6%
257	1	1.6%
259	1	1.6%
262	1	1.6%
266	2	3.2%

Value	Count	Frequency (%)
377	1	1.6%
374	1	1.6%
365	1	1.6%
358	1	1.6%
350	1	1.6%
343	3	4.8%
340	1	1.6%
337	1	1.6%
335	1	1.6%
329	1	1.6%

신재생(GWh)
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	21.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.3548387

Minimum	2
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	2
5-th percentile	3
Q1	3
median	6
Q3	7
95-th percentile	17.85
Maximum	21
Range	19
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.1373817
Coefficient of variation (CV)	0.65106006
Kurtosis	4.087631
Mean	6.3548387
Median Absolute Deviation (MAD)	2
Skewness	1.9832425
Sum	394
Variance	17.117927
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	15	24.2%
6	11	17.7%
4	8	12.9%
7	8	12.9%
9	6	9.7%
5	4	6.5%
2	2	3.2%
8	2	3.2%
18	2	3.2%
10	1	1.6%
Other values (3)	3	4.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	3.2%
3	15	24.2%
4	8	12.9%
5	4	6.5%
6	11	17.7%
7	8	12.9%
8	2	3.2%
9	6	9.7%
10	1	1.6%
15	1	1.6%

Value	Count	Frequency (%)
21	1	1.6%
19	1	1.6%
18	2	3.2%
15	1	1.6%
10	1	1.6%
9	6	9.7%
8	2	3.2%
7	8	12.9%
6	11	17.7%
5	4	6.5%

합계(GWh)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	62
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13447.081

Minimum	9291
Maximum	16125
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	690.0 B

Quantile statistics

Minimum	9291
5-th percentile	10432.3
Q1	12478.5
median	13673
Q3	14611.5
95-th percentile	15699.8
Maximum	16125
Range	6834
Interquartile range (IQR)	2133

Descriptive statistics

Standard deviation	1567.3724
Coefficient of variation (CV)	0.11655856
Kurtosis	-0.038244389
Mean	13447.081
Median Absolute Deviation (MAD)	1093.5
Skewness	-0.55458081
Sum	833719
Variance	2456656.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12069	1	1.6%
14874	1	1.6%
13207	1	1.6%
16125	1	1.6%
15709	1	1.6%
13680	1	1.6%
13611	1	1.6%
13077	1	1.6%
14290	1	1.6%
14411	1	1.6%
Other values (52)	52	83.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9291	1	1.6%
10050	1	1.6%
10213	1	1.6%
10410	1	1.6%
10856	1	1.6%
10878	1	1.6%
11244	1	1.6%
11510	1	1.6%
11706	1	1.6%
11921	1	1.6%

Value	Count	Frequency (%)
16125	1	1.6%
16044	1	1.6%
15893	1	1.6%
15709	1	1.6%
15525	1	1.6%
15489	1	1.6%
15386	1	1.6%
15297	1	1.6%
15107	1	1.6%
14927	1	1.6%

Phik (φk)
Auto

Heatmap
Table

	연월	원자력(GWh)	수력(GWh)	양수(GWh)	신재생(GWh)	합계(GWh)
연월	1.000	1.000	1.000	1.000	1.000	1.000
원자력(GWh)	1.000	1.000	0.000	0.370	0.000	0.999
수력(GWh)	1.000	0.000	1.000	0.000	0.068	0.330
양수(GWh)	1.000	0.370	0.000	1.000	0.539	0.340
신재생(GWh)	1.000	0.000	0.068	0.539	1.000	0.000
합계(GWh)	1.000	0.999	0.330	0.340	0.000	1.000

Heatmap
Table

	원자력(GWh)	수력(GWh)	양수(GWh)	신재생(GWh)	합계(GWh)
원자력(GWh)	1.000	0.033	0.206	0.527	0.998
수력(GWh)	0.033	1.000	-0.120	0.193	0.038
양수(GWh)	0.206	-0.120	1.000	0.362	0.231
신재생(GWh)	0.527	0.193	0.362	1.000	0.542
합계(GWh)	0.998	0.038	0.231	0.542	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	연월	원자력(GWh)	수력(GWh)	양수(GWh)	신재생(GWh)	합계(GWh)
0	2019-01-01	11663	63	340	3	12069
1	2019-02-01	10501	54	298	3	10856
2	2019-03-01	13369	47	274	4	13694
3	2019-04-01	13471	66	284	3	13824
4	2019-05-01	14051	84	257	4	14396
5	2019-06-01	12934	76	222	3	13235
6	2019-07-01	11110	91	306	3	11510
7	2019-08-01	11597	112	313	3	12025
8	2019-09-01	9803	108	299	3	10213
9	2019-10-01	10071	46	290	3	10410

	연월	원자력(GWh)	수력(GWh)	양수(GWh)	신재생(GWh)	합계(GWh)
52	2023-05-01	13752	137	365	9	14263
53	2023-06-01	13468	140	277	9	13894
54	2023-07-01	15030	217	271	7	15525
55	2023-08-01	15084	134	262	9	15489
56	2023-09-01	14243	118	324	9	14694
57	2023-10-01	14396	72	377	15	14860
58	2023-11-01	14958	75	335	18	15386
59	2023-12-01	15493	87	295	18	15893
60	2024-01-01	14216	55	374	21	14666
61	2024-02-01	14008	71	350	19	14448

Overview

Variables

Interactions

Correlations

Missing values

Sample