我需要將調查結果轉換為可在 BI 工具（如 Tableau）中使用的內容。調查采用以下數據框的格式df = pd.DataFrame({'Respondent': ['Sally', 'Tony', 'Fred'],               'What project did you work on with - Chris?': ['Project A','Project B', np.nan],                'What score would you give - Chris': [9,7,np.nan],                'Any other feedback for - Chris': ['Random Comment','Okay performance',np.nan],               'What project did you work on with - Matt?': [np.nan,'Project C', 'Project X'],                'What score would you give - Matt': [np.nan,9,8],                'Any other feedback for - Matt': [np.nan, 'Great to work with Matt', 'Work was just okay'],               'What project did you work on with - Luke?': ['Project B','Project D', 'Project Y'],                'What score would you give - Luke': [10,8,7],                'Any other feedback for - Luke': ['Work was excellent', 'Was a bit technical', 'Another Random Comment'],              })我需要將其轉換為如下格式：df = pd.DataFrame({'Name': ['Chris','Chris','Matt','Matt','Luke','Luke','Luke'],               'Assessor': ['Sally','Tony','Tony','Fred','Sally','Tony','Fred'],                'Project Name': ['Project A', 'Project B', 'Project C', 'Project X', 'Project B', 'Project D', 'Project Y'],                'NPS Score': [9,7,9,8,10,8,7],               'Feedback': ['Random Comment','Okay performance','Great to work with Matt','Work was just okay','Work was excellent','Was a bit technical','Another Random Comment']              })如您所見，它需要能夠從列中提取名稱。實際數據實際上要大得多，所以我需要代碼來處理任何大小，而不僅僅是這個例子。