gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	500
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	72.4 KiB
Average record size in memory	148.3 B

Variable types

Categorical	3
Numeric	11
Text	3

Dataset

Description	샘플 데이터
Author	서울시(스마트카드사)
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=14

Alerts

`조합구분` is highly overall correlated with `교통수단코드` and 5 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
`정류장ID` 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 2 other fields	High correlation
`총누적거리(km)` is highly overall correlated with `정류장수` and 4 other fields	High correlation
`정류장누적거리(m)` is highly overall correlated with `정류장수` and 3 other fields	High correlation
`종료일자` is highly imbalanced (93.6%)	Imbalance
`정류장누적거리(m)` has 7 (1.4%) zeros	Zeros
`정류장간차이(m)` has 7 (1.4%) zeros	Zeros

Reproduction

Analysis started	2024-04-16 11:26:27.980476
Analysis finished	2024-04-16 11:26:39.951983
Duration	11.97 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

조합구분
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

시내	394
마을	106

Length

Max length	2
Median length	2
Mean length	2
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 (%)
시내	394	78.8%
마을	106	21.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
시내	394	78.8%
마을	106	21.2%

버스노선ID
Real number (ℝ)

Distinct	309
Distinct (%)	61.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18192736

Minimum	11110001
Maximum	41110219
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11110001
5-th percentile	11110024
Q1	11110194
median	11110582
Q3	11111158
95-th percentile	41110155
Maximum	41110219
Range	30000218
Interquartile range (IQR)	964.25

Descriptive statistics

Standard deviation	12749981
Coefficient of variation (CV)	0.70082813
Kurtosis	-0.44630022
Mean	18192736
Median Absolute Deviation (MAD)	407
Skewness	1.2471877
Sum	9.096368 × 10⁹
Variance	1.6256202 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11110193	6	1.2%
11110213	5	1.0%
11110039	5	1.0%
41110092	5	1.0%
11110268	5	1.0%
41110012	5	1.0%
41110216	5	1.0%
11110032	4	0.8%
11110070	4	0.8%
41110013	4	0.8%
Other values (299)	452	90.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110001	4	0.8%
11110002	2	0.4%
11110006	1	0.2%
11110009	2	0.4%
11110010	1	0.2%
11110011	3	0.6%
11110012	1	0.2%
11110013	2	0.4%
11110014	2	0.4%
11110016	2	0.4%

Value	Count	Frequency (%)
41110219	4	0.8%
41110218	1	0.2%
41110216	5	1.0%
41110215	1	0.2%
41110214	1	0.2%
41110211	3	0.6%
41110210	2	0.4%
41110209	3	0.6%
41110206	1	0.2%
41110205	1	0.2%

교통수단코드
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.93

Minimum	105
Maximum	131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	105
5-th percentile	105
Q1	115
median	115
Q3	120
95-th percentile	130
Maximum	131
Range	26
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	6.9297289
Coefficient of variation (CV)	0.059775113
Kurtosis	-0.12428884
Mean	115.93
Median Absolute Deviation (MAD)	5
Skewness	-0.050140305
Sum	57965
Variance	48.021142
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
120	180	36.0%
115	169	33.8%
105	106	21.2%
131	22	4.4%
130	15	3.0%
121	8	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
105	106	21.2%
115	169	33.8%
120	180	36.0%
121	8	1.6%
130	15	3.0%
131	22	4.4%

Value	Count	Frequency (%)
131	22	4.4%
130	15	3.0%
121	8	1.6%
120	180	36.0%
115	169	33.8%
105	106	21.2%

교통수단명
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

지선버스(120)	180
간선버스	169
마을버스(105)	106
심야버스(131)	22
광역버스(130)	15

Length

Max length	9
Median length	9
Mean length	7.31
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	마을버스(105)
2nd row	마을버스(105)
3rd row	마을버스(105)
4th row	마을버스(105)
5th row	마을버스(105)

Common Values

Value	Count	Frequency (%)
지선버스(120)	180	36.0%
간선버스	169	33.8%
마을버스(105)	106	21.2%
심야버스(131)	22	4.4%
광역버스(130)	15	3.0%
지선버스(121)	8	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
지선버스(120	180	36.0%
간선버스	169	33.8%
마을버스(105	106	21.2%
심야버스(131	22	4.4%
광역버스(130	15	3.0%
지선버스(121	8	1.6%

노선명
Text

Distinct	309
Distinct (%)	61.8%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	25
Median length	22
Mean length	16.24
Min length	12

Characters and Unicode

Total characters	8120
Distinct characters	271
Distinct categories	9 ?
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	191 ?
Unique (%)	38.2%

Sample

1st row	은평06(대성중.고등학교~불광동팀수양관)
2nd row	금천01(적.독산역~벽산아파트)
3rd row	금천10(독산역~디지털3단지운동장)
4th row	양천01(동신아파트~당산역)
5th row	종로13(평창동주민센터~부암동주민센터)

Value	Count	Frequency (%)
2233번(면목동~옥수동	6	1.2%
덕정~종로5가	5	1.0%
360번(송파차고지~여의도	5	1.0%
542번(군포터미널~강남역	5	1.0%
6511번(구로동~서울대	5	1.0%
703번(문산선유리~서울역환승센터	5	1.0%
3413번(강일동공영차고지~수서경찰서	5	1.0%
108번(양주	5	1.0%
271번(면목동~상암동	4	0.8%
262번(중랑공영차고지~국회의사당	4	0.8%
Other values (307)	468	90.5%

Most occurring characters

Value	Count	Frequency (%)
)	502	6.2%
(	502	6.2%
~	500	6.2%
번	364	4.5%
동	339	4.2%
1	337	4.2%
0	230	2.8%
역	214	2.6%
2	212	2.6%
지	209	2.6%
Other values (261)	4711	58.0%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	4918	60.6%
Decimal Number	1619	19.9%
Close Punctuation	502	6.2%
Open Punctuation	502	6.2%
Math Symbol	500	6.2%
Other Punctuation	30	0.4%
Uppercase Letter	29	0.4%
Space Separator	17	0.2%
Dash Punctuation	3	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
번	364	7.4%
동	339	6.9%
역	214	4.4%
지	209	4.2%
고	190	3.9%
차	159	3.2%
서	113	2.3%
영	110	2.2%
공	96	2.0%
대	87	1.8%
Other values (241)	3037	61.8%

Decimal Number

Value	Count	Frequency (%)
1	337	20.8%
0	230	14.2%
2	212	13.1%
5	173	10.7%
6	172	10.6%
3	166	10.3%
7	130	8.0%
4	129	8.0%
9	42	2.6%
8	28	1.7%

Uppercase Letter

Value	Count	Frequency (%)
N	22	75.9%
A	4	13.8%
B	3	10.3%

Other Punctuation

Value	Count	Frequency (%)
,	17	56.7%
.	13	43.3%

Close Punctuation

Value	Count	Frequency (%)
)	502	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	502	100.0%

Math Symbol

Value	Count	Frequency (%)
~	500	100.0%

Space Separator

Value	Count	Frequency (%)
	17	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	4918	60.6%
Common	3173	39.1%
Latin	29	0.4%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
번	364	7.4%
동	339	6.9%
역	214	4.4%
지	209	4.2%
고	190	3.9%
차	159	3.2%
서	113	2.3%
영	110	2.2%
공	96	2.0%
대	87	1.8%
Other values (241)	3037	61.8%

Common

Value	Count	Frequency (%)
)	502	15.8%
(	502	15.8%
~	500	15.8%
1	337	10.6%
0	230	7.2%
2	212	6.7%
5	173	5.5%
6	172	5.4%
3	166	5.2%
7	130	4.1%
Other values (7)	249	7.8%

Latin

Value	Count	Frequency (%)
N	22	75.9%
A	4	13.8%
B	3	10.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	4918	60.6%
ASCII	3202	39.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
)	502	15.7%
(	502	15.7%
~	500	15.6%
1	337	10.5%
0	230	7.2%
2	212	6.6%
5	173	5.4%
6	172	5.4%
3	166	5.2%
7	130	4.1%
Other values (10)	278	8.7%

Hangul

Value	Count	Frequency (%)
번	364	7.4%
동	339	6.9%
역	214	4.4%
지	209	4.2%
고	190	3.9%
차	159	3.2%
서	113	2.3%
영	110	2.2%
공	96	2.0%
대	87	1.8%
Other values (241)	3037	61.8%

노선번호
Text

Distinct	304
Distinct (%)	60.8%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	6
Median length	4
Mean length	3.658
Min length	3

Characters and Unicode

Total characters	1829
Distinct characters	46
Distinct categories	4 ?
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	186 ?
Unique (%)	37.2%

Sample

1st row	은평06
2nd row	금천01
3rd row	금천10
4th row	양천01
5th row	종로13

Value	Count	Frequency (%)
n61	7	1.4%
2233	6	1.2%
542	5	1.0%
703	5	1.0%
6511	5	1.0%
108	5	1.0%
3413	5	1.0%
360	5	1.0%
302	4	0.8%
2311	4	0.8%
Other values (294)	449	89.8%

Most occurring characters

Value	Count	Frequency (%)
1	330	18.0%
0	230	12.6%
2	205	11.2%
6	172	9.4%
5	162	8.9%
3	160	8.7%
4	128	7.0%
7	125	6.8%
9	36	2.0%
8	27	1.5%
Other values (36)	254	13.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1575	86.1%
Other Letter	222	12.1%
Uppercase Letter	29	1.6%
Dash Punctuation	3	0.2%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
서	23	10.4%
동	18	8.1%
초	14	6.3%
강	14	6.3%
천	11	5.0%
로	9	4.1%
작	9	4.1%
봉	8	3.6%
도	8	3.6%
포	8	3.6%
Other values (22)	100	45.0%

Decimal Number

Value	Count	Frequency (%)
1	330	21.0%
0	230	14.6%
2	205	13.0%
6	172	10.9%
5	162	10.3%
3	160	10.2%
4	128	8.1%
7	125	7.9%
9	36	2.3%
8	27	1.7%

Uppercase Letter

Value	Count	Frequency (%)
N	22	75.9%
A	4	13.8%
B	3	10.3%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1578	86.3%
Hangul	222	12.1%
Latin	29	1.6%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
서	23	10.4%
동	18	8.1%
초	14	6.3%
강	14	6.3%
천	11	5.0%
로	9	4.1%
작	9	4.1%
봉	8	3.6%
도	8	3.6%
포	8	3.6%
Other values (22)	100	45.0%

Common

Value	Count	Frequency (%)
1	330	20.9%
0	230	14.6%
2	205	13.0%
6	172	10.9%
5	162	10.3%
3	160	10.1%
4	128	8.1%
7	125	7.9%
9	36	2.3%
8	27	1.7%

Latin

Value	Count	Frequency (%)
N	22	75.9%
A	4	13.8%
B	3	10.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1607	87.9%
Hangul	222	12.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	330	20.5%
0	230	14.3%
2	205	12.8%
6	172	10.7%
5	162	10.1%
3	160	10.0%
4	128	8.0%
7	125	7.8%
9	36	2.2%
8	27	1.7%
Other values (4)	32	2.0%

Hangul

Value	Count	Frequency (%)
서	23	10.4%
동	18	8.1%
초	14	6.3%
강	14	6.3%
천	11	5.0%
로	9	4.1%
작	9	4.1%
봉	8	3.6%
도	8	3.6%
포	8	3.6%
Other values (22)	100	45.0%

정류장ID
Real number (ℝ)

HIGH CORRELATION

Distinct	486
Distinct (%)	97.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3956314.8

Minimum	1911
Maximum	9133550
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1911
5-th percentile	8691.55
Q1	15580.75
median	75141
Q3	9005895
95-th percentile	9013845.2
Maximum	9133550
Range	9131639
Interquartile range (IQR)	8990314.2

Descriptive statistics

Standard deviation	4321263.5
Coefficient of variation (CV)	1.0922446
Kurtosis	-1.9464434
Mean	3956314.8
Median Absolute Deviation (MAD)	67027
Skewness	0.20772669
Sum	1.9781574 × 10⁹
Variance	1.8673318 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73202	2	0.4%
12869	2	0.4%
8002663	2	0.4%
8922	2	0.4%
70141	2	0.4%
8002386	2	0.4%
9012353	2	0.4%
7404	2	0.4%
8501377	2	0.4%
72079	2	0.4%
Other values (476)	480	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1911	1	0.2%
7197	2	0.4%
7256	1	0.2%
7404	2	0.4%
7452	1	0.2%
7479	1	0.2%
7569	1	0.2%
7634	1	0.2%
7651	1	0.2%
7684	1	0.2%

Value	Count	Frequency (%)
9133550	1	0.2%
9113188	1	0.2%
9110211	1	0.2%
9107116	1	0.2%
9037014	1	0.2%
9036937	1	0.2%
9036500	1	0.2%
9036413	1	0.2%
9036229	1	0.2%
9036137	1	0.2%

정류장명
Text

Distinct	465
Distinct (%)	93.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	18
Median length	15
Mean length	6.726
Min length	2

Characters and Unicode

Total characters	3363
Distinct characters	338
Distinct categories	5 ?
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	432 ?
Unique (%)	86.4%

Sample

1st row	새장골유래비
2nd row	범일운수종점
3rd row	구로세관
4th row	신목중학교
5th row	문방구

Value	Count	Frequency (%)
월곡뉴타운	3	0.6%
논현역	3	0.6%
독립문역.한성과학고	2	0.4%
종로2가	2	0.4%
신내교회.신내데시앙아파트	2	0.4%
광화문	2	0.4%
종로5가	2	0.4%
방화2동우촌연립	2	0.4%
불광역	2	0.4%
신반포역	2	0.4%
Other values (457)	480	95.6%

Most occurring characters

Value	Count	Frequency (%)
동	94	2.8%
트	79	2.3%
교	78	2.3%
구	76	2.3%
파	75	2.2%
아	75	2.2%
역	73	2.2%
.	70	2.1%
지	57	1.7%
학	53	1.6%
Other values (328)	2633	78.3%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	3169	94.2%
Decimal Number	99	2.9%
Other Punctuation	71	2.1%
Uppercase Letter	22	0.7%
Space Separator	2	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	94	3.0%
트	79	2.5%
교	78	2.5%
구	76	2.4%
파	75	2.4%
아	75	2.4%
역	73	2.3%
지	57	1.8%
학	53	1.7%
장	51	1.6%
Other values (309)	2458	77.6%

Decimal Number

Value	Count	Frequency (%)
1	25	25.3%
2	21	21.2%
3	11	11.1%
4	11	11.1%
5	10	10.1%
6	6	6.1%
7	5	5.1%
0	4	4.0%
9	3	3.0%
8	3	3.0%

Uppercase Letter

Value	Count	Frequency (%)
T	7	31.8%
K	6	27.3%
N	3	13.6%
S	3	13.6%
Y	2	9.1%
G	1	4.5%

Other Punctuation

Value	Count	Frequency (%)
.	70	98.6%
&	1	1.4%

Space Separator

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	3169	94.2%
Common	172	5.1%
Latin	22	0.7%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	94	3.0%
트	79	2.5%
교	78	2.5%
구	76	2.4%
파	75	2.4%
아	75	2.4%
역	73	2.3%
지	57	1.8%
학	53	1.7%
장	51	1.6%
Other values (309)	2458	77.6%

Common

Value	Count	Frequency (%)
.	70	40.7%
1	25	14.5%
2	21	12.2%
3	11	6.4%
4	11	6.4%
5	10	5.8%
6	6	3.5%
7	5	2.9%
0	4	2.3%
9	3	1.7%
Other values (3)	6	3.5%

Latin

Value	Count	Frequency (%)
T	7	31.8%
K	6	27.3%
N	3	13.6%
S	3	13.6%
Y	2	9.1%
G	1	4.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	3169	94.2%
ASCII	194	5.8%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
동	94	3.0%
트	79	2.5%
교	78	2.5%
구	76	2.4%
파	75	2.4%
아	75	2.4%
역	73	2.3%
지	57	1.8%
학	53	1.7%
장	51	1.6%
Other values (309)	2458	77.6%

ASCII

Value	Count	Frequency (%)
.	70	36.1%
1	25	12.9%
2	21	10.8%
3	11	5.7%
4	11	5.7%
5	10	5.2%
T	7	3.6%
K	6	3.1%
6	6	3.1%
7	5	2.6%
Other values (9)	22	11.3%

정류장수
Real number (ℝ)

HIGH CORRELATION

Distinct	123
Distinct (%)	24.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.52

Minimum	11
Maximum	182
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11
5-th percentile	24
Q1	50
median	84
Q3	113
95-th percentile	154
Maximum	182
Range	171
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	39.56038
Coefficient of variation (CV)	0.47366355
Kurtosis	-0.53671618
Mean	83.52
Median Absolute Deviation (MAD)	30
Skewness	0.23041268
Sum	41760
Variance	1565.0236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	13	2.6%
119	12	2.4%
87	12	2.4%
32	10	2.0%
111	10	2.0%
101	10	2.0%
113	10	2.0%
36	9	1.8%
99	9	1.8%
28	9	1.8%
Other values (113)	396	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	1	0.2%
12	1	0.2%
13	1	0.2%
14	2	0.4%
16	2	0.4%
18	3	0.6%
19	3	0.6%
20	1	0.2%
21	3	0.6%
22	1	0.2%

Value	Count	Frequency (%)
182	5	1.0%
179	4	0.8%
178	3	0.6%
164	5	1.0%
160	3	0.6%
156	3	0.6%
154	3	0.6%
150	1	0.2%
147	1	0.2%
145	1	0.2%

정류장순서
Real number (ℝ)

HIGH CORRELATION

Distinct	125
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.43

Minimum	1
Maximum	170
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	16
median	36
Q3	67
95-th percentile	111.05
Maximum	170
Range	169
Interquartile range (IQR)	51

Descriptive statistics

Standard deviation	34.142885
Coefficient of variation (CV)	0.76846466
Kurtosis	0.062452795
Mean	44.43
Median Absolute Deviation (MAD)	23
Skewness	0.83391096
Sum	22215
Variance	1165.7366
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	14	2.8%
2	13	2.6%
6	12	2.4%
10	10	2.0%
29	9	1.8%
24	9	1.8%
3	9	1.8%
28	8	1.6%
21	8	1.6%
40	8	1.6%
Other values (115)	400	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7	1.4%
2	13	2.6%
3	9	1.8%
4	7	1.4%
5	6	1.2%
6	12	2.4%
7	5	1.0%
8	7	1.4%
9	6	1.2%
10	10	2.0%

Value	Count	Frequency (%)
170	1	0.2%
148	1	0.2%
144	1	0.2%
143	1	0.2%
138	1	0.2%
136	1	0.2%
131	2	0.4%
129	1	0.2%
128	1	0.2%
127	1	0.2%

정류장X좌표
Real number (ℝ)

Distinct	484
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12676.43

Minimum	12643.808
Maximum	12712.491
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	12643.808
5-th percentile	12649.995
Q1	12655.039
median	12658.597
Q3	12702.662
95-th percentile	12707.567
Maximum	12712.491
Range	68.6833
Interquartile range (IQR)	47.622525

Descriptive statistics

Standard deviation	24.459388
Coefficient of variation (CV)	0.0019295171
Kurtosis	-1.8910947
Mean	12676.43
Median Absolute Deviation (MAD)	8.3873
Skewness	0.21674616
Sum	6338215
Variance	598.26168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12659.677	2	0.4%
12700.6906	2	0.4%
12701.5418	2	0.4%
12657.7889	2	0.4%
12653.6741	2	0.4%
12648.6906	2	0.4%
12658.4331	2	0.4%
12658.188	2	0.4%
12701.6596	2	0.4%
12701.4251	2	0.4%
Other values (474)	480	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12643.8078	1	0.2%
12644.7353	1	0.2%
12644.7564	1	0.2%
12645.9914	1	0.2%
12646.02	1	0.2%
12646.0402	1	0.2%
12646.1583	1	0.2%
12646.5123	1	0.2%
12646.8852	1	0.2%
12646.9371	1	0.2%

Value	Count	Frequency (%)
12712.4911	1	0.2%
12710.7806	1	0.2%
12710.7161	1	0.2%
12710.397	1	0.2%
12710.224	1	0.2%
12709.4015	1	0.2%
12708.9101	1	0.2%
12708.7979	1	0.2%
12708.5269	1	0.2%
12708.5031	1	0.2%

정류장Y좌표
Real number (ℝ)

Distinct	486
Distinct (%)	97.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3732.6729

Minimum	3719.8596
Maximum	3747.106
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	3719.8596
5-th percentile	3726.1892
Q1	3729.6795
median	3732.7344
Q3	3735.5628
95-th percentile	3739.38
Maximum	3747.106
Range	27.2464
Interquartile range (IQR)	5.883275

Descriptive statistics

Standard deviation	4.3563809
Coefficient of variation (CV)	0.0011670942
Kurtosis	0.49868803
Mean	3732.6729
Median Absolute Deviation (MAD)	2.9879
Skewness	-0.0138393
Sum	1866336.5
Variance	18.978054
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3734.6996	2	0.4%
3736.3686	2	0.4%
3731.678	2	0.4%
3726.3295	2	0.4%
3730.3818	2	0.4%
3721.2411	2	0.4%
3732.8865	2	0.4%
3734.2036	2	0.4%
3738.29	2	0.4%
3728.5562	2	0.4%
Other values (476)	480	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3719.8596	1	0.2%
3720.2931	1	0.2%
3720.3639	1	0.2%
3721.0153	1	0.2%
3721.0522	1	0.2%
3721.0864	1	0.2%
3721.2411	2	0.4%
3721.4494	1	0.2%
3721.8651	1	0.2%
3722.2093	1	0.2%

Value	Count	Frequency (%)
3747.106	1	0.2%
3745.9321	1	0.2%
3745.2932	1	0.2%
3744.461	1	0.2%
3744.3719	1	0.2%
3743.2953	1	0.2%
3743.1467	1	0.2%
3742.7534	1	0.2%
3741.969	1	0.2%
3741.7461	1	0.2%

진입각도
Real number (ℝ)

Distinct	261
Distinct (%)	52.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	180.084

Minimum	0
Maximum	359
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	13.95
Q1	88
median	178
Q3	268
95-th percentile	344.05
Maximum	359
Range	359
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	105.8859
Coefficient of variation (CV)	0.58798063
Kurtosis	-1.1910912
Mean	180.084
Median Absolute Deviation (MAD)	90
Skewness	-0.0031536054
Sum	90042
Variance	11211.825
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75	6	1.2%
316	5	1.0%
232	5	1.0%
144	5	1.0%
3	5	1.0%
348	5	1.0%
338	5	1.0%
134	4	0.8%
96	4	0.8%
220	4	0.8%
Other values (251)	452	90.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.2%
1	1	0.2%
2	2	0.4%
3	5	1.0%
4	3	0.6%
5	1	0.2%
6	2	0.4%
8	1	0.2%
9	4	0.8%
10	2	0.4%

Value	Count	Frequency (%)
359	3	0.6%
358	3	0.6%
356	1	0.2%
354	1	0.2%
353	2	0.4%
352	1	0.2%
350	1	0.2%
349	1	0.2%
348	5	1.0%
347	3	0.6%

총누적거리(km)
Real number (ℝ)

HIGH CORRELATION

Distinct	308
Distinct (%)	61.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.838224

Minimum	1.636
Maximum	101.857
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1.636
5-th percentile	6.55085
Q1	18.1865
median	38.6015
Q3	55.458
95-th percentile	77.546
Maximum	101.857
Range	100.221
Interquartile range (IQR)	37.2715

Descriptive statistics

Standard deviation	23.201975
Coefficient of variation (CV)	0.59740053
Kurtosis	-0.68140122
Mean	38.838224
Median Absolute Deviation (MAD)	18.3745
Skewness	0.27522696
Sum	19419.112
Variance	538.33167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42.688	6	1.2%
55.757	5	1.0%
26.96	5	1.0%
88.542	5	1.0%
87.479	5	1.0%
38.616	5	1.0%
62.07	5	1.0%
51.611	4	0.8%
90.303	4	0.8%
77.546	4	0.8%
Other values (298)	452	90.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.636	1	0.2%
2.133	1	0.2%
2.741	2	0.4%
2.799	1	0.2%
3.364	1	0.2%
3.461	1	0.2%
3.625	1	0.2%
3.929	1	0.2%
4.094	1	0.2%
4.16	1	0.2%

Value	Count	Frequency (%)
101.857	3	0.6%
90.303	4	0.8%
89.968	3	0.6%
88.542	5	1.0%
87.479	5	1.0%
79.247	1	0.2%
78.964	2	0.4%
77.546	4	0.8%
76.151	2	0.4%
75.999	3	0.6%

정류장누적거리(m)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	489
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20343.33

Minimum	0
Maximum	91512
Zeros	7
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	520.6
Q1	5173
median	14531.5
Q3	32442
95-th percentile	53460.1
Maximum	91512
Range	91512
Interquartile range (IQR)	27269

Descriptive statistics

Standard deviation	18457.997
Coefficient of variation (CV)	0.90732425
Kurtosis	0.48903696
Mean	20343.33
Median Absolute Deviation (MAD)	11251
Skewness	1.023164
Sum	10171665
Variance	3.4069764 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7	1.4%
2002	3	0.6%
6640	2	0.4%
16402	2	0.4%
7129	2	0.4%
67024	1	0.2%
29412	1	0.2%
30715	1	0.2%
39010	1	0.2%
24613	1	0.2%
Other values (479)	479	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	1.4%
61	1	0.2%
130	1	0.2%
161	1	0.2%
196	1	0.2%
212	1	0.2%
251	1	0.2%
256	1	0.2%
278	1	0.2%
279	1	0.2%

Value	Count	Frequency (%)
91512	1	0.2%
87429	1	0.2%
77656	1	0.2%
74009	1	0.2%
72515	1	0.2%
71723	1	0.2%
71259	1	0.2%
70016	1	0.2%
69503	1	0.2%
69356	1	0.2%

정류장간차이(m)
Real number (ℝ)

ZEROS

Distinct	346
Distinct (%)	69.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	423.074

Minimum	0
Maximum	3588
Zeros	7
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	135.9
Q1	250
median	362
Q3	510
95-th percentile	837.7
Maximum	3588
Range	3588
Interquartile range (IQR)	260

Descriptive statistics

Standard deviation	304.70257
Coefficient of variation (CV)	0.72021105
Kurtosis	31.499345
Mean	423.074
Median Absolute Deviation (MAD)	124
Skewness	4.2048165
Sum	211537
Variance	92843.656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
243	7	1.4%
0	7	1.4%
362	5	1.0%
300	4	0.8%
410	4	0.8%
328	4	0.8%
262	4	0.8%
225	4	0.8%
539	3	0.6%
219	3	0.6%
Other values (336)	455	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	1.4%
59	1	0.2%
61	1	0.2%
88	1	0.2%
91	1	0.2%
93	1	0.2%
96	1	0.2%
99	2	0.4%
103	1	0.2%
105	1	0.2%

Value	Count	Frequency (%)
3588	1	0.2%
2518	1	0.2%
2291	1	0.2%
1809	1	0.2%
1666	1	0.2%
1587	1	0.2%
1574	1	0.2%
1559	1	0.2%
1391	1	0.2%
1194	1	0.2%

종료일자
Categorical

IMBALANCE

Distinct	5
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

99991231	492
20150903	3
20150824	2
20150901	2
20150803	1

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

1st row	99991231
2nd row	20150903
3rd row	20150824
4th row	99991231
5th row	99991231

Common Values

Value	Count	Frequency (%)
99991231	492	98.4%
20150903	3	0.6%
20150824	2	0.4%
20150901	2	0.4%
20150803	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
99991231	492	98.4%
20150903	3	0.6%
20150824	2	0.4%
20150901	2	0.4%
20150803	1	0.2%

Heatmap
Table

	조합구분	버스노선ID	교통수단코드	교통수단명	정류장ID	정류장수	정류장순서	정류장X좌표	정류장Y좌표	진입각도	총누적거리(km)	정류장누적거리(m)	정류장간차이(m)	종료일자
조합구분	1.000	0.395	1.000	1.000	0.487	0.928	0.551	0.062	0.186	0.000	0.950	0.672	0.289	0.145
버스노선ID	0.395	1.000	0.279	0.554	0.044	0.504	0.378	0.190	0.623	0.140	0.665	0.478	0.218	0.044
교통수단코드	1.000	0.279	1.000	1.000	0.587	0.822	0.552	0.349	0.139	0.000	0.916	0.674	0.264	0.169
교통수단명	1.000	0.554	1.000	1.000	0.870	0.690	0.428	0.235	0.232	0.000	0.786	0.537	0.282	0.067
정류장ID	0.487	0.044	0.587	0.870	1.000	0.557	0.381	0.094	0.037	0.144	0.605	0.444	0.380	0.104
정류장수	0.928	0.504	0.822	0.690	0.557	1.000	0.764	0.301	0.463	0.107	0.931	0.719	0.259	0.195
정류장순서	0.551	0.378	0.552	0.428	0.381	0.764	1.000	0.232	0.593	0.177	0.664	0.947	0.154	0.000
정류장X좌표	0.062	0.190	0.349	0.235	0.094	0.301	0.232	1.000	0.481	0.174	0.354	0.192	0.107	0.151
정류장Y좌표	0.186	0.623	0.139	0.232	0.037	0.463	0.593	0.481	1.000	0.173	0.419	0.709	0.000	0.561
진입각도	0.000	0.140	0.000	0.000	0.144	0.107	0.177	0.174	0.173	1.000	0.127	0.143	0.000	0.000
총누적거리(km)	0.950	0.665	0.916	0.786	0.605	0.931	0.664	0.354	0.419	0.127	1.000	0.767	0.234	0.159
정류장누적거리(m)	0.672	0.478	0.674	0.537	0.444	0.719	0.947	0.192	0.709	0.143	0.767	1.000	0.186	0.000
정류장간차이(m)	0.289	0.218	0.264	0.282	0.380	0.259	0.154	0.107	0.000	0.000	0.234	0.186	1.000	0.000
종료일자	0.145	0.044	0.169	0.067	0.104	0.195	0.000	0.151	0.561	0.000	0.159	0.000	0.000	1.000

Heatmap
Table

	종료일자	조합구분	교통수단명
종료일자	1.000	0.176	0.045
조합구분	0.176	1.000	0.996
교통수단명	0.045	0.996	1.000

Heatmap
Table

	버스노선ID	교통수단코드	정류장ID	정류장수	정류장순서	정류장X좌표	정류장Y좌표	진입각도	총누적거리(km)	정류장누적거리(m)	정류장간차이(m)	조합구분	교통수단명	종료일자
버스노선ID	1.000	0.075	0.180	0.057	0.025	-0.137	-0.160	0.068	0.095	0.041	0.010	0.256	0.397	0.053
교통수단코드	0.075	1.000	-0.463	0.388	0.246	0.002	0.007	-0.006	0.403	0.283	0.246	0.997	0.999	0.064
정류장ID	0.180	-0.463	1.000	-0.366	-0.271	-0.074	-0.031	0.024	-0.348	-0.289	-0.220	0.744	0.571	0.078
정류장수	0.057	0.388	-0.366	1.000	0.617	0.097	0.052	-0.013	0.941	0.649	0.299	0.768	0.452	0.082
정류장순서	0.025	0.246	-0.271	0.617	1.000	0.059	0.074	-0.032	0.583	0.975	0.253	0.422	0.241	0.000
정류장X좌표	-0.137	0.002	-0.074	0.097	0.059	1.000	0.179	-0.039	0.060	0.053	0.130	0.079	0.162	0.057
정류장Y좌표	-0.160	0.007	-0.031	0.052	0.074	0.179	1.000	-0.067	0.002	0.040	-0.042	0.143	0.119	0.265
진입각도	0.068	-0.006	0.024	-0.013	-0.032	-0.039	-0.067	1.000	0.006	-0.023	0.054	0.000	0.000	0.000
총누적거리(km)	0.095	0.403	-0.348	0.941	0.583	0.060	0.002	0.006	1.000	0.670	0.369	0.804	0.566	0.066
정류장누적거리(m)	0.041	0.283	-0.289	0.649	0.975	0.053	0.040	-0.023	0.670	1.000	0.333	0.519	0.317	0.000
정류장간차이(m)	0.010	0.246	-0.220	0.299	0.253	0.130	-0.042	0.054	0.369	0.333	1.000	0.287	0.144	0.000
조합구분	0.256	0.997	0.744	0.768	0.422	0.079	0.143	0.000	0.804	0.519	0.287	1.000	0.996	0.176
교통수단명	0.397	0.999	0.571	0.452	0.241	0.162	0.119	0.000	0.566	0.317	0.144	0.996	1.000	0.045
종료일자	0.053	0.064	0.078	0.082	0.000	0.057	0.265	0.000	0.066	0.000	0.000	0.176	0.045	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

	조합구분	버스노선ID	교통수단코드	교통수단명	노선명	노선번호	정류장ID	정류장명	정류장수	정류장순서	정류장X좌표	정류장Y좌표	진입각도	총누적거리(km)	정류장누적거리(m)	정류장간차이(m)	종료일자
0	마을	11110084	105	마을버스(105)	은평06(대성중.고등학교~불광동팀수양관)	은평06	9012124	새장골유래비	21	15	12655.4583	3737.2278	238	4.81	3329	331	99991231
1	마을	11110734	105	마을버스(105)	금천01(적.독산역~벽산아파트)	금천01	9012549	범일운수종점	28	19	12654.6651	3727.0356	278	8.028	5041	226	20150903
2	마을	11110751	105	마을버스(105)	금천10(독산역~디지털3단지운동장)	금천10	9037014	구로세관	20	17	12653.1025	3728.3456	156	5.494	4284	248	20150824
3	마을	11110696	105	마을버스(105)	양천01(동신아파트~당산역)	양천01	9007773	신목중학교	35	8	12652.318	3732.225	229	12.65	1836	174	99991231
4	마을	11110720	105	마을버스(105)	종로13(평창동주민센터~부암동주민센터)	종로13	9007311	문방구	37	8	12657.4795	3736.3777	233	7.642	1640	116	99991231
5	마을	11110685	105	마을버스(105)	성북15(고려아파트~한미약국)	성북15	9011172	현대2차아파트	18	7	12701.9178	3735.8705	83	2.133	678	91	99991231
6	마을	11111163	105	마을버스(105)	강남10(개포4단지7단지~양재역)	강남10	9012819	양재1동주민센터	44	20	12702.1922	3729.1045	263	15.481	6388	699	99991231
7	마을	11110806	105	마을버스(105)	서초18-1(서초네이처힐5단지~양재역)	서초18-1	9012801	교육개발원입구사거리	23	10	12702.3144	3728.7725	341	7.774	2706	282	99991231
8	마을	11110599	105	마을버스(105)	동작17(극동아파트~이수힐스테이트)	동작17	9036937	경문고교앞	25	11	12658.9602	3729.4295	3	5.754	2212	356	99991231
9	마을	11110517	105	마을버스(105)	강북05(번동초등학교~한일아파트)	강북05	9009013	롯데백화점	36	26	12701.8563	3736.8674	347	7.343	5039	214	99991231

	조합구분	버스노선ID	교통수단코드	교통수단명	노선명	노선번호	정류장ID	정류장명	정류장수	정류장순서	정류장X좌표	정류장Y좌표	진입각도	총누적거리(km)	정류장누적거리(m)	정류장간차이(m)	종료일자
490	시내	11110010	115	간선버스	130번(우이동~길동)	130	75114	길동주유소	84	42	12708.4026	3732.4558	93	49.176	24370	316	99991231
491	시내	41110211	115	간선버스	661번(부천상동~영등포역,신세계백화점)	661	15353	팰리스카운티아파트	122	8	12645.9914	3729.2898	100	53.182	2420	363	99991231
492	시내	11110059	115	간선버스	604번(신월동~중구청)	604	71018	광성중고등학교	86	62	12656.3857	3732.9383	299	45.616	32071	303	99991231
493	시내	11110354	120	지선버스(120)	7212번(은평차고지~옥수동)	7212	9002930	신사초등학교	140	127	12654.8132	3735.5908	315	59.213	52125	370	99991231
494	시내	11110892	120	지선버스(120)	2235(능말~신이문역)	2235	8003106	우림시장.망우사거리	44	10	12705.9281	3735.9821	254	14.777	3752	251	20150901
495	시내	11110048	115	간선버스	406번(개포동~서울역)	406	75143	방배프라자	70	50	12659.3956	3729.5973	153	42.947	33653	424	99991231
496	시내	11110213	120	지선버스(120)	3413번(강일동공영차고지~수서경찰서)	3413	12184	동명약국앞	87	69	12708.2612	3731.8488	16	38.616	32256	351	99991231
497	시내	11110860	120	지선버스(120)	6647(상사마을~송정중후문)	6647	8100935	상사마을기점	46	2	12648.1086	3735.3218	188	19.522	1666	1666	99991231
498	시내	11110198	120	지선버스(120)	3212번(강동공영차고지~강변역)	3212	12119	대순진리교	62	24	12707.8753	3731.8221	289	25.872	7998	287	99991231
499	시내	11110070	115	간선버스	752번(구산동~노량진)	752	75079	남성역	101	40	12658.2433	3729.0974	296	51.611	21082	243	99991231

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Uppercase Letter

Other Punctuation

Close Punctuation

Open Punctuation

Math Symbol

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample