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
BTRECORD(8)															       BTRECORD(8)

NAME
btrecord - recreate IO loads recorded by blktrace SYNOPSIS
Usage: btrecord [ options ] <dev...> DESCRIPTION
The btrecord and btreplay tools provide the ability to record and replay IOs captured by the blktrace utility. Attempts are made to main- tain ordering, CPU mappings and time-separation of IOs. The blktrace utility provides the ability to collect detailed traces from the kernel for each IO processed by the block IO layer. The traces provide a complete timeline for each IO processed, including detailed information concerning when an IO was first received by the block IO layer -- indicating the device, CPU number, time stamp, IO direction, sector number and IO size (number of sectors). Using this information, one is able to replay the IO again on the same machine or another set up entirely. The basic operating work-flow to replay IOs would be something like: - Run blktrace to collect traces. Here you specify the device or devices that you wish to trace and later replay IOs upon. Note: the only traces you are interested in are QUEUE requests -- thus, to save system resources (including storage for traces), one could specify the -a queue command line option to blktrace. - While blktrace is running, you run the workload that you are interested in. - When the work load has completed, you stop the blktrace utility (thus saving all traces over the complete workload). - You extract the pertinent IO information from the traces saved by blktrace using the btrecord utility. This will parse each trace file created by blktrace, and crafty IO descriptions to be used in the next phase of the workload processing. - Once btrecord has successfully created a series of data files to be processed, you can run the btreplay utility which attempts to generate the same IOs seen during the sample workload phase. OPTIONS
-d <dir> --input-directory=<dir> Set input directory. This option requires a single parameter providing the directory name for where input files are to be found. The default directory is the current directory (.). -D <dir> --output-directory=<dir> Set output directory. This option requires a single parameter providing the directory name for where output files are to be found. The default directory is the current directory (.). -F --find-traces Find trace files automatically This option instructs btreplay to go find all the trace files in the directory specified (either via the -d option, or in the default directory (.). -h --help Show help and exit. -V --version Show version number and exit. -m <nanoseconds> --max-bunch-time=<nanoseconds> The -m option requires a single parameter which specifies an amount of time (in nanoseconds) to include in any one bunch of IOs that are to be processed. The smaller the value, the smaller the number of IOs processed at one time -- perhaps yielding in more realis- tic replay. However, after a certain point the amount of overhead per bunch may result in additional real replay time, thus yield- ing less accurate replay times. The default value is 10,000,000 nanoseconds (10 milliseconds). -M <num> --max-pkts=<num> Set maximum number of packets per bunch. The -M option requires a single parameter which specifies the maximum number of IOs to store in a single bunch. As with the -m option, smaller values may or may not yield more accurate replay times. The default value is 8, with a maximum value of up to 512 being supported. -o <basename> --output-base=<basename> Set base name for output files. Each output file has 3 fields: 1. Device identifier (taken directly from the device name of the blktrace output file). 2. btrecord base name -- by default ``replay''. 3. The CPU number (again, taken directly from the blktrace output file name). This option requires a single parameter that will override the default name (replay), and replace it with the specified value. -v --verbose Enable verbose output. This option will output some simple statistics at the end of a successful run. Example output is: sdab:0: 580661 pkts (tot), 126030 pkts (replay), 89809 bunches, 1.4 pkts/bunch sdab:1: 2559775 pkts (tot), 430172 pkts (replay), 293029 bunches, 1.5 pkts/bunch sdab:2: 653559 pkts (tot), 136522 pkts (replay), 102288 bunches, 1.3 pkts/bunch sdab:3: 474773 pkts (tot), 117849 pkts (replay), 69572 bunches, 1.7 pkts/bunch The meaning of the columns is: 1. The first field contains the device name and CPU identifier. Thus: sdab:0: means the device sdab and traces on CPU 0. 2. The second field contains the total number of packets processed for each device file. 3. The next field shows the number of packets eligible for replay. 4. The fourth field contains the total number of IO bunches. 5. The last field shows the average number of IOs per bunch recorded. AUTHORS
btrecord was written by Alan D. Brunelle. This man page was created from the btreplay documentation by Bas Zoetekouw. REPORTING BUGS
Report bugs to <linux-btrace@vger.kernel.org> COPYRIGHT
Copyright (C) 2007 Alan D. Brunelle, Alan D. Brunelle and Nathan Scott. This is free software. You may redistribute copies of it under the terms of the GNU General Public License <http://www.gnu.org/licenses/gpl.html>. There is NO WARRANTY, to the extent permitted by law. This manual page was created for Debian by Bas Zoetekouw. It was derived from the documentation provided by the authors and it may be used, distributed and modified under the terms of the GNU General Public License, version 2. On Debian systems, the text of the GNU General Public License can be found in /usr/share/common-licenses/GPL-2. SEE ALSO
The full documentation for btreplay can be found in /usr/share/doc/blktrace on Debian systems. blktrace (8), blkparse (1), btreplay (8) blktrace git-20071207142532 December 8, 2007 BTRECORD(8)
All times are GMT -4. The time now is 04:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy