gimi9 Pandas Profiling

Dataset statistics

Number of variables	18
Number of observations	10000
Missing cells	25774
Missing cells (%)	14.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	161.0 B

Variable types

Text	3
DateTime	1
Numeric	9
Unsupported	1
Categorical	4

Dataset

Description	국토지리정보원의 항공사진 관련 메타데이터 중 항공사진촬영기록코스 입니다. (촬영일자, 렌즈번호, 코스일련번호, 코스번호 등)
Author	국토교통부 국토지리정보원
URL	https://www.data.go.kr/data/15067483/fileData.do

Alerts

`대표필름번호` is highly overall correlated with `최소위성수`	High correlation
`촬영각도` is highly overall correlated with `촬영방향`	High correlation
`최소위성수` is highly overall correlated with `대표필름번호` and 1 other fields	High correlation
`진행방향중복도_최대` is highly overall correlated with `진행방향중복도_최소` and 1 other fields	High correlation
`진행방향중복도_최소` is highly overall correlated with `진행방향중복도_최대`	High correlation
`촬영중복도_최대` is highly overall correlated with `촬영중복도_최소` and 1 other fields	High correlation
`촬영중복도_최소` is highly overall correlated with `촬영중복도_최대`	High correlation
`노출` is highly overall correlated with `조리개`	High correlation
`조리개` is highly overall correlated with `최소위성수` and 3 other fields	High correlation
`촬영방향` is highly overall correlated with `촬영각도`	High correlation
`필터` is highly imbalanced (52.8%)	Imbalance
`개시시간` has 2586 (25.9%) missing values	Missing
`대표필름번호` has 5708 (57.1%) missing values	Missing
`매수` has 660 (6.6%) missing values	Missing
`촬영각도` has 2452 (24.5%) missing values	Missing
`최소위성수` has 3475 (34.8%) missing values	Missing
`진행방향중복도_최대` has 2706 (27.1%) missing values	Missing
`진행방향중복도_최소` has 2736 (27.4%) missing values	Missing
`촬영중복도_최대` has 2725 (27.3%) missing values	Missing
`촬영중복도_최소` has 2726 (27.3%) missing values	Missing
`매수` is highly skewed (γ1 = 85.22601283)	Skewed
`개시시간` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`대표필름번호` has 1665 (16.7%) zeros	Zeros
`매수` has 462 (4.6%) zeros	Zeros
`촬영각도` has 3289 (32.9%) zeros	Zeros
`진행방향중복도_최대` has 484 (4.8%) zeros	Zeros
`진행방향중복도_최소` has 484 (4.8%) zeros	Zeros
`촬영중복도_최대` has 484 (4.8%) zeros	Zeros
`촬영중복도_최소` has 484 (4.8%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 13:08:22.589734
Analysis finished	2023-12-12 13:08:34.417562
Duration	11.83 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

사업지구코드
Text

Distinct	1742
Distinct (%)	17.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	110000
Distinct characters	14
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	352 ?
Unique (%)	3.5%

Sample

1st row	201704A208N
2nd row	196600A0001
3rd row	200804A0017
4th row	201309A303C
5th row	201704A511N

Value	Count	Frequency (%)
202102a102c	64	0.6%
202102a102d	59	0.6%
202102a103c	52	0.5%
201309a301c	46	0.5%
202003a0203	44	0.4%
202102a101d	44	0.4%
202102a103d	44	0.4%
201505a301c	43	0.4%
201309a304c	42	0.4%
202102a101c	41	0.4%
Other values (1732)	9521	95.2%

Most occurring characters

Value	Count	Frequency (%)
0	33937	30.9%
2	17428	15.8%
1	15491	14.1%
A	10000	9.1%
3	6587	6.0%
9	4794	4.4%
4	4648	4.2%
C	4493	4.1%
5	3959	3.6%
8	2321	2.1%
Other values (4)	6342	5.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	93749	85.2%
Uppercase Letter	16251	14.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	33937	36.2%
2	17428	18.6%
1	15491	16.5%
3	6587	7.0%
9	4794	5.1%
4	4648	5.0%
5	3959	4.2%
8	2321	2.5%
6	2300	2.5%
7	2284	2.4%

Uppercase Letter

Value	Count	Frequency (%)
A	10000	61.5%
C	4493	27.6%
N	935	5.8%
D	823	5.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	93749	85.2%
Latin	16251	14.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	33937	36.2%
2	17428	18.6%
1	15491	16.5%
3	6587	7.0%
9	4794	5.1%
4	4648	5.0%
5	3959	4.2%
8	2321	2.5%
6	2300	2.5%
7	2284	2.4%

Latin

Value	Count	Frequency (%)
A	10000	61.5%
C	4493	27.6%
N	935	5.8%
D	823	5.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	110000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	33937	30.9%
2	17428	15.8%
1	15491	14.1%
A	10000	9.1%
3	6587	6.0%
9	4794	4.4%
4	4648	4.2%
C	4493	4.1%
5	3959	3.6%
8	2321	2.1%
Other values (4)	6342	5.8%

촬영일자
Date

Distinct	2566
Distinct (%)	25.7%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	1947-10-16 00:00:00
Maximum	2023-04-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

렌즈번호
Text

Distinct	116
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	20
Median length	17
Mean length	7.2581
Min length	1

Characters and Unicode

Total characters	72581
Distinct characters	33
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

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

Unique

Unique	8 ?
Unique (%)	0.1%

Sample

1st row	15244
2nd row	54
3rd row	13084
4th row	1311
5th row	UC-SXp-1-91514228

Value	Count	Frequency (%)
1307	766	7.6%
1	640	6.4%
30107	606	6.0%
dmcii230-018	431	4.3%
1311	406	4.0%
dmcii250-038	379	3.8%
404	318	3.2%
13032	299	3.0%
uc-sxp-1-00015244	284	2.8%
10312058	282	2.8%
Other values (106)	5615	56.0%

Most occurring characters

Value	Count	Frequency (%)
1	14100	19.4%
0	11142	15.4%
3	7020	9.7%
2	5789	8.0%
-	4440	6.1%
5	4411	6.1%
4	3597	5.0%
8	2965	4.1%
C	2679	3.7%
7	2433	3.4%
Other values (23)	14005	19.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	54439	75.0%
Uppercase Letter	12515	17.2%
Dash Punctuation	4440	6.1%
Lowercase Letter	1085	1.5%
Connector Punctuation	58	0.1%
Space Separator	26	< 0.1%
Other Punctuation	17	< 0.1%
Letter Number	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	2679	21.4%
I	2137	17.1%
D	1811	14.5%
M	1782	14.2%
S	1243	9.9%
X	1225	9.8%
U	1047	8.4%
A	258	2.1%
G	193	1.5%
N	75	0.6%
Other values (4)	65	0.5%

Decimal Number

Value	Count	Frequency (%)
1	14100	25.9%
0	11142	20.5%
3	7020	12.9%
2	5789	10.6%
5	4411	8.1%
4	3597	6.6%
8	2965	5.4%
7	2433	4.5%
6	1590	2.9%
9	1392	2.6%

Lowercase Letter

Value	Count	Frequency (%)
p	784	72.3%
e	156	14.4%
f	91	8.4%
r	54	5.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4440	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	58	100.0%

Space Separator

Value	Count	Frequency (%)
	26	100.0%

Other Punctuation

Value	Count	Frequency (%)
#	17	100.0%

Letter Number

Value	Count	Frequency (%)
Ⅱ	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	58980	81.3%
Latin	13601	18.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	2679	19.7%
I	2137	15.7%
D	1811	13.3%
M	1782	13.1%
S	1243	9.1%
X	1225	9.0%
U	1047	7.7%
p	784	5.8%
A	258	1.9%
G	193	1.4%
Other values (9)	442	3.2%

Common

Value	Count	Frequency (%)
1	14100	23.9%
0	11142	18.9%
3	7020	11.9%
2	5789	9.8%
-	4440	7.5%
5	4411	7.5%
4	3597	6.1%
8	2965	5.0%
7	2433	4.1%
6	1590	2.7%
Other values (4)	1493	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72580	> 99.9%
Number Forms	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	14100	19.4%
0	11142	15.4%
3	7020	9.7%
2	5789	8.0%
-	4440	6.1%
5	4411	6.1%
4	3597	5.0%
8	2965	4.1%
C	2679	3.7%
7	2433	3.4%
Other values (22)	14004	19.3%

Number Forms

Value	Count	Frequency (%)
Ⅱ	1	100.0%

코스일련번호
Real number (ℝ)

Distinct	818
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	112.4718

Minimum	1
Maximum	988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	11
median	38
Q3	114
95-th percentile	552
Maximum	988
Range	987
Interquartile range (IQR)	103

Descriptive statistics

Standard deviation	180.87023
Coefficient of variation (CV)	1.6081384
Kurtosis	5.9191852
Mean	112.4718
Median Absolute Deviation (MAD)	33
Skewness	2.4813525
Sum	1124718
Variance	32714.038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	364	3.6%
2	331	3.3%
3	299	3.0%
4	263	2.6%
5	250	2.5%
7	214	2.1%
6	210	2.1%
8	182	1.8%
9	169	1.7%
12	160	1.6%
Other values (808)	7558	75.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	364	3.6%
2	331	3.3%
3	299	3.0%
4	263	2.6%
5	250	2.5%
6	210	2.1%
7	214	2.1%
8	182	1.8%
9	169	1.7%
10	150	1.5%

Value	Count	Frequency (%)
988	1	< 0.1%
984	1	< 0.1%
962	1	< 0.1%
961	1	< 0.1%
957	1	< 0.1%
956	1	< 0.1%
954	1	< 0.1%
952	1	< 0.1%
950	1	< 0.1%
947	1	< 0.1%

코스번호
Text

Distinct	1375
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	4
Median length	3
Mean length	2.4794
Min length	1

Characters and Unicode

Total characters	24794
Distinct characters	24
Distinct categories	3 ?
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	612 ?
Unique (%)	6.1%

Sample

1st row	121
2nd row	D
3rd row	14
4th row	A59
5th row	5

Value	Count	Frequency (%)
1	206	2.1%
2	186	1.9%
3	175	1.8%
4	172	1.7%
5	165	1.7%
6	144	1.4%
8	143	1.4%
7	138	1.4%
14	125	1.2%
13	120	1.2%
Other values (1365)	8426	84.3%

Most occurring characters

Value	Count	Frequency (%)
1	4038	16.3%
0	3284	13.2%
2	2908	11.7%
3	2387	9.6%
4	2058	8.3%
5	1787	7.2%
6	1611	6.5%
7	1514	6.1%
8	1352	5.5%
9	1270	5.1%
Other values (14)	2585	10.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	22209	89.6%
Uppercase Letter	2576	10.4%
Other Letter	9	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	962	37.3%
B	917	35.6%
A	597	23.2%
C	71	2.8%
D	10	0.4%
E	5	0.2%
F	4	0.2%
R	4	0.2%
W	2	0.1%
G	2	0.1%
Other values (2)	2	0.1%

Decimal Number

Value	Count	Frequency (%)
1	4038	18.2%
0	3284	14.8%
2	2908	13.1%
3	2387	10.7%
4	2058	9.3%
5	1787	8.0%
6	1611	7.3%
7	1514	6.8%
8	1352	6.1%
9	1270	5.7%

Other Letter

Value	Count	Frequency (%)
보	8	88.9%
재	1	11.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	22209	89.6%
Latin	2576	10.4%
Hangul	9	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	962	37.3%
B	917	35.6%
A	597	23.2%
C	71	2.8%
D	10	0.4%
E	5	0.2%
F	4	0.2%
R	4	0.2%
W	2	0.1%
G	2	0.1%
Other values (2)	2	0.1%

Common

Value	Count	Frequency (%)
1	4038	18.2%
0	3284	14.8%
2	2908	13.1%
3	2387	10.7%
4	2058	9.3%
5	1787	8.0%
6	1611	7.3%
7	1514	6.8%
8	1352	6.1%
9	1270	5.7%

Hangul

Value	Count	Frequency (%)
보	8	88.9%
재	1	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24785	> 99.9%
Hangul	9	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4038	16.3%
0	3284	13.2%
2	2908	11.7%
3	2387	9.6%
4	2058	8.3%
5	1787	7.2%
6	1611	6.5%
7	1514	6.1%
8	1352	5.5%
9	1270	5.1%
Other values (12)	2576	10.4%

Hangul

Value	Count	Frequency (%)
보	8	88.9%
재	1	11.1%

개시시간
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	2586
Missing (%)	25.9%
Memory size	156.2 KiB

필터
Categorical

IMBALANCE

Distinct	27
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

<NA>	3987
UV	3084
auto	1623
Yellow	500
yellow	274
Other values (22)	532

Length

Max length	8
Median length	4
Mean length	3.5559
Min length	1

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	UV
2nd row	<NA>
3rd row	Yellow
4th row	<NA>
5th row	UV

Common Values

Value	Count	Frequency (%)
<NA>	3987	39.9%
UV	3084	30.8%
auto	1623	16.2%
Yellow	500	5.0%
yellow	274	2.7%
YELLOW	168	1.7%
B	55	0.5%
L.Y	55	0.5%
525NM	37	0.4%
MB	30	0.3%
Other values (17)	187	1.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	3987	39.9%
uv	3084	30.8%
auto	1671	16.7%
yellow	942	9.4%
b	66	0.7%
l.y	55	0.5%
525nm	37	0.4%
mb	30	0.3%
420nm	30	0.3%
l.yellow	24	0.2%
Other values (11)	74	0.7%

노출
Categorical

HIGH CORRELATION

Distinct	43
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

auto	3358
<NA>	2325
AUTO	1753
1/500	1022
0	473
Other values (38)	1069

Length

Max length	5
Median length	4
Mean length	3.8643
Min length	1

Unique

Unique	10 ?
Unique (%)	0.1%

Sample

1st row	1/500
2nd row	<NA>
3rd row	auto
4th row	auto
5th row	AUTO

Common Values

Value	Count	Frequency (%)
auto	3358	33.6%
<NA>	2325	23.2%
AUTO	1753	17.5%
1/500	1022	10.2%
0	473	4.7%
300	251	2.5%
350	208	2.1%
250	106	1.1%
자동	97	1.0%
400	78	0.8%
Other values (33)	329	3.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
auto	5181	51.8%
na	2325	23.3%
1/500	1022	10.2%
0	473	4.7%
300	251	2.5%
350	208	2.1%
250	106	1.1%
자동	97	1.0%
400	78	0.8%
230	65	0.7%
Other values (30)	193	1.9%

조리개
Categorical

HIGH CORRELATION

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

<NA>	5459
auto	1182
11	864
AUTO	622
0	518
Other values (17)	1355

Length

Max length	4
Median length	4
Mean length	3.3431
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	11
2nd row	<NA>
3rd row	<NA>
4th row	auto
5th row	<NA>

Common Values

Value	Count	Frequency (%)
<NA>	5459	54.6%
auto	1182	11.8%
11	864	8.6%
AUTO	622	6.2%
0	518	5.2%
8	505	5.1%
4	258	2.6%
5.6	235	2.4%
5	73	0.7%
6	71	0.7%
Other values (12)	213	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	5459	54.6%
auto	1804	18.0%
11	864	8.6%
0	518	5.2%
8	505	5.1%
4	258	2.6%
5.6	235	2.4%
5	73	0.7%
6	71	0.7%
f8	67	0.7%
Other values (11)	146	1.5%

대표필름번호
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1761
Distinct (%)	41.0%
Missing	5708
Missing (%)	57.1%
Infinite	0
Infinite (%)	0.0%
Mean	1287.7761

Minimum	0
Maximum	30221
Zeros	1665
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	129
Q3	1387
95-th percentile	7033.45
Maximum	30221
Range	30221
Interquartile range (IQR)	1387

Descriptive statistics

Standard deviation	2338.5359
Coefficient of variation (CV)	1.8159492
Kurtosis	13.461396
Mean	1287.7761
Median Absolute Deviation (MAD)	129
Skewness	2.7528467
Sum	5527135
Variance	5468750.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1665	16.7%
1	62	0.6%
2445	31	0.3%
2402	25	0.2%
7	9	0.1%
9	9	0.1%
46	8	0.1%
36	8	0.1%
45	7	0.1%
34	7	0.1%
Other values (1751)	2461	24.6%
(Missing)	5708	57.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1665	16.7%
1	62	0.6%
2	7	0.1%
3	1	< 0.1%
4	5	0.1%
5	2	< 0.1%
6	2	< 0.1%
7	9	0.1%
8	6	0.1%
9	9	0.1%

Value	Count	Frequency (%)
30221	1	< 0.1%
30033	1	< 0.1%
10103	1	< 0.1%
9981	1	< 0.1%
9969	1	< 0.1%
9932	1	< 0.1%
9922	1	< 0.1%
9883	1	< 0.1%
9872	1	< 0.1%
9850	1	< 0.1%

매수
Real number (ℝ)

MISSING SKEWED ZEROS

Distinct	168
Distinct (%)	1.8%
Missing	660
Missing (%)	6.6%
Infinite	0
Infinite (%)	0.0%
Mean	32.949786

Minimum	0
Maximum	9705
Zeros	462
Zeros (%)	4.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	21
Q3	47
95-th percentile	91
Maximum	9705
Range	9705
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	104.38716
Coefficient of variation (CV)	3.168068
Kurtosis	7894.0773
Mean	32.949786
Median Absolute Deviation (MAD)	14
Skewness	85.226013
Sum	307751
Variance	10896.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	462	4.6%
10	290	2.9%
9	286	2.9%
7	268	2.7%
18	264	2.6%
5	259	2.6%
19	246	2.5%
20	235	2.4%
8	234	2.3%
11	223	2.2%
Other values (158)	6573	65.7%
(Missing)	660	6.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	462	4.6%
1	24	0.2%
2	58	0.6%
3	174	1.7%
4	186	1.9%
5	259	2.6%
6	216	2.2%
7	268	2.7%
8	234	2.3%
9	286	2.9%

Value	Count	Frequency (%)
9705	1	< 0.1%
260	1	< 0.1%
249	1	< 0.1%
201	1	< 0.1%
193	1	< 0.1%
190	2	< 0.1%
188	1	< 0.1%
184	1	< 0.1%
181	1	< 0.1%
176	3	< 0.1%

촬영방향
Categorical

HIGH CORRELATION

Distinct	33
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

동	2787
서	2745
동	1258
서	1192
<NA>	474
Other values (28)	1544

Length

Max length	4
Median length	4
Mean length	3.6593
Min length	2

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	동
2nd row	동
3rd row	서
4th row	동서
5th row	동

Common Values

Value	Count	Frequency (%)
동	2787	27.9%
서	2745	27.5%
동	1258	12.6%
서	1192	11.9%
<NA>	474	4.7%
남	294	2.9%
북	276	2.8%
동서	147	1.5%
남	143	1.4%
서동	141	1.4%
Other values (23)	543	5.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
동	4045	40.5%
서	3937	39.4%
na	474	4.7%
남	437	4.4%
북	396	4.0%
동서	277	2.8%
서동	273	2.7%
남서	27	0.3%
북동	26	0.3%
북서	23	0.2%
Other values (8)	85	0.9%

촬영각도
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	44
Distinct (%)	0.6%
Missing	2452
Missing (%)	24.5%
Infinite	0
Infinite (%)	0.0%
Mean	101.78458

Minimum	-91
Maximum	321
Zeros	3289
Zeros (%)	32.9%
Negative	5
Negative (%)	< 0.1%
Memory size	166.0 KiB

Quantile statistics

Minimum	-91
5-th percentile	0
Q1	0
median	180
Q3	180
95-th percentile	270
Maximum	321
Range	412
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	94.632837
Coefficient of variation (CV)	0.92973649
Kurtosis	-1.6061353
Mean	101.78458
Median Absolute Deviation (MAD)	90
Skewness	0.035082061
Sum	768270
Variance	8955.3738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
180	3432	34.3%
0	3289	32.9%
270	389	3.9%
90	349	3.5%
315	10	0.1%
230	5	0.1%
320	5	0.1%
50	4	< 0.1%
140	4	< 0.1%
16	4	< 0.1%
Other values (34)	57	0.6%
(Missing)	2452	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-91	1	< 0.1%
-90	2	< 0.1%
-14	2	< 0.1%
0	3289	32.9%
14	2	< 0.1%
16	4	< 0.1%
35	3	< 0.1%
40	1	< 0.1%
43	1	< 0.1%
45	3	< 0.1%

Value	Count	Frequency (%)
321	2	< 0.1%
320	5	0.1%
315	10	0.1%
310	1	< 0.1%
290	2	< 0.1%
270	389	3.9%
263	1	< 0.1%
240	2	< 0.1%
235	2	< 0.1%
233	1	< 0.1%

최소위성수
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7
Distinct (%)	0.1%
Missing	3475
Missing (%)	34.8%
Infinite	0
Infinite (%)	0.0%
Mean	6.3612261

Minimum	0
Maximum	9
Zeros	11
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	4
median	6
Q3	8
95-th percentile	9
Maximum	9
Range	9
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9866041
Coefficient of variation (CV)	0.31229892
Kurtosis	-1.4205144
Mean	6.3612261
Median Absolute Deviation (MAD)	2
Skewness	0.036400946
Sum	41507
Variance	3.9465957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	1902	19.0%
9	1554	15.5%
7	1017	10.2%
5	832	8.3%
8	690	6.9%
6	519	5.2%
0	11	0.1%
(Missing)	3475	34.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	0.1%
4	1902	19.0%
5	832	8.3%
6	519	5.2%
7	1017	10.2%
8	690	6.9%
9	1554	15.5%

Value	Count	Frequency (%)
9	1554	15.5%
8	690	6.9%
7	1017	10.2%
6	519	5.2%
5	832	8.3%
4	1902	19.0%
0	11	0.1%

진행방향중복도_최대
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	15
Distinct (%)	0.2%
Missing	2706
Missing (%)	27.1%
Infinite	0
Infinite (%)	0.0%
Mean	46.470524

Minimum	0
Maximum	85
Zeros	484
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	70
Q3	70
95-th percentile	75
Maximum	85
Range	85
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	31.106671
Coefficient of variation (CV)	0.669385
Kurtosis	-1.7510053
Mean	46.470524
Median Absolute Deviation (MAD)	5
Skewness	-0.40820385
Sum	338956
Variance	967.62501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
10	2380	23.8%
70	2279	22.8%
75	1301	13.0%
0	484	4.8%
63	240	2.4%
80	239	2.4%
60	151	1.5%
65	95	0.9%
85	55	0.5%
73	18	0.2%
Other values (5)	52	0.5%
(Missing)	2706	27.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	484	4.8%
10	2380	23.8%
15	18	0.2%
60	151	1.5%
61	8	0.1%
62	3	< 0.1%
63	240	2.4%
64	14	0.1%
65	95	0.9%
70	2279	22.8%

Value	Count	Frequency (%)
85	55	0.5%
83	9	0.1%
80	239	2.4%
75	1301	13.0%
73	18	0.2%
70	2279	22.8%
65	95	0.9%
64	14	0.1%
63	240	2.4%
62	3	< 0.1%

진행방향중복도_최소
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	17
Distinct (%)	0.2%
Missing	2736
Missing (%)	27.4%
Infinite	0
Infinite (%)	0.0%
Mean	42.541713

Minimum	0
Maximum	80
Zeros	484
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	60
Q3	65
95-th percentile	70
Maximum	80
Range	80
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	28.130876
Coefficient of variation (CV)	0.66125396
Kurtosis	-1.7404722
Mean	42.541713
Median Absolute Deviation (MAD)	10
Skewness	-0.38662085
Sum	309023
Variance	791.34619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
10	2395	23.9%
65	1540	15.4%
70	1427	14.3%
60	763	7.6%
0	484	4.8%
61	244	2.4%
55	178	1.8%
50	98	1.0%
75	64	0.6%
80	38	0.4%
Other values (7)	33	0.3%
(Missing)	2736	27.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	484	4.8%
10	2395	23.9%
15	3	< 0.1%
50	98	1.0%
54	2	< 0.1%
55	178	1.8%
57	1	< 0.1%
58	3	< 0.1%
59	1	< 0.1%
60	763	7.6%

Value	Count	Frequency (%)
80	38	0.4%
75	64	0.6%
70	1427	14.3%
65	1540	15.4%
63	20	0.2%
62	3	< 0.1%
61	244	2.4%
60	763	7.6%
59	1	< 0.1%
58	3	< 0.1%

촬영중복도_최대
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	20
Distinct (%)	0.3%
Missing	2725
Missing (%)	27.3%
Infinite	0
Infinite (%)	0.0%
Mean	45.589553

Minimum	0
Maximum	75
Zeros	484
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	40
median	45
Q3	60
95-th percentile	70
Maximum	75
Range	75
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	15.845046
Coefficient of variation (CV)	0.34755871
Kurtosis	2.099246
Mean	45.589553
Median Absolute Deviation (MAD)	5
Skewness	-1.2245376
Sum	331664
Variance	251.06549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
40	2126	21.3%
60	1998	20.0%
45	1335	13.4%
0	484	4.8%
70	363	3.6%
50	357	3.6%
33	239	2.4%
30	115	1.1%
34	91	0.9%
55	49	0.5%
Other values (10)	118	1.2%
(Missing)	2725	27.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	484	4.8%
30	115	1.1%
31	4	< 0.1%
32	7	0.1%
33	239	2.4%
34	91	0.9%
35	22	0.2%
36	4	< 0.1%
40	2126	21.3%
43	11	0.1%

Value	Count	Frequency (%)
75	7	0.1%
70	363	3.6%
65	48	0.5%
63	9	0.1%
61	4	< 0.1%
60	1998	20.0%
55	49	0.5%
50	357	3.6%
46	2	< 0.1%
45	1335	13.4%

촬영중복도_최소
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	22
Distinct (%)	0.3%
Missing	2726
Missing (%)	27.3%
Infinite	0
Infinite (%)	0.0%
Mean	37.005224

Minimum	0
Maximum	65
Zeros	484
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	31
median	40
Q3	50
95-th percentile	50
Maximum	65
Range	65
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.845108
Coefficient of variation (CV)	0.34711608
Kurtosis	2.2786327
Mean	37.005224
Median Absolute Deviation (MAD)	10
Skewness	-1.4052128
Sum	269176
Variance	164.99681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
40	1883	18.8%
50	1847	18.5%
35	1388	13.9%
30	999	10.0%
0	484	4.8%
31	246	2.5%
10	99	1.0%
45	86	0.9%
27	85	0.9%
60	56	0.6%
Other values (12)	101	1.0%
(Missing)	2726	27.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	484	4.8%
10	99	1.0%
15	1	< 0.1%
24	1	< 0.1%
25	15	0.1%
27	85	0.9%
28	3	< 0.1%
30	999	10.0%
31	246	2.5%
32	4	< 0.1%

Value	Count	Frequency (%)
65	7	0.1%
61	4	< 0.1%
60	56	0.6%
55	48	0.5%
53	9	0.1%
50	1847	18.5%
46	2	< 0.1%
45	86	0.9%
43	5	0.1%
40	1883	18.8%

Heatmap
Table

	코스일련번호	필터	노출	조리개	대표필름번호	매수	촬영방향	촬영각도	최소위성수	진행방향중복도_최대	진행방향중복도_최소	촬영중복도_최대	촬영중복도_최소
코스일련번호	1.000	0.297	0.347	0.423	0.108	0.000	0.300	0.154	0.271	0.374	0.274	0.329	0.382
필터	0.297	1.000	0.926	0.771	0.739	0.174	0.723	0.486	0.398	0.658	0.406	0.592	0.576
노출	0.347	0.926	1.000	0.941	0.638	0.152	0.550	0.325	0.751	0.553	0.521	0.717	0.759
조리개	0.423	0.771	0.941	1.000	0.591	0.027	0.561	0.361	0.774	0.836	0.694	0.854	0.686
대표필름번호	0.108	0.739	0.638	0.591	1.000	0.107	0.400	0.092	0.432	0.199	0.352	0.217	0.691
매수	0.000	0.174	0.152	0.027	0.107	1.000	0.000	NaN	NaN	NaN	NaN	NaN	NaN
촬영방향	0.300	0.723	0.550	0.561	0.400	0.000	1.000	0.935	0.419	0.545	0.628	0.531	0.622
촬영각도	0.154	0.486	0.325	0.361	0.092	NaN	0.935	1.000	0.113	0.388	0.283	0.272	0.370
최소위성수	0.271	0.398	0.751	0.774	0.432	NaN	0.419	0.113	1.000	0.564	0.515	0.775	0.521
진행방향중복도_최대	0.374	0.658	0.553	0.836	0.199	NaN	0.545	0.388	0.564	1.000	0.887	0.940	0.969
진행방향중복도_최소	0.274	0.406	0.521	0.694	0.352	NaN	0.628	0.283	0.515	0.887	1.000	0.878	0.931
촬영중복도_최대	0.329	0.592	0.717	0.854	0.217	NaN	0.531	0.272	0.775	0.940	0.878	1.000	0.900
촬영중복도_최소	0.382	0.576	0.759	0.686	0.691	NaN	0.622	0.370	0.521	0.969	0.931	0.900	1.000

Heatmap
Table

	조리개	촬영방향	노출	필터
조리개	1.000	0.185	0.557	0.322
촬영방향	0.185	1.000	0.142	0.248
노출	0.557	0.142	1.000	0.487
필터	0.322	0.248	0.487	1.000

Heatmap
Table

	코스일련번호	대표필름번호	매수	촬영각도	최소위성수	진행방향중복도_최대	진행방향중복도_최소	촬영중복도_최대	촬영중복도_최소	필터	노출	조리개	촬영방향
코스일련번호	1.000	-0.135	0.053	-0.055	0.048	0.137	0.185	-0.014	0.016	0.112	0.126	0.170	0.110
대표필름번호	-0.135	1.000	0.089	0.049	0.793	0.174	0.126	0.291	0.223	0.474	0.359	0.364	0.184
매수	0.053	0.089	1.000	0.005	-0.012	0.394	0.397	-0.302	-0.344	0.151	0.128	0.021	0.000
촬영각도	-0.055	0.049	0.005	1.000	0.060	-0.029	-0.036	-0.064	-0.061	0.174	0.127	0.154	0.706
최소위성수	0.048	0.793	-0.012	0.060	1.000	0.026	-0.080	0.056	0.156	0.267	0.349	0.551	0.195
진행방향중복도_최대	0.137	0.174	0.394	-0.029	0.026	1.000	0.906	-0.182	-0.148	0.459	0.327	0.667	0.296
진행방향중복도_최소	0.185	0.126	0.397	-0.036	-0.080	0.906	1.000	-0.266	-0.052	0.249	0.287	0.468	0.305
촬영중복도_최대	-0.014	0.291	-0.302	-0.064	0.056	-0.182	-0.266	1.000	0.798	0.339	0.350	0.588	0.286
촬영중복도_최소	0.016	0.223	-0.344	-0.061	0.156	-0.148	-0.052	0.798	1.000	0.217	0.433	0.380	0.282
필터	0.112	0.474	0.151	0.174	0.267	0.459	0.249	0.339	0.217	1.000	0.487	0.322	0.248
노출	0.126	0.359	0.128	0.127	0.349	0.327	0.287	0.350	0.433	0.487	1.000	0.557	0.142
조리개	0.170	0.364	0.021	0.154	0.551	0.667	0.468	0.588	0.380	0.322	0.557	1.000	0.185
촬영방향	0.110	0.184	0.000	0.706	0.195	0.296	0.305	0.286	0.282	0.248	0.142	0.185	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

	사업지구코드	촬영일자	렌즈번호	코스일련번호	코스번호	개시시간	필터	노출	조리개	대표필름번호	매수	촬영방향	촬영각도	최소위성수	진행방향중복도_최대	진행방향중복도_최소	촬영중복도_최대	촬영중복도_최소
8231	201704A208N	2017-09-30	15244	121	121	1118	UV	1/500	11	<NA>	68	동	0	7	75	70	45	40
20971	196600A0001	1966-11-03	54	4	D	1246	<NA>	<NA>	<NA>	3692	35	동	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
16822	200804A0017	2008-04-24	13084	11	14	1259	Yellow	auto	<NA>	264	17	서	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
25451	201309A303C	2013-10-30	1311	9	A59	1012	<NA>	auto	auto	0	0	동서	180	4	10	10	60	50
8777	201704A511N	2017-06-18	UC-SXp-1-91514228	5	5	1116	UV	AUTO	<NA>	<NA>	48	동	0	5	70	70	40	40
60363	202102A101C	2021-05-09	DMCII230-018	197	197	934.0	<NA>	AUTO	AUTO	<NA>	85	동	0	4	10	10	70	40
34228	200711A0204	2008-03-01	3020	32	86	NaN	<NA>	<NA>	<NA>	<NA>	65	서	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
1159	201405A102C	2014-05-01	250038	142	142	1206	auto	auto	<NA>	<NA>	88	동	0	6	70	60	40	30
56378	200711A0203	2007-11-03	13230	12	11	NaN	<NA>	<NA>	<NA>	<NA>	41	서	270	<NA>	<NA>	<NA>	<NA>	<NA>
57900	202102A101D	2021-03-08	DMCII230-018	81	81	1159.0	<NA>	AUTO	AUTO	<NA>	83	동	0	4	10	10	70	40

	사업지구코드	촬영일자	렌즈번호	코스일련번호	코스번호	개시시간	필터	노출	조리개	대표필름번호	매수	촬영방향	촬영각도	최소위성수	진행방향중복도_최대	진행방향중복도_최소	촬영중복도_최대	촬영중복도_최소
66958	201911A0302	2019-12-16	15244	67	67	1027.0	UV	1/500	UV	0	59	북	90	4	75	65	45	35
53245	201804A0301	2018-04-12	UC-SXp-1-00015244	19	19	NaN	<NA>	<NA>	<NA>	<NA>	12	남	270	<NA>	75	65	45	35
68283	200611A0302	2006-12-29	1	82	64A	NaN	<NA>	<NA>	<NA>	0	5	동	0	<NA>	0	0	0	0
20496	200300A0022	2003-03-29	13230	1	1	1140	YELLOW	1350	5.6	6838	8	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
10387	201804A206N	2018-06-01	1133	204	B004	1045	<NA>	auto	auto	0	0	동	0	4	10	10	60	50
24324	200908A0036	2009-09-20	30117	44	N045	1232	yellow	auto	<NA>	640	23	남	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
72712	202103A454D	2021-09-12	27566	13	22	1206.0	auto	auto	<NA>	<NA>	57	서	180	9	70	65	40	35
32159	201009A103C	2010-09-18	001-102	33	35	1155	auto	auto	<NA>	<NA>	52	동	0	7	83	75	63	53
44759	196902A0556	1969-02-09	0	1	1	0.0	<NA>	<NA>	<NA>	<NA>	133	서동	<NA>	<NA>	60	50	30	10
77080	202103A506C	2021-04-05	DMC01-102	206	206	1052.0	<NA>	AUTO	<NA>	<NA>	95	서	180	5	63	61	33	31

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

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

Lowercase Letter

Dash Punctuation

Connector Punctuation

Space Separator

Other Punctuation

Letter Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Number Forms

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Hangul

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Common Values

Length

Common Values

Length

Common Values

Length

Common Values

Length

Interactions

Correlations

Missing values

Sample