Overview

Dataset statistics

Number of variables5
Number of observations28
Missing cells5
Missing cells (%)3.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory44.7 B

Variable types

Text3
DateTime2

Dataset

Description괴산군 CCTV 중 비상벨이 설치되어 있는 CCTV의 비상벨 사용 현황 및 모니터링 현황을 정리함, 총 27대이며 비상벨 설치현황에 따라 추후에 업데이트 될 예정임
Author충청북도 괴산군
URLhttps://www.data.go.kr/data/15091341/fileData.do

Alerts

비상벨 발생시간 has constant value ""Constant
데이터기준일자 has constant value ""Constant
비상벨 cctv 명칭 has 1 (3.6%) missing valuesMissing
설치주소 has 1 (3.6%) missing valuesMissing
위치정보 has 1 (3.6%) missing valuesMissing
비상벨 발생시간 has 1 (3.6%) missing valuesMissing
데이터기준일자 has 1 (3.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 17:24:55.609569
Analysis finished2023-12-12 17:24:56.233735
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

비상벨 cctv 명칭
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:24:56.415151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row 15-C01
2nd row 15-C02
3rd row 15-C03
4th row 15-C04
5th row 15-C05
ValueCountFrequency (%)
15-c01 1
 
3.7%
15-c15 1
 
3.7%
21-061 1
 
3.7%
21-060 1
 
3.7%
21-059 1
 
3.7%
21-058 1
 
3.7%
16-c07 1
 
3.7%
16-c06 1
 
3.7%
16-c05 1
 
3.7%
16-c04 1
 
3.7%
Other values (17) 17
63.0%
2023-12-13T02:24:56.818240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 37
19.6%
27
14.3%
- 27
14.3%
0 23
12.2%
C 22
11.6%
5 20
10.6%
6 12
 
6.3%
2 9
 
4.8%
3 3
 
1.6%
4 3
 
1.6%
Other values (3) 6
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 113
59.8%
Space Separator 27
 
14.3%
Dash Punctuation 27
 
14.3%
Uppercase Letter 22
 
11.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 37
32.7%
0 23
20.4%
5 20
17.7%
6 12
 
10.6%
2 9
 
8.0%
3 3
 
2.7%
4 3
 
2.7%
7 2
 
1.8%
8 2
 
1.8%
9 2
 
1.8%
Space Separator
ValueCountFrequency (%)
27
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%
Uppercase Letter
ValueCountFrequency (%)
C 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 167
88.4%
Latin 22
 
11.6%

Most frequent character per script

Common
ValueCountFrequency (%)
1 37
22.2%
27
16.2%
- 27
16.2%
0 23
13.8%
5 20
12.0%
6 12
 
7.2%
2 9
 
5.4%
3 3
 
1.8%
4 3
 
1.8%
7 2
 
1.2%
Other values (2) 4
 
2.4%
Latin
ValueCountFrequency (%)
C 22
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 189
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 37
19.6%
27
14.3%
- 27
14.3%
0 23
12.2%
C 22
11.6%
5 20
10.6%
6 12
 
6.3%
2 9
 
4.8%
3 3
 
1.6%
4 3
 
1.6%
Other values (3) 6
 
3.2%

설치주소
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:24:57.038484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length12.555556
Min length11

Characters and Unicode

Total characters339
Distinct characters44
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

Unique27 ?
Unique (%)100.0%

Sample

1st row괴산읍 서부리 407-2
2nd row괴산읍 서부리 385-1
3rd row괴산읍 동부리 686-1
4th row괴산읍 서부리 288-10
5th row괴산읍 서부리 294-22
ValueCountFrequency (%)
괴산읍 16
 
19.8%
서부리 7
 
8.6%
청천면 4
 
4.9%
검승리 3
 
3.7%
송면리 2
 
2.5%
읍내로10길 2
 
2.5%
청안면 2
 
2.5%
읍내리 2
 
2.5%
청천리 2
 
2.5%
468-2 1
 
1.2%
Other values (40) 40
49.4%
2023-12-13T02:24:57.452472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
59
17.4%
읍 23
 
6.8%
리 23
 
6.8%
2 21
 
6.2%
괴 16
 
4.7%
산 16
 
4.7%
- 16
 
4.7%
면 13
 
3.8%
1 13
 
3.8%
8 12
 
3.5%
Other values (34) 127
37.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 167
49.3%
Decimal Number 97
28.6%
Space Separator 59
 
17.4%
Dash Punctuation 16
 
4.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
읍 23
13.8%
리 23
13.8%
괴 16
 
9.6%
산 16
 
9.6%
면 13
 
7.8%
청 8
 
4.8%
부 8
 
4.8%
서 7
 
4.2%
내 7
 
4.2%
천 6
 
3.6%
Other values (22) 40
24.0%
Decimal Number
ValueCountFrequency (%)
2 21
21.6%
1 13
13.4%
8 12
12.4%
4 10
10.3%
6 10
10.3%
3 8
 
8.2%
7 6
 
6.2%
0 6
 
6.2%
5 6
 
6.2%
9 5
 
5.2%
Space Separator
ValueCountFrequency (%)
59
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 172
50.7%
Hangul 167
49.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
읍 23
13.8%
리 23
13.8%
괴 16
 
9.6%
산 16
 
9.6%
면 13
 
7.8%
청 8
 
4.8%
부 8
 
4.8%
서 7
 
4.2%
내 7
 
4.2%
천 6
 
3.6%
Other values (22) 40
24.0%
Common
ValueCountFrequency (%)
59
34.3%
2 21
 
12.2%
- 16
 
9.3%
1 13
 
7.6%
8 12
 
7.0%
4 10
 
5.8%
6 10
 
5.8%
3 8
 
4.7%
7 6
 
3.5%
0 6
 
3.5%
Other values (2) 11
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 172
50.7%
Hangul 167
49.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
59
34.3%
2 21
 
12.2%
- 16
 
9.3%
1 13
 
7.6%
8 12
 
7.0%
4 10
 
5.8%
6 10
 
5.8%
3 8
 
4.7%
7 6
 
3.5%
0 6
 
3.5%
Other values (2) 11
 
6.4%
Hangul
ValueCountFrequency (%)
읍 23
13.8%
리 23
13.8%
괴 16
 
9.6%
산 16
 
9.6%
면 13
 
7.8%
청 8
 
4.8%
부 8
 
4.8%
서 7
 
4.2%
내 7
 
4.2%
천 6
 
3.6%
Other values (22) 40
24.0%

위치정보
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:24:57.654991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length15
Mean length12.407407
Min length6

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row동인초 금산방문요양센터 앞
2nd row동인초 괴산군일자리종합지원센터 앞
3rd row동인초 CU앞 사거리
4th row명덕초 태광아파트 지하주차장 옆
5th row명덕초 모아빌 앞 사거리
ValueCountFrequency (%)
앞 17
20.2%
동인초 4
 
4.8%
사거리 4
 
4.8%
삼거리 3
 
3.6%
명덕초 3
 
3.6%
성불산생태공원 3
 
3.6%
정문 2
 
2.4%
송면초 2
 
2.4%
청천초 2
 
2.4%
후문 2
 
2.4%
Other values (39) 42
50.0%
2023-12-13T02:24:58.026720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
57
 
17.0%
앞 19
 
5.7%
초 15
 
4.5%
사 8
 
2.4%
원 8
 
2.4%
리 8
 
2.4%
공 8
 
2.4%
동 7
 
2.1%
거 7
 
2.1%
산 7
 
2.1%
Other values (99) 191
57.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 274
81.8%
Space Separator 57
 
17.0%
Uppercase Letter 2
 
0.6%
Close Punctuation 1
 
0.3%
Open Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 19
 
6.9%
초 15
 
5.5%
사 8
 
2.9%
원 8
 
2.9%
리 8
 
2.9%
공 8
 
2.9%
동 7
 
2.6%
거 7
 
2.6%
산 7
 
2.6%
인 6
 
2.2%
Other values (94) 181
66.1%
Uppercase Letter
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%
Space Separator
ValueCountFrequency (%)
57
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 274
81.8%
Common 59
 
17.6%
Latin 2
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 19
 
6.9%
초 15
 
5.5%
사 8
 
2.9%
원 8
 
2.9%
리 8
 
2.9%
공 8
 
2.9%
동 7
 
2.6%
거 7
 
2.6%
산 7
 
2.6%
인 6
 
2.2%
Other values (94) 181
66.1%
Common
ValueCountFrequency (%)
57
96.6%
) 1
 
1.7%
( 1
 
1.7%
Latin
ValueCountFrequency (%)
U 1
50.0%
C 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 274
81.8%
ASCII 61
 
18.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
57
93.4%
) 1
 
1.6%
( 1
 
1.6%
U 1
 
1.6%
C 1
 
1.6%
Hangul
ValueCountFrequency (%)
앞 19
 
6.9%
초 15
 
5.5%
사 8
 
2.9%
원 8
 
2.9%
리 8
 
2.9%
공 8
 
2.9%
동 7
 
2.6%
거 7
 
2.6%
산 7
 
2.6%
인 6
 
2.2%
Other values (94) 181
66.1%

비상벨 발생시간
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)3.7%
Missing1
Missing (%)3.6%
Memory size356.0 B
Minimum2023-12-13 00:00:00
Maximum2023-12-13 00:00:00
2023-12-13T02:24:58.158114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:24:58.242390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)3.7%
Missing1
Missing (%)3.6%
Memory size356.0 B
Minimum2021-09-30 00:00:00
Maximum2021-09-30 00:00:00
2023-12-13T02:24:58.348549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:24:58.437028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-13T02:24:58.497736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비상벨 cctv 명칭설치주소위치정보
비상벨 cctv 명칭1.0001.0001.000
설치주소1.0001.0001.000
위치정보1.0001.0001.000

Missing values

2023-12-13T02:24:55.876213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:24:56.026607image/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.
2023-12-13T02:24:56.156520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

비상벨 cctv 명칭설치주소위치정보비상벨 발생시간데이터기준일자
015-C01괴산읍 서부리 407-2동인초 금산방문요양센터 앞00:002021-09-30
115-C02괴산읍 서부리 385-1동인초 괴산군일자리종합지원센터 앞00:002021-09-30
215-C03괴산읍 동부리 686-1동인초 CU앞 사거리00:002021-09-30
315-C04괴산읍 서부리 288-10명덕초 태광아파트 지하주차장 옆00:002021-09-30
415-C05괴산읍 서부리 294-22명덕초 모아빌 앞 사거리00:002021-09-30
515-C06괴산읍 서부리 298-5괴산명가 앞 사거리00:002021-09-30
615-C07사리면 사담리 482보광초 정문 입구00:002021-09-30
715-C08청안면 읍내리 229-1청안초 후문 통학버스 탑승장00:002021-09-30
815-C09청안면 읍내리 286청안초 청안중 옆 사거리00:002021-09-30
915-C10청천면 청천리 78-2청천초 후문주변 사택 앞 골목길00:002021-09-30
비상벨 cctv 명칭설치주소위치정보비상벨 발생시간데이터기준일자
1816-C04칠성면 도정리 212-4칠성소공원(역사공원)00:002021-09-30
1916-C05괴산읍 검승리 237-4성불산생태공원 상부 생태연못00:002021-09-30
2016-C06괴산읍 검승리 254성불산생태공원 상부 어린이놀이터00:002021-09-30
2116-C07괴산읍 검승리 263-1성불산생태공원 동화나라놀이터00:002021-09-30
2221-058괴산읍 읍내로10길 3상신종합약국 앞00:002021-09-30
2321-059괴산읍 읍내로9길 4제중당약국 앞00:002021-09-30
2421-060괴산읍 읍내로6길 2동인공인중개사 앞00:002021-09-30
2521-061괴산읍 읍내로8길 19사또족발 앞00:002021-09-30
2621-062괴산읍 읍내로10길 22덕평상회 앞00:002021-09-30
27<NA><NA><NA><NA><NA>