gimi9 Pandas Profiling

Dataset statistics

Number of variables	11
Number of observations	2926
Missing cells	63
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	274.4 KiB
Average record size in memory	96.0 B

Variable types

Categorical	1
Text	2
Numeric	8

Dataset

Description	구명,동명,수질측정지점명,전기전도도,PH,잔류염소,탁도,수온,구코드,동코드,측정시간
Author	상수도사업본부
URL	https://data.seoul.go.kr/dataList/OA-13507/S/1/datasetView.do

Alerts

`구코드` is highly overall correlated with `동코드` and 1 other fields	High correlation
`동코드` is highly overall correlated with `구코드` and 1 other fields	High correlation
`구명` is highly overall correlated with `구코드` and 1 other fields	High correlation
`동코드` has 63 (2.2%) missing values	Missing

Reproduction

Analysis started	2024-05-11 09:06:04.573199
Analysis finished	2024-05-11 09:06:30.413378
Duration	25.84 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

구명
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	23.0 KiB

송파구	189
관악구	147
강남구	147
강서구	140
노원구	133
Other values (20)	2170

Length

Max length	4
Median length	3
Mean length	3.076555
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	강남구
2nd row	강남구
3rd row	강남구
4th row	강남구
5th row	강남구

Common Values

Value	Count	Frequency (%)
송파구	189	6.5%
관악구	147	5.0%
강남구	147	5.0%
강서구	140	4.8%
노원구	133	4.5%
성북구	133	4.5%
강동구	133	4.5%
영등포구	126	4.3%
서초구	119	4.1%
종로구	119	4.1%
Other values (15)	1540	52.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
송파구	189	6.5%
강남구	147	5.0%
관악구	147	5.0%
강서구	140	4.8%
노원구	133	4.5%
성북구	133	4.5%
강동구	133	4.5%
영등포구	126	4.3%
서초구	119	4.1%
종로구	119	4.1%
Other values (15)	1540	52.6%

동명
Text

Distinct	417
Distinct (%)	14.3%
Missing	0
Missing (%)	0.0%
Memory size	23.0 KiB

Length

Max length	11
Median length	4
Mean length	3.7942584
Min length	2

Characters and Unicode

Total characters	11102
Distinct characters	188
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	개포1동
2nd row	개포2동
3rd row	개포4동
4th row	논현1동
5th row	논현2동

Value	Count	Frequency (%)
신사동	14	0.5%
정릉4동	7	0.2%
방이1동	7	0.2%
문정2동	7	0.2%
문정1동	7	0.2%
마천2동	7	0.2%
마천1동	7	0.2%
거여2동	7	0.2%
거여1동	7	0.2%
가락본동	7	0.2%
Other values (407)	2849	97.4%

Most occurring characters

Value	Count	Frequency (%)
동	2940	26.5%
1	672	6.1%
2	665	6.0%
3	301	2.7%
신	266	2.4%
4	182	1.6%
가	161	1.5%
화	119	1.1%
계	119	1.1%
상	119	1.1%
Other values (178)	5558	50.1%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	9016	81.2%
Decimal Number	2023	18.2%
Other Punctuation	63	0.6%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	2940	32.6%
신	266	3.0%
가	161	1.8%
화	119	1.3%
계	119	1.3%
상	119	1.3%
곡	112	1.2%
산	112	1.2%
방	112	1.2%
정	105	1.2%
Other values (167)	4851	53.8%

Decimal Number

Value	Count	Frequency (%)
1	672	33.2%
2	665	32.9%
3	301	14.9%
4	182	9.0%
5	77	3.8%
6	49	2.4%
7	42	2.1%
8	21	1.0%
9	7	0.3%
0	7	0.3%

Other Punctuation

Value	Count	Frequency (%)
?	63	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	9016	81.2%
Common	2086	18.8%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	2940	32.6%
신	266	3.0%
가	161	1.8%
화	119	1.3%
계	119	1.3%
상	119	1.3%
곡	112	1.2%
산	112	1.2%
방	112	1.2%
정	105	1.2%
Other values (167)	4851	53.8%

Common

Value	Count	Frequency (%)
1	672	32.2%
2	665	31.9%
3	301	14.4%
4	182	8.7%
5	77	3.7%
?	63	3.0%
6	49	2.3%
7	42	2.0%
8	21	1.0%
9	7	0.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	9016	81.2%
ASCII	2086	18.8%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
동	2940	32.6%
신	266	3.0%
가	161	1.8%
화	119	1.3%
계	119	1.3%
상	119	1.3%
곡	112	1.2%
산	112	1.2%
방	112	1.2%
정	105	1.2%
Other values (167)	4851	53.8%

ASCII

Value	Count	Frequency (%)
1	672	32.2%
2	665	31.9%
3	301	14.4%
4	182	8.7%
5	77	3.7%
?	63	3.0%
6	49	2.3%
7	42	2.0%
8	21	1.0%
9	7	0.3%

수질측정지점명
Text

Distinct	399
Distinct (%)	13.6%
Missing	0
Missing (%)	0.0%
Memory size	23.0 KiB

Length

Max length	18
Median length	17
Mean length	9.7799043
Min length	7

Characters and Unicode

Total characters	28616
Distinct characters	238
Distinct categories	7 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	잠원 [기타]
2nd row	방배3 [기타]
3rd row	개포1 [기타]
4th row	내곡 [배수지]
5th row	방배1 [기타]

Value	Count	Frequency (%)
기타	1421	24.3%
공원	567	9.7%
학교	182	3.1%
배수지	175	3.0%
지역배수지	140	2.4%
관공서	119	2.0%
아파트	98	1.7%
올림터	70	1.2%
소방서	49	0.8%
수도사업소	49	0.8%
Other values (399)	2982	51.0%

Most occurring characters

Value	Count	Frequency (%)
]	2926	10.2%
	2926	10.2%
[	2926	10.2%
동	2366	8.3%
기	1442	5.0%
타	1421	5.0%
공	777	2.7%
원	700	2.4%
1	644	2.3%
2	609	2.1%
Other values (228)	11879	41.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	17003	59.4%
Close Punctuation	3304	11.5%
Open Punctuation	3304	11.5%
Space Separator	2926	10.2%
Decimal Number	1939	6.8%
Uppercase Letter	70	0.2%
Other Punctuation	70	0.2%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	2366	13.9%
기	1442	8.5%
타	1421	8.4%
공	777	4.6%
원	700	4.1%
수	518	3.0%
지	518	3.0%
배	343	2.0%
교	287	1.7%
신	273	1.6%
Other values (210)	8358	49.2%

Decimal Number

Value	Count	Frequency (%)
1	644	33.2%
2	609	31.4%
3	280	14.4%
4	182	9.4%
5	77	4.0%
6	49	2.5%
9	42	2.2%
7	28	1.4%
8	21	1.1%
0	7	0.4%

Close Punctuation

Value	Count	Frequency (%)
]	2926	88.6%
)	378	11.4%

Open Punctuation

Value	Count	Frequency (%)
[	2926	88.6%
(	378	11.4%

Other Punctuation

Value	Count	Frequency (%)
,	49	70.0%
.	21	30.0%

Space Separator

Value	Count	Frequency (%)
	2926	100.0%

Uppercase Letter

Value	Count	Frequency (%)
A	70	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	17003	59.4%
Common	11543	40.3%
Latin	70	0.2%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	2366	13.9%
기	1442	8.5%
타	1421	8.4%
공	777	4.6%
원	700	4.1%
수	518	3.0%
지	518	3.0%
배	343	2.0%
교	287	1.7%
신	273	1.6%
Other values (210)	8358	49.2%

Common

Value	Count	Frequency (%)
]	2926	25.3%
	2926	25.3%
[	2926	25.3%
1	644	5.6%
2	609	5.3%
)	378	3.3%
(	378	3.3%
3	280	2.4%
4	182	1.6%
5	77	0.7%
Other values (7)	217	1.9%

Latin

Value	Count	Frequency (%)
A	70	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	17003	59.4%
ASCII	11613	40.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
]	2926	25.2%
	2926	25.2%
[	2926	25.2%
1	644	5.5%
2	609	5.2%
)	378	3.3%
(	378	3.3%
3	280	2.4%
4	182	1.6%
5	77	0.7%
Other values (8)	287	2.5%

Hangul

Value	Count	Frequency (%)
동	2366	13.9%
기	1442	8.5%
타	1421	8.4%
공	777	4.6%
원	700	4.1%
수	518	3.0%
지	518	3.0%
배	343	2.0%
교	287	1.7%
신	273	1.6%
Other values (210)	8358	49.2%

전기전도도
Real number (ℝ)

Distinct	86
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	181.38448

Minimum	0
Maximum	269
Zeros	7
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	0
5-th percentile	163
Q1	171
median	183
Q3	191
95-th percentile	201
Maximum	269
Range	269
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	15.74105
Coefficient of variation (CV)	0.086782784
Kurtosis	41.387642
Mean	181.38448
Median Absolute Deviation (MAD)	10
Skewness	-3.5504862
Sum	530731
Variance	247.78067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
185	106	3.6%
188	104	3.6%
190	99	3.4%
168	97	3.3%
187	95	3.2%
186	94	3.2%
169	90	3.1%
191	90	3.1%
183	87	3.0%
189	86	2.9%
Other values (76)	1978	67.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	0.2%
120	1	< 0.1%
121	1	< 0.1%
122	1	< 0.1%
123	1	< 0.1%
124	2	0.1%
125	1	< 0.1%
147	1	< 0.1%
148	4	0.1%
149	5	0.2%

Value	Count	Frequency (%)
269	1	< 0.1%
235	4	0.1%
232	2	0.1%
229	2	0.1%
226	2	0.1%
223	2	0.1%
220	2	0.1%
218	2	0.1%
217	1	< 0.1%
216	4	0.1%

PH
Real number (ℝ)

Distinct	10
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.0967532

Minimum	0
Maximum	7.5
Zeros	7
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	0
5-th percentile	6.9
Q1	7
median	7.1
Q3	7.2
95-th percentile	7.3
Maximum	7.5
Range	7.5
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.36522287
Coefficient of variation (CV)	0.051463375
Kurtosis	338.90595
Mean	7.0967532
Median Absolute Deviation (MAD)	0.1
Skewness	-17.56316
Sum	20765.1
Variance	0.13338775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
7.1	1106	37.8%
7.2	824	28.2%
7.0	519	17.7%
7.3	223	7.6%
6.9	162	5.5%
6.8	42	1.4%
7.4	31	1.1%
7.5	7	0.2%
0.0	7	0.2%
6.7	5	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	7	0.2%
6.7	5	0.2%
6.8	42	1.4%
6.9	162	5.5%
7.0	519	17.7%
7.1	1106	37.8%
7.2	824	28.2%
7.3	223	7.6%
7.4	31	1.1%
7.5	7	0.2%

Value	Count	Frequency (%)
7.5	7	0.2%
7.4	31	1.1%
7.3	223	7.6%
7.2	824	28.2%
7.1	1106	37.8%
7.0	519	17.7%
6.9	162	5.5%
6.8	42	1.4%
6.7	5	0.2%
0.0	7	0.2%

잔류염소
Real number (ℝ)

Distinct	38
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28941558

Minimum	0
Maximum	0.49
Zeros	7
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.18
Q1	0.24
median	0.29
Q3	0.33
95-th percentile	0.41
Maximum	0.49
Range	0.49
Interquartile range (IQR)	0.09

Descriptive statistics

Standard deviation	0.071316558
Coefficient of variation (CV)	0.24641575
Kurtosis	0.47888796
Mean	0.28941558
Median Absolute Deviation (MAD)	0.04
Skewness	0.22609824
Sum	846.83
Variance	0.0050860515
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
0.3	210	7.2%
0.29	207	7.1%
0.27	191	6.5%
0.31	177	6.0%
0.32	166	5.7%
0.24	149	5.1%
0.28	148	5.1%
0.26	144	4.9%
0.25	138	4.7%
0.33	102	3.5%
Other values (28)	1294	44.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	7	0.2%
0.13	1	< 0.1%
0.14	11	0.4%
0.15	13	0.4%
0.16	25	0.9%
0.17	59	2.0%
0.18	86	2.9%
0.19	88	3.0%
0.2	85	2.9%
0.21	83	2.8%

Value	Count	Frequency (%)
0.49	10	0.3%
0.48	33	1.1%
0.47	10	0.3%
0.46	23	0.8%
0.45	13	0.4%
0.44	16	0.5%
0.43	14	0.5%
0.42	21	0.7%
0.41	39	1.3%
0.4	41	1.4%

탁도
Real number (ℝ)

Distinct	18
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.054336979

Minimum	0
Maximum	0.19
Zeros	9
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.04
Q1	0.05
median	0.05
Q3	0.06
95-th percentile	0.08
Maximum	0.19
Range	0.19
Interquartile range (IQR)	0.01

Descriptive statistics

Standard deviation	0.013820136
Coefficient of variation (CV)	0.25434126
Kurtosis	18.270835
Mean	0.054336979
Median Absolute Deviation (MAD)	0
Skewness	2.631001
Sum	158.99
Variance	0.00019099615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0.05	1718	58.7%
0.06	398	13.6%
0.04	286	9.8%
0.07	261	8.9%
0.08	152	5.2%
0.03	35	1.2%
0.09	33	1.1%
0.0	9	0.3%
0.02	8	0.3%
0.17	5	0.2%
Other values (8)	21	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	9	0.3%
0.01	4	0.1%
0.02	8	0.3%
0.03	35	1.2%
0.04	286	9.8%
0.05	1718	58.7%
0.06	398	13.6%
0.07	261	8.9%
0.08	152	5.2%
0.09	33	1.1%

Value	Count	Frequency (%)
0.19	1	< 0.1%
0.17	5	0.2%
0.16	2	0.1%
0.15	3	0.1%
0.14	2	0.1%
0.13	4	0.1%
0.11	1	< 0.1%
0.1	4	0.1%
0.09	33	1.1%
0.08	152	5.2%

수온
Real number (ℝ)

Distinct	63
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.613397

Minimum	0
Maximum	20.3
Zeros	7
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	0
5-th percentile	15.8
Q1	17.1
median	17.8
Q3	18.3
95-th percentile	19.2
Maximum	20.3
Range	20.3
Interquartile range (IQR)	1.2

Descriptive statistics

Standard deviation	1.3500104
Coefficient of variation (CV)	0.076646794
Kurtosis	67.641222
Mean	17.613397
Median Absolute Deviation (MAD)	0.6
Skewness	-5.4780227
Sum	51536.8
Variance	1.8225281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.1	141	4.8%
18.3	135	4.6%
17.6	134	4.6%
17.9	133	4.5%
18.2	130	4.4%
17.8	128	4.4%
17.7	124	4.2%
17.5	116	4.0%
18.4	114	3.9%
18.5	105	3.6%
Other values (53)	1666	56.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	7	0.2%
14.1	1	< 0.1%
14.2	8	0.3%
14.4	1	< 0.1%
14.5	5	0.2%
14.6	8	0.3%
14.7	3	0.1%
14.8	4	0.1%
14.9	2	0.1%
15.0	17	0.6%

Value	Count	Frequency (%)
20.3	5	0.2%
20.2	4	0.1%
20.1	6	0.2%
20.0	8	0.3%
19.9	10	0.3%
19.8	17	0.6%
19.7	9	0.3%
19.6	15	0.5%
19.5	9	0.3%
19.4	35	1.2%

구코드
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11136.603

Minimum	11010
Maximum	11250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	11010
5-th percentile	11020
Q1	11070
median	11140
Q3	11210
95-th percentile	11240
Maximum	11250
Range	240
Interquartile range (IQR)	140

Descriptive statistics

Standard deviation	73.909236
Coefficient of variation (CV)	0.0066366052
Kurtosis	-1.2388412
Mean	11136.603
Median Absolute Deviation (MAD)	70
Skewness	-0.091352778
Sum	32585700
Variance	5462.5752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
11240	189	6.5%
11230	147	5.0%
11210	147	5.0%
11160	140	4.8%
11080	133	4.5%
11250	133	4.5%
11110	133	4.5%
11190	126	4.3%
11220	119	4.1%
11010	119	4.1%
Other values (15)	1540	52.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11010	119	4.1%
11020	98	3.3%
11030	112	3.8%
11040	105	3.6%
11050	105	3.6%
11060	98	3.3%
11070	112	3.8%
11080	133	4.5%
11090	91	3.1%
11100	98	3.3%

Value	Count	Frequency (%)
11250	133	4.5%
11240	189	6.5%
11230	147	5.0%
11220	119	4.1%
11210	147	5.0%
11200	98	3.3%
11190	126	4.3%
11180	70	2.4%
11170	112	3.8%
11160	140	4.8%

동코드
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	409
Distinct (%)	14.3%
Missing	63
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	1113791

Minimum	1101053
Maximum	1125074
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	1101053
5-th percentile	1102060
Q1	1107073
median	1114072
Q3	1121052
95-th percentile	1124079
Maximum	1125074
Range	24021
Interquartile range (IQR)	13979

Descriptive statistics

Standard deviation	7349.6264
Coefficient of variation (CV)	0.0065987483
Kurtosis	-1.2357124
Mean	1113791
Median Absolute Deviation (MAD)	6982
Skewness	-0.1071405
Sum	3.1887836 × 10⁹
Variance	54017009
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1108065	7	0.2%
1124069	7	0.2%
1124068	7	0.2%
1124056	7	0.2%
1124055	7	0.2%
1124054	7	0.2%
1124053	7	0.2%
1124065	7	0.2%
1124067	7	0.2%
1124066	7	0.2%
Other values (399)	2793	95.5%
(Missing)	63	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101053	7	0.2%
1101054	7	0.2%
1101055	7	0.2%
1101056	7	0.2%
1101057	7	0.2%
1101058	7	0.2%
1101060	7	0.2%
1101064	7	0.2%
1101067	7	0.2%
1101068	7	0.2%

Value	Count	Frequency (%)
1125074	7	0.2%
1125073	7	0.2%
1125072	7	0.2%
1125071	7	0.2%
1125070	7	0.2%
1125067	7	0.2%
1125066	7	0.2%
1125065	7	0.2%
1125063	7	0.2%
1125061	7	0.2%

측정시간
Real number (ℝ)

Distinct	7
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0240511 × 10⁹

Minimum	2.0240511 × 10⁹
Maximum	2.0240511 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	25.8 KiB

Quantile statistics

Minimum	2.0240511 × 10⁹
5-th percentile	2.0240511 × 10⁹
Q1	2.0240511 × 10⁹
median	2.0240511 × 10⁹
Q3	2.0240511 × 10⁹
95-th percentile	2.0240511 × 10⁹
Maximum	2.0240511 × 10⁹
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0003419
Coefficient of variation (CV)	9.8828623 × 10^-10
Kurtosis	-1.2500853
Mean	2.0240511 × 10⁹
Median Absolute Deviation (MAD)	2
Skewness	0
Sum	5.9223736 × 10¹²
Variance	4.0013675
Monotonicity	Decreasing

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2024051117	418	14.3%
2024051116	418	14.3%
2024051115	418	14.3%
2024051114	418	14.3%
2024051113	418	14.3%
2024051112	418	14.3%
2024051111	418	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2024051111	418	14.3%
2024051112	418	14.3%
2024051113	418	14.3%
2024051114	418	14.3%
2024051115	418	14.3%
2024051116	418	14.3%
2024051117	418	14.3%

Value	Count	Frequency (%)
2024051117	418	14.3%
2024051116	418	14.3%
2024051115	418	14.3%
2024051114	418	14.3%
2024051113	418	14.3%
2024051112	418	14.3%
2024051111	418	14.3%

Phik (φk)
Auto

Heatmap
Table

	구명	전기전도도	PH	잔류염소	탁도	수온	구코드	동코드	측정시간
구명	1.000	0.521	0.339	0.725	0.563	0.604	1.000	1.000	0.000
전기전도도	0.521	1.000	0.768	0.652	0.112	0.666	0.329	0.340	0.000
PH	0.339	0.768	1.000	0.938	0.000	0.718	0.201	0.203	0.000
잔류염소	0.725	0.652	0.938	1.000	0.284	0.707	0.517	0.515	0.000
탁도	0.563	0.112	0.000	0.284	1.000	0.255	0.461	0.443	0.000
수온	0.604	0.666	0.718	0.707	0.255	1.000	0.505	0.487	0.131
구코드	1.000	0.329	0.201	0.517	0.461	0.505	1.000	1.000	0.000
동코드	1.000	0.340	0.203	0.515	0.443	0.487	1.000	1.000	0.000
측정시간	0.000	0.000	0.000	0.000	0.000	0.131	0.000	0.000	1.000

Heatmap
Table

	전기전도도	PH	잔류염소	탁도	수온	구코드	동코드	측정시간	구명
전기전도도	1.000	-0.028	-0.088	0.073	0.020	-0.033	-0.029	-0.081	0.251
PH	-0.028	1.000	0.145	-0.117	0.090	0.081	0.077	-0.043	0.184
잔류염소	-0.088	0.145	1.000	-0.061	0.140	0.418	0.408	0.009	0.378
탁도	0.073	-0.117	-0.061	1.000	-0.148	-0.108	-0.102	0.002	0.234
수온	0.020	0.090	0.140	-0.148	1.000	0.152	0.142	-0.110	0.306
구코드	-0.033	0.081	0.418	-0.108	0.152	1.000	0.999	0.000	0.997
동코드	-0.029	0.077	0.408	-0.102	0.142	0.999	1.000	0.000	0.992
측정시간	-0.081	-0.043	0.009	0.002	-0.110	0.000	0.000	1.000	0.000
구명	0.251	0.184	0.378	0.234	0.306	0.997	0.992	0.000	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

	구명	동명	수질측정지점명	전기전도도	PH	잔류염소	탁도	수온	구코드	동코드	측정시간
0	강남구	개포1동	잠원 [기타]	182	7.0	0.37	0.06	17.2	11230	1123068	2024051117
1	강남구	개포2동	방배3 [기타]	150	7.2	0.48	0.05	17.8	11230	1123080	2024051117
2	강남구	개포4동	개포1 [기타]	171	6.9	0.34	0.05	17.6	11230	1123071	2024051117
3	강남구	논현1동	내곡 [배수지]	170	7.3	0.34	0.05	18.3	11230	1123052	2024051117
4	강남구	논현2동	방배1 [기타]	173	7.0	0.37	0.05	15.9	11230	1123053	2024051117
5	강남구	대치1동	압구정 [기타]	167	7.2	0.32	0.09	17.3	11230	1123060	2024051117
6	강남구	대치2동	개포2 [기타]	191	7.1	0.33	0.07	16.9	11230	1123079	2024051117
7	강남구	대치4동	청담 [기타]	168	7.2	0.35	0.07	17.9	11230	1123063	2024051117
8	강남구	도곡1동	개포4 [기타]	193	7.1	0.36	0.05	17.0	11230	1123066	2024051117
9	강남구	도곡2동	논현동(논현초교) [학교]	185	7.2	0.29	0.05	18.6	11230	1123067	2024051117

	구명	동명	수질측정지점명	전기전도도	PH	잔류염소	탁도	수온	구코드	동코드	측정시간
2916	중랑구	면목7동	면목4동 [학교]	190	7.0	0.2	0.06	17.4	11070	1107057	2024051111
2917	중랑구	면목본동	면목5동 [기타]	182	7.1	0.2	0.06	16.3	11070	1107071	2024051111
2918	중랑구	묵1동	중화1동 [기타]	178	6.9	0.18	0.06	16.0	11070	1107064	2024051111
2919	중랑구	묵2동	중화2동 [기타]	192	7.0	0.16	0.04	16.3	11070	1107065	2024051111
2920	중랑구	상봉1동	면목동(사가정공원) [공원]	193	7.1	0.18	0.05	16.0	11070	1107059	2024051111
2921	중랑구	상봉2동	면목본동 [기타]	179	7.0	0.21	0.09	16.1	11070	1107060	2024051111
2922	중랑구	신내1동	망우동(중랑캠핑숲) [공원]	188	7.2	0.18	0.05	16.4	11070	1107069	2024051111
2923	중랑구	신내2동	망우3동 [기타]	188	6.9	0.17	0.07	16.9	11070	1107070	2024051111
2924	중랑구	중화1동	상봉동(상봉초교) [학교]	156	7.1	0.2	0.04	17.5	11070	1107061	2024051111
2925	중랑구	중화2동	상봉2동 [기타]	189	7.1	0.2	0.04	16.8	11070	1107062	2024051111

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Close Punctuation

Open Punctuation

Other Punctuation

Space Separator

Uppercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample