Overview

Dataset statistics

Number of variables11
Number of observations3647
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory324.2 KiB
Average record size in memory91.0 B

Variable types

Categorical10
Numeric1

Dataset

Description대구광역시_버스전용차로 지점교통량_20111231
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15069480&dataSetDetailId=150694801dc11d82eceed&provdMethod=FILE

Alerts

지점교통량DB_아이디 has constant value ""Constant
조사구분 has constant value ""Constant
조사지점유형 has constant value ""Constant
연도 has constant value ""Constant
요일유형 has constant value ""Constant
방향구분 is highly overall correlated with 조사지점_아이디High correlation
조사지점_아이디 is highly overall correlated with 방향구분High correlation
교통량_15분 has 480 (13.2%) zerosZeros

Reproduction

Analysis started2024-04-21 01:59:26.559357
Analysis finished2024-04-21 01:59:27.822657
Duration1.26 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지점교통량DB_아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
52
3647 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row52
2nd row52
3rd row52
4th row52
5th row52

Common Values

ValueCountFrequency (%)
52 3647
100.0%

Length

2024-04-21T10:59:27.936423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:28.103866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
52 3647
100.0%

조사구분
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
대구시기초조사
3647 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구시기초조사
2nd row대구시기초조사
3rd row대구시기초조사
4th row대구시기초조사
5th row대구시기초조사

Common Values

ValueCountFrequency (%)
대구시기초조사 3647
100.0%

Length

2024-04-21T10:59:28.277288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:28.444963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구시기초조사 3647
100.0%

조사지점유형
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
버스전용차로운영구간
3647 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row버스전용차로운영구간
2nd row버스전용차로운영구간
3rd row버스전용차로운영구간
4th row버스전용차로운영구간
5th row버스전용차로운영구간

Common Values

ValueCountFrequency (%)
버스전용차로운영구간 3647
100.0%

Length

2024-04-21T10:59:28.617372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:28.789269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
버스전용차로운영구간 3647
100.0%

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
2011
3647 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2011
2nd row2011
3rd row2011
4th row2011
5th row2011

Common Values

ValueCountFrequency (%)
2011 3647
100.0%

Length

2024-04-21T10:59:28.962163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:29.132217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2011 3647
100.0%

조사지점_아이디
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
화랑로
 
192
달구벌대로(A)
 
192
중앙대로(B)
 
192
월배로
 
192
국채보상로(A)
 
192
Other values (14)
2687 

Length

Max length8
Median length3
Mean length4.7373183
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row화랑로
2nd row화랑로
3rd row화랑로
4th row화랑로
5th row화랑로

Common Values

ValueCountFrequency (%)
화랑로 192
 
5.3%
달구벌대로(A) 192
 
5.3%
중앙대로(B) 192
 
5.3%
월배로 192
 
5.3%
국채보상로(A) 192
 
5.3%
국채보상로(B) 192
 
5.3%
서대구로 192
 
5.3%
팔달로 192
 
5.3%
신암로아양로 192
 
5.3%
달구벌대로(B) 192
 
5.3%
Other values (9) 1727
47.4%

Length

2024-04-21T10:59:29.305030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
화랑로 192
 
5.3%
수성로 192
 
5.3%
중앙대로(a 192
 
5.3%
달서로 192
 
5.3%
동대구로 192
 
5.3%
성당로 192
 
5.3%
명덕로 192
 
5.3%
태평로 192
 
5.3%
대명로 192
 
5.3%
달구벌대로(b 192
 
5.3%
Other values (9) 1727
47.4%

요일유형
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
평일
3647 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row평일
2nd row평일
3rd row평일
4th row평일
5th row평일

Common Values

ValueCountFrequency (%)
평일 3647
100.0%

Length

2024-04-21T10:59:29.509929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:29.676107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
평일 3647
100.0%

방향구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
상행
1919 
하행
1728 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
상행 1919
52.6%
하행 1728
47.4%

Length

2024-04-21T10:59:29.849667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:30.022441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상행 1919
52.6%
하행 1728
47.4%

시간대_1시간
Categorical

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
17시-18시
608 
07시-08시
608 
12시-13시
608 
13시-14시
608 
18시-19시
607 
Other values (2)
608 

Length

Max length7
Median length7
Mean length6.9994516
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row17시-18시
2nd row17시-18시
3rd row17시-18시
4th row17시-18시
5th row17시-18시

Common Values

ValueCountFrequency (%)
17시-18시 608
16.7%
07시-08시 608
16.7%
12시-13시 608
16.7%
13시-14시 608
16.7%
18시-19시 607
16.6%
08시-09시 606
16.6%
08시-9시 2
 
0.1%

Length

2024-04-21T10:59:30.213961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:30.419530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
17시-18시 608
16.7%
07시-08시 608
16.7%
12시-13시 608
16.7%
13시-14시 608
16.7%
18시-19시 607
16.6%
08시-09시 606
16.6%
08시-9시 2
 
0.1%

시간대_15분
Categorical

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
00-15
912 
15-30
912 
30-45
912 
45-60
911 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row00-15
2nd row00-15
3rd row00-15
4th row00-15
5th row00-15

Common Values

ValueCountFrequency (%)
00-15 912
25.0%
15-30 912
25.0%
30-45 912
25.0%
45-60 911
25.0%

Length

2024-04-21T10:59:30.647295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:30.831454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
00-15 912
25.0%
15-30 912
25.0%
30-45 912
25.0%
45-60 911
25.0%

차종
Categorical

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size28.6 KiB
승용차(10인승 이하 택시포함)
456 
버스 소형(승합차 11~15인승 이하)
456 
버스 중형(중형버스 16~36인승 미만)
456 
버스 대형(대형버스 36인승 이상)
456 
화물차 소형(소형화물차 2.5톤 미만)
456 
Other values (3)
1367 

Length

Max length31
Median length22
Mean length19.754867
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row승용차(10인승 이하 택시포함)
2nd row버스 소형(승합차 11~15인승 이하)
3rd row버스 중형(중형버스 16~36인승 미만)
4th row버스 대형(대형버스 36인승 이상)
5th row화물차 소형(소형화물차 2.5톤 미만)

Common Values

ValueCountFrequency (%)
승용차(10인승 이하 택시포함) 456
12.5%
버스 소형(승합차 11~15인승 이하) 456
12.5%
버스 중형(중형버스 16~36인승 미만) 456
12.5%
버스 대형(대형버스 36인승 이상) 456
12.5%
화물차 소형(소형화물차 2.5톤 미만) 456
12.5%
화물차 중형(중형화물차 2.5~8.5톤 이하) 456
12.5%
화물차 대형(대형화물차 8.5톤 초과 컨테이너/트레일러) 456
12.5%
이륜 455
12.5%

Length

2024-04-21T10:59:31.042966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:59:31.259509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
버스 1368
 
10.3%
이하 1368
 
10.3%
화물차 1368
 
10.3%
미만 912
 
6.9%
승용차(10인승 456
 
3.4%
소형(소형화물차 456
 
3.4%
컨테이너/트레일러 456
 
3.4%
초과 456
 
3.4%
8.5톤 456
 
3.4%
대형(대형화물차 456
 
3.4%
Other values (12) 5471
41.4%

교통량_15분
Real number (ℝ)

ZEROS 

Distinct403
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55.804771
Minimum0
Maximum937
Zeros480
Zeros (%)13.2%
Negative0
Negative (%)0.0%
Memory size32.2 KiB
2024-04-21T10:59:31.530278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median12
Q329
95-th percentile349.1
Maximum937
Range937
Interquartile range (IQR)27

Descriptive statistics

Standard deviation125.79705
Coefficient of variation (CV)2.2542347
Kurtosis12.104533
Mean55.804771
Median Absolute Deviation (MAD)11
Skewness3.3271931
Sum203520
Variance15824.899
MonotonicityNot monotonic
2024-04-21T10:59:31.767858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 480
 
13.2%
1 331
 
9.1%
2 179
 
4.9%
3 137
 
3.8%
5 107
 
2.9%
4 98
 
2.7%
12 95
 
2.6%
11 94
 
2.6%
13 79
 
2.2%
9 79
 
2.2%
Other values (393) 1968
54.0%
ValueCountFrequency (%)
0 480
13.2%
1 331
9.1%
2 179
 
4.9%
3 137
 
3.8%
4 98
 
2.7%
5 107
 
2.9%
6 67
 
1.8%
7 68
 
1.9%
8 58
 
1.6%
9 79
 
2.2%
ValueCountFrequency (%)
937 1
< 0.1%
933 1
< 0.1%
909 1
< 0.1%
903 1
< 0.1%
888 1
< 0.1%
877 1
< 0.1%
860 1
< 0.1%
837 1
< 0.1%
816 1
< 0.1%
814 1
< 0.1%

Interactions

2024-04-21T10:59:27.228924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:59:31.921991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조사지점_아이디방향구분시간대_1시간시간대_15분차종교통량_15분
조사지점_아이디1.0001.0000.0000.0000.0000.386
방향구분1.0001.0000.0000.0000.0000.132
시간대_1시간0.0000.0001.0000.0000.0000.080
시간대_15분0.0000.0000.0001.0000.0000.000
차종0.0000.0000.0000.0001.0000.635
교통량_15분0.3860.1320.0800.0000.6351.000
2024-04-21T10:59:32.100280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
방향구분시간대_15분시간대_1시간차종조사지점_아이디
방향구분1.0000.0000.0000.0000.998
시간대_15분0.0001.0000.0000.0000.000
시간대_1시간0.0000.0001.0000.0000.000
차종0.0000.0000.0001.0000.000
조사지점_아이디0.9980.0000.0000.0001.000
2024-04-21T10:59:32.276512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
교통량_15분조사지점_아이디방향구분시간대_1시간시간대_15분차종
교통량_15분1.0000.1550.1010.0400.0000.368
조사지점_아이디0.1551.0000.9980.0000.0000.000
방향구분0.1010.9981.0000.0000.0000.000
시간대_1시간0.0400.0000.0001.0000.0000.000
시간대_15분0.0000.0000.0000.0001.0000.000
차종0.3680.0000.0000.0000.0001.000

Missing values

2024-04-21T10:59:27.439592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:59:27.714692image/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

지점교통량DB_아이디조사구분조사지점유형연도조사지점_아이디요일유형방향구분시간대_1시간시간대_15분차종교통량_15분
052대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15승용차(10인승 이하 택시포함)433
152대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15버스 소형(승합차 11~15인승 이하)29
252대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15버스 중형(중형버스 16~36인승 미만)1
352대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15버스 대형(대형버스 36인승 이상)6
452대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15화물차 소형(소형화물차 2.5톤 미만)32
552대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15화물차 중형(중형화물차 2.5~8.5톤 이하)2
652대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15화물차 대형(대형화물차 8.5톤 초과 컨테이너/트레일러)0
752대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시00-15이륜9
852대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시15-30승용차(10인승 이하 택시포함)511
952대구시기초조사버스전용차로운영구간2011화랑로평일상행17시-18시15-30버스 소형(승합차 11~15인승 이하)43
지점교통량DB_아이디조사구분조사지점유형연도조사지점_아이디요일유형방향구분시간대_1시간시간대_15분차종교통량_15분
363752대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시30-45화물차 대형(대형화물차 8.5톤 초과 컨테이너/트레일러)5
363852대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시30-45이륜8
363952대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60승용차(10인승 이하 택시포함)451
364052대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60버스 소형(승합차 11~15인승 이하)35
364152대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60버스 중형(중형버스 16~36인승 미만)0
364252대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60버스 대형(대형버스 36인승 이상)5
364352대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60화물차 소형(소형화물차 2.5톤 미만)35
364452대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60화물차 중형(중형화물차 2.5~8.5톤 이하)1
364552대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60화물차 대형(대형화물차 8.5톤 초과 컨테이너/트레일러)0
364652대구시기초조사버스전용차로운영구간2011화랑로평일상행13시-14시45-60이륜12