Overview

Dataset statistics

Number of variables5
Number of observations281
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.4 KiB
Average record size in memory41.5 B

Variable types

Numeric1
Categorical3
Text1

Dataset

Description인천광역시 서구의 쓰레기 무단투기 감시용 카메라(CCTV) 설치 현황에 관한 데이터로, 관리부서, 전화번호, 설치위치 등의 항목을 제공합니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15105069&srcSe=7661IVAWM27C61E190

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 unique valuesUnique

Reproduction

Analysis started2024-01-28 11:28:41.054987
Analysis finished2024-01-28 11:28:41.485932
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct281
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean141
Minimum1
Maximum281
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2024-01-28T20:28:41.536347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile15
Q171
median141
Q3211
95-th percentile267
Maximum281
Range280
Interquartile range (IQR)140

Descriptive statistics

Standard deviation81.261922
Coefficient of variation (CV)0.57632569
Kurtosis-1.2
Mean141
Median Absolute Deviation (MAD)70
Skewness0
Sum39621
Variance6603.5
MonotonicityStrictly increasing
2024-01-28T20:28:41.655151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
186 1
 
0.4%
192 1
 
0.4%
191 1
 
0.4%
190 1
 
0.4%
189 1
 
0.4%
188 1
 
0.4%
187 1
 
0.4%
185 1
 
0.4%
194 1
 
0.4%
Other values (271) 271
96.4%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
281 1
0.4%
280 1
0.4%
279 1
0.4%
278 1
0.4%
277 1
0.4%
276 1
0.4%
275 1
0.4%
274 1
0.4%
273 1
0.4%
272 1
0.4%

관리부서
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
연희동행정복지센터
30 
석남1동행정복지센터
26 
검암경서동행정복지센터
23 
오류왕길동행정복지센터
23 
가좌1동행정복지센터
21 
Other values (16)
158 

Length

Max length11
Median length10
Mean length10.02847
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row검암경서동행정복지센터
2nd row검암경서동행정복지센터
3rd row검암경서동행정복지센터
4th row검암경서동행정복지센터
5th row검암경서동행정복지센터

Common Values

ValueCountFrequency (%)
연희동행정복지센터 30
 
10.7%
석남1동행정복지센터 26
 
9.3%
검암경서동행정복지센터 23
 
8.2%
오류왕길동행정복지센터 23
 
8.2%
가좌1동행정복지센터 21
 
7.5%
신현원창동행정복지센터 16
 
5.7%
석남2동행정복지센터 16
 
5.7%
가좌2동행정복지센터 14
 
5.0%
원당동행정복지센터 13
 
4.6%
불로대곡동행정복지센터 12
 
4.3%
Other values (11) 87
31.0%

Length

2024-01-28T20:28:41.790463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
연희동행정복지센터 30
 
10.7%
석남1동행정복지센터 26
 
9.3%
검암경서동행정복지센터 23
 
8.2%
오류왕길동행정복지센터 23
 
8.2%
가좌1동행정복지센터 21
 
7.5%
신현원창동행정복지센터 16
 
5.7%
석남2동행정복지센터 16
 
5.7%
가좌2동행정복지센터 14
 
5.0%
원당동행정복지센터 13
 
4.6%
불로대곡동행정복지센터 12
 
4.3%
Other values (11) 87
31.0%

관리부서 전화번호
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
032-718-3560
30 
032-718-3880
26 
032-718-3520
23 
032-718-5120
21 
032-718-5440
17 
Other values (18)
164 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row032-718-3520
2nd row032-718-3520
3rd row032-718-3520
4th row032-718-3520
5th row032-718-3520

Common Values

ValueCountFrequency (%)
032-718-3560 30
 
10.7%
032-718-3880 26
 
9.3%
032-718-3520 23
 
8.2%
032-718-5120 21
 
7.5%
032-718-5440 17
 
6.0%
032-718-3840 16
 
5.7%
032-718-3920 16
 
5.7%
032-718-5160 14
 
5.0%
032-718-5360 13
 
4.6%
032-718-5320 12
 
4.3%
Other values (13) 93
33.1%

Length

2024-01-28T20:28:41.905867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
032-718-3560 30
 
10.7%
032-718-3880 26
 
9.3%
032-718-3520 23
 
8.2%
032-718-5120 21
 
7.5%
032-718-5440 17
 
6.0%
032-718-3840 16
 
5.7%
032-718-3920 16
 
5.7%
032-718-5160 14
 
5.0%
032-718-5360 13
 
4.6%
032-718-5320 12
 
4.3%
Other values (13) 93
33.1%

설치위치(주소)
Text

Distinct278
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2024-01-28T20:28:42.067995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length29
Mean length18.779359
Min length5

Characters and Unicode

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

Unique

Unique275 ?
Unique (%)97.9%

Sample

1st row승학로506번길 60
2nd row승학로434번길 1
3rd row경서로45번길4-5 씨티라이프B동앞
4th row경서로45번길4-5 씨티라이프B동앞
5th row경서로45번길4-5 칸타빌B동앞
ValueCountFrequency (%)
앞 69
 
6.7%
옆 27
 
2.6%
맞은편 15
 
1.5%
1 11
 
1.1%
가정로 10
 
1.0%
13 7
 
0.7%
7 7
 
0.7%
사이 7
 
0.7%
전봇대 7
 
0.7%
검단로 7
 
0.7%
Other values (648) 860
83.7%
2024-01-28T20:28:42.351928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
774
 
14.7%
1 341
 
6.5%
로 262
 
5.0%
길 211
 
4.0%
번 201
 
3.8%
2 194
 
3.7%
3 134
 
2.5%
4 114
 
2.2%
- 106
 
2.0%
앞 93
 
1.8%
Other values (324) 2847
54.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2916
55.3%
Decimal Number 1290
24.4%
Space Separator 774
 
14.7%
Dash Punctuation 106
 
2.0%
Close Punctuation 57
 
1.1%
Open Punctuation 57
 
1.1%
Other Punctuation 53
 
1.0%
Uppercase Letter 18
 
0.3%
Lowercase Letter 3
 
0.1%
Math Symbol 1
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 262
 
9.0%
길 211
 
7.2%
번 201
 
6.9%
앞 93
 
3.2%
동 93
 
3.2%
라 55
 
1.9%
빌 51
 
1.7%
주 50
 
1.7%
정 47
 
1.6%
가 46
 
1.6%
Other values (295) 1807
62.0%
Decimal Number
ValueCountFrequency (%)
1 341
26.4%
2 194
15.0%
3 134
 
10.4%
4 114
 
8.8%
5 88
 
6.8%
7 88
 
6.8%
6 87
 
6.7%
9 84
 
6.5%
0 82
 
6.4%
8 78
 
6.0%
Uppercase Letter
ValueCountFrequency (%)
B 6
33.3%
A 6
33.3%
F 2
 
11.1%
S 1
 
5.6%
G 1
 
5.6%
C 1
 
5.6%
H 1
 
5.6%
Lowercase Letter
ValueCountFrequency (%)
u 1
33.3%
c 1
33.3%
e 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 51
96.2%
& 2
 
3.8%
Space Separator
ValueCountFrequency (%)
774
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 106
100.0%
Close Punctuation
ValueCountFrequency (%)
) 57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 57
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2916
55.3%
Common 2340
44.3%
Latin 21
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 262
 
9.0%
길 211
 
7.2%
번 201
 
6.9%
앞 93
 
3.2%
동 93
 
3.2%
라 55
 
1.9%
빌 51
 
1.7%
주 50
 
1.7%
정 47
 
1.6%
가 46
 
1.6%
Other values (295) 1807
62.0%
Common
ValueCountFrequency (%)
774
33.1%
1 341
14.6%
2 194
 
8.3%
3 134
 
5.7%
4 114
 
4.9%
- 106
 
4.5%
5 88
 
3.8%
7 88
 
3.8%
6 87
 
3.7%
9 84
 
3.6%
Other values (9) 330
14.1%
Latin
ValueCountFrequency (%)
B 6
28.6%
A 6
28.6%
F 2
 
9.5%
u 1
 
4.8%
S 1
 
4.8%
G 1
 
4.8%
C 1
 
4.8%
H 1
 
4.8%
c 1
 
4.8%
e 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2916
55.3%
ASCII 2359
44.7%
Punctuation 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
774
32.8%
1 341
14.5%
2 194
 
8.2%
3 134
 
5.7%
4 114
 
4.8%
- 106
 
4.5%
5 88
 
3.7%
7 88
 
3.7%
6 87
 
3.7%
9 84
 
3.6%
Other values (17) 349
14.8%
Hangul
ValueCountFrequency (%)
로 262
 
9.0%
길 211
 
7.2%
번 201
 
6.9%
앞 93
 
3.2%
동 93
 
3.2%
라 55
 
1.9%
빌 51
 
1.7%
주 50
 
1.7%
정 47
 
1.6%
가 46
 
1.6%
Other values (295) 1807
62.0%
Punctuation
ValueCountFrequency (%)
’ 1
50.0%
‘ 1
50.0%

유형
Categorical

Distinct2
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
이동형
180 
고정형
101 

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 (%)
이동형 180
64.1%
고정형 101
35.9%

Length

2024-01-28T20:28:42.452080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:28:42.522688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
이동형 180
64.1%
고정형 101
35.9%

Interactions

2024-01-28T20:28:41.304711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T20:28:42.571483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관리부서관리부서 전화번호유형
번호1.0000.9760.9790.289
관리부서0.9761.0001.0000.255
관리부서 전화번호0.9791.0001.0000.280
유형0.2890.2550.2801.000
2024-01-28T20:28:42.639005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리부서 전화번호유형관리부서
관리부서 전화번호1.0000.2340.996
유형0.2341.0000.216
관리부서0.9960.2161.000
2024-01-28T20:28:42.704062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관리부서관리부서 전화번호유형
번호1.0000.8350.8500.200
관리부서0.8351.0000.9960.216
관리부서 전화번호0.8500.9961.0000.234
유형0.2000.2160.2341.000

Missing values

2024-01-28T20:28:41.386165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T20:28:41.457050image/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검암경서동행정복지센터032-718-3520승학로506번길 60고정형
12검암경서동행정복지센터032-718-3520승학로434번길 1고정형
23검암경서동행정복지센터032-718-3520경서로45번길4-5 씨티라이프B동앞고정형
34검암경서동행정복지센터032-718-3520경서로45번길4-5 씨티라이프B동앞고정형
45검암경서동행정복지센터032-718-3520경서로45번길4-5 칸타빌B동앞고정형
56검암경서동행정복지센터032-718-3520승학로506번안길57 해피하임빌103동앞고정형
67검암경서동행정복지센터032-718-3520경서로 14번길 30고정형
78검암경서동행정복지센터032-718-3520도요지로 190번길 15고정형
89검암경서동행정복지센터032-718-3520도요지로236번길 9-1고정형
910검암경서동행정복지센터032-718-3520승학로 497이동형
번호관리부서관리부서 전화번호설치위치(주소)유형
271272마전동행정복지센터032-718-5480마전동 1019 주차장이동형
272273마전동행정복지센터032-718-5480마전동 1019(공영주차장 부지와 완정로 7번길 사이)이동형
273274아라동행정복지센터032-718-5510바리미로 23 GS25 편의점 앞이동형
274275아라동행정복지센터032-718-5510이음5로 66(서영아너시티1차) 및 이음5로 65(금호어울림) 사잇길이동형
275276아라동행정복지센터032-718-5510원당동 507-3(쓰리엠 타워 앞)이동형
276277아라동행정복지센터032-718-5510원당동 480-2(선우프라자 앞)이동형
277278아라동행정복지센터032-718-5510당하동 152-2(파라곤 센트럴파크 앞 F1 점포주택 부지)이동형
278279아라동행정복지센터032-718-5510당하동 357-13(파라곤 센트럴파크 앞 F1 점포주택 부지)이동형
279280아라동행정복지센터032-718-5510원당동 95(검단2 고등학교 예정부지 공원 앞)이동형
280281아라동행정복지센터032-718-5510당하동 983-3(유승한내들 정문 상가 네이버오븐 앞)이동형