Overview

Dataset statistics

Number of variables8
Number of observations68
Missing cells98
Missing cells (%)18.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory65.9 B

Variable types

Text3
Categorical3
Boolean1
DateTime1

Dataset

Description충청북도 충주시 동물관련 영업현황과 관련된 데이터 제공(사업장명칭, 영업내용, 주소, 전화번호, 동물등록 대행여부, 관련부서, 전화번호, 데이터기준일자)
URLhttps://www.data.go.kr/data/15033778/fileData.do

Alerts

동물등록대행여부 has constant value ""Constant
관련부서 has constant value ""Constant
데이터기준일자 has constant value ""Constant
부서전화번호 is highly overall correlated with 영업의내용High correlation
영업의내용 is highly overall correlated with 부서전화번호High correlation
전화번호 has 39 (57.4%) missing valuesMissing
동물등록대행여부 has 59 (86.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 12:13:11.605375
Analysis finished2023-12-12 12:13:12.370166
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업장명칭
Text

Distinct66
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size676.0 B
2023-12-12T21:13:12.555526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length6.5882353
Min length2

Characters and Unicode

Total characters448
Distinct characters171
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 (%)94.1%

Sample

1st row이개 내고양이
2nd row하얀강아지&고양이
3rd row골드애견
4th row견우애견
5th row(주)더부루벨
ValueCountFrequency (%)
보드미동물병원 2
 
2.3%
애견 2
 
2.3%
가인동물병원 2
 
2.3%
충주축협동물병원 1
 
1.1%
중앙동물의료센터 1
 
1.1%
핫도그 1
 
1.1%
큰동물병원(출장진료전문병원 1
 
1.1%
뽀독 1
 
1.1%
애견미용실 1
 
1.1%
솜사탕 1
 
1.1%
Other values (74) 74
85.1%
2023-12-12T21:13:12.980922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
원 22
 
4.9%
19
 
4.2%
병 18
 
4.0%
동 17
 
3.8%
물 16
 
3.6%
이 11
 
2.5%
견 11
 
2.5%
아 11
 
2.5%
애 10
 
2.2%
) 8
 
1.8%
Other values (161) 305
68.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 384
85.7%
Space Separator 19
 
4.2%
Uppercase Letter 17
 
3.8%
Close Punctuation 8
 
1.8%
Open Punctuation 8
 
1.8%
Lowercase Letter 6
 
1.3%
Other Punctuation 3
 
0.7%
Decimal Number 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 22
 
5.7%
병 18
 
4.7%
동 17
 
4.4%
물 16
 
4.2%
이 11
 
2.9%
견 11
 
2.9%
아 11
 
2.9%
애 10
 
2.6%
개 8
 
2.1%
주 7
 
1.8%
Other values (134) 253
65.9%
Uppercase Letter
ValueCountFrequency (%)
E 2
11.8%
T 2
11.8%
B 2
11.8%
H 1
 
5.9%
N 1
 
5.9%
O 1
 
5.9%
Y 1
 
5.9%
L 1
 
5.9%
A 1
 
5.9%
S 1
 
5.9%
Other values (4) 4
23.5%
Lowercase Letter
ValueCountFrequency (%)
o 2
33.3%
n 1
16.7%
a 1
16.7%
u 1
16.7%
m 1
16.7%
Decimal Number
ValueCountFrequency (%)
4 1
33.3%
3 1
33.3%
1 1
33.3%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
, 1
33.3%
Space Separator
ValueCountFrequency (%)
19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 384
85.7%
Common 41
 
9.2%
Latin 23
 
5.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 22
 
5.7%
병 18
 
4.7%
동 17
 
4.4%
물 16
 
4.2%
이 11
 
2.9%
견 11
 
2.9%
아 11
 
2.9%
애 10
 
2.6%
개 8
 
2.1%
주 7
 
1.8%
Other values (134) 253
65.9%
Latin
ValueCountFrequency (%)
E 2
 
8.7%
T 2
 
8.7%
B 2
 
8.7%
o 2
 
8.7%
H 1
 
4.3%
N 1
 
4.3%
O 1
 
4.3%
n 1
 
4.3%
a 1
 
4.3%
u 1
 
4.3%
Other values (9) 9
39.1%
Common
ValueCountFrequency (%)
19
46.3%
) 8
19.5%
( 8
19.5%
& 2
 
4.9%
, 1
 
2.4%
4 1
 
2.4%
3 1
 
2.4%
1 1
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 384
85.7%
ASCII 64
 
14.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
원 22
 
5.7%
병 18
 
4.7%
동 17
 
4.4%
물 16
 
4.2%
이 11
 
2.9%
견 11
 
2.9%
아 11
 
2.9%
애 10
 
2.6%
개 8
 
2.1%
주 7
 
1.8%
Other values (134) 253
65.9%
ASCII
ValueCountFrequency (%)
19
29.7%
) 8
12.5%
( 8
12.5%
& 2
 
3.1%
E 2
 
3.1%
T 2
 
3.1%
B 2
 
3.1%
o 2
 
3.1%
H 1
 
1.6%
, 1
 
1.6%
Other values (17) 17
26.6%

영업의내용
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)17.6%
Missing0
Missing (%)0.0%
Memory size676.0 B
동물 ( 미용 )
19 
동물병원
14 
동물 ( 위탁관리 미용 )
11 
동물 ( 판매 )
9 
동물 ( 위탁관리 )
5 
Other values (7)
10 

Length

Max length17
Median length14
Mean length9.75
Min length4

Unique

Unique4 ?
Unique (%)5.9%

Sample

1st row동물 ( 판매 )
2nd row동물 ( 판매 위탁관리 미용 )
3rd row동물 ( 판매 위탁관리 미용 )
4th row동물 ( 판매 )
5th row동물 ( 판매 )

Common Values

ValueCountFrequency (%)
동물 ( 미용 ) 19
27.9%
동물병원 14
20.6%
동물 ( 위탁관리 미용 ) 11
16.2%
동물 ( 판매 ) 9
13.2%
동물 ( 위탁관리 ) 5
 
7.4%
동물 ( 판매 위탁관리 미용 ) 2
 
2.9%
동물 ( 판매 미용 ) 2
 
2.9%
동물 ( 판매 위탁관리 ) 2
 
2.9%
동물 ( 판매 전시 위탁관리 ) 1
 
1.5%
동물 ( 전시 미용 ) 1
 
1.5%
Other values (2) 2
 
2.9%

Length

2023-12-12T21:13:13.134409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
108
42.4%
동물 54
21.2%
미용 36
 
14.1%
위탁관리 23
 
9.0%
판매 16
 
6.3%
동물병원 14
 
5.5%
전시 2
 
0.8%
운송 2
 
0.8%

소재지주소
Text

Distinct64
Distinct (%)94.1%
Missing0
Missing (%)0.0%
Memory size676.0 B
2023-12-12T21:13:13.479559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length33
Mean length25.867647
Min length20

Characters and Unicode

Total characters1759
Distinct characters121
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

Unique60 ?
Unique (%)88.2%

Sample

1st row충청북도 충주시 연수서편3길 33 (연수동)
2nd row충청북도 충주시 국원대로 30 (봉방동)
3rd row충청북도 충주시 지현천변1길 33-3 (지현동)
4th row충청북도 충주시 사직로 178 (지현동)
5th row충청북도 충주시 중원대로 3420 (문화동, 이마트)
ValueCountFrequency (%)
충청북도 68
17.9%
충주시 68
17.9%
1층 17
 
4.5%
연수동 14
 
3.7%
교현동 12
 
3.2%
용산동 8
 
2.1%
계명대로 7
 
1.8%
국원대로 6
 
1.6%
예성로 5
 
1.3%
칠금동 5
 
1.3%
Other values (135) 169
44.6%
2023-12-12T21:13:13.968213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
311
17.7%
충 137
 
7.8%
1 76
 
4.3%
동 71
 
4.0%
주 70
 
4.0%
청 69
 
3.9%
북 68
 
3.9%
도 68
 
3.9%
시 68
 
3.9%
( 62
 
3.5%
Other values (111) 759
43.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1019
57.9%
Space Separator 311
 
17.7%
Decimal Number 259
 
14.7%
Open Punctuation 62
 
3.5%
Close Punctuation 62
 
3.5%
Other Punctuation 31
 
1.8%
Dash Punctuation 14
 
0.8%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
충 137
 
13.4%
동 71
 
7.0%
주 70
 
6.9%
청 69
 
6.8%
북 68
 
6.7%
도 68
 
6.7%
시 68
 
6.7%
로 45
 
4.4%
길 24
 
2.4%
대 23
 
2.3%
Other values (95) 376
36.9%
Decimal Number
ValueCountFrequency (%)
1 76
29.3%
3 40
15.4%
2 37
14.3%
5 24
 
9.3%
0 21
 
8.1%
4 19
 
7.3%
8 12
 
4.6%
9 11
 
4.2%
6 10
 
3.9%
7 9
 
3.5%
Space Separator
ValueCountFrequency (%)
311
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 14
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1019
57.9%
Common 739
42.0%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
충 137
 
13.4%
동 71
 
7.0%
주 70
 
6.9%
청 69
 
6.8%
북 68
 
6.7%
도 68
 
6.7%
시 68
 
6.7%
로 45
 
4.4%
길 24
 
2.4%
대 23
 
2.3%
Other values (95) 376
36.9%
Common
ValueCountFrequency (%)
311
42.1%
1 76
 
10.3%
( 62
 
8.4%
) 62
 
8.4%
3 40
 
5.4%
2 37
 
5.0%
, 31
 
4.2%
5 24
 
3.2%
0 21
 
2.8%
4 19
 
2.6%
Other values (5) 56
 
7.6%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1019
57.9%
ASCII 740
42.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
311
42.0%
1 76
 
10.3%
( 62
 
8.4%
) 62
 
8.4%
3 40
 
5.4%
2 37
 
5.0%
, 31
 
4.2%
5 24
 
3.2%
0 21
 
2.8%
4 19
 
2.6%
Other values (6) 57
 
7.7%
Hangul
ValueCountFrequency (%)
충 137
 
13.4%
동 71
 
7.0%
주 70
 
6.9%
청 69
 
6.8%
북 68
 
6.7%
도 68
 
6.7%
시 68
 
6.7%
로 45
 
4.4%
길 24
 
2.4%
대 23
 
2.3%
Other values (95) 376
36.9%

전화번호
Text

MISSING 

Distinct24
Distinct (%)82.8%
Missing39
Missing (%)57.4%
Memory size676.0 B
2023-12-12T21:13:14.246334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique19 ?
Unique (%)65.5%

Sample

1st row043-842-4929
2nd row043-845-0079
3rd row043-846-8654
4th row043-841-1052
5th row043-841-2500
ValueCountFrequency (%)
043-856-0049 2
 
6.9%
043-843-0075 2
 
6.9%
043-851-3040 2
 
6.9%
043-841-1052 2
 
6.9%
043-844-2223 2
 
6.9%
043-842-4579 1
 
3.4%
043-823-1223 1
 
3.4%
043-852-8875 1
 
3.4%
043-854-8054 1
 
3.4%
043-847-7582 1
 
3.4%
Other values (14) 14
48.3%
2023-12-12T21:13:14.638961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 59
17.0%
- 58
16.7%
0 55
15.8%
3 43
12.4%
5 35
10.1%
8 34
9.8%
2 24
6.9%
1 15
 
4.3%
7 11
 
3.2%
6 7
 
2.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 290
83.3%
Dash Punctuation 58
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 59
20.3%
0 55
19.0%
3 43
14.8%
5 35
12.1%
8 34
11.7%
2 24
8.3%
1 15
 
5.2%
7 11
 
3.8%
6 7
 
2.4%
9 7
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 348
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 59
17.0%
- 58
16.7%
0 55
15.8%
3 43
12.4%
5 35
10.1%
8 34
9.8%
2 24
6.9%
1 15
 
4.3%
7 11
 
3.2%
6 7
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 348
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 59
17.0%
- 58
16.7%
0 55
15.8%
3 43
12.4%
5 35
10.1%
8 34
9.8%
2 24
6.9%
1 15
 
4.3%
7 11
 
3.2%
6 7
 
2.0%

동물등록대행여부
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)11.1%
Missing59
Missing (%)86.8%
Memory size268.0 B
True
9 
(Missing)
59 
ValueCountFrequency (%)
True 9
 
13.2%
(Missing) 59
86.8%
2023-12-12T21:13:14.806555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

관련부서
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size676.0 B
충주시청 축수산과
68 

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 (%)
충주시청 축수산과 68
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:13:15.030066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충주시청 68
50.0%
축수산과 68
50.0%

부서전화번호
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size676.0 B
043-850-5862
54 
043-850-5873
14 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row043-850-5862
2nd row043-850-5862
3rd row043-850-5862
4th row043-850-5862
5th row043-850-5862

Common Values

ValueCountFrequency (%)
043-850-5862 54
79.4%
043-850-5873 14
 
20.6%

Length

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

Common Values (Plot)

2023-12-12T21:13:15.290300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
043-850-5862 54
79.4%
043-850-5873 14
 
20.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size676.0 B
Minimum2023-04-30 00:00:00
Maximum2023-04-30 00:00:00
2023-12-12T21:13:15.409295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:13:15.545075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T21:13:15.671338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업장명칭영업의내용소재지주소전화번호부서전화번호
사업장명칭1.0000.9880.9971.0000.000
영업의내용0.9881.0000.9300.9521.000
소재지주소0.9970.9301.0000.9870.000
전화번호1.0000.9520.9871.0000.000
부서전화번호0.0001.0000.0000.0001.000
2023-12-12T21:13:15.790722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서전화번호영업의내용
부서전화번호1.0000.921
영업의내용0.9211.000
2023-12-12T21:13:15.905731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업의내용부서전화번호
영업의내용1.0000.921
부서전화번호0.9211.000

Missing values

2023-12-12T21:13:12.100010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:13:12.218623image/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.
2023-12-12T21:13:12.324008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

사업장명칭영업의내용소재지주소전화번호동물등록대행여부관련부서부서전화번호데이터기준일자
0이개 내고양이동물 ( 판매 )충청북도 충주시 연수서편3길 33 (연수동)<NA><NA>충주시청 축수산과043-850-58622023-04-30
1하얀강아지&고양이동물 ( 판매 위탁관리 미용 )충청북도 충주시 국원대로 30 (봉방동)043-842-4929<NA>충주시청 축수산과043-850-58622023-04-30
2골드애견동물 ( 판매 위탁관리 미용 )충청북도 충주시 지현천변1길 33-3 (지현동)043-845-0079<NA>충주시청 축수산과043-850-58622023-04-30
3견우애견동물 ( 판매 )충청북도 충주시 사직로 178 (지현동)043-846-8654<NA>충주시청 축수산과043-850-58622023-04-30
4(주)더부루벨동물 ( 판매 )충청북도 충주시 중원대로 3420 (문화동, 이마트)043-841-1052<NA>충주시청 축수산과043-850-58622023-04-30
5(주)롯데마트(충주점)동물 ( 판매 )충청북도 충주시 봉계1길 49 (칠금동, 충주공용버스터미널)043-841-2500<NA>충주시청 축수산과043-850-58622023-04-30
6스타펫미팅동물 ( 판매 전시 위탁관리 )충청북도 충주시 성서7길 29-1 (성서동)<NA><NA>충주시청 축수산과043-850-58622023-04-30
7로얄수족관(이마트충주점)동물 ( 판매 )충청북도 충주시 중원대로 3420 (문화동)043-841-1052<NA>충주시청 축수산과043-850-58622023-04-30
8헬로독동물 ( 판매 )충청북도 충주시 연수서3길 4 (연수동)<NA><NA>충주시청 축수산과043-850-58622023-04-30
9바둑아 놀자동물 ( 판매 미용 )충청북도 충주시 형설로 173 (성내동)043-843-0630<NA>충주시청 축수산과043-850-58622023-04-30
사업장명칭영업의내용소재지주소전화번호동물등록대행여부관련부서부서전화번호데이터기준일자
58보드미동물병원동물병원충청북도 충주시 국원대로 108 (교현동)043-843-0075Y충주시청 축수산과043-850-58732023-04-30
59애플동물병원동물병원충청북도 충주시 계명대로 15, 하나빌딩 1층 (칠금동)043-911-8275Y충주시청 축수산과043-850-58732023-04-30
60열린동물병원동물병원충청북도 충주시 금릉로 78 (교현동)043-857-0075Y충주시청 축수산과043-850-58732023-04-30
61용산동물병원동물병원충청북도 충주시 용산동 1953(형설로 54-11)043-847-7582Y충주시청 축수산과043-850-58732023-04-30
62정종합동물병원동물병원충청북도 충주시 지현천변1길 57 (지현동, 정종합동물병원)043-854-8054Y충주시청 축수산과043-850-58732023-04-30
63중앙동물의료센터동물병원충청북도 충주시 국원대로 131, 1층 (교현동)043-852-8875Y충주시청 축수산과043-850-58732023-04-30
64충주축협동물병원동물병원충청북도 충주시 예성로 256 (교현동)043-850-7555<NA>충주시청 축수산과043-850-58732023-04-30
65큰동물병원(출장진료전문병원)동물병원충청북도 충주시 주덕읍 신덕로 1364-1<NA><NA>충주시청 축수산과043-850-58732023-04-30
66현대동물병원동물병원충청북도 충주시 번영대로 144 (연수동)043-851-3040Y충주시청 축수산과043-850-58732023-04-30
67삼성동물병원(출장진료전문병원)동물병원충청북도 충주시 대림9길 28(문화동)<NA><NA>충주시청 축수산과043-850-58732023-04-30