MCOICOP

OpenDOSM

Home Dashboards Data Catalogue Publications API Docs

On this page

Data as of 2018

This table provides a complete lookup for 2, 3, 4, and 5-digit codes under Malaysia's COICOP (Classification of Individual Consumption According to Purpose), as applied and used in data publications in Malaysia. The MCOICOP is primarily used by the Department of Statistics Malaysia (DOSM), for instance when categorising and analysing consumer price inflation.

0 views·0 downloads

How is this data produced?

The MCOICOP was adapted from the latest COICOP published by the United Nations Statistics Division, which is used as a global reference in the classification of individual and household consumption.

What caveats I should bear in mind when using this data?

—

Publication(s) using this data

—

Metadata

Dataset description

Variable definitions

Digits
[Integer] Number of digits; this column can be used as a filter if you only want to keep 2 digit codes, for example
Division
String] 2-digit code; please ensure that you read this column as a string, because the (intentional leading zeroes will be dropped if read as an integer (e.g. upon opening in Microsoft Excel)
Group
String] 3-digit code, with dashes where not applicable (e.g. for rows providing 2-digit definitions
Class
String] 4-digit code, with dashes where not applicable (e.g. for rows providing 2 and 3-digit definitions
Subclass
String] 5-digit code, with dashes where not applicable (e.g. for rows providing 2 and 3-digit definitions
Description (EN)
[String] Description for the code, in English
Description (BM)
[String] Description for the code, in Malay

Name in Dataset	Variable	Definition
digits (Integer)	Digits	Number of digits; this column can be used as a filter if you only want to keep 2 digit codes, for example
division (String)	Division	2-digit code; please ensure that you read this column as a string, because the (intentional) leading zeroes will be dropped if read as an integer (e.g. upon opening in Microsoft Excel)
group (String)	Group	3-digit code, with dashes where not applicable (e.g. for rows providing 2-digit definitions)
class (String)	Class	4-digit code, with dashes where not applicable (e.g. for rows providing 2 and 3-digit definitions)
subclass (String)	Subclass	5-digit code, with dashes where not applicable (e.g. for rows providing 2 and 3-digit definitions)
desc_en (String)	Description (EN)	Description for the code, in English
desc_bm (String)	Description (BM)	Description for the code, in Malay

Last updated:

16 Apr 2024, 00:00

Next update:

N/A

Data source(s)

DOSM

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.

Full Dataset (Parquet)

Recommended for data scientists seeking to work with data via code.

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/dictionaries/mcoicop.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=mcoicop&limit=3" 

response_json = requests.get(url=url).json()
pprint.pprint(response_json)

Department of Statistics Malaysia

Open Source

Frontend Repo: NextJS Backend Repo: Django UI + UX Design: Figma

Open Data

data.gov.my