我正在嘗試在 excel 文件 (xls) 中使用搜索和替換字符串,實際上 - 我需要查找字符串并在前綴 * 之前添加。例如但我收到一個錯誤:LVdemact = {'two': two_replaced, 'six': six_replaced, 'five': five_replaced}NameError: name 'two_replaced' is not defined代碼:from xlrd import open_workbookfrom xlutils.copy import copyimport xlsxwriterrb = open_workbook("template.xlsx")# Create an new Excel file and add a worksheet.wb = xlsxwriter.Workbook('Updated_Workbook1.xlsx')ws = wb.add_worksheet()s_orig = rb.sheet_by_index(0)LVdemact = {'two': two_replaced, 'six': six_replaced, 'five': five_replaced,}for row in range(s_orig.nrows): for col in range(s_orig.ncols): if s_orig.cell(row,col).value in LVdemact: # s.write(row, col, LVdemact[item]) ws.write(row, col, LVdemact[s_orig.cell(row,col).value]) else: ws.write(row, col, s_orig.cell(row,col).value)wb.close()
2 回答

溫溫醬
TA貢獻1752條經驗 獲得超4個贊
問題在于 -LVdemact = {'two': two_replaced, 'six': six_replaced, 'five': five_replaced,}
變量two_replaced
,six_replaced
并且five_replaced
未定義。你想讓它成為一個字符串嗎?然后以這種方式定義它 -
LVdemact = {'two': 'two_replaced', 'six': 'six_replaced', 'five': 'five_replaced'}

慕桂英3389331
TA貢獻2036條經驗 獲得超8個贊
你可以用這個
df = pd.DataFrame() # Your dataframe
for column in df.select_dtypes('object'):
df[column] = df[column].str.replace('toreplace','newword')
添加回答
舉報
0/150
提交
取消