gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	146.0 B

Variable types

Categorical	8
Numeric	8

Dataset

Description	대전광역시 도로관리시스템에 등재된 가로등 현황입니다. ※ 2022년 공공데이터 기업 매칭 지원사업으로 청년 인턴을 통해 정비·구축된 데이터입니다. 법적 효력이 없으므로 참고 목적으로만 활용하시기 바랍니다.
URL	https://www.data.go.kr/data/15110054/fileData.do

Alerts

`지형지물부호` has constant value ""	Constant
`대장초기화여부` has constant value ""	Constant
`등주형식` is highly overall correlated with `등주높이` and 4 other fields	High correlation
`등기구수량` is highly overall correlated with `등주높이` and 4 other fields	High correlation
`관리번호` is highly overall correlated with `행정읍면동`	High correlation
`도엽번호` is highly overall correlated with `위도`	High correlation
`등주높이` is highly overall correlated with `암길이` and 5 other fields	High correlation
`암길이` is highly overall correlated with `등주높이` and 2 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 `등주높이` and 5 other fields	High correlation
`등주재질` is highly overall correlated with `등주높이` and 5 other fields	High correlation
`광원종류` is highly overall correlated with `등주높이` and 4 other fields	High correlation
`등기구모형` is highly imbalanced (94.1%)	Imbalance
`등주형식` is highly imbalanced (92.5%)	Imbalance
`등주재질` is highly imbalanced (93.3%)	Imbalance
`등기구수량` is highly imbalanced (90.7%)	Imbalance
`광원종류` is highly imbalanced (93.0%)	Imbalance
`암길이` is highly skewed (γ1 = 24.92002211)	Skewed
`관리번호` has unique values	Unique
`등주높이` has 9808 (98.1%) zeros	Zeros
`암길이` has 9825 (98.2%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 05:17:15.405811
Analysis finished	2023-12-12 05:17:26.801077
Duration	11.4 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

지형지물부호
Categorical

CONSTANT

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

가로등	10000

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	가로등
2nd row	가로등
3rd row	가로등
4th row	가로등
5th row	가로등

Common Values

Value	Count	Frequency (%)
가로등	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
가로등	10000	100.0%

관리번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21647.57

Minimum	5
Maximum	43093
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	5
5-th percentile	2170.9
Q1	10966.5
median	21508.5
Q3	32351.5
95-th percentile	41032.35
Maximum	43093
Range	43088
Interquartile range (IQR)	21385

Descriptive statistics

Standard deviation	12413.113
Coefficient of variation (CV)	0.57341831
Kurtosis	-1.1897055
Mean	21647.57
Median Absolute Deviation (MAD)	10720.5
Skewness	-0.0067245118
Sum	2.164757 × 10⁸
Variance	1.5408537 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10605	1	< 0.1%
28877	1	< 0.1%
36567	1	< 0.1%
36029	1	< 0.1%
40998	1	< 0.1%
32569	1	< 0.1%
22463	1	< 0.1%
31602	1	< 0.1%
4556	1	< 0.1%
33886	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
15	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
22	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
29	1	< 0.1%

Value	Count	Frequency (%)
43093	1	< 0.1%
43089	1	< 0.1%
43087	1	< 0.1%
43085	1	< 0.1%
43084	1	< 0.1%
43082	1	< 0.1%
43076	1	< 0.1%
43067	1	< 0.1%
43064	1	< 0.1%
43058	1	< 0.1%

행정읍면동
Categorical

HIGH CORRELATION

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

대전광역시 유성구	4035
대전광역시 서구	2104
대전광역시 동구	1377
대전광역시 대덕구	1286
대전광역시 중구	1198

Length

Max length	10
Median length	10
Mean length	9.5321
Min length	9

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	대전광역시 대덕구
2nd row	대전광역시 동구
3rd row	대전광역시 동구
4th row	대전광역시 중구
5th row	대전광역시 중구

Common Values

Value	Count	Frequency (%)
대전광역시 유성구	4035	40.4%
대전광역시 서구	2104	21.0%
대전광역시 동구	1377	13.8%
대전광역시 대덕구	1286	12.9%
대전광역시 중구	1198	12.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
대전광역시	10000	50.0%
유성구	4035	20.2%
서구	2104	10.5%
동구	1377	6.9%
대덕구	1286	6.4%
중구	1198	6.0%

도엽번호
Real number (ℝ)

HIGH CORRELATION

Distinct	58
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36710059

Minimum	36710005
Maximum	36710099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	36710005
5-th percentile	36710026
Q1	36710047
median	36710063
Q3	36710074
95-th percentile	36710086
Maximum	36710099
Range	94
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	17.418909
Coefficient of variation (CV)	4.7449962 × 10^-7
Kurtosis	-0.23269496
Mean	36710059
Median Absolute Deviation (MAD)	11
Skewness	-0.44510312
Sum	3.6710059 × 10¹¹
Variance	303.4184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36710064	556	5.6%
36710068	496	5.0%
36710056	460	4.6%
36710054	458	4.6%
36710067	422	4.2%
36710043	375	3.8%
36710066	364	3.6%
36710063	359	3.6%
36710026	337	3.4%
36710078	322	3.2%
Other values (48)	5851	58.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36710005	25	0.2%
36710006	9	0.1%
36710010	1	< 0.1%
36710015	47	0.5%
36710016	20	0.2%
36710017	26	0.3%
36710018	40	0.4%
36710019	13	0.1%
36710026	337	3.4%
36710027	262	2.6%

Value	Count	Frequency (%)
36710099	45	0.4%
36710096	5	0.1%
36710094	37	0.4%
36710089	174	1.7%
36710088	28	0.3%
36710087	16	0.2%
36710086	203	2.0%
36710085	37	0.4%
36710084	240	2.4%
36710083	135	1.4%

도로구간번호
Real number (ℝ)

Distinct	6082
Distinct (%)	60.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38644.881

Minimum	1510
Maximum	134875
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1510
5-th percentile	13842
Q1	21501.5
median	33985
Q3	43511.25
95-th percentile	101386.65
Maximum	134875
Range	133365
Interquartile range (IQR)	22009.75

Descriptive statistics

Standard deviation	25909.606
Coefficient of variation (CV)	0.67045377
Kurtosis	3.4515145
Mean	38644.881
Median Absolute Deviation (MAD)	10919
Skewness	1.9169949
Sum	3.8644881 × 10⁸
Variance	6.7130769 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
46986	28	0.3%
41367	18	0.2%
13792	17	0.2%
43406	16	0.2%
17169	13	0.1%
13860	13	0.1%
37201	12	0.1%
37161	12	0.1%
42446	12	0.1%
31607	12	0.1%
Other values (6072)	9847	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1510	4	< 0.1%
2658	1	< 0.1%
2823	1	< 0.1%
2881	2	< 0.1%
2931	1	< 0.1%
3163	1	< 0.1%
3165	1	< 0.1%
3175	1	< 0.1%
3313	1	< 0.1%
3324	1	< 0.1%

Value	Count	Frequency (%)
134875	1	< 0.1%
134851	1	< 0.1%
134845	1	< 0.1%
134839	1	< 0.1%
134826	1	< 0.1%
134823	1	< 0.1%
134822	1	< 0.1%
134761	1	< 0.1%
134756	2	< 0.1%
134753	1	< 0.1%

등기구모형
Categorical

HIGH CORRELATION IMBALANCE

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

미분류	9831
기타	95
가오스형(신),	33
LED	23
올챙이형	14

Length

Max length	8
Median length	3
Mean length	3.0084
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	미분류
2nd row	미분류
3rd row	미분류
4th row	미분류
5th row	미분류

Common Values

Value	Count	Frequency (%)
미분류	9831	98.3%
기타	95	0.9%
가오스형(신),	33	0.3%
LED	23	0.2%
올챙이형	14	0.1%
사각형	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
미분류	9831	98.3%
기타	95	0.9%
가오스형(신	33	0.3%
led	23	0.2%
올챙이형	14	0.1%
사각형	4	< 0.1%

등주높이
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14285

Minimum	0
Maximum	11
Zeros	9808
Zeros (%)	98.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.0594721
Coefficient of variation (CV)	7.4166755
Kurtosis	59.352057
Mean	0.14285
Median Absolute Deviation (MAD)	0
Skewness	7.681306
Sum	1428.5
Variance	1.1224811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0.0	9808	98.1%
8.0	83	0.8%
4.0	34	0.3%
9.0	27	0.3%
5.5	23	0.2%
10.0	16	0.2%
11.0	9	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	9808	98.1%
4.0	34	0.3%
5.5	23	0.2%
8.0	83	0.8%
9.0	27	0.3%
10.0	16	0.2%
11.0	9	0.1%

Value	Count	Frequency (%)
11.0	9	0.1%
10.0	16	0.2%
9.0	27	0.3%
8.0	83	0.8%
5.5	23	0.2%
4.0	34	0.3%
0.0	9808	98.1%

등주형식
Categorical

HIGH CORRELATION IMBALANCE

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

미분류	9808
기본형	58
원형	53
사각	51
2등형	30

Length

Max length	3
Median length	3
Mean length	2.9896
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	미분류
2nd row	미분류
3rd row	미분류
4th row	미분류
5th row	미분류

Common Values

Value	Count	Frequency (%)
미분류	9808	98.1%
기본형	58	0.6%
원형	53	0.5%
사각	51	0.5%
2등형	30	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
미분류	9808	98.1%
기본형	58	0.6%
원형	53	0.5%
사각	51	0.5%
2등형	30	0.3%

등주재질
Categorical

HIGH CORRELATION IMBALANCE

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

미분류	9808
강관	90
강판	51
스텐레스	31
STEEL	14

Length

Max length	5
Median length	3
Mean length	2.9912
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	미분류
2nd row	미분류
3rd row	미분류
4th row	미분류
5th row	미분류

Common Values

Value	Count	Frequency (%)
미분류	9808	98.1%
강관	90	0.9%
강판	51	0.5%
스텐레스	31	0.3%
STEEL	14	0.1%
주철	6	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
미분류	9808	98.1%
강관	90	0.9%
강판	51	0.5%
스텐레스	31	0.3%
steel	14	0.1%
주철	6	0.1%

암길이
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05975

Minimum	0
Maximum	25
Zeros	9825
Zeros (%)	98.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.95639762
Coefficient of variation (CV)	16.006655
Kurtosis	645.04034
Mean	0.05975
Median Absolute Deviation (MAD)	0
Skewness	24.920022
Sum	597.5
Variance	0.91469641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0.0	9825	98.2%
1.0	80	0.8%
2.0	58	0.6%
2.5	17	0.2%
25.0	14	0.1%
1.5	6	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	9825	98.2%
1.0	80	0.8%
1.5	6	0.1%
2.0	58	0.6%
2.5	17	0.2%
25.0	14	0.1%

Value	Count	Frequency (%)
25.0	14	0.1%
2.5	17	0.2%
2.0	58	0.6%
1.5	6	0.1%
1.0	80	0.8%
0.0	9825	98.2%

등기구수량
Categorical

HIGH CORRELATION IMBALANCE

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

0	9808
1	167
2	25

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	9808	98.1%
1	167	1.7%
2	25	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	9808	98.1%
1	167	1.7%
2	25	0.2%

광원종류
Categorical

HIGH CORRELATION IMBALANCE

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

미분류	9808
기타	132
메탈할라이드	33
고압나트륨램프	23
CDM	4

Length

Max length	7
Median length	3
Mean length	3.0059
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	미분류
2nd row	미분류
3rd row	미분류
4th row	미분류
5th row	미분류

Common Values

Value	Count	Frequency (%)
미분류	9808	98.1%
기타	132	1.3%
메탈할라이드	33	0.3%
고압나트륨램프	23	0.2%
CDM	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
미분류	9808	98.1%
기타	132	1.3%
메탈할라이드	33	0.3%
고압나트륨램프	23	0.2%
cdm	4	< 0.1%

가로등제어기관리번호
Real number (ℝ)

Distinct	1362
Distinct (%)	13.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.8890004 × 10⁹

Minimum	1
Maximum	1 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	227
Q1	1058
median	1 × 10¹⁰
Q3	1 × 10¹⁰
95-th percentile	1 × 10¹⁰
Maximum	1 × 10¹⁰
Range	1 × 10¹⁰
Interquartile range (IQR)	9.9999989 × 10⁹

Descriptive statistics

Standard deviation	4.9205788 × 10⁹
Coefficient of variation (CV)	0.83555417
Kurtosis	-1.8697555
Mean	5.8890004 × 10⁹
Median Absolute Deviation (MAD)	0
Skewness	-0.36141185
Sum	5.8890004 × 10¹³
Variance	2.4212096 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9999999999	5889	58.9%
1210	12	0.1%
1293	12	0.1%
681	11	0.1%
1021	11	0.1%
1292	11	0.1%
1206	11	0.1%
735	10	0.1%
1097	10	0.1%
1252	10	0.1%
Other values (1352)	4013	40.1%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
9999999999	5889	58.9%
1627	1	< 0.1%
1626	6	0.1%
1624	2	< 0.1%
1622	1	< 0.1%
1621	1	< 0.1%
1620	3	< 0.1%
1619	4	< 0.1%
1618	7	0.1%
1616	2	< 0.1%

대장초기화여부
Categorical

CONSTANT

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

1	10000

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	10000	100.0%

위도
Real number (ℝ)

HIGH CORRELATION

Distinct	9992
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.353495

Minimum	36.25002
Maximum	36.482975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	36.25002
5-th percentile	36.293
Q1	36.322819
median	36.34772
Q3	36.377663
95-th percentile	36.437744
Maximum	36.482975
Range	0.23295495
Interquartile range (IQR)	0.054844585

Descriptive statistics

Standard deviation	0.043037403
Coefficient of variation (CV)	0.0011838587
Kurtosis	-0.091654237
Mean	36.353495
Median Absolute Deviation (MAD)	0.026865055
Skewness	0.55241063
Sum	363534.95
Variance	0.001852218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.34253321	2	< 0.1%
36.43054287	2	< 0.1%
36.31045711	2	< 0.1%
36.29155162	2	< 0.1%
36.34021976	2	< 0.1%
36.29542473	2	< 0.1%
36.3657342	2	< 0.1%
36.34091589	2	< 0.1%
36.39458941	1	< 0.1%
36.38308767	1	< 0.1%
Other values (9982)	9982	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.25002036	1	< 0.1%
36.25092386	1	< 0.1%
36.25176667	1	< 0.1%
36.2518575	1	< 0.1%
36.25194508	1	< 0.1%
36.25236618	1	< 0.1%
36.25272545	1	< 0.1%
36.25319526	1	< 0.1%
36.25331576	1	< 0.1%
36.25331774	1	< 0.1%

Value	Count	Frequency (%)
36.48297531	1	< 0.1%
36.48252541	1	< 0.1%
36.48244965	1	< 0.1%
36.48229535	1	< 0.1%
36.48213068	1	< 0.1%
36.48135542	1	< 0.1%
36.48127333	1	< 0.1%
36.48112899	1	< 0.1%
36.48090232	1	< 0.1%
36.48032039	1	< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION

Distinct	9971
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127.38198

Minimum	127.2584
Maximum	127.47628
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	127.2584
5-th percentile	127.3086
Q1	127.34178
median	127.38526
Q3	127.4188
95-th percentile	127.4564
Maximum	127.47628
Range	0.2178806
Interquartile range (IQR)	0.077018825

Descriptive statistics

Standard deviation	0.045852408
Coefficient of variation (CV)	0.00035995992
Kurtosis	-0.96377769
Mean	127.38198
Median Absolute Deviation (MAD)	0.03826075
Skewness	-0.024338573
Sum	1273819.8
Variance	0.0021024434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
127.319659	2	< 0.1%
127.3109828	2	< 0.1%
127.4554824	2	< 0.1%
127.3865666	2	< 0.1%
127.3341837	2	< 0.1%
127.3353142	2	< 0.1%
127.3202595	2	< 0.1%
127.4152972	2	< 0.1%
127.4185	2	< 0.1%
127.3861679	2	< 0.1%
Other values (9961)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
127.2583953	1	< 0.1%
127.259325	1	< 0.1%
127.2593952	1	< 0.1%
127.2596675	1	< 0.1%
127.2604437	1	< 0.1%
127.2609424	1	< 0.1%
127.2611002	1	< 0.1%
127.2613334	1	< 0.1%
127.2614786	1	< 0.1%
127.2619731	1	< 0.1%

Value	Count	Frequency (%)
127.4762759	1	< 0.1%
127.4752563	1	< 0.1%
127.4751071	1	< 0.1%
127.4748851	1	< 0.1%
127.4748436	1	< 0.1%
127.4748162	1	< 0.1%
127.4748145	1	< 0.1%
127.4747811	1	< 0.1%
127.4747522	1	< 0.1%
127.474709	1	< 0.1%

Heatmap
Table

	관리번호	행정읍면동	도엽번호	도로구간번호	등기구모형	등주높이	등주형식	등주재질	암길이	등기구수량	광원종류	가로등제어기관리번호	위도	경도
관리번호	1.000	0.949	0.787	0.665	0.320	0.340	0.461	0.340	0.190	0.442	0.461	0.367	0.763	0.795
행정읍면동	0.949	1.000	0.769	0.723	0.106	0.098	0.184	0.122	0.043	0.111	0.238	0.124	0.773	0.898
도엽번호	0.787	0.769	1.000	0.700	0.489	0.558	0.689	0.475	0.098	0.455	0.545	0.184	0.978	0.578
도로구간번호	0.665	0.723	0.700	1.000	0.426	0.390	0.527	0.345	0.076	0.399	0.519	0.213	0.728	0.650
등기구모형	0.320	0.106	0.489	0.426	1.000	0.958	0.775	0.960	0.969	0.936	0.913	0.123	0.640	0.639
등주높이	0.340	0.098	0.558	0.390	0.958	1.000	0.871	0.958	0.912	0.973	0.805	0.099	0.604	0.606
등주형식	0.461	0.184	0.689	0.527	0.775	0.871	1.000	0.868	0.558	0.901	0.932	0.073	0.783	0.625
등주재질	0.340	0.122	0.475	0.345	0.960	0.958	0.868	1.000	0.985	0.978	0.801	0.102	0.556	0.479
암길이	0.190	0.043	0.098	0.076	0.969	0.912	0.558	0.985	1.000	0.821	0.440	0.008	0.119	0.113
등기구수량	0.442	0.111	0.455	0.399	0.936	0.973	0.901	0.978	0.821	1.000	0.730	0.030	0.631	0.382
광원종류	0.461	0.238	0.545	0.519	0.913	0.805	0.932	0.801	0.440	0.730	1.000	0.069	0.723	0.503
가로등제어기관리번호	0.367	0.124	0.184	0.213	0.123	0.099	0.073	0.102	0.008	0.030	0.069	1.000	0.210	0.262
위도	0.763	0.773	0.978	0.728	0.640	0.604	0.783	0.556	0.119	0.631	0.723	0.210	1.000	0.605
경도	0.795	0.898	0.578	0.650	0.639	0.606	0.625	0.479	0.113	0.382	0.503	0.262	0.605	1.000

Heatmap
Table

	등주형식	등기구수량	광원종류	행정읍면동	등주재질	등기구모형
등주형식	1.000	0.951	0.637	0.070	0.788	0.655
등기구수량	0.951	1.000	0.723	0.084	0.818	0.693
광원종류	0.637	0.723	1.000	0.091	0.690	0.866
행정읍면동	0.070	0.084	0.091	1.000	0.082	0.071
등주재질	0.788	0.818	0.690	0.082	1.000	0.705
등기구모형	0.655	0.693	0.866	0.071	0.705	1.000

Heatmap
Table

	관리번호	도엽번호	도로구간번호	등주높이	암길이	가로등제어기관리번호	위도	경도	행정읍면동	등기구모형	등주형식	등주재질	등기구수량	광원종류
관리번호	1.000	-0.089	0.121	-0.161	-0.154	-0.159	0.021	-0.367	0.691	0.174	0.209	0.186	0.297	0.209
도엽번호	-0.089	1.000	-0.391	-0.088	-0.103	-0.064	-0.969	0.195	0.425	0.335	0.370	0.290	0.393	0.317
도로구간번호	0.121	-0.391	1.000	0.122	0.119	-0.069	0.352	-0.378	0.383	0.240	0.246	0.189	0.262	0.241
등주높이	-0.161	-0.088	0.122	1.000	0.953	0.054	0.083	-0.060	0.066	0.695	0.794	0.698	0.798	0.696
암길이	-0.154	-0.103	0.119	0.953	1.000	0.047	0.103	-0.041	0.027	1.000	0.397	1.000	0.287	0.323
가로등제어기관리번호	-0.159	-0.064	-0.069	0.054	0.047	1.000	0.090	0.100	0.152	0.088	0.089	0.074	0.050	0.084
위도	0.021	-0.969	0.352	0.083	0.103	0.090	1.000	-0.043	0.429	0.405	0.439	0.333	0.477	0.383
경도	-0.367	0.195	-0.378	-0.060	-0.041	0.100	-0.043	1.000	0.585	0.403	0.308	0.276	0.248	0.232
행정읍면동	0.691	0.425	0.383	0.066	0.027	0.152	0.429	0.585	1.000	0.071	0.070	0.082	0.084	0.091
등기구모형	0.174	0.335	0.240	0.695	1.000	0.088	0.405	0.403	0.071	1.000	0.655	0.705	0.693	0.866
등주형식	0.209	0.370	0.246	0.794	0.397	0.089	0.439	0.308	0.070	0.655	1.000	0.788	0.951	0.637
등주재질	0.186	0.290	0.189	0.698	1.000	0.074	0.333	0.276	0.082	0.705	0.788	1.000	0.818	0.690
등기구수량	0.297	0.393	0.262	0.798	0.287	0.050	0.477	0.248	0.084	0.693	0.951	0.818	1.000	0.723
광원종류	0.209	0.317	0.241	0.696	0.323	0.084	0.383	0.232	0.091	0.866	0.637	0.690	0.723	1.000

Count
Matrix

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.

First rows
Last rows

	지형지물부호	관리번호	행정읍면동	도엽번호	도로구간번호	등기구모형	등주형식	등주재질	광원종류	가로등제어기관리번호	대장초기화여부	위도	경도
10596	가로등	10605	대전광역시 대덕구	36710048	36309	미분류	미분류	미분류	미분류	9999999999	1	36.376837	127.427412
4922	가로등	4928	대전광역시 동구	36710068	20784	미분류	미분류	미분류	미분류	9999999999	1	36.345164	127.446184
14087	가로등	14099	대전광역시 동구	36710089	13533	미분류	미분류	미분류	미분류	9999999999	1	36.288152	127.457784
16637	가로등	16649	대전광역시 중구	36710068	25539	미분류	미분류	미분류	미분류	9999999999	1	36.32585	127.43196
41944	가로등	41957	대전광역시 중구	36710067	27543	미분류	미분류	미분류	미분류	879	1	36.33865	127.413581
18516	가로등	18528	대전광역시 서구	36710086	33476	미분류	미분류	미분류	미분류	9999999999	1	36.299562	127.378508
18831	가로등	18843	대전광역시 서구	36710084	13770	미분류	미분류	미분류	미분류	9999999999	1	36.291859	127.327822
14972	가로등	14984	대전광역시 동구	36710079	23476	미분류	미분류	미분류	미분류	1246	1	36.319538	127.461857
19123	가로등	19135	대전광역시 서구	36710084	13689	미분류	미분류	미분류	미분류	9999999999	1	36.291811	127.333901
38204	가로등	38217	대전광역시 유성구	36710036	13784	미분류	미분류	미분류	미분류	9999999999	1	36.411489	127.381454

	지형지물부호	관리번호	행정읍면동	도엽번호	도로구간번호	등기구모형	등주형식	등주재질	광원종류	가로등제어기관리번호	대장초기화여부	위도	경도
19788	가로등	19800	대전광역시 서구	36710084	34403	미분류	미분류	미분류	미분류	1097	1	36.296047	127.33466
38144	가로등	38157	대전광역시 유성구	36710036	42870	미분류	미분류	미분류	미분류	9999999999	1	36.408581	127.377943
33061	가로등	33074	대전광역시 유성구	36710054	44686	미분류	미분류	미분류	미분류	701	1	36.357399	127.349569
13755	가로등	13767	대전광역시 동구	36710089	14167	미분류	미분류	미분류	미분류	9999999999	1	36.277624	127.464207
12622	가로등	12631	대전광역시 대덕구	36710028	35955	미분류	미분류	미분류	미분류	9999999999	1	36.440543	127.428652
41360	가로등	41373	대전광역시 중구	36710077	22479	미분류	미분류	미분류	미분류	888	1	36.321087	127.415213
34464	가로등	34477	대전광역시 유성구	36710053	43697	미분류	미분류	미분류	미분류	9999999999	1	36.372588	127.319401
37927	가로등	37940	대전광역시 유성구	36710037	39524	미분류	미분류	미분류	미분류	9999999999	1	36.421538	127.404504
41391	가로등	41404	대전광역시 중구	36710077	66666	미분류	미분류	미분류	미분류	891	1	36.323139	127.413858
6145	가로등	6152	대전광역시 대덕구	36710027	38577	미분류	미분류	미분류	미분류	9999999999	1	36.445417	127.407573

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample