gimi9 Pandas Profiling

Dataset statistics

Number of variables	20
Number of observations	10000
Missing cells	37942
Missing cells (%)	19.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 MiB
Average record size in memory	185.0 B

Variable types

Categorical	6
Text	3
Numeric	10
Unsupported	1

Dataset

Description	상태 (공통),횡단보도예고표시 관리번호,방향,고가 (공통),구경찰서코드 (공통),구코드 (공통),신경찰서코드 (공통),작업구분 (공통),표출구분 (공통),도로구분 (공통),관할사업소 (공통),신규정규화ID,설치일,교체일,공간데이터,이력ID,공사관리번호,구관리번호,종류코드,공사형태 (공통)
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15542/S/1/datasetView.do

Alerts

`표출구분 (공통)` is highly overall correlated with `작업구분 (공통)` and 1 other fields	High correlation
`고가 (공통)` is highly overall correlated with `종류코드`	High correlation
`작업구분 (공통)` is highly overall correlated with `설치일` and 3 other fields	High correlation
`종류코드` is highly overall correlated with `방향` and 14 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 1 other fields	High correlation
`구코드 (공통)` is highly overall correlated with `관할사업소 (공통)` and 1 other fields	High correlation
`신경찰서코드 (공통)` is highly overall correlated with `구경찰서코드 (공통)` and 1 other fields	High correlation
`관할사업소 (공통)` is highly overall correlated with `구코드 (공통)` and 1 other fields	High correlation
`신규정규화ID` is highly overall correlated with `종류코드`	High correlation
`설치일` is highly overall correlated with `교체일` and 3 other fields	High correlation
`교체일` is highly overall correlated with `설치일` and 3 other fields	High correlation
`이력ID` is highly overall correlated with `종류코드`	High correlation
`공사형태 (공통)` is highly overall correlated with `종류코드`	High correlation
`상태 (공통)` is highly imbalanced (97.8%)	Imbalance
`고가 (공통)` is highly imbalanced (98.1%)	Imbalance
`구경찰서코드 (공통)` has 569 (5.7%) missing values	Missing
`구코드 (공통)` has 603 (6.0%) missing values	Missing
`신경찰서코드 (공통)` has 569 (5.7%) missing values	Missing
`신규정규화ID` has 7556 (75.6%) missing values	Missing
`설치일` has 8868 (88.7%) missing values	Missing
`교체일` has 8861 (88.6%) missing values	Missing
`공간데이터` has 10000 (100.0%) missing values	Missing
`공사관리번호` has 114 (1.1%) missing values	Missing
`공사형태 (공통)` has 704 (7.0%) missing values	Missing
`이력ID` has unique values	Unique
`공간데이터` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-05-04 02:40:23.405787
Analysis finished	2024-05-04 02:41:01.914561
Duration	38.51 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

상태 (공통)
Categorical

HIGH CORRELATION IMBALANCE

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

1	9964
4	35
<NA>	1

Length

Max length	4
Median length	1
Mean length	1.0003
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
1	9964	99.6%
4	35	0.4%
<NA>	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9964	99.6%
4	35	0.4%
na	1	< 0.1%

횡단보도예고표시 관리번호
Text

Distinct	9059
Distinct (%)	90.6%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	130000
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	8185 ?
Unique (%)	81.8%

Sample

1st row	18-0000007245
2nd row	18-0000030997
3rd row	18-0000010434
4th row	18-0000033135
5th row	18-0000000272

Value	Count	Frequency (%)
18-0000018577	5	< 0.1%
18-0000032539	5	< 0.1%
18-0000004026	5	< 0.1%
18-0000022095	5	< 0.1%
18-0000024156	4	< 0.1%
18-0000006543	4	< 0.1%
18-0000014516	4	< 0.1%
18-0000027767	4	< 0.1%
18-0000024394	3	< 0.1%
18-0000017041	3	< 0.1%
Other values (9049)	9958	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	56461	43.4%
1	16459	12.7%
8	13834	10.6%
-	10000	7.7%
2	6500	5.0%
3	6017	4.6%
4	4798	3.7%
5	4096	3.2%
6	4015	3.1%
7	3958	3.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	120000	92.3%
Dash Punctuation	10000	7.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	56461	47.1%
1	16459	13.7%
8	13834	11.5%
2	6500	5.4%
3	6017	5.0%
4	4798	4.0%
5	4096	3.4%
6	4015	3.3%
7	3958	3.3%
9	3862	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	10000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	56461	43.4%
1	16459	12.7%
8	13834	10.6%
-	10000	7.7%
2	6500	5.0%
3	6017	4.6%
4	4798	3.7%
5	4096	3.2%
6	4015	3.1%
7	3958	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	56461	43.4%
1	16459	12.7%
8	13834	10.6%
-	10000	7.7%
2	6500	5.0%
3	6017	4.6%
4	4798	3.7%
5	4096	3.2%
6	4015	3.1%
7	3958	3.0%

방향
Real number (ℝ)

HIGH CORRELATION

Distinct	361
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	186.2169

Minimum	0
Maximum	360
Zeros	98
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	85
median	200
Q3	286
95-th percentile	347
Maximum	360
Range	360
Interquartile range (IQR)	201

Descriptive statistics

Standard deviation	111.482
Coefficient of variation (CV)	0.59866745
Kurtosis	-1.3426216
Mean	186.2169
Median Absolute Deviation (MAD)	95
Skewness	-0.16174854
Sum	1862169
Variance	12428.236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	98	1.0%
291	81	0.8%
290	81	0.8%
270	75	0.8%
22	74	0.7%
23	70	0.7%
20	68	0.7%
289	67	0.7%
21	63	0.6%
294	62	0.6%
Other values (351)	9261	92.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	98	1.0%
1	30	0.3%
2	42	0.4%
3	38	0.4%
4	26	0.3%
5	28	0.3%
6	23	0.2%
7	16	0.2%
8	29	0.3%
9	44	0.4%

Value	Count	Frequency (%)
360	11	0.1%
359	42	0.4%
358	44	0.4%
357	36	0.4%
356	52	0.5%
355	35	0.4%
354	45	0.4%
353	38	0.4%
352	36	0.4%
351	31	0.3%

고가 (공통)
Categorical

HIGH CORRELATION IMBALANCE

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

1	9964
2	30
3	5
<NA>	1

Length

Max length	4
Median length	1
Mean length	1.0003
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
1	9964	99.6%
2	30	0.3%
3	5	0.1%
<NA>	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9964	99.6%
2	30	0.3%
3	5	< 0.1%
na	1	< 0.1%

구경찰서코드 (공통)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	31
Distinct (%)	0.3%
Missing	569
Missing (%)	5.7%
Infinite	0
Infinite (%)	0.0%
Mean	274.6538

Minimum	110
Maximum	410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	110
5-th percentile	140
Q1	210
median	280
Q3	340
95-th percentile	400
Maximum	410
Range	300
Interquartile range (IQR)	130

Descriptive statistics

Standard deviation	81.65406
Coefficient of variation (CV)	0.29729812
Kurtosis	-1.0394828
Mean	274.6538
Median Absolute Deviation (MAD)	70
Skewness	-0.11654284
Sum	2590260
Variance	6667.3854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
280	606	6.1%
210	490	4.9%
360	474	4.7%
170	471	4.7%
300	443	4.4%
400	423	4.2%
310	412	4.1%
350	400	4.0%
230	355	3.5%
200	355	3.5%
Other values (21)	5002	50.0%
(Missing)	569	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	106	1.1%
120	172	1.7%
130	90	0.9%
140	176	1.8%
150	165	1.7%
160	256	2.6%
170	471	4.7%
180	244	2.4%
190	198	2.0%
200	355	3.5%

Value	Count	Frequency (%)
410	353	3.5%
400	423	4.2%
390	202	2.0%
380	148	1.5%
370	340	3.4%
360	474	4.7%
350	400	4.0%
340	330	3.3%
330	345	3.5%
320	254	2.5%

구코드 (공통)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	25
Distinct (%)	0.3%
Missing	603
Missing (%)	6.0%
Infinite	0
Infinite (%)	0.0%
Mean	451.08865

Minimum	110
Maximum	740
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	110
5-th percentile	140
Q1	290
median	470
Q3	620
95-th percentile	710
Maximum	740
Range	630
Interquartile range (IQR)	330

Descriptive statistics

Standard deviation	188.17924
Coefficient of variation (CV)	0.41716687
Kurtosis	-1.2256832
Mean	451.08865
Median Absolute Deviation (MAD)	180
Skewness	-0.12072438
Sum	4238880
Variance	35411.426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
680	826	8.3%
560	580	5.8%
710	577	5.8%
350	503	5.0%
440	473	4.7%
500	457	4.6%
650	453	4.5%
290	431	4.3%
740	403	4.0%
470	384	3.8%
Other values (15)	4310	43.1%
(Missing)	603	6.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	285	2.9%
140	282	2.8%
170	258	2.6%
200	302	3.0%
210	273	2.7%
230	374	3.7%
260	270	2.7%
290	431	4.3%
300	261	2.6%
320	293	2.9%

Value	Count	Frequency (%)
740	403	4.0%
710	577	5.8%
680	826	8.3%
650	453	4.5%
620	340	3.4%
590	204	2.0%
560	580	5.8%
540	232	2.3%
530	348	3.5%
500	457	4.6%

신경찰서코드 (공통)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	31
Distinct (%)	0.3%
Missing	569
Missing (%)	5.7%
Infinite	0
Infinite (%)	0.0%
Mean	273.51076

Minimum	110
Maximum	410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	110
5-th percentile	140
Q1	200
median	280
Q3	350
95-th percentile	400
Maximum	410
Range	300
Interquartile range (IQR)	150

Descriptive statistics

Standard deviation	84.843852
Coefficient of variation (CV)	0.31020297
Kurtosis	-1.148846
Mean	273.51076
Median Absolute Deviation (MAD)	70
Skewness	-0.14380044
Sum	2579480
Variance	7198.4792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
360	582	5.8%
170	582	5.8%
370	509	5.1%
210	482	4.8%
300	457	4.6%
410	418	4.2%
310	414	4.1%
280	413	4.1%
350	384	3.8%
200	373	3.7%
Other values (21)	4817	48.2%
(Missing)	569	5.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	168	1.7%
120	171	1.7%
130	115	1.1%
140	231	2.3%
150	113	1.1%
160	256	2.6%
170	582	5.8%
180	302	3.0%
190	214	2.1%
200	373	3.7%

Value	Count	Frequency (%)
410	418	4.2%
400	294	2.9%
390	200	2.0%
380	138	1.4%
370	509	5.1%
360	582	5.8%
350	384	3.8%
340	320	3.2%
330	342	3.4%
320	217	2.2%

작업구분 (공통)
Categorical

HIGH CORRELATION

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

4	4171
1	3851
2	1274
6	381
3	323

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
4	4171	41.7%
1	3851	38.5%
2	1274	12.7%
6	381	3.8%
3	323	3.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	4171	41.7%
1	3851	38.5%
2	1274	12.7%
6	381	3.8%
3	323	3.2%

표출구분 (공통)
Categorical

HIGH CORRELATION

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

1	6700
2	3300

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

Common Values

Value	Count	Frequency (%)
1	6700	67.0%
2	3300	33.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	6700	67.0%
2	3300	33.0%

도로구분 (공통)
Categorical

HIGH CORRELATION

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

1	6906
2	3087
<NA>	7

Length

Max length	4
Median length	1
Mean length	1.0021
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	6906	69.1%
2	3087	30.9%
<NA>	7	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	6906	69.1%
2	3087	30.9%
na	7	0.1%

관할사업소 (공통)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	69
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	106.43248

Minimum	104
Maximum	109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	104
5-th percentile	104
Q1	105
median	106
Q3	108
95-th percentile	109
Maximum	109
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6323603
Coefficient of variation (CV)	0.01533705
Kurtosis	-1.1441879
Mean	106.43248
Median Absolute Deviation (MAD)	1
Skewness	-0.0038502651
Sum	1056981
Variance	2.6646003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
106	1950	19.5%
107	1880	18.8%
108	1702	17.0%
104	1682	16.8%
105	1444	14.4%
109	1273	12.7%
(Missing)	69	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
104	1682	16.8%
105	1444	14.4%
106	1950	19.5%
107	1880	18.8%
108	1702	17.0%
109	1273	12.7%

Value	Count	Frequency (%)
109	1273	12.7%
108	1702	17.0%
107	1880	18.8%
106	1950	19.5%
105	1444	14.4%
104	1682	16.8%

신규정규화ID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2417
Distinct (%)	98.9%
Missing	7556
Missing (%)	75.6%
Infinite	0
Infinite (%)	0.0%
Mean	6414291.4

Minimum	172941
Maximum	72165110
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	172941
5-th percentile	1150292.1
Q1	2304850.5
median	4209557
Q3	5328764.8
95-th percentile	24530845
Maximum	72165110
Range	71992169
Interquartile range (IQR)	3023914.2

Descriptive statistics

Standard deviation	10732481
Coefficient of variation (CV)	1.6732139
Kurtosis	15.803716
Mean	6414291.4
Median Absolute Deviation (MAD)	1301990
Skewness	4.0030862
Sum	1.5676528 × 10¹⁰
Variance	1.1518616 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2887910	3	< 0.1%
23034710	3	< 0.1%
60187210	3	< 0.1%
52526810	2	< 0.1%
42658310	2	< 0.1%
43208410	2	< 0.1%
5413895	2	< 0.1%
5177084	2	< 0.1%
61221810	2	< 0.1%
62988210	2	< 0.1%
Other values (2407)	2421	24.2%
(Missing)	7556	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
172941	1	< 0.1%
182363	1	< 0.1%
182882	1	< 0.1%
190152	1	< 0.1%
190881	1	< 0.1%
191072	1	< 0.1%
192092	1	< 0.1%
192302	1	< 0.1%
192311	1	< 0.1%
193591	1	< 0.1%

Value	Count	Frequency (%)
72165110	2	< 0.1%
72089110	1	< 0.1%
72088810	1	< 0.1%
72083110	1	< 0.1%
62988210	2	< 0.1%
62862610	1	< 0.1%
62682710	1	< 0.1%
62403519	1	< 0.1%
62403516	1	< 0.1%
62233510	1	< 0.1%

설치일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	206
Distinct (%)	18.2%
Missing	8868
Missing (%)	88.7%
Infinite	0
Infinite (%)	0.0%
Mean	20173007

Minimum	20141231
Maximum	20240531
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20141231
5-th percentile	20151222
Q1	20161026
median	20171031
Q3	20181148
95-th percentile	20211221
Maximum	20240531
Range	99300
Interquartile range (IQR)	20121.75

Descriptive statistics

Standard deviation	18072.911
Coefficient of variation (CV)	0.00089589577
Kurtosis	1.7028047
Mean	20173007
Median Absolute Deviation (MAD)	10090.5
Skewness	1.1795413
Sum	2.2835843 × 10¹⁰
Variance	3.2663012 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20151231	88	0.9%
20161231	70	0.7%
20171226	39	0.4%
20171231	38	0.4%
20191231	36	0.4%
20161230	34	0.3%
20181221	31	0.3%
20151222	31	0.3%
20181231	30	0.3%
20161016	24	0.2%
Other values (196)	711	7.1%
(Missing)	8868	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20141231	4	< 0.1%
20150131	2	< 0.1%
20150420	2	< 0.1%
20150513	4	< 0.1%
20150531	6	0.1%
20150720	6	0.1%
20150815	1	< 0.1%
20150930	2	< 0.1%
20151007	1	< 0.1%
20151020	1	< 0.1%

Value	Count	Frequency (%)
20240531	1	< 0.1%
20240331	4	< 0.1%
20231231	5	0.1%
20231220	1	< 0.1%
20231130	2	< 0.1%
20231129	2	< 0.1%
20230731	1	< 0.1%
20230721	1	< 0.1%
20230630	2	< 0.1%
20230324	1	< 0.1%

교체일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	209
Distinct (%)	18.3%
Missing	8861
Missing (%)	88.6%
Infinite	0
Infinite (%)	0.0%
Mean	20174567

Minimum	20141231
Maximum	20240531
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20141231
5-th percentile	20151222
Q1	20161108
median	20171105
Q3	20181224
95-th percentile	20220819
Maximum	20240531
Range	99300
Interquartile range (IQR)	20115.5

Descriptive statistics

Standard deviation	19348.911
Coefficient of variation (CV)	0.00095907441
Kurtosis	0.90864104
Mean	20174567
Median Absolute Deviation (MAD)	10116
Skewness	1.0543456
Sum	2.2978832 × 10¹⁰
Variance	3.7438036 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20151231	84	0.8%
20161231	66	0.7%
20191231	37	0.4%
20171231	37	0.4%
20171226	37	0.4%
20161230	33	0.3%
20151222	31	0.3%
20181221	31	0.3%
20181231	30	0.3%
20161016	24	0.2%
Other values (199)	729	7.3%
(Missing)	8861	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20141231	4	< 0.1%
20150131	2	< 0.1%
20150420	1	< 0.1%
20150513	4	< 0.1%
20150531	5	0.1%
20150720	5	0.1%
20150815	1	< 0.1%
20150930	2	< 0.1%
20151007	1	< 0.1%
20151020	1	< 0.1%

Value	Count	Frequency (%)
20240531	1	< 0.1%
20240331	4	< 0.1%
20231231	5	0.1%
20231220	1	< 0.1%
20231130	2	< 0.1%
20231129	2	< 0.1%
20230731	1	< 0.1%
20230721	1	< 0.1%
20230630	2	< 0.1%
20230324	1	< 0.1%

공간데이터
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

이력ID
Real number (ℝ)

HIGH CORRELATION UNIQUE

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

Minimum	9
Maximum	107406
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	9
5-th percentile	3829.75
Q1	18898.5
median	39567.5
Q3	60694.25
95-th percentile	78580.15
Maximum	107406
Range	107397
Interquartile range (IQR)	41795.75

Descriptive statistics

Standard deviation	25346.052
Coefficient of variation (CV)	0.62407222
Kurtosis	-0.74327332
Mean	40613.973
Median Absolute Deviation (MAD)	20921
Skewness	0.2899623
Sum	4.0613973 × 10⁸
Variance	6.4242236 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9344	1	< 0.1%
101951	1	< 0.1%
64258	1	< 0.1%
24951	1	< 0.1%
5417	1	< 0.1%
63516	1	< 0.1%
79649	1	< 0.1%
50765	1	< 0.1%
10927	1	< 0.1%
39473	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9	1	< 0.1%
15	1	< 0.1%
19	1	< 0.1%
21	1	< 0.1%
27	1	< 0.1%
31	1	< 0.1%
50	1	< 0.1%
67	1	< 0.1%
80	1	< 0.1%
82	1	< 0.1%

Value	Count	Frequency (%)
107406	1	< 0.1%
107341	1	< 0.1%
107334	1	< 0.1%
107330	1	< 0.1%
107306	1	< 0.1%
107268	1	< 0.1%
107192	1	< 0.1%
107190	1	< 0.1%
107169	1	< 0.1%
107167	1	< 0.1%

공사관리번호
Text

MISSING

Distinct	1976
Distinct (%)	20.0%
Missing	114
Missing (%)	1.1%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	128518
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	645 ?
Unique (%)	6.5%

Sample

1st row	2005-1108-015
2nd row	2016-0507-002
3rd row	2005-0108-091
4th row	2009-1108-078
5th row	2010-0104-001

Value	Count	Frequency (%)
2000-0000-000	831	8.4%
2010-0108-013	116	1.2%
2008-0102-558	96	1.0%
2009-0108-049	63	0.6%
2010-1108-103	63	0.6%
2009-0108-012	54	0.5%
2011-0108-175	54	0.5%
2009-1002-001	53	0.5%
2009-1004-002	51	0.5%
2008-1108-985	41	0.4%
Other values (1966)	8464	85.6%

Most occurring characters

Value	Count	Frequency (%)
0	46472	36.2%
1	21478	16.7%
-	19772	15.4%
2	14922	11.6%
8	9147	7.1%
7	3344	2.6%
4	3110	2.4%
5	2931	2.3%
9	2791	2.2%
3	2451	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	108746	84.6%
Dash Punctuation	19772	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	46472	42.7%
1	21478	19.8%
2	14922	13.7%
8	9147	8.4%
7	3344	3.1%
4	3110	2.9%
5	2931	2.7%
9	2791	2.6%
3	2451	2.3%
6	2100	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	19772	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	128518	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	46472	36.2%
1	21478	16.7%
-	19772	15.4%
2	14922	11.6%
8	9147	7.1%
7	3344	2.6%
4	3110	2.4%
5	2931	2.3%
9	2791	2.2%
3	2451	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	128518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	46472	36.2%
1	21478	16.7%
-	19772	15.4%
2	14922	11.6%
8	9147	7.1%
7	3344	2.6%
4	3110	2.4%
5	2931	2.3%
9	2791	2.2%
3	2451	1.9%

구관리번호
Text

Distinct	9032
Distinct (%)	90.6%
Missing	29
Missing (%)	0.3%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	89739
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	8160 ?
Unique (%)	81.8%

Sample

1st row	18-007245
2nd row	18-030997
3rd row	18-010434
4th row	18-033135
5th row	18-000272

Value	Count	Frequency (%)
18-022095	5	0.1%
18-018577	5	0.1%
18-032539	5	0.1%
18-004026	5	0.1%
18-024156	4	< 0.1%
18-027767	4	< 0.1%
18-014516	4	< 0.1%
18-006543	4	< 0.1%
18-030108	3	< 0.1%
18-037233	3	< 0.1%
Other values (9022)	9929	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	16412	18.3%
1	16410	18.3%
8	13784	15.4%
-	9971	11.1%
2	6484	7.2%
3	6006	6.7%
4	4784	5.3%
5	4090	4.6%
6	4000	4.5%
7	3949	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79768	88.9%
Dash Punctuation	9971	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16412	20.6%
1	16410	20.6%
8	13784	17.3%
2	6484	8.1%
3	6006	7.5%
4	4784	6.0%
5	4090	5.1%
6	4000	5.0%
7	3949	5.0%
9	3849	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	9971	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	89739	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16412	18.3%
1	16410	18.3%
8	13784	15.4%
-	9971	11.1%
2	6484	7.2%
3	6006	6.7%
4	4784	5.3%
5	4090	4.6%
6	4000	4.5%
7	3949	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	89739	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16412	18.3%
1	16410	18.3%
8	13784	15.4%
-	9971	11.1%
2	6484	7.2%
3	6006	6.7%
4	4784	5.3%
5	4090	4.6%
6	4000	4.5%
7	3949	4.4%

종류코드
Categorical

HIGH CORRELATION

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

<NA>	7036
1	2964

Length

Max length	4
Median length	4
Mean length	3.1108
Min length	1

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>	7036	70.4%
1	2964	29.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	7036	70.4%
1	2964	29.6%

공사형태 (공통)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	9
Distinct (%)	0.1%
Missing	704
Missing (%)	7.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1968589

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	5
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.1102416
Coefficient of variation (CV)	0.50281454
Kurtosis	1.4394481
Mean	4.1968589
Median Absolute Deviation (MAD)	0
Skewness	0.54628749
Sum	39014
Variance	4.4531198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	4658	46.6%
1	1861	18.6%
4	1661	16.6%
3	555	5.5%
10	544	5.4%
6	8	0.1%
9	6	0.1%
2	2	< 0.1%
8	1	< 0.1%
(Missing)	704	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1861	18.6%
2	2	< 0.1%
3	555	5.5%
4	1661	16.6%
5	4658	46.6%
6	8	0.1%
8	1	< 0.1%
9	6	0.1%
10	544	5.4%

Value	Count	Frequency (%)
10	544	5.4%
9	6	0.1%
8	1	< 0.1%
6	8	0.1%
5	4658	46.6%
4	1661	16.6%
3	555	5.5%
2	2	< 0.1%
1	1861	18.6%

Heatmap
Table

	상태 (공통)	방향	고가 (공통)	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	이력ID	공사형태 (공통)
상태 (공통)	1.000	0.029	0.000	0.000	0.013	0.000	0.076	0.060	0.000	0.005	0.000	NaN	NaN	0.049	0.073
방향	0.029	1.000	0.035	0.295	0.283	0.283	0.045	0.059	0.091	0.202	0.113	0.217	0.216	0.109	0.068
고가 (공통)	0.000	0.035	1.000	0.067	0.063	0.055	0.000	0.008	0.015	0.106	0.000	0.000	0.000	0.019	0.044
구경찰서코드 (공통)	0.000	0.295	0.067	1.000	0.925	0.995	0.165	0.098	0.194	0.762	0.391	0.415	0.424	0.160	0.159
구코드 (공통)	0.013	0.283	0.063	0.925	1.000	0.937	0.153	0.095	0.123	0.948	0.439	0.489	0.502	0.223	0.173
신경찰서코드 (공통)	0.000	0.283	0.055	0.995	0.937	1.000	0.128	0.098	0.164	0.783	0.391	0.415	0.424	0.159	0.145
작업구분 (공통)	0.076	0.045	0.000	0.165	0.153	0.128	1.000	0.642	0.088	0.075	0.102	0.717	0.734	0.388	0.270
표출구분 (공통)	0.060	0.059	0.008	0.098	0.095	0.098	0.642	1.000	0.089	0.095	0.058	0.125	0.127	0.427	0.316
도로구분 (공통)	0.000	0.091	0.015	0.194	0.123	0.164	0.088	0.089	1.000	0.138	0.174	0.283	0.245	0.178	0.169
관할사업소 (공통)	0.005	0.202	0.106	0.762	0.948	0.783	0.075	0.095	0.138	1.000	0.349	0.395	0.417	0.218	0.182
신규정규화ID	0.000	0.113	0.000	0.391	0.439	0.391	0.102	0.058	0.174	0.349	1.000	0.262	0.293	0.121	0.117
설치일	NaN	0.217	0.000	0.415	0.489	0.415	0.717	0.125	0.283	0.395	0.262	1.000	0.998	0.277	0.140
교체일	NaN	0.216	0.000	0.424	0.502	0.424	0.734	0.127	0.245	0.417	0.293	0.998	1.000	0.271	0.181
이력ID	0.049	0.109	0.019	0.160	0.223	0.159	0.388	0.427	0.178	0.218	0.121	0.277	0.271	1.000	0.357
공사형태 (공통)	0.073	0.068	0.044	0.159	0.173	0.145	0.270	0.316	0.169	0.182	0.117	0.140	0.181	0.357	1.000

Heatmap
Table

	표출구분 (공통)	고가 (공통)	작업구분 (공통)	종류코드	상태 (공통)	도로구분 (공통)
표출구분 (공통)	1.000	0.014	0.771	1.000	0.039	0.057
고가 (공통)	0.014	1.000	0.000	1.000	0.000	0.026
작업구분 (공통)	0.771	0.000	1.000	1.000	0.093	0.107
종류코드	1.000	1.000	1.000	1.000	1.000	1.000
상태 (공통)	0.039	0.000	0.093	1.000	1.000	0.000
도로구분 (공통)	0.057	0.026	0.107	1.000	0.000	1.000

Heatmap
Table

	방향	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	이력ID	공사형태 (공통)	상태 (공통)	고가 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	종류코드
방향	1.000	-0.011	0.013	-0.027	-0.008	-0.014	-0.002	-0.006	-0.038	0.009	0.022	0.029	0.021	0.045	0.070	1.000
구경찰서코드 (공통)	-0.011	1.000	0.488	0.931	-0.352	0.222	0.084	0.066	-0.006	-0.000	0.000	0.039	0.069	0.075	0.149	1.000
구코드 (공통)	0.013	0.488	1.000	0.494	-0.670	0.019	0.034	0.016	0.014	0.053	0.010	0.037	0.064	0.073	0.095	1.000
신경찰서코드 (공통)	-0.027	0.931	0.494	1.000	-0.332	0.222	0.084	0.066	0.001	0.002	0.000	0.032	0.054	0.075	0.126	1.000
관할사업소 (공통)	-0.008	-0.352	-0.670	-0.332	1.000	0.440	-0.001	0.030	0.010	-0.027	0.003	0.044	0.051	0.068	0.099	1.000
신규정규화ID	-0.014	0.222	0.019	0.222	0.440	1.000	0.072	0.103	0.030	-0.002	0.000	0.000	0.078	0.044	0.133	1.000
설치일	-0.002	0.084	0.034	0.084	-0.001	0.072	1.000	0.944	0.070	-0.068	1.000	0.000	0.566	0.087	0.215	1.000
교체일	-0.006	0.066	0.016	0.066	0.030	0.103	0.944	1.000	0.054	-0.025	1.000	0.000	0.582	0.087	0.186	1.000
이력ID	-0.038	-0.006	0.014	0.001	0.010	0.030	0.070	0.054	1.000	-0.092	0.049	0.008	0.236	0.427	0.177	1.000
공사형태 (공통)	0.009	-0.000	0.053	0.002	-0.027	-0.002	-0.068	-0.025	-0.092	1.000	0.073	0.019	0.159	0.316	0.169	1.000
상태 (공통)	0.022	0.000	0.010	0.000	0.003	0.000	1.000	1.000	0.049	0.073	1.000	0.000	0.093	0.039	0.000	1.000
고가 (공통)	0.029	0.039	0.037	0.032	0.044	0.000	0.000	0.000	0.008	0.019	0.000	1.000	0.000	0.014	0.026	1.000
작업구분 (공통)	0.021	0.069	0.064	0.054	0.051	0.078	0.566	0.582	0.236	0.159	0.093	0.000	1.000	0.771	0.107	1.000
표출구분 (공통)	0.045	0.075	0.073	0.075	0.068	0.044	0.087	0.087	0.427	0.316	0.039	0.014	0.771	1.000	0.057	1.000
도로구분 (공통)	0.070	0.149	0.095	0.126	0.099	0.133	0.215	0.186	0.177	0.169	0.000	0.026	0.107	0.057	1.000	1.000
종류코드	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.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

	상태 (공통)	횡단보도예고표시 관리번호	방향	고가 (공통)	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	공간데이터	이력ID	공사관리번호	구관리번호	종류코드	공사형태 (공통)
8907	1	18-0000007245	10	1	280	680	280	4	1	1	106	<NA>	<NA>	<NA>	<NA>	9344	2005-1108-015	18-007245	<NA>	1
62729	1	18-0000030997	287	1	330	530	330	1	2	2	104	194193	20161231	20161231	<NA>	16690	2016-0507-002	18-030997	<NA>	5
31870	1	18-0000010434	330	1	180	200	180	4	1	1	109	<NA>	<NA>	<NA>	<NA>	41341	2005-0108-091	18-010434	<NA>	5
31827	1	18-0000033135	47	1	250	300	250	4	1	1	107	<NA>	<NA>	<NA>	<NA>	43637	2009-1108-078	18-033135	<NA>	1
21487	1	18-0000000272	39	1	140	410	140	2	1	2	108	<NA>	<NA>	<NA>	<NA>	25569	2010-0104-001	18-000272	<NA>	5
52184	1	18-0000040138	59	1	170	560	170	4	1	1	104	<NA>	<NA>	<NA>	<NA>	70034	2012-1008-046	18-040138	<NA>	4
4905	1	18-0000009032	163	1	230	200	180	4	1	1	109	<NA>	<NA>	<NA>	<NA>	6931	2009-1004-002	18-009032	<NA>	4
34648	1	18-0000019311	20	1	280	680	410	1	1	1	106	<NA>	<NA>	<NA>	<NA>	44698	2011-0108-123	18-019311	<NA>	4
21864	1	18-0000022795	90	1	130	140	130	4	1	1	108	<NA>	<NA>	<NA>	<NA>	28644	2011-0108-121	18-022795	<NA>	5
34475	1	18-0000008116	332	1	360	710	360	1	2	2	106	6127669	20191231	20191231	<NA>	21714	2019-1407-002	18-008116	1	5

	상태 (공통)	횡단보도예고표시 관리번호	방향	고가 (공통)	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	공간데이터	이력ID	공사관리번호	구관리번호	종류코드	공사형태 (공통)
54569	1	18-0000023730	32	1	260	540	260	1	1	2	105	2100903	<NA>	<NA>	<NA>	73796	2011-0108-108	18-023730	<NA>	3
25264	1	18-0000023811	231	1	260	620	260	4	1	2	105	<NA>	<NA>	<NA>	<NA>	30772	2004-1108-133	18-023811	<NA>	1
33686	1	18-0000014166	106	1	320	290	320	3	2	1	107	<NA>	<NA>	<NA>	<NA>	42714	2009-1108-165	18-014166	1	10
43828	1	18-0000024156	193	1	180	200	180	4	1	1	109	<NA>	<NA>	<NA>	<NA>	58147	2011-0108-142	18-024156	<NA>	4
48248	1	18-0000016591	303	1	260	620	290	3	2	2	105	<NA>	<NA>	<NA>	<NA>	65594	2011-1208-001	18-016591	1	5
33720	1	18-0000019363	357	1	310	740	310	1	2	2	106	<NA>	<NA>	<NA>	<NA>	43431	2008-0108-453	18-019363	1	5
33733	1	18-0000025088	315	1	170	560	170	4	1	1	104	<NA>	<NA>	<NA>	<NA>	43444	2008-1108-042	18-025088	<NA>	1
831	1	18-0000023286	185	1	250	300	250	4	1	1	107	<NA>	<NA>	<NA>	<NA>	10370	2009-1108-069	18-023286	<NA>	4
8505	1	18-0000024156	192	1	180	200	180	4	1	1	109	<NA>	<NA>	<NA>	<NA>	9228	2011-0108-142	18-024156	<NA>	4
55151	1	18-0000041596	79	1	350	470	350	3	2	2	104	<NA>	<NA>	<NA>	<NA>	74796	2012-0108-162	18-041596	1	1

Overview

Variables

Common Values

Length

Common Values (Plot)

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

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

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

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample