Plotly:从pandas dataframe创建带有rowname的表

Question

我正在尝试用Python Panda Dataframe创建一个绘图表，使用package :import plotly.graph_objs as go，我想让我的熊猫数据框行名作为绘图表中的行名。我不能将XXX，YYY，the table from dataframe等作为列名。请帮帮忙。The table from plotly

Answer 1

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()

​

​

Answer 2

安装此库以从图形生成图像。

pip install kaleido

脚本：

import plotly.figure_factory as ff
import pandas as pd


fig = ff.create_table(df)
fig.show()
fig.write_image("myimage.png")

Answer 3

不确定您所说的graph_obj表是什么意思。但是，您可以使用以下命令来创建表格：

import plotly.plotly as py
import plotly.figure_factory as ff
import pandas as pd

df = pd.read_csv("https://raw.githubusercontent.com/plotly/datasets/master/school_earnings.csv")

    table = ff.create_table(df)
    py.iplot(table, filename='jupyter-table1')

来自链接：https://plot.ly/python/ipython-notebook-tutorial/