## Finding reciprocal columns

Finding reciprocal columns
# 8
02-01-2014
Quote:
Originally Posted by RawToast
@RudiC - I tried:

@Don - I am on OSX 10.8.5 - my awk command usually works for simple stuff like:

Do you see any difference between what you used:
and what RudiC suggested:
This User Gave Thanks to Don Cragun For This Post:
 Don Cragun View Public Profile for Don Cragun Find all posts by Don Cragun
# 9
02-02-2014
To print 0 if a reciprocal value is missing, force into numerical mode: ...{print \$0, T[\$2,\$1]+0} .
 Scrutinizer View Public Profile for Scrutinizer Find all posts by Scrutinizer
# 10
02-02-2014
@Don - O I C... thanks.

@all- OK I feel like I almost have this working, but still isn't perfect. I tried the following as command (note inclusion of Scrutinizer's suggestion):
the input file test.txt has the following (delimiters are tabs):
The output I get is:
This is pretty close to what I want, but if I could get the returned value on the same line that would be great. Not sure why it isn't on the same line, could this be a formatting issue with the input file?

The output I am looking for is:
Actually have a 0 for the 4th column for rows without reciprocals isn't essential. So would be fine also.

Thanks for all you help with this guys.

Last edited by RawToast; 02-02-2014 at 08:14 AM..
 RawToast View Public Profile for RawToast Find all posts by RawToast
# 11
02-02-2014
Try :

OR

This is my understanding about reciprocal

For example, the reciprocal of 2/3 is 3/2 (or 1-1/2) , because 2/3 x 3/2 = 1. The reciprocal of 7 is 1/7 because 7 x 1/7 = 1.
 Akshay Hegde View Public Profile for Akshay Hegde Find all posts by Akshay Hegde
# 12
02-02-2014
Ok, so now we have a clear understanding of what the outout should look like. So you want values that have themselves as counter values to be 0 in the last column. I noticed in your output there was also a zero, presumably from an empty line. But I don not know why some parts start on a new line. To counteract the empty line and to cater for entries that might lack a reversed counterpart I used NF and reintroduced the +0 bit. I took RudiC's and Akshay's suggestions and made a couple of changes:

Last edited by Scrutinizer; 02-02-2014 at 01:28 PM..
 Scrutinizer View Public Profile for Scrutinizer Find all posts by Scrutinizer
# 13
02-02-2014
Hi.

Here is a script that breaks down the tasks into pieces of work. Each step also writes the intermediate output so that the form can be examined.
producing:
1) Make lines into a canonical form in the sense of arranging the first 2 columns in a specific order. Also join the first two columns so that future tasks can be easily done.

2) Sort the items,

3) Collect contiguous lines that have an identical first column, a kind of self-join,

4) Add a trailing "0" if the number of fields is not appropriate,

5) Separate the first 2 columns.

I agree with implicit remark of Akshay Hegde that reciprocal is not a word I would use to describe this.

Best wishes ... cheers, drl

PS This also works on OS-X:

Last edited by drl; 02-02-2014 at 12:14 PM..
 drl View Public Profile for drl Find all posts by drl
# 14
02-02-2014
Hi drl...

I might be missing something here but you have created two versions of the db()
function, one being a NOP, and don't seem to call either of them.
 wisecracker View Public Profile for wisecracker Find all posts by wisecracker

## Finding common entries between 10 columns

Hello, I need to find the intersection across 10 columns. Kindly help. my file (INPUT.csv) looks like this 4_R 4_S 8_R 8_S 12_R 12_S 24_R 24_S LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290 LOC_Os01g01010 LOC_Os01g01010...

## Finding difference between two columns of unequal length

Hi, I have two files which look like this cat waitstate.txt 18.2 82.1 cat gostate.txt 5.6 5.8 6.1 6.3 6.6 6.9 7.2 7.5

## UNIX scripting for finding duplicates and null records in pk columns

Hi, I have a requirement.for eg: i have a text file with pipe symbol as delimiter(|) with 4 columns a,b,c,d. Here a and b are primary key columns.. i want to process that file to find the duplicates and null values are in primary key columns(a,b) . I want to write the unique records in which...

## Finding value bigger than zero in all columns

Hi everybody, I am a complete novice and please forgive if its answered gazillion times I have a file which looks like this 1 0 2 0 0 0 0 0 0 3 0 1 18 2 6 0 1 7 0 2 4 0 0 0 1 17 16 1 1 0 0 I have to add...

## Finding standard deviation for all columns in a data file

Hi All, I want someone to modify the below script from this forum so that it can be used for all columns in the file( instead of only printing column 3 mean and standard deviation values). I don't know how to loop around all the columns. ...

## finding duplicates in csv based on key columns

Hi team, I have 20 columns csv files. i want to find the duplicates in that file based on the column1 column10 column4 column6 coulnn8 coulunm2 . if those columns have same values . then it should be a duplicate record. can one help me on finding the duplicates, Thanks in advance. ...

## Matching same columns and finding the smallest match

Hi all, I am wondering if its possible to solve my problem with a simple code. Basically I have a file that looks like this (tab delimited) bob 8 250 tina 8 225 sam 8 225 ellen 9 315 kyle 9 275 sally 9 135 So what I want to do is match columns 2 and 5. If columns 2 and 5...

## finding duplicates in columns and removing lines

I am trying to figure out how to scan a file like so: 1 ralphs office","555-555-5555","ralph@mail.com","www.ralph.com 2 margies office","555-555-5555","ralph@mail.com","www.ralph.com 3 kims office","555-555-5555","kims@mail.com","www.ralph.com 4 tims...

## finding duplicate files by size and finding pattern matching and its count

Hi, I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern. Note:These are the samples of two files,but i can have more...