Hi
I need help to make heat map with excel file of microarray data. and how i can make different cluster according to functional group of the genes.If someone know which programme i can use which is publically available online.
Thank you very much in anticipating
Submit your paper to J Biol Methods today!

Heatmap from excel file
Started by MicroRNAQa, Mar 31 2011 06:39 PM
3 replies to this topic
#1
Posted 31 March 2011 - 06:39 PM
#2
Posted 01 April 2011 - 12:57 AM
hi, look for cluster 3.0 and java treeview on the web using google.
you have to convert your excel file to a .txt file but this should be no problem.
you have to convert your excel file to a .txt file but this should be no problem.
tea-test: The artist formerly known as Ned Land
#3
Posted 17 May 2011 - 01:36 AM
you can use R
to import your data in R from excel, you've to export your sheet in csv format (tab delimited)
in R :
A <- read.table("your file.csv",header=TRUE,row.names=TRUE,sep="\t")
heatmap(as.matrix(A))
here's more info and examples : http://www2.warwick....cock/r/heatmap/
to import your data in R from excel, you've to export your sheet in csv format (tab delimited)
in R :
A <- read.table("your file.csv",header=TRUE,row.names=TRUE,sep="\t")
heatmap(as.matrix(A))
here's more info and examples : http://www2.warwick....cock/r/heatmap/
Edited by NicoBxl, 17 May 2011 - 01:40 AM.
#4
Posted 29 January 2013 - 08:04 AM
Please excuse me to bring an old topic up. However I need some help in getting the Microarray data (Excel sheet) in a format which cluster understand. Is there any possibility that someone can explain step by step the process from the beginning (Excel) to the end (Java Treeviewer). I really appreciate you help.