Live TVLive TV
»
4-min read

Graphical analysis of the Padma Awards 2012

Soumyadip | http://soumyadip.com

First published: January 25, 2012, 7:49 PM IST | Updated: January 25, 2012
facebook Twitter google skype whatsapp
Graphical analysis of the Padma Awards 2012
We plotted the data in charts to reveal hidden dimensions that might not be obvious in the lengthy list.

On the eve of the Republic Day, the Government of India announced the list of 2012 Padma awardees. We did a little number crunching and plotted the data on charts to reveal hidden dimensions that might not be obvious in the long list of Padma Vibhushan, Padma Bhushan and Padma Shri awardees.

Awardees from UPA and non-UPA ruled states (pie chart)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=I19%3AJ21&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"in","colors":["#3366CC","#DC3912","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 9"}

Awardees from UPA and non-UPA ruled states (bar diagram)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=1&headers=1&range=I19%3AJ21&gid=0&pub=1","options":{"reverseCategories":false,"title":"","backgroundColor":"#FFFFFF","legend":"in","theme":"maximized","logScale":false,"reverseAxis":false,"hAxis":{"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},"hasLabelsColumn":false,"isStacked":false,"width":350,"height":350},"state":{},"view":"{"columns":[0,1,2]}","chartType":"BarChart","chartName":"Chart 10"}

Number of awards

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=1&headers=1&range=I44%3AJ46&gid=0&pub=1","options":{"reverseCategories":false,"title":"","backgroundColor":"#FFFFFF","legend":"in","theme":"maximized","logScale":false,"reverseAxis":false,"hAxis":{"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},"hasLabelsColumn":false,"isStacked":false,"width":350,"height":350},"state":{},"view":"{"columns":[0,1,2]}","chartType":"BarChart","chartName":"Chart 6"}

Awardees by categories (bar diagram)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=1&headers=1&range=I33%3AJ42&gid=0&pub=1","options":{"vAxes":[{"title":null,"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"reverseCategories":false,"title":"","backgroundColor":"#FFFFFF","legend":"in","theme":"maximized","logScale":false,"reverseAxis":false,"hAxis":{"maxAlternations":1},"hasLabelsColumn":false,"isStacked":false,"width":350,"height":350},"state":{},"view":"{"columns":[0,1,2,3,4,5,6,7,8,9]}","chartType":"ColumnChart","chartName":"Chart 7"}

Awardees by categories (pie chart)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=I33%3AJ42&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"in","colors":["#3366CC","#DC3912","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 8"}

Awardees by countries

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=L46%3AM52&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"none","colors":["#3366CC","#DC3912","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 3"}

Awardees by state (bar diagram)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=1&headers=1&range=L9%3AM36&gid=0&pub=1","options":{"vAxes":[{"title":null,"minValue":null,"viewWindowMode":"pretty","viewWindow":{"min":null,"max":null},"maxValue":null},{"viewWindowMode":"pretty","viewWindow":{}}],"reverseCategories":false,"title":"","backgroundColor":"#FFFFFF","legend":"in","theme":"maximized","logScale":false,"reverseAxis":false,"hAxis":{"maxAlternations":1},"hasLabelsColumn":false,"isStacked":false,"width":550,"height":350},"state":{},"view":"{"columns":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27]}","chartType":"ColumnChart","chartName":"Chart 4"}

Awardees by state (pie chart)

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=L9%3AM36&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"in","colors":["#3366CC","#DC3912","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 5"}

Awardee gender

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=I48%3AJ49&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"none","colors":["#ff9900","#DC3912","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 1"}

Living and dead awardees

{"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0Aj5L7T5iH6XZdGNwdmhWNk1FMXhwYkxmYTMyODViRnc&transpose=0&headers=0&range=I51%3AJ52&gid=0&pub=1","options":{"vAxes":[{"viewWindowMode":"pretty","viewWindow":{}},{"viewWindowMode":"pretty","viewWindow":{}}],"title":"","backgroundColor":"#FFFFFF","legend":"none","colors":["#f1c232","#444444","#FF9900","#109618","#990099","#0099C6","#DD4477","#66AA00","#B82E2E","#316395","#994499","#22AA99","#AAAA11","#6633CC","#E67300","#8B0707","#651067","#329262","#5574A6","#3B3EAC","#B77322","#16D620","#B91383","#F4359E","#9C5935","#A9C413","#2A778D","#668D1C","#BEA413","#0C5922","#743411"],"theme":"maximized","is3D":false,"hasLabelsColumn":true,"hAxis":{"maxAlternations":1},"width":350,"height":350},"state":{},"view":"{"columns":[0,1]}","chartType":"PieChart","chartName":"Chart 2"}

facebook Twitter google skype whatsapp