Overview

Dataset statistics

Number of variables6
Number of observations64
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory52.1 B

Variable types

Categorical2
DateTime2
Numeric2

Dataset

Description한국공항공사 - 국제공항 일 첨두 화물실적 및 최다 화물처리실적 (공항별, 일자별, 시간대별, 노선별 도착/출발시간)
URLhttps://www.data.go.kr/data/15002645/fileData.do

Alerts

도착 is highly overall correlated with 출발High correlation
출발 is highly overall correlated with 도착High correlation
도착 has 21 (32.8%) zerosZeros
출발 has 24 (37.5%) zerosZeros

Reproduction

Analysis started2023-12-12 17:13:57.816826
Analysis finished2023-12-12 17:13:58.771010
Duration0.95 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공항
Categorical

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
GMP
16 
PUS
16 
CJU
16 
ICN
16 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
GMP 16
25.0%
PUS 16
25.0%
CJU 16
25.0%
ICN 16
25.0%

Length

2023-12-13T02:13:58.843412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:13:58.948340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gmp 16
25.0%
pus 16
25.0%
cju 16
25.0%
icn 16
25.0%

일자
Date

Distinct25
Distinct (%)39.1%
Missing0
Missing (%)0.0%
Memory size644.0 B
Minimum2023-01-13 00:00:00
Maximum2023-07-28 00:00:00
2023-12-13T02:13:59.049347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:13:59.164546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

시간대
Date

Distinct11
Distinct (%)17.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
Minimum2023-12-13 06:00:00
Maximum2023-12-13 23:00:00
2023-12-13T02:13:59.255637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:13:59.377617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)

노선
Categorical

Distinct2
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size644.0 B
국내
32 
국제
32 

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 (%)
국내 32
50.0%
국제 32
50.0%

Length

2023-12-13T02:13:59.508733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:13:59.612408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내 32
50.0%
국제 32
50.0%

도착
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct43
Distinct (%)67.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean52.789063
Minimum0
Maximum460
Zeros21
Zeros (%)32.8%
Negative0
Negative (%)0.0%
Memory size708.0 B
2023-12-13T02:13:59.735370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median16.15
Q345.375
95-th percentile326.65
Maximum460
Range460
Interquartile range (IQR)45.375

Descriptive statistics

Standard deviation104.86024
Coefficient of variation (CV)1.9864009
Kurtosis6.3902932
Mean52.789063
Median Absolute Deviation (MAD)16.15
Skewness2.6851996
Sum3378.5
Variance10995.67
MonotonicityNot monotonic
2023-12-13T02:13:59.890584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
0.0 21
32.8%
45.2 2
 
3.1%
1.0 1
 
1.6%
19.0 1
 
1.6%
22.8 1
 
1.6%
16.8 1
 
1.6%
15.5 1
 
1.6%
20.2 1
 
1.6%
22.6 1
 
1.6%
23.7 1
 
1.6%
Other values (33) 33
51.6%
ValueCountFrequency (%)
0.0 21
32.8%
1.0 1
 
1.6%
1.6 1
 
1.6%
1.9 1
 
1.6%
2.0 1
 
1.6%
2.2 1
 
1.6%
3.2 1
 
1.6%
3.4 1
 
1.6%
3.5 1
 
1.6%
5.4 1
 
1.6%
ValueCountFrequency (%)
460.0 1
1.6%
405.0 1
1.6%
377.0 1
1.6%
334.0 1
1.6%
285.0 1
1.6%
272.0 1
1.6%
195.0 1
1.6%
103.0 1
1.6%
59.1 1
1.6%
51.9 1
1.6%

출발
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct40
Distinct (%)62.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean98.145313
Minimum0
Maximum866
Zeros24
Zeros (%)37.5%
Negative0
Negative (%)0.0%
Memory size708.0 B
2023-12-13T02:14:00.029996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median5.2
Q332.3
95-th percentile675.4
Maximum866
Range866
Interquartile range (IQR)32.3

Descriptive statistics

Standard deviation232.89411
Coefficient of variation (CV)2.3729519
Kurtosis4.3781322
Mean98.145313
Median Absolute Deviation (MAD)5.2
Skewness2.4320431
Sum6281.3
Variance54239.665
MonotonicityNot monotonic
2023-12-13T02:14:00.176562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
0.0 24
37.5%
5.2 2
 
3.1%
14.4 1
 
1.6%
1.9 1
 
1.6%
58.8 1
 
1.6%
56.8 1
 
1.6%
53.2 1
 
1.6%
50.2 1
 
1.6%
48.8 1
 
1.6%
49.2 1
 
1.6%
Other values (30) 30
46.9%
ValueCountFrequency (%)
0.0 24
37.5%
1.4 1
 
1.6%
1.7 1
 
1.6%
1.9 1
 
1.6%
2.6 1
 
1.6%
3.4 1
 
1.6%
4.3 1
 
1.6%
4.6 1
 
1.6%
5.2 2
 
3.1%
6.4 1
 
1.6%
ValueCountFrequency (%)
866.0 1
1.6%
847.0 1
1.6%
765.0 1
1.6%
676.0 1
1.6%
672.0 1
1.6%
653.0 1
1.6%
593.0 1
1.6%
514.0 1
1.6%
76.3 1
1.6%
62.8 1
1.6%

Interactions

2023-12-13T02:13:58.167341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:13:58.027086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:13:58.243854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:13:58.093825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:14:00.278708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공항일자시간대노선도착출발
공항1.0000.9190.9470.0000.3710.396
일자0.9191.0000.9420.0000.6650.667
시간대0.9470.9421.0000.0000.0000.000
노선0.0000.0000.0001.0000.2180.368
도착0.3710.6650.0000.2181.0001.000
출발0.3960.6670.0000.3681.0001.000
2023-12-13T02:14:00.426501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공항노선
공항1.0000.000
노선0.0001.000
2023-12-13T02:14:00.617346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도착출발공항노선
도착1.0000.5810.2310.201
출발0.5811.0000.2580.254
공항0.2310.2581.0000.000
노선0.2010.2540.0001.000

Missing values

2023-12-13T02:13:58.617593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:13:58.725166image/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

공항일자시간대노선도착출발
0GMP2023-01-1312:00:00국내45.314.4
1GMP2023-06-1216:00:00국내36.310.7
2GMP2023-03-1512:00:00국내45.812.9
3GMP2023-03-0916:00:00국내44.56.4
4GMP2023-04-1818:00:00국내59.15.2
5GMP2023-01-2512:00:00국내51.911.6
6GMP2023-06-1516:00:00국내43.010.8
7GMP2023-02-2212:00:00국내43.917.9
8GMP2023-01-1312:00:00국제17.58.3
9GMP2023-06-1216:00:00국제0.025.2
공항일자시간대노선도착출발
54ICN2023-05-1822:00:00국내0.00.0
55ICN2023-03-1823:00:00국내0.00.0
56ICN2023-01-1923:00:00국제405.0676.0
57ICN2023-07-2723:00:00국제195.0847.0
58ICN2023-02-2323:00:00국제272.0765.0
59ICN2023-04-2023:00:00국제377.0653.0
60ICN2023-06-2222:00:00국제460.0514.0
61ICN2023-05-0423:00:00국제103.0866.0
62ICN2023-05-1822:00:00국제285.0672.0
63ICN2023-03-1823:00:00국제334.0593.0