Overview

Dataset statistics

Number of variables19
Number of observations116
Missing cells20
Missing cells (%)0.9%
Duplicate rows1
Duplicate rows (%)0.9%
Total size in memory17.6 KiB
Average record size in memory155.1 B

Variable types

Categorical11
Text3
Numeric2
Boolean3

Dataset

Description화성도시공사에서 관리하고 있는 안심비상벨 현황입니다. 설치목적, 설치장소유형, 설치위치, 소재지도로명주소, 소재지지번주소, 위도, 경도, 연계방식, 경찰연계유무, 관리사무소연계유무를 확인할 수 있습니다.
Author화성도시공사
URLhttps://www.data.go.kr/data/15127054/fileData.do

Alerts

경비업체연계유무 has constant value ""Constant
최종점검결과구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 1 (0.9%) duplicate rowsDuplicates
부서명 is highly overall correlated with 경도 and 10 other fieldsHigh correlation
안전비상벨설치연도 is highly overall correlated with 부서명 and 6 other fieldsHigh correlation
최종점검일자 is highly overall correlated with 부서명 and 3 other fieldsHigh correlation
설치장소유형 is highly overall correlated with 경도 and 6 other fieldsHigh correlation
관리기관명 is highly overall correlated with 부서명 and 4 other fieldsHigh correlation
부가기능 is highly overall correlated with 부서명 and 9 other fieldsHigh correlation
관리기관전화번호 is highly overall correlated with 경도 and 10 other fieldsHigh correlation
연계방식 is highly overall correlated with 경도 and 7 other fieldsHigh correlation
설치목적 is highly overall correlated with 부서명 and 6 other fieldsHigh correlation
경찰연계유무 is highly overall correlated with 부서명 and 6 other fieldsHigh correlation
경도 is highly overall correlated with 부서명 and 3 other fieldsHigh correlation
관리사무소연계유무 is highly overall correlated with 부서명 and 4 other fieldsHigh correlation
안전비상벨설치연도 is highly imbalanced (53.9%)Imbalance
최종점검일자 is highly imbalanced (63.3%)Imbalance
소재지도로명주소 has 20 (17.2%) missing valuesMissing

Reproduction

Analysis started2024-03-23 06:52:49.035696
Analysis finished2024-03-23 06:53:02.160157
Duration13.12 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

부서명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
공원관리2부
43 
공원관리1부
40 
우정체육센터부
12 
반월체육센터
8 
체육시설1부
7 
Other values (2)
6 

Length

Max length7
Median length6
Mean length6.112069
Min length6

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row체육시설1부
2nd row체육시설1부
3rd row체육시설1부
4th row체육시설1부
5th row체육시설1부

Common Values

ValueCountFrequency (%)
공원관리2부 43
37.1%
공원관리1부 40
34.5%
우정체육센터부 12
 
10.3%
반월체육센터 8
 
6.9%
체육시설1부 7
 
6.0%
주차운영1부 5
 
4.3%
그린환경센터부 1
 
0.9%

Length

2024-03-23T06:53:02.392961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:02.895722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공원관리2부 43
37.1%
공원관리1부 40
34.5%
우정체육센터부 12
 
10.3%
반월체육센터 8
 
6.9%
체육시설1부 7
 
6.0%
주차운영1부 5
 
4.3%
그린환경센터부 1
 
0.9%

설치목적
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
방범용
96 
약자보호
12 
방범용, 안전사고 예방
 
8

Length

Max length12
Median length3
Mean length3.7241379
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row방범용
2nd row방범용
3rd row방범용
4th row방범용
5th row방범용

Common Values

ValueCountFrequency (%)
방범용 96
82.8%
약자보호 12
 
10.3%
방범용, 안전사고 예방 8
 
6.9%

Length

2024-03-23T06:53:03.492213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:03.926634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
방범용 104
78.8%
약자보호 12
 
9.1%
안전사고 8
 
6.1%
예방 8
 
6.1%

설치장소유형
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
화장실
73 
공원
43 

Length

Max length3
Median length3
Mean length2.6293103
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row화장실
2nd row화장실
3rd row화장실
4th row화장실
5th row화장실

Common Values

ValueCountFrequency (%)
화장실 73
62.9%
공원 43
37.1%

Length

2024-03-23T06:53:04.315431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:04.718080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화장실 73
62.9%
공원 43
37.1%

설치위치
Text

Distinct105
Distinct (%)90.5%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-23T06:53:05.418345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length9.6724138
Min length4

Characters and Unicode

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

Unique

Unique104 ?
Unique (%)89.7%

Sample

1st row나래울 배드민턴장
2nd row수질복원센터 화장실
3rd row크린에너지센터 화장실
4th row예당마을 테니스장
5th row금반저류지 테니스장
ValueCountFrequency (%)
화성남부국민체육센터 12
 
6.2%
근린공원 8
 
4.1%
반월체육센터 8
 
4.1%
1층 6
 
3.1%
한빛공영주차장 5
 
2.6%
지하2층 4
 
2.1%
남자화장실 4
 
2.1%
화장실 4
 
2.1%
어린이공원 3
 
1.5%
전곡공원 3
 
1.5%
Other values (123) 137
70.6%
2024-03-23T06:53:07.538141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
공 94
 
8.4%
원 87
 
7.8%
84
 
7.5%
체 36
 
3.2%
육 36
 
3.2%
장 35
 
3.1%
화 32
 
2.9%
터 27
 
2.4%
센 26
 
2.3%
1 24
 
2.1%
Other values (176) 641
57.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 947
84.4%
Space Separator 84
 
7.5%
Decimal Number 49
 
4.4%
Close Punctuation 21
 
1.9%
Open Punctuation 20
 
1.8%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 94
 
9.9%
원 87
 
9.2%
체 36
 
3.8%
육 36
 
3.8%
장 35
 
3.7%
화 32
 
3.4%
터 27
 
2.9%
센 26
 
2.7%
호 23
 
2.4%
남 23
 
2.4%
Other values (166) 528
55.8%
Decimal Number
ValueCountFrequency (%)
1 24
49.0%
2 16
32.7%
3 4
 
8.2%
4 3
 
6.1%
5 1
 
2.0%
6 1
 
2.0%
Space Separator
ValueCountFrequency (%)
84
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 947
84.4%
Common 175
 
15.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 94
 
9.9%
원 87
 
9.2%
체 36
 
3.8%
육 36
 
3.8%
장 35
 
3.7%
화 32
 
3.4%
터 27
 
2.9%
센 26
 
2.7%
호 23
 
2.4%
남 23
 
2.4%
Other values (166) 528
55.8%
Common
ValueCountFrequency (%)
84
48.0%
1 24
 
13.7%
) 21
 
12.0%
( 20
 
11.4%
2 16
 
9.1%
3 4
 
2.3%
4 3
 
1.7%
5 1
 
0.6%
6 1
 
0.6%
. 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 947
84.4%
ASCII 175
 
15.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
공 94
 
9.9%
원 87
 
9.2%
체 36
 
3.8%
육 36
 
3.8%
장 35
 
3.7%
화 32
 
3.4%
터 27
 
2.9%
센 26
 
2.7%
호 23
 
2.4%
남 23
 
2.4%
Other values (166) 528
55.8%
ASCII
ValueCountFrequency (%)
84
48.0%
1 24
 
13.7%
) 21
 
12.0%
( 20
 
11.4%
2 16
 
9.1%
3 4
 
2.3%
4 3
 
1.7%
5 1
 
0.6%
6 1
 
0.6%
. 1
 
0.6%

소재지도로명주소
Text

MISSING 

Distinct69
Distinct (%)71.9%
Missing20
Missing (%)17.2%
Memory size1.0 KiB
2024-03-23T06:53:08.195532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length23
Mean length18.947917
Min length13

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)63.5%

Sample

1st row경기도 화성시 여울로2길 33-2
2nd row경기도 화성시 동탄산단7길 38
3rd row경기도 화성시 동탄대로9길 76
4th row경기도 화성시 동탄신리천로 221
5th row경기도 화성시 병점중앙로 227
ValueCountFrequency (%)
화성시 95
21.5%
경기 52
 
11.8%
경기도 43
 
9.7%
우정읍 14
 
3.2%
쌍봉로 12
 
2.7%
109-10 12
 
2.7%
새솔동 8
 
1.8%
봉담읍 8
 
1.8%
향남읍 8
 
1.8%
92 8
 
1.8%
Other values (128) 182
41.2%
2024-03-23T06:53:09.629375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
346
19.0%
기 98
 
5.4%
화 97
 
5.3%
성 96
 
5.3%
경 95
 
5.2%
시 95
 
5.2%
1 87
 
4.8%
2 68
 
3.7%
0 50
 
2.7%
도 46
 
2.5%
Other values (90) 741
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1051
57.8%
Decimal Number 376
 
20.7%
Space Separator 346
 
19.0%
Dash Punctuation 33
 
1.8%
Other Punctuation 11
 
0.6%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 98
 
9.3%
화 97
 
9.2%
성 96
 
9.1%
경 95
 
9.0%
시 95
 
9.0%
도 46
 
4.4%
로 36
 
3.4%
동 34
 
3.2%
리 34
 
3.2%
읍 33
 
3.1%
Other values (75) 387
36.8%
Decimal Number
ValueCountFrequency (%)
1 87
23.1%
2 68
18.1%
0 50
13.3%
9 31
 
8.2%
4 28
 
7.4%
7 26
 
6.9%
3 23
 
6.1%
6 23
 
6.1%
5 20
 
5.3%
8 20
 
5.3%
Space Separator
ValueCountFrequency (%)
346
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 33
100.0%
Other Punctuation
ValueCountFrequency (%)
, 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1051
57.8%
Common 768
42.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 98
 
9.3%
화 97
 
9.2%
성 96
 
9.1%
경 95
 
9.0%
시 95
 
9.0%
도 46
 
4.4%
로 36
 
3.4%
동 34
 
3.2%
리 34
 
3.2%
읍 33
 
3.1%
Other values (75) 387
36.8%
Common
ValueCountFrequency (%)
346
45.1%
1 87
 
11.3%
2 68
 
8.9%
0 50
 
6.5%
- 33
 
4.3%
9 31
 
4.0%
4 28
 
3.6%
7 26
 
3.4%
3 23
 
3.0%
6 23
 
3.0%
Other values (5) 53
 
6.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1051
57.8%
ASCII 768
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
346
45.1%
1 87
 
11.3%
2 68
 
8.9%
0 50
 
6.5%
- 33
 
4.3%
9 31
 
4.0%
4 28
 
3.6%
7 26
 
3.4%
3 23
 
3.0%
6 23
 
3.0%
Other values (5) 53
 
6.9%
Hangul
ValueCountFrequency (%)
기 98
 
9.3%
화 97
 
9.2%
성 96
 
9.1%
경 95
 
9.0%
시 95
 
9.0%
도 46
 
4.4%
로 36
 
3.4%
동 34
 
3.2%
리 34
 
3.2%
읍 33
 
3.1%
Other values (75) 387
36.8%

소재지지번주소
Text

Distinct86
Distinct (%)74.1%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-23T06:53:10.868624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length24.5
Mean length17.827586
Min length13

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)64.7%

Sample

1st row경기도 화성시 능동 1128
2nd row경기도 화성시 방교동 795
3rd row경기도 화성시 송동 681-244
4th row경기도 화성시 석우동 58
5th row경기도 화성시 반송동 635
ValueCountFrequency (%)
화성시 115
21.5%
경기도 64
 
11.9%
경기 50
 
9.3%
우정읍 14
 
2.6%
조암리 13
 
2.4%
반송동 13
 
2.4%
385 12
 
2.2%
반월동 10
 
1.9%
새솔동 8
 
1.5%
968 8
 
1.5%
Other values (146) 229
42.7%
2024-03-23T06:53:12.568074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
420
20.3%
화 117
 
5.7%
기 116
 
5.6%
경 115
 
5.6%
시 115
 
5.6%
성 115
 
5.6%
1 82
 
4.0%
동 74
 
3.6%
도 67
 
3.2%
8 66
 
3.2%
Other values (91) 781
37.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1150
55.6%
Decimal Number 445
 
21.5%
Space Separator 420
 
20.3%
Dash Punctuation 34
 
1.6%
Other Punctuation 17
 
0.8%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
화 117
 
10.2%
기 116
 
10.1%
경 115
 
10.0%
시 115
 
10.0%
성 115
 
10.0%
동 74
 
6.4%
도 67
 
5.8%
리 46
 
4.0%
읍 33
 
2.9%
반 23
 
2.0%
Other values (76) 329
28.6%
Decimal Number
ValueCountFrequency (%)
1 82
18.4%
8 66
14.8%
5 42
9.4%
6 42
9.4%
3 41
9.2%
4 41
9.2%
2 38
8.5%
7 37
8.3%
0 34
7.6%
9 22
 
4.9%
Space Separator
ValueCountFrequency (%)
420
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1150
55.6%
Common 918
44.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
화 117
 
10.2%
기 116
 
10.1%
경 115
 
10.0%
시 115
 
10.0%
성 115
 
10.0%
동 74
 
6.4%
도 67
 
5.8%
리 46
 
4.0%
읍 33
 
2.9%
반 23
 
2.0%
Other values (76) 329
28.6%
Common
ValueCountFrequency (%)
420
45.8%
1 82
 
8.9%
8 66
 
7.2%
5 42
 
4.6%
6 42
 
4.6%
3 41
 
4.5%
4 41
 
4.5%
2 38
 
4.1%
7 37
 
4.0%
- 34
 
3.7%
Other values (5) 75
 
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1150
55.6%
ASCII 918
44.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
420
45.8%
1 82
 
8.9%
8 66
 
7.2%
5 42
 
4.6%
6 42
 
4.6%
3 41
 
4.5%
4 41
 
4.5%
2 38
 
4.1%
7 37
 
4.0%
- 34
 
3.7%
Other values (5) 75
 
8.2%
Hangul
ValueCountFrequency (%)
화 117
 
10.2%
기 116
 
10.1%
경 115
 
10.0%
시 115
 
10.0%
성 115
 
10.0%
동 74
 
6.4%
도 67
 
5.8%
리 46
 
4.0%
읍 33
 
2.9%
반 23
 
2.0%
Other values (76) 329
28.6%

위도
Real number (ℝ)

Distinct91
Distinct (%)78.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.184959
Minimum37.044579
Maximum38.257343
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-03-23T06:53:13.180451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.044579
5-th percentile37.089543
Q137.12225
median37.18853
Q337.215047
95-th percentile37.275682
Maximum38.257343
Range1.2127642
Interquartile range (IQR)0.092796775

Descriptive statistics

Standard deviation0.11486909
Coefficient of variation (CV)0.0030891277
Kurtosis66.655847
Mean37.184959
Median Absolute Deviation (MAD)0.03694225
Skewness7.1083408
Sum4313.4553
Variance0.013194907
MonotonicityNot monotonic
2024-03-23T06:53:13.912100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.089543 12
 
10.3%
37.2304766 8
 
6.9%
37.1221 5
 
4.3%
37.1223 2
 
1.7%
37.2831154 2
 
1.7%
37.2771137 2
 
1.7%
37.219221 1
 
0.9%
37.199447 1
 
0.9%
37.205135 1
 
0.9%
37.180724 1
 
0.9%
Other values (81) 81
69.8%
ValueCountFrequency (%)
37.0445793 1
 
0.9%
37.0742319 1
 
0.9%
37.0894443 1
 
0.9%
37.089543 12
10.3%
37.089944 1
 
0.9%
37.103 1
 
0.9%
37.1032 1
 
0.9%
37.1037161 1
 
0.9%
37.1056314 1
 
0.9%
37.1056574 1
 
0.9%
ValueCountFrequency (%)
38.2573435 1
 
0.9%
37.2831154 2
 
1.7%
37.2790664 1
 
0.9%
37.2771137 2
 
1.7%
37.2752043 1
 
0.9%
37.2573435 1
 
0.9%
37.2488368 1
 
0.9%
37.233066 1
 
0.9%
37.2304766 8
6.9%
37.2277972 1
 
0.9%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct92
Distinct (%)79.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.97551
Minimum126.65492
Maximum127.84907
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-03-23T06:53:14.640138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.65492
5-th percentile126.75856
Q1126.83031
median127.03224
Q3127.07554
95-th percentile127.11601
Maximum127.84907
Range1.1941492
Interquartile range (IQR)0.24523417

Descriptive statistics

Standard deviation0.15118742
Coefficient of variation (CV)0.0011906818
Kurtosis8.3488338
Mean126.97551
Median Absolute Deviation (MAD)0.079006
Skewness1.2280072
Sum14729.159
Variance0.022857637
MonotonicityNot monotonic
2024-03-23T06:53:15.243235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.816483 12
 
10.3%
127.053452 8
 
6.9%
127.0425 5
 
4.3%
126.8170442 2
 
1.7%
126.8223164 2
 
1.7%
127.03 1
 
0.9%
127.078163 1
 
0.9%
127.077708 1
 
0.9%
127.075434 1
 
0.9%
127.089934 1
 
0.9%
Other values (82) 82
70.7%
ValueCountFrequency (%)
126.6549242 1
 
0.9%
126.6666237 1
 
0.9%
126.6767122 1
 
0.9%
126.677632 1
 
0.9%
126.7302514 1
 
0.9%
126.752417 1
 
0.9%
126.7606123 1
 
0.9%
126.7717889 1
 
0.9%
126.7901387 1
 
0.9%
126.816483 12
10.3%
ValueCountFrequency (%)
127.8490734 1
0.9%
127.125401 1
0.9%
127.124269 1
0.9%
127.121492 1
0.9%
127.121366 1
0.9%
127.117279 1
0.9%
127.115587 1
0.9%
127.112617 1
0.9%
127.112196 1
0.9%
127.111258 1
0.9%

연계방식
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
단방향
64 
양방향
40 
미연계
12 

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 (%)
단방향 64
55.2%
양방향 40
34.5%
미연계 12
 
10.3%

Length

2024-03-23T06:53:15.910462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:16.451477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
단방향 64
55.2%
양방향 40
34.5%
미연계 12
 
10.3%

경찰연계유무
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size248.0 B
True
88 
False
28 
ValueCountFrequency (%)
True 88
75.9%
False 28
 
24.1%
2024-03-23T06:53:16.744411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

경비업체연계유무
Boolean

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size248.0 B
False
116 
ValueCountFrequency (%)
False 116
100.0%
2024-03-23T06:53:17.081102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

관리사무소연계유무
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
N
70 
Y
38 
Y(안내데스크 연계)
 
6
Y(운영사무실 연계)
 
2

Length

Max length11
Median length1
Mean length1.6896552
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowY
2nd rowY
3rd rowY
4th rowY
5th rowY

Common Values

ValueCountFrequency (%)
N 70
60.3%
Y 38
32.8%
Y(안내데스크 연계) 6
 
5.2%
Y(운영사무실 연계) 2
 
1.7%

Length

2024-03-23T06:53:17.461541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:17.821892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
n 70
56.5%
y 38
30.6%
연계 8
 
6.5%
y(안내데스크 6
 
4.8%
y(운영사무실 2
 
1.6%

부가기능
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
경보음+경보등
40 
경보등+경보음+CCTV
32 
경보등+경보음
19 
경보음
12 
경보음+CCTV
7 
Other values (2)
6 

Length

Max length12
Median length7
Mean length7.9051724
Min length3

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row경보음+CCTV
2nd row경보음+CCTV
3rd row경보음+CCTV
4th row경보음+CCTV
5th row경보음+CCTV

Common Values

ValueCountFrequency (%)
경보음+경보등 40
34.5%
경보등+경보음+CCTV 32
27.6%
경보등+경보음 19
16.4%
경보음 12
 
10.3%
경보음+CCTV 7
 
6.0%
<NA> 5
 
4.3%
경보음+경보위치 1
 
0.9%

Length

2024-03-23T06:53:18.344924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:18.958328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경보음+경보등 40
34.5%
경보등+경보음+cctv 32
27.6%
경보등+경보음 19
16.4%
경보음 12
 
10.3%
경보음+cctv 7
 
6.0%
na 5
 
4.3%
경보음+경보위치 1
 
0.9%

안전비상벨설치연도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct8
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
<NA>
82 
2021
21 
2023
 
7
2017
 
2
2014
 
1
Other values (3)
 
3

Length

Max length12
Median length4
Mean length4.0689655
Min length4

Unique

Unique4 ?
Unique (%)3.4%

Sample

1st row2014
2nd row2017
3rd row2017
4th row2013
5th row2008

Common Values

ValueCountFrequency (%)
<NA> 82
70.7%
2021 21
 
18.1%
2023 7
 
6.0%
2017 2
 
1.7%
2014 1
 
0.9%
2013 1
 
0.9%
2008 1
 
0.9%
경보등+경보음+CCTV 1
 
0.9%

Length

2024-03-23T06:53:19.680176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:20.256876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 82
70.7%
2021 21
 
18.1%
2023 7
 
6.0%
2017 2
 
1.7%
2014 1
 
0.9%
2013 1
 
0.9%
2008 1
 
0.9%
경보등+경보음+cctv 1
 
0.9%

최종점검일자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-12-31
104 
<NA>
 
7
2023-12-01
 
5

Length

Max length10
Median length10
Mean length9.637931
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 (%)
2023-12-31 104
89.7%
<NA> 7
 
6.0%
2023-12-01 5
 
4.3%

Length

2024-03-23T06:53:20.747026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:21.109722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 104
89.7%
na 7
 
6.0%
2023-12-01 5
 
4.3%

최종점검결과구분
Boolean

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size248.0 B
True
116 
ValueCountFrequency (%)
True 116
100.0%
2024-03-23T06:53:21.367132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

관리기관명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
화성도시공사
76 
화성도시공사
39 
화성도시공사 그린환경센터부
 
1

Length

Max length14
Median length6
Mean length6.4051724
Min length6

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row화성도시공사
2nd row화성도시공사
3rd row화성도시공사
4th row화성도시공사
5th row화성도시공사

Common Values

ValueCountFrequency (%)
화성도시공사 76
65.5%
화성도시공사 39
33.6%
화성도시공사 그린환경센터부 1
 
0.9%

Length

2024-03-23T06:53:21.828569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:22.187073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화성도시공사 116
99.1%
그린환경센터부 1
 
0.9%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
031-8059-6432
43 
031-5189-6961
40 
031-351-9514
12 
031-273-0530
8 
031-352-4251
7 
Other values (2)
6 

Length

Max length13
Median length13
Mean length12.758621
Min length12

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row031-352-4251
2nd row031-352-4251
3rd row031-352-4251
4th row031-352-4251
5th row031-352-4251

Common Values

ValueCountFrequency (%)
031-8059-6432 43
37.1%
031-5189-6961 40
34.5%
031-351-9514 12
 
10.3%
031-273-0530 8
 
6.9%
031-352-4251 7
 
6.0%
031-8059-6538 5
 
4.3%
031-227-7670 1
 
0.9%

Length

2024-03-23T06:53:22.533368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:22.780242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-8059-6432 43
37.1%
031-5189-6961 40
34.5%
031-351-9514 12
 
10.3%
031-273-0530 8
 
6.9%
031-352-4251 7
 
6.0%
031-8059-6538 5
 
4.3%
031-227-7670 1
 
0.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2023-12-31
116 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-31
2nd row2023-12-31
3rd row2023-12-31
4th row2023-12-31
5th row2023-12-31

Common Values

ValueCountFrequency (%)
2023-12-31 116
100.0%

Length

2024-03-23T06:53:23.171649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T06:53:23.519728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 116
100.0%

Interactions

2024-03-23T06:52:59.992088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:52:59.343770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:53:00.264060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:52:59.724919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T06:53:23.793740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서명설치목적설치장소유형소재지도로명주소소재지지번주소위도경도연계방식경찰연계유무관리사무소연계유무부가기능안전비상벨설치연도최종점검일자관리기관명관리기관전화번호
부서명1.0001.0001.0000.9971.0000.5890.6901.0001.0000.8150.9980.7951.0000.9301.000
설치목적1.0001.0000.2001.0001.0000.6560.5100.9480.5390.7330.9780.6630.0000.4881.000
설치장소유형1.0000.2001.0001.0001.0000.0430.6900.4400.5920.2390.9881.0000.1430.3411.000
소재지도로명주소0.9971.0001.0001.0001.0000.5400.9390.9990.9880.0000.9951.0001.0001.0000.997
소재지지번주소1.0001.0001.0001.0001.0000.4260.9291.0001.0000.0001.0001.0001.0000.9981.000
위도0.5890.6560.0430.5400.4261.0000.7350.7110.2430.4010.7770.2820.1770.3850.589
경도0.6900.5100.6900.9390.9290.7351.0000.6500.2420.1910.6410.2550.0920.5290.690
연계방식1.0000.9480.4400.9991.0000.7110.6501.0000.4160.4781.0000.4130.0970.8611.000
경찰연계유무1.0000.5390.5920.9881.0000.2430.2420.4161.0000.9150.9810.7440.0000.2501.000
관리사무소연계유무0.8150.7330.2390.0000.0000.4010.1910.4780.9151.0000.7100.6530.4590.2580.815
부가기능0.9980.9780.9880.9951.0000.7770.6411.0000.9810.7101.0000.748NaN0.9980.998
안전비상벨설치연도0.7950.6631.0001.0001.0000.2820.2550.4130.7440.6530.7481.0001.0000.5550.795
최종점검일자1.0000.0000.1431.0001.0000.1770.0920.0970.0000.459NaN1.0001.0000.1601.000
관리기관명0.9300.4880.3411.0000.9980.3850.5290.8610.2500.2580.9980.5550.1601.0000.930
관리기관전화번호1.0001.0001.0000.9971.0000.5890.6901.0001.0000.8150.9980.7951.0000.9301.000
2024-03-23T06:53:24.521138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서명안전비상벨설치연도최종점검일자설치장소유형관리기관명관리사무소연계유무부가기능관리기관전화번호연계방식설치목적경찰연계유무
부서명1.0000.6140.9810.9780.9290.7110.9251.0000.9820.9820.978
안전비상벨설치연도0.6141.0000.9800.9190.4080.4830.5770.6140.4010.5260.739
최종점검일자0.9810.9801.0000.0910.2620.3071.0000.9810.1600.0000.000
설치장소유형0.9780.9190.0911.0000.5430.1570.8860.9780.6820.3260.403
관리기관명0.9290.4080.2620.5431.0000.2450.9280.9290.5490.1950.406
관리사무소연계유무0.7110.4830.3070.1570.2451.0000.5370.7110.4730.7740.730
부가기능0.9250.5771.0000.8860.9280.5371.0000.9250.9860.8070.860
관리기관전화번호1.0000.6140.9810.9780.9290.7110.9251.0000.9820.9820.978
연계방식0.9820.4010.1600.6820.5490.4730.9860.9821.0000.7190.649
설치목적0.9820.5260.0000.3260.1950.7740.8070.9820.7191.0000.802
경찰연계유무0.9780.7390.0000.4030.4060.7300.8600.9780.6490.8021.000
2024-03-23T06:53:25.222032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도부서명설치목적설치장소유형연계방식경찰연계유무관리사무소연계유무부가기능안전비상벨설치연도최종점검일자관리기관명관리기관전화번호
위도1.0000.2580.4720.3170.0710.3670.3940.3900.4490.2680.2900.1390.472
경도0.2581.0000.5320.4420.8130.6100.2910.1550.4980.1470.1100.4640.532
부서명0.4720.5321.0000.9820.9780.9820.9780.7110.9250.6140.9810.9291.000
설치목적0.3170.4420.9821.0000.3260.7190.8020.7740.8070.5260.0000.1950.982
설치장소유형0.0710.8130.9780.3261.0000.6820.4030.1570.8860.9190.0910.5430.978
연계방식0.3670.6100.9820.7190.6821.0000.6490.4730.9860.4010.1600.5490.982
경찰연계유무0.3940.2910.9780.8020.4030.6491.0000.7300.8600.7390.0000.4060.978
관리사무소연계유무0.3900.1550.7110.7740.1570.4730.7301.0000.5370.4830.3070.2450.711
부가기능0.4490.4980.9250.8070.8860.9860.8600.5371.0000.5771.0000.9280.925
안전비상벨설치연도0.2680.1470.6140.5260.9190.4010.7390.4830.5771.0000.9800.4080.614
최종점검일자0.2900.1100.9810.0000.0910.1600.0000.3071.0000.9801.0000.2620.981
관리기관명0.1390.4640.9290.1950.5430.5490.4060.2450.9280.4080.2621.0000.929
관리기관전화번호0.4720.5321.0000.9820.9780.9820.9780.7110.9250.6140.9810.9291.000

Missing values

2024-03-23T06:53:00.698032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T06:53:01.696647image/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체육시설1부방범용화장실나래울 배드민턴장경기도 화성시 여울로2길 33-2경기도 화성시 능동 112837.1223127.03단방향NNY경보음+CCTV2014<NA>Y화성도시공사031-352-42512023-12-31
1체육시설1부방범용화장실수질복원센터 화장실경기도 화성시 동탄산단7길 38경기도 화성시 방교동 79537.1032127.051단방향NNY경보음+CCTV2017<NA>Y화성도시공사031-352-42512023-12-31
2체육시설1부방범용화장실크린에너지센터 화장실경기도 화성시 동탄대로9길 76경기도 화성시 송동 681-24437.103127.0549단방향NNY경보음+CCTV2017<NA>Y화성도시공사031-352-42512023-12-31
3체육시설1부방범용화장실예당마을 테니스장<NA>경기도 화성시 석우동 5837.1223127.0438단방향NNY경보음+CCTV2013<NA>Y화성도시공사031-352-42512023-12-31
4체육시설1부방범용화장실금반저류지 테니스장<NA>경기도 화성시 반송동 63537.1104127.0458단방향NNY경보음+CCTV2008<NA>Y화성도시공사031-352-42512023-12-31
5체육시설1부방범용화장실화성시 실내배드민턴장경기도 화성시 동탄신리천로 221경기도 화성시 오산동 1041-137.1107127.0616단방향NNY경보음+CCTV2023<NA>Y화성도시공사031-352-42512023-12-31
6체육시설1부방범용화장실다람산공원 다목적체육관경기도 화성시 병점중앙로 227경기도 화성시 진안동 14137.1258127.0158단방향NNY경보음+CCTV2023<NA>Y화성도시공사031-352-42512023-12-31
7주차운영1부방범용화장실한빛공영주차장 지하1층 남자화장실경기도 화성시 동탄중심상가2길 21경기도 화성시 반송동 88-737.1221127.0425단방향YNY<NA>20232023-12-01Y화성도시공사031-8059-65382023-12-31
8주차운영1부방범용화장실한빛공영주차장 지하2층 남자화장실경기도 화성시 동탄중심상가2길 21경기도 화성시 반송동 88-737.1221127.0425단방향YNY<NA>20232023-12-01Y화성도시공사031-8059-65382023-12-31
9주차운영1부방범용화장실한빛공영주차장 지하2층 여자화장실경기도 화성시 동탄중심상가2길 21경기도 화성시 반송동 88-737.1221127.0425단방향YNY<NA>20232023-12-01Y화성도시공사031-8059-65382023-12-31
부서명설치목적설치장소유형설치위치소재지도로명주소소재지지번주소위도경도연계방식경찰연계유무경비업체연계유무관리사무소연계유무부가기능안전비상벨설치연도최종점검일자최종점검결과구분관리기관명관리기관전화번호데이터기준일자
106공원관리1부방범용화장실신리천공원1<NA>경기도 화성시 오산동 1082, 1085, 1044-1, 1046-137.183777127.104156양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
107공원관리1부방범용화장실신리천공원2<NA>경기도 화성시 오산동 1082, 1085, 1044-1, 1046-137.183144127.112617양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
108공원관리1부방범용화장실신리천공원3<NA>경기도 화성시 목동 444-8337.183047127.117279양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
109공원관리1부방범용화장실신리천공원4<NA>경기도 화성시 목동 444-8337.181702127.121492양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
110공원관리1부방범용화장실송동공원1<NA>경기도 화성시 장지동 106837.163311127.100577양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
111공원관리1부방범용화장실송동공원2<NA>경기도 화성시 장지동 106637.162112127.105001양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
112공원관리1부방범용화장실장지1호공원<NA>경기도 화성시 산척동 78337.164112127.115587양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
113공원관리1부방범용화장실장지체육공원<NA>경기도 화성시 장지동 97437.159733127.111233양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
114공원관리1부방범용화장실왕배산1호공원경기도 화성시 동탄대로12길 102경기도 화성시 산척동 75337.176775127.112196양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31
115공원관리1부방범용화장실왕배산체육공원<NA>경기도 화성시 목동 산10737.179558127.124269양방향YNN경보음+경보등<NA>2023-12-31Y화성도시공사031-5189-69612023-12-31

Duplicate rows

Most frequently occurring

부서명설치목적설치장소유형설치위치소재지도로명주소소재지지번주소위도경도연계방식경찰연계유무경비업체연계유무관리사무소연계유무부가기능안전비상벨설치연도최종점검일자최종점검결과구분관리기관명관리기관전화번호데이터기준일자# duplicates
0우정체육센터부약자보호화장실화성남부국민체육센터경기도 화성시 우정읍 쌍봉로 109-10경기도 화성시 우정읍 조암리 38537.089543126.816483미연계NNY경보음20212023-12-31Y화성도시공사031-351-95142023-12-3112