Overview

Dataset statistics

Number of variables5
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory43.1 B

Variable types

Text2
Categorical3

Dataset

Description인천광역시 부평구 무단투기단속 고정형CCTV현황 데이터는 CCTV 설치동, 설치장소, 설치일자 등에 대한 데이터를 제공합니다.
URLhttps://www.data.go.kr/data/15102518/fileData.do

Alerts

관리번호 has unique valuesUnique
설치장소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:44:48.054361
Analysis finished2023-12-12 00:44:48.528954
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T09:44:48.732627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.7857143
Min length2

Characters and Unicode

Total characters117
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st rowA1
2nd rowA2
3rd rowA4
4th rowA5
5th rowA6
ValueCountFrequency (%)
a1 1
 
2.4%
a26 1
 
2.4%
a37 1
 
2.4%
a29 1
 
2.4%
a19 1
 
2.4%
a20 1
 
2.4%
a21 1
 
2.4%
a22 1
 
2.4%
a23 1
 
2.4%
a24 1
 
2.4%
Other values (32) 32
76.2%
2023-12-12T09:44:49.175369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 42
35.9%
1 15
 
12.8%
2 15
 
12.8%
3 14
 
12.0%
4 7
 
6.0%
8 4
 
3.4%
5 4
 
3.4%
6 4
 
3.4%
0 4
 
3.4%
7 4
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 75
64.1%
Uppercase Letter 42
35.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 15
20.0%
2 15
20.0%
3 14
18.7%
4 7
9.3%
8 4
 
5.3%
5 4
 
5.3%
6 4
 
5.3%
0 4
 
5.3%
7 4
 
5.3%
9 4
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
A 42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 75
64.1%
Latin 42
35.9%

Most frequent character per script

Common
ValueCountFrequency (%)
1 15
20.0%
2 15
20.0%
3 14
18.7%
4 7
9.3%
8 4
 
5.3%
5 4
 
5.3%
6 4
 
5.3%
0 4
 
5.3%
7 4
 
5.3%
9 4
 
5.3%
Latin
ValueCountFrequency (%)
A 42
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 117
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 42
35.9%
1 15
 
12.8%
2 15
 
12.8%
3 14
 
12.0%
4 7
 
6.0%
8 4
 
3.4%
5 4
 
3.4%
6 4
 
3.4%
0 4
 
3.4%
7 4
 
3.4%

설치동
Categorical

Distinct17
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Memory size468.0 B
부평2동
6 
십정1동
4 
십정2동
3 
부평5동
3 
삼산1동
3 
Other values (12)
23 

Length

Max length4
Median length4
Mean length3.952381
Min length3

Unique

Unique2 ?
Unique (%)4.8%

Sample

1st row부평1동
2nd row부평1동
3rd row부평2동
4th row부평2동
5th row부평2동

Common Values

ValueCountFrequency (%)
부평2동 6
14.3%
십정1동 4
 
9.5%
십정2동 3
 
7.1%
부평5동 3
 
7.1%
삼산1동 3
 
7.1%
청천1동 3
 
7.1%
부평6동 2
 
4.8%
청천2동 2
 
4.8%
부평3동 2
 
4.8%
부평4동 2
 
4.8%
Other values (7) 12
28.6%

Length

2023-12-12T09:44:49.330984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부평2동 6
14.3%
십정1동 4
 
9.5%
십정2동 3
 
7.1%
부평5동 3
 
7.1%
삼산1동 3
 
7.1%
청천1동 3
 
7.1%
산곡1동 2
 
4.8%
갈산1동 2
 
4.8%
일신동 2
 
4.8%
부평1동 2
 
4.8%
Other values (7) 12
28.6%

설치장소
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T09:44:49.633885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length31
Mean length26.238095
Min length16

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row인천광역시 부평구 부평동 341-137 (우주렌터카 부평점 옆)
2nd row인천광역시 부평구 부흥로267번길 25(CU편의점 앞)
3rd row인천광역시 부평구 경인로902번길 12 (파라다이스맨션 옆)
4th row인천광역시 부평구 경인로818번길 21 (보성빌라 A동 앞)
5th row인천광역시 부평구 경인로911번길 39(삼거리 한전 전못대 왼편)
ValueCountFrequency (%)
인천광역시 42
 
19.1%
부평구 42
 
19.1%
앞 12
 
5.5%
코너 4
 
1.8%
옆 3
 
1.4%
78 2
 
0.9%
21 2
 
0.9%
6 2
 
0.9%
부흥북로 2
 
0.9%
10 2
 
0.9%
Other values (105) 107
48.6%
2023-12-12T09:44:50.174380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
179
 
16.2%
부 58
 
5.3%
평 49
 
4.4%
인 48
 
4.4%
천 47
 
4.3%
1 47
 
4.3%
역 43
 
3.9%
구 42
 
3.8%
시 42
 
3.8%
광 42
 
3.8%
Other values (121) 505
45.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 685
62.2%
Space Separator 179
 
16.2%
Decimal Number 179
 
16.2%
Close Punctuation 21
 
1.9%
Open Punctuation 21
 
1.9%
Dash Punctuation 12
 
1.1%
Uppercase Letter 4
 
0.4%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 58
 
8.5%
평 49
 
7.2%
인 48
 
7.0%
천 47
 
6.9%
역 43
 
6.3%
구 42
 
6.1%
시 42
 
6.1%
광 42
 
6.1%
로 38
 
5.5%
길 26
 
3.8%
Other values (102) 250
36.5%
Decimal Number
ValueCountFrequency (%)
1 47
26.3%
2 24
13.4%
3 20
11.2%
4 17
 
9.5%
6 16
 
8.9%
9 13
 
7.3%
0 11
 
6.1%
7 11
 
6.1%
8 10
 
5.6%
5 10
 
5.6%
Uppercase Letter
ValueCountFrequency (%)
U 1
25.0%
C 1
25.0%
B 1
25.0%
A 1
25.0%
Space Separator
ValueCountFrequency (%)
179
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 685
62.2%
Common 413
37.5%
Latin 4
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 58
 
8.5%
평 49
 
7.2%
인 48
 
7.0%
천 47
 
6.9%
역 43
 
6.3%
구 42
 
6.1%
시 42
 
6.1%
광 42
 
6.1%
로 38
 
5.5%
길 26
 
3.8%
Other values (102) 250
36.5%
Common
ValueCountFrequency (%)
179
43.3%
1 47
 
11.4%
2 24
 
5.8%
) 21
 
5.1%
( 21
 
5.1%
3 20
 
4.8%
4 17
 
4.1%
6 16
 
3.9%
9 13
 
3.1%
- 12
 
2.9%
Other values (5) 43
 
10.4%
Latin
ValueCountFrequency (%)
U 1
25.0%
C 1
25.0%
B 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 685
62.2%
ASCII 417
37.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
179
42.9%
1 47
 
11.3%
2 24
 
5.8%
) 21
 
5.0%
( 21
 
5.0%
3 20
 
4.8%
4 17
 
4.1%
6 16
 
3.8%
9 13
 
3.1%
- 12
 
2.9%
Other values (9) 47
 
11.3%
Hangul
ValueCountFrequency (%)
부 58
 
8.5%
평 49
 
7.2%
인 48
 
7.0%
천 47
 
6.9%
역 43
 
6.3%
구 42
 
6.1%
시 42
 
6.1%
광 42
 
6.1%
로 38
 
5.5%
길 26
 
3.8%
Other values (102) 250
36.5%

설치일자(신규)
Categorical

Distinct14
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size468.0 B
2004-07-09
8 
2008-05-16
8 
2009-06-26
8 
2008-01-25
4 
2018-01-15
3 
Other values (9)
11 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique7 ?
Unique (%)16.7%

Sample

1st row2004-07-09
2nd row2007-05-01
3rd row2008-05-16
4th row2008-01-25
5th row2008-05-16

Common Values

ValueCountFrequency (%)
2004-07-09 8
19.0%
2008-05-16 8
19.0%
2009-06-26 8
19.0%
2008-01-25 4
9.5%
2018-01-15 3
 
7.1%
2007-05-01 2
 
4.8%
2013-11-24 2
 
4.8%
2006-10-25 1
 
2.4%
2005-05-03 1
 
2.4%
2012-03-31 1
 
2.4%
Other values (4) 4
9.5%

Length

2023-12-12T09:44:50.356527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2004-07-09 8
19.0%
2008-05-16 8
19.0%
2009-06-26 8
19.0%
2008-01-25 4
9.5%
2018-01-15 3
 
7.1%
2007-05-01 2
 
4.8%
2013-11-24 2
 
4.8%
2006-10-25 1
 
2.4%
2005-05-03 1
 
2.4%
2012-03-31 1
 
2.4%
Other values (4) 4
9.5%

설치일자(기존)
Categorical

Distinct15
Distinct (%)35.7%
Missing0
Missing (%)0.0%
Memory size468.0 B
2020-12-18
7 
2021-08-06
5 
<NA>
5 
2017-12-15
5 
2018-08-20
4 
Other values (10)
16 

Length

Max length10
Median length10
Mean length9.2857143
Min length4

Unique

Unique5 ?
Unique (%)11.9%

Sample

1st row2021-08-06
2nd row2013-11-24
3rd row2015-12-17
4th row2012-03-31
5th row2022-11-17

Common Values

ValueCountFrequency (%)
2020-12-18 7
16.7%
2021-08-06 5
11.9%
<NA> 5
11.9%
2017-12-15 5
11.9%
2018-08-20 4
9.5%
2015-12-17 3
7.1%
2013-11-24 2
 
4.8%
2016-10-26 2
 
4.8%
2008-11-17 2
 
4.8%
2011-05-04 2
 
4.8%
Other values (5) 5
11.9%

Length

2023-12-12T09:44:50.515976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2020-12-18 7
16.7%
2021-08-06 5
11.9%
na 5
11.9%
2017-12-15 5
11.9%
2018-08-20 4
9.5%
2015-12-17 3
7.1%
2013-11-24 2
 
4.8%
2016-10-26 2
 
4.8%
2008-11-17 2
 
4.8%
2011-05-04 2
 
4.8%
Other values (5) 5
11.9%

Correlations

2023-12-12T09:44:50.627596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호설치동설치장소설치일자(신규)설치일자(기존)
관리번호1.0001.0001.0001.0001.000
설치동1.0001.0001.0000.7080.000
설치장소1.0001.0001.0001.0001.000
설치일자(신규)1.0000.7081.0001.0000.000
설치일자(기존)1.0000.0001.0000.0001.000
2023-12-12T09:44:50.760378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치동설치일자(기존)설치일자(신규)
설치동1.0000.0000.291
설치일자(기존)0.0001.0000.000
설치일자(신규)0.2910.0001.000
2023-12-12T09:44:50.882834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치동설치일자(신규)설치일자(기존)
설치동1.0000.2910.000
설치일자(신규)0.2911.0000.000
설치일자(기존)0.0000.0001.000

Missing values

2023-12-12T09:44:48.369023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:44:48.478144image/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

관리번호설치동설치장소설치일자(신규)설치일자(기존)
0A1부평1동인천광역시 부평구 부평동 341-137 (우주렌터카 부평점 옆)2004-07-092021-08-06
1A2부평1동인천광역시 부평구 부흥로267번길 25(CU편의점 앞)2007-05-012013-11-24
2A4부평2동인천광역시 부평구 경인로902번길 12 (파라다이스맨션 옆)2008-05-162015-12-17
3A5부평2동인천광역시 부평구 경인로818번길 21 (보성빌라 A동 앞)2008-01-252012-03-31
4A6부평2동인천광역시 부평구 경인로911번길 39(삼거리 한전 전못대 왼편)2008-05-162022-11-17
5A40부평2동인천광역시 부평구 남부역로5번길 462018-01-15<NA>
6A41부평2동인천광역시 부평구 안남로16번길 312018-01-15<NA>
7A42부평2동인천광역시 부평구 부영로31번길 32018-01-15<NA>
8A7부평3동인천광역시 부평구 마장로 432008-05-162020-12-18
9A28부평3동인천광역시 부평구 백운로6번길 22006-10-252020-12-18
관리번호설치동설치장소설치일자(신규)설치일자(기존)
32A30부개3동인천광역시 부평구 부흥북로 1192007-05-182018-08-20
33A31일신동인천광역시 부평구 경인로1118번길 28-1 (풍림아파트 앞)2008-01-25<NA>
34A32일신동인천광역시 부평구 일신동 175-23 (항동공원 앞)2004-07-092008-11-17
35A33십정1동인천광역시 부평구 배곶로69번길 102008-01-252021-08-06
36A34십정1동인천광역시 부평구 배곶로 79-1 (꿈나무어린이집 앞)2008-05-162011-05-04
37A35십정1동인천광역시 부평구 십정동 356-6 (방죽놀이공원 코너)2007-05-012017-12-15
38A39십정1동인천광역시 부평구 이규보로61번길 452009-11-202020-12-18
39A36십정2동인천광역시 부평구 백범로478번길 19 (일산슈퍼 앞, 석정공원 코너)2009-06-262016-10-26
40A37십정2동인천광역시 부평구 아트센터로74번길 78 (에덴빌라 B동 옆)2008-05-162009-06-26
41A38십정2동인천광역시 부평구 배곶북로 14-12009-06-262011-05-04