mercredi 4 mars 2015

How to print incremental count of occurrences of the same value in column 1


I'm trying to come up with an solution to this problem, I need to incrementally count and then print the counts of the unique values in column 1 of a tab delimited text file. Here is an example:




Apple_1 1 300
Apple_2 1 500
Apple_2 500 1500
Apple_2 1500 2450
Apple_3 1 1250
Apple_3 1250 2000


And the desired output is:




Apple_1 1 300 1
Apple_2 1 500 1
Apple_2 500 1500 2
Apple_2 1500 2450 3
Apple_3 1 1250 1
Apple_3 1250 2000 2


I know that I can print the line number in awk with just print NR, but I don't know how to reset it for each unique value of column 1.


Thanks for any help you can offer, I appreciate it.



Aucun commentaire:

Enregistrer un commentaire