Overview

Dataset statistics

Number of variables5
Number of observations76
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory41.7 B

Variable types

Categorical4
Text1

Dataset

Description170814전라북도종합관광안내표지설치현황2016
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202799

Alerts

전라북도 종합관광안내표지판 현황 is highly overall correlated with Unnamed: 3High correlation
Unnamed: 3 is highly overall correlated with 전라북도 종합관광안내표지판 현황High correlation

Reproduction

Analysis started2024-03-14 00:41:36.788251
Analysis finished2024-03-14 00:41:37.189564
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

전라북도 종합관광안내표지판 현황
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)21.1%
Missing0
Missing (%)0.0%
Memory size740.0 B
군산(10)
10 
진안(8)
8 
무주(8)
8 
익산(7)
7 
남원(7)
7 
Other values (11)
36 

Length

Max length6
Median length5
Mean length5.0657895
Min length2

Unique

Unique2 ?
Unique (%)2.6%

Sample

1st row시군명
2nd row전주(4)
3rd row전주(4)
4th row전주(4)
5th row전주(4)

Common Values

ValueCountFrequency (%)
군산(10) 10
13.2%
진안(8) 8
10.5%
무주(8) 8
10.5%
익산(7) 7
9.2%
남원(7) 7
9.2%
임실(6) 6
7.9%
전주(4) 4
 
5.3%
정읍(4) 4
 
5.3%
김제(4) 4
 
5.3%
순창(4) 4
 
5.3%
Other values (6) 14
18.4%

Length

2024-03-14T09:41:37.313421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
군산(10 10
13.2%
진안(8 8
10.5%
무주(8 8
10.5%
익산(7 7
9.2%
남원(7 7
9.2%
임실(6 6
7.9%
전주(4 4
 
5.3%
정읍(4 4
 
5.3%
김제(4 4
 
5.3%
순창(4 4
 
5.3%
Other values (6) 14
18.4%

Unnamed: 1
Text

Distinct75
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size740.0 B
2024-03-14T09:41:37.572435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length7.2763158
Min length3

Characters and Unicode

Total characters553
Distinct characters177
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

Unique74 ?
Unique (%)97.4%

Sample

1st row위 치
2nd row덕진공원 입구
3rd row고속버스터미널
4th row시외버스터미널
5th row전주국립박물관
ValueCountFrequency (%)
주차장 6
 
5.8%
내 4
 
3.9%
휴게소 3
 
2.9%
입구 3
 
2.9%
시외버스터미널 2
 
1.9%
터미널 2
 
1.9%
무주반디랜드내 1
 
1.0%
무주리조트 1
 
1.0%
태권도공원 1
 
1.0%
머루와인동굴내 1
 
1.0%
Other values (79) 79
76.7%
2024-03-14T09:41:37.872907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
 
4.9%
장 19
 
3.4%
산 18
 
3.3%
소 16
 
2.9%
휴 14
 
2.5%
주 13
 
2.4%
관 13
 
2.4%
게 11
 
2.0%
차 10
 
1.8%
원 10
 
1.8%
Other values (167) 402
72.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 506
91.5%
Space Separator 27
 
4.9%
Open Punctuation 8
 
1.4%
Close Punctuation 8
 
1.4%
Decimal Number 4
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
장 19
 
3.8%
산 18
 
3.6%
소 16
 
3.2%
휴 14
 
2.8%
주 13
 
2.6%
관 13
 
2.6%
게 11
 
2.2%
차 10
 
2.0%
원 10
 
2.0%
광 9
 
1.8%
Other values (160) 373
73.7%
Decimal Number
ValueCountFrequency (%)
7 1
25.0%
5 1
25.0%
3 1
25.0%
4 1
25.0%
Space Separator
ValueCountFrequency (%)
27
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 506
91.5%
Common 47
 
8.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
장 19
 
3.8%
산 18
 
3.6%
소 16
 
3.2%
휴 14
 
2.8%
주 13
 
2.6%
관 13
 
2.6%
게 11
 
2.2%
차 10
 
2.0%
원 10
 
2.0%
광 9
 
1.8%
Other values (160) 373
73.7%
Common
ValueCountFrequency (%)
27
57.4%
( 8
 
17.0%
) 8
 
17.0%
7 1
 
2.1%
5 1
 
2.1%
3 1
 
2.1%
4 1
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 506
91.5%
ASCII 47
 
8.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
27
57.4%
( 8
 
17.0%
) 8
 
17.0%
7 1
 
2.1%
5 1
 
2.1%
3 1
 
2.1%
4 1
 
2.1%
Hangul
ValueCountFrequency (%)
장 19
 
3.8%
산 18
 
3.6%
소 16
 
3.2%
휴 14
 
2.8%
주 13
 
2.6%
관 13
 
2.6%
게 11
 
2.2%
차 10
 
2.0%
원 10
 
2.0%
광 9
 
1.8%
Other values (160) 373
73.7%

Unnamed: 2
Categorical

Distinct15
Distinct (%)19.7%
Missing0
Missing (%)0.0%
Memory size740.0 B
2002
14 
2004
12 
2003
12 
2005
9 
2012
6 
Other values (10)
23 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique5 ?
Unique (%)6.6%

Sample

1st row설치년도
2nd row2004
3rd row2012
4th row2012
5th row2011

Common Values

ValueCountFrequency (%)
2002 14
18.4%
2004 12
15.8%
2003 12
15.8%
2005 9
11.8%
2012 6
7.9%
2014 5
 
6.6%
2013 4
 
5.3%
2016 4
 
5.3%
2011 3
 
3.9%
2010 2
 
2.6%
Other values (5) 5
 
6.6%

Length

2024-03-14T09:41:37.983376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2002 14
18.4%
2004 12
15.8%
2003 12
15.8%
2005 9
11.8%
2012 6
7.9%
2014 5
 
6.6%
2013 4
 
5.3%
2016 4
 
5.3%
2011 3
 
3.9%
2010 2
 
2.6%
Other values (5) 5
 
6.6%

Unnamed: 3
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size740.0 B
<NA>
20 
2016
16 
2015
13 
2011
7 
2013
6 
Other values (5)
14 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique2 ?
Unique (%)2.6%

Sample

1st row정비년도
2nd row2012
3rd row<NA>
4th row<NA>
5th row2016

Common Values

ValueCountFrequency (%)
<NA> 20
26.3%
2016 16
21.1%
2015 13
17.1%
2011 7
 
9.2%
2013 6
 
7.9%
2012 4
 
5.3%
2014 4
 
5.3%
2009 4
 
5.3%
정비년도 1
 
1.3%
2010 1
 
1.3%

Length

2024-03-14T09:41:38.088706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:41:38.199266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 20
26.3%
2016 16
21.1%
2015 13
17.1%
2011 7
 
9.2%
2013 6
 
7.9%
2012 4
 
5.3%
2014 4
 
5.3%
2009 4
 
5.3%
정비년도 1
 
1.3%
2010 1
 
1.3%

Unnamed: 4
Categorical

Distinct10
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size740.0 B
3600×2400
44 
3900×2400
16 
3000×2400
 
4
3600×2320
 
4
2480×1880
 
2
Other values (5)
6 

Length

Max length9
Median length9
Mean length8.8552632
Min length3

Unique

Unique4 ?
Unique (%)5.3%

Sample

1st row규 격
2nd row3900×2400
3rd row3500×2970
4th row3600×2400
5th row3600×2400

Common Values

ValueCountFrequency (%)
3600×2400 44
57.9%
3900×2400 16
 
21.1%
3000×2400 4
 
5.3%
3600×2320 4
 
5.3%
2480×1880 2
 
2.6%
3500×2400 2
 
2.6%
규 격 1
 
1.3%
3500×2970 1
 
1.3%
3600×2300 1
 
1.3%
<NA> 1
 
1.3%

Length

2024-03-14T09:41:38.315630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:41:38.415859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3600×2400 44
57.1%
3900×2400 16
 
20.8%
3000×2400 4
 
5.2%
3600×2320 4
 
5.2%
2480×1880 2
 
2.6%
3500×2400 2
 
2.6%
규 1
 
1.3%
격 1
 
1.3%
3500×2970 1
 
1.3%
3600×2300 1
 
1.3%

Correlations

2024-03-14T09:41:38.490009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전라북도 종합관광안내표지판 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
전라북도 종합관광안내표지판 현황1.0000.9450.5940.8410.677
Unnamed: 10.9451.0000.9811.0000.905
Unnamed: 20.5940.9811.0000.6150.800
Unnamed: 30.8411.0000.6151.0000.578
Unnamed: 40.6770.9050.8000.5781.000
2024-03-14T09:41:38.571942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전라북도 종합관광안내표지판 현황Unnamed: 4Unnamed: 2Unnamed: 3
전라북도 종합관광안내표지판 현황1.0000.3340.2430.506
Unnamed: 40.3341.0000.4790.322
Unnamed: 20.2430.4791.0000.328
Unnamed: 30.5060.3220.3281.000
2024-03-14T09:41:38.652455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전라북도 종합관광안내표지판 현황Unnamed: 2Unnamed: 3Unnamed: 4
전라북도 종합관광안내표지판 현황1.0000.2430.5060.334
Unnamed: 20.2431.0000.3280.479
Unnamed: 30.5060.3281.0000.322
Unnamed: 40.3340.4790.3221.000

Missing values

2024-03-14T09:41:37.067403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:41:37.150628image/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

전라북도 종합관광안내표지판 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
0시군명위 치설치년도정비년도규 격
1전주(4)덕진공원 입구200420123900×2400
2전주(4)고속버스터미널2012<NA>3500×2970
3전주(4)시외버스터미널2012<NA>3600×2400
4전주(4)전주국립박물관201120163600×2400
5군산(10)금강호휴게소2013<NA>3600×2400
6군산(10)군산공항201220163600×2400
7군산(10)고속도군산(하)휴게소200220133600×2400
8군산(10)여객선터미널(중)2011<NA>2480×1880
9군산(10)여객선 터미널200320122480×1880
전라북도 종합관광안내표지판 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4
66순창(4)순창고추장마을2012<NA>3600×2400
67순창(4)회문산자연휴양림200420163900×2400
68고창(4)선운산관리사무소200220153600×2400
69고창(4)석정 휴스파200220153600×2400
70고창(4)서해고인돌(하)휴게소200220153600×2400
71고창(4)서해고인돌(상)휴게소200320113600×2400
72부안(3)부안영상테마파크200620163600×2400
73부안(3)변산해수욕장200420103900×2400
74부안(3)내소사 주차장2016<NA>3600×2400
75합계74개소<NA><NA><NA>