gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	1451
Missing cells	102
Missing cells (%)	0.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	225.4 KiB
Average record size in memory	159.1 B

Variable types

Numeric	9
Categorical	8
Text	1

Dataset

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

Alerts

`관리기관` has constant value ""	Constant
`설치일자` is highly overall correlated with `이력코드` and 2 other fields	High correlation
`이력코드` is highly overall correlated with `광원용량` and 2 other fields	High correlation
`비고` is highly overall correlated with `식별번호` and 8 other fields	High correlation
`도로종류` is highly overall correlated with `식별번호` and 3 other fields	High correlation
`식별번호` is highly overall correlated with `노선번호` and 3 other fields	High correlation
`관리번호` is highly overall correlated with `노선번호` and 1 other fields	High correlation
`노선번호` is highly overall correlated with `식별번호` and 3 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 `비고`	High correlation
`등주재질` is highly overall correlated with `비고`	High correlation
`광원용량` is highly overall correlated with `식별번호` and 3 other fields	High correlation
`이력코드` is highly imbalanced (89.9%)	Imbalance
`광원종류` is highly imbalanced (64.0%)	Imbalance
`설치일자` is highly imbalanced (84.2%)	Imbalance
`비고` is highly imbalanced (85.0%)	Imbalance
`사진` has 102 (7.0%) missing values	Missing
`식별번호` has unique values	Unique
`관리번호` has 90 (6.2%) zeros	Zeros
`위치_종점` has 24 (1.7%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 23:56:43.066218
Analysis finished	2023-12-10 23:56:55.208349
Duration	12.14 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

식별번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1451
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	726

Minimum	1
Maximum	1451
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	1
5-th percentile	73.5
Q1	363.5
median	726
Q3	1088.5
95-th percentile	1378.5
Maximum	1451
Range	1450
Interquartile range (IQR)	725

Descriptive statistics

Standard deviation	419.01193
Coefficient of variation (CV)	0.57715142
Kurtosis	-1.2
Mean	726
Median Absolute Deviation (MAD)	363
Skewness	0
Sum	1053426
Variance	175571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
827	1	0.1%
825	1	0.1%
824	1	0.1%
823	1	0.1%
822	1	0.1%
821	1	0.1%
820	1	0.1%
819	1	0.1%
818	1	0.1%
Other values (1441)	1441	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
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%
10	1	0.1%

Value	Count	Frequency (%)
1451	1	0.1%
1450	1	0.1%
1449	1	0.1%
1448	1	0.1%
1447	1	0.1%
1446	1	0.1%
1445	1	0.1%
1444	1	0.1%
1443	1	0.1%
1442	1	0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1341
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7729109.7

Minimum	0
Maximum	10990009
Zeros	90
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	690024.5
median	10100014
Q3	10215014
95-th percentile	10840012
Maximum	10990009
Range	10990009
Interquartile range (IQR)	9524989.5

Descriptive statistics

Standard deviation	4315222.5
Coefficient of variation (CV)	0.55830783
Kurtosis	-0.72883773
Mean	7729109.7
Median Absolute Deviation (MAD)	119991
Skewness	-1.1186955
Sum	1.1214938 × 10¹⁰
Variance	1.8621145 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	90	6.2%
10220001	2	0.1%
600004	2	0.1%
600005	2	0.1%
600007	2	0.1%
10770027	2	0.1%
690001	2	0.1%
690004	2	0.1%
690002	2	0.1%
690006	2	0.1%
Other values (1331)	1343	92.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	90	6.2%
300001	1	0.1%
300002	1	0.1%
300003	1	0.1%
300004	1	0.1%
300005	1	0.1%
300006	1	0.1%
300007	1	0.1%
300008	1	0.1%
300009	1	0.1%

Value	Count	Frequency (%)
10990009	1	0.1%
10990008	1	0.1%
10990007	1	0.1%
10990006	1	0.1%
10990005	1	0.1%
10990004	1	0.1%
10990003	1	0.1%
10990002	1	0.1%
10990001	1	0.1%
10890025	1	0.1%

관리기관
Categorical

CONSTANT

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

1683	1451

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

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	1451	100.0%

도로종류
Categorical

HIGH CORRELATION

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

1504	1195
1507	256

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	1507
5th row	1507

Common Values

Value	Count	Frequency (%)
1504	1195	82.4%
1507	256	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	1195	82.4%
1507	256	17.6%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	41
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	832.77395

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

Quantile statistics

Minimum	30
5-th percentile	30
Q1	1001
median	1011
Q3	1029
95-th percentile	1084
Maximum	1099
Range	1069
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	390.5976
Coefficient of variation (CV)	0.46903196
Kurtosis	0.29209877
Mean	832.77395
Median Absolute Deviation (MAD)	11
Skewness	-1.5039224
Sum	1208355
Variance	152566.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1018	112	7.7%
1011	101	7.0%
1001	76	5.2%
30	76	5.2%
37	74	5.1%
1084	71	4.9%
1007	70	4.8%
1003	64	4.4%
1010	61	4.2%
1029	59	4.1%
Other values (31)	687	47.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	76	5.2%
37	74	5.1%
58	19	1.3%
60	37	2.5%
67	44	3.0%
69	37	2.5%
907	6	0.4%
1001	76	5.2%
1002	7	0.5%
1003	64	4.4%

Value	Count	Frequency (%)
1099	9	0.6%
1089	25	1.7%
1084	71	4.9%
1080	39	2.7%
1077	40	2.8%
1051	3	0.2%
1049	29	2.0%
1047	2	0.1%
1042	44	3.0%
1041	3	0.2%

구간번호
Real number (ℝ)

HIGH CORRELATION

Distinct	17
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9104066

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 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.6421245
Coefficient of variation (CV)	0.74171546
Kurtosis	1.1273152
Mean	4.9104066
Median Absolute Deviation (MAD)	2
Skewness	1.1425084
Sum	7125
Variance	13.265071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	266	18.3%
2	200	13.8%
3	177	12.2%
7	168	11.6%
4	165	11.4%
6	105	7.2%
5	98	6.8%
9	71	4.9%
8	46	3.2%
10	41	2.8%
Other values (7)	114	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	266	18.3%
2	200	13.8%
3	177	12.2%
4	165	11.4%
5	98	6.8%
6	105	7.2%
7	168	11.6%
8	46	3.2%
9	71	4.9%
10	41	2.8%

Value	Count	Frequency (%)
19	9	0.6%
16	2	0.1%
15	14	1.0%
14	27	1.9%
13	37	2.5%
12	8	0.6%
11	17	1.2%
10	41	2.8%
9	71	4.9%
8	46	3.2%

이력코드
Categorical

HIGH CORRELATION IMBALANCE

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

0	1432
1	19

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	1432	98.7%
1	19	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1432	98.7%
1	19	1.3%

위치_시점
Real number (ℝ)

HIGH CORRELATION

Distinct	1285
Distinct (%)	88.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1844997

Minimum	0
Maximum	19.526
Zeros	8
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.06
Q1	1.4605
median	4.186
Q3	7.813
95-th percentile	13.27
Maximum	19.526
Range	19.526
Interquartile range (IQR)	6.3525

Descriptive statistics

Standard deviation	4.3201209
Coefficient of variation (CV)	0.83327634
Kurtosis	-0.15121521
Mean	5.1844997
Median Absolute Deviation (MAD)	3.009
Skewness	0.77402682
Sum	7522.709
Variance	18.663445
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	8	0.6%
0.065	8	0.6%
0.02	5	0.3%
0.16	4	0.3%
0.095	4	0.3%
0.007	4	0.3%
0.06	4	0.3%
0.011	3	0.2%
0.508	3	0.2%
7.67	3	0.2%
Other values (1275)	1405	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	8	0.6%
0.002	3	0.2%
0.003	1	0.1%
0.004	2	0.1%
0.005	2	0.1%
0.006	1	0.1%
0.007	4	0.3%
0.008	2	0.1%
0.009	2	0.1%
0.01	1	0.1%

Value	Count	Frequency (%)
19.526	1	0.1%
19.478	1	0.1%
19.406	1	0.1%
19.38	1	0.1%
18.726	1	0.1%
18.626	1	0.1%
18.564	1	0.1%
18.516	1	0.1%
18.458	1	0.1%
17.729	1	0.1%

위치_종점
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1303
Distinct (%)	89.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.294499

Minimum	0
Maximum	20.5
Zeros	24
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.095
Q1	1.467
median	4.29
Q3	8.0135
95-th percentile	13.6115
Maximum	20.5
Range	20.5
Interquartile range (IQR)	6.5465

Descriptive statistics

Standard deviation	4.3807988
Coefficient of variation (CV)	0.82742461
Kurtosis	-0.11784581
Mean	5.294499
Median Absolute Deviation (MAD)	3.066
Skewness	0.78560453
Sum	7682.318
Variance	19.191398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	24	1.7%
11.36	4	0.3%
0.4	4	0.3%
0.095	4	0.3%
2.87	3	0.2%
3.11	3	0.2%
1.15	3	0.2%
0.18	3	0.2%
7.845	2	0.1%
5.84	2	0.1%
Other values (1293)	1399	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	24	1.7%
0.002	2	0.1%
0.003	1	0.1%
0.005	1	0.1%
0.007	2	0.1%
0.009	2	0.1%
0.011	1	0.1%
0.016	1	0.1%
0.018	2	0.1%
0.019	1	0.1%

Value	Count	Frequency (%)
20.5	1	0.1%
19.526	1	0.1%
19.478	1	0.1%
19.406	1	0.1%
19.36	1	0.1%
19.136	1	0.1%
19.08	1	0.1%
18.726	1	0.1%
18.626	1	0.1%
18.564	1	0.1%

위치_방향
Categorical

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	11.5 KiB

0	768
1	682
<NA>	1

Length

Max length	4
Median length	1
Mean length	1.0020675
Min length	1

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
0	768	52.9%
1	682	47.0%
<NA>	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	768	52.9%
1	682	47.0%
na	1	0.1%

등주형식
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3201.519

Minimum	3021
Maximum	3299
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	3021
5-th percentile	3201
Q1	3201
median	3201
Q3	3201
95-th percentile	3202
Maximum	3299
Range	278
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.525707
Coefficient of variation (CV)	0.0032877228
Kurtosis	167.76356
Mean	3201.519
Median Absolute Deviation (MAD)	0
Skewness	-1.4817826
Sum	4645404
Variance	110.7905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3201	1307	90.1%
3202	102	7.0%
3203	19	1.3%
3299	10	0.7%
3200	10	0.7%
3021	2	0.1%
3204	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3021	2	0.1%
3200	10	0.7%
3201	1307	90.1%
3202	102	7.0%
3203	19	1.3%
3204	1	0.1%
3299	10	0.7%

Value	Count	Frequency (%)
3299	10	0.7%
3204	1	0.1%
3203	19	1.3%
3202	102	7.0%
3201	1307	90.1%
3200	10	0.7%
3021	2	0.1%

등주재질
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3305.3825

Minimum	3300
Maximum	3399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	3300
5-th percentile	3301
Q1	3303
median	3304
Q3	3304
95-th percentile	3305
Maximum	3399
Range	99
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	13.427474
Coefficient of variation (CV)	0.0040623055
Kurtosis	44.450131
Mean	3305.3825
Median Absolute Deviation (MAD)	1
Skewness	6.7810005
Sum	4796110
Variance	180.29705
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
3304	419	28.9%
3303	415	28.6%
3305	320	22.1%
3302	146	10.1%
3301	108	7.4%
3399	29	2.0%
3300	11	0.8%
3306	3	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3300	11	0.8%
3301	108	7.4%
3302	146	10.1%
3303	415	28.6%
3304	419	28.9%
3305	320	22.1%
3306	3	0.2%
3399	29	2.0%

Value	Count	Frequency (%)
3399	29	2.0%
3306	3	0.2%
3305	320	22.1%
3304	419	28.9%
3303	415	28.6%
3302	146	10.1%
3301	108	7.4%
3300	11	0.8%

광원종류
Categorical

IMBALANCE

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	11.5 KiB

3403	1221
3401	207
3402	12
3400	11

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
3403	1221	84.1%
3401	207	14.3%
3402	12	0.8%
3400	11	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3403	1221	84.1%
3401	207	14.3%
3402	12	0.8%
3400	11	0.8%

광원용량
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	11.5 KiB

3505	844
3500	484
3506	109
3507	11
3503	3

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
3505	844	58.2%
3500	484	33.4%
3506	109	7.5%
3507	11	0.8%
3503	3	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3505	844	58.2%
3500	484	33.4%
3506	109	7.5%
3507	11	0.8%
3503	3	0.2%

등기수 수량
Real number (ℝ)

Distinct	46
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2033081

Minimum	0
Maximum	110
Zeros	2
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	12
Maximum	110
Range	110
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.9918503
Coefficient of variation (CV)	2.4948741
Kurtosis	80.556867
Mean	3.2033081
Median Absolute Deviation (MAD)	0
Skewness	7.8783906
Sum	4648
Variance	63.869672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
1	1039	71.6%
2	117	8.1%
3	52	3.6%
4	41	2.8%
5	29	2.0%
7	29	2.0%
6	19	1.3%
8	17	1.2%
9	16	1.1%
11	8	0.6%
Other values (36)	84	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	0.1%
1	1039	71.6%
2	117	8.1%
3	52	3.6%
4	41	2.8%
5	29	2.0%
6	19	1.3%
7	29	2.0%
8	17	1.2%
9	16	1.1%

Value	Count	Frequency (%)
110	1	0.1%
107	1	0.1%
102	1	0.1%
90	1	0.1%
71	1	0.1%
69	1	0.1%
62	1	0.1%
58	1	0.1%
57	1	0.1%
54	1	0.1%

설치일자
Categorical

HIGH CORRELATION IMBALANCE

Distinct	15
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	11.5 KiB

1900-01-01	1346
20121219	21
2016-03-31	19
20101130	13
20090326	12
Other values (10)	40

Length

Max length	10
Median length	10
Mean length	9.8855961
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1900-01-01
2nd row	1900-01-01
3rd row	1900-01-01
4th row	1900-01-01
5th row	1900-01-01

Common Values

Value	Count	Frequency (%)
1900-01-01	1346	92.8%
20121219	21	1.4%
2016-03-31	19	1.3%
20101130	13	0.9%
20090326	12	0.8%
20090515	11	0.8%
20100104	7	0.5%
201006	5	0.3%
2007-12-31	3	0.2%
20091209	3	0.2%
Other values (5)	11	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1900-01-01	1346	92.8%
20121219	21	1.4%
2016-03-31	19	1.3%
20101130	13	0.9%
20090326	12	0.8%
20090515	11	0.8%
20100104	7	0.5%
201006	5	0.3%
2007-12-31	3	0.2%
20091209	3	0.2%
Other values (5)	11	0.8%

사진
Text

MISSING

Distinct	1340
Distinct (%)	99.3%
Missing	102
Missing (%)	7.0%
Memory size	11.5 KiB

Length

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

Characters and Unicode

Total characters	17537
Distinct characters	14
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	1336 ?
Unique (%)	99.0%

Sample

1st row	006701O00011D
2nd row	006701O00025U
3rd row	006701O00072U
4th row	006701O00116U
5th row	006701O00160U

Value	Count	Frequency (%)
100501o04871u	5	0.4%
100501o04903d	4	0.3%
006703o01813u	2	0.1%
107704o10790d	2	0.1%
006010o09800d	1	0.1%
101403o08636d	1	0.1%
101807o16218d	1	0.1%
101811o03110d	1	0.1%
101811o05780d	1	0.1%
101811o07134u	1	0.1%
Other values (1330)	1330	98.6%

Most occurring characters

Value	Count	Frequency (%)
0	5582	31.8%
1	2718	15.5%
O	1347	7.7%
2	1014	5.8%
3	898	5.1%
4	880	5.0%
7	879	5.0%
8	763	4.4%
6	750	4.3%
5	718	4.1%
Other values (4)	1988	11.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14840	84.6%
Uppercase Letter	2697	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5582	37.6%
1	2718	18.3%
2	1014	6.8%
3	898	6.1%
4	880	5.9%
7	879	5.9%
8	763	5.1%
6	750	5.1%
5	718	4.8%
9	638	4.3%

Uppercase Letter

Value	Count	Frequency (%)
O	1347	49.9%
U	717	26.6%
D	632	23.4%
P	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	14840	84.6%
Latin	2697	15.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5582	37.6%
1	2718	18.3%
2	1014	6.8%
3	898	6.1%
4	880	5.9%
7	879	5.9%
8	763	5.1%
6	750	5.1%
5	718	4.8%
9	638	4.3%

Latin

Value	Count	Frequency (%)
O	1347	49.9%
U	717	26.6%
D	632	23.4%
P	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17537	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5582	31.8%
1	2718	15.5%
O	1347	7.7%
2	1014	5.8%
3	898	5.1%
4	880	5.0%
7	879	5.0%
8	763	4.4%
6	750	4.3%
5	718	4.1%
Other values (4)	1988	11.3%

비고
Categorical

HIGH CORRELATION IMBALANCE

Distinct	48
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	11.5 KiB

<NA>	1327
2EA	14
보안등	11
전주	11
원형철주	10
Other values (43)	78

Length

Max length	13
Median length	4
Mean length	4.0778773
Min length	2

Unique

Unique	27 ?
Unique (%)	1.9%

Sample

1st row	<NA>
2nd row	<NA>
3rd row	<NA>
4th row	<NA>
5th row	<NA>

Common Values

Value	Count	Frequency (%)
<NA>	1327	91.5%
2EA	14	1.0%
보안등	11	0.8%
전주	11	0.8%
원형철주	10	0.7%
원형(2EA)	8	0.6%
3EA	7	0.5%
팔각주	7	0.5%
팔각철주	4	0.3%
(4EA)	3	0.2%
Other values (38)	49	3.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	1327	91.1%
2ea	16	1.1%
보안등	11	0.8%
전주	11	0.8%
원형철주	10	0.7%
팔각주	9	0.6%
원형(2ea	8	0.5%
3ea	7	0.5%
팔각철주	4	0.3%
원형	3	0.2%
Other values (37)	51	3.5%

Heatmap
Table

	식별번호	관리번호	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	등주형식	등주재질	광원종류	광원용량	등기수 수량	설치일자	비고
식별번호	1.000	0.871	0.938	0.687	0.652	0.439	0.466	0.427	0.105	0.060	0.190	0.538	0.896	0.154	0.587	0.972
관리번호	0.871	1.000	0.946	0.590	0.336	0.085	0.228	0.241	0.099	0.000	0.097	0.342	0.272	0.068	0.449	0.645
도로종류	0.938	0.946	1.000	0.676	0.285	0.058	0.262	0.239	0.105	0.014	0.085	0.294	0.142	0.000	0.125	NaN
노선번호	0.687	0.590	0.676	1.000	0.360	0.027	0.298	0.250	0.045	0.012	0.037	0.178	0.204	0.055	0.414	0.904
구간번호	0.652	0.336	0.285	0.360	1.000	0.193	0.415	0.373	0.074	0.000	0.122	0.304	0.489	0.000	0.773	0.899
이력코드	0.439	0.085	0.058	0.027	0.193	1.000	0.059	0.052	0.000	0.000	0.000	0.031	0.427	0.000	1.000	NaN
위치_시점	0.466	0.228	0.262	0.298	0.415	0.059	1.000	0.990	0.107	0.000	0.038	0.182	0.185	0.265	0.235	0.753
위치_종점	0.427	0.241	0.239	0.250	0.373	0.052	0.990	1.000	0.108	0.045	0.000	0.177	0.184	0.205	0.227	0.860
위치_방향	0.105	0.099	0.105	0.045	0.074	0.000	0.107	0.108	1.000	0.000	0.063	0.000	0.000	0.000	0.000	0.000
등주형식	0.060	0.000	0.014	0.012	0.000	0.000	0.000	0.045	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.783
등주재질	0.190	0.097	0.085	0.037	0.122	0.000	0.038	0.000	0.063	0.000	1.000	0.029	0.109	0.000	0.000	0.965
광원종류	0.538	0.342	0.294	0.178	0.304	0.031	0.182	0.177	0.000	0.000	0.029	1.000	0.157	0.149	0.000	0.730
광원용량	0.896	0.272	0.142	0.204	0.489	0.427	0.185	0.184	0.000	0.000	0.109	0.157	1.000	0.208	0.938	1.000
등기수 수량	0.154	0.068	0.000	0.055	0.000	0.000	0.265	0.205	0.000	0.000	0.000	0.149	0.208	1.000	0.333	0.691
설치일자	0.587	0.449	0.125	0.414	0.773	1.000	0.235	0.227	0.000	0.000	0.000	0.000	0.938	0.333	1.000	1.000
비고	0.972	0.645	NaN	0.904	0.899	NaN	0.753	0.860	0.000	0.783	0.965	0.730	1.000	0.691	1.000	1.000

Heatmap
Table

	설치일자	이력코드	광원용량	광원종류	비고	도로종류	위치_방향
설치일자	1.000	0.996	0.680	0.000	0.794	0.114	0.000
이력코드	0.996	1.000	0.519	0.021	1.000	0.037	0.000
광원용량	0.680	0.519	1.000	0.128	0.798	0.173	0.000
광원종류	0.000	0.021	0.128	1.000	0.392	0.196	0.000
비고	0.794	1.000	0.798	0.392	1.000	1.000	0.000
도로종류	0.114	0.037	0.173	0.196	1.000	1.000	0.067
위치_방향	0.000	0.000	0.000	0.000	0.000	0.067	1.000

Heatmap
Table

	식별번호	관리번호	노선번호	구간번호	위치_시점	위치_종점	등주형식	등주재질	등기수 수량	도로종류	이력코드	위치_방향	광원종류	광원용량	설치일자	비고
식별번호	1.000	0.347	0.595	0.147	-0.073	-0.094	-0.141	-0.109	0.172	0.787	0.337	0.080	0.351	0.581	0.262	0.680
관리번호	0.347	1.000	0.762	-0.108	-0.050	-0.084	-0.145	0.005	0.033	0.789	0.054	0.063	0.228	0.332	0.409	0.431
노선번호	0.595	0.762	1.000	-0.124	-0.108	-0.143	-0.133	0.008	0.019	0.932	0.044	0.075	0.169	0.156	0.207	0.584
구간번호	0.147	-0.108	-0.124	1.000	0.155	0.130	-0.075	-0.002	-0.049	0.218	0.148	0.053	0.191	0.197	0.393	0.524
위치_시점	-0.073	-0.050	-0.108	0.155	1.000	0.955	-0.033	0.080	-0.159	0.200	0.045	0.082	0.109	0.077	0.089	0.300
위치_종점	-0.094	-0.084	-0.143	0.130	0.955	1.000	-0.027	0.026	-0.065	0.183	0.040	0.082	0.106	0.077	0.086	0.415
등주형식	-0.141	-0.145	-0.133	-0.075	-0.033	-0.027	1.000	-0.048	0.266	0.020	0.000	0.031	0.000	0.082	0.278	0.535
등주재질	-0.109	0.005	0.008	-0.002	0.080	0.026	-0.048	1.000	-0.211	0.054	0.000	0.040	0.042	0.134	0.000	0.726
등기수 수량	0.172	0.033	0.019	-0.049	-0.159	-0.065	0.266	-0.211	1.000	0.000	0.000	0.000	0.107	0.110	0.124	0.358
도로종류	0.787	0.789	0.932	0.218	0.200	0.183	0.020	0.054	0.000	1.000	0.037	0.067	0.196	0.173	0.114	1.000
이력코드	0.337	0.054	0.044	0.148	0.045	0.040	0.000	0.000	0.000	0.037	1.000	0.000	0.021	0.519	0.996	1.000
위치_방향	0.080	0.063	0.075	0.053	0.082	0.082	0.031	0.040	0.000	0.067	0.000	1.000	0.000	0.000	0.000	0.000
광원종류	0.351	0.228	0.169	0.191	0.109	0.106	0.000	0.042	0.107	0.196	0.021	0.000	1.000	0.128	0.000	0.392
광원용량	0.581	0.332	0.156	0.197	0.077	0.077	0.082	0.134	0.110	0.173	0.519	0.000	0.128	1.000	0.680	0.798
설치일자	0.262	0.409	0.207	0.393	0.089	0.086	0.278	0.000	0.124	0.114	0.996	0.000	0.000	0.680	1.000	0.794
비고	0.680	0.431	0.584	0.524	0.300	0.415	0.535	0.726	0.358	1.000	1.000	0.000	0.392	0.798	0.794	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

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	위치_시점	위치_종점	위치_방향	등주형식	등주재질	광원종류	광원용량	등기수 수량	설치일자	사진	비고
0	1	670001	1683	1507	67	1	0.011	0.602	1	3201	3303	3403	3505	18	1900-01-01	006701O00011D	<NA>
1	2	670002	1683	1507	67	1	0.025	0.025	0	3202	3301	3403	3505	1	1900-01-01	006701O00025U	<NA>
2	3	670003	1683	1507	67	1	0.072	0.072	0	3201	3303	3403	3505	1	1900-01-01	006701O00072U	<NA>
3	4	670004	1683	1507	67	1	0.116	0.116	0	3201	3303	3403	3505	1	1900-01-01	006701O00116U	<NA>
4	5	670005	1683	1507	67	1	0.16	0.31	0	3201	3303	3403	3505	5	1900-01-01	006701O00160U	<NA>
5	6	670006	1683	1507	67	1	0.369	0.828	0	3201	3303	3403	3505	13	1900-01-01	006701O00369U	<NA>
6	7	670007	1683	1507	67	1	0.648	0.806	1	3201	3303	3403	3505	5	1900-01-01	006701O00648D	<NA>
7	8	670008	1683	1507	67	1	0.843	1.046	1	3201	3303	3403	3505	7	1900-01-01	006701O00843D	<NA>
8	9	670009	1683	1507	67	1	0.857	0.857	0	3204	3303	3403	3505	1	1900-01-01	006701O00857U	<NA>
9	10	670010	1683	1507	67	1	0.867	1.026	0	3201	3303	3403	3505	5	1900-01-01	006701O00867U	<NA>

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	등주형식	등주재질	광원종류	광원용량	등기수 수량	설치일자	사진	비고
1441	1442	10420022	1683	1504	1042	1	1	4.141	4.457	0	3201	3303	3403	3506	8	2016-03-31	104201O04141U	<NA>
1442	1443	10420021	1683	1504	1042	1	1	3.661	3.947	0	3201	3303	3403	3506	8	2016-03-31	104201O03661U	<NA>
1443	1444	10420020	1683	1504	1042	1	1	2.482	2.845	0	3201	3303	3403	3506	9	2016-03-31	104201O02482U	<NA>
1444	1445	10420019	1683	1504	1042	1	1	2.125	2.353	0	3201	3303	3403	3506	6	2016-03-31	104201O02125U	<NA>
1445	1446	10420018	1683	1504	1042	1	1	1.828	1.828	0	3201	3303	3403	3503	1	2016-03-31	104201O01828U	<NA>
1446	1447	10420017	1683	1504	1042	1	1	1.465	1.465	0	3201	3303	3403	3503	1	2016-03-31	104201O01465U	<NA>
1447	1448	10420016	1683	1504	1042	1	1	1.016	1.994	0	3201	3303	3403	3506	23	2016-03-31	104201O01016U	<NA>
1448	1449	10420031	1683	1504	1042	1	1	4.184	4.457	<NA>	3201	3303	3403	3506	7	2016-03-31	104201O04184D	<NA>
1449	1450	600029	1683	1507	60	19	0	8.845	9.595	1	3201	3303	3403	3506	22	2013-10-31	006019O08845D	<NA>
1450	1451	600028	1683	1507	60	19	0	8.845	9.588	0	3201	3303	3403	3506	21	2013-10-31	006019O08845U	<NA>

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

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

Interactions

Correlations

Missing values

Sample