Filtering two files with uncommon column
Chris
cwitts at gmail.com
Fri Jan 18 04:37:59 EST 2008
On Jan 18, 11:23 am, Madhur <madhurr... at gmail.com> wrote:
> I would like to know the best way of generating filter of two files
> based upon the following condition
>
> I have two files. Contents of the first file is
>
> File 1
> abc def hij
> asd sss lmn
> hig pqr mno
>
> File 2
>
> jih def asd
> poi iuu wer
> wer pqr jjj
>
> I would like have the output as
> Output
>
> File1
> asd sss lmn
> File2
> poi iuu wer
>
> Basically I want to compare the two files based on second column. If
> the second
> column matches on both the files do not print anything, else if there
> is no matc
> h in for the second column for first file in second file then print it
> under Fil
> e1 header, else if there is no match for the second column for second
> file in fi
> rst file print it under File2 header.
>
> Thankyou
> Madhur
file1 = open('file1.txt','rb')
file2 = open('file2.txt','rb')
file1_line = file1.next()
file2_line = file2.next()
while file1_line and file2_line:
try:
f1_col2 = file1_line.split(' ')[1]
except IndexError:
print 'Not enough delimiters in line.'
try:
f2_col2 = file2_line.split(' ')[2]
except IndexError:
print 'Not enough delimiters in line.'
if f1_col2 != f2_col2:
outfile_data_to_relevant_files()
file1_line = file1.next()
file2_line = file2.next()
HTH
Chris
More information about the Python-list
mailing list