## calculate average of column 2

calculate average of column 2
# 1
07-06-2007
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
2006-06-25,7498,"Harry Potter",2006-12-31
2006-06-26,7500,"Harry Potter",2006-12-31
2006-06-27,7750,"Harry Potter",2006-12-31
2006-06-28,7860,"Harry Potter",2006-12-31
2006-06-29,,"Harry Potter",2006-12-31
2006-06-30,7860,"Harry Potter",2006-12-31
2006-07-01,1760,"Bible",2007-03-03
2006-07-02,2755,"Bible",2007-03-03
2006-07-03,3760,"Bible",2007-03-03
2006-07-04,,"Bible",2007-03-03
2006-07-05,5788,"Bible",2007-03-03
2006-07-06,6799,"Bible",2007-03-03
...............................

I want to add a new column in each line that is Field 5 (average popularity[over a sample of three days] 6 months before release date)

So for the harry potter book, the release date is 2006-12-31, I need to find the average value of field 2 over the following date points: 2006-06-30,2006-06-28 and 2006-06-27. (This problem is complicated by the fact that the popularity of 2006-06-29 is unavailable and left as blank in the csv, so 2006-06-29 is skipped in the calculation of average).

My supervisor gave me a short timespan to solve this.I've already got the datecalc script found in FAQ but haven't found its use in my context yet. Can someone please help me? Thanks a million!
 onthetopo View Public Profile for onthetopo Find all posts by onthetopo

Test Your Knowledge in Computers #633
Difficulty: Medium
The touch and gesture features of the iPhone are based on technology originally developed by FingerWorks.
True or False?

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

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

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

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

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

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

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

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

## 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;

## 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?
```bookman(1)																bookman(1)

NAME
bookman - Generate a book from man pages

SYNOPSIS
bookman [-pPxn] [-o outfile] [-a author] [-d date] [-r release]
[-t title] [-v volume] [-c coverfile] [manfile]

DESCRIPTION
bookman	compiles  a  set  of  man  pages files specified by manfile arguments, or if no manfile is given, filenames are read from standard
input.

OPTIONS
-p     PDF output format.

-P     Postscript output format.

-x     X11 previewing, using gxditview(1).

-n     no format, output is direct gtroff intermediate format.

-o outfile
Output in file outfile. Default is standard output.

-a author
Set the author, on the cover page.

-d date
Set the date on the cover page.

-r release
Set the book name and release on the cover page.

-t title
Set the title on the cover page.

-v volume
Specify the name of the volume.

-c coverfile
Uses the file coverfile to generate the cover page, i.e. all pages preceding the table of content. coverfile must be in  groff_ms(7)
format.

EXAMPLE
To build a reference manual from section 2 man, do:

\$ cd /usr/man/man2
\$ bookman -p -t 'Unix Reference Manual' * >book.pdf