Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: Add same columns of a file and then compare two file contents

by shmem (Chancellor)
on Dec 06, 2012 at 14:30 UTC ( #1007590=note: print w/replies, xml ) Need Help??

in reply to [untitled node, ID 1007488]

First, please go over your message and format it properly as per the List of Perl Monks Approved HTML Tags - just like I did quoting you:
I want output.txt file in following format
  1. To add and take average of second column entry(time stamp in hh:mm:ss) in file p10.txt (eg Retrieve_generic_assembly_(CP) is coming three times. So add all 3 entry and take average).
    Similarly do it for p20.txt.
  2. Write a new file output.txt that should have entry for all first column and avg entry of file p10.txt in second column and avg entry of p20.txt in third column and take difference of second and third column in fourth column.
I want output.txt format like this in 4 column
Subsection P10 P20 Delta(p10-p20) Retrieve_generic_assembly_(CP) 00:01:25 00:01:26 -00:00:01 Retrieve_assembly_1_(CP) 00:01:35 00:00:45 00:00:50 Retrieve_assembly_2_(CP) 00:01:42 00:02:46 -00:01:04

I am trying to achieve it through following code.

Then, please reformat your code with proper indenting, and insert comments telling yourself (and then us) at which place you are expecting to achieve what. For instance, I cannot see average calculus anywhere, not even an attempt thereof.

Hold on, you might get better answers, and nicer ones.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1007590]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2018-06-20 06:03 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (116 votes). Check out past polls.