Overview

Dataset statistics

Number of variables6
Number of observations226
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.4 KiB
Average record size in memory51.6 B

Variable types

Categorical3
Text1
Numeric2

Dataset

Description한국공항공사가 제공하는 항공사별 화물실적 통계 서비스에 대한 데이터로 연도, 노선, 항공사, 총화물출발, 총화물도착 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15002631/fileData.do

Alerts

연도 has constant value ""Constant
노선 has constant value ""Constant
총화물출발 is highly overall correlated with 총화물도착High correlation
총화물도착 is highly overall correlated with 총화물출발High correlation
총화물출발 has 87 (38.5%) zerosZeros
총화물도착 has 90 (39.8%) zerosZeros

Reproduction

Analysis started2023-12-12 08:52:20.635241
Analysis finished2023-12-12 08:52:21.474024
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023
226 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023 226
100.0%

Length

2023-12-12T17:52:21.542166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:52:21.634459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 226
100.0%

노선
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
D
226 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
D 226
100.0%

Length

2023-12-12T17:52:21.756571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:52:21.868246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
d 226
100.0%

항공사
Text

Distinct113
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T17:52:22.190821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters678
Distinct characters26
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowAAR
2nd rowAAR
3rd rowKAL
4th rowKAL
5th rowABL
ValueCountFrequency (%)
aar 2
 
0.9%
gcr 2
 
0.9%
pac 2
 
0.9%
ncr 2
 
0.9%
mxd 2
 
0.9%
msi 2
 
0.9%
mng 2
 
0.9%
mml 2
 
0.9%
mma 2
 
0.9%
mgl 2
 
0.9%
Other values (103) 206
91.2%
2023-12-12T17:52:22.709682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 108
15.9%
C 66
 
9.7%
L 40
 
5.9%
S 38
 
5.6%
T 38
 
5.6%
H 36
 
5.3%
M 28
 
4.1%
G 28
 
4.1%
K 26
 
3.8%
E 22
 
3.2%
Other values (16) 248
36.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 678
100.0%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 108
15.9%
C 66
 
9.7%
L 40
 
5.9%
S 38
 
5.6%
T 38
 
5.6%
H 36
 
5.3%
M 28
 
4.1%
G 28
 
4.1%
K 26
 
3.8%
E 22
 
3.2%
Other values (16) 248
36.6%

Most occurring scripts

ValueCountFrequency (%)
Latin 678
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 108
15.9%
C 66
 
9.7%
L 40
 
5.9%
S 38
 
5.6%
T 38
 
5.6%
H 36
 
5.3%
M 28
 
4.1%
G 28
 
4.1%
K 26
 
3.8%
E 22
 
3.2%
Other values (16) 248
36.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 678
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 108
15.9%
C 66
 
9.7%
L 40
 
5.9%
S 38
 
5.6%
T 38
 
5.6%
H 36
 
5.3%
M 28
 
4.1%
G 28
 
4.1%
K 26
 
3.8%
E 22
 
3.2%
Other values (16) 248
36.6%

정기_부정기여부
Categorical

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
정기
113 
부정기
113 

Length

Max length3
Median length2.5
Mean length2.5
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정기
2nd row부정기
3rd row정기
4th row부정기
5th row정기

Common Values

ValueCountFrequency (%)
정기 113
50.0%
부정기 113
50.0%

Length

2023-12-12T17:52:22.881098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:52:22.999820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정기 113
50.0%
부정기 113
50.0%

총화물출발
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct138
Distinct (%)61.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3403.4398
Minimum0
Maximum304565.5
Zeros87
Zeros (%)38.5%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T17:52:23.142613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median24.95
Q3915.425
95-th percentile7784.975
Maximum304565.5
Range304565.5
Interquartile range (IQR)915.425

Descriptive statistics

Standard deviation23085.395
Coefficient of variation (CV)6.7829596
Kurtosis139.17641
Mean3403.4398
Median Absolute Deviation (MAD)24.95
Skewness11.407861
Sum769177.4
Variance5.3293546 × 108
MonotonicityNot monotonic
2023-12-12T17:52:23.306586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 87
38.5%
3.7 2
 
0.9%
0.1 2
 
0.9%
161291.9 1
 
0.4%
1320.6 1
 
0.4%
6373.4 1
 
0.4%
2709.4 1
 
0.4%
1372.0 1
 
0.4%
160.6 1
 
0.4%
201.0 1
 
0.4%
Other values (128) 128
56.6%
ValueCountFrequency (%)
0.0 87
38.5%
0.1 2
 
0.9%
0.2 1
 
0.4%
0.4 1
 
0.4%
1.0 1
 
0.4%
1.2 1
 
0.4%
2.1 1
 
0.4%
2.3 1
 
0.4%
2.6 1
 
0.4%
2.8 1
 
0.4%
ValueCountFrequency (%)
304565.5 1
0.4%
161291.9 1
0.4%
32261.5 1
0.4%
31776.1 1
0.4%
18435.8 1
0.4%
17866.5 1
0.4%
12209.2 1
0.4%
10076.7 1
0.4%
9360.0 1
0.4%
8284.2 1
0.4%

총화물도착
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct134
Distinct (%)59.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3585.1708
Minimum0
Maximum321747.9
Zeros90
Zeros (%)39.8%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T17:52:23.457990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median10.8
Q3765.075
95-th percentile7882.775
Maximum321747.9
Range321747.9
Interquartile range (IQR)765.075

Descriptive statistics

Standard deviation24460.886
Coefficient of variation (CV)6.8227953
Kurtosis137.61241
Mean3585.1708
Median Absolute Deviation (MAD)10.8
Skewness11.328842
Sum810248.6
Variance5.9833497 × 108
MonotonicityNot monotonic
2023-12-12T17:52:23.656974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 90
39.8%
31.5 2
 
0.9%
0.1 2
 
0.9%
0.2 2
 
0.9%
23.1 1
 
0.4%
5930.1 1
 
0.4%
17.8 1
 
0.4%
4188.2 1
 
0.4%
175.4 1
 
0.4%
21.5 1
 
0.4%
Other values (124) 124
54.9%
ValueCountFrequency (%)
0.0 90
39.8%
0.1 2
 
0.9%
0.2 2
 
0.9%
0.4 1
 
0.4%
0.7 1
 
0.4%
0.9 1
 
0.4%
1.0 1
 
0.4%
1.4 1
 
0.4%
1.5 1
 
0.4%
1.6 1
 
0.4%
ValueCountFrequency (%)
321747.9 1
0.4%
170720.0 1
0.4%
47704.7 1
0.4%
28061.9 1
0.4%
19200.0 1
0.4%
16045.5 1
0.4%
12367.0 1
0.4%
11983.0 1
0.4%
10015.9 1
0.4%
9386.7 1
0.4%

Interactions

2023-12-12T17:52:21.003271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:52:20.773372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:52:21.109803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:52:20.891299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:52:23.808599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정기_부정기여부총화물출발총화물도착
정기_부정기여부1.0000.0000.007
총화물출발0.0001.0000.996
총화물도착0.0070.9961.000
2023-12-12T17:52:23.932019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
총화물출발총화물도착정기_부정기여부
총화물출발1.0000.9390.000
총화물도착0.9391.0000.000
정기_부정기여부0.0000.0001.000

Missing values

2023-12-12T17:52:21.279090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:52:21.419199image/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

연도노선항공사정기_부정기여부총화물출발총화물도착
02023DAAR정기161291.9170720.0
12023DAAR부정기4000.53546.4
22023DKAL정기304565.5321747.9
32023DKAL부정기31776.147704.7
42023DABL정기2237.82297.9
52023DABL부정기59.159.1
62023DESR정기0.40.4
72023DESR부정기0.00.0
82023DJJA정기3353.73332.8
92023DJJA부정기2843.22355.0
연도노선항공사정기_부정기여부총화물출발총화물도착
2162023DUPS정기17866.510015.9
2172023DUPS부정기236.568.5
2182023DUZB정기1154.5115.4
2192023DUZB부정기1171.219.2
2202023DVAG정기0.00.0
2212023DVAG부정기0.00.0
2222023DVJC정기769.72735.8
2232023DVJC부정기0.00.0
2242023DXAX정기2105.51468.9
2252023DXAX부정기0.00.0