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

Cloud Platform & Communities summer experiences in Switzerland & Italy

A couple of weeks ago with the European developers communities team we started activities with some new communities specialized in Machine Learning & Cloud Platform.  We also participated in some activities and as part of this initiative, we visited two communities with a practical program proposal  based on Cloud Technology. Cloud Study Jam . We shared a very nice activity with SOAI chapter in Zurich . Here we present the basic elements of the Cloud Study Jam proposal and we also explored a workshop with the introduction to Cloud ML engine. Cloud Study Jam Overview: *a core element of Cloud Study Jam format is the utilization of qwiklabs platform to provide tech tutorial & online labs. Cloud Study Jam, workshop "Cloud ML Engine: Qwik Start": In addition to that, we shared another very nice activity with Machine Learning Milan . Similar approach with Cloud Study Jam Overview and then we provided a workshop related to AutoML Vision. Cloud Stud...
2 comments
Read more

Model Top-Down Analysis in software products.

In this paper will discuss an approach from the environmental variability of presentation software solutions. Focusing on the concept of software product family. If we play the role of architects:           How many times we try analyzing common feature in different forms of presentation?           How many times have we requested a mobile solution attached to our traditional solution?           Are simply the decisions to implement new presentations of the software solution? Here is an introduction to the concept…. Software organizations are building a product vision characterized by the development and evolution of product families instead of creating a specific software product for a given client. This trend is driven by several factors such as, business strategy, diversity computing devices and reuse of software components in complex software systems. Howeve...
1 comment
Read more

Community centered care data analysis, times of Covid-19

For the past few weeks, the global health emergency caused by Covid-19 has put many questions in my thoughts, from general to more specific in many dimensions. We all know that we should prepare better in the future and this morning reviewing the concept of community centered care “ At the Epicenter of the Covid-19 Pandemic and Humanitarian Crises in Italy: Changing Perspectives on Preparation and Mitigation ,(2020), Nacoti, Ciocca, ... ” added by the hospital in Bergamo Italy, sparked my interest... how to be prepared, how potentially implement and be smart into the distribution, finally using data from Korea( KCDC  and DS4C ), I started analyzing looking for responses. From the data analysis perspective if we can understand the entities and important variables geographically distributed in a region, we can analyze the activity of this approach at least in theory dimension. Also with an analysis of infection-cases we can explore the more affected regions and maybe create a d...
Post a Comment
Read more