Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Counting the number of element in each column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Counting the number of element in each column
# 1  
Old 11-17-2013
Counting the number of element in each column
Hello,

I have a file as follows:

Code:
ENSGALG00000000189                   
ENSGALG00000000189                   
ENSGALG00000000189                   
ENSGALG00000000215                   
ENSGALG00000000215                               
ENSGALG00000000218                   
ENSGALG00000000218                   
ENSGALG00000000218                   
ENSGALG00000000218

Code:
awk '{count[$1]++} {for (genes in count) { print genes, count[genes]}}' file

I want to count the number of each gene in the file, for example there are 3 of ENSGALG00000000189 and so on. I came up with the code above, but it doesn't work properly, could you please help me with that?

Thanks.
Last edited by Homa; 11-17-2013 at 07:28 AM..
# 2  
Old 11-17-2013
Try:
Code:
awk '{count[$1]++} END{for (genes in count) print genes, count[genes]}' ZGenes

This User Gave Thanks to Scrutinizer For This Post:
Homa
# 3  
Old 11-17-2013
Oops, sorry for posting this, I found my mistake:

Code:
awk '{count[$1]++} END{for (genes in count) { print genes, count[genes]}}' file

# 4  
Old 11-17-2013
You may try

Code:
$ egrep -o '\w+' file | sort -nk1 | uniq -c
      3 ENSGALG00000000189
      2 ENSGALG00000000215
      4 ENSGALG00000000218

OR

Code:
$ tr -s ' ' '\n' < file | sort | uniq -c
      3 ENSGALG00000000189
      2 ENSGALG00000000215
      4 ENSGALG00000000218

# 5  
Old 11-17-2013
Code:
uniq -cw18 file

This User Gave Thanks to RudiC For This Post:
greet_sed
# 6  
Old 11-17-2013
Quote:
Originally Posted by RudiC
Code:
uniq -cw18 file

Note: You would need the GNU version and a grouped (or sorted) input file...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding character and append last element of second column

Hi, could you help me in processing this file under bash? I need to add some text to the first line and then append the last element of the second columns. The input file is tab separated while the output should be space separated. input file is 1.00E-02 2.00E-02 4.465E+17 2.00E-02 3.00E-02... (4 Replies)
Discussion started by: f_o_555
4 Replies

2. Shell Programming and Scripting

Help: Counting values less than a number

So I have several files (35000, to be exact) in the format rmsd_protein_*.dat each with 2 columns and 35000 rows. I would like to count how many values in the second column are less than 3 for each file, and output it into a new file so that it ultimately appears as: 1 14057 2 ... (12 Replies)
Discussion started by: Alexandryne
12 Replies

3. Shell Programming and Scripting

Counting a consecutive number in column 2

Hi, I have a input file which contains following data 0 1 0 2 0 3 0 4 0 8 0 9 0 11 1 1 1 2 1 6 1 7 1 8 1 9 2 1 2 11 2 12 (12 Replies)
Discussion started by: Ryan Kim
12 Replies

4. Shell Programming and Scripting

Print the row element till the next row element appear in a column

Hi all I have file with columns F3 pathway CPS F2 H2 H4 H5 H6 no pathway CMP H7 H8 H9 H10 My expected output is F3 pathway CPS F2 pathway CPS (10 Replies)
Discussion started by: Priyanka Chopra
10 Replies

5. Shell Programming and Scripting

Counting the number of characters

Hi all, Can someone help me in getting the following o/p I/p:... (7 Replies)
Discussion started by: Sri3001
7 Replies

6. Shell Programming and Scripting

counting number of sentence

Hi all I want to count total numbers of sentences separated by fullstop (.) in different files under a directory at one go. Any help is appreciated. (3 Replies)
Discussion started by: my_Perl
3 Replies

7. Shell Programming and Scripting

counting the number of occurences

say i've got a text file with >10million sequences: ssss ssss tttttt uuuuuu uuuuuu uuuuuu ... I'd like to convert the file so that the output will report the number of occurence right by each sequence: 2 ssss 2 ssss 1 tttttt 3 uuuuuu 3 uuuuuu 3 uuuuuu .... (3 Replies)
Discussion started by: johjoh
3 Replies

8. Shell Programming and Scripting

counting the number of lines - again

Hi all, I use bash shell and I have a problem with wc. I would like to determine the number of lines in a file so I do wc -l filename but I don't want to get the filename again I just would like to have the number of lines and use it in a variable. Can anybody help? Thank you, (7 Replies)
Discussion started by: f_o_555
7 Replies

9. UNIX for Dummies Questions & Answers

Counting number of occurences

Hi All, I have to count the number of occurences of the character " ; " in a given line. I had used the following awk command to achieve the same echo $KOP.dat|awk '{split($1,my,";"); for(i in my)c++ }END{print c-1}' My file KOP.dat had the following data ... (1 Reply)
Discussion started by: kingofprussia
1 Replies

10. Linux

counting the number of lines

Hello, I have afile which begins with a few urls on multiple lines and then there is listing of some information on separate lines. The listing begins with the word Name on a given line followed by teh actual list. I want to count the number of lines in this file after the line having... (6 Replies)
Discussion started by: nayeemmz
6 Replies
Login or Register to Ask a Question