Overview

Dataset statistics

Number of variables4
Number of observations28
Missing cells5
Missing cells (%)4.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory36.6 B

Variable types

Text3
DateTime1

Dataset

Description익산시 관내 읍면동에 위히하고 있는 동물병원의 병원명, 도로명주소,개설일, 전화번호 등의 현황을 보유하고 있습니다.
Author전북특별자치도 익산시
URLhttps://www.data.go.kr/data/3079990/fileData.do

Alerts

병원연락처 has 5 (17.9%) missing valuesMissing
병원명 has unique valuesUnique
도로명주소 has unique valuesUnique
개설일 has unique valuesUnique

Reproduction

Analysis started2024-03-14 10:04:28.692887
Analysis finished2024-03-14 10:04:29.436117
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

병원명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size352.0 B
2024-03-14T19:04:30.118677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11.5
Mean length7.0357143
Min length5

Characters and Unicode

Total characters197
Distinct characters76
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

Unique28 ?
Unique (%)100.0%

Sample

1st row삼성동물병원
2nd row서울동물병원
3rd row대학동물병원
4th row황등동물병원
5th row퍼피존동물병원
ValueCountFrequency (%)
삼성동물병원 1
 
3.3%
서울동물병원 1
 
3.3%
클리닉 1
 
3.3%
펫 1
 
3.3%
에버그린 1
 
3.3%
모현동물병원 1
 
3.3%
전북야생동물구조관리센터 1
 
3.3%
전북동물의료센터 1
 
3.3%
우성동물병원 1
 
3.3%
다민동물병원 1
 
3.3%
Other values (20) 20
66.7%
2024-03-14T19:04:31.399292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 26
 
13.2%
물 26
 
13.2%
원 25
 
12.7%
병 24
 
12.2%
산 4
 
2.0%
리 4
 
2.0%
북 3
 
1.5%
우 3
 
1.5%
전 3
 
1.5%
터 2
 
1.0%
Other values (66) 77
39.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 193
98.0%
Space Separator 2
 
1.0%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 26
 
13.5%
물 26
 
13.5%
원 25
 
13.0%
병 24
 
12.4%
산 4
 
2.1%
리 4
 
2.1%
북 3
 
1.6%
우 3
 
1.6%
전 3
 
1.6%
터 2
 
1.0%
Other values (63) 73
37.8%
Space Separator
ValueCountFrequency (%)
2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 193
98.0%
Common 4
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 26
 
13.5%
물 26
 
13.5%
원 25
 
13.0%
병 24
 
12.4%
산 4
 
2.1%
리 4
 
2.1%
북 3
 
1.6%
우 3
 
1.6%
전 3
 
1.6%
터 2
 
1.0%
Other values (63) 73
37.8%
Common
ValueCountFrequency (%)
2
50.0%
) 1
25.0%
( 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 193
98.0%
ASCII 4
 
2.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 26
 
13.5%
물 26
 
13.5%
원 25
 
13.0%
병 24
 
12.4%
산 4
 
2.1%
리 4
 
2.1%
북 3
 
1.6%
우 3
 
1.6%
전 3
 
1.6%
터 2
 
1.0%
Other values (63) 73
37.8%
ASCII
ValueCountFrequency (%)
2
50.0%
) 1
25.0%
( 1
25.0%

도로명주소
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size352.0 B
2024-03-14T19:04:32.351328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length29
Mean length27
Min length23

Characters and Unicode

Total characters756
Distinct characters94
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

Unique28 ?
Unique (%)100.0%

Sample

1st row전북특별자치도 익산시 금마면동고도리697번지
2nd row전북특별자치도 익산시 함열읍 함열로 78-1
3rd row전북특별자치도 익산시 인북로 139 (창인동1가)
4th row전북특별자치도 익산시 황등면황등리893번지
5th row전북특별자치도 익산시 익산대로 190 (창인동1가)
ValueCountFrequency (%)
전북특별자치도 28
20.0%
익산시 28
20.0%
창인동1가 3
 
2.1%
무왕로 3
 
2.1%
마동 3
 
2.1%
79 2
 
1.4%
함열읍 2
 
1.4%
춘포면 2
 
1.4%
어양동 2
 
1.4%
고봉로 2
 
1.4%
Other values (60) 65
46.4%
2024-03-14T19:04:33.576287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
116
 
15.3%
산 34
 
4.5%
1 31
 
4.1%
익 30
 
4.0%
북 30
 
4.0%
전 29
 
3.8%
도 29
 
3.8%
시 29
 
3.8%
특 28
 
3.7%
별 28
 
3.7%
Other values (84) 372
49.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 493
65.2%
Space Separator 116
 
15.3%
Decimal Number 102
 
13.5%
Close Punctuation 17
 
2.2%
Open Punctuation 17
 
2.2%
Other Punctuation 7
 
0.9%
Dash Punctuation 4
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 34
 
6.9%
익 30
 
6.1%
북 30
 
6.1%
전 29
 
5.9%
도 29
 
5.9%
시 29
 
5.9%
특 28
 
5.7%
별 28
 
5.7%
자 28
 
5.7%
치 28
 
5.7%
Other values (69) 200
40.6%
Decimal Number
ValueCountFrequency (%)
1 31
30.4%
2 13
12.7%
3 11
 
10.8%
0 10
 
9.8%
4 10
 
9.8%
7 9
 
8.8%
9 7
 
6.9%
6 6
 
5.9%
8 3
 
2.9%
5 2
 
2.0%
Space Separator
ValueCountFrequency (%)
116
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 493
65.2%
Common 263
34.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 34
 
6.9%
익 30
 
6.1%
북 30
 
6.1%
전 29
 
5.9%
도 29
 
5.9%
시 29
 
5.9%
특 28
 
5.7%
별 28
 
5.7%
자 28
 
5.7%
치 28
 
5.7%
Other values (69) 200
40.6%
Common
ValueCountFrequency (%)
116
44.1%
1 31
 
11.8%
) 17
 
6.5%
( 17
 
6.5%
2 13
 
4.9%
3 11
 
4.2%
0 10
 
3.8%
4 10
 
3.8%
7 9
 
3.4%
, 7
 
2.7%
Other values (5) 22
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 493
65.2%
ASCII 263
34.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
116
44.1%
1 31
 
11.8%
) 17
 
6.5%
( 17
 
6.5%
2 13
 
4.9%
3 11
 
4.2%
0 10
 
3.8%
4 10
 
3.8%
7 9
 
3.4%
, 7
 
2.7%
Other values (5) 22
 
8.4%
Hangul
ValueCountFrequency (%)
산 34
 
6.9%
익 30
 
6.1%
북 30
 
6.1%
전 29
 
5.9%
도 29
 
5.9%
시 29
 
5.9%
특 28
 
5.7%
별 28
 
5.7%
자 28
 
5.7%
치 28
 
5.7%
Other values (69) 200
40.6%

개설일
Date

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size352.0 B
Minimum1963-06-10 00:00:00
Maximum2020-03-23 00:00:00
2024-03-14T19:04:33.785751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T19:04:34.002179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

병원연락처
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing5
Missing (%)17.9%
Memory size352.0 B
2024-03-14T19:04:34.775408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters276
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 (%)100.0%

Sample

1st row063-836-6222
2nd row063-861-0546
3rd row063-841-0811
4th row063-856-5010
5th row063-841-0010
ValueCountFrequency (%)
063-836-6222 1
 
4.3%
063-831-5115 1
 
4.3%
063-833-7570 1
 
4.3%
063-850-0975 1
 
4.3%
063-850-0970 1
 
4.3%
063-291-0727 1
 
4.3%
063-834-7585 1
 
4.3%
063-858-7582 1
 
4.3%
063-831-1252 1
 
4.3%
063-831-6179 1
 
4.3%
Other values (13) 13
56.5%
2024-03-14T19:04:35.934930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 46
16.7%
0 38
13.8%
3 35
12.7%
6 32
11.6%
8 29
10.5%
5 27
9.8%
1 20
7.2%
2 17
 
6.2%
7 14
 
5.1%
4 10
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 230
83.3%
Dash Punctuation 46
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 38
16.5%
3 35
15.2%
6 32
13.9%
8 29
12.6%
5 27
11.7%
1 20
8.7%
2 17
7.4%
7 14
 
6.1%
4 10
 
4.3%
9 8
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 46
16.7%
0 38
13.8%
3 35
12.7%
6 32
11.6%
8 29
10.5%
5 27
9.8%
1 20
7.2%
2 17
 
6.2%
7 14
 
5.1%
4 10
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 46
16.7%
0 38
13.8%
3 35
12.7%
6 32
11.6%
8 29
10.5%
5 27
9.8%
1 20
7.2%
2 17
 
6.2%
7 14
 
5.1%
4 10
 
3.6%

Correlations

2024-03-14T19:04:36.090297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
병원명도로명주소개설일병원연락처
병원명1.0001.0001.0001.000
도로명주소1.0001.0001.0001.000
개설일1.0001.0001.0001.000
병원연락처1.0001.0001.0001.000

Missing values

2024-03-14T19:04:29.043224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T19:04:29.324635image/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삼성동물병원전북특별자치도 익산시 금마면동고도리697번지1973-04-05063-836-6222
1서울동물병원전북특별자치도 익산시 함열읍 함열로 78-11976-03-08063-861-0546
2대학동물병원전북특별자치도 익산시 인북로 139 (창인동1가)1979-12-05063-841-0811
3황등동물병원전북특별자치도 익산시 황등면황등리893번지1981-12-04063-856-5010
4퍼피존동물병원전북특별자치도 익산시 익산대로 190 (창인동1가)1987-04-17063-841-0010
5왕궁동물병원전북특별자치도 익산시 왕궁면구덕리522-101997-06-21063-291-5214
6전북동물병원전북특별자치도 익산시 인화동1가132번지1999-05-25063-855-2948
7고려동물병원전북특별자치도 익산시 무왕로 1032 (영등동)2000-05-16063-855-0124
8김동물병원전북특별자치도 익산시 황등면 황등7길 171963-06-10063-856-4942
9미래종합동물병원전북특별자치도 익산시 무왕로 1132 (어양동)2003-11-26063-833-7582
병원명도로명주소개설일병원연락처
18금강동물병원전북특별자치도 익산시 익산대로 204 (창인동1가)2010-11-02063-858-7582
19우리들동물병원전북특별자치도 익산시 금마면 미륵사지로 682011-01-17063-834-7585
20하나로동물병원전북특별자치도 익산시 목천로 20, 1층 (목천동)2013-06-28<NA>
21다민동물병원전북특별자치도 익산시 춘포면 쌍정길 16-12014-11-17063-291-0727
22우성동물병원전북특별자치도 익산시 함열읍 함열10길 262014-12-08<NA>
23전북동물의료센터전북특별자치도 익산시 고봉로 79 (마동)2015-03-13063-850-0970
24전북야생동물구조관리센터전북특별자치도 익산시 고봉로 79 (마동, 전북대학교)2015-07-06063-850-0975
25모현동물병원전북특별자치도 익산시 선화로 114 (남중동)2016-02-01<NA>
26에버그린 펫 클리닉전북특별자치도 익산시 동서로63길 4 (어양동, 하모니시티)2017-06-24063-834-7553
27조한웅동물병원전북특별자치도 익산시 춘포면 궁성로 130, 고려온천아파트상가 107동 104호2020-03-23<NA>