title: Separating same ID value between location in data-set using Python
body: <p>I have a data-set that contains experimental data by location and alphanumeric ID. There are several different locations and several different ID's at each location. Each ID-location pair receives its own row in the csv. Not every location has every ID. There is a core set of ID's that can be found at every single location in the data-set that I am interested in locating. A simple list of the ID's found at each location would be perfect. There are ~20 different locations and ~1000 different ID's distributed across those locations with about 12,000 total experiments. A sample looks like:
  <a href="https://i.stack.imgur.com/8bfVx.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>Initially, I tried to create a pivot table of ID's by location that I could then determine a way to sort, but since the ID's are not numeric, this didn't seem to work. I then tried to create lists of every ID at each location. If I were successful in creating these lists, would there be a way to filter them to find the common ID's at every location? Or could there be a more straightforward method from the beginning? </p>