I have a long list of genes but Im giving some list
ACTL6A
ACTL6B
ACTR5
ACTR8
AICDA
ANP32B
ANP32E
APEX1
APOBEC1
So i have the final cuffdiff output which is basically a massive csv files with all the genes and their corresponding values etc .
Now how am I going to search all these genes from the excel sheet ,one of the most simplest way is to use control+F in excel and keep on searching till i find the gene and values, but this is tedious and at times it would be wastage of time if my list of genes is really huge.
So can anyone could tell me how can i do search for the gene in R or in shell script , i guess this is like parsing but since I have no idea how to proceed so I need help.
I have my dataframe in as such manner
Gene sample1 sample 2 value1 value2 p value significant
so the logic that i would like to follow is find the gene and then extract the corresponding information lets say i just need value1 and value2
How do i do that in R or simple shell script?
Any help or suggestion would be highly appreciated