Annual extraction of mineral commodities by state from 2016 to 2021.
0 views·0 downloads
Data on mineral extraction in Malaysia is produced by the Mineral Intelligence Unit based on data collected via establishment-level surveys and censuses conducted by the Department of Mineral and Geoscience (JMG), in collaboration with the Department of Statistics Malaysia (DOSM). Accordingly, this data reflects the extractive activities of establishments registered with the DMG only. The data shown here is also used for the production of Malaysia's official GDP statistics.
From a definitional perspective, it should be noted that:
National totals may be slightly different to the sum of state values due to rounding.
—
Annual extraction of mineral commodities by state from 2016 to 2021.
Name in Dataset | Variable | Definition |
---|---|---|
state (Categorical) | State | One of 16 states, or Malaysia; note that W.P. Labuan is not present in the dataset due to an absence of mineral extraction activitiy in the state. |
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 since the data is at annual frequency |
type (Categorical) | Commodity Type | The type of commodity in snake case; either energy ('energy'), metallic ('metallic') or non-metallic ('non_metallic'). |
commodity (Categorical) | Commodity | The mineral commodity extracted in snake case, such as coal, bauxite, gold, feldspare, limestone, etc. |
production (Float) | Extraction | The quantity of the commodity extracted; all values are in metric tonnes except for gold and silver, which are denominated in grammes |
01 Sept 2024, 12:00
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/mining/mineral_extraction.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=mineral_extraction&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
Department of Statistics Malaysia
© 2024 Public Sector Open Data
Open Data
data.gov.my