combine large datasets. Suppose you’re given two datasetsCompany Locations, with the columns Company ID and Location, andCompany Headcount, with the columns Company ID and Headcount.
Questions: If you want to create a single dataset with a companyID, location, and headcount, how would you do it? Assume for nowthat each company ID shows up in both tables. What tools would youuse? Depending on the tool, what function/syntax/query would youuse? Suppose Company Locations has company IDs that don’t appear inCompany Headcount. How would you create a single dataset with acompany ID, location, and headcount, but headcount is set to 0 forcompanies absent from the Company Headcount table? Suppose we havea table that stores Offer data with the following columns: Offer,Candidate, Recruiter, Application_Create_Date, Offer_Extend_Date.Questions: How would you calculate the average time from start tooffer to an extension? How would you calculate the number of offerseach recruiter extended? Suppose you have a second table with OfferID and Job Name. Using these two tables, how can you calculate thenumber of offers made under each job name in the last year?
combine large datasets. Suppose you’re given two datasets Company Locations, with the columns Company ID and Location, a
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
combine large datasets. Suppose you’re given two datasets Company Locations, with the columns Company ID and Location, a
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!