Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Calculating the average of scores

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Calculating the average of scores
# 8  
Old 04-22-2013
One thing to suggest is add fflush () as follows: t/($3-$2+1)}; fflush ()' file2 file1 so when it crashes, and you are saving the output, you can see where it crashes, or even see if it gets to file1. There is a good chance the output might provide a clue. If your awk does not support fflush, it will quickly let you know.
# 9  
Old 04-22-2013
since its taking huge time and memory i tried to include it in perl and run in my server the script is as follows
Code:
use strict;
use Data::Dumper;
use Carp;
use File::Basename;

my $path = "/home/jpsl/";
my $file1 = "2";
my $file2 = "1";

    open PIPE, "| qsub" or die $!;
    print PIPE <<EOF;
#!/bin/sh
#PBS -N Perl
#PBS -l select=4:ncpus=4
#PBS -k oe

awk 'NR==FNR{A[$1]=$2; next}{t=0; for(i=$2; i<=$3; i++)t+=A[i]; print$0, t/($3-$2+1)}' $file1 $file2


EOF

Code:
its returning error like this
awk: NR==FNR{A[]=; next}{t=0; for(i=; i<=; i++)t+=A[i]; printtrail.pl, t/(-+1)}
awk:           ^ syntax error
awk: fatal: invalid subscript expression

# 10  
Old 04-22-2013
Running the awk command within perl is not going to speed anything up or use less memory. Is there some reason not to put in shell script? Sorry, I don't know why you are getting the error messages. I don't normally use perl. Are you sure you are invoking the awk external command correctly from within perl? Is your perl script called trail.pl by any chance? Smilie
# 11  
Old 04-22-2013
I wanted to run it in server through pbs so i included it in perl. ya my perl script is trail.pl
# 12  
Old 04-22-2013
Aha!! Look at your error message. perl is translating print$0 to printtrail.pl result. All those $0 and $1 etc. are being interpreted by perl, not by awk. There is something wrong with the way you are invoking the awk from within perl.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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