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 PLAN9

road

ROAD(7) 						 Miscellaneous Information Manual						   ROAD(7)

NAME

       road, gps - road map of the United States

SYNOPSIS

       games/road [ -g ] [ -s scale ]
       games/gps

DESCRIPTION

       Road  displays a road map centered around some specified place in the United States.  The data comes from the Census Bureau Tiger Database.
       The map is drawn in three shades of grey.  Light grey is used for water features such as rivers, streams and lakes.  Dark grey is used  for
       railroads and airports.	Black is used for roads.  On terminals with ldepth zero, all shades appear black.

       Without	options,  the center of the map is the latitude and longitude specified in the file /lib/sky/here.  If the -g option is given, the
       center of the map will be the latitude and longitude specified by continually monitoring the end of the file  /tmp/gpslog.   This  file	is
       written	by the GPS satellite receiver program gps.  With this option, and with gps running, road becomes a moving map display suitable for
       cars or planes.

   Keyboard commands
       s number
	      sets the scale of the map to number.  The number can be prefixed with + or - to increase/decrease the current  scale.   Scale  6	is
	      about  one mile across the screen and scale 10 is about ten miles across.  Scales 1 through 10 are drawn with maximum detail showing
	      all roads, trails, rivers, streams and airports.	Scales 11 through 14  show  highways,  rivers,	airports  and  county  boundaries.
	      Scales 15 through 20 show interstate highways and state boundaries.

       /regexp
	      All features labeled by text matching the regular expression are highlighted.

       p place
	      centers  the  map at the specified place.  Usually the place must have the associated state code, (eg murrayhill,nj) but places like
	      lax and ewr are also known.

       l latitude longitude
	      centers the map at the specified coordinate.

       g      toggles the -g option described above.

       q      Exit.

   Mouse button commands
       Button 1
	      displays the text of the line nearest the cursor.  Normally this is the name of a street or river.

       Button 2
	      displays the text of the place nearest the cursor.  Normally this is a town.

       Button 3
	      centers the display on the cursor position.

       Gps reads /dev/eia0 assumed connected to a Garmin GPS-55 satellite receiver and writes  the  current  location  on  the	end  of  the  file
       /tmp/gpslog.  It is intended to be used with mobile PC's.

FILES

       /lib/roads/LLLL/LLLLGGGG.h
	      scale 1-10 database files where LLLL is the latitude multiplied by 5 and GGGG is the longitude multiplied by 5.

       /lib/roads/LLL/LLLGGG.h
	      scale 11-14 database files where LLL is the latitude multiplied by 1 and GGG is the longitude multiplied by 1.

       /lib/roads/LL/LLGG.h
	      scale 15-20 database files where LL is the latitude multiplied by 0.2 and GG is the longitude multiplied by 0.2.

       /lib/roads/place
	      /lib/roads/place.local are the translations between place names and locations.  These files must be sorted.

       /lib/sky/here
	      default starting map center.

       /tmp/gpslog
	      moving map location.

SOURCE

       /sys/src/games/road
       /sys/src/games/gps

																	   ROAD(7)
All times are GMT -4. The time now is 10:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy