Overview

Dataset statistics

Number of variables17
Number of observations295
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory40.7 KiB
Average record size in memory141.4 B

Variable types

Numeric1
Categorical15
Text1

Dataset

Description대전광역시 서구 관내 약수터 수질검사 결과(약수터명, 지번/도로명 주소, 검사의뢰일자, 검사항목명, 검사기준 등) 정보를 제공합니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15113085/fileData.do

Alerts

의뢰일자 has constant value ""Constant
데이터기준일자 has constant value ""Constant
위도 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
법정동명 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
검사결과 is highly overall correlated with 도로명주소 and 3 other fieldsHigh correlation
행정동명 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
지번주소 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
도로명주소 is highly overall correlated with 순번 and 12 other fieldsHigh correlation
수질기준초과여부 is highly overall correlated with 도로명주소 and 2 other fieldsHigh correlation
약수터명 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
법정동코드 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
행정동코드 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
적합부적합여부 is highly overall correlated with 도로명주소 and 2 other fieldsHigh correlation
경도 is highly overall correlated with 순번 and 8 other fieldsHigh correlation
검사기준 is highly overall correlated with 도로명주소 and 1 other fieldsHigh correlation
순번 is highly overall correlated with 약수터명 and 8 other fieldsHigh correlation
검사결과 is highly imbalanced (81.7%)Imbalance
적합부적합여부 is highly imbalanced (94.1%)Imbalance
수질기준초과여부 is highly imbalanced (94.1%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2024-04-06 08:09:52.191375
Analysis finished2024-04-06 08:09:55.874571
Duration3.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct295
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean148
Minimum1
Maximum295
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2024-04-06T17:09:56.047158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile15.7
Q174.5
median148
Q3221.5
95-th percentile280.3
Maximum295
Range294
Interquartile range (IQR)147

Descriptive statistics

Standard deviation85.30338
Coefficient of variation (CV)0.57637419
Kurtosis-1.2
Mean148
Median Absolute Deviation (MAD)74
Skewness0
Sum43660
Variance7276.6667
MonotonicityStrictly increasing
2024-04-06T17:09:56.414894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
204 1
 
0.3%
202 1
 
0.3%
201 1
 
0.3%
200 1
 
0.3%
199 1
 
0.3%
198 1
 
0.3%
197 1
 
0.3%
196 1
 
0.3%
195 1
 
0.3%
Other values (285) 285
96.6%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
295 1
0.3%
294 1
0.3%
293 1
0.3%
292 1
0.3%
291 1
0.3%
290 1
0.3%
289 1
0.3%
288 1
0.3%
287 1
0.3%
286 1
0.3%

약수터명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
갈마약수터
59 
내원사약수터
59 
오량약수터
59 
빼울약수터
59 
한천약수터
59 

Length

Max length6
Median length5
Mean length5.2
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row갈마약수터
2nd row갈마약수터
3rd row갈마약수터
4th row갈마약수터
5th row갈마약수터

Common Values

ValueCountFrequency (%)
갈마약수터 59
20.0%
내원사약수터 59
20.0%
오량약수터 59
20.0%
빼울약수터 59
20.0%
한천약수터 59
20.0%

Length

2024-04-06T17:09:56.724544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:56.949735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
갈마약수터 59
20.0%
내원사약수터 59
20.0%
오량약수터 59
20.0%
빼울약수터 59
20.0%
한천약수터 59
20.0%

지번주소
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
대전광역시 서구 갈마동 414-4
59 
대전광역시 서구 도마2동 산7
59 
대전광역시 서구 복수동 336-31
59 
대전광역시 서구 가수원동 618-4
59 
대전광역시 서구 관저동 산68-1
59 

Length

Max length19
Median length18
Mean length18
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대전광역시 서구 갈마동 414-4
2nd row대전광역시 서구 갈마동 414-4
3rd row대전광역시 서구 갈마동 414-4
4th row대전광역시 서구 갈마동 414-4
5th row대전광역시 서구 갈마동 414-4

Common Values

ValueCountFrequency (%)
대전광역시 서구 갈마동 414-4 59
20.0%
대전광역시 서구 도마2동 산7 59
20.0%
대전광역시 서구 복수동 336-31 59
20.0%
대전광역시 서구 가수원동 618-4 59
20.0%
대전광역시 서구 관저동 산68-1 59
20.0%

Length

2024-04-06T17:09:57.233276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:57.438032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대전광역시 295
25.0%
서구 295
25.0%
갈마동 59
 
5.0%
414-4 59
 
5.0%
도마2동 59
 
5.0%
산7 59
 
5.0%
복수동 59
 
5.0%
336-31 59
 
5.0%
가수원동 59
 
5.0%
618-4 59
 
5.0%
Other values (2) 118
 
10.0%

도로명주소
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
<NA>
236 
대전광역시 서구 벌곡로1285번길 182
59 

Length

Max length22
Median length4
Mean length7.6
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> 236
80.0%
대전광역시 서구 벌곡로1285번길 182 59
 
20.0%

Length

2024-04-06T17:09:57.662944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:57.858657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 236
50.0%
대전광역시 59
 
12.5%
서구 59
 
12.5%
벌곡로1285번길 59
 
12.5%
182 59
 
12.5%

행정동코드
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
3017058100
59 
3017053000
59 
3017051000
59 
3017059000
59 
3017059700
59 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3017058100
2nd row3017058100
3rd row3017058100
4th row3017058100
5th row3017058100

Common Values

ValueCountFrequency (%)
3017058100 59
20.0%
3017053000 59
20.0%
3017051000 59
20.0%
3017059000 59
20.0%
3017059700 59
20.0%

Length

2024-04-06T17:09:58.134177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:58.325440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3017058100 59
20.0%
3017053000 59
20.0%
3017051000 59
20.0%
3017059000 59
20.0%
3017059700 59
20.0%

행정동명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
갈마1동
59 
도마2동
59 
복수동
59 
가수원동
59 
관저2동
59 

Length

Max length4
Median length4
Mean length3.8
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row갈마1동
2nd row갈마1동
3rd row갈마1동
4th row갈마1동
5th row갈마1동

Common Values

ValueCountFrequency (%)
갈마1동 59
20.0%
도마2동 59
20.0%
복수동 59
20.0%
가수원동 59
20.0%
관저2동 59
20.0%

Length

2024-04-06T17:09:58.511702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:58.715919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
갈마1동 59
20.0%
도마2동 59
20.0%
복수동 59
20.0%
가수원동 59
20.0%
관저2동 59
20.0%

법정동코드
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
3017011100
59 
3017010300
59 
3017010100
59 
3017011400
59 
3017011600
59 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3017011100
2nd row3017011100
3rd row3017011100
4th row3017011100
5th row3017011100

Common Values

ValueCountFrequency (%)
3017011100 59
20.0%
3017010300 59
20.0%
3017010100 59
20.0%
3017011400 59
20.0%
3017011600 59
20.0%

Length

2024-04-06T17:09:58.937359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:59.219322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3017011100 59
20.0%
3017010300 59
20.0%
3017010100 59
20.0%
3017011400 59
20.0%
3017011600 59
20.0%

법정동명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
갈마동
59 
도마동
59 
복수동
59 
가수원동
59 
관저동
59 

Length

Max length4
Median length3
Mean length3.2
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row갈마동
2nd row갈마동
3rd row갈마동
4th row갈마동
5th row갈마동

Common Values

ValueCountFrequency (%)
갈마동 59
20.0%
도마동 59
20.0%
복수동 59
20.0%
가수원동 59
20.0%
관저동 59
20.0%

Length

2024-04-06T17:09:59.462149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:09:59.680528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
갈마동 59
20.0%
도마동 59
20.0%
복수동 59
20.0%
가수원동 59
20.0%
관저동 59
20.0%

의뢰일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2024-03-29
295 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-29
2nd row2024-03-29
3rd row2024-03-29
4th row2024-03-29
5th row2024-03-29

Common Values

ValueCountFrequency (%)
2024-03-29 295
100.0%

Length

2024-04-06T17:09:59.957383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:00.144532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-29 295
100.0%
Distinct61
Distinct (%)20.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2024-04-06T17:10:00.570333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length5.0576271
Min length1

Characters and Unicode

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

Unique

Unique2 ?
Unique (%)0.7%

Sample

1st row일반세균
2nd row총대장균군
3rd row여시니아균
4th row대장균/분원성대장균군
5th row
ValueCountFrequency (%)
일반세균 5
 
1.7%
5
 
1.7%
카드뮴 5
 
1.7%
클로로포름 5
 
1.7%
브로모디클로로메탄 5
 
1.7%
디브로모클로로메탄 5
 
1.7%
클로랄하이드레이트 5
 
1.7%
디브로모아세토니트릴 5
 
1.7%
디클로로아세토니트릴 5
 
1.7%
트리클로로아세토니트릴 5
 
1.7%
Other values (54) 252
83.4%
2024-04-06T17:10:01.784766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
155
 
10.4%
60
 
4.0%
50
 
3.4%
50
 
3.4%
40
 
2.7%
40
 
2.7%
35
 
2.3%
35
 
2.3%
30
 
2.0%
30
 
2.0%
Other values (106) 967
64.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1445
96.8%
Dash Punctuation 10
 
0.7%
Close Punctuation 10
 
0.7%
Open Punctuation 10
 
0.7%
Space Separator 7
 
0.5%
Other Punctuation 5
 
0.3%
Decimal Number 5
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
155
 
10.7%
60
 
4.2%
50
 
3.5%
50
 
3.5%
40
 
2.8%
40
 
2.8%
35
 
2.4%
35
 
2.4%
30
 
2.1%
30
 
2.1%
Other values (100) 920
63.7%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 5
100.0%
Decimal Number
ValueCountFrequency (%)
3 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1445
96.8%
Common 47
 
3.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
155
 
10.7%
60
 
4.2%
50
 
3.5%
50
 
3.5%
40
 
2.8%
40
 
2.8%
35
 
2.4%
35
 
2.4%
30
 
2.1%
30
 
2.1%
Other values (100) 920
63.7%
Common
ValueCountFrequency (%)
- 10
21.3%
) 10
21.3%
( 10
21.3%
7
14.9%
/ 5
10.6%
3 5
10.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1445
96.8%
ASCII 47
 
3.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
155
 
10.7%
60
 
4.2%
50
 
3.5%
50
 
3.5%
40
 
2.8%
40
 
2.8%
35
 
2.4%
35
 
2.4%
30
 
2.1%
30
 
2.1%
Other values (100) 920
63.7%
ASCII
ValueCountFrequency (%)
- 10
21.3%
) 10
21.3%
( 10
21.3%
7
14.9%
/ 5
10.6%
3 5
10.6%

검사기준
Categorical

HIGH CORRELATION 

Distinct36
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0.01 mg/L 이하
30 
0.1 mg/L 이하
25 
0.03 mg/L 이하
25 
0.3 mg/L 이하
 
15
0.5 mg/L 이하
 
15
Other values (31)
185 

Length

Max length13
Median length12
Mean length10.847458
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row100 CFU/ml이하
2nd row불검출 / 100ml
3rd row불검출 / 2L
4th row불검출 / 100ml
5th row0.01 mg/L 이하

Common Values

ValueCountFrequency (%)
0.01 mg/L 이하 30
 
10.2%
0.1 mg/L 이하 25
 
8.5%
0.03 mg/L 이하 25
 
8.5%
0.3 mg/L 이하 15
 
5.1%
0.5 mg/L 이하 15
 
5.1%
250 mg/L 이하 10
 
3.4%
0.05 mg/L 이하 10
 
3.4%
10 mg/L 이하 10
 
3.4%
불검출 / 100ml 10
 
3.4%
0.02 mg/L 이하 10
 
3.4%
Other values (26) 135
45.8%

Length

2024-04-06T17:10:02.085472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
이하 240
28.6%
mg/l 230
27.4%
0.01 30
 
3.6%
0.1 25
 
3.0%
0.03 25
 
3.0%
20
 
2.4%
0.3 15
 
1.8%
0.5 15
 
1.8%
mg/l이하 15
 
1.8%
불검출 15
 
1.8%
Other values (34) 210
25.0%

검사결과
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct12
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
<NA>
271 
불검출
 
7
0
 
4
1.2 mg/L
 
3
검출
 
2
Other values (7)
 
8

Length

Max length8
Median length4
Mean length4.0474576
Min length1

Unique

Unique6 ?
Unique (%)2.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 271
91.9%
불검출 7
 
2.4%
0 4
 
1.4%
1.2 mg/L 3
 
1.0%
검출 2
 
0.7%
1.1 mg/L 2
 
0.7%
2 1
 
0.3%
2.1 mg/L 1
 
0.3%
2.4 mg/L 1
 
0.3%
4.9 mg/L 1
 
0.3%
Other values (2) 2
 
0.7%

Length

2024-04-06T17:10:02.447541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 271
88.9%
mg/l 10
 
3.3%
불검출 7
 
2.3%
0 4
 
1.3%
1.2 3
 
1.0%
검출 2
 
0.7%
1.1 2
 
0.7%
2 1
 
0.3%
2.1 1
 
0.3%
2.4 1
 
0.3%
Other values (3) 3
 
1.0%

적합부적합여부
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
적합
293 
부적합
 
2

Length

Max length3
Median length2
Mean length2.0067797
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row적합
2nd row부적합
3rd row적합
4th row적합
5th row적합

Common Values

ValueCountFrequency (%)
적합 293
99.3%
부적합 2
 
0.7%

Length

2024-04-06T17:10:02.757657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:02.948763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
적합 293
99.3%
부적합 2
 
0.7%

수질기준초과여부
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
미초과
293 
초과
 
2

Length

Max length3
Median length3
Mean length2.9932203
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미초과
2nd row초과
3rd row미초과
4th row미초과
5th row미초과

Common Values

ValueCountFrequency (%)
미초과 293
99.3%
초과 2
 
0.7%

Length

2024-04-06T17:10:03.143299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:03.351517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미초과 293
99.3%
초과 2
 
0.7%

위도
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
36.345785
59 
36.32528628
59 
36.30756976
59 
36.29221074
59 
36.28373424
59 

Length

Max length11
Median length11
Mean length10.6
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row36.345785
2nd row36.345785
3rd row36.345785
4th row36.345785
5th row36.345785

Common Values

ValueCountFrequency (%)
36.345785 59
20.0%
36.32528628 59
20.0%
36.30756976 59
20.0%
36.29221074 59
20.0%
36.28373424 59
20.0%

Length

2024-04-06T17:10:03.575392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:03.789726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
36.345785 59
20.0%
36.32528628 59
20.0%
36.30756976 59
20.0%
36.29221074 59
20.0%
36.28373424 59
20.0%

경도
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
127.364353
59 
127.3618169
59 
127.3778789
59 
127.3497043
59 
127.3247614
59 

Length

Max length11
Median length11
Mean length10.8
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row127.364353
2nd row127.364353
3rd row127.364353
4th row127.364353
5th row127.364353

Common Values

ValueCountFrequency (%)
127.364353 59
20.0%
127.3618169 59
20.0%
127.3778789 59
20.0%
127.3497043 59
20.0%
127.3247614 59
20.0%

Length

2024-04-06T17:10:04.032720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:04.275625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
127.364353 59
20.0%
127.3618169 59
20.0%
127.3778789 59
20.0%
127.3497043 59
20.0%
127.3247614 59
20.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2024-03-29
295 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-29
2nd row2024-03-29
3rd row2024-03-29
4th row2024-03-29
5th row2024-03-29

Common Values

ValueCountFrequency (%)
2024-03-29 295
100.0%

Length

2024-04-06T17:10:04.531821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:10:04.880540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-29 295
100.0%

Interactions

2024-04-06T17:09:54.782942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:10:05.021763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약수터명지번주소행정동코드행정동명법정동코드법정동명검사항목명검사기준검사결과적합부적합여부수질기준초과여부위도경도
순번1.0001.0001.0001.0001.0001.0001.0000.0000.0000.5690.0000.0001.0001.000
약수터명1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
지번주소1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
행정동코드1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
행정동명1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
법정동코드1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
법정동명1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
검사항목명0.0000.0000.0000.0000.0000.0000.0001.0001.0000.9230.5900.5900.0000.000
검사기준0.0000.0000.0000.0000.0000.0000.0001.0001.0001.0000.3450.3450.0000.000
검사결과0.5690.1360.1360.1360.1360.1360.1360.9231.0001.0001.0001.0000.1360.136
적합부적합여부0.0000.0000.0000.0000.0000.0000.0000.5900.3451.0001.0000.9220.0000.000
수질기준초과여부0.0000.0000.0000.0000.0000.0000.0000.5900.3451.0000.9221.0000.0000.000
위도1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
경도1.0001.0001.0001.0001.0001.0001.0000.0000.0000.1360.0000.0001.0001.000
2024-04-06T17:10:05.345052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도법정동명검사결과행정동명지번주소도로명주소수질기준초과여부약수터명법정동코드행정동코드적합부적합여부경도검사기준
위도1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
법정동명1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
검사결과0.0000.0001.0000.0000.0001.0000.7690.0000.0000.0000.7690.0000.787
행정동명1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
지번주소1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
도로명주소1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
수질기준초과여부0.0000.0000.7690.0000.0001.0001.0000.0000.0000.0000.7470.0000.274
약수터명1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
법정동코드1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
행정동코드1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
적합부적합여부0.0000.0000.7690.0000.0001.0000.7470.0000.0000.0001.0000.0000.274
경도1.0001.0000.0001.0001.0001.0000.0001.0001.0001.0000.0001.0000.000
검사기준0.0000.0000.7870.0000.0001.0000.2740.0000.0000.0000.2740.0001.000
2024-04-06T17:10:05.689390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번약수터명지번주소도로명주소행정동코드행정동명법정동코드법정동명검사기준검사결과적합부적합여부수질기준초과여부위도경도
순번1.0000.9910.9911.0000.9910.9910.9910.9910.0000.2180.0000.0000.9910.991
약수터명0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
지번주소0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
도로명주소1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
행정동코드0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
행정동명0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
법정동코드0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
법정동명0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
검사기준0.0000.0000.0001.0000.0000.0000.0000.0001.0000.7870.2740.2740.0000.000
검사결과0.2180.0000.0001.0000.0000.0000.0000.0000.7871.0000.7690.7690.0000.000
적합부적합여부0.0000.0000.0001.0000.0000.0000.0000.0000.2740.7691.0000.7470.0000.000
수질기준초과여부0.0000.0000.0001.0000.0000.0000.0000.0000.2740.7690.7471.0000.0000.000
위도0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000
경도0.9911.0001.0001.0001.0001.0001.0001.0000.0000.0000.0000.0001.0001.000

Missing values

2024-04-06T17:09:55.109126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:09:55.706710image/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.

Sample

순번약수터명지번주소도로명주소행정동코드행정동명법정동코드법정동명의뢰일자검사항목명검사기준검사결과적합부적합여부수질기준초과여부위도경도데이터기준일자
01갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29일반세균100 CFU/ml이하2적합미초과36.345785127.3643532024-03-29
12갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29총대장균군불검출 / 100ml검출부적합초과36.345785127.3643532024-03-29
23갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29여시니아균불검출 / 2L<NA>적합미초과36.345785127.3643532024-03-29
34갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29대장균/분원성대장균군불검출 / 100ml<NA>적합미초과36.345785127.3643532024-03-29
45갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-290.01 mg/L 이하<NA>적합미초과36.345785127.3643532024-03-29
56갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29불소1.5 mg/L 이하<NA>적합미초과36.345785127.3643532024-03-29
67갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29비소0.01 mg/L 이하<NA>적합미초과36.345785127.3643532024-03-29
78갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29세레늄0.01 mg/L 이하<NA>적합미초과36.345785127.3643532024-03-29
89갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29수은0.001 mg/L이하<NA>적합미초과36.345785127.3643532024-03-29
910갈마약수터대전광역시 서구 갈마동 414-4<NA>3017058100갈마1동3017011100갈마동2024-03-29시안0.01 mg/L 이하<NA>적합미초과36.345785127.3643532024-03-29
순번약수터명지번주소도로명주소행정동코드행정동명법정동코드법정동명의뢰일자검사항목명검사기준검사결과적합부적합여부수질기준초과여부위도경도데이터기준일자
285286한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29아연3 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
286287한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29염소이온250 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
287288한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29증발잔류물<NA><NA>적합미초과36.283734127.3247612024-03-29
288289한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-290.3 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
289290한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29망간0.3 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
290291한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29탁도1 NTU 이하<NA>적합미초과36.283734127.3247612024-03-29
291292한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29황산이온250 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
292293한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29알루미늄0.2 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
293294한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29다이옥산0.05 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29
294295한천약수터대전광역시 서구 관저동 산68-1<NA>3017059700관저2동3017011600관저동2024-03-29우라늄0.03 mg/L 이하<NA>적합미초과36.283734127.3247612024-03-29