Sponsored Content
Top Forums UNIX for Advanced & Expert Users Want to get average value for each hour Post 302940281 by mjf on Thursday 2nd of April 2015 10:36:06 PM
Old 04-02-2015
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

 

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
OSDClock(1)						      General Commands Manual						       OSDClock(1)

NAME
osd_clock - X on-screen clock displayer SYNOPSIS
osd_clock [OPTION]... [+FORMAT] DESCRIPTION
Display date/time information on screen. -f FONT Set font. -c COLOR Set color. -d DELAY Sets the delay (in seconds) that the clock is exposed. Useful if combined with INTERVAL. -F FORMAT This option specifies the format to be used to output the date. See 'strftime(3)'. -i INTERVAL This specifies the interval between displays. Default is 1 (display every second). -H INTEGER The "chimes per hour" count overrides -i. Default is 0 (no effect). The time will be displayed this many times each hour (notwithstanding signals interrupting sleep, and leap seconds). The first dis- play of the hour will be on the hour exactly. Use -H 4 for a display at 0, 15, 30 and 45 minutes past. -s SHADOW This option sets the shadow depth. Default 2. -t locate clock at top left (default: bottom left). -b locate clock at bottom left (default). -o OFFSET This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0. Useful to move above or below panels or applets. -h, --help display this help and exit BUGS
The per-hour mode may fire up to one second late, or worse if the system is busy. AUTHOR
Jon Beckham <leftorium@leftorium.net> Martijn van de Streek <martijn@foodfight.org> Nathan Walp <faceprint@faceprint.com> COPYRIGHT
It is distributed under the GNU General Public License. X OSD Clock March 2001 OSDClock(1)
All times are GMT -4. The time now is 07:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy