This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to create the matrix of expression values from different gene lists for generating heat map?

Hi,

I have several lists of up-regulated and down-regulated genes (with their fold change values). Different genes are expressed in different conditions. Now how to create the matrix for heat map generation using all these genes lists? As I have hundreds of genes, manually searching each gene in all the lists and feeding its respective fold chane will be insane

heat map gene lists matix
• 3,759 views • link
updated by Carlo Yague Carlo Yague • written by mirza mirza

This seems like a very basic task... Can u script with R or python ? or do you want an answer based on Excel ?

• 1 views • link
written by Carlo Yague Carlo Yague

better be excel right now. I am trying to learn R

• 1 views • link
written by mirza mirza

I get it, its really a bad choice to use excel. Please suggest some solutions. Please direct me to some tutorials or web page or forum discussions where I can find the answers.

• 1 views • link
written by mirza mirza

Please suggest some solution with R, I can us it to some extent. I know we can use ggplots but I think I need to create the matrix first?

• 1 views • link
written by mirza mirza

1 answer

With excel, you can create a column with all the gene IDs you are interested in, then use Vlookup to search the expression value corresponding to the IDs in the different tables (conditions).

In R, you can use merge() to merge dataframes based on the geneID column or whatever.

• 1 views • link
written by Carlo Yague Carlo Yague

Log in to answer this question.

More posts like this