Category Archives: Visualisations

Languages that cities love

We built a small tool that helps us recruit. It periodically pulls data off of Github for developers in India, and shows how they are connected. You can watch this 2-minute video to understand how it works.

codersearch

This data also helps us understand how popular different programming languages are across cities. For example, if we take the top cities, based on the number of users (we’ve been fuzzy about the geography and included Colombo and Singapore into the mix)…

cities

… and the top programming languages, again based on the number of users …

languages

… it begs the question: is the popularity of languages the same across cities? Or are there certain cities that love or hate certain languages?

This is the distribution of programmers across these cities:

distribution

This does not readily lead to any insights. But we could look at this number differently. If all cities had the same distribution, then what would these numbers have looked like? In other words, how many developers of each programming language would each city have had? That’s shown below:

ideal-distribution

So, for example, Bangalore actually has 321 Javascript developers. But if it had the same percentage of Javascript developers as other cities, it would just have had 263 Javascript developers. So clearly, there are more Javascripters in Bangalore than you’d expect.

The numbers below show the difference between the expected and actual number of programmers.differences

A few things stand out:

  • If you’re looking for Javascript programmers, Bangalore and Mumbai would be the two places to visit. There are considerably more Javascript programmers here than you’d expect.
  • On the other hand, if you’re looking for Java programmers, you’d be much better off visiting Delhi, followed by Chennai and Bangalore.
  • There’s only one city to visit for Python programmers – Bangalore. The rest are scattered across the minor cities. (A closer look at the data reveals that a reasonable number are in Kerala.)
  • Colombo, on the other hand, looks primarily like a Ruby shop. The focus seems to be server-side development. Javascript programmers are much rarer than normal.
  • Gurgaon is the primary PHP hub. The city is under-represented in most popular programming languages, but has a thriving group of PHP programmers (a language that Chennai, Bangalore and Mumbai seem to actively dislike.)
  • The biggest hub for iOS developers (Objective-C) is Singapore. Within India, only Pune seems to have a slightly larger than usual number of iOS developers – but that’s a meagre 20 programmers.

Whether you’re a start-up looking for your lead developers, or an IT firm recruiting open source geeks, or just a geek yourself looking for friends to hack with, we hope this gives you a idea of which city to visit next.

Making Public Service BIG with #BigData

3 Months back while the world was watching, amidst much hype, a new government announced its success with a lot of promise to one and all.

One of those promises was that of minimum government, maximum governance. This statement is as audacious as much as it’s succinct. The new government promises to reinvent public service, making it more efficient, introducing transparency and steadier and sustainable growth. With a government more tech-embracing than ever and the advent of fingertip technology to the people, a lot can be hoped. How much is achieved is yet to be seen.

To solve a problem, knowing the problem clearly is the key. This key is held by the huge loads of Data that we have hidden in the organizational silos of our government. At Gramener, we attempt to solve this problem through richer, better data-driven insights, making it available to the common Joe. The advent of Big Data in today’s world is not unknown. Big Data is a term that everyone is using today. From board rooms to college canteens, it’s now become the buzz in the more privileged world.

Making Public Service Big With Big Data

Fraud Detection

Some stats to put the problem at hand in perspective:

$314 billion is what India loses from tax evasion annually, depriving it of funds for investment in roads, ports and power.7 With so little revenue, the government must borrow more to fund a planned $1 trillion five-year infrastructure program.

$462 Billion is what India lost due to tax evasion, crime and corruption post-Independence.

Click here to see more on govt. spending.

The more startling fact is that this money is not only from the big-scale frauds that we read about in the dailies. Small, unreported frauds add up and form such bizarre numbers.

What if we could track these numbers to their last rupee like in the financial services industry? What if we could have systems to detect irregularities in each micro-transaction? Government should invest in the infrastructure to capture data from all corners of the government machinery to one place. Read about how the UK govt saved 33bn a year using Big Data Analytics.

How about Internal Security?

CCTV footages, RFIDs and scanner machines and other electronic data, although unstructured but when used with deftness, Wirelessly intercepted information, Internet browsing activities can really help extract useful information for analyses to detect crime, terrorist activities and tracking wrongdoers faster and easier and way more efficient.

Law enforcement agencies need to adapt to such practices for the greater good. This requires a conscious effort towards skill acquisition, training etc but it’s worth the effort.

Public Services

Ever thought of filling that form for your PAN-Card purely online and getting it at your doorstep without hassles. Ever wondered what it means to get updates about that skywalk in your neighbourhood, its status real-time on that smartphone like your Facebook notification.  With multiple sources of data and your details integrated into one place, your updates, services can be more and more personal.

Will there be a time when we realize the above is not a hypotheses alone? Lets hope our governments realize it soon. Watch this space out for some more thoughts on how having the data is the new necessity.

What the World is looking for

Why is Andre AgassiLarge scale sociological research has never been this easy. Google’s search suggestions are based on what people search for on their search engine. This can be a fairly good reflection of what people are currently interested in, making it a powerful tool for research. (You could also save these results and look at them over time to see trends in these preferences, but that’s a topic for a different day..)

So, to learn what questions people are asking about Andre Agassi, just go to Google’s search box and type “Why is Andre Agassi” and wait for a second. (People want to know why he’s famous, why he’s bald, why he broke up with Brooke Shields, and why he wore a wig.)

Or, to see what India is interested in learning, just type “How to” on google.co.in and you’ll find – perhaps to your surprise – that Indians want to learn:

  • how to kiss
  • how to lose weight
  • how to download youtube videos
  • how to get pregnant (clearly less important than kissing well)

Search for How to on Google India

On the other hand, the UK wants to know

  • how to make loom bands (but why?)
  • how to lose weight
  • how to make pancakes (which may not be a good idea if  you want to lose weight)
  • how to write a cv

Search for How to on Google UK

The US wants to learn

  • how to train your dragon 2 (that’s the animated film)
  • how to tie a tie
  • how to hard boil eggs
  • how to lose weight

Search for How to on Google US

What’s clear is that people of all three nations have losing weight as one of their top 4 priorities, but vary quite a bit in their preferences otherwise.

At Gramener, we put together a compilation of the search results for common questions.

Search for questions on Google

There are several nuggets in here. The world is generally curious about why Salman Khan is not married, and why he’s not in jail. But the preference and order of questions varies from country to country.

Why is Salman Khan

Focus on inventions vary a lot across regions too. Indians are the only ones who seem concerned about who invented zero. For the British, football comes ahead of the Internet and Electricity.

Who invented

You can explore these are more at https://gramener.com/search/

If you find any interesting query patterns please let us know either in the comments below or via Twitter. We’ll add it here.