In my current situation I have a csv that contains many duplicate products however, the external ID is different on the duplicates. I want to take all the external Ids from the duplicate rows, store them in a new column and then drop the duplicates. 
ive tried intense while and if statements but they are always too ambiguous. Ive tried a reduce but cant get it on a specific group of my dataframe
