Hi Monks,

This post is regardig how do i use the if condtion statement within perl module. below is the data, the code attached is given by one of the monk, he helped me out.

I want to use a if conndtion like below if thee col6 is starting with 97517, it should pick in if condtion. in elsif condition it should pick 97516 containing records

 if ($col6 =~ /^\Q97517\E/ }
    elsif
 $col6 =~ /^\Q97516\E/))

[download]

Input csv 

col1,col2,col3,col4,col5,col6,col7,col8
1234,GP,20170715,0,V,97517,24,0.6
5678,Pack,20170715,0,V,97516,88,1.8
1234,GP,20170715,0,V,97517,22,0.6
5678,Pack,20170715,0,V,97517,183,3.9
1234,PRS,20170715,0,S,97517,261,5.4
5678,PRS,20170715,0,M,97517,36,0.9

[download]

code

#!/usr/bin/env perl

use strict;
use warnings;

use Data::Table;

# Load input data from csv file
my $dt = Data::Table::fromCSV('data.csv');

# Make a new table that only contains the relevant columns
my $st = $dt->subTable(undef, [ 'col2', 'col7', 'col8' ]);
 
# Group by 'col2', calculate sums for 'col7' and 'col8'
my $ot = $st->group(
    ['col2'], # column to group by
    ['col7', 'col8'], # Columns to perform calculation on
    [ \&sum, \&sum ], # Apply sum function to 'col7' and 'col8'
    ['sum_of_col7', 'sum_of_col8'] # Put the sums in these columns 
);
print $ot->csv, "\n";

sub sum {
  my @data = @_;
  my $sum = 0;
  foreach my $x (@data) {
    next unless $x;
    $sum += $x;
  }
  return $sum;
}

[download]

2017-08-16 Athanasius added code tags

In reply to if condition within module by gowthamvels

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.