Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk script to count percentage from log file
Top Forums Shell Programming and Scripting awk script to count percentage from log file Post 302314274 by ghostdog74 on Friday 8th of May 2009 01:09:14 AM
Old 05-08-2009
if you have Python, here's an alternative solution
Code:
#!/usr/bin/env python
from __future__ import division
d={}
f=open("file")
header=f.readline()
for line in f:        
    line=line.strip().split()
    d.setdefault(line[0],[])
    d[line[0]].append(sum(map(int,line[2:6])))
for i,j in d.iteritems():
    try:
        print i,100*j[1]/j[0]        
    except Exception,e: 
        print e

output:
Code:
# ./test.py
30033 99.2307692308
30032 99.3808049536
30031 99.8797354179
30011 100.347222222
30013 100.0
30012 99.7777777778
30051 99.7604790419
30053 99.7389033943
30052 99.6088657106
30101 98.8571428571
30061 99.8313659359
30062 99.9547920434
30063 99.605781866
30082 float division
30083 float division
30081 99.7353797301
30042 99.5249406176
30043 99.1323210412
30041 100.0
30021 99.8188405797
30022 100.355871886
30023 100.0
30103 101.231527094
30073 99.3121693122
30072 100.0
30071 98.6825595985
30091 99.8564249821
30102 99.4520547945
30093 99.8550724638
30092 99.9460334593

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk percentage

how would you calculate percentage by per line? Given a column of 16 lines, grab each line and divide it by the sum of the entire column and multiply by 100? thanks ... (8 Replies)
Discussion started by: rockiefx
8 Replies

2. Shell Programming and Scripting

Need an AWK script to calculate the percentage

Hi I need a awk script to calculate percentage. I have to pass the pararmeters in to the awk script and calculate the percentage. Sum = 50 passed = 43 failed = 7 I need to pass these value in to the awk script and calculate the percentage. Please advice me. (8 Replies)
Discussion started by: bobprabhu
8 Replies

3. Shell Programming and Scripting

awk script to count characters in file 1 in file 2

I need a scripting AWK to compare 2 files. file 1 and 2 are list of keywords 1 is a b c d 2 is aa aaa b bb ccc d I want the AWK script to give us the number of times every keyword in file 1 occurs in file 2. output should be a 2 (7 Replies)
Discussion started by: anhtt
7 Replies

4. Shell Programming and Scripting

Need an awk script to calculate the percentage of value field and replace

Need an awk script to calculate the percentage of value field and replace I have a input file called file.txt with the following content: john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2 andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1 in fourth filed of input file, calulate percentage of each... (1 Reply)
Discussion started by: veeruasu
1 Replies

5. UNIX for Dummies Questions & Answers

Need an awk script to calculate the percentage of value field and replace

I have a input file called file.txt with the following content: john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2 andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1 in fourth filed of input file, calulate percentage of each sub filed seperated by ; semicolon and replace value with percentage . i... (11 Replies)
Discussion started by: veeruasu
11 Replies

6. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

7. Shell Programming and Scripting

Count percentage of string

Hi, Am trying to count the number of occurrences and then as a percentage from a log to troubleshoot errors, can someone help please grep -o 'HTTP/1\.1\" 404 3..' access_log | wc -l 6 (5 Replies)
Discussion started by: dmccabe
5 Replies

8. Shell Programming and Scripting

Help with awk percentage calculation from a file

i have a file say test with the below mentioned details Folder Name Total space Space used /test/test1 500.1GB 112.0 GB /test/test2 3.2 TB 5TB /test/test3 3TB 100GB i need to calculate percentage of each row based on total space and space used and copy... (9 Replies)
Discussion started by: venkitesh
9 Replies

9. Shell Programming and Scripting

awk script to detect specific string in a log file and count it

Hello, can someone guide me on this? I don't know what is the best approach, (awk script, shell script) I am using RedHat Linux version 6.5. There is a third party application deployed on that server. This app by default generates 5 log files and each file is 20MB. These log rollover... (5 Replies)
Discussion started by: ktisbest
5 Replies

10. HP-UX

Shell /awk script for Percentage

having two columns, A and B.. i need to add another column C in a file and calculate the percentage based on the column A and B. (COLUMN B/ COLUMN A *100) . "|" is delimiter separating the A and B.. need C column with the percentage value. Thanks for your help 100|50 |50% ... (6 Replies)
Discussion started by: kartikirans
6 Replies

LEARN ABOUT DEBIAN

perlio::via::symlink

symlink(3pm)						User Contributed Perl Documentation					      symlink(3pm)

NAME

       PerlIO::via::symlink - PerlIO layers for create symlinks

SYNOPSIS

	open $fh, '>:via(symlink)', $fname;
	print $fh "link foobar";
	close $fh;

DESCRIPTION

       The PerlIO layer "symlink" allows you to create a symbolic link by writing to the file handle.

       You need to write C"link $name" to the file handle. If the format does not match, "close" will fail with EINVAL.

TEST COVERAGE

	----------------------------------- ------ ------ ------ ------ ------ ------
	File				      stmt branch   cond    sub   time	total
	----------------------------------- ------ ------ ------ ------ ------ ------
	blib/lib/PerlIO/via/symlink.pm	     100.0  100.0    n/a  100.0  100.0	100.0
	Total				     100.0  100.0    n/a  100.0  100.0	100.0
	----------------------------------- ------ ------ ------ ------ ------ ------

AUTHORS

       Chia-liang Kao <clkao@clkao.org>

COPYRIGHT

       Copyright 2004-2005 by Chia-liang Kao <clkao@clkao.org>.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       See <http://www.perl.com/perl/misc/Artistic.html>

perl v5.8.8							    2005-04-21							      symlink(3pm)
All times are GMT -4. The time now is 05:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy