Overview

Dataset statistics

Number of variables8
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows8
Duplicate rows (%)16.7%
Total size in memory3.3 KiB
Average record size in memory69.8 B

Variable types

DateTime1
Categorical7

Dataset

Description산림청 산림항공본부 관리소별 보유 기종의 항공기 제원에 대한 데이터입니다.(항공기도입일, 항공기제조국, 기종명, 담수량, 체공시간, 최대속도, 크기, 제작사 등을 제공합니다.)
Author산림청 산림항공본부
URLhttps://www.data.go.kr/data/15092219/fileData.do

Alerts

Dataset has 8 (16.7%) duplicate rowsDuplicates
체공시간(분) is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation
항공기제조사명 is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation
항공기담수량(리터) is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation
크기 is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation
항공기제조국명 is highly overall correlated with 기종명 and 5 other fieldsHigh correlation
최대속도(시속) is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation
기종명 is highly overall correlated with 항공기제조국명 and 5 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 18:20:06.890749
Analysis finished2023-12-12 18:20:07.462313
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

도입일
Date

Distinct39
Distinct (%)81.2%
Missing0
Missing (%)0.0%
Memory size516.0 B
Minimum1988-04-14 00:00:00
Maximum2022-12-03 00:00:00
2023-12-13T03:20:07.528185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:20:07.960889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)

항공기제조국명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
러시아
29 
미국
14 
프랑스
4 
대한민국
 
1

Length

Max length4
Median length3
Mean length2.7291667
Min length2

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row미국
2nd row미국
3rd row미국
4th row미국
5th row프랑스

Common Values

ValueCountFrequency (%)
러시아 29
60.4%
미국 14
29.2%
프랑스 4
 
8.3%
대한민국 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:08.191498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
러시아 29
60.4%
미국 14
29.2%
프랑스 4
 
8.3%
대한민국 1
 
2.1%

기종명
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size516.0 B
KA-32T
26 
BELL206-L3
7 
S64E
7 
AS350-B2
4 
KA-32A
3 

Length

Max length10
Median length6
Mean length6.4791667
Min length4

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st rowBELL206-L3
2nd rowBELL206-L3
3rd rowBELL206-L3
4th rowBELL206-L3
5th rowAS350-B2

Common Values

ValueCountFrequency (%)
KA-32T 26
54.2%
BELL206-L3 7
 
14.6%
S64E 7
 
14.6%
AS350-B2 4
 
8.3%
KA-32A 3
 
6.2%
KUH-1FS 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:08.427874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ka-32t 26
54.2%
bell206-l3 7
 
14.6%
s64e 7
 
14.6%
as350-b2 4
 
8.3%
ka-32a 3
 
6.2%
kuh-1fs 1
 
2.1%

항공기담수량(리터)
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Memory size516.0 B
3000
29 
600
7 
8000
7 
800
4 
2000
 
1

Length

Max length4
Median length4
Mean length3.7708333
Min length3

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row600
2nd row600
3rd row600
4th row600
5th row800

Common Values

ValueCountFrequency (%)
3000 29
60.4%
600 7
 
14.6%
8000 7
 
14.6%
800 4
 
8.3%
2000 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:08.683963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3000 29
60.4%
600 7
 
14.6%
8000 7
 
14.6%
800 4
 
8.3%
2000 1
 
2.1%

체공시간(분)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
190
29 
200
11 
150
7 
180
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique1 ?
Unique (%)2.1%

Sample

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

Common Values

ValueCountFrequency (%)
190 29
60.4%
200 11
 
22.9%
150 7
 
14.6%
180 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:08.927060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
190 29
60.4%
200 11
 
22.9%
150 7
 
14.6%
180 1
 
2.1%

최대속도(시속)
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size516.0 B
230
29 
240
7 
213
7 
287
5 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row240
2nd row240
3rd row240
4th row240
5th row287

Common Values

ValueCountFrequency (%)
230 29
60.4%
240 7
 
14.6%
213 7
 
14.6%
287 5
 
10.4%

Length

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

Common Values (Plot)

2023-12-13T03:20:09.156465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
230 29
60.4%
240 7
 
14.6%
213 7
 
14.6%
287 5
 
10.4%

크기
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size516.0 B
대형
36 
소형
11 
중형
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row소형
2nd row소형
3rd row소형
4th row소형
5th row소형

Common Values

ValueCountFrequency (%)
대형 36
75.0%
소형 11
 
22.9%
중형 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:09.389991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대형 36
75.0%
소형 11
 
22.9%
중형 1
 
2.1%

항공기제조사명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Memory size516.0 B
KumAPE
29 
Bell Helicopter
7 
ERICSON AIR CRANE
7 
AIRBUS HELICOPTERS
4 
한국항공우주산업 주식회사
 
1

Length

Max length18
Median length6
Mean length10.0625
Min length6

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st rowBell Helicopter
2nd rowBell Helicopter
3rd rowBell Helicopter
4th rowBell Helicopter
5th rowAIRBUS HELICOPTERS

Common Values

ValueCountFrequency (%)
KumAPE 29
60.4%
Bell Helicopter 7
 
14.6%
ERICSON AIR CRANE 7
 
14.6%
AIRBUS HELICOPTERS 4
 
8.3%
한국항공우주산업 주식회사 1
 
2.1%

Length

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

Common Values (Plot)

2023-12-13T03:20:09.701019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kumape 29
39.2%
bell 7
 
9.5%
helicopter 7
 
9.5%
ericson 7
 
9.5%
air 7
 
9.5%
crane 7
 
9.5%
airbus 4
 
5.4%
helicopters 4
 
5.4%
한국항공우주산업 1
 
1.4%
주식회사 1
 
1.4%

Correlations

2023-12-13T03:20:09.798205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도입일항공기제조국명기종명항공기담수량(리터)체공시간(분)최대속도(시속)크기항공기제조사명
도입일1.0001.0001.0001.0001.0001.0001.0001.000
항공기제조국명1.0001.0001.0001.0000.9870.9790.8161.000
기종명1.0001.0001.0001.0001.0001.0001.0001.000
항공기담수량(리터)1.0001.0001.0001.0001.0001.0001.0001.000
체공시간(분)1.0000.9871.0001.0001.0000.9851.0001.000
최대속도(시속)1.0000.9791.0001.0000.9851.0000.6961.000
크기1.0000.8161.0001.0001.0000.6961.0001.000
항공기제조사명1.0001.0001.0001.0001.0001.0001.0001.000
2023-12-13T03:20:09.928314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
체공시간(분)항공기제조사명항공기담수량(리터)크기항공기제조국명최대속도(시속)기종명
체공시간(분)1.0000.9890.9890.9890.8420.8300.977
항공기제조사명0.9891.0001.0000.9780.9890.9890.988
항공기담수량(리터)0.9891.0001.0000.9780.9890.9890.988
크기0.9890.9780.9781.0000.8720.7230.966
항공기제조국명0.8420.9890.9890.8721.0000.8020.977
최대속도(시속)0.8300.9890.9890.7230.8021.0000.977
기종명0.9770.9880.9880.9660.9770.9771.000
2023-12-13T03:20:10.101091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
항공기제조국명기종명항공기담수량(리터)체공시간(분)최대속도(시속)크기항공기제조사명
항공기제조국명1.0000.9770.9890.8420.8020.8720.989
기종명0.9771.0000.9880.9770.9770.9660.988
항공기담수량(리터)0.9890.9881.0000.9890.9890.9781.000
체공시간(분)0.8420.9770.9891.0000.8300.9890.989
최대속도(시속)0.8020.9770.9890.8301.0000.7230.989
크기0.8720.9660.9780.9890.7231.0000.978
항공기제조사명0.9890.9881.0000.9890.9890.9781.000

Missing values

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

도입일항공기제조국명기종명항공기담수량(리터)체공시간(분)최대속도(시속)크기항공기제조사명
01988-04-14미국BELL206-L3600200240소형Bell Helicopter
11991-01-04미국BELL206-L3600200240소형Bell Helicopter
21992-04-01미국BELL206-L3600200240소형Bell Helicopter
31992-04-01미국BELL206-L3600200240소형Bell Helicopter
41992-11-18프랑스AS350-B2800200287소형AIRBUS HELICOPTERS
51993-02-23프랑스AS350-B2800200287소형AIRBUS HELICOPTERS
61993-12-29러시아KA-32T3000190230대형KumAPE
71993-12-29러시아KA-32T3000190230대형KumAPE
81995-04-01러시아KA-32T3000190230대형KumAPE
91995-04-03러시아KA-32T3000190230대형KumAPE
도입일항공기제조국명기종명항공기담수량(리터)체공시간(분)최대속도(시속)크기항공기제조사명
382009-01-08러시아KA-32A3000190230대형KumAPE
392009-12-13러시아KA-32A3000190230대형KumAPE
402011-09-16프랑스AS350-B2800200287소형AIRBUS HELICOPTERS
412014-04-30미국BELL206-L3600200240소형Bell Helicopter
422014-04-30미국BELL206-L3600200240소형Bell Helicopter
432018-05-19대한민국KUH-1FS2000180287중형한국항공우주산업 주식회사
442018-10-27미국S64E8000150213대형ERICSON AIR CRANE
452019-11-29미국S64E8000150213대형ERICSON AIR CRANE
462020-01-09미국S64E8000150213대형ERICSON AIR CRANE
472022-12-03미국S64E8000150213대형ERICSON AIR CRANE

Duplicate rows

Most frequently occurring

도입일항공기제조국명기종명항공기담수량(리터)체공시간(분)최대속도(시속)크기항공기제조사명# duplicates
31996-05-22러시아KA-32T3000190230대형KumAPE3
01992-04-01미국BELL206-L3600200240소형Bell Helicopter2
11993-12-29러시아KA-32T3000190230대형KumAPE2
21995-04-03러시아KA-32T3000190230대형KumAPE2
41997-10-16러시아KA-32T3000190230대형KumAPE2
51999-01-18러시아KA-32T3000190230대형KumAPE2
61999-09-28러시아KA-32T3000190230대형KumAPE2
72014-04-30미국BELL206-L3600200240소형Bell Helicopter2