Python prettytable Module

Python prettytable Module

Python outputs the output as a tabular format via the Prettytable module

1. Installing prettytable

Pip Install prettytable

　　

2. Example

From prettytable Import Prettytablex = prettytable ([' City name ', ' area ', ' Population ', ' annual rainfall ']) x.align["City N Ame "] =" L "# left align City namesx.padding_width = 1 # One space between column edges and contents (default) X.add_row ([" A Delaide ", 1295, 1158259, 600.5]) x.add_row ([" Brisbane ", 5905, 1857594, 1146.4]) x.add_row ([" Darwin ", 112, 120900, 1714.7] ) X.add_row (["Hobart", 1357, 205556, 619.5]) x.add_row (["Sydney", 2058, 4336374, 1214.8]) x.add_row (["Melbourne", 1566, 3806092, 646.9]) x.add_row (["Perth", 5386, 1554769, 869.4]) print (x) +-----------+------+------------+--------------- --+| City Name | Area | Population | Annual rainfall |+-----------+------+------------+-----------------+| Adelaide | 1295 | 1158259 | 600.5 | | Brisbane | 5905 | 1857594 | 1146.4 | | Darwin | 112 | 120900 | 1714.7 | | Hobart | 1357 | 205556 | 619.5 | | Sydney | 2058 | 4336374 | 1214.8 | | Melbourne | 1566 | 3806092 | 646.9 | | Perth | 5386 | 1554769 | 869.4 |+-----------+------+------------+-----------------+

　　

referencing CSV file data

From prettytable Import FROM_CSVFP = open ("Data.csv", "r") MyTable = from_csv (FP) print (mytable) fp.close ()

　　

Referencing database file data

Import sqlite3from prettytable Import from_cursorconnection = Sqlite3.connect ("mydb.db") cursor = Connection.cursor () Cursor.execute ("Select Field1, Field2, field3 from my_table") MyTable = from_cursor (cursor) print (mytable)

　　

Python prettytable Module