Lookup Table: Federal Finance

Data as of Jan 2024

Lookup table, to be left-joined against category and variable name in the other Federal Government Finance datasets if specified.

0 views·0 downloads

How is this data produced?

This lookup table is not part of any standardised data dictionary; it was custom-made to serve the datasets on federal government finance made available via data.gov.my only.

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

Publication(s) using this data

Metadata

Dataset description

Lookup table, to be left-joined against category and variable name in the other Federal Government Finance datasets if specified.

Variable definitions
  • Dataset
  • Category
  • Variable
  • Variable Definition (EN)
  • Variable Definition (MS)
Last updated:

13 Feb 2024, 00:01

Next update:

N/A

Data source(s)
  • Accountant-General's Department
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)

Full Dataset (CSV)

Recommended for individuals seeking an Excel-friendly format.

0

Full Dataset (Parquet)

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_lookup.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=lookup_federal_finance&limit=3" response_json = requests.get(url=url).json() pprint.pprint(response_json)