gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	2347
Missing cells	4293
Missing cells (%)	10.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	348.5 KiB
Average record size in memory	152.1 B

Variable types

Text	6
Numeric	5
Categorical	7

Dataset

Description	보행자작동신호기 관리번호,지주관리번호,방향 (공통),설치일,교체일,X좌표,Y좌표,제조업체,작업구분 (공통),표출구분 (공통),종류,신규정규화ID,상태 (공통),공사관리번호,보행자작동신호기 관리번호,이력ID,위치정보,공사형태 (공통)
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15545/S/1/datasetView.do

Alerts

`공사형태 (공통)` is highly overall correlated with `표출구분 (공통)` and 2 other fields	High correlation
`위치정보` is highly overall correlated with `이력ID` and 3 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 `이력ID`	High correlation
`X좌표` is highly overall correlated with `신규정규화ID`	High correlation
`신규정규화ID` is highly overall correlated with `X좌표`	High correlation
`이력ID` is highly overall correlated with `방향 (공통)` and 1 other fields	High correlation
`작업구분 (공통)` is highly overall correlated with `제조업체`	High correlation
`표출구분 (공통)` is highly overall correlated with `공사형태 (공통)`	High correlation
`제조업체` is highly imbalanced (61.5%)	Imbalance
`상태 (공통)` is highly imbalanced (91.4%)	Imbalance
`방향 (공통)` has 152 (6.5%) missing values	Missing
`설치일` has 1237 (52.7%) missing values	Missing
`교체일` has 1443 (61.5%) missing values	Missing
`X좌표` has 152 (6.5%) missing values	Missing
`Y좌표` has 152 (6.5%) missing values	Missing
`신규정규화ID` has 760 (32.4%) missing values	Missing
`공사관리번호` has 397 (16.9%) missing values	Missing
`이력ID` has unique values	Unique
`방향 (공통)` has 336 (14.3%) zeros	Zeros

Reproduction

Analysis started	2024-05-04 05:44:21.818415
Analysis finished	2024-05-04 05:44:32.020177
Duration	10.2 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

보행자작동신호기 관리번호
Text

Distinct	2154
Distinct (%)	91.8%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

Length

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

Characters and Unicode

Total characters	30511
Distinct characters	11
Distinct categories	2 ?
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	1977 ?
Unique (%)	84.2%

Sample

1st row	29-0000001015
2nd row	29-0000001040
3rd row	29-0000001058
4th row	29-0000001064
5th row	29-0000001092

Value	Count	Frequency (%)
29-0000000001	5	0.2%
29-0000000093	4	0.2%
29-0000000039	3	0.1%
29-0000000035	3	0.1%
29-0000000658	3	0.1%
29-0000000092	3	0.1%
29-0000000030	3	0.1%
29-0000000033	3	0.1%
29-0000000031	3	0.1%
29-0000000034	3	0.1%
Other values (2144)	2314	98.6%

Most occurring characters

Value	Count	Frequency (%)
0	16127	52.9%
2	3212	10.5%
9	3025	9.9%
-	2347	7.7%
1	1730	5.7%
6	693	2.3%
3	684	2.2%
5	679	2.2%
7	678	2.2%
4	674	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28164	92.3%
Dash Punctuation	2347	7.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16127	57.3%
2	3212	11.4%
9	3025	10.7%
1	1730	6.1%
6	693	2.5%
3	684	2.4%
5	679	2.4%
7	678	2.4%
4	674	2.4%
8	662	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	2347	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	30511	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16127	52.9%
2	3212	10.5%
9	3025	9.9%
-	2347	7.7%
1	1730	5.7%
6	693	2.3%
3	684	2.2%
5	679	2.2%
7	678	2.2%
4	674	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30511	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16127	52.9%
2	3212	10.5%
9	3025	9.9%
-	2347	7.7%
1	1730	5.7%
6	693	2.3%
3	684	2.2%
5	679	2.2%
7	678	2.2%
4	674	2.2%

지주관리번호
Text

Distinct	1917
Distinct (%)	81.7%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

Length

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

Characters and Unicode

Total characters	30511
Distinct characters	11
Distinct categories	2 ?
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	1636 ?
Unique (%)	69.7%

Sample

1st row	02-0000000030
2nd row	02-0000117327
3rd row	02-0000120394
4th row	02-0000050216
5th row	02-0000009634

Value	Count	Frequency (%)
02-0000162102	8	0.3%
02-0000162105	8	0.3%
02-0000162103	6	0.3%
02-0000006646	5	0.2%
02-0000160966	5	0.2%
02-0000136757	5	0.2%
02-0000080250	5	0.2%
02-0000134220	5	0.2%
02-0000160968	4	0.2%
02-0000001343	4	0.2%
Other values (1907)	2292	97.7%

Most occurring characters

Value	Count	Frequency (%)
0	14079	46.1%
2	3634	11.9%
1	2380	7.8%
-	2347	7.7%
6	1328	4.4%
5	1260	4.1%
7	1232	4.0%
9	1102	3.6%
8	1088	3.6%
3	1063	3.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28164	92.3%
Dash Punctuation	2347	7.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	14079	50.0%
2	3634	12.9%
1	2380	8.5%
6	1328	4.7%
5	1260	4.5%
7	1232	4.4%
9	1102	3.9%
8	1088	3.9%
3	1063	3.8%
4	998	3.5%

Dash Punctuation

Value	Count	Frequency (%)
-	2347	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	30511	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	14079	46.1%
2	3634	11.9%
1	2380	7.8%
-	2347	7.7%
6	1328	4.4%
5	1260	4.1%
7	1232	4.0%
9	1102	3.6%
8	1088	3.6%
3	1063	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30511	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	14079	46.1%
2	3634	11.9%
1	2380	7.8%
-	2347	7.7%
6	1328	4.4%
5	1260	4.1%
7	1232	4.0%
9	1102	3.6%
8	1088	3.6%
3	1063	3.5%

방향 (공통)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	9
Distinct (%)	0.4%
Missing	152
Missing (%)	6.5%
Infinite	0
Infinite (%)	0.0%
Mean	117.84055

Minimum	-45
Maximum	315
Zeros	336
Zeros (%)	14.3%
Negative	6
Negative (%)	0.3%
Memory size	20.8 KiB

Quantile statistics

Minimum	-45
5-th percentile	0
Q1	90
median	90
Q3	180
95-th percentile	180
Maximum	315
Range	360
Interquartile range (IQR)	90

Descriptive statistics

Standard deviation	70.308489
Coefficient of variation (CV)	0.59664089
Kurtosis	-0.55948267
Mean	117.84055
Median Absolute Deviation (MAD)	90
Skewness	-0.12277135
Sum	258660
Variance	4943.2836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
90	881	37.5%
180	862	36.7%
0	336	14.3%
270	64	2.7%
45	16	0.7%
135	11	0.5%
225	11	0.5%
315	8	0.3%
-45	6	0.3%
(Missing)	152	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-45	6	0.3%
0	336	14.3%
45	16	0.7%
90	881	37.5%
135	11	0.5%
180	862	36.7%
225	11	0.5%
270	64	2.7%
315	8	0.3%

Value	Count	Frequency (%)
315	8	0.3%
270	64	2.7%
225	11	0.5%
180	862	36.7%
135	11	0.5%
90	881	37.5%
45	16	0.7%
0	336	14.3%
-45	6	0.3%

설치일
Text

MISSING

Distinct	304
Distinct (%)	27.4%
Missing	1237
Missing (%)	52.7%
Memory size	18.5 KiB

Length

Max length	8
Median length	8
Mean length	7.9873874
Min length	1

Characters and Unicode

Total characters	8866
Distinct characters	11
Distinct categories	2 ?
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	70 ?
Unique (%)	6.3%

Sample

1st row	20201215
2nd row	20201215
3rd row	20011203
4th row	20201215
5th row	20161111

Value	Count	Frequency (%)
20100625	34	3.1%
20201215	25	2.3%
20130430	25	2.3%
20171031	24	2.2%
20090101	23	2.1%
20130725	18	1.6%
20131220	16	1.4%
20131231	16	1.4%
20130920	15	1.4%
20150922	14	1.3%
Other values (293)	898	81.0%

Most occurring characters

Value	Count	Frequency (%)
0	2698	30.4%
1	2083	23.5%
2	1909	21.5%
3	530	6.0%
5	404	4.6%
9	297	3.3%
4	280	3.2%
6	277	3.1%
8	194	2.2%
7	192	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8864	> 99.9%
Space Separator	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2698	30.4%
1	2083	23.5%
2	1909	21.5%
3	530	6.0%
5	404	4.6%
9	297	3.4%
4	280	3.2%
6	277	3.1%
8	194	2.2%
7	192	2.2%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8866	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2698	30.4%
1	2083	23.5%
2	1909	21.5%
3	530	6.0%
5	404	4.6%
9	297	3.3%
4	280	3.2%
6	277	3.1%
8	194	2.2%
7	192	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8866	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2698	30.4%
1	2083	23.5%
2	1909	21.5%
3	530	6.0%
5	404	4.6%
9	297	3.3%
4	280	3.2%
6	277	3.1%
8	194	2.2%
7	192	2.2%

교체일
Text

MISSING

Distinct	260
Distinct (%)	28.8%
Missing	1443
Missing (%)	61.5%
Memory size	18.5 KiB

Length

Max length	8
Median length	8
Mean length	7.9845133
Min length	1

Characters and Unicode

Total characters	7218
Distinct characters	11
Distinct categories	2 ?
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	63 ?
Unique (%)	7.0%

Sample

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

Value	Count	Frequency (%)
20201215	42	4.7%
20171031	22	2.4%
20131220	16	1.8%
20171215	16	1.8%
20131231	16	1.8%
20190913	16	1.8%
20201016	15	1.7%
20190912	14	1.6%
20171220	14	1.6%
20140425	14	1.6%
Other values (249)	717	79.5%

Most occurring characters

Value	Count	Frequency (%)
0	1929	26.7%
2	1769	24.5%
1	1664	23.1%
3	377	5.2%
5	345	4.8%
9	313	4.3%
6	239	3.3%
7	221	3.1%
4	215	3.0%
8	144	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7216	> 99.9%
Space Separator	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1929	26.7%
2	1769	24.5%
1	1664	23.1%
3	377	5.2%
5	345	4.8%
9	313	4.3%
6	239	3.3%
7	221	3.1%
4	215	3.0%
8	144	2.0%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7218	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1929	26.7%
2	1769	24.5%
1	1664	23.1%
3	377	5.2%
5	345	4.8%
9	313	4.3%
6	239	3.3%
7	221	3.1%
4	215	3.0%
8	144	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7218	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1929	26.7%
2	1769	24.5%
1	1664	23.1%
3	377	5.2%
5	345	4.8%
9	313	4.3%
6	239	3.3%
7	221	3.1%
4	215	3.0%
8	144	2.0%

X좌표
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1922
Distinct (%)	87.6%
Missing	152
Missing (%)	6.5%
Infinite	0
Infinite (%)	0.0%
Mean	199413.05

Minimum	182613.69
Maximum	215848.52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.8 KiB

Quantile statistics

Minimum	182613.69
5-th percentile	187931.67
Q1	193500.77
median	201173.34
Q3	204601.21
95-th percentile	209579.13
Maximum	215848.52
Range	33234.824
Interquartile range (IQR)	11100.435

Descriptive statistics

Standard deviation	6941.2835
Coefficient of variation (CV)	0.034808571
Kurtosis	-0.6921701
Mean	199413.05
Median Absolute Deviation (MAD)	4986.3851
Skewness	-0.22726675
Sum	4.3771165 × 10⁸
Variance	48181416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
190934.63327	8	0.3%
192304.7565	8	0.3%
205745.67406	5	0.2%
207062.173	5	0.2%
207057.53485	5	0.2%
207039.62379	4	0.2%
196710.89419	4	0.2%
204945.33963	4	0.2%
204955.31176	4	0.2%
201347.58665	4	0.2%
Other values (1912)	2144	91.4%
(Missing)	152	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
182613.69228	1	< 0.1%
183176.56511	1	< 0.1%
183187.03519	1	< 0.1%
183521.12614	1	< 0.1%
183525.41352	1	< 0.1%
183551.46591	1	< 0.1%
183551.5259	1	< 0.1%
183558.63468	1	< 0.1%
183558.75466	1	< 0.1%
183772.7444	1	< 0.1%

Value	Count	Frequency (%)
215848.51616	1	< 0.1%
215834.65854	1	< 0.1%
215126.15046	1	< 0.1%
215113.1247	2	0.1%
215101.13852	1	< 0.1%
215095.4747	2	0.1%
214933.75982	1	< 0.1%
214929.32808	1	< 0.1%
214187.61946	1	< 0.1%
214181.54551	1	< 0.1%

Y좌표
Real number (ℝ)

MISSING

Distinct	1921
Distinct (%)	87.5%
Missing	152
Missing (%)	6.5%
Infinite	0
Infinite (%)	0.0%
Mean	551362.48

Minimum	539291.37
Maximum	565368.17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.8 KiB

Quantile statistics

Minimum	539291.37
5-th percentile	541969.51
Q1	547190.92
median	550806.82
Q3	554889.3
95-th percentile	561977.15
Maximum	565368.17
Range	26076.806
Interquartile range (IQR)	7698.3781

Descriptive statistics

Standard deviation	5824.2743
Coefficient of variation (CV)	0.010563421
Kurtosis	-0.47890259
Mean	551362.48
Median Absolute Deviation (MAD)	3865.3558
Skewness	0.23294895
Sum	1.2102407 × 10⁹
Variance	33922171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
548293.31251	8	0.3%
549168.58356	8	0.3%
552374.0823	5	0.2%
553910.32527	5	0.2%
552756.64403	5	0.2%
552607.95843	4	0.2%
552587.21478	4	0.2%
553163.29356	4	0.2%
548515.29834	4	0.2%
551529.3468	4	0.2%
Other values (1911)	2144	91.4%
(Missing)	152	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
539291.36638	1	< 0.1%
539298.7976	1	< 0.1%
539308.26847	1	< 0.1%
539315.62095	1	< 0.1%
539664.75454	1	< 0.1%
539665.84256	1	< 0.1%
539700.94402	1	< 0.1%
539735.44746	1	< 0.1%
539735.71367	1	< 0.1%
539744.00724	1	< 0.1%

Value	Count	Frequency (%)
565368.17229	1	< 0.1%
565365.97236	1	< 0.1%
565360.45237	1	< 0.1%
565358.06919	1	< 0.1%
565346.92577	1	< 0.1%
565345.19616	1	< 0.1%
565310.74999	1	< 0.1%
565306.49072	1	< 0.1%
565305.83083	1	< 0.1%
565303.1013	1	< 0.1%

제조업체
Categorical

HIGH CORRELATION IMBALANCE

Distinct	45
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

<NA>	1137
대한신호	830
대한신호(주)	100
.	63
0	24
Other values (40)	193

Length

Max length	10
Median length	4
Mean length	4.0877716
Min length	1

Unique

Unique	11 ?
Unique (%)	0.5%

Sample

1st row	대한신호
2nd row	.
3rd row	.
4th row	.
5th row	대한신호

Common Values

Value	Count	Frequency (%)
<NA>	1137	48.4%
대한신호	830	35.4%
대한신호(주)	100	4.3%
.	63	2.7%
0	24	1.0%
대한신호㈜	24	1.0%
서돌전자통신	17	0.7%
한길에이치씨	14	0.6%
대한	14	0.6%
1	13	0.6%
Other values (35)	111	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	1137	48.5%
대한신호	830	35.4%
대한신호(주	101	4.3%
	63	2.7%
0	24	1.0%
대한신호㈜	24	1.0%
서돌전자통신	17	0.7%
한길에이치씨	14	0.6%
대한	14	0.6%
1	13	0.6%
Other values (33)	108	4.6%

작업구분 (공통)
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

1	1735
6	261
2	259
4	74
3	18

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

Common Values

Value	Count	Frequency (%)
1	1735	73.9%
6	261	11.1%
2	259	11.0%
4	74	3.2%
3	18	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1735	73.9%
6	261	11.1%
2	259	11.0%
4	74	3.2%
3	18	0.8%

표출구분 (공통)
Categorical

HIGH CORRELATION

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

1	1783
2	564

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	1783	76.0%
2	564	24.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1783	76.0%
2	564	24.0%

종류
Categorical

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

0	1791
1	537
<NA>	19

Length

Max length	4
Median length	1
Mean length	1.0242863
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
0	1791	76.3%
1	537	22.9%
<NA>	19	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1791	76.3%
1	537	22.9%
na	19	0.8%

신규정규화ID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1578
Distinct (%)	99.4%
Missing	760
Missing (%)	32.4%
Infinite	0
Infinite (%)	0.0%
Mean	4041538.4

Minimum	289141
Maximum	52858210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.8 KiB

Quantile statistics

Minimum	289141
5-th percentile	1178773
Q1	2303672.5
median	4221694
Q3	5108596
95-th percentile	6214761.7
Maximum	52858210
Range	52569069
Interquartile range (IQR)	2804923.5

Descriptive statistics

Standard deviation	3628310.5
Coefficient of variation (CV)	0.89775481
Kurtosis	92.332027
Mean	4041538.4
Median Absolute Deviation (MAD)	1084922
Skewness	8.4893263
Sum	6.4139215 × 10⁹
Variance	1.3164637 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32035810	3	0.1%
2979810	3	0.1%
32674510	2	0.1%
20069010	2	0.1%
52858210	2	0.1%
12716410	2	0.1%
44652510	2	0.1%
2373936	1	< 0.1%
4432912	1	< 0.1%
1106496	1	< 0.1%
Other values (1568)	1568	66.8%
(Missing)	760	32.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
289141	1	< 0.1%
289244	1	< 0.1%
297972	1	< 0.1%
297989	1	< 0.1%
352541	1	< 0.1%
352542	1	< 0.1%
352811	1	< 0.1%
362942	1	< 0.1%
372042	1	< 0.1%
380205	1	< 0.1%

Value	Count	Frequency (%)
52858210	2	0.1%
45309410	1	< 0.1%
44652510	2	0.1%
42562410	1	< 0.1%
33840610	1	< 0.1%
32674510	2	0.1%
32035810	3	0.1%
20069010	2	0.1%
20059910	1	< 0.1%
12716410	2	0.1%

상태 (공통)
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

001	2288
<NA>	41
004	14
002	2
	2

Length

Max length	4
Median length	3
Mean length	3.0157648
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
001	2288	97.5%
<NA>	41	1.7%
004	14	0.6%
002	2	0.1%
	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
001	2288	97.6%
na	41	1.7%
004	14	0.6%
002	2	0.1%

공사관리번호
Text

MISSING

Distinct	312
Distinct (%)	16.0%
Missing	397
Missing (%)	16.9%
Memory size	18.5 KiB

Length

Max length	13
Median length	13
Mean length	12.987692
Min length	1

Characters and Unicode

Total characters	25326
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	53 ?
Unique (%)	2.7%

Sample

1st row	2012-0101-006
2nd row	2012-0101-091
3rd row	2012-0101-112
4th row	2012-0101-112
5th row	2012-0101-111

Value	Count	Frequency (%)
2000-0000-000	702	36.0%
2019-0201-040	58	3.0%
2020-0101-114	42	2.2%
2011-0101-084	32	1.6%
2009-1101-151	26	1.3%
2012-0101-012	26	1.3%
2016-2301-001	23	1.2%
2013-0111-004	18	0.9%
2014-0101-034	18	0.9%
2020-0101-011	16	0.8%
Other values (301)	987	50.7%

Most occurring characters

Value	Count	Frequency (%)
0	12138	47.9%
1	4182	16.5%
-	3896	15.4%
2	2896	11.4%
4	453	1.8%
3	395	1.6%
6	308	1.2%
7	302	1.2%
9	297	1.2%
5	247	1.0%
Other values (2)	212	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21428	84.6%
Dash Punctuation	3896	15.4%
Space Separator	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12138	56.6%
1	4182	19.5%
2	2896	13.5%
4	453	2.1%
3	395	1.8%
6	308	1.4%
7	302	1.4%
9	297	1.4%
5	247	1.2%
8	210	1.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3896	100.0%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	25326	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12138	47.9%
1	4182	16.5%
-	3896	15.4%
2	2896	11.4%
4	453	1.8%
3	395	1.6%
6	308	1.2%
7	302	1.2%
9	297	1.2%
5	247	1.0%
Other values (2)	212	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25326	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12138	47.9%
1	4182	16.5%
-	3896	15.4%
2	2896	11.4%
4	453	1.8%
3	395	1.6%
6	308	1.2%
7	302	1.2%
9	297	1.2%
5	247	1.0%
Other values (2)	212	0.8%

보행자작동신호기 관리번호.1
Text

Distinct	2154
Distinct (%)	91.8%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	21123
Distinct characters	11
Distinct categories	2 ?
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	1977 ?
Unique (%)	84.2%

Sample

1st row	29-001015
2nd row	29-001040
3rd row	29-001058
4th row	29-001064
5th row	29-001092

Value	Count	Frequency (%)
29-000001	5	0.2%
29-000093	4	0.2%
29-000039	3	0.1%
29-000035	3	0.1%
29-000658	3	0.1%
29-000092	3	0.1%
29-000030	3	0.1%
29-000033	3	0.1%
29-000031	3	0.1%
29-000034	3	0.1%
Other values (2144)	2314	98.6%

Most occurring characters

Value	Count	Frequency (%)
0	6739	31.9%
2	3212	15.2%
9	3025	14.3%
-	2347	11.1%
1	1730	8.2%
6	693	3.3%
3	684	3.2%
5	679	3.2%
7	678	3.2%
4	674	3.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18776	88.9%
Dash Punctuation	2347	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6739	35.9%
2	3212	17.1%
9	3025	16.1%
1	1730	9.2%
6	693	3.7%
3	684	3.6%
5	679	3.6%
7	678	3.6%
4	674	3.6%
8	662	3.5%

Dash Punctuation

Value	Count	Frequency (%)
-	2347	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	21123	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6739	31.9%
2	3212	15.2%
9	3025	14.3%
-	2347	11.1%
1	1730	8.2%
6	693	3.3%
3	684	3.2%
5	679	3.2%
7	678	3.2%
4	674	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21123	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6739	31.9%
2	3212	15.2%
9	3025	14.3%
-	2347	11.1%
1	1730	8.2%
6	693	3.3%
3	684	3.2%
5	679	3.2%
7	678	3.2%
4	674	3.2%

이력ID
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	2347
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1182.0017

Minimum	1
Maximum	2374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.8 KiB

Quantile statistics

Minimum	1
5-th percentile	118.3
Q1	587.5
median	1174
Q3	1776.5
95-th percentile	2256.7
Maximum	2374
Range	2373
Interquartile range (IQR)	1189

Descriptive statistics

Standard deviation	686.5346
Coefficient of variation (CV)	0.58082369
Kurtosis	-1.202622
Mean	1182.0017
Median Absolute Deviation (MAD)	595
Skewness	0.014284317
Sum	2774158
Variance	471329.75
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	1	< 0.1%
2028	1	< 0.1%
1769	1	< 0.1%
1768	1	< 0.1%
1949	1	< 0.1%
1939	1	< 0.1%
1420	1	< 0.1%
1990	1	< 0.1%
2002	1	< 0.1%
1980	1	< 0.1%
Other values (2337)	2337	99.6%

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 (%)
2374	1	< 0.1%
2373	1	< 0.1%
2372	1	< 0.1%
2371	1	< 0.1%
2370	1	< 0.1%
2369	1	< 0.1%
2368	1	< 0.1%
2367	1	< 0.1%
2366	1	< 0.1%
2365	1	< 0.1%

위치정보
Categorical

HIGH CORRELATION

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

1	1289
<NA>	1056
	2

Length

Max length	4
Median length	1
Mean length	2.3498083
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	1289	54.9%
<NA>	1056	45.0%
	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1289	55.0%
na	1056	45.0%

공사형태 (공통)
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	18.5 KiB

<NA>	949
003	805
001	415
002	90
004	79
Other values (2)	9

Length

Max length	4
Median length	3
Mean length	3.4026417
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	949	40.4%
003	805	34.3%
001	415	17.7%
002	90	3.8%
004	79	3.4%
006	7	0.3%
	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	949	40.5%
003	805	34.3%
001	415	17.7%
002	90	3.8%
004	79	3.4%
006	7	0.3%

Heatmap
Table

	방향 (공통)	X좌표	Y좌표	제조업체	작업구분 (공통)	표출구분 (공통)	종류	신규정규화ID	상태 (공통)	이력ID	위치정보	공사형태 (공통)
방향 (공통)	1.000	0.223	0.303	0.476	0.440	0.157	0.216	0.000	0.000	0.612	0.223	0.268
X좌표	0.223	1.000	0.664	0.656	0.329	0.132	0.159	0.635	0.155	0.523	0.304	0.233
Y좌표	0.303	0.664	1.000	0.633	0.471	0.300	0.224	0.244	0.159	0.594	0.358	0.392
제조업체	0.476	0.656	0.633	1.000	0.823	0.450	0.395	0.000	0.880	0.635	1.000	0.794
작업구분 (공통)	0.440	0.329	0.471	0.823	1.000	0.223	0.131	0.114	0.000	0.580	0.000	0.392
표출구분 (공통)	0.157	0.132	0.300	0.450	0.223	1.000	0.222	0.024	0.091	0.585	0.100	0.911
종류	0.216	0.159	0.224	0.395	0.131	0.222	1.000	0.073	0.072	0.399	0.090	0.145
신규정규화ID	0.000	0.635	0.244	0.000	0.114	0.024	0.073	1.000	0.046	0.163	0.135	0.101
상태 (공통)	0.000	0.155	0.159	0.880	0.000	0.091	0.072	0.046	1.000	0.099	1.000	0.741
이력ID	0.612	0.523	0.594	0.635	0.580	0.585	0.399	0.163	0.099	1.000	1.000	0.448
위치정보	0.223	0.304	0.358	1.000	0.000	0.100	0.090	0.135	1.000	1.000	1.000	1.000
공사형태 (공통)	0.268	0.233	0.392	0.794	0.392	0.911	0.145	0.101	0.741	0.448	1.000	1.000

Heatmap
Table

	공사형태 (공통)	종류	위치정보	작업구분 (공통)	제조업체	표출구분 (공통)	상태 (공통)
공사형태 (공통)	1.000	0.104	0.997	0.282	0.487	0.734	0.577
종류	0.104	1.000	0.057	0.160	0.309	0.142	0.047
위치정보	0.997	0.057	1.000	0.000	0.981	0.064	0.999
작업구분 (공통)	0.282	0.160	0.000	1.000	0.533	0.272	0.000
제조업체	0.487	0.309	0.981	0.533	1.000	0.353	0.683
표출구분 (공통)	0.734	0.142	0.064	0.272	0.353	1.000	0.060
상태 (공통)	0.577	0.047	0.999	0.000	0.683	0.060	1.000

Heatmap
Table

	방향 (공통)	X좌표	Y좌표	신규정규화ID	이력ID	제조업체	작업구분 (공통)	표출구분 (공통)	종류	상태 (공통)	위치정보	공사형태 (공통)
방향 (공통)	1.000	-0.083	-0.208	-0.095	0.524	0.199	0.272	0.157	0.215	0.000	0.223	0.152
X좌표	-0.083	1.000	0.275	0.940	0.029	0.283	0.142	0.101	0.122	0.093	0.233	0.124
Y좌표	-0.208	0.275	1.000	0.374	-0.091	0.270	0.214	0.231	0.174	0.095	0.274	0.219
신규정규화ID	-0.095	0.940	0.374	1.000	0.071	0.000	0.122	0.026	0.078	0.031	0.223	0.060
이력ID	0.524	0.029	-0.091	0.071	1.000	0.271	0.278	0.452	0.306	0.059	0.998	0.255
제조업체	0.199	0.283	0.270	0.000	0.271	1.000	0.533	0.353	0.309	0.683	0.981	0.487
작업구분 (공통)	0.272	0.142	0.214	0.122	0.278	0.533	1.000	0.272	0.160	0.000	0.000	0.282
표출구분 (공통)	0.157	0.101	0.231	0.026	0.452	0.353	0.272	1.000	0.142	0.060	0.064	0.734
종류	0.215	0.122	0.174	0.078	0.306	0.309	0.160	0.142	1.000	0.047	0.057	0.104
상태 (공통)	0.000	0.093	0.095	0.031	0.059	0.683	0.000	0.060	0.047	1.000	0.999	0.577
위치정보	0.223	0.233	0.274	0.223	0.998	0.981	0.000	0.064	0.057	0.999	1.000	0.997
공사형태 (공통)	0.152	0.124	0.219	0.060	0.255	0.487	0.282	0.734	0.104	0.577	0.997	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

	보행자작동신호기 관리번호	지주관리번호	방향 (공통)	설치일	교체일	X좌표	Y좌표	제조업체	작업구분 (공통)	표출구분 (공통)	종류	신규정규화ID	상태 (공통)	공사관리번호	보행자작동신호기 관리번호.1	이력ID	위치정보	공사형태 (공통)
0	29-0000001015	02-0000000030	315	<NA>	<NA>	197694.00138	550450.82047	대한신호	1	1	1	3267046	001	2012-0101-006	29-001015	3	1	003
1	29-0000001040	02-0000117327	90	<NA>	<NA>	201594.49009	558600.64063	.	2	1	0	<NA>	001	2012-0101-091	29-001040	807	1	<NA>
2	29-0000001058	02-0000120394	90	<NA>	<NA>	206861.93441	550509.99666	.	2	1	0	<NA>	001	2012-0101-112	29-001058	836	1	<NA>
3	29-0000001064	02-0000050216	90	<NA>	<NA>	206777.83936	550295.15259	.	2	1	0	<NA>	001	2012-0101-112	29-001064	263	1	<NA>
4	29-0000001092	02-0000009634	90	<NA>	<NA>	198742.67717	550794.67193	대한신호	1	1	1	3288102	001	2012-0101-111	29-001092	103	1	003
5	29-0000001087	02-0000139703	90	<NA>	<NA>	197867.46342	550996.25356	.	2	1	0	<NA>	001	2012-0101-111	29-001087	940	1	<NA>
6	29-0000000950	02-0000079912	90	<NA>	<NA>	206522.05977	554275.64231	0	1	1	0	<NA>	001	2011-0101-084	29-000950	496	1	<NA>
7	29-0000000929	02-0000129123	0	<NA>	<NA>	204960.44412	551607.19086	0	1	1	0	<NA>	001	2011-0101-084	29-000929	860	1	<NA>
8	29-0000000618	02-0000068290	90	<NA>	<NA>	206029.1903	553142.69337	<NA>	1	1	0	5322773	001	2000-0000-000	29-000618	399	1	003
9	29-0000000647	02-0000068759	90	<NA>	<NA>	205673.63057	552209.97284	<NA>	1	1	1	5310993	001	2000-0000-000	29-000647	401	1	003

	보행자작동신호기 관리번호	지주관리번호	방향 (공통)	설치일	교체일	X좌표	Y좌표	제조업체	작업구분 (공통)	표출구분 (공통)	종류	신규정규화ID	상태 (공통)	공사관리번호	보행자작동신호기 관리번호.1	이력ID	위치정보	공사형태 (공통)
2337	29-0000002176	02-0000223061	<NA>	20230724	20230724	<NA>	<NA>	대한신호	1	2	1	352541	001	2023-0101-068	29-002176	2369	<NA>	001
2338	29-0000002175	02-0000223059	<NA>	20230724	20230724	<NA>	<NA>	대한신호(주)	1	2	1	1331081	001	2023-0101-062	29-002175	2368	<NA>	001
2339	29-0000002174	02-0000070042	<NA>	20230724	20230724	<NA>	<NA>	대한신호(주)	1	2	1	1331091	001	2023-0101-062	29-002174	2367	<NA>	001
2340	29-0000001145	02-0000157316	180	20230930	20230930	199951.69226	545467.93916	대한신호	1	2	1	4107547	001	2023-0101-010	29-001145	1338	<NA>	002
2341	29-0000001621	02-0000180594	180	20140806	20230725	203736.54785	565288.73377	대한신호(주)	1	2	0	4587104	001	2023-0101-133	29-001621	1814	<NA>	002
2342	29-0000001622	02-0000180595	180	20140806	20230725	203707.51284	565283.3347	대한신호(주)	1	2	0	4587004	001	2023-0101-133	29-001622	1815	<NA>	002
2343	29-0000001295	02-0000161621	180	20230615	20230615	201527.47298	561459.06215	<NA>	1	2	0	4439743	001	2023-0101-133	29-001295	1488	<NA>	002
2344	29-0000001294	02-0000161622	180	20230615	20230615	201517.11351	561448.54239	<NA>	1	2	0	4439633	001	2023-0101-133	29-001294	1487	<NA>	002
2345	29-0000001564	02-0000178446	180	20231128	20231128	198126.13139	550491.07917	대한신호	1	2	1	3267945	001	2023-0101-148	29-001564	1757	<NA>	002
2346	29-0000001563	02-0000178448	180	20130101	20231128	198138.24931	550498.78784	대한신호	1	2	1	3267944	001	2023-0101-148	29-001563	1756	<NA>	002

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

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

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

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common