Overview

Dataset statistics

Number of variables9
Number of observations129
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.2 KiB
Average record size in memory73.0 B

Variable types

Categorical5
Text1
DateTime3

Dataset

Description제주국제공항 국제선 운항과 관련한 데이터로 구분, 항공사, 편명, 출발지, 도착지, 운항요일, 운항시작기간, 운항종료기간 등 정보를 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15047534/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
구분 is highly overall correlated with 출발지 and 1 other fieldsHigh correlation
도착지 is highly overall correlated with 구분High correlation
출발지 is highly overall correlated with 구분High correlation

Reproduction

Analysis started2023-12-12 00:33:00.888592
Analysis finished2023-12-12 00:33:01.410531
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
출발
65 
도착
64 

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 (%)
출발 65
50.4%
도착 64
49.6%

Length

2023-12-12T09:33:01.459480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:33:01.530985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
출발 65
50.4%
도착 64
49.6%

항공사
Categorical

Distinct16
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
춘추항공
28 
룽에어
18 
중국남방항공
11 
제주항공
11 
길상항공(준야오)
10 
Other values (11)
51 

Length

Max length9
Median length7
Mean length4.8992248
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row춘추항공
2nd row춘추항공
3rd row춘추항공
4th row춘추항공
5th row홍콩익스프레스

Common Values

ValueCountFrequency (%)
춘추항공 28
21.7%
룽에어 18
14.0%
중국남방항공 11
 
8.5%
제주항공 11
 
8.5%
길상항공(준야오) 10
 
7.8%
티웨이항공 10
 
7.8%
서부항공 9
 
7.0%
중국동방항공 6
 
4.7%
홍콩익스프레스 5
 
3.9%
오케이항공 5
 
3.9%
Other values (6) 16
12.4%

Length

2023-12-12T09:33:01.612273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
춘추항공 28
20.7%
룽에어 18
13.3%
중국남방항공 11
 
8.1%
제주항공 11
 
8.1%
길상항공(준야오 10
 
7.4%
티웨이항공 10
 
7.4%
서부항공 9
 
6.7%
중국동방항공 6
 
4.4%
오케이항공 5
 
3.7%
홍콩익스프레스 5
 
3.7%
Other values (8) 22
16.3%

편명
Text

Distinct69
Distinct (%)53.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T09:33:01.803485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.8062016
Min length5

Characters and Unicode

Total characters749
Distinct characters30
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique36 ?
Unique (%)27.9%

Sample

1st row9C6150
2nd row9C7206
3rd row9C8624
4th row9C7206
5th rowUO677
ValueCountFrequency (%)
gj8940 5
 
3.9%
9c8708 5
 
3.9%
9c8707 5
 
3.9%
gj8939 5
 
3.9%
pn6528 4
 
3.1%
gj8906 4
 
3.1%
gj8905 4
 
3.1%
pn6527 4
 
3.1%
uo677 3
 
2.3%
7c2038 3
 
2.3%
Other values (59) 87
67.4%
2023-12-12T09:33:02.098894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 88
11.7%
9 71
 
9.5%
7 66
 
8.8%
6 65
 
8.7%
2 54
 
7.2%
0 51
 
6.8%
C 50
 
6.7%
3 45
 
6.0%
5 38
 
5.1%
1 33
 
4.4%
Other values (20) 188
25.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 530
70.8%
Uppercase Letter 219
29.2%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
C 50
22.8%
G 20
 
9.1%
J 20
 
9.1%
T 16
 
7.3%
Z 15
 
6.8%
O 15
 
6.8%
U 11
 
5.0%
H 10
 
4.6%
W 10
 
4.6%
N 9
 
4.1%
Other values (10) 43
19.6%
Decimal Number
ValueCountFrequency (%)
8 88
16.6%
9 71
13.4%
7 66
12.5%
6 65
12.3%
2 54
10.2%
0 51
9.6%
3 45
8.5%
5 38
7.2%
1 33
 
6.2%
4 19
 
3.6%

Most occurring scripts

ValueCountFrequency (%)
Common 530
70.8%
Latin 219
29.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
C 50
22.8%
G 20
 
9.1%
J 20
 
9.1%
T 16
 
7.3%
Z 15
 
6.8%
O 15
 
6.8%
U 11
 
5.0%
H 10
 
4.6%
W 10
 
4.6%
N 9
 
4.1%
Other values (10) 43
19.6%
Common
ValueCountFrequency (%)
8 88
16.6%
9 71
13.4%
7 66
12.5%
6 65
12.3%
2 54
10.2%
0 51
9.6%
3 45
8.5%
5 38
7.2%
1 33
 
6.2%
4 19
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 749
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 88
11.7%
9 71
 
9.5%
7 66
 
8.8%
6 65
 
8.7%
2 54
 
7.2%
0 51
 
6.8%
C 50
 
6.7%
3 45
 
6.0%
5 38
 
5.1%
1 33
 
4.4%
Other values (20) 188
25.1%

출발지
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)14.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
제주
65 
항조우/항저우
9 
상하이/푸동
8 
심양/선양
 
6
홍콩
 
5
Other values (14)
36 

Length

Max length9
Median length2
Mean length3.7364341
Min length2

Unique

Unique2 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
제주 65
50.4%
항조우/항저우 9
 
7.0%
상하이/푸동 8
 
6.2%
심양/선양 6
 
4.7%
홍콩 5
 
3.9%
베이징/다싱 4
 
3.1%
톈진 4
 
3.1%
정주/정저우 4
 
3.1%
타이페이/타오위안 4
 
3.1%
난징(남경)/난징 3
 
2.3%
Other values (9) 17
 
13.2%

Length

2023-12-12T09:33:02.208995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주 65
50.4%
항조우/항저우 9
 
7.0%
상하이/푸동 8
 
6.2%
심양/선양 6
 
4.7%
홍콩 5
 
3.9%
베이징/다싱 4
 
3.1%
톈진 4
 
3.1%
정주/정저우 4
 
3.1%
타이페이/타오위안 4
 
3.1%
마카오 3
 
2.3%
Other values (9) 17
 
13.2%

도착지
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)15.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
제주
64 
상하이/푸동
9 
항조우/항저우
8 
홍콩
 
6
심양/선양
 
6
Other values (15)
36 

Length

Max length9
Median length2
Mean length3.7209302
Min length2

Unique

Unique3 ?
Unique (%)2.3%

Sample

1st row난징(남경)/난징
2nd row베이징/다싱
3rd row항조우/항저우
4th row베이징/다싱
5th row홍콩

Common Values

ValueCountFrequency (%)
제주 64
49.6%
상하이/푸동 9
 
7.0%
항조우/항저우 8
 
6.2%
홍콩 6
 
4.7%
심양/선양 6
 
4.7%
정주/정저우 4
 
3.1%
타이페이/타오위안 4
 
3.1%
닝보 3
 
2.3%
톈진 3
 
2.3%
난징(남경)/난징 3
 
2.3%
Other values (10) 19
 
14.7%

Length

2023-12-12T09:33:02.323130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주 64
49.6%
상하이/푸동 9
 
7.0%
항조우/항저우 8
 
6.2%
홍콩 6
 
4.7%
심양/선양 6
 
4.7%
정주/정저우 4
 
3.1%
타이페이/타오위안 4
 
3.1%
난징(남경)/난징 3
 
2.3%
베이징/다싱 3
 
2.3%
장춘/창춘 3
 
2.3%
Other values (10) 19
 
14.7%

운항요일
Categorical

Distinct25
Distinct (%)19.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
월+화+수+목+금+토+일
21 
월+금
17 
화+토
12 
월+수+금+일
10 
목+일
9 
Other values (20)
60 

Length

Max length13
Median length11
Mean length5.3410853
Min length1

Unique

Unique4 ?
Unique (%)3.1%

Sample

1st row화+목+토
2nd row월+화+수+목+금+토+일
3rd row월+수+금+일
4th row월+화+수+목+금+토+일
5th row일

Common Values

ValueCountFrequency (%)
월+화+수+목+금+토+일 21
16.3%
월+금 17
13.2%
화+토 12
 
9.3%
월+수+금+일 10
 
7.8%
목+일 9
 
7.0%
목 8
 
6.2%
토 7
 
5.4%
화+목+토 6
 
4.7%
월+화+목+토 4
 
3.1%
화+수+토 4
 
3.1%
Other values (15) 31
24.0%

Length

2023-12-12T09:33:02.435917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
월+화+수+목+금+토+일 21
16.3%
월+금 17
13.2%
화+토 12
 
9.3%
월+수+금+일 10
 
7.8%
목+일 9
 
7.0%
목 8
 
6.2%
토 7
 
5.4%
화+목+토 6
 
4.7%
월+화+목+토 4
 
3.1%
화+수+토 4
 
3.1%
Other values (15) 31
24.0%

운항시작기간
Date

Distinct29
Distinct (%)22.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2023-10-29 00:00:00
Maximum2024-01-27 00:00:00
2023-12-12T09:33:02.525417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:33:02.670518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)

운항종료기간
Date

Distinct22
Distinct (%)17.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2023-11-19 00:00:00
Maximum2024-03-31 00:00:00
2023-12-12T09:33:02.776510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:33:02.878420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2023-11-13 00:00:00
Maximum2023-11-13 00:00:00
2023-12-12T09:33:02.971123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:33:03.058334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T09:33:03.126076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분항공사편명출발지도착지운항요일운항시작기간운항종료기간
구분1.0000.0001.0001.0001.0000.0000.0000.000
항공사0.0001.0001.0000.8380.8450.8920.7340.634
편명1.0001.0001.0000.9990.9990.8300.0000.000
출발지1.0000.8380.9991.0000.0000.6580.0000.426
도착지1.0000.8450.9990.0001.0000.0000.3000.000
운항요일0.0000.8920.8300.6580.0001.0000.8770.767
운항시작기간0.0000.7340.0000.0000.3000.8771.0000.951
운항종료기간0.0000.6340.0000.4260.0000.7670.9511.000
2023-12-12T09:33:03.244625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분도착지항공사출발지운항요일
구분1.0000.9260.0000.9310.000
도착지0.9261.0000.4360.0000.000
항공사0.0000.4361.0000.4400.494
출발지0.9310.0000.4401.0000.231
운항요일0.0000.0000.4940.2311.000
2023-12-12T09:33:03.335562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분항공사출발지도착지운항요일
구분1.0000.0000.9310.9260.000
항공사0.0001.0000.4400.4360.494
출발지0.9310.4401.0000.0000.231
도착지0.9260.4360.0001.0000.000
운항요일0.0000.4940.2310.0001.000

Missing values

2023-12-12T09:33:01.275129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:33:01.372329image/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

구분항공사편명출발지도착지운항요일운항시작기간운항종료기간데이터기준일자
0출발춘추항공9C6150제주난징(남경)/난징화+목+토2023-12-192024-03-302023-11-13
1출발춘추항공9C7206제주베이징/다싱월+화+수+목+금+토+일2023-12-202024-03-302023-11-13
2출발춘추항공9C8624제주항조우/항저우월+수+금+일2023-12-202024-03-292023-11-13
3출발춘추항공9C7206제주베이징/다싱월+화+수+목+금+토+일2023-12-102023-12-192023-11-13
4출발홍콩익스프레스UO677제주홍콩일2023-10-292024-03-302023-11-13
5출발춘추항공9C8624제주항조우/항저우화+목+토2023-10-312024-03-302023-11-13
6출발춘추항공9C8914제주톈진월+수+금+일2023-10-302024-03-302023-11-13
7출발홍콩익스프레스UO677제주홍콩화+목2023-10-292024-03-302023-11-13
8출발홍콩익스프레스UO677제주홍콩토2023-12-032024-03-302023-11-13
9출발타이거에어 타이완IT655제주타이페이/타오위안화+수+금+토2023-10-292024-03-302023-11-13
구분항공사편명출발지도착지운항요일운항시작기간운항종료기간데이터기준일자
119도착길상항공(준야오)HO1377상하이/푸동제주월+화+수+목+금+토+일2023-10-292024-03-302023-11-13
120도착서부항공PN6527정주/정저우제주월+목2023-12-302023-12-312023-11-13
121도착서부항공PN6527정주/정저우제주월+목2024-01-272024-03-292023-11-13
122도착춘추항공9C8567상하이/푸동제주월+화+수+목+금+토+일2023-10-292024-03-302023-11-13
123도착춘추항공9C7205베이징/다싱제주월+화+수+목+금+토+일2023-12-102023-12-192023-11-13
124도착춘추항공9C8623항조우/항저우제주화+목+토2023-10-312024-03-302023-11-13
125도착춘추항공9C8913톈진제주월+수+금+일2023-10-302024-03-302023-11-13
126도착춘추항공9C6149난징(남경)/난징제주화+목+토2023-12-192024-03-302023-11-13
127도착춘추항공9C7205베이징/다싱제주월+화+수+목+금+토+일2023-12-202024-03-302023-11-13
128도착춘추항공9C8623항조우/항저우제주월+수+금+일2023-12-202024-03-292023-11-13