In this article I would like share a very simple analysis about developers and their relevance in 6 of the most important capitals of #LatAm. Based on data proposed by [http://data.stackexchange.com/] we will study the behavior of developers [all disciplines] in [Buenos Aires, Sao Paulo, Santiago de Chile, Lima, Bogota and Mexico City] I used the #Users table, the complexity begins when the analysis of the #Location attribute shows a quite variable string. Anyway it's possible identify the data of cities without problems. For this sample/snapshot I identified over 5K developers. Bogotá, Colombia 650 Lima, Perú 515 Santiago, Chile 750 Sao Paulo, Brazil 1845 Mexico City, Mexico 582 Buenos Aires, Argentina 1395 Total 5737 I used a very simple model query like this: Select count(*), Sum(reputation),Location from Users Where Location LIKE 'key%' Group by Location Order by Sum(reputation) Then using some filters... if you want avoid this step you can us...
Innovation, Technology, Research & Tech Communities