Overview

Dataset statistics

Number of variables6
Number of observations1462
Missing cells1274
Missing cells (%)14.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory70.1 KiB
Average record size in memory49.1 B

Variable types

Text1
DateTime2
Boolean1
Numeric1
Categorical1

Dataset

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

Alerts

사용여부 has constant value ""Constant
수정날짜 has 1274 (87.1%) missing valuesMissing
입력날짜 has unique valuesUnique
게시물번호(pk) has unique valuesUnique

Reproduction

Analysis started2024-05-10 23:25:01.680525
Analysis finished2024-05-10 23:25:03.619196
Duration1.94 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제목
Text

Distinct533
Distinct (%)36.5%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
2024-05-10T23:25:04.113655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length40
Mean length19.812585
Min length7

Characters and Unicode

Total characters28966
Distinct characters219
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

Unique396 ?
Unique (%)27.1%

Sample

1st row마포자원회수시설 전광판 미표출 안내
2nd row마포자원회수시설 CleanSYS 정기점검 안내
3rd row마포자원회수시설 CleanSYS 정기점검 안내
4th row노원자원회수시설 굴뚝자동측정시스템(CleanSYS) 정기점검 안내
5th row마포자원회수시설 소각로 #2호기 가동중지 안내
ValueCountFrequency (%)
cleansys 329
 
6.2%
관련 293
 
5.5%
안내 282
 
5.3%
양천자원회수시설 269
 
5.1%
주간점검 259
 
4.9%
소각로 258
 
4.9%
tms 254
 
4.8%
정기점검 225
 
4.2%
안내입니다 163
 
3.1%
알림 160
 
3.0%
Other values (345) 2815
53.0%
2024-05-10T23:25:05.751193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3988
 
13.8%
S 1658
 
5.7%
960
 
3.3%
937
 
3.2%
914
 
3.2%
875
 
3.0%
790
 
2.7%
716
 
2.5%
693
 
2.4%
l 676
 
2.3%
Other values (209) 16759
57.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 17011
58.7%
Space Separator 3988
 
13.8%
Uppercase Letter 3782
 
13.1%
Lowercase Letter 2829
 
9.8%
Decimal Number 492
 
1.7%
Other Punctuation 328
 
1.1%
Open Punctuation 262
 
0.9%
Close Punctuation 262
 
0.9%
Math Symbol 9
 
< 0.1%
Dash Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
960
 
5.6%
937
 
5.5%
914
 
5.4%
875
 
5.1%
790
 
4.6%
716
 
4.2%
693
 
4.1%
597
 
3.5%
591
 
3.5%
570
 
3.4%
Other values (156) 9368
55.1%
Uppercase Letter
ValueCountFrequency (%)
S 1658
43.8%
C 655
 
17.3%
Y 639
 
16.9%
T 382
 
10.1%
M 381
 
10.1%
A 12
 
0.3%
N 9
 
0.2%
H 8
 
0.2%
D 8
 
0.2%
O 8
 
0.2%
Other values (6) 22
 
0.6%
Lowercase Letter
ValueCountFrequency (%)
l 676
23.9%
a 670
23.7%
e 668
23.6%
n 667
23.6%
s 70
 
2.5%
y 33
 
1.2%
c 32
 
1.1%
t 4
 
0.1%
u 3
 
0.1%
x 2
 
0.1%
Other values (3) 4
 
0.1%
Decimal Number
ValueCountFrequency (%)
2 189
38.4%
1 157
31.9%
0 61
 
12.4%
3 44
 
8.9%
5 9
 
1.8%
4 7
 
1.4%
7 7
 
1.4%
6 6
 
1.2%
9 6
 
1.2%
8 6
 
1.2%
Other Punctuation
ValueCountFrequency (%)
. 224
68.3%
# 61
 
18.6%
, 24
 
7.3%
: 14
 
4.3%
' 2
 
0.6%
/ 2
 
0.6%
? 1
 
0.3%
Open Punctuation
ValueCountFrequency (%)
[ 206
78.6%
( 56
 
21.4%
Close Punctuation
ValueCountFrequency (%)
] 206
78.6%
) 56
 
21.4%
Space Separator
ValueCountFrequency (%)
3988
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 17011
58.7%
Latin 6611
 
22.8%
Common 5344
 
18.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
960
 
5.6%
937
 
5.5%
914
 
5.4%
875
 
5.1%
790
 
4.6%
716
 
4.2%
693
 
4.1%
597
 
3.5%
591
 
3.5%
570
 
3.4%
Other values (156) 9368
55.1%
Latin
ValueCountFrequency (%)
S 1658
25.1%
l 676
10.2%
a 670
10.1%
e 668
10.1%
n 667
10.1%
C 655
 
9.9%
Y 639
 
9.7%
T 382
 
5.8%
M 381
 
5.8%
s 70
 
1.1%
Other values (19) 145
 
2.2%
Common
ValueCountFrequency (%)
3988
74.6%
. 224
 
4.2%
[ 206
 
3.9%
] 206
 
3.9%
2 189
 
3.5%
1 157
 
2.9%
0 61
 
1.1%
# 61
 
1.1%
( 56
 
1.0%
) 56
 
1.0%
Other values (14) 140
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 17011
58.7%
ASCII 11955
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3988
33.4%
S 1658
13.9%
l 676
 
5.7%
a 670
 
5.6%
e 668
 
5.6%
n 667
 
5.6%
C 655
 
5.5%
Y 639
 
5.3%
T 382
 
3.2%
M 381
 
3.2%
Other values (43) 1571
 
13.1%
Hangul
ValueCountFrequency (%)
960
 
5.6%
937
 
5.5%
914
 
5.4%
875
 
5.1%
790
 
4.6%
716
 
4.2%
693
 
4.1%
597
 
3.5%
591
 
3.5%
570
 
3.4%
Other values (156) 9368
55.1%

입력날짜
Date

UNIQUE 

Distinct1462
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2006-04-12 13:53:47
Maximum2024-05-07 09:16:47
2024-05-10T23:25:06.265950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T23:25:06.903068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정날짜
Date

MISSING 

Distinct188
Distinct (%)100.0%
Missing1274
Missing (%)87.1%
Memory size11.6 KiB
Minimum2006-04-12 13:55:07
Maximum2024-04-17 10:13:41
2024-05-10T23:25:07.378548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T23:25:07.791550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사용여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
True
1462 
ValueCountFrequency (%)
True 1462
100.0%
2024-05-10T23:25:08.148717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

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

UNIQUE 

Distinct1462
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean740.64432
Minimum1
Maximum1528
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.0 KiB
2024-05-10T23:25:08.531819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile74.05
Q1367.25
median735.5
Q31106.75
95-th percentile1454.95
Maximum1528
Range1527
Interquartile range (IQR)739.5

Descriptive statistics

Standard deviation433.04748
Coefficient of variation (CV)0.5846902
Kurtosis-1.1517002
Mean740.64432
Median Absolute Deviation (MAD)370
Skewness0.048947397
Sum1082822
Variance187530.12
MonotonicityStrictly decreasing
2024-05-10T23:25:09.119732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1528 1
 
0.1%
480 1
 
0.1%
482 1
 
0.1%
483 1
 
0.1%
484 1
 
0.1%
485 1
 
0.1%
486 1
 
0.1%
487 1
 
0.1%
488 1
 
0.1%
489 1
 
0.1%
Other values (1452) 1452
99.3%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1528 1
0.1%
1527 1
0.1%
1526 1
0.1%
1525 1
0.1%
1524 1
0.1%
1523 1
0.1%
1522 1
0.1%
1521 1
0.1%
1520 1
0.1%
1519 1
0.1%
Distinct4
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
https://rrf.seoul.go.kr/content/bcreb226.do
489 
https://rrf.seoul.go.kr/content/bcrec237.do
362 
https://rrf.seoul.go.kr/content/bcree257.do
359 
https://rrf.seoul.go.kr/content/bcred246.do
252 

Length

Max length43
Median length43
Mean length43
Min length43

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttps://rrf.seoul.go.kr/content/bcred246.do
2nd rowhttps://rrf.seoul.go.kr/content/bcred246.do
3rd rowhttps://rrf.seoul.go.kr/content/bcred246.do
4th rowhttps://rrf.seoul.go.kr/content/bcrec237.do
5th rowhttps://rrf.seoul.go.kr/content/bcred246.do

Common Values

ValueCountFrequency (%)
https://rrf.seoul.go.kr/content/bcreb226.do 489
33.4%
https://rrf.seoul.go.kr/content/bcrec237.do 362
24.8%
https://rrf.seoul.go.kr/content/bcree257.do 359
24.6%
https://rrf.seoul.go.kr/content/bcred246.do 252
17.2%

Length

2024-05-10T23:25:09.758136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:25:10.242559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://rrf.seoul.go.kr/content/bcreb226.do 489
33.4%
https://rrf.seoul.go.kr/content/bcrec237.do 362
24.8%
https://rrf.seoul.go.kr/content/bcree257.do 359
24.6%
https://rrf.seoul.go.kr/content/bcred246.do 252
17.2%

Interactions

2024-05-10T23:25:02.300170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-10T23:25:10.566417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
게시물번호(pk)상세정보링크
게시물번호(pk)1.0000.498
상세정보링크0.4981.000
2024-05-10T23:25:10.818344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
게시물번호(pk)상세정보링크
게시물번호(pk)1.0000.320
상세정보링크0.3201.000

Missing values

2024-05-10T23:25:02.842911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-10T23:25:03.368124image/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-07 09:16:47.0<NA>Y1528https://rrf.seoul.go.kr/content/bcred246.do
1마포자원회수시설 CleanSYS 정기점검 안내2024-05-07 09:10:57.0<NA>Y1527https://rrf.seoul.go.kr/content/bcred246.do
2마포자원회수시설 CleanSYS 정기점검 안내2024-04-30 09:13:56.0<NA>Y1526https://rrf.seoul.go.kr/content/bcred246.do
3노원자원회수시설 굴뚝자동측정시스템(CleanSYS) 정기점검 안내2024-04-30 09:01:38.0<NA>Y1525https://rrf.seoul.go.kr/content/bcrec237.do
4마포자원회수시설 소각로 #2호기 가동중지 안내2024-04-29 09:04:53.0<NA>Y1524https://rrf.seoul.go.kr/content/bcred246.do
5노원자원회수시설 점검 및 보수로 인한 굴뚝자동측정시스템(CleanSYS) 조치 안내2024-04-25 13:22:24.0<NA>Y1523https://rrf.seoul.go.kr/content/bcrec237.do
6양천자원회수시설 CleanSYS 주간점검 안내2024-04-24 10:43:11.0<NA>Y1522https://rrf.seoul.go.kr/content/bcree257.do
7노원자원회수시설 굴뚝자동측정시스템(CleanSYS) 정기점검 안내2024-04-24 09:04:21.0<NA>Y1521https://rrf.seoul.go.kr/content/bcrec237.do
8마포자원회수시설 2024년 소정비 일정 안내2024-04-23 11:22:34.0<NA>Y1520https://rrf.seoul.go.kr/content/bcred246.do
9마포자원회수시설 CleanSYS 정기점검 안내2024-04-23 08:22:02.0<NA>Y1519https://rrf.seoul.go.kr/content/bcred246.do
제목입력날짜수정날짜사용여부게시물번호(pk)상세정보링크
1452소각로 #2호기 TMS 수치 관련(15:00~18:00)2006-04-21 17:50:40.0<NA>Y10https://rrf.seoul.go.kr/content/bcree257.do
1453TMS 표출오류2006-04-21 12:39:28.0<NA>Y9https://rrf.seoul.go.kr/content/bcred246.do
1454소각로 #2호기 가동정지 일정 변경2006-04-20 09:34:16.02006-04-20 09:38:38.0Y8https://rrf.seoul.go.kr/content/bcree257.do
1455TMS정상표출-소각로 정상가동(2호기)2006-04-19 18:07:24.0<NA>Y7https://rrf.seoul.go.kr/content/bcreb226.do
1456강남 TMS자료 표출 오류입니다.2006-04-19 09:52:30.02006-04-19 10:09:31.0Y6https://rrf.seoul.go.kr/content/bcreb226.do
1457소각로2호기 가동정지 계획2006-04-18 14:17:23.02006-04-19 11:38:48.0Y5https://rrf.seoul.go.kr/content/bcree257.do
1458소각설비 가동중지2006-04-14 11:18:46.02006-04-14 12:08:51.0Y4https://rrf.seoul.go.kr/content/bcred246.do
14594월 12일 ~ 4월 13일 까지 TMS시스템을 점검합니다.2006-04-12 15:12:34.0<NA>Y3https://rrf.seoul.go.kr/content/bcreb226.do
1460이 곳은 각 시설의 배출가스 농도를 실시간으로 공개하는 곳입니다.2006-04-12 14:01:44.0<NA>Y2https://rrf.seoul.go.kr/content/bcreb226.do
1461이 곳은 각 시설의 배출가스 농도를 실시간으로 공개하는 곳입니다.2006-04-12 13:53:47.02006-04-12 13:55:07.0Y1https://rrf.seoul.go.kr/content/bcred246.do