gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	653
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.6 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=CT06OCN001

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:53:52.793182
Analysis finished	2024-03-13 12:53:59.425841
Duration	6.63 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

SPOT_LO
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	653
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.32051

Minimum	129.32038
Maximum	129.32063
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	129.32038
5-th percentile	129.32042
Q1	129.32046
median	129.3205
Q3	129.32055
95-th percentile	129.3206
Maximum	129.32063
Range	0.0002576866
Interquartile range (IQR)	9.00619 × 10^-5

Descriptive statistics

Standard deviation	5.7154686 × 10^-5
Coefficient of variation (CV)	4.4196151 × 10^-7
Kurtosis	-0.82099787
Mean	129.32051
Median Absolute Deviation (MAD)	4.48401 × 10^-5
Skewness	0.070397478
Sum	84446.29
Variance	3.2666581 × 10^-9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.3204210284	1	0.2%
129.3205549753	1	0.2%
129.3205324598	1	0.2%
129.3205437367	1	0.2%
129.3205550136	1	0.2%
129.3205662904	1	0.2%
129.3205775673	1	0.2%
129.3205888441	1	0.2%
129.320600121	1	0.2%
129.3206113979	1	0.2%
Other values (643)	643	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
129.3203758062	1	0.2%
129.3203758444	1	0.2%
129.3203869685	1	0.2%
129.3203870067	1	0.2%
129.3203870449	1	0.2%
129.3203870831	1	0.2%
129.3203871213	1	0.2%
129.3203966409	1	0.2%
129.3203981308	1	0.2%
129.320398169	1	0.2%

Value	Count	Frequency (%)
129.3206334928	1	0.2%
129.3206229806	1	0.2%
129.3206229423	1	0.2%
129.3206229041	1	0.2%
129.3206226747	1	0.2%
129.3206226365	1	0.2%
129.3206225983	1	0.2%
129.3206222924	1	0.2%
129.3206222542	1	0.2%
129.320622216	1	0.2%

SPOT_LA
Real number (ℝ)

UNIQUE

Distinct	653
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.287278

Minimum	37.28709
Maximum	37.287523
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	37.28709
5-th percentile	37.287099
Q1	37.287172
median	37.287271
Q3	37.287379
95-th percentile	37.287478
Maximum	37.287523
Range	0.0004329497
Interquartile range (IQR)	0.000207144

Descriptive statistics

Standard deviation	0.00012176765
Coefficient of variation (CV)	3.2656621 × 10^-6
Kurtosis	-1.0994778
Mean	37.287278
Median Absolute Deviation (MAD)	9.92653 × 10^-5
Skewness	0.18622588
Sum	24348.593
Variance	1.4827361 × 10^-8
Monotonicity	Strictly decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.2875231083	1	0.2%
37.2871983731	1	0.2%
37.2872074445	1	0.2%
37.2872074139	1	0.2%
37.2872073834	1	0.2%
37.2872073528	1	0.2%
37.2872073223	1	0.2%
37.2872072918	1	0.2%
37.2872072612	1	0.2%
37.2872072307	1	0.2%
Other values (643)	643	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37.2870901586	1	0.2%
37.2870901891	1	0.2%
37.2870902197	1	0.2%
37.2870902502	1	0.2%
37.2870902807	1	0.2%
37.2870903113	1	0.2%
37.2870903418	1	0.2%
37.2870903723	1	0.2%
37.2870904029	1	0.2%
37.2870904334	1	0.2%

Value	Count	Frequency (%)
37.2875231083	1	0.2%
37.2875230778	1	0.2%
37.2875230473	1	0.2%
37.2875141592	1	0.2%
37.2875141286	1	0.2%
37.2875140981	1	0.2%
37.2875140676	1	0.2%
37.287514037	1	0.2%
37.28750521	1	0.2%
37.2875051794	1	0.2%

SPOT_AL
Real number (ℝ)

HIGH CORRELATION

Distinct	637
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2543323

Minimum	-3.439
Maximum	17.186
Zeros	1
Zeros (%)	0.2%
Negative	77
Negative (%)	11.8%
Memory size	5.9 KiB

Quantile statistics

Minimum	-3.439
5-th percentile	-0.529
Q1	0.634
median	3.055
Q3	6.854
95-th percentile	13.1988
Maximum	17.186
Range	20.625
Interquartile range (IQR)	6.22

Descriptive statistics

Standard deviation	4.3781706
Coefficient of variation (CV)	1.0291087
Kurtosis	-0.19094792
Mean	4.2543323
Median Absolute Deviation (MAD)	2.713
Skewness	0.86656075
Sum	2778.079
Variance	19.168378
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.121	2	0.3%
2.404	2	0.3%
1.211	2	0.3%
1.219	2	0.3%
-0.895	2	0.3%
-0.118	2	0.3%
0.559	2	0.3%
1.059	2	0.3%
0.341	2	0.3%
1.008	2	0.3%
Other values (627)	633	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.439	1	0.2%
-2.877	1	0.2%
-2.061	1	0.2%
-1.707	1	0.2%
-1.397	1	0.2%
-1.216	1	0.2%
-1.15	1	0.2%
-1.108	1	0.2%
-1.107	1	0.2%
-1.075	1	0.2%

Value	Count	Frequency (%)
17.186	1	0.2%
16.593	1	0.2%
16.217	1	0.2%
16.131	1	0.2%
16.054	1	0.2%
15.897	1	0.2%
15.588	1	0.2%
15.313	1	0.2%
15.197	1	0.2%
15.084	1	0.2%

GRDNT_RT
Real number (ℝ)

HIGH CORRELATION

Distinct	646
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	123.47222

Minimum	7.09
Maximum	711.31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	7.09
5-th percentile	25.94
Q1	65.48
median	105.06
Q3	159.31
95-th percentile	268.144
Maximum	711.31
Range	704.22
Interquartile range (IQR)	93.83

Descriptive statistics

Standard deviation	89.642819
Coefficient of variation (CV)	0.72601609
Kurtosis	11.098696
Mean	123.47222
Median Absolute Deviation (MAD)	44.3
Skewness	2.5255497
Sum	80627.36
Variance	8035.835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
106.24	2	0.3%
30.35	2	0.3%
91.17	2	0.3%
99.35	2	0.3%
79.31	2	0.3%
67.57	2	0.3%
119.13	2	0.3%
72.46	1	0.2%
108.39	1	0.2%
120.79	1	0.2%
Other values (636)	636	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.09	1	0.2%
7.33	1	0.2%
8.21	1	0.2%
8.92	1	0.2%
9.14	1	0.2%
10.01	1	0.2%
10.79	1	0.2%
10.82	1	0.2%
12.67	1	0.2%
12.78	1	0.2%

Value	Count	Frequency (%)
711.31	1	0.2%
705.77	1	0.2%
692.15	1	0.2%
644.06	1	0.2%
576.1	1	0.2%
559.22	1	0.2%
490.16	1	0.2%
424.82	1	0.2%
423.5	1	0.2%
420.14	1	0.2%

GRDNT_VAL
Real number (ℝ)

HIGH CORRELATION

Distinct	624
Distinct (%)	95.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.940582

Minimum	4.06
Maximum	82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	4.06
5-th percentile	14.544
Q1	33.22
median	46.41
Q3	57.88
95-th percentile	69.546
Maximum	82
Range	77.94
Interquartile range (IQR)	24.66

Descriptive statistics

Standard deviation	16.732188
Coefficient of variation (CV)	0.37231802
Kurtosis	-0.49461853
Mean	44.940582
Median Absolute Deviation (MAD)	12.27
Skewness	-0.28924205
Sum	29346.2
Variance	279.96613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49.99	3	0.5%
57.09	2	0.3%
46.6	2	0.3%
65.56	2	0.3%
16.88	2	0.3%
66.55	2	0.3%
51.44	2	0.3%
42.36	2	0.3%
46.73	2	0.3%
38.42	2	0.3%
Other values (614)	632	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.06	1	0.2%
4.19	1	0.2%
4.7	1	0.2%
5.1	1	0.2%
5.22	1	0.2%
5.72	1	0.2%
6.16	1	0.2%
6.17	1	0.2%
7.22	1	0.2%
7.28	1	0.2%

Value	Count	Frequency (%)
82.0	1	0.2%
81.94	1	0.2%
81.78	1	0.2%
81.17	1	0.2%
80.15	1	0.2%
79.86	1	0.2%
78.47	1	0.2%
76.75	1	0.2%
76.71	1	0.2%
76.61	1	0.2%

SLANT_DRC
Real number (ℝ)

Distinct	640
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.88643

Minimum	1.07
Maximum	359.68
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.9 KiB

Quantile statistics

Minimum	1.07
5-th percentile	25.728
Q1	64.25
median	88.58
Q3	138.7
95-th percentile	244.82
Maximum	359.68
Range	358.61
Interquartile range (IQR)	74.45

Descriptive statistics

Standard deviation	71.661374
Coefficient of variation (CV)	0.65812951
Kurtosis	2.8322758
Mean	108.88643
Median Absolute Deviation (MAD)	30.5
Skewness	1.5859705
Sum	71102.84
Variance	5135.3525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
84.61	2	0.3%
74.64	2	0.3%
62.49	2	0.3%
64.13	2	0.3%
53.79	2	0.3%
80.01	2	0.3%
58.74	2	0.3%
70.76	2	0.3%
87.64	2	0.3%
38.39	2	0.3%
Other values (630)	633	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.07	1	0.2%
1.9	1	0.2%
4.48	1	0.2%
4.67	1	0.2%
7.37	1	0.2%
8.31	1	0.2%
8.63	1	0.2%
8.79	1	0.2%
8.99	1	0.2%
9.94	1	0.2%

Value	Count	Frequency (%)
359.68	1	0.2%
358.18	1	0.2%
358.13	1	0.2%
357.41	1	0.2%
356.78	1	0.2%
356.28	1	0.2%
356.23	1	0.2%
354.88	1	0.2%
354.59	1	0.2%
354.12	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.594	0.685	0.410	0.325	0.242
SPOT_LA	0.594	1.000	0.542	0.407	0.450	0.516
SPOT_AL	0.685	0.542	1.000	0.000	0.076	0.312
GRDNT_RT	0.410	0.407	0.000	1.000	0.940	0.475
GRDNT_VAL	0.325	0.450	0.076	0.940	1.000	0.540
SLANT_DRC	0.242	0.516	0.312	0.475	0.540	1.000

Heatmap
Table

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
SPOT_LO	1.000	-0.357	-0.550	0.020	0.020	0.075
SPOT_LA	-0.357	1.000	-0.400	-0.170	-0.170	-0.208
SPOT_AL	-0.550	-0.400	1.000	0.090	0.090	0.081
GRDNT_RT	0.020	-0.170	0.090	1.000	1.000	-0.154
GRDNT_VAL	0.020	-0.170	0.090	1.000	1.000	-0.154
SLANT_DRC	0.075	-0.208	0.081	-0.154	-0.154	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	129.320421	37.287523	1.128	72.46	35.93	87.06
1	129.320432	37.287523	-0.018	59.73	30.85	89.54
2	129.320444	37.287523	-0.052	66.96	33.8	99.5
3	129.320398	37.287514	2.101	75.09	36.9	102.22
4	129.32041	37.287514	1.652	190.43	62.3	45.22
5	129.320421	37.287514	1.147	116.81	49.43	33.94
6	129.320432	37.287514	0.566	126.42	51.65	25.94
7	129.320444	37.287514	-0.477	145.91	55.58	34.16
8	129.320376	37.287505	5.466	111.68	48.16	48.26
9	129.320387	37.287505	3.305	576.1	80.15	27.88

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
643	129.320487	37.28709	11.763	130.22	52.48	75.22
644	129.320498	37.28709	10.839	137.97	54.07	77.03
645	129.320509	37.28709	9.777	140.71	54.6	70.76
646	129.320521	37.28709	8.844	121.09	50.45	58.38
647	129.320532	37.28709	7.722	139.11	54.29	82.7
648	129.320543	37.28709	6.558	129.39	52.3	83.95
649	129.320555	37.28709	5.451	111.3	48.06	74.6
650	129.320566	37.28709	4.703	103.08	45.87	59.53
651	129.320577	37.28709	4.215	144.87	55.38	84.66
652	129.320588	37.28709	3.701	148.63	56.07	86.54

Overview

Variables

Interactions

Correlations

Missing values

Sample