Overview

Dataset statistics

Number of variables5
Number of observations1922
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory75.2 KiB
Average record size in memory40.1 B

Variable types

Numeric1
Categorical2
DateTime2

Dataset

Description인천광역시 UTIS시스템의 RSE 기본수집정보(통과OBUID, 출발RSEID, 도착RSEID, 출발RSE통과일자및시각, 도착RSE통과일자및시각) 데이터입니다.
Author인천광역시
URLhttps://www.data.go.kr/data/15089911/fileData.do

Alerts

통과 오비유아이디 is highly overall correlated with 출발(알에스이아이디) and 1 other fieldsHigh correlation
출발(알에스이아이디) is highly overall correlated with 통과 오비유아이디 and 1 other fieldsHigh correlation
도착(알에스이아이디) is highly overall correlated with 통과 오비유아이디 and 1 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 03:59:21.027390
Analysis finished2023-12-12 03:59:23.796152
Duration2.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

통과 오비유아이디
Real number (ℝ)

HIGH CORRELATION 

Distinct734
Distinct (%)38.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.9076503 × 1063
Minimum3.0303243 × 1063
Maximum6.6643431 × 1063
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.0 KiB
2023-12-12T12:59:23.895175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.0303243 × 1063
5-th percentile3.0434136 × 1063
Q13.4353791 × 1063
median3.8363744 × 1063
Q34.3394336 × 1063
95-th percentile4.6353617 × 1063
Maximum6.6643431 × 1063
Range3.6340187 × 1063
Interquartile range (IQR)9.0405457 × 1062

Descriptive statistics

Standard deviation6.3872274 × 1062
Coefficient of variation (CV)0.16345443
Kurtosis3.6073292
Mean3.9076503 × 1063
Median Absolute Deviation (MAD)4.920206 × 1062
Skewness1.3356916
Sum7.5105039 × 1066
Variance4.0796674 × 10125
MonotonicityNot monotonic
2023-12-12T12:59:24.058381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4.531383239303733e+63 69
 
3.6%
3.733344443363146e+63 51
 
2.7%
4.442423741464242e+63 47
 
2.4%
3.0323745463035357e+63 40
 
2.1%
3.4454432374643376e+63 40
 
2.1%
3.832433442433337e+63 36
 
1.9%
3.346313931313745e+63 26
 
1.4%
4.2353244433445315e+63 26
 
1.4%
4.443314136323842e+63 26
 
1.4%
3.842353337363835e+63 25
 
1.3%
Other values (724) 1536
79.9%
ValueCountFrequency (%)
3.0303243393546384e+63 1
 
0.1%
3.0303838454344467e+63 2
 
0.1%
3.0323432324530316e+63 1
 
0.1%
3.0323745463035357e+63 40
2.1%
3.033314643413636e+63 1
 
0.1%
3.0333744443944444e+63 1
 
0.1%
3.0334233383333438e+63 3
 
0.2%
3.034323531666664e+63 1
 
0.1%
3.0344446453536332e+63 4
 
0.2%
3.0353930444238384e+63 2
 
0.1%
ValueCountFrequency (%)
6.664343064326238e+63 2
0.1%
6.639653335393433e+63 2
0.1%
6.636626637366638e+63 1
0.1%
6.635663064393864e+63 1
0.1%
6.562373335653662e+63 1
0.1%
6.562363239623663e+63 1
0.1%
6.5396437373935645e+63 1
0.1%
6.536653333313762e+63 1
0.1%
6.536353463343231e+63 1
0.1%
6.5336563393634315e+63 1
0.1%

출발(알에스이아이디)
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size15.1 KiB
DSRC013
747 
DSRC001
472 
DSRC002
329 
DSRC003
206 
DSRC034
 
40
Other values (8)
128 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st rowDSRC001
2nd rowDSRC002
3rd rowDSRC001
4th rowDSRC001
5th rowDSRC001

Common Values

ValueCountFrequency (%)
DSRC013 747
38.9%
DSRC001 472
24.6%
DSRC002 329
17.1%
DSRC003 206
 
10.7%
DSRC034 40
 
2.1%
DSRC035 28
 
1.5%
DSRC014 27
 
1.4%
DSRC033 22
 
1.1%
DSRC036 18
 
0.9%
DSRC022 14
 
0.7%
Other values (3) 19
 
1.0%

Length

2023-12-12T12:59:24.195315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
dsrc013 747
38.9%
dsrc001 472
24.6%
dsrc002 329
17.1%
dsrc003 206
 
10.7%
dsrc034 40
 
2.1%
dsrc035 28
 
1.5%
dsrc014 27
 
1.4%
dsrc033 22
 
1.1%
dsrc036 18
 
0.9%
dsrc022 14
 
0.7%
Other values (3) 19
 
1.0%

도착(알에스이아이디)
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size15.1 KiB
DSRC002
1072 
DSRC013
308 
DSRC001
169 
DSRC003
131 
DSRC035
 
40
Other values (9)
202 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDSRC002
2nd rowDSRC013
3rd rowDSRC002
4th rowDSRC002
5th rowDSRC002

Common Values

ValueCountFrequency (%)
DSRC002 1072
55.8%
DSRC013 308
 
16.0%
DSRC001 169
 
8.8%
DSRC003 131
 
6.8%
DSRC035 40
 
2.1%
DSRC008 38
 
2.0%
DSRC034 33
 
1.7%
DSRC018 29
 
1.5%
DSRC014 26
 
1.4%
DSRC020 19
 
1.0%
Other values (4) 57
 
3.0%

Length

2023-12-12T12:59:24.324177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
dsrc002 1072
55.8%
dsrc013 308
 
16.0%
dsrc001 169
 
8.8%
dsrc003 131
 
6.8%
dsrc035 40
 
2.1%
dsrc008 38
 
2.0%
dsrc034 33
 
1.7%
dsrc018 29
 
1.5%
dsrc014 26
 
1.4%
dsrc020 19
 
1.0%
Other values (4) 57
 
3.0%

출발알에스이통과일자 및 시각
Date

Distinct850
Distinct (%)44.2%
Missing0
Missing (%)0.0%
Memory size15.1 KiB
Minimum2022-10-24 11:20:34
Maximum2022-10-24 14:32:47
2023-12-12T12:59:24.456937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:59:24.604029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

도착 알에스이 통과일자 및 시각
Date

Distinct789
Distinct (%)41.1%
Missing0
Missing (%)0.0%
Memory size15.1 KiB
Minimum2022-10-24 14:20:01
Maximum2022-10-24 14:34:04
2023-12-12T12:59:24.778209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:59:24.926463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T12:59:21.210529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:59:25.014749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)
통과 오비유아이디1.0000.5360.637
출발(알에스이아이디)0.5361.0000.940
도착(알에스이아이디)0.6370.9401.000
2023-12-12T12:59:25.107393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도착(알에스이아이디)출발(알에스이아이디)
도착(알에스이아이디)1.0000.718
출발(알에스이아이디)0.7181.000
2023-12-12T12:59:25.195776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)
통과 오비유아이디1.0000.6770.650
출발(알에스이아이디)0.6771.0000.718
도착(알에스이아이디)0.6500.7181.000

Missing values

2023-12-12T12:59:23.636162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:59:23.745928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)출발알에스이통과일자 및 시각도착 알에스이 통과일자 및 시각
04536424441324331394432454230334230453935463345343234363733454237DSRC001DSRC0022022-10-24 14:24:472022-10-24 14:26:49
14536424441324331394432454230334230453935463345343234363733454237DSRC002DSRC0132022-10-24 14:26:492022-10-24 14:29:06
23237303743423139323430434546303446363145383839343536423544393146DSRC001DSRC0022022-10-24 14:31:252022-10-24 14:32:20
33237303743423139323430434546303446363145383839343536423544393146DSRC001DSRC0022022-10-24 14:31:252022-10-24 14:32:23
43237303743423139323430434546303446363145383839343536423544393146DSRC001DSRC0022022-10-24 14:31:252022-10-24 14:32:26
54342364642443144433346394430414633453834364644344532423343393742DSRC001DSRC0022022-10-24 14:19:162022-10-24 14:21:14
64342364642443144433346394430414633453834364644344532423343393742DSRC001DSRC0022022-10-24 14:19:162022-10-24 14:21:18
73043413633393643433334333330383136324541364531313338414441393330DSRC001DSRC0022022-10-24 14:26:142022-10-24 14:27:37
83043413633393643433334333330383136324541364531313338414441393330DSRC002DSRC0132022-10-24 14:27:372022-10-24 14:31:44
93043414141353139353943333237333244453836314343343133373843463134DSRC003DSRC0132022-10-24 14:29:422022-10-24 14:32:17
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)출발알에스이통과일자 및 시각도착 알에스이 통과일자 및 시각
19123146323633433639433637374632323033393538373735363239453932334446DSRC001DSRC0022022-10-24 14:29:192022-10-24 14:31:48
19133146323633433639433637374632323033393538373735363239453932334446DSRC001DSRC0022022-10-24 14:29:192022-10-24 14:31:51
19143133304636413733434143343642323834393737333244433534384443384531DSRC022DSRC0212022-10-24 12:16:152022-10-24 14:21:12
19153133304636413733434143343642323834393737333244433534384443384531DSRC022DSRC0212022-10-24 12:16:152022-10-24 14:22:25
19163434303835374545374538354642433833344439383833453541354433434444DSRC003DSRC0132022-10-24 14:24:372022-10-24 14:27:00
19173434303835374545374538354642433833344439383833453541354433434444DSRC013DSRC0032022-10-24 13:12:292022-10-24 14:24:37
19184242324446453143384130383536414142303635464130354342434242413930DSRC001DSRC0022022-10-24 14:30:422022-10-24 14:31:53
19194242324446453143384130383536414142303635464130354342434242413930DSRC001DSRC0022022-10-24 14:30:422022-10-24 14:31:58
19204330353231343134413139464443364533343444413433333938353937453135DSRC013DSRC0082022-10-24 12:51:132022-10-24 14:27:58
19213737303241454333363746393839303732443141424341453139443741424639DSRC002DSRC0012022-10-24 13:17:562022-10-24 14:29:12