Sponsored Content
Full Discussion: Computing data in awk
Top Forums Shell Programming and Scripting Computing data in awk Post 302352449 by ripat on Friday 11th of September 2009 10:33:16 AM
Old 09-11-2009
Is this what you are after?

Code:
awk '
NR==FNR{tot[$1]+=$4;l2[$1]=$2;l3[$1]=$3;l4[$1]=$4;next}
{
	print sprintf("L1[%s]=%f\nL2[%s]=%f\n",
	$1, ($4/tot[$1]*$2)+(l4[$1]/tot[$1]*l2[$1]),
	$1, ($4/tot[$1]*$3)+(l4[$1]/tot[$1]*l3[$1]))
}' yourFile yourFile

On the sample file given above, it produces this output:

Code:
L1[sade]=0.551124
L2[sade]=0.479663

L1[foly]=0.304343
L2[foly]=0.260808

L1[jude]=0.445567
L2[jude]=0.183608

L1[jude]=0.371546
L2[jude]=0.224330

L1[sade]=0.993708
L2[sade]=0.726742

L1[foly]=0.339394
L2[foly]=0.226263

 

8 More Discussions You Might Find Interesting

1. Cybersecurity

Trusted Computing

About a year ago, a friend of mine who worked on the OReilly Snort book took a propsal he and I had worked on for a book on Trusted Computing. Though the editor thought the content was good and worthwhile, he felt that there wasn't enough of a market to justify printing such a work. How many... (0 Replies)
Discussion started by: kduffin
0 Replies

2. Virtualization and Cloud Computing

Event Cloud Computing - IBM Turning Data Centers Into ?Computing Cloud?

Tim Bass Thu, 15 Nov 2007 23:55:07 +0000 *I predict we may experience less*debates*on the use of the term “event cloud”*related to*CEP in the future, now that both IBM and Google* have made announcements about “cloud computing” and “computing cloud”, IBM Turning Data Centers Into ‘Computing... (0 Replies)
Discussion started by: Linux Bot
0 Replies

3. Virtualization and Cloud Computing

Cloud Enabling Computing for the Next Generation Data Center

Hear how the changing needs of massive scale-out computing is driving a transfomation in technology and learn how HP is supporting this new evolution of the web. More... (1 Reply)
Discussion started by: Linux Bot
1 Replies

4. Shell Programming and Scripting

AWK help. how to compare a variable with a data array in AWK?

Hi all, i have a data array as follows. array=ertfgj2345 array=456ttygkd . . . array=errdjt3235 so number or elements in the array can varies depending on how big the data input is. now i have a variable, and it is $1 (there are $2, $3 and so on, i am only interested in $1). ... (9 Replies)
Discussion started by: usustarr
9 Replies

5. Shell Programming and Scripting

Computing the ratio of similar columns in the two files using awk script

Thanks Bartus11 for your help in the following code to compare the two files "t1" and "t2". awk 'NR==FNR{a=1;next}$2 in a{print $2}' t1 t2 First can anyone explain that what is the purpose of assigning a =1? Second, the current script is printing out the matched columns between the... (4 Replies)
Discussion started by: coder83
4 Replies

6. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---... (5 Replies)
Discussion started by: rveri
5 Replies

7. UNIX for Dummies Questions & Answers

Computing for linearly-interpolated values using awk

Hi, I want to compute for linearly-interpolated values for my data using awk, any help is highly appreciated. How do I apply the linear interpolation formula to my data in awk given the equation below: x y 15 0 25 0.1633611 35 0.0741623 desired output: linear interpolation at... (4 Replies)
Discussion started by: ida1215
4 Replies

8. Shell Programming and Scripting

awk --> math-operation in data-record and joining with second file data

Hi! I have a pretty complex job - at least for me! i have two csv-files with meassurement-data: fileA ...... (2 Replies)
Discussion started by: IMPe
2 Replies
dict(3erl)						     Erlang Module Definition							dict(3erl)

NAME
dict - Key-Value Dictionary DESCRIPTION
Dict implements a Key - Value dictionary. The representation of a dictionary is not defined. This module provides exactly the same interface as the module orddict . One difference is that while this module considers two keys as dif- ferent if they do not match ( =:= ), orddict considers two keys as different if and only if they do not compare equal ( == ). DATA TYPES
dictionary() as returned by new/0 EXPORTS
append(Key, Value, Dict1) -> Dict2 Types Key = Value = term() Dict1 = Dict2 = dictionary() This function appends a new Value to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. append_list(Key, ValList, Dict1) -> Dict2 Types ValList = [Value] Key = Value = term() Dict1 = Dict2 = dictionary() This function appends a list of values ValList to the current list of values associated with Key . An exception is generated if the initial value associated with Key is not a list of values. erase(Key, Dict1) -> Dict2 Types Key = term() Dict1 = Dict2 = dictionary() This function erases all items with a given key from a dictionary. fetch(Key, Dict) -> Value Types Key = Value = term() Dict = dictionary() This function returns the value associated with Key in the dictionary Dict . fetch assumes that the Key is present in the dictionary and an exception is generated if Key is not in the dictionary. fetch_keys(Dict) -> Keys Types Dict = dictionary() Keys = [term()] This function returns a list of all keys in the dictionary. filter(Pred, Dict1) -> Dict2 Types Pred = fun(Key, Value) -> bool() Key = Value = term() Dict1 = Dict2 = dictionary() Dict2 is a dictionary of all keys and values in Dict1 for which Pred(Key, Value) is true . find(Key, Dict) -> {ok, Value} | error Types Key = Value = term() Dict = dictionary() This function searches for a key in a dictionary. Returns {ok, Value} where Value is the value associated with Key , or error if the key is not present in the dictionary. fold(Fun, Acc0, Dict) -> Acc1 Types Fun = fun(Key, Value, AccIn) -> AccOut Key = Value = term() Acc0 = Acc1 = AccIn = AccOut = term() Dict = dictionary() Calls Fun on successive keys and values of Dict together with an extra argument Acc (short for accumulator). Fun must return a new accumulator which is passed to the next call. Acc0 is returned if the list is empty. The evaluation order is undefined. from_list(List) -> Dict Types List = [{Key, Value}] Dict = dictionary() This function converts the Key - Value list List to a dictionary. is_key(Key, Dict) -> bool() Types Key = term() Dict = dictionary() This function tests if Key is contained in the dictionary Dict . map(Fun, Dict1) -> Dict2 Types Fun = fun(Key, Value1) -> Value2 Key = Value1 = Value2 = term() Dict1 = Dict2 = dictionary() map calls Func on successive keys and values of Dict to return a new value for each key. The evaluation order is undefined. merge(Fun, Dict1, Dict2) -> Dict3 Types Fun = fun(Key, Value1, Value2) -> Value Key = Value1 = Value2 = Value3 = term() Dict1 = Dict2 = Dict3 = dictionary() merge merges two dictionaries, Dict1 and Dict2 , to create a new dictionary. All the Key - Value pairs from both dictionaries are included in the new dictionary. If a key occurs in both dictionaries then Fun is called with the key and both values to return a new value. merge could be defined as: merge(Fun, D1, D2) -> fold(fun (K, V1, D) -> update(K, fun (V2) -> Fun(K, V1, V2) end, V1, D) end, D2, D1). but is faster. new() -> dictionary() This function creates a new dictionary. size(Dict) -> int() Types Dict = dictionary() Returns the number of elements in a Dict . store(Key, Value, Dict1) -> Dict2 Types Key = Value = term() Dict1 = Dict2 = dictionary() This function stores a Key - Value pair in a dictionary. If the Key already exists in Dict1 , the associated value is replaced by Value . to_list(Dict) -> List Types Dict = dictionary() List = [{Key, Value}] This function converts the dictionary to a list representation. update(Key, Fun, Dict1) -> Dict2 Types Key = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Dict1 = Dict2 = dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. An exception is generated if Key is not present in the dictionary. update(Key, Fun, Initial, Dict1) -> Dict2 Types Key = Initial = term() Fun = fun(Value1) -> Value2 Value1 = Value2 = term() Dict1 = Dict2 = dictionary() Update a value in a dictionary by calling Fun on the value to get a new value. If Key is not present in the dictionary then Initial will be stored as the first value. For example append/3 could be defined as: append(Key, Val, D) -> update(Key, fun (Old) -> Old ++ [Val] end, [Val], D). update_counter(Key, Increment, Dict1) -> Dict2 Types Key = term() Increment = number() Dict1 = Dict2 = dictionary() Add Increment to the value associated with Key and store this value. If Key is not present in the dictionary then Increment will be stored as the first value. This could be defined as: update_counter(Key, Incr, D) -> update(Key, fun (Old) -> Old + Incr end, Incr, D). but is faster. NOTES
The functions append and append_list are included so we can store keyed values in a list accumulator . For example: > D0 = dict:new(), D1 = dict:store(files, [], D0), D2 = dict:append(files, f1, D1), D3 = dict:append(files, f2, D2), D4 = dict:append(files, f3, D3), dict:fetch(files, D4). [f1,f2,f3] This saves the trouble of first fetching a keyed value, appending a new value to the list of stored values, and storing the result. The function fetch should be used if the key is known to be in the dictionary, otherwise find . SEE ALSO
gb_trees(3erl) , orddict(3erl) Ericsson AB stdlib 1.17.3 dict(3erl)
All times are GMT -4. The time now is 08:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy