Plotly: Create table with rowname from pandas dataframe

Question

I am trying to create a plotly table with Python Panda Dataframe using package :import plotly.graph_objs as go I would like to have my panda dataframe rownames as row names in the plotly table. Can this be done the table from dataframe i am not able to have the XXX, YYY, etc as column names. Please help.The table from plotly

Please include a sample data, and also what you precisely did (the code). This will increase the chances of you getting a quick and correct answer. Thanks. — byouness
– byouness, Commented May 16, 2018 at 8:44
@Sushmita Are XXX and YYY in the dataframe that you're trying to put into a table? It doesn't look like that from the screenshot. — vestland
– vestland, Commented Oct 4, 2019 at 7:51

Dharman · Accepted Answer · 2020-10-13 09:46:13Z

2

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

edited Oct 13, 2020 at 9:46

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Oct 13, 2020 at 9:40

Saurabh Kumar

1271 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jsta Over a year ago

unlike the other answers this one allows you to change the formatting of individual columns

kklw · Accepted Answer · 2021-01-18 12:00:06Z

2

Install this library to generate image from graph.

pip install kaleido

Script:

import plotly.figure_factory as ff
import pandas as pd


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

edited Jan 18, 2021 at 12:00

answered Jan 6, 2021 at 13:28

kklw

9283 gold badges16 silver badges28 bronze badges

Comments

InsParbo · Accepted Answer · 2018-05-17 05:49:04Z

0

Not sure what you mean by graph_obj table. However, you can create table using plotly following this:

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

From the link: https://plot.ly/python/ipython-notebook-tutorial/

answered May 17, 2018 at 5:49

InsParbo

4403 silver badges14 bronze badges

Collectives™ on Stack Overflow

Plotly: Create table with rowname from pandas dataframe

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related