What’s most welcome language among developer based on the StackOverflow survey data

Pingyuan
3 min readJan 3, 2021

Introduction

For this research, we will draw our insight based on Stack overflow survey data 2018–2020, 3 main below questions need to be tackled :

  1. What’s the most popular language that among the last 3 year?
  2. What’s the rapidly growing language that among the last 3 years?
  3. What’s depreciated language among the last 3 years?

Part I: What’s the most popular language that among the last 3 year?

Let’s review the last 3 years of data and get a rank by measuring their average voting % from survey data. Interesting to see that JS, HTML/CSS ranks as the top 2 common languages while SQL ranks as the 3rd. This implies that a majority of the developer is working on Web application which is mainstream of state-of-art software architecture. On the other hand, SQL as the main DB query language takes the following. JAVA, Python as most common backend language still occupy 4th and 5th place.

Part II: What’s the most rapidly growing language that among the last 3 year?

From 2018 to 2019, JS, Python, HTML/CSS grew most fast than other languages. The possible reason could be the strong popularity of web applications based on JS/HTML/CSS as well as Python which more popular with the Data Science domain.

From 2019–2020, the growth mostly focuses on relatively new languages like Pearl, Hackshell, Typescript, etc. An interesting reason could be due to the Covid-19 issue worldwide, the coder has more time to put on learning a new skill which shows more promising functionality.

Part III: What’s depreciated language that among the last 3 years?

From 2018 to 2019, VB.Net/VB 6, Matlab, Groovy continues depreciating. The strange thing is Perl ranked as one of the depreciating languages 2018–2019, on the other hand, it ranked as the most fast-growing language in 2019-2020. Those results may contradict each other. The possible reason to explain that is that Perl is still a kind of minority language that is easily missed in the survey data in 2019 data. ( We treated NaN value as Zero in the data wrangling )

From 2019 to 2020, we see most of the common language is somehow depreciated like Shell/BashShell/PowerShell, JS/HTML/CSS, SQL

Conclusion

From analyzing the Stackoverflow survey data 2018–2020, we can draw our conclusion as below:
1. What’s the most popular language among the last 3 years?
JS HTML/CSS ranked as Top 3 implies that WEB development is quite popular these year while SQL/Java/Python/Bash/Shell/PowerShell/C#/C/PHP/C++ takes following
2. What’s the rapid growing language that among the last 3 year?
In 2019, it seems JS, Python,HTML/CSS ,SQL grows faster than others while in 2020, Perl,Haskell,Typescript,draft,Rust grows faster
3. What’s depreciated language among the last 3 years?
In 2019, it seems Vb.Net, Matlab, Groovy, Perl, VB6 depreciated hugely than others . In 2020, Bash/Shell/PowerShell, JS, HTML/CSS, SQL depreciated more than others.

For more info, you can visit my Github repository

--

--