Overview

Dataset statistics

Number of variables11
Number of observations10000
Missing cells12279
Missing cells (%)11.2%
Duplicate rows164
Duplicate rows (%)1.6%
Total size in memory976.6 KiB
Average record size in memory100.0 B

Variable types

Text3
Categorical5
Numeric3

Dataset

Description보안등 정보 현황(제공표준)
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=VEY71398U2941WM4E7PV21507518&infSeq=1

Alerts

Dataset has 164 (1.6%) duplicate rowsDuplicates
데이터기준일자 is highly overall correlated with 위도 and 3 other fieldsHigh correlation
관리기관명 is highly overall correlated with 위도 and 4 other fieldsHigh correlation
관리기관전화번호 is highly overall correlated with 위도 and 4 other fieldsHigh correlation
위도 is highly overall correlated with 관리기관전화번호 and 2 other fieldsHigh correlation
경도 is highly overall correlated with 관리기관전화번호 and 2 other fieldsHigh correlation
설치연도 is highly overall correlated with 관리기관전화번호 and 1 other fieldsHigh correlation
설치개수 is highly imbalanced (96.2%)Imbalance
소재지도로명주소 has 4804 (48.0%) missing valuesMissing
위도 has 114 (1.1%) missing valuesMissing
경도 has 114 (1.1%) missing valuesMissing
설치연도 has 7245 (72.5%) missing valuesMissing

Reproduction

Analysis started2024-05-10 20:17:46.228828
Analysis finished2024-05-10 20:17:53.483550
Duration7.25 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

보안등위치명
Text

Distinct8212
Distinct (%)82.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-05-10T20:17:54.085910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length31
Mean length8.4429
Min length1

Characters and Unicode

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

Unique

Unique8072 ?
Unique (%)80.7%

Sample

1st row원미구역곡동226-24~원미구역곡동213
2nd row조종면237
3rd row곡반정동204
4th row둔대동081-1
5th row오정동 625-3
ValueCountFrequency (%)
ts 1183
 
9.3%
원미구역곡동226-24~원미구역곡동213 792
 
6.2%
수택동 107
 
0.8%
삼정동 101
 
0.8%
오정동 101
 
0.8%
인근 85
 
0.7%
교문동 78
 
0.6%
앞 59
 
0.5%
내동 57
 
0.4%
경기 53
 
0.4%
Other values (8477) 10058
79.4%
2024-05-10T20:17:55.216785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 7336
 
8.7%
2 7155
 
8.5%
동 6072
 
7.2%
0 4579
 
5.4%
3 3844
 
4.6%
- 3490
 
4.1%
4 3356
 
4.0%
6 2929
 
3.5%
2675
 
3.2%
5 2231
 
2.6%
Other values (519) 40762
48.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 37475
44.4%
Other Letter 36594
43.3%
Dash Punctuation 3490
 
4.1%
Uppercase Letter 2858
 
3.4%
Space Separator 2675
 
3.2%
Math Symbol 798
 
0.9%
Open Punctuation 253
 
0.3%
Close Punctuation 253
 
0.3%
Lowercase Letter 18
 
< 0.1%
Other Punctuation 9
 
< 0.1%
Other values (2) 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 6072
 
16.6%
원 2184
 
6.0%
곡 1983
 
5.4%
구 1957
 
5.3%
미 1912
 
5.2%
역 1691
 
4.6%
면 929
 
2.5%
평 656
 
1.8%
정 615
 
1.7%
대 496
 
1.4%
Other values (465) 18099
49.5%
Uppercase Letter
ValueCountFrequency (%)
S 1329
46.5%
T 1186
41.5%
U 90
 
3.1%
N 77
 
2.7%
G 50
 
1.7%
R 31
 
1.1%
M 19
 
0.7%
L 19
 
0.7%
B 12
 
0.4%
A 9
 
0.3%
Other values (12) 36
 
1.3%
Decimal Number
ValueCountFrequency (%)
1 7336
19.6%
2 7155
19.1%
0 4579
12.2%
3 3844
10.3%
4 3356
9.0%
6 2929
 
7.8%
5 2231
 
6.0%
7 2124
 
5.7%
8 1993
 
5.3%
9 1928
 
5.1%
Lowercase Letter
ValueCountFrequency (%)
a 5
27.8%
m 4
22.2%
b 2
 
11.1%
p 2
 
11.1%
n 1
 
5.6%
l 1
 
5.6%
x 1
 
5.6%
c 1
 
5.6%
s 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
, 5
55.6%
. 2
 
22.2%
; 1
 
11.1%
& 1
 
11.1%
Open Punctuation
ValueCountFrequency (%)
( 230
90.9%
[ 23
 
9.1%
Close Punctuation
ValueCountFrequency (%)
) 230
90.9%
] 23
 
9.1%
Dash Punctuation
ValueCountFrequency (%)
- 3490
100.0%
Space Separator
ValueCountFrequency (%)
2675
100.0%
Math Symbol
ValueCountFrequency (%)
~ 798
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 44955
53.2%
Hangul 36598
43.3%
Latin 2876
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 6072
 
16.6%
원 2184
 
6.0%
곡 1983
 
5.4%
구 1957
 
5.3%
미 1912
 
5.2%
역 1691
 
4.6%
면 929
 
2.5%
평 656
 
1.8%
정 615
 
1.7%
대 496
 
1.4%
Other values (466) 18103
49.5%
Latin
ValueCountFrequency (%)
S 1329
46.2%
T 1186
41.2%
U 90
 
3.1%
N 77
 
2.7%
G 50
 
1.7%
R 31
 
1.1%
M 19
 
0.7%
L 19
 
0.7%
B 12
 
0.4%
A 9
 
0.3%
Other values (21) 54
 
1.9%
Common
ValueCountFrequency (%)
1 7336
16.3%
2 7155
15.9%
0 4579
10.2%
3 3844
8.6%
- 3490
7.8%
4 3356
7.5%
6 2929
 
6.5%
2675
 
6.0%
5 2231
 
5.0%
7 2124
 
4.7%
Other values (12) 5236
11.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 47831
56.7%
Hangul 36593
43.3%
None 4
 
< 0.1%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 7336
15.3%
2 7155
15.0%
0 4579
9.6%
3 3844
8.0%
- 3490
7.3%
4 3356
7.0%
6 2929
 
6.1%
2675
 
5.6%
5 2231
 
4.7%
7 2124
 
4.4%
Other values (43) 8112
17.0%
Hangul
ValueCountFrequency (%)
동 6072
 
16.6%
원 2184
 
6.0%
곡 1983
 
5.4%
구 1957
 
5.3%
미 1912
 
5.2%
역 1691
 
4.6%
면 929
 
2.5%
평 656
 
1.8%
정 615
 
1.7%
대 496
 
1.4%
Other values (464) 18098
49.5%
None
ValueCountFrequency (%)
㈜ 4
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅇ 1
100.0%

설치개수
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
9908 
2
 
60
3
 
18
0
 
12
4
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 9908
99.1%
2 60
 
0.6%
3 18
 
0.2%
0 12
 
0.1%
4 2
 
< 0.1%

Length

2024-05-10T20:17:55.562383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T20:17:55.812927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9908
99.1%
2 60
 
0.6%
3 18
 
0.2%
0 12
 
0.1%
4 2
 
< 0.1%

소재지도로명주소
Text

MISSING 

Distinct4721
Distinct (%)90.9%
Missing4804
Missing (%)48.0%
Memory size156.2 KiB
2024-05-10T20:17:56.463279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length35
Mean length21.283487
Min length12

Characters and Unicode

Total characters110589
Distinct characters395
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

Unique4500 ?
Unique (%)86.6%

Sample

1st row경기도 수원시 권선구 곡선로50번길 6-1
2nd row경기도 군포시 호수로 305-40
3rd row경기도 부천시 상오정로 63
4th row경기도 부천시 삼작로 22
5th row경기도 부천시 오정로199번길 20-1
ValueCountFrequency (%)
경기도 5197
 
21.0%
부천시 1121
 
4.5%
광주시 856
 
3.5%
성남시 795
 
3.2%
고양시 439
 
1.8%
권선구 408
 
1.6%
수원시 408
 
1.6%
수정구 389
 
1.6%
남양주시 364
 
1.5%
중원구 330
 
1.3%
Other values (4798) 14443
58.4%
2024-05-10T20:17:57.539122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
19554
 
17.7%
도 5573
 
5.0%
경 5453
 
4.9%
시 5313
 
4.8%
기 5229
 
4.7%
1 4578
 
4.1%
로 4477
 
4.0%
길 3764
 
3.4%
2 3267
 
3.0%
번 2998
 
2.7%
Other values (385) 50383
45.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 65945
59.6%
Decimal Number 22174
 
20.1%
Space Separator 19554
 
17.7%
Dash Punctuation 2074
 
1.9%
Open Punctuation 388
 
0.4%
Close Punctuation 388
 
0.4%
Other Punctuation 59
 
0.1%
Uppercase Letter 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 5573
 
8.5%
경 5453
 
8.3%
시 5313
 
8.1%
기 5229
 
7.9%
로 4477
 
6.8%
길 3764
 
5.7%
번 2998
 
4.5%
구 1904
 
2.9%
천 1665
 
2.5%
남 1479
 
2.2%
Other values (364) 28090
42.6%
Decimal Number
ValueCountFrequency (%)
1 4578
20.6%
2 3267
14.7%
3 2495
11.3%
4 2144
9.7%
5 2065
9.3%
6 1870
8.4%
7 1593
 
7.2%
8 1422
 
6.4%
9 1405
 
6.3%
0 1335
 
6.0%
Uppercase Letter
ValueCountFrequency (%)
M 2
28.6%
A 2
28.6%
D 1
14.3%
H 1
14.3%
Y 1
14.3%
Other Punctuation
ValueCountFrequency (%)
, 55
93.2%
. 4
 
6.8%
Space Separator
ValueCountFrequency (%)
19554
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2074
100.0%
Open Punctuation
ValueCountFrequency (%)
( 388
100.0%
Close Punctuation
ValueCountFrequency (%)
) 388
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 65945
59.6%
Common 44637
40.4%
Latin 7
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 5573
 
8.5%
경 5453
 
8.3%
시 5313
 
8.1%
기 5229
 
7.9%
로 4477
 
6.8%
길 3764
 
5.7%
번 2998
 
4.5%
구 1904
 
2.9%
천 1665
 
2.5%
남 1479
 
2.2%
Other values (364) 28090
42.6%
Common
ValueCountFrequency (%)
19554
43.8%
1 4578
 
10.3%
2 3267
 
7.3%
3 2495
 
5.6%
4 2144
 
4.8%
- 2074
 
4.6%
5 2065
 
4.6%
6 1870
 
4.2%
7 1593
 
3.6%
8 1422
 
3.2%
Other values (6) 3575
 
8.0%
Latin
ValueCountFrequency (%)
M 2
28.6%
A 2
28.6%
D 1
14.3%
H 1
14.3%
Y 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 65945
59.6%
ASCII 44644
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
19554
43.8%
1 4578
 
10.3%
2 3267
 
7.3%
3 2495
 
5.6%
4 2144
 
4.8%
- 2074
 
4.6%
5 2065
 
4.6%
6 1870
 
4.2%
7 1593
 
3.6%
8 1422
 
3.2%
Other values (11) 3582
 
8.0%
Hangul
ValueCountFrequency (%)
도 5573
 
8.5%
경 5453
 
8.3%
시 5313
 
8.1%
기 5229
 
7.9%
로 4477
 
6.8%
길 3764
 
5.7%
번 2998
 
4.5%
구 1904
 
2.9%
천 1665
 
2.5%
남 1479
 
2.2%
Other values (364) 28090
42.6%

소재지지번주소
Text

Distinct8954
Distinct (%)89.6%
Missing2
Missing (%)< 0.1%
Memory size156.2 KiB
2024-05-10T20:17:58.109910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length30
Mean length19.261552
Min length11

Characters and Unicode

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

Unique

Unique8516 ?
Unique (%)85.2%

Sample

1st row경기도 부천시 중동 1181
2nd row경기도 가평군 조종면 대보리 412-1
3rd row경기도 수원시 권선구 곡반정동 561-1
4th row경기도 군포시 둔대동 산 32-16
5th row경기도 부천시 오정동 625-3
ValueCountFrequency (%)
경기도 9998
 
22.0%
부천시 1917
 
4.2%
남양주시 1365
 
3.0%
광주시 1205
 
2.7%
고양시 1123
 
2.5%
가평군 1018
 
2.2%
성남시 961
 
2.1%
중동 744
 
1.6%
덕양구 654
 
1.4%
시흥시 631
 
1.4%
Other values (7666) 25780
56.8%
2024-05-10T20:17:59.118490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
35693
18.5%
도 10614
 
5.5%
경 10051
 
5.2%
기 9998
 
5.2%
시 9633
 
5.0%
1 8256
 
4.3%
동 7999
 
4.2%
- 7145
 
3.7%
2 5409
 
2.8%
3 4369
 
2.3%
Other values (254) 83410
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 109503
56.9%
Decimal Number 40172
 
20.9%
Space Separator 35693
 
18.5%
Dash Punctuation 7145
 
3.7%
Open Punctuation 31
 
< 0.1%
Close Punctuation 30
 
< 0.1%
Other Punctuation 1
 
< 0.1%
Uppercase Letter 1
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 10614
 
9.7%
경 10051
 
9.2%
기 9998
 
9.1%
시 9633
 
8.8%
동 7999
 
7.3%
리 3304
 
3.0%
양 3286
 
3.0%
구 2980
 
2.7%
천 2674
 
2.4%
남 2672
 
2.4%
Other values (237) 46292
42.3%
Decimal Number
ValueCountFrequency (%)
1 8256
20.6%
2 5409
13.5%
3 4369
10.9%
4 3991
9.9%
5 3474
8.6%
7 3273
 
8.1%
6 3213
 
8.0%
8 2822
 
7.0%
0 2722
 
6.8%
9 2643
 
6.6%
Space Separator
ValueCountFrequency (%)
35693
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7145
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 30
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 109503
56.9%
Common 83073
43.1%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 10614
 
9.7%
경 10051
 
9.2%
기 9998
 
9.1%
시 9633
 
8.8%
동 7999
 
7.3%
리 3304
 
3.0%
양 3286
 
3.0%
구 2980
 
2.7%
천 2674
 
2.4%
남 2672
 
2.4%
Other values (237) 46292
42.3%
Common
ValueCountFrequency (%)
35693
43.0%
1 8256
 
9.9%
- 7145
 
8.6%
2 5409
 
6.5%
3 4369
 
5.3%
4 3991
 
4.8%
5 3474
 
4.2%
7 3273
 
3.9%
6 3213
 
3.9%
8 2822
 
3.4%
Other values (6) 5428
 
6.5%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 109503
56.9%
ASCII 83074
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
35693
43.0%
1 8256
 
9.9%
- 7145
 
8.6%
2 5409
 
6.5%
3 4369
 
5.3%
4 3991
 
4.8%
5 3474
 
4.2%
7 3273
 
3.9%
6 3213
 
3.9%
8 2822
 
3.4%
Other values (7) 5429
 
6.5%
Hangul
ValueCountFrequency (%)
도 10614
 
9.7%
경 10051
 
9.2%
기 9998
 
9.1%
시 9633
 
8.8%
동 7999
 
7.3%
리 3304
 
3.0%
양 3286
 
3.0%
구 2980
 
2.7%
천 2674
 
2.4%
남 2672
 
2.4%
Other values (237) 46292
42.3%

위도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct8910
Distinct (%)90.1%
Missing114
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean37.542878
Minimum37.197882
Maximum38.036179
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-10T20:17:59.582654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.197882
5-th percentile37.300756
Q137.429459
median37.508119
Q337.662518
95-th percentile37.856023
Maximum38.036179
Range0.83829733
Interquartile range (IQR)0.23305874

Descriptive statistics

Standard deviation0.16215049
Coefficient of variation (CV)0.0043190747
Kurtosis-0.41320133
Mean37.542878
Median Absolute Deviation (MAD)0.12231883
Skewness0.42862152
Sum371148.89
Variance0.026292783
MonotonicityNot monotonic
2024-05-10T20:17:59.984125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.51275623 34
 
0.3%
37.50060486 28
 
0.3%
37.5106733 23
 
0.2%
37.50030747 20
 
0.2%
37.49624528 18
 
0.2%
37.49803408 18
 
0.2%
37.5155779 17
 
0.2%
37.49977059 16
 
0.2%
37.49810777 15
 
0.1%
37.50606814 14
 
0.1%
Other values (8900) 9683
96.8%
(Missing) 114
 
1.1%
ValueCountFrequency (%)
37.19788167 1
< 0.1%
37.21226482 1
< 0.1%
37.22270044 1
< 0.1%
37.22923174 1
< 0.1%
37.23121551 1
< 0.1%
37.23150246 1
< 0.1%
37.23172996 1
< 0.1%
37.23184973 1
< 0.1%
37.23245223 1
< 0.1%
37.23248811 1
< 0.1%
ValueCountFrequency (%)
38.036179 1
< 0.1%
38.016766 1
< 0.1%
38.012398 1
< 0.1%
38.00491 1
< 0.1%
37.996544 1
< 0.1%
37.993431 1
< 0.1%
37.992649 1
< 0.1%
37.99082 1
< 0.1%
37.989059 1
< 0.1%
37.987797 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct8893
Distinct (%)90.0%
Missing114
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean127.05117
Minimum126.56845
Maximum127.59882
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-10T20:18:00.374510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.56845
5-th percentile126.76088
Q1126.80455
median127.0601
Q3127.23927
95-th percentile127.46269
Maximum127.59882
Range1.030373
Interquartile range (IQR)0.43471897

Descriptive statistics

Standard deviation0.23837185
Coefficient of variation (CV)0.0018761878
Kurtosis-1.2135771
Mean127.05117
Median Absolute Deviation (MAD)0.2354529
Skewness0.23357942
Sum1256027.9
Variance0.05682114
MonotonicityNot monotonic
2024-05-10T20:18:00.756067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.7639151 34
 
0.3%
126.7637176 28
 
0.3%
126.7639477 23
 
0.2%
126.7598953 20
 
0.2%
126.775626 18
 
0.2%
126.7598665 18
 
0.2%
126.765623 17
 
0.2%
126.7694067 16
 
0.2%
126.7692154 15
 
0.1%
126.7739203 14
 
0.1%
Other values (8883) 9683
96.8%
(Missing) 114
 
1.1%
ValueCountFrequency (%)
126.568451 1
< 0.1%
126.570645 1
< 0.1%
126.573021 1
< 0.1%
126.583807 1
< 0.1%
126.584679 1
< 0.1%
126.605612 1
< 0.1%
126.633487 1
< 0.1%
126.645133 1
< 0.1%
126.648218 1
< 0.1%
126.6823964565 1
< 0.1%
ValueCountFrequency (%)
127.598824 1
< 0.1%
127.580437 1
< 0.1%
127.576653 1
< 0.1%
127.575516 1
< 0.1%
127.574684 1
< 0.1%
127.574493 1
< 0.1%
127.573952 1
< 0.1%
127.573334 1
< 0.1%
127.569176 1
< 0.1%
127.568893 1
< 0.1%

설치연도
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct21
Distinct (%)0.8%
Missing7245
Missing (%)72.5%
Infinite0
Infinite (%)0.0%
Mean2014.1492
Minimum1990
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-10T20:18:01.048316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1990
5-th percentile2007.7
Q12011
median2015
Q32019
95-th percentile2021
Maximum2023
Range33
Interquartile range (IQR)8

Descriptive statistics

Standard deviation5.8572862
Coefficient of variation (CV)0.0029080697
Kurtosis4.624021
Mean2014.1492
Median Absolute Deviation (MAD)4
Skewness-1.5690974
Sum5548981
Variance34.307802
MonotonicityNot monotonic
2024-05-10T20:18:01.463899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
2011 620
 
6.2%
2019 549
 
5.5%
2018 290
 
2.9%
2009 243
 
2.4%
2020 131
 
1.3%
2013 123
 
1.2%
2016 123
 
1.2%
2022 108
 
1.1%
2008 104
 
1.0%
2017 87
 
0.9%
Other values (11) 377
 
3.8%
(Missing) 7245
72.5%
ValueCountFrequency (%)
1990 67
 
0.7%
2001 1
 
< 0.1%
2005 12
 
0.1%
2006 20
 
0.2%
2007 38
 
0.4%
2008 104
 
1.0%
2009 243
 
2.4%
2010 33
 
0.3%
2011 620
6.2%
2012 52
 
0.5%
ValueCountFrequency (%)
2023 27
 
0.3%
2022 108
 
1.1%
2021 39
 
0.4%
2020 131
 
1.3%
2019 549
5.5%
2018 290
2.9%
2017 87
 
0.9%
2016 123
 
1.2%
2015 46
 
0.5%
2014 42
 
0.4%

설치형태
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
4729 
한전주
4353 
전용주
765 
건축물
 
153

Length

Max length4
Median length3
Mean length3.4729
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한전주
2nd row한전주
3rd row한전주
4th row건축물
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 4729
47.3%
한전주 4353
43.5%
전용주 765
 
7.6%
건축물 153
 
1.5%

Length

2024-05-10T20:18:01.829734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T20:18:02.076832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 4729
47.3%
한전주 4353
43.5%
전용주 765
 
7.6%
건축물 153
 
1.5%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct45
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
031-590-4223
1365 
031-760-2173
1205 
031-580-2100
1018 
032-625-5624
897 
031-8075-5335
664 
Other values (40)
4851 

Length

Max length13
Median length12
Mean length12.1174
Min length12

Unique

Unique7 ?
Unique (%)0.1%

Sample

1st row032-625-5624
2nd row031-580-2100
3rd row031-228-6498
4th row031-390-0358
5th row032-625-7315

Common Values

ValueCountFrequency (%)
031-590-4223 1365
13.7%
031-760-2173 1205
12.0%
031-580-2100 1018
 
10.2%
032-625-5624 897
 
9.0%
031-8075-5335 664
 
6.6%
031-310-3144 633
 
6.3%
031-729-5462 440
 
4.4%
031-228-6498 434
 
4.3%
032-625-7315 371
 
3.7%
031-729-6361 359
 
3.6%
Other values (35) 2614
26.1%

Length

2024-05-10T20:18:02.400326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
031-590-4223 1365
13.7%
031-760-2173 1205
12.0%
031-580-2100 1018
 
10.2%
032-625-5624 897
 
9.0%
031-8075-5335 664
 
6.6%
031-310-3144 633
 
6.3%
031-729-5462 440
 
4.4%
031-228-6498 434
 
4.3%
032-625-7315 371
 
3.7%
031-729-6361 359
 
3.6%
Other values (35) 2614
26.1%

관리기관명
Categorical

HIGH CORRELATION 

Distinct33
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경기도 부천시청
1917 
경기도 남양주시청
1365 
경기도 광주시청
1205 
경기도 가평군청
1018 
경기도 고양시 덕양구청 안전건설과
654 
Other values (28)
3841 

Length

Max length19
Median length8
Mean length10.2989
Min length8

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row경기도 부천시청
2nd row경기도 가평군청
3rd row경기도 수원시 권선구청
4th row경기도 군포시청
5th row경기도 부천시청

Common Values

ValueCountFrequency (%)
경기도 부천시청 1917
19.2%
경기도 남양주시청 1365
13.7%
경기도 광주시청 1205
12.0%
경기도 가평군청 1018
10.2%
경기도 고양시 덕양구청 안전건설과 654
 
6.5%
경기도 시흥시청 633
 
6.3%
경기도 성남시 수정구청 440
 
4.4%
경기도 수원시 권선구청 434
 
4.3%
경기도 성남시 중원구청 359
 
3.6%
경기도 동두천시 도로과 314
 
3.1%
Other values (23) 1661
16.6%

Length

2024-05-10T20:18:02.716246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 10000
40.8%
부천시청 1917
 
7.8%
남양주시청 1365
 
5.6%
광주시청 1205
 
4.9%
고양시 1126
 
4.6%
안전건설과 1126
 
4.6%
가평군청 1018
 
4.1%
성남시 961
 
3.9%
덕양구청 654
 
2.7%
시흥시청 633
 
2.6%
Other values (33) 4527
18.5%

데이터기준일자
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2022-09-23
1917 
2023-05-17
1365 
2024-01-22
1205 
2023-06-15
1126 
2023-11-24
1018 
Other values (10)
3369 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-09-23
2nd row2023-11-24
3rd row2023-06-30
4th row2024-02-13
5th row2022-09-23

Common Values

ValueCountFrequency (%)
2022-09-23 1917
19.2%
2023-05-17 1365
13.7%
2024-01-22 1205
12.0%
2023-06-15 1126
11.3%
2023-11-24 1018
10.2%
2023-08-31 961
9.6%
2022-12-09 633
 
6.3%
2023-06-30 434
 
4.3%
2023-08-30 314
 
3.1%
2023-06-12 311
 
3.1%
Other values (5) 716
 
7.2%

Length

2024-05-10T20:18:03.016743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-09-23 1917
19.2%
2023-05-17 1365
13.7%
2024-01-22 1205
12.0%
2023-06-15 1126
11.3%
2023-11-24 1018
10.2%
2023-08-31 961
9.6%
2022-12-09 633
 
6.3%
2023-06-30 434
 
4.3%
2023-08-30 314
 
3.1%
2023-06-12 311
 
3.1%
Other values (5) 716
 
7.2%

Interactions

2024-05-10T20:17:51.326093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:49.566757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:50.416930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:51.560517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:49.834569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:50.678836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:51.781974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:50.145571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T20:17:50.946466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-10T20:18:03.322433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치개수위도경도설치연도설치형태관리기관전화번호관리기관명데이터기준일자
설치개수1.0000.2530.1740.1070.1070.3680.3370.380
위도0.2531.0000.8090.5570.5170.9410.9320.926
경도0.1740.8091.0000.5600.4850.9460.9320.909
설치연도0.1070.5570.5601.0000.4030.7250.7120.617
설치형태0.1070.5170.4850.4031.0000.6980.6790.755
관리기관전화번호0.3680.9410.9460.7250.6981.0001.0001.000
관리기관명0.3370.9320.9320.7120.6791.0001.0001.000
데이터기준일자0.3800.9260.9090.6170.7551.0001.0001.000
2024-05-10T20:18:03.673413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터기준일자관리기관명설치개수설치형태관리기관전화번호
데이터기준일자1.0000.9990.1710.4740.998
관리기관명0.9991.0000.1660.4750.995
설치개수0.1710.1661.0000.0800.168
설치형태0.4740.4750.0801.0000.475
관리기관전화번호0.9980.9950.1680.4751.000
2024-05-10T20:18:04.013458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도설치연도설치개수설치형태관리기관전화번호관리기관명데이터기준일자
위도1.0000.203-0.3660.1080.3630.6800.6800.676
경도0.2031.000-0.1930.0730.3330.6980.6810.634
설치연도-0.366-0.1931.0000.0670.3060.5080.5110.486
설치개수0.1080.0730.0671.0000.0800.1680.1660.171
설치형태0.3630.3330.3060.0801.0000.4750.4750.474
관리기관전화번호0.6800.6980.5080.1680.4751.0000.9950.998
관리기관명0.6800.6810.5110.1660.4750.9951.0000.999
데이터기준일자0.6760.6340.4860.1710.4740.9980.9991.000

Missing values

2024-05-10T20:17:52.185547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-10T20:17:52.626018image/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.
2024-05-10T20:17:53.043841image/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

보안등위치명설치개수소재지도로명주소소재지지번주소위도경도설치연도설치형태관리기관전화번호관리기관명데이터기준일자
44601원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 118137.499771126.769407<NA>한전주032-625-5624경기도 부천시청2022-09-23
9423조종면2371<NA>경기도 가평군 조종면 대보리 412-137.819241127.3580552019한전주031-580-2100경기도 가평군청2023-11-24
65209곡반정동2041경기도 수원시 권선구 곡선로50번길 6-1경기도 수원시 권선구 곡반정동 561-137.238223127.028102<NA>한전주031-228-6498경기도 수원시 권선구청2023-06-30
29661둔대동081-11경기도 군포시 호수로 305-40경기도 군포시 둔대동 산 32-1637.326741126.9102812020건축물031-390-0358경기도 군포시청2024-02-13
53266오정동 625-31경기도 부천시 상오정로 63경기도 부천시 오정동 625-337.523692126.790787<NA><NA>032-625-7315경기도 부천시청2022-09-23
41527삼정동 3641경기도 부천시 삼작로 22경기도 부천시 삼정동 36437.51902126.762331<NA><NA>032-625-7315경기도 부천시청2022-09-23
20259매산749-13a TS1<NA>경기도 광주시 매산동 749-1637.356221127.2461782020한전주031-760-2173경기도 광주시청2024-01-22
29708수택동1<NA>경기도 구리시 수택동 46137.594642127.1404842011전용주031-550-2436경기도 구리시청2023-06-12
56370오정208-61경기도 부천시 오정로199번길 20-1경기도 부천시 오정동 208-637.527492126.782682<NA><NA>032-625-7315경기도 부천시청2022-09-23
67883정왕1동21U1131<NA>경기도 시흥시 정왕동 158137.344724126.7451132013<NA>031-310-3144경기도 시흥시청2022-12-09
보안등위치명설치개수소재지도로명주소소재지지번주소위도경도설치연도설치형태관리기관전화번호관리기관명데이터기준일자
59347상대원1동01021경기도 성남시 중원구 둔촌대로 541번길 60경기도 성남시 중원구 상대원동 222-137.437427127.1764522022한전주031-729-6361경기도 성남시 중원구청2023-08-31
44770원미구약대동214-37-원미구약대동산3-41<NA>경기도 부천시 약대동 127-137.512654126.770814<NA>한전주032-625-5624경기도 부천시청2022-09-23
3620가평읍6681<NA>경기도 가평군 가평읍 상색리 141-737.801205127.4842992010전용주031-580-2100경기도 가평군청2023-11-24
18609곤지암1137 TS1경기도 광주시 곤지암읍 부항길97번길 29경기도 광주시 곤지암읍 부항리 136-2번지37.355866127.405425<NA>한전주031-760-2173경기도 광주시청2024-01-22
20606곤지암1630 TS1경기도 광주시 곤지암읍 새재길226번길 28-2경기도 광주시 곤지암읍 봉현리 212-137.344918127.404391<NA>한전주031-760-2173경기도 광주시청2024-01-22
3298712-06181<NA>경기도 남양주시 진접읍 부평리 734-937.734991127.1968<NA><NA>031-590-4223경기도 남양주시청2023-05-17
26634퇴촌면497 TS1경기도 광주시 퇴촌면 구룡동길 175경기도 광주시 퇴촌면 영동리 324-1번지37.481644127.374403<NA>한전주031-760-2173경기도 광주시청2024-01-22
49796도당동0311<NA>경기도 부천시 도당동 14537.516998126.784266<NA>한전주032-625-5286경기도 부천시청2022-09-23
9864상면0781<NA>경기도 가평군 상면 연하리 59037.797276127.3517382009전용주031-580-2100경기도 가평군청2023-11-24
57699태평3동(매직헤어 건너)1경기도 성남시 수정구 제일로 186경기도 성남시 수정구 태평3동 373837.443228127.131143<NA><NA>031-729-5462경기도 성남시 수정구청2023-08-31

Duplicate rows

Most frequently occurring

보안등위치명설치개수소재지도로명주소소재지지번주소위도경도설치연도설치형태관리기관전화번호관리기관명데이터기준일자# duplicates
64원미구역곡동226-24~원미구역곡동2131경기도 부천시 석천로 293경기도 부천시 중동 102437.512756126.763915<NA>한전주032-625-5624경기도 부천시청2022-09-2333
69원미구역곡동226-24~원미구역곡동2131경기도 부천시 소향로 162경기도 부천시 중동 117737.500605126.763718<NA>한전주032-625-5624경기도 부천시청2022-09-2328
108원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 102837.510673126.763948<NA>한전주032-625-5624경기도 부천시청2022-09-2323
124원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 117037.500307126.759895<NA>한전주032-625-5624경기도 부천시청2022-09-2320
126원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 117237.498034126.759867<NA>한전주032-625-5624경기도 부천시청2022-09-2318
140원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 1185-237.496245126.775626<NA>한전주032-625-5624경기도 부천시청2022-09-2318
102원미구역곡동226-24~원미구역곡동2131경기도 부천시 평천로 679경기도 부천시 약대동 216-137.515578126.765623<NA>한전주032-625-5624경기도 부천시청2022-09-2317
136원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 118137.499771126.769407<NA>한전주032-625-5624경기도 부천시청2022-09-2316
137원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 118237.498108126.769215<NA>한전주032-625-5624경기도 부천시청2022-09-2315
116원미구역곡동226-24~원미구역곡동2131<NA>경기도 부천시 중동 105537.506068126.769706<NA>한전주032-625-5624경기도 부천시청2022-09-2314