Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Count and merge using common column
Top Forums Shell Programming and Scripting Count and merge using common column Post 302724547 by Chubler_XL on Wednesday 31st of October 2012 07:40:42 PM
Old 10-31-2012
Think this does what you want

Code:
awk '
$3!="." {
    key=$1"\t"$2
    if(!(key in I)) D[++keys]=key
        if(!((key SUBSEP $3) in M)) {
            I[key]++
            K[key,I[key]]=$3
        }
    M[key,$3]++
    S[key]++
}
END {
    for(i=1;i<=keys;i++) {
            key=D[i]
        printf "%d\t", S[key]
        if(I[key]>1)
            for(j=1;j<=I[key];j++)
               printf "%s%d",(j>1?",":""),M[key,K[key,j]]
        printf "\t%s\t", key
        for(j=1;j<=I[key];j++)
               printf "%s%s",(j>1?"/":""),K[key,j]
        printf "\n"
    }
}' infile

This User Gave Thanks to Chubler_XL For This Post:
empyrean
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

merge based on common, awk help

All, $ cat x.txt z 11 az x 12 ax y 13 ay $ cat y.txt ay TT ax NN Output required: y 13 ay TT x 12 ax NN (3 Replies)
Discussion started by: jkl_jkl
3 Replies

2. Shell Programming and Scripting

merge rows based on a common column

Hi guys, Please guide me if you have a solution to this problem. I have tried paste -s but it's not giving the desired output. I have a file with the following content- A123 box1 B345 bat2 C431 my_id A123 service C431 box1 A123 my_id I need two different outputs- OUTPUT1 A123... (6 Replies)
Discussion started by: smriti_shridhar
6 Replies

3. Shell Programming and Scripting

"Join" or "Merge" more than 2 files into single output based on common key (column)

Hi All, I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations: 1. I am restrained to 2 input files only. 2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Discussion started by: Katabatic
1 Replies

4. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns. I want the merge all these text files by the matching values in the second column. In the output, the first column should... (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

Merge rows with common column

Dear all I have big file with two columns A_AA960715 GO:0006952 A_AA960715 GO:0008152 A_AA960715 GO:0016491 A_AA960715 GO:0007165 A_AA960715 GO:0005618 A_AA960716 GO:0006952 A_AA960716 GO:0005618 A_AA960716... (15 Replies)
Discussion started by: AAWT
15 Replies

6. Shell Programming and Scripting

file merge based on common columns

I have two files 1.txt 34, ABC, 7, 8, 0.9 35, CDE, 6.5, -2, 0.01 2.txt 34, ABC, 9, 6, -1.9 35, CDE, 8.5, -2.3, 5.01 So in both files common columns are 1 and 2 so final o/p should look like 34, ABC, 7, 8, 0.9, 9, 6, -1.9 35, CDE, 6.5, -2, 0.01, 8.5, -2.3, 5.01 I tried using... (3 Replies)
Discussion started by: manas_ranjan
3 Replies

7. Shell Programming and Scripting

Merge with common column

hi i have two files and i wanted to join them using common column. try to do this using "join" command but that did not help. File 1: 123 9a.vcf hy92.vcf hy90.vcf Index Ref Alt Ref Alt Ref Alt 315 14 0 7 4 ... (6 Replies)
Discussion started by: empyrean
6 Replies

8. Shell Programming and Scripting

Count common elements in a column

HI, I have a 3-column tab separated column (approx 1GB) in which I would like to count and output the frequency of all of the common elements in the 1st column. For instance: If my input was the following: dot is-big 2 dot is-round 3 dot is-gray 4 cat is-big 3 hot in-summer 5 My... (4 Replies)
Discussion started by: owwow14
4 Replies

9. Shell Programming and Scripting

Seperated by columns, merge in a file, sort them on common column

Hi All, I have 4 files in below format. I took them as an example. File 1: Cut from position 1-4 then 6-7 then 8-14 then rest left and make them as columns in one new file. Inserting character H to the initial of all line like HCTOT. CTOT 456787897 Low fever CTOR 556712345 High fever... (2 Replies)
Discussion started by: Mannu2525
2 Replies

10. Shell Programming and Scripting

Merge multiple files with common header

Hi all, Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),, How can I merge them to one singe file "X" in shell scripting Thanks for your suggestions. (2 Replies)
Discussion started by: msarguru
2 Replies

LEARN ABOUT MOJAVE

glutspecialupfunc

glutSpecialUpFunc(3GLUT)					       GLUT						  glutSpecialUpFunc(3GLUT)

NAME

       glutSpecialUpFunc - sets the special keyboard up (key release) callback for the current window.

SYNTAX

       #include <GLUT/glut.h>

       void glutSpecialUpFunc(void (*func)(int key, int x, int y));

ARGUMENTS

       func	 The new special callback function.

DESCRIPTION

       glutSpecialUpFunc sets the special keyboard up (key release) callback for the current window. The special keyboard up callback is triggered
       when keyboard function or directional keys are released. The key callback parameter is a GLUT_KEY_* constant for the special  key  pressed.
       The  x  and y callback parameters indicate the mouse in window relative coordinates when the key was pressed. When a new window is created,
       no special up callback is initially registered and special key releases in the window are ignored.  Passing NULL to glutSpecialUpFunc  dis-
       ables the generation of special up callbacks.

       During  a  special  up callback, glutGetModifiers may be called to determine the state of modifier keys when the key release generating the
       callback occurred.

       To avoid the reporting of key release/press pairs due to auto repeat, use glutIgnoreKeyRepeat to ignore auto repeated keystrokes.

       An implementation should do its best to provide ways to generate all the GLUT_KEY_* special keys. The available GLUT_KEY_* values are:

       GLUT_KEY_F1
	       F1 function key.

       GLUT_KEY_F2
	       F2 function key.

       GLUT_KEY_F3
	       F3 function key.

       GLUT_KEY_F4
	       F4 function key.

       GLUT_KEY_F5
	       F5 function key.

       GLUT_KEY_F6
	       F6 function key.

       GLUT_KEY_F7
	       F7 function key.

       GLUT_KEY_F8
	       F8 function key.

       GLUT_KEY_F9
	       F9 function key.

       GLUT_KEY_F10
	       F10 function key.

       GLUT_KEY_F11
	       F11 function key.

       GLUT_KEY_F12
	       F12 function key.

       GLUT_KEY_LEFT
	       Left directional key.

       GLUT_KEY_UP
	       Up directional key.

       GLUT_KEY_RIGHT
	       Right directional key.

       GLUT_KEY_DOWN
	       Down directional key.

       GLUT_KEY_PAGE_UP
	       Page up directional key.

       GLUT_KEY_PAGE_DOWN
	       Page down directional key.

       GLUT_KEY_HOME
	       Home directional key.

       GLUT_KEY_END
	       End directional key.

       GLUT_KEY_INSERT
	       Inset directional key.

       Note that the escape, backspace, and delete keys are generated as an ASCII character.

SEE ALSO

       glutSpecialFunc, glutKeyboardFunc, glutKeyboardUpFunc,  glutMouseFunc,  glutSpaceballButtonFunc,  glutButtonBoxFunc,  glutTabletButtonFunc,
       glutGetModifiers, glutIgnoreKeyRepeat

AUTHOR

       Mark J. Kilgard (mjk@nvidia.com)

GLUT
									3.7						  glutSpecialUpFunc(3GLUT)
All times are GMT -4. The time now is 08:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy