gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	10000
Missing cells	3377
Missing cells (%)	2.1%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	1.4 MiB
Average record size in memory	143.0 B

Variable types

Categorical	5
Text	4
Numeric	7

Dataset

Description	인천국제공항공사 항공운송실적 정보로 월별, 항공사별, 노선별 여객, 환승, 화물 운송 실적에 대한 세부 정보를 포함하고 있음
Author	인천국제공항공사
URL	https://www.data.go.kr/data/15062056/fileData.do

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`유임승객(명)` is highly overall correlated with `무임승객(명)` and 3 other fields	High correlation
`무임승객(명)` is highly overall correlated with `유임승객(명)` and 2 other fields	High correlation
`환승객(명)` is highly overall correlated with `유임승객(명)` and 2 other fields	High correlation
`항공화물(kg)` is highly overall correlated with `환적화물(kg)`	High correlation
`환적화물(kg)` is highly overall correlated with `항공화물(kg)`	High correlation
`수하물(kg)` is highly overall correlated with `유임승객(명)` and 2 other fields	High correlation
`여객_화물` is highly overall correlated with `유임승객(명)`	High correlation
`국제_국내` is highly imbalanced (84.0%)	Imbalance
`항공사(ICAO)` has 307 (3.1%) missing values	Missing
`항공사(IATA)` has 307 (3.1%) missing values	Missing
`항공사명` has 307 (3.1%) missing values	Missing
`경유지공항` has 307 (3.1%) missing values	Missing
`유임승객(명)` has 307 (3.1%) missing values	Missing
`무임승객(명)` has 307 (3.1%) missing values	Missing
`환승객(명)` has 307 (3.1%) missing values	Missing
`항공화물(kg)` has 307 (3.1%) missing values	Missing
`환적화물(kg)` has 307 (3.1%) missing values	Missing
`우편물(kg)` has 307 (3.1%) missing values	Missing
`수하물(kg)` has 307 (3.1%) missing values	Missing
`유임승객(명)` has 3029 (30.3%) zeros	Zeros
`무임승객(명)` has 3519 (35.2%) zeros	Zeros
`환승객(명)` has 4102 (41.0%) zeros	Zeros
`항공화물(kg)` has 2114 (21.1%) zeros	Zeros
`환적화물(kg)` has 5752 (57.5%) zeros	Zeros
`우편물(kg)` has 7268 (72.7%) zeros	Zeros
`수하물(kg)` has 3038 (30.4%) zeros	Zeros

Reproduction

Analysis started	2024-03-14 11:36:10.885811
Analysis finished	2024-03-14 11:36:26.814729
Duration	15.93 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년월
Categorical

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

2023-10	911
2023-03	871
2023-12	844
2023-09	836
2023-08	811
Other values (8)	5727

Length

Max length	7
Median length	7
Mean length	6.9079
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-06
2nd row	2023-02
3rd row	2023-04
4th row	2023-01
5th row	2023-02

Common Values

Value	Count	Frequency (%)
2023-10	911	9.1%
2023-03	871	8.7%
2023-12	844	8.4%
2023-09	836	8.4%
2023-08	811	8.1%
2023-11	804	8.0%
2023-07	799	8.0%
2023-06	786	7.9%
2023-01	778	7.8%
2023-05	763	7.6%
Other values (3)	1797	18.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2023-10	911	9.1%
2023-03	871	8.7%
2023-12	844	8.4%
2023-09	836	8.4%
2023-08	811	8.1%
2023-11	804	8.0%
2023-07	799	8.0%
2023-06	786	7.9%
2023-01	778	7.8%
2023-05	763	7.6%
Other values (3)	1797	18.0%

항공사(ICAO)
Text

MISSING

Distinct	112
Distinct (%)	1.2%
Missing	307
Missing (%)	3.1%
Memory size	156.2 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	29079
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	AAR
2nd row	KAL
3rd row	KAL
4th row	KAL
5th row	KAL

Value	Count	Frequency (%)
kal	2469	25.5%
aar	1407	14.5%
jja	663	6.8%
twb	512	5.3%
jna	436	4.5%
aih	230	2.4%
gti	220	2.3%
asv	210	2.2%
pac	169	1.7%
csn	167	1.7%
Other values (102)	3210	33.1%

Most occurring characters

Value	Count	Frequency (%)
A	8443	29.0%
L	3126	10.8%
K	2721	9.4%
J	2016	6.9%
R	1575	5.4%
C	1460	5.0%
T	1171	4.0%
S	952	3.3%
B	847	2.9%
N	752	2.6%
Other values (16)	6016	20.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	29079	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	8443	29.0%
L	3126	10.8%
K	2721	9.4%
J	2016	6.9%
R	1575	5.4%
C	1460	5.0%
T	1171	4.0%
S	952	3.3%
B	847	2.9%
N	752	2.6%
Other values (16)	6016	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	29079	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	8443	29.0%
L	3126	10.8%
K	2721	9.4%
J	2016	6.9%
R	1575	5.4%
C	1460	5.0%
T	1171	4.0%
S	952	3.3%
B	847	2.9%
N	752	2.6%
Other values (16)	6016	20.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	8443	29.0%
L	3126	10.8%
K	2721	9.4%
J	2016	6.9%
R	1575	5.4%
C	1460	5.0%
T	1171	4.0%
S	952	3.3%
B	847	2.9%
N	752	2.6%
Other values (16)	6016	20.7%

항공사(IATA)
Text

MISSING

Distinct	111
Distinct (%)	1.1%
Missing	307
Missing (%)	3.1%
Memory size	156.2 KiB

Length

Max length	3
Median length	2
Mean length	2.0008253
Min length	2

Characters and Unicode

Total characters	19394
Distinct characters	35
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	OZ
2nd row	KE
3rd row	KE
4th row	KE
5th row	KE

Value	Count	Frequency (%)
ke	2469	25.5%
oz	1407	14.5%
7c	663	6.8%
tw	512	5.3%
lj	436	4.5%
kj	230	2.4%
5y	220	2.3%
rs	210	2.2%
po	169	1.7%
cz	167	1.7%
Other values (101)	3210	33.1%

Most occurring characters

Value	Count	Frequency (%)
K	2895	14.9%
E	2614	13.5%
Z	1736	9.0%
O	1715	8.8%
C	1293	6.7%
J	911	4.7%
T	721	3.7%
7	706	3.6%
L	691	3.6%
W	530	2.7%
Other values (25)	5582	28.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17911	92.4%
Decimal Number	1483	7.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
K	2895	16.2%
E	2614	14.6%
Z	1736	9.7%
O	1715	9.6%
C	1293	7.2%
J	911	5.1%
T	721	4.0%
L	691	3.9%
W	530	3.0%
X	526	2.9%
Other values (16)	4279	23.9%

Decimal Number

Value	Count	Frequency (%)
7	706	47.6%
5	422	28.5%
9	78	5.3%
4	73	4.9%
3	57	3.8%
8	48	3.2%
2	40	2.7%
6	31	2.1%
0	28	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17911	92.4%
Common	1483	7.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
K	2895	16.2%
E	2614	14.6%
Z	1736	9.7%
O	1715	9.6%
C	1293	7.2%
J	911	5.1%
T	721	4.0%
L	691	3.9%
W	530	3.0%
X	526	2.9%
Other values (16)	4279	23.9%

Common

Value	Count	Frequency (%)
7	706	47.6%
5	422	28.5%
9	78	5.3%
4	73	4.9%
3	57	3.8%
8	48	3.2%
2	40	2.7%
6	31	2.1%
0	28	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19394	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
K	2895	14.9%
E	2614	13.5%
Z	1736	9.0%
O	1715	8.8%
C	1293	6.7%
J	911	4.7%
T	721	3.7%
7	706	3.6%
L	691	3.6%
W	530	2.7%
Other values (25)	5582	28.8%

항공사명
Text

MISSING

Distinct	111
Distinct (%)	1.1%
Missing	307
Missing (%)	3.1%
Memory size	156.2 KiB

Length

Max length	16
Median length	15
Mean length	5.2015888
Min length	3

Characters and Unicode

Total characters	50419
Distinct characters	170
Distinct categories	7 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	아시아나항공
2nd row	대한항공
3rd row	대한항공
4th row	대한항공
5th row	대한항공

Value	Count	Frequency (%)
대한항공	2469	22.3%
아시아나항공	1407	12.7%
에어	700	6.3%
제주항공	663	6.0%
티웨이항공	512	4.6%
진	436	3.9%
항공	289	2.6%
에어인천	230	2.1%
아틀라스항공	220	2.0%
에어서울	210	1.9%
Other values (120)	3926	35.5%

Most occurring characters

Value	Count	Frequency (%)
항	7942	15.8%
공	7942	15.8%
아	3592	7.1%
한	2524	5.0%
대	2469	4.9%
에	1876	3.7%
시	1648	3.3%
어	1598	3.2%
나	1500	3.0%
	1369	2.7%
Other values (160)	17959	35.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	47590	94.4%
Space Separator	1369	2.7%
Uppercase Letter	1136	2.3%
Lowercase Letter	282	0.6%
Open Punctuation	19	< 0.1%
Close Punctuation	19	< 0.1%
Dash Punctuation	4	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
항	7942	16.7%
공	7942	16.7%
아	3592	7.5%
한	2524	5.3%
대	2469	5.2%
에	1876	3.9%
시	1648	3.5%
어	1598	3.4%
나	1500	3.2%
제	969	2.0%
Other values (135)	15530	32.6%

Uppercase Letter

Value	Count	Frequency (%)
E	199	17.5%
F	144	12.7%
X	141	12.4%
L	118	10.4%
I	78	6.9%
A	74	6.5%
T	65	5.7%
D	51	4.5%
M	51	4.5%
R	46	4.0%
Other values (9)	169	14.9%

Lowercase Letter

Value	Count	Frequency (%)
d	141	50.0%
e	141	50.0%

Space Separator

Value	Count	Frequency (%)
	1369	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	19	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	19	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	47590	94.4%
Latin	1418	2.8%
Common	1411	2.8%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
항	7942	16.7%
공	7942	16.7%
아	3592	7.5%
한	2524	5.3%
대	2469	5.2%
에	1876	3.9%
시	1648	3.5%
어	1598	3.4%
나	1500	3.2%
제	969	2.0%
Other values (135)	15530	32.6%

Latin

Value	Count	Frequency (%)
E	199	14.0%
F	144	10.2%
X	141	9.9%
d	141	9.9%
e	141	9.9%
L	118	8.3%
I	78	5.5%
A	74	5.2%
T	65	4.6%
D	51	3.6%
Other values (11)	266	18.8%

Common

Value	Count	Frequency (%)
	1369	97.0%
(	19	1.3%
)	19	1.3%
-	4	0.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	47590	94.4%
ASCII	2829	5.6%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
항	7942	16.7%
공	7942	16.7%
아	3592	7.5%
한	2524	5.3%
대	2469	5.2%
에	1876	3.9%
시	1648	3.5%
어	1598	3.4%
나	1500	3.2%
제	969	2.0%
Other values (135)	15530	32.6%

ASCII

Value	Count	Frequency (%)
	1369	48.4%
E	199	7.0%
F	144	5.1%
X	141	5.0%
d	141	5.0%
e	141	5.0%
L	118	4.2%
I	78	2.8%
A	74	2.6%
T	65	2.3%
Other values (15)	359	12.7%

국제_국내
Categorical

IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

국제	9628
<NA>	307
국내	65

Length

Max length	4
Median length	2
Mean length	2.0614
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	국제
2nd row	국제
3rd row	국제
4th row	국제
5th row	국제

Common Values

Value	Count	Frequency (%)
국제	9628	96.3%
<NA>	307	3.1%
국내	65	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
국제	9628	96.3%
na	307	3.1%
국내	65	0.7%

경유지공항
Text

MISSING

Distinct	215
Distinct (%)	2.2%
Missing	307
Missing (%)	3.1%
Memory size	156.2 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	29079
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	0.2%

Sample

1st row	TAO
2nd row	OSL
3rd row	BNE
4th row	KKJ
5th row	SEA

Value	Count	Frequency (%)
nrt	364	3.8%
hkg	309	3.2%
kix	279	2.9%
tpe	229	2.4%
han	224	2.3%
pvg	212	2.2%
bkk	210	2.2%
dad	206	2.1%
lax	197	2.0%
cxr	169	1.7%
Other values (205)	7294	75.3%

Most occurring characters

Value	Count	Frequency (%)
N	2465	8.5%
K	2313	8.0%
A	2196	7.6%
T	1700	5.8%
C	1633	5.6%
G	1597	5.5%
S	1591	5.5%
H	1444	5.0%
D	1431	4.9%
R	1221	4.2%
Other values (16)	11488	39.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	29079	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	2465	8.5%
K	2313	8.0%
A	2196	7.6%
T	1700	5.8%
C	1633	5.6%
G	1597	5.5%
S	1591	5.5%
H	1444	5.0%
D	1431	4.9%
R	1221	4.2%
Other values (16)	11488	39.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	29079	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	2465	8.5%
K	2313	8.0%
A	2196	7.6%
T	1700	5.8%
C	1633	5.6%
G	1597	5.5%
S	1591	5.5%
H	1444	5.0%
D	1431	4.9%
R	1221	4.2%
Other values (16)	11488	39.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29079	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	2465	8.5%
K	2313	8.0%
A	2196	7.6%
T	1700	5.8%
C	1633	5.6%
G	1597	5.5%
S	1591	5.5%
H	1444	5.0%
D	1431	4.9%
R	1221	4.2%
Other values (16)	11488	39.5%

도착_출발
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

출발	4854
도착	4839
<NA>	307

Length

Max length	4
Median length	2
Mean length	2.0614
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	출발
2nd row	도착
3rd row	도착
4th row	도착
5th row	출발

Common Values

Value	Count	Frequency (%)
출발	4854	48.5%
도착	4839	48.4%
<NA>	307	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
출발	4854	48.5%
도착	4839	48.4%
na	307	3.1%

정기_부정기
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

정기	7879
부정기	1814
<NA>	307

Length

Max length	4
Median length	2
Mean length	2.2428
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
정기	7879	78.8%
부정기	1814	18.1%
<NA>	307	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
정기	7879	78.8%
부정기	1814	18.1%
na	307	3.1%

여객_화물
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

여객	6671
화물	3022
<NA>	307

Length

Max length	4
Median length	2
Mean length	2.0614
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	여객
2nd row	화물
3rd row	여객
4th row	화물
5th row	여객

Common Values

Value	Count	Frequency (%)
여객	6671	66.7%
화물	3022	30.2%
<NA>	307	3.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
여객	6671	66.7%
화물	3022	30.2%
na	307	3.1%

유임승객(명)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	4986
Distinct (%)	51.4%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	3725.1487

Minimum	0
Maximum	39315
Zeros	3029
Zeros (%)	30.3%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1931
Q3	5218
95-th percentile	14076.2
Maximum	39315
Range	39315
Interquartile range (IQR)	5218

Descriptive statistics

Standard deviation	5042.0313
Coefficient of variation (CV)	1.3535114
Kurtosis	6.3271582
Mean	3725.1487
Median Absolute Deviation (MAD)	1931
Skewness	2.1979239
Sum	36107866
Variance	25422080
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3029	30.3%
2	6	0.1%
172	6	0.1%
188	6	0.1%
3661	6	0.1%
4582	6	0.1%
304	6	0.1%
2127	6	0.1%
179	5	0.1%
171	5	0.1%
Other values (4976)	6612	66.1%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3029	30.3%
1	3	< 0.1%
2	6	0.1%
3	2	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
6	1	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
39315	1	< 0.1%
36354	1	< 0.1%
36046	1	< 0.1%
35513	1	< 0.1%
35182	1	< 0.1%
34798	1	< 0.1%
34564	1	< 0.1%
34184	1	< 0.1%
33849	1	< 0.1%
33353	1	< 0.1%

무임승객(명)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	212
Distinct (%)	2.2%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	18.666151

Minimum	0
Maximum	361
Zeros	3519
Zeros (%)	35.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6
Q3	25
95-th percentile	78
Maximum	361
Range	361
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	31.170149
Coefficient of variation (CV)	1.6698755
Kurtosis	17.432776
Mean	18.666151
Median Absolute Deviation (MAD)	6
Skewness	3.3629709
Sum	180931
Variance	971.57817
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3519	35.2%
1	285	2.9%
2	260	2.6%
5	249	2.5%
3	239	2.4%
6	211	2.1%
4	209	2.1%
7	189	1.9%
8	162	1.6%
10	159	1.6%
Other values (202)	4211	42.1%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3519	35.2%
1	285	2.9%
2	260	2.6%
3	239	2.4%
4	209	2.1%
5	249	2.5%
6	211	2.1%
7	189	1.9%
8	162	1.6%
9	159	1.6%

Value	Count	Frequency (%)
361	1	< 0.1%
332	1	< 0.1%
328	1	< 0.1%
326	1	< 0.1%
313	1	< 0.1%
311	1	< 0.1%
309	1	< 0.1%
287	1	< 0.1%
282	1	< 0.1%
280	1	< 0.1%

환승객(명)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1861
Distinct (%)	19.2%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	477.76519

Minimum	0
Maximum	18673
Zeros	4102
Zeros (%)	41.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	8
Q3	237
95-th percentile	2831.4
Maximum	18673
Range	18673
Interquartile range (IQR)	237

Descriptive statistics

Standard deviation	1362.3092
Coefficient of variation (CV)	2.85142
Kurtosis	39.092452
Mean	477.76519
Median Absolute Deviation (MAD)	8
Skewness	5.3925986
Sum	4630978
Variance	1855886.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4102	41.0%
1	157	1.6%
2	136	1.4%
3	103	1.0%
4	98	1.0%
6	78	0.8%
5	71	0.7%
9	60	0.6%
8	59	0.6%
7	54	0.5%
Other values (1851)	4775	47.8%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4102	41.0%
1	157	1.6%
2	136	1.4%
3	103	1.0%
4	98	1.0%
5	71	0.7%
6	78	0.8%
7	54	0.5%
8	59	0.6%
9	60	0.6%

Value	Count	Frequency (%)
18673	1	< 0.1%
18026	1	< 0.1%
17571	1	< 0.1%
15811	1	< 0.1%
15022	1	< 0.1%
14897	1	< 0.1%
14894	1	< 0.1%
14832	1	< 0.1%
14373	1	< 0.1%
13949	1	< 0.1%

항공화물(kg)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	7331
Distinct (%)	75.6%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	209714.82

Minimum	0
Maximum	4843510
Zeros	2114
Zeros (%)	21.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	336
median	41677
Q3	232017
95-th percentile	978658
Maximum	4843510
Range	4843510
Interquartile range (IQR)	231681

Descriptive statistics

Standard deviation	422734.49
Coefficient of variation (CV)	2.0157588
Kurtosis	23.745511
Mean	209714.82
Median Absolute Deviation (MAD)	41677
Skewness	4.1560985
Sum	2.0327658 × 10⁹
Variance	1.7870445 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2114	21.1%
3	9	0.1%
1	7	0.1%
45	6	0.1%
231	5	0.1%
15	5	0.1%
200	4	< 0.1%
72	4	< 0.1%
336	4	< 0.1%
60	4	< 0.1%
Other values (7321)	7531	75.3%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2114	21.1%
1	7	0.1%
2	2	< 0.1%
3	9	0.1%
4	2	< 0.1%
5	1	< 0.1%
6	3	< 0.1%
7	3	< 0.1%
8	3	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
4843510	1	< 0.1%
4789015	1	< 0.1%
4729729	1	< 0.1%
4299632	1	< 0.1%
4247784	1	< 0.1%
4118294	1	< 0.1%
4077933	1	< 0.1%
3974124	1	< 0.1%
3914062	1	< 0.1%
3872575	1	< 0.1%

환적화물(kg)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	3876
Distinct (%)	40.0%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	88027.241

Minimum	0
Maximum	3583128
Zeros	5752
Zeros (%)	57.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	40330
95-th percentile	450588.2
Maximum	3583128
Range	3583128
Interquartile range (IQR)	40330

Descriptive statistics

Standard deviation	286377.06
Coefficient of variation (CV)	3.2532777
Kurtosis	54.646902
Mean	88027.241
Median Absolute Deviation (MAD)	0
Skewness	6.5618139
Sum	8.5324804 × 10⁸
Variance	8.201182 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5752	57.5%
2	5	0.1%
261	3	< 0.1%
18	3	< 0.1%
4	3	< 0.1%
1	3	< 0.1%
123	3	< 0.1%
250	3	< 0.1%
26	3	< 0.1%
120	2	< 0.1%
Other values (3866)	3913	39.1%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5752	57.5%
1	3	< 0.1%
2	5	0.1%
4	3	< 0.1%
6	2	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
11	1	< 0.1%
12	2	< 0.1%

Value	Count	Frequency (%)
3583128	1	< 0.1%
3548079	1	< 0.1%
3447077	1	< 0.1%
3429379	1	< 0.1%
3364957	1	< 0.1%
3340117	1	< 0.1%
3330973	1	< 0.1%
3274068	1	< 0.1%
3268393	1	< 0.1%
3215044	1	< 0.1%

우편물(kg)
Real number (ℝ)

MISSING ZEROS

Distinct	2230
Distinct (%)	23.0%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	2891.0424

Minimum	0
Maximum	230373
Zeros	7268
Zeros (%)	72.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	15909
Maximum	230373
Range	230373
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	10762.029
Coefficient of variation (CV)	3.7225429
Kurtosis	76.72897
Mean	2891.0424
Median Absolute Deviation (MAD)	0
Skewness	7.2445221
Sum	28022874
Variance	1.1582127 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7268	72.7%
47	5	0.1%
25	5	0.1%
143	4	< 0.1%
384	3	< 0.1%
63	3	< 0.1%
1612	3	< 0.1%
11	3	< 0.1%
555	3	< 0.1%
8	3	< 0.1%
Other values (2220)	2393	23.9%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7268	72.7%
1	2	< 0.1%
2	3	< 0.1%
3	1	< 0.1%
4	3	< 0.1%
5	3	< 0.1%
7	1	< 0.1%
8	3	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
230373	1	< 0.1%
200132	1	< 0.1%
152349	1	< 0.1%
146802	1	< 0.1%
142600	1	< 0.1%
137411	1	< 0.1%
131656	1	< 0.1%
124784	1	< 0.1%
120190	1	< 0.1%
118032	1	< 0.1%

수하물(kg)
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	6528
Distinct (%)	67.3%
Missing	307
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	64381.776

Minimum	0
Maximum	827819
Zeros	3038
Zeros (%)	30.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	31798
Q3	91804
95-th percentile	239289.8
Maximum	827819
Range	827819
Interquartile range (IQR)	91804

Descriptive statistics

Standard deviation	92662.907
Coefficient of variation (CV)	1.4392723
Kurtosis	10.073781
Mean	64381.776
Median Absolute Deviation (MAD)	31798
Skewness	2.6498708
Sum	6.2405255 × 10⁸
Variance	8.5864144 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3038	30.4%
2036	3	< 0.1%
25370	3	< 0.1%
91818	2	< 0.1%
20105	2	< 0.1%
83037	2	< 0.1%
48672	2	< 0.1%
45828	2	< 0.1%
37060	2	< 0.1%
25306	2	< 0.1%
Other values (6518)	6635	66.3%
(Missing)	307	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3038	30.4%
27	2	< 0.1%
33	1	< 0.1%
49	1	< 0.1%
62	1	< 0.1%
70	1	< 0.1%
85	1	< 0.1%
90	1	< 0.1%
110	1	< 0.1%
120	1	< 0.1%

Value	Count	Frequency (%)
827819	1	< 0.1%
820141	1	< 0.1%
774555	1	< 0.1%
754131	1	< 0.1%
731399	1	< 0.1%
693293	1	< 0.1%
691836	1	< 0.1%
689815	1	< 0.1%
688287	1	< 0.1%
685344	1	< 0.1%

Heatmap
Table

	년월	국제_국내	도착_출발	정기_부정기	여객_화물	유임승객(명)	무임승객(명)	환승객(명)	항공화물(kg)	환적화물(kg)	우편물(kg)	수하물(kg)
년월	1.000	0.029	0.000	0.132	0.040	0.095	0.049	0.029	0.000	0.000	0.000	0.061
국제_국내	0.029	1.000	0.062	0.097	0.083	0.065	0.055	0.000	0.009	0.000	0.000	0.083
도착_출발	0.000	0.062	1.000	0.021	0.009	0.000	0.033	0.000	0.074	0.055	0.071	0.038
정기_부정기	0.132	0.097	0.021	1.000	0.282	0.423	0.266	0.174	0.139	0.055	0.066	0.372
여객_화물	0.040	0.083	0.009	0.282	1.000	0.648	0.393	0.253	0.556	0.432	0.036	0.535
유임승객(명)	0.095	0.065	0.000	0.423	0.648	1.000	0.667	0.316	0.218	0.131	0.149	0.773
무임승객(명)	0.049	0.055	0.033	0.266	0.393	0.667	1.000	0.358	0.105	0.000	0.149	0.620
환승객(명)	0.029	0.000	0.000	0.174	0.253	0.316	0.358	1.000	0.147	0.126	0.236	0.824
항공화물(kg)	0.000	0.009	0.074	0.139	0.556	0.218	0.105	0.147	1.000	0.926	0.148	0.263
환적화물(kg)	0.000	0.000	0.055	0.055	0.432	0.131	0.000	0.126	0.926	1.000	0.138	0.162
우편물(kg)	0.000	0.000	0.071	0.066	0.036	0.149	0.149	0.236	0.148	0.138	1.000	0.287
수하물(kg)	0.061	0.083	0.038	0.372	0.535	0.773	0.620	0.824	0.263	0.162	0.287	1.000

Heatmap
Table

	정기_부정기	국제_국내	년월	여객_화물	도착_출발
정기_부정기	1.000	0.062	0.102	0.182	0.013
국제_국내	0.062	1.000	0.022	0.053	0.039
년월	0.102	0.022	1.000	0.031	0.000
여객_화물	0.182	0.053	0.031	1.000	0.006
도착_출발	0.013	0.039	0.000	0.006	1.000

Heatmap
Table

	유임승객(명)	무임승객(명)	환승객(명)	항공화물(kg)	환적화물(kg)	우편물(kg)	수하물(kg)	년월	국제_국내	도착_출발	정기_부정기	여객_화물
유임승객(명)	1.000	0.917	0.717	-0.217	-0.240	0.215	0.953	0.040	0.050	0.000	0.325	0.503
무임승객(명)	0.917	1.000	0.744	-0.199	-0.185	0.214	0.911	0.021	0.042	0.026	0.204	0.301
환승객(명)	0.717	0.744	1.000	-0.019	0.046	0.285	0.830	0.012	0.000	0.000	0.133	0.194
항공화물(kg)	-0.217	-0.199	-0.019	1.000	0.643	0.372	-0.117	0.000	0.007	0.057	0.107	0.429
환적화물(kg)	-0.240	-0.185	0.046	0.643	1.000	0.171	-0.139	0.000	0.000	0.042	0.042	0.332
우편물(kg)	0.215	0.214	0.285	0.372	0.171	1.000	0.272	0.000	0.000	0.071	0.066	0.036
수하물(kg)	0.953	0.911	0.830	-0.117	-0.139	0.272	1.000	0.026	0.064	0.029	0.285	0.412
년월	0.040	0.021	0.012	0.000	0.000	0.000	0.026	1.000	0.022	0.000	0.102	0.031
국제_국내	0.050	0.042	0.000	0.007	0.000	0.000	0.064	0.022	1.000	0.039	0.062	0.053
도착_출발	0.000	0.026	0.000	0.057	0.042	0.071	0.029	0.000	0.039	1.000	0.013	0.006
정기_부정기	0.325	0.204	0.133	0.107	0.042	0.066	0.285	0.102	0.062	0.013	1.000	0.182
여객_화물	0.503	0.301	0.194	0.429	0.332	0.036	0.412	0.031	0.053	0.006	0.182	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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	년월	항공사(ICAO)	항공사(IATA)	항공사명	국제_국내	경유지공항	도착_출발	정기_부정기	여객_화물	유임승객(명)	무임승객(명)	환승객(명)	항공화물(kg)	환적화물(kg)	우편물(kg)	수하물(kg)
5458	2023-06	AAR	OZ	아시아나항공	국제	TAO	출발	정기	여객	785	3	721	6501	3575	0	27726
1787	2023-02	KAL	KE	대한항공	국제	OSL	도착	정기	화물	0	0	0	636105	107794	0	0
3848	2023-04	KAL	KE	대한항공	국제	BNE	도착	정기	여객	760	13	92	3230	0	0	15910
703	2023-01	KAL	KE	대한항공	국제	KKJ	도착	부정기	화물	0	0	0	3868	3452	0	0
1809	2023-02	KAL	KE	대한항공	국제	SEA	출발	정기	여객	1907	21	2496	83159	77574	0	134936
13234	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
2629	2023-03	JJA	7C	제주항공	국제	FUK	출발	정기	여객	21723	103	91	0	0	0	173646
4699	2023-05	GTI	5Y	아틀라스항공	국제	HAN	출발	정기	화물	0	0	0	72291	0	0	0
112	2023-01	AAR	OZ	아시아나항공	국제	SFO	도착	정기	여객	4052	17	4545	117882	5734	0	276846
10746	2023-10	MFX	C6	MY FREIGHTER	국제	TAS	출발	부정기	화물	0	0	0	83258	0	0	0

	년월	항공사(ICAO)	항공사(IATA)	항공사명	국제_국내	경유지공항	도착_출발	정기_부정기	여객_화물	유임승객(명)	무임승객(명)	환승객(명)	항공화물(kg)	환적화물(kg)	우편물(kg)	수하물(kg)
4929	2023-05	KAL	KE	대한항공	국제	DAD	출발	정기	여객	10268	136	1367	33388	29457	0	149289
13472	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
2951	2023-03	KAL	KE	대한항공	국제	RGN	출발	정기	여객	710	2	102	35953	23740	0	22658
2543	2023-03	FDX	FX	FedEX항공	국제	SZX	출발	정기	화물	0	0	0	39539	39290	0	0
8402	2023-08	PAC	PO	폴라에어카고	국제	CVG	출발	부정기	화물	0	0	0	12007	1715	0	0
10072	2023-10	CES	MU	중국동방항공	국제	XIY	출발	정기	여객	9	0	0	0	0	0	123
8936	2023-09	CSN	CZ	중국남방항공	국제	CSX	출발	정기	여객	177	0	1	0	0	0	1943
1568	2023-02	JNA	LJ	진 에어	국제	CRK	도착	부정기	여객	319	0	53	0	0	0	6781
5371	2023-06	AAR	OZ	아시아나항공	국제	FRA	도착	정기	여객	8170	24	218	310883	33288	0	158105
10370	2023-10	JNA	LJ	진 에어	국제	BKK	도착	정기	여객	10941	35	63	236242	0	4581	131930

Most frequently occurring

	년월	항공사(ICAO)	항공사(IATA)	항공사명	국제_국내	경유지공항	도착_출발	정기_부정기	여객_화물	유임승객(명)	무임승객(명)	환승객(명)	항공화물(kg)	환적화물(kg)	우편물(kg)	수하물(kg)	# duplicates
0	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	307

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Lowercase Letter

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring