BYU Student Author: @Christian @Kaden_Sandberg
Reviewers: @Spencer, @Brett_Lowe, @Boston, @James_Behling, @Kylie_Larsen17
Estimated Time to Solve: 30 Minutes
We provide the solution to this challenge using:
Need a program? Click here.
Overview
Working as a financial analyst for NY Goliath, Inc., you are assigned an overnight project of getting 2 lists: 1) The 25 most common customers that are ordering from us and, 2) the top 10 employees that make the most sales. However, when you get the data, there is an error in converting the information you needed and, consequentially, each row of information has been combined into the same cell for the two master files! Thankfully, the transaction file generated correctly into separate columns. Your boss has requested you generate the customer list and the employee list under the names “Top25Customers” and “Top10Employees”, respectively.
Instructions
-
Load the data from the excel sheets “Sales_Order_Summary”, “Employees”, and “Customers” into their own dataframes. After creating these dataframes, parse the “Customers” and “Employees” dataframes with the appropriate information entered into each field.
-
After parsing the needed dataframes, Create 2 new dataframes with the following columns:
- Dataframe 1: Cust_Num, Comp_Name, First_Name, Last_Name, Phone_Number, Address, City, State, and NumOfSOs.
- Dataframe 2: EmpID, First_Name, Last_Name, Phone_Number, Job_Title, Department, and Numof SOs.
- After creating the two dataframes, find the Top 25 Customers by number (count) of Sales Orders and Top 10 Employees by number (count) of Sales Orders . Save each of these two findings to separate excel sheets titled “Top25Customers” and “Top10Employees”.
Data Files
Suggestions and Hints
Suggestion: Feel free to leverage GenAI in solving this challenge! Prompts such as “Please help me perform this task in python: [task]” or “explain this python code to me in simple terms: [python code]” can make a big difference!
Solution