Overview

Dataset statistics

Number of variables11
Number of observations334
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory29.5 KiB
Average record size in memory90.4 B

Variable types

Categorical6
Numeric2
Text1
DateTime2

Dataset

Description제주특별자치도 세계자연유산 제주 홈페이지 내 홍보라이브러리 현황입니다. 링크: https://www.jeju.go.kr/jejuwnh/media/gallery.htm
URLhttps://www.data.go.kr/data/15119771/fileData.do

Alerts

디렉토리 has constant value ""Constant
게시판명 has constant value ""Constant
부서 has constant value ""Constant
상태 has constant value ""Constant
데이터기준일자 has constant value ""Constant
카테고리 is highly overall correlated with 일련번호 and 2 other fieldsHigh correlation
작성자 is highly overall correlated with 일련번호 and 2 other fieldsHigh correlation
일련번호 is highly overall correlated with 게시물번호 and 2 other fieldsHigh correlation
게시물번호 is highly overall correlated with 일련번호 and 2 other fieldsHigh correlation
일련번호 has unique valuesUnique
게시물번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:12:59.691835
Analysis finished2023-12-12 22:13:01.710790
Duration2.02 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

디렉토리
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
/files
334 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row/files
2nd row/files
3rd row/files
4th row/files
5th row/files

Common Values

ValueCountFrequency (%)
/files 334
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:13:01.891287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
files 334
100.0%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct334
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1193246.1
Minimum1192085
Maximum1196772
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2023-12-13T07:13:02.024115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1192085
5-th percentile1192103.6
Q11192807.2
median1192947.5
Q31193037.8
95-th percentile1196753.4
Maximum1196772
Range4687
Interquartile range (IQR)230.5

Descriptive statistics

Standard deviation1067.1372
Coefficient of variation (CV)0.00089431444
Kurtosis5.0920758
Mean1193246.1
Median Absolute Deviation (MAD)98
Skewness2.2716472
Sum3.9854418 × 108
Variance1138781.8
MonotonicityStrictly decreasing
2023-12-13T07:13:02.192210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1196772 1
 
0.3%
1192883 1
 
0.3%
1192885 1
 
0.3%
1192886 1
 
0.3%
1192887 1
 
0.3%
1192888 1
 
0.3%
1192889 1
 
0.3%
1192890 1
 
0.3%
1192891 1
 
0.3%
1192892 1
 
0.3%
Other values (324) 324
97.0%
ValueCountFrequency (%)
1192085 1
0.3%
1192088 1
0.3%
1192089 1
0.3%
1192090 1
0.3%
1192091 1
0.3%
1192092 1
0.3%
1192093 1
0.3%
1192094 1
0.3%
1192095 1
0.3%
1192096 1
0.3%
ValueCountFrequency (%)
1196772 1
0.3%
1196771 1
0.3%
1196770 1
0.3%
1196769 1
0.3%
1196768 1
0.3%
1196767 1
0.3%
1196766 1
0.3%
1196765 1
0.3%
1196762 1
0.3%
1196761 1
0.3%

게시물번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct334
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean169.5
Minimum3
Maximum336
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2023-12-13T07:13:02.365581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile19.65
Q186.25
median169.5
Q3252.75
95-th percentile319.35
Maximum336
Range333
Interquartile range (IQR)166.5

Descriptive statistics

Standard deviation96.561725
Coefficient of variation (CV)0.56968569
Kurtosis-1.2
Mean169.5
Median Absolute Deviation (MAD)83.5
Skewness0
Sum56613
Variance9324.1667
MonotonicityStrictly decreasing
2023-12-13T07:13:02.523509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
336 1
 
0.3%
106 1
 
0.3%
108 1
 
0.3%
109 1
 
0.3%
110 1
 
0.3%
111 1
 
0.3%
112 1
 
0.3%
113 1
 
0.3%
114 1
 
0.3%
115 1
 
0.3%
Other values (324) 324
97.0%
ValueCountFrequency (%)
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
11 1
0.3%
12 1
0.3%
ValueCountFrequency (%)
336 1
0.3%
335 1
0.3%
334 1
0.3%
333 1
0.3%
332 1
0.3%
331 1
0.3%
330 1
0.3%
329 1
0.3%
328 1
0.3%
327 1
0.3%

게시판명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
국제사진공모전
334 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국제사진공모전
2nd row국제사진공모전
3rd row국제사진공모전
4th row국제사진공모전
5th row국제사진공모전

Common Values

ValueCountFrequency (%)
국제사진공모전 334
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:13:02.789545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국제사진공모전 334
100.0%

카테고리
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
3회수상작
59 
2회수상작
52 
1회수상작
39 
4회수상작
33 
6회수상작
27 
Other values (5)
124 

Length

Max length6
Median length5
Mean length5.0658683
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row10회수상작
2nd row10회수상작
3rd row10회수상작
4th row10회수상작
5th row10회수상작

Common Values

ValueCountFrequency (%)
3회수상작 59
17.7%
2회수상작 52
15.6%
1회수상작 39
11.7%
4회수상작 33
9.9%
6회수상작 27
8.1%
5회수상작 27
8.1%
9회수상작 26
7.8%
7회수상작 25
7.5%
8회수상작 24
7.2%
10회수상작 22
 
6.6%

Length

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

Common Values (Plot)

2023-12-13T07:13:03.022825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3회수상작 59
17.7%
2회수상작 52
15.6%
1회수상작 39
11.7%
4회수상작 33
9.9%
6회수상작 27
8.1%
5회수상작 27
8.1%
9회수상작 26
7.8%
7회수상작 25
7.5%
8회수상작 24
7.2%
10회수상작 22
 
6.6%

부서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
세계유산본부
334 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세계유산본부
2nd row세계유산본부
3rd row세계유산본부
4th row세계유산본부
5th row세계유산본부

Common Values

ValueCountFrequency (%)
세계유산본부 334
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:13:03.301267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
세계유산본부 334
100.0%

제목
Text

Distinct323
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
2023-12-13T07:13:03.570312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length21
Mean length7.5
Min length1

Characters and Unicode

Total characters2505
Distinct characters389
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique314 ?
Unique (%)94.0%

Sample

1st row삶의무게
2nd row여름휴가
3rd row제주농촌소경
4th row해안도로
5th row가암과 반영
ValueCountFrequency (%)
한라산 12
 
1.8%
제주의 10
 
1.5%
성산일출봉 9
 
1.4%
본 7
 
1.1%
백록담 7
 
1.1%
일출 6
 
0.9%
제주 6
 
0.9%
주상절리 5
 
0.8%
일출봉 5
 
0.8%
풍경 5
 
0.8%
Other values (485) 580
89.0%
2023-12-13T07:13:03.991649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
318
 
12.7%
의 79
 
3.2%
산 64
 
2.6%
주 43
 
1.7%
제 42
 
1.7%
일 41
 
1.6%
라 39
 
1.6%
름 36
 
1.4%
출 35
 
1.4%
해 34
 
1.4%
Other values (379) 1774
70.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1884
75.2%
Space Separator 318
 
12.7%
Lowercase Letter 209
 
8.3%
Uppercase Letter 61
 
2.4%
Decimal Number 23
 
0.9%
Other Punctuation 5
 
0.2%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 79
 
4.2%
산 64
 
3.4%
주 43
 
2.3%
제 42
 
2.2%
일 41
 
2.2%
라 39
 
2.1%
름 36
 
1.9%
출 35
 
1.9%
해 34
 
1.8%
에 30
 
1.6%
Other values (323) 1441
76.5%
Lowercase Letter
ValueCountFrequency (%)
a 25
12.0%
e 21
10.0%
s 18
 
8.6%
o 18
 
8.6%
n 16
 
7.7%
t 15
 
7.2%
r 14
 
6.7%
h 11
 
5.3%
l 11
 
5.3%
i 11
 
5.3%
Other values (13) 49
23.4%
Uppercase Letter
ValueCountFrequency (%)
S 11
18.0%
E 9
14.8%
H 8
13.1%
R 5
8.2%
I 4
 
6.6%
A 4
 
6.6%
T 3
 
4.9%
P 3
 
4.9%
M 2
 
3.3%
N 2
 
3.3%
Other values (8) 10
16.4%
Decimal Number
ValueCountFrequency (%)
0 6
26.1%
2 6
26.1%
1 5
21.7%
6 2
 
8.7%
4 2
 
8.7%
8 1
 
4.3%
5 1
 
4.3%
Other Punctuation
ValueCountFrequency (%)
# 2
40.0%
' 1
20.0%
! 1
20.0%
. 1
20.0%
Space Separator
ValueCountFrequency (%)
318
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1884
75.2%
Common 351
 
14.0%
Latin 270
 
10.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 79
 
4.2%
산 64
 
3.4%
주 43
 
2.3%
제 42
 
2.2%
일 41
 
2.2%
라 39
 
2.1%
름 36
 
1.9%
출 35
 
1.9%
해 34
 
1.8%
에 30
 
1.6%
Other values (323) 1441
76.5%
Latin
ValueCountFrequency (%)
a 25
 
9.3%
e 21
 
7.8%
s 18
 
6.7%
o 18
 
6.7%
n 16
 
5.9%
t 15
 
5.6%
r 14
 
5.2%
S 11
 
4.1%
h 11
 
4.1%
l 11
 
4.1%
Other values (31) 110
40.7%
Common
ValueCountFrequency (%)
318
90.6%
0 6
 
1.7%
2 6
 
1.7%
1 5
 
1.4%
) 2
 
0.6%
( 2
 
0.6%
# 2
 
0.6%
6 2
 
0.6%
4 2
 
0.6%
- 1
 
0.3%
Other values (5) 5
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1884
75.2%
ASCII 621
 
24.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
318
51.2%
a 25
 
4.0%
e 21
 
3.4%
s 18
 
2.9%
o 18
 
2.9%
n 16
 
2.6%
t 15
 
2.4%
r 14
 
2.3%
S 11
 
1.8%
h 11
 
1.8%
Other values (46) 154
24.8%
Hangul
ValueCountFrequency (%)
의 79
 
4.2%
산 64
 
3.4%
주 43
 
2.3%
제 42
 
2.2%
일 41
 
2.2%
라 39
 
2.1%
름 36
 
1.9%
출 35
 
1.9%
해 34
 
1.8%
에 30
 
1.6%
Other values (323) 1441
76.5%

작성자
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
제주특별자치도
291 
자연유산제주
43 

Length

Max length7
Median length7
Mean length6.8712575
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주특별자치도
2nd row제주특별자치도
3rd row제주특별자치도
4th row제주특별자치도
5th row제주특별자치도

Common Values

ValueCountFrequency (%)
제주특별자치도 291
87.1%
자연유산제주 43
 
12.9%

Length

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

Common Values (Plot)

2023-12-13T07:13:04.279276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주특별자치도 291
87.1%
자연유산제주 43
 
12.9%

수정일
Date

Distinct4
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
Minimum2019-08-23 00:00:00
Maximum2019-09-25 00:00:00
2023-12-13T07:13:04.380102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:13:04.497511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
정상
334 

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 (%)
정상 334
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:13:04.740754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 334
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
Minimum2023-08-21 00:00:00
Maximum2023-08-21 00:00:00
2023-12-13T07:13:04.815538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:13:04.917946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T07:13:00.950868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:13:00.619425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:13:01.126975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:13:00.803994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:13:04.992264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호게시물번호카테고리작성자수정일
일련번호1.0000.9931.0000.8011.000
게시물번호0.9931.0000.9810.9890.946
카테고리1.0000.9811.0000.9921.000
작성자0.8010.9890.9921.0000.994
수정일1.0000.9461.0000.9941.000
2023-12-13T07:13:05.117111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카테고리작성자
카테고리1.0000.910
작성자0.9101.000
2023-12-13T07:13:05.207340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호게시물번호카테고리작성자
일련번호1.0001.0000.9780.928
게시물번호1.0001.0000.7590.895
카테고리0.9780.7591.0000.910
작성자0.9280.8950.9101.000

Missing values

2023-12-13T07:13:01.372351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:13:01.618177image/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/files1196772336국제사진공모전10회수상작세계유산본부삶의무게제주특별자치도2019-09-25정상2023-08-21
1/files1196771335국제사진공모전10회수상작세계유산본부여름휴가제주특별자치도2019-09-25정상2023-08-21
2/files1196770334국제사진공모전10회수상작세계유산본부제주농촌소경제주특별자치도2019-09-25정상2023-08-21
3/files1196769333국제사진공모전10회수상작세계유산본부해안도로제주특별자치도2019-09-25정상2023-08-21
4/files1196768332국제사진공모전10회수상작세계유산본부가암과 반영제주특별자치도2019-09-25정상2023-08-21
5/files1196767331국제사진공모전10회수상작세계유산본부붉은 들판제주특별자치도2019-09-25정상2023-08-21
6/files1196766330국제사진공모전10회수상작세계유산본부한 폭의 그림에서의 비상제주특별자치도2019-09-25정상2023-08-21
7/files1196765329국제사진공모전10회수상작세계유산본부눈 내린 성산일출봉제주특별자치도2019-09-25정상2023-08-21
8/files1196762328국제사진공모전10회수상작세계유산본부THE SEA AS SCULPTOR제주특별자치도2019-09-25정상2023-08-21
9/files1196761327국제사진공모전10회수상작세계유산본부무럭무럭 자라라제주특별자치도2019-09-25정상2023-08-21
디렉토리일련번호게시물번호게시판명카테고리부서제목작성자수정일상태데이터기준일자
324/files119209612국제사진공모전1회수상작세계유산본부성산일출자연유산제주2019-08-23정상2023-08-21
325/files119209511국제사진공모전1회수상작세계유산본부고수목마자연유산제주2019-08-23정상2023-08-21
326/files119209410국제사진공모전1회수상작세계유산본부부름이 흐르는 제주자연유산제주2019-08-23정상2023-08-21
327/files11920939국제사진공모전1회수상작세계유산본부백록담자연유산제주2019-08-23정상2023-08-21
328/files11920928국제사진공모전1회수상작세계유산본부태풍을만나다자연유산제주2019-08-23정상2023-08-21
329/files11920917국제사진공모전1회수상작세계유산본부어울림자연유산제주2019-08-23정상2023-08-21
330/files11920906국제사진공모전1회수상작세계유산본부한라산의 신비자연유산제주2019-08-23정상2023-08-21
331/files11920895국제사진공모전1회수상작세계유산본부겨울의 백록담 전경자연유산제주2019-08-23정상2023-08-21
332/files11920884국제사진공모전1회수상작세계유산본부농부의 그림자연유산제주2019-08-23정상2023-08-21
333/files11920853국제사진공모전1회수상작세계유산본부섬에서 본 지미봉 문주란자연유산제주2019-08-23정상2023-08-21