Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Want to get average value for each hour
Top Forums UNIX for Advanced & Expert Users Want to get average value for each hour Post 302940285 by Don Cragun on Friday 3rd of April 2015 01:06:46 AM
Old 04-03-2015
Quote:
Originally Posted by mjf
Try this awk solution if I understand what you are looking for (untested as more sample data is needed).

Code:
awk -F'|' 'NR>2 {hour=" " substr($2,1,2); array[$1 hour] += $3 count[$1 hour]++ } END { for (a in array) {print a, array[a]/count[a] } } ' file | sort
03/02/2015 00 26.2439
03/02/2015 01 26.3635
03/03/2015 01 18.99

I have only tested this with the given data, but I'm surprised that you're showing sample output that includes the data marked in red above when there was no sample input for that date. When I tried running the above code with the given sample input, I didn't get the last line of the output shown above.

It also looks like there is a missing semicolon. Did you perhaps intend the following?:
Code:
awk -F'|' 'NR>2 {hour=" " substr($2,1,2); array[$1 hour] += $3; count[$1 hour]++ } END { for (a in array) {print a, array[a]/count[a] } } ' file | sort

which produces the output:
Code:
03/02/2015 00 26.24
03/02/2015 01 26.36

from the given sample input. And, this seems to match the given sample input.
These 2 Users Gave Thanks to Don Cragun For This Post:
babinlonston Saravanan_0074
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

1 Hour less

set DAY=`date +%y%m%d` set H=`date +%H` set M=`date +%M` mailx -s "$H-Mydata" myemail@mail.com<mydata I am looking to set the current hour to have 1 hour less in the subject header: For example: let's say the system time is 8 I want to have "7-Mydata" not "8-Mydata" Can some1... (6 Replies)
Discussion started by: bobo
6 Replies

2. UNIX for Dummies Questions & Answers

an hour less in 24 hour system

My program: __________________________________ #!/bin/ksh DAY=`date +%y%m%d` H=`date +%H` M=`date +%M` day=`date +%m/%d/%y` let h=$H-1 echo DAY $DAY echo H $H echo M $M echo day $day echo h $h _____________________________________ My result: (3 Replies)
Discussion started by: bobo
3 Replies

3. Shell Programming and Scripting

help in hour grep

i have this script that checks for yesterday date and also specific hour in that ----------------------------------------------------------------- TZ=`date +%Z`+24 ;a=`date +%Y-%m-%d %k` cd logs count=0 for i in DBMaint.log do cat $i | grep $a >> file12.txt done... (0 Replies)
Discussion started by: ali560045
0 Replies

4. Shell Programming and Scripting

Counting average data per hour

Hi i have log like this : Actually i will process the data become Anybody can help me ? (6 Replies)
Discussion started by: justbow
6 Replies

5. What is on Your Mind?

Power Hour?

I had some free time at work today so I decided to get a little practice with my shell scripts (I'm pretty new to the whole UNIX thing). I'm sure I'm not the only college student here so maybe this code will come in handy for future weekends. #!/bin/sh if then echo "No playlist... (0 Replies)
Discussion started by: thedoobieman5
0 Replies

6. Shell Programming and Scripting

Getting the last hour from a log.

I have a log like this: Jan 26 13:59:41 server2 ntpdate: step time server 91.189.94.4 offset 0.065456 sec Jan 26 13:59:41 server2 ntpd: ntpd 4.2.4p8@1.1612-o Fri Aug 6 22:49:54 UTC 2010 (1) Jan 26 13:59:41 server2 ntpd: precision = 1.000 usec Jan 26 13:59:41 server2 ntpd: ntp_io: estimated max... (2 Replies)
Discussion started by: Jotne
2 Replies

7. UNIX for Dummies Questions & Answers

Load average spikes once an hour

Hi, I am getting a high load average, around 7, once an hour. It last for about 4 minutes and makes things fairly unusable for this time. How do I find out what is using this. Looking at top the only thing running at the time is md5sum. I have looked at the crontab and there is nothing... (10 Replies)
Discussion started by: sm9ai
10 Replies

8. Shell Programming and Scripting

How to convert 24 hour time to 12 hour timing?

Hi friends, I want to convert 24 hour timing to 12 hour please help me... my data file looks like this.. 13-Nov-2011 13:27:36 15.32044 72.68502 13-Nov-2011 12:08:31 15.31291 72.69807 16-Nov-2011 01:16:54 15.30844 72.74028 15-Nov-2011 20:09:25 15.35096 ... (13 Replies)
Discussion started by: nex_asp
13 Replies

9. Shell Programming and Scripting

How to get next hour?

Hi guys I want any script to get me next hour For example Nexthour.sh 2013022823 It get me result 2013030100 Thanks a lot , I'm using Solaris 10 (5 Replies)
Discussion started by: teefa
5 Replies

10. Shell Programming and Scripting

Average of multiple time-stamped data every half hour

Hi All, Thank you for reading through my post and helping me figure out how I would be able to perform this task. For example: I have a list of continuous output collected into a file in the format as seen below: Date...........Time........C....A......... B ==========================... (5 Replies)
Discussion started by: terrychen
5 Replies

LEARN ABOUT DEBIAN

glgetmultisamplefv

GLGETMULTISAMPLEFV(3G)						  [FIXME: manual]					    GLGETMULTISAMPLEFV(3G)

NAME

       glGetMultisamplefv - retrieve the location of a sample

C SPECIFICATION

       void glGetMultisamplefv(GLenum pname, GLuint index, GLfloat *val);

PARAMETERS

       pname
	   Specifies the sample parameter name.  pname must be GL_SAMPLE_POSITION.

       index
	   Specifies the index of the sample whose position to query.

       val
	   Specifies the address of an array to receive the position of the sample.

DESCRIPTION

       glGetMultisamplefv queries the location of a given sample.  pname specifies the sample parameter to retrieve and must be
       GL_SAMPLE_POSITION.  index corresponds to the sample for which the location should be returned. The sample location is returned as two
       floating-point values in val[0] and val[1], each between 0 and 1, corresponding to the x and y locations respectively in the GL pixel space
       of that sample. (0.5, 0.5) this corresponds to the pixel center.  index must be between zero and the value of GL_SAMPLES - 1.

       If the multisample mode does not have fixed sample locations, the returned values may only reflect the locations of samples within some
       pixels.

ERRORS

       GL_INVALID_ENUM is generated if pname is not one GL_SAMPLE_POSITION.

       GL_INVALID_VALUE is generated if index is greater than or equal to the value of GL_SAMPLES.

SEE ALSO

       glGenFramebuffers(), glBindFramebuffer()

COPYRIGHT

       Copyright (C) 2010 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
       License, v 1.0, 8 June 1999.  http://opencontent.org/openpub/.

[FIXME: source] 						    05/30/2012						    GLGETMULTISAMPLEFV(3G)
All times are GMT -4. The time now is 01:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy