Python - Write to file in tabular format

Question

I have a number of variables being printed using a for loop. They are being written in a file using the below function.

def writeToServiceFile(file,svc,nodes,idd,i):
    my_file=open(file,"a")
    my_file.write(str(id)+"\t"+nodes+"\t"+svc+"\t"+str(i)+"\n")
    my_file.close()

The output that I get is :

1000078201  172.29.219.105  kubelet None
1000078202  172.29.219.104  kubelet None
1000078204  172.29.219.103  kubelet None
1000078209  172.29.219.106  mongod  SECONDARY
1000078209  172.29.219.106  elasticsearch   Secondary
1000078211  172.29.219.107  mongod  SECONDARY
1000078211  172.29.219.107  elasticsearch   Secondary
1000078206  172.29.219.109  postgres    None
1000078205  172.29.219.16   redis-server    slave
1000078837  172.29.219.15   redis-server    master

The output I desire is more tabular in nature.

1000078201  172.29.219.105  kubelet         None
1000078202  172.29.219.104  kubelet         None
1000078204  172.29.219.103  kubelet         None
1000078209  172.29.219.106  mongod          SECONDARY
1000078209  172.29.219.106  elasticsearch   Secondary
1000078211  172.29.219.107  mongod          SECONDARY
1000078211  172.29.219.107  elasticsearch   Secondary
1000078206  172.29.219.109  postgres        None
1000078205  172.29.219.16   redis-server    slave
1000078837  172.29.219.15   redis-server    master

What libraries can I look into to get a desired output ?

No need for any libraries, python's built-in print function will easily do just that. — chickity china chinese chicken
– chickity china chinese chicken, Commented Apr 5, 2017 at 1:10
if you know the max len of your values, you can use format() — t.m.adam
– t.m.adam, Commented Apr 5, 2017 at 1:12

Graham · Accepted Answer · 2017-09-26 21:56:17Z

3

No need for any external library, use python's built-in format() function. Just make this one-line change:

my_file.write('{0:10}  {1:14}  {2:13}   {3}\n'.format(str(id), nodes, svc, str(i)))

See the Format Specification Mini-Language for details on the parameters and other possible customization.

edited Sep 26, 2017 at 21:56

Graham

7,86020 gold badges67 silver badges92 bronze badges

answered Apr 5, 2017 at 1:51

chickity china chinese chicken

8,0672 gold badges24 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

Python - Write to file in tabular format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related