Overview

Dataset statistics

Number of variables12
Number of observations453
Missing cells479
Missing cells (%)8.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory43.5 KiB
Average record size in memory98.3 B

Variable types

Numeric2
Text2
Categorical8

Dataset

Description부산광역시_먹는물공동시설(약수터)수질검사결과정보_20220930
Author부산광역시
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15083355

Alerts

미검사사유 is highly overall correlated with 검사여부 and 1 other fieldsHigh correlation
총대장균군 is highly overall correlated with 검사여부 and 3 other fieldsHigh correlation
분원성대장균군 is highly overall correlated with 검사여부 and 3 other fieldsHigh correlation
검사여부 is highly overall correlated with 일반세균 중온 and 6 other fieldsHigh correlation
암모니아성 질소 is highly overall correlated with 번호 and 7 other fieldsHigh correlation
검사일자 is highly overall correlated with 번호 and 2 other fieldsHigh correlation
과망간산칼륨소비량 is highly overall correlated with 검사여부 and 1 other fieldsHigh correlation
검사결과 is highly overall correlated with 검사여부 and 3 other fieldsHigh correlation
번호 is highly overall correlated with 검사일자 and 1 other fieldsHigh correlation
일반세균 중온 is highly overall correlated with 검사여부 and 1 other fieldsHigh correlation
일반세균 중온 has 240 (53.0%) missing valuesMissing
질산성 질소 has 239 (52.8%) missing valuesMissing
번호 has unique valuesUnique
일반세균 중온 has 98 (21.6%) zerosZeros

Reproduction

Analysis started2024-03-13 13:14:11.518061
Analysis finished2024-03-13 13:14:13.237394
Duration1.72 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct453
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean227
Minimum1
Maximum453
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.1 KiB
2024-03-13T22:14:13.322179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile23.6
Q1114
median227
Q3340
95-th percentile430.4
Maximum453
Range452
Interquartile range (IQR)226

Descriptive statistics

Standard deviation130.91409
Coefficient of variation (CV)0.57671407
Kurtosis-1.2
Mean227
Median Absolute Deviation (MAD)113
Skewness0
Sum102831
Variance17138.5
MonotonicityStrictly increasing
2024-03-13T22:14:13.478302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
285 1
 
0.2%
311 1
 
0.2%
310 1
 
0.2%
309 1
 
0.2%
308 1
 
0.2%
307 1
 
0.2%
306 1
 
0.2%
305 1
 
0.2%
304 1
 
0.2%
Other values (443) 443
97.8%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
453 1
0.2%
452 1
0.2%
451 1
0.2%
450 1
0.2%
449 1
0.2%
448 1
0.2%
447 1
0.2%
446 1
0.2%
445 1
0.2%
444 1
0.2%

공동시설명
Text

Distinct151
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
2024-03-13T22:14:13.766545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length7.1721854
Min length5

Characters and Unicode

Total characters3249
Distinct characters163
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서구 서대신동 꽃마을
2nd row서구 중앙공원민속관
3rd row서구 중앙공원석탑
4th row서구 중앙공원구이
5th row서구 중앙공원옥천
ValueCountFrequency (%)
부산진구 72
 
7.9%
사상구 54
 
5.9%
금정구 45
 
4.9%
사하구 45
 
4.9%
북구 39
 
4.3%
남구 36
 
3.9%
영도구 30
 
3.3%
해운대구 30
 
3.3%
동래구 30
 
3.3%
서구 21
 
2.3%
Other values (151) 510
55.9%
2024-03-13T22:14:14.302680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
459
 
14.1%
구 453
 
13.9%
산 135
 
4.2%
사 132
 
4.1%
정 108
 
3.3%
부 78
 
2.4%
수 78
 
2.4%
진 72
 
2.2%
동 69
 
2.1%
금 66
 
2.0%
Other values (153) 1599
49.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2727
83.9%
Space Separator 459
 
14.1%
Open Punctuation 24
 
0.7%
Close Punctuation 24
 
0.7%
Decimal Number 15
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 453
 
16.6%
산 135
 
5.0%
사 132
 
4.8%
정 108
 
4.0%
부 78
 
2.9%
수 78
 
2.9%
진 72
 
2.6%
동 69
 
2.5%
금 66
 
2.4%
상 57
 
2.1%
Other values (147) 1479
54.2%
Decimal Number
ValueCountFrequency (%)
1 6
40.0%
2 6
40.0%
4 3
20.0%
Space Separator
ValueCountFrequency (%)
459
100.0%
Open Punctuation
ValueCountFrequency (%)
( 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2727
83.9%
Common 522
 
16.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 453
 
16.6%
산 135
 
5.0%
사 132
 
4.8%
정 108
 
4.0%
부 78
 
2.9%
수 78
 
2.9%
진 72
 
2.6%
동 69
 
2.5%
금 66
 
2.4%
상 57
 
2.1%
Other values (147) 1479
54.2%
Common
ValueCountFrequency (%)
459
87.9%
( 24
 
4.6%
) 24
 
4.6%
1 6
 
1.1%
2 6
 
1.1%
4 3
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2727
83.9%
ASCII 522
 
16.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
459
87.9%
( 24
 
4.6%
) 24
 
4.6%
1 6
 
1.1%
2 6
 
1.1%
4 3
 
0.6%
Hangul
ValueCountFrequency (%)
구 453
 
16.6%
산 135
 
5.0%
사 132
 
4.8%
정 108
 
4.0%
부 78
 
2.9%
수 78
 
2.9%
진 72
 
2.6%
동 69
 
2.5%
금 66
 
2.4%
상 57
 
2.1%
Other values (147) 1479
54.2%

검사여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
미검사
240 
검사
213 

Length

Max length3
Median length3
Mean length2.5298013
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미검사
2nd row미검사
3rd row미검사
4th row미검사
5th row미검사

Common Values

ValueCountFrequency (%)
미검사 240
53.0%
검사 213
47.0%

Length

2024-03-13T22:14:14.462141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:14.579651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미검사 240
53.0%
검사 213
47.0%

미검사사유
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
213 
안심등급
172 
양호등급
37 
지정취소
22 
수원고갈
 
8

Length

Max length5
Median length4
Mean length4.0022075
Min length4

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row안심등급
2nd row안심등급
3rd row안심등급
4th row안심등급
5th row안심등급

Common Values

ValueCountFrequency (%)
<NA> 213
47.0%
안심등급 172
38.0%
양호등급 37
 
8.2%
지정취소 22
 
4.9%
수원고갈 8
 
1.8%
수량 부족 1
 
0.2%

Length

2024-03-13T22:14:14.689087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:14.801652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 213
46.9%
안심등급 172
37.9%
양호등급 37
 
8.1%
지정취소 22
 
4.8%
수원고갈 8
 
1.8%
수량 1
 
0.2%
부족 1
 
0.2%

검사일자
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
237 
2022-09-20
 
23
2022-09-14
 
21
2022-07-12
 
19
2022-07-06
 
18
Other values (17)
135 

Length

Max length10
Median length4
Mean length6.8609272
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 237
52.3%
2022-09-20 23
 
5.1%
2022-09-14 21
 
4.6%
2022-07-12 19
 
4.2%
2022-07-06 18
 
4.0%
2022-08-29 16
 
3.5%
2022-07-26 14
 
3.1%
2022-09-13 13
 
2.9%
2022-08-23 12
 
2.6%
2022-08-30 12
 
2.6%
Other values (12) 68
 
15.0%

Length

2024-03-13T22:14:14.931535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 237
52.3%
2022-09-20 23
 
5.1%
2022-09-14 21
 
4.6%
2022-07-12 19
 
4.2%
2022-07-06 18
 
4.0%
2022-08-29 16
 
3.5%
2022-07-26 14
 
3.1%
2022-09-13 13
 
2.9%
2022-08-23 12
 
2.6%
2022-08-30 12
 
2.6%
Other values (12) 68
 
15.0%

검사결과
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
240 
적합
143 
부적합
70 

Length

Max length4
Median length4
Mean length3.214128
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 240
53.0%
적합 143
31.6%
부적합 70
 
15.5%

Length

2024-03-13T22:14:15.110051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:15.231822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 240
53.0%
적합 143
31.6%
부적합 70
 
15.5%

일반세균 중온
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct60
Distinct (%)28.2%
Missing240
Missing (%)53.0%
Infinite0
Infinite (%)0.0%
Mean30.220657
Minimum0
Maximum700
Zeros98
Zeros (%)21.6%
Negative0
Negative (%)0.0%
Memory size4.1 KiB
2024-03-13T22:14:15.391108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q320
95-th percentile144
Maximum700
Range700
Interquartile range (IQR)20

Descriptive statistics

Standard deviation79.732058
Coefficient of variation (CV)2.6383297
Kurtosis30.467225
Mean30.220657
Median Absolute Deviation (MAD)1
Skewness4.9251363
Sum6437
Variance6357.2011
MonotonicityNot monotonic
2024-03-13T22:14:15.525877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 98
21.6%
1 11
 
2.4%
2 9
 
2.0%
7 5
 
1.1%
10 5
 
1.1%
3 5
 
1.1%
4 5
 
1.1%
20 4
 
0.9%
9 4
 
0.9%
5 3
 
0.7%
Other values (50) 64
 
14.1%
(Missing) 240
53.0%
ValueCountFrequency (%)
0 98
21.6%
1 11
 
2.4%
2 9
 
2.0%
3 5
 
1.1%
4 5
 
1.1%
5 3
 
0.7%
6 1
 
0.2%
7 5
 
1.1%
8 2
 
0.4%
9 4
 
0.9%
ValueCountFrequency (%)
700 1
0.2%
450 1
0.2%
400 1
0.2%
380 1
0.2%
301 1
0.2%
295 1
0.2%
200 1
0.2%
183 1
0.2%
160 1
0.2%
156 1
0.2%

총대장균군
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
240 
불검출
145 
검출
68 

Length

Max length4
Median length4
Mean length3.3796909
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 240
53.0%
불검출 145
32.0%
검출 68
 
15.0%

Length

2024-03-13T22:14:15.661193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:15.789774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 240
53.0%
불검출 145
32.0%
검출 68
 
15.0%

분원성대장균군
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
240 
불검출
172 
검출
41 

Length

Max length4
Median length4
Mean length3.4392936
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 240
53.0%
불검출 172
38.0%
검출 41
 
9.1%

Length

2024-03-13T22:14:15.936470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:16.059468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 240
53.0%
불검출 172
38.0%
검출 41
 
9.1%

암모니아성 질소
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
239 
불검출
214 

Length

Max length4
Median length4
Mean length3.5275938
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 239
52.8%
불검출 214
47.2%

Length

2024-03-13T22:14:16.192539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:14:16.328419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 239
52.8%
불검출 214
47.2%

질산성 질소
Text

MISSING 

Distinct56
Distinct (%)26.2%
Missing239
Missing (%)52.8%
Memory size3.7 KiB
2024-03-13T22:14:16.551151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.7943925
Min length1

Characters and Unicode

Total characters598
Distinct characters14
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique19 ?
Unique (%)8.9%

Sample

1st row2
2nd row2.2
3rd row5.9
4th row2.8
5th row1.1
ValueCountFrequency (%)
불검출 24
 
11.2%
1.1 11
 
5.1%
2.3 9
 
4.2%
1.3 9
 
4.2%
1 8
 
3.7%
1.4 8
 
3.7%
1.6 7
 
3.3%
1.8 7
 
3.3%
1.7 7
 
3.3%
0.8 7
 
3.3%
Other values (46) 117
54.7%
2024-03-13T22:14:16.943048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 168
28.1%
1 94
15.7%
2 63
 
10.5%
3 43
 
7.2%
4 30
 
5.0%
0 26
 
4.3%
8 25
 
4.2%
불 24
 
4.0%
검 24
 
4.0%
출 24
 
4.0%
Other values (4) 77
12.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 358
59.9%
Other Punctuation 168
28.1%
Other Letter 72
 
12.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 94
26.3%
2 63
17.6%
3 43
12.0%
4 30
 
8.4%
0 26
 
7.3%
8 25
 
7.0%
6 24
 
6.7%
7 19
 
5.3%
9 18
 
5.0%
5 16
 
4.5%
Other Letter
ValueCountFrequency (%)
불 24
33.3%
검 24
33.3%
출 24
33.3%
Other Punctuation
ValueCountFrequency (%)
. 168
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 526
88.0%
Hangul 72
 
12.0%

Most frequent character per script

Common
ValueCountFrequency (%)
. 168
31.9%
1 94
17.9%
2 63
 
12.0%
3 43
 
8.2%
4 30
 
5.7%
0 26
 
4.9%
8 25
 
4.8%
6 24
 
4.6%
7 19
 
3.6%
9 18
 
3.4%
Hangul
ValueCountFrequency (%)
불 24
33.3%
검 24
33.3%
출 24
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 526
88.0%
Hangul 72
 
12.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 168
31.9%
1 94
17.9%
2 63
 
12.0%
3 43
 
8.2%
4 30
 
5.7%
0 26
 
4.9%
8 25
 
4.8%
6 24
 
4.6%
7 19
 
3.6%
9 18
 
3.4%
Hangul
ValueCountFrequency (%)
불 24
33.3%
검 24
33.3%
출 24
33.3%

과망간산칼륨소비량
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size3.7 KiB
<NA>
240 
불검출
105 
0.3
72 
0.4
 
18
0.6
 
6
Other values (6)
 
12

Length

Max length4
Median length4
Mean length3.5298013
Min length3

Unique

Unique4 ?
Unique (%)0.9%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 240
53.0%
불검출 105
23.2%
0.3 72
 
15.9%
0.4 18
 
4.0%
0.6 6
 
1.3%
0.5 6
 
1.3%
0.7 2
 
0.4%
5.2 1
 
0.2%
3.3 1
 
0.2%
6.8 1
 
0.2%

Length

2024-03-13T22:14:17.099309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 240
53.0%
불검출 105
23.2%
0.3 72
 
15.9%
0.4 18
 
4.0%
0.6 6
 
1.3%
0.5 6
 
1.3%
0.7 2
 
0.4%
5.2 1
 
0.2%
3.3 1
 
0.2%
6.8 1
 
0.2%

Interactions

2024-03-13T22:14:12.509122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:14:12.309541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:14:12.585896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:14:12.414794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:14:17.210423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호검사여부미검사사유검사일자검사결과일반세균 중온총대장균군분원성대장균군질산성 질소과망간산칼륨소비량
번호1.0000.4620.4650.9520.4620.2210.4930.5100.6020.187
검사여부0.4621.000NaN0.234NaNNaNNaNNaN0.393NaN
미검사사유0.465NaN1.000NaNNaNNaNNaNNaNNaNNaN
검사일자0.9520.234NaN1.0000.3990.0000.4150.3970.7010.000
검사결과0.462NaNNaN0.3991.0000.4490.9990.8790.2600.063
일반세균 중온0.221NaNNaN0.0000.4491.0000.4010.3850.0000.000
총대장균군0.493NaNNaN0.4150.9990.4011.0000.8900.2850.007
분원성대장균군0.510NaNNaN0.3970.8790.3850.8901.0000.3880.194
질산성 질소0.6020.393NaN0.7010.2600.0000.2850.3881.0000.530
과망간산칼륨소비량0.187NaNNaN0.0000.0630.0000.0070.1940.5301.000
2024-03-13T22:14:17.370428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
미검사사유총대장균군분원성대장균군검사여부암모니아성 질소검사일자과망간산칼륨소비량검사결과
미검사사유1.000NaNNaN1.000NaN1.000NaNNaN
총대장균군NaN1.0000.6981.0001.0000.3480.0000.968
분원성대장균군NaN0.6981.0001.0001.0000.3330.1450.683
검사여부1.0001.0001.0001.0001.0000.1951.0001.000
암모니아성 질소NaN1.0001.0001.0001.0001.0001.0001.000
검사일자1.0000.3480.3330.1951.0001.0000.0000.334
과망간산칼륨소비량NaN0.0000.1451.0001.0000.0001.0000.046
검사결과NaN0.9680.6831.0001.0000.3340.0461.000
2024-03-13T22:14:17.848167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호일반세균 중온검사여부미검사사유검사일자검사결과총대장균군분원성대장균군암모니아성 질소과망간산칼륨소비량
번호1.000-0.0930.3520.2880.7440.3480.3720.3851.0000.056
일반세균 중온-0.0931.0001.0000.0000.0000.4750.4240.4081.0000.000
검사여부0.3521.0001.0001.0000.1951.0001.0001.0001.0001.000
미검사사유0.2880.0001.0001.0001.0000.0000.0000.000NaN0.000
검사일자0.7440.0000.1951.0001.0000.3340.3480.3331.0000.000
검사결과0.3480.4751.0000.0000.3341.0000.9680.6831.0000.046
총대장균군0.3720.4241.0000.0000.3480.9681.0000.6981.0000.000
분원성대장균군0.3850.4081.0000.0000.3330.6830.6981.0001.0000.145
암모니아성 질소1.0001.0001.000NaN1.0001.0001.0001.0001.0001.000
과망간산칼륨소비량0.0560.0001.0000.0000.0000.0460.0000.1451.0001.000

Missing values

2024-03-13T22:14:12.737004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:14:12.949576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2024-03-13T22:14:13.120549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

번호공동시설명검사여부미검사사유검사일자검사결과일반세균 중온총대장균군분원성대장균군암모니아성 질소질산성 질소과망간산칼륨소비량
01서구 서대신동 꽃마을미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
12서구 중앙공원민속관미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
23서구 중앙공원석탑미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
34서구 중앙공원구이미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
45서구 중앙공원옥천미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
56서구 중앙공원팔각정미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
67서구 남부민동 천마정미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
78동구 만리산미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
89동구 청조미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
910동구 수정샘미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
번호공동시설명검사여부미검사사유검사일자검사결과일반세균 중온총대장균군분원성대장균군암모니아성 질소질산성 질소과망간산칼륨소비량
443444사상구 불심검사<NA>2022-09-13적합0불검출불검출불검출20.3
444445사상구 승학(엄궁)미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
445446사상구 거북미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
446447사상구 삼운정미검사양호등급<NA><NA><NA><NA><NA><NA><NA><NA>
447448사상구 운수사미검사안심등급<NA><NA><NA><NA><NA><NA><NA><NA>
448449사상구 백수검사<NA>2022-09-14부적합7검출검출불검출6.80.4
449450사상구 청수미검사양호등급<NA><NA><NA><NA><NA><NA><NA><NA>
450451사상구 승학(학장)미검사양호등급<NA><NA><NA><NA><NA><NA><NA><NA>
451452기장군 용소검사<NA>2022-09-14부적합10검출검출불검출1.1불검출
452453기장군 불광산검사<NA>2022-09-14적합1불검출불검출불검출0.80.3