Getting the most repeated column Post: 302831069

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...

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?""""""

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 ...

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...

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...

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...

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...

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 ...

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 ...

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...

LEARN ABOUT DEBIAN

grcat

GRCAT(1)						      General Commands Manual							  GRCAT(1)

NAME

       grcat - read from standard input, colourise it and write to standard output

SYNOPSIS

       grcat configuration

DESCRIPTION

       configuration  is a name of a configuration file. Directories ~/.grc/, /usr/local/share/grc/, /usr/share/grc/ are searched for the file (in
       this order).

       If the file is not found, it is assumed to be an absolute path of a configuration file located elsewhere.

       Configuration file consists of entries, one per regexp, entries are separated with lines with first character non-alphanumeric (except  #).
       Lines beginning with # or empty lines are ignored.

       Each  entry  consists  of several lines.  Each line has form: keyword=value where keyword is one of: regexp, colours, command, skip, count.
       Only regexp is mandatory, but it does not have much sense by itself unless you specify at least a colour or command keyword as well.

       regexp is the regular expression to match

       colours is the list of colours, separated by commas (you can specify only one colour), each colour per one regexp group specified  in  reg-
       exp.

       command	is  command  to be executed when regexp matches. Its output will be mixed with normal stdout, use redirectors ( >/dev/null) if you
       want to supress it.

       skip can be either yes, or no, if yes, the matched line will be skipped and not displayed in output.  Default is no.

       count is one of words: once, more, or stop.

       once means that if the regexp is matched, its first occurrence is coloured and the program will continue with other regexp's.

       more means that if there are multiple matches of the regexp in one line, all of them will be coloured.

       stop means that the regexp will be coloured and program will move to the next line (i.e. ignoring other regexp's)

       Regular expressions are evaluated from top to bottom, this allows nested and overlapped expressions. (e.g.  you	colour	everything  inside
       parentheses with one colour, and if a following expression matches the text inside parentheses, it will be also coloured)

OPTIONS

       None so far.

SEE ALSO

       grc(1)

AUTHOR

       Written by Radovan Garabik <garabik @ kassiopeia.juls.savba.sk>

																	  GRCAT(1)