Visualizing tables with Plotly

tableviz.py

import adviz
import plotly.express as px
from plotly.subplots import make_subplots

def category_to_color(categories, colorscale='D3'):
    colorscale = eval(f'px.colors.qualitative.{colorscale}')
    cat_dict = dict(enumerate(set(categories)))
    cat_dict = {v: colorscale[k] for k, v in cat_dict.items()}

    return [cat_dict[cat] for cat in categories]

top15 = px.data.gapminder().query('year==2007').sort_values('pop', ascending=False).head(15)
top15['flag'] = [adviz.flag(cc) for cc in top15['iso_alpha']]

df = top15[['flag', 'country', 'continent', 'lifeExp', 'pop', 'gdpPercap']]
df.columns = ['', 'Country', 'Continent', 'Life Exp.', 'Population', 'GDP per capita']
fig = make_subplots(
    rows=1,
    cols=df.shape[1],
    horizontal_spacing=0,
    subplot_titles=df.columns)
for i, col in enumerate(df):
    if col not in  ['Life Exp.', 'Continent']:
        fig.add_heatmap(
            z=[[100] for i in range(len(df))] if col not in ['Population', 'GDP per capita'] else df[[col]],
            col=i+1,
            row=1,
            showscale=False,
            name=df.columns[i],
            colorscale='RdBu' if col not in ['Population', 'GDP per capita'] else 'cividis',
            texttemplate="%{text}" if col not in ['Population', 'GDP per capita'] else "%{text:,.0f}",
            textfont={'size': 14 if col != '' else 30},
            text=df[[col]])
    elif col == 'Life Exp.':
        fig.add_bar(
            x=df[col],
            y=list(range(len(df))),
            text=df[col],
            showlegend=False,
            texttemplate="%{text:,.2f}",
            marker={'color': 'steelblue'},
            orientation='h', col=i+1, row=1)
    else:
        fig.add_bar(
            x=[10 for i in range(len(df))],
            y=list(range(len(df))),
            text=df[col],
            showlegend=False,
            texttemplate="%{text}",
            orientation='h',
            col=i+1, row=1,
            marker={'color': category_to_color(df[col]), 'opacity': .8},
        )
fig.update_xaxes(showticklabels=False, showgrid=False, zeroline=False)
fig.update_yaxes(showticklabels=False, showgrid=False, zeroline=False, autorange='reversed')
fig.layout.height = 700
fig.layout.template = 'plotly_white'
fig.layout.title = 'Gapminder data – top 15 countries by population (2007)'
fig.write_html('gapminder_table_viz_top15_2007.html')
fig

From:

To: