Household Income by Administrative District
Data as of 2022Mean and median gross monthly household income by administrative district from 2019 to 2022.
0 views·0 downloads
How is this data produced?
Data on individual salaries and wages in the formal economy is easy to obtain from administrative records. However, data on household income is more difficult to tabulate, as it requires the correct definition of a statistical household, as well as the inclusion of non-salary sources of income such as property income, dividends, and interest. For this reason, it requires the use of a representative survey or census.
In Malaysia, data on household income (as well as expenditure and access to basic amenities) is collected through the Household Income and Expenditure Survey (HIES), which is conducted at least twice within any 5-year period. The data shown here was tabulated from household-level HIES records spanning 1970 to 2022 (the latest edition). For a full description of the methodology, please refer to the technical notes.
What caveats I should bear in mind when using this data?
This data presents nominal values, i.e. they have not been adjusted for inflation. Furthermore, district-level data is only published from 2019 (relative to state-level data which is available from 1970) as prior HIES samples were not sufficient to support district-level granularity.
Publication(s) using this data
The Household Income Survey Report, 2022, the latest edition of the household income statistics published by DOSM. OpenDOSM also features a dashboard on household income which enables you to explore Malaysia's household income data interactively.
Metadata
Dataset description
Mean and median gross monthly household income by administrative district from 2019 to 2022.
Variable definitions
- State
- District
- Date
- Mean Income
- Median Income
Name in Dataset | Variable | Definition |
|---|---|---|
state (Categorical) | State | One of 16 states, including the 3 Federal Territories |
district (Categorical) | District | One of 160 administrative districts, including the 4 states (Perlis and the 3 Federal Territories) which do not have subdivisions |
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 as the data is at annual frequency |
income_mean (Integer, RM) | Mean Income | Average gross monthly household income |
income_median (Integer, RM) | Median Income | Median gross monthly household income; this is generally less than the mean income due to the right-skewed distribution of income |
Last updated:
28 Jul 2023, 12:00
Next update:
N/A
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/hies/hh_income_district.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=hh_income_district&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data