Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory63.3 B

Variable types

Categorical4
Numeric3

Dataset

Description샘플 데이터
Author지디에스컨설팅그룹
URLhttps://www.bigdata-environment.kr/user/data_market/detail.do?id=a2c6a820-2dff-11ea-9713-eb3e5186fb38

Alerts

도로 고유ID has constant value ""Constant
시작노드ID has constant value ""Constant
도로명 has constant value ""Constant
종료노드ID has constant value ""Constant
속도 is highly overall correlated with 지연시간High correlation
지연시간 is highly overall correlated with 속도High correlation
변환시간 has unique valuesUnique

Reproduction

Analysis started2023-12-10 11:54:36.496756
Analysis finished2023-12-10 11:54:38.759511
Duration2.26 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

도로 고유ID
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1000000301
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1000000301 100
100.0%

Length

2023-12-10T20:54:38.874268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:54:39.048856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1000000301 100
100.0%

속도
Real number (ℝ)

HIGH CORRELATION 

Distinct24
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.29
Minimum10
Maximum47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:54:39.239594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile12
Q117
median20
Q323.25
95-th percentile30.05
Maximum47
Range37
Interquartile range (IQR)6.25

Descriptive statistics

Standard deviation5.7775165
Coefficient of variation (CV)0.28474699
Kurtosis3.947214
Mean20.29
Median Absolute Deviation (MAD)3
Skewness1.2872771
Sum2029
Variance33.379697
MonotonicityNot monotonic
2023-12-10T20:54:39.467058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
18 13
13.0%
20 9
 
9.0%
16 8
 
8.0%
17 7
 
7.0%
21 7
 
7.0%
24 6
 
6.0%
19 5
 
5.0%
22 5
 
5.0%
15 5
 
5.0%
23 5
 
5.0%
Other values (14) 30
30.0%
ValueCountFrequency (%)
10 1
 
1.0%
11 3
 
3.0%
12 4
 
4.0%
13 1
 
1.0%
14 2
 
2.0%
15 5
 
5.0%
16 8
8.0%
17 7
7.0%
18 13
13.0%
19 5
 
5.0%
ValueCountFrequency (%)
47 1
 
1.0%
36 1
 
1.0%
33 2
 
2.0%
31 1
 
1.0%
30 1
 
1.0%
29 1
 
1.0%
27 3
3.0%
26 5
5.0%
25 4
4.0%
24 6
6.0%

시작노드ID
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1000008600
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1000008600 100
100.0%

Length

2023-12-10T20:54:39.725298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:54:39.915211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1000008600 100
100.0%

도로명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
종로
100 

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 (%)
종로 100
100.0%

Length

2023-12-10T20:54:40.092782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:54:40.296556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종로 100
100.0%

지연시간
Real number (ℝ)

HIGH CORRELATION 

Distinct29
Distinct (%)29.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.99
Minimum12
Maximum54
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:54:40.485471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile18
Q123
median28
Q333
95-th percentile45
Maximum54
Range42
Interquartile range (IQR)10

Descriptive statistics

Standard deviation7.9359749
Coefficient of variation (CV)0.2737487
Kurtosis0.91065684
Mean28.99
Median Absolute Deviation (MAD)5
Skewness0.8163981
Sum2899
Variance62.979697
MonotonicityNot monotonic
2023-12-10T20:54:40.744636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
27 8
 
8.0%
31 8
 
8.0%
30 7
 
7.0%
34 6
 
6.0%
22 6
 
6.0%
25 5
 
5.0%
21 5
 
5.0%
23 5
 
5.0%
26 5
 
5.0%
29 5
 
5.0%
Other values (19) 40
40.0%
ValueCountFrequency (%)
12 1
 
1.0%
15 1
 
1.0%
16 1
 
1.0%
17 1
 
1.0%
18 2
 
2.0%
19 1
 
1.0%
20 3
3.0%
21 5
5.0%
22 6
6.0%
23 5
5.0%
ValueCountFrequency (%)
54 1
 
1.0%
49 3
3.0%
45 4
4.0%
42 1
 
1.0%
39 2
 
2.0%
37 1
 
1.0%
36 4
4.0%
35 2
 
2.0%
34 6
6.0%
33 2
 
2.0%

종료노드ID
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1000008900
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1000008900 100
100.0%

Length

2023-12-10T20:54:41.017326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:54:41.217401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1000008900 100
100.0%

변환시간
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0201201 × 1013
Minimum2.0201201 × 1013
Maximum2.0201202 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:54:41.430930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0201201 × 1013
5-th percentile2.0201201 × 1013
Q12.0201201 × 1013
median2.0201201 × 1013
Q32.0201201 × 1013
95-th percentile2.0201202 × 1013
Maximum2.0201202 × 1013
Range1012000
Interquartile range (IQR)168875

Descriptive statistics

Standard deviation281093.76
Coefficient of variation (CV)1.3914705 × 10-8
Kurtosis4.2173403
Mean2.0201201 × 1013
Median Absolute Deviation (MAD)78750
Skewness2.3292117
Sum2.0201201 × 1015
Variance7.9013701 × 1010
MonotonicityStrictly increasing
2023-12-10T20:54:41.759821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20201201000558 1
 
1.0%
20201201194558 1
 
1.0%
20201201213058 1
 
1.0%
20201201212058 1
 
1.0%
20201201211058 1
 
1.0%
20201201205058 1
 
1.0%
20201201204058 1
 
1.0%
20201201203058 1
 
1.0%
20201201202558 1
 
1.0%
20201201201558 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
20201201000558 1
1.0%
20201201001558 1
1.0%
20201201002558 1
1.0%
20201201003558 1
1.0%
20201201004558 1
1.0%
20201201005058 1
1.0%
20201201012058 1
1.0%
20201201013058 1
1.0%
20201201014058 1
1.0%
20201201015058 1
1.0%
ValueCountFrequency (%)
20201202012558 1
1.0%
20201202011558 1
1.0%
20201202010558 1
1.0%
20201202010058 1
1.0%
20201202005058 1
1.0%
20201202004058 1
1.0%
20201202003058 1
1.0%
20201202002058 1
1.0%
20201202001058 1
1.0%
20201202000558 1
1.0%

Interactions

2023-12-10T20:54:37.868753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:36.700307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:37.284053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:38.051805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:36.927769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:37.504555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:38.238391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:37.098810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:54:37.671122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:54:41.982955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
속도지연시간변환시간
속도1.0000.8720.239
지연시간0.8721.0000.383
변환시간0.2390.3831.000
2023-12-10T20:54:42.146836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
속도지연시간변환시간
속도1.000-0.997-0.348
지연시간-0.9971.0000.357
변환시간-0.3480.3571.000

Missing values

2023-12-10T20:54:38.481668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:54:38.693933image/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

도로 고유ID속도시작노드ID도로명지연시간종료노드ID변환시간
01000000301171000008600종로33100000890020201201000558
11000000301181000008600종로30100000890020201201001558
21000000301331000008600종로17100000890020201201002558
31000000301231000008600종로24100000890020201201003558
41000000301141000008600종로39100000890020201201004558
51000000301251000008600종로22100000890020201201005058
61000000301331000008600종로16100000890020201201012058
71000000301191000008600종로29100000890020201201013058
81000000301181000008600종로30100000890020201201014058
91000000301221000008600종로25100000890020201201015058
도로 고유ID속도시작노드ID도로명지연시간종료노드ID변환시간
901000000301181000008600종로31100000890020201202000558
911000000301181000008600종로31100000890020201202001058
921000000301161000008600종로34100000890020201202002058
931000000301121000008600종로45100000890020201202003058
941000000301151000008600종로36100000890020201202004058
951000000301111000008600종로49100000890020201202005058
961000000301161000008600종로34100000890020201202010058
971000000301161000008600종로34100000890020201202010558
981000000301141000008600종로39100000890020201202011558
991000000301251000008600종로22100000890020201202012558