Overview

Dataset statistics

Number of variables5
Number of observations859
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory34.5 KiB
Average record size in memory41.2 B

Variable types

Numeric1
Text2
Categorical1
DateTime1

Dataset

Description대전광역시 서구 쓰레기 종량제 봉투 판매소 현황에 대한 데이터로 서구 관내 종량제봉투 판매소의 상호 및 위치 안내입니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15099719/fileData.do

Alerts

데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 행정동High correlation
행정동 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 23:30:42.496270
Analysis finished2023-12-12 23:30:43.107379
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct859
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean430
Minimum1
Maximum859
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-13T08:30:43.169908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile43.9
Q1215.5
median430
Q3644.5
95-th percentile816.1
Maximum859
Range858
Interquartile range (IQR)429

Descriptive statistics

Standard deviation248.11624
Coefficient of variation (CV)0.5770145
Kurtosis-1.2
Mean430
Median Absolute Deviation (MAD)215
Skewness0
Sum369370
Variance61561.667
MonotonicityStrictly increasing
2023-12-13T08:30:43.289038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
566 1
 
0.1%
568 1
 
0.1%
569 1
 
0.1%
570 1
 
0.1%
571 1
 
0.1%
572 1
 
0.1%
573 1
 
0.1%
574 1
 
0.1%
575 1
 
0.1%
Other values (849) 849
98.8%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
859 1
0.1%
858 1
0.1%
857 1
0.1%
856 1
0.1%
855 1
0.1%
854 1
0.1%
853 1
0.1%
852 1
0.1%
851 1
0.1%
850 1
0.1%

상호명
Text

UNIQUE 

Distinct859
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size6.8 KiB
2023-12-13T08:30:43.488978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length23
Mean length17.159488
Min length10

Characters and Unicode

Total characters14740
Distinct characters403
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

Unique859 ?
Unique (%)100.0%

Sample

1st row대전축산업협동조합(도안)(171060)
2nd row코코마트주식회사(171055)
3rd row홈플러스익스프레스도안2점(171056)
4th row씨유 도안베르디움점(171057)
5th row도안베르디움아파트(171912)
ValueCountFrequency (%)
씨유 94
 
7.0%
세븐일레븐 75
 
5.6%
이마트24 70
 
5.2%
gs25 59
 
4.4%
지에스25 36
 
2.7%
주식회사 17
 
1.3%
주)코리아세븐 17
 
1.3%
지에스(gs)25 7
 
0.5%
지에스25(gs25 7
 
0.5%
초록마을 7
 
0.5%
Other values (931) 949
70.9%
2023-12-13T08:30:43.834161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1427
 
9.7%
2 1252
 
8.5%
( 946
 
6.4%
) 946
 
6.4%
0 842
 
5.7%
479
 
3.2%
9 468
 
3.2%
점 467
 
3.2%
4 382
 
2.6%
3 371
 
2.5%
Other values (393) 7160
48.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6464
43.9%
Decimal Number 5669
38.5%
Open Punctuation 946
 
6.4%
Close Punctuation 946
 
6.4%
Space Separator 479
 
3.2%
Uppercase Letter 214
 
1.5%
Lowercase Letter 15
 
0.1%
Other Punctuation 3
 
< 0.1%
Dash Punctuation 2
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 467
 
7.2%
마 354
 
5.5%
대 295
 
4.6%
전 271
 
4.2%
트 258
 
4.0%
스 187
 
2.9%
븐 174
 
2.7%
이 127
 
2.0%
지 124
 
1.9%
유 124
 
1.9%
Other values (351) 4083
63.2%
Uppercase Letter
ValueCountFrequency (%)
S 88
41.1%
G 86
40.2%
R 9
 
4.2%
C 7
 
3.3%
K 7
 
3.3%
U 7
 
3.3%
A 2
 
0.9%
T 2
 
0.9%
D 2
 
0.9%
M 1
 
0.5%
Other values (3) 3
 
1.4%
Decimal Number
ValueCountFrequency (%)
1 1427
25.2%
2 1252
22.1%
0 842
14.9%
9 468
 
8.3%
4 382
 
6.7%
3 371
 
6.5%
5 350
 
6.2%
8 196
 
3.5%
7 191
 
3.4%
6 190
 
3.4%
Lowercase Letter
ValueCountFrequency (%)
l 2
13.3%
a 2
13.3%
e 2
13.3%
g 2
13.3%
s 2
13.3%
u 1
6.7%
c 1
6.7%
r 1
6.7%
h 1
6.7%
p 1
6.7%
Other Punctuation
ValueCountFrequency (%)
# 1
33.3%
. 1
33.3%
， 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 946
100.0%
Close Punctuation
ValueCountFrequency (%)
) 946
100.0%
Space Separator
ValueCountFrequency (%)
479
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8046
54.6%
Hangul 6465
43.9%
Latin 229
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 467
 
7.2%
마 354
 
5.5%
대 295
 
4.6%
전 271
 
4.2%
트 258
 
4.0%
스 187
 
2.9%
븐 174
 
2.7%
이 127
 
2.0%
지 124
 
1.9%
유 124
 
1.9%
Other values (352) 4084
63.2%
Latin
ValueCountFrequency (%)
S 88
38.4%
G 86
37.6%
R 9
 
3.9%
C 7
 
3.1%
K 7
 
3.1%
U 7
 
3.1%
A 2
 
0.9%
l 2
 
0.9%
a 2
 
0.9%
T 2
 
0.9%
Other values (13) 17
 
7.4%
Common
ValueCountFrequency (%)
1 1427
17.7%
2 1252
15.6%
( 946
11.8%
) 946
11.8%
0 842
10.5%
479
 
6.0%
9 468
 
5.8%
4 382
 
4.7%
3 371
 
4.6%
5 350
 
4.3%
Other values (8) 583
7.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8274
56.1%
Hangul 6464
43.9%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1427
17.2%
2 1252
15.1%
( 946
11.4%
) 946
11.4%
0 842
10.2%
479
 
5.8%
9 468
 
5.7%
4 382
 
4.6%
3 371
 
4.5%
5 350
 
4.2%
Other values (30) 811
9.8%
Hangul
ValueCountFrequency (%)
점 467
 
7.2%
마 354
 
5.5%
대 295
 
4.6%
전 271
 
4.2%
트 258
 
4.0%
스 187
 
2.9%
븐 174
 
2.7%
이 127
 
2.0%
지 124
 
1.9%
유 124
 
1.9%
Other values (351) 4083
63.2%
None
ValueCountFrequency (%)
， 1
50.0%
㈜ 1
50.0%

행정동
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size6.8 KiB
탄방동
68 
둔산2동
65 
가수원동
61 
갈마2동
 
55
괴정동
 
55
Other values (20)
555 

Length

Max length6
Median length4
Mean length3.644936
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가수원동
2nd row가수원동
3rd row가수원동
4th row가수원동
5th row가수원동

Common Values

ValueCountFrequency (%)
탄방동 68
 
7.9%
둔산2동 65
 
7.6%
가수원동 61
 
7.1%
갈마2동 55
 
6.4%
괴정동 55
 
6.4%
관저2동 52
 
6.1%
도마1동 48
 
5.6%
기타(관외) 42
 
4.9%
월평1동 41
 
4.8%
갈마1동 40
 
4.7%
Other values (15) 332
38.6%

Length

2023-12-13T08:30:43.971774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
탄방동 68
 
7.9%
둔산2동 65
 
7.6%
가수원동 61
 
7.1%
갈마2동 55
 
6.4%
괴정동 55
 
6.4%
관저2동 52
 
6.1%
도마1동 48
 
5.6%
기타(관외 42
 
4.9%
월평1동 41
 
4.8%
갈마1동 40
 
4.7%
Other values (15) 332
38.6%

소재지
Text

Distinct853
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size6.8 KiB
2023-12-13T08:30:44.223299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length39
Mean length18.04773
Min length1

Characters and Unicode

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

Unique

Unique851 ?
Unique (%)99.1%

Sample

1st row도안중로305번길 6(도안동)
2nd row도안북로103,102(도안동,샤인빌딩102~108)
3rd row원도안로 191(도안동,1층)
4th row원도안로 100(도안동, 도안베르디움아파트상가동 108호)
5th row원도안로 100(도안동, 도안베르디움아파트)
ValueCountFrequency (%)
1층 129
 
5.2%
서구 46
 
1.8%
상가동 26
 
1.0%
101호 23
 
0.9%
중구 15
 
0.6%
유성구 14
 
0.6%
도솔로 14
 
0.6%
괴정동 14
 
0.6%
102호 14
 
0.6%
갈마2동 12
 
0.5%
Other values (1521) 2193
87.7%
2023-12-13T08:30:44.587433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2171
 
14.0%
1 1602
 
10.3%
동 733
 
4.7%
2 703
 
4.5%
로 634
 
4.1%
0 549
 
3.5%
3 516
 
3.3%
4 431
 
2.8%
, 415
 
2.7%
5 390
 
2.5%
Other values (265) 7359
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6599
42.6%
Decimal Number 5518
35.6%
Space Separator 2171
 
14.0%
Other Punctuation 419
 
2.7%
Dash Punctuation 334
 
2.2%
Open Punctuation 221
 
1.4%
Close Punctuation 217
 
1.4%
Uppercase Letter 12
 
0.1%
Math Symbol 10
 
0.1%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 733
 
11.1%
로 634
 
9.6%
번 344
 
5.2%
길 298
 
4.5%
층 226
 
3.4%
마 221
 
3.3%
호 219
 
3.3%
도 197
 
3.0%
산 185
 
2.8%
가 169
 
2.6%
Other values (238) 3373
51.1%
Decimal Number
ValueCountFrequency (%)
1 1602
29.0%
2 703
12.7%
0 549
 
9.9%
3 516
 
9.4%
4 431
 
7.8%
5 390
 
7.1%
6 370
 
6.7%
9 323
 
5.9%
8 319
 
5.8%
7 315
 
5.7%
Uppercase Letter
ValueCountFrequency (%)
B 5
41.7%
A 1
 
8.3%
F 1
 
8.3%
L 1
 
8.3%
H 1
 
8.3%
O 1
 
8.3%
S 1
 
8.3%
D 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 415
99.0%
@ 3
 
0.7%
/ 1
 
0.2%
Space Separator
ValueCountFrequency (%)
2171
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 334
100.0%
Open Punctuation
ValueCountFrequency (%)
( 221
100.0%
Close Punctuation
ValueCountFrequency (%)
) 217
100.0%
Math Symbol
ValueCountFrequency (%)
~ 10
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8890
57.3%
Hangul 6599
42.6%
Latin 14
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 733
 
11.1%
로 634
 
9.6%
번 344
 
5.2%
길 298
 
4.5%
층 226
 
3.4%
마 221
 
3.3%
호 219
 
3.3%
도 197
 
3.0%
산 185
 
2.8%
가 169
 
2.6%
Other values (238) 3373
51.1%
Common
ValueCountFrequency (%)
2171
24.4%
1 1602
18.0%
2 703
 
7.9%
0 549
 
6.2%
3 516
 
5.8%
4 431
 
4.8%
, 415
 
4.7%
5 390
 
4.4%
6 370
 
4.2%
- 334
 
3.8%
Other values (8) 1409
15.8%
Latin
ValueCountFrequency (%)
B 5
35.7%
e 2
 
14.3%
A 1
 
7.1%
F 1
 
7.1%
L 1
 
7.1%
H 1
 
7.1%
O 1
 
7.1%
S 1
 
7.1%
D 1
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8904
57.4%
Hangul 6599
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2171
24.4%
1 1602
18.0%
2 703
 
7.9%
0 549
 
6.2%
3 516
 
5.8%
4 431
 
4.8%
, 415
 
4.7%
5 390
 
4.4%
6 370
 
4.2%
- 334
 
3.8%
Other values (17) 1423
16.0%
Hangul
ValueCountFrequency (%)
동 733
 
11.1%
로 634
 
9.6%
번 344
 
5.2%
길 298
 
4.5%
층 226
 
3.4%
마 221
 
3.3%
호 219
 
3.3%
도 197
 
3.0%
산 185
 
2.8%
가 169
 
2.6%
Other values (238) 3373
51.1%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.8 KiB
Minimum2023-02-07 00:00:00
Maximum2023-02-07 00:00:00
2023-12-13T08:30:44.710454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T08:30:44.795124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T08:30:42.887646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T08:30:44.872591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.994
행정동0.9941.000
2023-12-13T08:30:44.958181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동
연번1.0000.922
행정동0.9221.000

Missing values

2023-12-13T08:30:42.983711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:30:43.072194image/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대전축산업협동조합(도안)(171060)가수원동도안중로305번길 6(도안동)2023-02-07
12코코마트주식회사(171055)가수원동도안북로103,102(도안동,샤인빌딩102~108)2023-02-07
23홈플러스익스프레스도안2점(171056)가수원동원도안로 191(도안동,1층)2023-02-07
34씨유 도안베르디움점(171057)가수원동원도안로 100(도안동, 도안베르디움아파트상가동 108호)2023-02-07
45도안베르디움아파트(171912)가수원동원도안로 100(도안동, 도안베르디움아파트)2023-02-07
56지에스25 도안중앙점(171949)가수원동서구 도안동로31번길 12-3, 1층2023-02-07
67빅마트(171048)가수원동가수원중로 4-26 806-32023-02-07
78씨유 도안한라비발디점(171049)가수원동도안북로136(도안동,101호)2023-02-07
89참조은마트(171050)가수원동가수원로 43(가수원동)2023-02-07
910세종마트(171910)가수원동가수원로91-4(가수원동,1층) 656-272023-02-07
연번상호명행정동소재지데이터기준일
849850이마트24대전탄방문정점(211956)탄방동문정로122번길 22, 1층2023-02-07
850851씨유 대전탄방남선점(211957)탄방동2023-02-07
851852이마트24 대전보라매점 (211958)탄방동문정로60번길 60, 1층(탄방동, 둔산리치2동)2023-02-07
852853세븐일레븐 대전탄방행복점(211959)탄방동도솔로437번길 29, 1층2023-02-07
853854GS25 둔산로데오점(211960)탄방동문정로 77, 141호(탄방동)2023-02-07
854855주식회사 8282기획(211961)탄방동문예로 17, 4층(뉴대전빌딩)2023-02-07
855856이마트24R 대전탄방베스트점(211965)탄방동도솔로411번길 16, 1층2023-02-07
856857(주)코리아세븐 대전탄방하모니점(211964)탄방동계룡로583번길 6, 1층2023-02-07
857858세븐일레븐 대전탄방시티점(211962)탄방동문정로2번길 33, 1층 107호, 109호2023-02-07
858859홈플러스(주)익스프레스 탄방점(211963)탄방동문예로 152023-02-07