Compare two tab-delimiter files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare two tab-delimiter files
# 1  
Old 09-11-2012
Compare two tab-delimiter files

Hi,

I have two files like:

file1

Code:
chr1     40
chr1     50
chr2     10
chr2     60

file2

Code:
chr1     30
chr1     50
chr2     15
chr2     20

and want to get the difference of column 2 when column 1 is the same in both files.

So the output file would be:

Code:
chr1     10
chr1     0
chr2     -5
chr2     40

Could somebody help me? Thanks
Moderator's Comments:
Mod Comment
Please use code tags when posting data and code samples!
# 2  
Old 09-11-2012
with the recent fury of questions you posted... What have you tried so far and where exactly are you stuck?
# 3  
Old 09-11-2012
I wanted to get the average of two columns and compare that average to a column in another file. I have the average in column 2 in in column 1 the chromosome number. If column 1 is the same for both files i want to calculate the difference between column 2 of two files as described above.
Sorry for all questions. im really new with this.
# 4  
Old 09-11-2012
Quote:
Originally Posted by linseyr
I wanted to get the average of two columns and compare that average to a column in another file. I have the average in column 2 in in column 1 the chromosome number. If column 1 is the same for both files i want to calculate the difference between column 2 of two files as described above.
Sorry for all questions. im really new with this.
This is a very confusing explanation and seems that your original statement has nothing to do with the what're asking now and with the sample file you provided.
If the last statement is what you're after, please provide sample files and the desired output.
Also please show your own attempt at the resolution - it would help us guide you in the right direction.
# 5  
Old 09-11-2012
Based on your sample datas, you can start with:
Code:
~/unix.com$ awk -F"\t" 'NR==FNR{A[NR]=$2;next}{print $1,$2-A[FNR]}' file1 file2

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

How can i make a tab delimiter file to a comma delimiter??? (13 Replies)
Discussion started by: saggiboy10
13 Replies

2. UNIX for Dummies Questions & Answers

set output delimiter as tab in cut command

I can not make it work, it prints \t rather than introduce tabs. cut -d "," -f 4,8 Samples.csv --output-delimiter="\t" | sort > out Since I am running this command within a shell script, I tried manually inserting tab in this command, still does not work. I am using bash shell Suggestions... (8 Replies)
Discussion started by: analyst
8 Replies

3. Shell Programming and Scripting

Selecting Specific Columns and Insert the delimiter TAB

Hi, I am writing a Perl Script for the below : I have a data file that consists of the header information which is 231 Lines and the footer information as 4 lines. The total number of line including the header and footer 1.2 Million with Pipe Delimited file. For example: Header Information:... (4 Replies)
Discussion started by: filter
4 Replies

4. Shell Programming and Scripting

Compare Tab Separated Field with AWK to all and print lines of unique fields.

Hi. I have a tab separated file that has a couple nearly identical lines. When doing: sort file | uniq > file.new It passes through the nearly identical lines because, well, they still are unique. a) I want to look only at field x for uniqueness and if the content in field x is the... (1 Reply)
Discussion started by: rocket_dog
1 Replies

5. Shell Programming and Scripting

Compare two columns separated by a tab

witam potrzebuje polecenia porownujacego koumny na podstawie n-ostatnich znakow danej linnijki tj mam 2 koumny AiB zawierajace ciag dowolnych znakow (dlugosci w kazdej linijce mga byc rozne wiec uzycie substra odpada) A B ewewewabc nbgujnnabc... (3 Replies)
Discussion started by: Toudi
3 Replies

6. UNIX for Dummies Questions & Answers

Tab delimiter to ""

May be it's simple. But asa new bie I'm having hard time. input : a tab delimited file col c1 c2 c3 a X/X Y/Y D/D b L/L L/L M/M output col c1 c2 c3 "a" "X/X" "Y/Y" "D/D" "b" "L/L" "L/L" "M/M" (2 Replies)
Discussion started by: ruby_sgp
2 Replies

7. UNIX for Dummies Questions & Answers

Delimiter: Tab or Space?

Hello, Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another. Thanks, G (4 Replies)
Discussion started by: Gussifinknottle
4 Replies

8. UNIX for Advanced & Expert Users

how to search delimiter tab in a line and replace it

hi every one plz help me i want to search for a line contains tabspace This is a line The should be changed see the above line is seperated with tab space i want to replace that tab space in to # as This is a line#The should be changed i have tried with... (4 Replies)
Discussion started by: kkraja
4 Replies

9. Shell Programming and Scripting

append data in a file by using tab delimiter

Hi, I need to append the data in to a file by using tab delimiter. eg: echo "Data1" >> filename.txt echo "\t" >> filename.txt (its not working) echo "Data2" >> filename.txt. the result sould be like this. Data1 Data2 (6 Replies)
Discussion started by: Sharmila_P
6 Replies

10. Shell Programming and Scripting

Cutting a tab delimiter file

I have a 30 column tab delimited record file. I need to extract the first 10column. The following command to cut was not working cut -f 1-10 -d "\t" filename. Could any one keep on this . Thanks in Advance (4 Replies)
Discussion started by: vinod.thayil
4 Replies
Login or Register to Ask a Question

Featured Tech Videos