# Commodity Prices Schema Report

Source file: /mnt/z/B011/file-UtbA48d7rmrmqUm6rELA6U.xlsx
Sheet name: Monthly Prices

Raw shape (rows x cols): (803, 72)
Number of raw commodities (before cleaning): 71
Valid date rows: 796
Invalid date rows skipped: 0
Initial price columns: 71
Price columns dropped (all NaN): 0

Missing value markers replaced:
- ...: 227
- …: 6190

Final number of commodities with price data: 71
Final number of monthly observations: 796

Sample of commodities (first 20):

| Code | Name | Unit | Group | First Date | Last Date | N Obs | Mean | Std | Min | Max |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| CRUDE_PETRO | Crude oil, average | ($/bbl) | Energy | 1960-01-01 | 2026-04-01 | 796 | 34.17 | 31.54 | 1.21 | 132.8 |
| CRUDE_BRENT | Crude oil, Brent | ($/bbl) | Energy | 1960-01-01 | 2026-04-01 | 796 | 35.04 | 32.75 | 1.21 | 133.9 |
| CRUDE_DUBAI | Crude oil, Dubai | ($/bbl) | Energy | 1960-01-01 | 2026-04-01 | 796 | 33.53 | 31.82 | 1.21 | 131.2 |
| CRUDE_WTI | Crude oil, WTI | ($/bbl) | Energy | 1982-01-01 | 2026-04-01 | 532 | 46.65 | 28.49 | 11.31 | 133.9 |
| COAL_AUS | Coal, Australian | ($/mt) | Energy | 1970-01-01 | 2026-04-01 | 676 | 59.04 | 55 | 7.8 | 430.8 |
| COAL_SAFRICA | Coal, South African ** | ($/mt) | Energy | 1984-01-01 | 2026-04-01 | 508 | 61.54 | 43.31 | 21.25 | 302 |
| NGAS_US | Natural gas, US | ($/mmbtu) | Energy | 1960-01-01 | 2026-04-01 | 796 | 2.426 | 2.167 | 0.14 | 13.52 |
| NGAS_EUR | Natural gas, Europe | ($/mmbtu) | Energy | 1960-01-01 | 2026-04-01 | 796 | 4.937 | 6.232 | 0.3841 | 70.04 |
| NGAS_JP | Liquefied natural gas, Japan | ($/mmbtu) | Energy | 1977-01-01 | 2026-04-01 | 592 | 7.316 | 4.429 | 2.72 | 23.73 |
| iNATGAS | Natural gas index | (2010=100) | Energy | 1977-01-01 | 2026-04-01 | 592 | 74.12 | 49.71 | 18.53 | 454 |
| COCOA | Cocoa | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.939 | 1.362 | 0.259 | 10.75 |
| COFFEE_ARABIC | Coffee, Arabica | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 2.765 | 1.593 | 0.7776 | 9.049 |
| COFFEE_ROBUS | Coffee, Robusta | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.84 | 1.066 | 0.4872 | 6.884 |
| TEA_AVG | Tea, avg 3 auctions | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.829 | 0.7393 | 0.7074 | 3.369 |
| TEA_COLOMBO | Tea, Colombo | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.883 | 1.086 | 0.4342 | 4.49 |
| TEA_KOLKATA | Tea, Kolkata | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.906 | 0.709 | 0.6648 | 4.073 |
| TEA_MOMBASA | Tea, Mombasa | ($/kg) | Soft Commodities | 1960-01-01 | 2026-04-01 | 796 | 1.698 | 0.6111 | 0.7196 | 3.393 |
| COCONUT_OIL | Coconut oil | ($/mt) | Energy | 1960-01-01 | 2026-04-01 | 796 | 743.1 | 477.7 | 200 | 2841 |
| GRNUT | Groundnuts | ($/mt) | Agriculture | 1980-01-01 | 2026-04-01 | 556 | 1191 | 416.1 | 585 | 2528 |
| FISH_MEAL | Fish meal | ($/mt) | Agriculture | 1979-01-01 | 2026-04-01 | 568 | 896.2 | 523.9 | 254 | 1933 |