Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory546.9 KiB
Average record size in memory56.0 B

Variable types

Text1
Categorical2
DateTime3

Dataset

Description광양항 배후단지 내 컨테이너 차량의 게이트별 도로 운행 정보입니다. 차량정보(개인정보로 인한 마스킹처리), 진입게이트, 진입일시, 진출게이트, 진출일시, 작업시간으로 구성되어 있습니다. 갱신주기는 반기입니다.
Author여수광양항만공사
URLhttps://www.data.go.kr/data/15042050/fileData.do

Reproduction

Analysis started2024-04-06 08:02:13.068190
Analysis finished2024-04-06 08:02:16.283078
Duration3.21 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

차량번호
Text

Distinct65
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:02:16.597064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length9
Mean length9
Min length9

Characters and Unicode

Total characters90000
Distinct characters34
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique9 ?
Unique (%)0.1%

Sample

1st row전남98바****
2nd row대구98바****
3rd row경기98사****
4th row전남98사****
5th row전남98사****
ValueCountFrequency (%)
전남98사 3052
30.5%
전남98바 2519
25.2%
경남99바 427
 
4.3%
전북98사 402
 
4.0%
광주99사 349
 
3.5%
부산99사 316
 
3.2%
부산99바 271
 
2.7%
광주99바 205
 
2.1%
경남99사 200
 
2.0%
전북98아 156
 
1.6%
Other values (55) 2103
21.0%
2024-04-06T17:02:17.291079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 40000
44.4%
9 12644
 
14.0%
8 7271
 
8.1%
남 6785
 
7.5%
전 6768
 
7.5%
사 5054
 
5.6%
바 4146
 
4.6%
경 1048
 
1.2%
산 954
 
1.1%
부 846
 
0.9%
Other values (24) 4484
 
5.0%

Most occurring categories

ValueCountFrequency (%)
Other Punctuation 40000
44.4%
Other Letter 30000
33.3%
Decimal Number 20000
22.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 6785
22.6%
전 6768
22.6%
사 5054
16.8%
바 4146
13.8%
경 1048
 
3.5%
산 954
 
3.2%
부 846
 
2.8%
북 812
 
2.7%
주 785
 
2.6%
광 785
 
2.6%
Other values (15) 2017
 
6.7%
Decimal Number
ValueCountFrequency (%)
9 12644
63.2%
8 7271
36.4%
0 30
 
0.1%
2 20
 
0.1%
5 14
 
0.1%
1 12
 
0.1%
6 8
 
< 0.1%
3 1
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
* 40000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 60000
66.7%
Hangul 30000
33.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 6785
22.6%
전 6768
22.6%
사 5054
16.8%
바 4146
13.8%
경 1048
 
3.5%
산 954
 
3.2%
부 846
 
2.8%
북 812
 
2.7%
주 785
 
2.6%
광 785
 
2.6%
Other values (15) 2017
 
6.7%
Common
ValueCountFrequency (%)
* 40000
66.7%
9 12644
 
21.1%
8 7271
 
12.1%
0 30
 
< 0.1%
2 20
 
< 0.1%
5 14
 
< 0.1%
1 12
 
< 0.1%
6 8
 
< 0.1%
3 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 60000
66.7%
Hangul 30000
33.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 40000
66.7%
9 12644
 
21.1%
8 7271
 
12.1%
0 30
 
< 0.1%
2 20
 
< 0.1%
5 14
 
< 0.1%
1 12
 
< 0.1%
6 8
 
< 0.1%
3 1
 
< 0.1%
Hangul
ValueCountFrequency (%)
남 6785
22.6%
전 6768
22.6%
사 5054
16.8%
바 4146
13.8%
경 1048
 
3.5%
산 954
 
3.2%
부 846
 
2.8%
북 812
 
2.7%
주 785
 
2.6%
광 785
 
2.6%
Other values (15) 2017
 
6.7%

진입게이트
Categorical

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
13번 GATE
1780 
14번 GATE
1541 
10번 GATE
1538 
2번 GATE
1326 
3번 GATE
1117 
Other values (7)
2698 

Length

Max length8
Median length8
Mean length7.5092
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row10번 GATE
2nd row13번 GATE
3rd row13번 GATE
4th row10번 GATE
5th row6번 GATE

Common Values

ValueCountFrequency (%)
13번 GATE 1780
17.8%
14번 GATE 1541
15.4%
10번 GATE 1538
15.4%
2번 GATE 1326
13.3%
3번 GATE 1117
11.2%
4번 GATE 1072
10.7%
9번 GATE 549
 
5.5%
5번 GATE 533
 
5.3%
11번 GATE 233
 
2.3%
7번 GATE 209
 
2.1%
Other values (2) 102
 
1.0%

Length

2024-04-06T17:02:17.544461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
gate 10000
50.0%
13번 1780
 
8.9%
14번 1541
 
7.7%
10번 1538
 
7.7%
2번 1326
 
6.6%
3번 1117
 
5.6%
4번 1072
 
5.4%
9번 549
 
2.7%
5번 533
 
2.7%
11번 233
 
1.2%
Other values (3) 311
 
1.6%

진입일시
Date

Distinct8669
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 07:43:00
Maximum2023-12-29 17:48:00
2024-04-06T17:02:17.793611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:02:18.068496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

진출게이트
Categorical

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
16번 GATE
2706 
15번 GATE
2273 
4번 GATE
1956 
8번 GATE
1646 
7번 GATE
913 
Other values (3)
506 

Length

Max length8
Median length8
Mean length7.5408
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row16번 GATE
2nd row16번 GATE
3rd row16번 GATE
4th row15번 GATE
5th row4번 GATE

Common Values

ValueCountFrequency (%)
16번 GATE 2706
27.1%
15번 GATE 2273
22.7%
4번 GATE 1956
19.6%
8번 GATE 1646
16.5%
7번 GATE 913
 
9.1%
12번 GATE 429
 
4.3%
1번 GATE 72
 
0.7%
3번 GATE 5
 
0.1%

Length

2024-04-06T17:02:18.345127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:02:18.596853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gate 10000
50.0%
16번 2706
 
13.5%
15번 2273
 
11.4%
4번 1956
 
9.8%
8번 1646
 
8.2%
7번 913
 
4.6%
12번 429
 
2.1%
1번 72
 
0.4%
3번 5
 
< 0.1%

진출일시
Date

Distinct8746
Distinct (%)87.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 07:59:00
Maximum2023-12-29 18:03:00
2024-04-06T17:02:19.141990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:02:19.436023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

작업시간
Date

Distinct6509
Distinct (%)65.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-04-06 00:00:04
Maximum2024-04-06 05:59:35
2024-04-06T17:02:20.187016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:02:20.612375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2024-04-06T17:02:20.869802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차량번호진입게이트진출게이트
차량번호1.0000.1920.247
진입게이트0.1921.0000.706
진출게이트0.2470.7061.000
2024-04-06T17:02:21.093544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.391
진출게이트0.3911.000
2024-04-06T17:02:21.264325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.391
진출게이트0.3911.000

Missing values

2024-04-06T17:02:15.877738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:02:16.157784image/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

차량번호진입게이트진입일시진출게이트진출일시작업시간
11296전남98바****10번 GATE2023-07-25 17:3616번 GATE2023-07-25 18:1900:43:31
5578대구98바****13번 GATE2023-07-18 19:5316번 GATE2023-07-18 19:5800:05:04
9728경기98사****13번 GATE2023-07-22 19:0616번 GATE2023-07-22 19:2400:18:14
10408전남98사****10번 GATE2023-07-24 16:1115번 GATE2023-07-24 16:5200:41:45
30271전남98사****6번 GATE2023-12-16 14:034번 GATE2023-12-16 14:1300:09:23
1941전남98사****4번 GATE2023-07-06 10:484번 GATE2023-07-06 10:5500:07:19
5180부산99바****9번 GATE2023-07-18 15:2312번 GATE2023-07-18 16:1500:52:36
993전남98사****5번 GATE2023-07-04 09:434번 GATE2023-07-04 10:0000:16:46
17987부산99바****14번 GATE2023-08-17 10:4516번 GATE2023-08-17 12:1201:26:37
21609전남98사****9번 GATE2023-09-13 14:3416번 GATE2023-09-13 16:3201:58:19
차량번호진입게이트진입일시진출게이트진출일시작업시간
18843전남98사****13번 GATE2023-08-21 14:1815번 GATE2023-08-21 16:1801:59:28
20184전남98사****2번 GATE2023-09-01 13:307번 GATE2023-09-01 14:4801:17:42
8316부산99사****10번 GATE2023-07-20 17:1515번 GATE2023-07-20 20:2103:05:25
1804전남98사****3번 GATE2023-07-05 17:038번 GATE2023-07-05 17:5600:53:29
21365전남98바****10번 GATE2023-09-12 11:1216번 GATE2023-09-12 11:1900:06:51
29137전남98사****4번 GATE2023-12-14 16:294번 GATE2023-12-14 16:3400:05:25
12884전남98바****13번 GATE2023-07-28 13:2015번 GATE2023-07-28 14:4001:19:55
21203전남98사****13번 GATE2023-09-11 09:0015번 GATE2023-09-11 11:3002:30:31
9339전남98사****13번 GATE2023-07-21 16:5916번 GATE2023-07-21 17:1500:15:45
32459전남98바****2번 GATE2023-12-20 13:417번 GATE2023-12-20 14:1700:36:31