Household Income and Expenditure: Administrative Districts
Data as of 2022This dataset tabulates household-level income, expenditure, poverty, and income inequality at administrative district level. It is based on the Household Income & Expenditure Surveys (HIES) carried in 2022.
0 views·0 downloads
How is this data produced?
This data is is based on Household Income Surveys (HIS) and Household Income & Expenditure Surveys (HIES) carried out from 1970 to 2022, the latest of which is HIES 2022. The survey is carried out at least twice in a rolling five-year period to produce representative data regarding income, poverty and access to basic amenities for Malaysian households.
What caveats I should bear in mind when using this data?
For a full account of the relative standard errors for the survey as well as the detailed survey methodology, please refer to the HIES Technical Notes.
Publication(s) using this data
Metadata
Dataset description
This dataset tabulates household-level income, expenditure, poverty, and income inequality at administrative district level. It is based on the Household Income & Expenditure Surveys (HIES) carried in 2022.
Variable definitions
- Date
- State
- District
- Mean Income
- Median Income
- Mean Expenditure
- Gini Coefficient
- Poverty Rate
Name in Dataset | Variable | Definition |
|---|---|---|
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 as this is annual data |
state (Categorical) | State | One of 16 states |
district (Categorical) | District | One of 160 administrative districts, including the 4 states (Perlis and the 3 Federal Territories) which do not have subdivisions |
income_mean (Integer) | Mean Income | Average (across households) gross monthly household income, in RM |
income_median (Integer) | Median Income | Median (across households) gross monthly household income, in RM |
expenditure_mean (Integer) | Mean Expenditure | Average (across households) gross monthly household expenditure, in RM |
gini (Float) | Gini Coefficient | Gini coefficient, with higher values indicating greater inequality of income between households |
poverty (Float) | Poverty Rate | Proportion of households with monthly income below the Poverty Line Income (PLI) |
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/hies_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=hies_district&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data