gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	3864
Missing cells	2131
Missing cells (%)	3.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	573.7 KiB
Average record size in memory	152.0 B

Variable types

Categorical	6
Text	4
Numeric	8

Dataset

Description	2017년 12월말 기준 경남도내 교량 현황입니다.
Author	경상남도
URL	https://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15055128

Alerts

`시도` has constant value ""	Constant
`교장` 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 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 1 other fields	High correlation
`상부구조` is highly overall correlated with `최대경간장`	High correlation
`설계하중` is highly imbalanced (68.4%)	Imbalance
`노선명` has 1280 (33.1%) missing values	Missing
`리` has 415 (10.7%) missing values	Missing
`교통량` has 402 (10.4%) missing values	Missing
`교통량` has 201 (5.2%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 00:37:47.262668
Analysis finished	2023-12-11 00:37:56.797291
Duration	9.53 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

도로종류
Categorical

Distinct	6
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

고속국도	1088
일반국도	871
시도	855
지방도	468
군도	429

Length

Max length	7
Median length	4
Mean length	3.3330745
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 (%)
고속국도	1088	28.2%
일반국도	871	22.5%
시도	855	22.1%
지방도	468	12.1%
군도	429	11.1%
국가지원지방도	153	4.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
고속국도	1088	28.2%
일반국도	871	22.5%
시도	855	22.1%
지방도	468	12.1%
군도	429	11.1%
국가지원지방도	153	4.0%

노선명
Text

MISSING

Distinct	76
Distinct (%)	2.9%
Missing	1280
Missing (%)	33.1%
Memory size	30.3 KiB

Length

Max length	11
Median length	8
Mean length	8.2345201
Min length	2

Characters and Unicode

Total characters	21278
Distinct characters	24
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	3 ?
Unique (%)	0.1%

Sample

1st row	일반국도14호선
2nd row	일반국도14호선
3rd row	일반국도14호선
4th row	일반국도14호선
5th row	일반국도14호선

Value	Count	Frequency (%)
고속국도10호선	328	12.7%
고속국도35호선	270	10.4%
일반국도2호선	153	5.9%
고속국도55호선	123	4.8%
일반국도3호선	115	4.5%
일반국도33호선	110	4.3%
일반국도14호선	100	3.9%
고속국도12호선	93	3.6%
일반국도5호선	81	3.1%
일반국도24호선	74	2.9%
Other values (66)	1137	44.0%

Most occurring characters

Value	Count	Frequency (%)
도	2584	12.1%
호	2580	12.1%
선	2580	12.1%
국	2112	9.9%
1	1337	6.3%
0	1192	5.6%
고	1088	5.1%
속	1088	5.1%
5	918	4.3%
일	871	4.1%
Other values (14)	4928	23.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	15479	72.7%
Decimal Number	5799	27.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
도	2584	16.7%
호	2580	16.7%
선	2580	16.7%
국	2112	13.6%
고	1088	7.0%
속	1088	7.0%
일	871	5.6%
반	871	5.6%
지	774	5.0%
방	621	4.0%
Other values (4)	310	2.0%

Decimal Number

Value	Count	Frequency (%)
1	1337	23.1%
0	1192	20.6%
5	918	15.8%
3	776	13.4%
2	567	9.8%
4	387	6.7%
7	195	3.4%
9	185	3.2%
8	139	2.4%
6	103	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	15479	72.7%
Common	5799	27.3%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
도	2584	16.7%
호	2580	16.7%
선	2580	16.7%
국	2112	13.6%
고	1088	7.0%
속	1088	7.0%
일	871	5.6%
반	871	5.6%
지	774	5.0%
방	621	4.0%
Other values (4)	310	2.0%

Common

Value	Count	Frequency (%)
1	1337	23.1%
0	1192	20.6%
5	918	15.8%
3	776	13.4%
2	567	9.8%
4	387	6.7%
7	195	3.4%
9	185	3.2%
8	139	2.4%
6	103	1.8%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	15479	72.7%
ASCII	5799	27.3%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
도	2584	16.7%
호	2580	16.7%
선	2580	16.7%
국	2112	13.6%
고	1088	7.0%
속	1088	7.0%
일	871	5.6%
반	871	5.6%
지	774	5.0%
방	621	4.0%
Other values (4)	310	2.0%

ASCII

Value	Count	Frequency (%)
1	1337	23.1%
0	1192	20.6%
5	918	15.8%
3	776	13.4%
2	567	9.8%
4	387	6.7%
7	195	3.4%
9	185	3.2%
8	139	2.4%
6	103	1.8%

시설명
Text

Distinct	3434
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

Length

Max length	14
Median length	13
Mean length	4.9477226
Min length	2

Characters and Unicode

Total characters	19118
Distinct characters	351
Distinct categories	10 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

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

Unique

Unique	3141 ?
Unique (%)	81.3%

Sample

1st row	계룡산교
2nd row	고현1교
3rd row	고현2교
4th row	고현3교
5th row	고현천교

Value	Count	Frequency (%)
신기교	9	0.2%
신촌교	8	0.2%
송정교	7	0.2%
오산교	6	0.2%
정동교	6	0.2%
대천교	6	0.2%
대곡교	6	0.2%
상평교	6	0.2%
운곡교	6	0.2%
두곡교	5	0.1%
Other values (3435)	3833	98.3%

Most occurring characters

Value	Count	Frequency (%)
교	3892	20.4%
(	1122	5.9%
)	1122	5.9%
산	655	3.4%
천	556	2.9%
1	490	2.6%
2	445	2.3%
C	340	1.8%
대	326	1.7%
부	292	1.5%
Other values (341)	9878	51.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	14658	76.7%
Decimal Number	1204	6.3%
Open Punctuation	1122	5.9%
Close Punctuation	1122	5.9%
Uppercase Letter	919	4.8%
Dash Punctuation	40	0.2%
Space Separator	34	0.2%
Lowercase Letter	12	0.1%
Other Punctuation	5	< 0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
교	3892	26.6%
산	655	4.5%
천	556	3.8%
대	326	2.2%
부	292	2.0%
육	279	1.9%
동	274	1.9%
하	261	1.8%
곡	243	1.7%
남	231	1.6%
Other values (304)	7649	52.2%

Uppercase Letter

Value	Count	Frequency (%)
C	340	37.0%
I	257	28.0%
J	74	8.1%
T	74	8.1%
R	39	4.2%
A	38	4.1%
B	23	2.5%
P	17	1.8%
M	16	1.7%
D	13	1.4%
Other values (7)	28	3.0%

Decimal Number

Value	Count	Frequency (%)
1	490	40.7%
2	445	37.0%
3	141	11.7%
4	52	4.3%
5	29	2.4%
6	19	1.6%
7	12	1.0%
8	7	0.6%
9	5	0.4%
0	4	0.3%

Lowercase Letter

Value	Count	Frequency (%)
p	4	33.3%
m	4	33.3%
a	4	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	4	80.0%
/	1	20.0%

Open Punctuation

Value	Count	Frequency (%)
(	1122	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1122	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	40	100.0%

Space Separator

Value	Count	Frequency (%)
	34	100.0%

Math Symbol

Value	Count	Frequency (%)
~	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	14658	76.7%
Common	3529	18.5%
Latin	931	4.9%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
교	3892	26.6%
산	655	4.5%
천	556	3.8%
대	326	2.2%
부	292	2.0%
육	279	1.9%
동	274	1.9%
하	261	1.8%
곡	243	1.7%
남	231	1.6%
Other values (304)	7649	52.2%

Latin

Value	Count	Frequency (%)
C	340	36.5%
I	257	27.6%
J	74	7.9%
T	74	7.9%
R	39	4.2%
A	38	4.1%
B	23	2.5%
P	17	1.8%
M	16	1.7%
D	13	1.4%
Other values (10)	40	4.3%

Common

Value	Count	Frequency (%)
(	1122	31.8%
)	1122	31.8%
1	490	13.9%
2	445	12.6%
3	141	4.0%
4	52	1.5%
-	40	1.1%
	34	1.0%
5	29	0.8%
6	19	0.5%
Other values (7)	35	1.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	14658	76.7%
ASCII	4460	23.3%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
교	3892	26.6%
산	655	4.5%
천	556	3.8%
대	326	2.2%
부	292	2.0%
육	279	1.9%
동	274	1.9%
하	261	1.8%
곡	243	1.7%
남	231	1.6%
Other values (304)	7649	52.2%

ASCII

Value	Count	Frequency (%)
(	1122	25.2%
)	1122	25.2%
1	490	11.0%
2	445	10.0%
C	340	7.6%
I	257	5.8%
3	141	3.2%
J	74	1.7%
T	74	1.7%
4	52	1.2%
Other values (27)	343	7.7%

시도
Categorical

CONSTANT

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

경상남도	3864

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	경상남도
2nd row	경상남도
3rd row	경상남도
4th row	경상남도
5th row	경상남도

Common Values

Value	Count	Frequency (%)
경상남도	3864	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
경상남도	3864	100.0%

시군구
Categorical

Distinct	24
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

창원시	693
김해시	502
진주시	360
양산시	243
함양군	240
Other values (19)	1826

Length

Max length	4
Median length	3
Mean length	3.0007764
Min length	3

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	거제시
2nd row	거제시
3rd row	거제시
4th row	거제시
5th row	거제시

Common Values

Value	Count	Frequency (%)
창원시	693	17.9%
김해시	502	13.0%
진주시	360	9.3%
양산시	243	6.3%
함양군	240	6.2%
합천군	213	5.5%
함안군	211	5.5%
산청군	186	4.8%
밀양시	177	4.6%
고성군	161	4.2%
Other values (14)	878	22.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
창원시	693	17.9%
김해시	502	13.0%
진주시	360	9.3%
양산시	243	6.3%
함양군	240	6.2%
합천군	213	5.5%
함안군	211	5.5%
산청군	186	4.8%
밀양시	177	4.6%
고성군	161	4.2%
Other values (14)	878	22.7%

읍면동
Text

Distinct	287
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

Length

Max length	5
Median length	3
Mean length	3.1565735
Min length	2

Characters and Unicode

Total characters	12197
Distinct characters	157
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	31 ?
Unique (%)	0.8%

Sample

1st row	장평동
2nd row	상동동
3rd row	상동동
4th row	상동동
5th row	문동동

Value	Count	Frequency (%)
의창구	179	4.6%
마산합포구	178	4.6%
마산회원구	127	3.3%
성산구	120	3.1%
대동면	87	2.3%
진해구	87	2.3%
상동면	53	1.4%
주촌면	51	1.3%
생림면	48	1.2%
진례면	46	1.2%
Other values (277)	2888	74.7%

Most occurring characters

Value	Count	Frequency (%)
면	2395	19.6%
동	774	6.3%
구	707	5.8%
산	651	5.3%
읍	364	3.0%
마	339	2.8%
성	260	2.1%
창	238	2.0%
상	236	1.9%
진	232	1.9%
Other values (147)	6001	49.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	12197	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
면	2395	19.6%
동	774	6.3%
구	707	5.8%
산	651	5.3%
읍	364	3.0%
마	339	2.8%
성	260	2.1%
창	238	2.0%
상	236	1.9%
진	232	1.9%
Other values (147)	6001	49.2%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	12197	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
면	2395	19.6%
동	774	6.3%
구	707	5.8%
산	651	5.3%
읍	364	3.0%
마	339	2.8%
성	260	2.1%
창	238	2.0%
상	236	1.9%
진	232	1.9%
Other values (147)	6001	49.2%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	12197	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
면	2395	19.6%
동	774	6.3%
구	707	5.8%
산	651	5.3%
읍	364	3.0%
마	339	2.8%
성	260	2.1%
창	238	2.0%
상	236	1.9%
진	232	1.9%
Other values (147)	6001	49.2%

리
Text

MISSING

Distinct	934
Distinct (%)	27.1%
Missing	415
Missing (%)	10.7%
Memory size	30.3 KiB

Length

Max length	5
Median length	3
Mean length	2.9449116
Min length	2

Characters and Unicode

Total characters	10157
Distinct characters	248
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	325 ?
Unique (%)	9.4%

Sample

1st row	사곡리
2nd row	사곡리
3rd row	사등리
4th row	사등리
5th row	사등리

Value	Count	Frequency (%)
내서읍	50	1.4%
동읍	46	1.3%
북면	43	1.2%
진북면	40	1.2%
진전면	34	1.0%
대감리	29	0.8%
덕산리	26	0.8%
대산면	24	0.7%
석계리	19	0.6%
구암동	19	0.6%
Other values (924)	3119	90.4%

Most occurring characters

Value	Count	Frequency (%)
리	2758	27.2%
동	580	5.7%
산	355	3.5%
곡	212	2.1%
대	199	2.0%
면	164	1.6%
전	158	1.6%
사	139	1.4%
정	132	1.3%
천	129	1.3%
Other values (238)	5331	52.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	10142	99.9%
Decimal Number	15	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
리	2758	27.2%
동	580	5.7%
산	355	3.5%
곡	212	2.1%
대	199	2.0%
면	164	1.6%
전	158	1.6%
사	139	1.4%
정	132	1.3%
천	129	1.3%
Other values (237)	5316	52.4%

Decimal Number

Value	Count	Frequency (%)
1	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	10142	99.9%
Common	15	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
리	2758	27.2%
동	580	5.7%
산	355	3.5%
곡	212	2.1%
대	199	2.0%
면	164	1.6%
전	158	1.6%
사	139	1.4%
정	132	1.3%
천	129	1.3%
Other values (237)	5316	52.4%

Common

Value	Count	Frequency (%)
1	15	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	10142	99.9%
ASCII	15	0.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
리	2758	27.2%
동	580	5.7%
산	355	3.5%
곡	212	2.1%
대	199	2.0%
면	164	1.6%
전	158	1.6%
사	139	1.4%
정	132	1.3%
천	129	1.3%
Other values (237)	5316	52.4%

ASCII

Value	Count	Frequency (%)
1	15	100.0%

교장
Real number (ℝ)

HIGH CORRELATION

Distinct	736
Distinct (%)	19.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.288872

Minimum	2.3
Maximum	2145
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	2.3
5-th percentile	8.5
Q1	15
median	31
Q3	80
95-th percentile	340
Maximum	2145
Range	2142.7
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	150.21854
Coefficient of variation (CV)	1.8035847
Kurtosis	38.32461
Mean	83.288872
Median Absolute Deviation (MAD)	19
Skewness	5.0695402
Sum	321828.2
Variance	22565.609
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.0	176	4.6%
30.0	123	3.2%
12.0	123	3.2%
10.0	94	2.4%
50.0	79	2.0%
40.0	78	2.0%
20.0	65	1.7%
8.0	65	1.7%
24.0	59	1.5%
45.0	56	1.4%
Other values (726)	2946	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.3	1	< 0.1%
2.4	1	< 0.1%
3.0	3	0.1%
3.4	1	< 0.1%
3.7	1	< 0.1%
4.0	3	0.1%
4.1	1	< 0.1%
4.5	1	< 0.1%
4.7	1	< 0.1%
4.8	2	0.1%

Value	Count	Frequency (%)
2145.0	1	< 0.1%
2018.0	1	< 0.1%
1700.0	1	< 0.1%
1479.7	1	< 0.1%
1422.4	2	0.1%
1320.0	2	0.1%
1290.0	1	< 0.1%
1240.0	1	< 0.1%
1160.0	2	0.1%
1148.0	1	< 0.1%

총폭
Real number (ℝ)

HIGH CORRELATION

Distinct	320
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.179684

Minimum	2
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	2
5-th percentile	6
Q1	9
median	12
Q3	19.4
95-th percentile	28.685
Maximum	80
Range	78
Interquartile range (IQR)	10.4

Descriptive statistics

Standard deviation	7.6674118
Coefficient of variation (CV)	0.5407322
Kurtosis	8.7947153
Mean	14.179684
Median Absolute Deviation (MAD)	3.85
Skewness	2.097611
Sum	54790.3
Variance	58.789204
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.5	249	6.4%
9.0	218	5.6%
8.0	189	4.9%
12.1	177	4.6%
10.0	155	4.0%
19.5	125	3.2%
21.0	109	2.8%
12.6	98	2.5%
12.2	96	2.5%
12.0	90	2.3%
Other values (310)	2358	61.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.0	1	< 0.1%
2.5	5	0.1%
2.6	1	< 0.1%
3.0	6	0.2%
3.1	1	< 0.1%
3.3	2	0.1%
3.4	1	< 0.1%
3.5	10	0.3%
3.6	1	< 0.1%
3.8	2	0.1%

Value	Count	Frequency (%)
80.0	1	< 0.1%
77.8	1	< 0.1%
76.5	1	< 0.1%
75.0	1	< 0.1%
73.0	1	< 0.1%
66.0	2	0.1%
61.3	1	< 0.1%
60.0	2	0.1%
51.4	1	< 0.1%
50.7	1	< 0.1%

유효폭
Real number (ℝ)

HIGH CORRELATION

Distinct	284
Distinct (%)	7.4%
Missing	15
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	12.228605

Minimum	0
Maximum	80
Zeros	3
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	8
median	11
Q3	15.7
95-th percentile	23.24
Maximum	80
Range	80
Interquartile range (IQR)	7.7

Descriptive statistics

Standard deviation	6.5595026
Coefficient of variation (CV)	0.53640646
Kurtosis	11.044127
Mean	12.228605
Median Absolute Deviation (MAD)	3.5
Skewness	2.1170727
Sum	47067.9
Variance	43.027074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.4	286	7.4%
8.0	282	7.3%
7.0	216	5.6%
9.0	180	4.7%
14.0	151	3.9%
11.7	151	3.9%
9.5	109	2.8%
18.5	107	2.8%
10.0	97	2.5%
20.0	88	2.3%
Other values (274)	2182	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	3	0.1%
2.0	2	0.1%
2.4	1	< 0.1%
2.5	9	0.2%
2.6	1	< 0.1%
3.0	11	0.3%
3.1	4	0.1%
3.2	3	0.1%
3.4	2	0.1%
3.5	31	0.8%

Value	Count	Frequency (%)
80.0	1	< 0.1%
76.8	1	< 0.1%
75.0	1	< 0.1%
73.0	1	< 0.1%
48.6	1	< 0.1%
46.7	1	< 0.1%
45.3	1	< 0.1%
44.7	1	< 0.1%
44.2	1	< 0.1%
43.6	1	< 0.1%

교고
Real number (ℝ)

HIGH CORRELATION

Distinct	275
Distinct (%)	7.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	7.5890758

Minimum	0
Maximum	109.7
Zeros	11
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3.5
median	5.5
Q3	8.5
95-th percentile	21.2
Maximum	109.7
Range	109.7
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	7.1493
Coefficient of variation (CV)	0.94205146
Kurtosis	25.107025
Mean	7.5890758
Median Absolute Deviation (MAD)	2.4
Skewness	3.759915
Sum	29316.6
Variance	51.112491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.0	294	7.6%
3.0	234	6.1%
2.0	184	4.8%
4.0	138	3.6%
6.0	135	3.5%
2.5	118	3.1%
3.5	103	2.7%
7.0	103	2.7%
4.5	85	2.2%
10.0	71	1.8%
Other values (265)	2398	62.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	11	0.3%
0.8	1	< 0.1%
1.0	5	0.1%
1.1	2	0.1%
1.2	4	0.1%
1.3	3	0.1%
1.4	2	0.1%
1.5	11	0.3%
1.6	3	0.1%
1.7	6	0.2%

Value	Count	Frequency (%)
109.7	1	< 0.1%
92.0	1	< 0.1%
64.0	1	< 0.1%
56.5	1	< 0.1%
54.2	1	< 0.1%
54.0	2	0.1%
52.0	2	0.1%
51.5	2	0.1%
48.7	1	< 0.1%
47.1	1	< 0.1%

경간수
Real number (ℝ)

HIGH CORRELATION

Distinct	28
Distinct (%)	0.7%
Missing	3
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.049469

Minimum	1
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	3.25296
Coefficient of variation (CV)	1.06673
Kurtosis	82.883113
Mean	3.049469
Median Absolute Deviation (MAD)	1
Skewness	5.8997594
Sum	11774
Variance	10.581749
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
1	1379	35.7%
2	819	21.2%
3	683	17.7%
4	318	8.2%
5	191	4.9%
6	120	3.1%
7	75	1.9%
8	61	1.6%
9	58	1.5%
10	38	1.0%
Other values (18)	119	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1379	35.7%
2	819	21.2%
3	683	17.7%
4	318	8.2%
5	191	4.9%
6	120	3.1%
7	75	1.9%
8	61	1.6%
9	58	1.5%
10	38	1.0%

Value	Count	Frequency (%)
76	1	< 0.1%
45	1	< 0.1%
34	1	< 0.1%
29	1	< 0.1%
26	1	< 0.1%
25	1	< 0.1%
24	9	0.2%
23	1	< 0.1%
21	2	0.1%
20	2	0.1%

최대경간장
Real number (ℝ)

HIGH CORRELATION

Distinct	326
Distinct (%)	8.5%
Missing	15
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	23.597038

Minimum	1
Maximum	475
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	1
5-th percentile	5.34
Q1	11
median	15
Q3	30.1
95-th percentile	55
Maximum	475
Range	474
Interquartile range (IQR)	19.1

Descriptive statistics

Standard deviation	22.371172
Coefficient of variation (CV)	0.94804998
Kurtosis	98.423378
Mean	23.597038
Median Absolute Deviation (MAD)	7
Skewness	6.7933225
Sum	90825
Variance	500.46932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30.0	342	8.9%
15.0	277	7.2%
12.0	228	5.9%
50.0	212	5.5%
10.0	195	5.0%
8.0	126	3.3%
11.0	119	3.1%
35.0	96	2.5%
14.0	94	2.4%
13.0	89	2.3%
Other values (316)	2071	53.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.0	1	< 0.1%
2.3	1	< 0.1%
2.4	2	0.1%
2.9	1	< 0.1%
3.0	18	0.5%
3.1	1	< 0.1%
3.2	4	0.1%
3.3	4	0.1%
3.4	19	0.5%
3.5	6	0.2%

Value	Count	Frequency (%)
475.0	1	< 0.1%
404.0	1	< 0.1%
400.0	1	< 0.1%
280.0	1	< 0.1%
230.0	2	0.1%
202.0	1	< 0.1%
200.0	1	< 0.1%
190.0	1	< 0.1%
182.0	1	< 0.1%
180.0	1	< 0.1%

상부구조
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

라멘교	1353
RC슬래브교	794
PSC I형교	743
강상자형교	478
RC T형교	112
Other values (13)	384

Length

Max length	9
Median length	8
Mean length	4.9748965
Min length	2

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	라멘교
2nd row	강상자형교
3rd row	강상자형교
4th row	강상자형교
5th row	강상자형교

Common Values

Value	Count	Frequency (%)
라멘교	1353	35.0%
RC슬래브교	794	20.5%
PSC I형교	743	19.2%
강상자형교	478	12.4%
RC T형교	112	2.9%
프리플렉스형교	86	2.2%
PSC상자형교	81	2.1%
RC상자형교	48	1.2%
기타	47	1.2%
PSC슬래브교	29	0.8%
Other values (8)	93	2.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
라멘교	1353	28.7%
rc슬래브교	794	16.8%
psc	743	15.7%
i형교	743	15.7%
강상자형교	478	10.1%
rc	112	2.4%
t형교	112	2.4%
프리플렉스형교	86	1.8%
psc상자형교	81	1.7%
rc상자형교	48	1.0%
Other values (10)	169	3.6%

하부구조
Categorical

Distinct	18
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

기타	1161
T형 교각식	636
역 T형식교대	570
라멘식	416
벽식	322
Other values (13)	759

Length

Max length	7
Median length	6
Mean length	3.9011387
Min length	2

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	기타
2nd row	T형 교각식
3rd row	T형 교각식
4th row	역 T형식교대
5th row	기타

Common Values

Value	Count	Frequency (%)
기타	1161	30.0%
T형 교각식	636	16.5%
역 T형식교대	570	14.8%
라멘식	416	10.8%
벽식	322	8.3%
중력식	284	7.3%
중력식교대	124	3.2%
반중력식	83	2.1%
구주식	67	1.7%
반중력식교대	60	1.6%
Other values (8)	141	3.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
기타	1161	22.8%
교각식	642	12.6%
t형	636	12.5%
역	570	11.2%
t형식교대	570	11.2%
라멘식	416	8.2%
벽식	322	6.3%
중력식	284	5.6%
중력식교대	124	2.4%
반중력식	83	1.6%
Other values (11)	275	5.4%

설계하중
Categorical

IMBALANCE

Distinct	9
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	30.3 KiB

DB-24	3075
DB-18	490
DB-13.5	249
미상	23
DB-24(성능개선)	13
Other values (4)	14

Length

Max length	11
Median length	5
Mean length	5.1270704
Min length	2

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DB-24
2nd row	DB-24
3rd row	DB-24
4th row	DB-24
5th row	DB-24

Common Values

Value	Count	Frequency (%)
DB-24	3075	79.6%
DB-18	490	12.7%
DB-13.5	249	6.4%
미상	23	0.6%
DB-24(성능개선)	13	0.3%
기타	9	0.2%
T12 또는 D12	2	0.1%
DB-9	2	0.1%
T9 또는 D9	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
db-24	3075	79.5%
db-18	490	12.7%
db-13.5	249	6.4%
미상	23	0.6%
db-24(성능개선	13	0.3%
기타	9	0.2%
또는	3	0.1%
t12	2	0.1%
d12	2	0.1%
db-9	2	0.1%
Other values (2)	2	0.1%

교통량
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	989
Distinct (%)	28.6%
Missing	402
Missing (%)	10.4%
Infinite	0
Infinite (%)	0.0%
Mean	18427.281

Minimum	0
Maximum	72984
Zeros	201
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1335
median	7192
Q3	23679
95-th percentile	72984
Maximum	72984
Range	72984
Interquartile range (IQR)	22344

Descriptive statistics

Standard deviation	22937.563
Coefficient of variation (CV)	1.2447611
Kurtosis	0.43920351
Mean	18427.281
Median Absolute Deviation (MAD)	6824
Skewness	1.3103663
Sum	63795247
Variance	5.2613181 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	201	5.2%
72984	185	4.8%
23679	181	4.7%
70581	164	4.2%
50510	160	4.1%
19917	89	2.3%
43113	71	1.8%
42192	29	0.8%
21868	20	0.5%
9467	19	0.5%
Other values (979)	2343	60.6%
(Missing)	402	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	201	5.2%
1	1	< 0.1%
10	3	0.1%
15	3	0.1%
20	5	0.1%
30	2	0.1%
31	1	< 0.1%
50	1	< 0.1%
66	1	< 0.1%
72	1	< 0.1%

Value	Count	Frequency (%)
72984	185	4.8%
70964	3	0.1%
70581	164	4.2%
62042	1	< 0.1%
56700	8	0.2%
56544	6	0.2%
56204	6	0.2%
54000	1	< 0.1%
52567	1	< 0.1%
52189	1	< 0.1%

준공년도
Real number (ℝ)

Distinct	65
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2039.8476

Minimum	0
Maximum	8888
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	34.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1979
Q1	1994
median	2001
Q3	2007
95-th percentile	2015
Maximum	8888
Range	8888
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	531.08616
Coefficient of variation (CV)	0.26035581
Kurtosis	161.91267
Mean	2039.8476
Median Absolute Deviation (MAD)	6
Skewness	12.756608
Sum	7881971
Variance	282052.51
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2005	242	6.3%
1998	222	5.7%
1996	222	5.7%
2001	214	5.5%
2006	186	4.8%
2015	181	4.7%
2011	144	3.7%
1992	144	3.7%
1995	131	3.4%
2004	131	3.4%
Other values (55)	2047	53.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1927	1	< 0.1%
1934	3	0.1%
1940	1	< 0.1%
1941	1	< 0.1%
1942	1	< 0.1%
1943	3	0.1%
1956	1	< 0.1%
1961	1	< 0.1%
1963	2	0.1%

Value	Count	Frequency (%)
8888	23	0.6%
2017	41	1.1%
2016	23	0.6%
2015	181	4.7%
2014	95	2.5%
2013	74	1.9%
2012	74	1.9%
2011	144	3.7%
2010	120	3.1%
2009	81	2.1%

Heatmap
Table

	도로종류	노선명	시군구	교장	총폭	유효폭	교고	경간수	최대경간장	상부구조	하부구조	설계하중	교통량	준공년도
도로종류	1.000	1.000	0.698	0.166	0.503	0.382	0.249	0.082	0.206	0.570	0.544	0.417	0.668	0.199
노선명	1.000	1.000	0.944	0.224	0.550	0.547	0.328	0.226	0.456	0.796	0.720	0.666	0.932	0.241
시군구	0.698	0.944	1.000	0.169	0.241	0.275	0.329	0.035	0.295	0.299	0.357	0.205	0.657	0.100
교장	0.166	0.224	0.169	1.000	0.087	0.049	0.628	0.756	0.641	0.638	0.435	0.037	0.184	0.000
총폭	0.503	0.550	0.241	0.087	1.000	0.875	0.142	0.066	0.062	0.305	0.368	0.321	0.565	0.000
유효폭	0.382	0.547	0.275	0.049	0.875	1.000	0.133	0.043	0.000	0.276	0.335	0.338	0.388	0.036
교고	0.249	0.328	0.329	0.628	0.142	0.133	1.000	0.268	0.730	0.520	0.407	0.101	0.283	0.000
경간수	0.082	0.226	0.035	0.756	0.066	0.043	0.268	1.000	0.206	0.312	0.213	0.000	0.163	0.000
최대경간장	0.206	0.456	0.295	0.641	0.062	0.000	0.730	0.206	1.000	0.843	0.538	0.092	0.176	0.000
상부구조	0.570	0.796	0.299	0.638	0.305	0.276	0.520	0.312	0.843	1.000	0.820	0.475	0.388	0.041
하부구조	0.544	0.720	0.357	0.435	0.368	0.335	0.407	0.213	0.538	0.820	1.000	0.502	0.408	0.057
설계하중	0.417	0.666	0.205	0.037	0.321	0.338	0.101	0.000	0.092	0.475	0.502	1.000	0.280	0.679
교통량	0.668	0.932	0.657	0.184	0.565	0.388	0.283	0.163	0.176	0.388	0.408	0.280	1.000	0.070
준공년도	0.199	0.241	0.100	0.000	0.000	0.036	0.000	0.000	0.000	0.041	0.057	0.679	0.070	1.000

Heatmap
Table

	도로종류	상부구조	하부구조	설계하중	시군구
도로종류	1.000	0.264	0.248	0.222	0.360
상부구조	0.264	1.000	0.317	0.176	0.088
하부구조	0.248	0.317	1.000	0.189	0.107
설계하중	0.222	0.176	0.189	1.000	0.079
시군구	0.360	0.088	0.107	0.079	1.000

Heatmap
Table

	교장	총폭	유효폭	교고	경간수	최대경간장	교통량	준공년도	도로종류	시군구	상부구조	하부구조	설계하중
교장	1.000	0.133	0.129	0.620	0.731	0.791	0.193	0.227	0.083	0.065	0.265	0.158	0.012
총폭	0.133	1.000	0.948	0.344	-0.106	0.307	0.555	0.348	0.293	0.092	0.120	0.149	0.152
유효폭	0.129	0.948	1.000	0.353	-0.118	0.313	0.572	0.346	0.272	0.113	0.134	0.154	0.156
교고	0.620	0.344	0.353	1.000	0.264	0.708	0.452	0.401	0.141	0.138	0.248	0.183	0.049
경간수	0.731	-0.106	-0.118	0.264	1.000	0.219	-0.094	-0.121	0.046	0.000	0.143	0.096	0.000
최대경간장	0.791	0.307	0.313	0.708	0.219	1.000	0.398	0.463	0.116	0.126	0.562	0.260	0.045
교통량	0.193	0.555	0.572	0.452	-0.094	0.398	1.000	0.202	0.431	0.309	0.159	0.169	0.131
준공년도	0.227	0.348	0.346	0.401	-0.121	0.463	0.202	1.000	0.084	0.045	0.018	0.026	0.389
도로종류	0.083	0.293	0.272	0.141	0.046	0.116	0.431	0.084	1.000	0.360	0.264	0.248	0.222
시군구	0.065	0.092	0.113	0.138	0.000	0.126	0.309	0.045	0.360	1.000	0.088	0.107	0.079
상부구조	0.265	0.120	0.134	0.248	0.143	0.562	0.159	0.018	0.264	0.088	1.000	0.317	0.176
하부구조	0.158	0.149	0.154	0.183	0.096	0.260	0.169	0.026	0.248	0.107	0.317	1.000	0.189
설계하중	0.012	0.152	0.156	0.049	0.000	0.045	0.131	0.389	0.222	0.079	0.176	0.189	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

	도로종류	노선명	시설명	시도	시군구	읍면동	리	교장	총폭	유효폭	교고	경간수	최대경간장	상부구조	하부구조	설계하중	교통량	준공년도
0	일반국도	일반국도14호선	계룡산교	경상남도	거제시	장평동	<NA>	13.5	20.0	20.0	5.0	1	13.5	라멘교	기타	DB-24	15424	2015
1	일반국도	일반국도14호선	고현1교	경상남도	거제시	상동동	<NA>	230.0	20.9	20.0	5.0	5	50.0	강상자형교	T형 교각식	DB-24	15424	2015
2	일반국도	일반국도14호선	고현2교	경상남도	거제시	상동동	<NA>	150.0	20.9	20.0	5.0	3	50.0	강상자형교	T형 교각식	DB-24	15424	2015
3	일반국도	일반국도14호선	고현3교	경상남도	거제시	상동동	<NA>	50.0	20.9	20.0	5.0	1	50.0	강상자형교	역 T형식교대	DB-24	15424	2015
4	일반국도	일반국도14호선	고현천교	경상남도	거제시	문동동	<NA>	100.0	30.8	29.4	22.5	3	40.0	강상자형교	기타	DB-24	35826	2013
5	일반국도	일반국도14호선	문동1교	경상남도	거제시	양정동	<NA>	315.0	20.9	19.4	16.0	9	35.0	PSC I형교	π형 교각	DB-24	35826	2013
6	일반국도	일반국도14호선	문동2교	경상남도	거제시	상동동	<NA>	50.0	20.9	20.0	5.0	1	50.0	강상자형교	역 T형식교대	DB-24	35826	2016
7	일반국도	일반국도14호선	문동3교	경상남도	거제시	상동동	<NA>	300.0	20.9	20.0	5.0	6	50.0	강상자형교	T형 교각식	DB-24	15424	2015
8	일반국도	일반국도14호선	사곡교	경상남도	거제시	사등면	사곡리	11.4	19.5	18.5	4.0	1	11.4	라멘교	기타	DB-24	56204	1994
9	일반국도	일반국도14호선	사곡입체교	경상남도	거제시	사등면	사곡리	12.4	22.8	20.0	4.5	1	12.4	라멘교	기타	DB-24	56204	1998

	도로종류	노선명	시설명	시도	시군구	읍면동	리	교장	총폭	유효폭	교고	경간수	최대경간장	상부구조	하부구조	설계하중	교통량	준공년도
3854	군도	<NA>	중문2교	경상남도	합천군	삼가면	문송리	8.6	4.1	4.1	3.0	1	8.6	RC슬래브교	역 T형식교대	DB-13.5	256	1990
3855	군도	<NA>	진읍교	경상남도	합천군	율곡면	갑산리	12.0	6.2	5.9	2.0	1	12.0	RC T형교	중력식교대	DB-13.5	422	1985
3856	군도	<NA>	청현2교	경상남도	합천군	가야면	청현리	9.4	5.0	4.5	5.0	1	9.4	라멘교	기타	DB-9	968	1977
3857	군도	<NA>	택계교	경상남도	합천군	용주면	황계리	22.5	7.5	6.7	3.0	2	11.5	라멘교	기타	DB-24	312	2004
3858	군도	<NA>	평촌교	경상남도	합천군	청덕면	운봉리	12.0	8.6	7.5	3.0	2	6.0	라멘교	기타	DB-24	524	1996
3859	군도	<NA>	포두교	경상남도	합천군	덕곡면	포두리	24.0	6.4	5.0	6.0	2	12.0	RC슬래브교	T형 교각식	DB-18	<NA>	1987
3860	군도	<NA>	하남1교	경상남도	합천군	초계면	상대리	9.7	5.5	5.0	2.0	1	9.7	RC T형교	중력식교대	DB-24	50	1987
3861	군도	<NA>	하용계1교	경상남도	합천군	합천읍	용계리	7.9	8.4	7.8	2.0	1	7.9	RC슬래브교	중력식교대	DB-13.5	72	1968
3862	군도	<NA>	황계교	경상남도	합천군	용주면	황계리	19.0	5.0	4.7	2.0	3	7.0	RC슬래브교	중력식	DB-13.5	510	1975
3863	군도	<NA>	회양교	경상남도	합천군	대병면	회양리	39.0	9.5	8.0	6.0	3	13.0	RC슬래브교	라멘식	DB-18	1809	1987

Overview

Variables

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

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Open Punctuation

Close Punctuation

Dash Punctuation

Space Separator

Math Symbol

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

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

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

Common Values

Length

Common Values

Length

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample