|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Column sum group by uniq records
Post 302161917 by Nayanajith on Saturday 26th of January 2008 09:44:26 PM
01-26-2008
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
i have a file where the records are like this.
vt100 2048 D402 MG0010 0
586 262144 D403 MG0011 1000
486 8192 D404 MG0012 270
386 8192 A423 CC0177 40
586 65536 A424 CC0182 670
486 16384 A423 CC0183 100
486 16384 A425 CC0184 80
65000 4096 B407 EE1027 80
I want firstly,
to count how... (10 Replies)
Discussion started by: sickboy
10 Replies
2. Shell Programming and Scripting
I have a file in the following format. Groups of data merge together and the group number is indicated above each group.
1
adrf
dfgr
dfg
2
dfgr
dfgr
3
dfef
dfr
fd
4
fgrt
fgr
fgg
5
fgrt
fgr (3 Replies)
Discussion started by: Lucky Ali
3 Replies
3. Shell Programming and Scripting
Hi All
I do have a file like this with 6 columns. Groups of data merge together and the group number is indicated above each group.
1
1 12 26 289 3.2e-027 GCGTATGGCGGC
2 12 26 215 6.7e+006 TTCCACCTTTTG
3 9 26 175 ... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
4. Shell Programming and Scripting
Hello All ,
I have a problem with summing of column by group
Input File -
COL_1,COL_2,COL_3,COL_4,COL_5,COL_6,COL_7,COL_8,COL_9,COL_10,COL_11
3010,21,1923D ,6,0,0.26,0,0.26,-0.26,1,200807
3010,21,192BI ,6,24558.97,1943.94,0,1943.94,22615.03,1,200807
3010,21,192BI... (8 Replies)
Discussion started by: jambesh
8 Replies
5. Shell Programming and Scripting
12-11-2012,PNL,158406
12-11-2012,RISK,4564
12-11-2012,VAR_1D,310101
12-11-2012,VAR_10D,310101
12-11-2012,CB,866
12-11-2012,STR_VAR_1D,298494
12-11-2012,STR_VAR_10D,309623
09-11-2012,PNL,1024106
09-11-2012,RISK,4565
09-11-2012,VAR_1D,317211
09-11-2012,VAR_10D,317211
09-11-2012,CB,985... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
6. Shell Programming and Scripting
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies
7. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies
9. Shell Programming and Scripting
I want to bring values in the second column into single line for uniq value in the first column.
My input
jvm01, Web 2.0 Feature Pack Library
jvm01, IBM WebSphere JAX-RS
jvm01, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library
jvm02, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature... (10 Replies)
Discussion started by: kchinnam
10 Replies
10. Shell Programming and Scripting
awk to Sum columns when other column has duplicates and append one column value to another with Care
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (1 Reply)
Discussion started by: as7951
1 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)