Skip to main content

#BuenosAires birthplace of great developers? Analysis according #stackexchange

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á, Colombia650
Lima, Perú515
Santiago, Chile750
Sao Paulo, Brazil1845
Mexico City, Mexico582
Buenos Aires, Argentina1395
Total5737
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 use better regular expressions [more accurately]. Later we added the relevance of the developers of each country and here the result chart
Licencia Creative Commons
#BuenosAires birthplace of great developers? Analysis according #stackexchange por Nicolas Bortolotti se distribuye bajo una Licencia Creative Commons Atribución-CompartirIgual 4.0 Internacional.

Comments

Popular posts from this blog

Google Assistant, simpleness of interaction to call a webhook

The creation of an application using Google Assistant is very simple and represent a big impact to interact with users in diverse environments and particularly in home Hey Google ...Where is my dog? If we plan to connect a security camera system, the challenge of finding my pet in an automated way is more feasible, then I will give more details of how I intend to do it. Now we are going to prepare the functionality of the assistant’s requests. To create an agent and interact with Google Assistant , we will use DialogFlow . Let's see the main elements to create an agent, and using this agent call a webhook with some functionality. * Part of the objective will be to try to prepare the logic of interaction with a home security system * Arlo System From the DialogFlow console, we will create a new agent: We can customize different support languages, for this case I will use English to facilitate the testing of the agent. [You can include Spanish and also go in

Architectural reviews of software engineering, a simple approach

I wanted to share an analysis of a very interesting work where they develop concepts related to software architecture solutions. We know that the architecture of a software solution is very important to the success of a development. In my experience as a software architect in previous works dedicated to the software industry, very often expressed an effect of "do not have time to complete thearchitectural review. " What is the justification? if we can justify it. It is very expensive,time consuming, depending on the architectural documentation of the solution, a scenario that could never discuss "is a small project with a limited life cycle, with minimum documentation" So what options do we have when the project has these characteristics, and we'resure that we execute architectural reviews? “However, in spite of the demonstrated benefits of architecture reviews, many projects are unable or unwilling to use them. These projects tend to have the following cha

An service option to interact with Arlo cameras

Interacting with the Arlo system is very attractive for who acquired the hardware and enjoy all the benefits of these equipments. Which by the way are very good, flexible and full of good properties. To interact with this system with a developer's perspective I found two interesting python-based projects. Python-arlo:  https://github.com/tchellomello/python-arlo Arlo:  https://github.com/jeffreydwalter/arlo Both propose different features but Python-arlo has a good documentation and structure of its API. The objective for this integration is to support applications from Google Assistant , for this reason I  integrated the service into an App Engine flex env project. I included flask as an interaction framework and with this I have the option to use a service interface. This would be our ideal architectural map: We looking for continue with the application initiated from: Hey Google ... Where is my dog? * Of course we will have to implement