gimi9 Pandas Profiling

Dataset statistics

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

Variable types

Numeric	11
Categorical	4
Text	1

Dataset

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

Alerts

`식별번호` 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 `위치_종점`	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 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 imbalanced (98.4%)	Imbalance
`도로종류` is highly imbalanced (97.8%)	Imbalance
`이력코드` is highly imbalanced (96.7%)	Imbalance
`비고` has 8311 (83.1%) missing values	Missing
`식별번호` has unique values	Unique
`관리번호` has 395 (4.0%) zeros	Zeros
`높이_최소` has 296 (3.0%) zeros	Zeros
`폭` has 772 (7.7%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 23:56:47.076141
Analysis finished	2023-12-10 23:57:06.483987
Duration	19.41 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

식별번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

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

Minimum	3
Maximum	16446
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	3
5-th percentile	811.85
Q1	4080.5
median	8166.5
Q3	12323.25
95-th percentile	15640.05
Maximum	16446
Range	16443
Interquartile range (IQR)	8242.75

Descriptive statistics

Standard deviation	4759.7259
Coefficient of variation (CV)	0.58106644
Kurtosis	-1.202434
Mean	8191.3625
Median Absolute Deviation (MAD)	4118.5
Skewness	0.0097621129
Sum	81913625
Variance	22654990
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4093	1	< 0.1%
15366	1	< 0.1%
6232	1	< 0.1%
7970	1	< 0.1%
10768	1	< 0.1%
3783	1	< 0.1%
7158	1	< 0.1%
7085	1	< 0.1%
2677	1	< 0.1%
681	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
8	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
22	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
16446	1	< 0.1%
16445	1	< 0.1%
16443	1	< 0.1%
16442	1	< 0.1%
16441	1	< 0.1%
16440	1	< 0.1%
16439	1	< 0.1%
16438	1	< 0.1%
16436	1	< 0.1%
16434	1	< 0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9532
Distinct (%)	95.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8311322.6

Minimum	0
Maximum	10990372
Zeros	395
Zeros (%)	4.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	300177.95
Q1	10010696
median	10140008
Q3	10340652
95-th percentile	10890140
Maximum	10990372
Range	10990372
Interquartile range (IQR)	329956

Descriptive statistics

Standard deviation	3961452.7
Coefficient of variation (CV)	0.47663324
Kurtosis	0.21145282
Mean	8311322.6
Median Absolute Deviation (MAD)	150298.5
Skewness	-1.4751433
Sum	8.3113226 × 10¹⁰
Variance	1.5693107 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	395	4.0%
690031	3	< 0.1%
600008	3	< 0.1%
690032	3	< 0.1%
690033	3	< 0.1%
10220013	2	< 0.1%
10490021	2	< 0.1%
690034	2	< 0.1%
10240354	2	< 0.1%
10490054	2	< 0.1%
Other values (9522)	9583	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	395	4.0%
1	1	< 0.1%
2	1	< 0.1%
300002	1	< 0.1%
300004	1	< 0.1%
300005	1	< 0.1%
300006	1	< 0.1%
300010	1	< 0.1%
300011	1	< 0.1%
300013	1	< 0.1%

Value	Count	Frequency (%)
10990372	1	< 0.1%
10990370	1	< 0.1%
10990369	1	< 0.1%
10990368	1	< 0.1%
10990367	1	< 0.1%
10990365	1	< 0.1%
10990364	1	< 0.1%
10990361	1	< 0.1%
10990360	1	< 0.1%
10990358	1	< 0.1%

관리기관
Categorical

IMBALANCE

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

1683	9977
1684	19
1682	4

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	9977	99.8%
1684	19	0.2%
1682	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	9977	99.8%
1684	19	0.2%
1682	4	< 0.1%

도로종류
Categorical

HIGH CORRELATION IMBALANCE

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

1504	9979
1507	21

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	9979	99.8%
1507	21	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	9979	99.8%
1507	21	0.2%

노선번호
Real number (ℝ)

HIGH CORRELATION

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

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	1002
median	1018
Q3	1037
95-th percentile	1089
Maximum	1099
Range	1069
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	368.30783
Coefficient of variation (CV)	0.4265487
Kurtosis	1.0174515
Mean	863.4602
Median Absolute Deviation (MAD)	16
Skewness	-1.7247197
Sum	8634602
Variance	135650.66
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
60	676	6.8%
1001	474	4.7%
1034	462	4.6%
1018	415	4.2%
1021	400	4.0%
1024	390	3.9%
1007	383	3.8%
1077	377	3.8%
1089	360	3.6%
1010	342	3.4%
Other values (33)	5721	57.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	126	1.3%
37	315	3.1%
58	207	2.1%
60	676	6.8%
67	79	0.8%
69	308	3.1%
907	65	0.7%
1001	474	4.7%
1002	304	3.0%
1003	283	2.8%

Value	Count	Frequency (%)
1099	226	2.3%
1089	360	3.6%
1084	338	3.4%
1080	204	2.0%
1077	377	3.8%
1051	133	1.3%
1049	172	1.7%
1047	120	1.2%
1042	206	2.1%
1041	91	0.9%

구간번호
Real number (ℝ)

HIGH CORRELATION

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

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	3
median	5
Q3	7
95-th percentile	13
Maximum	19
Range	18
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.6349913
Coefficient of variation (CV)	0.67531004
Kurtosis	0.63322291
Mean	5.3827
Median Absolute Deviation (MAD)	2
Skewness	0.95941325
Sum	53827
Variance	13.213162
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	1374	13.7%
4	1291	12.9%
2	1117	11.2%
3	1079	10.8%
7	1066	10.7%
5	1025	10.2%
6	737	7.4%
9	570	5.7%
8	445	4.5%
11	313	3.1%
Other values (7)	983	9.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1374	13.7%
2	1117	11.2%
3	1079	10.8%
4	1291	12.9%
5	1025	10.2%
6	737	7.4%
7	1066	10.7%
8	445	4.5%
9	570	5.7%
10	251	2.5%

Value	Count	Frequency (%)
19	41	0.4%
16	89	0.9%
15	113	1.1%
14	102	1.0%
13	196	2.0%
12	191	1.9%
11	313	3.1%
10	251	2.5%
9	570	5.7%
8	445	4.5%

이력코드
Categorical

IMBALANCE

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

0	9966
1	34

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	9966	99.7%
1	34	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	9966	99.7%
1	34	0.3%

위치_시점
Real number (ℝ)

HIGH CORRELATION

Distinct	6452
Distinct (%)	64.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5175885

Minimum	-0.3
Maximum	28.725
Zeros	80
Zeros (%)	0.8%
Negative	6
Negative (%)	0.1%
Memory size	166.0 KiB

Quantile statistics

Minimum	-0.3
5-th percentile	0.3239
Q1	2.248
median	4.8815
Q3	7.987
95-th percentile	13.0962
Maximum	28.725
Range	29.025
Interquartile range (IQR)	5.739

Descriptive statistics

Standard deviation	4.0753535
Coefficient of variation (CV)	0.73861134
Kurtosis	1.4694873
Mean	5.5175885
Median Absolute Deviation (MAD)	2.8135
Skewness	0.98829989
Sum	55175.885
Variance	16.608506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	80	0.8%
8.0	15	0.1%
0.02	15	0.1%
7.0	13	0.1%
0.01	11	0.1%
4.76	9	0.1%
3.2	8	0.1%
5.24	8	0.1%
6.24	7	0.1%
4.54	7	0.1%
Other values (6442)	9827	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.3	2	< 0.1%
-0.26	1	< 0.1%
-0.11	2	< 0.1%
-0.046	1	< 0.1%
0.0	80	0.8%
0.001	5	0.1%
0.002	4	< 0.1%
0.003	4	< 0.1%
0.004	4	< 0.1%
0.005	5	0.1%

Value	Count	Frequency (%)
28.725	1	< 0.1%
28.65	1	< 0.1%
28.385	1	< 0.1%
28.268	1	< 0.1%
28.253	1	< 0.1%
28.23	1	< 0.1%
28.13	1	< 0.1%
27.375	1	< 0.1%
27.02	1	< 0.1%
26.866	1	< 0.1%

위치_종점
Real number (ℝ)

HIGH CORRELATION

Distinct	6441
Distinct (%)	64.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6677851

Minimum	-0.27
Maximum	254
Zeros	24
Zeros (%)	0.2%
Negative	3
Negative (%)	< 0.1%
Memory size	166.0 KiB

Quantile statistics

Minimum	-0.27
5-th percentile	0.435
Q1	2.38925
median	5.0085
Q3	8.09075
95-th percentile	13.2262
Maximum	254
Range	254.27
Interquartile range (IQR)	5.7015

Descriptive statistics

Standard deviation	4.7717217
Coefficient of variation (CV)	0.84190238
Kurtosis	733.43136
Mean	5.6677851
Median Absolute Deviation (MAD)	2.8295
Skewness	14.702466
Sum	56677.851
Variance	22.769328
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	24	0.2%
7.0	12	0.1%
8.0	12	0.1%
1.94	8	0.1%
1.91	8	0.1%
5.48	8	0.1%
1.215	8	0.1%
0.625	8	0.1%
4.76	8	0.1%
0.3	7	0.1%
Other values (6431)	9897	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.27	1	< 0.1%
-0.21	1	< 0.1%
-0.053	1	< 0.1%
0.0	24	0.2%
0.008	1	< 0.1%
0.01	2	< 0.1%
0.012	1	< 0.1%
0.018	1	< 0.1%
0.02	3	< 0.1%
0.022	1	< 0.1%

Value	Count	Frequency (%)
254.0	1	< 0.1%
28.755	1	< 0.1%
28.692	1	< 0.1%
28.65	1	< 0.1%
28.385	1	< 0.1%
28.315	1	< 0.1%
28.253	1	< 0.1%
28.23	1	< 0.1%
27.6	1	< 0.1%
27.06	1	< 0.1%

위치_방향
Categorical

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

1	5274
0	4724
<NA>	2

Length

Max length	4
Median length	1
Mean length	1.0006
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	5274	52.7%
0	4724	47.2%
<NA>	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5274	52.7%
0	4724	47.2%
na	2	< 0.1%

연장
Real number (ℝ)

Distinct	700
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.19329

Minimum	0
Maximum	2460
Zeros	23
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	43
median	85
Q3	155
95-th percentile	371.05
Maximum	2460
Range	2460
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	148.48071
Coefficient of variation (CV)	1.1766133
Kurtosis	37.097573
Mean	126.19329
Median Absolute Deviation (MAD)	49
Skewness	4.5318661
Sum	1261932.9
Variance	22046.522
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.0	163	1.6%
60.0	140	1.4%
100.0	124	1.2%
30.0	115	1.1%
20.0	110	1.1%
80.0	107	1.1%
50.0	95	0.9%
25.0	95	0.9%
90.0	90	0.9%
45.0	88	0.9%
Other values (690)	8873	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	23	0.2%
1.54	1	< 0.1%
2.0	4	< 0.1%
3.0	7	0.1%
4.0	17	0.2%
4.5	1	< 0.1%
5.0	20	0.2%
6.0	39	0.4%
7.0	41	0.4%
7.3	1	< 0.1%

Value	Count	Frequency (%)
2460.0	1	< 0.1%
2315.0	1	< 0.1%
2305.0	1	< 0.1%
2190.0	1	< 0.1%
1962.0	1	< 0.1%
1737.0	1	< 0.1%
1529.0	1	< 0.1%
1528.0	1	< 0.1%
1433.0	1	< 0.1%
1420.0	1	< 0.1%

종류
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1305.0356

Minimum	1300
Maximum	1399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1300
5-th percentile	1301
Q1	1301
median	1302
Q3	1304
95-th percentile	1309
Maximum	1399
Range	99
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	13.847666
Coefficient of variation (CV)	0.010610949
Kurtosis	40.715262
Mean	1305.0356
Median Absolute Deviation (MAD)	1
Skewness	6.4296271
Sum	13047746
Variance	191.75786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1301	3581	35.8%
1302	2356	23.6%
1306	1205	12.0%
1304	930	9.3%
1309	718	7.2%
1303	625	6.2%
1399	206	2.1%
1308	191	1.9%
1305	166	1.7%
1300	18	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1300	18	0.2%
1301	3581	35.8%
1302	2356	23.6%
1303	625	6.2%
1304	930	9.3%
1305	166	1.7%
1306	1205	12.0%
1307	2	< 0.1%
1308	191	1.9%
1309	718	7.2%

Value	Count	Frequency (%)
1399	206	2.1%
1309	718	7.2%
1308	191	1.9%
1307	2	< 0.1%
1306	1205	12.0%
1305	166	1.7%
1304	930	9.3%
1303	625	6.2%
1302	2356	23.6%
1301	3581	35.8%

높이_최대
Real number (ℝ)

HIGH CORRELATION

Distinct	54
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.529539

Minimum	0
Maximum	6
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.15
Q1	0.2
median	0.6
Q3	0.7
95-th percentile	1.05
Maximum	6
Range	6
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.35111178
Coefficient of variation (CV)	0.6630518
Kurtosis	20.736117
Mean	0.529539
Median Absolute Deviation (MAD)	0.3
Skewness	2.2945939
Sum	5295.39
Variance	0.12327949
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7	3115	31.1%
0.2	3039	30.4%
0.6	684	6.8%
0.5	639	6.4%
0.15	516	5.2%
1.0	465	4.7%
0.3	209	2.1%
0.8	208	2.1%
0.4	165	1.7%
1.2	133	1.3%
Other values (44)	827	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	6	0.1%
0.05	4	< 0.1%
0.1	75	0.8%
0.14	1	< 0.1%
0.15	516	5.2%
0.18	1	< 0.1%
0.2	3039	30.4%
0.23	11	0.1%
0.25	115	1.1%
0.3	209	2.1%

Value	Count	Frequency (%)
6.0	3	< 0.1%
3.0	4	< 0.1%
2.8	1	< 0.1%
2.7	2	< 0.1%
2.6	2	< 0.1%
2.5	4	< 0.1%
2.3	4	< 0.1%
2.1	9	0.1%
2.0	42	0.4%
1.9	2	< 0.1%

높이_최소
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	53
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.491565

Minimum	0
Maximum	3
Zeros	296
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.15
Q1	0.2
median	0.5
Q3	0.7
95-th percentile	1
Maximum	3
Range	3
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.32162958
Coefficient of variation (CV)	0.65429715
Kurtosis	3.6635033
Mean	0.491565
Median Absolute Deviation (MAD)	0.25
Skewness	1.1366718
Sum	4915.65
Variance	0.10344559
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7	3116	31.2%
0.2	3058	30.6%
0.6	710	7.1%
0.5	642	6.4%
0.15	506	5.1%
1.0	390	3.9%
0.0	296	3.0%
0.3	221	2.2%
0.8	186	1.9%
0.4	155	1.6%
Other values (43)	720	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	296	3.0%
0.04	1	< 0.1%
0.05	4	< 0.1%
0.1	84	0.8%
0.14	1	< 0.1%
0.15	506	5.1%
0.18	1	< 0.1%
0.2	3058	30.6%
0.23	11	0.1%
0.25	113	1.1%

Value	Count	Frequency (%)
3.0	3	< 0.1%
2.7	1	< 0.1%
2.6	1	< 0.1%
2.5	3	< 0.1%
2.3	3	< 0.1%
2.1	6	0.1%
2.0	33	0.3%
1.9	1	< 0.1%
1.85	1	< 0.1%
1.8	2	< 0.1%

폭
Real number (ℝ)

ZEROS

Distinct	55
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.693017

Minimum	0
Maximum	10.51
Zeros	772
Zeros (%)	7.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.6
median	0.7
Q3	0.7
95-th percentile	1.5
Maximum	10.51
Range	10.51
Interquartile range (IQR)	0.1

Descriptive statistics

Standard deviation	0.44573918
Coefficient of variation (CV)	0.6431865
Kurtosis	106.72397
Mean	0.693017
Median Absolute Deviation (MAD)	0.05
Skewness	7.4472015
Sum	6930.17
Variance	0.19868342
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.7	4762	47.6%
0.5	1107	11.1%
0.6	780	7.8%
0.0	772	7.7%
0.75	689	6.9%
1.5	477	4.8%
1.0	432	4.3%
0.8	364	3.6%
0.4	179	1.8%
0.3	83	0.8%
Other values (45)	355	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	772	7.7%
0.1	5	0.1%
0.14	1	< 0.1%
0.15	1	< 0.1%
0.2	17	0.2%
0.25	34	0.3%
0.3	83	0.8%
0.35	1	< 0.1%
0.4	179	1.8%
0.45	20	0.2%

Value	Count	Frequency (%)
10.51	1	< 0.1%
8.0	6	0.1%
7.0	4	< 0.1%
6.0	4	< 0.1%
5.0	19	0.2%
4.0	1	< 0.1%
3.8	1	< 0.1%
3.5	1	< 0.1%
3.0	3	< 0.1%
2.8	1	< 0.1%

비고
Text

MISSING

Distinct	127
Distinct (%)	7.5%
Missing	8311
Missing (%)	83.1%
Memory size	156.2 KiB

Length

Max length	17
Median length	13
Mean length	4.4339846
Min length	1

Characters and Unicode

Total characters	7489
Distinct characters	99
Distinct categories	9 ?
Distinct scripts	4 ?
Distinct blocks	3 ?

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

Unique

Unique	51 ?
Unique (%)	3.0%

Sample

1st row	LU형측구(0.7*0.8
2nd row	J형측구
3rd row	L형측구
4th row	토사형측구
5th row	LU형측구

Value	Count	Frequency (%)
l형측구	171	9.8%
u형측구	153	8.8%
덮개	127	7.3%
옹벽형l형	111	6.4%
유개	100	5.7%
옹벽형l형측구	87	5.0%
토사형측구	75	4.3%
공사중	71	4.1%
lu형측구	68	3.9%
옹벽형측구	64	3.7%
Other values (112)	721	41.2%

Most occurring characters

Value	Count	Frequency (%)
형	1302	17.4%
구	872	11.6%
측	864	11.5%
L	600	8.0%
U	358	4.8%
옹	337	4.5%
벽	337	4.5%
개	328	4.4%
덮	186	2.5%
사	162	2.2%
Other values (89)	2143	28.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	5571	74.4%
Uppercase Letter	1398	18.7%
Decimal Number	173	2.3%
Open Punctuation	90	1.2%
Close Punctuation	83	1.1%
Dash Punctuation	71	0.9%
Space Separator	59	0.8%
Other Punctuation	40	0.5%
Lowercase Letter	4	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
형	1302	23.4%
구	872	15.7%
측	864	15.5%
옹	337	6.0%
벽	337	6.0%
개	328	5.9%
덮	186	3.3%
사	162	2.9%
토	143	2.6%
유	102	1.8%
Other values (53)	938	16.8%

Uppercase Letter

Value	Count	Frequency (%)
L	600	42.9%
U	358	25.6%
E	74	5.3%
P	73	5.2%
J	70	5.0%
T	69	4.9%
Y	69	4.9%
O	50	3.6%
V	9	0.6%
K	5	0.4%
Other values (7)	21	1.5%

Decimal Number

Value	Count	Frequency (%)
0	72	41.6%
1	36	20.8%
2	26	15.0%
6	13	7.5%
7	9	5.2%
9	5	2.9%
8	4	2.3%
3	4	2.3%
4	3	1.7%
5	1	0.6%

Other Punctuation

Value	Count	Frequency (%)
.	20	50.0%
,	10	25.0%
*	9	22.5%
:	1	2.5%

Open Punctuation

Value	Count	Frequency (%)
(	90	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	83	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	71	100.0%

Space Separator

Value	Count	Frequency (%)
	59	100.0%

Lowercase Letter

Value	Count	Frequency (%)
φ	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	5571	74.4%
Latin	1396	18.6%
Common	516	6.9%
Greek	6	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
형	1302	23.4%
구	872	15.7%
측	864	15.5%
옹	337	6.0%
벽	337	6.0%
개	328	5.9%
덮	186	3.3%
사	162	2.9%
토	143	2.6%
유	102	1.8%
Other values (53)	938	16.8%

Common

Value	Count	Frequency (%)
(	90	17.4%
)	83	16.1%
0	72	14.0%
-	71	13.8%
	59	11.4%
1	36	7.0%
2	26	5.0%
.	20	3.9%
6	13	2.5%
,	10	1.9%
Other values (8)	36	7.0%

Latin

Value	Count	Frequency (%)
L	600	43.0%
U	358	25.6%
E	74	5.3%
P	73	5.2%
J	70	5.0%
T	69	4.9%
Y	69	4.9%
O	50	3.6%
V	9	0.6%
K	5	0.4%
Other values (6)	19	1.4%

Greek

Value	Count	Frequency (%)
φ	4	66.7%
Φ	2	33.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	5571	74.4%
ASCII	1912	25.5%
None	6	0.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
형	1302	23.4%
구	872	15.7%
측	864	15.5%
옹	337	6.0%
벽	337	6.0%
개	328	5.9%
덮	186	3.3%
사	162	2.9%
토	143	2.6%
유	102	1.8%
Other values (53)	938	16.8%

ASCII

Value	Count	Frequency (%)
L	600	31.4%
U	358	18.7%
(	90	4.7%
)	83	4.3%
E	74	3.9%
P	73	3.8%
0	72	3.8%
-	71	3.7%
J	70	3.7%
T	69	3.6%
Other values (24)	352	18.4%

None

Value	Count	Frequency (%)
φ	4	66.7%
Φ	2	33.3%

Heatmap
Table

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	연장	종류	높이_최대	높이_최소	폭
식별번호	1.000	0.723	0.162	0.176	0.733	0.592	0.226	0.289	0.133	0.080	0.106	0.169	0.272	0.560	0.172
관리번호	0.723	1.000	0.098	0.054	0.999	0.289	0.016	0.094	0.048	0.009	0.026	0.006	0.069	0.126	0.154
관리기관	0.162	0.098	1.000	0.000	0.024	0.176	0.000	0.080	0.000	0.000	0.000	0.000	0.037	0.047	0.000
도로종류	0.176	0.054	0.000	1.000	0.060	0.880	0.000	0.072	0.000	0.000	0.000	0.000	0.036	0.061	0.000
노선번호	0.733	0.999	0.024	0.060	1.000	0.283	0.014	0.102	0.000	0.000	0.009	0.014	0.115	0.146	0.134
구간번호	0.592	0.289	0.176	0.880	0.283	1.000	0.126	0.217	0.069	0.066	0.000	0.077	0.114	0.224	0.060
이력코드	0.226	0.016	0.000	0.000	0.014	0.126	1.000	0.059	0.000	0.019	0.000	0.000	0.000	0.083	0.000
위치_시점	0.289	0.094	0.080	0.072	0.102	0.217	0.059	1.000	0.796	0.041	0.048	0.040	0.040	0.093	0.071
위치_종점	0.133	0.048	0.000	0.000	0.000	0.069	0.000	0.796	1.000	0.007	0.000	0.000	0.000	0.000	0.000
위치_방향	0.080	0.009	0.000	0.000	0.000	0.066	0.019	0.041	0.007	1.000	0.000	0.019	0.071	0.094	0.010
연장	0.106	0.026	0.000	0.000	0.009	0.000	0.000	0.048	0.000	0.000	1.000	0.000	0.000	0.000	0.071
종류	0.169	0.006	0.000	0.000	0.014	0.077	0.000	0.040	0.000	0.019	0.000	1.000	0.114	0.084	0.000
높이_최대	0.272	0.069	0.037	0.036	0.115	0.114	0.000	0.040	0.000	0.071	0.000	0.114	1.000	0.885	0.478
높이_최소	0.560	0.126	0.047	0.061	0.146	0.224	0.083	0.093	0.000	0.094	0.000	0.084	0.885	1.000	0.601
폭	0.172	0.154	0.000	0.000	0.134	0.060	0.000	0.071	0.000	0.010	0.071	0.000	0.478	0.601	1.000

Heatmap
Table

	위치_방향	이력코드	관리기관	도로종류
위치_방향	1.000	0.012	0.000	0.000
이력코드	0.012	1.000	0.000	0.000
관리기관	0.000	0.000	1.000	0.000
도로종류	0.000	0.000	0.000	1.000

Heatmap
Table

	식별번호	관리번호	노선번호	구간번호	위치_시점	위치_종점	연장	종류	높이_최대	높이_최소	폭	관리기관	도로종류	이력코드	위치_방향
식별번호	1.000	0.440	0.603	0.068	-0.098	-0.097	0.015	-0.087	-0.074	-0.165	-0.148	0.098	0.135	0.173	0.061
관리번호	0.440	1.000	0.886	-0.115	-0.009	-0.009	0.021	-0.039	-0.033	0.027	-0.089	0.029	0.090	0.026	0.015
노선번호	0.603	0.886	1.000	-0.124	-0.084	-0.084	0.007	-0.055	-0.069	-0.062	-0.078	0.007	0.100	0.023	0.000
구간번호	0.068	-0.115	-0.124	1.000	0.050	0.048	-0.020	0.031	0.024	0.011	0.005	0.106	0.714	0.097	0.050
위치_시점	-0.098	-0.009	-0.084	0.050	1.000	0.998	0.002	-0.005	0.006	0.000	0.006	0.047	0.055	0.045	0.031
위치_종점	-0.097	-0.009	-0.084	0.048	0.998	1.000	0.031	-0.007	0.003	-0.003	0.004	0.000	0.000	0.000	0.012
연장	0.015	0.021	0.007	-0.020	0.002	0.031	1.000	0.039	0.004	-0.009	-0.037	0.000	0.000	0.000	0.000
종류	-0.087	-0.039	-0.055	0.031	-0.005	-0.007	0.039	1.000	0.617	0.584	-0.023	0.000	0.000	0.000	0.012
높이_최대	-0.074	-0.033	-0.069	0.024	0.006	0.003	0.004	0.617	1.000	0.895	0.248	0.019	0.023	0.031	0.081
높이_최소	-0.165	0.027	-0.062	0.011	0.000	-0.003	-0.009	0.584	0.895	1.000	0.242	0.025	0.044	0.060	0.073
폭	-0.148	-0.089	-0.078	0.005	0.006	0.004	-0.037	-0.023	0.248	0.242	1.000	0.000	0.000	0.000	0.010
관리기관	0.098	0.029	0.007	0.106	0.047	0.000	0.000	0.000	0.019	0.025	0.000	1.000	0.000	0.000	0.000
도로종류	0.135	0.090	0.100	0.714	0.055	0.000	0.000	0.000	0.023	0.044	0.000	0.000	1.000	0.000	0.000
이력코드	0.173	0.026	0.023	0.097	0.045	0.000	0.000	0.000	0.031	0.060	0.000	0.000	0.000	1.000	0.012
위치_방향	0.061	0.015	0.000	0.050	0.031	0.012	0.000	0.012	0.081	0.073	0.010	0.000	0.000	0.012	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

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	위치_시점	위치_종점	위치_방향	연장	종류	높이_최대	높이_최소	폭	비고
4116	4093	600652	1683	1504	60	7	6.156	6.262	1	106.0	1301	0.2	0.2	0.7	<NA>
9706	9683	10370169	1683	1504	1037	3	4.453	5.121	1	668.0	1399	0.7	0.7	0.7	LU형측구(0.7*0.8
7921	7898	10180305	1683	1504	1018	7	2.921	2.959	1	38.0	1309	0.7	0.7	0.7	J형측구
144	121	10030366	1683	1504	1003	9	4.248	4.389	1	141.0	1301	0.1	0.1	0.7	<NA>
2326	2303	10110024	1683	1504	1011	1	1.538	1.575	0	37.0	1309	0.7	0.5	0.25	<NA>
13032	13009	10210373	1683	1504	1021	9	2.798	2.9	0	102.0	1303	0.6	0.6	0.6	<NA>
9672	9649	10370040	1683	1504	1037	1	2.501	2.526	1	25.0	1304	0.7	0.7	1.5	<NA>
9663	9640	10370025	1683	1504	1037	1	1.776	1.784	1	8.0	1304	0.7	0.7	1.5	<NA>
6979	6956	10130534	1683	1504	1013	5	10.81	10.85	1	40.0	1306	0.7	0.7	0.7	<NA>
14618	14595	10840535	1683	1504	1084	9	8.87	9.1	1	230.0	1301	0.25	0.25	0.5	<NA>

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	위치_시점	위치_종점	위치_방향	연장	종류	높이_최대	높이_최소	폭	비고
9033	9010	10340258	1683	1504	1034	6	2.05	2.13	1	80.0	1302	0.7	0.7	0.7	<NA>
14354	14331	10840188	1683	1504	1084	4	6.262	6.34	0	78.0	1303	0.6	0.6	0.7	<NA>
14812	14789	10890044	1683	1504	1089	3	4.136	4.301	1	165.0	1301	0.2	0.2	0.5	<NA>
933	910	10100093	1683	1504	1010	2	7.417	7.461	0	44.0	1302	0.4	0.4	0.4	<NA>
12644	12621	10060130	1683	1504	1006	4	4.275	4.409	0	135.0	1304	0.2	0.2	0.0	토사형 측구
1278	1255	10050248	1683	1504	1005	6	11.978	12.138	0	160.0	1301	0.2	0.2	0.75	<NA>
6214	6191	10070286	1683	1504	1007	6	8.836	8.94	0	104.0	1301	0.2	0.2	0.7	<NA>
14219	14196	10840101	1683	1504	1084	3	6.321	6.471	0	150.0	1301	0.15	0.15	0.3	<NA>
4596	4573	580165	1683	1504	58	3	4.075	4.155	1	80.0	1301	0.2	0.2	0.7	<NA>
6479	6456	10080110	1683	1504	1008	3	6.716	7.685	0	969.0	1308	0.2	0.2	0.0	<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)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Open Punctuation

Close Punctuation

Dash Punctuation

Space Separator

Lowercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Greek

Most occurring blocks

Most frequent character per block

Hangul

ASCII

None

Interactions

Correlations

Missing values

Sample