Overview

Dataset statistics

Number of variables5
Number of observations44
Missing cells11
Missing cells (%)5.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory44.0 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description인천광역시 서구에 위치한 동물병원 현황으로 (병원명, 소재지, 전화번호)에 대한 정보를 포함하고 있는 데이터 파일입니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15039512&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 11 (25.0%) missing valuesMissing
연번 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2024-01-28 06:21:32.726241
Analysis finished2024-01-28 06:21:33.334737
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.5
Minimum1
Maximum44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size528.0 B
2024-01-28T15:21:33.391754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.15
Q111.75
median22.5
Q333.25
95-th percentile41.85
Maximum44
Range43
Interquartile range (IQR)21.5

Descriptive statistics

Standard deviation12.845233
Coefficient of variation (CV)0.57089923
Kurtosis-1.2
Mean22.5
Median Absolute Deviation (MAD)11
Skewness0
Sum990
Variance165
MonotonicityStrictly increasing
2024-01-28T15:21:33.493823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
1 1
 
2.3%
24 1
 
2.3%
26 1
 
2.3%
27 1
 
2.3%
28 1
 
2.3%
29 1
 
2.3%
30 1
 
2.3%
31 1
 
2.3%
32 1
 
2.3%
33 1
 
2.3%
Other values (34) 34
77.3%
ValueCountFrequency (%)
1 1
2.3%
2 1
2.3%
3 1
2.3%
4 1
2.3%
5 1
2.3%
6 1
2.3%
7 1
2.3%
8 1
2.3%
9 1
2.3%
10 1
2.3%
ValueCountFrequency (%)
44 1
2.3%
43 1
2.3%
42 1
2.3%
41 1
2.3%
40 1
2.3%
39 1
2.3%
38 1
2.3%
37 1
2.3%
36 1
2.3%
35 1
2.3%

병원명
Text

Distinct43
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size484.0 B
2024-01-28T15:21:33.667727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length8.1590909
Min length5

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)95.5%

Sample

1st row가정동물병원
2nd row우리동물병원
3rd row도희동물병원
4th row원당동물병원
5th row화이트동물병원
ValueCountFrequency (%)
동물병원 10
 
15.6%
쿨펫동물병원 2
 
3.1%
24시 2
 
3.1%
동물의료센터 2
 
3.1%
이영수 1
 
1.6%
청라호수동물메디컬센터 1
 
1.6%
진현우동물병원 1
 
1.6%
더블유 1
 
1.6%
아이케어 1
 
1.6%
행복한산책 1
 
1.6%
Other values (42) 42
65.6%
2024-01-28T15:21:33.962781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 44
 
12.3%
물 44
 
12.3%
원 39
 
10.9%
병 35
 
9.7%
20
 
5.6%
이 11
 
3.1%
센 10
 
2.8%
터 9
 
2.5%
료 7
 
1.9%
의 7
 
1.9%
Other values (86) 133
37.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 333
92.8%
Space Separator 20
 
5.6%
Decimal Number 4
 
1.1%
Other Punctuation 1
 
0.3%
Uppercase Letter 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 44
 
13.2%
물 44
 
13.2%
원 39
 
11.7%
병 35
 
10.5%
이 11
 
3.3%
센 10
 
3.0%
터 9
 
2.7%
료 7
 
2.1%
의 7
 
2.1%
청 5
 
1.5%
Other values (81) 122
36.6%
Decimal Number
ValueCountFrequency (%)
2 2
50.0%
4 2
50.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
J 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 333
92.8%
Common 25
 
7.0%
Latin 1
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 44
 
13.2%
물 44
 
13.2%
원 39
 
11.7%
병 35
 
10.5%
이 11
 
3.3%
센 10
 
3.0%
터 9
 
2.7%
료 7
 
2.1%
의 7
 
2.1%
청 5
 
1.5%
Other values (81) 122
36.6%
Common
ValueCountFrequency (%)
20
80.0%
2 2
 
8.0%
4 2
 
8.0%
& 1
 
4.0%
Latin
ValueCountFrequency (%)
J 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 333
92.8%
ASCII 26
 
7.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 44
 
13.2%
물 44
 
13.2%
원 39
 
11.7%
병 35
 
10.5%
이 11
 
3.3%
센 10
 
3.0%
터 9
 
2.7%
료 7
 
2.1%
의 7
 
2.1%
청 5
 
1.5%
Other values (81) 122
36.6%
ASCII
ValueCountFrequency (%)
20
76.9%
2 2
 
7.7%
4 2
 
7.7%
& 1
 
3.8%
J 1
 
3.8%

소재지
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2024-01-28T15:21:34.211930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length45
Mean length34.75
Min length22

Characters and Unicode

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

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st row인천광역시 서구 가정로 346 (가정동)
2nd row인천광역시 서구 서곶로 349 (연희동)
3rd row인천광역시 서구 승학로 245, 1층 (심곡동)
4th row인천광역시 서구 원당대로 852, 창신프라자 204호 (당하동)
5th row인천광역시 서구 서곶로 866 (마전동, 강서빌딩)
ValueCountFrequency (%)
인천광역시 44
 
14.5%
서구 44
 
14.5%
청라동 8
 
2.6%
1층 7
 
2.3%
가정동 7
 
2.3%
2층 6
 
2.0%
마전동 5
 
1.7%
원당동 5
 
1.7%
가정로 5
 
1.7%
서곶로 4
 
1.3%
Other values (138) 168
55.4%
2024-01-28T15:21:34.578760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
259
 
16.9%
1 57
 
3.7%
, 53
 
3.5%
2 52
 
3.4%
서 51
 
3.3%
동 50
 
3.3%
시 48
 
3.1%
인 46
 
3.0%
천 45
 
2.9%
) 44
 
2.9%
Other values (151) 824
53.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 830
54.3%
Decimal Number 260
 
17.0%
Space Separator 259
 
16.9%
Other Punctuation 55
 
3.6%
Close Punctuation 44
 
2.9%
Open Punctuation 44
 
2.9%
Uppercase Letter 18
 
1.2%
Lowercase Letter 13
 
0.9%
Math Symbol 5
 
0.3%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 51
 
6.1%
동 50
 
6.0%
시 48
 
5.8%
인 46
 
5.5%
천 45
 
5.4%
로 44
 
5.3%
구 44
 
5.3%
역 44
 
5.3%
광 44
 
5.3%
라 26
 
3.1%
Other values (120) 388
46.7%
Decimal Number
ValueCountFrequency (%)
1 57
21.9%
2 52
20.0%
0 35
13.5%
3 26
10.0%
4 20
 
7.7%
5 19
 
7.3%
6 17
 
6.5%
8 15
 
5.8%
7 12
 
4.6%
9 7
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
K 3
16.7%
B 3
16.7%
S 2
11.1%
L 2
11.1%
V 2
11.1%
I 2
11.1%
E 2
11.1%
W 2
11.1%
Lowercase Letter
ValueCountFrequency (%)
e 4
30.8%
a 2
15.4%
d 2
15.4%
r 2
15.4%
s 2
15.4%
c 1
 
7.7%
Other Punctuation
ValueCountFrequency (%)
, 53
96.4%
' 2
 
3.6%
Space Separator
ValueCountFrequency (%)
259
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%
Math Symbol
ValueCountFrequency (%)
~ 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 830
54.3%
Common 668
43.7%
Latin 31
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 51
 
6.1%
동 50
 
6.0%
시 48
 
5.8%
인 46
 
5.5%
천 45
 
5.4%
로 44
 
5.3%
구 44
 
5.3%
역 44
 
5.3%
광 44
 
5.3%
라 26
 
3.1%
Other values (120) 388
46.7%
Common
ValueCountFrequency (%)
259
38.8%
1 57
 
8.5%
, 53
 
7.9%
2 52
 
7.8%
) 44
 
6.6%
( 44
 
6.6%
0 35
 
5.2%
3 26
 
3.9%
4 20
 
3.0%
5 19
 
2.8%
Other values (7) 59
 
8.8%
Latin
ValueCountFrequency (%)
e 4
12.9%
K 3
9.7%
B 3
9.7%
a 2
 
6.5%
S 2
 
6.5%
L 2
 
6.5%
d 2
 
6.5%
r 2
 
6.5%
s 2
 
6.5%
V 2
 
6.5%
Other values (4) 7
22.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 830
54.3%
ASCII 699
45.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
259
37.1%
1 57
 
8.2%
, 53
 
7.6%
2 52
 
7.4%
) 44
 
6.3%
( 44
 
6.3%
0 35
 
5.0%
3 26
 
3.7%
4 20
 
2.9%
5 19
 
2.7%
Other values (21) 90
 
12.9%
Hangul
ValueCountFrequency (%)
서 51
 
6.1%
동 50
 
6.0%
시 48
 
5.8%
인 46
 
5.5%
천 45
 
5.4%
로 44
 
5.3%
구 44
 
5.3%
역 44
 
5.3%
광 44
 
5.3%
라 26
 
3.1%
Other values (120) 388
46.7%

전화번호
Text

MISSING 

Distinct33
Distinct (%)100.0%
Missing11
Missing (%)25.0%
Memory size484.0 B
2024-01-28T15:21:34.750949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters396
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

Unique33 ?
Unique (%)100.0%

Sample

1st row032-575-0833
2nd row032-566-0075
3rd row032-566-0038
4th row032-566-7588
5th row032-561-7592
ValueCountFrequency (%)
032-567-2575 1
 
3.0%
032-710-7553 1
 
3.0%
032-584-0075 1
 
3.0%
032-568-0022 1
 
3.0%
032-572-7475 1
 
3.0%
032-565-8270 1
 
3.0%
032-564-7600 1
 
3.0%
032-563-1900 1
 
3.0%
032-566-7589 1
 
3.0%
032-567-2475 1
 
3.0%
Other values (23) 23
69.7%
2024-01-28T15:21:35.008415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 66
16.7%
0 57
14.4%
5 55
13.9%
2 48
12.1%
3 44
11.1%
7 37
9.3%
6 33
8.3%
8 17
 
4.3%
1 15
 
3.8%
9 13
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 330
83.3%
Dash Punctuation 66
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 57
17.3%
5 55
16.7%
2 48
14.5%
3 44
13.3%
7 37
11.2%
6 33
10.0%
8 17
 
5.2%
1 15
 
4.5%
9 13
 
3.9%
4 11
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 396
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 66
16.7%
0 57
14.4%
5 55
13.9%
2 48
12.1%
3 44
11.1%
7 37
9.3%
6 33
8.3%
8 17
 
4.3%
1 15
 
3.8%
9 13
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 396
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 66
16.7%
0 57
14.4%
5 55
13.9%
2 48
12.1%
3 44
11.1%
7 37
9.3%
6 33
8.3%
8 17
 
4.3%
1 15
 
3.8%
9 13
 
3.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
Minimum2023-07-31 00:00:00
Maximum2023-07-31 00:00:00
2024-01-28T15:21:35.093488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:21:35.158322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-28T15:21:33.161193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T15:21:35.209323image/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-01-28T15:21:33.234930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T15:21:33.307694image/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가정동물병원인천광역시 서구 가정로 346 (가정동)032-575-08332023-07-31
12우리동물병원인천광역시 서구 서곶로 349 (연희동)032-566-00752023-07-31
23도희동물병원인천광역시 서구 승학로 245, 1층 (심곡동)032-566-00382023-07-31
34원당동물병원인천광역시 서구 원당대로 852, 창신프라자 204호 (당하동)032-566-75882023-07-31
45화이트동물병원인천광역시 서구 서곶로 866 (마전동, 강서빌딩)032-561-75922023-07-31
56굿모닝동물병원인천광역시 서구 가정로 246, 203호 (석남동)032-583-11192023-07-31
67예 동물병원인천광역시 서구 완정로 70, 영남탑스빌아파트 상가 (마전동)<NA>2023-07-31
78쿨펫동물병원인천광역시 서구 원당대로 581, 롯데마트 (마전동)<NA>2023-07-31
89쿨펫동물병원인천광역시 서구 서곶로 754, 당하 이마트 (당하동)032-565-79752023-07-31
910검암동물병원인천광역시 서구 승학로 512 (검암동)<NA>2023-07-31
연번병원명소재지전화번호데이터기준일자
3435삼성종합동물병원인천광역시 서구 건지로 269 (석남동)032-584-00752023-07-31
3536리브동물의료센터인천광역시 서구 검단로 455, 105,202호 (왕길동, 검단KB빌딩)032-567-24752023-07-31
3637이기쁨동물병원인천광역시 서구 가정로 437, 301동 B119호 (가정동, 루원시티 SK Leaders' VIEW)032-579-77782023-07-31
373824시 더원 동물병원인천광역시 서구 발산로 41, 4층 (원당동)032-569-66772023-07-31
3839검단이담동물의료센터인천광역시 서구 이음1로 383, 세중시그니쳐 2층 201~3호 (원당동)032-710-24402023-07-31
3940아이비유동물병원인천광역시 서구 이음5로 65, 상가동 103호 (원당동, 검단 금호어울림 센트럴)<NA>2023-07-31
4041아람동물의료센터인천광역시 서구 발산로 6, 아인시티 주차타워 2층 201~3호 (원당동)032-866-11112023-07-31
4142우신&스퀘어 동물병원인천광역시 서구 담지로8번길 18, 1층 (청라동)<NA>2023-07-31
4243이영수 고양이 병원인천광역시 서구 봉오재3로 120, 301,302호 (가정동)032-205-02792023-07-31
4344루원 센트럴 동물의료센터인천광역시 서구 봉오대로 270, 302동 B121호 (가정동, 루원시티2차 SK Leaders' VIEW)032-579-75822023-07-31