How to calculate average of each column and the data in separate file?
Hi all,
I would like to find the average of the first two columns in each file and divide the values (Column 2 / Column1). Below shows the example of my intended output :
File1:
A B
1 2
4 5
7 8
File2:
A B
2 3
5 6
8 9
Desired output :
File1 1.25
File2 1.125
Thank you
• 360 views
•
link
written
by
sadstudent •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Creating column that groups data from another columns
written by Bioinfo •
-
Count columns and delet specific one
written by salvatore_d •
-
combine columns from multiple files
written by bk11 •
-
Using Python, How to compare two columns in two different csv files, and then print the similar lin…
written by hamzaallal07 •
-
How to replace row with another row in linux having NA and nucleotide bases
written by Kritika
-
Merging data coloum wise in R
written by David_emir
-
Compare one of the columns of two seperate files and write the raw of the second file next to first…
written by emre •
-
how to compare sets using python (dealing with PDB file)
written by Jason Lin •
-
Merging File
written by prt-hntr •
-
Comparing The Numbers Present In Two Files And Get The Matched [Closed]
written by Cynthia •
how is it related to bioinformatics ?
awk '(NR>1){T1+=int($1);T2+=int($2);} END{print T2/T1;}' input.txtand closing.
Hello sadstudent!
We believe that this post does not fit the main topic of this site.
unrelated to bioinformatics
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!