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.
Labels:

Comments

Post a Comment

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
Post a Comment
Read more

SMI Developer Day - Session 2 was pure developers adrenaline

A new session of SMI Developer Day program has been conducted at the Cultural Center Borges in Buenos Aires. The event was pure adrenaline to the ecosystem of technology development in Google. A great attendance and I could feel pure adrenaline at the conference on May 8 at the Cultural Center Borges in the context of SMI Developer Day event . In this opportunity we present an approach to development Web solutions , innovative technologies such as HTML5 and present an option for persistence in disconnected scenarios. A great conversation environments with a lot of questions, showed the state of motivation of the developer community in the region. A region full of talent. A region that every day becomes more involved in technology , mobility , computing in the cloud. Furthermore, this region strengthens a vision of entrepreneurship, and drive an amazing ecosystem. An excellent shared moment with the community
1 comment
Read more

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
Post a Comment
Read more