Overview

Dataset statistics

Number of variables5
Number of observations34
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory44.9 B

Variable types

Numeric1
Categorical1
Text2
DateTime1

Dataset

Description충청북도 옥천군 신고체육시설업 현황에 대한 데이터로 (업종, 상호명, 도로명주소, 데이터기준일) 을 제공합니다.
URLhttps://www.data.go.kr/data/3069438/fileData.do

Alerts

데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
상호 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:07:13.139126
Analysis finished2023-12-12 20:07:13.670606
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.5
Minimum1
Maximum34
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size438.0 B
2023-12-13T05:07:13.761374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.65
Q19.25
median17.5
Q325.75
95-th percentile32.35
Maximum34
Range33
Interquartile range (IQR)16.5

Descriptive statistics

Standard deviation9.9582462
Coefficient of variation (CV)0.56904264
Kurtosis-1.2
Mean17.5
Median Absolute Deviation (MAD)8.5
Skewness0
Sum595
Variance99.166667
MonotonicityStrictly increasing
2023-12-13T05:07:13.922196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
1 1
 
2.9%
27 1
 
2.9%
21 1
 
2.9%
22 1
 
2.9%
23 1
 
2.9%
24 1
 
2.9%
25 1
 
2.9%
26 1
 
2.9%
28 1
 
2.9%
19 1
 
2.9%
Other values (24) 24
70.6%
ValueCountFrequency (%)
1 1
2.9%
2 1
2.9%
3 1
2.9%
4 1
2.9%
5 1
2.9%
6 1
2.9%
7 1
2.9%
8 1
2.9%
9 1
2.9%
10 1
2.9%
ValueCountFrequency (%)
34 1
2.9%
33 1
2.9%
32 1
2.9%
31 1
2.9%
30 1
2.9%
29 1
2.9%
28 1
2.9%
27 1
2.9%
26 1
2.9%
25 1
2.9%

업종
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)20.6%
Missing0
Missing (%)0.0%
Memory size404.0 B
체육도장업
10 
당구장업
8 
체력단련장업
7 
골프연습장업
6 
무도학원업
 
1
Other values (2)
2 

Length

Max length10
Median length6
Mean length5.2647059
Min length4

Unique

Unique3 ?
Unique (%)8.8%

Sample

1st row체육도장업
2nd row체육도장업
3rd row체육도장업
4th row체육도장업
5th row체육도장업

Common Values

ValueCountFrequency (%)
체육도장업 10
29.4%
당구장업 8
23.5%
체력단련장업 7
20.6%
골프연습장업 6
17.6%
무도학원업 1
 
2.9%
승마장업 1
 
2.9%
가상체험 체육시설업 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-13T05:07:14.184728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
체육도장업 10
28.6%
당구장업 8
22.9%
체력단련장업 7
20.0%
골프연습장업 6
17.1%
무도학원업 1
 
2.9%
승마장업 1
 
2.9%
가상체험 1
 
2.9%
체육시설업 1
 
2.9%

상호
Text

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-13T05:07:14.438610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length7.2352941
Min length3

Characters and Unicode

Total characters246
Distinct characters105
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

Unique34 ?
Unique (%)100.0%

Sample

1st row삼교체육관
2nd row청도태권도
3rd row화랑태권도
4th row경희라온태권도
5th row천무태권도
ValueCountFrequency (%)
스크린 2
 
3.8%
삼교체육관 1
 
1.9%
청도태권도 1
 
1.9%
cm 1
 
1.9%
fitness 1
 
1.9%
블루홀스 1
 
1.9%
승마센터 1
 
1.9%
현댄스스포츠 1
 
1.9%
향수당구클럽 1
 
1.9%
청산당구클럽 1
 
1.9%
Other values (41) 41
78.8%
2023-12-13T05:07:14.788584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
18
 
7.3%
스 11
 
4.5%
도 9
 
3.7%
장 8
 
3.3%
구 8
 
3.3%
당 8
 
3.3%
천 8
 
3.3%
럽 6
 
2.4%
프 6
 
2.4%
골 6
 
2.4%
Other values (95) 158
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 213
86.6%
Space Separator 18
 
7.3%
Uppercase Letter 8
 
3.3%
Lowercase Letter 6
 
2.4%
Other Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 11
 
5.2%
도 9
 
4.2%
장 8
 
3.8%
구 8
 
3.8%
당 8
 
3.8%
천 8
 
3.8%
럽 6
 
2.8%
프 6
 
2.8%
골 6
 
2.8%
클 6
 
2.8%
Other values (83) 137
64.3%
Uppercase Letter
ValueCountFrequency (%)
C 3
37.5%
M 2
25.0%
Y 1
 
12.5%
G 1
 
12.5%
F 1
 
12.5%
Lowercase Letter
ValueCountFrequency (%)
s 2
33.3%
e 1
16.7%
n 1
16.7%
i 1
16.7%
t 1
16.7%
Space Separator
ValueCountFrequency (%)
18
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 213
86.6%
Common 19
 
7.7%
Latin 14
 
5.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 11
 
5.2%
도 9
 
4.2%
장 8
 
3.8%
구 8
 
3.8%
당 8
 
3.8%
천 8
 
3.8%
럽 6
 
2.8%
프 6
 
2.8%
골 6
 
2.8%
클 6
 
2.8%
Other values (83) 137
64.3%
Latin
ValueCountFrequency (%)
C 3
21.4%
s 2
14.3%
M 2
14.3%
Y 1
 
7.1%
G 1
 
7.1%
e 1
 
7.1%
n 1
 
7.1%
F 1
 
7.1%
i 1
 
7.1%
t 1
 
7.1%
Common
ValueCountFrequency (%)
18
94.7%
. 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 213
86.6%
ASCII 33
 
13.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
18
54.5%
C 3
 
9.1%
s 2
 
6.1%
M 2
 
6.1%
Y 1
 
3.0%
G 1
 
3.0%
e 1
 
3.0%
n 1
 
3.0%
. 1
 
3.0%
F 1
 
3.0%
Other values (2) 2
 
6.1%
Hangul
ValueCountFrequency (%)
스 11
 
5.2%
도 9
 
4.2%
장 8
 
3.8%
구 8
 
3.8%
당 8
 
3.8%
천 8
 
3.8%
럽 6
 
2.8%
프 6
 
2.8%
골 6
 
2.8%
클 6
 
2.8%
Other values (83) 137
64.3%

도로명주소
Text

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-13T05:07:15.023017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length25
Mean length22.911765
Min length19

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)100.0%

Sample

1st row충청북도 옥천군 옥천읍 성암2길 50
2nd row충청북도 옥천군 옥천읍 장야4길 24
3rd row충청북도 옥천군 옥천읍 가화3길 20, 201호
4th row충청북도 옥천군 옥천읍 중앙로1길 25-16, 학원
5th row충청북도 옥천군 옥천읍 향수1길 29
ValueCountFrequency (%)
충청북도 34
18.0%
옥천군 34
18.0%
옥천읍 31
16.4%
21 3
 
1.6%
동부로 3
 
1.6%
삼양로 3
 
1.6%
3층 3
 
1.6%
중앙로1길 2
 
1.1%
5 2
 
1.1%
3 2
 
1.1%
Other values (62) 72
38.1%
2023-12-13T05:07:15.399620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
155
19.9%
옥 68
 
8.7%
천 68
 
8.7%
청 37
 
4.7%
충 34
 
4.4%
북 34
 
4.4%
도 34
 
4.4%
군 34
 
4.4%
읍 31
 
4.0%
1 25
 
3.2%
Other values (63) 259
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 493
63.3%
Space Separator 155
 
19.9%
Decimal Number 104
 
13.4%
Other Punctuation 13
 
1.7%
Dash Punctuation 10
 
1.3%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
옥 68
13.8%
천 68
13.8%
청 37
 
7.5%
충 34
 
6.9%
북 34
 
6.9%
도 34
 
6.9%
군 34
 
6.9%
읍 31
 
6.3%
로 25
 
5.1%
길 17
 
3.4%
Other values (48) 111
22.5%
Decimal Number
ValueCountFrequency (%)
1 25
24.0%
2 18
17.3%
5 15
14.4%
3 11
10.6%
4 7
 
6.7%
7 7
 
6.7%
6 6
 
5.8%
9 6
 
5.8%
0 5
 
4.8%
8 4
 
3.8%
Space Separator
ValueCountFrequency (%)
155
100.0%
Other Punctuation
ValueCountFrequency (%)
, 13
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 493
63.3%
Common 286
36.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
옥 68
13.8%
천 68
13.8%
청 37
 
7.5%
충 34
 
6.9%
북 34
 
6.9%
도 34
 
6.9%
군 34
 
6.9%
읍 31
 
6.3%
로 25
 
5.1%
길 17
 
3.4%
Other values (48) 111
22.5%
Common
ValueCountFrequency (%)
155
54.2%
1 25
 
8.7%
2 18
 
6.3%
5 15
 
5.2%
, 13
 
4.5%
3 11
 
3.8%
- 10
 
3.5%
4 7
 
2.4%
7 7
 
2.4%
6 6
 
2.1%
Other values (5) 19
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 493
63.3%
ASCII 286
36.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
155
54.2%
1 25
 
8.7%
2 18
 
6.3%
5 15
 
5.2%
, 13
 
4.5%
3 11
 
3.8%
- 10
 
3.5%
4 7
 
2.4%
7 7
 
2.4%
6 6
 
2.1%
Other values (5) 19
 
6.6%
Hangul
ValueCountFrequency (%)
옥 68
13.8%
천 68
13.8%
청 37
 
7.5%
충 34
 
6.9%
북 34
 
6.9%
도 34
 
6.9%
군 34
 
6.9%
읍 31
 
6.3%
로 25
 
5.1%
길 17
 
3.4%
Other values (48) 111
22.5%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
Minimum2023-07-19 00:00:00
Maximum2023-07-19 00:00:00
2023-12-13T05:07:15.506830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:07:15.590222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T05:07:13.347432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:07:15.654621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종상호도로명주소
연번1.0000.8261.0001.000
업종0.8261.0001.0001.000
상호1.0001.0001.0001.000
도로명주소1.0001.0001.0001.000
2023-12-13T05:07:16.006801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.573
업종0.5731.000

Missing values

2023-12-13T05:07:13.510854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:07:13.626703image/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체육도장업삼교체육관충청북도 옥천군 옥천읍 성암2길 502023-07-19
12체육도장업청도태권도충청북도 옥천군 옥천읍 장야4길 242023-07-19
23체육도장업화랑태권도충청북도 옥천군 옥천읍 가화3길 20, 201호2023-07-19
34체육도장업경희라온태권도충청북도 옥천군 옥천읍 중앙로1길 25-16, 학원2023-07-19
45체육도장업천무태권도충청북도 옥천군 옥천읍 향수1길 292023-07-19
56체육도장업김영만 복싱클럽충청북도 옥천군 옥천읍 중앙로9길 62023-07-19
67체육도장업옥천 태권도장충청북도 옥천군 옥천읍 성신로 51-12023-07-19
78체육도장업천무관하랑도장충청북도 옥천군 옥천읍 문장로 82, 빌딩 3층2023-07-19
89체육도장업합기도 양우관 총본관충청북도 옥천군 옥천읍 문장로 932023-07-19
910체육도장업옥천향수검도관충청북도 옥천군 옥천읍 가화길 21, 학원2023-07-19
연번업종상호도로명주소데이터기준일
2425당구장업역전당구장충청북도 옥천군 옥천읍 중앙로1길 32023-07-19
2526당구장업세이당구클럽충청북도 옥천군 옥천읍 중앙로10길 32023-07-19
2627당구장업시크릿당구장충청북도 옥천군 옥천읍 삼양로7길 9-17, 사무소2023-07-19
2728당구장업럭키당구장충청북도 옥천군 옥천읍 삼금로 45, 상가2023-07-19
2829당구장업큐 당구클럽충청북도 옥천군 옥천읍 중앙로5길 5 (음식점)2023-07-19
2930당구장업청산당구클럽충청북도 옥천군 청산면 지전길 21, 음식점2023-07-19
3031당구장업향수당구클럽충청북도 옥천군 옥천읍 금장로 24, 의원 3층2023-07-19
3132무도학원업현댄스스포츠충청북도 옥천군 옥천읍 삼금로5길 7-62023-07-19
3233승마장업블루홀스 승마센터충청북도 옥천군 동이면 옥천동이로 711-132023-07-19
3334가상체험 체육시설업골프존파크 옥천지앤지점충청북도 옥천군 옥천읍 동부로 2272023-07-19