export data into file in python

Question

I am exporting my data from a list of lists.

when I run the following code

with open('out5.txt','w') as f :
    f.write ('\t'.join(z[0][0]))
    for i in rows:
        f.write ('\t'.join(i))

everything is in the same line but I want a file like this

id    name  Trans

ENS001 EGSB  TTP

EN02   EHGT  GFT

Sure looks like it to me: you've just replaced ' ' with '\t', and changed the name of the output file. What am I missing? — DSM
– DSM, Commented Dec 30, 2014 at 7:16

Alexander · Accepted Answer · 2014-12-30 07:29:35Z

1

You should add a newline characters \n

 f.write('\t'.join(i) + '\n')

I would do it like this :

from __future__ import print_function
with open('out5.txt','w') as f :
    print(*z[0][0], sep="\t", file=f, end="\n")
    for i in rows:
       print(*i, sep="\t", file=f, end="\n")

edited Dec 30, 2014 at 7:29

answered Dec 30, 2014 at 7:12

Alexander

12.8k5 gold badges62 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Madela Abel · Accepted Answer · 2014-12-30 07:18:51Z

0

You seem to be missing a newline after each print to file. You should try this

with open('out5.txt','w') as f :
    f.write ('\t'.join(z[0][0]))
    f.write ('\n')
    for i in rows:
        f.write ('\t'.join(i))
        f.write ('\n')

answered Dec 30, 2014 at 7:18

Madela Abel

213 bronze badges

Collectives™ on Stack Overflow

export data into file in python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related