Padma Shri (also Padmashree) is the fourth highest civilian award in the Republic of India, after the Bharat Ratna, the Padma Vibhushan and the Padma Bhushan. Awarded by the Government of India, it is announced every year on India’s Republic Day.
The first time you open up the wikipedia page it’s hard to relate just looking at the HTML Tables that which state has bagged the maximum no. of awards and which field has performed well in a particular year and who are the personalities in a specific field who represent their states or how states perform consistently years over the years.
I was looking at the wikipedia page to collect the data through my eyes to gather the information as much as I can but somehow it didn’t worked out to give an intensive and comprehensive horizon of the information that I was looking for. Then suddenly I thought of why not visualizing this entire data on a dashboard and the next question pops up but How?
Since I have used Tableau earlier on a couple of occasions earlier so thought to give it a try for this entire exercise of developing an information graphics of the Padma Shri Awards.
Next the challenge lies in getting the table from Wikipedia to Tableau, However that was not a uphill task for me since python was in my tool bag. I used Beautiful Soup, which is a python library to pull the data from HTML & XML files. So it wasn’t a time taking task to write a simple python script using Requests & Beautiful Soup to grab the data from Wikipedia to an Excel file.
I uploaded this excel file in Tableau and ready to do the magic but hold-on do I have a plan what I’m looking for and how I’m gonna visualize the entire data set to make it an easy read for anyone to overcome the challenge of what I’m trying to do with my eyes earlier.
DIY StoryTelling with Data
Do your own Research
Ask yourself first, why I’m doing these analytics? it’s all about looking at the information through the medium of numbers and getting a better insight from the data and visualize every corner of the information that your data reveals.
Plan your Story
As learnt in schools every story has a beginning, Middle and an End, Think through to get a clear storyline for your audience. Ensure the take away for your audience is a tangible bit of Information they can use.
Analysis should be short & Informative
Tools are now ubiquitous and they came with a range of visualizations — Bar, Pie, Tables & Line charts. However the focus is on Data exploration and a meaningful insight of your data. so using these tools with utmost intelligence and sharpness is the key for a better visualization of your data and story telling.
So In my case I was interested to know which states has bagged maximum number of awards from 2010–2017 and what are the fields where maximum awards are gained over the years, Also how user can look for the Awardees names in a specific filed for an individual state.
Since I have a clear goal in my mind to plot I have started using the Tableau worksheets to craft my single visualizations before putting them together to create an interactive Dashboard.
Using Tableau is really an easy & efficient way to visualize the data and give your data a fantastic overview in the form of story.
Below is my 1 week of efforts looks like in Tableau Public Forum, here
To read original post, click here
Comment
Hi Guys,
I created a code for extraction of the above dataset from wiki and feeding it to an excel workbook.
https://github.com/gitakshay/PadmaShri
Let me know your feedback !!
Thanks
Hi Vinay,
can you please share a sample of Python to extract data from Wiki Pedia to table. That would be very useful as i am learning python now
Thanks In Advnace
Regards
Mohan
Posted 1 March 2021
© 2021 TechTarget, Inc.
Powered by
Badges | Report an Issue | Privacy Policy | Terms of Service
Most Popular Content on DSC
To not miss this type of content in the future, subscribe to our newsletter.
Other popular resources
Archives: 2008-2014 | 2015-2016 | 2017-2019 | Book 1 | Book 2 | More
Most popular articles
You need to be a member of Data Science Central to add comments!
Join Data Science Central