Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows31
Duplicate rows (%)0.3%
Total size in memory478.5 KiB
Average record size in memory49.0 B

Variable types

DateTime1
Categorical3
Numeric1

Dataset

Description부산광역시_지능형교통정보_구간DSRC정보_20240131
Author부산광역시
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15041721

Alerts

Dataset has 31 (0.3%) duplicate rowsDuplicates
구간명 is highly overall correlated with 속도 and 2 other fieldsHigh correlation
시점 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 구간명High correlation

Reproduction

Analysis started2024-03-13 13:16:33.357001
Analysis finished2024-03-13 13:16:34.121548
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

가공일시
Date

Distinct1440
Distinct (%)14.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-31 00:00:00
Maximum2024-01-31 23:59:00
2024-03-13T22:16:34.206405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:16:34.364706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구간명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
중앙대로
5183 
가락대로
4817 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중앙대로
2nd row중앙대로
3rd row가락대로
4th row가락대로
5th row중앙대로

Common Values

ValueCountFrequency (%)
중앙대로 5183
51.8%
가락대로 4817
48.2%

Length

2024-03-13T22:16:34.514683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:16:34.626094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중앙대로 5183
51.8%
가락대로 4817
48.2%

시점
Categorical

HIGH CORRELATION 

Distinct40
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
범방동314-1
805 
범방동1925
 
589
구랑동1265
 
564
생곡동1594-8
 
307
미음동1632
 
301
Other values (35)
7434 

Length

Max length15
Median length10
Mean length6.6303
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row우리는교회
2nd row구서역4번출구
3rd row범방동1925
4th row생곡동1614
5th row청룡동삼거리

Common Values

ValueCountFrequency (%)
범방동314-1 805
 
8.1%
범방동1925 589
 
5.9%
구랑동1265 564
 
5.6%
생곡동1594-8 307
 
3.1%
미음동1632 301
 
3.0%
범방동1958 300
 
3.0%
청호테크앞 299
 
3.0%
구랑주유소앞 299
 
3.0%
속성변화점 298
 
3.0%
금남교 290
 
2.9%
Other values (30) 5948
59.5%

Length

2024-03-13T22:16:34.736904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
범방동314-1 805
 
8.1%
범방동1925 589
 
5.9%
구랑동1265 564
 
5.6%
생곡동1594-8 307
 
3.1%
미음동1632 301
 
3.0%
범방동1958 300
 
3.0%
청호테크앞 299
 
3.0%
구랑주유소앞 299
 
3.0%
속성변화점 298
 
3.0%
금남교 290
 
2.9%
Other values (30) 5948
59.5%

종점
Categorical

HIGH CORRELATION 

Distinct38
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
범방동314-1
818 
범방동1925
 
572
구랑동1265
 
564
범방동1958
 
327
청룡동삼거리
 
311
Other values (33)
7408 

Length

Max length15
Median length10
Mean length6.6759
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부곡동입구교차로
2nd row구서교남측
3rd row범방동1925
4th row세산교차로
5th row범어사역6번출구

Common Values

ValueCountFrequency (%)
범방동314-1 818
 
8.2%
범방동1925 572
 
5.7%
구랑동1265 564
 
5.6%
범방동1958 327
 
3.3%
청룡동삼거리 311
 
3.1%
생곡동896 303
 
3.0%
에이스커피 302
 
3.0%
범방동364-40 300
 
3.0%
생곡동1614 297
 
3.0%
청호테크앞 293
 
2.9%
Other values (28) 5913
59.1%

Length

2024-03-13T22:16:34.897073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
범방동314-1 818
 
8.2%
범방동1925 572
 
5.7%
구랑동1265 564
 
5.6%
범방동1958 327
 
3.3%
청룡동삼거리 311
 
3.1%
생곡동896 303
 
3.0%
에이스커피 302
 
3.0%
범방동364-40 300
 
3.0%
생곡동1614 297
 
3.0%
시청앞 293
 
2.9%
Other values (28) 5913
59.1%

속도
Real number (ℝ)

HIGH CORRELATION 

Distinct89
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.9853
Minimum4
Maximum102
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-13T22:16:35.053992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile17
Q129
median38
Q349
95-th percentile62
Maximum102
Range98
Interquartile range (IQR)20

Descriptive statistics

Standard deviation14.137166
Coefficient of variation (CV)0.36262813
Kurtosis-0.075676552
Mean38.9853
Median Absolute Deviation (MAD)10
Skewness0.21564974
Sum389853
Variance199.85947
MonotonicityNot monotonic
2024-03-13T22:16:35.238943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
46 407
 
4.1%
47 346
 
3.5%
45 332
 
3.3%
30 330
 
3.3%
36 316
 
3.2%
48 307
 
3.1%
35 297
 
3.0%
32 292
 
2.9%
31 282
 
2.8%
34 270
 
2.7%
Other values (79) 6821
68.2%
ValueCountFrequency (%)
4 4
 
< 0.1%
5 4
 
< 0.1%
6 29
0.3%
7 15
 
0.1%
8 25
 
0.2%
9 31
0.3%
10 17
 
0.2%
11 24
 
0.2%
12 36
0.4%
13 67
0.7%
ValueCountFrequency (%)
102 2
 
< 0.1%
98 1
 
< 0.1%
93 1
 
< 0.1%
92 1
 
< 0.1%
91 9
0.1%
89 3
 
< 0.1%
87 1
 
< 0.1%
86 5
0.1%
85 3
 
< 0.1%
84 2
 
< 0.1%

Interactions

2024-03-13T22:16:33.770173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:16:35.351284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구간명시점종점속도
구간명1.0001.0001.0000.944
시점1.0001.0000.9900.794
종점1.0000.9901.0000.769
속도0.9440.7940.7691.000
2024-03-13T22:16:35.467907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구간명시점종점
구간명1.0000.9980.998
시점0.9981.0000.765
종점0.9980.7651.000
2024-03-13T22:16:35.584330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
속도구간명시점종점
속도1.0000.7990.3860.392
구간명0.7991.0000.9980.998
시점0.3860.9981.0000.765
종점0.3920.9980.7651.000

Missing values

2024-03-13T22:16:33.935985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:16:34.067285image/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

가공일시구간명시점종점속도
25102024-01-31 06:27:00중앙대로우리는교회부곡동입구교차로35
845682024-01-31 21:35:00중앙대로구서역4번출구구서교남측34
490472024-01-31 07:23:00가락대로범방동1925범방동192539
343782024-01-31 02:54:00가락대로생곡동1614세산교차로54
873402024-01-31 21:06:00중앙대로청룡동삼거리범어사역6번출구30
974682024-01-31 23:47:00중앙대로남산역8번출구속성변화점35
357282024-01-31 01:24:00가락대로청호테크앞세산교차로51
594922024-01-31 13:28:00가락대로범방동364-40범방동314-145
921232024-01-31 06:17:00중앙대로금남교남산역8번출구35
66602024-01-31 16:27:00중앙대로헤이도기우리는교회24
가공일시구간명시점종점속도
317622024-01-31 07:18:00가락대로생곡동1614생곡동1594-856
204412024-01-31 09:37:00가락대로구랑동1265구랑주유소앞51
244942024-01-31 06:10:00가락대로생곡동1594-8생곡동89641
215322024-01-31 04:02:00가락대로구랑동1265구랑주유소앞14
202462024-01-31 06:22:00가락대로구랑동1265구랑주유소앞53
477532024-01-31 09:49:00가락대로범방동364-40범방동192544
985632024-01-31 18:31:00중앙대로속성변화점제칠일안식일예수재림교금정교회34
299672024-01-31 01:23:00가락대로세산교차로생곡동161433
801182024-01-31 16:34:00중앙대로카라웨딩금정구청앞18
51942024-01-31 11:40:00중앙대로우리는교회헤이도기28

Duplicate rows

Most frequently occurring

가공일시구간명시점종점속도# duplicates
02024-01-31 01:46:00가락대로범방동314-1범방동314-1492
12024-01-31 03:31:00가락대로범방동314-1범방동314-1532
22024-01-31 04:50:00가락대로범방동314-1범방동314-1502
32024-01-31 05:05:00가락대로구랑주유소앞구랑동1265512
42024-01-31 05:31:00가락대로범방동314-1범방동314-1492
52024-01-31 05:34:00가락대로범방동314-1범방동314-1462
62024-01-31 06:29:00가락대로범방동314-1범방동314-1462
72024-01-31 06:38:00가락대로범방동314-1범방동314-1412
82024-01-31 09:12:00가락대로범방동314-1범방동314-1482
92024-01-31 09:41:00가락대로범방동314-1범방동314-1462