Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Highest value matrix parsing
Top Forums Shell Programming and Scripting Highest value matrix parsing Post 302952925 by RudiC on Monday 24th of August 2015 10:42:16 AM
Old 08-24-2015
Any attempts from your side?

---------- Post updated at 16:42 ---------- Previous update was at 16:35 ----------

Howsoever, try
Code:
awk '
NR==1   {for (i=1; i<=NF; i++) TT[i+1]=$i
         next
        }
        {MAX=$2
         COL=2
         for (i=3; i<=NF; i++) if ($i>MAX)      {MAX=$i
                                                 COL=i
                                                }
         print $1, TT[COL], MAX
        }
' file
b a_3 0.9
c s_4 1
d a_3 0.98
e a_3 0.96

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sort with highest wc

Hi :) I'm a unix beginner and i've recently got an assignment to write up a script to print the most common IP address that made requests from a webserver. I'm really lost in this one...and if someone could pls tell me where to start i'll be really greatful ! thanx (1 Reply)
Discussion started by: ymf
1 Replies

2. Shell Programming and Scripting

Perl parsing compared to Ksh parsing

#! /usr/local/bin/perl -w $ip = "$ARGV"; $rw = "$ARGV"; $snmpg = "/usr/local/bin/snmpbulkget -v2c -Cn1 -Cn2 -Os -c $rw"; $snmpw = "/usr/local/bin/snmpwalk -Os -c $rw"; $syst=`$snmpg $ip system sysName sysObjectID`; sysDescr.0 = STRING: Cisco Internetwork Operating System Software... (1 Reply)
Discussion started by: popeye
1 Replies

3. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies

4. Shell Programming and Scripting

diagonal matrix to square matrix

Hello, all! I am struggling with a short script to read a diagonal matrix for later retrieval. 1.000 0.234 0.435 0.123 0.012 0.102 0.325 0.412 0.087 0.098 1.000 0.111 0.412 0.115 0.058 0.091 0.190 0.045 0.058 1.000 0.205 0.542 0.335 0.054 0.117 0.203 0.125 1.000 0.587 0.159 0.357... (11 Replies)
Discussion started by: yifangt
11 Replies

5. Ubuntu

How to convert full data matrix to linearised left data matrix?

Hi all, Is there a way to convert full data matrix to linearised left data matrix? e.g full data matrix Bh1 Bh2 Bh3 Bh4 Bh5 Bh6 Bh7 Bh1 0 0.241058 0.236129 0.244397 0.237479 0.240767 0.245245 Bh2 0.241058 0 0.240594 0.241931 0.241975 ... (8 Replies)
Discussion started by: evoll
8 Replies

6. Shell Programming and Scripting

awk? adjacency matrix to adjacency list / correlation matrix to list

Hi everyone I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Discussion started by: stonemonkey
5 Replies

7. Shell Programming and Scripting

Printing highest value from a list

Hi all, I'm trying to get the item with the maximum value, and was wondering if someone can help me with it. Heres my input file: apples 15 books 15 books 17 pens 12 pens 15 umbrella 13Here's what my output file should look like: apples 15 books 17 pens 15 umbrella 13 Can... (2 Replies)
Discussion started by: r4v3n
2 Replies

8. Programming

Matrix parsing help !

Hello every body ! I'm a new in this forum and beginner in Perl scripting and I have some problems :(:(:(! I have a big file like that : ID1 ID2 Identity chromosome07_194379 chromosome01_168057 0.975 chromosome01_100293 chromosome01_168057 ... (23 Replies)
Discussion started by: mchimich
23 Replies

9. Shell Programming and Scripting

Script read highest value

Hi All, Can someone help steer me to the simplest approach to write a script that reads the second column of a csv file and returns the highest value. example file: DATE,QUANTITY Mon Apr 30 01:56:00 2012,42 Mon Apr 30 02:24:00 2012,72 Mon Apr 30 02:56:00 2012,102 Mon Apr 30 02:59:00... (3 Replies)
Discussion started by: dekker74
3 Replies

10. Shell Programming and Scripting

Parsing a subset of data from a large matrix

I do have a large matrix of the following format and it is tab delimited ch-ab1-20 ch-bb2-23 ch-ab1-34 ch-ab1-24 er-cc1-45 bv-cc1-78 ch-ab1-20 0 2 3 4 5 6 ch-bb2-23 3 0 5 ... (6 Replies)
Discussion started by: Kanja
6 Replies

LEARN ABOUT DEBIAN

slas2.f

slas2.f(3)							      LAPACK								slas2.f(3)

NAME

       slas2.f -

SYNOPSIS

   Functions/Subroutines
       subroutine slas2 (F, G, H, SSMIN, SSMAX)
	   SLAS2

Function/Subroutine Documentation
   subroutine slas2 (realF, realG, realH, realSSMIN, realSSMAX)
       SLAS2

       Purpose:

	    SLAS2  computes the singular values of the 2-by-2 matrix
	       [  F   G  ]
	       [  0   H  ].
	    On return, SSMIN is the smaller singular value and SSMAX is the
	    larger singular value.

       Parameters:
	   F

		     F is REAL
		     The (1,1) element of the 2-by-2 matrix.

	   G

		     G is REAL
		     The (1,2) element of the 2-by-2 matrix.

	   H

		     H is REAL
		     The (2,2) element of the 2-by-2 matrix.

	   SSMIN

		     SSMIN is REAL
		     The smaller singular value.

	   SSMAX

		     SSMAX is REAL
		     The larger singular value.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Further Details:

	     Barring over/underflow, all output quantities are correct to within
	     a few units in the last place (ulps), even in the absence of a guard
	     digit in addition/subtraction.

	     In IEEE arithmetic, the code works correctly if one matrix element is
	     infinite.

	     Overflow will not occur unless the largest singular value itself
	     overflows, or is within a few ulps of overflow. (On machines with
	     partial overflow, like the Cray, overflow may occur if the largest
	     singular value is within a factor of 2 of overflow.)

	     Underflow is harmless if underflow is gradual. Otherwise, results
	     may correspond to a matrix modified by perturbations of size near
	     the underflow threshold.

       Definition at line 108 of file slas2.f.

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

Version 3.4.1							  Sun May 26 2013							slas2.f(3)
All times are GMT -4. The time now is 10:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy