sum numbers of multiple files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sum numbers of multiple files
# 8  
Old 08-03-2012
There are 146 lines below the header. Sorry its not clear.
The lines from the counts files are created from an other file which contains 6,000,000 lines.
This file contains 6,000,000 sequences of length 146 with numbers 1,2,3, and 4.
I want to count the occurrences of all combinations of 1,2,3 and 4. So for example: 1 in position 1 in all sequences, and 3 in position 5 in all sequences.
So those counts are 146 x 146 matrices with counts of occurrences of all those possible combinations.

-------A=1,B=1-------
occurrences of 1 in one position and 1 in an other position
146x146 matrix

Hope its clear now...
# 9  
Old 08-03-2012
I'm even less sure how. So the input is a 147x147 matrix, or I'm supposed to assemble a 147x147 matrix out of lines?

If you could just show more of your input and output instead of hoping we'll make correct assumptions about stuff you never posted, then show the work you did to generate one from the other, that would help a lot more than describing something we can't see over and over. Shrink the example to something you can show in its entirety, like a 3x3 instead of a 147x147. Ideally the same code could apply to either.

Last edited by Corona688; 08-03-2012 at 02:23 PM..
# 10  
Old 08-03-2012
Quote:
Originally Posted by linseyr
There are 146 lines below the header. Sorry its not clear.
The lines from the counts files are created from an other file which contains 6,000,000 lines.
This file contains 6,000,000 sequences of length 146 with numbers 1,2,3, and 4.
I want to count the occurrences of all combinations of 1,2,3 and 4. So for example: 1 in position 1 in all sequences, and 3 in position 5 in all sequences.
So those counts are 146 x 146 matrices with counts of occurrences of all those possible combinations.

-------A=1,B=1-------
occurrences of 1 in one position and 1 in an other position
146x146 matrix

Hope its clear now...
Please start using code tags as indicated before - otherwise you'll loose interesting in this entirely.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script count lines and sum numbers from multiple files

I want to count the number of lines, I need this result be a number, and sum the last numeric column, I had done to make this one at time, but I need to make this for a crontab, so, it has to be an script, here is my lines: It counts the number of lines: egrep -i String file_name_201611* |... (5 Replies)
Discussion started by: Elly
5 Replies

2. Shell Programming and Scripting

Need to sum up a column value from multiple files into Credit and Debit categories using awk command

i have multiple files with Batch Header, Record detail & Batch trailer data in the files like : BH 20150225950050N8262 RD 20140918000000 99999999 unk Deferred Settlement -13950 BT01 -13950 *Above sample data donot have the spaces coorectly defined. I do have multiple batch trailer... (1 Reply)
Discussion started by: kcdg859
1 Replies

3. Shell Programming and Scripting

Sum of numbers in three or more files

I have files : cat file1 15 88 44 667 33 4cat file2 445 66 77 3 56 (12 Replies)
Discussion started by: Natalie
12 Replies

4. Shell Programming and Scripting

Sum of a column in multiple files

I am performing the following operation on a file that looks like this 1000 0 10 479.0 1115478.07497 0.0 0.0 0.0872665 1000 10 20 1500.0 3470012.29304 0.0 0.0 0.261799 1000 20 30 2442.0 5676346.87758 0.0 0.0 0.436332 1000 30 40 3378.0 7737905.30957 0.0 0.0 0.610865 1000 40 50 4131.0... (2 Replies)
Discussion started by: kayak
2 Replies

5. UNIX for Dummies Questions & Answers

need [HELP] sum array multiple files

Hi.. I'm very newbie here.. I wonder if somebody can help me.. I have multiple directories with same out file name for each directories.. ./dirA/out.dat ./dirB/out.dat ./dirC/out.dat ..and so on.. for ./dirA/out.dat here is the structure content : for ./dirB/out.dat the same... (4 Replies)
Discussion started by: agiantz
4 Replies

6. Shell Programming and Scripting

need [HELP] sum array multiple files

Hi.. I'm very newbie here.. I wonder if somebody can help me.. I have multiple directories with same out file name for each directories.. ./dirA/out.dat ./dirB/out.dat ./dirC/out.dat ..and so on.. for ./dirA/out.dat here is the structure content : for ./dirB/out.dat the same... (6 Replies)
Discussion started by: agiantz
6 Replies

7. Shell Programming and Scripting

Sum Numbers from different files

Hi All, I need to print the sum of numbers from different files. Input files: file1.out 10 20 30 file2.out 10 20 30 (5 Replies)
Discussion started by: saint2006
5 Replies

8. Shell Programming and Scripting

Read the data from multiple files and sum the value

Hi all, I have a requirement where i have to read multiple files using Shell Script in Korn Shell. each file will have the 3rd line as the amount field, i have to read this amount field and sum it for all the files. any idea on how to achieve this?? (i think i can achieve it using a loop,... (9 Replies)
Discussion started by: nvuradi
9 Replies

9. Shell Programming and Scripting

sum numbers in multiple files

I have 11 directories with around 200 files in each. In each directory the files are labeled out.0 through out.201 . Each file has around 118 numbers in a single column. I need to sum the files in each directory so each directory will have a resultant vector that is 118 numbers long. I then... (5 Replies)
Discussion started by: pattywac
5 Replies

10. Shell Programming and Scripting

how to find a sum of multiple numbers

I have a command which returns some numbers as follows: $ls -l ${dbname}.ix* | awk '{print $5 }' 929792 36864 57344 73728 53248 114688 How can I find the sum of those numbers by piping this output into 'awk' or some other editor/command? Thanks a lot -A (3 Replies)
Discussion started by: aoussenko
3 Replies
Login or Register to Ask a Question