Item Lookup
Data as of 09 Nov 2023, 23:59Lookup table, to be left-joined against item code in the main PriceCatcher data.
0 views·0 downloads
How is this data produced?
Prices are collected and verified by groundstaff on a daily basis, with over 2 million prices collected every month.
What caveats I should bear in mind when using this data?
This data is collected for the purpose of price surveillance, and is excellent for high-frequency analysis of specific items in specific locations. Inflation surveillance requires a different approach, in particular to ensure proper representativeness. Inflation analysis should be conducted using DOSM's CPI data.
Publication(s) using this data
—
Metadata
Dataset description
Lookup table, to be left-joined against item code in the main PriceCatcher data.
Variable definitions
- Item Code
- Item Name
- Unit of Measurement
- Item Group
- Item Category
Name in Dataset | Variable | Definition |
|---|---|---|
item_code (Integer) | Item Code | Column for left-join |
item (Categorical) | Item Name | Name of item |
unit (Categorical) | Unit of Measurement | Unit of measurement |
item_group (Categorical) | Item Group | Item group |
item_category (Categorical) | Item Category | Broad category |
Last updated:
N/A
Next update:
N/A
Data source(s)
- Ministry of Domestic Trade
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/pricecatcher/lookup_item.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