How many studies have unequal values for each pair? Post: 302978109

Sponsored Content

Top Forums Shell Programming and Scripting How many studies have unequal values for each pair? Post 302978109 by rdrtx1 on Tuesday 26th of July 2016 11:24:13 AM

07-26-2016

Read Only

Code:

awk '
$1+0 {a[$2]=$2; b[$2,c[$2]++]=$3}                                        # load variable names array, load pairs array
END {
   for (i in a) {
      for (j in a) {
         if (i != j) {
            for (k=0; k<c[i]; k++) {
               if (b[i,k] && b[j,k] && (b[i,k] != b[j,k])) {
                  out[i,j]++;                                            # count pair mismatches for existing pairs
               }
            }
         }
      }
   }
   print "Point1\tPoint2\t#StudiesWhereValuesAreDifferentForThisPair";   # print header
   for (i in a) {
      for (j in a) {
         if (out[i,j] && ! p[j,i] && ! p[i,j]) {                         # for non repeat pairs output
            print i "\t" j "\t" out[i,j];                                # print pair mismatch counts
            p[j,i]=p[i,j]=1;                                             # set pair array printed
         }
      }
   }
}
' infile

Verify p2 p5 from sample output.

Last edited by rdrtx1; 07-26-2016 at 01:44 PM..

This User Gave Thanks to rdrtx1 For This Post:

rdrtx1

View Public Profile for rdrtx1

Find all posts by rdrtx1

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting a file into unequal parts

How do I split a file into many parts but with different amounts of lines per part? I looked at the split command but that only splits evenly. I'd like a range specified to determine how many lines each output file should have. For example, if the input file has 1000 lines and the range is...

2. UNIX for Dummies Questions & Answers

Merge two files with common IDs but unequal number of rows

Hi, I have two files that I would like to merge and think that there should be a solution using awk. The files look something like this: file 1 IDX1 IDY1 IDX2 IDY2 IDX3 IDY3 file 2 IDY1 dataA data1 IDY2 dataB data2 IDY3 dataC data3 Desired output IDX1 IDY1 dataA data1 IDX2 ...

3. Shell Programming and Scripting

Newline between unequal record fields

Assume the following 5 records (field separator is a space): 0903 0903 0910 0910 0910 0910 0910 0910 0917 0917 0917 0917 0924 1001 1001 1001 1001 1008 1008 1008 1008 1015 1015 1015 1015 1022 1029 1029 1029 1029 1105 1105 1105 1105 1112 1112 1112 1112 1119 1126 1126 1126 1126 1203 1203 1203 1203...

4. Shell Programming and Scripting

Pair wise comparisons

Hi, I have 25 groups and I need to perform all possible pairwise compariosns between them using the formula n(n-1)/2. SO in my case it will be 25(25-1)/2 which is equal to 300 comparisons. my 25 groups are FG1 FG2 FG3 FG4 FG5 NT5E CD44 CD44 CD44 AXL ADAM19 CCDC80 L1CAM L1CAM CD44...

5. Shell Programming and Scripting

Compare two unsorted unequal files extracted from xml

I have two files for comparison which are extracts from set of xml files. file1 has: Comparing File: BRCSH1to320140224CC3.xml :: TZZZ:BR :: TAZZ:OUT UIZZ:0 :: ERAZ:1.000000 UIZZ:0 :: CTZZ:B UIZZ:0 :: CCAZ:MYR Comparing File: BRMY20140224CC18REG013SPFNSY13.xml :: TZZZ:BR :: TAZZ:INB...

6. Shell Programming and Scripting

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

7. Shell Programming and Scripting

awk name pair values

Team, I have a file like below FILE: NAM1,KEY1,VAL1 NAM1,KEY2,VAL2 NAM1,KEY3,VAL3 NAM2,KEY1,VALA NAM2,KEY2,VALB NAM2,KEY3,VALCOutput: I have to build commands like below <Script> VAL1 VAL2 VAL3 NAME1 <Script> VALA VALB VALC NAME2Can you please help with awk command i can use...

LEARN ABOUT CENTOS

calc_spline

calc_spline(3alleg4)						  Allegro manual					      calc_spline(3alleg4)

NAME

       calc_spline - Calculates a series of values along a Bezier spline. Allegro game programming library.

SYNOPSIS

       #include <allegro.h>

       void calc_spline(const int points[8], int npts, int *x, int *y);

DESCRIPTION

       Calculates  a  series of npts values along a Bezier spline, storing them in the output x and y arrays. The Bezier curve is specified by the
       four x/y control points in the points array: points[0] and points[1] contain the coordinates of the  first  control  point,  points[2]  and
       points[3]  are  the second point, etc. Control points 0 and 3 are the ends of the spline, and points 1 and 2 are guides. The curve probably
       won't pass through points 1 and 2, but they affect the shape of the curve between points 0 and 3 (the lines p0-p1 and p2-p3 are tangents to
       the  spline).  The  easiest  way to think of it is that the curve starts at p0, heading in the direction of p1, but curves round so that it
       arrives at p3 from the direction of p2.	In addition to their role as graphics primitives, spline curves can  be  useful  for  constructing
       smooth paths around a series of control points, as in exspline.c.

SEE ALSO

       spline(3alleg4), exspline(3alleg4)

Allegro 							   version 4.4.2					      calc_spline(3alleg4)