where columns are year, month, day, hour, minute log_val, lat_val, area. I want to find the daily average of area and the output should be like

Code:

1995 1 2 10 29 22.601

and so on. how to do using awk or some other linux commands ?

Moderator's Comments:

fixed code tags

Moderator's Comments:

Please wrap all code, files, input & output/errors in CODE tags as described in the forum rules.
It makes it far easier to read and preserves multiple spaces where that is important to fixed width output.

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Hi everyone,
Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages.
For example, suppose you have the following table with various individuals and their scores in round1 and round2:
SAMPLE SCORE1 SCORE2
British ... (6 Replies)

Discussion started by: Geneanalyst

6 Replies

2. Homework & Coursework Questions

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write an awk script(company.awk) for the workers file to find the number of workers of each departman, total... (8 Replies)

Discussion started by: orange47

4. Shell Programming and Scripting

Hi,
I am in stage of post processing some of my results. I wanted to plot the data against the three axis x,y,z. The data file is quite complicated and i have to take the average of x, y,z over different steps of my test. A typical file look like below:
Time taken:4s
No.of series : 3... (6 Replies)

Discussion started by: begin_shell

6 Replies

5. Solaris

Hi all
Bit of a silly question, but if I run sar to get the CPU stats (something like this):
sar -u 300 1
The figures that are returned, is it in the above case the average over 300 seconds, or does it just wait for 300 seconds before obtaining the readings? (1 Reply)

Discussion started by: kinetik

1 Replies

6. Shell Programming and Scripting

`/proc/loadavg` give me three indicators of how much work
the system has done during the last 1, 5 & 15 minutes.
How can i get a list of load averages
that each averaged over the last minute for 10 minutes? (2 Replies)

Discussion started by: navidlog

2 Replies

7. Shell Programming and Scripting

Hello,
I am trying to create a awk script to calculate the simple moving average of two fields but I got only the result of the first field.
Could you please help me to fix this awk shell script
awk -F, -v points=5 '
{
a = $2;
b = $3;
if(NR>=points) {
total_a = 0;
total_b... (1 Reply)

Discussion started by: csierra

1 Replies

8. Shell Programming and Scripting

Hi,
I have a file with more than 2,000 rows like this:
05/26/2011,1200,1500
I would like to create a awk shell script that calculate the price average of the second and third field each 5,10 and 20 rows or ask me for the values, starting at first row.
Finally compare the average value... (1 Reply)

Discussion started by: csierra

1 Replies

9. Programming

I'm fairly new to python so bare with me. I'm trying to write a script that would calculate my class average from exams. The script will look at a text file formatted like this:
Calculus 95 90 92
Physics 80 85 92
History 90 82 83 95
The output should look like this:
Calculus 92.33... (2 Replies)