Sponsored Content
Full Discussion: Get column average using ID
Top Forums Shell Programming and Scripting Get column average using ID Post 302852083 by jwbucha on Tuesday 10th of September 2013 12:32:17 PM
Old 09-10-2013
The output is showing the average BV for window 1, 2 etc.
 

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

3. UNIX for Dummies Questions & Answers

average of a column in a table

Hello, Is there a quick way to compute the average of a column data in a numerical tab delimeted file? Thanks, Gussi (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

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

5. Shell Programming and Scripting

average each column in a file

Hi, I tried to do this in excel but there is a limit to how many rows it can handle. All I need to do is average each column in a file and get the final value. My file looks something like this (obviously a lot larger): Joe HHR + 1 2 3 4 5 6 7 8 Jor HHR - 1 2 3 4 5 6 7 8 the output... (1 Reply)
Discussion started by: kylle345
1 Replies

6. Shell Programming and Scripting

average of rows with same value in the first column

Dear All, I have this file tab delimited A 1 12 22 B 3 34 33 C 55 9 32 A 12 81 71 D 11 1 66 E 455 4 2 B 89 4 3 I would like to make the average every column where the first column is the same, for example, A 6,5 46,5 46,5 B 46,0 19,0 18,0 C 55,0 9,0 32,0 D 11,0 1,0 66,0... (8 Replies)
Discussion started by: paolo.kunder
8 Replies

7. Shell Programming and Scripting

Average of columns with values of other column with same name

I have a lot of input files that have the following form: Sample Cq Sample Cq Sample Cq Sample Cq Sample Cq 1WBIN 23.45 1WBIN 23.45 1CVSIN 23.96 1CVSIN 23.14 S1 31.37 1WBIN 23.53 1WBIN 23.53 1CVSIN 23.81 1CVSIN 23.24 S1 31.49 1WBIN 24.55 1WBIN 24.55 1CVSIN 23.86 1CVSIN 23.24 S1 31.74 ... (3 Replies)
Discussion started by: isildur1234
3 Replies

8. Shell Programming and Scripting

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

9. Shell Programming and Scripting

Check first column - average second column based on a condition

Hi, My input file Gene1 1 Gene1 2 Gene1 3 Gene1 0 Gene2 0 Gene2 0 Gene2 4 Gene2 8 Gene3 9 Gene3 9 Gene4 0 Condition: If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging. ... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

10. Shell Programming and Scripting

Average each numeric column

Hi all, Does anyone know of an efficient unix script to average each numeric column of a multi-column tab delimited file (with header) with some character columns. Here is an example input file: CHR RS_ID ALLELE POP1 POP2 POP3 POP4 POP5 POP6 POP7 POP8... (7 Replies)
Discussion started by: Geneanalyst
7 Replies
WATCH-MULTIPLE-MIMDEFANGS(8)				      System Manager's Manual				      WATCH-MULTIPLE-MIMDEFANGS(8)

NAME
watch-multiple-mimdefangs.tcl - Keep an eye on a cluster of MIMEDefang machines SYNOPSIS
watch-multiple-mimdefangs.tcl [-archive] machine-1 machine-2 ... machine-N DESCRIPTION
watch-multiple-mimdefangs.tcl is a Tk script that graphically displays the status of mimedefang-multiplexor(8) on a cluster of machines. Note that Tcl/Tk 8.4 or higher is required to run watch-multiple-mimdefangs.tcl. If you supply the -archive command-line option, then watch-multiple-mimdefangs.tcl logs the output of md-mx-ctrl rawload for each machine. The output for machine_name is logged in: $HOME/.watch-multiple-mimedefangs/machine_name/data. PREREQUISITES
To use watch-multiple-mimdefangs.tcl to monitor a cluster of machines, you need the following prerequisites: o A UNIX-like machine with Tcl/Tk 8.4, the X window system and an SSH client. You also need "xterm" to use some of the features. o The ability to SSH as root to all of the machines you want to monitor. Ideally, you should be using the SSH agent so that you can SSH to the monitored machines as root without being prompted for a password or pass phrase. o The program md-mx-ctrl on root's path on all the machines you want to monitor. DISPLAY
For each machine specified on the command line, watch-multiple-mimdefangs.tcl creates a chart with five columns. The columns are: o A button with the name of the machine. Clicking the button pops up a menu that lets you take various actions, as described later. If all slaves on the machine are busy, the button turns yellow. o A label showing the number of busy slaves in the form "busy/total", where total is the total number of slaves. o A label showing the average number of messages per second over the last 10 seconds. o A label showing the average number of milliseconds per scan over the last 10 seconds. o A chart that graphs the average number of busy slaves, the average number of messages per second and the average scan time in mil- liseconds, all averaged over the last 10 seconds. MACHINE MENU
If you click on a machine name, a menu with three options pops up: SSH Open an xterm session and ssh as root to the machine. Busy Slaves Monitor the busy slaves on the machine. If you click on the process-ID of a slave, an xterm will open up and the command "strace -s 100 -t -p pid" will be executed on the remote machine. This is Linux-specific, but you can edit watch-multiple-mimdefangs.tcl to replace the command with your particular system's command for tracing system calls. Delete Remove the machine from the list of machines being monitored. ADDING A MACHINE
If you need to add a machine to the display, simply type the name of the machine in the "Add Machine:" box and press Enter. AUTHOR
watch-multiple-mimdefangs.tcl was written by David F. Skoll. SEE ALSO
mimedefang.pl(8), mimedefang-filter(5), mimedefang(8), mimedefang-protocol(7), md-mx-ctrl(8), watch-mimedefang(8) 4th Berkeley Distribution 12 January 2007 WATCH-MULTIPLE-MIMDEFANGS(8)
All times are GMT -4. The time now is 07:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy