gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	1513
Missing cells	1450
Missing cells (%)	5.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	223.2 KiB
Average record size in memory	151.1 B

Variable types

Numeric	11
Categorical	4
Text	2

Dataset

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

Alerts

`식별번호` 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 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 2 other fields	High correlation
`관리기관` is highly imbalanced (82.3%)	Imbalance
`도로종류` is highly imbalanced (55.5%)	Imbalance
`이력코드` is highly imbalanced (96.3%)	Imbalance
`사진` has 298 (19.7%) missing values	Missing
`비고` has 1145 (75.7%) missing values	Missing
`식별번호` has unique values	Unique
`관리번호` has 68 (4.5%) zeros	Zeros
`높이_최소` has 143 (9.5%) zeros	Zeros
`폭` has 304 (20.1%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:30:48.114904
Analysis finished	2023-12-11 00:31:02.885068
Duration	14.77 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

식별번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1513
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	757

Minimum	1
Maximum	1513
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	1
5-th percentile	76.6
Q1	379
median	757
Q3	1135
95-th percentile	1437.4
Maximum	1513
Range	1512
Interquartile range (IQR)	756

Descriptive statistics

Standard deviation	436.90979
Coefficient of variation (CV)	0.57715957
Kurtosis	-1.2
Mean	757
Median Absolute Deviation (MAD)	378
Skewness	0
Sum	1145341
Variance	190890.17
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
1006	1	0.1%
1015	1	0.1%
1014	1	0.1%
1013	1	0.1%
1012	1	0.1%
1011	1	0.1%
1010	1	0.1%
1009	1	0.1%
1008	1	0.1%
Other values (1503)	1503	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 (%)
1513	1	0.1%
1512	1	0.1%
1511	1	0.1%
1510	1	0.1%
1509	1	0.1%
1508	1	0.1%
1507	1	0.1%
1506	1	0.1%
1505	1	0.1%
1504	1	0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1436
Distinct (%)	94.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8321671.2

Minimum	0
Maximum	10990030
Zeros	68
Zeros (%)	4.5%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	300008.6
Q1	10020012
median	10180002
Q3	10340041
95-th percentile	10890002
Maximum	10990030
Range	10990030
Interquartile range (IQR)	320029

Descriptive statistics

Standard deviation	3964776.2
Coefficient of variation (CV)	0.4764399
Kurtosis	0.22722638
Mean	8321671.2
Median Absolute Deviation (MAD)	160029
Skewness	-1.4808695
Sum	1.2590688 × 10¹⁰
Variance	1.571945 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68	4.5%
690001	2	0.1%
690002	2	0.1%
10180077	2	0.1%
10090007	2	0.1%
10400002	2	0.1%
600001	2	0.1%
10770077	2	0.1%
10400003	2	0.1%
690003	2	0.1%
Other values (1426)	1427	94.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	68	4.5%
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 (%)
10990030	1	0.1%
10990029	1	0.1%
10990028	1	0.1%
10990027	1	0.1%
10990026	1	0.1%
10990025	1	0.1%
10990024	1	0.1%
10990023	1	0.1%
10990022	1	0.1%
10990021	1	0.1%

관리기관
Categorical

IMBALANCE

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

1683	1447
1684	59
1682	7

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	1447	95.6%
1684	59	3.9%
1682	7	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	1447	95.6%
1684	59	3.9%
1682	7	0.5%

도로종류
Categorical

HIGH CORRELATION IMBALANCE

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

1504	1373
1507	140

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	1373	90.7%
1507	140	9.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	1373	90.7%
1507	140	9.3%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	42
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	877.33113

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

Quantile statistics

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

Descriptive statistics

Standard deviation	356.71175
Coefficient of variation (CV)	0.40658736
Kurtosis	1.4865397
Mean	877.33113
Median Absolute Deviation (MAD)	16
Skewness	-1.8543278
Sum	1327402
Variance	127243.27
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
1018	119	7.9%
60	97	6.4%
1077	83	5.5%
1024	68	4.5%
1002	64	4.2%
1001	59	3.9%
1022	56	3.7%
1034	55	3.6%
1084	53	3.5%
1010	53	3.5%
Other values (32)	806	53.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	11	0.7%
37	46	3.0%
58	14	0.9%
60	97	6.4%
67	32	2.1%
69	39	2.6%
907	5	0.3%
1001	59	3.9%
1002	64	4.2%
1003	31	2.0%

Value	Count	Frequency (%)
1099	30	2.0%
1089	48	3.2%
1084	53	3.5%
1080	31	2.0%
1077	83	5.5%
1051	13	0.9%
1049	20	1.3%
1047	25	1.7%
1042	17	1.1%
1041	25	1.7%

구간번호
Real number (ℝ)

Distinct	17
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1625909

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	13.4 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.4943267
Coefficient of variation (CV)	0.67685525
Kurtosis	-0.082981952
Mean	5.1625909
Median Absolute Deviation (MAD)	2
Skewness	0.7962538
Sum	7811
Variance	12.210319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	228	15.1%
2	193	12.8%
3	175	11.6%
5	170	11.2%
4	162	10.7%
7	140	9.3%
6	105	6.9%
8	69	4.6%
11	68	4.5%
10	57	3.8%
Other values (7)	146	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	228	15.1%
2	193	12.8%
3	175	11.6%
4	162	10.7%
5	170	11.2%
6	105	6.9%
7	140	9.3%
8	69	4.6%
9	55	3.6%
10	57	3.8%

Value	Count	Frequency (%)
19	1	0.1%
16	2	0.1%
15	9	0.6%
14	16	1.1%
13	33	2.2%
12	30	2.0%
11	68	4.5%
10	57	3.8%
9	55	3.6%
8	69	4.6%

이력코드
Categorical

IMBALANCE

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

0	1507
1	6

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	1507	99.6%
1	6	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1507	99.6%
1	6	0.4%

위치_시점
Real number (ℝ)

HIGH CORRELATION

Distinct	1390
Distinct (%)	91.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6274997

Minimum	0
Maximum	28.692
Zeros	6
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2806
Q1	1.99
median	5.019
Q3	8.416
95-th percentile	13.2088
Maximum	28.692
Range	28.692
Interquartile range (IQR)	6.426

Descriptive statistics

Standard deviation	4.2607585
Coefficient of variation (CV)	0.75713172
Kurtosis	1.6078352
Mean	5.6274997
Median Absolute Deviation (MAD)	3.153
Skewness	0.94463324
Sum	8514.407
Variance	18.154063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	6	0.4%
7.5	3	0.2%
0.76	3	0.2%
0.678	3	0.2%
4.62	3	0.2%
6.62	3	0.2%
10.98	3	0.2%
3.043	3	0.2%
11.67	2	0.1%
4.104	2	0.1%
Other values (1380)	1482	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	6	0.4%
0.001	1	0.1%
0.002	1	0.1%
0.005	2	0.1%
0.006	1	0.1%
0.008	1	0.1%
0.011	1	0.1%
0.012	2	0.1%
0.015	1	0.1%
0.019	2	0.1%

Value	Count	Frequency (%)
28.692	1	0.1%
27.86	1	0.1%
27.785	1	0.1%
27.192	1	0.1%
24.8	1	0.1%
23.312	1	0.1%
19.898	1	0.1%
18.873	1	0.1%
17.914	1	0.1%
17.767	1	0.1%

위치_종점
Real number (ℝ)

HIGH CORRELATION

Distinct	1397
Distinct (%)	92.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7190337

Minimum	0
Maximum	57.815
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3426
Q1	2.071
median	5.102
Q3	8.489
95-th percentile	13.3494
Maximum	57.815
Range	57.815
Interquartile range (IQR)	6.418

Descriptive statistics

Standard deviation	4.4298384
Coefficient of variation (CV)	0.77457812
Kurtosis	13.203453
Mean	5.7190337
Median Absolute Deviation (MAD)	3.165
Skewness	1.8211907
Sum	8652.898
Variance	19.623468
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.76	3	0.2%
6.635	3	0.2%
3.625	3	0.2%
0.047	3	0.2%
9.603	2	0.1%
4.461	2	0.1%
5.41	2	0.1%
5.528	2	0.1%
3.59	2	0.1%
5.36	2	0.1%
Other values (1387)	1489	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	0.1%
0.002	1	0.1%
0.02	1	0.1%
0.022	1	0.1%
0.025	1	0.1%
0.026	1	0.1%
0.035	1	0.1%
0.036	1	0.1%
0.038	2	0.1%
0.045	1	0.1%

Value	Count	Frequency (%)
57.815	1	0.1%
28.725	1	0.1%
27.885	1	0.1%
27.225	1	0.1%
24.815	1	0.1%
23.34	1	0.1%
19.957	1	0.1%
18.98	1	0.1%
18.0	1	0.1%
17.798	1	0.1%

위치_방향
Categorical

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

1	760
0	753

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	1

Common Values

Value	Count	Frequency (%)
1	760	50.2%
0	753	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	760	50.2%
0	753	49.8%

연장
Real number (ℝ)

Distinct	258
Distinct (%)	17.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.669227

Minimum	0
Maximum	1315
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	11
Q1	27
median	47
Q3	90
95-th percentile	209
Maximum	1315
Range	1315
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	79.490204
Coefficient of variation (CV)	1.1248206
Kurtosis	48.815155
Mean	70.669227
Median Absolute Deviation (MAD)	26
Skewness	4.8853028
Sum	106922.54
Variance	6318.6926
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.0	51	3.4%
30.0	44	2.9%
40.0	34	2.2%
10.0	28	1.9%
15.0	27	1.8%
18.0	27	1.8%
22.0	24	1.6%
35.0	24	1.6%
29.0	24	1.6%
50.0	23	1.5%
Other values (248)	1207	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	0.1%
2.0	2	0.1%
4.0	4	0.3%
5.0	2	0.1%
6.0	11	0.7%
7.0	4	0.3%
8.0	11	0.7%
9.0	8	0.5%
10.0	28	1.9%
11.0	11	0.7%

Value	Count	Frequency (%)
1315.0	1	0.1%
666.0	1	0.1%
623.0	1	0.1%
622.0	1	0.1%
566.0	1	0.1%
515.0	1	0.1%
506.0	1	0.1%
499.0	1	0.1%
460.0	1	0.1%
441.0	1	0.1%

종류
Real number (ℝ)

Distinct	9
Distinct (%)	0.6%
Missing	7
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	4324.917

Minimum	4300
Maximum	4399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	4300
5-th percentile	4301
Q1	4301
median	4302
Q3	4309
95-th percentile	4399
Maximum	4399
Range	99
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	40.914826
Coefficient of variation (CV)	0.009460257
Kurtosis	-0.4136844
Mean	4324.917
Median Absolute Deviation (MAD)	1
Skewness	1.2536218
Sum	6513325
Variance	1674.023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
4301	572	37.8%
4399	351	23.2%
4302	330	21.8%
4308	142	9.4%
4300	56	3.7%
4309	35	2.3%
4304	13	0.9%
4306	6	0.4%
4305	1	0.1%
(Missing)	7	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4300	56	3.7%
4301	572	37.8%
4302	330	21.8%
4304	13	0.9%
4305	1	0.1%
4306	6	0.4%
4308	142	9.4%
4309	35	2.3%
4399	351	23.2%

Value	Count	Frequency (%)
4399	351	23.2%
4309	35	2.3%
4308	142	9.4%
4306	6	0.4%
4305	1	0.1%
4304	13	0.9%
4302	330	21.8%
4301	572	37.8%
4300	56	3.7%

높이_최대
Real number (ℝ)

Distinct	76
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5559815

Minimum	0
Maximum	20.5
Zeros	14
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0.8
Q1	1.2
median	2
Q3	3
95-th percentile	6
Maximum	20.5
Range	20.5
Interquartile range (IQR)	1.8

Descriptive statistics

Standard deviation	2.0898807
Coefficient of variation (CV)	0.81764314
Kurtosis	19.120821
Mean	2.5559815
Median Absolute Deviation (MAD)	1
Skewness	3.4090569
Sum	3867.2
Variance	4.3676014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.0	227	15.0%
1.0	209	13.8%
3.0	159	10.5%
2.5	84	5.6%
1.5	71	4.7%
4.0	58	3.8%
5.0	48	3.2%
6.0	46	3.0%
1.8	44	2.9%
1.2	43	2.8%
Other values (66)	524	34.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	14	0.9%
0.2	1	0.1%
0.3	6	0.4%
0.4	4	0.3%
0.5	16	1.1%
0.6	10	0.7%
0.7	11	0.7%
0.8	19	1.3%
0.9	21	1.4%
1.0	209	13.8%

Value	Count	Frequency (%)
20.5	1	0.1%
20.0	2	0.1%
19.0	1	0.1%
18.0	1	0.1%
17.0	1	0.1%
16.0	1	0.1%
15.0	1	0.1%
13.5	1	0.1%
12.6	1	0.1%
12.0	2	0.1%

높이_최소
Real number (ℝ)

ZEROS

Distinct	58
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6271183

Minimum	0
Maximum	20
Zeros	143
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	1.6563185
Coefficient of variation (CV)	1.017946
Kurtosis	27.204323
Mean	1.6271183
Median Absolute Deviation (MAD)	0.6
Skewness	3.8260154
Sum	2461.83
Variance	2.743391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.0	392	25.9%
0.0	143	9.5%
2.0	132	8.7%
3.0	88	5.8%
0.5	76	5.0%
1.5	71	4.7%
2.5	41	2.7%
0.2	39	2.6%
1.2	39	2.6%
0.3	38	2.5%
Other values (48)	454	30.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	143	9.5%
0.1	2	0.1%
0.2	39	2.6%
0.3	38	2.5%
0.4	9	0.6%
0.5	76	5.0%
0.6	17	1.1%
0.7	15	1.0%
0.8	25	1.7%
0.9	13	0.9%

Value	Count	Frequency (%)
20.0	1	0.1%
18.0	1	0.1%
17.0	1	0.1%
16.0	1	0.1%
9.0	9	0.6%
8.0	6	0.4%
7.5	3	0.2%
7.2	1	0.1%
7.0	3	0.2%
6.5	1	0.1%

폭
Real number (ℝ)

ZEROS

Distinct	34
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.59074686

Minimum	0
Maximum	27
Zeros	304
Zeros (%)	20.1%
Negative	0
Negative (%)	0.0%
Memory size	13.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.25
median	0.5
Q3	0.7
95-th percentile	1
Maximum	27
Range	27
Interquartile range (IQR)	0.45

Descriptive statistics

Standard deviation	1.0756429
Coefficient of variation (CV)	1.8208186
Kurtosis	287.75321
Mean	0.59074686
Median Absolute Deviation (MAD)	0.2
Skewness	14.207131
Sum	893.8
Variance	1.1570076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0.5	411	27.2%
0.0	304	20.1%
0.7	273	18.0%
1.0	178	11.8%
0.3	121	8.0%
0.25	71	4.7%
0.8	51	3.4%
0.4	18	1.2%
2.0	16	1.1%
0.2	11	0.7%
Other values (24)	59	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	304	20.1%
0.1	2	0.1%
0.15	11	0.7%
0.2	11	0.7%
0.25	71	4.7%
0.3	121	8.0%
0.4	18	1.2%
0.5	411	27.2%
0.6	6	0.4%
0.7	273	18.0%

Value	Count	Frequency (%)
27.0	1	0.1%
16.6	1	0.1%
11.0	1	0.1%
10.8	1	0.1%
7.0	5	0.3%
6.0	1	0.1%
5.2	1	0.1%
5.0	3	0.2%
4.5	1	0.1%
3.4	1	0.1%

사진
Text

MISSING

Distinct	1212
Distinct (%)	99.8%
Missing	298
Missing (%)	19.7%
Memory size	11.9 KiB

Length

Max length	13
Median length	13
Mean length	12.986008
Min length	12

Characters and Unicode

Total characters	15778
Distinct characters	15
Distinct categories	3 ?
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	1209 ?
Unique (%)	99.5%

Sample

1st row	100309F04959U
2nd row	100309F02666U
3rd row	100309F00233U
4th row	100308F01615U
5th row	100307F10275D

Value	Count	Frequency (%)
102202f01966d	2	0.2%
100902f01118u	2	0.2%
101809f01667d	2	0.2%
104201f02175d	1	0.1%
103701f08172u	1	0.1%
103701f04708d	1	0.1%
103701f04798d	1	0.1%
103701f06001d	1	0.1%
103701f06114d	1	0.1%
103701f07240d	1	0.1%
Other values (1202)	1202	98.9%

Most occurring characters

Value	Count	Frequency (%)
0	4826	30.6%
1	2407	15.3%
F	1210	7.7%
2	857	5.4%
4	847	5.4%
7	841	5.3%
3	803	5.1%
6	727	4.6%
8	695	4.4%
5	689	4.4%
Other values (5)	1876	11.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	13348	84.6%
Uppercase Letter	2428	15.4%
Lowercase Letter	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4826	36.2%
1	2407	18.0%
2	857	6.4%
4	847	6.3%
7	841	6.3%
3	803	6.0%
6	727	5.4%
8	695	5.2%
5	689	5.2%
9	656	4.9%

Uppercase Letter

Value	Count	Frequency (%)
F	1210	49.8%
D	614	25.3%
U	599	24.7%
L	5	0.2%

Lowercase Letter

Value	Count	Frequency (%)
u	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13348	84.6%
Latin	2430	15.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4826	36.2%
1	2407	18.0%
2	857	6.4%
4	847	6.3%
7	841	6.3%
3	803	6.0%
6	727	5.4%
8	695	5.2%
5	689	5.2%
9	656	4.9%

Latin

Value	Count	Frequency (%)
F	1210	49.8%
D	614	25.3%
U	599	24.7%
L	5	0.2%
u	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15778	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4826	30.6%
1	2407	15.3%
F	1210	7.7%
2	857	5.4%
4	847	5.4%
7	841	5.3%
3	803	5.1%
6	727	4.6%
8	695	4.4%
5	689	4.4%
Other values (5)	1876	11.9%

비고
Text

MISSING

Distinct	66
Distinct (%)	17.9%
Missing	1145
Missing (%)	75.7%
Memory size	11.9 KiB

Length

Max length	15
Median length	10
Mean length	4.3288043
Min length	1

Characters and Unicode

Total characters	1593
Distinct characters	75
Distinct categories	8 ?
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	30 ?
Unique (%)	8.2%

Sample

1st row	돌망태2단
2nd row	돌망태2단
3rd row	돌망태3단
4th row	돌망태2단
5th row	돌망태2단

Value	Count	Frequency (%)
개비온	62	15.9%
돌망태	39	10.0%
l형	34	8.7%
0	25	6.4%
역t형	25	6.4%
돌망태2단	20	5.1%
옹벽	19	4.9%
옹벽(개비온	18	4.6%
돌망태3단	17	4.4%
l형옹벽	10	2.6%
Other values (51)	120	30.8%

Most occurring characters

Value	Count	Frequency (%)
비	106	6.7%
개	102	6.4%
벽	101	6.3%
망	100	6.3%
옹	98	6.2%
온	97	6.1%
돌	96	6.0%
태	96	6.0%
형	91	5.7%
(	72	4.5%
Other values (65)	634	39.8%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1184	74.3%
Decimal Number	114	7.2%
Uppercase Letter	99	6.2%
Open Punctuation	72	4.5%
Close Punctuation	72	4.5%
Space Separator	21	1.3%
Other Punctuation	17	1.1%
Math Symbol	14	0.9%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
비	106	9.0%
개	102	8.6%
벽	101	8.5%
망	100	8.4%
옹	98	8.3%
온	97	8.2%
돌	96	8.1%
태	96	8.1%
형	91	7.7%
단	62	5.2%
Other values (45)	235	19.8%

Decimal Number

Value	Count	Frequency (%)
0	35	30.7%
2	33	28.9%
3	24	21.1%
1	10	8.8%
5	5	4.4%
6	4	3.5%
4	3	2.6%

Uppercase Letter

Value	Count	Frequency (%)
L	56	56.6%
T	33	33.3%
H	7	7.1%
W	1	1.0%
R	1	1.0%
M	1	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	16	94.1%
,	1	5.9%

Math Symbol

Value	Count	Frequency (%)
=	7	50.0%
~	7	50.0%

Open Punctuation

Value	Count	Frequency (%)
(	72	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	72	100.0%

Space Separator

Value	Count	Frequency (%)
	21	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	1184	74.3%
Common	310	19.5%
Latin	99	6.2%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
비	106	9.0%
개	102	8.6%
벽	101	8.5%
망	100	8.4%
옹	98	8.3%
온	97	8.2%
돌	96	8.1%
태	96	8.1%
형	91	7.7%
단	62	5.2%
Other values (45)	235	19.8%

Common

Value	Count	Frequency (%)
(	72	23.2%
)	72	23.2%
0	35	11.3%
2	33	10.6%
3	24	7.7%
	21	6.8%
.	16	5.2%
1	10	3.2%
=	7	2.3%
~	7	2.3%
Other values (4)	13	4.2%

Latin

Value	Count	Frequency (%)
L	56	56.6%
T	33	33.3%
H	7	7.1%
W	1	1.0%
R	1	1.0%
M	1	1.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	1184	74.3%
ASCII	409	25.7%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
비	106	9.0%
개	102	8.6%
벽	101	8.5%
망	100	8.4%
옹	98	8.3%
온	97	8.2%
돌	96	8.1%
태	96	8.1%
형	91	7.7%
단	62	5.2%
Other values (45)	235	19.8%

ASCII

Value	Count	Frequency (%)
(	72	17.6%
)	72	17.6%
L	56	13.7%
0	35	8.6%
T	33	8.1%
2	33	8.1%
3	24	5.9%
	21	5.1%
.	16	3.9%
1	10	2.4%
Other values (10)	37	9.0%

Heatmap
Table

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	연장	종류	높이_최대	높이_최소	폭	비고
식별번호	1.000	0.695	0.602	0.998	0.740	0.571	0.225	0.245	0.236	0.101	0.054	0.354	0.278	0.205	0.052	0.928
관리번호	0.695	1.000	0.330	0.404	0.997	0.197	0.000	0.157	0.070	0.014	0.000	0.038	0.000	0.118	0.113	0.713
관리기관	0.602	0.330	1.000	0.035	0.179	0.538	0.000	0.163	0.095	0.027	0.077	0.171	0.103	0.110	0.000	0.926
도로종류	0.998	0.404	0.035	1.000	0.481	0.199	0.000	0.084	0.074	0.058	0.000	0.000	0.000	0.038	0.117	0.636
노선번호	0.740	0.997	0.179	0.481	1.000	0.168	0.000	0.131	0.013	0.028	0.000	0.057	0.000	0.083	0.033	0.685
구간번호	0.571	0.197	0.538	0.199	0.168	1.000	0.087	0.196	0.151	0.072	0.000	0.132	0.165	0.000	0.000	0.827
이력코드	0.225	0.000	0.000	0.000	0.000	0.087	1.000	0.000	0.000	0.000	0.000	0.069	0.000	0.000	0.000	NaN
위치_시점	0.245	0.157	0.163	0.084	0.131	0.196	0.000	1.000	0.986	0.151	0.044	0.097	0.000	0.027	0.000	0.825
위치_종점	0.236	0.070	0.095	0.074	0.013	0.151	0.000	0.986	1.000	0.168	0.000	0.103	0.000	0.000	0.000	0.861
위치_방향	0.101	0.014	0.027	0.058	0.028	0.072	0.000	0.151	0.168	1.000	0.040	0.073	0.035	0.070	0.070	0.440
연장	0.054	0.000	0.077	0.000	0.000	0.000	0.000	0.044	0.000	0.040	1.000	0.062	0.000	0.059	0.000	0.771
종류	0.354	0.038	0.171	0.000	0.057	0.132	0.069	0.097	0.103	0.073	0.062	1.000	0.023	0.000	0.054	0.949
높이_최대	0.278	0.000	0.103	0.000	0.000	0.165	0.000	0.000	0.000	0.035	0.000	0.023	1.000	0.766	0.144	0.796
높이_최소	0.205	0.118	0.110	0.038	0.083	0.000	0.000	0.027	0.000	0.070	0.059	0.000	0.766	1.000	0.053	0.873
폭	0.052	0.113	0.000	0.117	0.033	0.000	0.000	0.000	0.000	0.070	0.000	0.054	0.144	0.053	1.000	0.000
비고	0.928	0.713	0.926	0.636	0.685	0.827	NaN	0.825	0.861	0.440	0.771	0.949	0.796	0.873	0.000	1.000

Heatmap
Table

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

Heatmap
Table

	식별번호	관리번호	노선번호	구간번호	위치_시점	위치_종점	연장	종류	높이_최대	높이_최소	폭	관리기관	도로종류	이력코드	위치_방향
식별번호	1.000	0.502	0.687	0.068	-0.084	-0.085	-0.011	0.103	0.029	0.003	-0.321	0.445	0.956	0.172	0.077
관리번호	0.502	1.000	0.850	-0.105	-0.041	-0.041	0.022	-0.018	0.021	0.016	-0.113	0.114	0.636	0.000	0.023
노선번호	0.687	0.850	1.000	-0.098	-0.082	-0.083	-0.015	0.037	0.055	0.038	-0.154	0.055	0.737	0.000	0.046
구간번호	0.068	-0.105	-0.098	1.000	0.048	0.048	0.002	0.007	0.040	-0.090	0.104	0.389	0.161	0.066	0.054
위치_시점	-0.084	-0.041	-0.082	0.048	1.000	0.999	0.035	-0.017	0.025	0.027	0.072	0.072	0.083	0.000	0.149
위치_종점	-0.085	-0.041	-0.083	0.048	0.999	1.000	0.050	-0.017	0.025	0.027	0.072	0.039	0.053	0.000	0.121
연장	-0.011	0.022	-0.015	0.002	0.035	0.050	1.000	0.017	0.009	-0.013	-0.021	0.052	0.000	0.000	0.043
종류	0.103	-0.018	0.037	0.007	-0.017	-0.017	0.017	1.000	0.175	-0.019	0.338	0.104	0.000	0.046	0.050
높이_최대	0.029	0.021	0.055	0.040	0.025	0.025	0.009	0.175	1.000	0.461	0.269	0.060	0.000	0.000	0.032
높이_최소	0.003	0.016	0.038	-0.090	0.027	0.027	-0.013	-0.019	0.461	1.000	-0.118	0.034	0.044	0.000	0.071
폭	-0.321	-0.113	-0.154	0.104	0.072	0.072	-0.021	0.338	0.269	-0.118	1.000	0.000	0.101	0.000	0.057
관리기관	0.445	0.114	0.055	0.389	0.072	0.039	0.052	0.104	0.060	0.034	0.000	1.000	0.058	0.000	0.044
도로종류	0.956	0.636	0.737	0.161	0.083	0.053	0.000	0.000	0.000	0.044	0.101	0.058	1.000	0.000	0.037
이력코드	0.172	0.000	0.000	0.066	0.000	0.000	0.000	0.046	0.000	0.000	0.000	0.000	0.000	1.000	0.000
위치_방향	0.077	0.023	0.046	0.054	0.149	0.121	0.043	0.050	0.032	0.071	0.057	0.044	0.037	0.000	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	1	10030032	1683	1504	1003	9	4.959	5.0	0	41.0	4308	2.0	1.0	1.0	100309F04959U	돌망태2단
1	2	10030031	1683	1504	1003	9	2.666	2.706	0	40.0	4302	1.2	1.2	0.3	100309F02666U	<NA>
2	3	10030030	1683	1504	1003	9	0.233	0.275	0	42.0	4308	2.0	1.0	1.0	100309F00233U	돌망태2단
3	4	10030029	1683	1504	1003	8	1.615	1.65	0	35.0	4308	3.0	1.0	1.0	100308F01615U	돌망태3단
4	5	10030028	1683	1504	1003	7	10.275	10.335	1	60.0	4308	2.0	1.0	1.0	100307F10275D	돌망태2단
5	6	10030027	1683	1504	1003	7	10.122	10.165	1	43.0	4308	2.0	1.0	1.0	100307F10122D	돌망태2단
6	7	10030026	1683	1504	1003	7	9.869	9.94	1	71.0	4308	3.0	1.0	1.0	100307F09869D	돌망태3단
7	8	10030025	1683	1504	1003	2	5.268	5.33	1	62.0	4302	0.8	0.8	0.3	100302F05268D	<NA>
8	9	10030024	1683	1504	1003	9	6.315	6.398	0	83.0	4302	2.0	2.0	0.3	100309F06315U	<NA>
9	10	10030022	1683	1504	1003	9	5.0	5.048	0	48.0	4308	2.0	2.0	0.3	100309F05000U	돌망태2단

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	연장	종류	높이_최대	높이_최소	사진	비고
1503	1504	0	1682	1504	1002	14	0	8.903	8.978	1	75.0	<NA>	0.0	0.0	<NA>	<NA>
1504	1505	0	1682	1504	1002	14	0	9.048	9.13	1	82.0	<NA>	0.0	0.0	<NA>	<NA>
1505	1506	0	1682	1504	1002	14	0	9.422	9.741	0	319.0	<NA>	0.0	0.0	<NA>	<NA>
1506	1507	0	1682	1504	1002	14	0	9.372	9.561	1	189.0	<NA>	0.0	0.0	<NA>	<NA>
1507	1508	10420020	1683	1504	1042	1	1	3.993	4.06	0	67.0	4399	0.0	0.0	104201F03993U	<NA>
1508	1509	10420019	1683	1504	1042	1	1	3.966	4.13	1	164.0	4399	0.0	0.0	104201F03966D	<NA>
1509	1510	10420018	1683	1504	1042	1	1	3.34	3.38	0	40.0	4399	0.0	0.0	104201F03340U	<NA>
1510	1511	10420015	1683	1504	1042	1	1	1.925	2.01	1	85.0	4309	3.0	2.0	104201F01925D	<NA>
1511	1512	10420017	1683	1504	1042	1	1	2.175	2.229	1	54.0	4309	5.0	0.0	104201F02175D	<NA>
1512	1513	10420016	1683	1504	1042	1	1	2.091	2.133	0	42.0	4399	0.0	0.0	104201F02091U	<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

Decimal Number

Uppercase Letter

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Uppercase Letter

Other Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Interactions

Correlations

Missing values

Sample