|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Getting the most repeated column
Post 302831069 by zaxxon on Wednesday 10th of July 2013 06:48:12 AM
07-10-2013
Nope, that's not correct.
NR>=1 means equal or greater than 1. Since a file you want to parse usually has a 1st line, this makes no sense. You could leave it away if you want to count the header in.
If you want to skip the header line, you have to use NR>1 to just skip it.
So if the 2nd example is just a new or altered request, you should be able to alter the code given, to achieve the same. If you do not understand the code, that is no problem, but you have to let us know.
This is no script drive-in
NR>=1 means equal or greater than 1. Since a file you want to parse usually has a 1st line, this makes no sense. You could leave it away if you want to count the header in.
If you want to skip the header line, you have to use NR>1 to just skip it.
So if the 2nd example is just a new or altered request, you should be able to alter the code given, to achieve the same. If you do not understand the code, that is no problem, but you have to let us know.
This is no script drive-in
Last edited by zaxxon; 07-10-2013 at 08:02 AM.. Reason: spelling
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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 DEBIAN
mcsender
MCSENDER(8) System Manager's Manual MCSENDER(8) NAME
mcsender - Multicast test tool to send multicast test packets SYNOPSIS
mcsender [-t<ttl>] [-i<interface>] ip:port DESCRIPTION
mcsender sends multicast packets to the specified IPv4 or IPv6 multicast address and port. The packets sent contain the string "this is the test message from mclab/mcsender ". OPTIONS
-t<ttl> Set the TTL (or hop limit for IPv6) to the specified value. -i<interface> Specify the interface to use for outgoing multicast datagrams. EXAMPLES
To send datagrams to IPv4 multicast address 239.1.1.1 and port 12345 with a TTL of 3: $ mcsender -t3 239.1.1.1:12345 To send datagrams to IPv4 multicast address 239.1.1.1 and port 12345 with a TTL of 3 out of interface eth1: $ mcsender -ieth1 -t3 239.1.1.1:12345 To send datagrams to IPv6 multicast address ff15::1 and port 12345 with a hop limit of 3: $ mcsender -t3 ff15::1:12345 To send datagrams to IPv6 multicast address ff15::1 and port 12345 with a hop limit of 3 out of interface eth1: $ mcsender -ieth1 -t3 ff15::1:12345 AUTHOR
mcsender was written by Carsten Schill <carsten@cschill.de>. Support for IPv6 was added by Todd Hayton <todd.hayton@gmail.com>. This manual page was written by Julien BLACHE <jblache@debian.org>, for the Debian project (but may be used by others). August 08, 2011 MCSENDER(8)