Overview

Dataset statistics

Number of variables6
Number of observations531
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.5 KiB
Average record size in memory49.2 B

Variable types

Numeric1
Text2
Categorical3

Dataset

Description서울특별시 동대문구 쓰레기종량제봉투 판매소 현황 데이터로 판매소명, 주소, 특수마대 판매여부, 특수마대 용량 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15113107/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
특수마대 용량 is highly overall correlated with 특수마대 판매여부High correlation
특수마대 판매여부 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 is highly overall correlated with 특수마대 판매여부High correlation
연번 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 04:21:48.122349
Analysis finished2023-12-12 04:21:48.848696
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct531
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean266
Minimum1
Maximum531
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.8 KiB
2023-12-12T13:21:48.925239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile27.5
Q1133.5
median266
Q3398.5
95-th percentile504.5
Maximum531
Range530
Interquartile range (IQR)265

Descriptive statistics

Standard deviation153.43077
Coefficient of variation (CV)0.57680739
Kurtosis-1.2
Mean266
Median Absolute Deviation (MAD)133
Skewness0
Sum141246
Variance23541
MonotonicityStrictly increasing
2023-12-12T13:21:49.080076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
351 1
 
0.2%
365 1
 
0.2%
364 1
 
0.2%
363 1
 
0.2%
362 1
 
0.2%
361 1
 
0.2%
360 1
 
0.2%
359 1
 
0.2%
358 1
 
0.2%
Other values (521) 521
98.1%
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 (%)
531 1
0.2%
530 1
0.2%
529 1
0.2%
528 1
0.2%
527 1
0.2%
526 1
0.2%
525 1
0.2%
524 1
0.2%
523 1
0.2%
522 1
0.2%

판매소명
Text

Distinct519
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
2023-12-12T13:21:49.340964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length15
Mean length8.1996234
Min length2

Characters and Unicode

Total characters4354
Distinct characters339
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique509 ?
Unique (%)95.9%

Sample

1st rowCU 신설남예종점
2nd row경북식품
3rd row경동유통(광명슈퍼)
4th row그린팜마트
5th row대광슈퍼
ValueCountFrequency (%)
gs25 63
 
7.7%
cu 62
 
7.6%
세븐일레븐 55
 
6.7%
지에스25 26
 
3.2%
씨유 24
 
2.9%
이마트24 16
 
2.0%
코리아세븐 9
 
1.1%
우리슈퍼 3
 
0.4%
답십리역점 3
 
0.4%
신이문역점 3
 
0.4%
Other values (510) 552
67.6%
2023-12-12T13:21:49.796412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 294
 
6.8%
288
 
6.6%
2 138
 
3.2%
트 129
 
3.0%
븐 127
 
2.9%
마 120
 
2.8%
5 105
 
2.4%
리 100
 
2.3%
장 88
 
2.0%
대 88
 
2.0%
Other values (329) 2877
66.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3460
79.5%
Uppercase Letter 290
 
6.7%
Space Separator 288
 
6.6%
Decimal Number 284
 
6.5%
Lowercase Letter 11
 
0.3%
Open Punctuation 8
 
0.2%
Close Punctuation 8
 
0.2%
Other Symbol 3
 
0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 294
 
8.5%
트 129
 
3.7%
븐 127
 
3.7%
마 120
 
3.5%
리 100
 
2.9%
장 88
 
2.5%
대 88
 
2.5%
안 84
 
2.4%
스 81
 
2.3%
이 74
 
2.1%
Other values (297) 2275
65.8%
Uppercase Letter
ValueCountFrequency (%)
S 76
26.2%
G 69
23.8%
C 65
22.4%
U 65
22.4%
K 4
 
1.4%
D 3
 
1.0%
J 2
 
0.7%
L 2
 
0.7%
R 2
 
0.7%
M 1
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
e 3
27.3%
n 1
 
9.1%
t 1
 
9.1%
k 1
 
9.1%
r 1
 
9.1%
a 1
 
9.1%
f 1
 
9.1%
l 1
 
9.1%
s 1
 
9.1%
Decimal Number
ValueCountFrequency (%)
2 138
48.6%
5 105
37.0%
4 29
 
10.2%
1 6
 
2.1%
9 3
 
1.1%
3 2
 
0.7%
7 1
 
0.4%
Space Separator
ValueCountFrequency (%)
288
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3463
79.5%
Common 590
 
13.6%
Latin 301
 
6.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 294
 
8.5%
트 129
 
3.7%
븐 127
 
3.7%
마 120
 
3.5%
리 100
 
2.9%
장 88
 
2.5%
대 88
 
2.5%
안 84
 
2.4%
스 81
 
2.3%
이 74
 
2.1%
Other values (298) 2278
65.8%
Latin
ValueCountFrequency (%)
S 76
25.2%
G 69
22.9%
C 65
21.6%
U 65
21.6%
K 4
 
1.3%
e 3
 
1.0%
D 3
 
1.0%
J 2
 
0.7%
L 2
 
0.7%
R 2
 
0.7%
Other values (10) 10
 
3.3%
Common
ValueCountFrequency (%)
288
48.8%
2 138
23.4%
5 105
 
17.8%
4 29
 
4.9%
( 8
 
1.4%
) 8
 
1.4%
1 6
 
1.0%
9 3
 
0.5%
/ 2
 
0.3%
3 2
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3460
79.5%
ASCII 891
 
20.5%
None 3
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 294
 
8.5%
트 129
 
3.7%
븐 127
 
3.7%
마 120
 
3.5%
리 100
 
2.9%
장 88
 
2.5%
대 88
 
2.5%
안 84
 
2.4%
스 81
 
2.3%
이 74
 
2.1%
Other values (297) 2275
65.8%
ASCII
ValueCountFrequency (%)
288
32.3%
2 138
15.5%
5 105
 
11.8%
S 76
 
8.5%
G 69
 
7.7%
C 65
 
7.3%
U 65
 
7.3%
4 29
 
3.3%
( 8
 
0.9%
) 8
 
0.9%
Other values (21) 40
 
4.5%
None
ValueCountFrequency (%)
㈜ 3
100.0%

주소
Text

UNIQUE 

Distinct531
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
2023-12-12T13:21:50.057940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length65
Median length48
Mean length26.566855
Min length17

Characters and Unicode

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

Unique

Unique531 ?
Unique (%)100.0%

Sample

1st row서울특별시 동대문구 한빛로 18(신설동)
2nd row서울특별시 동대문구 무학로 189(용두동)
3rd row서울특별시 동대문구 고산자로30길 70(용두동)
4th row서울특별시 동대문구 왕산로 108(용두동)
5th row서울특별시 동대문구 천호대로39길 55(용두동)
ValueCountFrequency (%)
동대문구 533
22.3%
서울특별시 531
22.2%
1층 43
 
1.8%
한천로 25
 
1.0%
천호대로 19
 
0.8%
장한로 18
 
0.8%
왕산로 17
 
0.7%
전농로 17
 
0.7%
답십리로 15
 
0.6%
전농동 14
 
0.6%
Other values (802) 1157
48.4%
2023-12-12T13:21:50.574950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1860
 
13.2%
동 1015
 
7.2%
문 615
 
4.4%
대 612
 
4.3%
1 600
 
4.3%
시 564
 
4.0%
서 547
 
3.9%
울 547
 
3.9%
구 533
 
3.8%
특 531
 
3.8%
Other values (157) 6683
47.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8918
63.2%
Decimal Number 2162
 
15.3%
Space Separator 1860
 
13.2%
Open Punctuation 447
 
3.2%
Close Punctuation 447
 
3.2%
Other Punctuation 194
 
1.4%
Dash Punctuation 64
 
0.5%
Uppercase Letter 12
 
0.1%
Math Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 1015
 
11.4%
문 615
 
6.9%
대 612
 
6.9%
시 564
 
6.3%
서 547
 
6.1%
울 547
 
6.1%
구 533
 
6.0%
특 531
 
6.0%
별 531
 
6.0%
로 529
 
5.9%
Other values (136) 2894
32.5%
Decimal Number
ValueCountFrequency (%)
1 600
27.8%
2 318
14.7%
3 215
 
9.9%
0 196
 
9.1%
4 176
 
8.1%
6 149
 
6.9%
5 143
 
6.6%
8 131
 
6.1%
7 127
 
5.9%
9 107
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
B 5
41.7%
S 3
25.0%
K 3
25.0%
A 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 192
99.0%
@ 2
 
1.0%
Space Separator
ValueCountFrequency (%)
1860
100.0%
Open Punctuation
ValueCountFrequency (%)
( 447
100.0%
Close Punctuation
ValueCountFrequency (%)
) 447
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8918
63.2%
Common 5177
36.7%
Latin 12
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 1015
 
11.4%
문 615
 
6.9%
대 612
 
6.9%
시 564
 
6.3%
서 547
 
6.1%
울 547
 
6.1%
구 533
 
6.0%
특 531
 
6.0%
별 531
 
6.0%
로 529
 
5.9%
Other values (136) 2894
32.5%
Common
ValueCountFrequency (%)
1860
35.9%
1 600
 
11.6%
( 447
 
8.6%
) 447
 
8.6%
2 318
 
6.1%
3 215
 
4.2%
0 196
 
3.8%
, 192
 
3.7%
4 176
 
3.4%
6 149
 
2.9%
Other values (7) 577
 
11.1%
Latin
ValueCountFrequency (%)
B 5
41.7%
S 3
25.0%
K 3
25.0%
A 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8918
63.2%
ASCII 5189
36.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1860
35.8%
1 600
 
11.6%
( 447
 
8.6%
) 447
 
8.6%
2 318
 
6.1%
3 215
 
4.1%
0 196
 
3.8%
, 192
 
3.7%
4 176
 
3.4%
6 149
 
2.9%
Other values (11) 589
 
11.4%
Hangul
ValueCountFrequency (%)
동 1015
 
11.4%
문 615
 
6.9%
대 612
 
6.9%
시 564
 
6.3%
서 547
 
6.1%
울 547
 
6.1%
구 533
 
6.0%
특 531
 
6.0%
별 531
 
6.0%
로 529
 
5.9%
Other values (136) 2894
32.5%

특수마대 판매여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
<NA>
346 
○
185 

Length

Max length4
Median length4
Mean length2.9548023
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row○
4th row○
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 346
65.2%
○ 185
34.8%

Length

2023-12-12T13:21:50.715056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:21:50.859047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 346
65.2%
○ 185
34.8%

특수마대 용량
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
<NA>
346 
20ℓ
125 
10ℓ+20ℓ
57 
10ℓ
 
3

Length

Max length7
Median length4
Mean length4.0809793
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row20ℓ
4th row20ℓ
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 346
65.2%
20ℓ 125
 
23.5%
10ℓ+20ℓ 57
 
10.7%
10ℓ 3
 
0.6%

Length

2023-12-12T13:21:50.977298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:21:51.091768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 346
65.2%
20ℓ 125
 
23.5%
10ℓ+20ℓ 57
 
10.7%
10ℓ 3
 
0.6%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.3 KiB
2023-02-28
531 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-28
2nd row2023-02-28
3rd row2023-02-28
4th row2023-02-28
5th row2023-02-28

Common Values

ValueCountFrequency (%)
2023-02-28 531
100.0%

Length

2023-12-12T13:21:51.213127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:21:51.385645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-02-28 531
100.0%

Interactions

2023-12-12T13:21:48.533330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:21:51.463239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번특수마대 용량
연번1.0000.217
특수마대 용량0.2171.000
2023-12-12T13:21:51.583289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
특수마대 용량특수마대 판매여부
특수마대 용량1.0001.000
특수마대 판매여부1.0001.000
2023-12-12T13:21:51.694142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번특수마대 판매여부특수마대 용량
연번1.0001.0000.129
특수마대 판매여부1.0001.0001.000
특수마대 용량0.1291.0001.000

Missing values

2023-12-12T13:21:48.666242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:21:48.805184image/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

연번판매소명주소특수마대 판매여부특수마대 용량데이터기준일자
01CU 신설남예종점서울특별시 동대문구 한빛로 18(신설동)<NA><NA>2023-02-28
12경북식품서울특별시 동대문구 무학로 189(용두동)<NA><NA>2023-02-28
23경동유통(광명슈퍼)서울특별시 동대문구 고산자로30길 70(용두동)○20ℓ2023-02-28
34그린팜마트서울특별시 동대문구 왕산로 108(용두동)○20ℓ2023-02-28
45대광슈퍼서울특별시 동대문구 천호대로39길 55(용두동)<NA><NA>2023-02-28
56동부마트/시립병원앞서울특별시 동대문구 무학로 30길 26 (용두동)○20ℓ2023-02-28
67둘리마트서울특별시 동대문구 천호대로45라길 12(용두동)○20ℓ2023-02-28
78CU 동대문도서관서울특별시 동대문구 천호대로2길 23-17(신설동)<NA><NA>2023-02-28
89세븐일레븐 라마다 신설점서울특별시 동대문구 왕산로 20, 101호 (신설동, 동양빌딩)<NA><NA>2023-02-28
910GS25 동대문신동아점서울특별시 동대문구 무학로 26길 33(용두동)<NA><NA>2023-02-28
연번판매소명주소특수마대 판매여부특수마대 용량데이터기준일자
521522세븐일레븐 신이문역점서울특별시 동대문구 한천로 479(이문동, 1층)<NA><NA>2023-02-28
522523GS25 이문삼거리서울특별시 동대문구 이문로 178, 1층 (이문동)<NA><NA>2023-02-28
523524세븐일레븐 이문행복점서울특별시 동대문구 신이문로2길 25 1층,101호(이문동)<NA><NA>2023-02-28
524525서울전기종합상사서울특별시 동대문구 이문로 201, 1층(이문동)○20ℓ2023-02-28
525526럭키할인마트서울특별시 동대문구 신이문로27, 102,013호○10ℓ+20ℓ2023-02-28
526527샛별로또서울특별시 동대문구 한천로 422, 1층(이문동)○20ℓ2023-02-28
527528GS25 신이문로점서울특별시 동대문구 신이문로 37(이문동)<NA><NA>2023-02-28
528529스토리웨이 신이문역점서울특별시 동대문구 한천로 472<NA><NA>2023-02-28
529530지에스25 신이문대리점서울특별시 동대문구 신이문로54길 46<NA><NA>2023-02-28
530531신창마트서울특별시 동대문구 망우로 114 (휘경동)○10ℓ+20ℓ2023-02-28