Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Average column
Dear Ygor, Thank yuo very much for your script. Especially the split("10 20 5",arr) option was very useful and gave me flexibility. However, is there an option to print out the average of the first column (time series) next to the average of the second column (dependent variable)... -
Average column
I have something like this: {if ($1 <= 20) (av +=$2/NR) if (($1 >= 21) && ($1 <= 50)) (av1 += &2/NR)} -
Average column
Hi awk users, Is there a simple awk script which allows me to average only parts of a column. Suppose I have 100 time points and I want for example to average the first ten time points and then the following twenty time points and then for example the subsequent 5 time points. In short, an awk... -
bootstrap resampling techniques
Hi all, Does anybody have any experience with writing awk scripts to perform bootstrap or jackknife procedures. Input will be appreciated. Thanks in advance -
Unstack columns
Ygor, Is there a possibility to enlarge the space between the columns. Now I have some columsn which overlap like this: 0.00E+00 1.5000E+01 6.0000 E+01 7.5000E+ 1.51E+01 2.55E+00 -1.13E+00 1.59E+01 5.17E+00 -5.23E-01 2.77E+01 1.68E+01 1.82E+01 Is there a solution to solve above problem? -
Dear users, 1 2 2 3 1 2 3
No it is not that simple. Let me give you an example of an unique data set. I will give you an overview of my data set. Currently I am doing a lot of data analysis in the field of medicines. Now suppose I have two patients (which are have identification number 1 and 2) and I have measured heart... -
Dear users, 1 2 2 3 1 2 3
Vlad, Not exactly what I want. I am doing a lot of data analysis. Most of the times those data sets consists of more than 100000 recors. FOr that purpose, excel can not be used. Now suppose I have the following data set: 1 2 2 4 3 5 4 2 5 4 1 5 2 6 3 3 4 5 5 3 The output should be as follow... -
Dear users, 1 2 2 3 1 2 3
Suppose I have the following data set with two columns. In which column one is the independend variable and column two the depend variable: 1 2 1 3 2 4 2 5 3 6 3 7 Now assume the following command. If column 1 equals 1 print colomn two etc. The output would be like this (column one see above... -
Dear users, 1 2 2 3 1 2 3
Dare Salem, I was more interested in a output like this: 2 3 4 4 2 7 4 2 2 Where colomsn one is not printed and when columsn equals 1 then columns 2 in printed in the first new colums and when column 1 equals 2 then column two is outputted in the new columns 2 etc. Thanks in advance -
Dear users, 1 2 2 3 1 2 3
Dear users, 1 2 2 3 1 2 3 4 5 4 1 2 3 4 5 2 2 7 How can I make subsets of colomns in awk. Like this: if column 1 equals 1 then output of column 2 should be printed in a new column and if column1 equals 2 columns 2 should be printed in another new column too and so on. Thanks in advance -
Manipulating columns in awk
Thanx guys. I used the && instead of || option. -
Manipulating columns in awk
Hi, I have just started to learn awk and I am alreadt facing a problem. I have to following columns: 0 0 0 22.32 15 0 0 16.2 75 0 0 18.48 140 0 0 17.94 180 0 0 16.72 240 0 0 18 300 0 0 16.8 360 0 0 16.79 420 0 0 19.58 480 0 0 19.53 How can I extract only rows for which column 1 equals 15 and...
