Imagine I have a table that looks like this.
How do I convert it into this?
Attached sample data. Thanks.
Asked
Active
Viewed 576 times
0
-
Something like `df.groupby('id').agg(['unique'])` – Henry Ecker Aug 31 '21 at 14:13
-
Or `df.groupby('id', as_index=False).agg({'name': 'first', 'fruit': 'unique', 'meat': 'unique'})` – Henry Ecker Aug 31 '21 at 14:14
-
Or if you want to exclude NaN/Missing values see [this answer](https://stackoverflow.com/a/46218844/15497888) – Henry Ecker Aug 31 '21 at 14:18