Overview

Dataset statistics

Number of variables6
Number of observations97
Missing cells12
Missing cells (%)2.1%
Duplicate rows5
Duplicate rows (%)5.2%
Total size in memory4.8 KiB
Average record size in memory50.4 B

Variable types

Text2
Categorical4

Dataset

Description서울특별시_동대문구_폐건전지폐형광등분리수거함(설치주소, 설치건물, 보유수량, 데이터기준일자)을 알 수 있는 공공데이터입니다.
URLhttps://www.data.go.kr/data/15038091/fileData.do

Alerts

관리부서명 has constant value ""Constant
관리부서 전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 5 (5.2%) duplicate rowsDuplicates
보유수량 is highly imbalanced (84.5%)Imbalance
설치건물 has 12 (12.4%) missing valuesMissing

Reproduction

Analysis started2023-12-12 08:47:13.070672
Analysis finished2023-12-12 08:47:13.768261
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치주소
Text

Distinct89
Distinct (%)91.8%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-12-12T17:47:13.927028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length19.979381
Min length16

Characters and Unicode

Total characters1938
Distinct characters69
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

Unique82 ?
Unique (%)84.5%

Sample

1st row서울특별시 동대문구 천호대로133
2nd row서울특별시 동대문구 무학로133
3rd row서울특별시 동대문구 천호대로2길23-9
4th row서울특별시 동대문구 무학로26길16
5th row서울특별시 동대문구 왕산로81
ValueCountFrequency (%)
서울특별시 97
32.6%
동대문구 97
32.6%
답십리로130 3
 
1.0%
전농로20길31 2
 
0.7%
황물로15길25 2
 
0.7%
답십리로141 2
 
0.7%
약령시로154 2
 
0.7%
전농로3길62 2
 
0.7%
한천로11길 2
 
0.7%
10-1 2
 
0.7%
Other values (86) 87
29.2%
2023-12-12T17:47:14.309641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
280
 
14.4%
대 111
 
5.7%
동 105
 
5.4%
시 104
 
5.4%
서 102
 
5.3%
울 102
 
5.3%
문 100
 
5.2%
특 97
 
5.0%
별 97
 
5.0%
구 97
 
5.0%
Other values (59) 743
38.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1306
67.4%
Decimal Number 337
 
17.4%
Space Separator 280
 
14.4%
Dash Punctuation 15
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 111
 
8.5%
동 105
 
8.0%
시 104
 
8.0%
서 102
 
7.8%
울 102
 
7.8%
문 100
 
7.7%
특 97
 
7.4%
별 97
 
7.4%
구 97
 
7.4%
로 96
 
7.4%
Other values (47) 295
22.6%
Decimal Number
ValueCountFrequency (%)
1 89
26.4%
3 41
12.2%
2 41
12.2%
7 34
 
10.1%
5 28
 
8.3%
0 28
 
8.3%
6 24
 
7.1%
8 21
 
6.2%
4 18
 
5.3%
9 13
 
3.9%
Space Separator
ValueCountFrequency (%)
280
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1306
67.4%
Common 632
32.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 111
 
8.5%
동 105
 
8.0%
시 104
 
8.0%
서 102
 
7.8%
울 102
 
7.8%
문 100
 
7.7%
특 97
 
7.4%
별 97
 
7.4%
구 97
 
7.4%
로 96
 
7.4%
Other values (47) 295
22.6%
Common
ValueCountFrequency (%)
280
44.3%
1 89
 
14.1%
3 41
 
6.5%
2 41
 
6.5%
7 34
 
5.4%
5 28
 
4.4%
0 28
 
4.4%
6 24
 
3.8%
8 21
 
3.3%
4 18
 
2.8%
Other values (2) 28
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1306
67.4%
ASCII 632
32.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
280
44.3%
1 89
 
14.1%
3 41
 
6.5%
2 41
 
6.5%
7 34
 
5.4%
5 28
 
4.4%
0 28
 
4.4%
6 24
 
3.8%
8 21
 
3.3%
4 18
 
2.8%
Other values (2) 28
 
4.4%
Hangul
ValueCountFrequency (%)
대 111
 
8.5%
동 105
 
8.0%
시 104
 
8.0%
서 102
 
7.8%
울 102
 
7.8%
문 100
 
7.7%
특 97
 
7.4%
별 97
 
7.4%
구 97
 
7.4%
로 96
 
7.4%
Other values (47) 295
22.6%

설치건물
Text

MISSING 

Distinct80
Distinct (%)94.1%
Missing12
Missing (%)12.4%
Memory size908.0 B
2023-12-12T17:47:14.565048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length8
Min length4

Characters and Unicode

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

Unique

Unique76 ?
Unique (%)89.4%

Sample

1st row홈플러스 동대문점
2nd row용두어린이영어도서관
3rd row신설동 복지지원센터
4th row신동아아파트
5th row두산베어스타워
ValueCountFrequency (%)
주민센터 4
 
4.1%
답십리래미안위브 3
 
3.1%
동아아파트 3
 
3.1%
답십리 2
 
2.1%
답십리두산위브아파트 2
 
2.1%
미주아파트 2
 
2.1%
군자초등학교 1
 
1.0%
장안삼성래미안아파트 1
 
1.0%
해오름아파트 1
 
1.0%
신일해피트리3차아파트 1
 
1.0%
Other values (77) 77
79.4%
2023-12-12T17:47:15.046482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
트 42
 
6.2%
아 41
 
6.0%
파 39
 
5.7%
동 25
 
3.7%
리 19
 
2.8%
교 18
 
2.6%
학 17
 
2.5%
안 17
 
2.5%
답 16
 
2.4%
십 14
 
2.1%
Other values (136) 432
63.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 644
94.7%
Decimal Number 22
 
3.2%
Space Separator 12
 
1.8%
Lowercase Letter 1
 
0.1%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
트 42
 
6.5%
아 41
 
6.4%
파 39
 
6.1%
동 25
 
3.9%
리 19
 
3.0%
교 18
 
2.8%
학 17
 
2.6%
안 17
 
2.6%
답 16
 
2.5%
십 14
 
2.2%
Other values (126) 396
61.5%
Decimal Number
ValueCountFrequency (%)
1 10
45.5%
2 6
27.3%
3 2
 
9.1%
8 1
 
4.5%
4 1
 
4.5%
7 1
 
4.5%
9 1
 
4.5%
Space Separator
ValueCountFrequency (%)
12
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 644
94.7%
Common 35
 
5.1%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
트 42
 
6.5%
아 41
 
6.4%
파 39
 
6.1%
동 25
 
3.9%
리 19
 
3.0%
교 18
 
2.8%
학 17
 
2.6%
안 17
 
2.6%
답 16
 
2.5%
십 14
 
2.2%
Other values (126) 396
61.5%
Common
ValueCountFrequency (%)
12
34.3%
1 10
28.6%
2 6
17.1%
3 2
 
5.7%
8 1
 
2.9%
4 1
 
2.9%
- 1
 
2.9%
7 1
 
2.9%
9 1
 
2.9%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 644
94.7%
ASCII 36
 
5.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
트 42
 
6.5%
아 41
 
6.4%
파 39
 
6.1%
동 25
 
3.9%
리 19
 
3.0%
교 18
 
2.8%
학 17
 
2.6%
안 17
 
2.6%
답 16
 
2.5%
십 14
 
2.2%
Other values (126) 396
61.5%
ASCII
ValueCountFrequency (%)
12
33.3%
1 10
27.8%
2 6
16.7%
3 2
 
5.6%
e 1
 
2.8%
8 1
 
2.8%
4 1
 
2.8%
- 1
 
2.8%
7 1
 
2.8%
9 1
 
2.8%

보유수량
Categorical

IMBALANCE 

Distinct4
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size908.0 B
1
93 
3
 
2
4
 
1
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)2.1%

Sample

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

Common Values

ValueCountFrequency (%)
1 93
95.9%
3 2
 
2.1%
4 1
 
1.0%
2 1
 
1.0%

Length

2023-12-12T17:47:15.230933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:47:15.370974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 93
95.9%
3 2
 
2.1%
4 1
 
1.0%
2 1
 
1.0%

관리부서명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
서울특별시 동대문구청
97 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 동대문구청
2nd row서울특별시 동대문구청
3rd row서울특별시 동대문구청
4th row서울특별시 동대문구청
5th row서울특별시 동대문구청

Common Values

ValueCountFrequency (%)
서울특별시 동대문구청 97
100.0%

Length

2023-12-12T17:47:15.538687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:47:15.664376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 97
50.0%
동대문구청 97
50.0%

관리부서 전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
02-2127-5290
97 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-2127-5290
2nd row02-2127-5290
3rd row02-2127-5290
4th row02-2127-5290
5th row02-2127-5290

Common Values

ValueCountFrequency (%)
02-2127-5290 97
100.0%

Length

2023-12-12T17:47:15.784284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:47:15.899771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-2127-5290 97
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-06-29
97 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-29
2nd row2023-06-29
3rd row2023-06-29
4th row2023-06-29
5th row2023-06-29

Common Values

ValueCountFrequency (%)
2023-06-29 97
100.0%

Length

2023-12-12T17:47:16.018430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:47:16.127028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-29 97
100.0%

Correlations

2023-12-12T17:47:16.188269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치주소설치건물보유수량
설치주소1.0000.9990.000
설치건물0.9991.0000.000
보유수량0.0000.0001.000

Missing values

2023-12-12T17:47:13.586209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:47:13.725161image/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서울특별시 동대문구 천호대로133홈플러스 동대문점1서울특별시 동대문구청02-2127-52902023-06-29
1서울특별시 동대문구 무학로133용두어린이영어도서관1서울특별시 동대문구청02-2127-52902023-06-29
2서울특별시 동대문구 천호대로2길23-9신설동 복지지원센터1서울특별시 동대문구청02-2127-52902023-06-29
3서울특별시 동대문구 무학로26길16신동아아파트1서울특별시 동대문구청02-2127-52902023-06-29
4서울특별시 동대문구 왕산로81두산베어스타워1서울특별시 동대문구청02-2127-52902023-06-29
5서울특별시 동대문구 천호대로25길81랜드마크타워1서울특별시 동대문구청02-2127-52902023-06-29
6서울특별시 동대문구 왕산로60-1<NA>1서울특별시 동대문구청02-2127-52902023-06-29
7서울특별시 동대문구 왕산로16길47청재제일타운아파트1서울특별시 동대문구청02-2127-52902023-06-29
8서울특별시 동대문구 정릉천동로58롯데캐슬피렌체1서울특별시 동대문구청02-2127-52902023-06-29
9서울특별시 동대문구 정릉천동로16용두두산위브1서울특별시 동대문구청02-2127-52902023-06-29
설치주소설치건물보유수량관리부서명관리부서 전화번호데이터기준일자
87서울특별시 동대문구 한천로300휘경 동일스위트리버아파트1서울특별시 동대문구청02-2127-52902023-06-29
88서울특별시 동대문구 망우로28회기휘경새마을금고1서울특별시 동대문구청02-2127-52902023-06-29
89서울특별시 동대문구 외대역동로114-1이문1동주민센터1서울특별시 동대문구청02-2127-52902023-06-29
90서울특별시 동대문구 이문로9길52이문청소년독서실1서울특별시 동대문구청02-2127-52902023-06-29
91서울특별시 동대문구 이문로114<NA>1서울특별시 동대문구청02-2127-52902023-06-29
92서울특별시 동대문구 휘경로17길13-5<NA>1서울특별시 동대문구청02-2127-52902023-06-29
93서울특별시 동대문구 회기로25길67동안교회1서울특별시 동대문구청02-2127-52902023-06-29
94서울특별시 동대문구 휘경로2길25<NA>1서울특별시 동대문구청02-2127-52902023-06-29
95서울특별시 동대문구 한천로58길107이문현대아파트1서울특별시 동대문구청02-2127-52902023-06-29
96서울특별시 동대문구 한천로58길47이문쌍용아파트1서울특별시 동대문구청02-2127-52902023-06-29

Duplicate rows

Most frequently occurring

설치주소설치건물보유수량관리부서명관리부서 전화번호데이터기준일자# duplicates
0서울특별시 동대문구 답십리로130답십리래미안위브1서울특별시 동대문구청02-2127-52902023-06-292
1서울특별시 동대문구 답십리로141<NA>1서울특별시 동대문구청02-2127-52902023-06-292
2서울특별시 동대문구 전농로3길62<NA>1서울특별시 동대문구청02-2127-52902023-06-292
3서울특별시 동대문구 한천로11길 10-1답십리 동아아파트1서울특별시 동대문구청02-2127-52902023-06-292
4서울특별시 동대문구 황물로15길25답십리두산위브아파트1서울특별시 동대문구청02-2127-52902023-06-292