|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Count Repetitive Number in a column and renumbering using awk
Post 303024247 by himanshu on Thursday 4th of October 2018 11:38:09 AM
10-04-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have an input below and i would want to do a count on all the term "aaa" and count only once if the number in first column is the same.
For eg, if i use a "grep -c aaa input" command, the count will be "8".
However, i would want the count to be "6" instead since 2 numbers in the 1st... (7 Replies)
Discussion started by: Raynon
7 Replies
2. Shell Programming and Scripting
Hi,
I am a beginner in awk scripting! I need your help; I want to replace the fifth column number (which is 15 here) here in this file for example :
ATOM 142 N PRO A 15
ATOM 143 CD PRO A 15
ATOM 144 HD1 PRO A 15
ATOM ... (5 Replies)
Discussion started by: adak
5 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I have the following input which i want to process using AWK.
Rows,NC,amount
1,1202,0.192387
2,1201,0.111111
3,1201,0.123456
i want the following output
count of rows = 3 ,sum of amount = 0.426954
Many thanks (2 Replies)
Discussion started by: pistachio
2 Replies
4. Shell Programming and Scripting
im trying to count the number of occurences of column 2 value(starting from KKK*) of the below file, file.txt
using the code cat file.txt | awk ' BEGIN { print "Category Counts"} {FS=","} {NR > 2} { cats = cats + 1} END { for(c in cats) { print c, "=", cats} } '
but its returning as
... (6 Replies)
Discussion started by: michaelrozar17
6 Replies
5. UNIX for Dummies Questions & Answers
Could anybody help with this?
I have input below .....
david,39
david,39
emelie,40
clarissa,22
bob,42
bob,42
tim,32
bob,39
david,38
emelie,47
what i want to do is count how many names there are with different ages, so output would be like this ....
david,2
emelie,2
clarissa,1... (3 Replies)
Discussion started by: itsme999
3 Replies
6. Shell Programming and Scripting
This is the source file, we called it errorlist.out
196 server_a server_unix_2 CD
196 server_b server_win_1 CD
196 server_c server_win_2 CD
196 server_bd server_unix_2 CD
196 server_d server_unix_2 CD
196 server_es server_win_1 CD
196 ... (14 Replies)
Discussion started by: sQew
14 Replies
7. Shell Programming and Scripting
Hi
I was going through the below thread
https://www.unix.com/shell-programming-scripting/48535-how-count-number-fields-record.html
I too have something similar requirement as specified in this thread but the number of columns in my case can be very high, so I am getting following error.
... (3 Replies)
Discussion started by: shekharjchandra
3 Replies
8. Shell Programming and Scripting
Hi i have data like
abchd 124 ldskc aattggcc
each separated by tab space i want to count number of characters in 4th column and print it in new column with tabspace for every line can anyone help me how to do it.
Thanks. (3 Replies)
Discussion started by: bhargavpbk88
3 Replies
9. UNIX for Dummies Questions & Answers
Hi !
input:
A|B|C|D
A|F|C|E
A|B|I|C
A|T|I|B
As the title of the thread says, I would need to get:
1|3|2|4
I tried different variants of this command, but I don't manage to obtain what I need:
gawk 'BEGIN{FS=OFS="|"}{for(i=1; i<=NF; i++) a++} END {for (b in a) print b}' input
... (2 Replies)
Discussion started by: beca123456
2 Replies
10. Shell Programming and Scripting
What is an efficient way of counting the number of unique values in a 400 column by 1000 row array and outputting the counts per column, assuming the unique values in the array are:
A, B, C, D
In other words the output should look like: Value COL1 COL2 COL3
A 50 51 52... (16 Replies)
Discussion started by: Geneanalyst
16 Replies
LEARN ABOUT OSX
datetime::locale::ga
DateTime::Locale::ga(3) User Contributed Perl Documentation DateTime::Locale::ga(3) NAME
DateTime::Locale::ga SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ga' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Irish. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) De Luain De Mairt De Ceadaoin Deardaoin De hAoine De Sathairn De Domhnaigh Abbreviated (format) Luan Mairt Cead Dear Aoine Sath Domh Narrow (format) L M C D A S D Wide (stand-alone) De Luain De Mairt De Ceadaoin Deardaoin De hAoine De Sathairn De Domhnaigh Abbreviated (stand-alone) Luan Mairt Cead Dear Aoine Sath Domh Narrow (stand-alone) L M C D A S D Months Wide (format) Eanair Feabhra Marta Aibrean Bealtaine Meitheamh Iuil Lunasa Mean Fomhair Deireadh Fomhair Samhain Nollaig Abbreviated (format) Ean Feabh Marta Aib Beal Meith Iuil Lun MFomh DFomh Samh Noll Narrow (format) E F M A B M I L M D S N Wide (stand-alone) Eanair Feabhra Marta Aibrean Bealtaine Meitheamh Iuil Lunasa Mean Fomhair Deireadh Fomhair Samhain Nollaig Abbreviated (stand-alone) Ean Feabh Marta Aib Beal Meith Iuil Lun MFomh DFomh Samh Noll Narrow (stand-alone) E F M A B M I L M D S N Quarters Wide (format) 1u raithe 2u raithe 3u raithe 4u raithe Abbreviated (format) R1 R2 R3 R4 Narrow (format) 1 2 3 4 Wide (stand-alone) 1u raithe 2u raithe 3u raithe 4u raithe Abbreviated (stand-alone) R1 R2 R3 R4 Narrow (stand-alone) 1 2 3 4 Eras Wide Roimh Chriost Anno Domini Abbreviated RC AD Narrow RC AD Date Formats Full 2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008 1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995 -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10 Long 2008-02-05T18:30:30 = 5 Feabhra 2008 1995-12-22T09:05:02 = 22 Nollaig 1995 -0010-09-15T04:44:23 = 15 Mean Fomhair -10 Medium 2008-02-05T18:30:30 = 5 Feabh 2008 1995-12-22T09:05:02 = 22 Noll 1995 -0010-09-15T04:44:23 = 15 MFomh -10 Short 2008-02-05T18:30:30 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 Default 2008-02-05T18:30:30 = 5 Feabh 2008 1995-12-22T09:05:02 = 22 Noll 1995 -0010-09-15T04:44:23 = 15 MFomh -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Long 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Datetime Formats Full 2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008 18:30:30 UTC 1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995 09:05:02 UTC -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10 04:44:23 UTC Long 2008-02-05T18:30:30 = 5 Feabhra 2008 18:30:30 UTC 1995-12-22T09:05:02 = 22 Nollaig 1995 09:05:02 UTC -0010-09-15T04:44:23 = 15 Mean Fomhair -10 04:44:23 UTC Medium 2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30 1995-12-22T09:05:02 = 22 Noll 1995 09:05:02 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23 Short 2008-02-05T18:30:30 = 05/02/2008 18:30 1995-12-22T09:05:02 = 22/12/1995 09:05 -0010-09-15T04:44:23 = 15/09/-010 04:44 Default 2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30 1995-12-22T09:05:02 = 22 Noll 1995 09:05:02 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23 Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 Mairt 1995-12-22T09:05:02 = 22 Aoine -0010-09-15T04:44:23 = 15 Sath HHmm (HH:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 HHmmss (HH:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 p.m. 1995-12-22T09:05:02 = 9:05 a.m. -0010-09-15T04:44:23 = 4:44 a.m. Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 p.m. 1995-12-22T09:05:02 = 9:05:02 a.m. -0010-09-15T04:44:23 = 4:44:23 a.m. M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (d/M) 2008-02-05T18:30:30 = 5/2 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/9 MEd (E, M-d) 2008-02-05T18:30:30 = Mairt, 2-5 1995-12-22T09:05:02 = Aoine, 12-22 -0010-09-15T04:44:23 = Sath, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = Feabh 1995-12-22T09:05:02 = Noll -0010-09-15T04:44:23 = MFomh MMMd (MMM d) 2008-02-05T18:30:30 = Feabh 5 1995-12-22T09:05:02 = Noll 22 -0010-09-15T04:44:23 = MFomh 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Mairt Feabh 5 1995-12-22T09:05:02 = Aoine Noll 22 -0010-09-15T04:44:23 = Sath MFomh 15 MMMMd (d MMMM) 2008-02-05T18:30:30 = 5 Feabhra 1995-12-22T09:05:02 = 22 Nollaig -0010-09-15T04:44:23 = 15 Mean Fomhair MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Mairt Feabhra 5 1995-12-22T09:05:02 = Aoine Nollaig 22 -0010-09-15T04:44:23 = Sath Mean Fomhair 15 mmss (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = Mairt, 2008-2-5 1995-12-22T09:05:02 = Aoine, 1995-12-22 -0010-09-15T04:44:23 = Sath, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Feabh 1995-12-22T09:05:02 = 1995 Noll -0010-09-15T04:44:23 = -10 MFomh yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Mairt, 2008 Feabh 5 1995-12-22T09:05:02 = Aoine, 1995 Noll 22 -0010-09-15T04:44:23 = Sath, -10 MFomh 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Feabhra 1995-12-22T09:05:02 = 1995 Nollaig -0010-09-15T04:44:23 = -10 Mean Fomhair yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 R1 1995-12-22T09:05:02 = 1995 R4 -0010-09-15T04:44:23 = -10 R3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyMMM (MMM yy) 2008-02-05T18:30:30 = Feabh 08 1995-12-22T09:05:02 = Noll 95 -0010-09-15T04:44:23 = MFomh -10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMM (MM/yyyy) 2008-02-05T18:30:30 = 02/2008 1995-12-22T09:05:02 = 12/1995 -0010-09-15T04:44:23 = 09/-010 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = Feabhra 2008 1995-12-22T09:05:02 = Nollaig 1995 -0010-09-15T04:44:23 = Mean Fomhair -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week De Luain SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.2 2013-08-25 DateTime::Locale::ga(3)