python - 用 Pandas 重命名excel中的特定列

Question

问题 : 有两个文件。一个是带有名称的文本文件，另一个是带有参与者列表的 excel 文件。 Excel 列表还包含出现在文本文件中的名称。在excel文件中有一个参数参与的列。我想为文本文件中的所有参与者在 excel 文件中的“参与”列中给出值"is"。

import pandas as pd

excelList = pd.read_excel("participantsList.xlsx", sheet_name="Table1")
participatedList = open('participated.txt','r')

#CODE TO CHANGE THE PARAMETER

excelList.to_excel(r'newList.xlsx')

File: participated.txt 
(The following names should get the value "Yes" in the excel file.)

participant one
participant two
participant three

File: participantsList.xlsx

First name  | Last Name | Participated
______________________________________
Magnus      | one       | 
Maverick    | two       |
Rhett       | three     |
Winston     | four      |
Xander      | five      |

Answer 1

这是我的尝试:

import pandas as pd
excelList = pd.read_excel("participantsList.xlsx", sheet_name="Table1")
#participatedList = open('participated.txt','r')
#CODE TO CHANGE THE PARAMETER
#excelList.to_excel(r'newList.xlsx')

data = pd.read_csv('participated.txt', sep=" ", header=None)
data.columns = ["First Name", "Last Name"]

newList = excelList.copy()

txt = 0
while txt < len(data):
    i = 0
    while i < len(excelList):
        if data['Last Name'][txt] == excelList['Last Name'][i]:
            newList.loc[i,'Participated'] = "Yes"
        i += 1
    txt += 1

newList.to_excel(r'newList.xlsx')

print(newList)