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:34.856147
Analysis finished2020-02-14 00:01:35.713906
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Variables

DATE
Date

UNIFORM
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

PORANGUSDM
Real number (ℝ≥0)

UNIQUE
Distinct count361
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1942046709516831
Minimum0.56105
Maximum2.17254761904762
Zeros0
Zeros (%)0.0%
Memory size2.9 KiB

Quantile statistics

Minimum0.56105
5-th percentile0.7371818182
Q10.9244318182
median1.15725
Q31.428714286
95-th percentile1.86452381
Maximum2.172547619
Range1.611497619
Interquartile range (IQR)0.5042824675

Descriptive statistics

Standard deviation0.3473087284
Coefficient of variation (CV)0.2908284793
Kurtosis-0.400216634
Mean1.194204671
Median Absolute Deviation (MAD)0.2839333612
Skewness0.5405907172
Sum431.1078862
Variance0.1206233528
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.56105 0.73767045 1.46855323 2.02435714 2.17254762], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.746478261 1 0.3%
 
1.084357143 1 0.3%
 
1.398880952 1 0.3%
 
1.448368421 1 0.3%
 
1.180863636 1 0.3%
 
1.86452381 1 0.3%
 
1.527738095 1 0.3%
 
1.374657895 1 0.3%
 
1.014954545 1 0.3%
 
1.388818182 1 0.3%
 
Other values (351) 351 97.2%
 
ValueCountFrequency (%) 
0.56105 1 0.3%
 
0.5766190476 1 0.3%
 
0.594547619 1 0.3%
 
0.6096842105 1 0.3%
 
0.6121304348 1 0.3%
 
ValueCountFrequency (%) 
2.172547619 1 0.3%
 
2.03602381 1 0.3%
 
2.012690476 1 0.3%
 
2.012275 1 0.3%
 
2.00325 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

DATEPORANGUSDM
01990-01-011.913636
11990-02-011.940289
21990-03-011.922636
31990-04-011.960125
41990-05-011.949477
51990-06-011.864524
61990-07-011.833381
71990-08-011.724717
81990-09-011.445579
91990-10-011.230826

Last rows

DATEPORANGUSDM
3512019-04-011.084357
3522019-05-010.986045
3532019-06-011.027250
3542019-07-011.014955
3552019-08-010.993318
3562019-09-011.006300
3572019-10-010.984370
3582019-11-010.981600
3592019-12-010.975905
3602020-01-010.969095