Hi, This is currently my column definition : Employee ID Name Client Project Team 01/01/2022 02/01/2022 03/01/2022 04/01/2022 05/01/2022 12345 Dummy x Dummy a abc team a OFF WO WH WH WH
As you can see, the outer columns are just daily attendance dates. My goal is to count the employees who were OFF / WO / WH on said dates. I need to transpose them so it would look like this : [cid:ff6d0260-0168-40a4-82db-6c2acd517c39] I am still new to pandas. Can you guide me on how to produce this? I am reading about melt() and set_index() but I am not sure if they are the correct functions to use.
