Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: BASH. Need to extract some numbers and take the average
Top Forums Shell Programming and Scripting BASH. Need to extract some numbers and take the average Post 302367193 by daptal on Sunday 1st of November 2009 10:38:19 PM
Old 11-01-2009
Code:
 cat abc.txt | perl -e 'while ( <>){ push @{$hash{$1}},$2 if (/^([a-z]+)\-(\d+)\..*/);} foreach $k(keys %hash){ my $total = 0; ($total+=$_) for @{$hash{$k}}; printf ("%s\t%d\t%.2f\n",$k,$total,$total/($#{$hash{$k}}+1));}'

Replace abc.txt with your file name

HTH,
PL
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract numbers from a word

Hi ppl, I am a bit lost on this...can some one assist. I know this can be down with awk or sed, but i cant get the exact syntax right. I need to only extract the numbers from a signle word ( eg abcd.123.xyz ) How can i extract 123 only ? Thanks (14 Replies)
Discussion started by: systemali
14 Replies

2. Shell Programming and Scripting

Extract numbers from text file work out average

Just wondering if someone could assist me with shell script I'm trying to write. I need to read the final column of a text file (shown below) and workout what the average number is. The text file will have a variable number of lines, I just want the script to pull out the values in the final field... (14 Replies)
Discussion started by: rich@ardz
14 Replies

3. UNIX for Dummies Questions & Answers

Taking a average of a column of numbers

Hey all, I am relatively poor at programming and unfortunately don't have time to read about programming at this current moment. I wanted to be able to run a simple command to read a column of numbers in a file and give me the average of those numbers. In addition if I could specify the... (2 Replies)
Discussion started by: Leonidsg
2 Replies

4. Shell Programming and Scripting

Number of elements, average value, min & max from a list of numbers using awk

Hi all, I have a list of numbers. I need an awk command to find out the numbers of elements (number of numbers, sort to speak), the average value the min and max value. Reading the list only once, with awk. Any ideas? Thanks! (5 Replies)
Discussion started by: black_fender
5 Replies

5. Shell Programming and Scripting

Bash script affect load average

Hello I have created next scritpt to do the next: chekp if host is alive. When the host down, launch telnet other equip to do checks. When execute the script the load average of the machines increase. For example: Before launch script top - 11:14:56 up 14 days, 18:06, 3 users, load... (3 Replies)
Discussion started by: capilla
3 Replies

6. Shell Programming and Scripting

How to take a Average of numbers from different files?

Hi, I have 3 to 4 different files, from that i need to take a Average of numbers from a particular column. here i have to take 4th column, that should present in diff. file. File 1: Col1 col2 col3 col4 1 11 sa 12.00 2 22 sb 134.59 3 33 sc 11.99 4 44 sd 12.44 Col1 col2 col3... (8 Replies)
Discussion started by: Shenbaga.d
8 Replies

7. Shell Programming and Scripting

awk or Bash: Cumulative average

For the data I would like to parse down and for each parsing I want a cumulative averaging, stored in an array that can be output. I.e. 546/NR = 546 (546+344)/NR=(546+344)/2 = etc. For N record input I want N values of the average (a block averaging effectively) Any... (3 Replies)
Discussion started by: chrisjorg
3 Replies

8. Shell Programming and Scripting

Extract numbers from file name-how to ?

Hello friends,I am new to Unix programming. how do I achieve the following in Unix shell script (I am running ksh on AIX) extract the number from name of file? My file format is like "LongFileName-1234.020614-221030.txt" now I want to extract value which is between (-) hyphen and (.) dot... (4 Replies)
Discussion started by: f150
4 Replies

9. Solaris

How is Load Average computed and what are better numbers?

Hello All, What is load average and how is it computed in Solaris 10? What are the different ranges for normal, warning and danger signs? Kindly clarify. Thank you, Sunil Kumar (3 Replies)
Discussion started by: msgforsunil
3 Replies

10. UNIX for Beginners Questions & Answers

Substr with % - extract numbers only

# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.5 (Maipo) I have this script that will monitor filesystems and send me e-amil alerts. #! /bin/ksh DIST_LIST=monitor@...com WORKDIR=/home/monitor WARNLEVEL=90 MAIL_SUBJ="filesystems monitor on "$(hostname) ... (3 Replies)
Discussion started by: danielshell
3 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 05:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy