Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Calculate average for repeated ID within a data
Top Forums Shell Programming and Scripting Calculate average for repeated ID within a data Post 302869441 by ENG_MOHD on Wednesday 30th of October 2013 10:51:04 AM
Old 10-30-2013
Yes it works. Thank you ...

One last modifications..How about if I want to calculate the first hit. for example instead of calculating the average, I want to filtered out the repeated occurrences. For example;

Code:
Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.09852 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.12751 seconds
Average end-to-end transmission delay 2.1 to 5.1 is 1.15817 seconds

The output would be only the first hit;
Code:
Average end-to-end transmission delay 2.1 to 5.1 is 1.06953 seconds

and ignore the rest repeated occurrences.
 

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

calculate average of multiple line data

I have a question as below and i need to write a shell or perl script for this query:My Input file looks like below RNo Marks 12 50 15 70 18 80 12 40 13 55 18 88 13 75... (4 Replies)
Discussion started by: smacherla
4 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

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... (6 Replies)
Discussion started by: alex2005
6 Replies

7. UNIX for Dummies Questions & Answers

Average for repeated elements in a column

I have a file that looks like this 452 025_E3 8 025_E3 82 025_F5 135 025_F5 5 025_F5 23 025_G2 38 025_G2 71 025_G2 9 026_A12 81 026_A12 10 026_A12 some of the elements in column2 are repeated. I want an output file that will extract the... (1 Reply)
Discussion started by: FelipeAd
1 Replies

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

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... (8 Replies)
Discussion started by: jiam912
8 Replies

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... (1 Reply)
Discussion started by: invinzin21
1 Replies

LEARN ABOUT DEBIAN

transmission-remote-cli

transmission-remote-cli(1)				      transmission-remote-cli					transmission-remote-cli(1)

NAME

       transmission-remote-cli - a console client for the Transmission BitTorrent client

SYNOPSIS

       transmission-remote-cli [options] [filename-or-URL]

DESCRIPTION

       transmission-remote-cli is a curses interface for the daemon of the BitTorrent client Transmission.

OPTIONS

       --version
	      Show version number and exit

       -h --help
	      Show usage information and a list of options

       -c CONNECTION --connect=CONNECTION
	      Point to the server. CONNECTION must match the following pattern:
	      [username:password@]host[:port][path]
	      Default: localhost:9091

       -s --ssl
	      Use SSL to connect to the server.
	      Default: don't use SSL

       --create-config
	      Create configuration file with default values.
	      NOTE:  A	config	file won't be created unless you provide this option at least once. After that, it is rewritten whenever transmis-
	      sion-remote-cli exits.

       -f CONFIGFILE --config=CONFIGFILE
	      Set path to configuration file.
	      Default: ~/.config/transmission-remote-cli/settings.cfg

       -n --netrc
	      Get authentication info from ~/.netrc.

       -- OPTIONS
	      Use the known server connection to pass OPTIONS on to transmission-remote.

FILES

       transmission-remote-cli overwrites the configuration file on exit. Keep that in mind if you edit it manually.

SEE ALSO

       transmission-create(1),	transmission-daemon(1),  transmission-edit(1),	transmission-gtk(1),  transmission-qt(1),  transmission-remote(1),
       transmission-show(1).

								  April 22, 2012					transmission-remote-cli(1)
All times are GMT -4. The time now is 10:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy