Lookup table, to be left-joined against category and variable name in the other Federal Government Finance datasets if specified.
0 views·0 downloads
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.
—
—
Lookup table, to be left-joined against category and variable name in the other Federal Government Finance datasets if specified.
Name in Dataset | Variable | Definition |
---|---|---|
file (Categorical) | Dataset | Referenced dataset |
category (Categorical) | Category | Name of category within the referenced dataset, if any |
variable (String) | Variable | Name of the variable as contained within the dataset |
variable_en (String) | Variable Definition (EN) | Definition of the variable in English |
variable_bm (String) | Variable Definition (MS) | Definition of the variable in Malay |
13 Feb 2024, 00:01
N/A
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.
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
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)
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)
© 2024 Public Sector Open Data