Sponsored Content
Top Forums Shell Programming and Scripting Calculating the average of scores Post 302796671 by anurupa777 on Saturday 20th of April 2013 09:36:51 AM
Old 04-20-2013
Calculating the average of scores

Hi
I have 2 files
file1

Code:
aac 23 25
aac 87 90
aac 33 67

file2

Code:
23 0.9
24 0.8
25 0.4
........
67 0.55
........



I want to get output as

Code:
aac 23 25 0.7  i,e (0.9+0.8+0.4)/3


like this for all in file1

How to do that? Please help
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Calculating the average

This is the cronjob ---------------------- root@a7germ:/home/paxtemp > crontab -l|grep test 57 * * * * /home/paxtemp/test_1.sh 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/paxtemp/test.sh root@a7germ:/home/paxtemp > This is the contents of test.sh script... (2 Replies)
Discussion started by: kekanap
2 Replies

2. UNIX for Dummies Questions & Answers

Calculating the Number of Rows and Average

Hi All I like to know how can we calculate the number of rows and the average of the values present in the file. I will not know what will be the rowcount, which will be dynamic in nature of the file. eg. 29 33 48 30 28 (6 Replies)
Discussion started by: pk_eee
6 Replies

3. UNIX for Dummies Questions & Answers

Calculating average

Hi, i have 12 float variables in a bash file and i want to calculate the average of them. Can any body help? (6 Replies)
Discussion started by: limadario
6 Replies

4. UNIX for Dummies Questions & Answers

Calculating weighted average

Dear all, i have 200 values in a file. How can i calculate a weighted average and output into a new file avg.dat? INPUT: file1.dat 1.3453 2.434 2.345 ..... OUTPUT: avg.dat file1: 1.762 Thanks. Po (3 Replies)
Discussion started by: chen.xiao.po
3 Replies

5. Shell Programming and Scripting

Calculating average of 100 different files of same size

Hey guys..... I have many files (lets say 100 or more) of same size, and I want to create a new output file and calculate the average of first row fifth column in all files and print it in first row of output file, then 2nd row fifth col in all 100 files and print it in 2nd row of output... (1 Reply)
Discussion started by: CAch
1 Replies

6. Shell Programming and Scripting

Calculating average with awk

I need to find the average from a file like: data => BW:123 M:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0' data => BW:123 N:30 RTD:0 1... (4 Replies)
Discussion started by: Slagle
4 Replies

7. UNIX for Dummies Questions & Answers

Calculating average

Hi I have file like below 111,victor,48,12,36 342,Peter,54,58,30 476,Scott,25,36,48 567,Patty,74,17,95 I have written below code to calcualte avereage for every id Victor = 48+12+36/3 #!/bin/ksh /usr/xpg4/bin/awk ' BEGIN {FS=","} {sum=0; n=0;i=3 (1 Reply)
Discussion started by: stew
1 Replies

8. Shell Programming and Scripting

Python Script Calculating Average

Can anyone explain what each line of the code does and how it works? I have no experience with python so I am not sure how the arrays and such work. I found this code while looking through the forums. f = open("exams","r") l = f.readline() while l: l = l.split(" ") values = l ... (22 Replies)
Discussion started by: totoro125
22 Replies

9. Shell Programming and Scripting

Calculating average from files

I have some files with the following contents.I would like to calculate average of fifth column. How can I do this with awk? file1 cat 95.9 152 78.0 17.9 rat 67.1 153 36.5 30.6 dog 81.4 154 68.1 13.3 dog 92.0 155 55.5 36.5 rat 73.8 156 23.9 49.9 file2 rat... (4 Replies)
Discussion started by: avina
4 Replies
AAC(4)							   BSD Kernel Interfaces Manual 						    AAC(4)

NAME
aac -- Adaptec AdvancedRAID Controller driver SYNOPSIS
aac* at pci? dev ? function ? ld* at aac? unit ? DESCRIPTION
The aac driver provides support for the Adaptec AAC family of SCSI and SATA RAID controllers. These controllers support RAID 0, 1, 5, 10, and volume sets. They have four channels in the add-in version or 1-2 channels in the motherboard integrated version, and are most often found rebadged by Dell, Hewlett-Packard or IBM. Supported controllers include: o Adaptec AAC-364 o Adaptec SCSI RAID 2120S o Adaptec SCSI RAID 2200S o Adaptec SATA RAID 2410SA o Adaptec SATA RAID 3405 o Adaptec SCSI RAID 5400S o Dell PERC 2/Si o Dell PERC 2/QC o Dell PERC 3/Di o Dell PERC 3/Si o Dell PERC 320/DC o Dell CERC SATA RAID 1.5/6ch o HP NetRAID 4M o HP ML110 G2 (Adaptec SATA RAID 2610SA) o IBM ServeRAID 8k Access to RAID containers is available via the ld device driver. Individual drives cannot be accessed unless they are part of a container or volume set, and non-fixed disks cannot be accessed. Containers can be configured by using the on-board BIOS utility of the card. DIAGNOSTICS
The adapter can send status and alert messages asynchronously to the driver. These messages are printed on the system console. SEE ALSO
intro(4), ld(4) HISTORY
The aac driver first appeared in NetBSD 1.6, and was based on the FreeBSD driver of the same name. BUGS
This driver is not compatible with controllers that have version 1.x firmware. The firmware version is the same as the kernel version printed in the BIOS POST and driver attach messages. BSD
February 19, 2011 BSD
All times are GMT -4. The time now is 11:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy