gimi9 Pandas Profiling

Dataset statistics

Number of variables	7
Number of observations	744
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	45.2 KiB
Average record size in memory	62.2 B

Variable types

DateTime	1
Numeric	6

Dataset

Description	제주특별자치도개발공사가 운영하는 제주삼다수 제1,2취수원의 감시정 6개를 통해 관리 및 수집하는 제주지역 수소 이온 농도 정보로 입니다.
Author	제주특별자치도개발공사
URL	https://www.data.go.kr/data/15103550/fileData.do

Alerts

`1수원 감시정1` is highly overall correlated with `1수원 감시정3`	High correlation
`1수원 감시정2` is highly overall correlated with `1수원 감시정3` and 1 other fields	High correlation
`1수원 감시정3` is highly overall correlated with `1수원 감시정1` and 1 other fields	High correlation
`2수원 감시정1` is highly overall correlated with `1수원 감시정2`	High correlation
`일시` has unique values	Unique

Reproduction

Analysis started	2024-04-21 02:11:50.689401
Analysis finished	2024-04-21 02:11:56.795045
Duration	6.11 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

일시
Date

UNIQUE

Distinct	744
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.9 KiB

Minimum	2024-03-01 00:00:00
Maximum	2024-03-31 23:00:00

Histogram

Histogram with fixed size bins (bins=50)

1수원 감시정1
Real number (ℝ)

HIGH CORRELATION

Distinct	39
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.4337231

Minimum	7.15
Maximum	7.53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	7.15
5-th percentile	7.2215
Q1	7.4275
median	7.47
Q3	7.48
95-th percentile	7.51
Maximum	7.53
Range	0.38
Interquartile range (IQR)	0.0525

Descriptive statistics

Standard deviation	0.083574154
Coefficient of variation (CV)	0.01124257
Kurtosis	2.4855963
Mean	7.4337231
Median Absolute Deviation (MAD)	0.01
Skewness	-1.8240822
Sum	5530.69
Variance	0.0069846392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
7.47	190	25.5%
7.46	114	15.3%
7.48	82	11.0%
7.49	54	7.3%
7.5	43	5.8%
7.51	30	4.0%
7.45	16	2.2%
7.36	12	1.6%
7.35	10	1.3%
7.41	10	1.3%
Other values (29)	183	24.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.15	5	0.7%
7.16	5	0.7%
7.17	4	0.5%
7.18	5	0.7%
7.19	5	0.7%
7.2	5	0.7%
7.21	5	0.7%
7.22	4	0.5%
7.23	5	0.7%
7.24	5	0.7%

Value	Count	Frequency (%)
7.53	2	0.3%
7.52	8	1.1%
7.51	30	4.0%
7.5	43	5.8%
7.49	54	7.3%
7.48	82	11.0%
7.47	190	25.5%
7.46	114	15.3%
7.45	16	2.2%
7.44	9	1.2%

1수원 감시정2
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6605376

Minimum	7.27
Maximum	7.81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	7.27
5-th percentile	7.35
Q1	7.67
median	7.7
Q3	7.74
95-th percentile	7.78
Maximum	7.81
Range	0.54
Interquartile range (IQR)	0.07

Descriptive statistics

Standard deviation	0.12714901
Coefficient of variation (CV)	0.016597922
Kurtosis	1.5235491
Mean	7.6605376
Median Absolute Deviation (MAD)	0.035
Skewness	-1.587336
Sum	5699.44
Variance	0.016166871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.68	87	11.7%
7.69	78	10.5%
7.73	64	8.6%
7.72	52	7.0%
7.7	42	5.6%
7.74	41	5.5%
7.71	38	5.1%
7.77	36	4.8%
7.76	32	4.3%
7.78	31	4.2%
Other values (45)	243	32.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.27	3	0.4%
7.28	5	0.7%
7.29	4	0.5%
7.3	5	0.7%
7.31	4	0.5%
7.32	5	0.7%
7.33	4	0.5%
7.34	5	0.7%
7.35	4	0.5%
7.36	5	0.7%

Value	Count	Frequency (%)
7.81	3	0.4%
7.8	10	1.3%
7.79	10	1.3%
7.78	31	4.2%
7.77	36	4.8%
7.76	32	4.3%
7.75	29	3.9%
7.74	41	5.5%
7.73	64	8.6%
7.72	52	7.0%

1수원 감시정3
Real number (ℝ)

HIGH CORRELATION

Distinct	16
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6166129

Minimum	7.52
Maximum	7.67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	7.52
5-th percentile	7.55
Q1	7.61
median	7.63
Q3	7.63
95-th percentile	7.65
Maximum	7.67
Range	0.15
Interquartile range (IQR)	0.02

Descriptive statistics

Standard deviation	0.030409155
Coefficient of variation (CV)	0.0039924774
Kurtosis	0.91330374
Mean	7.6166129
Median Absolute Deviation (MAD)	0.01
Skewness	-1.1827883
Sum	5666.76
Variance	0.00092471671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
7.63	191	25.7%
7.62	136	18.3%
7.64	101	13.6%
7.61	58	7.8%
7.65	54	7.3%
7.57	34	4.6%
7.6	30	4.0%
7.59	29	3.9%
7.55	25	3.4%
7.66	25	3.4%
Other values (6)	61	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.52	5	0.7%
7.53	8	1.1%
7.54	15	2.0%
7.55	25	3.4%
7.56	14	1.9%
7.57	34	4.6%
7.58	14	1.9%
7.59	29	3.9%
7.6	30	4.0%
7.61	58	7.8%

Value	Count	Frequency (%)
7.67	5	0.7%
7.66	25	3.4%
7.65	54	7.3%
7.64	101	13.6%
7.63	191	25.7%
7.62	136	18.3%
7.61	58	7.8%
7.6	30	4.0%
7.59	29	3.9%
7.58	14	1.9%

2수원 감시정1
Real number (ℝ)

HIGH CORRELATION

Distinct	114
Distinct (%)	15.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.040336

Minimum	7.19
Maximum	8.67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	7.19
5-th percentile	7.43
Q1	7.7
median	8.21
Q3	8.36
95-th percentile	8.39
Maximum	8.67
Range	1.48
Interquartile range (IQR)	0.66

Descriptive statistics

Standard deviation	0.35346395
Coefficient of variation (CV)	0.043961341
Kurtosis	-1.2212751
Mean	8.040336
Median Absolute Deviation (MAD)	0.17
Skewness	-0.56425402
Sum	5982.01
Variance	0.12493676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.38	57	7.7%
8.37	53	7.1%
8.39	50	6.7%
8.36	34	4.6%
8.35	30	4.0%
8.34	19	2.6%
8.3	13	1.7%
8.4	13	1.7%
8.33	13	1.7%
8.32	12	1.6%
Other values (104)	450	60.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.19	1	0.1%
7.24	1	0.1%
7.28	1	0.1%
7.29	1	0.1%
7.31	2	0.3%
7.32	1	0.1%
7.33	4	0.5%
7.34	4	0.5%
7.35	4	0.5%
7.36	3	0.4%

Value	Count	Frequency (%)
8.67	1	0.1%
8.4	13	1.7%
8.39	50	6.7%
8.38	57	7.7%
8.37	53	7.1%
8.36	34	4.6%
8.35	30	4.0%
8.34	19	2.6%
8.33	13	1.7%
8.32	12	1.6%

2수원 감시정2
Real number (ℝ)

Distinct	26
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3424731

Minimum	8.19
Maximum	8.44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	8.19
5-th percentile	8.23
Q1	8.2975
median	8.35
Q3	8.4
95-th percentile	8.42
Maximum	8.44
Range	0.25
Interquartile range (IQR)	0.1025

Descriptive statistics

Standard deviation	0.06093539
Coefficient of variation (CV)	0.0073042357
Kurtosis	-0.95466101
Mean	8.3424731
Median Absolute Deviation (MAD)	0.05
Skewness	-0.39457398
Sum	6206.8
Variance	0.0037131218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
8.41	76	10.2%
8.42	56	7.5%
8.4	54	7.3%
8.29	43	5.8%
8.38	39	5.2%
8.39	39	5.2%
8.34	39	5.2%
8.36	37	5.0%
8.31	36	4.8%
8.32	35	4.7%
Other values (16)	290	39.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.19	1	0.1%
8.2	2	0.3%
8.21	3	0.4%
8.22	15	2.0%
8.23	24	3.2%
8.24	16	2.2%
8.25	24	3.2%
8.26	19	2.6%
8.27	16	2.2%
8.28	23	3.1%

Value	Count	Frequency (%)
8.44	2	0.3%
8.43	18	2.4%
8.42	56	7.5%
8.41	76	10.2%
8.4	54	7.3%
8.39	39	5.2%
8.38	39	5.2%
8.37	32	4.3%
8.36	37	5.0%
8.35	34	4.6%

2수원 감시정3
Real number (ℝ)

Distinct	31
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8236962

Minimum	7.69
Maximum	7.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 KiB

Quantile statistics

Minimum	7.69
5-th percentile	7.73
Q1	7.78
median	7.82
Q3	7.86
95-th percentile	7.93
Maximum	7.99
Range	0.3
Interquartile range (IQR)	0.08

Descriptive statistics

Standard deviation	0.059127066
Coefficient of variation (CV)	0.0075574337
Kurtosis	-0.15303909
Mean	7.8236962
Median Absolute Deviation (MAD)	0.04
Skewness	0.36186896
Sum	5820.83
Variance	0.0034960099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
7.81	59	7.9%
7.8	57	7.7%
7.84	52	7.0%
7.82	50	6.7%
7.79	48	6.5%
7.83	47	6.3%
7.78	45	6.0%
7.85	39	5.2%
7.77	33	4.4%
7.91	30	4.0%
Other values (21)	284	38.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.69	1	0.1%
7.7	6	0.8%
7.71	9	1.2%
7.72	10	1.3%
7.73	20	2.7%
7.74	17	2.3%
7.75	25	3.4%
7.76	27	3.6%
7.77	33	4.4%
7.78	45	6.0%

Value	Count	Frequency (%)
7.99	2	0.3%
7.98	4	0.5%
7.97	7	0.9%
7.96	6	0.8%
7.95	5	0.7%
7.94	9	1.2%
7.93	8	1.1%
7.92	13	1.7%
7.91	30	4.0%
7.9	16	2.2%

Phik (φk)
Auto

Heatmap
Table

	1수원 감시정1	1수원 감시정2	1수원 감시정3	2수원 감시정1	2수원 감시정2	2수원 감시정3
1수원 감시정1	1.000	0.953	0.827	0.637	0.450	0.562
1수원 감시정2	0.953	1.000	0.872	0.784	0.436	0.681
1수원 감시정3	0.827	0.872	1.000	0.569	0.350	0.451
2수원 감시정1	0.637	0.784	0.569	1.000	0.340	0.320
2수원 감시정2	0.450	0.436	0.350	0.340	1.000	0.168
2수원 감시정3	0.562	0.681	0.451	0.320	0.168	1.000

Heatmap
Table

	1수원 감시정1	1수원 감시정2	1수원 감시정3	2수원 감시정1	2수원 감시정2	2수원 감시정3
1수원 감시정1	1.000	0.467	0.580	-0.108	0.206	-0.039
1수원 감시정2	0.467	1.000	0.683	-0.639	0.133	0.044
1수원 감시정3	0.580	0.683	1.000	-0.305	0.251	-0.073
2수원 감시정1	-0.108	-0.639	-0.305	1.000	0.055	-0.221
2수원 감시정2	0.206	0.133	0.251	0.055	1.000	-0.053
2수원 감시정3	-0.039	0.044	-0.073	-0.221	-0.053	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

	일시	1수원 감시정1	1수원 감시정2	1수원 감시정3	2수원 감시정1	2수원 감시정2	2수원 감시정3
0	2024-03-01 00:00	7.15	7.27	7.55	8.19	8.25	7.8
1	2024-03-01 01:00	7.15	7.27	7.6	8.19	8.26	7.77
2	2024-03-01 02:00	7.15	7.27	7.6	8.2	8.27	7.8
3	2024-03-01 03:00	7.15	7.28	7.59	8.2	8.28	7.77
4	2024-03-01 04:00	7.15	7.28	7.56	8.21	8.29	7.78
5	2024-03-01 05:00	7.16	7.28	7.57	8.21	8.3	7.79
6	2024-03-01 06:00	7.16	7.28	7.57	8.22	8.31	7.82
7	2024-03-01 07:00	7.16	7.28	7.57	8.22	8.32	7.8
8	2024-03-01 08:00	7.16	7.29	7.57	8.23	8.33	7.77
9	2024-03-01 09:00	7.16	7.29	7.57	8.2	8.31	7.8

	일시	1수원 감시정1	1수원 감시정2	1수원 감시정3	2수원 감시정1	2수원 감시정2	2수원 감시정3
734	2024-03-31 14:00	7.35	7.78	7.61	7.55	8.31	7.9
735	2024-03-31 15:00	7.34	7.78	7.62	7.57	8.41	7.86
736	2024-03-31 16:00	7.35	7.78	7.66	7.5	8.39	7.88
737	2024-03-31 17:00	7.33	7.8	7.63	7.38	8.37	7.85
738	2024-03-31 18:00	7.34	7.79	7.62	7.59	8.38	7.89
739	2024-03-31 19:00	7.34	7.79	7.62	7.67	8.35	7.83
740	2024-03-31 20:00	7.33	7.79	7.61	7.68	8.35	7.88
741	2024-03-31 21:00	7.33	7.8	7.62	7.67	8.34	7.87
742	2024-03-31 22:00	7.35	7.8	7.65	7.7	8.42	7.93
743	2024-03-31 23:00	7.34	7.8	7.63	7.43	8.36	7.85

Overview

Variables

Interactions

Correlations

Missing values

Sample