Technical background
in the previous postblog (loanword)We have introduced the python table data processing program, which focuses on combing, calculating, and presenting table-type data, this article focuses on theshowcaseThis aspect works. First let's look at a case where we define a table of data in the form of an array:
[dechin@dechin-manjaro table]$ ipython
Python 3.8.5 (default, Sep 4 2020, 07:30:14)
Type 'copyright', 'credits' or 'license' for more information
IPython 7.19.0 -- An enhanced Interactive Python. Type '?' for help.
In [1]: table=[('a',1,2,3),('b',2,3,4)]
In [2]: print(table)
[('a', 1, 2, 3), ('b', 2, 3, 4)]
When we print the data from this form directly, we find that the results are very difficult to see. Although we can get the same information from this form, this method of presenting the data is very unfavorable for us to get the data directly from the printout.
Use tabulate to beautify table output
First introduce a tool tabulate, you can directly print the array format of the table data, and there are a variety of output formats to choose from. Installation method can also be managed with pip:
[dechin@dechin-manjaro table]$ python3 -m pip install tabulate Requirement already satisfied: tabulate in /home/dechin/anaconda3/lib/python3.8/site-packages (0.8.9)
Installation is easy and there are no other dependencies. Next we show some basic usage with ipython:
[dechin@dechin-manjaro table]$ ipython
Python 3.8.5 (default, Sep 4 2020, 07:30:14)
Type 'copyright', 'credits' or 'license' for more information
IPython 7.19.0 -- An enhanced Interactive Python. Type '?' for help.
In [1]: from tabulate import tabulate
In [2]: import numpy as np
In [3]: header=['index']+list(range(4)) # Definition of table headers
In [4]: header
Out[4]: ['index', 0, 1, 2, 3]
In [8]: table=[('Alice',1,2,3,4),('Bob',2,3,4,5)] # Definition of table content
In [9]: table
Out[9]: [('Alice', 1, 2, 3, 4), ('Bob', 2, 3, 4, 5)]
In [11]: print(tabulate(table,headers=header,tablefmt='grid')) # Print table contents in grid format
+---------+-----+-----+-----+-----+
| index | 0 | 1 | 2 | 3 |
+=========+=====+=====+=====+=====+
| Alice | 1 | 2 | 3 | 4 |
+---------+-----+-----+-----+-----+
| Bob | 2 | 3 | 4 | 5 |
+---------+-----+-----+-----+-----+
In [12]: print(tabulate(table,headers=header,tablefmt='fancy_grid')) # Printed in fancy_grid format
╒═════════╤═════╤═════╤═════╤═════╕
│ index │ 0 │ 1 │ 2 │ 3 │
╞═════════╪═════╪═════╪═════╪═════╡
│ Alice │ 1 │ 2 │ 3 │ 4 │
├─────────┼─────┼─────┼─────┼─────┤
│ Bob │ 2 │ 3 │ 4 │ 5 │
╘═════════╧═════╧═════╧═════╧═════╛
In this case, we generated the table header and table content in array format separately, and then wrapped them with tabulate before printing them out. Since thetabulateSupports output in a variety of formats, here we show only thegridcap (a poem)fancy_gridTwo personal favorite formats. Other types of formats are available:
"plain" "simple" "github" "grid" "fancy_grid" "pipe" "orgtbl" "jira" "presto" "psql" "rst" "mediawiki" "moinmoin" "youtrack" "html" "latex" "latex_raw" "latex_booktabs" "textile"
Use prettytable to beautify the output
Similar to tabulate, prettytable's main purpose is also to standardize the beautification of the table data output, but in the use of slightly different methods, in different scenarios can be used in different programs. Here we first look at the installation of prettytable, the same can use pip to manage:
[dechin@dechin-manjaro table]$ python3 -m pip install prettytable Collecting prettytable Downloading prettytable-2.1. (22 kB) Requirement already satisfied: wcwidth in /home/dechin/anaconda3/lib/python3.8/site-packages (from prettytable) (0.2.5) Installing collected packages: prettytable Successfully installed prettytable-2.1.0
After installation we show its usage with an example py file:
# pt_test.py from prettytable import PrettyTable tb = PrettyTable() # Generate form objects tb.field_names = ['Index', 0, 1, 2, 3] # Define table headers tb.add_row(['Alice',1,2,3,4]) # Add a row with column tb.add_row(['Bob',2,3,4,5]) print (tb) # printout
The execution result of the code is as follows:
[dechin@dechin-manjaro table]$ python3 pt_test.py +-------+---+---+---+---+ | Index | 0 | 1 | 2 | 3 | +-------+---+---+---+---+ | Alice | 1 | 2 | 3 | 4 | | Bob | 2 | 3 | 4 | 5 | +-------+---+---+---+---+
As the use of the case with the tabulate introduced above is the same, so the output results are similar, equivalent to more than one output format. But in addition to the output format, we found that prettytable can be very good use of rows and columns of the form of adding to the table operation, the operation of the habit is closer to the form of database operations, so for frequent use of the database, prettytable may be a better solution to the output of tabular data.
Summary outline
This article describes the two table data printing tools: tabulate and prettytable installation and basic usage. As the tabular data itself is not standardized on the output format, so the printed data will appear more messy, not conducive to intuitive reading. Therefore the introduction of these two tools to enhance the readability of the output results. Both have their advantages and disadvantages in use, tabulate supports more forms of table styles, while prettytable uses a form of operation closer to the database, for some users have a natural ecological advantage.
copyright statement
This article was first linked to:/dechinphy/p/
Author ID: DechinPhy
For more original articles, see:/dechinphy/
Reference Links/qq_43901693/article/details/104920856/u010359398/article/details/82766474
to this article on python3 beautify the results of the table data output is introduced to this article, more related python table beautify the output content, please search for my previous articles or continue to browse the following related articles I hope that you will support me in the future more!