Overview

Dataset statistics

Number of variables5
Number of observations654
Missing cells613
Missing cells (%)18.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.3 KiB
Average record size in memory41.2 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Description경기도 안양시 관내에 있는 의류수거함 위치 데이터 ( 연번, 구분, 주소, 행정동, 비고) 입니다. 2024년 전수조사를 통해 현행화될 예정입니다.
Author경기도 안양시
URLhttps://www.data.go.kr/data/15127070/fileData.do

Alerts

구분 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
비고 has 613 (93.7%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-23 05:20:01.762297
Analysis finished2024-03-23 05:20:03.590898
Duration1.83 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct654
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean327.5
Minimum1
Maximum654
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.9 KiB
2024-03-23T05:20:03.965808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile33.65
Q1164.25
median327.5
Q3490.75
95-th percentile621.35
Maximum654
Range653
Interquartile range (IQR)326.5

Descriptive statistics

Standard deviation188.93782
Coefficient of variation (CV)0.57690938
Kurtosis-1.2
Mean327.5
Median Absolute Deviation (MAD)163.5
Skewness0
Sum214185
Variance35697.5
MonotonicityStrictly increasing
2024-03-23T05:20:04.730283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
451 1
 
0.2%
433 1
 
0.2%
434 1
 
0.2%
435 1
 
0.2%
436 1
 
0.2%
437 1
 
0.2%
438 1
 
0.2%
439 1
 
0.2%
440 1
 
0.2%
Other values (644) 644
98.5%
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 (%)
654 1
0.2%
653 1
0.2%
652 1
0.2%
651 1
0.2%
650 1
0.2%
649 1
0.2%
648 1
0.2%
647 1
0.2%
646 1
0.2%
645 1
0.2%

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.2 KiB
만안구
389 
동안구
265 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row만안구
2nd row만안구
3rd row만안구
4th row만안구
5th row만안구

Common Values

ValueCountFrequency (%)
만안구 389
59.5%
동안구 265
40.5%

Length

2024-03-23T05:20:05.463542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T05:20:05.855341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
만안구 389
59.5%
동안구 265
40.5%

주소
Text

Distinct631
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size5.2 KiB
2024-03-23T05:20:06.706234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length26
Mean length22.157492
Min length16

Characters and Unicode

Total characters14491
Distinct characters88
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

Unique614 ?
Unique (%)93.9%

Sample

1st row경기도 안양시 만안구 경수대로1161
2nd row경기도 안양시 만안구 경수대로1167-5
3rd row경기도 안양시 만안구 경수대로1185-6
4th row경기도 안양시 만안구 경수대로1196번길28
5th row경기도 안양시 만안구 경수대로1196번길28
ValueCountFrequency (%)
경기도 654
24.2%
안양시 654
24.2%
만안구 389
14.4%
동안구 265
 
9.8%
경수대로 12
 
0.4%
갈산로 12
 
0.4%
시민대로 8
 
0.3%
안양로468번길25-18 5
 
0.2%
전파로 5
 
0.2%
박달우회로 4
 
0.1%
Other values (654) 691
25.6%
2024-03-23T05:20:08.242390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2046
 
14.1%
안 1446
 
10.0%
양 760
 
5.2%
경 686
 
4.7%
시 662
 
4.6%
구 654
 
4.5%
기 654
 
4.5%
도 654
 
4.5%
로 652
 
4.5%
1 598
 
4.1%
Other values (78) 5679
39.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9217
63.6%
Decimal Number 3013
 
20.8%
Space Separator 2046
 
14.1%
Dash Punctuation 213
 
1.5%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 1446
15.7%
양 760
 
8.2%
경 686
 
7.4%
시 662
 
7.2%
구 654
 
7.1%
기 654
 
7.1%
도 654
 
7.1%
로 652
 
7.1%
길 520
 
5.6%
번 519
 
5.6%
Other values (64) 2010
21.8%
Decimal Number
ValueCountFrequency (%)
1 598
19.8%
2 417
13.8%
3 369
12.2%
4 329
10.9%
5 248
8.2%
6 237
 
7.9%
9 222
 
7.4%
7 214
 
7.1%
0 206
 
6.8%
8 173
 
5.7%
Space Separator
ValueCountFrequency (%)
2046
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 213
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9217
63.6%
Common 5274
36.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 1446
15.7%
양 760
 
8.2%
경 686
 
7.4%
시 662
 
7.2%
구 654
 
7.1%
기 654
 
7.1%
도 654
 
7.1%
로 652
 
7.1%
길 520
 
5.6%
번 519
 
5.6%
Other values (64) 2010
21.8%
Common
ValueCountFrequency (%)
2046
38.8%
1 598
 
11.3%
2 417
 
7.9%
3 369
 
7.0%
4 329
 
6.2%
5 248
 
4.7%
6 237
 
4.5%
9 222
 
4.2%
7 214
 
4.1%
- 213
 
4.0%
Other values (4) 381
 
7.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9217
63.6%
ASCII 5274
36.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2046
38.8%
1 598
 
11.3%
2 417
 
7.9%
3 369
 
7.0%
4 329
 
6.2%
5 248
 
4.7%
6 237
 
4.5%
9 222
 
4.2%
7 214
 
4.1%
- 213
 
4.0%
Other values (4) 381
 
7.2%
Hangul
ValueCountFrequency (%)
안 1446
15.7%
양 760
 
8.2%
경 686
 
7.4%
시 662
 
7.2%
구 654
 
7.1%
기 654
 
7.1%
도 654
 
7.1%
로 652
 
7.1%
길 520
 
5.6%
번 519
 
5.6%
Other values (64) 2010
21.8%

행정동
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size5.2 KiB
관양동
111 
석수2동
68 
안양8동
56 
안양9동
54 
비산3동
52 
Other values (20)
313 

Length

Max length4
Median length4
Mean length3.7155963
Min length3

Unique

Unique1 ?
Unique (%)0.2%

Sample

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

Common Values

ValueCountFrequency (%)
관양동 111
17.0%
석수2동 68
10.4%
안양8동 56
8.6%
안양9동 54
 
8.3%
비산3동 52
 
8.0%
안양6동 43
 
6.6%
충훈동 39
 
6.0%
안양2동 32
 
4.9%
안양3동 31
 
4.7%
인덕원동 29
 
4.4%
Other values (15) 139
21.3%

Length

2024-03-23T05:20:08.837925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
관양동 111
17.0%
석수2동 68
10.4%
안양8동 56
8.6%
안양9동 54
 
8.3%
비산3동 52
 
8.0%
안양6동 43
 
6.6%
충훈동 39
 
6.0%
안양2동 32
 
4.9%
안양3동 31
 
4.7%
인덕원동 29
 
4.4%
Other values (15) 139
21.3%

비고
Text

MISSING 

Distinct36
Distinct (%)87.8%
Missing613
Missing (%)93.7%
Memory size5.2 KiB
2024-03-23T05:20:09.554728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length6.9756098
Min length3

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)80.5%

Sample

1st row성원연립
2nd row성원연립
3rd row미래프라자 뒤쪽
4th row한마음선원 큰길
5th row호암파크빌
ValueCountFrequency (%)
우주타운 5
 
7.4%
석수아파트 4
 
5.9%
주변 4
 
5.9%
앞 2
 
2.9%
후문 2
 
2.9%
옆 2
 
2.9%
성원연립 2
 
2.9%
동신벨로스아파트 2
 
2.9%
베아르시 1
 
1.5%
삼성산경로당 1
 
1.5%
Other values (43) 43
63.2%
2024-03-23T05:20:10.875990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
 
9.4%
아 14
 
4.9%
파 13
 
4.5%
트 13
 
4.5%
동 11
 
3.8%
주 9
 
3.1%
스 9
 
3.1%
1 7
 
2.4%
타 7
 
2.4%
운 6
 
2.1%
Other values (100) 170
59.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 237
82.9%
Space Separator 27
 
9.4%
Decimal Number 20
 
7.0%
Dash Punctuation 1
 
0.3%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 14
 
5.9%
파 13
 
5.5%
트 13
 
5.5%
동 11
 
4.6%
주 9
 
3.8%
스 9
 
3.8%
타 7
 
3.0%
운 6
 
2.5%
우 5
 
2.1%
로 5
 
2.1%
Other values (89) 145
61.2%
Decimal Number
ValueCountFrequency (%)
1 7
35.0%
4 3
15.0%
0 3
15.0%
3 2
 
10.0%
5 2
 
10.0%
8 1
 
5.0%
7 1
 
5.0%
2 1
 
5.0%
Space Separator
ValueCountFrequency (%)
27
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 237
82.9%
Common 49
 
17.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 14
 
5.9%
파 13
 
5.5%
트 13
 
5.5%
동 11
 
4.6%
주 9
 
3.8%
스 9
 
3.8%
타 7
 
3.0%
운 6
 
2.5%
우 5
 
2.1%
로 5
 
2.1%
Other values (89) 145
61.2%
Common
ValueCountFrequency (%)
27
55.1%
1 7
 
14.3%
4 3
 
6.1%
0 3
 
6.1%
3 2
 
4.1%
5 2
 
4.1%
- 1
 
2.0%
8 1
 
2.0%
7 1
 
2.0%
2 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 237
82.9%
ASCII 49
 
17.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
27
55.1%
1 7
 
14.3%
4 3
 
6.1%
0 3
 
6.1%
3 2
 
4.1%
5 2
 
4.1%
- 1
 
2.0%
8 1
 
2.0%
7 1
 
2.0%
2 1
 
2.0%
Hangul
ValueCountFrequency (%)
아 14
 
5.9%
파 13
 
5.5%
트 13
 
5.5%
동 11
 
4.6%
주 9
 
3.8%
스 9
 
3.8%
타 7
 
3.0%
운 6
 
2.5%
우 5
 
2.1%
로 5
 
2.1%
Other values (89) 145
61.2%

Interactions

2024-03-23T05:20:02.573869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T05:20:11.268486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분행정동비고
연번1.0001.0000.8941.000
구분1.0001.0001.0001.000
행정동0.8941.0001.0001.000
비고1.0001.0001.0001.000
2024-03-23T05:20:11.655283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분행정동
구분1.0000.982
행정동0.9821.000
2024-03-23T05:20:11.959715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분행정동
연번1.0000.9850.575
구분0.9851.0000.982
행정동0.5750.9821.000

Missing values

2024-03-23T05:20:02.973117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T05:20:03.447071image/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만안구경기도 안양시 만안구 경수대로1161안양2동<NA>
12만안구경기도 안양시 만안구 경수대로1167-5안양2동<NA>
23만안구경기도 안양시 만안구 경수대로1185-6안양2동<NA>
34만안구경기도 안양시 만안구 경수대로1196번길28석수1동성원연립
45만안구경기도 안양시 만안구 경수대로1196번길28석수1동성원연립
56만안구경기도 안양시 만안구 경수대로1200번길29석수1동<NA>
67만안구경기도 안양시 만안구 경수대로1201번길14석수1동<NA>
78만안구경기도 안양시 만안구 경수대로1269석수1동미래프라자 뒤쪽
89만안구경기도 안양시 만안구 경수대로1273번길25석수1동<NA>
910만안구경기도 안양시 만안구 경수대로1282석수1동한마음선원 큰길
연번구분주소행정동비고
644645동안구경기도 안양시 동안구 흥안대로 94번길 15(대흥슈퍼)호계3동<NA>
645646동안구경기도 안양시 동안구 흥안대로 94번길 52호계3동<NA>
646647동안구경기도 안양시 동안구 흥안대로 94번길 61호계3동<NA>
647648동안구경기도 안양시 동안구 흥안대로109번길 56호계1동사당교회, 앞
648649동안구경기도 안양시 동안구 흥안대로370번길16평촌동<NA>
649650동안구경기도 안양시 동안구 흥안대로370번길6평촌동<NA>
650651동안구경기도 안양시 동안구 흥안대로434번길24평촌동<NA>
651652동안구경기도 안양시 동안구 흥안대로456번길30평촌동<NA>
652653동안구경기도 안양시 동안구 흥안대로492번길49인덕원동<NA>
653654동안구경기도 안양시 동안구 흥안대로494-10인덕원동<NA>