Facebook
TwitterThe Agricultural Price Index (API) is a monthly publication that measures the price changes in agricultural outputs and inputs for the UK. The output series reflects the price farmers receive for their products (referred to as the farm-gate price). Information is collected for all major crops (for example wheat and potatoes) and on livestock and livestock products (for example sheep, milk and eggs). The input series reflects the price farmers pay for goods and services. This is split into two groups: goods and services currently consumed; and goods and services contributing to investment. Goods and services currently consumed refer to items that are used up in the production process, for example fertiliser, or seed. Goods and services contributing to investment relate to items that are required but not consumed in the production process, such as tractors or buildings.
A price index is a way of measuring relative price changes compared to a reference point or base year which is given a value of 100. The year used as the base year needs to be updated over time to reflect changing market trends. The latest data are presented with a base year of 2020 = 100. To maintain continuity with the current API time series, the UK continues to use standardised methodology adopted across the EU. Details of this internationally recognised methodology are described in the https://ec.europa.eu/eurostat/web/products-manuals-and-guidelines/-/ks-bh-02-003">Handbook for EU agricultural price statistics.
Please note: The historical time series with base years 2000 = 100, 2005 = 100, 2010 = 100 and 2015 = 100 are not updated monthly and presented for archive purposes only. Each file gives the date the series was last updated.
For those commodities where farm-gate prices are currently unavailable we use the best proxy data that are available (for example wholesale prices). Similarly, calculations are based on UK prices where possible but sometimes we cannot obtain these. In such cases prices for Great Britain, England and Wales or England are used instead.
Next update: see the statistics release calendar.
As part of our ongoing commitment to compliance with the Code of Practice for Official Statistics we wish to strengthen our engagement with users of Agricultural Price Indices (API) data and better understand how data from this release is used. Consequently, we invite you to register as a user of the API data, so that we can retain your details and inform you of any new releases and provide you with the opportunity to take part in any user engagement activities that we may run.
Agricultural Accounts and Market Prices Team
Email: prices@defra.gov.uk
You can also contact us via Twitter: https://twitter.com/DefraStats
Facebook
TwitterThis dataset contains monthly historical prices of 10 different commodities from January 1980 to April 2023. The data was collected from the Alpha Vantage API using Python. The commodities included in the dataset are WTI crude oil, cotton, natural gas, coffee, sugar, aluminum, Brent crude oil, corn, copper, and wheat. Prices are reported in USD per unit of measurement for each commodity. The dataset contains 520 rows and 12 columns, with each row representing a monthly observation of the prices of the 10 commodities. The 'All_Commodities' column is new.
WTI: WTI crude oil price per unit of measurement (USD). COTTON: Cotton price per unit of measurement (USD). NATURAL_GAS: Natural gas price per unit of measurement (USD). ALL_COMMODITIES: A composite index that represents the average price of all 10 commodities in the dataset, weighted by their individual market capitalizations. Prices are reported in USD per unit of measurement. COFFEE: Coffee price per unit of measurement (USD). SUGAR: Sugar price per unit of measurement (USD). ALUMINUM: Aluminum price per unit of measurement (USD). BRENT: Brent crude oil price per unit of measurement (USD). CORN: Corn price per unit of measurement (USD). COPPER: Copper price per unit of measurement (USD). WHEAT: Wheat price per unit of measurement (USD).
Note that some values are missing in the dataset, represented by NaN. These missing values occur for some of the commodities in the earlier years of the dataset.
It may be useful for time series analysis and predictive modeling.
NaN values were included so that you as a Data Scientist can get some practice on dealing with NaN values.
Not seeing a result you expected?
Learn how you can add new datasets to our index.
Facebook
TwitterThe Agricultural Price Index (API) is a monthly publication that measures the price changes in agricultural outputs and inputs for the UK. The output series reflects the price farmers receive for their products (referred to as the farm-gate price). Information is collected for all major crops (for example wheat and potatoes) and on livestock and livestock products (for example sheep, milk and eggs). The input series reflects the price farmers pay for goods and services. This is split into two groups: goods and services currently consumed; and goods and services contributing to investment. Goods and services currently consumed refer to items that are used up in the production process, for example fertiliser, or seed. Goods and services contributing to investment relate to items that are required but not consumed in the production process, such as tractors or buildings.
A price index is a way of measuring relative price changes compared to a reference point or base year which is given a value of 100. The year used as the base year needs to be updated over time to reflect changing market trends. The latest data are presented with a base year of 2020 = 100. To maintain continuity with the current API time series, the UK continues to use standardised methodology adopted across the EU. Details of this internationally recognised methodology are described in the https://ec.europa.eu/eurostat/web/products-manuals-and-guidelines/-/ks-bh-02-003">Handbook for EU agricultural price statistics.
Please note: The historical time series with base years 2000 = 100, 2005 = 100, 2010 = 100 and 2015 = 100 are not updated monthly and presented for archive purposes only. Each file gives the date the series was last updated.
For those commodities where farm-gate prices are currently unavailable we use the best proxy data that are available (for example wholesale prices). Similarly, calculations are based on UK prices where possible but sometimes we cannot obtain these. In such cases prices for Great Britain, England and Wales or England are used instead.
Next update: see the statistics release calendar.
As part of our ongoing commitment to compliance with the Code of Practice for Official Statistics we wish to strengthen our engagement with users of Agricultural Price Indices (API) data and better understand how data from this release is used. Consequently, we invite you to register as a user of the API data, so that we can retain your details and inform you of any new releases and provide you with the opportunity to take part in any user engagement activities that we may run.
Agricultural Accounts and Market Prices Team
Email: prices@defra.gov.uk
You can also contact us via Twitter: https://twitter.com/DefraStats