Overview

Dataset statistics

Number of variables6
Number of observations64
Missing cells34
Missing cells (%)8.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.2 KiB
Average record size in memory51.1 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description부산광역시사하구_동물미용업현황_20230421
Author부산광역시 사하구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15085773

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 34 (53.1%) missing valuesMissing
연번 has unique valuesUnique
업체명 has unique valuesUnique
소재지(도로명주소) has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:27:14.546673
Analysis finished2023-12-10 16:27:15.248199
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.5
Minimum1
Maximum64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2023-12-11T01:27:15.336885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.15
Q116.75
median32.5
Q348.25
95-th percentile60.85
Maximum64
Range63
Interquartile range (IQR)31.5

Descriptive statistics

Standard deviation18.618987
Coefficient of variation (CV)0.5728919
Kurtosis-1.2
Mean32.5
Median Absolute Deviation (MAD)16
Skewness0
Sum2080
Variance346.66667
MonotonicityStrictly increasing
2023-12-11T01:27:15.488625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
34 1
 
1.6%
36 1
 
1.6%
37 1
 
1.6%
38 1
 
1.6%
39 1
 
1.6%
40 1
 
1.6%
41 1
 
1.6%
42 1
 
1.6%
43 1
 
1.6%
Other values (54) 54
84.4%
ValueCountFrequency (%)
1 1
1.6%
2 1
1.6%
3 1
1.6%
4 1
1.6%
5 1
1.6%
6 1
1.6%
7 1
1.6%
8 1
1.6%
9 1
1.6%
10 1
1.6%
ValueCountFrequency (%)
64 1
1.6%
63 1
1.6%
62 1
1.6%
61 1
1.6%
60 1
1.6%
59 1
1.6%
58 1
1.6%
57 1
1.6%
56 1
1.6%
55 1
1.6%

업체명
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T01:27:15.736531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.640625
Min length2

Characters and Unicode

Total characters361
Distinct characters140
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

Unique64 ?
Unique (%)100.0%

Sample

1st row착한 강아지
2nd row몽글펫
3rd row우리펫살롱
4th row아이러브 애견
5th row개린이집
ValueCountFrequency (%)
애견 4
 
4.8%
강아지 2
 
2.4%
똥강아지 2
 
2.4%
동물병원 2
 
2.4%
미용실 2
 
2.4%
착한 1
 
1.2%
멍멍이 1
 
1.2%
나은동물병원 1
 
1.2%
하이댕댕 1
 
1.2%
도그살롱 1
 
1.2%
Other values (67) 67
79.8%
2023-12-11T01:27:16.092965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20
 
5.5%
동 13
 
3.6%
견 13
 
3.6%
애 12
 
3.3%
원 11
 
3.0%
물 11
 
3.0%
이 11
 
3.0%
미 11
 
3.0%
멍 10
 
2.8%
병 10
 
2.8%
Other values (130) 239
66.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 327
90.6%
Space Separator 20
 
5.5%
Lowercase Letter 3
 
0.8%
Other Punctuation 3
 
0.8%
Close Punctuation 2
 
0.6%
Open Punctuation 2
 
0.6%
Uppercase Letter 2
 
0.6%
Decimal Number 2
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 13
 
4.0%
견 13
 
4.0%
애 12
 
3.7%
원 11
 
3.4%
물 11
 
3.4%
이 11
 
3.4%
미 11
 
3.4%
멍 10
 
3.1%
병 10
 
3.1%
아 8
 
2.4%
Other values (118) 217
66.4%
Other Punctuation
ValueCountFrequency (%)
, 1
33.3%
. 1
33.3%
& 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
d 2
66.7%
y 1
33.3%
Uppercase Letter
ValueCountFrequency (%)
M 1
50.0%
C 1
50.0%
Decimal Number
ValueCountFrequency (%)
8 1
50.0%
3 1
50.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 327
90.6%
Common 29
 
8.0%
Latin 5
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 13
 
4.0%
견 13
 
4.0%
애 12
 
3.7%
원 11
 
3.4%
물 11
 
3.4%
이 11
 
3.4%
미 11
 
3.4%
멍 10
 
3.1%
병 10
 
3.1%
아 8
 
2.4%
Other values (118) 217
66.4%
Common
ValueCountFrequency (%)
20
69.0%
) 2
 
6.9%
( 2
 
6.9%
, 1
 
3.4%
. 1
 
3.4%
& 1
 
3.4%
8 1
 
3.4%
3 1
 
3.4%
Latin
ValueCountFrequency (%)
d 2
40.0%
M 1
20.0%
y 1
20.0%
C 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 327
90.6%
ASCII 34
 
9.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
20
58.8%
) 2
 
5.9%
( 2
 
5.9%
d 2
 
5.9%
M 1
 
2.9%
, 1
 
2.9%
. 1
 
2.9%
y 1
 
2.9%
& 1
 
2.9%
8 1
 
2.9%
Other values (2) 2
 
5.9%
Hangul
ValueCountFrequency (%)
동 13
 
4.0%
견 13
 
4.0%
애 12
 
3.7%
원 11
 
3.4%
물 11
 
3.4%
이 11
 
3.4%
미 11
 
3.4%
멍 10
 
3.1%
병 10
 
3.1%
아 8
 
2.4%
Other values (118) 217
66.4%

대표자
Text

Distinct63
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T01:27:16.338719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.171875
Min length3

Characters and Unicode

Total characters203
Distinct characters88
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

Unique62 ?
Unique (%)96.9%

Sample

1st row정수민
2nd row김민균
3rd row김현정
4th row박동복
5th row이소정
ValueCountFrequency (%)
김수연 2
 
3.1%
노영수 1
 
1.5%
강은영 1
 
1.5%
신광숙 1
 
1.5%
김경재 1
 
1.5%
박미정 1
 
1.5%
이동욱 1
 
1.5%
강우주 1
 
1.5%
이태훈 1
 
1.5%
김혜정 1
 
1.5%
Other values (54) 54
83.1%
2023-12-11T01:27:16.687256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
정 14
 
6.9%
김 12
 
5.9%
박 10
 
4.9%
이 8
 
3.9%
영 7
 
3.4%
선 6
 
3.0%
희 6
 
3.0%
은 6
 
3.0%
경 5
 
2.5%
현 5
 
2.5%
Other values (78) 124
61.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 200
98.5%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%
Space Separator 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 14
 
7.0%
김 12
 
6.0%
박 10
 
5.0%
이 8
 
4.0%
영 7
 
3.5%
선 6
 
3.0%
희 6
 
3.0%
은 6
 
3.0%
경 5
 
2.5%
현 5
 
2.5%
Other values (75) 121
60.5%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 200
98.5%
Common 3
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 14
 
7.0%
김 12
 
6.0%
박 10
 
5.0%
이 8
 
4.0%
영 7
 
3.5%
선 6
 
3.0%
희 6
 
3.0%
은 6
 
3.0%
경 5
 
2.5%
현 5
 
2.5%
Other values (75) 121
60.5%
Common
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 200
98.5%
ASCII 3
 
1.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
정 14
 
7.0%
김 12
 
6.0%
박 10
 
5.0%
이 8
 
4.0%
영 7
 
3.5%
선 6
 
3.0%
희 6
 
3.0%
은 6
 
3.0%
경 5
 
2.5%
현 5
 
2.5%
Other values (75) 121
60.5%
ASCII
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
1
33.3%

전화번호
Text

MISSING 

Distinct30
Distinct (%)100.0%
Missing34
Missing (%)53.1%
Memory size644.0 B
2023-12-11T01:27:16.871020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique30 ?
Unique (%)100.0%

Sample

1st row051-204-7568
2nd row051-907-5252
3rd row051-206-3510
4th row051-202-9708
5th row051-204-1891
ValueCountFrequency (%)
051-261-4270 1
 
3.3%
051-907-5252 1
 
3.3%
051-291-7900 1
 
3.3%
051-714-2435 1
 
3.3%
051-203-6741 1
 
3.3%
051-201-1482 1
 
3.3%
051-264-7584 1
 
3.3%
051-204-8720 1
 
3.3%
051-291-4456 1
 
3.3%
051-291-3618 1
 
3.3%
Other values (20) 20
66.7%
2023-12-11T01:27:17.162924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 60
16.7%
0 57
15.8%
1 55
15.3%
5 45
12.5%
2 42
11.7%
6 21
 
5.8%
4 20
 
5.6%
3 16
 
4.4%
9 15
 
4.2%
8 15
 
4.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.3%
Dash Punctuation 60
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 57
19.0%
1 55
18.3%
5 45
15.0%
2 42
14.0%
6 21
 
7.0%
4 20
 
6.7%
3 16
 
5.3%
9 15
 
5.0%
8 15
 
5.0%
7 14
 
4.7%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 360
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 60
16.7%
0 57
15.8%
1 55
15.3%
5 45
12.5%
2 42
11.7%
6 21
 
5.8%
4 20
 
5.6%
3 16
 
4.4%
9 15
 
4.2%
8 15
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 60
16.7%
0 57
15.8%
1 55
15.3%
5 45
12.5%
2 42
11.7%
6 21
 
5.8%
4 20
 
5.6%
3 16
 
4.4%
9 15
 
4.2%
8 15
 
4.2%

소재지(도로명주소)
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-11T01:27:17.447459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length39
Mean length29.828125
Min length22

Characters and Unicode

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

Unique

Unique64 ?
Unique (%)100.0%

Sample

1st row부산광역시 사하구 낙동대로 194, 1층 (괴정동)
2nd row부산광역시 사하구 하신중앙로 326, 한우리빌딩 3층 (하단동)
3rd row부산광역시 사하구 대티로 5, 1층 (괴정동)
4th row부산광역시 사하구 사하로 156-1 (괴정동)
5th row부산광역시 사하구 낙동남로1357번길 46, 1층 (하단동, 하단 지오피아)
ValueCountFrequency (%)
부산광역시 64
 
16.5%
사하구 64
 
16.5%
1층 22
 
5.7%
다대로 15
 
3.9%
괴정동 14
 
3.6%
다대동 14
 
3.6%
하단동 9
 
2.3%
낙동대로 8
 
2.1%
당리동 7
 
1.8%
장림동 7
 
1.8%
Other values (134) 163
42.1%
2023-12-11T01:27:17.871131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
323
 
16.9%
동 87
 
4.6%
하 84
 
4.4%
1 68
 
3.6%
사 66
 
3.5%
구 65
 
3.4%
산 65
 
3.4%
시 65
 
3.4%
) 64
 
3.4%
부 64
 
3.4%
Other values (94) 958
50.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1121
58.7%
Space Separator 323
 
16.9%
Decimal Number 281
 
14.7%
Close Punctuation 64
 
3.4%
Open Punctuation 64
 
3.4%
Other Punctuation 47
 
2.5%
Dash Punctuation 8
 
0.4%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 87
 
7.8%
하 84
 
7.5%
사 66
 
5.9%
구 65
 
5.8%
산 65
 
5.8%
시 65
 
5.8%
부 64
 
5.7%
역 64
 
5.7%
광 64
 
5.7%
로 62
 
5.5%
Other values (77) 435
38.8%
Decimal Number
ValueCountFrequency (%)
1 68
24.2%
2 45
16.0%
3 32
11.4%
4 30
10.7%
5 28
10.0%
0 22
 
7.8%
6 18
 
6.4%
7 15
 
5.3%
8 12
 
4.3%
9 11
 
3.9%
Other Punctuation
ValueCountFrequency (%)
, 46
97.9%
· 1
 
2.1%
Space Separator
ValueCountFrequency (%)
323
100.0%
Close Punctuation
ValueCountFrequency (%)
) 64
100.0%
Open Punctuation
ValueCountFrequency (%)
( 64
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1121
58.7%
Common 787
41.2%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 87
 
7.8%
하 84
 
7.5%
사 66
 
5.9%
구 65
 
5.8%
산 65
 
5.8%
시 65
 
5.8%
부 64
 
5.7%
역 64
 
5.7%
광 64
 
5.7%
로 62
 
5.5%
Other values (77) 435
38.8%
Common
ValueCountFrequency (%)
323
41.0%
1 68
 
8.6%
) 64
 
8.1%
( 64
 
8.1%
, 46
 
5.8%
2 45
 
5.7%
3 32
 
4.1%
4 30
 
3.8%
5 28
 
3.6%
0 22
 
2.8%
Other values (6) 65
 
8.3%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1121
58.7%
ASCII 787
41.2%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
323
41.0%
1 68
 
8.6%
) 64
 
8.1%
( 64
 
8.1%
, 46
 
5.8%
2 45
 
5.7%
3 32
 
4.1%
4 30
 
3.8%
5 28
 
3.6%
0 22
 
2.8%
Other values (6) 65
 
8.3%
Hangul
ValueCountFrequency (%)
동 87
 
7.8%
하 84
 
7.5%
사 66
 
5.9%
구 65
 
5.8%
산 65
 
5.8%
시 65
 
5.8%
부 64
 
5.7%
역 64
 
5.7%
광 64
 
5.7%
로 62
 
5.5%
Other values (77) 435
38.8%
None
ValueCountFrequency (%)
· 1
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-04-21
64 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-04-21
2nd row2023-04-21
3rd row2023-04-21
4th row2023-04-21
5th row2023-04-21

Common Values

ValueCountFrequency (%)
2023-04-21 64
100.0%

Length

2023-12-11T01:27:17.995052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:27:18.080991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-21 64
100.0%

Interactions

2023-12-11T01:27:14.903702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:27:18.136845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업체명대표자전화번호소재지(도로명주소)
연번1.0001.0000.9471.0001.000
업체명1.0001.0001.0001.0001.000
대표자0.9471.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
소재지(도로명주소)1.0001.0001.0001.0001.000

Missing values

2023-12-11T01:27:15.051234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:27:15.196645image/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착한 강아지정수민051-204-7568부산광역시 사하구 낙동대로 194, 1층 (괴정동)2023-04-21
12몽글펫김민균<NA>부산광역시 사하구 하신중앙로 326, 한우리빌딩 3층 (하단동)2023-04-21
23우리펫살롱김현정051-907-5252부산광역시 사하구 대티로 5, 1층 (괴정동)2023-04-21
34아이러브 애견박동복051-206-3510부산광역시 사하구 사하로 156-1 (괴정동)2023-04-21
45개린이집이소정051-202-9708부산광역시 사하구 낙동남로1357번길 46, 1층 (하단동, 하단 지오피아)2023-04-21
56(주)사하동물의료원(주)사하동물의료원 박대식051-204-1891부산광역시 사하구 낙동대로356번길 6 (당리동)2023-04-21
67미소애견허윤정051-261-1891부산광역시 사하구 다대로 624 (다대동)2023-04-21
78해피멍윤선화051-265-8454부산광역시 사하구 다대로 274 (장림동)2023-04-21
89한솔동물병원박용구<NA>부산광역시 사하구 낙동대로 184 (괴정동)2023-04-21
910베스트 애견박경희051-266-1434부산광역시 사하구 장림번영로 46-2(장림동)2023-04-21
연번업체명대표자전화번호소재지(도로명주소)데이터기준일자
5455보듬 반려견미용실조대명<NA>부산광역시 사하구 낙동대로410번길 21, B동 1층 102호 (당리동, 한성금강빌라)2023-04-21
5556행복한 동물병원김창엽051-714-2435부산광역시 사하구 을숙도대로 713, 1층 (신평동)2023-04-21
5657베이비숑 펫살롱안채희<NA>부산광역시 사하구 제석로 6, 황도주택 101호 (하단동)2023-04-21
5758마이댕댕(My.d,d)김수연<NA>부산광역시 사하구 다대로 513(다대동)2023-04-21
5859꽁냥꽁냥추형화<NA>부산광역시 사하구 괴정로57번길 40(하단동)2023-04-21
5960멍멍이샵정지은051-255-7188부산광역시 사하구 다대로 232, 1층 (장림동)2023-04-21
6061멍멍이발소박선주<NA>부산광역시 사하구 다송로 7, 다대다해아파트 4동 지하층 2호 (다대동, 다대다해아파트)2023-04-21
6162동동 애견 미용권젬마<NA>부산광역시 사하구 윤공단로17번길 103, 상가 4동 1층 4호 (다대동, 조성아파트)2023-04-21
6263몽&보리이현선<NA>부산광역시 사하구 대티로1번길 22, 109동 1층 103호 (괴정동, 괴정 스타클래스)2023-04-21
6364산책갈까신현미<NA>부산광역시 사하구 다대로 247, 1층 105호 (장림동)2023-04-21