Overview

Dataset statistics

Number of variables4
Number of observations8761
Missing cells1023
Missing cells (%)2.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory308.1 KiB
Average record size in memory36.0 B

Variable types

Numeric2
Categorical2

Alerts

STA_LO has constant value ""Constant
STA_LA has constant value ""Constant
STRM_SRG_HIGH has 1023 (11.7%) missing valuesMissing
YMDH has unique valuesUnique

Reproduction

Analysis started2024-03-13 12:50:42.875721
Analysis finished2024-03-13 12:50:44.140463
Duration1.26 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

YMDH
Real number (ℝ)

UNIQUE 

Distinct8761
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.021067 × 109
Minimum2.0210101 × 109
Maximum2.0220101 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size77.1 KiB
2024-03-13T21:50:44.275535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0210101 × 109
5-th percentile2.0210119 × 109
Q12.0210402 × 109
median2.0210702 × 109
Q32.0211001 × 109
95-th percentile2.0211213 × 109
Maximum2.0220101 × 109
Range1000000
Interquartile range (IQR)59912

Descriptive statistics

Standard deviation35941.885
Coefficient of variation (CV)1.7783619 × 10-5
Kurtosis52.687386
Mean2.021067 × 109
Median Absolute Deviation (MAD)29994
Skewness2.0454166
Sum1.7706568 × 1013
Variance1.2918191 × 109
MonotonicityStrictly increasing
2024-03-13T21:50:44.520649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2021010100 1
 
< 0.1%
2021090111 1
 
< 0.1%
2021090105 1
 
< 0.1%
2021090106 1
 
< 0.1%
2021090107 1
 
< 0.1%
2021090108 1
 
< 0.1%
2021090109 1
 
< 0.1%
2021090110 1
 
< 0.1%
2021090112 1
 
< 0.1%
2021090306 1
 
< 0.1%
Other values (8751) 8751
99.9%
ValueCountFrequency (%)
2021010100 1
< 0.1%
2021010101 1
< 0.1%
2021010102 1
< 0.1%
2021010103 1
< 0.1%
2021010104 1
< 0.1%
2021010105 1
< 0.1%
2021010106 1
< 0.1%
2021010107 1
< 0.1%
2021010108 1
< 0.1%
2021010109 1
< 0.1%
ValueCountFrequency (%)
2022010100 1
< 0.1%
2021123123 1
< 0.1%
2021123122 1
< 0.1%
2021123121 1
< 0.1%
2021123120 1
< 0.1%
2021123119 1
< 0.1%
2021123118 1
< 0.1%
2021123117 1
< 0.1%
2021123116 1
< 0.1%
2021123115 1
< 0.1%

STA_LO
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size68.6 KiB
128.3087748
8761 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row128.3087748
2nd row128.3087748
3rd row128.3087748
4th row128.3087748
5th row128.3087748

Common Values

ValueCountFrequency (%)
128.3087748 8761
100.0%

Length

2024-03-13T21:50:44.734402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:50:44.881355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
128.3087748 8761
100.0%

STA_LA
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size68.6 KiB
34.91355153
8761 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row34.91355153
2nd row34.91355153
3rd row34.91355153
4th row34.91355153
5th row34.91355153

Common Values

ValueCountFrequency (%)
34.91355153 8761
100.0%

Length

2024-03-13T21:50:45.080915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:50:45.311380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
34.91355153 8761
100.0%

STRM_SRG_HIGH
Real number (ℝ)

MISSING 

Distinct428
Distinct (%)5.5%
Missing1023
Missing (%)11.7%
Infinite0
Infinite (%)0.0%
Mean0.0029764797
Minimum-0.314
Maximum0.389
Zeros38
Zeros (%)0.4%
Negative3581
Negative (%)40.9%
Memory size77.1 KiB
2024-03-13T21:50:45.521196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-0.314
5-th percentile-0.109
Q1-0.039
median0.005
Q30.047
95-th percentile0.107
Maximum0.389
Range0.703
Interquartile range (IQR)0.086

Descriptive statistics

Standard deviation0.067041365
Coefficient of variation (CV)22.52371
Kurtosis0.96196344
Mean0.0029764797
Median Absolute Deviation (MAD)0.043
Skewness-0.13171185
Sum23.032
Variance0.0044945446
MonotonicityNot monotonic
2024-03-13T21:50:46.193995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-0.03 63
 
0.7%
0.008 63
 
0.7%
0.029 63
 
0.7%
0.027 63
 
0.7%
0.007 62
 
0.7%
0.053 60
 
0.7%
0.004 59
 
0.7%
0.001 58
 
0.7%
-0.002 56
 
0.6%
0.011 56
 
0.6%
Other values (418) 7135
81.4%
(Missing) 1023
 
11.7%
ValueCountFrequency (%)
-0.314 1
< 0.1%
-0.304 1
< 0.1%
-0.297 1
< 0.1%
-0.295 1
< 0.1%
-0.283 1
< 0.1%
-0.282 1
< 0.1%
-0.277 1
< 0.1%
-0.258 1
< 0.1%
-0.254 1
< 0.1%
-0.253 1
< 0.1%
ValueCountFrequency (%)
0.389 1
< 0.1%
0.356 1
< 0.1%
0.291 1
< 0.1%
0.29 1
< 0.1%
0.282 1
< 0.1%
0.273 1
< 0.1%
0.259 1
< 0.1%
0.256 1
< 0.1%
0.254 1
< 0.1%
0.25 1
< 0.1%

Interactions

2024-03-13T21:50:43.528436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:50:43.195207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:50:43.691293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:50:43.356958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T21:50:46.350315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
YMDHSTRM_SRG_HIGH
YMDH1.0000.011
STRM_SRG_HIGH0.0111.000
2024-03-13T21:50:46.468632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
YMDHSTRM_SRG_HIGH
YMDH1.0000.114
STRM_SRG_HIGH0.1141.000

Missing values

2024-03-13T21:50:43.921762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T21:50:44.080719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

YMDHSTA_LOSTA_LASTRM_SRG_HIGH
02021010100128.30877534.913552-0.063
12021010101128.30877534.913552-0.073
22021010102128.30877534.9135520.001
32021010103128.30877534.913552-0.154
42021010104128.30877534.913552-0.152
52021010105128.30877534.9135520.011
62021010106128.30877534.913552-0.032
72021010107128.30877534.913552-0.102
82021010108128.30877534.913552-0.092
92021010109128.30877534.913552-0.159
YMDHSTA_LOSTA_LASTRM_SRG_HIGH
87512021123115128.30877534.913552-0.029
87522021123116128.30877534.913552-0.026
87532021123117128.30877534.9135520.064
87542021123118128.30877534.913552-0.019
87552021123119128.30877534.913552-0.049
87562021123120128.30877534.913552-0.015
87572021123121128.30877534.913552-0.077
87582021123122128.30877534.9135520.023
87592021123123128.30877534.9135520.06
87602022010100128.30877534.9135520.009