Overview

Dataset statistics

Number of variables9
Number of observations45
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory74.8 B

Variable types

Text2
DateTime1
Categorical6

Dataset

Description부산광역시 북구 관내에 있는 수질검사 대상 지하수(관정)에 대한 데이터로 위치, 수질검사기관과 검사 결과를 제공합니다.
Author부산광역시 북구
URLhttps://www.data.go.kr/data/15026573/fileData.do

Alerts

검사결과 has constant value ""Constant
용도 has constant value ""Constant
음용여부 is highly overall correlated with 검사종류High correlation
검사종류 is highly overall correlated with 음용여부High correlation

Reproduction

Analysis started2024-03-14 23:44:02.295577
Analysis finished2024-03-14 23:44:03.758680
Duration1.46 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct44
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size488.0 B
2024-03-15T08:44:04.460869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length7.2888889
Min length7

Characters and Unicode

Total characters328
Distinct characters13
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

Unique43 ?
Unique (%)95.6%

Sample

1st row부산9-1216
2nd row부산8-675
3rd row부산8-119
4th row부산8-069
5th row부산8-188
ValueCountFrequency (%)
부산8-188 2
 
4.4%
부산9-1216 1
 
2.2%
부산8-1040 1
 
2.2%
부산8-1046 1
 
2.2%
부산8-875 1
 
2.2%
부산8-894 1
 
2.2%
부산8-910 1
 
2.2%
부산8-936 1
 
2.2%
부산8-941 1
 
2.2%
부산8-956 1
 
2.2%
Other values (34) 34
75.6%
2024-03-15T08:44:05.755174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 57
17.4%
부 45
13.7%
산 45
13.7%
- 45
13.7%
1 39
11.9%
9 20
 
6.1%
0 16
 
4.9%
6 15
 
4.6%
7 13
 
4.0%
2 11
 
3.4%
Other values (3) 22
 
6.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 193
58.8%
Other Letter 90
27.4%
Dash Punctuation 45
 
13.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 57
29.5%
1 39
20.2%
9 20
 
10.4%
0 16
 
8.3%
6 15
 
7.8%
7 13
 
6.7%
2 11
 
5.7%
4 9
 
4.7%
3 7
 
3.6%
5 6
 
3.1%
Other Letter
ValueCountFrequency (%)
부 45
50.0%
산 45
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 45
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 238
72.6%
Hangul 90
 
27.4%

Most frequent character per script

Common
ValueCountFrequency (%)
8 57
23.9%
- 45
18.9%
1 39
16.4%
9 20
 
8.4%
0 16
 
6.7%
6 15
 
6.3%
7 13
 
5.5%
2 11
 
4.6%
4 9
 
3.8%
3 7
 
2.9%
Hangul
ValueCountFrequency (%)
부 45
50.0%
산 45
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 238
72.6%
Hangul 90
 
27.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 57
23.9%
- 45
18.9%
1 39
16.4%
9 20
 
8.4%
0 16
 
6.7%
6 15
 
6.3%
7 13
 
5.5%
2 11
 
4.6%
4 9
 
3.8%
3 7
 
2.9%
Hangul
ValueCountFrequency (%)
부 45
50.0%
산 45
50.0%

검사일자
Date

Distinct32
Distinct (%)71.1%
Missing0
Missing (%)0.0%
Memory size488.0 B
Minimum2023-01-10 00:00:00
Maximum2023-12-20 00:00:00
2024-03-15T08:44:05.988166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:44:06.384708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)

검사종류
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size488.0 B
생활용수
28 
음용수(기타 먹는물)
17 

Length

Max length11
Median length4
Mean length6.6444444
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활용수
2nd row생활용수
3rd row음용수(기타 먹는물)
4th row음용수(기타 먹는물)
5th row생활용수

Common Values

ValueCountFrequency (%)
생활용수 28
62.2%
음용수(기타 먹는물) 17
37.8%

Length

2024-03-15T08:44:06.641058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:06.871437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활용수 28
45.2%
음용수(기타 17
27.4%
먹는물 17
27.4%

검사결과
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size488.0 B
합격
45 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row합격
2nd row합격
3rd row합격
4th row합격
5th row합격

Common Values

ValueCountFrequency (%)
합격 45
100.0%

Length

2024-03-15T08:44:07.138353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:07.479577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
합격 45
100.0%

검사기관명
Categorical

Distinct6
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size488.0 B
동의분석센터
26 
누리생명과학원(주)
13 
(주)그린환경연구원
 
2
아이센주식회사
 
2
누리생명과학원
 
1

Length

Max length10
Median length6
Mean length7.4444444
Min length6

Unique

Unique2 ?
Unique (%)4.4%

Sample

1st row(주)그린환경연구원
2nd row동의분석센터
3rd row동의분석센터
4th row누리생명과학원(주)
5th row동의분석센터

Common Values

ValueCountFrequency (%)
동의분석센터 26
57.8%
누리생명과학원(주) 13
28.9%
(주)그린환경연구원 2
 
4.4%
아이센주식회사 2
 
4.4%
누리생명과학원 1
 
2.2%
낙동강유역환경청 1
 
2.2%

Length

2024-03-15T08:44:07.741868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:07.964382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동의분석센터 26
57.8%
누리생명과학원(주 13
28.9%
주)그린환경연구원 2
 
4.4%
아이센주식회사 2
 
4.4%
누리생명과학원 1
 
2.2%
낙동강유역환경청 1
 
2.2%

용도
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size488.0 B
생활용
45 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활용
2nd row생활용
3rd row생활용
4th row생활용
5th row생활용

Common Values

ValueCountFrequency (%)
생활용 45
100.0%

Length

2024-03-15T08:44:08.344097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:08.666161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활용 45
100.0%

세부용도
Categorical

Distinct4
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size488.0 B
일반용
30 
공동주택용
7 
가정용
7 
기타
 
1

Length

Max length5
Median length3
Mean length3.2888889
Min length2

Unique

Unique1 ?
Unique (%)2.2%

Sample

1st row일반용
2nd row일반용
3rd row일반용
4th row공동주택용
5th row일반용

Common Values

ValueCountFrequency (%)
일반용 30
66.7%
공동주택용 7
 
15.6%
가정용 7
 
15.6%
기타 1
 
2.2%

Length

2024-03-15T08:44:08.918691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:09.132020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반용 30
66.7%
공동주택용 7
 
15.6%
가정용 7
 
15.6%
기타 1
 
2.2%

음용여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size488.0 B
비음용
28 
음용
17 

Length

Max length3
Median length3
Mean length2.6222222
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row비음용
2nd row비음용
3rd row음용
4th row음용
5th row비음용

Common Values

ValueCountFrequency (%)
비음용 28
62.2%
음용 17
37.8%

Length

2024-03-15T08:44:09.352445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:44:09.556113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
비음용 28
62.2%
음용 17
37.8%

관정위치
Text

Distinct44
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size488.0 B
2024-03-15T08:44:10.377606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length32
Mean length26.511111
Min length21

Characters and Unicode

Total characters1193
Distinct characters99
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

Unique43 ?
Unique (%)95.6%

Sample

1st row부산광역시 북구 와석장터로 20 (화명동)
2nd row부산광역시 북구 만덕1로104번가길 29-13 (만덕동,옥천사)
3rd row부산광역시 북구 화명동 산 163번지 한전북부전력소
4th row부산광역시 북구 산성로47번길 20-6 (화명동,삼원주택)
5th row부산광역시 북구 산성로 37-1 (화명동)
ValueCountFrequency (%)
부산광역시 45
19.3%
북구 45
19.3%
구포동 11
 
4.7%
덕천동 9
 
3.9%
화명동 7
 
3.0%
만덕동 7
 
3.0%
금곡동 4
 
1.7%
산성로 3
 
1.3%
덕천로 3
 
1.3%
6 2
 
0.9%
Other values (90) 97
41.6%
2024-03-15T08:44:11.506714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
190
 
15.9%
구 59
 
4.9%
시 51
 
4.3%
산 50
 
4.2%
동 47
 
3.9%
북 47
 
3.9%
부 46
 
3.9%
광 45
 
3.8%
역 45
 
3.8%
) 43
 
3.6%
Other values (89) 570
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 717
60.1%
Space Separator 190
 
15.9%
Decimal Number 177
 
14.8%
Close Punctuation 43
 
3.6%
Open Punctuation 43
 
3.6%
Other Punctuation 12
 
1.0%
Dash Punctuation 11
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 59
 
8.2%
시 51
 
7.1%
산 50
 
7.0%
동 47
 
6.6%
북 47
 
6.6%
부 46
 
6.4%
광 45
 
6.3%
역 45
 
6.3%
로 40
 
5.6%
덕 36
 
5.0%
Other values (74) 251
35.0%
Decimal Number
ValueCountFrequency (%)
1 42
23.7%
5 25
14.1%
6 19
10.7%
4 18
10.2%
2 18
10.2%
7 15
 
8.5%
3 15
 
8.5%
0 12
 
6.8%
8 8
 
4.5%
9 5
 
2.8%
Space Separator
ValueCountFrequency (%)
190
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Other Punctuation
ValueCountFrequency (%)
, 12
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 717
60.1%
Common 476
39.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 59
 
8.2%
시 51
 
7.1%
산 50
 
7.0%
동 47
 
6.6%
북 47
 
6.6%
부 46
 
6.4%
광 45
 
6.3%
역 45
 
6.3%
로 40
 
5.6%
덕 36
 
5.0%
Other values (74) 251
35.0%
Common
ValueCountFrequency (%)
190
39.9%
) 43
 
9.0%
( 43
 
9.0%
1 42
 
8.8%
5 25
 
5.3%
6 19
 
4.0%
4 18
 
3.8%
2 18
 
3.8%
7 15
 
3.2%
3 15
 
3.2%
Other values (5) 48
 
10.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 717
60.1%
ASCII 476
39.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
190
39.9%
) 43
 
9.0%
( 43
 
9.0%
1 42
 
8.8%
5 25
 
5.3%
6 19
 
4.0%
4 18
 
3.8%
2 18
 
3.8%
7 15
 
3.2%
3 15
 
3.2%
Other values (5) 48
 
10.1%
Hangul
ValueCountFrequency (%)
구 59
 
8.2%
시 51
 
7.1%
산 50
 
7.0%
동 47
 
6.6%
북 47
 
6.6%
부 46
 
6.4%
광 45
 
6.3%
역 45
 
6.3%
로 40
 
5.6%
덕 36
 
5.0%
Other values (74) 251
35.0%

Correlations

2024-03-15T08:44:11.668690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호검사일자검사종류검사기관명세부용도음용여부관정위치
관리번호1.0000.9851.0001.0001.0001.0001.000
검사일자0.9851.0000.4230.9430.0000.4230.985
검사종류1.0000.4231.0000.0000.3740.9971.000
검사기관명1.0000.9430.0001.0000.0000.0001.000
세부용도1.0000.0000.3740.0001.0000.3741.000
음용여부1.0000.4230.9970.0000.3741.0001.000
관정위치1.0000.9851.0001.0001.0001.0001.000
2024-03-15T08:44:11.862289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세부용도음용여부검사기관명검사종류
세부용도1.0000.2420.0000.242
음용여부0.2421.0000.0000.952
검사기관명0.0000.0001.0000.000
검사종류0.2420.9520.0001.000
2024-03-15T08:44:12.106129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
검사종류검사기관명세부용도음용여부
검사종류1.0000.0000.2420.952
검사기관명0.0001.0000.0000.000
세부용도0.2420.0001.0000.242
음용여부0.9520.0000.2421.000

Missing values

2024-03-15T08:44:03.136098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T08:44:03.590592image/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

관리번호검사일자검사종류검사결과검사기관명용도세부용도음용여부관정위치
0부산9-12162023-11-29생활용수합격(주)그린환경연구원생활용일반용비음용부산광역시 북구 와석장터로 20 (화명동)
1부산8-6752023-09-20생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 만덕1로104번가길 29-13 (만덕동,옥천사)
2부산8-1192023-11-27음용수(기타 먹는물)합격동의분석센터생활용일반용음용부산광역시 북구 화명동 산 163번지 한전북부전력소
3부산8-0692023-04-17음용수(기타 먹는물)합격누리생명과학원(주)생활용공동주택용음용부산광역시 북구 산성로47번길 20-6 (화명동,삼원주택)
4부산8-1882023-09-01생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 산성로 37-1 (화명동)
5부산8-1882023-09-08생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 산성로 37-1 (화명동)
6부산8-4962023-03-16생활용수합격누리생명과학원(주)생활용일반용비음용부산광역시 북구 금곡대로616번길 25 (금곡동)
7부산8-3262023-05-15생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 팽나무로 35 (구포동)
8부산8-0902023-04-17생활용수합격누리생명과학원(주)생활용일반용비음용부산광역시 북구 구포시장6길 4 (구포동)
9부산8-0292023-02-08음용수(기타 먹는물)합격누리생명과학원(주)생활용공동주택용음용부산광역시 북구 덕천로 107 (덕천동)
관리번호검사일자검사종류검사결과검사기관명용도세부용도음용여부관정위치
35부산8-10482023-12-20생활용수합격아이센주식회사생활용가정용비음용부산광역시 북구 시랑로 155-7 (구포동)
36부산8-10922023-05-02생활용수합격누리생명과학원(주)생활용가정용비음용부산광역시 북구 금곡대로61번길 28 (덕천동)
37부산8-11022023-08-07생활용수합격누리생명과학원(주)생활용가정용비음용부산광역시 북구 낙동북로772번길 76 (구포동)
38부산8-11152023-04-20생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 모분재로 112 (구포동)
39부산8-11162023-09-15생활용수합격누리생명과학원(주)생활용일반용비음용부산광역시 북구 시랑로61번길 6 (구포동)
40부산8-11182023-09-01생활용수합격동의분석센터생활용가정용비음용부산광역시 북구 만덕대로155번길 40-5 (덕천동)
41부산8-11232023-06-15생활용수합격동의분석센터생활용가정용비음용부산광역시 북구 의성로 56 (덕천동)
42부산8-11372023-05-15음용수(기타 먹는물)합격동의분석센터생활용일반용음용부산광역시 북구 의성로33번길 184 (화명동)
43부산8-11672023-03-22생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 산성로 66 (화명동, 화명장원맨션)
44부산9-11112023-05-02생활용수합격동의분석센터생활용일반용비음용부산광역시 북구 만덕대로 160 (덕천동)