format data from mysql in python tuple

Question

I am reading data from a MySQL database and want to print it to the screen.

I use:

import MySQLdb
conn = MySQLdb.connect(host='localhost',user='root',passwd='passwd',db='test',charset='utf8')
cursor = conn.cursor()
cursor.execute('select cust_name,cust_address,cust_city,cust_state from Customers')
numrows = int(cursor.rowcount)
for i in range(numrows):
    row =  cursor.fetchone()
    print "%s  %s  %s   %20s" %(row[0],row[1],row[2],row[3])
cursor.close()
conn.close()

The result is like this:

Village Toys  200 Maple Lane  Detroit            MI

Kids Place  333 South Lake Drive  Columbus                     OH

Fun4All  1 Sunny Place  Muncie                     IN

Fun4All  829 Riverside Drive  Phoenix                     AZ

The Toy Store  4545 53rd Street  Chicago                     IL

How can i make it left justified?

jro · Accepted Answer · 2012-10-25 06:39:38Z

1

Assuming you only want to align the last column, do it like this:

print "%s  %s  %s   %-20s" %(row[0],row[1],row[2],row[3])

The --sign justifies it to the left.

answered Oct 25, 2012 at 6:39

jro

9,5002 gold badges35 silver badges39 bronze badges

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

2 Comments

ovgolovin Over a year ago

@user1773219 Please, put the result wanted in the question. In the comments the formatting is lost.

user1773219 Over a year ago

thank you very much . I am sorry ，I couldn't Clearly expressed the question. I think this answer is great print('{row[0]:20}{row[1]:20}{row[2]:20}{row[3]:20}'.format(row=row))

ovgolovin · Accepted Answer · 2012-10-25 07:11:27Z

0

Also, there is a new formatting syntax in Python.

As I understand, you want every column to have the same indentation. This can be achieved by specifying the space each column should occupy. Because now first 3 strings are put to consume as little as possible of the target string, and only the last one takes 20 symbols. If you specify the length of each string, you will get the output in the resulting string well aligned.

Try this:

print('{row[0]:20}{row[1]:20}{row[2]:20}{row[3]:20}'.format(row=row))

The numbers 20 in the curly braces denote the length of each field.

edited Oct 25, 2012 at 7:11

answered Oct 25, 2012 at 6:50

ovgolovin

13.5k7 gold badges53 silver badges80 bronze badges

1 Comment

ovgolovin Over a year ago

@user1773219 Please, show the example of the output you want. Show this example in the question (click edit) and add this example.

Collectives™ on Stack Overflow

format data from mysql in python tuple

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related