gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	10000
Missing cells	30975
Missing cells (%)	18.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	155.0 B

Variable types

Numeric	8
Text	4
Categorical	5

Dataset

Description	시군구_코드,도로_일련번호,법정동_일련번호,도로_명,영문_도로_명,시도_명,시군구_명,법정동_구분,법정동_코드,법정동_명,상위_도로_일련번호,상위_도로_명,새주소_사용여부,변경_이력_사유_코드,변경_이력_정보,법정동_번호,도로_코드
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15411/S/1/datasetView.do

Alerts

`시도_명` has constant value ""	Constant
`새주소_사용여부` is highly overall correlated with `변경_이력_정보` and 1 other fields	High correlation
`변경_이력_사유_코드` is highly overall correlated with `법정동_일련번호` and 3 other fields	High correlation
`시군구_코드` is highly overall correlated with `도로_일련번호` and 3 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 overall correlated with `법정동_일련번호` and 2 other fields	High correlation
`변경_이력_정보` is highly overall correlated with `시군구_코드` and 6 other fields	High correlation
`법정동_번호` is highly overall correlated with `법정동_코드` and 2 other fields	High correlation
`도로_코드` is highly overall correlated with `시군구_코드` and 3 other fields	High correlation
`시군구_명` is highly overall correlated with `시군구_코드` and 3 other fields	High correlation
`법정동_구분` is highly overall correlated with `법정동_코드` and 1 other fields	High correlation
`새주소_사용여부` is highly imbalanced (78.8%)	Imbalance
`변경_이력_사유_코드` is highly imbalanced (89.0%)	Imbalance
`법정동_명` has 4668 (46.7%) missing values	Missing
`상위_도로_일련번호` has 1902 (19.0%) missing values	Missing
`상위_도로_명` has 9791 (97.9%) missing values	Missing
`변경_이력_정보` has 9945 (99.5%) missing values	Missing
`법정동_번호` has 4668 (46.7%) missing values	Missing
`법정동_일련번호` has 4668 (46.7%) zeros	Zeros
`법정동_코드` has 4668 (46.7%) zeros	Zeros

Reproduction

Analysis started	2024-05-18 06:02:00.302684
Analysis finished	2024-05-18 06:02:21.734984
Duration	21.43 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

시군구_코드
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11419.033

Minimum	11110
Maximum	11740
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	11110
5-th percentile	11140
Q1	11230
median	11440
Q3	11590
95-th percentile	11710
Maximum	11740
Range	630
Interquartile range (IQR)	360

Descriptive statistics

Standard deviation	191.32253
Coefficient of variation (CV)	0.016754705
Kurtosis	-1.3240632
Mean	11419.033
Median Absolute Deviation (MAD)	180
Skewness	0.015185822
Sum	1.1419033 × 10⁸
Variance	36604.31
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
11560	605	6.0%
11290	601	6.0%
11680	553	5.5%
11620	550	5.5%
11230	490	4.9%
11110	472	4.7%
11440	455	4.5%
11170	449	4.5%
11590	446	4.5%
11650	426	4.3%
Other values (15)	4953	49.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110	472	4.7%
11140	372	3.7%
11170	449	4.5%
11200	418	4.2%
11215	347	3.5%
11230	490	4.9%
11260	377	3.8%
11290	601	6.0%
11305	405	4.0%
11320	199	2.0%

Value	Count	Frequency (%)
11740	323	3.2%
11710	365	3.6%
11680	553	5.5%
11650	426	4.3%
11620	550	5.5%
11590	446	4.5%
11560	605	6.0%
11545	262	2.6%
11530	330	3.3%
11500	395	4.0%

도로_일련번호
Real number (ℝ)

HIGH CORRELATION

Distinct	7977
Distinct (%)	79.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4052014.1

Minimum	1000001
Maximum	4861546
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1000001
5-th percentile	3111001
Q1	4112359.8
median	4133297.5
Q3	4157081.2
95-th percentile	4169302
Maximum	4861546
Range	3861545
Interquartile range (IQR)	44721.5

Descriptive statistics

Standard deviation	340514.67
Coefficient of variation (CV)	0.084035905
Kurtosis	15.724546
Mean	4052014.1
Median Absolute Deviation (MAD)	21282
Skewness	-3.6057387
Sum	4.0520141 × 10¹⁰
Variance	1.1595024 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000008	12	0.1%
2000003	12	0.1%
3100010	10	0.1%
3101011	8	0.1%
3005016	8	0.1%
3100021	6	0.1%
2000006	6	0.1%
2100001	6	0.1%
2005008	6	0.1%
3101009	6	0.1%
Other values (7967)	9920	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000001	1	< 0.1%
1000027	1	< 0.1%
1000028	1	< 0.1%
1000033	1	< 0.1%
1000105	1	< 0.1%
2000001	1	< 0.1%
2000003	12	0.1%
2000004	1	< 0.1%
2000006	6	0.1%
2000008	6	0.1%

Value	Count	Frequency (%)
4861546	1	< 0.1%
4861545	1	< 0.1%
4861342	1	< 0.1%
4860970	2	< 0.1%
4860969	1	< 0.1%
4860966	1	< 0.1%
4860176	1	< 0.1%
4860174	1	< 0.1%
4860173	1	< 0.1%
4859725	1	< 0.1%

법정동_일련번호
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6902

Minimum	0
Maximum	27
Zeros	4668
Zeros (%)	46.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	2
Maximum	27
Range	27
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0705786
Coefficient of variation (CV)	1.5511136
Kurtosis	123.72554
Mean	0.6902
Median Absolute Deviation (MAD)	1
Skewness	7.6379945
Sum	6902
Variance	1.1461386
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0	4668	46.7%
1	4591	45.9%
2	454	4.5%
3	121	1.2%
4	61	0.6%
5	33	0.3%
6	28	0.3%
7	11	0.1%
8	10	0.1%
9	6	0.1%
Other values (10)	17	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4668	46.7%
1	4591	45.9%
2	454	4.5%
3	121	1.2%
4	61	0.6%
5	33	0.3%
6	28	0.3%
7	11	0.1%
8	10	0.1%
9	6	0.1%

Value	Count	Frequency (%)
27	1	< 0.1%
26	1	< 0.1%
24	1	< 0.1%
19	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	1	< 0.1%
12	4	< 0.1%
11	1	< 0.1%
10	4	< 0.1%

도로_명
Text

Distinct	7945
Distinct (%)	79.5%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	10
Median length	9
Mean length	6.2289
Min length	2

Characters and Unicode

Total characters	62289
Distinct characters	315
Distinct categories	3 ?
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	6160 ?
Unique (%)	61.6%

Sample

1st row	숭인로8가길
2nd row	고산자로29길
3rd row	도봉로180길
4th row	답십리로12길
5th row	돌곶이로34길

Value	Count	Frequency (%)
남부순환로	12	0.1%
통일로	12	0.1%
율곡로	10	0.1%
퇴계로	8	0.1%
백범로	8	0.1%
양재대로	6	0.1%
충무로	6	0.1%
삼일대로	6	0.1%
청계천로	6	0.1%
천호대로	6	0.1%
Other values (7935)	9920	99.2%

Most occurring characters

Value	Count	Frequency (%)
길	9306	14.9%
로	9116	14.6%
1	3568	5.7%
2	2515	4.0%
3	2012	3.2%
4	1628	2.6%
5	1492	2.4%
6	1267	2.0%
가	1217	2.0%
7	1165	1.9%
Other values (305)	29003	46.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	45701	73.4%
Decimal Number	16579	26.6%
Other Punctuation	9	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
길	9306	20.4%
로	9116	19.9%
가	1217	2.7%
대	1114	2.4%
동	761	1.7%
산	736	1.6%
나	607	1.3%
천	578	1.3%
봉	491	1.1%
신	425	0.9%
Other values (294)	21350	46.7%

Decimal Number

Value	Count	Frequency (%)
1	3568	21.5%
2	2515	15.2%
3	2012	12.1%
4	1628	9.8%
5	1492	9.0%
6	1267	7.6%
7	1165	7.0%
8	1041	6.3%
9	974	5.9%
0	917	5.5%

Other Punctuation

Value	Count	Frequency (%)
.	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	45701	73.4%
Common	16588	26.6%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
길	9306	20.4%
로	9116	19.9%
가	1217	2.7%
대	1114	2.4%
동	761	1.7%
산	736	1.6%
나	607	1.3%
천	578	1.3%
봉	491	1.1%
신	425	0.9%
Other values (294)	21350	46.7%

Common

Value	Count	Frequency (%)
1	3568	21.5%
2	2515	15.2%
3	2012	12.1%
4	1628	9.8%
5	1492	9.0%
6	1267	7.6%
7	1165	7.0%
8	1041	6.3%
9	974	5.9%
0	917	5.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	45701	73.4%
ASCII	16588	26.6%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
길	9306	20.4%
로	9116	19.9%
가	1217	2.7%
대	1114	2.4%
동	761	1.7%
산	736	1.6%
나	607	1.3%
천	578	1.3%
봉	491	1.1%
신	425	0.9%
Other values (294)	21350	46.7%

ASCII

Value	Count	Frequency (%)
1	3568	21.5%
2	2515	15.2%
3	2012	12.1%
4	1628	9.8%
5	1492	9.0%
6	1267	7.6%
7	1165	7.0%
8	1041	6.3%
9	974	5.9%
0	917	5.5%

영문_도로_명
Text

Distinct	7952
Distinct (%)	79.5%
Missing	1
Missing (%)	< 0.1%
Memory size	156.2 KiB

Length

Max length	38
Median length	34
Mean length	18.747075
Min length	6

Characters and Unicode

Total characters	187452
Distinct characters	58
Distinct categories	8 ?
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	6174 ?
Unique (%)	61.7%

Sample

1st row	Sungin-ro 8ga-gil
2nd row	Gosanja-ro 29(isipgu)-gil
3rd row	Dobong-ro 180-gil
4th row	Dapsimni-ro 12(sibi)-gil
5th row	Dolgoji-ro 34-gil

Value	Count	Frequency (%)
gil	505	2.6%
2-gil	188	1.0%
nambusunhwan-ro	169	0.9%
3-gil	166	0.8%
1-gil	163	0.8%
6-gil	158	0.8%
4-gil	155	0.8%
8-gil	155	0.8%
5-gil	150	0.8%
dongil-ro	140	0.7%
Other values (2007)	17828	90.1%

Most occurring characters

Value	Count	Frequency (%)
g	18724	10.0%
o	18147	9.7%
-	17596	9.4%
i	13501	7.2%
n	12950	6.9%
a	11968	6.4%
l	11394	6.1%
	11076	5.9%
r	9938	5.3%
e	7236	3.9%
Other values (48)	54922	29.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	129352	69.0%
Dash Punctuation	17596	9.4%
Decimal Number	16583	8.8%
Space Separator	11076	5.9%
Uppercase Letter	10078	5.4%
Open Punctuation	1379	0.7%
Close Punctuation	1379	0.7%
Other Punctuation	9	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
g	18724	14.5%
o	18147	14.0%
i	13501	10.4%
n	12950	10.0%
a	11968	9.3%
l	11394	8.8%
r	9938	7.7%
e	7236	5.6%
u	4137	3.2%
s	3704	2.9%
Other values (14)	17653	13.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1870	18.6%
D	1358	13.5%
G	1095	10.9%
Y	716	7.1%
J	713	7.1%
H	705	7.0%
B	652	6.5%
M	619	6.1%
N	505	5.0%
C	410	4.1%
Other values (9)	1435	14.2%

Decimal Number

Value	Count	Frequency (%)
1	3561	21.5%
2	2510	15.1%
3	2015	12.2%
4	1633	9.8%
5	1496	9.0%
6	1265	7.6%
7	1171	7.1%
8	1041	6.3%
9	979	5.9%
0	912	5.5%

Dash Punctuation

Value	Count	Frequency (%)
-	17596	100.0%

Space Separator

Value	Count	Frequency (%)
	11076	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1379	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1379	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	139430	74.4%
Common	48022	25.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
g	18724	13.4%
o	18147	13.0%
i	13501	9.7%
n	12950	9.3%
a	11968	8.6%
l	11394	8.2%
r	9938	7.1%
e	7236	5.2%
u	4137	3.0%
s	3704	2.7%
Other values (33)	27731	19.9%

Common

Value	Count	Frequency (%)
-	17596	36.6%
	11076	23.1%
1	3561	7.4%
2	2510	5.2%
3	2015	4.2%
4	1633	3.4%
5	1496	3.1%
(	1379	2.9%
)	1379	2.9%
6	1265	2.6%
Other values (5)	4112	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	187452	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
g	18724	10.0%
o	18147	9.7%
-	17596	9.4%
i	13501	7.2%
n	12950	6.9%
a	11968	6.4%
l	11394	6.1%
	11076	5.9%
r	9938	5.3%
e	7236	3.9%
Other values (48)	54922	29.3%

시도_명
Categorical

CONSTANT

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

서울특별시	10000

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	서울특별시
2nd row	서울특별시
3rd row	서울특별시
4th row	서울특별시
5th row	서울특별시

Common Values

Value	Count	Frequency (%)
서울특별시	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
서울특별시	10000	100.0%

시군구_명
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

영등포구	605
성북구	601
강남구	553
관악구	550
동대문구	490
Other values (20)	7201

Length

Max length	4
Median length	3
Mean length	3.1053
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	성북구
2nd row	동대문구
3rd row	도봉구
4th row	동대문구
5th row	성북구

Common Values

Value	Count	Frequency (%)
영등포구	605	6.0%
성북구	601	6.0%
강남구	553	5.5%
관악구	550	5.5%
동대문구	490	4.9%
종로구	472	4.7%
마포구	455	4.5%
용산구	449	4.5%
동작구	446	4.5%
서초구	426	4.3%
Other values (15)	4953	49.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
영등포구	605	6.0%
성북구	601	6.0%
강남구	553	5.5%
관악구	550	5.5%
동대문구	490	4.9%
종로구	472	4.7%
마포구	455	4.5%
용산구	449	4.5%
동작구	446	4.5%
서초구	426	4.3%
Other values (15)	4953	49.5%

법정동_구분
Categorical

HIGH CORRELATION

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

1	5332
2	4668

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

Common Values

Value	Count	Frequency (%)
1	5332	53.3%
2	4668	46.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5332	53.3%
2	4668	46.7%

법정동_코드
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	322
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6038.4502

Minimum	0
Maximum	18706
Zeros	4668
Zeros (%)	46.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10101
Q3	10701
95-th percentile	13601
Maximum	18706
Range	18706
Interquartile range (IQR)	10701

Descriptive statistics

Standard deviation	5782.4057
Coefficient of variation (CV)	0.95759765
Kurtosis	-1.7147948
Mean	6038.4502
Median Absolute Deviation (MAD)	4201
Skewness	0.027793004
Sum	60384502
Variance	33436216
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4668	46.7%
10101	668	6.7%
10201	612	6.1%
10301	507	5.1%
10501	312	3.1%
10801	252	2.5%
10701	250	2.5%
10601	204	2.0%
10901	169	1.7%
10401	159	1.6%
Other values (312)	2199	22.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4668	46.7%
10101	668	6.7%
10102	4	< 0.1%
10201	612	6.1%
10202	39	0.4%
10301	507	5.1%
10302	38	0.4%
10303	7	0.1%
10304	1	< 0.1%
10401	159	1.6%

Value	Count	Frequency (%)
18706	1	< 0.1%
18701	1	< 0.1%
18603	1	< 0.1%
18602	3	< 0.1%
18601	2	< 0.1%
18502	2	< 0.1%
18501	1	< 0.1%
18412	1	< 0.1%
18402	1	< 0.1%
18401	6	0.1%

법정동_명
Text

MISSING

Distinct	435
Distinct (%)	8.2%
Missing	4668
Missing (%)	46.7%
Memory size	156.2 KiB

Length

Max length	6
Median length	3
Mean length	3.2573143
Min length	2

Characters and Unicode

Total characters	17368
Distinct characters	208
Distinct categories	2 ?
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	47 ?
Unique (%)	0.9%

Sample

1st row	장위동
2nd row	미아동
3rd row	신대방동
4th row	홍제동
5th row	동선동4가

Value	Count	Frequency (%)
신림동	173	3.2%
봉천동	92	1.7%
미아동	86	1.6%
신길동	84	1.6%
화곡동	80	1.5%
수유동	80	1.5%
신월동	70	1.3%
독산동	69	1.3%
면목동	67	1.3%
상계동	64	1.2%
Other values (425)	4467	83.8%

Most occurring characters

Value	Count	Frequency (%)
동	5219	30.0%
가	702	4.0%
신	622	3.6%
림	272	1.6%
산	215	1.2%
상	211	1.2%
곡	203	1.2%
수	203	1.2%
로	200	1.2%
천	196	1.1%
Other values (198)	9325	53.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	16740	96.4%
Decimal Number	628	3.6%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	5219	31.2%
가	702	4.2%
신	622	3.7%
림	272	1.6%
산	215	1.3%
상	211	1.3%
곡	203	1.2%
수	203	1.2%
로	200	1.2%
천	196	1.2%
Other values (190)	8697	52.0%

Decimal Number

Value	Count	Frequency (%)
1	196	31.2%
2	167	26.6%
3	111	17.7%
4	58	9.2%
5	48	7.6%
6	29	4.6%
7	16	2.5%
8	3	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	16740	96.4%
Common	628	3.6%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	5219	31.2%
가	702	4.2%
신	622	3.7%
림	272	1.6%
산	215	1.3%
상	211	1.3%
곡	203	1.2%
수	203	1.2%
로	200	1.2%
천	196	1.2%
Other values (190)	8697	52.0%

Common

Value	Count	Frequency (%)
1	196	31.2%
2	167	26.6%
3	111	17.7%
4	58	9.2%
5	48	7.6%
6	29	4.6%
7	16	2.5%
8	3	0.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	16740	96.4%
ASCII	628	3.6%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
동	5219	31.2%
가	702	4.2%
신	622	3.7%
림	272	1.6%
산	215	1.3%
상	211	1.3%
곡	203	1.2%
수	203	1.2%
로	200	1.2%
천	196	1.2%
Other values (190)	8697	52.0%

ASCII

Value	Count	Frequency (%)
1	196	31.2%
2	167	26.6%
3	111	17.7%
4	58	9.2%
5	48	7.6%
6	29	4.6%
7	16	2.5%
8	3	0.5%

상위_도로_일련번호
Real number (ℝ)

MISSING

Distinct	427
Distinct (%)	5.3%
Missing	1902
Missing (%)	19.0%
Infinite	0
Infinite (%)	0.0%
Mean	2966875.7

Minimum	2000003
Maximum	3124009
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2000003
5-th percentile	2005007
Q1	3005029
median	3104007
Q3	3116003
95-th percentile	3122011
Maximum	3124009
Range	1124006
Interquartile range (IQR)	110974

Descriptive statistics

Standard deviation	325054.32
Coefficient of variation (CV)	0.10956115
Kurtosis	4.2901002
Mean	2966875.7
Median Absolute Deviation (MAD)	17003
Skewness	-2.4610235
Sum	2.4025759 × 10¹⁰
Variance	1.0566031 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000003	157	1.6%
3000001	147	1.5%
3005039	124	1.2%
3005041	112	1.1%
2000008	99	1.0%
3005038	95	0.9%
2005010	91	0.9%
3000004	82	0.8%
3117004	79	0.8%
3000008	69	0.7%
Other values (417)	7043	70.4%
(Missing)	1902	19.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2000003	157	1.6%
2000006	42	0.4%
2000007	2	< 0.1%
2000008	99	1.0%
2005001	13	0.1%
2005002	12	0.1%
2005005	54	0.5%
2005007	50	0.5%
2005008	17	0.2%
2005009	45	0.4%

Value	Count	Frequency (%)
3124009	23	0.2%
3124008	5	0.1%
3124007	8	0.1%
3124006	13	0.1%
3124005	1	< 0.1%
3124004	11	0.1%
3124003	28	0.3%
3124002	8	0.1%
3124001	23	0.2%
3123024	26	0.3%

상위_도로_명
Text

MISSING

Distinct	72
Distinct (%)	34.4%
Missing	9791
Missing (%)	97.9%
Memory size	156.2 KiB

Length

Max length	5
Median length	3
Mean length	3.3492823
Min length	3

Characters and Unicode

Total characters	700
Distinct characters	108
Distinct categories	1 ?
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	28 ?
Unique (%)	13.4%

Sample

1st row	숭인로
2nd row	한천로
3rd row	숭인로
4th row	북아현로
5th row	숭인로

Value	Count	Frequency (%)
한천로	21	10.0%
통일로	12	5.7%
금호로	11	5.3%
신길로	9	4.3%
북아현로	8	3.8%
천호대로	6	2.9%
용마산로	6	2.9%
장월로	5	2.4%
서달로	5	2.4%
증가로	5	2.4%
Other values (62)	121	57.9%

Most occurring characters

Value	Count	Frequency (%)
로	209	29.9%
천	34	4.9%
한	24	3.4%
산	22	3.1%
대	18	2.6%
호	17	2.4%
마	17	2.4%
신	16	2.3%
현	14	2.0%
북	12	1.7%
Other values (98)	317	45.3%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	700	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
로	209	29.9%
천	34	4.9%
한	24	3.4%
산	22	3.1%
대	18	2.6%
호	17	2.4%
마	17	2.4%
신	16	2.3%
현	14	2.0%
북	12	1.7%
Other values (98)	317	45.3%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	700	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
로	209	29.9%
천	34	4.9%
한	24	3.4%
산	22	3.1%
대	18	2.6%
호	17	2.4%
마	17	2.4%
신	16	2.3%
현	14	2.0%
북	12	1.7%
Other values (98)	317	45.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	700	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
로	209	29.9%
천	34	4.9%
한	24	3.4%
산	22	3.1%
대	18	2.6%
호	17	2.4%
마	17	2.4%
신	16	2.3%
현	14	2.0%
북	12	1.7%
Other values (98)	317	45.3%

새주소_사용여부
Categorical

HIGH CORRELATION IMBALANCE

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

0	9665
1	335

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

Common Values

Value	Count	Frequency (%)
0	9665	96.7%
1	335	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	9665	96.7%
1	335	3.4%

변경_이력_사유_코드
Categorical

HIGH CORRELATION IMBALANCE

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

<NA>	9687
1	267
0	45
9	1

Length

Max length	4
Median length	4
Mean length	3.9061
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	9687	96.9%
1	267	2.7%
0	45	0.4%
9	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	9687	96.9%
1	267	2.7%
0	45	0.4%
9	1	< 0.1%

변경_이력_정보
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	55
Distinct (%)	100.0%
Missing	9945
Missing (%)	99.5%
Infinite	0
Infinite (%)	0.0%
Mean	1.1394891 × 10¹³

Minimum	1.1230412 × 10¹³
Maximum	1.1740417 × 10¹³
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1.1230412 × 10¹³
5-th percentile	1.1272358 × 10¹³
Q1	1.1290486 × 10¹³
median	1.1305412 × 10¹³
Q3	1.1440414 × 10¹³
95-th percentile	1.1710417 × 10¹³
Maximum	1.1740417 × 10¹³
Range	5.1000567 × 10¹¹
Interquartile range (IQR)	1.4992831 × 10¹¹

Descriptive statistics

Standard deviation	1.6702478 × 10¹¹
Coefficient of variation (CV)	0.014657865
Kurtosis	-0.30182051
Mean	1.1394891 × 10¹³
Median Absolute Deviation (MAD)	1.4926803 × 10¹⁰
Skewness	1.1772301
Sum	6.2671903 × 10¹⁴
Variance	2.7897277 × 10²²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11740417244300	1	< 0.1%
11290412180400	1	< 0.1%
11305412462400	1	< 0.1%
11680416687600	1	< 0.1%
11560415483600	1	< 0.1%
11680416687700	1	< 0.1%
11305412463100	1	< 0.1%
11290485659000	1	< 0.1%
11290485660401	1	< 0.1%
11305412462700	1	< 0.1%
Other values (45)	45	0.4%
(Missing)	9945	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11230411571000	1	< 0.1%
11230411571001	1	< 0.1%
11230412179801	1	< 0.1%
11290335220700	1	< 0.1%
11290412180400	1	< 0.1%
11290485658302	1	< 0.1%
11290485658500	1	< 0.1%
11290485658900	1	< 0.1%
11290485658901	1	< 0.1%
11290485659000	1	< 0.1%

Value	Count	Frequency (%)
11740417244301	1	< 0.1%
11740417244300	1	< 0.1%
11710416955401	1	< 0.1%
11710416955301	1	< 0.1%
11710416955200	1	< 0.1%
11710416955101	1	< 0.1%
11680485836201	1	< 0.1%
11680485836200	1	< 0.1%
11680416687700	1	< 0.1%
11680416687600	1	< 0.1%

법정동_번호
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	87
Distinct (%)	1.6%
Missing	4668
Missing (%)	46.7%
Infinite	0
Infinite (%)	0.0%
Mean	113.23631

Minimum	101
Maximum	187
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	101
5-th percentile	101
Q1	103
median	107
Q3	117
95-th percentile	154
Maximum	187
Range	86
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	16.831596
Coefficient of variation (CV)	0.14864133
Kurtosis	4.456945
Mean	113.23631
Median Absolute Deviation (MAD)	5
Skewness	2.1308684
Sum	603776
Variance	283.30262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
101	672	6.7%
102	651	6.5%
103	553	5.5%
105	347	3.5%
108	290	2.9%
107	287	2.9%
106	226	2.3%
109	215	2.1%
104	180	1.8%
110	122	1.2%
Other values (77)	1789	17.9%
(Missing)	4668	46.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101	672	6.7%
102	651	6.5%
103	553	5.5%
104	180	1.8%
105	347	3.5%
106	226	2.3%
107	287	2.9%
108	290	2.9%
109	215	2.1%
110	122	1.2%

Value	Count	Frequency (%)
187	2	< 0.1%
186	6	0.1%
185	3	< 0.1%
184	8	0.1%
183	14	0.1%
182	5	0.1%
181	2	< 0.1%
180	2	< 0.1%
179	2	< 0.1%
178	3	< 0.1%

도로_코드
Real number (ℝ)

HIGH CORRELATION

Distinct	8075
Distinct (%)	80.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1419438 × 10¹¹

Minimum	1.1110201 × 10¹¹
Maximum	1.1740486 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1.1110201 × 10¹¹
5-th percentile	1.114031 × 10¹¹
Q1	1.1230412 × 10¹¹
median	1.1440311 × 10¹¹
Q3	1.1590416 × 10¹¹
95-th percentile	1.1710417 × 10¹¹
Maximum	1.1740486 × 10¹¹
Range	6.302856 × 10⁹
Interquartile range (IQR)	3.6000416 × 10⁹

Descriptive statistics

Standard deviation	1.9132521 × 10⁹
Coefficient of variation (CV)	0.016754345
Kurtosis	-1.3240415
Mean	1.1419438 × 10¹¹
Median Absolute Deviation (MAD)	1.7989946 × 10⁹
Skewness	0.015160995
Sum	1.1419438 × 10¹⁵
Variance	3.6605337 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
111103100010	10	0.1%
111403101011	8	0.1%
111403101009	6	0.1%
111103000008	5	0.1%
111703102009	5	0.1%
115603118023	5	0.1%
111103100013	5	0.1%
115603118024	5	0.1%
111703102004	5	0.1%
115603005074	5	0.1%
Other values (8065)	9941	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111102005001	1	< 0.1%
111102100001	1	< 0.1%
111102100002	2	< 0.1%
111103000008	5	0.1%
111103005001	1	< 0.1%
111103005002	1	< 0.1%
111103005004	1	< 0.1%
111103005005	4	< 0.1%
111103005006	1	< 0.1%
111103005008	2	< 0.1%

Value	Count	Frequency (%)
117404860970	2	< 0.1%
117404860969	1	< 0.1%
117404860966	1	< 0.1%
117404859648	1	< 0.1%
117404858126	1	< 0.1%
117404858050	1	< 0.1%
117404858049	2	< 0.1%
117404858048	2	< 0.1%
117404858046	1	< 0.1%
117404172446	1	< 0.1%

Heatmap
Table

	시군구_코드	도로_일련번호	법정동_일련번호	시군구_명	법정동_구분	법정동_코드	상위_도로_일련번호	상위_도로_명	새주소_사용여부	변경_이력_사유_코드	변경_이력_정보	법정동_번호	도로_코드
시군구_코드	1.000	0.117	0.115	1.000	0.061	0.450	0.434	0.996	0.135	0.601	0.973	0.587	1.000
도로_일련번호	0.117	1.000	0.342	0.188	0.131	0.108	0.053	NaN	0.051	0.388	0.885	0.123	0.123
법정동_일련번호	0.115	0.342	1.000	0.194	0.159	0.265	0.000	NaN	0.015	NaN	NaN	0.253	0.136
시군구_명	1.000	0.188	0.194	1.000	0.068	0.697	0.579	0.996	0.166	0.930	1.000	0.807	1.000
법정동_구분	0.061	0.131	0.159	0.068	1.000	1.000	0.000	0.000	0.026	0.010	0.000	NaN	0.076
법정동_코드	0.450	0.108	0.265	0.697	1.000	1.000	0.090	0.882	0.056	0.272	0.510	0.996	0.488
상위_도로_일련번호	0.434	0.053	0.000	0.579	0.000	0.090	1.000	1.000	0.000	0.260	0.642	0.129	0.430
상위_도로_명	0.996	NaN	NaN	0.996	0.000	0.882	1.000	1.000	0.772	0.907	1.000	0.967	0.993
새주소_사용여부	0.135	0.051	0.015	0.166	0.026	0.056	0.000	0.772	1.000	1.000	NaN	0.077	0.141
변경_이력_사유_코드	0.601	0.388	NaN	0.930	0.010	0.272	0.260	0.907	1.000	1.000	0.815	0.364	0.602
변경_이력_정보	0.973	0.885	NaN	1.000	0.000	0.510	0.642	1.000	NaN	0.815	1.000	0.576	0.973
법정동_번호	0.587	0.123	0.253	0.807	NaN	0.996	0.129	0.967	0.077	0.364	0.576	1.000	0.745
도로_코드	1.000	0.123	0.136	1.000	0.076	0.488	0.430	0.993	0.141	0.602	0.973	0.745	1.000

Heatmap
Table

	새주소_사용여부	변경_이력_사유_코드	시군구_명	법정동_구분
새주소_사용여부	1.000	0.998	0.143	0.016
변경_이력_사유_코드	0.998	1.000	0.799	0.017
시군구_명	0.143	0.799	1.000	0.059
법정동_구분	0.016	0.017	0.059	1.000

Heatmap
Table

	시군구_코드	도로_일련번호	법정동_일련번호	법정동_코드	상위_도로_일련번호	변경_이력_정보	법정동_번호	도로_코드	시군구_명	법정동_구분	새주소_사용여부	변경_이력_사유_코드
시군구_코드	1.000	0.850	-0.075	-0.146	0.425	0.963	-0.360	0.999	0.999	0.059	0.108	0.441
도로_일련번호	0.850	1.000	-0.140	-0.167	0.430	0.737	-0.328	0.860	0.075	0.099	0.036	0.378
법정동_일련번호	-0.075	-0.140	1.000	0.909	-0.009	-0.044	0.252	-0.079	0.075	0.158	0.015	1.000
법정동_코드	-0.146	-0.167	0.909	1.000	-0.011	-0.134	1.000	-0.148	0.401	1.000	0.040	0.116
상위_도로_일련번호	0.425	0.430	-0.009	-0.011	1.000	-0.420	-0.033	0.429	0.339	0.000	0.000	0.172
변경_이력_정보	0.963	0.737	-0.044	-0.134	-0.420	1.000	-0.614	0.925	0.978	0.000	1.000	0.796
법정동_번호	-0.360	-0.328	0.252	1.000	-0.033	-0.614	1.000	-0.358	0.439	1.000	0.059	0.244
도로_코드	0.999	0.860	-0.079	-0.148	0.429	0.925	-0.358	1.000	0.999	0.059	0.108	0.441
시군구_명	0.999	0.075	0.075	0.401	0.339	0.978	0.439	0.999	1.000	0.059	0.143	0.799
법정동_구분	0.059	0.099	0.158	1.000	0.000	0.000	1.000	0.059	0.059	1.000	0.016	0.017
새주소_사용여부	0.108	0.036	0.015	0.040	0.000	1.000	0.059	0.108	0.143	0.016	1.000	0.998
변경_이력_사유_코드	0.441	0.378	1.000	0.116	0.172	0.796	0.244	0.441	0.799	0.017	0.998	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

	시군구_코드	도로_일련번호	법정동_일련번호	도로_명	영문_도로_명	시도_명	시군구_명	법정동_구분	법정동_코드	법정동_명	상위_도로_일련번호	상위_도로_명	새주소_사용여부	변경_이력_사유_코드	변경_이력_정보	법정동_번호	도로_코드
32129	11290	4121401	0	숭인로8가길	Sungin-ro 8ga-gil	서울특별시	성북구	2	0	<NA>	3005043	숭인로	1	1	<NA>	<NA>	112904121401
15240	11230	4115026	0	고산자로29길	Gosanja-ro 29(isipgu)-gil	서울특별시	동대문구	2	0	<NA>	3005030	<NA>	0	<NA>	<NA>	<NA>	112304115026
23300	11320	4127183	0	도봉로180길	Dobong-ro 180-gil	서울특별시	도봉구	2	0	<NA>	3005039	<NA>	0	<NA>	<NA>	<NA>	113204127183
14241	11230	4115053	0	답십리로12길	Dapsimni-ro 12(sibi)-gil	서울특별시	동대문구	2	0	<NA>	3005025	<NA>	0	<NA>	<NA>	<NA>	112304115053
15483	11290	4121058	1	돌곶이로34길	Dolgoji-ro 34-gil	서울특별시	성북구	1	13801	장위동	3107002	<NA>	0	<NA>	<NA>	138	112904121058
23558	11305	4124112	1	도봉로53가길	Dobong-ro 53ga-gil	서울특별시	강북구	1	10101	미아동	3005039	<NA>	0	<NA>	<NA>	101	113054124112
13742	11260	4118236	0	면목로60길	Myeonmok-ro 60(yuksip)-gil	서울특별시	중랑구	2	0	<NA>	3005027	<NA>	0	<NA>	<NA>	<NA>	112604118236
1138	11590	4157481	1	신대방16길	Sindaebang 16-gil	서울특별시	동작구	1	10901	신대방동	<NA>	<NA>	0	<NA>	<NA>	109	115904157481
13057	11230	4115448	0	전농로34길	Jeonnong-ro 34(samsipsa)-gil	서울특별시	동대문구	2	0	<NA>	3105013	<NA>	0	<NA>	<NA>	<NA>	112304115448
15660	11290	4121194	0	보문로14길	Bomun-ro 14-gil	서울특별시	성북구	2	0	<NA>	3005003	<NA>	0	<NA>	<NA>	<NA>	112904121194

	시군구_코드	도로_일련번호	법정동_일련번호	도로_명	영문_도로_명	시도_명	시군구_명	법정동_구분	법정동_코드	법정동_명	상위_도로_일련번호	상위_도로_명	변경_이력_사유_코드	변경_이력_정보	법정동_번호	도로_코드
1149	11590	4157486	0	신대방1가길	Sindaebang 1 ga-gil	서울특별시	동작구	2	0	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	115904157486
29149	11170	4106075	1	두텁바위로75길	Duteopbawi-ro 75-gil	서울특별시	용산구	1	10101	후암동	3102002	<NA>	<NA>	<NA>	101	111704106075
2493	11620	4160748	1	행운1마길	Haengun 1ma-gil	서울특별시	관악구	1	10101	봉천동	<NA>	<NA>	<NA>	<NA>	101	116204160748
9817	11680	4166056	1	개포로24길	Gaepo-ro 24 gil	서울특별시	강남구	1	10301	개포동	3122001	<NA>	<NA>	<NA>	103	116804166056
30328	11140	4103218	0	손기정로12길	Songijeong-ro 12-gil	서울특별시	중구	2	0	<NA>	3101019	<NA>	<NA>	<NA>	<NA>	111404103218
7149	11470	4142125	1	목동서로8길	Mokdongseo-ro 8-gil	서울특별시	양천구	1	10201	목동	3114003	<NA>	<NA>	<NA>	102	114704142125
7881	11470	4142191	0	목동중앙북로2길	Mokdongjungangbuk-ro 2-gil	서울특별시	양천구	2	0	<NA>	3114007	<NA>	<NA>	<NA>	<NA>	114704142191
10966	11740	4172042	0	구천면로12길	Gucheonmyeon-ro 12-gil	서울특별시	강동구	2	0	<NA>	3016054	<NA>	<NA>	<NA>	<NA>	117404172042
8632	11650	4163560	0	주흥길	Juheung-gil	서울특별시	서초구	2	0	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	116504163560
7552	11440	4139070	0	독막로18길	Dongmak-ro 18-gil	서울특별시	마포구	2	0	<NA>	3113005	<NA>	<NA>	<NA>	<NA>	114404139070

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Most occurring scripts

Most frequent character per script

Hangul

Most occurring blocks

Most frequent character per block

Hangul

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample