Overview

Dataset statistics

Number of variables5
Number of observations442
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.8 KiB
Average record size in memory41.3 B

Variable types

Numeric1
Categorical2
Text1
DateTime1

Dataset

Description파일 다운로드
Author양천구
URLhttps://data.seoul.go.kr/dataList/OA-22057/F/1/datasetView.do

Alerts

수거함종류 has constant value ""Constant
데이터기준일자 has constant value ""Constant
번호 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 번호High correlation
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-11 05:37:05.131318
Analysis finished2023-12-11 05:37:05.815797
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct442
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean221.5
Minimum1
Maximum442
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2023-12-11T14:37:05.909231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile23.05
Q1111.25
median221.5
Q3331.75
95-th percentile419.95
Maximum442
Range441
Interquartile range (IQR)220.5

Descriptive statistics

Standard deviation127.73867
Coefficient of variation (CV)0.57669826
Kurtosis-1.2
Mean221.5
Median Absolute Deviation (MAD)110.5
Skewness0
Sum97903
Variance16317.167
MonotonicityStrictly increasing
2023-12-11T14:37:06.085637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
292 1
 
0.2%
303 1
 
0.2%
302 1
 
0.2%
301 1
 
0.2%
300 1
 
0.2%
299 1
 
0.2%
298 1
 
0.2%
297 1
 
0.2%
296 1
 
0.2%
Other values (432) 432
97.7%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
442 1
0.2%
441 1
0.2%
440 1
0.2%
439 1
0.2%
438 1
0.2%
437 1
0.2%
436 1
0.2%
435 1
0.2%
434 1
0.2%
433 1
0.2%

행정동
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
신정3동
83 
목1동
43 
목5동
40 
신정7동
35 
신월2동
30 
Other values (13)
211 

Length

Max length4
Median length4
Mean length3.6651584
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
신정3동 83
18.8%
목1동 43
9.7%
목5동 40
9.0%
신정7동 35
7.9%
신월2동 30
 
6.8%
목4동 29
 
6.6%
신월4동 29
 
6.6%
목2동 25
 
5.7%
신정2동 22
 
5.0%
신정6동 19
 
4.3%
Other values (8) 87
19.7%

Length

2023-12-11T14:37:06.237215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
신정3동 83
18.8%
목1동 43
9.7%
목5동 40
9.0%
신정7동 35
7.9%
신월2동 30
 
6.8%
목4동 29
 
6.6%
신월4동 29
 
6.6%
목2동 25
 
5.7%
신정2동 22
 
5.0%
신정6동 19
 
4.3%
Other values (8) 87
19.7%

수거함 설치 위치
Text

Distinct326
Distinct (%)73.8%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-11T14:37:06.706382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length18.045249
Min length16

Characters and Unicode

Total characters7976
Distinct characters25
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

Unique280 ?
Unique (%)63.3%

Sample

1st row서울특별시 양천구 목동 404-13
2nd row서울특별시 양천구 목동 404-3
3rd row서울특별시 양천구 목동 405
4th row서울특별시 양천구 목동 405-208
5th row서울특별시 양천구 목동 405-472
ValueCountFrequency (%)
서울특별시 442
25.0%
양천구 442
25.0%
신정동 184
10.4%
목동 148
 
8.4%
신월동 110
 
6.2%
1175-28 16
 
0.9%
1063 9
 
0.5%
1323 8
 
0.5%
929 7
 
0.4%
1322 7
 
0.4%
Other values (321) 395
22.3%
2023-12-11T14:37:07.317938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1326
16.6%
서 442
 
5.5%
동 442
 
5.5%
특 442
 
5.5%
별 442
 
5.5%
시 442
 
5.5%
양 442
 
5.5%
천 442
 
5.5%
구 442
 
5.5%
울 442
 
5.5%
Other values (15) 2672
33.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4714
59.1%
Decimal Number 1746
 
21.9%
Space Separator 1326
 
16.6%
Dash Punctuation 190
 
2.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 442
9.4%
동 442
9.4%
특 442
9.4%
별 442
9.4%
시 442
9.4%
양 442
9.4%
천 442
9.4%
구 442
9.4%
울 442
9.4%
신 294
6.2%
Other values (3) 442
9.4%
Decimal Number
ValueCountFrequency (%)
1 393
22.5%
3 244
14.0%
2 235
13.5%
9 178
10.2%
0 160
9.2%
7 152
 
8.7%
5 121
 
6.9%
4 93
 
5.3%
8 86
 
4.9%
6 84
 
4.8%
Space Separator
ValueCountFrequency (%)
1326
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 190
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4714
59.1%
Common 3262
40.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 442
9.4%
동 442
9.4%
특 442
9.4%
별 442
9.4%
시 442
9.4%
양 442
9.4%
천 442
9.4%
구 442
9.4%
울 442
9.4%
신 294
6.2%
Other values (3) 442
9.4%
Common
ValueCountFrequency (%)
1326
40.6%
1 393
 
12.0%
3 244
 
7.5%
2 235
 
7.2%
- 190
 
5.8%
9 178
 
5.5%
0 160
 
4.9%
7 152
 
4.7%
5 121
 
3.7%
4 93
 
2.9%
Other values (2) 170
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4714
59.1%
ASCII 3262
40.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1326
40.6%
1 393
 
12.0%
3 244
 
7.5%
2 235
 
7.2%
- 190
 
5.8%
9 178
 
5.5%
0 160
 
4.9%
7 152
 
4.7%
5 121
 
3.7%
4 93
 
2.9%
Other values (2) 170
 
5.2%
Hangul
ValueCountFrequency (%)
서 442
9.4%
동 442
9.4%
특 442
9.4%
별 442
9.4%
시 442
9.4%
양 442
9.4%
천 442
9.4%
구 442
9.4%
울 442
9.4%
신 294
6.2%
Other values (3) 442
9.4%

수거함종류
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
폐형광등폐건전지 통합수거함
442 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐형광등폐건전지 통합수거함
2nd row폐형광등폐건전지 통합수거함
3rd row폐형광등폐건전지 통합수거함
4th row폐형광등폐건전지 통합수거함
5th row폐형광등폐건전지 통합수거함

Common Values

ValueCountFrequency (%)
폐형광등폐건전지 통합수거함 442
100.0%

Length

2023-12-11T14:37:07.516820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T14:37:07.655552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐형광등폐건전지 442
50.0%
통합수거함 442
50.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2022-09-08 00:00:00
Maximum2022-09-08 00:00:00
2023-12-11T14:37:07.766453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:37:07.881315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T14:37:05.258883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T14:37:07.975216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호행정동
번호1.0000.910
행정동0.9101.000
2023-12-11T14:37:08.078673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호행정동
번호1.0000.655
행정동0.6551.000

Missing values

2023-12-11T14:37:05.643582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T14:37:05.765816image/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

번호행정동수거함 설치 위치수거함종류데이터기준일자
01목1동서울특별시 양천구 목동 404-13폐형광등폐건전지 통합수거함2022-09-08
12목1동서울특별시 양천구 목동 404-3폐형광등폐건전지 통합수거함2022-09-08
23목1동서울특별시 양천구 목동 405폐형광등폐건전지 통합수거함2022-09-08
34목1동서울특별시 양천구 목동 405-208폐형광등폐건전지 통합수거함2022-09-08
45목1동서울특별시 양천구 목동 405-472폐형광등폐건전지 통합수거함2022-09-08
56목1동서울특별시 양천구 목동 808-5폐형광등폐건전지 통합수거함2022-09-08
67목1동서울특별시 양천구 목동 808-9폐형광등폐건전지 통합수거함2022-09-08
78목1동서울특별시 양천구 목동 914폐형광등폐건전지 통합수거함2022-09-08
89목1동서울특별시 양천구 목동 916폐형광등폐건전지 통합수거함2022-09-08
910목1동서울특별시 양천구 목동 916폐형광등폐건전지 통합수거함2022-09-08
번호행정동수거함 설치 위치수거함종류데이터기준일자
432433신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
433434신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
434435신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
435436신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
436437신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
437438신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
438439신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
439440신정3동서울특별시 양천구 신정동 1175-28폐형광등폐건전지 통합수거함2022-09-08
440441신정3동서울특별시 양천구 신정동 1218-1폐형광등폐건전지 통합수거함2022-09-08
441442신정6동서울특별시 양천구 신정동 330-3폐형광등폐건전지 통합수거함2022-09-08