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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started