# Cell line list and compound list

**URL:** <https://forum.depmap.org/t/cell-line-list-and-compound-list/467>\
**Category:** Q&A\
**Tags:** data\
**Created:** [February 24, 2021, 2:57pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467 "2021-02-24T14:57:24Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jinxie](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jinxie](https://forum.depmap.org/u/jinxie)\
**Post date:** [February 24, 2021, 2:57pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/1 "2021-02-24T14:57:24Z")

</div>

Your list of cell lines and compounds are codes not related to the actual cell lines/compounds in the excel format. Any way to convert them into real names?

---

<div class="post-metadata">

**Author:** ![dllahr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/dllahr/32/23_2.png) [@dllahr](https://forum.depmap.org/u/dllahr)\
**Post date:** [February 25, 2021, 1:34pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/2 "2021-02-25T13:34:36Z")

</div>

Are you referring to specific files you’ve downloaded? Can you provide those, it makes it much easier to provide help.  
In my experience with the download files, the cell lines are referred to by their immutable DepMap ID, which has a lot of benefits. Then you need to look up the other identifiers - i.e. name, sanger ID etc. - using the cell line metadata file.

---

<div class="post-metadata">

**Author:** ![jinxie](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jinxie](https://forum.depmap.org/u/jinxie)\
**Post date:** [February 25, 2021, 2:49pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/3 "2021-02-25T14:49:38Z")

</div>

I am referring to the primary-screen-replicate-collapsed-logfoldchange file downloaded from Drug sensitivity (PRISM Repurposing Primary Screen) 19Q4. There were 4686 compounds and 578 cell lines. I need your help to convert the IDs into compound names and cell line names. Thank you

---

<div class="post-metadata">

**Author:** ![jinxie](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jinxie](https://forum.depmap.org/u/jinxie)\
**Post date:** [February 25, 2021, 3:04pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/4 "2021-02-25T15:04:13Z")

</div>

> [@dllahr](#):
>
> the cell line metadata file

I got the info for cell lines but need info for compounds  
thank you

---

<div class="post-metadata">

**Author:** ![dllahr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/dllahr/32/23_2.png) [@dllahr](https://forum.depmap.org/u/dllahr)\
**Post date:** [February 25, 2021, 5:34pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/5 "2021-02-25T17:34:45Z")

</div>

I think maybe you want this file:  
`primary-screen-replicate-treatment-info.csv`

Or maybe:  
`primary-screen-replicate-collapsed-treatment-info.csv`

From the downloads page if you search the name field for “info” you’ll find these and other metadata files.

---

<div class="post-metadata">

**Author:** ![jinxie](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jinxie](https://forum.depmap.org/u/jinxie)\
**Post date:** [February 25, 2021, 8:31pm UTC](https://forum.depmap.org/t/cell-line-list-and-compound-list/467/6 "2021-02-25T20:31:00Z")

</div>

> [@dllahr](#):
>
> primary-screen-replicate-collapsed-treatment-info.csv

I just downloaded the file, thank you