Overview

Dataset statistics

Number of variables10
Number of observations5819
Missing cells8093
Missing cells (%)13.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory471.8 KiB
Average record size in memory83.0 B

Variable types

Categorical5
Numeric3
Text2

Dataset

Description경기도 화성시_신호등대장에 대한 데이터로 지형지물부호, 관리번호, 일련번호, 신호등종류, 신호등재질, 신호등규격, 신호등구분, 신호등수, 잔여시간표시기유무, 비고 등의 항목을 제공합니다.
Author경기도 화성시
URLhttps://www.data.go.kr/data/15093536/fileData.do

Alerts

지형지물부호 has constant value ""Constant
관리번호 is highly overall correlated with 일련번호 and 2 other fieldsHigh correlation
일련번호 is highly overall correlated with 관리번호 and 1 other fieldsHigh correlation
신호등수 is highly overall correlated with 관리번호 and 1 other fieldsHigh correlation
신호등종류 is highly overall correlated with 신호등구분High correlation
신호등구분 is highly overall correlated with 신호등종류High correlation
잔여시간표시기유무 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation
신호등재질 is highly imbalanced (97.4%)Imbalance
신호등규격 has 4305 (74.0%) missing valuesMissing
비고 has 3788 (65.1%) missing valuesMissing
일련번호 has 289 (5.0%) zerosZeros

Reproduction

Analysis started2023-12-12 15:39:59.982000
Analysis finished2023-12-12 15:40:02.036708
Duration2.05 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지형지물부호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
신호등
5819 

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 (%)
신호등 5819
100.0%

Length

2023-12-13T00:40:02.106291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:40:02.220761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
신호등 5819
100.0%

관리번호
Real number (ℝ)

HIGH CORRELATION 

Distinct5727
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5030441 × 1013
Minimum100004
Maximum8.9991907 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size51.3 KiB
2023-12-13T00:40:02.346128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum100004
5-th percentile900139.9
Q1901303.5
median902762
Q39.9916122 × 1011
95-th percentile8.9991901 × 1013
Maximum8.9991907 × 1013
Range8.9991907 × 1013
Interquartile range (IQR)9.9916032 × 1011

Descriptive statistics

Standard deviation3.1289057 × 1013
Coefficient of variation (CV)2.0817126
Kurtosis1.4568632
Mean1.5030441 × 1013
Median Absolute Deviation (MAD)2260
Skewness1.8174788
Sum8.7462133 × 1016
Variance9.7900508 × 1026
MonotonicityNot monotonic
2023-12-13T00:40:02.543166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100059 3
 
0.1%
82992002050006 3
 
0.1%
82992002050004 3
 
0.1%
82992002050003 3
 
0.1%
500147 2
 
< 0.1%
82992002030013 2
 
< 0.1%
500144 2
 
< 0.1%
500145 2
 
< 0.1%
82992002040006 2
 
< 0.1%
82992002040015 2
 
< 0.1%
Other values (5717) 5795
99.6%
ValueCountFrequency (%)
100004 1
 
< 0.1%
100042 1
 
< 0.1%
100054 2
< 0.1%
100055 1
 
< 0.1%
100056 1
 
< 0.1%
100057 1
 
< 0.1%
100059 3
0.1%
100060 1
 
< 0.1%
100061 2
< 0.1%
100062 2
< 0.1%
ValueCountFrequency (%)
89991907240204 1
< 0.1%
89991907240203 1
< 0.1%
89991907240202 1
< 0.1%
89991907240201 1
< 0.1%
89991907240200 1
< 0.1%
89991907240199 1
< 0.1%
89991907240198 1
< 0.1%
89991907240197 1
< 0.1%
89991907240196 1
< 0.1%
89991907240195 1
< 0.1%

일련번호
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct5369
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.4810031 × 1013
Minimum0
Maximum8.9991907 × 1013
Zeros289
Zeros (%)5.0%
Negative0
Negative (%)0.0%
Memory size51.3 KiB
2023-12-13T00:40:02.745823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.9
Q190000722
median90002176
Q39.9916122 × 1011
95-th percentile8.9991901 × 1013
Maximum8.9991907 × 1013
Range8.9991907 × 1013
Interquartile range (IQR)9.9907122 × 1011

Descriptive statistics

Standard deviation3.1338146 × 1013
Coefficient of variation (CV)2.116008
Kurtosis1.4813505
Mean1.4810031 × 1013
Median Absolute Deviation (MAD)1674
Skewness1.8278509
Sum8.6179573 × 1016
Variance9.8207936 × 1026
MonotonicityNot monotonic
2023-12-13T00:40:02.936480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 289
 
5.0%
10000001 72
 
1.2%
50000001 29
 
0.5%
10000002 21
 
0.4%
20000001 15
 
0.3%
50000002 7
 
0.1%
82161809050021 3
 
0.1%
82161809050019 3
 
0.1%
30000001 3
 
0.1%
82161809050001 2
 
< 0.1%
Other values (5359) 5375
92.4%
ValueCountFrequency (%)
0 289
5.0%
1 1
 
< 0.1%
2 1
 
< 0.1%
3 1
 
< 0.1%
4 1
 
< 0.1%
5 1
 
< 0.1%
6 1
 
< 0.1%
7 1
 
< 0.1%
8 1
 
< 0.1%
9 1
 
< 0.1%
ValueCountFrequency (%)
89991907240204 1
< 0.1%
89991907240203 1
< 0.1%
89991907240202 1
< 0.1%
89991907240201 1
< 0.1%
89991907240200 1
< 0.1%
89991907240199 1
< 0.1%
89991907240198 1
< 0.1%
89991907240197 1
< 0.1%
89991907240196 1
< 0.1%
89991907240195 1
< 0.1%

신호등종류
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
횡형4색등
2497 
종형2색등
1584 
횡형3색등
1356 
기타
 
226
종형3색등
 
102
Other values (2)
 
54

Length

Max length5
Median length5
Mean length4.8827977
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row종형2색등
2nd row횡형3색등
3rd row횡형3색등
4th row횡형3색등
5th row횡형3색등

Common Values

ValueCountFrequency (%)
횡형4색등 2497
42.9%
종형2색등 1584
27.2%
횡형3색등 1356
23.3%
기타 226
 
3.9%
종형3색등 102
 
1.8%
횡형2색등 52
 
0.9%
미분류 2
 
< 0.1%

Length

2023-12-13T00:40:03.129744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:40:03.290142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
횡형4색등 2497
42.9%
종형2색등 1584
27.2%
횡형3색등 1356
23.3%
기타 226
 
3.9%
종형3색등 102
 
1.8%
횡형2색등 52
 
0.9%
미분류 2
 
< 0.1%

신호등재질
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
강관
5786 
주철
 
13
강판
 
10
미분류
 
8
기타
 
2

Length

Max length3
Median length2
Mean length2.0013748
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강관
2nd row강관
3rd row강관
4th row강관
5th row강관

Common Values

ValueCountFrequency (%)
강관 5786
99.4%
주철 13
 
0.2%
강판 10
 
0.2%
미분류 8
 
0.1%
기타 2
 
< 0.1%

Length

2023-12-13T00:40:03.484519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:40:03.649863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강관 5786
99.4%
주철 13
 
0.2%
강판 10
 
0.2%
미분류 8
 
0.1%
기타 2
 
< 0.1%

신호등규격
Text

MISSING 

Distinct147
Distinct (%)9.7%
Missing4305
Missing (%)74.0%
Memory size45.6 KiB
2023-12-13T00:40:04.002717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length48
Mean length42.551519
Min length6

Characters and Unicode

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

Unique53 ?
Unique (%)3.5%

Sample

1st row차량형1색등(안개등)
2nd row차량형1색등(안개등)
3rd row차량형1색등(안개등)
4th row차량형1색등(안개등)
5th row차량형1색등(안개등)
ValueCountFrequency (%)
견착 335
18.1%
보행종2색 222
 
12.0%
보등종형3색x1 175
 
9.5%
차량횡형4색등x1+보행종형2색등x1 90
 
4.9%
종형2색 60
 
3.2%
차량횡형4색등x2+보행종형2색등x1 57
 
3.1%
종형2색*2 46
 
2.5%
보등종형2색x1 40
 
2.2%
차횡4x1+보종2x1 39
 
2.1%
보행종형2색등x1 39
 
2.1%
Other values (135) 746
40.3%
2023-12-13T00:40:04.489663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
49107
76.2%
X 1523
 
2.4%
색 1411
 
2.2%
2 1296
 
2.0%
1 1259
 
2.0%
종 1252
 
1.9%
형 1155
 
1.8%
보 1108
 
1.7%
등 1059
 
1.6%
3 667
 
1.0%
Other values (34) 4586
 
7.1%

Most occurring categories

ValueCountFrequency (%)
Space Separator 49107
76.2%
Other Letter 9148
 
14.2%
Decimal Number 3978
 
6.2%
Uppercase Letter 1523
 
2.4%
Math Symbol 438
 
0.7%
Other Punctuation 157
 
0.2%
Close Punctuation 36
 
0.1%
Open Punctuation 36
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
색 1411
15.4%
종 1252
13.7%
형 1155
12.6%
보 1108
12.1%
등 1059
11.6%
차 663
7.2%
횡 608
6.6%
행 593
6.5%
량 415
 
4.5%
착 347
 
3.8%
Other values (18) 537
 
5.9%
Decimal Number
ValueCountFrequency (%)
2 1296
32.6%
1 1259
31.6%
3 667
16.8%
4 439
 
11.0%
5 147
 
3.7%
0 126
 
3.2%
6 28
 
0.7%
7 14
 
0.4%
9 2
 
0.1%
Other Punctuation
ValueCountFrequency (%)
* 125
79.6%
/ 32
 
20.4%
Space Separator
ValueCountFrequency (%)
49107
100.0%
Uppercase Letter
ValueCountFrequency (%)
X 1523
100.0%
Math Symbol
ValueCountFrequency (%)
+ 438
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Open Punctuation
ValueCountFrequency (%)
( 36
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 53752
83.4%
Hangul 9148
 
14.2%
Latin 1523
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
색 1411
15.4%
종 1252
13.7%
형 1155
12.6%
보 1108
12.1%
등 1059
11.6%
차 663
7.2%
횡 608
6.6%
행 593
6.5%
량 415
 
4.5%
착 347
 
3.8%
Other values (18) 537
 
5.9%
Common
ValueCountFrequency (%)
49107
91.4%
2 1296
 
2.4%
1 1259
 
2.3%
3 667
 
1.2%
4 439
 
0.8%
+ 438
 
0.8%
5 147
 
0.3%
0 126
 
0.2%
* 125
 
0.2%
) 36
 
0.1%
Other values (5) 112
 
0.2%
Latin
ValueCountFrequency (%)
X 1523
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 55275
85.8%
Hangul 9148
 
14.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
49107
88.8%
X 1523
 
2.8%
2 1296
 
2.3%
1 1259
 
2.3%
3 667
 
1.2%
4 439
 
0.8%
+ 438
 
0.8%
5 147
 
0.3%
0 126
 
0.2%
* 125
 
0.2%
Other values (6) 148
 
0.3%
Hangul
ValueCountFrequency (%)
색 1411
15.4%
종 1252
13.7%
형 1155
12.6%
보 1108
12.1%
등 1059
11.6%
차 663
7.2%
횡 608
6.6%
행 593
6.5%
량 415
 
4.5%
착 347
 
3.8%
Other values (18) 537
 
5.9%

신호등구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
차량신호등
3158 
보행등
1394 
점멸등
1153 
기타
 
112
미분류
 
2

Length

Max length5
Median length5
Mean length4.0661626
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row보행등
2nd row점멸등
3rd row점멸등
4th row점멸등
5th row점멸등

Common Values

ValueCountFrequency (%)
차량신호등 3158
54.3%
보행등 1394
24.0%
점멸등 1153
 
19.8%
기타 112
 
1.9%
미분류 2
 
< 0.1%

Length

2023-12-13T00:40:04.696079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:40:05.216161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
차량신호등 3158
54.3%
보행등 1394
24.0%
점멸등 1153
 
19.8%
기타 112
 
1.9%
미분류 2
 
< 0.1%

신호등수
Real number (ℝ)

HIGH CORRELATION 

Distinct16
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.6860285
Minimum0
Maximum18
Zeros2
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size51.3 KiB
2023-12-13T00:40:05.345052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median1
Q32
95-th percentile4
Maximum18
Range18
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.6754231
Coefficient of variation (CV)0.99370983
Kurtosis28.216207
Mean1.6860285
Median Absolute Deviation (MAD)0
Skewness4.682482
Sum9811
Variance2.8070426
MonotonicityNot monotonic
2023-12-13T00:40:05.495091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
1 4095
70.4%
2 795
 
13.7%
3 525
 
9.0%
4 218
 
3.7%
12 44
 
0.8%
6 37
 
0.6%
5 29
 
0.5%
9 17
 
0.3%
8 17
 
0.3%
13 12
 
0.2%
Other values (6) 30
 
0.5%
ValueCountFrequency (%)
0 2
 
< 0.1%
1 4095
70.4%
2 795
 
13.7%
3 525
 
9.0%
4 218
 
3.7%
5 29
 
0.5%
6 37
 
0.6%
7 4
 
0.1%
8 17
 
0.3%
9 17
 
0.3%
ValueCountFrequency (%)
18 7
 
0.1%
15 1
 
< 0.1%
13 12
 
0.2%
12 44
0.8%
11 10
 
0.2%
10 6
 
0.1%
9 17
 
0.3%
8 17
 
0.3%
7 4
 
0.1%
6 37
0.6%

잔여시간표시기유무
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
미분류
3427 
무
1354 
유
1038 

Length

Max length3
Median length3
Mean length2.1778656
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row무
2nd row무
3rd row무
4th row무
5th row무

Common Values

ValueCountFrequency (%)
미분류 3427
58.9%
무 1354
 
23.3%
유 1038
 
17.8%

Length

2023-12-13T00:40:05.706856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:40:05.865706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미분류 3427
58.9%
무 1354
 
23.3%
유 1038
 
17.8%

비고
Text

MISSING 

Distinct58
Distinct (%)2.9%
Missing3788
Missing (%)65.1%
Memory size45.6 KiB
2023-12-13T00:40:06.106985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length241
Median length239
Mean length218.35697
Min length4

Characters and Unicode

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

Unique

Unique6 ?
Unique (%)0.3%

Sample

1st row송산그린시티 기반시설 건설공사 도로 및 지하매설물 GIS D/B 구축용역(20171229)
2nd row송산그린시티 기반시설 건설공사 도로 및 지하매설물 GIS D/B 구축용역(20171229)
3rd row송산그린시티 기반시설 건설공사 도로 및 지하매설물 GIS D/B 구축용역(20171229)
4th row송산그린시티 기반시설 건설공사 도로 및 지하매설물 GIS D/B 구축용역(20171229)
5th row송산그린시티 기반시설 건설공사 도로 및 지하매설물 GIS D/B 구축용역(20171229)
ValueCountFrequency (%)
gis 1305
 
9.5%
및 1228
 
8.9%
도로 1179
 
8.6%
db 951
 
6.9%
지하시설물 935
 
6.8%
구축용역 551
 
4.0%
화성 528
 
3.8%
db구축용역 390
 
2.8%
부지공사(1단계)gis 377
 
2.7%
동탄(2)택지개발사업 377
 
2.7%
Other values (133) 5951
43.2%
2023-12-13T00:40:06.497635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
382742
86.3%
지 2603
 
0.6%
구 2584
 
0.6%
2 2286
 
0.5%
도 2115
 
0.5%
축 2019
 
0.5%
로 1883
 
0.4%
설 1862
 
0.4%
1 1845
 
0.4%
D 1796
 
0.4%
Other values (144) 41748
 
9.4%

Most occurring categories

ValueCountFrequency (%)
Space Separator 382742
86.3%
Other Letter 40503
 
9.1%
Uppercase Letter 8793
 
2.0%
Decimal Number 7306
 
1.6%
Open Punctuation 1789
 
0.4%
Close Punctuation 1789
 
0.4%
Other Punctuation 280
 
0.1%
Dash Punctuation 197
 
< 0.1%
Connector Punctuation 66
 
< 0.1%
Math Symbol 18
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 2603
 
6.4%
구 2584
 
6.4%
도 2115
 
5.2%
축 2019
 
5.0%
로 1883
 
4.6%
설 1862
 
4.6%
사 1783
 
4.4%
시 1648
 
4.1%
역 1561
 
3.9%
용 1515
 
3.7%
Other values (118) 20930
51.7%
Decimal Number
ValueCountFrequency (%)
2 2286
31.3%
1 1845
25.3%
0 1257
17.2%
7 914
 
12.5%
3 388
 
5.3%
8 370
 
5.1%
9 144
 
2.0%
6 48
 
0.7%
5 35
 
0.5%
4 19
 
0.3%
Uppercase Letter
ValueCountFrequency (%)
D 1796
20.4%
B 1796
20.4%
I 1747
19.9%
S 1707
19.4%
G 1707
19.4%
C 40
 
0.5%
Other Punctuation
ValueCountFrequency (%)
/ 175
62.5%
, 96
34.3%
* 9
 
3.2%
Math Symbol
ValueCountFrequency (%)
~ 10
55.6%
+ 8
44.4%
Space Separator
ValueCountFrequency (%)
382742
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1789
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1789
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 197
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 394187
88.9%
Hangul 40503
 
9.1%
Latin 8793
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 2603
 
6.4%
구 2584
 
6.4%
도 2115
 
5.2%
축 2019
 
5.0%
로 1883
 
4.6%
설 1862
 
4.6%
사 1783
 
4.4%
시 1648
 
4.1%
역 1561
 
3.9%
용 1515
 
3.7%
Other values (118) 20930
51.7%
Common
ValueCountFrequency (%)
382742
97.1%
2 2286
 
0.6%
1 1845
 
0.5%
( 1789
 
0.5%
) 1789
 
0.5%
0 1257
 
0.3%
7 914
 
0.2%
3 388
 
0.1%
8 370
 
0.1%
- 197
 
< 0.1%
Other values (10) 610
 
0.2%
Latin
ValueCountFrequency (%)
D 1796
20.4%
B 1796
20.4%
I 1747
19.9%
S 1707
19.4%
G 1707
19.4%
C 40
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 402980
90.9%
Hangul 40503
 
9.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
382742
95.0%
2 2286
 
0.6%
1 1845
 
0.5%
D 1796
 
0.4%
B 1796
 
0.4%
( 1789
 
0.4%
) 1789
 
0.4%
I 1747
 
0.4%
S 1707
 
0.4%
G 1707
 
0.4%
Other values (16) 3776
 
0.9%
Hangul
ValueCountFrequency (%)
지 2603
 
6.4%
구 2584
 
6.4%
도 2115
 
5.2%
축 2019
 
5.0%
로 1883
 
4.6%
설 1862
 
4.6%
사 1783
 
4.4%
시 1648
 
4.1%
역 1561
 
3.9%
용 1515
 
3.7%
Other values (118) 20930
51.7%

Interactions

2023-12-13T00:40:01.229624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:00.648264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:00.947925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:01.350326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:00.745439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:01.034880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:01.466701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:00.836371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:40:01.118981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:40:06.591172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호일련번호신호등종류신호등재질신호등구분신호등수잔여시간표시기유무비고
관리번호1.0000.9990.2410.2040.2370.4270.8330.995
일련번호0.9991.0000.2450.2390.2240.4040.8270.995
신호등종류0.2410.2451.0000.3810.8670.5420.4090.761
신호등재질0.2040.2390.3811.0000.5800.1690.1150.920
신호등구분0.2370.2240.8670.5801.0000.8220.3320.837
신호등수0.4270.4040.5420.1690.8221.0000.7090.773
잔여시간표시기유무0.8330.8270.4090.1150.3320.7091.0000.677
비고0.9950.9950.7610.9200.8370.7730.6771.000
2023-12-13T00:40:06.706892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신호등재질신호등구분신호등종류잔여시간표시기유무
신호등재질1.0000.2490.2550.087
신호등구분0.2491.0000.7880.266
신호등종류0.2550.7881.0000.302
잔여시간표시기유무0.0870.2660.3021.000
2023-12-13T00:40:06.810792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호일련번호신호등수신호등종류신호등재질신호등구분잔여시간표시기유무
관리번호1.0000.7060.5570.1460.1390.1620.521
일련번호0.7061.0000.2260.1480.1640.1540.513
신호등수0.5570.2261.0000.3120.0520.4810.567
신호등종류0.1460.1480.3121.0000.2550.7880.302
신호등재질0.1390.1640.0520.2551.0000.2490.087
신호등구분0.1620.1540.4810.7880.2491.0000.266
잔여시간표시기유무0.5210.5130.5670.3020.0870.2661.000

Missing values

2023-12-13T00:40:01.636779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:40:01.842926image/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-13T00:40:01.984333image/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

지형지물부호관리번호일련번호신호등종류신호등재질신호등규격신호등구분신호등수잔여시간표시기유무비고
0신호등50014750000002종형2색등강관<NA>보행등1무<NA>
1신호등50021850000001횡형3색등강관<NA>점멸등1무<NA>
2신호등50022150000001횡형3색등강관<NA>점멸등2무<NA>
3신호등50022950000001횡형3색등강관<NA>점멸등3무<NA>
4신호등50024550000001횡형3색등강관<NA>점멸등3무<NA>
5신호등50024650000001횡형3색등강관<NA>차량신호등6무<NA>
6신호등50024950000001횡형3색등강관<NA>차량신호등4무<NA>
7신호등50034150000001종형2색등강관<NA>보행등1무<NA>
8신호등50034250000001횡형3색등강관<NA>차량신호등2무<NA>
9신호등50034350000001횡형3색등강관<NA>차량신호등3무<NA>
지형지물부호관리번호일련번호신호등종류신호등재질신호등규격신호등구분신호등수잔여시간표시기유무비고
5809신호등8216200818001082162008180010횡형4색등강관차횡4X2+보종2X1차량신호등3유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5810신호등8216200818000982162008180009횡형4색등강관차횡4X1+보종2X1차량신호등2유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5811신호등8216200818000882162008180008횡형4색등강관차횡4X1+보종2X1차량신호등2유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5812신호등8216200818000782162008180007횡형4색등강관차횡4X2+보종2X1차량신호등3유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5813신호등8216200818000682162008180006횡형4색등강관차횡4X2+보종2X1차량신호등3유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5814신호등8216200818000582162008180005횡형4색등강관차횡4X1+보종2X1차량신호등2유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5815신호등8216200818000482162008180004횡형4색등강관차횡4X1+보종2X1차량신호등2유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5816신호등8216200818000382162008180003횡형4색등강관차횡4X2+보종2X1차량신호등3유화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5817신호등8216200818000282162008180002횡형3색등강관차횡3X1차량신호등1무화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역
5818신호등8216200818000182162008180001횡형3색등강관차횡3X1차량신호등1무화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역