Data Visualization Blog Part 3:Part A To select a particular range of data from the google docs

The part 2 was a simpler example to create a chart on the google doc where we could manipulate the data as per our whims and fancies.

 In reality the situation is quite difficult as the client google doc or even yours can have a huge amount of data.

We need to manipulate the code to select a range of data

We are running a series of two subparts of this blog Part A and Part B.

 Part A I have taken reference entirely from the prof blog "http://visual.yantrajaal.com/2013/12/creating-google-charts-from-google-docs.html"

 In this we need to look at the chart based on the following selection of the data

 1) Data to be picked up from sheet named "Demo3"

 2) Within this sheet, from the range C3:I23

 3) Within this range from the columns C, D, G, H

4) Given the nature of the data we would like to multiply column G by 1000 before it is plotted #
Sheet 2 Chart - Sheet, Range, Cols

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