怎么用python程序显示表格

时间:2025-01-28 08:57:45 单机游戏

在Python中显示表格有多种方法,以下是几种常用的方式:

方法一:使用pandas和tabulate库

安装pandas和tabulate库

```bash

pip install pandas tabulate

```

创建数据框

```python

import pandas as pd

data = {

"姓名": ["张三", "李四", "王五"],

"年龄": [25, 30, 28],

"城市": ["北京", "上海", "广州"]

}

df = pd.DataFrame(data)

```

将数据框格式化为表格

```python

from tabulate import tabulate

print(tabulate(df, headers='keys', tablefmt='grid'))

```

方法二:使用pandas和prettytable库

安装pandas和prettytable库

```bash

pip install pandas prettytable

```

创建数据框

```python

import pandas as pd

data = {

"姓名": ["Alice", "Bob", "Charlie"],

"年龄": [30, 25, 35],

"城市": ["New York", "Los Angeles", "Chicago"]

}

df = pd.DataFrame(data)

```

使用prettytable库创建表格

```python

from prettytable import PrettyTable

table = PrettyTable()

table.field_names = ["姓名", "年龄", "城市"]

table.add_row(["Alice", 30, "New York"])

table.add_row(["Bob", 25, "Los Angeles"])

table.add_row(["Charlie", 35, "Chicago"])

print(table)

```

方法三:使用基础字符串拼接

创建数据

```python

data = [

["姓名", "年龄", "城市"],

["Alice", 30, "New York"],

["Bob", 25, "Los Angeles"],

["Charlie", 35, "Chicago"]

]

```

使用制表符拼接

```python

for row in data:

print("\t".join(map(str, row)))

```

使用字符串格式化

```python

for row in data:

print("{:<10} {:<5} {:<15}".format(*row))

```

方法四:从文件读取表格

读取CSV文件

```python

import pandas as pd

df = pd.read_csv('data.csv', encoding='utf-8')

print(df.head())

```

读取Excel文件

```python

import pandas as pd

df = pd.read_excel('travel.xlsx')

print(df.head())

```

将数据写入Excel文件

```python

df.to_excel('output.xlsx', index=False)

```

总结

以上方法各有优缺点,选择哪种方法取决于具体需求。对于简单的表格,可以使用字符串拼接或prettytable库;对于复杂的数据处理和展示,建议使用pandas和tabulate库,因为它们功能更强大,格式化选项更多样。