Overview

Dataset statistics

Number of variables5
Number of observations52
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory44.5 B

Variable types

Categorical1
Numeric2
Text2

Dataset

Description2023년 10월 현재 노원구서비스공단 운영 사업장 내 CCTV 설치 및 운영 현황입니다. 설치목적, 설치대수, 설치사업장주소, 보존기간 등을 확인하실 수 있습니다.
Author서울특별시노원구서비스공단
URLhttps://www.data.go.kr/data/15124600/fileData.do

Alerts

설치목적 is highly imbalanced (54.3%)Imbalance
설치위치 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:56:34.696451
Analysis finished2023-12-12 05:56:35.486353
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치목적
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size548.0 B
시설안전, 화재예방
47 
쓰레기 무단투기

Length

Max length10
Median length10
Mean length9.8076923
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시설안전, 화재예방
2nd row시설안전, 화재예방
3rd row시설안전, 화재예방
4th row시설안전, 화재예방
5th row시설안전, 화재예방

Common Values

ValueCountFrequency (%)
시설안전, 화재예방 47
90.4%
쓰레기 무단투기 5
 
9.6%

Length

2023-12-12T14:56:35.577562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:56:35.689995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시설안전 47
45.2%
화재예방 47
45.2%
쓰레기 5
 
4.8%
무단투기 5
 
4.8%

설치대수
Real number (ℝ)

Distinct21
Distinct (%)40.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.8846154
Minimum1
Maximum68
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2023-12-12T14:56:35.780282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median5.5
Q311
95-th percentile27.45
Maximum68
Range67
Interquartile range (IQR)9

Descriptive statistics

Standard deviation13.191878
Coefficient of variation (CV)1.3345869
Kurtosis10.752101
Mean9.8846154
Median Absolute Deviation (MAD)3.5
Skewness3.0600987
Sum514
Variance174.02564
MonotonicityNot monotonic
2023-12-12T14:56:35.897737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
2 9
17.3%
4 7
13.5%
1 6
11.5%
7 5
9.6%
8 3
 
5.8%
5 3
 
5.8%
6 3
 
5.8%
10 2
 
3.8%
17 2
 
3.8%
27 1
 
1.9%
Other values (11) 11
21.2%
ValueCountFrequency (%)
1 6
11.5%
2 9
17.3%
3 1
 
1.9%
4 7
13.5%
5 3
 
5.8%
6 3
 
5.8%
7 5
9.6%
8 3
 
5.8%
10 2
 
3.8%
14 1
 
1.9%
ValueCountFrequency (%)
68 1
1.9%
62 1
1.9%
28 1
1.9%
27 1
1.9%
23 1
1.9%
22 1
1.9%
20 1
1.9%
18 1
1.9%
17 2
3.8%
16 1
1.9%

설치위치
Text

UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-12T14:56:36.164139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length15.961538
Min length11

Characters and Unicode

Total characters830
Distinct characters106
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique52 ?
Unique (%)100.0%

Sample

1st row노원구민의전당 시설 내외부
2nd row초안산캠핑장 시설 내외부
3rd row더불어숲 시설 내외부
4th row중계구민체육센터 시설 내외부
5th row월계구민체육센터 시설 내외부
ValueCountFrequency (%)
내외부 35
22.3%
공영주차장 25
15.9%
거주자우선주차장 16
 
10.2%
시설 10
 
6.4%
상계동 9
 
5.7%
공릉동 3
 
1.9%
상계2동 2
 
1.3%
상계5동 2
 
1.3%
마들스포츠타운 2
 
1.3%
부설 1
 
0.6%
Other values (52) 52
33.1%
2023-12-12T14:56:36.502501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
 
12.7%
67
 
8.1%
44
 
5.3%
41
 
4.9%
37
 
4.5%
36
 
4.3%
36
 
4.3%
35
 
4.2%
27
 
3.3%
1 24
 
2.9%
Other values (96) 378
45.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 619
74.6%
Space Separator 105
 
12.7%
Decimal Number 90
 
10.8%
Dash Punctuation 16
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
67
 
10.8%
44
 
7.1%
41
 
6.6%
37
 
6.0%
36
 
5.8%
36
 
5.8%
35
 
5.7%
27
 
4.4%
20
 
3.2%
20
 
3.2%
Other values (84) 256
41.4%
Decimal Number
ValueCountFrequency (%)
1 24
26.7%
3 11
12.2%
5 10
11.1%
2 9
 
10.0%
4 9
 
10.0%
0 9
 
10.0%
6 7
 
7.8%
7 4
 
4.4%
8 4
 
4.4%
9 3
 
3.3%
Space Separator
ValueCountFrequency (%)
105
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 619
74.6%
Common 211
 
25.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
67
 
10.8%
44
 
7.1%
41
 
6.6%
37
 
6.0%
36
 
5.8%
36
 
5.8%
35
 
5.7%
27
 
4.4%
20
 
3.2%
20
 
3.2%
Other values (84) 256
41.4%
Common
ValueCountFrequency (%)
105
49.8%
1 24
 
11.4%
- 16
 
7.6%
3 11
 
5.2%
5 10
 
4.7%
2 9
 
4.3%
4 9
 
4.3%
0 9
 
4.3%
6 7
 
3.3%
7 4
 
1.9%
Other values (2) 7
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 619
74.6%
ASCII 211
 
25.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
49.8%
1 24
 
11.4%
- 16
 
7.6%
3 11
 
5.2%
5 10
 
4.7%
2 9
 
4.3%
4 9
 
4.3%
0 9
 
4.3%
6 7
 
3.3%
7 4
 
1.9%
Other values (2) 7
 
3.3%
Hangul
ValueCountFrequency (%)
67
 
10.8%
44
 
7.1%
41
 
6.6%
37
 
6.0%
36
 
5.8%
36
 
5.8%
35
 
5.7%
27
 
4.4%
20
 
3.2%
20
 
3.2%
Other values (84) 256
41.4%
Distinct50
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size548.0 B
2023-12-12T14:56:36.742159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length17.173077
Min length14

Characters and Unicode

Total characters893
Distinct characters43
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique48 ?
Unique (%)92.3%

Sample

1st row서울시 노원구 동일로 1229
2nd row서울시 노원구 마들로5가길 66-107
3rd row서울시 노원구 하계동 산16-26
4th row서울시 노원구 노원로22길 1
5th row서울시 노원구 월계로 298
ValueCountFrequency (%)
서울시 52
25.0%
노원구 52
25.0%
상계동 14
 
6.7%
하계동 4
 
1.9%
중계동 4
 
1.9%
덕릉로 3
 
1.4%
공릉동 3
 
1.4%
동일로 2
 
1.0%
상계5동 2
 
1.0%
750 2
 
1.0%
Other values (67) 70
33.7%
2023-12-12T14:56:37.111833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
156
17.5%
54
 
6.0%
53
 
5.9%
52
 
5.8%
52
 
5.8%
52
 
5.8%
52
 
5.8%
1 45
 
5.0%
36
 
4.0%
33
 
3.7%
Other values (33) 308
34.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 489
54.8%
Decimal Number 219
24.5%
Space Separator 156
 
17.5%
Dash Punctuation 29
 
3.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
54
11.0%
53
10.8%
52
10.6%
52
10.6%
52
10.6%
52
10.6%
36
7.4%
33
6.7%
22
 
4.5%
20
 
4.1%
Other values (21) 63
12.9%
Decimal Number
ValueCountFrequency (%)
1 45
20.5%
2 31
14.2%
3 24
11.0%
6 22
10.0%
5 22
10.0%
4 18
 
8.2%
0 18
 
8.2%
7 15
 
6.8%
9 13
 
5.9%
8 11
 
5.0%
Space Separator
ValueCountFrequency (%)
156
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 29
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 489
54.8%
Common 404
45.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
54
11.0%
53
10.8%
52
10.6%
52
10.6%
52
10.6%
52
10.6%
36
7.4%
33
6.7%
22
 
4.5%
20
 
4.1%
Other values (21) 63
12.9%
Common
ValueCountFrequency (%)
156
38.6%
1 45
 
11.1%
2 31
 
7.7%
- 29
 
7.2%
3 24
 
5.9%
6 22
 
5.4%
5 22
 
5.4%
4 18
 
4.5%
0 18
 
4.5%
7 15
 
3.7%
Other values (2) 24
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 489
54.8%
ASCII 404
45.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
156
38.6%
1 45
 
11.1%
2 31
 
7.7%
- 29
 
7.2%
3 24
 
5.9%
6 22
 
5.4%
5 22
 
5.4%
4 18
 
4.5%
0 18
 
4.5%
7 15
 
3.7%
Other values (2) 24
 
5.9%
Hangul
ValueCountFrequency (%)
54
11.0%
53
10.8%
52
10.6%
52
10.6%
52
10.6%
52
10.6%
36
7.4%
33
6.7%
22
 
4.5%
20
 
4.1%
Other values (21) 63
12.9%

보존기간
Real number (ℝ)

Distinct7
Distinct (%)13.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.076923
Minimum7
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2023-12-12T14:56:37.247903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile15
Q115
median15
Q315
95-th percentile27.25
Maximum30
Range23
Interquartile range (IQR)0

Descriptive statistics

Standard deviation4.2233996
Coefficient of variation (CV)0.2626995
Kurtosis5.9289461
Mean16.076923
Median Absolute Deviation (MAD)0
Skewness2.2570491
Sum836
Variance17.837104
MonotonicityNot monotonic
2023-12-12T14:56:37.343242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
15 44
84.6%
30 3
 
5.8%
7 1
 
1.9%
24 1
 
1.9%
20 1
 
1.9%
25 1
 
1.9%
10 1
 
1.9%
ValueCountFrequency (%)
7 1
 
1.9%
10 1
 
1.9%
15 44
84.6%
20 1
 
1.9%
24 1
 
1.9%
25 1
 
1.9%
30 3
 
5.8%
ValueCountFrequency (%)
30 3
 
5.8%
25 1
 
1.9%
24 1
 
1.9%
20 1
 
1.9%
15 44
84.6%
10 1
 
1.9%
7 1
 
1.9%

Interactions

2023-12-12T14:56:35.142278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:56:34.950640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:56:35.231831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:56:35.051587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:56:37.423123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치목적설치대수설치위치설치주소보존기간
설치목적1.0000.0001.0000.0000.000
설치대수0.0001.0001.0000.6760.900
설치위치1.0001.0001.0001.0001.000
설치주소0.0000.6761.0001.0000.602
보존기간0.0000.9001.0000.6021.000
2023-12-12T14:56:37.513469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치대수보존기간설치목적
설치대수1.0000.2030.000
보존기간0.2031.0000.000
설치목적0.0000.0001.000

Missing values

2023-12-12T14:56:35.345677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:56:35.446459image/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시설안전, 화재예방27노원구민의전당 시설 내외부서울시 노원구 동일로 122915
1시설안전, 화재예방7초안산캠핑장 시설 내외부서울시 노원구 마들로5가길 66-10730
2시설안전, 화재예방7더불어숲 시설 내외부서울시 노원구 하계동 산16-267
3시설안전, 화재예방62중계구민체육센터 시설 내외부서울시 노원구 노원로22길 124
4시설안전, 화재예방68월계구민체육센터 시설 내외부서울시 노원구 월계로 29820
5시설안전, 화재예방16수락산스포츠타운 시설 내외부서울시 노원구 수락산로8나길 1030
6시설안전, 화재예방10마들스포츠타운 시설 내외부서울시 노원구 덕릉로 45025
7시설안전, 화재예방28불암산스포츠타운 시설 내외부서울시 노원구 중계로 3610
8시설안전, 화재예방8월계배드민턴장 시설 내외부서울시 노원구 마들로5가길 11315
9시설안전, 화재예방7당고개배드민턴장 시설 내외부서울시 노원구 상계로 27330
설치목적설치대수설치위치설치주소보존기간
42시설안전, 화재예방2거주자우선주차장 상계5동 152-2서울시 노원구 상계5동 152-215
43시설안전, 화재예방4거주자우선주차장 상계5동 138-40서울시 노원구 상계5동 138-4015
44시설안전, 화재예방4거주자우선주차장 공릉동 517-99서울시 노원구 공릉동 517-9915
45시설안전, 화재예방5거주자우선주차장 하계동 161-1서울시 노원구 하계동 161-115
46시설안전, 화재예방6거주자우선주차장 월계동 320-3서울시 노원구 월계동 320-315
47쓰레기 무단투기1거주자우선주차장 공릉동 408-208서울시 노원구 공릉동 408-20815
48쓰레기 무단투기1거주자우선주차장 상계동 750서울시 노원구 상계동 75015
49쓰레기 무단투기1거주자우선주차장 상계동 436-3서울시 노원구 상계동 436-315
50쓰레기 무단투기2거주자우선주차장 상계동 111-266서울시 노원구 상계동 111-26615
51쓰레기 무단투기1거주자우선주차장 상계동 319-1서울시 노원구 상계동 319-115