How can I see the output in python as like SQL table format [duplicate]

Question

The code and output which I have written is attached below.. FInd it in above images.

    import psycopg2
    conn = psycopg2.connect("dbname='news' user='postgres'")
    cursor = conn.cursor()
    cursor.execute(
        "SELECT * FROM authors")
    results = cursor.fetchall()
    print (results)
    conn.close

The code and output:

The output format what I want:

stackoverflow.com/questions/10865483/… I'd look at the second answer here. — bhow
– bhow, Commented Oct 16, 2017 at 19:09

aufziehvogel · Accepted Answer · 2017-10-16 19:10:06Z

2

You could use the library pandas for this, it has convenient methods to show data and does the alignment of columns for you.

Here is a small sample:

import pandas as pd
print(pd.DataFrame([(1,2,3), (1,2,3)], columns=['a', 'b', 'c']))

Leads to the output

   a  b  c
0  1  2  3
1  1  2  3

And in your case, you would want to use:

df = pd.DataFrame(results, columns=['name', 'description', 'id'])

I just guessed the column names...

answered Oct 16, 2017 at 19:10

aufziehvogel

7,2976 gold badges37 silver badges57 bronze badges

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

3 Comments

cs95 Over a year ago

Nothing was mentioned about pandas, so why bring it up?

aufziehvogel Over a year ago

Because it does the job.

cs95 Over a year ago

You can do the job 100 other ways, too, why not list them all? :)

Collectives™ on Stack Overflow

How can I see the output in python as like SQL table format [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related