Question: To complete this assignment follow these steps: Start your Jupyter Notebooks server Open Jupyter Notebooks in a browser Download information about data positions and associated

To complete this assignment follow these steps:

  • Start your Jupyter Notebooks server
  • Open Jupyter Notebooks in a browser
  • Download information about data positions and associated salaries for several countries positions (Data_Position_Salary_Survey_Responses.csv) and upload the file to your VM.
  • Clean the SalaryUSD data
    • Create a method function called cleanData that takes in a salary value and removes all punctuation (commas, dollar signs, spaces etc.) and converts the value to an integer
    • Use a lambda expression and df.apply to clean the 'SalaryUSD' column of your dataframe.
  • Using the groupby, and plot methods on the pandas Dataframe libraries, to create graphs below. Ensure that all labels, titles, and numeric values match those given below.

Note: You can use the pyplot libraries in Matplotlib but should NOT use the following methods from the Matplotlib libraries (plot, scatter, bar, pie). Instead you should use the 'kind' parameter available in the pandas plot method (e.g., df.plot(kind='pie') )

Note: There are many ways to complete this assignment. You may want to research how to use some of the following pandas methods to parse and organize the data.

  • sort_values
  • tail, head
  • loc, iloc
  • isin

1. A line graph that shows changes in salaries for those working on major databases between 2017-2019

2. A bar chart that shows the average salaries for data positions for the top 10 countries

3. A pie chart showing the top 4 databases (excluding Oracle and Microsoft SQL Server) and what percent of positions recorded were using each for 2017-2019.Upload your Jupyter notebook to fulfill this assignment.

1/5/17 5:10

200,000.00

United States

Not Asked

Microsoft SQL Server

10

MySQL/MariaDB

Full time employee

DBA

1/5/17 5:26

61515

United Kingdom

Not Asked

Microsoft SQL Server

15

Oracle, PostgreSQL

Full time employee

DBA

1/5/17 5:32

95000

Germany

Not Asked

Microsoft SQL Server

5

Oracle, MySQL/MariaDB, Informix

Full time employee

Other

1/5/17 5:33

56000

United Kingdom

Not Asked

Microsoft SQL Server

6

Full time employee

DBA

1/5/17 5:34

35000

France

Not Asked

Microsoft SQL Server

10

Oracle

Full time employee of a consulting/contracting company

DBA

1/5/17 6:05

215000

United Kingdom

Not Asked

Microsoft SQL Server

15

Independent or freelancer or company owner

DBA

1/5/17 6:09

75000

Germany

Not Asked

Microsoft SQL Server

16

Oracle

Full time employee

DBA

1/5/17 6:34

47000

Netherlands

Not Asked

Microsoft SQL Server

4

Oracle

Full time employee

DBA

1/5/17 6:43

41000

United Kingdom

Not Asked

Microsoft SQL Server

3

MySQL/MariaDB, PostgreSQL, Amazon RDS (any flavor)

Full time employee

Developer: App code (C#, JS, etc)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!