Pandas Profiling Report

Dataset statistics

Number of variables	38
Number of observations	5000
Missing cells	18557
Missing cells (%)	9.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	304.0 B

Variable types

Numeric	17
Categorical	21

Alerts

`generation-units` has constant value "thousand megawatthours"	Constant
`total-consumption-btu-units` has constant value "million MMBtu"	Constant
`consumption-for-eg-btu-units` has constant value "million MMBtu"	Constant
`consumption-uto-btu-units` has constant value "million MMBtu"	Constant
`receipts-btu-units` has constant value "billion Btu"	Constant
`cost-per-btu-units` has constant value "dollars per million Btu"	Constant
`sulfur-content-units` has constant value "percent"	Constant
`ash-content-units` has constant value "percent"	Constant
`Unnamed: 0` is highly correlated with `period` and 2 other fields	High correlation
`sectorid` is highly correlated with `location` and 2 other fields	High correlation
`generation` is highly correlated with `total-consumption` and 8 other fields	High correlation
`total-consumption` is highly correlated with `generation` and 7 other fields	High correlation
`consumption-for-eg` is highly correlated with `generation` and 6 other fields	High correlation
`consumption-uto` is highly correlated with `generation` and 7 other fields	High correlation
`total-consumption-btu` is highly correlated with `generation` and 8 other fields	High correlation
`consumption-for-eg-btu` is highly correlated with `generation` and 6 other fields	High correlation
`consumption-uto-btu` is highly correlated with `generation` and 8 other fields	High correlation
`stocks` is highly correlated with `fueltypeid` and 9 other fields	High correlation
`receipts` is highly correlated with `generation` and 6 other fields	High correlation
`receipts-btu` is highly correlated with `generation` and 8 other fields	High correlation
`cost` is highly correlated with `fueltypeid` and 13 other fields	High correlation
`cost-per-btu` is highly correlated with `location` and 13 other fields	High correlation
`sulfur-content` is highly correlated with `location` and 7 other fields	High correlation
`ash-content` is highly correlated with `fueltypeid` and 5 other fields	High correlation
`heat-content` is highly correlated with `fueltypeid` and 11 other fields	High correlation
`period` is highly correlated with `Unnamed: 0` and 2 other fields	High correlation
`location` is highly correlated with `Unnamed: 0` and 6 other fields	High correlation
`stateDescription` is highly correlated with `Unnamed: 0` and 6 other fields	High correlation
`sectorDescription` is highly correlated with `location` and 2 other fields	High correlation
`fueltypeid` is highly correlated with `fuelTypeDescription` and 13 other fields	High correlation
`fuelTypeDescription` is highly correlated with `fueltypeid` and 13 other fields	High correlation
`generation-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`total-consumption-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`consumption-for-eg-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`consumption-uto-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`total-consumption-btu-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`consumption-for-eg-btu-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`consumption-uto-btu-units` is highly correlated with `sectorDescription` and 19 other fields	High correlation
`stocks-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`receipts-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`receipts-btu-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`cost-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`cost-per-btu-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`sulfur-content-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`ash-content-units` is highly correlated with `consumption-uto-btu-units` and 19 other fields	High correlation
`heat-content-units` is highly correlated with `fueltypeid` and 10 other fields	High correlation
`generation` has 502 (10.0%) missing values	Missing
`total-consumption` has 623 (12.5%) missing values	Missing
`consumption-for-eg` has 623 (12.5%) missing values	Missing
`consumption-uto` has 623 (12.5%) missing values	Missing
`total-consumption-btu` has 623 (12.5%) missing values	Missing
`consumption-for-eg-btu` has 623 (12.5%) missing values	Missing
`consumption-uto-btu` has 623 (12.5%) missing values	Missing
`stocks` has 4585 (91.7%) missing values	Missing
`receipts` has 296 (5.9%) missing values	Missing
`receipts-btu` has 296 (5.9%) missing values	Missing
`cost` has 3978 (79.6%) missing values	Missing
`cost-per-btu` has 4274 (85.5%) missing values	Missing
`sulfur-content` has 296 (5.9%) missing values	Missing
`ash-content` has 296 (5.9%) missing values	Missing
`heat-content` has 296 (5.9%) missing values	Missing
`generation` is highly skewed (γ1 = 22.9144148)	Skewed
`total-consumption` is highly skewed (γ1 = 30.73579515)	Skewed
`consumption-for-eg` is highly skewed (γ1 = 29.22453334)	Skewed
`consumption-uto` is highly skewed (γ1 = 34.29031446)	Skewed
`total-consumption-btu` is highly skewed (γ1 = 23.39351969)	Skewed
`consumption-for-eg-btu` is highly skewed (γ1 = 22.90084752)	Skewed
`consumption-uto-btu` is highly skewed (γ1 = 22.41990393)	Skewed
`receipts` is highly skewed (γ1 = 29.87602857)	Skewed
`receipts-btu` is highly skewed (γ1 = 21.25369134)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`generation` has 684 (13.7%) zeros	Zeros
`total-consumption` has 2449 (49.0%) zeros	Zeros
`consumption-for-eg` has 2455 (49.1%) zeros	Zeros
`consumption-uto` has 3375 (67.5%) zeros	Zeros
`total-consumption-btu` has 713 (14.3%) zeros	Zeros
`consumption-for-eg-btu` has 720 (14.4%) zeros	Zeros
`consumption-uto-btu` has 2849 (57.0%) zeros	Zeros
`stocks` has 175 (3.5%) zeros	Zeros
`receipts` has 3812 (76.2%) zeros	Zeros
`receipts-btu` has 3690 (73.8%) zeros	Zeros
`cost` has 810 (16.2%) zeros	Zeros
`cost-per-btu` has 497 (9.9%) zeros	Zeros
`sulfur-content` has 4124 (82.5%) zeros	Zeros
`ash-content` has 4198 (84.0%) zeros	Zeros
`heat-content` has 2556 (51.1%) zeros	Zeros

Reproduction

Analysis started	2022-11-17 22:33:16.092715
Analysis finished	2022-11-17 22:34:10.128389
Duration	54.04 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	5000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2499.5

Minimum	0
Maximum	4999
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	249.95
Q1	1249.75
median	2499.5
Q3	3749.25
95-th percentile	4749.05
Maximum	4999
Range	4999
Interquartile range (IQR)	2499.5

Descriptive statistics

Standard deviation	1443.520003
Coefficient of variation (CV)	0.577523506
Kurtosis	-1.2
Mean	2499.5
Median Absolute Deviation (MAD)	1250
Skewness	0
Sum	12497500
Variance	2083750
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3330	1	< 0.1%
3337	1	< 0.1%
3336	1	< 0.1%
3335	1	< 0.1%
3334	1	< 0.1%
3333	1	< 0.1%
3332	1	< 0.1%
3331	1	< 0.1%
3329	1	< 0.1%
Other values (4990)	4990	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
4999	1	< 0.1%
4998	1	< 0.1%
4997	1	< 0.1%
4996	1	< 0.1%
4995	1	< 0.1%
4994	1	< 0.1%
4993	1	< 0.1%
4992	1	< 0.1%
4991	1	< 0.1%
4990	1	< 0.1%

period
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

2021-10	2542
2021-09	1179
2021-07	174
2021-12	159
2022-01	155
Other values (12)	791

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	35000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-06
2nd row	2021-06
3rd row	2021-06
4th row	2021-06
5th row	2021-06

Common Values

Value	Count	Frequency (%)
2021-10	2542	50.8%
2021-09	1179	23.6%
2021-07	174	3.5%
2021-12	159	3.2%
2022-01	155	3.1%
2022-02	154	3.1%
2021-11	145	2.9%
2021-08	132	2.6%
2022-03	90	1.8%
2010-03	64	1.3%
Other values (7)	206	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-10	2542	50.8%
2021-09	1179	23.6%
2021-07	174	3.5%
2021-12	159	3.2%
2022-01	155	3.1%
2022-02	154	3.1%
2021-11	145	2.9%
2021-08	132	2.6%
2022-03	90	1.8%
2010-03	64	1.3%
Other values (7)	206	4.1%

Most occurring characters

Value	Count	Frequency (%)
2	10653	30.4%
0	9822	28.1%
1	7742	22.1%
-	5000	14.3%
9	1179	3.4%
7	174	0.5%
3	154	0.4%
8	132	0.4%
4	76	0.2%
5	39	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	30000	85.7%
Dash Punctuation	5000	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	10653	35.5%
0	9822	32.7%
1	7742	25.8%
9	1179	3.9%
7	174	0.6%
3	154	0.5%
8	132	0.4%
4	76	0.3%
5	39	0.1%
6	29	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	10653	30.4%
0	9822	28.1%
1	7742	22.1%
-	5000	14.3%
9	1179	3.4%
7	174	0.5%
3	154	0.4%
8	132	0.4%
4	76	0.2%
5	39	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	10653	30.4%
0	9822	28.1%
1	7742	22.1%
-	5000	14.3%
9	1179	3.4%
7	174	0.5%
3	154	0.4%
8	132	0.4%
4	76	0.2%
5	39	0.1%

location
Categorical

HIGH CORRELATION

Distinct	37
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

CA	391
TX	316
TN	316
PCN	308
90	297
Other values (32)	3372

Length

Max length	3
Median length	2
Mean length	2.2532
Min length	2

Characters and Unicode

Total characters	11266
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
CA	391	7.8%
TX	316	6.3%
TN	316	6.3%
PCN	308	6.2%
90	297	5.9%
CO	262	5.2%
AR	245	4.9%
PCC	207	4.1%
WSC	204	4.1%
AL	198	4.0%
Other values (27)	2256	45.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	391	7.8%
tx	316	6.3%
tn	316	6.3%
pcn	308	6.2%
90	297	5.9%
co	262	5.2%
ar	245	4.9%
pcc	207	4.1%
wsc	204	4.1%
al	198	4.0%
Other values (27)	2256	45.1%

Most occurring characters

Value	Count	Frequency (%)
C	1840	16.3%
A	1480	13.1%
T	1107	9.8%
N	858	7.6%
S	809	7.2%
P	690	6.1%
M	593	5.3%
R	570	5.1%
I	396	3.5%
D	391	3.5%
Other values (13)	2532	22.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10672	94.7%
Decimal Number	594	5.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	1840	17.2%
A	1480	13.9%
T	1107	10.4%
N	858	8.0%
S	809	7.6%
P	690	6.5%
M	593	5.6%
R	570	5.3%
I	396	3.7%
D	391	3.7%
Other values (11)	1938	18.2%

Decimal Number

Value	Count	Frequency (%)
9	297	50.0%
0	297	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10672	94.7%
Common	594	5.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	1840	17.2%
A	1480	13.9%
T	1107	10.4%
N	858	8.0%
S	809	7.6%
P	690	6.5%
M	593	5.6%
R	570	5.3%
I	396	3.7%
D	391	3.7%
Other values (11)	1938	18.2%

Common

Value	Count	Frequency (%)
9	297	50.0%
0	297	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11266	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	1840	16.3%
A	1480	13.1%
T	1107	9.8%
N	858	7.6%
S	809	7.2%
P	690	6.1%
M	593	5.3%
R	570	5.1%
I	396	3.5%
D	391	3.5%
Other values (13)	2532	22.5%

stateDescription
Categorical

HIGH CORRELATION

Distinct	37
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

California	391
Texas	316
Tennessee	316
Pacific Noncontiguous	308
Pacific	297
Other values (32)	3372

Length

Max length	21
Median length	14
Mean length	10.4584
Min length	4

Characters and Unicode

Total characters	52292
Distinct characters	41
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South Dakota
2nd row	South Dakota
3rd row	South Dakota
4th row	South Dakota
5th row	South Dakota

Common Values

Value	Count	Frequency (%)
California	391	7.8%
Texas	316	6.3%
Tennessee	316	6.3%
Pacific Noncontiguous	308	6.2%
Pacific	297	5.9%
Colorado	262	5.2%
Arkansas	245	4.9%
Pacific Contiguous	207	4.1%
West South Central	204	4.1%
Alabama	198	4.0%
Other values (27)	2256	45.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pacific	812	11.4%
south	612	8.6%
california	391	5.5%
central	385	5.4%
tennessee	316	4.4%
texas	316	4.4%
noncontiguous	308	4.3%
colorado	262	3.7%
arkansas	245	3.4%
atlantic	241	3.4%
Other values (33)	3220	45.3%

Most occurring characters

Value	Count	Frequency (%)
a	6250	12.0%
o	4491	8.6%
n	4406	8.4%
i	4160	8.0%
t	3219	6.2%
s	2992	5.7%
e	2950	5.6%
c	2441	4.7%
l	2212	4.2%
	2108	4.0%
Other values (31)	17063	32.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	42869	82.0%
Uppercase Letter	7177	13.7%
Space Separator	2108	4.0%
Other Punctuation	138	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6250	14.6%
o	4491	10.5%
n	4406	10.3%
i	4160	9.7%
t	3219	7.5%
s	2992	7.0%
e	2950	6.9%
c	2441	5.7%
l	2212	5.2%
u	1988	4.6%
Other values (13)	7760	18.1%

Uppercase Letter

Value	Count	Frequency (%)
C	1325	18.5%
P	987	13.8%
A	840	11.7%
T	701	9.8%
S	681	9.5%
M	593	8.3%
I	391	5.4%
W	379	5.3%
N	341	4.8%
R	325	4.5%
Other values (6)	614	8.6%

Space Separator

Value	Count	Frequency (%)
	2108	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	138	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50046	95.7%
Common	2246	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6250	12.5%
o	4491	9.0%
n	4406	8.8%
i	4160	8.3%
t	3219	6.4%
s	2992	6.0%
e	2950	5.9%
c	2441	4.9%
l	2212	4.4%
u	1988	4.0%
Other values (29)	14937	29.8%

Common

Value	Count	Frequency (%)
	2108	93.9%
.	138	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52292	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6250	12.0%
o	4491	8.6%
n	4406	8.4%
i	4160	8.0%
t	3219	6.2%
s	2992	5.7%
e	2950	5.6%
c	2441	4.7%
l	2212	4.2%
	2108	4.0%
Other values (31)	17063	32.6%

sectorid
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.1342

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	90
Q3	97
95-th percentile	99
Maximum	99
Range	98
Interquartile range (IQR)	94

Descriptive statistics

Standard deviation	46.09975735
Coefficient of variation (CV)	0.8361372315
Kurtosis	-1.932528786
Mean	55.1342
Median Absolute Deviation (MAD)	9
Skewness	-0.2345948465
Sum	275671
Variance	2125.187628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
99	719	14.4%
1	560	11.2%
2	508	10.2%
98	502	10.0%
90	455	9.1%
94	409	8.2%
97	366	7.3%
96	290	5.8%
5	258	5.2%
3	243	4.9%
Other values (5)	690	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	560	11.2%
2	508	10.2%
3	243	4.9%
4	235	4.7%
5	258	5.2%
6	134	2.7%
7	223	4.5%
8	42	0.8%
90	455	9.1%
94	409	8.2%

Value	Count	Frequency (%)
99	719	14.4%
98	502	10.0%
97	366	7.3%
96	290	5.8%
95	56	1.1%
94	409	8.2%
90	455	9.1%
8	42	0.8%
7	223	4.5%
6	134	2.7%

sectorDescription
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

All Sectors	719
Electric Utility	560
IPP Non-CHP	508
Electric Power	502
Electric Power Sector Non-CHP	455
Other values (10)	2256

Length

Max length	29
Median length	27
Mean length	15.8684
Min length	7

Characters and Unicode

Total characters	79342
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electric Power
2nd row	Electric Power
3rd row	Electric Power
4th row	Electric Power
5th row	Electric Power

Common Values

Value	Count	Frequency (%)
All Sectors	719	14.4%
Electric Utility	560	11.2%
IPP Non-CHP	508	10.2%
Electric Power	502	10.0%
Electric Power Sector Non-CHP	455	9.1%
Independent Power Producers	409	8.2%
All Industrial	366	7.3%
All Commercial	290	5.8%
Commercial CHP	258	5.2%
IPP CHP	243	4.9%
Other values (5)	690	13.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
electric	1517	13.5%
all	1375	12.2%
power	1366	12.1%
non-chp	1332	11.8%
commercial	783	6.9%
ipp	751	6.7%
chp	724	6.4%
industrial	723	6.4%
sectors	719	6.4%
utility	560	5.0%
Other values (6)	1427	12.7%

Most occurring characters

Value	Count	Frequency (%)
e	6560	8.3%
l	6431	8.1%
r	6381	8.0%
	6277	7.9%
c	5400	6.8%
P	5333	6.7%
o	5232	6.6%
t	5041	6.4%
i	4283	5.4%
n	3436	4.3%
Other values (18)	24968	31.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	53510	67.4%
Uppercase Letter	18223	23.0%
Space Separator	6277	7.9%
Dash Punctuation	1332	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	6560	12.3%
l	6431	12.0%
r	6381	11.9%
c	5400	10.1%
o	5232	9.8%
t	5041	9.4%
i	4283	8.0%
n	3436	6.4%
d	1992	3.7%
s	1949	3.6%
Other values (6)	6805	12.7%

Uppercase Letter

Value	Count	Frequency (%)
P	5333	29.3%
C	2951	16.2%
H	2056	11.3%
I	1883	10.3%
E	1517	8.3%
A	1375	7.5%
N	1332	7.3%
S	1174	6.4%
U	560	3.1%
R	42	0.2%

Space Separator

Value	Count	Frequency (%)
	6277	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1332	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	71733	90.4%
Common	7609	9.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	6560	9.1%
l	6431	9.0%
r	6381	8.9%
c	5400	7.5%
P	5333	7.4%
o	5232	7.3%
t	5041	7.0%
i	4283	6.0%
n	3436	4.8%
C	2951	4.1%
Other values (16)	20685	28.8%

Common

Value	Count	Frequency (%)
	6277	82.5%
-	1332	17.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79342	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	6560	8.3%
l	6431	8.1%
r	6381	8.0%
	6277	7.9%
c	5400	6.8%
P	5333	6.7%
o	5232	6.6%
t	5041	6.4%
i	4283	5.4%
n	3436	4.3%
Other values (18)	24968	31.5%

fueltypeid
Categorical

HIGH CORRELATION

Distinct	44
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

ALL	230
FOS	206
REN	204
NGO	201
NG	199
Other values (39)	3960

Length

Max length	3
Median length	3
Mean length	2.9396
Min length	2

Characters and Unicode

Total characters	14698
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AOR
2nd row	BIO
3rd row	COL
4th row	COW
5th row	DFO

Common Values

Value	Count	Frequency (%)
ALL	230	4.6%
FOS	206	4.1%
REN	204	4.1%
NGO	201	4.0%
NG	199	4.0%
AOR	198	4.0%
PEL	194	3.9%
PET	192	3.8%
DFO	182	3.6%
BIO	164	3.3%
Other values (34)	3030	60.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
all	230	4.6%
fos	206	4.1%
ren	204	4.1%
ngo	201	4.0%
ng	199	4.0%
aor	198	4.0%
pel	194	3.9%
pet	192	3.8%
dfo	182	3.6%
bio	164	3.3%
Other values (34)	3030	60.6%

Most occurring characters

Value	Count	Frequency (%)
O	2115	14.4%
N	1164	7.9%
W	1157	7.9%
S	1069	7.3%
L	1036	7.0%
P	833	5.7%
T	763	5.2%
G	737	5.0%
B	704	4.8%
R	660	4.5%
Other values (12)	4460	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14586	99.2%
Decimal Number	112	0.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2115	14.5%
N	1164	8.0%
W	1157	7.9%
S	1069	7.3%
L	1036	7.1%
P	833	5.7%
T	763	5.2%
G	737	5.1%
B	704	4.8%
R	660	4.5%
Other values (11)	4348	29.8%

Decimal Number

Value	Count	Frequency (%)
2	112	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14586	99.2%
Common	112	0.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2115	14.5%
N	1164	8.0%
W	1157	7.9%
S	1069	7.3%
L	1036	7.1%
P	833	5.7%
T	763	5.2%
G	737	5.1%
B	704	4.8%
R	660	4.5%
Other values (11)	4348	29.8%

Common

Value	Count	Frequency (%)
2	112	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14698	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	2115	14.4%
N	1164	7.9%
W	1157	7.9%
S	1069	7.3%
L	1036	7.0%
P	833	5.7%
T	763	5.2%
G	737	5.0%
B	704	4.8%
R	660	4.5%
Other values (12)	4460	30.3%

fuelTypeDescription
Categorical

HIGH CORRELATION

Distinct	42
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

biomass	394
all fuels	230
fossil fuels	206
renewable	204
natural gas & other gases	201
Other values (37)	3765

Length

Max length	40
Median length	24
Mean length	15.908
Min length	4

Characters and Unicode

Total characters	79540
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	all renewables
2nd row	biomass
3rd row	coal, excluding waste coal
4th row	all coal products
5th row	distillate fuel oil

Common Values

Value	Count	Frequency (%)
biomass	394	7.9%
all fuels	230	4.6%
fossil fuels	206	4.1%
renewable	204	4.1%
natural gas & other gases	201	4.0%
natural gas	199	4.0%
all renewables	198	4.0%
petroleum liquids	194	3.9%
petroleum	192	3.8%
distillate fuel oil	182	3.6%
Other values (32)	2800	56.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
coal	832	7.1%
gas	636	5.4%
solar	630	5.3%
other	600	5.1%
all	548	4.6%
petroleum	440	3.7%
waste	438	3.7%
fuels	436	3.7%
natural	400	3.4%
biomass	394	3.3%
Other values (44)	6445	54.6%

Most occurring characters

Value	Count	Frequency (%)
l	8349	10.5%
a	7537	9.5%
e	7264	9.1%
	6799	8.5%
o	6578	8.3%
s	6328	8.0%
t	5280	6.6%
i	4718	5.9%
r	3862	4.9%
u	3260	4.1%
Other values (18)	19565	24.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	72377	91.0%
Space Separator	6799	8.5%
Other Punctuation	322	0.4%
Dash Punctuation	42	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	8349	11.5%
a	7537	10.4%
e	7264	10.0%
o	6578	9.1%
s	6328	8.7%
t	5280	7.3%
i	4718	6.5%
r	3862	5.3%
u	3260	4.5%
n	3227	4.5%
Other values (14)	15974	22.1%

Other Punctuation

Value	Count	Frequency (%)
&	201	62.4%
,	121	37.6%

Space Separator

Value	Count	Frequency (%)
	6799	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	42	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	72377	91.0%
Common	7163	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	8349	11.5%
a	7537	10.4%
e	7264	10.0%
o	6578	9.1%
s	6328	8.7%
t	5280	7.3%
i	4718	6.5%
r	3862	5.3%
u	3260	4.5%
n	3227	4.5%
Other values (14)	15974	22.1%

Common

Value	Count	Frequency (%)
	6799	94.9%
&	201	2.8%
,	121	1.7%
-	42	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	79540	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	8349	10.5%
a	7537	9.5%
e	7264	9.1%
	6799	8.5%
o	6578	8.3%
s	6328	8.0%
t	5280	6.6%
i	4718	5.9%
r	3862	4.9%
u	3260	4.1%
Other values (18)	19565	24.6%

generation
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	1969
Distinct (%)	43.8%
Missing	502
Missing (%)	10.0%
Infinite	0
Infinite (%)	0.0%
Mean	1505.740881

Minimum	-493.31
Maximum	378966.7023
Zeros	684
Zeros (%)	13.7%
Negative	64
Negative (%)	1.3%
Memory size	39.2 KiB

Quantile statistics

Minimum	-493.31
5-th percentile	0
Q1	1.005
median	21.27886
Q3	312.38666
95-th percentile	6606.61323
Maximum	378966.7023
Range	379460.0123
Interquartile range (IQR)	311.38166

Descriptive statistics

Standard deviation	9328.222315
Coefficient of variation (CV)	6.195104636
Kurtosis	742.6162863
Mean	1505.740881
Median Absolute Deviation (MAD)	21.27886
Skewness	22.9144148
Sum	6772822.484
Variance	87015731.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	684	13.7%
284.176	20	0.4%
3.08367	19	0.4%
6.71839	18	0.4%
5.25275	17	0.3%
23.86935	16	0.3%
1.14336	14	0.3%
5.28567	14	0.3%
1.79978	13	0.3%
0.001	13	0.3%
Other values (1959)	3670	73.4%
(Missing)	502	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-493.31	1	< 0.1%
-321.982	1	< 0.1%
-116.314	2	< 0.1%
-56.033	1	< 0.1%
-52.94	5	0.1%
-45.926	4	0.1%
-45.5	4	0.1%
-36.457	1	< 0.1%
-28.669	1	< 0.1%
-5.723	1	< 0.1%

Value	Count	Frequency (%)
378966.7023	1	< 0.1%
228579.0333	1	< 0.1%
186742.1265	1	< 0.1%
137288.5043	1	< 0.1%
136317.1032	1	< 0.1%
128305.7695	1	< 0.1%
87505.58733	1	< 0.1%
86862.2401	1	< 0.1%
79286.82934	1	< 0.1%
70576.875	1	< 0.1%

generation-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand megawatthours	5000

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	110000
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand megawatthours
2nd row	thousand megawatthours
3rd row	thousand megawatthours
4th row	thousand megawatthours
5th row	thousand megawatthours

Common Values

Value	Count	Frequency (%)
thousand megawatthours	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	50.0%
megawatthours	5000	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	15000	13.6%
a	15000	13.6%
h	10000	9.1%
o	10000	9.1%
u	10000	9.1%
s	10000	9.1%
n	5000	4.5%
d	5000	4.5%
	5000	4.5%
m	5000	4.5%
Other values (4)	20000	18.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	105000	95.5%
Space Separator	5000	4.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	15000	14.3%
a	15000	14.3%
h	10000	9.5%
o	10000	9.5%
u	10000	9.5%
s	10000	9.5%
n	5000	4.8%
d	5000	4.8%
m	5000	4.8%
e	5000	4.8%
Other values (3)	15000	14.3%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	105000	95.5%
Common	5000	4.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	15000	14.3%
a	15000	14.3%
h	10000	9.5%
o	10000	9.5%
u	10000	9.5%
s	10000	9.5%
n	5000	4.8%
d	5000	4.8%
m	5000	4.8%
e	5000	4.8%
Other values (3)	15000	14.3%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	110000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	15000	13.6%
a	15000	13.6%
h	10000	9.1%
o	10000	9.1%
u	10000	9.1%
s	10000	9.1%
n	5000	4.5%
d	5000	4.5%
	5000	4.5%
m	5000	4.5%
Other values (4)	20000	18.2%

total-consumption
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	928
Distinct (%)	21.2%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	2712.5538

Minimum	0
Maximum	1200476.741
Zeros	2449
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	85.922
95-th percentile	4690.129
Maximum	1200476.741
Range	1200476.741
Interquartile range (IQR)	85.922

Descriptive statistics

Standard deviation	29195.77343
Coefficient of variation (CV)	10.7632053
Kurtosis	1155.412575
Mean	2712.5538
Median Absolute Deviation (MAD)	0
Skewness	30.73579515
Sum	11872847.98
Variance	852393186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2449	49.0%
143.674	20	0.4%
0.014	14	0.3%
160.819	13	0.3%
81.55	13	0.3%
125.482	12	0.2%
0.343	12	0.2%
0.002	12	0.2%
26.788	11	0.2%
73.705	10	0.2%
Other values (918)	1811	36.2%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2449	49.0%
0.001	6	0.1%
0.002	12	0.2%
0.005	1	< 0.1%
0.006	1	< 0.1%
0.008	6	0.1%
0.012	3	0.1%
0.014	14	0.3%
0.018	3	0.1%
0.02	2	< 0.1%

Value	Count	Frequency (%)
1200476.741	1	< 0.1%
1114612.527	1	< 0.1%
517549.829	1	< 0.1%
239806.207	1	< 0.1%
239045.7	1	< 0.1%
229371.502	2	< 0.1%
207961.641	1	< 0.1%
199114.333	1	< 0.1%
183538.951	2	< 0.1%
162113.397	1	< 0.1%

total-consumption-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand physical units	3117
thousand short tons	951
thousand barrels	477
thousand Mcf	455

Length

Max length	23
Median length	23
Mean length	20.5704
Min length	12

Characters and Unicode

Total characters	102852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand physical units
2nd row	thousand physical units
3rd row	thousand short tons
4th row	thousand short tons
5th row	thousand short tons

Common Values

Value	Count	Frequency (%)
thousand physical units	3117	62.3%
thousand short tons	951	19.0%
thousand barrels	477	9.5%
thousand Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	35.5%
physical	3117	22.2%
units	3117	22.2%
short	951	6.8%
tons	951	6.8%
barrels	477	3.4%
mcf	455	3.2%

Most occurring characters

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93329	90.7%
Space Separator	9068	8.8%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	14.6%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.7%
d	5000	5.4%
l	3594	3.9%
Other values (7)	13120	14.1%

Space Separator

Value	Count	Frequency (%)
	9068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	91.2%
Common	9068	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	14.5%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.6%
d	5000	5.3%
l	3594	3.8%
Other values (8)	13575	14.5%

Common

Value	Count	Frequency (%)
	9068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

consumption-for-eg
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	919
Distinct (%)	21.0%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	2450.317202

Minimum	0
Maximum	1023723.001
Zeros	2455
Zeros (%)	49.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	69.35
95-th percentile	3929.183
Maximum	1023723.001
Range	1023723.001
Interquartile range (IQR)	69.35

Descriptive statistics

Standard deviation	26191.68415
Coefficient of variation (CV)	10.68909941
Kurtosis	1053.317253
Mean	2450.317202
Median Absolute Deviation (MAD)	0
Skewness	29.22453334
Sum	10725038.39
Variance	686004318.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2455	49.1%
143.674	20	0.4%
0.014	14	0.3%
81.55	13	0.3%
160.819	13	0.3%
0.031	12	0.2%
125.482	12	0.2%
5.229	11	0.2%
0.002	11	0.2%
0.034	10	0.2%
Other values (909)	1806	36.1%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2455	49.1%
0.001	1	< 0.1%
0.002	11	0.2%
0.005	5	0.1%
0.006	5	0.1%
0.007	2	< 0.1%
0.008	6	0.1%
0.01	2	< 0.1%
0.011	3	0.1%
0.014	14	0.3%

Value	Count	Frequency (%)
1023723.001	1	< 0.1%
1002158.692	1	< 0.1%
513694.03	1	< 0.1%
228225.951	1	< 0.1%
228092.221	1	< 0.1%
227941.376	2	< 0.1%
182867.343	2	< 0.1%
169711.687	1	< 0.1%
167398.874	1	< 0.1%
146233.291	1	< 0.1%

consumption-for-eg-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand physical units	3117
thousand short tons	951
thousand barrels	477
thousand Mcf	455

Length

Max length	23
Median length	23
Mean length	20.5704
Min length	12

Characters and Unicode

Total characters	102852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand physical units
2nd row	thousand physical units
3rd row	thousand short tons
4th row	thousand short tons
5th row	thousand short tons

Common Values

Value	Count	Frequency (%)
thousand physical units	3117	62.3%
thousand short tons	951	19.0%
thousand barrels	477	9.5%
thousand Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	35.5%
physical	3117	22.2%
units	3117	22.2%
short	951	6.8%
tons	951	6.8%
barrels	477	3.4%
mcf	455	3.2%

Most occurring characters

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93329	90.7%
Space Separator	9068	8.8%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	14.6%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.7%
d	5000	5.4%
l	3594	3.9%
Other values (7)	13120	14.1%

Space Separator

Value	Count	Frequency (%)
	9068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	91.2%
Common	9068	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	14.5%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.6%
d	5000	5.3%
l	3594	3.8%
Other values (8)	13575	14.5%

Common

Value	Count	Frequency (%)
	9068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

consumption-uto
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	411
Distinct (%)	9.4%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	262.1514606

Minimum	0
Maximum	176753.74
Zeros	3375
Zeros (%)	67.5%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	346.005
Maximum	176753.74
Range	176753.74
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3677.008207
Coefficient of variation (CV)	14.02627397
Kurtosis	1441.896359
Mean	262.1514606
Median Absolute Deviation (MAD)	0
Skewness	34.29031446
Sum	1147436.943
Variance	13520389.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3375	67.5%
7.953	13	0.3%
40.912	12	0.2%
0.312	12	0.2%
3.558	12	0.2%
37.993	12	0.2%
4.355	12	0.2%
0.041	11	0.2%
112.778	11	0.2%
21.559	11	0.2%
Other values (401)	896	17.9%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3375	67.5%
0.001	7	0.1%
0.002	1	< 0.1%
0.006	3	0.1%
0.007	3	0.1%
0.009	2	< 0.1%
0.01	3	0.1%
0.013	2	< 0.1%
0.015	9	0.2%
0.016	2	< 0.1%

Value	Count	Frequency (%)
176753.74	1	< 0.1%
112453.835	1	< 0.1%
64299.905	1	< 0.1%
40282.69	1	< 0.1%
38249.954	1	< 0.1%
31715.459	1	< 0.1%
30632.331	1	< 0.1%
29209.789	1	< 0.1%
27226	1	< 0.1%
22061.296	2	< 0.1%

consumption-uto-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand physical units	3117
thousand short tons	951
thousand barrels	477
thousand Mcf	455

Length

Max length	23
Median length	23
Mean length	20.5704
Min length	12

Characters and Unicode

Total characters	102852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand physical units
2nd row	thousand physical units
3rd row	thousand short tons
4th row	thousand short tons
5th row	thousand short tons

Common Values

Value	Count	Frequency (%)
thousand physical units	3117	62.3%
thousand short tons	951	19.0%
thousand barrels	477	9.5%
thousand Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	35.5%
physical	3117	22.2%
units	3117	22.2%
short	951	6.8%
tons	951	6.8%
barrels	477	3.4%
mcf	455	3.2%

Most occurring characters

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93329	90.7%
Space Separator	9068	8.8%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	14.6%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.7%
d	5000	5.4%
l	3594	3.9%
Other values (7)	13120	14.1%

Space Separator

Value	Count	Frequency (%)
	9068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	91.2%
Common	9068	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	14.5%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.6%
d	5000	5.3%
l	3594	3.8%
Other values (8)	13575	14.5%

Common

Value	Count	Frequency (%)
	9068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

total-consumption-btu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	1844
Distinct (%)	42.1%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	14.50350716

Minimum	0
Maximum	3700.69511
Zeros	713
Zeros (%)	14.3%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.00839
median	0.29158
Q3	3.93595
95-th percentile	62.13151
Maximum	3700.69511
Range	3700.69511
Interquartile range (IQR)	3.92756

Descriptive statistics

Standard deviation	90.09394357
Coefficient of variation (CV)	6.211872933
Kurtosis	775.0603341
Mean	14.50350716
Median Absolute Deviation (MAD)	0.29158
Skewness	23.39351969
Sum	63481.85085
Variance	8116.918668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	713	14.3%
7 × 10^-5	22	0.4%
3.08899	20	0.4%
0.03947	19	0.4%
1 × 10^-5	19	0.4%
0.07832	18	0.4%
0.0028	17	0.3%
0.06073	17	0.3%
0.29158	16	0.3%
0.06127	14	0.3%
Other values (1834)	3502	70.0%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	713	14.3%
1 × 10^-5	19	0.4%
5 × 10^-5	6	0.1%
6 × 10^-5	2	< 0.1%
7 × 10^-5	22	0.4%
0.0001	4	0.1%
0.00011	2	< 0.1%
0.00012	3	0.1%
0.00013	1	< 0.1%
0.00014	2	< 0.1%

Value	Count	Frequency (%)
3700.69511	1	< 0.1%
2168.00937	1	< 0.1%
1762.25657	1	< 0.1%
1185.59015	1	< 0.1%
1173.51279	1	< 0.1%
1151.40097	1	< 0.1%
951.82708	1	< 0.1%
944.18178	1	< 0.1%
778.07218	1	< 0.1%
737.24604	1	< 0.1%

total-consumption-btu-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

million MMBtu	5000

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	65000
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	million MMBtu
2nd row	million MMBtu
3rd row	million MMBtu
4th row	million MMBtu
5th row	million MMBtu

Common Values

Value	Count	Frequency (%)
million MMBtu	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
million	5000	50.0%
mmbtu	5000	50.0%

Most occurring characters

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45000	69.2%
Uppercase Letter	15000	23.1%
Space Separator	5000	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	10000	22.2%
l	10000	22.2%
m	5000	11.1%
o	5000	11.1%
n	5000	11.1%
t	5000	11.1%
u	5000	11.1%

Uppercase Letter

Value	Count	Frequency (%)
M	10000	66.7%
B	5000	33.3%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60000	92.3%
Common	5000	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	10000	16.7%
l	10000	16.7%
M	10000	16.7%
m	5000	8.3%
o	5000	8.3%
n	5000	8.3%
B	5000	8.3%
t	5000	8.3%
u	5000	8.3%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

consumption-for-eg-btu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	1834
Distinct (%)	41.9%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	13.72247551

Minimum	0
Maximum	3464.89228
Zeros	720
Zeros (%)	14.4%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.00455
median	0.18406
Q3	3.08899
95-th percentile	61.17745
Maximum	3464.89228
Range	3464.89228
Interquartile range (IQR)	3.08444

Descriptive statistics

Standard deviation	85.38831722
Coefficient of variation (CV)	6.222515549
Kurtosis	744.88318
Mean	13.72247551
Median Absolute Deviation (MAD)	0.18406
Skewness	22.90084752
Sum	60063.2753
Variance	7291.164718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	720	14.4%
3.08899	20	0.4%
7 × 10^-5	19	0.4%
0.03947	19	0.4%
0.07832	18	0.4%
0.06073	17	0.3%
0.29158	16	0.3%
0.06127	14	0.3%
0.06811	14	0.3%
0.01361	13	0.3%
Other values (1824)	3507	70.1%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	720	14.4%
1 × 10^-5	13	0.3%
3 × 10^-5	3	0.1%
4 × 10^-5	2	< 0.1%
5 × 10^-5	7	0.1%
6 × 10^-5	7	0.1%
7 × 10^-5	19	0.4%
0.0001	4	0.1%
0.00011	2	< 0.1%
0.00012	4	0.1%

Value	Count	Frequency (%)
3464.89228	1	< 0.1%
2009.66244	1	< 0.1%
1754.67278	1	< 0.1%
1178.25755	1	< 0.1%
1040.72378	1	< 0.1%
1035.44587	1	< 0.1%
930.5016	1	< 0.1%
923.15041	1	< 0.1%
737.24604	1	< 0.1%
703.11816	1	< 0.1%

consumption-for-eg-btu-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

million MMBtu	5000

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	65000
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	million MMBtu
2nd row	million MMBtu
3rd row	million MMBtu
4th row	million MMBtu
5th row	million MMBtu

Common Values

Value	Count	Frequency (%)
million MMBtu	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
million	5000	50.0%
mmbtu	5000	50.0%

Most occurring characters

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45000	69.2%
Uppercase Letter	15000	23.1%
Space Separator	5000	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	10000	22.2%
l	10000	22.2%
m	5000	11.1%
o	5000	11.1%
n	5000	11.1%
t	5000	11.1%
u	5000	11.1%

Uppercase Letter

Value	Count	Frequency (%)
M	10000	66.7%
B	5000	33.3%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60000	92.3%
Common	5000	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	10000	16.7%
l	10000	16.7%
M	10000	16.7%
m	5000	8.3%
o	5000	8.3%
n	5000	8.3%
B	5000	8.3%
t	5000	8.3%
u	5000	8.3%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

consumption-uto-btu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	586
Distinct (%)	13.4%
Missing	623
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.7810318095

Minimum	0
Maximum	235.80282
Zeros	2849
Zeros (%)	57.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.04108
95-th percentile	2.3824
Maximum	235.80282
Range	235.80282
Interquartile range (IQR)	0.04108

Descriptive statistics

Standard deviation	6.190254589
Coefficient of variation (CV)	7.925739405
Kurtosis	667.1339216
Mean	0.7810318095
Median Absolute Deviation (MAD)	0
Skewness	22.41990393
Sum	3418.57623
Variance	38.31925187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2849	57.0%
0.1197	23	0.5%
1 × 10^-5	20	0.4%
0.22035	20	0.4%
0.06967	19	0.4%
0.02496	18	0.4%
3 × 10^-5	17	0.3%
0.06825	14	0.3%
0.00096	14	0.3%
0.31725	13	0.3%
Other values (576)	1370	27.4%
(Missing)	623	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2849	57.0%
1 × 10^-5	20	0.4%
2 × 10^-5	6	0.1%
3 × 10^-5	17	0.3%
4 × 10^-5	6	0.1%
5 × 10^-5	2	< 0.1%
6 × 10^-5	3	0.1%
8 × 10^-5	2	< 0.1%
9 × 10^-5	3	0.1%
0.0001	3	0.1%

Value	Count	Frequency (%)
235.80282	1	< 0.1%
158.34692	1	< 0.1%
132.78901	1	< 0.1%
115.9551	1	< 0.1%
74.95402	3	0.1%
68.59367	1	< 0.1%
67.53777	1	< 0.1%
45.93429	1	< 0.1%
39.65767	1	< 0.1%
37.5865	1	< 0.1%

consumption-uto-btu-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

million MMBtu	5000

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	65000
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	million MMBtu
2nd row	million MMBtu
3rd row	million MMBtu
4th row	million MMBtu
5th row	million MMBtu

Common Values

Value	Count	Frequency (%)
million MMBtu	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
million	5000	50.0%
mmbtu	5000	50.0%

Most occurring characters

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45000	69.2%
Uppercase Letter	15000	23.1%
Space Separator	5000	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	10000	22.2%
l	10000	22.2%
m	5000	11.1%
o	5000	11.1%
n	5000	11.1%
t	5000	11.1%
u	5000	11.1%

Uppercase Letter

Value	Count	Frequency (%)
M	10000	66.7%
B	5000	33.3%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	60000	92.3%
Common	5000	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	10000	16.7%
l	10000	16.7%
M	10000	16.7%
m	5000	8.3%
o	5000	8.3%
n	5000	8.3%
B	5000	8.3%
t	5000	8.3%
u	5000	8.3%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	10000	15.4%
l	10000	15.4%
M	10000	15.4%
m	5000	7.7%
o	5000	7.7%
n	5000	7.7%
	5000	7.7%
B	5000	7.7%
t	5000	7.7%
u	5000	7.7%

stocks
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	194
Distinct (%)	46.7%
Missing	4585
Missing (%)	91.7%
Infinite	0
Infinite (%)	0.0%
Mean	2302.465472

Minimum	0
Maximum	113511.087
Zeros	175
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3.994
Q3	181.5275
95-th percentile	7854.5853
Maximum	113511.087
Range	113511.087
Interquartile range (IQR)	181.5275

Descriptive statistics

Standard deviation	11083.65396
Coefficient of variation (CV)	4.813819833
Kurtosis	51.84346889
Mean	2302.465472
Median Absolute Deviation (MAD)	3.994
Skewness	6.897245344
Sum	955523.171
Variance	122847385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	175	3.5%
10.07	4	0.1%
212.271	4	0.1%
28.246	4	0.1%
252.541	4	0.1%
168.294	3	0.1%
7.974	3	0.1%
142.268	3	0.1%
14.933	3	0.1%
1516.136	3	0.1%
Other values (184)	209	4.2%
(Missing)	4585	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	175	3.5%
0.054	2	< 0.1%
0.157	2	< 0.1%
0.176	1	< 0.1%
0.177	1	< 0.1%
0.228	1	< 0.1%
0.244	1	< 0.1%
0.327	1	< 0.1%
0.406	1	< 0.1%
0.409	1	< 0.1%

Value	Count	Frequency (%)
113511.087	1	< 0.1%
87890.446	1	< 0.1%
87786.234	1	< 0.1%
79487.015	1	< 0.1%
63784.986	2	< 0.1%
51144.976	1	< 0.1%
51049.386	1	< 0.1%
33948.375	2	< 0.1%
21324.104	2	< 0.1%
20000.529	1	< 0.1%

stocks-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand physical units	3117
thousand short tons	951
thousand barrels	477
thousand Mcf	455

Length

Max length	23
Median length	23
Mean length	20.5704
Min length	12

Characters and Unicode

Total characters	102852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand physical units
2nd row	thousand physical units
3rd row	thousand short tons
4th row	thousand short tons
5th row	thousand short tons

Common Values

Value	Count	Frequency (%)
thousand physical units	3117	62.3%
thousand short tons	951	19.0%
thousand barrels	477	9.5%
thousand Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	35.5%
physical	3117	22.2%
units	3117	22.2%
short	951	6.8%
tons	951	6.8%
barrels	477	3.4%
mcf	455	3.2%

Most occurring characters

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93329	90.7%
Space Separator	9068	8.8%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	14.6%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.7%
d	5000	5.4%
l	3594	3.9%
Other values (7)	13120	14.1%

Space Separator

Value	Count	Frequency (%)
	9068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	91.2%
Common	9068	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	14.5%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.6%
d	5000	5.3%
l	3594	3.8%
Other values (8)	13575	14.5%

Common

Value	Count	Frequency (%)
	9068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

receipts
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	325
Distinct (%)	6.9%
Missing	296
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	2026.683126

Minimum	0
Maximum	926905.42
Zeros	3812
Zeros (%)	76.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2488.99825
Maximum	926905.42
Range	926905.42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	23214.32048
Coefficient of variation (CV)	11.45434142
Kurtosis	1109.659581
Mean	2026.683126
Median Absolute Deviation (MAD)	0
Skewness	29.87602857
Sum	9533517.424
Variance	538904675.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3812	76.2%
53.457	22	0.4%
86.988	20	0.4%
3.363	14	0.3%
5.216	12	0.2%
13.283	12	0.2%
60.186	11	0.2%
3671.064	10	0.2%
12.49	9	0.2%
3.874	9	0.2%
Other values (315)	773	15.5%
(Missing)	296	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3812	76.2%
0.03	2	< 0.1%
0.143	1	< 0.1%
0.18	3	0.1%
0.232	1	< 0.1%
0.357	1	< 0.1%
0.362	3	0.1%
0.869	6	0.1%
1.048	3	0.1%
1.082	1	< 0.1%

Value	Count	Frequency (%)
926905.42	2	< 0.1%
448849.226	1	< 0.1%
216155.694	2	< 0.1%
215159.362	2	< 0.1%
177744.07	2	< 0.1%
174164.459	2	< 0.1%
141048.08	2	< 0.1%
114107.521	2	< 0.1%
107187.858	2	< 0.1%
105110.035	2	< 0.1%

receipts-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

thousand physical units	3117
thousand short tons	951
thousand barrels	477
thousand Mcf	455

Length

Max length	23
Median length	23
Mean length	20.5704
Min length	12

Characters and Unicode

Total characters	102852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	thousand physical units
2nd row	thousand physical units
3rd row	thousand short tons
4th row	thousand short tons
5th row	thousand short tons

Common Values

Value	Count	Frequency (%)
thousand physical units	3117	62.3%
thousand short tons	951	19.0%
thousand barrels	477	9.5%
thousand Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
thousand	5000	35.5%
physical	3117	22.2%
units	3117	22.2%
short	951	6.8%
tons	951	6.8%
barrels	477	3.4%
mcf	455	3.2%

Most occurring characters

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	93329	90.7%
Space Separator	9068	8.8%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	14.6%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.7%
d	5000	5.4%
l	3594	3.9%
Other values (7)	13120	14.1%

Space Separator

Value	Count	Frequency (%)
	9068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	93784	91.2%
Common	9068	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	14.5%
t	10019	10.7%
n	9068	9.7%
h	9068	9.7%
a	8594	9.2%
u	8117	8.7%
o	6902	7.4%
i	6234	6.6%
d	5000	5.3%
l	3594	3.8%
Other values (8)	13575	14.5%

Common

Value	Count	Frequency (%)
	9068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	102852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13613	13.2%
t	10019	9.7%
n	9068	8.8%
	9068	8.8%
h	9068	8.8%
a	8594	8.4%
u	8117	7.9%
o	6902	6.7%
i	6234	6.1%
d	5000	4.9%
Other values (9)	17169	16.7%

receipts-btu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	399
Distinct (%)	8.5%
Missing	296
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	5731.845309

Minimum	0
Maximum	1716383.163
Zeros	3690
Zeros (%)	73.8%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	19290.6578
Maximum	1716383.163
Range	1716383.163
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	45486.72494
Coefficient of variation (CV)	7.935790741
Kurtosis	604.0411122
Mean	5731.845309
Median Absolute Deviation (MAD)	0
Skewness	21.25369134
Sum	26962600.33
Variance	2069042145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3690	73.8%
1870.242	22	0.4%
1221.55989	22	0.4%
3777.71929	15	0.3%
80.712	14	0.3%
81.3696	12	0.2%
13.283	12	0.2%
1172.18254	11	0.2%
22.60065	9	0.2%
73.51524	9	0.2%
Other values (389)	888	17.8%
(Missing)	296	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3690	73.8%
0.5124	2	< 0.1%
0.58093	1	< 0.1%
0.89495	1	< 0.1%
1.044	3	0.1%
1.54753	1	< 0.1%
2.09916	1	< 0.1%
2.12856	3	0.1%
5.0402	6	0.1%
6.0784	3	0.1%

Value	Count	Frequency (%)
1716383.163	1	< 0.1%
1029675.178	1	< 0.1%
957433.6661	2	< 0.1%
740486.0943	1	< 0.1%
735327.3857	1	< 0.1%
552990.0179	1	< 0.1%
552911.2059	1	< 0.1%
463216.3039	1	< 0.1%
406806.4122	1	< 0.1%
402046.7503	1	< 0.1%

receipts-btu-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

billion Btu	5000

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	55000
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	billion Btu
2nd row	billion Btu
3rd row	billion Btu
4th row	billion Btu
5th row	billion Btu

Common Values

Value	Count	Frequency (%)
billion Btu	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
billion	5000	50.0%
btu	5000	50.0%

Most occurring characters

Value	Count	Frequency (%)
i	10000	18.2%
l	10000	18.2%
b	5000	9.1%
o	5000	9.1%
n	5000	9.1%
	5000	9.1%
B	5000	9.1%
t	5000	9.1%
u	5000	9.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45000	81.8%
Space Separator	5000	9.1%
Uppercase Letter	5000	9.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	10000	22.2%
l	10000	22.2%
b	5000	11.1%
o	5000	11.1%
n	5000	11.1%
t	5000	11.1%
u	5000	11.1%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Uppercase Letter

Value	Count	Frequency (%)
B	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50000	90.9%
Common	5000	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	10000	20.0%
l	10000	20.0%
b	5000	10.0%
o	5000	10.0%
n	5000	10.0%
B	5000	10.0%
t	5000	10.0%
u	5000	10.0%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	10000	18.2%
l	10000	18.2%
b	5000	9.1%
o	5000	9.1%
n	5000	9.1%
	5000	9.1%
B	5000	9.1%
t	5000	9.1%
u	5000	9.1%

cost
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	125
Distinct (%)	12.2%
Missing	3978
Missing (%)	79.6%
Infinite	0
Infinite (%)	0.0%
Mean	10.31503914

Minimum	0
Maximum	168.73
Zeros	810
Zeros (%)	16.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	93.8
Maximum	168.73
Range	168.73
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	27.09472334
Coefficient of variation (CV)	2.626720362
Kurtosis	7.624980478
Mean	10.31503914
Median Absolute Deviation (MAD)	0
Skewness	2.886158942
Sum	10541.97
Variance	734.1240327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	810	16.2%
5.11	4	0.1%
61	4	0.1%
38.48	4	0.1%
94.94	4	0.1%
6.58	4	0.1%
93.8	4	0.1%
42.61	3	0.1%
4.05	3	0.1%
99.78	3	0.1%
Other values (115)	179	3.6%
(Missing)	3978	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	810	16.2%
3.32	1	< 0.1%
4.05	3	0.1%
4.17	2	< 0.1%
4.28	2	< 0.1%
4.44	2	< 0.1%
4.93	2	< 0.1%
4.94	1	< 0.1%
5.03	1	< 0.1%
5.04	1	< 0.1%

Value	Count	Frequency (%)
168.73	1	< 0.1%
126.87	1	< 0.1%
124.7	3	0.1%
118.42	3	0.1%
118.1	3	0.1%
117.1	1	< 0.1%
115.41	1	< 0.1%
112.46	1	< 0.1%
110.63	3	0.1%
110.17	2	< 0.1%

cost-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

dollars per physical units	3117
dollars per short tons	951
dollars per barrels	477
dollars per Mcf	455

Length

Max length	26
Median length	26
Mean length	23.5704
Min length	15

Characters and Unicode

Total characters	117852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dollars per physical units
2nd row	dollars per physical units
3rd row	dollars per short tons
4th row	dollars per short tons
5th row	dollars per short tons

Common Values

Value	Count	Frequency (%)
dollars per physical units	3117	62.3%
dollars per short tons	951	19.0%
dollars per barrels	477	9.5%
dollars per Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
dollars	5000	26.2%
per	5000	26.2%
physical	3117	16.3%
units	3117	16.3%
short	951	5.0%
tons	951	5.0%
barrels	477	2.5%
mcf	455	2.4%

Most occurring characters

Value	Count	Frequency (%)
	14068	11.9%
s	13613	11.6%
l	13594	11.5%
r	11905	10.1%
a	8594	7.3%
p	8117	6.9%
o	6902	5.9%
i	6234	5.3%
e	5477	4.6%
t	5019	4.3%
Other values (9)	24329	20.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	103329	87.7%
Space Separator	14068	11.9%
Uppercase Letter	455	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13613	13.2%
l	13594	13.2%
r	11905	11.5%
a	8594	8.3%
p	8117	7.9%
o	6902	6.7%
i	6234	6.0%
e	5477	5.3%
t	5019	4.9%
d	5000	4.8%
Other values (7)	18874	18.3%

Space Separator

Value	Count	Frequency (%)
	14068	100.0%

Uppercase Letter

Value	Count	Frequency (%)
M	455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	103784	88.1%
Common	14068	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13613	13.1%
l	13594	13.1%
r	11905	11.5%
a	8594	8.3%
p	8117	7.8%
o	6902	6.7%
i	6234	6.0%
e	5477	5.3%
t	5019	4.8%
d	5000	4.8%
Other values (8)	19329	18.6%

Common

Value	Count	Frequency (%)
	14068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14068	11.9%
s	13613	11.6%
l	13594	11.5%
r	11905	10.1%
a	8594	7.3%
p	8117	6.9%
o	6902	5.9%
i	6234	5.3%
e	5477	4.6%
t	5019	4.3%
Other values (9)	24329	20.6%

cost-per-btu
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	141
Distinct (%)	19.4%
Missing	4274
Missing (%)	85.5%
Infinite	0
Infinite (%)	0.0%
Mean	2.336669559

Minimum	0
Maximum	22.142
Zeros	497
Zeros (%)	9.9%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2.150875
95-th percentile	16.72625
Maximum	22.142
Range	22.142
Interquartile range (IQR)	2.150875

Descriptive statistics

Standard deviation	5.022055224
Coefficient of variation (CV)	2.14923638
Kurtosis	5.402728928
Mean	2.336669559
Median Absolute Deviation (MAD)	0
Skewness	2.534970843
Sum	1696.4221
Variance	25.22103867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	497	9.9%
6.58	4	0.1%
15.3847	4	0.1%
2.1346	4	0.1%
16.4764	4	0.1%
3.91	4	0.1%
6.4536	3	0.1%
6.8795	3	0.1%
16.6343	3	0.1%
20.5856	3	0.1%
Other values (131)	197	3.9%
(Missing)	4274	85.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	497	9.9%
1.4793	2	< 0.1%
1.5184	1	< 0.1%
1.5397	2	< 0.1%
1.6075	2	< 0.1%
1.6256	2	< 0.1%
1.6912	1	< 0.1%
1.7474	1	< 0.1%
1.7542	1	< 0.1%
1.7734	2	< 0.1%

Value	Count	Frequency (%)
22.142	1	< 0.1%
21.5	3	0.1%
20.91	1	< 0.1%
20.5856	3	0.1%
20.2724	3	0.1%
19.9428	1	< 0.1%
19.5291	1	< 0.1%
19.2317	1	< 0.1%
19.026	2	< 0.1%
18.8412	1	< 0.1%

cost-per-btu-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

dollars per million Btu	5000

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	115000
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dollars per million Btu
2nd row	dollars per million Btu
3rd row	dollars per million Btu
4th row	dollars per million Btu
5th row	dollars per million Btu

Common Values

Value	Count	Frequency (%)
dollars per million Btu	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
dollars	5000	25.0%
per	5000	25.0%
million	5000	25.0%
btu	5000	25.0%

Most occurring characters

Value	Count	Frequency (%)
l	20000	17.4%
	15000	13.0%
o	10000	8.7%
r	10000	8.7%
i	10000	8.7%
d	5000	4.3%
a	5000	4.3%
s	5000	4.3%
p	5000	4.3%
e	5000	4.3%
Other values (5)	25000	21.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	95000	82.6%
Space Separator	15000	13.0%
Uppercase Letter	5000	4.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	20000	21.1%
o	10000	10.5%
r	10000	10.5%
i	10000	10.5%
d	5000	5.3%
a	5000	5.3%
s	5000	5.3%
p	5000	5.3%
e	5000	5.3%
m	5000	5.3%
Other values (3)	15000	15.8%

Space Separator

Value	Count	Frequency (%)
	15000	100.0%

Uppercase Letter

Value	Count	Frequency (%)
B	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	100000	87.0%
Common	15000	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	20000	20.0%
o	10000	10.0%
r	10000	10.0%
i	10000	10.0%
d	5000	5.0%
a	5000	5.0%
s	5000	5.0%
p	5000	5.0%
e	5000	5.0%
m	5000	5.0%
Other values (4)	20000	20.0%

Common

Value	Count	Frequency (%)
	15000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	20000	17.4%
	15000	13.0%
o	10000	8.7%
r	10000	8.7%
i	10000	8.7%
d	5000	4.3%
a	5000	4.3%
s	5000	4.3%
p	5000	4.3%
e	5000	4.3%
Other values (5)	25000	21.7%

sulfur-content
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	108
Distinct (%)	2.3%
Missing	296
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.110369898

Minimum	0
Maximum	5.97
Zeros	4124
Zeros (%)	82.5%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.56
Maximum	5.97
Range	5.97
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4374718013
Coefficient of variation (CV)	3.963687649
Kurtosis	46.78806073
Mean	0.110369898
Median Absolute Deviation (MAD)	0
Skewness	6.059612427
Sum	519.18
Variance	0.1913815769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4124	82.5%
0.36	35	0.7%
0.56	31	0.6%
0.16	25	0.5%
0.31	25	0.5%
0.23	22	0.4%
0.6	19	0.4%
0.37	19	0.4%
0.47	19	0.4%
0.35	17	0.3%
Other values (98)	368	7.4%
(Missing)	296	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4124	82.5%
0.01	1	< 0.1%
0.05	1	< 0.1%
0.06	2	< 0.1%
0.15	2	< 0.1%
0.16	25	0.5%
0.18	3	0.1%
0.2	1	< 0.1%
0.21	4	0.1%
0.22	15	0.3%

Value	Count	Frequency (%)
5.97	2	< 0.1%
5.6	2	< 0.1%
5.04	1	< 0.1%
3.65	1	< 0.1%
3.5	3	0.1%
3.46	2	< 0.1%
3.35	1	< 0.1%
3.04	1	< 0.1%
3.01	2	< 0.1%
2.99	2	< 0.1%

sulfur-content-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

percent	5000

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	35000
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
percent	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
percent	5000	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35000	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

ash-content
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	135
Distinct (%)	2.9%
Missing	296
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.9578210034

Minimum	0
Maximum	47.82
Zeros	4198
Zeros (%)	84.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	8.4
Maximum	47.82
Range	47.82
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.321255951
Coefficient of variation (CV)	3.467512134
Kurtosis	56.09616618
Mean	0.9578210034
Median Absolute Deviation (MAD)	0
Skewness	5.916554665
Sum	4505.59
Variance	11.03074109
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4198	84.0%
7	28	0.6%
8.1	28	0.6%
9.38	27	0.5%
9.7	22	0.4%
5.8	14	0.3%
5.21	12	0.2%
5.2	12	0.2%
6.37	12	0.2%
7.95	11	0.2%
Other values (125)	340	6.8%
(Missing)	296	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4198	84.0%
0.26	1	< 0.1%
0.28	2	< 0.1%
0.3	4	0.1%
0.6	2	< 0.1%
1.22	1	< 0.1%
3.85	1	< 0.1%
4.65	1	< 0.1%
4.67	1	< 0.1%
4.72	1	< 0.1%

Value	Count	Frequency (%)
47.82	1	< 0.1%
46.06	2	< 0.1%
45.26	1	< 0.1%
44.98	1	< 0.1%
42.8	1	< 0.1%
41.6	1	< 0.1%
37.38	1	< 0.1%
29.4	1	< 0.1%
28.89	1	< 0.1%
24.22	2	< 0.1%

ash-content-units
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

percent	5000

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	35000
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
percent	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
percent	5000	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35000	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10000	28.6%
p	5000	14.3%
r	5000	14.3%
c	5000	14.3%
n	5000	14.3%
t	5000	14.3%

heat-content
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	901
Distinct (%)	19.2%
Missing	296
Missing (%)	5.9%
Infinite	0
Infinite (%)	0.0%
Mean	3.505200787

Minimum	0
Maximum	34.18
Zeros	2556
Zeros (%)	51.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5.6052
95-th percentile	20.197455
Maximum	34.18
Range	34.18
Interquartile range (IQR)	5.6052

Descriptive statistics

Standard deviation	6.491138629
Coefficient of variation (CV)	1.851859287
Kurtosis	3.711196369
Mean	3.505200787
Median Absolute Deviation (MAD)	0
Skewness	2.132350499
Sum	16488.4645
Variance	42.1348807
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2556	51.1%
0.484	42	0.8%
5.8	38	0.8%
22.852	23	0.5%
21.5	20	0.4%
0.487	18	0.4%
15	17	0.3%
5.762	17	0.3%
1.029	17	0.3%
6	15	0.3%
Other values (891)	1941	38.8%
(Missing)	296	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2556	51.1%
0.1072	1	< 0.1%
0.1361	1	< 0.1%
0.154	3	0.1%
0.1724	1	< 0.1%
0.1759	1	< 0.1%
0.254	1	< 0.1%
0.2575	1	< 0.1%
0.2717	1	< 0.1%
0.2815	1	< 0.1%

Value	Count	Frequency (%)
34.18	2	< 0.1%
31.61	1	< 0.1%
30.738	3	0.1%
30.366	2	< 0.1%
30	1	< 0.1%
29.9251	2	< 0.1%
29.521	1	< 0.1%
29.4921	1	< 0.1%
29.4805	1	< 0.1%
29.25	2	< 0.1%

heat-content-units
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Btu per physical units	3117
Btu per short tons	951
Btu per barrels	477
Btu per Mcf	455

Length

Max length	22
Median length	22
Mean length	19.5704
Min length	11

Characters and Unicode

Total characters	97852
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Btu per physical units
2nd row	Btu per physical units
3rd row	Btu per short tons
4th row	Btu per short tons
5th row	Btu per short tons

Common Values

Value	Count	Frequency (%)
Btu per physical units	3117	62.3%
Btu per short tons	951	19.0%
Btu per barrels	477	9.5%
Btu per Mcf	455	9.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
btu	5000	26.2%
per	5000	26.2%
physical	3117	16.3%
units	3117	16.3%
short	951	5.0%
tons	951	5.0%
barrels	477	2.5%
mcf	455	2.4%

Most occurring characters

Value	Count	Frequency (%)
	14068	14.4%
t	10019	10.2%
s	8613	8.8%
u	8117	8.3%
p	8117	8.3%
r	6905	7.1%
i	6234	6.4%
e	5477	5.6%
B	5000	5.1%
h	4068	4.2%
Other values (9)	21234	21.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	78329	80.0%
Space Separator	14068	14.4%
Uppercase Letter	5455	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	10019	12.8%
s	8613	11.0%
u	8117	10.4%
p	8117	10.4%
r	6905	8.8%
i	6234	8.0%
e	5477	7.0%
h	4068	5.2%
n	4068	5.2%
a	3594	4.6%
Other values (6)	13117	16.7%

Uppercase Letter

Value	Count	Frequency (%)
B	5000	91.7%
M	455	8.3%

Space Separator

Value	Count	Frequency (%)
	14068	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	83784	85.6%
Common	14068	14.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	10019	12.0%
s	8613	10.3%
u	8117	9.7%
p	8117	9.7%
r	6905	8.2%
i	6234	7.4%
e	5477	6.5%
B	5000	6.0%
h	4068	4.9%
n	4068	4.9%
Other values (8)	17166	20.5%

Common

Value	Count	Frequency (%)
	14068	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	97852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14068	14.4%
t	10019	10.2%
s	8613	8.8%
u	8117	8.3%
p	8117	8.3%
r	6905	7.1%
i	6234	6.4%
e	5477	5.6%
B	5000	5.1%
h	4068	4.2%
Other values (9)	21234	21.7%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

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.

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.

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.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Unnamed: 0	period	location	stateDescription	sectorid	sectorDescription	fueltypeid	fuelTypeDescription	generation	generation-units	total-consumption	total-consumption-units	consumption-for-eg	consumption-for-eg-units	consumption-uto	consumption-uto-units	total-consumption-btu	total-consumption-btu-units	consumption-for-eg-btu	consumption-for-eg-btu-units	consumption-uto-btu	consumption-uto-btu-units	stocks	stocks-units	receipts	receipts-units	receipts-btu	receipts-btu-units	cost	cost-units	cost-per-btu	cost-per-btu-units	sulfur-content	sulfur-content-units	ash-content	ash-content-units	heat-content	heat-content-units
0	0	2021-06	SD	South Dakota	98	Electric Power	AOR	all renewables	660.11939	thousand megawatthours	0.000	thousand physical units	0.000	thousand physical units	0.000	thousand physical units	5.79123	million MMBtu	5.79123	million MMBtu	0.00000	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	0.00	percent	0.0	percent	0.0000	Btu per physical units
1	1	2021-06	SD	South Dakota	98	Electric Power	BIO	biomass	0.00000	thousand megawatthours	0.000	thousand physical units	0.000	thousand physical units	0.000	thousand physical units	0.00000	million MMBtu	0.00000	million MMBtu	0.00000	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	0.00	percent	0.0	percent	0.0000	Btu per physical units
2	2	2021-06	SD	South Dakota	98	Electric Power	COL	coal, excluding waste coal	205.22798	thousand megawatthours	134.827	thousand short tons	128.908	thousand short tons	5.919	thousand short tons	2.21143	million MMBtu	2.11434	million MMBtu	0.09709	million MMBtu	NaN	thousand short tons	103.693	thousand short tons	1705.54246	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	0.84	percent	5.2	percent	16.4020	Btu per short tons
3	3	2021-06	SD	South Dakota	98	Electric Power	COW	all coal products	205.22798	thousand megawatthours	134.827	thousand short tons	128.908	thousand short tons	5.919	thousand short tons	2.21143	million MMBtu	2.11434	million MMBtu	0.09709	million MMBtu	NaN	thousand short tons	103.693	thousand short tons	1705.54246	billion Btu	30.02	dollars per short tons	1.825	dollars per million Btu	0.84	percent	5.2	percent	16.4020	Btu per short tons
4	4	2021-06	SD	South Dakota	98	Electric Power	DFO	distillate fuel oil	NaN	thousand megawatthours	NaN	thousand short tons	NaN	thousand short tons	NaN	thousand short tons	NaN	million MMBtu	NaN	million MMBtu	NaN	million MMBtu	NaN	thousand short tons	1.191	thousand short tons	7.14600	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	0.00	percent	0.0	percent	6.0000	Btu per short tons
5	5	2021-06	SD	South Dakota	98	Electric Power	FOS	fossil fuels	377.34304	thousand megawatthours	0.000	thousand physical units	0.000	thousand physical units	0.000	thousand physical units	3.68633	million MMBtu	3.58921	million MMBtu	0.09712	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	2074.31449	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	0.84	percent	5.2	percent	0.0000	Btu per physical units
6	6	2021-07	WSC	West South Central	2	IPP Non-CHP	BIO	biomass	38.23158	thousand megawatthours	827.170	thousand physical units	827.170	thousand physical units	0.000	thousand physical units	0.49172	million MMBtu	0.49172	million MMBtu	0.00000	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	0.00	percent	0.0	percent	0.5945	Btu per physical units
7	7	2021-07	WSC	West South Central	2	IPP Non-CHP	COL	coal, excluding waste coal	6850.71606	thousand megawatthours	4704.249	thousand short tons	4704.249	thousand short tons	0.000	thousand short tons	73.48206	million MMBtu	73.48206	million MMBtu	0.00000	million MMBtu	NaN	thousand short tons	3539.209	thousand short tons	55362.90043	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	0.50	percent	8.7	percent	15.6204	Btu per short tons
8	8	2021-07	WSC	West South Central	2	IPP Non-CHP	COW	all coal products	6850.71606	thousand megawatthours	4704.249	thousand short tons	4704.249	thousand short tons	0.000	thousand short tons	73.48206	million MMBtu	73.48206	million MMBtu	0.00000	million MMBtu	NaN	thousand short tons	3539.209	thousand short tons	55362.90043	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	0.50	percent	8.7	percent	15.6204	Btu per short tons
9	9	2021-07	WSC	West South Central	2	IPP Non-CHP	DFO	distillate fuel oil	0.51471	thousand megawatthours	0.966	thousand short tons	0.966	thousand short tons	0.000	thousand short tons	0.00562	million MMBtu	0.00562	million MMBtu	0.00000	million MMBtu	NaN	thousand short tons	1.048	thousand short tons	6.07840	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	0.00	percent	0.0	percent	5.8137	Btu per short tons

Last rows

	Unnamed: 0	period	location	stateDescription	sectorid	sectorDescription	fueltypeid	fuelTypeDescription	generation	generation-units	total-consumption	total-consumption-units	consumption-for-eg	consumption-for-eg-units	consumption-uto	consumption-uto-units	total-consumption-btu	total-consumption-btu-units	consumption-for-eg-btu	consumption-for-eg-btu-units	consumption-uto-btu	consumption-uto-btu-units	stocks	stocks-units	receipts	receipts-units	receipts-btu	receipts-btu-units	cost	cost-units	cost-per-btu	cost-per-btu-units	sulfur-content-units	ash-content-units	heat-content	heat-content-units
4990	4990	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	OBW	biomass	12.75888	thousand megawatthours	29.334	thousand physical units	29.334	thousand physical units	0.0	thousand physical units	0.22252	million MMBtu	0.22252	million MMBtu	0.0	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	7.5856	Btu per physical units
4991	4991	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	ORW	other renewables	NaN	thousand megawatthours	NaN	thousand physical units	NaN	thousand physical units	NaN	thousand physical units	NaN	million MMBtu	NaN	million MMBtu	NaN	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	0.0000	Btu per physical units
4992	4992	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	OTH	other	15.29219	thousand megawatthours	19.446	thousand physical units	19.446	thousand physical units	0.0	thousand physical units	0.27159	million MMBtu	0.27159	million MMBtu	0.0	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	13.9663	Btu per physical units
4993	4993	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	PEL	petroleum liquids	3.08829	thousand megawatthours	6.906	thousand barrels	6.906	thousand barrels	0.0	thousand barrels	0.04032	million MMBtu	0.04032	million MMBtu	0.0	million MMBtu	657.514	thousand barrels	13.489	thousand barrels	78.14038	billion Btu	NaN	dollars per barrels	NaN	dollars per million Btu	percent	percent	5.8379	Btu per barrels
4994	4994	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	PET	petroleum	3.08829	thousand megawatthours	6.906	thousand barrels	6.906	thousand barrels	0.0	thousand barrels	0.04032	million MMBtu	0.04032	million MMBtu	0.0	million MMBtu	NaN	thousand barrels	13.489	thousand barrels	78.14038	billion Btu	NaN	dollars per barrels	NaN	dollars per million Btu	percent	percent	5.8379	Btu per barrels
4995	4995	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	RC	refined coal	0.00000	thousand megawatthours	0.000	thousand short tons	0.000	thousand short tons	0.0	thousand short tons	0.00000	million MMBtu	0.00000	million MMBtu	0.0	million MMBtu	NaN	thousand short tons	0.000	thousand short tons	0.00000	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	percent	percent	0.0000	Btu per short tons
4996	4996	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	REN	renewable	287.15675	thousand megawatthours	108.551	thousand physical units	108.551	thousand physical units	0.0	thousand physical units	2.63622	million MMBtu	2.63622	million MMBtu	0.0	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	2.4031	Btu per physical units
4997	4997	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	RFO	residual fuel oil	NaN	thousand megawatthours	NaN	thousand short tons	NaN	thousand short tons	NaN	thousand short tons	NaN	million MMBtu	NaN	million MMBtu	NaN	million MMBtu	NaN	thousand short tons	0.000	thousand short tons	0.00000	billion Btu	NaN	dollars per short tons	NaN	dollars per million Btu	percent	percent	5.9700	Btu per short tons
4998	4998	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	SPV	solar photovoltaic	50.84164	thousand megawatthours	0.000	thousand physical units	0.000	thousand physical units	0.0	thousand physical units	0.44603	million MMBtu	0.44603	million MMBtu	0.0	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	0.0000	Btu per physical units
4999	4999	2021-10	MD	Maryland	90	Electric Power Sector Non-CHP	SUN	solar	50.84164	thousand megawatthours	0.000	thousand physical units	0.000	thousand physical units	0.0	thousand physical units	0.44603	million MMBtu	0.44603	million MMBtu	0.0	million MMBtu	NaN	thousand physical units	0.000	thousand physical units	0.00000	billion Btu	NaN	dollars per physical units	NaN	dollars per million Btu	percent	percent	0.0000	Btu per physical units

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category