Combining Data in pandas With Merge Assignment

Assignment Task

Before diving into your data, it's always best to first explore the dataset to understand what you are working with.

1. Considering that you will be combining your two tables of data together at a later stage, how many rows of data are available for your analysis?

2. How are unknown values represented in the dataset?

3. What is the salary range covered by this dataset?

• $254,000
• $200,000
• $235,500
• $238,500

4. How many unique industries are covered by the dataset?

5. How many unique industries are covered by the dataset?

Consider the following point from your boss's email: In its current form, this question is ambiguous as it is unclear whether it is asking about the location where data scientists work or the industry in which they work. Think about how you could approach this question, how to best answer it, and how it could be phrased in data terms. Select the most correct option below.

1. What are locations and industries with the highest number (count) of data jobs?

2. What are the locations with the highest proportion (%) of data scientists relative to all data jobs?

3. What are the industries with the highest salary total (sum) for data scientists?

4. What are the locations and industries with the highest number (count) of data scientists?

5. What are the locations and industries with the highest salary total (sum) for data scientists?

Now you've explored your data and thought about how to define your questions, you can now transform the data to make it ready for analysis.

• In the job_salary table, the job title and job category are currently given together in the Job Title (Job Category) column, e.g: Healthcare Data Scientist (data scientist) .
• For further analysis, you will need to separate the job title and job category into separate columns (as shown in the image below).
• To create a dedicated column in your job_salary table, which of the following combinations of text manipulation functions could you use?
• Note: the X in the formulae below represents the unseparated Job Title (Job Category) column..
• Now create a dedicated Job Category column on your job_salary table and use text manipulation functions to split job category from the job title.
• Once you have done this, using your newly created job category column , answer the following to check that you have done this step correctly: 
• How many data scientist , data engineer, and data analyst jobs (in that given order) are there? 
• You will also need to join your two sheets of data together, the job_salary table and the company datasets.
• Which method(s) below could you use to join the datasets together? Select all correct answers.

Use your method of choice to join the datasets together.

1. Manually copy the data from one table and insert it below the other table

2. Use INDEX/MATCH

3. Transform the data in both sheets into Tables and then use Excel Power Query to append the tables together 

4. Transform the data in both sheets into Tables and then use Excel Power Query to merge Queries

5. There's no need to join the datasets together as you'll analyze each table separately

6. Use VLOOKUP.

This Statistics has been solved by our PHD Experts at My Uni Paper.