Overview

Dataset statistics

Number of variables4
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory34.3 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Description본 데이터는 완주군 관광사업등록 현황에 대한 데이터로 여행업, 휴양업, 야영장, 한옥체험업 등의 등록현황에 대한 항목을 제공합니다.
Author전북특별자치도 완주군
URLhttps://www.data.go.kr/data/3076582/fileData.do

Alerts

연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 22:51:22.215988
Analysis finished2024-03-14 22:51:23.329744
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50.5
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-15T07:51:23.476073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.95
Q125.75
median50.5
Q375.25
95-th percentile95.05
Maximum100
Range99
Interquartile range (IQR)49.5

Descriptive statistics

Standard deviation29.011492
Coefficient of variation (CV)0.57448499
Kurtosis-1.2
Mean50.5
Median Absolute Deviation (MAD)25
Skewness0
Sum5050
Variance841.66667
MonotonicityStrictly increasing
2024-03-15T07:51:23.818134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%

업종
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
일반야영장업
27 
국내외여행업
15 
국내여행업
14 
종합여행업
10 
한옥체험업(구)
9 
Other values (12)
25 

Length

Max length11
Median length8
Mean length6.04
Min length5

Unique

Unique8 ?
Unique (%)8.0%

Sample

1st row국내여행업
2nd row국내여행업
3rd row국내여행업
4th row국내여행업
5th row국내여행업

Common Values

ValueCountFrequency (%)
일반야영장업 27
27.0%
국내외여행업 15
15.0%
국내여행업 14
14.0%
종합여행업 10
 
10.0%
한옥체험업(구) 9
 
9.0%
한옥체험업 8
 
8.0%
기타유원시설업 5
 
5.0%
자동차야영장업 2
 
2.0%
전문휴양업 2
 
2.0%
관광펜션업 1
 
1.0%
Other values (7) 7
 
7.0%

Length

2024-03-15T07:51:24.075170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일반야영장업 27
27.0%
국내외여행업 15
15.0%
국내여행업 14
14.0%
종합여행업 10
 
10.0%
한옥체험업(구 9
 
9.0%
한옥체험업 8
 
8.0%
기타유원시설업 5
 
5.0%
전문휴양업 2
 
2.0%
자동차야영장업 2
 
2.0%
관광펜션업 1
 
1.0%
Other values (7) 7
 
7.0%

상호
Text

Distinct90
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
2024-03-15T07:51:24.843276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length15
Mean length8.18
Min length2

Characters and Unicode

Total characters818
Distinct characters213
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

Unique80 ?
Unique (%)80.0%

Sample

1st row(유)국제관광
2nd row유)삼신관광여행사
3rd row(유)현대고속관광
4th row유한회사 삼성해외관광
5th row(유)고려항공여행사
ValueCountFrequency (%)
유한회사 5
 
3.6%
캠핑장 3
 
2.2%
아마존 3
 
2.2%
유)국제관광 2
 
1.4%
대한전세버스협동조합 2
 
1.4%
오토캠핑장 2
 
1.4%
유한)동마실업고속관광 2
 
1.4%
산내들희망캠프협동조합 2
 
1.4%
유)삼신관광여행사 2
 
1.4%
야영장 2
 
1.4%
Other values (109) 114
82.0%
2024-03-15T07:51:26.076098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
39
 
4.8%
유 31
 
3.8%
) 28
 
3.4%
( 26
 
3.2%
캠 24
 
2.9%
장 23
 
2.8%
핑 22
 
2.7%
관 21
 
2.6%
광 19
 
2.3%
한 18
 
2.2%
Other values (203) 567
69.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 707
86.4%
Space Separator 39
 
4.8%
Close Punctuation 28
 
3.4%
Open Punctuation 26
 
3.2%
Uppercase Letter 10
 
1.2%
Lowercase Letter 6
 
0.7%
Other Punctuation 1
 
0.1%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 31
 
4.4%
캠 24
 
3.4%
장 23
 
3.3%
핑 22
 
3.1%
관 21
 
3.0%
광 19
 
2.7%
한 18
 
2.5%
사 17
 
2.4%
행 14
 
2.0%
여 14
 
2.0%
Other values (184) 504
71.3%
Uppercase Letter
ValueCountFrequency (%)
L 2
20.0%
R 1
10.0%
Y 1
10.0%
E 1
10.0%
A 1
10.0%
H 1
10.0%
P 1
10.0%
U 1
10.0%
S 1
10.0%
Lowercase Letter
ValueCountFrequency (%)
o 2
33.3%
g 1
16.7%
t 1
16.7%
u 1
16.7%
r 1
16.7%
Space Separator
ValueCountFrequency (%)
39
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 707
86.4%
Common 95
 
11.6%
Latin 16
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 31
 
4.4%
캠 24
 
3.4%
장 23
 
3.3%
핑 22
 
3.1%
관 21
 
3.0%
광 19
 
2.7%
한 18
 
2.5%
사 17
 
2.4%
행 14
 
2.0%
여 14
 
2.0%
Other values (184) 504
71.3%
Latin
ValueCountFrequency (%)
o 2
12.5%
L 2
12.5%
R 1
 
6.2%
Y 1
 
6.2%
E 1
 
6.2%
A 1
 
6.2%
H 1
 
6.2%
g 1
 
6.2%
P 1
 
6.2%
U 1
 
6.2%
Other values (4) 4
25.0%
Common
ValueCountFrequency (%)
39
41.1%
) 28
29.5%
( 26
27.4%
, 1
 
1.1%
2 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 707
86.4%
ASCII 111
 
13.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
39
35.1%
) 28
25.2%
( 26
23.4%
o 2
 
1.8%
L 2
 
1.8%
, 1
 
0.9%
R 1
 
0.9%
2 1
 
0.9%
Y 1
 
0.9%
E 1
 
0.9%
Other values (9) 9
 
8.1%
Hangul
ValueCountFrequency (%)
유 31
 
4.4%
캠 24
 
3.4%
장 23
 
3.3%
핑 22
 
3.1%
관 21
 
3.0%
광 19
 
2.7%
한 18
 
2.5%
사 17
 
2.4%
행 14
 
2.0%
여 14
 
2.0%
Other values (184) 504
71.3%

소재지(도로명)
Text

Distinct83
Distinct (%)83.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
2024-03-15T07:51:27.245545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length33
Mean length25.95
Min length21

Characters and Unicode

Total characters2595
Distinct characters119
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

Unique69 ?
Unique (%)69.0%

Sample

1st row전북특별자치도 완주군 삼례읍 삼례나들목로 107
2nd row전북특별자치도 완주군 삼례읍 동학로 49
3rd row전북특별자치도 완주군 용진면 봉서로 42
4th row전북특별자치도 완주군 상관면 춘향로 4449
5th row전북특별자치도 완주군 봉동읍 완주로 553, 7호
ValueCountFrequency (%)
전북특별자치도 100
19.3%
완주군 100
19.3%
운주면 18
 
3.5%
상관면 11
 
2.1%
삼례읍 9
 
1.7%
소양면 9
 
1.7%
이서면 9
 
1.7%
동상면 8
 
1.5%
구이면 7
 
1.3%
고산면 7
 
1.3%
Other values (152) 241
46.4%
2024-03-15T07:51:28.840848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
419
 
16.1%
주 127
 
4.9%
전 106
 
4.1%
완 104
 
4.0%
북 103
 
4.0%
도 101
 
3.9%
별 100
 
3.9%
자 100
 
3.9%
치 100
 
3.9%
특 100
 
3.9%
Other values (109) 1235
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1732
66.7%
Space Separator 419
 
16.1%
Decimal Number 376
 
14.5%
Dash Punctuation 50
 
1.9%
Other Punctuation 14
 
0.5%
Uppercase Letter 2
 
0.1%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 127
 
7.3%
전 106
 
6.1%
완 104
 
6.0%
북 103
 
5.9%
도 101
 
5.8%
별 100
 
5.8%
자 100
 
5.8%
치 100
 
5.8%
특 100
 
5.8%
군 100
 
5.8%
Other values (92) 691
39.9%
Decimal Number
ValueCountFrequency (%)
1 67
17.8%
2 53
14.1%
5 41
10.9%
3 40
10.6%
4 38
10.1%
0 34
9.0%
7 32
8.5%
6 27
7.2%
9 23
 
6.1%
8 21
 
5.6%
Uppercase Letter
ValueCountFrequency (%)
S 1
50.0%
A 1
50.0%
Space Separator
ValueCountFrequency (%)
419
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%
Other Punctuation
ValueCountFrequency (%)
, 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1732
66.7%
Common 861
33.2%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 127
 
7.3%
전 106
 
6.1%
완 104
 
6.0%
북 103
 
5.9%
도 101
 
5.8%
별 100
 
5.8%
자 100
 
5.8%
치 100
 
5.8%
특 100
 
5.8%
군 100
 
5.8%
Other values (92) 691
39.9%
Common
ValueCountFrequency (%)
419
48.7%
1 67
 
7.8%
2 53
 
6.2%
- 50
 
5.8%
5 41
 
4.8%
3 40
 
4.6%
4 38
 
4.4%
0 34
 
3.9%
7 32
 
3.7%
6 27
 
3.1%
Other values (5) 60
 
7.0%
Latin
ValueCountFrequency (%)
S 1
50.0%
A 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1732
66.7%
ASCII 863
33.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
419
48.6%
1 67
 
7.8%
2 53
 
6.1%
- 50
 
5.8%
5 41
 
4.8%
3 40
 
4.6%
4 38
 
4.4%
0 34
 
3.9%
7 32
 
3.7%
6 27
 
3.1%
Other values (7) 62
 
7.2%
Hangul
ValueCountFrequency (%)
주 127
 
7.3%
전 106
 
6.1%
완 104
 
6.0%
북 103
 
5.9%
도 101
 
5.8%
별 100
 
5.8%
자 100
 
5.8%
치 100
 
5.8%
특 100
 
5.8%
군 100
 
5.8%
Other values (92) 691
39.9%

Interactions

2024-03-15T07:51:22.909742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T07:51:29.002217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종상호소재지(도로명)
연번1.0000.9410.6990.712
업종0.9411.0000.9510.943
상호0.6990.9511.0001.000
소재지(도로명)0.7120.9431.0001.000
2024-03-15T07:51:29.172322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.725
업종0.7251.000

Missing values

2024-03-15T07:51:23.095755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T07:51:23.271468image/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국내여행업(유)국제관광전북특별자치도 완주군 삼례읍 삼례나들목로 107
12국내여행업유)삼신관광여행사전북특별자치도 완주군 삼례읍 동학로 49
23국내여행업(유)현대고속관광전북특별자치도 완주군 용진면 봉서로 42
34국내여행업유한회사 삼성해외관광전북특별자치도 완주군 상관면 춘향로 4449
45국내여행업(유)고려항공여행사전북특별자치도 완주군 봉동읍 완주로 553, 7호
56국내여행업(유한)동마실업고속관광전북특별자치도 완주군 용진면 신지송광로 25-16
67국내여행업(유)미래항공여행사전북특별자치도 완주군 구이면 장미로 240-8
78국내여행업(유)신일해외관광전북특별자치도 완주군 용진면 구억명덕로 63
89국내여행업대한전세버스협동조합전북특별자치도 완주군 봉동읍 완주로 553
910국내여행업(유)서해항공전북특별자치도 완주군 화산면 화산로 900
연번업종상호소재지(도로명)
9091외국인전용유흥음식점업여보여보클럽전북특별자치도 완주군 이서면 오공로 11-20
9192관광순환버스업(유)동마실업고속관광전북특별자치도 완주군 용진읍 신지송광로 25-16
9293관광궤도업(주)양지대둔산삭도전북특별자치도 완주군 운주면 대둔산공원길 55
9394관광극장유흥업HARLEY전북특별자치도 완주군 이서면 오공로 11-23 (대성타워)
9495일반유원시설업법용유원지전북특별자치도 완주군 운주면 금당길 4
9596기타유원시설업아쿠아틱파크 아마존전북특별자치도 완주군 구이면 신전길 75-96
9697기타유원시설업아쿠아틱파크 아마존전북특별자치도 완주군 구이면 신전길 75-96
9798기타유원시설업미니특공대 키즈카페 전주혁신점전북특별자치도 완주군 이서면 안전로 153, 7층 702호
9899기타유원시설업키즈다쿵2 삼봉점전북특별자치도 완주군 삼례읍 삼봉7로 8, 5층,6층
99100기타유원시설업모넬로 전주점전북특별자치도 완주군 이서면 대문안1길 2, 1층