Wholesale & Retail Trade by Group (3 digit)
Data as of Sept 2024Performance of the wholesale & retail trade subsectors by MSIC group (3 digit), covering sales value and volume. The table provides a preview of the full dataset using the latest month of data only.
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. Furthermore, note that seasonally adjusted volume index data is not provided at group (3 digit) level.
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 group (3 digit), covering sales value and volume. The table provides a preview of the full dataset using the latest month of data only.
Variable definitions
- Series Type
- Date
- Group
- Sales Value
- Volume Index
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 |
group (String) | Group | 3-digit code, to be matched using the 'group' 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 |
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_3d.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
This data catalog is not available through OpenAPI as the nature of the data makes it unsuitable for API access. For the full dataset, please use the provided download link as shown in the above section.
© 2024 Public Sector Open Data