gimi9 Pandas Profiling

Dataset statistics

Number of variables	20
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	174.0 B

Variable types

Unsupported	3
Categorical	4
Text	9
Numeric	4

Dataset

Description	설치방식,상태 (공통),표지코드,비고,X좌표,Y좌표,설치일,교체일,표지관리번호,지주관리번호,각도 (공통),작업구분 (공통),표출구분 (공통),신규정규화ID,이력ID,공사관리번호,표지관리번호,표지인덱스,위치정보,공사형태
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15540/S/1/datasetView.do

Alerts

`작업구분 (공통)` is highly overall correlated with `표출구분 (공통)`	High correlation
`표출구분 (공통)` is highly overall correlated with `작업구분 (공통)`	High correlation
`표지코드` is highly imbalanced (73.0%)	Imbalance
`작업구분 (공통)` is highly imbalanced (52.5%)	Imbalance
`공사형태` is highly imbalanced (82.2%)	Imbalance
`이력ID` has unique values	Unique
`설치방식` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`상태 (공통)` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`위치정보` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`X좌표` has 296 (3.0%) zeros	Zeros
`각도 (공통)` has 8262 (82.6%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 07:04:59.439507
Analysis finished	2023-12-11 07:05:04.795294
Duration	5.36 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

설치방식
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

상태 (공통)
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

표지코드
Categorical

IMBALANCE

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

002	8577
003	804
004	580
000	16
	13
Other values (2)	10

Length

Max length	3
Median length	3
Mean length	2.9971
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
002	8577	85.8%
003	804	8.0%
004	580	5.8%
000	16	0.2%
	13	0.1%
001	7	0.1%
00	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
002	8577	85.9%
003	804	8.1%
004	580	5.8%
000	16	0.2%
001	7	0.1%
00	3	< 0.1%

비고
Text

Distinct	603
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	59
Median length	1
Mean length	2.1119
Min length	1

Characters and Unicode

Total characters	21119
Distinct characters	312
Distinct categories	12 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

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

Unique

Unique	435 ?
Unique (%)	4.3%

Sample

1st row
2nd row	전방 30m
3rd row
4th row
5th row

Value	Count	Frequency (%)
100m	131	5.2%
100	113	4.5%
주차금지	89	3.5%
주차구획선외	82	3.3%
유치원앞	71	2.8%
일방통행	70	2.8%
60	68	2.7%
전방	48	1.9%
버스전용	41	1.6%
사고잦은곳	41	1.6%
Other values (632)	1758	70.0%

Most occurring characters

Value	Count	Frequency (%)
	9136	43.3%
0	1980	9.4%
1	556	2.6%
m	441	2.1%
차	387	1.8%
:	336	1.6%
2	302	1.4%
주	262	1.2%
전	261	1.2%
시	253	1.2%
Other values (302)	7205	34.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	9136	43.3%
Other Letter	6879	32.6%
Decimal Number	3629	17.2%
Lowercase Letter	553	2.6%
Other Punctuation	484	2.3%
Uppercase Letter	192	0.9%
Math Symbol	150	0.7%
Dash Punctuation	43	0.2%
Open Punctuation	25	0.1%
Close Punctuation	24	0.1%
Other values (2)	4	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
차	387	5.6%
주	262	3.8%
전	261	3.8%
시	253	3.7%
방	202	2.9%
구	182	2.6%
선	179	2.6%
지	174	2.5%
일	166	2.4%
행	149	2.2%
Other values (240)	4664	67.8%

Uppercase Letter

Value	Count	Frequency (%)
M	88	45.8%
O	27	14.1%
S	12	6.2%
E	9	4.7%
N	9	4.7%
C	9	4.7%
L	8	4.2%
Z	8	4.2%
H	8	4.2%
X	5	2.6%
Other values (6)	9	4.7%

Lowercase Letter

Value	Count	Frequency (%)
m	441	79.7%
t	39	7.1%
o	19	3.4%
s	8	1.4%
c	8	1.4%
e	6	1.1%
n	6	1.1%
z	6	1.1%
l	6	1.1%
h	6	1.1%
Other values (4)	8	1.4%

Decimal Number

Value	Count	Frequency (%)
0	1980	54.6%
1	556	15.3%
2	302	8.3%
5	185	5.1%
7	176	4.8%
4	144	4.0%
3	144	4.0%
6	90	2.5%
8	32	0.9%
9	20	0.6%

Other Punctuation

Value	Count	Frequency (%)
:	336	69.4%
.	124	25.6%
,	13	2.7%
;	4	0.8%
/	2	0.4%
%	2	0.4%
？	1	0.2%
'	1	0.2%
!	1	0.2%

Math Symbol

Value	Count	Frequency (%)
~	132	88.0%
\|	10	6.7%
→	4	2.7%
>	2	1.3%
←	1	0.7%
↔	1	0.7%

Other Symbol

Value	Count	Frequency (%)
↙	1	50.0%
↘	1	50.0%

Space Separator

Value	Count	Frequency (%)
	9136	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	43	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	25	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	24	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13495	63.9%
Hangul	6879	32.6%
Latin	745	3.5%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
차	387	5.6%
주	262	3.8%
전	261	3.8%
시	253	3.7%
방	202	2.9%
구	182	2.6%
선	179	2.6%
지	174	2.5%
일	166	2.4%
행	149	2.2%
Other values (240)	4664	67.8%

Common

Value	Count	Frequency (%)
	9136	67.7%
0	1980	14.7%
1	556	4.1%
:	336	2.5%
2	302	2.2%
5	185	1.4%
7	176	1.3%
4	144	1.1%
3	144	1.1%
~	132	1.0%
Other values (22)	404	3.0%

Latin

Value	Count	Frequency (%)
m	441	59.2%
M	88	11.8%
t	39	5.2%
O	27	3.6%
o	19	2.6%
S	12	1.6%
E	9	1.2%
N	9	1.2%
C	9	1.2%
s	8	1.1%
Other values (20)	84	11.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14231	67.4%
Hangul	6879	32.6%
Arrows	8	< 0.1%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9136	64.2%
0	1980	13.9%
1	556	3.9%
m	441	3.1%
:	336	2.4%
2	302	2.1%
5	185	1.3%
7	176	1.2%
4	144	1.0%
3	144	1.0%
Other values (46)	831	5.8%

Hangul

Value	Count	Frequency (%)
차	387	5.6%
주	262	3.8%
전	261	3.8%
시	253	3.7%
방	202	2.9%
구	182	2.6%
선	179	2.6%
지	174	2.5%
일	166	2.4%
행	149	2.2%
Other values (240)	4664	67.8%

Arrows

Value	Count	Frequency (%)
→	4	50.0%
←	1	12.5%
↙	1	12.5%
↘	1	12.5%
↔	1	12.5%

None

Value	Count	Frequency (%)
？	1	100.0%

X좌표
Real number (ℝ)

ZEROS

Distinct	9594
Distinct (%)	95.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	191253.46

Minimum	0
Maximum	215723.48
Zeros	296
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	186025.33
Q1	192161.86
median	195252.43
Q3	201546.85
95-th percentile	209855.92
Maximum	215723.48
Range	215723.48
Interquartile range (IQR)	9384.9978

Descriptive statistics

Standard deviation	34020.711
Coefficient of variation (CV)	0.17788285
Kurtosis	26.596606
Mean	191253.46
Median Absolute Deviation (MAD)	3883.2319
Skewness	-5.2332266
Sum	1.9125346 × 10⁹
Variance	1.1574088 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	296	3.0%
194638.23623	3	< 0.1%
207564.81413	3	< 0.1%
203384.74505	3	< 0.1%
208291.70373	3	< 0.1%
196061.13973	3	< 0.1%
192344.74619	3	< 0.1%
204195.67311	3	< 0.1%
197690.01408	3	< 0.1%
194924.82365	2	< 0.1%
Other values (9584)	9678	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	296	3.0%
182655.74246	1	< 0.1%
182673.74112	1	< 0.1%
182763.74338	1	< 0.1%
182823.73682	1	< 0.1%
182987.31563	1	< 0.1%
182999.09942	1	< 0.1%
183028.90475	1	< 0.1%
183044.74263	1	< 0.1%
183122.74287	1	< 0.1%

Value	Count	Frequency (%)
215723.48181	1	< 0.1%
215224.99095	1	< 0.1%
215135.51289	1	< 0.1%
215124.51365	1	< 0.1%
215123.42468	1	< 0.1%
215089.50735	1	< 0.1%
215063.50491	1	< 0.1%
214881.47448	1	< 0.1%
214870.47417	1	< 0.1%
214779.52736	1	< 0.1%

Y좌표
Real number (ℝ)

Distinct	9613
Distinct (%)	96.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	534602.5

Minimum	100000
Maximum	565787.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	100000
5-th percentile	539781.99
Q1	543284.86
median	546347.12
Q3	551720.8
95-th percentile	556651.92
Maximum	565787.54
Range	465787.54
Interquartile range (IQR)	8435.9418

Descriptive statistics

Standard deviation	76076.818
Coefficient of variation (CV)	0.14230539
Kurtosis	28.547736
Mean	534602.5
Median Absolute Deviation (MAD)	4021.7893
Skewness	-5.5124472
Sum	5.346025 × 10⁹
Variance	5.7876822 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100000.0	296	3.0%
545860.14018	3	< 0.1%
545468.47753	3	< 0.1%
556765.26575	3	< 0.1%
551117.6022	3	< 0.1%
554120.76017	3	< 0.1%
547004.30953	2	< 0.1%
556098.65004	2	< 0.1%
543733.14282	2	< 0.1%
555903.13517	2	< 0.1%
Other values (9603)	9681	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100000.0	296	3.0%
537265.60933	1	< 0.1%
537294.60862	1	< 0.1%
537302.29647	1	< 0.1%
537655.2887	1	< 0.1%
537665.28868	1	< 0.1%
537739.29388	1	< 0.1%
537790.29375	1	< 0.1%
537851.18203	1	< 0.1%
537867.99963	1	< 0.1%

Value	Count	Frequency (%)
565787.53559	1	< 0.1%
564525.06507	1	< 0.1%
564524.97524	1	< 0.1%
563653.16871	1	< 0.1%
563511.23692	1	< 0.1%
563470.71974	1	< 0.1%
563073.33985	1	< 0.1%
563064.53125	1	< 0.1%
562969.82856	1	< 0.1%
562937.29727	1	< 0.1%

설치일
Text

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

Length

Max length	8
Median length	1
Mean length	1.1204
Min length	1

Characters and Unicode

Total characters	11204
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	47 ?
Unique (%)	0.5%

Sample

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

Value	Count	Frequency (%)
20131010	12	7.0%
20121218	11	6.4%
20131031	8	4.7%
20130607	6	3.5%
20141015	6	3.5%
20141030	6	3.5%
20131119	5	2.9%
20140528	4	2.3%
20131115	4	2.3%
20140830	4	2.3%
Other values (72)	106	61.6%

Most occurring characters

Value	Count	Frequency (%)
	9828	87.7%
1	395	3.5%
0	369	3.3%
2	252	2.2%
3	95	0.8%
8	76	0.7%
4	70	0.6%
5	35	0.3%
7	31	0.3%
9	29	0.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	9828	87.7%
Decimal Number	1376	12.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	395	28.7%
0	369	26.8%
2	252	18.3%
3	95	6.9%
8	76	5.5%
4	70	5.1%
5	35	2.5%
7	31	2.3%
9	29	2.1%
6	24	1.7%

Space Separator

Value	Count	Frequency (%)
	9828	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11204	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	9828	87.7%
1	395	3.5%
0	369	3.3%
2	252	2.2%
3	95	0.8%
8	76	0.7%
4	70	0.6%
5	35	0.3%
7	31	0.3%
9	29	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11204	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9828	87.7%
1	395	3.5%
0	369	3.3%
2	252	2.2%
3	95	0.8%
8	76	0.7%
4	70	0.6%
5	35	0.3%
7	31	0.3%
9	29	0.3%

교체일
Text

Distinct	85
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	8
Median length	1
Mean length	1.1372
Min length	1

Characters and Unicode

Total characters	11372
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	48 ?
Unique (%)	0.5%

Sample

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

Value	Count	Frequency (%)
20141202	15	7.7%
20131010	12	6.1%
20140528	11	5.6%
20121218	11	5.6%
20131031	8	4.1%
20141015	6	3.1%
20141030	6	3.1%
20130607	6	3.1%
20131119	5	2.6%
20140830	4	2.0%
Other values (74)	112	57.1%

Most occurring characters

Value	Count	Frequency (%)
	9804	86.2%
1	436	3.8%
0	418	3.7%
2	313	2.8%
3	96	0.8%
4	92	0.8%
8	78	0.7%
5	44	0.4%
7	35	0.3%
9	31	0.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	9804	86.2%
Decimal Number	1568	13.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	436	27.8%
0	418	26.7%
2	313	20.0%
3	96	6.1%
4	92	5.9%
8	78	5.0%
5	44	2.8%
7	35	2.2%
9	31	2.0%
6	25	1.6%

Space Separator

Value	Count	Frequency (%)
	9804	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11372	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	9804	86.2%
1	436	3.8%
0	418	3.7%
2	313	2.8%
3	96	0.8%
4	92	0.8%
8	78	0.7%
5	44	0.4%
7	35	0.3%
9	31	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11372	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9804	86.2%
1	436	3.8%
0	418	3.7%
2	313	2.8%
3	96	0.8%
4	92	0.8%
8	78	0.7%
5	44	0.4%
7	35	0.3%
9	31	0.3%

표지관리번호
Text

Distinct	9897
Distinct (%)	99.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	9798 ?
Unique (%)	98.0%

Sample

1st row	04-0000024279
2nd row	04-0000019601
3rd row	04-0000052131
4th row	04-0000016166
5th row	04-0000043116

Value	Count	Frequency (%)
04-0000026098	3	< 0.1%
04-0000072609	3	< 0.1%
04-0000173181	3	< 0.1%
04-0000064709	3	< 0.1%
04-0000064084	2	< 0.1%
04-0000251572	2	< 0.1%
04-0000252446	2	< 0.1%
04-0000015444	2	< 0.1%
04-0000015447	2	< 0.1%
04-0000050672	2	< 0.1%
Other values (9887)	9976	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	63158	48.6%
4	15275	11.8%
-	10000	7.7%
2	6573	5.1%
5	6107	4.7%
1	5666	4.4%
6	5118	3.9%
3	5068	3.9%
7	4650	3.6%
8	4265	3.3%

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	63158	52.6%
4	15275	12.7%
2	6573	5.5%
5	6107	5.1%
1	5666	4.7%
6	5118	4.3%
3	5068	4.2%
7	4650	3.9%
8	4265	3.6%
9	4120	3.4%

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	63158	48.6%
4	15275	11.8%
-	10000	7.7%
2	6573	5.1%
5	6107	4.7%
1	5666	4.4%
6	5118	3.9%
3	5068	3.9%
7	4650	3.6%
8	4265	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	63158	48.6%
4	15275	11.8%
-	10000	7.7%
2	6573	5.1%
5	6107	4.7%
1	5666	4.4%
6	5118	3.9%
3	5068	3.9%
7	4650	3.6%
8	4265	3.3%

지주관리번호
Text

Distinct	9076
Distinct (%)	90.8%
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	8234 ?
Unique (%)	82.3%

Sample

1st row	02-0000093777
2nd row	02-0000000751
3rd row	02-0000029874
4th row	02-0000104888
5th row	02-0000107340

Value	Count	Frequency (%)
02-0000014302	5	< 0.1%
02-0000042163	5	< 0.1%
02-0000036904	4	< 0.1%
02-0000044431	4	< 0.1%
02-0000003480	4	< 0.1%
02-0000036908	4	< 0.1%
02-0000095848	4	< 0.1%
02-0000107004	4	< 0.1%
02-0000036907	4	< 0.1%
02-0000154767	3	< 0.1%
Other values (9066)	9959	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	64291	49.5%
2	15579	12.0%
-	10000	7.7%
1	7852	6.0%
3	5417	4.2%
5	5098	3.9%
9	4702	3.6%
4	4688	3.6%
7	4258	3.3%
8	4155	3.2%

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	64291	53.6%
2	15579	13.0%
1	7852	6.5%
3	5417	4.5%
5	5098	4.2%
9	4702	3.9%
4	4688	3.9%
7	4258	3.5%
8	4155	3.5%
6	3960	3.3%

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	64291	49.5%
2	15579	12.0%
-	10000	7.7%
1	7852	6.0%
3	5417	4.2%
5	5098	3.9%
9	4702	3.6%
4	4688	3.6%
7	4258	3.3%
8	4155	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	64291	49.5%
2	15579	12.0%
-	10000	7.7%
1	7852	6.0%
3	5417	4.2%
5	5098	3.9%
9	4702	3.6%
4	4688	3.6%
7	4258	3.3%
8	4155	3.2%

각도 (공통)
Real number (ℝ)

ZEROS

Distinct	351
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.3533

Minimum	0
Maximum	359
Zeros	8262
Zeros (%)	82.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	253
Maximum	359
Range	359
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	80.580962
Coefficient of variation (CV)	2.5700951
Kurtosis	5.7546818
Mean	31.3533
Median Absolute Deviation (MAD)	0
Skewness	2.6229346
Sum	313533
Variance	6493.2914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8262	82.6%
180	58	0.6%
70	19	0.2%
340	17	0.2%
159	17	0.2%
249	16	0.2%
160	15	0.1%
273	15	0.1%
250	15	0.1%
93	11	0.1%
Other values (341)	1555	15.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8262	82.6%
1	5	0.1%
2	6	0.1%
3	5	0.1%
4	6	0.1%
5	7	0.1%
6	3	< 0.1%
7	3	< 0.1%
8	4	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
359	3	< 0.1%
358	4	< 0.1%
357	5	0.1%
356	7	0.1%
355	9	0.1%
354	4	< 0.1%
353	2	< 0.1%
352	5	0.1%
351	4	< 0.1%
350	6	0.1%

작업구분 (공통)
Categorical

HIGH CORRELATION IMBALANCE

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

1	7640
4	1112
2	1098
6	109
3	41

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

Common Values

Value	Count	Frequency (%)
1	7640	76.4%
4	1112	11.1%
2	1098	11.0%
6	109	1.1%
3	41	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	7640	76.4%
4	1112	11.1%
2	1098	11.0%
6	109	1.1%
3	41	0.4%

표출구분 (공통)
Categorical

HIGH CORRELATION

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

2	6133
1	3867

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	2

Common Values

Value	Count	Frequency (%)
2	6133	61.3%
1	3867	38.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	6133	61.3%
1	3867	38.7%

신규정규화ID
Text

Distinct	107
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	7
Median length	1
Mean length	1.0636
Min length	1

Characters and Unicode

Total characters	10636
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	106 ?
Unique (%)	1.1%

Sample

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

Value	Count	Frequency (%)
2341091	1	0.9%
6018603	1	0.9%
4448552	1	0.9%
1393443	1	0.9%
2298691	1	0.9%
5330661	1	0.9%
5490751	1	0.9%
4317941	1	0.9%
2168842	1	0.9%
3254243	1	0.9%
Other values (96)	96	90.6%

Most occurring characters

Value	Count	Frequency (%)
	9894	93.0%
1	135	1.3%
3	120	1.1%
2	115	1.1%
4	75	0.7%
5	69	0.6%
6	66	0.6%
8	49	0.5%
0	38	0.4%
9	38	0.4%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	9894	93.0%
Decimal Number	742	7.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	135	18.2%
3	120	16.2%
2	115	15.5%
4	75	10.1%
5	69	9.3%
6	66	8.9%
8	49	6.6%
0	38	5.1%
9	38	5.1%
7	37	5.0%

Space Separator

Value	Count	Frequency (%)
	9894	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10636	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	9894	93.0%
1	135	1.3%
3	120	1.1%
2	115	1.1%
4	75	0.7%
5	69	0.6%
6	66	0.6%
8	49	0.5%
0	38	0.4%
9	38	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10636	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	9894	93.0%
1	135	1.3%
3	120	1.1%
2	115	1.1%
4	75	0.7%
5	69	0.6%
6	66	0.6%
8	49	0.5%
0	38	0.4%
9	38	0.4%

이력ID
Real number (ℝ)

UNIQUE

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

Minimum	8
Maximum	317589
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	8
5-th percentile	3558.55
Q1	16173.75
median	31836.5
Q3	47718.75
95-th percentile	62710.1
Maximum	317589
Range	317581
Interquartile range (IQR)	31545

Descriptive statistics

Standard deviation	36304.477
Coefficient of variation (CV)	1.0277413
Kurtosis	38.877029
Mean	35324.529
Median Absolute Deviation (MAD)	15789
Skewness	5.4469432
Sum	3.5324529 × 10⁸
Variance	1.318015 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18905	1	< 0.1%
1031	1	< 0.1%
34305	1	< 0.1%
62052	1	< 0.1%
9198	1	< 0.1%
15739	1	< 0.1%
7455	1	< 0.1%
62	1	< 0.1%
46714	1	< 0.1%
15017	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	< 0.1%
9	1	< 0.1%
26	1	< 0.1%
41	1	< 0.1%
45	1	< 0.1%
47	1	< 0.1%
48	1	< 0.1%
56	1	< 0.1%
62	1	< 0.1%
64	1	< 0.1%

Value	Count	Frequency (%)
317589	1	< 0.1%
317547	1	< 0.1%
317545	1	< 0.1%
317540	1	< 0.1%
317535	1	< 0.1%
317523	1	< 0.1%
317521	1	< 0.1%
317486	1	< 0.1%
317484	1	< 0.1%
317480	1	< 0.1%

공사관리번호
Text

Distinct	630
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	13
Median length	13
Mean length	12.9928
Min length	1

Characters and Unicode

Total characters	129928
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

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

Unique

Unique	264 ?
Unique (%)	2.6%

Sample

1st row	2008-0107-634
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	7081	70.8%
2007-0507-548	113	1.1%
2007-0507-459	51	0.5%
2008-0107-824	50	0.5%
2008-0107-475	48	0.5%
2008-1107-519	45	0.5%
2008-0107-903	45	0.5%
2007-0507-749	44	0.4%
2008-0107-727	42	0.4%
2008-0512-002	35	0.4%
Other values (621)	2442	24.4%

Most occurring characters

Value	Count	Frequency (%)
0	83981	64.6%
-	19987	15.4%
2	11124	8.6%
1	4495	3.5%
7	3555	2.7%
8	1972	1.5%
5	1569	1.2%
4	1079	0.8%
9	765	0.6%
3	744	0.6%
Other values (8)	657	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	109927	84.6%
Dash Punctuation	19987	15.4%
Space Separator	8	< 0.1%
Other Letter	6	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	83981	76.4%
2	11124	10.1%
1	4495	4.1%
7	3555	3.2%
8	1972	1.8%
5	1569	1.4%
4	1079	1.0%
9	765	0.7%
3	744	0.7%
6	643	0.6%

Other Letter

Value	Count	Frequency (%)
상	1	16.7%
습	1	16.7%
정	1	16.7%
체	1	16.7%
지	1	16.7%
점	1	16.7%

Dash Punctuation

Value	Count	Frequency (%)
-	19987	100.0%

Space Separator

Value	Count	Frequency (%)
	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	129922	> 99.9%
Hangul	6	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	83981	64.6%
-	19987	15.4%
2	11124	8.6%
1	4495	3.5%
7	3555	2.7%
8	1972	1.5%
5	1569	1.2%
4	1079	0.8%
9	765	0.6%
3	744	0.6%
Other values (2)	651	0.5%

Hangul

Value	Count	Frequency (%)
상	1	16.7%
습	1	16.7%
정	1	16.7%
체	1	16.7%
지	1	16.7%
점	1	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129922	> 99.9%
Hangul	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	83981	64.6%
-	19987	15.4%
2	11124	8.6%
1	4495	3.5%
7	3555	2.7%
8	1972	1.5%
5	1569	1.2%
4	1079	0.8%
9	765	0.6%
3	744	0.6%
Other values (2)	651	0.5%

Hangul

Value	Count	Frequency (%)
상	1	16.7%
습	1	16.7%
정	1	16.7%
체	1	16.7%
지	1	16.7%
점	1	16.7%

표지관리번호.1
Text

Distinct	9897
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

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

Characters and Unicode

Total characters	90000
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	9798 ?
Unique (%)	98.0%

Sample

1st row	04-024279
2nd row	04-019601
3rd row	04-052131
4th row	04-016166
5th row	04-043116

Value	Count	Frequency (%)
04-026098	3	< 0.1%
04-072609	3	< 0.1%
04-173181	3	< 0.1%
04-064709	3	< 0.1%
04-064084	2	< 0.1%
04-251572	2	< 0.1%
04-252446	2	< 0.1%
04-015444	2	< 0.1%
04-015447	2	< 0.1%
04-050672	2	< 0.1%
Other values (9887)	9976	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	23158	25.7%
4	15275	17.0%
-	10000	11.1%
2	6573	7.3%
5	6107	6.8%
1	5666	6.3%
6	5118	5.7%
3	5068	5.6%
7	4650	5.2%
8	4265	4.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	80000	88.9%
Dash Punctuation	10000	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	23158	28.9%
4	15275	19.1%
2	6573	8.2%
5	6107	7.6%
1	5666	7.1%
6	5118	6.4%
3	5068	6.3%
7	4650	5.8%
8	4265	5.3%
9	4120	5.1%

Dash Punctuation

Value	Count	Frequency (%)
-	10000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	90000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	23158	25.7%
4	15275	17.0%
-	10000	11.1%
2	6573	7.3%
5	6107	6.8%
1	5666	6.3%
6	5118	5.7%
3	5068	5.6%
7	4650	5.2%
8	4265	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	90000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	23158	25.7%
4	15275	17.0%
-	10000	11.1%
2	6573	7.3%
5	6107	6.8%
1	5666	6.3%
6	5118	5.7%
3	5068	5.6%
7	4650	5.2%
8	4265	4.7%

표지인덱스
Text

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

Length

Max length	9
Median length	3
Mean length	3.3239
Min length	3

Characters and Unicode

Total characters	33239
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

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

Unique

Unique	36 ?
Unique (%)	0.4%

Sample

1st row	219
2nd row	538
3rd row	213
4th row	127
5th row	219

Value	Count	Frequency (%)
219	1468	14.7%
428	1280	12.8%
322	365	3.6%
214	333	3.3%
213	331	3.3%
514-1-100	290	2.9%
218	276	2.8%
418	259	2.6%
326	237	2.4%
226	228	2.3%
Other values (183)	4933	49.3%

Most occurring characters

Value	Count	Frequency (%)
2	9386	28.2%
1	6442	19.4%
3	3337	10.0%
4	3291	9.9%
8	2196	6.6%
9	1819	5.5%
0	1782	5.4%
5	1676	5.0%
-	1267	3.8%
6	937	2.8%
Other values (2)	1106	3.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31651	95.2%
Dash Punctuation	1267	3.8%
Uppercase Letter	321	1.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	9386	29.7%
1	6442	20.4%
3	3337	10.5%
4	3291	10.4%
8	2196	6.9%
9	1819	5.7%
0	1782	5.6%
5	1676	5.3%
6	937	3.0%
7	785	2.5%

Dash Punctuation

Value	Count	Frequency (%)
-	1267	100.0%

Uppercase Letter

Value	Count	Frequency (%)
Z	321	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	32918	99.0%
Latin	321	1.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	9386	28.5%
1	6442	19.6%
3	3337	10.1%
4	3291	10.0%
8	2196	6.7%
9	1819	5.5%
0	1782	5.4%
5	1676	5.1%
-	1267	3.8%
6	937	2.8%

Latin

Value	Count	Frequency (%)
Z	321	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33239	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	9386	28.2%
1	6442	19.4%
3	3337	10.0%
4	3291	9.9%
8	2196	6.6%
9	1819	5.5%
0	1782	5.4%
5	1676	5.0%
-	1267	3.8%
6	937	2.8%
Other values (2)	1106	3.3%

위치정보
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

공사형태
Categorical

IMBALANCE

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

	9156
003	682
001	82
002	64
004	11
Other values (2)	5

Length

Max length	3
Median length	1
Mean length	1.1688
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
	9156	91.6%
003	682	6.8%
001	82	0.8%
002	64	0.6%
004	11	0.1%
006	4	< 0.1%
005	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
003	682	80.8%
001	82	9.7%
002	64	7.6%
004	11	1.3%
006	4	0.5%
005	1	0.1%

Heatmap
Table

	표지코드	X좌표	Y좌표	설치일	교체일	각도 (공통)	작업구분 (공통)	표출구분 (공통)	이력ID	공사형태
표지코드	1.000	0.288	NaN	0.198	0.206	0.033	0.199	0.134	0.104	0.104
X좌표	0.288	1.000	NaN	0.000	0.000	0.100	0.425	0.135	0.159	0.094
Y좌표	NaN	NaN	1.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN
설치일	0.198	0.000	NaN	1.000	1.000	0.397	0.686	0.079	0.810	0.871
교체일	0.206	0.000	NaN	1.000	1.000	0.370	0.719	0.090	0.890	0.892
각도 (공통)	0.033	0.100	NaN	0.397	0.370	1.000	0.268	0.103	0.350	0.234
작업구분 (공통)	0.199	0.425	NaN	0.686	0.719	0.268	1.000	0.555	0.686	0.508
표출구분 (공통)	0.134	0.135	NaN	0.079	0.090	0.103	0.555	1.000	0.085	0.323
이력ID	0.104	0.159	NaN	0.810	0.890	0.350	0.686	0.085	1.000	0.667
공사형태	0.104	0.094	NaN	0.871	0.892	0.234	0.508	0.323	0.667	1.000

Heatmap
Table

	표지코드	작업구분 (공통)	표출구분 (공통)	공사형태
표지코드	1.000	0.128	0.144	0.037
작업구분 (공통)	0.128	1.000	0.671	0.357
표출구분 (공통)	0.144	0.671	1.000	0.346
공사형태	0.037	0.357	0.346	1.000

Heatmap
Table

	X좌표	Y좌표	각도 (공통)	이력ID	표지코드	작업구분 (공통)	표출구분 (공통)	공사형태
X좌표	1.000	0.078	0.062	0.221	0.202	0.356	0.223	0.063
Y좌표	0.078	1.000	-0.071	-0.405	0.277	0.497	0.219	0.047
각도 (공통)	0.062	-0.071	1.000	0.075	0.016	0.115	0.079	0.120
이력ID	0.221	-0.405	0.075	1.000	0.052	0.353	0.065	0.418
표지코드	0.202	0.277	0.016	0.052	1.000	0.128	0.144	0.037
작업구분 (공통)	0.356	0.497	0.115	0.353	0.128	1.000	0.671	0.357
표출구분 (공통)	0.223	0.219	0.079	0.065	0.144	0.671	1.000	0.346
공사형태	0.063	0.047	0.120	0.418	0.037	0.357	0.346	1.000

Count
Matrix

A simple visualization of nullity by column.

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

First rows
Last rows

	설치방식	상태 (공통)	표지코드	비고	X좌표	Y좌표	표지관리번호	지주관리번호	각도 (공통)	작업구분 (공통)	표출구분 (공통)	이력ID	공사관리번호	표지관리번호.1	표지인덱스	위치정보
22952	003	001	002		208723.45414	556492.48801	04-0000024279	02-0000093777	0	4	1	18905	2008-0107-634	04-024279	219	9
14233	003	001	002	전방 30m	196579.58021	556049.22814	04-0000019601	02-0000000751	0	2	1	9245	2000-0000-000	04-019601	538	9
33469	3	1	002		193283.86136	544563.26654	04-0000052131	02-0000029874	92	1	2	37511	2000-0000-000	04-052131	213	9
8713	001	001	002		193892.785	547813.24874	04-0000016166	02-0000104888	0	1	1	18002	2000-0000-000	04-016166	127	9
34401	3	1	002		185242.95593	543773.09963	04-0000043116	02-0000107340	0	1	2	39789	2000-0000-000	04-043116	219	9
20290	999	001	004		211357.98427	548653.75643	04-0000167067	02-0000036630	0	2	1	17542	2000-0000-000	04-167067	428	9
1785	003	001	002		199911.11035	551637.4566	04-0000002359	02-0000009838	0	4	1	4189	2000-0000-000	04-002359	428	9
44490	999	1	004	100	198093.169	542606.31301	04-0000159367	02-0000017402	0	2	1	46075	2000-0000-000	04-159367	425	9
14371	003	001	002		192528.71685	553967.42451	04-0000009569	02-0000008419	0	1	2	16587	2000-0000-000	04-009569	219	9
16690	003	001	002	주차구획선외 주차금지	193105.61647	555912.15413	04-0000028261	02-0000105938	0	1	2	21240	2000-0000-000	04-028261	513	9

	설치방식	상태 (공통)	표지코드	비고	X좌표	Y좌표	표지관리번호	지주관리번호	각도 (공통)	작업구분 (공통)	표출구분 (공통)	이력ID	공사관리번호	표지관리번호.1	표지인덱스	위치정보
7316	003	001	002	유치원앞	209469.89999	556012.42356	04-0000141864	02-0000081862	0	2	1	5687	2007-0507-459	04-141864	231-Z	9
58544	3	1	002		211145.09049	545428.24694	04-0000078705	02-0000045572	0	1	1	61561	2000-0000-000	04-078705	428	9
37858	3	1	003		193306.40208	557671.81037	04-0000240849	02-0000144026	0	2	1	32159	2008-0507-006	04-240849	712	9
5178	001	001	002		198663.56567	546719.02594	04-0000252254	02-0000150995	0	1	2	2807	2007-1107-638	04-252254	303	9
15313	003	001	002		190149.68478	554072.10746	04-0000010405	02-0000002816	0	1	2	9336	2000-0000-000	04-010405	322	9
36827	2	1	002	어린이 보호구역 여기서부터 200m	192822.95518	540456.29618	04-0000038953	02-0000022379	0	2	1	32122	2000-0000-000	04-038953	231-Z	9
39732	3	1	002		186320.91861	545014.11135	04-0000046015	02-0000097369	0	1	1	40164	2010-0107-094	04-046015	428	9
32456	003	001	002		192060.79672	548091.20648	04-0000041684	02-0000023819	85	1	2	39108	2000-0000-000	04-041684	308	9
35564	3	1	002		192120.46875	542421.0625	04-0000037779	02-0000106933	142	1	2	40955	2000-0000-000	04-037779	311	9
9034	001	001	002		200975.8959	554483.02864	04-0000251762	02-0000150609	0	1	2	10093	2008-1112-535	04-251762	328	9

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Math Symbol

Other Symbol

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Arrows

None

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

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)

Common Values

Length