gimi9 Pandas Profiling

Dataset statistics

Number of variables	20
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	40
Duplicate rows (%)	0.4%
Total size in memory	1.6 MiB
Average record size in memory	173.0 B

Variable types

Categorical	9
Numeric	5
Text	6

Dataset

Description	경기도 화성시_교통표지판에 대한 데이터로, 지형지물부호, 관리번호, 행정읍면동, 도엽번호, 관리기관, 설치일자, 위치구분, 표지판구분, 지주형식, 높이, 규격, 대장초기화여부, 비고, 도로구간번호, 공사번호, 납품업체, 로딩일자, X좌표, Y좌표 등의 항목을 제공합니다.
Author	경기도 화성시
URL	https://www.data.go.kr/data/15093492/fileData.do

Alerts

Dataset has 40 (0.4%) duplicate rows	Duplicates
`대장초기화여부` is highly overall correlated with `관리기관`	High correlation
`관리기관` is highly overall correlated with `X좌표` and 4 other fields	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
`X좌표` is highly overall correlated with `행정읍면동` and 1 other fields	High correlation
`Y좌표` is highly overall correlated with `행정읍면동` and 1 other fields	High correlation
`행정읍면동` is highly overall correlated with `X좌표` and 2 other fields	High correlation
`납품업체` is highly overall correlated with `관리번호` and 1 other fields	High correlation
`지형지물부호` is highly imbalanced (99.9%)	Imbalance
`관리기관` is highly imbalanced (81.8%)	Imbalance
`대장초기화여부` is highly imbalanced (96.2%)	Imbalance
`공사번호` is highly imbalanced (99.4%)	Imbalance
`납품업체` is highly imbalanced (53.4%)	Imbalance
`높이` has 4003 (40.0%) zeros	Zeros
`도로구간번호` has 152 (1.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 18:12:54.090167
Analysis finished	2023-12-12 18:13:00.986178
Duration	6.9 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

지형지물부호
Categorical

IMBALANCE

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

교통표지판	9999
신호등	1

Length

Max length	5
Median length	5
Mean length	4.9998
Min length	3

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	교통표지판
2nd row	교통표지판
3rd row	교통표지판
4th row	교통표지판
5th row	교통표지판

Common Values

Value	Count	Frequency (%)
교통표지판	9999	> 99.9%
신호등	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
교통표지판	9999	> 99.9%
신호등	1	< 0.1%

관리번호
Real number (ℝ)

HIGH CORRELATION

Distinct	4135
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1567576 × 10¹³

Minimum	100001
Maximum	8.99919 × 10¹³
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	100001
5-th percentile	200057.95
Q1	9.992015 × 10¹⁰
median	2.15304 × 10¹¹
Q3	2.2162 × 10¹³
95-th percentile	8.99919 × 10¹³
Maximum	8.99919 × 10¹³
Range	8.99919 × 10¹³
Interquartile range (IQR)	2.206208 × 10¹³

Descriptive statistics

Standard deviation	3.5720234 × 10¹³
Coefficient of variation (CV)	1.6562007
Kurtosis	-0.39748157
Mean	2.1567576 × 10¹³
Median Absolute Deviation (MAD)	2.153039 × 10¹¹
Skewness	1.2270745
Sum	2.1567576 × 10¹⁷
Variance	1.2759351 × 10²⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89991900000000	799	8.0%
888615000000	514	5.1%
89991600000000	415	4.2%
999161000000	229	2.3%
82111800000000	215	2.1%
82162000000000	213	2.1%
511308000000	196	2.0%
215304000000	193	1.9%
82161800000000	186	1.9%
82161900000000	160	1.6%
Other values (4125)	6880	68.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100001	1	< 0.1%
100002	1	< 0.1%
100003	1	< 0.1%
100006	1	< 0.1%
100007	1	< 0.1%
100008	1	< 0.1%
100009	1	< 0.1%
100015	1	< 0.1%
100017	1	< 0.1%
100019	1	< 0.1%

Value	Count	Frequency (%)
89991900000000	799	8.0%
89991600000000	415	4.2%
82992100000000	5	0.1%
82992000000000	132	1.3%
82991700000000	4	< 0.1%
82162000000000	213	2.1%
82161900000000	160	1.6%
82161800000000	186	1.9%
82112000000000	135	1.4%
82111900000000	5	0.1%

행정읍면동
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

<NA>	2116
향남읍	1230
남양읍	733
봉담읍	536
동탄6동	515
Other values (20)	4870

Length

Max length	4
Median length	3
Mean length	3.3743
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	<NA>
2nd row	<NA>
3rd row	양감면
4th row	향남읍
5th row	<NA>

Common Values

Value	Count	Frequency (%)
<NA>	2116	21.2%
향남읍	1230	12.3%
남양읍	733	7.3%
봉담읍	536	5.4%
동탄6동	515	5.1%
서신면	457	4.6%
마도면	416	4.2%
정남면	404	4.0%
송산면	358	3.6%
동탄1동	333	3.3%
Other values (15)	2902	29.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	2116	21.2%
향남읍	1230	12.3%
남양읍	733	7.3%
봉담읍	536	5.4%
동탄6동	515	5.1%
서신면	457	4.6%
마도면	416	4.2%
정남면	404	4.0%
송산면	358	3.6%
동탄1동	333	3.3%
Other values (15)	2902	29.0%

도엽번호
Text

Distinct	2469
Distinct (%)	24.7%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	100000
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	783 ?
Unique (%)	7.8%

Sample

1st row	377130855D
2nd row	377130873A
3rd row	376162015C
4th row	376161810B
5th row	377130832B

Value	Count	Frequency (%)
376161471c	31	0.3%
376160284b	31	0.3%
377130261a	29	0.3%
376160287b	29	0.3%
376160286a	29	0.3%
376122234b	27	0.3%
377130739d	27	0.3%
376161475a	24	0.2%
376160653b	24	0.2%
376160285c	24	0.2%
Other values (2459)	9725	97.2%

Most occurring characters

Value	Count	Frequency (%)
7	17091	17.1%
3	16171	16.2%
1	15363	15.4%
6	14058	14.1%
0	8497	8.5%
2	5946	5.9%
5	3829	3.8%
8	3333	3.3%
4	3259	3.3%
C	2679	2.7%
Other values (4)	9774	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	90000	90.0%
Uppercase Letter	10000	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	17091	19.0%
3	16171	18.0%
1	15363	17.1%
6	14058	15.6%
0	8497	9.4%
2	5946	6.6%
5	3829	4.3%
8	3333	3.7%
4	3259	3.6%
9	2453	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	2679	26.8%
D	2548	25.5%
B	2429	24.3%
A	2344	23.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	90000	90.0%
Latin	10000	10.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	17091	19.0%
3	16171	18.0%
1	15363	17.1%
6	14058	15.6%
0	8497	9.4%
2	5946	6.6%
5	3829	4.3%
8	3333	3.7%
4	3259	3.6%
9	2453	2.7%

Latin

Value	Count	Frequency (%)
C	2679	26.8%
D	2548	25.5%
B	2429	24.3%
A	2344	23.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	100000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	17091	17.1%
3	16171	16.2%
1	15363	15.4%
6	14058	14.1%
0	8497	8.5%
2	5946	5.9%
5	3829	3.8%
8	3333	3.3%
4	3259	3.3%
C	2679	2.7%
Other values (4)	9774	9.8%

관리기관
Categorical

HIGH CORRELATION IMBALANCE

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

<NA>	9235
도로과	715
화성시	26
교통건설과	20
해양수산과	4

Length

Max length	5
Median length	4
Mean length	3.9283
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	9235	92.3%
도로과	715	7.1%
화성시	26	0.3%
교통건설과	20	0.2%
해양수산과	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	9235	92.3%
도로과	715	7.1%
화성시	26	0.3%
교통건설과	20	0.2%
해양수산과	4	< 0.1%

설치일자
Text

Distinct	78
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	10
Median length	10
Mean length	9.5923
Min length	1

Characters and Unicode

Total characters	95923
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Value	Count	Frequency (%)
1990-01-01	1602	16.8%
2016-01-01	1282	13.4%
1900-01-01	1189	12.5%
2014-01-01	743	7.8%
2006-10-01	514	5.4%
2017-01-01	458	4.8%
2017-12-01	375	3.9%
2018-01-01	312	3.3%
2020-01-01	282	3.0%
2015-01-01	242	2.5%
Other values (67)	2548	26.7%

Most occurring characters

Value	Count	Frequency (%)
0	29592	30.8%
1	26018	27.1%
-	19094	19.9%
2	8857	9.2%
9	5000	5.2%
6	2647	2.8%
7	1468	1.5%
4	1153	1.2%
3	634	0.7%
8	586	0.6%
Other values (2)	874	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76376	79.6%
Dash Punctuation	19094	19.9%
Space Separator	453	0.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	29592	38.7%
1	26018	34.1%
2	8857	11.6%
9	5000	6.5%
6	2647	3.5%
7	1468	1.9%
4	1153	1.5%
3	634	0.8%
8	586	0.8%
5	421	0.6%

Dash Punctuation

Value	Count	Frequency (%)
-	19094	100.0%

Space Separator

Value	Count	Frequency (%)
	453	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	95923	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	29592	30.8%
1	26018	27.1%
-	19094	19.9%
2	8857	9.2%
9	5000	5.2%
6	2647	2.8%
7	1468	1.5%
4	1153	1.2%
3	634	0.7%
8	586	0.6%
Other values (2)	874	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	95923	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	29592	30.8%
1	26018	27.1%
-	19094	19.9%
2	8857	9.2%
9	5000	5.2%
6	2647	2.8%
7	1468	1.5%
4	1153	1.2%
3	634	0.7%
8	586	0.6%
Other values (2)	874	0.9%

위치구분
Categorical

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

우	4012
좌	3976
미분류	1604
중앙	333
기타	65

Length

Max length	8
Median length	1
Mean length	1.3676
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
우	4012	40.1%
좌	3976	39.8%
미분류	1604	16.0%
중앙	333	3.3%
기타	65	0.7%
교통안전(기타)	10	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
우	4012	40.1%
좌	3976	39.8%
미분류	1604	16.0%
중앙	333	3.3%
기타	65	0.7%
교통안전(기타	10	0.1%

표지판구분
Categorical

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

교통안전(규제)	2982
교통안전(지시)	2929
교통안전(주의)	2372
교통안전(보조)	905
교통안전(기타)	410
Other values (2)	402

Length

Max length	8
Median length	8
Mean length	7.836
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	교통안전(지시)
2nd row	교통안전(지시)
3rd row	교통안전(주의)
4th row	교통안전(보조)
5th row	교통안전(지시)

Common Values

Value	Count	Frequency (%)
교통안전(규제)	2982	29.8%
교통안전(지시)	2929	29.3%
교통안전(주의)	2372	23.7%
교통안전(보조)	905	9.0%
교통안전(기타)	410	4.1%
<NA>	386	3.9%
기타	16	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
교통안전(규제	2982	29.8%
교통안전(지시	2929	29.3%
교통안전(주의	2372	23.7%
교통안전(보조	905	9.0%
교통안전(기타	410	4.1%
na	386	3.9%
기타	16	0.2%

지주형식
Categorical

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

단주식	3794
견착식	3471
미분류	1602
<NA>	411
기타	303
Other values (5)	419

Length

Max length	4
Median length	3
Mean length	3.0108
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	견착식
2nd row	단주식
3rd row	단주식
4th row	<NA>
5th row	견착식

Common Values

Value	Count	Frequency (%)
단주식	3794	37.9%
견착식	3471	34.7%
미분류	1602	16.0%
<NA>	411	4.1%
기타	303	3.0%
편지식	278	2.8%
측주식	113	1.1%
복주식	20	0.2%
현수식	6	0.1%
문형식	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
단주식	3794	37.9%
견착식	3471	34.7%
미분류	1602	16.0%
na	411	4.1%
기타	303	3.0%
편지식	278	2.8%
측주식	113	1.1%
복주식	20	0.2%
현수식	6	0.1%
문형식	2	< 0.1%

높이
Real number (ℝ)

ZEROS

Distinct	120
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.940393

Minimum	0
Maximum	36
Zeros	4003
Zeros (%)	40.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2.2
Q3	2.8
95-th percentile	5.5
Maximum	36
Range	36
Interquartile range (IQR)	2.8

Descriptive statistics

Standard deviation	1.9325668
Coefficient of variation (CV)	0.9959667
Kurtosis	9.4664366
Mean	1.940393
Median Absolute Deviation (MAD)	2.2
Skewness	1.2087726
Sum	19403.93
Variance	3.7348145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	4003	40.0%
2.5	1041	10.4%
5.0	493	4.9%
2.7	405	4.0%
2.8	365	3.6%
3.0	315	3.1%
2.3	298	3.0%
2.1	280	2.8%
6.0	252	2.5%
2.0	238	2.4%
Other values (110)	2310	23.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	4003	40.0%
0.4	1	< 0.1%
0.5	1	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	6	0.1%
1.0	5	0.1%
1.1	7	0.1%
1.2	11	0.1%
1.3	11	0.1%

Value	Count	Frequency (%)
36.0	1	< 0.1%
10.0	18	0.2%
9.0	1	< 0.1%
8.5	1	< 0.1%
8.0	6	0.1%
7.7	3	< 0.1%
7.6	4	< 0.1%
7.5	11	0.1%
7.1	1	< 0.1%
7.0	55	0.5%

규격
Text

Distinct	440
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	27
Median length	19
Mean length	6.3722
Min length	1

Characters and Unicode

Total characters	63722
Distinct characters	71
Distinct categories	13 ?
Distinct scripts	4 ?
Distinct blocks	4 ?

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

Unique

Unique	161 ?
Unique (%)	1.6%

Sample

1st row	오각0.8X0.3X0.8
2nd row	오각0.8X0.3X0.8
3rd row	0.6
4th row	□600X600
5th row	¨ª600

Value	Count	Frequency (%)
¨ª600	1023	11.1%
¨ª900	542	5.9%
900	391	4.2%
600	389	4.2%
오각0.6x0.2x0.6	345	3.7%
원형ø600	345	3.7%
원형	345	3.7%
0.6	224	2.4%
오각	200	2.2%
φ600	199	2.2%
Other values (376)	5204	56.5%

Most occurring characters

Value	Count	Frequency (%)
0	18550	29.1%
.	7710	12.1%
6	5918	9.3%
X	3959	6.2%
9	3762	5.9%
	2927	4.6%
각	2720	4.3%
2	2060	3.2%
형	1954	3.1%
ª	1654	2.6%
Other values (61)	12508	19.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	33126	52.0%
Other Letter	10401	16.3%
Other Punctuation	8436	13.2%
Uppercase Letter	4895	7.7%
Space Separator	2927	4.6%
Modifier Symbol	1654	2.6%
Lowercase Letter	1259	2.0%
Other Symbol	745	1.2%
Math Symbol	251	0.4%
Open Punctuation	12	< 0.1%
Other values (3)	16	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
각	2720	26.2%
형	1954	18.8%
ª	1654	15.9%
오	1050	10.1%
삼	933	9.0%
원	874	8.4%
사	779	7.5%
변	161	1.5%
역	141	1.4%
규	21	0.2%
Other values (22)	114	1.1%

Decimal Number

Value	Count	Frequency (%)
0	18550	56.0%
6	5918	17.9%
9	3762	11.4%
2	2060	6.2%
1	1211	3.7%
8	616	1.9%
3	339	1.0%
7	258	0.8%
5	226	0.7%
4	186	0.6%

Uppercase Letter

Value	Count	Frequency (%)
X	3959	80.9%
Ø	454	9.3%
Φ	248	5.1%
Χ	82	1.7%
A	76	1.6%
E	76	1.6%

Other Punctuation

Value	Count	Frequency (%)
.	7710	91.4%
:	334	4.0%
,	183	2.2%
*	173	2.1%
/	36	0.4%

Lowercase Letter

Value	Count	Frequency (%)
x	993	78.9%
a	75	6.0%
e	75	6.0%
m	74	5.9%
ø	42	3.3%

Other Symbol

Value	Count	Frequency (%)
△	403	54.1%
□	157	21.1%
▽	115	15.4%
◇	35	4.7%
○	35	4.7%

Math Symbol

Value	Count	Frequency (%)
×	242	96.4%
+	9	3.6%

Space Separator

Value	Count	Frequency (%)
	2927	100.0%

Modifier Symbol

Value	Count	Frequency (%)
¨	1654	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	12	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	12	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	47167	74.0%
Hangul	8747	13.7%
Latin	7478	11.7%
Greek	330	0.5%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
각	2720	31.1%
형	1954	22.3%
오	1050	12.0%
삼	933	10.7%
원	874	10.0%
사	779	8.9%
변	161	1.8%
역	141	1.6%
규	21	0.2%
격	21	0.2%
Other values (21)	93	1.1%

Common

Value	Count	Frequency (%)
0	18550	39.3%
.	7710	16.3%
6	5918	12.5%
9	3762	8.0%
	2927	6.2%
2	2060	4.4%
¨	1654	3.5%
1	1211	2.6%
8	616	1.3%
△	403	0.9%
Other values (18)	2356	5.0%

Latin

Value	Count	Frequency (%)
X	3959	52.9%
ª	1654	22.1%
x	993	13.3%
Ø	454	6.1%
A	76	1.0%
E	76	1.0%
a	75	1.0%
e	75	1.0%
m	74	1.0%
ø	42	0.6%

Greek

Value	Count	Frequency (%)
Φ	248	75.2%
Χ	82	24.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49854	78.2%
Hangul	8747	13.7%
None	4376	6.9%
Geometric Shapes	745	1.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	18550	37.2%
.	7710	15.5%
6	5918	11.9%
X	3959	7.9%
9	3762	7.5%
	2927	5.9%
2	2060	4.1%
1	1211	2.4%
x	993	2.0%
8	616	1.2%
Other values (18)	2148	4.3%

Hangul

Value	Count	Frequency (%)
각	2720	31.1%
형	1954	22.3%
오	1050	12.0%
삼	933	10.7%
원	874	10.0%
사	779	8.9%
변	161	1.8%
역	141	1.6%
규	21	0.2%
격	21	0.2%
Other values (21)	93	1.1%

None

Value	Count	Frequency (%)
ª	1654	37.8%
¨	1654	37.8%
Ø	454	10.4%
Φ	248	5.7%
×	242	5.5%
Χ	82	1.9%
ø	42	1.0%

Geometric Shapes

Value	Count	Frequency (%)
△	403	54.1%
□	157	21.1%
▽	115	15.4%
◇	35	4.7%
○	35	4.7%

기재사항
Text

Distinct	666
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	39
Median length	30
Mean length	5.0642
Min length	1

Characters and Unicode

Total characters	50642
Distinct characters	300
Distinct categories	12 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

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

Unique

Unique	363 ?
Unique (%)	3.6%

Sample

1st row	횡단보도
2nd row	횡단보도
3rd row	과속방지턱
4th row	견인지역
5th row	자전거전용도로

Value	Count	Frequency (%)
횡단보도	1510	17.7%
주정차금지	513	6.0%
과속방지턱	473	5.6%
견인지역	468	5.5%
최고속도제한	373	4.4%
양보	244	2.9%
정차주차금지	184	2.2%
주정차금지,견인지역표시	157	1.8%
자전거및보행자겸용도로	153	1.8%
어린이보호구역	143	1.7%
Other values (637)	4304	50.5%

Most occurring characters

Value	Count	Frequency (%)
도	3517	6.9%
보	2772	5.5%
지	2420	4.8%
	2076	4.1%
단	1860	3.7%
횡	1767	3.5%
차	1659	3.3%
속	1616	3.2%
전	1521	3.0%
자	1454	2.9%
Other values (290)	29980	59.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	44912	88.7%
Space Separator	2076	4.1%
Decimal Number	1668	3.3%
Other Punctuation	717	1.4%
Uppercase Letter	466	0.9%
Lowercase Letter	279	0.6%
Open Punctuation	216	0.4%
Close Punctuation	216	0.4%
Math Symbol	54	0.1%
Connector Punctuation	23	< 0.1%
Other values (2)	15	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
도	3517	7.8%
보	2772	6.2%
지	2420	5.4%
단	1860	4.1%
횡	1767	3.9%
차	1659	3.7%
속	1616	3.6%
전	1521	3.4%
자	1454	3.2%
제	1300	2.9%
Other values (240)	25026	55.7%

Uppercase Letter

Value	Count	Frequency (%)
C	122	26.2%
M	91	19.5%
T	75	16.1%
V	49	10.5%
L	24	5.2%
P	24	5.2%
K	19	4.1%
A	16	3.4%
E	16	3.4%
N	15	3.2%
Other values (3)	15	3.2%

Lowercase Letter

Value	Count	Frequency (%)
m	138	49.5%
x	65	23.3%
k	63	22.6%
t	4	1.4%
c	2	0.7%
s	2	0.7%
v	1	0.4%
b	1	0.4%
u	1	0.4%
o	1	0.4%

Decimal Number

Value	Count	Frequency (%)
0	651	39.0%
3	238	14.3%
2	164	9.8%
6	155	9.3%
5	124	7.4%
4	96	5.8%
1	85	5.1%
7	83	5.0%
8	51	3.1%
9	21	1.3%

Other Punctuation

Value	Count	Frequency (%)
,	286	39.9%
/	264	36.8%
.	117	16.3%
%	20	2.8%
?	15	2.1%
#	15	2.1%

Other Symbol

Value	Count	Frequency (%)
┼	4	40.0%
├	3	30.0%
┤	2	20.0%
╋	1	10.0%

Space Separator

Value	Count	Frequency (%)
	2076	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	216	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	216	100.0%

Math Symbol

Value	Count	Frequency (%)
+	54	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	23	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	44912	88.7%
Common	4985	9.8%
Latin	745	1.5%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
도	3517	7.8%
보	2772	6.2%
지	2420	5.4%
단	1860	4.1%
횡	1767	3.9%
차	1659	3.7%
속	1616	3.6%
전	1521	3.4%
자	1454	3.2%
제	1300	2.9%
Other values (240)	25026	55.7%

Common

Value	Count	Frequency (%)
	2076	41.6%
0	651	13.1%
,	286	5.7%
/	264	5.3%
3	238	4.8%
(	216	4.3%
)	216	4.3%
2	164	3.3%
6	155	3.1%
5	124	2.5%
Other values (16)	595	11.9%

Latin

Value	Count	Frequency (%)
m	138	18.5%
C	122	16.4%
M	91	12.2%
T	75	10.1%
x	65	8.7%
k	63	8.5%
V	49	6.6%
L	24	3.2%
P	24	3.2%
K	19	2.6%
Other values (14)	75	10.1%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	44859	88.6%
ASCII	5720	11.3%
Compat Jamo	53	0.1%
Box Drawing	10	< 0.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
도	3517	7.8%
보	2772	6.2%
지	2420	5.4%
단	1860	4.1%
횡	1767	3.9%
차	1659	3.7%
속	1616	3.6%
전	1521	3.4%
자	1454	3.2%
제	1300	2.9%
Other values (237)	24973	55.7%

ASCII

Value	Count	Frequency (%)
	2076	36.3%
0	651	11.4%
,	286	5.0%
/	264	4.6%
3	238	4.2%
(	216	3.8%
)	216	3.8%
2	164	2.9%
6	155	2.7%
m	138	2.4%
Other values (36)	1316	23.0%

Compat Jamo

Value	Count	Frequency (%)
ㅏ	28	52.8%
ㅓ	21	39.6%
ㅜ	4	7.5%

Box Drawing

Value	Count	Frequency (%)
┼	4	40.0%
├	3	30.0%
┤	2	20.0%
╋	1	10.0%

대장초기화여부
Categorical

HIGH CORRELATION IMBALANCE

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

1	9959
	41

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	9959	99.6%
	41	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9959	100.0%

비고
Text

Distinct	189
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	66
Median length	56
Mean length	15.7023
Min length	1

Characters and Unicode

Total characters	157023
Distinct characters	220
Distinct categories	10 ?
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	37 ?
Unique (%)	0.4%

Sample

1st row	동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역
2nd row	동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역
3rd row
4th row	화성 향남 2지구 도로 및 지하시설물 DB 구축(20170831)
5th row

Value	Count	Frequency (%)
gis	2648	8.9%
db	2290	7.7%
및	2123	7.1%
도로	1973	6.6%
지하시설물	1621	5.4%
구축용역	1388	4.6%
화성	946	3.2%
구축	643	2.2%
향남	587	2.0%
구축(20170831	587	2.0%
Other values (322)	15093	50.5%

Most occurring characters

Value	Count	Frequency (%)
	29619	18.9%
구	5274	3.4%
지	4769	3.0%
로	4574	2.9%
도	4508	2.9%
축	4123	2.6%
2	3905	2.5%
설	3834	2.4%
사	3769	2.4%
I	3546	2.3%
Other values (210)	89102	56.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	90209	57.4%
Space Separator	29619	18.9%
Uppercase Letter	17456	11.1%
Decimal Number	12507	8.0%
Close Punctuation	2725	1.7%
Open Punctuation	2725	1.7%
Dash Punctuation	746	0.5%
Other Punctuation	598	0.4%
Math Symbol	319	0.2%
Connector Punctuation	119	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
구	5274	5.8%
지	4769	5.3%
로	4574	5.1%
도	4508	5.0%
축	4123	4.6%
설	3834	4.3%
사	3769	4.2%
시	3005	3.3%
역	2747	3.0%
용	2678	3.0%
Other values (179)	50928	56.5%

Decimal Number

Value	Count	Frequency (%)
2	3905	31.2%
1	2967	23.7%
0	2024	16.2%
7	1327	10.6%
3	947	7.6%
8	829	6.6%
9	236	1.9%
6	105	0.8%
5	92	0.7%
4	75	0.6%

Uppercase Letter

Value	Count	Frequency (%)
I	3546	20.3%
S	3505	20.1%
G	3505	20.1%
D	3421	19.6%
B	3421	19.6%
C	41	0.2%
H	10	0.1%
E	3	< 0.1%
A	3	< 0.1%
M	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	344	57.5%
,	245	41.0%
.	8	1.3%
*	1	0.2%

Math Symbol

Value	Count	Frequency (%)
+	265	83.1%
~	54	16.9%

Space Separator

Value	Count	Frequency (%)
	29619	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2725	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2725	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	746	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	119	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	90209	57.4%
Common	49358	31.4%
Latin	17456	11.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
구	5274	5.8%
지	4769	5.3%
로	4574	5.1%
도	4508	5.0%
축	4123	4.6%
설	3834	4.3%
사	3769	4.2%
시	3005	3.3%
역	2747	3.0%
용	2678	3.0%
Other values (179)	50928	56.5%

Common

Value	Count	Frequency (%)
	29619	60.0%
2	3905	7.9%
1	2967	6.0%
)	2725	5.5%
(	2725	5.5%
0	2024	4.1%
7	1327	2.7%
3	947	1.9%
8	829	1.7%
-	746	1.5%
Other values (11)	1544	3.1%

Latin

Value	Count	Frequency (%)
I	3546	20.3%
S	3505	20.1%
G	3505	20.1%
D	3421	19.6%
B	3421	19.6%
C	41	0.2%
H	10	0.1%
E	3	< 0.1%
A	3	< 0.1%
M	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	90209	57.4%
ASCII	66814	42.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	29619	44.3%
2	3905	5.8%
I	3546	5.3%
S	3505	5.2%
G	3505	5.2%
D	3421	5.1%
B	3421	5.1%
1	2967	4.4%
)	2725	4.1%
(	2725	4.1%
Other values (21)	7475	11.2%

Hangul

Value	Count	Frequency (%)
구	5274	5.8%
지	4769	5.3%
로	4574	5.1%
도	4508	5.0%
축	4123	4.6%
설	3834	4.3%
사	3769	4.2%
시	3005	3.3%
역	2747	3.0%
용	2678	3.0%
Other values (179)	50928	56.5%

도로구간번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2405
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1127753 × 10¹³

Minimum	0
Maximum	8.99919 × 10¹³
Zeros	152
Zeros (%)	1.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	6.1474069 × 10⁸
Q1	2.503394 × 10⁹
median	9.9916122 × 10¹⁰
Q3	2.21619 × 10¹³
95-th percentile	8.99919 × 10¹³
Maximum	8.99919 × 10¹³
Range	8.99919 × 10¹³
Interquartile range (IQR)	2.2159397 × 10¹³

Descriptive statistics

Standard deviation	3.5630329 × 10¹³
Coefficient of variation (CV)	1.686423
Kurtosis	-0.3468741
Mean	2.1127753 × 10¹³
Median Absolute Deviation (MAD)	9.7815803 × 10¹⁰
Skewness	1.246863
Sum	2.1127753 × 10¹⁷
Variance	1.2695204 × 10²⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89991900000000	776	7.8%
89991600000000	415	4.2%
82162000000000	213	2.1%
82111700000000	211	2.1%
82161900000000	172	1.7%
82161800000000	164	1.6%
0	152	1.5%
82112000000000	135	1.4%
82992000000000	131	1.3%
12111800000000	106	1.1%
Other values (2395)	7525	75.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	152	1.5%
307590001	1	< 0.1%
307600009	2	< 0.1%
307790017	2	< 0.1%
307790018	1	< 0.1%
613000579	1	< 0.1%
613000582	1	< 0.1%
613000587	2	< 0.1%
613000589	3	< 0.1%
613000595	1	< 0.1%

Value	Count	Frequency (%)
89991900000000	776	7.8%
89991600000000	415	4.2%
82992100000000	5	0.1%
82992000000000	131	1.3%
82991700000000	4	< 0.1%
82162000000000	213	2.1%
82161900000000	172	1.7%
82161800000000	164	1.6%
82112000000000	135	1.4%
82111900000000	5	0.1%

공사번호
Categorical

HIGH CORRELATION IMBALANCE

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

	9993
2010000189	5
1	2

Length

Max length	10
Median length	1
Mean length	1.0045
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
	9993	99.9%
2010000189	5	0.1%
1	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2010000189	5	71.4%
1	2	28.6%

납품업체
Categorical

HIGH CORRELATION IMBALANCE

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

	7000
새한항업	636
(주)한라지리정보	453
㈜진성이엔씨	394
(주)지아이에스21	355
Other values (11)	1162

Length

Max length	10
Median length	1
Mean length	2.8027
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row	새한항업

Common Values

Value	Count	Frequency (%)
	7000	70.0%
새한항업	636	6.4%
(주)한라지리정보	453	4.5%
㈜진성이엔씨	394	3.9%
(주)지아이에스21	355	3.5%
㈜한양지에스티	323	3.2%
(주)성원공간정보	229	2.3%
(주)진성이엔씨	155	1.6%
제일항업(주)	132	1.3%
지오스	97	1.0%
Other values (6)	226	2.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
새한항업	636	21.2%
주)한라지리정보	453	15.1%
㈜진성이엔씨	394	13.1%
주)지아이에스21	355	11.8%
㈜한양지에스티	323	10.8%
주)성원공간정보	229	7.6%
주)진성이엔씨	155	5.2%
제일항업(주	132	4.4%
지오스	97	3.2%
주)우주공간정보	94	3.1%
Other values (5)	132	4.4%

로딩일자
Text

Distinct	77
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	10
Median length	1
Mean length	5.0779
Min length	1

Characters and Unicode

Total characters	50779
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	2019-12-04
2nd row	2019-12-04
3rd row
4th row	2017-08-31
5th row	2019-01-05

Value	Count	Frequency (%)
2017-08-31	587	13.0%
2021-04-16	490	10.8%
2019-12-04	453	10.0%
2020-05-20	443	9.8%
2019-01-05	415	9.2%
2021-03-23	355	7.8%
2019-04-05	221	4.9%
2017-12-07	161	3.6%
2020-10-21	133	2.9%
2017-12-29	112	2.5%
Other values (66)	1161	25.6%

Most occurring characters

Value	Count	Frequency (%)
0	11151	22.0%
-	9062	17.8%
2	8637	17.0%
1	7119	14.0%
	5469	10.8%
8	1630	3.2%
3	1621	3.2%
9	1471	2.9%
7	1359	2.7%
5	1351	2.7%
Other values (2)	1909	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	36248	71.4%
Dash Punctuation	9062	17.8%
Space Separator	5469	10.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	11151	30.8%
2	8637	23.8%
1	7119	19.6%
8	1630	4.5%
3	1621	4.5%
9	1471	4.1%
7	1359	3.7%
5	1351	3.7%
4	1348	3.7%
6	561	1.5%

Dash Punctuation

Value	Count	Frequency (%)
-	9062	100.0%

Space Separator

Value	Count	Frequency (%)
	5469	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	50779	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	11151	22.0%
-	9062	17.8%
2	8637	17.0%
1	7119	14.0%
	5469	10.8%
8	1630	3.2%
3	1621	3.2%
9	1471	2.9%
7	1359	2.7%
5	1351	2.7%
Other values (2)	1909	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50779	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	11151	22.0%
-	9062	17.8%
2	8637	17.0%
1	7119	14.0%
	5469	10.8%
8	1630	3.2%
3	1621	3.2%
9	1471	2.9%
7	1359	2.7%
5	1351	2.7%
Other values (2)	1909	3.8%

X좌표
Real number (ℝ)

HIGH CORRELATION

Distinct	9289
Distinct (%)	92.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	194172.3

Minimum	166217.66
Maximum	212266.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	166217.66
5-th percentile	174244.31
Q1	184371.42
median	193423.45
Q3	205491.03
95-th percentile	209798.64
Maximum	212266.1
Range	46048.438
Interquartile range (IQR)	21119.605

Descriptive statistics

Standard deviation	11380.135
Coefficient of variation (CV)	0.058608438
Kurtosis	-1.0519903
Mean	194172.3
Median Absolute Deviation (MAD)	9889.7023
Skewness	-0.18723528
Sum	1.941723 × 10⁹
Variance	1.2950748 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
209790.84	4	< 0.1%
197017.942	4	< 0.1%
182692.941	4	< 0.1%
191982.331	3	< 0.1%
181377.896	3	< 0.1%
185123.159	3	< 0.1%
210271.494	3	< 0.1%
180826.316	3	< 0.1%
193044.397	3	< 0.1%
181729.574	3	< 0.1%
Other values (9279)	9967	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
166217.662	1	< 0.1%
166219.491	1	< 0.1%
166272.172	1	< 0.1%
166273.981	1	< 0.1%
166290.071	1	< 0.1%
166294.023	1	< 0.1%
166294.054	1	< 0.1%
166295.843	1	< 0.1%
166298.72	1	< 0.1%
166353.275	1	< 0.1%

Value	Count	Frequency (%)
212266.1	1	< 0.1%
212212.83	1	< 0.1%
212034.77	1	< 0.1%
212034.559	1	< 0.1%
212034.391	2	< 0.1%
212022.18	1	< 0.1%
211975.343	1	< 0.1%
211975.254	1	< 0.1%
211974.235	1	< 0.1%
211969.584	1	< 0.1%

Y좌표
Real number (ℝ)

HIGH CORRELATION

Distinct	9284
Distinct (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	508903.09

Minimum	490912.41
Maximum	521801.03
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	490912.41
5-th percentile	498441.1
Q1	505591.45
median	509739.5
Q3	512666.38
95-th percentile	518351.84
Maximum	521801.03
Range	30888.62
Interquartile range (IQR)	7074.928

Descriptive statistics

Standard deviation	5953.2473
Coefficient of variation (CV)	0.011698195
Kurtosis	-0.0042088891
Mean	508903.09
Median Absolute Deviation (MAD)	3185.1227
Skewness	-0.45777048
Sum	5.0890309 × 10⁹
Variance	35441154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
521384.669	4	< 0.1%
506300.786	4	< 0.1%
506326.394	4	< 0.1%
493477.056	3	< 0.1%
492551.379	3	< 0.1%
507759.9714	3	< 0.1%
504036.955	3	< 0.1%
492810.889	3	< 0.1%
506940.3799	3	< 0.1%
507340.7474	3	< 0.1%
Other values (9274)	9967	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
490912.41	1	< 0.1%
490979.8	1	< 0.1%
491022.41	1	< 0.1%
491198.07	1	< 0.1%
491226.97	1	< 0.1%
491778.48	1	< 0.1%
491857.99	1	< 0.1%
491861.1	1	< 0.1%
491861.91	1	< 0.1%
491863.4	1	< 0.1%

Value	Count	Frequency (%)
521801.0304	2	< 0.1%
521777.9511	1	< 0.1%
521426.5631	1	< 0.1%
521384.669	4	< 0.1%
521364.2	1	< 0.1%
521335.02	1	< 0.1%
521277.17	1	< 0.1%
521269.968	1	< 0.1%
521248.301	1	< 0.1%
521247.992	1	< 0.1%

Heatmap
Table

	지형지물부호	관리번호	행정읍면동	관리기관	설치일자	위치구분	표지판구분	지주형식	높이	대장초기화여부	도로구간번호	공사번호	납품업체	로딩일자	X좌표	Y좌표
지형지물부호	1.000	0.085	0.000	0.275	0.382	0.000	0.059	0.000	0.000	0.000	0.000	0.000	0.067	0.309	0.000	0.000
관리번호	0.085	1.000	0.656	0.519	0.944	0.388	0.309	0.398	0.252	0.053	0.971	0.000	0.983	0.979	0.453	0.425
행정읍면동	0.000	0.656	1.000	0.893	0.957	0.485	0.390	0.527	0.311	0.277	0.678	0.089	0.734	0.902	0.954	0.881
관리기관	0.275	0.519	0.893	1.000	0.997	0.000	0.097	0.186	0.000	NaN	0.489	NaN	0.528	0.997	0.961	0.734
설치일자	0.382	0.944	0.957	0.997	1.000	0.804	0.584	0.798	0.514	1.000	0.904	1.000	0.977	0.994	0.925	0.899
위치구분	0.000	0.388	0.485	0.000	0.804	1.000	0.474	0.710	0.170	0.108	0.220	0.000	0.351	0.482	0.305	0.280
표지판구분	0.059	0.309	0.390	0.097	0.584	0.474	1.000	0.446	0.243	0.383	0.182	0.000	0.277	0.455	0.250	0.219
지주형식	0.000	0.398	0.527	0.186	0.798	0.710	0.446	1.000	0.480	0.140	0.326	0.000	0.362	0.575	0.361	0.326
높이	0.000	0.252	0.311	0.000	0.514	0.170	0.243	0.480	1.000	0.033	0.222	0.000	0.430	0.423	0.201	0.243
대장초기화여부	0.000	0.053	0.277	NaN	1.000	0.108	0.383	0.140	0.033	1.000	0.034	0.000	0.021	0.000	0.254	0.138
도로구간번호	0.000	0.971	0.678	0.489	0.904	0.220	0.182	0.326	0.222	0.034	1.000	0.000	0.957	0.966	0.436	0.427
공사번호	0.000	0.000	0.089	NaN	1.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.895	0.058	0.095
납품업체	0.067	0.983	0.734	0.528	0.977	0.351	0.277	0.362	0.430	0.021	0.957	0.000	1.000	0.991	0.688	0.722
로딩일자	0.309	0.979	0.902	0.997	0.994	0.482	0.455	0.575	0.423	0.000	0.966	0.895	0.991	1.000	0.893	0.891
X좌표	0.000	0.453	0.954	0.961	0.925	0.305	0.250	0.361	0.201	0.254	0.436	0.058	0.688	0.893	1.000	0.776
Y좌표	0.000	0.425	0.881	0.734	0.899	0.280	0.219	0.326	0.243	0.138	0.427	0.095	0.722	0.891	0.776	1.000

Heatmap
Table

	대장초기화여부	표지판구분	행정읍면동	지형지물부호	관리기관	위치구분	납품업체	공사번호	지주형식
대장초기화여부	1.000	0.276	0.219	0.000	1.000	0.077	0.016	0.000	0.140
표지판구분	0.276	1.000	0.167	0.043	0.079	0.187	0.136	0.000	0.240
행정읍면동	0.219	0.167	1.000	0.000	0.807	0.258	0.340	0.041	0.230
지형지물부호	0.000	0.043	0.000	1.000	0.183	0.000	0.053	0.000	0.000
관리기관	1.000	0.079	0.807	0.183	1.000	0.000	0.367	1.000	0.152
위치구분	0.077	0.187	0.258	0.000	0.000	1.000	0.177	0.000	0.448
납품업체	0.016	0.136	0.340	0.053	0.367	0.177	1.000	0.000	0.158
공사번호	0.000	0.000	0.041	0.000	1.000	0.000	0.000	1.000	0.000
지주형식	0.140	0.240	0.230	0.000	0.152	0.448	0.158	0.000	1.000

Heatmap
Table

	관리번호	높이	도로구간번호	X좌표	Y좌표	지형지물부호	행정읍면동	관리기관	위치구분	표지판구분	지주형식	대장초기화여부	공사번호	납품업체
관리번호	1.000	0.161	0.704	0.014	-0.108	0.061	0.387	0.447	0.149	0.116	0.210	0.038	0.000	0.941
높이	0.161	1.000	0.044	0.207	0.178	0.000	0.152	0.000	0.108	0.157	0.331	0.021	0.000	0.213
도로구간번호	0.704	0.044	1.000	-0.060	0.019	0.000	0.343	0.418	0.132	0.109	0.178	0.036	0.000	0.853
X좌표	0.014	0.207	-0.060	1.000	-0.004	0.000	0.770	0.736	0.165	0.134	0.173	0.195	0.034	0.353
Y좌표	-0.108	0.178	0.019	-0.004	1.000	0.000	0.575	0.568	0.151	0.117	0.154	0.106	0.056	0.384
지형지물부호	0.061	0.000	0.000	0.000	0.000	1.000	0.000	0.183	0.000	0.043	0.000	0.000	0.000	0.053
행정읍면동	0.387	0.152	0.343	0.770	0.575	0.000	1.000	0.807	0.258	0.167	0.230	0.219	0.041	0.340
관리기관	0.447	0.000	0.418	0.736	0.568	0.183	0.807	1.000	0.000	0.079	0.152	1.000	1.000	0.367
위치구분	0.149	0.108	0.132	0.165	0.151	0.000	0.258	0.000	1.000	0.187	0.448	0.077	0.000	0.177
표지판구분	0.116	0.157	0.109	0.134	0.117	0.043	0.167	0.079	0.187	1.000	0.240	0.276	0.000	0.136
지주형식	0.210	0.331	0.178	0.173	0.154	0.000	0.230	0.152	0.448	0.240	1.000	0.140	0.000	0.158
대장초기화여부	0.038	0.021	0.036	0.195	0.106	0.000	0.219	1.000	0.077	0.276	0.140	1.000	0.000	0.016
공사번호	0.000	0.000	0.000	0.034	0.056	0.000	0.041	1.000	0.000	0.000	0.000	0.000	1.000	0.000
납품업체	0.941	0.213	0.853	0.353	0.384	0.053	0.340	0.367	0.177	0.136	0.158	0.016	0.000	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

	지형지물부호	관리번호	행정읍면동	도엽번호	관리기관	설치일자	위치구분	표지판구분	지주형식	높이	규격	기재사항	대장초기화여부	비고	도로구간번호	납품업체	로딩일자	X좌표	Y좌표
16596	교통표지판	89991900000000	<NA>	377130855D	<NA>		좌	교통안전(지시)	견착식	0.0	오각0.8X0.3X0.8	횡단보도	1	동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역	89991900000000		2019-12-04	210917.8189	508103.6565
16220	교통표지판	89991900000000	<NA>	377130873A	<NA>		좌	교통안전(지시)	단주식	3.0	오각0.8X0.3X0.8	횡단보도	1	동탄(2)택지개발사업 부지공사(1단계)GIS DB구축용역	89991900000000		2019-12-04	209801.513	507212.595
6247	교통표지판	200449	양감면	376162015C	<NA>	1900-01-01	우	교통안전(주의)	단주식	2.5	0.6	과속방지턱	1		3110212026			197534.089	499018.689
11554	교통표지판	888618000000	향남읍	376161810B	<NA>	2016-01-01	좌	교통안전(보조)	<NA>	0.0	□600X600	견인지역	1	화성 향남 2지구 도로 및 지하시설물 DB 구축(20170831)	618100029		2017-08-31	190977.942	499869.463
13892	교통표지판	89991600000000	<NA>	377130832B	<NA>	2016-01-01	우	교통안전(지시)	견착식	2.9	¨ª600	자전거전용도로	1		89991600000000	새한항업	2019-01-05	209711.752	509361.864
5164	교통표지판	300313	서신면	376150960D	<NA>	1900-01-01	우	교통안전(지시)	견착식	0.0	0.8X0.8	비보호	1		2300213004			173309.529	508152.97
287	교통표지판	200462	양감면	376162035A	<NA>	1900-01-01	좌	교통안전(주의)	단주식	2.5	0.6	좌우로이중굽운도로	1		3110212019			197359.525	498179.335
2249	교통표지판	100120	봉담읍	376160938C	<NA>	1900-01-01	좌	교통안전(주의)	단주식	2.5	삼각형0.90	횡단보도	1		1104311032			194434.925	509123.277
4813	교통표지판	402137	병점2동	377130189D	<NA>	2006-06-20	좌	<NA>	단주식	2.8	삼각형0.9	과속방지턱	1	주의표지	2502444151			203964.415	511952.13
9671	교통표지판	411996	동탄1동	377130266D	<NA>	2006-10-01	좌	교통안전(지시)	편지식	5.5	사각 2.0*1.5	버스전용차로	1		2201019001			207039.988	512922.735

	지형지물부호	관리번호	행정읍면동	도엽번호	관리기관	설치일자	위치구분	표지판구분	지주형식	높이	규격	기재사항	대장초기화여부	비고	도로구간번호	납품업체	로딩일자	X좌표	Y좌표
11104	교통표지판	999161000000	마도면	376160656C	<NA>	2016-12-01	우	교통안전(규제)	견착식	0.0	삼각형0.7	양보	1	경기화성바이오밸리	99916121970			180019.068	508157.836
12058	교통표지판	215304000000	동탄5동	377130385D	<NA>	2014-01-01	좌	교통안전(주의)	단주식	2.3	삼변 : 0.9	과속방지턱	1		21530385139			210960.677	511907.391
12196	교통표지판	211617000000	장안면	376161720B	<NA>	2013-06-01	좌	교통안전(주의)	단주식	2.6	0.9x0.9x0.9	좌로굽은도로	1	도시계획도로 소로1-2호선 개설공사 GIS DB구축	21161720008			186555.058	499533.496
2991	교통표지판	99920151354	<NA>	376161295C	<NA>	1990-01-01	미분류	교통안전(규제)	미분류	0.0			1		99920150751			184120.22	500319.14
6007	교통표지판	300155	비봉면	376160325C	<NA>	1900-01-01	좌	교통안전(규제)	편지식	7.5	사각형	어린이보호구역 속도제한30	1		2800113020			188554.982	515212.002
18246	교통표지판	82161900000000	양감면	376161588D	<NA>	2017-12-01	우	교통안전(보조)	견착식	2.7	600X600	저속전기차진입금지,고속도로구간	1	화성향남2 주변도로 건설사업 도로 및 지하시설물 GIS DB 구축용역	82161900000000	(주)한라지리정보	2021-04-16	198916.949	500854.125
2924	교통표지판	99920151360	장안면	376161289C	<NA>	1990-01-01	미분류	교통안전(지시)	미분류	0.0			1		99920150478			185937.97	500910.29
11416	교통표지판	402254	병점2동	377130189B	<NA>	2006-06-20	우	<NA>	단주식	2.8	오각형0.6X0.2X0.6	횡단보도	1	지시표지	2502444151			203907.094	512066.575
16815	교통표지판	22161800000000	비봉면	376160311A	<NA>	2017-10-20	중앙	교통안전(규제)	견착식	0.0	¨ª600	최고속도제한60	1	시도69호선 도로확포장공사 GIS DB 구축용역	22161800000000	(주)성원공간정보	2018-08-31	186766.4044	516077.2861
2892	교통표지판	99920153156	마도면	376151010C	<NA>	1990-01-01	미분류	교통안전(주의)	미분류	0.0			1		99920150634			177381.38	510878.54

Most frequently occurring

	지형지물부호	관리번호	행정읍면동	도엽번호	관리기관	설치일자	위치구분	표지판구분	지주형식	높이	규격	기재사항	대장초기화여부	비고	도로구간번호	납품업체	로딩일자	X좌표	Y좌표	# duplicates
0	교통표지판	206307000000	<NA>	377130719A	<NA>	2016-01-01	좌	교통안전(보조)	측주식	4.0	사각:0.6X0.6	해제	1	내민식이 없으므로 측주식으로 표기	26307180293	새한항업	2019-04-05	208018.753	510570.071	2
1	교통표지판	206307000000	<NA>	377130719C	<NA>	2016-01-01	좌	교통안전(보조)	측주식	4.0	사각:0.6X0.6	해제	1	내민식이 없으므로 측주식으로 표기	26307190442	새한항업	2019-04-05	208185.921	510322.425	2
2	교통표지판	211619000000	장안면	376161854A	<NA>	2011-06-01	우	교통안전(규제)	견착식	0.0	900X3		1	장안면 독정리 247-2번지 원인자 공사	21161854008			188190.437	497152.565	2
3	교통표지판	211621000000	<NA>	376162117D	<NA>	2013-01-01	우	교통안전(규제)	단주식	3.8	1.2x1.2x1.2	천천히	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			180826.316	493477.056	2
4	교통표지판	211621000000	<NA>	376162117D	<NA>	2013-01-01	우	교통안전(주의)	단주식	2.8	1.2x1.2x1.2	과속방지턱	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			180847.152	493480.531	2
5	교통표지판	211621000000	<NA>	376162117D	<NA>	2013-01-01	좌	교통안전(주의)	단주식	2.8	1.2x1.2x1.2	과속방지턱	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			180862.108	493496.273	2
6	교통표지판	211621000000	<NA>	376162118C	<NA>	2013-01-01	우	교통안전(주의)	단주식	3.8	1.2x1.2x1.2	과속방지턱	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			181065.261	493475.357	2
7	교통표지판	211621000000	<NA>	376162118C	<NA>	2013-01-01	좌	교통안전(주의)	단주식	2.8	1.2x1.2x1.2	과속방지턱	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			181020.06	493480.502	2
8	교통표지판	211621000000	<NA>	376162118C	<NA>	2013-01-01	좌	교통안전(주의)	단주식	2.8	1.2x1.2x1.2	과속방지턱	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			181077.654	493491.058	2
9	교통표지판	211621000000	<NA>	376162118D	<NA>	2013-01-01	좌	교통안전(규제)	단주식	3.8	1.2x1.2x1.2	양보	1	이화-석천간(2공구)도로확포장공사 GIS DB 구축 사업	21162129001			181278.156	493523.624	2

Overview

Variables

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

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

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

Decimal Number

Uppercase Letter

Other Punctuation

Lowercase Letter

Other Symbol

Math Symbol

Space Separator

Modifier Symbol

Open Punctuation

Close Punctuation

Dash Punctuation

Control

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Greek

Most occurring blocks

Most frequent character per block

ASCII

Hangul

None

Geometric Shapes

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Other Symbol