Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 332 |
| Duplicate rows (%) | 3.3% |
| Total size in memory | 888.7 KiB |
| Average record size in memory | 91.0 B |
Variable types
| Categorical | 3 |
|---|---|
| Numeric | 2 |
| DateTime | 5 |
Dataset
| Description | 울산항만공사 선석운영지원시스템의 울산항 선석배정현황 데이터입니다. · 선석: 항내에서 선박을 접안시키는 장소 · 선석배정: 선박 접안장소 지정 · 접안방향: Port(좌현), Star(우현) · 시프팅: 선박 접안장소 이동 ※ 데이터기준일 : 2020년~2023년(최근 3개년) |
|---|---|
| URL | https://www.data.go.kr/data/15121258/fileData.do |
| Dataset has 332 (3.3%) duplicate rows | Duplicates |
부두코드명 is highly overall correlated with 선석코드명 and 1 other fields | High correlation |
항구코드명 is highly overall correlated with 선석코드명 and 1 other fields | High correlation |
선석코드명 is highly overall correlated with 항구코드명 and 1 other fields | High correlation |
항구코드명 is highly imbalanced (55.9%) | Imbalance |
접안방향 is highly imbalanced (75.3%) | Imbalance |
Reproduction
| Analysis started | 2023-12-12 19:37:50.389527 |
|---|---|
| Analysis finished | 2023-12-12 19:37:51.604801 |
| Duration | 1.22 second |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
항구코드명
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| 820 | |
|---|---|
| 823 | |
| 821 | 1 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 823 |
|---|---|
| 2nd row | 820 |
| 3rd row | 820 |
| 4th row | 820 |
| 5th row | 820 |
Common Values
| Value | Count | Frequency (%) |
| 820 | 8121 | |
| 823 | 1878 | 18.8% |
| 821 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 820 | 8121 | |
| 823 | 1878 | 18.8% |
| 821 | 1 | < 0.1% |
부두코드명
Categorical
HIGH CORRELATION
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| MB6 | |
|---|---|
| MBN | |
| MB4 | |
| MB3 | |
| MB2 | |
| Other values (16) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | MBF |
|---|---|
| 2nd row | MBY |
| 3rd row | MB9 |
| 4th row | MB9 |
| 5th row | MB3 |
Common Values
| Value | Count | Frequency (%) |
| MB6 | 1699 | |
| MBN | 1167 | |
| MB4 | 991 | |
| MB3 | 885 | |
| MB2 | 814 | |
| MBG | 666 | 6.7% |
| MB8 | 530 | 5.3% |
| MDY | 527 | 5.3% |
| MBF | 423 | 4.2% |
| MB7 | 393 | 3.9% |
| Other values (11) | 1905 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| mb6 | 1699 | |
| mbn | 1167 | |
| mb4 | 991 | |
| mb3 | 885 | |
| mb2 | 814 | |
| mbg | 666 | 6.7% |
| mb8 | 530 | 5.3% |
| mdy | 527 | 5.3% |
| mbf | 423 | 4.2% |
| mb7 | 393 | 3.9% |
| Other values (11) | 1905 |
선석코드명
Real number (ℝ)
HIGH CORRELATION
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.3878 |
| Minimum | 1 |
|---|---|
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 21 |
| 95-th percentile | 31 |
| Maximum | 41 |
| Range | 40 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 11.490518 |
|---|---|
| Coefficient of variation (CV) | 1.1061551 |
| Kurtosis | -0.25555181 |
| Mean | 10.3878 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.0201826 |
| Sum | 103878 |
| Variance | 132.03201 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 1 | 2510 | |
| 2 | 2014 | |
| 26 | 1006 | |
| 11 | 941 | 9.4% |
| 21 | 902 | 9.0% |
| 3 | 597 | 6.0% |
| 31 | 547 | 5.5% |
| 41 | 301 | 3.0% |
| 7 | 292 | 2.9% |
| 5 | 277 | 2.8% |
| Other values (4) | 613 | 6.1% |
| Value | Count | Frequency (%) |
| 1 | 2510 | |
| 2 | 2014 | |
| 3 | 597 | 6.0% |
| 4 | 87 | 0.9% |
| 5 | 277 | 2.8% |
| 6 | 121 | 1.2% |
| 7 | 292 | 2.9% |
| 8 | 244 | 2.4% |
| 11 | 941 | 9.4% |
| 21 | 902 | 9.0% |
| Value | Count | Frequency (%) |
| 41 | 301 | 3.0% |
| 31 | 547 | |
| 27 | 161 | 1.6% |
| 26 | 1006 | |
| 21 | 902 | |
| 11 | 941 | |
| 8 | 244 | 2.4% |
| 7 | 292 | 2.9% |
| 6 | 121 | 1.2% |
| 5 | 277 | 2.8% |
접안방향
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Port | |
|---|---|
| Star | 767 |
| <NA> | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Port |
|---|---|
| 2nd row | Port |
| 3rd row | Port |
| 4th row | Star |
| 5th row | Port |
Common Values
| Value | Count | Frequency (%) |
| Port | 9232 | |
| Star | 767 | 7.7% |
| <NA> | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| port | 9232 | |
| star | 767 | 7.7% |
| na | 1 | < 0.1% |
입항연도
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2021.6304 |
| Minimum | 2000 |
|---|---|
| Maximum | 2032 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 2020 |
| Q1 | 2021 |
| median | 2022 |
| Q3 | 2022 |
| 95-th percentile | 2023 |
| Maximum | 2032 |
| Range | 32 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.020049 |
|---|---|
| Coefficient of variation (CV) | 0.00050456748 |
| Kurtosis | 67.433333 |
| Mean | 2021.6304 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -3.2606803 |
| Sum | 20216304 |
| Variance | 1.0404999 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 2022 | 3459 | |
| 2021 | 3398 | |
| 2023 | 2016 | |
| 2020 | 1121 | 11.2% |
| 2002 | 2 | < 0.1% |
| 2000 | 2 | < 0.1% |
| 2024 | 1 | < 0.1% |
| 2032 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2000 | 2 | < 0.1% |
| 2002 | 2 | < 0.1% |
| 2020 | 1121 | 11.2% |
| 2021 | 3398 | |
| 2022 | 3459 | |
| 2023 | 2016 | |
| 2024 | 1 | < 0.1% |
| 2032 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2032 | 1 | < 0.1% |
| 2024 | 1 | < 0.1% |
| 2023 | 2016 | |
| 2022 | 3459 | |
| 2021 | 3398 | |
| 2020 | 1121 | 11.2% |
| 2002 | 2 | < 0.1% |
| 2000 | 2 | < 0.1% |
접안예정일
Date
| Distinct | 1079 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2020-05-26 00:00:00 |
|---|---|
| Maximum | 2023-08-27 00:00:00 |
Histogram with fixed size bins (bins=50)
출항예정일
Date
| Distinct | 1082 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2020-05-27 00:00:00 |
|---|---|
| Maximum | 2023-09-08 00:00:00 |
Histogram with fixed size bins (bins=50)
선석배정일
Date
| Distinct | 935 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2020-05-26 00:00:00 |
|---|---|
| Maximum | 2023-08-24 00:00:00 |
Histogram with fixed size bins (bins=50)
등록일자
Date
| Distinct | 875 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2020-05-26 00:00:00 |
|---|---|
| Maximum | 2023-08-24 00:00:00 |
Histogram with fixed size bins (bins=50)
수정일자
Date
| Distinct | 935 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2020-05-26 00:00:00 |
|---|---|
| Maximum | 2023-08-24 00:00:00 |
Histogram with fixed size bins (bins=50)
| 항구코드명 | 부두코드명 | 선석코드명 | 접안방향 | 입항연도 | |
|---|---|---|---|---|---|
| 항구코드명 | 1.000 | 1.000 | 0.645 | 0.011 | 0.023 |
| 부두코드명 | 1.000 | 1.000 | 0.954 | 0.556 | 0.095 |
| 선석코드명 | 0.645 | 0.954 | 1.000 | 0.217 | 0.061 |
| 접안방향 | 0.011 | 0.556 | 0.217 | 1.000 | 0.105 |
| 입항연도 | 0.023 | 0.095 | 0.061 | 0.105 | 1.000 |
| 접안방향 | 부두코드명 | 항구코드명 | |
|---|---|---|---|
| 접안방향 | 1.000 | 0.491 | 0.018 |
| 부두코드명 | 0.491 | 1.000 | 0.999 |
| 항구코드명 | 0.018 | 0.999 | 1.000 |
| 선석코드명 | 입항연도 | 항구코드명 | 부두코드명 | 접안방향 | |
|---|---|---|---|---|---|
| 선석코드명 | 1.000 | 0.020 | 0.545 | 0.737 | 0.221 |
| 입항연도 | 0.020 | 1.000 | 0.022 | 0.053 | 0.070 |
| 항구코드명 | 0.545 | 0.022 | 1.000 | 0.999 | 0.018 |
| 부두코드명 | 0.737 | 0.053 | 0.999 | 1.000 | 0.491 |
| 접안방향 | 0.221 | 0.070 | 0.018 | 0.491 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| 항구코드명 | 부두코드명 | 선석코드명 | 접안방향 | 입항연도 | 접안예정일 | 출항예정일 | 선석배정일 | 등록일자 | 수정일자 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 6667 | 823 | MBF | 2 | Port | 2021 | 2021-12-08 | 2021-12-09 | 2021-12-07 | 2021-12-07 | 2021-12-07 |
| 6363 | 820 | MBY | 1 | Port | 2021 | 2021-11-20 | 2021-11-20 | 2021-11-19 | 2021-11-19 | 2021-11-19 |
| 16454 | 820 | MB9 | 1 | Port | 2023 | 2023-08-12 | 2023-08-12 | 2023-08-12 | 2023-08-11 | 2023-08-12 |
| 14531 | 820 | MB9 | 1 | Star | 2023 | 2023-04-14 | 2023-04-17 | 2023-04-17 | 2023-04-13 | 2023-04-17 |
| 5734 | 820 | MB3 | 2 | Port | 2021 | 2021-10-12 | 2021-10-12 | 2021-10-12 | 2021-10-12 | 2021-10-12 |
| 226 | 820 | MBP | 1 | Port | 2020 | 2020-09-28 | 2020-10-29 | 2020-10-05 | 2020-09-25 | 2020-10-05 |
| 2553 | 820 | MB6 | 2 | Port | 2021 | 2021-03-11 | 2021-03-11 | 2021-03-09 | 2021-03-09 | 2021-03-09 |
| 15574 | 820 | MB4 | 1 | Port | 2023 | 2023-06-15 | 2023-06-16 | 2023-06-14 | 2023-06-14 | 2023-06-14 |
| 3634 | 820 | U34 | 3 | Port | 2021 | 2021-05-18 | 2021-05-19 | 2021-05-18 | 2021-05-18 | 2021-05-18 |
| 1292 | 820 | MB8 | 1 | Port | 2020 | 2020-12-17 | 2020-12-18 | 2020-12-17 | 2020-12-16 | 2020-12-17 |
| 항구코드명 | 부두코드명 | 선석코드명 | 접안방향 | 입항연도 | 접안예정일 | 출항예정일 | 선석배정일 | 등록일자 | 수정일자 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3913 | 820 | MB6 | 5 | Port | 2021 | 2021-06-11 | 2021-06-11 | 2021-06-10 | 2021-06-10 | 2021-06-10 |
| 10514 | 820 | MBP | 1 | Port | 2022 | 2022-08-01 | 2022-08-01 | 2022-07-29 | 2022-07-29 | 2022-07-29 |
| 12358 | 820 | MB4 | 1 | Port | 2022 | 2022-12-07 | 2022-12-07 | 2022-12-07 | 2022-12-06 | 2022-12-07 |
| 12522 | 823 | MBN | 26 | Port | 2022 | 2022-12-15 | 2022-12-16 | 2022-12-15 | 2022-12-15 | 2022-12-15 |
| 12591 | 823 | MBN | 26 | Port | 2022 | 2022-12-19 | 2022-12-20 | 2022-12-19 | 2022-12-19 | 2022-12-19 |
| 8002 | 823 | MBF | 1 | Port | 2022 | 2022-02-23 | 2022-02-24 | 2022-02-22 | 2022-02-22 | 2022-02-22 |
| 16164 | 823 | MBN | 26 | Port | 2023 | 2023-07-21 | 2023-07-21 | 2023-07-21 | 2023-07-21 | 2023-07-21 |
| 8901 | 820 | MB6 | 31 | Port | 2022 | 2022-04-16 | 2022-04-16 | 2022-04-15 | 2022-04-15 | 2022-04-15 |
| 7796 | 820 | MB4 | 1 | Port | 2022 | 2022-02-11 | 2022-02-11 | 2022-02-11 | 2022-02-11 | 2022-02-11 |
| 15248 | 823 | MBN | 27 | Port | 2023 | 2023-05-22 | 2023-05-22 | 2023-05-22 | 2023-05-22 | 2023-05-22 |
Most frequently occurring
| 항구코드명 | 부두코드명 | 선석코드명 | 접안방향 | 입항연도 | 접안예정일 | 출항예정일 | 선석배정일 | 등록일자 | 수정일자 | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 326 | 823 | MBN | 26 | Port | 2023 | 2023-08-24 | 2023-08-25 | 2023-08-24 | 2023-08-24 | 2023-08-24 | 6 |
| 258 | 823 | MBN | 26 | Port | 2022 | 2022-12-13 | 2022-12-14 | 2022-12-13 | 2022-12-13 | 2022-12-13 | 4 |
| 308 | 823 | MBN | 26 | Port | 2023 | 2023-06-08 | 2023-06-09 | 2023-06-08 | 2023-06-08 | 2023-06-08 | 4 |
| 313 | 823 | MBN | 26 | Port | 2023 | 2023-07-05 | 2023-07-06 | 2023-07-05 | 2023-07-05 | 2023-07-05 | 4 |
| 62 | 820 | MB6 | 2 | Star | 2022 | 2022-02-19 | 2022-02-19 | 2022-02-16 | 2022-02-16 | 2022-02-16 | 3 |
| 67 | 820 | MB6 | 2 | Star | 2022 | 2022-06-23 | 2022-06-23 | 2022-06-22 | 2022-06-22 | 2022-06-22 | 3 |
| 70 | 820 | MB6 | 2 | Star | 2022 | 2022-09-13 | 2022-09-13 | 2022-09-12 | 2022-09-12 | 2022-09-12 | 3 |
| 119 | 820 | MBP | 1 | Port | 2021 | 2021-10-14 | 2021-10-15 | 2021-10-13 | 2021-10-13 | 2021-10-13 | 3 |
| 120 | 820 | MDY | 2 | Port | 2020 | 2020-09-09 | 2020-09-10 | 2020-09-09 | 2020-09-09 | 2020-09-09 | 3 |
| 126 | 820 | MDY | 2 | Port | 2021 | 2021-12-26 | 2021-12-27 | 2021-12-24 | 2021-12-24 | 2021-12-24 | 3 |