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
uptime(1)						      General Commands Manual							 uptime(1)

NAME
uptime, w - show how long system has been up and/or who is logged in and what they are doing SYNOPSIS
[user] [pset_list]] [user] [pset_list]] DESCRIPTION
prints the current time, the length of time the system has been up, the number of users logged on to the system, and the average number of jobs in the run queue over the last 1, 5, and 15 minutes for the active processors. is linked to and prints the same output as displaying a summary of the current activity on the system. Options and recognize the following options: Print the current time, the length of time the system has been up, and the number of users logged on to the system in the first line of the output. The average number of jobs in the core over the last 1, 5, and 15 minutes for the active processors is also printed. When used with the option, the load averages for the processor sets (psets) are calculated on a core basis. Suppress the first line and the heading line. This option should not be used with the option. This option assumes the use of the option to Use long output. This option assumes the use of the option to Print the current time, the length of time the system has been up, and the number of users logged on to the system in the first line of the output. The load averages over the last 1, 5, and 15 minutes for the processor sets (psets) given in the command line, pset_list, are displayed in the subsequent lines. If no arguments are given, the load averages are displayed for all the psets in the system. If pset id of an empty pset is given in the command line, a corresponding message will be displayed. If the kernel does not have the pset capability, gives an error. The option cannot be used along with other options except Use the short form of output for displaying terminal information. The terminal name is abbreviated, and the login time and CPU times are suppressed. Print only the first line describing the overall state of the system. This is the default for the command. Print a summary of the current activity on the system for each user. This is the default for the command. EXAMPLES
The command: produces text resembling the following: depending upon the current status of the system. The command: gives the load average of all the psets in the system. If 0, 94, 95, and 97 are existing psets in the system, the output will look like the following: The command: gives output which looks like the following if 94 and 95 are valid pset ids: The command: gives the load average of the system, producing output resembling the following: The command: gives the load average of all the psets in the system. If 0 and 1 are psets in the system, the output will look like the following: AUTHOR
was developed by the University of California, Berkeley and HP. SEE ALSO
mpctl(2), pset_ctl(2). uptime(1)
All times are GMT -4. The time now is 07:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy