gimi9 Pandas Profiling

Dataset statistics

Number of variables	4
Number of observations	50
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 KiB
Average record size in memory	37.6 B

Variable types

DateTime	1
Numeric	3

Dataset

Description	한국가스공사 인천기지본부의 연간 상수도 사용량으로, 용도별(설비용, 사무용) 상수도 사용량(㎥)에 대한 정보를 나타냄
Author	한국가스공사
URL	https://www.data.go.kr/data/15087687/fileData.do

Alerts

`설비용사용량` is highly overall correlated with `합계`	High correlation
`합계` is highly overall correlated with `설비용사용량`	High correlation
`사용 월` has unique values	Unique
`설비용사용량` has unique values	Unique

Reproduction

Analysis started	2024-03-23 05:37:48.502593
Analysis finished	2024-03-23 05:37:50.735477
Duration	2.23 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

사용 월
Date

UNIQUE

Distinct	50
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	532.0 B

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

Histogram

Histogram with fixed size bins (bins=50)

설비용사용량
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	50
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14439.86

Minimum	4300
Maximum	50749
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	582.0 B

Quantile statistics

Minimum	4300
5-th percentile	6589.45
Q1	7614.75
median	11592
Q3	15937.25
95-th percentile	45248.45
Maximum	50749
Range	46449
Interquartile range (IQR)	8322.5

Descriptive statistics

Standard deviation	10903.517
Coefficient of variation (CV)	0.75509854
Kurtosis	4.7792315
Mean	14439.86
Median Absolute Deviation (MAD)	4036.5
Skewness	2.2848882
Sum	721993
Variance	1.1888669 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8729	1	2.0%
11400	1	2.0%
42829	1	2.0%
50749	1	2.0%
13526	1	2.0%
8708	1	2.0%
10211	1	2.0%
17287	1	2.0%
8323	1	2.0%
18032	1	2.0%
Other values (40)	40	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4300	1	2.0%
5927	1	2.0%
6580	1	2.0%
6601	1	2.0%
6696	1	2.0%
6744	1	2.0%
6810	1	2.0%
6883	1	2.0%
7100	1	2.0%
7155	1	2.0%

Value	Count	Frequency (%)
50749	1	2.0%
47718	1	2.0%
47228	1	2.0%
42829	1	2.0%
29044	1	2.0%
23924	1	2.0%
20933	1	2.0%
18032	1	2.0%
17489	1	2.0%
17287	1	2.0%

사무용사용량
Real number (ℝ)

Distinct	49
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3239.78

Minimum	1813
Maximum	6598
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	582.0 B

Quantile statistics

Minimum	1813
5-th percentile	1870.85
Q1	2506.25
median	2953
Q3	3512.25
95-th percentile	5822.85
Maximum	6598
Range	4785
Interquartile range (IQR)	1006

Descriptive statistics

Standard deviation	1155.134
Coefficient of variation (CV)	0.35654704
Kurtosis	1.3212027
Mean	3239.78
Median Absolute Deviation (MAD)	554
Skewness	1.3194712
Sum	161989
Variance	1334334.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
1813	2	4.0%
2567	1	2.0%
5658	1	2.0%
2248	1	2.0%
4539	1	2.0%
4284	1	2.0%
4482	1	2.0%
4146	1	2.0%
3513	1	2.0%
5835	1	2.0%
Other values (39)	39	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1813	2	4.0%
1829	1	2.0%
1922	1	2.0%
2020	1	2.0%
2140	1	2.0%
2183	1	2.0%
2238	1	2.0%
2248	1	2.0%
2351	1	2.0%
2381	1	2.0%

Value	Count	Frequency (%)
6598	1	2.0%
6073	1	2.0%
5835	1	2.0%
5808	1	2.0%
5658	1	2.0%
4539	1	2.0%
4482	1	2.0%
4337	1	2.0%
4284	1	2.0%
4146	1	2.0%

합계
Real number (ℝ)

HIGH CORRELATION

Distinct	49
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17679.64

Minimum	7321
Maximum	52997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	582.0 B

Quantile statistics

Minimum	7321
5-th percentile	9023.35
Q1	10476
median	14596.5
Q3	19733.5
95-th percentile	47119.3
Maximum	52997
Range	45676
Interquartile range (IQR)	9257.5

Descriptive statistics

Standard deviation	10832.881
Coefficient of variation (CV)	0.61273201
Kurtosis	3.9238212
Mean	17679.64
Median Absolute Deviation (MAD)	4787
Skewness	2.0623229
Sum	883982
Variance	1.1735132 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
9682	2	4.0%
11296	1	2.0%
14019	1	2.0%
52997	1	2.0%
18065	1	2.0%
12992	1	2.0%
14693	1	2.0%
21433	1	2.0%
11836	1	2.0%
23867	1	2.0%
Other values (39)	39	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7321	1	2.0%
7740	1	2.0%
8716	1	2.0%
9399	1	2.0%
9438	1	2.0%
9451	1	2.0%
9478	1	2.0%
9500	1	2.0%
9623	1	2.0%
9682	2	4.0%

Value	Count	Frequency (%)
52997	1	2.0%
49531	1	2.0%
49057	1	2.0%
44751	1	2.0%
33381	1	2.0%
27184	1	2.0%
27006	1	2.0%
23867	1	2.0%
21433	1	2.0%
20993	1	2.0%

Phik (φk)
Auto

Heatmap
Table

	사용 월	설비용사용량	사무용사용량	합계
사용 월	1.000	1.000	1.000	1.000
설비용사용량	1.000	1.000	0.688	0.993
사무용사용량	1.000	0.688	1.000	0.724
합계	1.000	0.993	0.724	1.000

Heatmap
Table

	설비용사용량	사무용사용량	합계
설비용사용량	1.000	0.247	0.983
사무용사용량	0.247	1.000	0.346
합계	0.983	0.346	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

	사용 월	설비용사용량	사무용사용량	합계
0	2020-01-01 00:00	8729	2567	11296
1	2020-02-01 00:00	7100	2351	9451
2	2020-03-01 00:00	5927	1813	7740
3	2020-04-01 00:00	7155	2468	9623
4	2020-05-01 00:00	7525	2381	9906
5	2020-06-01 00:00	6744	2655	9399
6	2020-07-01 00:00	4300	3021	7321
7	2020-08-01 00:00	6580	2898	9478
8	2020-09-01 00:00	6601	3081	9682
9	2020-10-01 00:00	6883	2555	9438

	사용 월	설비용사용량	사무용사용량	합계
40	2023-05-01 00:00	8786	2140	10926
41	2023-06-01 00:00	10327	2950	13277
42	2023-07-01 00:00	6810	2690	9500
43	2023-08-01 00:00	7701	3470	11171
44	2023-09-01 00:00	7586	2740	10326
45	2023-10-01 00:00	6696	2020	8716
46	2023-11-01 00:00	11389	3020	14409
47	2023-12-01 00:00	16108	3830	19938
48	2024-01-01 00:00	11839	2730	14569
49	2024-02-01 00:00	11951	3030	14981

Overview

Variables

Interactions

Correlations

Missing values

Sample