Calculate average of rows between two specific patterns Post: 302820335

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

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?

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;

4. Shell Programming and Scripting

AWK novice - calculate the average

Hi, I have the following data in a file for example: P1 XXXXXXX.1 YYYYYYY.1 ZZZ.1 P1 XXXXXXX.2 YYYYYYY.2 ZZZ.2 P1 XXXXXXX.3 YYYYYYY.3 ZZZ.3 P1 XXXXXXX.4 YYYYYYY.4 ZZZ.4 P1 XXXXXXX.5 YYYYYYY.5 ZZZ.5 P1 XXXXXXX.6 YYYYYYY.6 ZZZ.6 P1 XXXXXXX.7 YYYYYYY.7 ZZZ.7 P1 XXXXXXX.8 YYYYYYY.8 ZZZ.8 P2...

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

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

7. Shell Programming and Scripting

Calculate average for repeated ID within a data

I have an awk script that gives the following output: Average end-to-end transmission delay 2.7 to 5.7 is 0.635392 seconds Average end-to-end transmission delay 2.1 to 5.1 is 0.66272 seconds Average end-to-end transmission delay 2.1 to 5.1 is 0.691712 seconds Average end-to-end transmission...

8. Shell Programming and Scripting

Calculate Average time of one 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. 2015-02-07 08:15:28 10.102.51.100 10.112.55.101 "kevin.c" POST ...

9. Shell Programming and Scripting

Calculate average, azimut and distance

Gents, Please i will to get the distance and azimut from 2 coordinates: Usig excel formula i get the correct values, but i will like to do it using awk. Example A 35089.0 50345.016 9 75 1 2101774 77 70 79 483911.6 2380106.9 137.4 1 1 6 1 A 35089.0 50345.01620 75...

10. Shell Programming and Scripting

Calculate the average per block.

My old school way is a one liner. And will search for average from SAR, to get the data receive rate. But, I dont think it is practical or accurate,. Because it calculates to off peak hours. I am planning to change it. My cron runs every 30 mins. When my cron runs, and my time is 14:47pm,, it will...

LEARN ABOUT OPENSOLARIS

holidays

holidays(4)							   File Formats 						       holidays(4)

NAME

       holidays - prime/nonprime table for the accounting system

SYNOPSIS

       /etc/acct/holidays

DESCRIPTION

       The /etc/acct/holidays file specifies prime time hours and holidays. Holidays and weekends are considered non-prime time hours.

       /etc/acct/holidays is used by the accounting system.

       All lines beginning with an * are comments.

       The  /etc/acct/holidays	file consists of two sections. The first non-comment line defines the current year and the start time of prime and
       non-prime time hours, in the form of:

	 current_year prime_start non_prime_start

       Specify prime_start and non_prime_start times in the range of 0000 to 2400.

       The remaining non-comment lines define the holidays in the form of:

	 month/day company_holiday

       Of these two fields, only the month/day is actually used by the accounting system programs.

       The /etc/acct/holidays file must be updated every year.

EXAMPLES

       Example 1 An Example of the /etc/acct/holidays File

       The following is an example of the /etc/acct/holidays file:

	 * Prime/Nonprime Table for the accounting system
	 *
	 * Curr     Prime     Non-Prime
	 * Year     Start     Start
	 *
	   1991     0830     1800
	 *
	 * only the first column (month/day) is significant.
	 *
	 * month/day	Company Holiday
	 *
	   1/1		New Years Day
	   5/30 	Memorial Day
	   7/4		Indep. Day
	   9/5		Labor Day
	   11/24	Thanksgiving Day
	   11/25	day after Thanksgiving
	   12/25	Christmas
	   12/26	day after Christmas

SEE ALSO

       acct(1M)

SunOS 5.11							    18 Aug 2008 						       holidays(4)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

calculate average of column 2

Discussion started by: onthetopo

2. UNIX for Dummies Questions & Answers

Use awk to calculate average of column 3

Discussion started by: grossgermany

3. Programming

calculate average

Discussion started by: cdfd123

4. Shell Programming and Scripting

AWK novice - calculate the average

Discussion started by: alex2005