Menu

How To Create A Bar Race Animation Using Excel And Python

Language:

In this tutorial, I will show you, how to create a Bar Race Animation using Excel and Python. Usually, it was very time-consuming coding this kindly of animation from scratch. Luckily, there is a Python library called “bar-chart-race”.

 

📝 Resources:

Official documentation of the “bar-chart-race” library:

► https://www.dexplo.org/bar_chart_race/

Download the files and script I used in the tutorial here:

Download Here

 

👩‍💻 Source Code:

 
import pandas as pd
import bar_chart_race as bcr

df = pd.read_excel('Salesdata.xlsx')
df.set_index('Date', inplace=True)

# Documentation: https://pypi.org/project/bar-chart-race/
bcr.bar_chart_race(
    df=df,
    filename='Salesdata.mp4',
    orientation='h',
    sort='desc',
    n_bars=6,
    fixed_order=False,
    fixed_max=True,
    steps_per_period=10,
    interpolate_period=False,
    label_bars=True,
    bar_size=.95,
    period_label={'x': .99, 'y': .25, 'ha': 'right', 'va': 'center'},
    period_fmt='%B %d, %Y',
    period_summary_func=lambda v, r: {'x': .99, 'y': .18,
                                      's': f'Total Sales: {v.nlargest(6).sum():,.0f}',
                                      'ha': 'right', 'size': 8, 'family': 'Courier New'},
    period_length=500,
    figsize=(12, 6),
    dpi=300,
    cmap='dark12',
    title='Sales by stores in USD',
    bar_label_size=7,
    tick_label_size=7,
    scale='linear',
    writer=None,
    fig=None,
    bar_kwargs={'alpha': .7},
    filter_column_colors=False)