Sponsored Content
Full Discussion: Calculate Averages !
Top Forums Shell Programming and Scripting Calculate Averages ! Post 302525510 by rdcwayx on Thursday 26th of May 2011 11:58:44 PM
Old 05-27-2011
Something like this?

Code:
awk -F , -v i=5 '{ sum2+=$2;sum3+=$3} 
                 NR%i {print;next}
                 { print $0, (sum2>last2)?"UP":(sum2==last2)?"STABLE":"DOWN", (sum3>last3)?"UP":(sum3==last3)?"STABLE":"DOWN";
                   last2=sum2;last3=sum3;sum2=0;sum3=0
                 } ' infile



05/26/2011,1200,1500
05/26/2011,1201,1500
05/26/2011,1202,1500
05/26/2011,1203,1500
05/26/2011,1204,1500 UP UP
05/26/2011,1201,1500
05/26/2011,1205,1500
05/26/2011,1202,1500
05/26/2011,1206,1500
05/26/2011,1207,1500 UP STABLE
05/26/2011,1101,1500
05/26/2011,1105,1500
05/26/2011,1102,1500
05/26/2011,1106,1500
05/26/2011,1107,1500 DOWN STABLE

This User Gave Thanks to rdcwayx For This Post:
 

9 More Discussions You Might Find Interesting

1. Programming

Python Script to calculate averages

I'm fairly new to python so bare with me. I'm trying to write a script that would calculate my class average from exams. The script will look at a text file formatted like this: Calculus 95 90 92 Physics 80 85 92 History 90 82 83 95 The output should look like this: Calculus 92.33... (2 Replies)
Discussion started by: jl487
2 Replies

2. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do... (10 Replies)
Discussion started by: worm
10 Replies

3. Shell Programming and Scripting

Moving Averages SMA !

Hello, I am trying to create a awk script to calculate the simple moving average of two fields but I got only the result of the first field. Could you please help me to fix this awk shell script awk -F, -v points=5 ' { a = $2; b = $3; if(NR>=points) { total_a = 0; total_b... (1 Reply)
Discussion started by: csierra
1 Replies

4. Shell Programming and Scripting

Create a list of load averages

`/proc/loadavg` give me three indicators of how much work the system has done during the last 1, 5 & 15 minutes. How can i get a list of load averages that each averaged over the last minute for 10 minutes? (2 Replies)
Discussion started by: navidlog
2 Replies

5. Solaris

SAR averages question

Hi all Bit of a silly question, but if I run sar to get the CPU stats (something like this): sar -u 300 1 The figures that are returned, is it in the above case the average over 300 seconds, or does it just wait for 300 seconds before obtaining the readings? (1 Reply)
Discussion started by: kinetik
1 Replies

6. Shell Programming and Scripting

Taking the averages of columns with deletion of some lines

Hi, I am in stage of post processing some of my results. I wanted to plot the data against the three axis x,y,z. The data file is quite complicated and i have to take the average of x, y,z over different steps of my test. A typical file look like below: Time taken:4s No.of series : 3... (6 Replies)
Discussion started by: begin_shell
6 Replies

7. Solaris

Sparc Solaris 10 load averages

our server is running oracle database, it has: load average: 1.77, 1.76, 1.73 using only one cpu. is that too high? thanks. (4 Replies)
Discussion started by: orange47
4 Replies

8. How to Post in the The UNIX and Linux Forums

Daily averages...

I have date file like below.. 1995 1 2 10 29 38.6706 -6.53823 41.9201 1995 1 2 10 29 -49.2477 -4.59733 17.2704 1995 1 2 10 29 -49.2369 -4.48045 8.61348 1995 1 3 8 48 -42.2643 ... (3 Replies)
Discussion started by: athithi
3 Replies

9. Shell Programming and Scripting

Awk- Pivot Table Averages

Hi everyone, Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages. For example, suppose you have the following table with various individuals and their scores in round1 and round2: SAMPLE SCORE1 SCORE2 British ... (6 Replies)
Discussion started by: Geneanalyst
6 Replies
sctp_test(1)						      General Commands Manual						      sctp_test(1)

NAME
sctp_test - Send and receive messages via SCTP SYNOPSIS
sctp_test -H -P -h -p -l|s DESCRIPTION
This is a userspace test application for the SCTP Linux kernel reference implementation. OPTIONS
-H local-addr -P local-port -h remote-addr -p remote-port -s Act as client -l Listen for connections (server) -a assoc_pattern assoc_pattern in the mixed mode 0 = sequential ascending(default) 1 = random -d debug 0 = none 1 = min(default) 2 = max -c testcase 0 = 1 byte packets. 1 = 1352 byte packets. (fragmentation point for an i/f with 1500 as mtu.) 2 = 1353 byte packets. (min. size at which fragmentation occurs for an i/f with 1500 as mtu.) 3 = Sequence of 1, 1353, 32768 byte packets. 4 = Sequence of following size packets. (1, 1000, 2000, 3000, 5000, 10000,15000, 20000, 25000, 32768) 5 = 32768 byte packets. (default max receive window size.) 6 = random size packets. -ve value Packets of specifed size. -m msgsize (1500-65515, default value 32768) -x number_of_repeats -o order_pattern 0 = all unordered(default) 1 = all ordered 2 = alternating 3 = random -t stream_pattern 0 = sequential ascending(default) 1 = random -M max_stream (default value 0) -r seed (default 0, use time()) -L num_ports (default value 0). Run the mixed mode -S num_ports (default value 0). Run the mixed mode -D Drain. If in client mode do a read following send. USAGE
server: sctp_test -H local_addr -P local_port -l client: sctp_test -H local_addr -P local_port -h remote_addr -p remote-port -s AUTHOR
Michael Biebl <biebl@debian.org> sctp_test(1)
All times are GMT -4. The time now is 08:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy