HW2_withGITcall
knitr::opts_chunk$set(echo = TRUE)
require(readr)## Loading required package: readrrequire(dplyr)## Loading required package: dplyr##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionrequire(RCurl)## Loading required package: RCurlurlfile="https://raw.githubusercontent.com/schmalmr/Project_2_Aug2021/main/CapacityData.csv"
dataimport<-read_csv(url(urlfile))## New names:
## * `` -> ...44## Rows: 7867 Columns: 44## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (4): REFINERY NAME, Country, REFINERY_UNIT, CURRENT OPERATOR
## lgl (1): ...44##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.dataimport## # A tibble: 7,867 × 44
## `REFINERY NAME` Country REFINERY_UNIT `CURRENT OPERATOR` `2017 Q1` `2017 Q2`
## <chr> <chr> <chr> <chr> <dbl> <dbl>
## 1 Texas City United … Alkylation-HF Marathon Petroleu… 13.8 13.8
## 2 Mt. Vernon United … Alkylation-HF Countrymark Coope… 1.98 1.98
## 3 Ciudad Madero Mexico Alkylation-HF Petroleos Mexican… 5.11 5.11
## 4 Corpus Christi United … Alkylation-HF Flint Hills Resou… 14 14
## 5 Schwedt Germany Alkylation-HF PCK Raffinerie Gm… 9.48 9.48
## 6 Aghii Theodori Greece Alkylation-HF Motor Oil (Hellas… 2.4 2.4
## 7 Great Falls United … Alkylation-HF Calumet Specialty… 0.9 0.9
## 8 Alliance United … Alkylation-HF Phillips 66 34.2 34.2
## 9 Sweeny United … Alkylation-HF Phillips 66 19.5 19.5
## 10 Szazhalombatta Hungary Alkylation-HF MOL Magyar Olaj- … 3.3 3.3
## # … with 7,857 more rows, and 38 more variables: 2017 Q3 <dbl>, 2017 Q4 <dbl>,
## # 2018 Q1 <dbl>, 2018 Q2 <dbl>, 2018 Q3 <dbl>, 2018 Q4 <dbl>, 2019 Q1 <dbl>,
## # 2019 Q2 <dbl>, 2019 Q3 <dbl>, 2019 Q4 <dbl>, 2020 Q1 <dbl>, 2020 Q2 <dbl>,
## # 2020 Q3 <dbl>, 2020 Q4 <dbl>, 2021 Q1 <dbl>, 2021 Q2 <dbl>, 2021 Q3 <dbl>,
## # 2021 Q4 <dbl>, 2022 Q1 <dbl>, 2022 Q2 <dbl>, 2022 Q3 <dbl>, 2022 Q4 <dbl>,
## # 2023 Q1 <dbl>, 2023 Q2 <dbl>, 2023 Q3 <dbl>, 2023 Q4 <dbl>, 2024 Q1 <dbl>,
## # 2024 Q2 <dbl>, 2024 Q3 <dbl>, 2024 Q4 <dbl>, 2025 Q1 <dbl>, …# Import the data set via CSV reader of file into the Import Data Set
#dataimport=data.frame(Capacity_Database_Excel_Export_Table_1)
# Run the summary function on the dataimport for all unit operations capacity, locations and firms vs Quarter. Display all the DataImport (DI) summary data to includ the average mean and median by quarter and year.
DIsummary<-summary(dataimport)
DIsummary## REFINERY NAME Country REFINERY_UNIT CURRENT OPERATOR
## Length:7867 Length:7867 Length:7867 Length:7867
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
##
## 2017 Q1 2017 Q2 2017 Q3 2017 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 25.60 Median : 25.50 Median : 25.65 Median : 25.68
## Mean : 87.88 Mean : 87.70 Mean : 87.91 Mean : 88.12
## 3rd Qu.: 60.00 3rd Qu.: 60.00 3rd Qu.: 60.00 3rd Qu.: 60.00
## Max. :7020.00 Max. :7020.00 Max. :7020.00 Max. :7020.00
## NA's :906 NA's :906 NA's :883 NA's :883
## 2018 Q1 2018 Q2 2018 Q3 2018 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 25.89 Median : 25.89 Median : 26.00 Median : 26.00
## Mean : 89.85 Mean : 89.84 Mean : 89.88 Mean : 89.75
## 3rd Qu.: 60.00 3rd Qu.: 60.00 3rd Qu.: 60.00 3rd Qu.: 60.40
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :864 NA's :856 NA's :834 NA's :846
## 2019 Q1 2019 Q2 2019 Q3 2019 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.010 Min. : 0.01
## 1st Qu.: 9.79 1st Qu.: 9.80 1st Qu.: 9.873 1st Qu.: 10.00
## Median : 25.20 Median : 25.31 Median : 25.360 Median : 25.65
## Mean : 87.18 Mean : 87.49 Mean : 87.551 Mean : 88.11
## 3rd Qu.: 60.00 3rd Qu.: 60.00 3rd Qu.: 60.000 3rd Qu.: 60.00
## Max. :9090.00 Max. :9090.00 Max. :9090.000 Max. :9090.00
## NA's :544 NA's :523 NA's :535 NA's :512
## 2020 Q1 2020 Q2 2020 Q3 2020 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 26.10 Median : 26.30 Median : 26.50 Median : 26.50
## Mean : 88.75 Mean : 88.95 Mean : 89.22 Mean : 89.00
## 3rd Qu.: 60.40 3rd Qu.: 60.65 3rd Qu.: 61.00 3rd Qu.: 61.00
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :497 NA's :499 NA's :542 NA's :576
## 2021 Q1 2021 Q2 2021 Q3 2021 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 26.55 Median : 27.00 Median : 27.00 Median : 27.00
## Mean : 89.01 Mean : 89.87 Mean : 90.36 Mean : 90.38
## 3rd Qu.: 61.00 3rd Qu.: 62.00 3rd Qu.: 62.03 3rd Qu.: 62.01
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :574 NA's :598 NA's :579 NA's :576
## 2022 Q1 2022 Q2 2022 Q3 2022 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 27.00 Median : 27.00 Median : 27.00 Median : 27.00
## Mean : 90.97 Mean : 91.25 Mean : 91.23 Mean : 91.26
## 3rd Qu.: 62.20 3rd Qu.: 62.50 3rd Qu.: 62.50 3rd Qu.: 62.50
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :559 NA's :554 NA's :550 NA's :546
## 2023 Q1 2023 Q2 2023 Q3 2023 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 27.00 Median : 27.00 Median : 27.00 Median : 27.00
## Mean : 91.23 Mean : 91.38 Mean : 91.53 Mean : 91.91
## 3rd Qu.: 62.72 3rd Qu.: 63.00 3rd Qu.: 63.20 3rd Qu.: 63.67
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :528 NA's :504 NA's :487 NA's :469
## 2024 Q1 2024 Q2 2024 Q3 2024 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.01 Min. : 0.01
## 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00 1st Qu.: 10.00
## Median : 27.10 Median : 27.10 Median : 27.10 Median : 27.10
## Mean : 91.89 Mean : 91.90 Mean : 91.90 Mean : 91.90
## 3rd Qu.: 63.99 3rd Qu.: 64.00 3rd Qu.: 64.00 3rd Qu.: 64.00
## Max. :9090.00 Max. :9090.00 Max. :9090.00 Max. :9090.00
## NA's :445 NA's :443 NA's :443 NA's :443
## 2025 Q1 2025 Q2 2025 Q3 2025 Q4
## Min. : 0.01 Min. : 0.01 Min. : 0.0 Min. : 0.0
## 1st Qu.: 10.08 1st Qu.: 10.10 1st Qu.: 10.1 1st Qu.: 10.1
## Median : 27.25 Median : 27.30 Median : 27.2 Median : 27.3
## Mean : 92.16 Mean : 92.21 Mean : 245.2 Mean : 245.0
## 3rd Qu.: 64.00 3rd Qu.: 64.09 3rd Qu.: 64.3 3rd Qu.: 64.6
## Max. :9090.00 Max. :9090.00 Max. :800000.0 Max. :800000.0
## NA's :435 NA's :431 NA's :421 NA's :410
## 2026 Q1 2026 Q2 2026 Q3 ...44
## Min. : 0.0 Min. : 0.0 Min. : 0.0 Mode:logical
## 1st Qu.: 10.1 1st Qu.: 10.1 1st Qu.: 10.1 NA's:7867
## Median : 27.3 Median : 27.4 Median : 27.4
## Mean : 245.0 Mean : 244.8 Mean : 244.8
## 3rd Qu.: 64.8 3rd Qu.: 64.8 3rd Qu.: 64.8
## Max. :800000.0 Max. :800000.0 Max. :800000.0
## NA's :406 NA's :394 NA's :394# Select specific columns and key fields
Country<-select(dataimport, contains ("Country"))
Refineryunit<-select( dataimport,contains ("Refinery_Unit"))
Operator<-select(dataimport,contains("Current Operator"))
# Shorten the dataset by selecting only the Quarter 4 (Q4) columns for the updated unit operation capacity data - extract columns
FCCtableQ4<- select(dataimport,ends_with ("Q4"))
FCCtable<-bind_cols(Refineryunit,Operator,Country,FCCtableQ4)
FCCtable<-data.frame(FCCtable)
# Filter rows for Refineryunit as "CCU_Fluid" for the Fluidized Catalytic Cracking Units
FCCtable<-filter(FCCtable,Refineryunit=="CCU-Fluid")
# original column names
colnames(FCCtable)## [1] "REFINERY_UNIT" "CURRENT.OPERATOR" "Country" "X2017.Q4"
## [5] "X2018.Q4" "X2019.Q4" "X2020.Q4" "X2021.Q4"
## [9] "X2022.Q4" "X2023.Q4" "X2024.Q4" "X2025.Q4"# new column names and renaming of columns
# rename(FCCtable, new name = old name)
FCCtable<-rename(FCCtable,UnitOperation=REFINERY_UNIT)
FCCtable<-rename(FCCtable,Company=CURRENT.OPERATOR)
FCCtable<-rename(FCCtable,Location=Country)
colnames(FCCtable)## [1] "UnitOperation" "Company" "Location" "X2017.Q4"
## [5] "X2018.Q4" "X2019.Q4" "X2020.Q4" "X2021.Q4"
## [9] "X2022.Q4" "X2023.Q4" "X2024.Q4" "X2025.Q4"# Summary function for FCCtable and display the table to allow comparison of Q4 data
FCCresultssummary<-summary(FCCtable)
FCCresultssummary## UnitOperation Company Location X2017.Q4
## Length:385 Length:385 Length:385 Min. : 2.00
## Class :character Class :character Class :character 1st Qu.: 22.30
## Mode :character Mode :character Mode :character Median : 36.44
## Mean : 44.53
## 3rd Qu.: 57.00
## Max. :218.70
## NA's :40
## X2018.Q4 X2019.Q4 X2020.Q4 X2021.Q4
## Min. : 2.00 Min. : 2.00 Min. : 2.00 Min. : 2.00
## 1st Qu.: 22.50 1st Qu.: 22.00 1st Qu.: 22.95 1st Qu.: 22.73
## Median : 36.80 Median : 36.08 Median : 37.05 Median : 37.30
## Mean : 44.74 Mean : 43.60 Mean : 44.73 Mean : 44.74
## 3rd Qu.: 56.70 3rd Qu.: 54.90 3rd Qu.: 56.10 3rd Qu.: 56.10
## Max. :218.70 Max. :218.70 Max. :232.50 Max. :232.50
## NA's :43 NA's :17 NA's :25 NA's :25
## X2022.Q4 X2023.Q4 X2024.Q4 X2025.Q4
## Min. : 2.00 Min. : 2.00 Min. : 2.00 Min. : 2.00
## 1st Qu.: 22.80 1st Qu.: 22.80 1st Qu.: 23.00 1st Qu.: 23.00
## Median : 37.50 Median : 37.50 Median : 37.65 Median : 37.80
## Mean : 44.69 Mean : 44.68 Mean : 44.76 Mean : 44.75
## 3rd Qu.: 55.80 3rd Qu.: 55.80 3rd Qu.: 55.77 3rd Qu.: 55.80
## Max. :232.50 Max. :232.50 Max. :232.50 Max. :232.50
## NA's :24 NA's :24 NA's :23 NA's :20# Use FCCtable to replace values in the column UnitOperation
# Replace all CCU-Fluid with FCC Unit; (or Fluidized Catalytic Cracking Unit)
# Update operating company names: Tessoro was purchased by Andeavor and then by Marathon (move to Marathon) and shorten the Royal Dutch Shell plc name to Shell.
FCCtable_Colvaluereplacement<-FCCtable $Company[FCCtable $Company==("Tesoro Corporation")]<-"Marathon Petroleum Corporation"
FCCtable_Colvaluereplacement<-FCCtable $Company[FCCtable $Company==("Royal Dutch Shell plc")]<-"Shell"
FCCtable_Colvaluereplacement<-FCCtable $UnitOperation[FCCtable $UnitOperation==("CCU-Fluid")]<-"FCC Unit"
# Order the dataframe FCCtable on column 2 which has the refinery name so we have a alphabetical listing by company or refinery parent. Display full table to show first column update and to see the updates to eliminate Tessoro (as now Marathon units) and to shorten the Royal Dutch Shell name to Shell
FCCtable<-FCCtable [order (FCCtable [,2]),]
FCCtable## UnitOperation Company
## 177 FCC Unit Agip Petroleum Exploration Co. Inc.
## 111 FCC Unit Alon USA Energy, Inc.
## 197 FCC Unit Alon USA Energy, Inc.
## 216 FCC Unit Ampol
## 207 FCC Unit ANCAP
## 171 FCC Unit Axion Energy
## 139 FCC Unit Bahrain Petroleum Company B.S.C.
## 179 FCC Unit Baota Lingzhou Petrochemical
## 330 FCC Unit Bashneft
## 336 FCC Unit Bashneft
## 96 FCC Unit Bayernoil GmbH
## 325 FCC Unit Befar Binyang Petrochemical
## 17 FCC Unit Beili Petrochemical
## 9 FCC Unit Bharat Petroleum Corporation Limited
## 144 FCC Unit Bharat Petroleum Corporation Limited
## 252 FCC Unit Blue Star Petrochemical
## 59 FCC Unit BP plc
## 102 FCC Unit BP plc
## 211 FCC Unit BP plc
## 236 FCC Unit BP plc
## 353 FCC Unit BP plc
## 29 FCC Unit Byco Petroleum Pakistan Limited
## 114 FCC Unit Calumet Specialty Products Partners LP
## 267 FCC Unit Calumet Specialty Products Partners LP
## 244 FCC Unit Carlyle Group
## 260 FCC Unit Cenex Harvest States Cooperatives
## 305 FCC Unit Chennai Petroleum Corp. Ltd. (CPCL) Madras Refinery Ltd.
## 8 FCC Unit Chevron Corporation
## 84 FCC Unit Chevron Corporation
## 202 FCC Unit Chevron Corporation
## 222 FCC Unit Chevron Corporation
## 255 FCC Unit Chevron Corporation
## 303 FCC Unit Chevron Corporation
## 44 FCC Unit China National Chemical Corporation
## 64 FCC Unit China National Chemical Corporation
## 66 FCC Unit China National Chemical Corporation
## 135 FCC Unit China National Chemical Corporation
## 319 FCC Unit China National Chemical Corporation
## 11 FCC Unit China Petroleum & Chemical Corporation
## 23 FCC Unit China Petroleum & Chemical Corporation
## 24 FCC Unit China Petroleum & Chemical Corporation
## 33 FCC Unit China Petroleum & Chemical Corporation
## 43 FCC Unit China Petroleum & Chemical Corporation
## 65 FCC Unit China Petroleum & Chemical Corporation
## 69 FCC Unit China Petroleum & Chemical Corporation
## 71 FCC Unit China Petroleum & Chemical Corporation
## 83 FCC Unit China Petroleum & Chemical Corporation
## 92 FCC Unit China Petroleum & Chemical Corporation
## 98 FCC Unit China Petroleum & Chemical Corporation
## 116 FCC Unit China Petroleum & Chemical Corporation
## 145 FCC Unit China Petroleum & Chemical Corporation
## 152 FCC Unit China Petroleum & Chemical Corporation
## 158 FCC Unit China Petroleum & Chemical Corporation
## 161 FCC Unit China Petroleum & Chemical Corporation
## 170 FCC Unit China Petroleum & Chemical Corporation
## 182 FCC Unit China Petroleum & Chemical Corporation
## 218 FCC Unit China Petroleum & Chemical Corporation
## 243 FCC Unit China Petroleum & Chemical Corporation
## 264 FCC Unit China Petroleum & Chemical Corporation
## 268 FCC Unit China Petroleum & Chemical Corporation
## 276 FCC Unit China Petroleum & Chemical Corporation
## 314 FCC Unit China Petroleum & Chemical Corporation
## 324 FCC Unit China Petroleum & Chemical Corporation
## 354 FCC Unit China Petroleum & Chemical Corporation
## 384 FCC Unit China Petroleum & Chemical Corporation
## 263 FCC Unit Citgo Petroleum Corp.
## 320 FCC Unit Citgo Petroleum Corp.
## 352 FCC Unit Citgo Petroleum Corp.
## 100 FCC Unit CNOOC Limited
## 200 FCC Unit CNOOC Limited
## 221 FCC Unit CNOOC Limited
## 51 FCC Unit Compania Espanola de Petroleos S.A.
## 315 FCC Unit Compania Espanola de Petroleos S.A.
## 245 FCC Unit Consumer Cooperatives Refineries Ltd.
## 157 FCC Unit Cosmo Oil Co. Ltd.
## 181 FCC Unit Cosmo Oil Co. Ltd.
## 298 FCC Unit Cosmo Oil Co. Ltd.
## 191 FCC Unit Countrymark Cooperative, LLP
## 294 FCC Unit Cubapetroleo S.A
## 70 FCC Unit CVR Energy, Inc.
## 115 FCC Unit CVR Energy, Inc.
## 86 FCC Unit Daqing Petrochemical
## 168 FCC Unit Delek US Holdings, Inc.
## 299 FCC Unit Delek US Holdings, Inc.
## 186 FCC Unit Dongfang Hualong Group
## 311 FCC Unit Dongming Petrochemical
## 162 FCC Unit Dongying Yatong Petrochemical Co Ltd
## 313 FCC Unit Dongyou Bitumen
## 187 FCC Unit Ecopetrol S.A.
## 196 FCC Unit Ecopetrol S.A.
## 180 FCC Unit Empresa Nacional del Petroleo
## 183 FCC Unit Empresa Nacional del Petroleo
## 375 FCC Unit Empresa Publica Petroecuador
## 22 FCC Unit ENEOS Corporation
## 198 FCC Unit ENEOS Corporation
## 15 FCC Unit Eni S.p.A.
## 12 FCC Unit Essar Energy plc
## 285 FCC Unit Esso (Thailand) Public Co. Ltd.
## 46 FCC Unit Exxon Mobil Corporation
## 76 FCC Unit Exxon Mobil Corporation
## 87 FCC Unit Exxon Mobil Corporation
## 93 FCC Unit Exxon Mobil Corporation
## 143 FCC Unit Exxon Mobil Corporation
## 156 FCC Unit Exxon Mobil Corporation
## 210 FCC Unit Exxon Mobil Corporation
## 248 FCC Unit Exxon Mobil Corporation
## 283 FCC Unit Exxon Mobil Corporation
## 351 FCC Unit Exxon Mobil Corporation
## 113 FCC Unit Fina Petroleos de Angola
## 205 FCC Unit FJ Management Inc.
## 109 FCC Unit Flint Hills Resources
## 128 FCC Unit Flint Hills Resources
## 346 FCC Unit Formosa Chemical & Fiber Corp.
## 129 FCC Unit Fuji Oil Company Ltd.
## 219 FCC Unit Fujian Petrochemical Co Ltd
## 72 FCC Unit Galp Energia SGPS SA
## 103 FCC Unit Gazprom Neft
## 277 FCC Unit Gazprom Neft
## 366 FCC Unit Gazprom, OAO
## 132 FCC Unit Government
## 282 FCC Unit GS Caltex Corp.
## 301 FCC Unit Guangda Chemical Industry Co
## 37 FCC Unit Gunvor
## 34 FCC Unit HaiKe Chemical Group Limited
## 322 FCC Unit Hebei Dagang Petrochemical
## 35 FCC Unit Hellenic Petroleum SA
## 270 FCC Unit Hengyuan Petrochemical
## 56 FCC Unit Hindustan Petroleum Co. Ltd.
## 344 FCC Unit Hindustan Petroleum Co. Ltd.
## 1 FCC Unit Holborn Europa Raffinerie GmbH
## 10 FCC Unit HollyFrontier Corporation
## 47 FCC Unit HollyFrontier Corporation
## 225 FCC Unit HollyFrontier Corporation
## 286 FCC Unit HollyFrontier Corporation
## 381 FCC Unit HollyFrontier Corporation
## 342 FCC Unit Hongrun Petrochemical Additive
## 363 FCC Unit HPCL Rajasthan Refinery Limited (HRRL)
## 372 FCC Unit HPCL-Mittal Energy Limited
## 230 FCC Unit Hualian Petrochemical
## 194 FCC Unit Husky Energy Incorporated
## 373 FCC Unit Husky Energy Incorporated
## 213 FCC Unit Idemitsu Kosan Co., Ltd.
## 27 FCC Unit Imperial Oil Ltd
## 164 FCC Unit Imperial Oil Ltd
## 176 FCC Unit Imperial Oil Ltd
## 19 FCC Unit INA-Naftaplin
## 134 FCC Unit INA-Naftaplin
## 266 FCC Unit Independents
## 321 FCC Unit Independents
## 32 FCC Unit Indian Oil Corporation Limited
## 185 FCC Unit Indian Oil Corporation Limited
## 204 FCC Unit Indian Oil Corporation Limited
## 224 FCC Unit Indian Oil Corporation Limited
## 334 FCC Unit Indian Oil Corporation Limited
## 89 FCC Unit Ineos Group Holdings Plc
## 120 FCC Unit Ineos Group Holdings Plc
## 273 FCC Unit IRPC Public Co. Ltd.
## 126 FCC Unit Irving Oil Limited
## 278 FCC Unit Island Energy Services LLC
## 238 FCC Unit Jincheng Petrochemical
## 18 FCC Unit Jingbo Petrochemical
## 124 FCC Unit Jordan Petroleum Refinery
## 57 FCC Unit JX Nippon Oil & Energy Corporation
## 153 FCC Unit JX Nippon Oil & Energy Corporation
## 339 FCC Unit JX Nippon Oil & Energy Corporation
## 104 FCC Unit Kashima Oil Co Ltd
## 107 FCC Unit Kazmunaigaz
## 359 FCC Unit Kazmunaigaz
## 256 FCC Unit Kenli Petrochemical
## 141 FCC Unit Kuwait Petroleum Corporation
## 379 FCC Unit Lihuayi
## 36 FCC Unit Lukoil
## 97 FCC Unit Lukoil
## 333 FCC Unit Lukoil
## 228 FCC Unit LyondellBasell Industries N.V.
## 360 FCC Unit Mangalore Refinery and Petrochemicals Ltd
## 5 FCC Unit Marathon Petroleum Corporation
## 78 FCC Unit Marathon Petroleum Corporation
## 94 FCC Unit Marathon Petroleum Corporation
## 147 FCC Unit Marathon Petroleum Corporation
## 246 FCC Unit Marathon Petroleum Corporation
## 251 FCC Unit Marathon Petroleum Corporation
## 253 FCC Unit Marathon Petroleum Corporation
## 261 FCC Unit Marathon Petroleum Corporation
## 272 FCC Unit Marathon Petroleum Corporation
## 280 FCC Unit Marathon Petroleum Corporation
## 284 FCC Unit Marathon Petroleum Corporation
## 296 FCC Unit Marathon Petroleum Corporation
## 317 FCC Unit Marathon Petroleum Corporation
## 169 FCC Unit Mineraloelrohstoff-Handel GmbH
## 54 FCC Unit MOL Magyar Olaj- es Gazipari Nyrt.
## 30 FCC Unit Monroe Energy
## 323 FCC Unit Motiva Enterprises LLC
## 370 FCC Unit Motiva Enterprises LLC
## 42 FCC Unit Motor Oil (Hellas) Corinth Refineries S.A.
## 233 FCC Unit National Cooperative Refinery Association
## 229 FCC Unit National Iranian Oil Refining and Distribution Company
## 16 FCC Unit National Petroleum Refiners
## 117 FCC Unit Neftochim
## 118 FCC Unit Neste Oil Oyj
## 82 FCC Unit Nigerian National Petroleum Corporation
## 85 FCC Unit Nigerian National Petroleum Corporation
## 227 FCC Unit Nigerian National Petroleum Corporation
## 358 FCC Unit Oil Refineries Ltd.
## 121 FCC Unit Olefin Chemical
## 28 FCC Unit OMV AG
## 91 FCC Unit OMV Petrom SA
## 326 FCC Unit Osaka International Refining Company
## 172 FCC Unit Pampa Energia
## 293 FCC Unit Par Petroleum Corporation
## 119 FCC Unit Paz Oil Company Ltd.
## 13 FCC Unit PBF Energy Inc.
## 151 FCC Unit PBF Energy Inc.
## 281 FCC Unit PBF Energy Inc.
## 287 FCC Unit PBF Energy Inc.
## 331 FCC Unit PBF Energy Inc.
## 159 FCC Unit PCK Raffinerie GmbH
## 3 FCC Unit PetroChina Company Limited
## 7 FCC Unit PetroChina Company Limited
## 20 FCC Unit PetroChina Company Limited
## 45 FCC Unit PetroChina Company Limited
## 62 FCC Unit PetroChina Company Limited
## 63 FCC Unit PetroChina Company Limited
## 68 FCC Unit PetroChina Company Limited
## 75 FCC Unit PetroChina Company Limited
## 77 FCC Unit PetroChina Company Limited
## 79 FCC Unit PetroChina Company Limited
## 101 FCC Unit PetroChina Company Limited
## 122 FCC Unit PetroChina Company Limited
## 123 FCC Unit PetroChina Company Limited
## 137 FCC Unit PetroChina Company Limited
## 166 FCC Unit PetroChina Company Limited
## 174 FCC Unit PetroChina Company Limited
## 178 FCC Unit PetroChina Company Limited
## 188 FCC Unit PetroChina Company Limited
## 237 FCC Unit PetroChina Company Limited
## 239 FCC Unit PetroChina Company Limited
## 259 FCC Unit PetroChina Company Limited
## 262 FCC Unit PetroChina Company Limited
## 274 FCC Unit PetroChina Company Limited
## 300 FCC Unit PetroChina Company Limited
## 356 FCC Unit PetroChina Company Limited
## 190 FCC Unit Petroleo Brasileiro SA
## 292 FCC Unit Petroleo Brasileiro SA
## 297 FCC Unit Petroleo Brasileiro SA
## 302 FCC Unit Petroleo Brasileiro SA
## 304 FCC Unit Petroleo Brasileiro SA
## 340 FCC Unit Petroleo Brasileiro SA
## 341 FCC Unit Petroleo Brasileiro SA
## 347 FCC Unit Petroleo Brasileiro SA
## 355 FCC Unit Petroleo Brasileiro SA
## 368 FCC Unit Petroleo Brasileiro SA
## 369 FCC Unit Petroleo Brasileiro SA
## 220 FCC Unit Petroleos de Venezuela S.A.
## 307 FCC Unit Petroleos de Venezuela S.A.
## 383 FCC Unit Petroleos de Venezuela S.A.
## 385 FCC Unit Petroleos de Venezuela S.A.
## 212 FCC Unit Petroleos del Peru SA
## 163 FCC Unit Petroleos Mexicanos
## 316 FCC Unit Petroleos Mexicanos
## 328 FCC Unit Petroleos Mexicanos
## 345 FCC Unit Petroleos Mexicanos
## 377 FCC Unit Petroleos Mexicanos
## 380 FCC Unit Petroleos Mexicanos
## 374 FCC Unit Petroleum Company of Trinidad and Tobago Ltd.
## 38 FCC Unit Petron Corporation
## 167 FCC Unit Petronor SA
## 142 FCC Unit PetroTel Inc.
## 112 FCC Unit Phillips 66
## 127 FCC Unit Phillips 66
## 133 FCC Unit Phillips 66
## 136 FCC Unit Phillips 66
## 201 FCC Unit Phillips 66
## 203 FCC Unit Phillips 66
## 241 FCC Unit Phillips 66
## 257 FCC Unit Phillips 66
## 269 FCC Unit Phillips 66
## 271 FCC Unit Phillips 66
## 310 FCC Unit Phillips 66
## 149 FCC Unit PKN ORLEN
## 364 FCC Unit Placid Refining Company
## 175 FCC Unit Polski Koncern Naftowy Orlen
## 223 FCC Unit Preem Petroleum AB
## 2 FCC Unit PT Pertamina (Persero)
## 376 FCC Unit PT Pertamina (Persero)
## 337 FCC Unit Qatar Petroleum
## 289 FCC Unit Qirun
## 217 FCC Unit Rabigh Refining and Petrochemical Company
## 40 FCC Unit Rafinerija Nafte Pancevo
## 329 FCC Unit Refinaria de Petroleo Ipiranga SA
## 206 FCC Unit Reliance Industries Ltd
## 279 FCC Unit Reliance Industries Ltd
## 150 FCC Unit Repsol S.A.
## 209 FCC Unit Repsol S.A.
## 367 FCC Unit Repsol S.A.
## 52 FCC Unit Rosneft
## 67 FCC Unit Rosneft
## 81 FCC Unit Rosneft
## 231 FCC Unit Rosneft
## 308 FCC Unit Rosneft
## 88 FCC Unit Ruhroel GmbH
## 184 FCC Unit Saras Energia SA
## 291 FCC Unit Sarpom
## 53 FCC Unit Saudi Arabian Oil Company
## 249 FCC Unit Saudi Arabian Oil Company
## 165 FCC Unit Saudi Aramco Mobil Ref Co
## 106 FCC Unit Seibu Oil
## 343 FCC Unit Shandong Haihua Petrochemical Limited
## 382 FCC Unit Shandong Haiyou Petrochemical Limited
## 189 FCC Unit Shandong Huifeng Petroleum & Chemical Co Ltd
## 306 FCC Unit Shandong Qicheng Petroleum Chemical Industry Co Ltd
## 50 FCC Unit Shandong Qingyuan Petrochemical
## 371 FCC Unit Shandong Shtar Science & Technology Chemical Co Ltd
## 250 FCC Unit Shandong Tianhong Chemical
## 226 FCC Unit Shandong Wantong Petroleum & Chemical Corporation
## 309 FCC Unit Shandong Yulong Petrochemical Co., Ltd.
## 90 FCC Unit Shandong Zhonghai Petrochemical
## 125 FCC Unit Shell
## 160 FCC Unit Shell
## 173 FCC Unit Shell
## 235 FCC Unit Shell
## 327 FCC Unit Shell
## 348 FCC Unit Shell
## 61 FCC Unit Shell and BP South Africa Petroleum Refineries Pty Ltd
## 290 FCC Unit Shenchi Chemical Co Ltd
## 110 FCC Unit Shengma Chemical
## 258 FCC Unit Shiyou Chemical
## 234 FCC Unit Shouguang Lianmeng Chemical
## 48 FCC Unit Showa Shell Sekiyu K.K.
## 318 FCC Unit Sinclair Oil Corporation
## 335 FCC Unit Sinclair Oil Corporation
## 26 FCC Unit Sinochem Corporation
## 49 FCC Unit Slavneft
## 232 FCC Unit Slavneft
## 140 FCC Unit Slovnaft AS
## 58 FCC Unit Sonatrach SpA
## 208 FCC Unit South Refinery Co
## 74 FCC Unit State Oil Company of the Azerbaijan Republic
## 6 FCC Unit Suncor Energy Incorporated
## 73 FCC Unit Suncor Energy Incorporated
## 195 FCC Unit Suncor Energy Incorporated
## 338 FCC Unit TAIF-NK
## 60 FCC Unit Tatneft
## 39 FCC Unit Tema Oil Refinery Co Ltd
## 242 FCC Unit Thaioil Public Co. Ltd.
## 146 FCC Unit The Rompetrol Group N.V.
## 108 FCC Unit Toa Oil Co Ltd
## 80 FCC Unit TonenGeneral Sekiyu K.K.
## 95 FCC Unit TonenGeneral Sekiyu K.K.
## 332 FCC Unit TonenGeneral Sekiyu K.K.
## 4 FCC Unit Total S.A.
## 130 FCC Unit Total S.A.
## 138 FCC Unit Total S.A.
## 155 FCC Unit Total S.A.
## 247 FCC Unit Total S.A.
## 254 FCC Unit Total S.A.
## 105 FCC Unit Tupras Turkiye Petrol Rafinerileri AS
## 365 FCC Unit Tupras Turkiye Petrol Rafinerileri AS
## 154 FCC Unit Turkmenneft
## 350 FCC Unit United Refining Company
## 362 FCC Unit UrktatNafta
## 14 FCC Unit Valero Energy Corporation
## 21 FCC Unit Valero Energy Corporation
## 31 FCC Unit Valero Energy Corporation
## 131 FCC Unit Valero Energy Corporation
## 193 FCC Unit Valero Energy Corporation
## 199 FCC Unit Valero Energy Corporation
## 214 FCC Unit Valero Energy Corporation
## 240 FCC Unit Valero Energy Corporation
## 265 FCC Unit Valero Energy Corporation
## 312 FCC Unit Valero Energy Corporation
## 357 FCC Unit Valero Energy Corporation
## 361 FCC Unit Viva Energy
## 148 FCC Unit WEPEC
## 99 FCC Unit Western Refining
## 192 FCC Unit Western Refining
## 55 FCC Unit Yanchang Petroleum International Limited
## 349 FCC Unit Yanchang Petroleum International Limited
## 378 FCC Unit Yanchang Petroleum International Limited
## 215 FCC Unit YPF S.A.
## 295 FCC Unit YPF S.A.
## 288 FCC Unit Yuhuang
## 275 FCC Unit Zhejiang Petroleum & Chemical Limited
## 25 FCC Unit Zhongjie Hebei Petrochemical Group
## 41 FCC Unit Zhuhai Baota Petrochemical Co Ltd
## Location X2017.Q4 X2018.Q4 X2019.Q4 X2020.Q4 X2021.Q4 X2022.Q4
## 177 Italy 34.00 34.00 34.00 34.00 34.00 34.00
## 111 United States 22.26 22.26 22.26 22.26 22.26 22.26
## 197 United States 30.69 30.69 30.69 33.00 33.00 33.00
## 216 Australia 36.00 36.00 36.00 36.00 36.00 36.00
## 207 Uruguay 12.50 12.50 12.50 12.50 12.50 12.50
## 171 Argentina 27.30 27.30 27.30 27.30 27.30 27.30
## 139 Bahrain 41.40 41.40 41.40 41.40 41.40 41.40
## 179 China 49.00 49.00 49.00 49.00 49.00 49.00
## 330 Russia 48.00 48.00 48.00 48.00 48.00 48.00
## 336 Russia 36.44 36.44 36.44 36.44 36.44 36.44
## 96 Germany 44.70 44.70 44.70 44.70 44.70 44.70
## 325 China NA NA 20.00 NA NA NA
## 17 China NA NA 5.00 5.00 5.00 5.00
## 9 India 77.13 77.13 77.13 77.13 77.13 77.13
## 144 India 15.90 15.90 15.90 15.90 15.90 15.90
## 252 China 16.00 16.00 16.00 16.00 16.00 16.00
## 59 United States 49.50 49.50 49.50 52.20 52.20 52.20
## 102 Spain 30.00 30.00 30.00 30.00 30.00 30.00
## 211 United States 157.50 157.50 157.50 176.50 176.50 176.50
## 236 Netherlands 55.80 55.80 55.80 55.80 55.80 55.80
## 353 Australia 31.50 31.50 31.50 31.50 31.50 31.50
## 29 Pakistan NA NA NA NA NA NA
## 114 United States 9.90 9.90 9.90 7.60 7.60 7.60
## 267 United States 2.70 2.70 2.70 2.70 2.70 2.70
## 244 United States 81.87 81.87 NA NA NA NA
## 260 United States 14.90 14.90 14.90 14.90 14.90 14.90
## 305 India 14.90 14.90 14.90 14.90 14.90 14.90
## 8 South Africa 22.30 22.30 22.30 22.30 22.30 22.30
## 84 United States 80.00 80.00 80.00 80.00 80.00 80.00
## 202 United States 74.00 74.00 74.00 66.50 66.50 66.50
## 222 United States 86.00 86.00 86.00 79.20 79.20 79.20
## 255 United States 14.00 14.00 14.00 14.00 14.00 14.00
## 303 Canada 17.60 17.60 17.60 17.60 17.60 17.60
## 44 China 6.20 6.20 6.20 6.20 6.20 6.20
## 64 China NA NA 46.00 46.00 46.00 46.00
## 66 China 12.00 12.00 12.00 12.00 12.00 12.00
## 135 China 50.00 50.00 50.00 50.00 50.00 50.00
## 319 China 33.00 33.00 33.00 33.00 33.00 33.00
## 11 China NA NA 4.70 4.70 4.70 4.70
## 23 China 53.00 53.00 53.00 53.00 53.00 53.00
## 24 China 67.00 67.00 67.00 67.00 67.00 67.00
## 33 China 65.00 65.00 65.00 65.00 65.00 38.30
## 43 China 24.90 24.90 24.90 75.50 75.50 75.50
## 65 China 72.30 72.30 72.30 72.30 72.30 72.30
## 69 China 38.00 38.00 38.00 38.00 38.00 38.00
## 71 China 105.00 105.00 105.00 105.00 105.00 105.00
## 83 China NA NA 27.00 27.00 27.00 27.00
## 92 China 73.00 73.00 73.00 73.00 73.00 73.00
## 98 China NA NA 60.00 60.00 60.00 60.00
## 116 China 50.60 50.60 50.60 50.60 50.60 50.60
## 145 China 38.00 38.00 38.00 38.00 38.00 38.00
## 152 China 59.00 59.00 59.00 59.00 59.00 59.00
## 158 China 38.30 38.30 38.30 38.30 38.30 38.30
## 161 China NA NA 5.00 5.00 5.00 5.00
## 170 China 92.00 92.00 99.70 99.70 99.70 99.70
## 182 China 111.00 111.00 111.00 111.00 111.00 111.00
## 218 China 27.00 27.00 27.00 27.00 27.00 27.00
## 243 China 50.60 50.60 50.60 50.60 50.60 50.60
## 264 China NA NA 27.00 27.00 27.00 27.00
## 268 China 23.00 23.00 23.00 77.00 77.00 77.00
## 276 China 40.00 40.00 40.00 40.00 40.00 40.00
## 314 China 14.50 14.50 14.50 14.50 14.50 14.50
## 324 China 25.00 25.00 25.00 25.00 25.00 25.00
## 354 China NA NA 57.00 57.00 57.00 57.00
## 384 China NA NA NA 81.00 81.00 81.00
## 263 United States 130.50 130.50 130.50 138.00 138.00 138.00
## 320 United States 62.10 62.10 62.10 62.10 62.10 62.10
## 352 United States 75.40 75.40 75.40 62.30 62.30 62.30
## 100 China NA NA 22.00 22.00 22.00 22.00
## 200 China NA NA 4.00 4.00 4.00 4.00
## 221 China 115.00 115.00 115.00 115.00 115.00 115.00
## 51 Spain 40.00 40.00 40.00 40.00 40.00 40.00
## 315 Spain 19.00 19.00 19.00 19.00 19.00 19.00
## 245 Canada 47.80 47.80 47.80 47.80 47.80 47.80
## 157 Japan 27.90 27.90 27.90 27.90 27.90 27.90
## 181 Japan 33.30 33.30 33.30 33.30 33.30 33.30
## 298 Japan 21.60 21.60 21.60 21.60 21.60 21.60
## 191 United States 7.40 7.40 7.40 8.60 8.60 8.60
## 294 Cuba 14.70 14.70 12.50 12.50 12.50 12.50
## 70 United States 19.80 19.80 19.80 19.00 19.00 19.00
## 115 United States 33.90 33.90 33.90 33.90 33.90 33.90
## 86 China 45.50 45.50 45.50 83.80 83.80 83.80
## 168 United States 18.18 18.18 18.18 19.00 19.00 19.00
## 299 United States 18.00 18.00 18.00 20.50 20.50 20.50
## 186 China NA 23.00 23.00 23.00 23.00 23.00
## 311 China NA NA 42.00 42.00 42.00 42.00
## 162 China 23.00 23.00 23.00 23.00 23.00 23.00
## 313 China NA NA 11.00 11.00 11.00 11.00
## 187 Colombia 38.00 38.00 38.00 38.00 38.00 38.00
## 196 Colombia 64.00 64.00 64.00 64.00 64.00 64.00
## 180 Chile 31.10 31.10 31.10 31.10 31.10 31.10
## 183 Chile 22.10 22.10 22.10 22.10 22.10 22.10
## 375 Ecuador 20.00 20.00 20.00 20.00 20.00 20.00
## 22 Japan 44.10 44.10 44.10 44.10 44.10 44.10
## 198 Japan 27.00 27.00 27.00 27.00 27.00 27.00
## 15 Italy 47.00 47.00 47.00 47.00 47.00 47.00
## 12 India 74.69 74.69 74.69 74.69 74.69 74.69
## 285 Thailand 42.00 42.00 42.00 42.00 42.00 42.00
## 46 United States 218.70 218.70 218.70 232.50 232.50 232.50
## 76 Italy 50.00 50.00 50.00 50.00 50.00 50.00
## 87 France 35.00 35.00 35.00 35.00 35.00 35.00
## 93 United States 105.30 105.30 105.30 105.30 105.30 105.30
## 143 United States 89.10 89.10 89.10 94.50 94.50 94.50
## 156 United States 197.50 197.50 197.50 212.50 212.50 212.50
## 210 Australia 30.00 30.00 30.00 30.00 30.00 NA
## 248 France 29.00 29.00 29.00 29.00 29.00 29.00
## 283 Belgium 35.00 35.00 35.00 35.00 35.00 35.00
## 351 United States 17.10 17.10 17.10 22.80 22.80 22.80
## 113 Angola NA NA NA NA NA 9.00
## 205 United States 11.10 11.10 11.10 12.30 12.30 12.30
## 109 United States 99.00 99.00 99.00 50.80 50.80 50.80
## 128 United States 78.30 82.80 82.80 90.20 90.20 90.20
## 346 Taiwan 168.00 168.00 168.00 168.00 168.00 168.00
## 129 Japan 16.20 16.20 16.20 16.20 16.20 16.20
## 219 China 38.00 38.00 38.00 38.00 38.00 38.00
## 72 Portugal 42.00 42.00 42.00 42.00 42.00 42.00
## 103 Russia 47.90 47.90 47.90 47.90 47.90 47.90
## 277 Russia 78.20 78.20 78.20 78.20 78.20 78.20
## 366 Russia 12.52 12.52 12.52 12.52 21.52 21.52
## 132 Uzbekistan NA NA NA NA NA NA
## 282 South Korea 53.00 53.00 53.00 53.00 53.00 53.00
## 301 China 5.40 5.40 5.40 5.40 5.40 5.40
## 37 Germany 28.77 28.77 28.77 28.77 28.77 28.77
## 34 China 30.60 30.60 30.60 30.60 30.60 30.60
## 322 China 10.30 10.30 10.30 10.30 10.30 10.30
## 35 Greece 44.70 44.70 44.70 44.70 44.70 44.70
## 270 China 27.00 27.00 27.00 27.00 27.00 27.00
## 56 India 36.60 36.60 36.60 36.60 36.60 36.60
## 344 India 43.60 43.60 43.60 43.60 43.60 43.60
## 1 Germany 22.00 22.00 22.00 22.00 22.00 22.00
## 10 United States 16.20 16.20 16.20 16.20 16.20 16.20
## 47 United States 25.78 25.78 25.78 25.78 25.78 25.78
## 225 United States 11.30 12.20 12.20 NA NA NA
## 286 United States 24.30 27.00 27.00 29.00 29.00 29.00
## 381 United States 36.00 36.00 36.00 42.00 42.00 42.00
## 342 China NA NA 37.00 37.00 37.00 37.00
## 363 India NA NA NA NA NA NA
## 372 India 58.40 58.40 58.40 58.40 58.40 58.40
## 230 China 38.30 38.30 38.30 38.30 38.30 38.30
## 194 Canada 3.40 3.40 3.40 3.40 3.40 3.40
## 373 United States 36.16 36.16 36.16 39.90 39.90 39.90
## 213 Japan 40.50 40.50 40.50 40.50 40.50 40.50
## 27 Canada 48.00 48.00 48.00 48.00 48.00 48.00
## 164 Canada 30.00 30.00 30.00 30.00 30.00 30.00
## 176 Canada 63.00 63.00 63.00 63.00 63.00 63.00
## 19 Croatia 15.00 15.00 15.00 15.00 15.00 15.00
## 134 Croatia 10.00 10.00 NA NA NA NA
## 266 China 15.30 15.30 15.30 15.30 15.30 15.30
## 321 China 3.60 41.60 41.60 41.60 41.60 41.60
## 32 India 2.00 2.00 2.00 2.00 2.00 2.00
## 185 India 80.00 80.00 80.00 80.00 80.00 80.00
## 204 India 26.00 26.00 26.00 26.00 26.00 26.00
## 224 India NA NA NA NA NA NA
## 334 India 34.50 34.50 34.50 34.50 34.50 34.50
## 89 France 30.00 30.00 30.00 30.00 30.00 30.00
## 120 United Kingdom 21.00 21.00 21.00 NA NA NA
## 273 Thailand 25.00 25.00 25.00 25.00 25.00 25.00
## 126 Canada 22.50 22.50 22.50 22.50 22.50 22.50
## 278 United States 21.00 NA NA NA NA NA
## 238 China 28.00 28.00 28.00 28.00 28.00 28.00
## 18 China 40.00 40.00 40.00 40.00 40.00 40.00
## 124 Jordan 4.35 4.35 4.35 4.35 4.35 4.35
## 57 Japan 8.28 8.28 8.28 8.28 8.28 8.28
## 153 Japan 41.40 41.40 41.40 41.40 41.40 41.40
## 339 Japan 34.20 34.20 34.20 34.20 34.20 34.20
## 104 Japan 31.95 31.95 31.95 31.95 31.95 31.95
## 107 Kazakhstan NA 46.00 46.00 46.00 46.00 46.00
## 359 Kazakhstan 38.35 38.35 38.35 38.35 38.35 38.35
## 256 China 30.60 30.60 30.60 30.60 30.60 30.60
## 141 Kuwait 36.00 36.00 36.00 36.00 38.25 38.25
## 379 China 63.00 63.00 63.00 63.00 63.00 63.00
## 36 Russia 9.60 9.60 9.60 9.60 9.60 9.60
## 97 Russia 78.75 78.75 78.75 78.75 78.75 78.75
## 333 Italy 38.00 38.00 38.00 38.00 38.00 38.00
## 228 United States 99.00 99.00 99.00 94.20 94.20 94.20
## 360 India 42.10 42.10 42.10 42.10 42.10 42.10
## 5 United States 46.50 46.50 46.50 51.90 51.90 51.90
## 78 United States 36.00 NA 97.40 97.40 97.40 97.40
## 94 United States 25.65 25.65 25.65 31.50 31.50 31.50
## 147 United States 92.25 NA NA NA NA NA
## 246 United States 55.60 NA NA NA NA NA
## 251 United States 21.16 21.16 21.16 23.30 23.30 23.30
## 253 United States 38.00 38.00 38.00 41.80 41.80 41.80
## 261 United States 130.50 186.10 186.10 186.10 186.10 186.10
## 272 United States 24.70 24.70 24.70 24.70 24.70 24.70
## 280 United States 70.00 70.00 70.00 NA NA NA
## 284 United States 131.10 131.10 131.10 137.80 137.80 137.80
## 296 United States 51.80 51.80 51.80 51.80 51.80 51.80
## 317 United States 98.80 98.80 98.80 98.80 98.80 98.80
## 169 Germany 89.00 89.00 89.00 89.00 89.00 89.00
## 54 Hungary 24.00 24.00 24.00 24.00 24.00 24.00
## 30 United States 47.70 47.70 47.70 51.50 51.50 51.50
## 323 United States 82.00 82.00 82.00 NA NA NA
## 370 United States 85.00 85.00 85.00 89.70 89.70 89.70
## 42 Greece 30.50 30.50 30.50 30.50 30.50 30.50
## 233 United States 21.60 21.60 21.60 23.20 23.20 23.20
## 229 Iran 75.00 75.00 75.00 75.00 75.00 75.00
## 16 South Africa 26.37 26.37 26.37 26.37 26.37 26.37
## 117 Bulgaria 37.10 37.10 37.10 37.10 37.10 37.10
## 118 Finland 40.50 40.50 40.50 40.50 40.50 40.50
## 82 Nigeria 24.70 24.70 24.70 24.70 24.70 24.70
## 85 Nigeria 40.00 40.00 40.00 40.00 40.00 40.00
## 227 Nigeria 18.00 18.00 18.00 18.00 18.00 18.00
## 358 Israel 25.00 25.00 25.00 25.00 25.00 25.00
## 121 China NA NA 18.00 18.00 18.00 18.00
## 28 Austria 26.80 26.80 26.80 26.80 26.80 26.80
## 91 Romania 21.40 21.40 21.40 21.40 21.40 21.40
## 326 Japan 26.10 26.10 26.10 NA NA NA
## 172 Argentina 7.86 7.86 7.86 7.86 7.86 7.86
## 293 United States 6.30 6.30 6.30 7.00 7.00 7.00
## 119 Israel 27.50 27.50 27.50 27.50 27.50 27.50
## 13 United States 73.80 73.80 73.80 85.30 85.30 85.30
## 151 United States 79.02 79.02 79.02 101.60 101.60 101.60
## 281 United States 64.80 64.80 64.80 67.40 67.40 67.40
## 287 United States 49.50 49.50 49.50 54.00 54.00 54.00
## 331 United States 68.04 68.04 68.04 73.00 73.00 73.00
## 159 Germany 57.50 57.50 57.50 57.50 57.50 57.50
## 3 China 27.60 27.60 27.60 27.60 27.60 27.60
## 7 China 44.00 44.00 44.00 44.00 44.00 44.00
## 20 China 63.30 63.30 63.30 63.30 63.30 63.30
## 45 China 29.00 29.00 29.00 29.00 29.00 29.00
## 62 China 49.00 49.00 49.00 49.00 49.00 49.00
## 63 China NA NA 16.00 16.00 16.00 16.00
## 68 China NA NA 39.80 39.80 39.80 39.80
## 75 China 43.50 43.50 43.50 80.00 80.00 80.00
## 77 China NA NA 30.00 30.00 30.00 30.00
## 79 China 81.00 81.00 81.00 81.00 81.00 81.00
## 101 China 70.00 70.00 70.00 70.00 70.00 70.00
## 122 China NA NA 45.00 45.00 45.00 45.00
## 123 China 41.00 41.00 41.00 41.00 41.00 41.00
## 137 China 54.00 54.00 54.00 54.00 54.00 54.00
## 166 China 30.00 30.00 30.00 30.00 30.00 30.00
## 174 China 50.60 50.60 50.60 50.60 50.60 50.60
## 178 China NA NA NA NA NA 68.90
## 188 China NA NA 17.00 17.00 17.00 17.00
## 237 China NA NA 15.00 15.00 15.00 15.00
## 239 China 2.79 2.79 2.79 2.79 2.79 2.79
## 259 China 38.00 38.00 38.00 38.00 38.00 38.00
## 262 China 24.22 24.22 24.22 24.22 24.22 24.22
## 274 China 63.30 63.30 63.30 63.30 63.30 63.30
## 300 China 74.00 74.00 74.00 74.00 74.00 74.00
## 356 China 14.90 14.90 14.90 14.90 14.90 14.90
## 190 United States 50.00 50.00 50.00 50.00 50.00 50.00
## 292 Brazil 53.90 53.90 53.90 53.90 53.90 53.90
## 297 Brazil 2.93 2.93 2.93 2.93 2.93 2.93
## 302 Brazil 43.90 43.90 43.90 43.90 43.90 43.90
## 304 Brazil 82.03 82.03 82.03 82.03 82.03 82.03
## 340 Brazil 93.74 93.74 93.74 93.74 93.74 93.74
## 341 Brazil 87.88 87.88 95.00 95.00 95.00 95.00
## 347 Brazil 23.00 23.00 23.00 23.00 23.00 23.00
## 355 Brazil 55.66 55.66 55.66 55.66 55.66 55.66
## 368 Brazil 40.30 40.30 40.30 40.30 40.30 40.30
## 369 Brazil 18.16 18.16 18.16 18.16 18.16 18.16
## 220 Venezuela 197.00 197.00 197.00 197.00 197.00 197.00
## 307 Netherland Antilles 53.00 53.00 53.00 53.00 53.00 53.00
## 383 Venezuela 70.00 70.00 70.00 70.00 70.00 70.00
## 385 Venezuela 14.50 14.50 14.50 14.50 14.50 14.50
## 212 Peru 18.00 18.00 18.00 18.00 18.00 25.00
## 163 Mexico 76.00 76.00 76.00 76.00 76.00 76.00
## 316 Mexico 38.00 38.00 38.00 38.00 38.00 38.00
## 328 Mexico 80.00 80.00 80.00 80.00 80.00 80.00
## 345 Mexico 69.00 69.00 69.00 69.00 69.00 69.00
## 377 Mexico 57.00 57.00 57.00 57.00 57.00 57.00
## 380 Mexico 86.00 86.00 86.00 86.00 86.00 86.00
## 374 Trinidad and Tobago 28.00 NA NA NA NA NA
## 38 Philippines 54.90 54.90 54.90 54.90 54.90 54.90
## 167 Spain 43.70 43.70 43.70 43.70 43.70 43.70
## 142 Romania 18.50 18.50 18.50 18.50 18.50 18.50
## 112 United States 91.00 91.00 91.00 91.00 91.00 91.00
## 127 United Kingdom 49.60 49.60 49.60 49.60 49.60 49.60
## 133 United States 46.44 46.44 46.44 48.70 48.70 48.70
## 136 United States 46.60 46.60 46.60 47.40 47.40 47.40
## 201 United States 19.40 19.40 19.40 21.60 21.60 21.60
## 203 United States 69.20 69.20 69.20 60.10 60.10 60.10
## 241 United States 32.85 32.85 32.85 34.00 34.00 34.00
## 257 United States 130.50 130.50 130.50 128.00 128.00 128.00
## 269 United States 75.46 75.46 75.46 75.46 75.46 75.46
## 271 United States 94.50 94.50 94.50 96.50 96.50 96.50
## 310 United States 50.40 50.40 50.40 55.00 55.00 55.00
## 149 Poland 32.99 32.99 32.99 32.99 32.99 32.99
## 364 United States 22.50 22.50 22.50 25.00 25.00 25.00
## 175 Lithuania 43.20 43.20 43.20 43.20 43.20 43.20
## 223 Sweden 34.10 34.10 34.10 34.10 34.10 34.10
## 2 Indonesia 18.45 18.45 18.45 18.45 18.45 18.45
## 376 Indonesia 60.00 60.00 60.00 60.00 60.00 60.00
## 337 Qatar 28.00 28.00 28.00 28.00 28.00 28.00
## 289 China NA NA 19.00 19.00 19.00 19.00
## 217 Saudi Arabia 82.80 82.80 82.80 82.80 82.80 82.80
## 40 Serbia 18.95 18.95 18.95 18.95 18.95 18.95
## 329 Brazil 3.50 3.50 3.50 3.50 3.50 3.50
## 206 India 200.00 200.00 200.00 200.00 200.00 200.00
## 279 India 200.00 200.00 200.00 200.00 200.00 200.00
## 150 Spain 30.60 30.60 30.60 30.60 30.60 30.60
## 209 Peru 15.50 15.50 15.50 15.50 15.50 15.50
## 367 Spain 31.60 31.60 31.60 31.60 31.60 31.60
## 52 Russia 47.95 47.95 47.95 47.95 47.95 47.95
## 67 Russia 22.05 22.05 22.05 22.05 22.05 22.05
## 81 Russia 19.18 19.18 19.18 19.18 19.18 19.18
## 231 Russia 13.42 13.42 13.42 13.42 13.42 13.42
## 308 Russia 12.80 12.80 12.80 12.80 12.80 12.80
## 88 Germany 30.20 30.20 30.20 30.20 30.20 30.20
## 184 Italy 90.00 90.00 90.00 90.00 90.00 90.00
## 291 Italy 32.00 32.00 32.00 32.00 32.00 32.00
## 53 Saudi Arabia 23.80 23.80 23.80 23.80 23.80 23.80
## 249 Saudi Arabia NA NA NA NA NA NA
## 165 Saudi Arabia 90.60 90.60 90.60 90.60 90.60 90.60
## 106 Japan 25.20 25.20 25.20 25.20 25.20 25.20
## 343 China 13.50 13.50 13.50 13.50 13.50 13.50
## 382 China 10.90 10.90 10.90 10.90 10.90 10.90
## 189 China 10.80 10.80 10.80 10.80 10.80 10.80
## 306 China NA NA 27.00 27.00 27.00 27.00
## 50 China NA NA 4.00 4.00 4.00 4.00
## 371 China 28.00 28.00 28.00 28.00 28.00 28.00
## 250 China 26.00 26.00 26.00 26.00 26.00 26.00
## 226 China 37.00 37.00 37.00 37.00 37.00 37.00
## 309 China NA NA NA NA NA NA
## 90 China 3.80 3.80 3.80 3.80 3.80 3.80
## 125 Singapore 34.00 34.00 34.00 34.00 34.00 34.00
## 160 United States 52.11 52.11 52.11 52.11 52.11 52.11
## 173 Argentina 22.10 22.10 22.10 22.10 22.10 22.10
## 235 United States 63.00 63.00 63.00 75.00 75.00 75.00
## 327 Netherlands 49.00 49.00 49.00 49.00 49.00 49.00
## 348 Canada 19.00 19.00 19.00 19.00 19.00 19.00
## 61 South Africa 38.00 38.00 38.00 38.00 38.00 38.00
## 290 China 29.30 29.30 29.30 29.30 29.30 29.30
## 110 China 10.35 10.35 10.35 10.35 10.35 10.35
## 258 China 18.00 18.00 18.00 18.00 18.00 18.00
## 234 China 23.00 23.00 23.00 23.00 23.00 23.00
## 48 Japan 54.90 54.90 54.90 54.90 54.90 54.90
## 318 United States 20.60 20.60 20.60 20.60 20.60 20.60
## 335 United States 9.90 9.90 9.90 9.90 9.90 9.90
## 26 China 64.00 64.00 64.00 64.00 64.00 64.00
## 49 Russia 28.77 28.77 28.77 28.77 28.77 28.77
## 232 Belarus 38.00 38.00 38.00 38.00 38.00 38.00
## 140 Slovakia 18.00 18.00 18.00 18.00 18.00 18.00
## 58 Algeria 6.00 6.00 6.00 6.00 6.00 6.00
## 208 Iraq NA NA NA NA NA NA
## 74 Azerbaijan 38.40 38.40 38.40 38.40 38.40 38.40
## 6 Canada 32.00 32.00 32.00 32.00 32.00 32.00
## 73 United States 27.45 27.45 27.45 27.45 27.45 27.45
## 195 Canada 40.90 40.90 40.90 40.90 40.90 40.90
## 338 Russia 19.18 19.18 19.18 19.18 19.18 19.18
## 60 Russia NA NA NA NA 21.10 21.10
## 39 Ghana 14.00 14.00 14.00 14.00 14.00 14.00
## 242 Thailand 12.00 12.00 12.00 12.00 12.00 12.00
## 146 Romania 28.00 28.00 28.00 28.00 28.00 28.00
## 108 Japan 37.80 37.80 37.80 37.80 37.80 37.80
## 80 Japan 82.80 82.80 82.80 82.80 82.80 82.80
## 95 Japan 41.40 41.40 41.40 41.40 41.40 41.40
## 332 Japan 35.10 35.10 35.10 35.10 35.10 35.10
## 4 United States 75.00 75.00 75.00 75.00 75.00 75.00
## 130 United Kingdom 51.00 51.00 51.00 51.00 51.00 51.00
## 138 Germany 59.31 59.31 59.31 59.31 59.31 59.31
## 155 France 29.45 29.45 29.45 29.45 NA NA
## 247 France 28.53 28.53 28.53 28.53 28.53 28.53
## 254 France 51.23 51.23 51.23 51.23 51.23 51.23
## 105 Turkey 13.84 13.84 13.84 13.84 13.84 13.84
## 365 Turkey 15.10 15.10 15.10 15.10 15.10 15.10
## 154 Turkmenistan 34.50 34.50 34.50 34.50 34.50 34.50
## 350 United States 20.70 20.70 20.70 25.00 25.00 25.00
## 362 Ukraine 14.60 14.60 14.60 14.60 14.60 14.60
## 14 United States 77.40 77.40 77.40 81.70 81.70 81.70
## 21 United States 21.60 21.60 21.60 23.40 23.40 23.40
## 31 Canada 63.20 63.20 63.20 63.20 63.20 63.20
## 131 United States 67.50 67.50 67.50 72.00 72.00 72.00
## 193 United Kingdom 90.00 90.00 90.00 90.00 90.00 90.00
## 199 United States 90.00 90.00 90.00 NA NA NA
## 214 United States 50.70 50.70 50.70 52.50 52.50 52.50
## 240 United States 50.00 50.00 50.00 52.80 52.80 52.80
## 265 United States 64.40 64.40 64.40 71.50 71.50 71.50
## 312 United States 67.50 67.50 67.50 73.10 73.10 73.10
## 357 United States 27.00 27.00 27.00 25.00 25.00 25.00
## 361 Australia 38.00 38.00 38.00 38.00 38.00 38.00
## 148 China 54.00 54.00 54.00 54.00 54.00 54.00
## 99 United States 7.70 7.70 7.70 NA NA NA
## 192 United States 31.50 31.50 31.50 33.30 33.30 33.30
## 55 China 36.20 36.20 36.20 36.20 36.20 36.20
## 349 China NA NA 37.50 37.50 37.50 37.50
## 378 China 27.10 27.10 27.10 27.10 27.10 27.10
## 215 Argentina 43.00 43.00 43.00 43.00 43.00 43.00
## 295 Argentina 73.60 73.60 73.60 73.60 73.60 73.60
## 288 China NA NA 15.00 NA NA NA
## 275 China NA NA 75.90 75.90 75.90 75.90
## 25 China 25.00 25.00 25.00 25.00 25.00 25.00
## 41 China 12.30 12.30 12.30 12.30 12.30 12.30
## X2023.Q4 X2024.Q4 X2025.Q4
## 177 34.00 34.00 34.00
## 111 22.26 22.26 22.26
## 197 33.00 33.00 33.00
## 216 36.00 36.00 36.00
## 207 12.50 12.50 12.50
## 171 27.30 27.30 27.30
## 139 41.40 41.40 41.40
## 179 49.00 49.00 49.00
## 330 48.00 48.00 48.00
## 336 36.44 36.44 36.44
## 96 44.70 44.70 44.70
## 325 NA NA NA
## 17 5.00 5.00 5.00
## 9 77.13 77.13 77.13
## 144 15.90 15.90 15.90
## 252 16.00 16.00 16.00
## 59 52.20 52.20 52.20
## 102 30.00 30.00 30.00
## 211 176.50 176.50 176.50
## 236 55.80 55.80 55.80
## 353 31.50 31.50 31.50
## 29 NA NA 25.00
## 114 7.60 7.60 7.60
## 267 2.70 2.70 2.70
## 244 NA NA NA
## 260 14.90 14.90 14.90
## 305 14.90 14.90 14.90
## 8 22.30 22.30 22.30
## 84 80.00 80.00 80.00
## 202 66.50 66.50 66.50
## 222 79.20 79.20 79.20
## 255 14.00 14.00 14.00
## 303 17.60 17.60 17.60
## 44 6.20 6.20 6.20
## 64 46.00 46.00 46.00
## 66 12.00 12.00 12.00
## 135 50.00 50.00 50.00
## 319 33.00 33.00 33.00
## 11 4.70 4.70 4.70
## 23 53.00 53.00 53.00
## 24 67.00 67.00 67.00
## 33 38.30 38.30 38.30
## 43 75.50 75.50 75.50
## 65 72.30 72.30 72.30
## 69 38.00 38.00 38.00
## 71 105.00 105.00 105.00
## 83 27.00 27.00 27.00
## 92 73.00 73.00 73.00
## 98 60.00 60.00 60.00
## 116 50.60 50.60 50.60
## 145 38.00 38.00 38.00
## 152 59.00 59.00 59.00
## 158 38.30 38.30 38.30
## 161 5.00 5.00 5.00
## 170 99.70 99.70 99.70
## 182 111.00 111.00 111.00
## 218 27.00 27.00 27.00
## 243 50.60 50.60 50.60
## 264 27.00 27.00 27.00
## 268 77.00 77.00 77.00
## 276 40.00 40.00 40.00
## 314 14.50 14.50 14.50
## 324 25.00 25.00 25.00
## 354 57.00 57.00 57.00
## 384 81.00 81.00 81.00
## 263 138.00 138.00 138.00
## 320 62.10 62.10 62.10
## 352 62.30 62.30 62.30
## 100 22.00 22.00 22.00
## 200 4.00 4.00 4.00
## 221 115.00 115.00 115.00
## 51 40.00 40.00 40.00
## 315 19.00 19.00 19.00
## 245 47.80 47.80 47.80
## 157 27.90 27.90 27.90
## 181 33.30 33.30 33.30
## 298 21.60 21.60 21.60
## 191 8.60 8.60 8.60
## 294 12.50 12.50 12.50
## 70 19.00 19.00 19.00
## 115 33.90 33.90 33.90
## 86 83.80 83.80 83.80
## 168 19.00 19.00 19.00
## 299 20.50 20.50 20.50
## 186 23.00 23.00 23.00
## 311 42.00 42.00 42.00
## 162 23.00 23.00 23.00
## 313 11.00 11.00 11.00
## 187 38.00 38.00 38.00
## 196 64.00 64.00 64.00
## 180 31.10 31.10 31.10
## 183 22.10 22.10 22.10
## 375 20.00 20.00 20.00
## 22 44.10 44.10 44.10
## 198 27.00 27.00 27.00
## 15 47.00 47.00 47.00
## 12 74.69 74.69 74.69
## 285 42.00 42.00 42.00
## 46 232.50 232.50 232.50
## 76 50.00 50.00 50.00
## 87 35.00 35.00 35.00
## 93 105.30 105.30 105.30
## 143 94.50 94.50 94.50
## 156 212.50 212.50 212.50
## 210 NA NA NA
## 248 29.00 29.00 29.00
## 283 35.00 35.00 35.00
## 351 22.80 22.80 22.80
## 113 9.00 9.00 9.00
## 205 12.30 12.30 12.30
## 109 50.80 50.80 50.80
## 128 90.20 90.20 90.20
## 346 168.00 168.00 168.00
## 129 16.20 16.20 16.20
## 219 38.00 38.00 38.00
## 72 42.00 42.00 42.00
## 103 47.90 47.90 47.90
## 277 78.20 78.20 78.20
## 366 21.52 21.52 21.52
## 132 NA NA 9.60
## 282 53.00 53.00 53.00
## 301 5.40 5.40 5.40
## 37 28.77 28.77 28.77
## 34 30.60 30.60 30.60
## 322 10.30 10.30 10.30
## 35 44.70 44.70 44.70
## 270 27.00 27.00 27.00
## 56 36.60 36.60 36.60
## 344 43.60 43.60 43.60
## 1 22.00 22.00 22.00
## 10 16.20 16.20 16.20
## 47 25.78 25.78 25.78
## 225 NA NA NA
## 286 29.00 29.00 29.00
## 381 42.00 42.00 42.00
## 342 37.00 37.00 37.00
## 363 NA NA NA
## 372 58.40 58.40 58.40
## 230 38.30 38.30 38.30
## 194 3.40 3.40 3.40
## 373 39.90 39.90 39.90
## 213 40.50 40.50 40.50
## 27 48.00 48.00 48.00
## 164 30.00 30.00 30.00
## 176 63.00 63.00 63.00
## 19 15.00 15.00 15.00
## 134 NA NA NA
## 266 15.30 15.30 15.30
## 321 41.60 41.60 41.60
## 32 2.00 2.00 2.00
## 185 80.00 80.00 80.00
## 204 26.00 26.00 26.00
## 224 NA NA 48.13
## 334 34.50 34.50 80.71
## 89 30.00 30.00 30.00
## 120 NA NA NA
## 273 25.00 25.00 25.00
## 126 22.50 22.50 22.50
## 278 NA NA NA
## 238 28.00 28.00 28.00
## 18 40.00 40.00 40.00
## 124 4.35 4.35 4.35
## 57 8.28 8.28 8.28
## 153 41.40 41.40 41.40
## 339 NA NA NA
## 104 31.95 31.95 31.95
## 107 46.00 46.00 46.00
## 359 38.35 38.35 38.35
## 256 30.60 30.60 30.60
## 141 38.25 38.25 38.25
## 379 63.00 63.00 63.00
## 36 9.60 9.60 9.60
## 97 78.75 78.75 78.75
## 333 38.00 38.00 38.00
## 228 94.20 94.20 94.20
## 360 42.10 42.10 42.10
## 5 51.90 51.90 51.90
## 78 97.40 97.40 97.40
## 94 31.50 31.50 31.50
## 147 NA NA NA
## 246 NA NA NA
## 251 23.30 23.30 23.30
## 253 41.80 41.80 41.80
## 261 186.10 186.10 186.10
## 272 24.70 24.70 24.70
## 280 NA NA NA
## 284 137.80 137.80 137.80
## 296 51.80 51.80 51.80
## 317 98.80 98.80 98.80
## 169 89.00 89.00 89.00
## 54 24.00 24.00 24.00
## 30 51.50 51.50 51.50
## 323 NA NA NA
## 370 89.70 89.70 89.70
## 42 30.50 30.50 30.50
## 233 23.20 23.20 23.20
## 229 75.00 75.00 75.00
## 16 26.37 26.37 26.37
## 117 37.10 37.10 37.10
## 118 40.50 40.50 40.50
## 82 24.70 24.70 24.70
## 85 40.00 40.00 40.00
## 227 18.00 18.00 18.00
## 358 25.00 25.00 25.00
## 121 18.00 18.00 18.00
## 28 26.80 26.80 26.80
## 91 21.40 21.40 21.40
## 326 NA NA NA
## 172 7.86 7.86 7.86
## 293 7.00 7.00 7.00
## 119 27.50 27.50 27.50
## 13 85.30 85.30 85.30
## 151 101.60 101.60 101.60
## 281 67.40 67.40 67.40
## 287 54.00 54.00 54.00
## 331 73.00 73.00 73.00
## 159 57.50 57.50 57.50
## 3 27.60 27.60 27.60
## 7 44.00 44.00 44.00
## 20 63.30 63.30 63.30
## 45 29.00 29.00 29.00
## 62 49.00 49.00 49.00
## 63 16.00 16.00 16.00
## 68 39.80 39.80 39.80
## 75 80.00 80.00 80.00
## 77 30.00 30.00 30.00
## 79 81.00 81.00 81.00
## 101 70.00 70.00 70.00
## 122 45.00 45.00 45.00
## 123 41.00 41.00 41.00
## 137 54.00 54.00 54.00
## 166 30.00 30.00 30.00
## 174 50.60 50.60 50.60
## 178 68.90 68.90 68.90
## 188 17.00 17.00 17.00
## 237 15.00 15.00 15.00
## 239 2.79 2.79 2.79
## 259 38.00 38.00 38.00
## 262 24.22 24.22 24.22
## 274 63.30 63.30 63.30
## 300 74.00 74.00 74.00
## 356 14.90 14.90 14.90
## 190 50.00 50.00 50.00
## 292 53.90 53.90 53.90
## 297 2.93 2.93 2.93
## 302 43.90 43.90 43.90
## 304 82.03 82.03 82.03
## 340 93.74 93.74 93.74
## 341 95.00 95.00 95.00
## 347 23.00 23.00 23.00
## 355 55.66 55.66 55.66
## 368 40.30 40.30 40.30
## 369 18.16 18.16 18.16
## 220 197.00 197.00 197.00
## 307 53.00 53.00 53.00
## 383 70.00 70.00 70.00
## 385 14.50 14.50 14.50
## 212 25.00 25.00 25.00
## 163 76.00 76.00 76.00
## 316 38.00 38.00 38.00
## 328 80.00 80.00 80.00
## 345 69.00 69.00 69.00
## 377 57.00 57.00 57.00
## 380 86.00 86.00 86.00
## 374 NA NA NA
## 38 54.90 54.90 54.90
## 167 43.70 43.70 43.70
## 142 18.50 18.50 18.50
## 112 91.00 91.00 91.00
## 127 49.60 49.60 49.60
## 133 48.70 48.70 48.70
## 136 47.40 47.40 47.40
## 201 21.60 21.60 21.60
## 203 60.10 60.10 60.10
## 241 34.00 34.00 34.00
## 257 128.00 128.00 128.00
## 269 75.46 75.46 75.46
## 271 96.50 96.50 96.50
## 310 55.00 55.00 55.00
## 149 32.99 32.99 32.99
## 364 25.00 25.00 25.00
## 175 43.20 43.20 43.20
## 223 34.10 34.10 34.10
## 2 18.45 18.45 18.45
## 376 60.00 60.00 60.00
## 337 28.00 28.00 28.00
## 289 19.00 19.00 19.00
## 217 82.80 82.80 82.80
## 40 18.95 18.95 18.95
## 329 3.50 3.50 3.50
## 206 200.00 200.00 200.00
## 279 200.00 200.00 200.00
## 150 30.60 30.60 30.60
## 209 15.50 15.50 15.50
## 367 31.60 31.60 31.60
## 52 47.95 47.95 47.95
## 67 22.05 22.05 22.05
## 81 19.18 19.18 19.18
## 231 13.42 35.48 35.48
## 308 12.80 12.80 12.80
## 88 30.20 30.20 30.20
## 184 90.00 90.00 90.00
## 291 32.00 32.00 32.00
## 53 23.80 23.80 23.80
## 249 NA NA NA
## 165 90.60 90.60 90.60
## 106 25.20 25.20 25.20
## 343 13.50 13.50 13.50
## 382 10.90 10.90 10.90
## 189 10.80 10.80 10.80
## 306 27.00 27.00 27.00
## 50 4.00 4.00 4.00
## 371 28.00 28.00 28.00
## 250 26.00 26.00 26.00
## 226 37.00 37.00 37.00
## 309 NA 54.00 54.00
## 90 3.80 3.80 3.80
## 125 34.00 34.00 34.00
## 160 52.11 52.11 52.11
## 173 22.10 22.10 22.10
## 235 75.00 75.00 75.00
## 327 49.00 49.00 49.00
## 348 19.00 19.00 19.00
## 61 38.00 38.00 38.00
## 290 29.30 29.30 29.30
## 110 10.35 10.35 10.35
## 258 18.00 18.00 18.00
## 234 23.00 23.00 23.00
## 48 54.90 54.90 54.90
## 318 20.60 20.60 20.60
## 335 9.90 9.90 9.90
## 26 64.00 64.00 64.00
## 49 28.77 28.77 28.77
## 232 38.00 38.00 38.00
## 140 18.00 18.00 18.00
## 58 6.00 6.00 6.00
## 208 28.35 28.35 28.35
## 74 38.40 38.40 38.40
## 6 32.00 32.00 32.00
## 73 27.45 27.45 27.45
## 195 40.90 40.90 40.90
## 338 19.18 19.18 19.18
## 60 21.10 21.10 21.10
## 39 14.00 14.00 14.00
## 242 12.00 12.00 12.00
## 146 28.00 28.00 28.00
## 108 37.80 37.80 37.80
## 80 82.80 82.80 82.80
## 95 41.40 41.40 41.40
## 332 35.10 35.10 35.10
## 4 75.00 75.00 75.00
## 130 51.00 51.00 51.00
## 138 59.31 59.31 59.31
## 155 NA NA NA
## 247 28.53 28.53 28.53
## 254 51.23 51.23 51.23
## 105 13.84 13.84 13.84
## 365 15.10 15.10 15.10
## 154 34.50 34.50 34.50
## 350 25.00 25.00 25.00
## 362 14.60 14.60 14.60
## 14 81.70 81.70 81.70
## 21 23.40 23.40 23.40
## 31 63.20 63.20 63.20
## 131 72.00 72.00 72.00
## 193 90.00 90.00 90.00
## 199 NA NA NA
## 214 52.50 52.50 52.50
## 240 52.80 52.80 52.80
## 265 71.50 71.50 71.50
## 312 73.10 73.10 73.10
## 357 25.00 25.00 25.00
## 361 38.00 38.00 38.00
## 148 54.00 54.00 54.00
## 99 NA NA NA
## 192 33.30 33.30 33.30
## 55 36.20 36.20 36.20
## 349 37.50 37.50 37.50
## 378 27.10 27.10 27.10
## 215 43.00 43.00 43.00
## 295 73.60 73.60 73.60
## 288 NA NA NA
## 275 75.90 75.90 75.90
## 25 25.00 25.00 25.00
## 41 12.30 12.30 12.30#Comparison of console output summary in step 1 and in step 4 shows the differences when we look at the Q4 data by each year. The uploaded data has all unit operations mean and median while the data in step 4 is limited to just one unit operation - the FCC unit operation.
# The data sets shows the DIsummary for Q4 2017 Q4 2018 and Q4 2019 with
# mean 88.12 89.75 88.11
# median 25.68 26.00 25.65
# The data set shows the FCCtable summary Q4 2017 Q4 2018 Q4 2019
# mean 44.53 44.74 43.6
# median 36.44 36.80 36.08
## R Markdown
This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see <http://rmarkdown.rstudio.com>.
When you click the **Knit** button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
```r
summary(cars)## speed dist
## Min. : 4.0 Min. : 2.00
## 1st Qu.:12.0 1st Qu.: 26.00
## Median :15.0 Median : 36.00
## Mean :15.4 Mean : 42.98
## 3rd Qu.:19.0 3rd Qu.: 56.00
## Max. :25.0 Max. :120.00Including Plots
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.