Overview

Dataset statistics

Number of variables6
Number of observations29
Missing cells3
Missing cells (%)1.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory53.4 B

Variable types

Numeric1
Categorical1
DateTime1
Text3

Dataset

Description전북특별자치도 박물관 현황(박물관명, 위치, 연락처 등)전북특별자치도 박물관의 일률적으로 연속되어 있는 번호, 전북특별자치도 박물관의 구분
Author전북특별자치도
URLhttps://www.data.go.kr/data/15055693/fileData.do

Alerts

연번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 연번High correlation
연락처 has 3 (10.3%) missing valuesMissing
연번 has unique valuesUnique
박물관명 has unique valuesUnique
주 소 has unique valuesUnique

Reproduction

Analysis started2024-03-15 00:13:15.625076
Analysis finished2024-03-15 00:13:16.738866
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15
Minimum1
Maximum29
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size389.0 B
2024-03-15T09:13:16.848778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.4
Q18
median15
Q322
95-th percentile27.6
Maximum29
Range28
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.5146932
Coefficient of variation (CV)0.56764621
Kurtosis-1.2
Mean15
Median Absolute Deviation (MAD)7
Skewness0
Sum435
Variance72.5
MonotonicityStrictly increasing
2024-03-15T09:13:17.177666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
1 1
 
3.4%
2 1
 
3.4%
29 1
 
3.4%
28 1
 
3.4%
27 1
 
3.4%
26 1
 
3.4%
25 1
 
3.4%
24 1
 
3.4%
23 1
 
3.4%
22 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
1 1
3.4%
2 1
3.4%
3 1
3.4%
4 1
3.4%
5 1
3.4%
6 1
3.4%
7 1
3.4%
8 1
3.4%
9 1
3.4%
10 1
3.4%
ValueCountFrequency (%)
29 1
3.4%
28 1
3.4%
27 1
3.4%
26 1
3.4%
25 1
3.4%
24 1
3.4%
23 1
3.4%
22 1
3.4%
21 1
3.4%
20 1
3.4%

구분
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size360.0 B
공립
18 
사립
7 
대학
4 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공립
2nd row공립
3rd row공립
4th row공립
5th row공립

Common Values

ValueCountFrequency (%)
공립 18
62.1%
사립 7
 
24.1%
대학 4
 
13.8%

Length

2024-03-15T09:13:17.596680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:13:17.934008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공립 18
62.1%
사립 7
 
24.1%
대학 4
 
13.8%

등록일
Date

Distinct25
Distinct (%)86.2%
Missing0
Missing (%)0.0%
Memory size360.0 B
Minimum1990-10-26 00:00:00
Maximum2013-08-29 00:00:00
2024-03-15T09:13:18.533478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:13:18.923764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

박물관명
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size360.0 B
2024-03-15T09:13:19.739070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length10
Mean length8.1034483
Min length5

Characters and Unicode

Total characters235
Distinct characters91
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

Unique29 ?
Unique (%)100.0%

Sample

1st row국립전주박물관
2nd row미륵사지유물전시관
3rd row전주역사박물관
4th row익산보석박물관
5th row남원향토박물관
ValueCountFrequency (%)
국립전주박물관 1
 
3.3%
미륵사지유물전시관 1
 
3.3%
군산대학교박물관 1
 
3.3%
전주대학교박물관 1
 
3.3%
전북대학교박물관 1
 
3.3%
완주책박물관 1
 
3.3%
연안이씨종중문적(보물651호)박물관 1
 
3.3%
카메라영상박물관 1
 
3.3%
예수병원의학박물관 1
 
3.3%
전주한지박물관 1
 
3.3%
Other values (20) 20
66.7%
2024-03-15T09:13:20.887445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
관 29
 
12.3%
물 28
 
11.9%
박 26
 
11.1%
전 10
 
4.3%
주 6
 
2.6%
사 6
 
2.6%
학 6
 
2.6%
대 5
 
2.1%
교 5
 
2.1%
원 5
 
2.1%
Other values (81) 109
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 229
97.4%
Decimal Number 3
 
1.3%
Close Punctuation 1
 
0.4%
Open Punctuation 1
 
0.4%
Space Separator 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 29
 
12.7%
물 28
 
12.2%
박 26
 
11.4%
전 10
 
4.4%
주 6
 
2.6%
사 6
 
2.6%
학 6
 
2.6%
대 5
 
2.2%
교 5
 
2.2%
원 5
 
2.2%
Other values (75) 103
45.0%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
5 1
33.3%
6 1
33.3%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 229
97.4%
Common 6
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
관 29
 
12.7%
물 28
 
12.2%
박 26
 
11.4%
전 10
 
4.4%
주 6
 
2.6%
사 6
 
2.6%
학 6
 
2.6%
대 5
 
2.2%
교 5
 
2.2%
원 5
 
2.2%
Other values (75) 103
45.0%
Common
ValueCountFrequency (%)
) 1
16.7%
1 1
16.7%
5 1
16.7%
6 1
16.7%
( 1
16.7%
1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 229
97.4%
ASCII 6
 
2.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
관 29
 
12.7%
물 28
 
12.2%
박 26
 
11.4%
전 10
 
4.4%
주 6
 
2.6%
사 6
 
2.6%
학 6
 
2.6%
대 5
 
2.2%
교 5
 
2.2%
원 5
 
2.2%
Other values (75) 103
45.0%
ASCII
ValueCountFrequency (%)
) 1
16.7%
1 1
16.7%
5 1
16.7%
6 1
16.7%
( 1
16.7%
1
16.7%

주 소
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size360.0 B
2024-03-15T09:13:21.917795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length15.068966
Min length11

Characters and Unicode

Total characters437
Distinct characters92
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

Unique29 ?
Unique (%)100.0%

Sample

1st row전주시 완산구 효자동
2nd row익산시 금마면 미륵사지로 362
3rd row전주시 완산구 쑥고개로 251
4th row익산시 왕궁면 호반로 8
5th row전북 남원시 양림길 14-9
ValueCountFrequency (%)
전주시 8
 
7.1%
익산시 7
 
6.2%
완산구 6
 
5.3%
왕궁면 2
 
1.8%
완주군 2
 
1.8%
부안군 2
 
1.8%
익산대로 2
 
1.8%
군산시 2
 
1.8%
덕진구 2
 
1.8%
정읍시 2
 
1.8%
Other values (76) 78
69.0%
2024-03-15T09:13:23.186792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
85
 
19.5%
시 21
 
4.8%
산 19
 
4.3%
로 19
 
4.3%
1 16
 
3.7%
4 15
 
3.4%
7 12
 
2.7%
면 11
 
2.5%
주 10
 
2.3%
군 10
 
2.3%
Other values (82) 219
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 264
60.4%
Space Separator 85
 
19.5%
Decimal Number 83
 
19.0%
Dash Punctuation 5
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 21
 
8.0%
산 19
 
7.2%
로 19
 
7.2%
면 11
 
4.2%
주 10
 
3.8%
군 10
 
3.8%
전 9
 
3.4%
익 9
 
3.4%
완 8
 
3.0%
구 8
 
3.0%
Other values (70) 140
53.0%
Decimal Number
ValueCountFrequency (%)
1 16
19.3%
4 15
18.1%
7 12
14.5%
2 8
9.6%
0 7
8.4%
3 7
8.4%
5 5
 
6.0%
6 5
 
6.0%
9 4
 
4.8%
8 4
 
4.8%
Space Separator
ValueCountFrequency (%)
85
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 264
60.4%
Common 173
39.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 21
 
8.0%
산 19
 
7.2%
로 19
 
7.2%
면 11
 
4.2%
주 10
 
3.8%
군 10
 
3.8%
전 9
 
3.4%
익 9
 
3.4%
완 8
 
3.0%
구 8
 
3.0%
Other values (70) 140
53.0%
Common
ValueCountFrequency (%)
85
49.1%
1 16
 
9.2%
4 15
 
8.7%
7 12
 
6.9%
2 8
 
4.6%
0 7
 
4.0%
3 7
 
4.0%
5 5
 
2.9%
- 5
 
2.9%
6 5
 
2.9%
Other values (2) 8
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 264
60.4%
ASCII 173
39.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
85
49.1%
1 16
 
9.2%
4 15
 
8.7%
7 12
 
6.9%
2 8
 
4.6%
0 7
 
4.0%
3 7
 
4.0%
5 5
 
2.9%
- 5
 
2.9%
6 5
 
2.9%
Other values (2) 8
 
4.6%
Hangul
ValueCountFrequency (%)
시 21
 
8.0%
산 19
 
7.2%
로 19
 
7.2%
면 11
 
4.2%
주 10
 
3.8%
군 10
 
3.8%
전 9
 
3.4%
익 9
 
3.4%
완 8
 
3.0%
구 8
 
3.0%
Other values (70) 140
53.0%

연락처
Text

MISSING 

Distinct26
Distinct (%)100.0%
Missing3
Missing (%)10.3%
Memory size360.0 B
2024-03-15T09:13:23.997299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.038462
Min length12

Characters and Unicode

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

Unique26 ?
Unique (%)100.0%

Sample

1st row063-223-5651
2nd row063-836-7804
3rd row063-281-2306
4th row063-850-4981
5th row063-620-6792
ValueCountFrequency (%)
063-836-7804 1
 
3.8%
063-281-2306 1
 
3.8%
063-430-2789 1
 
3.8%
063-469-4191 1
 
3.8%
063-220-2158 1
 
3.8%
063-270-3488 1
 
3.8%
070-8915-8132 1
 
3.8%
063-852-7277 1
 
3.8%
063-563-6600 1
 
3.8%
063-230-8828 1
 
3.8%
Other values (16) 16
61.5%
2024-03-15T09:13:25.006819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 52
16.6%
0 50
16.0%
6 42
13.4%
3 42
13.4%
2 28
8.9%
8 26
8.3%
5 21
6.7%
4 14
 
4.5%
1 14
 
4.5%
7 12
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 261
83.4%
Dash Punctuation 52
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 50
19.2%
6 42
16.1%
3 42
16.1%
2 28
10.7%
8 26
10.0%
5 21
8.0%
4 14
 
5.4%
1 14
 
5.4%
7 12
 
4.6%
9 12
 
4.6%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 313
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 52
16.6%
0 50
16.0%
6 42
13.4%
3 42
13.4%
2 28
8.9%
8 26
8.3%
5 21
6.7%
4 14
 
4.5%
1 14
 
4.5%
7 12
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 313
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 52
16.6%
0 50
16.0%
6 42
13.4%
3 42
13.4%
2 28
8.9%
8 26
8.3%
5 21
6.7%
4 14
 
4.5%
1 14
 
4.5%
7 12
 
3.8%

Interactions

2024-03-15T09:13:16.028776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T09:13:25.314119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분등록일박물관명주 소연락처
연번1.0000.8960.9791.0001.0001.000
구분0.8961.0001.0001.0001.0001.000
등록일0.9791.0001.0001.0001.0001.000
박물관명1.0001.0001.0001.0001.0001.000
주 소1.0001.0001.0001.0001.0001.000
연락처1.0001.0001.0001.0001.0001.000
2024-03-15T09:13:25.580324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분
연번1.0000.720
구분0.7201.000

Missing values

2024-03-15T09:13:16.369456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T09:13:16.667781image/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공립1990-10-26국립전주박물관전주시 완산구 효자동063-223-5651
12공립1996-11-22미륵사지유물전시관익산시 금마면 미륵사지로 362063-836-7804
23공립2002-10-15전주역사박물관전주시 완산구 쑥고개로 251063-281-2306
34공립2006-03-20익산보석박물관익산시 왕궁면 호반로 8063-850-4981
45공립2006-11-01남원향토박물관전북 남원시 양림길 14-9063-620-6792
56공립2006-12-15벽골제농경문화박물관김제시 부량면 벽골제로 442063-540-3225
67공립2005-04-28고창판소리박물관고창군 고창읍 읍내리 동리로 100063-560-2761
78공립2008-08-19전주전통술박물관전주시 완산구 최명희길 74063-287-6305
89공립2008-02-15왕궁리유적전시관익산시 왕궁면 궁성로 670063-859-4632
910공립2011-02-23어진박물관전주시 완산구 태조로 44063-231-0190
연번구분등록일박물관명주 소연락처
1920사립2006-09-14원숭이자연사박물관부안군 상서면 부안로 1783063-584-0708
2021사립2007-07-31전주한지박물관전주시 덕진구 팔복로 59063-210-8216
2122사립2009-07-30예수병원의학박물관전주시 완산구 서원로 68063-230-8828
2223사립2009-12-16카메라영상박물관완주군 소양면 신교응암길 14063-563-6600
2324사립2013-05-14연안이씨종중문적(보물651호)박물관익산시 삼기면 기산리 332-1번지063-852-7277
2425사립2013-08-29완주책박물관완주군 삼례읍 후정리 247-1070-8915-8132
2526대학2001-09-27전북대학교박물관전주시 덕진구 백제대로 567063-270-3488
2627대학2000-11-20전주대학교박물관전주시 완산구 백마길 45063-220-2158
2728대학2000-12-30군산대학교박물관군산시 대학로 1170063-469-4191
2829대학2000-12-30원광대학교박물관익산시 신동 익산대로 460063-850-5483