Filtering two files with uncommon column

[Madhur]

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

[Chris]

On Jan 18, 11:23 am, Madhur <[e-mail]:

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

[Martin Blume]

"Madhur" schrieb

I would like to know the best way of generating filter
of two files based upon the following condition
[...]

Sounds like homework. Here some suggestions:

- for each file, create a dictionary (see help(dict)
in the python shell for details) and populate it with
the values, so that e.g.
d1['def'] = 'abc def hij'
(help("".split), perhaps help("".strip))

- for each key in the first dictionary, look whether
it exists in the second, if not, write the value (the
line extracted in the first step) out.
(help(dict.iteritems), help(dict.has_key))
(Note that for
if a_dict.has_key("def"): pass
one can also write
if "def" in a_dict: pass
but you won't find this in the simple on-line help,
at least in my version)

HTH
Martin

[Neil Cerutti]

On Jan 18, 2008 4:23 AM, Madhur <ma********@gmail.comwrote:

I would like to know the best way of generating filter of two files
based upon the following condition

As a bit of friendly advice, you'll get much more useful assistance if
you post your code.

If you don't have any code to show, write some. Unless it's a quine, a
program won't write itself.

--
Neil Cerutti <mr***************@gmail.com>