gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.4 KiB
Average record size in memory	55.3 B

Variable types

Categorical	1
Numeric	5

Dataset

Description	Sample
Author	㈜지오시스템리서치
URL	https://www.bigdata-coast.kr/gdsInfo/gdsInfoDetail.do?gdsCd=CT09GSR012

Alerts

`WV_NM` has constant value ""	Constant
`WV_MTR_SN` is highly overall correlated with `LA`	High correlation
`LA` is highly overall correlated with `WV_MTR_SN` and 1 other fields	High correlation
`LO` is highly overall correlated with `LA` and 1 other fields	High correlation
`WVDRCT` is highly overall correlated with `LO`	High correlation
`WV_MTR_SN` has unique values	Unique
`LA` has unique values	Unique
`LO` has unique values	Unique

Reproduction

Analysis started	2024-03-13 12:43:43.270888
Analysis finished	2024-03-13 12:43:47.587256
Duration	4.32 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

WV_NM
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

1979	100

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1979
2nd row	1979
3rd row	1979
4th row	1979
5th row	1979

Common Values

Value	Count	Frequency (%)
1979	100	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1979	100	100.0%

WV_MTR_SN
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50.5

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	1
5-th percentile	5.95
Q1	25.75
median	50.5
Q3	75.25
95-th percentile	95.05
Maximum	100
Range	99
Interquartile range (IQR)	49.5

Descriptive statistics

Standard deviation	29.011492
Coefficient of variation (CV)	0.57448499
Kurtosis	-1.2
Mean	50.5
Median Absolute Deviation (MAD)	25
Skewness	0
Sum	5050
Variance	841.66667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	1.0%
65	1	1.0%
75	1	1.0%
74	1	1.0%
73	1	1.0%
72	1	1.0%
71	1	1.0%
70	1	1.0%
69	1	1.0%
68	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	1.0%
2	1	1.0%
3	1	1.0%
4	1	1.0%
5	1	1.0%
6	1	1.0%
7	1	1.0%
8	1	1.0%
9	1	1.0%
10	1	1.0%

Value	Count	Frequency (%)
100	1	1.0%
99	1	1.0%
98	1	1.0%
97	1	1.0%
96	1	1.0%
95	1	1.0%
94	1	1.0%
93	1	1.0%
92	1	1.0%
91	1	1.0%

LA
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.69447

Minimum	34.663896
Maximum	34.752531
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	34.663896
5-th percentile	34.667331
Q1	34.672232
median	34.682505
Q3	34.712309
95-th percentile	34.750426
Maximum	34.752531
Range	0.08863504
Interquartile range (IQR)	0.040076818

Descriptive statistics

Standard deviation	0.02739577
Coefficient of variation (CV)	0.00078962928
Kurtosis	-0.51478948
Mean	34.69447
Median Absolute Deviation (MAD)	0.01350906
Skewness	0.89422445
Sum	3469.447
Variance	0.0007505282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34.66389636	1	1.0%
34.70307584	1	1.0%
34.71937991	1	1.0%
34.67819693	1	1.0%
34.681855	1	1.0%
34.67756959	1	1.0%
34.67748421	1	1.0%
34.67664291	1	1.0%
34.68625653	1	1.0%
34.68800945	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
34.66389636	1	1.0%
34.66573414	1	1.0%
34.66595759	1	1.0%
34.66625775	1	1.0%
34.66729378	1	1.0%
34.66733286	1	1.0%
34.66747484	1	1.0%
34.66770699	1	1.0%
34.66788336	1	1.0%
34.66816941	1	1.0%

Value	Count	Frequency (%)
34.7525314	1	1.0%
34.75240413	1	1.0%
34.75206961	1	1.0%
34.75202382	1	1.0%
34.75083032	1	1.0%
34.75040439	1	1.0%
34.7492674	1	1.0%
34.74773674	1	1.0%
34.74644161	1	1.0%
34.74483675	1	1.0%

LO
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127.31244

Minimum	127.27876
Maximum	127.3437
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	127.27876
5-th percentile	127.28362
Q1	127.2989
median	127.31526
Q3	127.32581
95-th percentile	127.33475
Maximum	127.3437
Range	0.0649377
Interquartile range (IQR)	0.02690945

Descriptive statistics

Standard deviation	0.0165326
Coefficient of variation (CV)	0.00012985848
Kurtosis	-0.85543751
Mean	127.31244
Median Absolute Deviation (MAD)	0.0121786
Skewness	-0.3876117
Sum	12731.244
Variance	0.00027332686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
127.2852199	1	1.0%
127.329397	1	1.0%
127.3297968	1	1.0%
127.2812546	1	1.0%
127.3113797	1	1.0%
127.3026961	1	1.0%
127.3112068	1	1.0%
127.28781	1	1.0%
127.3150392	1	1.0%
127.318874	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
127.2787632	1	1.0%
127.280934	1	1.0%
127.2812546	1	1.0%
127.2819733	1	1.0%
127.2819879	1	1.0%
127.2837039	1	1.0%
127.2842391	1	1.0%
127.2851331	1	1.0%
127.2852199	1	1.0%
127.2868747	1	1.0%

Value	Count	Frequency (%)
127.3437009	1	1.0%
127.3411288	1	1.0%
127.3392302	1	1.0%
127.3369121	1	1.0%
127.3353884	1	1.0%
127.3347191	1	1.0%
127.3330033	1	1.0%
127.3326474	1	1.0%
127.3318687	1	1.0%
127.331211	1	1.0%

SGNFCT_WVHGH
Real number (ℝ)

Distinct	84
Distinct (%)	84.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.78795

Minimum	0.576
Maximum	0.904
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0.576
5-th percentile	0.68885
Q1	0.7365
median	0.788
Q3	0.84075
95-th percentile	0.89025
Maximum	0.904
Range	0.328
Interquartile range (IQR)	0.10425

Descriptive statistics

Standard deviation	0.066892553
Coefficient of variation (CV)	0.084894413
Kurtosis	-0.37713911
Mean	0.78795
Median Absolute Deviation (MAD)	0.0535
Skewness	-0.19194473
Sum	78.795
Variance	0.0044746136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.752	3	3.0%
0.82	3	3.0%
0.768	2	2.0%
0.701	2	2.0%
0.889	2	2.0%
0.75	2	2.0%
0.731	2	2.0%
0.717	2	2.0%
0.727	2	2.0%
0.829	2	2.0%
Other values (74)	78	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.576	1	1.0%
0.665	1	1.0%
0.669	1	1.0%
0.684	1	1.0%
0.686	1	1.0%
0.689	1	1.0%
0.701	2	2.0%
0.704	1	1.0%
0.709	2	2.0%
0.711	1	1.0%

Value	Count	Frequency (%)
0.904	1	1.0%
0.903	1	1.0%
0.9	1	1.0%
0.896	1	1.0%
0.895	1	1.0%
0.89	1	1.0%
0.889	2	2.0%
0.888	1	1.0%
0.88	1	1.0%
0.879	1	1.0%

WVDRCT
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	254.7604

Minimum	0.25
Maximum	359.38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0.25
5-th percentile	37.261
Q1	241.7525
median	288.45
Q3	317.49
95-th percentile	356.34
Maximum	359.38
Range	359.13
Interquartile range (IQR)	75.7375

Descriptive statistics

Standard deviation	99.795146
Coefficient of variation (CV)	0.39172158
Kurtosis	0.63852531
Mean	254.7604
Median Absolute Deviation (MAD)	39.45
Skewness	-1.3466733
Sum	25476.04
Variance	9959.0712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
298.4	2	2.0%
250.17	1	1.0%
329.5	1	1.0%
356.91	1	1.0%
227.24	1	1.0%
299.71	1	1.0%
287.82	1	1.0%
296.2	1	1.0%
239.44	1	1.0%
306.92	1	1.0%
Other values (89)	89	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.25	1	1.0%
31.92	1	1.0%
32.3	1	1.0%
35.32	1	1.0%
35.57	1	1.0%
37.35	1	1.0%
43.21	1	1.0%
43.96	1	1.0%
44.45	1	1.0%
44.57	1	1.0%

Value	Count	Frequency (%)
359.38	1	1.0%
358.57	1	1.0%
358.06	1	1.0%
357.78	1	1.0%
356.91	1	1.0%
356.31	1	1.0%
355.15	1	1.0%
354.77	1	1.0%
354.27	1	1.0%
353.94	1	1.0%

Phik (φk)
Auto

Heatmap
Table

	WV_MTR_SN	LA	LO	SGNFCT_WVHGH	WVDRCT
WV_MTR_SN	1.000	0.532	0.428	0.391	0.400
LA	0.532	1.000	0.704	0.888	0.848
LO	0.428	0.704	1.000	0.487	0.787
SGNFCT_WVHGH	0.391	0.888	0.487	1.000	0.654
WVDRCT	0.400	0.848	0.787	0.654	1.000

Heatmap
Table

	WV_MTR_SN	LA	LO	SGNFCT_WVHGH	WVDRCT
WV_MTR_SN	1.000	0.701	0.253	0.159	-0.120
LA	0.701	1.000	0.712	0.006	0.060
LO	0.253	0.712	1.000	0.167	0.581
SGNFCT_WVHGH	0.159	0.006	0.167	1.000	0.419
WVDRCT	-0.120	0.060	0.581	0.419	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

	WV_NM	WV_MTR_SN	LA	LO	SGNFCT_WVHGH	WVDRCT
0	1979	1	34.663896	127.28522	0.576	250.17
1	1979	2	34.665958	127.287634	0.686	256.04
2	1979	3	34.667294	127.316647	0.799	296.14
3	1979	4	34.665734	127.310834	0.763	289.08
4	1979	5	34.666258	127.306516	0.732	285.94
5	1979	6	34.711382	127.343701	0.738	357.78
6	1979	7	34.667475	127.297929	0.684	259.38
7	1979	8	34.667333	127.29357	0.711	256.23
8	1979	9	34.667883	127.287538	0.761	251.15
9	1979	10	34.668169	127.314627	0.798	294.34

	WV_NM	WV_MTR_SN	LA	LO	SGNFCT_WVHGH	WVDRCT
90	1979	91	34.679593	127.301924	0.75	254.91
91	1979	92	34.683573	127.309432	0.82	299.18
92	1979	93	34.680058	127.281988	0.868	227.8
93	1979	94	34.718819	127.327915	0.731	358.57
94	1979	95	34.712689	127.329105	0.829	350.24
95	1979	96	34.752024	127.311638	0.709	70.21
96	1979	97	34.749267	127.315012	0.709	55.41
97	1979	98	34.744837	127.320862	0.717	43.21
98	1979	99	34.74041	127.323114	0.752	35.57
99	1979	100	34.736814	127.323342	0.743	31.92

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample