I have two data files, each have 3 columns, and I would like to subtract one column from one file and one column from another. Is it possible?
Yes, I want to perform the arithmetic operation of subtraction among the mentioned columns, thanks for helping.
1 1 ===>> 0
2 2 0
3 3 0
4 4 0
5 5 0
You could create a bash (shell) script with 'awk' commands to do this. Ideally, extract each column from file and put into temp files, then use 'paste' to combine temp files, then final 'awk' command to perform subtraction, you can also include commands to clean up temp files etc within the shell script.
You can do the substraction and write the result just using awk from command line.
just try:
awk '{$3 = $1 - $2} 1' < your_input_file > your_output_file
you might formating field separator of the output (if you need) .
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Graphs