gimi9 Pandas Profiling

Dataset statistics

Number of variables	7
Number of observations	36
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	66.7 B

Variable types

Numeric	7

Dataset

Description	국가 에너지(천연가스) 수급 관련 통계정보(국가 전체기준, 1988~) 자료 및 천연가스 공급 및 수요 항목의 데이터(가스공사 기준)를 제공하고 있습니다.
Author	산업통상자원부
URL	https://www.data.go.kr/data/3053100/fileData.do

Alerts

`연도` is highly overall correlated with `공급_국내생산(천ton)` and 5 other fields	High correlation
`공급_국내생산(천ton)` is highly overall correlated with `연도` and 5 other fields	High correlation
`공급_수입(천ton)` is highly overall correlated with `연도` and 5 other fields	High correlation
`수입(백만달러)` is highly overall correlated with `연도` and 5 other fields	High correlation
`수요_발전(천ton)` is highly overall correlated with `연도` and 5 other fields	High correlation
`수요_지역난방(천ton)` is highly overall correlated with `연도` and 5 other fields	High correlation
`수요_도시가스(천ton)` is highly overall correlated with `연도` and 5 other fields	High correlation
`연도` has unique values	Unique
`공급_수입(천ton)` has unique values	Unique
`수입(백만달러)` has unique values	Unique
`수요_발전(천ton)` has unique values	Unique
`수요_도시가스(천ton)` has unique values	Unique
`공급_국내생산(천ton)` has 18 (50.0%) zeros	Zeros
`수요_지역난방(천ton)` has 4 (11.1%) zeros	Zeros

Reproduction

Analysis started	2024-04-06 08:13:18.204723
Analysis finished	2024-04-06 08:13:28.655116
Duration	10.45 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	36
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2005.5

Minimum	1988
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	1988
5-th percentile	1989.75
Q1	1996.75
median	2005.5
Q3	2014.25
95-th percentile	2021.25
Maximum	2023
Range	35
Interquartile range (IQR)	17.5

Descriptive statistics

Standard deviation	10.535654
Coefficient of variation (CV)	0.0052533801
Kurtosis	-1.2
Mean	2005.5
Median Absolute Deviation (MAD)	9
Skewness	0
Sum	72198
Variance	111
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
1988	1	2.8%
2007	1	2.8%
2009	1	2.8%
2010	1	2.8%
2011	1	2.8%
2012	1	2.8%
2013	1	2.8%
2014	1	2.8%
2015	1	2.8%
2016	1	2.8%
Other values (26)	26	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1988	1	2.8%
1989	1	2.8%
1990	1	2.8%
1991	1	2.8%
1992	1	2.8%
1993	1	2.8%
1994	1	2.8%
1995	1	2.8%
1996	1	2.8%
1997	1	2.8%

Value	Count	Frequency (%)
2023	1	2.8%
2022	1	2.8%
2021	1	2.8%
2020	1	2.8%
2019	1	2.8%
2018	1	2.8%
2017	1	2.8%
2016	1	2.8%
2015	1	2.8%
2014	1	2.8%

공급_국내생산(천ton)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	50.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127.44444

Minimum	0
Maximum	415
Zeros	18
Zeros (%)	50.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	21
Q3	250.5
95-th percentile	386.75
Maximum	415
Range	415
Interquartile range (IQR)	250.5

Descriptive statistics

Standard deviation	150.14915
Coefficient of variation (CV)	1.1781538
Kurtosis	-1.1478909
Mean	127.44444
Median Absolute Deviation (MAD)	21
Skewness	0.66282889
Sum	4588
Variance	22544.768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	18	50.0%
355	2	5.6%
247	1	2.8%
42	1	2.8%
142	1	2.8%
198	1	2.8%
234	1	2.8%
261	1	2.8%
118	1	2.8%
144	1	2.8%
Other values (8)	8	22.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	50.0%
42	1	2.8%
118	1	2.8%
142	1	2.8%
144	1	2.8%
163	1	2.8%
181	1	2.8%
198	1	2.8%
234	1	2.8%
247	1	2.8%

Value	Count	Frequency (%)
415	1	2.8%
398	1	2.8%
383	1	2.8%
355	2	5.6%
347	1	2.8%
334	1	2.8%
271	1	2.8%
261	1	2.8%
247	1	2.8%
234	1	2.8%

공급_수입(천ton)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	36
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23219.778

Minimum	1898
Maximum	46394
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	1898
5-th percentile	2181.5
Q1	9956.25
median	23786.5
Q3	36790.5
95-th percentile	44570.75
Maximum	46394
Range	44496
Interquartile range (IQR)	26834.25

Descriptive statistics

Standard deviation	14890.267
Coefficient of variation (CV)	0.64127515
Kurtosis	-1.4113714
Mean	23219.778
Median Absolute Deviation (MAD)	13459
Skewness	-0.0056234052
Sum	835912
Variance	2.2172004 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
1898	1	2.8%
25569	1	2.8%
25822	1	2.8%
32603	1	2.8%
36685	1	2.8%
36184	1	2.8%
39876	1	2.8%
37107	1	2.8%
33366	1	2.8%
33453	1	2.8%
Other values (26)	26	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1898	1	2.8%
2015	1	2.8%
2237	1	2.8%
2494	1	2.8%
2994	1	2.8%
4459	1	2.8%
5996	1	2.8%
6756	1	2.8%
9258	1	2.8%
10189	1	2.8%

Value	Count	Frequency (%)
46394	1	2.8%
45932	1	2.8%
44117	1	2.8%
44015	1	2.8%
40748	1	2.8%
39982	1	2.8%
39876	1	2.8%
37537	1	2.8%
37107	1	2.8%
36685	1	2.8%

수입(백만달러)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	36
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12535

Minimum	323
Maximum	50022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	323
5-th percentile	431.75
Q1	1795.75
median	10286
Q3	19996.25
95-th percentile	32564.5
Maximum	50022
Range	49699
Interquartile range (IQR)	18200.5

Descriptive statistics

Standard deviation	12393.223
Coefficient of variation (CV)	0.98868948
Kurtosis	0.83845833
Mean	12535
Median Absolute Deviation (MAD)	8874
Skewness	1.0634138
Sum	451260
Variance	1.5359197 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
323	1	2.8%
12653	1	2.8%
13875	1	2.8%
17006	1	2.8%
23859	1	2.8%
27364	1	2.8%
30645	1	2.8%
31403	1	2.8%
18779	1	2.8%
12170	1	2.8%
Other values (26)	26	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
323	1	2.8%
347	1	2.8%
460	1	2.8%
485	1	2.8%
562	1	2.8%
781	1	2.8%
961	1	2.8%
1275	1	2.8%
1549	1	2.8%
1878	1	2.8%

Value	Count	Frequency (%)
50022	1	2.8%
36049	1	2.8%
31403	1	2.8%
30645	1	2.8%
27364	1	2.8%
25453	1	2.8%
23859	1	2.8%
23189	1	2.8%
20567	1	2.8%
19806	1	2.8%

수요_발전(천ton)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	36
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6886.3889

Minimum	1661
Maximum	14876
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	1661
5-th percentile	1677.5
Q1	2456.25
median	6778
Q3	11202.25
95-th percentile	13230.5
Maximum	14876
Range	13215
Interquartile range (IQR)	8746

Descriptive statistics

Standard deviation	4449.5557
Coefficient of variation (CV)	0.64613773
Kurtosis	-1.5540374
Mean	6886.3889
Median Absolute Deviation (MAD)	4377
Skewness	0.18093477
Sum	247910
Variance	19798546
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
1905	1	2.8%
8716	1	2.8%
6903	1	2.8%
10555	1	2.8%
11851	1	2.8%
12893	1	2.8%
14876	1	2.8%
13403	1	2.8%
11266	1	2.8%
11181	1	2.8%
Other values (26)	26	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1661	1	2.8%
1670	1	2.8%
1680	1	2.8%
1709	1	2.8%
1741	1	2.8%
1800	1	2.8%
1905	1	2.8%
2019	1	2.8%
2427	1	2.8%
2466	1	2.8%

Value	Count	Frequency (%)
14876	1	2.8%
13403	1	2.8%
13173	1	2.8%
12893	1	2.8%
12789	1	2.8%
11851	1	2.8%
11434	1	2.8%
11285	1	2.8%
11266	1	2.8%
11181	1	2.8%

수요_지역난방(천ton)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	33
Distinct (%)	91.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2569.1389

Minimum	0
Maximum	5392
Zeros	4
Zeros (%)	11.1%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1873
median	2212
Q3	4114
95-th percentile	4985.5
Maximum	5392
Range	5392
Interquartile range (IQR)	2241

Descriptive statistics

Standard deviation	1558.2082
Coefficient of variation (CV)	0.60650993
Kurtosis	-0.81832796
Mean	2569.1389
Median Absolute Deviation (MAD)	1149
Skewness	0.029514812
Sum	92489
Variance	2428012.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	4	11.1%
4171	1	2.8%
3126	1	2.8%
3465	1	2.8%
4095	1	2.8%
4201	1	2.8%
3591	1	2.8%
3257	1	2.8%
4257	1	2.8%
206	1	2.8%
Other values (23)	23	63.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	11.1%
206	1	2.8%
857	1	2.8%
1620	1	2.8%
1723	1	2.8%
1846	1	2.8%
1882	1	2.8%
1909	1	2.8%
1933	1	2.8%
1954	1	2.8%

Value	Count	Frequency (%)
5392	1	2.8%
5029	1	2.8%
4971	1	2.8%
4793	1	2.8%
4575	1	2.8%
4257	1	2.8%
4201	1	2.8%
4187	1	2.8%
4171	1	2.8%
4095	1	2.8%

수요_도시가스(천ton)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	36
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11801.5

Minimum	184
Maximum	19832
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	456.0 B

Quantile statistics

Minimum	184
5-th percentile	519.25
Q1	5467.75
median	14017
Q3	18249
95-th percentile	19650.25
Maximum	19832
Range	19648
Interquartile range (IQR)	12781.25

Descriptive statistics

Standard deviation	7019.2827
Coefficient of variation (CV)	0.59477886
Kurtosis	-1.3347672
Mean	11801.5
Median Absolute Deviation (MAD)	4647
Skewness	-0.47663837
Sum	424854
Variance	49270330
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
184	1	2.8%
14596	1	2.8%
15634	1	2.8%
17522	1	2.8%
18255	1	2.8%
19558	1	2.8%
19596	1	2.8%
18180	1	2.8%
16929	1	2.8%
17384	1	2.8%
Other values (26)	26	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
184	1	2.8%
349	1	2.8%
576	1	2.8%
879	1	2.8%
1256	1	2.8%
1848	1	2.8%
2451	1	2.8%
3417	1	2.8%
4561	1	2.8%
5770	1	2.8%

Value	Count	Frequency (%)
19832	1	2.8%
19813	1	2.8%
19596	1	2.8%
19558	1	2.8%
19331	1	2.8%
18822	1	2.8%
18390	1	2.8%
18328	1	2.8%
18255	1	2.8%
18247	1	2.8%

Phik (φk)
Auto

Heatmap
Table

	연도	공급_국내생산(천ton)	공급_수입(천ton)	수입(백만달러)	수요_발전(천ton)	수요_지역난방(천ton)	수요_도시가스(천ton)
연도	1.000	0.427	0.957	0.755	0.622	0.766	0.947
공급_국내생산(천ton)	0.427	1.000	0.442	0.821	0.858	0.699	0.000
공급_수입(천ton)	0.957	0.442	1.000	0.740	0.836	0.860	0.936
수입(백만달러)	0.755	0.821	0.740	1.000	0.914	0.706	0.000
수요_발전(천ton)	0.622	0.858	0.836	0.914	1.000	0.592	0.603
수요_지역난방(천ton)	0.766	0.699	0.860	0.706	0.592	1.000	0.692
수요_도시가스(천ton)	0.947	0.000	0.936	0.000	0.603	0.692	1.000

Heatmap
Table

	연도	공급_국내생산(천ton)	공급_수입(천ton)	수입(백만달러)	수요_발전(천ton)	수요_지역난방(천ton)	수요_도시가스(천ton)
연도	1.000	0.548	0.990	0.938	0.914	0.959	0.960
공급_국내생산(천ton)	0.548	1.000	0.574	0.614	0.646	0.525	0.636
공급_수입(천ton)	0.990	0.574	1.000	0.963	0.936	0.967	0.982
수입(백만달러)	0.938	0.614	0.963	1.000	0.963	0.930	0.963
수요_발전(천ton)	0.914	0.646	0.936	0.963	1.000	0.908	0.948
수요_지역난방(천ton)	0.959	0.525	0.967	0.930	0.908	1.000	0.951
수요_도시가스(천ton)	0.960	0.636	0.982	0.963	0.948	0.951	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

	연도	공급_수입(천ton)	수입(백만달러)	수요_발전(천ton)	수요_지역난방(천ton)	수요_도시가스(천ton)
0	1988	1898	323	1905	0	184
1	1989	2015	347	1670	0	349
2	1990	2237	460	1741	0	576
3	1991	2494	485	1800	0	879
4	1992	2994	562	2019	206	1256
5	1993	4459	781	1661	857	1848
6	1994	5996	961	1709	1620	2451
7	1995	6756	1275	1680	1882	3417
8	1996	9258	1878	2427	2195	4561
9	1997	11471	2296	3147	2229	5770

	연도	공급_국내생산(천ton)	공급_수입(천ton)	수입(백만달러)	수요_발전(천ton)	수요_지역난방(천ton)	수요_도시가스(천ton)
26	2014	247	37107	31403	13403	3591	18180
27	2015	144	33366	18779	11266	3257	16929
28	2016	118	33453	12170	11181	4171	17384
29	2017	261	37537	15616	9500	4257	18390
30	2018	234	44015	23189	11434	4971	19813
31	2019	198	40748	20567	10199	4575	18822
32	2020	142	39982	15716	9932	4187	18247
33	2021	42	45932	25453	12789	4793	19331
34	2022	0	46394	50022	13173	5392	19832
35	2023	0	44117	36049	11285	5029	18328

Overview

Variables

Interactions

Correlations

Missing values

Sample