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
安装：
1
2
tar fvxz pip-8.1.2.tar.gz&& cd pip-8.1.2 && chmod +x setup.py&& python setup.pyinstall
pip2.6 install tabulate
执行python:
>>> from tabulate import tabulate成功
一、列出字段对应的表格
1
2
3
4
5
6
7
8
>>> 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 63715973.6
Moon 1737 73.5
Mars 3390 641.85
------------------------
二、把相应的字段头放到表格前端
使用headers选项
1
2
3
4
5
6
7
>>> print tabulate(table, headers=["Planet","sina", "baidu"])
Planet sina baidu
---------------------------
Sun 696000 1.9891e+09
Earth 63715973.6
Moon 1737 73.5
Mars 3390 641.85
如果行表头在第一个字段则使用headers="firstrow"
如下：
1
2
3
4
5
>>> 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”
[*]“latex_booktabs”
以对每个参数做了测试，需要哪个参数可以自己选择
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
>>> 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}
>>>
页:
[1]