Python表格講解及安裝

python 安裝pip

通路官網：

https://pypi.python.org/pypi/pip

下載下傳：

https://pypi.python.org/packages/e7/a8/7556133689add8d1a54c0b14aeff0acb03c64707ce100ecd53934da1aa13/pip-8.1.2.tar.gz#md5=87083c0b9867963b29f7aba3613e8f4a

安裝：

tar fvxz pip-8.1.2.tar.gz  && cd pip-8.1.2 && chmod +x setup.py  && python setup.py  install
pip2.6 install tabulate      

執行python:

>>> from tabulate import tabulate成功

一、列出字段對應的表格

>>> table = [["Sun",696000,1989100000],["Earth",6371,5973.6],["Moon",1737,73.5],["Mars",3390,641.85]]
>>> print tabulate(table)
-----  ------  -------------
Sun    696000     1.9891e+09
Earth    6371  5973.6
Moon     1737    73.5
Mars     3390   641.85
-----  ------  -------------      

二、把相應的字段頭放到表格前端

使用headers選項

>>> print tabulate(table, headers=["Planet","sina", "baidu"])
Planet      sina          baidu
--------  ------  -------------
Sun       696000     1.9891e+09
Earth       6371  5973.6
Moon        1737    73.5
Mars        3390   641.85      

如果行表頭在第一個字段則使用headers="firstrow"

如下：

>>> print tabulate([["Name","age"],["liyuanchuaun","25"],["gaolixu","25"]],headers="firstrow")
Name            age
------------  -----
liyuanchuaun     25
gaolixu          25      

table支援的格式很多具體如下：

Supported table formats are:

• “plain”
• “simple”
• “grid”
• “fancy_grid”
• “pipe”
• “orgtbl”
• “rst”
• “mediawiki”
• “html”
• “latex”

>>> table = [["spam",42],["eggs",455],["bacon",23]]
>>> headers = ["item","qty"]
>>> print tabulate(table,headers)
item      qty
------  -----
spam       42
eggs      455
bacon      23
>>> print tabulate(table,headers,tablefmt="plain")
item      qty
spam       42
eggs      455
bacon      23
>>> print tabulate(table,headers,tablefmt="simple")
item      qty
------  -----
spam       42
eggs      455
bacon      23
>>> print tabulate(table,headers,tablefmt="grid")  
+--------+-------+
| item   |   qty |
+========+=======+
| spam   |    42 |
+--------+-------+
| eggs   |   455 |
+--------+-------+
| bacon  |    23 |
+--------+-------+
>>> print tabulate(table,headers,tablefmt="psql")
+--------+-------+
| item   |   qty |
|--------+-------|
| spam   |    42 |
| eggs   |   455 |
| bacon  |    23 |
+--------+-------+
>>> print tabulate(table,headers,tablefmt="rst") 
======  =====
item      qty
======  =====
spam       42
eggs      455
bacon      23
======  =====
>>> print tabulate(table,headers,tablefmt="orgtbl")
| item   |   qty |
|--------+-------|
| spam   |    42 |
| eggs   |   455 |
| bacon  |    23 |
>>> print tabulate(table,headers,tablefmt="mediawiki")
{| class="wikitable" style="text-align: left;"
|+ <!-- caption -->
|-
! item   !! align="right"|   qty
|-
| spam   || align="right"|    42
|-
| eggs   || align="right"|   455
|-
| bacon  || align="right"|    23
|}
>>> print tabulate(table,headers,tablefmt="html")     
<table>
<tr><th>item  </th><th style="text-align: right;">  qty</th></tr>
<tr><td>spam  </td><td style="text-align: right;">   42</td></tr>
<tr><td>eggs  </td><td style="text-align: right;">  455</td></tr>
<tr><td>bacon </td><td style="text-align: right;">   23</td></tr>
</table>
>>> print tabulate(table,headers,tablefmt="latex")
\begin{tabular}{lr}
\hline
 item   &   qty \\
\hline
 spam   &    42 \\
 eggs   &   455 \\
 bacon  &    23 \\
\hline
\end{tabular}
>>>