Quarterly Federal Government Development Expenditure by Function
Data as of 3Q 2023Breakdown of quarterly Federal Government development expenditure by key sectors describing the area of impact of development projects.
0 views·0 downloads
How is this data produced?
This data is produced by the Accountant-General's Department in compliance with the Malaysian Public Sector Accounting Standards and the IMF's Dissemination Standards. Within this dataset, values for the general administration function include public services, statistics, Royal Customs and Excise, Inland Revenue Departments and the Ministry of Foreign Affairs.
What caveats I should bear in mind when using this data?
Numbers may not add up due to rounding during derivation. Furthermore, data for 2023 are preliminary and are subject to revision in future releases.
Publication(s) using this data
—
Metadata
Dataset description
Breakdown of quarterly Federal Government development expenditure by key sectors describing the area of impact of development projects.
Variable definitions
- Date
- Category
- Function
- Expenditure (RM mil)
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 quarterly frequency |
category (Categorical) | Category | Overall expenditure, defence & security, economic services, social services, or general administration |
function (String) | Function | Variable name, to be mapped using the Lookup Table where file = 'de'. The lookup table will give you the English and Malay definitions. |
value (Float) | Expenditure (RM mil) | Development expenditure in millions of ringgit (RM mil) |
Last updated:
30 Nov 2023, 15:00
Next update:
29 Feb 2024, 15:00
Data source(s)
- JANM
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/publicadmin/federal_finance_qtr_de.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=federal_finance_qtr_de&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data