gimi9 Pandas Profiling

Dataset statistics

Number of variables	13
Number of observations	541
Missing cells	410
Missing cells (%)	5.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	59.8 KiB
Average record size in memory	113.2 B

Variable types

Text	3
Categorical	5
Numeric	5

Dataset

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

Alerts

`관리기관` has constant value ""	Constant
`노선번호` is highly overall correlated with `도로종류`	High correlation
`도로종류` is highly overall correlated with `노선번호`	High correlation
`이력코드` is highly imbalanced (93.7%)	Imbalance
`구조물종류` is highly imbalanced (89.1%)	Imbalance
`위치_방향` is highly imbalanced (82.3%)	Imbalance
`위치` has 22 (4.1%) missing values	Missing
`비고` has 388 (71.7%) missing values	Missing
`구조물 시점 구간내 이정` has 16 (3.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 23:28:06.887782
Analysis finished	2023-12-10 23:28:10.627757
Duration	3.74 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

구조물코드
Text

Distinct	540
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	4328
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	539 ?
Unique (%)	99.6%

Sample

1st row	0058B270
2nd row	0058B280
3rd row	0058B300
4th row	0058B310
5th row	0058B330

Value	Count	Frequency (%)
1084b150	2	0.4%
1005b110	1	0.2%
1005b010	1	0.2%
1005b020	1	0.2%
1005b031	1	0.2%
1005b032	1	0.2%
1004b010	1	0.2%
1004b020	1	0.2%
1004b040	1	0.2%
1004b110	1	0.2%
Other values (530)	530	98.0%

Most occurring characters

Value	Count	Frequency (%)
0	1737	40.1%
1	776	17.9%
B	529	12.2%
2	237	5.5%
4	181	4.2%
3	180	4.2%
8	170	3.9%
5	141	3.3%
7	129	3.0%
9	123	2.8%
Other values (5)	125	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3787	87.5%
Uppercase Letter	541	12.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1737	45.9%
1	776	20.5%
2	237	6.3%
4	181	4.8%
3	180	4.8%
8	170	4.5%
5	141	3.7%
7	129	3.4%
9	123	3.2%
6	113	3.0%

Uppercase Letter

Value	Count	Frequency (%)
B	529	97.8%
P	5	0.9%
T	4	0.7%
S	2	0.4%
C	1	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	3787	87.5%
Latin	541	12.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1737	45.9%
1	776	20.5%
2	237	6.3%
4	181	4.8%
3	180	4.8%
8	170	4.5%
5	141	3.7%
7	129	3.4%
9	123	3.2%
6	113	3.0%

Latin

Value	Count	Frequency (%)
B	529	97.8%
P	5	0.9%
T	4	0.7%
S	2	0.4%
C	1	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1737	40.1%
1	776	17.9%
B	529	12.2%
2	237	5.5%
4	181	4.2%
3	180	4.2%
8	170	3.9%
5	141	3.3%
7	129	3.0%
9	123	2.8%
Other values (5)	125	2.9%

관리기관
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

1683	541

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	541	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	541	100.0%

도로종류
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

1504	467
1507	74

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	467	86.3%
1507	74	13.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	467	86.3%
1507	74	13.7%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	838.89094

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

Quantile statistics

Minimum	30
5-th percentile	58
Q1	1001
median	1011
Q3	1037
95-th percentile	1089
Maximum	1099
Range	1069
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	388.55495
Coefficient of variation (CV)	0.46317695
Kurtosis	0.33662118
Mean	838.89094
Median Absolute Deviation (MAD)	18
Skewness	-1.515989
Sum	453840
Variance	150974.95
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
58	38	7.0%
1001	34	6.3%
1084	24	4.4%
60	24	4.4%
1002	24	4.4%
1003	22	4.1%
37	20	3.7%
1089	20	3.7%
1077	17	3.1%
1034	17	3.1%
Other values (33)	301	55.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	6	1.1%
37	20	3.7%
58	38	7.0%
60	24	4.4%
67	2	0.4%
69	16	3.0%
907	3	0.6%
1001	34	6.3%
1002	24	4.4%
1003	22	4.1%

Value	Count	Frequency (%)
1099	12	2.2%
1089	20	3.7%
1084	24	4.4%
1080	16	3.0%
1077	17	3.1%
1051	4	0.7%
1049	6	1.1%
1047	5	0.9%
1042	9	1.7%
1041	13	2.4%

구간번호
Real number (ℝ)

Distinct	17
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.0757856

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

Quantile statistics

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

Descriptive statistics

Standard deviation	3.57561
Coefficient of variation (CV)	0.70444464
Kurtosis	1.246674
Mean	5.0757856
Median Absolute Deviation (MAD)	2
Skewness	1.0859038
Sum	2746
Variance	12.784987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	86	15.9%
7	76	14.0%
2	74	13.7%
3	63	11.6%
5	55	10.2%
4	52	9.6%
6	30	5.5%
9	27	5.0%
8	20	3.7%
11	15	2.8%
Other values (7)	43	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	86	15.9%
2	74	13.7%
3	63	11.6%
4	52	9.6%
5	55	10.2%
6	30	5.5%
7	76	14.0%
8	20	3.7%
9	27	5.0%
10	13	2.4%

Value	Count	Frequency (%)
19	4	0.7%
16	3	0.6%
15	2	0.4%
14	7	1.3%
13	10	1.8%
12	4	0.7%
11	15	2.8%
10	13	2.4%
9	27	5.0%
8	20	3.7%

이력코드
Categorical

IMBALANCE

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

0	537
1	4

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	537	99.3%
1	4	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	537	99.3%
1	4	0.7%

구조물 시점 구간내 이정
Real number (ℝ)

ZEROS

Distinct	507
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.45885

Minimum	0
Maximum	885
Zeros	16
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.133
Q1	2.063
median	4.995
Q3	8.152
95-th percentile	14.882
Maximum	885
Range	885
Interquartile range (IQR)	6.089

Descriptive statistics

Standard deviation	57.098177
Coefficient of variation (CV)	5.4593168
Kurtosis	182.56258
Mean	10.45885
Median Absolute Deviation (MAD)	2.995
Skewness	13.181121
Sum	5658.238
Variance	3260.2018
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	16	3.0%
6.782	2	0.4%
0.72	2	0.4%
6.574	2	0.4%
3.445	2	0.4%
0.443	2	0.4%
7.0	2	0.4%
9.28	2	0.4%
7.539	2	0.4%
0.262	2	0.4%
Other values (497)	507	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	16	3.0%
0.001	1	0.2%
0.003	1	0.2%
0.015	1	0.2%
0.017	1	0.2%
0.02	1	0.2%
0.021	1	0.2%
0.024	1	0.2%
0.025	1	0.2%
0.07	1	0.2%

Value	Count	Frequency (%)
885.0	1	0.2%
803.74	1	0.2%
520.0	1	0.2%
274.0	1	0.2%
127.0	1	0.2%
26.694	1	0.2%
25.492	1	0.2%
22.924	1	0.2%
21.945	1	0.2%
19.757	1	0.2%

위치
Real number (ℝ)

MISSING

Distinct	327
Distinct (%)	63.0%
Missing	22
Missing (%)	4.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.8587453 × 10⁹

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

Quantile statistics

Minimum	4.4889033 × 10⁹
5-th percentile	4.8170328 × 10⁹
Q1	4.827037 × 10⁹
median	4.873037 × 10⁹
Q3	4.886037 × 10⁹
95-th percentile	4.8890371 × 10⁹
Maximum	4.889046 × 10⁹
Range	4.0014273 × 10⁸
Interquartile range (IQR)	58999974

Descriptive statistics

Standard deviation	33334535
Coefficient of variation (CV)	0.006860729
Kurtosis	27.337769
Mean	4.8587453 × 10⁹
Median Absolute Deviation (MAD)	15003977
Skewness	-2.8576181
Sum	2.5216888 × 10¹²
Variance	1.1111912 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4888025000	9	1.7%
4888040000	8	1.5%
4831039022	6	1.1%
4831039029	6	1.1%
4824032000	6	1.1%
4833011200	6	1.1%
4887038026	5	0.9%
4817044000	5	0.9%
4889034000	5	0.9%
4885040023	5	0.9%
Other values (317)	458	84.7%
(Missing)	22	4.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4488903300	1	0.2%
4811015100	2	0.4%
4811015400	3	0.6%
4811025032	1	0.2%
4811025041	1	0.2%
4811033000	1	0.2%
4816025025	3	0.6%
4816031022	1	0.2%
4816031026	1	0.2%
4816032025	1	0.2%

Value	Count	Frequency (%)
4889046026	1	0.2%
4889046023	1	0.2%
4889046022	1	0.2%
4889045029	2	0.4%
4889045000	2	0.4%
4889044029	1	0.2%
4889044000	4	0.7%
4889043032	1	0.2%
4889043028	2	0.4%
4889042022	1	0.2%

구조물종류
Categorical

IMBALANCE

Distinct	5
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

B	524
T	9
P	5
S	2
C	1

Length

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

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

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

Common Values

Value	Count	Frequency (%)
B	524	96.9%
T	9	1.7%
P	5	0.9%
S	2	0.4%
C	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
b	524	96.9%
t	9	1.7%
p	5	0.9%
s	2	0.4%
c	1	0.2%

구조물명
Text

Distinct	507
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

Length

Max length	12
Median length	3
Mean length	3.3585952
Min length	2

Characters and Unicode

Total characters	1817
Distinct characters	214
Distinct categories	7 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

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

Unique

Unique	484 ?
Unique (%)	89.5%

Sample

1st row	송정R-D교
2nd row	송정R-E교
3rd row	덕포교
4th row	덕포IC교
5th row	대계1교

Value	Count	Frequency (%)
무명교	7	1.3%
신촌교	4	0.7%
대천교	3	0.6%
두모교	3	0.6%
송정교	3	0.6%
용산교	3	0.6%
하림2교	2	0.4%
초정ic	2	0.4%
월광교	2	0.4%
동산교	2	0.4%
Other values (498)	512	94.3%

Most occurring characters

Value	Count	Frequency (%)
교	533	29.3%
산	47	2.6%
2	39	2.1%
대	38	2.1%
천	35	1.9%
신	33	1.8%
1	32	1.8%
월	24	1.3%
곡	24	1.3%
동	23	1.3%
Other values (204)	989	54.4%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1688	92.9%
Decimal Number	80	4.4%
Uppercase Letter	32	1.8%
Open Punctuation	6	0.3%
Dash Punctuation	5	0.3%
Close Punctuation	4	0.2%
Space Separator	2	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
교	533	31.6%
산	47	2.8%
대	38	2.3%
천	35	2.1%
신	33	2.0%
월	24	1.4%
곡	24	1.4%
동	23	1.4%
정	22	1.3%
계	21	1.2%
Other values (189)	888	52.6%

Uppercase Letter

Value	Count	Frequency (%)
I	9	28.1%
C	9	28.1%
R	5	15.6%
A	3	9.4%
P	2	6.2%
M	2	6.2%
D	1	3.1%
E	1	3.1%

Decimal Number

Value	Count	Frequency (%)
2	39	48.8%
1	32	40.0%
3	9	11.2%

Open Punctuation

Value	Count	Frequency (%)
(	6	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4	100.0%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	1688	92.9%
Common	97	5.3%
Latin	32	1.8%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
교	533	31.6%
산	47	2.8%
대	38	2.3%
천	35	2.1%
신	33	2.0%
월	24	1.4%
곡	24	1.4%
동	23	1.4%
정	22	1.3%
계	21	1.2%
Other values (189)	888	52.6%

Latin

Value	Count	Frequency (%)
I	9	28.1%
C	9	28.1%
R	5	15.6%
A	3	9.4%
P	2	6.2%
M	2	6.2%
D	1	3.1%
E	1	3.1%

Common

Value	Count	Frequency (%)
2	39	40.2%
1	32	33.0%
3	9	9.3%
(	6	6.2%
-	5	5.2%
)	4	4.1%
	2	2.1%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	1688	92.9%
ASCII	129	7.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
교	533	31.6%
산	47	2.8%
대	38	2.3%
천	35	2.1%
신	33	2.0%
월	24	1.4%
곡	24	1.4%
동	23	1.4%
정	22	1.3%
계	21	1.2%
Other values (189)	888	52.6%

ASCII

Value	Count	Frequency (%)
2	39	30.2%
1	32	24.8%
I	9	7.0%
C	9	7.0%
3	9	7.0%
(	6	4.7%
-	5	3.9%
R	5	3.9%
)	4	3.1%
A	3	2.3%
Other values (5)	8	6.2%

위치_방향
Categorical

IMBALANCE

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.4 KiB

2	516
0	24
1	1

Length

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

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

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

Common Values

Value	Count	Frequency (%)
2	516	95.4%
0	24	4.4%
1	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	516	95.4%
0	24	4.4%
1	1	0.2%

시설물등급
Real number (ℝ)

Distinct	6
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2547.549

Minimum	2500
Maximum	2601
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.9 KiB

Quantile statistics

Minimum	2500
5-th percentile	2501
Q1	2502
median	2502
Q3	2599
95-th percentile	2599
Maximum	2601
Range	101
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	48.767702
Coefficient of variation (CV)	0.019142989
Kurtosis	-1.9936593
Mean	2547.549
Median Absolute Deviation (MAD)	2
Skewness	0.11499531
Sum	1378224
Variance	2378.2888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2599	229	42.3%
2502	172	31.8%
2501	98	18.1%
2500	16	3.0%
2600	15	2.8%
2601	11	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2500	16	3.0%
2501	98	18.1%
2502	172	31.8%
2599	229	42.3%
2600	15	2.8%
2601	11	2.0%

Value	Count	Frequency (%)
2601	11	2.0%
2600	15	2.8%
2599	229	42.3%
2502	172	31.8%
2501	98	18.1%
2500	16	3.0%

비고
Text

MISSING

Distinct	116
Distinct (%)	75.8%
Missing	388
Missing (%)	71.7%
Memory size	4.4 KiB

Length

Max length	16
Median length	11
Mean length	11.215686
Min length	2

Characters and Unicode

Total characters	1716
Distinct characters	134
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

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

Unique

Unique	90 ?
Unique (%)	58.8%

Sample

1st row	거제시 연초면 송정리
2nd row	거제시 덕포동
3rd row	거제시 장목면 농소리
4th row	거제시 장목면 농소리
5th row	거제시 장목면 유호리

Value	Count	Frequency (%)
거창군	33	7.2%
합천군	22	4.8%
경상남도	20	4.3%
창녕군	12	2.6%
함안군	10	2.2%
산청군	10	2.2%
거창읍	9	2.0%
진주시	9	2.0%
함양군	9	2.0%
야로면	9	2.0%
Other values (170)	318	69.0%

Most occurring characters

Value	Count	Frequency (%)
	308	17.9%
리	141	8.2%
면	132	7.7%
군	108	6.3%
창	56	3.3%
천	48	2.8%
거	47	2.7%
시	41	2.4%
산	38	2.2%
남	32	1.9%
Other values (124)	765	44.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1408	82.1%
Space Separator	308	17.9%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
리	141	10.0%
면	132	9.4%
군	108	7.7%
창	56	4.0%
천	48	3.4%
거	47	3.3%
시	41	2.9%
산	38	2.7%
남	32	2.3%
상	30	2.1%
Other values (123)	735	52.2%

Space Separator

Value	Count	Frequency (%)
	308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	1408	82.1%
Common	308	17.9%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
리	141	10.0%
면	132	9.4%
군	108	7.7%
창	56	4.0%
천	48	3.4%
거	47	3.3%
시	41	2.9%
산	38	2.7%
남	32	2.3%
상	30	2.1%
Other values (123)	735	52.2%

Common

Value	Count	Frequency (%)
	308	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	1408	82.1%
ASCII	308	17.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	308	100.0%

Hangul

Value	Count	Frequency (%)
리	141	10.0%
면	132	9.4%
군	108	7.7%
창	56	4.0%
천	48	3.4%
거	47	3.3%
시	41	2.9%
산	38	2.7%
남	32	2.3%
상	30	2.1%
Other values (123)	735	52.2%

Heatmap
Table

	도로종류	노선번호	구간번호	이력코드	구조물 시점 구간내 이정	위치	구조물종류	위치_방향	시설물등급
도로종류	1.000	0.539	0.289	0.000	0.000	0.000	0.000	0.008	0.513
노선번호	0.539	1.000	0.421	0.000	0.144	0.081	0.097	0.000	0.132
구간번호	0.289	0.421	1.000	0.044	0.000	0.334	0.094	0.078	0.198
이력코드	0.000	0.000	0.044	1.000	0.000	0.115	0.000	0.000	0.082
구조물 시점 구간내 이정	0.000	0.144	0.000	0.000	1.000	NaN	0.739	0.375	0.031
위치	0.000	0.081	0.334	0.115	NaN	1.000	0.000	0.024	0.128
구조물종류	0.000	0.097	0.094	0.000	0.739	0.000	1.000	0.272	0.043
위치_방향	0.008	0.000	0.078	0.000	0.375	0.024	0.272	1.000	0.103
시설물등급	0.513	0.132	0.198	0.082	0.031	0.128	0.043	0.103	1.000

Heatmap
Table

	위치_방향	도로종류	이력코드	구조물종류
위치_방향	1.000	0.013	0.000	0.212
도로종류	0.013	1.000	0.000	0.000
이력코드	0.000	0.000	1.000	0.000
구조물종류	0.212	0.000	0.000	1.000

Heatmap
Table

	노선번호	구간번호	구조물 시점 구간내 이정	위치	시설물등급	도로종류	이력코드	구조물종류	위치_방향
노선번호	1.000	-0.195	-0.022	0.191	-0.120	0.805	0.000	0.072	0.000
구간번호	-0.195	1.000	-0.020	0.218	-0.123	0.234	0.033	0.039	0.061
구조물 시점 구간내 이정	-0.022	-0.020	1.000	0.052	0.090	0.000	0.000	0.363	0.306
위치	0.191	0.218	0.052	1.000	-0.023	0.000	0.089	0.000	0.000
시설물등급	-0.120	-0.123	0.090	-0.023	1.000	0.349	0.055	0.049	0.162
도로종류	0.805	0.234	0.000	0.000	0.349	1.000	0.000	0.000	0.013
이력코드	0.000	0.033	0.000	0.089	0.055	0.000	1.000	0.000	0.000
구조물종류	0.072	0.039	0.363	0.000	0.049	0.000	0.000	1.000	0.212
위치_방향	0.000	0.061	0.306	0.000	0.162	0.013	0.000	0.212	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	0058B270	1683	1504	58	7	0.544	4831037030	B	송정R-D교	2	2501	<NA>
1	0058B280	1683	1504	58	7	0.552	4831037030	B	송정R-E교	2	2501	<NA>
2	0058B300	1683	1504	58	7	1.375	4831010700	B	덕포교	2	2501	<NA>
3	0058B310	1683	1504	58	7	2.568	4831010700	B	덕포IC교	2	2599	<NA>
4	0058B330	1683	1504	58	7	3.97	4831039029	B	대계1교	2	2501	<NA>
5	0058B340	1683	1504	58	7	4.435	4831039029	B	대계2교	2	2501	<NA>
6	0058B350	1683	1504	58	7	4.895	4831039029	B	대계3교	2	2502	<NA>
7	0058B360	1683	1504	58	7	5.572	4831039029	B	외포IC교	2	2599	<NA>
8	0058B370	1683	1504	58	7	5.951	4831039029	B	외포1교	2	2501	<NA>
9	0058B380	1683	1504	58	7	7.08	4831039029	B	외포2교	2	2501	<NA>

	구조물코드	관리기관	도로종류	노선번호	구간번호	구조물 시점 구간내 이정	위치	구조물종류	구조물명	위치_방향	시설물등급	비고
531	0069B270	1683	1507	69	6	3.492	4833032023	B	선장교	2	2502	<NA>
532	0069B350	1683	1507	69	6	6.667	4833032024	B	영포교	2	2599	<NA>
533	0069B580	1683	1507	69	7	6.522	4833032026	B	장선교	2	2599	<NA>
534	0069B030	1683	1507	69	2	0.443	4825037028	B	덕산1교	2	2599	<NA>
535	0069B020	1683	1507	69	2	0.025	4825037028	B	덕산2교	2	2599	<NA>
536	0069B040	1683	1507	69	2	4.425	4825036022	B	매리2교	2	2599	<NA>
537	0069B130	1683	1507	69	7	4.302	4833032026	B	선리교	2	2599	<NA>
538	0069B120	1683	1507	69	7	0.5	4833032025	B	고점교	2	2599	<NA>
539	0060B580	1683	1507	60	19	6.405	<NA>	B	법기1교	2	2601	양산시 동면 법기리
540	0058B260	1683	1504	58	7	0.015	4831037030	B	송정R-A교	2	2501	<NA>

Overview

Variables

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

Common Values

Length

Common Values (Plot)

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

Other Letter

Uppercase Letter

Decimal Number

Open Punctuation

Dash Punctuation

Close Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample