I'm attempting to manipulate one of my data files. Basically, I'm attempting to do the equivalent of a pivot table or use the COUNTIF function in excel on my file. I have a file with a column named 'seqname' full of genes, and I would like to add a new column that contains the counts of the unique gene entries. For example, if a gene name appears 4 times in a row I want a new column that says the count is 4 for that gene.
The data file is:
[che625@washington.edu].[Promoter_GeneExpression_Methylation_CGs]
I'm attempting to manipulate one of my data files. Basically, I'm attempting to do the equivalent of a pivot table or use the COUNTIF function in excel on my file. I have a file with a column named 'seqname' full of genes, and I would like to add a new column that contains the counts of the unique gene entries. For example, if a gene name appears 4 times in a row I want a new column that says the count is 4 for that gene.
The data file is: [che625@washington.edu].[Promoter_GeneExpression_Methylation_CGs]
Thank you!!!