I have a file that has enhancers in 1st column and the name of transcription factor in 2nd column for which it has binding sites. I want to see this data visually so I can know which enhancers share similar transcription factor binding sites. How can I make a heatmap out of it? or any other visual graph that would allow me to do this?Because if i want to make a heatmap out of it, I'll have to make a table with enhancers in rows and transcription factors in columns and I cant do that manually as I have a huge data list. My data looks like this:
Enhancer TF Gene1_Enhancer1 Arid3a Gene1_Enhnacer1 Ascl2 Gene1_Enhancer1 EBP Gene1_Enhancer2 ETS1 Gene2_Enhancer1 ETS1 Gene2_Enhancer1 Hltf Gene3_Enhancer1 Hoxa4 Gene3_Enhancer2 Hoxa7 Gene4_Enhancer1 Hoxa4
Thanks a lot!!!