Overview

Dataset statistics

Number of variables7
Number of observations21
Missing cells1
Missing cells (%)0.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory62.1 B

Variable types

Text3
Categorical3
DateTime1

Dataset

Description본 공공데이터는 완주군 전세특수운송업 현황에 대한 상호명, 사업종류, 사무소 주소 , 전화번호, 관리부서, 관리부서 전화번호 등의 정보를 제공합니다.
Author전라북도 완주군
URLhttps://www.data.go.kr/data/3076564/fileData.do

Alerts

관리부서 has constant value ""Constant
데이터 기준일자 has constant value ""Constant
사업의 종류 is highly overall correlated with 관리부서 연락처High correlation
관리부서 연락처 is highly overall correlated with 사업의 종류High correlation
주사무소전화번호 has 1 (4.8%) missing valuesMissing
상호(업체명) has unique valuesUnique

Reproduction

Analysis started2024-03-14 11:25:03.655753
Analysis finished2024-03-14 11:25:04.623078
Duration0.97 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호(업체명)
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size296.0 B
2024-03-14T20:25:05.258278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.9047619
Min length5

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row(유)전일전세
2nd row대한전세버스협동조합
3rd row(유)국제여행사
4th row(유)삼성해외관광
5th row(유)동마실업고속관광
ValueCountFrequency (%)
유)전일전세 1
 
4.0%
유)하나고속관광 1
 
4.0%
이장 1
 
4.0%
묘지 1
 
4.0%
완주공원 1
 
4.0%
삼봉장의사 1
 
4.0%
장례문화원 1
 
4.0%
봉동호스피스 1
 
4.0%
완주장의사 1
 
4.0%
한길장례식장 1
 
4.0%
Other values (15) 15
60.0%
2024-03-14T20:25:06.516872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 15
 
8.0%
유 15
 
8.0%
) 15
 
8.0%
관 9
 
4.8%
광 9
 
4.8%
사 8
 
4.3%
장 6
 
3.2%
공 5
 
2.7%
해 5
 
2.7%
고 5
 
2.7%
Other values (51) 95
50.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 153
81.8%
Open Punctuation 15
 
8.0%
Close Punctuation 15
 
8.0%
Space Separator 4
 
2.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 15
 
9.8%
관 9
 
5.9%
광 9
 
5.9%
사 8
 
5.2%
장 6
 
3.9%
공 5
 
3.3%
해 5
 
3.3%
고 5
 
3.3%
여 5
 
3.3%
행 5
 
3.3%
Other values (48) 81
52.9%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 153
81.8%
Common 34
 
18.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 15
 
9.8%
관 9
 
5.9%
광 9
 
5.9%
사 8
 
5.2%
장 6
 
3.9%
공 5
 
3.3%
해 5
 
3.3%
고 5
 
3.3%
여 5
 
3.3%
행 5
 
3.3%
Other values (48) 81
52.9%
Common
ValueCountFrequency (%)
( 15
44.1%
) 15
44.1%
4
 
11.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 153
81.8%
ASCII 34
 
18.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 15
44.1%
) 15
44.1%
4
 
11.8%
Hangul
ValueCountFrequency (%)
유 15
 
9.8%
관 9
 
5.9%
광 9
 
5.9%
사 8
 
5.2%
장 6
 
3.9%
공 5
 
3.3%
해 5
 
3.3%
고 5
 
3.3%
여 5
 
3.3%
행 5
 
3.3%
Other values (48) 81
52.9%

사업의 종류
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Memory size296.0 B
전세버스
16 
특수여객
5 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전세버스
2nd row전세버스
3rd row전세버스
4th row전세버스
5th row전세버스

Common Values

ValueCountFrequency (%)
전세버스 16
76.2%
특수여객 5
 
23.8%

Length

2024-03-14T20:25:06.910352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:25:07.227108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전세버스 16
76.2%
특수여객 5
 
23.8%

주사무소 주소
Text

Distinct20
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size296.0 B
2024-03-14T20:25:08.003081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length27
Mean length24.238095
Min length22

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)90.5%

Sample

1st row전북특별자치도 완주군 봉동읍 봉강구만길 8
2nd row전북특별자치도 완주군 봉동읍 둔산3로 12
3rd row전북특별자치도 완주군 삼례읍 하리 488-1
4th row전북특별자치도 완주군 상관면 춘향로 4449
5th row전북특별자치도 완주군 용진읍 신지송광로 25-16
ValueCountFrequency (%)
전북특별자치도 21
19.8%
완주군 21
19.8%
봉동읍 7
 
6.6%
용진읍 5
 
4.7%
완주로 3
 
2.8%
소양면 2
 
1.9%
삼례읍 2
 
1.9%
414 2
 
1.9%
구이면 2
 
1.9%
우주로 2
 
1.9%
Other values (39) 39
36.8%
2024-03-14T20:25:09.251713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
85
 
16.7%
주 27
 
5.3%
완 25
 
4.9%
북 22
 
4.3%
자 21
 
4.1%
치 21
 
4.1%
도 21
 
4.1%
별 21
 
4.1%
특 21
 
4.1%
군 21
 
4.1%
Other values (62) 224
44.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 349
68.6%
Space Separator 85
 
16.7%
Decimal Number 67
 
13.2%
Dash Punctuation 7
 
1.4%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 27
 
7.7%
완 25
 
7.2%
북 22
 
6.3%
자 21
 
6.0%
치 21
 
6.0%
도 21
 
6.0%
별 21
 
6.0%
특 21
 
6.0%
군 21
 
6.0%
전 21
 
6.0%
Other values (49) 128
36.7%
Decimal Number
ValueCountFrequency (%)
1 14
20.9%
4 11
16.4%
2 10
14.9%
8 6
9.0%
3 6
9.0%
0 6
9.0%
7 5
 
7.5%
6 4
 
6.0%
5 3
 
4.5%
9 2
 
3.0%
Space Separator
ValueCountFrequency (%)
85
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 349
68.6%
Common 160
31.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 27
 
7.7%
완 25
 
7.2%
북 22
 
6.3%
자 21
 
6.0%
치 21
 
6.0%
도 21
 
6.0%
별 21
 
6.0%
특 21
 
6.0%
군 21
 
6.0%
전 21
 
6.0%
Other values (49) 128
36.7%
Common
ValueCountFrequency (%)
85
53.1%
1 14
 
8.8%
4 11
 
6.9%
2 10
 
6.2%
- 7
 
4.4%
8 6
 
3.8%
3 6
 
3.8%
0 6
 
3.8%
7 5
 
3.1%
6 4
 
2.5%
Other values (3) 6
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 349
68.6%
ASCII 160
31.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
85
53.1%
1 14
 
8.8%
4 11
 
6.9%
2 10
 
6.2%
- 7
 
4.4%
8 6
 
3.8%
3 6
 
3.8%
0 6
 
3.8%
7 5
 
3.1%
6 4
 
2.5%
Other values (3) 6
 
3.8%
Hangul
ValueCountFrequency (%)
주 27
 
7.7%
완 25
 
7.2%
북 22
 
6.3%
자 21
 
6.0%
치 21
 
6.0%
도 21
 
6.0%
별 21
 
6.0%
특 21
 
6.0%
군 21
 
6.0%
전 21
 
6.0%
Other values (49) 128
36.7%

주사무소전화번호
Text

MISSING 

Distinct20
Distinct (%)100.0%
Missing1
Missing (%)4.8%
Memory size296.0 B
2024-03-14T20:25:10.004418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique20 ?
Unique (%)100.0%

Sample

1st row063-254-7777
2nd row063-243-5552
3rd row063-291-3434
4th row063-223-4142
5th row063-262-8883
ValueCountFrequency (%)
063-254-7777 1
 
5.0%
063-243-5552 1
 
5.0%
063-261-4444 1
 
5.0%
063-285-1009 1
 
5.0%
063-263-4464 1
 
5.0%
063-282-1188 1
 
5.0%
063-221-2581 1
 
5.0%
063-251-6062 1
 
5.0%
063-228-0030 1
 
5.0%
063-227-0038 1
 
5.0%
Other values (10) 10
50.0%
2024-03-14T20:25:11.113769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 40
16.7%
2 37
15.4%
0 32
13.3%
3 32
13.3%
6 28
11.7%
4 23
9.6%
8 14
 
5.8%
1 13
 
5.4%
5 10
 
4.2%
7 9
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 200
83.3%
Dash Punctuation 40
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 37
18.5%
0 32
16.0%
3 32
16.0%
6 28
14.0%
4 23
11.5%
8 14
 
7.0%
1 13
 
6.5%
5 10
 
5.0%
7 9
 
4.5%
9 2
 
1.0%
Dash Punctuation
ValueCountFrequency (%)
- 40
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 240
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 40
16.7%
2 37
15.4%
0 32
13.3%
3 32
13.3%
6 28
11.7%
4 23
9.6%
8 14
 
5.8%
1 13
 
5.4%
5 10
 
4.2%
7 9
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 240
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 40
16.7%
2 37
15.4%
0 32
13.3%
3 32
13.3%
6 28
11.7%
4 23
9.6%
8 14
 
5.8%
1 13
 
5.4%
5 10
 
4.2%
7 9
 
3.8%

관리부서
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size296.0 B
도로교통과 교통행정팀
21 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도로교통과 교통행정팀
2nd row도로교통과 교통행정팀
3rd row도로교통과 교통행정팀
4th row도로교통과 교통행정팀
5th row도로교통과 교통행정팀

Common Values

ValueCountFrequency (%)
도로교통과 교통행정팀 21
100.0%

Length

2024-03-14T20:25:11.724256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:25:12.028368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로교통과 21
50.0%
교통행정팀 21
50.0%

관리부서 연락처
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Memory size296.0 B
063-290-2837
16 
063-290-2802
5 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row063-290-2837
2nd row063-290-2837
3rd row063-290-2837
4th row063-290-2837
5th row063-290-2837

Common Values

ValueCountFrequency (%)
063-290-2837 16
76.2%
063-290-2802 5
 
23.8%

Length

2024-03-14T20:25:12.350462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:25:12.660799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
063-290-2837 16
76.2%
063-290-2802 5
 
23.8%

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size296.0 B
Minimum2024-02-02 00:00:00
Maximum2024-02-02 00:00:00
2024-03-14T20:25:12.952891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:25:13.245582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-03-14T20:25:13.451776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호(업체명)사업의 종류주사무소 주소주사무소전화번호관리부서 연락처
상호(업체명)1.0001.0001.0001.0001.000
사업의 종류1.0001.0001.0001.0000.976
주사무소 주소1.0001.0001.0001.0001.000
주사무소전화번호1.0001.0001.0001.0001.000
관리부서 연락처1.0000.9761.0001.0001.000
2024-03-14T20:25:13.714062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리부서 연락처사업의 종류
관리부서 연락처1.0000.861
사업의 종류0.8611.000
2024-03-14T20:25:13.950915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업의 종류관리부서 연락처
사업의 종류1.0000.861
관리부서 연락처0.8611.000

Missing values

2024-03-14T20:25:04.078027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:25:04.469249image/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

상호(업체명)사업의 종류주사무소 주소주사무소전화번호관리부서관리부서 연락처데이터 기준일자
0(유)전일전세전세버스전북특별자치도 완주군 봉동읍 봉강구만길 8063-254-7777도로교통과 교통행정팀063-290-28372024-02-02
1대한전세버스협동조합전세버스전북특별자치도 완주군 봉동읍 둔산3로 12063-243-5552도로교통과 교통행정팀063-290-28372024-02-02
2(유)국제여행사전세버스전북특별자치도 완주군 삼례읍 하리 488-1063-291-3434도로교통과 교통행정팀063-290-28372024-02-02
3(유)삼성해외관광전세버스전북특별자치도 완주군 상관면 춘향로 4449063-223-4142도로교통과 교통행정팀063-290-28372024-02-02
4(유)동마실업고속관광전세버스전북특별자치도 완주군 용진읍 신지송광로 25-16063-262-8883도로교통과 교통행정팀063-290-28372024-02-02
5(유)전주한솔해외여행사전세버스전북특별자치도 완주군 용진읍 완주로 272063-284-2180도로교통과 교통행정팀063-290-28372024-02-02
6(유)서해항공전세버스전북특별자치도 완주군 화산면 화산로 900063-237-3187도로교통과 교통행정팀063-290-28372024-02-02
7(유)미래항공여행사전세버스전북특별자치도 완주군 구이면 장미로 240-8063-273-6600도로교통과 교통행정팀063-290-28372024-02-02
8(유)신일해외관광전세버스전북특별자치도 완주군 용진읍 구억명덕로 63063-242-0152도로교통과 교통행정팀063-290-28372024-02-02
9(유)영진관광전세버스전북특별자치도 완주군 소양면 소양로 216-1063-244-2242도로교통과 교통행정팀063-290-28372024-02-02
상호(업체명)사업의 종류주사무소 주소주사무소전화번호관리부서관리부서 연락처데이터 기준일자
11(유)삼남해외관광전세버스전북특별자치도 완주군 삼례읍 동학로 87063-227-0038도로교통과 교통행정팀063-290-28372024-02-02
12(유)현대고속관광전세버스전북특별자치도 완주군 용진읍 봉서로 42063-228-0030도로교통과 교통행정팀063-290-28372024-02-02
13(유)하나고속관광전세버스전북특별자치도 완주군 소양면 대흥봉덕길 3-10063-251-6062도로교통과 교통행정팀063-290-28372024-02-02
14(유)대진고속관광전세버스전북특별자치도 완주군 구이면 원계곡길 11063-221-2581도로교통과 교통행정팀063-290-28372024-02-02
15(유)고려항공여행사전세버스전북특별자치도 완주군 봉동읍 완주로 553, 7호063-282-1188도로교통과 교통행정팀063-290-28372024-02-02
16한길장례식장특수여객전북특별자치도 완주군 봉동읍 낙평남북로 104-17063-263-4464도로교통과 교통행정팀063-290-28022024-02-02
17완주장의사특수여객전북특별자치도 완주군 봉동읍 우주로 414063-285-1009도로교통과 교통행정팀063-290-28022024-02-02
18봉동호스피스 장례문화원특수여객전북특별자치도 완주군 용진읍 완주로 807063-261-4444도로교통과 교통행정팀063-290-28022024-02-02
19삼봉장의사특수여객전북특별자치도 완주군 봉동읍 우주로 414063-251-4434도로교통과 교통행정팀063-290-28022024-02-02
20완주공원 묘지 이장 공사특수여객전북특별자치도 완주군 비봉면 율소3길 122-3<NA>도로교통과 교통행정팀063-290-28022024-02-02