Price of Petroleum & Diesel
Data as of 21 Nov 2024, 00:01Weekly retail prices of RON95 petrol, RON97 petrol, and diesel in Malaysia.
0 views·0 downloads
How is this data produced?
This dataset presents the weekly retail price of RON95 petrol, RON97 petrol, and diesel in Malaysia. Since April 2017, the retail price of fuel in Malaysia has been set on a weekly basis (except for a short period at the end of 2018 where it was announced monthly) using the Automatic Pricing Mechanism (APM). The APM is designed to allow the government to monitor the effects of changes in global crude oil prices and adjust retail fuel prices to ensure the continued welfare of the rakyat.
What caveats I should bear in mind when using this data?
The following information should be incorporated into any analysis of fuel prices in Malaysia:
- Malaysia's goods and services tax (GST) was zero-rated on 1 June 2018, with the sales and services tax (SST) subsequently implemented on 1 September 2018. However, because petrol and diesel prices are controlled by the government, they were not affected by this.
- Beginning 3 March 2021, the announcement of fuel prices was changed from Fridays to Wednesdays.
- On 10 June 2024, diesel subsidies were removed in Peninsular Malaysia, leading to a discontinuous jump from RM2.15 to RM3.35 per litre. Therefore, beginning 13 June 2024, the weekly price of diesel was announced separately for Peninsular Malaysia and East Malaysia (Sarawak, Sabah, W.P. Labuan).
Publication(s) using this data
MoF's weekly press statement on the retail price of petroleum products.
Metadata
Dataset description
Weekly retail prices of RON95 petrol, RON97 petrol, and diesel in Malaysia.
Variable definitions
- Chart Type
- Date
- RON95 Petrol Price
- RON97 Petrol Price
- Price of Diesel (Peninsular Malaysia)
- Price of Diesel (East Malaysia)
Name in Dataset | Variable | Definition |
|---|---|---|
series_type (categorical) | Chart Type | Price in RM (level), or weekly change in RM (change_weekly). |
date (Date) | Date | The date of effect of the price, in YYYY-MM-DD format |
ron95 (Float) | RON95 Petrol Price | Price per litre of RON95 petrol, in RM |
ron97 (Float) | RON97 Petrol Price | Price per litre of RON97 petrol, in RM |
diesel (Float) | Price of Diesel (Peninsular Malaysia) | Price per litre of diesel in Peninsular Malaysia, in RM |
diesel_eastmsia (Float) | Price of Diesel (East Malaysia) | Price per litre of diesel in East Malaysia, in RM |
Last updated:
20 Nov 2024, 23:59
Next update:
27 Nov 2024, 23:59
Data source(s)
- Ministry of Finance
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.data.gov.my/commodities/fuelprice.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
The following code is an example of how to make an API query to retrieve the data catalogue mentioned above. You can use different programming languages by switching the code accordingly. For a complete guide on possible query parameters and syntax, please refer to the official Open API Documentation.
import requests
import pprint
url = "https://api.data.gov.my/data-catalogue?id=fuelprice&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data