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

LEARN ABOUT DEBIAN

alzabo::sqlmaker::mysql

Alzabo::SQLMaker::MySQL(3pm)				User Contributed Perl Documentation			      Alzabo::SQLMaker::MySQL(3pm)

NAME

       Alzabo::SQLMaker::MySQL - Alzabo SQL making class for MySQL

SYNOPSIS

	 use Alzabo::SQLMaker;

	 my $sql = Alzabo::SQLMaker->new( sql => 'MySQL' );

DESCRIPTION

       This class implementes MySQL-specific SQL creation.  MySQL does not allow subselects.  Any attempt to use a subselect (by passing an "Alz-
       abo::SQMaker" object in as parameter to a method) will result in an "Alzabo::Exception::SQL" error.

METHODS

       Almost all of the functionality inherited from Alzabo::SQLMaker is used as is.  The only overridden methods are "limit()" and
       "get_limit()", as MySQL does allow for a "LIMIT" clause in its SQL.

EXPORTED SQL FUNCTIONS

       SQL may be imported by name or by tags.	They take arguments as documented in the MySQL documentation (version 3.23.39).  The functions
       (organized by tag) are:

       :math

	PI
	RAND
	MOD
	ROUND
	POW
	POWER
	ATAN2
	ABS
	SIGN
	FLOOR
	CEILING
	EXP
	LOG
	LOG10
	SQRT
	COS
	SIN
	TAN
	ACOS
	ASIN
	ATAN
	COT
	DEGREES
	RADIANS
	TRUNCATE

       :string

	CHAR
	POSITION
	INSTR
	LEFT
	RIGHT
	FIND_IN_SET
	REPEAT
	LEAST
	GREATEST
	CONCAT
	ELT
	FIELD
	MAKE_SET
	LOCATE
	SUBSTRING
	CONV
	LPAD
	RPAD
	MID
	SUBSTRING_INDEX
	REPLACE
	CONCAT_WS
	EXPORT_SET
	INSERT
	ASCII
	ORD
	BIN
	OCT
	HEX
	LENGTH
	OCTET_LENGTH
	CHAR_LENGTH
	CHARACTER_LENGTH
	TRIM
	LTRIM
	RTRIM
	SOUNDEX
	SPACE
	REVERSE
	LCASE
	LOWER
	UCASE
	UPPER

       :datetime

	CURDATE
	CURRENT_DATE
	CURTIME
	CURRENT_TIME
	NOW
	SYSDATE
	CURRENT_TIMESTAMP
	UNIX_TIMESTAMP
	WEEK
	PERIOD_ADD
	PERIOD_DIFF
	DATE_ADD
	DATE_SUB
	ADDDATE
	SUBDATE
	DATE_FORMAT
	TIME_FORMAT
	FROM_UNIXTIME
	DAYOFWEEK
	WEEKDAY
	DAYOFYEAR
	MONTH
	DAYNAME
	MONTHNAME
	QUARTER
	YEAR
	YEARWEEK
	HOUR
	MINUTE
	SECOND
	TO_DAYS
	FROM_DAYS
	SEC_TO_TIME
	TIME_TO_SEC

       :aggregate

       These are functions which operate on an aggregate set of values all at once.

	COUNT
	AVG
	MIN
	MAX
	SUM
	STD
	STDDEV

       :system

       These are functions which return information about the MySQL server.

	DATABASE
	USER
	SYSTEM_USER
	SESSION_USER
	VERSION
	CONNECTION_ID
	LAST_INSERT_ID
	GET_LOCK
	RELEASE_LOCK
	BENCHMARK
	MASTER_POS_WAIT

       :control

       These are flow control functions:

	IFNULL
	NULLIF
	IF

       :misc

       These are functions which don't fit into any other categories.

	ENCRYPT
	ENCODE
	DECODE
	FORMAT
	INET_NTOA
	INET_ATON
	BIT_OR
	BIT_AND
	PASSWORD
	MD5
	LOAD_FILE

       :fulltext

       These are functions related to MySQL's fulltext searching capabilities.

	MATCH
	AGAINST
	IN_BOOLEAN_MODE

       NOTE: In MySQL 4.0 and greater, it is possible to say that a search is in boolean mode in order to change how MySQL handles the argument
       given to AGAINST.  This will not work with earlier versions.

       :common

       These are functions from other groups that are most commonly used.

	NOW
	COUNT
	AVG
	MIN
	MAX
	SUM
	DISTINCT

AUTHOR

       Dave Rolsky, <dave@urth.org>

perl v5.8.8							    2007-12-23					      Alzabo::SQLMaker::MySQL(3pm)
All times are GMT -4. The time now is 05:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy