Overview

Dataset statistics

Number of variables9
Number of observations62
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.6 KiB
Average record size in memory76.1 B

Variable types

Categorical5
Text1
DateTime1
Numeric2

Dataset

Description서초구 내 담배꽁초 수거함 현황에 대한 데이터입니다. 흡연구역 내에 있는 담배꽁초 수거함 이외에도 도로변 담배꽁초 수거함도 포함되어 있으며 담배꽁초만을 수거하는 전용수거함을 별도로 표기하였습니다.
URLhttps://www.data.go.kr/data/15104099/fileData.do

Alerts

자치구명 has constant value ""Constant
청소관리 is highly overall correlated with 설치주체 and 1 other fieldsHigh correlation
해당동 is highly overall correlated with 위도 and 2 other fieldsHigh correlation
설치주체 is highly overall correlated with 청소관리 and 1 other fieldsHigh correlation
비고 is highly overall correlated with 위도 and 4 other fieldsHigh correlation
위도 is highly overall correlated with 경도 and 2 other fieldsHigh correlation
경도 is highly overall correlated with 위도 and 2 other fieldsHigh correlation
설치위치 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:20:41.350026
Analysis finished2023-12-12 07:20:42.694442
Duration1.34 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size628.0 B
서초구
62 

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 (%)
서초구 62
100.0%

Length

2023-12-12T16:20:42.783972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:20:42.900647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서초구 62
100.0%

해당동
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)17.7%
Missing0
Missing (%)0.0%
Memory size628.0 B
양재2동
21 
양재1동
15 
서초2동
7 
방배2동
5 
반포4동
4 
Other values (6)
10 

Length

Max length4
Median length4
Mean length3.983871
Min length3

Unique

Unique3 ?
Unique (%)4.8%

Sample

1st row서초4동
2nd row양재1동
3rd row양재1동
4th row반포4동
5th row서초2동

Common Values

ValueCountFrequency (%)
양재2동 21
33.9%
양재1동 15
24.2%
서초2동 7
 
11.3%
방배2동 5
 
8.1%
반포4동 4
 
6.5%
방배1동 3
 
4.8%
서초3동 2
 
3.2%
방배본동 2
 
3.2%
서초4동 1
 
1.6%
서초1동 1
 
1.6%

Length

2023-12-12T16:20:43.010336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
양재2동 21
33.9%
양재1동 15
24.2%
서초2동 7
 
11.3%
방배2동 5
 
8.1%
반포4동 4
 
6.5%
방배1동 3
 
4.8%
서초3동 2
 
3.2%
방배본동 2
 
3.2%
서초4동 1
 
1.6%
서초1동 1
 
1.6%

설치위치
Text

UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size628.0 B
2023-12-12T16:20:43.258888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length25
Mean length22.032258
Min length12

Characters and Unicode

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

Unique

Unique62 ?
Unique (%)100.0%

Sample

1st row교보타워(강남대로 465) 부지주차장 진입로 옆
2nd row엘타워 뒤 주차장 진입로 옆
3rd row서울가정행정법원 청사 출입계단 밑
4th row고속버스터미널역 3번출구 앞
5th row강남역 7번 출구와 8번출구 사이 보도 서초동 1319-5 앞
ValueCountFrequency (%)
앞 30
 
9.4%
보도 14
 
4.4%
건물 11
 
3.5%
옆 11
 
3.5%
서초동 7
 
2.2%
서초대로 5
 
1.6%
사이 5
 
1.6%
양재동 5
 
1.6%
녹지 4
 
1.3%
방배동 4
 
1.3%
Other values (180) 222
69.8%
2023-12-12T16:20:43.650865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
263
 
19.3%
1 46
 
3.4%
로 45
 
3.3%
2 37
 
2.7%
앞 32
 
2.3%
동 30
 
2.2%
3 26
 
1.9%
서 22
 
1.6%
- 22
 
1.6%
길 21
 
1.5%
Other values (189) 822
60.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 824
60.3%
Space Separator 263
 
19.3%
Decimal Number 224
 
16.4%
Dash Punctuation 22
 
1.6%
Open Punctuation 14
 
1.0%
Close Punctuation 14
 
1.0%
Uppercase Letter 5
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 45
 
5.5%
앞 32
 
3.9%
동 30
 
3.6%
서 22
 
2.7%
길 21
 
2.5%
도 20
 
2.4%
대 20
 
2.4%
구 19
 
2.3%
남 18
 
2.2%
지 18
 
2.2%
Other values (171) 579
70.3%
Decimal Number
ValueCountFrequency (%)
1 46
20.5%
2 37
16.5%
3 26
11.6%
7 20
8.9%
6 19
8.5%
8 18
 
8.0%
4 18
 
8.0%
5 16
 
7.1%
0 14
 
6.2%
9 10
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
A 2
40.0%
C 1
20.0%
U 1
20.0%
T 1
20.0%
Space Separator
ValueCountFrequency (%)
263
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 824
60.3%
Common 537
39.3%
Latin 5
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 45
 
5.5%
앞 32
 
3.9%
동 30
 
3.6%
서 22
 
2.7%
길 21
 
2.5%
도 20
 
2.4%
대 20
 
2.4%
구 19
 
2.3%
남 18
 
2.2%
지 18
 
2.2%
Other values (171) 579
70.3%
Common
ValueCountFrequency (%)
263
49.0%
1 46
 
8.6%
2 37
 
6.9%
3 26
 
4.8%
- 22
 
4.1%
7 20
 
3.7%
6 19
 
3.5%
8 18
 
3.4%
4 18
 
3.4%
5 16
 
3.0%
Other values (4) 52
 
9.7%
Latin
ValueCountFrequency (%)
A 2
40.0%
C 1
20.0%
U 1
20.0%
T 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 824
60.3%
ASCII 542
39.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
263
48.5%
1 46
 
8.5%
2 37
 
6.8%
3 26
 
4.8%
- 22
 
4.1%
7 20
 
3.7%
6 19
 
3.5%
8 18
 
3.3%
4 18
 
3.3%
5 16
 
3.0%
Other values (8) 57
 
10.5%
Hangul
ValueCountFrequency (%)
로 45
 
5.5%
앞 32
 
3.9%
동 30
 
3.6%
서 22
 
2.7%
길 21
 
2.5%
도 20
 
2.4%
대 20
 
2.4%
구 19
 
2.3%
남 18
 
2.2%
지 18
 
2.2%
Other values (171) 579
70.3%

설치주체
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size628.0 B
서초구보건소
40 
청소행정과
13 
센트럴시티
 
4
교보타워
 
1
엘타워
 
1
Other values (3)
 
3

Length

Max length6
Median length6
Mean length5.6129032
Min length3

Unique

Unique5 ?
Unique (%)8.1%

Sample

1st row교보타워
2nd row엘타워
3rd row서울가정법원
4th row센트럴시티
5th row서초구보건소

Common Values

ValueCountFrequency (%)
서초구보건소 40
64.5%
청소행정과 13
 
21.0%
센트럴시티 4
 
6.5%
교보타워 1
 
1.6%
엘타워 1
 
1.6%
서울가정법원 1
 
1.6%
서초구청 1
 
1.6%
우리동성개발 1
 
1.6%

Length

2023-12-12T16:20:43.804010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:20:43.912630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서초구보건소 40
64.5%
청소행정과 13
 
21.0%
센트럴시티 4
 
6.5%
교보타워 1
 
1.6%
엘타워 1
 
1.6%
서울가정법원 1
 
1.6%
서초구청 1
 
1.6%
우리동성개발 1
 
1.6%

청소관리
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size628.0 B
건강정책과
29 
청소행정과
22 
센트럴시티
4 
교보타워
 
1
엘타워
 
1
Other values (5)
5 

Length

Max length7
Median length5
Mean length5
Min length3

Unique

Unique7 ?
Unique (%)11.3%

Sample

1st row교보타워
2nd row엘타워
3rd row서울가정법원
4th row센트럴시티
5th row청소행정과

Common Values

ValueCountFrequency (%)
건강정책과 29
46.8%
청소행정과 22
35.5%
센트럴시티 4
 
6.5%
교보타워 1
 
1.6%
엘타워 1
 
1.6%
서울가정법원 1
 
1.6%
서희빌딩 1
 
1.6%
서초종합체육관 1
 
1.6%
행정지원과 1
 
1.6%
우리동성개발 1
 
1.6%

Length

2023-12-12T16:20:44.090468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:20:44.250296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건강정책과 29
46.8%
청소행정과 22
35.5%
센트럴시티 4
 
6.5%
교보타워 1
 
1.6%
엘타워 1
 
1.6%
서울가정법원 1
 
1.6%
서희빌딩 1
 
1.6%
서초종합체육관 1
 
1.6%
행정지원과 1
 
1.6%
우리동성개발 1
 
1.6%

설치일자
Date

Distinct25
Distinct (%)40.3%
Missing0
Missing (%)0.0%
Memory size628.0 B
Minimum2012-04-26 00:00:00
Maximum2022-03-28 00:00:00
2023-12-12T16:20:44.407431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:20:44.528261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct61
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.474936
Minimum37.350644
Maximum37.504492
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-12T16:20:44.691808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.350644
5-th percentile37.457347
Q137.469752
median37.476929
Q337.484904
95-th percentile37.498544
Maximum37.504492
Range0.153848
Interquartile range (IQR)0.01515175

Descriptive statistics

Standard deviation0.025773399
Coefficient of variation (CV)0.0006877503
Kurtosis16.609672
Mean37.474936
Median Absolute Deviation (MAD)0.0079695
Skewness-3.6781443
Sum2323.446
Variance0.00066426807
MonotonicityNot monotonic
2023-12-12T16:20:44.907982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.350644 2
 
3.2%
37.503756 1
 
1.6%
37.475954 1
 
1.6%
37.477888 1
 
1.6%
37.476097 1
 
1.6%
37.476852 1
 
1.6%
37.475894 1
 
1.6%
37.477276 1
 
1.6%
37.478945 1
 
1.6%
37.473707 1
 
1.6%
Other values (51) 51
82.3%
ValueCountFrequency (%)
37.350644 2
3.2%
37.446271 1
1.6%
37.457241 1
1.6%
37.459356 1
1.6%
37.460475 1
1.6%
37.466841 1
1.6%
37.467059 1
1.6%
37.467196 1
1.6%
37.467537 1
1.6%
37.467588 1
1.6%
ValueCountFrequency (%)
37.504492 1
1.6%
37.503935 1
1.6%
37.503756 1
1.6%
37.498608 1
1.6%
37.497326 1
1.6%
37.496637 1
1.6%
37.495624 1
1.6%
37.495347 1
1.6%
37.494104 1
1.6%
37.494003 1
1.6%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct61
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.02657
Minimum126.98245
Maximum127.05732
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-12T16:20:45.071661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.98245
5-th percentile126.98299
Q1127.01392
median127.03512
Q3127.04118
95-th percentile127.04829
Maximum127.05732
Range0.074878
Interquartile range (IQR)0.02726075

Descriptive statistics

Standard deviation0.021127538
Coefficient of variation (CV)0.00016632377
Kurtosis-0.24947607
Mean127.02657
Median Absolute Deviation (MAD)0.007665
Skewness-1.0184775
Sum7875.6475
Variance0.00044637288
MonotonicityNot monotonic
2023-12-12T16:20:45.299671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.006834 2
 
3.2%
127.02411 1
 
1.6%
126.982462 1
 
1.6%
127.03918 1
 
1.6%
127.039158 1
 
1.6%
127.038161 1
 
1.6%
127.035023 1
 
1.6%
127.036115 1
 
1.6%
127.03796 1
 
1.6%
127.048316 1
 
1.6%
Other values (51) 51
82.3%
ValueCountFrequency (%)
126.982446 1
1.6%
126.982462 1
1.6%
126.982937 1
1.6%
126.982987 1
1.6%
126.98302 1
1.6%
126.984933 1
1.6%
126.986544 1
1.6%
126.989952 1
1.6%
126.992181 1
1.6%
126.996886 1
1.6%
ValueCountFrequency (%)
127.057324 1
1.6%
127.050404 1
1.6%
127.048641 1
1.6%
127.048316 1
1.6%
127.047814 1
1.6%
127.045617 1
1.6%
127.044911 1
1.6%
127.044349 1
1.6%
127.043913 1
1.6%
127.042944 1
1.6%

비고
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size628.0 B
<NA>
53 
꽁초전용 수거함
9 

Length

Max length8
Median length4
Mean length4.5806452
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 53
85.5%
꽁초전용 수거함 9
 
14.5%

Length

2023-12-12T16:20:45.484800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:20:45.606086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 53
74.6%
꽁초전용 9
 
12.7%
수거함 9
 
12.7%

Interactions

2023-12-12T16:20:42.059915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:20:41.805257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:20:42.196943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:20:41.914418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:20:45.685929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
해당동설치위치설치주체청소관리설치일자위도경도
해당동1.0001.0000.7750.7680.9070.8800.907
설치위치1.0001.0001.0001.0001.0001.0001.000
설치주체0.7751.0001.0000.9861.0000.5570.591
청소관리0.7681.0000.9861.0001.0000.7040.779
설치일자0.9071.0001.0001.0001.0000.9340.906
위도0.8801.0000.5570.7040.9341.0000.908
경도0.9071.0000.5910.7790.9060.9081.000
2023-12-12T16:20:45.808463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
청소관리해당동설치주체비고
청소관리1.0000.4550.9361.000
해당동0.4551.0000.4961.000
설치주체0.9360.4961.0001.000
비고1.0001.0001.0001.000
2023-12-12T16:20:45.897122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도해당동설치주체청소관리비고
위도1.000-0.5730.6910.3720.3471.000
경도-0.5731.0000.6840.3230.3411.000
해당동0.6910.6841.0000.4960.4551.000
설치주체0.3720.3230.4961.0000.9361.000
청소관리0.3470.3410.4550.9361.0001.000
비고1.0001.0001.0001.0001.0001.000

Missing values

2023-12-12T16:20:42.459273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:20:42.626429image/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서초구서초4동교보타워(강남대로 465) 부지주차장 진입로 옆교보타워교보타워2012-04-2637.503756127.02411<NA>
1서초구양재1동엘타워 뒤 주차장 진입로 옆엘타워엘타워2015-04-1837.482767127.03495<NA>
2서초구양재1동서울가정행정법원 청사 출입계단 밑서울가정법원서울가정법원2015-06-0837.481245127.03619<NA>
3서초구반포4동고속버스터미널역 3번출구 앞센트럴시티센트럴시티2018-03-1637.504492127.007845<NA>
4서초구서초2동강남역 7번 출구와 8번출구 사이 보도 서초동 1319-5 앞서초구보건소청소행정과2018-08-2837.497326127.027281<NA>
5서초구방배1동방배역 3번출구 먹자골목 입구방배동 910-9 옆서초구보건소청소행정과2019-04-0337.48218126.996886<NA>
6서초구서초2동서초대로 78길 24 서초동 1327-5 스타벅스 앞서초구보건소청소행정과2019-04-2337.495624127.027723<NA>
7서초구서초2동서초대로 78길 42 서초동 1330-18 현대기림오피스텔 앞서초구보건소청소행정과2019-04-2337.494003127.028354<NA>
8서초구방배2동방배천복개도로 명동칼국수(방배동 450-14) 앞서초구보건소청소행정과2019-04-2637.477757126.982987<NA>
9서초구서초2동서희타워(서초동1366-4) 옆 이면도로서초구보건소서희빌딩2019-06-2437.484909127.032901<NA>
자치구명해당동설치위치설치주체청소관리설치일자위도경도비고
52서초구방배1동방배동 941-1 (서초대로 68) 아구랜드 앞청소행정과청소행정과2019-08-2637.486251126.989952<NA>
53서초구서초1동서초동 1679-8 (서초1교 밑 강남방면)청소행정과청소행정과2019-08-2637.495347127.021046<NA>
54서초구서초2동서초대로 398 삼성타운 A동 맞은편 따릉이 옆 2대청소행정과청소행정과2019-08-2637.496637127.025104<NA>
55서초구서초3동서초구 법원로2길 24( 서초동 1715-5)청소행정과청소행정과2019-06-1437.494104127.013248<NA>
56서초구내곡동청계산로 217 (신원동 214) CU편의점 앞청소행정과청소행정과2019-10-2237.446271127.057324<NA>
57서초구양재2동양재동 351-1 도토리편백집앞청소행정과청소행정과2019-10-2237.467537127.041653<NA>
58서초구양재1동중앙로 584 에비뉴클래식 (우면동 760)청소행정과청소행정과2019-10-2237.457241127.015931<NA>
59서초구양재2동양재동 349-27 블루핸즈 앞청소행정과청소행정과2019-10-2237.467059127.042944<NA>
60서초구서초2동서초동 1340-6 남강빌딩 흡연지역청소행정과청소행정과2020-05-1337.489195127.03136<NA>
61서초구양재1동우면동 18-1(2기동대 앞)청소행정과청소행정과2020-10-3037.472439127.030514<NA>