Skip to content

THREE MINUTE CHART

In the next three minutes, you will build a professional bar chart from scratch.

image-20210805184952349

There is an interesting article on Medium titled "Tutorial on Building a Professional Bar Graph in Plotly Python" that shows how to build a very nice plot using Kaggle data.

Below the very cool plot complete with commentary and everything. We want to do something similar, from zero, in under three minutes.

image-20210805185332459

1 - GET DATA (45 seconds)

Go to the article, click on the link to the data, download the data as a csv file.

2 - OPEN DATASET AND RENAME COLUMNS (45 seconds)

Right-click on the file and open it in Excel. Rename the "created_at" column as "Date". Close and save the file. If you have time, you can rename the "category_name_1" column into "category"

image-20210805190138154

3 - LOAD DATASET ON 'MPARANZA.COM APP (30 seconds)

Open 'Mparanza.com, and click on "Open Beta".

Open the upload widget and load the file.

image-20210805190946809

Wait until the little munchkin has finished running.

image-20210805191115619

Scroll down to the submit button.

image-20210805191329905

4 - RUN CHARTING (10 seconds)

Hit "Submit".

Three charts should appear below the submit button.

image-20210917144244695

Nice, but there is no commentary ☹️.

5 - ADD COMMENTARY (50 seconds)

Make up a commentary - max 100 characters. For example, "Growth driven by doubling of Mobiles sales, Appliance & Entertainment also strong" for the "by category" chart.

Type your commentary in the text box that above the chart. Click again on submit when done.

image-20210805193928839

Click on submit.

Now the chart has a commentary above the title 😎.

image-20210917125412483