Overview

Dataset statistics

Number of variables6
Number of observations161
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.8 KiB
Average record size in memory49.8 B

Variable types

Categorical2
Text2
DateTime1
Numeric1

Dataset

Description충청북도 동물병원 현황은 충청북도의 동물병원에 대한 설명으로서 시도, 시군구, 동물병원명, 주소, 수의사 수 등의 정보를 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/15026717/fileData.do

Alerts

시도 has constant value ""Constant
수의사수 has 10 (6.2%) zerosZeros

Reproduction

Analysis started2023-12-12 16:22:59.397799
Analysis finished2023-12-12 16:22:59.996482
Duration0.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
충청북도
161 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청북도
2nd row충청북도
3rd row충청북도
4th row충청북도
5th row충청북도

Common Values

ValueCountFrequency (%)
충청북도 161
100.0%

Length

2023-12-13T01:23:00.068213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:23:00.177692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 161
100.0%

시군구
Categorical

Distinct14
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
청주시 청원구
24 
청주시 흥덕구
22 
청주시 서원구
19 
충주시
16 
음성군
14 
Other values (9)
66 

Length

Max length7
Median length3
Mean length4.9378882
Min length3

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row괴산군
2nd row괴산군
3rd row괴산군
4th row괴산군
5th row괴산군

Common Values

ValueCountFrequency (%)
청주시 청원구 24
14.9%
청주시 흥덕구 22
13.7%
청주시 서원구 19
11.8%
충주시 16
9.9%
음성군 14
8.7%
청주시 상당구 13
8.1%
진천군 11
6.8%
제천시 10
6.2%
보은군 9
 
5.6%
괴산군 7
 
4.3%
Other values (4) 16
9.9%

Length

2023-12-13T01:23:00.300016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청주시 78
32.6%
청원구 24
 
10.0%
흥덕구 22
 
9.2%
서원구 19
 
7.9%
충주시 16
 
6.7%
음성군 14
 
5.9%
상당구 13
 
5.4%
진천군 11
 
4.6%
제천시 10
 
4.2%
보은군 9
 
3.8%
Other values (5) 23
 
9.6%
Distinct154
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-13T01:23:00.481407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16
Mean length7.826087
Min length5

Characters and Unicode

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

Unique

Unique149 ?
Unique (%)92.5%

Sample

1st row괴산증평축협동물병원
2nd row김동물병원
3rd row김종하 동물병원
4th row마루동물병원
5th row수암동물병원
ValueCountFrequency (%)
동물병원 21
 
10.7%
우리동물병원 3
 
1.5%
현대동물병원 3
 
1.5%
출장진료전문병원 2
 
1.0%
훈동물병원 2
 
1.0%
한국동물병원 2
 
1.0%
명성동물병원 2
 
1.0%
하나동물병원 2
 
1.0%
메인동물병원 1
 
0.5%
주주종합동물병원 1
 
0.5%
Other values (157) 157
80.1%
2023-12-13T01:23:00.823752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
164
 
13.0%
160
 
12.7%
158
 
12.5%
154
 
12.2%
35
 
2.8%
19
 
1.5%
16
 
1.3%
15
 
1.2%
12
 
1.0%
12
 
1.0%
Other values (184) 515
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1186
94.1%
Space Separator 35
 
2.8%
Close Punctuation 12
 
1.0%
Open Punctuation 12
 
1.0%
Decimal Number 8
 
0.6%
Uppercase Letter 6
 
0.5%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
164
 
13.8%
160
 
13.5%
158
 
13.3%
154
 
13.0%
19
 
1.6%
16
 
1.3%
15
 
1.3%
12
 
1.0%
12
 
1.0%
12
 
1.0%
Other values (174) 464
39.1%
Uppercase Letter
ValueCountFrequency (%)
C 2
33.3%
M 2
33.3%
E 1
16.7%
S 1
16.7%
Decimal Number
ValueCountFrequency (%)
2 4
50.0%
4 4
50.0%
Space Separator
ValueCountFrequency (%)
35
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Lowercase Letter
ValueCountFrequency (%)
i 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1186
94.1%
Common 67
 
5.3%
Latin 7
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
164
 
13.8%
160
 
13.5%
158
 
13.3%
154
 
13.0%
19
 
1.6%
16
 
1.3%
15
 
1.3%
12
 
1.0%
12
 
1.0%
12
 
1.0%
Other values (174) 464
39.1%
Common
ValueCountFrequency (%)
35
52.2%
) 12
 
17.9%
( 12
 
17.9%
2 4
 
6.0%
4 4
 
6.0%
Latin
ValueCountFrequency (%)
C 2
28.6%
M 2
28.6%
i 1
14.3%
E 1
14.3%
S 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1186
94.1%
ASCII 74
 
5.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
164
 
13.8%
160
 
13.5%
158
 
13.3%
154
 
13.0%
19
 
1.6%
16
 
1.3%
15
 
1.3%
12
 
1.0%
12
 
1.0%
12
 
1.0%
Other values (174) 464
39.1%
ASCII
ValueCountFrequency (%)
35
47.3%
) 12
 
16.2%
( 12
 
16.2%
2 4
 
5.4%
4 4
 
5.4%
C 2
 
2.7%
M 2
 
2.7%
i 1
 
1.4%
E 1
 
1.4%
S 1
 
1.4%
Distinct160
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-13T01:23:01.115834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length43
Mean length27.285714
Min length19

Characters and Unicode

Total characters4393
Distinct characters205
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique159 ?
Unique (%)98.8%

Sample

1st row충청북도 괴산군 괴산읍 읍내로2길 39 (괴산증평축협)
2nd row충청북도 괴산군 사리면 문화2길 1
3rd row충청북도 괴산군 괴산읍 읍내로2길 45-1
4th row충청북도 괴산군 청천면 청천3길 7
5th row충청북도 괴산군 괴산읍 임꺽정로 142-3
ValueCountFrequency (%)
충청북도 161
 
16.4%
청주시 78
 
8.0%
청원구 24
 
2.5%
흥덕구 22
 
2.2%
1층 19
 
1.9%
서원구 19
 
1.9%
충주시 16
 
1.6%
음성군 14
 
1.4%
상당구 13
 
1.3%
진천군 11
 
1.1%
Other values (383) 602
61.5%
2023-12-13T01:23:01.553898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
822
 
18.7%
277
 
6.3%
1 188
 
4.3%
183
 
4.2%
164
 
3.7%
161
 
3.7%
141
 
3.2%
110
 
2.5%
98
 
2.2%
98
 
2.2%
Other values (195) 2151
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2668
60.7%
Space Separator 822
 
18.7%
Decimal Number 622
 
14.2%
Close Punctuation 81
 
1.8%
Open Punctuation 81
 
1.8%
Other Punctuation 65
 
1.5%
Dash Punctuation 43
 
1.0%
Uppercase Letter 11
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
277
 
10.4%
183
 
6.9%
164
 
6.1%
161
 
6.0%
141
 
5.3%
110
 
4.1%
98
 
3.7%
98
 
3.7%
81
 
3.0%
59
 
2.2%
Other values (172) 1296
48.6%
Decimal Number
ValueCountFrequency (%)
1 188
30.2%
2 79
12.7%
0 64
 
10.3%
4 61
 
9.8%
5 56
 
9.0%
3 52
 
8.4%
8 33
 
5.3%
6 31
 
5.0%
9 30
 
4.8%
7 28
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
E 2
18.2%
T 2
18.2%
A 2
18.2%
B 1
9.1%
H 1
9.1%
S 1
9.1%
Y 1
9.1%
L 1
9.1%
Space Separator
ValueCountFrequency (%)
822
100.0%
Close Punctuation
ValueCountFrequency (%)
) 81
100.0%
Open Punctuation
ValueCountFrequency (%)
( 81
100.0%
Other Punctuation
ValueCountFrequency (%)
, 65
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 43
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2668
60.7%
Common 1714
39.0%
Latin 11
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
277
 
10.4%
183
 
6.9%
164
 
6.1%
161
 
6.0%
141
 
5.3%
110
 
4.1%
98
 
3.7%
98
 
3.7%
81
 
3.0%
59
 
2.2%
Other values (172) 1296
48.6%
Common
ValueCountFrequency (%)
822
48.0%
1 188
 
11.0%
) 81
 
4.7%
( 81
 
4.7%
2 79
 
4.6%
, 65
 
3.8%
0 64
 
3.7%
4 61
 
3.6%
5 56
 
3.3%
3 52
 
3.0%
Other values (5) 165
 
9.6%
Latin
ValueCountFrequency (%)
E 2
18.2%
T 2
18.2%
A 2
18.2%
B 1
9.1%
H 1
9.1%
S 1
9.1%
Y 1
9.1%
L 1
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2668
60.7%
ASCII 1725
39.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
822
47.7%
1 188
 
10.9%
) 81
 
4.7%
( 81
 
4.7%
2 79
 
4.6%
, 65
 
3.8%
0 64
 
3.7%
4 61
 
3.5%
5 56
 
3.2%
3 52
 
3.0%
Other values (13) 176
 
10.2%
Hangul
ValueCountFrequency (%)
277
 
10.4%
183
 
6.9%
164
 
6.1%
161
 
6.0%
141
 
5.3%
110
 
4.1%
98
 
3.7%
98
 
3.7%
81
 
3.0%
59
 
2.2%
Other values (172) 1296
48.6%
Distinct158
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum1976-11-10 00:00:00
Maximum2023-09-13 00:00:00
2023-12-13T01:23:01.677390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:23:01.794658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수의사수
Real number (ℝ)

ZEROS 

Distinct10
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9627329
Minimum0
Maximum75
Zeros10
Zeros (%)6.2%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T01:23:01.900412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median1
Q31
95-th percentile4
Maximum75
Range75
Interquartile range (IQR)0

Descriptive statistics

Standard deviation6.2037168
Coefficient of variation (CV)3.1607545
Kurtosis122.86448
Mean1.9627329
Median Absolute Deviation (MAD)0
Skewness10.668307
Sum316
Variance38.486102
MonotonicityNot monotonic
2023-12-13T01:23:02.018284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
1 117
72.7%
2 18
 
11.2%
0 10
 
6.2%
3 6
 
3.7%
4 4
 
2.5%
6 2
 
1.2%
10 1
 
0.6%
25 1
 
0.6%
75 1
 
0.6%
7 1
 
0.6%
ValueCountFrequency (%)
0 10
 
6.2%
1 117
72.7%
2 18
 
11.2%
3 6
 
3.7%
4 4
 
2.5%
6 2
 
1.2%
7 1
 
0.6%
10 1
 
0.6%
25 1
 
0.6%
75 1
 
0.6%
ValueCountFrequency (%)
75 1
 
0.6%
25 1
 
0.6%
10 1
 
0.6%
7 1
 
0.6%
6 2
 
1.2%
4 4
 
2.5%
3 6
 
3.7%
2 18
 
11.2%
1 117
72.7%
0 10
 
6.2%

Interactions

2023-12-13T01:22:59.711224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:23:02.107959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구수의사수
시군구1.0000.000
수의사수0.0001.000
2023-12-13T01:23:02.201996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수의사수시군구
수의사수1.0000.000
시군구0.0001.000

Missing values

2023-12-13T01:22:59.835747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:22:59.945456image/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충청북도괴산군괴산증평축협동물병원충청북도 괴산군 괴산읍 읍내로2길 39 (괴산증평축협)2010-05-041
1충청북도괴산군김동물병원충청북도 괴산군 사리면 문화2길 12016-12-101
2충청북도괴산군김종하 동물병원충청북도 괴산군 괴산읍 읍내로2길 45-11987-02-131
3충청북도괴산군마루동물병원충청북도 괴산군 청천면 청천3길 72021-11-071
4충청북도괴산군수암동물병원충청북도 괴산군 괴산읍 임꺽정로 142-32016-12-221
5충청북도괴산군우원동물병원충청북도 괴산군 괴산읍 남산1길 41-1, 괴산신성미소지움아파트 상가 1층 1호2020-04-101
6충청북도괴산군희성동물병원충청북도 괴산군 청안면 청안읍내로 412021-07-261
7충청북도단양군중부동물병원충청북도 단양군 단양읍 삼봉로 3192003-03-281
8충청북도보은군E 동물의료원충청북도 보은군 마로면 관기송현로 95-12008-12-301
9충청북도보은군더 가까운 동물병원충청북도 보은군 보은읍 뱃들로 47, 상가2021-06-180
시도시군구동물병원명도로명주소신고일수의사수
151충청북도충주시열린동물병원충청북도 충주시 금릉로 78 (교현동)2007-07-031
152충청북도충주시용산동물병원충청북도 충주시 형설로 54-11 (용산동)2018-12-201
153충청북도충주시정종합동물병원충청북도 충주시 지현천변1길 57 (지현동, 정종합동물병원)2000-08-051
154충청북도충주시중앙동물의료센터충청북도 충주시 국원대로 131, 1층 (교현동)2015-11-122
155충청북도충주시중원동물병원(출장진료전문)충청북도 충주시 천변로 249 (교현동)2019-04-181
156충청북도충주시충주동물병원충청북도 충주시 중앙로 34 (문화동)1994-10-011
157충청북도충주시충주축협동물병원충청북도 충주시 예성로 256 (교현동)1998-05-041
158충청북도충주시큰동물병원(출장진료전문병원)충청북도 충주시 주덕읍 신덕로 1364-12018-04-171
159충청북도충주시튼튼동물병원충청북도 충주시 예성6길 27 (교현동)2023-09-131
160충청북도충주시현대동물병원충청북도 충주시 번영대로 144 (연수동)2002-07-161