<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/what-can-we-learn-from-stackoverflow-data/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2017/01/stackoverflow-insights.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a target="_blank" rel="nofollow" href="http://stackoverflow.com/">StackOverflow</a>, the popular Q&amp;A site for programmers, provides useful information to nearly 5 million programmers worldwide with its database of questions and answers — not to mention the additional comments that other programmers provide. (You might be interested in the <a target="_blank" rel="nofollow" href="http://nickcraver.com/blog/2016/02/17/stack-overflow-the-architecture-2016-edition/">architecture</a>, <a target="_blank" rel="nofollow" href="https://customers.microsoft.com/en-US/story/developer-qa-site-stays-fast-innovative-and-agile-with-sql-server-2016">based SQL Server 2016</a>, required to deliver the 8.5 billion pages Stack Overflow served last year.) Since its inception, StackOverflow has has a policy of sharing all of this content under a <a target="_blank" rel="nofollow" href="https://creativecommons.org/licenses/by-sa/3.0/">Creative Commons</a> license. This represents a rich trove of unstructured data for analysis, especially given that the database of 13 million questions, 21 million answers and 54 million comments (and growing) is easily accessible via <a target="_blank" rel="nofollow" href="http://data.stackexchange.com/">StackExchange Data Explore</a>, <a target="_blank" rel="nofollow" href="https://www.kaggle.com/stackoverflow/rquestions">Kaggle</a> and <a target="_blank" rel="nofollow" href="https://cloud.google.com/bigquery/public-data/stackoverflow">Google BigQuery</a>.</p>
<p>Various data scientists have investigated this database, and learned some interesting things about programmers in the process. Here are a few examples, with links to the complete reports.</p>
<p><a target="_blank" rel="nofollow" href="https://hackernoon.com/which-programming-languages-have-the-happiest-and-angriest-commenters-ebe91b3852ed#.thwtgim4z">Sara Robinson analyzed the sentiment of Stack Overflow comments</a> (based on phrases like &quot;thank you&quot; or &quot;stupid&quot;) and found that R users seem to be the happiest, while Objective-C users are the angriest.</p>
<table width="500">
<tbody>
<tr>
<td><a target="_blank" rel="nofollow" href="https://hackernoon.com/which-programming-languages-have-the-happiest-and-angriest-commenters-ebe91b3852ed#.thwtgim4z"><img title="Happiest" alt="Happiest" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb0968b58f970d-800wi" border="0"></a></td>
<td> </td>
<td><a target="_blank" rel="nofollow" href="https://hackernoon.com/which-programming-languages-have-the-happiest-and-angriest-commenters-ebe91b3852ed#.thwtgim4z"><img title="Angriest" alt="Angriest" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb0968b594970d-800wi" border="0"></a></td>
</tr>
<tr>
<td>Tags with happiest comments</td>
<td> </td>
<td>Tags with angriest comments</td>
</tr>
</tbody>
</table>
<p><a target="_blank" rel="nofollow" href="http://stackoverflow.blog/2016/12/Developers-webmasters-and-ninjas-whats-in-a-job-title/">David Robinson analyzed developer job titles over time</a> and found terms that were on the rise (for example &quot;full stack&quot;) and terms on the decline (like &quot;webmaster&quot;).</p>
<p><a target="_blank" rel="nofollow" href="http://stackoverflow.blog/2016/12/Developers-webmasters-and-ninjas-whats-in-a-job-title/"><img title="Job titles" alt="Job titles" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b7c8c5cbe1970b-800wi" border="0"></a></p>
<p><a target="_blank" rel="nofollow" href="http://stackoverflow.blog/2016/11/How-Do-Developers-in-New-York-San-Francisco-London-and-Bangalore-Differ/">David Robinson also analyzed regional differences between programmers</a> and compared the most popular tags used in San Francisco, London, Bangalore and New York. (R is the third most popular language in New York by this measure.)</p>
<p><a target="_blank" rel="nofollow" href="http://stackoverflow.blog/2016/11/How-Do-Developers-in-New-York-San-Francisco-London-and-Bangalore-Differ/"><img title="SO regions" alt="SO regions" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b8d24f9f21970c-800wi" border="0"></a></p>
<p><a target="_blank" rel="nofollow" href="http://minimaxir.com/2016/07/stack-overflow">Max Woolf analyzed the results of the StackOverflow Developer Survey</a> and found this relationship between self-described skill level and salary.</p>
<p><a target="_blank" rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb0968b52c970d-pi"><img title="Salary" alt="Salary" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01bb0968b52c970d-800wi" border="0"></a></p>
<p>Seen any other interesting analyses of the StackOverflow data, or done one yourself? Let us know in the comments.</p>
<p> </p>
</div>
<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2017/01/stackoverflow-insights.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/Xto_q2EZvcM"></a></div>