Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Problem with getting awk to multiply a field by a value set based on condition of another field
Top Forums UNIX for Beginners Questions & Answers Problem with getting awk to multiply a field by a value set based on condition of another field Post 303043683 by RudiC on Monday 3rd of February 2020 07:06:06 PM
Old 02-03-2020
Quote:
Originally Posted by cotilloe
Wow, very simple. But why wouldn't it work the way I was trying? (Using an if/else block)
Difficult to say without in depth analysis. Guessing from a first peek: You got the blocks mixed up. The grade can only be determined when all results are summed up, i.e. in the END section.
And, you're testing too many conditions. Once the average IS NOT greater than or equal, it is automatically less, and the test can go.



Quote:
What does the 'R' represent in the second arg for the function?
Residual of former test - can go away.


How about
Code:
awk '
BEGIN           {split ("97 94 90 87 84 80 76 70 60 0", THRSH)
                 split ("A+ A  A- B+ B  B- C+ C  D  E", TMPGR)
                }
function GRD(AVG,   i)  {while ((AVG < THRSH[++i]) && (i < 11)) ;
                         return TMPGR[i]
                        }


FNR==NR         {WEIGHT[$1] = $3
                 next
                }
FNR == 1        {next
                }
                {SUM[$1]    += $4 * WEIGHT[$2]
                 TOT[$2,$3] += $5 * WEIGHT[$2]
                 CNT[$2,$3]++
                }
END             {for (t in TOT) TOTAL += TOT[t] / CNT[t]
                 for (s in SUM) {AVG = SUM[s] / TOTAL * 100 
                                 print s, SUM[s], AVG, GRD(AVG)
                                }
                }
' OFS="\t" OFMT="%.2f" file1 file2
Sam        349.45    60.75    D
Chelsey    536.95    93.34    A-
Andrew     402.60    69.99    D
Shane      427.75    74.36    C
Ava        434.50    75.53    C

Not sure if the algorithm to determine the TOTAL possible is reliable in other contexts - it takes the average per assignment of the participants thus ruling out students have missed an exam.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find top N values for field X based on field Y's value

I want to find the top N entries for a certain field based on the values of another field. For example if N=3, we want the 3 best values for each entry: Entry1 ||| 100 Entry1 ||| 95 Entry1 ||| 30 Entry1 ||| 80 Entry1 ||| 50 Entry2 ||| 40 Entry2 ||| 20 Entry2 ||| 10 Entry2 ||| 50... (1 Reply)
Discussion started by: FrancoisCN
1 Replies

2. UNIX for Dummies Questions & Answers

awk - Summing a field based on another field

So, I need to do some summing. I have an Apache log file with the following as a typical line: 127.0.0.1 - frank "GET /apache_pb.gif HTTP/1.0" 200 2326 Now, what I'd like to do is a per-minute sum. So, I can have awk tell me the individual minutes, preserving the dates(since this is a... (7 Replies)
Discussion started by: treesloth
7 Replies

3. Shell Programming and Scripting

Update a field in a file based on condition

Hi i am new to scripting. i have a file file.dat with content as : CONTENT_STORAGE PERCENTAGE FLAG: /storage_01 64% 0 /storage_02 17% 1 I need to update the value of FLAG for a particular CONTENT_STORAGE value I have written the following code #!/bin/sh threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies

4. Shell Programming and Scripting

Help with Awk finding and replacing a field based on a condition

Hi everybody, I'm trying to replace the $98 field with "T" if the last field (108th) is T I've tried awk 'BEGIN{OFS=FS="|"} {if ($108=="T")sub($98,"T"); print}' test.txt but that doesn't do anything also tried awk 'BEGIN{OFS=FS="|"}{ /*T.$/ sub($98,"T")} { print}' test.txt but... (2 Replies)
Discussion started by: jghi123
2 Replies

5. Shell Programming and Scripting

awk to count condition in field

I am trying to confirm the counts from another code and tried the below awk, but the syntax is incorrect. Basically, outputting the counts of each condition in $8. Thank you :) awk '$8==/TYPE=snp/ /TYPE=ins/ /TYPE=del/ {count++} END{print count}'... (6 Replies)
Discussion started by: cmccabe
6 Replies

6. Shell Programming and Scripting

awk to update value in field based on another field

In the tab-delimeted input file below I am trying to use awk to update the value in $2 if TYPE=ins in bold, by adding the value of HRUN= in italics. In the below since in line 1 TYPE=ins the 117282541 value in $2 has 6 added because that is the value of HRUN=. Hopefully the awk is a start but I... (2 Replies)
Discussion started by: cmccabe
2 Replies

7. Shell Programming and Scripting

awk to adjust coordinates in field based on sequential numbers in another field

I am trying to output a tab-delimited result that uses the data from a tab-delimited file to combine and subtract specific lines. If $4 matches in each line then the first matching sequential $6 value is added to $2, unless the value is 1, then the original $2 is used (like in the case of line... (3 Replies)
Discussion started by: cmccabe
3 Replies

8. Shell Programming and Scripting

Perl to update field based on a specific set of rules

In the perl below, which does execute, I am having trouble with the else in Rule 3. The digit in f{8} is extracted and used to update f accordinly along with the value in f. There can be either - * or + before the number that is extracted but the same logic applies, that is if the value is greater... (5 Replies)
Discussion started by: cmccabe
5 Replies

9. Shell Programming and Scripting

awk to change contents of field based on condition in same file

In the awk below I am trying to copy the entire contents of $6 there may be multiple values seperated by a ;, to $8, if $8 is . (lines 1 and 3 are examples). If that condition $8 is not . (line2 is an example) then that line is skipped and printed as is. The awk does execute but prints the output... (3 Replies)
Discussion started by: cmccabe
3 Replies

10. UNIX for Beginners Questions & Answers

Change the field color based on condition in email

Request your help to change the field color based on condition , if it is otherthan 0. using html in unix. Here is my condition for(i=1;i<=NF;i++) { print "<td> "$i"</td> } Please use CODE tags when displaying sample input, output, and code segments. (17 Replies)
Discussion started by: CatchMe
17 Replies

LEARN ABOUT DEBIAN

gpiv_t-avg

GPIV_T-AVG(1)						      General Commands Manual						     GPIV_T-AVG(1)

NAME

       gpiv_t-avg - Calculates time-averaged mean and variances of PIV data.

SYNOPSIS

       gpiv_t-avg  [-dn  |  --dir_name	dir  basename]	[-df  |  --first_dir  N] [-dl | --last_dir N] [-fb | --file_basename file basename] [-ff |
       --first_file N] [-fl | --last_file N] [-fx | --file_prefix] [-h | --help] [-n | --none] [-p | --print] [-relrms]  [-uv  |  --print]  [-v  |
       --version]

DESCRIPTION

       gpiv_t-avg calculates mean and variances from a series of piv data resulting into time-averaged values. If no parameters are defined at the
       command line, standard parameters will be used that are defined in the script. This program does not use the parameter resources from libg-
       piv.

Options
       -dn | --dir_name dir base-name
	      The  dir	base-name represents the directory name without its last number. It is supposed that the last number in the directory name
	      is a counter.

       -df | --first_dir
	      Defines the counter  N of the first directory number at which the analyses starts.

       -dl | --last_dir
	      Last directory number N at which the analyses ends.

       -fb | --file_base_name file base-name
	      The filename has to be given without its .piv extension. The file base-name represents the file name without its last number, before
	      the extension. If not -fx key is used, it is supposed that the last number in the file name is a counter. The output will be written
	      to dir base-name/file base-name.ta_mean.piv and dirname/filename.ta_sdev.piv at which mean values and variances are written  respec-
	      tively or to dirname/filename.ta_U.piv and to dirname/filename.ta_V.piv if -uv is used.

       -ff | --first_file
	      Defines the counter  Nof first file number at which the analyses starts.

       -fl | --last_file
	      Last file number N at which the analyses ends.

       -fx | --file_prefix
	      Prefix numbering to file base name.

       -h | --help
	      On-line help.

       -n | --none
	      Suppresses real execution.

       -p | --print
	      Prints parameters, command line options and input and output filenames to stdout.

       -relrms
	      Prints relative rms, related to the absolute mean value.

       -uv    Writes U and v displacements/velocities to separate outputs.

       -v | --version
	      Prints version information to standard output, then exits successfully.

       SEE ALSO
	      gpivtools

AUTHOR

       Gerber Van der Graaf

								  19 Januari 2005						     GPIV_T-AVG(1)
All times are GMT -4. The time now is 01:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy