Overview

Dataset statistics

Number of variables5
Number of observations4059
Missing cells0
Missing cells (%)0.0%
Duplicate rows3
Duplicate rows (%)0.1%
Total size in memory158.7 KiB
Average record size in memory40.0 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

Dataset has 3 (0.1%) duplicate rowsDuplicates
출발(알에스이아이디) is highly overall correlated with 도착(알에스이아이디)High correlation
도착(알에스이아이디) is highly overall correlated with 출발(알에스이아이디)High correlation

Reproduction

Analysis started2023-12-12 03:59:12.147035
Analysis finished2023-12-12 03:59:18.625777
Duration6.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

Distinct2449
Distinct (%)60.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.8938271 × 1063
Minimum3.0303042 × 1063
Maximum6.6663631 × 1063
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size35.8 KiB
2023-12-12T12:59:18.709426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.0303042 × 1063
5-th percentile3.0463544 × 1063
Q13.4313439 × 1063
median3.7646631 × 1063
Q34.3343146 × 1063
95-th percentile4.6414546 × 1063
Maximum6.6663631 × 1063
Range3.6360589 × 1063
Interquartile range (IQR)9.0297074 × 1062

Descriptive statistics

Standard deviation6.6573511 × 1062
Coefficient of variation (CV)0.17097192
Kurtosis4.0920324
Mean3.8938271 × 1063
Median Absolute Deviation (MAD)4.6664108 × 1062
Skewness1.563766
Sum1.5805044 × 1067
Variance4.4320323 × 10125
MonotonicityNot monotonic
2023-12-12T12:59:18.914950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4.1464539323434325e+63 7
 
0.2%
3.735313931443931e+63 7
 
0.2%
3.536463131394135e+63 7
 
0.2%
4.545323534453439e+63 7
 
0.2%
4.638413446333647e+63 6
 
0.1%
6.538343437373834e+63 6
 
0.1%
3.2344338343633445e+63 6
 
0.1%
3.33238414432454e+63 5
 
0.1%
3.731443637434637e+63 5
 
0.1%
3.1314343303042464e+63 5
 
0.1%
Other values (2439) 3998
98.5%
ValueCountFrequency (%)
3.0303042364435438e+63 2
< 0.1%
3.0303431394131307e+63 1
 
< 0.1%
3.0303931343046396e+63 1
 
< 0.1%
3.0304143313538413e+63 1
 
< 0.1%
3.0304232333633436e+63 2
< 0.1%
3.03046354639434e+63 1
 
< 0.1%
3.0313032433733454e+63 4
0.1%
3.0313066643637324e+63 1
 
< 0.1%
3.0313130323738387e+63 1
 
< 0.1%
3.0313141333334397e+63 1
 
< 0.1%
ValueCountFrequency (%)
6.666363136633032e+63 2
< 0.1%
6.664653531353834e+63 1
 
< 0.1%
6.66439363236643e+63 3
0.1%
6.662353236643434e+63 3
0.1%
6.662323935663865e+63 2
< 0.1%
6.661646562386165e+63 1
 
< 0.1%
6.661613839333136e+63 1
 
< 0.1%
6.661383434333665e+63 2
< 0.1%
6.661366135386135e+63 1
 
< 0.1%
6.639333061663234e+63 1
 
< 0.1%

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

HIGH CORRELATION 

Distinct33
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
DSRC006
391 
DSRC025
290 
DSRC005
282 
DSRC008
 
256
DSRC001
 
253
Other values (28)
2587 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDSRC016
2nd rowDSRC030
3rd rowDSRC006
4th rowDSRC016
5th rowDSRC006

Common Values

ValueCountFrequency (%)
DSRC006 391
 
9.6%
DSRC025 290
 
7.1%
DSRC005 282
 
6.9%
DSRC008 256
 
6.3%
DSRC001 253
 
6.2%
DSRC021 248
 
6.1%
DSRC007 226
 
5.6%
DSRC022 209
 
5.1%
DSRC026 180
 
4.4%
DSRC009 174
 
4.3%
Other values (23) 1550
38.2%

Length

2023-12-12T12:59:19.087695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
dsrc006 391
 
9.6%
dsrc025 290
 
7.1%
dsrc005 282
 
6.9%
dsrc008 256
 
6.3%
dsrc001 253
 
6.2%
dsrc021 248
 
6.1%
dsrc007 226
 
5.6%
dsrc022 209
 
5.1%
dsrc026 180
 
4.4%
dsrc009 174
 
4.3%
Other values (23) 1550
38.2%

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

HIGH CORRELATION 

Distinct31
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
DSRC006
360 
DSRC005
297 
DSRC007
275 
DSRC001
273 
DSRC025
 
257
Other values (26)
2597 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDSRC017
2nd rowDSRC001
3rd rowDSRC005
4th rowDSRC017
5th rowDSRC007

Common Values

ValueCountFrequency (%)
DSRC006 360
 
8.9%
DSRC005 297
 
7.3%
DSRC007 275
 
6.8%
DSRC001 273
 
6.7%
DSRC025 257
 
6.3%
DSRC022 248
 
6.1%
DSRC008 243
 
6.0%
DSRC021 209
 
5.1%
DSRC017 192
 
4.7%
DSRC009 169
 
4.2%
Other values (21) 1536
37.8%

Length

2023-12-12T12:59:19.221444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
dsrc006 360
 
8.9%
dsrc005 297
 
7.3%
dsrc007 275
 
6.8%
dsrc001 273
 
6.7%
dsrc025 257
 
6.3%
dsrc022 248
 
6.1%
dsrc008 243
 
6.0%
dsrc021 209
 
5.1%
dsrc017 192
 
4.7%
dsrc009 169
 
4.2%
Other values (21) 1536
37.8%

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

Distinct189
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
Minimum2021-09-24 11:46:00
Maximum2021-09-24 15:03:00
2023-12-12T12:59:19.346682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:59:19.501571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

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

Distinct15
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size31.8 KiB
Minimum2021-09-24 14:50:00
Maximum2021-09-24 15:04:00
2023-12-12T12:59:19.623286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:59:19.744329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)

Interactions

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

Correlations

2023-12-12T12:59:19.827752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)도착 알에스이 통과일자 및 시각
통과 오비유아이디1.0000.5240.5280.000
출발(알에스이아이디)0.5241.0000.9890.358
도착(알에스이아이디)0.5280.9891.0000.366
도착 알에스이 통과일자 및 시각0.0000.3580.3661.000
2023-12-12T12:59:19.937765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도착(알에스이아이디)출발(알에스이아이디)
도착(알에스이아이디)1.0000.792
출발(알에스이아이디)0.7921.000
2023-12-12T12:59:20.030957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)
통과 오비유아이디1.0000.3120.295
출발(알에스이아이디)0.3121.0000.792
도착(알에스이아이디)0.2950.7921.000

Missing values

2023-12-12T12:59:18.453627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:59:18.577109image/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

통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)출발알에스이통과일자 및 시각도착 알에스이 통과일자 및 시각
04630423342363846364643453334364638354338394237314432344546363837DSRC016DSRC0172021-09-24 15:022021-09-24 15:04
13935384645394542324345354445344537433938434638393244424332303245DSRC030DSRC0012021-09-24 15:022021-09-24 15:04
24345374243433138433946344338453739443631353636463038353230303233DSRC006DSRC0052021-09-24 15:022021-09-24 15:04
33139373641373333353033394644443745463733443738433533423433393239DSRC016DSRC0172021-09-24 15:012021-09-24 15:04
43430414230464235423639343835393231434337433031333739343234434536DSRC006DSRC0072021-09-24 13:582021-09-24 15:04
53441353434394137444632434338354245413739374630303239383033423546DSRC004DSRC0162021-09-24 12:122021-09-24 15:04
63033443146464237444537313246413746313130324137453139314536323244DSRC006DSRC0042021-09-24 12:302021-09-24 15:04
73433383241363643333837433441303435424537313238393444363745433043DSRC010DSRC0092021-09-24 12:562021-09-24 15:04
83865666439333637653031333039656266373737326635303561653062316361DSRC039DSRC0382021-09-24 15:002021-09-24 15:04
94430363744303136354234464336374636314246453743334231373143444536DSRC016DSRC0172021-09-24 15:012021-09-24 15:04
통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)출발알에스이통과일자 및 시각도착 알에스이 통과일자 및 시각
40493046453031433038333641433633353344394335434546353437453032304439DSRC025DSRC0242021-09-24 14:462021-09-24 14:50
40504430454530453933334631433730303831434538373634454239323539433438DSRC008DSRC0052021-09-24 14:492021-09-24 14:50
40513236344131373242334245324435463637394242363935323439413531303541DSRC028DSRC0292021-09-24 14:372021-09-24 14:50
40524545464239303845414246353336333837423839443534323838364634424138DSRC007DSRC0062021-09-24 14:492021-09-24 14:50
40534634353546323142374446374346314243334638334134303338454443464144DSRC016DSRC0042021-09-24 14:422021-09-24 14:50
40543530444146313846373136444342393933303332383435463939363533303633DSRC030DSRC0012021-09-24 13:362021-09-24 14:50
40553233323637343238384445384234364442354330433037333945413639353734DSRC005DSRC0062021-09-24 14:482021-09-24 14:50
40563036363039423632383942443646414435413336364235324130394430394143DSRC005DSRC0082021-09-24 14:492021-09-24 14:50
40573839414146354133354437353844463638323138444145413530393633343339DSRC002DSRC0012021-09-24 13:042021-09-24 14:50
40584334304139443545434338304437394245454439413745393533463845343246DSRC030DSRC0012021-09-24 14:252021-09-24 14:50

Duplicate rows

Most frequently occurring

통과 오비유아이디출발(알에스이아이디)도착(알에스이아이디)출발알에스이통과일자 및 시각도착 알에스이 통과일자 및 시각# duplicates
04131414237324433314637373830373030463241343834364232304535423542DSRC001DSRC0302021-09-24 14:472021-09-24 14:502
14139373430413644373633324138363331433035444444364537353932464333DSRC027DSRC0262021-09-24 14:522021-09-24 14:582
24144343944464430353235333235424145434335373236394238363135464634DSRC005DSRC0062021-09-24 14:492021-09-24 14:522