BCPC¶
About¶
The Compendium of Pesticide Common Names (BCPC):
Quote
This electronic compendium is intended to provide details of the status of all pesticide common names (not just those assigned by ISO), together with their systematic chemical names, molecular formulae, chemical structures and CAS Registry Numbers®. It is designed to function like a database, with several indexes that provide access to the data sheets.
About this App¶
Simmate's bcpc
app helps to download BCPC data & load it into the Simmate database.
Module | CLI | Workflows | Data |
---|---|---|---|
simmate.apps.bcpc |
Installation¶
-
Add
bcpc
to the list of installed Simmate apps with:simmate config add bcpc
-
Ensure everything is configured correctly:
simmate config test bcpc
-
Add new tables to your database:
simmate database update
-
Download all BCPC datasets:
simmate database download bcpc
Datasets¶
Dataset | Disk Space | Rows (#) | SQL Table | Python Class |
---|---|---|---|---|
ISO Names | --- | --- | bcpc__iso_pesticides__molecules |
BcpcIsoPesticide |
Tip
Read through our database guide to learn how to work with these datasets
Example
from simmate.database import connect
from simmate.apps.bcpc.models import BcpcIsoPesticide
pesticides_data = BcpcIsoPesticide.objects.to_dataframe()