Overview

Dataset statistics

Number of variables2
Number of observations361
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory16.4 B

Variable types

DATE1
NUM1

Reproduction

Analysis started2020-02-14 00:01:30.282690
Analysis finished2020-02-14 00:01:31.045214
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Variables

DATE
Date

UNIQUE
Distinct count361
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
Minimum1990-01-01 00:00:00
Maximum2020-01-01 00:00:00
Histogram

PCOALAUUSDM
Real number (ℝ≥0)

Distinct count275
Unique (%)76.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean61.06970978828314
Minimum24.0
Maximum195.18633540372699
Zeros0
Zeros (%)0.0%
Memory size2.9 KiB

Quantile statistics

Minimum24
5-th percentile26.1
Q133.6
median52.43303571
Q385.56173469
95-th percentile125.0858766
Maximum195.1863354
Range171.1863354
Interquartile range (IQR)51.96173469

Descriptive statistics

Standard deviation33.60143246
Coefficient of variation (CV)0.5502143793
Kurtosis0.4179963001
Mean61.06970979
Median Absolute Deviation (MAD)28.05645774
Skewness1.002984538
Sum22046.16523
Variance1129.056264
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 24. 26.09464286 26.12142857 30.875 31.09 ... 54.5187406 57.19212662 106.05620301 142.48182398 195.1863354 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
39.5 19 5.3%
 
31 13 3.6%
 
26.1 11 3.0%
 
40.5 10 2.8%
 
25.1 6 1.7%
 
25.6 5 1.4%
 
33.1 5 1.4%
 
38 4 1.1%
 
35 4 1.1%
 
27.15 3 0.8%
 
Other values (265) 281 77.8%
 
ValueCountFrequency (%) 
24 1 0.3%
 
24.45 1 0.3%
 
24.9 1 0.3%
 
24.96428571 1 0.3%
 
25.1 6 1.7%
 
ValueCountFrequency (%) 
195.1863354 1 0.3%
 
173.3035714 1 0.3%
 
166.9897959 1 0.3%
 
164.4983766 1 0.3%
 
143.0758929 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

DATEPCOALAUUSDM
01990-01-0138.0
11990-02-0138.0
21990-03-0138.0
31990-04-0138.0
41990-05-0140.5
51990-06-0140.5
61990-07-0140.5
71990-08-0140.5
81990-09-0140.5
91990-10-0140.5

Last rows

DATEPCOALAUUSDM
3512019-04-0188.764643
3522019-05-0189.564286
3532019-06-0177.629821
3542019-07-0177.845807
3552019-08-0169.739286
3562019-09-0166.958673
3572019-10-0169.194255
3582019-11-0169.729082
3592019-12-0170.464643
3602020-01-0172.106169