Overview

Dataset statistics

Number of variables5
Number of observations25
Missing cells4
Missing cells (%)3.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory46.3 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description충청북도 영동관내의 동물관련 업소 현황으로 순번, 구분, 업소명, 주소, 전화번호의 정보가 있으며
Author충청북도 영동군
URLhttps://www.data.go.kr/data/15024734/fileData.do

Alerts

순번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 순번High correlation
전화번호 has 4 (16.0%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:45:54.627571
Analysis finished2023-12-12 18:45:55.374568
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13
Minimum1
Maximum25
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2023-12-13T03:45:55.476219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.2
Q17
median13
Q319
95-th percentile23.8
Maximum25
Range24
Interquartile range (IQR)12

Descriptive statistics

Standard deviation7.3598007
Coefficient of variation (CV)0.56613852
Kurtosis-1.2
Mean13
Median Absolute Deviation (MAD)6
Skewness0
Sum325
Variance54.166667
MonotonicityStrictly increasing
2023-12-13T03:45:55.665112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
1 1
 
4.0%
2 1
 
4.0%
25 1
 
4.0%
24 1
 
4.0%
23 1
 
4.0%
22 1
 
4.0%
21 1
 
4.0%
20 1
 
4.0%
19 1
 
4.0%
18 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
1 1
4.0%
2 1
4.0%
3 1
4.0%
4 1
4.0%
5 1
4.0%
6 1
4.0%
7 1
4.0%
8 1
4.0%
9 1
4.0%
10 1
4.0%
ValueCountFrequency (%)
25 1
4.0%
24 1
4.0%
23 1
4.0%
22 1
4.0%
21 1
4.0%
20 1
4.0%
19 1
4.0%
18 1
4.0%
17 1
4.0%
16 1
4.0%

구분
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
동물약국
8 
동물병원
4 
동물판매업등록업소
4 
애견샵
2 
애완용품 파는곳
2 
Other values (4)
5 

Length

Max length10
Median length4
Mean length5.72
Min length3

Unique

Unique3 ?
Unique (%)12.0%

Sample

1st row유기동물보호센터
2nd row동물병원
3rd row동물병원
4th row동물병원
5th row동물병원

Common Values

ValueCountFrequency (%)
동물약국 8
32.0%
동물병원 4
16.0%
동물판매업등록업소 4
16.0%
애견샵 2
 
8.0%
애완용품 파는곳 2
 
8.0%
동물등록대행업체 2
 
8.0%
유기동물보호센터 1
 
4.0%
애견카페 1
 
4.0%
동물장묘업 1
 
4.0%

Length

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

Common Values (Plot)

2023-12-13T03:45:56.017131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물약국 8
29.6%
동물병원 4
14.8%
동물판매업등록업소 4
14.8%
애견샵 2
 
7.4%
애완용품 2
 
7.4%
파는곳 2
 
7.4%
동물등록대행업체 2
 
7.4%
유기동물보호센터 1
 
3.7%
애견카페 1
 
3.7%
동물장묘업 1
 
3.7%

업소명
Text

Distinct22
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-13T03:45:56.256539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length10
Mean length5.48
Min length2

Characters and Unicode

Total characters137
Distinct characters65
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

Unique19 ?
Unique (%)76.0%

Sample

1st row최종주동물병원(위탁운영)
2nd row최종주동물병원
3rd row영동합동동물병원
4th row백동물병원
5th row추동물병원
ValueCountFrequency (%)
백동물병원 2
 
8.0%
퍼피엔젤 2
 
8.0%
최종주동물병원 2
 
8.0%
스타애견 1
 
4.0%
최종주동물병원(위탁운영 1
 
4.0%
서울메디칼약국 1
 
4.0%
동성농장 1
 
4.0%
갈기산 1
 
4.0%
oz 1
 
4.0%
플레이그라운드 1
 
4.0%
Other values (12) 12
48.0%
2023-12-13T03:45:56.664913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 12
 
8.8%
물 8
 
5.8%
국 8
 
5.8%
약 8
 
5.8%
병 7
 
5.1%
원 7
 
5.1%
엔 3
 
2.2%
산 3
 
2.2%
서 3
 
2.2%
스 3
 
2.2%
Other values (55) 75
54.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 130
94.9%
Open Punctuation 2
 
1.5%
Close Punctuation 2
 
1.5%
Uppercase Letter 2
 
1.5%
Space Separator 1
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 12
 
9.2%
물 8
 
6.2%
국 8
 
6.2%
약 8
 
6.2%
병 7
 
5.4%
원 7
 
5.4%
엔 3
 
2.3%
산 3
 
2.3%
서 3
 
2.3%
스 3
 
2.3%
Other values (50) 68
52.3%
Uppercase Letter
ValueCountFrequency (%)
O 1
50.0%
Z 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 130
94.9%
Common 5
 
3.6%
Latin 2
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 12
 
9.2%
물 8
 
6.2%
국 8
 
6.2%
약 8
 
6.2%
병 7
 
5.4%
원 7
 
5.4%
엔 3
 
2.3%
산 3
 
2.3%
서 3
 
2.3%
스 3
 
2.3%
Other values (50) 68
52.3%
Common
ValueCountFrequency (%)
( 2
40.0%
) 2
40.0%
1
20.0%
Latin
ValueCountFrequency (%)
O 1
50.0%
Z 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 130
94.9%
ASCII 7
 
5.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 12
 
9.2%
물 8
 
6.2%
국 8
 
6.2%
약 8
 
6.2%
병 7
 
5.4%
원 7
 
5.4%
엔 3
 
2.3%
산 3
 
2.3%
서 3
 
2.3%
스 3
 
2.3%
Other values (50) 68
52.3%
ASCII
ValueCountFrequency (%)
( 2
28.6%
) 2
28.6%
O 1
14.3%
Z 1
14.3%
1
14.3%

주소
Text

Distinct22
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-13T03:45:56.892469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length25
Mean length21.56
Min length15

Characters and Unicode

Total characters539
Distinct characters54
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique20 ?
Unique (%)80.0%

Sample

1st row충청북도 영동군 영동읍 계산로 54
2nd row충청북도 영동군 영동읍 계산로 54
3rd row충청북도 영동군 영동읍 영동천2길 3-1
4th row충청북도 영동군 영동읍 계산로 27
5th row충청북도 영동군 영동읍 난계로 1166-1
ValueCountFrequency (%)
충청북도 25
19.8%
영동군 25
19.8%
영동읍 17
13.5%
계산로 8
 
6.3%
54 3
 
2.4%
중앙로 3
 
2.4%
용산면 2
 
1.6%
학산면 2
 
1.6%
약국 2
 
1.6%
영동천2길 2
 
1.6%
Other values (36) 37
29.4%
2023-12-13T03:45:57.274340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
107
19.9%
동 46
 
8.5%
영 45
 
8.3%
충 25
 
4.6%
북 25
 
4.6%
도 25
 
4.6%
군 25
 
4.6%
청 25
 
4.6%
읍 17
 
3.2%
산 17
 
3.2%
Other values (44) 182
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 342
63.5%
Space Separator 107
 
19.9%
Decimal Number 75
 
13.9%
Dash Punctuation 11
 
2.0%
Open Punctuation 2
 
0.4%
Close Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 46
13.5%
영 45
13.2%
충 25
 
7.3%
북 25
 
7.3%
도 25
 
7.3%
군 25
 
7.3%
청 25
 
7.3%
읍 17
 
5.0%
산 17
 
5.0%
로 17
 
5.0%
Other values (30) 75
21.9%
Decimal Number
ValueCountFrequency (%)
1 16
21.3%
2 13
17.3%
3 11
14.7%
4 9
12.0%
5 7
9.3%
7 5
 
6.7%
6 5
 
6.7%
0 4
 
5.3%
8 3
 
4.0%
9 2
 
2.7%
Space Separator
ValueCountFrequency (%)
107
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 342
63.5%
Common 197
36.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 46
13.5%
영 45
13.2%
충 25
 
7.3%
북 25
 
7.3%
도 25
 
7.3%
군 25
 
7.3%
청 25
 
7.3%
읍 17
 
5.0%
산 17
 
5.0%
로 17
 
5.0%
Other values (30) 75
21.9%
Common
ValueCountFrequency (%)
107
54.3%
1 16
 
8.1%
2 13
 
6.6%
- 11
 
5.6%
3 11
 
5.6%
4 9
 
4.6%
5 7
 
3.6%
7 5
 
2.5%
6 5
 
2.5%
0 4
 
2.0%
Other values (4) 9
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 342
63.5%
ASCII 197
36.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
107
54.3%
1 16
 
8.1%
2 13
 
6.6%
- 11
 
5.6%
3 11
 
5.6%
4 9
 
4.6%
5 7
 
3.6%
7 5
 
2.5%
6 5
 
2.5%
0 4
 
2.0%
Other values (4) 9
 
4.6%
Hangul
ValueCountFrequency (%)
동 46
13.5%
영 45
13.2%
충 25
 
7.3%
북 25
 
7.3%
도 25
 
7.3%
군 25
 
7.3%
청 25
 
7.3%
읍 17
 
5.0%
산 17
 
5.0%
로 17
 
5.0%
Other values (30) 75
21.9%

전화번호
Text

MISSING 

Distinct17
Distinct (%)81.0%
Missing4
Missing (%)16.0%
Memory size332.0 B
2023-12-13T03:45:57.483499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.857143
Min length9

Characters and Unicode

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

Unique14 ?
Unique (%)66.7%

Sample

1st row043-744-4209
2nd row043-744-4209
3rd row043-742-2055
4th row043-744-8275
5th row043-743-3671
ValueCountFrequency (%)
043-744-4209 3
14.3%
043-742-5008 2
 
9.5%
043-744-8275 2
 
9.5%
043-745-0966 1
 
4.8%
043-742-1545 1
 
4.8%
043-743-8846 1
 
4.8%
043-745-0974 1
 
4.8%
043-744-3396 1
 
4.8%
043-744-1088 1
 
4.8%
043-745-2111 1
 
4.8%
Other values (7) 7
33.3%
2023-12-13T03:45:57.985102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 55
22.1%
- 41
16.5%
0 31
12.4%
3 30
12.0%
7 24
9.6%
2 18
 
7.2%
5 16
 
6.4%
9 9
 
3.6%
6 9
 
3.6%
8 8
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 208
83.5%
Dash Punctuation 41
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 55
26.4%
0 31
14.9%
3 30
14.4%
7 24
11.5%
2 18
 
8.7%
5 16
 
7.7%
9 9
 
4.3%
6 9
 
4.3%
8 8
 
3.8%
1 8
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 249
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 55
22.1%
- 41
16.5%
0 31
12.4%
3 30
12.0%
7 24
9.6%
2 18
 
7.2%
5 16
 
6.4%
9 9
 
3.6%
6 9
 
3.6%
8 8
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 249
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 55
22.1%
- 41
16.5%
0 31
12.4%
3 30
12.0%
7 24
9.6%
2 18
 
7.2%
5 16
 
6.4%
9 9
 
3.6%
6 9
 
3.6%
8 8
 
3.2%

Interactions

2023-12-13T03:45:54.981977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:45:58.142947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분업소명주소전화번호
순번1.0000.8650.8330.9050.773
구분0.8651.0000.6860.0000.000
업소명0.8330.6861.0000.9971.000
주소0.9050.0000.9971.0001.000
전화번호0.7730.0001.0001.0001.000
2023-12-13T03:45:58.292615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분
순번1.0000.661
구분0.6611.000

Missing values

2023-12-13T03:45:55.162714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:45:55.315280image/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유기동물보호센터최종주동물병원(위탁운영)충청북도 영동군 영동읍 계산로 54043-744-4209
12동물병원최종주동물병원충청북도 영동군 영동읍 계산로 54043-744-4209
23동물병원영동합동동물병원충청북도 영동군 영동읍 영동천2길 3-1043-742-2055
34동물병원백동물병원충청북도 영동군 영동읍 계산로 27043-744-8275
45동물병원추동물병원충청북도 영동군 영동읍 난계로 1166-1<NA>
56동물약국서울동물약국충청북도 영동군 상촌면 민주지산로 3026-1043-743-3671
67동물약국용산약국충청북도 영동군 용산면 용산로 333-1043-742-2669
78동물약국남서울약국충청북도 영동군 영동읍 중앙로 33043-745-3223
89동물약국포도알약국충청북도 영동군 영동읍 중앙로3길 2043-745-5332
910동물약국건강약국충청북도 영동군 영동읍 중앙로 44 (약국)043-745-2111
순번구분업소명주소전화번호
1516애완용품 파는곳맘엔독스(애견미용)충청북도 영동군 영동읍 계산로 11-7043-744-3396
1617애완용품 파는곳쥬티펫충청북도 영동군 영동읍 계산로 29043-745-0974
1718애견카페플레이그라운드충청북도 영동군 성안길 25043-743-8846
1819동물판매업등록업소퍼피엔젤충청북도 영동군 영동읍 계산리 683-42번지043-742-5008
1920동물판매업등록업소OZ충청북도 영동군 황간면 소계리 268-2번지<NA>
2021동물판매업등록업소갈기산충청북도 영동군 학산면 지내리 1307-1번지<NA>
2122동물판매업등록업소동성농장충청북도 영동군 용산면 부상리 405번지<NA>
2223동물등록대행업체최종주동물병원충청북도 영동군 영동읍 계산로 54043-744-4209
2324동물등록대행업체백동물병원충청북도 영동군 영동읍 계산로 27043-744-8275
2425동물장묘업스마일어게인충청북도 영동군 추풍령면 작동1길 811544-9262