Overview

Dataset statistics

Number of variables7
Number of observations41
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory61.2 B

Variable types

Numeric1
Categorical2
Text3
DateTime1

Dataset

Description번호,년도,제목,리스트이미지,링크주소,등록일,작성자 이름
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-21069/S/1/datasetView.do

Alerts

번호 is highly overall correlated with 년도High correlation
년도 is highly overall correlated with 번호High correlation
작성자 이름 is highly imbalanced (55.3%)Imbalance
번호 has unique valuesUnique
제목 has unique valuesUnique
리스트이미지 has unique valuesUnique
링크주소 has unique valuesUnique
등록일 has unique valuesUnique

Reproduction

Analysis started2024-05-17 22:37:58.200267
Analysis finished2024-05-17 22:38:00.313939
Duration2.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean124.21951
Minimum102
Maximum147
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size501.0 B
2024-05-18T07:38:00.594643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum102
5-th percentile104
Q1112
median122
Q3137
95-th percentile145
Maximum147
Range45
Interquartile range (IQR)25

Descriptive statistics

Standard deviation14.17835
Coefficient of variation (CV)0.11413948
Kurtosis-1.3901031
Mean124.21951
Median Absolute Deviation (MAD)13
Skewness0.05935852
Sum5093
Variance201.02561
MonotonicityStrictly decreasing
2024-05-18T07:38:01.018300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
147 1
 
2.4%
111 1
 
2.4%
119 1
 
2.4%
118 1
 
2.4%
117 1
 
2.4%
116 1
 
2.4%
115 1
 
2.4%
114 1
 
2.4%
113 1
 
2.4%
112 1
 
2.4%
Other values (31) 31
75.6%
ValueCountFrequency (%)
102 1
2.4%
103 1
2.4%
104 1
2.4%
105 1
2.4%
106 1
2.4%
107 1
2.4%
108 1
2.4%
109 1
2.4%
110 1
2.4%
111 1
2.4%
ValueCountFrequency (%)
147 1
2.4%
146 1
2.4%
145 1
2.4%
144 1
2.4%
143 1
2.4%
142 1
2.4%
141 1
2.4%
140 1
2.4%
139 1
2.4%
138 1
2.4%

년도
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size460.0 B
2019
11 
2022
10 
2021
10 
2020
10 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022
2nd row2022
3rd row2022
4th row2022
5th row2022

Common Values

ValueCountFrequency (%)
2019 11
26.8%
2022 10
24.4%
2021 10
24.4%
2020 10
24.4%

Length

2024-05-18T07:38:01.399494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:38:01.935703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 11
26.8%
2022 10
24.4%
2021 10
24.4%
2020 10
24.4%

제목
Text

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size460.0 B
2024-05-18T07:38:02.461013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length14.902439
Min length8

Characters and Unicode

Total characters611
Distinct characters21
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

Unique41 ?
Unique (%)100.0%

Sample

1st row2022년도 12월 한울타리 웹진
2nd row2022년도 11월 한울타리 웹진
3rd row2022년도 10월 한울타리 웹진
4th row2022년도 9월 한울타리 웹진
5th row2022년도 8월 한울타리 웹진
ValueCountFrequency (%)
웹진 37
25.7%
한울타리 28
19.4%
2022년도 10
 
6.9%
2019 9
 
6.2%
2020년 8
 
5.6%
2021년도 8
 
5.6%
11월 4
 
2.8%
12월 3
 
2.1%
10월 3
 
2.1%
4월 2
 
1.4%
Other values (25) 32
22.2%
2024-05-18T07:38:03.622798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
103
16.9%
2 85
13.9%
0 62
10.1%
41
 
6.7%
41
 
6.7%
1 38
 
6.2%
29
 
4.7%
28
 
4.6%
28
 
4.6%
28
 
4.6%
Other values (11) 128
20.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 269
44.0%
Decimal Number 224
36.7%
Space Separator 103
 
16.9%
Other Punctuation 15
 
2.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 85
37.9%
0 62
27.7%
1 38
17.0%
9 15
 
6.7%
8 4
 
1.8%
7 4
 
1.8%
6 4
 
1.8%
5 4
 
1.8%
4 4
 
1.8%
3 4
 
1.8%
Other Letter
ValueCountFrequency (%)
41
15.2%
41
15.2%
29
10.8%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
18
6.7%
Space Separator
ValueCountFrequency (%)
103
100.0%
Other Punctuation
ValueCountFrequency (%)
. 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 342
56.0%
Hangul 269
44.0%

Most frequent character per script

Common
ValueCountFrequency (%)
103
30.1%
2 85
24.9%
0 62
18.1%
1 38
 
11.1%
9 15
 
4.4%
. 15
 
4.4%
8 4
 
1.2%
7 4
 
1.2%
6 4
 
1.2%
5 4
 
1.2%
Other values (2) 8
 
2.3%
Hangul
ValueCountFrequency (%)
41
15.2%
41
15.2%
29
10.8%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
18
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 342
56.0%
Hangul 269
44.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
103
30.1%
2 85
24.9%
0 62
18.1%
1 38
 
11.1%
9 15
 
4.4%
. 15
 
4.4%
8 4
 
1.2%
7 4
 
1.2%
6 4
 
1.2%
5 4
 
1.2%
Other values (2) 8
 
2.3%
Hangul
ValueCountFrequency (%)
41
15.2%
41
15.2%
29
10.8%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
28
10.4%
18
6.7%

리스트이미지
Text

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size460.0 B
2024-05-18T07:38:04.587168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)100.0%

Sample

1st rowF1669785581.jpg
2nd rowF1666765736.jpg
3rd rowF1665129494.jpg
4th rowF1662083892.jpg
5th rowF1658886014.jpg
ValueCountFrequency (%)
f1669785581.jpg 1
 
2.4%
f1604376253.jpg 1
 
2.4%
f1599449348.jpg 1
 
2.4%
f1596411732.jpg 1
 
2.4%
f1594018225.jpg 1
 
2.4%
f1590972422.jpg 1
 
2.4%
f1588724306.jpg 1
 
2.4%
f1585706074.jpg 1
 
2.4%
f1583126813.jpg 1
 
2.4%
f1575246515.jpg 1
 
2.4%
Other values (31) 31
75.6%
2024-05-18T07:38:06.084436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 65
10.6%
6 64
10.4%
5 54
 
8.8%
F 41
 
6.7%
. 41
 
6.7%
j 41
 
6.7%
p 41
 
6.7%
g 41
 
6.7%
4 37
 
6.0%
2 35
 
5.7%
Other values (5) 155
25.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 410
66.7%
Lowercase Letter 123
 
20.0%
Uppercase Letter 41
 
6.7%
Other Punctuation 41
 
6.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 65
15.9%
6 64
15.6%
5 54
13.2%
4 37
9.0%
2 35
8.5%
7 33
8.0%
3 33
8.0%
8 32
7.8%
0 31
7.6%
9 26
 
6.3%
Lowercase Letter
ValueCountFrequency (%)
j 41
33.3%
p 41
33.3%
g 41
33.3%
Uppercase Letter
ValueCountFrequency (%)
F 41
100.0%
Other Punctuation
ValueCountFrequency (%)
. 41
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 451
73.3%
Latin 164
 
26.7%

Most frequent character per script

Common
ValueCountFrequency (%)
1 65
14.4%
6 64
14.2%
5 54
12.0%
. 41
9.1%
4 37
8.2%
2 35
7.8%
7 33
7.3%
3 33
7.3%
8 32
7.1%
0 31
6.9%
Latin
ValueCountFrequency (%)
F 41
25.0%
j 41
25.0%
p 41
25.0%
g 41
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 615
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 65
10.6%
6 64
10.4%
5 54
 
8.8%
F 41
 
6.7%
. 41
 
6.7%
j 41
 
6.7%
p 41
 
6.7%
g 41
 
6.7%
4 37
 
6.0%
2 35
 
5.7%
Other values (5) 155
25.2%

링크주소
Text

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size460.0 B
2024-05-18T07:38:06.941776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length26
Mean length25.487805
Min length23

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)100.0%

Sample

1st row/webzine/vol2212/main.html
2nd row/webzine/vol2211/main.html
3rd row/webzine/vol2210/main.html
4th row/webzine/vol2209/main.html
5th row/webzine/vol2208/main.html
ValueCountFrequency (%)
webzine/vol2212/main.html 1
 
2.4%
webzine/vol2011/main.html 1
 
2.4%
webzine/vol2009/main.html 1
 
2.4%
webzine/vol2008/main.html 1
 
2.4%
webzine/vol2007/main.html 1
 
2.4%
webzine/vol2006/main.html 1
 
2.4%
webzine/vol2005/main.html 1
 
2.4%
webzine/vol2004/main.html 1
 
2.4%
webzine/vol2003/main.html 1
 
2.4%
webzine/december/main.html 1
 
2.4%
Other values (31) 31
75.6%
2024-05-18T07:38:08.324721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
/ 123
 
11.8%
e 88
 
8.4%
m 84
 
8.0%
n 83
 
7.9%
i 82
 
7.8%
l 79
 
7.6%
b 44
 
4.2%
2 43
 
4.1%
t 42
 
4.0%
h 41
 
3.9%
Other values (19) 336
32.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 752
72.0%
Other Punctuation 164
 
15.7%
Decimal Number 128
 
12.2%
Space Separator 1
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 88
11.7%
m 84
11.2%
n 83
11.0%
i 82
10.9%
l 79
10.5%
b 44
 
5.9%
t 42
 
5.6%
h 41
 
5.5%
w 41
 
5.5%
a 41
 
5.5%
Other values (6) 127
16.9%
Decimal Number
ValueCountFrequency (%)
2 43
33.6%
0 34
26.6%
1 23
18.0%
9 4
 
3.1%
8 4
 
3.1%
7 4
 
3.1%
6 4
 
3.1%
5 4
 
3.1%
4 4
 
3.1%
3 4
 
3.1%
Other Punctuation
ValueCountFrequency (%)
/ 123
75.0%
. 41
 
25.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 752
72.0%
Common 293
 
28.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 88
11.7%
m 84
11.2%
n 83
11.0%
i 82
10.9%
l 79
10.5%
b 44
 
5.9%
t 42
 
5.6%
h 41
 
5.5%
w 41
 
5.5%
a 41
 
5.5%
Other values (6) 127
16.9%
Common
ValueCountFrequency (%)
/ 123
42.0%
2 43
 
14.7%
. 41
 
14.0%
0 34
 
11.6%
1 23
 
7.8%
9 4
 
1.4%
8 4
 
1.4%
7 4
 
1.4%
6 4
 
1.4%
5 4
 
1.4%
Other values (3) 9
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1045
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
/ 123
 
11.8%
e 88
 
8.4%
m 84
 
8.0%
n 83
 
7.9%
i 82
 
7.8%
l 79
 
7.6%
b 44
 
4.2%
2 43
 
4.1%
t 42
 
4.0%
h 41
 
3.9%
Other values (19) 336
32.2%

등록일
Date

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size460.0 B
Minimum2019-01-02 10:49:17
Maximum2022-11-30 14:19:41
2024-05-18T07:38:08.826303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T07:38:09.398531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)

작성자 이름
Categorical

IMBALANCE 

Distinct4
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size460.0 B
한울타리
34 
홈코테스트
홈코테스트2
 
2
최고관리자
 
1

Length

Max length6
Median length4
Mean length4.2195122
Min length4

Unique

Unique1 ?
Unique (%)2.4%

Sample

1st row홈코테스트2
2nd row홈코테스트2
3rd row홈코테스트
4th row홈코테스트
5th row홈코테스트

Common Values

ValueCountFrequency (%)
한울타리 34
82.9%
홈코테스트 4
 
9.8%
홈코테스트2 2
 
4.9%
최고관리자 1
 
2.4%

Length

2024-05-18T07:38:09.994426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:38:10.454032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한울타리 34
82.9%
홈코테스트 4
 
9.8%
홈코테스트2 2
 
4.9%
최고관리자 1
 
2.4%

Interactions

2024-05-18T07:37:59.140358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-18T07:38:10.768308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호년도제목리스트이미지링크주소등록일작성자 이름
번호1.0000.9531.0001.0001.0001.0000.682
년도0.9531.0001.0001.0001.0001.0000.733
제목1.0001.0001.0001.0001.0001.0001.000
리스트이미지1.0001.0001.0001.0001.0001.0001.000
링크주소1.0001.0001.0001.0001.0001.0001.000
등록일1.0001.0001.0001.0001.0001.0001.000
작성자 이름0.6820.7331.0001.0001.0001.0001.000
2024-05-18T07:38:11.100405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
년도작성자 이름
년도1.0000.369
작성자 이름0.3691.000
2024-05-18T07:38:11.349915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호년도작성자 이름
번호1.0000.8250.437
년도0.8251.0000.369
작성자 이름0.4370.3691.000

Missing values

2024-05-18T07:37:59.631530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-18T07:38:00.086255image/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

번호년도제목리스트이미지링크주소등록일작성자 이름
014720222022년도 12월 한울타리 웹진F1669785581.jpg/webzine/vol2212/main.html2022-11-30 14:19:41.0홈코테스트2
114620222022년도 11월 한울타리 웹진F1666765736.jpg/webzine/vol2211/main.html2022-10-26 15:29:04.0홈코테스트2
214520222022년도 10월 한울타리 웹진F1665129494.jpg/webzine/vol2210/main.html2022-10-07 16:58:15.0홈코테스트
314420222022년도 9월 한울타리 웹진F1662083892.jpg/webzine/vol2209/main.html2022-09-02 10:58:11.0홈코테스트
414320222022년도 8월 한울타리 웹진F1658886014.jpg/webzine/vol2208/main.html2022-07-27 10:40:14.0홈코테스트
514220222022년도 7월 한울타리 웹진F1656391446.jpg/webzine/vol2207/main.html2022-06-28 13:44:05.0홈코테스트
614120222022년도 6월 한울타리 웹진F1653957514.jpg/webzine/vol2206/main.html2022-05-31 09:38:34.0한울타리
714020222022년도 5월 한울타리 웹진F1652073400.jpg/webzine/vol2205/main.html2022-05-12 14:16:40.0한울타리
813920222022년도 4월 한울타리 웹진F1652318308.jpg/webzine/vol2204/main.html2022-05-12 10:18:28.0한울타리
913820222022년도 3월 한울타리 웹진F1652318262.jpg/webzine/vol2203/main.html2022-05-12 10:17:42.0한울타리
번호년도제목리스트이미지링크주소등록일작성자 이름
3111120192019. 11월 웹진F1572575943.jpg/webzine/november/main.html2019-11-01 11:39:03.0한울타리
3211020192019. 10웹진F1570152536.jpg/webzine/october/main.html2019-10-04 10:28:56.0한울타리
3310920192019. 9 웹진F1567487829.jpg/webzine/vol9/main.html2019-09-03 14:17:09.0한울타리
3410820192019. 8 웹진F1564706044.jpg/webzine/vol8/main.html2019-08-02 09:34:04.0한울타리
3510720192019. 7 웹진F1561938414.jpg/webzine/vol7/main.html2019-07-01 08:46:54.0한울타리
3610620192019. 6 웹진F1559519242.jpg/webzine/vol6/main.html2019-06-03 08:47:22.0한울타리
3710520192019. 5 웹진F1556757806.jpg/webzine/vol5/main.html2019-05-02 09:43:26.0한울타리
3810420192019. 4 웹진F1554086635.jpg/webzine/vol4/main.html2019-04-01 11:43:55.0한울타리
3910320192019 . 3 웹진F1553159203.jpg/webzine/vol3/main.html2019-03-21 18:06:43.0한울타리
4010220192019.1웹진F1546393757.jpg/webzine/vol1/main.html2019-01-02 10:49:17.0한울타리