Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditor Going Concern Reporting A Review Of Global Research And Future Research Opportunities

Authors: Marshall A. Geiger, Anna Gold, Philip Wallage

1st Edition

0367649489, 978-0367649487

More Books

Students also viewed these Accounting questions

Question

When should sketches be made instead of just recording data?

Answered: 1 week ago