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 303043634 by cotilloe on Sunday 2nd of February 2020 03:20:47 PM
Old 02-02-2020
That actually helps alot, as I had tried something like that. What I tried to do was:

Code:
SUM[$1] += $4*0.1

That did not work, but by storing the weights in in an array, I see how it could be workable. My only question is how to store/use multiple values.
If $2 = Homework then $4 needs to be multiplied by 0.1
if $2 = Quiz then $4 needs to be multiplied by 0.4
if $2 = Lab then $4 needs to be multiplied by 0.3
if $2 = Final then $4 needs to be multiplied by 0.15
if $2 = Survey then $4 needs to be multiplied by 0.05

Then, all I would need to do is some $4 with the new values and have the overall percent for each student.
 

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

sbvec2i32

SbVec2i32(3)							       Coin							      SbVec2i32(3)

NAME

       SbVec2i32 -

       The SbVec2i32 class is a 2 dimensional vector with short integer coordinates.

       This vector class is used by many other classes in Coin. It provides storage for a vector in 2 dimensions as well as simple integer
       arithmetic operations.

SYNOPSIS

       #include <Inventor/SbLinear.h>

   Public Member Functions
       SbVec2i32 (void)
       SbVec2i32 (const int32_t v[2])
       SbVec2i32 (int32_t x, int32_t y)
       SbVec2i32 (const SbVec2ui32 &v)
       SbVec2i32 (const SbVec2b &v)
       SbVec2i32 (const SbVec2s &v)
       SbVec2i32 (const SbVec2f &v)
       SbVec2i32 (const SbVec2d &v)
       SbVec2i32 & setValue (const int32_t v[2])
       SbVec2i32 & setValue (int32_t x, int32_t y)
       SbVec2i32 & setValue (const SbVec2ui32 &v)
       SbVec2i32 & setValue (const SbVec2b &v)
       SbVec2i32 & setValue (const SbVec2s &v)
       SbVec2i32 & setValue (const SbVec2f &v)
       SbVec2i32 & setValue (const SbVec2d &v)
       const int32_t * getValue (void) const
       void getValue (int32_t &x, int32_t &y) const
       int32_t & operator[] (const int i)
       const int32_t & operator[] (const int i) const
       int32_t dot (const SbVec2i32 &v) const
       void negate (void)
       SbVec2i32 & operator*= (int d)
       SbVec2i32 & operator*= (double d)
       SbVec2i32 & operator/= (int d)
       SbVec2i32 & operator/= (double d)
       SbVec2i32 & operator+= (const SbVec2i32 &v)
       SbVec2i32 & operator-= (const SbVec2i32 &v)
       SbVec2i32 operator- (void) const
       void print (FILE *fp) const

   Protected Attributes
       int32_t vec [2]

   Related Functions
       (Note that these are not member functions.)
       SbVec2i32 operator* (const SbVec2i32 &v, int d)
       SbVec2i32 operator* (const SbVec2i32 &v, double d)
       SbVec2i32 operator* (int d, const SbVec2i32 &v)
       SbVec2i32 operator* (double d, const SbVec2i32 &v)
       SbVec2i32 operator/ (const SbVec2i32 &v, int d)
       SbVec2i32 operator/ (const SbVec2i32 &v, double d)
       SbVec2i32 operator+ (const SbVec2i32 &v1, const SbVec2i32 &v2)
       SbVec2i32 operator- (const SbVec2i32 &v1, const SbVec2i32 &v2)
       int operator== (const SbVec2i32 &v1, const SbVec2i32 &v2)
       int operator!= (const SbVec2i32 &v1, const SbVec2i32 &v2)

Detailed Description
       The SbVec2i32 class is a 2 dimensional vector with short integer coordinates.

       This vector class is used by many other classes in Coin. It provides storage for a vector in 2 dimensions as well as simple integer
       arithmetic operations.

       See also:
	   SbVec2f, SbVec2d, SbVec3s, SbVec3f, SbVec3d, SbVec4f, SbVec4d.

Constructor &; Destructor Documentation
   SbVec2i32::SbVec2i32 (void) [inline]
       The default constructor does nothing. The vector coordinates will be uninitialized until you do a setValue().

   SbVec2i32::SbVec2i32 (const int32_tv[2]) [inline]
       Constructs an SbVec2i32 instance with initial values from v.

   SbVec2i32::SbVec2i32 (int32_tx, int32_ty) [inline]
       Constructs an SbVec2i32 instance with the initial vector endpoints from x and y.

   SbVec2i32::SbVec2i32 (const SbVec2ui32 &v) [inline],  [explicit]
       Since:
	   Coin 2.5

   SbVec2i32::SbVec2i32 (const SbVec2b &v) [inline],  [explicit]
       Since:
	   Coin 2.5

   SbVec2i32::SbVec2i32 (const SbVec2s &v) [inline],  [explicit]
       Since:
	   Coin 2.5

   SbVec2i32::SbVec2i32 (const SbVec2f &v) [inline],  [explicit]
       Since:
	   Coin 2.5

   SbVec2i32::SbVec2i32 (const SbVec2d &v) [inline],  [explicit]
       Since:
	   Coin 2.5

Member Function Documentation
   SbVec2i32 & SbVec2i32::setValue (const int32_tv[2]) [inline]
       Set new x and y coordinates for the vector from v. Returns reference to self.

       See also:
	   getValue().

   SbVec2i32 & SbVec2i32::setValue (int32_tx, int32_ty) [inline]
       Set new x and y coordinates for the vector. Returns reference to self.

       See also:
	   getValue().

   SbVec2i32 & SbVec2i32::setValue (const SbVec2ui32 &v)
       Since:
	   Coin 2.5

   SbVec2i32 & SbVec2i32::setValue (const SbVec2b &v)
       Since:
	   Coin 2.5

   SbVec2i32 & SbVec2i32::setValue (const SbVec2s &v)
       Since:
	   Coin 2.5

   SbVec2i32 & SbVec2i32::setValue (const SbVec2f &v)
       Since:
	   Coin 2.5

   SbVec2i32 & SbVec2i32::setValue (const SbVec2d &v)
       Since:
	   Coin 2.5

   const int32_t * SbVec2i32::getValue (void) const [inline]
       Returns a pointer to an array of two floats containing the x and y coordinates of the vector.

       See also:
	   setValue().

   void SbVec2i32::getValue (int32_t &x, int32_t &y) const [inline]
       Returns the x and y coordinates of the vector.

       See also:
	   setValue().

   int32_t & SbVec2i32::operator[] (const inti) [inline]
       Index operator. Returns modifiable x or y coordinate.

       See also:
	   getValue() and setValue().

   const int32_t & SbVec2i32::operator[] (const inti) const [inline]
       Index operator. Returns x or y coordinate.

       See also:
	   getValue().

   int32_t SbVec2i32::dot (const SbVec2i32 &v) const [inline]
       Calculates and returns the result of taking the dot product of this vector and v.

   void SbVec2i32::negate (void) [inline]
       Negate the vector (i.e. point it in the opposite direction).

   SbVec2i32 & SbVec2i32::operator*= (intd) [inline]
       Multiply components of vector with value d. Returns reference to self.

   SbVec2i32 & SbVec2i32::operator*= (doubled)
       Multiply components of vector with value d. Returns reference to self.

   SbVec2i32 & SbVec2i32::operator/= (intd) [inline]
       Divides components of vector with value d. Returns reference to self.

   SbVec2i32 & SbVec2i32::operator/= (doubled) [inline]
       Divides components of vector with value d. Returns reference to self.

   SbVec2i32 & SbVec2i32::operator+= (const SbVec2i32 &v) [inline]
       Adds this vector and vector v. Returns reference to self.

   SbVec2i32 & SbVec2i32::operator-= (const SbVec2i32 &v) [inline]
       Subtracts vector u from this vector. Returns reference to self.

   SbVec2i32 SbVec2i32::operator- (void) const [inline]
       Non-destructive negation operator. Returns a new SbVec2i32 instance which points in the opposite direction of this vector.

       See also:
	   negate().

   void SbVec2i32::print (FILE *fp) const
       Dump the state of this object to the file stream. Only works in debug version of library, method does nothing in an optimized compile.

Friends And Related Function Documentation
   SbVec2i32 operator* (const SbVec2i32 &v, intd) [related]
       Returns an SbVec2i32 instance which is the components of vector v multiplied with d.

   SbVec2i32 operator* (const SbVec2i32 &v, doubled) [related]
       Returns an SbVec2i32 instance which is the components of vector v multiplied with d.

   SbVec2i32 operator* (intd, const SbVec2i32 &v) [related]
       Returns an SbVec2i32 instance which is the components of vector v multiplied with d.

   SbVec2i32 operator* (doubled, const SbVec2i32 &v) [related]
       Returns an SbVec2i32 instance which is the components of vector v multiplied with d.

   SbVec2i32 operator/ (const SbVec2i32 &v, intd) [related]
       Returns an SbVec2i32 instance which is the components of vector v divided on d.

   SbVec2i32 operator/ (const SbVec2i32 &v, doubled) [related]
       Returns an SbVec2i32 instance which is the components of vector v divided on d.

   SbVec2i32 operator+ (const SbVec2i32 &v1, const SbVec2i32 &v2) [related]
       Returns an SbVec2i32 instance which is the sum of vectors v1 and v2.

   SbVec2i32 operator- (const SbVec2i32 &v1, const SbVec2i32 &v2) [related]
       Returns an SbVec2i32 instance which is vector v2 subtracted from vector v1.

   int operator== (const SbVec2i32 &v1, const SbVec2i32 &v2) [related]
       Returns 1 if v1 and v2 are equal, 0 otherwise.

   int operator!= (const SbVec2i32 &v1, const SbVec2i32 &v2) [related]
       Returns 1 if v1 and v2 are not equal, 0 if they are equal.

Author
       Generated automatically by Doxygen for Coin from the source code.

Version 3.1.3							  Wed May 23 2012						      SbVec2i32(3)
All times are GMT -4. The time now is 04:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy