gimi9 Pandas Profiling

Dataset statistics

Number of variables	4
Number of observations	46
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 KiB
Average record size in memory	37.9 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:45:58.747508
Analysis finished	2024-04-06 09:46:00.462439
Duration	1.71 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

사용 월
Date

UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	500.0 B

Minimum	2020-01-01 00:00:00
Maximum	2023-10-01 00:00:00

Histogram

Histogram with fixed size bins (bins=46)

설비용사용량
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14580.565

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

Quantile statistics

Minimum	4300
5-th percentile	6585.25
Q1	7540.25
median	11209.5
Q3	16595
95-th percentile	46128.25
Maximum	50749
Range	46449
Interquartile range (IQR)	9054.75

Descriptive statistics

Standard deviation	11352.423
Coefficient of variation (CV)	0.77859964
Kurtosis	4.1378713
Mean	14580.565
Median Absolute Deviation (MAD)	3882.5
Skewness	2.174403
Sum	670706
Variance	1.288775 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
8729	1	2.2%
18032	1	2.2%
17489	1	2.2%
12302	1	2.2%
42829	1	2.2%
50749	1	2.2%
13526	1	2.2%
8708	1	2.2%
10211	1	2.2%
17287	1	2.2%
Other values (36)	36	78.3%

Minimum 10 values
Maximum 10 values

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

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

사무용사용량
Real number (ℝ)

Distinct	45
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3247.3696

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

Quantile statistics

Minimum	1813
5-th percentile	1852.25
Q1	2473.5
median	2924
Q3	3512.25
95-th percentile	5828.25
Maximum	6598
Range	4785
Interquartile range (IQR)	1038.75

Descriptive statistics

Standard deviation	1198.8809
Coefficient of variation (CV)	0.36918524
Kurtosis	1.0339177
Mean	3247.3696
Median Absolute Deviation (MAD)	576.5
Skewness	1.2692456
Sum	149379
Variance	1437315.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
1813	2	4.3%
2567	1	2.2%
6073	1	2.2%
3709	1	2.2%
1922	1	2.2%
2248	1	2.2%
4539	1	2.2%
4284	1	2.2%
4482	1	2.2%
4146	1	2.2%
Other values (35)	35	76.1%

Minimum 10 values
Maximum 10 values

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

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

합계
Real number (ℝ)

HIGH CORRELATION

Distinct	45
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17827.935

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

Quantile statistics

Minimum	7321
5-th percentile	8886.75
Q1	10011
median	14596.5
Q3	19733.5
95-th percentile	47980.5
Maximum	52997
Range	45676
Interquartile range (IQR)	9722.5

Descriptive statistics

Standard deviation	11270.854
Coefficient of variation (CV)	0.6322019
Kurtosis	3.360267
Mean	17827.935
Median Absolute Deviation (MAD)	4899
Skewness	1.9610622
Sum	820085
Variance	1.2703216 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
9682	2	4.3%
11296	1	2.2%
27006	1	2.2%
16011	1	2.2%
44751	1	2.2%
52997	1	2.2%
18065	1	2.2%
12992	1	2.2%
14693	1	2.2%
21433	1	2.2%
Other values (35)	35	76.1%

Minimum 10 values
Maximum 10 values

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

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

Phik (φk)
Auto

Heatmap
Table

	사용 월	설비용사용량	사무용사용량	합계
사용 월	1.000	1.000	1.000	1.000
설비용사용량	1.000	1.000	0.605	0.992
사무용사용량	1.000	0.605	1.000	0.768
합계	1.000	0.992	0.768	1.000

Heatmap
Table

	설비용사용량	사무용사용량	합계
설비용사용량	1.000	0.221	0.982
사무용사용량	0.221	1.000	0.322
합계	0.982	0.322	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

	사용 월	설비용사용량	사무용사용량	합계
36	2023-01-01 00:00	20933	6073	27006
37	2023-02-01 00:00	12882	6598	19480
38	2023-03-01 00:00	11400	5808	17208
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

Overview

Variables

Interactions

Correlations

Missing values

Sample