Python好看又好用的二维表格table生成

1.网上常见的方案

# PrettyTable
https://blog.csdn.net/weixin_45775963/article/details/104125439

# reportlab
https://blog.csdn.net/bocai_xiaodaidai/article/details/102820431

# matplotlib.table
https://blog.csdn.net/qq_43235685/article/details/96100174

# pyQT5
http://www.jiuaitu.com/python/471.html
           

不是太丑就是太复杂!

2.大救星plotly

https://plotly.com/python/table/#use-a-pandas-dataframe

import plotly.graph_objects as go
import pandas as pd

df = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/2014_usa_states.csv')

fig = go.Figure(data=[go.Table(
    header=dict(values=list(df.columns),
                fill_color='paleturquoise',
                align='left'),
    cells=dict(values=[df.Rank, df.State, df.Postal, df.Population],
               fill_color='lavender',
               align='left'))
])

fig.show()
           

3.plotly环境搭建

#安装olotly 以及依赖
pip install plotly psutil requests

#kaleido是默认导出图片的引擎(https://plotly.com/python/static-image-export/#specify-image-export-engine)，但是有时候中文乱码，这是plotly的默认引擎，比orca快，配置简单
pip install  kaleido
           

若kaleido出现中文乱码（https://github.com/plotly/plotly.py/issues/1106），那就只能请orca出场了，orca安装配置参考：https://www.icode9.com/content-1-602481.html