Overview

Dataset statistics

Number of variables12
Number of observations217
Missing cells401
Missing cells (%)15.4%
Duplicate rows9
Duplicate rows (%)4.1%
Total size in memory20.5 KiB
Average record size in memory96.6 B

Variable types

Text6
Categorical5
DateTime1

Dataset

Description구로구청 청소환경과에서 관리하고 있는 가로휴지통 현황입니다. 소재지 주소, 상세위치, 위경도, 설치장소유형, 수거쓰레기종류, 쓰레기통형태, 관리기관명, 관리기관전화번호, 데이터기준일자로 구성되어있습니다.
Author서울특별시 구로구
URLhttps://www.data.go.kr/data/15087773/fileData.do

Alerts

관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 9 (4.1%) duplicate rowsDuplicates
설치장소유형 is highly overall correlated with 수거쓰레기종류 and 1 other fieldsHigh correlation
수거쓰레기종류 is highly overall correlated with 설치장소유형 and 1 other fieldsHigh correlation
쓰레기통형태 is highly overall correlated with 설치장소유형 and 1 other fieldsHigh correlation
쓰레기통형태 is highly imbalanced (67.3%)Imbalance
소재지도로명주소 has 23 (10.6%) missing valuesMissing
소재지지번주소 has 74 (34.1%) missing valuesMissing
상세위치 has 144 (66.4%) missing valuesMissing
위도 has 80 (36.9%) missing valuesMissing
경도 has 80 (36.9%) missing valuesMissing

Reproduction

Analysis started2024-04-06 08:49:16.831566
Analysis finished2024-04-06 08:49:20.720752
Duration3.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

소재지도로명
Text

Distinct53
Distinct (%)24.4%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-04-06T17:49:21.069865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length4.3317972
Min length3

Characters and Unicode

Total characters940
Distinct characters54
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique20 ?
Unique (%)9.2%

Sample

1st row구로동로
2nd row구로동로
3rd row남부순환로
4th row남부순환로105길
5th row남부순환로105길
ValueCountFrequency (%)
경인로 30
 
13.8%
구로동로 27
 
12.4%
가마산로 19
 
8.8%
우마길 11
 
5.1%
고척로 11
 
5.1%
신도림로 9
 
4.1%
부일로 7
 
3.2%
개봉로 6
 
2.8%
구로중앙로 6
 
2.8%
서해안로 5
 
2.3%
Other values (43) 86
39.6%
2024-04-06T17:49:21.995580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 239
25.4%
길 66
 
7.0%
경 41
 
4.4%
인 40
 
4.3%
구 38
 
4.0%
마 31
 
3.3%
동 28
 
3.0%
가 23
 
2.4%
3 23
 
2.4%
부 20
 
2.1%
Other values (44) 391
41.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 833
88.6%
Decimal Number 107
 
11.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 239
28.7%
길 66
 
7.9%
경 41
 
4.9%
인 40
 
4.8%
구 38
 
4.6%
마 31
 
3.7%
동 28
 
3.4%
가 23
 
2.8%
부 20
 
2.4%
산 20
 
2.4%
Other values (34) 287
34.5%
Decimal Number
ValueCountFrequency (%)
3 23
21.5%
2 19
17.8%
1 17
15.9%
0 11
10.3%
7 10
9.3%
5 10
9.3%
9 7
 
6.5%
6 5
 
4.7%
4 4
 
3.7%
8 1
 
0.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 833
88.6%
Common 107
 
11.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 239
28.7%
길 66
 
7.9%
경 41
 
4.9%
인 40
 
4.8%
구 38
 
4.6%
마 31
 
3.7%
동 28
 
3.4%
가 23
 
2.8%
부 20
 
2.4%
산 20
 
2.4%
Other values (34) 287
34.5%
Common
ValueCountFrequency (%)
3 23
21.5%
2 19
17.8%
1 17
15.9%
0 11
10.3%
7 10
9.3%
5 10
9.3%
9 7
 
6.5%
6 5
 
4.7%
4 4
 
3.7%
8 1
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 833
88.6%
ASCII 107
 
11.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 239
28.7%
길 66
 
7.9%
경 41
 
4.9%
인 40
 
4.8%
구 38
 
4.6%
마 31
 
3.7%
동 28
 
3.4%
가 23
 
2.8%
부 20
 
2.4%
산 20
 
2.4%
Other values (34) 287
34.5%
ASCII
ValueCountFrequency (%)
3 23
21.5%
2 19
17.8%
1 17
15.9%
0 11
10.3%
7 10
9.3%
5 10
9.3%
9 7
 
6.5%
6 5
 
4.7%
4 4
 
3.7%
8 1
 
0.9%

소재지도로명주소
Text

MISSING 

Distinct151
Distinct (%)77.8%
Missing23
Missing (%)10.6%
Memory size1.8 KiB
2024-04-06T17:49:22.795114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length16.742268
Min length6

Characters and Unicode

Total characters3248
Distinct characters59
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

Unique117 ?
Unique (%)60.3%

Sample

1st row서울특별시 구로구 구로동로 13
2nd row서울특별시 구로구 구로동로 25
3rd row서울특별시 구로구 남부순환로 1295
4th row서울특별시 구로구 남부순환로105길 76
5th row서울특별시 구로구 남부순환로105길 134
ValueCountFrequency (%)
서울특별시 167
23.4%
구로구 167
23.4%
구로동로 26
 
3.6%
가마산로 19
 
2.7%
경인로 17
 
2.4%
고척로 11
 
1.5%
신도림로 9
 
1.3%
개봉로 6
 
0.8%
우마길 5
 
0.7%
7 5
 
0.7%
Other values (172) 283
39.6%
2024-04-06T17:49:24.137944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
521
16.0%
로 378
11.6%
구 374
11.5%
시 171
 
5.3%
서 170
 
5.2%
특 167
 
5.1%
별 167
 
5.1%
울 167
 
5.1%
1 118
 
3.6%
2 100
 
3.1%
Other values (49) 915
28.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2090
64.3%
Decimal Number 611
 
18.8%
Space Separator 521
 
16.0%
Dash Punctuation 26
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 378
18.1%
구 374
17.9%
시 171
8.2%
서 170
8.1%
특 167
8.0%
별 167
8.0%
울 167
8.0%
길 63
 
3.0%
동 33
 
1.6%
마 31
 
1.5%
Other values (37) 369
17.7%
Decimal Number
ValueCountFrequency (%)
1 118
19.3%
2 100
16.4%
3 75
12.3%
5 61
10.0%
6 57
9.3%
7 51
8.3%
0 45
 
7.4%
4 44
 
7.2%
9 36
 
5.9%
8 24
 
3.9%
Space Separator
ValueCountFrequency (%)
521
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2090
64.3%
Common 1158
35.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 378
18.1%
구 374
17.9%
시 171
8.2%
서 170
8.1%
특 167
8.0%
별 167
8.0%
울 167
8.0%
길 63
 
3.0%
동 33
 
1.6%
마 31
 
1.5%
Other values (37) 369
17.7%
Common
ValueCountFrequency (%)
521
45.0%
1 118
 
10.2%
2 100
 
8.6%
3 75
 
6.5%
5 61
 
5.3%
6 57
 
4.9%
7 51
 
4.4%
0 45
 
3.9%
4 44
 
3.8%
9 36
 
3.1%
Other values (2) 50
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2090
64.3%
ASCII 1158
35.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
521
45.0%
1 118
 
10.2%
2 100
 
8.6%
3 75
 
6.5%
5 61
 
5.3%
6 57
 
4.9%
7 51
 
4.4%
0 45
 
3.9%
4 44
 
3.8%
9 36
 
3.1%
Other values (2) 50
 
4.3%
Hangul
ValueCountFrequency (%)
로 378
18.1%
구 374
17.9%
시 171
8.2%
서 170
8.1%
특 167
8.0%
별 167
8.0%
울 167
8.0%
길 63
 
3.0%
동 33
 
1.6%
마 31
 
1.5%
Other values (37) 369
17.7%

소재지지번주소
Text

MISSING 

Distinct108
Distinct (%)75.5%
Missing74
Missing (%)34.1%
Memory size1.8 KiB
2024-04-06T17:49:25.029004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length18.741259
Min length8

Characters and Unicode

Total characters2680
Distinct characters35
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

Unique79 ?
Unique (%)55.2%

Sample

1st row서울특별시 구로구 가리봉동 121-30
2nd row서울특별시 구로구 가리봉동 88-18
3rd row서울특별시 구로구 가리봉동 137-4
4th row서울특별시 구로구 가리봉동 125-16
5th row서울특별시 구로구 가리봉동 121-44
ValueCountFrequency (%)
서울특별시 136
24.4%
구로구 136
24.4%
구로동 74
13.3%
개봉동 19
 
3.4%
신도림동 13
 
2.3%
오류동 11
 
2.0%
가리봉동 10
 
1.8%
궁동 7
 
1.3%
83-4 5
 
0.9%
온수동 5
 
0.9%
Other values (109) 142
25.4%
2024-04-06T17:49:26.265368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
415
15.5%
구 346
12.9%
로 210
 
7.8%
동 143
 
5.3%
서 136
 
5.1%
울 136
 
5.1%
시 136
 
5.1%
별 136
 
5.1%
특 136
 
5.1%
- 122
 
4.6%
Other values (25) 764
28.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1531
57.1%
Decimal Number 612
 
22.8%
Space Separator 415
 
15.5%
Dash Punctuation 122
 
4.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 346
22.6%
로 210
13.7%
동 143
9.3%
서 136
 
8.9%
울 136
 
8.9%
시 136
 
8.9%
별 136
 
8.9%
특 136
 
8.9%
봉 29
 
1.9%
개 19
 
1.2%
Other values (13) 104
 
6.8%
Decimal Number
ValueCountFrequency (%)
1 122
19.9%
4 84
13.7%
3 68
11.1%
2 64
10.5%
8 58
9.5%
0 55
9.0%
6 48
 
7.8%
7 39
 
6.4%
5 37
 
6.0%
9 37
 
6.0%
Space Separator
ValueCountFrequency (%)
415
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 122
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1531
57.1%
Common 1149
42.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 346
22.6%
로 210
13.7%
동 143
9.3%
서 136
 
8.9%
울 136
 
8.9%
시 136
 
8.9%
별 136
 
8.9%
특 136
 
8.9%
봉 29
 
1.9%
개 19
 
1.2%
Other values (13) 104
 
6.8%
Common
ValueCountFrequency (%)
415
36.1%
- 122
 
10.6%
1 122
 
10.6%
4 84
 
7.3%
3 68
 
5.9%
2 64
 
5.6%
8 58
 
5.0%
0 55
 
4.8%
6 48
 
4.2%
7 39
 
3.4%
Other values (2) 74
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1531
57.1%
ASCII 1149
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
415
36.1%
- 122
 
10.6%
1 122
 
10.6%
4 84
 
7.3%
3 68
 
5.9%
2 64
 
5.6%
8 58
 
5.0%
0 55
 
4.8%
6 48
 
4.2%
7 39
 
3.4%
Other values (2) 74
 
6.4%
Hangul
ValueCountFrequency (%)
구 346
22.6%
로 210
13.7%
동 143
9.3%
서 136
 
8.9%
울 136
 
8.9%
시 136
 
8.9%
별 136
 
8.9%
특 136
 
8.9%
봉 29
 
1.9%
개 19
 
1.2%
Other values (13) 104
 
6.8%

상세위치
Text

MISSING 

Distinct63
Distinct (%)86.3%
Missing144
Missing (%)66.4%
Memory size1.8 KiB
2024-04-06T17:49:27.035779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length8.6986301
Min length1

Characters and Unicode

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

Unique

Unique53 ?
Unique (%)72.6%

Sample

1st row삼호아파트 102동 앞
2nd row임괄아파트 2동 앞
3rd row현대연예인아파트 입구
4th row구로1동주민센터 앞
5th row좌
ValueCountFrequency (%)
앞 30
 
22.9%
입구 4
 
3.1%
파리바게트 3
 
2.3%
맞은편 3
 
2.3%
우 2
 
1.5%
503동 2
 
1.5%
대림12차아파트 2
 
1.5%
버스정류장 2
 
1.5%
오류동 2
 
1.5%
3번출구 2
 
1.5%
Other values (72) 79
60.3%
2024-04-06T17:49:28.136971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
58
 
9.1%
앞 31
 
4.9%
0 26
 
4.1%
1 25
 
3.9%
스 20
 
3.1%
차 17
 
2.7%
버 17
 
2.7%
구 17
 
2.7%
로 16
 
2.5%
파 15
 
2.4%
Other values (159) 393
61.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 468
73.7%
Decimal Number 90
 
14.2%
Space Separator 58
 
9.1%
Dash Punctuation 11
 
1.7%
Uppercase Letter 4
 
0.6%
Open Punctuation 2
 
0.3%
Close Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 31
 
6.6%
스 20
 
4.3%
차 17
 
3.6%
버 17
 
3.6%
구 17
 
3.6%
로 16
 
3.4%
파 15
 
3.2%
트 15
 
3.2%
아 14
 
3.0%
동 13
 
2.8%
Other values (143) 293
62.6%
Decimal Number
ValueCountFrequency (%)
0 26
28.9%
1 25
27.8%
7 11
12.2%
3 10
 
11.1%
2 9
 
10.0%
5 4
 
4.4%
9 2
 
2.2%
6 2
 
2.2%
8 1
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
A 2
50.0%
S 1
25.0%
G 1
25.0%
Space Separator
ValueCountFrequency (%)
58
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 468
73.7%
Common 163
 
25.7%
Latin 4
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 31
 
6.6%
스 20
 
4.3%
차 17
 
3.6%
버 17
 
3.6%
구 17
 
3.6%
로 16
 
3.4%
파 15
 
3.2%
트 15
 
3.2%
아 14
 
3.0%
동 13
 
2.8%
Other values (143) 293
62.6%
Common
ValueCountFrequency (%)
58
35.6%
0 26
16.0%
1 25
15.3%
7 11
 
6.7%
- 11
 
6.7%
3 10
 
6.1%
2 9
 
5.5%
5 4
 
2.5%
( 2
 
1.2%
) 2
 
1.2%
Other values (3) 5
 
3.1%
Latin
ValueCountFrequency (%)
A 2
50.0%
S 1
25.0%
G 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 468
73.7%
ASCII 167
 
26.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
58
34.7%
0 26
15.6%
1 25
15.0%
7 11
 
6.6%
- 11
 
6.6%
3 10
 
6.0%
2 9
 
5.4%
5 4
 
2.4%
( 2
 
1.2%
) 2
 
1.2%
Other values (6) 9
 
5.4%
Hangul
ValueCountFrequency (%)
앞 31
 
6.6%
스 20
 
4.3%
차 17
 
3.6%
버 17
 
3.6%
구 17
 
3.6%
로 16
 
3.4%
파 15
 
3.2%
트 15
 
3.2%
아 14
 
3.0%
동 13
 
2.8%
Other values (143) 293
62.6%

위도
Text

MISSING 

Distinct99
Distinct (%)72.3%
Missing80
Missing (%)36.9%
Memory size1.8 KiB
2024-04-06T17:49:28.811176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length10.890511
Min length7

Characters and Unicode

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

Unique

Unique66 ?
Unique (%)48.2%

Sample

1st row37.48289633
2nd row37.48387266
3rd row37.47911835
4th row37.48016123
5th row37.48217645
ValueCountFrequency (%)
37.49481403 5
 
3.5%
37.4851606 3
 
2.1%
37.48484996 3
 
2.1%
37.48353325 2
 
1.4%
37.48298724 2
 
1.4%
37.50512282 2
 
1.4%
37.4938915 2
 
1.4%
37.49671859 2
 
1.4%
37.49436222 2
 
1.4%
37.4923559 2
 
1.4%
Other values (91) 116
82.3%
2024-04-06T17:49:30.181520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 239
16.0%
4 200
13.4%
7 190
12.7%
9 146
9.8%
. 133
8.9%
5 106
7.1%
8 102
6.8%
1 94
 
6.3%
6 90
 
6.0%
2 82
 
5.5%
Other values (19) 110
7.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1321
88.5%
Other Punctuation 135
 
9.0%
Other Letter 28
 
1.9%
Space Separator 4
 
0.3%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
철 2
 
7.1%
등 2
 
7.1%
시 2
 
7.1%
택 2
 
7.1%
스 2
 
7.1%
버 2
 
7.1%
소 2
 
7.1%
역 2
 
7.1%
류 2
 
7.1%
정 2
 
7.1%
Other values (4) 8
28.6%
Decimal Number
ValueCountFrequency (%)
3 239
18.1%
4 200
15.1%
7 190
14.4%
9 146
11.1%
5 106
8.0%
8 102
7.7%
1 94
 
7.1%
6 90
 
6.8%
2 82
 
6.2%
0 72
 
5.5%
Other Punctuation
ValueCountFrequency (%)
. 133
98.5%
, 2
 
1.5%
Space Separator
ValueCountFrequency (%)
4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1464
98.1%
Hangul 28
 
1.9%

Most frequent character per script

Common
ValueCountFrequency (%)
3 239
16.3%
4 200
13.7%
7 190
13.0%
9 146
10.0%
. 133
9.1%
5 106
7.2%
8 102
7.0%
1 94
 
6.4%
6 90
 
6.1%
2 82
 
5.6%
Other values (5) 82
 
5.6%
Hangul
ValueCountFrequency (%)
철 2
 
7.1%
등 2
 
7.1%
시 2
 
7.1%
택 2
 
7.1%
스 2
 
7.1%
버 2
 
7.1%
소 2
 
7.1%
역 2
 
7.1%
류 2
 
7.1%
정 2
 
7.1%
Other values (4) 8
28.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1464
98.1%
Hangul 28
 
1.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 239
16.3%
4 200
13.7%
7 190
13.0%
9 146
10.0%
. 133
9.1%
5 106
7.2%
8 102
7.0%
1 94
 
6.4%
6 90
 
6.1%
2 82
 
5.6%
Other values (5) 82
 
5.6%
Hangul
ValueCountFrequency (%)
철 2
 
7.1%
등 2
 
7.1%
시 2
 
7.1%
택 2
 
7.1%
스 2
 
7.1%
버 2
 
7.1%
소 2
 
7.1%
역 2
 
7.1%
류 2
 
7.1%
정 2
 
7.1%
Other values (4) 8
28.6%

경도
Text

MISSING 

Distinct98
Distinct (%)71.5%
Missing80
Missing (%)36.9%
Memory size1.8 KiB
2024-04-06T17:49:30.858268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length10.79562
Min length9

Characters and Unicode

Total characters1479
Distinct characters20
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

Unique66 ?
Unique (%)48.2%

Sample

1st row126.8868871
2nd row126.8863248
3rd row126.8948323
4th row126.8886952
5th row126.8867218
ValueCountFrequency (%)
126.8886765 5
 
3.4%
사각 4
 
2.8%
쓰레기통 4
 
2.8%
일반 4
 
2.8%
126.8865766 3
 
2.1%
126.8867371 3
 
2.1%
126.8314768 2
 
1.4%
126.882191 2
 
1.4%
126.8822699 2
 
1.4%
126.8876711 2
 
1.4%
Other values (90) 114
78.6%
2024-04-06T17:49:31.952863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 256
17.3%
2 215
14.5%
6 208
14.1%
1 207
14.0%
. 133
9.0%
7 82
 
5.5%
5 77
 
5.2%
3 73
 
4.9%
9 73
 
4.9%
4 70
 
4.7%
Other values (10) 85
 
5.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1306
88.3%
Other Punctuation 133
 
9.0%
Other Letter 32
 
2.2%
Space Separator 8
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 256
19.6%
2 215
16.5%
6 208
15.9%
1 207
15.8%
7 82
 
6.3%
5 77
 
5.9%
3 73
 
5.6%
9 73
 
5.6%
4 70
 
5.4%
0 45
 
3.4%
Other Letter
ValueCountFrequency (%)
반 4
12.5%
각 4
12.5%
쓰 4
12.5%
레 4
12.5%
기 4
12.5%
통 4
12.5%
일 4
12.5%
사 4
12.5%
Other Punctuation
ValueCountFrequency (%)
. 133
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1447
97.8%
Hangul 32
 
2.2%

Most frequent character per script

Common
ValueCountFrequency (%)
8 256
17.7%
2 215
14.9%
6 208
14.4%
1 207
14.3%
. 133
9.2%
7 82
 
5.7%
5 77
 
5.3%
3 73
 
5.0%
9 73
 
5.0%
4 70
 
4.8%
Other values (2) 53
 
3.7%
Hangul
ValueCountFrequency (%)
반 4
12.5%
각 4
12.5%
쓰 4
12.5%
레 4
12.5%
기 4
12.5%
통 4
12.5%
일 4
12.5%
사 4
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1447
97.8%
Hangul 32
 
2.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 256
17.7%
2 215
14.9%
6 208
14.4%
1 207
14.3%
. 133
9.2%
7 82
 
5.7%
5 77
 
5.3%
3 73
 
5.0%
9 73
 
5.0%
4 70
 
4.8%
Other values (2) 53
 
3.7%
Hangul
ValueCountFrequency (%)
반 4
12.5%
각 4
12.5%
쓰 4
12.5%
레 4
12.5%
기 4
12.5%
통 4
12.5%
일 4
12.5%
사 4
12.5%

설치장소유형
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
도로변(횡단보도 포함)
133 
정류소(버스, 택시 등)
63 
상가지역
14 
지하철역 입구
 
3
광장, 공원 등 다중집합장소
 
3

Length

Max length15
Median length12
Mean length11.723502
Min length4

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row도로변(횡단보도 포함)
2nd row정류소(버스, 택시 등)
3rd row정류소(버스, 택시 등)
4th row정류소(버스, 택시 등)
5th row도로변(횡단보도 포함)

Common Values

ValueCountFrequency (%)
도로변(횡단보도 포함) 133
61.3%
정류소(버스, 택시 등) 63
29.0%
상가지역 14
 
6.5%
지하철역 입구 3
 
1.4%
광장, 공원 등 다중집합장소 3
 
1.4%
지하쳘역 입구 1
 
0.5%

Length

2024-04-06T17:49:32.338794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:49:32.694386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로변(횡단보도 133
27.2%
포함 133
27.2%
등 66
13.5%
정류소(버스 63
12.9%
택시 63
12.9%
상가지역 14
 
2.9%
입구 4
 
0.8%
지하철역 3
 
0.6%
광장 3
 
0.6%
공원 3
 
0.6%
Other values (2) 4
 
0.8%

수거쓰레기종류
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
일반쓰레기
110 
재활용
92 
담배꽁초
13 
<NA>
 
2

Length

Max length5
Median length5
Mean length4.0829493
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반쓰레기
2nd row일반쓰레기
3rd row일반쓰레기
4th row재활용
5th row일반쓰레기

Common Values

ValueCountFrequency (%)
일반쓰레기 110
50.7%
재활용 92
42.4%
담배꽁초 13
 
6.0%
<NA> 2
 
0.9%

Length

2024-04-06T17:49:33.084018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:49:33.438826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반쓰레기 110
50.7%
재활용 92
42.4%
담배꽁초 13
 
6.0%
na 2
 
0.9%

쓰레기통형태
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
일반 사각 쓰레기통
193 
담배꽁초 수거함
 
13
항아리형 쓰레기통
 
8
IoT태양광 압축 쓰레기통
 
3

Length

Max length14
Median length10
Mean length9.8986175
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반 사각 쓰레기통
2nd row일반 사각 쓰레기통
3rd row일반 사각 쓰레기통
4th row일반 사각 쓰레기통
5th row일반 사각 쓰레기통

Common Values

ValueCountFrequency (%)
일반 사각 쓰레기통 193
88.9%
담배꽁초 수거함 13
 
6.0%
항아리형 쓰레기통 8
 
3.7%
IoT태양광 압축 쓰레기통 3
 
1.4%

Length

2024-04-06T17:49:33.771836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:49:34.142472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
쓰레기통 204
32.4%
일반 193
30.6%
사각 193
30.6%
담배꽁초 13
 
2.1%
수거함 13
 
2.1%
항아리형 8
 
1.3%
iot태양광 3
 
0.5%
압축 3
 
0.5%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
구로구청 청소행정과
217 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row구로구청 청소행정과
2nd row구로구청 청소행정과
3rd row구로구청 청소행정과
4th row구로구청 청소행정과
5th row구로구청 청소행정과

Common Values

ValueCountFrequency (%)
구로구청 청소행정과 217
100.0%

Length

2024-04-06T17:49:34.489316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:49:34.796153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구로구청 217
50.0%
청소행정과 217
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
02-860-2918
217 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-860-2918
2nd row02-860-2918
3rd row02-860-2918
4th row02-860-2918
5th row02-860-2918

Common Values

ValueCountFrequency (%)
02-860-2918 217
100.0%

Length

2024-04-06T17:49:35.076872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:49:35.373652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-860-2918 217
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2024-03-25 00:00:00
Maximum2024-03-25 00:00:00
2024-04-06T17:49:35.593216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:49:35.878392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-04-06T17:49:36.135123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소재지도로명상세위치위도경도설치장소유형수거쓰레기종류쓰레기통형태
소재지도로명1.0000.9840.9980.9970.8340.8980.780
상세위치0.9841.0001.0001.0000.9920.8280.872
위도0.9981.0001.0001.0000.9990.0000.000
경도0.9971.0001.0001.0000.9670.0000.000
설치장소유형0.8340.9920.9990.9671.0000.6960.711
수거쓰레기종류0.8980.8280.0000.0000.6961.0000.681
쓰레기통형태0.7800.8720.0000.0000.7110.6811.000
2024-04-06T17:49:36.558490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수거쓰레기종류쓰레기통형태설치장소유형
수거쓰레기종류1.0000.7120.674
쓰레기통형태0.7121.0000.540
설치장소유형0.6740.5401.000
2024-04-06T17:49:36.825532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치장소유형수거쓰레기종류쓰레기통형태
설치장소유형1.0000.6740.540
수거쓰레기종류0.6741.0000.712
쓰레기통형태0.5400.7121.000

Missing values

2024-04-06T17:49:18.914693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:49:19.402282image/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-04-06T17:49:20.487536image/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

소재지도로명소재지도로명주소소재지지번주소상세위치위도경도설치장소유형수거쓰레기종류쓰레기통형태관리기관명관리기관전화번호데이터기준일자
0구로동로서울특별시 구로구 구로동로 13서울특별시 구로구 가리봉동 121-30<NA>37.48289633126.8868871도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
1구로동로서울특별시 구로구 구로동로 25서울특별시 구로구 가리봉동 88-18<NA>37.48387266126.8863248정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
2남부순환로서울특별시 구로구 남부순환로 1295서울특별시 구로구 가리봉동 137-4<NA>37.47911835126.8948323정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
3남부순환로105길서울특별시 구로구 남부순환로105길 76서울특별시 구로구 가리봉동 125-16<NA>37.48016123126.8886952정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
4남부순환로105길서울특별시 구로구 남부순환로105길 134서울특별시 구로구 가리봉동 121-44<NA>37.48217645126.8867218도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
5남부순환로105길서울특별시 구로구 남부순환로105길 134서울특별시 구로구 가리봉동 121-44<NA>37.48217645126.8867218도로변(횡단보도 포함)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
6디지털로서울특별시 구로구 디지털로 231서울특별시 구로구 가리봉동 131-11<NA>37.48076327126.891283도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
7디지털로27길서울특별시 구로구 디지털로27길 135서울특별시 구로구 가리봉동 89-99<NA>37.48484996126.8865766도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
8디지털로27길서울특별시 구로구 디지털로27길 135서울특별시 구로구 가리봉동 89-99<NA>37.48484996126.8865766도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
9디지털로27길서울특별시 구로구 디지털로27길 135서울특별시 구로구 가리봉동 89-99<NA>37.48484996126.8865766도로변(횡단보도 포함)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
소재지도로명소재지도로명주소소재지지번주소상세위치위도경도설치장소유형수거쓰레기종류쓰레기통형태관리기관명관리기관전화번호데이터기준일자
207구로동로구로동로 79-1<NA><NA><NA><NA>정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
208구로동로구로동로 82<NA>대한안경콘택트 앞<NA><NA>정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
209구일로4길구일로4길 22<NA>주공A 119동 앞<NA><NA>정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
210남부순환로97길남부순환로97길<NA><NA><NA><NA>정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
211디지털로31길디지털로31길 90<NA><NA><NA><NA>정류소(버스, 택시 등)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
212경인로<NA><NA>버스전용차로-17008<NA><NA>정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
213경인로<NA><NA>버스전용차로-17009<NA><NA>정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
214경인로<NA><NA>버스전용차로-17010<NA><NA>정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
215경인로<NA><NA>버스전용차로-17011<NA><NA>정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25
216경인로<NA><NA>버스전용차로-17012<NA><NA>정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-25

Duplicate rows

Most frequently occurring

소재지도로명소재지도로명주소소재지지번주소상세위치위도경도설치장소유형수거쓰레기종류쓰레기통형태관리기관명관리기관전화번호데이터기준일자# duplicates
1가마산로서울특별시 구로구 가마산로 250서울특별시 구로구 구로동 83-4<NA>37.49481403126.8886765도로변(횡단보도 포함)일반쓰레기항아리형 쓰레기통구로구청 청소행정과02-860-29182024-03-254
0가마산로서울특별시 구로구 가마산로 218서울특별시 구로구 구로동 80-24<NA>37.49321551126.8851411정류소(버스, 택시 등)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
2경인로67길서울특별시 구로구 신도림동 329-2<NA>아이파크아파트 맞은편<NA><NA>도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
3구로동로서울특별시 구로구 구로동로 203서울특별시 구로구 구로동 481-7<NA>37.49671859126.8822699도로변(횡단보도 포함)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
4구로중앙로서울특별시 구로구 구로중앙로 135-6서울특별시 구로구 구로동 500-27<NA>37.49995073126.8828691도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
5구로중앙로서울특별시 구로구 구로중앙로28길 66서울특별시 구로구 구로동 109-4<NA>37.50010311126.8893378도로변(횡단보도 포함)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
6도림로서울특별시 구로구 도림로 6서울특별시 구로구 구로동 801-51<NA>37.4851606126.8867371도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
7디지털로27길서울특별시 구로구 디지털로27길 135서울특별시 구로구 가리봉동 89-99<NA>37.48484996126.8865766도로변(횡단보도 포함)일반쓰레기일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252
8신도림로서울특별시 구로구 신도림로 40서울특별시 구로구 신도림동 390-68<NA>37.50777999126.8805952도로변(횡단보도 포함)재활용일반 사각 쓰레기통구로구청 청소행정과02-860-29182024-03-252