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

Sunday, November 28, 2021

Milk_Production

World wide Milk Production 1970 - 2018


The bar race chart shows milk production of top 15 countries over a period of 1970 to 2018. Please press the play button at the bottom right to play the animation.

World Milk Day

National Milk Day - India

Background

Milk Day is celebrated in India on 26th November 2021 in memory of the father of the white revolution, Dr. Verghese Kurien. In the year 2014, the Indian Dairy Association (IDA) took the initiative to celebrate National Milk Day in India. In the year 1965, Prime Minister Lal Bahadur Shastri assigned Dr. Kurien to create the National Dairy Development Board (NDDB).

Today

In India we have come a long way in becoming the world's largest milk producer. In the 70s the then chief minister of Maharashtra State had predicted that milk would be made available through taps, like tap water. India has achieved what he meant. Making milk available all when needed. I have plotted the 10 Largest Milk Producing Countries 2020. India was at the top with 196.18 million tonnes of milk production in 2019.

Sunday, November 14, 2021

Kerala_Tour_Day2

Kerala Tour

Munnar

Munnar rises as three mountain streams merge - Mudrapuzha, Nallathanni and Kundala. 1,600 m above sea level, this hill station was once the summer resort of the erstwhile British Government in South India. Sprawling tea plantations, picturesque towns, winding lanes and holiday facilities make this a popular resort town. Among the exotic flora found in the forests and grasslands here is the Neelakurinji. This flower which bathes the hills in blue once in every twelve years, will bloom next in 2030. Munnar also has the highest peak in South India, Anamudi, which towers over 2,695 m. The stay in Munnar was blissful.

Mattupetty

Another prime draw for visitors, located about 13 km from Munnar Town, is Mattupetty. Situated at a height of 1700 m above sea level, Mattupetty is known for its storage masonry dam and the beautiful lake, which offers pleasurable boat rides, enabling one to enjoy the surrounding hills and landscape. Mattupetty's fame is also attributed to the dairy farm run by the Indo-Swiss Livestock Project, where one can encounter different high yielding breeds of cows. We did a speed boat ride, that was exhilarating.

Echo Point

About 15 km from Munnar lies the famous Echo Point. Popular for its natural echo phenomenon, one can always see the area full of eager visitors throughout the year. At an altitude of about 600 ft, people love taking a walk in the lush greenery surrounding the place. It is an ideal picnic spot. People usually come across Echo Point while making the trip to Top Station, the highest point (1700m) in Munnar, on the Munnar-Kodaikanal road. Here the clouds seem like they are just an arm’slength away and one gets a brilliant view of the valley below. This is also a prime viewing spot for the Neelakurinji (Strobilantheskunthianus), flowers which bloom once every twelve years. We bought hand made soaps and chocolates.

Eravikulam National Park

One of the main attractions near Munnar is the Eravikulam National Park. This park is famous for its endangered inhabitant - the Nilgiri Tahr. Spread over an area of 97 sq. km., this park is also home to several species of rare butterflies, animals and birds. A great place for trekking, the park offers a magnificent view of the tea plantations caressed by blankets of mists. The park becomes a hot destination when the hill slopes here get covered in a carpet of blue, resulting from the flowering of the Neelakurinji. It is a plant endemic to this part of the Western Ghats which blooms once in twelve years. We walked to the highest point possible. We did see the Nilgiri Tahr. It did offer magnificent view of the tea plantations caressed by blankets of mists. The mighty waterfall was breathtaking.
Please visit the link for more information

The Interactive Map