# How can we know the last value of TPM taken by DepMap for normalization of gene expression ? **URL:** \ **Category:** Q&A\ **Tags:** data\ **Created:** [June 4, 2023, 12:52am UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605 "2023-06-04T00:52:57Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Srinjoyee](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Srinjoyee](https://forum.depmap.org/u/Srinjoyee)\ **Post date:** [June 4, 2023, 12:52am UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/1 "2023-06-04T00:52:57Z")
So I have to list my cell lines for TNBC and I was searching for the expression of CEBPB in MD MB 231 cell for tnbc . In the characterization option I saw that _cebpb_ is not being expressed in the MD MB 231 cell line but in the protein atlas there is expression of the gene in the MD MB 231 cell line .I was wondering if I can see the raw data for the values of TPM taken by depmap so that I can get an idea ? ---
**Author:** ![simz](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/simz/32/440_2.png) [@simz](https://forum.depmap.org/u/simz)\ **Post date:** [June 6, 2023, 2:01pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/2 "2023-06-06T14:01:24Z")
Hi, We provide expression expected count data on both gene- and transcript-level. If you navigate to the file downloads page, you should be able to access OmicsExpressionGenesExpectedCountProfile.csv and OmicsExpressionTranscriptsExpectedCountProfile.csv, respectively. Hope this helps, Simone ---
**Author:** ![Srinjoyee](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Srinjoyee](https://forum.depmap.org/u/Srinjoyee)\ **Post date:** [June 6, 2023, 3:09pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/3 "2023-06-06T15:09:21Z")
Hi so I checked the gene by the transcript id ENST00000303004 and its not present in the csv data. Do you know any possible reasons for this ? .It has 3 isoforms as well , is it the reason that’s its not present there?? ---
**Author:** ![simz](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/simz/32/440_2.png) [@simz](https://forum.depmap.org/u/simz)\ **Post date:** [June 6, 2023, 3:51pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/4 "2023-06-06T15:51:31Z")
By csv data, do you mean OmicsExpressionTranscriptsExpectedCountProfile.csv? I see a column called “CEBPB (ENST00000303004)” in this file, and a column called “CEBPB (ENSG00000172216)” in OmicsExpressionGenesExpectedCountProfile. Is either of these what you are looking for? ---
**Author:** ![Srinjoyee](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Srinjoyee](https://forum.depmap.org/u/Srinjoyee)\ **Post date:** [June 7, 2023, 7:19am UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/5 "2023-06-07T07:19:08Z")
Oh yes!!! that’s the gene I am lookin for , but when I am typing the gene name in the excel file , its showing they couldn’t find it. Can you please tell me how to troubleshoot it or send the screenshot of the CEBPB gene in both the csv files ? ---
**Author:** ![simz](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/simz/32/440_2.png) [@simz](https://forum.depmap.org/u/simz)\ **Post date:** [June 7, 2023, 1:45pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/6 "2023-06-07T13:45:27Z")
The files are quite large so I suspect excel is probably not able to handle a search like this. I’d highly recommend parsing these data frames programmatically. ---
**Author:** ![Srinjoyee](https://avatars.discourse-cdn.com/v4/letter/s/9dc877/32.png) [@Srinjoyee](https://forum.depmap.org/u/Srinjoyee)\ **Post date:** [June 7, 2023, 1:59pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/7 "2023-06-07T13:59:55Z")
> [@simz](#): > > parsing these data frames programmatically. I am very much new to bioinformatics so I couldn’t understand what you are suggesting. Can you please simplify as to how it will be easy for me to the check the tpm values of the gene CEBPB ? ---
**Author:** ![simz](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.depmap.org/simz/32/440_2.png) [@simz](https://forum.depmap.org/u/simz)\ **Post date:** [June 7, 2023, 2:18pm UTC](https://forum.depmap.org/t/how-can-we-know-the-last-value-of-tpm-taken-by-depmap-for-normalization-of-gene-expression/2605/8 "2023-06-07T14:18:16Z")
One way to programmatically read data frames is using pandas in python. I’d suggest checking out this tutorial: [Read csv using pandas.read\_csv() in Python - GeeksforGeeks](https://www.geeksforgeeks.org/python-read-csv-using-pandas-read_csv/#)