Daily averages...


 
Thread Tools Search this Thread
Contact Us Post Here to Contact Site Administrators and Moderators How to Post in the The UNIX and Linux Forums Daily averages...
# 1  
Old 05-08-2015
Daily averages...

I have date file like below..
Code:
1995   1       2      10      29      38.6706     -6.53823      41.9201
1995   1       2      10      29     -49.2477     -4.59733      17.2704
1995   1       2      10      29     -49.2369     -4.48045      8.61348
1995   1       3       8       48     -42.2643     -5.37043      28.9973
1995   1       3       8      48     -33.9019     -4.26548      90.1121

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:
Mod Comment fixed code tags


Moderator's Comments:
Mod Comment
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.

Last edited by Don Cragun; 05-08-2015 at 04:03 PM.. Reason: Added CODE tags
# 2  
Old 05-08-2015
Is this a homework assignment?

What have you tried so far?
This User Gave Thanks to Don Cragun For This Post:
# 3  
Old 05-10-2015
Moderator's Comments:
Mod Comment Until the question about this being a homework item is resolved; please do not post ways to solve this problem.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk- Pivot Table Averages

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

Calculating Total and Averages with awk Commands & Scripts

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: RedJohn
8 Replies

3. Solaris

Sparc Solaris 10 load averages

our server is running oracle database, it has: load average: 1.77, 1.76, 1.73 using only one cpu. is that too high? thanks. (4 Replies)
Discussion started by: orange47
4 Replies

4. Shell Programming and Scripting

Taking the averages of columns with deletion of some lines

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

SAR averages question

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

Create a list of load averages

`/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

Moving Averages SMA !

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

Calculate Averages !

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

Python Script to calculate averages

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)
Discussion started by: jl487
2 Replies
Login or Register to Ask a Question