I was not sure whether I would make maps showing medals won by different countries in Rio Olympics 2016 or not. But, I was still free to watch Bollywood movies and work with GIS on the side. My favorite pastime? Yes ! I love doing it and it has been my favorite way of Worktainment. Did I just invent the new word? No, I didn't. Apparently, there is already a website with this name- http://worktainment.com/. Poor me- why people invent words ahead of me? Hahaha!
Let's come to the medal map preparation process. I had a basic framework ready from the work I did for last blog post.Wikipedia also has a table of data showing medals won by different countries in tabulated format. I just had to copy and paste data in excel sheet. Wikipedia also has all the maps prepared, though.
There was an issue with the table I created from the information I copied from Wikipedia. I tried for three hours to join medals table with country shapefile in GIS. I kept getting null values every time I try. I went through every country names-no issues there. I figured out there were extra spaces after the word in the excel cells. I fixed that- still no solutions. I accidentally figured out the solution. Apparently, there were extra spaces in front of the country name which were the main culprits. I only had 87 countries on the list so it only took me few minutes to go to individual cells and remove extra spaces. Finally, I made these few maps.
Maps are worth thousands of words. I just want to say few words- There were many athletes which didn't belong to any country boundary on the map. They played as a refugee team and an independent athlete team dubbed the Independent Olympic Athlete (IOA) in Rio Olympics. They won two medals; one gold and one bronze. Bravo!!
Total Medals Won by Different Countries
Gold Medals Won by Different Countries
Silver Medals Won by Different Countries
Bronze Medals Won by Different Countries
No comments:
Post a Comment