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

Reproduction

Analysis started2024-03-14 16:50:31.595612
Analysis finished2024-03-14 16:50:34.382173
Duration2.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

차량번호
Text

Distinct53
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T01:50:34.985915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length9
Mean length9
Min length9

Characters and Unicode

Total characters90000
Distinct characters30
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

Unique1 ?
Unique (%)< 0.1%

Sample

1st row대구99바****
2nd row전남98바****
3rd row전남99사****
4th row경남99바****
5th row대전99바****
ValueCountFrequency (%)
전남98사 3186
31.9%
전남98바 2466
24.7%
경남99바 478
 
4.8%
부산99사 366
 
3.7%
광주99사 328
 
3.3%
전북98사 307
 
3.1%
광주99바 287
 
2.9%
부산99바 258
 
2.6%
부산98사 207
 
2.1%
경남99사 174
 
1.7%
Other values (43) 1943
19.4%
2024-03-15T01:50:36.266752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 40000
44.4%
9 12733
 
14.1%
8 7201
 
8.0%
남 6879
 
7.6%
전 6734
 
7.5%
사 5116
 
5.7%
바 4151
 
4.6%
경 1055
 
1.2%
산 1014
 
1.1%
부 929
 
1.0%
Other values (20) 4188
 
4.7%

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 (%)
남 6879
22.9%
전 6734
22.4%
사 5116
17.1%
바 4151
13.8%
경 1055
 
3.5%
산 1014
 
3.4%
부 929
 
3.1%
광 764
 
2.5%
주 764
 
2.5%
북 726
 
2.4%
Other values (13) 1868
 
6.2%
Decimal Number
ValueCountFrequency (%)
9 12733
63.7%
8 7201
36.0%
0 32
 
0.2%
2 30
 
0.1%
5 2
 
< 0.1%
1 2
 
< 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 (%)
남 6879
22.9%
전 6734
22.4%
사 5116
17.1%
바 4151
13.8%
경 1055
 
3.5%
산 1014
 
3.4%
부 929
 
3.1%
광 764
 
2.5%
주 764
 
2.5%
북 726
 
2.4%
Other values (13) 1868
 
6.2%
Common
ValueCountFrequency (%)
* 40000
66.7%
9 12733
 
21.2%
8 7201
 
12.0%
0 32
 
0.1%
2 30
 
< 0.1%
5 2
 
< 0.1%
1 2
 
< 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 12733
 
21.2%
8 7201
 
12.0%
0 32
 
0.1%
2 30
 
< 0.1%
5 2
 
< 0.1%
1 2
 
< 0.1%
Hangul
ValueCountFrequency (%)
남 6879
22.9%
전 6734
22.4%
사 5116
17.1%
바 4151
13.8%
경 1055
 
3.5%
산 1014
 
3.4%
부 929
 
3.1%
광 764
 
2.5%
주 764
 
2.5%
북 726
 
2.4%
Other values (13) 1868
 
6.2%

진입게이트
Categorical

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2번 GATE
2956 
3번 GATE
2330 
4번 GATE
2319 
5번 GATE
1221 
11번 GATE
518 
Other values (3)
656 

Length

Max length8
Median length7
Mean length7.0518
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5번 GATE
2nd row4번 GATE
3rd row5번 GATE
4th row2번 GATE
5th row2번 GATE

Common Values

ValueCountFrequency (%)
2번 GATE 2956
29.6%
3번 GATE 2330
23.3%
4번 GATE 2319
23.2%
5번 GATE 1221
12.2%
11번 GATE 518
 
5.2%
7번 GATE 438
 
4.4%
6번 GATE 165
 
1.7%
1번 GATE 53
 
0.5%

Length

2024-03-15T01:50:36.625199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T01:50:36.979307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gate 10000
50.0%
2번 2956
 
14.8%
3번 2330
 
11.7%
4번 2319
 
11.6%
5번 1221
 
6.1%
11번 518
 
2.6%
7번 438
 
2.2%
6번 165
 
0.8%
1번 53
 
0.3%

진입일시
Date

Distinct8014
Distinct (%)80.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 07:29:00
Maximum2023-12-20 22:28:00
2024-03-15T01:50:37.356744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:50:37.762315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

진출게이트
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
4번 GATE
4334 
8번 GATE
3517 
7번 GATE
1982 
1번 GATE
 
162
3번 GATE
 
5

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
4번 GATE 4334
43.3%
8번 GATE 3517
35.2%
7번 GATE 1982
19.8%
1번 GATE 162
 
1.6%
3번 GATE 5
 
0.1%

Length

2024-03-15T01:50:38.186351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T01:50:38.504095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gate 10000
50.0%
4번 4334
21.7%
8번 3517
 
17.6%
7번 1982
 
9.9%
1번 162
 
0.8%
3번 5
 
< 0.1%

진출일시
Date

Distinct8252
Distinct (%)82.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-07-01 07:45:00
Maximum2023-12-20 22:57:00
2024-03-15T01:50:38.714554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:50:38.979909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

작업시간
Date

Distinct5374
Distinct (%)53.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-03-15 00:00:01
Maximum2024-03-15 05:59:58
2024-03-15T01:50:39.318631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:50:39.597902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2024-03-15T01:50:39.747566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차량번호진입게이트진출게이트
차량번호1.0000.1730.308
진입게이트0.1731.0000.189
진출게이트0.3080.1891.000
2024-03-15T01:50:39.896787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.116
진출게이트0.1161.000
2024-03-15T01:50:40.052655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
진입게이트진출게이트
진입게이트1.0000.116
진출게이트0.1161.000

Missing values

2024-03-15T01:50:33.839427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T01:50:34.216697image/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

차량번호진입게이트진입일시진출게이트진출일시작업시간
7993대구99바****5번 GATE2023-10-12 14:274번 GATE2023-10-12 14:3000:02:24
12275전남98바****4번 GATE2023-12-15 15:118번 GATE2023-12-15 15:4000:28:23
5808전남99사****5번 GATE2023-08-14 15:368번 GATE2023-08-14 16:1600:39:46
4314경남99바****2번 GATE2023-08-01 08:504번 GATE2023-08-01 11:4602:56:01
10999대전99바****2번 GATE2023-12-14 09:264번 GATE2023-12-14 09:4600:19:52
1802전남98아****5번 GATE2023-07-06 12:484번 GATE2023-07-06 13:0300:14:39
10090부산99사****2번 GATE2023-12-13 09:077번 GATE2023-12-13 09:3800:30:48
9065경남99바****3번 GATE2023-12-04 11:174번 GATE2023-12-04 12:3401:17:18
1074경남99사****5번 GATE2023-07-04 14:424번 GATE2023-07-04 16:4101:59:24
2020경남99바****4번 GATE2023-07-07 08:247번 GATE2023-07-07 08:5800:34:33
차량번호진입게이트진입일시진출게이트진출일시작업시간
12435경남99바****3번 GATE2023-12-15 17:194번 GATE2023-12-15 17:4500:25:52
5532부산99사****11번 GATE2023-08-11 15:394번 GATE2023-08-11 16:2800:49:39
11410전남98사****2번 GATE2023-12-14 14:548번 GATE2023-12-14 15:2900:35:04
139전남98사****5번 GATE2023-07-03 09:187번 GATE2023-07-03 09:5200:34:15
571전남02가****3번 GATE2023-07-03 16:097번 GATE2023-07-03 16:4900:39:33
14417인천98바****2번 GATE2023-12-20 08:528번 GATE2023-12-20 09:1800:25:57
4173광주99바****5번 GATE2023-07-20 11:398번 GATE2023-07-20 12:2500:46:17
10679전남98사****2번 GATE2023-12-13 15:114번 GATE2023-12-13 15:2300:12:09
10869광주99바****2번 GATE2023-12-13 18:414번 GATE2023-12-13 18:5000:09:19
1005전남98바****5번 GATE2023-07-04 13:348번 GATE2023-07-04 14:0400:29:26