Overview

Dataset statistics

Number of variables5
Number of observations85
Missing cells56
Missing cells (%)13.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.5 KiB
Average record size in memory42.6 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description인천광역시 미추홀구의 동물미용업 현황 데이터로 유형, 상호명, 소재지주소, 도로명주소, 전화번호 등의 데이터를 포함하고 있습니다.
Author인천광역시 미추홀구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15100470&srcSe=7661IVAWM27C61E190

Alerts

유형 has constant value ""Constant
전화번호 has 56 (65.9%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 08:05:57.259605
Analysis finished2024-01-28 08:05:57.753154
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct85
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean43
Minimum1
Maximum85
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size897.0 B
2024-01-28T17:05:57.811903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.2
Q122
median43
Q364
95-th percentile80.8
Maximum85
Range84
Interquartile range (IQR)42

Descriptive statistics

Standard deviation24.681302
Coefficient of variation (CV)0.57398377
Kurtosis-1.2
Mean43
Median Absolute Deviation (MAD)21
Skewness0
Sum3655
Variance609.16667
MonotonicityStrictly increasing
2024-01-28T17:05:57.922644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.2%
55 1
 
1.2%
63 1
 
1.2%
62 1
 
1.2%
61 1
 
1.2%
60 1
 
1.2%
59 1
 
1.2%
58 1
 
1.2%
57 1
 
1.2%
56 1
 
1.2%
Other values (75) 75
88.2%
ValueCountFrequency (%)
1 1
1.2%
2 1
1.2%
3 1
1.2%
4 1
1.2%
5 1
1.2%
6 1
1.2%
7 1
1.2%
8 1
1.2%
9 1
1.2%
10 1
1.2%
ValueCountFrequency (%)
85 1
1.2%
84 1
1.2%
83 1
1.2%
82 1
1.2%
81 1
1.2%
80 1
1.2%
79 1
1.2%
78 1
1.2%
77 1
1.2%
76 1
1.2%

유형
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size812.0 B
동물미용업(일반)
85 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동물미용업(일반)
2nd row동물미용업(일반)
3rd row동물미용업(일반)
4th row동물미용업(일반)
5th row동물미용업(일반)

Common Values

ValueCountFrequency (%)
동물미용업(일반) 85
100.0%

Length

2024-01-28T17:05:58.024584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T17:05:58.109261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물미용업(일반 85
100.0%

상호명
Text

Distinct84
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size812.0 B
2024-01-28T17:05:58.315051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length5.9058824
Min length2

Characters and Unicode

Total characters502
Distinct characters180
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

Unique83 ?
Unique (%)97.6%

Sample

1st row이쁜강아지
2nd row파리 애견스타일
3rd row라르펫
4th row러블리 강아지
5th row개미딱지
ValueCountFrequency (%)
강아지 5
 
4.7%
시드니종합동물병원 2
 
1.9%
러블리 2
 
1.9%
펫살롱 2
 
1.9%
도그아로마 1
 
0.9%
본애견미용실 1
 
0.9%
써니펫살롱 1
 
0.9%
반하냥 1
 
0.9%
나에개 1
 
0.9%
내사랑 1
 
0.9%
Other values (90) 90
84.1%
2024-01-28T17:05:58.665717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
22
 
4.4%
펫 17
 
3.4%
리 15
 
3.0%
개 14
 
2.8%
견 14
 
2.8%
애 13
 
2.6%
멍 13
 
2.6%
아 12
 
2.4%
동 12
 
2.4%
이 11
 
2.2%
Other values (170) 359
71.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 432
86.1%
Lowercase Letter 29
 
5.8%
Space Separator 22
 
4.4%
Uppercase Letter 6
 
1.2%
Open Punctuation 4
 
0.8%
Close Punctuation 4
 
0.8%
Other Punctuation 3
 
0.6%
Decimal Number 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
펫 17
 
3.9%
리 15
 
3.5%
개 14
 
3.2%
견 14
 
3.2%
애 13
 
3.0%
멍 13
 
3.0%
아 12
 
2.8%
동 12
 
2.8%
이 11
 
2.5%
물 11
 
2.5%
Other values (143) 300
69.4%
Lowercase Letter
ValueCountFrequency (%)
a 3
10.3%
o 3
10.3%
p 3
10.3%
y 2
 
6.9%
l 2
 
6.9%
u 2
 
6.9%
g 2
 
6.9%
d 2
 
6.9%
n 2
 
6.9%
r 2
 
6.9%
Other values (5) 6
20.7%
Uppercase Letter
ValueCountFrequency (%)
D 2
33.3%
L 1
16.7%
C 1
16.7%
J 1
16.7%
A 1
16.7%
Other Punctuation
ValueCountFrequency (%)
, 2
66.7%
& 1
33.3%
Decimal Number
ValueCountFrequency (%)
4 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 432
86.1%
Common 35
 
7.0%
Latin 35
 
7.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
펫 17
 
3.9%
리 15
 
3.5%
개 14
 
3.2%
견 14
 
3.2%
애 13
 
3.0%
멍 13
 
3.0%
아 12
 
2.8%
동 12
 
2.8%
이 11
 
2.5%
물 11
 
2.5%
Other values (143) 300
69.4%
Latin
ValueCountFrequency (%)
a 3
 
8.6%
o 3
 
8.6%
p 3
 
8.6%
y 2
 
5.7%
l 2
 
5.7%
u 2
 
5.7%
g 2
 
5.7%
d 2
 
5.7%
n 2
 
5.7%
r 2
 
5.7%
Other values (10) 12
34.3%
Common
ValueCountFrequency (%)
22
62.9%
( 4
 
11.4%
) 4
 
11.4%
, 2
 
5.7%
& 1
 
2.9%
4 1
 
2.9%
2 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 432
86.1%
ASCII 70
 
13.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
22
31.4%
( 4
 
5.7%
) 4
 
5.7%
a 3
 
4.3%
o 3
 
4.3%
p 3
 
4.3%
y 2
 
2.9%
l 2
 
2.9%
u 2
 
2.9%
g 2
 
2.9%
Other values (17) 23
32.9%
Hangul
ValueCountFrequency (%)
펫 17
 
3.9%
리 15
 
3.5%
개 14
 
3.2%
견 14
 
3.2%
애 13
 
3.0%
멍 13
 
3.0%
아 12
 
2.8%
동 12
 
2.8%
이 11
 
2.5%
물 11
 
2.5%
Other values (143) 300
69.4%

도로명주소
Text

Distinct83
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size812.0 B
2024-01-28T17:05:58.898198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length45
Mean length32.2
Min length23

Characters and Unicode

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

Unique

Unique81 ?
Unique (%)95.3%

Sample

1st row인천광역시 미추홀구 소성로 334 (문학동)
2nd row인천광역시 미추홀구 소성로 237, 201호 (학익동)
3rd row인천광역시 미추홀구 노적산로 70, 102호 (학익동)
4th row인천광역시 미추홀구 동산로 9, 1층 (숭의동)
5th row인천광역시 미추홀구 장천로112번길 5 (숭의동)
ValueCountFrequency (%)
인천광역시 85
 
15.9%
미추홀구 85
 
15.9%
1층 33
 
6.2%
주안동 30
 
5.6%
용현동 18
 
3.4%
도화동 12
 
2.2%
숭의동 10
 
1.9%
학익동 9
 
1.7%
2층 8
 
1.5%
소성로 7
 
1.3%
Other values (180) 238
44.5%
2024-01-28T17:05:59.272890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
450
 
16.4%
인 103
 
3.8%
홀 101
 
3.7%
1 99
 
3.6%
동 98
 
3.6%
미 97
 
3.5%
추 95
 
3.5%
천 91
 
3.3%
시 88
 
3.2%
광 86
 
3.1%
Other values (143) 1429
52.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1619
59.2%
Space Separator 450
 
16.4%
Decimal Number 394
 
14.4%
Open Punctuation 86
 
3.1%
Close Punctuation 86
 
3.1%
Other Punctuation 71
 
2.6%
Uppercase Letter 17
 
0.6%
Dash Punctuation 10
 
0.4%
Lowercase Letter 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 103
 
6.4%
홀 101
 
6.2%
동 98
 
6.1%
미 97
 
6.0%
추 95
 
5.9%
천 91
 
5.6%
시 88
 
5.4%
광 86
 
5.3%
구 86
 
5.3%
역 85
 
5.3%
Other values (115) 689
42.6%
Decimal Number
ValueCountFrequency (%)
1 99
25.1%
2 57
14.5%
3 48
12.2%
4 40
10.2%
0 38
 
9.6%
6 27
 
6.9%
8 26
 
6.6%
5 22
 
5.6%
9 19
 
4.8%
7 18
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
S 4
23.5%
B 2
11.8%
K 2
11.8%
E 2
11.8%
V 2
11.8%
I 2
11.8%
W 2
11.8%
A 1
 
5.9%
Open Punctuation
ValueCountFrequency (%)
( 85
98.8%
[ 1
 
1.2%
Close Punctuation
ValueCountFrequency (%)
) 85
98.8%
] 1
 
1.2%
Other Punctuation
ValueCountFrequency (%)
, 70
98.6%
* 1
 
1.4%
Lowercase Letter
ValueCountFrequency (%)
k 2
50.0%
y 2
50.0%
Space Separator
ValueCountFrequency (%)
450
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1619
59.2%
Common 1097
40.1%
Latin 21
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 103
 
6.4%
홀 101
 
6.2%
동 98
 
6.1%
미 97
 
6.0%
추 95
 
5.9%
천 91
 
5.6%
시 88
 
5.4%
광 86
 
5.3%
구 86
 
5.3%
역 85
 
5.3%
Other values (115) 689
42.6%
Common
ValueCountFrequency (%)
450
41.0%
1 99
 
9.0%
( 85
 
7.7%
) 85
 
7.7%
, 70
 
6.4%
2 57
 
5.2%
3 48
 
4.4%
4 40
 
3.6%
0 38
 
3.5%
6 27
 
2.5%
Other values (8) 98
 
8.9%
Latin
ValueCountFrequency (%)
S 4
19.0%
B 2
9.5%
K 2
9.5%
E 2
9.5%
k 2
9.5%
y 2
9.5%
V 2
9.5%
I 2
9.5%
W 2
9.5%
A 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1619
59.2%
ASCII 1118
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
450
40.3%
1 99
 
8.9%
( 85
 
7.6%
) 85
 
7.6%
, 70
 
6.3%
2 57
 
5.1%
3 48
 
4.3%
4 40
 
3.6%
0 38
 
3.4%
6 27
 
2.4%
Other values (18) 119
 
10.6%
Hangul
ValueCountFrequency (%)
인 103
 
6.4%
홀 101
 
6.2%
동 98
 
6.1%
미 97
 
6.0%
추 95
 
5.9%
천 91
 
5.6%
시 88
 
5.4%
광 86
 
5.3%
구 86
 
5.3%
역 85
 
5.3%
Other values (115) 689
42.6%

전화번호
Text

MISSING 

Distinct28
Distinct (%)96.6%
Missing56
Missing (%)65.9%
Memory size812.0 B
2024-01-28T17:05:59.461840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.103448
Min length12

Characters and Unicode

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

Unique27 ?
Unique (%)93.1%

Sample

1st row032-887-2952
2nd row032-889-1357
3rd row032-889-7582
4th row032-887-2829
5th row032-868-9428
ValueCountFrequency (%)
070-4281-0658 2
 
6.9%
032-887-2952 1
 
3.4%
032-203-0075 1
 
3.4%
032-874-3003 1
 
3.4%
032-880-1882 1
 
3.4%
032-424-3331 1
 
3.4%
032-868-3501 1
 
3.4%
032-713-4904 1
 
3.4%
032-872-7003 1
 
3.4%
032-887-0480 1
 
3.4%
Other values (18) 18
62.1%
2024-01-28T17:05:59.742315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 58
16.5%
0 50
14.2%
2 48
13.7%
8 45
12.8%
3 39
11.1%
7 31
8.8%
5 22
 
6.3%
4 16
 
4.6%
6 16
 
4.6%
1 13
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 293
83.5%
Dash Punctuation 58
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 50
17.1%
2 48
16.4%
8 45
15.4%
3 39
13.3%
7 31
10.6%
5 22
7.5%
4 16
 
5.5%
6 16
 
5.5%
1 13
 
4.4%
9 13
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 351
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 58
16.5%
0 50
14.2%
2 48
13.7%
8 45
12.8%
3 39
11.1%
7 31
8.8%
5 22
 
6.3%
4 16
 
4.6%
6 16
 
4.6%
1 13
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 351
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 58
16.5%
0 50
14.2%
2 48
13.7%
8 45
12.8%
3 39
11.1%
7 31
8.8%
5 22
 
6.3%
4 16
 
4.6%
6 16
 
4.6%
1 13
 
3.7%

Interactions

2024-01-28T17:05:57.559165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T17:05:59.827090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명도로명주소전화번호
연번1.0000.9380.8670.928
상호명0.9381.0001.0001.000
도로명주소0.8671.0001.0001.000
전화번호0.9281.0001.0001.000

Missing values

2024-01-28T17:05:57.642687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T17:05:57.719445image/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동물미용업(일반)이쁜강아지인천광역시 미추홀구 소성로 334 (문학동)<NA>
12동물미용업(일반)파리 애견스타일인천광역시 미추홀구 소성로 237, 201호 (학익동)<NA>
23동물미용업(일반)라르펫인천광역시 미추홀구 노적산로 70, 102호 (학익동)<NA>
34동물미용업(일반)러블리 강아지인천광역시 미추홀구 동산로 9, 1층 (숭의동)<NA>
45동물미용업(일반)개미딱지인천광역시 미추홀구 장천로112번길 5 (숭의동)<NA>
56동물미용업(일반)강아지소풍인천광역시 미추홀구 주승로 98-5 (주안동)<NA>
67동물미용업(일반)한국동물병원인천광역시 미추홀구 낙섬중로 25 (용현동)032-887-2952
78동물미용업(일반)제물포애견인천광역시 미추홀구 수봉로 28 (숭의동)<NA>
89동물미용업(일반)우리집 강아지인천광역시 미추홀구 석정로456번길 4, 1층 (주안동)<NA>
910동물미용업(일반)토토애견인천광역시 미추홀구 제일로 42 (도화동)<NA>
연번유형상호명도로명주소전화번호
7576동물미용업(일반)댕카 미용실인천광역시 미추홀구 미추홀대로722번길 18, 4층 (주안동)<NA>
7677동물미용업(일반)멍블링인천광역시 미추홀구 매소홀로 262, 4층 401호 (학익동)<NA>
7778동물미용업(일반)중앙애견미용실인천광역시 미추홀구 경인로 417-1, 1층 (주안동)032-424-3331
7879동물미용업(일반)멍냥펫살롱인천광역시 미추홀구 연송로 38, 1층 (도화동)<NA>
7980동물미용업(일반)하인츠애견미용실인천광역시 미추홀구 독배로 305, 이한프라자 2층 (용현동)<NA>
8081동물미용업(일반)수박이네인천광역시 미추홀구 인하로 153, 1층 (용현동)<NA>
8182동물미용업(일반)우리동네 개밥하우스인천광역시 미추홀구 독정이로 31(용현동)032-880-1882
8283동물미용업(일반)라온캣독 펫살롱 인천점인천광역시 미추홀구 인주대로458번길 8 (주안동)<NA>
8384동물미용업(일반)파트라슈&네로인천광역시 미추홀구 소성로 99 (학익동)032-874-3003
8485동물미용업(일반)멍블리인천광역시 미추홀구 경인로144번길 10, 영창빌딩 201호 (숭의동)032-215-4748