Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Calculate Averages !

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Calculate Averages !
# 1  
Old 05-27-2011
Question Calculate Averages !
Hi,

I have a file with more than 2,000 rows like this:
Code:
05/26/2011,1200,1500

I would like to create a awk shell script that calculate the price average of the second and third field each 5,10 and 20 rows or ask me for the values, starting at first row.

Finally compare the average value obtained with the price of last row of the range used for the average, so know whether price is up or down.

Thanks a lot
# 2  
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:
csierra
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

9. 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
Login or Register to Ask a Question