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

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:

https://stackoverflow.com/questions/10865483/print-results-in-mysql-format-with-python I'd look at the second answer here. — bhow, Oct 16 '17 at 19:09

score 2 · Answer 1 · answered Oct 16 '17 at 19:10

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 '17 at 19:10

aufziehvogel

7,167
5
34
56

2

Nothing was mentioned about pandas, so why bring it up? – cs95 Oct 16 '17 at 19:14
2

Because it does the job. – aufziehvogel Oct 16 '17 at 19:21
You can do the job 100 other ways, too, why not list them all? :) – cs95 Oct 16 '17 at 19:52

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

1 Answers1