Sponsored Content
Top Forums Shell Programming and Scripting Average of a columns from three files Post 303002886 by nans on Monday 4th of September 2017 09:34:30 AM
Old 09-04-2017
Both the solutions worked perfect! Thank you
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Taking the average of two columns and printing it on a new column

Hi, I have a space delimited text file that looks like the following: Aa 100 200 Bb 300 100 Cc X 500 Dd 600 X Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore... (11 Replies)
Discussion started by: evelibertine
11 Replies

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

3. Shell Programming and Scripting

How to calculate average of two columns and copy into another file?

Hi, I need help with the awk command. I have a folder with aprox 500 files each one with two columns and I want to print in a new file, the average of column 1 and average of column 2 and the name of each file. Input files are: File-1: 100 99 20 99 50 99 50 99 File-2: 200 85... (3 Replies)
Discussion started by: Lokaps
3 Replies

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

5. Shell Programming and Scripting

Average across multiple columns group by

Hi experts, I want to group by average, for multiple columns starting column $7 until NF, group by ($1-$5), please help For just 7th column, I can do awk ' NR>1{ arr += $7 count += 1 } END{ for (a in arr) { print a, arr/count ... (10 Replies)
Discussion started by: ritakadm
10 Replies

6. Shell Programming and Scripting

Match first two columns and calculate percent of average in third column

I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results. awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
Discussion started by: ncwxpanther
1 Replies

7. Shell Programming and Scripting

Match first two columns and average third from multiple files

I have the following format of input from multiple files File 1 24.01 -81.01 1.0 24.02 -81.02 5.0 24.03 -81.03 0.0 File 2 24.01 -81.01 2.0 24.02 -81.02 -5.0 24.03 -81.03 10.0 I need to scan through the files and when the first 2 columns match I... (18 Replies)
Discussion started by: ncwxpanther
18 Replies

8. Emergency UNIX and Linux Support

Average columns based on header name

Hi Friends, I have files with columns like this. This sample input below is partial. Please check below for main file link. Each file will have only two rows. ... (8 Replies)
Discussion started by: jacobs.smith
8 Replies

9. Shell Programming and Scripting

Average across multiple columns - awk

Hi forum members, I'm trying to get an average of multiple columns in a csv file using awk. A small example of my input data is as follows: cu,u3o8,au,ag -9,20,-9,3.6 0.005,30,-9,-9 0.005,50,10,3.44 0.021,-9,8,3.35 The following code seems to do most of what I want gawk -F","... (6 Replies)
Discussion started by: theflamingmoe
6 Replies

10. UNIX for Beginners Questions & Answers

Average of columns

I have files that have the following columns chr pos ref alt sample 1 sample 2 sample 3 chr2 179644035 G A 1,107 0,1 58,67 chr7 151945167 G T 142,101 100,200 500,700 chr13 31789169 CTT CT,C 6,37,8 0,0,0 15,46,89 chr22 ... (3 Replies)
Discussion started by: nans
3 Replies
DDS(6)								   Games Manual 							    DDS(6)

NAME
dds - double dummy solver frontend SYNOPSIS
dds file [ options ] DESCRIPTION
This program is a command line interface for Bo Haglund's Double Dummy Solver (DDS). It has four useful stand-alone options: 1. Option -playdd, to play any deal double dummy. 2. Option -giblib. For any deal, to get maximum trick values for all possible contracts and leaders (these are the 20 trick values as for giblib). 3. Option -tricks. For specified deal, to get maximum trick values for all possible contracts and leaders (these are the 20 trick val- ues as for giblib). 4. Option -gen. This is to generate deals, without or with up to 20 possible trick values. OPTIONS
file path for 'giblib' input file Optional arguments [options] are one or more of: -v verbose where applicable -target=d -1-13 (default -1). Number of tricks to be won by the side to play, -1 means that the program shall find the maximum number. For equivalent cards only the highest is returned. -sol=d solution 1/2/3 (default 3). How many card solutions SolveBoard returns: target=1-13, solutions=1: Returns only one of the cards. Its returned score is the same as target when target or higher tricks can be won. Otherwise, score -1 is returned if target cannot be reached, or score 0 if no tricks can be won. target=-1, solutions=1: Returns only one of the optimum cards and its score. target=0, solutions=1: Returns only one of the cards legal to play with score set to 0. target=1-13, solutions=2: Return all cards meeting target. Their returned scores are the same as target when target or higher tricks can be won. Otherwise, only one card is returned with score -1 if target cannot be reached, or score 0 for all cards legal to play if no tricks can be won. target=-1, solutions=2: Return all optimum cards with their scores. target=0, solutions=2: Return all cards legal to play with scores set to 0. target irrelevant, solutions=3: Return all cards that can be legally played with their scores in descending order. -mode=d 0/1 (default 1). DLL mode of operation. This mode does not affect the DLL if there are multiple choices for cards to play. If there is just one card to play, or multiple cards that are all equivalent, this mode determines whether or not the DLL will search to find the score. mode=0: Do not search to find the score if the hand to play has only one card, including its equivalents, to play. Score is set to -2 for this card, indicating that there are no alternative cards. This mode is very fast. mode=1: Always search to find the score. Even when the hand to play has only one card, with possible equivalents, to play. -trumps=t s/h/d/c/n, this overrides the file (default=n) -leader=l w/n/e/s, this overrides the file (default=w) but used only when no cards have been played -deal=d 1/2/... deal number in giblib file. Only one of -deal or -name should be specified. -name=str deal with 'name=str' in giblib file. Only one of -deal or -name should be specified. -playdd play deal choosing between DDS alternatives -timeall time all deals in file for sol=1/2/3, print stats -timeg=xcn x - hex digit, total tricks by n-s c - contract s/h/d/c/n n - number of deals time the first n deals in the giblib file, having total tricks x at contract c, for target=-1 sol=1 mode=1 and for the speci- fied/default leader, each deal is validated. -giblib=d1-d2[-all] validate all deals from d1 to d2 in giblib file for target=-1 sol=1 mode=1. 1. if -all is given, this is done for all of the 20 trick values even if some of them are '-'. 2. if -all is not given, this is done only for those trick values which are not '-'. -tricks like -giblib, but for single deal specified by -name=str -deal=d or option Generate deals: -gen=n (required) n=number of deals to generate. output is written to a file (see below) -genseed=s (default 0) seed for random generator -gencards=c (default=52) number of cards generated per deal, must be multiple of 4 -gentricks=t 0,1,...,20 (default 1), number of tricks values to set randomly Generate output is written to a file: gen-genseed-ndeal-gencards-gentricks.txt NOTES
The program was named ddd by its author. As there is already some other ddd package in Debian (the gdb frontend) it was renamed to dds, the name of the library used. SEE ALSO
dealer(6), deal(6). DDS(6)
All times are GMT -4. The time now is 05:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy