Overview

Dataset statistics

Number of variables6
Number of observations25
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory53.3 B

Variable types

Text5
DateTime1

Dataset

Description제주특별자치도 내 소재하고 있는 지하수 영향조사 기관에 관한 데이터로 등록번호, 상호명, 주소, 전화번호 등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15099978/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
등록번호 has unique valuesUnique
상호명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:43:21.113156
Analysis finished2023-12-12 07:43:21.615904
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T16:43:21.726214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row제주 2000-01
2nd row제주 2001-02
3rd row제주 2003-01
4th row제주 2007-01
5th row제주 2010-01
ValueCountFrequency (%)
제주 25
50.0%
2000-01 1
 
2.0%
2021-03 1
 
2.0%
2021-02 1
 
2.0%
2021-01 1
 
2.0%
2019-04 1
 
2.0%
2019-03 1
 
2.0%
2018-02 1
 
2.0%
2018-01 1
 
2.0%
2017-04 1
 
2.0%
Other values (16) 16
32.0%
2023-12-12T16:43:22.024329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 56
22.4%
2 38
15.2%
1 32
12.8%
제 25
10.0%
주 25
10.0%
25
10.0%
- 25
10.0%
3 7
 
2.8%
7 5
 
2.0%
5 3
 
1.2%
Other values (4) 9
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 150
60.0%
Other Letter 50
 
20.0%
Space Separator 25
 
10.0%
Dash Punctuation 25
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 56
37.3%
2 38
25.3%
1 32
21.3%
3 7
 
4.7%
7 5
 
3.3%
5 3
 
2.0%
4 3
 
2.0%
6 2
 
1.3%
8 2
 
1.3%
9 2
 
1.3%
Other Letter
ValueCountFrequency (%)
제 25
50.0%
주 25
50.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 200
80.0%
Hangul 50
 
20.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 56
28.0%
2 38
19.0%
1 32
16.0%
25
12.5%
- 25
12.5%
3 7
 
3.5%
7 5
 
2.5%
5 3
 
1.5%
4 3
 
1.5%
6 2
 
1.0%
Other values (2) 4
 
2.0%
Hangul
ValueCountFrequency (%)
제 25
50.0%
주 25
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 200
80.0%
Hangul 50
 
20.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 56
28.0%
2 38
19.0%
1 32
16.0%
25
12.5%
- 25
12.5%
3 7
 
3.5%
7 5
 
2.5%
5 3
 
1.5%
4 3
 
1.5%
6 2
 
1.0%
Other values (2) 4
 
2.0%
Hangul
ValueCountFrequency (%)
제 25
50.0%
주 25
50.0%

상호명
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T16:43:22.236691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length6.64
Min length3

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row㈜진산
2nd row㈜남천개발
3rd row㈜덕천개발
4th row㈜웅지산업개발
5th row㈜디케이엘
ValueCountFrequency (%)
주식회사 2
 
7.4%
㈜진산 1
 
3.7%
㈜남천개발 1
 
3.7%
㈜해강종합기술 1
 
3.7%
주)영아리환경기술 1
 
3.7%
코탐(주 1
 
3.7%
주)지오엔지니어링 1
 
3.7%
주)기반이엔씨 1
 
3.7%
유)샘물 1
 
3.7%
연웅이앤씨 1
 
3.7%
Other values (16) 16
59.3%
2023-12-12T16:43:22.592994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
㈜ 15
 
9.0%
지 9
 
5.4%
) 8
 
4.8%
( 8
 
4.8%
주 8
 
4.8%
이 5
 
3.0%
개 5
 
3.0%
발 5
 
3.0%
기 4
 
2.4%
유 4
 
2.4%
Other values (64) 95
57.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 133
80.1%
Other Symbol 15
 
9.0%
Close Punctuation 8
 
4.8%
Open Punctuation 8
 
4.8%
Space Separator 2
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 9
 
6.8%
주 8
 
6.0%
이 5
 
3.8%
개 5
 
3.8%
발 5
 
3.8%
기 4
 
3.0%
유 4
 
3.0%
씨 4
 
3.0%
엔 4
 
3.0%
한 3
 
2.3%
Other values (60) 82
61.7%
Other Symbol
ValueCountFrequency (%)
㈜ 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 148
89.2%
Common 18
 
10.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
㈜ 15
 
10.1%
지 9
 
6.1%
주 8
 
5.4%
이 5
 
3.4%
개 5
 
3.4%
발 5
 
3.4%
기 4
 
2.7%
유 4
 
2.7%
씨 4
 
2.7%
엔 4
 
2.7%
Other values (61) 85
57.4%
Common
ValueCountFrequency (%)
) 8
44.4%
( 8
44.4%
2
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 133
80.1%
ASCII 18
 
10.8%
None 15
 
9.0%

Most frequent character per block

None
ValueCountFrequency (%)
㈜ 15
100.0%
Hangul
ValueCountFrequency (%)
지 9
 
6.8%
주 8
 
6.0%
이 5
 
3.8%
개 5
 
3.8%
발 5
 
3.8%
기 4
 
3.0%
유 4
 
3.0%
씨 4
 
3.0%
엔 4
 
3.0%
한 3
 
2.3%
Other values (60) 82
61.7%
ASCII
ValueCountFrequency (%)
) 8
44.4%
( 8
44.4%
2
 
11.1%

주소
Text

Distinct22
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T16:43:22.855970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length30
Mean length21.56
Min length17

Characters and Unicode

Total characters539
Distinct characters59
Distinct categories6 ?
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 (%)76.0%

Sample

1st row제주특별자치도 제주시 일주동로 84 (화북이동)
2nd row제주특별자치도 서귀포시 서문로 29번길 19 (서귀동)
3rd row제주특별자치도 제주시 애월읍 광령평화2길 39
4th row제주특별자치도 제주시 도리로 22-21 (이호일동)
5th row제주특별자치도 제주시 첨단로 213-3
ValueCountFrequency (%)
제주특별자치도 25
22.9%
제주시 22
20.2%
도령로 4
 
3.7%
서귀포시 3
 
2.8%
애월읍 2
 
1.8%
87 2
 
1.8%
일주동로 2
 
1.8%
7-11 2
 
1.8%
남원읍 2
 
1.8%
39 2
 
1.8%
Other values (38) 43
39.4%
2023-12-12T16:43:23.220178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
84
15.6%
주 49
 
9.1%
제 47
 
8.7%
도 30
 
5.6%
특 25
 
4.6%
별 25
 
4.6%
자 25
 
4.6%
치 25
 
4.6%
시 25
 
4.6%
로 22
 
4.1%
Other values (49) 182
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 372
69.0%
Space Separator 84
 
15.6%
Decimal Number 72
 
13.4%
Dash Punctuation 5
 
0.9%
Close Punctuation 3
 
0.6%
Open Punctuation 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 49
13.2%
제 47
12.6%
도 30
 
8.1%
특 25
 
6.7%
별 25
 
6.7%
자 25
 
6.7%
치 25
 
6.7%
시 25
 
6.7%
로 22
 
5.9%
길 9
 
2.4%
Other values (35) 90
24.2%
Decimal Number
ValueCountFrequency (%)
2 19
26.4%
1 17
23.6%
7 6
 
8.3%
9 6
 
8.3%
8 5
 
6.9%
4 5
 
6.9%
3 5
 
6.9%
0 4
 
5.6%
5 4
 
5.6%
6 1
 
1.4%
Space Separator
ValueCountFrequency (%)
84
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 372
69.0%
Common 167
31.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 49
13.2%
제 47
12.6%
도 30
 
8.1%
특 25
 
6.7%
별 25
 
6.7%
자 25
 
6.7%
치 25
 
6.7%
시 25
 
6.7%
로 22
 
5.9%
길 9
 
2.4%
Other values (35) 90
24.2%
Common
ValueCountFrequency (%)
84
50.3%
2 19
 
11.4%
1 17
 
10.2%
7 6
 
3.6%
9 6
 
3.6%
8 5
 
3.0%
4 5
 
3.0%
3 5
 
3.0%
- 5
 
3.0%
0 4
 
2.4%
Other values (4) 11
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 372
69.0%
ASCII 167
31.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
84
50.3%
2 19
 
11.4%
1 17
 
10.2%
7 6
 
3.6%
9 6
 
3.6%
8 5
 
3.0%
4 5
 
3.0%
3 5
 
3.0%
- 5
 
3.0%
0 4
 
2.4%
Other values (4) 11
 
6.6%
Hangul
ValueCountFrequency (%)
주 49
13.2%
제 47
12.6%
도 30
 
8.1%
특 25
 
6.7%
별 25
 
6.7%
자 25
 
6.7%
치 25
 
6.7%
시 25
 
6.7%
로 22
 
5.9%
길 9
 
2.4%
Other values (35) 90
24.2%

전화번호
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T16:43:23.450032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.12
Min length12

Characters and Unicode

Total characters303
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row064-756-8868
2nd row064-733-4111
3rd row064-757-9300
4th row064-713-2155
5th row064-759-9578
ValueCountFrequency (%)
064-756-8868 1
 
4.0%
064-742-7455 1
 
4.0%
064-900-5471 1
 
4.0%
064-722-0125 1
 
4.0%
070-5102-0297 1
 
4.0%
070-7431-0859 1
 
4.0%
064-901-8708 1
 
4.0%
064-748-0535 1
 
4.0%
064-748-0167 1
 
4.0%
064-745-1445 1
 
4.0%
Other values (15) 15
60.0%
2023-12-12T16:43:23.805086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 50
16.5%
0 47
15.5%
7 42
13.9%
4 40
13.2%
6 29
9.6%
8 20
 
6.6%
5 18
 
5.9%
1 18
 
5.9%
2 16
 
5.3%
3 15
 
5.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 253
83.5%
Dash Punctuation 50
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 47
18.6%
7 42
16.6%
4 40
15.8%
6 29
11.5%
8 20
7.9%
5 18
 
7.1%
1 18
 
7.1%
2 16
 
6.3%
3 15
 
5.9%
9 8
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 303
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 50
16.5%
0 47
15.5%
7 42
13.9%
4 40
13.2%
6 29
9.6%
8 20
 
6.6%
5 18
 
5.9%
1 18
 
5.9%
2 16
 
5.3%
3 15
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 303
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 50
16.5%
0 47
15.5%
7 42
13.9%
4 40
13.2%
6 29
9.6%
8 20
 
6.6%
5 18
 
5.9%
1 18
 
5.9%
2 16
 
5.3%
3 15
 
5.0%

팩스번호
Text

Distinct24
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-12T16:43:24.010568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.2
Min length12

Characters and Unicode

Total characters305
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique23 ?
Unique (%)92.0%

Sample

1st row064-756-8386
2nd row064-732-8850
3rd row064-726-0093
4th row064-743-6687
5th row064-759-9579
ValueCountFrequency (%)
064-764-7878 2
 
8.0%
064-756-8386 1
 
4.0%
064-755-5175 1
 
4.0%
064-900-5473 1
 
4.0%
064-722-0128 1
 
4.0%
042-367-0779 1
 
4.0%
0303-3442-1170 1
 
4.0%
064-901-8507 1
 
4.0%
064-742-7456 1
 
4.0%
064-749-0167 1
 
4.0%
Other values (14) 14
56.0%
2023-12-12T16:43:24.361637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 50
16.4%
0 42
13.8%
4 41
13.4%
7 41
13.4%
6 36
11.8%
3 21
6.9%
8 20
 
6.6%
5 17
 
5.6%
2 17
 
5.6%
1 11
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 255
83.6%
Dash Punctuation 50
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 42
16.5%
4 41
16.1%
7 41
16.1%
6 36
14.1%
3 21
8.2%
8 20
7.8%
5 17
6.7%
2 17
6.7%
1 11
 
4.3%
9 9
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 305
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 50
16.4%
0 42
13.8%
4 41
13.4%
7 41
13.4%
6 36
11.8%
3 21
6.9%
8 20
 
6.6%
5 17
 
5.6%
2 17
 
5.6%
1 11
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 305
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 50
16.4%
0 42
13.8%
4 41
13.4%
7 41
13.4%
6 36
11.8%
3 21
6.9%
8 20
 
6.6%
5 17
 
5.6%
2 17
 
5.6%
1 11
 
3.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
Minimum2022-09-30 00:00:00
Maximum2022-09-30 00:00:00
2023-12-12T16:43:24.494661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:43:24.600065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T16:43:24.674961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록번호상호명주소전화번호팩스번호
등록번호1.0001.0001.0001.0001.000
상호명1.0001.0001.0001.0001.000
주소1.0001.0001.0001.0000.952
전화번호1.0001.0001.0001.0001.000
팩스번호1.0001.0000.9521.0001.000

Missing values

2023-12-12T16:43:21.454373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:43:21.563850image/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제주 2000-01㈜진산제주특별자치도 제주시 일주동로 84 (화북이동)064-756-8868064-756-83862022-09-30
1제주 2001-02㈜남천개발제주특별자치도 서귀포시 서문로 29번길 19 (서귀동)064-733-4111064-732-88502022-09-30
2제주 2003-01㈜덕천개발제주특별자치도 제주시 애월읍 광령평화2길 39064-757-9300064-726-00932022-09-30
3제주 2007-01㈜웅지산업개발제주특별자치도 제주시 도리로 22-21 (이호일동)064-713-2155064-743-66872022-09-30
4제주 2010-01㈜디케이엘제주특별자치도 제주시 첨단로 213-3064-759-9578064-759-95792022-09-30
5제주 2012-01㈜웨리트제주제주특별자치도 제주시 우정로15길 12064-713-8730064-713-87342022-09-30
6제주 2012-02㈜규성제주특별자치도 서귀포시 남원읍 남원체육관로 221번길 7-11064-764-2828064-764-78782022-09-30
7제주 2013-01㈜지엠씨제주특별자치도 제주시 신산로 22064-726-8875064-726-88742022-09-30
8제주 2015-01㈜지원이엔씨제주특별자치도 제주시 신산로 22064-722-10700303-3448-10712022-09-30
9제주 2015-03㈜삼화엔지니어링제주특별자치도 제주시 일주동로 87064-722-3341064-722-33492022-09-30
등록번호상호명주소전화번호팩스번호데이터기준일자
15제주 2017-03주식회사 한가람제주특별자치도 제주시 연삼로 215064-726-8851064-726-88532022-09-30
16제주 2017-04(유)한빛지오텍제주특별자치도 제주시 도령로 40064-745-1445064-745-14462022-09-30
17제주 2018-01주식회사 연웅이앤씨제주특별자치도 제주시 서사로 92064-748-0167064-749-01672022-09-30
18제주 2018-02(유)샘물제주특별자치도 제주시 도령로 50064-748-0535064-742-74562022-09-30
19제주 2019-03(주)기반이엔씨제주특별자치도 제주시 오남로 1064-901-8708064-901-85072022-09-30
20제주 2019-04(주)지오엔지니어링제주특별자치도 제주시 삼무로1길 10-8070-7431-08590303-3442-11702022-09-30
21제주 2021-01코탐(주)제주특별자치도 제주시 선사로8길 71070-5102-0297042-367-07792022-09-30
22제주 2021-02(주)영아리환경기술제주특별자치도 제주시 원남6길 49064-722-0125064-722-01282022-09-30
23제주 2021-03㈜해강종합기술제주특별자치도 제주시 오남로 1064-900-5471064-900-54732022-09-30
24제주 2022-01(주)케이지오제주특별자치도 제주시 연북로 724064-744-2387064-757-23872022-09-30