Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: average of rows with same value in the first column
Top Forums Shell Programming and Scripting average of rows with same value in the first column Post 302693355 by elixir_sinari on Wednesday 29th of August 2012 05:22:02 AM
Old 08-29-2012
Quote:
Originally Posted by paolo.kunder
thanks but unfortunately is not working the script
Code:
cat testfile
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

awk '{
> c[$1]=1
> for(i=2;i<=NF;i++)
> {
>  total[$1,i]+=$i
>  count[$1,i]++
> }
> }
> END{
> for(i in c)
> {
>  printf "%s",i
>  for(j=2;count[i,j];j++)
>   printf "\t%.1f", (total[i,j]/count[i,j])
>  printf "\n"
> }
> }' testfile
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
E       455.0   4.0     2.0

What do you mean by "not working"?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Calculating the Number of Rows and Average

Hi All I like to know how can we calculate the number of rows and the average of the values present in the file. I will not know what will be the rowcount, which will be dynamic in nature of the file. eg. 29 33 48 30 28 (6 Replies)
Discussion started by: pk_eee
6 Replies

2. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows??

Hi friends I have 100 files in my directory. Each file look like this.. Temp1 Temp2 Temp3 MAS 1 2 3 MAS 4 5 6 MAS 7 8 9 Delhi 10 11 12 Delhi 13 14 15 Delhi 16 17 ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

3. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows?

Hi Friends, In continuation to my earlier post https://www.unix.com/shell-programming-scripting/99166-script-find-average-given-column-also-specified-number-rows.html I am extending my problem as follows. Input: Column1 Column2 MAS 1 MAS 4 ... (2 Replies)
Discussion started by: ks_reddy
2 Replies

4. Shell Programming and Scripting

Average calculation based on number of rows

Dear users, I need your support, I have a file like this: 272134.548 6680572.715 272134.545 6680572.711 272134.546 6680572.713 272134.548 6680572.706 272134.545 6680572.721 272134.543 6680572.710 272134.544 6680572.715 272134.543 6680572.705 272134.540 6680572.720 272134.544... (10 Replies)
Discussion started by: Gery
10 Replies

5. UNIX Desktop Questions & Answers

Calculate average for rows in a text file

Dear Gurus, I have tab-delimited text files with matrix containing values. The first column is a identifier and other columns have the corresponding values. I would like to calculate the average value (total number/number of entries) for all entries from 2nd column to the last column in row... (3 Replies)
Discussion started by: Unilearn
3 Replies

6. UNIX for Dummies Questions & Answers

Writing a script to take the average of two columns every 3 rows

I have a dataset with 120 columns. I would like to write a script, that takes the average of every two columns, starting from columns 2 and 3, and moving consecutively in frames of 3 columns, all the way until the last column. The first column in the output file would be the averages of columns... (1 Reply)
Discussion started by: evelibertine
1 Replies

7. Shell Programming and Scripting

Average values of duplicate rows

I have this file input.txt. I want to take average column-wise for the rows having duplicate gene names. Gene Sample_1 Sample_2 Sample_3 gene_A 2 4 5 gene_B 1 2 3 gene_A 0 5 7 gene_B 4 5 6 gene_A 11 12 13 gene_C 2 3 4 Desired output: gene_A 4.3 7 8.3 gene_B 2.5 3.5 4.5 gene_C 2 3 4... (6 Replies)
Discussion started by: Sanchari
6 Replies

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

9. Shell Programming and Scripting

Average across rows with a condition

Hi Friends, My input file Gene1 10 20 0 Gene2 5 0 15 Gene3 10 10 10 Gene4 5 0 0 If there is a zero for any gene in any column, I don't want that column to be considered which reduces the denominator value during average. Here is my output Gene1 10 20 0 10 Gene2 5 0 15 10 Gene3... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

10. Shell Programming and Scripting

Average select rows

I have no idea how to even get started with this script. I need to average field 3 for each of the unique identifiers found in field 1. However, I only want to average these rows when field 2 is equal to 1506 - 2000 (note that i replaced the values field 2 for security reasons, but the real... (6 Replies)
Discussion started by: ncwxpanther
6 Replies

LEARN ABOUT OSX

vm_stat

VM_STAT(1)						    BSD General Commands Manual 						VM_STAT(1)

NAME

     vm_stat -- show Mach virtual memory statistics

SYNOPSIS

     vm_stat [[-c count] interval]

DESCRIPTION

     vm_stat displays Mach virtual memory statistics.  If the optional interval is specified, then vm_stat will display the statistics every
     interval seconds.	In this case, each line of output displays the change in each statistic (an interval count of 1 displays the values per
     second).  However, the first line of output following each banner displays the system-wide totals for each statistic.  If a count is pro-
     vided, the command will terminate after count intervals.  The following values are displayed:

     Pages free
	     the total number of free pages in the system.

     Pages active
	     the total number of pages currently in use and pageable.

     Pages inactive
	     the total number of pages on the inactive list.

     Pages speculative
	     the total number of pages on the speculative list.

     Pages throttled
	     the total number of pages on the throttled list (not wired but not pageable).

     Pages wired down
	     the total number of pages wired down.  That is, pages that cannot be paged out.

     Pages purgeable
	     the total number of purgeable pages.

     Translation faults
	     the number of times the "vm_fault" routine has been called.

     Pages copy-on-write
	     the number of faults that caused a page to be copied (generally caused by copy-on-write faults).

     Pages zero filled
	     the total number of pages that have been zero-filled on demand.

     Pages reactivated
	     the total number of pages that have been moved from the inactive list to the active list (reactivated).

     Pages purged
	     the total number of pages that have been purged.

     File-backed pages
	     the total number of pages that are file-backed (non-swap)

     Anonymous pages
	     the total number of pages that are anonymous

     Uncompressed pages
	     the total number of pages (uncompressed) held within the compressor

     Pages used by VM compressor:
	     the number of pages used to store compressed VM pages.

     Pages decompressed
	     the total number of pages that have been decompressed by the VM compressor.

     Pages compressed
	     the total number of pages that have been compressed by the VM compressor.

     Pageins
	     the total number of requests for pages from a pager (such as the inode pager).

     Pageouts
	     the total number of pages that have been paged out.

     Swapins
	     the total number of compressed pages that have been swapped out to disk.

     Swapouts
	     the total number of compressed pages that have been swapped back in from disk.

     If interval is not specified, then vm_stat displays all accumulated statistics along with the page size.

Mac OS X							  August 13, 1997							  Mac OS X
All times are GMT -4. The time now is 05:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy