04-23-2010
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
3. Shell Programming and Scripting
I have a following inputfile
MT,AP,CDM,TTML,MUM,GS,SUCC,3
MT,AP,CDM,TTSL,AP,GS,FAIL,9
MT,AP,CDM,RCom,MAH,GS,SUCC,3
MT,AP,CDM,RTL,HP,GS,SUCC,1
MT,AP,CDM,Uni,UPE,GS,SUCC,2
MT,AP,CDM,Uni,MUM,GS,SUCC,2
TTSL,AP,GS,MT,MAH,CDM,SUCC,20
TTML,AP,GS,MT,MAH,CDM,FAIL,10... (2 Replies)
Discussion started by: siramitsharma
2 Replies
4. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies
5. 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
6. 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
7. 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
8. UNIX for Beginners Questions & Answers
I have a file which need to be summed up using date column.
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20
2017/01/01 b 30
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
2017/02/01 a 10... (6 Replies)
Discussion started by: Booo
6 Replies
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT DEBIAN
dbix::class::resultsetcolumn
DBIx::Class::ResultSetColumn(3pm) User Contributed Perl Documentation DBIx::Class::ResultSetColumn(3pm)
NAME
DBIx::Class::ResultSetColumn - helpful methods for messing
with a single column of the resultset
SYNOPSIS
$rs = $schema->resultset('CD')->search({ artist => 'Tool' });
$rs_column = $rs->get_column('year');
$max_year = $rs_column->max; #returns latest year
DESCRIPTION
A convenience class used to perform operations on a specific column of a resultset.
METHODS
new
my $obj = DBIx::Class::ResultSetColumn->new($rs, $column);
Creates a new resultset column object from the resultset and column passed as params. Used internally by "get_column" in
DBIx::Class::ResultSet.
as_query
Arguments: none
Return Value: [ $sql, @bind ]
Returns the SQL query and bind vars associated with the invocant.
This is generally used as the RHS for a subquery.
next
Arguments: none
Return Value: $value
Returns the next value of the column in the resultset (or "undef" if there is none).
Much like "next" in DBIx::Class::ResultSet but just returning the one value.
all
Arguments: none
Return Value: @values
Returns all values of the column in the resultset (or "undef" if there are none).
Much like "all" in DBIx::Class::ResultSet but returns values rather than row objects.
reset
Arguments: none
Return Value: $self
Resets the underlying resultset's cursor, so you can iterate through the elements of the column again.
Much like "reset" in DBIx::Class::ResultSet.
first
Arguments: none
Return Value: $value
Resets the underlying resultset and returns the next value of the column in the resultset (or "undef" if there is none).
Much like "first" in DBIx::Class::ResultSet but just returning the one value.
single
Arguments: none
Return Value: $value
Much like "single" in DBIx::Class::ResultSet fetches one and only one column value using the cursor directly. If additional rows are
present a warning is issued before discarding the cursor.
min
Arguments: none
Return Value: $lowest_value
my $first_year = $year_col->min();
Wrapper for ->func. Returns the lowest value of the column in the resultset (or "undef" if there are none).
min_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->min_rs();
Wrapper for ->func_rs for function MIN().
max
Arguments: none
Return Value: $highest_value
my $last_year = $year_col->max();
Wrapper for ->func. Returns the highest value of the column in the resultset (or "undef" if there are none).
max_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->max_rs();
Wrapper for ->func_rs for function MAX().
sum
Arguments: none
Return Value: $sum_of_values
my $total = $prices_col->sum();
Wrapper for ->func. Returns the sum of all the values in the column of the resultset. Use on varchar-like columns at your own risk.
sum_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->sum_rs();
Wrapper for ->func_rs for function SUM().
func
Arguments: $function
Return Value: $function_return_value
$rs = $schema->resultset("CD")->search({});
$length = $rs->get_column('title')->func('LENGTH');
Runs a query using the function on the column and returns the value. Produces the following SQL:
SELECT LENGTH( title ) FROM cd me
func_rs
Arguments: $function
Return Value: $resultset
Creates the resultset that "func()" uses to run its query.
throw_exception
See "throw_exception" in DBIx::Class::Schema for details.
AUTHORS
Luke Saunders <luke.saunders@gmail.com>
Jess Robinson
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-05-10 DBIx::Class::ResultSetColumn(3pm)