|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk matrix problem
Post 302337306 by philstar on Thursday 23rd of July 2009 07:51:21 PM
07-23-2009
awk matrix problem
hi there
I'm very new in programing and i've started with awk.
I'm processing 200 data files and I need to do some precessing on them.
The files have 3 columns with N-lines
for each line a have on the first and second value is the same for all the files and only the third is variable. like this:
file1
0.003 0.004 4
0.005 -0.003 3
-0.023 0.423 2
...
file2
0.003 0.004 5
0.005 -0.003 4
-0.023 0.423 8
...
...
I need an output that can give me a matrix than the 1st and 2nd column are the same but the 3 must be a mean of all the values of all files
outputfile
0.003 0.004 mean
0.005 -0.003 mean
-0.023 0.423 mean
...
...
i have another problem cause' sometimes the value in the 3d column is not a number (NaN) and I can't count that one for the mean.
Can anyone give me some ideias
I'm very new in programing and i've started with awk.
I'm processing 200 data files and I need to do some precessing on them.
The files have 3 columns with N-lines
for each line a have on the first and second value is the same for all the files and only the third is variable. like this:
file1
0.003 0.004 4
0.005 -0.003 3
-0.023 0.423 2
...
file2
0.003 0.004 5
0.005 -0.003 4
-0.023 0.423 8
...
...
I need an output that can give me a matrix than the 1st and 2nd column are the same but the 3 must be a mean of all the values of all files
outputfile
0.003 0.004 mean
0.005 -0.003 mean
-0.023 0.423 mean
...
...
i have another problem cause' sometimes the value in the 3d column is not a number (NaN) and I can't count that one for the mean.
Can anyone give me some ideias
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have few days to complete my awk homework. But I'm stucked. i hope some1 will help me out.
I have to inverse n x n matrix, but I have problems with finding the determinant of the matrix.
I found the algoritm, how to find a determinant of n x n matrix:... (0 Replies)
Discussion started by: vesyyr
0 Replies
2. Shell Programming and Scripting
I need to inverse a matrix given in a file.
The problem is I'm stuck with writing determinant finding algoritm into code.
I found this algoritm about finding determinant of nxn matrix. This is what i need:
Matrices and Determinants
and here:
a11 a12 a13
a21 a22 a23
a31 a32 a33... (0 Replies)
Discussion started by: vesyyr
0 Replies
3. Shell Programming and Scripting
A C G T -
A 5 -4 -4 -4 -5
C -4 5 -4 -4 -5
G -4 -4 5 -4 -5
T -4 -4 -4 5 -5
- -5 -5 -5 -5 0
So lets say I have a matrix which looks something like (above). Its basically a scoring matrix. the numbers are... (2 Replies)
Discussion started by: aj05
2 Replies
4. Shell Programming and Scripting
Hi everyone
I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Discussion started by: stonemonkey
5 Replies
5. Shell Programming and Scripting
Hi there,
If anyone can help me sorting out this small task would be great. Given a matrix like the following:
100 3 3 3 3 3 ...
200 5 5 5 5 5 ...
400 1 1 1 1 1 ...
500 8 8 8 8 8 ...
900 0 0 0 0... (5 Replies)
Discussion started by: JRodrigoF
5 Replies
6. Shell Programming and Scripting
is it possible to count the number of keys based on state and cell and output it as a simple matrix.
Ex: cell1-state1 has 2 keys
cell3-state1 has 4 keys.
Note: Insert 0 if no data available.
input
key states cell
key1 state1 cell1
key1 state2 cell1
key1 ... (21 Replies)
Discussion started by: quincyjones
21 Replies
7. Shell Programming and Scripting
Hi,
Needs for statistics, doing converting
Here is a sample file
Input :
1|A|17,94
1|B|22,59
1|C|56,93
2|A|63,71
2|C|23,92
5|B|19,49
5|C|67,58
expecting something like that
Output :
1|A|17,94|B|22,59|C|56,93
2|A|63,71|B|0|C|23,92
5|A|0|B|19,49|C|67,58 (11 Replies)
Discussion started by: fastlane3000
11 Replies
8. Shell Programming and Scripting
Hi, every one. I have two files ,one is in matrix like this, one is a list with the same data as the matrix.
AB AE AC AD AA AF
SA 3 4 5 6 4 6
SC 5 7 2 8 4 3
SD 4 6 5 3 8 3
SE 45 ... (5 Replies)
Discussion started by: xshang
5 Replies
9. Shell Programming and Scripting
is it possible to order the following row clusters from ascending to descending. thanx in advance
input
1 2 4 0
1 2 4 0
3 3 3 3
1 5 1 0
1 5 1 0
6 0 0 0
5 1 1 1... (4 Replies)
Discussion started by: quincyjones
4 Replies
10. Shell Programming and Scripting
input
A1 B1 A2 B2
0 0 1 1
1 0 0 1
0 1 1 0
1 1 1 1
Output
label A1 B1 A2 B2
A1 2 1 1 2
B1 1 2 2 1
A2 1 2 3 2
B2 2 1 2 3
Ex:
The number of times that A1 and B1 row values are both 1 should be printed as output.
The last row of A1 and B1 in the input match by having 1 in both... (4 Replies)
Discussion started by: quincyjones
4 Replies
LEARN ABOUT MINIX
ascii
ASCII(7) Miscellaneous Information Manual ASCII(7) NAME
ascii - the ASCII character set. DESCRIPTION
The ASCII character set is as follows: |000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel| |010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si | |020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb| |030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us | |040 sp |041 ! |042 " |043 # |044 $ |045 % |046 & |047 ' | |050 ( |051 ) |052 * |053 + |054 , |055 - |056 . |057 / | |060 0 |061 1 |062 2 |063 3 |064 4 |065 5 |066 6 |067 7 | |070 8 |071 9 |072 : |073 ; |074 < |075 = |076 > |077 ? | |100 @ |101 A |102 B |103 C |104 D |105 E |106 F |107 G | |110 H |111 I |112 J |113 K |114 L |115 M |116 N |117 O | |120 P |121 Q |122 R |123 S |124 T |125 U |126 V |127 W | |130 X |131 Y |132 Z |133 [ |134 |135 ] |136 ^ |137 _ | |140 ` |141 a |142 b |143 c |144 d |145 e |146 f |147 g | |150 h |151 i |152 j |153 k |154 l |155 m |156 n |157 o | |160 p |161 q |162 r |163 s |164 t |165 u |166 v |167 w | |170 x |171 y |172 z |173 { |174 | |175 } |176 ~ |177 del| |00 nul|01 soh|02 stx|03 etx|04 eot|05 enq|06 ack|07 bel| |08 bs |09 ht |0A nl |0B vt |0C np |0D cr |0E so |0F si | |10 dle|11 dc1|12 dc2|13 dc3|14 dc4|15 nak|16 syn|17 etb| |18 can|19 em |1A sub|1B esc|1C fs |1D gs |1E rs |1F us | |20 sp |21 ! |22 " |23 # |24 $ |25 % |26 & |27 ' | |28 ( |29 ) |2A * |2B + |2C , |2D - |2E . |2F / | |30 0 |31 1 |32 2 |33 3 |34 4 |35 5 |36 6 |37 7 | |38 8 |39 9 |3A : |3B ; |3C < |3D = |3E > |3F ? | |40 @ |41 A |42 B |43 C |44 D |45 E |46 F |47 G | |48 H |49 I |4A J |4B K |4C L |4D M |4E N |4F O | |50 P |51 Q |52 R |53 S |54 T |55 U |56 V |57 W | |58 X |59 Y |5A Z |5B [ |5C |5D ] |5E ^ |5F _ | |60 ` |61 a |62 b |63 c |64 d |65 e |66 f |67 g | |68 h |69 i |6A j |6B k |6C l |6D m |6E n |6F o | |70 p |71 q |72 r |73 s |74 t |75 u |76 v |77 w | |78 x |79 y |7A z |7B { |7C | |7D } |7E ~ |7F del| ASCII(7)