gimi9 Pandas Profiling

Dataset statistics

Number of variables	19
Number of observations	10000
Missing cells	41549
Missing cells (%)	21.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	176.0 B

Variable types

Categorical	6
Text	3
Numeric	9
Unsupported	1

Dataset

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

Alerts

`구경찰서코드 (공통)` is highly overall correlated with `신경찰서코드 (공통)`	High correlation
`구코드 (공통)` is highly overall correlated with `관할사업소 (공통)`	High correlation
`신경찰서코드 (공통)` is highly overall correlated with `구경찰서코드 (공통)`	High correlation
`관할사업소 (공통)` is highly overall correlated with `구코드 (공통)`	High correlation
`신규정규화ID` is highly overall correlated with `상태 (공통)` and 1 other fields	High correlation
`설치일` is highly overall correlated with `교체일` and 4 other fields	High correlation
`교체일` is highly overall correlated with `설치일` and 4 other fields	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 `신규정규화ID` and 2 other fields	High correlation
`고가 (공통)` is highly overall correlated with `신규정규화ID` and 2 other fields	High correlation
`작업구분` is highly overall correlated with `설치일` and 2 other fields	High correlation
`표출구분 (공통)` is highly overall correlated with `공사형태 (공통)` and 1 other fields	High correlation
`상태 (공통)` is highly imbalanced (99.6%)	Imbalance
`고가 (공통)` is highly imbalanced (99.7%)	Imbalance
`도로구분 (공통)` is highly imbalanced (66.8%)	Imbalance
`신규정규화ID` has 8113 (81.1%) missing values	Missing
`설치일` has 8145 (81.5%) missing values	Missing
`교체일` has 8152 (81.5%) missing values	Missing
`공간데이터` has 10000 (100.0%) missing values	Missing
`공사관리번호` has 3546 (35.5%) missing values	Missing
`험프관리번호.1` has 133 (1.3%) missing values	Missing
`공사형태 (공통)` has 3299 (33.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-03 20:59:57.905520
Analysis finished	2024-05-03 21:00:34.297912
Duration	36.39 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	9995
4	4
2	1

Length

Max length	1
Median length	1
Mean length	1
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	9995	> 99.9%
4	4	< 0.1%
2	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9995	> 99.9%
4	4	< 0.1%
2	1	< 0.1%

험프관리번호
Text

Distinct	8896
Distinct (%)	89.0%
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	8038 ?
Unique (%)	80.4%

Sample

1st row	16-0000020505
2nd row	16-0000011707
3rd row	16-0000005822
4th row	16-0000007512
5th row	16-0000004429

Value	Count	Frequency (%)
16-0000006432	25	0.2%
16-0000004189	21	0.2%
16-0000001624	19	0.2%
16-0000005186	19	0.2%
16-0000001950	9	0.1%
16-0000007238	8	0.1%
16-0000006106	6	0.1%
16-0000008137	6	0.1%
16-0000005067	6	0.1%
16-0000002557	5	< 0.1%
Other values (8886)	9876	98.8%

Most occurring characters

Value	Count	Frequency (%)
0	60072	46.2%
1	17758	13.7%
6	14015	10.8%
-	10000	7.7%
2	4318	3.3%
5	4083	3.1%
4	4078	3.1%
3	4048	3.1%
8	3939	3.0%
7	3898	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	60072	50.1%
1	17758	14.8%
6	14015	11.7%
2	4318	3.6%
5	4083	3.4%
4	4078	3.4%
3	4048	3.4%
8	3939	3.3%
7	3898	3.2%
9	3791	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	60072	46.2%
1	17758	13.7%
6	14015	10.8%
-	10000	7.7%
2	4318	3.3%
5	4083	3.1%
4	4078	3.1%
3	4048	3.1%
8	3939	3.0%
7	3898	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	60072	46.2%
1	17758	13.7%
6	14015	10.8%
-	10000	7.7%
2	4318	3.3%
5	4083	3.1%
4	4078	3.1%
3	4048	3.1%
8	3939	3.0%
7	3898	3.0%

고가 (공통)
Categorical

HIGH CORRELATION IMBALANCE

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

1	9996
<NA>	2
2	1
3	1

Length

Max length	4
Median length	1
Mean length	1.0006
Min length	1

Unique

Unique	2 ?
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	9996	> 99.9%
<NA>	2	< 0.1%
2	1	< 0.1%
3	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9996	> 99.9%
na	2	< 0.1%
2	1	< 0.1%
3	1	< 0.1%

유형
Categorical

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

2	6333
1	3667

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2	6333	63.3%
1	3667	36.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	6333	63.3%
1	3667	36.7%

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

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	57
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	278.59499

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	290
Q3	350
95-th percentile	400
Maximum	410
Range	300
Interquartile range (IQR)	140

Descriptive statistics

Standard deviation	82.509469
Coefficient of variation (CV)	0.29616279
Kurtosis	-1.1517866
Mean	278.59499
Median Absolute Deviation (MAD)	70
Skewness	-0.22004754
Sum	2770070
Variance	6807.8125
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
340	665	6.7%
210	640	6.4%
330	634	6.3%
360	497	5.0%
140	451	4.5%
250	444	4.4%
370	433	4.3%
390	430	4.3%
170	430	4.3%
350	422	4.2%
Other values (21)	4897	49.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	77	0.8%
120	127	1.3%
130	79	0.8%
140	451	4.5%
150	67	0.7%
160	211	2.1%
170	430	4.3%
180	300	3.0%
190	238	2.4%
200	177	1.8%

Value	Count	Frequency (%)
410	227	2.3%
400	342	3.4%
390	430	4.3%
380	264	2.6%
370	433	4.3%
360	497	5.0%
350	422	4.2%
340	665	6.7%
330	634	6.3%
320	243	2.4%

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

HIGH CORRELATION

Distinct	25
Distinct (%)	0.3%
Missing	25
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	449.32231

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	170
Q1	300
median	440
Q3	590
95-th percentile	710
Maximum	740
Range	630
Interquartile range (IQR)	290

Descriptive statistics

Standard deviation	173.15142
Coefficient of variation (CV)	0.38536128
Kurtosis	-1.0334982
Mean	449.32231
Median Absolute Deviation (MAD)	140
Skewness	-0.059694629
Sum	4481990
Variance	29981.414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
650	914	9.1%
380	660	6.6%
440	634	6.3%
530	623	6.2%
350	538	5.4%
410	537	5.4%
710	525	5.2%
560	516	5.2%
680	480	4.8%
290	448	4.5%
Other values (15)	4100	41.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	209	2.1%
140	228	2.3%
170	213	2.1%
200	299	3.0%
210	267	2.7%
230	181	1.8%
260	295	2.9%
290	448	4.5%
300	447	4.5%
320	282	2.8%

Value	Count	Frequency (%)
740	335	3.4%
710	525	5.2%
680	480	4.8%
650	914	9.1%
620	140	1.4%
590	235	2.4%
560	516	5.2%
540	167	1.7%
530	623	6.2%
500	377	3.8%

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

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	7
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	276.59862

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	290
Q3	350
95-th percentile	400
Maximum	410
Range	300
Interquartile range (IQR)	140

Descriptive statistics

Standard deviation	85.749584
Coefficient of variation (CV)	0.3100145
Kurtosis	-1.2178776
Mean	276.59862
Median Absolute Deviation (MAD)	70
Skewness	-0.23057468
Sum	2764050
Variance	7352.9911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
340	658	6.6%
210	634	6.3%
330	627	6.3%
140	542	5.4%
370	540	5.4%
360	529	5.3%
170	516	5.2%
250	447	4.5%
390	430	4.3%
350	425	4.2%
Other values (21)	4645	46.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	148	1.5%
120	146	1.5%
130	80	0.8%
140	542	5.4%
150	63	0.6%
160	213	2.1%
170	516	5.2%
180	299	3.0%
190	255	2.5%
200	181	1.8%

Value	Count	Frequency (%)
410	276	2.8%
400	284	2.8%
390	430	4.3%
380	256	2.6%
370	540	5.4%
360	529	5.3%
350	425	4.2%
340	658	6.6%
330	627	6.3%
320	193	1.9%

작업구분
Categorical

HIGH CORRELATION

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

<NA>	3974
1	3168
4	1736
2	743
3	236

Length

Max length	4
Median length	1
Mean length	2.1922
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	3974	39.7%
1	3168	31.7%
4	1736	17.4%
2	743	7.4%
3	236	2.4%
6	143	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	3974	39.7%
1	3168	31.7%
4	1736	17.4%
2	743	7.4%
3	236	2.4%
6	143	1.4%

표출구분 (공통)
Categorical

HIGH CORRELATION

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

2	6679
1	3321

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2	6679	66.8%
1	3321	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	6679	66.8%
1	3321	33.2%

도로구분 (공통)
Categorical

IMBALANCE

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

2	8889
1	1075
<NA>	36

Length

Max length	4
Median length	1
Mean length	1.0108
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2	8889	88.9%
1	1075	10.8%
<NA>	36	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	8889	88.9%
1	1075	10.8%
na	36	0.4%

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

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	72
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	106.45548

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	107
Q3	108
95-th percentile	109
Maximum	109
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6454779
Coefficient of variation (CV)	0.015456959
Kurtosis	-1.2465272
Mean	106.45548
Median Absolute Deviation (MAD)	1
Skewness	-0.11655029
Sum	1056890
Variance	2.7075977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
108	2279	22.8%
107	1909	19.1%
104	1762	17.6%
105	1532	15.3%
106	1409	14.1%
109	1037	10.4%
(Missing)	72	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
104	1762	17.6%
105	1532	15.3%
106	1409	14.1%
107	1909	19.1%
108	2279	22.8%
109	1037	10.4%

Value	Count	Frequency (%)
109	1037	10.4%
108	2279	22.8%
107	1909	19.1%
106	1409	14.1%
105	1532	15.3%
104	1762	17.6%

신규정규화ID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1864
Distinct (%)	98.8%
Missing	8113
Missing (%)	81.1%
Infinite	0
Infinite (%)	0.0%
Mean	4076302.6

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

Quantile statistics

Minimum	1
5-th percentile	1142608.7
Q1	2247752
median	4184522
Q3	5184723
95-th percentile	6155308
Maximum	61746610
Range	61746609
Interquartile range (IQR)	2936971

Descriptive statistics

Standard deviation	4570894.7
Coefficient of variation (CV)	1.1213335
Kurtosis	95.463539
Mean	4076302.6
Median Absolute Deviation (MAD)	1267949
Skewness	9.0318506
Sum	7.6919831 × 10⁹
Variance	2.0893078 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4	< 0.1%
45713310	3	< 0.1%
3104746	2	< 0.1%
3204885	2	< 0.1%
3204323	2	< 0.1%
3204692	2	< 0.1%
2119432	2	< 0.1%
2392502	2	< 0.1%
61379010	2	< 0.1%
5015243	2	< 0.1%
Other values (1854)	1864	18.6%
(Missing)	8113	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
184432	1	< 0.1%
190323	1	< 0.1%
191292	1	< 0.1%
191332	1	< 0.1%
191342	1	< 0.1%
191502	1	< 0.1%
192104	1	< 0.1%
192202	1	< 0.1%
192324	1	< 0.1%

Value	Count	Frequency (%)
61746610	1	< 0.1%
61564410	1	< 0.1%
61379010	2	< 0.1%
52250310	2	< 0.1%
52157410	1	< 0.1%
45713310	3	< 0.1%
44535110	2	< 0.1%
44534310	1	< 0.1%
41873610	1	< 0.1%
32964510	1	< 0.1%

설치일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	341
Distinct (%)	18.4%
Missing	8145
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	20184516

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

Quantile statistics

Minimum	20141231
5-th percentile	20151220
Q1	20170818
median	20181231
Q3	20191231
95-th percentile	20221231
Maximum	20240331
Range	99100
Interquartile range (IQR)	20413

Descriptive statistics

Standard deviation	20610.655
Coefficient of variation (CV)	0.0010211121
Kurtosis	-0.057838157
Mean	20184516
Median Absolute Deviation (MAD)	10410
Skewness	0.22605997
Sum	3.7442278 × 10¹⁰
Variance	4.2479908 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20191231	299	3.0%
20181231	128	1.3%
20201231	98	1.0%
20141231	56	0.6%
20161231	56	0.6%
20180731	52	0.5%
20151231	36	0.4%
20231231	34	0.3%
20221130	26	0.3%
20160610	25	0.2%
Other values (331)	1045	10.4%
(Missing)	8145	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20141231	56	0.6%
20150424	2	< 0.1%
20150430	1	< 0.1%
20150531	3	< 0.1%
20151007	11	0.1%
20151019	1	< 0.1%
20151031	2	< 0.1%
20151130	7	0.1%
20151207	4	< 0.1%
20151214	2	< 0.1%

Value	Count	Frequency (%)
20240331	1	< 0.1%
20240325	3	< 0.1%
20240321	2	< 0.1%
20240124	1	< 0.1%
20231231	34	0.3%
20231227	2	< 0.1%
20231222	2	< 0.1%
20231215	1	< 0.1%
20231210	2	< 0.1%
20231129	1	< 0.1%

교체일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	342
Distinct (%)	18.5%
Missing	8152
Missing (%)	81.5%
Infinite	0
Infinite (%)	0.0%
Mean	20185792

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

Quantile statistics

Minimum	20141231
5-th percentile	20151221
Q1	20170830
median	20190103
Q3	20200623
95-th percentile	20221231
Maximum	20240331
Range	99100
Interquartile range (IQR)	29793

Descriptive statistics

Standard deviation	20604.899
Coefficient of variation (CV)	0.0010207625
Kurtosis	-0.15354036
Mean	20185792
Median Absolute Deviation (MAD)	11128
Skewness	0.11809418
Sum	3.7303343 × 10¹⁰
Variance	4.2456186 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20191231	288	2.9%
20181231	123	1.2%
20201231	113	1.1%
20141231	54	0.5%
20161231	45	0.4%
20180731	44	0.4%
20200623	35	0.4%
20231231	35	0.4%
20151231	31	0.3%
20221130	26	0.3%
Other values (332)	1054	10.5%
(Missing)	8152	81.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20141231	54	0.5%
20150424	2	< 0.1%
20150430	1	< 0.1%
20150531	3	< 0.1%
20151007	11	0.1%
20151019	1	< 0.1%
20151031	2	< 0.1%
20151130	6	0.1%
20151207	4	< 0.1%
20151214	2	< 0.1%

Value	Count	Frequency (%)
20240331	1	< 0.1%
20240325	3	< 0.1%
20240124	1	< 0.1%
20231231	35	0.4%
20231227	2	< 0.1%
20231222	2	< 0.1%
20231215	1	< 0.1%
20231210	2	< 0.1%
20231124	1	< 0.1%
20231106	3	< 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	23107.732

Minimum	2
Maximum	58305
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2
5-th percentile	1261.9
Q1	6321
median	12799.5
Q3	51779.5
95-th percentile	57050.2
Maximum	58305
Range	58303
Interquartile range (IQR)	45458.5

Descriptive statistics

Standard deviation	21584.105
Coefficient of variation (CV)	0.93406419
Kurtosis	-1.3532458
Mean	23107.732
Median Absolute Deviation (MAD)	8110.5
Skewness	0.68381913
Sum	2.3107732 × 10⁸
Variance	4.6587358 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
58101	1	< 0.1%
14919	1	< 0.1%
13400	1	< 0.1%
56201	1	< 0.1%
52957	1	< 0.1%
16816	1	< 0.1%
2163	1	< 0.1%
11145	1	< 0.1%
12289	1	< 0.1%
3176	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
11	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%
17	1	< 0.1%

Value	Count	Frequency (%)
58305	1	< 0.1%
58301	1	< 0.1%
58300	1	< 0.1%
58298	1	< 0.1%
58296	1	< 0.1%
58290	1	< 0.1%
58287	1	< 0.1%
58286	1	< 0.1%
58284	1	< 0.1%
58283	1	< 0.1%

공사관리번호
Text

MISSING

Distinct	610
Distinct (%)	9.5%
Missing	3546
Missing (%)	35.5%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	83902
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	245 ?
Unique (%)	3.8%

Sample

1st row	2003-1108-263
2nd row	2000-0000-000
3rd row	2000-0000-000
4th row	2000-0000-000
5th row	2000-0000-000

Value	Count	Frequency (%)
2000-0000-000	4181	64.8%
2019-0107-009	47	0.7%
2014-0107-150	47	0.7%
2007-0108-008	44	0.7%
2003-1108-222	42	0.7%
2018-1407-010	41	0.6%
2018-0107-006	37	0.6%
2020-0107-023	35	0.5%
2019-0107-049	31	0.5%
2012-0512-002	26	0.4%
Other values (600)	1923	29.8%

Most occurring characters

Value	Count	Frequency (%)
0	51515	61.4%
-	12908	15.4%
2	8190	9.8%
1	4468	5.3%
7	2140	2.6%
8	1179	1.4%
9	907	1.1%
4	806	1.0%
3	676	0.8%
5	573	0.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	70994	84.6%
Dash Punctuation	12908	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	51515	72.6%
2	8190	11.5%
1	4468	6.3%
7	2140	3.0%
8	1179	1.7%
9	907	1.3%
4	806	1.1%
3	676	1.0%
5	573	0.8%
6	540	0.8%

Dash Punctuation

Value	Count	Frequency (%)
-	12908	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	83902	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	51515	61.4%
-	12908	15.4%
2	8190	9.8%
1	4468	5.3%
7	2140	2.6%
8	1179	1.4%
9	907	1.1%
4	806	1.0%
3	676	0.8%
5	573	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	83902	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	51515	61.4%
-	12908	15.4%
2	8190	9.8%
1	4468	5.3%
7	2140	2.6%
8	1179	1.4%
9	907	1.1%
4	806	1.0%
3	676	0.8%
5	573	0.7%

험프관리번호.1
Text

MISSING

Distinct	8772
Distinct (%)	88.9%
Missing	133
Missing (%)	1.3%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	88803
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	7923 ?
Unique (%)	80.3%

Sample

1st row	16-020505
2nd row	16-011707
3rd row	16-005822
4th row	16-007512
5th row	16-004429

Value	Count	Frequency (%)
16-006432	25	0.3%
16-004189	21	0.2%
16-001624	19	0.2%
16-005186	19	0.2%
16-001950	9	0.1%
16-007238	8	0.1%
16-006106	6	0.1%
16-005067	6	0.1%
16-008137	6	0.1%
16-000748	5	0.1%
Other values (8762)	9743	98.7%

Most occurring characters

Value	Count	Frequency (%)
0	19833	22.3%
1	17498	19.7%
6	13838	15.6%
-	9867	11.1%
2	4265	4.8%
5	4029	4.5%
4	3980	4.5%
3	3977	4.5%
8	3909	4.4%
7	3857	4.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	78936	88.9%
Dash Punctuation	9867	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19833	25.1%
1	17498	22.2%
6	13838	17.5%
2	4265	5.4%
5	4029	5.1%
4	3980	5.0%
3	3977	5.0%
8	3909	5.0%
7	3857	4.9%
9	3750	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	9867	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	88803	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19833	22.3%
1	17498	19.7%
6	13838	15.6%
-	9867	11.1%
2	4265	4.8%
5	4029	4.5%
4	3980	4.5%
3	3977	4.5%
8	3909	4.4%
7	3857	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	88803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	19833	22.3%
1	17498	19.7%
6	13838	15.6%
-	9867	11.1%
2	4265	4.8%
5	4029	4.5%
4	3980	4.5%
3	3977	4.5%
8	3909	4.4%
7	3857	4.3%

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

HIGH CORRELATION MISSING

Distinct	7
Distinct (%)	0.1%
Missing	3299
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2630951

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	1
median	4
Q3	4
95-th percentile	5
Maximum	10
Range	9
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.8492904
Coefficient of variation (CV)	0.56672895
Kurtosis	1.2051209
Mean	3.2630951
Median Absolute Deviation (MAD)	1
Skewness	0.51675438
Sum	21866
Variance	3.4198751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	2203	22.0%
1	2196	22.0%
5	1536	15.4%
3	617	6.2%
10	119	1.2%
2	19	0.2%
9	11	0.1%
(Missing)	3299	33.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2196	22.0%
2	19	0.2%
3	617	6.2%
4	2203	22.0%
5	1536	15.4%
9	11	0.1%
10	119	1.2%

Value	Count	Frequency (%)
10	119	1.2%
9	11	0.1%
5	1536	15.4%
4	2203	22.0%
3	617	6.2%
2	19	0.2%
1	2196	22.0%

Heatmap
Table

	상태 (공통)	고가 (공통)	유형	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	이력ID	공사형태 (공통)
상태 (공통)	1.000	0.000	0.001	0.028	0.049	0.022	0.001	0.002	0.000	0.044	0.536	NaN	NaN	0.014	0.024
고가 (공통)	0.000	1.000	0.000	0.000	0.013	0.000	0.000	0.000	0.000	0.000	NaN	NaN	NaN	0.000	0.000
유형	0.001	0.000	1.000	0.338	0.512	0.344	0.172	0.181	0.067	0.485	0.029	0.243	0.229	0.301	0.444
구경찰서코드 (공통)	0.028	0.000	0.338	1.000	0.927	0.998	0.296	0.168	0.131	0.759	0.360	0.692	0.701	0.295	0.249
구코드 (공통)	0.049	0.013	0.512	0.927	1.000	0.939	0.290	0.225	0.139	0.953	0.370	0.584	0.592	0.403	0.354
신경찰서코드 (공통)	0.022	0.000	0.344	0.998	0.939	1.000	0.296	0.152	0.134	0.778	0.360	0.686	0.694	0.293	0.247
작업구분	0.001	0.000	0.172	0.296	0.290	0.296	1.000	0.745	0.032	0.159	0.186	0.497	0.497	0.495	0.319
표출구분 (공통)	0.002	0.000	0.181	0.168	0.225	0.152	0.745	1.000	0.000	0.217	0.000	0.165	0.178	0.602	0.605
도로구분 (공통)	0.000	0.000	0.067	0.131	0.139	0.134	0.032	0.000	1.000	0.126	0.007	0.198	0.216	0.176	0.087
관할사업소 (공통)	0.044	0.000	0.485	0.759	0.953	0.778	0.159	0.217	0.126	1.000	0.335	0.391	0.400	0.429	0.270
신규정규화ID	0.536	NaN	0.029	0.360	0.370	0.360	0.186	0.000	0.007	0.335	1.000	0.296	0.306	0.020	0.000
설치일	NaN	NaN	0.243	0.692	0.584	0.686	0.497	0.165	0.198	0.391	0.296	1.000	0.999	0.678	0.452
교체일	NaN	NaN	0.229	0.701	0.592	0.694	0.497	0.178	0.216	0.400	0.306	0.999	1.000	0.651	0.491
이력ID	0.014	0.000	0.301	0.295	0.403	0.293	0.495	0.602	0.176	0.429	0.020	0.678	0.651	1.000	0.298
공사형태 (공통)	0.024	0.000	0.444	0.249	0.354	0.247	0.319	0.605	0.087	0.270	0.000	0.452	0.491	0.298	1.000

Heatmap
Table

	상태 (공통)	유형	작업구분	도로구분 (공통)	표출구분 (공통)	고가 (공통)
상태 (공통)	1.000	0.002	0.001	0.000	0.004	0.000
유형	0.002	1.000	0.211	0.043	0.116	0.000
작업구분	0.001	0.211	1.000	0.039	0.879	0.000
도로구분 (공통)	0.000	0.043	0.039	1.000	0.000	0.000
표출구분 (공통)	0.004	0.116	0.879	0.000	1.000	0.000
고가 (공통)	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	이력ID	공사형태 (공통)	상태 (공통)	고가 (공통)	유형	작업구분	표출구분 (공통)	도로구분 (공통)
구경찰서코드 (공통)	1.000	0.410	0.954	-0.352	0.419	0.076	0.062	0.115	-0.026	0.017	0.000	0.259	0.127	0.129	0.101
구코드 (공통)	0.410	1.000	0.412	-0.682	-0.140	0.022	0.010	0.084	-0.124	0.029	0.008	0.394	0.124	0.172	0.107
신경찰서코드 (공통)	0.954	0.412	1.000	-0.342	0.414	0.076	0.061	0.126	-0.021	0.013	0.000	0.264	0.127	0.116	0.103
관할사업소 (공통)	-0.352	-0.682	-0.342	1.000	0.407	-0.111	-0.119	-0.107	0.007	0.018	0.000	0.350	0.108	0.156	0.091
신규정규화ID	0.419	-0.140	0.414	0.407	1.000	0.085	0.022	0.095	-0.039	0.574	1.000	0.032	0.134	0.000	0.008
설치일	0.076	0.022	0.076	-0.111	0.085	1.000	0.922	0.566	0.064	1.000	1.000	0.202	0.790	0.128	0.158
교체일	0.062	0.010	0.061	-0.119	0.022	0.922	1.000	0.514	0.119	1.000	1.000	0.191	0.791	0.139	0.170
이력ID	0.115	0.084	0.126	-0.107	0.095	0.566	0.514	1.000	-0.133	0.006	0.000	0.216	0.203	0.438	0.126
공사형태 (공통)	-0.026	-0.124	-0.021	0.007	-0.039	0.064	0.119	-0.133	1.000	0.016	0.000	0.476	0.210	0.651	0.093
상태 (공통)	0.017	0.029	0.013	0.018	0.574	1.000	1.000	0.006	0.016	1.000	0.000	0.002	0.001	0.004	0.000
고가 (공통)	0.000	0.008	0.000	0.000	1.000	1.000	1.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000
유형	0.259	0.394	0.264	0.350	0.032	0.202	0.191	0.216	0.476	0.002	0.000	1.000	0.211	0.116	0.043
작업구분	0.127	0.124	0.127	0.108	0.134	0.790	0.791	0.203	0.210	0.001	0.000	0.211	1.000	0.879	0.039
표출구분 (공통)	0.129	0.172	0.116	0.156	0.000	0.128	0.139	0.438	0.651	0.004	0.000	0.116	0.879	1.000	0.000
도로구분 (공통)	0.101	0.107	0.103	0.091	0.008	0.158	0.170	0.126	0.093	0.000	0.000	0.043	0.039	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	상태 (공통)	험프관리번호	고가 (공통)	유형	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	공간데이터	이력ID	공사관리번호	험프관리번호.1	공사형태 (공통)
25078	1	16-0000020505	1	2	270	260	270	<NA>	2	2	109	<NA>	<NA>	<NA>	<NA>	58101	<NA>	16-020505	4
15297	1	16-0000011707	1	1	170	560	170	1	2	2	105	2158203	20151214	20151214	<NA>	16908	<NA>	16-011707	4
6308	1	16-0000005822	1	2	350	470	350	4	1	2	104	<NA>	<NA>	<NA>	<NA>	3169	2003-1108-263	16-005822	1
10238	1	16-0000007512	1	2	360	710	360	4	1	2	106	<NA>	<NA>	<NA>	<NA>	9244	2000-0000-000	16-007512	<NA>
6756	1	16-0000004429	1	2	320	290	320	<NA>	2	2	107	<NA>	<NA>	<NA>	<NA>	4087	2000-0000-000	16-004429	4
12212	1	16-0000000094	1	1	390	380	390	2	1	2	108	<NA>	<NA>	<NA>	<NA>	9759	2000-0000-000	16-000094	<NA>
16849	1	16-0000013563	1	2	320	290	320	1	2	2	107	4368121	20180808	20180808	<NA>	51155	<NA>	16-013563	4
13575	1	16-0000006432	1	2	230	210	230	4	1	2	109	<NA>	<NA>	<NA>	<NA>	11243	<NA>	16-006432	5
5149	1	16-0000001231	1	1	210	440	210	1	2	2	108	2279672	<NA>	<NA>	<NA>	2048	2000-0000-000	16-001231	5
14952	1	16-0000012634	1	2	220	590	220	1	2	2	105	2175431	20170727	20170727	<NA>	50204	<NA>	16-012634	4

	상태 (공통)	험프관리번호	고가 (공통)	유형	구경찰서코드 (공통)	구코드 (공통)	신경찰서코드 (공통)	작업구분	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	신규정규화ID	설치일	교체일	공간데이터	이력ID	공사관리번호	험프관리번호.1	공사형태 (공통)
22670	1	16-0000018183	1	2	220	590	220	<NA>	2	1	105	<NA>	<NA>	<NA>	<NA>	55779	<NA>	16-018183	4
5170	1	16-0000003718	1	2	410	710	360	4	1	2	106	<NA>	<NA>	<NA>	<NA>	2447	2000-0000-000	16-003718	<NA>
14580	1	16-0000007728	1	2	390	380	390	3	2	2	108	<NA>	<NA>	<NA>	<NA>	12250	<NA>	16-007728	5
16834	1	16-0000013753	1	1	270	260	270	1	2	2	109	5354451	20181105	20181105	<NA>	51349	<NA>	16-013753	1
13876	1	16-0000007125	1	2	390	380	390	2	1	2	108	<NA>	<NA>	<NA>	<NA>	11700	2000-0000-000	16-007125	<NA>
24948	1	16-0000020182	1	1	340	650	340	<NA>	2	2	105	<NA>	<NA>	<NA>	<NA>	57778	<NA>	16-020182	1
24230	1	16-0000019078	1	1	340	650	340	<NA>	2	2	106	<NA>	<NA>	<NA>	<NA>	56674	<NA>	16-019078	1
13828	1	16-0000002512	1	1	150	110	150	2	1	2	107	<NA>	<NA>	<NA>	<NA>	10920	2000-0000-000	16-002512	<NA>
2624	1	16-0000010661	1	1	280	680	280	3	2	1	106	<NA>	<NA>	<NA>	<NA>	15943	<NA>	16-010661	4
18468	1	16-0000014650	1	1	120	110	120	<NA>	2	2	107	<NA>	<NA>	<NA>	<NA>	52246	<NA>	<NA>	4

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)

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

Interactions

Correlations

Missing values

Sample