1

Selecting lines having same values for first two columns

view story
linux-howto

http://www.unix.com – Hello to all. This is first post. Kindly excuse me if I do not adhere to any rules and regulations of this forum. I have a file containing some rows with three columns each per row(separeted by a space). There are certain rows for which first two columns have same value but the value in third column is different. In that case I wish to retain only that row which has the maximum value for third column. Further I want to wirte the rows not required to a file for further processing. Code: 1123022201 9310777627 3976 1127021871 9312262893 3600  -- not required, sent to another (HowTos)

more's picture
Submitted by more on 12/27/2012

Stories similar to Selecting lines having same values for first two columns

Hi All,

I have a big file with 232 columns and 9 million rows, I want to delete all rows with same column values in col3 through col232. Also the output should be sorted based on first 2 columns.

Here is a reduced example with 6 columns.

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are tab separated.

I am stuck with by DNA clustering analysis. I thought this forum will be a great help with data manipulations. Please help me.

I have a table with 91 columns. First I want to trim the table to only having rows where the column values are single characters which are A,T,G,C or 0. So any row having column values such as AA,AAG, AATG , Y, K etc has to be filtered out.

Hi,

I have a tab delimited text file with multiple columns. The second and third columns include numbers that have not been sorted. I want to extract rows where the second column includes a value between -0.01 and 0.01 (including both numbers) and the first third column includes a value between 1 and 5 (including). How do I go about doing that?

I have two files and i want to arrange rows of 2nd file in the same order of rows in 1st file. where column no 2 and 5 of 2nd files have same values as 1st file only the difference is their order is different. considering that complete rows should rearrange not only 2nd and 3rd columns .

Hello,

I have a very large file for which I would like to remove all rows for which the value of columns 2-5 is zero.

I've a text file with below values viz. multiple rows with same values in column 3, 4 and 5, which need to be considered as duplicates. For all such cases, the rows from second occurrence onwards should be modified in a way that their values in first two columns are replaced with values as in first occurrence.

Hi, This may not be the right forum but i am hoping someone knows an answer to this.

I have to capture rows for a column that was deleted.

Hi all,

I have 7 words

Code: CAD CD HT RA T1D T2D BD Now I have 1 file which contain data in large number of rows and columns

from 2 nd column onwards it contain any of these 7 words or may be more than one words among above 7 words:

these 7 names are present in starting from 2nd column

means the file contain any of these 7 words in coulmns 2,3,4,5,6,7,89,10...

It's a big file in t