Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting the most repeated column
Top Forums Shell Programming and Scripting Getting the most repeated column Post 302830995 by teefa on Wednesday 10th of July 2013 03:39:09 AM
Old 07-10-2013
i have tried with
Code:
cat file | uniq -c | /usr/xpg4/bin/awk -F"," '!a[$1,$2]++'

to get me first or most repeated but in case of tom i want the 2 cases from 2 diff records in one record

its not that simple
Code:
name,ID,ID1,ID2
adam,12345,1,2  ----1
adam,12345,1,1  ----2
adam,934,1,2
adam,12345,2,2  ----3
john,14
john,13
john,25 ----1 
john,25 ----2
tom,1  -----1
tom,2  -----1

to get me for example
Code:
adam,12345,1,2 the most repeated fields in one reocrds

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting repeated strings in column 2

Hi to all, I have a file where the subject could contain "Summarized Availability Report" or only "Summarized Report" If the subject is "Summarized Availability Report" I want to apply it Scrip1 and if the subject is "Summarized Report" I want to apply it Scrip2. 1-) I would like you... (5 Replies)
Discussion started by: cgkmal
5 Replies

2. Shell Programming and Scripting

repeated column data filter and make as a row

I need to get the output in row wise for the repeated column data Ex: Input: que = five ans = 5 que = six ans = 6 Required output: que = five six ans = 5 6 Any body can guide me?"""""" (2 Replies)
Discussion started by: vasanth_vadalur
2 Replies

3. UNIX for Dummies Questions & Answers

Extracting column if above certain values and repeated over a number of times continuously

Hi I am new to the forum and would like to ask: i have a file in form with thousands of column id.1 A01 A01 A68 A68 id.2 A5 A5 A3 A3 1001 0 0 0.136 0.136 1002 0 0 0.262 0.183 1003 0 0 0.662 0.662 1004 0 0 ... (9 Replies)
Discussion started by: newbeeuk
9 Replies

4. UNIX for Dummies Questions & Answers

Average for repeated elements in a column

I have a file that looks like this 452 025_E3 8 025_E3 82 025_F5 135 025_F5 5 025_F5 23 025_G2 38 025_G2 71 025_G2 9 026_A12 81 026_A12 10 026_A12 some of the elements in column2 are repeated. I want an output file that will extract the... (1 Reply)
Discussion started by: FelipeAd
1 Replies

5. Emergency UNIX and Linux Support

[Solved] Extract records based on a repeated column value

Hi guys, I need help in making a command to find some data. I have multiple files in which multiple records are present.. Each record is separated with a carriage return and in each record there are multiple fields with each field separated by "|" what i want is that I want to extract... (1 Reply)
Discussion started by: m_usmanayub
1 Replies

6. Shell Programming and Scripting

Finding most repeated entry in a column and giving the count

Please can you help in providing the most repeated entry in the 2nd column and give its count Here is an input file 1, This , is a forum 2, This , is a forum 1, There , is a forum 2, This , is not right Here the most repeated entry is "This" and count is 3 So output... (4 Replies)
Discussion started by: necro98
4 Replies

7. Shell Programming and Scripting

Find repeated word and take sum of the second field to it ,for all the repeated words in awk

Hi below is the input file, i need to find repeated words and sum up the values of it which is second field from the repeated work.Im trying but getting no where close to it.Kindly give me a hint on how to go about it Input fruits,apple,20,fruits,mango,20,veg,carrot,12,veg,raddish,30... (11 Replies)
Discussion started by: 100bees
11 Replies

8. Shell Programming and Scripting

Choosing between repeated entries based on a column field

Hello, I have an input file: LOC_Os04g01890\LOC_Os05g17604 0.051307 LOC_Os04g01890\LOC_Os05g17604 0.150977 LOC_Os04g01890\LOC_Os05g17604 0.306231 LOC_Os04g01890\LOC_Os06g33100 0.168037 LOC_Os04g01890\LOC_Os06g33100 0.236293 ... (3 Replies)
Discussion started by: Sanchari
3 Replies

9. Shell Programming and Scripting

Choosing between repeated entries based on the "absolute values" of a column

Hello, I was looking for a way to select between the repeated entries (column1) based on the values of absolute values of column 3 (larger value). For example if the same gene id has FC value -2 and 1, I should get the output as -2. Kindly help. GeneID Description FC ... (2 Replies)
Discussion started by: Sanchari
2 Replies

10. UNIX for Dummies Questions & Answers

Append no of times a column is repeated at the end

Hi folks, Iam working on a bash script, i need to print how many times column 2 repeated at the end of each line. Input.txt COL1 COL2 COL3 COL4 1 XX 45 N 2 YY 34 y 3 ZZ 44 N 4 XX 89 Y 5 XX 45 N 6 YY 84 D 7 ZZ 22 S Output.txt COL1 COL2 COL3 COL4 COL5 1 XX 45 N 3 2 YY 34... (6 Replies)
Discussion started by: tech_frk
6 Replies

LEARN ABOUT LINUX

transition-check

TRANSITION-CHECK(1)                                                                                                            TRANSITION-CHECK(1)

NAME

       transition-check - check a package list for involvement in transitions

SYNOPSIS

       transition-check --help|--version

       transition-check [-f|--filename=FILENAME] [source package list]

DESCRIPTION

       transition-check checks whether any of the listed source packages are involved in a transition for which uploads to unstable are currently
       blocked.

       If neither a filename nor a list of packages is supplied, transition-check will use the source package name from debian/control.

OPTIONS

       -f, --filename=filename
           Read a source package name from filename, which should be a Debian package control file or .changes file, and add that package to the
           list of packages to check.

EXIT STATUS

       The exit status indicates whether any of the packages examined were found to be involved in a transition.

       0   Either --help or --version was used, or none of the packages examined was involved in a transition.

       1   At least one package examined is involved in a current transition.

LICENSE

       This code is copyright by Adam D. Barratt <adam@adam-barratt.org.uk>, all rights reserved.

       This program comes with ABSOLUTELY NO WARRANTY.  You are free to redistribute this code under the terms of the GNU General Public License,
       version 2 or later.

AUTHOR

       Adam D. Barratt <adam@adam-barratt.org.uk>

Debian Utilities                                                    2013-12-23                                                 TRANSITION-CHECK(1)
All times are GMT -4. The time now is 08:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy