有没有一种方法可以在python中指定具有合并单元格的多个标头?
示例数据集:
from tabulate import tabulate
cols = ["ID", "Config\nA", "Config\nB", "Config\nC", "Config\nD", "Oth"]
rows = [[ "0x0", "2", "0", "0", "4", "3"],
[ "0x1", "0", "0", "0", "0", "4"],
[ "0x2", "0", "2", "0", "1", "5"]]
print(tabulate(rows, headers=cols,tablefmt="pretty"))表中的当前输出:
+-----+--------+--------+--------+--------+--------+
| ID | Config | Config | Config | Config | Oth |
| | A | B | C | D | |
+-----+--------+--------+--------+--------+--------+
| 0x0 | 2 | 0 | 0 | 4 | 3 |
| 0x1 | 0 | 0 | 0 | 0 | 4 |
| 0x2 | 0 | 1 | 0 | 1 | 5 |
+-----+--------+--------+--------+--------+--------+期望产出:
+-----+---+---+---+---+-----+
| ID | Config | Oth |
+ +---+---+---+---+ |
| | A | B | C | D | |
+-----+---+---+---+---+-----+
| 0x0 | 2 | 0 | 0 | 4 | 3 |
| 0x1 | 0 | 0 | 0 | 0 | 4 |
| 0x2 | 0 | 2 | 0 | 1 | 5 |
+-----+---+---+---+---+-----+发布于 2022-03-25 13:19:36
我不完全确定你要用这张桌子做什么,但我可能会建议你转到潘达斯图书馆。他们有广泛的支持,各种数据标签。
import pandas as pd
column_names = pd.DataFrame([["Config", "A"],
["Config", "B"],
["Config", "C"],
["Config", "D"],
["0th", ""]],
columns=["ID", ""])
rows = [["2", "0", "0", "4", "3"],
["0", "0", "0", "0", "4"],
["0", "2", "0", "1", "5"]]
columns = pd.MultiIndex.from_frame(column_names)
index = ["0x0", "0x1", "0x2"]
df = pd.DataFrame(rows, columns=columns, index=index)
display(df)

https://stackoverflow.com/questions/70897191
复制相似问题