Sunday, December 26, 2021

How chart can be made interactive using Altair Vega-Lite Python and Pandas.

Interactive Altair Vega-Lite Plot
using Python and Pandas

Milk Production over years

Click a country name, to see its chart

MMT is million metric tonnes

India is #1, followed by #USA


The interactive Chart


The code is available on my github account.

Wednesday, December 15, 2021

Indian_Unicorns_Plots

Indian Unicorns


The data was downloaded from web, cleaned using Excel Power Query.

Total number of Unicorns is 51.


Total Valuation of the unicorns 148.45 USD Billion


The total valuation of these unicorns is more than market capitalisation of Infosys and Wipro added together.


1) Valuation plotted against cities and in turn Industries


BengaluruGurugramMumbaiNew DelhiPuneNoidaFaridabadThaneChennaiJaipurEdtechFintechInternetAutoSupply chainHealthMobile_telecommE/comm DTCOtherTravelE/comm DTCSupply chainFintechHealthInternetFintechEdtechE/comm DTCFintechE/comm DTCE/comm DTCFintechE/comm DTCE/comm DTCOtherE/comm DTC0.025.4Valuation ($B)BengaluruChennaiFaridabadGurugramJaipurMumbaiNew DelhiNoidaPuneThaneCity

2) Count of Unicorns per industry per city


The size of the circle is proportional to valuation.

BengaluruGurugramMumbaiNew DelhiPuneNoidaFaridabadThaneChennaiJaipurEdtech3Fintech7Internet7Auto2Supply chain3Health1Mobile_telecomm1E-comm DTC1Other1Travel1E-comm DTC4Supply chain3Fintech1Health1Internet1Fintech2Edtech2E-comm DTC1Fintech1E-comm DTC1E-comm DTC2Fintech1E-comm DTC1E-comm DTC1Other1E-comm DTC13.011.9Valuation ($B) [sum]BengaluruChennaiFaridabadGurugramJaipurMumbaiNew DelhiNoidaPuneThaneCity [csvDistinct]

Credit:app.rawgraphs.io for graphics and CB Insights for data

Saturday, December 11, 2021

KeralaDay3

Kerala Day 3

Periyar Tiger Reserve

We started from Munnar. We came down a moutain range and climed up another. I did not note down the geo locations while coming down and hence those are missing. While we did not see tigers and elephants we did see the following. Great cormorant, Woolly-necked stork, Sambar deer, Bengal monitor, White-throated kingfisher, Brahminy Kite and Gaur.
Please see the photos my facebook.

The path taken



The above interactive visualization was made using Python and Folium. I wanted to make a visualization with Folium for last 2 years!
The folium library in turn uses the leaflet library to render the web-page visualisation. Using Folium I do not have to worry about the HTML, CSS, Javascript code! Plus Python allows me to hold my data in pandas and manupulation of the data becomes convenient. Customizing markers and icons becomes easy using both the pandas and folium libraries.

Folium was not part of the standard Anaconda distribution. It had to be downloaded by using the following command.
$ conda install folium -c conda-forge
at the Anaconda promo. But before that I created a separate environment for folium (folium_project) by closing the base environment. The command was
$ conda create --name folium_project --clone base

Folium allows one to leverage the power of leaflet by just writing a few lines of code. The web-page visualization including its code is on my github account.

Friday, December 3, 2021

Indian Unicorns 2021

The Indian unicorns is a success story.
I have captured its essence in the dashboard below.

Bangalore City

and

Fintech Industry

leads the show.

The Unicorn Dashboard made using Tableau