Overview

Dataset statistics

Number of variables6
Number of observations247
Missing cells102
Missing cells (%)6.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.9 KiB
Average record size in memory49.5 B

Variable types

Text2
DateTime2
Boolean1
Numeric1

Dataset

Description제목,입력날짜,수정날짜,사용여부,게시물번호(pk),상세정보링크
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-17400/S/1/datasetView.do

Alerts

사용여부 has constant value ""Constant
수정날짜 has 102 (41.3%) missing valuesMissing
입력날짜 has unique valuesUnique
게시물번호(pk) has unique valuesUnique
상세정보링크 has unique valuesUnique

Reproduction

Analysis started2024-05-11 07:05:06.970870
Analysis finished2024-05-11 07:05:07.700286
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제목
Text

Distinct243
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-05-11T16:05:07.981795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length41
Mean length21.380567
Min length8

Characters and Unicode

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

Unique

Unique240 ?
Unique (%)97.2%

Sample

1st row[마포] 주한 카자흐스탄 대사관 마포자원회수시설 방문
2nd row[마포] 카타르 중앙자치의회 마포자원회수시설 방문
3rd row[마포] 환경부 마포자원회수시설 방문
4th row[마포] 인도 마하라슈트라주 마포자원회수시설 방문
5th row환경부 장관 양천자원회수시설 방문
ValueCountFrequency (%)
방문 136
 
12.8%
시설 49
 
4.6%
공무원 34
 
3.2%
시설방문 32
 
3.0%
b><font 27
 
2.5%
대표단 19
 
1.8%
및 18
 
1.7%
중국 15
 
1.4%
일행 14
 
1.3%
공무원단 13
 
1.2%
Other values (491) 702
66.3%
2024-05-11T16:05:08.624604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
826
 
15.6%
시 202
 
3.8%
방 196
 
3.7%
문 184
 
3.5%
원 168
 
3.2%
설 113
 
2.1%
o 102
 
1.9%
공 96
 
1.8%
무 86
 
1.6%
국 82
 
1.6%
Other values (355) 3226
61.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3444
65.2%
Space Separator 826
 
15.6%
Lowercase Letter 483
 
9.1%
Math Symbol 167
 
3.2%
Uppercase Letter 111
 
2.1%
Decimal Number 85
 
1.6%
Other Punctuation 83
 
1.6%
Open Punctuation 37
 
0.7%
Close Punctuation 37
 
0.7%
Dash Punctuation 6
 
0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 202
 
5.9%
방 196
 
5.7%
문 184
 
5.3%
원 168
 
4.9%
설 113
 
3.3%
공 96
 
2.8%
무 86
 
2.5%
국 82
 
2.4%
환 70
 
2.0%
경 69
 
2.0%
Other values (289) 2178
63.2%
Uppercase Letter
ValueCountFrequency (%)
A 15
13.5%
S 12
10.8%
E 10
 
9.0%
B 9
 
8.1%
K 9
 
8.1%
I 8
 
7.2%
M 6
 
5.4%
O 5
 
4.5%
C 5
 
4.5%
R 5
 
4.5%
Other values (11) 27
24.3%
Lowercase Letter
ValueCountFrequency (%)
o 102
21.1%
n 50
10.4%
r 50
10.4%
l 45
9.3%
e 44
9.1%
b 42
8.7%
c 35
 
7.2%
t 33
 
6.8%
f 32
 
6.6%
g 14
 
2.9%
Other values (9) 36
 
7.5%
Decimal Number
ValueCountFrequency (%)
0 26
30.6%
2 19
22.4%
1 15
17.6%
7 7
 
8.2%
6 6
 
7.1%
5 3
 
3.5%
9 3
 
3.5%
3 3
 
3.5%
4 2
 
2.4%
8 1
 
1.2%
Other Punctuation
ValueCountFrequency (%)
' 69
83.1%
, 7
 
8.4%
/ 4
 
4.8%
? 2
 
2.4%
. 1
 
1.2%
Math Symbol
ValueCountFrequency (%)
< 68
40.7%
> 68
40.7%
= 31
18.6%
Open Punctuation
ValueCountFrequency (%)
( 27
73.0%
[ 10
 
27.0%
Close Punctuation
ValueCountFrequency (%)
) 27
73.0%
] 10
 
27.0%
Space Separator
ValueCountFrequency (%)
826
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 1
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3444
65.2%
Common 1243
 
23.5%
Latin 594
 
11.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 202
 
5.9%
방 196
 
5.7%
문 184
 
5.3%
원 168
 
4.9%
설 113
 
3.3%
공 96
 
2.8%
무 86
 
2.5%
국 82
 
2.4%
환 70
 
2.0%
경 69
 
2.0%
Other values (289) 2178
63.2%
Latin
ValueCountFrequency (%)
o 102
17.2%
n 50
 
8.4%
r 50
 
8.4%
l 45
 
7.6%
e 44
 
7.4%
b 42
 
7.1%
c 35
 
5.9%
t 33
 
5.6%
f 32
 
5.4%
A 15
 
2.5%
Other values (30) 146
24.6%
Common
ValueCountFrequency (%)
826
66.5%
' 69
 
5.6%
< 68
 
5.5%
> 68
 
5.5%
= 31
 
2.5%
( 27
 
2.2%
) 27
 
2.2%
0 26
 
2.1%
2 19
 
1.5%
1 15
 
1.2%
Other values (16) 67
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3444
65.2%
ASCII 1835
34.7%
Punctuation 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
826
45.0%
o 102
 
5.6%
' 69
 
3.8%
< 68
 
3.7%
> 68
 
3.7%
n 50
 
2.7%
r 50
 
2.7%
l 45
 
2.5%
e 44
 
2.4%
b 42
 
2.3%
Other values (54) 471
25.7%
Hangul
ValueCountFrequency (%)
시 202
 
5.9%
방 196
 
5.7%
문 184
 
5.3%
원 168
 
4.9%
설 113
 
3.3%
공 96
 
2.8%
무 86
 
2.5%
국 82
 
2.4%
환 70
 
2.0%
경 69
 
2.0%
Other values (289) 2178
63.2%
Punctuation
ValueCountFrequency (%)
‘ 1
50.0%
’ 1
50.0%

입력날짜
Date

UNIQUE 

Distinct247
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
Minimum2006-02-13 11:51:40
Maximum2024-05-03 16:07:18
2024-05-11T16:05:08.818425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:05:09.030986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정날짜
Date

MISSING 

Distinct145
Distinct (%)100.0%
Missing102
Missing (%)41.3%
Memory size2.1 KiB
Minimum2006-02-14 14:26:49
Maximum2024-05-03 16:07:18
2024-05-11T16:05:09.197225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:05:09.388252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사용여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size379.0 B
True
247 
ValueCountFrequency (%)
True 247
100.0%
2024-05-11T16:05:09.519877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

게시물번호(pk)
Real number (ℝ)

UNIQUE 

Distinct247
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean134.35223
Minimum6
Maximum262
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2024-05-11T16:05:09.654472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6
5-th percentile19.3
Q168.5
median134
Q3198.5
95-th percentile249.7
Maximum262
Range256
Interquartile range (IQR)130

Descriptive statistics

Standard deviation74.651395
Coefficient of variation (CV)0.55563943
Kurtosis-1.2079658
Mean134.35223
Median Absolute Deviation (MAD)65
Skewness-0.00160296
Sum33185
Variance5572.8307
MonotonicityStrictly decreasing
2024-05-11T16:05:09.850846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
262 1
 
0.4%
86 1
 
0.4%
100 1
 
0.4%
99 1
 
0.4%
98 1
 
0.4%
97 1
 
0.4%
96 1
 
0.4%
95 1
 
0.4%
94 1
 
0.4%
92 1
 
0.4%
Other values (237) 237
96.0%
ValueCountFrequency (%)
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
11 1
0.4%
12 1
0.4%
13 1
0.4%
14 1
0.4%
15 1
0.4%
16 1
0.4%
ValueCountFrequency (%)
262 1
0.4%
261 1
0.4%
260 1
0.4%
259 1
0.4%
258 1
0.4%
257 1
0.4%
256 1
0.4%
255 1
0.4%
254 1
0.4%
253 1
0.4%

상세정보링크
Text

UNIQUE 

Distinct247
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2024-05-11T16:05:10.188718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length117
Median length117
Mean length116.62348
Min length115

Characters and Unicode

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

Unique

Unique247 ?
Unique (%)100.0%

Sample

1st rowhttps://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=262
2nd rowhttps://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=261
3rd rowhttps://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=260
4th rowhttps://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=259
5th rowhttps://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=258
ValueCountFrequency (%)
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=262 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=67 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=100 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=99 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=98 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=97 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=96 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=95 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=94 1
 
0.4%
https://rrf.seoul.go.kr/content/jccod1011view.do?pageindex=1&srchcategory=&menuid=&subpage=&menunm=&srchsj=&seqno=92 1
 
0.4%
Other values (237) 237
96.0%
2024-05-11T16:05:10.723196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 2470
 
8.6%
= 1729
 
6.0%
o 1729
 
6.0%
r 1482
 
5.1%
& 1482
 
5.1%
n 1482
 
5.1%
s 1482
 
5.1%
t 1235
 
4.3%
c 1235
 
4.3%
1 1137
 
3.9%
Other values (36) 13343
46.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 19513
67.7%
Other Punctuation 3952
 
13.7%
Decimal Number 1883
 
6.5%
Math Symbol 1729
 
6.0%
Uppercase Letter 1729
 
6.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 2470
12.7%
o 1729
 
8.9%
r 1482
 
7.6%
n 1482
 
7.6%
s 1482
 
7.6%
t 1235
 
6.3%
c 1235
 
6.3%
d 988
 
5.1%
u 988
 
5.1%
g 988
 
5.1%
Other values (14) 5434
27.8%
Decimal Number
ValueCountFrequency (%)
1 1137
60.4%
0 290
 
15.4%
2 117
 
6.2%
5 54
 
2.9%
4 54
 
2.9%
3 53
 
2.8%
6 46
 
2.4%
9 44
 
2.3%
8 44
 
2.3%
7 44
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
I 494
28.6%
N 247
14.3%
S 247
14.3%
C 247
14.3%
P 247
14.3%
V 247
14.3%
Other Punctuation
ValueCountFrequency (%)
& 1482
37.5%
/ 988
25.0%
. 988
25.0%
? 247
 
6.2%
: 247
 
6.2%
Math Symbol
ValueCountFrequency (%)
= 1729
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 21242
73.7%
Common 7564
 
26.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 2470
 
11.6%
o 1729
 
8.1%
r 1482
 
7.0%
n 1482
 
7.0%
s 1482
 
7.0%
t 1235
 
5.8%
c 1235
 
5.8%
d 988
 
4.7%
u 988
 
4.7%
g 988
 
4.7%
Other values (20) 7163
33.7%
Common
ValueCountFrequency (%)
= 1729
22.9%
& 1482
19.6%
1 1137
15.0%
/ 988
13.1%
. 988
13.1%
0 290
 
3.8%
? 247
 
3.3%
: 247
 
3.3%
2 117
 
1.5%
5 54
 
0.7%
Other values (6) 285
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 28806
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 2470
 
8.6%
= 1729
 
6.0%
o 1729
 
6.0%
r 1482
 
5.1%
& 1482
 
5.1%
n 1482
 
5.1%
s 1482
 
5.1%
t 1235
 
4.3%
c 1235
 
4.3%
1 1137
 
3.9%
Other values (36) 13343
46.3%

Interactions

2024-05-11T16:05:07.274572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-05-11T16:05:07.448919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T16:05:07.628368image/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

제목입력날짜수정날짜사용여부게시물번호(pk)상세정보링크
0[마포] 주한 카자흐스탄 대사관 마포자원회수시설 방문2024-05-03 16:07:18.02024-05-03 16:07:18.0Y262https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=262
1[마포] 카타르 중앙자치의회 마포자원회수시설 방문2024-02-21 15:51:28.02024-02-21 15:52:12.0Y261https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=261
2[마포] 환경부 마포자원회수시설 방문2023-08-30 11:06:05.02023-08-30 14:05:45.0Y260https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=260
3[마포] 인도 마하라슈트라주 마포자원회수시설 방문2023-03-28 11:19:21.02023-03-28 11:19:21.0Y259https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=259
4환경부 장관 양천자원회수시설 방문2023-02-09 16:08:08.02023-02-09 16:08:08.0Y258https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=258
5[양천]딩 중리 중국 전인대 상무위원회 부위원장 일행 방문2018-09-21 16:06:51.02018-09-21 16:06:51.0Y257https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=257
6[양천]세계은행환경전문가등 시설견학2018-03-26 16:58:15.02018-03-26 16:58:15.0Y256https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=256
7주한 방글라데시 대사 마포자원회수시설 방문2018-03-12 17:23:50.02018-03-12 17:44:16.0Y255https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=255
8세계은행 환경전문가 대표단 시설방문2017-05-23 09:51:15.02017-05-23 09:51:15.0Y254https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=254
9우크라이나 키예프 시 공무원 방문2017-02-10 09:28:44.02017-02-10 09:30:52.0Y253https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=253
제목입력날짜수정날짜사용여부게시물번호(pk)상세정보링크
237'중앙공무원교육원 고위공무원단' 방문2006-05-09 13:48:49.02006-05-09 14:01:13.0Y16https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=16
238연세대학교 의과대학 시설 견학2006-04-12 11:43:59.02006-04-12 11:46:39.0Y15https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=15
239[서울특별시쓰레기문제해결을위한시민협의회] 정기회의 개최2006-03-28 17:12:58.0<NA>Y14https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=14
240강남자원회수시설 환경경영체제 인증 취득2006-03-02 13:21:32.02006-03-02 14:27:31.0Y13https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=13
241중국 치둥시 정부대표단 시설 방문2006-02-25 10:08:44.02006-02-25 10:25:37.0Y12https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=12
242자치구별 자원순환테마 전시관 및 자원회수시설 견학2006-02-15 14:09:45.02006-02-15 19:08:23.0Y11https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=11
243자치구별 자원순환테마 전시관 및 자원회수시설 견학2006-02-14 15:14:10.02006-02-21 13:51:47.0Y9https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=9
244아기스포츠단 환경사생대회2006-02-14 09:15:42.02006-02-14 14:26:49.0Y8https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=8
245자치구별 자원순환테마 전시관 및 자원회수시설 견학2006-02-13 16:07:03.02006-02-20 13:48:05.0Y7https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=7
246육군 제7135부대 시설 견학2006-02-13 11:51:40.0<NA>Y6https://rrf.seoul.go.kr/content/jccod1011View.do?pageIndex=1&srchCategory=&menuId=&subPage=&menuNm=&srchSj=&seqno=6