Figure Factory Tables in Python
How to make tables in Python with Plotly's Figure Factory.
New to Plotly?
Plotly is a free and open-source graphing library for Python. We recommend you read our Getting Started guide for the latest installation or upgrade instructions, then move on to our Plotly Fundamentals tutorials or dive straight in to some Basic Charts tutorials.
Tables can be created using a table trace type, or by using a figure factory as detailed in this page.
Simple Table¶
In [1]:
import plotly.figure_factory as ff
data_matrix = [['Country', 'Year', 'Population'],
['United States', 2000, 282200000],
['Canada', 2000, 27790000],
['United States', 2005, 295500000],
['Canada', 2005, 32310000],
['United States', 2010, 309000000],
['Canada', 2010, 34000000]]
fig = ff.create_table(data_matrix)
fig.show()
Add Links¶
In [2]:
import plotly.figure_factory as ff
data_matrix = [['User', 'Language', 'Chart Type', '# of Views'],
['<a href="https://plotly.com/~empet/folder/home">empet</a>',
'<a href="https://plotly.com/python/">Python</a>',
'<a href="https://plotly.com/~empet/8614/">Network Graph</a>',
298],
['<a href="https://plotly.com/~Grondo/folder/home">Grondo</a>',
'<a href="https://plotly.com/matlab/">Matlab</a>',
'<a href="https://plotly.com/~Grondo/42/">Subplots</a>',
356],
['<a href="https://plotly.com/~Dreamshot/folder/home">Dreamshot</a>',
'<a href="https://help.plot.ly/tutorials/">Web App</a>',
'<a href="https://plotly.com/~Dreamshot/6575/_2014-us-city-populations/">Bubble Map</a>',
262],
['<a href="https://plotly.com/~FiveThirtyEight/folder/home">FiveThirtyEight</a>',
'<a href="https://help.plot.ly/tutorials/">Web App</a>',
'<a href="https://plotly.com/~FiveThirtyEight/30/">Scatter</a>',
692],
['<a href="https://plotly.com/~cpsievert/folder/home">cpsievert</a>',
'<a href="https://plotly.com/r/">R</a>',
'<a href="https://plotly.com/~cpsievert/1130/">Surface</a>',
302]]
fig = ff.create_table(data_matrix)
fig.show()
Use LaTeX¶
In [3]:
import plotly.figure_factory as ff
data_matrix = [['Name', 'Equation'],
['Pythagorean Theorem', '$a^{2}+b^{2}=c^{2}$'],
['Euler\'s Formula', '$F-E+V=2$'],
['The Origin of Complex Numbers', '$i^{2}=-1$'],
['Einstein\'s Theory of Relativity', '$E=m c^{2}$']]
fig = ff.create_table(data_matrix)
fig.show()
Use a Pandas Dataframe¶
In [4]:
import plotly.figure_factory as ff
import pandas as pd
df = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/gapminderDataFiveYear.csv')
df_sample = df[100:120]
fig = ff.create_table(df_sample)
fig.show()
Modify Row Height¶
The default row height is 30 pixels. Set height_constant if you'd like to change the height of each row.
In [5]:
import plotly.figure_factory as ff
data_matrix = [['Country', 'Year', 'Population'],
['United States', 2000, 282200000],
['Canada', 2000, 27790000],
['United States', 2005, 295500000],
['Canada', 2005, 32310000],
['United States', 2010, 309000000],
['Canada', 2010, 34000000]]
fig = ff.create_table(data_matrix, height_constant=20)
fig.show()
Custom Table Colors¶
In [6]:
import plotly.figure_factory as ff
import pandas as pd
df = pd.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/gapminderDataFiveYear.csv')
df_sample = df[400:410]
colorscale = [[0, '#4d004c'],[.5, '#f2e5ff'],[1, '#ffffff']]
fig = ff.create_table(df_sample, colorscale=colorscale)
fig.show()
Custom Font Colors¶
In [7]:
import plotly.figure_factory as ff
text = [['Team', 'Rank'], ['A', 1], ['B', 2], ['C', 3], ['D', 4], ['E', 5], ['F', 6]]
colorscale = [[0, '#272D31'],[.5, '#ffffff'],[1, '#ffffff']]
font=['#FCFCFC', '#00EE00', '#008B00', '#004F00', '#660000', '#CD0000', '#FF3030']
fig = ff.create_table(text, colorscale=colorscale, font_colors=font)
fig.layout.width=250
fig.show()
Change Font Size¶
In [8]:
import plotly.figure_factory as ff
data_matrix = [['Country', 'Year', 'Population'],
['United States', 2000, 282200000],
['Canada', 2000, 27790000],
['United States', 2005, 295500000],
['Canada', 2005, 32310000],
['United States', 2010, 309000000],
['Canada', 2010, 34000000]]
fig = ff.create_table(data_matrix, index=True)
# Make text size larger
for i in range(len(fig.layout.annotations)):
fig.layout.annotations[i].font.size = 20
fig.show()
Tables with Graphs¶
In [9]:
import plotly.graph_objs as go
import plotly.figure_factory as ff
# Add table data
table_data = [['Team', 'Wins', 'Losses', 'Ties'],
['Montréal<br>Canadiens', 18, 4, 0],
['Dallas Stars', 18, 5, 0],
['NY Rangers', 16, 5, 0],
['Boston<br>Bruins', 13, 8, 0],
['Chicago<br>Blackhawks', 13, 8, 0],
['LA Kings', 13, 8, 0],
['Ottawa<br>Senators', 12, 5, 0]]
# Initialize a figure with ff.create_table(table_data)
fig = ff.create_table(table_data, height_constant=60)
# Add graph data
teams = ['Montréal Canadiens', 'Dallas Stars', 'NY Rangers',
'Boston Bruins', 'Chicago Blackhawks', 'LA Kings', 'Ottawa Senators']
GFPG = [3.54, 3.48, 3.0, 3.27, 2.83, 2.45, 3.18]
GAPG = [2.17, 2.57, 2.0, 2.91, 2.57, 2.14, 2.77]
# Make traces for graph
fig.add_trace(go.Scatter(x=teams, y=GFPG,
marker=dict(color='#0099ff'),
name='Goals For<br>Per Game',
xaxis='x2', yaxis='y2'))
fig.add_trace(go.Scatter(x=teams, y=GAPG,
marker=dict(color='#404040'),
name='Goals Against<br>Per Game',
xaxis='x2', yaxis='y2'))
fig.update_layout(
title_text = '2016 Hockey Stats',
margin = {'t':50, 'b':100},
xaxis = {'domain': [0, .5]},
xaxis2 = {'domain': [0.6, 1.]},
yaxis2 = {'anchor': 'x2', 'title': 'Goals'}
)
fig.show()
In [10]:
import plotly.graph_objs as go
import plotly.figure_factory as ff
# Add table data
table_data = [['Team', 'Wins', 'Losses', 'Ties'],
['Montréal<br>Canadiens', 18, 4, 0],
['Dallas Stars', 18, 5, 0],
['NY Rangers', 16, 5, 0],
['Boston<br>Bruins', 13, 8, 0],
['Chicago<br>Blackhawks', 13, 8, 0],
['Ottawa<br>Senators', 12, 5, 0]]
# Initialize a fig with ff.create_table(table_data)
fig = ff.create_table(table_data, height_constant=60)
# Add graph data
teams = ['Montréal Canadiens', 'Dallas Stars', 'NY Rangers',
'Boston Bruins', 'Chicago Blackhawks', 'Ottawa Senators']
GFPG = [3.54, 3.48, 3.0, 3.27, 2.83, 3.18]
GAPG = [2.17, 2.57, 2.0, 2.91, 2.57, 2.77]
fig.add_trace(go.Bar(x=teams, y=GFPG, xaxis='x2', yaxis='y2',
marker=dict(color='#0099ff'),
name='Goals For<br>Per Game'))
fig.add_trace(go.Bar(x=teams, y=GAPG, xaxis='x2', yaxis='y2',
marker=dict(color='#404040'),
name='Goals Against<br>Per Game'))
fig.update_layout(
title_text = '2016 Hockey Stats',
height = 800,
margin = {'t':75, 'l':50},
yaxis = {'domain': [0, .45]},
xaxis2 = {'anchor': 'y2'},
yaxis2 = {'domain': [.6, 1], 'anchor': 'x2', 'title': 'Goals'}
)
fig.show()
Reference¶
For more info on ff.create_table(), see the full function reference
What About Dash?¶
Dash is an open-source framework for building analytical applications, with no Javascript required, and it is tightly integrated with the Plotly graphing library.
Learn about how to install Dash at https://dash.plot.ly/installation.
Everywhere in this page that you see fig.show(), you can display the same figure in a Dash application by passing it to the figure argument of the Graph component from the built-in dash_core_components package like this:
import plotly.graph_objects as go # or plotly.express as px
fig = go.Figure() # or any Plotly Express function e.g. px.bar(...)
# fig.add_trace( ... )
# fig.update_layout( ... )
from dash import Dash, dcc, html
app = Dash()
app.layout = html.Div([
dcc.Graph(figure=fig)
])
app.run_server(debug=True, use_reloader=False) # Turn off reloader if inside Jupyter
