# Problem to map drug info to 24Q2\_Extended\_Primary\_Data\_Matrix

**URL:** <https://forum.depmap.org/t/problem-to-map-drug-info-to-24q2-extended-primary-data-matrix/3521>\
**Category:** Issues and Bugs\
**Tags:** data\
**Created:** [August 23, 2024, 1:24pm UTC](https://forum.depmap.org/t/problem-to-map-drug-info-to-24q2-extended-primary-data-matrix/3521 "2024-08-23T13:24:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mathias\_Gehrmann](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Mathias\_Gehrmann](https://forum.depmap.org/u/Mathias_Gehrmann)\
**Post date:** [August 23, 2024, 1:24pm UTC](https://forum.depmap.org/t/problem-to-map-drug-info-to-24q2-extended-primary-data-matrix/3521/1 "2024-08-23T13:24:07Z")

</div>

When I tried to map the drug info from the file “Repurposing\_Public\_24Q2\_Extended\_Primary\_Compound\_List.csv” to the data matrix file “Repurposing\_Public\_24Q2\_Extended\_Primary \_Data\_Matrix.csv”, I realized, that the compound IDs in the data matrix file are unique. However, in the compound list file the ID “BRD:BRD-K05804044-001-18-5” occurs twice while ID “BRD:BRD-K28042756-001-01-9” is missing. Could you please check whether this is intended or due to an error. Best wishes, Mathias

---

<div class="post-metadata">

**Author:** ![abas\_buaza](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@abas\_buaza](https://forum.depmap.org/u/abas_buaza)\
**Post date:** [February 26, 2025, 4:09pm UTC](https://forum.depmap.org/t/problem-to-map-drug-info-to-24q2-extended-primary-data-matrix/3521/2 "2025-02-26T16:09:46Z")

</div>

yeah the problem is BRD:BRD-K28042756-001-01-9 from Repurposing\_Public\_24Q2\_Extended\_Primary\_Data\_Matrix.csv does not exist in Repurposing\_Public\_24Q2\_Extended\_Primary\_Compound\_List.csv and BRD:BRD-K05804044-001-18-5 is a duplicate in Repurposing\_Public\_24Q2\_Extended\_Primary\_Compound\_List.csv.

From here [SID 340086375 - PubChem](https://pubchem.ncbi.nlm.nih.gov/substance/340086375) looks like BRD-K28042756-001-01-9 is not maintained any more. Anyway, I replaced the duplicate record with BRD-K28042756-001-01-9 using pubchem.