Creating tables using plotly

Question

I am using plotly offline to create a table.But the output is displayed as a single row,not as shown in the output format given in the following link(i.e not as a table)

https://plot.ly/python/table/#changing-row-and-column-size(“Changing Row and column size”)

Here is the code,

import plotly
import plotly.graph_objs as go
#plotly.offline.init_notebook_mode()
from plotly.offline import download_plotlyjs, init_notebook_mode, plot, iplot
values = [[['geneNames', 'uniprotIDs', 'ec-code', 'subcellularLocation', 'tissueSpecificity',
            'proteinName', 'subunit', 'species']], [[' G6PC', ' P35575', ' 3.1.3.9',
            '  Endoplasmic reticulum membrane', 'No Data', ' Glucose-6-phosphatase alpha',
            'No Data', ' Homo sapiens']]]
trace0 = go.Table(
  type = 'table',
  columnorder = [1,2],
  columnwidth = [80,400],
  header = dict(
    values = [['<b>PARAMETERS</b>'],
                  ['<b>VALUES</b>']],
    line = dict(color = '#506784'),
    fill = dict(color = '#119DFF'),
    align = ['left','center'],
    font = dict(color = 'white', size = 12),
    height = 40
  ),
  cells = dict(
    values = values,
    line = dict(color = '#506784'),
    fill = dict(color = ['#25FEFD', 'white']),
    align = ['left', 'center'],
    font = dict(color = '#506784', size = 12),
    height = 30
    ))

data = [trace0]
plot(data)

I would like to ask for some help

EDIT: Would it be possible to save the table in png/txt format?I tried replacing 'uniprot.html' with 'uniprot.png'. But the file gets saved as uniprot.png.html.

The output table opens as a html file.Instead of manually using the save icon in order to save the file,I wish to save it programmatically. Any suggestions on how this can be done? — Natasha
– Natasha, Commented Dec 3, 2017 at 15:41
Try plotly.offline.plot(data, filename='uniprot.html', auto_open=False) — Maximilian Peters
– Maximilian Peters, Commented Dec 3, 2017 at 15:58
Would it be possible to save the table in png/txt format?I tried replacing 'uniprot.html' with 'uniprot.png'. But the file gets saved as uniprot.png.html. — Natasha
– Natasha, Commented Dec 3, 2017 at 16:45
Please ask only question at once, otherwise it is difficult for other users to find answers. — Maximilian Peters
– Maximilian Peters, Commented Dec 3, 2017 at 17:10

Maximilian Peters · Accepted Answer · 2017-12-03 14:16:12Z

2

Looks like as if the document and the current version of Plotly are out of sync. Try using a simple of list of two lists (column 1 and column 2).

values = [['geneNames', 'uniprotIDs', 'ec-code', 'subcellularLocation', 'tissueSpecificity', 'proteinName', 'subunit', 'species'], 
          [' G6PC', ' P35575', ' 3.1.3.9', '  Endoplasmic reticulum membrane', 'No Data', ' Glucose-6-phosphatase alpha', 'No Data', ' Homo sapiens']
         ]

answered Dec 3, 2017 at 14:16

Maximilian Peters

31.8k12 gold badges95 silver badges102 bronze badges

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

Comments

s3dev · Accepted Answer · 2019-10-01 09:09:02Z

0

Regarding your question about saving (figures) as PNG, check out orca. This is the graphing engine which sits behind plotly.

To be honest, it's a little fiddly at first, but easy once you get going, and it provides PNG support!

answered Oct 1, 2019 at 9:09

s3dev

9,8713 gold badges34 silver badges49 bronze badges

Collectives™ on Stack Overflow

Creating tables using plotly

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related