gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	10000
Missing cells	36055
Missing cells (%)	20.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	167.0 B

Variable types

Text	3
Categorical	6
Numeric	8
Unsupported	1

Dataset

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

Alerts

`구경찰서코드 (공통)` is highly overall correlated with `신경찰서코드 (공통)` and 1 other fields	High correlation
`신경찰서코드 (공통)` is highly overall correlated with `구경찰서코드 (공통)` and 1 other fields	High correlation
`관할사업소 (공통)` is highly overall correlated with `구코드 (공통)`	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 `설치일` and 2 other fields	High correlation
`이력ID` is highly overall correlated with `표출구분 (공통)`	High correlation
`상태 (공통)` is highly overall correlated with `설치일` and 1 other fields	High correlation
`작업구분 (공통)` is highly overall correlated with `설치일` and 2 other fields	High correlation
`표출구분 (공통)` is highly overall correlated with `이력ID` and 1 other fields	High correlation
`상태 (공통)` is highly imbalanced (98.3%)	Imbalance
`고가 (공통)` is highly imbalanced (97.0%)	Imbalance
`도로구분 (공통)` is highly imbalanced (60.0%)	Imbalance
`안전지대종류코드` is highly imbalanced (70.9%)	Imbalance
`구코드 (공통)` has 111 (1.1%) missing values	Missing
`신규정규화ID` has 7655 (76.5%) missing values	Missing
`설치일` has 8866 (88.7%) missing values	Missing
`교체일` has 8856 (88.6%) missing values	Missing
`공간데이터` has 10000 (100.0%) missing values	Missing
`공사관리번호` has 353 (3.5%) 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:10:18.820427
Analysis finished	2024-05-03 20:10:49.388623
Duration	30.57 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

안전지대관리번호
Text

Distinct	7031
Distinct (%)	70.3%
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	5548 ?
Unique (%)	55.5%

Sample

1st row	14-0000017374
2nd row	14-0000012116
3rd row	14-0000002357
4th row	14-0000012771
5th row	14-0000017998

Value	Count	Frequency (%)
14-0000002181	74	0.7%
14-0000000218	70	0.7%
14-0000009600	61	0.6%
14-0000007543	51	0.5%
14-0000003155	46	0.5%
14-0000004095	44	0.4%
14-0000004616	33	0.3%
14-0000003262	32	0.3%
14-0000003452	28	0.3%
14-0000008723	27	0.3%
Other values (7021)	9534	95.3%

Most occurring characters

Value	Count	Frequency (%)
0	59685	45.9%
1	18247	14.0%
4	14132	10.9%
-	10000	7.7%
2	5390	4.1%
3	4100	3.2%
5	3865	3.0%
8	3760	2.9%
6	3714	2.9%
9	3603	2.8%

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	59685	49.7%
1	18247	15.2%
4	14132	11.8%
2	5390	4.5%
3	4100	3.4%
5	3865	3.2%
8	3760	3.1%
6	3714	3.1%
9	3603	3.0%
7	3504	2.9%

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	59685	45.9%
1	18247	14.0%
4	14132	10.9%
-	10000	7.7%
2	5390	4.1%
3	4100	3.2%
5	3865	3.0%
8	3760	2.9%
6	3714	2.9%
9	3603	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	59685	45.9%
1	18247	14.0%
4	14132	10.9%
-	10000	7.7%
2	5390	4.1%
3	4100	3.2%
5	3865	3.0%
8	3760	2.9%
6	3714	2.9%
9	3603	2.8%

상태 (공통)
Categorical

HIGH CORRELATION IMBALANCE

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

1	9973
4	26
<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	9973	99.7%
4	26	0.3%
<NA>	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9973	99.7%
4	26	0.3%
na	1	< 0.1%

고가 (공통)
Categorical

IMBALANCE

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

1	9936
2	56
3	7
<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	9936	99.4%
2	56	0.6%
3	7	0.1%
<NA>	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9936	99.4%
2	56	0.6%
3	7	0.1%
na	1	< 0.1%

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

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	45
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	258.78051

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	130
Q1	190
median	250
Q3	340
95-th percentile	400
Maximum	410
Range	300
Interquartile range (IQR)	150

Descriptive statistics

Standard deviation	84.67776
Coefficient of variation (CV)	0.32721846
Kurtosis	-1.2122756
Mean	258.78051
Median Absolute Deviation (MAD)	80
Skewness	0.093867875
Sum	2576160
Variance	7170.323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
210	699	7.0%
340	552	5.5%
160	512	5.1%
170	493	4.9%
360	461	4.6%
300	459	4.6%
330	446	4.5%
230	438	4.4%
190	410	4.1%
180	403	4.0%
Other values (21)	5082	50.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	127	1.3%
120	261	2.6%
130	189	1.9%
140	305	3.0%
150	167	1.7%
160	512	5.1%
170	493	4.9%
180	403	4.0%
190	410	4.1%
200	358	3.6%

Value	Count	Frequency (%)
410	309	3.1%
400	221	2.2%
390	253	2.5%
380	163	1.6%
370	228	2.3%
360	461	4.6%
350	307	3.1%
340	552	5.5%
330	446	4.5%
320	213	2.1%

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

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	46
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	256.44063

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	120
Q1	180
median	250
Q3	340
95-th percentile	390
Maximum	410
Range	300
Interquartile range (IQR)	160

Descriptive statistics

Standard deviation	86.263397
Coefficient of variation (CV)	0.3363874
Kurtosis	-1.2883373
Mean	256.44063
Median Absolute Deviation (MAD)	80
Skewness	0.082694195
Sum	2552610
Variance	7441.3736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
210	670	6.7%
360	625	6.2%
170	572	5.7%
160	530	5.3%
340	513	5.1%
180	483	4.8%
330	464	4.6%
300	442	4.4%
190	429	4.3%
200	378	3.8%
Other values (21)	4848	48.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	215	2.1%
120	288	2.9%
130	188	1.9%
140	318	3.2%
150	105	1.1%
160	530	5.3%
170	572	5.7%
180	483	4.8%
190	429	4.3%
200	378	3.8%

Value	Count	Frequency (%)
410	252	2.5%
400	153	1.5%
390	231	2.3%
380	180	1.8%
370	313	3.1%
360	625	6.2%
350	316	3.2%
340	513	5.1%
330	464	4.6%
320	168	1.7%

작업구분 (공통)
Categorical

HIGH CORRELATION

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

4	4871
1	3029
2	1880
6	118
3	102

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

Common Values

Value	Count	Frequency (%)
4	4871	48.7%
1	3029	30.3%
2	1880	18.8%
6	118	1.2%
3	102	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	4871	48.7%
1	3029	30.3%
2	1880	18.8%
6	118	1.2%
3	102	1.0%

표출구분 (공통)
Categorical

HIGH CORRELATION

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

1	7597
2	2403

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

Common Values

Value	Count	Frequency (%)
1	7597	76.0%
2	2403	24.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	7597	76.0%
2	2403	24.0%

도로구분 (공통)
Categorical

IMBALANCE

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

1	8472
2	1504
<NA>	24

Length

Max length	4
Median length	1
Mean length	1.0072
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	8472	84.7%
2	1504	15.0%
<NA>	24	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	8472	84.7%
2	1504	15.0%
na	24	0.2%

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

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	99
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.58994

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.6996482
Coefficient of variation (CV)	0.015945671
Kurtosis	-1.2737056
Mean	106.58994
Median Absolute Deviation (MAD)	1
Skewness	-0.15731368
Sum	1055347
Variance	2.8888038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
108	2292	22.9%
104	1657	16.6%
107	1572	15.7%
106	1487	14.9%
109	1473	14.7%
105	1420	14.2%
(Missing)	99	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
104	1657	16.6%
105	1420	14.2%
106	1487	14.9%
107	1572	15.7%
108	2292	22.9%
109	1473	14.7%

Value	Count	Frequency (%)
109	1473	14.7%
108	2292	22.9%
107	1572	15.7%
106	1487	14.9%
105	1420	14.2%
104	1657	16.6%

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

HIGH CORRELATION MISSING

Distinct	25
Distinct (%)	0.3%
Missing	111
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	426.757

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

Descriptive statistics

Standard deviation	193.11886
Coefficient of variation (CV)	0.45252651
Kurtosis	-1.3033982
Mean	426.757
Median Absolute Deviation (MAD)	180
Skewness	-0.032423863
Sum	4220200
Variance	37294.893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
650	684	6.8%
440	662	6.6%
710	613	6.1%
290	598	6.0%
560	564	5.6%
680	542	5.4%
170	530	5.3%
200	479	4.8%
530	452	4.5%
500	442	4.4%
Other values (15)	4323	43.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
110	392	3.9%
140	409	4.1%
170	530	5.3%
200	479	4.8%
210	328	3.3%
230	381	3.8%
260	242	2.4%
290	598	6.0%
300	153	1.5%
320	152	1.5%

Value	Count	Frequency (%)
740	270	2.7%
710	613	6.1%
680	542	5.4%
650	684	6.8%
620	237	2.4%
590	307	3.1%
560	564	5.6%
540	139	1.4%
530	452	4.5%
500	442	4.4%

신규정규화ID
Real number (ℝ)

MISSING

Distinct	2325
Distinct (%)	99.1%
Missing	7655
Missing (%)	76.5%
Infinite	0
Infinite (%)	0.0%
Mean	5495436.8

Minimum	180421
Maximum	72265410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	180421
5-th percentile	1154212.6
Q1	2278431
median	4076178
Q3	5199815
95-th percentile	22104230
Maximum	72265410
Range	72084989
Interquartile range (IQR)	2921384

Descriptive statistics

Standard deviation	8571414.3
Coefficient of variation (CV)	1.559733
Kurtosis	20.78668
Mean	5495436.8
Median Absolute Deviation (MAD)	1369415
Skewness	4.4533081
Sum	1.2886799 × 10¹⁰
Variance	7.3469143 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31164110	2	< 0.1%
1178802	2	< 0.1%
31150810	2	< 0.1%
50978710	2	< 0.1%
2246725	2	< 0.1%
23797710	2	< 0.1%
40872910	2	< 0.1%
50362010	2	< 0.1%
5343032	2	< 0.1%
2196965	2	< 0.1%
Other values (2315)	2325	23.2%
(Missing)	7655	76.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
180421	1	< 0.1%
180701	1	< 0.1%
182881	1	< 0.1%
190562	1	< 0.1%
191103	1	< 0.1%
191402	1	< 0.1%
191712	1	< 0.1%
191975	1	< 0.1%
192203	1	< 0.1%
192204	1	< 0.1%

Value	Count	Frequency (%)
72265410	1	< 0.1%
62872310	1	< 0.1%
62472610	1	< 0.1%
61690311	1	< 0.1%
61500710	1	< 0.1%
61472611	1	< 0.1%
61095310	1	< 0.1%
60391010	1	< 0.1%
55439310	1	< 0.1%
55410710	1	< 0.1%

설치일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	264
Distinct (%)	23.3%
Missing	8866
Missing (%)	88.7%
Infinite	0
Infinite (%)	0.0%
Mean	20183248

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

Quantile statistics

Minimum	20150131
5-th percentile	20151228
Q1	20161231
median	20180731
Q3	20200430
95-th percentile	20230324
Maximum	20240331
Range	90200
Interquartile range (IQR)	39199

Descriptive statistics

Standard deviation	23517.522
Coefficient of variation (CV)	0.0011652001
Kurtosis	-0.65259192
Mean	20183248
Median Absolute Deviation (MAD)	19500
Skewness	0.63436972
Sum	2.2887804 × 10¹⁰
Variance	5.5307386 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20151231	42	0.4%
20161230	40	0.4%
20171226	39	0.4%
20181130	34	0.3%
20191220	32	0.3%
20161231	31	0.3%
20221216	30	0.3%
20181231	25	0.2%
20181221	24	0.2%
20191231	24	0.2%
Other values (254)	813	8.1%
(Missing)	8866	88.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20150131	4	< 0.1%
20150420	4	< 0.1%
20150531	3	< 0.1%
20150630	1	< 0.1%
20150720	6	0.1%
20151020	1	< 0.1%
20151030	2	< 0.1%
20151031	2	< 0.1%
20151118	2	< 0.1%
20151130	2	< 0.1%

Value	Count	Frequency (%)
20240331	1	< 0.1%
20240124	6	0.1%
20231231	16	0.2%
20231222	2	< 0.1%
20231220	2	< 0.1%
20231215	1	< 0.1%
20231130	8	0.1%
20230817	1	< 0.1%
20230731	5	0.1%
20230727	1	< 0.1%

교체일
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	262
Distinct (%)	22.9%
Missing	8856
Missing (%)	88.6%
Infinite	0
Infinite (%)	0.0%
Mean	20186655

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

Quantile statistics

Minimum	20150131
5-th percentile	20151231
Q1	20170228
median	20181130
Q3	20210917
95-th percentile	20230613
Maximum	20240331
Range	90200
Interquartile range (IQR)	40689

Descriptive statistics

Standard deviation	24565.053
Coefficient of variation (CV)	0.0012168956
Kurtosis	-1.0921304
Mean	20186655
Median Absolute Deviation (MAD)	19900
Skewness	0.37067912
Sum	2.3093533 × 10¹⁰
Variance	6.0344181 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20221216	44	0.4%
20161230	40	0.4%
20171226	39	0.4%
20151231	36	0.4%
20191220	36	0.4%
20161231	29	0.3%
20181130	25	0.2%
20231231	25	0.2%
20191231	24	0.2%
20181221	23	0.2%
Other values (252)	823	8.2%
(Missing)	8856	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20150131	3	< 0.1%
20150420	4	< 0.1%
20150531	3	< 0.1%
20150630	1	< 0.1%
20150720	5	0.1%
20151020	1	< 0.1%
20151030	2	< 0.1%
20151031	1	< 0.1%
20151118	2	< 0.1%
20151130	1	< 0.1%

Value	Count	Frequency (%)
20240331	1	< 0.1%
20240124	6	0.1%
20231231	25	0.2%
20231222	2	< 0.1%
20231220	2	< 0.1%
20231215	1	< 0.1%
20231130	8	0.1%
20230817	1	< 0.1%
20230731	5	0.1%
20230727	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	25872.734

Minimum	4
Maximum	53793
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4
5-th percentile	2518.85
Q1	12906.5
median	25700.5
Q3	38435.75
95-th percentile	51327.1
Maximum	53793
Range	53789
Interquartile range (IQR)	25529.25

Descriptive statistics

Standard deviation	15127.971
Coefficient of variation (CV)	0.58470709
Kurtosis	-1.1169398
Mean	25872.734
Median Absolute Deviation (MAD)	12766
Skewness	0.061331029
Sum	2.5872734 × 10⁸
Variance	2.2885551 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37664	1	< 0.1%
41662	1	< 0.1%
18190	1	< 0.1%
26867	1	< 0.1%
10598	1	< 0.1%
25695	1	< 0.1%
479	1	< 0.1%
22500	1	< 0.1%
43756	1	< 0.1%
24474	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	< 0.1%
5	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
18	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
29	1	< 0.1%
31	1	< 0.1%
39	1	< 0.1%

Value	Count	Frequency (%)
53793	1	< 0.1%
53792	1	< 0.1%
53785	1	< 0.1%
53783	1	< 0.1%
53781	1	< 0.1%
53770	1	< 0.1%
53769	1	< 0.1%
53763	1	< 0.1%
53759	1	< 0.1%
53757	1	< 0.1%

공사관리번호
Text

MISSING

Distinct	1735
Distinct (%)	18.0%
Missing	353
Missing (%)	3.5%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	125411
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	724 ?
Unique (%)	7.5%

Sample

1st row	2000-0000-000
2nd row	2000-0000-000
3rd row	2010-0108-022
4th row	2009-1108-158
5th row	2012-0708-001

Value	Count	Frequency (%)
2000-0000-000	2480	25.7%
2010-0108-013	81	0.8%
2010-0708-001	76	0.8%
2009-1108-157	61	0.6%
2005-1108-141	61	0.6%
2008-0102-558	57	0.6%
2003-1108-210	54	0.6%
2007-0108-014	50	0.5%
2008-0108-953	49	0.5%
2004-0108-110	48	0.5%
Other values (1725)	6630	68.7%

Most occurring characters

Value	Count	Frequency (%)
0	54520	43.5%
-	19294	15.4%
1	15726	12.5%
2	14116	11.3%
8	7269	5.8%
7	3197	2.5%
9	2611	2.1%
4	2491	2.0%
5	2410	1.9%
3	2047	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	106117	84.6%
Dash Punctuation	19294	15.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	54520	51.4%
1	15726	14.8%
2	14116	13.3%
8	7269	6.8%
7	3197	3.0%
9	2611	2.5%
4	2491	2.3%
5	2410	2.3%
3	2047	1.9%
6	1730	1.6%

Dash Punctuation

Value	Count	Frequency (%)
-	19294	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	125411	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	54520	43.5%
-	19294	15.4%
1	15726	12.5%
2	14116	11.3%
8	7269	5.8%
7	3197	2.5%
9	2611	2.1%
4	2491	2.0%
5	2410	1.9%
3	2047	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	125411	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	54520	43.5%
-	19294	15.4%
1	15726	12.5%
2	14116	11.3%
8	7269	5.8%
7	3197	2.5%
9	2611	2.1%
4	2491	2.0%
5	2410	1.9%
3	2047	1.6%

구안전지대 관리번호
Text

Distinct	7009
Distinct (%)	70.3%
Missing	24
Missing (%)	0.2%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	89784
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	5527 ?
Unique (%)	55.4%

Sample

1st row	14-017374
2nd row	14-012116
3rd row	14-002357
4th row	14-012771
5th row	14-017998

Value	Count	Frequency (%)
14-002181	74	0.7%
14-000218	70	0.7%
14-009600	61	0.6%
14-007543	51	0.5%
14-003155	46	0.5%
14-004095	44	0.4%
14-004616	33	0.3%
14-003262	32	0.3%
14-003452	28	0.3%
14-002386	27	0.3%
Other values (6999)	9510	95.3%

Most occurring characters

Value	Count	Frequency (%)
0	19645	21.9%
1	18202	20.3%
4	14101	15.7%
-	9976	11.1%
2	5370	6.0%
3	4088	4.6%
5	3858	4.3%
8	3748	4.2%
6	3707	4.1%
9	3594	4.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79808	88.9%
Dash Punctuation	9976	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19645	24.6%
1	18202	22.8%
4	14101	17.7%
2	5370	6.7%
3	4088	5.1%
5	3858	4.8%
8	3748	4.7%
6	3707	4.6%
9	3594	4.5%
7	3495	4.4%

Dash Punctuation

Value	Count	Frequency (%)
-	9976	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	89784	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19645	21.9%
1	18202	20.3%
4	14101	15.7%
-	9976	11.1%
2	5370	6.0%
3	4088	4.6%
5	3858	4.3%
8	3748	4.2%
6	3707	4.1%
9	3594	4.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	89784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	19645	21.9%
1	18202	20.3%
4	14101	15.7%
-	9976	11.1%
2	5370	6.0%
3	4088	4.6%
5	3858	4.3%
8	3748	4.2%
6	3707	4.1%
9	3594	4.0%

안전지대종류코드
Categorical

IMBALANCE

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

1	9490
2	510

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

Common Values

Value	Count	Frequency (%)
1	9490	94.9%
2	510	5.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9490	94.9%
2	510	5.1%

Heatmap
Table

	상태 (공통)	고가 (공통)	구경찰서코드 (공통)	신경찰서코드 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	구코드 (공통)	신규정규화ID	설치일	교체일	이력ID	안전지대종류코드
상태 (공통)	1.000	0.000	0.030	0.026	0.042	0.038	0.000	0.057	0.046	0.000	NaN	NaN	0.070	0.000
고가 (공통)	0.000	1.000	0.075	0.081	0.000	0.007	0.009	0.059	0.072	0.000	0.000	0.000	0.074	0.000
구경찰서코드 (공통)	0.030	0.075	1.000	0.996	0.155	0.061	0.144	0.755	0.925	0.315	0.381	0.397	0.338	0.059
신경찰서코드 (공통)	0.026	0.081	0.996	1.000	0.147	0.066	0.143	0.776	0.937	0.314	0.384	0.400	0.335	0.039
작업구분 (공통)	0.042	0.000	0.155	0.147	1.000	0.678	0.040	0.113	0.180	0.000	0.739	0.785	0.629	0.282
표출구분 (공통)	0.038	0.007	0.061	0.066	0.678	1.000	0.044	0.091	0.088	0.000	0.161	0.202	0.700	0.525
도로구분 (공통)	0.000	0.009	0.144	0.143	0.040	0.044	1.000	0.074	0.134	0.037	0.382	0.365	0.142	0.099
관할사업소 (공통)	0.057	0.059	0.755	0.776	0.113	0.091	0.074	1.000	0.945	0.263	0.368	0.395	0.266	0.052
구코드 (공통)	0.046	0.072	0.925	0.937	0.180	0.088	0.134	0.945	1.000	0.396	0.474	0.494	0.342	0.000
신규정규화ID	0.000	0.000	0.315	0.314	0.000	0.000	0.037	0.263	0.396	1.000	0.194	0.208	0.000	0.100
설치일	NaN	0.000	0.381	0.384	0.739	0.161	0.382	0.368	0.474	0.194	1.000	0.998	0.461	0.182
교체일	NaN	0.000	0.397	0.400	0.785	0.202	0.365	0.395	0.494	0.208	0.998	1.000	0.441	0.160
이력ID	0.070	0.074	0.338	0.335	0.629	0.700	0.142	0.266	0.342	0.000	0.461	0.441	1.000	0.315
안전지대종류코드	0.000	0.000	0.059	0.039	0.282	0.525	0.099	0.052	0.000	0.100	0.182	0.160	0.315	1.000

Heatmap
Table

	상태 (공통)	작업구분 (공통)	안전지대종류코드	도로구분 (공통)	표출구분 (공통)	고가 (공통)
상태 (공통)	1.000	0.051	0.000	0.000	0.024	0.000
작업구분 (공통)	0.051	1.000	0.345	0.049	0.811	0.000
안전지대종류코드	0.000	0.345	1.000	0.063	0.352	0.000
도로구분 (공통)	0.000	0.049	0.063	1.000	0.028	0.015
표출구분 (공통)	0.024	0.811	0.352	0.028	1.000	0.011
고가 (공통)	0.000	0.000	0.000	0.015	0.011	1.000

Heatmap
Table

	구경찰서코드 (공통)	신경찰서코드 (공통)	관할사업소 (공통)	구코드 (공통)	신규정규화ID	설치일	교체일	이력ID	상태 (공통)	고가 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	안전지대종류코드
구경찰서코드 (공통)	1.000	0.951	-0.418	0.620	0.158	0.013	0.018	0.059	0.023	0.044	0.065	0.047	0.110	0.045
신경찰서코드 (공통)	0.951	1.000	-0.413	0.628	0.157	0.015	0.019	0.063	0.020	0.048	0.062	0.051	0.109	0.030
관할사업소 (공통)	-0.418	-0.413	1.000	-0.689	0.463	0.076	0.124	-0.049	0.041	0.024	0.077	0.065	0.053	0.037
구코드 (공통)	0.620	0.628	-0.689	1.000	-0.045	-0.028	-0.055	0.088	0.035	0.043	0.076	0.067	0.103	0.000
신규정규화ID	0.158	0.157	0.463	-0.045	1.000	0.090	0.125	0.054	0.000	0.000	0.000	0.000	0.029	0.077
설치일	0.013	0.015	0.076	-0.028	0.090	1.000	0.887	0.386	1.000	0.000	0.565	0.122	0.293	0.140
교체일	0.018	0.019	0.124	-0.055	0.125	0.887	1.000	0.340	1.000	0.000	0.606	0.153	0.279	0.123
이력ID	0.059	0.063	-0.049	0.088	0.054	0.386	0.340	1.000	0.054	0.044	0.311	0.546	0.109	0.242
상태 (공통)	0.023	0.020	0.041	0.035	0.000	1.000	1.000	0.054	1.000	0.000	0.051	0.024	0.000	0.000
고가 (공통)	0.044	0.048	0.024	0.043	0.000	0.000	0.000	0.044	0.000	1.000	0.000	0.011	0.015	0.000
작업구분 (공통)	0.065	0.062	0.077	0.076	0.000	0.565	0.606	0.311	0.051	0.000	1.000	0.811	0.049	0.345
표출구분 (공통)	0.047	0.051	0.065	0.067	0.000	0.122	0.153	0.546	0.024	0.011	0.811	1.000	0.028	0.352
도로구분 (공통)	0.110	0.109	0.053	0.103	0.029	0.293	0.279	0.109	0.000	0.015	0.049	0.028	1.000	0.063
안전지대종류코드	0.045	0.030	0.037	0.000	0.077	0.140	0.123	0.242	0.000	0.000	0.345	0.352	0.063	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	공사관리번호	구안전지대 관리번호	안전지대종류코드
41999	14-0000017374	1	1	140	140	1	2	1	108	410	<NA>	<NA>	<NA>	<NA>	37664	2000-0000-000	14-017374	1
297	14-0000012116	1	1	260	260	4	1	2	105	540	<NA>	<NA>	<NA>	<NA>	15416	2000-0000-000	14-012116	1
9671	14-0000002357	1	1	220	220	1	2	1	105	590	3116861	<NA>	<NA>	<NA>	44405	2010-0108-022	14-002357	2
2807	14-0000012771	1	1	220	220	4	1	1	105	590	<NA>	<NA>	<NA>	<NA>	23854	2009-1108-158	14-012771	1
41168	14-0000017998	1	1	210	210	4	1	1	108	440	<NA>	<NA>	<NA>	<NA>	42749	2012-0708-001	14-017998	1
7884	14-0000001453	1	1	170	170	4	1	2	104	560	<NA>	<NA>	<NA>	<NA>	10753	2000-0000-000	14-001453	1
26334	14-0000009506	1	1	350	350	2	1	1	104	470	<NA>	<NA>	<NA>	<NA>	44370	2004-0108-211	14-009506	1
37872	14-0000010706	1	1	180	180	4	1	1	109	200	<NA>	<NA>	<NA>	<NA>	38696	2009-1004-002	14-010706	1
16107	14-0000004522	1	1	180	180	4	1	2	109	200	<NA>	<NA>	<NA>	<NA>	23121	2005-1108-233	14-004522	1
7175	14-0000001499	1	1	380	380	1	1	1	105	650	3172621	<NA>	<NA>	<NA>	3774	2000-0000-000	14-001499	1

	안전지대관리번호	상태 (공통)	고가 (공통)	구경찰서코드 (공통)	신경찰서코드 (공통)	작업구분 (공통)	표출구분 (공통)	도로구분 (공통)	관할사업소 (공통)	구코드 (공통)	신규정규화ID	설치일	교체일	공간데이터	이력ID	공사관리번호	구안전지대 관리번호	안전지대종류코드
10876	14-0000003039	1	1	360	360	4	1	1	106	710	<NA>	<NA>	<NA>	<NA>	7461	2010-1108-103	14-003039	1
50803	14-0000001268	1	1	330	330	4	1	1	104	530	<NA>	<NA>	<NA>	<NA>	34821	2000-0000-000	14-001268	1
24815	14-0000011447	1	1	200	200	4	1	2	109	230	<NA>	<NA>	<NA>	<NA>	5435	2007-1112-842	14-011447	1
38615	14-0000015659	1	1	330	330	1	2	2	<NA>	<NA>	1172752	<NA>	<NA>	<NA>	46133	2000-0000-000	14-015659	1
19777	14-0000006114	1	1	410	360	4	1	1	106	710	<NA>	<NA>	<NA>	<NA>	268	2006-1108-109	14-006114	1
47968	14-0000012893	1	1	210	210	1	2	1	108	440	23034710	20190819	20190819	<NA>	25499	2019-0207-068	14-012893	1
47845	14-0000020006	1	3	340	340	1	2	1	105	650	4108301	20161031	20161031	<NA>	47788	2020-9907-001	14-020006	1
14708	14-0000004151	1	1	200	200	2	1	1	109	230	<NA>	<NA>	<NA>	<NA>	391	2005-0108-049	14-004151	1
11930	14-0000003262	1	1	180	180	4	1	2	109	200	<NA>	<NA>	<NA>	<NA>	16871	2005-0108-040	14-003262	1
21453	14-0000007398	1	1	170	170	2	1	1	104	560	<NA>	<NA>	<NA>	<NA>	40863	2002-0708-039	14-007398	1

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

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

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample