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/15042052/fileData.do

Reproduction

Analysis started2024-04-06 08:22:46.218481
Analysis finished2024-04-06 08:22:49.373278
Duration3.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

차량번호
Text

Distinct64
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:22:49.628021image/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

Unique5 ?
Unique (%)< 0.1%

Sample

1st row전남98바****
2nd row광주99사****
3rd row전남98사****
4th row광주98사****
5th row울산99바****
ValueCountFrequency (%)
전남98사 2984
29.8%
전남98바 2512
25.1%
전북98사 465
 
4.7%
경남99바 422
 
4.2%
광주99사 404
 
4.0%
부산99사 323
 
3.2%
부산99바 300
 
3.0%
전남99사 187
 
1.9%
광주99바 173
 
1.7%
경남99사 160
 
1.6%
Other values (54) 2070
20.7%
2024-04-06T17:22:50.255097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 40000
44.4%
9 12679
 
14.1%
8 7242
 
8.0%
전 6787
 
7.5%
남 6721
 
7.5%
사 5103
 
5.7%
바 4114
 
4.6%
경 982
 
1.1%
산 967
 
1.1%
부 884
 
1.0%
Other values (24) 4521
 
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 (%)
전 6787
22.6%
남 6721
22.4%
사 5103
17.0%
바 4114
13.7%
경 982
 
3.3%
산 967
 
3.2%
부 884
 
2.9%
광 816
 
2.7%
주 816
 
2.7%
북 800
 
2.7%
Other values (14) 2010
 
6.7%
Decimal Number
ValueCountFrequency (%)
9 12679
63.4%
8 7242
36.2%
5 27
 
0.1%
1 17
 
0.1%
0 16
 
0.1%
6 13
 
0.1%
2 3
 
< 0.1%
3 2
 
< 0.1%
7 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 (%)
전 6787
22.6%
남 6721
22.4%
사 5103
17.0%
바 4114
13.7%
경 982
 
3.3%
산 967
 
3.2%
부 884
 
2.9%
광 816
 
2.7%
주 816
 
2.7%
북 800
 
2.7%
Other values (14) 2010
 
6.7%
Common
ValueCountFrequency (%)
* 40000
66.7%
9 12679
 
21.1%
8 7242
 
12.1%
5 27
 
< 0.1%
1 17
 
< 0.1%
0 16
 
< 0.1%
6 13
 
< 0.1%
2 3
 
< 0.1%
3 2
 
< 0.1%
7 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 12679
 
21.1%
8 7242
 
12.1%
5 27
 
< 0.1%
1 17
 
< 0.1%
0 16
 
< 0.1%
6 13
 
< 0.1%
2 3
 
< 0.1%
3 2
 
< 0.1%
7 1
 
< 0.1%
Hangul
ValueCountFrequency (%)
전 6787
22.6%
남 6721
22.4%
사 5103
17.0%
바 4114
13.7%
경 982
 
3.3%
산 967
 
3.2%
부 884
 
2.9%
광 816
 
2.7%
주 816
 
2.7%
북 800
 
2.7%
Other values (14) 2010
 
6.7%

진입게이트
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
4번 GATE
3439 
3번 GATE
3048 
5번 GATE
2537 
1번 GATE
976 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4번 GATE
2nd row4번 GATE
3rd row4번 GATE
4th row3번 GATE
5th row1번 GATE

Common Values

ValueCountFrequency (%)
4번 GATE 3439
34.4%
3번 GATE 3048
30.5%
5번 GATE 2537
25.4%
1번 GATE 976
 
9.8%

Length

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

Common Values (Plot)

2024-04-06T17:22:50.684636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gate 10000
50.0%
4번 3439
 
17.2%
3번 3048
 
15.2%
5번 2537
 
12.7%
1번 976
 
4.9%

진입일시
Date

Distinct8903
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 08:15:00
Maximum2023-09-27 14:03:00
2024-04-06T17:22:50.908453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:22:51.246589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

진출게이트
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
10번 GATE
5205 
9번 GATE
4058 
8번 GATE
737 

Length

Max length8
Median length8
Mean length7.5205
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10번 GATE 5205
52.0%
9번 GATE 4058
40.6%
8번 GATE 737
 
7.4%

Length

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

Common Values (Plot)

2024-04-06T17:22:51.727098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gate 10000
50.0%
10번 5205
26.0%
9번 4058
20.3%
8번 737
 
3.7%

진출일시
Date

Distinct8901
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 09:32:00
Maximum2023-09-27 18:35:00
2024-04-06T17:22:52.000789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:22:52.292356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

작업시간
Date

Distinct5219
Distinct (%)52.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-04-06 00:00:07
Maximum2024-04-06 05:59:44
2024-04-06T17:22:52.585327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:22:52.845271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2024-04-06T17:22:53.002427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차량번호진입게이트진출게이트
차량번호1.0000.1340.119
진입게이트0.1341.0000.076
진출게이트0.1190.0761.000
2024-04-06T17:22:53.272268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.072
진출게이트0.0721.000
2024-04-06T17:22:53.582490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.072
진출게이트0.0721.000

Missing values

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

차량번호진입게이트진입일시진출게이트진출일시작업시간
503전남98바****4번 GATE2023-07-03 10:0410번 GATE2023-07-03 10:4300:38:51
56889광주99사****4번 GATE2023-08-21 14:0810번 GATE2023-08-21 15:2801:20:32
81153전남98사****4번 GATE2023-09-12 10:3110번 GATE2023-09-12 11:0300:32:29
10120광주98사****3번 GATE2023-07-11 09:2010번 GATE2023-07-11 09:4600:25:40
3785울산99바****1번 GATE2023-07-05 12:589번 GATE2023-07-05 13:3300:35:23
33649전남98바****5번 GATE2023-07-28 10:2210번 GATE2023-07-28 11:0600:43:36
24388전남98사****1번 GATE2023-07-21 13:319번 GATE2023-07-21 15:2801:57:27
51332경남99바****1번 GATE2023-08-16 15:5610번 GATE2023-08-16 17:4301:47:55
39841대구99바****3번 GATE2023-08-03 09:3310번 GATE2023-08-03 09:4100:08:16
95041전남98바****3번 GATE2023-09-22 16:479번 GATE2023-09-22 17:3700:50:18
차량번호진입게이트진입일시진출게이트진출일시작업시간
53277전남98사****5번 GATE2023-08-17 17:5010번 GATE2023-08-17 17:5600:06:41
52003부산99사****4번 GATE2023-08-17 08:5710번 GATE2023-08-17 09:3600:38:33
91640전남98사****5번 GATE2023-09-20 14:079번 GATE2023-09-20 19:1905:11:31
64282전남98사****5번 GATE2023-08-28 08:589번 GATE2023-08-28 09:2000:22:29
16472전남98바****3번 GATE2023-07-15 08:2810번 GATE2023-07-15 08:4600:17:17
69824전남98사****3번 GATE2023-08-31 16:2510번 GATE2023-08-31 17:0500:39:44
28869전남99사****4번 GATE2023-07-25 14:4410번 GATE2023-07-25 14:5500:10:51
69528경남99사****5번 GATE2023-08-31 14:229번 GATE2023-08-31 14:5900:37:36
3848광주99사****3번 GATE2023-07-05 13:2810번 GATE2023-07-05 14:4301:14:39
80731광주99바****5번 GATE2023-09-11 17:3810번 GATE2023-09-11 18:0700:28:20