Hi there! I have two files like below File1(with a header, ~1000 rows, ~50 columns) File2 (without a header, ~50 rows) Output
I need to multiply the the value in row1 & column 3 of File2 to the values in Column6 and onwards (MI1_A....MI45_A) of File1 all the way down till the last row, ignoring every alternate column(MI1_H..MI45_H).
Last edited by Akang; 02-21-2016 at 09:47 PM..
Reason: Add CODE and ICODE tags.
In the output file I need
1) Column "ID2" from file1 : the unique record id
2)Columns ending with "_A": The values of these columns need to be multiplied with the 3rd column of file 2.
3) Column id of file 1 (starting from column 6th) matches with the row id (except for "_A") of file2.
4) From 6th column onward in file1, every alternate column is to be used for the multiplication (6th, 8th, 10th and so on)
Hope that helps to better understand the problem!
In File1 we are using data from columns with headings:
and multiplying values in those columns with data from rows with the data in the 1st two columns containing the data:
and producing output with the headings:
Why are all three of these sets of names different? I can understand if you're saying we should completely ignore the 1st two columns in File2, but I'm not sure that I understand the transformation that you want to happen when moving headings from File1 to your output file. Is it just that 2nd character of each of the headings (except ID2) copied from File1 are to be deleted when printing the headings in the output file? Why are the headings for the fields used in File1 copied to the output file unchanged (like RudiC did in his suggestion)?
How can I produce this kind of output?
Enter a number: 3
MULTIPLICATION TABLE:
0 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
When you enter a number, it should show you the corresponding multiplication table. Plus we need to use for loops that I do not actually know. Thanks in advance! Here is my... (2 Replies)
I have two files. Row id in File1 matches the column id in file2 (starting from column7 )except the last 2 characters. File1 has 50 rows and File 2 has 56 columns. If the id matches I want to multiply the value in column3 of File1 to the entire column in File2. and in the final output print only... (11 Replies)
Hello all,
I have square matrices that look like the following, I want to merge these matrices together, and add the file names as headers. This is a simple example with two variables, actually I have ~1500 variables and 10 files.
The order of variables in the matrices are consistent.
Please... (2 Replies)
Hi,
I can't find out how to create correct code to get multiplication of each elements of array. Let's say I enter array into command line (2 3 4 5 6 8) and i need output 2*3*4*5*6*8=5760.
I tried this one, but answer is 0.
for i in $@; do
mult=$((mult*i))done
echo "mult: " $mult
... (4 Replies)
Dear All,
I am facing a problem and I would be Thankful if you can help
Hope this is the right place to ask this question
I have two matrices of (row=10, col=3) and I want to get the cosine similarity between two lines (vectors) of each file --> the result should be (10,1) of cosine measures
I... (10 Replies)
Hi all, newbie here.
Does anyone know if it is possible to use GCC or Clang to multiply
two unsigned numbers and have it use for intel instructions, the mull instruction or an imul. I can't figure how to word this to accomplish this task:
(int)(((unsigned long long)result * (unsigned)2290649225)... (4 Replies)
Hi,
I would like to carry out a multiplication in a for loop but some how I get always zero. The result of the multiplication must be assigned to the variable x.
Here is teh code
for (( i=1;i<=15;i++)); do
x=$( printf "%s\n " 'scale = 10; i*5.0*335.0*3.0/1000.0' | bc)
echo $x $i... (5 Replies)
Hi,
I am writing a script in Bourne shell
#!/bin/sh
used=`quota -v | tail -1 | awk '{print $2}'`
total=`quota -v | tail -1 | awk '{print $3}'`
echo "$used"
echo "$total"
perc=`expr ${used} / ${total} * 100 | bc`
echo "$perc"
I want to get a percentage of quota used to total limit
I... (5 Replies)
Suppose i have a file A
1*2*3*4
2*4*4*22
and second file B
2*3*4*5
4*4*6*7
By multiplying file A by file B that is file A by first column in file B respectively
output shud be
2*6*12*20
8*16*24*154
my code is
=$1
next
}
{for (f=1;f<=NF;f++) (2 Replies)
Hello there,
how do i multiply a fraction and a whole number? Example 20% of 50,000.
I had gotten 0.2 using the following:
chk=echo 20 100 | awk `{print $1/$2}`
echo $chk
$chk \* 50000 displays the error: non-numeric expression. (1 Reply)