gimi9 Pandas Profiling

Dataset statistics

Number of variables	12
Number of observations	10000
Missing cells	2541
Missing cells (%)	2.1%
Duplicate rows	8
Duplicate rows (%)	0.1%
Total size in memory	1.1 MiB
Average record size in memory	114.0 B

Variable types

Categorical	3
Numeric	7
Text	2

Dataset

Description	경상남도 도로대장전산화 시스템 데이터의 중장기개방계획에 따른 데이터입니다. 시스템 상에서의 기본공사 도면 정보(공사관련,도면 정보)를 가지고 있으며, 도로대장의 단위도면정보 데이터를 포함하고있습니다.
Author	경상남도
URL	https://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15091952

Alerts

Dataset has 8 (0.1%) duplicate rows	Duplicates
`노선번호` 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 `이력코드`	High correlation
`도로종류` is highly overall correlated with `노선번호` and 1 other fields	High correlation
`이력코드` is highly overall correlated with `도면연장`	High correlation
`관리기관` is highly imbalanced (98.2%)	Imbalance
`도로종류` is highly imbalanced (71.2%)	Imbalance
`이력코드` is highly imbalanced (88.5%)	Imbalance
`구간도면명` has 120 (1.2%) missing values	Missing
`위치(소재지)` has 2421 (24.2%) missing values	Missing
`위치(소재지)` is highly skewed (γ1 = -24.39026682)	Skewed
`도면시점 구간내 이정` has 645 (6.5%) zeros	Zeros
`도면 종점 구간내 이정` has 141 (1.4%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 23:57:27.138961
Analysis finished	2023-12-10 23:57:35.574609
Duration	8.44 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

관리기관
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1683	9983
1682	17

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	9983	99.8%
1682	17	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	9983	99.8%
1682	17	0.2%

도로종류
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1504	8693
1507	1287
1057	15
1056	5

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1504	8693	86.9%
1507	1287	12.9%
1057	15	0.1%
1056	5	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	8693	86.9%
1507	1287	12.9%
1057	15	0.1%
1056	5	< 0.1%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	892.9146

Minimum	30
Maximum	1099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	30
5-th percentile	58
Q1	1003
median	1018
Q3	1037
95-th percentile	1084
Maximum	1099
Range	1069
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	338.57667
Coefficient of variation (CV)	0.37918146
Kurtosis	2.2961378
Mean	892.9146
Median Absolute Deviation (MAD)	16
Skewness	-2.0590023
Sum	8929146
Variance	114634.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
60	510	5.1%
1034	497	5.0%
1002	479	4.8%
1001	450	4.5%
1024	437	4.4%
1021	436	4.4%
1018	434	4.3%
1022	362	3.6%
1007	350	3.5%
1089	321	3.2%
Other values (33)	5724	57.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	151	1.5%
37	278	2.8%
58	190	1.9%
60	510	5.1%
67	79	0.8%
69	183	1.8%
907	73	0.7%
1001	450	4.5%
1002	479	4.8%
1003	266	2.7%

Value	Count	Frequency (%)
1099	167	1.7%
1089	321	3.2%
1084	309	3.1%
1080	222	2.2%
1077	313	3.1%
1051	107	1.1%
1049	148	1.5%
1047	77	0.8%
1042	274	2.7%
1041	201	2.0%

구간번호
Real number (ℝ)

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2408

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	7
95-th percentile	13
Maximum	19
Range	18
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.6676369
Coefficient of variation (CV)	0.69982387
Kurtosis	0.49067844
Mean	5.2408
Median Absolute Deviation (MAD)	2
Skewness	0.97617958
Sum	52408
Variance	13.451561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	1543	15.4%
4	1235	12.3%
3	1187	11.9%
2	1141	11.4%
7	1022	10.2%
5	1002	10.0%
6	708	7.1%
9	526	5.3%
11	320	3.2%
8	316	3.2%
Other values (7)	1000	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1543	15.4%
2	1141	11.4%
3	1187	11.9%
4	1235	12.3%
5	1002	10.0%
6	708	7.1%
7	1022	10.2%
8	316	3.2%
9	526	5.3%
10	204	2.0%

Value	Count	Frequency (%)
19	30	0.3%
16	81	0.8%
15	88	0.9%
14	131	1.3%
13	236	2.4%
12	230	2.3%
11	320	3.2%
10	204	2.0%
9	526	5.3%
8	316	3.2%

구간
Real number (ℝ)

HIGH CORRELATION

Distinct	4102
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8929682.7

Minimum	300301
Maximum	10990710
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	300301
5-th percentile	580306
Q1	10030512
median	10180918
Q3	10370107
95-th percentile	10841007
Maximum	10990710
Range	10690409
Interquartile range (IQR)	339595.25

Descriptive statistics

Standard deviation	3385740.4
Coefficient of variation (CV)	0.37915574
Kurtosis	2.2961527
Mean	8929682.7
Median Absolute Deviation (MAD)	159904.5
Skewness	-2.0590075
Sum	8.9296827 × 10¹⁰
Variance	1.1463238 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10420223	22	0.2%
10420220	21	0.2%
10420224	18	0.2%
10420226	16	0.2%
10420227	16	0.2%
10420221	15	0.1%
10420222	15	0.1%
10420219	12	0.1%
10420228	11	0.1%
10200325	10	0.1%
Other values (4092)	9844	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300301	1	< 0.1%
300302	2	< 0.1%
300303	2	< 0.1%
300304	2	< 0.1%
300305	3	< 0.1%
300306	1	< 0.1%
300307	2	< 0.1%
300308	3	< 0.1%
300309	1	< 0.1%
300310	3	< 0.1%

Value	Count	Frequency (%)
10990710	2	< 0.1%
10990709	2	< 0.1%
10990708	2	< 0.1%
10990707	2	< 0.1%
10990704	1	< 0.1%
10990703	2	< 0.1%
10990702	1	< 0.1%
10990701	3	< 0.1%
10990518	3	< 0.1%
10990517	2	< 0.1%

이력코드
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

0	9845
1	155

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	9845	98.5%
1	155	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	9845	98.5%
1	155	1.6%

도면시점 구간내 이정
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	349
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4371179

Minimum	-0.34
Maximum	28.5
Zeros	645
Zeros (%)	6.5%
Negative	2
Negative (%)	< 0.1%
Memory size	166.0 KiB

Quantile statistics

Minimum	-0.34
5-th percentile	0
Q1	2
median	4.5
Q3	8
95-th percentile	13.5
Maximum	28.5
Range	28.84
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.381963
Coefficient of variation (CV)	0.80593489
Kurtosis	2.3287302
Mean	5.4371179
Median Absolute Deviation (MAD)	3
Skewness	1.2298909
Sum	54371.179
Variance	19.2016
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	645	6.5%
1.0	509	5.1%
1.5	492	4.9%
0.5	487	4.9%
2.0	474	4.7%
3.0	456	4.6%
2.5	449	4.5%
4.0	440	4.4%
3.5	422	4.2%
4.5	417	4.2%
Other values (339)	5209	52.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.34	2	< 0.1%
0.0	645	6.5%
0.02	5	0.1%
0.08	1	< 0.1%
0.1	1	< 0.1%
0.14	1	< 0.1%
0.16	6	0.1%
0.2	5	0.1%
0.22	3	< 0.1%
0.26	1	< 0.1%

Value	Count	Frequency (%)
28.5	3	< 0.1%
28.0	4	< 0.1%
27.5	4	< 0.1%
27.0	4	< 0.1%
26.5	5	0.1%
26.0	3	< 0.1%
25.5	4	< 0.1%
25.0	6	0.1%
24.5	2	< 0.1%
24.0	6	0.1%

도면 종점 구간내 이정
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	546
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9070914

Minimum	0
Maximum	28.903
Zeros	141
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	2.5
median	5
Q3	8.5
95-th percentile	13.9
Maximum	28.903
Range	28.903
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.3866995
Coefficient of variation (CV)	0.74261581
Kurtosis	2.3150514
Mean	5.9070914
Median Absolute Deviation (MAD)	3
Skewness	1.219099
Sum	59070.914
Variance	19.243132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5	507	5.1%
0.5	489	4.9%
2.0	480	4.8%
1.0	479	4.8%
2.5	462	4.6%
3.5	442	4.4%
3.0	440	4.4%
4.5	424	4.2%
4.0	415	4.2%
5.0	404	4.0%
Other values (536)	5458	54.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	141	1.4%
0.02	2	< 0.1%
0.04	1	< 0.1%
0.1	1	< 0.1%
0.12	1	< 0.1%
0.16	3	< 0.1%
0.18	1	< 0.1%
0.2	7	0.1%
0.22	1	< 0.1%
0.28	1	< 0.1%

Value	Count	Frequency (%)
28.903	2	< 0.1%
28.9	1	< 0.1%
28.5	4	< 0.1%
28.0	4	< 0.1%
27.5	4	< 0.1%
27.0	5	0.1%
26.5	3	< 0.1%
26.0	4	< 0.1%
25.5	6	0.1%
25.0	2	< 0.1%

도면연장
Real number (ℝ)

HIGH CORRELATION

Distinct	143
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	477.0946

Minimum	12
Maximum	504
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	12
5-th percentile	280
Q1	500
median	500
Q3	500
95-th percentile	500
Maximum	504
Range	492
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	88.782148
Coefficient of variation (CV)	0.18608919
Kurtosis	15.888049
Mean	477.0946
Median Absolute Deviation (MAD)	0
Skewness	-4.0848715
Sum	4770946
Variance	7882.2699
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
500	9195	92.0%
20	147	1.5%
300	39	0.4%
200	25	0.2%
260	24	0.2%
100	18	0.2%
60	18	0.2%
140	16	0.2%
380	16	0.2%
80	16	0.2%
Other values (133)	486	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	2	< 0.1%
15	3	< 0.1%
20	147	1.5%
23	2	< 0.1%
29	2	< 0.1%
33	5	0.1%
36	3	< 0.1%
40	9	0.1%
45	1	< 0.1%
47	2	< 0.1%

Value	Count	Frequency (%)
504	6	0.1%
500	9195	92.0%
493	3	< 0.1%
490	6	0.1%
489	4	< 0.1%
487	2	< 0.1%
482	3	< 0.1%
480	14	0.1%
474	4	< 0.1%
468	3	< 0.1%

도면명
Text

Distinct	9937
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	14
Median length	13
Mean length	13.3062
Min length	8

Characters and Unicode

Total characters	133062
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9878 ?
Unique (%)	98.8%

Sample

1st row	1014021025005H
2nd row	100109103000U
3rd row	101810106000P
4th row	108909106000Y
5th row	1042011115005H

Value	Count	Frequency (%)
108907111500u	4	< 0.1%
1089071115005h	4	< 0.1%
0220000y	2	< 0.1%
102306111500y	2	< 0.1%
006701101500y	2	< 0.1%
102004103000sh	2	< 0.1%
107702109000sh	2	< 0.1%
006701101000y	2	< 0.1%
104201103000u	2	< 0.1%
102404123000p	2	< 0.1%
Other values (9927)	9976	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	58414	43.9%
1	27311	20.5%
5	9169	6.9%
2	6599	5.0%
4	4935	3.7%
3	4294	3.2%
7	3601	2.7%
H	3154	2.4%
6	3010	2.3%
9	2662	2.0%
Other values (5)	9913	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	122622	92.2%
Uppercase Letter	10440	7.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	58414	47.6%
1	27311	22.3%
5	9169	7.5%
2	6599	5.4%
4	4935	4.0%
3	4294	3.5%
7	3601	2.9%
6	3010	2.5%
9	2662	2.2%
8	2627	2.1%

Uppercase Letter

Value	Count	Frequency (%)
H	3154	30.2%
U	2328	22.3%
Y	2262	21.7%
P	2256	21.6%
S	440	4.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	122622	92.2%
Latin	10440	7.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	58414	47.6%
1	27311	22.3%
5	9169	7.5%
2	6599	5.4%
4	4935	4.0%
3	4294	3.5%
7	3601	2.9%
6	3010	2.5%
9	2662	2.2%
8	2627	2.1%

Latin

Value	Count	Frequency (%)
H	3154	30.2%
U	2328	22.3%
Y	2262	21.7%
P	2256	21.6%
S	440	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	133062	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	58414	43.9%
1	27311	20.5%
5	9169	6.9%
2	6599	5.0%
4	4935	3.7%
3	4294	3.2%
7	3601	2.7%
H	3154	2.4%
6	3010	2.3%
9	2662	2.0%
Other values (5)	9913	7.4%

구간도면명
Text

MISSING

Distinct	411
Distinct (%)	4.2%
Missing	120
Missing (%)	1.2%
Memory size	156.2 KiB

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	128440
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39 ?
Unique (%)	0.4%

Sample

1st row	SE10140200000
2nd row	SE10010900000
3rd row	SE10181006000
4th row	SE10890900000
5th row	SE10420100000

Value	Count	Frequency (%)
se10420100000	166	1.7%
se10240400000	127	1.3%
se10090400000	103	1.0%
se10221200000	101	1.0%
se10260300000	94	1.0%
se00600200000	93	0.9%
se10340600000	90	0.9%
se00580700000	89	0.9%
se10341300000	87	0.9%
se00370200000	87	0.9%
Other values (401)	8843	89.5%

Most occurring characters

Value	Count	Frequency (%)
0	72237	56.2%
1	14325	11.2%
S	9880	7.7%
E	9880	7.7%
2	4509	3.5%
4	3699	2.9%
3	3325	2.6%
7	2816	2.2%
9	2142	1.7%
6	2015	1.6%
Other values (2)	3612	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	108680	84.6%
Uppercase Letter	19760	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	72237	66.5%
1	14325	13.2%
2	4509	4.1%
4	3699	3.4%
3	3325	3.1%
7	2816	2.6%
9	2142	2.0%
6	2015	1.9%
8	1919	1.8%
5	1693	1.6%

Uppercase Letter

Value	Count	Frequency (%)
S	9880	50.0%
E	9880	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	108680	84.6%
Latin	19760	15.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	72237	66.5%
1	14325	13.2%
2	4509	4.1%
4	3699	3.4%
3	3325	3.1%
7	2816	2.6%
9	2142	2.0%
6	2015	1.9%
8	1919	1.8%
5	1693	1.6%

Latin

Value	Count	Frequency (%)
S	9880	50.0%
E	9880	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	72237	56.2%
1	14325	11.2%
S	9880	7.7%
E	9880	7.7%
2	4509	3.5%
4	3699	2.9%
3	3325	2.6%
7	2816	2.2%
9	2142	1.7%
6	2015	1.6%
Other values (2)	3612	2.8%

위치(소재지)
Real number (ℝ)

MISSING SKEWED

Distinct	653
Distinct (%)	8.6%
Missing	2421
Missing (%)	24.2%
Infinite	0
Infinite (%)	0.0%
Mean	4.8493475 × 10⁹

Minimum	0
Maximum	4.889046 × 10⁹
Zeros	10
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	4.817025 × 10⁹
Q1	4.827025 × 10⁹
median	4.872042 × 10⁹
Q3	4.885032 × 10⁹
95-th percentile	4.889035 × 10⁹
Maximum	4.889046 × 10⁹
Range	4.889046 × 10⁹
Interquartile range (IQR)	58007006

Descriptive statistics

Standard deviation	1.8561263 × 10⁸
Coefficient of variation (CV)	0.038275794
Kurtosis	622.32825
Mean	4.8493475 × 10⁹
Median Absolute Deviation (MAD)	16988997
Skewness	-24.390267
Sum	3.6753205 × 10¹³
Variance	3.4452048 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4825012500	73	0.7%
4831033022	65	0.7%
4872031021	59	0.6%
4825033026	58	0.6%
4833032023	58	0.6%
4833011200	52	0.5%
4888034024	50	0.5%
4885040025	50	0.5%
4833032025	50	0.5%
4873032026	45	0.4%
Other values (643)	7019	70.2%
(Missing)	2421	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	0.1%
2671032023	2	< 0.1%
2671032024	2	< 0.1%
4811011200	3	< 0.1%
4811011300	2	< 0.1%
4811011500	2	< 0.1%
4811011600	2	< 0.1%
4811011800	15	0.1%
4811025032	3	< 0.1%
4811025033	8	0.1%

Value	Count	Frequency (%)
4889046029	8	0.1%
4889046028	7	0.1%
4889046026	9	0.1%
4889046025	10	0.1%
4889046023	10	0.1%
4889046022	21	0.2%
4889045029	15	0.1%
4889045027	6	0.1%
4889045025	4	< 0.1%
4889045024	2	< 0.1%

Heatmap
Table

	관리기관	도로종류	노선번호	구간번호	구간	이력코드	도면시점 구간내 이정	도면 종점 구간내 이정	도면연장	위치(소재지)
관리기관	1.000	0.000	0.006	0.357	0.006	0.000	0.030	0.036	0.071	0.000
도로종류	0.000	1.000	0.655	0.202	0.655	0.069	0.027	0.026	0.039	0.057
노선번호	0.006	0.655	1.000	0.262	1.000	0.030	0.066	0.074	0.090	0.202
구간번호	0.357	0.202	0.262	1.000	0.262	0.267	0.229	0.234	0.204	0.702
구간	0.006	0.655	1.000	0.262	1.000	0.030	0.066	0.074	0.090	0.202
이력코드	0.000	0.069	0.030	0.267	0.030	1.000	0.141	0.151	0.872	0.000
도면시점 구간내 이정	0.030	0.027	0.066	0.229	0.066	0.141	1.000	1.000	0.232	0.065
도면 종점 구간내 이정	0.036	0.026	0.074	0.234	0.074	0.151	1.000	1.000	0.230	0.061
도면연장	0.071	0.039	0.090	0.204	0.090	0.872	0.232	0.230	1.000	0.155
위치(소재지)	0.000	0.057	0.202	0.702	0.202	0.000	0.065	0.061	0.155	1.000

Heatmap
Table

	관리기관	이력코드	도로종류
관리기관	1.000	0.000	0.000
이력코드	0.000	1.000	0.045
도로종류	0.000	0.045	1.000

Heatmap
Table

	노선번호	구간번호	구간	도면시점 구간내 이정	도면 종점 구간내 이정	도면연장	위치(소재지)	관리기관	도로종류	이력코드
노선번호	1.000	-0.126	0.999	-0.057	-0.061	-0.049	-0.014	0.010	0.680	0.050
구간번호	-0.126	1.000	-0.101	0.053	0.058	0.089	0.062	0.274	0.130	0.205
구간	0.999	-0.101	1.000	-0.052	-0.055	-0.050	-0.019	0.010	0.680	0.050
도면시점 구간내 이정	-0.057	0.053	-0.052	1.000	0.999	-0.087	0.057	0.023	0.016	0.108
도면 종점 구간내 이정	-0.061	0.058	-0.055	0.999	1.000	-0.068	0.059	0.028	0.016	0.116
도면연장	-0.049	0.089	-0.050	-0.087	-0.068	1.000	0.066	0.054	0.024	0.706
위치(소재지)	-0.014	0.062	-0.019	0.057	0.059	0.066	1.000	0.000	0.095	0.000
관리기관	0.010	0.274	0.010	0.023	0.028	0.054	0.000	1.000	0.000	0.000
도로종류	0.680	0.130	0.680	0.016	0.016	0.024	0.095	0.000	1.000	0.045
이력코드	0.050	0.205	0.050	0.108	0.116	0.706	0.000	0.000	0.045	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

	관리기관	도로종류	노선번호	구간번호	구간	도면시점 구간내 이정	도면 종점 구간내 이정	도면연장	도면명	구간도면명	위치(소재지)
5537	1683	1504	1014	2	10140207	3.5	4.0	500	1014021025005H	SE10140200000	4885040025
14392	1683	1504	1001	9	10010907	3.0	3.5	500	100109103000U	SE10010900000	<NA>
6365	1683	1504	1018	11	10181112	6.0	6.5	500	101810106000P	SE10181006000	4831039021
18013	1683	1504	1089	9	10890913	6.0	6.5	500	108909106000Y	SE10890900000	<NA>
16503	1683	1504	1042	1	10420124	11.5	11.78	280	1042011115005H	SE10420100000	<NA>
6388	1683	1504	1018	11	10181115	7.5	8.0	500	1018101075002H	SE10181007500	4831039021
13773	1683	1504	1049	1	10490112	5.5	6.0	500	104901105500Y	SE10490100000	4817031024
9856	1683	1504	1051	2	10510201	0.5	1.0	500	1051021005005H	SE10510200000	4833032025
4615	1683	1504	1009	1	10090106	3.0	3.5	500	100901103000P	SE10090100000	4882043027
3198	1683	1504	1002	4	10020409	4.5	5.0	500	100204104500U	SE10020400000	4824035026

	관리기관	도로종류	노선번호	구간번호	구간	도면시점 구간내 이정	도면 종점 구간내 이정	도면연장	도면명	구간도면명	위치(소재지)
2719	1683	1507	69	7	690719	9.5	9.79	290	006907109500SH	SE00690700000	4833032026
1615	1683	1507	60	6	600602	10.5	11.0	500	0060061105002H	SE00600600000	4889044026
9900	1683	1504	1051	2	10510213	6.5	7.0	500	105102106500P	SE10510200000	4827035031
11423	1683	1504	1020	3	10200310	4.5	5.0	500	102003104500Y	SE10200300000	4825031027
6313	1683	1504	1018	11	10181102	1.0	1.5	500	1018101010005H	SE10181001000	4831039023
16833	1683	1504	1080	5	10800504	1.5	2.0	500	1080051015005H	SE10800500000	<NA>
14554	1683	1504	1001	13	10011308	3.5	4.0	500	100113103500U	SE10011300000	<NA>
4581	1683	1504	1008	3	10080325	12.5	13.0	500	100803112500U	SE10080300000	4827025327
14011	1683	1504	1049	3	10490323	11.0	11.44	440	104903111000SH	SE10490300000	4817044027
7167	1683	1504	1024	3	10240317	8.0	8.5	500	102403108000Y	SE10240300000	4884035027

Most frequently occurring

	관리기관	도로종류	노선번호	구간번호	구간	도면시점 구간내 이정	도면 종점 구간내 이정	도면연장	도면명	구간도면명	위치(소재지)	# duplicates
0	1682	1504	1002	14	10021406	0.0	0.5	500	0220000Y	SE10021400000	4815137021	2
1	1683	1504	1020	4	10200403	1.0	1.5	500	102004101000SH	SE10200400000	4825031025	2
2	1683	1504	1020	4	10200404	1.5	2.0	500	102004101500SH	SE10200400000	4825031025	2
3	1683	1504	1020	4	10200407	3.0	3.5	500	102004103000SH	SE10200400000	4825011300	2
4	1683	1504	1020	4	10200416	7.5	8.0	500	102004107500SH	SE10200400000	4825011000	2
5	1683	1504	1020	4	10200417	8.0	8.5	500	102004108000SH	SE10200400000	4825011000	2
6	1683	1504	1077	2	10770218	9.0	9.5	500	107702109000SH	SE10770200000	4833011200	2
7	1683	1504	1077	2	10770219	9.5	10.0	500	107702109500SH	SE10770200000	4833011200	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring