Overview

Dataset info

Number of variables 7
Number of observations 106746
Total Missing (%) 14.3%
Total size in memory 5.7 MiB
Average record size in memory 56.0 B

Variables types

Numeric 4
Categorical 2
Boolean 0
Date 0
Text (Unique) 0
Rejected 1
Unsupported 0

Warnings

  • 0.000911851 is highly correlated with 1 (ρ = 0.99966) Rejected
  • F5 has a high cardinality: 3310 distinct values Warning
  • Unnamed: 6 has 106736 / 100.0% missing values Missing

Variables

+1.089013318
Numeric

Distinct count 106746
Unique (%) 100.0%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean -2.1758
Minimum -89.782
Maximum 89.569
Zeros (%) 0.0%

Quantile statistics

Minimum -89.782
5-th percentile -65.959
Q1 -36.782
Median -2.0403
Q3 31.411
95-th percentile 63.759
Maximum 89.569
Range 179.35
Interquartile range 68.192

Descriptive statistics

Standard deviation 41.118
Coef of variation -18.898
Kurtosis -1.0158
Mean -2.1758
MAD 35.184
Skewness 0.04507
Sum -232250
Variance 1690.7
Memory size 834.0 KiB
Value Count Frequency (%)  
64.257812789 1 0.0%
 
76.793502405 1 0.0%
 
7.007631927 1 0.0%
 
65.005534893 1 0.0%
 
21.579379373000002 1 0.0%
 
42.289749029 1 0.0%
 
62.001978862 1 0.0%
 
-64.298082578 1 0.0%
 
-62.399435645 1 0.0%
 
57.905585078 1 0.0%
 
Other values (106736) 106736 100.0%
 

Minimum 5 values

Value Count Frequency (%)  
-89.782453821 1 0.0%
 
-89.771695885 1 0.0%
 
-89.46050205799999 1 0.0%
 
-89.308448685 1 0.0%
 
-89.273960636 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
89.222916594 1 0.0%
 
89.264137779 1 0.0%
 
89.406534585 1 0.0%
 
89.44429245200001 1 0.0%
 
89.569408632 1 0.0%
 

0.000911851
Highly correlated

This variable is highly correlated with 1 and should be ignored for analysis

Correlation 0.99966

1
Numeric

Distinct count 106746
Unique (%) 100.0%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean 59035
Minimum 2
Maximum 120404
Zeros (%) 0.0%

Quantile statistics

Minimum 2
5-th percentile 5834.2
Q1 29220
Median 58964
Q3 88709
95-th percentile 112430
Maximum 120404
Range 120402
Interquartile range 59488

Descriptive statistics

Standard deviation 34245
Coef of variation 0.58008
Kurtosis -1.2046
Mean 59035
MAD 29668
Skewness 0.0046576
Sum 6301784974
Variance 1172800000
Memory size 834.0 KiB
Value Count Frequency (%)  
2047 1 0.0%
 
39865 1 0.0%
 
101659 1 0.0%
 
111900 1 0.0%
 
113949 1 0.0%
 
107806 1 0.0%
 
109855 1 0.0%
 
21792 1 0.0%
 
23841 1 0.0%
 
17698 1 0.0%
 
Other values (106736) 106736 100.0%
 

Minimum 5 values

Value Count Frequency (%)  
2 1 0.0%
 
3 1 0.0%
 
4 1 0.0%
 
5 1 0.0%
 
6 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
120250 1 0.0%
 
120306 1 0.0%
 
120313 1 0.0%
 
120402 1 0.0%
 
120404 1 0.0%
 

716.850549
Numeric

Distinct count 4962
Unique (%) 4.6%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean 819.22
Minimum 4.0928
Maximum 11649
Zeros (%) 0.0%

Quantile statistics

Minimum 4.0928
5-th percentile 143.88
Q1 362.01
Median 639.54
Q3 1065.9
95-th percentile 2131.8
Maximum 11649
Range 11645
Interquartile range 703.9

Descriptive statistics

Standard deviation 671.58
Coef of variation 0.81979
Kurtosis 9.8215
Mean 819.22
MAD 482.86
Skewness 2.2423
Sum 87448000
Variance 451020
Memory size 834.0 KiB
Value Count Frequency (%)  
1132.524306 188 0.2%
 
1003.5907689999999 179 0.2%
 
1199.143382 176 0.2%
 
1120.848797 175 0.2%
 
1101.915541 173 0.2%
 
1598.857843 171 0.2%
 
1105.650847 166 0.2%
 
1016.096573 166 0.2%
 
1062.433225 164 0.2%
 
1042.0670929999999 163 0.2%
 
Other values (4952) 105025 98.4%
 

Minimum 5 values

Value Count Frequency (%)  
4.092845 1 0.0%
 
4.226932 1 0.0%
 
4.32118 1 0.0%
 
5.948587 1 0.0%
 
8.307024 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
10192.71875 1 0.0%
 
10521.516129000001 1 0.0%
 
10872.233333 1 0.0%
 
11247.137931000001 1 0.0%
 
11648.821429000001 1 0.0%
 

9.10
Numeric

Distinct count 1089
Unique (%) 1.0%
Missing (%) 0.0%
Missing (n) 0
Infinite (%) 0.0%
Infinite (n) 0
Mean 8.2709
Minimum -1.44
Maximum 13.57
Zeros (%) 0.0%

Quantile statistics

Minimum -1.44
5-th percentile 6.07
Q1 7.56
Median 8.35
Q3 9.05
95-th percentile 10.24
Maximum 13.57
Range 15.01
Interquartile range 1.49

Descriptive statistics

Standard deviation 1.2863
Coef of variation 0.15552
Kurtosis 1.576
Mean 8.2709
MAD 0.97001
Skewness -0.43931
Sum 882880
Variance 1.6546
Memory size 834.0 KiB
Value Count Frequency (%)  
8.27 465 0.4%
 
8.6 464 0.4%
 
8.73 448 0.4%
 
8.4 447 0.4%
 
8.52 446 0.4%
 
8.69 445 0.4%
 
8.48 442 0.4%
 
8.65 441 0.4%
 
8.94 440 0.4%
 
8.77 440 0.4%
 
Other values (1079) 102268 95.8%
 

Minimum 5 values

Value Count Frequency (%)  
-1.44 1 0.0%
 
-0.62 1 0.0%
 
-0.05 1 0.0%
 
-0.01 1 0.0%
 
0.03 1 0.0%
 

Maximum 5 values

Value Count Frequency (%)  
13.25 1 0.0%
 
13.5 1 0.0%
 
13.51 1 0.0%
 
13.52 1 0.0%
 
13.57 1 0.0%
 

F5
Categorical

Distinct count 3310
Unique (%) 3.1%
Missing (%) 0.0%
Missing (n) 0
K0
 
7876
G5
 
5710
A0
 
4509
Other values (3307)
88651
Value Count Frequency (%)  
K0 7876 7.4%
 
G5 5710 5.3%
 
A0 4509 4.2%
 
F8 4190 3.9%
 
G0 4105 3.8%
 
F5 3743 3.5%
 
K0III 3329 3.1%
 
K2 3265 3.1%
 
K5 2531 2.4%
 
A2 2442 2.3%
 
Other values (3300) 65046 60.9%
 

Unnamed: 6
Categorical

Distinct count 9
Unique (%) 0.0%
Missing (%) 100.0%
Missing (n) 106736
1
 
3
7:
 
1
5ev
 
1
Other values (5)
 
5
(Missing)
106736
Value Count Frequency (%)  
1 3 0.0%
 
7: 1 0.0%
 
5ev 1 0.0%
 
2 1 0.0%
 
1e: 1 0.0%
 
6e 1 0.0%
 
5v 1 0.0%
 
2v 1 0.0%
 
(Missing) 106736 100.0%
 

Correlations

Sample

1 0.000911851 +1.089013318 716.850549 9.10 F5 Unnamed: 6
0 2 0.003797 -19.498837 156.435012 9.27 K3V NaN
1 3 0.005008 38.859286 1443.216814 6.61 B9 NaN
2 4 0.008382 -51.893546 437.808054 8.06 F0V NaN
3 5 0.009965 -40.591224 840.636598 8.55 G8III NaN
4 6 0.018141 3.946488 179.508531 12.31 M0V: NaN