Overview

Dataset statistics

Number of variables7
Number of observations474
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.1 KiB
Average record size in memory56.3 B

Variable types

Categorical4
Text2
DateTime1

Dataset

Description경기도 양주시 종량제봉투 판매소 현황으로 관리기관명, 행정도명, 법정도명, 판매소위치, 상호명, 관리부서 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15115851/fileData.do

Alerts

관리기관명 has constant value ""Constant
관리부서 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-12 22:16:39.318774
Analysis finished2023-12-12 22:16:39.815447
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
경기도 양주시
474 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 양주시
2nd row경기도 양주시
3rd row경기도 양주시
4th row경기도 양주시
5th row경기도 양주시

Common Values

ValueCountFrequency (%)
경기도 양주시 474
100.0%

Length

2023-12-13T07:16:39.867640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:16:39.974485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 474
50.0%
양주시 474
50.0%

행정동명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
회천4동
75 
양주2동
72 
백석읍
55 
광적면
46 
회천2동
46 
Other values (6)
180 

Length

Max length4
Median length4
Mean length3.5316456
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row백석읍
2nd row백석읍
3rd row백석읍
4th row백석읍
5th row백석읍

Common Values

ValueCountFrequency (%)
회천4동 75
15.8%
양주2동 72
15.2%
백석읍 55
11.6%
광적면 46
9.7%
회천2동 46
9.7%
은현면 35
7.4%
회천1동 35
7.4%
회천3동 35
7.4%
남면 29
 
6.1%
장흥면 28
 
5.9%

Length

2023-12-13T07:16:40.122350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
회천4동 75
15.8%
양주2동 72
15.2%
백석읍 55
11.6%
광적면 46
9.7%
회천2동 46
9.7%
은현면 35
7.4%
회천1동 35
7.4%
회천3동 35
7.4%
남면 29
 
6.1%
장흥면 28
 
5.9%

법정동명
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
옥정동
63 
백석읍
55 
광적면
46 
덕정동
40 
덕계동
35 
Other values (17)
235 

Length

Max length3
Median length3
Mean length2.9388186
Min length2

Unique

Unique2 ?
Unique (%)0.4%

Sample

1st row백석읍
2nd row백석읍
3rd row백석읍
4th row백석읍
5th row백석읍

Common Values

ValueCountFrequency (%)
옥정동 63
13.3%
백석읍 55
11.6%
광적면 46
9.7%
덕정동 40
8.4%
덕계동 35
 
7.4%
은현면 35
 
7.4%
남면 29
 
6.1%
장흥면 28
 
5.9%
광사동 24
 
5.1%
고암동 24
 
5.1%
Other values (12) 95
20.0%

Length

2023-12-13T07:16:40.258312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
옥정동 63
13.3%
백석읍 55
11.6%
광적면 46
9.7%
덕정동 40
8.4%
덕계동 35
 
7.4%
은현면 35
 
7.4%
남면 29
 
6.1%
장흥면 28
 
5.9%
광사동 24
 
5.1%
고암동 24
 
5.1%
Other values (12) 95
20.0%
Distinct455
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2023-12-13T07:16:40.510391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length35
Mean length18.535865
Min length11

Characters and Unicode

Total characters8786
Distinct characters116
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

Unique437 ?
Unique (%)92.2%

Sample

1st row경기도 양주시 백석읍 오산리 543-5
2nd row경기도 양주시 백석읍 방성리 78-4
3rd row경기도 양주시 백석읍 복지리 295-1
4th row경기도 양주시 백석읍 오산리 538-15
5th row경기도 양주시 백석읍 방성리 6-3
ValueCountFrequency (%)
경기도 474
22.5%
양주시 474
22.5%
옥정동 63
 
3.0%
백석읍 55
 
2.6%
광적면 47
 
2.2%
덕정동 38
 
1.8%
은현면 35
 
1.7%
덕계동 34
 
1.6%
남면 29
 
1.4%
장흥면 28
 
1.3%
Other values (515) 831
39.4%
2023-12-13T07:16:40.904683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1634
18.6%
485
 
5.5%
479
 
5.5%
478
 
5.4%
476
 
5.4%
474
 
5.4%
474
 
5.4%
- 360
 
4.1%
1 331
 
3.8%
280
 
3.2%
Other values (106) 3315
37.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4882
55.6%
Decimal Number 1886
 
21.5%
Space Separator 1634
 
18.6%
Dash Punctuation 360
 
4.1%
Close Punctuation 7
 
0.1%
Open Punctuation 7
 
0.1%
Lowercase Letter 4
 
< 0.1%
Other Punctuation 3
 
< 0.1%
Uppercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
485
 
9.9%
479
 
9.8%
478
 
9.8%
476
 
9.8%
474
 
9.7%
474
 
9.7%
280
 
5.7%
188
 
3.9%
139
 
2.8%
122
 
2.5%
Other values (84) 1287
26.4%
Decimal Number
ValueCountFrequency (%)
1 331
17.6%
2 236
12.5%
5 202
10.7%
6 199
10.6%
3 195
10.3%
4 189
10.0%
7 146
7.7%
9 132
 
7.0%
0 131
 
6.9%
8 125
 
6.6%
Lowercase Letter
ValueCountFrequency (%)
s 1
25.0%
u 1
25.0%
l 1
25.0%
p 1
25.0%
Uppercase Letter
ValueCountFrequency (%)
E 1
33.3%
S 1
33.3%
T 1
33.3%
Space Separator
ValueCountFrequency (%)
1634
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 360
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4882
55.6%
Common 3897
44.4%
Latin 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
485
 
9.9%
479
 
9.8%
478
 
9.8%
476
 
9.8%
474
 
9.7%
474
 
9.7%
280
 
5.7%
188
 
3.9%
139
 
2.8%
122
 
2.5%
Other values (84) 1287
26.4%
Common
ValueCountFrequency (%)
1634
41.9%
- 360
 
9.2%
1 331
 
8.5%
2 236
 
6.1%
5 202
 
5.2%
6 199
 
5.1%
3 195
 
5.0%
4 189
 
4.8%
7 146
 
3.7%
9 132
 
3.4%
Other values (5) 273
 
7.0%
Latin
ValueCountFrequency (%)
s 1
14.3%
u 1
14.3%
l 1
14.3%
p 1
14.3%
E 1
14.3%
S 1
14.3%
T 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4882
55.6%
ASCII 3904
44.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1634
41.9%
- 360
 
9.2%
1 331
 
8.5%
2 236
 
6.0%
5 202
 
5.2%
6 199
 
5.1%
3 195
 
5.0%
4 189
 
4.8%
7 146
 
3.7%
9 132
 
3.4%
Other values (12) 280
 
7.2%
Hangul
ValueCountFrequency (%)
485
 
9.9%
479
 
9.8%
478
 
9.8%
476
 
9.8%
474
 
9.7%
474
 
9.7%
280
 
5.7%
188
 
3.9%
139
 
2.8%
122
 
2.5%
Other values (84) 1287
26.4%

상호명
Text

UNIQUE 

Distinct474
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2023-12-13T07:16:41.167369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length20
Mean length9.742616
Min length3

Characters and Unicode

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

Unique

Unique474 ?
Unique (%)100.0%

Sample

1st row(주)꼬끼오 백석지점
2nd row(주)삼주국민마트(백석)
3rd row(주)케이엠유통(코리아마트)
4th rowCU 백석초교점
5th rowGS25 백석부흥점
ValueCountFrequency (%)
씨유 86
 
10.0%
gs25 76
 
8.8%
세븐일레븐 74
 
8.6%
이마트24 41
 
4.8%
주식회사 7
 
0.8%
주)이마트에브리데이 5
 
0.6%
양주 5
 
0.6%
미니스톱 5
 
0.6%
노브랜드 4
 
0.5%
지에스25 4
 
0.5%
Other values (490) 554
64.3%
2023-12-13T07:16:41.624602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
387
 
8.4%
332
 
7.2%
233
 
5.0%
203
 
4.4%
159
 
3.4%
2 130
 
2.8%
116
 
2.5%
113
 
2.4%
106
 
2.3%
93
 
2.0%
Other values (359) 2746
59.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3663
79.3%
Space Separator 387
 
8.4%
Decimal Number 267
 
5.8%
Uppercase Letter 212
 
4.6%
Open Punctuation 38
 
0.8%
Close Punctuation 38
 
0.8%
Lowercase Letter 7
 
0.2%
Other Symbol 2
 
< 0.1%
Other Punctuation 2
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
332
 
9.1%
233
 
6.4%
203
 
5.5%
159
 
4.3%
116
 
3.2%
113
 
3.1%
106
 
2.9%
93
 
2.5%
92
 
2.5%
90
 
2.5%
Other values (319) 2126
58.0%
Uppercase Letter
ValueCountFrequency (%)
S 83
39.2%
G 81
38.2%
C 11
 
5.2%
R 5
 
2.4%
U 4
 
1.9%
A 4
 
1.9%
T 4
 
1.9%
I 4
 
1.9%
L 4
 
1.9%
D 2
 
0.9%
Other values (7) 10
 
4.7%
Decimal Number
ValueCountFrequency (%)
2 130
48.7%
5 84
31.5%
4 44
 
16.5%
8 3
 
1.1%
1 2
 
0.7%
0 1
 
0.4%
7 1
 
0.4%
6 1
 
0.4%
3 1
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
s 2
28.6%
e 1
14.3%
p 1
14.3%
l 1
14.3%
u 1
14.3%
k 1
14.3%
Other Punctuation
ValueCountFrequency (%)
/ 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
387
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Other Symbol
ValueCountFrequency (%)
2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3665
79.4%
Common 734
 
15.9%
Latin 219
 
4.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
332
 
9.1%
233
 
6.4%
203
 
5.5%
159
 
4.3%
116
 
3.2%
113
 
3.1%
106
 
2.9%
93
 
2.5%
92
 
2.5%
90
 
2.5%
Other values (320) 2128
58.1%
Latin
ValueCountFrequency (%)
S 83
37.9%
G 81
37.0%
C 11
 
5.0%
R 5
 
2.3%
U 4
 
1.8%
A 4
 
1.8%
T 4
 
1.8%
I 4
 
1.8%
L 4
 
1.8%
D 2
 
0.9%
Other values (13) 17
 
7.8%
Common
ValueCountFrequency (%)
387
52.7%
2 130
 
17.7%
5 84
 
11.4%
4 44
 
6.0%
( 38
 
5.2%
) 38
 
5.2%
8 3
 
0.4%
1 2
 
0.3%
0 1
 
0.1%
7 1
 
0.1%
Other values (6) 6
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3663
79.3%
ASCII 953
 
20.6%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
387
40.6%
2 130
 
13.6%
5 84
 
8.8%
S 83
 
8.7%
G 81
 
8.5%
4 44
 
4.6%
( 38
 
4.0%
) 38
 
4.0%
C 11
 
1.2%
R 5
 
0.5%
Other values (29) 52
 
5.5%
Hangul
ValueCountFrequency (%)
332
 
9.1%
233
 
6.4%
203
 
5.5%
159
 
4.3%
116
 
3.2%
113
 
3.1%
106
 
2.9%
93
 
2.5%
92
 
2.5%
90
 
2.5%
Other values (319) 2126
58.0%
None
ValueCountFrequency (%)
2
100.0%

관리부서
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
청소행정과
474 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
청소행정과 474
100.0%

Length

2023-12-13T07:16:41.744447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:16:41.831387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청소행정과 474
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
Minimum2023-06-30 00:00:00
Maximum2023-06-30 00:00:00
2023-12-13T07:16:41.901497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:16:41.995030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-13T07:16:42.074571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동명법정동명
행정동명1.0001.000
법정동명1.0001.000
2023-12-13T07:16:42.151124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
법정동명행정동명
법정동명1.0000.964
행정동명0.9641.000
2023-12-13T07:16:42.239606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동명법정동명
행정동명1.0000.964
법정동명0.9641.000

Missing values

2023-12-13T07:16:39.673587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:16:39.773839image/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경기도 양주시백석읍백석읍경기도 양주시 백석읍 오산리 543-5(주)꼬끼오 백석지점청소행정과2023-06-30
1경기도 양주시백석읍백석읍경기도 양주시 백석읍 방성리 78-4(주)삼주국민마트(백석)청소행정과2023-06-30
2경기도 양주시백석읍백석읍경기도 양주시 백석읍 복지리 295-1(주)케이엠유통(코리아마트)청소행정과2023-06-30
3경기도 양주시백석읍백석읍경기도 양주시 백석읍 오산리 538-15CU 백석초교점청소행정과2023-06-30
4경기도 양주시백석읍백석읍경기도 양주시 백석읍 방성리 6-3GS25 백석부흥점청소행정과2023-06-30
5경기도 양주시백석읍백석읍경기도 양주시 백석읍 복지리 322-4GS25 백석은하수청소행정과2023-06-30
6경기도 양주시백석읍백석읍경기도 양주시 백석읍 양주산성로 54 (가야아파트상가동 101호)GS25 양주가야점청소행정과2023-06-30
7경기도 양주시백석읍백석읍경기도 양주시 백석읍 방성리 511-2GS25 양주대교점청소행정과2023-06-30
8경기도 양주시백석읍백석읍경기도 양주시 백석읍 방성리 8-7GS25 양주백석점청소행정과2023-06-30
9경기도 양주시백석읍백석읍경기도 양주시 백석읍 복지리 125GS25 양주복지리점청소행정과2023-06-30
관리기관명행정동명법정동명판매소위치상호명관리부서데이터기준일자
464경기도 양주시회천4동옥정동경기도 양주시 옥정동 1049-3이마트24 옥정혜산프라자점청소행정과2023-06-30
465경기도 양주시회천4동옥정동경기도 양주시 옥정동 1040-8이마트24 옥정호수점청소행정과2023-06-30
466경기도 양주시회천4동옥정동경기도 양주시 옥정동 1066-3이마트24양주옥정제이드웰점청소행정과2023-06-30
467경기도 양주시회천4동회암동경기도 양주시 회암동 250-21종점편의점청소행정과2023-06-30
468경기도 양주시회천4동옥정동경기도 양주시 옥정동 946지에스25 옥정디에트르2호점청소행정과2023-06-30
469경기도 양주시회천4동율정동경기도 양주시 율정동 121-2지평휴게실상회청소행정과2023-06-30
470경기도 양주시회천4동율정동경기도 양주시 율정동 44-3 (천보아파트 옆)천보잡화청소행정과2023-06-30
471경기도 양주시회천4동옥정동경기도 양주시 옥정동 1036-7초록마을 옥정신도시점청소행정과2023-06-30
472경기도 양주시회천4동옥정동경기도 양주시 옥정동 873-6코리아세븐 양주옥정세창점청소행정과2023-06-30
473경기도 양주시회천4동율정동경기도 양주시 율정동 304-14한누리24청소행정과2023-06-30