gimi9 Pandas Profiling

Dataset statistics

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

Variable types

Numeric	9
Categorical	4
Unsupported	4
Boolean	1

Dataset

Description	경기도_BMS 카드데이터 기준 노선 경유정류소
Author	경기도
URL	https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=WY7XU78DB4FAYSR8TBBJ33212861&infSeq=1

Alerts

`사용구분` has constant value ""	Constant
`등록아이디` has constant value ""	Constant
`등록일자` has constant value ""	Constant
`진행구분코드명` 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 3 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 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
`링크순서` has 10000 (100.0%) missing values	Missing
`누적거리` has 5569 (55.7%) missing values	Missing
`확정거리` has 5569 (55.7%) missing values	Missing
`정류장간거리` has 10000 (100.0%) missing values	Missing
`수정아이디` has 10000 (100.0%) missing values	Missing
`갱신일자` has 10000 (100.0%) missing values	Missing
`링크순서` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`정류장간거리` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`수정아이디` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`갱신일자` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`정류장순서` has 167 (1.7%) zeros	Zeros
`누적거리` has 158 (1.6%) zeros	Zeros
`확정거리` has 158 (1.6%) zeros	Zeros
`정류장누적거리` has 241 (2.4%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 21:45:42.560212
Analysis finished	2023-12-10 21:45:52.423240
Duration	9.86 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

이비노선아이디
Real number (ℝ)

Distinct	991
Distinct (%)	9.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41004676

Minimum	41001001
Maximum	41014172
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	41001001
5-th percentile	41002044
Q1	41002571
median	41003683
Q3	41006322
95-th percentile	41009136
Maximum	41014172
Range	13171
Interquartile range (IQR)	3751

Descriptive statistics

Standard deviation	2578.3564
Coefficient of variation (CV)	6.2879571 × 10^-5
Kurtosis	1.1977027
Mean	41004676
Median Absolute Deviation (MAD)	1442
Skewness	1.1203992
Sum	4.1004676 × 10¹¹
Variance	6647921.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41002045	41	0.4%
41003006	40	0.4%
41007027	40	0.4%
41002028	39	0.4%
41007003	36	0.4%
41002042	33	0.3%
41009171	32	0.3%
41007024	32	0.3%
41006239	32	0.3%
41002210	31	0.3%
Other values (981)	9644	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41001001	17	0.2%
41001002	10	0.1%
41001013	28	0.3%
41001020	17	0.2%
41001024	24	0.2%
41001026	6	0.1%
41001027	16	0.2%
41001028	10	0.1%
41001029	11	0.1%
41001030	17	0.2%

Value	Count	Frequency (%)
41014172	9	0.1%
41014171	20	0.2%
41014168	17	0.2%
41014167	16	0.2%
41014122	4	< 0.1%
41014121	10	0.1%
41014120	23	0.2%
41014119	9	0.1%
41014118	10	0.1%
41014106	15	0.1%

정류장순서
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	206
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.6763

Minimum	0
Maximum	229
Zeros	167
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	15
median	32
Q3	59
95-th percentile	114
Maximum	229
Range	229
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	35.906326
Coefficient of variation (CV)	0.86155263
Kurtosis	1.9685285
Mean	41.6763
Median Absolute Deviation (MAD)	20
Skewness	1.3565691
Sum	416763
Variance	1289.2642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	195	1.9%
5	185	1.8%
3	181	1.8%
6	175	1.8%
13	169	1.7%
17	169	1.7%
0	167	1.7%
18	166	1.7%
9	165	1.7%
16	163	1.6%
Other values (196)	8265	82.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	167	1.7%
1	195	1.9%
2	153	1.5%
3	181	1.8%
4	160	1.6%
5	185	1.8%
6	175	1.8%
7	142	1.4%
8	150	1.5%
9	165	1.7%

Value	Count	Frequency (%)
229	1	< 0.1%
226	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%
216	1	< 0.1%
215	1	< 0.1%
213	1	< 0.1%
210	1	< 0.1%
208	1	< 0.1%
206	1	< 0.1%

노선아이디
Real number (ℝ)

HIGH CORRELATION

Distinct	991
Distinct (%)	9.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2993581 × 10⁸

Minimum	2.0000001 × 10⁸
Maximum	2.4000015 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2.0000001 × 10⁸
5-th percentile	2.1500017 × 10⁸
Q1	2.2800013 × 10⁸
median	2.3400015 × 10⁸
Q3	2.340014 × 10⁸
95-th percentile	2.4000002 × 10⁸
Maximum	2.4000015 × 10⁸
Range	40000134
Interquartile range (IQR)	6001265

Descriptive statistics

Standard deviation	8130080.9
Coefficient of variation (CV)	0.035358046
Kurtosis	2.6045599
Mean	2.2993581 × 10⁸
Median Absolute Deviation (MAD)	1000011
Skewness	-1.6370881
Sum	2.2993581 × 10¹²
Variance	6.6098216 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
234000024	41	0.4%
234000316	40	0.4%
217000012	40	0.4%
234000058	39	0.4%
217000006	36	0.4%
234000041	33	0.3%
240000105	32	0.3%
217000009	32	0.3%
228000002	32	0.3%
234000849	31	0.3%
Other values (981)	9644	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200000013	8	0.1%
200000104	14	0.1%
200000149	18	0.2%
200000150	16	0.2%
200000191	18	0.2%
200000265	26	0.3%
200000268	29	0.3%
204000005	6	0.1%
204000025	9	0.1%
204000035	17	0.2%

Value	Count	Frequency (%)
240000147	13	0.1%
240000144	10	0.1%
240000143	2	< 0.1%
240000139	2	< 0.1%
240000129	4	< 0.1%
240000117	4	< 0.1%
240000115	2	< 0.1%
240000105	32	0.3%
240000104	12	0.1%
240000098	5	0.1%

이비정류장아이디
Real number (ℝ)

Distinct	5912
Distinct (%)	59.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4292057.3

Minimum	4100015
Maximum	8020350
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4100015
5-th percentile	4102158
Q1	4115594
median	4151245
Q3	4174847.2
95-th percentile	4199942
Maximum	8020350
Range	3920335
Interquartile range (IQR)	59253.25

Descriptive statistics

Standard deviation	640506.2
Coefficient of variation (CV)	0.14923058
Kurtosis	15.533463
Mean	4292057.3
Median Absolute Deviation (MAD)	25389.5
Skewness	4.1769336
Sum	4.2920573 × 10¹⁰
Variance	4.1024819 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4160141	35	0.4%
4175623	33	0.3%
4160143	31	0.3%
4160146	30	0.3%
4197304	30	0.3%
4160145	29	0.3%
4160144	22	0.2%
4199942	21	0.2%
4160140	21	0.2%
4175491	18	0.2%
Other values (5902)	9730	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4100015	1	< 0.1%
4100017	1	< 0.1%
4100018	1	< 0.1%
4100024	1	< 0.1%
4100025	1	< 0.1%
4100028	1	< 0.1%
4100029	2	< 0.1%
4100032	1	< 0.1%
4100037	1	< 0.1%
4100058	1	< 0.1%

Value	Count	Frequency (%)
8020350	2	< 0.1%
8009290	1	< 0.1%
8000220	2	< 0.1%
7103993	1	< 0.1%
7103992	1	< 0.1%
7103903	3	< 0.1%
7103902	4	< 0.1%
7103769	1	< 0.1%
7103765	2	< 0.1%
7103725	1	< 0.1%

정류장아이디
Real number (ℝ)

HIGH CORRELATION

Distinct	5912
Distinct (%)	59.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2718434 × 10⁸

Minimum	1 × 10⁸
Maximum	5.0000021 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1 × 10⁸
5-th percentile	2.0200005 × 10⁸
Q1	2.2200137 × 10⁸
median	2.300007 × 10⁸
Q3	2.3700033 × 10⁸
95-th percentile	2.400013 × 10⁸
Maximum	5.0000021 × 10⁸
Range	4.0000021 × 10⁸
Interquartile range (IQR)	14998962

Descriptive statistics

Standard deviation	27276498
Coefficient of variation (CV)	0.12006328
Kurtosis	20.053801
Mean	2.2718434 × 10⁸
Median Absolute Deviation (MAD)	6999758.5
Skewness	-1.0345163
Sum	2.2718434 × 10¹²
Variance	7.4400732 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
237000666	35	0.4%
230001276	33	0.3%
237000664	31	0.3%
237000327	30	0.3%
237000665	30	0.3%
237000324	29	0.3%
237000663	22	0.2%
230001304	21	0.2%
237000661	21	0.2%
230000892	18	0.2%
Other values (5902)	9730	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100000001	1	< 0.1%
100000169	2	< 0.1%
100000174	1	< 0.1%
100000397	1	< 0.1%
101000001	3	< 0.1%
101000002	2	< 0.1%
101000005	2	< 0.1%
101000006	2	< 0.1%
101000026	2	< 0.1%
101000042	1	< 0.1%

Value	Count	Frequency (%)
500000212	3	< 0.1%
500000109	1	< 0.1%
500000108	1	< 0.1%
500000107	1	< 0.1%
500000106	2	< 0.1%
500000103	1	< 0.1%
500000018	1	< 0.1%
500000016	2	< 0.1%
277103993	1	< 0.1%
277103992	1	< 0.1%

회차정류장명
Categorical

HIGH CORRELATION

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

<NA>	5569
F	3103
B	1328

Length

Max length	4
Median length	4
Mean length	2.6707
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	5569	55.7%
F	3103	31.0%
B	1328	13.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	5569	55.7%
f	3103	31.0%
b	1328	13.3%

링크순서
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

누적거리
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	2581
Distinct (%)	58.2%
Missing	5569
Missing (%)	55.7%
Infinite	0
Infinite (%)	0.0%
Mean	17354.905

Minimum	0
Maximum	97160
Zeros	158
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	365
Q1	4855
median	12580
Q3	24410
95-th percentile	52735
Maximum	97160
Range	97160
Interquartile range (IQR)	19555

Descriptive statistics

Standard deviation	17025.815
Coefficient of variation (CV)	0.98103762
Kurtosis	3.1720761
Mean	17354.905
Median Absolute Deviation (MAD)	8850
Skewness	1.680152
Sum	76899585
Variance	2.8987838 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	158	1.6%
360	13	0.1%
5250	11	0.1%
3350	11	0.1%
1810	10	0.1%
6980	9	0.1%
2010	9	0.1%
590	9	0.1%
4470	8	0.1%
3120	8	0.1%
Other values (2571)	4185	41.9%
(Missing)	5569	55.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	1.6%
90	2	< 0.1%
130	2	< 0.1%
140	1	< 0.1%
170	3	< 0.1%
180	1	< 0.1%
190	3	< 0.1%
200	3	< 0.1%
210	7	0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
97160	1	< 0.1%
94930	1	< 0.1%
94650	1	< 0.1%
94380	1	< 0.1%
92240	1	< 0.1%
92230	1	< 0.1%
91640	1	< 0.1%
91570	1	< 0.1%
91560	1	< 0.1%
91250	1	< 0.1%

확정거리
Real number (ℝ)

MISSING ZEROS

Distinct	1037
Distinct (%)	23.4%
Missing	5569
Missing (%)	55.7%
Infinite	0
Infinite (%)	0.0%
Mean	556.69668

Minimum	0
Maximum	8660
Zeros	158
Zeros (%)	1.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	133
Q1	298.5
median	447
Q3	710.5
95-th percentile	1318.5
Maximum	8660
Range	8660
Interquartile range (IQR)	412

Descriptive statistics

Standard deviation	437.63939
Coefficient of variation (CV)	0.78613615
Kurtosis	40.875641
Mean	556.69668
Median Absolute Deviation (MAD)	187
Skewness	3.9281662
Sum	2466723
Variance	191528.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	158	1.6%
410	43	0.4%
250	37	0.4%
360	36	0.4%
300	36	0.4%
430	33	0.3%
330	32	0.3%
370	30	0.3%
310	29	0.3%
440	28	0.3%
Other values (1027)	3969	39.7%
(Missing)	5569	55.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	1.6%
1	1	< 0.1%
30	1	< 0.1%
50	2	< 0.1%
60	1	< 0.1%
70	1	< 0.1%
80	2	< 0.1%
82	1	< 0.1%
86	1	< 0.1%
88	1	< 0.1%

Value	Count	Frequency (%)
8660	1	< 0.1%
6240	1	< 0.1%
4409	1	< 0.1%
3886	1	< 0.1%
3880	1	< 0.1%
3623	2	< 0.1%
3621	1	< 0.1%
3523	2	< 0.1%
3490	1	< 0.1%
3344	1	< 0.1%

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

HIGH CORRELATION ZEROS

Distinct	4909
Distinct (%)	49.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24948.017

Minimum	0
Maximum	191370
Zeros	241
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	920
Q1	7580
median	18285
Q3	36152.5
95-th percentile	71221
Maximum	191370
Range	191370
Interquartile range (IQR)	28572.5

Descriptive statistics

Standard deviation	22551.96
Coefficient of variation (CV)	0.90395801
Kurtosis	2.1300497
Mean	24948.017
Median Absolute Deviation (MAD)	12720
Skewness	1.3467896
Sum	2.4948017 × 10⁸
Variance	5.0859089 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	241	2.4%
4360	13	0.1%
360	13	0.1%
2820	13	0.1%
3350	13	0.1%
2660	12	0.1%
1570	12	0.1%
5250	11	0.1%
1420	11	0.1%
410	11	0.1%
Other values (4899)	9650	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	241	2.4%
90	2	< 0.1%
130	2	< 0.1%
140	1	< 0.1%
170	3	< 0.1%
180	1	< 0.1%
190	3	< 0.1%
200	3	< 0.1%
210	7	0.1%
220	1	< 0.1%

Value	Count	Frequency (%)
191370	1	< 0.1%
183780	1	< 0.1%
172090	1	< 0.1%
168290	1	< 0.1%
165830	1	< 0.1%
158400	1	< 0.1%
140330	1	< 0.1%
136120	1	< 0.1%
135640	1	< 0.1%
130610	1	< 0.1%

정류장간거리
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

기관코드
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	7
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4.1525908 × 10⁹

Minimum	4.111 × 10⁹
Maximum	4.183 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4.111 × 10⁹
5-th percentile	4.113 × 10⁹
Q1	4.146 × 10⁹
median	4.161 × 10⁹
Q3	4.161 × 10⁹
95-th percentile	4.183 × 10⁹
Maximum	4.183 × 10⁹
Range	72000000
Interquartile range (IQR)	15000000

Descriptive statistics

Standard deviation	16874904
Coefficient of variation (CV)	0.004063705
Kurtosis	0.096391824
Mean	4.1525908 × 10⁹
Median Absolute Deviation (MAD)	0
Skewness	-0.65456845
Sum	4.149684 × 10¹³
Variance	2.8476239 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
4161000000	5190	51.9%
4146000000	1125	11.2%
4136000000	798	8.0%
4127000000	765	7.6%
4183000000	724	7.2%
4159000000	378	3.8%
4113000000	299	3.0%
4111000000	205	2.1%
4131000000	166	1.7%
4157000000	158	1.6%
Other values (2)	185	1.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4111000000	205	2.1%
4113000000	299	3.0%
4125000000	149	1.5%
4127000000	765	7.6%
4131000000	166	1.7%
4136000000	798	8.0%
4139000000	36	0.4%
4146000000	1125	11.2%
4157000000	158	1.6%
4159000000	378	3.8%

Value	Count	Frequency (%)
4183000000	724	7.2%
4161000000	5190	51.9%
4159000000	378	3.8%
4157000000	158	1.6%
4146000000	1125	11.2%
4139000000	36	0.4%
4136000000	798	8.0%
4131000000	166	1.7%
4127000000	765	7.6%
4125000000	149	1.5%

사용구분
Boolean

CONSTANT

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

True	10000

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	10000	100.0%

등록아이디
Categorical

CONSTANT

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

ETL_ADMIN	10000

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
ETL_ADMIN	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
etl_admin	10000	100.0%

등록일자
Categorical

CONSTANT

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

20190224234500	10000

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
20190224234500	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
20190224234500	10000	100.0%

수정아이디
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

갱신일자
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

진행구분코드명
Categorical

HIGH CORRELATION

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

<NA>	5569
상행	3103
하행	1328

Length

Max length	4
Median length	4
Mean length	3.1138
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	5569	55.7%
상행	3103	31.0%
하행	1328	13.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	5569	55.7%
상행	3103	31.0%
하행	1328	13.3%

Heatmap
Table

	이비노선아이디	정류장순서	노선아이디	이비정류장아이디	정류장아이디	회차정류장명	누적거리	확정거리	정류장누적거리	기관코드	진행구분코드명
이비노선아이디	1.000	0.247	0.938	0.363	0.369	0.075	0.183	0.094	0.138	0.898	0.075
정류장순서	0.247	1.000	0.223	0.097	0.223	0.688	0.906	0.000	0.809	0.209	0.688
노선아이디	0.938	0.223	1.000	0.194	0.466	0.135	0.182	0.103	0.142	0.908	0.135
이비정류장아이디	0.363	0.097	0.194	1.000	0.956	0.012	0.094	0.000	0.071	0.064	0.012
정류장아이디	0.369	0.223	0.466	0.956	1.000	0.035	0.252	0.130	0.253	0.401	0.035
회차정류장명	0.075	0.688	0.135	0.012	0.035	1.000	0.725	0.042	0.725	0.115	1.000
누적거리	0.183	0.906	0.182	0.094	0.252	0.725	1.000	0.101	0.947	0.152	0.725
확정거리	0.094	0.000	0.103	0.000	0.130	0.042	0.101	1.000	0.083	0.097	0.042
정류장누적거리	0.138	0.809	0.142	0.071	0.253	0.725	0.947	0.083	1.000	0.137	0.725
기관코드	0.898	0.209	0.908	0.064	0.401	0.115	0.152	0.097	0.137	1.000	0.115
진행구분코드명	0.075	0.688	0.135	0.012	0.035	1.000	0.725	0.042	0.725	0.115	1.000

Heatmap
Table

	진행구분코드명	회차정류장명
진행구분코드명	1.000	0.999
회차정류장명	0.999	1.000

Heatmap
Table

	이비노선아이디	정류장순서	노선아이디	이비정류장아이디	정류장아이디	누적거리	확정거리	정류장누적거리	기관코드	회차정류장명	진행구분코드명
이비노선아이디	1.000	0.048	-0.296	-0.086	-0.073	-0.053	-0.079	-0.001	-0.350	0.076	0.076
정류장순서	0.048	1.000	-0.213	-0.151	-0.239	0.967	0.094	0.948	-0.172	0.536	0.536
노선아이디	-0.296	-0.213	1.000	0.199	0.626	-0.022	0.197	-0.112	0.885	0.135	0.135
이비정류장아이디	-0.086	-0.151	0.199	1.000	0.385	-0.035	0.111	-0.095	0.182	0.019	0.019
정류장아이디	-0.073	-0.239	0.626	0.385	1.000	0.006	0.223	-0.155	0.572	0.043	0.043
누적거리	-0.053	0.967	-0.022	-0.035	0.006	1.000	0.186	1.000	0.008	0.568	0.568
확정거리	-0.079	0.094	0.197	0.111	0.223	0.186	1.000	0.186	0.197	0.031	0.031
정류장누적거리	-0.001	0.948	-0.112	-0.095	-0.155	1.000	0.186	1.000	-0.080	0.536	0.536
기관코드	-0.350	-0.172	0.885	0.182	0.572	0.008	0.197	-0.080	1.000	0.130	0.130
회차정류장명	0.076	0.536	0.135	0.019	0.043	0.568	0.031	0.536	0.130	1.000	0.999
진행구분코드명	0.076	0.536	0.135	0.019	0.043	0.568	0.031	0.536	0.130	0.999	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

	이비노선아이디	정류장순서	노선아이디	이비정류장아이디	정류장아이디	회차정류장명	링크순서	누적거리	확정거리	정류장누적거리	정류장간거리	기관코드	사용구분	등록아이디	등록일자	수정아이디	갱신일자	진행구분코드명
1678	41002493	31	230000143	4172731	237000896	<NA>	<NA>	<NA>	<NA>	27680	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
37131	41005003	29	222000033	4114842	222001791	<NA>	<NA>	<NA>	<NA>	8350	<NA>	4136000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
29367	41003156	38	234001491	7102058	277102058	<NA>	<NA>	<NA>	<NA>	28730	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
38240	41009155	20	240000008	4151113	240000022	<NA>	<NA>	<NA>	<NA>	16040	<NA>	4183000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
28012	41003258	1	234000459	4175515	230001539	F	<NA>	590	595	590	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행
45136	41007027	6	217000012	4101426	208000001	F	<NA>	2420	474	2420	<NA>	4127000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행
33138	41007004	1	224000016	4105287	216000095	F	<NA>	240	243	240	<NA>	4127000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행
9385	41002019	34	234000050	4100073	209000018	<NA>	<NA>	<NA>	<NA>	42290	<NA>	4131000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
2153	41002801	55	234001236	4109284	222001413	<NA>	<NA>	<NA>	<NA>	130610	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
37191	41005003	55	222000033	4196465	222000241	<NA>	<NA>	<NA>	<NA>	20640	<NA>	4136000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>

	이비노선아이디	정류장순서	노선아이디	이비정류장아이디	정류장아이디	회차정류장명	링크순서	누적거리	확정거리	정류장누적거리	정류장간거리	기관코드	사용구분	등록아이디	등록일자	수정아이디	갱신일자	진행구분코드명
53635	41008141	29	233000059	4170583	233000444	<NA>	<NA>	<NA>	<NA>	16360	<NA>	4159000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
45446	41006299	5	228000222	4197527	228000501	<NA>	<NA>	<NA>	<NA>	4500	<NA>	4146000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
18464	41003002	50	234000095	4179305	204000178	<NA>	<NA>	<NA>	<NA>	22950	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
2484	41003009	34	234000015	4116828	202000053	<NA>	<NA>	<NA>	<NA>	15100	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
33825	41003036	32	234001375	4198820	237000446	F	<NA>	22870	1540	22870	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행
20331	41003005	69	234000009	4199205	123000016	<NA>	<NA>	<NA>	<NA>	37990	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
16190	41003211	47	234001593	4112232	234000324	<NA>	<NA>	<NA>	<NA>	17940	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
33416	41003091	1	234001507	4160144	237000663	F	<NA>	780	780	780	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행
7136	41002080	58	234001433	4173152	237000953	<NA>	<NA>	<NA>	<NA>	39170	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	<NA>
11173	41002157	22	234000764	4172666	237000686	F	<NA>	13190	1919	13190	<NA>	4161000000	Y	ETL_ADMIN	20190224234500	<NA>	<NA>	상행

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample