<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d8211560\x26blogName\x3dTech+Tips,+Tricks+%26+Trivia\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttp://mvark.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttp://mvark.blogspot.com/\x26vt\x3d-5147029996388199615', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe" }); } }); </script>

Tech Tips, Tricks & Trivia

by 'Anil' Radhakrishna
An architect's notes, experiments, discoveries and annotated bookmarks.

Search from over a hundred HOW TO articles, Tips and Tricks


The Top Programmers in India according to StackOverflow

A recruiter looking for resources in a narrow area of a technology asked me if there was a way to know the hottest talent in that field in the country.

Finding the right candidate for a job is easier said than done. However one way to know about the top programming talent in India is to check the reputation points of users on StackOverflow, the internet's best known online forum for programmers. If you searched online for an answer to a programming question, the odds are very high that an answer from StackOverflow would be among the top 10 results thrown by popular search engines.

I pointed him to the StackOverflow site and asked him to look for users from India who answered questions with the tag of that technology area. This is as easy as finding a needle in a haystack.

Luckily, Stack Exchange, the parent network under which StackOverflow and 100+ other Q&A sites exist, provides an API and a database to query for data collected through the sites. I tried this query at StackExchange Data Explorer and found out that there are currently 148 members from India with a reputation of 10,000 and above:
select Id  as [User Link], Location, Reputation from Users 
where Location like '%India' and Reputation > 10000
order by Reputation desc



It may be a little narrow-minded to slot developers by country or region but if there has to be a measurable way to find out, a StackOverflow user's internet points provide one facet. The ranks may not be wholly correct as some programmers may have chosen not to reveal their location details or were too lazy to fill out their personal details on StackOverflow.

Labels: ,

Tweet this | Google+ it | Share on FB

« Home | Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »
| Next »

Posted by Blogger Lokesh | 3/07/2014 11:44:00 AM

-- top users: INDIA
-- List of India-based users by reputation score. Query, naturally, by an Indian user.

SELECT
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
Reputation
FROM
Users
WHERE
LOWER(Location) LIKE '%india%'
OR UPPER(Location) LIKE '%INDIA'
ORDER BY
Reputation DESC;

-- Calculate Percentile--
-- ((1-userRank/totalUsers)*100)    



Posted by Blogger Anil | 3/07/2014 12:43:00 PM

Thanks Lokesh for sharing your query. The results are insightful. There are more than 26K SO members from India (who have identified themselves) with at least 10 "internet points"/reputation.    



»

Post a Comment