Data Visualization Part 4: Plotting Cities in a map

As part of learning continues we would plot the cities in the google map. The exercises mostly have been taken from https://developers.google.com/chart and http://visual.yantrajaal.com/2013/12/cities-of-india.html.

Interesting Isn't It?

We have a data that contains the number of registered vehicles in different years

Steps to be followed:

1) The doc link is https://docs.google.com/spreadsheets/d/1rrz2aobU3Htc4Ez6Alcga_ROhRo2ZyzKsrkmL-cTOT4/edit#gid=0 where the shet is CityWise 2 and range is identified by sheet = CityWise2

2) The range is identified by range = B2:M23


Comments

Post a Comment

Popular posts from this blog

Kabaddi Match: Lets meet at the arena!! Aa jao Dam Dikhane!!!

Image
Kabaddi is one of the oldest sports of India.   It has been the national game of Bangladesh and Nepal. The game is a test of strength and unity. The game continues till the other team members oust the last player. The game tests ones mental, physical and interpersonal skills. The onus of one lies on other members hence the trust is the other key factor. The statistical programming languages are on the same fighting arena. Lets look around us we have R, Python, SPSS, SAS, Stata among many other. Which one is the best? 1)We have problem statement on which analysis needs to be done any language can be used to build up on the solution as the languages are a tool whereas logic remains same behind these. 2)R is a free open courseware whereas others are costly in terms of licensing costs. Meanwhile R has been used most freely SAS/Stata is more powerful to handle more statistical languages and techniques. 3)R being free is the most documented and used for the research and t...
Read more

Text Analytics Using R - Part A: Extraction of reviews of galaxy s4 product reviews in flipkart

Hi Folks!! This is my first blog in the series where I would love to share my experimentation with text analytics using R.. The initial 3 parts we would concentrate our efforts towards scrapping or extraction of reviews of samsung s4 product from the flipkart. We would be understanding the code bit by bit to get a hang of it and make it simpler to follow for a novice who is just enticed and want to start afresh here. When I am starting with -- this means R code  1) R is an open source platform and in case you want to have added functionalities you load the library --library(RCurl) --library(XML) RCurl:    Provides functions to allow one to compose general HTTP requests and provides convenient functions to fetch URIs, get & post forms, etc. and process the results returned by the Web server.  ( Ref:  https://cran.r-project.org/web/packages/RCurl/index.html) XML:This collection of functions allow us to add, remove and replace children from an X...
Read more

Replace your Social Media with the New Age Social Media: Fitness with Motivation

Image
I had quit Social Media a year ago especially Instagram and as any other millennial hooked to Social Media the minute I woke up I wanted to get hold my Phone and checking immediately the feeds. More than the feeds it was just adding to the ever growing anxiety and also stealing away the beautiful moments which you spend online. I took a very drastic step some 7-8 Months Back to quit Instagram. It was not sudden but a gradual deaddiction mechanism I followed. I deactivated Instagram and we are allowed to activate/deactivate once per week. It was kind of sheer stupidity of my actions that I was following then came the Day I finally deleted my Instagram Account. Post that day It was a sudden vacuum that came but what really helped me was I suddenly have the new found time to pursue my Activities. I started drawing and below is one of my new passtimes I also started actively working out when I came across an interesting App Strava. I was suddenly making new friends and...
Read more