I have downloaded the complete set of target data from the DrugBank site (available here: https://www.drugbank.ca/releases/latest#protein-identifiers). Each row contains data for one target; the final column of each row lists N DrugBank IDs for the N drugs associated with that target.
For each DrugBank ID, I need to locate the associated Name and SMILES data. I have searched BioStars and elsewhere online, but so far, haven't located a way to do this in an automated way. One idea is to mine the 600 MB DrugBank XML database file, so that I could extract the drug Name and SMILES data associated with each DrugBank drug ID value. However, if there is a simpler way to obtain the Name and SMILES data without need to deal with that huge file, any recommendations will be much appreciated. Thanks in advance for any advice you can provide.