漂亮地打印 pandas 数据框 [英] Pretty Printing a pandas dataframe

问题描述

如何将 Pandas 数据框打印为基于文本的漂亮表格，如下所示?

How can I print a pandas dataframe as a nice text-based table, like the following?

+------------+---------+-------------+
| column_one | col_two |   column_3  |
+------------+---------+-------------+
|          0 |  0.0001 | ABCD        |
|          1 |  1e-005 | ABCD        |
|          2 |  1e-006 | long string |
|          3 |  1e-007 | ABCD        |
+------------+---------+-------------+

推荐答案

我刚刚找到了一个很好的工具来满足这个需求，它叫做 制表.

I've just found a great tool for that need, it is called tabulate.

它打印表格数据并与 DataFrame 配合使用.

It prints tabular data and works with DataFrame.

from tabulate import tabulate
import pandas as pd

df = pd.DataFrame({'col_two' : [0.0001, 1e-005 , 1e-006, 1e-007],
                   'column_3' : ['ABCD', 'ABCD', 'long string', 'ABCD']})
print(tabulate(df, headers='keys', tablefmt='psql'))

+----+-----------+-------------+
|    |   col_two | column_3    |
|----+-----------+-------------|
|  0 |    0.0001 | ABCD        |
|  1 |    1e-05  | ABCD        |
|  2 |    1e-06  | long string |
|  3 |    1e-07  | ABCD        |
+----+-----------+-------------+

注意:

要抑制所有类型数据的行索引，请传递 showindex="never" 或 showindex=False.

To suppress row indices for all types of data, pass showindex="never" or showindex=False.

这篇关于漂亮地打印 pandas 数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！