gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	530
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	28.1 KiB
Average record size in memory	54.2 B

Variable types

Numeric	6

Dataset

Description	Sample
Author	㈜오셔닉
URL	https://www.bigdata-coast.kr/gdsInfo/gdsInfoDetail.do?gdsCd=CT06OCN002

Alerts

`SPOT_LO` is highly overall correlated with `SPOT_AL`	High correlation
`SPOT_AL` is highly overall correlated with `SPOT_LO`	High correlation
`GRDNT_RT` is highly overall correlated with `GRDNT_VAL`	High correlation
`GRDNT_VAL` is highly overall correlated with `GRDNT_RT`	High correlation
`SPOT_LO` has unique values	Unique
`SPOT_LA` has unique values	Unique

Reproduction

Analysis started	2024-03-13 12:28:11.897709
Analysis finished	2024-03-13 12:28:21.920577
Duration	10.02 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

SPOT_LO
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	530
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.61401

Minimum	126.6139
Maximum	126.61421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	126.6139
5-th percentile	126.61391
Q1	126.61394
median	126.61399
Q3	126.61406
95-th percentile	126.61416
Maximum	126.61421
Range	0.0003152744
Interquartile range (IQR)	0.00011935942

Descriptive statistics

Standard deviation	7.9467089 × 10^-5
Coefficient of variation (CV)	6.2763269 × 10^-7
Kurtosis	-0.5187771
Mean	126.61401
Median Absolute Deviation (MAD)	5.742125 × 10^-5
Skewness	0.64162518
Sum	67105.423
Variance	6.3150182 × 10^-9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126.6138966777	1	0.2%
126.6141466456	1	0.2%
126.6139169882	1	0.2%
126.6139147366	1	0.2%
126.613912485	1	0.2%
126.6139102333	1	0.2%
126.6139079817	1	0.2%
126.6139057301	1	0.2%
126.6139034785	1	0.2%
126.6139012268	1	0.2%
Other values (520)	520	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
126.6138966777	1	0.2%
126.6138966869	1	0.2%
126.6138966961	1	0.2%
126.6138967052	1	0.2%
126.6138989294	1	0.2%
126.6138989385	1	0.2%
126.6138989477	1	0.2%
126.6138989569	1	0.2%
126.613898966	1	0.2%
126.6138989752	1	0.2%

Value	Count	Frequency (%)
126.6142119521	1	0.2%
126.6142097005	1	0.2%
126.6142074488	1	0.2%
126.6142051972	1	0.2%
126.6142029456	1	0.2%
126.6142006939	1	0.2%
126.6141984423	1	0.2%
126.6141961907	1	0.2%
126.614193939	1	0.2%
126.6141916874	1	0.2%

SPOT_LA
Real number (ℝ)

UNIQUE

Distinct	530
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.162047

Minimum	37.162043
Maximum	37.162053
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	37.162043
5-th percentile	37.162043
Q1	37.162045
median	37.162047
Q3	37.16205
95-th percentile	37.162052
Maximum	37.162053
Range	1.09739 × 10^-5
Interquartile range (IQR)	4.779225 × 10^-6

Descriptive statistics

Standard deviation	2.8019878 × 10^-6
Coefficient of variation (CV)	7.5399177 × 10^-8
Kurtosis	-0.65482344
Mean	37.162047
Median Absolute Deviation (MAD)	1.84605 × 10^-6
Skewness	0
Sum	19695.885
Variance	7.8511356 × 10^-12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.1620533233	1	0.2%
37.1620469291	1	0.2%
37.162044379	1	0.2%
37.1620443717	1	0.2%
37.1620443643	1	0.2%
37.162044357	1	0.2%
37.1620443497	1	0.2%
37.1620443423	1	0.2%
37.162044335	1	0.2%
37.1620443276	1	0.2%
Other values (520)	520	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37.1620425182	1	0.2%
37.1620425256	1	0.2%
37.1620425329	1	0.2%
37.1620425402	1	0.2%
37.1620425476	1	0.2%
37.1620425549	1	0.2%
37.1620425622	1	0.2%
37.1620425696	1	0.2%
37.1620425769	1	0.2%
37.1620425843	1	0.2%

Value	Count	Frequency (%)
37.1620534921	1	0.2%
37.1620534847	1	0.2%
37.1620534774	1	0.2%
37.1620534701	1	0.2%
37.1620534627	1	0.2%
37.1620534554	1	0.2%
37.162053448	1	0.2%
37.1620534407	1	0.2%
37.1620534334	1	0.2%
37.162053426	1	0.2%

SPOT_AL
Real number (ℝ)

HIGH CORRELATION

Distinct	177
Distinct (%)	33.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-2.1550057

Minimum	-2.264
Maximum	-1.984
Zeros	0
Zeros (%)	0.0%
Negative	530
Negative (%)	100.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	-2.264
5-th percentile	-2.233
Q1	-2.19475
median	-2.153
Q3	-2.125
95-th percentile	-2.075
Maximum	-1.984
Range	0.28
Interquartile range (IQR)	0.06975

Descriptive statistics

Standard deviation	0.053049839
Coefficient of variation (CV)	-0.02461703
Kurtosis	0.19024039
Mean	-2.1550057
Median Absolute Deviation (MAD)	0.0335
Skewness	0.37930972
Sum	-1142.153
Variance	0.0028142854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-2.23	12	2.3%
-2.153	11	2.1%
-2.155	10	1.9%
-2.152	10	1.9%
-2.124	8	1.5%
-2.079	8	1.5%
-2.133	8	1.5%
-2.154	7	1.3%
-2.174	7	1.3%
-2.126	7	1.3%
Other values (167)	442	83.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2.264	1	0.2%
-2.263	1	0.2%
-2.259	2	0.4%
-2.254	2	0.4%
-2.251	3	0.6%
-2.25	1	0.2%
-2.246	2	0.4%
-2.243	1	0.2%
-2.24	2	0.4%
-2.238	2	0.4%

Value	Count	Frequency (%)
-1.984	1	0.2%
-1.985	1	0.2%
-1.986	1	0.2%
-1.99	1	0.2%
-1.992	1	0.2%
-1.997	1	0.2%
-2.003	1	0.2%
-2.005	1	0.2%
-2.009	1	0.2%
-2.014	1	0.2%

GRDNT_RT
Real number (ℝ)

HIGH CORRELATION

Distinct	423
Distinct (%)	79.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5643774

Minimum	0.09
Maximum	23.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	0.09
5-th percentile	0.828
Q1	2.0525
median	3.77
Q3	5.875
95-th percentile	11.8555
Maximum	23.1
Range	23.01
Interquartile range (IQR)	3.8225

Descriptive statistics

Standard deviation	3.6758264
Coefficient of variation (CV)	0.8053292
Kurtosis	5.3035806
Mean	4.5643774
Median Absolute Deviation (MAD)	1.795
Skewness	2.0283625
Sum	2419.12
Variance	13.5117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.02	4	0.8%
5.02	4	0.8%
0.98	4	0.8%
2.36	3	0.6%
4.18	3	0.6%
3.97	3	0.6%
3.83	3	0.6%
2.38	3	0.6%
1.98	3	0.6%
4.44	3	0.6%
Other values (413)	497	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.09	1	0.2%
0.17	1	0.2%
0.21	1	0.2%
0.26	1	0.2%
0.28	1	0.2%
0.35	1	0.2%
0.45	1	0.2%
0.47	2	0.4%
0.53	1	0.2%
0.58	1	0.2%

Value	Count	Frequency (%)
23.1	1	0.2%
22.32	1	0.2%
20.69	1	0.2%
20.02	1	0.2%
19.8	1	0.2%
18.23	1	0.2%
18.04	1	0.2%
17.81	1	0.2%
17.47	1	0.2%
17.1	1	0.2%

GRDNT_VAL
Real number (ℝ)

HIGH CORRELATION

Distinct	353
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6080755

Minimum	0.05
Maximum	13.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	0.05
5-th percentile	0.4745
Q1	1.18
median	2.16
Q3	3.3575
95-th percentile	6.76
Maximum	13.01
Range	12.96
Interquartile range (IQR)	2.1775

Descriptive statistics

Standard deviation	2.0872224
Coefficient of variation (CV)	0.80029217
Kurtosis	5.1238973
Mean	2.6080755
Median Absolute Deviation (MAD)	1.03
Skewness	1.9966343
Sum	1382.28
Variance	4.3564972
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.75	5	0.9%
1.16	5	0.9%
1.14	5	0.9%
2.27	4	0.8%
1.73	4	0.8%
1.51	4	0.8%
1.36	4	0.8%
0.56	4	0.8%
3.56	4	0.8%
3.6	3	0.6%
Other values (343)	488	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05	1	0.2%
0.1	1	0.2%
0.12	1	0.2%
0.15	1	0.2%
0.16	1	0.2%
0.2	1	0.2%
0.26	1	0.2%
0.27	2	0.4%
0.3	1	0.2%
0.33	1	0.2%

Value	Count	Frequency (%)
13.01	1	0.2%
12.58	1	0.2%
11.69	1	0.2%
11.32	1	0.2%
11.2	1	0.2%
10.33	1	0.2%
10.23	1	0.2%
10.1	1	0.2%
9.91	1	0.2%
9.71	1	0.2%

SLANT_DRC
Real number (ℝ)

Distinct	528
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	185.35664

Minimum	0.1
Maximum	359.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.8 KiB

Quantile statistics

Minimum	0.1
5-th percentile	15.134
Q1	64.22
median	197.12
Q3	298.2175
95-th percentile	346.72
Maximum	359.61
Range	359.51
Interquartile range (IQR)	233.9975

Descriptive statistics

Standard deviation	118.53903
Coefficient of variation (CV)	0.63951863
Kurtosis	-1.5143254
Mean	185.35664
Median Absolute Deviation (MAD)	114.48
Skewness	-0.12117027
Sum	98239.02
Variance	14051.501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
338.81	2	0.4%
292.06	2	0.4%
215.23	1	0.2%
163.3	1	0.2%
213.24	1	0.2%
215.22	1	0.2%
201.44	1	0.2%
181.67	1	0.2%
166.92	1	0.2%
171.56	1	0.2%
Other values (518)	518	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	1	0.2%
0.25	1	0.2%
1.37	1	0.2%
1.64	1	0.2%
1.89	1	0.2%
3.2	1	0.2%
3.46	1	0.2%
3.73	1	0.2%
3.9	1	0.2%
5.3	1	0.2%

Value	Count	Frequency (%)
359.61	1	0.2%
358.15	1	0.2%
357.95	1	0.2%
357.92	1	0.2%
357.29	1	0.2%
357.05	1	0.2%
356.83	1	0.2%
356.53	1	0.2%
355.9	1	0.2%
355.74	1	0.2%

Phik (φk)
Auto

Heatmap
Table

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
SPOT_LO	1.000	0.737	0.910	0.437	0.435	0.615
SPOT_LA	0.737	1.000	0.686	0.251	0.246	0.424
SPOT_AL	0.910	0.686	1.000	0.311	0.328	0.420
GRDNT_RT	0.437	0.251	0.311	1.000	0.999	0.307
GRDNT_VAL	0.435	0.246	0.328	0.999	1.000	0.281
SLANT_DRC	0.615	0.424	0.420	0.307	0.281	1.000

Heatmap
Table

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
SPOT_LO	1.000	-0.133	0.774	-0.270	-0.270	0.035
SPOT_LA	-0.133	1.000	-0.252	-0.018	-0.018	0.030
SPOT_AL	0.774	-0.252	1.000	-0.249	-0.249	-0.027
GRDNT_RT	-0.270	-0.018	-0.249	1.000	1.000	0.077
GRDNT_VAL	-0.270	-0.018	-0.249	1.000	1.000	0.077
SLANT_DRC	0.035	0.030	-0.027	0.077	0.077	1.000

Count
Matrix

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.

First rows
Last rows

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
0	126.613897	37.162053	-2.209	3.78	2.17	215.23
1	126.613899	37.162053	-2.201	3.69	2.12	183.74
2	126.613901	37.162053	-2.198	5.03	2.88	136.89
3	126.613903	37.162053	-2.198	6.58	3.77	111.39
4	126.613906	37.162053	-2.212	5.84	3.34	84.65
5	126.613908	37.162053	-2.23	6.23	3.56	54.81
6	126.61391	37.162053	-2.25	5.96	3.41	37.67
7	126.613912	37.162053	-2.259	4.63	2.65	13.05
8	126.613915	37.162053	-2.264	4.48	2.57	348.06
9	126.613917	37.162053	-2.263	5.26	3.01	326.55

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
520	126.613955	37.162043	-2.07	4.3	2.46	356.83
521	126.613958	37.162043	-2.077	5.34	3.06	47.57
522	126.61396	37.162043	-2.093	7.57	4.33	69.85
523	126.613962	37.162043	-2.112	4.28	2.45	68.17
524	126.613964	37.162043	-2.121	1.14	0.65	25.74
525	126.613967	37.162043	-2.123	0.96	0.55	349.28
526	126.613969	37.162043	-2.124	1.91	1.1	309.23
527	126.613971	37.162043	-2.125	3.83	2.19	293.39
528	126.613973	37.162043	-2.127	5.09	2.91	286.09
529	126.613976	37.162043	-2.13	5.08	2.91	284.51

Overview

Variables

Interactions

Correlations

Missing values

Sample