Sponsored Content
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 303043666 by RudiC on Monday 3rd of February 2020 10:02:47 AM
Old 02-03-2020
Try instead
Code:
awk '
function GRD(AVG, R)    {if             (AVG >= 97)     return "A+"
                           else if      (AVG >= 94)     return "A"
                           else if      (AVG >= 90)     return "A-"
                           else if      (AVG >= 87)     return "B+"
                           else if      (AVG >= 84)     return "B"
                           else if      (AVG >= 80)     return "B-"
                           else if      (AVG >= 76)     return "C+"
                           else if      (AVG >= 70)     return "C"
                           else if      (AVG >= 60)     return "D"
                           else                         return "E"
                        }


FNR==NR         {WEIGHT[$1] = $3
                 next
                }
FNR == 1        {next
                }
                {SUM[$1] += $4 * WEIGHT[$2]
                }
END             {for (s in SUM) {AVG = SUM[s]/5.7525
                                 print s, SUM[s], AVG, GRD(AVG)
                                }
                }
' OFS="\t" file1 file2
Sam     349.45  60.7475 D
Chelsey 536.95  93.342  A-
Andrew  402.6   69.987  D
Shane   427.75  74.359  C
Ava     434.5   75.5324 C

There are more elegant grade determination approaches, that is...

Last edited by RudiC; 02-03-2020 at 11:12 AM..
 

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
sa-heatu(1)							   User Commands						       sa-heatu(1)

NAME
sa-heatu - Spamasassin Heuristic Email Address Tracker Utility SYNOPSIS
sa-heatu [options] [dbfile [timestamp-file]] DESCRIPTION
Check or clean a SpamAssassin auto-whitelist (AWL) database file. The Auto-WhiteList (AWL) feature in Spamassassing tracks scores from messages previously received and adjusts the message score, either by boosting messages from senders who send ham or penalizing senders who have sent spam previously. This not only treats some senders as if they were whitelisted but also treats spammers as if they were blacklisted. To enable AWL in spamassassin, read dcoumentation: perldoc Mail::SpamAssassin::Conf This is an enhanced version of the original AWL tool. The AWL database can be examined and pruned; single email entries can be removed. This is useful when a spammer sends one or more ham messages before sending spam. Without special options, the program generates a summary of the database (see FILES): $ sa-heatu -D -n /var/spool/spamassassin/auto-whitelist 0 entries removed. 0 entries would be expired. 0 timestamps would be added. 0 timestamps would be updated. 308 entries input. 308 entries output = input - expired - removed. With option --verbose it generates output: AVG TOTSCORE COUNT EMAIL IPBASE AVG is the average score; TOTSCORE is the total score of all mails seen so far; COUNT is the number of messages seen from that sender; EMAIL is the sender's email address, and IPBASE is the AWL base IP address. AWL base IP address is a way to identify the sender's IP address they frequently send from, in an approximate way, but remaining hard for spammers to spoof. The algorithm is as follows: - Take the last Received header that contains a public IP address; namely one which is not in private, unrouted IP space. - Chop off the last two octets, assuming that the user may be in an ISP's dynamic address pool. Negative values indicate senders of ham: average total count 6.8 6.8 1 support@midphase.com 72.26 -8.1 -16.2 2 users-return-@spamassassin.apache.org 98.109 1.4 15.9 11 partners@us.cyberoam.com 38.105 13.9 13.9 1 obdg@borgard.com 89.185 OPTIONS
-D, --DONTupdatetimestamps No timestamps processing is done. Alias for --noTimestamps. -e, --expireOlderThan NUMBER Expire entries older than NUMBER of days. -f, --firstTimes Use this for the first run to avoid reading timestamps. -h, --help Display short help. -n, --noTimestamps No timestamps processing. -p, --prune NUMBER Clean out infrequently-used AWL entries. The NUMBER can be used to select the threshold at which entries are kept or deleted. Value 1 means that entries seen once are deleted. -q, --quiet Be quiet. -r, --remove EMAIL Remove EMAIL from database. -s, --showUpdates Output entries updated or added or removed, in addition to the summary. -v, --verbose Display more information. Note that this may display lot of information from the database. EXAMPLES
To see valid senders: sa-heatu --verbose -D | sort -n | head -n 20 To see top spammers: sa-heatu --verbose -D | sort -n | tail -n 20 To display single record: sa-heatu --verbose -n | grep -i foo@example.com To remove of foo@example.com entry: $ sa-heatu -n --remove foo@example.com Using $HOME/.spamassassin/auto-whitelist average total count found 34.5 34.5 1 foo@example.com 41.202 1 deleted. 259 keys with 1 entry. 658 keys with 2 entries. 1675 entries. To shrink the database considerably by removing entries that only have one hit: sa-heatu --prune Average total count email address ip network address last time updated: Note: the date and time stamp is the time sa-heatu was run, not the time the email was received: sa-heatu --verbose -D | sort -n | head -5 ENVIRONMENT
None. FILES
$HOME/.spamassassin The default working directory of program where dbfile etc. are expected. If dbfile is not given the "$HOME/.spamassassin/auto-whitelist" is used. See also option auto_whitelist_path in Spamassasin Perl module Mail::SpamAssassin::Plugin::AWL which typically points to "/var/spool/spamassassin/auto-whitelist". SEE ALSO
spamassassin(1) Mail::SpamAssassin::Plugin::AWL(3p) STANDARDS
http://wiki.apache.org/spamassassin/AutoWhitelist AVAILABILITY
See STANDARDS for download link. The original version this program is based on is at http://svn.apache.org/repos/asf/spamassassin/branches/3.2/tools/check_whitelist AUTHORS
Program was written by Dennis G German <DGermansa@Real-world-Systems.com> This manual page was written by Jari Aalto <jari.aalto@cante.net>. Released under license GNU GPL version 2 or (at your option) any later version. For more information about license, visit <http://www.gnu.org/copyleft/gpl.html>. sa-heatu 2011-01-11 sa-heatu(1)
All times are GMT -4. The time now is 04:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy