Overview

Dataset statistics

Number of variables4
Number of observations400
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.6 KiB
Average record size in memory32.3 B

Variable types

Text2
Categorical2

Dataset

Description광주광역시 서구에 설치 되어있는 의류수거함에 대한 정보로 수거함관리번호, 수거함 도로명주소, 수거함이 설치되어있는 행정동, 수거함 관리업체에 대한 정보를 포함하고 있습니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15127222/fileData.do

Alerts

관리업체 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 관리업체High correlation
관리번호 has unique valuesUnique

Reproduction

Analysis started2024-03-30 08:44:20.763955
Analysis finished2024-03-30 08:44:21.629605
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct400
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-03-30T08:44:22.304006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

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

Unique

Unique400 ?
Unique (%)100.0%

Sample

1st row서구-0001
2nd row서구-0002
3rd row서구-0003
4th row서구-0004
5th row서구-0005
ValueCountFrequency (%)
서구-0001 1
 
0.2%
서구-0271 1
 
0.2%
서구-0282 1
 
0.2%
서구-0281 1
 
0.2%
서구-0280 1
 
0.2%
서구-0279 1
 
0.2%
서구-0278 1
 
0.2%
서구-0277 1
 
0.2%
서구-0276 1
 
0.2%
서구-0275 1
 
0.2%
Other values (390) 390
97.5%
2024-03-30T08:44:23.639689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 579
20.7%
서 400
14.3%
구 400
14.3%
- 400
14.3%
1 180
 
6.4%
3 180
 
6.4%
2 180
 
6.4%
4 81
 
2.9%
7 80
 
2.9%
5 80
 
2.9%
Other values (3) 240
8.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1600
57.1%
Other Letter 800
28.6%
Dash Punctuation 400
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 579
36.2%
1 180
 
11.2%
3 180
 
11.2%
2 180
 
11.2%
4 81
 
5.1%
7 80
 
5.0%
5 80
 
5.0%
6 80
 
5.0%
8 80
 
5.0%
9 80
 
5.0%
Other Letter
ValueCountFrequency (%)
서 400
50.0%
구 400
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 400
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2000
71.4%
Hangul 800
 
28.6%

Most frequent character per script

Common
ValueCountFrequency (%)
0 579
28.9%
- 400
20.0%
1 180
 
9.0%
3 180
 
9.0%
2 180
 
9.0%
4 81
 
4.0%
7 80
 
4.0%
5 80
 
4.0%
6 80
 
4.0%
8 80
 
4.0%
Hangul
ValueCountFrequency (%)
서 400
50.0%
구 400
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2000
71.4%
Hangul 800
 
28.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 579
28.9%
- 400
20.0%
1 180
 
9.0%
3 180
 
9.0%
2 180
 
9.0%
4 81
 
4.0%
7 80
 
4.0%
5 80
 
4.0%
6 80
 
4.0%
8 80
 
4.0%
Hangul
ValueCountFrequency (%)
서 400
50.0%
구 400
50.0%

행정동
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
상무2동
56 
풍암동
46 
상무1동
46 
화정1동
33 
농성1동
29 
Other values (13)
190 

Length

Max length4
Median length4
Mean length3.6725
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양동
2nd row양동
3rd row양동
4th row양동
5th row양3동

Common Values

ValueCountFrequency (%)
상무2동 56
14.0%
풍암동 46
11.5%
상무1동 46
11.5%
화정1동 33
8.2%
농성1동 29
 
7.2%
금호2동 27
 
6.8%
화정3동 25
 
6.2%
농성2동 23
 
5.8%
광천동 19
 
4.8%
서창동 16
 
4.0%
Other values (8) 80
20.0%

Length

2024-03-30T08:44:24.217762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
상무2동 56
14.0%
상무1동 46
11.5%
풍암동 46
11.5%
화정1동 33
8.2%
농성1동 29
 
7.2%
금호2동 27
 
6.8%
화정3동 25
 
6.2%
농성2동 23
 
5.8%
광천동 19
 
4.8%
유덕동 16
 
4.0%
Other values (8) 80
20.0%

도로명주소
Text

Distinct385
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-03-30T08:44:24.898480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length20.0725
Min length6

Characters and Unicode

Total characters8029
Distinct characters101
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

Unique377 ?
Unique (%)94.2%

Sample

1st row광주광역시 서구 양동로17번길 17
2nd row광주광역시 서구 천변좌로208번길 14
3rd row광주광역시 서구 경열로143번길 20
4th row광주광역시 서구 천변좌로222번길 18-1
5th row광주광역시 서구 양동로25번길 9
ValueCountFrequency (%)
서구 392
24.9%
광주광역시 392
24.9%
9 18
 
1.1%
12 13
 
0.8%
16 12
 
0.8%
7 10
 
0.6%
11 10
 
0.6%
8 9
 
0.6%
데이터미수집 8
 
0.5%
20 8
 
0.5%
Other values (413) 704
44.7%
2024-03-30T08:44:26.172949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1195
14.9%
광 794
 
9.9%
1 432
 
5.4%
주 399
 
5.0%
서 397
 
4.9%
구 396
 
4.9%
시 394
 
4.9%
역 392
 
4.9%
로 362
 
4.5%
길 353
 
4.4%
Other values (91) 2915
36.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4950
61.7%
Decimal Number 1735
 
21.6%
Space Separator 1195
 
14.9%
Dash Punctuation 149
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 794
16.0%
주 399
 
8.1%
서 397
 
8.0%
구 396
 
8.0%
시 394
 
8.0%
역 392
 
7.9%
로 362
 
7.3%
길 353
 
7.1%
번 324
 
6.5%
화 104
 
2.1%
Other values (79) 1035
20.9%
Decimal Number
ValueCountFrequency (%)
1 432
24.9%
2 283
16.3%
4 178
10.3%
3 175
10.1%
5 137
 
7.9%
8 120
 
6.9%
9 116
 
6.7%
0 110
 
6.3%
6 96
 
5.5%
7 88
 
5.1%
Space Separator
ValueCountFrequency (%)
1195
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 149
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4950
61.7%
Common 3079
38.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 794
16.0%
주 399
 
8.1%
서 397
 
8.0%
구 396
 
8.0%
시 394
 
8.0%
역 392
 
7.9%
로 362
 
7.3%
길 353
 
7.1%
번 324
 
6.5%
화 104
 
2.1%
Other values (79) 1035
20.9%
Common
ValueCountFrequency (%)
1195
38.8%
1 432
 
14.0%
2 283
 
9.2%
4 178
 
5.8%
3 175
 
5.7%
- 149
 
4.8%
5 137
 
4.4%
8 120
 
3.9%
9 116
 
3.8%
0 110
 
3.6%
Other values (2) 184
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4950
61.7%
ASCII 3079
38.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1195
38.8%
1 432
 
14.0%
2 283
 
9.2%
4 178
 
5.8%
3 175
 
5.7%
- 149
 
4.8%
5 137
 
4.4%
8 120
 
3.9%
9 116
 
3.8%
0 110
 
3.6%
Other values (2) 184
 
6.0%
Hangul
ValueCountFrequency (%)
광 794
16.0%
주 399
 
8.1%
서 397
 
8.0%
구 396
 
8.0%
시 394
 
8.0%
역 392
 
7.9%
로 362
 
7.3%
길 353
 
7.1%
번 324
 
6.5%
화 104
 
2.1%
Other values (79) 1035
20.9%

관리업체
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
위너스무역
222 
원무역
163 
케이컴퍼니
 
15

Length

Max length5
Median length5
Mean length4.185
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원무역
2nd row원무역
3rd row원무역
4th row원무역
5th row원무역

Common Values

ValueCountFrequency (%)
위너스무역 222
55.5%
원무역 163
40.8%
케이컴퍼니 15
 
3.8%

Length

2024-03-30T08:44:26.676532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T08:44:27.110583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
위너스무역 222
55.5%
원무역 163
40.8%
케이컴퍼니 15
 
3.8%

Correlations

2024-03-30T08:44:27.362444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동관리업체
행정동1.0000.999
관리업체0.9991.000
2024-03-30T08:44:27.587654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리업체행정동
관리업체1.0000.953
행정동0.9531.000
2024-03-30T08:44:27.870980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동관리업체
행정동1.0000.953
관리업체0.9531.000

Missing values

2024-03-30T08:44:21.183661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-30T08:44:21.449499image/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서구-0001양동광주광역시 서구 양동로17번길 17원무역
1서구-0002양동광주광역시 서구 천변좌로208번길 14원무역
2서구-0003양동광주광역시 서구 경열로143번길 20원무역
3서구-0004양동광주광역시 서구 천변좌로222번길 18-1원무역
4서구-0005양3동광주광역시 서구 양동로25번길 9원무역
5서구-0164양3동광주광역시 서구 천변좌로140번길 20위너스무역
6서구-0165양3동광주광역시 서구 천변좌로130번길 12위너스무역
7서구-0166양3동광주광역시 서구 천변좌로130번길 2위너스무역
8서구-0167양3동광주광역시 서구 천변좌로140번길 5위너스무역
9서구-0168양3동광주광역시 서구 발산로45번길 13위너스무역
관리번호행정동도로명주소관리업체
390서구-0383풍암동광주광역시 서구 풍암중앙로 84위너스무역
391서구-0384풍암동광주광역시 서구 풍암중앙로86번길 30위너스무역
392서구-0385풍암동광주광역시 서구 풍암중앙로86번길 30위너스무역
393서구-0157동천동광주광역시 서구 동천로10번길 22원무역
394서구-0158동천동광주광역시 서구 동천로10번길 35원무역
395서구-0159동천동광주광역시 서구 하남대로734번길 11원무역
396서구-0160동천동광주광역시 서구 동림2지구길 50원무역
397서구-0161동천동광주광역시 서구 동림2지구길 40원무역
398서구-0162동천동광주광역시 서구 동림2지구길 32원무역
399서구-0163동천동광주광역시 서구 동림2지구길 16원무역