天天看點

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