I'm trying to fix a problem with Pandas but I can't find an example that matches my issue.
I got the following table, where members are assigned to different duty types over the course of a month:
I want to reshape it in a way, that it lists for every single member the duty type he is assigned to and the corresponding date, like:
How the reshaped table should look like
I just can't get my mind around it, how I can check in each of the duty columns. Could you help me?
I've tried stacking, unstacking and pivoting, but it never yielded the result I needed.
