Monarch Learning Series 2023 Exercise 10 Solution: National Stock Number Analysis


Exercise Info

Exercise Overview

You are a Budget Analyst at a Federal Agency and you want to analyze National Stock Number data to help prepare for budget season by answering the following questions:

  1. What is the Total Number of items grouped by "rep_office" for both Excel files?
  2. How many items exist on both Excel files?
  3. How many items don't exist on the both files? (ie, what items are on the 2-21-23 file, that are not on the 3-17-21 file, and vice versa)

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.