Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calculate average from CSV file using PERL script
Top Forums Shell Programming and Scripting Calculate average from CSV file using PERL script Post 302552837 by sayachop on Monday 5th of September 2011 10:17:29 PM
Old 09-05-2011
Hi

Anybody can look what is the problem with this code.

perl -e "my $total=0; while (<>) { chomp; my $value = (split /([,:])/)[2]; $total=$value+$total; open FILE, ">", "ami.txt" or die $! }print FILE $total/$." fps.csv

I got perl -e The system cannot find the patch specified
 

10 More Discussions You Might Find Interesting

1. Programming

calculate average

I have a file which is 2 3 4 5 6 6 so i am writing program in C to calculate mean.. #include<stdio.h> #include<string.h> #include <math.h> double CALL mean(int n , double x) main (int argc, char **argv) { char Buf,SEQ; int i; double result = 0; FILE *fp; (3 Replies)
Discussion started by: cdfd123
3 Replies

2. Shell Programming and Scripting

Simple Script needed for Processing CSV file perl

I am new to perl, and need a script to pull a CSV file, strip out 2 leading columns, and 2 ending columns, and resave the file in a new location. The file is basic and has less than 10,000 records. Secondly, can I schedule perl scripts to run daily? Can someone provide the basic script to... (1 Reply)
Discussion started by: cobbjob
1 Replies

3. Shell Programming and Scripting

Calculate average of each of position of contents in a huge file

My input: >AAA_100 10 20 50 60 10 100 15 10 >AAA_100 20 20 50 60 20 100 15 10 >AAA_100 10 20 50 60 40 100 15 10 >AAA_100 40 20 50 60 10 100 15 10 . . . My Output 20 20 50 60 20 100 15 10 If I have a long list of file. I want to calculate average of each position inside the contents... (7 Replies)
Discussion started by: patrick87
7 Replies

4. Shell Programming and Scripting

Please do help: Perl Script to pull out rows from a CSV file

I have CSV file that contains data in the format as shown below: ABC, 67, 56, 67, 78, 89, 76, 55 PDR, 85, 83, 83, 72, 82, 89, 83 MPG, 86, 53, 54, 65, 23, 54, 75 .. .. .. .. I want to create a script that will pull out the rows from the above sheet and paste it into another CSV file.... (12 Replies)
Discussion started by: pankajusc
12 Replies

5. Shell Programming and Scripting

Calculate average time using a script

Hello, I'm hoping to get some help on calculating an average time from a list of times (hour:minute:second). Here's what my list looks like right now, it will grow (I can get the full date or change the formatting of this as well): 07:55:31 09:42:00 08:09:02 09:15:23 09:27:45 09:49:26... (4 Replies)
Discussion started by: jaredhanks
4 Replies

6. UNIX Desktop Questions & Answers

Calculate average for rows in a text file

Dear Gurus, I have tab-delimited text files with matrix containing values. The first column is a identifier and other columns have the corresponding values. I would like to calculate the average value (total number/number of entries) for all entries from 2nd column to the last column in row... (3 Replies)
Discussion started by: Unilearn
3 Replies

7. Shell Programming and Scripting

Perl script to modify csv file

Hi Friends, I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file table findhost= { {"xyz","abc"}, {"rxz","mmz"}, {"vrr","nnz"}, } default={"NONE"} My current perl script #!/usr/bin/env perl... (12 Replies)
Discussion started by: dbashyam
12 Replies

8. Shell Programming and Scripting

How to calculate average of two columns and copy into another file?

Hi, I need help with the awk command. I have a folder with aprox 500 files each one with two columns and I want to print in a new file, the average of column 1 and average of column 2 and the name of each file. Input files are: File-1: 100 99 20 99 50 99 50 99 File-2: 200 85... (3 Replies)
Discussion started by: Lokaps
3 Replies

9. Shell Programming and Scripting

How to calculate avg values of csv file using shell scripting .?

hi all i have a reporting work and i want it to be automated using shell scripting kindly let me know how can i make that possibe . eg data are :... (2 Replies)
Discussion started by: Avinash shaw
2 Replies

10. Shell Programming and Scripting

How to calculate average of csv using shell scripting?

Hi, I need to calculate the average of the following values using shell scripitng. Can anyone please suggest a solution? ... (10 Replies)
Discussion started by: karan pratap si
10 Replies

LEARN ABOUT DEBIAN

perl::critic::statistics

Perl::Critic::Statistics(3pm)				User Contributed Perl Documentation			     Perl::Critic::Statistics(3pm)

NAME

       Perl::Critic::Statistics - Compile stats on Perl::Critic violations.

DESCRIPTION

       This class accumulates statistics on Perl::Critic violations across one or more files.  NOTE: This class is experimental and subject to
       change.

INTERFACE SUPPORT

       This is considered to be a non-public class.  Its interface is subject to change without notice.

METHODS

       "new()"
	   Create a new instance of Perl::Critic::Statistics.  No arguments are supported at this time.

       " accumulate( $doc, @violations ) "
	   Accumulates statistics about the $doc and the @violations that were found.

       "modules()"
	   The number of chunks of code (usually files) that have been analyzed.

       "subs()"
	   The total number of subroutines analyzed by this Critic.

       "statements()"
	   The total number of statements analyzed by this Critic.

       "lines()"
	   The total number of lines of code analyzed by this Critic.

       "lines_of_blank()"
	   The total number of blank lines analyzed by this Critic. This includes only blank lines in code, not POD or data.

       "lines_of_comment()"
	   The total number of comment lines analyzed by this Critic. This includes only lines whose first non-whitespace character is "#".

       "lines_of_data()"
	   The total number of lines of data section analyzed by this Critic, not counting the "__END__" or "__DATA__" line. POD in a data section
	   is counted as POD, not data.

       "lines_of_perl()"
	   The total number of lines of Perl code analyzed by this Critic. Perl appearing in the data section is not counted.

       "lines_of_pod()"
	   The total number of lines of POD analyzed by this Critic. Pod occurring in a data section is counted as POD, not as data.

       "violations_by_severity()"
	   The number of violations of each severity found by this Critic as a reference to a hash keyed by severity.

       "violations_by_policy()"
	   The number of violations of each policy found by this Critic as a reference to a hash keyed by full policy name.

       "total_violations()"
	   The the total number of violations found by this Critic.

       "statements_other_than_subs()"
	   The total number of statements minus the number of subroutines.  Useful because a subroutine is considered a statement by PPI.

       "average_sub_mccabe()"
	   The average McCabe score of all scanned subroutines.

       "violations_per_file()"
	   The total violations divided by the number of modules.

       "violations_per_statement()"
	   The total violations divided by the number statements minus subroutines.

       "violations_per_line_of_code()"
	   The total violations divided by the lines of code.

AUTHOR

       Elliot Shank "<perl@galumph.com>"

COPYRIGHT

       Copyright (c) 2007-2011 Elliot Shank.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The full text of this license
       can be found in the LICENSE file included with this module.

perl v5.14.2							    2012-06-07					     Perl::Critic::Statistics(3pm)
All times are GMT -4. The time now is 04:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy