09-10-2018
Quote:
Originally Posted by
maya3
Does the fact that I am printing it as string (printf and %s) make any problems with precision or format for later use? The entries in file1 and file2 can be either float or decimal and the precision is very important for the task, so I tried replacing %s with %d or %i to keep the output in the same format but that didn't give the result in a triangular form like it did with %s. Why is that?
well... I assumed the sample files were representative. It seems that they cover only a
part of the cases.
It's doable. Please provide the
more representative samples for both files.
What happens if the same entries have
different floating precision from 2 files? The higher precision wins?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies
2. Shell Programming and Scripting
I have two files:
file1.txt:
FS Total Used Free Used%
/u01 10000 8000 2000 80%
/u02 10000 8000 2000 80%
/u03 10000 8000 2000 80%
/u04 10000 8000 2000 80%
/u05 10000 8000 2000 80%
/u06 10000 8000 2000 80%
/u07 10000 8000 2000 80%
/u10 10000 5000 5000 50%
file2.txt:... (7 Replies)
Discussion started by: oabdalla
7 Replies
3. Shell Programming and Scripting
Hi,
I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3
I also need to repeat for column 4.
Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies
4. Shell Programming and Scripting
Hello everyone,
I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me.
Thanks a lot (7 Replies)
Discussion started by: chandra321
7 Replies
5. Shell Programming and Scripting
Hi everyone,
I got a problem with merging files and hoped one of you would have an idea how to approach this issue. I tried it with awk, but didn't get far. This is what I have:
I got 40 files looking like the ones below. All have three columns but the number of rows differs (20000 to 50000).... (6 Replies)
Discussion started by: TuAd
6 Replies
6. UNIX for Dummies Questions & Answers
Dear all,
I have a question. I have a txt.file as below. i want to add 3 more columns: column3=conlum 2*column2; column4=(1-column2)*(1-column2); column5=1-column3-column4. Do you know how to do it? Thanks a lot!
file:
column1 column2
a 1
b 20
c 30
d 3
... (2 Replies)
Discussion started by: forevertl
2 Replies
7. Shell Programming and Scripting
I have a number of files with multiple rows that I need to add together.
Let say I have 10 files:
Each file has a great number of rows and columns. I need to add these files together the following way.
In other words, If, for example, file A occupies Columns 1 to 19, I want to add file B... (7 Replies)
Discussion started by: Ernst
7 Replies
8. Shell Programming and Scripting
Hello
I have a file as below
chr1 start ref alt code1 code2
chr1 18884 C CAAAA 2 0
chr1 135419 TATACA T 2 0
chr1 332045 T TTG 0 2
chr1 453838 T TAC 2 0
chr1 567652 T TG 1 0
chr1 602541 ... (2 Replies)
Discussion started by: plumb_r
2 Replies
9. Shell Programming and Scripting
I have two files (csv and vcf) which look exactly like this
S1.csv
func,gene,start,info
"exonic","AL","2309","het"
"exonic","NEF","6912","hom"S1.vcf
##fileinfo
#CHROM POS ID INFO
chr1 4567 rs323211 1/1:84,104,99
chr4 2309 rs346742 1/1:27,213,90
chr6 5834 ... (5 Replies)
Discussion started by: Sarah_19
5 Replies
10. Shell Programming and Scripting
Hello All,
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies