Want to get average value for each hour Post: 302941306

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Want to get average value for each hour Post 302941306 by Don Cragun on Wednesday 15th of April 2015 02:09:46 AM

04-15-2015

Registered User

Quote:

Originally Posted by mjf

Don,
I interpreted the data Saravanan_0074 included in his/her last post to be the output, not the input, of running the awk command (in which case you would need-F'|'and NR>2). The avg of 26.2439 (should be 26.24) for hour 00 appears to match the input in the original post although there appears to not be enough input data to confirm the hours beyond 00 in the output.

You are correct re: the sort of the date.

You may be correct. If that is the case, the only thing wrong with the Saravanan_0074's script was the missing semicolon (like the problem you had in post #2 in this script). But, it clearly is not going to provide a daily average; only hourly averages.

But, the stated goal in post #10 is to get the daily average, and the script in that post does NOT do that. And, it isn't clear which average is desired. Is the desire to get the arithmetic mean of the hourly arithmetic means? (That is what the script I suggested would provided if the data shown in post #10 was fed into it as input.) Is the desire to get the arithmetic mean of the individual data for each day? Or, is some other average desired???

Is there ever input for more than one day in the input file?
Are there always the same number of sample points for each day (and the same number of sample points each day for each hour)? What happens on days when there is a shift to or from daylight savings time?

Is the sort in the pipeline intended to sort average day values into date order? Or, is it intended to sort average hourly values for a single date into hour order? If daily averages and hourly averages are both supposed to be in the output, what is the sort order supposed to be? What output format is wanted for the daily average values?

Sometimes I get tired of trying to guess what requirements we are trying to meet.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

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...

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. 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...

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 ?

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...

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...

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...

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 ...

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

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 ==========================...

LEARN ABOUT OSX

sa1

sa1(8)							    BSD System Manager's Manual 						    sa1(8)

NAME

     sa1 -- Generate a system activity daily data file.

SYNOPSIS

     /usr/lib/sa/sa1 [t n]

DESCRIPTION

     The sa1 command is a shell script used to invoke the system activity data collector, sadc.  The binary sample data is collected at intervals
     t seconds apart, in a loop n times.  The binary sample data is written to the standard daily data file, /var/log/sa/sadd where the dd repre-
     sents the current day of the month.

     sa1 is intended to be started by cron.

EXAMPLE CRON ENTRY

     # Starting at 8am collect system activity records
     # every 20 minutes for 12 hours
     # 20 minutes = 1200 seconds
     # 12 hours with 3 samples each hour = 36 loops

     0 8 * * 1-5 /usr/lib/sa/sa1 1200 36

     # After the 12 hour period,
     # collect a system activity report

     30 20 * * 1-5 /usr/lib/sa/sa2 -A

FILES

     /var/log/sa/sadd  Default daily activity file that holds the binary sampling data.  dd are digits that represent the day of the month.

SEE ALSO

     crontab(1), fs_usage(1), netstat(1), sar(1), sc_usage(1), top(1), vm_stat(1), crontab(5), iostat(8), sa2(8), sadc(8)

Mac OS X							    Jul 25 2003 							  Mac OS X