Issue using awk to print min values for unique ids Post: 303034391

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma

2. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the...

3. Shell Programming and Scripting

AWK script - extracting min and max values from selected lines

Hi guys! I'm new to scripting and I need to write a script in awk. Here is example of file on which I'm working ATOM 4688 HG1 PRO A 322 18.080 59.680 137.020 1.00 0.00 ATOM 4689 HG2 PRO A 322 18.850 61.220 137.010 1.00 0.00 ATOM 4690 CD ...

4. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Hi guys, I already search on the forum but i can't solve this on my own. I have a lot of files like this: And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in...

5. Shell Programming and Scripting

Print unique records in 2 columns using awk

Is it possible to print the records that has only 1 value in 2nd column. Ex: input awex1 1 awex1 2 awex1 3 assww 1 ader34 1 ader34 2 output assww 1

6. Shell Programming and Scripting

How to get min and max values using awk?

Hi, I need your kind help to get min and max values from file based on value in $5 . File1 SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0 SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0 SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0 SP12.3 XE 2240077 2241254 + ID1_N003 ...

7. Shell Programming and Scripting

awk to filter out lines containing unique values in a specified column

Hi, I have multiple files that each contain four columns of strings: File1: Code: 123 abc gfh 273 456 ddff jfh 837 789 ghi u4u 395 File2: Code: 123 abc dd fu 456 def 457 nd 891 384 djh 783 I want to compare the strings in Column 1 of File 1 with each other file and Print in...

8. Shell Programming and Scripting

awk to print unique text in field

I am trying to use awk to print the unique entries in $2 So in the example below there are 3 lines but 2 of the lines match in $2 so only one is used in the output. File.txt chr17:29667512-29667673 NF1:exon.1;NF1:exon.2;NF1:exon.38;NF1:exon.4;NF1:exon.46;NF1:exon.47 703.807...

9. Shell Programming and Scripting

Print count of unique values

Hello experts, I am converting a number into its binary output as : read n echo "obase=2;$n" | bc I wish to count the maximum continuous occurrences of the digit 1. Example : 1. The binary equivalent of 5 = 101. Hence the output must be 1. 2. The binary...

10. UNIX for Beginners Questions & Answers

Print lines based upon unique values in Nth field

For some reason I am having difficulty performing what should be a fairly easy task. I would like to print lines of a file that have a unique value in the first field. For example, I have a large data-set with the following excerpt: PS003,001 MZMWR/ L-DWD// * PS003,001...

LEARN ABOUT MOJAVE

mpsnnscalenode

MPSNNScaleNode(3)					 MetalPerformanceShaders.framework					 MPSNNScaleNode(3)

NAME

       MPSNNScaleNode

SYNOPSIS

       #import <MPSNNGraphNodes.h>

       Inherits MPSNNFilterNode.

       Inherited by MPSNNBilinearScaleNode, and MPSNNLanczosScaleNode.

   Instance Methods
       (nonnull instancetype) - initWithSource:outputSize:
       (nonnull instancetype) - initWithSource:transformProvider:outputSize:

   Class Methods
       (nonnull instancetype) + nodeWithSource:outputSize:
       (nonnull instancetype) + nodeWithSource:transformProvider:outputSize:

   Additional Inherited Members
Method Documentation
   - (nonnull instancetype) initWithSource: (MPSNNImageNode *__nonnull) sourceNode(MTLSize) size
       init a node to convert a MPSImage to the desired size

       Parameters:
	   sourceNode A valid MPSNNImageNode
	   size The size of the output image {width, height, depth}

   - (nonnull instancetype) initWithSource: (MPSNNImageNode *__nonnull) sourceNode(__nullable id< MPSImageTransformProvider >)
       transformProvider(MTLSize) size
       init a node to convert a MPSImage to the desired size for a region of interest

       Parameters:
	   sourceNode A valid MPSNNImageNode
	   transformProvider If non-nil, a valid MPSImageTransformProvider that provides the region of interest
	   size The size of the output image {width, height, depth}

   + (nonnull instancetype) nodeWithSource: (MPSNNImageNode *__nonnull) sourceNode(MTLSize) size
       create an autoreleased node to convert a MPSImage to the desired size

       Parameters:
	   sourceNode A valid MPSNNImageNode
	   size The size of the output image {width, height, depth}

   + (nonnull instancetype) nodeWithSource: (MPSNNImageNode *__nonnull) sourceNode(__nullable id< MPSImageTransformProvider >)
       transformProvider(MTLSize) size
       create an autoreleased node to convert a MPSImage to the desired size for a region of interest

       Parameters:
	   sourceNode A valid MPSNNImageNode
	   transformProvider If non-nil, a valid MPSImageTransformProvider that provides the region of interest
	   size The size of the output image {width, height, depth}

Author
       Generated automatically by Doxygen for MetalPerformanceShaders.framework from the source code.

Version MetalPerformanceShaders-100				  Thu Feb 8 2018						 MPSNNScaleNode(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Awk search for max and min field values

Discussion started by: Kirichiko

2. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Discussion started by: amigarus

3. Shell Programming and Scripting

AWK script - extracting min and max values from selected lines

Discussion started by: grincz

4. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Discussion started by: MetaBolic0