<article style="font-size: 16px;">
<div>
<section>
<div>
<div>
<p>Recently, I have started to be more interested in the data science aspect of my job, and I wanted to dig a bit deeper into the data that is backing recent trends. For this, I have looked at the StackOverflow survey data from 2017 to 2020, which can be found here <a href="https://insights.stackoverflow.com/survey">https://insights.stackoverflow.com/survey</a>.</p>
<p>最近,我开始对工作中的数据科学方面更加感兴趣,并且我想对支持最新趋势的数据进行更深入的研究。 为此,我查看了2017年至2020年的StackOverflow调查数据,可在以下<a href="https://insights.stackoverflow.com/survey">网址</a>找到<a href="https://insights.stackoverflow.com/survey">https://insights.stackoverflow.com/survey</a> 。</p>
<p>The data collected by StackOverflow is quite large, and the questions as well as their possible answers have changed from year to year.</p>
<p> StackOverflow收集的数据很大,而且问题及其可能的答案每年都在变化。</p>
<p>Starting in 2017, we have around 51K entries for the survey from all around the world, with most entries coming from the United States.</p>
<p> 从2017年开始,我们有来自世界各地的大约51,000项调查条目,其中大多数条目来自美国。</p>
<figure style="display:block;text-align:center;">
<div>
<div>
<div>
<div style="text-align: center;">
<img alt="Image for post" height="432" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-c723944a7fa5ef6708c7901777bcb4ad.png" style="outline: none;" width="700">
</div>
</div>
</div>
</div>
<figcaption>
Countries participating in the SO survey in 2017
</figcaption>
<figcaption>
参加2017年SO调查的国家
</figcaption>
</figure>
<p>Given that I am based in Europe, I was more interested to see how does this part of the world compares to the rest, so I have made most of the analysis by comparing European countries as a whole to the rest of the world.</p>
<p>鉴于我居住在欧洲,所以我更感兴趣的是看看世界上这部分地区与其他地区相比如何,因此我通过将欧洲国家整体与世界其他地区进行比较来进行大部分分析。</p>
<p>For simplicity, I have considered only countries that are part of the European Union plus the United Kingdom for this analysis. In 2017, there were 19K entries for this subset out of the total of 51K, and the UK is the top country participating in the survey.</p>
<p> 为简单起见,我只考虑了欧盟和英国组成部分中的国家进行此分析。 在2017年的51,000项总数中,有1.9万项属于该子集,英国是参与调查的国家中排名最高的国家。</p>
<figure style="display:block;text-align:center;">
<div>
<div>
<div>
<div style="text-align: center;">
<img alt="Image for post" height="1002" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-ae455139723261ba8b7d84e1ad7fa08a.png" style="outline: none;" width="486">
</div>
</div>
</div>
</div>
</figure>
</div>
</div>
</section>
<section>
<div>
<div>
<h1> 多年来,有哪些开发商类型对调查做出回应? <span style="font-weight: bold;">(</span>What are the developer types responding to the survey over the years?<span style="font-weight: bold;">)</span></h1>
<p>I wanted to see what are the job titles of the respondents to this survey. In 2017, this information is contained in the <code>DeveloperType</code> column and the survey gives the opportunity to include several functions in one row, like for example: <code>Web developer; Mobile developer; Desktop applications developer</code> . This data needs to be split so that we can get a real count of how many entries are available for each role. Any missing data will be dropped for this column as it does not bring any value in our analysis, so around 9K entries are removed.</p>
<p> 我想看看本次调查的受访者的职务是什么。 在2017年,此信息包含在<code>DeveloperType</code>列中,调查使您有机会在一行中包含多个功能,例如: <code>Web developer; Mobile developer; Desktop applications developer</code> <code>Web developer; Mobile developer; Desktop applications developer</code> <code>Web developer; Mobile developer; Desktop applications developer</code> 。 需要拆分这些数据,以便我们可以实际获得每个角色可用条目的数量。 此列将删除所有丢失的数据,因为它在我们的分析中没有带来任何价值,因此删除了大约9K条目。</p>
<figure style="display:block;text-align:center;">
<div>
<div>
<div>
<div>
<div style="text-align: center;">
<img alt="Image for post" height="1036" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-7ff2f367af1a525eaf8ac90f9a75f76e.png" style="outline: none;" width="766">
</div>
</div>
</div>
</div>
</div>
</figure>
</div>
</div>
<div>
<div>
<div>
<div>
<figure style="display:block;text-align:center;">
|
|