{ "cells": [ { "cell_type": "markdown", "metadata": { "_uuid": "b8aa609b313e2325aea21ba9b2162bb6a1fa45e0" }, "source": [ "# Stack Overflow Survey 2018: Technology Preferences\n", "\n", "In this notebook I'll create rankings of technologies, that respondents of the [Stack Overflow Survey 2018](https://insights.stackoverflow.com/survey/2018/) worked with in the past, want to work with in the future, where these overlap and where not. The survey asked 4 similar questions about languages, databases, platforms and frameworks, below is the one about languages:\n", "\n", "> Which of the following programming, scripting, and markup languages have you done extensive development work in over the past year, and which do you want to work in over the next year? (If you both worked with the language and want to continue to do so, please check both boxes in that row.)\n", "\n", "## Setup\n", "\n", "The code in the next cell imports the Python libraries that'll be used, sets display and style parameters, loads the data from the CSV file [made available on Kaggle](https://www.kaggle.com/stackoverflow/stack-overflow-2018-developer-survey) and outputs the first few rows." ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "_uuid": "573c3476026e2b3de75a102979101d34a025b6e5" }, "outputs": [ { "data": { "text/html": [ "
\n", " | LanguageWorkedWith | \n", "LanguageDesireNextYear | \n", "DatabaseWorkedWith | \n", "DatabaseDesireNextYear | \n", "PlatformWorkedWith | \n", "PlatformDesireNextYear | \n", "FrameworkWorkedWith | \n", "FrameworkDesireNextYear | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "JavaScript;Python;HTML;CSS | \n", "JavaScript;Python;HTML;CSS | \n", "Redis;SQL Server;MySQL;PostgreSQL;Amazon RDS/Aurora;Microsoft Azure (Tables, CosmosDB, SQL, etc) | \n", "Redis;SQL Server;MySQL;PostgreSQL;Amazon RDS/Aurora;Microsoft Azure (Tables, CosmosDB, SQL, etc) | \n", "AWS;Azure;Linux;Firebase | \n", "AWS;Azure;Linux;Firebase | \n", "Django;React | \n", "Django;React | \n", "
1 | \n", "JavaScript;Python;Bash/Shell | \n", "Go;Python | \n", "Redis;PostgreSQL;Memcached | \n", "PostgreSQL | \n", "Linux | \n", "Linux | \n", "Django | \n", "React | \n", "
2 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
3 | \n", "C#;JavaScript;SQL;TypeScript;HTML;CSS;Bash/Shell | \n", "C#;JavaScript;SQL;TypeScript;HTML;CSS;Bash/Shell | \n", "SQL Server;Microsoft Azure (Tables, CosmosDB, SQL, etc) | \n", "SQL Server;Microsoft Azure (Tables, CosmosDB, SQL, etc) | \n", "Azure | \n", "Azure | \n", "NaN | \n", "Angular;.NET Core;React | \n", "
4 | \n", "C;C++;Java;Matlab;R;SQL;Bash/Shell | \n", "Assembly;C;C++;Matlab;SQL;Bash/Shell | \n", "SQL Server;PostgreSQL;Oracle;IBM Db2 | \n", "PostgreSQL;Oracle;IBM Db2 | \n", "Arduino;Windows Desktop or Server | \n", "Arduino;Windows Desktop or Server | \n", "NaN | \n", "NaN | \n", "
\n", " | database_liked | \n", "database_new | \n", "database_worked_with | \n", "framework_liked | \n", "framework_new | \n", "framework_worked_with | \n", "language_liked | \n", "language_new | \n", "language_worked_with | \n", "platform_liked | \n", "platform_new | \n", "platform_worked_with | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "{MySQL, Amazon RDS/Aurora, Redis, PostgreSQL, Microsoft Azure (Tables, CosmosDB, SQL, etc), SQL Server} | \n", "{} | \n", "{MySQL, Amazon RDS/Aurora, Redis, PostgreSQL, Microsoft Azure (Tables, CosmosDB, SQL, etc), SQL Server} | \n", "{Django, React} | \n", "{} | \n", "{Django, React} | \n", "{Python, HTML, CSS, JavaScript} | \n", "{} | \n", "{Python, HTML, CSS, JavaScript} | \n", "{Linux, Firebase, Azure, AWS} | \n", "{} | \n", "{Linux, Firebase, Azure, AWS} | \n", "
1 | \n", "{PostgreSQL} | \n", "{} | \n", "{PostgreSQL, Redis, Memcached} | \n", "{} | \n", "{React} | \n", "{Django} | \n", "{Python} | \n", "{Go} | \n", "{Python, Bash/Shell, JavaScript} | \n", "{Linux} | \n", "{} | \n", "{Linux} | \n", "
2 | \n", "{SQL Server, Microsoft Azure (Tables, CosmosDB, SQL, etc)} | \n", "{} | \n", "{SQL Server, Microsoft Azure (Tables, CosmosDB, SQL, etc)} | \n", "{} | \n", "{} | \n", "{Angular, React, .NET Core} | \n", "{C#, HTML, CSS, JavaScript, TypeScript, Bash/Shell, SQL} | \n", "{} | \n", "{C#, HTML, CSS, JavaScript, TypeScript, Bash/Shell, SQL} | \n", "{Azure} | \n", "{} | \n", "{Azure} | \n", "
3 | \n", "{PostgreSQL, Oracle, IBM Db2} | \n", "{} | \n", "{PostgreSQL, Oracle, IBM Db2, SQL Server} | \n", "{} | \n", "{} | \n", "{} | \n", "{C++, C, Matlab, Bash/Shell, SQL} | \n", "{Assembly} | \n", "{C++, R, C, Matlab, Java, Bash/Shell, SQL} | \n", "{Windows Desktop or Server, Arduino} | \n", "{} | \n", "{Windows Desktop or Server, Arduino} | \n", "
4 | \n", "{} | \n", "{PostgreSQL} | \n", "{MongoDB} | \n", "{Node.js} | \n", "{} | \n", "{Angular, Node.js} | \n", "{Python, HTML, CSS, JavaScript, Java, TypeScript} | \n", "{SQL, C#, Go} | \n", "{TypeScript, Python, HTML, CSS, JavaScript, Java} | \n", "{Linux} | \n", "{} | \n", "{Linux} | \n", "