Mapping drugs: preparing the Boiler input files¶
This notebook shows the procedure for converting source drug codes into the input files required by the OMOP Drug Boiler (the drug_concept_stage, internal_relationship_stage, ds_stage, and relationship_to_concept files).
There is currently no gold standard for drugs, so this notebook does not include any evaluation.
The procedure has three stages:
- Structuring: an LLM splits each source drug into its ingredients, dose forms, strengths, brand names, suppliers, etc., and separates drugs from devices.
- Normalization: the structured data is converted into the Boiler staging tables.
- Mapping: the staged drug attributes are mapped to standard OMOP concepts, producing
relationship_to_concept.

Setup¶
Before running this notebook, make sure the environment is set up as described in the README, including the credentials for the LLM API and the connection to the OHDSI Vocabularies database. Settings for the drug pipeline are read by ConfigDrugMapping.
All results are stored in the data/notebook_results/drug_results folder. Most code blocks load results from file if they already exist, to save time and costs. Delete those files to rerun the corresponding steps.
from pathlib import Path
import logging
import pandas as pd
from dotenv import load_dotenv
from ariadne.utils.config_drug_mapping import ConfigDrugMapping
logging.basicConfig(level=logging.INFO, format="%(asctime)s %(message)s")
project_root = Path.cwd().parent.parent
load_dotenv()
config_drug_mapping = ConfigDrugMapping()
results_folder = project_root / "data" / "notebook_results" / "drug_results"
results_folder.mkdir(parents=True, exist_ok=True)
Source data¶
The input is a CSV file with one row per source drug, plus a markdown file describing the columns of that CSV (the data dictionary), which is given to the LLM as context.
Set the paths and the names of the columns holding the unique drug code and the full drug name below. Here we use the sample data in the data/sample_data folder.
input_csv = project_root / "data" / "sample_data" / "drug_codes_2_sample.csv"
input_dictionary_md = project_root / "data" / "sample_data" / "drug_codes_2_dictionary.md"
drug_code_column = "APPID"
full_drug_name_column = "NM_AMPP"
source_df = pd.read_csv(input_csv, dtype=str)
source_df.head()
| __record_tag_AMPP | APID | APPID | COMBPACKCD | DISCCD | DISCDT | INVALID_AMPP | LEGAL_CATCD | NM_AMPP | SUBP | ... | __record_tag_VTM | ABBREVNM_VTM | INVALID_VTM | NM_VTM | VTMIDDT | VTMIDPREV | AGGREGATED_INGREDIENTS | AGGREGATED_ROUTES | DOSE_FORM | SUPPLIER_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AMPP | 37515811000001101 | 37515911000001106 | NaN | NaN | NaN | NaN | 3 | Latuda 18.5mg tablets (CST Pharma Ltd) 28 tablet | NaN | ... | VTM | NaN | NaN | Lurasidone | 2023-02-06 | 2.66643110000011e+16 | Lurasidone hydrochloride (703116009) 18.5 nan | Oral | Oral tablet | CST Pharma Ltd |
| 1 | AMPP | 35547611000001102 | 35547811000001103 | NaN | NaN | NaN | NaN | 3 | Sertraline 75mg/5ml oral suspension (Special O... | NaN | ... | VTM | NaN | NaN | Sertraline | 2023-02-06 | 321958004.0 | Sertraline hydrochloride (96211006) 15.0 nan | Oral | Oral suspension | Special Order |
| 2 | AMPP | 29643811000001108 | 29643911000001103 | NaN | 1.0 | 2023-01-01 | NaN | 4 | Juzo Hostess class 2 (23-32mmHg) tights open t... | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Juzo UK Ltd |
| 3 | AMPP | 19640011000001108 | 19640111000001109 | NaN | NaN | NaN | NaN | 4 | Sigvaris Advance 1 low compression (14-18mmHg)... | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Sigvaris Britain Ltd |
| 4 | AMPP | 24789511000001108 | 24789611000001107 | NaN | NaN | NaN | NaN | 4 | Sigvaris Essential Comfortable class 2 (23-32m... | NaN | ... | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Sigvaris Britain Ltd |
5 rows × 68 columns
Stage 1: Structuring the drugs¶
The LlmDrugStructurer uses the LLM, guided by the settings in drug_structuring and the data dictionary, to extract structured information from each source drug. It returns:
classification_df: whether each source code is a drug or a deviceingredient_df: the ingredients (and their strengths) per drugdrug_df: drug-level attributes such as dose form, brand name, and supplierdevice_df: the source codes classified as devices
We also write a debug version of the ingredient file that includes the full drug name, to make manual review easier.
from types import SimpleNamespace
from ariadne.llm_mapping.llm_drug_structurer import LlmDrugStructurer
classify_path = results_folder / "classification.csv"
ingredient_path = results_folder / "ingredients.csv"
ingredient_debug_path = results_folder / "ingredients_with_full_drug_name.csv"
drug_path = results_folder / "drugs.csv"
device_path = results_folder / "devices.csv"
if all(p.exists() for p in [classify_path, ingredient_path, ingredient_debug_path, drug_path, device_path]):
structured = SimpleNamespace(
classification_df=pd.read_csv(classify_path, dtype=str),
ingredient_df=pd.read_csv(ingredient_path, dtype=str),
drug_df=pd.read_csv(drug_path, dtype=str),
device_df=pd.read_csv(device_path, dtype=str),
)
print("Loaded structured drugs from file.")
else:
structurer = LlmDrugStructurer(
settings=config_drug_mapping.drug_structuring,
dictionary_markdown_file=input_dictionary_md,
)
structured = structurer.structure_drugs(source_df, drug_code_column=drug_code_column)
structured.classification_df.to_csv(classify_path, index=False)
structured.ingredient_df.to_csv(ingredient_path, index=False)
structured.drug_df.to_csv(drug_path, index=False)
structured.device_df.to_csv(device_path, index=False)
ingredient_debug_df = structured.ingredient_df.copy()
if full_drug_name_column not in ingredient_debug_df.columns and full_drug_name_column in source_df.columns:
ingredient_debug_df = ingredient_debug_df.merge(
source_df[[drug_code_column, full_drug_name_column]].drop_duplicates(subset=[drug_code_column]),
left_on="drug_code",
right_on=drug_code_column,
how="left",
)
ingredient_debug_df.to_csv(ingredient_debug_path, index=False)
structured.ingredient_df.head()
2026-11-13 00:02:30,922 Starting drug structuring for rows_total=250 batch_size=25 2026-11-13 00:02:30,957 Drug structuring progress rows_processed=25/250 live_cost_usd=0.000000 cache_hits=4 api_calls=0 2026-11-13 00:02:30,987 Drug structuring progress rows_processed=50/250 live_cost_usd=0.000000 cache_hits=8 api_calls=0 2026-11-13 00:02:31,017 Drug structuring progress rows_processed=75/250 live_cost_usd=0.000000 cache_hits=12 api_calls=0 2026-11-13 00:02:31,047 Drug structuring progress rows_processed=100/250 live_cost_usd=0.000000 cache_hits=16 api_calls=0 2026-11-13 00:02:31,079 Drug structuring progress rows_processed=125/250 live_cost_usd=0.000000 cache_hits=20 api_calls=0 2026-11-13 00:02:31,108 Drug structuring progress rows_processed=150/250 live_cost_usd=0.000000 cache_hits=24 api_calls=0 2026-11-13 00:02:31,139 Drug structuring progress rows_processed=175/250 live_cost_usd=0.000000 cache_hits=28 api_calls=0 2026-11-13 00:02:31,168 Drug structuring progress rows_processed=200/250 live_cost_usd=0.000000 cache_hits=32 api_calls=0 2026-11-13 00:02:31,197 Drug structuring progress rows_processed=225/250 live_cost_usd=0.000000 cache_hits=36 api_calls=0 2026-11-13 00:02:31,224 Drug structuring progress rows_processed=250/250 live_cost_usd=0.000000 cache_hits=40 api_calls=0 2026-11-13 00:02:31,231 Drug structuring complete rows_processed=250 rows_total=250 live_cost_usd=0.000000 cache_hits=40 api_calls=0 content_filter_events=0 elapsed_seconds=0.31 output_rows_classification=250 output_rows_ingredient=103 output_rows_drug=90 output_rows_device=158
| drug_code | ingredient_name | ingredient_code | amount_value | amount_unit | numerator_value | numerator_unit | denominator_value | denominator_unit | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 37515911000001106 | Lurasidone | 776588007 | 18.5 | mg | NaN | None | NaN | None |
| 1 | 35547811000001103 | Sertraline | 777521008 | NaN | None | 75.0 | mg | 5.0 | mL |
| 2 | 19634311000001104 | Letrozole | 776502006 | 2.5 | mg | NaN | None | NaN | None |
| 3 | 34025911000001108 | Oxycodone | 777027001 | NaN | None | 20.0 | mg | 2.0 | mL |
| 4 | 21381011000001107 | Glycopyrronium bromide | 13298001000001104 | NaN | None | 0.5 | mg | NaN | mL |
structured.drug_df.head()
| drug_code | full_product_name | brand_name | brand_code | supplier_name | supplier_code | dose_form | box_size | |
|---|---|---|---|---|---|---|---|---|
| 0 | 37515911000001106 | Latuda 18.5 mg oral tablet 28 tablets | Latuda | None | CST Pharma | 24059811000001102 | oral tablet | 28.0 |
| 1 | 35547811000001103 | Sertraline 75 mg/5 ml oral suspension 1 ml | None | None | None | None | oral suspension | NaN |
| 2 | 19634311000001104 | Letrozole 2.5 mg oral tablet 14 tablets | None | None | Dexcel-Pharma | 2911401000001108 | oral tablet | 14.0 |
| 3 | 34025911000001108 | Shortec 20 mg/2 ml solution for injection ampo... | Shortec | None | Qdem Pharmaceuticals | 20921311000001103 | solution for injection | 5.0 |
| 4 | 21381011000001107 | Glycopyrronium bromide 0.05% solution 600 ml | None | None | None | None | None | NaN |
Stage 2: Normalizing the drug attributes¶
normalize_structured_drugs converts the structured output into the Boiler staging tables:
drug_concept_stage: all source drugs and their attributes (ingredients, dose forms, brand names, suppliers, units)internal_relationship_stage: relationships between drugs and their attributesds_stage: drug strength information
from ariadne.llm_mapping.llm_drug_structurer import normalize_structured_drugs
drug_concept_stage_path = results_folder / "drug_concept_stage.csv"
internal_relationship_stage_path = results_folder / "internal_relationship_stage.csv"
ds_stage_path = results_folder / "ds_stage.csv"
if all(p.exists() for p in [drug_concept_stage_path, internal_relationship_stage_path, ds_stage_path]):
normalized = SimpleNamespace(
drug_concept_stage=pd.read_csv(drug_concept_stage_path, dtype=str),
internal_relationship_stage=pd.read_csv(internal_relationship_stage_path, dtype=str),
ds_stage=pd.read_csv(ds_stage_path, dtype=str),
)
print("Loaded normalized drugs from file.")
else:
normalized = normalize_structured_drugs(structured)
normalized.drug_concept_stage.to_csv(drug_concept_stage_path, index=False)
normalized.internal_relationship_stage.to_csv(internal_relationship_stage_path, index=False)
normalized.ds_stage.to_csv(ds_stage_path, index=False)
normalized.drug_concept_stage.head()
| concept_name | domain_id | concept_class_id | concept_code | |
|---|---|---|---|---|
| 0 | g | Unit | Unit | g |
| 1 | h | Unit | Unit | h |
| 2 | mL | Unit | Unit | mL |
| 3 | mg | Unit | Unit | mg |
| 4 | patch | Unit | Unit | patch |
normalized.ds_stage.head()
| drug_concept_code | ingredient_concept_code | amount_value | amount_unit | numerator_value | numerator_unit | denominator_value | denominator_unit | box_size | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 37515911000001106 | 776588007 | 18.5 | mg | NaN | None | NaN | None | 28.0 |
| 1 | 35547811000001103 | 777521008 | NaN | None | 75.0 | mg | 5.0 | mL | NaN |
| 2 | 19634311000001104 | 776502006 | 2.5 | mg | NaN | None | NaN | None | 14.0 |
| 3 | 34025911000001108 | 777027001 | NaN | None | 20.0 | mg | 2.0 | mL | 5.0 |
| 4 | 21381011000001107 | 13298001000001104 | NaN | None | 0.5 | mg | NaN | mL | NaN |
Stage 3: Mapping to standard concepts¶
Finally, the DrugMapper maps the attributes in drug_concept_stage (ingredients, dose forms, brand names, suppliers, units) to standard OMOP concepts. The result is the relationship_to_concept file.
from ariadne.llm_mapping.drug_mapper import DrugMapper
relationship_to_concept_path = results_folder / "relationship_to_concept.csv"
if relationship_to_concept_path.exists():
relationship_to_concept = pd.read_csv(relationship_to_concept_path, dtype=str)
print("Loaded relationship_to_concept from file.")
else:
drug_mapper = DrugMapper(config_drug_mapping)
relationship_to_concept = drug_mapper.map_drug_concepts(normalized.drug_concept_stage)
relationship_to_concept.to_csv(relationship_to_concept_path, index=False)
relationship_to_concept.head(10)
Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_ingredient. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_ingredient.pkl Processing term 'Glycopyrronium bromide' Processing term 'Noradrenaline' Processing term 'Fenofibrate micronised' Processing term 'indapamide hemihydrate' Processing term 'paracetamol' Processing term 'Neostigmine methylsulfate' Processing term 'Betamethasone valerate' Processing term 'Valaciclovir' Processing term 'Apple mistletoe' Processing term 'Arachis oil extract of crude coal tar' Processing term 'Cade oil' Processing term 'Coal tar solution' Processing term 'Clobetasol propionate' Processing term 'Etidronate disodium' Processing term 'Hepar sulfuris' Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_ingredient. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_ingredient.pkl Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_brand_name. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_brand_name.pkl Processing term 'Iscador M c Hg' Processing term 'Steriflex No.27' Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_dose_form. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_dose_form.pkl Processing term 'solution for injection' Processing term 'transdermal patch' Processing term 'powder for solution for injection' Processing term 'oral gastro-resistant tablet' Processing term 'intravenous solution for infusion' Processing term 'subcutaneous solution for injection' Processing term 'cutaneous cream' Processing term 'ophthalmic eye drops' Processing term 'intravenous solution for injection' Processing term 'oral modified-release tablet' Processing term 'oral dispersible tablet' Processing term 'pessary' Processing term 'Solution for injection' Processing term 'Powder for solution for injection' Processing term 'Intravenous infusion' Processing term 'cutaneous ointment' Processing term 'solution for infusion' Processing term 'cutaneous solution' Processing term 'shampoo' Processing term 'Homeopathic tablet' Processing term 'Transdermal patch' Processing term 'Cutaneous medicated plaster' Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_supplier. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_supplier.pkl Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_unit. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_unit.pkl Processing term 'g' Processing term 'h' Processing term 'mL' Processing term 'mg' Processing term 'patch' Parquet files already exist in folder E:\git\Ariadne\data\terms_drug_device_only. Skipping download. spaCy model 'en_core_web_sm' loaded successfully. Index loaded from E:\git\Ariadne\data\verbatim_drug_mapping_index_device.pkl Processing term 'Juzo Hostess class 2 (23-32mmHg) tights open toe lymphoedema garment standard size V Sesame 1 device' Processing term 'Sigvaris Advance 1 low compression (14-18mmHg) armsleeve lymphoedema garment normal small Black 1 device' Processing term 'Sigvaris Essential Comfortable class 2 (23-32mmHg) thigh length open toe with waist attachment lymphoedema garment long extra small left Caramel 1 device' Processing term 'Haddenham Star Cotton class 2 (23-32mmHg) thigh length closed toe with grip top lymphoedema garment extra wide regular size VII Black 2 device' Processing term 'AlgiSorb dressing 10cm x 10cm 1 dressing' Processing term 'Sigvaris Essential Thermoregulating Maxi class 3 (34-46mmHg) below knee closed toe lymphoedema garment long medium Anthracite 2 device' Processing term 'Jobst Opaque class 2 (23-32mmHg) thigh length open toe with dotted silicone band lymphoedema garment standard petite size V Natural 2 device' Processing term 'Optiray 240 solution for infusion 50ml bottles 10 bottle' Processing term 'Fortisip Compact liquid banana 125 ml' Processing term 'Juzo Soft custom fit class 2 (23-32mmHg) below knee open toe with silicone top band lymphoedema garment Sesame 1 device' Processing term 'Elastane made to measure pantie brief Fit 15c 1 device' Processing term 'Sigvaris CompreBoot (30-40mmHg) standard foot lymphoedema garment long extra large/XX large Beige 1 device' Processing term 'Glucosamine sulfate 1g capsules 90 capsule' Processing term 'Jobst UltraSheer class 1 (18-21mmHg) tights closed toe lymphoedema garment regular size III Black 1 device' Processing term 'Anatera 500mg/5ml solution for injection vials 12 vial' Processing term 'Jobst Opaque class 2 (23-32mmHg) thigh length open toe with dotted silicone band lymphoedema garment wide petite size I Navy 2 device' Processing term 'Confidence BE soft convex colostomy bag with filter and overlap, standard XB32ST 32mm Stone 10 device' Processing term 'Haddenham Veni class 2 (23-32mmHg) tights open toe lymphoedema garment short size VI Slate 1 device' Processing term 'Dietary Specials gluten free brown multigrain loaf sliced 400 gram' Processing term 'Juzo Dynamic Cotton class 2 (23-32mmHg) thigh length closed toe with silicone top band lymphoedema garment wide standard size V Black pepper 2 device' Processing term 'Sigvaris 700 class 1 (18-21mmHg) thigh length open toe with waist attachment lymphoedema garment short large plus right Crispa 1 device' Processing term 'Juzo Dynamic class 2 (23-32mmHg) thigh length open toe with waist attachment lymphoedema garment right extra short size III Almond 1 device' Processing term 'Sigvaris Essential Thermoregulating class 1 (18-21mmHg) thigh length open toe with waist attachment lymphoedema garment short extra small right plus Black 1 device' Processing term 'Skinnies AM vest sleeveless 6-24 months Ecru 1 device' Processing term 'NovaLife TRE 1 soft convex ileostomy bag maxi 3083-30 30mm Beige 10 device' Processing term 'Juzo Soft class 1 (18-21mmHg) armsleeve with silicone border max lymphoedema garment size V Black pepper 1 device' Processing term 'Juzo Dynamic custom fit class 2 (23-32mmHg) one-legged panty closed toe lymphoedema garment Sesame 1 device' Processing term 'Ribbed cotton and viscose surgical tubular stockinette BP 1988 type A lightweight 25cm 5 m' Processing term 'WoundASSIST TNP dressing pack small/medium 1 kit' Processing term 'Juzo Dynamic Cotton class 2 (23-32mmHg) below knee open toe with silicone top band lymphoedema garment standard size III Sesame 2 device' Processing term 'Sigvaris Advance 2 medium compression (20-25mmHg) armsleeve with grip top lymphoedema garment normal medium plus size Black 1 device' Processing term 'Greenlan lancets 0.35mm/28gauge 200 lancet' Processing term 'Haddenham Veni class 1 (18-21mmHg) tights closed toe lymphoedema garment regular size VII Grey 1 device' Processing term 'SpiritCare hydrophilic catheter male 18Ch SH-CC028 30 catheter' Processing term 'Sigvaris Essential Thermoregulating class 1 (18-21mmHg) thigh length open toe with waist attachment lymphoedema garment short XX small right Nature (Sigvaris Britain Ltd) 1 device' Processing term 'Freedom Folatex latex catheter male 14Ch 41-515-26 10ml balloon (Mentor Medical Ltd) 1 catheter' Processing term 'Haddenham Veni class 3 (34-46mmHg) below knee open toe lymphoedema garment regular size I Beige (Haddenham Healthcare Ltd) 2 device' Processing term 'Sigvaris Essential Thermoregulating class 2 (23-32mmHg) thigh length closed toe with waist attachment lymphoedema garment long extra large left plus Black (Sigvaris Britain Ltd) 1 device' Processing term 'Juzo Inspiration custom fit class 1 (18-21mmHg) thigh length open toe with silicone top band lymphoedema garment Blueberry (Juzo UK Ltd) 1 device' Processing term 'Beta two piece ostomy system bag 32-294-16 (Mentor Medical Ltd) 90 device' Processing term 'Medisafe dressing 9cm x 25cm (Neomedic Ltd) 20 dressing' Processing term 'Nutrison Energy liquid (Nutricia Ltd) 500 ml 1 x 500ml pack' Processing term 'SMA Little Steps First Infant milk powder (SMA Nutrition) 800 gram' Processing term 'Haddenham Veni class 3 (34-46mmHg) below knee open toe lymphoedema garment extra wide long size V Pearl (Haddenham Healthcare Ltd) 2 device' Processing term 'Cutimed Siltec Sorbact B dressing 15cm x 15cm (Essity UK Ltd) 1 dressing' Processing term 'Juzo Inspiration class 1 (18-21mmHg) below knee closed toe with silicone top band lymphoedema garment short size IV Poppy seed (Juzo UK Ltd) 2 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) thigh length closed toe lymphoedema garment short size II Nutmeg (Juzo UK Ltd) 2 device' Processing term 'Chailey male urinal with rubber bag WP100-01-P (Jade-Euro-Med) 1 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) thigh length open toe lymphoedema garment extra short size VI Sesame (Juzo UK Ltd) 2 device' Processing term 'Juzo Inspiration class 1 (18-21mmHg) below knee closed toe with silicone top band lymphoedema garment extra short size III Blueberry 2 device' Processing term 'Promin low protein cheese sauce mix 225 gram' Processing term 'Haddenham Veni class 3 (34-46mmHg) thigh length open toe with grip top lymphoedema garment extra wide short size II Sahara 2 device' Processing term 'Juzo Inspiration class 2 (23-32mmHg) below knee closed toe with silicone top band lymphoedema garment extra short size II Poppy seed 2 device' Processing term 'Haddenham Veni class 2 (23-32mmHg) below knee closed toe lymphoedema garment extra wide short size III White 2 device' Processing term 'Aquacel Ag Extra dressing 20cm x 30cm rectangular 1 dressing' Processing term 'SensaCath hydrophilic catheter male Tiemann tip 16Ch PSCT16 30 catheter' Processing term 'Dipeptiven 10g/50ml concentrate for solution for infusion bottles 10 bottle' Processing term 'Altiven class 2 (23-32mmHg) thigh length open toe lymphoedema garment extra wide regular size II Soft beige 2 device' Processing term 'Aymes Shake powder 57g sachets 7 sachet' Processing term 'Juzo Soft custom fit class 1 (18-21mmHg) thigh length open toe with silicone top band lymphoedema garment Sesame 1 device' Processing term 'Juzo Dynamic class 3 (34-46mmHg) thigh length open toe with silicone top band lymphoedema garment standard size III Black pepper 2 device' Processing term 'Advasoft bandage 10cm x 3.5m (Advancis Medical) 1 bandage' Processing term 'GluNEO blood glucose monitoring system (Neon Diagnostics Ltd) 1 device' Processing term 'Cuiwear female urostomy support shortie central size 22 BS65 White (CUI International) 1 device' Processing term 'Clinitas Eye Compress (The Body Doctor Ltd) 1 device' Processing term 'Haddenham Veni class 3 (34-46mmHg) below knee open toe lymphoedema garment regular size VIII American tan (Haddenham Healthcare Ltd) 2 device' Processing term 'Juzo Dynamic class 2 (23-32mmHg) thigh length closed toe lymphoedema garment short size V Poppy seed (Juzo UK Ltd) 2 device' Processing term 'Venoflex Micro class 1 (18-21mmHg) thigh length open toe with dotted silicone band lymphoedema garment long size 5 Mode (Thuasne UK Ltd) 2 device' Processing term 'Altiven class 1 (18-21mmHg) tights open toe lymphoedema garment regular size II Soft beige (Altimed Ltd) 1 device' Processing term 'Juzo Expert Strong custom fit class 2 (23-32mmHg) foot with open toe lymphoedema garment Red (Juzo UK Ltd) 1 device' Processing term 'Soft Simplastic PVC catheter male 22Ch DT4416 30ml balloon (Rusch UK Ltd) 1 catheter' Processing term 'ActivHeal PHMB Foam Silicone Border dressing 12.5cm x 12.5cm (Advanced Medical Solutions Ltd) 1 dressing' Processing term 'Juzo Dynamic Cotton class 1 (18-21mmHg) below knee closed toe with silicone top band lymphoedema garment short size VI Black pepper (Juzo UK Ltd) 2 device' Processing term 'Sigvaris Essential Thermoregulating class 1 (18-21mmHg) panty closed toe lymphoedema garment normal XX small plus Nature (Sigvaris Britain Ltd) 1 device' Processing term 'Juzo Inspiration class 2 (23-32mmHg) thigh length open toe with silicone top band lymphoedema garment extra short size V Poppy seed (Juzo UK Ltd) 2 device' Processing term 'Haddenham Doktus class 2 (23-32mmHg) armsleeve with grip top lymphoedema garment extra wide long small Black (Haddenham Healthcare Ltd) 1 device' Processing term 'Juzo Dynamic class 2 (23-32mmHg) thigh length open toe with waist attachment lymphoedema garment left standard size V Blueberry' Processing term 'Juzo Intenso class 3 (34-46mmHg) below knee open toe with silicone top band lymphoedema garment standard size V Black pepper' Processing term 'Haddenham Veni class 2 (23-32mmHg) tights open toe lymphoedema garment regular size I Smoke' Processing term 'Juzo Soft class 2 (23-32mmHg) armsleeve with silicone border lymphoedema garment size III Nutmeg' Processing term 'OA Reaction Web knee brace right medial/left lateral size XX large' Processing term 'Juzo Soft class 2 (23-32mmHg) thigh length open toe with waist attachment lymphoedema garment right short size VI Sesame' Processing term 'Haddenham Veni class 1 (18-21mmHg) thigh length open toe with grip top lymphoedema garment regular size VII White' Processing term 'Conform 2 two piece ostomy system FlexWear convex floating flange with adhesive border 25300 55mm flange, cut to fit 13mm-38mm' Processing term 'Biotrol Almarys Twin+ two piece ostomy system colostomy bag with filter 037260E 60mm Beige' Processing term 'K+IC sheath 103.32 32mm' Processing term 'Juzo Hostess class 1 (18-21mmHg) tights open toe lymphoedema garment standard size II Blueberry' Processing term 'Skinnies Viscose stockinette vest long sleeve small adult Black' Processing term 'Build-up nutritious soup oral powder 49g sachets chicken' Processing term 'Sigvaris Essential Comfortable class 2 (23-32mmHg) thigh length closed toe with waist attachment lymphoedema garment short medium right Skin' Processing term 'Juzo Hostess class 2 (23-32mmHg) thigh length closed toe with silicone top band lymphoedema garment wide short size VI Sesame' Processing term 'Dressfilm dressing 15cm x 20cm' Processing term 'Juzo Move class 1 (18-21mmHg) below knee closed toe with silicone balance border lymphoedema garment standard size V Black pepper' Processing term 'Cuiwear female ostomy support briefs twin size 24 CF57 Black' Processing term 'Sigvaris Essential Thermoregulating class 3 (34-46mmHg) thigh length closed toe with grip top lymphoedema garment normal medium plus Black' Processing term 'Juzo Dynamic class 3 (34-46mmHg) thigh length open toe with waist attachment lymphoedema garment left short size I Blueberry' Processing term 'Haddenham Veni class 2 (23-32mmHg) thigh length closed toe with grip top lymphoedema garment short size V Grey' Processing term 'Haddenham Venex class 2 (23-32mmHg) armsleeve with grip top and mitten lymphoedema garment extra wide regular large Beige' Processing term 'Aymes ActaSolve High Energy powder 85g sachets chocolate' Processing term 'Mediven harmony class 1 (15-21mmHg) armsleeve lymphoedema garment extra wide regular size VII Sand' Processing term 'Juzo Move class 2 (23-32mmHg) below knee open toe lymphoedema garment extra short size I Poppy seed' Processing term 'Haddenham Veni class 1 (18-21mmHg) below knee closed toe lymphoedema garment regular size I Beige' Processing term 'Cuiwear male urostomy support trunks central medium LT32 Navy' Processing term 'Parafricta boxer XX large White' Processing term 'Spring truss inguinal rat-tail single left 91cm' Processing term 'Haddenham Veni class 1 (18-21mmHg) tights open toe lymphoedema garment long size VIII White 1 device' Processing term 'KoCarbon Occlusive dressing 4cm x 6.5cm 1 dressing' Processing term 'Juzo Dynamic class 1 (18-21mmHg) combined armsleeve with silicone border lymphoedema garment size I Sesame 1 device' Processing term 'HiLINE Activ medium support hernia belt without lace front for right side stoma large Res 9ar 57mm-70mm White 1 device' Processing term 'Suspender belt Large 1 device' Processing term 'CliniMed clamp 3750 1 device' Processing term 'Antistatic Space Chamber Plus with small mask 1 device' Processing term 'Juzo Move class 3 (34-46mmHg) below knee closed toe with silicone balance border lymphoedema garment extra short size VI Sugar 2 device' Processing term 'Solidea Catherine class 1 (18-21mmHg) thigh length open toe lymphoedema garment medium Nero 2 device' Processing term 'Suportx breathable tube ostomy belt small SPX584S 20cm depth Skin 1 device' Processing term 'Gloria Med Strong class 3 (34-46mmHg) thigh length open toe with waist attachment max lymphoedema garment short large left Beige 1 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) tights closed toe lymphoedema garment standard size III Blueberry 1 device' Processing term 'Juzo Classic Seamless class 2 (23-32mmHg) combined armsleeve with grip top and mitten max lymphoedema garment size 1 Black pepper 1 device' Processing term 'Sigvaris Essential Thermoregulating class 3 (34-46mmHg) thigh length closed toe with waist attachment lymphoedema garment long small left Nature 1 device' Processing term 'SOS Rehydrate oral powder sachets watermelon 8 sachet' Processing term 'Juzo Dynamic Cotton class 2 (23-32mmHg) thigh length open toe with silicone top band lymphoedema garment wide standard size III Black pepper 2 device' Processing term 'Haddenham Veni class 1 (18-21mmHg) below knee closed toe lymphoedema garment short size III Navy 2 device' Processing term 'Jobst UltraSheer class 2 (23-32mmHg) thigh length open toe with lace silicone band lymphoedema garment standard petite size I Caramel 2 device' Processing term 'Juzo Move class 2 (23-32mmHg) below knee open toe lymphoedema garment short size VI Sugar 2 device' Processing term 'Mediven Plus class 1 (18-21mmHg) thigh length closed toe with silicone top band lymphoedema garment petite size V Beige 2 device' Processing term 'LoFric Hydro-Kit catheter male non PVC 16Ch 42016253 20 catheter' Processing term 'Jobst Opaque class 2 (23-32mmHg) thigh length closed toe with dotted silicone band lymphoedema garment wide regular size I Natural 2 device' Processing term 'Uriflex SP sodium chloride 0.9% catheter maintenance solution GR026 100 ml' Processing term 'Haddenham Star Cotton class 2 (23-32mmHg) below knee open toe lymphoedema garment short size III Black 2 device' Processing term 'Haddenham Veni class 2 (23-32mmHg) below knee closed toe lymphoedema garment regular size IV Smoke 2 device' Processing term 'GA gel oral powder 24g sachets 30 sachet' Processing term 'Juzo Move class 1 (18-21mmHg) below knee closed toe lymphoedema garment short size VI Black pepper 2 device' Processing term 'Comfizz Level I waistband with silicone grip small/medium WBS/M-si Black 1 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) thigh length open toe lymphoedema garment short size IV Cinnamon 2 device' Processing term 'Juzo Hostess class 2 (23-32mmHg) thigh length closed toe with silicone top band lymphoedema garment wide standard size I Blueberry 2 device' Processing term 'Juzo Dynamic class 3 (34-46mmHg) below knee closed toe lymphoedema garment short size I Black pepper 2 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) thigh length open toe lymphoedema garment extra short size V Almond 2 device' Processing term 'Juzo Dynamic class 2 (23-32mmHg) armsleeve max lymphoedema garment size IV Sesame 1 device' Processing term 'Jobst UltraSheer class 2 (23-32mmHg) below knee closed toe lymphoedema garment petite size VI Black 2 device' Processing term 'VenoTrain Micro class 1 (18-21mmHg) thigh length open toe with silicone top band lymphoedema garment normal short large Black 2 device' Processing term 'Ceretec 500microgram kit for radiopharmaceutical preparation 5 vial' Processing term 'Sigvaris Active Masculine class 2 (23-32mmHg) below knee closed toe lymphoedema garment long XX small Black 2 device' Processing term 'Fluorescein 88.3mg/2ml solution for injection ampoules 10 ampoule' Processing term 'Fulcionel ostomy/hernia support tube belt medium F815W 20cm depth White 1 device' Processing term 'Juzo Hostess class 1 (18-21mmHg) tights open toe lymphoedema garment standard size II Poppy seed 1 device' Processing term 'Brava Coloplast strip paste 2655 10 device' Processing term 'Haddenham Veni class 2 (23-32mmHg) tights closed toe lymphoedema garment short size VI Black 1 device' Processing term 'Provide Xtra liquid blackcurrant 800 ml 4 x 200ml bottles' Processing term 'Absorb odour neutralising absorbent gel 3g sachets 30 sachet PFW5' Processing term 'Easiflex Soft Seal two piece ostomy system convex baseplate 14641 35mm flange, 18mm stoma 5 device' Processing term 'Juzo Dynamic Cotton class 2 (23-32mmHg) below knee open toe with silicone top band lymphoedema garment short size VI Black pepper 2 device' Processing term 'Haddenham EasyWrap Light (20-30mmHg) foot lymphoedema garment regular medium Sand 1 device' Processing term 'Sigvaris Style Transparent (15-20mmHg) below knee closed toe lymphoedema garment long XX large Beige One 2 device' Processing term 'Haddenham Venex class 2 (23-32mmHg) armsleeve with grip top and mitten lymphoedema garment extra wide long medium Smoke 1 device' Processing term 'Sigvaris Essential Comfortable class 2 (23-32mmHg) panty closed toe lymphoedema garment normal XX small plus Savannah 1 device' Processing term 'Juzo Expert custom fit class 1 (18-21mmHg) thigh length lymphoedema garment Red 1 device' Processing term 'Nature's Best Glucosamine 500mg/5ml liquid 1000 ml' Processing term 'Biotrol Almarys Twin two piece ostomy system convex baseplate F031362E 60mm flange, 37mm stoma 5 device'
| concept_code | source_name | mapped_concept_id | mapped_concept_name | drug_class_id | |
|---|---|---|---|---|---|
| 0 | 776588007 | Lurasidone | 40230761.0 | lurasidone | Ingredient |
| 1 | 777521008 | Sertraline | 739138.0 | sertraline | Ingredient |
| 2 | 776502006 | Letrozole | 1315946.0 | letrozole | Ingredient |
| 3 | 777027001 | Oxycodone | 1124957.0 | oxycodone | Ingredient |
| 4 | 777722004 | Testosterone | 1636780.0 | testosterone | Ingredient |
| 5 | 775543001 | Diamorphine | 19022417.0 | heroin | Ingredient |
| 6 | 776713006 | Metformin | 1503297.0 | metformin | Ingredient |
| 7 | 777294006 | Pramipexole | 720810.0 | pramipexole | Ingredient |
| 8 | 777388000 | Rabeprazole | 911735.0 | rabeprazole | Ingredient |
| 9 | 777905007 | Ustekinumab | 40161532.0 | ustekinumab | Ingredient |
Boiler input files¶
The following files in the results folder are the inputs for the Drug Boiler:
for name in ["drug_concept_stage", "internal_relationship_stage", "ds_stage", "relationship_to_concept"]:
path = results_folder / f"{name}.csv"
print(f"{path}: {'found' if path.exists() else 'MISSING'}")
E:\git\Ariadne\data\notebook_results\drug_results\drug_concept_stage.csv: found E:\git\Ariadne\data\notebook_results\drug_results\internal_relationship_stage.csv: found E:\git\Ariadne\data\notebook_results\drug_results\ds_stage.csv: found E:\git\Ariadne\data\notebook_results\drug_results\relationship_to_concept.csv: found