gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	438
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	23.2 KiB
Average record size in memory	54.3 B

Variable types

Numeric	6

Dataset

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

Alerts

`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:47:35.204832
Analysis finished	2024-03-13 12:47:41.298841
Duration	6.09 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

SPOT_LO
Real number (ℝ)

UNIQUE

Distinct	438
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.12092

Minimum	129.12086
Maximum	129.12095
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	129.12086
5-th percentile	129.12088
Q1	129.1209
median	129.12092
Q3	129.12093
95-th percentile	129.12095
Maximum	129.12095
Range	9.21841 × 10^-5
Interquartile range (IQR)	3.2922875 × 10^-5

Descriptive statistics

Standard deviation	2.1955777 × 10^-5
Coefficient of variation (CV)	1.7004044 × 10^-7
Kurtosis	-0.7046295
Mean	129.12092
Median Absolute Deviation (MAD)	1.53929 × 10^-5
Skewness	-0.32343643
Sum	56554.961
Variance	4.8205615 × 10^-10
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.1209224065	1	0.2%
129.1208784863	1	0.2%
129.1209026248	1	0.2%
129.1209004304	1	0.2%
129.120898236	1	0.2%
129.1208960416	1	0.2%
129.1208938472	1	0.2%
129.1208916527	1	0.2%
129.1208894583	1	0.2%
129.1208872639	1	0.2%
Other values (428)	428	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
129.1208609229	1	0.2%
129.1208631174	1	0.2%
129.12086312	1	0.2%
129.1208653118	1	0.2%
129.1208653144	1	0.2%
129.1208675062	1	0.2%
129.1208675089	1	0.2%
129.1208675115	1	0.2%
129.1208697006	1	0.2%
129.1208697033	1	0.2%

Value	Count	Frequency (%)
129.120953107	1	0.2%
129.1209531044	1	0.2%
129.1209531017	1	0.2%
129.120953099	1	0.2%
129.1209530964	1	0.2%
129.1209530937	1	0.2%
129.120953091	1	0.2%
129.1209509153	1	0.2%
129.1209509126	1	0.2%
129.1209509099	1	0.2%

SPOT_LA
Real number (ℝ)

UNIQUE

Distinct	438
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.132959

Minimum	35.132948
Maximum	35.132975
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	35.132948
5-th percentile	35.132948
Q1	35.132952
median	35.132957
Q3	35.132965
95-th percentile	35.132972
Maximum	35.132975
Range	2.70474 × 10^-5
Interquartile range (IQR)	1.2569825 × 10^-5

Descriptive statistics

Standard deviation	7.3460582 × 10^-6
Coefficient of variation (CV)	2.0909307 × 10^-7
Kurtosis	-0.87113234
Mean	35.132959
Median Absolute Deviation (MAD)	5.4213 × 10^-6
Skewness	0.38795185
Sum	15388.236
Variance	5.396457 × 10^-11
Monotonicity	Strictly decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.1329753598	1	0.2%
35.1329537709	1	0.2%
35.1329537468	1	0.2%
35.132953749	1	0.2%
35.1329537512	1	0.2%
35.1329537534	1	0.2%
35.1329537556	1	0.2%
35.1329537577	1	0.2%
35.1329537599	1	0.2%
35.1329537621	1	0.2%
Other values (428)	428	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35.1329483124	1	0.2%
35.1329483145	1	0.2%
35.1329483167	1	0.2%
35.1329483189	1	0.2%
35.1329483211	1	0.2%
35.1329483233	1	0.2%
35.1329483255	1	0.2%
35.1329483277	1	0.2%
35.1329483299	1	0.2%
35.1329483321	1	0.2%

Value	Count	Frequency (%)
35.1329753598	1	0.2%
35.1329753576	1	0.2%
35.1329753554	1	0.2%
35.1329753532	1	0.2%
35.132975351	1	0.2%
35.1329753488	1	0.2%
35.1329735658	1	0.2%
35.1329735636	1	0.2%
35.1329735614	1	0.2%
35.1329735592	1	0.2%

SPOT_AL
Real number (ℝ)

Distinct	356
Distinct (%)	81.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.046130137

Minimum	-0.681
Maximum	2.351
Zeros	0
Zeros (%)	0.0%
Negative	208
Negative (%)	47.5%
Memory size	4.0 KiB

Quantile statistics

Minimum	-0.681
5-th percentile	-0.46145
Q1	-0.2455
median	0.0215
Q3	0.314
95-th percentile	0.62045
Maximum	2.351
Range	3.032
Interquartile range (IQR)	0.5595

Descriptive statistics

Standard deviation	0.37384451
Coefficient of variation (CV)	8.1041274
Kurtosis	5.1547323
Mean	0.046130137
Median Absolute Deviation (MAD)	0.284
Skewness	1.1291184
Sum	20.205
Variance	0.13975972
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.015	4	0.9%
0.239	3	0.7%
0.155	3	0.7%
0.076	3	0.7%
0.33	3	0.7%
0.083	3	0.7%
-0.163	3	0.7%
-0.42	3	0.7%
0.526	2	0.5%
0.182	2	0.5%
Other values (346)	409	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.681	1	0.2%
-0.66	1	0.2%
-0.636	1	0.2%
-0.631	1	0.2%
-0.629	1	0.2%
-0.596	1	0.2%
-0.58	1	0.2%
-0.577	1	0.2%
-0.571	1	0.2%
-0.567	2	0.5%

Value	Count	Frequency (%)
2.351	1	0.2%
2.297	1	0.2%
1.428	1	0.2%
0.711	1	0.2%
0.71	1	0.2%
0.709	2	0.5%
0.707	1	0.2%
0.704	1	0.2%
0.698	1	0.2%
0.69	1	0.2%

GRDNT_RT
Real number (ℝ)

HIGH CORRELATION

Distinct	431
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.402146

Minimum	2.07
Maximum	290.71
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	2.07
5-th percentile	8.076
Q1	21.1825
median	40.25
Q3	60.1675
95-th percentile	119.8605
Maximum	290.71
Range	288.64
Interquartile range (IQR)	38.985

Descriptive statistics

Standard deviation	34.422805
Coefficient of variation (CV)	0.74183648
Kurtosis	6.6235912
Mean	46.402146
Median Absolute Deviation (MAD)	19.26
Skewness	1.8548165
Sum	20324.14
Variance	1184.9295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.96	2	0.5%
17.21	2	0.5%
54.03	2	0.5%
53.35	2	0.5%
25.1	2	0.5%
53.72	2	0.5%
20.32	2	0.5%
55.31	1	0.2%
11.04	1	0.2%
6.15	1	0.2%
Other values (421)	421	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.07	1	0.2%
4.43	1	0.2%
4.54	1	0.2%
4.79	1	0.2%
4.83	1	0.2%
4.86	1	0.2%
5.3	1	0.2%
6.02	1	0.2%
6.13	1	0.2%
6.15	1	0.2%

Value	Count	Frequency (%)
290.71	1	0.2%
195.05	1	0.2%
154.96	1	0.2%
150.23	1	0.2%
148.89	1	0.2%
142.83	1	0.2%
141.22	1	0.2%
140.92	1	0.2%
140.36	1	0.2%
140.23	1	0.2%

GRDNT_VAL
Real number (ℝ)

HIGH CORRELATION

Distinct	419
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.996598

Minimum	1.19
Maximum	71.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	1.19
5-th percentile	4.6165
Q1	11.96
median	21.925
Q3	31.035
95-th percentile	50.163
Maximum	71.02
Range	69.83
Interquartile range (IQR)	19.075

Descriptive statistics

Standard deviation	13.455664
Coefficient of variation (CV)	0.58511541
Kurtosis	-0.093713557
Mean	22.996598
Median Absolute Deviation (MAD)	9.625
Skewness	0.6334376
Sum	10072.51
Variance	181.05489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28.24	3	0.7%
28.38	3	0.7%
40.02	2	0.5%
14.09	2	0.5%
11.49	2	0.5%
6.42	2	0.5%
19.9	2	0.5%
9.84	2	0.5%
26.13	2	0.5%
28.95	2	0.5%
Other values (409)	416	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.19	1	0.2%
2.54	1	0.2%
2.6	1	0.2%
2.74	1	0.2%
2.76	1	0.2%
2.78	1	0.2%
3.03	1	0.2%
3.44	1	0.2%
3.51	1	0.2%
3.52	1	0.2%

Value	Count	Frequency (%)
71.02	1	0.2%
62.86	1	0.2%
57.16	1	0.2%
56.35	1	0.2%
56.11	1	0.2%
55.0	1	0.2%
54.7	1	0.2%
54.64	1	0.2%
54.53	1	0.2%
54.51	1	0.2%

SLANT_DRC
Real number (ℝ)

Distinct	434
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	176.51756

Minimum	0.53
Maximum	358.16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0.53
5-th percentile	16.098
Q1	79.1475
median	117.965
Q3	319.4925
95-th percentile	349.2395
Maximum	358.16
Range	357.63
Interquartile range (IQR)	240.345

Descriptive statistics

Standard deviation	122.6396
Coefficient of variation (CV)	0.69477282
Kurtosis	-1.5675312
Mean	176.51756
Median Absolute Deviation (MAD)	87.76
Skewness	0.28425607
Sum	77314.69
Variance	15040.472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
87.32	2	0.5%
338.34	2	0.5%
344.38	2	0.5%
126.63	2	0.5%
106.76	1	0.2%
82.18	1	0.2%
100.81	1	0.2%
109.85	1	0.2%
96.77	1	0.2%
353.05	1	0.2%
Other values (424)	424	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.53	1	0.2%
1.16	1	0.2%
1.19	1	0.2%
1.3	1	0.2%
1.37	1	0.2%
2.45	1	0.2%
2.59	1	0.2%
2.62	1	0.2%
4.14	1	0.2%
5.37	1	0.2%

Value	Count	Frequency (%)
358.16	1	0.2%
356.88	1	0.2%
356.75	1	0.2%
356.63	1	0.2%
356.04	1	0.2%
355.14	1	0.2%
354.77	1	0.2%
354.43	1	0.2%
354.37	1	0.2%
354.19	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.459	0.668	0.366	0.498	0.650
SPOT_LA	0.459	1.000	0.383	0.285	0.439	0.535
SPOT_AL	0.668	0.383	1.000	0.226	0.273	0.451
GRDNT_RT	0.366	0.285	0.226	1.000	0.943	0.647
GRDNT_VAL	0.498	0.439	0.273	0.943	1.000	0.766
SLANT_DRC	0.650	0.535	0.451	0.647	0.766	1.000

Heatmap
Table

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
SPOT_LO	1.000	0.256	-0.377	0.252	0.252	0.257
SPOT_LA	0.256	1.000	-0.271	0.303	0.303	0.321
SPOT_AL	-0.377	-0.271	1.000	0.057	0.057	-0.039
GRDNT_RT	0.252	0.303	0.057	1.000	1.000	0.420
GRDNT_VAL	0.252	0.303	0.057	1.000	1.000	0.420
SLANT_DRC	0.257	0.321	-0.039	0.420	0.420	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.120922	35.132975	-0.235	72.44	35.92	335.85
1	129.120925	35.132975	-0.184	73.17	36.19	338.34
2	129.120927	35.132975	-0.14	65.35	33.16	340.79
3	129.120929	35.132975	-0.089	47.72	25.51	353.59
4	129.120931	35.132975	-0.027	89.84	41.94	311.82
5	129.120933	35.132975	0.009	61.92	31.77	319.47
6	129.120914	35.132974	-0.571	54.75	28.7	325.39
7	129.120916	35.132974	-0.353	58.15	30.18	323.79
8	129.120918	35.132974	-0.222	57.43	29.87	326.2
9	129.12092	35.132974	-0.163	48.79	26.01	332.84

	SPOT_LO	SPOT_LA	SPOT_AL	GRDNT_RT	GRDNT_VAL	SLANT_DRC
428	129.120909	35.132948	0.623	28.46	15.89	24.87
429	129.120911	35.132948	0.577	29.13	16.24	22.63
430	129.120914	35.132948	0.491	26.26	14.71	16.23
431	129.120916	35.132948	0.39	20.08	11.35	5.44
432	129.120918	35.132948	0.311	13.92	7.93	348.99
433	129.12092	35.132948	0.205	26.11	14.63	248.28
434	129.120922	35.132948	0.096	80.98	39.0	216.0
435	129.120925	35.132948	-0.002	150.23	56.35	217.5
436	129.120927	35.132948	-0.075	154.96	57.16	206.27
437	129.120929	35.132948	-0.163	140.23	54.51	179.64

Overview

Variables

Interactions

Correlations

Missing values

Sample