gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	181
Missing cells	38
Missing cells (%)	1.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	23.6 KiB
Average record size in memory	133.7 B

Variable types

Numeric	10
Categorical	4
DateTime	1

Dataset

Description	경상남도 도로대장전산화 시스템 데이터의 중장기개방계획에 따른 데이터입니다. 시스템 상에서의 우회도로 및 구간정보를 가지고 있으며, 도로대장의 중앙분리대 데이터를 포함하고있습니다.
Author	경상남도
URL	https://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15091957

Alerts

`관리기관` has constant value ""	Constant
`비고` is highly overall correlated with `식별번호` and 7 other fields	High correlation
`이력코드` is highly overall correlated with `식별번호` and 2 other fields	High correlation
`식별번호` is highly overall correlated with `이력코드` and 1 other fields	High correlation
`관리번호` is highly overall correlated with `노선번호` and 2 other fields	High correlation
`노선번호` is highly overall correlated with `관리번호` and 1 other fields	High correlation
`구간번호` is highly overall correlated with `관리번호` and 1 other fields	High correlation
`위치_시점` is highly overall correlated with `위치_종점`	High correlation
`위치_종점` is highly overall correlated with `위치_시점`	High correlation
`종류` is highly overall correlated with `연장` and 1 other fields	High correlation
`연장` is highly overall correlated with `종류`	High correlation
`높이` is highly overall correlated with `이력코드` and 1 other fields	High correlation
`도로종류` is highly overall correlated with `비고`	High correlation
`도로종류` is highly imbalanced (79.0%)	Imbalance
`이력코드` is highly imbalanced (79.0%)	Imbalance
`종류` has 36 (19.9%) missing values	Missing
`설치일자` has 2 (1.1%) missing values	Missing
`식별번호` has unique values	Unique
`위치_시점` has unique values	Unique
`관리번호` has 14 (7.7%) zeros	Zeros
`분리대폭` has 11 (6.1%) zeros	Zeros
`높이` has 2 (1.1%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:31:59.037165
Analysis finished	2023-12-11 00:32:08.694413
Duration	9.66 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

식별번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	181
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	91

Minimum	1
Maximum	181
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	46
median	91
Q3	136
95-th percentile	172
Maximum	181
Range	180
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	52.394338
Coefficient of variation (CV)	0.57576196
Kurtosis	-1.2
Mean	91
Median Absolute Deviation (MAD)	45
Skewness	0
Sum	16471
Variance	2745.1667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.6%
115	1	0.6%
117	1	0.6%
118	1	0.6%
119	1	0.6%
120	1	0.6%
121	1	0.6%
122	1	0.6%
123	1	0.6%
124	1	0.6%
Other values (171)	171	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.6%
2	1	0.6%
3	1	0.6%
4	1	0.6%
5	1	0.6%
6	1	0.6%
7	1	0.6%
8	1	0.6%
9	1	0.6%
10	1	0.6%

Value	Count	Frequency (%)
181	1	0.6%
180	1	0.6%
179	1	0.6%
178	1	0.6%
177	1	0.6%
176	1	0.6%
175	1	0.6%
174	1	0.6%
173	1	0.6%
172	1	0.6%

관리번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	168
Distinct (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7598572.2

Minimum	0
Maximum	10770019
Zeros	14
Zeros (%)	7.7%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	670001
median	10080017
Q3	10200012
95-th percentile	10770010
Maximum	10770019
Range	10770019
Interquartile range (IQR)	9530011

Descriptive statistics

Standard deviation	4475338.1
Coefficient of variation (CV)	0.58897092
Kurtosis	-0.7854736
Mean	7598572.2
Median Absolute Deviation (MAD)	119997
Skewness	-1.0992181
Sum	1.3753416 × 10⁹
Variance	2.0028651 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14	7.7%
670001	1	0.6%
10770008	1	0.6%
10770000	1	0.6%
10770001	1	0.6%
10770002	1	0.6%
10770003	1	0.6%
10770004	1	0.6%
10770005	1	0.6%
10770006	1	0.6%
Other values (158)	158	87.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	7.7%
1	1	0.6%
2	1	0.6%
3	1	0.6%
4	1	0.6%
5	1	0.6%
6	1	0.6%
7	1	0.6%
8	1	0.6%
9	1	0.6%

Value	Count	Frequency (%)
10770019	1	0.6%
10770018	1	0.6%
10770017	1	0.6%
10770016	1	0.6%
10770015	1	0.6%
10770014	1	0.6%
10770013	1	0.6%
10770012	1	0.6%
10770011	1	0.6%
10770010	1	0.6%

관리기관
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

1683	181

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1683	181	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	181	100.0%

도로종류
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

1504	175
1507	6

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1507
2nd row	1507
3rd row	1507
4th row	1504
5th row	1504

Common Values

Value	Count	Frequency (%)
1504	175	96.7%
1507	6	3.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	175	96.7%
1507	6	3.3%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	19
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	851.24862

Minimum	30
Maximum	1084
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	30
5-th percentile	58
Q1	1004
median	1009
Q3	1028
95-th percentile	1080
Maximum	1084
Range	1054
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	376.52117
Coefficient of variation (CV)	0.44231633
Kurtosis	0.73518427
Mean	851.24862
Median Absolute Deviation (MAD)	11
Skewness	-1.6415796
Sum	154076
Variance	141768.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
58	27	14.9%
1004	25	13.8%
1008	23	12.7%
1020	20	11.0%
1077	20	11.0%
1009	15	8.3%
1042	12	6.6%
1018	8	4.4%
1084	8	4.4%
1028	6	3.3%
Other values (9)	17	9.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	1	0.6%
58	27	14.9%
60	3	1.7%
67	2	1.1%
1001	1	0.6%
1004	25	13.8%
1008	23	12.7%
1009	15	8.3%
1011	5	2.8%
1018	8	4.4%

Value	Count	Frequency (%)
1084	8	4.4%
1080	2	1.1%
1077	20	11.0%
1042	12	6.6%
1041	1	0.6%
1040	1	0.6%
1028	6	3.3%
1022	1	0.6%
1020	20	11.0%
1018	8	4.4%

구간번호
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.3149171

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	3
Q3	7
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.7919027
Coefficient of variation (CV)	0.64703507
Kurtosis	-0.42611679
Mean	4.3149171
Median Absolute Deviation (MAD)	2
Skewness	0.73822711
Sum	781
Variance	7.7947207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	70	38.7%
7	49	27.1%
1	29	16.0%
2	14	7.7%
10	10	5.5%
4	3	1.7%
9	2	1.1%
11	2	1.1%
6	1	0.6%
13	1	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	29	16.0%
2	14	7.7%
3	70	38.7%
4	3	1.7%
6	1	0.6%
7	49	27.1%
9	2	1.1%
10	10	5.5%
11	2	1.1%
13	1	0.6%

Value	Count	Frequency (%)
13	1	0.6%
11	2	1.1%
10	10	5.5%
9	2	1.1%
7	49	27.1%
6	1	0.6%
4	3	1.7%
3	70	38.7%
2	14	7.7%
1	29	16.0%

이력코드
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

0	175
1	6

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
0	175	96.7%
1	6	3.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	175	96.7%
1	6	3.3%

위치_시점
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	181
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.3777017

Minimum	0
Maximum	19.423
Zeros	1
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0.12
Q1	2.571
median	5.11
Q3	9.376
95-th percentile	16.514
Maximum	19.423
Range	19.423
Interquartile range (IQR)	6.805

Descriptive statistics

Standard deviation	4.870454
Coefficient of variation (CV)	0.76366914
Kurtosis	-0.037518425
Mean	6.3777017
Median Absolute Deviation (MAD)	3.38
Skewness	0.78070137
Sum	1154.364
Variance	23.721322
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.577	1	0.6%
4.043	1	0.6%
5.062	1	0.6%
5.125	1	0.6%
5.915	1	0.6%
6.035	1	0.6%
6.064	1	0.6%
7.442	1	0.6%
7.465	1	0.6%
7.816	1	0.6%
Other values (171)	171	94.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	0.6%
0.007	1	0.6%
0.021	1	0.6%
0.022	1	0.6%
0.027	1	0.6%
0.06	1	0.6%
0.072	1	0.6%
0.107	1	0.6%
0.108	1	0.6%
0.12	1	0.6%

Value	Count	Frequency (%)
19.423	1	0.6%
19.372	1	0.6%
19.035	1	0.6%
18.815	1	0.6%
18.711	1	0.6%
17.067	1	0.6%
17.047	1	0.6%
16.76	1	0.6%
16.713	1	0.6%
16.514	1	0.6%

위치_종점
Real number (ℝ)

HIGH CORRELATION

Distinct	180
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7673149

Minimum	0.022
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0.022
5-th percentile	0.728
Q1	2.735
median	5.454
Q3	9.745
95-th percentile	16.6
Maximum	20
Range	19.978
Interquartile range (IQR)	7.01

Descriptive statistics

Standard deviation	4.8626903
Coefficient of variation (CV)	0.71855534
Kurtosis	-0.093254132
Mean	6.7673149
Median Absolute Deviation (MAD)	3.254
Skewness	0.75259078
Sum	1224.884
Variance	23.645757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.543	2	1.1%
1.775	1	0.6%
2.865	1	0.6%
5.915	1	0.6%
5.958	1	0.6%
6.064	1	0.6%
7.387	1	0.6%
7.465	1	0.6%
7.816	1	0.6%
7.859	1	0.6%
Other values (170)	170	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.022	1	0.6%
0.08	1	0.6%
0.238	1	0.6%
0.31	1	0.6%
0.377	1	0.6%
0.4	1	0.6%
0.492	1	0.6%
0.65	1	0.6%
0.652	1	0.6%
0.728	1	0.6%

Value	Count	Frequency (%)
20.0	1	0.6%
19.423	1	0.6%
19.098	1	0.6%
19.035	1	0.6%
18.815	1	0.6%
18.711	1	0.6%
17.067	1	0.6%
16.823	1	0.6%
16.737	1	0.6%
16.6	1	0.6%

종류
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6
Distinct (%)	4.1%
Missing	36
Missing (%)	19.9%
Infinite	0
Infinite (%)	0.0%
Mean	3134.6414

Minimum	3100
Maximum	3199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	3100
5-th percentile	3100
Q1	3101
median	3101
Q3	3199
95-th percentile	3199
Maximum	3199
Range	99
Interquartile range (IQR)	98

Descriptive statistics

Standard deviation	46.177297
Coefficient of variation (CV)	0.014731285
Kurtosis	-1.5422233
Mean	3134.6414
Median Absolute Deviation (MAD)	1
Skewness	0.68737059
Sum	454523
Variance	2132.3427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3101	66	36.5%
3199	49	27.1%
3100	14	7.7%
3105	8	4.4%
3108	6	3.3%
3109	2	1.1%
(Missing)	36	19.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3100	14	7.7%
3101	66	36.5%
3105	8	4.4%
3108	6	3.3%
3109	2	1.1%
3199	49	27.1%

Value	Count	Frequency (%)
3199	49	27.1%
3109	2	1.1%
3108	6	3.3%
3105	8	4.4%
3101	66	36.5%
3100	14	7.7%

연장
Real number (ℝ)

HIGH CORRELATION

Distinct	147
Distinct (%)	81.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	380.43646

Minimum	8
Maximum	2717
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	8
5-th percentile	20
Q1	65
median	180
Q3	509
95-th percentile	1392
Maximum	2717
Range	2709
Interquartile range (IQR)	444

Descriptive statistics

Standard deviation	509.78598
Coefficient of variation (CV)	1.3400029
Kurtosis	7.0292917
Mean	380.43646
Median Absolute Deviation (MAD)	137
Skewness	2.4575099
Sum	68859
Variance	259881.75
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	5	2.8%
40	4	2.2%
86	3	1.7%
91	3	1.7%
10	3	1.7%
100	3	1.7%
26	3	1.7%
29	3	1.7%
64	3	1.7%
43	3	1.7%
Other values (137)	148	81.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	2	1.1%
10	3	1.7%
12	1	0.6%
15	1	0.6%
16	1	0.6%
17	1	0.6%
20	5	2.8%
24	1	0.6%
25	1	0.6%
26	3	1.7%

Value	Count	Frequency (%)
2717	1	0.6%
2700	1	0.6%
2640	1	0.6%
2382	1	0.6%
1805	1	0.6%
1644	1	0.6%
1555	1	0.6%
1421	1	0.6%
1415	1	0.6%
1392	1	0.6%

분리대폭
Real number (ℝ)

ZEROS

Distinct	23
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	93.41547

Minimum	0
Maximum	900
Zeros	11
Zeros (%)	6.1%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	30
median	50
Q3	150
95-th percentile	200
Maximum	900
Range	900
Interquartile range (IQR)	120

Descriptive statistics

Standard deviation	100.83248
Coefficient of variation (CV)	1.079398
Kurtosis	24.609453
Mean	93.41547
Median Absolute Deviation (MAD)	48
Skewness	3.6690079
Sum	16908.2
Variance	10167.188
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
50.0	55	30.4%
200.0	27	14.9%
150.0	26	14.4%
2.0	15	8.3%
0.0	11	6.1%
120.0	11	6.1%
20.0	7	3.9%
30.0	7	3.9%
60.0	5	2.8%
0.6	2	1.1%
Other values (13)	15	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	11	6.1%
0.5	1	0.6%
0.6	2	1.1%
1.0	1	0.6%
1.3	1	0.6%
2.0	15	8.3%
4.2	1	0.6%
20.0	7	3.9%
30.0	7	3.9%
40.0	1	0.6%

Value	Count	Frequency (%)
900.0	1	0.6%
600.0	1	0.6%
300.0	1	0.6%
200.0	27	14.9%
190.0	2	1.1%
180.0	1	0.6%
170.0	1	0.6%
150.0	26	14.4%
120.0	11	6.1%
100.0	2	1.1%

높이
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	16
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.995028

Minimum	0
Maximum	150
Zeros	2
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	1.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	70
median	80
Q3	90
95-th percentile	140
Maximum	150
Range	150
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	36.05867
Coefficient of variation (CV)	0.45076139
Kurtosis	0.59817891
Mean	79.995028
Median Absolute Deviation (MAD)	10
Skewness	-0.61178714
Sum	14479.1
Variance	1300.2277
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
80.0	48	26.5%
70.0	28	15.5%
77.5	28	15.5%
120.0	26	14.4%
140.0	11	6.1%
0.5	9	5.0%
90.0	8	4.4%
0.6	6	3.3%
100.0	5	2.8%
20.0	3	1.7%
Other values (6)	9	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	2	1.1%
0.5	9	5.0%
0.6	6	3.3%
0.7	1	0.6%
7.8	1	0.6%
20.0	3	1.7%
30.0	1	0.6%
70.0	28	15.5%
72.5	1	0.6%
77.5	28	15.5%

Value	Count	Frequency (%)
150.0	3	1.7%
140.0	11	6.1%
120.0	26	14.4%
100.0	5	2.8%
90.0	8	4.4%
80.0	48	26.5%
77.5	28	15.5%
72.5	1	0.6%
70.0	28	15.5%
30.0	1	0.6%

설치일자
Date

MISSING

Distinct	8
Distinct (%)	4.5%
Missing	2
Missing (%)	1.1%
Memory size	1.5 KiB

Minimum	1900-01-01 00:00:00
Maximum	2016-03-31 00:00:00

Histogram

Histogram with fixed size bins (bins=8)

비고
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Memory size	1.5 KiB

<NA>	105
차선규제봉	35
공사중	14
가드레일	11
콘크리트보형,중앙분리대봉	3
Other values (10)	13

Length

Max length	13
Median length	4
Mean length	4.6906077
Min length	3

Unique

Unique	7 ?
Unique (%)	3.9%

Sample

1st row	<NA>
2nd row	차선규제봉 12개
3rd row	차선규제봉
4th row	차선규제봉
5th row	차선규제봉

Common Values

Value	Count	Frequency (%)
<NA>	105	58.0%
차선규제봉	35	19.3%
공사중	14	7.7%
가드레일	11	6.1%
콘크리트보형,중앙분리대봉	3	1.7%
차선규제봉(10EA)	2	1.1%
차선규제봉(5EA)	2	1.1%
연석형(화단)	2	1.1%
차선규제봉 12개	1	0.6%
차선규제봉(22EA)	1	0.6%
Other values (5)	5	2.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	105	57.7%
차선규제봉	36	19.8%
공사중	14	7.7%
가드레일	11	6.0%
콘크리트보형,중앙분리대봉	3	1.6%
차선규제봉(10ea	2	1.1%
차선규제봉(5ea	2	1.1%
연석형(화단	2	1.1%
12개	1	0.5%
차선규제봉(22ea	1	0.5%
Other values (5)	5	2.7%

Heatmap
Table

	식별번호	관리번호	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	종류	연장	분리대폭	높이	설치일자	비고
식별번호	1.000	0.919	0.299	0.933	0.722	0.673	0.816	0.809	0.000	0.000	0.603	0.773	0.788	0.874
관리번호	0.919	1.000	0.409	0.941	0.691	0.007	0.550	0.493	0.000	0.082	0.655	0.490	0.989	0.957
도로종류	0.299	0.409	1.000	0.516	0.307	0.000	0.249	0.122	0.000	0.000	0.000	0.580	0.000	0.781
노선번호	0.933	0.941	0.516	1.000	0.610	0.000	0.754	0.703	0.000	0.173	0.802	0.523	0.983	0.781
구간번호	0.722	0.691	0.307	0.610	1.000	0.263	0.449	0.430	0.325	0.000	0.427	0.566	0.810	0.863
이력코드	0.673	0.007	0.000	0.000	0.263	1.000	0.218	0.328	0.155	0.027	0.000	0.675	1.000	NaN
위치_시점	0.816	0.550	0.249	0.754	0.449	0.218	1.000	0.995	0.463	0.000	0.374	0.522	0.399	0.632
위치_종점	0.809	0.493	0.122	0.703	0.430	0.328	0.995	1.000	0.513	0.142	0.420	0.543	0.459	0.465
종류	0.000	0.000	0.000	0.000	0.325	0.155	0.463	0.513	1.000	0.615	0.512	0.760	0.260	1.000
연장	0.000	0.082	0.000	0.173	0.000	0.027	0.000	0.142	0.615	1.000	0.000	0.000	0.000	0.408
분리대폭	0.603	0.655	0.000	0.802	0.427	0.000	0.374	0.420	0.512	0.000	1.000	0.680	0.603	0.209
높이	0.773	0.490	0.580	0.523	0.566	0.675	0.522	0.543	0.760	0.000	0.680	1.000	0.816	0.945
설치일자	0.788	0.989	0.000	0.983	0.810	1.000	0.399	0.459	0.260	0.000	0.603	0.816	1.000	NaN
비고	0.874	0.957	0.781	0.781	0.863	NaN	0.632	0.465	1.000	0.408	0.209	0.945	NaN	1.000

Heatmap
Table

	비고	이력코드	도로종류
비고	1.000	1.000	0.576
이력코드	1.000	1.000	0.000
도로종류	0.576	0.000	1.000

Heatmap
Table

	식별번호	관리번호	노선번호	구간번호	위치_시점	위치_종점	종류	연장	분리대폭	높이	도로종류	이력코드	비고
식별번호	1.000	-0.200	0.168	0.168	-0.052	-0.051	-0.035	0.129	0.009	-0.411	0.290	0.512	0.623
관리번호	-0.200	1.000	0.603	-0.670	-0.102	-0.116	0.079	-0.149	-0.255	0.239	0.268	0.000	0.760
노선번호	0.168	0.603	1.000	-0.420	-0.457	-0.464	0.025	0.004	-0.404	-0.070	0.345	0.000	0.576
구간번호	0.168	-0.670	-0.420	1.000	0.245	0.258	-0.187	0.179	0.129	-0.004	0.310	0.267	0.616
위치_시점	-0.052	-0.102	-0.457	0.245	1.000	0.994	0.187	-0.147	0.135	0.184	0.186	0.163	0.322
위치_종점	-0.051	-0.116	-0.464	0.258	0.994	1.000	0.149	-0.071	0.144	0.202	0.090	0.246	0.209
종류	-0.035	0.079	0.025	-0.187	0.187	0.149	1.000	-0.517	-0.328	-0.257	0.000	0.075	0.915
연장	0.129	-0.149	0.004	0.179	-0.147	-0.071	-0.517	1.000	0.266	0.003	0.000	0.022	0.196
분리대폭	0.009	-0.255	-0.404	0.129	0.135	0.144	-0.328	0.266	1.000	-0.084	0.000	0.000	0.091
높이	-0.411	0.239	-0.070	-0.004	0.184	0.202	-0.257	0.003	-0.084	1.000	0.127	0.510	0.629
도로종류	0.290	0.268	0.345	0.310	0.186	0.090	0.000	0.000	0.000	0.127	1.000	0.000	0.576
이력코드	0.512	0.000	0.000	0.267	0.163	0.246	0.075	0.022	0.000	0.510	0.000	1.000	1.000
비고	0.623	0.760	0.576	0.616	0.322	0.209	0.915	0.196	0.091	0.629	0.576	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	위치_시점	위치_종점	종류	연장	분리대폭	높이	설치일자	비고
0	1	670001	1683	1507	67	3	1.577	1.775	3199	198	20.0	70.0	1900-01-01	<NA>
1	2	670002	1683	1507	67	9	9.86	9.9	3199	40	0.0	120.0	1900-01-01	차선규제봉 12개
2	3	300001	1683	1507	30	7	11.04	11.104	3199	64	0.0	120.0	1900-01-01	차선규제봉
3	4	10200018	1683	1504	1020	4	8.492	8.543	3199	51	40.0	70.0	1900-01-01	차선규제봉
4	5	10200019	1683	1504	1020	4	8.5	8.543	3199	43	0.0	70.0	1900-01-01	차선규제봉
5	6	10200001	1683	1504	1020	3	0.107	0.82	3101	713	200.0	80.0	1900-01-01	<NA>
6	7	10200002	1683	1504	1020	3	0.82	1.406	3105	586	200.0	80.0	1900-01-01	<NA>
7	8	10200003	1683	1504	1020	3	1.406	1.62	3101	214	200.0	80.0	1900-01-01	<NA>
8	9	10200004	1683	1504	1020	3	1.62	1.839	3105	219	200.0	80.0	1900-01-01	<NA>
9	10	10200005	1683	1504	1020	3	2.128	2.608	3105	480	200.0	80.0	1900-01-01	<NA>

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	종류	연장	분리대폭	높이	설치일자	비고
171	172	0	1683	1504	1084	10	0	0.914	1.598	<NA>	684	2.0	0.5	20121219	<NA>
172	173	0	1683	1504	1084	10	0	0.551	0.745	<NA>	194	2.0	0.5	20121219	<NA>
173	174	0	1683	1504	1084	10	0	0.14	0.377	<NA>	237	2.0	0.5	20121219	<NA>
174	175	0	1683	1504	1040	13	0	0.072	0.4	<NA>	328	0.5	72.5	2012.03.31	<NA>
175	176	10420011	1683	1504	1042	1	1	3.154	3.662	3101	508	2.0	0.6	20160331	<NA>
176	177	10420010	1683	1504	1042	1	1	2.84	3.116	3101	276	2.0	0.6	20160331	<NA>
177	178	10420009	1683	1504	1042	1	1	2.56	2.66	3101	100	2.0	0.6	20160331	<NA>
178	179	10420008	1683	1504	1042	1	1	2.31	2.496	3101	186	2.0	0.6	20160331	<NA>
179	180	10420007	1683	1504	1042	1	1	1.204	2.153	3101	949	2.0	0.6	20160331	<NA>
180	181	10420006	1683	1504	1042	1	1	0.304	0.73	3101	426	2.0	0.6	20160331	<NA>

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample