gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	3425
Missing cells	2841
Missing cells (%)	5.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	441.6 KiB
Average record size in memory	132.0 B

Variable types

Numeric	8
Categorical	4
DateTime	1
Text	2

Dataset

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

Alerts

`식별번호` 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 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 (87.6%)	Imbalance
`이력코드` is highly imbalanced (97.4%)	Imbalance
`사진` has 459 (13.4%) missing values	Missing
`비고` has 2382 (69.5%) missing values	Missing
`수량` is highly skewed (γ1 = 32.37376281)	Skewed
`식별번호` has unique values	Unique
`관리번호` has 127 (3.7%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:13:34.761349
Analysis finished	2023-12-11 00:13:44.365985
Duration	9.6 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

식별번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3425
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1713

Minimum	1
Maximum	3425
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	1
5-th percentile	172.2
Q1	857
median	1713
Q3	2569
95-th percentile	3253.8
Maximum	3425
Range	3424
Interquartile range (IQR)	1712

Descriptive statistics

Standard deviation	988.85666
Coefficient of variation (CV)	0.577266
Kurtosis	-1.2
Mean	1713
Median Absolute Deviation (MAD)	856
Skewness	0
Sum	5867025
Variance	977837.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
3231	1	< 0.1%
3233	1	< 0.1%
3234	1	< 0.1%
3235	1	< 0.1%
3236	1	< 0.1%
3237	1	< 0.1%
3238	1	< 0.1%
3239	1	< 0.1%
3240	1	< 0.1%
Other values (3415)	3415	99.7%

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 (%)
3425	1	< 0.1%
3424	1	< 0.1%
3423	1	< 0.1%
3422	1	< 0.1%
3421	1	< 0.1%
3420	1	< 0.1%
3419	1	< 0.1%
3418	1	< 0.1%
3417	1	< 0.1%
3416	1	< 0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3259
Distinct (%)	95.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8586805.7

Minimum	0
Maximum	10990081
Zeros	127
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	0
5-th percentile	300033.2
Q1	10010249
median	10100189
Q3	10280006
95-th percentile	10890088
Maximum	10990081
Range	10990081
Interquartile range (IQR)	269757

Descriptive statistics

Standard deviation	3714547.5
Coefficient of variation (CV)	0.43258781
Kurtosis	1.0587329
Mean	8586805.7
Median Absolute Deviation (MAD)	99815
Skewness	-1.7338734
Sum	2.940981 × 10¹⁰
Variance	1.3797863 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	127	3.7%
10020003	4	0.1%
690002	2	0.1%
600001	2	0.1%
10240001	2	0.1%
600009	2	0.1%
10240000	2	0.1%
600007	2	0.1%
600006	2	0.1%
600008	2	0.1%
Other values (3249)	3278	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	127	3.7%
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%

Value	Count	Frequency (%)
10990081	1	< 0.1%
10990080	1	< 0.1%
10990079	1	< 0.1%
10990078	1	< 0.1%
10990077	1	< 0.1%
10990076	1	< 0.1%
10990075	1	< 0.1%
10990074	1	< 0.1%
10990073	1	< 0.1%
10990072	1	< 0.1%

관리기관
Categorical

IMBALANCE

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

1683	3367
1684	58

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	3367	98.3%
1684	58	1.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1683	3367	98.3%
1684	58	1.7%

도로종류
Categorical

HIGH CORRELATION

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

1504	2999
1507	426

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	2999	87.6%
1507	426	12.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1504	2999	87.6%
1507	426	12.4%

노선번호
Real number (ℝ)

HIGH CORRELATION

Distinct	41
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	897.77956

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

Quantile statistics

Minimum	30
5-th percentile	58
Q1	1003
median	1011
Q3	1034
95-th percentile	1089
Maximum	1099
Range	1069
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	331.82605
Coefficient of variation (CV)	0.36960749
Kurtosis	2.5940168
Mean	897.77956
Median Absolute Deviation (MAD)	10
Skewness	-2.1259675
Sum	3074895
Variance	110108.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1010	297	8.7%
1001	251	7.3%
1018	249	7.3%
1003	215	6.3%
1034	180	5.3%
1089	178	5.2%
60	146	4.3%
1049	125	3.6%
1080	121	3.5%
1011	119	3.5%
Other values (31)	1544	45.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30	34	1.0%
37	101	2.9%
58	42	1.2%
60	146	4.3%
67	99	2.9%
69	34	1.0%
907	26	0.8%
1001	251	7.3%
1002	80	2.3%
1003	215	6.3%

Value	Count	Frequency (%)
1099	81	2.4%
1089	178	5.2%
1084	112	3.3%
1080	121	3.5%
1077	32	0.9%
1049	125	3.6%
1042	25	0.7%
1041	26	0.8%
1040	50	1.5%
1037	31	0.9%

구간번호
Real number (ℝ)

Distinct	17
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.2087591

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.2 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.7639824
Coefficient of variation (CV)	0.72262554
Kurtosis	0.47756037
Mean	5.2087591
Median Absolute Deviation (MAD)	2
Skewness	1.0213615
Sum	17840
Variance	14.167563
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	548	16.0%
5	443	12.9%
2	427	12.5%
3	400	11.7%
4	389	11.4%
9	326	9.5%
7	252	7.4%
6	176	5.1%
13	88	2.6%
10	82	2.4%
Other values (7)	294	8.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	548	16.0%
2	427	12.5%
3	400	11.7%
4	389	11.4%
5	443	12.9%
6	176	5.1%
7	252	7.4%
8	51	1.5%
9	326	9.5%
10	82	2.4%

Value	Count	Frequency (%)
19	9	0.3%
16	20	0.6%
15	59	1.7%
14	79	2.3%
13	88	2.6%
12	23	0.7%
11	53	1.5%
10	82	2.4%
9	326	9.5%
8	51	1.5%

이력코드
Categorical

IMBALANCE

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

0	3416
1	9

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	3416	99.7%
1	9	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	3416	99.7%
1	9	0.3%

위치_시점
Real number (ℝ)

HIGH CORRELATION

Distinct	2660
Distinct (%)	77.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3563673

Minimum	0
Maximum	28.084
Zeros	23
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.26
Q1	2.212
median	4.782
Q3	7.936
95-th percentile	12.344
Maximum	28.084
Range	28.084
Interquartile range (IQR)	5.724

Descriptive statistics

Standard deviation	3.9216865
Coefficient of variation (CV)	0.73215414
Kurtosis	1.684863
Mean	5.3563673
Median Absolute Deviation (MAD)	2.822
Skewness	0.97312881
Sum	18345.558
Variance	15.379625
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	23	0.7%
7.0	8	0.2%
1.96	6	0.2%
5.24	6	0.2%
2.34	6	0.2%
2.16	6	0.2%
1.7	6	0.2%
0.78	5	0.1%
4.782	5	0.1%
8.55	5	0.1%
Other values (2650)	3349	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	23	0.7%
0.001	1	< 0.1%
0.002	1	< 0.1%
0.003	4	0.1%
0.004	2	0.1%
0.008	2	0.1%
0.009	1	< 0.1%
0.01	1	< 0.1%
0.012	1	< 0.1%
0.013	1	< 0.1%

Value	Count	Frequency (%)
28.084	1	< 0.1%
27.255	1	< 0.1%
27.192	1	< 0.1%
24.7	1	< 0.1%
24.682	1	< 0.1%
24.11	2	0.1%
23.78	1	< 0.1%
23.741	1	< 0.1%
23.345	1	< 0.1%
22.805	1	< 0.1%

위치_종점
Real number (ℝ)

HIGH CORRELATION

Distinct	2686
Distinct (%)	78.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6724993

Minimum	0
Maximum	28.76
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6002
Q1	2.508
median	5.08
Q3	8.265
95-th percentile	12.618
Maximum	28.76
Range	28.76
Interquartile range (IQR)	5.757

Descriptive statistics

Standard deviation	3.9244685
Coefficient of variation (CV)	0.69184117
Kurtosis	1.8165197
Mean	5.6724993
Median Absolute Deviation (MAD)	2.831
Skewness	0.9853087
Sum	19428.31
Variance	15.401453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.0	8	0.2%
2.5	7	0.2%
3.64	6	0.2%
4.93	6	0.2%
4.0	5	0.1%
8.54	5	0.1%
3.5	5	0.1%
4.1	5	0.1%
4.32	5	0.1%
1.08	5	0.1%
Other values (2676)	3368	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	< 0.1%
0.014	1	< 0.1%
0.027	1	< 0.1%
0.06	1	< 0.1%
0.069	1	< 0.1%
0.07	1	< 0.1%
0.079	1	< 0.1%
0.08	1	< 0.1%
0.085	1	< 0.1%
0.088	1	< 0.1%

Value	Count	Frequency (%)
28.76	1	< 0.1%
28.725	1	< 0.1%
27.565	1	< 0.1%
25.2	1	< 0.1%
25.14	1	< 0.1%
24.392	2	0.1%
24.391	1	< 0.1%
23.809	1	< 0.1%
23.61	1	< 0.1%
23.426	1	< 0.1%

위치_방향
Categorical

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

1	1736
0	1687
2	2

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	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	1736	50.7%
0	1687	49.3%
2	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1736	50.7%
0	1687	49.3%
2	2	0.1%

종류
Real number (ℝ)

Distinct	12
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3635.8642

Minimum	3600
Maximum	3699
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	3600
5-th percentile	3601
Q1	3606
median	3606
Q3	3699
95-th percentile	3699
Maximum	3699
Range	99
Interquartile range (IQR)	93

Descriptive statistics

Standard deviation	43.685306
Coefficient of variation (CV)	0.012015109
Kurtosis	-1.4310557
Mean	3635.8642
Median Absolute Deviation (MAD)	3
Skewness	0.74903922
Sum	12452835
Variance	1908.4059
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3606	1641	47.9%
3699	1106	32.3%
3601	242	7.1%
3609	237	6.9%
3602	97	2.8%
3607	44	1.3%
3603	19	0.6%
3616	13	0.4%
3608	12	0.4%
3605	10	0.3%
Other values (2)	4	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3600	1	< 0.1%
3601	242	7.1%
3602	97	2.8%
3603	19	0.6%
3605	10	0.3%
3606	1641	47.9%
3607	44	1.3%
3608	12	0.4%
3609	237	6.9%
3616	13	0.4%

Value	Count	Frequency (%)
3699	1106	32.3%
3669	3	0.1%
3616	13	0.4%
3609	237	6.9%
3608	12	0.4%
3607	44	1.3%
3606	1641	47.9%
3605	10	0.3%
3603	19	0.6%
3602	97	2.8%

수량
Real number (ℝ)

SKEWED

Distinct	253
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.77781

Minimum	0
Maximum	8168
Zeros	22
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	30.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	10
median	21
Q3	45
95-th percentile	139
Maximum	8168
Range	8168
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	183.11453
Coefficient of variation (CV)	4.0000718
Kurtosis	1284.8375
Mean	45.77781
Median Absolute Deviation (MAD)	13
Skewness	32.373763
Sum	156789
Variance	33530.93
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	123	3.6%
9	116	3.4%
6	106	3.1%
8	102	3.0%
5	101	2.9%
14	99	2.9%
11	98	2.9%
13	98	2.9%
15	97	2.8%
12	95	2.8%
Other values (243)	2390	69.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	0.6%
1	19	0.6%
2	40	1.2%
3	63	1.8%
4	90	2.6%
5	101	2.9%
6	106	3.1%
7	91	2.7%
8	102	3.0%
9	116	3.4%

Value	Count	Frequency (%)
8168	1	< 0.1%
4750	1	< 0.1%
3190	1	< 0.1%
1629	1	< 0.1%
966	1	< 0.1%
827	1	< 0.1%
785	1	< 0.1%
760	1	< 0.1%
757	1	< 0.1%
702	2	0.1%

설치일자
Date

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	26.9 KiB

Minimum	1900-01-01 00:00:00
Maximum	2016-03-31 00:00:00

Histogram

Histogram with fixed size bins (bins=8)

사진
Text

MISSING

Distinct	2944
Distinct (%)	99.3%
Missing	459
Missing (%)	13.4%
Memory size	26.9 KiB

Length

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

Characters and Unicode

Total characters	38558
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	2925 ?
Unique (%)	98.6%

Sample

1st row	006701R00634D
2nd row	006701R00369U
3rd row	006701R01367D
4th row	006701R01559U
5th row	006701R01361U

Value	Count	Frequency (%)
108409r06195u	3	0.1%
108409r00306u	3	0.1%
108401r04782d	3	0.1%
108404r12360d	2	0.1%
108401r04651d	2	0.1%
108401r04980d	2	0.1%
109902r03285d	2	0.1%
109902r02785u	2	0.1%
102004r00072d	2	0.1%
108404r08869d	2	0.1%
Other values (2934)	2943	99.2%

Most occurring characters

Value	Count	Frequency (%)
0	12223	31.7%
1	6008	15.6%
R	2717	7.0%
3	2225	5.8%
4	2019	5.2%
2	1915	5.0%
5	1754	4.5%
8	1693	4.4%
9	1622	4.2%
7	1606	4.2%
Other values (4)	4776	12.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	32626	84.6%
Uppercase Letter	5932	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12223	37.5%
1	6008	18.4%
3	2225	6.8%
4	2019	6.2%
2	1915	5.9%
5	1754	5.4%
8	1693	5.2%
9	1622	5.0%
7	1606	4.9%
6	1561	4.8%

Uppercase Letter

Value	Count	Frequency (%)
R	2717	45.8%
D	1502	25.3%
U	1464	24.7%
S	249	4.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	32626	84.6%
Latin	5932	15.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12223	37.5%
1	6008	18.4%
3	2225	6.8%
4	2019	6.2%
2	1915	5.9%
5	1754	5.4%
8	1693	5.2%
9	1622	5.0%
7	1606	4.9%
6	1561	4.8%

Latin

Value	Count	Frequency (%)
R	2717	45.8%
D	1502	25.3%
U	1464	24.7%
S	249	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38558	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12223	31.7%
1	6008	15.6%
R	2717	7.0%
3	2225	5.8%
4	2019	5.2%
2	1915	5.0%
5	1754	4.5%
8	1693	4.4%
9	1622	4.2%
7	1606	4.2%
Other values (4)	4776	12.4%

비고
Text

MISSING

Distinct	113
Distinct (%)	10.8%
Missing	2382
Missing (%)	69.5%
Memory size	26.9 KiB

Length

Max length	25
Median length	20
Mean length	4.346117
Min length	2

Characters and Unicode

Total characters	4533
Distinct characters	110
Distinct categories	9 ?
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	66 ?
Unique (%)	6.3%

Sample

1st row	소나무
2nd row	소나무
3rd row	소나무
4th row	소나무
5th row	소나무

Value	Count	Frequency (%)
동백나무	215	19.4%
소나무	145	13.1%
무궁화	127	11.4%
벗나무	85	7.7%
이팝나무	81	7.3%
기타	72	6.5%
단풍나무	62	5.6%
해송	32	2.9%
백일홍	30	2.7%
이팝나무(물푸레나무과	20	1.8%
Other values (101)	242	21.8%

Most occurring characters

Value	Count	Frequency (%)
무	964	21.3%
나	838	18.5%
백	263	5.8%
동	232	5.1%
소	172	3.8%
궁	129	2.8%
화	129	2.8%
벗	112	2.5%
팝	105	2.3%
타	102	2.3%
Other values (100)	1487	32.8%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	3993	88.1%
Decimal Number	154	3.4%
Other Punctuation	107	2.4%
Uppercase Letter	96	2.1%
Space Separator	68	1.5%
Open Punctuation	48	1.1%
Close Punctuation	48	1.1%
Math Symbol	13	0.3%
Lowercase Letter	6	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
무	964	24.1%
나	838	21.0%
백	263	6.6%
동	232	5.8%
소	172	4.3%
궁	129	3.2%
화	129	3.2%
벗	112	2.8%
팝	105	2.6%
타	102	2.6%
Other values (78)	947	23.7%

Decimal Number

Value	Count	Frequency (%)
1	33	21.4%
2	25	16.2%
5	25	16.2%
3	22	14.3%
6	14	9.1%
4	8	5.2%
7	7	4.5%
9	7	4.5%
8	7	4.5%
0	6	3.9%

Uppercase Letter

Value	Count	Frequency (%)
E	36	37.5%
A	36	37.5%
U	12	12.5%
C	12	12.5%

Other Punctuation

Value	Count	Frequency (%)
,	95	88.8%
\	12	11.2%

Lowercase Letter

Value	Count	Frequency (%)
a	3	50.0%
e	3	50.0%

Space Separator

Value	Count	Frequency (%)
	68	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	48	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	48	100.0%

Math Symbol

Value	Count	Frequency (%)
+	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	3993	88.1%
Common	438	9.7%
Latin	102	2.3%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
무	964	24.1%
나	838	21.0%
백	263	6.6%
동	232	5.8%
소	172	4.3%
궁	129	3.2%
화	129	3.2%
벗	112	2.8%
팝	105	2.6%
타	102	2.6%
Other values (78)	947	23.7%

Common

Value	Count	Frequency (%)
,	95	21.7%
	68	15.5%
(	48	11.0%
)	48	11.0%
1	33	7.5%
2	25	5.7%
5	25	5.7%
3	22	5.0%
6	14	3.2%
+	13	3.0%
Other values (6)	47	10.7%

Latin

Value	Count	Frequency (%)
E	36	35.3%
A	36	35.3%
U	12	11.8%
C	12	11.8%
a	3	2.9%
e	3	2.9%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	3993	88.1%
ASCII	540	11.9%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
무	964	24.1%
나	838	21.0%
백	263	6.6%
동	232	5.8%
소	172	4.3%
궁	129	3.2%
화	129	3.2%
벗	112	2.8%
팝	105	2.6%
타	102	2.6%
Other values (78)	947	23.7%

ASCII

Value	Count	Frequency (%)
,	95	17.6%
	68	12.6%
(	48	8.9%
)	48	8.9%
E	36	6.7%
A	36	6.7%
1	33	6.1%
2	25	4.6%
5	25	4.6%
3	22	4.1%
Other values (12)	104	19.3%

Heatmap
Table

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	이력코드	위치_시점	위치_종점	위치_방향	종류	수량	설치일자
식별번호	1.000	0.636	0.508	0.916	0.690	0.637	0.189	0.369	0.368	0.065	0.371	0.045	0.291
관리번호	0.636	1.000	0.034	0.563	0.997	0.245	0.000	0.100	0.095	0.000	0.013	0.056	0.228
관리기관	0.508	0.034	1.000	0.067	0.028	0.156	0.000	0.580	0.597	0.000	0.000	0.000	0.000
도로종류	0.916	0.563	0.067	1.000	0.724	0.210	0.000	0.112	0.102	0.000	0.000	0.000	0.031
노선번호	0.690	0.997	0.028	0.724	1.000	0.281	0.000	0.093	0.084	0.012	0.018	0.071	0.253
구간번호	0.637	0.245	0.156	0.210	0.281	1.000	0.083	0.304	0.295	0.000	0.194	0.059	0.663
이력코드	0.189	0.000	0.000	0.000	0.000	0.083	1.000	0.023	0.037	0.000	0.000	0.000	1.000
위치_시점	0.369	0.100	0.580	0.112	0.093	0.304	0.023	1.000	0.998	0.000	0.096	0.000	0.017
위치_종점	0.368	0.095	0.597	0.102	0.084	0.295	0.037	0.998	1.000	0.000	0.098	0.000	0.031
위치_방향	0.065	0.000	0.000	0.000	0.012	0.000	0.000	0.000	0.000	1.000	0.026	0.000	0.026
종류	0.371	0.013	0.000	0.000	0.018	0.194	0.000	0.096	0.098	0.026	1.000	0.000	0.801
수량	0.045	0.056	0.000	0.000	0.071	0.059	0.000	0.000	0.000	0.000	0.000	1.000	0.451
설치일자	0.291	0.228	0.000	0.031	0.253	0.663	1.000	0.017	0.031	0.026	0.801	0.451	1.000

Heatmap
Table

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

Heatmap
Table

	식별번호	관리번호	노선번호	구간번호	위치_시점	위치_종점	종류	수량	관리기관	도로종류	이력코드	위치_방향
식별번호	1.000	0.487	0.594	0.042	-0.021	-0.008	0.144	0.103	0.391	0.757	0.145	0.038
관리번호	0.487	1.000	0.846	0.006	0.053	0.064	-0.003	0.050	0.056	0.832	0.000	0.000
노선번호	0.594	0.846	1.000	-0.130	0.044	0.052	-0.042	0.007	0.047	0.962	0.000	0.004
구간번호	0.042	0.006	-0.130	1.000	0.038	0.037	0.109	-0.046	0.120	0.162	0.063	0.000
위치_시점	-0.021	0.053	0.044	0.038	1.000	0.989	-0.038	-0.045	0.447	0.086	0.018	0.000
위치_종점	-0.008	0.064	0.052	0.037	0.989	1.000	-0.045	0.030	0.461	0.078	0.028	0.000
종류	0.144	-0.003	-0.042	0.109	-0.038	-0.045	1.000	0.092	0.000	0.000	0.000	0.024
수량	0.103	0.050	0.007	-0.046	-0.045	0.030	0.092	1.000	0.000	0.000	0.000	0.000
관리기관	0.391	0.056	0.047	0.120	0.447	0.461	0.000	0.000	1.000	0.043	0.000	0.000
도로종류	0.757	0.832	0.962	0.162	0.086	0.078	0.000	0.000	0.043	1.000	0.000	0.000
이력코드	0.145	0.000	0.000	0.063	0.018	0.028	0.000	0.000	0.000	0.000	1.000	0.000
위치_방향	0.038	0.000	0.004	0.000	0.000	0.000	0.024	0.000	0.000	0.000	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	670004	1683	1507	67	1	0.634	0.834	1	3606	25	1900-01-01	006701R00634D	<NA>
1	2	670003	1683	1507	67	1	0.369	0.833	0	3606	58	1900-01-01	006701R00369U	<NA>
2	3	670009	1683	1507	67	1	1.367	1.483	1	3606	11	1900-01-01	006701R01367D	<NA>
3	4	670010	1683	1507	67	1	1.559	1.585	0	3606	3	1900-01-01	006701R01559U	<NA>
4	5	670008	1683	1507	67	1	1.361	1.487	0	3606	11	1900-01-01	006701R01361U	<NA>
5	6	670007	1683	1507	67	1	1.063	1.253	0	3606	19	1900-01-01	006701R01063U	<NA>
6	7	670005	1683	1507	67	1	0.843	1.347	1	3606	50	1900-01-01	006701R00843D	<NA>
7	8	670006	1683	1507	67	1	0.848	1.051	0	3606	21	1900-01-01	006701R00848U	<NA>
8	9	670002	1683	1507	67	1	0.16	0.308	0	3606	19	1900-01-01	006701R00160U	<NA>
9	10	670001	1683	1507	67	1	0.0	0.582	1	3606	68	1900-01-01	006701R00000D	<NA>

	식별번호	관리번호	관리기관	도로종류	노선번호	구간번호	위치_시점	위치_종점	위치_방향	종류	수량	설치일자	사진	비고
3415	3155	10890021	1683	1504	1089	3	5.37	5.42	0	3601	12	1900-01-01	108903R05370U	<NA>
3416	3156	10890024	1683	1504	1089	3	6.215	6.72	1	3601	44	1900-01-01	108903R06215D	<NA>
3417	3157	10890025	1683	1504	1089	3	6.342	6.52	0	3601	15	1900-01-01	108903R06342U	<NA>
3418	3158	10890026	1683	1504	1089	3	6.692	6.778	0	3601	7	1900-01-01	108903R06692U	<NA>
3419	3159	10890027	1683	1504	1089	3	6.797	6.875	1	3601	9	1900-01-01	<NA>	<NA>
3420	3160	10890028	1683	1504	1089	3	7.86	8.18	1	3601	28	1900-01-01	108903R07860D	<NA>
3421	3161	10890029	1683	1504	1089	3	8.196	8.272	0	3606	11	1900-01-01	<NA>	<NA>
3422	3162	10890031	1683	1504	1089	3	8.534	8.878	0	3606	28	1900-01-01	108903R08534U	<NA>
3423	3163	10890030	1683	1504	1089	3	8.34	8.52	1	3601	21	1900-01-01	<NA>	<NA>
3424	3164	10890015	1683	1504	1089	3	3.852	4.172	1	3601	41	1900-01-01	108903R03852D	벗나무11개

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

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

Lowercase Letter

Space Separator

Open Punctuation

Close Punctuation

Math Symbol

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