Sponsored Content
Top Forums Shell Programming and Scripting Calculate Average time of one column Post 302934449 by Newman on Saturday 7th of February 2015 06:53:52 AM
Old 02-07-2015
Calculate Average time of a column

Hello dears,

I have a log file with records like below and want to get a average of one column based on the search of one specific keyword.

Code:
2015-02-07      08:15:28        10.102.51.100   10.112.55.101   "kevin.c"       POST    /mainportal/webflow/customerprofile/smsEmailNotications/loadSubCategories.do?&msisdn=374355752&categoryCode=GSM_19   0.391   200     1740

suppose keyword is "loadSubCategories" and response time is on "column 8" (0.391)

This command gives a average of all response time of column 8 but not with the given keyword.

Code:
awk '{ total += $8; count++ } END { print total/count }' file.log001

please let me know how to write it.

Thanks.

Last edited by Newman; 02-07-2015 at 12:38 PM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

calculate average of column 2

Hi I have fakebook.csv as following: F1(current date) F2(popularity) F3(name of book) F4(release date of book) 2006-06-21,6860,"Harry Potter",2006-12-31 2006-06-22,,"Harry Potter",2006-12-31 2006-06-23,7120,"Harry Potter",2006-12-31 2006-06-24,,"Harry Potter",2006-12-31... (0 Replies)
Discussion started by: onthetopo
0 Replies

2. UNIX for Dummies Questions & Answers

Use awk to calculate average of column 3

Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies

3. 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

4. Shell Programming and Scripting

calculate the average of time series data using AWK

Hi, I have two time series data (below) merged into a file. t1 and t2 are in unit of second I want to calculate the average of V1 every second and count how many times "1" in V2 is occur within a second Input File: t1 V1 t2 V2 10.000000... (5 Replies)
Discussion started by: nica
5 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. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do... (10 Replies)
Discussion started by: worm
10 Replies

7. Shell Programming and Scripting

Calculate Average AWK

I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall: Example file: File 1 001 0.046 0.667267 001 0.047 0.672028 001 0.048 0.656025 001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies

8. Shell Programming and Scripting

Transpose timestamp based on column values and calculate time difference

Hello Expert, I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom INPUT File ======== 08/23/2012 12:36:09 JOB_5340 08/23/2012 12:36:14 JOB_5340 08/23/2012... (2 Replies)
Discussion started by: asnandhakumar
2 Replies

9. Shell Programming and Scripting

Calculate the average of a column based on the value of another column

Hi, I would like to calculate the average of column 'y' based on the value of column 'pos'. For example, here is file1 id pos y c 11 1 220 aa 11 4333 207 f 11 5333 112 ee 11 11116 305 e 11 11117 310 r 11 22228 781 gg 11 ... (2 Replies)
Discussion started by: jackken007
2 Replies

10. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
Discussion started by: ncwxpanther
1 Replies
acctcms(8)						      System Manager's Manual							acctcms(8)

NAME
acctcms - Produces command usage summaries from accounting records SYNOPSIS
acctcms [-acjnspot] file ... FLAGS
Displays output in ASCII summary format rather than the default binary format. The acctcms command sorts its output in descending order according to total K-core minutes. The unit K-core minutes is the amount of storage used (in kilobytes) multiplied by the amount of time the buffer was in use. The hog factor is the total CPU time divided by the total real time. The ASCII summary output format has the fol- lowing headings: The COMMAND NAME column specifies the name of the command. Because only object modules are reported by the accounting system, the sh command entry specifies the entry for all shell processes, regardless of their actual names. The NUMBER CMDS column speci- fies the total number of command invocations during the accounting period. The TOTAL KCOREMIN column combines the amount of memory used and the length of time used. Memory is specified in kilobyte blocks, and time is specified in minutes. The TOTAL CPU-MIN column specifies the total CPU time needed to process the command the number of times specified in the NUMBER CMDS column. The TOTAL REAL-MIN column speci- fies the total number of real-time minutes needed to process the command the number of times specified in the NUMBER CMDS column. The MEAN SIZE-K column specifies the average amount of memory in kilobytes used to process the command the number of times specified in the NUMBER CMDS column. The MEAN CPU-MIN column specifies the average amount of CPU time that the command used each time it was processed. The mean CPU minutes are obtained by dividing the total CPU minutes by the total number of commands. The HOG FACTOR column specifies the CPU time needed to process the command the number of times specified in the NUMBER CMDS column with respect to the time required to process all com- mands. This value shows the ratio of system availability to system utilization. The CHARS TRANSFD column specifies the total number of characters that were read or written when the command was processed the number of times specified in the NUMBER CMDS column. The BLOCKS READ column specifies the number of file system blocks (1 block is equivalent to 1 kilobyte) that were read when the command was processed the number of times specified in the NUMBER CMDS column. The number of blocks read may not correspond with the number of characters trans- ferred. Sorts in descending order according to total CPU time rather than total K-core minutes. Combines all commands called only once in the column specified by "***other" in the COMMAND NAME column. Sorts in descending order according to the number of times each command was called. Displays a command summary of nonprime-time commands. Displays a command summary of prime-time commands. Assumes that any file specified after this flag is in binary format. Processes all records as total accounting records. The default binary format splits each heading into prime-time and nonprime-time parts. DESCRIPTION
The acctcms command outputs data in a format called TOTAL COMMAND SUMMARY. This command reads each file specified, combines and sorts all records for identically named processes, and writes them in a binary format to the output device. Files are usually organized in the acct file format. When you specify the -o and -p flags together, the acctcms command produces a summary report that combines commands processed during both prime and nonprime time. All the output summaries specify total usage, except for the number of times run, CPU minutes, and real minutes, which are split into prime-time and nonprime-time minutes. EXAMPLES
To collect command accounting records from one or more source files into a command summary file called today and to maintain a running total summary of commands in a file called cmtotal, add the following lines to an accounting shell script: acctcms [source File(s) ....] > today cp total prev_tot acctcms -s today prev_tot > cmtotal acctcms -a -s cmtotal First, the acctcms command is used to redirect command records in File(s) that you specify to a file called today. Next, the old total com- mand summary file is renamed prev_tot. Then, the command summary records that are collected in the today and the prev_tot files are redi- rected to a new command summary file called cmtotal. These are all binary files. The last acctcms command outputs to the default output device the contents of the cmtotal file in the ASCII default command summary format previously described, so that the report may be dis- played. FILES
Specifies the command path. This is where prime time is set. Accounting header files that define formats for writing accounting files. RELATED INFORMATION
Commands: acct(8), runacct(8) Functions: acct(2) delim off acctcms(8)
All times are GMT -4. The time now is 01:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy