Search Results

No sir. I am able to do that with floowing -
nawk '{c[$1]++;s[$1]+=$2}END{ for(i in c) printf("%s %.5f\n", i, s[i]/c[i])}'
but thing is that it calculates differnce from top to bootom for...

Hi All,
IS there any 'awk' way to manipulate following data?

Fruit Date Count
Apple 20/08/2011 5
Apple 27/08/2011 7
Apple 05/09/2011 11
Apple 12/09/2011 3
Apple 19/09/2011 25
.
.
.
....

Thanks for your reply.
But its not working in my case as its not in proper format. However I have separate out min values and now trying to round off them to nearest multiple of 5.
So now data at...

Hi,
I have a data like

Date Time Pulse
04/02/2012 00:01:05 2
04/02/2012 00:01:48 5
04/02/2012 00:02:09 3
04/02/2012 00:03:19 4
04/02/2012 00:04:40 1
04/02/2012 00:04:45 9
04/02/2012...

Thanks Jim Mcnamara !!! You are awesome !!! Its what I wanted.

Hi Guys,
I am having some issue in one aspect. I am having data like -

00:00
X-1
Y-1
Z-4
A-5
E-6
.
.
.

.
01:00
Z-9
X-1
Z-5
A-8
E-7