Anurag Lahon
3 min readApr 3, 2020

Analysis from Stack Overflow data

image taken from https://www.boulderweekly.com/

We have analyzed Stack Overflow users’ salary data and answered the following four questions regarding the users’ salary and different other features:

1. What is the average salary of particular Under Graduate Major and what is the average salary of particular Formal Education?

2. Which company size and company type have highest salary?

3. How many years of programming and formal education is highest average salary?

4. Which country have the highest average salary for Work Pay Care?

Preparing data:

  • Inspecting the data
  • Handle missing data and replacing them with forward and backward fill
  • Preparing the questions by inspecting the data set .

What is the average salary of particular Under Graduate Major and what is the average salary of particular Formal Education?

Under Graduate Major Avg Salary
Formal Education Avg Salary
image taken from USNews & World Report

From the results we can conclude that Psychology have the highest average salary among Majors in undergraduate and Doctoral degree have the highest average salary.

Which company size and company type have highest salary?

group by company size and company type
group by company type and company size
image taken from yahoo finance

From the results we can conclude that ‘Pre-series A startup’ have the highest average salary among company type.In Venture-funded startup , 5,000 to 9,999 employees have the highest average salary among company size.

How many years of programming and formal education is highest average salary?

group by years to program and formal education
image taken from gettingsmart.com

From the results we can conclude that 17–18 years with Professional degree have highest average salary.

Which country have the highest average salary for Work Pay Care?

group by country and work pay care
image taken from paychex.com

From the results we can conclude that In Puerto Rico have the highest average salary and they agree that they were give Work Pay care.

Anurag Lahon
Anurag Lahon

No responses yet