How to replace a column in a text file using a list?

Question

I want to replace a column in a text file based on values from another text file. I skipped first 3 header lines and read second column from file1 into a list L and want to replace column 2 in file2. Following is what I have:

L = []
for index, line in enumerate(open("C:/file1.txt", "r")):
    if index <= 2:
        continue
    else:
        L.append(line.split()[1])

For example:

L = ['2.3','1.2']

and text file is:

 x     y    z
1.1   2.1  1.4
1.9   1.8  2.1

I want to replace values under variable y with list L values. Any suggestions would be appreciative.

consider using pandas package it might save you lot of time and efforts — alko
– alko, Commented Nov 6, 2013 at 11:26

beroe · Accepted Answer · 2013-11-06 07:51:41Z

Here is one way to do it, assuming there are the same number of elements in the list as there are lines in the file. Also assuming that you want tabs between the elements. Also assuming that "column 2" means the second column, with python index 1. Final assumption, you just want to print the substituted file to the screen. On OSX or Linux, you can capture the edited file by putting > editedfile.txt after the command. If there are four or more columns, just put elements[2:] instead of elements[2]:

# This must have the same number of values as lines in the file
L = ['2.3','1.2']
with open("file1.txt", "r") as f:
    # skip the first line but output it?
    print f.readline().rstrip('\n') 

    for value,line in zip(L,f):
        elements = line.split()
        print "{}\t{}\t{}".format(elements[0],value,elements[2])

Output (in which the middle values have been changed to 2.3 and 1.2, and I replaced the tabs wth spaces for formatting):

 x     y    z
1.1    2.3    1.4
1.9    1.2    2.1

Martijn Pieters · Accepted Answer · 2013-11-05 23:25:51Z

0

You probably need itertools.izip or itertools.izip_longest:

import itertools
with open(fname1) as f1, open(fname2) as f2:
    for line1, line2 in itertools.izip(f1, f2):
        pass # some computations here

edited Nov 5, 2013 at 23:25

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Nov 5, 2013 at 23:17

alko

48.7k12 gold badges99 silver badges105 bronze badges

3 Comments

abarnert Over a year ago

That isn't valid Python. Did you mean with open(fname1) as f1, open(fname2) as f2:?

abarnert Over a year ago

Also, you probably want to zip up the file objects, not the filenames.

alko Over a year ago

yeah, don't have interpreter at hand, programm on paper. thanx!

Collectives™ on Stack Overflow

How to replace a column in a text file using a list?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related