UNIX for Dummies Questions & Answers

provide sample input and a desired output.
most likely you don't need 'uniq' and can do it all in awk.

Hi,

managed to crack it.

The data is like this

1319188458.353690 0.46975
1319188458.823439 0.07558
1319188458.899017 0.00020
1319188458.899217 0.00120
1319188458.900415 0.25879

i split the part before '.' using

Code:

cut -d '.' -f1

then used

Code:

awk '{counts[$1]++} END {for (i in counts) {print i, counts[i]}}'

put back both the count and time data together using paste -d

and if i plot this data gnuplot works perfectly.

Is there any way to do this all at one go using awk? that would be great.

Thanks for your help guys!!

Code:

awk '{c[substr($1,1,index($1, ".")-1)]++}END{ for (i in c) print i, c[i]}' myFile

perfect thanks