Overview

Dataset statistics

Number of variables15
Number of observations90
Missing cells459
Missing cells (%)34.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.2 KiB
Average record size in memory127.5 B

Variable types

Text4
Categorical1
Unsupported5
Numeric1
Boolean2
DateTime2

Dataset

Description배너 ID,배너구분,배너명,링크 URL,이미지명,이미지파일,설명,정렬순서,반영여부,등록ID,등록일,최종수정ID,최종수정일,에디터 설명,에디터 사용여부
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15370/S/1/datasetView.do

Alerts

반영여부 has constant value ""Constant
정렬순서 is highly overall correlated with 배너구분High correlation
배너구분 is highly overall correlated with 정렬순서High correlation
에디터 사용여부 is highly imbalanced (90.5%)Imbalance
링크 URL has 90 (100.0%) missing valuesMissing
설명 has 90 (100.0%) missing valuesMissing
등록ID has 90 (100.0%) missing valuesMissing
최종수정ID has 90 (100.0%) missing valuesMissing
최종수정일 has 1 (1.1%) missing valuesMissing
에디터 설명 has 90 (100.0%) missing valuesMissing
에디터 사용여부 has 8 (8.9%) missing valuesMissing
배너 ID has unique valuesUnique
이미지파일 has unique valuesUnique
등록일 has unique valuesUnique
링크 URL is an unsupported type, check if it needs cleaning or further analysisUnsupported
설명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
등록ID is an unsupported type, check if it needs cleaning or further analysisUnsupported
최종수정ID is an unsupported type, check if it needs cleaning or further analysisUnsupported
에디터 설명 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-05-03 21:01:59.841468
Analysis finished2024-05-03 21:02:05.464718
Duration5.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

배너 ID
Text

UNIQUE 

Distinct90
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size852.0 B
2024-05-03T21:02:05.952744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)100.0%

Sample

1st rowBANNER_0000000000173
2nd rowBANNER_0000000000174
3rd rowBANNER_0000000000175
4th rowBANNER_0000000000176
5th rowBANNER_0000000000179
ValueCountFrequency (%)
banner_0000000000173 1
 
1.1%
banner_0000000000344 1
 
1.1%
banner_0000000000342 1
 
1.1%
banner_0000000000341 1
 
1.1%
banner_0000000000340 1
 
1.1%
banner_0000000000339 1
 
1.1%
banner_0000000000338 1
 
1.1%
banner_0000000000337 1
 
1.1%
banner_0000000000336 1
 
1.1%
banner_0000000000335 1
 
1.1%
Other values (80) 80
88.9%
2024-05-03T21:02:07.135611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 923
51.3%
N 180
 
10.0%
B 90
 
5.0%
A 90
 
5.0%
E 90
 
5.0%
R 90
 
5.0%
_ 90
 
5.0%
3 82
 
4.6%
2 37
 
2.1%
1 29
 
1.6%
Other values (6) 99
 
5.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1170
65.0%
Uppercase Letter 540
30.0%
Connector Punctuation 90
 
5.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 923
78.9%
3 82
 
7.0%
2 37
 
3.2%
1 29
 
2.5%
7 19
 
1.6%
9 19
 
1.6%
5 18
 
1.5%
4 17
 
1.5%
6 14
 
1.2%
8 12
 
1.0%
Uppercase Letter
ValueCountFrequency (%)
N 180
33.3%
B 90
16.7%
A 90
16.7%
E 90
16.7%
R 90
16.7%
Connector Punctuation
ValueCountFrequency (%)
_ 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1260
70.0%
Latin 540
30.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 923
73.3%
_ 90
 
7.1%
3 82
 
6.5%
2 37
 
2.9%
1 29
 
2.3%
7 19
 
1.5%
9 19
 
1.5%
5 18
 
1.4%
4 17
 
1.3%
6 14
 
1.1%
Latin
ValueCountFrequency (%)
N 180
33.3%
B 90
16.7%
A 90
16.7%
E 90
16.7%
R 90
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1800
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 923
51.3%
N 180
 
10.0%
B 90
 
5.0%
A 90
 
5.0%
E 90
 
5.0%
R 90
 
5.0%
_ 90
 
5.0%
3 82
 
4.6%
2 37
 
2.1%
1 29
 
1.6%
Other values (6) 99
 
5.5%

배너구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size852.0 B
B001
68 
B010
12 
B004
B002
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB001
2nd rowB001
3rd rowB002
4th rowB002
5th rowB001

Common Values

ValueCountFrequency (%)
B001 68
75.6%
B010 12
 
13.3%
B004 8
 
8.9%
B002 2
 
2.2%

Length

2024-05-03T21:02:07.655320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:02:08.071058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b001 68
75.6%
b010 12
 
13.3%
b004 8
 
8.9%
b002 2
 
2.2%
Distinct80
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size852.0 B
2024-05-03T21:02:08.726564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length25.5
Mean length21.633333
Min length6

Characters and Unicode

Total characters1947
Distinct characters208
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique79 ?
Unique (%)87.8%

Sample

1st row성북진경페스티벌
2nd row성곽마을 축제
3rd row해설 프로그램
4th row스탬프 투어
5th row한양도성주간
ValueCountFrequency (%)
한양도성 28
 
8.0%
13
 
3.7%
안내 13
 
3.7%
행사 12
 
3.4%
관련 12
 
3.4%
복원 12
 
3.4%
순성의 12
 
3.4%
11
 
3.2%
디지털인문도시 11
 
3.2%
인문강좌 8
 
2.3%
Other values (159) 217
62.2%
2024-05-03T21:02:10.059119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
271
 
13.9%
( 83
 
4.3%
) 83
 
4.3%
78
 
4.0%
1 70
 
3.6%
64
 
3.3%
58
 
3.0%
. 57
 
2.9%
47
 
2.4%
46
 
2.4%
Other values (198) 1090
56.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1187
61.0%
Space Separator 271
 
13.9%
Decimal Number 218
 
11.2%
Open Punctuation 83
 
4.3%
Close Punctuation 83
 
4.3%
Other Punctuation 78
 
4.0%
Math Symbol 26
 
1.3%
Connector Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
78
 
6.6%
64
 
5.4%
58
 
4.9%
47
 
4.0%
46
 
3.9%
32
 
2.7%
30
 
2.5%
27
 
2.3%
26
 
2.2%
25
 
2.1%
Other values (175) 754
63.5%
Decimal Number
ValueCountFrequency (%)
1 70
32.1%
2 41
18.8%
0 26
 
11.9%
9 21
 
9.6%
8 16
 
7.3%
3 13
 
6.0%
4 12
 
5.5%
7 8
 
3.7%
6 8
 
3.7%
5 3
 
1.4%
Other Punctuation
ValueCountFrequency (%)
. 57
73.1%
: 12
 
15.4%
' 6
 
7.7%
! 1
 
1.3%
/ 1
 
1.3%
, 1
 
1.3%
Math Symbol
ValueCountFrequency (%)
~ 12
46.2%
> 7
26.9%
< 7
26.9%
Space Separator
ValueCountFrequency (%)
271
100.0%
Open Punctuation
ValueCountFrequency (%)
( 83
100.0%
Close Punctuation
ValueCountFrequency (%)
) 83
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1182
60.7%
Common 760
39.0%
Han 5
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
78
 
6.6%
64
 
5.4%
58
 
4.9%
47
 
4.0%
46
 
3.9%
32
 
2.7%
30
 
2.5%
27
 
2.3%
26
 
2.2%
25
 
2.1%
Other values (170) 749
63.4%
Common
ValueCountFrequency (%)
271
35.7%
( 83
 
10.9%
) 83
 
10.9%
1 70
 
9.2%
. 57
 
7.5%
2 41
 
5.4%
0 26
 
3.4%
9 21
 
2.8%
8 16
 
2.1%
3 13
 
1.7%
Other values (13) 79
 
10.4%
Han
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1182
60.7%
ASCII 760
39.0%
CJK 5
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
271
35.7%
( 83
 
10.9%
) 83
 
10.9%
1 70
 
9.2%
. 57
 
7.5%
2 41
 
5.4%
0 26
 
3.4%
9 21
 
2.8%
8 16
 
2.1%
3 13
 
1.7%
Other values (13) 79
 
10.4%
Hangul
ValueCountFrequency (%)
78
 
6.6%
64
 
5.4%
58
 
4.9%
47
 
4.0%
46
 
3.9%
32
 
2.7%
30
 
2.5%
27
 
2.3%
26
 
2.2%
25
 
2.1%
Other values (170) 749
63.4%
CJK
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

링크 URL
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing90
Missing (%)100.0%
Memory size942.0 B
Distinct64
Distinct (%)71.1%
Missing0
Missing (%)0.0%
Memory size852.0 B
2024-05-03T21:02:10.740113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length23
Mean length14.611111
Min length7

Characters and Unicode

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

Unique

Unique55 ?
Unique (%)61.1%

Sample

1st row성북진경.jpg
2nd row도성마을 축제.jpg
3rd row해설프로그램.jpg
4th row한양도성스탬프투어.jpg
5th row한양도성주간.jpg
ValueCountFrequency (%)
꾸미기]순성로고 16
 
11.2%
가로.jpg 16
 
11.2%
없음.jpg 8
 
5.6%
행사안내.jpg 7
 
4.9%
꾸미기]제목 6
 
4.2%
제목 5
 
3.5%
140612 3
 
2.1%
꾸미기]edm_top4.jpg 3
 
2.1%
꾸미기_제목 3
 
2.1%
없음1.jpg 3
 
2.1%
Other values (67) 73
51.0%
2024-05-03T21:02:12.125100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
p 91
 
6.9%
. 90
 
6.8%
g 85
 
6.5%
j 78
 
5.9%
53
 
4.0%
_ 42
 
3.2%
41
 
3.1%
38
 
2.9%
37
 
2.8%
1 36
 
2.7%
Other values (138) 724
55.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 551
41.9%
Lowercase Letter 313
23.8%
Decimal Number 122
 
9.3%
Other Punctuation 90
 
6.8%
Uppercase Letter 72
 
5.5%
Space Separator 53
 
4.0%
Connector Punctuation 42
 
3.2%
Open Punctuation 31
 
2.4%
Close Punctuation 31
 
2.4%
Dash Punctuation 10
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
41
 
7.4%
38
 
6.9%
37
 
6.7%
35
 
6.4%
30
 
5.4%
20
 
3.6%
17
 
3.1%
16
 
2.9%
16
 
2.9%
16
 
2.9%
Other values (93) 285
51.7%
Lowercase Letter
ValueCountFrequency (%)
p 91
29.1%
g 85
27.2%
j 78
24.9%
o 14
 
4.5%
e 10
 
3.2%
b 6
 
1.9%
a 5
 
1.6%
f 3
 
1.0%
m 3
 
1.0%
x 3
 
1.0%
Other values (8) 15
 
4.8%
Decimal Number
ValueCountFrequency (%)
1 36
29.5%
2 22
18.0%
0 17
13.9%
3 11
 
9.0%
4 10
 
8.2%
6 8
 
6.6%
9 6
 
4.9%
8 6
 
4.9%
5 3
 
2.5%
7 3
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
J 11
15.3%
P 11
15.3%
G 11
15.3%
T 9
12.5%
E 9
12.5%
M 9
12.5%
D 9
12.5%
I 2
 
2.8%
A 1
 
1.4%
Open Punctuation
ValueCountFrequency (%)
[ 28
90.3%
( 3
 
9.7%
Close Punctuation
ValueCountFrequency (%)
] 28
90.3%
) 3
 
9.7%
Other Punctuation
ValueCountFrequency (%)
. 90
100.0%
Space Separator
ValueCountFrequency (%)
53
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 42
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 551
41.9%
Latin 385
29.3%
Common 379
28.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
41
 
7.4%
38
 
6.9%
37
 
6.7%
35
 
6.4%
30
 
5.4%
20
 
3.6%
17
 
3.1%
16
 
2.9%
16
 
2.9%
16
 
2.9%
Other values (93) 285
51.7%
Latin
ValueCountFrequency (%)
p 91
23.6%
g 85
22.1%
j 78
20.3%
o 14
 
3.6%
J 11
 
2.9%
P 11
 
2.9%
G 11
 
2.9%
e 10
 
2.6%
T 9
 
2.3%
E 9
 
2.3%
Other values (17) 56
14.5%
Common
ValueCountFrequency (%)
. 90
23.7%
53
14.0%
_ 42
11.1%
1 36
 
9.5%
[ 28
 
7.4%
] 28
 
7.4%
2 22
 
5.8%
0 17
 
4.5%
3 11
 
2.9%
- 10
 
2.6%
Other values (8) 42
11.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 764
58.1%
Hangul 551
41.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
p 91
11.9%
. 90
11.8%
g 85
11.1%
j 78
 
10.2%
53
 
6.9%
_ 42
 
5.5%
1 36
 
4.7%
[ 28
 
3.7%
] 28
 
3.7%
2 22
 
2.9%
Other values (35) 211
27.6%
Hangul
ValueCountFrequency (%)
41
 
7.4%
38
 
6.9%
37
 
6.7%
35
 
6.4%
30
 
5.4%
20
 
3.6%
17
 
3.1%
16
 
2.9%
16
 
2.9%
16
 
2.9%
Other values (93) 285
51.7%

이미지파일
Text

UNIQUE 

Distinct90
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size852.0 B
2024-05-03T21:02:13.617832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length139
Median length118
Mean length119.4
Min length118

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)100.0%

Sample

1st rowhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404071046003850.jpg&filePath=bannerthumb
2nd rowhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404110116546470.jpg&filePath=bannerthumb
3rd rowhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070121095450.jpg&filePath=bannerthumb
4th rowhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070121559550.jpg&filePath=bannerthumb
5th rowhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070124537580.jpg&filePath=bannerthumb
ValueCountFrequency (%)
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=[object 6
 
6.2%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201404071046003850.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201903210917560800.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201908021015114560.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201908020939341870.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201908020919250240.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201907050514375590.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201905170208240800.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201905130945014600.jpg&filepath=bannerthumb 1
 
1.0%
https://seoulcitywall.seoul.go.kr/child/file/getimage2.do?filephysical=bnr_201904191109113380.jpg&filepath=bannerthumb 1
 
1.0%
Other values (81) 81
84.4%
2024-05-03T21:02:15.250038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
l 816
 
7.6%
e 738
 
6.9%
t 558
 
5.2%
i 540
 
5.0%
0 474
 
4.4%
. 450
 
4.2%
a 450
 
4.2%
h 450
 
4.2%
/ 450
 
4.2%
o 366
 
3.4%
Other values (42) 5454
50.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 7026
65.4%
Decimal Number 1710
 
15.9%
Other Punctuation 1170
 
10.9%
Uppercase Letter 558
 
5.2%
Math Symbol 180
 
1.7%
Connector Punctuation 84
 
0.8%
Open Punctuation 6
 
0.1%
Space Separator 6
 
0.1%
Close Punctuation 6
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
l 816
 
11.6%
e 738
 
10.5%
t 558
 
7.9%
i 540
 
7.7%
a 450
 
6.4%
h 450
 
6.4%
o 366
 
5.2%
g 360
 
5.1%
s 360
 
5.1%
u 276
 
3.9%
Other values (12) 2112
30.1%
Decimal Number
ValueCountFrequency (%)
0 474
27.7%
2 335
19.6%
1 278
16.3%
8 107
 
6.3%
9 106
 
6.2%
4 102
 
6.0%
5 95
 
5.6%
3 93
 
5.4%
7 65
 
3.8%
6 55
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
P 180
32.3%
I 96
17.2%
B 84
15.1%
N 84
15.1%
R 84
15.1%
H 6
 
1.1%
T 6
 
1.1%
M 6
 
1.1%
L 6
 
1.1%
E 6
 
1.1%
Other Punctuation
ValueCountFrequency (%)
. 450
38.5%
/ 450
38.5%
& 90
 
7.7%
: 90
 
7.7%
? 90
 
7.7%
Math Symbol
ValueCountFrequency (%)
= 180
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 84
100.0%
Open Punctuation
ValueCountFrequency (%)
[ 6
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
] 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 7584
70.6%
Common 3162
29.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
l 816
 
10.8%
e 738
 
9.7%
t 558
 
7.4%
i 540
 
7.1%
a 450
 
5.9%
h 450
 
5.9%
o 366
 
4.8%
g 360
 
4.7%
s 360
 
4.7%
u 276
 
3.6%
Other values (22) 2670
35.2%
Common
ValueCountFrequency (%)
0 474
15.0%
. 450
14.2%
/ 450
14.2%
2 335
10.6%
1 278
8.8%
= 180
 
5.7%
8 107
 
3.4%
9 106
 
3.4%
4 102
 
3.2%
5 95
 
3.0%
Other values (10) 585
18.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10746
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
l 816
 
7.6%
e 738
 
6.9%
t 558
 
5.2%
i 540
 
5.0%
0 474
 
4.4%
. 450
 
4.2%
a 450
 
4.2%
h 450
 
4.2%
/ 450
 
4.2%
o 366
 
3.4%
Other values (42) 5454
50.8%

설명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing90
Missing (%)100.0%
Memory size942.0 B

정렬순서
Real number (ℝ)

HIGH CORRELATION 

Distinct74
Distinct (%)82.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51
Minimum1
Maximum190
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size942.0 B
2024-05-03T21:02:15.830262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.45
Q122.5
median46
Q365.75
95-th percentile109.55
Maximum190
Range189
Interquartile range (IQR)43.25

Descriptive statistics

Standard deviation36.957613
Coefficient of variation (CV)0.72465908
Kurtosis0.89375867
Mean51
Median Absolute Deviation (MAD)20.5
Skewness0.81742943
Sum4590
Variance1365.8652
MonotonicityNot monotonic
2024-05-03T21:02:16.429117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 4
 
4.4%
36 3
 
3.3%
46 2
 
2.2%
54 2
 
2.2%
42 2
 
2.2%
4 2
 
2.2%
44 2
 
2.2%
60 2
 
2.2%
48 2
 
2.2%
20 2
 
2.2%
Other values (64) 67
74.4%
ValueCountFrequency (%)
1 4
4.4%
2 1
 
1.1%
3 2
2.2%
4 2
2.2%
5 1
 
1.1%
6 1
 
1.1%
7 1
 
1.1%
8 1
 
1.1%
9 1
 
1.1%
10 1
 
1.1%
ValueCountFrequency (%)
190 1
1.1%
114 1
1.1%
113 1
1.1%
112 1
1.1%
110 1
1.1%
109 1
1.1%
108 1
1.1%
107 1
1.1%
106 1
1.1%
105 1
1.1%

반영여부
Boolean

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size222.0 B
True
90 
ValueCountFrequency (%)
True 90
100.0%
2024-05-03T21:02:16.912051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록ID
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing90
Missing (%)100.0%
Memory size942.0 B

등록일
Date

UNIQUE 

Distinct90
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size852.0 B
Minimum2014-04-07 10:46:00
Maximum2021-10-07 16:47:46
2024-05-03T21:02:17.336973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:02:18.057899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최종수정ID
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing90
Missing (%)100.0%
Memory size942.0 B

최종수정일
Date

MISSING 

Distinct89
Distinct (%)100.0%
Missing1
Missing (%)1.1%
Memory size852.0 B
Minimum2014-09-18 10:08:38
Maximum2021-11-02 13:26:11
2024-05-03T21:02:18.751785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:02:19.366796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

에디터 설명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing90
Missing (%)100.0%
Memory size942.0 B

에디터 사용여부
Boolean

IMBALANCE  MISSING 

Distinct2
Distinct (%)2.4%
Missing8
Missing (%)8.9%
Memory size312.0 B
True
81 
False
 
1
(Missing)
 
8
ValueCountFrequency (%)
True 81
90.0%
False 1
 
1.1%
(Missing) 8
 
8.9%
2024-05-03T21:02:19.837866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2024-05-03T21:02:03.315921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-03T21:02:20.096150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
배너 ID배너구분배너명이미지명이미지파일정렬순서등록일최종수정일에디터 사용여부
배너 ID1.0001.0001.0001.0001.0001.0001.0001.0001.000
배너구분1.0001.0001.0001.0001.0000.7381.0001.0000.000
배너명1.0001.0001.0000.0001.0001.0001.0001.0001.000
이미지명1.0001.0000.0001.0001.0000.9461.0001.0001.000
이미지파일1.0001.0001.0001.0001.0001.0001.0001.0001.000
정렬순서1.0000.7381.0000.9461.0001.0001.0001.0000.000
등록일1.0001.0001.0001.0001.0001.0001.0001.0001.000
최종수정일1.0001.0001.0001.0001.0001.0001.0001.0001.000
에디터 사용여부1.0000.0001.0001.0001.0000.0001.0001.0001.000
2024-05-03T21:02:20.561362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
에디터 사용여부배너구분
에디터 사용여부1.0000.000
배너구분0.0001.000
2024-05-03T21:02:20.866530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정렬순서배너구분에디터 사용여부
정렬순서1.0000.5660.000
배너구분0.5661.0000.000
에디터 사용여부0.0000.0001.000

Missing values

2024-05-03T21:02:04.045519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-03T21:02:04.909072image/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.
2024-05-03T21:02:05.327987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

배너 ID배너구분배너명링크 URL이미지명이미지파일설명정렬순서반영여부등록ID등록일최종수정ID최종수정일에디터 설명에디터 사용여부
0BANNER_0000000000173B001성북진경페스티벌<NA>성북진경.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404071046003850.jpg&filePath=bannerthumb<NA>1Y<NA>2014-04-07 10:46:00.0<NA>2014-09-18 10:55:16.0<NA>Y
1BANNER_0000000000174B001성곽마을 축제<NA>도성마을 축제.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404110116546470.jpg&filePath=bannerthumb<NA>1Y<NA>2014-04-07 13:19:31.0<NA>2014-09-18 10:08:38.0<NA>Y
2BANNER_0000000000175B002해설 프로그램<NA>해설프로그램.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070121095450.jpg&filePath=bannerthumb<NA>190Y<NA>2014-04-07 13:21:09.0<NA>2021-10-28 17:41:33.0<NA>Y
3BANNER_0000000000176B002스탬프 투어<NA>한양도성스탬프투어.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070121559550.jpg&filePath=bannerthumb<NA>30Y<NA>2014-04-07 13:21:56.0<NA>2020-08-03 14:57:19.0<NA>Y
4BANNER_0000000000179B001한양도성주간<NA>한양도성주간.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_201404070124537580.jpg&filePath=bannerthumb<NA>3Y<NA>2014-04-07 13:24:53.0<NA>2014-10-08 15:30:24.0<NA>Y
5BANNER_0000000000188B004서울 한양도성 관광안내지도 (앞면)<NA>20131125-서울한양도성안내도A3_종로구_국문_앞면-01.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=[object HTMLInputElement]202108240239401180.jpg&filePath=bannerthumb<NA>20Y<NA>2014-04-11 07:47:25.0<NA>2020-05-19 08:04:42.0<NA><NA>
6BANNER_0000000000189B004서울 한양도성 관광안내지도 (뒷면)<NA>서울한양도성안내도_종로구_국문_뒷면.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=[object HTMLInputElement]202108240237402210.jpg&filePath=bannerthumb<NA>15Y<NA>2014-04-11 07:50:16.0<NA>2020-05-19 08:05:01.0<NA><NA>
7BANNER_0000000000208B004서울한양도성 가이드북 (21.7 국문)<NA>img_guide_book.gifhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=[object HTMLInputElement]201406120502156240.jpg&filePath=bannerthumb<NA>50Y<NA>2014-06-12 16:54:19.0<NA>2021-08-24 13:53:52.0<NA><NA>
8BANNER_0000000000209B004서울한양도성 가이드북 (영어)<NA>140612 가이드북 영어.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=[object HTMLInputElement]201409180133322700.jpg&filePath=bannerthumb<NA>48Y<NA>2014-06-12 17:04:16.0<NA>2021-05-17 13:56:36.0<NA><NA>
9BANNER_0000000000210B004서울한양도성 가이드북 (중국어)<NA>140612 가이드북 중국어.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=[object HTMLInputElement]201409251022588310.jpg&filePath=bannerthumb<NA>46Y<NA>2014-06-12 17:23:09.0<NA>2019-09-18 15:42:45.0<NA><NA>
배너 ID배너구분배너명링크 URL이미지명이미지파일설명정렬순서반영여부등록ID등록일최종수정ID최종수정일에디터 설명에디터 사용여부
80BANNER_0000000000358B001(문화체험프로그램)동동동대문을 열어라(11.4~8)<NA>꾸미기_캡처.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202010270133312990.jpg&filePath=bannerthumb<NA>106Y<NA>2020-10-27 13:38:30.0<NA>2020-10-29 14:30:17.0<NA>Y
81BANNER_0000000000359B001(문화체험프로그램)그림자아트(10.31~11.1)<NA>캡처12.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202010290221597020.jpg&filePath=bannerthumb<NA>105Y<NA>2020-10-29 14:27:01.0<NA>2020-10-29 14:32:43.0<NA>Y
82BANNER_0000000000360B001(문화체험프로그램)한양도성 빛초롱 순성(11.14)<NA>꾸미기_캡처.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202011131110312840.jpg&filePath=bannerthumb<NA>107Y<NA>2020-11-13 11:10:30.0<NA>2020-11-13 11:12:51.0<NA>Y
83BANNER_0000000000362B004한양도성 홍보 소책자 (21.7 국문)<NA>getImage_do2 copy.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202011170312390010.jpg&filePath=bannerthumb<NA>54Y<NA>2020-11-17 15:12:36.0<NA>2021-08-24 13:53:39.0<NA><NA>
84BANNER_0000000000367B004한양도성 홍보 소책자 (21.7. 영문)<NA>getImage_en.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202108200528100770.jpg&filePath=bannerthumb<NA>60Y<NA>2021-08-20 17:27:04.0<NA>2021-08-24 13:53:30.0<NA><NA>
85BANNER_0000000000368B0012021 훈련도감 무예 재현행사<NA>훈련도감.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202109161001563080.jpg&filePath=bannerthumb<NA>109Y<NA>2021-09-16 10:00:41.0<NA>2021-09-16 10:05:28.0<NA>Y
86BANNER_0000000000369B001제9회 한양도성문화제<NA>한양도성문화제.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202109161002438940.jpg&filePath=bannerthumb<NA>110Y<NA>2021-09-16 10:01:28.0<NA>2021-09-24 17:19:28.0<NA>Y
87BANNER_0000000000370B001바람과 함께 '한양도성 비대면 순성챌린지'참가자 모집<NA>순성탤린지.jpghttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202109161004477900.jpg&filePath=bannerthumb<NA>112Y<NA>2021-09-16 10:03:32.0<NA>2021-09-16 10:08:28.0<NA>Y
88BANNER_0000000000371B001(문화체험프로그램)한양도성 빛초롱 순성(10.3~)<NA>캡처123.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202110011049341480.jpg&filePath=bannerthumb<NA>113Y<NA>2021-10-01 10:48:13.0<NA>2021-10-01 10:50:27.0<NA>Y
89BANNER_0000000000372B001(문화체험프로그램)전통 옻칠 공예(11.11~)<NA>캡처1.JPGhttps://seoulcitywall.seoul.go.kr/child/file/getImage2.do?filePhysical=BNR_202110070449089970.jpg&filePath=bannerthumb<NA>114Y<NA>2021-10-07 16:47:46.0<NA>2021-11-02 13:26:11.0<NA>Y