Wholesale & Retail Trade by Division (2 digit)
Data as of Sept 2024Performance of the wholesale & retail trade subsectors by MSIC division (2 digit), covering sales value and volume.
0 views·0 downloads
How is this data produced?
Statistics on the wholesale and retail trade subsectors are produced using data collected through the Monthly Survey of Wholesale & Retail Trade. The data covers all establishments registered with relevant regulatory bodies which are engaged in wholesale and retail trade activities, and is reported based on the establishments' profit and loss accounts, financial statements, and other valid supporting documents. For a full description of the methodology, please refer to the Technical Notes.
What caveats I should bear in mind when using this data?
In cases where proper financial statements for an establishment are incomplete or unavailable, the data is reported based on the best available estimates.
Publication(s) using this data
Wholesale & Retail Trade, Sep 2024, the latest edition of the monthly wholesale and retail trade statistics published by DOSM. OpenDOSM also features a dashboard on wholesale and retail trade.
Metadata
Dataset description
Performance of the wholesale & retail trade subsectors by MSIC division (2 digit), covering sales value and volume.
Variable definitions
- Series Type
- Date
- Division
- Sales Value
- Volume Index
- Volume Index (sa)
Name in Dataset | Variable | Definition |
|---|---|---|
series (String) | Series Type | Series type, either absolute values ('abs'), year-on-year growth ('growth_yoy') or month-on-month growth ('growth_mom') |
date (Date) | Date | The date in YYYY-MM-DD format, with DD set to 01 as the data is at monthly frequency |
division (String) | Division | 2-digit code, to be matched using the 'division' column in the MSIC Lookup. The MSIC lookup table will give you the English and Malay definitions. |
sales (Float, RM mil) | Sales Value | The total sum paid by customers, in RM millions |
volume (Float) | Volume Index | Quantity of items sold, expressed as an index with base 2015 = 100 |
volume_sa (Float) | Volume Index (sa) | Quantity of items sold, expressed as a seasonally adjusted index with base 2015 = 100 |
Last updated:
07 Nov 2024, 12:00
Next update:
11 Dec 2024, 12:00
Data source(s)
- Department of Statistics Malaysia
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.dosm.gov.my/iowrt/iowrt_2d.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=iowrt_2d&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data