Approved Wholesalers of Pharmaceutical Products
Data as of 25 Jul 2024, 23:59Complete list of approved wholesalers of pharmaceutical products with an active license from NPRA. The table provides a preview of the dataset using 10 records as a sample.
0 views·0 downloads
How is this data produced?
This dataset represents an exact copy of the administrative records managed by the National Pharmaceutical Regulatory Agency (NPRA) using the QUEST3+ system, with any columns containing personal data excluded. QUEST3+ is the administrative system used by NPRA to enable the online management of product registrations, variations, licensing, market sampling, renewal and others.
What caveats I should bear in mind when using this data?
Although this data represents administrative records, it nevertheless remains a static dataset which is updated once per day, rather than in real time. As such, this dataset should not be used as the basis for any legal action. Any queries on enforcement of the relevant laws of Malaysia should always be referred to the National Pharmaceutical Regulatory Agency (NPRA).
Publication(s) using this data
—
Metadata
Dataset description
Complete list of approved wholesalers of pharmaceutical products with an active license from NPRA. The table provides a preview of the dataset using 10 records as a sample.
Variable definitions
- Company
- State
- Postcode
- Poison Products
- Non-Poison Products
- Traditional Products
- Health Supplements
- Veterinary Poison Products
- Veterinary Non-Poison Products
Name in Dataset | Variable | Definition |
|---|---|---|
company (String) | Company | Name of the company holding the license |
state (Categorical) | State | The state in which the company is located; one of 16 states |
postcode (String) | Postcode | 5-digit postal code for the company's address |
poison (Integer) | Poison Products | Binary variable indicating whether the company is approved (1) to sell poison products or not (0) |
non_poison (Integer) | Non-Poison Products | Binary variable indicating whether the company is approved (1) to sell non-poison products or not (0) |
traditional (Integer) | Traditional Products | Binary variable indicating whether the company is approved (1) to sell traditional products or not (0) |
health_supplement (Integer) | Health Supplements | Binary variable indicating whether the company is approved (1) to sell health supplements or not (0) |
poison_vet (Integer) | Veterinary Poison Products | Binary variable indicating whether the company is approved (1) to sell veterinary poison products or not (0) |
non_poison_vet (Integer) | Veterinary Non-Poison Products | Binary variable indicating whether the company is approved (1) to sell veterinary non-poison products or not (0) |
Last updated:
26 Jul 2024, 01:00
Next update:
02 Aug 2024, 01:00
Data source(s)
- National Pharmaceutical Regulatory Agency
- Ministry of Health 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.data.gov.my/healthcare/pharmaceutical_wholesalers.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
This data catalog is not available through OpenAPI as the nature of the data makes it unsuitable for API access. For the full dataset, please use the provided download link as shown in the above section.
© 2024 Ministry of Health Malaysia