gimi9 Pandas Profiling

Dataset statistics

Number of variables	4
Number of observations	49
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.7 B

Variable types

DateTime	1
Numeric	3

Dataset

Description	한국가스공사 인천기지본부의 연간 상수도 사용량으로, 용도별(설비용, 사무용) 상수도 사용량(㎥)에 대한 정보를 나타냄
Author	한국가스공사
URL	https://data.incheon.go.kr/findData/publicDataDetail?dataId=15087687&srcSe=7661IVAWM27C61E190

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-04-06 09:46:03.425407
Analysis finished	2024-04-06 09:46:04.982119
Duration	1.56 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

사용 월
Date

UNIQUE

Distinct	49
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	524.0 B

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

Histogram

Histogram with fixed size bins (bins=49)

설비용사용량
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	49
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14490.653

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

Quantile statistics

Minimum	4300
5-th percentile	6588.4
Q1	7586
median	11400
Q3	16108
95-th percentile	45468.4
Maximum	50749
Range	46449
Interquartile range (IQR)	8522

Descriptive statistics

Standard deviation	11010.532
Coefficient of variation (CV)	0.75983682
Kurtosis	4.6039139
Mean	14490.653
Median Absolute Deviation (MAD)	3901
Skewness	2.2528887
Sum	710042
Variance	1.2123181 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
8729	1	2.0%
12882	1	2.0%
12302	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%
Other values (39)	39	79.6%

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	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3244.0612

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

Quantile statistics

Minimum	1813
5-th percentile	1866.2
Q1	2490
median	2950
Q3	3513
95-th percentile	5824.2
Maximum	6598
Range	4785
Interquartile range (IQR)	1023

Descriptive statistics

Standard deviation	1166.7037
Coefficient of variation (CV)	0.35964295
Kurtosis	1.2214545
Mean	3244.0612
Median Absolute Deviation (MAD)	560
Skewness	1.2970462
Sum	158959
Variance	1361197.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1813	2	4.1%
2567	1	2.0%
5808	1	2.0%
1922	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%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1813	2	4.1%
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	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17734.714

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

Quantile statistics

Minimum	7321
5-th percentile	8989.2
Q1	10326
median	14582
Q3	19818
95-th percentile	47334.6
Maximum	52997
Range	45676
Interquartile range (IQR)	9492

Descriptive statistics

Standard deviation	10938.067
Coefficient of variation (CV)	0.61676029
Kurtosis	3.7655609
Mean	17734.714
Median Absolute Deviation (MAD)	4898
Skewness	2.0314521
Sum	869001
Variance	1.1964132 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
9682	2	4.1%
11296	1	2.0%
17208	1	2.0%
44751	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%
Other values (38)	38	77.6%

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.1%

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.671	0.992
사무용사용량	1.000	0.671	1.000	0.709
합계	1.000	0.992	0.709	1.000

Heatmap
Table

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

	사용 월	설비용사용량	사무용사용량	합계
39	2023-04-01 00:00	8361	5658	14019
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

Overview

Variables

Interactions

Correlations

Missing values

Sample