Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to calculate average of two columns and copy into another file?
Top Forums Shell Programming and Scripting How to calculate average of two columns and copy into another file? Post 302870969 by balajesuri on Tuesday 5th of November 2013 09:33:51 AM
Old 11-05-2013
Code:
[user@host ~]$ ls -l file*
-rw-r--r-- 1 user group 25 Nov  5 19:59 file1
-rw-r--r-- 1 user group 20 Nov  5 19:59 file2
[user@host ~]$ cat test.sh
#! /bin/bash

for f in file*
do
    s1=0
    s2=0
    c=0
    while read c1 c2
    do
        s1=$(( s1 + c1 ))
        s2=$(( s2 + c2 ))
        (( c++ ))
    done < $f
    echo "Name: $f --> $(( s1 / c )) $(( s2 / c ))"
done
[user@host ~]$ ./test.sh
Name: file1 --> 55 99
Name: file2 --> 116 85
[user@host ~]$

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

calculate average of column 2

Hi I have fakebook.csv as following: F1(current date) F2(popularity) F3(name of book) F4(release date of book) 2006-06-21,6860,"Harry Potter",2006-12-31 2006-06-22,,"Harry Potter",2006-12-31 2006-06-23,7120,"Harry Potter",2006-12-31 2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Discussion started by: onthetopo
0 Replies

2. UNIX for Dummies Questions & Answers

Use awk to calculate average of column 3

Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies

3. Programming

calculate average

I have a file which is 2 3 4 5 6 6 so i am writing program in C to calculate mean.. #include<stdio.h> #include<string.h> #include <math.h> double CALL mean(int n , double x) main (int argc, char **argv) { char Buf,SEQ; int i; double result = 0; FILE *fp; (3 Replies)
Discussion started by: cdfd123
3 Replies

4. Shell Programming and Scripting

Calculate average of each of position of contents in a huge file

My input: >AAA_100 10 20 50 60 10 100 15 10 >AAA_100 20 20 50 60 20 100 15 10 >AAA_100 10 20 50 60 40 100 15 10 >AAA_100 40 20 50 60 10 100 15 10 . . . My Output 20 20 50 60 20 100 15 10 If I have a long list of file. I want to calculate average of each position inside the contents... (7 Replies)
Discussion started by: patrick87
7 Replies

5. Shell Programming and Scripting

Calculate Average AWK

I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall: Example file: File 1 001 0.046 0.667267 001 0.047 0.672028 001 0.048 0.656025 001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies

6. Shell Programming and Scripting

Calculate average from CSV file using PERL script

Hi All I have this csv file and I need to calculate the average of FPS. FPS:27.7420, Interval:1314184238772 FPS:25.9798, Interval:1314184242646 FPS:27.4772, Interval:1314184246311 FPS:26.1623, Interval:1314184250159 FPS:26.4515, Interval:1314184253972 FPS:31.5896, Interval:1314184257163... (24 Replies)
Discussion started by: sayachop
24 Replies

7. UNIX Desktop Questions & Answers

Calculate average for rows in a text file

Dear Gurus, I have tab-delimited text files with matrix containing values. The first column is a identifier and other columns have the corresponding values. I would like to calculate the average value (total number/number of entries) for all entries from 2nd column to the last column in row... (3 Replies)
Discussion started by: Unilearn
3 Replies

8. Shell Programming and Scripting

awk based script to find the average of all the columns in a data file

Hi All, I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side. I have... (4 Replies)
Discussion started by: ks_reddy
4 Replies

9. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
Discussion started by: ncwxpanther
1 Replies

10. Shell Programming and Scripting

Calculate the average per block.

My old school way is a one liner. And will search for average from SAR, to get the data receive rate. But, I dont think it is practical or accurate,. Because it calculates to off peak hours. I am planning to change it. My cron runs every 30 mins. When my cron runs, and my time is 14:47pm,, it will... (1 Reply)
Discussion started by: invinzin21
1 Replies

LEARN ABOUT BSD

mv

MV(1)							      General Commands Manual							     MV(1)

NAME

       mv - move or rename files

SYNOPSIS

       mv [ -i ] [ -f ] [ - ] file1 file2

       mv [ -i ] [ -f ] [ - ] file ... directory

DESCRIPTION

       Mv moves (changes the name of) file1 to file2.

       If file2 already exists, it is removed before file1 is moved.  If file2 has a mode which forbids writing, mv prints the mode (see chmod(2))
       and reads the standard input to obtain a line; if the line begins with y, the move takes place; if not, mv exits.

       In the second form, one or more files (plain files or directories) are moved to the directory with their original file-names.

       Mv refuses to move a file onto itself.

       Options:

       -i     stands for interactive mode. Whenever a move is to supercede an existing file, the user is prompted by the name of the file followed
	      by  a  question mark. If he answers with a line starting with 'y', the move continues. Any other reply prevents the move from occur-
	      ring.

       -f     stands for force. This option overrides any mode restrictions or the -i switch.

       -      means interpret all the following arguments to mv as file names.	This allows file names starting with minus.

SEE ALSO

       cp(1), ln(1)

BUGS

       If file1 and file2 lie on different file systems, mv must copy the file and delete the original.  In this case the owner name becomes  that
       of the copying process and any linking relationship with other files is lost.

4th Berkeley Distribution					  April 29, 1985							     MV(1)
All times are GMT -4. The time now is 12:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy