Monthly Trade by SITC Section
Data as of Jul 2024Monthly exports and imports by SITC commodity sections.
0 views·0 downloads
How is this data produced?
This dataset presents monthly trade data for Malaysia, broken down by SITC section. The SITC classification is a widely used international system for classifying traded goods and services. For a full description of the methodology, please refer to the Technical Notes.
What caveats I should bear in mind when using this data?
Data for the most recent two months is provisional and subject to revision in future updates.
Publication(s) using this data
External Trade, July 2024, the latest edition of the monthly trade statistics published by DOSM. OpenDOSM also features a dashboard on trade.
Metadata
Dataset description
Monthly exports and imports by SITC commodity sections.
Variable definitions
- Date
- SITC Section
- Exports
- Imports
Name in Dataset | Variable | Definition |
|---|---|---|
date (Date) | Date | The date in YYYY-MM-DD format, with DD set to 01 since the data is at monthly frequency |
section (Categorical) | SITC Section | SITC section (from 0 to 9) or 'overall' |
exports (Float) | Exports | The value of exports in RM millions. |
imports (Float) | Imports | The value of imports in RM millions. |
Last updated:
28 Aug 2024, 12:00
Next update:
27 Sept 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/trade/trade_sitc_1d.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=trade_sitc_1d&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data