Public Cloud revenue 2022 to 2026

#vba

#excel

#powerpoint

Organising data in spreadsheets

The guide is designed so that you may down load it and keep it handy with you for a reference.

For a detailed explanation, please click the blog post.

The below guide explains how to organise data in spreadsheets.

 

Nifty50_index

Nifty50_Index: Rs 2 trillion AUM mark has been breached by ETFs and Index funds tracking the Nifty 50 Index

• April_2022: AUM reaches Rs 2 trillion
• Aug_2020: AUM reaches Rs 1 trillion
• Dec 2001: First ETF linked to Nifty50 - launched

Indian_Unicorns_by_2025

 India could have 250 unicorns by 2025.

Growth of Indian Unicorns

#vba

#powerpoint

#excel

#India

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.

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

2) Count of Unicorns per industry per city

The size of the circle is proportional to valuation.

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

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.